Shell Programming and Scripting

 
cat mylist
 
First_NAME   Gender
Mike             M
Sara             F  
Raya           M
Sara           F
Fibi             F
Mike            M
Mike             M
Micheal        M

 
./myscript
 
Mike 3       
Sara  2  
Raya  1
Fibi  1
Micheal  1

sed -n '2,$p' mylist | awk '{print $1}' | sort | uniq -c | awk '{print $2,$1}' | sort -nrk2

perl -ane '($.==1)&& next; $x{$F[0]}++; END{for(keys %x){print "$_ $x{$_}\n"}}' mylist | sort -nrk2

 
$ nawk 'NR>1{a[$1" "$2]++;next}END{for(i in a){split(i,b," ");print b[1],a[i]}}' input.txt | sort -nrk2
Mike 3
Sara 2
Raya 1
Micheal 1
Fibi 1

# awk '!/NAME/{a[$1]++};END{for(i in a)print i,a[i]}' mylist|sort -nrk2
Mike 3
Sara 2
Raya 1
Micheal 1
Fibi 1