Skip to content

Instantly share code, notes, and snippets.

@ottomata

ottomata/PacketLossAverager.py

Last active December 15, 2015 06:19
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ottomata/5215342 to your computer and use it in GitHub Desktop.
Save ottomata/5215342 to your computer and use it in GitHub Desktop.
Download ZIP
Packet Loss Averages
Raw
locke_loss_all_hosts.tsv
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 2 columns, instead of 3. in line 1.
2013-03-20T23:38:05 5.6856725 12.2807
2013-03-20T23:41:03 5.6853720354 8.50202
2013-03-20T23:45:01 6.74600885965 11.62791
2013-03-20T23:55:01 4.06590065217 12.93532
2013-03-21T00:00:01 6.49078443478 25.0
2013-03-21T00:10:01 4.53003 6.97674
2013-03-21T00:15:01 6.74624758621 27.83505
2013-03-21T00:25:01 4.41375275362 6.63801
2013-03-21T00:30:01 6.42837526316 21.32132
2013-03-21T00:40:01 5.11167007194 12.0
2013-03-21T00:45:01 6.84608243478 31.57895
2013-03-21T00:55:01 4.71227130435 6.91489
2013-03-21T01:00:01 6.55231421053 7.47155
2013-03-21T01:10:01 4.7111207971 5.47264
2013-03-21T01:15:01 6.20856781513 24.60317
2013-03-21T01:25:01 5.01699115108 8.8729
2013-03-21T01:30:02 7.21445201681 31.57895
2013-03-21T01:40:02 4.98698992754 13.74663
2013-03-21T01:45:01 6.49490286957 21.95122
2013-03-21T01:55:01 3.98805391304 6.87361
2013-03-21T02:00:01 6.8219392437 23.80952
2013-03-21T02:10:01 4.54631724638 6.56566
2013-03-21T02:15:01 6.63148637931 19.43128
2013-03-21T02:25:01 4.73802108696 4.96029
2013-03-21T02:30:01 7.22650444444 31.03448
2013-03-21T02:40:01 4.83151094203 10.91314
2013-03-21T02:45:01 6.56067162791 21.14695
2013-03-21T02:54:50 4.99192678571 14.49086
2013-03-21T03:00:01 6.43340283465 20.0
2013-03-21T03:10:01 4.29108072464 8.4507
2013-03-21T03:15:01 6.56577898438 19.23077
2013-03-21T03:25:01 4.38238956522 5.63812
2013-03-21T03:30:01 6.52300702479 16.0
2013-03-21T03:40:01 3.88174217391 3.07329
2013-03-21T03:45:01 6.38613461538 12.61219
2013-03-21T03:55:01 4.59740208633 9.77444
2013-03-21T04:00:01 6.42242974576 19.02834
2013-03-21T04:10:01 3.88860964029 6.32911
2013-03-21T04:15:01 6.92892232759 43.87755
2013-03-21T04:25:01 4.52805876812 7.6087
2013-03-21T04:30:01 6.48050486957 29.64824
2013-03-21T04:40:01 4.99802702899 16.89751
2013-03-21T04:45:01 6.55323101695 26.82927
2013-03-21T04:55:01 4.07965144928 9.02256
2013-03-21T05:00:01 6.11539333333 4.9545
2013-03-21T05:10:01 4.72930884058 11.44708
2013-03-21T05:15:01 6.54208634783 19.64286
2013-03-21T05:25:01 4.12534275362 8.37696
2013-03-21T05:30:01 6.55759094017 34.42623
2013-03-21T05:40:01 4.40789654676 5.43735
2013-03-21T05:45:01 6.32704219298 9.43396
2013-03-21T05:55:01 5.16140072464 12.32227
2013-03-21T06:00:02 6.28793299145 41.17647
2013-03-21T06:10:01 3.93685753623 7.14286
2013-03-21T06:15:01 6.61463168067 24.5283
2013-03-21T06:25:01 4.93908463768 14.41441
2013-03-21T06:30:01 6.38598128 25.61983
2013-03-21T06:40:01 4.953265 17.64706
2013-03-21T06:45:02 6.9181574359 28.90995
2013-03-21T06:55:02 4.7105605036 13.54467
2013-03-21T07:00:01 6.66691825 19.83122
2013-03-21T07:10:01 4.80789449275 19.42149
2013-03-21T07:15:01 6.6332942735 28.1768
2013-03-21T07:25:01 4.97377347826 14.79821
2013-03-21T07:30:01 7.08094305085 40.54054
2013-03-21T07:40:01 5.17949586957 14.57286
2013-03-21T07:45:01 6.868807 25.3112
2013-03-21T07:55:01 5.20732681159 14.85149
2013-03-21T08:00:01 6.27167372881 23.80952
2013-03-21T08:10:01 4.47612927536 7.69231
2013-03-21T08:15:01 6.64414416 15.70881
2013-03-21T08:25:01 3.85688592857 6.66667
2013-03-21T08:30:01 6.38540918699 15.38462
2013-03-21T08:40:01 4.44950913043 7.26817
2013-03-21T08:45:01 5.95078639344 12.0
2013-03-21T08:55:01 4.50231695652 9.85325
2013-03-21T09:00:01 6.5754697561 17.91045
2013-03-21T09:10:01 4.3483842029 6.32911
2013-03-21T09:15:01 6.32267811475 14.0625
2013-03-21T09:25:01 4.63953 8.14196
2013-03-21T09:30:01 6.65630349206 30.131
2013-03-21T09:40:01 4.42659768116 8.32966
2013-03-21T09:45:01 6.62423765217 13.04348
2013-03-21T09:55:01 5.11131086957 12.01717
2013-03-21T10:00:01 5.91228958678 19.11765
2013-03-21T10:10:01 5.02528942446 13.13559
2013-03-21T10:15:01 6.80214416667 23.40426
2013-03-21T10:25:01 4.76314275362 9.09091
2013-03-21T10:30:01 7.18673344538 33.8843
2013-03-21T10:40:01 5.02205292857 21.4876
2013-03-21T10:45:01 6.53894675 14.63415
2013-03-21T10:55:01 5.24087913669 12.85403
2013-03-21T11:00:01 7.51771943548 34.88372
2013-03-21T11:10:01 4.89661536232 11.2426
2013-03-21T11:15:01 6.47184016807 32.64249
2013-03-21T11:25:01 3.85529171429 5.34979
2013-03-21T11:30:01 6.68830016667 26.07004
2013-03-21T11:40:01 4.67638333333 10.13072
2013-03-21T11:45:01 6.53344456897 16.66667
2013-03-21T11:55:01 4.70878374101 8.86076
2013-03-21T12:00:01 6.4646425641 23.40426
2013-03-21T12:10:01 4.74527826087 9.66387
2013-03-21T12:15:01 6.0960272 14.89362
2013-03-21T12:25:01 4.2283934058 9.50226
2013-03-21T12:30:01 6.26186808 25.0
2013-03-21T12:40:01 4.55425328571 13.55599
2013-03-21T12:45:02 6.83937783333 17.03057
2013-03-21T12:55:02 5.14768928058 10.84337
2013-03-21T13:00:02 5.94925253968 12.5
2013-03-21T13:10:02 5.20829355072 14.09692
2013-03-21T13:15:01 6.67946959677 31.03448
2013-03-21T13:25:01 4.8206642029 13.7931
2013-03-21T13:30:01 6.78598991935 18.66029
2013-03-21T13:40:01 4.22455021583 6.61479
2013-03-21T13:45:01 6.38853793103 14.52991
2013-03-21T13:55:01 4.8034671223 7.89474
2013-03-21T14:00:01 7.24787438017 28.96175
2013-03-21T14:10:01 4.9474123741 7.03518
2013-03-21T14:15:01 6.63992306452 20.35398
2013-03-21T14:25:01 4.50643565217 9.54774
2013-03-21T14:30:02 7.3623554918 28.0
2013-03-21T14:40:01 4.57802434783 6.92641
2013-03-21T14:45:01 7.24798788136 27.03863
2013-03-21T14:55:01 4.71170417266 8.52391
2013-03-21T15:00:01 6.47998017094 21.56863
2013-03-21T15:10:01 5.39310597122 12.32877
2013-03-21T15:15:01 6.65787991525 20.79208
2013-03-21T15:25:01 4.49999188406 10.19417
2013-03-21T15:30:01 6.53289418803 23.44498
2013-03-21T15:40:01 5.22689231884 9.95261
2013-03-21T15:45:01 6.05027565217 6.10125
2013-03-21T15:55:01 4.49048282609 8.60215
2013-03-21T16:00:01 6.99541694915 34.88372
2013-03-21T16:10:01 4.62203431655 8.46682
2013-03-21T16:15:01 6.63884453782 20.93023
2013-03-21T16:25:01 5.02147876812 13.70558
2013-03-21T16:30:01 6.85931042373 28.93401
2013-03-21T16:40:01 4.3704942029 10.44776
2013-03-21T16:45:01 6.84672152542 30.23256
2013-03-21T16:55:02 5.24735114286 14.70588
2013-03-21T17:00:01 6.51474491379 18.26923
2013-03-21T17:10:01 5.10426275362 11.29032
2013-03-21T17:15:01 6.29980447368 5.69173
2013-03-21T17:25:01 4.79408589928 12.77259
2013-03-21T17:30:01 6.100325 6.20032
2013-03-21T17:40:01 4.65539921429 9.27022
2013-03-21T17:45:01 6.69376693548 20.39801
2013-03-21T17:55:01 4.37991669118 12.12121
2013-03-21T18:00:01 6.57334258929 6.03514
2013-03-21T18:10:01 5.36708740741 9.63855
2013-03-21T18:15:02 6.25878508929 8.41889
Raw
locke_loss_no_sq_hosts.tsv
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 2 columns, instead of 3. in line 1.
2013-03-20T23:38:05 5.6856725 12.2807
2013-03-20T23:41:03 12.57907 66.55727
2013-03-20T23:45:01 14.0916290566 66.94763
2013-03-20T23:55:01 13.7427161111 66.62393
2013-03-21T00:00:01 13.5922520755 66.82662
2013-03-21T00:10:01 13.6836235185 66.53547
2013-03-21T00:15:01 13.5162703774 66.59416
2013-03-21T00:25:01 13.476887037 66.80672
2013-03-21T00:30:01 14.021715283 66.72472
2013-03-21T00:40:01 13.2884859259 66.72946
2013-03-21T00:45:01 14.1479766038 66.76077
2013-03-21T00:55:01 13.3482477778 66.62999
2013-03-21T01:00:01 13.7404428302 66.75375
2013-03-21T01:10:01 13.9482859259 66.72669
2013-03-21T01:15:01 14.5759734615 66.75811
2013-03-21T01:25:01 13.6253818519 66.67793
2013-03-21T01:30:02 14.5512488889 66.93175
2013-03-21T01:40:02 14.1992198148 66.84037
2013-03-21T01:45:01 14.0050254717 66.91176
2013-03-21T01:55:01 13.498372963 66.79675
2013-03-21T02:00:01 14.08787 66.61316
2013-03-21T02:10:01 13.7841188679 66.6633
2013-03-21T02:15:01 13.9016288889 66.31956
2013-03-21T02:25:01 13.6151157407 66.64463
2013-03-21T02:30:01 14.4599358491 66.95805
2013-03-21T02:40:01 13.2786746296 66.82446
2013-03-21T02:45:01 13.9463475472 66.67237
2013-03-21T02:54:50 13.4417696296 66.65097
2013-03-21T03:00:01 13.6591674074 66.61108
2013-03-21T03:10:01 13.6758216667 66.64593
2013-03-21T03:15:01 13.8147158491 66.6388
2013-03-21T03:25:01 13.316367037 66.27242
2013-03-21T03:30:01 13.6334524528 66.49415
2013-03-21T03:40:01 13.2991453704 66.9144
2013-03-21T03:45:01 13.7025324528 66.52031
2013-03-21T03:55:01 13.606495 66.72919
2013-03-21T04:00:01 13.5775622642 66.78402
2013-03-21T04:10:01 13.1499542593 66.62588
2013-03-21T04:15:01 13.6019639623 66.96186
2013-03-21T04:25:01 13.1736792593 66.66502
2013-03-21T04:30:01 13.5097277358 66.84101
2013-03-21T04:40:01 13.6319001852 66.94093
2013-03-21T04:45:01 13.51312 66.68227
2013-03-21T04:55:01 13.3079146296 66.62416
2013-03-21T05:00:01 13.7616484906 66.69574
2013-03-21T05:10:01 13.0069868519 66.86822
2013-03-21T05:15:01 13.8605171698 66.96002
2013-03-21T05:25:01 13.2803461111 66.61455
2013-03-21T05:30:01 13.369174717 66.64395
2013-03-21T05:40:01 13.6286914815 66.63361
2013-03-21T05:45:01 13.8564192453 67.04815
2013-03-21T05:55:01 13.5092757407 66.74607
2013-03-21T06:00:02 13.614582037 66.55903
2013-03-21T06:10:01 13.6546590741 67.10805
2013-03-21T06:15:01 13.7690627778 66.92899
2013-03-21T06:25:01 13.6056496296 66.91101
2013-03-21T06:30:01 13.357279434 66.72968
2013-03-21T06:40:01 13.3893151852 66.79335
2013-03-21T06:45:02 13.7398671698 66.56394
2013-03-21T06:55:02 13.3015440741 66.76195
2013-03-21T07:00:01 13.7103958491 66.448
2013-03-21T07:10:01 13.1272888889 66.71548
2013-03-21T07:15:01 13.6025784906 66.7894
2013-03-21T07:25:01 14.1947955556 66.76508
2013-03-21T07:30:01 13.674905283 66.30566
2013-03-21T07:40:01 13.8287287037 66.41147
2013-03-21T07:45:01 13.5995162264 66.88627
2013-03-21T07:55:01 13.7289109259 66.66599
2013-03-21T08:00:01 13.3848843396 66.54458
2013-03-21T08:10:01 13.3454038889 66.9759
2013-03-21T08:15:01 14.0669973585 67.06123
2013-03-21T08:25:01 13.6301912963 66.81762
2013-03-21T08:30:01 13.7951266038 66.67061
2013-03-21T08:40:01 13.8952818519 67.05064
2013-03-21T08:45:01 13.9756566038 66.85014
2013-03-21T08:55:01 13.9041801852 67.18346
2013-03-21T09:00:01 13.2994485185 66.75209
2013-03-21T09:10:01 13.2383427778 66.82464
2013-03-21T09:15:01 14.1099141509 67.11498
2013-03-21T09:25:01 13.7349332075 66.7426
2013-03-21T09:30:01 13.3952487037 66.66667
2013-03-21T09:40:01 13.1757275926 66.79524
2013-03-21T09:45:01 13.77419 66.8232
2013-03-21T09:55:01 13.7084112963 66.63949
2013-03-21T10:00:01 13.5791264151 66.8624
2013-03-21T10:10:01 13.1926533333 66.69633
2013-03-21T10:15:01 14.0213003774 67.09585
2013-03-21T10:25:01 13.7669728302 66.69707
2013-03-21T10:30:01 13.9817358491 66.91278
2013-03-21T10:40:01 13.642957037 67.04468
2013-03-21T10:45:01 13.9678073585 67.05118
2013-03-21T10:55:01 13.5141896296 66.99844
2013-03-21T11:00:01 13.7278266038 66.93347
2013-03-21T11:10:01 13.2873688889 66.94504
2013-03-21T11:15:01 13.7743656604 66.85885
2013-03-21T11:25:01 13.5600340741 66.68501
2013-03-21T11:30:01 13.7665888679 66.82542
2013-03-21T11:40:01 13.6117244444 66.8781
2013-03-21T11:45:01 13.6388509434 66.76451
2013-03-21T11:55:01 13.2090155556 66.81083
2013-03-21T12:00:01 13.5599562264 66.26175
2013-03-21T12:10:01 13.4989722222 66.79817
2013-03-21T12:15:01 13.34229 66.74085
2013-03-21T12:25:01 13.4735701852 66.64856
2013-03-21T12:30:01 12.9831246296 66.84004
2013-03-21T12:40:01 13.0588144444 66.9879
2013-03-21T12:45:02 13.8928167925 66.65809
2013-03-21T12:55:02 13.186722037 67.06304
2013-03-21T13:00:02 13.7929401887 66.90393
2013-03-21T13:10:02 13.7112101852 66.8434
2013-03-21T13:15:01 13.8205018868 66.77088
2013-03-21T13:25:01 13.2761216667 66.97243
2013-03-21T13:30:01 13.9524648148 67.03487
2013-03-21T13:40:01 13.0493914815 66.50586
2013-03-21T13:45:01 13.805464717 66.76848
2013-03-21T13:55:01 13.4667090741 66.89167
2013-03-21T14:00:01 13.7769758491 66.7499
2013-03-21T14:10:01 13.5515964815 67.06323
2013-03-21T14:15:01 13.5616362963 66.86291
2013-03-21T14:25:01 13.6157398148 66.89342
2013-03-21T14:30:02 14.131037963 66.98818
2013-03-21T14:40:01 13.1358322222 66.69011
2013-03-21T14:45:01 13.967329434 66.68761
2013-03-21T14:55:01 13.4143033333 66.87144
2013-03-21T15:00:01 13.9302088679 66.96745
2013-03-21T15:10:01 14.220312037 66.94154
2013-03-21T15:15:01 13.8843607407 67.24984
2013-03-21T15:25:01 13.2386701852 67.04384
2013-03-21T15:30:01 13.5120966667 67.03835
2013-03-21T15:40:01 13.2641377778 66.59873
2013-03-21T15:45:01 13.8829230189 67.03795
2013-03-21T15:55:01 13.4064674074 66.80336
2013-03-21T16:00:01 14.1154913208 67.10461
2013-03-21T16:10:01 13.7191114815 66.9325
2013-03-21T16:15:01 13.7155911111 66.72729
2013-03-21T16:25:01 13.3960501852 67.01783
2013-03-21T16:30:01 13.4014022222 66.72893
2013-03-21T16:40:01 13.2940805556 66.72716
2013-03-21T16:45:01 13.7643381481 66.66432
2013-03-21T16:55:02 14.523077037 67.17115
2013-03-21T17:00:01 13.824242037 67.01024
2013-03-21T17:10:01 14.7099746296 67.34812
2013-03-21T17:15:01 13.8248277358 66.87293
2013-03-21T17:25:01 13.4991990741 66.81946
2013-03-21T17:30:01 13.7347601887 66.89133
2013-03-21T17:40:01 13.22176 66.55102
2013-03-21T17:45:01 14.2773879245 67.06066
2013-03-21T17:55:01 13.8476796154 66.99493
2013-03-21T18:00:01 14.3013005882 66.74979
2013-03-21T18:10:01 14.5882363462 67.11171
Raw
locke_loss_no_sq_or_ssl_hosts.tsv
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 2 columns, instead of 3. in line 1.
2013-03-20T23:38:05 1.65709727273 12.02346
2013-03-20T23:41:03 0.0803826190476 0.69567
2013-03-20T23:45:01 0.178888809524 0.67979
2013-03-20T23:55:01 0.544111627907 0.52674
2013-03-21T00:00:01 0.074024047619 0.60224
2013-03-21T00:10:01 0.511992790698 0.51776
2013-03-21T00:15:01 0.0331973809524 0.46653
2013-03-21T00:25:01 -0.127642325581 0.52514
2013-03-21T00:30:01 0.133838571429 0.73706
2013-03-21T00:40:01 -0.384288604651 0.41519
2013-03-21T00:45:01 0.266376190476 0.61761
2013-03-21T00:55:01 -0.0125004651163 0.77809
2013-03-21T01:00:01 0.154636904762 0.63367
2013-03-21T01:10:01 0.42000372093 0.85531
2013-03-21T01:15:01 0.344429756098 0.66804
2013-03-21T01:25:01 0.0780997674419 0.48553
2013-03-21T01:30:02 0.739243488372 1.21336
2013-03-21T01:40:02 0.72199 0.98058
2013-03-21T01:45:01 0.456313333333 0.97538
2013-03-21T01:55:01 0.201890697674 0.76832
2013-03-21T02:00:01 0.283008809524 0.58344
2013-03-21T02:10:01 0.251193809524 0.59776
2013-03-21T02:15:01 0.740077674419 0.72992
2013-03-21T02:25:01 0.20080372093 0.37183
2013-03-21T02:30:01 0.246753571429 0.77603
2013-03-21T02:40:01 0.0423137209302 0.52211
2013-03-21T02:45:01 0.176745714286 0.57301
2013-03-21T02:54:50 -0.195164418605 0.41357
2013-03-21T03:00:01 0.453023953488 0.67211
2013-03-21T03:10:01 0.37442255814 0.42125
2013-03-21T03:15:01 0.0506030952381 0.51206
2013-03-21T03:25:01 0.0401358139535 0.42327
2013-03-21T03:30:01 0.020185952381 0.57029
2013-03-21T03:40:01 -0.521006511628 0.36881
2013-03-21T03:45:01 0.0237454761905 0.63259
2013-03-21T03:55:01 0.107208372093 0.39676
2013-03-21T04:00:01 0.0349807142857 0.69253
2013-03-21T04:10:01 -0.16870627907 0.51881
2013-03-21T04:15:01 -0.0446397619048 0.47565
2013-03-21T04:25:01 -0.185891395349 0.42361
2013-03-21T04:30:01 0.000160238095238 0.52444
2013-03-21T04:40:01 -0.105963023256 0.29589
2013-03-21T04:45:01 -0.0470157142857 0.58514
2013-03-21T04:55:01 0.0111113953488 0.32276
2013-03-21T05:00:01 -0.0162419047619 0.57826
2013-03-21T05:10:01 -0.762902325581 0.35774
2013-03-21T05:15:01 0.0444242857143 0.70675
2013-03-21T05:25:01 -0.34444372093 0.32947
2013-03-21T05:30:01 0.0345742857143 0.80664
2013-03-21T05:40:01 -0.0174797674419 0.26281
2013-03-21T05:45:01 0.01348 0.53579
2013-03-21T05:55:01 0.122230697674 0.48367
2013-03-21T06:00:02 0.160751162791 0.56811
2013-03-21T06:10:01 -0.104442325581 0.5939
2013-03-21T06:15:01 0.248694883721 0.86614
2013-03-21T06:25:01 -0.00472 0.52728
2013-03-21T06:30:01 -0.0902007142857 0.55904
2013-03-21T06:40:01 -0.149995581395 0.37417
2013-03-21T06:45:02 -0.00809666666667 0.53878
2013-03-21T06:55:02 -0.194206046512 0.43291
2013-03-21T07:00:01 -0.0676226190476 0.55451
2013-03-21T07:10:01 -0.400180232558 0.32957
2013-03-21T07:15:01 -0.0401178571429 0.57057
2013-03-21T07:25:01 0.694711162791 0.56236
2013-03-21T07:30:01 -0.0316945238095 0.77968
2013-03-21T07:40:01 0.68264372093 0.48062
2013-03-21T07:45:01 0.111602619048 0.94828
2013-03-21T07:55:01 0.387710232558 0.55856
2013-03-21T08:00:01 -0.017930952381 0.71797
2013-03-21T08:10:01 -0.282352790698 0.37927
2013-03-21T08:15:01 -0.022419047619 0.71114
2013-03-21T08:25:01 0.115309069767 0.58153
2013-03-21T08:30:01 -0.0327573809524 0.62847
2013-03-21T08:40:01 0.0933441860465 0.6919
2013-03-21T08:45:01 -0.0220026190476 0.66181
2013-03-21T08:55:01 0.364775116279 0.55044
2013-03-21T09:00:01 -0.0273672093023 0.75371
2013-03-21T09:10:01 -0.371065348837 0.30248
2013-03-21T09:15:01 -0.0932602380952 0.78362
2013-03-21T09:25:01 -0.0386976190476 0.43788
2013-03-21T09:30:01 0.0404204651163 0.63164
2013-03-21T09:40:01 -0.425182790698 0.42126
2013-03-21T09:45:01 0.023894047619 0.70764
2013-03-21T09:55:01 0.453216046512 0.3988
2013-03-21T10:00:01 0.109647380952 0.79934
2013-03-21T10:10:01 -0.429551162791 0.40833
2013-03-21T10:15:01 0.0052019047619 0.56896
2013-03-21T10:25:01 0.0096780952381 0.44619
2013-03-21T10:30:01 -0.151958333333 0.44636
2013-03-21T10:40:01 -0.137279767442 0.46043
2013-03-21T10:45:01 -0.159612142857 0.51349
2013-03-21T10:55:01 -0.24831372093 0.40742
2013-03-21T11:00:01 -0.0746676190476 0.31859
2013-03-21T11:10:01 -0.324005116279 0.39465
2013-03-21T11:15:01 -0.0312902380952 0.96057
2013-03-21T11:25:01 0.122856744186 0.4334
2013-03-21T11:30:01 -0.0263102380952 0.43569
2013-03-21T11:40:01 0.139475813953 0.379
2013-03-21T11:45:01 -0.0486180952381 0.44489
2013-03-21T11:55:01 -0.434641162791 0.33857
2013-03-21T12:00:01 0.0509307142857 0.60159
2013-03-21T12:10:01 -0.0735062790698 0.44225
2013-03-21T12:15:01 -0.38514627907 0.5946
2013-03-21T12:25:01 -0.0588095348837 0.32132
2013-03-21T12:30:01 -0.558066511628 0.50865
2013-03-21T12:40:01 -0.555503488372 0.39286
2013-03-21T12:45:02 0.0389688095238 0.58937
2013-03-21T12:55:02 -0.61656 0.30482
2013-03-21T13:00:02 -0.0854928571429 0.27662
2013-03-21T13:10:02 0.269209069767 0.46053
2013-03-21T13:15:01 -0.0755654761905 0.36741
2013-03-21T13:25:01 -0.34001255814 0.319
2013-03-21T13:30:01 0.407842093023 0.47041
2013-03-21T13:40:01 -0.600897674419 0.31744
2013-03-21T13:45:01 0.019725952381 0.47549
2013-03-21T13:55:01 -0.202317906977 0.30137
2013-03-21T14:00:01 0.040330952381 0.37745
2013-03-21T14:10:01 -0.168180930233 1.02933
2013-03-21T14:15:01 0.124490465116 0.36634
2013-03-21T14:25:01 0.102945348837 0.39504
2013-03-21T14:30:02 0.79878744186 0.61514
2013-03-21T14:40:01 -0.473409534884 0.49239
2013-03-21T14:45:01 0.0174221428571 0.496
2013-03-21T14:55:01 0.0180818604651 0.46224
2013-03-21T15:00:01 0.0423128571429 0.53247
2013-03-21T15:10:01 1.05070930233 1.36369
2013-03-21T15:15:01 -0.0926053488372 0.43393
2013-03-21T15:25:01 -0.559611162791 0.45342
2013-03-21T15:30:01 0.215231395349 0.6352
2013-03-21T15:40:01 -0.341922325581 0.44247
2013-03-21T15:45:01 0.141473333333 0.77244
2013-03-21T15:55:01 -0.330077906977 0.34802
2013-03-21T16:00:01 -0.013089047619 0.51506
2013-03-21T16:10:01 0.183536744186 0.58868
2013-03-21T16:15:01 0.257322790698 0.62165
2013-03-21T16:25:01 -0.0657053488372 0.45853
2013-03-21T16:30:01 -0.00560093023256 0.62728
2013-03-21T16:40:01 -0.121220465116 0.39052
2013-03-21T16:45:01 0.288479767442 0.72123
2013-03-21T16:55:02 1.28216232558 1.24529
2013-03-21T17:00:01 0.25804744186 0.86238
2013-03-21T17:10:01 1.13766534884 1.18017
2013-03-21T17:15:01 -0.066599047619 0.44837
2013-03-21T17:25:01 -0.0980876744186 0.39803
2013-03-21T17:30:01 -0.0170492857143 0.40562
2013-03-21T17:40:01 -0.306019069767 0.33453
2013-03-21T17:45:01 0.383681428571 0.64822
2013-03-21T17:55:01 -0.553951219512 0.38767
2013-03-21T18:00:01 -0.028601 0.48964
2013-03-21T18:10:01 0.73067804878 1.14412
2013-03-21T18:15:02 0.048797 0.77752
Raw
locke_loss_no_ssl_hosts.tsv
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 2 columns, instead of 3. in line 1.
2013-03-20T23:38:05 1.65709727273 12.02346
2013-03-20T23:41:03 -0.0804711650485 1.1906
2013-03-20T23:45:01 0.288368932039 1.43298
2013-03-20T23:55:01 -1.24106755906 1.261
2013-03-21T00:00:01 0.280383269231 1.33923
2013-03-21T00:10:01 -0.681451640625 2.25933
2013-03-21T00:15:01 0.643777904762 1.76435
2013-03-21T00:25:01 -0.977501102362 1.30309
2013-03-21T00:30:01 -0.0455816504854 1.03314
2013-03-21T00:40:01 -0.184222734375 3.33357
2013-03-21T00:45:01 0.467735769231 1.74284
2013-03-21T00:55:01 -0.559444566929 2.96496
2013-03-21T01:00:01 0.244806796117 2.71605
2013-03-21T01:10:01 -0.669390629921 2.90974
2013-03-21T01:15:01 -0.0463836111111 1.63599
2013-03-21T01:25:01 -0.2738325 4.27709
2013-03-21T01:30:02 0.967961296296 3.98486
2013-03-21T01:40:02 -0.374076299213 4.1457
2013-03-21T01:45:01 0.228967692308 1.79003
2013-03-21T01:55:01 -1.33763307087 1.12183
2013-03-21T02:00:01 0.713333611111 4.35198
2013-03-21T02:10:01 -0.729262834646 2.74841
2013-03-21T02:15:01 0.479883809524 2.94269
2013-03-21T02:25:01 -0.57271480315 2.20775
2013-03-21T02:30:01 0.844227075472 3.61394
2013-03-21T02:40:01 -0.381735669291 1.32436
2013-03-21T02:45:01 0.971131694915 4.03423
2013-03-21T02:54:50 -0.274247131783 3.11419
2013-03-21T03:00:01 0.852820258621 4.2461
2013-03-21T03:10:01 -1.02539417323 1.1065
2013-03-21T03:15:01 0.943291452991 5.92334
2013-03-21T03:25:01 -0.886521417323 1.30729
2013-03-21T03:30:01 0.614169818182 2.12766
2013-03-21T03:40:01 -1.61320244094 0.88886
2013-03-21T03:45:01 0.206989056604 1.84922
2013-03-21T03:55:01 -0.7117334375 2.42981
2013-03-21T04:00:01 0.371075700935 1.43298
2013-03-21T04:10:01 -1.3815246875 1.14028
2013-03-21T04:15:01 0.771200285714 1.63279
2013-03-21T04:25:01 -0.744093700787 2.31362
2013-03-21T04:30:01 0.2812425 1.45359
2013-03-21T04:40:01 -0.401191259843 2.37859
2013-03-21T04:45:01 0.515058317757 3.43008
2013-03-21T04:55:01 -1.22171417323 1.41897
2013-03-21T05:00:01 -0.31936592233 1.76322
2013-03-21T05:10:01 -0.649901338583 2.48806
2013-03-21T05:15:01 0.188445576923 1.67464
2013-03-21T05:25:01 -1.28072811024 1.33333
2013-03-21T05:30:01 0.56720754717 2.09568
2013-03-21T05:40:01 -0.968776171875 1.10202
2013-03-21T05:45:01 -0.121759708738 1.43414
2013-03-21T05:55:01 -0.0942651181102 3.45504
2013-03-21T06:00:02 0.069934245283 1.23922
2013-03-21T06:10:01 -1.56343519685 0.88049
2013-03-21T06:15:01 0.502830185185 1.66143
2013-03-21T06:25:01 -0.419798110236 1.09634
2013-03-21T06:30:01 0.758977368421 2.46912
2013-03-21T06:40:01 -0.361592598425 1.5061
2013-03-21T06:45:02 0.762937735849 2.81974
2013-03-21T06:55:02 -0.561455703125 1.78353
2013-03-21T07:00:01 0.64714733945 3.16796
2013-03-21T07:10:01 -0.492849685039 1.67866
2013-03-21T07:15:01 0.50447 1.38889
2013-03-21T07:25:01 -0.395792440945 2.23464
2013-03-21T07:30:01 1.02289841121 1.91898
2013-03-21T07:40:01 -0.0206869291339 1.2987
2013-03-21T07:45:01 0.992383394495 3.52595
2013-03-21T07:55:01 -0.0478625984252 2.43902
2013-03-21T08:00:01 0.279490934579 1.43711
2013-03-21T08:10:01 -0.906197952756 0.90411
2013-03-21T08:15:01 0.737066315789 6.15177
2013-03-21T08:25:01 -1.48145744186 0.88198
2013-03-21T08:30:01 0.472212589286 1.14586
2013-03-21T08:40:01 -1.04172566929 1.84049
2013-03-21T08:45:01 -0.140882612613 1.14992
2013-03-21T08:55:01 -0.896225669291 0.81372
2013-03-21T09:00:01 0.798533660714 3.22581
2013-03-21T09:10:01 -1.02952204724 1.05263
2013-03-21T09:15:01 0.176795945946 1.33333
2013-03-21T09:25:01 -0.745723412698 1.01523
2013-03-21T09:30:01 1.01816426087 3.4965
2013-03-21T09:40:01 -0.936233622047 0.9009
2013-03-21T09:45:01 0.314988557692 1.41468
2013-03-21T09:55:01 -0.121299370079 3.16206
2013-03-21T10:00:01 0.00271390909091 1.27971
2013-03-21T10:10:01 -0.252802734375 1.82391
2013-03-21T10:15:01 0.672906972477 2.01342
2013-03-21T10:25:01 -0.566373070866 1.20482
2013-03-21T10:30:01 0.998213240741 2.97542
2013-03-21T10:40:01 -0.306475193798 3.98126
2013-03-21T10:45:01 0.345652385321 1.96977
2013-03-21T10:55:01 -0.093449453125 4.55531
2013-03-21T11:00:01 1.78306513274 6.40394
2013-03-21T11:10:01 -0.438718267717 2.41154
2013-03-21T11:15:01 0.359198240741 1.25112
2013-03-21T11:25:01 -1.45130356589 0.60821
2013-03-21T11:30:01 0.659282385321 3.19755
2013-03-21T11:40:01 -0.659013858268 1.3837
2013-03-21T11:45:01 0.314081047619 1.10799
2013-03-21T11:55:01 -0.605120859375 2.65487
2013-03-21T12:00:01 0.375703679245 0.99762
2013-03-21T12:10:01 -0.608321811024 1.45788
2013-03-21T12:15:01 0.21893377193 1.3145
2013-03-21T12:25:01 -1.15419929134 0.94746
2013-03-21T12:30:01 0.505683508772 2.83401
2013-03-21T12:40:01 -0.709047829457 1.23199
2013-03-21T12:45:02 0.78938293578 4.68986
2013-03-21T12:55:02 -0.18020515625 3.37628
2013-03-21T13:00:02 0.130341652174 2.41998
2013-03-21T13:10:02 -0.0794082677165 4.19669
2013-03-21T13:15:01 0.819414867257 4.0
2013-03-21T13:25:01 -0.521885433071 1.74129
2013-03-21T13:30:01 0.93422 4.21456
2013-03-21T13:40:01 -1.11947859375 1.13392
2013-03-21T13:45:01 0.097231047619 0.9456
2013-03-21T13:55:01 -0.532968984375 3.07627
2013-03-21T14:00:01 1.35006345455 5.61331
2013-03-21T14:10:01 -0.400997421875 2.38525
2013-03-21T14:15:01 0.852877787611 3.4565
2013-03-21T14:25:01 -0.857757322835 2.55277
2013-03-21T14:30:02 1.52683945946 5.78158
2013-03-21T14:40:01 -0.771056614173 0.9766
2013-03-21T14:45:01 1.08154990654 3.48418
2013-03-21T14:55:01 -0.53646859375 1.33333
2013-03-21T15:00:01 0.204091981132 0.72962
2013-03-21T15:10:01 0.21035453125 3.70232
2013-03-21T15:15:01 0.298059065421 0.95768
2013-03-21T15:25:01 -0.928760551181 1.78817
2013-03-21T15:30:01 0.414625943396 0.76764
2013-03-21T15:40:01 -0.0760233070866 3.31715
2013-03-21T15:45:01 -0.327609038462 0.82412
2013-03-21T15:55:01 -0.932724094488 0.87903
2013-03-21T16:00:01 0.717648785047 1.00859
2013-03-21T16:10:01 -0.706852890625 1.3938
2013-03-21T16:15:01 0.559680185185 1.18756
2013-03-21T16:25:01 -0.26179503937 5.4878
2013-03-21T16:30:01 0.798897850467 2.42931
2013-03-21T16:40:01 -0.944603385827 1.00734
2013-03-21T16:45:01 0.720032803738 1.95246
2013-03-21T16:55:02 0.0427595348837 3.30789
2013-03-21T17:00:01 0.193308380952 1.10273
2013-03-21T17:10:01 -0.323076850394 2.20247
2013-03-21T17:15:01 -0.16830407767 0.65108
2013-03-21T17:25:01 -0.52184828125 0.98205
2013-03-21T17:30:01 -0.322536990291 0.68012
2013-03-21T17:40:01 -0.584325348837 1.61322
2013-03-21T17:45:01 0.791505840708 2.9734
2013-03-21T17:55:01 -1.17698136 0.8292
2013-03-21T18:00:01 0.0564752475248 1.50435
2013-03-21T18:10:01 -0.0328523387097 1.51949
2013-03-21T18:15:02 -0.146578118812 0.83632
Raw
locke_loss_sq_hosts.tsv
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 2 columns, instead of 3. in line 1.
2013-03-20T23:38:05 99 99
2013-03-20T23:41:03 -0.19122295082 3.75204
2013-03-20T23:45:01 0.363748688525 1.80035
2013-03-20T23:55:01 -2.15490928571 1.89873
2013-03-21T00:00:01 0.420175 1.92778
2013-03-21T00:10:01 -1.28519411765 3.45996
2013-03-21T00:15:01 1.0508315873 2.94247
2013-03-21T00:25:01 -1.41254785714 2.69497
2013-03-21T00:30:01 -0.169116885246 1.17633
2013-03-21T00:40:01 -0.0830129411765 4.75082
2013-03-21T00:45:01 0.604140645161 2.31621
2013-03-21T00:55:01 -0.839427857143 3.48837
2013-03-21T01:00:01 0.306890983607 2.97416
2013-03-21T01:10:01 -1.22705678571 3.44828
2013-03-21T01:15:01 -0.285538059701 2.15755
2013-03-21T01:25:01 -0.451868823529 5.32544
2013-03-21T01:30:02 1.11926692308 6.25
2013-03-21T01:40:02 -0.935157857143 4.1457
2013-03-21T01:45:01 0.0749593548387 2.43902
2013-03-21T01:55:01 -2.12572261905 1.19972
2013-03-21T02:00:01 0.987176666667 5.92662
2013-03-21T02:10:01 -1.21372376471 3.79747
2013-03-21T02:15:01 0.299426774194 2.94269
2013-03-21T02:25:01 -0.968682619048 2.41102
2013-03-21T02:30:01 1.2363190625 4.82154
2013-03-21T02:40:01 -0.598808571429 1.63889
2013-03-21T02:45:01 1.41013447368 5.6696
2013-03-21T02:54:50 -0.313788488372 4.27752
2013-03-21T03:00:01 1.08831671233 6.12245
2013-03-21T03:10:01 -1.74196702381 3.03445
2013-03-21T03:15:01 1.44319693333 10.20408
2013-03-21T03:25:01 -1.36088166667 2.01005
2013-03-21T03:30:01 0.981042205882 3.37934
2013-03-21T03:40:01 -2.1723027381 1.40147
2013-03-21T03:45:01 0.32724265625 4.47344
2013-03-21T03:55:01 -1.12602164706 3.22581
2013-03-21T04:00:01 0.588244769231 3.4749
2013-03-21T04:10:01 -1.99506811765 2.13392
2013-03-21T04:15:01 1.31509365079 3.44123
2013-03-21T04:25:01 -1.02984011905 3.25648
2013-03-21T04:30:01 0.471653064516 2.15367
2013-03-21T04:40:01 -0.55232 3.63503
2013-03-21T04:45:01 0.878244615385 6.34921
2013-03-21T04:55:01 -1.85280345238 2.17563
2013-03-21T05:00:01 -0.528074262295 1.92213
2013-03-21T05:10:01 -0.592055595238 3.73926
2013-03-21T05:15:01 0.286008387097 2.14637
2013-03-21T05:25:01 -1.76001654762 2.16878
2013-03-21T05:30:01 0.916748125 2.81931
2013-03-21T05:40:01 -1.45002023529 2.13415
2013-03-21T05:45:01 -0.21487557377 3.11053
2013-03-21T05:55:01 -0.205090357143 6.44285
2013-03-21T06:00:02 0.00794809523809 2.21841
2013-03-21T06:10:01 -2.31030059524 1.76322
2013-03-21T06:15:01 0.670950461538 2.85205
2013-03-21T06:25:01 -0.632278571429 2.72374
2013-03-21T06:30:01 1.25433125 4.95868
2013-03-21T06:40:01 -0.469910119048 5.52995
2013-03-21T06:45:02 1.2689290625 6.36132
2013-03-21T06:55:02 -0.747240823529 5.01836
2013-03-21T07:00:01 1.09521208955 5.35549
2013-03-21T07:10:01 -0.540287619048 2.56046
2013-03-21T07:15:01 0.86185578125 4.58546
2013-03-21T07:25:01 -0.954026428571 4.20561
2013-03-21T07:30:01 1.70432769231 3.73369
2013-03-21T07:40:01 -0.380725238095 2.75762
2013-03-21T07:45:01 1.54451462687 7.31707
2013-03-21T07:55:01 -0.270834404762 4.68345
2013-03-21T08:00:01 0.471671230769 4.49699
2013-03-21T08:10:01 -1.2255472619 3.9678
2013-03-21T08:15:01 1.18009944444 8.09147
2013-03-21T08:25:01 -2.27984069767 2.16155
2013-03-21T08:30:01 0.775194571429 7.97546
2013-03-21T08:40:01 -1.62277333333 3.76759
2013-03-21T08:45:01 -0.213244347826 1.61893
2013-03-21T08:55:01 -1.54173797619 1.96078
2013-03-21T09:00:01 1.31322550725 4.7619
2013-03-21T09:10:01 -1.36658916667 2.35242
2013-03-21T09:15:01 0.341177971014 4.35943
2013-03-21T09:25:01 -1.09923630952 2.32131
2013-03-21T09:30:01 1.60209458333 7.0632
2013-03-21T09:40:01 -1.19784297619 2.14689
2013-03-21T09:45:01 0.512181612903 2.8777
2013-03-21T09:55:01 -0.415396547619 4.34012
2013-03-21T10:00:01 -0.0633332352941 1.77815
2013-03-21T10:10:01 -0.163388823529 3.63881
2013-03-21T10:15:01 1.09146835821 5.20282
2013-03-21T10:25:01 -0.851010117647 2.2779
2013-03-21T10:30:01 1.73014060606 6.5713
2013-03-21T10:40:01 -0.391072906977 4.66102
2013-03-21T10:45:01 0.662385373134 4.9568
2013-03-21T10:55:01 -0.0151063529412 7.12743
2013-03-21T11:00:01 2.8820056338 10.93117
2013-03-21T11:10:01 -0.49744047619 3.5533
2013-03-21T11:15:01 0.607690909091 3.93208
2013-03-21T11:25:01 -2.23838372093 1.30985
2013-03-21T11:30:01 1.08905686567 6.69546
2013-03-21T11:40:01 -1.06776452381 2.71849
2013-03-21T11:45:01 0.55588047619 2.81442
2013-03-21T11:55:01 -0.691363529412 4.49438
2013-03-21T12:00:01 0.5888359375 4.10385
2013-03-21T12:10:01 -0.882096428571 2.80778
2013-03-21T12:15:01 0.584785070423 4.7619
2013-03-21T12:25:01 -1.71493452381 2.36187
2013-03-21T12:30:01 1.14992647887 4.94297
2013-03-21T12:40:01 -0.78582 3.79747
2013-03-21T12:45:02 1.25979179104 5.51181
2013-03-21T12:55:02 0.0405390588235 4.30622
2013-03-21T13:00:02 0.254520410959 5.7377
2013-03-21T13:10:02 -0.257867142857 4.80202
2013-03-21T13:15:01 1.34883985915 7.94979
2013-03-21T13:25:01 -0.61498702381 3.50877
2013-03-21T13:30:01 1.25756642857 5.88235
2013-03-21T13:40:01 -1.38181952941 3.61446
2013-03-21T13:45:01 0.148901111111 1.66738
2013-03-21T13:55:01 -0.700239529412 3.83813
2013-03-21T14:00:01 2.15901588235 8.18859
2013-03-21T14:10:01 -0.518775176471 3.52845
2013-03-21T14:15:01 1.30031571429 7.06023
2013-03-21T14:25:01 -1.34954559524 3.10651
2013-03-21T14:30:02 1.98722529412 14.10256
2013-03-21T14:40:01 -0.923423571429 3.22581
2013-03-21T14:45:01 1.76914015385 5.74618
2013-03-21T14:55:01 -0.817005882353 3.98849
2013-03-21T15:00:01 0.31025953125 4.12979
2013-03-21T15:10:01 -0.214766117647 4.3659
2013-03-21T15:15:01 0.56053671875 2.08931
2013-03-21T15:25:01 -1.11772988095 4.30622
2013-03-21T15:30:01 0.550720634921 1.20382
2013-03-21T15:40:01 0.0600916666667 3.89294
2013-03-21T15:45:01 -0.645374516129 0.93633
2013-03-21T15:55:01 -1.24122154762 2.80778
2013-03-21T16:00:01 1.18981784615 5.7971
2013-03-21T16:10:01 -1.15728529412 3.00231
2013-03-21T16:15:01 0.759701230769 2.84553
2013-03-21T16:25:01 -0.362174285714 6.44575
2013-03-21T16:30:01 1.33942046875 5.61432
2013-03-21T16:40:01 -1.36609702381 3.38164
2013-03-21T16:45:01 1.0099825 4.54163
2013-03-21T16:55:02 -0.576941860465 5.26316
2013-03-21T17:00:01 0.148408709677 1.52916
2013-03-21T17:10:01 -1.0708377381 5.21423
2013-03-21T17:15:01 -0.238330491803 0.78259
2013-03-21T17:25:01 -0.736221294118 3.62422
2013-03-21T17:30:01 -0.532872786885 0.85785
2013-03-21T17:40:01 -0.723478488372 3.33533
2013-03-21T17:45:01 1.03275408451 5.95483
2013-03-21T17:55:01 -1.48107940476 2.2363
2013-03-21T18:00:01 0.11226295082 2.60736
2013-03-21T18:10:01 -0.410017951807 1.96078
2013-03-21T18:15:02 -0.27469295082 2.15185
Raw
locke_loss_ssl_hosts.tsv
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 2 columns, instead of 3. in line 1.
2013-03-20T23:38:05 50.0 50.0
2013-03-20T23:41:03 65.073557 67.25929
2013-03-20T23:45:01 67.2130009091 71.26437
2013-03-20T23:55:01 65.3372609091 67.12915
2013-03-21T00:00:01 65.2073045455 67.13578
2013-03-21T00:10:01 65.1727254545 66.81704
2013-03-21T00:15:01 64.9970945455 67.27273
2013-03-21T00:25:01 66.6582290909 67.39854
2013-03-21T00:30:01 67.0481536364 67.42864
2013-03-21T00:40:01 66.7366045455 68.80667
2013-03-21T00:45:01 67.1504509091 68.0
2013-03-21T00:55:01 65.5766272727 66.81148
2013-03-21T01:00:01 65.61352 67.08657
2013-03-21T01:10:01 66.8315709091 66.93887
2013-03-21T01:15:01 67.6208181818 69.53405
2013-03-21T01:25:01 66.5829390909 66.965
2013-03-21T01:30:02 68.5436336364 73.07132
2013-03-21T01:40:02 66.8829363636 67.82842
2013-03-21T01:45:01 65.7364718182 67.11681
2013-03-21T01:55:01 65.4755309091 67.36784
2013-03-21T02:00:01 66.79734 68.07721
2013-03-21T02:10:01 65.4552872727 67.00164
2013-03-21T02:15:01 65.3513290909 67.08303
2013-03-21T02:25:01 66.0528809091 66.79553
2013-03-21T02:30:01 68.72845 72.52091
2013-03-21T02:40:01 65.0208127273 67.26355
2013-03-21T02:45:01 66.5211909091 67.06198
2013-03-21T02:54:50 66.7497845455 68.06777
2013-03-21T03:00:01 65.2831827273 67.15836
2013-03-21T03:10:01 65.6722 67.56224
2013-03-21T03:15:01 66.3686009091 68.71629
2013-03-21T03:25:01 65.2143618182 66.77032
2013-03-21T03:30:01 65.6113790909 66.8228
2013-03-21T03:40:01 67.3233754545 71.63995
2013-03-21T03:45:01 65.9306281818 67.67001
2013-03-21T03:55:01 66.3764336364 67.48482
2013-03-21T04:00:01 65.2856009091 67.15742
2013-03-21T04:10:01 65.2138090909 66.98328
2013-03-21T04:15:01 65.7071781818 67.14976
2013-03-21T04:25:01 65.3974554545 67.35454
2013-03-21T04:30:01 65.0917127273 67.71257
2013-03-21T04:40:01 67.3344563636 69.37213
2013-03-21T04:45:01 65.2881836364 67.34143
2013-03-21T04:55:01 65.2863272727 66.90584
2013-03-21T05:00:01 66.3681390909 68.18811
2013-03-21T05:10:01 66.8347354545 67.46255
2013-03-21T05:15:01 66.6128718182 68.07512
2013-03-21T05:25:01 66.5408881818 67.21507
2013-03-21T05:30:01 64.2831036364 67.17043
2013-03-21T05:40:01 66.9728154545 67.53247
2013-03-21T05:45:01 66.7112781818 67.28771
2013-03-21T05:55:01 65.8404518182 67.14701
2013-03-21T06:00:02 66.20683 72.13622
2013-03-21T06:10:01 67.4402372727 69.39891
2013-03-21T06:15:01 66.62141 67.62965
2013-03-21T06:25:01 66.8098218182 68.99225
2013-03-21T06:30:01 64.7022036364 67.09263
2013-03-21T06:40:01 66.3157118182 67.66169
2013-03-21T06:45:02 66.2320927273 67.20264
2013-03-21T06:55:02 66.0576581818 67.42424
2013-03-21T07:00:01 66.3173754545 67.13062
2013-03-21T07:10:01 66.0073954545 67.10594
2013-03-21T07:15:01 65.6928736364 67.43787
2013-03-21T07:25:01 66.9678527273 67.53247
2013-03-21T07:30:01 66.0091954545 66.91458
2013-03-21T07:40:01 65.21797 67.06237
2013-03-21T07:45:01 65.0988227273 67.52137
2013-03-21T07:55:01 65.8808772727 67.08901
2013-03-21T08:00:01 64.55927 67.45606
2013-03-21T08:10:01 66.6175436364 69.36275
2013-03-21T08:15:01 67.8629509091 73.14376
2013-03-21T08:25:01 66.4610945455 67.22888
2013-03-21T08:30:01 66.5925018182 67.59324
2013-03-21T08:40:01 67.8483109091 70.66409
2013-03-21T08:45:01 67.4212645455 69.04762
2013-03-21T08:55:01 66.8309454545 68.13725
2013-03-21T09:00:01 65.3951827273 67.27551
2013-03-21T09:10:01 66.4387563636 67.36097
2013-03-21T09:15:01 68.3402163636 72.3127
2013-03-21T09:25:01 66.32516 67.19321
2013-03-21T09:30:01 65.6004863636 67.06944
2013-03-21T09:40:01 66.3429227273 67.04555
2013-03-21T09:45:01 66.27532 67.31775
2013-03-21T09:55:01 65.5241745455 67.22541
2013-03-21T10:00:01 65.0080463636 67.35347
2013-03-21T10:10:01 66.4430890909 67.37908
2013-03-21T10:15:01 67.5373127273 69.69697
2013-03-21T10:25:01 66.2948254545 67.26278
2013-03-21T10:30:01 67.94675 72.43755
2013-03-21T10:40:01 67.5111554545 70.2381
2013-03-21T10:45:01 67.9088636364 71.34238
2013-03-21T10:55:01 67.3130663636 70.80868
2013-03-21T11:00:01 66.4282590909 68.47912
2013-03-21T11:10:01 66.4954672727 67.74194
2013-03-21T11:15:01 66.48687 68.51472
2013-03-21T11:25:01 66.0871818182 67.29875
2013-03-21T11:30:01 66.4303854545 67.19766
2013-03-21T11:40:01 66.2759690909 67.16568
2013-03-21T11:45:01 65.9000963636 67.19483
2013-03-21T11:55:01 66.54331 67.33052
2013-03-21T12:00:01 65.1398718182 67.45136
2013-03-21T12:10:01 66.5550245455 67.13592
2013-03-21T12:15:01 67.0040863636 67.44457
2013-03-21T12:25:01 66.3728727273 67.29222
2013-03-21T12:30:01 65.9168718182 67.42492
2013-03-21T12:40:01 66.2784209091 67.26602
2013-03-21T12:45:02 66.7893272727 67.32919
2013-03-21T12:55:02 67.1450063636 68.36983
2013-03-21T13:00:02 66.7833209091 67.52568
2013-03-21T13:10:02 66.2572145455 67.1878
2013-03-21T13:15:01 66.8782136364 68.83469
2013-03-21T13:25:01 66.5028281818 67.43997
2013-03-21T13:30:01 66.8996263636 68.34532
2013-03-21T13:40:01 66.4096127273 67.30571
2013-03-21T13:45:01 66.4419218182 67.28882
2013-03-21T13:55:01 66.9001781818 67.29115
2013-03-21T14:00:01 66.2259836364 67.03142
2013-03-21T14:10:01 67.1834536364 68.51672
2013-03-21T14:15:01 66.0886609091 67.13069
2013-03-21T14:25:01 66.4384818182 67.42835
2013-03-21T14:30:02 66.2480172727 67.34888
2013-03-21T14:40:01 66.3355954545 67.25641
2013-03-21T14:45:01 67.2306118182 67.2009
2013-03-21T14:55:01 65.7813509091 67.48182
2013-03-21T15:00:01 66.9567209091 67.27224
2013-03-21T15:10:01 65.7014863636 67.71863
2013-03-21T15:15:01 68.5215918182 73.30282
2013-03-21T15:25:01 67.1774063636 67.36225
2013-03-21T15:30:01 65.4907518182 67.52691
2013-03-21T15:40:01 66.4514636364 67.41633
2013-03-21T15:45:01 66.3502763636 67.26472
2013-03-21T15:55:01 67.1038718182 68.86792
2013-03-21T16:00:01 68.06098 70.03745
2013-03-21T16:10:01 66.6309036364 68.14364
2013-03-21T16:15:01 66.3251854545 67.40301
2013-03-21T16:25:01 66.0192763636 67.6103
2013-03-21T16:30:01 65.8105963636 67.17044
2013-03-21T16:40:01 65.7357118182 67.15323
2013-03-21T16:45:01 66.4426936364 67.52673
2013-03-21T16:55:02 66.2830163636 67.32903
2013-03-21T17:00:01 66.85573 69.38776
2013-03-21T17:10:01 67.7653654545 70.9423
2013-03-21T17:15:01 66.8648209091 67.52137
2013-03-21T17:25:01 66.6522290909 67.49278
2013-03-21T17:30:01 66.2416690909 68.68009
2013-03-21T17:40:01 66.1030781818 67.10246
2013-03-21T17:45:01 67.3260854545 68.3908
2013-03-21T17:55:01 67.5264854545 69.23077
2013-03-21T18:00:01 66.4100336364 67.29776
2013-03-21T18:10:01 66.2391354545 67.54055
2013-03-21T18:15:02 65.0716654545 67.24601
Raw
PacketLossAverager.py
# -*- coding: utf-8 -*-
import re
import sys
# local dependencies
class PacketLossLogAverager(object):
def __init__(self):
'''This function should initialize any data structures or variables
needed for the internal state of the line parser.'''
# this is what will match the packet loss lines
# packet loss format :
# %[%Y-%m-%dT%H:%M:%S]t %server lost: (%percentloss +/- %margin)
# [2011-10-26T21:20:25] sq86.wikimedia.org lost: (3.61446 +/- 19.67462)%
# match keys: date, server, percentloss, margin
self.num_hits = 0
self.reg = re.compile ('^\[(?P<date>[^]]+)\] (?P<server>[^ ]+) lost: \((?P<percentloss>[^ ]+) \+\/- (?P<margin>[^)]+)\)%')
self.percentloss_list = list()
# example function for parse line
# takes one argument (text) line to be parsed
# returns nothing
def parse_line(self, line):
'''This function should digest the contents of one line at a time,
updating the internal state variables.'''
try:
regMatch = self.reg.match(line)
if regMatch:
linebits = regMatch.groupdict()
self.num_hits+=1
# capture data
percentloss = float(linebits['percentloss'])
margin = float(linebits['margin'])
# store for 90th % and average calculations
# on ssl servers, sequence numbers are out of order.
# http://rt.wikimedia.org/Ticket/Display.html?id=1616
if( ( margin <= 20 ) and ( percentloss <= 98 ) ):
self.percentloss_list.append(percentloss)
except Exception, e:
raise Exception, "regmatch or contents failed with %s" % e
def parse_stdin(self):
for line in sys.stdin:
self.parse_line(line)
return self.calculate()
def calculate(self):
self.percentloss_list.sort()
num_entries = len(self.percentloss_list)
if (num_entries != 0 ):
packetloss_90th = self.percentloss_list[int(num_entries * 0.9)]
packetloss_ave = sum(self.percentloss_list) / len(self.percentloss_list)
else:
# in this event, all data was thrown out in parse_line
packetloss_90th = 99
packetloss_ave = 99
print("%s\t%s" % (packetloss_ave, packetloss_90th))
if __name__ == '__main__':
averager = PacketLossLogAverager()
averager.parse_stdin()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment