目录
1 横向合并——merge
2 横向合并——join
3 竖向合并——append
4 竖向合并——concat
1 横向合并——merge
result = pd.merge(left, right, on='key')
result = pd.merge(left, right, on=['key1', 'key2'])
result = pd.merge(left, right, how='left', on=['key1', 'key2'])
result = pd.merge(left, right, how='right', on=['key1', 'key2'])
result = pd.merge(left, right, how='outer', on=['key1', 'key2'])
2 横向合并——join
result = left.join(right, on=key_or_keys) #共同指标的关键词
result = pd.merge(left, right, left_on=key_or_keys, right_index=True,how='left', sort=False)
result = left.join(right, on='key')
3 竖向合并——append
result = df1.append(df2)
文章来源:https://www.toymoban.com/news/detail-606391.html
4 竖向合并——concat
frames = [df1, df2, df3]
result = pd.concat(frames)
文章来源地址https://www.toymoban.com/news/detail-606391.html
到了这里,关于Python——把几个DataFrame合并成一个DataFrame的文章就介绍完了。如果您还想了解更多内容,请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章,希望大家以后多多支持TOY模板网!