[R] Table Transformation

[Christian Pilger]

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

-- 
View this message in context: http://www.nabble.com/Table-Transformation-tp22335545p22335545.html
Sent from the R help mailing list archive at Nabble.com.