nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Calculate fields using logic with Python - standalone script

KK2

Hallo, I would like to ask how to populate a new attribute field using logic with python as standalone script without opening Raster Calculator and pasting the script attached below. How to assign with python the information from which attribute(s) and from which dataset the new attribute will be populated?

Expression:
Reclass(!WELL_YIELD!)

Code Block:
def Reclass(WellYield):
    if (WellYield >= 0 and WellYield <= 10):
        return 1
    elif (WellYield > 10 and WellYield <= 20):
        return 2
    elif (WellYield > 20 and WellYield <= 30):
        return 3
    elif (WellYield > 30):
        return 4

Find more posts tagged with

Accepted answers

danretired

Calculate Field (Data Management)—ArcGIS Pro | Documentation

arcpy.management.CalculateField(in_table, field, expression, {expression_type}, {code_block}, {field_type})

arcpy.CalculateField_management(inTable, fieldName, expression, "PYTHON3",
codeblock)

"getClass(short(!CLC1!))" # wrong

leave out short

"getClass(!CLC1!)"

AND the error says....

.... not a member of VB | PYTHON | PYTHON_9.3

and you put .... "PYTHON3",

try "PYTHON" or "PYTHON_9.3"

danretired

you don't need Shape

float(!SHAPE.CLC1!)

should be

!CLC1!

since that is the field you are using as the source information

danretired

Ahh field calculator

Calculate Field (Data Management)—ArcGIS Pro | Documentation

All comments

danretired

@KK2 Always use the current help files to validate syntax. You would not be the first one that gets led astray by "googling" for help.

I always navigate from here

ArcGIS Pro help—ArcGIS Pro | Documentation for general help

ArcGIS Pro geoprocessing tool reference—ArcGIS Pro | Documentation for tool information and

ArcGIS Pro Python reference—ArcGIS Pro | Documentation for python specific information.

Take care

KK2

Thank you again for your valuable help. Amending your suggestions helps me to run the script successfully. I used PYTHON3 before, because such example I have found on ESRI website.

With these changes the script works:

expression = "getClass(!CLC1!)"
# Execute CalculateField 
arcpy.CalculateField_management(inTable, fieldName, expression, "PYTHON", 
                                codeblock)

danretired

Calculate Field (Data Management)—ArcGIS Pro | Documentation

arcpy.management.CalculateField(in_table, field, expression, {expression_type}, {code_block}, {field_type})

arcpy.CalculateField_management(inTable, fieldName, expression, "PYTHON3",
codeblock)

"getClass(short(!CLC1!))" # wrong

leave out short

"getClass(!CLC1!)"

AND the error says....

.... not a member of VB | PYTHON | PYTHON_9.3

and you put .... "PYTHON3",

try "PYTHON" or "PYTHON_9.3"

KK2

Below I attach the updated script and the error message. I also changed 'float' to 'short' in expression line, because my attribute is saved as short, but it did not change anything.

# Import system modules
import arcpy
# Set environment settings
arcpy.env.workspace = "E:/CLC_data"

# Set local variables
inFeatures = "CLC"
fieldName = "NEW_code"
#fieldPrecision = 9
#fieldAlias = "refcode"
fieldLength = 50
 
# Execute AddField for new fields
arcpy.AddField_management(inFeatures, fieldName, "TEXT", field_length=fieldLength)

# Set local variables
inTable = "CLC"
expression = "getClass(short(!CLC1!))"

#Create NEW_code for CLC1
codeblock = """
def getClass(CLC1):  
  if (CLC1 == 1):  
    return 'A_1'  
  elif (CLC1 == 2):  
    return 'A_2'
  elif (CLC1 == 3):  
    return 'A_3'   	
  else:
	return 'error'"""
 	
# Execute CalculateField 
arcpy.CalculateField_management(inTable, fieldName, expression, "PYTHON3", 
                                codeblock)

Runtime error  Traceback (most recent call last):   File "<string>", line 3, in <module>   File "c:\program files (x86)\arcgis\desktop10.2\arcpy\arcpy\management.py", line 3183, in CalculateField     raise e ExecuteError: Failed to execute. Parameters are not valid. ERROR 000800: The value is not a member of VB | PYTHON | PYTHON_9.3. Failed to execute (CalculateField).  
>>>

danretired

Post a clean version of your script so we can see what changes were made. And your error message again too

KK2

Thank you for your reply. I have amended the script according to your suggestion, but unfortunately I still have the same error. It has to be something different, but I don't know what it is.

danretired

arcpy.env.workspace = "E:/CLC_data

the folder would be the workspace

What you have with the shapefile appended to it is the featureclass name

KK2

Thank you for your informative answer. I corrected the script accordingly, but unfortunately, I still have the same error. Do you see maybe some other error in my script that may cause this error? I think that I implemented everything like in the example on esri website, but it does not work.

danretired

you don't need Shape

float(!SHAPE.CLC1!)

should be

!CLC1!

since that is the field you are using as the source information

KK2

Thank you for the answer, it is what I was looking for.

However, I received an error while running the script, which was as follow:

Runtime error  Traceback (most recent call last):   File "<string>", line 3, in <module>   File "c:\program files (x86)\arcgis\desktop10.2\arcpy\arcpy\management.py", line 3183, in CalculateField     raise e ExecuteError: Failed to execute. Parameters are not valid. ERROR 000800: The value is not a member of VB | PYTHON | PYTHON_9.3. Failed to execute (CalculateField).

Do you know maybe what might be wrong in my code? I think it might be because of the line attached below, because the example code was taking area and I want to reclassify my input data to another classes and I am not sure if my implementation is correct. In the line attached below I wanted to take the attribute value to calculate the new attribute.

# Set local variables
inTable = "CLC"
expression = "getClass(float(!SHAPE.CLC1!))"

The entire code:

# Import system modules
import arcpy
# Set environment settings
arcpy.env.workspace = "E:/CLC_data/CLC.shp"

# Set local variables
inFeatures = "CLC"
fieldName = "NEW_code"
#fieldPrecision = 9
#fieldAlias = "refcode"
fieldLength = 50
 
# Execute AddField for new fields
arcpy.AddField_management(inFeatures, fieldName, "TEXT", field_length=fieldLength)

# Set local variables
inTable = "CLC"
expression = "getClass(float(!SHAPE.CLC1!))"

#Create NEW_code for CLC1
codeblock = """
def getClass(CLC1):  
  if (CLC1 == 1):  
    return 'A_1'  
  elif (CLC1 == 2):  
    return 'A_2'
  elif (CLC1 == 3):  
    return 'A_3'   	
  else:
	return 'error'"""
 	
# Execute CalculateField 
arcpy.CalculateField_management(inTable, fieldName, expression, "PYTHON3", 
                                codeblock)

danretired

Ahh field calculator

Calculate Field (Data Management)—ArcGIS Pro | Documentation

KK2

Thank you for the answer, but I am not working on raster but on polygon shapefile and I would like to run it as standalone python script, so I think the Con function will not help me much. I am looking for a script that indicates me the input data and input attributes in the attribute table from which the logic statement is evaluated to populate a new attribute in my polygon shapefile.

danretired

Use the spatial analyst's Con function.

It this example W is your WellYield raster.

OutRas = Con(W <= 10, 1, Con(W <= 20, 2, Con(W <= 30, 3, 4)))

or try

OutRas = RoundUp(Divide(W, 10.))

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.