Drop Duplicate Rows — LeetCode 2882 Python Solution
EasyPandas
- Problem
- #2882
- Reading time
- 2 min
- Source
- leetcode.com
Table schema
SQL
DataFrame customers +-------------+--------+ | Column Name | Type | +-------------+--------+ | customer_id | int | | name | object | | email | object | +-------------+--------+ There are some duplicate rows in the DataFrame based on the email column. Write a solution to remove these duplicate rows and keep only the first occurrence.Example
SQL
DataFrame customers
+-------------+--------+
| Column Name | Type |
+-------------+--------+
| customer_id | int |
| name | object |
| email | object |
+-------------+--------+Python solution
Python
import pandas as pd
def dropDuplicateEmails(customers: pd.DataFrame) -> pd.DataFrame:
return customers.drop_duplicates(subset=['email'])Complexity
| Measure | Complexity |
|---|---|
| Time | O(n) |
| Space | O(1) to O(n) auxiliary |
Related problems
Frequently asked questions
- How hard is LeetCode 2882. Drop Duplicate Rows?
- LeetCode 2882. Drop Duplicate Rows is rated Easy on LeetCode.
- What topics does LeetCode 2882. Drop Duplicate Rows cover?
- LeetCode 2882. Drop Duplicate Rows is tagged Pandas on LeetCode.