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

[arun]

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 <agoijman at cnia.inta.gov.ar>
To: r-help at 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 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.