topic Re: Help with syntax error in Calculate Field tool in Python Questions

Help with syntax error in Calculate Field tool

KaydenSim — Wed, 29 Jul 2020 14:34:26 GMT

Hi Esri community, I am getting an error for a script I've written to calculate several fields. The error message says there is a syntax error, but I have tried to fix it and I don't know what I've done wrong. The error message is as follows:

Runtime error Traceback (most recent call last): File "<string>", line 97, in <module> File "c:\program files (x86)\arcgis\desktop10.3\arcpy\arcpy\management.py", line 3457, in CalculateField raise e ExecuteError: ERROR 000989: Python syntax error: Parsing error IndentationError: unexpected indent (line 1)

The script I used worked for every field except for the last one, which was the only field that needed codeblock to calculate. The portion of the script for the last field is as follows (line 97 is the last line) :

# Import system modules #
import arcpy
# Set environment settings #
arcpy.env.workspace = r"D:\mapsfolder"

# Set local variables for unassigned #
inTable = r"D:\mapsfolder\table.shp"
fieldName13 = "unassigned"
expression13 = "unassigned_fxn(!type1year!,!type2year!,!type1end!,!type2end!,!eventyear!,!occurrence!)"
codeblock13 = " " " def unassigned_fxn(inValue1, inValue2, inValue3, inValue4, inValue5, inValue6):
result1 = inValue1
result2 = inValue2
result3 = inValue3
result4 = inValue4
result5 = inValue5
result6 = inValue6
if result1 == 0 and result2 == 0 and result3 == 0 and result4 == 0:
return result5 * result6
else:
return 0" " "
# Execute Calculate Field #
arcpy.CalculateField_management(inTable, fieldName13, expression13, "PYTHON_9.3", codeblock13)

Thanks for any help!!

Re: Help with syntax error in Calculate Field tool

JoshuaBixby — Sun, 12 Dec 2021 00:12:36 GMT

You need to indent everything within a function definition. What you have now is the same as:

def unassigned_fxn(inValue1, inValue2, inValue3, inValue4, inValue5, inValue6):
result1 = inValue1
result2 = inValue2
....‍‍‍‍

and what you need is:

def unassigned_fxn(inValue1, inValue2, inValue3, inValue4, inValue5, inValue6):
    result1 = inValue1
    result2 = inValue2
    ....‍‍‍‍

Re: Help with syntax error in Calculate Field tool

DanPatterson — Sun, 12 Dec 2021 00:12:39 GMT

Notice how \n is inserted where appropriate and the indentation is maintained.

A 'print' statement will confirm everything

codeblock13 = """def unassigned_fxn(inValue1, inValue2, inValue3, inValue4, inValue5, inValue6):
    result1 = inValue1
    result2 = inValue2
    result3 = inValue3
    result4 = inValue4
    result5 = inValue5
    result6 = inValue6
    if result1 == 0 and result2 == 0 and result3 == 0 and result4 == 0:
         return result5 * result6
    else:
         return 0"""

codeblock13

'def unassigned_fxn(inValue1, inValue2, inValue3, inValue4, inValue5, inValue6):\n    result1 = inValue1\n    result2 = inValue2\n    result3 = inValue3\n    result4 = inValue4\n    result5 = inValue5\n    result6 = inValue6\n    if result1 == 0 and result2 == 0 and result3 == 0 and result4 == 0:\n         return result5 * result6\n    else:\n         return 0'

print(codeblock13)

def unassigned_fxn(inValue1, inValue2, inValue3, inValue4, inValue5, inValue6):
    result1 = inValue1
    result2 = inValue2
    result3 = inValue3
    result4 = inValue4
    result5 = inValue5
    result6 = inValue6
    if result1 == 0 and result2 == 0 and result3 == 0 and result4 == 0:
         return result5 * result6
    else:
         return 0‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Help with syntax error in Calculate Field tool

KaydenSim — Wed, 29 Jul 2020 19:19:03 GMT

Thanks for both of your help!

I am still getting an error saying I need an indent even when fix what you mentioned.... not sure why, especially when the code works when I use it in field calculator.

Re: Help with syntax error in Calculate Field tool

DanPatterson — Wed, 29 Jul 2020 19:24:54 GMT

you have a space after the triple quote... remove it

Re: Help with syntax error in Calculate Field tool

KaydenSim — Wed, 29 Jul 2020 19:34:44 GMT

Thanks for the help! unfortunately I am still getting an error message:

Re: Help with syntax error in Calculate Field tool

JoeBorgione — Wed, 29 Jul 2020 19:46:21 GMT

Look closely at 'result2 = inValue2' ; to me it looks like it's in one space extra. Compare how the r's line up above that line and below... (Using the syntax highliter rather than a screen shot would help...)

Re: Help with syntax error in Calculate Field tool

DanPatterson — Wed, 29 Jul 2020 19:54:41 GMT

codeblock = 'def unassigned_fxn(inValue1, inValue2, inValue3, inValue4, inValue5, inValue6):\n result1 = inValue1\n result2 = inValue2\n result3 = inValue3\n result4 = inValue4\n result5 = inValue5\n result6 = inValue6\n if result1 == 0 and result2 == 0 and result3 == 0 and result4 == 0:\n return result5 * result6\n else:\n return 0'

there was an extra space in your return sections

Re: Help with syntax error in Calculate Field tool

KaydenSim — Wed, 29 Jul 2020 20:25:31 GMT

Thanks that fixed the problem and it finally worked!!

Thanks to everybody who helped!

Re: Help with syntax error in Calculate Field tool

RockyRudolph — Sun, 12 Dec 2021 00:12:42 GMT

Alternatively, if you don't want the headache of getting the syntax perfect inside a big triple quote string, you can use an update cursor.

Something like this:

inTable = r"D:\mapsfolder\table.shp"
field_list = ["type1year","type2year","type1end","type2end","eventyear","occurrence", "unassigned"]
with arcpy.da.UpdateCursor(inTable, field_list) as cursor:
	for row in cursor:
		# Using any(), if any of those fields are not zero, this will execute.
		if any([row[0], row[1], row[2], row[3]]):
			result = row[4] * row[5]
		else:
			result = 0
			
		row[6] = result
		cursor.updateRow(row)‍‍‍‍‍‍‍‍‍‍‍‍

You also get more control of the values each field is returning and can deal with them more deftly.

Re: Help with syntax error in Calculate Field tool

awgeezrick — Thu, 06 May 2021 21:51:11 GMT

Thanks for this, it helped me out with a similar issue I was having.