Message-ID: <3218139C-937C-4724-9925-FABE98D0D65B@comcast.net>
Date: 2013-01-18T20:11:48Z
From: David Winsemius
Subject: read tab delimited file from a certain line
In-Reply-To: <CAFDcVCRNq2H84sp5xEBhEtM8cZg9YEeHO55b1NkaJ7xidx9WqA@mail.gmail.com>
On Jan 18, 2013, at 10:26 AM, Henrik Bengtsson wrote:
> Christof,
>
> I've added support for this to the R.filesets package. In your case,
> then all you need to do is:
>
> library("R.filesets")
> dlf <- readDataFrame(filename, skip="^year")
>
> No need to specify any other arguments - they're all automagically
> inferred - and the default is stringsAsFactors=FALSE.
>
> This is in R.filesets v2.0.0 which I still haven't published on CRAN.
> In the meanwhile, you can install it via:
>
> source("http://aroma-project.org/hbLite.R")
> hbLite("R.filesets")
Mac GUI users should exit to a Terminal session running R --vanilla before attempting this. (Probably a safer practice in general, but sometimes we get get lazy because the GUI Package Installer is so handy.)
--
David.
>
> /Henrik
>
> On Thu, Jan 17, 2013 at 1:34 AM, Christof Klu? <ckluss at email.uni-kiel.de> wrote:
>> Hello
>>
>> thank you for the fast and helpful answer! Now the following works fine for
>> me
>>
>> x <- readLines(filename)
>>
>> i <- grep("^year", x)
>> dlf <- read.table(textConnection(x[i:length(x)]),
>> header = T, stringsAsFactors=F,sep="\t")
>>
>> Greetings
>> Christof
>>
>>
>> Am 16-01-2013 16:55, schrieb Rui Barradas:
>>
>>> Hello,
>>>
>>> Read the file using readLines, then grep "^year". You can then use a
>>> textConnection to read.table:
>>>
>>> x <- readLines(con = textConnection(
>>> "informations (unknown count of lines)
>>> ... and at some point the table
>>> ------
>>> year month mday value
>>> 2013 1 16 0 "))
>>>
>>> # This is it
>>> i <- grep("^year", x)
>>> read.table(textConnection(x[i:length(x)]), header = TRUE)
>>>
>>>
>>> Hope this helps,
>>>
>>> Rui Barradas
>>>
>>> Em 16-01-2013 14:17, Christof Klu? escreveu:
>>>>
>>>> Hi
>>>>
>>>> I would like to read table data from a text-files with extra
>>>> informations in the header (of unknown line count). Example:
>>>>
>>>> informations (unknown count of lines)
>>>> ... and at some point the table
>>>> ------
>>>> year month mday value
>>>> 2013 1 16 0
>>>> ...
>>>>
>>>> If it was an excel file I could use something like read.xls(...,
>>>> pattern="year") But it is a simple tab seperated text-file. Is there
>>>> an easy way to read only the table? (Without dirty things ;))
>>>>
>>>> Thx
>>>> Christof
>>>>
>>>> ______________________________________________
>>>> R-help at r-project.org mailing list
>>>> 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.
>>>
>>>
>>
>> ______________________________________________
>> R-help at r-project.org mailing list
>> 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.
>
> ______________________________________________
> R-help at r-project.org mailing list
> 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.
David Winsemius
Alameda, CA, USA