擅长:python、mysql、java
<p>为此:</p>
<pre><code>df.loc[(df['Percent'] == 100) &\
(df['Rating1'] != 8) &\
(df['Rating2'] != 1)&\
(df['Grade'] == "NG")]
</code></pre>
<p>您正在从符合此条件的行中选择所有列</p>
<p>由于更改只发生在<code>Percent</code>列上,因此应该将其传递到.loc中。这样,您可以直接设置它</p>
<pre><code>df.loc[(df['Percent'] == 100) &\
(df['Rating1'] != 8) &\
(df['Rating2'] != 1)&\
(df['Grade'] == "NG"), 'Percent'] = np.nan
</code></pre>