Question: I am using Python I have the following columns, each row shows an interaction - i . e . when a device of type u
I am using Python
I have the following columns, each row shows an "interaction"
ie when a device of type u is near a device of type a:
uimei device id of type u
aimei device id of type a
upingtime timestamp of device of type u
apingtime timestamp of device of type a
upingid unique ping id of type u
apingid unique ping id of type a
Please note each device sends one ping per minute.
For each unique combination of uimei, aimei, I want to calculate the duration of an interaction as follows:
if the next row is minutes or less apart, then merge the duration and consider it part of the same interaction.
if the next row is minutes or more apart, then consider that as a seperate interaction.
i want start and end time and duration of each such unique interaction.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
