topic Re: I get invalid syntax in Python Questions

I get invalid syntax

G__EricCastillo_Morales — Thu, 10 Mar 2016 02:19:26 GMT

I 'm trying to run my script but I get this error message.

Here is the code.

import arcpy
from arcpy import env
env.workspace = r'D:\Eric\Ejercicio\shp\ejercicioTest.gdb\shp'
crbuff = r'D:\Eric\Ejercicio\shp\ejercicioTest.gdb\shp\CRojaPBuff'
insumo = r'D:\Eric\Ejercicio\shp\ejercicioTest.gdb\shp\Insumo'
# Add field to insumo.
arcpy.AddField_management(insumo, "test", "TEXT", "", "", "50", "", "NULLABLE", "NON_REQUIRED", "")
# Make a layer from crbuff to get the select by location works.
arcpy.MakeFeatureLayer_management (crbuff, 'crbuff_layer')
arcpy.MakeFeatureLayer_management (insumo, 'insumo_layer')
# loop with cursor
cursor = arcpy.SearchCursor(crbuff)
field = "Lab" # Specify the field in the loop.
for row in cursor:
print (row.getValue(field))
arcpy.SelectLayerByLocation_management('insumo_layer', "HAVE_THEIR_CENTER_IN", 'crbuff_layer', "", "NEW_SELECTION", "NOT_INVERT")
# Process: Calculate Field.
cursorIn = arcpy.UpdateCursor('insumo_layer')
for row in cursorIn:
row.setValue("test", (row.getValue(field))
cursorIn.updateRow(row)
# Process: Summary Statistics.
intable = r'D:\Eric\Ejercicio\shp\Insumo.shp'
outtable = r'D:\Eric\Ejercicio\shp'
arcpy.Statistics_analysis(intable, outtable + "stats.dbf", "POB1 SUM;POB8 SUM;POB11 SUM;POB14 SUM;POB15 SUM;POB16 SUM;POB24 SUM;POB31 SUM;POB57 SUM;MIG7 SUM;INDI1 SUM;DISC1 SUM;DISC4 SUM;DISC5 SUM;DISC6 SUM;ECO1 SUM;ECO4 SUM;ECO25 SUM;ECO28 SUM;SALUD1 SUM;SALUD2 SUM;SALUD3 SUM;SALUD4 SUM;SALUD5 SUM;SALUD6 SUM", "test")

I need help ...

Re: I get invalid syntax

Luke_Pinner — Thu, 10 Mar 2016 02:42:38 GMT

Extra bracket in 23.

row.setValue("test", (row.getValue(field))

Change it to: row.setValue("test", row.getValue(field))

Also, consider using arcpy.da.Search/InsertCursor instead of arcpy.Search/InsertCursor, the new (at 10.1) cursors are much faster and have easier and more "pythonic" syntax.

Re: I get invalid syntax

AdrianWelsh — Thu, 10 Mar 2016 02:47:18 GMT

Luke, nice catch. Also, how do you know when to use arcpy.da.SearchCursor versus using arcpy.SearchCursor?

Re: I get invalid syntax

XanderBakker — Thu, 10 Mar 2016 03:43:10 GMT

In most cases I would recommend using the da cursors, since they are much faster. I can only think of a few use cases for the "old" cursors like accessing the attribute table of the integer raster data set or when using ArcGIS 10.0. There is some more info here: Accessing data using cursors—Help | ArcGIS for Desktop

Re: I get invalid syntax

G__EricCastillo_Morales — Thu, 10 Mar 2016 15:41:00 GMT

Thanks Luke. That corrects the syntax problem. Now I get a new problem.

Traceback (most recent call last):

File "D:\Eric\Ejercicio\script\again.py", line 23, in <module>

row.setValue("test", row.getValue(field))

File "C:\Program Files (x86)\ArcGIS\Desktop10.3\ArcPy\arcpy\arcobjects\arcobjects.py", line 1096, in getValue

return convertArcObjectToPythonObject(self._arc_object.GetValue(*gp_fixargs(args)))

RuntimeError: ERROR 999999: Error executing function.

I'm trying to write in "test" field from insumo layer the value field from the select by location features loop of crbuff layer.

Re: I get invalid syntax

G__EricCastillo_Morales — Thu, 10 Mar 2016 16:12:25 GMT

I'm trying to write in test field from some layer based on iterate feature selction. I get succes using model builder but I'm fail when I try with my own code.

The process with MB.

The code and error.

Any suggestions?

Re: I get invalid syntax

G__EricCastillo_Morales — Thu, 10 Mar 2016 16:28:09 GMT

I decided to put this in another question. Thanks.