awk tips

avg of column

awk '{ sum += $2; n++; } END { if (n > 0) print sum / n }'

• https://stackoverflow.com/questions/19149731/use-awk-to-find-average-of-a-column
• https://stackoverflow.com/questions/30352241/awk-average-of-n-data-in-each-column

Use bash variable

• Bash: Pass Shell Variables To awk
• How do I use shell variables in an awk script?

cut column

• Using awk to print all columns from the nth to the last

awk '{$1=$2=""; print $0}' somefile