Great, thanks, 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: Jeff Newmiller [jdnew...@dcn.davis.ca.us] Sent: 24 September 2012 15:35 To: Benjamin Gillespie; arun Cc: R help Subject: Re: [R] 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:<jdnew...@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 <gy...@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 [smartpink...@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 <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. ______________________________________________ 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.
