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)
参考来源
pandas.DataFrame.drop_duplicates 官方文档
pandas.merge 官方文档
