I have a feature table, and want to normalize the data in a field between 0-1, and I know the normalization method should be "(x-min(x))/(max(x)-min(x) ". I have tried "add field---field calculator", but I have no idea how to use the functions. Could anyone help me to achieve it in ArcGIS Pro?
Solved! Go to Solution.
A more traditional approach (still a lot less work IMHO, sorry Dan):
1. Find the min and max values, let's say they are 10 and 900. (right click field in table view, Statistics)
2. Add a field
3. Run Calculate field with this expression (VFLD is your field that ranges from 0 to 900) (Use Python parser)
min + (max-min) * (value - 10.0) / (max-min)
10 + ((900 - 10) * (!VFLD! - 10.0) / (900 - 10))
I should mention that what you are suggesting is not "normalizing" the data but instead doing a min-max "stretch" of the data. To Normalize the data you would convert the values to Z scores using the mean and standard deviation (replace mean and std with the numbers you get from the Statistics run):
(!VFLD! - mean) / std