CO2 Emission By Vehicles
Amount of CO2 emissions by a vehicle depending on their various features.
@kaggle.debajyotipodder_co2_emission_by_vehicles
Amount of CO2 emissions by a vehicle depending on their various features.
@kaggle.debajyotipodder_co2_emission_by_vehicles
Hi, I am currently pursuing PGP in Data Science. Recently we were assigned with a project on regression and hypothesis by our Statistics department. While looking for a dataset relevant to my project, I stumbled upon this one.
This dataset captures the details of how CO2 emissions by a vehicle can vary with the different features. The dataset has been taken from Canada Government official open data website. This is a compiled version. This contains data over a period of 7 years.
There are total 7385 rows and 12 columns. There are few abbreviations that has been used to describe the features. I am listing them out here. The same can be found in the Data Description sheet.
4WD/4X4 = Four-wheel drive
AWD = All-wheel drive
FFV = Flexible-fuel vehicle
SWB = Short wheelbase
LWB = Long wheelbase
EWB = Extended wheelbase
A = Automatic
AM = Automated manual
AS = Automatic with select shift
AV = Continuously variable
M = Manual
3 - 10 = Number of gears
X = Regular gasoline
Z = Premium gasoline
D = Diesel
E = Ethanol (E85)
N = Natural gas
City and highway fuel consumption ratings are shown in litres per 100 kilometres (L/100 km) - the combined rating (55% city, 45% hwy) is shown in L/100 km and in miles per gallon (mpg)
The tailpipe emissions of carbon dioxide (in grams per kilometre) for combined city and highway driving
The data has been taken and compiled from the below Canada Government official link
https://open.canada.ca/data/en/dataset/98f1a129-f628-4ce4-b24d-6f16bf24dd64#wb-auto-6
CREATE TABLE co2_emissions_canada (
"make" VARCHAR,
"model" VARCHAR,
"vehicle_class" VARCHAR,
"engine_size_l" DOUBLE -- Engine Size(L),
"cylinders" BIGINT,
"transmission" VARCHAR,
"fuel_type" VARCHAR,
"fuel_consumption_city_l_100_km" DOUBLE -- Fuel Consumption City (L/100 Km),
"fuel_consumption_hwy_l_100_km" DOUBLE -- Fuel Consumption Hwy (L/100 Km),
"fuel_consumption_comb_l_100_km" DOUBLE -- Fuel Consumption Comb (L/100 Km),
"fuel_consumption_comb_mpg" BIGINT -- Fuel Consumption Comb (mpg),
"co2_emissions_g_km" BIGINT -- CO2 Emissions(g/km)
);CREATE TABLE data_description (
"understanding_the_data" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1
);Anyone who has the link will be able to view this.