Python Pandas - Check if the index has duplicate values

To check if the index has duplicate values, use the index.has_duplicates property in Pandas.

At first, import the required libraries −

import pandas as pd

Creating the index −

index = pd.Index(['Car','Bike','Truck','Car','Airplane'])

Display the index −

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

Check if the index is having duplicate values −

print("\nIs the Pandas index having duplicate values?\n",index.has_duplicates)

Example

Following is the code −

import pandas as pd

# Creating the index
index = pd.Index(['Car','Bike','Truck','Car','Airplane'])

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

# Return an array representing the data in the Index
print("\nArray...\n",index.values)

# Check if the index is having duplicate values
print("\nIs the Pandas index having duplicate values?\n",index.has_duplicates)

Output

This will produce the following code −

Pandas Index...
Index(['Car', 'Bike', 'Truck', 'Car', 'Airplane'], dtype='object')

Array...
['Car' 'Bike' 'Truck' 'Car' 'Airplane']

Is the Pandas index having duplicate values?
True

AmitDiwan

Updated on: 13-Oct-2021

4K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started