可以使用Pandas库来进行数据表格的比较和筛选,具体代码如下:
import pandas as pd
df1 = pd.read_csv('data1.csv') df2 = pd.read_csv('data2.csv')
unique_df1 = df1.drop_duplicates() diff_df1 = unique_df1.merge(df2, how='outer', indicator=True).query("_merge == 'left_only'").drop('_merge', axis=1)
unique_df2 = df2.drop_duplicates() diff_df2 = unique_df2.merge(df1, how='outer', indicator=True).query("_merge == 'left_only'").drop('_merge', axis=1)
result = pd.concat([diff_df1, diff_df2], ignore_index=True)
result.to_csv('unique_rows.csv', index=False, encoding='utf-8')