Pandas dataframe：how to achieve that two rows are subtracted according to the keys?

Asked Apr 20 '18 at 05:55

Active Apr 20 '18 at 05:55

Viewed 24 times

For example, I have a dataframe:

  id    Click_time  
0  a           3         
1  b           1         
2  a           4         
3  b           6         
4  a           8         
5  b           8

I want to get each id's interval between two clicks. What I want to get is as follows:

      id    Click_time  interval
0  a           3         nan
1  b           1         nan
2  a           4         1
3  b           6         5
4  a           8         4
5  b           8         2

How can I achieve it ?

asked Apr 20 '18 at 05:55

rosefun

1,797
1
21
33

Use `df['interval'] = df.groupby('id')['Click_time'].diff()` – jezrael Apr 20 '18 at 05:57
1

Thanks! Your answer solves my problem. – rosefun Apr 20 '18 at 06:36

Pandas dataframe：how to achieve that two rows are subtracted according to the keys?

0 Answers0