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 Field Calculator >> PLEASE HELP!

Anonymous User

I need some assistance creating a ArcPy script to field calculate and display the value of a field based on the input of another field. I would like to show the value of attribute NS_Address if the Prefix attribute is N or S and I would like to show the value of attribute EW_Address if the Prefix attribute is E or W.

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

Accepted answers

DanPatterson_Retired

Make the address field active.

put the function in the code block.

the expression in the expression box

and calculate away

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">my_func</SPAN><SPAN class="punctuation token">(</SPAN>val<SPAN class="punctuation token">,</SPAN> fld1<SPAN class="punctuation token">,</SPAN> fld2<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">""" NS_Address if the Prefix attribute is N or S
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EW_Address if the Prefix attribute is E or W
&nbsp;&nbsp;&nbsp; """</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> val <SPAN class="keyword token">in</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'N'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'S'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> fld1
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">elif</SPAN> val <SPAN class="keyword token">in</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'E'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'W'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> fld2
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> None‍‍‍‍‍‍‍‍‍‍<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>

expression

my_func(!Prefix!, !NS_Address!, !EW_Address! )

All comments

DanPatterson_Retired

Assumed Answered....

I suppose

DanPatterson_Retired

Anthony, no problem

You should close the question so others can find the answer

Anonymous User

I just had to add a colon after the first line. The expression ran perfectly! Thank you!!!

Anonymous User

Dan,

Thanks for the reply. I received the error below when attempting to run that calculation.

DanPatterson_Retired

Make the address field active.

put the function in the code block.

the expression in the expression box

and calculate away

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">my_func</SPAN><SPAN class="punctuation token">(</SPAN>val<SPAN class="punctuation token">,</SPAN> fld1<SPAN class="punctuation token">,</SPAN> fld2<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">""" NS_Address if the Prefix attribute is N or S
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EW_Address if the Prefix attribute is E or W
&nbsp;&nbsp;&nbsp; """</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> val <SPAN class="keyword token">in</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'N'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'S'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> fld1
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">elif</SPAN> val <SPAN class="keyword token">in</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'E'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'W'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> fld2
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> None‍‍‍‍‍‍‍‍‍‍<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>

expression

my_func(!Prefix!, !NS_Address!, !EW_Address! )

forestknutsen1

Something like this? Untested code...

http://pro.arcgis.com/en/pro-app/arcpy/data-access/updatecursor-class.htm
https://www.tutorialspoint.com/python/string_split.htm

Python IF...ELIF...ELSE Statements

import arcpy
feature_class_path =r"xyz"

with arcpy.da.UpdateCursor(feature_class_path, ["NS_Address", "Address"]) as cursor:
    for row in cursor:
        row_parts = row.split(" ")
        prefix = ""
        if row_parts[0] == "N" or row_parts[0] == "S":
            prefix = "NS_Address"
        else:
            prefix = "EW_Address"
        row[1] = prefix + " " + row_parts[1] + " " + row_parts[2]
        cursor.updateRow(row)

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.