100,000 UK Used Car Data Set

100,000 scraped used car listings, cleaned and split into car make.

@kaggle.adityadesai13_used_car_dataset_ford_and_mercedes

Table List

13 tables(1.41 MB)

Audi

Bmw

Cclass

Focus

Ford

Hyundi

Merc

Skoda

Toyota

Unclean Cclass

Unclean Focus

Vauxhall

Audi

@kaggle.adityadesai13_used_car_dataset_ford_and_mercedes.audi

127.14 KB
10668 rows
9 columns

model Model	year Year	price Price	transmission Transmission	mileage Mileage	fueltype FuelType	tax Tax	mpg Mpg	enginesize EngineSize
A1	2017	12500	Manual	15735	Petrol	150	55.4	1.4
A6	2016	16500	Automatic	36203	Diesel	20	64.2	2
A1	2016	11000	Manual	29946	Petrol	30	55.4	1.4
A4	2017	16800	Automatic	25952	Diesel	145	67.3	2
A3	2019	17300	Manual	1998	Petrol	145	49.6	1
A1	2016	13900	Automatic	32260	Petrol	30	58.9	1.4
A6	2016	13250	Automatic	76788	Diesel	30	61.4	2
A4	2016	11750	Manual	75185	Diesel	20	70.6	2
A3	2015	10200	Manual	46112	Petrol	20	60.1	1.4
A1	2016	12000	Manual	22451	Petrol	30	55.4	1.4


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