python pandas replace nan code example
Example 1: replace nan in pandas
df['DataFrame Column'] = df['DataFrame Column'].fillna(0)
Example 2: pandas replace nan
data["Gender"].fillna("No Gender", inplace = True)
Example 3: replace "-" for nan in dataframe
df.replace(np.nan,0)
Example 4: python dataframe replace nan with 0
In [7]: df
Out[7]:
0 1
0 NaN NaN
1 -0.494375 0.570994
2 NaN NaN
3 1.876360 -0.229738
4 NaN NaN
In [8]: df.fillna(0)
Out[8]:
0 1
0 0.000000 0.000000
1 -0.494375 0.570994
2 0.000000 0.000000
3 1.876360 -0.229738
4 0.000000 0.000000
Example 5: pandas replace nan with value above
>>> df = pd.DataFrame([[1, 2, 3], [4, None, None], [None, None, 9]])
>>> df.fillna(method='ffill')
0 1 2
0 1 2 3
1 4 2 3
2 4 2 9