avg.awk
{ sum=0;for(column=2;column<=NF;column++) sum+=$column;average[$1]=sum/(NF-1)}
END{ for( user in average) sum2+=average[user] ; print sum2/NR}
kpi.txt
user1 70 72 74 76 74 72
user2 80 82 84 82 80 78
user3 60 61 62 63 64 65
user4 90 89 88 87 64 85
user5 45 60 63 62 61 50
脚本命令执行
awk -f avg.awk kpi.txt
