擅长:python、mysql、java
<p>问题可归因于描述单元,因为有两个新的连续行的零件,它们之间没有任何内容</p>
<p>我只是使用<code>.dropna()</code>读取创建的新csv,并在没有NaN值的情况下重写它。无论如何,我认为重复这个过程不是最好的方法,但它作为一个解决方案是直接进行的</p>
<pre class="lang-py prettyprint-override"><code>df.to_csv(root_new_fn, sep = ',', quotechar = '"', encoding = 'utf-8', index = False)
new_df = pd.read_csv(root_new_fn).dropna()
new_df.to_csv(root_new_fn, sep = ',', quotechar = '"', encoding = 'utf-8', index = False)
new_df = pd.read_csv(root_new_fn)
print(type(new_df.iloc[7, 1]))# where was a NaN value
print(new_df['descripcion'].isnull())
<class 'str'>
0 False
1 False
2 False
3 False
4 False
5 False
6 False
7 False
8 False
and continues...
</code></pre>