[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