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

Populate one field based on second

PamelaLinson-DeVore

This may be simple but I am only a beginner. Does anyone have a Python script to populate a field based on the code of another field in the same table? Or do have any recommendations where I might find a script?

Thank you
Pam

Vind meer berichten getagd met

Accepted answers

curtvprice

Does anyone have a Python script to populate a field based on the code of another field in the same table?

This can be done a lot faster by using the CalculateField tool than with a cursor:

Expresson: NEWFIELD =

f(!CODEFIELD!)

Code block:

def f(code):
  codelist = ['a','b','c']
  valuelist = [10,20,30]
  value = valuelist[codelist.index(code)] 
  return value

Language: "PYTHON"

But I need to say that generally the best way to do this is to have a lookup table and use a join and Calculate Field to calculate values over.

All comments

curtvprice

Does anyone have a Python script to populate a field based on the code of another field in the same table?

This can be done a lot faster by using the CalculateField tool than with a cursor:

Expresson: NEWFIELD =

f(!CODEFIELD!)

Code block:

def f(code):
  codelist = ['a','b','c']
  valuelist = [10,20,30]
  value = valuelist[codelist.index(code)] 
  return value

Language: "PYTHON"

But I need to say that generally the best way to do this is to have a lookup table and use a join and Calculate Field to calculate values over.

StephenBarrow

This may be simple but I am only a beginner. Does anyone have a Python script to populate a field based on the code of another field in the same table? Or do have any recommendations where I might find a script?

Thank you
Pam

Hi Pam

In python use an updateCursor to access and update the rows then work row by row making your changes as required. Here is something to get you started:

import arcpy
cur = arcpy.UpdateCursor(r"c:\your file") #put in your file path here
for row in cur:
  row.fieldName1 = row.fieldName2  #here I am copying the data from one field to another, just add your own code here.
  cur.updateRow(row) #transfer the row changes from memory to the table

Hope this helps

Stephen

RandyKreuziger

Hi Pam,
Welcome. Try posting your question under the geoprocessing forum. This forum is more for asking questions about ESRI Map Data.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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