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.
