Stack Overflow
Stack Overflow

Questions tagged [fuzzywuzzy]

FuzzyWuzzy is a Python package to perform fuzzy string matching.

FuzzyWuzzy is a Python package to perform fuzzy string matching.

Useful links

522 questions
1
vote
3 answers

clustering of company names in python when standard list is not there

I have a list of company names in a pandas data frame, I want group these names that are similar,review and create a standard name for each group. most of the solutions i see are to map a value to standard value but i want to just group the list…
Vaibav
  • 77
  • 1
  • 7
1
vote
2 answers

How to fuzzy match two lists in Python

I have two lists: ref_list and inp_list. How can one make use of FuzzyWuzzy to match the input list from the reference list? inp_list = pd.DataFrame(['ADAMS SEBASTIAN', 'HAIMBILI SEUN', 'MUTESI JOHN', 'SHEETEKELA MATT',…
John Mutesi
  • 77
  • 2
  • 9
1
vote
1 answer

How to use fuzz.ratio on a data frame on pyspark

I want to use fuzz.ratio on a data frame, but I'm working on pyspark (I can't use pandas). I have the function: from fuzzywuzzy import fuzz I create a data frame like this: communes_corrompues=spark.createDataFrame( [("VILLEAINTE",…
Neoooar
  • 33
  • 7
1
vote
1 answer

Create columns having similarity index values

How can I create columns that show the respectively similarity indices for each row? This code def func(name): matches = try_test.apply(lambda row: (fuzz.partial_ratio(row['name'], name) >= 85), axis=1) return [try_test.word[i] for i, x in…
user12907213
1
vote
2 answers

How to deal with Nonetype while fuzzy matching in a dataframe?

So I am fuzzy matching two dataframes and want to find a match from the right table if it has a score of over 80. So for the ones that do not find a match over 80 it ends up with Nonetype which causes the script to fail. How can I handle this? I…
Cole
  • 99
  • 10
1
vote
1 answer

How to write all rows using fuzzy wuzzy python?

I have a list = ['NAAR HUIS', 'TIANJIN', 'GORINCHEM', 'TIMIKA0', 'DAMMAM', 'DULAC', 'SUNDERLAND'] and want to compare the each element of the list with the column 3 of the given csv file using fuzzy wuzzy. if the string is match greater than 80%…
Banaja Rout
  • 11
  • 2
1
vote
1 answer

fuzzy Logic for a String in R

I have 2 dataframe: DF1 ID Address AB1 VILL +PO CHAPAR TAPUKADA ALWAR AB2 VILL WARD NO 02 THIKARIYA CHAND RAWAT JUNA PADA POST BADANA 0 SIROHI AB3 RAMKUMAR YADAV VILL KANSL 0 JAIPUR AB4 VILL KHERKI MUKKER POSTPANIYA PUTLI …
SiddhiKharkia
  • 11
  • 2
1
vote
1 answer

Find fuzzy match string in a list with matching string value and their count

I have one list A as below. A = ['vikash','vikas','Vinod',Vikky','Akash','Vinodh','Sachin','Salman,'Ajay','Suchin','Akash','vikahs'] I want to match each element in the list with each element and find the fuzzy matching strings of each element with…
Vikash Chauradia
  • 39
  • 1
  • 8
1
vote
2 answers

Python3.6 package for fuzzy matching that is neither regex, fuzzywuzzy nor tre?

I'm searching for something that lets me fuzzy match in Python 3.6 without using the following libraries/packages that have been discarted (not my project, so I cannot make a decision over it unless I find a solution to the problems these libraries…
thisismylasthope
  • 11
  • 1
1
vote
1 answer

Call python method dynamically

I want to loop through all fuzzy matching methods to determine which is the best for my data, from the package fuzzywuzzy. Code: from fuzzywuzzy import fuzz # Discover ratio. # This set should give a higher match than the set below. high_match =…
Christina Zhou
  • 1,483
  • 1
  • 7
  • 17
1
vote
0 answers

Remake dataframe based of fuzzywuzzy matches

i have a dataframes now it have 5 rows(in future will have more). In column names there 5 values, if those 5 names the same(their fuzz.ratio close to each other) then ok no changes needed. But there is cases where: 4 values good(their fuzz.ratio…
Andrii
  • 83
  • 4
1
vote
1 answer

How to join two dataset using fuzzywuzzy

We have two dataframe dataframe 1 :: dataframe 2 : need to validate same data in second dataset in combined column and add id column from first dataset means output like :: !pip install fuzzywuzzy from fuzzywuzzy import fuzz data =…
Amol
  • 336
  • 3
  • 5
  • 17
1
vote
2 answers

Pandas: How to use a Numpy function instead of a Lambda function for the same result (since Numpy is faster)?

The command below is giving me the following error: ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all(). Why and how can I fix it? df['Score'] = np.array(fuzz.ratio(df['Vendor'],…
Chadee Fouad
  • 2,630
  • 2
  • 23
  • 29
1
vote
3 answers

Optimize element wise fuzzy match between two lists

I have two lists of companies (> 2k entries in the longer list) in different formats that I need to unify. I know that both formats share a stub about 80% of the time, so I'm using fuzzy match to compare both lists: def get_fuzz_score(str1, str2): …
lajulajay
  • 355
  • 3
  • 4
  • 18
1
vote
0 answers

Why the fuzzywuzzy Ratio() uses a slightly different implementation of Levenshtein Distance while calculating the ratio between two strings?

I am trying to wrap my head around how the fuzzywuzzy library calculates the Levenshtein Distance between two strings, as the docs clearly mention that it is using that. The Levenshtein Distance algorithm counts looks for the minimum number of edits…
Samarth
  • 242
  • 2
  • 12
1 2 3
…
34 35