ArcPy Field Calculator – Using Calculate Field with ArcPy

arcpyfield-calculator

I have field that includes 2500 records with name RASTERVALU and type Double. I want to add another field with name Qi. My expression for Qi is equal to RASTERVALU but I don't know correct syntax.

infc = "E:/gis payannameh/Pychram_tabu/extractVP/net1.shp"
arcpy.AddField_management(infc, "Qi", "DOUBLE")
exp =  "Qi" == "!RATERVALU!"
arcpy.CalculateField_management(infc,"Qi", exp)

Best Answer

Try this:

import arcpy

infc = r"E:/gis payannameh/Pychram_tabu/extractVP/net1.shp"

arcpy.AddField_management(in_table=infc, field_name="Qi", field_type="DOUBLE")
arcpy.CalculateField_management(in_table=infc, field="Qi", expression='!RASTERVALUE!', expression_type="PYTHON")

I almost never use Calculate Field in Python, instead arcpy.da.UpdateCursor. I think it is more versatile and easier to get the correct syntax:

with arcpy.da.UpdateCursor(infc, ['RASTERVALUE','Qi']) as cursor:
    for row in cursor:
        row[1] = row[0]
        cursor.updateRow(row)

Related Solutions

[GIS] Calculate field in model builder using file name

I'm not sure where %Name% is coming from, so I may not be able to answer your question entirely, but wrapping something in exclamation points is how you get a value out a field in a python code block. %Name% is a model builder variable, not a field name. So remove the the exclamation points and just use %Name%[3:] and see if that works.

ArcGIS – Fixing VBScript if/then Syntax Error 000539 in Field Calculator

You need to pass the returned value in a variable, not reference the column itself.

Expression:

result

Codeblock:

if [ColumnB] > 0 then
    result = [ColumnA] / [ColumnB]
else
    result = 0
end if

Here's how the two parts fit together in the field calculator - my data doesn't have the same field names, but you get the idea.

enter image description here

Best Answer

Related Solutions

[GIS] Calculate field in model builder using file name

ArcGIS – Fixing VBScript if/then Syntax Error 000539 in Field Calculator

Related Question