Filter rows below a given threshold
Hey everyone,
I have a numeric matrix like this one
1 4 0.439453125
1 5 0.03662109375
1 6 0.49609375
1 9 0.4384765625
1 14 0.55322265625
1 18 1
I would like to remove all rows with a threshold <0.3 based on the 3rd column. Could you help me out? Thanks!
• 1,022 views
•
link
updated
by
Alex Reynolds
•
written
by
genomes_and_MGEs •
•
written
by
genomes_and_MGEs •
1 answer
To remove rows from a tab-delimited text file, where the third column is less than 0.3:
$ awk -v FS="\t" -v OFS="\t" '($3>=0.3)' in.txt > out.txt
• 0 views
•
link
written
by
Alex Reynolds
Log in to answer this question.
More posts like this
-
Unable to extract count matrices from multi-layered Seurat object
written by bgbs •
-
Filter numeric matrix only show large network clusters in Cytoscape
written by genomes_and_MGEs •
-
Heatmap error: 'x' must be a numeric matrix
written by adnan.sabar7865 •
-
Creating column that groups data from another columns
written by Bioinfo •
-
Problem with design for DESeq2
written by 5cantaloupe5 •
-
MGRA returns error
written by little_more •
-
Restructuring table: rows to column and interleaving columns
written by akang
-
how to compare sets using python (dealing with PDB file)
written by Jason Lin •
-
R Two matrices, extract rows based on common column
written by cara78 •
-
Split Seven Rows In Per Column
written by 2011101101 •
...tell me what you have already tried?
... ¿dime lo que has ya intentado?