Multiple count if style "queries"

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