Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Subsetting the EU data #1

Open
wengraf opened this issue Jan 29, 2021 · 1 comment
Open

Subsetting the EU data #1

wengraf opened this issue Jan 29, 2021 · 1 comment

Comments

@wengraf
Copy link
Collaborator

wengraf commented Jan 29, 2021

@Robinlovelace: We need to work out which vehicles we are keeping. I would suggest we need all GB, plus all non-GB that isn't replicated by GB equivalents.

@wengraf
Copy link
Collaborator Author

wengraf commented Jan 29, 2021

@Robinlovelace: I've added some elements and tidied up the data - there is new registration data, which should be the basis of a joining variable. The commercial model name also looks promising in format. Proposed next steps:

Switch to reading final data. For example:

Read in VEH160 from the DfT Vehicle Stats. VEH160 has DVLA model name and total new registrations. GB subset of EU data has "commercial model name", which looks quite DVLA-ish at first glance, and total new registrations, which ought to match UK annual new registration totals.

Test how much of the new registration UK vehicle parc is submitted to EU.

Are you getting full or generic model name in your stats19 data? I think you really need full.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant