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") FindReplaceANADARKO E & P ONSHORE LLCANADARKOANADARKO E&P ONSHOREANADARKOANADARKO PETANADARKOANADARKO PET CORPANADARKOANADARKO PETROLEUM CORPORATIONANADARKOCHESAPEAKE LIMITED PARTNERSHIPCHESAPEAKECHESAPEAKE OPERATING INC.CHESAPEAKECHESAPEAKE OPERATING INCORPORATEDCHESAPEAKECHESAPEAKE OPERATING, INC.CHESAPEAKECHESAPEAKE OPERG INCCHESAPEAKE How can I build a single script for all replacements? Thanks!

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

Help with building script for multiple replacements in field

MelissaTrascher

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!

Encontre mais publicações marcadas com

Accepted answers

All comments

XanderBakker

So the data you attached really explains the situation you have. I assume you don't only what to correct 'ANADARKO' and 'CHESAPEAKE', but there is a large list of cases where multiple notations are used for the same operator.

I did a summarize on the operator field and found 748 unique values. How many operators are there? When I take the first word from the operator name and summarized again (including first and last operator and sum of cnt operator):

It returns 446 unique values (including things that don't make sense). There may be 8 different notations for DEVON, but maybe they are not all the same.

Do you have an official list of all the valid operators? In that case you could do something like determining the score with string comparison as explained here: python - Fuzzy String Comparison - Stack Overflow

The long manual way, but more secure method, would be to summarize on Operator and in the resulting table, add a field with the correct name (editing the 748 records!) and join the result back to the original table.

Question: how was this data generated? It would be good to revise the way the data was captures to avoid this work the next time by using for instance a domain with valid names for operators (although having a drop down list that has nearly 500 elements is no pleasure to work with).

DanPatterson_Retired

visual guide...

MelissaTrascher

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.

DanPatterson_Retired

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?

MelissaTrascher

Here is the data I am struggling with.

PetraExportTest.zip

MelissaTrascher

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

OPERATOR=

calc( !OPERATOR!)

DanPatterson_Retired

change this

def calc( !OPERATOR! 😞

def calc( field):

MelissaTrascher

My screenshots are being moderated

MelissaTrascher

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

calc( !OPERATOR!)

XanderBakker

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">CorrectNames</SPAN><SPAN class="punctuation token">(</SPAN>name<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; dct <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">"NADARKO E & P ONSHORE LLC"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"ANADARKO"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"ANADARKO E&P ONSHORE"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"ANADARKO"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"ANADARKO PET"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"ANADARKO"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"ANADARKO PET CORP"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"ANADARKO"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"ANADARKO PETROLEUM CORPORATION"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"ANADARKO"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"CHESAPEAKE LIMITED PARTNERSHIP"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"CHESAPEAKE"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"CHESAPEAKE OPERATING INC."</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"CHESAPEAKE"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"CHESAPEAKE OPERATING INCORPORATED"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"CHESAPEAKE"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"CHESAPEAKE OPERATING, INC."</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"CHESAPEAKE"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"CHESAPEAKE OPERG INC"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"CHESAPEAKE"</SPAN><SPAN class="punctuation token">}</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> name <SPAN class="keyword token">in</SPAN> dct<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> dct<SPAN class="punctuation token">[</SPAN>name<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> name<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I would use a dictionary...

DanPatterson_Retired

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.

MelissaTrascher

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

jskinner

Hi Melissa,

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

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">calc</SPAN><SPAN class="punctuation token">(</SPAN>field<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="string token">'ANADARKO'</SPAN> <SPAN class="keyword token">in</SPAN> field<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">'ANADARKO'</SPAN>
&nbsp; <SPAN class="keyword token">elif</SPAN> <SPAN class="string token">'CHESAPEAKE'</SPAN> <SPAN class="keyword token">in</SPAN> field<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="string token">'CHESAPEAKE'</SPAN>‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Example:

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

MitchHolley1

The following should work.

<SPAN class="comment token">#complete path to .shp or feature class</SPAN>
dataset <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'path_to_dataset'</SPAN>

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>dataset<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'OPERATOR'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="string token">'ANADARKO'</SPAN> <SPAN class="keyword token">in</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'ANADARKO'</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">elif</SPAN> <SPAN class="string token">'CHESAPEAKE'</SPAN> <SPAN class="keyword token">in</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="comment token">#use same elif loop for more companies</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'CHESAPEAKE'</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">del</SPAN> cursor<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

RebeccaStrauch__GISP

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)

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

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