Message-ID: <1349537637.24720.YahooMailNeo@web142602.mail.bf1.yahoo.com>
Date: 2012-10-06T15:33:57Z
From: arun
Subject: Presence/ absence data from matrix to single column
In-Reply-To: <1AAB7185FA5.00000067jrkrideau@inbox.com>
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 <jrkrideau at inbox.com>
To: arun <smartpink111 at 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: 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.
>
> ______________________________________________
> 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.
>
>
> ______________________________________________
> 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.
____________________________________________________________
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!