Example
交集
df_merge = pd.merge(df1,df2,on=['id','name','number'],how='inner')
并集
# 两种方式
df_union = pd.merge(df1,df2,on=['id','name','number'],how='outer')
df_union2 = df1.append(df2).drop_duplicates(subset=df1.columns,keep='first',ignore_index=True)
差集
# 两种方式
# df1-df2
df_diff1 = df1.append(df1.append(df2)).drop_duplicates(subset=df1.columns,keep=False,ignore_index=True)
df_diff1 = pd.concat([df1,df1,df2]).drop_duplicates(keep=False)
# 两种方式
# df2 - df1
df_diff2 = df2.append(df2.append(df1)).drop_duplicates(subset=df2.columns,keep=False,ignore_index=True)
df_diff2 = pd.concat([df1,df2,df2]).drop_duplicates(keep=False)
对称差集
df_diff = df1.append(df2).drop_duplicates(subset=df1.columns,keep=False,ignore_index=True)
参考来源