擅长:python、mysql、java
<p>依靠这样的辅助功能:</p>
<pre><code>df = pd.DataFrame({'col 1': [59, 62, 179, 180],
'col 2': ['538 Walton Avenue, Chester, FY6 7NP',
'42 Chesterton Road, Peterborough, FR7 2NY',
'3 Wallbridge Street, Essex, 4HG 3HT',
'6 Stevenage Avenue, Coventry, 7PY 9NP'
]})
def aux_func(x):
# split by comma and select the interesting part ([1])
x = x.split(',')
x = x[1]
aux_list = ['Stevenage', 'Essex', 'Coventry', 'Chester']
for v in aux_list:
if v in x:
return v
return ""
df['col 3'] = [aux_func(name) for name in df['col 2']]
</code></pre>