UNIX for Dummies Questions & Answers

field_01        field_02        field_03        field_04        field_05       field_06 field_07        field_08
TA      T       TA      T       TA      TA      TA      T
CAA     CAA     CAA     C       CAA     CAA     CAA     C
CG      C       C       CG      C       C       C       C
T       T       T       T       T       T       T       T
AT      AT      AT      AT      A       A       A       AT
AT      A       A       A       AT      AT      AT      A
CGA     CGA     C       CGA     C       CGA     CGA     C
GTTAC   GTTAC   G       GTTAC   GTTAC   GTTAC   G       G
CAT     CAT     C       CAT     C       C       C       C
AG      AG      AG      AG      AG      AG      AG      A
AG      A       A       A       AG      AG      AG      A

awk 'BEGIN{print "count"} NR>1  {print gsub($8,"")-1}' input.txt

count
7
7
7
7
4
7
7
7
7
7
7

count
2
1
5
7
4
3
2
2
4
0
3

awk 'BEGIN{print "count"} NR>1{t=0; for(i=1; i<=7; i++) if($i==$8) t++; print t}'  file

awk 'BEGIN{print "count"} NR>1{t=0; for(i=1; i<=NF-1; i++) if($i==$NF) t++; print t}' file

awk 'BEGIN{print "count"} NR>1 {print gsub("\\<" $8 "\\>","")-1}' file

awk 'BEGIN{print "count"} NR>1 {print gsub("(^|[[:blank:]])" $8 "([[:blank:]]|$)","")-1}' file

field_01	field_02	field_03	field_04	field_05	field_06	field_07	field_08	field_09
TA	T	TA	T	TA	TA	TA	T	TA
CAA	CAA	CAA	C	CAA	CAA	CAA	C	CAA
CG	C	C	CG	C	C	C	C	CG
T	T	T	T	T	T	T	T	TA
AT	AT	AT	AT	A	A	A	AT	A
AT	A	A	A	AT	AT	AT	A	AT
CGA	CGA	C	CGA	C	CGA	CGA	C	CGA
GTTAC	GTTAC	G	GTTAC	GTTAC	GTTAC	G	G	GTTAC
CAT	CAT	C	CAT	C	C	C	C	CAT
AG	AG	AG	AG	AG	AG	AG	A	AG
AG	A	A	A	AG	AG	AG	A	AG

 awk 'BEGIN{print "count1" "\t" "count2"} NR>1 
{t=0; for(i=1; i<=7; i++) 
if($i==$8) t++; 
else if($i==$9) t++; printf("%s\t",t)} print ""}' input.txt

awk: cmd. line:1: BEGIN{print "count1" "\t" "count2"} NR>1 {t=0; for(i=1; i<=7; i++) if($i==$8) t++; else if($i==$9) t++; printf("%s\t",t)} print ""}
awk: cmd. line:1:                                                                                                                           ^ syntax error
awk: cmd. line:1: BEGIN{print "count1" "\t" "count2"} NR>1 {t=0; for(i=1; i<=7; i++) if($i==$8) t++; else if($i==$9) t++; printf("%s\t",t)} print ""}
awk: cmd. line:1:

count1      count2
2       5
1       6
5       2
7       0
4       3
3       4
2       5
2       5
4       3
0       7
3       4

awk '
  BEGIN {
    OFS="\t"
    print "count1, count2"
  } 
  NR>1 {
    t=u=0
    for(i=1; i<=7; i++) {
      if($i==$8) t++
      if($i==$9) u++
    } 
    print t,u 
  }
' file