df = pdDataFramewith openfile_pathrencoding=utf-8 as file nextfile for line in file linesplit = linesplit mailNumber = linesplit0 if df编号 != mailNumberany df编号 =

import pandas as pd

df = pd.DataFrame() with open(file_path, 'r', encoding='utf-8') as file: next(file) for line in file: linesplit = line.split('|') mailNumber = linesplit[0] if (df["编号"] != mailNumber).any(): df = df.append({"编号": mailNumber}, ignore_index=True) # try: if linesplit[3] == "203": sjopTimeStart = linesplit[1] df.loc[df["编号"] == mailNumber, "机构号"] = linesplit[2] df.loc[df["编号"] == mailNumber, "机构名"] = linesplit[5] if (linesplit[2] == "21506000") & (linesplit[3] == "352"): clopTimeStart = linesplit[1] df.loc[df["编号"] == mailNumber, "处理时间"] = clopTimeStart

    if (linesplit[2] == "21000") & (linesplit[3] == "389"):
        clopTimeEnd = linesplit[1]  # 车辆离开处理中心
        df.loc[df["编号"] == mailNumber, "处理中心封车时间"] = clopTimeEnd

    if (linesplit[2][:3] == "215") & (linesplit[3] == "306"):
        tdopTimeStart = linesplit[1]
        df.loc[df["编号"] == mailNumber, "到达时间"] = tdopTimeStart
    if (linesplit[2][:3] == "215") and (linesplit[3] == "706" or linesplit[3] == "711"):
        tdopTimeEnd = linesplit[1]
        df.loc[df["编号"] == mailNumber, "妥投时间"] = tdopTimeStart

    if (linesplit[2] == "21000") & (linesplit[3] == "999"):
        split_str = linesplit[16].split("</br>")

        df.loc[df["编号"] == mailNumber, "验单类别"] = split_str[0].split(":")[1]
        df.loc[df["编号"] == mailNumber, "验单环节"] = split_str[3].strip("[]")
        df.loc[df["编号"] == mailNumber, "验单号"] = split_str[1].split(":")[1]

df.to_excel("output.xlsx", index=False)