Create a codebook for SurveyMonkey data

createCodebook() creates a partial codebook that can be edited to create useful variable names from SurveyMonkey data. It returns a long form tibble to use as a code book for the SurveyMonkey data, it returns 5 columns described below and variable_name is the column that will be used in the function readRenameData() to rename the variable names in the data to be imported into R.

Usage

createCodebook(file_path)

Arguments

file_path

Required, A file path with extension of .csv or .xlsx.

Value

A tibble with 5 columns: header_1, header_2, combined_header, variable_name and position. header_1 is the first header row, header_2 is the second header row, combined_header is the combination of the two headers, position is the column number for each combined_header, and variable_name is a cleaned up version for combined_header and will be the column to edit to change the column names later on to shorter and more meaningful names.