All functions

OuhscMunge

Data manipulation operations frequently used in OUHSC BBMC projects. http://www.ouhsc.edu/bbmc/

assert_non_na() assert_non_na_and_unique()

Assert vector characteristics

assert_version_r()

I that the local machine is using an acceptable version.

clump_month_date() clump_week_date()

Assign date for a given year & month

cut_with_nas()

Convert numeric to factor, with an explicit level for NAs

data_frame_compare_structure()

Verify equivalent structure of two dataset

data_frame_stack_new() metadata_update_file()

Verify equivalent structure of two dataset

data_frame_uniqueness_test() data_frame_uniqueness_assert()

Check uniqueness of column combinations

date_min_with_nas() date_max_with_nas() date_range_with_nas() min_with_nas_numeric() max_with_nas_numeric() range_with_nas_numeric() min_with_nas_integer() max_with_nas_integer() range_with_nas_integer()

Find date ranges in the presence of missing subsets

deterge_to_double() deterge_to_integer() deterge_to_ascii()

Convert (and possibly clean) a vector

execute_sql_file()

Execute a SQL file

first_nonmissing()

First nonmissing element in a vector

hash_and_salt_sha_256()

Salt and hash a value

column_rename_headstart() column_class_headstart() column_value_headstart()

Utilities for outputting characteristics of a dataset used it code.

install_packages_addin()

Install important packages

match_statistics()

Create explicit factor level for missing values.

open_dsn_channel_sqls_odbc()

Open an ODBC channel to a SQL Server database

package_janitor_remote()

checks the user's installed packages against the packages listed in a CSV.

readr_spec_aligned()

Align & qualify the col_types specification passed to readr::spec_csv().

replace_nas_with_explicit()

Create explicit factor level for missing values.

replace_with_nas()

Convert blank, zero-length values to NAs for a variety of data types.

retrieve_key_value()

Read a value stored in a database.

row_sum()

Find the sum of selected columns within a row

snake_case()

Convert variable names to snake_case

trim_numeric() trim_integer() trim_date() trim_datetime() trim_character()

Trim extreme values

update_packages_addin()

Download and install dependencies

upload_sqls_odbc()

Upload to a SQL Server database using odbc

verify_value_headstart()

Generates code to verify a base::data.frame().