Sponsored Content
Full Discussion: print average of values
Top Forums Shell Programming and Scripting print average of values Post 302575470 by agama on Monday 21st of November 2011 10:27:04 PM
Old 11-21-2011
Anything is possible, well almost Smilie

Code:
awk '
    {
        sum[$1] += $2;
        count[$1]++;
        if( max[$1] < $2 )
            max[$1] = $2;
    }

    END {
        for( x in sum )
            printf( "%s ave=%.2f  max=%d\n", x, sum[x]/count[x], max[x] );
    }
'

Prints both average and max.

---------- Post updated at 22:27 ---------- Previous update was at 22:24 ----------

Replace the printf() with this if you only want max:

Code:
printf( "%s %d\n", x,  max[x] );

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script to generate Average Values

11.60 12.35 12.49 12.99 13.09 12.91 13.48 14.16 14.18 13.23 13.17 13.15 13.71 13.35 13.12 13.00 12.79 12.83 12.54 12.89 12.89 12.47 12.94 13.00 13.41 13.09 13.09 12.09 12.76 12.93 13.67 13.14 13.01 12.39 12.78 12.86 12.61 12.50 12.11 12.98 12.90 12.77 12.56... (5 Replies)
Discussion started by: gagan.delouri
5 Replies

2. Shell Programming and Scripting

average of distinct values with awk

Hi guys, I am not an expert in shell and I need help with awk command. I have a file with values like 200 1 1 200 7 2 200 6 3 200 5 4 300 3 1 300 7 2 300 6 3 300 4 4 I need resulting file with averages of... (3 Replies)
Discussion started by: saif
3 Replies

3. Programming

javascript average from from values in radiobuttons?

Hi all, can you please help me with these part of my code, I want to calculate average grade from each module and not sure if need to label each element there, or is there any easier option to do that? appreciate your help... (0 Replies)
Discussion started by: me.
0 Replies

4. Shell Programming and Scripting

Average values in a column based on range

Hi i have data with two columns like below. I want to find average of column values like if the value in column 2 is between 0-250000 the average of column 1 is some xx and average of column2 is ww then if value is 250001-5000000 average of column 1 is yy and average of column 2 is zz. And my... (5 Replies)
Discussion started by: bhargavpbk88
5 Replies

5. Shell Programming and Scripting

Average of columns with values of other column with same name

I have a lot of input files that have the following form: Sample Cq Sample Cq Sample Cq Sample Cq Sample Cq 1WBIN 23.45 1WBIN 23.45 1CVSIN 23.96 1CVSIN 23.14 S1 31.37 1WBIN 23.53 1WBIN 23.53 1CVSIN 23.81 1CVSIN 23.24 S1 31.49 1WBIN 24.55 1WBIN 24.55 1CVSIN 23.86 1CVSIN 23.24 S1 31.74 ... (3 Replies)
Discussion started by: isildur1234
3 Replies

6. Shell Programming and Scripting

Get the average from column, and eliminate the duplicate values.

Dear Experts, Kindly help me please, I have a big file where there is duplicate values in col 11 till col 23, every 2 rows appers a new numbers, but in each row there is different coordinates x and y in col 57 till col 74. Please i will like to get a single value and average of the x and y... (8 Replies)
Discussion started by: jiam912
8 Replies

7. Shell Programming and Scripting

Calculate average of top n% of values - UNIX

