Shell Programming and Scripting

hdisk0 0
hdisk0 2
hdisk0 0
hdisk1 2
hdisk1 2
hdisk1 2
hdisk2 1
hdisk2 0
hdisk2 0

awk '{	c[$1]++; s[$1] += $2}
END {	for(i in c) print i, s[i] / c[i]}' sar.out

cat /tmp/sar.txt | grep -v -p Average |egrep "hdisk" |cut -c 14-26|sort -rn
hdisk1      2
hdisk1      0
hdisk1      0
hdisk0      2
hdisk0      0
hdisk0      0
 
A=`cat /tmp/sar.txt | grep -v -p Average |egrep "hdisk" |cut -c 14-26|sort -rn`
 
awk '{ c[$1]++; s[$1] += $2}
END { for(i in c) print i, s[i] / c[i] }' $A
awk: 0602-533 Cannot find or open file hdisk1.
 The source line number is 2.

awk '{
> c[$1]=1
> for(i=2;i<=NF;i++)
> {
>  total[$1,i]+=$i
>  count[$1,i]++
> }
> }
> END{
> for(i in c)
> {
>  printf "%s",i
>  for(j=2;count[i,j];j++)
>   printf "\t%.1f", (total[i,j]/count[i,j])
>  printf "\n"
> }
> }' sar.txt

awk '{ c[$1]++; s[$1] += $2}
END { for(i in c) print i, s[i] / c[i] }' <<< "$A"

echo "$A" | awk '{ c[$1]++; s[$1] += $2}
END { for(i in c) print i, s[i] / c[i] }'