Remove rows that repeat exactly
Your task
Given contacts with columns email and name, drop rows that duplicate another row across BOTH columns, keeping the first. Return email and name, sorted by email ascending and then name ascending.
Examples
dedupe_rows(contacts: dataframe) -> dataframeExample 1
Input
dedupe_rows(contacts)contacts
| name | |
|---|---|
| a@x.com | Ann |
| b@x.com | Bob |
| a@x.com | Ann |
| c@x.com | Cy |
| b@x.com | Bobby |
Output
| name | |
|---|---|
| a@x.com | Ann |
| b@x.com | Bob |
| b@x.com | Bobby |
| c@x.com | Cy |