parse csv file

How can I parse a csv file based on P.value and Adjusted.P.value.

,Term,Overlap,P.value,Adjusted.P.value,Old.P.value,Old.Adjusted.P.value,Odds.Ratio,Combined.Score,Genes
1,positive regulation of leukocyte mediated cytotoxicity (GO:0001912),15/43,9.50675988639601e-06,0.031981677891461,0,0,4.85030586541922,56.0865479873029

awk -F, '($4 <= .05) { print }' file_name.csv

What is the problem in this command?

awk csv

• 1,063 views • link

updated 3.4 years ago by Ram

• written 3.6 years ago by sharmatina189059 •

1 answer

Just simplify it as:

awk -F, '$4<=.05' file_name.csv

Alternatively:

awk -F, '{ if ( $4 <= .05 ){ print } }' file_name.csv

• 0 views • link

written 3.6 years ago by iraun