How to merge two dataframes side-by-side?

Question

is there a way to conveniently merge two data frames side by side?

both two data frames have 30 rows, they have different number of columns, say, df1 has 20 columns and df2 has 40 columns.

how can i easily get a new data frame of 30 rows and 60 columns?

df3 = pd.someSpecialMergeFunct(df1, df2) 

or maybe there is some special parameter in append

df3 = pd.append(df1, df2, left_index=False, right_index=false, how='left') 

ps: if possible, i hope the replicated column names could be resolved automatically.

thanks!

Answer 1

You can use the concat function for this (axis=1 is to concatenate as columns):

pd.concat([df1, df2], axis=1) 

See the pandas docs on merging/concatenating: http://pandas.pydata.org/pandas-docs/stable/merging.html