[R] reformatting some data
arun
smartpink111 at yahoo.com
Tue Dec 4 22:41:13 CET 2012
Hi,
Not sure whether this helps:
library(reshape2)
dat1<-structure(list(group = c(4L, 3L, 4L, 4L, 4L, 2L), X3.Hydroxybutyrate =
c(4e-04,
5e-04, 4e-04, 6e-04, 5e-04, 7e-04), X3.Hydroxyisovalerate = c(3e-04,
3e-04, 3e-04, 3e-04, 3e-04, 4e-04), ADP = c(5e-04, 6e-04, 6e-04,
5e-04, 7e-04, 7e-04)), .Names = c("group", "X3.Hydroxybutyrate",
"X3.Hydroxyisovalerate", "ADP"), row.names = c(347L, 353L, 359L,
365L, 371L, 377L), class = "data.frame")
datM<-melt(dat1,id.var="group")
dcast(datM,variable~group,length)
#or
dcast(datM,variable~group,mean)
# variable 2 3 4
#1 X3.Hydroxybutyrate 7e-04 5e-04 0.000475
#2 X3.Hydroxyisovalerate 4e-04 3e-04 0.000300
#3 ADP 7e-04 6e-04 0.000575
A.K>
----- Original Message -----
From: Charles Determan Jr <deter088 at umn.edu>
To: r-help at r-project.org
Cc:
Sent: Tuesday, December 4, 2012 4:17 PM
Subject: [R] reformatting some data
Hello,
I am trying to reformat some data so that it is organized by group in the
columns. The data currently looks like this:
group X3.Hydroxybutyrate X3.Hydroxyisovalerate ADP
347 4 4e-04 3e-04 5e-04
353 3 5e-04 3e-04 6e-04
359 4 4e-04 3e-04 6e-04
365 4 6e-04 3e-04 5e-04
371 4 5e-04 3e-04 7e-04
377 2 7e-04 4e-04 7e-04
I would like to reformat it so it is like this:
2 3 4
var1
var2
var3
I realize that there unequal numbers in each group but I would like to
none-the-less if possible.
Here is a subset of the data:
structure(list(group = c(4L, 3L, 4L, 4L, 4L, 2L), X3.Hydroxybutyrate =
c(4e-04,
5e-04, 4e-04, 6e-04, 5e-04, 7e-04), X3.Hydroxyisovalerate = c(3e-04,
3e-04, 3e-04, 3e-04, 3e-04, 4e-04), ADP = c(5e-04, 6e-04, 6e-04,
5e-04, 7e-04, 7e-04)), .Names = c("group", "X3.Hydroxybutyrate",
"X3.Hydroxyisovalerate", "ADP"), row.names = c(347L, 353L, 359L,
365L, 371L, 377L), class = "data.frame")
Any insight is truly appreciated,
Regards,
Charles
[[alternative HTML version deleted]]
______________________________________________
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.
More information about the R-help
mailing list