擅长:python、mysql、java
<p>首先确保“CreatedDate”列是datetime:</p>
<pre><code>df['CreatedDate'] = pd.to_datetime(df['CreatedDate'])
</code></pre>
<p>那么这应该管用。你知道吗</p>
<pre><code>df['diff'] = df.sort_values(['Casenumber', 'Site']).groupby(['Casenumber', 'Site'])['CreatedDate'].diff()
</code></pre>
<p>查看其他可能有用的帖子。
<a href="https://stackoverflow.com/questions/40804265/how-to-calculate-time-difference-by-group-using-pandas">How to calculate time difference by group using pandas?</a></p>