From: Chris Mcowen <chrismcowen at gmail.com>
Subject: Re: [R] Multiple subsets of data
To: "John Kane" <jrkrideau at yahoo.ca>
Cc: r-help at r-project.org
Received: Thursday, January 6, 2011, 10:19 AM
Hi,
Sorry the formatting has messed up, the common variable is
species ( spelt different in both but i have corrected this
now)
I am having some luck with the which function but am
struggling to automate it for all communities
On 6 Jan 2011, at 15:09, John Kane wrote:
Is there any common variable?? From your description,
I don't see how you would link a species to a
community.? I mean if you select species a in df1 how
would you know what community it is in?
--- On Thu, 1/6/11, Chris Mcowen <chrismcowen at gmail.com>
wrote:
From: Chris Mcowen <chrismcowen at gmail.com>
Subject: [R] Multiple subsets of data
To: r-help at r-project.org
Received: Thursday, January 6, 2011, 6:29 AM
Dear List,
I have a data frame called trait with roughly 800
in, each species have 15 columns of information:
Species? ? ???
1? ? 2? ? 3???
etc..
a? ? ? ? ???
t? ? y? ? h
b? ? ? ? ???
f? ? j? ? u
c? ? ? ? ???
r? ? y? ? u
etc..
I then have another data frame called com with the
composition of species in each region, there are 506
different communities:
community? ? species
NA1102? ? ? ? a
NA1102? ? ? ? c
NA0402? ? ? ? b
NA0402? ? ? ? c
AT1302? ? ? ? a
AT1302? ? ? ? b
etc..
What i want to do is extract the information held in
first data frame for each community and save this as a
data frame.
Resulting in : -
community_NA1102? ?
a? ? ? ? ???
t? ? y? ? h
c? ? ? ? ???
r? ? y? ? u
community_NA0402? ?
b? ? ? ? ???
f? ? j? ? u
c? ? ? ? ???
r? ? y? ? u
Thanks in advance for any suggestions / code.