Auto Real-world

dataset provides comprehensive details on used car listings.

@kaggle.willianoliveiragibin_auto_real_world

Table List

1 table(567.81 KB)

Final Scout Not Dummy New

@kaggle.willianoliveiragibin_auto_real_world.final_scout_not_dummy_new

567.81 KB
15915 rows
16 columns

make_model Make Model	body_type Body Type	price Price	vat Vat	km Km	type Type	fuel Fuel	gears Gears	comfort_convenience Comfort Convenience	entertainment_media Entertainment Media	extras Extras	safety_security Safety Security	age Age	previous_owners Previous Owners	hp_kw Hp KW	inspection_new Inspection New
Audi A1	Sedans	15770	VAT deductible	56013.0	Used	Diesel	7	Air conditioning,Armrest,Automatic climate control,Cruise control,Electrical side mirrors,Hill Holder,Leather steering wheel,Light sensor,Multi-function steering wheel,Navigation system,Park Distance Control,Parking assist system sensors rear,Power windows,Rain sensor,Seat heating,Start-stop system	Bluetooth,Hands-free equipment,On-board computer,Radio	Alloy wheels,Catalytic Converter,Voice Control	ABS,Central door lock,Daytime running lights,Driver-side airbag,Electronic stability control,Fog lights,Immobilizer,Isofix,Passenger-side airbag,Power steering,Side airbag,Tire pressure monitoring system,Traction control,Xenon headlights	3	2	66	1
Audi A1	Sedans	14500	Price negotiable	80000.0	Used	Benzine	7	Air conditioning,Automatic climate control,Hill Holder,Leather steering wheel,Lumbar support,Parking assist system sensors rear,Power windows,Start-stop system,Tinted windows	Bluetooth,Hands-free equipment,On-board computer,Radio,Sound system	Alloy wheels,Sport seats,Sport suspension,Voice Control	ABS,Central door lock,Central door lock with remote control,Daytime running lights,Driver-side airbag,Electronic stability control,Head airbag,Immobilizer,Isofix,Passenger-side airbag,Power steering,Side airbag,Tire pressure monitoring system,Traction control,Xenon headlights	2	1	141
Audi A1	Sedans	14640	VAT deductible	83450.0	Used	Diesel	7	Air conditioning,Cruise control,Electrical side mirrors,Hill Holder,Leather steering wheel,Multi-function steering wheel,Navigation system,Park Distance Control,Parking assist system sensors front,Parking assist system sensors rear,Power windows,Seat heating,Start-stop system	MP3,On-board computer	Alloy wheels,Voice Control	ABS,Central door lock,Daytime running lights,Driver-side airbag,Electronic stability control,Immobilizer,Isofix,Passenger-side airbag,Power steering,Side airbag,Tire pressure monitoring system,Traction control	3	1	85
Audi A1	Sedans	14500	VAT deductible	73000.0	Used	Diesel	6	Air suspension,Armrest,Auxiliary heating,Electrical side mirrors,Heads-up display,Hill Holder,Leather steering wheel,Light sensor,Lumbar support,Multi-function steering wheel,Navigation system,Power windows,Rain sensor,Seat heating,Split rear seats,Start-stop system	Bluetooth,CD player,Hands-free equipment,MP3,On-board computer,Radio,Sound system,USB	Alloy wheels,Sport seats,Voice Control	ABS,Alarm system,Central door lock with remote control,Driver drowsiness detection,Driver-side airbag,Electronic stability control,Emergency system,Head airbag,Immobilizer,Isofix,Passenger-side airbag,Power steering,Side airbag,Tire pressure monitoring system	3	1	66
Audi A1	Sedans	16790	VAT deductible	16200.0	Used	Diesel	7	Air conditioning,Armrest,Automatic climate control,Electrical side mirrors,Hill Holder,Leather steering wheel,Light sensor,Multi-function steering wheel,Park Distance Control,Parking assist system sensors rear,Power windows,Rain sensor,Start-stop system	Bluetooth,CD player,Hands-free equipment,MP3,On-board computer,Radio,USB	Alloy wheels,Sport package,Sport suspension,Voice Control	ABS,Central door lock,Driver-side airbag,Electronic stability control,Fog lights,Immobilizer,Isofix,Passenger-side airbag,Power steering,Side airbag,Tire pressure monitoring system,Traction control,Xenon headlights	3	1	66	1
Audi A1	Sedans	15090	VAT deductible	63668.0	Used	Diesel	7	Air conditioning,Armrest,Automatic climate control,Electrical side mirrors,Hill Holder,Keyless central door lock,Leather steering wheel,Light sensor,Lumbar support,Multi-function steering wheel,Navigation system,Park Distance Control,Parking assist system sensors rear,Power windows,Rain sensor,Seat …	Bluetooth,Hands-free equipment,On-board computer,Radio,Sound system,USB	Alloy wheels,Sport package,Sport seats,Sport suspension	ABS,Central door lock,Daytime running lights,Driver-side airbag,Electronic stability control,Fog lights,Immobilizer,Isofix,Passenger-side airbag,Power steering,Side airbag,Tire pressure monitoring system,Traction control,Xenon headlights	3	1	85
Audi A1	Station wagon	16422	VAT deductible	62111.0	Used	Diesel	7	Air conditioning,Armrest,Automatic climate control,Cruise control,Electrical side mirrors,Leather steering wheel,Light sensor,Multi-function steering wheel,Navigation system,Park Distance Control,Parking assist system sensors front,Parking assist system sensors rear,Power windows,Rain sensor,Start-s…	Bluetooth,CD player,Hands-free equipment,On-board computer,Radio,Sound system,USB	Alloy wheels,Sport package,Sport seats,Sport suspension	ABS,Central door lock,Daytime running lights,Driver-side airbag,Electronic stability control,Fog lights,Immobilizer,Isofix,Passenger-side airbag,Power steering,Side airbag,Tire pressure monitoring system,Xenon headlights	3	1	85	1
Audi A1	Compact	14480	VAT deductible	14986.0	Used	Diesel	7	Air conditioning,Armrest,Electrical side mirrors,Light sensor,Park Distance Control,Parking assist system sensors rear,Power windows,Rain sensor,Seat heating,Start-stop system	CD player,MP3,Radio	Alloy wheels	ABS,Central door lock,Daytime running lights,Driver-side airbag,Electronic stability control,Immobilizer,Isofix,Passenger-side airbag,Power steering,Side airbag,Tire pressure monitoring system,Traction control	3	1	66	1
Audi A1	Sedans	16700	VAT deductible	57000.0	Used	Diesel	7	Air conditioning,Power windows	Radio	Alloy wheels	ABS,Central door lock,Driver-side airbag,Electronic stability control,Immobilizer,Passenger-side airbag,Power steering,Side airbag,Traction control	3	1	85
Audi A1	Sedans	17990	VAT deductible	16103.0	Used	Benzine	7	Air conditioning,Armrest,Automatic climate control,Cruise control,Electrical side mirrors,Leather steering wheel,Light sensor,Lumbar support,Multi-function steering wheel,Navigation system,Park Distance Control,Parking assist system sensors front,Parking assist system sensors rear,Power windows,Rain…	Radio	Alloy wheels	ABS,Central door lock,Daytime running lights,Driver-side airbag,Electronic stability control,Fog lights,Immobilizer,Isofix,Passenger-side airbag,Power steering,Side airbag,Tire pressure monitoring system,Traction control,Xenon headlights	2	1	70


CREATE TABLE final_scout_not_dummy_new (
  "make_model" VARCHAR,
  "body_type" VARCHAR,
  "price" BIGINT,
  "vat" VARCHAR,
  "km" VARCHAR,
  "type" VARCHAR,
  "fuel" VARCHAR,
  "gears" DOUBLE,
  "comfort_convenience" VARCHAR,
  "entertainment_media" VARCHAR,
  "extras" VARCHAR,
  "safety_security" VARCHAR,
  "age" DOUBLE,
  "previous_owners" DOUBLE,
  "hp_kw" DOUBLE,
  "inspection_new" BIGINT
);