import pandas as pd
import numpy as np
1:
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’]})
key A B
0 k0 a0 b0
1 k1 a1 b1
2 k2 a2 b2
3 k3 a3 b3
key C D
0 k0 c0 d0
1 k1 c1 d1
2 k2 c2 d2
3 k3 c3 d3
res = pd.merge(left,right,on=‘key’) #以key为中心,进行合并
key A B C D
0 k0 a0 b0 c0 d0
1 k1 a1 b1 c1 d1
2 k2 a2 b2 c2 d2
3 k3 a3 b3 c3 d3
2:#indicator显示如何合并
df1 = pd.DataFrame({‘col1’:[0,1],‘col_left’:[‘a’,‘b’]})
df2 = pd.DataFrame({‘col1’:[1,2,2],‘col_right’:[2,2,2]})
col1 col_left
0 0 a
1 1 b
col1 col_right
0 1 2
1 2 2
2 2 2
res = pd.merge(df1,df2,on=‘col1’,how=‘outer’,i