<html><head></head><body><div style="color:#000; background-color:#fff; font-family:Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px"><div id="yui_3_16_0_ym19_1_1483847670884_5065"><span id="yui_3_16_0_ym19_1_1483847670884_5342">Really difficult to answer since I do not know what it really is you are attempting to determine. It appears your data consists of:</span></div><div id="yui_3_16_0_ym19_1_1483847670884_6407"><span id="yui_3_16_0_ym19_1_1483847670884_5342">Long (tidy) format layout<br></span></div><div id="yui_3_16_0_ym19_1_1483847670884_5396" dir="ltr">a) species- mode character or mode factor (categorical if you want them that way). If you know how R treats factors and what functions to use for factors, then it's just a choice. If not familiar with how R treats factors then definitely character and save yourself some unwelcome surprises<span id="yui_3_16_0_ym19_1_1483847670884_5342"><br></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1483847670884_5484"><span id="yui_3_16_0_ym19_1_1483847670884_5342">b) season - same treatment as species, or perhaps better described by date??? Read the lubridate package vignette to learn how it makes working with dates simple.<br></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1483847670884_5677"><span id="yui_3_16_0_ym19_1_1483847670884_5342">c) counts-numerical<br></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1483847670884_6431"><span id="yui_3_16_0_ym19_1_1483847670884_5342"><br></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1483847670884_6484"><span id="yui_3_16_0_ym19_1_1483847670884_5342">Wide data format</span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1483847670884_6485"><span id="yui_3_16_0_ym19_1_1483847670884_5342">a) each species a column each per season such as black bear- wet,turtle - dry etc</span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1483847670884_6598"><span id="yui_3_16_0_ym19_1_1483847670884_6842">b) counts filing </span><span id="yui_3_16_0_ym19_1_1483847670884_5342"><span id="yui_3_16_0_ym19_1_1483847670884_6843">the columns </span>along with numerous NA <br></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1483847670884_6658"><span id="yui_3_16_0_ym19_1_1483847670884_5342">definitely an "untidy" data set but perhaps easiest to manually enter and verify?<br></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1483847670884_6846"><span id="yui_3_16_0_ym19_1_1483847670884_5342"><br></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1483847670884_6995"><span id="yui_3_16_0_ym19_1_1483847670884_5342">You can always use the data.table melt function to go from wide to long format when or if you want, or use cast to go the other way.</span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1483847670884_10677"><span id="yui_3_16_0_ym19_1_1483847670884_5342"><br></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1483847670884_10759"><span id="yui_3_16_0_ym19_1_1483847670884_5342">Here is a toy example in the long format layout (I'm to lazy to type the wide one)<br></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1483847670884_10792"><span id="yui_3_16_0_ym19_1_1483847670884_5342"><br></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1483847670884_10793"><span id="yui_3_16_0_ym19_1_1483847670884_5342"># critter pics<br id="yui_3_16_0_ym19_1_1483847670884_10810">library(data.table)<br id="yui_3_16_0_ym19_1_1483847670884_10811">library(lubridate)<br id="yui_3_16_0_ym19_1_1483847670884_10812">species <- c("bear","chipmunk","garter_snake","cardinal")<br id="yui_3_16_0_ym19_1_1483847670884_10813">date <- mdy(c("01-15-2016", "02-25-2016", "06-01-2016", "08-31-2016"))<br id="yui_3_16_0_ym19_1_1483847670884_10814">counts<- c(15,20,2,50)<br id="yui_3_16_0_ym19_1_1483847670884_10815">pics_data <- data.table(species,date,counts)<br id="yui_3_16_0_ym19_1_1483847670884_10816">pics_data<br id="yui_3_16_0_ym19_1_1483847670884_10817">str(pics_data)<br></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1483847670884_10965"><span id="yui_3_16_0_ym19_1_1483847670884_5342"><br></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1483847670884_10995"><span id="yui_3_16_0_ym19_1_1483847670884_5342">Data printout</span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1483847670884_10996"><br></div><table class="yahoo-compose-table-card img-overlay-selected" style="font-family: 'Lucida Console' !important; font-size: 10pt !important; font-style: inherit !important; font-variant: inherit !important; font-weight: inherit !important; line-height: inherit !important; padding-left: 6px; padding-bottom: 8px; border: none; outline: none; word-wrap: break-word; cursor: text; white-space: pre-wrap !important; color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); width: 708.1770629882813px;" id="yui_3_16_0_ym19_1_1483847670884_11030" cellspacing="0" cellpadding="0"><tbody id="yui_3_16_0_ym19_1_1483847670884_11031"><tr id="yui_3_16_0_ym19_1_1483847670884_11032"><td style="font-family: 'Lucida Console'; line-height: 1.2; font-size: 10pt !important; vertical-align: top;" id="yui_3_16_0_ym19_1_1483847670884_11033" align="left"><pre tabindex="0" style="font-family: 'Lucida Console'; font-size: 10pt !important; outline: none; border: none; word-break: break-all; margin: 0px; -webkit-user-select: text; white-space: pre-wrap !important; line-height: 1.2;" id="yui_3_16_0_ym19_1_1483847670884_11034"> species date counts
1: bear 2016-01-15 15
2: chipmunck 2016-02-25 20
3: garter_snake 2016-06-01 2
4: cardinal 2016-08-31 50
<span style="color: blue; white-space:pre-wrap; -webkit-user-select: text;" id="yui_3_16_0_ym19_1_1483847670884_11035">> </span><span style="color: blue;" id="yui_3_16_0_ym19_1_1483847670884_11036">str(pics_data)
</span>Classes ‘data.table’ and 'data.frame': 4 obs. of 3 variables:
$ species: chr "bear" "chipmunck" "garter_snake" "cardinal"
$ date : Date, format: "2016-01-15" "2016-02-25" ...
$ counts : num 15 20 2 50
- attr(*, ".internal.selfref")=<externalptr>
</pre></td></tr><tr id="yui_3_16_0_ym19_1_1483847670884_11037"><td style="font-family: 'Lucida Console'; line-height: 1.2; font-size: 10pt !important; vertical-align: top;" id="yui_3_16_0_ym19_1_1483847670884_11038" align="left"><br id="yui_3_16_0_ym19_1_1483847670884_11039"></td></tr><tr id="yui_3_16_0_ym19_1_1483847670884_11040"><td style="font-family: 'Lucida Console'; line-height: 1.2; font-size: 10pt !important; vertical-align: top;" id="yui_3_16_0_ym19_1_1483847670884_11041" align="left"><table style="width: 708.3333129882813px;" class="yahoo-compose-table-card" id="yui_3_16_0_ym19_1_1483847670884_11042" cellspacing="0" cellpadding="0"><tbody id="yui_3_16_0_ym19_1_1483847670884_11043"><tr id="yui_3_16_0_ym19_1_1483847670884_11044"><td rowspan="1" style="font-family: 'Lucida Console'; line-height: 1.2; font-size: 10pt !important; vertical-align: top;" id="yui_3_16_0_ym19_1_1483847670884_11045" width="1" height="" align="left"><div style="color: blue; white-space:pre-wrap; -webkit-user-select: text;" id="yui_3_16_0_ym19_1_1483847670884_11046">> </div></td></tr></tbody></table></td></tr></tbody></table><div id="yui_3_16_0_ym19_1_1483847670884_5348"><div dir="ltr" id="yui_3_16_0_ym19_1_1483847670884_11273"> </div></div><div class="signature" id="yui_3_16_0_ym19_1_1483847670884_5349">Carl Sutton</div> <div class="qtdSeparateBR"><br><br></div><div class="yahoo_quoted" style="display: block;"> <div style="font-family: Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div dir="ltr"><font size="2" face="Arial"> On Saturday, January 7, 2017 8:15 PM, BondHR <Hannah.Bond@outlook.com> wrote:<br></font></div> <blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; margin-top: 5px; padding-left: 5px;"> <br><br> <div class="y_msg_container">Sorry if this question is trivial,<br><br>I have a collection of camera trap data of recorded species during the rainy<br>season and the dry season.<br><br>I am confused how to lay out a table to import to R, do I have species down<br>the left (then counts of how many of that species) and columns of wet season<br>and dry season? <br><br>Also, I am confused on what statistical test to use :( <br><br><br>I've read so many books and websites and every thing seems to be<br>contradicting each other, please can anyone help! <br><br><br><br>--<br>View this message in context: <a href="http://r.789695.n4.nabble.com/What-statistical-test-to-use-for-species-abundance-between-wet-and-dry-season-tp4727949.html" target="_blank">http://r.789695.n4.nabble.com/What-statistical-test-to-use-for-species-abundance-between-wet-and-dry-season-tp4727949.html</a><br>Sent from the datatable-help mailing list archive at Nabble.com.<br>_______________________________________________<br>datatable-help mailing list<br><a ymailto="mailto:datatable-help@lists.r-forge.r-project.org" href="mailto:datatable-help@lists.r-forge.r-project.org">datatable-help@lists.r-forge.r-project.org</a><br><a href="https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help" target="_blank">https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help</a><br><br><br></div> </blockquote> </div> </div> </div></div></body></html>