擅长:python、mysql、java
<p>试试这个</p>
<p>数据</p>
<pre><code> id kpoints Rpoints Wpoints
0 1 1241 -1 1466
1 2 0 1475 0
2 3 0 1586 0
3 4 0 -1 0
</code></pre>
<p>使用</p>
<pre><code>data.loc[(data['Rpoints'] != -1) & (data['kpoints'] == 0), 'kpoints'] = None
data.loc[(data['Rpoints'] != -1) & (data['Wpoints'] == 0), 'Wpoints'] = None
</code></pre>
<p>输出</p>
<pre><code> id kpoints Rpoints Wpoints
0 1 1241.0 -1 1466.0
1 2 NaN 1475 NaN
2 3 NaN 1586 NaN
3 4 0.0 -1 0.0
</code></pre>
<p>简单<code>data.dropna()</code>将删除所有na行</p>