UNIX for Dummies Questions & Answers

1 -0.1
1 0
1 0.1
2 0
2 0.2
2 -0.2

a,i = (H,i-h,i)/(sum(1-n)[(H,j -h,j)])

a,1= (0.1-(-0.1))/( 0.1-(-0.1) + 0.2-(-0.2)) = 0.2/0.6 = 0.33333..

awk     '       {if (!L[$1] && $2 < L[$1]) L[$1]=$2
                 if (!H[$1] && $2 > H[$1]) H[$1]=$2}
         END    {for (x in L) print x, L[x], H[x]}
        ' file
1 -0.1 0.1
2 -0.2 0.2

awk' {min[$1]=$2 , max[$1]=$2
         if  ($2 >= max) max=$2
         else if ($2 <= min) min = $2}
END {for (x in min) print x, min[x], max[x]}
' list

3 -1
3 1
4 -1
4 5
4 7
4 -7

awk '
        {
                if ( $1 in L )
                {
                        L[$1] = L[$1] > $2 ? $2 : L[$1]
                        H[$1] = H[$1] < $2 ? $2 : H[$1]
                }
                else
                {
                        L[$1] = $2
                        H[$1] = $2
                }
        }
        END {
                for ( k in L )
                        print k, L[k], H[k]
        }
' file

awk '
{
s[$1]+=$3;n[$1]++
if ( $1 in L )
{
L[$1] = L[$1] > $2 ? $2 : L[$1]
H[$1] = H[$1] < $2 ? $2 : H[$1]
}
else
{
L[$1] = $2
H[$1] = $2
}
}
END {
for ( k in L )
print k, (H[k] - L[k]), (SUM OF ALL (H[k] - L[k]), s[k]/n[k]
}
' list

-1 -1 10
-1 0 20
-1 1 30
0 -2 25
0 0 20
0 2 15
1 -3 21
1 0 20
1 3 19

-1 2 12 20
0 4  12 20
1 6  12 20

awk '
        {
                if ( $1 in L )
                {
                        L[$1] = L[$1] > $2 ? $2 : L[$1]
                        H[$1] = H[$1] < $2 ? $2 : H[$1]
                }
                else
                {
                        L[$1] = $2
                        H[$1] = $2
                }
                S[$1] += $3
                N[$1]++
        }
        END {
                for ( k in L )
                {
                        SL += L[k]
                        SH += H[k]
                }
                for ( k in L )
                        print k, H[k] - L[k], SH - SL, S[k] / N[k]
        }
' file