擅长:python、mysql、java
<p>这里有一种使用<a href="https://docs.scipy.org/doc/numpy/reference/generated/numpy.argmax.html" rel="nofollow noreferrer">^{<cd1>}</a>的方法:</p>
<pre><code>df['targetCol'] = df.values[df.index, df.ne('No').values.argmax(1)]
col1 col2 col3 col4 targetCol
0 A No No No A
1 A No No No A
2 A No No No A
3 No No No D D
4 No B No No B
5 No No C No C
6 No No C No C
</code></pre>