topic Re: Help with building script for multiple replacements in field in Data Management Questions

Help with building script for multiple replacements in field

MelissaTrascher — Thu, 07 Dec 2017 18:45:27 GMT

I have a field that has multiple names for the same company, for several companies. I would like to build a script to replace the name for each company...

example: replace( [OPERATOR],"ANADARKO E & P ONSHORE LLC","ANADARKO")

Find	Replace
ANADARKO E & P ONSHORE LLC	ANADARKO
ANADARKO E&P ONSHORE	ANADARKO
ANADARKO PET	ANADARKO
ANADARKO PET CORP	ANADARKO
ANADARKO PETROLEUM CORPORATION	ANADARKO
CHESAPEAKE LIMITED PARTNERSHIP	CHESAPEAKE
CHESAPEAKE OPERATING INC.	CHESAPEAKE
CHESAPEAKE OPERATING INCORPORATED	CHESAPEAKE
CHESAPEAKE OPERATING, INC.	CHESAPEAKE
CHESAPEAKE OPERG INC	CHESAPEAKE

How can I build a single script for all replacements?

Thanks!

Re: Help with building script for multiple replacements in field

RebeccaStrauch__GISP — Thu, 07 Dec 2017 19:07:06 GMT

tagging https://community.esri.com/community/developers/gis-developers/python?sr=search&searchId=7b113f9c-5599-4474-b879-ab8c86c4c6fb&searchIndex=3‌ since I assume you are wanting this in a python script (if not, make sure to specify what you want the script to be written in, or ifyou are just trying in the field calculator box)

Re: Help with building script for multiple replacements in field

MitchHolley1 — Fri, 10 Dec 2021 20:03:35 GMT

The following should work.

#complete path to .shp or feature class
dataset = r'path_to_dataset'

with arcpy.da.UpdateCursor(dataset, ['OPERATOR']) as cursor:
    for row in cursor:
        if 'ANADARKO' in row[0]:
            row[0] = 'ANADARKO'
        elif 'CHESAPEAKE' in row[0]: #use same elif loop for more companies
            row[0] = 'CHESAPEAKE'
        cursor.updateRow(row)
del cursor‍‍‍‍‍‍‍‍‍‍‍

Re: Help with building script for multiple replacements in field

JakeSkinner — Fri, 10 Dec 2021 20:03:38 GMT

Hi Melissa,

You can do this using the Field Calculator. Here is the code:

def calc(field):
  if 'ANADARKO' in field:
    return 'ANADARKO'
  elif 'CHESAPEAKE' in field:
    return 'CHESAPEAKE'‍‍‍‍‍‍‍‍‍‍

Example:

!Company! is the field name you are updating. In this case, the field is called Company.

Re: Help with building script for multiple replacements in field

MelissaTrascher — Thu, 07 Dec 2017 20:22:28 GMT

Thank you for your help. I am still having issues.

Re: Help with building script for multiple replacements in field

DanPatterson_Retired — Thu, 07 Dec 2017 20:26:34 GMT

You might have indentation issues or anything...

what is the exact error message?

perhaps you can copy and paste the field calculator expression you are using or at least provide a screen grab.

Maybe jskinner-esristaff‌ could do the same with his expression and attach it as a *.cal file to obviate any indentation/copy issues.

Re: Help with building script for multiple replacements in field

XanderBakker — Fri, 10 Dec 2021 20:03:41 GMT

def CorrectNames(name):
    dct = {"NADARKO E & P ONSHORE LLC":"ANADARKO",
        "ANADARKO E&P ONSHORE":"ANADARKO",
        "ANADARKO PET":"ANADARKO",
        "ANADARKO PET CORP":"ANADARKO",
        "ANADARKO PETROLEUM CORPORATION":"ANADARKO",
        "CHESAPEAKE LIMITED PARTNERSHIP":"CHESAPEAKE",
        "CHESAPEAKE OPERATING INC.":"CHESAPEAKE",
        "CHESAPEAKE OPERATING INCORPORATED":"CHESAPEAKE",
        "CHESAPEAKE OPERATING, INC.":"CHESAPEAKE",
        "CHESAPEAKE OPERG INC":"CHESAPEAKE"}

    if name in dct:
        return dct[name]
    else:
        return name‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I would use a dictionary...

Re: Help with building script for multiple replacements in field

MelissaTrascher — Thu, 07 Dec 2017 20:34:45 GMT

def calc( !OPERATOR! 😞
if 'ANADARKO' in field:
return 'ANADARKO'
elif 'CHESAPEAKE' in field:
return 'CHESAPEAKE'

calc( !OPERATOR!)

Re: Help with building script for multiple replacements in field

MelissaTrascher — Thu, 07 Dec 2017 20:35:13 GMT

My screenshots are being moderated

Re: Help with building script for multiple replacements in field

DanPatterson_Retired — Thu, 07 Dec 2017 20:40:51 GMT

change this

def calc( !OPERATOR! 😞

def calc( field):

Re: Help with building script for multiple replacements in field

MelissaTrascher — Thu, 07 Dec 2017 21:59:17 GMT

def calc(field):
if 'ANADARKO' in field:
return 'ANADARKO'
elif 'CHESAPEAKE' in field:
return 'CHESAPEAKE'

OPERATOR=

calc( !OPERATOR!)

Re: Help with building script for multiple replacements in field

MelissaTrascher — Thu, 07 Dec 2017 21:59:50 GMT

Still failed. I am having no luck.

Re: Help with building script for multiple replacements in field

DanPatterson_Retired — Thu, 07 Dec 2017 22:07:22 GMT

it appears you are trying to calculate values for an 'OPERATOR' field... if so, you can't use values that are already in that field. You need to make a new field of the same data type... say ... 'NEW_OP'... then you make that field active and use the calculator expression

cal(!NEW_OP!)

of course this assumes that your indentation is totally correct etc etc

Re: Help with building script for multiple replacements in field

JakeSkinner — Fri, 08 Dec 2017 12:37:14 GMT

Melissa,

Can you upload a zipped sample of your data?

Re: Help with building script for multiple replacements in field

MelissaTrascher — Fri, 08 Dec 2017 15:04:09 GMT

I'm sorry, I'm new here - where do I go to upload data?

Re: Help with building script for multiple replacements in field

JakeSkinner — Fri, 08 Dec 2017 16:19:34 GMT

When replying click on Use Advanced Editor at the top right:

Then you will see the Attach option in the lower left hand corner:

Re: Help with building script for multiple replacements in field

MelissaTrascher — Fri, 08 Dec 2017 17:22:59 GMT

Here is the data I am struggling with.

Re: Help with building script for multiple replacements in field

MelissaTrascher — Fri, 08 Dec 2017 17:33:05 GMT

Thanks, I had to reply to original message to see the advanced option.

Re: Help with building script for multiple replacements in field

DanPatterson_Retired — Fri, 08 Dec 2017 17:41:51 GMT

Did you try the suggestion https://community.esri.com/thread/206396-help-with-building-script-for-multiple-replacements-in-field#comment-734793 because your haven't clarified the name of the field you have the data in and whether or not you are trying to add this to a field of the correct type. You calculator expression was incorrect as it was posted.

BTW, it appears to have been answered... so what was the solution?

Re: Help with building script for multiple replacements in field

MelissaTrascher — Fri, 08 Dec 2017 18:17:11 GMT

I did try it. I added a text field named it NewOp, selected it, then ran field calc. It didn't work. Its time I took a scripting class... the basics are not working in my new job.

I didn't report that this was answered... unless it was by accident when trying to find the advanced editor. Ugh.