Hello Community, I'm completely at a lost here. I have tried all possible combinations and was trying to figure out how to get this to work but it just doesn't work for me. The thing I am trying to accomplish is the following: I have 5 fields with a or b answers (1 or 0) and 5 fields with the correct solution. (also 1 or 0). Q1-5 and A1-5. I also have 5 fields with a Weight W1-5. I am trying to find a floating value of 0-1 based on the answer. This goes in the field Betrouwbaarheid This is what I have so far, which is to you very clearly incorrect. But I have tried a lot of different types of formatting without avail. Note: It's updated! Expression : calc ( !Q1! , !Q2! , !Q3! , !Q4! , !Q5! , !A1! , !A2! , !A3! , !A4! , !A5! , !W1! , !W2! , !W3! , !W4! , !W5 ) Code block : def calc ( Q1 , Q2 , Q3 , Q4 , Q5 , A1 , A2 , A3 , A4 , A5 , W1 , W2 , W3 , W4 , W5 ) : if Q1 == A1 : c1 = 1 else : c1 = 0 if Q2 == A2 : c2 = 1 else : c2 = 0 if Q3 == A3 : c3 = 1 else : c3 = 0 if Q4 == A4 : c4 = 1 else : c4 = 0 if Q5 == A5 : c5 = 1 else : c5 = 0 betr = ( c1 * W1 + c2 * W2 + c3 * W3 + c4 * W4 + c5 * W5 ) / ( W1 + W2 + W3 + W4 + W5 ) return betr Thanks to the people below a part was resolved. My new code gives no syntax errors. However, i still get an error when trying to do a field calculation. ERROR 000539: File " ", line 1 calc(, , , , , , , , , , , , , , ) ^ SyntaxError: invalid syntax Failed to execute (CalculateField). I hope anyone can shed me some light into how this codeblock programming works. It's a complete and utter mystery to me.

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 code block in field calculator

Thomvan_Oijen

Hello Community,

I'm completely at a lost here. I have tried all possible combinations and was trying to figure out how to get this to work but it just doesn't work for me.

The thing I am trying to accomplish is the following:

I have 5 fields with a or b answers (1 or 0) and 5 fields with the correct solution. (also 1 or 0).

Q1-5 and A1-5.

I also have 5 fields with a Weight

W1-5.

I am trying to find a floating value of 0-1 based on the answer. This goes in the field Betrouwbaarheid

This is what I have so far, which is to you very clearly incorrect. But I have tried a lot of different types of formatting without avail.

Note: It's updated!

Expression<SPAN class="punctuation token">:</SPAN>
calc<SPAN class="punctuation token">(</SPAN>!Q1!<SPAN class="punctuation token">,</SPAN> !Q2!<SPAN class="punctuation token">,</SPAN> !Q3!<SPAN class="punctuation token">,</SPAN> !Q4!<SPAN class="punctuation token">,</SPAN> !Q5!<SPAN class="punctuation token">,</SPAN> !A1!<SPAN class="punctuation token">,</SPAN> !A2!<SPAN class="punctuation token">,</SPAN> !A3!<SPAN class="punctuation token">,</SPAN> !A4!<SPAN class="punctuation token">,</SPAN> !A5!<SPAN class="punctuation token">,</SPAN> !W1!<SPAN class="punctuation token">,</SPAN> !W2!<SPAN class="punctuation token">,</SPAN> !W3!<SPAN class="punctuation token">,</SPAN> !W4!<SPAN class="punctuation token">,</SPAN> !W5<SPAN class="punctuation token">)</SPAN>

