TO find the word which occurs maximum number of times

aajan · #1 (**permalink**) 01-08-2008

Hi Folks !!!!!!!!!!!!!!!!!!!

My Requirement is.............

i have a input file:
501,501.chan
502,502.anand
503,503.biji
504,504.raja
505,505.chan
506,506.anand
507,507.chan

and my o/p should be

chan->3

i.e. the word which occurs maximum number of times in a file should be displayed..

Its Really Urgent!!!!!!!!!!!!!!!!!!!

jaduks · #2 (**permalink**) 01-08-2008

A slight weaker one :-) this will not print 2 names with same max number of occurrence

$ awk -F "." '{arr[$2]+=NF/2} END {for (i in arr) {print i"->",arr[i]}}' maxtime.out| sort -k2 | tail -1

ranjithpr · #3 (**permalink**) 01-08-2008

cut -d'.' -f2 filename|sort|uniq -c|sort|tail -1| awk '{print $2"->"$1}'

Klashxx · #4 (**permalink**) 01-08-2008

Awk solution :

Code:

> cat f1
501,501.chan
502,502.anand
503,503.biji
503,503.biji
503,503.biji
504,504.raja
505,505.chan
506,506.anand
507,507.chan

Code:

>awk  '{      
      a[$NF]++
      if ( a[$NF] >= max )
         max=a[$NF]
      }
  END {
      for ( item in a )
         if ( max == a[item] )
            print item
      }' FS="." f1
biji
chan

jaduks · #5 (**permalink**) 01-08-2008

Klashxx's solution is a good one, thanks :-)

summer_cherry · #6 (**permalink**) 01-11-2008

Hi,

I am not sure whether this one is more efficient for you.

Please try on your file, any result let all of us here know.

Code:

awk 'BEGIN{FS="."}
{
sum[$2]++
}
END{
for (i in sum)
print i"->"sum[i]
}' file > file.t
sort -t">" +1 -n file.t | tail -1
rm file.t

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Need to replace the first word of a line if it occurs again in the next line(shell)	geeko	Shell Programming and Scripting	4	06-18-2009 02:36 PM
ls - maximum number of files	karnan	UNIX for Dummies Questions & Answers	6	10-15-2008 05:56 PM
maximum number of arguments	matrixmadhan	UNIX for Dummies Questions & Answers	9	10-15-2008 05:03 PM
maximum number of times - a file can be opened	matrixmadhan	High Level Programming	3	03-21-2006 11:24 AM
Number of login times	ftengcheng	AIX	7	08-02-2005 03:35 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by