See ?reshape
Uwe Ligges
Christian Pilger wrote:
Dear R-experts,
recently, I started to discover the world of R. I came across a problem,
that I was unable to solve by myself (including searches in R-help, etc.)
I have a flat table similar to
key1 key2 value1
abcd_1 BP 10
abcd_1 BSMP 1A
abcd_1 PD 25
abcd_2 BP 20
abcd_3 BP 80
abcd_4 IA 30
abcd_4 PD 70
abcd_4 PS N
I wish to transform this table to obtain the following result:
key2
key1 BP BSMP IA PD PS
abcd_1 "10" "1A" "" "25" ""
abcd_2 "20" "" "" "" ""
abcd_3 "80" "" "" "" ""
abcd_4 "" "" "30" "70" "N"
I considered "table" and "xtabs" but I could not get the desired result: I
received cross-tables key1 vs. key2 that contained counts within the cells.
Can anybody help me?
Best wishes,
Christian
______________________________________________
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.
