擅长:python、mysql、java
<p>让我们试试:</p>
<pre><code># sort the values
df.sort_values(['playerid','season'], inplace=True)
# group
df[['playerid','season']].join(df.groupby(['playerid'])
[['points', 'rebounds']].diff()
)
</code></pre>
<p>输出:</p>
<pre><code> playerid season points rebounds
0 1234 2009-10 NaN NaN
1 1234 2010-11 33.0 27.0
2 2345 2009-10 NaN NaN
3 2345 2010-11 24.0 17.0
</code></pre>