Shell Programming and Scripting

Hi,

I have a file with 3 columns and I want to find when the average number of rows on column 3 is a certain value. The output will be put into another file indicating the range.

Here is what I mean (file is tab separated):

Code:

hhm1  2     0
hhm1  4     0.5
hhm1  6     0.3
hhm1  8     -1.4
hhm1  10   -1
hhm2  2     2
hhm2  4     0.5
hhm2  6     0.2
hhm2  8     -0.5
hhm2  10   -1.1
hhm2  12   -1.9

I want to find when 2 rows of column 3 averages out to be -1 or less. If that is the case then the output would look like this:

Code:

hhm1  8  10   -1.2
hhm2  10  12  -1.5

Where column1 is the name, column 2 and 3 is the range and column 4 is the average of the range (average has to be -1 or less). Also would it be possible to have parameters in case I want to search for a larger range (e.g. 2-12 from column 2).

thanks

what about

Code:

hhm2  8  12  -1.2

? Do you need ANY pair of records? or ALL of them?

only for pairs

I want to set another parameter to also look at triplets but thats later on.

thanks