Python Forum
isnull() in pandas not able to identify blank value (Python coding)
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
isnull() in pandas not able to identify blank value (Python coding)
#1
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:
Output:
[[False False False] [False False False] [False False False]]
Reply
#2
I didn't see in the official docs that .isnull should handle such cases.
if you want to catch empty strings, just do df == "".
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Python - Pandas writing blank files to file tdunphy 0 1,971 Jan-14-2021, 12:11 AM
Last Post: tdunphy
  ISNULL/NVL alternative in filter SIARO 0 2,301 Feb-14-2020, 09:32 PM
Last Post: SIARO
  Unable to identify Tuple index error appmkl 4 4,617 Jun-28-2019, 10:12 AM
Last Post: appmkl

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020