Python用于临床数据管理-Lab-AE核查-new-3-多次输出结果比较

#原文件新增一列【核查备注】列，新文件无需处理
import os
import pandas as pd
import excelformat2


filename_old=os.listdir(r'C:\Users\XinXinbuX280\Desktop\阿达木三期p\rawdata\文件比对\原')
filename_new=os.listdir(r'C:\Users\XinXinbuX280\Desktop\阿达木三期p\rawdata\文件比对\新')
path_old=r'C:\Users\XinXinbuX280\Desktop\阿达木三期p\rawdata\文件比对\原\{}'.format(filename_old[0])
path_new=r'C:\Users\XinXinbuX280\Desktop\阿达木三期p\rawdata\文件比对\新\{}'.format(filename_new[0])
writer=pd.ExcelWriter(r'C:\Users\XinXinbuX280\Desktop\阿达木三期p\output\LBAEMH文件比对\【比对结果】{}'.format(filename_new[0]))
data_old=pd.read_excel(path_old)
data_new=pd.read_excel(path_new)
data_new.drop_duplicates(keep='first',inplace=True)
data_new.reset_index(inplace=True)
data_old.drop_duplicates(keep='first',inplace=True)
data_old.reset_index(inplace=True)
comlist=['临床意义判定','备注','不良事件名称','不良事件序号','不良事件开始日期','不良事件结束日期','既往病史名称','既往病史序号','既往病史开始日期','既往病史结束日期','匹配结果']
comments=[]
compare=[]
for i in range(len(data_new)):
    comments.append('NA')
    compare.append('new')
for i in range(len(data_new)):
    for n in range(len(data_old)):
        if data_new['筛选号'][i]==data_old['筛选号'][n] and data_new['访视名称'][i]==data_old['访视名称'][n]  and data_new['表单名称'][i]==data_old['表单名称'][n] and data_new['检查项目'][i]==data_old['检查项目'][n] and data_new['检查日期'][i]==data_old['检查日期'][n] and data_new['检查结果'][i]==data_old['检查结果'][n]:
            comments[i]=data_old['核查备注'][n]
            diff=[]
            flag=0
            for c in comlist:
                if data_new[c][i]==data_old[c][n]:
                    flag+=1
                else:
                    diff.append([c,data_new[c][i],data_old[c][n]])
            if flag!=11:
                compare[i]='change'+str(diff)
            else:
                compare[i]='same'
            print(compare[i])
data_new.insert(len(data_new.columns),'核查备注',comments)
data_new.insert(len(data_new.columns),'比对结果',compare)
data_new.to_excel(writer,index=False)
writer.save()
outfile=r'C:\Users\XinXinbuX280\Desktop\阿达木三期p\output\LBAEMH文件比对\【比对结果】{}'.format(filename_new[0])
excelformat2.reset_col(outfile)
excelformat2.reset_format(outfile)