Tuesday, 4 February, 2020 13:32:20
> Subject: Re: [R] read_xlsx(readxl) apparently mangling some data input
> This may not be possible or practical, bit can you tell excel it's a
> character.
> The normal method of doing that is to add an ' at the front of the cell. So in
> Ex
8,8,10
> 2 45.65 9.129
>
> Cheers
> Petr
>
>> -Original Message-----
>> From: R-help On Behalf Of Chris Evans
>> Sent: Tuesday, February 4, 2020 1:07 PM
>> To: R-help Mailing List
>> Subject: [R] read_xlsx(readxl) apparently ma
Excel itself will store numeric data as numeric unless you explicitly say that
they are not. I.e., 9.13 gest stored in floating point, with the innate binary
rounding issues which you can also see from R
> print(9.13, digits=20)
[1] 9.1307816
> print(1.14, digits=20)
[1]
9
> as.data.frame(temp)
a1a2
1 12.008,8,10
2 45.65 9.129
Cheers
Petr
> -Original Message-
> From: R-help On Behalf Of Chris Evans
> Sent: Tuesday, February 4, 2020 1:07 PM
> To: R-help Mailing List
> Subject: [R] r
This is a very odd error I'm hitting using read_xlsx from the readxl package
(version 1.3.1) with R version 3.6.2 (2019-12-12) , platform
x86_64-pc-linux-gnu (and updated Ubuntu 18.04). I have some largeish Excel
spreadsheets that contain clinical data. I can't share the entire raw data but
I
5 matches
Mail list logo