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 <[email protected]> To: [email protected] 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]] ______________________________________________ [email protected] 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. ______________________________________________ [email protected] 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.
