Keywords: Data Preparation, Datetime Data, Tidyverse,
Webpages:
https://CRAN.R-project.org/package=padr,
https://github.com/edwinth/padr padr solves two problems that you can be confronted with when preparing datetime data for analysis. First, data is often recorded on too fine a granualarity. For instance, the timestamp registers the moment up to the second, while you want to do the analysis on an hourly level. The thicken function will add a column to a data frame. In conjunction with dplyr, it will allow for quick aggregation to the higher level. Second, when no events take place there are typically no data records generated. This is sensible from a storage perspective, but often unhelpful for analysing the data. In this context the pad function is used. Besides demonstrating these two functions, I will elaborate on the concept of the
interval, on which both functions heavily rely.