Breaking News: Grepper is joining You.com. Read the official announcement!

python build dictionary for use in table join

Dano's Grepper answered on December 26, 2019 Popularity 3/10 Helpfulness 1/10

answer python build dictionary for use in table join

python build dictionary for use in table join

Comment

from time import strftime  
  
print "Start script: " + strftime("%Y-%m-%d %H:%M:%S")  
  
import arcpy  
  
sourceFC = r"C:\Path\SourceFeatureClass"  
  
sourceFieldsList = ["JoinField", "ValueField"]  
  
# Use list comprehension to build a dictionary from a da SearchCursor  
valueDict = {r[0]:(r[1:]) for r in arcpy.da.SearchCursor(sourceFC, sourceFieldsList)}  
  
updateFC = r"C:\Path\UpdateFeatureClass"  
  
updateFieldsList = ["JoinField", "ValueField"]  
  
with arcpy.da.UpdateCursor(updateFC, updateFieldsList) as updateRows:  
    for updateRow in updateRows:  
        # store the Join value of the row being updated in a keyValue variable  
        keyValue = updateRow[0]  
         # verify that the keyValue is in the Dictionary  
        if keyValue in valueDict:  
             # transfer the value stored under the keyValue from the dictionary to the updated field.  
            updateRow[1] = valueDict[keyValue][0]  
            updateRows.updateRow(updateRow)  
  
del valueDict  
  
print "Finished script: " + strftime("%Y-%m-%d %H:%M:%S")

Popularity 3/10 Helpfulness 1/10 Language python

Source: Grepper

Tags: build dictionary join python

Link to this answer
Share Copy Link

Contributed on Dec 26 2019

Dano's Grepper

0 Answers Avg Quality 2/10

python build dictionary for use in table join

Contents

More Related Answers

python build dictionary for use in table join

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.