擅长:python、mysql、java
<p>用熊猫南。这些单元格在Excel中将为空(例如,您可以使用“选择空单元格”命令)。你不能用空字符串。</p>
<pre><code>import numpy as np
df.replace(['None', 'nan'], np.nan, inplace=True)
</code></pre>
<p><a href="https://i.stack.imgur.com/y7yZA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/y7yZA.png" alt="enter image description here"/></a></p>
<p><a href="https://i.stack.imgur.com/9NXSp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9NXSp.png" alt="enter image description here"/></a></p>