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]]
You have to explicitly ask that they not be printed:> x <- aggregate(state.x77, list(Region = state.region), mean) > xRegion 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 <ds5j@excite.com> 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]]
answer to your second question:> paste("$", format(1234567.77, big.mark=','), sep='')[1] "$1,234,568">you will have to go through each column you want and explicitly do it:> xRegion 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> x$Population <- paste("$", format(x$Population, big.mark=','), sep='') > xRegion Population Income Illiteracy Life Exp Murder HS Grad Frost Area 1 Northeast $5,495.111 4570.222 1.000000 71.26444 4.722222 53.96667 132.7778 18141.00 2 South $4,208.125 4011.938 1.737500 69.70625 10.581250 44.34375 64.6250 54605.12 3 North Central $4,803.000 4611.083 0.700000 71.76667 5.275000 54.51667 138.8333 62652.00 4 West $2,915.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 <ds5j@excite.com> 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]]