I have a feature class with two fields of interest: "name" and "identifier" (Original Data; Figure 1). Note that there are several duplicate rows in the table and the table may or may not be sorted, as it is in this example.
I'm interested in selecting, and/or removing, duplicate rows if the identifier is a duplicate within each "name" group (e.g. A, B, C...). In the example, name "C" has two identifiers "abcd", so the duplicate would need to be selected and/or removed. I'm working with ArcGIS Desktop Basic or QGIS and python. I'm thinking that referencing a dictionary or some fancy SQL expression might do the trick, but hoping there may be an easier solution. How can I find duplicate records based on multiple fields?