Compute average ignoring outliers of different segments within a dat file using awk Post: 302917758

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

[Splitting file] Extracting group of segments from one file to others

Hi there, I need to split one huge file into separate files if the condition is fulfilled according to that the position between 97 and 98 matches with �IT� at the segment MAS. There is no delimiter file is fix-width with varous line length. Could you please help me how I do split the file...

2. Shell Programming and Scripting

using awk to print average and standard deviation into a file

Hi I want to use awk to print avg and st deviation but it does not go into a file for column 1 only. I can do average and # of records but i cannot get st deviation. awk '{sum+=$1} END { print "Average = ",sum/NR}' thanks

3. Shell Programming and Scripting

Compute the median of a set of numbers with AWK?

Is there a way in awk to compute the median of a set of numbers in a file in the following format. 34 67 78 100 23 45 67

4. Shell Programming and Scripting

Remove interspersed headers in .dat file with AWK

Heya there, A small selection of my data is shown below. DATE TIME FRAC_DAYS_SINCE_JAN1 2011-06-25 08:03:20.000 175.33564815 2011-06-25 08:03:25.000 175.33570602 2011-06-25 ...

5. Shell Programming and Scripting

awk based script to find the average of all the columns in a data file

Hi All, I need the modification for the below mentioned code (found in one more post https://www.unix.com/shell-programming-scripting/27161-script-generate-average-values.html) to find the average values for all the columns(but for a specific rows) and print the averages side by side. I have...

6. Shell Programming and Scripting

awk command on .DAT file not working?

Hi All, I am trying to run awk command on .DAT file and it is not working. The same command is working on .txt file: Contents of the file ZZ_55555555_444444_ZZZZZZ_7777777_888_99.DAT: HEADER|ZZ_55555555_444444_ZZZZZZ_7777777_888_99.DAT...

7. 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...

8. Shell Programming and Scripting

Shell or awk script to compute average of all the points within a circle

HI Help, I have a file which looks like below --- Input file ---> 1970113.00000 3460.00000 1.09516 1970116.00000 3791.00000 1.06350 1970120.00000 4120.00000 1.07588 1970115.00000 4450.00000 1.09591 1970116.00000 4780.00000 1.09965 1970120.00000 5109.00000 1.06733 ...

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. UNIX for Beginners Questions & Answers

awk to average matching lines in file

The awk below executes and is close (producing the first 4 columns in desired). However, when I add the sum of $7, I get nothing returned. Basically, I am trying to combine all the matching $4 in f1 and output them with the average of $7 in each match. Thank you :). f1 ...

LEARN ABOUT OPENSOLARIS

mlib_signalgaussnoiseinit_s16

mlib_SignalGaussNoiseInit_S16(3MLIB)			    mediaLib Library Functions			      mlib_SignalGaussNoiseInit_S16(3MLIB)

NAME

       mlib_SignalGaussNoiseInit_S16 - Gaussian noise generation

SYNOPSIS

       cc [ flag... ] file... -lmlib [ library... ]
       #include <mlib.h>

       mlib_status mlib_SignalGaussNoiseInit_S16(void **state, mlib_s16 mag,
	    mlib_f32 mean, mlib_f32 stddev, mlib_s16 seed);

DESCRIPTION

       The  mlib_SignalGaussNoiseInit_S16() function allocates memory for an internal state structure and converts the parameters into an internal
       representation.

PARAMETERS

       The function takes the following arguments:

       state	 Internal state structure.

       mag	 Magnitude of the Gaussian noise to be generated, in Q15 format.

       mean	 Mean of the Gaussian noise.

       stddev	 Standard deviation of the Gaussian noise.

       seed	 Seed value for the pseudorandom number generator.

RETURN VALUES

       The function returns MLIB_SUCCESS if successful. Otherwise it returns MLIB_FAILURE.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Committed 		   |
       +-----------------------------+-----------------------------+
       |MT-Level		     |MT-Safe			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       mlib_SignalGaussNoise_S16(3MLIB), mlib_SignalGaussNoiseFree_S16(3MLIB), attributes(5)

SunOS 5.11							    2 Mar 2007				      mlib_SignalGaussNoiseInit_S16(3MLIB)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

[Splitting file] Extracting group of segments from one file to others

Discussion started by: ozgurgul

2. Shell Programming and Scripting

using awk to print average and standard deviation into a file

Discussion started by: phil_heath

3. Shell Programming and Scripting

Compute the median of a set of numbers with AWK?

Discussion started by: Lucky Ali

4. Shell Programming and Scripting

Remove interspersed headers in .dat file with AWK

Discussion started by: gd9629