python:pandas 合并多个DataFrame

python:pandas 合并多个DataFrame

python 把几个DataFrame合并成一个DataFrame——merge,append,join,concat

1、mergepd.merge(left,right,how=‘inner’,on=None,left_on=None,right_on=None,left_index=False,right_index=False,sort=True,suffixes=(’_x’,’_y’),copy=True,indicator=False)

2、append

result=df1.append(df2)

3、join

left.join(right,on=key_or_keys)pd.merge(left,right,left_on=key_or_keys,right_index=True,how=‘left’,sort=False)

4、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)