[R] convert table

Richard.Cotton at hsl.gov.uk Richard.Cotton at hsl.gov.uk
Mon Dec 17 18:13:13 CET 2007


> 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}}



More information about the R-help mailing list