topic Re: Update Cursor parsing error in Python Questions

Update Cursor parsing error

ClintonCooper1 — Tue, 22 Oct 2013 21:12:31 GMT

I am putting together some snippets of code and running into a parsing error: Parsing error SyntaxError: invalid syntax (line 8). The error seems to be on line: updateRows = arcpy.da.UpdateCursor(mainTbl, ["FULL_ADDRESS","FREQUENCY"])
I have tried all types of fixes, but cannot find the problem. I am running on 10.2

import arcpy  lutTbl = r"Database Servers\CLINTONCOOPER_SQLEXPRESS.gds\VOTERS_20133 (VERSION:dbo.DEFAULT)\VOTERS_20133.DBO.frequency" mainTbl = r"Database Servers\CLINTONCOOPER_SQLEXPRESS.gds\VOTERS_20133 (VERSION:dbo.DEFAULT)\VOTERS_20133.DBO.OHIO_VOTERS_GEOCODE_OCT142013_small"  lutDict = dict([(r.FULL_ADDRESS, (r.FREQUENCY)) for r in arcpy.da.SearchCursor(lutTbl, ["FULL_ADDRESS","FREQUENCY"])  updateRows = arcpy.da.UpdateCursor(mainTbl, ["FULL_ADDRESS","FREQUENCY"]) for updateRow in updateRows:     nameValue = updateRow.FULL_ADDRSS      if nameValue in lutDict:         updateRow[1] = lutDict[nameValue][0]  #Address     else:     updateRows.updateRow(updateRow) del updateRow, updateRows

Re: Update Cursor parsing error

JasonScheirer — Tue, 22 Oct 2013 21:23:48 GMT

You're mixing up arcpy.SearchCursor and arcpy.da.SearchCursor, among other issues (missing closing parens, indentation).

import arcpy  lutTbl = r"Database Servers\CLINTONCOOPER_SQLEXPRESS.gds\VOTERS_20133 (VERSION:dbo.DEFAULT)\VOTERS_20133.DBO.frequency" mainTbl = r"Database Servers\CLINTONCOOPER_SQLEXPRESS.gds\VOTERS_20133 (VERSION:dbo.DEFAULT)\VOTERS_20133.DBO.OHIO_VOTERS_GEOCODE_OCT142013_small"  lutDict = {r[0]: r[1] for r in arcpy.da.SearchCursor(lutTbl, ["FULL_ADDRESS","FREQUENCY"])}  with arcpy.da.UpdateCursor(mainTbl, ["FULL_ADDRESS","FREQUENCY"]) as updateRows:     for updateRow in updateRows:         nameValue = updateRow[0]         if nameValue in lutDict:             updateRow[1] = lutDict[nameValue][0]  #Address             updateRows.updateRow(updateRow)

Re: Update Cursor parsing error

ClintonCooper1 — Sat, 11 Dec 2021 16:11:34 GMT

With your changes, I am now getting a new error:

Runtime error
Traceback (most recent call last):
File "<string>", line 12, in <module>
TypeError: 'int' object has no attribute '__getitem__

based on this row:


updateRow[1] = lutDict[nameValue][0]

Re: Update Cursor parsing error

JasonScheirer — Tue, 22 Oct 2013 22:33:53 GMT

updateRow[1] = lutDict[nameValue]

Still don't quite understand what you're doing here.

Re: Update Cursor parsing error

ClintonCooper1 — Tue, 22 Oct 2013 22:55:25 GMT

The purpose of the code is to match the frequency table (convert it into a python dictionary), and then update a field in another file. In other words it is a fast way of doing a join/calc. If I understand the source where I got some of the code correctly, I am transferring the FREQUENCY filed data from the frequency.dbf (lutTbl) file into the mainTbl by way matching through the FULL_ADDRESS filed in each table.

Re: Update Cursor parsing error

ClintonCooper1 — Wed, 23 Oct 2013 17:07:43 GMT

So I was able to get the code working (without any errors) after I removed the [0] after the lutDict[nameValue] in code row:

updateRow[1] = lutDict[nameValue]

However It is not updating any new data in the mainTble field. Not sure where the code is going wrong.

Clinton

Re: Update Cursor parsing error

ClintonCooper1 — Sat, 11 Dec 2021 16:11:37 GMT

You're mixing up arcpy.SearchCursor and arcpy.da.SearchCursor, among other issues (missing closing parens, indentation).

import arcpy

lutTbl = r"Database Servers\CLINTONCOOPER_SQLEXPRESS.gds\VOTERS_20133 (VERSION:dbo.DEFAULT)\VOTERS_20133.DBO.frequency"
mainTbl = r"Database Servers\CLINTONCOOPER_SQLEXPRESS.gds\VOTERS_20133 (VERSION:dbo.DEFAULT)\VOTERS_20133.DBO.OHIO_VOTERS_GEOCODE_OCT142013_small"

lutDict = {r[0]: r[1] for r in arcpy.da.SearchCursor(lutTbl, ["FULL_ADDRESS","FREQUENCY"])}

with arcpy.da.UpdateCursor(mainTbl, ["FULL_ADDRESS","FREQUENCY"]) as updateRows:
    for updateRow in updateRows:
        nameValue = updateRow[0]
        if nameValue in lutDict:
            updateRow[1] = lutDict[nameValue][0]  #Address
            updateRows.updateRow(updateRow)

This solution worked after I removed the [0] bracket and added the del updateRow, updateRows