如何根据一列从两个数据帧中获取不匹配的数据。(熊猫)

import pandas as pd

# 创建两个数据帧
df1 = pd.DataFrame({'A': [1, 2, 3, 4, 5],
                    'B': ['a', 'b', 'c', 'd', 'e']})

df2 = pd.DataFrame({'A': [1, 2, 3, 6, 7],
                    'B': ['a', 'b', 'c', 'f', 'g']})

# 使用merge()函数进行合并
merged_df = pd.merge(df1, df2, on='A', how='outer', indicator=True)

# 获取不匹配的数据
unmatched_df = merged_df[merged_df['_merge'] != 'both']

# 打印结果
print(unmatched_df)

   A  B_x  B_y      _merge
3  4    d  NaN   left_only
4  5    e  NaN   left_only
5  6  NaN    f  right_only
6  7  NaN    g  right_only