Sponsored Content
Top Forums Shell Programming and Scripting How to find the average,min,max ,total count? Post 302612973 by vinothsekark on Monday 26th of March 2012 01:28:39 PM
Old 03-26-2012
How to find the average,min,max ,total count?

Hi ,
Below is my sample data,I have this 8 column(A,B,C,D,E,F,G,H) in csv file.

Code:
A     , B      ,C  ,D ,E  ,F,G  ,H
 
4141,127337,24,15,20,69,72.0,-3
4141,128864,24,15,20,65,66.0,-1
4141,910053,24,15,4,4,5.0,-1
4141,910383,24,15,22,3,4.0,-1
4141,496969,24,15,14,6,-24.0,-18
4141,497237,24,15,14,4,-9.0,-5
4141,497287,24,15,14,0,-4.0,-4
 
4141,635643,27,1,7,10,16.0,-6
4141,635645,27,1,7,12,24.0,-12

4149,798509,24,15,14,4,-17.0,-13
4149,127333,24,15,20,100,108.0,-8
4149,127337,24,15,20,95,98.0,-3
4149,128864,24,15,20,76,80.0,-4
4149,910350,24,15,13,7,8.0,-1

I want the output like below in another CSV file

Code:
A , C, D,Diff_count,min(H column),max(H column),AVG(H column)
4141,24,25,7,-18,-1,-4.714
4141,27,1,2,-12,-6,-9
4149,24,15,5,-13,-1,-5.8

Can anybody help me to script in korn shell to get the above result!!
Thanks in advance.

Moderator's Comments:
Mod Comment Code tags for code, please.

Last edited by Corona688; 03-26-2012 at 02:36 PM..
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to find min, max dates in a file

hello friends...:-) i need some help i have a file cantain like this Star1 ,NetWork,09/02/2008 Star1 ,NetWork,10/02/2008 Star1 ,NetWork,11/02/2008 Star2 ,NetWork,08/03/2008 Star2 ,NetWork,09/04/2008 Star2 ,NetWork,10/05/2008 i need to find out min, max dates the output look like... (6 Replies)
Discussion started by: gemini106
6 Replies

2. Shell Programming and Scripting

get min, max and average value

hi! i have a file like the attachement. I'd like to get for each line the min, max and average values. (there is 255 values for each line) how can i get that ? i try this, is it right? BEGIN {FS = ","; OFS = ";";max=0;min=0;moy=0;total=0;freq=890} $0 !~ /Trace1:/ { ... (1 Reply)
Discussion started by: riderman
1 Replies

3. Shell Programming and Scripting

Count time min/max/average for ping

I am redirecting my ping output to a file. The sample output is like this: 64 bytes from xx.xx.xx.167: icmp_seq=4490 ttl=116 3.75 ms 2011Jul12- 15 40 16 64 bytes from xx.xx.xx.167: icmp_seq=4491 ttl=116 5.29 ms 2011Jul12- 15 40 17 64 bytes from xx.xx.xx.167: icmp_seq=4492 ttl=116 4.88 ms... (6 Replies)
Discussion started by: zorrox
6 Replies

4. Shell Programming and Scripting

to find min and max value for each column!

Hello Experts, I have got a txt files which has multiple columns, I want to get the max, min and diff (max-min) for each column in the same txt file. Example: cat file.txt a 1 4 b 2 5 c 3 6 I want ouput like: cat file.txt a 1 4 b 2 5 c 3 6 Max 3 6 Min 1 4 Diff 2 2 awk 'min=="" ||... (4 Replies)
Discussion started by: dixits
4 Replies

5. Shell Programming and Scripting

Number of elements, average value, min & max from a list of numbers using awk

Hi all, I have a list of numbers. I need an awk command to find out the numbers of elements (number of numbers, sort to speak), the average value the min and max value. Reading the list only once, with awk. Any ideas? Thanks! (5 Replies)
Discussion started by: black_fender
5 Replies

6. Shell Programming and Scripting

Average, min and max in file with header, using awk

Hi, I have a file which looks like this: FID IID MISS_PHENO N_MISS N_GENO F_MISS 12AB43131 12AB43131 N 17774 906341 0.01961 65HJ87451 65HJ87451 N 10149 906341 0.0112 43JJ21345 43JJ21345 N 2826 906341 0.003118I would... (11 Replies)
Discussion started by: kayakj
11 Replies

