I have an output table from a tabular intersect that looks like this:
For any set of records that has the same 'Planning Polygon ID', 'ELCODE', and 'SeasonCode', I would like to delete the record with the lower 'PERCENTAGE', while retaining the 'OccProb' attribute. For example, in the above table, records 12 and 13 have matching 'Planning Polygon ID', 'ELCODE', and 'SeasonCode' fields, but their 'OccProb' is different. I would like to retain the 'OccProb' of the record that has the highest 'PERCENTAGE'. In this case, it would be Medium.
Summary Statistics gets me close by preserving the record with the max 'PERCENTAGE' value, but it does not retain the 'OccProb' field. Is there another way to do this? I will eventually be converting this into Python code, so Arcpy solutions are welcome.