[R] output formatting

[Kingsford Jones]

I'm guessing you processed a data frame with the 'by' function.
Rather than restructuring the by output, try using a different
function on your data frame.  For example

> #install.packages(doBy)
> summaryBy(breaks ~ tension + wool, data=warpbreaks, FUN=sum)
  tension wool breaks.sum
1       L    A        401
2       L    B        254
3       M    A        216
4       M    B        259
5       H    A        221
6       H    B        169

as opposed to

> with(warpbreaks, by(breaks, list(tension,wool), sum))
: L
: A
[1] 401
------------------------------------------------------------------------------
: M
: A
[1] 216
------------------------------------------------------------------------------
: H
: A
[1] 221
------------------------------------------------------------------------------
: L
: B
[1] 254
------------------------------------------------------------------------------
: M
: B
[1] 259
------------------------------------------------------------------------------
: H
: B
[1] 169


hth,
Kingsford Jones

On Wed, Mar 4, 2009 at 8:17 PM, Pele <drdionc at yahoo.com> wrote:
>
> Hi R users,
>
> I have an R object with the following attributes:
>
>> str(sales.bykey1)
>  'by' int [1:3, 1:2, 1:52] 268 79 118 359 87 147 453 130 81 483 ...
>  - attr(*, "dimnames")=List of 3
>  ..$ GROUP: chr [1:3] "III" "II" "I"
>  ..$ year           : chr [1:2] "2006" "2007"
>  ..$ week           : chr [1:52] "1" "2" "3" "4" ...
>  - attr(*, "call")= language by.data.frame(data = vars, INDICES = bykey1,
> FUN = sum)
>
>> sales.bykey1
> ---------------
> GROUP: III
> year: 2007
> week: 51
> [1] 64
> ---------------
> GROUP: II
> year: 2007
> week: 51
> [1] 17
> ---------------
> GROUP: I
> year: 2007
> week: 51
> [1] 21
> ---------------
> GROUP: III
> year: 2006
> week: 52
> [1] 14
> ---------------
> GROUP: II
> year: 2006
> week: 52
> [1] 62
> --------------
> GROUP: I
> year: 2006
> week: 52
> [1] 10
>
>
> Can anyone share the most efficient way to convert the output (sales.bykey1)
> above to look like this:
>
>
> GROUP   Year    week    sales
> III     2007    51      64
> II      2007    51      17
> I       2007    51      21
> III     2006    52      14
> II      2006    52      62
> I       2006    52      10
>
> Many thanks in advance for any help!
> --
> View this message in context: http://www.nabble.com/output-formatting-tp22344554p22344554.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help at 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.
>