Hey guys, I have several huge tab delimited files which look like this: a 1 20 a 3 15 a 5 10 b 2 15 b 6 10 c 3 23 what I am interested is to calculate the average of top n% of data in third column. So for example for this file the top 50% values are: 23 20 (Please note that it... (11 Replies)
Discussion started by: @man
11 Replies

8. Shell Programming and Scripting

Average values of duplicate rows

I have this file input.txt. I want to take average column-wise for the rows having duplicate gene names. Gene Sample_1 Sample_2 Sample_3 gene_A 2 4 5 gene_B 1 2 3 gene_A 0 5 7 gene_B 4 5 6 gene_A 11 12 13 gene_C 2 3 4 Desired output: gene_A 4.3 7 8.3 gene_B 2.5 3.5 4.5 gene_C 2 3 4... (6 Replies)
Discussion started by: Sanchari
6 Replies

9. Shell Programming and Scripting

Compute average based on field values

Im looking for a way to average the values in field 14 (when field 2 is equal to 2016) and fields 3 and 4 (when field 2 is equal to 2017). Any help is appreciated. 001001 2016 33.22 38.19 48.07 51.75 59.77 67.68 70.86 72.21 66.92 53.67 42.31 40.15 001001 2017 ... (10 Replies)
Discussion started by: ncwxpanther
10 Replies

10. UNIX for Beginners Questions & Answers

Calculate average from a given set of keys and values

Hello, I am writing a script which expects as its input a hash with student names as the keys and marks as the values. The script then returns array of average marks for student scored 60-70, 70-80, and over 90. Output expected 50-70 1 70-90 3 over 90 0 The test script so far... (4 Replies)
Discussion started by: nans
4 Replies
NGRAPH(1)						      General Commands Manual							 NGRAPH(1)

NAME
Ngraph - creating scientific 2-dimensional graphs SYNOPSIS
ngraph [options] [data file(s) or ngp file] DESCRIPTION
Ngraph is the program to create scientific 2-dimensional graphs for researchers and engineers. Graphs can be exported to PostScript, SVG, PNG or PDF format. OPTIONS
Command line options are: -L file load ngp file -x column data column for the x axis -y column data column for the y axis -X use X axis as the x axis -Y use Y axis as the y axis -U use U axis as the x axis -R use R axis as the y axis -d {mark | line | polygon | curve | diagonal | arrow | rectangle | rectangle_fill | rectangle_solid_fill | errorbar_x | errorbar_y | stair- case_x | staircase_y | bar_x | bar_y | bar_fill_x | bar_fill_y | bar_solid_fill_x | bar_solid_fill_y | fit} specify plot type -m type specify mark type (0-89) -o size specify mark size -l style specify line style -w width specify line width -CR n specify red component of the 1st plot color (0-255) -CG n specify green component of the 1st plot color (0-255) -CB n specify blue component of the 1st plot color (0-255) -cr n specify red component of the 2nd plot color (0-255) -cg n specify green component of the 2nd plot color (0-255) -cb n specify blue component of the 2nd plot color (0-255) -s line specify number of the head skip -r step specify number of the read step -f line specify number of the final line -vx n neighbor average of the x data -vy n neighbor average of the y data -mx formula specify math transformation for the x data -my formula specify math transformation for the y data -ex {linear | log | inverse | MJD} specify scale type of the x axis -ey {linear | log | inverse | MJD} specify scale type of the y axis -minx value specify minimum value of x axis -maxx value specify maximum value of x axis -incx value specify increment value of x axis -miny value specify minimum value of y axis -maxy value specify maximum value of y axis -incy value specify increment value of y axis -g load settings from data file -png file convert ngp file to PNG format -pdf file convert ngp file to PDF format -ps file convert ngp file to PostScript format -eps file convert ngp file to Encapsulated PostScript format -svg file convert ngp file to SVG format -gra file convert ngp file to GRA format -dialog show print dialog (with -p option) -p file print ngp file -n output ngp-file to stdout -h, --help show help message -v, --version show version of Ngraph -V, --VERSION show detail information about Ngraph FILES
${HOME}/.Ngraph/Ngraph.nsc start up script ${HOME}/.Ngraph/Ngraph.ini configuration file ${HOME}/.Ngraph/Ngraph.ngp default graph AUTHORS
Satoshi ISHIZAKA Hiroyuki Ito <ZXB01226@nifty.com> SEE ALSO
ngp2(1) COPYRIGHT
Copyright (C) 2003 Satoshi ISHIZAKA Copyright (C) 2008-2011 Hiroyuki Ito 4th Berkeley Distribution Local NGRAPH(1)
All times are GMT -4. The time now is 08:47 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy