Date and time of the report: 2024-01-25 05:00:04.919848
Analysed period: 2020-07-01 to 2024-01-25.
Bugs considered recent: Since 2024-01-04.
DONE
85
BUG_DESCRIPTION | NUM_BRANCHES | RELEASE | MODULE | TIMESTAMP | |
---|---|---|---|---|---|
0 | NS deletion takes longer than expected for bas... | 2 | [Master, v15.0] | LCM | 2023-12-20 14:13:28 |
1 | Robot testsuite heal_02 fails in a step when c... | 2 | [Master, v15.0] | Robot-tests | 2023-12-20 15:09:20 |
2 | Robot testsuite heal_03 fails when checking if... | 2 | [Master, v15.0] | Robot-tests | 2023-12-20 17:06:32 |
3 | Robot testsuite lcmop_01 fails in daily job wh... | 2 | [Master, v15.0] | Robot-tests | 2023-12-20 14:23:08 |
4 | Robot testsuite sol003_02 fails in the verific... | 2 | [Master, v15.0] | Robot-tests | 2023-12-20 13:51:33 |
5 | Unable to install OSM in air-gapped environmet | 2 | [Master, v14.0] | DEVOPS | 2023-11-02 10:16:24 |
6 | Updating a VNF instance with an NS update oper... | 3 | [Master, v14.0, v12.0] | LCM | 2023-12-12 11:11:02 |
AGE | CURRENT | Total |
---|---|---|
MODULE | ||
Bugzilla | 1 | 1 |
DEVOPS | 8 | 8 |
Documentation / Wiki | 4 | 4 |
Gerrit | 1 | 1 |
IM-NBI | 14 | 14 |
LCM | 14 | 14 |
MON | 2 | 2 |
N2VC | 1 | 1 |
OSMClient | 8 | 8 |
POL | 2 | 2 |
RO | 18 | 18 |
Robot-tests | 12 | 12 |
Total | 85 | 85 |
AGE | CURRENT | Total |
---|---|---|
VALUE | ||
OPEN-UNCONFIRMED | 73 | 73 |
CONFIRMED | 8 | 8 |
IN_PROGRESS | 4 | 4 |
Total | 85 | 85 |
NOTE: To see how a boxplot representation works, you may refer to this article.
Table with distributions of ages of currently open bugs:
MODULE | count | mean | std | min | 25% | 50% | 75% | max | |
---|---|---|---|---|---|---|---|---|---|
0 | Bugzilla | 1.0 | 841.000000 | NaN | 841.0 | 841.00 | 841.0 | 841.00 | 841.0 |
1 | DEVOPS | 8.0 | 226.375000 | 138.995311 | 63.0 | 83.00 | 256.5 | 331.00 | 407.0 |
2 | Documentation / Wiki | 4.0 | 222.000000 | 10.099505 | 216.0 | 216.00 | 217.5 | 223.50 | 237.0 |
3 | Gerrit | 1.0 | 638.000000 | NaN | 638.0 | 638.00 | 638.0 | 638.00 | 638.0 |
4 | IM-NBI | 14.0 | 140.142857 | 91.582545 | 49.0 | 75.25 | 81.5 | 234.75 | 302.0 |
5 | LCM | 14.0 | 189.642857 | 220.377162 | 35.0 | 43.00 | 74.5 | 269.75 | 770.0 |
6 | MON | 2.0 | 313.000000 | 49.497475 | 278.0 | 295.50 | 313.0 | 330.50 | 348.0 |
7 | N2VC | 1.0 | 182.000000 | NaN | 182.0 | 182.00 | 182.0 | 182.00 | 182.0 |
8 | OSMClient | 8.0 | 288.250000 | 120.793507 | 188.0 | 217.50 | 230.0 | 325.75 | 481.0 |
9 | POL | 2.0 | 75.000000 | 5.656854 | 71.0 | 73.00 | 75.0 | 77.00 | 79.0 |
10 | RO | 18.0 | 265.166667 | 241.153661 | 63.0 | 79.75 | 183.5 | 381.25 | 915.0 |
11 | Robot-tests | 12.0 | 97.583333 | 92.574745 | 35.0 | 35.00 | 35.0 | 218.00 | 237.0 |
Four types of bug age outliers are identified:
Recommendations file does not exist.
AGE | 1. Open outliers | 2. Open beyond q3 | 3. Open beyond 2 months | All |
---|---|---|---|---|
MODULE | ||||
Bugzilla | 0 | 0 | 1 | 1.0 |
DEVOPS | 0 | 2 | 6 | 8.0 |
Documentation / Wiki | 1 | 0 | 3 | 4.0 |
Gerrit | 0 | 0 | 1 | 1.0 |
IM-NBI | 1 | 2 | 10 | 13.0 |
LCM | 1 | 2 | 6 | 9.0 |
MON | 0 | 0 | 2 | 2.0 |
N2VC | 0 | 0 | 1 | 1.0 |
OSMClient | 0 | 2 | 6 | 8.0 |
POL | 0 | 1 | 1 | 2.0 |
RO | 2 | 2 | 14 | 18.0 |
Robot-tests | 0 | 1 | 3 | 4.0 |
All | 5 | 12 | 54 | 71.0 |
Too old bugs:
RECOMMENDATION | BUG_ID | BUG_DESCRIPTION | ISSUER | CREATION_TIME | CREATION_AGE | MONTH | STATE | STATE_UPDATE_TIME | STATE_UPDATE_AGE | ... | LAST_ASSIGNMENT_MONTH | LAST_ASSIGNMENT_AGE | OWNER_CHANGES | LAST_EVENT | LAST_EVENT_TIME | LAST_EVENT_AGE | LAST_EVENT_MONTH | SOLVED | BUG_RESOLUTION_TIME | TIME_SINCE_CREATION |
---|
0 rows × 29 columns
Pure outliers:
RECOMMENDATION | BUG_ID | LAST_EVENT_TIME | Time bug open (days) | count | mean | std | min | 25% | 50% | ... | OWNER | LAST_ASSIGNMENT_MONTH | LAST_ASSIGNMENT_AGE | OWNER_CHANGES | LAST_EVENT | LAST_EVENT_AGE | LAST_EVENT_MONTH | SOLVED | BUG_RESOLUTION_TIME | TIME_SINCE_CREATION | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | NaN | 2252 | 2023-08-24 16:59:46 | 237 | 4.0 | 222.000 | 10.099505 | 216.0 | 216.00 | 217.5 | ... | selvi.j@tataelxsi.co.in | 2023-08-31 23:59:59 | CURRENT | 2.0 | assigned_to | CURRENT | 2023-08-31 23:59:59.000000 | False | 0 | 237 |
1 | NaN | 2270 | 2023-11-10 08:21:04 | 194 | 8.0 | 104.250 | 49.660994 | 69.0 | 74.75 | 80.5 | ... | rahul.k4@tataelxsi.co.in | 2023-07-31 23:59:59 | CURRENT | 1.0 | comment | CURRENT | 2023-11-30 23:59:59.000000 | False | 0 | 194 |
2 | NaN | 2280 | 2024-01-18 15:39:05 | 173 | 5.0 | 86.800 | 50.021995 | 43.0 | 69.00 | 70.0 | ... | rahul.k4@tataelxsi.co.in | 2023-11-30 23:59:59 | CURRENT | 1.0 | comment | RECENT | 2024-01-25 04:00:04.948575 | False | 101 | 173 |
3 | NaN | 2281 | 2023-08-04 08:10:19 | 173 | 8.0 | 104.250 | 49.660994 | 69.0 | 74.75 | 80.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-08-31 23:59:59.000000 | False | 0 | 173 |
4 | NaN | 2284 | 2023-08-09 11:49:19 | 168 | 8.0 | 87.625 | 32.810876 | 71.0 | 74.00 | 76.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-08-31 23:59:59.000000 | False | 0 | 168 |
5 rows × 40 columns
Beyond Q3:
RECOMMENDATION | BUG_ID | LAST_EVENT_TIME | Time bug open (days) | count | mean | std | min | 25% | 50% | ... | OWNER | LAST_ASSIGNMENT_MONTH | LAST_ASSIGNMENT_AGE | OWNER_CHANGES | LAST_EVENT | LAST_EVENT_AGE | LAST_EVENT_MONTH | SOLVED | BUG_RESOLUTION_TIME | TIME_SINCE_CREATION | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | NaN | 1603 | 2023-02-15 00:00:12 | 915 | 9.0 | 421.333333 | 257.576202 | 63.0 | 281.00 | 413.0 | ... | gulsum.atici@canonical.com | 2022-03-31 23:59:59 | CURRENT | 2.0 | keywords | CURRENT | 2023-02-28 23:59:59 | False | 319 | 915 |
1 | NaN | 1830 | 2023-11-08 06:14:48 | 770 | 5.0 | 302.800000 | 300.514060 | 35.0 | 43.00 | 302.0 | ... | srojas@whitestack.com | 2023-07-31 23:59:59 | CURRENT | 3.0 | comment | CURRENT | 2023-11-30 23:59:59 | False | 581 | 770 |
2 | NaN | 2019 | 2023-12-12 08:56:06 | 636 | 9.0 | 421.333333 | 257.576202 | 63.0 | 281.00 | 413.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-12-31 23:59:59 | False | 193 | 636 |
3 | NaN | 2164 | 2023-10-17 17:21:22 | 497 | 3.0 | 224.000000 | 240.576391 | 43.0 | 87.50 | 132.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-10-31 23:59:59 | False | 138 | 497 |
4 | NaN | 2176 | 2023-10-17 16:56:24 | 481 | 6.0 | 310.000000 | 134.747171 | 188.0 | 210.00 | 256.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-10-31 23:59:59 | False | 382 | 481 |
5 | NaN | 2177 | 2023-10-17 17:02:41 | 478 | 6.0 | 310.000000 | 134.747171 | 188.0 | 210.00 | 256.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-10-31 23:59:59 | False | 379 | 478 |
6 | NaN | 2223 | 2023-03-03 13:23:34 | 331 | 2.0 | 207.000000 | 175.362482 | 83.0 | 145.00 | 207.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-03-31 23:59:59 | False | 0 | 331 |
7 | NaN | 2241 | 2023-04-28 14:57:23 | 271 | 4.0 | 227.500000 | 69.294059 | 124.0 | 223.75 | 257.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-04-30 23:59:59 | False | 0 | 271 |
8 | NaN | 2253 | 2023-08-24 16:59:30 | 237 | 8.0 | 128.875000 | 100.549117 | 35.0 | 35.00 | 126.5 | ... | selvi.j@tataelxsi.co.in | 2023-08-31 23:59:59 | CURRENT | 2.0 | cc | CURRENT | 2023-08-31 23:59:59 | False | 0 | 237 |
9 | NaN | 2299 | 2023-12-04 16:05:27 | 86 | 8.0 | 87.625000 | 32.810876 | 71.0 | 74.00 | 76.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-12-31 23:59:59 | False | 0 | 86 |
10 | NaN | 2301 | 2023-11-02 10:16:46 | 83 | 2.0 | 73.000000 | 14.142136 | 63.0 | 68.00 | 73.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-11-30 23:59:59 | False | 0 | 83 |
11 | NaN | 2305 | 2023-11-06 21:11:09 | 79 | 2.0 | 75.000000 | 5.656854 | 71.0 | 73.00 | 75.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-11-30 23:59:59 | False | 0 | 79 |
12 rows × 40 columns
Beyond 2 months:
RECOMMENDATION | BUG_ID | LAST_EVENT_TIME | Time bug open (days) | count | mean | std | min | 25% | 50% | ... | OWNER | LAST_ASSIGNMENT_MONTH | LAST_ASSIGNMENT_AGE | OWNER_CHANGES | LAST_EVENT | LAST_EVENT_AGE | LAST_EVENT_MONTH | SOLVED | BUG_RESOLUTION_TIME | TIME_SINCE_CREATION | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | NaN | 1683 | 2023-06-14 13:12:23 | 841 | 1.0 | 841.000000 | NaN | 841.0 | 841.00 | 841.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-06-30 23:59:59 | False | 617 | 841 |
1 | NaN | 2015 | 2023-06-14 14:52:04 | 638 | 1.0 | 638.000000 | NaN | 638.0 | 638.00 | 638.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-06-30 23:59:59 | False | 317 | 638 |
2 | NaN | 2093 | 2023-07-19 17:19:49 | 572 | 9.0 | 421.333333 | 257.576202 | 63.0 | 281.00 | 413.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-07-31 23:59:59 | False | 248 | 572 |
3 | NaN | 2195 | 2023-05-15 14:29:20 | 432 | 9.0 | 421.333333 | 257.576202 | 63.0 | 281.00 | 413.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-05-31 23:59:59 | False | 0 | 432 |
4 | NaN | 2200 | 2023-02-07 00:00:27 | 413 | 9.0 | 421.333333 | 257.576202 | 63.0 | 281.00 | 413.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-02-28 23:59:59 | False | 0 | 413 |
5 | NaN | 2205 | 2023-02-13 00:00:24 | 407 | 1.0 | 407.000000 | NaN | 407.0 | 407.00 | 407.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-02-28 23:59:59 | False | 0 | 407 |
6 | NaN | 2214 | 2023-03-07 05:29:42 | 364 | 5.0 | 302.800000 | 300.514060 | 35.0 | 43.00 | 302.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-03-31 23:59:59 | False | 0 | 364 |
7 | NaN | 2215 | 2023-02-13 13:26:07 | 348 | 1.0 | 348.000000 | NaN | 348.0 | 348.00 | 348.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-02-28 23:59:59 | False | 0 | 348 |
8 | NaN | 2221 | 2023-02-27 15:30:34 | 331 | 2.0 | 331.000000 | 0.000000 | 331.0 | 331.00 | 331.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-02-28 23:59:59 | False | 0 | 331 |
9 | NaN | 2222 | 2023-02-27 15:53:28 | 331 | 2.0 | 331.000000 | 0.000000 | 331.0 | 331.00 | 331.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-02-28 23:59:59 | False | 0 | 331 |
10 | NaN | 2229 | 2023-03-30 11:29:33 | 302 | 1.0 | 302.000000 | NaN | 302.0 | 302.00 | 302.0 | ... | NaN | NaT | NaN | NaN | short_desc | CURRENT | 2023-03-31 23:59:59 | False | 0 | 302 |
11 | NaN | 2230 | 2023-03-28 19:37:13 | 302 | 5.0 | 302.800000 | 300.514060 | 35.0 | 43.00 | 302.0 | ... | NaN | NaT | NaN | NaN | cc | CURRENT | 2023-03-31 23:59:59 | False | 0 | 302 |
12 | NaN | 2233 | 2023-04-13 10:02:45 | 286 | 9.0 | 421.333333 | 257.576202 | 63.0 | 281.00 | 413.0 | ... | NaN | NaT | NaN | NaN | cc | CURRENT | 2023-04-30 23:59:59 | False | 0 | 286 |
13 | NaN | 2235 | 2023-06-11 19:42:11 | 281 | 9.0 | 421.333333 | 257.576202 | 63.0 | 281.00 | 413.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-06-30 23:59:59 | False | 0 | 281 |
14 | NaN | 2238 | 2023-04-21 14:35:51 | 278 | 1.0 | 278.000000 | NaN | 278.0 | 278.00 | 278.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-04-30 23:59:59 | False | 0 | 278 |
15 | NaN | 2240 | 2023-04-24 16:52:54 | 275 | 6.0 | 310.000000 | 134.747171 | 188.0 | 210.00 | 256.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-04-30 23:59:59 | False | 0 | 275 |
16 | NaN | 2243 | 2023-05-11 09:09:17 | 258 | 4.0 | 227.500000 | 69.294059 | 124.0 | 223.75 | 257.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-05-31 23:59:59 | False | 0 | 258 |
17 | NaN | 2245 | 2023-11-27 17:49:44 | 257 | 4.0 | 227.500000 | 69.294059 | 124.0 | 223.75 | 257.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-11-30 23:59:59 | False | 0 | 257 |
18 | NaN | 2251 | 2023-08-24 16:59:52 | 237 | 6.0 | 310.000000 | 134.747171 | 188.0 | 210.00 | 256.0 | ... | selvi.j@tataelxsi.co.in | 2023-08-31 23:59:59 | CURRENT | 2.0 | assigned_to | CURRENT | 2023-08-31 23:59:59 | False | 0 | 237 |
19 | NaN | 2259 | 2023-06-15 17:15:02 | 223 | 2.0 | 223.000000 | 0.000000 | 223.0 | 223.00 | 223.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-06-30 23:59:59 | False | 0 | 223 |
20 | NaN | 2260 | 2023-06-15 17:18:45 | 223 | 2.0 | 223.000000 | 0.000000 | 223.0 | 223.00 | 223.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-06-30 23:59:59 | False | 0 | 223 |
21 | NaN | 2261 | 2023-06-21 13:01:39 | 219 | 4.0 | 222.000000 | 10.099505 | 216.0 | 216.00 | 217.5 | ... | ramerama@tataelxsi.co.in | 2023-06-30 23:59:59 | CURRENT | 1.0 | assigned_to | CURRENT | 2023-06-30 23:59:59 | False | 0 | 219 |
22 | NaN | 2263 | 2023-06-21 12:59:45 | 218 | 8.0 | 128.875000 | 100.549117 | 35.0 | 35.00 | 126.5 | ... | ramerama@tataelxsi.co.in | 2023-06-30 23:59:59 | CURRENT | 1.0 | assigned_to | CURRENT | 2023-06-30 23:59:59 | False | 0 | 218 |
23 | NaN | 2264 | 2023-06-21 12:59:58 | 218 | 8.0 | 128.875000 | 100.549117 | 35.0 | 35.00 | 126.5 | ... | ramerama@tataelxsi.co.in | 2023-06-30 23:59:59 | CURRENT | 1.0 | assigned_to | CURRENT | 2023-06-30 23:59:59 | False | 0 | 218 |
24 | NaN | 2265 | 2023-06-21 13:00:12 | 218 | 8.0 | 128.875000 | 100.549117 | 35.0 | 35.00 | 126.5 | ... | ramerama@tataelxsi.co.in | 2023-06-30 23:59:59 | CURRENT | 1.0 | assigned_to | CURRENT | 2023-06-30 23:59:59 | False | 0 | 218 |
25 | NaN | 2266 | 2023-06-22 15:10:37 | 216 | 4.0 | 222.000000 | 10.099505 | 216.0 | 216.00 | 217.5 | ... | rahul.k4@tataelxsi.co.in | 2023-06-30 23:59:59 | CURRENT | 1.0 | assigned_to | CURRENT | 2023-06-30 23:59:59 | False | 0 | 216 |
26 | NaN | 2267 | 2023-06-22 15:10:07 | 216 | 4.0 | 222.000000 | 10.099505 | 216.0 | 216.00 | 217.5 | ... | deepika.e@tataelxsi.co.in | 2023-06-30 23:59:59 | CURRENT | 1.0 | assigned_to | CURRENT | 2023-06-30 23:59:59 | False | 0 | 216 |
27 | NaN | 2269 | 2023-07-07 16:05:57 | 201 | 6.0 | 310.000000 | 134.747171 | 188.0 | 210.00 | 256.0 | ... | ramerama@tataelxsi.co.in | 2023-07-31 23:59:59 | CURRENT | 1.0 | version | CURRENT | 2023-07-31 23:59:59 | False | 0 | 201 |
28 | NaN | 2271 | 2023-07-19 18:53:57 | 194 | 9.0 | 421.333333 | 257.576202 | 63.0 | 281.00 | 413.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-07-31 23:59:59 | False | 0 | 194 |
29 | NaN | 2274 | 2023-07-20 15:08:35 | 188 | 6.0 | 310.000000 | 134.747171 | 188.0 | 210.00 | 256.0 | ... | deepika.e@tataelxsi.co.in | 2023-07-31 23:59:59 | CURRENT | 1.0 | assigned_to | CURRENT | 2023-07-31 23:59:59 | False | 0 | 188 |
30 | NaN | 2277 | 2023-07-26 11:00:06 | 182 | 1.0 | 182.000000 | NaN | 182.0 | 182.00 | 182.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-07-31 23:59:59 | False | 0 | 182 |
31 | NaN | 2278 | 2023-08-10 09:39:19 | 182 | 1.0 | 182.000000 | NaN | 182.0 | 182.00 | 182.0 | ... | guillermo.calvino@canonical.com | 2023-07-31 23:59:59 | CURRENT | 1.0 | bug_severity | CURRENT | 2023-08-31 23:59:59 | False | 0 | 182 |
32 | NaN | 2286 | 2023-09-08 11:17:57 | 147 | 1.0 | 147.000000 | NaN | 147.0 | 147.00 | 147.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-09-30 23:59:59 | False | 0 | 147 |
33 | NaN | 2287 | 2023-09-18 23:58:26 | 132 | 3.0 | 224.000000 | 240.576391 | 43.0 | 87.50 | 132.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-09-30 23:59:59 | False | 0 | 132 |
34 | NaN | 2288 | 2023-09-22 15:22:41 | 124 | 4.0 | 227.500000 | 69.294059 | 124.0 | 223.75 | 257.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-09-30 23:59:59 | False | 0 | 124 |
35 | NaN | 2298 | 2023-10-26 18:28:56 | 90 | 8.0 | 104.250000 | 49.660994 | 69.0 | 74.75 | 80.5 | ... | NaN | NaT | NaN | NaN | cc | CURRENT | 2023-10-31 23:59:59 | False | 0 | 90 |
36 | NaN | 2300 | 2023-11-02 10:16:46 | 83 | 2.0 | 207.000000 | 175.362482 | 83.0 | 145.00 | 207.0 | ... | NaN | NaT | NaN | NaN | blocked | CURRENT | 2023-11-30 23:59:59 | False | 0 | 83 |
37 | NaN | 2303 | 2023-11-09 07:37:41 | 82 | 8.0 | 104.250000 | 49.660994 | 69.0 | 74.75 | 80.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-11-30 23:59:59 | False | 0 | 82 |
38 | NaN | 2304 | 2023-12-11 15:40:49 | 79 | 5.0 | 86.800000 | 50.021995 | 43.0 | 69.00 | 70.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-12-31 23:59:59 | False | 21 | 79 |
39 | NaN | 2306 | 2023-11-16 14:53:53 | 79 | 8.0 | 104.250000 | 49.660994 | 69.0 | 74.75 | 80.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-11-30 23:59:59 | False | 0 | 79 |
40 | NaN | 2307 | 2023-11-08 12:21:22 | 77 | 8.0 | 87.625000 | 32.810876 | 71.0 | 74.00 | 76.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-11-30 23:59:59 | False | 0 | 77 |
41 | NaN | 2308 | 2023-11-14 07:28:00 | 77 | 8.0 | 87.625000 | 32.810876 | 71.0 | 74.00 | 76.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-11-30 23:59:59 | False | 0 | 77 |
42 | NaN | 2310 | 2023-11-09 14:01:03 | 76 | 8.0 | 104.250000 | 49.660994 | 69.0 | 74.75 | 80.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-11-30 23:59:59 | False | 0 | 76 |
43 | NaN | 2311 | 2023-11-09 12:04:03 | 76 | 8.0 | 87.625000 | 32.810876 | 71.0 | 74.00 | 76.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-11-30 23:59:59 | False | 0 | 76 |
44 | NaN | 2312 | 2023-11-13 06:08:30 | 75 | 8.0 | 87.625000 | 32.810876 | 71.0 | 74.00 | 76.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-11-30 23:59:59 | False | 0 | 75 |
45 | NaN | 2313 | 2023-11-14 12:17:39 | 71 | 8.0 | 87.625000 | 32.810876 | 71.0 | 74.00 | 76.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-11-30 23:59:59 | False | 0 | 71 |
46 | NaN | 2314 | 2023-11-16 10:54:53 | 71 | 8.0 | 87.625000 | 32.810876 | 71.0 | 74.00 | 76.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-11-30 23:59:59 | False | 0 | 71 |
47 | NaN | 2315 | 2023-11-16 10:54:23 | 71 | 2.0 | 75.000000 | 5.656854 | 71.0 | 73.00 | 75.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-11-30 23:59:59 | False | 0 | 71 |
48 | NaN | 2316 | 2023-11-14 18:31:37 | 71 | 8.0 | 104.250000 | 49.660994 | 69.0 | 74.75 | 80.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-11-30 23:59:59 | False | 0 | 71 |
49 | NaN | 2317 | 2023-12-14 16:00:54 | 70 | 5.0 | 86.800000 | 50.021995 | 43.0 | 69.00 | 70.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-12-31 23:59:59 | False | 29 | 70 |
50 | NaN | 2318 | 2023-11-16 16:28:43 | 69 | 8.0 | 104.250000 | 49.660994 | 69.0 | 74.75 | 80.5 | ... | NaN | NaT | NaN | NaN | short_desc | CURRENT | 2023-11-30 23:59:59 | False | 0 | 69 |
51 | NaN | 2319 | 2023-11-17 05:47:17 | 69 | 5.0 | 86.800000 | 50.021995 | 43.0 | 69.00 | 70.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-11-30 23:59:59 | False | 0 | 69 |
52 | NaN | 2320 | 2023-11-22 16:37:54 | 63 | 9.0 | 421.333333 | 257.576202 | 63.0 | 281.00 | 413.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-11-30 23:59:59 | False | 0 | 63 |
53 | NaN | 2321 | 2023-11-24 17:15:07 | 63 | 2.0 | 73.000000 | 14.142136 | 63.0 | 68.00 | 73.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-11-30 23:59:59 | False | 0 | 63 |
54 rows × 40 columns