Shell Programming and Scripting

B0000003,1.888
B0000024,0.728
B0000024,3.308
B0000024,1.948
B0000027,1.185
B0000030,3.287
B0000030,2.688

InputFile=input_file.sort
 
    while read line
    do

        NAME=`echo $line | cut -d"," -f1`
        TIME=`echo $line | cut -d"," -f2`
 
        if [[ "$COUNT" -gt "1" ]] then
            if [[ $NAME != $PREV_NAME ]] then
               echo "$COUNT:$PREV_NAME"
               COUNT=1
            fi
        fi

 
        if [[ $NAME != $PREV_NAME ]] then
            COUNT=1
            echo "1,$NAME"
        elif [[ $NAME = $PREV_NAME ]] then
            let COUNT=$COUNT+1
        fi
 
 
        PREV_NAME=$NAME
    done <"$InputFile"

Doc Name, Duration (secs)
1,Doc Name
B0000003,0.192494
1,B0000003                         < Error
B0000003,1.740529
B0000024,5.409181
2:B0000003                         < Correct
1,B0000024                         < Error
B0000024,5.409181
1,B0000024
B0000024,5.524508
B0000024,5.569696
B0000024,6.264533
B0000027,0.265375
4:B0000024                        < Correct
1,B0000027                        < Error
B0000027,0.298291
B0000027,1.157592
etc

awk -F, '{a[$1]++;b[$1]+=$2}END{for (i in a) print i, b[i]/a[i] |"sort -n"}'  infile

B0000003 1.888
B0000024 1.99467
B0000027 1.185
B0000030 2.9875

awk -F, '
{
    if( !a[$1] )
        min[$1] = max[$1] = $2+0;   # initialise min/max on first hit of each name; adding zero ensures numeric comparison
    else
    {
        if( $2 > max[$1]  )        # capture larger/smaller values 
            max[$1] = $2+0;
        if( $2 < min[$1]  )
            min[$1] = $2+0;
    }

    a[$1]++;
    b[$1]+=$2;
}
END {
    for (i in a)
        printf( "%s %d %.3f %.3f %.3f\n", i, a[i], b[i]/a[i], min[i], max[i] ) | "sort -n"
}'  inputfile

awk -F, '{a[$1]++;b[$1]+=$2;min[$1]=(min[$1]==""||min[$1]>$2)?$2:min[$1];max[$1]=max[$1]>$2?max[$1]:$2}
    END{for (i in a) print i, a[i],b[i]/a[i],min[i],max[i] |"sort -n"}' infile

B0000003 1 1.888 1.888 1.888
B0000024 3 1.99467 0.728 3.308
B0000027 1 1.185 1.185 1.185
B0000030 2 2.9875 2.688 3.287