你不会得到瓦尔D'ISERE，因为它并不存在于城市列表中。它有一个缩写，但程序无法识别它。你必须找到一种方法来解释缩写。下面的代码只处理在两列中找到的精确单词：

from itertools import product
from collections import defaultdict
d = defaultdict(list)
#create a cross Cartesian of the two columns
#and keep only values where City list can be found in text description
for first,last in product(df1.text_description,df2.City_List):
    if last in first:
        d[first].append(last)

d = {k:','.join(v) for k,v in d.items()}

#map the dictionary to text description and create two columns
df1[['city1','city2']] = df1.text_description.map(d).str.split(',',expand=True)

df1
         text_description                               city1       city2
0   ROME AND MILAN ARE AMAZING CITIES                   MILAN       ROME
1   NEW YORK AND LONDON REPRESENT GLOBAL FINANCE M...   NEW YORK    LONDON
2   I LOVE MADRID                                       MADRID      None
3   BANGKOK IS AN AMAZING CITY                          NaN         NaN
4   VAL D'ISERE IS A MAGIC PLACE                        NaN         NaN