How to replace the NaN value by zero in python?

Description

To replace the NaN(missing value) by scalar value using python.

  • Import pandas library.
  • Read the sample data.
  • Make it as a data frame.
  • Use fillna() to replace Nan value.

#import libraries

import pandas as pd

#Read the sample data

data=pd.read_csv(‘/home/soft27/soft27/

Sathish/Pythonfiles/Houseprice.csv’)

#create data frame

df=pd.DataFrame(data)

print(“Actual data frame is:\n”,df)

#Find the missing values

print(“Find missing values”)

print(df.isnull())

#Replace the missing values(Nan)

print(“Replace the Nan values”)

print(df.fillna(0))

Leave Comment

Your email address will not be published. Required fields are marked *

clear formSubmit