Re: Staging area for data before read into R

> Well, I am going to type in ever value because the data sheets are of
> counts of insects that I identified, so I should be okay with
> accuracy...  I really just need something that allows for more than
> 256 columns as I have encounter over 256 species of insects in even
> small streams. ...

Oh, ugh, that sounds difficult and prone to entry errors.  You might be
better off organizing in the 'long' format with 4-5 columns:
    siteID, subSiteID, species, count, comments

You can then reshape(), or use the reshape package, or even the 'pivot
table' available in excel and other spreadcheats.

Glad you have an answer.  Enjoy your day.
cur
--
Curt Seeliger, Data Ranger
Raytheon Information Services - Contractor to ORD
seeliger.curt@...
541/754-4638


r-help-bounces@... wrote on 10/20/2008 06:01:43 PM:
wrote:
> >> sorry excel 2003 with no immediate update in the future.
> >>
> >> On Mon, Oct 20, 2008 at 3:12 PM, Gabor Grothendieck
> >> <ggrothendieck@...> wrote:
> >>> You didn't say which version of Excel you are using but Excel 2007
> >>> allows 16,384 columns.
> >>>
> >>> On Mon, Oct 20, 2008 at 2:27 PM, stephen sefick <ssefick@...>
wrote:
> >>>> I am wondering if there is a better alternative than Excel for data
> >>>> storage that does not require database knowledge (I will eventually
> >>>> have to learn this, but it is not on my immediate todo list).  I
need
> >>>> something that is not limited to 256 columns... I don't need any of
> >>>> the built in functions in excel just a spreadsheet like program
with
> >>>> cells that hold data in a data.frame format for a staging area
before
> >>>> I get it into R.  Any help would be greatly appreciated.  This is
not
> >>>> a direct r question, but all of you folks have more experience than
I
> >>>> do and I am having a time finding what I need with google.
> >>>> thanks in advance
> >>>>
> >>>> --
> >>>> Stephen Sefick
> >>>> Research Scientist
> >>>> Southeastern Natural Sciences Academy
> >>>>
> >>>> Let's not spend our time and resources thinking about things that
are
> >>>> so little or so large that all they really do for us is puff us up
and
> >>>> make us feel like gods.  We are mammals, and have not exhausted the
> >>>> annoying little problems of being mammals.
> >>>>
> >>>>                                                                -K.
Mullis and
> >> make us feel like gods.  We are mammals, and have not exhausted the
> >> annoying little problems of being mammals.
> >>
> >>                                                                -K.
Mullis http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.

        [[alternative HTML version deleted]]

______________________________________________
R-help@... mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.