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 in Database by Edureka
• 13,640 points
45 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 by gaurav
• 13,460 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,720 points
223 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,240 points
13,110 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,240 points
185 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,360 points
1,910 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,360 points
1,315 views
0 votes
1 answer

Change default 'delimiters' in excel

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

answered Feb 21 in Database by gaurav
• 13,460 points
39 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 in Database by gaurav
• 13,460 points
44 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 in Database by gaurav
• 13,460 points
89 views
0 votes
1 answer

Group by Sum in Excel

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

answered Feb 21 in Database by gaurav
• 13,460 points
26 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 in Database by gaurav
• 13,460 points
39 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP