In [65]:
%matplotlib inline  
import sys
import pandas as pd
import matplotlib.pyplot as plt
import matplotlib.figure
# From http://pandas.pydata.org/pandas-docs/version/0.23/visualization.html
# http://pandas.pydata.org/pandas-docs/version/0.23/visualization.html#scatter-matrix-plot
# from mpl_toolkits.mplot3d import Axes3D
# This import registers the 3D projection, but is otherwise unused.  DO NOT REMOVE IT
from mpl_toolkits.mplot3d import Axes3D  # noqa: F401 unused import
import numpy as np
import numpy.polynomial.polynomial as poly
from scipy import stats
print(sys.version)


3.6.6 (default, Sep 12 2018, 18:26:19) 
[GCC 8.0.1 20180414 (experimental) [trunk revision 259383]]

In [66]:
FILENAME="performance_20181106-1107"
df = pd.read_csv(FILENAME+".csv")
df4=df[df['proto'] =='IPv4']
df6=df[df['proto'] =='IPv6']

In [67]:
df6


Out[67]:
retries elapsed delay loss size rate proto GTRs
1 0 9.524200e-02 0.0 0.0 1000 10500.00 IPv6 1
3 0 1.142390e-01 0.0 0.0 1000 8754.00 IPv6 0
5 0 1.330080e-01 0.0 0.0 1000 7518.00 IPv6 1
7 0 1.990360e-01 0.0 0.0 1000 5024.00 IPv6 0
9 0 1.357682e+00 0.0 0.0 1000 736.50 IPv6 6
11 0 4.998840e-01 0.0 0.0 1000 2000.00 IPv6 2
13 0 1.095049e+00 0.0 0.0 1000 913.20 IPv6 4
15 0 1.104843e+00 0.0 0.1 1000 905.10 IPv6 7
17 0 1.174619e+00 10.1 0.1 1000 851.30 IPv6 6
19 0 1.141908e+00 20.1 0.1 1000 875.70 IPv6 8
21 0 1.215317e+00 50.0 0.1 1000 822.80 IPv6 9
23 0 1.299935e+00 100.0 0.1 1000 769.30 IPv6 10
25 0 4.875630e-01 200.0 0.1 1000 2051.00 IPv6 5
27 0 1.090637e+00 500.0 0.1 1000 916.90 IPv6 6
29 0 1.118559e+00 0.0 10.0 1000 894.00 IPv6 7
31 0 1.165189e+00 10.1 10.0 1000 858.20 IPv6 9
33 0 1.141795e+00 20.1 10.0 1000 875.80 IPv6 9
35 0 1.202062e+00 50.0 10.0 1000 831.90 IPv6 5
37 0 2.881080e-01 100.0 10.0 1000 3471.00 IPv6 2
39 0 4.997220e-01 200.0 10.0 1000 2001.00 IPv6 1
41 0 1.093832e+00 500.0 10.0 1000 914.20 IPv6 3
43 0 1.105388e+00 0.0 20.0 1000 904.70 IPv6 7
45 0 1.133079e+00 10.1 20.0 1000 882.60 IPv6 9
47 0 1.157164e+00 20.1 20.0 1000 864.20 IPv6 7
49 0 5.204048e+00 50.0 20.0 1000 192.20 IPv6 18
51 0 6.332710e+00 100.0 20.0 1000 157.90 IPv6 6
53 0 5.495408e+00 200.0 20.0 1000 182.00 IPv6 9
55 0 6.095500e+00 500.0 20.0 1000 164.10 IPv6 7
57 0 1.513214e+01 0.0 30.1 1000 66.08 IPv6 20
59 0 1.513306e+01 10.1 30.1 1000 66.08 IPv6 18
61 0 5.144070e+00 20.1 30.1 1000 194.40 IPv6 8
63 0 5.195751e+00 50.0 30.1 1000 192.50 IPv6 11
65 0 2.935010e-01 100.0 30.1 1000 3407.00 IPv6 0
67 0 5.435210e-01 200.0 30.1 1000 1840.00 IPv6 1
69 0 8.176558e+00 500.0 30.1 1000 122.30 IPv6 22
71 0 1.137484e+00 0.0 50.2 1000 879.10 IPv6 3
73 0 1.159320e-01 10.1 50.2 1000 8626.00 IPv6 1
75 0 5.134788e+00 20.1 50.2 1000 194.80 IPv6 15
77 0 1.187228e+00 50.0 50.2 1000 842.30 IPv6 47
79 0 1.414105e+00 100.0 50.2 1000 707.20 IPv6 8
81 0 4.951790e-01 200.0 50.2 1000 2019.00 IPv6 4
83 0 2.154682e+00 500.0 50.2 1000 464.10 IPv6 6
85 0 8.176565e+00 0.0 60.0 1000 122.30 IPv6 19
87 0 1.134708e+00 10.1 60.0 1000 881.30 IPv6 2
89 0 1.314540e-01 20.1 60.0 1000 7607.00 IPv6 1
91 0 1.208148e+00 50.0 60.0 1000 827.70 IPv6 2
93 0 6.337136e+00 100.0 60.0 1000 157.80 IPv6 6
95 0 2.172292e+01 200.0 60.0 1000 46.03 IPv6 35
97 0 1.086219e+00 500.0 60.0 1000 920.60 IPv6 1
99 1000000000 1.000000e+09 0.0 70.0 1000 0.00 IPv6 43
101 1000000000 1.000000e+09 10.1 70.0 1000 0.00 IPv6 83
103 0 1.543290e+01 20.1 70.0 1000 64.80 IPv6 15
105 0 3.177288e+01 50.0 70.0 1000 31.47 IPv6 39
107 0 5.302579e+00 100.0 70.0 1000 188.60 IPv6 6
109 0 1.258439e+01 200.0 70.0 1000 79.46 IPv6 33
111 0 5.806860e-01 500.0 70.0 1000 1722.00 IPv6 41
113 0 5.090129e+00 0.0 80.0 1000 196.50 IPv6 10
115 0 6.119324e+00 10.1 80.0 1000 163.40 IPv6 11
117 0 1.222141e+01 20.1 80.0 1000 81.82 IPv6 13
119 0 3.228394e+00 50.0 80.0 1000 309.80 IPv6 15
121 1000000000 1.000000e+09 100.0 80.0 1000 0.00 IPv6 16
123 0 1.970782e+01 200.0 80.0 1000 50.74 IPv6 14
125 0 5.811580e-01 500.0 80.0 1000 1721.00 IPv6 41
127 0 1.126728e+00 0.0 0.0 10000 8875.00 IPv6 7
129 0 1.174752e+00 0.0 0.0 10000 8512.00 IPv6 5
131 0 1.178800e+00 0.0 0.0 10000 8483.00 IPv6 7
133 0 1.928180e-01 0.0 0.0 10000 51860.00 IPv6 2
135 0 2.898180e-01 0.0 0.0 10000 34500.00 IPv6 1
137 0 5.027890e-01 0.0 0.0 10000 19890.00 IPv6 4
139 0 1.093045e+00 0.0 0.0 10000 9149.00 IPv6 7
141 0 8.805700e-02 0.0 0.1 10000 113600.00 IPv6 3
143 0 1.169130e-01 10.1 0.1 10000 85530.00 IPv6 2
145 0 1.262940e-01 20.1 0.1 10000 79180.00 IPv6 2
147 0 1.242945e+00 50.0 0.1 10000 8045.00 IPv6 8
149 0 2.929090e-01 100.0 0.1 10000 34140.00 IPv6 2
151 0 5.078420e-01 200.0 0.1 10000 19690.00 IPv6 4
153 0 1.092570e+00 500.0 0.1 10000 9153.00 IPv6 5
155 0 1.124391e+00 0.0 10.0 10000 8894.00 IPv6 9
157 0 1.164934e+00 10.1 10.0 10000 8584.00 IPv6 7
159 0 1.150071e+00 20.1 10.0 10000 8695.00 IPv6 10
161 0 1.223903e+00 50.0 10.0 10000 8171.00 IPv6 7
163 0 2.968980e-01 100.0 10.0 10000 33680.00 IPv6 3
165 0 5.501624e+00 200.0 10.0 10000 1818.00 IPv6 22
167 0 1.094295e+00 500.0 10.0 10000 9138.00 IPv6 5
169 0 5.095422e+00 0.0 20.0 10000 1963.00 IPv6 8
171 0 1.140340e-01 10.1 20.0 10000 87690.00 IPv6 0
173 0 1.414143e+01 20.1 20.0 10000 707.10 IPv6 15
175 0 2.007220e-01 50.0 20.0 10000 49820.00 IPv6 2
177 0 1.331848e+00 100.0 20.0 10000 7508.00 IPv6 7
179 0 4.894220e-01 200.0 20.0 10000 20430.00 IPv6 1
181 0 1.101102e+00 500.0 20.0 10000 9082.00 IPv6 4
183 0 9.096200e-02 0.0 30.1 10000 109900.00 IPv6 1
185 0 1.143320e-01 10.1 30.1 10000 87460.00 IPv6 1
187 0 1.142168e+00 20.1 30.1 10000 8755.00 IPv6 5
189 0 1.925780e-01 50.0 30.1 10000 51930.00 IPv6 1
191 0 5.298921e+00 100.0 30.1 10000 1887.00 IPv6 7
193 0 4.866800e-01 200.0 30.1 10000 20550.00 IPv6 1
195 0 1.085874e+00 500.0 30.1 10000 9209.00 IPv6 2
197 0 1.137484e+00 0.0 50.2 10000 8791.00 IPv6 8
199 0 1.104854e+00 10.1 50.2 10000 9051.00 IPv6 21
201 0 1.117708e+00 20.1 50.2 10000 8947.00 IPv6 19
203 0 1.199152e+00 50.0 50.2 10000 8339.00 IPv6 4
205 0 2.937730e-01 100.0 50.2 10000 34040.00 IPv6 1
207 0 1.544217e+00 200.0 50.2 10000 6476.00 IPv6 9
209 0 2.147293e+01 500.0 50.2 10000 465.70 IPv6 28
211 0 2.042370e+01 0.0 60.0 10000 489.60 IPv6 14
213 0 3.189230e+00 10.1 60.0 10000 3136.00 IPv6 8
215 0 6.931068e+01 20.1 60.0 10000 144.30 IPv6 70
217 0 8.280709e+00 50.0 60.0 10000 1208.00 IPv6 11
219 0 1.430836e+01 100.0 60.0 10000 698.90 IPv6 22
221 0 1.536902e+00 200.0 60.0 10000 6507.00 IPv6 9
223 1000000000 1.000000e+09 500.0 60.0 10000 0.00 IPv6 22
225 0 1.519970e+01 0.0 70.0 10000 657.90 IPv6 5
227 0 5.066895e+01 10.1 70.0 10000 197.40 IPv6 25
229 0 1.914677e+01 20.1 70.0 10000 522.30 IPv6 17
231 0 8.253090e+00 50.0 70.0 10000 1212.00 IPv6 9
233 0 1.357201e+00 100.0 70.0 10000 7368.00 IPv6 5
235 0 3.012837e+01 200.0 70.0 10000 331.90 IPv6 38
237 0 1.098229e+00 500.0 70.0 10000 9106.00 IPv6 2
239 1000000000 1.000000e+09 0.0 80.0 10000 0.00 IPv6 44
241 1000000000 1.000000e+09 10.1 80.0 10000 0.00 IPv6 3
243 1000000000 1.000000e+09 20.1 80.0 10000 0.00 IPv6 24
245 1000000000 1.000000e+09 50.0 80.0 10000 0.00 IPv6 60
247 1000000000 1.000000e+09 100.0 80.0 10000 0.00 IPv6 62
249 1000000000 1.000000e+09 200.0 80.0 10000 0.00 IPv6 89
251 0 4.124890e+00 500.0 80.0 10000 2424.00 IPv6 9
253 0 7.345037e+01 0.0 0.0 100000 1361.00 IPv6 16
255 0 8.163751e+01 0.0 0.0 100000 1225.00 IPv6 8
257 0 9.804780e+01 0.0 0.0 100000 1020.00 IPv6 13
259 0 7.345334e+01 0.0 0.0 100000 1361.00 IPv6 11
261 0 7.345218e+01 0.0 0.0 100000 1361.00 IPv6 11
263 0 1.105165e+02 0.0 0.0 100000 904.80 IPv6 17
265 0 9.803299e+01 0.0 0.0 100000 1020.00 IPv6 15
267 0 7.754611e+01 0.0 0.1 100000 1290.00 IPv6 10
269 0 8.574699e+01 10.1 0.1 100000 1166.00 IPv6 8
271 0 9.394777e+01 20.1 0.1 100000 1064.00 IPv6 12
273 0 7.345592e+01 50.0 0.1 100000 1361.00 IPv6 15
275 0 7.345766e+01 100.0 0.1 100000 1361.00 IPv6 7
277 0 9.801689e+01 200.0 0.1 100000 1020.00 IPv6 11
279 0 9.852563e+01 500.0 0.1 100000 1015.00 IPv6 23
281 0 7.754564e+01 0.0 10.0 100000 1290.00 IPv6 8
283 0 8.984900e+01 10.1 10.0 100000 1113.00 IPv6 12
285 0 9.396849e+01 20.1 10.0 100000 1064.00 IPv6 12
287 0 7.347942e+01 50.0 10.0 100000 1361.00 IPv6 12
289 0 1.431857e+02 100.0 10.0 100000 698.40 IPv6 25
291 0 1.103194e+02 200.0 10.0 100000 906.50 IPv6 15
293 0 9.854345e+01 500.0 10.0 100000 1015.00 IPv6 16
295 0 7.344033e+01 0.0 20.0 100000 1362.00 IPv6 23
297 0 4.421077e+02 10.1 20.0 100000 226.20 IPv6 71
299 0 1.021572e+02 20.1 20.0 100000 978.90 IPv6 9
301 0 7.345674e+01 50.0 20.0 100000 1361.00 IPv6 31
303 0 2.025309e+02 100.0 20.0 100000 493.80 IPv6 22
305 0 9.823489e+01 200.0 20.0 100000 1018.00 IPv6 8
307 0 9.803865e+01 500.0 20.0 100000 1020.00 IPv6 9
309 0 1.553977e+02 0.0 30.1 100000 643.50 IPv6 38
311 0 1.185024e+02 10.1 30.1 100000 843.90 IPv6 30
313 0 9.806370e+01 20.1 30.1 100000 1020.00 IPv6 45
315 0 1.021168e+02 50.0 30.1 100000 979.30 IPv6 30
317 0 9.802461e+01 100.0 30.1 100000 1020.00 IPv6 18
319 0 5.948479e+02 200.0 30.1 100000 168.10 IPv6 90
321 0 3.371099e+02 500.0 30.1 100000 296.60 IPv6 72
323 0 1.103150e+02 0.0 50.2 100000 906.50 IPv6 42
325 0 3.233159e+02 10.1 50.2 100000 309.30 IPv6 108
327 0 3.417038e+02 20.1 50.2 100000 292.70 IPv6 126
329 0 2.270694e+02 50.0 50.2 100000 440.40 IPv6 72
331 0 3.120910e+00 100.0 50.2 100000 32040.00 IPv6 4
333 0 1.965224e+02 200.0 50.2 100000 508.80 IPv6 75
335 0 1.062212e+02 500.0 50.2 100000 941.40 IPv6 54
337 0 2.618669e+02 0.0 60.0 100000 381.90 IPv6 71
339 0 3.847530e+02 10.1 60.0 100000 259.90 IPv6 133
341 0 3.315202e+02 20.1 60.0 100000 301.60 IPv6 121
343 0 3.355849e+02 50.0 60.0 100000 298.00 IPv6 103
345 0 1.758481e+02 100.0 60.0 100000 568.70 IPv6 66
347 0 4.666542e+02 200.0 60.0 100000 214.30 IPv6 194
349 0 1.184980e+02 500.0 60.0 100000 843.90 IPv6 60
351 0 1.103227e+02 0.0 70.0 100000 906.40 IPv6 59
353 0 3.184035e+02 10.1 70.0 100000 314.10 IPv6 126
355 0 6.550815e+02 20.1 70.0 100000 152.70 IPv6 192
357 0 1.000936e+02 50.0 70.0 100000 999.10 IPv6 67
359 0 6.981425e+02 100.0 70.0 100000 143.20 IPv6 262
361 1000000000 1.000000e+09 200.0 70.0 100000 0.00 IPv6 20
363 0 3.245648e+02 500.0 70.0 100000 308.10 IPv6 106
365 0 9.340564e+02 0.0 80.0 100000 107.10 IPv6 318
367 0 8.103909e+02 10.1 80.0 100000 123.40 IPv6 266
369 0 1.018021e+03 20.1 80.0 100000 98.23 IPv6 347
371 1000000000 1.000000e+09 50.0 80.0 100000 0.00 IPv6 81
373 0 9.330296e+02 100.0 80.0 100000 107.20 IPv6 242
375 1000000000 1.000000e+09 200.0 80.0 100000 0.00 IPv6 50
377 0 9.349269e+02 500.0 80.0 100000 107.00 IPv6 234
379 0 7.339756e+01 0.0 0.0 200000 2725.00 IPv6 8
381 0 8.157893e+01 0.0 0.0 200000 2452.00 IPv6 8
383 0 9.384686e+01 0.0 0.0 200000 2131.00 IPv6 14
385 0 7.340194e+01 0.0 0.0 200000 2725.00 IPv6 7
387 0 1.144625e+02 0.0 0.0 200000 1747.00 IPv6 7
389 0 1.145612e+02 0.0 0.0 200000 1746.00 IPv6 7
391 0 9.802458e+01 0.0 0.0 200000 2040.00 IPv6 10
393 0 7.345150e+01 0.0 0.1 200000 2723.00 IPv6 13
395 0 8.159717e+01 10.1 0.1 200000 2451.00 IPv6 13
397 0 9.391429e+01 20.1 0.1 200000 2130.00 IPv6 8
399 0 1.061767e+02 50.0 0.1 200000 1884.00 IPv6 9
401 0 7.338370e+01 100.0 0.1 200000 2725.00 IPv6 12
403 0 9.408251e+01 200.0 0.1 200000 2126.00 IPv6 6
405 0 9.793298e+01 500.0 0.1 200000 2042.00 IPv6 12
407 0 7.738448e+01 0.0 10.0 200000 2584.00 IPv6 9
409 0 8.153518e+01 10.1 10.0 200000 2453.00 IPv6 8
411 0 8.565282e+01 20.1 10.0 200000 2335.00 IPv6 17
413 0 1.061712e+02 50.0 10.0 200000 1884.00 IPv6 8
415 0 1.144115e+02 100.0 10.0 200000 1748.00 IPv6 10
417 0 1.104284e+02 200.0 10.0 200000 1811.00 IPv6 24
419 0 1.020015e+02 500.0 10.0 200000 1961.00 IPv6 12
421 0 1.470911e+02 0.0 20.0 200000 1360.00 IPv6 23
423 0 7.745164e+01 10.1 20.0 200000 2582.00 IPv6 13
425 0 1.675594e+02 20.1 20.0 200000 1194.00 IPv6 46
427 0 1.061849e+02 50.0 20.0 200000 1884.00 IPv6 24
429 0 9.811067e+01 100.0 20.0 200000 2039.00 IPv6 10
431 0 1.114720e+02 200.0 20.0 200000 1794.00 IPv6 23
433 0 1.148837e+02 500.0 20.0 200000 1741.00 IPv6 18
435 0 3.314803e+02 0.0 30.1 200000 603.40 IPv6 49
437 0 1.062219e+02 10.1 30.1 200000 1883.00 IPv6 17
439 0 1.021565e+02 20.1 30.1 200000 1958.00 IPv6 12
441 0 1.062610e+02 50.0 30.1 200000 1882.00 IPv6 36
443 0 9.912143e+01 100.0 30.1 200000 2018.00 IPv6 28
445 0 9.822945e+01 200.0 30.1 200000 2036.00 IPv6 8
447 0 9.803905e+01 500.0 30.1 200000 2040.00 IPv6 32
449 0 2.045242e+02 0.0 50.2 200000 977.90 IPv6 71
451 0 9.393408e+01 10.1 50.2 200000 2129.00 IPv6 19
453 0 7.754607e+01 20.1 50.2 200000 2579.00 IPv6 50
455 0 1.144658e+02 50.0 50.2 200000 1747.00 IPv6 40
457 0 1.974297e+02 100.0 50.2 200000 1013.00 IPv6 60
459 0 1.184996e+02 200.0 50.2 200000 1688.00 IPv6 31
461 0 7.221258e+02 500.0 50.2 200000 277.00 IPv6 169
463 0 1.102828e+02 0.0 60.0 200000 1814.00 IPv6 53
465 0 2.178146e+02 10.1 60.0 200000 918.20 IPv6 59
467 0 2.260163e+02 20.1 60.0 200000 884.90 IPv6 59
469 0 1.104480e+02 50.0 60.0 200000 1811.00 IPv6 49
471 0 1.145079e+02 100.0 60.0 200000 1747.00 IPv6 71
473 0 5.690684e+02 200.0 60.0 200000 351.50 IPv6 197
475 0 1.322889e+02 500.0 60.0 200000 1512.00 IPv6 17
477 0 5.731746e+02 0.0 70.0 200000 348.90 IPv6 190
479 0 5.627043e+01 10.1 70.0 200000 3554.00 IPv6 15
481 0 7.656986e+02 20.1 70.0 200000 261.20 IPv6 221
483 0 1.985073e+02 50.0 70.0 200000 1008.00 IPv6 77
485 0 5.808588e+02 100.0 70.0 200000 344.30 IPv6 232
487 0 9.387047e+02 200.0 70.0 200000 213.10 IPv6 393
489 0 2.022133e+02 500.0 70.0 200000 989.10 IPv6 28
491 1000000000 1.000000e+09 0.0 80.0 200000 0.00 IPv6 25
493 0 7.084289e+02 10.1 80.0 200000 282.30 IPv6 176
495 1000000000 1.000000e+09 20.1 80.0 200000 0.00 IPv6 66
497 1000000000 1.000000e+09 50.0 80.0 200000 0.00 IPv6 13
499 1000000000 1.000000e+09 100.0 80.0 200000 0.00 IPv6 51
501 1000000000 1.000000e+09 200.0 80.0 200000 0.00 IPv6 130
503 1000000000 1.000000e+09 500.0 80.0 200000 0.00 IPv6 3

In [68]:
df.describe()


Out[68]:
retries elapsed delay loss size rate GTRs
count 5.040000e+02 5.040000e+02 504.000000 504.00000 504.000000 504.000000 504.000000
mean 5.555556e+07 5.555565e+07 111.771429 35.60000 77750.000000 6460.275437 34.303571
std 2.292890e+08 2.292890e+08 161.356007 28.74132 80579.591564 17853.285031 57.687934
min 0.000000e+00 8.186200e-02 0.000000 0.00000 1000.000000 0.000000 0.000000
25% 0.000000e+00 1.177788e+00 10.100000 10.00000 7750.000000 451.775000 6.000000
50% 0.000000e+00 7.317977e+01 50.000000 30.10000 55000.000000 1078.500000 12.500000
75% 0.000000e+00 1.144243e+02 200.000000 60.00000 125000.000000 2581.250000 37.000000
max 1.000000e+09 1.000000e+09 500.000000 80.00000 200000.000000 121500.000000 430.000000

In [69]:
pd.set_option('display.max_columns', 8)
pd.set_option('display.max_rows', 500)
df.sort_values(by=["size","rate","loss","delay"])


Out[69]:
retries elapsed delay loss size rate proto GTRs
86 1000000000 1.000000e+09 10.1 60.0 1000 0.00 IPv4 50
96 1000000000 1.000000e+09 500.0 60.0 1000 0.00 IPv4 72
99 1000000000 1.000000e+09 0.0 70.0 1000 0.00 IPv6 43
101 1000000000 1.000000e+09 10.1 70.0 1000 0.00 IPv6 83
118 1000000000 1.000000e+09 50.0 80.0 1000 0.00 IPv4 17
120 1000000000 1.000000e+09 100.0 80.0 1000 0.00 IPv4 76
121 1000000000 1.000000e+09 100.0 80.0 1000 0.00 IPv6 16
105 0 3.177288e+01 50.0 70.0 1000 31.47 IPv6 39
104 0 2.230765e+01 50.0 70.0 1000 44.83 IPv4 8
95 0 2.172292e+01 200.0 60.0 1000 46.03 IPv6 35
90 0 2.023626e+01 50.0 60.0 1000 49.42 IPv4 22
100 0 2.015344e+01 10.1 70.0 1000 49.62 IPv4 16
70 0 2.013481e+01 0.0 50.2 1000 49.67 IPv4 49
123 0 1.970782e+01 200.0 80.0 1000 50.74 IPv6 14
94 0 1.950059e+01 200.0 60.0 1000 51.28 IPv4 18
88 0 1.914208e+01 20.1 60.0 1000 52.24 IPv4 9
102 0 1.913997e+01 20.1 70.0 1000 52.25 IPv4 15
122 0 1.580503e+01 200.0 80.0 1000 63.27 IPv4 11
114 0 1.558113e+01 10.1 80.0 1000 64.18 IPv4 36
103 0 1.543290e+01 20.1 70.0 1000 64.80 IPv6 15
64 0 1.530318e+01 100.0 30.1 1000 65.35 IPv4 22
57 0 1.513214e+01 0.0 30.1 1000 66.08 IPv6 20
59 0 1.513306e+01 10.1 30.1 1000 66.08 IPv6 18
34 0 1.419969e+01 50.0 10.0 1000 70.42 IPv4 27
98 0 1.409397e+01 0.0 70.0 1000 70.95 IPv4 7
109 0 1.258439e+01 200.0 70.0 1000 79.46 IPv6 33
106 0 1.238660e+01 100.0 70.0 1000 80.73 IPv4 20
117 0 1.222141e+01 20.1 80.0 1000 81.82 IPv6 13
110 0 8.192759e+00 500.0 70.0 1000 122.10 IPv4 35
69 0 8.176558e+00 500.0 30.1 1000 122.30 IPv6 22
85 0 8.176565e+00 0.0 60.0 1000 122.30 IPv6 19
82 0 7.139807e+00 500.0 50.2 1000 140.10 IPv4 16
92 0 6.346839e+00 100.0 60.0 1000 157.60 IPv4 6
93 0 6.337136e+00 100.0 60.0 1000 157.80 IPv6 6
51 0 6.332710e+00 100.0 20.0 1000 157.90 IPv6 6
115 0 6.119324e+00 10.1 80.0 1000 163.40 IPv6 11
55 0 6.095500e+00 500.0 20.0 1000 164.10 IPv6 7
53 0 5.495408e+00 200.0 20.0 1000 182.00 IPv6 9
38 0 5.487233e+00 200.0 10.0 1000 182.20 IPv4 10
108 0 5.488765e+00 200.0 70.0 1000 182.20 IPv4 15
107 0 5.302579e+00 100.0 70.0 1000 188.60 IPv6 6
36 0 5.293194e+00 100.0 10.0 1000 188.90 IPv4 8
78 0 5.288229e+00 100.0 50.2 1000 189.10 IPv4 5
49 0 5.204048e+00 50.0 20.0 1000 192.20 IPv6 18
63 0 5.195751e+00 50.0 30.1 1000 192.50 IPv6 11
61 0 5.144070e+00 20.1 30.1 1000 194.40 IPv6 8
75 0 5.134788e+00 20.1 50.2 1000 194.80 IPv6 15
72 0 5.108482e+00 10.1 50.2 1000 195.80 IPv4 7
113 0 5.090129e+00 0.0 80.0 1000 196.50 IPv6 10
112 0 5.087330e+00 0.0 80.0 1000 196.60 IPv4 10
50 0 3.363638e+00 100.0 20.0 1000 297.30 IPv4 9
119 0 3.228394e+00 50.0 80.0 1000 309.80 IPv6 15
83 0 2.154682e+00 500.0 50.2 1000 464.10 IPv6 6
124 0 2.145781e+00 500.0 80.0 1000 466.00 IPv4 8
79 0 1.414105e+00 100.0 50.2 1000 707.20 IPv6 8
9 0 1.357682e+00 0.0 0.0 1000 736.50 IPv6 6
23 0 1.299935e+00 100.0 0.1 1000 769.30 IPv6 10
21 0 1.215317e+00 50.0 0.1 1000 822.80 IPv6 9
91 0 1.208148e+00 50.0 60.0 1000 827.70 IPv6 2
35 0 1.202062e+00 50.0 10.0 1000 831.90 IPv6 5
6 0 1.193125e+00 0.0 0.0 1000 838.10 IPv4 5
77 0 1.187228e+00 50.0 50.2 1000 842.30 IPv6 47
17 0 1.174619e+00 10.1 0.1 1000 851.30 IPv6 6
74 0 1.165431e+00 20.1 50.2 1000 858.10 IPv4 7
31 0 1.165189e+00 10.1 10.0 1000 858.20 IPv6 9
47 0 1.157164e+00 20.1 20.0 1000 864.20 IPv6 7
19 0 1.141908e+00 20.1 0.1 1000 875.70 IPv6 8
33 0 1.141795e+00 20.1 10.0 1000 875.80 IPv6 9
71 0 1.137484e+00 0.0 50.2 1000 879.10 IPv6 3
87 0 1.134708e+00 10.1 60.0 1000 881.30 IPv6 2
45 0 1.133079e+00 10.1 20.0 1000 882.60 IPv6 9
2 0 1.131037e+00 0.0 0.0 1000 884.10 IPv4 3
4 0 1.130612e+00 0.0 0.0 1000 884.50 IPv4 4
29 0 1.118559e+00 0.0 10.0 1000 894.00 IPv6 7
43 0 1.105388e+00 0.0 20.0 1000 904.70 IPv6 7
15 0 1.104843e+00 0.0 0.1 1000 905.10 IPv6 7
13 0 1.095049e+00 0.0 0.0 1000 913.20 IPv6 4
41 0 1.093832e+00 500.0 10.0 1000 914.20 IPv6 3
27 0 1.090637e+00 500.0 0.1 1000 916.90 IPv6 6
26 0 1.086918e+00 500.0 0.1 1000 920.00 IPv4 5
97 0 1.086219e+00 500.0 60.0 1000 920.60 IPv6 1
54 0 1.085956e+00 500.0 20.0 1000 920.80 IPv4 3
68 0 1.084141e+00 500.0 30.1 1000 922.40 IPv4 4
12 0 1.084064e+00 0.0 0.0 1000 922.50 IPv4 6
40 0 1.082245e+00 500.0 10.0 1000 924.00 IPv4 5
125 0 5.811580e-01 500.0 80.0 1000 1721.00 IPv6 41
111 0 5.806860e-01 500.0 70.0 1000 1722.00 IPv6 41
67 0 5.435210e-01 200.0 30.1 1000 1840.00 IPv6 1
11 0 4.998840e-01 0.0 0.0 1000 2000.00 IPv6 2
39 0 4.997220e-01 200.0 10.0 1000 2001.00 IPv6 1
81 0 4.951790e-01 200.0 50.2 1000 2019.00 IPv6 4
10 0 4.903540e-01 0.0 0.0 1000 2039.00 IPv4 4
25 0 4.875630e-01 200.0 0.1 1000 2051.00 IPv6 5
52 0 4.859330e-01 200.0 20.0 1000 2058.00 IPv4 0
80 0 4.848900e-01 200.0 50.2 1000 2062.00 IPv4 0
66 0 4.846540e-01 200.0 30.1 1000 2063.00 IPv4 2
24 0 4.828760e-01 200.0 0.1 1000 2071.00 IPv4 1
65 0 2.935010e-01 100.0 30.1 1000 3407.00 IPv6 0
37 0 2.881080e-01 100.0 10.0 1000 3471.00 IPv6 2
8 0 2.843320e-01 0.0 0.0 1000 3517.00 IPv4 3
22 0 2.834720e-01 100.0 0.1 1000 3528.00 IPv4 0
7 0 1.990360e-01 0.0 0.0 1000 5024.00 IPv6 0
76 0 1.917090e-01 50.0 50.2 1000 5216.00 IPv4 2
20 0 1.855590e-01 50.0 0.1 1000 5389.00 IPv4 0
62 0 1.841200e-01 50.0 30.1 1000 5431.00 IPv4 2
48 0 1.831400e-01 50.0 20.0 1000 5460.00 IPv4 2
5 0 1.330080e-01 0.0 0.0 1000 7518.00 IPv6 1
89 0 1.314540e-01 20.1 60.0 1000 7607.00 IPv6 1
32 0 1.256840e-01 20.1 10.0 1000 7956.00 IPv4 0
46 0 1.249950e-01 20.1 20.0 1000 8000.00 IPv4 0
60 0 1.245900e-01 20.1 30.1 1000 8026.00 IPv4 0
18 0 1.239730e-01 20.1 0.1 1000 8066.00 IPv4 0
84 0 1.185910e-01 0.0 60.0 1000 8432.00 IPv4 0
73 0 1.159320e-01 10.1 50.2 1000 8626.00 IPv6 1
3 0 1.142390e-01 0.0 0.0 1000 8754.00 IPv6 0
16 0 1.078820e-01 10.1 0.1 1000 9269.00 IPv4 1
30 0 1.055920e-01 10.1 10.0 1000 9470.00 IPv4 0
44 0 1.040870e-01 10.1 20.0 1000 9607.00 IPv4 1
58 0 1.038050e-01 10.1 30.1 1000 9633.00 IPv4 0
116 0 9.777500e-02 20.1 80.0 1000 10230.00 IPv4 21
1 0 9.524200e-02 0.0 0.0 1000 10500.00 IPv6 1
14 0 8.744300e-02 0.0 0.1 1000 11440.00 IPv4 0
56 0 8.637200e-02 0.0 30.1 1000 11580.00 IPv4 0
42 0 8.508300e-02 0.0 20.0 1000 11750.00 IPv4 0
28 0 8.505700e-02 0.0 10.0 1000 11760.00 IPv4 0
0 0 8.186200e-02 0.0 0.0 1000 12220.00 IPv4 0
223 1000000000 1.000000e+09 500.0 60.0 10000 0.00 IPv6 22
239 1000000000 1.000000e+09 0.0 80.0 10000 0.00 IPv6 44
241 1000000000 1.000000e+09 10.1 80.0 10000 0.00 IPv6 3
242 1000000000 1.000000e+09 20.1 80.0 10000 0.00 IPv4 33
243 1000000000 1.000000e+09 20.1 80.0 10000 0.00 IPv6 24
245 1000000000 1.000000e+09 50.0 80.0 10000 0.00 IPv6 60
247 1000000000 1.000000e+09 100.0 80.0 10000 0.00 IPv6 62
249 1000000000 1.000000e+09 200.0 80.0 10000 0.00 IPv6 89
215 0 6.931068e+01 20.1 60.0 10000 144.30 IPv6 70
240 0 6.401637e+01 10.1 80.0 10000 156.20 IPv4 62
227 0 5.066895e+01 10.1 70.0 10000 197.40 IPv6 25
210 0 4.797000e+01 0.0 60.0 10000 208.50 IPv4 27
222 0 3.789059e+01 500.0 60.0 10000 263.90 IPv4 38
224 0 3.174388e+01 0.0 70.0 10000 315.00 IPv4 10
235 0 3.012837e+01 200.0 70.0 10000 331.90 IPv6 38
244 0 2.633167e+01 50.0 80.0 10000 379.80 IPv4 5
214 0 2.222864e+01 20.1 60.0 10000 449.90 IPv4 30
209 0 2.147293e+01 500.0 50.2 10000 465.70 IPv6 28
250 0 2.111298e+01 500.0 80.0 10000 473.60 IPv4 9
170 0 2.046449e+01 10.1 20.0 10000 488.70 IPv4 36
211 0 2.042370e+01 0.0 60.0 10000 489.60 IPv6 14
230 0 2.023747e+01 50.0 70.0 10000 494.10 IPv4 14
198 0 2.019871e+01 10.1 50.2 10000 495.10 IPv4 20
190 0 1.930342e+01 100.0 30.1 10000 518.00 IPv4 28
229 0 1.914677e+01 20.1 70.0 10000 522.30 IPv6 17
204 0 1.734830e+01 100.0 50.2 10000 576.40 IPv4 19
225 0 1.519970e+01 0.0 70.0 10000 657.90 IPv6 5
228 0 1.517216e+01 20.1 70.0 10000 659.10 IPv4 5
208 0 1.509876e+01 500.0 50.2 10000 662.30 IPv4 31
194 0 1.509166e+01 500.0 30.1 10000 662.60 IPv4 18
219 0 1.430836e+01 100.0 60.0 10000 698.90 IPv6 22
216 0 1.420074e+01 50.0 60.0 10000 704.20 IPv4 10
173 0 1.414143e+01 20.1 20.0 10000 707.10 IPv6 15
236 0 9.152374e+00 500.0 70.0 10000 1093.00 IPv4 8
217 0 8.280709e+00 50.0 60.0 10000 1208.00 IPv6 11
231 0 8.253090e+00 50.0 70.0 10000 1212.00 IPv6 9
238 0 7.197658e+00 0.0 80.0 10000 1389.00 IPv4 37
165 0 5.501624e+00 200.0 10.0 10000 1818.00 IPv6 22
191 0 5.298921e+00 100.0 30.1 10000 1887.00 IPv6 7
246 0 5.293237e+00 100.0 80.0 10000 1889.00 IPv4 0
232 0 5.288072e+00 100.0 70.0 10000 1891.00 IPv4 3
212 0 5.107481e+00 10.1 60.0 10000 1958.00 IPv4 6
169 0 5.095422e+00 0.0 20.0 10000 1963.00 IPv6 8
182 0 5.089338e+00 0.0 30.1 10000 1965.00 IPv4 15
251 0 4.124890e+00 500.0 80.0 10000 2424.00 IPv6 9
248 0 3.378971e+00 200.0 80.0 10000 2959.00 IPv4 9
172 0 3.243391e+00 20.1 20.0 10000 3083.00 IPv4 8
202 0 3.199960e+00 50.0 50.2 10000 3125.00 IPv4 31
226 0 3.195272e+00 10.1 70.0 10000 3130.00 IPv4 5
213 0 3.189230e+00 10.1 60.0 10000 3136.00 IPv6 8
184 0 3.157883e+00 10.1 30.1 10000 3167.00 IPv4 11
192 0 1.545667e+00 200.0 30.1 10000 6470.00 IPv4 3
207 0 1.544217e+00 200.0 50.2 10000 6476.00 IPv6 9
234 0 1.540432e+00 200.0 70.0 10000 6492.00 IPv4 3
221 0 1.536902e+00 200.0 60.0 10000 6507.00 IPv6 9
233 0 1.357201e+00 100.0 70.0 10000 7368.00 IPv6 5
177 0 1.331848e+00 100.0 20.0 10000 7508.00 IPv6 7
176 0 1.330335e+00 100.0 20.0 10000 7517.00 IPv4 6
147 0 1.242945e+00 50.0 0.1 10000 8045.00 IPv6 8
161 0 1.223903e+00 50.0 10.0 10000 8171.00 IPv6 7
203 0 1.199152e+00 50.0 50.2 10000 8339.00 IPv6 4
188 0 1.196332e+00 50.0 30.1 10000 8359.00 IPv4 8
144 0 1.185909e+00 20.1 0.1 10000 8432.00 IPv4 6
131 0 1.178800e+00 0.0 0.0 10000 8483.00 IPv6 7
129 0 1.174752e+00 0.0 0.0 10000 8512.00 IPv6 5
157 0 1.164934e+00 10.1 10.0 10000 8584.00 IPv6 7
159 0 1.150071e+00 20.1 10.0 10000 8695.00 IPv6 10
186 0 1.144709e+00 20.1 30.1 10000 8736.00 IPv4 5
187 0 1.142168e+00 20.1 30.1 10000 8755.00 IPv6 5
142 0 1.139582e+00 10.1 0.1 10000 8775.00 IPv4 5
197 0 1.137484e+00 0.0 50.2 10000 8791.00 IPv6 8
127 0 1.126728e+00 0.0 0.0 10000 8875.00 IPv6 7
155 0 1.124391e+00 0.0 10.0 10000 8894.00 IPv6 9
201 0 1.117708e+00 20.1 50.2 10000 8947.00 IPv6 19
199 0 1.104854e+00 10.1 50.2 10000 9051.00 IPv6 21
181 0 1.101102e+00 500.0 20.0 10000 9082.00 IPv6 4
168 0 1.099824e+00 0.0 20.0 10000 9092.00 IPv4 3
237 0 1.098229e+00 500.0 70.0 10000 9106.00 IPv6 2
167 0 1.094295e+00 500.0 10.0 10000 9138.00 IPv6 5
139 0 1.093045e+00 0.0 0.0 10000 9149.00 IPv6 7
153 0 1.092570e+00 500.0 0.1 10000 9153.00 IPv6 5
152 0 1.087211e+00 500.0 0.1 10000 9198.00 IPv4 6
195 0 1.085874e+00 500.0 30.1 10000 9209.00 IPv6 2
180 0 1.084189e+00 500.0 20.0 10000 9223.00 IPv4 8
166 0 1.083892e+00 500.0 10.0 10000 9226.00 IPv4 5
138 0 1.083165e+00 0.0 0.0 10000 9232.00 IPv4 4
151 0 5.078420e-01 200.0 0.1 10000 19690.00 IPv6 4
137 0 5.027890e-01 0.0 0.0 10000 19890.00 IPv6 4
164 0 4.960620e-01 200.0 10.0 10000 20160.00 IPv4 3
136 0 4.904900e-01 0.0 0.0 10000 20390.00 IPv4 4
179 0 4.894220e-01 200.0 20.0 10000 20430.00 IPv6 1
193 0 4.866800e-01 200.0 30.1 10000 20550.00 IPv6 1
178 0 4.864030e-01 200.0 20.0 10000 20560.00 IPv4 2
150 0 4.858000e-01 200.0 0.1 10000 20580.00 IPv4 3
220 0 4.852180e-01 200.0 60.0 10000 20610.00 IPv4 5
206 0 4.835180e-01 200.0 50.2 10000 20680.00 IPv4 3
163 0 2.968980e-01 100.0 10.0 10000 33680.00 IPv6 3
205 0 2.937730e-01 100.0 50.2 10000 34040.00 IPv6 1
149 0 2.929090e-01 100.0 0.1 10000 34140.00 IPv6 2
134 0 2.909790e-01 0.0 0.0 10000 34370.00 IPv4 2
135 0 2.898180e-01 0.0 0.0 10000 34500.00 IPv6 1
162 0 2.880670e-01 100.0 10.0 10000 34710.00 IPv4 1
148 0 2.866570e-01 100.0 0.1 10000 34880.00 IPv4 0
218 0 2.848750e-01 100.0 60.0 10000 35100.00 IPv4 0
175 0 2.007220e-01 50.0 20.0 10000 49820.00 IPv6 2
133 0 1.928180e-01 0.0 0.0 10000 51860.00 IPv6 2
189 0 1.925780e-01 50.0 30.1 10000 51930.00 IPv6 1
132 0 1.854200e-01 0.0 0.0 10000 53930.00 IPv4 0
160 0 1.853530e-01 50.0 10.0 10000 53950.00 IPv4 0
146 0 1.836670e-01 50.0 0.1 10000 54450.00 IPv4 2
174 0 1.835500e-01 50.0 20.0 10000 54480.00 IPv4 2
200 0 1.369240e-01 20.1 50.2 10000 73030.00 IPv4 0
130 0 1.293410e-01 0.0 0.0 10000 77320.00 IPv4 1
145 0 1.262940e-01 20.1 0.1 10000 79180.00 IPv6 2
158 0 1.254760e-01 20.1 10.0 10000 79700.00 IPv4 0
143 0 1.169130e-01 10.1 0.1 10000 85530.00 IPv6 2
185 0 1.143320e-01 10.1 30.1 10000 87460.00 IPv6 1
171 0 1.140340e-01 10.1 20.0 10000 87690.00 IPv6 0
128 0 1.084630e-01 0.0 0.0 10000 92200.00 IPv4 2
156 0 1.081010e-01 10.1 10.0 10000 92510.00 IPv4 1
196 0 9.234800e-02 0.0 50.2 10000 108300.00 IPv4 0
183 0 9.096200e-02 0.0 30.1 10000 109900.00 IPv6 1
141 0 8.805700e-02 0.0 0.1 10000 113600.00 IPv6 3
154 0 8.772500e-02 0.0 10.0 10000 114000.00 IPv4 0
... ... ... ... ... ... ... ... ...
371 1000000000 1.000000e+09 50.0 80.0 100000 0.00 IPv6 81
372 1000000000 1.000000e+09 100.0 80.0 100000 0.00 IPv4 44
375 1000000000 1.000000e+09 200.0 80.0 100000 0.00 IPv6 50
369 0 1.018021e+03 20.1 80.0 100000 98.23 IPv6 347
377 0 9.349269e+02 500.0 80.0 100000 107.00 IPv6 234
365 0 9.340564e+02 0.0 80.0 100000 107.10 IPv6 318
373 0 9.330296e+02 100.0 80.0 100000 107.20 IPv6 242
367 0 8.103909e+02 10.1 80.0 100000 123.40 IPv6 266
359 0 6.981425e+02 100.0 70.0 100000 143.20 IPv6 262
355 0 6.550815e+02 20.1 70.0 100000 152.70 IPv6 192
330 0 6.487676e+02 100.0 50.2 100000 154.10 IPv4 213
319 0 5.948479e+02 200.0 30.1 100000 168.10 IPv6 90
347 0 4.666542e+02 200.0 60.0 100000 214.30 IPv6 194
376 0 4.587917e+02 500.0 80.0 100000 218.00 IPv4 198
297 0 4.421077e+02 10.1 20.0 100000 226.20 IPv6 71
339 0 3.847530e+02 10.1 60.0 100000 259.90 IPv6 133
334 0 3.600551e+02 500.0 50.2 100000 277.70 IPv4 97
327 0 3.417038e+02 20.1 50.2 100000 292.70 IPv6 126
318 0 3.395345e+02 200.0 30.1 100000 294.50 IPv4 66
354 0 3.394980e+02 20.1 70.0 100000 294.60 IPv4 187
321 0 3.371099e+02 500.0 30.1 100000 296.60 IPv6 72
343 0 3.355849e+02 50.0 60.0 100000 298.00 IPv6 103
341 0 3.315202e+02 20.1 60.0 100000 301.60 IPv6 121
363 0 3.245648e+02 500.0 70.0 100000 308.10 IPv6 106
325 0 3.233159e+02 10.1 50.2 100000 309.30 IPv6 108
340 0 3.227777e+02 20.1 60.0 100000 309.80 IPv4 160
353 0 3.184035e+02 10.1 70.0 100000 314.10 IPv6 126
362 0 2.744031e+02 500.0 70.0 100000 364.40 IPv4 120
337 0 2.618669e+02 0.0 60.0 100000 381.90 IPv6 71
306 0 2.289858e+02 500.0 20.0 100000 436.70 IPv4 36
329 0 2.270694e+02 50.0 50.2 100000 440.40 IPv6 72
360 0 2.105017e+02 200.0 70.0 100000 475.10 IPv4 115
348 0 2.075039e+02 500.0 60.0 100000 481.90 IPv4 99
303 0 2.025309e+02 100.0 20.0 100000 493.80 IPv6 22
320 0 1.993248e+02 500.0 30.1 100000 501.70 IPv4 85
370 0 1.991319e+02 50.0 80.0 100000 502.20 IPv4 92
342 0 1.966473e+02 50.0 60.0 100000 508.50 IPv4 90
333 0 1.965224e+02 200.0 50.2 100000 508.80 IPv6 75
336 0 1.961510e+02 0.0 60.0 100000 509.80 IPv4 129
345 0 1.758481e+02 100.0 60.0 100000 568.70 IPv6 66
358 0 1.612981e+02 100.0 70.0 100000 620.00 IPv4 68
309 0 1.553977e+02 0.0 30.1 100000 643.50 IPv6 38
282 0 1.510603e+02 10.1 10.0 100000 662.00 IPv4 37
324 0 1.510603e+02 10.1 50.2 100000 662.00 IPv4 39
289 0 1.431857e+02 100.0 10.0 100000 698.40 IPv6 25
311 0 1.185024e+02 10.1 30.1 100000 843.90 IPv6 30
349 0 1.184980e+02 500.0 60.0 100000 843.90 IPv6 60
326 0 1.183371e+02 20.1 50.2 100000 845.00 IPv4 30
328 0 1.163075e+02 50.0 50.2 100000 859.80 IPv4 15
292 0 1.144894e+02 500.0 10.0 100000 873.40 IPv4 13
278 0 1.144072e+02 500.0 0.1 100000 874.10 IPv4 10
264 0 1.142326e+02 0.0 0.0 100000 875.40 IPv4 11
263 0 1.105165e+02 0.0 0.0 100000 904.80 IPv6 17
351 0 1.103227e+02 0.0 70.0 100000 906.40 IPv6 59
291 0 1.103194e+02 200.0 10.0 100000 906.50 IPv6 15
323 0 1.103150e+02 0.0 50.2 100000 906.50 IPv6 42
262 0 1.102046e+02 0.0 0.0 100000 907.40 IPv4 8
276 0 1.101706e+02 200.0 0.1 100000 907.70 IPv4 11
290 0 1.101065e+02 200.0 10.0 100000 908.20 IPv4 8
335 0 1.062212e+02 500.0 50.2 100000 941.40 IPv6 54
374 0 1.025828e+02 200.0 80.0 100000 974.80 IPv4 80
356 0 1.024886e+02 50.0 70.0 100000 975.70 IPv4 22
299 0 1.021572e+02 20.1 20.0 100000 978.90 IPv6 9
315 0 1.021168e+02 50.0 30.1 100000 979.30 IPv6 30
310 0 1.019182e+02 10.1 30.1 100000 981.20 IPv4 22
300 0 1.019062e+02 50.0 20.0 100000 981.30 IPv4 14
338 0 1.019093e+02 10.1 60.0 100000 981.30 IPv4 32
272 0 1.018880e+02 50.0 0.1 100000 981.50 IPv4 9
258 0 1.018601e+02 0.0 0.0 100000 981.70 IPv4 8
357 0 1.000936e+02 50.0 70.0 100000 999.10 IPv6 67
304 0 9.994580e+01 200.0 20.0 100000 1001.00 IPv4 7
364 0 9.969142e+01 0.0 80.0 100000 1003.00 IPv4 117
332 0 9.859597e+01 200.0 50.2 100000 1014.00 IPv4 31
279 0 9.852563e+01 500.0 0.1 100000 1015.00 IPv6 23
293 0 9.854345e+01 500.0 10.0 100000 1015.00 IPv6 16
305 0 9.823489e+01 200.0 20.0 100000 1018.00 IPv6 8
257 0 9.804780e+01 0.0 0.0 100000 1020.00 IPv6 13
265 0 9.803299e+01 0.0 0.0 100000 1020.00 IPv6 15
277 0 9.801689e+01 200.0 0.1 100000 1020.00 IPv6 11
307 0 9.803865e+01 500.0 20.0 100000 1020.00 IPv6 9
313 0 9.806370e+01 20.1 30.1 100000 1020.00 IPv6 45
317 0 9.802461e+01 100.0 30.1 100000 1020.00 IPv6 18
286 0 9.785012e+01 50.0 10.0 100000 1022.00 IPv4 15
302 0 9.789066e+01 100.0 20.0 100000 1022.00 IPv4 34
312 0 9.787769e+01 20.1 30.1 100000 1022.00 IPv4 6
314 0 9.776713e+01 50.0 30.1 100000 1023.00 IPv4 12
308 0 9.736487e+01 0.0 30.1 100000 1027.00 IPv4 39
368 0 9.663114e+01 20.1 80.0 100000 1035.00 IPv4 47
271 0 9.394777e+01 20.1 0.1 100000 1064.00 IPv6 12
285 0 9.396849e+01 20.1 10.0 100000 1064.00 IPv6 12
283 0 8.984900e+01 10.1 10.0 100000 1113.00 IPv6 12
269 0 8.574699e+01 10.1 0.1 100000 1166.00 IPv6 8
344 0 8.556262e+01 100.0 60.0 100000 1169.00 IPv4 37
255 0 8.163751e+01 0.0 0.0 100000 1225.00 IPv6 8
284 0 8.141956e+01 20.1 10.0 100000 1228.00 IPv4 21
256 0 8.138903e+01 0.0 0.0 100000 1229.00 IPv4 8
352 0 7.845143e+01 10.1 70.0 100000 1275.00 IPv4 41
267 0 7.754611e+01 0.0 0.1 100000 1290.00 IPv6 10
281 0 7.754564e+01 0.0 10.0 100000 1290.00 IPv6 8
296 0 7.739911e+01 10.1 20.0 100000 1292.00 IPv4 9
298 0 7.737376e+01 20.1 20.0 100000 1292.00 IPv4 31
254 0 7.733258e+01 0.0 0.0 100000 1293.00 IPv4 11
268 0 7.736299e+01 10.1 0.1 100000 1293.00 IPv4 8
270 0 7.736141e+01 20.1 0.1 100000 1293.00 IPv4 13
322 0 7.532536e+01 0.0 50.2 100000 1328.00 IPv4 38
253 0 7.345037e+01 0.0 0.0 100000 1361.00 IPv6 16
259 0 7.345334e+01 0.0 0.0 100000 1361.00 IPv6 11
261 0 7.345218e+01 0.0 0.0 100000 1361.00 IPv6 11
273 0 7.345592e+01 50.0 0.1 100000 1361.00 IPv6 15
275 0 7.345766e+01 100.0 0.1 100000 1361.00 IPv6 7
287 0 7.347942e+01 50.0 10.0 100000 1361.00 IPv6 12
301 0 7.345674e+01 50.0 20.0 100000 1361.00 IPv6 31
295 0 7.344033e+01 0.0 20.0 100000 1362.00 IPv6 23
252 0 7.309163e+01 0.0 0.0 100000 1368.00 IPv4 12
266 0 7.273206e+01 0.0 0.1 100000 1375.00 IPv4 9
350 0 7.251633e+01 0.0 70.0 100000 1379.00 IPv4 61
294 0 7.220803e+01 0.0 20.0 100000 1385.00 IPv4 17
280 0 7.217292e+01 0.0 10.0 100000 1386.00 IPv4 8
288 0 6.924019e+01 100.0 10.0 100000 1444.00 IPv4 9
260 0 6.918847e+01 0.0 0.0 100000 1445.00 IPv4 13
274 0 6.917846e+01 100.0 0.1 100000 1446.00 IPv4 9
316 0 6.914138e+01 100.0 30.1 100000 1446.00 IPv4 24
366 0 1.578659e+01 10.1 80.0 100000 6334.00 IPv4 10
331 0 3.120910e+00 100.0 50.2 100000 32040.00 IPv6 4
462 1000000000 1.000000e+09 0.0 60.0 200000 0.00 IPv4 52
491 1000000000 1.000000e+09 0.0 80.0 200000 0.00 IPv6 25
494 1000000000 1.000000e+09 20.1 80.0 200000 0.00 IPv4 15
495 1000000000 1.000000e+09 20.1 80.0 200000 0.00 IPv6 66
497 1000000000 1.000000e+09 50.0 80.0 200000 0.00 IPv6 13
499 1000000000 1.000000e+09 100.0 80.0 200000 0.00 IPv6 51
501 1000000000 1.000000e+09 200.0 80.0 200000 0.00 IPv6 130
503 1000000000 1.000000e+09 500.0 80.0 200000 0.00 IPv6 3
492 0 1.015203e+03 10.1 80.0 200000 197.00 IPv4 253
496 0 9.947217e+02 50.0 80.0 200000 201.10 IPv4 208
468 0 9.690705e+02 50.0 60.0 200000 206.40 IPv4 310
482 0 9.537041e+02 50.0 70.0 200000 209.70 IPv4 430
487 0 9.387047e+02 200.0 70.0 200000 213.10 IPv6 393
456 0 8.801464e+02 100.0 50.2 200000 227.20 IPv4 228
470 0 8.392568e+02 100.0 60.0 200000 238.30 IPv4 242
481 0 7.656986e+02 20.1 70.0 200000 261.20 IPv6 221
461 0 7.221258e+02 500.0 50.2 200000 277.00 IPv6 169
493 0 7.084289e+02 10.1 80.0 200000 282.30 IPv6 176
466 0 7.001374e+02 20.1 60.0 200000 285.70 IPv4 253
485 0 5.808588e+02 100.0 70.0 200000 344.30 IPv6 232
477 0 5.731746e+02 0.0 70.0 200000 348.90 IPv6 190
473 0 5.690684e+02 200.0 60.0 200000 351.50 IPv6 197
454 0 5.648223e+02 50.0 50.2 200000 354.10 IPv4 151
488 0 4.465953e+02 500.0 70.0 200000 447.80 IPv4 114
500 0 4.420530e+02 200.0 80.0 200000 452.40 IPv4 41
432 0 3.631544e+02 500.0 20.0 200000 550.70 IPv4 57
435 0 3.314803e+02 0.0 30.1 200000 603.40 IPv6 49
486 0 3.227298e+02 200.0 70.0 200000 619.70 IPv4 91
478 0 2.862494e+02 10.1 70.0 200000 698.70 IPv4 113
498 0 2.617394e+02 100.0 80.0 200000 764.10 IPv4 66
420 0 2.516014e+02 0.0 20.0 200000 794.90 IPv4 43
467 0 2.260163e+02 20.1 60.0 200000 884.90 IPv6 59
474 0 2.250929e+02 500.0 60.0 200000 888.50 IPv4 72
446 0 2.248950e+02 500.0 30.1 200000 889.30 IPv4 62
465 0 2.178146e+02 10.1 60.0 200000 918.20 IPv6 59
502 0 2.101601e+02 500.0 80.0 200000 951.70 IPv4 60
449 0 2.045242e+02 0.0 50.2 200000 977.90 IPv6 71
489 0 2.022133e+02 500.0 70.0 200000 989.10 IPv6 28
480 0 2.007242e+02 20.1 70.0 200000 996.40 IPv4 93
483 0 1.985073e+02 50.0 70.0 200000 1008.00 IPv6 77
457 0 1.974297e+02 100.0 50.2 200000 1013.00 IPv6 60
464 0 1.961445e+02 10.1 60.0 200000 1020.00 IPv4 76
425 0 1.675594e+02 20.1 20.0 200000 1194.00 IPv6 46
416 0 1.470082e+02 200.0 10.0 200000 1360.00 IPv4 40
421 0 1.470911e+02 0.0 20.0 200000 1360.00 IPv6 23
442 0 1.387825e+02 100.0 30.1 200000 1441.00 IPv4 13
475 0 1.322889e+02 500.0 60.0 200000 1512.00 IPv6 17
404 0 1.266803e+02 500.0 0.1 200000 1579.00 IPv4 17
384 0 1.265555e+02 0.0 0.0 200000 1580.00 IPv4 13
402 0 1.225255e+02 200.0 0.1 200000 1632.00 IPv4 7
388 0 1.224504e+02 0.0 0.0 200000 1633.00 IPv4 17
430 0 1.224242e+02 200.0 20.0 200000 1634.00 IPv4 24
459 0 1.184996e+02 200.0 50.2 200000 1688.00 IPv6 31
382 0 1.183750e+02 0.0 0.0 200000 1690.00 IPv4 12
433 0 1.148837e+02 500.0 20.0 200000 1741.00 IPv6 18
389 0 1.145612e+02 0.0 0.0 200000 1746.00 IPv6 7
387 0 1.144625e+02 0.0 0.0 200000 1747.00 IPv6 7
455 0 1.144658e+02 50.0 50.2 200000 1747.00 IPv6 40
471 0 1.145079e+02 100.0 60.0 200000 1747.00 IPv6 71
415 0 1.144115e+02 100.0 10.0 200000 1748.00 IPv6 10
390 0 1.142413e+02 0.0 0.0 200000 1751.00 IPv4 7
458 0 1.131972e+02 200.0 50.2 200000 1767.00 IPv4 41
490 0 1.120524e+02 0.0 80.0 200000 1785.00 IPv4 66
431 0 1.114720e+02 200.0 20.0 200000 1794.00 IPv6 23
417 0 1.104284e+02 200.0 10.0 200000 1811.00 IPv6 24
469 0 1.104480e+02 50.0 60.0 200000 1811.00 IPv6 49
378 0 1.102392e+02 0.0 0.0 200000 1814.00 IPv4 11
463 0 1.102828e+02 0.0 60.0 200000 1814.00 IPv6 53
380 0 1.101127e+02 0.0 0.0 200000 1816.00 IPv4 18
450 0 1.100846e+02 10.1 50.2 200000 1817.00 IPv4 35
444 0 1.091069e+02 200.0 30.1 200000 1833.00 IPv4 22
441 0 1.062610e+02 50.0 30.1 200000 1882.00 IPv6 36
460 0 1.062557e+02 500.0 50.2 200000 1882.00 IPv4 45
437 0 1.062219e+02 10.1 30.1 200000 1883.00 IPv6 17
399 0 1.061767e+02 50.0 0.1 200000 1884.00 IPv6 9
413 0 1.061712e+02 50.0 10.0 200000 1884.00 IPv6 8
427 0 1.061849e+02 50.0 20.0 200000 1884.00 IPv6 24
448 0 1.055172e+02 0.0 50.2 200000 1895.00 IPv4 21
472 0 1.022755e+02 200.0 60.0 200000 1956.00 IPv4 61
439 0 1.021565e+02 20.1 30.1 200000 1958.00 IPv6 12
414 0 1.020043e+02 100.0 10.0 200000 1961.00 IPv4 18
419 0 1.020015e+02 500.0 10.0 200000 1961.00 IPv6 12
440 0 1.019110e+02 50.0 30.1 200000 1962.00 IPv4 31
436 0 1.015794e+02 10.1 30.1 200000 1969.00 IPv4 30
434 0 1.009039e+02 0.0 30.1 200000 1982.00 IPv4 40
484 0 1.000336e+02 100.0 70.0 200000 1999.00 IPv4 56
476 0 9.990401e+01 0.0 70.0 200000 2002.00 IPv4 42
443 0 9.912143e+01 100.0 30.1 200000 2018.00 IPv6 28
445 0 9.822945e+01 200.0 30.1 200000 2036.00 IPv6 8
429 0 9.811067e+01 100.0 20.0 200000 2039.00 IPv6 10
391 0 9.802458e+01 0.0 0.0 200000 2040.00 IPv6 10
447 0 9.803905e+01 500.0 30.1 200000 2040.00 IPv6 32
405 0 9.793298e+01 500.0 0.1 200000 2042.00 IPv6 12
403 0 9.408251e+01 200.0 0.1 200000 2126.00 IPv6 6
451 0 9.393408e+01 10.1 50.2 200000 2129.00 IPv6 19
397 0 9.391429e+01 20.1 0.1 200000 2130.00 IPv6 8
383 0 9.384686e+01 0.0 0.0 200000 2131.00 IPv6 14
386 0 9.381502e+01 0.0 0.0 200000 2132.00 IPv4 12
400 0 9.382213e+01 100.0 0.1 200000 2132.00 IPv4 16
396 0 9.375305e+01 20.1 0.1 200000 2133.00 IPv4 8
428 0 9.370532e+01 100.0 20.0 200000 2134.00 IPv4 37
412 0 8.979332e+01 50.0 10.0 200000 2227.00 IPv4 13
426 0 8.972575e+01 50.0 20.0 200000 2229.00 IPv4 9
411 0 8.565282e+01 20.1 10.0 200000 2335.00 IPv6 17
452 0 8.546556e+01 20.1 50.2 200000 2340.00 IPv4 28
395 0 8.159717e+01 10.1 0.1 200000 2451.00 IPv6 13
381 0 8.157893e+01 0.0 0.0 200000 2452.00 IPv6 8
409 0 8.153518e+01 10.1 10.0 200000 2453.00 IPv6 8
394 0 8.149271e+01 10.1 0.1 200000 2454.00 IPv4 13
438 0 8.139604e+01 20.1 30.1 200000 2457.00 IPv4 32
453 0 7.754607e+01 20.1 50.2 200000 2579.00 IPv6 50
410 0 7.747619e+01 20.1 10.0 200000 2581.00 IPv4 8
423 0 7.745164e+01 10.1 20.0 200000 2582.00 IPv6 13
407 0 7.738448e+01 0.0 10.0 200000 2584.00 IPv6 9
424 0 7.738417e+01 20.1 20.0 200000 2585.00 IPv4 22
392 0 7.676701e+01 0.0 0.1 200000 2605.00 IPv4 8
393 0 7.345150e+01 0.0 0.1 200000 2723.00 IPv6 13
379 0 7.339756e+01 0.0 0.0 200000 2725.00 IPv6 8
385 0 7.340194e+01 0.0 0.0 200000 2725.00 IPv6 7
401 0 7.338370e+01 100.0 0.1 200000 2725.00 IPv6 12
422 0 7.332412e+01 10.1 20.0 200000 2728.00 IPv4 18
398 0 7.326791e+01 50.0 0.1 200000 2730.00 IPv4 12
408 0 6.926343e+01 10.1 10.0 200000 2888.00 IPv4 21
406 0 6.871538e+01 0.0 10.0 200000 2911.00 IPv4 9
418 0 6.680351e+01 500.0 10.0 200000 2994.00 IPv4 11
479 0 5.627043e+01 10.1 70.0 200000 3554.00 IPv6 15

504 rows × 8 columns


In [70]:
# calculate seconds/byte
df4=df4.assign(spb=(1.0/df4["rate"]) )
df6=df6.assign(spb=(1.0/df6["rate"]) )
print(df4['spb'])


0      0.000082
2      0.001131
4      0.001131
6      0.001193
8      0.000284
10     0.000490
12     0.001084
14     0.000087
16     0.000108
18     0.000124
20     0.000186
22     0.000283
24     0.000483
26     0.001087
28     0.000085
30     0.000106
32     0.000126
34     0.014201
36     0.005294
38     0.005488
40     0.001082
42     0.000085
44     0.000104
46     0.000125
48     0.000183
50     0.003364
52     0.000486
54     0.001086
56     0.000086
58     0.000104
60     0.000125
62     0.000184
64     0.015302
66     0.000485
68     0.001084
70     0.020133
72     0.005107
74     0.001165
76     0.000192
78     0.005288
80     0.000485
82     0.007138
84     0.000119
86          inf
88     0.019142
90     0.020235
92     0.006345
94     0.019501
96          inf
98     0.014094
100    0.020153
102    0.019139
104    0.022306
106    0.012387
108    0.005488
110    0.008190
112    0.005086
114    0.015581
116    0.000098
118         inf
120         inf
122    0.015805
124    0.002146
126    0.000008
128    0.000011
130    0.000013
132    0.000019
134    0.000029
136    0.000049
138    0.000108
140    0.000009
142    0.000114
144    0.000119
146    0.000018
148    0.000029
150    0.000049
152    0.000109
154    0.000009
156    0.000011
158    0.000013
160    0.000019
162    0.000029
164    0.000050
166    0.000108
168    0.000110
170    0.002046
172    0.000324
174    0.000018
176    0.000133
178    0.000049
180    0.000108
182    0.000509
184    0.000316
186    0.000114
188    0.000120
190    0.001931
192    0.000155
194    0.001509
196    0.000009
198    0.002020
200    0.000014
202    0.000320
204    0.001735
206    0.000048
208    0.001510
210    0.004796
212    0.000511
214    0.002223
216    0.001420
218    0.000028
220    0.000049
222    0.003789
224    0.003175
226    0.000319
228    0.001517
230    0.002024
232    0.000529
234    0.000154
236    0.000915
238    0.000720
240    0.006402
242         inf
244    0.002633
246    0.000529
248    0.000338
250    0.002111
252    0.000731
254    0.000773
256    0.000814
258    0.001019
260    0.000692
262    0.001102
264    0.001142
266    0.000727
268    0.000773
270    0.000773
272    0.001019
274    0.000692
276    0.001102
278    0.001144
280    0.000722
282    0.001511
284    0.000814
286    0.000978
288    0.000693
290    0.001101
292    0.001145
294    0.000722
296    0.000774
298    0.000774
300    0.001019
302    0.000978
304    0.000999
306    0.002290
308    0.000974
310    0.001019
312    0.000978
314    0.000978
316    0.000692
318    0.003396
320    0.001993
322    0.000753
324    0.001511
326    0.001183
328    0.001163
330    0.006489
332    0.000986
334    0.003601
336    0.001962
338    0.001019
340    0.003228
342    0.001967
344    0.000855
346         inf
348    0.002075
350    0.000725
352    0.000784
354    0.003394
356    0.001025
358    0.001613
360    0.002105
362    0.002744
364    0.000997
366    0.000158
368    0.000966
370    0.001991
372         inf
374    0.001026
376    0.004587
378    0.000551
380    0.000551
382    0.000592
384    0.000633
386    0.000469
388    0.000612
390    0.000571
392    0.000384
394    0.000407
396    0.000469
398    0.000366
400    0.000469
402    0.000613
404    0.000633
406    0.000344
408    0.000346
410    0.000387
412    0.000449
414    0.000510
416    0.000735
418    0.000334
420    0.001258
422    0.000367
424    0.000387
426    0.000449
428    0.000469
430    0.000612
432    0.001816
434    0.000505
436    0.000508
438    0.000407
440    0.000510
442    0.000694
444    0.000546
446    0.001124
448    0.000528
450    0.000550
452    0.000427
454    0.002824
456    0.004401
458    0.000566
460    0.000531
462         inf
464    0.000980
466    0.003500
468    0.004845
470    0.004196
472    0.000511
474    0.001125
476    0.000500
478    0.001431
480    0.001004
482    0.004769
484    0.000500
486    0.001614
488    0.002233
490    0.000560
492    0.005076
494         inf
496    0.004973
498    0.001309
500    0.002210
502    0.001051
Name: spb, dtype: float64

