[R] read.table only reads part of file

Peter Langfelder peter.langfelder at gmail.com
Sat Jul 30 02:54:10 CEST 2011


Hi all,

I encountered a problem when trying to read in an Illumina chip
annotation file. The offending file is large, so I zipped it up and
posted it at

http://www.genetics.ucla.edu/labs/horvath/CoexpressionNetwork/tmp/ProbeInfo_Expression.txt.bz2

Executing this:

annot = read.table(bzfile("ProbeInfo_Expression.txt.bz2"),
                comment.char="",  sep = "\t", fill = TRUE, header = TRUE);

leads to

> dim(annot)
[1] 25952    28

i.e. 25952 rows were read, but the file is some 48000 rows long.

The file contains long text entries (up to several thousand
characters) which appear to be the problem since stripping out those
columns (outside of R) and re-reading gives he full 48k+ rows.

My question is why is read.table stopping the read (without any
warning or error)? Am I missing something in the documentation (read
it but didn't find anything). Any arguments I'm not setting right? I
tried to google the problem but came up empty-handed.

Session info:

> sessionInfo()
R version 2.11.1 Patched (2010-06-06 r52218)
i686-pc-linux-gnu

locale:
 [1] LC_CTYPE=en_US.utf8       LC_NUMERIC=C
 [3] LC_TIME=en_US.utf8        LC_COLLATE=en_US.utf8
 [5] LC_MONETARY=C             LC_MESSAGES=en_US.utf8
 [7] LC_PAPER=en_US.utf8       LC_NAME=C
 [9] LC_ADDRESS=C              LC_TELEPHONE=C
[11] LC_MEASUREMENT=en_US.utf8 LC_IDENTIFICATION=C

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base


Thanks,

Peter



More information about the R-help mailing list