library(reshape2)
x <- structure(list(ExpName = structure(c(1L, 1L, 1L, 1L, 2L, 2L,
2L, 3L, 3L), .Label = c("MM1-x1", "MM1-X2",
"MMX-X3"), class = "factor"),
Identifier = structure(c(1L, 2L, 3L, 4L, 1L, 2L, 4L, 1L,
2L), .Label = c("GSK", "GSK2", "GSK3",
"GSK4"), class = "factor"),
value = c(0.02, 0.001, 0.04, 0.1, 0.4, 0.1, 0.002, 0.4, 0.23
)), .Names = c("ExpName", "Identifier",
"value"), class "data.frame", row.names = c(NA,
-9L))
dcast(x, ExpName ~ Identifier)
Michael
On Mon, Mar 26, 2012 at 4:20 PM, Srinivas Iyyer
<srini_iyyer_bio at yahoo.com> wrote:> Hi:
> sorry for asking simple question (not simple for me though).
>
> I have a data frame something like this:
>
> ExpName Identifier value
> MM1-x1 GSK 0.02
> MM1-x1 GSK2 0.001
> MM1-x1 GSK3 0.04
> MM1-x1 GSK4 0.1
> MM1-X2 GSK 0.4
> MM1-X2 GSK2 0.1
> MM1-X2 GSK4 0.002
> MMX-X3 GSK 0.4
> MMX-X3 GSK2 0.23
>
>
>
> I am interested in getting a long table something like this:
>
> ?GSK GSK2 GSK3 GSK4 GSK..(n)
> MM1-x1 0.02 0.001 0.04 0.1
> MM1-X2 0.4 0.1 ?0.002
> MM1-X3 0.4 0.23
> MM1-Xn
>
>
> I am re-arranging my fields into more clean data frame.
>
> How is it possible to do this?
>
> thanks
> Srini
>
> ______________________________________________
> 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.