-----Original Message-----
From: smartpink111 at yahoo.com
Sent: Sat, 6 Oct 2012 08:15:34 -0700 (PDT)
To:melt(dat1,id=c("Year","Route","Point"))
Subject: Re: [R] Presence/ absence data from matrix to single column
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.