UNIX for Dummies Questions & Answers

$ cat file
id.1 A01 A01 A01 A68 A68
id.2 A5 A5 A5 A3 A3
1001 0.01 0 abc 0.136 0.136
1002 0.02 0 abc 0.262 0.183
1003 0.03 0 abc 0.662 0.662
1004 0.04 0 def 0.758 0.607
1005 0.05 0 def 0.855 0.855
1006 0.06 0 efg 0.867 0.867
1007 0 0 hij 0.872 0.692
1008 0.04 0 def 0.902 0.902
1009 0 0.06 def 0.51 0.906
1010 0 0 efg 0.51 0.906
1011 0 0.04 hij 0.51 0.969
1013 0.05 0 abc 0.07 0.743
1014 0.06 0 def 0.971 0.971
1015 0.07 0 def 0.971 0.743
1021 0 0.51 efg 0.996 0.996
1022 0 0.51 hij 0.996 0.996
1023 0 0.51 abc 0 0.995
1026 0.51 0 def 0 0.996
1027 0.51 0 poi 0 0.996
1028 0 0 sdf 0.05 0.996
$
$ awk 'NR<3{print $1, $3; next} $3 > 0.5{print $1, $3}' file
id.1 A01
id.2 A5
1021 0.51
1022 0.51
1023 0.51

 
cols_to_print="1,2"

while col_no in 3 4 5 6 7 8 9 10 ##type all columns to include in search
do
y=`cut -f ${field_no}  -d " " filename | uniq -c | sort -b -n -r | \
sed -n -e '1s/[^0-9]*\([0-9][0-9]*\).*/\1/p'`

[ $y -ge 50 ] && cols_to_print=${cols_to_print}",${col_no}"

done

cut -d " " -f ${cols_to_print}

cols_to_print="1,2"

while col_no in 3 4 5 6 7 8 9 10 ##type all columns to include in search
do
y=`cut -f ${field_no}  -d " " filename | uniq -c | sort -b -n -r | \
sed -n -e '1s/[^0-9]*\([0-9][0-9]*\).*/\1/p'`

[ $y -ge 50 ] && cols_to_print=${cols_to_print}",${col_no}"

done

cut -d " " -f ${cols_to_print} filename ## i missed the filename here.