Read the files 2017_german_election_overall.csv and 2017_german_election_party.csv from the german-election-2017 dataset.

  1. For each area, compute the percentage of total votes over the registered voters
  2. For each state, compute the total number of registered voters
  3. How many registered voters are there in Bayern or Saarland (compute the voters in each state and the sum of the two numbers)
  4. For each state, compute the number of votes (first vote) for each party
  5. For each state and each party, compute the area where the party has taken the most total votes
  6. 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.
  7. For each area, compute the difference between the valid first votes and the valid second votes
  8. For each state, compute the difference between the valid first votes and the valid second votes
  9. For each party, compute the difference between the valid first votes and the valid second votes
  10. For each area and each party, compute the difference between the valid first votes and the valid second votes