import pandas as pd
df1 = pd.DataFrame({
'Key': ['A', 'B', 'C', 'D'],
'Data1': [1, 2, 3, 4]
})
df2 = pd.DataFrame({
'Key': ['B', 'D', 'E', 'F'],
'Data2': [5, 6, 7, 8]
})
merged_df = pd.merge(df1, df2, on='Key', how='outer')
# merged_df = pd.merge(df1, df2, how='left')
# merged_df = pd.merge(df1, df2, how='right')
# merged_df = pd.merge(df1, df2, how='inner')
display(merged_df)
df_cross = pd.concat([df1, df2], ignore_index=True).drop_duplicates(keep=False)
display(df_cross)
【pandas】5中连接方式
最新推荐文章于 2024-09-17 23:15:58 发布