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

  1. Read the files 2017_german_election_overall.csv and 2017_german_election_party.csv.
  2. For each area, compute the percentage of total votes over the registered voters
  3. For each state, compute the total number of registered voters
  4. How many registered voters are there in Bayern or Saarland (compute the voters in each state and the sum of the two numbers)
  5. For each state, compute the number of votes (first vote) for each party
  6. For each state and each party, compute the area where the party has taken the most total votes