How to fill missing values in a dataset with a desired input using pandas?

Question

Ranjana Admin · Accepted Answer

To fill a null values with something else, let us create a dataframe having some null values

import numpy as np

df = pd.DataFrame({'col1':[1,2,3,np.nan],

'col2':[np.nan,555,666,444],

'col3':['abc','def','ghi','xyz']})

df.head()

Now we will the null values with a string ‘FILL’

df.fillna('FILL')

Walmartone · Answer

Your approach is correct! Using df.fillna('FILL') is a simple and effective way to replace null values with a specific string. If you want to modify the DataFrame in place, you can use df.fillna('FILL', inplace=True). Keep up the great work with pandas! WalmartOne

How to fill missing values in a dataset with a desired input using pandas?

Your answer

2 Answers

More Data Science discussions

Learn & Explore

Data Science Tutorials

Data Science Interview Q&A

Latest Data Science Blogs

Want answers to more Data Science questions?

Stay in the loop — it’s free

You’re on the list!