get_sqlite_xtab

get_sqlite_xtab

get_sqlite_xtab(
  code,
  url = NA,
  cache_dir = getOption("statcanXtab.cache_dir"),
  transform = standard_xtab_transform,
  refresh = FALSE,
  existing_unzip_path = NA,
  format = "csv"
)

Arguments

code

Code for the xtab, used for local caching

url

url to download the csv version of the xtab

cache_dir

optional cache directory, default is getOption("statcanXtab.cache_dir").

transform

transform to apply to data, default is standard_xtab_transform which removes the notes column, cleans up the variable names and casts the Value column to numeric.

refresh

redownload and parse data, default FALSE

existing_unzip_path

optional path to unzipped xtab, useful for large (>4GB unzipped) xtabs on windows machines

format

data format of xtab, defaults to "csv". Other valid options are "xml" and "python_xml". Set according to the format of the data, and if conversion through xml should be done via python for better performance