DE

↑ ↓ select, Enter open, Esc close

Calculate the average, minimum and maximum of a column

harmlessText processingalle
Adjust the values, the command updates live
user@server
awk -v c=2 'NR == 1 {min = max = $c} {s += $c; if ($c < min) min = $c; if ($c > max) max = $c} END {if (NR) printf "n=%d avg=%.2f min=%s max=%s\n", NR, s/NR, min, max}' measurements.txt

Reads the given column of each line, keeps track of the smallest and largest value and finally prints the count, the average with two decimal places, the minimum and the maximum. Suitable for measurement series, load times from logs or size lists. The file should contain data lines only.

Note: A header line skews the result, cut it off beforehand with tail -n +2 datei | awk ....

Also searched as

  • awk average of a column
  • calculate average response time command line
  • find min and max value in column linux

Related one-liners

All in Text processing

Print lines where a column value exceeds a threshold

$awk -v c=10 -v min=5000000 '$c + 0 > min + 0' /var/www/vhosts/system/example.com/logs/access_ssl_log
harmlessText processing

Sum the numbers in a column with awk

$awk -v c=10 '{s += $c} END {print s}' /var/www/vhosts/system/example.com/logs/access_ssl_log
harmlessText processing

Count requests per minute in the access log

#awk '{print substr($4, 2, 17)}' /var/www/vhosts/system/example.com/logs/access_ssl_log | sort | uniq -c | sort -rn | head -20
harmlessLogs

Extract specific fields with cut

$cut -d':' -f1,7 /etc/passwd
harmlessText processing

Filter CSV rows by the value in a column

$awk -F';' -v c=3 -v w='active' 'NR == 1 || $c == w' export.csv
harmlessText processing

Put two files side by side line by line

$paste -d ';' domains.txt ips.txt
harmlessText processing

Read first, then run.

The commands on myline.de act directly on servers, files and databases. A wrong path or placeholder can delete data irreversibly or make a server unreachable.

  • All commands are provided without warranty and are not tested on every system.
  • Understand what a command does before running it, and check every placeholder.
  • Make a backup first and, if possible, try it on a test system.
  • You run commands at your own risk. Liability for damages is excluded to the extent permitted by law.