Change language

Python | Pandas dataframe.isna ()

The Pandas function dataframe.isna() is used to detect missing values. It returns a boolean of the same size indicating whether the values ​​are NA. NA values ​​such as None or numpy.NaN are mapped to True values. Everything else is matched against false values. Characters such as blank lines "or numpy.inf are not considered NA values ​​(unless you set pandas.options.mode.use_inf_as_na = True).

Syntax: DataFrame.isna ()

Returns: Mask of bool values ​​for each element in DataFrame that indicates whether an element is not an NA value.

To link to the CSV file used in the example, click here

Example # 1: Use the isna () function to detect missing values ​​in a data frame.

# import pandas as pd

import pandas as pd

 
# Create a data frame

df = pd.read_csv ( "nba.csv" )

  
# Print the data frame
df

Let’s use the isna () function to detect missing values.

# detect missing values ​​
df.isna ()

Output:

In the output, cells corresponding to missing values ​​contain a value true, false otherwise.

Example # 2: Use the isna () function to find missing values ​​in a panda series object

# pandas import as pd

import pandas as pd

 
# Create a series

sr = pd.Series ([ 12 , 5 , None , 5 , None , 11 ])

 
# Print series
sr

Let’s find all missing values ​​in the series.

# to detect missing values ​​
sr.isna ()

Output:

Shop

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 laptop for development

$499+
Gifts for programmers

Best laptop for Cricut Maker

$299+
Gifts for programmers

Best laptop for hacking

$890
Gifts for programmers

Best laptop for Machine Learning

$699+
Gifts for programmers

Raspberry Pi robot kit

$150

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