[R] Table Transformation

[Uwe Ligges]

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
>