it seems it will work, however, the last line of code did not work, so I can
not check the results.
thanks,
jholtman wrote
>
> try this by reformatting the data and then reading back in:
>
>
>> x <- readLines(textConnection("TABLE NO. 1
> + ID TIME
> + 1325 0
> + 1325 0
> + TABLE NO. 1
> + ID TIME
> + 1325 0
> + 1325 0
> + TABLE NO. 1
> + ID TIME
> + 1325 0
> + 1325 0
> + TABLE NO. 1
> + ID TIME
> + 1325 0
> + 1325 0"))
>>
>> # remove "TABLE"
>> x <- x[-grep("^TABLE", x)]
>>
>> # remove all but first "ID"
>> x <- x[-grep("^ID", x)[-1]]
>>
>> # now create temporary file with the data to re-read
>> fileName <- tempfile()
>> writeLines(x, fileName)
>>
>> # now read in the data
> />* read.table(fileName, header = TRUE)*/
>
> ID TIME
> 1 1325 0
> 2 1325 0
> 3 1325 0
> 4 1325 0
> 5 1325 0
> 6 1325 0
> 7 1325 0
> 8 1325 0
>>
>>
>
>
> On Wed, Jun 20, 2012 at 10:08 AM, york8866 <yu_york@> wrote:
>> I have a table like the following:
>>
>> TABLE NO. 1
>> ID TIME
>> 1325 0
>> 1325 0
>> . .
>> . .
>> . .
>> TABLE NO. 1
>> ID TIME
>> 1325 0
>> 1325 0
>> . .
>> . .
>> . .
>> TABLE NO. 1
>> ID TIME
>> 1325 0
>> 1325 0
>> . .
>> . .
>> . .
>> TABLE NO. 1
>> ID TIME
>> 1325 0
>> 1325 0
>> . .
>> . .
>> . .
>>
>> I used the following code:
>> sim <- read.table("sim.tab", skip=1, as.is=T,header=T)
>> it did not work, as there're rows with characters in between the data.
>> Can anyone help me to read the table, while get rid of the character rows
>> in
>> between the data?
>> thanks,
>>
>> --
>> View this message in context:
>> http://r.789695.n4.nabble.com/can-not-read-a-table-tp4633971.html
>> Sent from the R help mailing list archive at Nabble.com.
>>
>> ______________________________________________
>> R-help@ 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.
>
>
>
> --
> Jim Holtman
> Data Munger Guru
>
> What is the problem that you are trying to solve?
> Tell me what you want to do, not how you want to do it.
>
> ______________________________________________
> R-help@ 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.
>
--
View this message in context:
http://r.789695.n4.nabble.com/can-not-read-a-table-tp4633971p4633994.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
R-help@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.
