Hi,
Thanks a lot.

here is a fraction of my df:

Sample     Season  Area     Gear  Depth
       1           W           1          5       1
       2           Sp          1          3       1
       2           Sp          1          5       1
       2           Sp          1         11      1
       2           Sp          1         11      1

Sample: 1:28
Season: I, P, V, O
Area: 1:3
Fishing gear: 1:12
Depth: 1:8

each variable level is coded with numbers. e.g I have 3 areas and 12 gears

My doubt:
I'd like to know how many times I saw each gear in the combination of some
of the other factors: e.g. season Sp + area 1 + depth 1.

I've tried to do tables for each pair of variables (with one common
variable) and then a merge but it didn't work.

I'm looking for reshape package but it's not easy to know what to do.


Thanks a lot again.
Cheers,
Barbara




On 14 July 2010 14:39, Dieter Menne <dieter.menne@menne-biomed.de> wrote:

>
>
> barbara horta e costa wrote:
> >
> > I have a data frame with several factors and I want to count the
> > occurrences
> > of an event resulting from an interaction of some factors.
> >
> > I'd only need a table as excel does with pivot table and summarize data
> as
> > count
> >
>
> "Only" what pivot tables does: Pivot tables are one of the best features of
> Excel, and it's not always that easy in R. Hadley Wickham who has written
> the "reshape" package, admitted that he tried to mimic pivot tables in R;
> the fact that the has not been ripped into piece because of this confession
> tells a lot.
>
> Anyway: give package reshape a try; it comes with a nice tutorial. And if
> you have more questions, try to construct a very simple example (3 lines!)
> that runs out of the box and shows your problem. I assume that merge (which
> does something like SQL join) is not what you need, but I am not sure
>
> Dieter
>
>
> --
> View this message in context:
> http://r.789695.n4.nabble.com/count-help-tp2288571p2288764.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
>  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<http://www.r-project.org/posting-guide.html>
> and provide commented, minimal, self-contained, reproducible code.
>



-- 
Bárbara H. Costa
Marine Biologist Researcher
SCIAENA - Marine Sciences and Cooperation
www.sciaena.org

ISPA | http://www.ispa.pt/ui/uie/index.asp
BIOMARES | http://www.ccmar.ualg.pt/biomares/
MSI-UCSB | http://www.msi.ucsb.edu/

bcosta@ispa.pt
barbarahcosta@gmail.com

	[[alternative HTML version deleted]]

