Resell Car Cleaned

Resell Car data preprocessed and cleaned.

@kaggle.vaibhavsharma47_car_cleaned

Table List

2 tables(253 KB)

Car Extended

@kaggle.vaibhavsharma47_car_cleaned.car_extended

133.17 KB
8128 rows
13 columns

name Name	year Year	selling_price Selling Price	km_driven Km Driven	fuel Fuel	seller_type Seller Type	transmission Transmission	owner Owner	mileage Mileage	engine Engine	max_power Max Power	torque Torque	seats Seats
Maruti Swift Dzire VDI	2014	450000	145500	Diesel	Individual	Manual	First Owner	23.4 kmpl	1248 CC	74 bhp	190Nm@ 2000rpm	5
Skoda Rapid 1.5 TDI Ambition	2014	370000	120000	Diesel	Individual	Manual	Second Owner	21.14 kmpl	1498 CC	103.52 bhp	250Nm@ 1500-2500rpm	5
Honda City 2017-2020 EXi	2006	158000	140000	Petrol	Individual	Manual	Third Owner	17.7 kmpl	1497 CC	78 bhp	12.7@ 2,700(kgm@ rpm)	5
Hyundai i20 Sportz Diesel	2010	225000	127000	Diesel	Individual	Manual	First Owner	23.0 kmpl	1396 CC	90 bhp	22.4 kgm at 1750-2750rpm	5
Maruti Swift VXI BSIII	2007	130000	120000	Petrol	Individual	Manual	First Owner	16.1 kmpl	1298 CC	88.2 bhp	11.5@ 4,500(kgm@ rpm)	5
Hyundai Xcent 1.2 VTVT E Plus	2017	440000	45000	Petrol	Individual	Manual	First Owner	20.14 kmpl	1197 CC	81.86 bhp	113.75nm@ 4000rpm	5
Maruti Wagon R LXI DUO BSIII	2007	96000	175000	LPG	Individual	Manual	First Owner	17.3 km/kg	1061 CC	57.5 bhp	7.8@ 4,500(kgm@ rpm)	5
Maruti 800 DX BSII	2001	45000	5000	Petrol	Individual	Manual	Second Owner	16.1 kmpl	796 CC	37 bhp	59Nm@ 2500rpm	4
Toyota Etios VXD	2011	350000	90000	Diesel	Individual	Manual	First Owner	23.59 kmpl	1364 CC	67.1 bhp	170Nm@ 1800-2400rpm	5
Ford Figo Diesel Celebration Edition	2013	200000	169000	Diesel	Individual	Manual	First Owner	20.0 kmpl	1399 CC	68.1 bhp	160Nm@ 2000rpm	5


CREATE TABLE car_extended (
  "name" VARCHAR,
  "year" BIGINT,
  "selling_price" BIGINT,
  "km_driven" BIGINT,
  "fuel" VARCHAR,
  "seller_type" VARCHAR,
  "transmission" VARCHAR,
  "owner" VARCHAR,
  "mileage" VARCHAR,
  "engine" VARCHAR,
  "max_power" VARCHAR,
  "torque" VARCHAR,
  "seats" DOUBLE
);