import xlrd

import datetime

infos = []

info_file = xlrd.open_workbook('examples.xls')

info_table = info_file.sheets()[0]

row_count = info_table.nrows

for row in range(7, row_count):

time_string = info_table.cell(row, 4).value

time_s_sp = time_string.split(':')

infos.append(

{

'type': info_table.cell(row, 2).value,

'number': info_table.cell(row, 3).value,

'timespan': datetime.timedelta(

seconds=int(time_s_sp[2]),

minutes=int(time_s_sp[1]),

hours=int(time_s_sp[0])),

'class': info_table.cell(row, 5).value

}

)

time_all = datetime.timedelta(seconds=0)

time_types = {}

time_classes = {}

time_numbers = {}

for infor in infos:

time_all += infor['timespan']

infor_type = infor['type']

if infor_type in time_types:

time_types[infor_type] += infor['timespan']

else:

time_types[infor_type] = infor['timespan']

infor_class = infor['class']

if infor_class in time_classes:

time_classes[infor_class] += infor['timespan']

else:

time_classes[infor_class] = infor['timespan']

infor_number = infor['number']

if infor_number in time_numbers:

time_numbers[infor_number] += infor['timespan']

else:

time_numbers[infor_number] = infor['timespan']

print '总通话时间：%s' % time_all

print '通信方式分类：'

for (k, v) in time_types.items():

print k.encode('utf-8'), v

print '通信类型分类：'

for (k, v) in time_classes.items():

print k.encode('utf-8'), v

print '对方号码分类：'

for (k, v) in time_numbers.items():

print k.ljust(20), v

**第 0020 题：** [登陆中国联通网上营业厅](http://iservice.10010.com/index_.html) 后选择「自助服务」 --> 「详单查询」，然后选择你要查询的时间段，点击「查询」按钮，查询结果页面的最下方，点击「导出」，就会生成类似于 2014年10月01日～2014年10月31日通话详单.xls 文件。写代码，对每月通话时间做个统计。

1. 我用移动

2. Excel的效果大概是这样的（私人信息已经涂黑）：

3. 除了统计通话时间，还能根据通话方式/对方号码/通信类型分类汇总

4. 结果是这样的