widal001 / election-data Goto Github PK

Summary

Clean the input datasets to prepare them for exploratory analysis

To Do

CIean input datasets

• Drop everything but the following columns:
  • year
  • state
  • state_po
  • office
  • district
  • candidate
  • party
  • candidatevotes
  • totalvotes
• Convert party names to lowercase and condense to the following categories:
  • democrat
  • republican
  • third-party
• Calculate vote percentage by party

Create a set of outcomes dataframes

• pres_outcome with state and year as the unique composite key
• house_outcome with state, district, and year as the unique composite key
• senate_outcome with state and year as the unique composite key
• Calculate the following additional columns for each outcomes data frame:
  • win_party - which party won the district/state for that election
  • win_percent - the percentage of the vote with which that candidate won the district/state
  • win_count - the number of votes with which that candidate won the district/state
  • win_margin_percent - the percentage point margin by which the candidate won the district
  • win_margin_count - the vote count margin by which the candidate won the district
  • dem_percent - percentage of the vote that went to the democratic candidate
  • gop_percent - percentage of the vote that went to the republican candidate

Sumary

Do some basic exploration of the dataset in a jupyter notebook, guided by the questions below.

Exploratory Questions

• How has the vote margin between Democrats and Republicans changed over time in each state?
• What is the relationship between Senate, House, and Presidential outcomes in each state?
• What is the relationship between population change in each state and the vote margin between Democrats and Republicans?
• What is the relationship among voting outcomes of neighboring states (and neighboring districts within states)? Does it change over time?

Summary

Buildout the basic project structure

To Do

• ReadMe
  • Overview
  • Getting started
  • Contributing
• Testing framework
• GitHub Setup
  • Project Setup
  • Issue Templates
  • PR template

Resources

• Issue Templates
• PR Template