topic Re: In this example, how do I write a Python script to accomplish this? in Python Questions

In this example, how do I write a Python script to accomplish this?

CharlesBanks2 — Wed, 27 Jun 2018 12:40:02 GMT

In this example, how do I write a Python script to accomplish this result:

Site ID

SIte A 0001

Site A 0001

SIte A 0001

Site A 0001

Site B 0002

SIte B 0002

Site B 0002

Site C 0003

SIte D 0004

Re: In this example, how do I write a Python script to accomplish this?

DanPatterson_Retired — Wed, 27 Jun 2018 12:44:21 GMT

I am suspecting that there is more to it than that.

What is the purpose of the code?
Do any of the values exist before hand?
are you reading the file from somewhere?
What have you tried!

Re: In this example, how do I write a Python script to accomplish this?

CharlesBanks2 — Wed, 27 Jun 2018 12:50:21 GMT

This is in connection with post: "Sequential Numbering Python Script for

Field Calculator in Arc 10.2" but a different sequence in the data.

Thanks,

Charles Banks

Re: In this example, how do I write a Python script to accomplish this?

DanPatterson_Retired — Wed, 27 Jun 2018 12:55:54 GMT

Well it can be done easily in more recent versions ( Table tools for ArcGIS PRO )

but perhaps if you included the link someone with an older version of ArcMap (or even 10.6) could have a look at what was posted there

Re: In this example, how do I write a Python script to accomplish this?

CharlesBanks2 — Wed, 27 Jun 2018 13:01:09 GMT

The link is "

https://community.esri.com/thread/192672-sequential-numbering-python-script-for-field-calculator-in-arc-102".

I don't have Pro and I would have to do this from Field Calc.

Thanks

Charles

Re: In this example, how do I write a Python script to accomplish this?

DanPatterson_Retired — Wed, 27 Jun 2018 14:35:15 GMT

The code I posted is in that link... you just need to change the field name that contains the source classification

seq_count(!Test!)

in that thread's example the Site stuff was in a field called Test.

You just need to do a field calculation with seq_count as the Code block and the seq_count(!YourFieldName!) as the expression.

Of course, you have to set the field calculator to the python parser

Re: In this example, how do I write a Python script to accomplish this?

CharlesBanks2 — Wed, 27 Jun 2018 14:49:17 GMT

This script does not produce the sequence above, it does work though!

Re: In this example, how do I write a Python script to accomplish this?

DanPatterson_Retired — Wed, 27 Jun 2018 14:55:32 GMT

It doesn't produce the exact sequence because... your data are different I suspect.

Perhaps you should show the data you are trying to produce a sequence for... or are you not following what the script does exactly?

Re: In this example, how do I write a Python script to accomplish this?

CharlesBanks2 — Wed, 27 Jun 2018 16:02:07 GMT

This is a sample of what needs to be:

FIELD	NEED TO BE
xxx_ 9999TUNK10_	xxx_ 9999TUNK10_001
xxx_ 9999TUNK10_	xxx_ 9999TUNK10_001
xxx_ 9999TUNK10_	xxx_ 9999TUNK10_001
xxx_ 9999BANK12_	xxx_ 9999BANK12_002
xxx_ 9999BANK17_	xxx_ 9999BANK17_003
xxx_ 9999BANK1_	xxx_ 9999BANK1_004
xxx_ 9999BANK20_	xxx_ 9999BANK20_005
xxx_ 9999BANK20_	xxx_ 9999BANK20_005
xxx_ 9999BANK20_	xxx_ 9999BANK20_005
xxx_ 9999BANK30_	xxx_ 9999BANK30_006

Re: In this example, how do I write a Python script to accomplish this?

DanPatterson_Retired — Wed, 27 Jun 2018 18:05:10 GMT

did you substitute the !Test! name in the field calculator expression and try what I suggested?

perhaps you can take a screen grab of the field calculator dialog so we can see what you are doing

Re: In this example, how do I write a Python script to accomplish this?

CharlesBanks2 — Wed, 27 Jun 2018 18:19:23 GMT

Yes, I did, and got something like this:

FIELD	NEED TO BE
xxx_ 9999TUNK10_	xxx_ 9999TUNK10_001
xxx_ 9999TUNK10_	xxx_ 9999TUNK10_002
xxx_ 9999TUNK10_	xxx_ 9999TUNK10_003
xxx_ 9999BANK12_	xxx_ 9999BANK12_002

Re: In this example, how do I write a Python script to accomplish this?

