Ensuring column uniqueness in a Pandas DataFrame

Last update on December 21 2024 09:14:25 (UTC/GMT +8 hours)

Pandas: Data Validation Exercise-7 with Solution

Write a Pandas program to check that a specific column contains only unique values.

This exercise demonstrates how to ensure that a specific column contains only unique values by checking for duplicates.

Sample Solution :

Code :

import pandas as pd

# Create a sample DataFrame
df = pd.DataFrame({
    'ID': [1, 2, 3, 3],
    'Name': ['Orville', 'Arturo', 'Ruth', 'David']
})

# Check if the 'ID' column has unique values
unique_ids = df['ID'].is_unique

# Output the result
print(f"Is 'ID' column unique? {unique_ids}")

Output:

Is 'ID' column unique? False

Explanation:

• Created a DataFrame with an 'ID' column that contains duplicate values.
• Used is_unique to check if the 'ID' column contains only unique values.
• Displayed whether the 'ID' column is unique.

Python-Pandas Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.