I'm trying to write a python script to label multiple columns of an attribute table based on certain parameters. For example, if Benzene is over 79, I want it to be red. I've gotten that part fine, but for some reason I can't get the labels to stack, it only displays the first one the meets the if/then statement. Here's what I have so far: def FindLabel ( [NAME], [Acetone], [Benzene], [1_3_Butadi] ): if int( [Benzene] ) > 79: message = " " " "+"Benzene:" + [Benzene] + " " + " "+ "\n" return message + "\n" if int( [Benzene] ) > 0: message = " " " "+"Benzene:" + [Benzene] + " " + " "+ "\n" return message + "\n" if int( [Acetone] ) > 0: message = " " " "+"Acetone:" + [Acetone] + " " + " " + "\n" return message + "\n" if int( [1_3_Butadi] ) > 0: message = " " " "+"1,3-Butadiene:" + [1_3_Butadi] + " " + " "+ "\n" return message + "\n" I essentially want it to display like this Benzene: 79 Acetone: 12 1,3-Butadiene:13 I tried using: return "{0}\n{1}".format([Acetone], [Benzene], [1_3_Butadi]) That allowed me to stack the labels but then I lost the formatting I wanted.

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; } } }

Python Labeling Help?

MattBrauckmann

I'm trying to write a python script to label multiple columns of an attribute table based on certain parameters. For example, if Benzene is over 79, I want it to be red. I've gotten that part fine, but for some reason I can't get the labels to stack, it only displays the first one the meets the if/then statement. Here's what I have so far:

def FindLabel ( [NAME], [Acetone], [Benzene], [1_3_Butadi]  ):
  if int( [Benzene] ) > 79:
    message = "<bol>" "<clr red = '255'>"+"Benzene:" + [Benzene] + "</clr>" + "</bol>"+ "\n"
    return message + "\n"
  if int( [Benzene] ) > 0:
    message = "<bol>" "<clr green = '255'>"+"Benzene:" + [Benzene] + "</clr>" + "</bol>"+ "\n"
    return message + "\n"
  if int( [Acetone] ) > 0:
    message = "<bol>" "<clr green = '255'>"+"Acetone:" + [Acetone] + "</clr>" + "</bol>" + "\n"
    return message + "\n"
  if int( [1_3_Butadi]  ) > 0:
    message = "<bol>" "<clr green = '255'>"+"1,3-Butadiene:" + [1_3_Butadi]  + "</clr>" + "</bol>"+ "\n"
    return message + "\n"

I essentially want it to display like this

Benzene: 79

Acetone: 12

1,3-Butadiene:13

I tried using:

  return "{0}\n{1}".format([Acetone], [Benzene], [1_3_Butadi])

That allowed me to stack the labels but then I lost the formatting I wanted.

Encuentra más publicaciones etiquetadas con

Accepted answers

WesMiller

You will need to build your message. I didn't test the code below but your code should be similar.

def FindLabel ( [NAME], [Acetone], [Benzene], [1_3_Butadi]  ):
  message = ''
  if int( [Benzene] ) > 79:  
    message = message + "<bol>" "<clr red = '255'>"+"Benzene:" + [Benzene] + "</clr>" + "</bol>"+ "\n"  
    message = message + "\n"  
  if int( [Benzene] ) > 0:  
    message = message + "<bol>" "<clr green = '255'>"+"Benzene:" + [Benzene] + "</clr>" + "</bol>"+ "\n"  
    message = message + "\n"  
  if int( [Acetone] ) > 0:  
    message = message + "<bol>" "<clr green = '255'>"+"Acetone:" + [Acetone] + "</clr>" + "</bol>" + "\n"  
    message = message + "\n"  
  if int( [1_3_Butadi]  ) > 0:  
    message = message + "<bol>" "<clr green = '255'>"+"1,3-Butadiene:" + [1_3_Butadi]  + "</clr>" + "</bol>"+ "\n"  
    message = message + "\n"
  return message

