How to use awk command to realize summation, average, maximum and minimum
This article introduces the relevant knowledge of "how to use the awk command to achieve summation, average, maximum and minimum". In the operation of actual cases, many people will encounter such a dilemma, and then let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!
1. Summation
The code is as follows:
Cat data | awk'{sum+=$1} END {print "Sum =", sum}'
2. Find the average
The code is as follows:
Cat data | awk'{sum+=$1} END {print "Average =", sum/NR}'
3. Find the maximum value
The code is as follows:
Cat data | awk 'BEGIN {max= 0} {if ($1 > max) max=$1 fi} END {print "Max=", max}'
4. Find the minimum value (you can set a super large number for the initial value of min)
The code is as follows:
Awk 'BEGIN {min = 1999999} {if ($1)