Hello

My file lists a millions of SNPs with their p-values by additive, dominant, and recessive models. I want to keep the SNPs with a model for which the p-value is the lowest.

Original file.txt x,y,z,w 1,a,b,0.22 1,a,b,0.35 1,a,b,0.45 2,c,d,0.06 2,c,d,0.20 2,c,d,0.46 3,e,f,0.002 3,e,f,0.98 3,e,f,1.0

The file.txt that I want is... x,y,z,w 1,a,b,0.22 2,c,d,0.06 3,e,f,0.002

How to do this? Thanks!