Deleting multiple rows in attribute table (conditional, where there are 10 records of less)

Question

Hi,

I need to select and delete records from an attribute table where there are fewer than 10 records/rows for a particular field (shipid).  Unfortunately the data set is very large, so it's not possible to do it manually.  So wondered if there is a way of doing this via select attribute? or similar?  I'm working with ArcPro. Thanks

DanPatterson · Answer

You would have then summarize statistics on that field (a count obviously)  to identify those candidates first

Summary Statistics (Analysis)—ArcGIS Pro | Documentation

once found (sort descending on the count) you could then delete what you want

Kate_Gormley_abdn · Answer

Maybe not quite, but will have a look thanks - the shipID is identical for lots of records, but I only want to delete where there are less than 10 records. (some may have 100's of points for the same shipid for example)

DanPatterson · Answer

Are they duplicates?

Find Identical (Data Management)—ArcGIS Pro | Documentation

Delete Identical (Data Management)—ArcGIS Pro | Documentation

read carefully before you do anything... and try on a copy of the file if this is what you are after