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

[Chris Mcowen]

Hi Eduard,

That is a handy package, i hadn't come across.

The ouput from dcf is perfect.

But for dfm:

                                ECO_NAME        Order           Family
134   Central Range montane rain forests Zingiberales    Zingiberaceae
269   Central Range montane rain forests Zingiberales    Zingiberaceae
364            Biak-Numfoor rain forests  Asparagales      Orchidaceae
500   Central Range montane rain forests  Asparagales      Orchidaceae
566   Central Range montane rain forests       Poales Centrolepidaceae
567  Huon Peninsula montane rain forests       Poales Centrolepidaceae
755   Central Range montane rain forests  Asparagales     Lomandraceae
906  Huon Peninsula montane rain forests  Asparagales      Orchidaceae
1079  Central Range montane rain forests Zingiberales    Zingiberaceae
1175  Central Range montane rain forests  Asparagales      Orchidaceae
1271  Central Range montane rain forests       Poales       Cyperaceae
1421  Central Range montane rain forests       Poales    Eriocaulaceae
1581 Huon Peninsula montane rain forests  Asparagales      Orchidaceae
1621           Biak-Numfoor rain forests  Alismatales          Araceae
1622  Central Range montane rain forests  Alismatales          Araceae
1811  Central Range montane rain forests       Poales       Cyperaceae
1928  Central Range montane rain forests Commelinales    Commelinaceae
2141  Central Range montane rain forests       Poales          Poaceae
2142 Huon Peninsula montane rain forests       Poales          Poaceae
2276  Central Range montane rain forests       Poales          Poaceae
2391 Huon Peninsula montane rain forests  Asparagales      Orchidaceae
2525  Central Range montane rain forests  Asparagales      Orchidaceae
2526 Huon Peninsula montane rain forests  Asparagales      Orchidaceae
2660  Central Range montane rain forests  Asparagales      Orchidaceae

I would want to count how many time a order appears in each eco_name and then how many times a family appears in each eco_name and how many times a genus appears in each eco_name.

For example to ask the question: How many  Zingiberaceae family are there in Central Range montane rain forests? But to query this for each eco_name.

I hope this makes sense.

Chris




On 20 May 2011, at 23:23, Eduard Szöcs wrote:

Using the reshape package:

require(reshape)
dfm <- melt(data2, id = "ECO_NAME")
dfc <- cast(dfm, ECO_NAME~variable, function(x) length(unique(x)))


Eduard

Am 20.05.2011 23:19, schrieb Chris Mcowen:
> 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
> 

_______________________________________________
R-sig-ecology mailing list
R-sig-ecology at r-project.org
https://stat.ethz.ch/mailman/listinfo/r-sig-ecology