In [71]:
plt.figure()
plt.xlabel("size (bytes)")
plt.ylabel("transmission rate (bytes/sec)")
marker_dict={'IPv4':'s', 'IPv6':'^'}
color_dict={'IPv4':'green', 'IPv6':'red'}
marker=[ marker_dict[i] for i in df['proto'] ]
# print(marker)
# Using a list of colors comes from 
# https://stackoverflow.com/questions/27318906/python-scatter-plot-with-colors-corresponding-to-strings
color=[ color_dict[i] for i in df['proto'] ]
# But then I had a better idea: simply create 2 DFs, one for IPv4 and one for IPv6
# plt.scatter(df["size"],df["rate"], c=color )
plt.scatter(df4['size'], df4.rate, c='r', marker='s', label="IPv4")
plt.scatter(df6['size'], df6.rate, c='g', marker='+', label="IPv6")
plt.legend()
plt.savefig(FILENAME+"_size_rate.svg")
plt.show()
# df.plot(x="size (bytes)",y="data_rate (bytes/sec)", kind="scatter", xlabel="SIZE")



In [72]:
ax = df4.plot(kind="scatter", x="loss",y="rate", color="r", marker="s", label="IPv4 rate vs. loss")
df6.plot(kind="scatter", x="loss",y="rate", color="g", marker="+", label="IPv6 rate vs. loss", ax=ax)
plt.legend()
plt.savefig(FILENAME+"_loss_rate.svg")
plt.show()



