work with large numbers and decimals using R

Question

I am currently importing a csv file that contains huge positive numbers separated by decimals in a column tb <- read.csv("data.csv",dec = ";")

4,013,054,922
5,208,913,410
5,514,995,512
5,148,498,611
...

this data in R recognizes it as a character type and I cannot do operations

I have tried with

as.numeric(tb$large)
as.long(tb$large)
as.complex(tb$large)

but it returns rows with NA

and also try the gmp library too, to no avail

I appreciate your help

How about the seperator? If it is semicolon, try to add sep=“;” argument inside the function as well. — maydin, Jun 14 '20 at 17:38
I want to try the following `adf.test(tb$large)`,but since it is **char** it will not work — royer, Jun 14 '20 at 17:38
I think your data is an irregular one. I mean, inside the column that you considered as numeric, there exists a character hidden in a single row. So it makes the entire column non numeric. — maydin, Jun 14 '20 at 17:47
`as.numeric(gsub(',','','5,514,995,512'))` evaluates to `5514995512`. The numbers are not so large that something like `gmp` or (easier to use) `Rmpfr` is needed. — John Coleman, Jun 14 '20 at 17:53

score 4 · Accepted Answer · answered Jun 14 '20 at 17:53

4

Is this what you are looking for?

d <-  c('4,013,054,922','5,208,913,410',
       '5,514,995,512',
       '5,148,498,611')

class(d)
#> [1] "character"
library(stringr)
as.numeric(str_remove_all(d, ','))
#> [1] 4013054922 5208913410 5514995512 5148498611

^{Created on 2020-06-14 by the reprex package (v0.3.0)}

answered Jun 14 '20 at 17:53

MarBlo

4,195
1
13
27

1

or `as.numeric(gsub(',','',d))` if you want to stay with base R functions – Ben Bolker Jun 14 '20 at 17:55

work with large numbers and decimals using R

1 Answers1