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.
•
written
by
ashkan
3 answers
d = as.data.frame(matrix(rnorm(1000, mean=20, sd=5), ncol=10))
d2 = d[which(apply(d, 1, function(x) min(x) >= 10)),]
Not really a bioinformatics question but have you looked at subset() ?
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.
Log in to answer this question.
-
phylip format sequence name/header issue
written by hafiz.talhamalik
-
R - find a pattern in rows (dinucleotide:number), turn the pattern into colname and keep the number…
written by Bianca •
-
Count columns and delet specific one
written by salvatore_d •
-
To obtain upstream DNA sequence by giving location
written by bioinfo456
-
filter data based on values
written by kanwarjag
-
How to retrieve rows from OTU table
written by mollysil •
-
filtering out some elements in matrix in python
written by ashkan
-
filtering out the genes in RNA-seq experiment
written by ashkan
-
Compare one of the columns of two seperate files and write the raw of the second file next to first…
written by emre •
-
cbind with row names to spliting by Chr in R
written by viniciushs88
not a bioinformatics question: ask in stackoverflow please : http://stackoverflow.com/
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...