擅长:python、mysql、java
<p>首先尝试检查nan,然后检查<code>YES</code>。然后使用<code>np.select</code>:</p>
<pre><code>df['D'] = np.select((df.isna().all(1), df.eq('Yes').any(1)),
('Invalid', True), False)
</code></pre>
<p>输出:</p>
<pre><code> A B C D
1 NaN NaN NaN Invalid
2 NaN Yes Yes True
3 No Yes Yes True
4 No Yes Yes True
5 No No NaN False
</code></pre>