Re: [R] For Loop help needed

2010-06-04 Thread Allan Engelhardt
On 04/06/10 10:32, Petr PIKAL wrote: One option: t<- data.frame(x1=c(1,1,0,0,0,1), x2=c(0,0,0,1,0,1), Count=c(523,23,2,45,3,433)) t.sum<- function(df, x1, x2) sum(df[df$x1==x1& df$x2==x2,]$Count) [...] If this is what Khan wants so aggregate(t$Count, list(interaction(t$x1, t$x2)), sum) Gro

Re: [R] For Loop help needed

2010-06-04 Thread Petr PIKAL
Hi r-help-boun...@r-project.org napsal dne 03.06.2010 18:18:33: > One option: > > t <- data.frame(x1=c(1,1,0,0,0,1), x2=c(0,0,0,1,0,1), > Count=c(523,23,2,45,3,433)) > t.sum <- function(df, x1, x2) sum(df[df$x1==x1 & df$x2==x2,]$Count) > t.sum(t, 1, 0) > # [1] 546 > t.sum(t, 0, 0) > # [1] 5 If

Re: [R] For Loop help needed

2010-06-03 Thread Jorge Ivan Velez
Hi Geeti, If d is your data.frame, the following is an option: as.data.frame.table(with(d, tapply(Count, list(x1, x2), sum))) HTH, Jorge On Thu, Jun 3, 2010 at 11:18 AM, Geeti Khan <> wrote: > Hi, > I have a dataset with three column like this > x1 x2 Count > 1 0 523 > 1 0 23 > 0 0 2 > 0 1

Re: [R] For Loop help needed

2010-06-03 Thread Allan Engelhardt
One option: t <- data.frame(x1=c(1,1,0,0,0,1), x2=c(0,0,0,1,0,1), Count=c(523,23,2,45,3,433)) t.sum <- function(df, x1, x2) sum(df[df$x1==x1 & df$x2==x2,]$Count) t.sum(t, 1, 0) # [1] 546 t.sum(t, 0, 0) # [1] 5 Hope this helps a little. Allan On 03/06/10 16:18, Geeti Khan wrote: Hi, I have a

[R] For Loop help needed

2010-06-03 Thread Geeti Khan
Hi, I have a dataset with three column like this x1 x2 Count 1 0 523 1 0 23 0 0 2 0 1 45 0 0 3 1 1 433 I need to create a loop so that when c(x1,x2)=c(1,1), I can add the corresponding Counts.When c(x1,x2)=c(1,0), can add the corresponding counts and so on. Can anyone help me