Separate the 'series' column in a data frame (tibble) downloaded using read_abs() into multiple columns using the ";" separator.

separate_series(
  data,
  column_names = NULL,
  remove_totals = FALSE,
  remove_nas = FALSE
)

Arguments

data

A data frame (tibble) containing tidied data from the ABS time series table(s).

column_names

(optional) character vector. Supply a vector of column names, such as c("group_name", "variable","gender"). If not supplied, columns will be named "series_1" etc.

remove_totals

logical. FALSE by default. If set to TRUE, any series rows that contain the word "total" will be removed.

remove_nas

locical. FALSE by default. If set to TRUE, any rows containining an NA in at least one of the separated series columns will be removed.

Value

A data frame (tibble) containing the tidied data from the ABS time series table(s).

Examples

if (FALSE) { # \dontrun{
wpi <- read_abs("6345.0", 1) %>%
  separate_series()
} # }