GoKawiilTwice this week, I have come across embarassingly bad data.
The first instance is the UK government’s fuel finder data. This is a downloadable CSV file of fuel station locations and prices from around the UK. A potentially very useful database, especially during the current conflict in the Middle East. A customer suggested it as a possible practice dataset for my data wrangling and visualization software, Easy Data Transform . So I had a quick look and spotted some glaring errors within a few minutes.
A quick plot of the latitude and longitude shows some clear outliers:
On further investigation, some of these UK fuel stations are apparently located in the Indian and South Atlantic oceans. In at least one case, it looks like they got the latitude and longitude the wrong way around.
A quick look at the fuel price columns also shows some major issues:
The ratio between the most expensive and cheapest fuel (per litre) is 1538:1. Clearly wrong.
Shown as a histogram with a logarithmic Y axis:
I am guessing that the reason for this bad data is that the fuel stations are submitting their own data and, humans being humans, they make mistakes. But then the government is publishing the data without even the most basic checks. That just isn’t good enough.
I reported the problem on 22-Mar-2026. They acknowledge my email on 24-Mar-2026 (“Thank you for sharing this, we have passed this on to the technical team to have a look at.”). The CSV file published on 29-Mar-2026 still has the garbage data.
The second instance is a report on electric cars from UK motoring organization, the RAC. The first graph in the article is this:
... continue reading