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