Compare 2 files and use fuzzy wuzzy to return a table with the best match

Question

I have the following two datasets:

Raw Data

Lookup Table

and I am trying to use fuzzy wuzzy to create the following extract via a dataframe.

Expected file table

I was able to create a loop to find the correct match by using process.extract, but i can't figure out how to get it to look like the final table

I am trying to use fuzzy wuzzy to create the following extract via a dataframe.

Expected file table