[R] Data manipulation in a data.frame

arun smartpink111 at yahoo.com
Fri Feb 21 01:19:09 CET 2014


Also,
rownames(which(t(!!A[,-1]),arr.ind=TRUE))
A.K.




On Thursday, February 20, 2014 6:48 PM, arun <smartpink111 at yahoo.com> wrote:
Hi,
May be this helps:

A$Variable <- rep(colnames(A[,-1]),nrow(A))[t(!!A[,-1])]
A.K.



On Thursday, February 20, 2014 5:55 PM, ioanna ioannou <ii54250 at msn.com> wrote:
Hello,





Assuming that I have a data frame 

A<-data.frame(A=c(10,100,1000,30,50,60,300),

              B=c(0,1,1,1,0,0,0),                        

              C=c(0,0,0,0,1,1,0),

              D=c(1,0,0,0,0,0,1))



What I would like is to introduce a new column Variable such that:



A<-data.frame(A=c(10,100,1000,30,50,60,300),

              B=c(0,1,1,1,0,0,0),                        

              C=c(0,0,0,0,1,1,0),

              D=c(1,0,0,0,0,0,1),

       Variable=c(D,B,B,B,C,C,D)) 



How can I do it?



Best 

IOanna


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





More information about the R-help mailing list