Skip to contents

All functions

aggregate_csvs()
combine data csvs
as.Date(<flexible>)
flexible character to date converter
errorSaver()
Function wrapper to capture errors and warnings for storing
gdrive_client_setup()
get a google drive 'client' for authentication from env file
gdrive_setup()
connect to your google drive account, required set-up for using the google drive packages
get_api_key()
check google cloud api key configuration
get_col_type_from_spec()
vector of types from column names, in order
get_drive_email()
pull drive email from environment
get_gsfile()
get a google drive file object given path and share drive
gfile_modified_time()
WIP get time stamp for a particular gfile
gsheet_auth_setup()
setup authentication for reading google sheet
read_data_csv()
read in a CSV from L0 folder, using specification spec
read_data_sheet()
read in google sheet for formatted for specific project, similar to how the readr package works for read_csv with a spec sheet data sheet features
  • allows you to skip top row(s) of data - allows for sheets that have non-data rows that are descriptive

  • numeric columns can have numeric strings and those will be converted to NAs, e.g. can indicate "NA" in numeric cells

  • requires a spec sheet that uses names per type_converter_fun()

read_gcsv()
download a CSV file from the project google shared drive and read into memory
read_gsheet_by_url()
read data in a google sheet from a URL and tab number
read_url_list()
read in the table of google sheet URLs with id
read_validate_and_save()
given a URL and params, read, validate and save a CSV
remove_comment_line()
remove line 2 from a csv file, used by data-entry for column directions/description.
spec_to_readr_col_types()
convert our specification format to something useable by readr::read_csv
type_code_to_readr_code()
convert a type name to a readr convert code
type_converter_fun()
code to conversion function mapping
validate_all()
read the list of urls, read, confirm column format, validate and when using in development mode, make sure do run devtools::load_all() to get all the collaboratR functions loaded save to CSV
validate_data()
validate data df
validate_data_columns()
validate columns against data definition
validate_from_file()
convenience to create validation results from a yaml file