Update Rows in Database with items from list, Python

Question

I am trying to update a field in a database, row by row, with a list of values. The following script works fine, but I can't help thinking there might be a more efficient (or pretty) way to update rows with items from a list. Here, I've just set a counter and updated the rows with the changing index item of the list.

listAreas = [1234.45, 3456.67, 6547.87, 536.76, 34.10]

indexIncr = 0
with arcpy.da.UpdateCursor(databasePath, "ColumnName") as cursorArea:
    for rowArea in cursorArea:
        rowArea[0] = listAreas[indexIncr]
        cursorArea.updateRow(rowArea)
        indexIncr+=1

Rockybilly · Accepted Answer · 2015-12-23 17:20:58Z

1

I don't know if it is more pretty, but this seems more pythonic to me.

for indexIncr, rowArea in enumerate(cursorArea):
    rowArea[0] = listAreas[indexIncr]
    cursorArea.updateRow(rowArea)

answered Dec 23, 2015 at 17:20

Rockybilly

4,5403 gold badges27 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mike Over a year ago

I knew I was looking for something just a little more simple and creative. I use enumerate all the time but today, my brain totally forgot about it. thanks for the suggestion. Nice one :)

Collectives™ on Stack Overflow

Update Rows in Database with items from list, Python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related