Try this

c1[, match(c2[, "type1"], names(c1), nomatch=0)]

Jean


`·.,,  ><(((?>   `·.,,  ><(((?>   `·.,,  ><(((?>

Jean V. Adams
Statistician
U.S. Geological Survey
Great Lakes Science Center
223 East Steinfest Road
Antigo, WI 54409  USA





From:
ראובן אברמוביץ <gantkant@walla.com>
To:
<r-help@r-project.org>
Date:
07/28/2011 09:03 AM
Subject:
[R] sorting data from dataframe with oter dataframe
Sent by:
r-help-bounces@r-project.org




   Hi, the subject isn't define well the problem, so i'll explain it in 
detail:

   i've got a csv.file with data on number of factors (every column got 
the
   name

   of the factor as header and the data below). on another csv file, i've 
got
   the

   factors sorted by their type. for example-


c1=read.csv('C:/R/c1.csv', header= TRUE)

   urrDate    A_XS    b_XS  c_XS  d_XS  e_XS
   1       01/01/1996 0    0.0000 0    0.0000 2.7220
   2       02/01/1996 0    2.3232 0    2.2960 2.7179
   3       03/01/1996 0    2.3368 0    2.3087 2.7004
   4       04/01/1996 0    2.3395 0    2.3173 2.6821
   5       07/01/1996 0    2.3226 0    2.3072 2.6852
   6       08/01/1996 0    2.3385 0    2.3067 2.7008
   7       09/01/1996 0    2.3290 0    2.2960 2.6793
   8       10/01/1996 0    2.3206 0    2.2907 2.6843
   9       11/01/1996 0    2.3292 0    2.2845 2.6978
   10      14/01/1996 0    2.3211 0    2.2926 2.6844
   11      15/01/1996 0    2.3184 0    2.2863 2.6810
   12      16/01/1996 0    2.3253 0    2.2880 2.6623
   13      17/01/1996 0    2.3119 0    2.2779 2.6486
   14      18/01/1996 0    2.3113 0    2.2844 2.6299
   15      21/01/1996 0    2.3043 0    2.2907 2.6227
   16      22/01/1996 0    2.2855 0    2.2819 2.6150
   17      23/01/1996 0    2.2936 0    2.2821 2.6392
   18      24/01/1996 0    2.3068 0    2.2883 2.6229
   19      25/01/1996 0    2.3056 0    2.2837 2.6427
   20      28/01/1996 0    2.3271 0    2.2904 2.6293
   21      29/01/1996 0    2.3281 0    2.2796 2.5885
   22      30/01/1996 0    2.3300 0    2.2774 2.5972
   23      31/01/1996 0    2.3377 0    2.2712 2.5824


c2=read.csv('C:/R/c2.csv', header= TRUE, fill=TRUE)

 
   type1 type2
 1 A_XS c_XS
 2 b_XS d_XS
 3   e_XS


   my question is how do I sort data from C1 with the headers of C2? which
   means if i'll write "type1" i'll get the data of A_XS and B_XS

     _________________________________________________________________

   Walla! Mail - [1]Get your free unlimited mail today

References

   1. http://www.walla.co.il/
______________________________________________
R-help@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.




	[[alternative HTML version deleted]]

