Pandas concat with different columns

Question

I have two dfs that I want to concat

(sorry I don't know how to properly recreate a df here)

A  B
a1 b1
a2 b2
a3 b3

A  C
a1 c1
a4 c4

Result:

A  B C
a1 b1 c1
a2 b2 NaN
a3 b3 NaN
a4 NaN c4

I have tried:

merge = pd.concat([df1,df2],axis = 0,ignore_index= True)

but this seems to just append the second df to the first df

Thank you!

sophocles · Accepted Answer · 2021-09-13 14:52:28Z

2

I believe you need an outer join:

>>> pd.merge(df,df2,how='outer')

    A    B    C
0  a1   b1   c1
1  a2   b2  NaN
2  a3   b3  NaN
3  a4  NaN   c4

answered Sep 13, 2021 at 14:52

sophocles

13.9k3 gold badges18 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1