How to replace Nan from column with float data in a data frame in python

Question

I am trying to replace NAN from a dataframe column which is of float type.

> for i in range(len(tdf)):
>     if tdf['Counterfeit_Weight'][i] =='NaN': # also have tried with np.NaN
>         tdf.loc[i,"Counterfeit_Weight"]=p

I tried np.where, imputer class but nothing is working.

tdf.isnull().sum()
Medicine_ID               0
Counterfeit_Weight     1166
DistArea_ID               0
Active_Since              0

Plz Help

share your data with us, e.g df.head().to_dict(). Nan is normally replaced with fillna: pandas.pydata.org/pandas-docs/version/0.17.0/generated/… — Anton vBR
– Anton vBR, Commented Nov 4, 2017 at 19:36

Ashish · Accepted Answer · 2017-11-04 19:40:58Z

1

Following one line should work for you

tdf['Counterfeit_Weight'].fillna(p)

answered Nov 4, 2017 at 19:40

Ashish

7591 gold badge9 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1