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

ArcPy Update Cursor if/else

ModernGIS

Good Afternoon:

I have been doing multiple searches on how to correctly write an if/else statement using Update Cursor to update a specific field based on the criteria in a different field, and lets say I got nothing.

Looking for a little help on how to write this:

I have a field called BILLING_MONTH_TEXT (text) and another field called BILLING_DATE (text).

What I need to do is say (As an Example) if BILLING_MONTH_TEXT is May-2019 then it would update BILLING_DATE with a value of 30. If it is April-2019, the value would be 29. And so on and so on.

If I could get started, I can figure out how to fill in the remaining months and values.

Thank You for your help.

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

Accepted answers

JoeBorgione

As mentioned, untested, but....

dateDict <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'April'</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">29</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'May'</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">31</SPAN><SPAN class="punctuation token">}</SPAN>
keyValue <SPAN class="operator token">=</SPAN> <SPAN class="string token">'April'</SPAN>
<SPAN class="keyword token">if</SPAN> keyValue <SPAN class="keyword token">in</SPAN> dateDict<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>dateDict<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN>keyValue<SPAN class="punctuation token">,</SPAN><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="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Just worked for me, returning 29. See if this revised code works for you:

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>target<SPAN class="punctuation token">,</SPAN>updateFields<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> updateRows<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">for</SPAN> updateRow <SPAN class="keyword token">in</SPAN> updateRows<SPAN class="punctuation token">:</SPAN>
        keyValue <SPAN class="operator token">=</SPAN> updateRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
        <SPAN class="keyword token">if</SPAN> keyValue <SPAN class="keyword token">in</SPAN> monthDict<SPAN class="punctuation token">:</SPAN>
           updateRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> monthDict<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN>keyValue<SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
           updateRows<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>updateRow<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Got the idea from: https://www.tutorialspoint.com/python/dictionary_get.htm

All comments

JoeBorgione

Dictionaries are cool; they take a moment to get your head wrapped around them, but they are worth the effort. Same goes for update cursors. This forum is where I learned about both, with a ton of guidance from Joshua Bixby‌

ModernGIS

Thank You Joe. That worked. I checked the table in ArcCatalog after running the script and the field I needed updating in-fact had the series of 29(s) and 30(s) updated.

Going to spend some time learning more about Dictionaries and Update Cursor from the information you attached to this post.

ModernGIS

Joshua:

Yes, in a nut shell that would be correct.

I have a series of Model(s) in ArcToolBox that runs my process for me (Billing Data) and it takes several hours to run the process. I am working on transitioning the model(s) to python scripts to make the process run faster and maybe run it automatically through a series of batch file(s).

bixb0012

So effectively your final data would look something like:

BILL_DATE	BILL_MONTH
Dec-2016	1
Dec-2016	1
Jan-2017	2
...	...
June-2018	19
...	...
June-2018	19
July-2018	20
...	...
May-2019	30

ModernGIS

I think I am being a little vague on what I am trying to do. I have a table of reading data (approx 15,000 records) of approx 30 months. I have one field that is the billing date (ex. May-2019). The other field is the billing month (ex. 30). Basically, I started with Dec-2016 which has a value of 1, Jan-2017 which is assigned a value of 2 and so on and so forth to May-2019. A previous step uses the Convert Date tool to get the May-2019. This step is to update the Billing Month field based on the value in the Billing Date field.

Hope this helps and makes more sense.

JoeBorgione

As mentioned, untested, but....

dateDict <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'April'</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">29</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'May'</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">31</SPAN><SPAN class="punctuation token">}</SPAN>
keyValue <SPAN class="operator token">=</SPAN> <SPAN class="string token">'April'</SPAN>
<SPAN class="keyword token">if</SPAN> keyValue <SPAN class="keyword token">in</SPAN> dateDict<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>dateDict<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN>keyValue<SPAN class="punctuation token">,</SPAN><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="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Just worked for me, returning 29. See if this revised code works for you:

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>target<SPAN class="punctuation token">,</SPAN>updateFields<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> updateRows<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">for</SPAN> updateRow <SPAN class="keyword token">in</SPAN> updateRows<SPAN class="punctuation token">:</SPAN>
        keyValue <SPAN class="operator token">=</SPAN> updateRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
        <SPAN class="keyword token">if</SPAN> keyValue <SPAN class="keyword token">in</SPAN> monthDict<SPAN class="punctuation token">:</SPAN>
           updateRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> monthDict<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN>keyValue<SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
           updateRows<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>updateRow<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Got the idea from: https://www.tutorialspoint.com/python/dictionary_get.htm

bixb0012

Taking a step back, are you looking to set the billing date on the second to last day of each month?

ModernGIS

Joe:

Thank you for taking a look and providing me with additional information to look at. I build the script example you sent me. However, I am getting this error:

updateRow[1] = monthDict[keyValue][0]
TypeError: 'int' object has no attribute '__getitem__'

Any advice?

JoeBorgione

Rather than an if elif else block, you might want to take a look at https://community.esri.com/blogs/richard_fairhurst/2014/11/08/turbo-charging-data-manipulation-with-python-cursors-and-dictionaries.

I've used Richard's approach more than once and it's pretty slick. In your case, you would make a dictionary of Month/Number pairs of keys and values like this:

monthDict <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'April'</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">29</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'May'</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">30</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Month'</SPAN><SPAN class="punctuation token">:</SPAN>Number<SPAN class="punctuation token">}</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

and your update cursor might look something like this:

target = 'your feature class'
updateFields = ‍‍['BILLING_MONTH_TEXT', 'BILLING_DATE']

with arcpy.da.UpdateCursor(target,updateFields) as updateRows:
    for updateRow in updateRows:
        keyValue = updateRow[0]
        if keyValue in monthDict:
           updateRow[1] = monthDict[keyValue][0]
           updateRows.updateRow(updateRow)‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Untested...

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.