Calculate value python 3

MarkBalman

Hi all

Am struggling to work out how to update a value for an integer attribute (SLD) that is based on the values in 3 other integer fields "P", "O", "S".

The following is the code I could use in ArcGIS for Desktop 10.7.1 calculate field (and based on VB):

Dim x
if

= 1 AND = 1 AND = 1 Then
x = 1
elseIf

= 1 AND = 1 AND = 2 Then
x = 2
elseIf

= 1 AND = 1 AND = 3 Then
x = 3
elseIf

= 1 AND = 2 AND <= 4 Then
x = 4
elseIf

= 1 AND = 3 AND <> 4 Then
x = 5
elseIf

= 1 AND = 5 AND <= 3 Then
x = 6
elseIf

= 4 AND <> 4 AND <= 5 Then

x = 7

else
x = 0

end if

If anyone can provide me with some suggestions as to how to convert this into python 3 within ArcGIS Pro I would be most appreciative,

Many thanks,

Mark

KClarkDev_GIS

Hi Mark,

This should get you what you need:

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">fieldCalc</SPAN><SPAN class="punctuation token">(</SPAN>f1<SPAN class="punctuation token">,</SPAN> f2<SPAN class="punctuation token">,</SPAN> f3<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    x <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
    <SPAN class="keyword token">if</SPAN> f1 <SPAN class="operator token">==</SPAN> <SPAN class="number token">1</SPAN> <SPAN class="operator token">and</SPAN> f2 <SPAN class="operator token">==</SPAN> <SPAN class="number token">1</SPAN> <SPAN class="operator token">and</SPAN> f3 <SPAN class="operator token">==</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN>
        x <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN>
    <SPAN class="keyword token">elif</SPAN> f1 <SPAN class="operator token">==</SPAN> <SPAN class="number token">1</SPAN> <SPAN class="operator token">and</SPAN> f2 <SPAN class="operator token">==</SPAN> <SPAN class="number token">1</SPAN> <SPAN class="operator token">and</SPAN> f3 <SPAN class="operator token">==</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">:</SPAN>
        x <SPAN class="operator token">=</SPAN> <SPAN class="number token">2</SPAN>
    <SPAN class="keyword token">elif</SPAN> f1 <SPAN class="operator token">==</SPAN> <SPAN class="number token">1</SPAN> <SPAN class="operator token">and</SPAN> f2 <SPAN class="operator token">==</SPAN> <SPAN class="number token">1</SPAN> <SPAN class="operator token">and</SPAN> f3 <SPAN class="operator token">==</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">:</SPAN>
        x <SPAN class="operator token">=</SPAN> <SPAN class="number token">3</SPAN>
    <SPAN class="keyword token">elif</SPAN> f1 <SPAN class="operator token">==</SPAN> <SPAN class="number token">1</SPAN> <SPAN class="operator token">and</SPAN> f2 <SPAN class="operator token">==</SPAN> <SPAN class="number token">2</SPAN> <SPAN class="operator token">and</SPAN> f3 <SPAN class="operator token"><=</SPAN> <SPAN class="number token">4</SPAN><SPAN class="punctuation token">:</SPAN>
        x <SPAN class="operator token">=</SPAN> <SPAN class="number token">4</SPAN>
    <SPAN class="keyword token">elif</SPAN> f1 <SPAN class="operator token">==</SPAN> <SPAN class="number token">1</SPAN> <SPAN class="operator token">and</SPAN> f2 <SPAN class="operator token">==</SPAN> <SPAN class="number token">3</SPAN> <SPAN class="operator token">and</SPAN> f3 <SPAN class="operator token">!=</SPAN> <SPAN class="number token">4</SPAN><SPAN class="punctuation token">:</SPAN>
        x <SPAN class="operator token">=</SPAN> <SPAN class="number token">5</SPAN>
    <SPAN class="keyword token">elif</SPAN> f1 <SPAN class="operator token">==</SPAN> <SPAN class="number token">1</SPAN> <SPAN class="operator token">and</SPAN> f2 <SPAN class="operator token">==</SPAN> <SPAN class="number token">5</SPAN> <SPAN class="operator token">and</SPAN> f3 <SPAN class="operator token"><=</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">:</SPAN>
        x <SPAN class="operator token">=</SPAN> <SPAN class="number token">6</SPAN>
    <SPAN class="keyword token">elif</SPAN> f1 <SPAN class="operator token">==</SPAN> <SPAN class="number token">4</SPAN> <SPAN class="operator token">and</SPAN> f2 <SPAN class="operator token">!=</SPAN> <SPAN class="number token">4</SPAN> <SPAN class="operator token">and</SPAN> f3 <SPAN class="operator token"><=</SPAN> <SPAN class="number token">5</SPAN><SPAN class="punctuation token">:</SPAN>
        x <SPAN class="operator token">=</SPAN> <SPAN class="number token">7</SPAN>
    <SPAN class="keyword token">return</SPAN> x‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<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>

The above code would be put in the Code Block, and you would call the function with SLD = fieldCalc(!P!, !O!, !S!)

Some of the major differences between VB Script and Python in relation to this code segment:

• Field names are referenced by surrounding the name with ! instead of [ ] 
• The "and" operator is lowercase in Python
• If statements end with a colon instead of the word "THEN"
• In Python, the == means "is equivalent to", whereas the single = is used to assign a value to a variable
• In Python, use != for "does not equal" rather than <>
• In Python, use "elif" instead of "elseif"
• Don't forget the return statement at the end!

Luckily, there are countless resources online where you can get even more information about operators and logical statements in Python. 

There is likely an even fancier way to do this, but my version should work and it was the simplest adaptation from your code. 

Hope that helps!

-Katherine