擅长:python、mysql、java
<p>您可以创建一个替换字典,然后使用'loc'替换它们。</p>
<pre><code>target_for_values = {
'DOLLARD-DES-ORMEAUX': ['D.DO', 'DOLLARD', 'DDO'],
'ILE-PERROT': ['IL PERROT', 'ILLE PEROT', 'ILE PERROT']}
for k, v in target_for_values.iteritems():
df.loc[df.CITY.str.upper().isin(v), 'CITY'] = k
>>> df.CITY
CITY
0 C.DO
1 DOLLARD-DES-ORMEAUX
2 DOLLARD-DES-ORMEAUX
3 DOLLARD-DES-ORMEAUX
4 ILE-PERROT
5 Pierrefonds
6 Ile Bizard
7 ILE-PERROT
8 ILE-PERROT
9 Pierrefonds
</code></pre>