Pandas combining dataframes based on column value

Question

I am trying to turn multiple dataframes into a single one based on the values in the first column, but not every dataframe has the same values in the first column. Take this example:

df1:
A    4
B    6
C    8

df2:
A    7
B    4
F    3

full_df:
A    4    7
B    6    4
C    8
F         3

How do I do this using python and pandas?

You can use Pandas' concat function for this.

Aquarthur
– Aquarthur

2018-09-25 17:26:29 +00:00
Commented Sep 25, 2018 at 17:26 — Aquarthur
– Aquarthur, Commented Sep 25, 2018 at 17:26

Naga kiran · Accepted Answer · 2018-09-25 17:26:50Z

1

You can use pandas merge with outer join

df1.merge(df2,on =['first_column'],how='outer')

answered Sep 25, 2018 at 17:26

Naga kiran

4,6071 gold badge21 silver badges32 bronze badges

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

1 Comment

db702 Over a year ago

Thanks. I was using append.

jpp · Accepted Answer · 2018-09-25 17:36:25Z

0

You can use pd.concat, remembering to align indices:

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

print(res)

     1    1
A  4.0  7.0
B  6.0  4.0
C  8.0  NaN
F  NaN  3.0

answered Sep 25, 2018 at 17:36

jpp

166k37 gold badges301 silver badges363 bronze badges

Collectives™ on Stack Overflow

Pandas combining dataframes based on column value

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related