How to assign value to NaN in pandas series?

Question

import pandas as pd
import numpy as np    

data = {'a' : 0., 'b' : 1., 'c' : 2.}

s = pd.Series(data,index=['b','c','d','a'])
print (s)

OUTPUT IS : 

b    1.0
c    2.0
d    NaN
a    0.0
dtype: float64

I want to assign some values to NaN. Finally i got the answer. I was thinking to remove the nan with empty string "" and below is the code.

        data = pd.read_excel(i)
        data1 = data.replace(np.nan, '', regex=True)
        data1.columns = data1.columns.str.replace('Unnamed.*', '')

Welcome to StackOverflow. Please take the time to read this post on [how to provide a great pandas example](https://stackoverflow.com/questions/20109391/how-to-make-good-reproducible-pandas-examples) as well as how to provide a [minimal, Complete, and Verifiable example](https://stackoverflow.com/help/mcve) and revise your question accordingly. These tips on how to ask a good question may also be useful. — yatu, Apr 11 '20 at 12:21

score 0 · Accepted Answer · answered Apr 11 '20 at 12:24

0

You can use fillna method of pandas.

s.fillna(0)

You can also replace with mean or median of Series

s.fillna(s.median()) 

#or

s.fillna(s.mean())

answered Apr 11 '20 at 12:24

FAHAD SIDDIQUI

631
4
22

How to assign value to NaN in pandas series?

1 Answers1