Create Three Column Database Form Data Frame from Sparse Data Frames
Takes a sparse matrix data frame (typical of ecological abundance data) and converts it into three column database format.
dematrify(comm, filename, sep = ",", thresh = 0)
comm |
a sparse data.frame or matrix, with samples as rows and comm as columns |
filename |
the name of the filename to produce |
sep |
the separator to use in separating columns |
thresh |
the minimum abundance to be included in the output |
The routine is pure R code to convert data from sparse matrix form to three column database form for export or reduced storage
a data.frame with the first column the sample ID, the second column the taxon ID, and the third column the abundance.
Typically, large ecological data sets are characterized by sparse matrices of taxon abundance in samples with many zeros in the matrix. Because these datasets may be many columns wide, they are difficult to work with in text editors or spreadsheets, and require excessive amount of space for storage. The reduced three column form is suitable for input to databases, and more easily edited.
library(labdsv) data(bryceveg) x <- dematrify(bryceveg)
Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.