import pandas as pd # 读取两个 Excel 文件 excel_a = pd.read_excel('test1.xlsx', engine='openpyxl') excel_b = pd.read_excel('test2.xlsx', engine='openpyxl') # 按行合并两个数据框 merged_data = pd.merge(excel_a, excel_b, how='outer', indicator=True) # 筛选出只在一个表中出现的行或数据不一致的行 differences = merged_data[merged_data['_merge'] != 'both'] # 添加列标识差异数据来自于哪个表 differences['Source_Table'] = differences['_merge'].map({'left_only': 'Table A', 'right_only': 'Table B'}) # 将差异数据写入新的 Excel 表 differences.to_excel('path_to_differences.xlsx', index=False) print(f"差异数据已写入 'path_to_differences.xlsx'")
注:需要安装pandas 以及openpyxl包