In [73]:
plt.figure();
plt.ylabel("transmission rate (bytes/sec)")
plt.xlabel("Delay (msec)")
plt.scatter(x=df4["delay"], y=df4["rate"], marker="s", c="r", label="IPv4")
plt.scatter(x=df6["delay"], y=df6["rate"], marker="+", c="g", label="IPv6")
plt.legend()
plt.savefig(FILENAME+"_delay_rate.svg")
plt.show()



In [74]:
# This is from POC_3d_scatter_plot.py
# From https://pythonprogramming.net/matplotlib-3d-scatterplot-tutorial/
# This does NOT work in a jupyter notebook - it doesn't spin or rotate

fig = plt.figure()
plt.ylabel("transmission rate (bytes/sec)")
plt.xlabel("packet loss %")
ax: matplotlib.figure.Figure = fig.add_subplot(111, projection='3d')
ax.set_xlabel('loss %')
ax.set_ylabel('Delay (msec)')
ax.set_zlabel('rate (bytes/sec')

# ax3d = Axes3D(fig=fig)
x4: pd.Series = df4.loss
x4min: float = df4.loss.min()
x4max: float = df4.loss.max()
y4: pd.Series = df4.delay
y4max: float = df4.delay.max()
y4min: float = df4.delay.min()
# https://matplotlib.org/api/_as_gen/matplotlib.axes.Axes.set_xlim.html#matplotlib.axes.Axes.set_xlim
# ax3d.set_xlim3d(left=xmin, right=xmax)  # Loss rate from 0% to 100%
# ax3d.set_ylim3d(bottom=ymin, top=ymax)

