[R] aggregate function

jim holtman jholtman at gmail.com
Wed Dec 21 17:31:46 CET 2011


Here is an example using 'data.table'"

> x <- read.table(text = "param       case1
+ 1               a
+ 2               b
+ 2               c
+ 2               d
+ 3               e
+ 4               f", header = TRUE, as.is = TRUE)
> require(data.table)
> x <- data.table(x)
> x[
+     , list( case1 = paste(case1, collapse = ','))
+     , by = param
+  ]
     param case1
[1,]     1     a
[2,]     2 b,c,d
[3,]     3     e
[4,]     4     f
>


On Wed, Dec 21, 2011 at 11:26 AM, Mary Kindall <mary.kindall at gmail.com> wrote:
> Hi
> I have a data frame with values in following format.
>
>
> param       case1
> 1               a
> 2               b
> 2               c
> 2               d
> 3               e
> 4               f
>
>
> how to use aggregate so that it I only one row for each 'param' value.
>
> the output for the above input should be
>
> param     case1
> 1      a
> 2      b,c,d
> 3      e
> 4      f
>
> Thanks
> M
>
>
>
> --
> -------------
> Mary Kindall
> Yorktown Heights, NY
> USA
>
>        [[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.



-- 
Jim Holtman
Data Munger Guru

What is the problem that you are trying to solve?
Tell me what you want to do, not how you want to do it.



More information about the R-help mailing list