求助计算每小时上传平均速度

wuchenlangzi

有如下的数据，要按照每个小时统计speed_upload字段的平均值，从每天的0点至23点，每个小时内的记录条数不定，有些小时内可能没有数据记录，求大神帮助
。2014-11-19 Wed  0:01:00.16 http_code: 200 speed_upload: 95138.000 time_total: 1.280
2014-11-19 Wed  0:04:00.15 http_code: 200 speed_upload: 65612.000 time_total: 1.856
2014-11-19 Wed  0:07:00.16 http_code: 200 speed_upload: 62933.000 time_total: 1.935
2014-11-19 Wed  0:10:00.22 http_code: 200 speed_upload: 64500.000 time_total: 1.888
2014-11-19 Wed  0:13:00.16 http_code: 200 speed_upload: 69706.000 time_total: 1.747
2014-11-19 Wed  1:01:00.16 http_code: 200 speed_upload: 34546.000 time_total: 3.525
2014-11-19 Wed  1:04:00.16 http_code: 200 speed_upload: 35806.000 time_total: 3.401
2014-11-19 Wed  1:07:00.17 http_code: 200 speed_upload: 72964.000 time_total: 1.669
2014-11-19 Wed  1:10:00.16 http_code: 200 speed_upload: 60047.000 time_total: 2.028
2014-11-19 Wed  1:22:00.17 http_code: 200 speed_upload: 92959.000 time_total: 1.310
2014-11-19 Wed  1:25:00.16 http_code: 200 speed_upload: 60979.000 time_total: 1.997
2014-11-19 Wed  1:28:00.15 http_code: 200 speed_upload: 77269.000 time_total: 1.576
2014-11-19 Wed  1:52:00.16 http_code: 200 speed_upload: 63992.000 time_total: 1.903
2014-11-19 Wed  1:55:00.17 http_code: 200 speed_upload: 65577.000 time_total: 1.857
2014-11-19 Wed  1:58:00.16 http_code: 200 speed_upload: 61941.000 time_total: 1.966
2014-11-19 Wed  2:01:00.17 http_code: 200 speed_upload: 88694.000 time_total: 1.373
2014-11-19 Wed  2:04:00.16 http_code: 200 speed_upload: 50052.000 time_total: 2.433
2014-11-19 Wed  2:07:00.15 http_code: 200 speed_upload: 66727.000 time_total: 1.825
2014-11-19 Wed  2:10:00.16 http_code: 200 speed_upload: 49725.000 time_total: 2.449
2014-11-19 Wed  2:43:00.16 http_code: 200 speed_upload: 54219.000 time_total: 2.246
2014-11-19 Wed  2:46:00.15 http_code: 200 speed_upload: 78871.000 time_total: 1.544
2014-11-19 Wed  2:49:00.16 http_code: 200 speed_upload: 66183.000 time_total: 1.840
2014-11-19 Wed  2:52:00.17 http_code: 200 speed_upload: 61941.000 time_total: 1.966
2014-11-19 Wed  2:55:00.18 http_code: 200 speed_upload: 49402.000 time_total: 2.465
2014-11-19 Wed  2:58:00.16 http_code: 200 speed_upload: 50031.000 time_total: 2.434
2014-11-19 Wed  3:01:00.16 http_code: 200 speed_upload: 75078.000 time_total: 1.622
2014-11-19 Wed  3:37:00.31 http_code: 200 speed_upload: 98844.000 time_total: 1.232
2014-11-19 Wed  3:40:00.34 http_code: 200 speed_upload: 40031.000 time_total: 3.042
2014-11-19 Wed  3:55:00.17 http_code: 200 speed_upload: 100063.000 time_total: 1.217
2014-11-19 Wed  3:58:00.15 http_code: 200 speed_upload: 74344.000 time_total: 1.638
2014-11-19 Wed  4:01:00.16 http_code: 200 speed_upload: 30023.000 time_total: 4.056
2014-11-19 Wed  4:04:00.15 http_code: 200 speed_upload: 35806.000 time_total: 3.401
2014-11-19 Wed  4:07:00.18 http_code: 200 speed_upload: 24938.000 time_total: 4.883
2014-11-19 Wed  4:10:00.15 http_code: 200 speed_upload: 65577.000 time_total: 1.857
2014-11-19 Wed  4:13:00.24 http_code: 200 speed_upload: 26284.000 time_total: 4.633
2014-11-19 Wed  4:16:00.17 http_code: 200 speed_upload: 62449.000 time_total: 1.950
2014-11-19 Wed  4:19:00.16 http_code: 200 speed_upload: 52041.000 time_total: 2.340
2014-11-19 Wed  5:01:00.16 http_code: 200 speed_upload: 84862.000 time_total: 1.435
2014-11-19 Wed  5:04:00.16 http_code: 200 speed_upload: 45119.000 time_total: 2.699
2014-11-19 Wed  5:07:00.17 http_code: 200 speed_upload: 13576.000 time_total: 8.970
2014-11-19 Wed  5:10:00.17 http_code: 200 speed_upload: 108439.000 time_total: 1.123
2014-11-19 Wed  5:13:00.16 http_code: 200 speed_upload: 94036.000 time_total: 1.295
2014-11-19 Wed  5:16:00.20 http_code: 504 speed_upload: 3142.000 time_total: 38.751
2014-11-19 Wed  5:19:07.02 http_code: 200 speed_upload: 8485.000 time_total: 14.352
2014-11-19 Wed  5:22:03.30 http_code: 200 speed_upload: 43367.000 time_total: 2.808
2014-11-19 Wed  5:25:00.16 http_code: 200 speed_upload: 66147.000 time_total: 1.841
2014-11-19 Wed  5:28:00.76 http_code: 200 speed_upload: 24706.000 time_total: 4.929

reyleon

浪哥, 你好

Herowinter

回复 1# wuchenlangzi

1. awk '{sub(/:.*/,"",$3);a[$3]+=$7;b[$3]++} END{for(i in a)print i,a[i]/b[i]}' i|sort -nk1,1
   
2. 0 71577.8
   
3. 1 62608
   
4. 2 61584.5
   
5. 3 77672
   
6. 4 42445.4
   
7. 5 49187.9

复制代码

reyleon

1. awk '{sub(/:.*/,"",$3)}NR>1&&k!=$3{print k,sum/n;sum=n=0}{sum+=$7;n++;k=$3}END{print k,sum/n}' file

复制代码