在某段内容中查找某个信息

老家的篱笆

======EVENT======
header:
        event_id = bearer_update
        event_result = success
        time_hour = 0
        time_minute = 0
        time_second = 0
        time_millisecond = 21
        duration = 83
cause_protocol = gtpv2
======EVENT======
header:
        event_id = bearer_update
        event_result = success
        time_hour = 0
        time_minute = 0
        time_second = 0
        time_millisecond = 284
        duration = 77
cause_protocol = gtpv2
cause_code = request_
======EVENT======
在======EVENT======之间统计duration

sunzhiguolu

怎么个统计法？求和，求平均，，，

老家的篱笆

sunzhiguolu 发表于 2017-01-03 22:57
怎么个统计法？求和，求平均，，，

统计time_hour ＝0的duration 的平均值

sunzhiguolu

回复 3# 老家的篱笆

1. #!/usr/bin/perl
   
2. use strict;
   
3. use warnings;
   
4. 
   
5. my ($flag, $sum, @aData) = (0, 0, ());
   
6. while (<DATA>){
   
7.     $flag = 1 if (/\A=/);
   
8.     $flag = 0 if (/time_hour\s+=\s+(\d+)/ and $1);
   
9.     push (@aData, $1) if ($flag and /duration\s+=\s+(\d+)/);
   
10. }
    
11. 
    
12. $sum += $_ for @aData;
    
13. printf ("%.2f\n", $sum / @aData);
    
14. 
    
15. __DATA__
    
16. ======EVENT======
    
17. header:
    
18.         event_id = bearer_update
    
19.         event_result = success
    
20.         time_hour = 0
    
21.         time_minute = 0
    
22.         time_second = 0
    
23.         time_millisecond = 21
    
24.         duration = 83
    
25. cause_protocol = gtpv2
    
26. ======EVENT======
    
27. header:
    
28.         event_id = bearer_update
    
29.         event_result = success
    
30.         time_hour = 0
    
31.         time_minute = 0
    
32.         time_second = 0
    
33.         time_millisecond = 284
    
34.         duration = 77
    
35. cause_protocol = gtpv2
    
36. cause_code = request_
    
37. ======EVENT======
    

复制代码

moperyblue

1. awk '/time_hour\s*=\s*0\>/{f=1;i++}f&&/duration/{s+=$3;f=0}END{print i?s/i:""}'

复制代码

zy86416779

1. [root@CentOS_6 experiment]# awk -F "=" -f test.awk test.txt
   
2. 69.5
   
3. [root@CentOS_6 experiment]# cat test.awk
   
4. BEGIN{i=0;j=0}
   
5. /header/,/cause_protocol/{
   
6.   if("time_hour"==$1){
   
7.     #printf $1 " " "\n"
   
8.     if($2==0){i=1;++j}
   
9.   }
   
10.   if(i==1){
    
11.     if("duration"==$1){array[j]=$2;i=0}
    
12.   }
    
13.   next
    
14. }
    
15. #END{printf array[1] " " array[2] "\n"}
    
16. END{print (array[1]+array[2])/length(array)}
    
17. [root@CentOS_6 experiment]# cat test.txt
    
18. ======EVENT======
    
19. header:
    
20. event_id=bearer_update
    
21. event_result=success
    
22. time_hour=0
    
23. time_minute=0
    
24. time_second=0
    
25. time_millisecond=21
    
26. duration=83
    
27. cause_protocol=gtpv2
    
28. ======EVENT======
    
29. header:
    
30. event_id=bearer_update
    
31. event_result=success
    
32. time_hour=1
    
33. time_minute=0
    
34. time_second=0
    
35. time_millisecond=284
    
36. duration=77
    
37. cause_protocol=gtpv2
    
38. cause_code=request_
    
39. ======EVENT======
    
40. header:
    
41. time_hour=0
    
42. duration=56
    
43. cause_protocol=gtpv2
    
44. ======EVENT======

复制代码

moperyblue

"EVENT"之间内容的格式是不是固定的?

zl624867243

file文件如下：

1. ======EVENT======
   
2. header:
   
3. event_id=bearer_update
   
4. event_result=success
   
5. time_hour=0
   
6. time_minute=0
   
7.   time_second=0
   
8.   time_millisecond=21
   
9.   duration=83
   
10. cause_protocol=gtpv2
    
11. ======EVENT======
    
12. header:
    
13. event_id=bearer_update
    
14. event_result=success
    
15. time_hour=1
    
16. time_minute=0
    
17. time_second=0
    
18. time_millisecond=284
    
19. duration=77
    
20. cause_protocol=gtpv2
    
21. cause_code=request_
    
22. ======EVENT======
    
23. header:
    
24. event_id=bearer_update
    
25. event_result=success
    
26. time_hour=0
    
27. time_minute=0
    
28. time_second=0
    
29. time_millisecond=284
    
30. duration=56
    
31. cause_protocol=gtpv2
    
32. ======EVENT======
    

复制代码

处理脚本如下：

1. #!/usr/bin/python
   
2. #coding:utf8
   
3. from __future__ import division
   
4. import re
   
5. 
   
6. f = open('file.txt','r')
   
7. lt = f.readlines()
   
8. num = len(lt)
   
9. y=[]
   
10. for i in range(0,num):
    
11.         if lt[i].replace("\n","") == "time_hour=0":
    
12.                 n = lt[i+4].replace("\n","").strip()
    
13.                 m = re.findall(r'\d+',n)
    
14.                 y.append(m)
    
15. z=[]
    
16. for x in y:
    
17.         aa = int(x[0])
    
18.         z.append(aa)
    
19. 
    
20. print sum(z)/len(z)
    
21. f.close()               
    
22. 
    

复制代码

zl624867243

回复 6# zy86416779

你这不符合题目要求，head 下面的文字不是对齐的

zl624867243

回复 5# moperyblue

你这符合题目要求？header下面不是对齐的。