calculate mode/ most common value

[rhnaeco]

Hi, does anybody know how to calculate the mode using awk or sed?

I have a 3 column file and i need to find the most common value in the 3rd column.

thanks in advance

rhnaceo

 

[vgersh99]

post a sample input and a desired output, pls!

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[rhnaeco]

example file:

a b 2
a b 2
a b 6
a b 2
a b 4
a b 2
a b 1

output:
mode=2

 

[vgersh99]

{
  a[$3]++
}
END {
    for(i in a)
         if (a[i] > freq) {most=i; freq=a[i] }
    printf("mode=%s\n", most)
}

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[rhnaeco]

Thank you vlad, most apprieciated.

rhnaeco