擅长:python、mysql、java
<p>这里有可能使用<a href="https://docs.scipy.org/doc/numpy/reference/generated/numpy.select.html" rel="nofollow noreferrer">^{<cd1>}</a>,对于按位的链<code>OR</code>使用<code>|</code>:</p>
<pre><code>m1 = df['AF_SC'] == df['TB_SC']
m2 = df['AF_SC'] == df['VS_SC']
m3 = df['TB_SC'] == df['VS_SC']
df['result'] = np.select([m1 | m2, m3], [df['AF_SC'], df['TB_SC']], "neutral")
</code></pre>
<p>您的解决方案应该更改:</p>
<pre><code>df['result'] = np.where((df['AF_SC'] == df['TB_SC']) |
(df['AF_SC'] == df['VS_SC']), df['AF_SC'],
np.where((df['TB_SC'] == df['VS_SC']), df['TB_SC'], "neutral"))
print (df)
AF_SC TB_SC VS_SC result
0 negative negative negative negative
1 positive positive positive positive
2 neutral negative negative negative
3 negative negative positive negative
4 positive positive neutral positive
5 negative negative positive negative
6 neutral positive neutral neutral
7 negative positive positive positive
8 negative positive neutral neutral
</code></pre>