python 字典数据那么写入到excel中
# coding:utf-8
import xlrd3,xlwt
wb = xlrd3.open_workbook('demo1.xlsx')
ws = wb.sheet_by_name('Sheet1')
r = 0
d = {}
l2 = {}
while r < ws.nrows - 1:
r += 1
key = ws.cell_value(r, 3)
key1 = ws.cell_value(r, 4)
val = ws.cell_value(r, 11)
# print(key,val)
if (key, key1) in d.keys():
d[key, key1] += [val]
else:
d[key, key1] = [val]
for k, v in d.items():
print(k,(v.count(5), v.count(13), len([x for x in v if x > 13])))