Thread: Count average per minute using Linux / Unix shell scripts

i am doing performance analysis, so i have to do some calculation from log file. i want to count average value per minute from log file.
my log file is like this:

Code:

22:47:30.751 3
22:47:30.754 2
22:47:30.776 1
22:47:31.756 8
22:47:31.752 4
22:47:32.752 9
22:47:32.755 6
22:47:32.751 3
22:47:33.898 2
22:47:33.751 10

i can calculate column 2 average value from average of all that values, my problem is i need to calculate average value per minute from this log.
so the output will be like this:

Code:

22:47:30 3  # (3+2+1)/3
22:47:31 2
22:47:32 6
22:47:33 6

i can only calculate the average of all these values but i am having a problem to calculate it per minute value.
need help, thank you.

hi,

Code:

$ cat $yourFile
22:47:30.751 3
22:47:30.754 2
22:47:30.776 1
22:47:31.756 8
22:47:31.752 4
22:47:32.752 9
22:47:32.755 6
22:47:32.751 3
22:47:33.898 2
22:47:33.751 10

$ awk '{
   sub(/\..*/,"",$1)
   ar[$1]+=$2
   nb[$1]++
}
END{
   for(i in ar)print i" -> "ar[i]"/"nb[i]" - "ar[i]/nb[i]
}' $yourFile
22:47:33 -> 12/2 - 6
22:47:30 -> 6/3 - 2
22:47:31 -> 12/2 - 6
22:47:32 -> 18/3 - 6

wow, thanks for the script...i've created script for this work but so complicated (combination of sed and awk command) unlike your script. really helpful!