topic Re: about the shell script in Operating System - HP-UX

about the shell script

juno2 — Fri, 13 Mar 2015 08:17:52 GMT

I have a text file in shell , how to calculate the average of the it.

#vi abc.txt

10
20
30
40

I want to have the result 25 (100/4) , can suggest how to write the script ? thx.

P.S. This thread has been moved from HP-UX > System Administration to HP-UX > languages. - Hp ForumModerator

Re: about the shell script

Graham Cameron_1 — Mon, 27 Oct 2003 05:17:15 GMT

So long as there are no blank lines in abc.txt, this will work:

cat abc.txt|awk '
{total+=$1}
END {printf "Average = %f\n", total/NR}
'

-- Graham

Re: about the shell script

TSaliba — Mon, 27 Oct 2003 06:48:54 GMT

hi
you can try the following:

sum=0
avr=0
for i in `cat abc.txt`
do
sum=`expr $sum + $i`
done
avr=`expr $sum / 4`

echo $avr

NB: use the right single quote "`" NOT "'"

Re: about the shell script

James Specht — Mon, 27 Oct 2003 06:59:43 GMT

#!/usr/bin/sh
lines=0
total=0
avg=0
cat abc.txt|while read LINE
do
lines=$(expr $lines + 1)
total=$(expr $total + $LINE)
done
avg=$(expr $total / $lines)
echo "Total : "$total
echo "Records: "$lines
echo "Average: "$avg

--Jim

Re: about the shell script

blal — Mon, 27 Oct 2003 07:36:56 GMT

Hi

Try this

cat abc.txt |grep "^$" |awk '{a+=$NF} END {print a/NR}'

This will give u avg of n numbers.
grep "^$" is used to filter blank lines if
any otherwise which will be also counted as NR.(number of records).

check it out.
bye
baiju.

Re: about the shell script

Jean-Louis Phelix — Mon, 27 Oct 2003 09:11:53 GMT

Hi,

awk solution seems to be the simpliest one ... but just for your information, doing arithmetic operation is also simple in shell :

#!/usr/bin/sh
typeset -i TOT VAR NB
cat abc.txt | while read VAR
do
((TOT=TOT+VAR))
((NB=NB+1))
done
print $((TOT/NB))

Regards.

Re: about the shell script

juno2 — Tue, 28 Oct 2003 04:27:20 GMT

thx reply, i hv another question , how to find the highest one ? ( the result should be 40) thx in advance .

Re: about the shell script

Elmar P. Kolkman — Tue, 28 Oct 2003 04:31:34 GMT

Quite simple...

awk 'BEGIN {max=0;total=0}
{ total += $1; if (max < $1) {max=$1}}
END {printf {"Average: %d \t Maximum: %d\n",total/NR,max);}'

Re: about the shell script

Jean-Louis Phelix — Tue, 28 Oct 2003 04:57:35 GMT

Or ...

#!/usr/bin/sh
typeset -i TOT VAR NB MAX
cat a | while read VAR
do
((TOT=TOT+VAR))
((NB=NB+1))
[[ VAR -gt MAX ]] && ((MAX=VAR))
done
print "Average : $((TOT/NB)) Max : $MAX"

Regards.