[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