python数据处理代码暂存

import xlwings as xw
import numpy
app &＃61; xw.App(visible&＃61;True,add_book&＃61;False)
#打开lineDetial_20211213174707699表处理数据
lineDetial_20211213174707699 &＃61; app.books.open(&＃39;lineDetial_20211213174707699.xlsx&＃39;)
lineDetial_20211213174707699Sheet1 &＃61; lineDetial_20211213174707699.sheets[&＃39;线路信息导出&＃39;]
lineDetial_20211213174707699Sheet1GongDianJu &＃61; lineDetial_20211213174707699Sheet1.range(&＃39;A2&＃39;,&＃39;A7009&＃39;).value
lineDetial_20211213174707699Sheet1XianLuMingCheng &＃61; lineDetial_20211213174707699Sheet1.range(&＃39;B2&＃39;,&＃39;B7009&＃39;).value
lineDetial_20211213174707699Sheet1ZongChangDu &＃61; lineDetial_20211213174707699Sheet1.range(&＃39;H2&＃39;,&＃39;H7009&＃39;).value
lineDetial_20211213174707699Sheet1ZongChangDuArray &＃61; numpy.array(lineDetial_20211213174707699Sheet1ZongChangDu)
#print(lineDetial_20211213174707699Sheet1ZongChangDuArray)
for i in range(0,7008):tempLineDetial &＃61; numpy.array([lineDetial_20211213174707699Sheet1XianLuMingCheng[i],lineDetial_20211213174707699Sheet1ZongChangDu[i]])#print(tempLineDetial)
#print(lineDetial_20211213174707699Sheet1GongDianJu)
#print(lineDetial_20211213174707699Sheet1ZongChangDu)
#print(lineDetial_20211213174707699Sheet1XianLuMingCheng)
#打开2021_01_01-2021_12_13-任务统计表表处理数据
taskStatistics &＃61; app.books.open(&＃39;2021_01_01-2021_12_13-任务统计表.xlsx&＃39;)
taskStatisticsSheet1 &＃61; taskStatistics.sheets[&＃39;统计报表&＃39;]
taskStatisticsSheet2 &＃61; taskStatistics.sheets[&＃39;缺陷数据1&＃39;]
taskStatisticsSheet3 &＃61; taskStatistics.sheets[&＃39;缺陷数据2&＃39;]
taskStatisticsSheet3GongDianJu &＃61; taskStatisticsSheet3.range(&＃39;A2&＃39;,&＃39;A8939&＃39;).value
taskStatisticsSheet3XianLu &＃61; taskStatisticsSheet3.range(&＃39;E2&＃39;,&＃39;E8939&＃39;).valuevector &＃61; numpy.array(taskStatisticsSheet3GongDianJu)
vectorXianLu &＃61; numpy.array(taskStatisticsSheet3XianLu)
vectorLineXianLu &＃61; numpy.array(lineDetial_20211213174707699Sheet1XianLuMingCheng)
vectorLineXianluChangDuArray &＃61; numpy.array(lineDetial_20211213174707699Sheet1ZongChangDu)
#去掉数组中重复的元素&＃xff0c;统计线路的种类个数
vectorXianLuUnique &＃61; numpy.unique(taskStatisticsSheet3XianLu)
#print(numpy.size(vectorXianLuUnique))
vectorXianLuUnique &＃61; numpy.array(vectorXianLuUnique)
#print(vectorXianLuUnique)
#计算各个线路的故障数
for i in vectorXianLuUnique:temp &＃61; numpy.where(vectorXianLu &＃61;&＃61; i)tempL &＃61; numpy.where(vectorLineXianLu &＃61;&＃61; i)tempU &＃61; numpy.where(vectorXianLuUnique &＃61;&＃61; i)#print(tempU,&＃39;unique&＃39;,i)#print(tempL,&＃39;Line&＃39;)tempLong &＃61; vectorLineXianluChangDuArray[tempL[0]]resultVector &＃61; numpy.array([i,&＃39;故障数量&＃39;,numpy.size(temp),&＃39;线路长度&＃39;,tempLong,&＃39;故障率&＃39;,numpy.size(temp)/tempLong])print(resultVector)
tempVector &＃61; numpy.zeros((427,2))
for i in range(0,427):temp &＃61; numpy.where(vectorXianLu &＃61;&＃61; vectorXianLuUnique[i])tempVector[i][0] &＃61; itempVector[i][1] &＃61; numpy.size(temp)
#print(tempVector)
#for i in range(0, 7008):#tempXianLuMingCheng &＃61; lineDetial_20211213174707699Sheet1XianLuMingCheng[i]#tempLineDetial &＃61; lineDetial_20211213174707699Sheet1ZongChangDu[i]
#print(lineDetial_20211213174707699Sheet1XianLuMingCheng)
#print(numpy.size(lineDetial_20211213174707699Sheet1XianLuMingCheng))
tempGuZhangLv &＃61; numpy.zeros((7009,2))
for i in range(0,7008):tempGuZhangLv[i][0] &＃61; itempGuZhangLv[i][1] &＃61; lineDetial_20211213174707699Sheet1ZongChangDuArray[i]
#print(tempGuZhangLv)
for i in range(0,7008): #遍历lineDetial表中的数据t &＃61; lineDetial_20211213174707699Sheet1XianLuMingCheng[i]#print(t)for j in range(0,427):t2 &＃61; vectorXianLuUnique[j]
lineDetial_20211213174707699.save()
lineDetial_20211213174707699.close()
taskStatistics.save()
taskStatistics.close()
app.quit()