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?