Why Removing duplicates (drop_duplicates) in Data Analysis Python? - Purpose & Use Cases

The Big Idea

What if you could clean messy data in seconds instead of hours?

The Scenario

Imagine you have a list of customer records collected from different sources. Many customers appear multiple times with the same details. You want to find unique customers to send a special offer.

The Problem

Manually scanning through hundreds or thousands of records to find and remove duplicates is slow and tiring. It's easy to miss duplicates or accidentally delete important data. Mistakes can cause wrong results and wasted effort.

The Solution

Using drop_duplicates in data analysis tools quickly finds and removes repeated rows. It does this accurately and instantly, saving time and avoiding errors.

Before vs After

✗ Before

unique_customers = []
for customer in customers:
    if customer not in unique_customers:
        unique_customers.append(customer)

✓ After

unique_customers = df.drop_duplicates()

What It Enables

It lets you clean your data fast and focus on real insights without worrying about repeated information.

Real Life Example

A marketing team cleans a list of email addresses before sending a campaign, ensuring each person gets only one email and avoiding spam complaints.

Key Takeaways

Manual duplicate removal is slow and error-prone.

drop_duplicates automates and speeds up this task.

Clean data leads to better decisions and results.

Practice

1. What does the drop_duplicates() function do in a pandas DataFrame?

easy

A. Fills missing values with zeros

B. Removes repeated rows based on all columns by default

C. Sorts the DataFrame rows in ascending order

D. Changes the data type of columns

Solution

1. Step 1: Understand the function purpose

   drop_duplicates() is used to remove repeated rows in a DataFrame.

2. Step 2: Default behavior

   By default, it checks all columns to find duplicates and keeps the first occurrence.

3. Final Answer:

   Removes repeated rows based on all columns by default -> Option B

4. Quick Check:

   drop_duplicates() removes repeated rows [OK]

Hint: Remember: drop_duplicates removes repeated rows [OK]

Common Mistakes:

• Thinking it sorts data
• Confusing with fillna()
• Assuming it changes data types

2. Which of the following is the correct syntax to remove duplicate rows from a DataFrame df?

easy

A. df.drop_duplicates[]

B. df.remove_duplicates()

C. df.drop_duplicates()

D. df.drop_duplicates{}

Solution

1. Step 1: Identify correct method call

   The method to remove duplicates is drop_duplicates(), called with parentheses.

2. Step 2: Check syntax correctness

   Only df.drop_duplicates() is valid syntax; brackets or braces are incorrect.

3. Final Answer:

   df.drop_duplicates() -> Option C

4. Quick Check:

   Use parentheses to call methods [OK]

Hint: Use parentheses () to call drop_duplicates method [OK]

Common Mistakes:

• Using square brackets instead of parentheses
• Using a non-existent method name
• Using curly braces instead of parentheses

3. Given the DataFrame df below, what will df.drop_duplicates(subset=['Name']) return?

import pandas as pd
data = {'Name': ['Anna', 'Bob', 'Anna', 'Cody'], 'Age': [25, 30, 25, 22]}
df = pd.DataFrame(data)

medium

A. [{'Name': 'Anna', 'Age': 25}, {'Name': 'Bob', 'Age': 30}, {'Name': 'Cody', 'Age': 22}]

B. [{'Name': 'Anna', 'Age': 25}, {'Name': 'Anna', 'Age': 25}, {'Name': 'Bob', 'Age': 30}, {'Name': 'Cody', 'Age': 22}]

C. [{'Name': 'Bob', 'Age': 30}, {'Name': 'Cody', 'Age': 22}]

D. [{'Name': 'Anna', 'Age': 25}, {'Name': 'Bob', 'Age': 30}]

Solution

1. Step 1: Understand subset parameter

   Using subset=['Name'] means duplicates are checked only on the 'Name' column.

2. Step 2: Identify duplicates by 'Name'

   'Anna' appears twice; only the first occurrence is kept, others dropped.

3. Final Answer:

   [{'Name': 'Anna', 'Age': 25}, {'Name': 'Bob', 'Age': 30}, {'Name': 'Cody', 'Age': 22}] -> Option A

4. Quick Check:

   Duplicates dropped by 'Name' column [OK]

Hint: Use subset to check duplicates on specific columns [OK]

Common Mistakes:

• Not using subset and dropping all duplicates
• Keeping all duplicates instead of first
• Confusing which rows are dropped

4. What is wrong with this code snippet to remove duplicates from DataFrame df?

df.drop_duplicates(inplace=True)

After running it, duplicates still appear in df. Why?

medium

A. The DataFrame has no duplicates to remove

B. drop_duplicates() does not modify the original DataFrame even with inplace=True

C. The DataFrame was not reassigned and inplace=True is ignored

D. The inplace parameter is misspelled

Solution

1. Step 1: Check inplace parameter usage

   inplace=True modifies the original DataFrame, so no reassignment needed.

2. Step 2: Consider DataFrame content

   If duplicates still appear, likely the DataFrame had no duplicates to remove.

3. Final Answer:

   The DataFrame has no duplicates to remove -> Option A

4. Quick Check:

   inplace=True modifies original; no duplicates means no change [OK]

Hint: Check if DataFrame actually has duplicates before drop_duplicates [OK]

Common Mistakes:

• Assuming inplace=True does nothing
• Thinking drop_duplicates always changes data
• Not verifying if duplicates exist

5. You have a DataFrame df with columns ['ID', 'Name', 'Score']. Some rows have duplicate ID values but different Score. How do you keep only the row with the highest Score for each ID?

hard

A. Use df.drop_duplicates(subset=['Score'])

B. Use df.drop_duplicates(subset=['ID']) without sorting

C. Use df.drop_duplicates(keep='last') without sorting

D. Use df.sort_values('Score', ascending=False).drop_duplicates(subset=['ID'])

Solution

1. Step 1: Sort DataFrame by Score descending

   Sorting by 'Score' descending puts highest scores first for each ID.

2. Step 2: Drop duplicates by ID keeping first

   After sorting, dropping duplicates by 'ID' keeps the first (highest score) row per ID.

3. Final Answer:

   df.sort_values('Score', ascending=False).drop_duplicates(subset=['ID']) -> Option D

4. Quick Check:

   Sort then drop duplicates keeps highest score per ID [OK]

Hint: Sort by score descending before drop_duplicates to keep max [OK]

Common Mistakes:

• Not sorting before dropping duplicates
• Dropping duplicates on wrong column
• Using keep='last' without sorting