Message-ID: <1354381677.26979.YahooMailNeo@web142606.mail.bf1.yahoo.com>
Date: 2012-12-01T17:07:57Z
From: arun
Subject: How to built a pivot table of value
In-Reply-To: <1354365422132-4651539.post@n4.nabble.com>
HI,
You can also also ?reshape()
res<-reshape(base,v.names="r",idvar="p",timevar="q",direction="wide")
?res[order(res$p),]
A.K.
----- Original Message -----
From: CE.KA <ce.kaya75 at yahoo.fr>
To: r-help at r-project.org
Cc:
Sent: Saturday, December 1, 2012 7:37 AM
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 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.