Hi, How about
dat <- data.frame(Prices, size, Band = cut(Prices, breaks=unique(Bands))) by(dat$size, dat$Band, sum) Best, Ista On Wed, Oct 17, 2012 at 10:58 AM, jcrosbie <ja...@crosb.ie> wrote: > I would like to create a subtotal table with custom bands. > > seq1 = seq(0, 100, by = 5) > seq2 = seq(100, 1000, by = 100) > Bands = c(seq1, seq2) > #Prices > Prices = sample(1:1000, 200, replace=F) > #corresponding size for the given price above. > size = sample(1:1000, 200, replace=F) > > How would I find the subtotal of the size based on a given price falls > within a band? > > > > -- > View this message in context: > http://r.789695.n4.nabble.com/subtotals-based-on-price-bands-tp4646473.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > 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.
