python - 从文件中提取成绩？

Question

我最近在 python 中得到了一项家庭作业，我必须制作一个假学生 ID 的字典，并将各种家庭作业的相应成绩放入一个嵌套字典中。我可以毫无问题地制作带有他们 ID 的字典，但我似乎无法将他们相应的成绩放入其中。文件内容的一个例子是:

807-49-0073
658-30-1272
544-78-7923
709-40-8165
492-42-7987
503-27-1729
840-12-4303
169-09-7157
560-33-3099
278-16-5335
097-26-3512
267-10-7633
979-49-6579
821-67-0672
393-36-5485

然后是他们的 ID 和成绩:

267-10-7633 66
709-40-8165 71
097-26-3512 78
807-49-0073 83
169-09-7157 73
278-16-5335 79
979-49-6579 79
544-78-7923 85
560-33-3099 73
840-12-4303 62
821-67-0672 87
503-27-1729 8
267-10-7633 85
979-49-6579 60
503-27-1729 62
821-67-0672 62
393-36-5485 15
560-33-3099 38
097-26-3512 80
658-30-1272 85
278-16-5335 84
169-09-7157 70
840-12-4303 73
544-78-7923 60
560-33-3099 87
840-12-4303 75
979-49-6579 96
492-42-7987 85
544-78-7923 72
169-09-7157 82
278-16-5335 67
709-40-8165 96
393-36-5485 87
097-26-3512 85
821-67-0672 86
278-16-5335 97
393-36-5485 73
503-27-1729 78
979-49-6579 24
821-67-0672 87
544-78-7923 73
709-40-8165 34
097-26-3512 73
840-12-4303 100
807-49-0073 75
267-10-7633 74
658-30-1272 94
492-42-7987 87

所以我需要取最后一位2位数字和对应的学生放在一起。有些是重复的。到目前为止，这是我的代码，但我目前卡住了。

def create_dictionary(idfilename, hwfilename):
    hwL = []
    dict1 = {}
    dict2 = {'hw': hwL}

    ids = open(idfilename, 'r').read().splitlines()
    hws = open(hwfilename, 'r').read().splitlines()

    for i in ids:
        dict1[i] = dict1.get(i, dict2)

    for k in hws:
        hwL = k.split(' ')

Answer 1

我现在无法调试，但这应该很接近:

import csv
#assuming the files are .csvs
def create_dictionary(idfilename, hwfilename):
    #declare the field names of the dictionaries so we can refer to them later
    field_names1 = ['id']
    field_names2 = ['id','grade']
    dictOf_Ids = csv.DictReader(open(idfilename,fieldnames=field_names1))
    dictOf_hw = csv.DictReader(open(hwfilename,fieldnames=field_names2))
    #will look something like this: [{'id':'560-33-3099','grades':[76,56,42]}]
    listOf_dictionaries =[{}]   

    #read through the records in the id dictionary line by line
    for id in dictOf_Ids:
        #each id will have its own list of grades
        grades = []
        #read through the records in the hw dictionary line by line
        for hw in dictOf_hw:
            #if the ids match, get the grade from the hw dict and add it to our list of grades for that id
            if id.get('id') == hw.get('id'):
                grade = hw.get('grade')
                grades.append(grade)
            else:
                #do nothing because the id's don't match
                pass
        #add the dictionary to the list
        dict = {'id':id,'grades':grades}
        listOf_dictionaries.append(dict)