BASH // AWK || grouping by a column and get the row with tha maximum value

… here: group by first column, select the row with maximum value in second column

 # cat $FILE | awk '{print $2" "$1}' | sort -k 2 -k 1rn | uniq -f 1 | awk '{print $2"  "$1}' 
Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s