Merge/conact Panda Dataframe

Asked Mar 07 '22 at 13:09

Active Mar 07 '22 at 13:09

Viewed 13 times

I work with a panda Dataframe and I try to create a new table that combine two dataframe based in one column id using concate : My first Dataframe df1 :

My second Dataframe df2:

The desired result :

When I tried to use this code :

result = pd.merge(df1, df2, on='id')

The result dataframe not show me the rows with id=3,4 and 6? Anyone can help please ? Thank you

asked Mar 07 '22 at 13:09

MFatn

1

`result = pd.merge(df1, df2, on='id', how='left')` – jezrael Mar 07 '22 at 13:10
Thank you @jesrael, this is what I look for it. And if I want o replace the "NA" with 0 which option chose ? – MFatn Mar 07 '22 at 13:28
1

then use `result = result.fillna(0)` – jezrael Mar 07 '22 at 13:52

Merge/conact Panda Dataframe

0 Answers0