output formatting

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.