Value_counts() counting NaN as True

Analyzing_Exit_Surveys.ipynb (41.2 KB)

Hi Team,
This was posted in another question but was not solved because they never posted their notebook. The values are created properly in the ‘disattisfied’ column, because using isnull() returns the appropriate amount of NaN values. However, when using value_counts(dropna=False), it displays the NaN values as True. Please see attached notebook. Any idea why this is happening?



Click here to view the jupyter notebook file in a new tab

@dylncu Welcome to DQ Community!

I am not sure which original post you have referred to but my best guess is this one: Error in any() fn

Just in case have you referred to the reply by Sahil?

Can you try this? For the other student, this seems to have worked.