0

I have a dataframe, when every row might have some nan in the last columns:

df = 
A B C  D   E   F
1 2 3 nan nan nan
1 2 3  4  nan nan
1 2 3  4   5   6 

I want to run ffill per row, to get:

df = 
A B C  D  E F
1 2 3  3  3 3
1 2 3  4  4 4
1 2 3  4  5 6 

How can I do it?

Thanks

Cranjis
  • 1,590
  • 8
  • 31
  • 64

1 Answers1

1

Use ffill with axis=1 as parameter:

>>> df.ffill(axis=1).astype(int)
   A  B  C  D  E  F
0  1  2  3  3  3  3
1  1  2  3  4  4  4
2  1  2  3  4  5  6
Corralien
  • 109,409
  • 8
  • 28
  • 52