Function reference • store

Package management Functions used to management package dependencies
`get_cran_package_system_dependencies()`	Get CRAN packages' system dependencies
Store credentials Securely store and retrive database connections using the keyring package
`create_locked_keyring()`	Create a new keyring
`get_keyring_status()`	Get the status of a keyring
`list_keys()`	List the keys within a keyring
`unlock_keyring()`	Unlock a keyring
`add_key()`	Add a key to a keyring
`delete_key()`	Delete a key from a keyring
`lock_keyring()`	Lock a keyring
Database connections Connect to databases
`get_sqlserver_connection()`	Connect to a SQL Server database
`get_postgres_connection()`	Connect to a PostgreSQL database
`get_mysql_connection()`	Connect to a MySQL database
Lookup tables Dataframes containing data table lookups
`country_codes`	ISO-3166 three letter country codes with United Nations regions and European Union membership
`uk_ireland_tenkm_grid_squares`	UK and Ireland 10km grid squares
`vc_grid_square_intersects`	Vice counties grid square intersections
Example tables Dataframes containing example data
`nbn_demonstration_dataset`	NBN demonstration dataset
Spatial data Explore spatial datasets
`tidy_spatial_data()`	Tidy spatial data
`extract_polygons()`	Extract and dissolve polygons from geometry collection
`create_bounding_box()`	Create bounding box polygon
`uk_ireland_base_map`	UK Ireland Base Map derived from the Oil and Gas Authority's OGA and Lloyd's Register SNS Regional Geological Maps (Open Source) layer
Grid Reference Extract and format grid reference information, including REST API endpoints.
`as_gridref()`	Convert a string to a gridref object
`precision()`	Get the precision of a grid reference
`projection()`	Get the projection of a grid reference
`easting()`	Get the easting of a grid reference
`northing()`	Get the northing of a grid reference
`hectad()`	Get the 10km grid reference
`pentad()`	Get the 5km grid reference
`tetrad()`	Get the 2km grid reference
`monad()`	Get the 1km grid reference
`hectare()`	Get the 100m grid reference
`gridsquare_geometry()`	Convert a OSGB or OSNI grid reference to a polygon geometry feature
Exploratory Data Analysis Explore datasets
`eda_variable_collection()`	Run the exploratory data analyses
`eda_variable_summary()`	Display a summary of the variables
`eda_variable_distribution()`	Display the distribution of the variables
`eda_variable_outliers()`	Display the variable outliers
`eda_variable_correlation()`	Display the correlation between the variables
Data manipulation Format data
`extract_comma_delimited_list()`	Extract a comma delimited list of items
`extract_semicolon_delimited_list()`	Extract a semi-colon delimited list of items
`extract_space_delimited_list()`	Extract a space delimited list of items
`extract_paragraph_delimited_list()`	Extract a paragraph delimited list of items
`add_tibble_to_list()`	Add a tibble to a list
Iteration Functions used to help with iterating through a dataset
`tally_counter()`	Count the number of remaining interactions
`click()`	Increment the tally counter
Data visualisation Tabular and graphical visualisations
`display_table()`	Display a dataset as a table
`reduce_image_size()`	Reduce the size of an image
`add_image_shadow()`	Add a shadow to an image
Quality assurance Functions and tables used in quality assurance
`compare_dataset_versions()`	Compare two versions of a dataset
Export data and analyses Export data to Excel spreadsheets
`add_new_spreadsheet()`	Add a new spreadsheet containing data and an image to an Excel workbook

Reference

Package management

Store credentials

Database connections

Lookup tables

Example tables

Spatial data

Grid Reference

Exploratory Data Analysis

Data manipulation

Iteration

Data visualisation

Quality assurance

Export data and analyses