需求:
分析一个进程的cpu负载高的问题时,需要使用pidin实时打印出该进程的子线程消耗的CPU时间,因此需要写一个python程序将pidin打印的log文本中的子线程消耗的CPU时间的数据提取出来并统计到excel表格中,从而找出消耗CPU时间多的子线程
实现步骤
1、添加test_dvr.sh脚本定时打印DVR的状态
2、在启动脚本中运行
3、下载PyCharm 和python解释器(自行百度)
4、测试pycharm是否可以正常运行
5、将附件代码(main.py)复制到pycharm中
# coding=UTF-8
import xlrd
import xlwt
from xlutils.copy import copy
def write_excel_xls(path, sheet_name, value):
index = len(value) # 获取需要写入数据的行数
workbook = xlwt.Workbook() # 新建一个工作簿
sheet = workbook.add_sheet(sheet_name) # 在工作簿中新建一个表格
for i in range(0, index):
for j in range(0, len(value[i])):
sheet.write(i, j, value[i][j]) # 像表格中写入数据(对应的行和列)
workbook.save(path) # 保存工作簿
print("xls格式表格写入数据成功!")
def write_excel_xls_append(path, value, j):
index = len(value) # 获取需要写入数据的行数
print(index)
workbook = xlrd.open_workbook(path) # 打开工作簿
sheets = workbook.sheet_names() # 获取工作簿中的所有表格
worksheet = workbook.sheet_by_name(sheets[0]) # 获取工作簿中所有表格中的的第一个表格
# rows_old = worksheet.nrows # 获取表格中已存在的数据的行数
rows_old = 1 # 获取表格中已存在的数据的行数
new_workbook = copy(workbook) # 将xlrd对象拷贝转化为xlwt对象
new_worksheet = new_workbook.get_sheet(0) # 获取转化后工作簿中的第一个表格
for i in range(0, index):
print(i)
print(value[i])
new_worksheet.write(i + rows_old, j, str(value[i])) # 追加写入数据,注意是从i+rows_old行开始写入
new_workbook.save(path) # 保存工作簿
print("xls格式表格【追加】写入数据成功!")
def read_excel_xls(path):
workbook = xlrd.open_workbook(path) # 打开工作簿
sheets = workbook.sheet_names() # 获取工作簿中的所有表格
worksheet = workbook.sheet_by_name(sheets[0]) # 获取工作簿中所有表格中的的第一个表格
for i in range(0, worksheet.nrows):
for j in range(0, worksheet.ncols):
print(worksheet.cell_value(i, j), "\t", end="") # 逐行逐列读取数据
print()
if __name__ == "__main__":
file = open("test_dvr.log")
useful_data_tag = 0
hogs_time = []
tid1 = []
tid2 = []
tid3 = []
tid4 = []
tid5 = []
tid6 = []
tid7 = []
tid8 = []
tid9 = []
tid10 = []
tid11 = []
tid12 = []
tid13 = []
tid14 = []
tid15 = []
tid16 = []
tid17 = []
tid18 = []
tid19 = []
tid20 = []
tid21 = []
tid22 = []
tid23 = []
tid24 = []
tid25 = []
tid26 = []
tid27 = []
tid28 = []
tid29 = []
tid30 = []
tid31 = []
tid32 = []
tid33 = []
tid34 = []
tid35 = []
tid36 = []
tid37 = []
tid38 = []
tid39 = []
tid40 = []
tid41 = []
tid42 = []
tid43 = []
tid44 = []
tid45 = []
tid46 = []
tid47 = []
tid48 = []
tid49 = []
tid50 = []
tid51 = []
tid52 = []
tid53 = []
tid54 = []
tid55 = []
tid56 = []
tid57 = []
tid58 = []
tid59 = []
tid60 = []
tid61 = []
tid62 = []
tid63 = []
tid64 = []
tid65 = []
tid66 = []
tid67 = []
tid68 = []
tid69 = []
tid70 = []
tid71 = []
tid72 = []
tid73 = []
tid74 = []
tid75 = []
tid76 = []
tid77 = []
tid78 = []
tid79 = []
tid80 = []
tid81 = []
tid82 = []
tid83 = []
tid84 = []
tid85 = []
for idx, line in enumerate(file.readlines()):
if line.find("sutime") != -1:
useful_data_tag = 1
elif line.find("Blocked") != -1:
useful_data_tag = 0
if len(tid2) != len(tid1):
tid2.append("not exist")
if len(tid3) != len(tid1):
tid3.append("not exist")
if len(tid4) != len(tid1):
tid4.append("not exist")
if len(tid5) != len(tid1):
tid5.append("not exist")
if len(tid6) != len(tid1):
tid6.append("not exist")
if len(tid7) != len(tid1):
tid7.append("not exist")
if len(tid8) != len(tid1):
tid8.append("not exist")
if len(tid9) != len(tid1):
tid9.append("not exist")
if len(tid10) != len(tid1):
tid10.append("not exist")
if len(tid11) != len(tid1):
tid11.append("not exist")
if len(tid12) != len(tid1):
tid12.append("not exist")
if len(tid13) != len(tid1):
tid13.append("not exist")
if len(tid14) != len(tid1):
tid14.append("not exist")
if len(tid15) != len(tid1):
tid15.append("not exist")
if len(tid16) != len(tid1):
tid16.append("not exist")
if len(tid17) != len(tid1):
tid17.append("not exist")
if len(tid18) != len(tid1):
tid18.append("not exist")
if len(tid19) != len(tid1):
tid19.append("not exist")
if len(tid20) != len(tid1):
tid20.append("not exist")
if len(tid21) != len(tid1):
tid21.append("not exist")
if len(tid22) != len(tid1):
tid22.append("not exist")
if len(tid23) != len(tid1):
tid23.append("not exist")
if len(tid24) != len(tid1):
tid24.append("not exist")
if len(tid25) != len(tid1):
tid25.append("not exist")
if len(tid26) != len(tid1):
tid26.append("not exist")
if len(tid27) != len(tid1):
tid27.append("not exist")
if len(tid28) != len(tid1):
tid28.append("not exist")
if len(tid29) != len(tid1):
tid29.append("not exist")
if len(tid30) != len(tid1):
tid30.append("not exist")
if len(tid31) != len(tid1):
tid31.append("not exist")
if len(tid32) != len(tid1):
tid32.append("not exist")
if len(tid33) != len(tid1):
tid33.append("not exist")
if len(tid34) != len(tid1):
tid34.append("not exist")
if len(tid35) != len(tid1):
tid35.append("not exist")
if len(tid36) != len(tid1):
tid36.append("not exist")
if len(tid37) != len(tid1):
tid37.append("not exist")
if len(tid38) != len(tid1):
tid38.append("not exist")
if len(tid39) != len(tid1):
tid39.append("not exist")
if len(tid40) != len(tid1):
tid40.append("not exist")
if len(tid41) != len(tid1):
tid41.append("not exist")
if len(tid42) != len(tid1):
tid42.append("not exist")
if len(tid43) != len(tid1):
tid43.append("not exist")
if len(tid44) != len(tid1):
tid44.append("not exist")
if len(tid45) != len(tid1):
tid45.append("not exist")
if len(tid46) != len(tid1):
tid46.append("not exist")
if len(tid47) != len(tid1):
tid47.append("not exist")
if len(tid48) != len(tid1):
tid48.append("not exist")
if len(tid49) != len(tid1):
tid49.append("not exist")
if len(tid50) != len(tid1):
tid50.append("not exist")
if len(tid51) != len(tid1):
tid51.append("not exist")
if len(tid52) != len(tid1):
tid52.append("not exist")
if len(tid53) != len(tid1):
tid53.append("not exist")
if len(tid54) != len(tid1):
tid54.append("not exist")
if len(tid55) != len(tid1):
tid55.append("not exist")
if len(tid56) != len(tid1):
tid56.append("not exist")
if len(tid57) != len(tid1):
tid57.append("not exist")
if len(tid58) != len(tid1):
tid58.append("not exist")
if len(tid59) != len(tid1):
tid59.append("not exist")
if len(tid60) != len(tid1):
tid60.append("not exist")
if len(tid61) != len(tid1):
tid61.append("not exist")
if len(tid62) != len(tid1):
tid62.append("not exist")
if len(tid63) != len(tid1):
tid63.append("not exist")
if len(tid64) != len(tid1):
tid64.append("not exist")
if len(tid65) != len(tid1):
tid65.append("not exist")
if len(tid66) != len(tid1):
tid66.append("not exist")
if len(tid67) != len(tid1):
tid67.append("not exist")
if len(tid68) != len(tid1):
tid68.append("not exist")
if len(tid69) != len(tid1):
tid69.append("not exist")
if len(tid70) != len(tid1):
tid70.append("not exist")
if len(tid71) != len(tid1):
tid71.append("not exist")
if len(tid72) != len(tid1):
tid72.append("not exist")
if len(tid73) != len(tid1):
tid73.append("not exist")
if len(tid74) != len(tid1):
tid74.append("not exist")
if len(tid75) != len(tid1):
tid75.append("not exist")
if len(tid76) != len(tid1):
tid76.append("not exist")
if len(tid77) != len(tid1):
tid77.append("not exist")
if len(tid78) != len(tid1):
tid78.append("not exist")
if len(tid79) != len(tid1):
tid79.append("not exist")
if len(tid80) != len(tid1):
tid80.append("not exist")
if len(tid81) != len(tid1):
tid81.append("not exist")
if len(tid82) != len(tid1):
tid82.append("not exist")
if len(tid83) != len(tid1):
tid83.append("not exist")
if len(tid84) != len(tid1):
tid84.append("not exist")
if len(tid85) != len(tid1):
tid85.append("not exist")
elif line.find("Test_DVR_CPU ") != -1:
hogs_time.append(line[-9:-1])
elif useful_data_tag == 1:
if line[0:12] == " 1732723 1":
if line[-7:-1].find("m") != -1:
tid1.append(int(line[-7:-5])*60 + int(line[-4:-2]))
else:
tid1.append(line[-7:-1])
elif line[0:12] == " 1732723 2":
if line[-7:-1].find("m") != -1:
tid2.append(int(line[-7:-5])*60 + int(line[-4:-2]))
else:
tid2.append(line[-7:-1])
elif line[0:12] == " 1732723 3":
if line[-7:-1].find("m") != -1:
tid3.append(int(line[-7:-5])*60 + int(line[-4:-2]))
else:
tid3.append(line[-7:-1])
elif line[0:12] == " 1732723 4":
if line[-7:-1].find("m") != -1:
tid4.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid4.append(line[-7:-1])
elif line[0:12] == " 1732723 5":
if line[-7:-1].find("m") != -1:
tid5.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid5.append(line[-7:-1])
elif line[0:12] == " 1732723 6":
if line[-7:-1].find("m") != -1:
tid6.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid6.append(line[-7:-1])
elif line[0:12] == " 1732723 7":
if line[-7:-1].find("m") != -1:
tid7.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid7.append(line[-7:-1])
elif line[0:12] == " 1732723 8":
if line[-7:-1].find("m") != -1:
tid8.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid8.append(line[-7:-1])
elif line[0:12] == " 1732723 9":
if line[-7:-1].find("m") != -1:
tid9.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid9.append(line[-7:-1])
elif line[0:12] == " 1732723 10":
if line[-7:-1].find("m") != -1:
tid10.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid10.append(line[-7:-1])
elif line[0:12] == " 1732723 11":
if line[-7:-1].find("m") != -1:
tid11.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid11.append(line[-7:-1])
elif line[0:12] == " 1732723 12":
if line[-7:-1].find("m") != -1:
tid12.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid12.append(line[-7:-1])
elif line[0:12] == " 1732723 13":
if line[-7:-1].find("m") != -1:
tid13.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid13.append(line[-7:-1])
elif line[0:12] == " 1732723 14":
if line[-7:-1].find("m") != -1:
tid14.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid14.append(line[-7:-1])
elif line[0:12] == " 1732723 15":
if line[-7:-1].find("m") != -1:
tid15.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid15.append(line[-7:-1])
elif line[0:12] == " 1732723 16":
if line[-7:-1].find("m") != -1:
tid16.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid16.append(line[-7:-1])
elif line[0:12] == " 1732723 17":
if line[-7:-1].find("m") != -1:
tid17.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid17.append(line[-7:-1])
elif line[0:12] == " 1732723 18":
if line[-7:-1].find("m") != -1:
tid18.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid18.append(line[-7:-1])
elif line[0:12] == " 1732723 19":
if line[-7:-1].find("m") != -1:
tid19.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid19.append(line[-7:-1])
elif line[0:12] == " 1732723 20":
if line[-7:-1].find("m") != -1:
tid20.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid20.append(line[-7:-1])
elif line[0:12] == " 1732723 21":
if line[-7:-1].find("m") != -1:
tid21.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid21.append(line[-7:-1])
elif line[0:12] == " 1732723 22":
if line[-7:-1].find("m") != -1:
tid22.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid22.append(line[-7:-1])
elif line[0:12] == " 1732723 23":
if line[-7:-1].find("m") != -1:
tid23.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid23.append(line[-7:-1])
elif line[0:12] == " 1732723 24":
if line[-7:-1].find("m") != -1:
tid24.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid24.append(line[-7:-1])
elif line[0:12] == " 1732723 25":
if line[-7:-1].find("m") != -1:
tid25.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid25.append(line[-7:-1])
elif line[0:12] == " 1732723 26":
if line[-7:-1].find("m") != -1:
tid26.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid26.append(line[-7:-1])
elif line[0:12] == " 1732723 27":
if line[-7:-1].find("m") != -1:
tid27.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid27.append(line[-7:-1])
elif line[0:12] == " 1732723 28":
if line[-7:-1].find("m") != -1:
tid28.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid28.append(line[-7:-1])
elif line[0:12] == " 1732723 29":
if line[-7:-1].find("m") != -1:
tid29.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid29.append(line[-7:-1])
elif line[0:12] == " 1732723 30":
if line[-7:-1].find("m") != -1:
tid30.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid30.append(line[-7:-1])
elif line[0:12] == " 1732723 31":
if line[-7:-1].find("m") != -1:
tid31.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid31.append(line[-7:-1])
elif line[0:12] == " 1732723 32":
if line[-7:-1].find("m") != -1:
tid32.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid32.append(line[-7:-1])
elif line[0:12] == " 1732723 33":
if line[-7:-1].find("m") != -1:
tid33.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid33.append(line[-7:-1])
elif line[0:12] == " 1732723 34":
if line[-7:-1].find("m") != -1:
tid34.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid34.append(line[-7:-1])
elif line[0:12] == " 1732723 35":
if line[-7:-1].find("m") != -1:
tid35.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid35.append(line[-7:-1])
elif line[0:12] == " 1732723 36":
if line[-7:-1].find("m") != -1:
tid36.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid36.append(line[-7:-1])
elif line[0:12] == " 1732723 37":
if line[-7:-1].find("m") != -1:
tid37.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid37.append(line[-7:-1])
elif line[0:12] == " 1732723 38":
if line[-7:-1].find("m") != -1:
tid38.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid38.append(line[-7:-1])
elif line[0:12] == " 1732723 39":
if line[-7:-1].find("m") != -1:
tid39.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid39.append(line[-7:-1])
elif line[0:12] == " 1732723 40":
if line[-7:-1].find("m") != -1:
tid40.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid40.append(line[-7:-1])
elif line[0:12] == " 1732723 41":
if line[-7:-1].find("m") != -1:
tid41.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid41.append(line[-7:-1])
elif line[0:12] == " 1732723 42":
if line[-7:-1].find("m") != -1:
tid42.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid42.append(line[-7:-1])
elif line[0:12] == " 1732723 43":
if line[-7:-1].find("m") != -1:
tid43.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid43.append(line[-7:-1])
elif line[0:12] == " 1732723 44":
if line[-7:-1].find("m") != -1:
tid44.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid44.append(line[-7:-1])
elif line[0:12] == " 1732723 45":
if line[-7:-1].find("m") != -1:
tid45.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid45.append(line[-7:-1])
elif line[0:12] == " 1732723 46":
if line[-7:-1].find("m") != -1:
tid46.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid46.append(line[-7:-1])
elif line[0:12] == " 1732723 47":
if line[-7:-1].find("m") != -1:
tid47.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid47.append(line[-7:-1])
elif line[0:12] == " 1732723 48":
if line[-7:-1].find("m") != -1:
tid48.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid48.append(line[-7:-1])
elif line[0:12] == " 1732723 49":
if line[-7:-1].find("m") != -1:
tid49.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid49.append(line[-7:-1])
elif line[0:12] == " 1732723 50":
if line[-7:-1].find("m") != -1:
tid50.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid50.append(line[-7:-1])
elif line[0:12] == " 1732723 51":
if line[-7:-1].find("m") != -1:
tid51.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid51.append(line[-7:-1])
elif line[0:12] == " 1732723 52":
if line[-7:-1].find("m") != -1:
tid52.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid52.append(line[-7:-1])
elif line[0:12] == " 1732723 53":
if line[-7:-1].find("m") != -1:
tid53.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid53.append(line[-7:-1])
elif line[0:12] == " 1732723 54":
if line[-7:-1].find("m") != -1:
tid54.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid54.append(line[-7:-1])
elif line[0:12] == " 1732723 55":
if line[-7:-1].find("m") != -1:
tid55.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid55.append(line[-7:-1])
elif line[0:12] == " 1732723 56":
if line[-7:-1].find("m") != -1:
tid56.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid56.append(line[-7:-1])
elif line[0:12] == " 1732723 57":
if line[-7:-1].find("m") != -1:
tid57.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid57.append(line[-7:-1])
elif line[0:12] == " 1732723 58":
if line[-7:-1].find("m") != -1:
tid58.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid58.append(line[-7:-1])
elif line[0:12] == " 1732723 59":
if line[-7:-1].find("m") != -1:
tid59.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid59.append(line[-7:-1])
elif line[0:12] == " 1732723 60":
if line[-7:-1].find("m") != -1:
tid60.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid60.append(line[-7:-1])
elif line[0:12] == " 1732723 61":
if line[-7:-1].find("m") != -1:
tid61.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid61.append(line[-7:-1])
elif line[0:12] == " 1732723 62":
if line[-7:-1].find("m") != -1:
tid62.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid62.append(line[-7:-1])
elif line[0:12] == " 1732723 63":
if line[-7:-1].find("m") != -1:
tid63.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid63.append(line[-7:-1])
elif line[0:12] == " 1732723 64":
if line[-7:-1].find("m") != -1:
tid64.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid64.append(line[-7:-1])
elif line[0:12] == " 1732723 65":
if line[-7:-1].find("m") != -1:
tid65.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid65.append(line[-7:-1])
elif line[0:12] == " 1732723 66":
if line[-7:-1].find("m") != -1:
tid66.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid66.append(line[-7:-1])
elif line[0:12] == " 1732723 67":
if line[-7:-1].find("m") != -1:
tid67.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid67.append(line[-7:-1])
elif line[0:12] == " 1732723 68":
if line[-7:-1].find("m") != -1:
tid68.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid68.append(line[-7:-1])
elif line[0:12] == " 1732723 69":
if line[-7:-1].find("m") != -1:
tid69.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid69.append(line[-7:-1])
elif line[0:12] == " 1732723 70":
if line[-7:-1].find("m") != -1:
tid70.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid70.append(line[-7:-1])
elif line[0:12] == " 1732723 71":
if line[-7:-1].find("m") != -1:
tid71.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid71.append(line[-7:-1])
elif line[0:12] == " 1732723 72":
if line[-7:-1].find("m") != -1:
tid72.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid72.append(line[-7:-1])
elif line[0:12] == " 1732723 73":
if line[-7:-1].find("m") != -1:
tid73.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid73.append(line[-7:-1])
elif line[0:12] == " 1732723 74":
if line[-7:-1].find("m") != -1:
tid74.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid74.append(line[-7:-1])
elif line[0:12] == " 1732723 75":
if line[-7:-1].find("m") != -1:
tid75.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid75.append(line[-7:-1])
elif line[0:12] == " 1732723 76":
if line[-7:-1].find("m") != -1:
tid76.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid76.append(line[-7:-1])
elif line[0:12] == " 1732723 77":
if line[-7:-1].find("m") != -1:
tid77.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid77.append(line[-7:-1])
elif line[0:12] == " 1732723 78":
if line[-7:-1].find("m") != -1:
tid78.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid78.append(line[-7:-1])
elif line[0:12] == " 1732723 79":
if line[-7:-1].find("m") != -1:
tid79.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid79.append(line[-7:-1])
elif line[0:12] == " 1732723 80":
if line[-7:-1].find("m") != -1:
tid80.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid80.append(line[-7:-1])
elif line[0:12] == " 1732723 81":
if line[-7:-1].find("m") != -1:
tid81.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid81.append(line[-7:-1])
elif line[0:12] == " 1732723 82":
if line[-7:-1].find("m") != -1:
tid82.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid82.append(line[-7:-1])
elif line[0:12] == " 1732723 83":
if line[-7:-1].find("m") != -1:
tid83.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid83.append(line[-7:-1])
elif line[0:12] == " 1732723 84":
if line[-7:-1].find("m") != -1:
tid84.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid84.append(line[-7:-1])
elif line[0:12] == " 1732723 85":
if line[-7:-1].find("m") != -1:
tid85.append(int(line[-7:-5]) * 60 + int(line[-4:-2]))
else:
tid85.append(line[-7:-1])
book_name_xls = '测试值.xls'
sheet_name_xls = '测试值表'
value_title = [
["time","tid1", "tid2", "tid3", "tid4", "tid5", "tid6", "tid7", "tid8", "tid9", "tid10", "tid11", "tid12", "tid13", "tid14", "tid15", "tid16", "tid17", "tid18", "tid19", "tid20", "tid21", "tid22", "tid23", "tid24", "tid25", "tid26", "tid27", "tid28", "tid29", "tid30", "tid31", "tid32", "tid33", "tid34", "tid35", "tid36", "tid37", "tid38", "tid39", "tid40", "tid41", "tid42", "tid43", "tid44", "tid45", "tid46", "tid47", "tid48", "tid49", "tid50", "tid51", "tid52", "tid53", "tid54", "tid55", "tid56", "tid57", "tid58", "tid59", "tid60", "tid61", "tid62", "tid63", "tid64", "tid65", "tid66", "tid67", "tid68", "tid69", "tid70", "tid71", "tid72", "tid73", "tid74", "tid75", "tid76", "tid77", "tid78", "tid79", "tid80", "tid81", "tid82", "tid83", "tid84", "tid85", ], ]
write_excel_xls(book_name_xls, sheet_name_xls, value_title)
write_excel_xls_append(book_name_xls, hogs_time, 0)
write_excel_xls_append(book_name_xls, tid1, 1)
write_excel_xls_append(book_name_xls, tid2, 2)
write_excel_xls_append(book_name_xls, tid3, 3)
write_excel_xls_append(book_name_xls, tid4, 4)
write_excel_xls_append(book_name_xls, tid5, 5)
write_excel_xls_append(book_name_xls, tid6, 6)
write_excel_xls_append(book_name_xls, tid7, 7)
write_excel_xls_append(book_name_xls, tid8, 8)
write_excel_xls_append(book_name_xls, tid9, 9)
write_excel_xls_append(book_name_xls, tid10, 10)
write_excel_xls_append(book_name_xls, tid11, 11)
write_excel_xls_append(book_name_xls, tid12, 12)
write_excel_xls_append(book_name_xls, tid13, 13)
write_excel_xls_append(book_name_xls, tid14, 14)
write_excel_xls_append(book_name_xls, tid15, 15)
write_excel_xls_append(book_name_xls, tid16, 16)
write_excel_xls_append(book_name_xls, tid17, 17)
write_excel_xls_append(book_name_xls, tid18, 18)
write_excel_xls_append(book_name_xls, tid19, 19)
write_excel_xls_append(book_name_xls, tid20, 20)
write_excel_xls_append(book_name_xls, tid21, 21)
write_excel_xls_append(book_name_xls, tid22, 22)
write_excel_xls_append(book_name_xls, tid23, 23)
write_excel_xls_append(book_name_xls, tid24, 24)
write_excel_xls_append(book_name_xls, tid25, 25)
write_excel_xls_append(book_name_xls, tid26, 26)
write_excel_xls_append(book_name_xls, tid27, 27)
write_excel_xls_append(book_name_xls, tid28, 28)
write_excel_xls_append(book_name_xls, tid29, 29)
write_excel_xls_append(book_name_xls, tid30, 30)
write_excel_xls_append(book_name_xls, tid31, 31)
write_excel_xls_append(book_name_xls, tid32, 32)
write_excel_xls_append(book_name_xls, tid33, 33)
write_excel_xls_append(book_name_xls, tid34, 34)
write_excel_xls_append(book_name_xls, tid35, 35)
write_excel_xls_append(book_name_xls, tid36, 36)
write_excel_xls_append(book_name_xls, tid37, 37)
write_excel_xls_append(book_name_xls, tid38, 38)
write_excel_xls_append(book_name_xls, tid39, 39)
write_excel_xls_append(book_name_xls, tid40, 40)
write_excel_xls_append(book_name_xls, tid41, 41)
write_excel_xls_append(book_name_xls, tid42, 42)
write_excel_xls_append(book_name_xls, tid43, 43)
write_excel_xls_append(book_name_xls, tid44, 44)
write_excel_xls_append(book_name_xls, tid45, 45)
write_excel_xls_append(book_name_xls, tid46, 46)
write_excel_xls_append(book_name_xls, tid47, 47)
write_excel_xls_append(book_name_xls, tid48, 48)
write_excel_xls_append(book_name_xls, tid49, 49)
write_excel_xls_append(book_name_xls, tid50, 50)
write_excel_xls_append(book_name_xls, tid51, 51)
write_excel_xls_append(book_name_xls, tid52, 52)
write_excel_xls_append(book_name_xls, tid53, 53)
write_excel_xls_append(book_name_xls, tid54, 54)
write_excel_xls_append(book_name_xls, tid55, 55)
write_excel_xls_append(book_name_xls, tid56, 56)
write_excel_xls_append(book_name_xls, tid57, 57)
write_excel_xls_append(book_name_xls, tid58, 58)
write_excel_xls_append(book_name_xls, tid59, 59)
write_excel_xls_append(book_name_xls, tid60, 60)
write_excel_xls_append(book_name_xls, tid61, 61)
write_excel_xls_append(book_name_xls, tid62, 62)
write_excel_xls_append(book_name_xls, tid63, 63)
write_excel_xls_append(book_name_xls, tid64, 64)
write_excel_xls_append(book_name_xls, tid65, 65)
write_excel_xls_append(book_name_xls, tid66, 66)
write_excel_xls_append(book_name_xls, tid67, 67)
write_excel_xls_append(book_name_xls, tid68, 68)
write_excel_xls_append(book_name_xls, tid69, 69)
write_excel_xls_append(book_name_xls, tid70, 70)
write_excel_xls_append(book_name_xls, tid71, 71)
write_excel_xls_append(book_name_xls, tid72, 72)
write_excel_xls_append(book_name_xls, tid73, 73)
write_excel_xls_append(book_name_xls, tid74, 74)
write_excel_xls_append(book_name_xls, tid75, 75)
write_excel_xls_append(book_name_xls, tid76, 76)
write_excel_xls_append(book_name_xls, tid77, 77)
write_excel_xls_append(book_name_xls, tid78, 78)
write_excel_xls_append(book_name_xls, tid79, 79)
write_excel_xls_append(book_name_xls, tid80, 80)
write_excel_xls_append(book_name_xls, tid81, 81)
write_excel_xls_append(book_name_xls, tid82, 82)
write_excel_xls_append(book_name_xls, tid83, 83)
write_excel_xls_append(book_name_xls, tid84, 84)
write_excel_xls_append(book_name_xls, tid85, 85)
6、使用pip安装引用的库
pip install xlrd
pip install xlwt
pip install xlutils
7、将test_dvr.sh脚本抓到的log文件test_dvr.log拷贝到python项目的文件夹中
8、根据线程数量和进程id合理修改代码
9、运行pycharm项目,会在项目文件夹生成.xls文件
10、打开.xls文件,会发现每个单元格左上角都有一个绿三角形,这是因为这些数字都是字符串类型,而非数字类型,需要转换。
从右下角的最后一个单元格选中往左上角拖,然后点击如下图