I've got a number of shapefiles with some redundant data. I'm looking for a way to select where a single attribute occurs more than a certain number of times (in this case four) and remove them from the table. As I've searched online, all the results refer to the frequency tool, which is not what I need.
For example, in the image below, FIDs 11,12,13,and 14 are all of interest to me, but 15 and 16 are not. I want to select those and delete them.
I'm using Python because there are hundreds of points in a few dozen shapefiles that I've got, so automation is key.
I'm not looking for somebody to edit my code or write some code for me, I just need an idea of what tools I might use to accomplish this. I don't know how to go about selecting fields when the frequency of an attribute hits a certain frequency.