1985 Automobile Dataset

1985 Auto Imports Database

@kaggle.fazilbtopal_auto85

Table List

2 tables(50.48 KB)

Auto

@kaggle.fazilbtopal_auto85.auto

23.18 KB
204 rows
26 columns

n_3 3	n ?	alfa_romero Alfa-romero	gas Gas	std Std	two Two	convertible Convertible	rwd Rwd	front Front	n_88_6 88.6	n_168_8 168.8	n_64_1 64.1	n_48_8 48.8	n_2548 2548	dohc Dohc	four Four	n_130 130	mpfi Mpfi	n_3_47 3.47	n_2_68 2.68	n_9_0 9.0	n_111 111	n_5000 5000	n_21 21	n_27 27	n_13495 13495
3	?	alfa-romero	gas	std	two	convertible	rwd	front	88.6	168.8	64.1	48.8	2548	dohc	four	130	mpfi	3.47	2.68	9	111	5000	21	27	16500
1	?	alfa-romero	gas	std	two	hatchback	rwd	front	94.5	171.2	65.5	52.4	2823	ohcv	six	152	mpfi	2.68	3.47	9	154	5000	19	26	16500
2	164	audi	gas	std	four	sedan	fwd	front	99.8	176.6	66.2	54.3	2337	ohc	four	109	mpfi	3.19	3.40	10	102	5500	24	30	13950
2	164	audi	gas	std	four	sedan	4wd	front	99.4	176.6	66.4	54.3	2824	ohc	five	136	mpfi	3.19	3.40	8	115	5500	18	22	17450
2	?	audi	gas	std	two	sedan	fwd	front	99.8	177.3	66.3	53.1	2507	ohc	five	136	mpfi	3.19	3.40	8.5	110	5500	19	25	15250
1	158	audi	gas	std	four	sedan	fwd	front	105.8	192.7	71.4	55.7	2844	ohc	five	136	mpfi	3.19	3.40	8.5	110	5500	19	25	17710
1	?	audi	gas	std	four	wagon	fwd	front	105.8	192.7	71.4	55.7	2954	ohc	five	136	mpfi	3.19	3.40	8.5	110	5500	19	25	18920
1	158	audi	gas	turbo	four	sedan	fwd	front	105.8	192.7	71.4	55.9	3086	ohc	five	131	mpfi	3.13	3.40	8.3	140	5500	17	20	23875
	?	audi	gas	turbo	two	hatchback	4wd	front	99.5	178.2	67.9	52	3053	ohc	five	131	mpfi	3.13	3.40	7	160	5500	16	22	?
2	192	bmw	gas	std	two	sedan	rwd	front	101.2	176.8	64.8	54.3	2395	ohc	four	108	mpfi	3.50	2.80	8.8	101	5800	23	29	16430


CREATE TABLE auto (
  "n_3" BIGINT,
  "n" VARCHAR,
  "alfa_romero" VARCHAR,
  "gas" VARCHAR,
  "std" VARCHAR,
  "two" VARCHAR,
  "convertible" VARCHAR,
  "rwd" VARCHAR,
  "front" VARCHAR,
  "n_88_6" DOUBLE,
  "n_168_8" DOUBLE,
  "n_64_1" DOUBLE,
  "n_48_8" DOUBLE,
  "n_2548" BIGINT,
  "dohc" VARCHAR,
  "four" VARCHAR,
  "n_130" BIGINT,
  "mpfi" VARCHAR,
  "n_3_47" VARCHAR,
  "n_2_68" VARCHAR,
  "n_9_0" DOUBLE,
  "n_111" VARCHAR,
  "n_5000" VARCHAR,
  "n_21" BIGINT,
  "n_27" BIGINT,
  "n_13495" VARCHAR
);