Tammy,
You won't get more help if you post this again every half an hour... I don't quite understand what you exactly want to do, but it seemed at
least to me that Keith's suggestion (see again below) pretty much does what you want. If not, could you please specify *EXACTLY* what you
want to do. Thanks!
Annette
From: Keith Jewell <k.jewell_at_campden.co.uk>
Date: Tue, 17 Mar 2009 12:23:34 +0000
Is this what you want it to do? (aDF is the original data frame)
aDF
V1 V2 V3 V4
1 2006-02-22 16:28:18 useractivity_act 8 0
2 2006-02-22 16:28:26 4 2 0
3 2006-02-22 16:28:28 3 3 0
4 2006-02-22 16:28:31 4 4 1
5 2006-02-22 16:28:35 3 159 0
6 2006-02-22 16:31:14 useractivity_idle 0 0
7 2006-02-22 16:28:18 useractivity_act 8 0
8 2006-02-22 16:28:26 4 2 0
9 2006-02-22 16:28:28 3 3 0
10 2006-02-22 16:28:31 4 4 0
11 2006-02-22 16:28:35 3 159 25
12 2006-02-22 16:31:14 useractivity_idle 0 0
with(aDF, aggregate(V4, by=list(V1, V2, V3), sum))
Group.1 Group.2 Group.3 x
1 2006-02-22 16:31:14 useractivity_idle 0 0
2 2006-02-22 16:28:26 4 2 0
3 2006-02-22 16:28:28 3 3 0
4 2006-02-22 16:28:31 4 4 1
5 2006-02-22 16:28:18 useractivity_act 8 0
6 2006-02-22 16:28:35 3 159 25
hth
Keith J
Tammy Ma schrieb:
I still couldn't solve it........any help would be preciated!
Tammy
From: metal_lical...@live.com
To: r-help@r-project.org
Date: Tue, 17 Mar 2009 11:49:10 +0200
Subject: [R] Merging
Hi, All.
I have a data frame with the part as :
.....
142 2006-02-22 16:28:18 useractivity_act 8 0
143 2006-02-22 16:28:26 4 2 0
144 2006-02-22 16:28:28 3 3 0
145 2006-02-22 16:28:31 4 4 1
146 2006-02-22 16:28:35 3 159 0
147 2006-02-22 16:31:14 useractivity_idle 0 0
1421 2006-02-22 16:28:18 useractivity_act 8 0
1431 2006-02-22 16:28:26 4 2 0
1441 2006-02-22 16:28:28 3 3 0
1451 2006-02-22 16:28:31 4 4 0
1461 2006-02-22 16:28:35 3 159 25
1471 2006-02-22 16:31:14 useractivity_idle 0 0
....
I want to merge the above as
142 2006-02-22 16:28:18 useractivity_act 8 0
143 2006-02-22 16:28:26 4 2 0
144 2006-02-22 16:28:28 3 3 0
145 2006-02-22 16:28:31 4 4 1
146 2006-02-22 16:28:35 3 159 25
147 2006-02-22 16:31:14 useractivity_idle 0 0
How should I do`??
Thanks.
Tammy
--
Annette Heisswolf
Section of Ecology
Department of Biology
University of Turku
20014 Turku, Finland
______________________________________________
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.
