擅长:python、mysql、java
<p>不完全理解你想要达到的目标,但你可以尝试</p>
<pre class="lang-py prettyprint-override"><code>items={"ä":"a","ç":"c","è":"e","º":"","Ã":"A","Í":"I","í":"i","Ü":"U","â":"a","ò":"o","¿":"","ó":"o","á":"a","à":"a","õ":"o","¡":"","Ó":"O","ù":"u","Ú":"U","´":"","Ñ":"N","Ò":"O","ï":"i","Ï":"I","Ç":"C","À":"A","É":"E","ë":"e","Á":"A","ã":"a","Ö":"O","ú":"u","ñ":"n","é":"e","ê":"e","·":"-","ª":"a","°":"","ü":"u","ô":"o"}
df = pd.DataFrame([
'abcä',
'Ãbcd12345'
], columns=['colA'])
df['colA'] = df['colA'].str.replace(r'[^\x00-\x7F]', lambda x: items.get(x.group(0)) or '_', regex=True)
df
</code></pre>
<pre><code> colA
0 abca
1 Abcd12345
</code></pre>
<p>对于<code>r'[^\x00-\x7F]</code>检查<a href="https://stackoverflow.com/questions/2758921/regular-expression-that-finds-and-replaces-non-ascii-characters-with-python">Regular expression that finds and replaces non-ascii characters with Python</a></p>