merge multiple Pandas dataframe

Question

I have three dataframes that look like the following:

df1                 df2                     df3
name      id        name      colour        name      type
apple     1         apple     red           apple     fruit
banana    2         banana    yellow        banana    fruit
cucumber  3         cucumber  green         cucumber  vegetable

I would like to merge the dataframes so they look like this:

name      id  colour  type
apple     1   red     fruit
banana    2   yellow  fruit
cucumber  3   green   vegetable

I have tried using merge and concatenate but the output was not how I wanted it or had a bunch of NaN entries. Does anyone have an idea on how to effectively merge the dataframes?

Mahdi F. · Accepted Answer · 2022-07-20 15:35:14Z

2

For multiple merge you can use functools.reduce.

from functools import reduce
df = reduce(lambda x,y : x.merge(y, on='name'), [df1, df2, df3])
# this work like this : df1.merge(df2, on='name').merge(df3, on='name')
print(df)

# name      id  colour  type
# apple     1   red     fruit
# banana    2   yellow  fruit
# cucumber  3   green   vegetable

edited Jul 20, 2022 at 15:35

answered Jul 20, 2022 at 14:15

Mahdi F.

24.1k5 gold badges25 silver badges32 bronze badges

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

Comments

bpfrd · Accepted Answer · 2022-07-20 14:12:51Z

0

try this:

tmp = df1.merge(df2, on='name')
df3.merge(tmp, on='name')

answered Jul 20, 2022 at 14:12

bpfrd

1,0255 silver badges11 bronze badges

Collectives™ on Stack Overflow

merge multiple Pandas dataframe

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related