统计通话时长的python代码

import xlrd

import time

# 存放文件的路径

filepath = ‘/home/bill/Desktop/list(201504).xls’

def run():

# 打开表格

xls = xlrd.open_workbook(filepath)

sheet = xls.sheet_by_index(0)

initiative_call = 0

passtive_call = 0

# 遍历表格，查到类型为被叫或主叫的行，记录通话时长

for i in range(3, ws):

rv = w_values(i)

e通话 if rv[2] == u'被叫':

struct_time = time.strptime(rv[5], "%H:%M:%S")

passtive_call += _hour * 3600 + _min * 60 + _sec

if rv[2] == u'主叫':

struct_time = time.strptime(rv[5], "%H:%M:%S")

initiative_call += _hour * 3600 + _min * 60 + _sec

print ‘主叫时长：%d分钟’% (initiative_call/60)

print ‘被叫时长：%d分钟’% (passtive_call/60)

print ‘总通话时长：%d分钟’% ((passtive_call+initiative_call)/60)

if __name__ =="__main__":

run()

本文发布于:2024-09-22 06:38:14，感谢您对本站的认可！

标签：通话表格类型

留言与评论（共有 0 条评论）