pandas replace null values code example

Example 1: pandas to convert null values to mean in numeric column

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

Example 2: pandas replace null values with values from another column

#Python
#Col 1 = where you want the values replaced
#Col 2 = where you want to take the values from
df.["Col 1"].fillna(df.["Col 2"], inplace=True)

Example 3: python pandas convert nan to 0

pandas.DataFrame.fillna(0)

Example 4: replace nan using 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