For a dataframe such that:
| ID | COLUMN | COLUMN 2 |
|---|---|---|
| 711 | PEDRO | RED |
| 711 | PEDRO | GREEN |
| 711 | LUCAS | GREE |
| 600 | JUAN | BLUE |
| 599 | PEDRO | BLUE |
The result should be:
| ID | COLUMN | COLUMN 2 |
|---|---|---|
| 711 | PEDRO | RED |
| 711 | LUCAS | GREEN |
| 600 | JUAN | BLUE |
| 599 | PEDRO | BLUE |
Each ID, COLUMN pair must be unique. And also must return the COLUMN 2