Hi,
Is there a way to add a colum containing percentages to output from
aggregate?
for example I have the following from aggregate:
(aggregate(data[,cbind("A","B","C","D","E","F")],
by=list(data$producttype), sum))
Group.1 A B C D
E F
1 ProductA 0.506626 0.413133 0.494486 0.35114 0.153208 0.045601
2 Product B 0.176571 0.28645 0.982117 0.724125 0.727259 0.033789
I want to have columns to show for e.g. column E/F as G% aand C/D as T%?
can I divided E/F or C/D and add them as 2 columns to the results of the
aggregate function somehow?
Which I then pipe ot html:
print(xtable(format(data, big.mark=',',
sep='')),include.rownames=FALSE,type='html')
thanks
Dhruv
[[alternative HTML version deleted]]