Used Cars Dataset

Car rides could be so exciting when you own it?

@kaggle.mrmars1010_cars_india_pre_owned

Table List

1 table(98.63 KB)

Pre Owned Cars

@kaggle.mrmars1010_cars_india_pre_owned.pre_owned_cars

98.63 KB
2806 rows
15 columns

brand Brand	model Model	transmission Transmission	make_year Make Year	reg_year Reg Year	fuel_type Fuel Type	engine_capacity_cc Engine Capacity(CC)	km_driven Km Driven	ownership Ownership	price Price	overall_cost Overall Cost	has_insurance Has Insurance	spare_key Spare Key	reg_number Reg Number	title Title
Mahindra	Thar LX D 4WD MT CONVERTIBLE	Manual	2020	01-01-2021	Diesel	2184	11003	1st owner	1231000	23431	True	No	HR26	2020 Mahindra Thar LX D 4WD MT CONVERTIBLE
Hyundai	Verna 1.6 VTVT SX	Manual	2018	01-07-2018	Petrol	1591	66936	1st owner	786000	15359	True	No	DL7C	2018 Hyundai Verna 1.6 VTVT SX
Tata	Harrier XT PLUS 2.0L KRYOTEC DARK EDITON	Manual	2022	01-08-2022	Diesel	1956	27990	1st owner	1489000	28349	True	No	HR29	2022 Tata Harrier XT PLUS 2.0L KRYOTEC DARK EDITON
Honda	City 1.5L I-VTE V CVT	Automatic	2023	01-04-2023	Petrol	1498	5061	1st owner	1227000	23355	True	Yes	DL4C	2023 Honda City 1.5L I-VTE V CVT
Ford	Ecosport TITANIUM 1.5L DIESEL	Manual	2021	01-07-2021	Diesel	1498	23480	1st owner	887000	16883	True	No	UP14	2021 Ford Ecosport TITANIUM 1.5L DIESEL
Honda	WR-V 1.2L I-VTEC VX MT	Manual	2021	01-10-2021	Petrol	1199	44787	1st owner	796000	15561	True	No	UP32	2021 Honda WR-V 1.2L I-VTEC VX MT
Tata	PUNCH CREATIVE 1.2 RTN DUAL TONE	Manual	2022	01-11-2022	Petrol	1199	450	1st owner	813000	15475	True	Yes	DL3C	2022 Tata PUNCH CREATIVE 1.2 RTN DUAL TONE
Tata	NEXON XMA DIESEL	Automatic	2020	01-02-2021	Diesel		59866	1st owner	728000	14228	True	No	DL5C	2020 Tata NEXON XMA DIESEL
Mahindra	XUV700 AX 7 LUXURY D AWD AT 7 STR	Automatic	2022	01-04-2022	Diesel	2184	62567	1st owner	2322000	44197	True	No	DL10	2022 Mahindra XUV700 AX 7 LUXURY D AWD AT 7 STR
Ford	Ecosport TITANIUM + 1.5L PETROL AT	Automatic	2019	01-07-2019	Petrol	1497	58503	1st owner	766000	14977	True	No	DL10	2019 Ford Ecosport TITANIUM + 1.5L PETROL AT


CREATE TABLE pre_owned_cars (
  "brand" VARCHAR,
  "model" VARCHAR,
  "transmission" VARCHAR,
  "make_year" DOUBLE,
  "reg_year" VARCHAR,
  "fuel_type" VARCHAR,
  "engine_capacity_cc" DOUBLE,
  "km_driven" DOUBLE,
  "ownership" VARCHAR,
  "price" BIGINT,
  "overall_cost" DOUBLE,
  "has_insurance" VARCHAR,
  "spare_key" VARCHAR,
  "reg_number" VARCHAR,
  "title" VARCHAR
);