BMW Pricing Challenge

Predict the value of a used car

@kaggle.danielkyrka_bmw_pricing_challenge

Table List

1 table(72.56 KB)

Bmw Pricing Challenge

@kaggle.danielkyrka_bmw_pricing_challenge.bmw_pricing_challenge

72.56 KB
4843 rows
18 columns

maker_key Maker Key	model_key Model Key	mileage Mileage	engine_power Engine Power	registration_date Registration Date	fuel Fuel	paint_color Paint Color	car_type Car Type	feature_1 Feature 1	feature_2 Feature 2	feature_5 Feature 5	feature_6 Feature 6	feature_7 Feature 7	feature_8 Feature 8	price Price	sold_at Sold At
BMW	118	140411	100	Wed Feb 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	diesel	black	convertible	true	true	true	true	true		11300	Mon Jan 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)
BMW	M4	13929	317	Fri Apr 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	petrol	grey	convertible	true	true		true	true	true	69700	Thu Feb 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)
BMW	320	183297	120	Sun Apr 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	diesel	white	convertible			true		true		10200	Thu Feb 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)
BMW	420	128035	135	Tue Jul 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	diesel	red	convertible	true	true	true	true	true	true	25100	Thu Feb 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)
BMW	425	97097	160	Mon Dec 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	diesel	silver	convertible	true	true		true	true	true	33400	Sun Apr 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)
BMW	335	152352	225	Sun May 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	petrol	black	convertible	true	true	true	true	true	true	17100	Thu Feb 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)
BMW	325	205219	145	Fri May 01 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	diesel	grey	convertible	true	true	true	true	true	true	12400	Thu Feb 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)
BMW	118	115560	105	Sat Aug 01 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	petrol	white	convertible	true	true		true	true		6100	Thu Feb 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)
BMW	Z4	123886	125	Thu Jul 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	petrol	black	convertible	true			true	true		6200	Thu Mar 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)
BMW	320	139541	135	Sat Jun 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	diesel	white	convertible			true		true		17300	Thu Mar 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)


CREATE TABLE bmw_pricing_challenge (
  "maker_key" VARCHAR,
  "model_key" VARCHAR,
  "mileage" BIGINT,
  "engine_power" BIGINT,
  "registration_date" TIMESTAMP,
  "fuel" VARCHAR,
  "paint_color" VARCHAR,
  "car_type" VARCHAR,
  "feature_1" BOOLEAN,
  "feature_2" BOOLEAN,
  "feature_3" BOOLEAN,
  "feature_4" BOOLEAN,
  "feature_5" BOOLEAN,
  "feature_6" BOOLEAN,
  "feature_7" BOOLEAN,
  "feature_8" BOOLEAN,
  "price" BIGINT,
  "sold_at" TIMESTAMP
);