[R-sig-eco] Multiple count if style "queries"

[Peter Solymos]

Chris,

Something like this should do the job:

1.
rowSums(xtabs(~ ECO_NAME + Genus, x) > 0)
2.
rowSums(xtabs(~ ECO_NAME + Genus, x))

Cheers,

Peter



On Fri, May 20, 2011 at 3:19 PM, Chris Mcowen <chrismcowen at gmail.com> wrote:
> Dear List,
>
> I am looking to calculate two things from my data frame and was after some advice. For the example below i want to know.
>
> 1. How many unique Orders/Families and Genera there are per eco-name
>
> 2. How many incidences are there for each Order/Family and Genus there are per eco-region
>
> I have 650 econame.
>
> I.e for Biak-Numfoor rain forests there are 2 orders, 2 families and two genera. Also, Alismatales are represented once, Asparagales once etc etc.
>
> Thanks for any advice.
>
> Chris
>
>
> ECO_NAME                                                        Order           Family                                  Genus
> Biak-Numfoor rain forests                               Alismatales             Araceae                         Homalomena
> Biak-Numfoor rain forests                               Asparagales             Orchidaceae                     Bromheadia
> Central Range montane rain forests      Alismatales             Araceae                         Homalomena
> Central Range montane rain forests      Asparagales             Lomandraceae            Cordyline
> Central Range montane rain forests      Asparagales             Orchidaceae                     Thelymitra
> Central Range montane rain forests      Asparagales             Orchidaceae                     Dendrobium
> Central Range montane rain forests      Asparagales             Orchidaceae                     Vanda
> Central Range montane rain forests      Asparagales             Orchidaceae                     Bulbophyllum
> Central Range montane rain forests      Asparagales             Orchidaceae                     Bulbophyllum
> Central Range montane rain forests      Asparagales             Orchidaceae                     Dendrobium
> Central Range montane rain forests      Asparagales             Orchidaceae                     Dendrobium
> Central Range montane rain forests      Commelinales    Commelinaceae           Murdannia
> Central Range montane rain forests      Poales                  Centrolepidaceae        Centrolepis
> Central Range montane rain forests      Poales                  Cyperaceae                      Machaerina
> Central Range montane rain forests      Poales                  Cyperaceae                      Eleocharis
> Central Range montane rain forests      Poales                  Eriocaulaceae           Eriocaulon
> Central Range montane rain forests      Poales                  Poaceae                 Schizostachyum
> Central Range montane rain forests      Poales                  Poaceae                 Poa
> Central Range montane rain forests      Zingiberales            Zingiberaceae           Alpinia
> Central Range montane rain forests      Zingiberales            Zingiberaceae           Curcuma
> Central Range montane rain forests      Zingiberales            Zingiberaceae           Amomum
> Huon Peninsula montane rain forests     Asparagales             Orchidaceae                     Taeniophyllum
> Huon Peninsula montane rain forests     Asparagales             Orchidaceae                     Corybas
> Huon Peninsula montane rain forests     Asparagales             Orchidaceae                     Thelymitra
> Huon Peninsula montane rain forests     Asparagales             Orchidaceae                     Glomera
> Huon Peninsula montane rain forests     Poales                  Centrolepidaceae        Centrolepis
> Huon Peninsula montane rain forests     Poales                  Poaceae                 Poa
>
> _______________________________________________
> R-sig-ecology mailing list
> R-sig-ecology at r-project.org
> https://stat.ethz.ch/mailman/listinfo/r-sig-ecology
>
>