get highest value from colD groupby ColA & ColB
Input | |||
---|---|---|---|
ColA | ColB | Colc | ColD |
901 | 501 | 123 | 1 |
901 | 501 | 189 | 2 |
201 | 101 | 77 | 3 |
201 | 101 | 88 | 4 |
901 | 501 | 33 | 5 |
301 | 233 | 11 | 6 |
Output | |||
ColA | ColB | Colc | ColD |
901 | 501 | 33 | 5 |
201 | 101 | 88 | 4 |
301 | 233 | 11 | 6 |