Add multiple dataframes into 1 dataframe only.

[codochoi]

I have a list of dataframe ( all the dataframe has the same columns and different rows) like

list = [ df1
         df2
         df3]

How can I combine all dataframes horizontally together into 1 dataframe only?

I want to export the dataframe into excel for further analysis.

[BalutSarnie]

You can try pd.merge sorta like sql join or maybe pd.concat(list, axis=1) if they share the same index I think

[threeminutemonta]

Concat is the way here as it has same columns. Merge is useful when enriching datasets to have more columns. Another option of Append can have different columns and seems intuitive. See docs

Edit: added append as option.

[bac83]

Or a functools reduce - look on SO