Name: 100,000 UK Used Car Data Set
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

100,000 UK Used Car Data Set

If you download/use the data set I'd appreciate an up vote, cheers.

Updated

Scraped data of used cars listings. 100,000 listings, which have been separated into files corresponding to each car manufacturer. I collected the data to make a tool to predict how much my friend should sell his old car for compared to other stuff on the market, and then just extended the data set. Then made a more general car value regression model.

previous version

Picked two fairly common cars on the British market for analysis (Ford Focus and Mercedes C Class). The hope is to find info such as: when is the ideal time to sell certain cars (i.e. at what age and mileage are there significant drops in resale value). Also can make comparisons between the two, and make a classifier for a ford or Mercedes car. Can easily add more makes and models, so comment for any request e.g. if you want a big data set of all Mercedes makes and models.

Content

The cleaned data set contains information of price, transmission, mileage, fuel type, road tax, miles per gallon (mpg), and engine size. I've removed duplicate listings and cleaned the columns, but have included a notebook showing the process and the original data for anyone who wants to check/improve my work.

Inspiration

It'd be cool to have some insights and visualisations of the data. Also, am open to ideas on how to expand the data set.

Tables

Audi

@kaggle.adityadesai13_used_car_dataset_ford_and_mercedes.audi

130.19 kB
10,668 rows
9 columns

CREATE TABLE audi (
  "model" VARCHAR,
  "year" BIGINT,
  "price" BIGINT,
  "transmission" VARCHAR,
  "mileage" BIGINT,
  "fueltype" VARCHAR,
  "tax" BIGINT,
  "mpg" DOUBLE,
  "enginesize" DOUBLE
);

Bmw

@kaggle.adityadesai13_used_car_dataset_ford_and_mercedes.bmw

133.1 kB
10,781 rows
9 columns

CREATE TABLE bmw (
  "model" VARCHAR,
  "year" BIGINT,
  "price" BIGINT,
  "transmission" VARCHAR,
  "mileage" BIGINT,
  "fueltype" VARCHAR,
  "tax" BIGINT,
  "mpg" DOUBLE,
  "enginesize" DOUBLE
);

Cclass

@kaggle.adityadesai13_used_car_dataset_ford_and_mercedes.cclass

44.86 kB
3,899 rows
7 columns

CREATE TABLE cclass (
  "model" VARCHAR,
  "year" BIGINT,
  "price" BIGINT,
  "transmission" VARCHAR,
  "mileage" BIGINT,
  "fueltype" VARCHAR,
  "enginesize" DOUBLE
);

Focus

@kaggle.adityadesai13_used_car_dataset_ford_and_mercedes.focus

55.26 kB
5,454 rows
7 columns

CREATE TABLE focus (
  "model" VARCHAR,
  "year" BIGINT,
  "price" BIGINT,
  "transmission" VARCHAR,
  "mileage" BIGINT,
  "fueltype" VARCHAR,
  "enginesize" DOUBLE
);

Ford

@kaggle.adityadesai13_used_car_dataset_ford_and_mercedes.ford

206.06 kB
17,965 rows
9 columns

CREATE TABLE ford (
  "model" VARCHAR,
  "year" BIGINT,
  "price" BIGINT,
  "transmission" VARCHAR,
  "mileage" BIGINT,
  "fueltype" VARCHAR,
  "tax" BIGINT,
  "mpg" DOUBLE,
  "enginesize" DOUBLE
);

Hyundi

@kaggle.adityadesai13_used_car_dataset_ford_and_mercedes.hyundi

62.87 kB
4,860 rows
9 columns

CREATE TABLE hyundi (
  "model" VARCHAR,
  "year" BIGINT,
  "price" BIGINT,
  "transmission" VARCHAR,
  "mileage" BIGINT,
  "fueltype" VARCHAR,
  "tax" BIGINT  -- Tax(£),
  "mpg" DOUBLE,
  "enginesize" DOUBLE
);

Merc

@kaggle.adityadesai13_used_car_dataset_ford_and_mercedes.merc

162.36 kB
13,119 rows
9 columns

CREATE TABLE merc (
  "model" VARCHAR,
  "year" BIGINT,
  "price" BIGINT,
  "transmission" VARCHAR,
  "mileage" BIGINT,
  "fueltype" VARCHAR,
  "tax" BIGINT,
  "mpg" DOUBLE,
  "enginesize" DOUBLE
);

Skoda

@kaggle.adityadesai13_used_car_dataset_ford_and_mercedes.skoda

77.29 kB
6,267 rows
9 columns

CREATE TABLE skoda (
  "model" VARCHAR,
  "year" BIGINT,
  "price" BIGINT,
  "transmission" VARCHAR,
  "mileage" BIGINT,
  "fueltype" VARCHAR,
  "tax" BIGINT,
  "mpg" DOUBLE,
  "enginesize" DOUBLE
);

Toyota

@kaggle.adityadesai13_used_car_dataset_ford_and_mercedes.toyota

80.91 kB
6,738 rows
9 columns

CREATE TABLE toyota (
  "model" VARCHAR,
  "year" BIGINT,
  "price" BIGINT,
  "transmission" VARCHAR,
  "mileage" BIGINT,
  "fueltype" VARCHAR,
  "tax" BIGINT,
  "mpg" DOUBLE,
  "enginesize" DOUBLE
);

Unclean Cclass

@kaggle.adityadesai13_used_car_dataset_ford_and_mercedes.unclean_cclass

90.85 kB
4,006 rows
11 columns

CREATE TABLE unclean_cclass (
  "model" VARCHAR,
  "year" DOUBLE,
  "price" VARCHAR,
  "transmission" VARCHAR,
  "mileage" VARCHAR,
  "fuel_type" VARCHAR,
  "engine_size" VARCHAR,
  "mileage2" VARCHAR,
  "fuel_type2" VARCHAR,
  "engine_size2" VARCHAR,
  "reference" VARCHAR
);

Unclean Focus

@kaggle.adityadesai13_used_car_dataset_ford_and_mercedes.unclean_focus

120 kB
5,604 rows
11 columns

CREATE TABLE unclean_focus (
  "model" VARCHAR,
  "year" DOUBLE,
  "price" VARCHAR,
  "transmission" VARCHAR,
  "mileage" VARCHAR,
  "fuel_type" VARCHAR,
  "engine_size" VARCHAR,
  "mileage2" DOUBLE,
  "fuel_type2" VARCHAR,
  "engine_size2" VARCHAR,
  "reference" VARCHAR
);

Vauxhall

@kaggle.adityadesai13_used_car_dataset_ford_and_mercedes.vauxhall

146.6 kB
13,632 rows
9 columns

CREATE TABLE vauxhall (
  "model" VARCHAR,
  "year" BIGINT,
  "price" BIGINT,
  "transmission" VARCHAR,
  "mileage" BIGINT,
  "fueltype" VARCHAR,
  "tax" BIGINT,
  "mpg" DOUBLE,
  "enginesize" DOUBLE
);

Vw

@kaggle.adityadesai13_used_car_dataset_ford_and_mercedes.vw

163.73 kB
15,157 rows
9 columns

CREATE TABLE vw (
  "model" VARCHAR,
  "year" BIGINT,
  "price" BIGINT,
  "transmission" VARCHAR,
  "mileage" BIGINT,
  "fueltype" VARCHAR,
  "tax" BIGINT,
  "mpg" DOUBLE,
  "enginesize" DOUBLE
);