Blast, you're right. I tend to load both at the same time and confused the two.
It should be reshape2
John Kane
Kingston ON Canada
> -----Original Message-----
> From: b...@xs4all.nl
> Sent: Sat, 1 Dec 2012 15:20:13 +0100
> To: jrkrid...@inbox.com
> Subject: Re: [R] How to built a pivot table of value
>
>
> On 01-12-2012, at 14:56, John Kane wrote:
>
>> One way, using the plyr package would be:
>>
>> library(plyr)
>> dcast(base, p ~ q)
>>
>
> Shouldn't that be library(reshape2) ?
>
> Berend
>
>> John Kane
>> Kingston ON Canada
>>
>>
>>> -----Original Message-----
>>> From: ce.kay...@yahoo.fr
>>> Sent: Sat, 1 Dec 2012 04:37:02 -0800 (PST)
>>> To: r-help@r-project.org
>>> Subject: [R] How to built a pivot table of value
>>>
>>> Hi R users
>>>
>>> Imagine the table "base":
>>> p=c("d","d","b","b","a","a")
>>> q=c("v1","v2","v1","v2","v1","v2")
>>> r=c(5,2,4,8,9,7)
>>> base=data.frame(p,q,r)
>>> base
>>>
>>> p q r
>>> 1 d v1 5
>>> 2 d v2 2
>>> 3 b v1 4
>>> 4 b v2 8
>>> 5 a v1 9
>>> 6 a v2 7
>>>
>>> How programming R to get this result:
>>>
>>> v1 v2
>>> a 9 7
>>> b 4 8
>>> d 5 2
>>>
>>> I tried the function table but the result is divided in several matrix:
>>> table(base$p,base$q,base$r)
>>> , , = 2
>>>
>>>
>>> v1 v2
>>> a 0 0
>>> b 0 0
>>> d 0 1
>>>
>>> , , = 4
>>>
>>>
>>> v1 v2
>>> a 0 0
>>> b 1 0
>>> d 0 0
>>>
>>> , , = 5
>>>
>>>
>>> v1 v2
>>> a 0 0
>>> b 0 0
>>> d 1 0
>>>
>>> , , = 7
>>>
>>>
>>> v1 v2
>>> a 0 1
>>> b 0 0
>>> d 0 0
>>>
>>> , , = 8
>>>
>>>
>>> v1 v2
>>> a 0 0
>>> b 0 1
>>> d 0 0
>>>
>>> , , = 9
>>>
>>>
>>> v1 v2
>>> a 1 0
>>> b 0 0
>>> d 0 0
>>>
>>> SIncerely yours
>>>
>>>
>>>
>>> --
>>> View this message in context:
>>> http://r.789695.n4.nabble.com/How-to-built-a-pivot-table-of-value-tp4651539.html
>>> Sent from the R help mailing list archive at Nabble.com.
>>>
>>> ______________________________________________
>>> 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
>>> and provide commented, minimal, self-contained, reproducible code.
>>
>> ____________________________________________________________
>> GET FREE SMILEYS FOR YOUR IM & EMAIL - Learn more at
>> http://www.inbox.com/smileys
>> Works with AIM®, MSN® Messenger, Yahoo!® Messenger, ICQ®, Google Talk™
>> and most webmails
>>
>> ______________________________________________
>> 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
>> and provide commented, minimal, self-contained, reproducible code.
____________________________________________________________
GET FREE SMILEYS FOR YOUR IM & EMAIL - Learn more at
http://www.inbox.com/smileys
Works with AIM®, MSN® Messenger, Yahoo!® Messenger, ICQ®, Google Talk™ and most
webmails
______________________________________________
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
and provide commented, minimal, self-contained, reproducible code.
