擅长:python、mysql、java
<p>从你的例子中我了解到,<code>Bos == "Buy"</code>是<code>Quantity Traded</code>损失,而<code>Bos == "Sell"</code>是<code>Quantity Traded</code>增益。考虑到这一点,您可以执行以下操作:</p>
<pre><code>df = pd.DataFrame({
'Security Name':['Max Pro','Max Pro','AVG','AVG'] ,
'Bos':['Buy','Sell','Buy','Sell'],
'Quantity Traded': [2000,1500,500,2000]
})
# Set the Bos == Sell as negative values
df.loc[ df["Bos"] == "Sell", "Quantity Traded" ] *= -1
df = df.groupby("Security Name").sum()
</code></pre>