All functions

clean_xtab_names_transform()

transform function for get_sqlite_xtab cleaning names

close_sqlite_xtab()

close_sqlite_xtab

collect_and_normalize_xtab()

Collect data and normalize result

csv2sqlite()

convert csv to sqlite adapted from https://rdrr.io/github/coolbutuseless/csv2sqlite/src/R/csv2sqlite.R

data2sqlite()

convert tibble or data frame to sqlite

gather_for_grep_string()

Pivot xtab columns to long form

get_sqlite_xtab()

get_sqlite_xtab

index_xtab_fields()

create indices on index_fields in the sqlite database in case they don't exist

install_python_environment()

Set up virtual conda env

numeric_xtab_values_transfrom()

transform function for get_sqlite_xtab cleaning names

remove_xtab_notes_transform()

remove notes

standard_xtab_transform()

transform function for get_sqlite_xtab cleaning names

standardize_xtab()

get xtab in long form

strip_columns_for_grep_string()

remove columns by regular expression

tidy_xtab()

transforms standard StatCan xtab to long form

xml_census_2001_profile()

Download xml xtab data from url, tag with code for caching useful for (2001) census profile data

xml_to_csv()

Use python to parse xml

xml_via_python()

Download xml xtab data from url, tag with code for caching useful for older (2006) data that does not come as csv option

xml_xtab_for()

Download xml xtab data from url, tag with code for caching useful for older (2006) data that does not come as csv option