Hi, Thanks for the different suggestions - Jorge, Erik, Marc, Ted and Phil. Thanks to you, I have learnt quite a few, for me new, tricks and methods. Thanks, Ravi ----- Original Message ---- From: Phil Spector <[EMAIL PROTECTED]> To: ravi <[EMAIL PROTECTED]> Cc: r-help@r-project.org Sent: Wednesday, 7 May, 2008 7:14:28 PM Subject: Re: [R] help with the unique function
Another way to produce the data frame is subset(as.data.frame(table(x)),Freq>0) - Phil Spector Statistical Computing Facility Department of Statistics UC Berkeley [EMAIL PROTECTED] On Wed, 7 May 2008, ravi wrote: > Hi, > The unique function is easy to understand and use. Beyond that, I want to get > also the frequency of repetition of each individual row in a data frame > Let me explain with an example : > x<-data.frame(a=c(1,2,3,1,2),b=c(2,3,4,2,3),c=c(10,20,30,10,20)) > xu<-unique(x) > We have, >> x > a b c > 1 1 2 10 > 2 2 3 20 > 3 3 4 30 > 4 1 2 10 > 5 2 3 20 >> xu > a b c > 1 1 2 10 > 2 2 3 20 > 3 3 4 30 > > I want to get the following data frame : > a b c Freq > 1 1 2 10 2 > 2 2 3 20 2 > 3 3 4 30 1 > That is, in addition to the unique rows, I want to get the frequency of > repetion of each individual row. > I will appreciate all the help that I can get. > Thank You, > Ravi > > ______________________________________________ > 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.
