[R] read tab delimited file from a certain line

[Christof Kluß]

Hi Henrik,

that's perfect, thanks!

Greetings
Christof

Am 18-01-2013 19:26, schrieb Henrik Bengtsson:
> 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")
>
> /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.
>