df.fillna(df.mean()) code example

Example 1: how to fill nas on a dataframe with median

df.fillna(df.mean(), inplace=True)

Example 2: how to fill nan values with mean in pandas

df.fillna(df.mean())

Example 3: python fillna with mean in a dataframe

df["newColumName"] = df["originalColumnName"].fillna(df["originalColumnName"].mean())

Example 4: 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 5: 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

Tags:

Misc Example