topic Field calculator Python function using Fuzzy string in Python Questions

Field calculator Python function using Fuzzy string

AhmedAbdelnasser1 — Thu, 23 Mar 2017 16:10:23 GMT

I want to -simply- compare the values from three columns using Fuzzywuzzy python library and return the percentage value.

I want to do something like this, but of course, this function is not working!

How I can make this one work.

from fuzzywuzzy import fuzz
from fuzzywuzzy import process
def function(query,v1,v2,v3)
choices = [v1,v2,v3 ]
result= process.extractOne(query, choices)
return result

I can make Fuzzy work for comparing only two columns like this.

Pre-logic script code:
from fuzzywuzzy import fuzz
from fuzzywuzzy import process
--------------------------------------------
fuzz.ratio(!column1!, !column2!)

this link can give you an idea about Fuzzy string: Fuzzy String Matching in Python – Marco Bonzanini

I will really appreciate your help.

Thanks,

Re: Field calculator Python function using Fuzzy string

JoshuaBixby — Thu, 23 Mar 2017 16:48:28 GMT

I don't have time to look at fuzzy string part, but there are some other issues I see. First, you don't have a colon after your function definition: def functioname: . Second, your not doing any indentation with your function definition. Third, you are passing 4 columns to the function, but the function only has 3 parameters.

Re: Field calculator Python function using Fuzzy string

JoshuaBixby — Thu, 23 Mar 2017 17:00:34 GMT

In your code, you are using extractOne, which returns a tuple with the highest-ranking string and its score. What do you want to store in the FUZZY_STRING field? A string, a number, both?

Re: Field calculator Python function using Fuzzy string

DanPatterson_Retired — Thu, 23 Mar 2017 17:27:59 GMT

I notice that some of your columns vary in case... ie !Column1! then !column2! did you type those in or select them from the list of available columns

Re: Field calculator Python function using Fuzzy string

curtvprice — Fri, 24 Mar 2017 04:09:53 GMT

Dan -- field names are absolutely case-insensitive in Calculate Field expressions.

Re: Field calculator Python function using Fuzzy string

DanPatterson_Retired — Fri, 24 Mar 2017 05:08:42 GMT

ahhh.. too much python... and that must be jUsT a sTUpid vb legacy thing

Re: Field calculator Python function using Fuzzy string

AhmedAbdelnasser1 — Sat, 25 Mar 2017 19:53:45 GMT

Thanks, Joshua

I update the code to this and it worked for me

from fuzzywuzzy import fuzz
from fuzzywuzzy import process
def SetMatchPercenage(query,v1,v2,v3,v4):
choices = [v1,v2,v3,v4]
result=str(process.extractOne(query, choices))
return result