Shell Programming and Scripting

head -2

sort -r file.txt > sort.txt
PRE_SIZE=""
content="middle.txt"
rm -f $content
rm -f final.txt
while read line
do
 dt=`echo $line | awk -F, '{print $1,$2}'`
 if [ "$PRE_SIZE" = "" ] || [ "$PRE_SIZE" = "$dt" ]
 then

 echo "$line" >> "${content}"
 PRE_SIZE="$dt"

 else

 cat $content | head -2 >> final.txt
 echo "$line" > "${content}"
 PRE_SIZE="$dt"

 fi

done < sort.txt
cat $content | head -2 >> final.txt

{ head -1 file; tail -n+2 file | sort -t, -k1,2 -k3nr; } | awk -F, '!T[$1,$2]++ {P=NR+1} NR<=P'
AREA,COUNTRY,RANK
A,IN,21
A,IN,7
A,MX,8
A,MX,5
B,CN,8
B,CN,6

{ head -1 file; sort -t, -k1,2 -k3nr file; } | awk -F, '!T[$1,$2]++ {P=NR+1} NR<=P'

head -1 file
tail -n+2 file | sort -t, -k1,2 -k3nr |
  while IFS=, read A C R X
    do [ "$TMP" != "$A,$C" ] && CNT=2
       [ $(( CNT-- )) -gt 0 ] && { echo $A,$C,$R      
                                   TMP="$A,$C"
                                 } 
    done

awk -F, '
        NR == 1 {
                print
                next
        }
        {
                idx = $1 FS $2
                if ( idx in A )
                {
                        if( A[idx] < $3 )
                        {
                                P[idx] = A[idx]
                                A[idx] = $3
                        }
                }
                else
                        A[idx] = $3
        }
        END {
                for ( k in A )
                        print k, A[k] RS k, P[k]
        }
' OFS=, file