pandas fill nan values from other series code example
Example 1: df.fillna(-999,inplace=True)
df2.replace(-999, np.nan, inplace=True)
df2.fillna(df2.mean())
EventId A B C
0 100000 0.91 124.711 2.666000
1 100001 0.91 124.711 -0.202838
2 100002 0.91 124.711 -0.202838
3 100003 0.91 124.711 -0.202838
Example 2: replace nan using fillna
>>> df.fillna(method='ffill')
A B C D
0 NaN 2.0 NaN 0
1 3.0 4.0 NaN 1
2 3.0 4.0 NaN 5
3 3.0 3.0 NaN 4