All comments

curtvprice

My friends, here are some ideas on how to take advantage of Python's very handy string abilities...

def report(clr, lbl, val):
  return "<bol><clr {} = '255'>{}: {}</clr></bol>\n".format(
    clr, lbl, val)
def FindLabel([NAME], [Acetone], [Benzene], [1_3_Butadi]):
  message = ""
  if int([Benzene]) > 79:
    message += report("red", "Benzene", [Benzene])
  elif int([Benzene]) > 0:
    message += report("green", "Benzene", [Benzene]) 
  if [Acetone] > 0:     
    message += report("green", "Acetone", [Acetone])
  if int([1_3_Butadi]) > 0:     
    message += report("green", "1,3-Butadiene", [1_3_Butadi])
  return message

(If you start a table, dataset, or field name with a number, you may regret it. You have been warned.)

MitchHolley1

Darren,

Yeah, that's it! Here is a sample of the script:

Notice, the expression is in VBscript.

I haven't tried running this yet... but I'm 99% sure it's not going to work.

All I'm trying to do is label one feature class with stack text as noted above.

Please excuse my sloppy code, and please let me know if I need to post this as a separate post.

DarrenWiens2

Do you mean, how to build a label expression, or something different?

MitchHolley1

I have the same question.

Could you give me an example of how this is executed in the Python script?

It looks as if your function is returning the message, but how exactly is that put into the feature class or shapefile you are trying to label?

Thanks for the help!

DarrenWiens2

I see you've got your answer, however I think you can benefit from an 'elif' between the Benzene comparisons. Without 'elif', a value of 80 will get a red label (>79) followed by a green label (>0). With 'elif', a value of 80 will get a red label, then skip the >0 comparison:

def FindLabel ( [NAME], [Acetone], [Benzene], [1_3_Butadi]  ):  
  message = ''  
  if int( [Benzene] ) > 79:    
    message = message + "<bol>" "<clr red = '255'>"+"Benzene:" + [Benzene] + "</clr>" + "</bol>"+ "\n"    
    message = message + "\n"   
  elif int( [Benzene] ) > 0:   
    message = message + "<bol>" "<clr green = '255'>"+"Benzene:" + [Benzene] + "</clr>" + "</bol>"+ "\n"   
    message = message + "\n"  
  if int( [Acetone] ) > 0:    
    message = message + "<bol>" "<clr green = '255'>"+"Acetone:" + [Acetone] + "</clr>" + "</bol>" + "\n"    
    message = message + "\n"    
  if int( [1_3_Butadi]  ) > 0:    
    message = message + "<bol>" "<clr green = '255'>"+"1,3-Butadiene:" + [1_3_Butadi]  + "</clr>" + "</bol>"+ "\n"    
    message = message + "\n"  
  return message

WesMiller

You will need to build your message. I didn't test the code below but your code should be similar.

def FindLabel ( [NAME], [Acetone], [Benzene], [1_3_Butadi]  ):
  message = ''
  if int( [Benzene] ) > 79:  
    message = message + "<bol>" "<clr red = '255'>"+"Benzene:" + [Benzene] + "</clr>" + "</bol>"+ "\n"  
    message = message + "\n"  
  if int( [Benzene] ) > 0:  
    message = message + "<bol>" "<clr green = '255'>"+"Benzene:" + [Benzene] + "</clr>" + "</bol>"+ "\n"  
    message = message + "\n"  
  if int( [Acetone] ) > 0:  
    message = message + "<bol>" "<clr green = '255'>"+"Acetone:" + [Acetone] + "</clr>" + "</bol>" + "\n"  
    message = message + "\n"  
  if int( [1_3_Butadi]  ) > 0:  
    message = message + "<bol>" "<clr green = '255'>"+"1,3-Butadiene:" + [1_3_Butadi]  + "</clr>" + "</bol>"+ "\n"  
    message = message + "\n"
  return message

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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