Displaying 1 result from an estimated 1 matches for "xldata".
Did you mean:
xdata
2024 Jul 14
2
Reinterpret data without saving it to a file 1st? Check for integer stopping at 1st decimal?
...aving the spreadsheet content into a CSV then loading that, which
works like a charm ; the chr columns are the same but now a large portion
of num is now instead int. Is there a way to skip writing and reading a CSV
and get the same transformation? Perhaps some way to break the spreadsheet
data (eg XLdata <- read_excel(...)), then put it back together without any
writing to a file (eg XLdataReformed <- reform(XLdata)) ?
In addition, from is.integer() documentation I ran
> is.wholenumber <- function(x, tol = .Machine$double.eps^0.5) abs(x - round
> (x)) < tol
and I'm now tryi...