Let's call your two data frames 'probe.ordered.df' and 'chrom.ordered.df'.
Ordering the rows of the first to match the second:

reordered.df <- probe.ordered.df[ match(chrom.ordered.df$probename,
probe.ordered.df$probename), ]

Or you could do this in-place:

probe.ordered.df <-
probe.ordered.df[match(chrom.ordered.df$probename,probe.ordered.df$probename),]

Why not just use that first column as the row names for your intensity
matrix/dataframe?  Sorting is still easy:

reordered.df <- probe.ordered.df[ match(chrom.ordered.df$probename,
rownames(probe.ordered.df), ]

But things like imputation, PCA, etc. are a lot easier if you have a matrix
of numeric values (with perhaps some NAs mixed in).


On Tue, Sep 29, 2009 at 12:37 PM, Hari Easwaran <hariharan.pe@gmail.com>wrote:

> Hi all,
> I have another question with handling dataframes.
> I have a dataframe with the 1-st column as probenames (agilent) and the
> remaining columns are the intensity values from multiple samples. I want to
> order this table such that the order of the probenames correspond to the
> order of the genes on the chromosome. To do this I have another table which
> has teh probenames in this order.
> For example:
>
> probename           sample1          sample2          sample3
> sample4 ...
> a                              v11
> v12                    v13                  v14
> d                              v21
> v22                    v23                  v24
> b                              v31                        v32
>    v33                  v34
> c                               v41                       v42
>     v43                  v45
> e                               v51                        v52
>    v53                  v54
>
> I want the above table to be rearranged such that the 1st column is in the
> order a,b,c,d,e and the correspondig values (v11, v12, etc) are also
> appropriately rearranged.
>
> Thanks a lot for any help/suggestions.
>
> Sincerely,
> Hari
>
>        [[alternative HTML version deleted]]
>
> _______________________________________________
> Bioconductor mailing list
> Bioconductor@stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/bioconductor
> Search the archives:
> http://news.gmane.org/gmane.science.biology.informatics.conductor
>



-- 
Statisticians, like artists, have a bad habit of falling in love with their
models.
--George Box

	[[alternative HTML version deleted]]

