expand_times {neatRanges} | R Documentation |
Expand timestamp ranges.
Description
Expand timestamp ranges.
Usage
expand_times(
df,
start_var,
end_var,
name = "Expanded",
fmt = "%Y-%m-%d %H:%M:%OS",
vars_to_keep = NULL,
unit = "hour",
tz = "UTC"
)
Arguments
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 |
Value
Returns a full data frame with expanded sequences in a column, e.g. by day or month.
Examples
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")
[Package neatRanges version 0.1.4 Index]