pandas的连接函数concat()函数
pd.concat(objs, axis``=``0``, join``=``'outer'``, join_axes``=``None``, ignore_index``=``False``,
``keys``=``None``, levels``=``None``, names``=``None``, verify_integrity``=``False``,
``copy``=``True``)
axis:需要合并链接的轴,0是行,1是列
join: 连接的方式 :inner,outer
df1 = pd.DataFrame({'A':['A0','A1','A2','A3'],
'B':['B0','B1','B2','B3'],
'C':['C0','C1','C2','C3'],
'D':['D0','D1','D2','D3']},index=list('1234'))
df1
df2 = pd.DataFrame({'A':['A4','A5','A6','A6'],
'B':['B4','B5','B5','B6'],
'C':['C4','C5','C5','C6'],
'D':['D4','D5','D5','D6']},index=list('2345'))
df2
frames=[df1,df2]
result=pd.concat(frames)
result
result = pd.concat(frames, keys=['x', 'y'])
result
result.loc['x']
result1=pd.concat([df1,df2],axis=1)
result1
JOIN参数
默认join = ‘outer’,为取并集的关系:
result1 = pd.concat([df1, df2], axis=1, join='inner')
result1
result1 = pd.concat([df1, df2], axis=1, join_axes=[df1.index]) #设置索引为df1的索引
TypeError: concat() got an unexpected keyword argument ‘join_axes’