[R] R- transform data frame into matrix

From: Thorsten Raff <t.raff_at_med2.uni-kiel.de>
Date: Wed, 12 Nov 2008 17:31:44 +0100


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

______________________________________________ R-help_at_r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.

Received on Wed 12 Nov 2008 - 16:34:53 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 12 Nov 2008 - 17:30:25 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive