主键合并,左右连接

import pandas as pd
left=pd.DataFrame({‘A’:[‘A0’,‘A1’,‘A2’],
‘B’:[‘B0’,‘B1’,‘B2’],
‘C’:[‘C0’,‘C1’,‘C2’],
‘key’:[‘k0’,‘k2’,‘k3’]})
right=pd.DataFrame({‘key’:[‘k0’,‘k2’,‘k3’],
‘B’:[‘B0’,‘B1’,‘B2’],
‘C’:[‘C0’,‘C1’,‘C2’],
‘D’:[‘D0’,‘D1’,‘D2’]})#合并后缺失值用NaN表示
print(left)
print(right)
print(pd.merge(left,right))
print(pd.merge(left,right,on=‘key’))#on=‘key’,key两边合并的所有项目显示
print(pd.merge(left,right,on=[‘B’]))#on=‘B’,B两边合并的所有项目显示
print(pd.merge(left,right,on=‘B’,suffixes=[’_left’,’_right’]))#suffixes指定项目名字显示
#on=‘B’,B两边合并的所有项目显示’_left’,’_right’
print(pd.merge(left,right,how=‘left’))#左连接,以左为基准全部显示,右边只显示重叠后剩下数据
print(pd.merge(left,right,how=‘right’))#与左连接相反

,