[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