[R] Reshape dataframe according to ordered variables

MORNEAU François francois.morneau at ifn.fr
Thu Mar 18 16:36:52 CET 2010


Hello Duarte,
It seems that "order" is what you are looking for :
df <- df[order(df$id, df$ord), ] 
Regards,
François

-----Message d'origine-----
De : r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org] De la part de Duarte Viana
Envoyé : jeudi 18 mars 2010 16:27
À : r-help
Objet : [R] Reshape dataframe according to ordered variables

Dear all,

I am still a R apprentice... Apologies for the basic question.
I am trying to reshape a dataframe based on the order of two variables
(a character variable and a numerical variable). To simplify it,
consider the following dataframe

> df<-data.frame(id=c("b","b","a","a","a"),ord=c(2,1,1,3,2))

  id ord
1  b   2
2  b   1
3  a   1
4  a   3
5  a   2

I want to reshape it such that it results in this dataframe ("id"
alphabetically ordered and ranked according to the "ord" order)

df1<-data.frame(id=c("a","a","a","b","b"),ord=c(1,2,3,1,2))

  id ord
1  a   1
2  a   2
3  a   3
4  b   1
5  b   2

Thanks in advance,

Duarte Viana

______________________________________________
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