Finding most repeated entry in a column and giving the count

Shell Programming and Scripting
1

Please can you help in providing the most repeated entry in the 2nd column and give its count

Here is an input file

 
1, This , is a forum
2, This ,  is a forum
1, There , is a forum
2, This ,  is not right

Here the most repeated entry is "This" and count is 3

So output shout contain all lines with the word and look like this

 
 
This = 3 
 
1, This , is a forum
2, This ,  is a forum
2, This ,  is not right
2

Did you try googling or searching through this forum?

3

Given the unknown input file size, this is one case where I think awk followed by grep is approrprate:

#!/usr/bin/env ksh
what=$( awk ' { c[$2]++; if( c[$2] > max ) max = $2; } END { printf( "%s = %d\n", max, c[max] ); }'  input-file)
printf "%s\n\n" "$what"
grep ${what%% *}  input-file

Should also work in bash if you prefer

4

perl

open $fh,"<", "a";
while(<$fh>){
    chomp;
    my @tmp = split(",",$_);
    $hash{$tmp[1]}->{'CNT'}++;
    $hash{$tmp[1]}->{'CONTENT'}=$hash{$tmp[1]}->{'CONTENT'}."\n".$_;
}
close $fh;
my $key = (sort {$hash{$b}->{'CNT'} cmp $hash{$a}->{'CNT'}} keys %hash)[0];
print $key,"=",$hash{$key}->{'CNT'},"\n";
print $hash{$key}->{'CONTENT'};

awk:

awk -F"," '{
    cnt[$2]++
    content[$2]=sprintf("%s\n%s",content[$2],$0)
}
END{
    for(i in cnt){
        if(ind ==""){
            ind=i
            max=cnt
        }
        else{
            if(cnt>=max){
                ind=i
                max=cnt
            }
        }
    }
    print ind"="cnt[ind]
    print content[ind]
}' a
5

Thanks very much f this ,it worked

In addition Some of the lines in the same file contain the letter C: with a value
Here the value is 0

1,00: This , is a good script c:0

I want to output of the lines with top 3 highest value for c:

1,00: This , is a nice script c:9999
1,00: This , is a good script c:9998
1,00: This , is a cool script c:9000
1,00: This , is a fun script c:12

So the output should be

1,00: This , is a nice script c:9999
1,00: This , is a good script c:9998
1,00: This , is a cool script c:9000

---------- Post updated at 01:31 AM ---------- Previous update was at 12:30 AM ----------

Hi summer , Please can you help with the above