Hi,
Try this:
dat1<-read.table(text="
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
",header=TRUE,sep="",stringsAsFactors=FALSE)
library(reshape)
melt(dat1,id=c("Year","Route","Point"))
Year Route Point variable value
1 2004 123 123-1 Sp1 0
2 2004 123 123-2 Sp1 0
3 2004 123 123-10 Sp1 1
4 2004 123 123-1 Sp2 1
5 2004 123 123-2 Sp2 1
6 2004 123 123-10 Sp2 1
7 2004 123 123-1 Sp3 0
8 2004 123 123-2 Sp3 1
9 2004 123 123-10 Sp3 0
A.K.
----- Original Message -----
From: agoijman <agoij...@cnia.inta.gov.ar>
To: r-help@r-project.org
Cc:
Sent: Saturday, October 6, 2012 11:03 AM
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@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.
