Large Data Sets Flashcards
During which two years must the vehicles in the LDS have been manufactured and registered?
2002 and 2016
Gap includes the emission scandal
Which database is the LDS extracted from?
the UK department for Transport Stock Vehicle database
What is the LDS about?
cars
How many makes of cars are there in the LDS?
5
What are the 5 makes in the LDS?
BMW
Ford
Toyota
Vauxhall
Volkswagen
(Big Friendly Troll’s Vague Viola)
How many regions are there in the LDS?
3
What are the 3 regions in the LDS?
London
North West
South West
How many propulsion types are thee in the LDS?
5
What are the 5 propulsion types?
petrol
diesel
electric (only 1 car)
gas / petrol (only 1 car)
electric / petrol
Paul Doesn’t Eat Greasy Potato Every Period
How many keeper title IDs are there in the LDS?
5
What are the 5 keeper title IDs in the LDS?
Male
Female
Not used
Unknown (eg Doctor)
Company
My Friend Niamh Uses Cream
What units do you need to know for the LDS?
(FOR EMISSIONS, MASS AND ENGINE SIZE)
Emissions = g/km
Mass = kg (this includes a 75kg driver)
Engine Size = cm^3
How much does the driver weigh?
75kg
DRIVE = 75
How many cm^3 is in 1 litre?
1000cm^3 = 1 litre
What missing data / errors are there in the LDS?
lots of gaps particularly for particulate submissions
data needs to be cleaned first (remove errors/outliers) before working out standard deviation
