擅长:python、mysql、java
<p>使用<a href="https://numpy.org/doc/stable/reference/generated/numpy.where.html" rel="nofollow noreferrer">^{<cd1>}</a>:</p>
<pre><code>df["Valindex"] = np.where(df["RB"].eq(0), df["Valindex0"], df["Valindex1"])
</code></pre>
<p>或</p>
<p>将<a href="https://numpy.org/doc/stable/reference/generated/numpy.select.html" rel="nofollow noreferrer">^{<cd2>}</a>用于多种情况和条件:</p>
<pre><code>conditions = [df["RB"].eq(0), df["RB"].eq(1)]
labels = [df["Valindex0"], df["Valindex1"]]
df["Valindex"] = np.select(conditions, labels)
</code></pre>
<p><code>df</code>的输出:</p>
<pre><code> contract Valindex0 RB Valindex1 Valindex
2 A00118 51 0 50 51
3 A00118 42 1 47 47
4 A00118 44 1 47 47
</code></pre>