retrieve lines with bash/awk

Dear All I have a table in this format (sep="\t"):

> head (final_results)
                row            column         cor           p
1 Eucgr.A00001.v2.0 Eucgr.A00003.v2.0  0.19259162 0.548714973
2 Eucgr.A00001.v2.0 Eucgr.A00004.v2.0  0.73894587 0.006039257
3 Eucgr.A00003.v2.0 Eucgr.A00004.v2.0 -0.05585972 0.863103037
4 Eucgr.A00001.v2.0 Eucgr.A00005.v2.0  0.63046206 0.027964074
5 Eucgr.A00003.v2.0 Eucgr.A00005.v2.0 -0.34251437 0.275780988
6 Eucgr.A00004.v2.0 Eucgr.A00005.v2.0  0.78089904 0.002716003

how I can retrieve lines with value higher than +0.9 and -0.9 in cor and below 0.05 in P columns?

Thanks

awk bash

• 646 views • link

written 7.5 years ago by Sam

Hello Sam!

We believe that this post does not fit the main topic of this site.

Pure R/bash(?)/awk(?) question. Please search StackOverflow

For this reason we have closed your question. This allows us to keep the site focused on the topics that the community can help with.

If you disagree please tell us why in a reply below, we'll be happy to talk about it.

Cheers!

• 1 views • link

written 7.5 years ago by Ram

0 answers

No answers yet.