[R] Working with data-frame

Christofer Bogaso bogaso.christofer at gmail.com
Sun Nov 9 20:58:12 CET 2014


Hi again,

Let say, I have following data frame:


Dat <- structure(list(A1 = structure(c(3L, 3L, 1L, 3L, 3L, 3L, 3L, 2L,
3L, 3L, 1L, 2L, 3L, 2L, 1L, 1L, 3L, 3L, 2L, 3L, 2L, 2L, 3L, 3L,
3L, 2L, 3L, 1L, 1L, 3L), .Label = c("a", "b", "c"), class = "factor"),
    A2 = c(2, 3, 2, 1, 3, 3, 2, 2, 3, 1, 3, 1, 3, 3, 2, 2, 1,
    2, 1, 2, 1, 3, 3, 2, 1, 2, 3, 2, 2, 2), C1 = 1:30), .Names = c("A1",
"A2", "C1"), row.names = c(NA, -30L), class = "data.frame")


Now my goal is :
1: Find all possible unique combinations of column 'A1' & column 'A2'.
For example A1 = c, A2 = 2 is 1 unique combination.

2. For each such unique combination, calculate sum for 'A3'.

Is there any direct R function to achieve this faster way? I have very
large data-frame to handle with such calculation.

I tried with spilt() function. However it looks to me that, it can
split a data-frame w.r.t. only one column.

Thanks for your suggestion



More information about the R-help mailing list