擅长:python、mysql、java
<p>你可以这样做:</p>
<pre class="lang-py prettyprint-override"><code>city_list = ["Stevenage", "Essex", "Coventry", "Chester"]
def get_match(row):
col_2 = row["col 2"].replace(",", " ").split() # Here you should process the string as you want
for c in city_list:
if difflib.get_close_matches(col_2, c)
return c
return ""
df["col 3"] = df.apply(lambda row: get_match(row), axis=1)
</code></pre>