Python - Show which entries in a Pandas Index are NA


To show which entries in a Pandas Index are NA, use the index.isna() in Pandas. At first, import the required libraries -

import pandas as pd
import numpy as np

Creating Pandas index with some NaN values −

index = pd.Index([5, 65, np.nan, 17, 75, np.nan])

Display the Pandas index −

print("Pandas Index...\n",index)

Show which entries in a Pandas index are NA. Return True for NA entries −

print("\nCheck which entries are NA...\n", index.isna())

Example

Following is the code −

import pandas as pd
import numpy as np

# Creating Pandas index with some NaN values
index = pd.Index([5, 65, np.nan, 17, 75, np.nan])

# Display the Pandas index
print("Pandas Index...\n",index)

# Return the number of elements in the Index
print("\nNumber of elements in the index...\n",index.size)

# Return the dtype of the data
print("\nThe dtype object...\n",index.dtype)

# Show which entries in a Pandas index are NA
# Return True for NA entries
print("\nCheck which entries are NA...\n", index.isna())

Output

This will produce the following output −

Pandas Index...
Float64Index([5.0, 65.0, nan, 17.0, 75.0, nan], dtype='float64')

Number of elements in the index...
6

The dtype object...
float64

Check which entries are NA...
[False False True False False True]

Updated on: 13-Oct-2021

64 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements