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
-
download_cover()
- Download the cover sheet from a published DfT table
-
download_orr_cover()
- Download the cover sheet from a published ORR table
-
extract_metadata()
- Extract metadata from the most recent DfT files in a Google Cloud Storage bucket
-
extract_orr_metadata()
- Extract metadata from the most recent ORR files in a Google Cloud Storage bucket
-
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_tables_to_list()
- To tidy published DfT data, stored in GCP, and move to BigQuery
-
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 methodology links
-
scrape_orr_methodology()
- For a provided ORR url, return those stats which have dynamically updating methodology 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