H all,
I have relative abundance data from 100 sites. This is from acoustic
monitoring and usually the data is for 2-3 nights but in some cases my
be longer like months for each location..
The data output from my management data base is proved by species by
night for each location so data frame would look like this below. What
I need to do is sum the Survey_time by Spec_Code for each location name
and divide summed AI values for each Spec_code by the summed Survey time
to adjust for unit effort then standardize it all by *10 to represent
the relative abundance by survey hour to 10 hours. How best to do this?
Using Plyr or reshape?
Location name SPEC_CODE Start_Day Survey_Time AI Std AI
079-f2p1-AcetunaBuzz2/14/2012 12.11 0.8264463
079-f2p1-AcetunaBuzz2/14/2012 12.11 0.8264463
079-f2p1-AcetunaEumspp 2/14/2012 12.11 0.8264463
079-f2p1-AcetunaFrag2/14/2012 12.118 14.87603
079-f2p1-AcetunaMolspp 2/14/2012 12.15 4.132231
079-f2p1-AcetunaMolspp 2/14/2012 12.15 4.132231
079-f2p1-AcetunaPhyllo 2/14/2012 12.12 1.652893
079-f2p1-AcetunaPtedav 2/14/2012 12.11 0.8264463
079-f2p1-AcetunaPtegym 2/14/2012 12.11 0.8264463
079-f2p1-AcetunaPtepar 2/14/2012 12.12 1.652893
079-f2p1-AcetunaRhotum 2/14/2012 12.16 4.958678
079-f2p1-AcetunaSacbil 2/14/2012 12.16 4.958678
079-f2p1-AcetunaSaclep 2/14/2012 12.111 9.090909
079-f2p1-AcetunaBuzz2/15/2012 12.12 1.652893
079-f2p1-AcetunaBuzz2/15/2012 12.12 1.652893
079-f2p1-AcetunaMolmol 2/15/2012 12.11 0.8264463
079-f2p1-AcetunaMolspp 2/15/2012 12.17 5.785124
079-f2p1-AcetunaMolspp 2/15/2012 12.17 5.785124
079-f2p1-AcetunaNocalb 2/15/2012 12.16 4.958678
079-f2p1-AcetunaPhyllo 2/15/2012 12.11 0.8264463
079-f2p1-AcetunaPtedav 2/15/2012 12.11 0.8264463
079-f2p1-AcetunaPtegym 2/15/2012 12.14 3.305785
079-f2p1-AcetunaPtepar 2/15/2012 12.14 3.305785
079-f2p1-AcetunaPteper 2/15/2012 12.13 2.479339
079-f2p1-AcetunaRhotum 2/15/2012 12.17 5.785124
079-f2p1-AcetunaSacbil 2/15/2012 12.12 1.652893
079-f2p1-AcetunaSaclep 2/15/2012 12.16 4.958678
079-f2p1-AcetunaBuzz2/16/2012 12.21 0.8196721
079-f2p1-AcetunaBuzz2/16/2012 12.21 0.8196721
079-f2p1-AcetunaEumspp 2/16/2012 12.24 3.278688
079-f2p1-AcetunaMolspp 2/16/2012 12.22 1.639344
079-f2p1-AcetunaMolspp 2/16/2012 12.22 1.639344
079-f2p1-AcetunaMyokea 2/16/2012 12.21 0.8196721
079-f2p1-AcetunaNocalb 2/16/2012 12.24 3.278688
079-f2p1-AcetunaPhyllo 2/16/2012 12.21 0.8196721
079-f2p1-AcetunaPtedav 2/16/2012 12.21 0.8196721
079-f2p1-AcetunaPtegym 2/16/2012 12.21 0.8196721
079-f2p1-AcetunaPtepar 2/16/2012 12.23 2.459016
079-f2p1-AcetunaPteper 2/16/2012 12.21 0.8196721
079-f2p1-AcetunaRhotum 2/16/2012 12.217 13.93443
079-f2p1-AcetunaSacbil 2/16/2012 12.23 2.459016
079-f2p1-AcetunaSaclep 2/16/2012 12.215 12.29508
Thanks for any suggestions. Excel will be a mess to try to do that.
Bruce
[[alternative HTML version deleted]]
___
R-sig-ecology mailing list
R-sig-ecology@r-project.org
https://stat.ethz.ch/mailman/listinfo/r-sig-ecology