Conditonal formatting of data based on time between entries
Budget: $10 – $30 USD
create a new data set that has the columns ID, DATE, START, STOP, DUR_s, DMI_kg.
When the time between entries (bunk visits) is less than 1 minute, they should be collapsed in to a single entry, containing the new stop time and summing the DUR and DMI_kg columns to account for the increased length of visit, as we as the associated date and ID. This will be done by ID by day for all entries in the data set. What I DON'T want is just a summary of duration and DMI_kg by day, I only want to summarize if the time between visits in less than 1 minute.
New data described above.
When the time between entries (bunk visits) is less than 1 minute, they should be collapsed in to a single entry, containing the new stop time and summing the DUR and DMI_kg columns to account for the increased length of visit, as we as the associated date and ID. This will be done by ID by day for all entries in the data set. What I DON'T want is just a summary of duration and DMI_kg by day, I only want to summarize if the time between visits in less than 1 minute.
New data described above.
Related categories:
R Programming Language