About this Dataset

CO2 Emission By Vehicles

CONTEXT

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.

CONTENT

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.

Model

4WD/4X4 = Four-wheel drive
AWD = All-wheel drive
FFV = Flexible-fuel vehicle
SWB = Short wheelbase
LWB = Long wheelbase
EWB = Extended wheelbase

Transmission

A = Automatic
AM = Automated manual
AS = Automatic with select shift
AV = Continuously variable
M = Manual
3 - 10 = Number of gears

Fuel type

X = Regular gasoline
Z = Premium gasoline
D = Diesel
E = Ethanol (E85)
N = Natural gas

Fuel Consumption

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)

CO2 Emissions

The tailpipe emissions of carbon dioxide (in grams per kilometre) for combined city and highway driving

ACKNOWLEDGEMENTS

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

QUESTIONS

Determine or test the influence of different variables on the emission of CO2.
What are the most influencing features that affect the CO2 emission the most?
Will there be any difference in the CO2 emissions when Fuel Consumption for City and Highway are considered separately and when their weighted variable interaction is considered?

Tables

Co2 Emissions Canada

@kaggle.debajyotipodder_co2_emission_by_vehicles.co2_emissions_canada

91.66 KB
7385 rows
12 columns


CREATE TABLE co2_emissions_canada (
  "make" VARCHAR,
  "model" VARCHAR,
  "vehicle_class" VARCHAR,
  "engine_size_l" DOUBLE,
  "cylinders" BIGINT,
  "transmission" VARCHAR,
  "fuel_type" VARCHAR,
  "fuel_consumption_city_l_100_km" DOUBLE,
  "fuel_consumption_hwy_l_100_km" DOUBLE,
  "fuel_consumption_comb_l_100_km" DOUBLE,
  "fuel_consumption_comb_mpg" BIGINT,
  "co2_emissions_g_km" BIGINT
);

Data Description

@kaggle.debajyotipodder_co2_emission_by_vehicles.data_description

3.17 KB
19 rows
2 columns


CREATE TABLE data_description (
  "understanding_the_data" VARCHAR,
  "unnamed_1" VARCHAR
);