I need to be able to add increments to duplicates in the P_ID field like below with arcpy. No sure how to though. P_ID 23560 -->0 P_ID 23560 -->1 P_ID 23560 -->2 P_ID 23560 -->3 P_ID 23560 -->4 P_ID 23571 -->0 P_ID 23571 -->1 P_ID 23571 -->2. I am working with the following code that adds 'Y' or 'No' in search of duplicates. Duplicates get a 'Y' and none Duplicates get 'N'. import arcpy #find Duplicate records, add Y or N in updateFeild inShapefile = 'VacantLots' checkField = "P_ID" updateField = "Count" with arcpy . da . SearchCursor ( inShapefile , [ checkField ] ) as rows : values = [ r [ 0 ] for r in rows ] d = { } for item in set ( values ) : if values . count ( item ) > 1 : d [ item ] = 'Y' else : d [ item ] = 'N' with arcpy . da . UpdateCursor ( inShapefile , [ checkField , updateField ] ) as rows : for row in rows : if row [ 0 ] in d : row [ 1 ] = d [ row [ 0 ] ] rows . updateRow ( row )

Can you post your revised code?

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Find Duplicates records

CCWeedcontrol

I need to be able to add increments to duplicates in the P_ID field like below with arcpy. No sure how to though.

P_ID 23560 -->0

P_ID 23560 -->1

P_ID 23560 -->2

P_ID 23560 -->3

P_ID 23560 -->4

P_ID 23571 -->0

P_ID 23571 -->1

P_ID 23571 -->2.

I am working with the following code that adds 'Y' or 'No' in search of duplicates. Duplicates get a 'Y' and none Duplicates get 'N'.

<SPAN class="keyword token">import</SPAN> arcpy

<SPAN class="comment token">#find Duplicate records, add Y or N in updateFeild</SPAN>

inShapefile <SPAN class="operator token">=</SPAN> <SPAN class="string token">'VacantLots'</SPAN>
checkField <SPAN class="operator token">=</SPAN> <SPAN class="string token">"P_ID"</SPAN>
updateField <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Count"</SPAN>

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>inShapefile<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN>checkField<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> rows<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; values <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>r<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">for</SPAN> r <SPAN class="keyword token">in</SPAN> rows<SPAN class="punctuation token">]</SPAN>

d <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN>
<SPAN class="keyword token">for</SPAN> item <SPAN class="keyword token">in</SPAN> set<SPAN class="punctuation token">(</SPAN>values<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> values<SPAN class="punctuation token">.</SPAN>count<SPAN class="punctuation token">(</SPAN>item<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">></SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; d<SPAN class="punctuation token">[</SPAN>item<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Y'</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; d<SPAN class="punctuation token">[</SPAN>item<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'N'</SPAN>

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>inShapefile<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN>checkField<SPAN class="punctuation token">,</SPAN> updateField<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> rows<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> rows<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">in</SPAN> d<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> d<SPAN class="punctuation token">[</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rows<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Najděte více příspěvků označených jako

Accepted answers

All comments

CCWeedcontrol

I tried it both ways i get the '0's'.

RandyBurton

Are you working with a shape file in ArcMap's python window? If so, I think you need to be in an edit session for the shape file to be updated. Or are you working with a feature in a file geodatabase?

CCWeedcontrol

Good point about which one is the original ID but for this case i don't need to actually know which is the original ID. It's a notification list to mail out notices and there is numerous double parcels. I need to remove the duplicates so when staff mails out letters their not sending out 3-7 letters to the same address.

I have ran into the case where people have requested every road name in our county. Our road center line is broken into numerous segments so i need to identify duplicates so this would be something i could use a number of ways.

CCWeedcontrol

I tried the code you posted but everything in the filed was just '0'. I did look at the link you posted and I had something similar to this but i had the same results

RandyBurton

This uses Arkadiusz Matoszka‌'s suggestion (from the link I posted above). It uses a dictionary in a manner similar to what you were trying. But it can run inside the UpdateCursor block, so you don't need the SearchCursor code. (Also, "Count" might not be a good field name as it may be an SQL reserved word.)

<SPAN class="keyword token">import</SPAN> arcpy

<SPAN class="comment token"># find duplicate records and count them in dictionary</SPAN>

inShapefile <SPAN class="operator token">=</SPAN> <SPAN class="string token">'VacantLots'</SPAN>
checkField <SPAN class="operator token">=</SPAN> <SPAN class="string token">"P_ID"</SPAN>
updateField <SPAN class="operator token">=</SPAN> <SPAN class="string token">"fieldCount"</SPAN> <SPAN class="comment token"># renamed field</SPAN>

d <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN> <SPAN class="comment token"># dictionary for counting</SPAN>

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>inShapefile<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN>checkField<SPAN class="punctuation token">,</SPAN> updateField<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> rows<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> rows<SPAN class="punctuation token">:</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">not</SPAN> <SPAN class="keyword token">in</SPAN> d<SPAN class="punctuation token">.</SPAN>keys<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; d<SPAN class="punctuation token">[</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN> <SPAN class="comment token"># insert key into dictionary and set value to 0</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN> <SPAN class="comment token"># value into updateField</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; d<SPAN class="punctuation token">[</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+=</SPAN> <SPAN class="number token">1</SPAN> <SPAN class="comment token">#increment value in dictionary</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>d<SPAN class="punctuation token">[</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># save value in updateField (str for text field)</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rows<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

RandyBurton

An old thread that might help: Identify duplicate records & increment

bixb0012

Several variations of this question have been asked in the past 6, maybe 12, months. I can't recall all of those other questions/discussions, but https://community.esri.com/thread/192311-find-duplicate-by-comparing-two-fields is one of them.

A quick question though. Since a group of records all share the same P_ID, how do you know which one is the original and which are the duplicates? Is the lowest ObjectID/FID the original?

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.