擅长:python、mysql、java
<pre><code>df = pd.DataFrame({'Opportunity':['AB122','AB123','AB125', 'AB124'],
'Quantity': [2, 3, 4, 1],
'Member': ["AACC", "AACC", "AACC", 'DDEE']})
even = lambda x: int(x) % 2 == 0
df['Opportunity'] = df['Opportunity'].apply(lambda x: x[:2] + (x[2:] if even(x[2:]) else str(int(x[2:]) -1)))
print(df)
</code></pre>
<p>输出:</p>
<pre><code> Opportunity Quantity Member
0 AB122 2 AACC
1 AB122 3 AACC
2 AB124 4 AACC
3 AB124 1 DDEE
</code></pre>