Read the files 2017_german_election_overall.csv
and 2017_german_election_party.csv
from the german-election-2017 dataset.
- For each area, compute the percentage of total votes over the registered voters
- For each state, compute the total number of registered voters
- How many registered voters are there in Bayern or Saarland (compute the voters in each state and the sum of the two numbers)
- For each state, compute the number of votes (first vote) for each party
- For each state and each party, compute the area where the party has taken the most total votes
- For each party, compute the area where the party has taken the most and the least votes, as a percentage of the overall registered voters in the state.
- For each area, compute the difference between the valid first votes and the valid second votes
- For each state, compute the difference between the valid first votes and the valid second votes
- For each party, compute the difference between the valid first votes and the valid second votes
- For each area and each party, compute the difference between the valid first votes and the valid second votes