Replacing blank rows in a column with the value of another column

Question

I have a dataframe with a date column but some values are blank or NaN, I am trying to replace all these values with a date from another column. I am trying the solution below but its not working, can someone please help

df['Date'] = df['Date'].replace(np.nan, df['Date2'])

Note that the `replace` method does not find any `np.nan`, probably because `np.nan == np.nan` evals to `False`. https://stackoverflow.com/a/10034186/18482459 — Firefighting Physicist, Dec 09 '22 at 15:27
thanks @mozway your solution worked, unfortunatley you posted the answer in a comment so I cant award you the credit — Samir112, Dec 09 '22 at 20:18

score 0 · Answer 1 · answered Dec 09 '22 at 15:38

0

some values are blank or NaN

You can first replace empty strings with NaN with replace then use fillna.

Try this :

df['Date'] = df['Date'].replace("", np.NaN).fillna(df['Date2'])

answered Dec 09 '22 at 15:38

Timeless

22,580
4
12
30

Replacing blank rows in a column with the value of another column

1 Answers1