Numpy学习笔记--08.Pandas合并 concat与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']})



res = pd.merge(left, right, on="key") #基于key的col来合并，类似数据库里面的连接
# res为
#   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


left = pd.DataFrame({
   'key1': ['K0', 'K0', 'K1', 'K2'],
                      'key2': ['K0', 'K1', 'K0', 'K1'],