擅长:python、mysql、java
<p>在对数据帧进行排序后,可以使用<code>diff</code>执行此操作:</p>
<pre><code># Sort
df = df.sort_values(by=['ID Vendedor', 'Report month'])
# Compute diff
df['Diff'] = df['sum'].diff()
# Set to 0 when vendor changes
mask = df['ID Vendedor'] != df['ID Vendedor'].shift(1)
df.loc[mask, 'Diff'] = 0
# Sort again?
df = df.sort_values(by='Report month')
</code></pre>