normalizeDataframe: Data frame Normalization for Unit Tests

In XLConnect: Excel Connector for R

Data frame Normalization for Unit Tests

Description

Normalizes a data.frame with respect to column types. This is necessary for comparing data.frames written to Excel and then read from Excel. Excel does not know e.g. factor types. Factor variables in fact are written to Excel as ordinary strings. Therefore, when read back in to R, they are treated as character variables.

Usage

normalizeDataframe(df, replaceInf)

Arguments

df	data.frame to normalize
replaceInf	logical specifying if infinites should be replaced with NA; this is used because Excel does not support infinites

Value

Returns a normalized data.frame

Author(s)

Martin Studer
Mirai Solutions GmbH https://mirai-solutions.ch

XLConnect documentation built on Sept. 11, 2024, 8:04 p.m.