Resell Car Cleaned
Resell Car data preprocessed and cleaned.
@kaggle.vaibhavsharma47_car_cleaned
Car Extended
@kaggle.vaibhavsharma47_car_cleaned.car_extended
- 133.17 KB
- 8128 rows
- 13 columns
nameName | yearYear | selling_priceSelling Price | km_drivenKm Driven | fuelFuel | seller_typeSeller Type | transmissionTransmission | ownerOwner | mileageMileage | engineEngine | max_powerMax Power | torqueTorque | seatsSeats |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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
);