Change language

Python | Pandas Index.notnull ()

Index.notnull() Pandas Index.notnull() detects existing (not missing) values. This function returns a Boolean of the same size indicating that the values ​​are not NA. Values ​​not missing are displayed as True. Characters such as empty strings "or numpy.inf are not considered NA values ​​(unless you set pandas.options.mode.use_inf_as_na = True). NA values ​​such as None or numpy.NaN are mapped to false values.

Syntax: Index.notnull ()

Returns: Boolean array to indicate which entries are not NA.

Example # 1: Use Index.notnull () () to detect missing values ​​in the given index.

Output:

Let’s find out all the non-missing values ​​in the index

# import pandas as pd

import pandas as pd

  
# Create index

idx = pd.Index ([ ’ Jan’ , ’ ’ , ’ Mar ’, None, ’ May ’, ’ Jun ’, ’ Jul’,

’Aug’ , ’Sep’ , ’Oct’ , ’ Nov’ , ’Dec’ ])

  
# Print index
idx

# not found omitted values.
idx.notnull ()

Output:

As we can see in the output, all non-missing values ​​were mapped to True and all missing values ​​were mapped to False . Note that an empty string was matched against True because an empty string is not considered a missing value.

Example # 2: Use Index.notnull () find all non-missing values ​​in the index.

# import pandas as pd

import pandas as pd

 
# Create index

idx = pd.Index ([ 22 , 14 , 8 , 56 , None , 21 , None , 23 ])

 
# Print index
idx

Output:

Let’s find out all the non-missing values ​​in the index

# find non-missing values.
idx.notnull ()

Output:

As we can see in the output, everything is not the missing values ​​were matched against True and all missing values ​​were matched against False .

Shop

Gifts for programmers

Learn programming in R: courses

$FREE
Gifts for programmers

Best Python online courses for 2022

$FREE
Gifts for programmers

Best laptop for Fortnite

$399+
Gifts for programmers

Best laptop for Excel

$
Gifts for programmers

Best laptop for Solidworks

$399+
Gifts for programmers

Best laptop for Roblox

$399+
Gifts for programmers

Best computer for crypto mining

$499+
Gifts for programmers

Best laptop for Sims 4

$

Latest questions

PythonStackOverflow

Common xlabel/ylabel for matplotlib subplots

1947 answers

PythonStackOverflow

Check if one list is a subset of another in Python

1173 answers

PythonStackOverflow

How to specify multiple return types using type-hints

1002 answers

PythonStackOverflow

Printing words vertically in Python

909 answers

PythonStackOverflow

Python Extract words from a given string

798 answers

PythonStackOverflow

Why do I get "Pickle - EOFError: Ran out of input" reading an empty file?

606 answers

PythonStackOverflow

Python os.path.join () method

384 answers

PythonStackOverflow

Flake8: Ignore specific warning for entire file

360 answers

News


Wiki

Python | How to copy data from one Excel sheet to another

Common xlabel/ylabel for matplotlib subplots

Check if one list is a subset of another in Python

How to specify multiple return types using type-hints

Printing words vertically in Python

Python Extract words from a given string

Cyclic redundancy check in Python

Finding mean, median, mode in Python without libraries

Python add suffix / add prefix to strings in a list

Why do I get "Pickle - EOFError: Ran out of input" reading an empty file?

Python - Move item to the end of the list

Python - Print list vertically