North Korean Pokémon Survey

North Korea's Pokémon are out of control! Cell phones are illegal, so nobody is catching the Pokémon.

Pokémon have been counted in the provinces of Bugjjog, Namjjog, and Dongjjog. Data on each type has been collected in a data set you can download. Here's part of the file:

There is one record for each type seen, showing the counts seen in each province. So, 25 Squirtles were counted in Bugjjog, and 53 Blastoise in Dongjjog.

Write a Python program to analyze the data set. There might be errors in the data. Exclude records with errors from your calculations. Data validation rules:

• There must be a name.
• All numbers must be integers from 0 up to 100.

For valid data, find:

• The total number of Pokémon in each province.
• The total in all provinces.
• The average of the counts for each province, rounded to one decimal place.
• The name and total count of the most common Pokémon.

Here's some sample output:

Upload your solution here, not to Moodle. The usual programming standards apply.

(No Pokémon were harmed in the creation of this exercise.)