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')
留言