Dear all,

I would like to aggregate a data frame (consisting of 2 columns - one  
for the bins, say factors, and one for the values) along bins and  
quantiles within the bins.

I have tried

aggregate(data.frame$values, list(bin = data.frame 
$bin,Quantile=cut2(data.frame$bin,g=10)),sum)

but then the quantiles apply to the population as a whole and not the  
individual bins. Upon this realisation I have tried

aggregate(data.frame$values, list(bin = data.frame 
$bin,Quantile=tapply(data.frame$values,data.frame$bin,cut2,g=10)),sum)

which gives the following error:

Error in sort.list(unique.default(x), na.last = TRUE) :
   'x' must be atomic for 'sort.list'
Have you called 'sort' on a list?

clearly I am doing something wrong, but cannot figure out what.  I  
believe the error stems either from a. the output of tapply being a  
list of a dimension equal to the number of bins, and not a list of  
equal dimension as the values, or b. that somehow aggregate does not  
like that the second list (of the quantiles within the bins are not  
sorted nicely)

1. Do you have a reference for doing the summation on both bins and  
quantiles within the bins?
2. If not, can you give me some guidance as to what I am doing wrong  
and how I can solve the sort/list issue?

Any help would be greatly appreciated

Kind regards,

Ivan Alves


	[[alternative HTML version deleted]]

