import pandas as pd
df=pd.DataFrame({'a':[1,2,3],
'b':[3,4,5],
'c':[5,6,7]},index=['A','C','D'])
print(df)
k=pd.DataFrame({'d':[1,2,3,4,5],'c':[5,6,7,8,9]},index=['A','B','C','D','E'])
print(k)
#横向
hx_dfk=pd.concat([df,k],axis=1) #df在前时
print(hx_dfk)
hx_kdf=pd.concat([k,df],axis=1) #k在前时
print(hx_kdf)
#纵向
zx_dfk=pd.concat([df,k],axis=0) #df在前时
print(zx_dfk)
zx_kdf=pd.concat([k,df],axis=0) #k在前时
print(zx_kdf)
结果:
备注:
1、绿圈处引出merge函数;(另外再介绍)
2、蓝框处引出concat函数的参数,ignore_index=True(默认是False);
3、NaN引出concat函数的参数,join=‘inner’(默认是outer);
如下:
import pandas as pd
df=pd.DataFrame({'a':[1,2,3],
'b':[3,4,5],
'c':[5,6,7]},index=['A','C','D'])
print(df)
k=pd.DataFrame({'d':[1,2,3,4,5],'c':[5,6,7,8,9]},index=['A','B','C','D','E'])
print(k)
#纵向
zx_dfk=pd.concat([df,k],axis=0,ignore_index=True) #df在前时
print(zx_dfk)
结果:
import pandas as pd
df=pd.DataFrame({'a':[1,2,3],
'b':[3,4,5],
'c':[5,6,7]},index=['A','C','D'])
print(df)
k=pd.DataFrame({'d':[1,2,3,4,5],'c':[5,6,7,8,9]},index=['A','B','C','D','E'])
print(k)
#横向
hx_dfk=pd.concat([df,k],axis=1,join='inner') #df在前时
print(hx_dfk)
结果:
二、append连接dateframe