How to replace NaN values in Python

1 min

The Pandas library will give you the tools to replace the nan values.

Fillna

The .fillna() method will replace all NaN values in contained in a pandas.Series ou pandas.DataFrame.

The method takes multiple arguments such as

Value

The value you want to replace the Na with.

Method

The method of fill. Can be forward fill as "ffill", backward fill as "bfill".

Axis

The axis you want to perform the operation on, it works only when given a DataFrame.

An example on a Serie

# My column is the column in which 
# we want to replace our NaN
df["my_column"] = df["my_column"].fillna(0)
The fillna method used to replace NaN values into 0

An example on a DataFrame

# Here we apply the method on a dataframe itself
df = df.fillna(0) # Here axis 1 means columns
The fillna method used to replace NaN values into 0

Here you are, you know how to replace your NaN by a specific value !

If you want to learn more about Backfill or Forward Fill, you can check the links below