df = pd.concat([df1, df2], axis=1)注意: 用于匹配相同类型的需要索引-int或object(显然是string)For matching need indexes of same types - both int or object (obviously string)示例:df1 = pd.DataFrame({'Column1': {302: 10, 301: 21, 102: 2},'Column2': {302: 0, 301: 0, 102: 0}})print (df1) Column1 Column2102 2 0301 21 0302 10 0df2 = pd.DataFrame({'Column1': {302: 4, 301: 5, 304: 6},'Column2': {302: 0, 301: 0, 304: 0}})print (df2) Column1 Column2301 5 0302 4 0304 6 0df = pd.merge(df1, df2, left_index=True, right_index=True)print (df) Column1_x Column2_x Column1_y Column2_y301 21 0 5 0302 10 0 4 0df = pd.merge(df1, df2, left_index=True, right_index=True, how='outer')print (df) Column1_x Column2_x Column1_y Column2_y102 2.0 0.0 NaN NaN301 21.0 0.0 5.0 0.0302 10.0 0.0 4.0 0.0304 NaN NaN 6.0 0.0df = pd.concat([df1, df2], axis=1)print (df) Column1 Column2 Column1 Column2102 2.0 0.0 NaN NaN301 21.0 0.0 5.0 0.0302 10.0 0.0 4.0 0.0304 NaN NaN 6.0 0.0df = pd.concat([df1, df2], axis=1, join='inner')print (df) Column1 Column2 Column1 Column2301 21 0 5 0302 10 0 4 0 这篇关于pandas数据框中的第一列不是列?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 上岸,阿里云!
08-18 19:33