nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Need some Python code for field calculator!

Anonymous User

Original User: jofuchs

Hi all!

I am a very beginner with Python, so that will be an easy task for most of you. 🙂

I want to calculate a new field of an attribute table, something like that: ((Field X/ Field Y)*100). Since 0-Values are existent, I have to exclude these values from dividing.
What I tried so far is displayed in the screenshot, but doesnt word untill now... (Perhaps it is totally wrong...)

[ATTACH=CONFIG]29480[/ATTACH]

I hope you can help me! Many Thanks in advance!

Jo

FieldCalc.png

file_example_JPG_2500kB.jpeg

Vind meer berichten getagd met

Accepted answers

AntGiles

I have created a sample feature class with three columns a,b and c. A and B are Long and C is a double. The code in the attached screenshot works fine:

[ATTACH=CONFIG]29490[/ATTACH]

Try changing your square brakets in your expression to normal brackets ()

Regards

Anthony

Untitled.png

All comments

Anonymous User

Original User: ad_giles@hotmail.com

Jo,

Try this:

def calc(f1,f2):
  if (f1 <> 0):
    return (f1/f2)*100
  else:
    return 0

Regards

Anthony

Anonymous User

Original User: jofuchs

Hi Anthony,

thanks for your reply. There is still this error message appearing

[ATTACH=CONFIG]29484[/ATTACH]

For your information:
The field i am calculating is double formatted; f1 and f2 are long integer. But I think thsi should be ok so!?

Jo

Error.png

AntGiles

Jo

It looks like you have zeros for both columns, try

def calc(f1,f2):
  if (f1 <> 0 and f2 <> 0):
    return (f1/f2)*100
  else:
    return 0

Anonymous User

Original User: jofuchs

I corrected this, you are right. That might be another potential error, but nevertheless I always have the same error message posted before...

EDIT: Field f1 is long, field f2 is double, target field is double! Can this be a problem?

AntGiles

Untitled.png

Anonymous User

Original User: jofuchs

Try changing your square brakets in your expression to normal brackets ()
Anthony

Thank you very much! That worked fine!

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.