Python Pandas DataFrame fillna() cannot work correctly

Asked Jul 28 '16 at 03:59

Active Jul 28 '16 at 04:28

Viewed 247 times

I have a DataFrame df which has 300000 rows and 75 columns. One of Columns of this dataframe has 165 NaN.
I want to use the fillna() to fill up the null value, but it seems that Nothing really happens. The 165 NaN values are still there. What my code is as follows:

df=df.fillna({'Col':df['Col'].mean()})

I don't know why it didn't work. Is it because of the large amount of NaN values?

edited Jul 28 '16 at 04:28

asked Jul 28 '16 at 03:59

Fan

Are you trying to `fillna()` on a particular column with the mean of that column? – mechanical_meat Jul 28 '16 at 04:06
3

If so, use; `df['Col'] = df['Col'].fillna(df['Col'].mean())`... – mechanical_meat Jul 28 '16 at 04:07
2

Can you make an [example DataFrame that exemplifies the issue](http://stackoverflow.com/q/20109391/2087463)? – tmthydvnprt Jul 28 '16 at 04:21
1

Check the column name for whitespaces etc. It looks correct. – ayhan Jul 28 '16 at 05:19

Python Pandas DataFrame fillna() cannot work correctly

0 Answers0