196. Delete Duplicate Emails.md

196. Delete Duplicate Emails

Question Link

Padas Solution

import pandas as pd

# Modify Person in place
def delete_duplicate_emails(person: pd.DataFrame) -> None:
    person.sort_values(by='id',ascending=True,inplace=True)
    person.drop_duplicates(subset='email',keep='first',inplace=True)
    # return person

SQL Solution

# Write your MySQL query statement below
delete p1 from Person p1, Person p2
where p1.email=p2.email and p1.id>p2.id