R help - Dec 2007 - convert table

Dear R user, a very simple question:
I have a table like this:

coor	v1	v2	v3
x1	12	33	123	
x2	1	123
x3	12	
x4	33	1

and I'd like to tranform this matrix in presence/absence data.frame

coor	1	12	33	123
x1	0	1	1	1	
x2	1	0	0	1
x3	0	1	0	0	
x4	1	0	1	0

Could you suggest me a direct way to do this?
Thank you
Giovanni

> I have a table like this:
> 
> coor   v1   v2   v3
> x1   12   33   123 
> x2   1   123
> x3   12 
> x4   33   1
> 
> and I'd like to tranform this matrix in presence/absence data.frame
> 
> coor   1   12   33   123
> x1   0   1   1   1 
> x2   1   0   0   1
> x3   0   1   0   0 
> x4   1   0   1   0
#This uses the reshape package
df = data.frame(coor = paste("x", 1:4, sep=""),
v1=c(12,1,12,33),
v2=c(33,123,NA,1), v3=c(1,NA,NA,NA))
mdf = melt(df)
with(mdf, table(coor, value))

Regards,
Richie.

Mathematical Sciences Unit
HSL


------------------------------------------------------------------------
ATTENTION:

This message contains privileged and confidential inform...{{dropped:20}}