DanPatterson_Retired — Sat, 11 Dec 2021 08:11:43 GMT

# lines 7... change to
        cnt += 0   # ---- try changing this
        ret = "{} {:04.0f}".format(val, cnt)
    else:
        cnt += 1   # ---- and this
        ret = "{} {:04.0f}".format(val, cnt)‍‍‍‍‍‍‍‍‍‍‍‍

Re: In this example, how do I write a Python script to accomplish this?

CharlesBanks2 — Wed, 27 Jun 2018 18:51:19 GMT

I got an error: 999999 : Error executing function.

999999 : Error executing function.

Re: In this example, how do I write a Python script to accomplish this?

DanPatterson_Retired — Thu, 28 Jun 2018 03:35:37 GMT

show your field calculator dialog with the function and your expression filled in

Any of you other peeps want to leap in... lots of viewers... no suggestions from the gallery??? You can take over if you want

Re: In this example, how do I write a Python script to accomplish this?

CharlesBanks2 — Thu, 28 Jun 2018 14:55:36 GMT

Sorry about the delay. Here it is:

Re: In this example, how do I write a Python script to accomplish this?

RandyBurton — Sat, 11 Dec 2021 08:11:46 GMT

Peeping in.....

A dictionary solution could look like something like this:

data = ['xxx_9999TUNK10_',
        'xxx_9999TUNK10_',
        'xxx_9999TUNK10_',
        'xxx_9999BANK12_',
        'xxx_9999BANK17_',
        'xxx_9999BANK1_',
        'xxx_9999BANK20_',
        'xxx_9999BANK20_',
        'xxx_9999BANK20_',
        'xxx_9999BANK30_' ]

d = {}
cnt = 0

for row in data:
    if row not in d.keys():
        cnt += 1
        d[row] = cnt
        print "{}{:04.0f}".format(row, cnt)
    else:
        print "{}{:04.0f}".format(row, d[row])

'''
Results:
xxx_9999TUNK10_0001
xxx_9999TUNK10_0001
xxx_9999TUNK10_0001
xxx_9999BANK12_0002
xxx_9999BANK17_0003
xxx_9999BANK1_0004
xxx_9999BANK20_0005
xxx_9999BANK20_0005
xxx_9999BANK20_0005
xxx_9999BANK30_0006
'''‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Is the prefixed 'xxx_' always the same, or does it vary? If it varies, you will need to do some string splitting, etc.

Is the postfixed '_' always present? If not, the formatting statement can be modified to include it.

By making the dictionary 'd' and the counter 'cnt' global, you should be able to make it work for the field calculator. The code should also work with an update cursor, should you wish to go that route.

Re: In this example, how do I write a Python script to accomplish this?

CharlesBanks2 — Thu, 28 Jun 2018 17:39:37 GMT

Prefix is always the same and suffix is always present and varies. Could I

substitute the data portion with the field name?

Charles Banks

Re: In this example, how do I write a Python script to accomplish this?

RandyBurton — Sat, 11 Dec 2021 08:11:48 GMT

Not sure I understand your question. Would something like this do what you want?

data = ['xxx_9999TUNK10_',
        'xxx_9999TUNK10_',
        'xxx_9999TUNK10_',
        'xxx_9999BANK12_',
        'xxx_9999BANK17_',
        'xxx_9999BANK1_',
        'xxx_9999BANK20_',
        'xxx_9999BANK20_',
        'xxx_9999BANK20_',
        'xxx_9999BANK30_' ]


d = {} # empty dictionary
cnt = 0 # counter
def seq_count(fname, val):
    global d
    global cnt

    if val not in d.keys():
        cnt += 1
        d[val] = cnt
        return "{}_{}{:04.0f}".format(fname, val, cnt)
    else:
        return "{}_{}{:04.0f}".format(fname, val, d[val])


fieldName = 'myField'
for item in data:
    print seq_count(fieldName, item)

'''
Results:
myField_xxx_9999TUNK10_0001
myField_xxx_9999TUNK10_0001
myField_xxx_9999TUNK10_0001
myField_xxx_9999BANK12_0002
myField_xxx_9999BANK17_0003
myField_xxx_9999BANK1_0004
myField_xxx_9999BANK20_0005
myField_xxx_9999BANK20_0005
myField_xxx_9999BANK20_0005
myField_xxx_9999BANK30_0006
'''‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: In this example, how do I write a Python script to accomplish this?

CharlesBanks2 — Thu, 28 Jun 2018 18:18:01 GMT

Yes.

Charles Banks