Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started