Hi,
Couldn't find your attachment.
But, from Nabble, I saw the data.
Try
this:dat1<-data.frame(Species=paste0("Species",1:6),Site1=c(5,NA,4,NA,3,NA),Site2=c(4,NA,4,4,NA,4),Site3=c(NA,5,NA,NA,NA,NA),Site4=c(NA,NA,NA,6,5,NA))
dat2<-melt(dat1)
dat3<-dat2[!is.na(dat2$value),]
dat3<-dat3[,1:2]
colnames(dat3)[2]<-"Site"
dat3$Species<-gsub(".*(\\d)","\\1",dat3$Species)
dat3$Site<-gsub(".*(\\d)","\\1",dat3$Site)
dat4<-dat3[,c(2,1)]
dat4
rownames(dat4)<-1:nrow(dat4)
dat4
# Site Species
#1 1 1
#2 1 3
#3 1 5
#4 2 1
#5 2 3
#6 2 4
#7 2 6
#8 3 2
#9 4 4
#10 4 5
A.K.
----- Original Message -----
From: Benjamin Gillespie <gy...@leeds.ac.uk>
To: PIKAL Petr <petr.pi...@precheza.cz>; "r-help@r-project.org"
<r-help@r-project.org>
Cc:
Sent: Monday, September 24, 2012 8:52 AM
Subject: Re: [R] List creation based on matrix
Please see the attached .csv files for further info,
Thanks guys,
Ben Gillespie
Research Postgraduate
School of Geography
University of Leeds
Leeds
LS2 9JT
Tel: +44(0)113 34 33345
Mob: +44(0)770 868 7641
http://www.geog.leeds.ac.uk/
________________________________________
From: PIKAL Petr [petr.pi...@precheza.cz]
Sent: 24 September 2012 13:39
To: Benjamin Gillespie; r-help@r-project.org
Subject: RE: [R] List creation based on matrix
Hi
> -----Original Message-----
> From: r-help-boun...@r-project.org [mailto:r-help-bounces@r-
> project.org] On Behalf Of benrgillespie
> Sent: Monday, September 24, 2012 1:20 PM
> To: r-help@r-project.org
> Subject: [R] List creation based on matrix
>
> Hi guys,
>
> It would be great if you could help me with this one...
>
> I'm looking to create a script to convert a matrix of species abundance
> e.g:
>
> <http://r.789695.n4.nabble.com/file/n4643978/species_matrix.jpg>
>
> into two vectors e.g:
>
> <http://r.789695.n4.nabble.com/file/n4643978/communitylist.jpg>
>
> ----------------
>
> If you feel there is no easy answer to this and that it would be easier
> to do in excel or open office calc (or another program), please let me
Not much can be done easier in Excel. If you do not fail to provide data you
could get better answers.
Regards
Petr
> know.
>
> Thanks in advance for your help and let me know if you require any
> further information,
>
> Ben Gillespie (Research Postgrad)
>
>
>
>
>
> --
> View this message in context: http://r.789695.n4.nabble.com/List-
> creation-based-on-matrix-tp4643978.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help@r-project.org 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.
______________________________________________
R-help@r-project.org 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.
______________________________________________
R-help@r-project.org 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.
