standardize_cols_by_cb: Standardize the columns in the order specified by the...
In IdahoAgStats/factcuratoR: Functions to curate FACT data

standardize_cols_by_cb

R Documentation

Standardize the columns in the order specified by the codebook

Description

Contains options to add missing columns or remove unnecessary columns The ordering follows the column order specified in the codebook Any extra columns will come after, in alphabetical order.

Usage

standardize_cols_by_cb(
  df,
  codebook_name,
  add_missing_cols,
  required_only,
  codebook_cols_only,
  db_folder,
  new_col_fill = "",
  cols_keep = NULL
)

Arguments

`df`	A data.frame with column names to verify against the codebook names against e.g. "trial_data", "trials_metadata"
`codebook_name`	A string that matches the book name in codebooks_all_db.csv
`add_missing_cols`	A logical denoting whether to add missing columns
`required_only`	A logical denoting whether to add only required columns. This parameter is only called if add_missing_cols = TRUE. Note: This option refers only to missing columns If optional columns exist in the df, these columns are retained.
`codebook_cols_only`	A logical denoting whether to remove any columns not specified by the codebook
`db_folder`	A string path to the database controlled vocabulary folder
`new_col_fill`	A value that will be used to fill newly created columns
`cols_keep`	A vector containing names of columns to keep (This is a useful argument to use when codebook_cols_only = TRUE, but the user wants to retain a few other columns that aren't in the codebook)