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.
______________________________________________ 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.