Need help with python script to compare two fields.

EGardner7 — Fri, 16 Aug 2024 18:25:09 GMT

I am trying to compare two fields in my attribute table. I did a spatial join with a point feature and the closest address. Not all of the addresses matched up correctly so for the point features that have address data, I want to compare just the numbers in that field to another field where I separated the number from the address that was joined. I need to locate all the numbers that do not match up. I am not very experienced with python, so I am trying to use copilot to generate something. Here is what it is giving me:

import re

def compare_fields(Add_Number, LocationDescription):
# Extract numbers from the LocationDescription field
address_numbers = re.findall(r'\d+', LocationDescription)

# Convert the extracted numbers to a single string for comparison
address_number_str = ''.join(address_numbers)

# Compare the Add_Number field with the extracted address numbers
if str(Add_Number) == address_number_str:
return "Match"
else:
return "No Match"

I am putting this script in the field calculator for a field where I want Match and No Match to be stored. It needs to compare the two fields LocationDescription (This is the script with the full address. These addresses are all in different formats. Some have the number at the end or contain underscores) and Add_Number (just the numbers for the joined address). I also tried a script that would extract the numbers only from LocationDescription because I thought it would be easier to compare if both fields were just numbers, but it also did not work. Does anyone have any idea what I am missing with this? This would help me a ton if someone could help me out otherwise, I will have to manually go through over 15,000 records.

Re: Need help with python script to compare two fields.

Ed_ — Fri, 16 Aug 2024 19:35:04 GMT

The following may help but you may have to modify it as needed.

Btw start by removing import re

In Calculate Field

First create and populate address_number_str using Calculate Field. Note that in Calculate Field you can directly create this field and set data type to Text and under = select !address_numbers! to convert the values to text/string
Then Open Calculate Field again
select the new field let's call it NF
Then towards the middle where it says NF = type reclass(!Add_Number!)
Then under code adapt the following, don't copy paste the following as it may have indentation errors and is just an idea

def reclass(Add_Number): if(str(Add_Number) == !Add_Number_str!): return "Match" else: return "No Match"

topic Need help with python script to compare two fields. in ArcGIS Pro Questions

Need help with python script to compare two fields.

Re: Need help with python script to compare two fields.