Python define column name in variable

Question

I'm writing a script for ArcMap

what I want is

rows = arcpy.UpdateCursor(featureClass) #open a cursor from data source
row = rows.next()
AddressFieldName = "row.ADD_FULL"
while row:
    s = AddressFieldName

but it doesn't work. originally

s = row.Add_FULL #Add_FULL is field column name

What can I do to solve this?

what you expect and what actually doesn't work? any errors? what is your current output? — Andersson
– Andersson, Commented Jul 20, 2015 at 14:15
Parsing error SyntaxError: invalid syntax when I use s = row + . + AddressFieldName and tried other ways that I could think of but about same — Minnu P
– Minnu P, Commented Jul 20, 2015 at 14:34
Please provide full error log (edit your question with adding log). Also let me know what is ADD_FULL method (I can't find description in google) and why you define s in 3 different ways: as string- "row.ADD_FULL", as method applying to row - s = row.Add_FULL (what is correct form ADD_FULL or Add_FULL???) and in some kind of mystery way- s = row + . + AddressFieldName? — Andersson
– Andersson, Commented Jul 20, 2015 at 16:01
This is the 4th definition of s :) Can you make required corrections to your question using following tips: specify input, your current code, error log, expected output... For now your question make no sense — Andersson
– Andersson, Commented Jul 20, 2015 at 20:21

Danfro · Accepted Answer · 2015-07-27 14:02:37Z

1

I am guessing that you do want to extract the field names of a Feature class and maybe the field values as well. You could try the following codesnippet:

rows = arcpy.SearchCursor(sourceFeatureClass)
fields = arcpy.ListFields(sourceFeatureClass)
fieldnames = ""
for field in fields:
    fieldnames += field.name
fulldata=""
for row in rows:
    data = ""
    for field in fields:
        data += row.getValue(field.name)
    fulldata += data

This way you do get all your fieldnames in "fields" and the data either per row in "data" or the all data of the featureclass in "fulldata"

answered Jul 27, 2015 at 14:02

Danfro

1965 bronze badges

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

Collectives™ on Stack Overflow

Python define column name in variable

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related