decomposeDF: Decompose a dataframe into the following representation: • a...

In eccc-cdo/SQLTypeR: Preserve R types in SQL

Description

Decompose a dataframe into the following representation:

• a dumbed-down version of the dataframe, where logicals are coerced to integers, and factors are coerced to strings.

• a meta dataframe containing the information necessary to recover the logicals and factors in the original dataframe. This operation is reversed by recomposeDF().

Usage

decomposeDF(df)

Arguments

df	The dataframe to decompose.

Examples

df <- tibble::tibble(
  a = factor(c("a", "a", "b"), levels = c("a", "b"), ordered = TRUE),
  b = c(TRUE, TRUE, FALSE),
  c = c(1,2,3)
 )

decomposeDF(df)

recomposeDF(decomposeDF(df))

eccc-cdo/SQLTypeR documentation built on March 23, 2020, 5:25 a.m.