Question

Phython

read_file (fp)  D1,D2,D3:

1. a) This function read a file pointer and returns 3 dictionaries:
   - Parameters: file pointer (fp)
   - Returns : 3 dictionaries of list of tuples - The function displays nothing

2. b) You must use the csv.reader because some fields have commas in them.

3. c) Each row of the file contains the name of a video game, the platform which it was released, the release year, the genre (i.e. shooter, puzzle, rpg, fighter, etc.), the publishing

CSE 231

Spring 2020

d) e)

f)

company, and regional sales across north America, Europe, Japan, and other regions. For this project, we are only interested in the following columns:

     name = line[0]
     platform = line[1]
     year = int(line[2])
     genre = line[3]
     publisher = line[4]
     na_sales = float(line[5])
     europe_sales = float(line[6])
     japan_sales = float(line[7])
     other_sales = float(line[8])

All strings should be converted to lower case and stripped of the trailing/forward white spaces.

Multiply each regional sales column by 1,000,000. The program must compute the total global sales by adding all the regional sales (na_sales, europe_sales, japan_sales, other_sales).

This function returns 3 separate dictionaries. The first dictionary, with ‘name’ as key, will contain the data used to display the global sales per year or platform. The second dictionary, with ‘genre’ as key, contains the data used to display the regional sales per genre. The third dictionary, with ‘publisher’ as key, contains the data used to display the global sales by publisher. All of 3 dictionaries have a list of tuples as values:

  D1 = { name:[(name, platform, year, genre, publisher,
        global_sales), ...], ...}

  D2 = { genre: [(genre, year, na_sales, eur_sales,
        jpn_sales, other_sales, global_sales), ...], ...}

  D3 = {publisher: [(publisher, name, year, na_sales,
        eur_sales, jpn_sales, other_sales, global_sales),
        ...], ...}

You should ignore all the values that are not valid: - ‘year’ should be integer (int)
- All regional sales should be floats (floats).

Once the file is read and all the data is stored in the 3 dictionaries, you need to sort each dictionary alphabetically in ascending order by their keys. The values for the 3 dictionaries should also be sorted by the last element of the tuples in reverse order (global_sales).

Hint: Dictionaries are insertion sorted meaning the order of insertion into the dictionary is preserved. You should first get all the keys of a dictionary and sort

g)

CSE 231 Spring 2020

them. Then iterate through the sorted list of keys and insert their corresponding values into a new dictionary. You should sort the values before inserting them.

Answer 1

I have used a made-up .csv file having the same structure as described above. It provided below

watch dogs ,pc,2014,fighter,companyA,10,100,1000,20000

gta 5,pc,2013,advanture,Rockstars ,10,100,1000,20000

The Witcher 3: Wild Hunt,pc,2020,opean world,companyB,10,100,1000,20000

Control,pc,2018,advanture,companyC,10,100,1000,20000

fortnite,pc,2017,battle royal,EPIC,10,100,1000,20000

pubg,pc,2016,battle royal,TENSENT,10,100,1000,20000

Code :

import csv

def sort(x):

d = {}

for i in sorted(x.keys()):

# print(i)

d[i] = x[i]

return d

def read_file(fp):

  

#reading the file

  

with open(fp) as csvfile:

spamreader = csv.reader(csvfile, delimiter=',')

file_rows = [row for row in spamreader]

# print(file_rows)

#extracting data into the specified columns

names=[]

platform=[]

year=[]

genre=[]

publisher=[]

na_sales=[]

europe_sales=[]

japan_sales=[]

other_sales=[]

for i in file_rows:

names.append(i[0].lower().strip())

platform.append(i[1].lower().strip())

year.append(int(i[2]))

genre.append(i[3].lower().strip())

publisher.append(i[4].lower().strip())

na_sales.append(float(i[5]))

europe_sales.append(float(i[6]))

japan_sales.append(float(i[7]))

other_sales.append(float(i[8]))

#calculate global

na_sales = list(map(lambda x: x * 1000000,na_sales))

  

europe_sales = list(map(lambda x: x * 1000000,europe_sales))

japan_sales = list(map(lambda x: x * 1000000,japan_sales))

other_sales = list(map(lambda x: x * 1000000,other_sales))

global_sales = [0] * len(other_sales)

for i in range(len(other_sales)):

global_sales[i] = na_sales[i] + europe_sales[i] + japan_sales[i] + other_sales[i]

# dic_1 key : names and contains info. abt. the global sales

D1 = {}

D2 = {}

D3 = {}

for i in range(len(names)):

D1[names[i]] = [(names[i],platform[i],year[i],genre[i],publisher[i],global_sales[i])]

D2[genre[i]] = [(genre[i],year[i],na_sales[i],europe_sales[i],japan_sales[i],other_sales[i],global_sales[i])]

D3[publisher[i]] = [(publisher[i],names[i],year[i],na_sales[i],europe_sales[i],japan_sales[i],other_sales[i],global_sales[i])]

  

# first sorting distionary by their keys

# print(sorted(D1.items(),reverse=True))

  

D1 = sort(D1)

  

D2 = sort(D2)

D3 = sort(D3)

return D1,D2,D3

if __name__ == "__main__":

d1,d2,d3 = read_file("game_data.csv")

Note :if you have any queries then comment below, I'm very happy to solve your doubts, thank you. ..