Shell Programming and Scripting

ID MINUTE TIME 
SA 17:21:34 507
SB 17:22:04 484
ST 17:24:49 431
SB 17:28:16 546
SA 17:28:35 304
SA 17:29:24 437
SY 17:36:45 521
SX 17:38:47 277
SX 17:38:59 517
SB 17:42:57 249
ST 17:43:25 587
SY 17:44:51 575
ST 17:49:31 624

ID TOTAL AVERAGE MAX-TIME MIN-TIME
SA 3 430 507 304
SB 3 470 546 249
ST 3 521 624 431
SX 2 393 517 277
SY 2 543 575 521

#!/bin/bash
echo -e "\t\tDATE\tDIR1\tDIR2\tDIR3\tDIR4\n"
for date in `awk -F, '{ print $1 }' file | sort | uniq`
 do
 printf "%20s" $date
 for dir in `awk -F, '{ print $2 }' file | sort | uniq `;
  do
    val=`grep -E "$date.*$dir" file | awk -F, '{ print $3 }'`
    printf "%8d" $val
  done
  echo -e "\n"
done

TIME_AVERAGE=`awk '{sum+=$3} END {print sum/NR}' $PURE_LOG`
TIME_MAX=`awk '$3 > max { max=$3; linea=$0 }; END { print max}' $PURE_LOG`
TIME_MIN=`awk 'BEGIN{min=512} {  if(min > $3){ min = $3 } } END{ print  min}' $PURE_LOG`
MINUTO=`cat $PURE_LOG | awk '{print $2}' | cut -c 4-5 | sort -n`
ID=`(here i stay freezed)` i will take the "uniq" id 
SUM_ID=`(here too im freeze) here i will take the sumatorie id per id
echo "
echo -e "ID\tTOTAL OPERATIONS\tTIME AVERAGE\tMAX TIME\tMIN TIME\n"

awk '{printf $ID SUM_ID TIME_AVERAGE TIME_MAX TIME_MIN}'

sort infile | 
{
  while read newid x val
  do
    case $newid in                                
      ID)    continue ;;                           
  
      "$id") count=$((count + 1))
             tot=$((tot + val))
             if [ $val -gt $max ]; then            
               max=$val
             elif [ $val -lt $min ]; then
               min=$val
             fi ;;
  
      ?*)    if [ -n "$id" ]; then                 
               printf "%s %d %d %d %d\n" "$id" $count $(( tot/count )) $max $min
             fi
             min=$val max=$val tot=$val            
             count=1
             id=$newid ;;
    esac
  done
  printf "%s %d %d %d %d\n" "$id" $count $(( tot/count )) $max $min
}