17,966 real market listings from the United Kingdom with comprehensive vehicle attributes
The dataset is the Ford Used Car Dataset from Kaggle, containing listings of used Ford vehicles sold in the United Kingdom. This represents real market data from actual transactions, making it ideal for building a production-ready pricing model.
The dataset includes Ford vehicle listings from multiple years, with registration years ranging from 1996 to 2020 (with some data quality outliers at 2060).
9 features covering vehicle specifications, condition, and market attributes
Type: Categorical
Description: Ford model name (Fiesta, Focus, Kuga, Mustang, Ranger, etc.)
Examples: Fiesta, Focus, Kuga, Mustang, EcoSport, C-Max
Impact: Strong price driver — Mustang commands premium, Ka is budget
Type: Integer
Description: Year of manufacture / registration
Range: 1996 – 2060 (outliers present)
Impact: Strongest positive correlation with price — newer = more expensive
Type: Integer
Description: TARGET VARIABLE — Resale price in British Pounds (GBP)
Range: £495 – £54,995
Distribution: Right-skewed (mean £12,280, median £11,291)
Type: Categorical
Description: Gearbox type
Values: Manual, Automatic, Semi-Auto
Impact: Automatic and Semi-Auto command premium over Manual
Type: Integer
Description: Odometer reading in miles
Range: 1 – 177,644 miles
Impact: Strong negative correlation — higher mileage reduces price
Type: Categorical
Description: Fuel category
Values: Petrol, Diesel, Hybrid, Electric, Other
Impact: Hybrid and Electric vehicles are premium-priced
Type: Integer
Description: Annual road tax in GBP
Range: £0 – £580
Impact: Low positive correlation with price
Type: Float
Description: Fuel efficiency in miles per gallon
Range: 20.8 – 201.8 mpg (outliers present)
Impact: Weak negative correlation — efficient cars tend to be cheaper models
Type: Float
Description: Engine displacement in litres
Range: 0.0 – 5.0 litres
Impact: Moderate positive correlation — larger engines = higher prices
| Feature | Mean | Median | Std Dev | Min | Max |
|---|---|---|---|---|---|
| price (GBP) | £12,280 | £11,291 | £4,741 | £495 | £54,995 |
| year | 2017 | 2017 | 2.1 | 1996 | 2060 |
| mileage | 23,363 | 18,243 | 19,472 | 1 | 177,644 |
| tax (GBP) | £113 | £145 | £62 | £0 | £580 |
| mpg | 57.9 | 58.9 | 10.1 | 20.8 | 201.8 |
| engineSize (L) | 1.35 | 1.2 | 0.43 | 0.0 | 5.0 |
| Issue | Status | Recommendation |
|---|---|---|
| Missing values | 0 found | No action needed ✓ |
| Duplicate rows | 154 found | Review and remove in production |
| Year = 2060 | Present | Likely data entry error |
| MPG > 150 | Present | Physically implausible outlier |
| Engine size = 0 | Present | Possible data error |
| Price < £500 | Present | Review for listing errors |
All records are retained in this project to preserve the original pipeline and demonstrate real-world data challenges. In a production environment, anomalous records should be cleaned or filtered before training to improve model accuracy.
Interactive table showing the first 100 records
Loading dataset...