Hi John,
Thanks for your comments.
I have both packages. I am using R 2.15. May be reshape is out-of-date. I
don't load reshape2 (may be lazy to add 2 at the end) that much except when I
need dcast() .... I tried the code with only reshape2 loaded, and is getting
the same result.
A.K.
----- Original Message -----
From: John Kane <jrkrid...@inbox.com>
To: arun <smartpink...@yahoo.com>
Cc:
Sent: Saturday, October 6, 2012 11:24 AM
Subject: Re: [R] Presence/ absence data from matrix to single column
I think reshape is out of date. reshape2 has been out for about a year I think.
John Kane
Kingston ON Canada
> -----Original Message-----
> From: smartpink...@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 <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.
____________________________________________________________
TRY FREE IM TOOLPACK at http://www.imtoolpack.com/default.aspx?rc=if5
Capture screenshots, upload images, edit and send them to your friends
through IMs, post on Twitter®, Facebook®, MySpace™, LinkedIn® – FAST!
______________________________________________
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.
