[R] R- transform data frame into matrix

Thorsten Raff t.raff at med2.uni-kiel.de
Wed Nov 12 17:31:44 CET 2008


I have the problem that I want to transform a dataframe as generated by

diagnosis <- rep(diagnosis[1:3], 3)
marker <- gl(3,3)
values <- rnorm(9)
dataframe <- cbind(diagnosis, marker, values)
dataframe <- dataframe[c(1:5, 7:9), ]

into a matrix where levels(diagnosis) is indicating the rows of the matrix, 
levels(marker) the columns and values are the actual content of the matrix. 
However, as can been seen in the dataframe, some observations are missing and 
should result in <NAs> in the resulting matrix, giving a result like this:

marker              1         2         3
diagnosis1      value   value   value
diagnosis2      value   value   value
diagnosis3      value      NA    value

Can anyone help out with some code for this? I have tried to look this up in 
the mailing list as it has probably been answered before but only found 
aspects of the problem which I was just not able to plumb together.

Many thanks in advance, I hope this is not to much of an insult for the list.


P.S: I have already sent this message to the mailing list, howver I got a 
bounce-message back, so hopefully this is no duplicate entry. Sorry for any 
inconvenience that this may confer.

Thorsten Raff
2nd Medical Department,
University Hospital Schleswig-Holstein, Campus Kiel
Chemnitzstraße 33
24116 Kiel

phone: +49 431 1697-5234
fax:   +49 431 1697-1264

email: t.raff<at>med2.uni-kiel.de
web:   www.uk-s-h.de

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part.
URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20081112/6dee27fd/attachment.bin>

More information about the R-help mailing list