Python-pandas, np.nan [duplicate]

Question

Could you guys please help me explain the code below:

Why a nan is not np.nan?

import pandas as pd
import numpy as np

df.iloc[31464]['SalesPersonID']
[out]:
nan

df.iloc[31464]['SalesPersonID'] is np.nan
[out]:
False

Thank you, all.

Pondweed

Use .isnan() instead to compare NaN values – Isogloss

How to check if any value is NaN in a Pandas DataFrame – Windham

Related: Why in numpy nan == nan is False while nan in [nan] is True? – Ibnsina

Problem solved. Thank you, all. – Pondweed

Answer 1

np.nan is a special value in numpy. Read here for more information on it.

The link above mentions the following code snippet:

>>> np.nan == np.nan  # is always False! Use special numpy functions instead.

Also, type(df.iloc[31464]['SalesPersonID']) is np.float64.

Spectroradiometer

Answer 2

use np.isnan(np.nan) which gives True or

np.isnan(df.iloc[31464]['SalesPersonID']) which gives True

Breebreech

Great help! Thanks, all. – Pondweed

mark an answer as approved. whichever has helped you. – Breebreech