Using SearchCursor and CalculateField

BenLeslie1

Hi - I'm trying to write a little bit of code to assign a random value to my ORIENT field where ORIENT = 0.

My problem is that it chages the ORIENT for the whole table not just where the value is zero.

I guess that this is because line 14 does not refer to row but I don't know how to charge it so it does refer to row - can anyone advise??

import arcpy

fc = r"c:\Test_Orient.shp"
feildName = "ORIENT"
expression = "rand_num()*360"
codeblock = """def rand_num():
    import random
    return random.random()"""
    
#search for rows to be altered
rows = arcpy.SearchCursor(fc, fieldName + " = 0")

for row in rows:
    arcpy.CalculateField_management(fc, fieldName, expression, "PYTHON_9.3", codeblock)

ChristopherMoravec1

Ben,

It might be easier in this case (and probably faster) to simply us a feature layer and your calculate field.  I would try something like this:

import arcpy
fc = r"c:\Test_Orient.shp"  
feildName = "ORIENT"  
expression = "rand_num()*360"  
codeblock = """def rand_num(): 
    import random 
    return random.random()"""  


arcpy.MakeFeatureLayer_management(fc, "TEST_ORIENT_LAYER", fieldName + " = 0")
arcpy.CalculateField_management("TEST_ORIENT_LAYER", fieldName, expression, "PYTHON_9.3", codeblock)

Using make feature layer makes an "in memory" pointer to the layer, much like adding the layer to an MXD does, it also happens to allow you to set a where clause.  Once you have this (I called it TEST_ORIENT_LAYER) then you can access it in almost any toolbox, as almost all of them take in a Feature Layer or a Feature Class (shape files included).  Check out the documentation here:

ArcGIS Help 10.1‌

As an aside, in my testing, until you want to calculate more than about 5 columns per row, it is faster to use a method like this as the Calc Field tool is faster than even a Data Access cursor until about 5 columns.  After 5 columns, you should probably open the cursor and do the calculations yourself.