Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Median calculator based on id match
Top Forums UNIX for Dummies Questions & Answers Median calculator based on id match Post 302893553 by Corona688 on Wednesday 19th of March 2014 05:24:18 PM
Old 03-19-2014
That's the thing, you'd usually take the median by taking the middle value from a sorted list. An unsorted one is meaningless. Do you have GNU awk? It can sort.

Code:
printf "%s\n" 1 5 8 7 2 35 15 | awk '{A[NR]=$1 }; END { asort(A); for(X=1; X<=NR; X++) print A[X] ; printf("\n"); print A[int(NR/2)+1]; }'
1
2
5
7
8
15
35

7

$

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Split a record based on particular match

Hi , I have a requirement to split the record based on particular match using UNIX. Case1: Input Record : 10.44.48.63;"Personals/Dating;sports";1441 Output Records : 10.44.48.63;Personals/Dating;1441;Original 10.44.48.63;sports;1441;Dummy Case2: Input Record : ... (5 Replies)
Discussion started by: mksuneel
5 Replies

2. Shell Programming and Scripting

Awk based script to find the median of all individual columns in a data file

Hi All, I have some data like below. Step1,Param1,Param2,Param3 1,2,3,4 2,3,4,5 2,4,5,6 3,0,1,2 3,0,0,0 3,2,1,3 ........ so on Where I need to find the median(arithmetic) of each column from Param1...to..Param3 for each set of Step1 values. (Sort each specific column, if the... (5 Replies)
Discussion started by: ks_reddy
5 Replies

3. UNIX for Dummies Questions & Answers

Display/Cut the characters based on match

I have input file like this update tablename set column1='ABC',column2='BBC' where columnx=1 and columny=100 and columnz='10000001' update tablename set column1='ABC',column2='BBC',column3='CBC' where columnx=1 and columny=100 and columnz='10000002' update tablename set column1='ABC' where... (1 Reply)
Discussion started by: nsuresh316
1 Replies

4. Shell Programming and Scripting

Match files based on either of the two columns awk

Dear Shell experts, I have 2 files with structure: File 1: ID and count head test_GI_count1.txt 1000094 2 10039307 1 10039641 1 10047177 11 10047359 1 1008555 2 10120302 1 10120672 13 10121776 1 10121865 32 And 2nd file: head Protein_gi_GeneID_symbol.txt protein_gi GeneID... (11 Replies)
Discussion started by: smitra
11 Replies

5. UNIX for Advanced & Expert Users

Match and print based on columns

HI, I have 2 different questions in this thread. Consider 2 files as input (input file have different line count ) File 1 1 1 625 56 1 12 657 34 1 9 25 45 1 2 20 54 67 3 25 35 27 4 45 73 36 5 125 56 45 File2 1 1 878 76 1 9 83 67 2 20 73 78 4 47 22 17 3 25 67 99 (4 Replies)
Discussion started by: rossi
4 Replies

6. Shell Programming and Scripting

New files based off match or no match

Trying to match $2 in original_targets with $2 of new_targets . If the two numbers match exactly then a match.txt file is outputted using the information in the new_targets in the beginning 4 fields $1, $2, $3, $4 and value of $4 in the original_targets . If there is "No Match" then a no... (2 Replies)
Discussion started by: cmccabe
2 Replies

7. Shell Programming and Scripting

Match based on criteria to file

Trying to match $1 of target.txt to $5 of file.txt. If there is a match then in an output.txt file $1,$1 (row underneath),$6,$4,$7 from file.txt are printed on the same line as $1 of target.txt. The input is from excel and the output should be tab-deliminated. Thank you :). target.txt... (2 Replies)
Discussion started by: cmccabe
2 Replies

8. Shell Programming and Scripting

Merge lines based on match

I am trying to merge two lines to one based on some matching condition. The file is as follows: Matches filter: 'request ', timestamp, <HTTPFlow request=<GET: Matches filter: 'request ', timestamp, <HTTPFlow request=<GET: Matches filter: 'request ', timestamp, <HTTPFlow ... (8 Replies)
Discussion started by: jamie_123
8 Replies

9. Shell Programming and Scripting

awk to update file based on partial match in field1 and exact match in field2

I am trying to create a cronjob that will run on startup that will look at a list.txt file to see if there is a later version of a database using database.txt as the source. The matching lines are written to output. $1 in database.txt will be in list.txt as a partial match. $2 of database.txt... (2 Replies)
Discussion started by: cmccabe
2 Replies

10. UNIX for Beginners Questions & Answers

Data match 2 files based on first 2 columns matching only and join if match

Hi, i have 2 files , the data i need to match is in masterfile and i need to pull out column 3 from master if column 1 and 2 match and output entire row to new file I have tried with join and awk and i keep getting blank outputs or same file is there an easier way than what i am... (4 Replies)
Discussion started by: axis88
4 Replies

LEARN ABOUT DEBIAN

xliff2oo

xliff2oo(1)						      Translate Toolkit 1.9.0						       xliff2oo(1)

NAME

       xliff2oo - convert XLIFF localization files to an OpenOffice.org (SDF) localization file

SYNOPSIS

       xliff2oo  [--version]  [-h|--help]  [--manpage]	[--progress  PROGRESS] [--errorlevel ERRORLEVEL] [-i|--input] INPUT [-x|--exclude EXCLUDE]
       [-o|--output] OUTPUT [-t|--template TEMPLATE] [-l|--language LANG]  [--source-language  LANG]  [-T|--keeptimestamp]  [--nonrecursiveoutput]
       [--nonrecursivetemplate] [--skipsource] [--filteraction ACTION] [--fuzzy] [--nofuzzy] [--multifile MULTIFILESTYLE]

OPTIONS

       --version
	      show program's version number and exit

       -h/--help
	      show this help message and exit

       --manpage
	      output a manpage based on the help

       --progress
	      show progress as: dots, none, bar, names, verbose

       --errorlevel
	      show errorlevel as: none, message, exception, traceback

       -i/--input
	      read from INPUT in xlf, po, pot formats

       -x/--exclude
	      exclude names matching EXCLUDE from input paths

       -o/--output
	      write to OUTPUT in sdf, oo formats

       -t/--template
	      read from TEMPLATE in sdf, oo formats

       -l/--language
	      set target language code (e.g. af-ZA) [required]

       --source-language
	      set source language code (default en-US)

       -T/--keeptimestamp
	      don't change the timestamps of the strings

       --nonrecursiveoutput
	      don't treat the output oo as a recursive store

       --nonrecursivetemplate
	      don't treat the template oo as a recursive store

       --skipsource
	      don't output the source language, but fallback to it where needed

       --filteraction
	      action on pofilter failure: none (default), warn, exclude-serious, exclude-all

       --fuzzy
	      use translations marked fuzzy

       --nofuzzy
	      don't use translations marked fuzzy (default)

       --multifile
	      how to split po/pot files (single, toplevel or onefile)

							      Translate Toolkit 1.9.0						       xliff2oo(1)
All times are GMT -4. The time now is 02:08 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy