I have a big matrix with 705184 by 670 dimensions. It has columns with values less than 1 and there are also columns with values greater than 1. I would like to create a subset that has columns with values less than 1 from this big matrix. I would also like to get rid of columns with NAs. I searched for a solution online but couldn't find anything satisfactory. Below is the reprex of the code.
Thanks in advance.
library(bigmemory)
library(reprex)
Phenome <- ("D:/My Data/Academic/Research/PhD/2020/Univeristy of Bayreuth/Biomes of Southern Africa/Protected Areas/Big Matrix")
setwd(Phenome)
#Load big matrix
statsMODIS<-attach.big.matrix("D:/My Data/Academic/Research/PhD/2020/Univeristy of Bayreuth/Biomes of Southern Africa/Protected Areas/Big Matrix/statsMODIS.desc")
dim(statsMODIS)
#> [1] 705184 670
#head(statsMODIS, n = 6)
#class(statsMODIS)
#describe(statsMODIS)