Message-ID: <5C50753E-C7DE-4653-AC69-6A3CE37299DF@xs4all.nl>
Date: 2012-12-01T13:50:07Z
From: Berend Hasselman
Subject: How to built a pivot table of value
In-Reply-To: <1354365422132-4651539.post@n4.nabble.com>
On 01-12-2012, at 13:37, CE.KA wrote:
> 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
>
xtabs(r~p+q,data=base)
Output
---------
q
p v1 v2
a 9 7
b 4 8
d 5 2
Berend