Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.2k views
in Technique[技术] by (71.8m points)

python - ffill not filling data in pandas dataframe

I have a dataframe like this :

  A  B  C  E D
---------------
0 a  r  g    g
1            x
2 x  f  f    r
3            t
3            y

I am trying for forward filling using ffill. It is not working

 cols = df.columns[:4].tolist()
 df[cols] = df[cols].ffill()

I also tried :

df[cols] = df[cols].fillna(method='ffill')

But it is not getting filled. Is it the empty columns in data causing this issue?

Data is mocked. Exact data is different (contains strings,numbers and empty columns)

desired o/p:

  A  B  C  E D
---------------
0 a  r  g    g
1 a  r  g    x
2 x  f  f    r
3 x  f  f    t
3 x  f  f    y
See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

Replace empty values in subset of columns by NaN:

df[cols] = df[cols].replace('', np.nan).ffill()

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...