Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: MODE function in awk
Top Forums Shell Programming and Scripting MODE function in awk Post 302244285 by radoulov on Tuesday 7th of October 2008 03:21:28 PM
Old 10-07-2008
Quote:
Originally Posted by jim mcnamara
radulov - it is bimodal, really. It should return a set: (1,2). I don't know what Excel does, just what statistics does. Mode is often used for data like 'birthdays of people in the room' or 'last names of people in a town' - data unlike numbers or numeric data with no real inherent meaning, just magnitude. Football (soccer) scores qualify in that category.

Thanks Jim,
I was not sure if it was supposed to return N/A or a set.
If I'm not missing something again:

Code:
% cat file
32,45,56,32,32
32,45,56,30,92
1,1,2,2
% awk -F, '{ print mode($0) }
func mode(list, sep,  n, a, i, h, m, k, f, r) {
  sep = sep ? sep : FS
  n = split(list, a, sep)
  while (++i <= n) if (++h[a[i]] > m) m = h[a[i]]
  for (k in a) m == h[a[k]] && f[a[k]]
  if (m > 1) for (k in f) r = r ? r sep k : k
  return r ? r : "#N/A"
  }' file
32
#N/A
1,2

Some awk interpreters (eg. mawk) do not support the abbreviated form func (you should use function instead).
Last edited by radoulov; 10-07-2008 at 04:58 PM..
 

10 More Discussions You Might Find Interesting

1. SuSE

Convet Linux OS from text mode to graphic mode

Hi All, I used to have my suse linux(VM) server in graphic mode but not anymore since morning. I cant rolback since i loose somuch work. Any idea how to it back to normal. Thanks (6 Replies)
Discussion started by: s_linux
6 Replies

2. Shell Programming and Scripting

Awk problem: How to express the single quote(') by using awk print function

Actually I got a list of file end with *.txt I want to use the same command apply to all the *.txt Thus I try to find out the fastest way to write those same command in a script and then want to let them run automatics. For example: I got the file below: file1.txt file2.txt file3.txt... (4 Replies)
Discussion started by: patrick87
4 Replies

3. Programming

which function copies data from user to kernel mode

when transitionaning from user to kernel mode which function copies data from user mode buffer to kernel mode? (5 Replies)
Discussion started by: rupeshkp728
5 Replies

4. UNIX for Advanced & Expert Users

What is the difference between single line mode and multiline mode in Regular expressions?

Hi All, Can please let me know what is the difference between the single line mode and multi line mode in regular expresions? Thanks, Chidhambaram B (3 Replies)
Discussion started by: chidhu.anu
3 Replies

5. Solaris

DNS service is in maintenance mode. How to bring it back to online mode?

:confused: when i tried to look the status of DNS-client, it is in maintenance mode..... Please tell me how to bring it back to online mode...PLEASE TELL ME STEP BY STEP.... PLEASE... :wall: (2 Replies)
Discussion started by: vamshigvk475
2 Replies

6. Shell Programming and Scripting

awk function

Hi all, I need to have informations in a URL : https://www.autolib.eu/stations/ Valors I need are in bold: {"charging_status": "nonexistent", "rental_status": "future", "subscription_status": "nonexistent", "station_id": 791, "address": "10 rue de Rome, 93110 Rosny-sous-Bois", "lat":... (3 Replies)
Discussion started by: roulitto
3 Replies

7. UNIX for Dummies Questions & Answers

A Freebie Text Mode Plot, (Drawing), Function...

This is probably common knowledge to the big guns but this is for newbies... This is a demo using simple plot function using bash. In a default Terminal... It clears the window, sets the cursor to the top left hand corner, draws a triangle inside the window, writes a string inside the... (0 Replies)
Discussion started by: wisecracker
0 Replies

8. Shell Programming and Scripting

awk function

hi, I have used awk command to delimit my variable. But this that not worked. Could you please let me know what need to be changed in my awk command Input: home/unix>cat test.txt DAILY.JOB CHENNAI,8388 DAILY.JOB BANGLORE,3848 DAILY.JOB TRICHY,9489 DAILY.JOB TIRUPUR,8409 code ... (9 Replies)
Discussion started by: arun888
9 Replies

9. HP-UX

From a C++ application how to find if a hpux host is in standard mode or trusted mode

is there a way for my C++ application to find out which mode the hpux OS is running in? standard mode or trusted mode. (3 Replies)
Discussion started by: einsteinBrain
3 Replies

10. Shell Programming and Scripting

Need help on awk for printing the function name inside each function

Hi, I am having script which contains many functions. Need to print each function name at the starting of the function. Like below, functionname() { echo "functionname" commands.... } I've tried like below, func=`grep "()" scriptname | cut -d "(" -f1` for i in $func do nawk -v... (4 Replies)
Discussion started by: Sumanthsv
4 Replies

LEARN ABOUT DEBIAN

tcamgr

TCATEST(1)							   Tokyo Cabinet							TCATEST(1)

NAME

       tcamgr - the command line utility of the abstract database API

DESCRIPTION

       The command `tcamgr' is a utility for test and debugging of the abstract database API and its applications.  `name' specifies the name of a
       database.  `key' specifies the key of a record.	`value' specifies the value of	a  record.   `params'  specifies  the  tuning  parameters.
       `func'  specifies  the  name  of  a function.  `arg' specifies the arguments of the function.  `dest' specifies the path of the destination
       file.

	      tcamgr create name
		     Create a database file.
	      tcamgr inform name
		     Print miscellaneous information to the standard output.
	      tcamgr put [-sx] [-sep chr] [-dk|-dc|-dai|-dad] name key value
		     Store a record.
	      tcamgr out [-sx] [-sep chr] name key
		     Remove a record.
	      tcamgr get [-sx] [-sep chr] [-px] [-pz] name key
		     Print the value of a record.
	      tcamgr list [-sep chr] [-m num] [-pv] [-px] [-fm str] name
		     Print keys of all records, separated by line feeds.
	      tcamgr optimize name params
		     Optimize a database file.
	      tcamgr misc [-sx] [-sep chr] [-px] name func [arg...]
		     Call a versatile function for miscellaneous operations.
	      tcamgr map [-fm str] name dest
		     Map records into another B+ tree database.
	      tcamgr version
		     Print the version information of Tokyo Cabinet.

       Options feature the following.

	      -sx : the input data is evaluated as a hexadecimal data string.
	      -sep chr : specify the separator of the input data.
	      -dk : use the function `tcadbputkeep' instead of `tcadbput'.
	      -dc : use the function `tcadbputcat' instead of `tcadbput'.
	      -dai : use the function `tcadbaddint' instead of `tcadbput'.
	      -dad : use the function `tcadbadddouble' instead of `tcadbput'.
	      -px : the output data is converted into a hexadecimal data string.
	      -pz : do not append line feed at the end of the output.
	      -m num : specify the maximum number of the output.
	      -pv : print values of records also.
	      -fm str : specify the prefix of keys.

       This command returns 0 on success, another on failure.

SEE ALSO

       tcatest(1), tcamttest(1), tcadb(3), tokyocabinet(3)

Man Page							    2011-02-12								TCATEST(1)
All times are GMT -4. The time now is 05:41 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy