convertDBtoDF: Does the reverse of convertDFtoDB: converts a data.frame of...

View source: R/dbAccess.R

convertDBtoDFR Documentation

Does the reverse of convertDFtoDB: converts a data.frame of converted data back to its original data.frames. Each row from the provided data.frame (df) is converted to a separate data.frame

Description

Does the reverse of convertDFtoDB: converts a data.frame of converted data back to its original data.frames. Each row from the provided data.frame (df) is converted to a separate data.frame

Usage

convertDBtoDF(
  df,
  columnNames = colnames(df),
  restoreClasses = FALSE,
  collapseChar = ";",
  vectorClass = "integer",
  fromBlob = TRUE,
  type = "gzip"
)

Arguments

df

data.frame to be converted

columnNames

character vector specifying which columns from the df argument are to be put in the converted data.frame(s)

restoreClasses

default is FALSE. IF TRUE then the first row of the data.frame argument (df) must contain the classes (as character vectors) to be used for the columns

collapseChar

the character to be used as seperator

vectorClass

class of the seperate elements, default = "integer". Other tested options are "numeric" and "character". Note: all columns are the same class when vectorClass is a single element vector. The argument can be different types, but then all column types need to be specified, eg c("numeric", "integer")

fromBlob

is the data raw datatype or not

type

character string, the type of compression. See ?memCompress for details

Value

a data.frame


BenBruyneel/BBPersonalR documentation built on Aug. 23, 2024, 8:28 p.m.