current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 2 down vote favorite

I need to add value in a field in attribute table, the value is to be determined on the basis of value in another field in same attribute table but i am unable to deifne value in another field in the script, can anyone help me with it?

share|improve this question

2 Answers 2

up vote 1 down vote accepted

I've not used Arc 10.1 cursors, but it's apparently even easier there.

In 10.0, there are a few ways to go about it, but here's a basic, beginner's approach:

# Create a cursor on a feature class
cur = arcpy.UpdateCursor(myFeatureClass)

# Loop through the rows in the attribute table
for row in cur:
    # The variable sqMiles will get the value from the column
    # named 'Area_Miles'
    sqMiles = row.getValue('Area_Miles')
    # Calculate how many acres
    acres = (sqMiles * 640)
    # Assign the acres to a column named 'Area_Acres'
    row.setValue('Area_Acres', acres)
    # Apply the change
    cur.updateRow(row)

    # The loop will then move on to the next row/feature

A simpler, condensed version:

cur = arcpy.UpdateCursor(myFeatureClass)

for row in cur:
    row.setValue('Area_Acres', row.getValue('Area_Miles') * 640)
    cur.updateRow(row)

See: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//000v0000003m000000

share|improve this answer
    
Tom, please re-write ALL of ESRI's "Help Files" using the method you used in this answer. Then more people will understand, and the world will be a happier place. –  Jason Miller Jun 27 '13 at 14:58
up vote 0 down vote

Well, there are a few ways you can do this.

  1. If the calculation is fairly simple, I would use the Calculate Field tool. If you need to use the code_block parameter, I'd go with option #2 as it's not always easy getting the syntax correct in a script (or in the tool itself for that matter).

  2. If you are interested in scripting more in the future, I'd strongly recommend using cursors. You can write the values from one field into a Python list and perform your calculations on each item in the list with a for loop and then write the list back to your new field.

I rarely use Calculate Field anymore as it's easier to script cursors for all but the simplest formulas.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.