蕭瑜期末考

import csv #德明科大蕭瑜修改11與16列
f = open('00960.csv','r',encoding='utf-8')
csv_reader = csv.reader(f)
header, rows = [], []
header = next(csv_reader)
for row in csv_reader:
   rows.append(row)
f.close()

idSet = set()
component = dict()

for row in rows:
    for j in range(0, 21):
        idSet.add(row[j*4])

for id in idSet:
    component[id] = [0 for i in range(21)]

for row in rows:
    for j in range(0, 21):
        if row[j*4+3] != '':
            component[row[j*4]][j] = row[j*4 + 3]
            print(row[j*4+1],component[row[j*4]])

for id in idSet:
    print(id, component[id])

原來

修改後