Forum Discussion
Difference in hours between duplicates
Please find the attached solution after signature
Super UserAnonymous let me rephrase my question, same session id can have more than one duplicate, if yes, let's say session id 111 has 10 rows then how your calculation would look like? I'm not going to blindly provide a solution when I didn't know the problem in-depth.
parry2k sorry for not being explicit.
If an id has 10 duplicates, I need to have the time difference in hours between consecutive id's. An example:
Session_ID Date Time The column I need
111 10/04/2020 10:00 NaN
111 10/04/2020 11:00 1
111 10/04/2020 12:00 1
111 10/04/2020 15:00 3
111 11/04/2020 01:00 10
112 11/04/2020 10:00 NaN
111 11/04/2020 11:00 10
- amitchandak
Please find the attached solution after signature
amitchandak thank you so much for your solution. Looks like exacly what I need.
For some reason, it is constantly giving me a memory error. Even with small amounts of data.
- amitchandak
Anonymous , check the new two columns were I split the calculations