Calculating (with Python) a 2nd field based on a 1st field in 10.2

Question

I am attempting to write a script that takes one field and sorts it from largest to smallest. I then want to add another field next to the sorted field in order to indicate a sequential order of the first field (ranging from 1 to what ever is the last occurence is). In other words, calculate a numeric sequential order of a field and populate that field with numbers based and in conjunction with another field. Is it possible? Any tips ?

JoelGuerra · Answer

Also when entering the table in question (the table that is supposed to have its fields sorted), can I just put in/reference the shape file itself, or does it needs to be an actual excel or dbf table?

JoelGuerra · Answer

When running the script, it seems to have a problem with one of the lines. This is the error that is coming up;

with arcpy.da.cursor(table, field_to_sort) as cursor:
Attribute Error: 'module' object has no attribute 'cursor'

Just a reminder also, the "field_to_rank" variable is one that needs to be created in the table.

JoelGuerra · Answer

Looking it over I noticed the work space was not set. I'm assuming the code here comes after the workspace is set right? Sorry, I'm a newbie to Python. 🙂