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

タグ付きの投稿をもっと見る

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!

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

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