RowSel <-c(0,1,0,1,2,3,0,5,5) set.seed(24) DF<- as.data.frame(matrix(sample(1:40,45,replace=TRUE),ncol=5)) RowSel[!as.logical(RowSel)]<-NA DF[RowSel,] # V1 V2 V3 V4 V5 #NA NA NA NA NA NA #1 12 11 21 24 30 #NA.1 NA NA NA NA NA #1.1 12 11 21 24 30 #2 9 25 6 26 26 #3 29 15 4 2 28 #NA.2 NA NA NA NA NA #5 27 27 30 10 19 #5.1 27 27 30 10 19
A.K. ----- Original Message ----- From: Bert Jacobs <bert.jac...@figurestofacts.be> To: r-help@r-project.org Cc: Sent: Saturday, June 8, 2013 7:09 AM Subject: [R] Add blank rows to a dataframe Hi, I have a vector that looks like this: RowSel <-c(0,1,0,1,2,3,0,5,5) Now I want to select rows from a specific dataframe DF based on that vector like this: SubDF <- DF[RowSel,] So this works fine, but I was wondering how I could add blank rows add the locations in the vector where there is a zero: So the final dataframe should look like this: SubDF [1] blank row [2] row 1 [3] blank row [4] row 1 [5] row 2 [6] row 3 [7] blank row [8] row 5 [9] row 5 Do I have to use a loop for this or does there exist a straight forward function option. Thx, Bert ______________________________________________ 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. ______________________________________________ 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.
