ArcGIS Field Editor if/else syntax with python

Question

I am just starting with Python and ArcGIs so here is my question:

I have the column "DB_Low" (Type "Long") and want to fill a new column by changing values. The new column will be a Float-Type field.

So here is what I tried so far:

if !DB_Low! == 0:

  return 0

else:

  return  !DB_Low! + 2.25

But I get the Error: 000539 SyntaxError, invalid syntax (, line 1)

Can someone tell me the mistake in my code?

FYI quite often I will check the help file right from the field calculator for small syntax/formatting and function references. — Barrett
– Barrett, Commented Jun 9, 2016 at 14:17

Joseph · Accepted Answer · 2016-06-10 09:25:59Z

2

In the code block window of the field calculator, try using:

def new(DB_Low):
    if DB_Low == 0:
        return 0
    else:
        return DB_Low + 2.25

And then in the expression window:

new(!DB_Low!)

answered Jun 9, 2016 at 14:07

Joseph

76.7k8 gold badges173 silver badges286 bronze badges

1 Answer 1