Hi all,
If I have a data frame with 3 columns as follows:
> ta
Species Depth Counts
spc_a 120 60
spc_a 140 140
spc_b 140 5
spc_b 150 4
spc_b 180 10
spc_c 180 10
spc_c 190 20
How can I turn it into a dataframe or matrix with this structure?:
120 140 140 150 180 180 190
spc_a 60 0 0 0 0 0 0
spc_a 0 140 0 0 0 0 0
spc_b 0 0 5 0 0 0 0
spc_b 0 0 0 4 0 0 0
spc_b 0 0 0 0 10 0 0
spc_c 0 0 0 0 0 10 0
spc_c 0 0 0 0 0 0 20
I tried with matrify, but this function summarized.
library(labdsv)
matrify(ta)
120 140 150 180 190
spc_a 60 140 0 0 0
spc_b 0 5 4 10 0
spc_c 0 0 0 10 20
We are looking by one function similarly to matrify but without summary.
some advice?
Thanks!!
John Ortiz
Smithsonian Tropical Research Institute
______________________________________________
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.
