bindColumns: Combine Similar Columns Into One

In madlogos/asestio: ASES Analytic Toolkit on Data I/O and Transformation

Description

Combine similar columns into one column within one spreadsheet.

Usage

bindColumns(mapping.file = paste0(toolkit, "BindFieldNames.xlsx"),
  toolkit = getOption("toolkit.dir"), sheet = 1,
  output.format = c("xlsx", "csv"))

bind_columns(mapping.file = paste0(toolkit, "BindFieldNames.xlsx"),
  toolkit = getOption("toolkit.dir"), sheet = 1,
  output.format = c("xlsx", "csv"))

Arguments

mapping.file	Name of the field name mapping dictionary. Default 'BindFieldNames.xlsx' in toolkit directory.
toolkit	Directory of the dictionary.
sheet	the sheet (number or name character) of the target workbook to read in. Default 1.
output.format	csv or xlsx. Default xlsx.

Value

A list.

• Output Results shows the path where bind_output.xlsx is;

• Dropped columns shows the variables dropped during the combination.

Author(s)

Yiying Wang, [e-mail]

Examples

## Not run: 
bindColumns()

## End(Not run)

madlogos/asestio documentation built on June 26, 2019, 12:18 a.m.