擅长:python、mysql、java
<p>让我们试试:</p>
<pre><code>df_out = (df.assign(Qty = np.where(df.Type == 'SELL', -df.Qty, df.Qty))
.groupby('Items')['Qty'].sum().reset_index())
df_out['TYPE'] = np.where(np.sign(df_out.Qty)==1,'BUY','SELL')
df_out.assign(Qty=df_out.Qty.abs()).query('Qty > 0')
</code></pre>
<p>输出:</p>
^{pr2}$