Update Cursor parsing error

[ClintonCooper1]

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 

[JasonScheirer · Accepted solution]

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)

[ClintonCooper1]

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]

[JasonScheirer]

updateRow[1] = lutDict[nameValue]

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

[ClintonCooper1]

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.

[ClintonCooper1]

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

[ClintonCooper1]

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