[R] question (and a suggestion)
Gabor Grothendieck
ggrothendieck at myway.com
Wed Nov 19 16:45:05 CET 2003
This question repeatedly comes up, e.g. see
https://www.stat.math.ethz.ch/pipermail/r-help/2003-November/040184.html
https://www.stat.math.ethz.ch/pipermail/r-help/2003-November/040348.html
from less than two weeks ago.
One thing that occurred to me is that the answer could be simplified
if skip= could take a 2-vector argument such that:
read.table("x.dat", skip=grep("start|end",readLines("x.dat")), head=T)
reads in the data. We already have nrows= but it deals with logical
lines whereas skip= deals with physical lines making it harder to
handle, particularly when blank lines are thrown away.
An even more powerful facility would be to allow the elements of
the 2-vector to be either as above or regular expressions. In
the latter case, one could simply write:
read.table("x.dat", skip=c("start","end"), head=T)
which has the added benefit of not reading the data twice. Of
course, there are numerous other possibilities for embedding data
in a text file that this does not handle but, based on the postings
to the list, this does seem to be the common one not already
easily handled by read.table.
---
Date: Wed, 19 Nov 2003 10:32:39 +0100
From: Fuensanta Saura Igual <igual at mat.uji.es>
To: <R-help at stat.math.ethz.ch>
Subject: [R] question
Does anyone know how I can read from a .txt file the lines that are between
two strings whose location is unknown?
My problem is that I have a .txt file with data separated by a sentence,
for example:
2.22 3.45
1.56 2.31
pattern 1
4.67 7.91
3.34 2.15
5.32 3.88
pattern 2
...
I do not know the number of lines where these separating sentences are located,
because the number of lines in between them can be random. If it was fixed, I
think I could use "read.table" using the option "skip", but in this case, I do
not know how I could manage to do that automatically.
Thanks.
______________________________________________
R-help at stat.math.ethz.ch mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help
More information about the R-help
mailing list