I have turned my excel file into a csv file on python. I have provided a screens

I have turned my excel file into a csv file on python. I have provided a screenshot of the directory that I have made on python that reads the file. However, I am unsure how to create your own directory that each element in the excel file is a key : value pair. The key is one of the 6 column of data on the excel file. Please help me create this dictionary. Thank you.
To keep in mind when building your dictionary that a few of these values have to be converted into an integer.
The desired outcome is following:
assignmentdata: {‘datesubmission’ : [’09-02-2021’ , ’09-12-2021’ , ’09-15-2021’ , ’09-23-2021’ , ’09–282021’],
‘timesubmission’ : [’21:06’ , ’18:23’ , ’09:36’ , ’22:24’ , ’16:12’],
‘dayinweek’ : [ 3, 5, 1, 2, 7],
‘hourinday’ : [21, 18, 9, 22, 16],
‘assignmentname’ : [‘Cells’ , ’Thermodynamics’ , ‘Kinetics’ , ‘Biopolymers’ , ‘Probability ‘],
’subjectname’ : [‘Biology’ , ‘Chemistry’ , ‘Chemistry’ , ‘Biology’ , ‘Mathematics’ ] }
The dictionary below opens the excel file:
def readingfile(file) :
assignmentlist = {}
print(‘input file is: ‘ + file)
with open(‘data/’ + file) as f:
count = 1
for line in f:
if count > 1 :
assignmentlist = line.replace(‘n’,”).split(‘|’)
information_on_line[2] = int(information_on_line[2])
assignmentlist[count-1] = information_on_list
count += 1
print(‘read a total of ‘, count ,’ lines from file: ‘, file)
return assignmentlist
Make a dictionary that was asked in the assignments directions and paste your code below:
def sortinformation(information) :
sortinfo = {}
for line_no,values in data.items():
for value in values :
#I need help making the rest of this dictionary

Posted in Uncategorized

Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount