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]]

On Tue, Sep 29, 2009 at 3:39 PM, Hari Easwaran <hariharan.pe at="" 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. Probably the simplest way is to merge the two data.frames first. See the merge() function. After merging, then do your reordering on the merged data.frame. Sean > 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 at stat.math.ethz.ch > https://stat.ethz.ch/mailman/listinfo/bioconductor > Search the archives: http://news.gmane.org/gmane.science.biology.informatics.conductor >