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 this is what Khan wants so aggregate(t$Count, list(interaction(t$x1, t$x2)), sum) Group.1 x 1 0.0 5 2 1.0 546 3 0.1 45 4 1.1 433 could be better option Regards Petr > > Hope this helps a little. > > Allan > > On 03/06/10 16:18, 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 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???? > > > > > > > > > > [[alternative HTML version deleted]] > > > > ______________________________________________ > > 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. > > > > ______________________________________________ > 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. ______________________________________________ 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.
