Python - Show which entries in a Pandas Index are not NA


To show which entries in a Pandas Index are not NA, use the index.notna() method. 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 not-NA. Return True for non-NA entries −

print("\nCheck which entries are not-NA...\n", index.notna())

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 not-NA
# Return True for non-NA entries
print("\nCheck which entries are not-NA...\n", index.notna())

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 not-NA...
[ True True False True True False]

Updated on: 13-Oct-2021

106 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements