• 28 comments
• Andrew Coyne

8.DataFarme连接堆叠

import numpy as np
import pandas as pd
rng = np.random.default_rng(0)

df1 = pd.DataFrame(
     {
         "A": ["A0", "A1", "A2", "A3"],
         "B": ["B0", "B1", "B2", "B3"],
         "C": ["C0", "C1", "C2", "C3"],
         "D": ["D0", "D1", "D2", "D3"],
     },
     index=[0, 1, 2, 3],
 )
df1

df2 = pd.DataFrame(
    {
        "B": ["B2", "B3", "B6", "B7"],
        "D": ["D2", "D3", "D6", "D7"],
        "F": ["F2", "F3", "F6", "F7"],
    },
    index=[2, 3, 6, 7],
)
df2

# 默认,axis=0,1轴合并,会自动对齐columns
pd.concat([df1,df2])
# pd.concat([df1,df2],axis=0)

# 1轴合并,会自动对齐index
pd.concat([df1,df2],axis=1)

# 连接方式,默认join='outer'
pd.concat([df1,df2],axis=1,join='outer')

# 连接方式,修改为inner
pd.concat([df1,df2],axis=1,join='inner')