Code block<SPAN class="punctuation token">:</SPAN>
<SPAN class="keyword token">def</SPAN> <SPAN class="token function">calc</SPAN><SPAN class="punctuation token">(</SPAN>Q1<SPAN class="punctuation token">,</SPAN> Q2<SPAN class="punctuation token">,</SPAN> Q3<SPAN class="punctuation token">,</SPAN> Q4<SPAN class="punctuation token">,</SPAN> Q5<SPAN class="punctuation token">,</SPAN> A1<SPAN class="punctuation token">,</SPAN> A2<SPAN class="punctuation token">,</SPAN> A3<SPAN class="punctuation token">,</SPAN> A4<SPAN class="punctuation token">,</SPAN> A5<SPAN class="punctuation token">,</SPAN> W1<SPAN class="punctuation token">,</SPAN> W2<SPAN class="punctuation token">,</SPAN> W3<SPAN class="punctuation token">,</SPAN> W4<SPAN class="punctuation token">,</SPAN> W5<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">if</SPAN> Q1 <SPAN class="operator token">==</SPAN> A1<SPAN class="punctuation token">:</SPAN>
        c1 <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN>
    <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
        c1 <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>

    <SPAN class="keyword token">if</SPAN> Q2 <SPAN class="operator token">==</SPAN> A2<SPAN class="punctuation token">:</SPAN>
        c2 <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN>
    <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
        c2 <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
    
    <SPAN class="keyword token">if</SPAN> Q3 <SPAN class="operator token">==</SPAN> A3<SPAN class="punctuation token">:</SPAN>
        c3 <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN>
    <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
        c3 <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
        
    <SPAN class="keyword token">if</SPAN> Q4 <SPAN class="operator token">==</SPAN> A4<SPAN class="punctuation token">:</SPAN>
        c4 <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN>
    <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
        c4 <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>

    <SPAN class="keyword token">if</SPAN> Q5 <SPAN class="operator token">==</SPAN> A5<SPAN class="punctuation token">:</SPAN>
        c5 <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN>
    <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
        c5 <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
    
    betr <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>c1 <SPAN class="operator token">*</SPAN> W1 <SPAN class="operator token">+</SPAN> c2 <SPAN class="operator token">*</SPAN> W2 <SPAN class="operator token">+</SPAN> c3 <SPAN class="operator token">*</SPAN> W3 <SPAN class="operator token">+</SPAN> c4 <SPAN class="operator token">*</SPAN> W4 <SPAN class="operator token">+</SPAN> c5 <SPAN class="operator token">*</SPAN> W5<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">/</SPAN> <SPAN class="punctuation token">(</SPAN>W1 <SPAN class="operator token">+</SPAN> W2 <SPAN class="operator token">+</SPAN> W3 <SPAN class="operator token">+</SPAN> W4 <SPAN class="operator token">+</SPAN> W5<SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">return</SPAN> betr‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Thanks to the people below a part was resolved. My new code gives no syntax errors.

However, i still get an error when trying to do a field calculation.

 ERROR 000539:   File "<expression>", line 1
    calc(, , , , , , , , , , , , , , )
         ^
SyntaxError: invalid syntax
 Failed to execute (CalculateField).<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I hope anyone can shed me some light into how this codeblock programming works. It's a complete and utter mystery to me.

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

Accepted answers

DanPatterson_Retired

/blogs/dan_patterson/2016/08/14/script-formatting

so line numbers can be referred to

The code block shouldn't contain the field names in the exclamation marks. They should reference variables.

The expression lines makes reference to those. So the code block with a python parser goes in that section and the expression in its line. In the example below !Field1! is now linked to 'a' etc

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">fake_def</SPAN><SPAN class="punctuation token">(</SPAN>a<SPAN class="punctuation token">,</SPAN>b<SPAN class="punctuation token">,</SPAN>c<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="string token">"""fake function"""</SPAN>
    d <SPAN class="operator token">=</SPAN> a <SPAN class="operator token">+</SPAN> b <SPAN class="operator token">+</SPAN> c
    <SPAN class="keyword token">return</SPAN> d

<SPAN class="comment token"># expression</SPAN>

fake_def<SPAN class="punctuation token">(</SPAN>!Field1!<SPAN class="punctuation token">,</SPAN> !Field2!<SPAN class="punctuation token">,</SPAN> !Field3!<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>

All comments

Thomvan_Oijen

Thanks all! Problem is resolved.

Apparently, since I was using a Join, I had to specify the table name in the expression. So no !W5! but !Database.W5!

DanPatterson_Retired

Scott, it never got past the first line since a trailing ! was missing... see my previous post

ScottDrzyzga

Are all your weight fields (your Ws) stored using numeric data types? If any (or all) of your weight fields is (are) defined as text strings, then trying to multiply by a string will cause the calculation to fail.

VinceAngelo

Going back and editing the initial post is required in GIS SE, but it's confusing here, where there is no way to distinguish comments from answers. Far better to post edited code as a reply to the original post, so that your current code is provided as a snapshot in time.

- V

DanPatterson_Retired

!W5! you have !W5

Thomvan_Oijen

Thanks dan,

The used expression and code is in my opening post. I updated it.

It has the same amount of variabels in the code as I have fields in the expression. (so same amount of ,)

DanPatterson_Retired

can you copy your function and your expression.

if your function was...

def calc(,,,,,,,,)

and your expression was

calc(,,,,,,)

it will fail miserably since you didn't supply the field names to the expression, nor did you provide variable names to the function

Thomvan_Oijen

Thanks to the people above I finally know how to properly use fields in the code block.

Unfortunately I still get an error message. This time it gives the following error:

 ERROR 000539:   File "<expression>", line 1
    calc(, , , , , , , , , , , , , , )
         ^
SyntaxError: invalid syntax
 Failed to execute (CalculateField).<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Thomvan_Oijen

Thank you! You know this is not explained anywhere.

I'll update on a next post as it's not quite resolved yet.

DanPatterson_Retired

/blogs/dan_patterson/2016/08/14/script-formatting

so line numbers can be referred to

The code block shouldn't contain the field names in the exclamation marks. They should reference variables.

The expression lines makes reference to those. So the code block with a python parser goes in that section and the expression in its line. In the example below !Field1! is now linked to 'a' etc

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">fake_def</SPAN><SPAN class="punctuation token">(</SPAN>a<SPAN class="punctuation token">,</SPAN>b<SPAN class="punctuation token">,</SPAN>c<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="string token">"""fake function"""</SPAN>
    d <SPAN class="operator token">=</SPAN> a <SPAN class="operator token">+</SPAN> b <SPAN class="operator token">+</SPAN> c
    <SPAN class="keyword token">return</SPAN> d

<SPAN class="comment token"># expression</SPAN>

fake_def<SPAN class="punctuation token">(</SPAN>!Field1!<SPAN class="punctuation token">,</SPAN> !Field2!<SPAN class="punctuation token">,</SPAN> !Field3!<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>

VinceAngelo

You haven't defined the Python variables Q1/A1/W1/Q2/A2/W2/Q3/A3/W3/Q4/A4/W4/Q5/A5/W5 (by adding them to parameter list?) and don't use Python syntax to reference the W? variables in the code block.

The expression should look like

computeFn(!var1!,...!varN!)
‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

And the code block like

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">computeFn</SPAN><SPAN class="punctuation token">(</SPAN>var1<SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>varN<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
     <SPAN class="keyword token">return</SPAN> var1 <SPAN class="operator token">*</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>

- V

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.