显示不同大小的2个DataFrames的共同元素和差异

import pandas as pd

# 创建两个示例DataFrames
df1 = pd.DataFrame({'A': [1, 2, 3], 'B': ['a', 'b', 'c']})
df2 = pd.DataFrame({'A': [2, 3, 4], 'B': ['b', 'c', 'd']})

# 合并两个DataFrames，并显示共同元素
common_elements = pd.merge(df1, df2, on=['A', 'B'], how='inner')
print("共同元素：")
print(common_elements)

# 显示df1中与df2不同的元素
diff_df1 = pd.merge(df1, df2, on=['A', 'B'], how='left', indicator=True)
diff_df1 = diff_df1[diff_df1['_merge'] == 'left_only']
print("df1中与df2不同的元素：")
print(diff_df1)

# 显示df2中与df1不同的元素
diff_df2 = pd.merge(df1, df2, on=['A', 'B'], how='right', indicator=True)
diff_df2 = diff_df2[diff_df2['_merge'] == 'right_only']
print("df2中与df1不同的元素：")
print(diff_df2)