expand_times | R Documentation |
Expand timestamp ranges.
expand_times( df, start_var, end_var, name = "Expanded", fmt = "%Y-%m-%d %H:%M:%OS", vars_to_keep = NULL, unit = "hour", tz = "UTC" )
df |
Data frame (can also be a data.table or a tibble) |
start_var |
Start time column |
end_var |
End time column |
name |
The name of newly created column. Defaults to 'Expanded' |
fmt |
The format of date columns, defaults to Y-M-D H:M:OS |
vars_to_keep |
Which columns you would like to keep |
unit |
By which unit of time you want to expand; the default is day |
tz |
Desired time zone - defaults to UTC |
Returns a full data frame with expanded sequences in a column, e.g. by day or month.
df <- data.frame( id = c("1111", "2222", "3333"), gender = c("M", "F", "F"), start = c("2018-01-01 15:00:00", "2019-01-01 14:00:00", "2020-01-01 19:00:00"), end = c("2018-01-01 18:30:00", "2019-01-01 17:30:00", "2020-01-02 02:00:00") ) expand_times(df, start_var = "start", end_var = "end", vars_to_keep = c("id", "gender"), unit = "hour")
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.