fillna() pandas code example

Example 1: pandas replace nan

data["Gender"].fillna("No Gender", inplace = True)

Example 2: fillna with mean pandas

sub2['income'].fillna((sub2['income'].mean()), inplace=True)

Example 3: 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 4: DataFrame.fillna

>>> df.fillna(0)
    A   B   C   D
0   0.0 2.0 0.0 0
1   3.0 4.0 0.0 1
2   0.0 0.0 0.0 5
3   0.0 3.0 0.0 4