擅长:python、mysql、java
<p>我想这将是你所期望的。我写得很通俗易懂</p>
<pre><code>d7 = pd.DataFrame({'CAD':[-4350242.355,424223.7584],'Currency':['GBP','AUD'],'Category':['Stack','Stack']})
fxratetable = pd.DataFrame({'from_currency':['GBP','AUD'],'fx_rate':[1.367,0.7706 ]})
_condition1 = d7['Category'] == 'Stack'
_condition2 = d7['Currency'] == fxratetable['from_currency']
d7['CAD (expected)'] = np.where(_condition1 & _condition2,d7['CAD'] * fxratetable['fx_rate'],d7['CAD'])
d7
</code></pre>
<p>输出
<a href="https://i.stack.imgur.com/9zBSJ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9zBSJ.png" alt="enter image description here"/></a></p>