topic Re: Duplicate Values in Python Snippets Questions

Duplicate Values

RickWarner — Fri, 19 Sep 2014 17:08:23 GMT

I have a table that has one field with duplicate values. Is there any code that will label the duplicates 0, 1, 2, 3, 4 ..., rather than 0 and 1 as the following code does which I've found on ESRI's web site.

Python parser, and use then use the following codebook.

uniqueList = []

def isDuplicate(inValue):

if inValue in uniqueList:

return 1

else:

uniqueList.append(inValue)

return 0

isDuplicate(!PCN!)

Re: Duplicate Values

forestknutsen1 — Fri, 19 Sep 2014 17:19:36 GMT

I am not sure I understand. You are saying that you have a field that has values like 1,2,2,3,4,4,5 etc. and you want 1,2,3,4,5,6 what is the value of this. Why not just use the OID if you need a UID (unique identifier). If this will not work- what you want can be done with python using an UpdateCursor: here is info on it.

ArcGIS Help 10.1

then just update the row with a count variable. and increment it each time though the loop. count += 1 i.e. count = count + 1

Re: Duplicate Values

BrianCarson2 — Fri, 19 Sep 2014 18:25:53 GMT

uniqueList={}
def isDuplicate(inValue):
    global uniqueList
    if inValue in uniqueList.keys():
        uniqueList[inValue] += 1
        return uniqueList[inValue]
    else:
        uniqueList[inValue] = 0
        return uniqueList[inValue]

Using the Python Parser, insert the following into the code block.

This will perform the same operation as the above, but will increment the duplicate records as 0, 1, 2, 3 ... and then revert to 0 when it hits the next unique value.

At the end you would then use the isDuplicate(!<Your Field Name>!)

Re: Duplicate Values

RickWarner — Sat, 20 Sep 2014 18:10:20 GMT

Brian, thank you so much, it worked perfectly.

Re: Duplicate Values

DanPatterson_Retired — Fri, 17 Oct 2014 00:46:10 GMT

this thread still remains open, if a solution was provided please select the correct answer to finalize the discussion

Re: Duplicate Values

RickWarner — Sat, 18 Oct 2014 00:35:56 GMT

This best answer which worked perfectly was by B Carslon.

Thanks so much…