search

nntrn / save

https://nntrn.github.io/save/
2 stars 0 forks source link

awk #36

Open nntrn opened 6 months ago

nntrn commented 6 months ago 
$ cat marks.txt
Dept    Name    Marks
ECE     Raj     53
ECE     Joel    72
EEE     Moi     68
CSE     Surya   81
EEE     Tia     59
ECE     Om      92
CSE     Amy     67

# average marks for each department
$ awk 'NR>1{d[$1]+=$3; c[$1]++} END{for(k in d) print k, d[k]/c[k]}' marks.txt
ECE 72.3333
EEE 63.5
CSE 74

https://learnbyexample.github.io/learn_gnuawk/control-structures.html