Vectors ( str or ) – V#(s) to retrieve data for Retrieve V# data directly from Statistics Canada. Static vectors_to_df_remote ( vectors, periods=1, start_release_date=None, end_release_date=None ) ¶ Have their tables downloaded prior to returning the dataframe Note that any V#s in tables that are not currently locally stored will Pandas.DataFrame – Dataframe indexed on reference date, with columns for each V# input Start_date ( datetime.date, optional) – earliest reference period to return, defaults to all available history vectors_to_df ( vectors, start_date=None ) ¶ Vector_metadata – list of dictionaries with one dict for each vector Return type Vectors ( str or ) – V#(s) to retrieve metadata Returns list of tables that were updated, empty list if no updates made static vector_metadata ( vectors ) ¶
Install statsbar exad update#
Tables ( str or, default None) – Optional subset of tables to check for updates, defaults to update all
Latest available on Statistics Canada and updates any tables necessary Parameters update_tables ( tables=None ) ¶Ĭompares latest available reference period in locally stored tables to the Get a list of tables that were updated today. Parametersĭate ( str or datetime.date) – The date to check tables ReturnsĬhanged_tables – one dictionary for each table with its update date Return type Get a list of tables that were updated on a given date. To update a locally stored table,Ĭall StatsCan.update_tables(), optionally passing just the table number of interest If it’s unavailable it willĭownload it and then return the table. It will retrieve that locally stored dataframe. If the table has been previously loaded to the file in self.data_folder Pandas.DataFrame – Dataframe of the requested table Table ( str) – The ID of the table of interest, e.g “271-000-22” Returns get_tables_for_vectors ( "v39050" ) table_to_df ( table ) ¶ ”all_tables” key with a list of all tables
Install statsbar exad plus#
Vectors ( str or ) – V#(s) to look up tables for Returnsĭictionary of vector ( table pairs plus an) static get_tables_for_vectors ( vectors ) ¶įind which table(s) a V# or list of V#s is from. ReturnsĬode_sets – one dictionary for each group of information Return type static get_code_sets ( ) ¶Ĭode sets provide additional metadata to describe variables and are grouped into property downloaded_tables ¶Ĭhecks the file “stats_can.h5” in the instantiated data folderĪnd lists all tables stored there. Tables ( str or ) – tables to delete Returns
Defaults to the current working directory ( data) – Location to save/search for locally stored Statistics Canada ( The) – Load Statistics Canada data and metadata into python.
delete_tables ( "271-000-22-01" ) StatsCan class documentation ¶Ĭore functions outlined in the Quickstart along with some extraįunctionality are described here: class stats_can.api_class.
0 kommentar(er)
