Question

write a function:

Names(path):

that reads from a file at location path and returns a dictionary mapping from column names to lists containing the data in those columns. The format of the file is a csv file. The first line is a comma separated set of string names for the columns contained in the file. The function will accumulate a dictionary mapping from year to the list of years, from name to the list of names (in the same order), and from count to the list of counts (in the same order).Convert year and count to integers.

Python

Answer 1

Here is the completed code for this problem. Comments are included, go through it, learn how things work and let me know if you have any doubts or if you need anything to change. If you are satisfied with the solution, please rate the answer. Thanks

Note: Please maintain proper code spacing (indentation), just copy the code part and paste it in your compiler/IDE directly, no modifications required.

#code

#required method
def Names(path):
    #opening file in read mode, assuming file exists, else this will result
    #in an exception
    file=open(path,'r')
    #creating an empty dict
    result=dict()
    #reading first line and splitting by comma to get a list of column headings
    headers=file.readline().strip().split(',')
    #looping through remaining file
    for line in file:
        #splitting line by comma to get a list of values
        fields=line.strip().split(',')
        #ensuring that there is enough number of values
        if len(headers)==len(fields):
            #looping through each index from 0 to len(headers)-1
            for i in range(len(headers)):
                #getting element at index i as value
                value=fields[i]
                #if value is numeric (year or count), converting it to integer
                if value.strip().isnumeric():
                    value=int(value)
                #if current heading is not a key in result dict, adding to dict with
                #key=headers[i] and value = empty list
                if headers[i] not in result:
                    result[headers[i]]=[]
                #appending current value to the list associated with key=headers[i]
                result[headers[i]].append(value)
    #closing file
    file.close()
    #returning the result
    return result