[R] Subsetting a group of data

[arun]

Hi,
You can also try this:
dat1 <- read.table(text="
Cola       Colb
1              1              1
2              1              1
3              1              1
4              -1            1
5              -1            -1
6              -1            -1
7              1              -1
8              -1            -1
9              -1            -1
10           -1            -1
", header=TRUE)

idx<- c(0,cumsum(abs(diff(dat1$Cola))))-as.integer(dat1$Cola!=dat1$Colb)
 split(dat1,idx)

A.K.

----- Original Message -----
From: Ian Arvin <ian at innovativequant.com>
To: r-help at r-project.org
Cc: 
Sent: Thursday, October 4, 2012 10:20 AM
Subject: [R] Subsetting a group of data

Hi,


I am making my way down the learning curve of R, and find it a great
language with so many helpful users!

Below is an example of what I'm trying to do, but can't quite figure out the
right path to go down.



Here's what I have:



Main is a time series of data with columns Cola and Colb

                Cola       Colb

1              1              1

2              1              1

3              1              1

4              -1            1

5              -1            -1

6              -1            -1

7              1              -1

8              -1            -1

9              -1            -1

10           -1            -1



What I would like is to subset the data into groups -  rows 1-3 into one
group (Cola and Colb both =1), then row 4 by itself, then rows 5-6, then row
7, then rows 8-10.

Group 1

                Cola       Colb

1              1              1

2              1              1

3              1              1



Group 2

                Cola       Colb

1              -1            1



Group 3

                Cola       Colb

1              -1            -1

2              -1            -1



Thank you for your help!



Ian






    [[alternative HTML version deleted]]

______________________________________________
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.