Question

Write an open_file() and a function that reads a csv data file and returns a dictionary

Microsoft Word - project09_final_RJE.docx 1/17 This project focuses on analyzing a publicly available dataset containing information about the spread of nCoV. Since this is an active situation, this dataset is constantly being updated with the latest figures. However, for our purposes, we will use a static version of the dataset provided to you with this project (ncov.csv). This static version was lasted updated on March 18h. Another file (ncov_small.csv) was last updated February 5m. open_file() -> fp This function takes no parameters and returns a file pointer to the data file. You likely have a copy from a previous project. It repeatedly prompis for a lile until one is successfully opened. It should have a try-except statement. By default (when the user does not provide a filename), this function opens the file 'ncov.csv'. build_dictionary (fp) -> dictionary This function accepts the previously generated file pointer as input and returns the required dictionary. You have to use csv.reader to read the data file since the area name has a comma. This function iterates over the CSV reader and within each iteration, extracts the needed data and then creates a dictionary that holds all of the data. Remember to skip the header line. Also, the order of countries and areas in the dictionary will be the same as the order observed in the CSV file. This dictionary is then returned by the function. The data to be extracted is:

Answer 1

If you have any doubts, please give me comment...

1 2 import csv def open_file(): is_open = False while is open = False: fname = input("Enter input filename: "), try: fp = open(fname) is_open = True except FileNotFoundError: print("Unable to open", fname) return fp

Code:

import csv

def open_file():

is_open = False

while is_open == False:

fname = input("Enter input filename: ")

try:

fp = open(fname)

is_open = True

except FileNotFoundError:

print("Unable to open", fname)

return fp

def build_dictionary(fp):

my_dict = {}

fp.readline()

csv_r = csv.reader(fp, delimiter=',')

for row in csv_r:

country = row[2]

area = row[1]

last_update = row[3]

cases = int(row[4])

deaths = int(row[5])

recovered = int(row[6])

if country not in my_dict:

my_dict[country] = []

my_dict[country].append({area:(last_update, cases, deaths, recovered)})

return my_dict

fp = open_file()

print(build_dictionary(fp))