Vehicle Fuel Economy

Insights into Vehicles, Fuel Efficiency, and Environmental Impact

@kaggle.sahirmaharajj_fuel_economy

Table List

1 table(1.18 MB)

Fuel

@kaggle.sahirmaharajj_fuel_economy.fuel

1.18 MB
38113 rows
81 columns

vehicle_id Vehicle Id	year Year	make Make	model Model	class Class	drive Drive	transmission Transmission	transmission_type Transmission Type	engine_index Engine Index	engine_descriptor Engine Descriptor	engine_cylinders Engine Cylinders	engine_displacement Engine Displacement	turbocharger Turbocharger	fuel_type Fuel Type	fuel_type_1 Fuel Type 1	city_mpg_ft1 City Mpg Ft1	highway_mpg_ft1 Highway Mpg Ft1	unadjusted_city_mpg_ft1 Unadjusted City Mpg Ft1	unadjusted_highway_mpg_ft1 Unadjusted Highway Mpg Ft1	combined_mpg_ft1 Combined Mpg Ft1	annual_fuel_cost_ft1 Annual Fuel Cost Ft1	gas_guzzler_tax Gas Guzzler Tax	save_or_spend_5_year Save Or Spend 5 Year	annual_consumption_in_barrels_ft1 Annual Consumption In Barrels Ft1	tailpipe_co2_ft1 Tailpipe Co2 Ft1	tailpipe_co2_in_grams_mile_ft1 Tailpipe Co2 In Grams Mile Ft1	tailpipe_co2_ft2 Tailpipe Co2 Ft2	fuel_economy_score Fuel Economy Score	ghg_score Ghg Score	ghg_score_alt_fuel Ghg Score Alt Fuel	my_mpg_data My Mpg Data	x2d_passenger_volume X2d Passenger Volume	x2d_luggage_volume X2d Luggage Volume	alternative_fuel_technology Alternative Fuel Technology
26587	1984	Alfa Romeo	GT V6 2.5	Minicompact Cars	nan	Manual 5-Speed	nan	9001	(FFS)	6	2.5	nan	Regular	Regular Gasoline	17	24	21	34	20	1750	nan	-2000	16.4805	-1	444.35	-1	-1	-1	-1	N	74	7	nan
27705	1984	Alfa Romeo	GT V6 2.5	Minicompact Cars	nan	Manual 5-Speed	nan	9005	(FFS) CA model	6	2.5	nan	Regular	Regular Gasoline	17	24	21	34	20	1750	nan	-2000	16.4805	-1	444.35	-1	-1	-1	-1	N	74	7	nan
26561	1984	Alfa Romeo	Spider Veloce 2000	Two Seaters	nan	Manual 5-Speed	nan	9002	(FFS)	4	2	nan	Regular	Regular Gasoline	18	25	23	35	21	1650	nan	-1500	15.69571429	-1	423.1904762	-1	-1	-1	-1	N			nan
27681	1984	Alfa Romeo	Spider Veloce 2000	Two Seaters	nan	Manual 5-Speed	nan	9006	(FFS) CA model	4	2	nan	Regular	Regular Gasoline	18	25	23	35	21	1650	nan	-1500	15.69571429	-1	423.1904762	-1	-1	-1	-1	N			nan
27550	1984	AM General	DJ Po Vehicle 2WD	Special Purpose Vehicle 2WD	2-Wheel Drive	Automatic 3-Speed	nan	1830	(FFS)	4	2.5	nan	Regular	Regular Gasoline	18	17	22	24	17	2050	nan	-3500	19.38882353	-1	522.7647059	-1	-1	-1	-1	N			nan
28426	1984	AM General	DJ Po Vehicle 2WD	Special Purpose Vehicle 2WD	2-Wheel Drive	Automatic 3-Speed	nan	1880	(FFS) CA model	4	2.5	nan	Regular	Regular Gasoline	18	17	22	24	17	2050	nan	-3500	19.38882353	-1	522.7647059	-1	-1	-1	-1	N			nan
27549	1984	AM General	FJ8c Post Office	Special Purpose Vehicle 2WD	2-Wheel Drive	Automatic 3-Speed	nan	1831	(FFS)	6	4.2	nan	Regular	Regular Gasoline	13	13	16	18	13	2700	nan	-6750	25.35461538	-1	683.6153846	-1	-1	-1	-1	N			nan
28425	1984	AM General	FJ8c Post Office	Special Purpose Vehicle 2WD	2-Wheel Drive	Automatic 3-Speed	nan	1881	(FFS) CA model	6	4.2	nan	Regular	Regular Gasoline	13	13	16	18	13	2700	nan	-6750	25.35461538	-1	683.6153846	-1	-1	-1	-1	N			nan
27593	1984	American Motors Corporation	Eagle 4WD	Special Purpose Vehicle 4WD	4-Wheel or All-Wheel Drive	Automatic 3-Speed	nan	1524	(FFS)	6	4.2	nan	Regular	Regular Gasoline	15	20	19	27	17	2050	nan	-3500	19.38882353	-1	522.7647059	-1	-1	-1	-1	N			nan
28455	1984	American Motors Corporation	Eagle 4WD	Special Purpose Vehicle 4WD	4-Wheel or All-Wheel Drive	Automatic 3-Speed	nan	1574	(FFS) CA model	6	4.2	nan	Regular	Regular Gasoline	15	19	19	26	17	2050	nan	-3500	19.38882353	-1	522.7647059	-1	-1	-1	-1	N			nan


