filtering the rows in R

Question

[ashkan]

Hi Guys,

I have a .txt file in which there are 13 columns. the first one is Characters(names) and the next 12 are numbers. also there are 1000 rows. I want to filter out the rows in which even one column has the value less than 10. in other word I just need the rows with values equal or more than 10 in all columns. could you please let me know how I can do that in R?

thanks.

[Nicolas Rosewick]

not a bioinformatics question: ask in stackoverflow please : http://stackoverflow.com/

[WouterDeCoster]

While, indeed, this question isn't purely bioinformatics, it's application clearly is. I would argue the question fits here, but that's just my opinion...

Answer 1

[Devon Ryan]

d = as.data.frame(matrix(rnorm(1000, mean=20, sd=5), ncol=10))
d2 = d[which(apply(d, 1, function(x) min(x) >= 10)),]

Answer 2

[Jean-Karim Heriche]

Not really a bioinformatics question but have you looked at subset() ?

Answer 3

[ivivek_ngs]

Yes Devon is correct, since this is not a Bioinformatics question but rather on data manipulations, it is always good to expand your horizon beyond Biostars like R community help or stackoverflow. Check the link , which is a similar question like yours. The key is to subset them.