python字典模糊查找_在一个Python数据框/字典中搜索另一数据框中的模糊匹配

我有以下具有50,000个唯一行和20列的pandas数据框(其中包括相关列的摘要)：

df1 ：

PRODUCT_ID PRODUCT_DESCRIPTION

0 165985858958 "Fish Burger with Lettuce"

1 185965653252 "Chicken Salad with Dressing"

2 165958565556 "Pork and Honey Rissoles"

3 655262522233 "Cheese, Ham and Tomato Sandwich"

4 857485966653 "Coleslaw with Yoghurt Dressing"

5 524156285551 "Lemon and Raspberry Cheesecake"

我也有以下数据框(我也以字典形式保存了它)，它具有2列和20,000个唯一行：

df2(也另存为dict_2)

PROD_ID PROD_DESCRIPTION

0 548576 "Fish Burger"

1 156956 "Chckn Salad w/Ranch Dressing"

2 257848 "Rissoles - Lamb & Rosemary"

3 298770 "Lemn C-cake"

4 651452 "Potato Salad with Bacon"

5 100256 "Cheese Cake - Lemon Raspberry Coulis"

我想要做的是将df1中的“ PRODUCT_DESCRIPTION