Verbosely assign tidy name and data type for each column of a data.frame and get rid of superfluous columns. Uses a .csv file for assignments to encourage a data dictionary based workflow. CAVE! Requires 'Date' type columns to already be read in as Date.
assign_types_names(data, meta_data)clean data.frame
data.frame to be tidied. Dates must already be of type date.
data.frame specifying old column names, new column names and datatypes of data. Has the following columns:
old_column_name : character with the old column name.
new_data_type : character denoting the tidy data type. Supported types are:
character (will be coerced using as.character()).
integer (will be coerced using as.integer()).
float (will be coerced using as.double()).
factor (will be coerced using as.factor()).
Will result in a warning if the new factor variable will have more than 10 levels.
date (can only confirm correct datatype assignment or coerce characters with format '%Y-%m-%d').
new_column_name : tidy column name. Can be left blank to keep the old column name.
Optional other columns (do not affect behavior).
J. Peter Marquardt