擅长:python、mysql、java
<p>在python中加载excel后,可以使用unicodedata模块。
您也可以在保存excel文件时使用其编码。你知道吗</p>
<pre class="lang-py prettyprint-override"><code>text= u"\u200bDuring the QA, bla bla bla,\xa0Head of bla bla\xa0for NZ,\xa0was labelled bla bal. With further investigation, bla bla bla bla bla bla."
from unicodedata import normalize
t=normalize('NFD',text)
print(t)
</code></pre>
<p>您可能需要检查它们引用的<a href="https://docs.python.org/2/library/unicodedata.html" rel="nofollow noreferrer">documentation</a></p>
<blockquote>
<p>Even if two unicode strings are normalized and look the same to a human reader, if one has combining characters and the other doesn’t, they may not compare equal. </p>
</blockquote>