I have a large shapefile with lots of duplicate records. However, each duplicate record has an accuracy rating. I want to remove all duplicate records with a lower accuracy rating.
This would be simple but there can be duplicate records with the same accuracy rating and I want to leave them in. This might be easier to show than to explain:
Key Accuracy
ABC 100
ABC 100
ABC 50
XYZ 100
XYZ 75
XYZ 75
123 50
123 20
123 20
In the above table I would want to keep the top two ABC records as they both have the best accuracy, but remove the last one. I would want to keep the top XYZ record but remove the other two. And I would want to keep the top 123 record as, although it doesn't have the best possible accuracy, it has the highest accuracy for that batch of duplicate records.
How do I do this using ArcPy?