List creation based on matrix

If you don't have paste0() then you should upgrade to the current version of R.
---------------------------------------------------------------------------
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
---------------------------------------------------------------------------
Sent from my phone. Please excuse my brevity.

Benjamin Gillespie <gybrg at leeds.ac.uk> wrote:

>Hi Arun,
>
>I've just run through that - thanks so much, it worked perfectly.
>Learnt lots of new commands too :)
>
>Thanks for all your help - awesome!
>
>ps. the only thing I changed was to remove the '0' from the first line
>after 'paste'.
>
>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: arun [smartpink111 at yahoo.com]
>Sent: 24 September 2012 14:01
>To: Benjamin Gillespie
>Cc: PIKAL Petr; R help
>Subject: Re: [R] List creation based on matrix
>
>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 <gybrg at leeds.ac.uk>
>To: PIKAL Petr <petr.pikal at precheza.cz>; "r-help at r-project.org"
><r-help at 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.pikal at precheza.cz]
>Sent: 24 September 2012 13:39
>To: Benjamin Gillespie; r-help at r-project.org
>Subject: RE: [R] List creation based on matrix
>
>Hi
>
>> -----Original Message-----
>> From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-
>> project.org] On Behalf Of benrgillespie
>> Sent: Monday, September 24, 2012 1:20 PM
>> To: r-help at 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 at 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 at 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 at 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.