计算两个Dataframe的差值

在字段名相同的情况下

df1-df2

df = pd.concat([df1, df2, df2]).drop_duplicates(keep=False)#df1-df2

print(df)

df2-df1

df = pd.concat([df2, df1, df1]).drop_duplicates(keep=False)#df2-df1

print(df)

上面的 df2-df1 等同于

fileds_df = df1.append(df2).drop_duplicates(keep=False) #drop_duplicates重复数据删除

print(fileds_df)

上面的 df1-df2 等同于

fileds_df = df2.append(df1).drop_duplicates(keep=False)

print(fileds_df)