[datatable-help] Odd problem using fread to read in a csv file: no data, just headers
Farrel Buchinsky
fjbuch at gmail.com
Thu Mar 6 04:53:20 CET 2014
Any idea why I am getting a data.table with headers only and zero data? How
can I get around the problem.
fread("http://www.cdc.gov/growthcharts/data/zscore/statage.csv", verbose=T)
fails
read.csv("http://www.cdc.gov/growthcharts/data/zscore/statage.csv") succeeds
> statagecdc <- fread("
http://www.cdc.gov/growthcharts/data/zscore/statage.csv", verbose=T)
trying URL 'http://www.cdc.gov/growthcharts/data/zscore/statage.csv'
Content type 'application/octet-stream' length 66087 bytes (64 Kb)
opened URL
downloaded 64 Kb
Input contains no \n. Taking this to be a filename to open
File opened, filesize is 6.2E-05B
File is opened and mapped ok
Detected eol as \r only (no \n afterwards). An old Mac 9 standard,
discontinued in 2002 according to Wikipedia.
Using line 1 to detect sep (the last non blank line in the first
'autostart') ... sep=','
Found 14 columns
First row with 14 fields occurs on line 1 (either column names or first row
of data)
All the fields on line 1 are character fields. Treating as the column names.
Byte after header row is eof or eol, 0 data rows present.
Type codes: 00000000000000 (first 5 rows)
Type codes: 00000000000000 (after applying colClasses and integer64)
Type codes: 00000000000000 (after applying drop or select (if supplied)
Allocating 14 column slots (14 - 0 NULL)
0.000s ( 0%) Memory map (rerun may be quicker)
0.000s ( 0%) sep and header detection
0.001s (100%) Count rows (wc -l)
0.000s ( 0%) Column type detection (first, middle and last 5 rows)
0.000s ( 0%) Allocation of 0x14 result (xMB) in RAM
0.000s ( 0%) Reading data
0.000s ( 0%) Allocation for type bumps (if any), including gc time if
triggered
0.000s ( 0%) Coercing data already read in type bumps (if any)
0.000s ( 0%) Changing na.strings to NA
0.001s Total
Thanks a lot.
Farrel Buchinsky
Google Voice Tel: (412) 567-7870
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.r-forge.r-project.org/pipermail/datatable-help/attachments/20140305/97c7fc99/attachment.html>
More information about the datatable-help
mailing list