Python数据分析三大框架之pandas（三）merge合并

合并部分

 

• 基础的部分

import numpy as np
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')
print(res)

 

• 两个键值的合并

 

# 考虑两个键值consider two keys

lef