[R] matrix of mean values

arun smartpink111 at yahoo.com
Tue Oct 8 16:54:35 CEST 2013


Try:

d1$value<-as.numeric(gsub(",","",as.character(d1$value)))
library(reshape2)
res <- dcast(d1,loc~variables,value.var="value",mean)
A.K.


----- Original Message -----
From: Nico Met <nicomet80 at gmail.com>
To: R help <r-help at r-project.org>
Cc: 
Sent: Tuesday, October 8, 2013 10:47 AM
Subject: [R] matrix of mean values

Dear all, I have a data set where I want to make a matrix of the mean
values using 3rd column (value). Where rows are unique “loc” and columns
would be “variables”. If there is one observation or no observation just
use “NA”.



> dput(d1)

structure(list(loc = structure(c(6L, 9L, 9L, 9L, 9L, 4L, 4L,

4L, 4L, 4L, 4L, 13L, 5L, 5L, 5L, 5L, 5L, 5L, 5L, 5L, 5L, 7L,

7L, 7L, 7L, 7L, 7L, 7L, 7L, 8L, 8L, 8L, 8L, 8L, 8L, 8L, 10L,

10L, 10L, 10L, 10L, 11L, 11L, 12L, 12L, 12L, 12L, 12L, 12L, 1L,

3L, 3L, 3L, 2L), .Label = c("AX09_126", "AX09_628", "AX09_924",

"IALA08_3299", "JA08_246", "JA08_3299", "JA08_408", "JE08_246",

"JE08_3299", "JE08_408", "NO08_246", "NO08_408", "PP08_3299"), class =
"factor"),

    variables = structure(c(5L, 6L, 6L, 6L, 6L, 6L, 5L, 5L, 5L,

    7L, 7L, 7L, 7L, 4L, 4L, 4L, 4L, 4L, 2L, 2L, 2L, 2L, 3L, 3L,

    3L, 3L, 3L, 3L, 1L, 1L, 1L, 2L, 1L, 5L, 5L, 5L, 6L, 6L, 7L,

    7L, 7L, 7L, 7L, 7L, 7L, 3L, 7L, 4L, 4L, 4L, 7L, 7L, 7L, 7L

    ), .Label = c("i", "r", "s", "t", "x", "y", "z"), class = "factor"),

    value = structure(c(1L, 21L, 2L, 1L, 30L, 32L, 4L, 32L, 5L,

    20L, 5L, 1L, 24L, 12L, 26L, 24L, 12L, 15L, 26L, 14L, 15L,

    23L, 13L, 11L, 23L, 25L, 23L, 6L, 7L, 3L, 8L, 19L, 3L, 19L,

    28L, 16L, 18L, 18L, 17L, 31L, 29L, 10L, 27L, 22L, 9L, 22L,

    22L, 9L, 9L, 35L, 33L, 33L, 33L, 34L), .Label = c("0", "0,3333",

    "142,1", "1506,00006", "1520,66664", "170,36", "18,6185",

    "19,2933", "20,2125", "20,7423", "225,94", "23,2245", "24,3526",

    "24,3685", "24,4593", "242,84", "25,7422", "26,34", "26,5989",

    "30,33336284", "36,33336608", "39,913", "41,4933", "43,9104",

    "47,1241", "49,3467", "49,5715", "50,0037", "50,7974", "53,6667",

    "56,2778", "76", "76,5", "77,6667", "82"), class = "factor")), .Names =
c("loc",

"variables", "value"), class = "data.frame", row.names = c(NA,

-54L))



Thanks



Nico

    [[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