import pandas as pdimport osimport refrom openpyxl import Workbookoutput_folder = F自动验单数据验本数据output_file = Nonefor filename in oslistdirfolder_path if rematchfile_format filename date_str =

import pandas as pd import os import re from openpyxl import Workbook

output_folder = 'F:/自动验单数据/验本数据/' output_file = None

for filename in os.listdir(folder_path): if re.match(file_format, filename): date_str = filename[11:19] file_path = os.path.join(folder_path, filename) yb_data = pd.read_csv(file_path, dtype=object, usecols=['发验机构', '上下行','发验时间']) data = yb_data[((yb_data['机构'] == '21506') & (yb_data['地市'] == '扬州市') & (yb_data['上下行'] == '上行'))] file_name = date_str + '验本数据.xlsx'

    if output_file is None:
        output_file = os.path.join(output_folder, file_name)
        data.to_excel(output_file, index=False)
    else:
        writer = pd.ExcelWriter(output_file, mode='a', engine='openpyxl')
        writer.book = Workbook()
        writer.sheets = {ws.title: ws for ws in writer.book.worksheets}
        data.to_excel(writer, index=False, header=False, startrow=writer.sheets["Sheet1"].max_row)
        writer.save()

print('匹配完成！'