About Services Tools Blog Contact us

Forecourt Fuel Prices

Turns a national forecourt price file into averages, cheapest and dearest sites, and a price map for unleaded and diesel.

  • Reporting Dashboards
  • Motor fuel retail
  • Dashboard feature
  • Productised
  • Local/private
  • 2026

The problem

The raw price file is too large to read, so supermarket gaps, motorway premiums and out-of-date prices stay hidden. Rows with impossible pence figures also pull the averages off. And a table of every site does not show where the cheap fuel is.

What it does

The file is read in pieces, and pump prices outside a sensible range are dropped. The page counts sites, closures, motorway, supermarket and all-night sites, then averages each grade. It splits unleaded by brand group, country, supermarket against other, and motorway against other. An interactive map colours each site from cheap to dear.

Outcomes

  • The supermarket saving and the motorway premium show as figures on the page.
  • Bad rows no longer move the average.
  • The age of the prices is shown, so stale sites are visible.
  • A marker on the map shows a site and its pence per litre.

Simplified mockup

Interactive preview with sample data. Nothing is sent to a server.

Forecourt report

Submitted yesterday
national_forecourts.csv · 8,420 rows · band 90p to 250p · 37 bad rows already dropped
Open sites
7,964
419 closed
Motorway
286
Premium sites
Supermarket
1,482
Two groups
All-night
1,104
Fuel 24 hours
Supermarket saving vs other
6.5p
132.1p vs 138.6p · £3.25 on 50 litres
Motorway premium vs other
+23.7p
158.9p vs 135.2p · £11.85 on 50 litres
Grade averages pence per litre
GradeAverageCheapestDearest
Unleaded136.4129.9168.2
Super unleaded151.2142.0179.9
Diesel144.8136.1176.4
Freshness Yesterday
Under 24 hours71%
1 to 3 days18%
Older than 3 days11%

Unleaded splits

Pence per litre
Pence above 125p unleaded
Brand groups
GroupKindSitesUnleadedDiesel
Harbour RetailSupermarket640131.4139.8
Field & FareSupermarket410132.8141.2
NorthwayMajor1,120137.9146.2
KilnMajor980138.4147.0
LanternMajor540139.1147.6
IndependentsOther3,860140.6148.9

Price map

Cheap Typical Dear
Unleaded clusters hover a marker
11 18 27 9 14 6 48

Schematic clusters coloured cheap to dear. Not a street map.

Marker Submitted yesterday
Site
Harbour Retail
Sittingbourne
Unleaded
129.9p
Diesel
138.4p
Supermarket 48 sites in this cluster
Cheapest and dearest unleaded
SitePence
Harbour Retail, Sittingbourne129.9
Harbour Retail, Kendal130.4
Northway, Derby139.6
Ridgeway Services, Maidstone161.9

How it works

  1. Read the forecourt file in pieces and drop prices outside the sensible range.
  2. Count sites, closures, motorway, supermarket and all-night sites.
  3. Average each grade.
  4. Split unleaded by supermarket against other, and motorway against other.
  5. Group prices by age, using the time each price was submitted.
  6. Colour the map clusters from cheap to dear.

Pipeline

flowchart LR
  File["Price file"] --> Clean["Drop bad rows"]
  Clean --> Avg["Grade averages"]
  Clean --> Split["Supermarket and motorway"]
  Clean --> Fresh["Freshness"]
  Avg --> Map["Price map"]
  Split --> Tiles["KPI tiles"]