Python Code for deleting identical values from one column - ArcMap [closed]

Question

I need Python code for deleting all identical values which are compared within one column.

As you can see in the image there are many identical values which I want to get rid of. I tried the delete identical tool but it won´t work in my situation. It could be that I just used it wrong but as I thought the tool only compares values between columns and not within one row.

Does anybody have a solution for me? Python or Toolbox-Tool? The identical rows and features should be deleted and one of them should be kept.

Answer 1

You could use a search cursor and list to check for and delete duplicates.

import arcpy

fc = r'path'

addr = []
with arcpy.da.UpdateCursor(fc, "ADRESSE") as cursor:
    for row in cursor:
        if not row[0] in addr:
            addr.append(row[0])
        else:
            cursor.deleteRow()