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
CodePudding user response:
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