Python Pandas - Check if the index has duplicate values

PythonPandasServer Side ProgrammingProgramming

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...
",index)

Check if the index is having duplicate values −

print("
Is the Pandas index having duplicate values?
",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...
",index) # Return an array representing the data in the Index print("
Array...
",index.values) # Check if the index is having duplicate values print("
Is the Pandas index having duplicate values?
",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
raja
Updated on 13-Oct-2021 11:13:11

Advertisements