[R] pivoting - summing up factors

jim holtman jholtman at gmail.com
Wed May 7 21:12:58 CEST 2008


Is this what you want:

> x
  location plant
1        x     a
2        x     b
3        x     b
4        y     b
5        y     b
6        y     a
7        z     a
8        z     a

> table(x$plant,x$location)

    x y z
  a 1 1 2
  b 2 2 0
>


On Wed, May 7, 2008 at 2:56 PM, juanita choo <juanitachoo at gmail.com> wrote:
> Hi
> I would like to know how to pivot a table that will sum the number of plants
> (a or b) for each location (x,y,z)
> I have read on the listserve similar questions but which involve summing up
> numbers rather than factors.  I have also read about the R package reshape
> on the listserve but wanted to know if there's a way to do it easily without
> the package
> Thanks for the help!
>
> location  plant
>  x             a
>  x             b
>  x             b
>  y             b
>  y             b
>  y             a
>  z             a
>  z             a
>
> into a table like this
>
>
>       x            y           z
> a     1            1           2
> b     2            2           0
>
>        [[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
Cincinnati, OH
+1 513 646 9390

What is the problem you are trying to solve?



More information about the R-help mailing list