Pattern matching in Pandas dataframe

Asked Oct 29 '18 at 05:16

Active Oct 29 '18 at 06:17

Viewed 167 times

I have two dataframes I want to match each keyword of Dataframe A with Dataframe B with maximum match of characters.

I am tried by splitting characters but its not giving exact output as required and also very low accuracy.

Also, I have 50 columns in Dataframe B, My time complexity is much more than expected, Is there any way to reduce time complexity by reducing search time?

Sample input : dataframe 1 =

dataframe2 - Batu, Balomb, and so on, containing country words but not exact match.

I want to search Balomb with Dataframe 1 with the highest matching characters.

Expected output should be:

If Bolamb found in DF1, it should print word.

edited Oct 29 '18 at 06:17

asked Oct 29 '18 at 05:16

Naitik Chandak

Please share some sample input and expected output. – Mayank Porwal Oct 29 '18 at 05:45
Hi, Added the external details. – Naitik Chandak Oct 29 '18 at 05:59
Remove one of your irrelevant tags and add a plain python tag please – Mad Physicist Oct 29 '18 at 06:16
If you are working with pandas, why do you have three Excel-related tags? – Mad Physicist Oct 29 '18 at 06:17
because I created dataframe with this excel file. it was just for reference for people who might be knowing similar way to get rid out of this.,. Although I removed tags as per your suggestion. – Naitik Chandak Oct 29 '18 at 06:19
@naitik_chandak: you can check [this](https://stackoverflow.com/questions/52092961/fuzzy-lookup-between-2-series-df-columns) – anky Oct 29 '18 at 09:09
No thats not useful, I've already checked that. Logic is too different over there and here – Naitik Chandak Oct 29 '18 at 09:27

Pattern matching in Pandas dataframe

0 Answers0