0

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.

deepu2711
  • 59
  • 1
  • 7

0 Answers0