Doesn't pandas recognize the np.nan value?

Question

I tried to check if a variable is equal to np.nan in the code(4th last line). But somehow I don't get a desired output while doing this rather when I use np.nan with check condition it sort of ignores the statement itself, the code seems to run well for other values.

My code:

import pandas as pd
import numpy as np
d={}
f=0
data=pd.read_excel('Book1.xlsx')
for i in data[:]:
    d[i]=0
    f=0
    for j in data[i]:
        print(j)
        if j==np.nan:
            f=f+1
            d[i]=f
print(d)

Please tell if I'm doing something wrong, and how to resolve this?

Does this answer your question? [How can I check for NaN values?](https://stackoverflow.com/questions/944700/how-can-i-check-for-nan-values) — LMc, Jan 12 '21 at 22:34
@LMc when I use this I get a Type error that says ufunc 'isnan' not supported for the inputs that could not be safely coerced to any supported types according to the casting rule ' ' safe ' ' — Inequilazitive, Jan 12 '21 at 22:53
@LMc still not working. Output is same as when I used np.nan. — Inequilazitive, Jan 13 '21 at 06:52

score 1 · Answer 1 · edited Jan 13 '21 at 05:49

1

Instead of

if j==np.nan:

use

if np.isnan(j):

edited Jan 13 '21 at 05:49

Wai Ha Lee

8,598
83
57
92

answered Jan 12 '21 at 22:33

Nour-Allah Hussein

1,439
1
8
17

score 0 · Answer 2 · answered Jan 12 '21 at 22:33

0

Change the line if j==np.nan: to if np.isnan(j):

answered Jan 12 '21 at 22:33

LMc

12,577
3
31
43

Doesn't pandas recognize the np.nan value?

2 Answers2