You have to explicitly ask that they not be printed:
> x <- aggregate(state.x77, list(Region = state.region), mean)
> x
Region Population Income Illiteracy Life Exp Murder HS
Grad Frost Area
1 Northeast 5495.111 4570.222 1.000000 71.26444 4.722222 53.96667
132.7778 18141.00
2 South 4208.125 4011.938 1.737500 69.70625 10.581250 44.34375
64.6250 54605.12
3 North Central 4803.000 4611.083 0.700000 71.76667 5.275000 54.51667
138.8333 62652.00
4 West 2915.308 4702.615 1.023077 71.23462 7.215385 62.00000
102.1538 134463.00
> print(x, row.names=FALSE)
Region Population Income Illiteracy Life Exp Murder HS Grad
Frost Area
Northeast 5495.111 4570.222 1.000000 71.26444 4.722222 53.96667
132.7778 18141.00
South 4208.125 4011.938 1.737500 69.70625 10.581250 44.34375
64.6250 54605.12
North Central 4803.000 4611.083 0.700000 71.76667 5.275000 54.51667
138.8333 62652.00
West 2915.308 4702.615 1.023077 71.23462 7.215385 62.00000
102.1538 134463.00
>
On Sun, Sep 21, 2008 at 6:03 PM, DS <[EMAIL PROTECTED]> wrote:
> Hi,
>
> 1) I have noticed that when I use the aggregate function it outputs
> numbers in the results. for example:
> aggregate by product
>
> group.1 Aggregate
> 1 ProductA 1000400.00
> 2 ProductB 23232323.00
> 3 Missing 232323.00
>
> is there a way to suppress the numbers infront of aggregate outputs. I
> checked and they don't look like columns when I do a summary so I can't -1
> them away.
>
> 2) is there an easy way to then take my aggregate matrix and then format
> the sum wtih $ and commas. for e.g instead 10000 it should show
> $10,000.00?
>
> I am trying to create a report and am piping the aggregate into an xtable
> and feeding it R2html.
>
> thanks
> Dhruv
>
> ------------------------------------------------------------
> Medical Billing and Coding Training
>
> ools.
>
> http://tagline.excite.com/fc/JkJQPTgMxYL8ba16zHPqHis4q6x4p3rbpaGcEAQIui8YyxCoQBNUxa/
> [[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<http://www.r-project.org/posting-guide.html>
> and provide commented, minimal, self-contained, reproducible code.
>
--
Jim Holtman
Cincinnati, OH
+1 513 646 9390
What is the problem that you are trying to solve?
[[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.
