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

Clean up 2015 results to use HoC data #19

Closed
john-sandall opened this issue Dec 5, 2019 · 0 comments · Fixed by #23
Closed

Clean up 2015 results to use HoC data #19

john-sandall opened this issue Dec 5, 2019 · 0 comments · Fixed by #23
Milestone

Comments

@john-sandall
Copy link
Owner

The currently processed 2015 results data isn't even that nice. Integrate further cleaning and ID mapping from the SixFifty model.

This currently uses the Electoral Commission's results dataset. Earlier this year, they stopped hosting results and this is now officially published by the House of Commons library at parliament.uk. We need to bring this code up-to-date so it uses the new data (which is in a different format!) for the 2015 results: https://researchbriefings.parliament.uk/ResearchBriefing/Summary/CBP-7186

The goal is the same, we want to turn this into a dataset with the same format as the current code with columns something like:

Press Association ID Number    Constituency ID    Constituency Name    Constituency Type    County    Region ID    Region    Country    Election Year    Electorate    Valid Votes    con    lab    ld    ukip    grn    snp    pc    other    con_pc    lab_pc    ld_pc    ukip_pc    grn_pc    snp_pc    pc_pc    other_pc    geo    winner

The new dataset also switches to using just ons_id (which is the same as Constituency ID in the previous cleaned results) and not Press Association ID Number, this is fine, you can drop that column.

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

Successfully merging a pull request may close this issue.

1 participant