Skip to contents
-
collect_collections()
- For a provided url, returns links associated with statistical collections
-
collect_links()
- For a provided url, returns links associated with uploaded statistical publication files
-
create_bq_table()
- For a provided table, create and upload a table to BigQuery
-
extract_orr_urls()
- For a provided url, return a table of urls of uploaded ODS and CSV files
-
extract_table_urls()
- For a provided url, return a table of urls of uploaded ODS and CSV files
-
gcp_to_bq()
- To tidy published DfT data, stored in GCP, and move to BigQuery
-
scrape_links()
- For a provided url, reads in the page and extracts all the link addresses from that page
-
scrape_odd_methodology()
- For a provided url, return those stats which have dynamically updating methdology links
-
scrape_tables()
- For a provided url, returns urls of uploaded ODS and CSV files associated with statistical publications
-
tidied_df()
- Tidies tables in ODS workbooks and converts to long format
-
year_column_check()
- For a given vatiable, check if it includes year information