Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to find the average,min,max ,total count?
Top Forums Shell Programming and Scripting How to find the average,min,max ,total count? Post 302613173 by chihung on Monday 26th of March 2012 10:55:49 PM
Old 03-26-2012
Try this:
Code:
#! /bin/sh

awk '
BEGIN {
        RS=""
        FS="\n"
        OFS=","
}
{
        max=-9999999
        min=9999999
        sum=0
        for(i=1;i<=NF;++i) {
                split($i,r,",")
                if (r[8]>max) { max=r[8] }
                if (r[8]<min) { min=r[8] }
                sum+=r[8]
        }
        print r[1],r[3],r[4],NF,min,max,sum/NF
}' input_file

 

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

LEARN ABOUT DEBIAN

re-pcr

RE-PCR(1)						      General Commands Manual							 RE-PCR(1)

NAME

       re-PCR -- Find sequence tagged sites (STS) in DNA sequences

SYNOPSIS

       re-PCR [-hV] -p hash-file [-g gaps] [-n mism] [-lq] [primer ...]

       re-PCR [-hV] -P hash-file [-g gaps] [-n mism] [-l] [-m margin] [-O+|-] [-C batchcnt] [-o outfile] [-r+|-] [primers-file ...]

       re-PCR [-hV] -s hash-file [-g gaps] [-n mism] [-lq] [-m margin] [-o outfile] [-r+|-] [left right lo[-hi] [...]]

       re-PCR [-hV] -S hash-file [-g gaps] [-n mism] [-lq] [-m margin] [-O+|-] [-C batchcnt] [-o outfile] [-r+|-] [stsfile ...]

DESCRIPTION

       Implements reverse searching (called Reverse e-PCR) to make it feasible to search the human genome sequence and other large genomes by per-
       forming STS and primer searches.

OPTIONS

       -p=hash-file
		 Perform primer lookup using hash-file

       -P=hash-file
		 Perform primer lookup using hash-file

       -s=hash-file
		 Perform STS lookup using hash-file

       -S=hash-file
		 Perform STS lookup using hash-file

       -n=mism	 Set max allowed mismatches per primer for lookup

       -g=gaps	 Set max allowed indels per primer for lookup

       -m=margin Set variability for STS size for lookup

       -l	 Use presize alignments (only if gaps>0)

       -G	 Print alignments in comments

       -d=min-max
		 Set default STS size

       -r=+|-	 Enable/disable reverse STS lookup

       -O=+|-	 Enable/disable syscall optimisation

       -C=batchcnt
		 Set number of STSes per batch

       -o=outfile
		 Set output file name

       -q	 Quiet (no progress indicator)

EXAMPLE

	famap -tN -b genome.famap org/chr_*.fa

	fahash -b genome.hash -w 12 -f3 ${PWD}/genome.famap

	re-PCR -s genome.hash -n1 -g1 ACTATTGATGATGA AGGTAGATGTTTTT 120-200

       See famap(1) and fahash(1)

SEE ALSO

       /usr/share/doc/ncbi-epcr/README.txt

       bioperl(1), e-pcr(1), famap(1) and fahash(1)

AUTHORS

       This manual page was written by Andreas Tille <tille@debian.org> for the Debian system (but may be used by others).  Permission is  granted
       to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2 any later version published by
       the Free Software Foundation.

       On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL.

								    April 2008								 RE-PCR(1)
All times are GMT -4. The time now is 04:06 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy