Not able to outer join two dataframe

Question

I am using this code to merge two dataframe : pd.concat(df1, df2, on='a', how='outer')

I am getting the following error:-

TypeError: concat() got an unexpected keyword argument 'on'

pd.concat([df1, df2], on='a', how='outer') – pissall Oct 17 '19 at 13:06 — pissall, Oct 17 '19 at 13:06

score 4 · Accepted Answer · answered Oct 17 '19 at 13:07

I believe you want merge:

df = pd.merge(df1, df2, on='a', how='outer')

But also concat is possible - it return default outer join by index of both DataFrames, so added [] and DataFrame.set_index:

df = pd.concat([df1.set_index('a'), df2.set_index('a')], axis=1)

score 1 · Answer 2 · edited Oct 17 '19 at 13:08

1

You should try the merge method.

pd.merge(df1, df2, how='outer', on='a')

edited Oct 17 '19 at 13:08

pissall

answered Oct 17 '19 at 13:08

William Knighting

score 0 · Answer 3 · answered Oct 17 '19 at 13:11

0

Here's the documentation for concat. As you can see, there is no 'on' (or how) arg, so you just need to adjust your parameters accordingly.

answered Oct 17 '19 at 13:11

c4llmeco4ch

3 Answers3