Sort,Unique and displaying max count

Question

In the table below, Remove duplicates and for some point of time say 12:06 only maximum count value should be displayed

3/12/2013 12:00 639 Count
3/12/2013 12:06 693 Count
3/12/2013 12:12 636 Count
3/12/2013 12:18 649 Count
3/12/2013 12:24 658 Count
3/12/2013 12:30 926 Count
3/12/2013 12:36 721 Count
3/12/2013 12:42 797 Count
3/12/2013 12:48 717 Count
3/12/2013 12:00 639 Count
3/12/2013 12:06 700 Count
3/12/2013 12:12 636 Count
3/12/2013 12:18 649 Count
3/12/2013 12:24 658 Count
3/12/2013 12:30 726 Count
3/12/2013 12:36 721 Count
3/12/2013 12:42 850 Count
3/12/2013 12:48 900 Count
3/12/2013 12:00 639 Count
3/12/2013 12:06 693 Count
3/12/2013 12:12 636 Count
3/12/2013 12:18 649 Count
3/12/2013 12:24 658 Count
3/12/2013 12:30 926 Count
3/12/2013 12:36 721 Count
3/12/2013 12:42 797 Count
3/12/2013 12:48 950 Count

Output should look like below:

3/12/2013 12:00 639 Count
3/12/2013 12:06 700 Count
3/12/2013 12:12 636 Count
3/12/2013 12:18 649 Count
3/12/2013 12:24 658 Count
3/12/2013 12:30 926 Count
3/12/2013 12:36 721 Count
3/12/2013 12:42 850 Count
3/12/2013 12:48 900 Count

What have you tried so far? This is a question and answer site, and I see no question (nor any attempt to solve the problem yourself before seeking help). — FtDRbwLXw6, Mar 15 '13 at 19:55
cat Task1.txt | sort | uniq | sort -k1 | sort -um -k2.1,2.0 i tried this command and i am looking for a alternative command — user2162716, Mar 15 '13 at 20:05
@summea haha.. no! @ user2162716 lucky for you I have added two. — Chris Seymour, Mar 15 '13 at 20:06

Chris Seymour · Accepted Answer · 2013-03-15T20:02:45.790

You want sort and uniq:

$ sort -k2,2 -rk3,3  file | uniq -w15 | sort -k2,2
3/12/2013 12:00 639     Count
3/12/2013 12:06 700     Count
3/12/2013 12:12 636     Count
3/12/2013 12:18 649     Count
3/12/2013 12:24 658     Count
3/12/2013 12:30 926     Count
3/12/2013 12:36 721     Count
3/12/2013 12:42 850     Count
3/12/2013 12:48 950     Count

Or with some awk:

$ awk '{if($3>a[$1" "$2])a[$1" "$2]=$3}END{for(k in a)print k,a[k],"\tCount"}' file | sort
3/12/2013 12:00 639     Count
3/12/2013 12:06 700     Count
3/12/2013 12:12 636     Count
3/12/2013 12:18 649     Count
3/12/2013 12:24 658     Count
3/12/2013 12:30 926     Count
3/12/2013 12:36 721     Count
3/12/2013 12:42 850     Count
3/12/2013 12:48 950     Count

Sort,Unique and displaying max count

1 Answers1