擅长:python、mysql、java
<p>尝试:</p>
<pre><code>df['Opportunity'] = df['Opportunity'].str[:2] + np.where(df['Opportunity'].str[2:].astype(int) % 2, df['Opportunity'].str[2:].astype(int).sub(1).astype(str), df['Opportunity'].str[2:])
</code></pre>
<p>现在:</p>
<pre><code>print(df)
</code></pre>
<p>是:</p>
<pre><code> Member Opportunity Quantity
0 AACC AB122 2
1 AACC AB122 3
2 AACC AB120 4
3 DDEE AB120 1
</code></pre>