[R] Presence/ absence data from matrix to single column

[John Kane]

Try the reshape2 package. You will probablly have to install the package.  install.packages("reshape2)

with your data as xx :
library(reshape2)
melt(xx, id =c("Year", "Route", "Point"))

seems to do what you want.

John Kane
Kingston ON Canada


> -----Original Message-----
> From: agoijman at cnia.inta.gov.ar
> Sent: Sat, 6 Oct 2012 08:03:11 -0700 (PDT)
> To: r-help at r-project.org
> Subject: [R] Presence/ absence data from matrix to single column
> 
> I've been trying to reshape this database but haven't succeed at it. I
> tried
> using loops but can't get it right. I just want to reshape my database
> from
> this matrix, to the one below, with only one column of data.
> 
> Year	Route	Point	Sp1	Sp2	Sp3
> 2004	123	123-1	0	1	0
> 2004	123	123-2	0	1	1
> 2004	123	123-10	1	1	0
> 
> What I want:
> 
> Year	Route	Point
> 2004	123	123-1	Sp1	0
> 2004	123	123-2	Sp1	0
> 2004	123	123-10	Sp1	1
> 2004	123	123-1	Sp2	1
> 2004	123	123-2	Sp2	1
> 2004	123	123-10	Sp2	1
> 2004	123	123-1	Sp3	0
> 2004	123	123-2	Sp3	1
> 2004	123	123-10	Sp3	0
> 
> 
> 
> 
> --
> View this message in context:
> http://r.789695.n4.nabble.com/Presence-absence-data-from-matrix-to-single-column-tp4645271.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.

____________________________________________________________
Share photos & screenshots in seconds...
TRY FREE IM TOOLPACK at http://www.imtoolpack.com/default.aspx?rc=if1
Works in all emails, instant messengers, blogs, forums and social networks.