[R] output formatting

[Pele]

Hi Kingsford - this is exactly what I am looking for...
Many thanks!!


Kingsford Jones wrote:
> 
> 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.
>>
> 
> ______________________________________________
> 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.
> 
> 

-- 
View this message in context: http://www.nabble.com/output-formatting-tp22344554p22345085.html
Sent from the R help mailing list archive at Nabble.com.