计算对应空行的和输出到单独的CSV文件
结果是这样的(我这里处理了多个上面截图的CSV文件)
下面附代码
import os
import pandas as pd
import numpy as np
import xlwt
workbook = xlwt.Workbook()
sheet = workbook.add_sheet("Sheet Name1")
file_path = "D:\四维\zdh\db1"
path_list = os.listdir(file_path)
path_name=[]
i = 0
# 利用循环历遍path_list列表并且利用split去掉后缀名
for orderid in path_list:
#读取文件
try:#文件不存在跳过
df = pd.read_csv("D:\四维\zdh\db1/"+ orderid +"/RULER_LINE_ABSOLUTE_LANEBOUNDARY_-distinct.csv")
had = df[["feature_length"]]#had上报总数
shen = df[["report_length"]]#识别总数
shen1 = df.query('report_