[R] fread transforms numbers

Jeff Newmiller jdnewmil at dcn.davis.ca.us
Wed Mar 22 17:58:36 CET 2017


You failed to provide a reproducible example, and you posted HTML so the quality of any answer will be limited by the quality of your question.

My stab at your problem is that you should read ?fread, and in particular should try using the colClasses argument.
-- 
Sent from my phone. Please excuse my brevity.

On March 22, 2017 8:52:55 AM PDT, Santosh <santosh2005 at gmail.com> wrote:
>Hi
>
>I have been using "fread" utility of "data.table" packge .. on a
>dataset of
>about 20 million rows. It's a fantastic package to read datasets. Thank
>you, Matt D.
>
>However, I am faced with a peculiar instance of  certain numbers in a
>column being transformed.
>
>In the dataset, a column has values ranging from 1 to 9##########
>(nchar(x)=11, e.g. 98765432109). After using "fread" to read the
>dataset,
>values in all the columns are displayed correctly upto the first 1000
>rows.
>If "fread" is applied for reading >1000 rows of  the total of 20Million
>rows, the values in only this (column (having wide range of values) are
>displayed as x.xxxxxxxe-3yy. (e.g. 3.5639877e-324)
>
>I tried reading all the columns as "character" and didn't help.
>
>Would highly appreciate your assistance!
>
>Thanks so much in advance.
>
>Best regards,
>Santosh
>
>	[[alternative HTML version deleted]]
>
>______________________________________________
>R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
>https://stat.ethz.ch/mailman/listinfo/r-help
>PLEASE do read the posting guide
>http://www.R-project.org/posting-guide.html
>and provide commented, minimal, self-contained, reproducible code.



More information about the R-help mailing list