[R] how to sum multiple data entries for the same sampling event?
karengrace84
kgfisher at alumni.unc.edu
Mon Jan 30 18:16:47 CET 2012
I'm having trouble with some catch per unit effort data (CPUE, fisheries
data). Some of the samples were "retained" and some "unretained," and they
are entered as 2 separate entries for the same sampling event (Date and
time). I want to calculate the total CPUE (so sum the "retained" and
"unretained" number for each sampling event) and am having troubld doing so.
Here's a sample of what my data.frame looks like now:
Date lmb.cpue
Disposition.of.Catch
1999-07-10 12:10:00 0.66666667 Unretained
1999-07-10 12:10:00 0.16666667 Retained
1999-07-14 11:22:00 0.83333333 Unretained
1999-07-14 11:22:00 0.55555556 Retained
1999-07-14 11:48:00 0.16666667 Unretained
1999-07-14 11:48:00 0.58333333 Retained
1999-07-14 13:56:00 0.57142857 Retained
1999-07-15 10:23:00 0.11111111 Retained
1999-07-22 12:03:00 0.33333333 Retained
1999-07-25 11:26:00 0.40000000 Unretained
1999-07-25 11:26:00 1.00000000 Retained
And I would like to end up with:
Date lmb.cpue
1999-07-10 12:10:00 0.83333333
1999-07-14 11:22:00 1.38888889
1999-07-14 11:48:00 0.75000000
1999-07-14 13:56:00 0.57142857
1999-07-15 10:23:00 0.11111111
1999-07-22 12:03:00 0.33333333
1999-07-25 11:26:00 1.40000000
Thanks for any help you have to offer!
--
View this message in context: http://r.789695.n4.nabble.com/how-to-sum-multiple-data-entries-for-the-same-sampling-event-tp4341670p4341670.html
Sent from the R help mailing list archive at Nabble.com.
More information about the R-help
mailing list