If a single scalar object (e.g. a string and a numeric) is provided, then a single boolean is returned.
Otherwise, a boolean mask where True represents non-NaN value, and False representing NaN, is returned.

Examples

Scalars


        
        
            
                
                
                    pd.notnull("A")
                
            
            True


        
        
            
                
                
                    pd.notnull(np.NaN)
                
            
            False


        
        
            
                
                
                    pd.notnull(None)
                
            
            False

Array-likes

Series


        
        
            
                
                
                    s = pd.Series([1,np.NaN,3])
pd.notnull(s)
                
            
            0     True
1    False
2     True
dtype: bool

The return type is a Series of booleans.

NOTE

Series have the notna(~) method, which serves the exact same purpose:


        
        
            
                
                
                    s = pd.Series([1,np.NaN,3])
s.notna()
                
            
            0     True
1    False
2     True
dtype: bool

DataFrame

Consider the following DataFrame:


        
        
            
                
                
                    df = pd.DataFrame({"A":[np.NaN,2], "B":[3,np.NaN]})
df
                
            
               A    B
0  NaN  3.0
1  2.0  NaN

To check for existing values (non-NaN values):


        
        
            
                
                
                    pd.notnull(df)
                
            
               A      B
0  False  True
1  True   False

The return type is a DataFrame of booleans.

NOTE

DataFrames have the notna(~) method, which serves the exact same purpose:


        
        
            
                
                
                    df = pd.DataFrame({"A":[np.NaN,2], "B":[3,np.NaN]})
df.notna()
                
            
               A      B
0  False  True
1  True   False

Published by Isshin Inada

Edited by 0 others

Did you find this page useful?

thumb_up

thumb_down

Comment

Citation

Ask a question or leave a feedback...

Official Pandas Documentation

https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.notnull.html

thumb_up

thumb_down

chat_bubble_outline

settings

Enjoy our search

Hit / to insta-search docs and recipes!