擅长:python、mysql、java
<p>创建虚拟数据</p>
<pre><code>df=pd.DataFrame({
'calories':[2306,3256,1235,np.nan,3654,3256],
'Person':['person1','person2','person3','person4','person5','person6',]
})
</code></pre>
<p>打印数据框</p>
<pre><code> calories Person
0 2306.0 person1
1 3256.0 person2
2 1235.0 person3
3 person4
4 3654.0 person5
5 3256.0 person6
</code></pre>
<p>如果缺少卡路里值,则删除行</p>
<pre><code>new_df=df.dropna(how='any',subset=['calories'])
</code></pre>
<p>结果</p>
<pre><code> calories Person
0 2306.0 person1
1 3256.0 person2
2 1235.0 person3
4 3654.0 person5
5 3256.0 person6
</code></pre>
<p>另存为excel</p>
<pre><code>new_df.to_excel('destination.xlsx',index=False)
</code></pre>