get_sqlite_xtab: get_sqlite_xtab

In mountainMath/statcanXtabs: Helper function for managing StatCan xtabs

get_sqlite_xtab

Description

get_sqlite_xtab

Usage

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

mountainMath/statcanXtabs documentation built on Aug. 17, 2022, 2:50 p.m.