topic Re: Simple table in Label Expression in ArcGIS Pro Questions

Simple table in Label Expression

EmmaO — Tue, 21 Mar 2023 20:08:17 GMT

I want to create simple tables in my labels. I thought that using python and pandas dataframe might work, but although the expression verifies as valid, no labels appear on my map. Is there a different way to accomplish this either in Python or a different language? I am using ArcPro 3.1. Thanks

Re: Simple table in Label Expression

JohannesLindner — Wed, 22 Mar 2023 18:48:08 GMT

Labels only show strings, s you have to return a string.

I can' test right now, maybe it works with the DataFrame method:

def FindLabel(): table = getTable() return table.to_string()

If it doesn't, you can try constructing it yourself (untested):

def FindLabel(): d = {"DATE": ["Fall 2018", "Spring 2019"], "RESULTS": [7.1, 8.4]} # get the column names and the max row count columns = k in d.keys() num_rows = max([len(d[c]) for c in columns]) # header in bold rows = [ "\t".join([f"<BOL>{c}</BOL>" for c in columns]), ] # append the values for r in range(num_rows): row = [] for c in columns: # get the value of current r and c, or default empty string try: row.append(str(d[c][r])) except IndexError: row.append(" ") rows.append("\t".join(row)) # concatenate the rows with line breaks return "\n".join(rows)

Re: Simple table in Label Expression

EmmaO — Mon, 27 Mar 2023 18:22:18 GMT

table.to_string() works! Thank you

Re: Simple table in Label Expression

JeffreyFitzgibbons — Fri, 31 Mar 2023 15:19:44 GMT

Can you post a screenshot for how the final product looks? I tried in arcgis pro 2.9.0 but its just text separated by spaces. Thanks.

Re: Simple table in Label Expression

EmmaO — Tue, 04 Apr 2023 00:48:42 GMT

Here is what it looks like in 3.1. I actually spoke a little too soon. I thought that using the methods here I would be able to format it how I wanted, but having played around, I haven't been able to do so. It also would be nice if there were lines to format the table, but I'm not sure if that's possible.