isnull() in pandas not able to identify blank value (Python coding)

Question

import pandas as pd
t1=pd.DataFrame()
t1 ['name'] = ["dp","ag","wp"]
t1['status'] = ['a','b','c']
t1['age'] = [10,"",15]
t1
##
print(t1.isnull().values)

Why is the execution of this node not able to identify blank (see "age" column, 2nd row). isnull() is coming false for all the cells, see below output Output:

 [[False False False] 
 [False False False] 
 [False False False]]

jezrael · Accepted Answer · 2020-03-20 10:54:46Z

1

Because empty string is not same like missing value. So correct test for it is:

print(t1.eq('').values)

Or:

print((t1 == '').values)

If want test empty strings or missing values chain both mask with | for bitwise OR:

print((t1.isnull() | t1.eq('')).values)

answered Mar 20, 2020 at 10:54

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Darp Ag Over a year ago

Thanks, but then what would a null look like in the dataframe? Because, even the space is not being captured by isnull() , nor the 'NULL' is being captured... I tried to check with that

Collectives™ on Stack Overflow

isnull() in pandas not able to identify blank value (Python coding)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related