Search code examples
pythondataframenandata-cleaning

Value "not a number" in my dataframe not found

I have a problem because I can't find the NaN values that appear when I use describe() on my dataframe. I'm working with Jupyter.

Here is what it looks like

my dataframe describe

And when I use .isnull() and info() functions I got :

isnull() utilization

info()

Can you help me please ?

Solution

  • As you confirmed, it seems that there is no NaN in df.

    I think you are confused with what df.describes returns. df.describes returns a summary of the dataframe. df is not df.describe().

    When you use describe(), the NaN values mean it is impossible to calculate. For example, there are values of object types, such as Month, Date, and Age_Group. It is impossible to calculate mean value of Month because Month's data type is object, not int.