Need to fill NaN with next values in Pandas Dataframe

Question

I have this dataframe

My goal is to fill the Nan values in the 3rd and 4th column with the non-Nan data in each column. Tried shift(-5) but didn't get it to work. Any thoughts?

df.iloc[:5, [2, 3]] = df.iloc[5:, [2, 3]].to_numpy()?

Mustafa Aydın
– Mustafa Aydın

2021-04-05 19:41:48 +00:00
Commented Apr 5, 2021 at 19:41 — Mustafa Aydın
– Mustafa Aydın, Commented Apr 5, 2021 at 19:41

Mayank Porwal · Accepted Answer · 2021-04-05 18:39:36Z

1

Use bfill:

df[['col3','col4']] = df[['col3','col4']].bfill()

OR:

df[['col3','col4']] = df[['col3','col4']].fillna(method='bfill')

answered Apr 5, 2021 at 18:39

Mayank Porwal

34.2k9 gold badges45 silver badges65 bronze badges

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

Collectives™ on Stack Overflow

Need to fill NaN with next values in Pandas Dataframe

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related