蕭瑜期末考
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]) 原來 修改後