python数据处理（excel）（1）

2019-2020学年度奖状分统计

import xlrd
import xlwt

dic = {}
data = xlrd.open_workbook('2019-2020学年度奖状分统计20200917.xlsx')
table = data.sheet_by_name(data.sheet_names()[0])
for i in range(1,len(table.col_values(0))):
    try:
        dic[table.col_values(0)[i]] += float(table.col_values(4)[i])
    except:
        dic[table.col_values(0)[i]] = float(table.col_values(4)[i])

index = len(dic.keys())  
workbook = xlwt.Workbook()  
sheet = workbook.add_sheet('Sheet1')
i=0
for name in dic.keys():
    sheet.write(i, 0, name)
    sheet.write(i, 1, dic[name])
    i += 1
workbook.save('2019-2020学年度奖状分统计总分20200917.xls')

---

源文件下载