I have data (dataframe) with rows that are similar 2 by 2 on one column (id) but different on other columns. Among those columns, there is a value. I would like to keep only the row with the maximum value and discard the other
For Data like below, discard rows for a given ID with the min value
ID, Sub-ID, Value
1, 1, 5 => keep
1, 4, 3 => discard
2, 6, 10 => keep
2, 4, 1 => discard
3, 9, 0 => discard
3, 1, 1 => keep
..