s-news
[Top] [All Lists]

Re: Data manipulation

To: "Scott Rollins" <rollins8@msu.edu>, <s-news@lists.biostat.wustl.edu>
Subject: Re: Data manipulation
From: Don MacQueen <macq@llnl.gov>
Date: Thu, 20 Jun 2002 08:00:20 -0700
In-reply-to: <000001c2179f$87f1e0d0$6b480a23@Megalodonta>
References: <000001c2179f$87f1e0d0$6b480a23@Megalodonta>
Why don't you give a short example of the data manipulation you need to perform. That is, a few rows of a data frame and the matrix it would become.

You mention a "crosstab" query. So try help(crosstabs) in Splus, and that will cross-reference "table" and "tabulate".

-Don

At 10:42 AM -0400 6/19/02, Scott Rollins wrote:
I'm in need of data manipulation help.  This is the first time I've
tried to use S-Plus (version 4.5 running in Windows ME) for cluster
analysis.  I have a dataframe containing 3 columns: site, species, ra
(relative abundance).  I'd like to cluster groups of sites based on
their species composition, but I'm having trouble converting the data
into the proper matrix format.  Not all sites contain the same species,
nor equal numbers of species.  That is, the ra vector contains no zero
values, but the site by species matrix will contain many zeros.  I'm
convinced that I can do this in S-Plus and that I don't have to export
the data to MS Access and run a crosstab query to create the matrix!
Can anyone help me?

Thanks,
Scott

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Scott L. Rollins
Research Assistant
Algal Ecology Lab
Department of Zoology
203 Natural Science Building
Michigan State University
East Lansing, Michigan 48824-1115
Phone: 517-432-8084
FAX: 517-432-2789
e-mail: rollins8@msu.edu


--------------------------------------------------------------------
This message was distributed by s-news@lists.biostat.wustl.edu.  To
unsubscribe send e-mail to s-news-request@lists.biostat.wustl.edu with
the BODY of the message:  unsubscribe s-news


--
--------------------------------------
Don MacQueen
Environmental Protection Department
Lawrence Livermore National Laboratory
Livermore, CA, USA
--------------------------------------


<Prev in Thread] Current Thread [Next in Thread>