擅长:python、mysql、java
<p>使用<a href="https://numpy.org/doc/stable/reference/generated/numpy.select.html" rel="nofollow noreferrer">^{<cd1>}</a>测试<a href="http://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.any.html" rel="nofollow noreferrer">^{<cd3>}</a>中至少一个值<code>Yes</code>,然后测试<a href="http://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.all.html" rel="nofollow noreferrer">^{<cd4>}</a>是否错误显示了所有值:</p>
<pre><code>#columns for test, in real data 14 columns names
cols = ['A','B','C']
m1 = dfMSR[cols].eq('Yes').any(axis=1)
m2 = dfMSR[cols].isna().all(axis=1)
dfMSR['D'] = np.select([m1, m2], [True, 'Invalid'], default=False)
print (dfMSR)
A B C D
1 NaN NaN NaN Invalid
2 Yes Yes NaN True
3 No Yes Yes True
4 No Yes Yes True
5 No No NaN False
</code></pre>