All functions |
|
---|---|
transform function for get_sqlite_xtab cleaning names |
|
close_sqlite_xtab |
|
Collect data and normalize result |
|
convert csv to sqlite adapted from https://rdrr.io/github/coolbutuseless/csv2sqlite/src/R/csv2sqlite.R |
|
convert tibble or data frame to sqlite |
|
Pivot xtab columns to long form |
|
get_sqlite_xtab |
|
create indices on index_fields in the sqlite database in case they don't exist |
|
Set up virtual conda env |
|
transform function for get_sqlite_xtab cleaning names |
|
remove notes |
|
transform function for get_sqlite_xtab cleaning names |
|
get xtab in long form |
|
remove columns by regular expression |
|
transforms standard StatCan xtab to long form |
|
Download xml xtab data from url, tag with code for caching useful for (2001) census profile data |
|
Use python to parse xml |
|
Download xml xtab data from url, tag with code for caching useful for older (2006) data that does not come as csv option |
|
Download xml xtab data from url, tag with code for caching useful for older (2006) data that does not come as csv option |