R help - May 2010 - ordering data frame

Hi all,

I have problem in ordering data frame. Could anyone help me?
> x
     [,1] [,2] [,3]
[1,] "A"  "1"  "2"
[2,] "G"  "3"  "2"
[3,] "E"  "2"  "3"
> y
     [,1] [,2] [,3]
[1,] "G"  "3"  "3"
[2,] "A"  "3"  "3"
[3,] "E"  "3"  "3"

I would like to order data frame x by the order of column 1 of data frame y,
as follow,

     [,1] [,2] [,3]
[1,] "G"  "3"  "2"
[2,] "A"  "1"  "2"
[3,] "E"  "2"  "3"


Thanks,
Phoebe

	[[alternative HTML version deleted]]

phoebe kong wrote:
> Hi all,
> 
> I have problem in ordering data frame. Could anyone help me?
> 
>> x
>      [,1] [,2] [,3]
> [1,] "A"  "1"  "2"
> [2,] "G"  "3"  "2"
> [3,] "E"  "2"  "3"
> 
>> y
>      [,1] [,2] [,3]
> [1,] "G"  "3"  "3"
> [2,] "A"  "3"  "3"
> [3,] "E"  "3"  "3"
Are these really data.frames? They looks like matrices. You do not 
provide ?dput output.
> 
> I would like to order data frame x by the order of column 1 of data frame
y,
> as follow,
> 
>      [,1] [,2] [,3]
> [1,] "G"  "3"  "2"
> [2,] "A"  "1"  "2"
> [3,] "E"  "2"  "3"
> 
My example uses data.frames.  ?match and ?order are the important functions.

df1 <- data.frame(a = sample(LETTERS[1:5]), b = rnorm(5))
df2 <- data.frame(a = sample(LETTERS[1:5]), b = rnorm(5))

df1[order(match(df1$a, df2$a)), ]







> 
> Thanks,
> Phoebe
> 
> 	[[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.