CSc 120: Pokemon data analysis

Introduction

Restrictions

1. For the long problems, your code should follow the style guidelines for the class.
2. You may not use concepts and/or short-hand syntax not yet covered in class. The restrictions include the following:
   • dictionary or list comprehensions, e.g., [n * 2 for i in range(10)]
   • with open (explicitly open and close the file instead)
   • the ternary operator (use an if instead)
   • nested functions (using def within a function to define another function)
   • exceptions (try/except)
   • type annotations
   • lambda expressions
   • generators and user defined iterators
   • default arguments
   • decorators
   • importing libraries (unless a library is explicitly mentioned in the specification)

Input Format

Any line in the input file that begins with the character '#' (without quotes) is a comment line that should be ignored for data analysis.

The first line of the input file, which is a comment line, gives the meaning of the various data columns (in this table, the number at the top of each entry gives its position in a row of comma-separated values, e.g., "Attack" is at position 6):

0 No.

1 Name

2 Type 1

3 Type 2

4 Total strength

5 HP

6 Attack

7 Defense

8 Special Attack

9 Special Defense

10 Speed

11 Generation

12 Legendary?

Expected Behavior

1. Read in the name of a data file. Use the input() function to prompt the user for the file name, but do not supply an argument to input(). (We call this a silent prompt.) This file will be a CSV file containing data about Pokemon in the format described above. It can be the full Pokemon.csv data file, but you can also specify other input files that contain more or less information (e.g., a smaller file may be useful for testing or debugging).
2. Read the data file specified above. Do not use the Python csv module. Organize the data into a data structure that collects together information about different Pokemon types. For this assignment, for the Type, we will consider only the Type 1 field and ignore Type 2 since this is not defined for all Pokemon.
3. Repeatedly read and process queries from the user (see Queries below) until the user enters an empty line. Some examples are given here.

Queries

User query	Program action
Total	Compute the Pokemon type(s) that have highest average Total strength.
HP	Compute the Pokemon type(s) that have highest average HP.
Attack	Compute the Pokemon type(s) that have highest average Attack.
Defense	Compute the Pokemon type(s) that have highest average Defense.
SpecialAttack	Compute the Pokemon type(s) that have highest average Special Attack.
SpecialDefense	Compute the Pokemon type(s) that have highest average Special Defense.
Speed	Compute the Pokemon type(s) that have highest average Speed.
(empty line)	Terminate query processing
anything else	Ignore the query

Note that, in each case, there may be more than one type of Pokemon with the highest average value computed. You should print out information about each of them according to the output format given below.

Matching the queries entered by the user's with the User query column shown above should be case-insensitive. For example, the user inputs Attack, attack, ATTACK, and AtTaCk should all be processed the same way.

Output Format

print("{}: {}".format(pokemon_type, max_average))

where pokemon_type is the type of Pokemon, and max_average is the average value computed for that Pokemon type for that query (e.g., average total, average HP, average Attack, etc.), which should be equal to the maximum value for that query across all types. If more than one Pokemon type has the same maximum average for a property, then print each one out, one per line, in alphabetical order of the Pokemon type.

Programming Requirements

1. Follow the style guidelines for this class.

2. Your code should not repeatedly and unnecessarily traverse all the data about all the Pokemon when processing queries. To this end, organize your code and data as follows.

   A. Data organization.

   You are required to use a two-level dictionary (i.e., a dictionary of dictionaries) to implement your Pokemon database, as explained below:

   • At the top level, information should be grouped by Pokemon type: i.e., all of the information about Pokemon belonging to a particular type should be grouped together. A data structure that will do this efficiently is the dictionary.
   • For each Pokemon type, we have to store information about all of the different Pokemon that belong to that type. Again, this can be done efficiently using a dictionary that maps the Pokemon's name to its properties (Total strength, Attack, Defense, etc.).

   Additionally, for each Pokemon type you must pre-compute the average values for all of its properties (see Code Organization below). These average values must also be organized as a dictionary keyed by Pokemon type.

   B. Code organization.

   Notice that the Pokemon properties you read in do not change during the computation. This means that the average value for any property for any given Pokemon type will remain the same as well. This, in turn, means that the maximum average values will also not change. Thus, these values can all be computed once and saved, with query processing simply looking up the saved values as needed. This approach is closely related to an speedup technique called memoization.

   Your code should be organized as follows:

   • After reading in all the Pokemon data: for each Pokemon type, compute the average value for each of its properties across all of the Pokemon that belong to that type. Save this result into a dictionary indexed by Pokemon type.
   • Next, process the average values obtained in the previous step to compute the maximum average value for each property. Optionally, at this point you can also compute which Pokemon types have the maximum average value for each property.
   • Use these data to help process user queries until there are no queries to process.

Examples