Shell Programming and Scripting

 DACH1 occurs 34 times with an average of 0.881541
NEB occurs 159 times with an average of 0.837628
LTBP1 occurs 46 times with an average of 0.748722

 
A           B       C
DACH1   34      0.881541  (xxx occurs xxx times with an average of xxx)
NEB       159     0.837628
LTBP1     46      0.748722

awk 'BEGIN { print "A\tB\tC"}
/^(DACH1|NEB|LTBP1) occurs/ { print $1,$3,$9,"("$0")"} ' OFS='\t' exonprobescore.txt > output.txt

 awk 'BEGIN { print "Gene\tCount\tScore"}
/^ occurs/ { print $1,$3,$9} ' OFS='\t' exonprobescore.txt > output.txt

awk 'BEGIN { print "Gene\tCount\tScore"}
NF==9 { print $1,$3,$9} ' OFS='\t' exonprobescore.txt > output.txt

awk 'BEGIN { print "Gene\tCount\tScore"}
$2=="occurs" { print $1,$3,$9} ' OFS='\t' exonprobescore.txt > output.txt

 
awk '{ N[$5]++ ; T[$5]+=$6 } END { for(X in N) printf("%s occurs %d times with an average of %f\n", X, N[X], T[X]/N[X]); }' exon.txt > score.txt | awk 'BEGIN { print "Gene\tCount\tScore"}
> $2=="occurs" { print $1,$3,$9} ' OFS='\t' score.txt > output.txt

awk '
  BEGIN{ print "Gene\tCount\tScore" > "output.txt" }
  {N[$5]++; T[$5]+=$6}
  END{
    for(X in N) {
      printf("%s occurs %d times with an average of %f\n", X, N[X], T[X]/N[X])
      printf("%s\t%d\t%f\n", X, N[X], T[X]/N[X]) > "output.txt"
    }
  }' exon.txt > score.txt