【莫烦Python】Numpy & Pandas (数据处理教程) pandas合并merge

 import pandas as pd
# merging two df by key/keys. (may be used in database)
# simple example

left = pd.DataFrame({'key': ['K0', 'K1', 'K2', 'K3'],
						'A': ['A0', 'A1', 'A2', 'A3'],
						'B': ['B0', 'B1', 'B2', 'B3']})
right = pd.DataFrame({'key':['K0', 'K1', 'K2', 'K3'],
						'C': ['C0','C1','C2','C3'],
						'D': ['D0', 'D1', 'D2', 'D3']})
print(left)
print(right)
res = pd.merge(left,right,on='key') 合并left和right，在key的参数上进行合并
print(res)

#consider two keys
left = pd.DataFrame({'key': ['K0', 'K1', 'K2', 'K3'],
						'A': ['A0', 'A1', 'A2', 'A3'],
						'B': ['B0', 'B1', 'B2', 'B3']})
right = pd.DataFrame({'key':['K0', 'K1', 'K2', 'K3'],
						'C': ['C0','C1','C2','C3'],
						'D': ['D0', 'D1', 'D2', 'D3']})
print(left)
print(right)
res =pd.merge(left,right,on=['key1','key2']，how='inner') # how = ['left','rigth','outer','inner']

# indicator
df1 = pd.DataFrame({'col1' :[0,1], 'col_ _left':['a','b']})
df2 = pd.DataFrame({'col1 ':[1,2,2],'col_ _right' :[2,2,2]})
print(df1)
print(df2)

# give the indicator a custom name
res = pd.merge(df1,df2,on='col1',how='outer',)