blob: 31ec3d9d564f9ec5e9e7bbbb6c420998d8759a39 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
|
#!/bin/bash
## Description:
## output the max value of the passed 2 parameters
## Usage:
## f_max "${val1}" "${val2}"
## Example:
## max=$(f_max "1.5" "2.0")
f_max(){
local val1=$1 && shift
local val2=$1 && shift
[ -z "$val1" ] && return $val2
[ -z "$val2" ] && return $val1
local compare=$(echo "$val1>$val2"|bc)
if [ "X$compare" = "X1" ];then
echo $val1
else
echo $val2
fi
}
## Description:
## output the min value of the passed 2 parameters
## Usage:
## f_min "${val1}" "${val2}"
## Example:
## min=$(f_min "1.5" "2.0")
f_min(){
local val1=$1 && shift
local val2=$1 && shift
[ -z "$val1" ] && return $val1
[ -z "$val2" ] && return $val2
local compare=$(echo "$val1<$val2"|bc)
if [ "X$compare" = "X1" ];then
echo $val1
else
echo $val2
fi
}
## Description:
## calculate the average value for specified csv file.
## The first field of that csv file should be the key/name of that line,
## Lines have the same key should be together.
## Usage:
## statistic "${csv_file_path}" "${file_number}"
## Example:
## statistic "$f_res_starttime" 2
## Note:
## if less than 4 samples for that key/item there, average will be calculated as total/count
## if 4 or more samples for that key/item there, average will be calculated with max and min excluded
statistic(){
local f_data=$1 && shift
if ! [ -f "$f_data" ]; then
return
fi
local field_no=$1 && shift
if [ -z "$field_no" ]; then
field_no=2
fi
local total=0
local max=0
local min=0
local old_key=""
local new_key=""
local count=0
for line in $(cat "${f_data}"); do
if ! echo "$line"|grep -q ,; then
continue
fi
new_key=$(echo $line|cut -d, -f1)
value=$(echo $line|cut -d, -f${field_no})
if [ "X${new_key}" = "X${old_key}" ]; then
total=$(echo "scale=2; ${total}+${value}"|bc -s)
count=$(echo "$count + 1"|bc)
max=$(f_max "$max" "$value")
min=$(f_min "$min" "$value")
else
if [ "X${old_key}" != "X" ]; then
if [ $count -ge 4 ]; then
average=$(echo "scale=2; ($total-$max-$min)/($count-2)"|bc)
else
average=$(echo "scale=2; $total/$count"|bc)
fi
echo "$old_key=$average"
fi
total="${value}"
max="${value}"
min="${value}"
old_key="${new_key}"
count=1
fi
done
if [ "X${new_key}" != "X" ]; then
if [ $count -ge 4 ]; then
average=$(echo "scale=2; ($total-$max-$min)/($count-2)"|bc)
else
average=$(echo "scale=2; $total/$count"|bc)
fi
echo "$new_key=$average"
fi
}
|