merge dataframe and manage _y and _x

Asked Dec 21 '21 at 11:28

Active Dec 21 '21 at 11:44

Viewed 35 times

HJello guys,

I wanzt to do a left join like below, but im gotting date1_x, date1_y and date2_x and date2_y. What i want is to replace the column if it exists.

df1 = df1.merge(df2, on='id', how='left')

df1

id, date1, val1, date2

1,  '2021-03-10', 'XEP', '2021-04-10'

df2

 id,    date1,      date2
 1,  '2021-09-03', '2021-09-04'
 2,  '2021-09-05', '2021-09-06'
 3,  '2021-09-07', '2021-09-08'

expected resulting df:

1,  '2021-09-03', 'XEP' , '2021-09-04'

edited Dec 21 '21 at 11:31

asked Dec 21 '21 at 11:28

tamo007

sorry, do you try dupe solution? If yes, why not mentioned in question and explianed why failed? – jezrael Dec 21 '21 at 11:29
what do you mean by dupe solution please? – tamo007 Dec 21 '21 at 11:31
I think [this](https://stackoverflow.com/a/48699845/2901002) – jezrael Dec 21 '21 at 11:31
yes thank you saw this !! and didn't succed – tamo007 Dec 21 '21 at 11:33
You are right wrong dupe, need `df11 = df1.set_index('id') df22 = df2.set_index('id') df11.update(df22)` – jezrael Dec 21 '21 at 11:43
like you did, i have still the date1_x and date1_y and date2_x and date2_y – tamo007 Dec 21 '21 at 11:47
no merge necessary, do you try comment solution? – jezrael Dec 21 '21 at 11:48
which ? one .? @jezrael – tamo007 Dec 21 '21 at 11:49
i tried yours. But my column id disappear totally now. – tamo007 Dec 21 '21 at 12:22
do you knwo how to do? please? – tamo007 Dec 21 '21 at 12:29
@jezrael have you an idea please? – tamo007 Dec 21 '21 at 18:10

0 Answers0