Bottom Page

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]]
Quote
#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 == "".
Quote

Top Page

Possibly Related Threads...
Thread Author Replies Views Last Post
  ISNULL/NVL alternative in filter SIARO 0 111 Feb-14-2020, 09:32 PM
Last Post: SIARO
  Unable to identify Tuple index error appmkl 4 867 Jun-28-2019, 10:12 AM
Last Post: appmkl

Forum Jump:


Users browsing this thread: 1 Guest(s)