And yet another way.
library(reshape2)
names(Dat1) <- c("big","small","nums")
dcast(Dat1 , big ~ small, sum)
John Kane
Kingston ON Canada
> -----Original Message-----
> From: bogaso.christo...@gmail.com
> Sent: Tue, 18 Dec 2012 20:06:42 +0530
> To: r-help@r-project.org
> Subject: [R] Summarizing elements for a data.frame
>
> Hello again, let say we have following data:
>
> Dat1 <- structure(list(factor.sample.LETTERS.1.3...6..replace...T.. =
> structure(c(1L,
> 3L, 2L, 1L, 3L, 3L), .Label = c("A", "B", "C"), class = "factor"),
> factor.sample.letters.1.2...6..replace...T.. = structure(c(2L,
> 2L, 1L, 1L, 2L, 1L), .Label = c("a", "b"), class = "factor"),
> X1.6 = 1:6), .Names =
> c("factor.sample.LETTERS.1.3...6..replace...T..",
> "factor.sample.letters.1.2...6..replace...T..", "X1.6"), row.names =
> c(NA,
> -6L), class = "data.frame")
>
> Out of this data.frame, I want to create a Table with rows coming from
> 1st column of Dat1 and columns are coming from 2nd column of Dat1 and
> each entry will be the sum for 3rd column of Dat1, i.e. the element
> for (1,1) will be sum for all element in 3rd column corresponding to
> (A, a) and so on.
>
> I tried with table() however could not achieve what I wanted.
>
> Can somebody give me some pointer?
>
> Thanks and regards,
>
> ______________________________________________
> R-help@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.
____________________________________________________________
FREE ONLINE PHOTOSHARING - Share your photos online with your friends and
family!
Visit http://www.inbox.com/photosharing to find out more!
______________________________________________
R-help@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.
