范雅惠期末考

import csv #德明科大范雅惠修改11與16列
f = open('00960.csv','r',encoding='utf-8')
csv_reader = csv.reader(f)
header, rows = [], []        #宣告空白串列(陣列,清單)
header = next(csv_reader)     #串列header存放第一列標題
for row in csv_reader:        #逐列讀檔案、附加append於rows串列
   rows.append(row)
f.close()
idSet = set()
component = dict()
#zeros = [0 for i in range(21)] 
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)] #取代原來的zeros
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])

原來

修改後