Algorithm used in Excel Fuzzy Lookup

0 votes
I was working on matching company names of two sets. I was trying to code it in Python with Levenstien's distance. I was having issues with short names of companies, and their trailing part like Pvt,Ltd. I have ran the same set with Excel Fuzzy lookup and was getting good results. I there a way that i can see how excel fuzzy lookup is coded and use the same implementation in python.
Apr 5, 2022 in Database by Edureka
• 13,690 points
1,404 views

1 answer to this question.

0 votes

There are two data sets that must be matched. The personnel list is in columns A and B. The names of the employees who completed a mandatory form are listed in columns D and E. You'll need to figure out who hasn't returned the paperwork yet. Because column A utilises a "last name, first name" format, and column D contains a nickname and last name, a VLOOKUP or XLOOKUP won't function. The fuzzy matching option can be used to match these two data sets.

image

The fuzzy match will use the translation table in columns G and H to help match full first names with nicknames. Two columns, called "From" and "To," are required in the translation table. Because they share several letters, the fuzzy match will most likely match Kris and Kristy, but it will require an entry in the translation table for Bill and William or Nathan and Nate.

Before you can execute the match, you must first convert each of the three data ranges to a table by selecting each range and pressing Ctrl+T. Then rename each table as follows: In a table, select one cell. Type a meaningful name in the Table Tools tab of the Ribbon, such as "Census," "Forms," or "Nicknames."

answered Apr 6, 2022 by gaurav
• 23,260 points

Related Questions In Database

0 votes
1 answer

TRIGGERS used in MySQL tables

The following TRIGGERS are allowed in MySQL:  BEFORE ...READ MORE

answered Aug 21, 2018 in Database by CodingByHeart77
• 3,750 points
575 views
0 votes
1 answer

Which operator is used in the query for pattern matching?

LIKE operator is used for pattern matching, ...READ MORE

answered Oct 15, 2018 in Database by DataKing99
• 8,250 points
23,625 views
0 votes
1 answer

Constraints Used In Database

Refer to the image below: READ MORE

answered Nov 15, 2018 in Database by DataKing99
• 8,250 points
1,010 views
0 votes
1 answer

What are the different types of keys used in the database?

There are mainly 5 types of Keys, ...READ MORE

answered Nov 19, 2018 in Database by Sahiti
• 6,370 points
5,879 views
0 votes
1 answer

What are set operations used in database?

There are mainly three set operations: UNION, ...READ MORE

answered Nov 19, 2018 in Database by Sahiti
• 6,370 points
3,179 views
0 votes
1 answer

Change default 'delimiters' in excel

Select a non-empty cell. Do Data -> Text ...READ MORE

answered Feb 21, 2022 in Database by gaurav
• 23,260 points
1,804 views
0 votes
1 answer

Convert a number to a letter in C# for use in Microsoft Excel [duplicate]

If you are familiar with using formulas ...READ MORE

answered Feb 23, 2022 in Database by gaurav
• 23,260 points
783 views
0 votes
1 answer

Date difference: different results in Excel vs. Python

To calculate the date difference, we can ...READ MORE

answered Feb 23, 2022 in Database by gaurav
• 23,260 points
1,098 views
0 votes
1 answer

Group by Sum in Excel

It is very easy and you can ...READ MORE

answered Feb 21, 2022 in Database by gaurav
• 23,260 points
551 views
0 votes
1 answer

Merging Two excel files as two sheets in one workbook in java

Basically for this, you need to create ...READ MORE

answered Feb 21, 2022 in Database by gaurav
• 23,260 points
1,037 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP