I have a dataframe like below-
|id|total|status|
|1|30|Pending|
|2|26|complete|
|1|40|complete|
|3|35|Pending|
|2|45|complete|
Want to achieve below output, get the max of total column based on id column and also achieve the corresponding status column value.-
|id|total|status|
|1|40|complete|
|2|45|complete|
|3|35|Pending|
Thanks in advance for any help with this.