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

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

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

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related