0

I have a dataframe - df1

Marketing Sales IT
marketing manager sales lead software eng
marketing spec sales mgr data scientist

And another dataframe - df2 -

Profession Job Title
IT data science manager
Marketing Marketing manager

I need to fuzzy match all the job titles from dataframe 2 (df2) to all the rows and columns in df1 and find fuzzy score of each element .

Sample output - Only for datascience manager (need to create such tables for all the Job Titles in dataframe 1 and find the column which has maximum scores above 90 so as to classify the job title in a profession:

Marketing Sales IT
50 0 30
0 0 91
mozway
  • 194,879
  • 13
  • 39
  • 75
Suraj Bhala
  • 3
  • 1
  • 2
  • you must provide a reproducible input – mozway Jul 20 '22 at 03:05
  • @mozway added the dataframes as a table, please let me know if this helps – Suraj Bhala Jul 20 '22 at 03:13
  • It is better, now you should check for similar questions, try the solutions and add here the exact code you tried and how it failed if really you don't manage. This problem has already been solved many times – mozway Jul 20 '22 at 03:18
  • Does this answer your question? [How do I merge two dataframes by partial string match?](https://stackoverflow.com/questions/72974891/how-do-i-merge-two-dataframes-by-partial-string-match) – René Jul 20 '22 at 05:01

0 Answers0