topic Re: Python to concatenate alternating numeric digits from two separate number fields in Python Questions

Python to concatenate alternating numeric digits from two separate number fields

KurtBarclay — Wed, 12 Jun 2019 18:28:35 GMT

I have calc'd the X and Y coordinate value using calc geometry into two separate (numeric / double) fields and now need to combine them into a new string field by alternating the values based upon their individual digit position.

Eample: (note: not using any values after the decimal pt)

Field X_Coor Field Y_Coor New Combined_Field

1831548.520524 490651.99297 8439105645

End result should have text value template of 'X2Y1X3Y2X4Y3X5Y4X6Y5' ... OR 8439105645 (using the example above)

Thanks

Re: Python to concatenate alternating numeric digits from two separate number fields

DanPatterson_Retired — Sat, 11 Dec 2021 09:56:15 GMT

def weave(a, b):
    """mini-weave"""
    a = str(a).split(".")[0][1:]
    b = str(b).split(".")[0][:-1]
    return "".join([*sum(zip(a, b), ())])
    

weave(1831548.520524, 490651.99297)
'8439105645'‍‍‍‍‍‍‍‍‍

'weaving' two sequences with conditions. This is a mini-version of a much larger problem.

Line 3... skip the first number in sequence 'a'

Line 4... skip the last number in sequence 'b'

Line 5... the magic

For a field calculator expression, line 8 would be

weave(!a_field!, !b_field!)

Any further deviations from your example entail greater condition checking and hence a much longer version

Re: Python to concatenate alternating numeric digits from two separate number fields

DanPatterson_Retired — Wed, 12 Jun 2019 20:37:45 GMT

PS, I should add you can 'int' or 'float' the string output if you don't need it in string format

Re: Python to concatenate alternating numeric digits from two separate number fields

KurtBarclay — Thu, 13 Jun 2019 12:32:14 GMT

Thanks Dan,

I loaded your script into the Field Calc w/Prelogic and am receiving errors.

I'm working thru it, but if you have an suggestions ... I'll take them.

I really appreciate your help

Re: Python to concatenate alternating numeric digits from two separate number fields

DanPatterson_Retired — Thu, 13 Jun 2019 13:20:09 GMT

ArcGIS Pro? hence, Python 3?

I would have to see the screen grab of the code block section in the field calculator (which it is initially designed for).

So add a new field, select calculate field, copy and paste the code from a text editor (like notepad or notepad++) into the code block.

It says there is a syntax error in line 5... I am trying to rule out things like format issues, wrong line terminators etc. So run a check on the syntax.

the starred expression in line 5... can't remember if it was just a python 3 thing,