用于比较具有相同行的两个CSV文件的新行/差异的Python脚本

import csv
import pandas as pd

def compare_csv(file1, file2):
    # 读取CSV文件并转换为DataFrame
    df1 = pd.read_csv(file1)
    df2 = pd.read_csv(file2)

    # 找到两个文件中的新行
    new_rows = df2[~df2.isin(df1)].dropna()

    # 找到两个文件中的差异行
    diff_rows = pd.concat([df1, df2]).drop_duplicates(keep=False)

    # 返回新行和差异行
    return new_rows, diff_rows

file1 = 'file1.csv'
file2 = 'file2.csv'
new_rows, diff_rows = compare_csv(file1, file2)

print("新行:")
print(new_rows)

print("差异行:")
print(diff_rows)