(pandas)merge合并实例

导入pandas库，打开“11.xls”和“22.xls”

import pandas as pd
df=pd.read_excel(r"11.xls")
df

df1=pd.read_excel(r"22.xls")
df1

1.以姓名为关键字，进行交集合并！

df3=pd.merge(df,df1,how="inner",on="姓名")
df3

2.以姓名为关键字，进行并集合并

df4=pd.merge(df,df1,how="outer",on="姓名")
df4

3.左连接合并

df5=pd.merge(df,df1,how="left")
df5

4.右链接合并

df6=pd.merge(df,df1,how="right")
df6