7. Shell Programming and Scripting

awk script to find min and max value

I need to find the max/min of columns 1 and 2 of a 2 column file what contains the special character ">". I know that this will find the max value of column 1. awk 'BEGIN {max = 0} {if ($1>max) max=$1} END {print max}' input.file But what if I needed to ignore special characters in the... (3 Replies)
Discussion started by: ncwxpanther
3 Replies

8. UNIX for Beginners Questions & Answers

How to count average and max respon time?

sorry i will revise first (1 Reply)
Discussion started by: fajar_3t3
1 Replies

9. UNIX for Beginners Questions & Answers

How to count respon time max min avg for nginx logs?

Hi All, need your help, i want count respon time max and average my nginx logs, based on hourly or minutes per api... my nginx.log sample : 10.1.1.1 - - "POST /v2/api/find/outlet/ HTTP/1.1" 200 2667 "-" "okhttp/3.12.0" "118.215.153.47" 0.178 0.178 . 10.1.1.1 - - "POST... (4 Replies)
Discussion started by: fajar_3t3
4 Replies
AMC-ANNOTE(1)						       Auto Multiple Choice						     AMC-ANNOTE(1)

NAME
AMC-annote - completed answer sheets annotation after marking for AMC multiple choice exams. SYNOPSIS
auto-multiple-choice annote --projet project-dir --data project-data-dir --fich-assoc assoc.xml [annotation options...] DESCRIPTION
The AMC-annote.pl command annotates papers scans with scores for all questions, global score and mark, resulting in JPEG files (one for each page). --projet project-dir sets the project directory. --data project-data-dir gives the directory where data files are (see for example AMC-prepare(1)). --cr project-cr-dir sets the project reports directory, where to find data capture reports prepared by AMC-analyse(1), and where to output annotated scans. Default value is project-dir/cr. --fich-noms students-list.csv sets the students list file name. --noms-encodage encoding selects an encoding for file students-list.csv (default is utf-8). --qualite qual sets JPEG quality for output files. Default value is 65. --taille-max maxsize sets the maximal size for output files (in the format widthxheight, in pixels). Default value is 1000x1500. --pointsize-nl lines sets the size of texts requiring that with this size, the number of text lines that fits on the page height must be lines. Default value is 60. --verdict header sets the text header to be printed on each first page of the students copies. This text may contain CR characters for multi-line headers. Some sequences are substituted in it: %S is replaced by the student total score. %M is replaced by the maximum total score. %s is replaced by the student mark. %m is replaced by the maximum mark. %(ID) is replaced by the student's name. %(COL) is replaced by the value of column COL in the students list for the curent student. --ch-sign nc Sets the number nc of significant digits to use when printing global mark. --symbols symbols-definition defines how boxes will be annotated. symbols-definition is a comma separated list of H-A:shape:colour constructs, where H is 0 or 1 depending on wether the box has to be checked or not, A is 0 or 1 depending on wether the box is actually checked or not, shape is one of none, circle, mark, box and coulour is a colour (name or #RGB, see ImageMagick or GraphicsMagick documentation for details). Default value is "0-0:none,0-1:circle:red,1-0:mark:red,1-1:mark:blue". --position pos sets the position of individual questions scores. pos may be 'none' (do dot write individual scores), 'marge' (write scores in the margin) or 'case' (write scores at the left of the left-most box for the question. --ecart dx sets the horizontal space to let between individual question score and the leftmost box when --position case is used. --ecart-marge x sets the x position for individual questions scores when written in the margin (in em units). --line-width lw sets the line width for symbols drwan on the scans (in pixels). Default value is 2. --indicatives bool say if indicative questions are to be annotated (use 1 for a true value; default is false). --debug file.log gives a file to fill with debugging information. AUTHORS
Alexis Bienvenue <paamc@passoire.fr> Main author Jean Berard Translation from French Georges Khaznadar Translation from French COPYRIGHT
Copyright (C) 2008-2012 Alexis Bienvenue This document can be used according to the terms of the GNU General Public License, version 2 or later. Auto Multiple Choice 1.1.1 06/19/2012 AMC-ANNOTE(1)
All times are GMT -4. The time now is 09:40 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy