Calculating Upper Percentile for any field that is required.
For eg. the total lengths summed up coming in the top 25%
Adding top 37 values
117 20.4
131 20.1
118 19.5
109 19.4
105 19.3
122 19.2
135 19.1
107 18.3
125 18.2
130 18.2
144 18.2
143 18.2
100 18.1
120 18.1
102 18.1
124 17.8
140 17.8
136 17.7
129 17.6
139 17.5
104 17.5
141 17.4
112 17.4
148 17.3
145 17.2
115 17.2
132 17.0
128 16.9
116 16.8
110 16.8
108 16.8
137 16.8
147 16.7
103 16.6
77 16.4
52 16.4
50 16.3
111 16.3
Name: Total, dtype: float64
Calculating Lower Percentile for any field that is required.
For eg. the total lengths summed up coming in the last 15%
Adding last 22 values
41 8.4
13 8.5
38 8.9
8 8.9
42 9.1
12 9.3
22 9.4
3 9.4
2 9.4
47 9.4
45 9.5
1 9.5
9 9.6
34 9.6
35 9.6
37 9.6
6 9.7
29 9.7
30 9.7
25 9.8
49 9.9
11 10.0
7 10.1
Name: Total, dtype: float64