Used-Car Data

Automoble Industry, Indian Used-Car Market

@kaggle.shubham1kumar_usedcar_data

Table List

1 table(170.87 KB)

Usercardata

@kaggle.shubham1kumar_usedcar_data.usercardata

170.87 KB
7906 rows
18 columns

sales_id Sales ID	name Name	year Year	selling_price Selling Price	km_driven Km Driven	region Region	state_or_province State Or Province	city City	fuel Fuel	seller_type Seller Type	transmission Transmission	owner Owner	mileage Mileage	engine Engine	max_power Max Power	torque Torque	seats Seats	sold Sold
1	Maruti	2014	450000	145500	East	District of Columbia	Washington	Diesel	Individual	Manual	First_Owner	23.4	1248	74	190Nm@ 2000rpm	5	Y
2	Skoda	2014	370000	120000	East	New York	New York City	Diesel	Individual	Manual	Second_Owner	21.14	1498	103.52	250Nm@ 1500-2500rpm	5	Y
3	Honda	2006	158000	140000	Central	Illinois	Chicago	Petrol	Individual	Manual	Third_Owner	17.7	1497	78	12.7@ 2,700(kgm@ rpm)	5	Y
4	Hyundai	2010	225000	127000	Central	Illinois	Chicago	Diesel	Individual	Manual	First_Owner	23	1396	90	22.4 kgm at 1750-2750rpm	5	Y
5	Maruti	2007	130000	120000	East	New York	New York City	Petrol	Individual	Manual	First_Owner	16.1	1298	88.2	11.5@ 4,500(kgm@ rpm)	5	Y
6	Hyundai	2017	440000	45000	East	New York	New York City	Petrol	Individual	Manual	First_Owner	20.14	1197	81.86	113.75nm@ 4000rpm	5	Y
7	Maruti	2007	96000	175000	West	California	Los Angeles	LPG	Individual	Manual	First_Owner	17.3	1061	57.5	7.8@ 4,500(kgm@ rpm)	5	Y
8	Maruti	2001	45000	5000	West	California	Los Angeles	Petrol	Individual	Manual	Second_Owner	16.1	796	37	59Nm@ 2500rpm	4	Y
9	Toyota	2011	350000	90000	West	California	Los Angeles	Diesel	Individual	Manual	First_Owner	23.59	1364	67.1	170Nm@ 1800-2400rpm	5	Y
10	Ford	2013	200000	169000	Central	Texas	Houston	Diesel	Individual	Manual	First_Owner	20	1399	68.1	160Nm@ 2000rpm	5	Y


CREATE TABLE usercardata (
  "sales_id" BIGINT,
  "name" VARCHAR,
  "year" BIGINT,
  "selling_price" BIGINT,
  "km_driven" BIGINT,
  "region" VARCHAR,
  "state_or_province" VARCHAR,
  "city" VARCHAR,
  "fuel" VARCHAR,
  "seller_type" VARCHAR,
  "transmission" VARCHAR,
  "owner" VARCHAR,
  "mileage" DOUBLE,
  "engine" BIGINT,
  "max_power" DOUBLE,
  "torque" VARCHAR,
  "seats" BIGINT,
  "sold" VARCHAR
);