CREATE TABLE fuel (
  "vehicle_id" BIGINT,
  "year" BIGINT,
  "make" VARCHAR,
  "model" VARCHAR,
  "class" VARCHAR,
  "drive" VARCHAR,
  "transmission" VARCHAR,
  "transmission_type" VARCHAR,
  "engine_index" BIGINT,
  "engine_descriptor" VARCHAR,
  "engine_cylinders" DOUBLE,
  "engine_displacement" DOUBLE,
  "turbocharger" VARCHAR,
  "supercharger" VARCHAR,
  "fuel_type" VARCHAR,
  "fuel_type_1" VARCHAR,
  "fuel_type_2" VARCHAR,
  "city_mpg_ft1" BIGINT,
  "unrounded_city_mpg_ft1" DOUBLE,
  "city_mpg_ft2" BIGINT,
  "unrounded_city_mpg_ft2" DOUBLE,
  "city_gasoline_consumption_cd" DOUBLE,
  "city_electricity_consumption" DOUBLE,
  "city_utility_factor" DOUBLE,
  "highway_mpg_ft1" BIGINT,
  "unrounded_highway_mpg_ft1" DOUBLE,
  "highway_mpg_ft2" BIGINT,
  "unrounded_highway_mpg_ft2" DOUBLE,
  "highway_gasoline_consumption_cd" DOUBLE,
  "highway_electricity_consumption" DOUBLE,
  "highway_utility_factor" DOUBLE,
  "unadjusted_city_mpg_ft1" DOUBLE,
  "unadjusted_highway_mpg_ft1" DOUBLE,
  "unadjusted_city_mpg_ft2" DOUBLE,
  "unadjusted_highway_mpg_ft2" DOUBLE,
  "combined_mpg_ft1" BIGINT,
  "unrounded_combined_mpg_ft1" DOUBLE,
  "combined_mpg_ft2" BIGINT,
  "unrounded_combined_mpg_ft2" DOUBLE,
  "combined_electricity_consumption" DOUBLE,
  "combined_gasoline_consumption_cd" DOUBLE,
  "combined_utility_factor" DOUBLE,
  "annual_fuel_cost_ft1" BIGINT,
  "annual_fuel_cost_ft2" BIGINT,
  "gas_guzzler_tax" VARCHAR,
  "save_or_spend_5_year" BIGINT,
  "annual_consumption_in_barrels_ft1" DOUBLE,
  "annual_consumption_in_barrels_ft2" DOUBLE,
  "tailpipe_co2_ft1" BIGINT,
  "tailpipe_co2_in_grams_mile_ft1" DOUBLE,
  "tailpipe_co2_ft2" BIGINT,
  "tailpipe_co2_in_grams_mile_ft2" DOUBLE,
  "fuel_economy_score" BIGINT,
  "ghg_score" BIGINT,
  "ghg_score_alt_fuel" BIGINT,
  "my_mpg_data" VARCHAR,
  "x2d_passenger_volume" BIGINT,
  "x2d_luggage_volume" BIGINT,
  "x4d_passenger_volume" BIGINT,
  "x4d_luggage_volume" BIGINT,
  "hatchback_passenger_volume" BIGINT,
  "hatchback_luggage_volume" BIGINT,
  "start_stop_technology" VARCHAR,
  "alternative_fuel_technology" VARCHAR,
  "electric_motor" VARCHAR,
  "manufacturer_code" VARCHAR,
  "gasoline_electricity_blended_cd" BOOLEAN,
  "vehicle_charger" VARCHAR,
  "alternate_charger" VARCHAR,
  "hours_to_charge_120v" BIGINT,
  "hours_to_charge_240v" DOUBLE,
  "hours_to_charge_ac_240v" DOUBLE,
  "composite_city_mpg" BIGINT,
  "composite_highway_mpg" BIGINT,
  "composite_combined_mpg" BIGINT,
  "range_ft1" BIGINT,
  "city_range_ft1" DOUBLE,
  "highway_range_ft1" DOUBLE,
  "range_ft2" VARCHAR,
  "city_range_ft2" DOUBLE,
  "highway_range_ft2" DOUBLE
);