Euro 3 Cars Emissions Traded On UK Market 2000-2007

JohnSnowLabs

Files Size Format Created Updated License Source
2 17MB csv zip 2 weeks ago John Snow Labs Standard License John Snow Labs Vehicle Certification Agency, UK
Download

Data Files

euro-3-cars-emissions-traded-on-uk-market-2000-2007-csv  

This is a preview version. There might be more data in the original version.

Field information

Field Name Order Type (Format) Description
Years_Released 1 date (%Y-%m-%d) The year UK Vehicle Certification Agency released the raport about emissions from new cars traded on UK Market
Car_Manufacturer 2 string The official car name manufacturer or importer
Car_Model 3 string The official brand under which a car manufacturer or importer is selling a specific type of car
Car_Description 4 string Specific characteristics of a car or cars belonging to a model sold by a car manufacturer or importer
Car_Transmission_Type 5 string The abbreviate description for a car model transmission types or types
Car_Engine_Capacity_In_Cubic_Centimeters 6 integer A car model engine capacity or capacities in cubic centimeters(cc)
Car_Fuel_Type 7 string The type of fuel or fuels a car model with specific characteristics is using
Urban_Fuel_Consumption_In_Metric_Units 8 number The urban fuel consumption in liers per 100 kilometres, at an ambient temperature of 20-30 Celsius degrees
Extra_Urban_Fuel_Consumption_In_Metric_Units 9 number The extra-urban fuel consumption in liers per 100 kilometres, at an ambient temperature of 20-30 Celsius degrees
Combined_Fuel_Consumption_In_Metric_Units 10 number The urban and extra-urban combined fuel consumption in liers per 100 kilometres, at an ambient temperature of 20-30 Celsius degrees
Urban_Fuel_Consumption_In_Imperial_Units 11 number The urban fuel consumption in miles per imperial gallon, at an ambient temperature of 20-30 Celsius degrees
Extra_Urban_Fuel_Consumption_In_Imperial_Units 12 number The extra-urban fuel consumption in miles per imperial gallon, at an ambient temperature of 20-30 Celsius degrees
Combined_Urban_Fuel_Consumption_In_Imperial_Units 13 number The urban and extra-urban combined fuel consumption in miles per imperial gallon, at an ambient temperature of 20-30 Celsius degrees
Fuel_Cost_Per_6000_Miles 14 number The estimated fuel cost in pounds at 6000 miles or halved from cost at 12000 miles
Electric_Energy_Consumption_Miles_Per_KWh 15 number Electricity consumption miles per kilowatt-hour
Wh_Per_Km 16 number Electricity consumption watt-hour per kilometre
Maximum_Range_Km 17 number The maximum number of kilometres a car can run using electrical power
Maximum_Range_Miles 18 number The maximum number of miles a car can run using electrical power
Electricity_Cost 19 number The estimated electricity cost in pounds
Total_Cost 20 number Ratio
Level_Of_External_Noise_Emitted_In_Decibels 21 number The estimated level of external noise in decibels, measured on the A scale (so it is more closely represented what is heard by the human ear), emitted by a car model with specific characteristics
CO2_Emissions_In_Grams_Per_Km 22 integer The estimated level of CO2 emissions, in grams per kilometer, released by a car model with specific characteristics
CO_Emmisions_In_Milligrams_Per_Km 23 number The estimated level of CO emissions, in milligrams per kilometer, released by a car model with specific characteristics
THC_Emissions_In_Milligrams_Per_Km 24 number The estimated level of hydrocarbons emissions, in milligrams per kilometer, released by a car model with specific characteristics
NOx_Emissions_In_Milligrams_Per_Km 25 number The estimated level of oxides of nitrogen (nitrogen dioxide - NO2 and nitric oxide - NO) emissions, in milligrams per kilometer, released by a car model with specific characteristics
THC_And_NOx_Emissions_In_Milligrams_Per_Km 26 number The estimated cumulative level of hydrocarbons and oxides of nitrogen (nitrogen dioxide - NO2 and nitric oxide - NO) emissions, in milligrams per kilometer, released by a car model with specific characteristics
Particulate_Matter_In_Milligrams_Per_Km 27 number The estimated level of particulate matter emissions, in milligrams per kilometer, released by a car model with specific characteristics

euro-3-cars-emissions-traded-on-uk-market-2000-2007_zip  

This is a preview version. There might be more data in the original version.

Read me

Import into your tool

If you are using R here's how to get the data you want quickly loaded:

install.packages("jsonlite")
library("jsonlite")

json_file <- "http://datahub.io/JohnSnowLabs/euro-3-cars-emissions-traded-on-uk-market-2000-2007/datapackage.json"
json_data <- fromJSON(paste(readLines(json_file), collapse=""))

# access csv file by the index starting from 1
path_to_file = json_data$resources$path[1][1]
data <- read.csv(url(path_to_file))
print(data)

In order to work with Data Packages in Pandas you need to install the Frictionless Data data package library and the pandas extension:

pip install datapackage
pip install jsontableschema-pandas

To get the data run following code:

import datapackage

data_url = "http://datahub.io/JohnSnowLabs/euro-3-cars-emissions-traded-on-uk-market-2000-2007/datapackage.json"

# to load Data Package into storage
storage = datapackage.push_datapackage(data_url, 'pandas')

# data frames available (corresponding to data files in original dataset)
storage.buckets

# you can access datasets inside storage, e.g. the first one:
storage[storage.buckets[0]]

For Python, first install the `datapackage` library (all the datasets on DataHub are Data Packages):

pip install datapackage

To get Data Package into your Python environment, run following code:

from datapackage import Package

package = Package('http://datahub.io/JohnSnowLabs/euro-3-cars-emissions-traded-on-uk-market-2000-2007/datapackage.json')

# get list of resources:
resources = package.descriptor['resources']
resourceList = [resources[x]['name'] for x in range(0, len(resources))]
print(resourceList)

data = package.resources[0].read()
print(data)

If you are using JavaScript, please, follow instructions below:

Install data.js module using npm:

  $ npm install data.js

Once the package is installed, use the following code snippet:

const {Dataset} = require('data.js')

const path = 'http://datahub.io/JohnSnowLabs/euro-3-cars-emissions-traded-on-uk-market-2000-2007/datapackage.json'

// We're using self-invoking function here as we want to use async-await syntax:
(async () => {
  const dataset = await Dataset.load(path)

  // Get the first data file in this dataset
  const file = dataset.resources[0]
  // Get a raw stream
  const stream = await file.stream()
  // entire file as a buffer (be careful with large files!)
  const buffer = await file.buffer
})()

Install the datapackage library created specially for Ruby language using gem:

gem install datapackage

Now get the dataset and read the data:

require 'datapackage'

path = 'http://datahub.io/JohnSnowLabs/euro-3-cars-emissions-traded-on-uk-market-2000-2007/datapackage.json'

package = DataPackage::Package.new(path)
# So package variable contains metadata. You can see it:
puts package

# Read data itself:
resource = package.resources[0]
data = resource.read
puts data
Datapackage.json