z4: pd.Series = df4.rate

x6: pd.Series = df6.loss
x6min: float = df6.loss.min()
x6max: float = df6.loss.max()
y6: pd.Series = df6.delay
y6max: float = df6.delay.max()
y6min: float = df6.delay.min()

z6: pd.Series = df6.rate

ax.scatter(x4, y4, z4, c='r', marker='o', label="IPv4")  # noqa

ax.scatter(x6, y6, z6, c='g', marker='+', label="IPv6")  # noqa

plt.legend()

plt.savefig(FILENAME+"_loss_delay_rate_3d.svg")
plt.show()


/usr/local/lib/python3.6/dist-packages/matplotlib/figure.py:98: MatplotlibDeprecationWarning: 
Adding an axes using the same arguments as a previous axes currently reuses the earlier instance.  In a future version, a new instance will always be created and returned.  Meanwhile, this warning can be suppressed, and the future behavior ensured, by passing a unique label to each axes instance.
  "Adding an axes using the same arguments as a previous axes "

In [75]:
# Is there a correlation bewteen global TCP retries and performance?
plt.figure();
plt.ylabel("transmission rate (bytes/sec)")
plt.xlabel("Global TCP retransmits")
plt.scatter(x=df4["GTRs"], y=df4["rate"], marker="s", c="r");
plt.scatter(x=df6["GTRs"], y=df6["rate"], marker="+", c="g");
plt.savefig(FILENAME+"_GTRs_rate.svg")
plt.show()



