I am trying to populate many new fields in a new table using values from fields in another table. I am hoping to use a combination of a da.search cursor dictionary and a da.update cursor to speed up this field update. I am not receiving any errors with this code, though the field values are not populating, and the fields remain blank after that script has completed. Any suggestions on what I might need to fix? "KEY_FIELD" is the unique identifier and is populated in both tables. search_feats = { f [ 0 ] : f [ 1 ] for f in arcpy . da . SearchCursor ( Table_1 , [ "key_field" , "field_2" , "field_3" , "field_4" , "field_5" , "field_6" ] ) } with arcpy . da . UpdateCursor ( Table_2 , [ "KEY_FIELD" , "FIELD_2" , "FIELD_3" , "FIELD_4" , "FIELD_5" , "FIELD_6" ] ) as upd_cur : for upd_row in upd_cur : CodeID = upd_row [ 0 ] if CodeID in search_feats : upd_row [ 1 ] = search_feats [ CodeID ] [ 0 ] #FIELD_2 upd_row [ 2 ] = search_feats [ CodeID ] [ 1 ] #FIELD_3 upd_row [ 3 ] = search_feats [ CodeID ] [ 2 ] #FIELD_4 upd_row [ 4 ] = search_feats [ CodeID ] [ 3 ] #FIELD_5 upd_row [ 5 ] = search_feats [ CodeID ] [ 4 ] #FIELD_6 upd_cur . updateRow ( upd_row ) del upd_cur

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; } } }

Using Search Cursor Dictionary/Update Cursor to Populate Many Fields Using Values from Another Table

TessOldemeyer

I am trying to populate many new fields in a new table using values from fields in another table. I am hoping to use a combination of a da.search cursor dictionary and a da.update cursor to speed up this field update.

I am not receiving any errors with this code, though the field values are not populating, and the fields remain blank after that script has completed. Any suggestions on what I might need to fix?

"KEY_FIELD" is the unique identifier and is populated in both tables.

search_feats <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>f<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>f<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">for</SPAN> f <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>Table_1<SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">"key_field"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"field_2"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"field_3"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"field_4"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"field_5"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"field_6"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">}</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>Table_2<SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">"KEY_FIELD"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"FIELD_2"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"FIELD_3"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"FIELD_4"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"FIELD_5"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"FIELD_6"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> upd_cur<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> upd_row <SPAN class="keyword token">in</SPAN> upd_cur<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CodeID <SPAN class="operator token">=</SPAN> upd_row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> CodeID <SPAN class="keyword token">in</SPAN> search_feats<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; upd_row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> search_feats<SPAN class="punctuation token">[</SPAN>CodeID<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token">#FIELD_2</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; upd_row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> search_feats<SPAN class="punctuation token">[</SPAN>CodeID<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token">#FIELD_3</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; upd_row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> search_feats<SPAN class="punctuation token">[</SPAN>CodeID<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token">#FIELD_4</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; upd_row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> search_feats<SPAN class="punctuation token">[</SPAN>CodeID<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token">#FIELD_5</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; upd_row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> search_feats<SPAN class="punctuation token">[</SPAN>CodeID<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token">#FIELD_6</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; upd_cur<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>upd_row<SPAN class="punctuation token">)</SPAN>&nbsp; 

<SPAN class="keyword token">del</SPAN> upd_cur‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<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>

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

Accepted answers

RandyBurton

Since you want to add several values to each dictionary key, you need to use f[0]:f[1:]. The colon is used for slicing and [1:] is equivalent to "1 to end". You may also wish to put your field names into a variable if both the search cursor and update cursor are working with the same field names. If the field types are the same in both tables, you shouldn't need to cast types. Hope this helps.

flds <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"KEY_FIELD"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"FIELD_2"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"FIELD_3"</SPAN><SPAN class="punctuation token">]</SPAN>

search_feats <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>f<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>f<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">for</SPAN> f <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>Table_1<SPAN class="punctuation token">,</SPAN>flds<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">}</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>Table_2<SPAN class="punctuation token">,</SPAN>flds<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> upd_cur<SPAN class="punctuation token">:</SPAN>‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

TessOldemeyer

Thank you both so much for your help. The list comprehension blog posts are great links to have, and thank you so much for sharing.

It turns out that I did need to use f[0]:f[1:] for the dictionary (hugely helpful) in addition to casting CodeID as an integer in line 5 of my initial posting.

RandyBurton

Since search_feats is set using list comprehension, you might want to check out Dan Patterson‌'s blogs on the topic:

List comprehensions...

List comprehensions... 2

List comprehensions 3 ...

(And Dan has lots of other interesting Python postings)

RandyBurton

flds <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"KEY_FIELD"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"FIELD_2"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"FIELD_3"</SPAN><SPAN class="punctuation token">]</SPAN>

search_feats <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>f<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>f<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">for</SPAN> f <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>Table_1<SPAN class="punctuation token">,</SPAN>flds<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">}</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>Table_2<SPAN class="punctuation token">,</SPAN>flds<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> upd_cur<SPAN class="punctuation token">:</SPAN>‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

TessOldemeyer

For some reason, I am really struggling with how to fix this issue. If I cast CodeID in line 5 as an integer, I am able to populate Table_2 fields with only one letter (rather than the entire text string from Table_1) before getting a 'string out of range error'. Maybe it would be best to change "key_field" in Table_1 to a text field using arcpy.TableToTable_conversion prior to creating the dictionary? I am not quite sure how to get field mappings to work for this though. Do you have any recommendations on how to most efficiently handle this?

Thank you so much for your help.

DanPatterson_Retired

if you want to cast integers to text

str(your number)

if you want to cast text to integers... ONLY if they can be

int(your text number ) ie int('1') will return 1

TessOldemeyer

It looks like the key field names are accurate and that they are both accurately populated in both tables. However, "key_field" in Table_1 has a 'double' field type, and "KEY_FIELD" in Table_2 is a text field. Is there an easy way to cast "key_field" as text in Table_1 by chance (if this might help to solve the issue)?

DanPatterson_Retired

oh.. you are using dictionaries, you need the dictionary 'key'.

the 'in' operator needs lists and other iterables, not dictionaries. Keys are iterable once extracted

sc <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'a'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'b'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>
dct <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>f<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>f<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">for</SPAN> f <SPAN class="keyword token">in</SPAN> sc<SPAN class="punctuation token">}</SPAN>

dct
<SPAN class="punctuation token">{</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'a'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'b'</SPAN><SPAN class="punctuation token">}</SPAN>

<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> sc<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; code <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> code <SPAN class="keyword token">in</SPAN> dct<SPAN class="punctuation token">.</SPAN>keys<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>&nbsp; <SPAN class="comment token"># need to get the code from the dictionary keys</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"has code"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
has code
has code<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>

TessOldemeyer

That must be what is going on. I receive a '61005 is in False' printout for all CodeID values. I'll dig into it a bit more to see what may be going on. Thanks!

DanPatterson_Retired

Which means that "CodeID in search_feats" fails and the row doesn't get updated.

To test, put a print statement just above your if

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"{} is in {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>CodeId<SPAN class="punctuation token">,</SPAN> CodeID <SPAN class="keyword token">in</SPAN> search_feats<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

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.