Leon Yee
2010-Aug-16 03:47 UTC
[R] re-order the rows of a data frame accroding to a specified order of some column
Dear all,
I have a data frame with several columns, and I have the specified
order of a given column. How can I re-order the rows of my data frame
accroding to this specified order? for example,
x = data.frame( num = 1:26, alpha = letters[1:26], stringsAsFactors=FALSE)
z = sample(x$alpha, replace=FALSE)
Can I re-order x accroding to z ?
Thanks,
Leon
[[alternative HTML version deleted]]
RICHARD M. HEIBERGER
2010-Aug-16 04:36 UTC
[R] re-order the rows of a data frame accroding to a specified order of some column
Yes, x[order(order(z)),] Two uses of order are needed, as shown. Rich On Sun, Aug 15, 2010 at 11:47 PM, Leon Yee <yee.leon@gmail.com> wrote:> Dear all, > > I have a data frame with several columns, and I have the specified > order of a given column. How can I re-order the rows of my data frame > accroding to this specified order? for example, > > x = data.frame( num = 1:26, alpha = letters[1:26], stringsAsFactors=FALSE) > z = sample(x$alpha, replace=FALSE) > Can I re-order x accroding to z ? > > Thanks, > > Leon > >[[alternative HTML version deleted]]
l.mohammadikhankahdani
2010-Aug-16 13:10 UTC
[R] re-order the rows of a data frame accroding to a specified order of some column
You can also write x[match(z,x[,2]),]. Leila on 2010/08/16 06:36 AM RICHARD M. HEIBERGER said the following:> Yes, > > x[order(order(z)),] > > > Two uses of order are needed, as shown. > > > Rich > > > On Sun, Aug 15, 2010 at 11:47 PM, Leon Yee <yee.leon at gmail.com> wrote: > >> Dear all, >> >> I have a data frame with several columns, and I have the specified >> order of a given column. How can I re-order the rows of my data frame >> accroding to this specified order? for example, >> >> x = data.frame( num = 1:26, alpha = letters[1:26], stringsAsFactors=FALSE) >> z = sample(x$alpha, replace=FALSE) >> Can I re-order x accroding to z ? >> >> Thanks, >> >> Leon >> >> > > [[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.