In [118]:
x_val_4 = df4.GTRs[(df4.spb < 1.0E+38) & (df4.spb > 0)]
y_val_4 = df4.spb[(df4.spb < 1.0E+38) & (df4.spb > 0)]
x_val_6 = df6.GTRs[(df6.spb < 1.0E+38) & (df6.spb > 0)]
y_val_6 = df6.spb[(df6.spb < 1.0E+38) & (df6.spb > 0)]
print((max(x_val_4), min(x_val_4)),(max(y_val_4), min(y_val_4)))
print((max(x_val_6), min(x_val_6)),(max(y_val_6), min(y_val_6)))


(430, 0) (0.022306491188935983, 8.23045267489712e-06)
(393, 0) (0.03177629488401652, 8.802816901408451e-06)

In [119]:
#### THIS IS WHERE I AM RUNNING INTO A PROBLEM

plt.figure();
plt.ylabel("Log(transmission rate (bytes/sec))")
plt.xlabel("Log(Global TCP retransmits)")
plt.grid(True, which="both")
plt.yscale('log')
plt.xscale('log')
plt.tick_params(axis='y', which='minor')
plt.tick_params(axis='x', which='minor')

plt.ylim=(1.0E-07,1.0E-2)
plt.xlim=(1.0,1000.0)
plt.scatter(x=x_val_4, y=y_val_4, marker="s", c="r");
plt.scatter(x=x_val_6, y=y_val_6, marker="+", c="g");
plt.savefig(FILENAME+"_GTRs_rate_LogLog.svg")
plt.show()



In [120]:
#### THIS WORKS AS EXPECTED, 

plt.figure();
plt.ylabel("Log(transmission rate (bytes/sec))")
plt.xlabel("Log(Global TCP retransmits)")
plt.grid(True, which="both")
plt.yscale('log')
plt.xscale('log')
plt.tick_params(axis='y', which='minor')
plt.tick_params(axis='x', which='minor')

plt.ylim=(1.0E-07,1.0E-2)
plt.xlim=(1.0,1000.0)
plt.scatter(x=x_val_4, y=y_val_4, marker="s", c="r");
# NOTE: the second call to scatter is commented out
# plt.scatter(x=x_val_6, y=y_val_6, marker="+", c="g");
plt.savefig(FILENAME+"_GTRs_rate_LogLog.svg")
plt.show()



In [122]:
#### THIS ALSO WORKS AS EXPECTED, 

plt.figure();
plt.ylabel("Log(transmission rate (bytes/sec))")
plt.xlabel("Log(Global TCP retransmits)")
plt.grid(True, which="both")
plt.yscale('log')
plt.xscale('log')
plt.tick_params(axis='y', which='minor')
plt.tick_params(axis='x', which='minor')

plt.ylim=(1.0E-07,1.0E-2)
plt.xlim=(1.0,1000.0)
#plt.scatter(x=x_val_4, y=y_val_4, marker="s", c="r");
# NOTE: the first call to scatter is commented out
plt.scatter(x=x_val_6, y=y_val_6, marker="+", c="g");
plt.savefig(FILENAME+"_GTRs_rate_LogLog.svg")
plt.show()



In [81]:
# From https://stackoverflow.com/questions/50418627/python-pandas-linear-regression-curve
def slope_intercept(x_val, y_val):
    print(f"x_val={x_val}...\n y_val={y_val}")
    x = np.array(x_val)
    y = np.array(y_val)
    m = ( ( (np.mean(x)*np.mean(y) ) - np.mean(x*y)) /
        ( ( np.mean(x)*np.mean(x)) - np.mean(x*x)))

    m = round(m,2)
    b=(np.mean(y)-np.mean(x)*m)
    b=round(b,2)
    return m,b
# df4.spb has some places where the value is inf (infinity).  Filter those out
# 1.0E+38 is a proxy for infinity
x_val=df4.GTRs[df4.spb < 1.0E+38].tolist()
y_val=df4.spb[df4.spb < 1.0E+38].tolist()
m,b=slope_intercept(x_val, y_val)
print(f"m={m}, b={b}")
df4['reg_line'] = [(m*x)+b for x in df4.GTRs.tolist()]
print(df4.reg_line)
plt.figure()
# plt.scatter(x=df4["GTRs"], y=df4['reg_line'], color="r", marker="s", label="IPv4 linear regression")
plt.scatter(x=df4.GTRs, y=df4.reg_line, color="r", marker="s", label="IPv4 linear regression")
plt.show()


