topic reclassify a field with field calculator using python problem in Python Questions

reclassify a field with field calculator using python problem

ThomasJakubicka — Wed, 21 Sep 2011 16:24:41 GMT

Hello

I am trying to reclassify a column using the field calculator and python. i am basically using the script i found on the arcgis10 help page. when i am running the field calculator, everything goes fine and i get no error messages (see the script below).

the original column contains values between 0 and 1 and the type is double.

Now my problem is that the reclassification won't work. this means that every field in the new column is populated with "very low" instead of the matching classification. so the result is that i have a column where every field contains "very low"

i am still new to python and i hope anybody can help me with this
thanks a lot
thomas

def reclass(ICISS):
  if (ICISS >= 0 and ICISS <= 0,4):
    return "very low"
  elif (ICISS > 0,4 and ICISS <= 0,6):
    return "medium low"
  elif (ICISS > 0,6 and ICISS <= 0,8):
    return "medium high"
  else:
    return "very high"

Re: reclassify a field with field calculator using python problem

DarrenWiens2 — Wed, 21 Sep 2011 17:48:57 GMT

I'm going to guess that this has to do with using a comma as the decimal point, and interpretting 0,4 as 4. Try replacing all of the commas with a period. Does your numerical column use commas?

Re: reclassify a field with field calculator using python problem

JakeSkinner — Fri, 10 Dec 2021 20:07:45 GMT

Is your Class field formatted with a ',' or a '.' for the decimal? Try the following instead:

def reclass(ICISS):
  if (ICISS >= 0 and ICISS <= 0.4):
    return "very low"
  elif (ICISS > 0.4 and ICISS <= 0.6):
    return "medium low"
  elif (ICISS > 0.6 and ICISS <= 0.8):
    return "medium high"
  else:
    return "very high"

Re: reclassify a field with field calculator using python problem

ThomasJakubicka — Thu, 22 Sep 2011 10:45:37 GMT

great that worked.
thanks for the quick help