1985 Automobile Dataset

1985 Auto Imports Database

@kaggle.fazilbtopal_auto85

Table List

2 tables(50.48 KB)

Auto Clean

@kaggle.fazilbtopal_auto85.auto_clean

27.31 KB
201 rows
29 columns

symboling Symboling	normalized_losses Normalized-losses	make Make	aspiration Aspiration	num_of_doors Num-of-doors	body_style Body-style	drive_wheels Drive-wheels	engine_location Engine-location	wheel_base Wheel-base	length Length	width Width	height Height	curb_weight Curb-weight	engine_type Engine-type	num_of_cylinders Num-of-cylinders	engine_size Engine-size	fuel_system Fuel-system	bore Bore	stroke Stroke	compression_ratio Compression-ratio	horsepower Horsepower	peak_rpm Peak-rpm	city_mpg City-mpg	highway_mpg Highway-mpg	price Price	city_l_100km City-L/100km	horsepower_binned Horsepower-binned	gas Gas
3	122	alfa-romero	std	two	convertible	rwd	front	88.6	0.8111484863046613	0.8902777777777777	48.8	2548	dohc	four	130	mpfi	3.47	2.68	9	111	5000	21	27	13495	11.190476190476188	Medium	1
3	122	alfa-romero	std	two	convertible	rwd	front	88.6	0.8111484863046613	0.8902777777777777	48.8	2548	dohc	four	130	mpfi	3.47	2.68	9	111	5000	21	27	16500	11.190476190476188	Medium	1
1	122	alfa-romero	std	two	hatchback	rwd	front	94.5	0.8226814031715521	0.9097222222222222	52.4	2823	ohcv	six	152	mpfi	2.68	3.47	9	154	5000	19	26	16500	12.36842105263158	Medium	1
2	164	audi	std	four	sedan	fwd	front	99.8	0.8486304661220567	0.9194444444444444	54.3	2337	ohc	four	109	mpfi	3.19	3.4	10	102	5500	24	30	13950	9.791666666666666	Medium	1
2	164	audi	std	four	sedan	4wd	front	99.4	0.8486304661220567	0.9222222222222224	54.3	2824	ohc	five	136	mpfi	3.19	3.4	8	115	5500	18	22	17450	13.055555555555555	Medium	1
2	122	audi	std	two	sedan	fwd	front	99.8	0.8519942335415667	0.9208333333333332	53.1	2507	ohc	five	136	mpfi	3.19	3.4	8.5	110	5500	19	25	15250	12.36842105263158	Medium	1
1	158	audi	std	four	sedan	fwd	front	105.8	0.9259971167707832	0.9916666666666668	55.7	2844	ohc	five	136	mpfi	3.19	3.4	8.5	110	5500	19	25	17710	12.36842105263158	Medium	1
1	122	audi	std	four	wagon	fwd	front	105.8	0.9259971167707832	0.9916666666666668	55.7	2954	ohc	five	136	mpfi	3.19	3.4	8.5	110	5500	19	25	18920	12.36842105263158	Medium	1
1	158	audi	turbo	four	sedan	fwd	front	105.8	0.9259971167707832	0.9916666666666668	55.9	3086	ohc	five	131	mpfi	3.13	3.4	8.3	140	5500	17	20	23875	13.823529411764708	Medium	1
2	192	bmw	std	two	sedan	rwd	front	101.2	0.8495915425276309	0.8999999999999999	54.3	2395	ohc	four	108	mpfi	3.5	2.8	8.8	101	5800	23	29	16430	10.217391304347826	Low	1


CREATE TABLE auto_clean (
  "symboling" BIGINT,
  "normalized_losses" BIGINT,
  "make" VARCHAR,
  "aspiration" VARCHAR,
  "num_of_doors" VARCHAR,
  "body_style" VARCHAR,
  "drive_wheels" VARCHAR,
  "engine_location" VARCHAR,
  "wheel_base" DOUBLE,
  "length" DOUBLE,
  "width" DOUBLE,
  "height" DOUBLE,
  "curb_weight" BIGINT,
  "engine_type" VARCHAR,
  "num_of_cylinders" VARCHAR,
  "engine_size" BIGINT,
  "fuel_system" VARCHAR,
  "bore" DOUBLE,
  "stroke" DOUBLE,
  "compression_ratio" DOUBLE,
  "horsepower" DOUBLE,
  "peak_rpm" DOUBLE,
  "city_mpg" BIGINT,
  "highway_mpg" BIGINT,
  "price" DOUBLE,
  "city_l_100km" DOUBLE,
  "horsepower_binned" VARCHAR,
  "diesel" BIGINT,
  "gas" BIGINT
);