回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我有文本格式的原始输入,字符串中有特殊字符。我想更改字符串中的这些特殊字符,以便在运行代码后,其中不会有任何特殊字符</p>
<p><a href="https://i.stack.imgur.com/reKRq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/reKRq.png" alt="enter image description here"/></a></p>
<p><a href="https://i.stack.imgur.com/kNMo9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kNMo9.png" alt="enter image description here"/></a></p>
<p>我试着写下面的代码。我不确定它是对还是错</p>
<pre><code>def avoid(x):
#print(x)
#value=[]
for ele in range(0, len(x)):
p=invalidcharch(ele)
#value.append(p)
#value=''.join(p)
print(p)
return p
def invalidcharch(e):
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"}
for i, j in items.items():
e = e.replace(i, j)
return e
for col in df.columns:
df[col]=df[col].apply(lambda x:avoid(x))
</code></pre>
<p>但在上面的代码中,我无法将整个字符串存储在变量p中。我需要将整个字符串值存储在p中,以便它存储替换单元格值。
包含混合数据类型值(如字符串整数)的数据</p>
<p><strong>A列</strong><br/>
卡卡韦洛斯之家<br/>
布拉根萨<br/>
拉斐尔旅社圣阿古斯蒂广场酒店
Cartão MOBI.E
R.Conselheiro Emídio Navarro(法语)</p>
<p><strong>在更改后</strong><br/>
Junto a Estacao de Carcavelos<br/>
布拉干卡<br/>
拉法利特旅社圣阿古斯蒂广场核电站现场。<br/>
卡托莫比酒店
R.Conselheiro Emidio Navarro(伊塞尔阵线)</p>