UNIX for Dummies Questions & Answers

Land,A,091374346294,Cathay,165
Island,B,091370291502,Cathay,3325
Island,P,091366545904,Cathay,440
Island,C,091368476591,Cathay,99000
Land,A,091379924879,Cathay,0
Land,P,091378222275,Cathay,245
Water,X,091369911459,Cathay,0
Island,B,091377596759,Cathay,0
Island,P,09137679859,Cathay,80000
Island,B,091355566759,Cathay,0

Island,B,2
Land,A,1
Water,X,1

awk '{s=0; for(i=5; i<=NF; i++) if ($i ="0") s++; print $1,$2,$4,s}' FS=, OFS=, input

awk '
BEGIN { FS = OFS = ","
}
$5 == 0 {
        c[$1 FS $2]++
}
END {   for(i in c) print i, c[i]
}' input

c[$1 FS $2]++

awk -F"," '$5==0 {a=$1OFS$2OFSb; b++; print a","b}; b=0' OFS=, file_check | awk -F"," '{count[$1","$2]+=$3;} END{for(i in count)  print i" "count[i]}' OFS=,

Land,A 1
Island,B 2
Water,X 1

$ cat <<test | awk '{c[$1]++}END{for(i in c)print "index",i,"is repeated",c[i],"times"}'
1
1
2
2
3
3
3
test

index 1 is repeated 2 times
index 2 is repeated 2 times
index 3 is repeated 3 times

grep -c ",0$" file