x_val=[0, 3, 4, 5, 3, 4, 6, 0, 1, 0, 0, 0, 1, 5, 0, 0, 0, 27, 8, 10, 5, 0, 1, 0, 2, 9, 0, 3, 0, 0, 0, 2, 22, 2, 4, 49, 7, 7, 2, 5, 0, 16, 0, 9, 22, 6, 18, 7, 16, 15, 8, 20, 15, 35, 10, 36, 21, 11, 8, 0, 2, 1, 0, 2, 4, 4, 0, 5, 6, 2, 0, 3, 6, 0, 1, 0, 0, 1, 3, 5, 3, 36, 8, 2, 6, 2, 8, 15, 11, 5, 8, 28, 3, 18, 0, 20, 0, 31, 19, 3, 31, 27, 6, 30, 10, 0, 5, 38, 10, 5, 5, 14, 3, 3, 8, 37, 62, 5, 0, 9, 9, 12, 11, 8, 8, 13, 8, 11, 9, 8, 13, 9, 9, 11, 10, 8, 37, 21, 15, 9, 8, 13, 17, 9, 31, 14, 34, 7, 36, 39, 22, 6, 12, 24, 66, 85, 38, 39, 30, 15, 213, 31, 97, 129, 32, 160, 90, 37, 99, 61, 41, 187, 22, 68, 115, 120, 117, 10, 47, 92, 80, 198, 11, 18, 12, 13, 12, 17, 7, 8, 13, 8, 12, 16, 7, 17, 9, 21, 8, 13, 18, 40, 11, 43, 18, 22, 9, 37, 24, 57, 40, 30, 32, 31, 13, 22, 62, 21, 35, 28, 151, 228, 41, 45, 76, 253, 310, 242, 61, 72, 42, 113, 93, 430, 56, 91, 114, 66, 253, 208, 66, 41, 60]...
 y_val=[8.183306055646482e-05, 0.0011310937676733402, 0.0011305822498586771, 0.0011931750387781887, 0.0002843332385555871, 0.0004904364884747426, 0.001084010840108401, 8.741258741258741e-05, 0.00010788650339842486, 0.0001239771881973717, 0.00018556318426424197, 0.0002834467120181406, 0.0004828585224529213, 0.0010869565217391304, 8.503401360544217e-05, 0.00010559662090813094, 0.00012569130216189038, 0.014200511218403862, 0.005293806246691371, 0.005488474204171241, 0.0010822510822510823, 8.510638297872341e-05, 0.00010409076714895389, 0.000125, 0.00018315018315018315, 0.003363605785401951, 0.00048590864917395527, 0.0010860121633362294, 8.635578583765112e-05, 0.00010380982040901069, 0.000124595066035385, 0.00018412815319462345, 0.015302218821729153, 0.0004847309743092584, 0.0010841283607979184, 0.020132876988121603, 0.005107252298263534, 0.0011653653420347278, 0.00019171779141104295, 0.005288207297726071, 0.00048496605237633366, 0.007137758743754462, 0.00011859582542694497, 0.01914241960183767, 0.020234722784297856, 0.006345177664974619, 0.01950078003120125, 0.01409443269908386, 0.02015316404675534, 0.019138755980861243, 0.022306491188935983, 0.01238696890870804, 0.005488474204171241, 0.00819000819000819, 0.00508646998982706, 0.01558117793705204, 9.775171065493646e-05, 0.0158052789631737, 0.002145922746781116, 8.23045267489712e-06, 1.0845986984815618e-05, 1.2933264355923434e-05, 1.8542555164101613e-05, 2.909514111143439e-05, 4.9043648847474255e-05, 0.00010831889081455805, 8.547008547008548e-06, 0.00011396011396011396, 0.00011859582542694497, 1.8365472910927457e-05, 2.8669724770642203e-05, 4.859086491739553e-05, 0.00010871928680147858, 8.771929824561403e-06, 1.0809642200843152e-05, 1.2547051442910916e-05, 1.8535681186283596e-05, 2.881014116969173e-05, 4.96031746031746e-05, 0.00010838933448948623, 0.00010998680158380995, 0.0020462451401677922, 0.0003243593902043464, 1.8355359765051395e-05, 0.00013303179459890914, 4.863813229571985e-05, 0.00010842459069717012, 0.0005089058524173028, 0.00031575623618566466, 0.00011446886446886447, 0.00011963153487259242, 0.0019305019305019305, 0.0001545595054095827, 0.0015092061575611227, 9.233610341643583e-06, 0.0020197939810139365, 1.3693002875530605e-05, 0.00032, 0.001734906315058987, 4.8355899419729206e-05, 0.0015098897780462027, 0.004796163069544364, 0.0005107252298263534, 0.0022227161591464773, 0.0014200511218403862, 2.849002849002849e-05, 4.8520135856380395e-05, 0.0037893141341417205, 0.0031746031746031746, 0.0003194888178913738, 0.0015172204521316946, 0.0020238818053025702, 0.0005288207297726071, 0.00015403573629081948, 0.0009149130832570906, 0.0007199424046076314, 0.006402048655569783, 0.0026329647182727752, 0.0005293806246691371, 0.0003379520108144643, 0.002111486486486486, 0.0007309941520467836, 0.0007733952049497294, 0.0008136696501220504, 0.0010186411327289396, 0.0006920415224913495, 0.001102049812651532, 0.001142334932602239, 0.0007272727272727272, 0.0007733952049497294, 0.0007733952049497294, 0.0010188487009679063, 0.0006915629322268327, 0.0011016855789357718, 0.0011440338634023566, 0.0007215007215007215, 0.0015105740181268882, 0.0008143322475570033, 0.0009784735812133072, 0.0006925207756232687, 0.0011010790574763267, 0.001144950767117014, 0.0007220216606498195, 0.0007739938080495357, 0.0007739938080495357, 0.0010190563538163661, 0.0009784735812133072, 0.000999000999000999, 0.002289901534234028, 0.0009737098344693282, 0.0010191602119853241, 0.0009784735812133072, 0.0009775171065493646, 0.0006915629322268327, 0.003395585738539898, 0.001993223041658362, 0.0007530120481927711, 0.0015105740181268882, 0.001183431952662722, 0.0011630611770179111, 0.006489292667099286, 0.0009861932938856016, 0.0036010082823190494, 0.001961553550411926, 0.0010190563538163661, 0.0032278889606197547, 0.0019665683382497543, 0.000855431993156544, 0.0020751193193608635, 0.0007251631617113851, 0.000784313725490196, 0.003394433129667345, 0.001024905196269345, 0.0016129032258064516, 0.0021048200378867604, 0.0027442371020856204, 0.0009970089730807576, 0.00015787811809283233, 0.000966183574879227, 0.0019912385503783356, 0.0010258514567090685, 0.0045871559633027525, 0.0005512679162072767, 0.0005506607929515419, 0.000591715976331361, 0.0006329113924050633, 0.00046904315196998124, 0.000612369871402327, 0.0005711022272986865, 0.00038387715930902113, 0.00040749796251018743, 0.00046882325363338024, 0.0003663003663003663, 0.00046904315196998124, 0.0006127450980392157, 0.0006333122229259025, 0.00034352456200618345, 0.00034626038781163435, 0.0003874467260751647, 0.000449034575662326, 0.0005099439061703213, 0.0007352941176470588, 0.00033400133600534405, 0.001258019876714052, 0.00036656891495601173, 0.00038684719535783365, 0.00044863167339614175, 0.00046860356138706655, 0.0006119951040391676, 0.0018158707100054475, 0.0005045408678102926, 0.0005078720162519045, 0.000407000407000407, 0.0005096839959225281, 0.0006939625260235947, 0.0005455537370430987, 0.0011244799280332846, 0.0005277044854881266, 0.000550357732526142, 0.00042735042735042735, 0.0028240609997175936, 0.0044014084507042256, 0.0005659309564233164, 0.0005313496280552603, 0.000980392156862745, 0.0035001750087504378, 0.0048449612403100775, 0.00419639110365086, 0.0005112474437627812, 0.0011254924029262803, 0.0004995004995004995, 0.001431229426077, 0.0010036130068245685, 0.004768717215069147, 0.0005002501250625312, 0.0016136840406648378, 0.0022331397945511387, 0.0005602240896358543, 0.005076142131979695, 0.004972650422675286, 0.0013087292239235702, 0.0022104332449160036, 0.0010507512871703267]
m=0.0, b=0.0
0      0.0
2      0.0
4      0.0
6      0.0
8      0.0
10     0.0
12     0.0
14     0.0
16     0.0
18     0.0
20     0.0
22     0.0
24     0.0
26     0.0
28     0.0
30     0.0
32     0.0
34     0.0
36     0.0
38     0.0
40     0.0
42     0.0
44     0.0
46     0.0
48     0.0
50     0.0
52     0.0
54     0.0
56     0.0
58     0.0
60     0.0
62     0.0
64     0.0
66     0.0
68     0.0
70     0.0
72     0.0
74     0.0
76     0.0
78     0.0
80     0.0
82     0.0
84     0.0
86     0.0
88     0.0
90     0.0
92     0.0
94     0.0
96     0.0
98     0.0
100    0.0
102    0.0
104    0.0
106    0.0
108    0.0
110    0.0
112    0.0
114    0.0
116    0.0
118    0.0
120    0.0
122    0.0
124    0.0
126    0.0
128    0.0
130    0.0
132    0.0
134    0.0
136    0.0
138    0.0
140    0.0
142    0.0
144    0.0
146    0.0
148    0.0
150    0.0
152    0.0
154    0.0
156    0.0
158    0.0
160    0.0
162    0.0
164    0.0
166    0.0
168    0.0
170    0.0
172    0.0
174    0.0
176    0.0
178    0.0
180    0.0
182    0.0
184    0.0
186    0.0
188    0.0
190    0.0
192    0.0
194    0.0
196    0.0
198    0.0
200    0.0
202    0.0
204    0.0
206    0.0
208    0.0
210    0.0
212    0.0
214    0.0
216    0.0
218    0.0
220    0.0
222    0.0
224    0.0
226    0.0
228    0.0
230    0.0
232    0.0
234    0.0
236    0.0
238    0.0
240    0.0
242    0.0
244    0.0
246    0.0
248    0.0
250    0.0
252    0.0
254    0.0
256    0.0
258    0.0
260    0.0
262    0.0
264    0.0
266    0.0
268    0.0
270    0.0
272    0.0
274    0.0
276    0.0
278    0.0
280    0.0
282    0.0
284    0.0
286    0.0
288    0.0
290    0.0
292    0.0
294    0.0
296    0.0
298    0.0
300    0.0
302    0.0
304    0.0
306    0.0
308    0.0
310    0.0
312    0.0
314    0.0
316    0.0
318    0.0
320    0.0
322    0.0
324    0.0
326    0.0
328    0.0
330    0.0
332    0.0
334    0.0
336    0.0
338    0.0
340    0.0
342    0.0
344    0.0
346    0.0
348    0.0
350    0.0
352    0.0
354    0.0
356    0.0
358    0.0
360    0.0
362    0.0
364    0.0
366    0.0
368    0.0
370    0.0
372    0.0
374    0.0
376    0.0
378    0.0
380    0.0
382    0.0
384    0.0
386    0.0
388    0.0
390    0.0
392    0.0
394    0.0
396    0.0
398    0.0
400    0.0
402    0.0
404    0.0
406    0.0
408    0.0
410    0.0
412    0.0
414    0.0
416    0.0
418    0.0
420    0.0
422    0.0
424    0.0
426    0.0
428    0.0
430    0.0
432    0.0
434    0.0
436    0.0
438    0.0
440    0.0
442    0.0
444    0.0
446    0.0
448    0.0
450    0.0
452    0.0
454    0.0
456    0.0
458    0.0
460    0.0
462    0.0
464    0.0
466    0.0
468    0.0
470    0.0
472    0.0
474    0.0
476    0.0
478    0.0
480    0.0
482    0.0
484    0.0
486    0.0
488    0.0
490    0.0
492    0.0
494    0.0
496    0.0
498    0.0
500    0.0
502    0.0
Name: reg_line, dtype: float64

In [77]:
# That looks like a reciprocal relationship
plt.figure();
x_new_4 = np.arange(len(df4))
slope, intercept, r_value, p_value, std_err = stats.linregress(df4["GTRs"],df4.spb)
line_4 = intercept + slope*x_new_4
plt.plot(line_4, "r-")

plt.ylabel("transmission rate (seconds/byte)")
plt.xlabel("Global TCP retransmits")
plt.scatter(x=df4["GTRs"], y=df4['spb'], marker="s", c="r")
plt.scatter(x=df6["GTRs"], y=df6['spb'], marker="+", c="g")



plt.savefig(FILENAME+"_GTRs_SpB.svg")
plt.show()


/usr/local/lib/python3.6/dist-packages/numpy/lib/function_base.py:3103: RuntimeWarning: invalid value encountered in subtract
  X -= avg[:, None]

In [ ]:


In [ ]:
df.columns

In [ ]:
def df_to_a(df_lcl):
    row_dict=dict()     # Holds row in array that has loss (a float) as a key
    col_dict=dict()     # holds col in array that has delay (a float) as a key
    row_ctr=0
    col_ctr=0
    for i in range(len(df_lcl.index)):
        row=df_lcl.iloc[i]
        rate=row['data_rate (bytes/sec)']
        delay=row['Delay (ms)']
        loss=row['loss_percent']
        print(f"{i:3d}, {delay:8.2f}, {loss:8.2f}%. {rate:9.2f}" )

df_to_a(df4)

In [ ]:
# Use a pivot table?
# From https://pandas.pydata.org/pandas-docs/stable/generated/pandas.pivot_table.html
pivot_table=pd.pivot_table(df4, values="data_rate (bytes/sec)", index=['Delay (ms)', 'loss_percent' ],
                          aggfunc=np.min)
pivot_table

In [ ]:
# Use a pivot table?  The last try had very little variation
# From https://pandas.pydata.org/pandas-docs/stable/generated/pandas.pivot_table.html
pivot_table=pd.pivot_table(df4, values="data_rate (bytes/sec)", index=['Delay (ms)', 'loss_percent' ])
pivot_table

In [ ]:
df4.sort_values(by="data_rate (bytes/sec)")