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.
normalizeDataframe(df, replaceInf)Returns a normalized data.frame
data.frame to normalize
logical specifying if infinites should be replaced with NA; this is used
because Excel does not support infinites
Martin Studer
Mirai Solutions GmbH https://mirai-solutions.ch