Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def normNum(num):
- arcpy.Statistics_analysis(r'C:Geodatabase.gdbOriginal_Features',r'C:Geodatabase.gdbTemp_Table', [["Field1","MIN"],["Field1","MAX"]])
- with arcpy.da.SearchCursor(r'C:Geodatabase.gdbTemp_Table', ("MAX_Field1" , "MIN_Field1")) as cursor:
- for row in cursor:
- maxNum = row[0]
- minNum = row[1]
- del cursor
- del row
- arcpy.Delete_management(r'C:Geodatabase.gdbTemp_Table')
- return ((num - minNum) / ( maxNum - minNum))
- normNum(!Field1!)
- def NormalizedNumbersToField(table, field, scratchGDB):
- arcpy.AddField_management(table, "NORMALIZED", "DOUBLE")
- scratchTable = os.path.join(scratchGDB, "Temp_Feat")
- arcpy.Statistics_analysis(table,scratchTable, [[str(field),"MIN"],[str(field),"MAX"]])
- with arcpy.da.SearchCursor(scratchTable, ("MAX_" + str(field) , "MIN_" + str(field))) as cursor:
- for row in cursor:
- maxNum = row[0]
- minNum = row[1]
- del cursor, row
- arcpy.Delete_management(scratchTable)
- with arcpy.da.UpdateCursor(table, ( field , "NORMALIZED" )) as cursor:
- for row in cursor:
- number = row[0]
- row[1] = (( number - minNum ) / ( maxNum - minNum ))
- cursor.updateRow(row)
- del cursor, row
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement