[datatable-help] fread (boolean?) problem in 1.8.11 rev 971

Matthew Dowle mdowle at mdowle.plus.com
Fri Sep 20 20:40:47 CEST 2013


Hi,
Many thanks. Now fixed - commit 973.
Matthew

On 20/09/13 18:16, Simon Biggs wrote:
> Hi
>
> I'm finding data.table excellent for processing of significant numbers 
> of large files. Trying out the latest build I'm seeing some problems 
> (perhaps around the new boolean support?)
>
> Loading my file with a basic call to fread() results in the error:
>
> Error in fread("file.txt") :
>    Expected sep ('	') but 'T' ends field 25 on line 2 when detecting types: 8878	1	1	24	4	AFY057250G12	NA	2012-07-01	2013-06-30	1e+05	49999100.7232666	1.58e+08	0	33176.21	978	NA	1	EUR	0	EUR	0	EUR	TERRINC	HXG	T
>
> Happy to provide the full file if you let me know how.  First couple 
> of rows reproduced below (file is tab delimited):
>
> Key Id AKey PKey Peril PNum LName EDt ExDt PAPt PL PPof PD Prem CurrencyKey RK IsV CurrencyCd minDedAmt minDedCur maxDedAmt maxDedCur userIdTxt1 userIdTxt2 userIdTxt3 userIdTxt4 PStat
> 8878 1 1 24 4 AFY05 NA 2012-07-01 2013-06-30 1e+05 49999100.7232666 1.58e+08 0 33176.21 978 NA 1 EUR 0 EUR 0 EUR TERRINC HXG T TO NA
> 8878 1 3 93 4 AFJ02 NA 2012-03-31 2014-03-30 150000 3.5e+07 1.4e+08 0 3688.44 840 NA 1 USD 0 USD 0 USD TERRINC JGP T TO NA
> 8878 1 6 95 4 AFY08 NA 2012-04-08 2013-04-07 1e+05 29999983.4435654 336907000 0 0 826 NA 1 GBP 0 GBP 0 GBP TERRINC SPT T TU NA
> 8878 1 7 17 4 AFR1 NA 2012-07-12 2013-06-30 7500000 5e+07 5e+08 0 10319.34 840 NA 1 USD 0 USD 0 USD TERREXC JGP T TO NA
>
> Many thanks for your efforts
>
> Simon
>
>
> _______________________________________________
> datatable-help mailing list
> datatable-help at lists.r-forge.r-project.org
> https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.r-forge.r-project.org/pipermail/datatable-help/attachments/20130920/56589e39/attachment.html>


More information about the datatable-help mailing list