Search text into Large data column ( partial match)

[619sandesh]

Hi,

I need to perform name search which having 100+ record which i need to search in data set of company names.

Data set is having record  10,000+ and usually name to be search 100-1000 record to be search. How can we search by partial match.

Please help me with the workflow

Name to be Search

Name to be search

ABC Europe

Johnson & Control

Muthroot golden fin corp ltd

Data Set sample table 

Company Name	Company ID	City	TAN
ABC capital LLC	2145746	Pune	ABCdd445
ABC europe ltd	156454	London	ABCd4565s
Apple	554887	Newyork	Aadjas114
Johnson and control limited	6448484	Newyork	BBBDD145
Reliance capital	5445555	Mumbai	AAAD554
Muthroot golden finance corp limited	8877455	Mumbai	ASAAS55

[binuacs]

@619sandesh may be you can try the attached workflow, adjust the match score if you want in the program

[619sandesh]

Getting error as module not found

[binuacs · Accepted solution]

@619sandesh i think you need to upgrade your python to latest version or another option is to try the fuzzy match tool