{ "cells": [ { "cell_type": "markdown", "metadata": { "hideCode": true, "hidePrompt": true }, "source": [ "# Estimation de la latence et de la capacité d’une connexion à partir de mesures asymétriques" ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "hideCode": true, "hidePrompt": true }, "outputs": [], "source": [ "%matplotlib inline\n", "import matplotlib.pyplot as plt\n", "import pandas as pd\n", "import isoweek\n", "import gzip\n", "import re as re\n", "from sklearn.linear_model import LinearRegression\n" ] }, { "cell_type": "markdown", "metadata": { "hideCode": true, "hidePrompt": true }, "source": [ "## Importation des données" ] }, { "cell_type": "markdown", "metadata": { "hideCode": true, "hidePrompt": true }, "source": [ "Deux jeux de données proviennent de connexions internet, permettent d'estimer la latence et la capacité associées. Une copie locale des données est effectuée." ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "hideCode": true, "hidePrompt": true }, "outputs": [], "source": [ "data_url_1=\"http://mescal.imag.fr/membres/arnaud.legrand/teaching/2014/RICM4_EP_ping/liglab2.log.gz\"\n", "data_url_2=\"http://mescal.imag.fr/membres/arnaud.legrand/teaching/2014/RICM4_EP_ping/stackoverflow.log.gz\"\n", "\n", "data_file_1_gz = \"connexion_internet_1.gz\"\n", "data_file_2_gz = \"connexion_internet_2.gz\"\n", "\n", "import os\n", "import urllib.request\n", "if not os.path.exists(data_file_1_gz):\n", " urllib.request.urlretrieve(data_url_1, data_file_1_gz)\n", " \n", "if not os.path.exists(data_file_2_gz):\n", " urllib.request.urlretrieve(data_url_2, data_file_2_gz)\n", " " ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "hideCode": true, "hidePrompt": true }, "outputs": [], "source": [ "with gzip.open(data_file_1_gz) as f:\n", " file_content = f.read()\n", "f = open(\"data_file_1.txt\", \"w\")\n", "f.write(file_content.decode(\"utf-8\") )\n", "f.close()\n" ] }, { "cell_type": "code", "execution_count": 4, "metadata": { "hideCode": true, "hidePrompt": true }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
0123456789
0[1421761682.052172]665bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=22.5ms
1[1421761682.277315]1373bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=21.2ms
2[1421761682.502054]262bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=21.2ms
3[1421761682.729257]1107bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=23.3ms
4[1421761682.934648]1128bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.41ms
5[1421761683.160397]489bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=21.9ms
6[1421761683.443055]1759bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=78.7ms
7[1421761683.672157]1146bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=25.1ms
8[1421761683.899933]884bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=24.0ms
9[1421761684.122687]1422bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=19.5ms
10[1421761684.344135]1180bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=18.0ms
11[1421761684.566271]999bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=18.8ms
12[1421761684.770828]21bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
13[1421761684.998504]1020bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=24.3ms
14[1421761685.205172]71bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=3.45ms
15[1421761685.414106]34bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=5.85ms
16[1421761685.620117]1843bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=2.31ms
17[1421761685.824949]407bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.14ms
18[1421761686.029177]356bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.10ms
19[1421761686.234464]1511bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=2.18ms
20[1421761686.438772]587bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.27ms
21[1421761686.643208]809bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.33ms
22[1421761686.848323]1364bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.51ms
23[1421761687.053400]1153bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.44ms
24[1421761687.257704]853bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.30ms
25[1421761687.463275]1510bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=2.17ms
26[1421761687.668423]123bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.21ms
27[1421761687.874230]1966bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=2.20ms
28[1421761688.078667]933bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.34ms
29[1421761688.283655]922bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.42ms
.................................
44383[1421771180.743715]1772bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=28.8ms
44384[1421771180.949053]41bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.14ms
44385[1421771181.155685]1944bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=2.32ms
44386[1421771181.362095]400bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.98ms
44387[1421771181.569409]226bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=3.01ms
44388[1421771181.780805]466bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=7.45ms
44389[1421771181.998869]350bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=13.5ms
44390[1421771182.248969]1829bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=45.9ms
44391[1421771182.512386]1954bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=58.5ms
44392[1421771182.717961]1074bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.45ms
44393[1421771182.923292]46bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.11ms
44394[1421771183.129965]1844bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=2.26ms
44395[1421771183.335449]645bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.24ms
44396[1421771183.540901]444bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.25ms
44397[1421771183.747983]1940bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=2.46ms
44398[1421771183.954099]1411bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.47ms
44399[1421771184.159879]49bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.21ms
44400[1421771184.365815]420bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.55ms
44401[1421771184.571516]227bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.22ms
44402[1421771184.777325]947bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.34ms
44403[1421771184.983905]1960bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=2.43ms
44404[1421771185.188976]531bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.19ms
44405[1421771185.394275]374bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.14ms
44406[1421771185.600745]1503bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=2.19ms
44407[1421771185.805877]572bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.29ms
44408[1421771186.011910]1338bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.47ms
44409[1421771186.222729]1515bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=7.02ms
44410[1421771186.429007]1875bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=2.33ms
44411[1421771186.634747]1006bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.61ms
44412[1421771186.840222]1273bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.35ms
\n", "

44413 rows × 10 columns

\n", "
" ], "text/plain": [ " 0 1 2 3 4 \\\n", "0 [1421761682.052172] 665 bytes from lig-publig.imag.fr \n", "1 [1421761682.277315] 1373 bytes from lig-publig.imag.fr \n", "2 [1421761682.502054] 262 bytes from lig-publig.imag.fr \n", "3 [1421761682.729257] 1107 bytes from lig-publig.imag.fr \n", "4 [1421761682.934648] 1128 bytes from lig-publig.imag.fr \n", "5 [1421761683.160397] 489 bytes from lig-publig.imag.fr \n", "6 [1421761683.443055] 1759 bytes from lig-publig.imag.fr \n", "7 [1421761683.672157] 1146 bytes from lig-publig.imag.fr \n", "8 [1421761683.899933] 884 bytes from lig-publig.imag.fr \n", "9 [1421761684.122687] 1422 bytes from lig-publig.imag.fr \n", "10 [1421761684.344135] 1180 bytes from lig-publig.imag.fr \n", "11 [1421761684.566271] 999 bytes from lig-publig.imag.fr \n", "12 [1421761684.770828] 21 bytes from lig-publig.imag.fr \n", "13 [1421761684.998504] 1020 bytes from lig-publig.imag.fr \n", "14 [1421761685.205172] 71 bytes from lig-publig.imag.fr \n", "15 [1421761685.414106] 34 bytes from lig-publig.imag.fr \n", "16 [1421761685.620117] 1843 bytes from lig-publig.imag.fr \n", "17 [1421761685.824949] 407 bytes from lig-publig.imag.fr \n", "18 [1421761686.029177] 356 bytes from lig-publig.imag.fr \n", "19 [1421761686.234464] 1511 bytes from lig-publig.imag.fr \n", "20 [1421761686.438772] 587 bytes from lig-publig.imag.fr \n", "21 [1421761686.643208] 809 bytes from lig-publig.imag.fr \n", "22 [1421761686.848323] 1364 bytes from lig-publig.imag.fr \n", "23 [1421761687.053400] 1153 bytes from lig-publig.imag.fr \n", "24 [1421761687.257704] 853 bytes from lig-publig.imag.fr \n", "25 [1421761687.463275] 1510 bytes from lig-publig.imag.fr \n", "26 [1421761687.668423] 123 bytes from lig-publig.imag.fr \n", "27 [1421761687.874230] 1966 bytes from lig-publig.imag.fr \n", "28 [1421761688.078667] 933 bytes from lig-publig.imag.fr \n", "29 [1421761688.283655] 922 bytes from lig-publig.imag.fr \n", "... ... ... ... ... ... \n", "44383 [1421771180.743715] 1772 bytes from lig-publig.imag.fr \n", "44384 [1421771180.949053] 41 bytes from lig-publig.imag.fr \n", "44385 [1421771181.155685] 1944 bytes from lig-publig.imag.fr \n", "44386 [1421771181.362095] 400 bytes from lig-publig.imag.fr \n", "44387 [1421771181.569409] 226 bytes from lig-publig.imag.fr \n", "44388 [1421771181.780805] 466 bytes from lig-publig.imag.fr \n", "44389 [1421771181.998869] 350 bytes from lig-publig.imag.fr \n", "44390 [1421771182.248969] 1829 bytes from lig-publig.imag.fr \n", "44391 [1421771182.512386] 1954 bytes from lig-publig.imag.fr \n", "44392 [1421771182.717961] 1074 bytes from lig-publig.imag.fr \n", "44393 [1421771182.923292] 46 bytes from lig-publig.imag.fr \n", "44394 [1421771183.129965] 1844 bytes from lig-publig.imag.fr \n", "44395 [1421771183.335449] 645 bytes from lig-publig.imag.fr \n", "44396 [1421771183.540901] 444 bytes from lig-publig.imag.fr \n", "44397 [1421771183.747983] 1940 bytes from lig-publig.imag.fr \n", "44398 [1421771183.954099] 1411 bytes from lig-publig.imag.fr \n", "44399 [1421771184.159879] 49 bytes from lig-publig.imag.fr \n", "44400 [1421771184.365815] 420 bytes from lig-publig.imag.fr \n", "44401 [1421771184.571516] 227 bytes from lig-publig.imag.fr \n", "44402 [1421771184.777325] 947 bytes from lig-publig.imag.fr \n", "44403 [1421771184.983905] 1960 bytes from lig-publig.imag.fr \n", "44404 [1421771185.188976] 531 bytes from lig-publig.imag.fr \n", "44405 [1421771185.394275] 374 bytes from lig-publig.imag.fr \n", "44406 [1421771185.600745] 1503 bytes from lig-publig.imag.fr \n", "44407 [1421771185.805877] 572 bytes from lig-publig.imag.fr \n", "44408 [1421771186.011910] 1338 bytes from lig-publig.imag.fr \n", "44409 [1421771186.222729] 1515 bytes from lig-publig.imag.fr \n", "44410 [1421771186.429007] 1875 bytes from lig-publig.imag.fr \n", "44411 [1421771186.634747] 1006 bytes from lig-publig.imag.fr \n", "44412 [1421771186.840222] 1273 bytes from lig-publig.imag.fr \n", "\n", " 5 6 7 8 9 \n", "0 (129.88.11.7): icmp_seq=1 ttl=60 time=22.5 ms \n", "1 (129.88.11.7): icmp_seq=1 ttl=60 time=21.2 ms \n", "2 (129.88.11.7): icmp_seq=1 ttl=60 time=21.2 ms \n", "3 (129.88.11.7): icmp_seq=1 ttl=60 time=23.3 ms \n", "4 (129.88.11.7): icmp_seq=1 ttl=60 time=1.41 ms \n", "5 (129.88.11.7): icmp_seq=1 ttl=60 time=21.9 ms \n", "6 (129.88.11.7): icmp_seq=1 ttl=60 time=78.7 ms \n", "7 (129.88.11.7): icmp_seq=1 ttl=60 time=25.1 ms \n", "8 (129.88.11.7): icmp_seq=1 ttl=60 time=24.0 ms \n", "9 (129.88.11.7): icmp_seq=1 ttl=60 time=19.5 ms \n", "10 (129.88.11.7): icmp_seq=1 ttl=60 time=18.0 ms \n", "11 (129.88.11.7): icmp_seq=1 ttl=60 time=18.8 ms \n", "12 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "13 (129.88.11.7): icmp_seq=1 ttl=60 time=24.3 ms \n", "14 (129.88.11.7): icmp_seq=1 ttl=60 time=3.45 ms \n", "15 (129.88.11.7): icmp_seq=1 ttl=60 time=5.85 ms \n", "16 (129.88.11.7): icmp_seq=1 ttl=60 time=2.31 ms \n", "17 (129.88.11.7): icmp_seq=1 ttl=60 time=1.14 ms \n", "18 (129.88.11.7): icmp_seq=1 ttl=60 time=1.10 ms \n", "19 (129.88.11.7): icmp_seq=1 ttl=60 time=2.18 ms \n", "20 (129.88.11.7): icmp_seq=1 ttl=60 time=1.27 ms \n", "21 (129.88.11.7): icmp_seq=1 ttl=60 time=1.33 ms \n", "22 (129.88.11.7): icmp_seq=1 ttl=60 time=1.51 ms \n", "23 (129.88.11.7): icmp_seq=1 ttl=60 time=1.44 ms \n", "24 (129.88.11.7): icmp_seq=1 ttl=60 time=1.30 ms \n", "25 (129.88.11.7): icmp_seq=1 ttl=60 time=2.17 ms \n", "26 (129.88.11.7): icmp_seq=1 ttl=60 time=1.21 ms \n", "27 (129.88.11.7): icmp_seq=1 ttl=60 time=2.20 ms \n", "28 (129.88.11.7): icmp_seq=1 ttl=60 time=1.34 ms \n", "29 (129.88.11.7): icmp_seq=1 ttl=60 time=1.42 ms \n", "... ... ... ... ... ... \n", "44383 (129.88.11.7): icmp_seq=1 ttl=60 time=28.8 ms \n", "44384 (129.88.11.7): icmp_seq=1 ttl=60 time=1.14 ms \n", "44385 (129.88.11.7): icmp_seq=1 ttl=60 time=2.32 ms \n", "44386 (129.88.11.7): icmp_seq=1 ttl=60 time=1.98 ms \n", "44387 (129.88.11.7): icmp_seq=1 ttl=60 time=3.01 ms \n", "44388 (129.88.11.7): icmp_seq=1 ttl=60 time=7.45 ms \n", "44389 (129.88.11.7): icmp_seq=1 ttl=60 time=13.5 ms \n", "44390 (129.88.11.7): icmp_seq=1 ttl=60 time=45.9 ms \n", "44391 (129.88.11.7): icmp_seq=1 ttl=60 time=58.5 ms \n", "44392 (129.88.11.7): icmp_seq=1 ttl=60 time=1.45 ms \n", "44393 (129.88.11.7): icmp_seq=1 ttl=60 time=1.11 ms \n", "44394 (129.88.11.7): icmp_seq=1 ttl=60 time=2.26 ms \n", "44395 (129.88.11.7): icmp_seq=1 ttl=60 time=1.24 ms \n", "44396 (129.88.11.7): icmp_seq=1 ttl=60 time=1.25 ms \n", "44397 (129.88.11.7): icmp_seq=1 ttl=60 time=2.46 ms \n", "44398 (129.88.11.7): icmp_seq=1 ttl=60 time=1.47 ms \n", "44399 (129.88.11.7): icmp_seq=1 ttl=60 time=1.21 ms \n", "44400 (129.88.11.7): icmp_seq=1 ttl=60 time=1.55 ms \n", "44401 (129.88.11.7): icmp_seq=1 ttl=60 time=1.22 ms \n", "44402 (129.88.11.7): icmp_seq=1 ttl=60 time=1.34 ms \n", "44403 (129.88.11.7): icmp_seq=1 ttl=60 time=2.43 ms \n", "44404 (129.88.11.7): icmp_seq=1 ttl=60 time=1.19 ms \n", "44405 (129.88.11.7): icmp_seq=1 ttl=60 time=1.14 ms \n", "44406 (129.88.11.7): icmp_seq=1 ttl=60 time=2.19 ms \n", "44407 (129.88.11.7): icmp_seq=1 ttl=60 time=1.29 ms \n", "44408 (129.88.11.7): icmp_seq=1 ttl=60 time=1.47 ms \n", "44409 (129.88.11.7): icmp_seq=1 ttl=60 time=7.02 ms \n", "44410 (129.88.11.7): icmp_seq=1 ttl=60 time=2.33 ms \n", "44411 (129.88.11.7): icmp_seq=1 ttl=60 time=1.61 ms \n", "44412 (129.88.11.7): icmp_seq=1 ttl=60 time=1.35 ms \n", "\n", "[44413 rows x 10 columns]" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "raw_data_1 = pd.read_csv(\"data_file_1.txt\",sep=' ',header=None)\n", "raw_data_1" ] }, { "cell_type": "markdown", "metadata": { "hideCode": true, "hidePrompt": true }, "source": [ "On repère les lignes où les données sont incomplètes" ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "hideCode": true, "hidePrompt": true }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
0123456789
12[1421761684.770828]21bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
116[1421761706.146320]9bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
314[1421761748.647974]9bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
508[1421761788.500516]9bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
590[1421761805.331125]18bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
647[1421761817.308839]18bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
1087[1421761907.694059]18bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
1091[1421761908.512826]13bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
1131[1421761916.713419]20bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
1153[1421761921.229704]21bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
1350[1421761962.174859]15bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
1542[1421762001.590195]17bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
1691[1421762032.199394]19bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
1765[1421762047.397821]9bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
1957[1421762088.369820]21bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
2099[1421762117.516869]8bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
2182[1421762134.551193]23bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
2209[1421762140.101009]10bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
2455[1421762191.278531]21bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
2478[1421762196.022695]16bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
2722[1421762246.169992]19bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
2734[1421762248.634005]21bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
3042[1421762311.874238]10bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
3064[1421762316.560968]9bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
3185[1421762342.293065]22bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
3222[1421762349.889838]10bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
3318[1421762369.740243]10bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
3333[1421762372.892510]10bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
3494[1421762406.232258]8bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
3689[1421762447.771797]9bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
.................................
39760[1421770202.098919]14bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
39929[1421770236.857197]22bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
40039[1421770260.878994]22bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
40398[1421770347.170294]12bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
40659[1421770401.425936]8bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
40704[1421770410.677288]20bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
40882[1421770447.286588]15bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
41276[1421770528.785624]12bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
41421[1421770558.624793]16bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
41494[1421770573.778775]22bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
41689[1421770614.039516]15bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
41833[1421770643.752354]17bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
42094[1421770697.673096]10bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
42119[1421770702.820645]21bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
42165[1421770712.292955]18bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
42171[1421770713.526885]9bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
42216[1421770722.770927]17bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
42290[1421770737.986337]17bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
42391[1421770758.905166]17bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
42440[1421770768.998916]14bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
42648[1421770811.776268]19bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
42772[1421770837.307423]17bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
42964[1421770877.106153]15bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
43267[1421770939.684446]11bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
43570[1421771013.105688]23bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
43730[1421771046.094241]14bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
43985[1421771098.507878]12bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
44024[1421771106.522134]8bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
44170[1421771136.918078]8bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
44359[1421771175.771771]23bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60NaNNaN
\n", "

377 rows × 10 columns

\n", "
" ], "text/plain": [ " 0 1 2 3 4 \\\n", "12 [1421761684.770828] 21 bytes from lig-publig.imag.fr \n", "116 [1421761706.146320] 9 bytes from lig-publig.imag.fr \n", "314 [1421761748.647974] 9 bytes from lig-publig.imag.fr \n", "508 [1421761788.500516] 9 bytes from lig-publig.imag.fr \n", "590 [1421761805.331125] 18 bytes from lig-publig.imag.fr \n", "647 [1421761817.308839] 18 bytes from lig-publig.imag.fr \n", "1087 [1421761907.694059] 18 bytes from lig-publig.imag.fr \n", "1091 [1421761908.512826] 13 bytes from lig-publig.imag.fr \n", "1131 [1421761916.713419] 20 bytes from lig-publig.imag.fr \n", "1153 [1421761921.229704] 21 bytes from lig-publig.imag.fr \n", "1350 [1421761962.174859] 15 bytes from lig-publig.imag.fr \n", "1542 [1421762001.590195] 17 bytes from lig-publig.imag.fr \n", "1691 [1421762032.199394] 19 bytes from lig-publig.imag.fr \n", "1765 [1421762047.397821] 9 bytes from lig-publig.imag.fr \n", "1957 [1421762088.369820] 21 bytes from lig-publig.imag.fr \n", "2099 [1421762117.516869] 8 bytes from lig-publig.imag.fr \n", "2182 [1421762134.551193] 23 bytes from lig-publig.imag.fr \n", "2209 [1421762140.101009] 10 bytes from lig-publig.imag.fr \n", "2455 [1421762191.278531] 21 bytes from lig-publig.imag.fr \n", "2478 [1421762196.022695] 16 bytes from lig-publig.imag.fr \n", "2722 [1421762246.169992] 19 bytes from lig-publig.imag.fr \n", "2734 [1421762248.634005] 21 bytes from lig-publig.imag.fr \n", "3042 [1421762311.874238] 10 bytes from lig-publig.imag.fr \n", "3064 [1421762316.560968] 9 bytes from lig-publig.imag.fr \n", "3185 [1421762342.293065] 22 bytes from lig-publig.imag.fr \n", "3222 [1421762349.889838] 10 bytes from lig-publig.imag.fr \n", "3318 [1421762369.740243] 10 bytes from lig-publig.imag.fr \n", "3333 [1421762372.892510] 10 bytes from lig-publig.imag.fr \n", "3494 [1421762406.232258] 8 bytes from lig-publig.imag.fr \n", "3689 [1421762447.771797] 9 bytes from lig-publig.imag.fr \n", "... ... .. ... ... ... \n", "39760 [1421770202.098919] 14 bytes from lig-publig.imag.fr \n", "39929 [1421770236.857197] 22 bytes from lig-publig.imag.fr \n", "40039 [1421770260.878994] 22 bytes from lig-publig.imag.fr \n", "40398 [1421770347.170294] 12 bytes from lig-publig.imag.fr \n", "40659 [1421770401.425936] 8 bytes from lig-publig.imag.fr \n", "40704 [1421770410.677288] 20 bytes from lig-publig.imag.fr \n", "40882 [1421770447.286588] 15 bytes from lig-publig.imag.fr \n", "41276 [1421770528.785624] 12 bytes from lig-publig.imag.fr \n", "41421 [1421770558.624793] 16 bytes from lig-publig.imag.fr \n", "41494 [1421770573.778775] 22 bytes from lig-publig.imag.fr \n", "41689 [1421770614.039516] 15 bytes from lig-publig.imag.fr \n", "41833 [1421770643.752354] 17 bytes from lig-publig.imag.fr \n", "42094 [1421770697.673096] 10 bytes from lig-publig.imag.fr \n", "42119 [1421770702.820645] 21 bytes from lig-publig.imag.fr \n", "42165 [1421770712.292955] 18 bytes from lig-publig.imag.fr \n", "42171 [1421770713.526885] 9 bytes from lig-publig.imag.fr \n", "42216 [1421770722.770927] 17 bytes from lig-publig.imag.fr \n", "42290 [1421770737.986337] 17 bytes from lig-publig.imag.fr \n", "42391 [1421770758.905166] 17 bytes from lig-publig.imag.fr \n", "42440 [1421770768.998916] 14 bytes from lig-publig.imag.fr \n", "42648 [1421770811.776268] 19 bytes from lig-publig.imag.fr \n", "42772 [1421770837.307423] 17 bytes from lig-publig.imag.fr \n", "42964 [1421770877.106153] 15 bytes from lig-publig.imag.fr \n", "43267 [1421770939.684446] 11 bytes from lig-publig.imag.fr \n", "43570 [1421771013.105688] 23 bytes from lig-publig.imag.fr \n", "43730 [1421771046.094241] 14 bytes from lig-publig.imag.fr \n", "43985 [1421771098.507878] 12 bytes from lig-publig.imag.fr \n", "44024 [1421771106.522134] 8 bytes from lig-publig.imag.fr \n", "44170 [1421771136.918078] 8 bytes from lig-publig.imag.fr \n", "44359 [1421771175.771771] 23 bytes from lig-publig.imag.fr \n", "\n", " 5 6 7 8 9 \n", "12 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "116 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "314 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "508 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "590 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "647 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "1087 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "1091 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "1131 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "1153 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "1350 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "1542 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "1691 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "1765 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "1957 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "2099 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "2182 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "2209 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "2455 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "2478 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "2722 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "2734 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "3042 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "3064 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "3185 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "3222 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "3318 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "3333 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "3494 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "3689 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "... ... ... ... ... ... \n", "39760 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "39929 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "40039 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "40398 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "40659 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "40704 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "40882 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "41276 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "41421 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "41494 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "41689 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "41833 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "42094 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "42119 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "42165 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "42171 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "42216 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "42290 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "42391 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "42440 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "42648 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "42772 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "42964 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "43267 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "43570 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "43730 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "43985 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "44024 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "44170 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "44359 (129.88.11.7): icmp_seq=1 ttl=60 NaN NaN \n", "\n", "[377 rows x 10 columns]" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "raw_data_1[raw_data_1.isnull().any(axis=1)]" ] }, { "cell_type": "markdown", "metadata": { "hideCode": true, "hidePrompt": true }, "source": [ "On retire les lignes associées à des données incomplètes" ] }, { "cell_type": "code", "execution_count": 6, "metadata": { "hideCode": true, "hidePrompt": true }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
0123456789
0[1421761682.052172]665bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=22.5ms
1[1421761682.277315]1373bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=21.2ms
2[1421761682.502054]262bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=21.2ms
3[1421761682.729257]1107bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=23.3ms
4[1421761682.934648]1128bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.41ms
5[1421761683.160397]489bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=21.9ms
6[1421761683.443055]1759bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=78.7ms
7[1421761683.672157]1146bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=25.1ms
8[1421761683.899933]884bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=24.0ms
9[1421761684.122687]1422bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=19.5ms
10[1421761684.344135]1180bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=18.0ms
11[1421761684.566271]999bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=18.8ms
13[1421761684.998504]1020bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=24.3ms
14[1421761685.205172]71bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=3.45ms
15[1421761685.414106]34bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=5.85ms
16[1421761685.620117]1843bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=2.31ms
17[1421761685.824949]407bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.14ms
18[1421761686.029177]356bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.10ms
19[1421761686.234464]1511bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=2.18ms
20[1421761686.438772]587bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.27ms
21[1421761686.643208]809bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.33ms
22[1421761686.848323]1364bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.51ms
23[1421761687.053400]1153bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.44ms
24[1421761687.257704]853bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.30ms
25[1421761687.463275]1510bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=2.17ms
26[1421761687.668423]123bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.21ms
27[1421761687.874230]1966bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=2.20ms
28[1421761688.078667]933bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.34ms
29[1421761688.283655]922bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.42ms
30[1421761688.488688]24bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.12ms
.................................
44383[1421771180.743715]1772bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=28.8ms
44384[1421771180.949053]41bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.14ms
44385[1421771181.155685]1944bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=2.32ms
44386[1421771181.362095]400bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.98ms
44387[1421771181.569409]226bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=3.01ms
44388[1421771181.780805]466bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=7.45ms
44389[1421771181.998869]350bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=13.5ms
44390[1421771182.248969]1829bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=45.9ms
44391[1421771182.512386]1954bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=58.5ms
44392[1421771182.717961]1074bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.45ms
44393[1421771182.923292]46bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.11ms
44394[1421771183.129965]1844bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=2.26ms
44395[1421771183.335449]645bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.24ms
44396[1421771183.540901]444bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.25ms
44397[1421771183.747983]1940bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=2.46ms
44398[1421771183.954099]1411bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.47ms
44399[1421771184.159879]49bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.21ms
44400[1421771184.365815]420bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.55ms
44401[1421771184.571516]227bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.22ms
44402[1421771184.777325]947bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.34ms
44403[1421771184.983905]1960bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=2.43ms
44404[1421771185.188976]531bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.19ms
44405[1421771185.394275]374bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.14ms
44406[1421771185.600745]1503bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=2.19ms
44407[1421771185.805877]572bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.29ms
44408[1421771186.011910]1338bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.47ms
44409[1421771186.222729]1515bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=7.02ms
44410[1421771186.429007]1875bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=2.33ms
44411[1421771186.634747]1006bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.61ms
44412[1421771186.840222]1273bytesfromlig-publig.imag.fr(129.88.11.7):icmp_seq=1ttl=60time=1.35ms
\n", "

44036 rows × 10 columns

\n", "
" ], "text/plain": [ " 0 1 2 3 4 \\\n", "0 [1421761682.052172] 665 bytes from lig-publig.imag.fr \n", "1 [1421761682.277315] 1373 bytes from lig-publig.imag.fr \n", "2 [1421761682.502054] 262 bytes from lig-publig.imag.fr \n", "3 [1421761682.729257] 1107 bytes from lig-publig.imag.fr \n", "4 [1421761682.934648] 1128 bytes from lig-publig.imag.fr \n", "5 [1421761683.160397] 489 bytes from lig-publig.imag.fr \n", "6 [1421761683.443055] 1759 bytes from lig-publig.imag.fr \n", "7 [1421761683.672157] 1146 bytes from lig-publig.imag.fr \n", "8 [1421761683.899933] 884 bytes from lig-publig.imag.fr \n", "9 [1421761684.122687] 1422 bytes from lig-publig.imag.fr \n", "10 [1421761684.344135] 1180 bytes from lig-publig.imag.fr \n", "11 [1421761684.566271] 999 bytes from lig-publig.imag.fr \n", "13 [1421761684.998504] 1020 bytes from lig-publig.imag.fr \n", "14 [1421761685.205172] 71 bytes from lig-publig.imag.fr \n", "15 [1421761685.414106] 34 bytes from lig-publig.imag.fr \n", "16 [1421761685.620117] 1843 bytes from lig-publig.imag.fr \n", "17 [1421761685.824949] 407 bytes from lig-publig.imag.fr \n", "18 [1421761686.029177] 356 bytes from lig-publig.imag.fr \n", "19 [1421761686.234464] 1511 bytes from lig-publig.imag.fr \n", "20 [1421761686.438772] 587 bytes from lig-publig.imag.fr \n", "21 [1421761686.643208] 809 bytes from lig-publig.imag.fr \n", "22 [1421761686.848323] 1364 bytes from lig-publig.imag.fr \n", "23 [1421761687.053400] 1153 bytes from lig-publig.imag.fr \n", "24 [1421761687.257704] 853 bytes from lig-publig.imag.fr \n", "25 [1421761687.463275] 1510 bytes from lig-publig.imag.fr \n", "26 [1421761687.668423] 123 bytes from lig-publig.imag.fr \n", "27 [1421761687.874230] 1966 bytes from lig-publig.imag.fr \n", "28 [1421761688.078667] 933 bytes from lig-publig.imag.fr \n", "29 [1421761688.283655] 922 bytes from lig-publig.imag.fr \n", "30 [1421761688.488688] 24 bytes from lig-publig.imag.fr \n", "... ... ... ... ... ... \n", "44383 [1421771180.743715] 1772 bytes from lig-publig.imag.fr \n", "44384 [1421771180.949053] 41 bytes from lig-publig.imag.fr \n", "44385 [1421771181.155685] 1944 bytes from lig-publig.imag.fr \n", "44386 [1421771181.362095] 400 bytes from lig-publig.imag.fr \n", "44387 [1421771181.569409] 226 bytes from lig-publig.imag.fr \n", "44388 [1421771181.780805] 466 bytes from lig-publig.imag.fr \n", "44389 [1421771181.998869] 350 bytes from lig-publig.imag.fr \n", "44390 [1421771182.248969] 1829 bytes from lig-publig.imag.fr \n", "44391 [1421771182.512386] 1954 bytes from lig-publig.imag.fr \n", "44392 [1421771182.717961] 1074 bytes from lig-publig.imag.fr \n", "44393 [1421771182.923292] 46 bytes from lig-publig.imag.fr \n", "44394 [1421771183.129965] 1844 bytes from lig-publig.imag.fr \n", "44395 [1421771183.335449] 645 bytes from lig-publig.imag.fr \n", "44396 [1421771183.540901] 444 bytes from lig-publig.imag.fr \n", "44397 [1421771183.747983] 1940 bytes from lig-publig.imag.fr \n", "44398 [1421771183.954099] 1411 bytes from lig-publig.imag.fr \n", "44399 [1421771184.159879] 49 bytes from lig-publig.imag.fr \n", "44400 [1421771184.365815] 420 bytes from lig-publig.imag.fr \n", "44401 [1421771184.571516] 227 bytes from lig-publig.imag.fr \n", "44402 [1421771184.777325] 947 bytes from lig-publig.imag.fr \n", "44403 [1421771184.983905] 1960 bytes from lig-publig.imag.fr \n", "44404 [1421771185.188976] 531 bytes from lig-publig.imag.fr \n", "44405 [1421771185.394275] 374 bytes from lig-publig.imag.fr \n", "44406 [1421771185.600745] 1503 bytes from lig-publig.imag.fr \n", "44407 [1421771185.805877] 572 bytes from lig-publig.imag.fr \n", "44408 [1421771186.011910] 1338 bytes from lig-publig.imag.fr \n", "44409 [1421771186.222729] 1515 bytes from lig-publig.imag.fr \n", "44410 [1421771186.429007] 1875 bytes from lig-publig.imag.fr \n", "44411 [1421771186.634747] 1006 bytes from lig-publig.imag.fr \n", "44412 [1421771186.840222] 1273 bytes from lig-publig.imag.fr \n", "\n", " 5 6 7 8 9 \n", "0 (129.88.11.7): icmp_seq=1 ttl=60 time=22.5 ms \n", "1 (129.88.11.7): icmp_seq=1 ttl=60 time=21.2 ms \n", "2 (129.88.11.7): icmp_seq=1 ttl=60 time=21.2 ms \n", "3 (129.88.11.7): icmp_seq=1 ttl=60 time=23.3 ms \n", "4 (129.88.11.7): icmp_seq=1 ttl=60 time=1.41 ms \n", "5 (129.88.11.7): icmp_seq=1 ttl=60 time=21.9 ms \n", "6 (129.88.11.7): icmp_seq=1 ttl=60 time=78.7 ms \n", "7 (129.88.11.7): icmp_seq=1 ttl=60 time=25.1 ms \n", "8 (129.88.11.7): icmp_seq=1 ttl=60 time=24.0 ms \n", "9 (129.88.11.7): icmp_seq=1 ttl=60 time=19.5 ms \n", "10 (129.88.11.7): icmp_seq=1 ttl=60 time=18.0 ms \n", "11 (129.88.11.7): icmp_seq=1 ttl=60 time=18.8 ms \n", "13 (129.88.11.7): icmp_seq=1 ttl=60 time=24.3 ms \n", "14 (129.88.11.7): icmp_seq=1 ttl=60 time=3.45 ms \n", "15 (129.88.11.7): icmp_seq=1 ttl=60 time=5.85 ms \n", "16 (129.88.11.7): icmp_seq=1 ttl=60 time=2.31 ms \n", "17 (129.88.11.7): icmp_seq=1 ttl=60 time=1.14 ms \n", "18 (129.88.11.7): icmp_seq=1 ttl=60 time=1.10 ms \n", "19 (129.88.11.7): icmp_seq=1 ttl=60 time=2.18 ms \n", "20 (129.88.11.7): icmp_seq=1 ttl=60 time=1.27 ms \n", "21 (129.88.11.7): icmp_seq=1 ttl=60 time=1.33 ms \n", "22 (129.88.11.7): icmp_seq=1 ttl=60 time=1.51 ms \n", "23 (129.88.11.7): icmp_seq=1 ttl=60 time=1.44 ms \n", "24 (129.88.11.7): icmp_seq=1 ttl=60 time=1.30 ms \n", "25 (129.88.11.7): icmp_seq=1 ttl=60 time=2.17 ms \n", "26 (129.88.11.7): icmp_seq=1 ttl=60 time=1.21 ms \n", "27 (129.88.11.7): icmp_seq=1 ttl=60 time=2.20 ms \n", "28 (129.88.11.7): icmp_seq=1 ttl=60 time=1.34 ms \n", "29 (129.88.11.7): icmp_seq=1 ttl=60 time=1.42 ms \n", "30 (129.88.11.7): icmp_seq=1 ttl=60 time=1.12 ms \n", "... ... ... ... ... .. \n", "44383 (129.88.11.7): icmp_seq=1 ttl=60 time=28.8 ms \n", "44384 (129.88.11.7): icmp_seq=1 ttl=60 time=1.14 ms \n", "44385 (129.88.11.7): icmp_seq=1 ttl=60 time=2.32 ms \n", "44386 (129.88.11.7): icmp_seq=1 ttl=60 time=1.98 ms \n", "44387 (129.88.11.7): icmp_seq=1 ttl=60 time=3.01 ms \n", "44388 (129.88.11.7): icmp_seq=1 ttl=60 time=7.45 ms \n", "44389 (129.88.11.7): icmp_seq=1 ttl=60 time=13.5 ms \n", "44390 (129.88.11.7): icmp_seq=1 ttl=60 time=45.9 ms \n", "44391 (129.88.11.7): icmp_seq=1 ttl=60 time=58.5 ms \n", "44392 (129.88.11.7): icmp_seq=1 ttl=60 time=1.45 ms \n", "44393 (129.88.11.7): icmp_seq=1 ttl=60 time=1.11 ms \n", "44394 (129.88.11.7): icmp_seq=1 ttl=60 time=2.26 ms \n", "44395 (129.88.11.7): icmp_seq=1 ttl=60 time=1.24 ms \n", "44396 (129.88.11.7): icmp_seq=1 ttl=60 time=1.25 ms \n", "44397 (129.88.11.7): icmp_seq=1 ttl=60 time=2.46 ms \n", "44398 (129.88.11.7): icmp_seq=1 ttl=60 time=1.47 ms \n", "44399 (129.88.11.7): icmp_seq=1 ttl=60 time=1.21 ms \n", "44400 (129.88.11.7): icmp_seq=1 ttl=60 time=1.55 ms \n", "44401 (129.88.11.7): icmp_seq=1 ttl=60 time=1.22 ms \n", "44402 (129.88.11.7): icmp_seq=1 ttl=60 time=1.34 ms \n", "44403 (129.88.11.7): icmp_seq=1 ttl=60 time=2.43 ms \n", "44404 (129.88.11.7): icmp_seq=1 ttl=60 time=1.19 ms \n", "44405 (129.88.11.7): icmp_seq=1 ttl=60 time=1.14 ms \n", "44406 (129.88.11.7): icmp_seq=1 ttl=60 time=2.19 ms \n", "44407 (129.88.11.7): icmp_seq=1 ttl=60 time=1.29 ms \n", "44408 (129.88.11.7): icmp_seq=1 ttl=60 time=1.47 ms \n", "44409 (129.88.11.7): icmp_seq=1 ttl=60 time=7.02 ms \n", "44410 (129.88.11.7): icmp_seq=1 ttl=60 time=2.33 ms \n", "44411 (129.88.11.7): icmp_seq=1 ttl=60 time=1.61 ms \n", "44412 (129.88.11.7): icmp_seq=1 ttl=60 time=1.35 ms \n", "\n", "[44036 rows x 10 columns]" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "data_1 = raw_data_1.dropna().copy()\n", "data_1" ] }, { "cell_type": "markdown", "metadata": { "hideCode": true, "hidePrompt": true }, "source": [ "On récupère les données des tailles de fichiers envoyés dans size_1, les temps associés dans time_1, et les dates dans date_1" ] }, { "cell_type": "code", "execution_count": 7, "metadata": { "hideCode": true, "hidePrompt": true, "scrolled": true }, "outputs": [ { "data": { "text/plain": [ "0 665\n", "1 1373\n", "2 262\n", "3 1107\n", "4 1128\n", "5 489\n", "6 1759\n", "7 1146\n", "8 884\n", "9 1422\n", "10 1180\n", "11 999\n", "13 1020\n", "14 71\n", "15 34\n", "16 1843\n", "17 407\n", "18 356\n", "19 1511\n", "20 587\n", "21 809\n", "22 1364\n", "23 1153\n", "24 853\n", "25 1510\n", "26 123\n", "27 1966\n", "28 933\n", "29 922\n", "30 24\n", " ... \n", "44383 1772\n", "44384 41\n", "44385 1944\n", "44386 400\n", "44387 226\n", "44388 466\n", "44389 350\n", "44390 1829\n", "44391 1954\n", "44392 1074\n", "44393 46\n", "44394 1844\n", "44395 645\n", "44396 444\n", "44397 1940\n", "44398 1411\n", "44399 49\n", "44400 420\n", "44401 227\n", "44402 947\n", "44403 1960\n", "44404 531\n", "44405 374\n", "44406 1503\n", "44407 572\n", "44408 1338\n", "44409 1515\n", "44410 1875\n", "44411 1006\n", "44412 1273\n", "Name: 1, Length: 44036, dtype: int64" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "size_1=data_1[1]\n", "size_1" ] }, { "cell_type": "code", "execution_count": 8, "metadata": { "hideCode": true, "hidePrompt": true, "scrolled": true }, "outputs": [ { "data": { "text/plain": [ "0 22.50\n", "1 21.20\n", "2 21.20\n", "3 23.30\n", "4 1.41\n", "5 21.90\n", "6 78.70\n", "7 25.10\n", "8 24.00\n", "9 19.50\n", "10 18.00\n", "11 18.80\n", "13 24.30\n", "14 3.45\n", "15 5.85\n", "16 2.31\n", "17 1.14\n", "18 1.10\n", "19 2.18\n", "20 1.27\n", "21 1.33\n", "22 1.51\n", "23 1.44\n", "24 1.30\n", "25 2.17\n", "26 1.21\n", "27 2.20\n", "28 1.34\n", "29 1.42\n", "30 1.12\n", " ... \n", "44383 28.80\n", "44384 1.14\n", "44385 2.32\n", "44386 1.98\n", "44387 3.01\n", "44388 7.45\n", "44389 13.50\n", "44390 45.90\n", "44391 58.50\n", "44392 1.45\n", "44393 1.11\n", "44394 2.26\n", "44395 1.24\n", "44396 1.25\n", "44397 2.46\n", "44398 1.47\n", "44399 1.21\n", "44400 1.55\n", "44401 1.22\n", "44402 1.34\n", "44403 2.43\n", "44404 1.19\n", "44405 1.14\n", "44406 2.19\n", "44407 1.29\n", "44408 1.47\n", "44409 7.02\n", "44410 2.33\n", "44411 1.61\n", "44412 1.35\n", "Name: 8, Length: 44036, dtype: float64" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "time_1_str=data_1[8]\n", "time_1 = pd.Series(time_1_str)\n", "time_1=time_1.str.replace('^[^\\d]*', '').astype(float)\n", "time_1" ] }, { "cell_type": "code", "execution_count": 9, "metadata": { "hideCode": true, "hidePrompt": true }, "outputs": [], "source": [ "date_1_str=data_1[0]\n", "def find_number(text):\n", " num = re.findall(r'[0-9]+',text)\n", " return \".\".join(num)\n", "date_1=date_1_str.apply(lambda x: find_number(x))\n" ] }, { "cell_type": "markdown", "metadata": { "hideCode": true, "hidePrompt": true }, "source": [ "## Exploitation des données" ] }, { "cell_type": "code", "execution_count": 10, "metadata": { "hideCode": true, "hidePrompt": true }, "outputs": [ { "data": { "text/plain": [ "[]" ] }, "execution_count": 10, "metadata": {}, "output_type": "execute_result" }, { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXoAAAD8CAYAAAB5Pm/hAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvIxREBQAAIABJREFUeJzt3X98VPWd7/HXZzLJJJAEERJ+Q7QiW8AKmgt2rV1/rKviD9A+aq0/2t56H3a3um0f3b2KK3vr3UJXu9vuXtbeLu7W1pWqtdfSugVqlbUt9GFBUCqCIlgw/JKEH5IgZEgy3/vHzITJMJPMZObMj8P7+XjkkcnJmZnPnHPmc77n++uYcw4REfGvQLEDEBERbynRi4j4nBK9iIjPKdGLiPicEr2IiM8p0YuI+JwSvYiIzynRi4j4nBK9iIjPBYsdAMDIkSNdU1NTscMQESkrGzZsOOCcaxhovZJI9E1NTaxfv77YYYiIlBUzezeT9VR1IyLic0r0IiI+p0QvIuJzSvQiIj6nRC8i4nNK9FIwre2d3LzkZVo7OosdishpRYleCmbxqm28svMQi1/cVuxQRE4rJdGPXvxtyoKVhLsjvX8vXdvC0rUthIIBti68poiRiZweVKIXz62+9zJumDGW6sro4VZdGWDujLGsvu+yIkcmcnpQohfPNdZXUxcKEu6OEAoGCHdHqAsFaayrLnZoIqcFVd1IQRw4Gua22ZO4ddZEnlzXQpsaZEUKxpxzxY6B5uZmp7luRESyY2YbnHPNA62nqhsREZ9TohcR8TklehERn1OiFxHxOSV6ERGfU6IXEfE5JXoREZ9TohcR8TklehERn1OiFxHxOSV6ERGfGzDRm9kEM3vJzN40s81m9uXY8gfNbI+ZbYz9zEl4zv1mtt3MtprZVV5+ABER6V8ms1d2A3/lnHvVzOqADWb2Qux//+Sc+8fElc1sKnALMA0YC7xoZuc653ryGbiIiGRmwBK9c26fc+7V2OMO4E1gXD9PmQs87ZwLO+d2ANuBWfkIVkREspdVHb2ZNQEzgbWxRfeY2etm9piZDY8tGwfsSnjabvo/MYiIiIcyTvRmVgs8C3zFOdcOfBf4EDAD2Ad8K75qiqefMum9md1lZuvNbH1bW1vWgYuISGYySvRmVkk0yf/QOfcTAOfcfudcj3MuAvwbJ6tndgMTEp4+Htib/JrOuUedc83OueaGhoZcPoOIiPQjk143BnwPeNM59+2E5WMSVrsReCP2+DngFjMLmdlZwGRgXf5CFhGRbGTS6+Zi4A5gk5ltjC37G+DTZjaDaLXMTuALAM65zWb2DLCFaI+du9XjRkSkeAZM9M65NaSud1/Rz3MWAYtyiEtERPJEI2NFRHxOiV5ExOeU6EVEfE6JXkTE55ToRUR8ToleRMTnlOhFRHxOiV5ExOeU6EVEfE6JXkTE55ToRUR8ToleRMTnlOhFRHxOiV5ExOeU6EVEfE6JXkTE55ToRUR8ToleRMTnlOhFRHxOiV5ExOeU6EVEfE6JXkTE55ToRUR8ToleRMTnlOhLXGt7JzcveZnWjs5ihyIiZUqJvsQtXrWNV3YeYvGL24odioiUqWCxA5DUpixYSbg70vv30rUtLF3bQigYYOvCa4oYmYiUmwFL9GY2wcxeMrM3zWyzmX05tvxMM3vBzLbFfg9PeM79ZrbdzLaa2VVefgC/Wn3vZdwwYyzVldFdVF0ZYO6Msay+77IiRyYi5SaTqptu4K+ccx8GLgLuNrOpwHxglXNuMrAq9jex/90CTAOuBv6vmVV4EbyfNdZXUxcKEu6OEAoGCHdHqAsFaayrLnZoIlJmBkz0zrl9zrlXY487gDeBccBc4PHYao8D82KP5wJPO+fCzrkdwHZgVr4DPx0cOBrmttmTWPbFi7lt9iTajoaLHZKIlKGs6ujNrAmYCawFRjnn9kH0ZGBmjbHVxgG/S3ja7tgyydKSO5p7Hy+cN72IkYhIOcu4142Z1QLPAl9xzrX3t2qKZS7F691lZuvNbH1bW1umYYiISJYySvRmVkk0yf/QOfeT2OL9ZjYm9v8xQGts+W5gQsLTxwN7k1/TOfeoc67ZOdfc0NAw2PhFRGQAmfS6MeB7wJvOuW8n/Os54LOxx58Ffpaw/BYzC5nZWcBkYF3+QhYRkWxkUkd/MXAHsMnMNsaW/Q3wEPCMmd0JtACfBHDObTazZ4AtRHvs3O2c68l75CIikpEBE71zbg2p690BrkjznEXAohziEhGRPNEUCCIiPqdELyK+pAkBT1KiFxFf0oSAJ2lSMxHxFU0IeCqV6EXEVzQh4KmU6EXEVzQh4KlUdSMivhOfEPDWWRN5cl0Lbad5g6w5d8o0NAXX3Nzs1q9fX+wwRETKipltcM41D7Seqm5ERHxOiV5ExOeU6EVEfE6JXkTE55ToRUR8ToleRMTnlOhFRHxOiV5ExOeU6EVEfE6JXkTE55ToRUR8ToleRMTnlOhFRHxOiV5ExOeU6EVEfE6JXkTE55ToRUR8ToleRMTnlOjltNXa3snNS16m9TS/n6j434CJ3sweM7NWM3sjYdmDZrbHzDbGfuYk/O9+M9tuZlvN7CqvAhfJ1eJV23hl5yEWv7it2KGIeCqYwTo/AB4B/iNp+T855/4xcYGZTQVuAaYBY4EXzexc51xPHmIVyYspC1YS7o70/r10bQtL17YQCgbYuvCaIkYm4o0BS/TOud8AhzJ8vbnA0865sHNuB7AdmJVDfCJ5t/rey7hhxliqK6OHf3VlgLkzxrL6vsuKHJmIN3Kpo7/HzF6PVe0Mjy0bB+xKWGd3bJlIyWisr6YuFCTcHSEUDBDujlAXCtJYV13s0EQ8MdhE/13gQ8AMYB/wrdhyS7GuS/UCZnaXma03s/VtbW2DDENkcA4cDXPb7Eks++LF3DZ7Em1Hw8UOScQzmdTRn8I5tz/+2Mz+Dfh57M/dwISEVccDe9O8xqPAowDNzc0pTwYiXllyR3Pv44XzphcxEhHvDapEb2ZjEv68EYj3yHkOuMXMQmZ2FjAZWJdbiCIikosBS/Rm9hRwKTDSzHYDXwMuNbMZRKtldgJfAHDObTazZ4AtQDdwt3rciIgUlzlX/FqT5uZmt379+mKHISJSVsxsg3OueaD1NDJWRMTnlOhFRHxOiV5ExOeU6EVEPFBKk+Yp0YuIeKCUJs0b1IApERFJrRQnzVOJXkQkj0px0jwlehGRPCrFSfNUdSMikmfxSfNunTWRJ9e10FbkBlmNjBURKVMaGSsiIoASvYiI7ynRi4j4nBK9iIjPKdGLiPicEr2IiM8p0YuI+JwSvYiIzynRi4j4nBK9iIjPKdGLiPicEr2IiM8p0YuI+JwSvYiIzynRi4j4nBK9iIjPKdGLSElobe/k5iUv01rkuzH50YCJ3sweM7NWM3sjYdmZZvaCmW2L/R6e8L/7zWy7mW01s6u8ClxE/GXxqm28svMQi1/cVuxQfGfAWwma2ceBo8B/OOemx5Z9EzjknHvIzOYDw51z95nZVOApYBYwFngRONc519Pfe+hWgiKnrykLVhLujpyyPBQMsHXhNUWIqHzk7VaCzrnfAIeSFs8FHo89fhyYl7D8aedc2Dm3A9hONOmLiKS0+t7LuGHGWKoro+moujLA3BljWX3fZUWOzD8GW0c/yjm3DyD2uzG2fBywK2G93bFlIiIpNdZXUxcKEu6OEAoGCHdHqAsFaayrLnZovpHvxlhLsSxl3ZCZ3WVm681sfVtbW57DkHKkxrjT14GjYW6bPYllX7yY22ZPou1ouNgheaYYx/lgE/1+MxsDEPvdGlu+G5iQsN54YG+qF3DOPeqca3bONTc0NAwyDPETvzbG6QQ2sCV3NLNw3nSmjq1n4bzpLLljwGrnslWM43zAxlgAM2sCfp7QGPsPwMGExtgznXP3mtk04ElONsauAiaXYmNsa3sn9zz1Go/cOlOXiEXm98a4Bcs28cN1Ldw2ayILbzyv2OFIkXhxnOetMdbMngJeBqaY2W4zuxN4CLjSzLYBV8b+xjm3GXgG2AL8Arh7oCRfLH4tPZYjvzbGTVmwkqb5y1m6tgXnYOnaFprmL2fKgpXFDk2KoJjHeXCgFZxzn07zryvSrL8IWJRLUF5KPqsuXdvC0rUtvik9liO/NsatvvcyFq54k19ufo/OrgjVlQGumjaaB679cLFDK4psrqL9eMVdzOP8tBsZ69fSY6nJtl7aj41xfj2BDVY2V9H5uuIutfaRYh3nA5bo/UZfvsJI/KJmUi+d2Pi2cN50L0MrqPgX+9ZZE3lyXQttJZJwCiFeKt/YcpgTPSfbAvu7ih7oijvbkn6647BYVwxL7mimtb2TLzyxAQc8+pkLC/K+GTXGeq3QjbFfeGI9DXXVfb58fm7lLyQvG1b9eDnvF63tndz1xAbMYMkdF9JYV93bCH3TzHF0RVzKKqzGuuo++xUHC1e8yfNv7CPc7QgFjaunj+GTF47nL5a+yiXnjmTlG+9x26yJfOmKyb3vuWjedB78zy08cutMDnSEmbN4Tco4q4IB3l54DQuWbWLp2hZGDK1izLBqghUBHv3MhX2Oq1THW7pjML78weun9saR/Nnif1/3L2to7YiW5G+fnVsDfaaNsadlohfvtLZ3pq2XzjU5q/dKaWpt7+Sa/7Oagx+cAKDCoGeAtDJiaBVP3DmLB/9zC3WhCla91ca1543ma9dP6/Na8XUT/05lcmMt29uO0lAboroyQMuh41QEoCepzGGkGdhDNOneOnsin1ryO757+wV89Znf03Y0zE0zx7Hr8HEevH4qn/v+K7R2hHsTdDyRTzijhp9s3MM5DSfj+PbN5/O5779Cd8QxsraKI8dO0HVqGQgYfEFIiV6K5oFlm3hyXQtVFQFO9ERyTsx+735Zzs59YEWfahnJ3oUTz+C7d1w4qIJQ3rpXimQr3w1OakAvTVMWrFSSz4PX9xzxvCrytGuMFe/lu2G1XBvQ/dymkO4qS7LX1eNomr8cgJ0PXevJe6hEL2WhHLtf+nlQ3up7dTWVb0v/h3cT/aqOXiTPToc2BZXo828wpXnV0UvOSm2wSbnwe5uCknz5UaIvMaWUXP1c9eClcm1TyNTqey/jz6aNKnYYvtM0f3lvXX2+qTG2xGQ7otQLmg8od34eEdtYX80vN+8vdhi+5FU9veroS0Qp1et6OehJ/OHTj77My39IvsOo5CrbenrV0ZeZUqrX9XvVg+Tu1Zb3ix2C71RWpLpBX34o0ZeIUkuu5didUQpn9b2XUVlR7Cj8ZduiOZ69turoS0gp1ev6dTZJyY9LvvkSXSV5S6Hy1TR/uWdVtaqjF5GstbZ3Musbq4odhu/EZ9fMVKZ19CrRi0hW+utHX2HR2SEjLjpTZGN9iP3t6av9aioDHE83peNpaI1HbXKqoxeRrMQ7DgRStB1WV1bgiPYWw6CqIkCwnyyTaZJvGjGkt6NCubl2+mhCwQABg+E1lWnXG1Uf8qxNrjy3nHiilAZrZaLc4i22fG2veMcBB73J/oopDZw5pJIPTvQw57zRLPvixTgHuw4fJx+DaHcePEZnAUr+l3xoBMNq8lPRUVlh3H7RJLqd45MXjscBtdVBbr9oEhOH1/RZd1h1kBkTzsjL+6aiRC+9ym0kbKbx5pLg/HQyyef+jXcc+PlfXsLtF03i7dajHDrWBcCWPR38zbJNOb9HsqoKw6seiNdOH02FGavfOciR4905v151ZYBpY4fxzCstPL95P0vXtvSe+Jb+7l1aDh9nWE0QA4bVBAlVVnh6lzvfN8b6earYfCmlwVqZyDbeXO5M5Ye7Wnm5fwea9yYYIC8l+kzVVAaIRByBgGVd9z9tbD1b9rWTbUocWlXBBydSd0EKGFx3/tjewYf9Gcz+0B2mYvzwRfVaMUbC5nICzjTeXBJcKZz8Ut2HdbCv49X+3bL3CPO+89ui34AkAESAMcOqefn+K7jy279mW+vRvutYtJE4WaFPRsly2R+n/cjYKQtW0jR/ee8l09K1LTTNX86UBSv7rOenS/PBKsZgrVyqETKNN5fRxqUwUnnxqm1s3PU+r7W8n1N1i1f7d8qClcxZvCbjJF8RMIZUnTrKqioP9THxPL3vSCdN85ezrfUooWCASSOGUFMZwEid5CE/ST5Vw3SiIVUVadfp7Irw89/v9fT75tvulavvvSxtKSZRKUwiVgoKNVgrXxOmZRJvLgmumCOVU11N5DqxXL73b7ZTFVdVGF0Rx4ihVRw7cbzP/7y4GjAg3B3h3YPHmNxYe0rpPt8iLv0VA8CxNFU7EI31kskjvQks/h5+rrrp7ybVpXBpPli5tjsUs92i0NVEX3hiPQ111X0SXKaNXrk8Nxet7Z0s+NkbvLhlf2/iqDC4cuoo/m7e9JJoa4rvx5//fm/a5JZoznljOHNoFW0dnXx97nQWrniT59/YR7g7s/xTEwwQqqwgFAxgAeO9I6V3BW7A+OE17Dp8HCM6niAbXt54xLcleui/FJNpib8U5XoV0t/zvT4JFLqknMtUDsWaBqKxvpqG2lCfBNrjYGStd/2ss9VYX81zG/dmvP6KTfuAaEGqsb464xNE3PHuCMe7I9w+eyIHPzjByiPvZRtyXlRWGF0prkAmDK9h9/vHOfTBCQCuOW9M72fOhJe3EYQcE72Z7QQ6gB6g2znXbGZnAj8CmoCdwM3OucO5hTk4/X1RS20SsUzkWu2RyfNzPYlkcqLwopoo2xNUqffGOnA0zIThNXxkfLRv9eu73y+pieWS27oyYcDUsfW0dnTy8ckj2XnwGC2HjmWV8Jeubel9XOhRtZdOaWDcGTX8MCGGuF2Ho9VR8d432SR5gNv/fZ2ntQk5Vd3EEn2zc+5AwrJvAoeccw+Z2XxguHPuvv5ep1hz3RTr0nywcq326O/5lzz8Ul6qsgrdyymesCcMr+Enr+3J+H3VGys35z6wkhM92SXZoVUVHOvq6d3m8arVEqg9LhnZft8K0r0yTaLfClzqnNtnZmOAXznnpvT3OprULCqTUmZ/7Q6ZSPf8XE8ixWrz+ND9y0nVlpfufb2Os9SvFPIl3ltt58FjxQ6loCYMr6G1I5zTPXPHnlHN4aNhjie0T1QEjOs+MibrtqpCda90wC/NbIOZ3RVbNso5tw8g9rsxx/c4bWTS5TDXeeLTPT/XqqxCd0eMd59NleT7e998x5ncPbfcRhcPVmN9Nd3Z1LkkqQ1Fa43HD68hsddhPga+fvTsEXl4ldR2HT6e843R3zvSycenNDK5sRYj2tDeE3GeVh3n2hh7sXNur5k1Ai+Y2VuZPjF2YrgLYOLEiTmGUZ7ipb+NLYf7dDHrr+491wbC+PNb2zt5e38Hj9w6s/d/udSdZ3qiyFeJN7kxHaLd2xz0+4XJ9YSWHH88sX/0G6v6nHT8fp/dbLtXJjsajk4zsPtw366W15w3hm37O7LuDhkAamIjVN9rz1+PnOqg0Zlhz6BMBQPGl6+YzG3/vpabLhjPnR87y/P7T+RUonfO7Y39bgWWAbOA/bEqG2K/W9M891HnXLNzrrmhoSGXMFLKZCBUfJ0te48UZdBUPElcf/5Yz0vDmZQ8l9zRzMJ50xlZW8Xb+zv4epYnkkyuNvJV4k1M2PGBKNdMG93nfdMdA7lcFcXjv+gbq/oMyEu+sijGAKtCDv5LvjKKa6yryul1V2zaN6g+7xFONoTuOPBBTjEkyneSh+i4gTmL13D4WBc1lQGmjq1n4bzppTnXjZkNBQLOuY7Y4xeAvwOuAA4mNMae6Zy7t7/X8qKOPpPGtvg65zTUsr3taMEa5vorDVUFA3QNou59IPHPmm6EYGLJ04uGSi/qxlM1pn997vTeEvfiF7fl7XMMVIKtrgwwur6adw8dG3T7Sa4S99uXrpic9ZVTtldbZ9+/PKseM5kKBY1wtyNg0e167ER+etbMOW8Mb+49wo4SbFcY7PfA88ZYMzubaCkeolVATzrnFpnZCOAZYCLQAnzSOdfv7eLzmejTfSGrKgLMmHgGj9w6M20PkzivL7dTNXwGMI519XDt9NEMrw0NqgdQqi9qJgkq3z1v0sWWXNXSNGIIz/z5R/NaL7lg2aY+XfAS5fI5Uu2z0fXV7Dx4jFAwmtjHn1HDn0xpTNuLy6uG2v728e2zMz/ZpDrB9xfz5x5by6/ePpDqpfp15pDK3pkuk9WFgnSEu3sHHFUFA4w7o5odB9In52AARg+rOaUaKC7+nXpy7buenJhyETC4/vyxgx4weNpOapau90jQjJ9s3NNb2kk1Mi8UDHD1dG8n84obqGvZYJJSui/qQAkqXz1vBpKuBOj1LIr5+hzJPZbiif3qaaP56jMbmTqmjh98fnba53vVpTPVSTRZf9v43AdWpJyGIBQM8MkLx6eNeTD19GOHVXPZHzWm7IuerC5UQUe4h8qAUVcdJFgRoLWj/2q2YIXRnfBZJg6v4UhnF2eNrOUbN07nm794a1AnJ695XaL33cjY5Ma2zq4IP0sYwRdvJIs33MXnp6gwONFTuEFT8Xri2WcN569//DonuiM4GNQI3YEGQsW3R1WF0dkV4UR3hNsvOrXR1etBZPFBMvuOdPbWrcdLM7lKbpytCBg9EUdVheXtc6RqrF44bzoLlm2i7WiY8cNHpXxevub3SVe6TtxvVcEAJ7oj0Z4cLrPj6frzx/Lsq3v6POdEd4Rwd6T36ihVzMu++MfMWbwm4/gB9h7pzCjJA3SEo3XuXRGX9gogWXfSCaslVsrfuOt95j7yW66clnof5UN8Bs1EibdWTGdIVQW/+p+XehYX+HT2ysTGtk9cMI7Rw6qjtzYDzODqaaP4+OSR3DRzHENDQc4eOZRZZ585qO6KgxVv+Fz7h0OEY0l+sMl1oC6D8e3xp1NHA9E+uwvnTU/ZCHTgaJgbZ45jcmMtN80cn9ft8YPPz+bic0Zyoid6InFEeyDc8+RrebvrUfwk1RNxTG6s5ad3fyxv+zW+z+Lb7Vdb2zKaITXbLp3pGlXjDcHXLV6TtoH5p1+8mMmNtfS4gY+neBfVZ1/dA5xsUO7sijBvxrgBY34yw4SdLNUMloXQFXGs2BSdOiFfNzAJJkxJmerapsf1n+QhOuHZrEWrBjXaOFO+K9FD3y6I37p5Bg8s29RbinAO3mn7gBe++icsWLaJo+FurvzwKHa/f5wvXXFOwQa5pLrsDXdHqDDLOikNVBL/1da2Pu+16/BxmuYvT9t9c8GyTWze186MCWfwrZvz2xMguVT8662t7H7/+KCmXEgu4aYqcceTshcynS8pmyul1vZOrvuXNbR2hHu3SfKx0toRZtaiVX32X+Ixf3bDUGafPWLAbrKproIumTySEUNDHA13MbI2lDLmXLtW9jeTY6Hka8LMXMYSJLp6WnTCOq/4ro4+WTYHZcDgD3+f/Qxy2Wpt7+QLT2ygoT7Eb95uy7k+vLW9k6v++Tdc/uFG7rz47FMaAgtxo45s5eO9SmEag0xHKn/usXVs2dfOtz91Pr94Y3/Kxvb0HQmiE2ml+qbGt9dgG3qT479p5jh2HT7OI7fO5G9/+kbKKUJa2zu56O9XlVzDZjFVBCDLGSH6mNxYywtf/ZOsn3fa33gkbvW9l3HVtFF9LtUCBqPrT/0yRBwpL72T5dpf+eFfvMVru97n17GSdq714YtXbeP9413UBCtOqY6JJ4BgwDy9UUe2cnmvTG8q058te49w3teeZ8u+I4P+DJB5n/zxw2toOxrmF5veS9lnOl2SN2DN/MtpGjG0z/IK6zsC+OFfvMW6HYd48LnNWR2byfGv23God5zD1+dO5+39HYysq+oTc2N9NfNmjMvo9U8XAyX5y/+osU81T7JtrUezPoaz4cuqm0SN9dWMrA31uVSLOKirDvJee9+bBWTaEDrYGR6Tv8zxxxHnokkiyxNHNrNR7nu/xtMbdWQr8b3MyOq9sp1iOn6ye/D6qTz4n1t45NaZfPnpjXSEu/nyUxt7S1KpSsUDlZQHGqmcaUNs/DMlT/3rgFmLVp3yuj0u2hUxuUtsvA76okWraD7rzAFL+PH408UJpDzOPziR+w20TwcGXDhpOGOHnZwyIhQM8K1PfoRFK95iX2xefa+nSfdtiT6x1B2f8vXa88Zw7XljmDC8hiPHu7jpgnEMq6kEogm/v2H7Ny95mXMfWJFVSTK55B+JpD7td/U4frx+V9b95uOl4lAwWlIIBa23lJdc6o3ffX7ed37bZ9RrcozZjBrNZvRxqnUOHA0zuaEW52ByQ23GbROpTkgvv3Mw7frxk92Xn97Iuh2HmLVoVe/oy3hJqmn+8pSjdrMdyZv8eU/uo+hXLRRMf+Xy8jundvszYNwZNb3PrwgYl05p4BMXRBvK01W9RoB1O6IjeDOJeeqYev5s2qhTRrpC6uN8yR3NXHruSJpGDEn5mtVB36aWrDhg/buH+4ztCHdHuOepjb1JPr7Myx5/vtkb8S/Ymm1tnPe15/nfz23u/YIuuaOZ1fddznduu4Dv3HYBq++7nHUP/ClDKis4fKyLyY21/PwvLxlw2H7yVAVmcNW0Ub1f2oGmGbhy2uiUsV967sjeebqzcTLhRb/s4W5H0IzGumqWffGPGTG0ingHh6oKGDG0iis/3NgnpuQYk3uWJA/4yXYCr/g6D614ixu/81vmfee3tHZ0MmXBSp7fvJ+3Ywn37dajPL95f8aXroknpMkNtb2Nl4mST3YDDa1PPoEPdFJPrv6JN6Su2xHdJsnVZtD3C504Bcd1/7KGto4TnNtYy5zp0eMkPmjoQEdnn95Ev91+gDsvaWLJHc2sue9yJqVJtnCyOvKs+5fT2tHZZx/GHz+88i027n6fHW0f9HbDhZM9U1KdnFrbO/n1tgNpZ68cM8y/M3d6IX6MecU3jbHxhrlMBiBl2hDYX0NuvMonsRHlr57ZyLOv7knZn7Y/kxujUzBcM300q98+wHdvv4DF/7W997I7sfoAR281xLWL16RsoKusMG6I9Y3OVlUwwNsJ2yDxvR9a8RY/eW1P2ntjVlUYby+aA/S/7T5xwTjeeq+Dve8f58jxrt7Xio+Uffu9Dj772Doev3MWHzvn5DxIyVUwyZPBJcYxY+IYJtOUAAAJwUlEQVRwHrx+Kv/6mz8MeMu6CWfWcCzcw9FwF+FuRyhoDKkKcv74Yfxux6GUI3m37D3Su/3PGjGEnQePZX3ruGvPG83yTanvlBQwGD2smr3vR0+qE8+soTIQ4J3YPC7x4661vZOPffMlTnRHUt6+LhQMMGJoFXuPdDK8ppLLP9zYO2//D9e2pD1+mkYM7XNiTB5h298IZIhWRYS7Illvk3I0mNsGJhtaVcGP/+KjTB0zLLv3Pl1GxmbSq6YiAI9/Ppo0Wts7ueuJDbS2d7I3dukUCgYYUlVBQ12IqmCAyooAi+ZN597/9zq7Dh/jyPHi1Ec21oX4wX//b3zu+6/Q2hHm9tnRWT7j8/PkesPjcWfUsO/I8T5Ju666gu6IY1RtiHcPHaeuOkh7Z2aff2RtFf/8qRn8xdJX+e7tF/DE797l+c37c4px6Z2zWPxf23nw+ql87vuv0HY03PvZgwHj4nNGsDYhGY8cWsWB2O3crp0+mpWb30vbO+RTF47nRxt2UxmA+IDSeFWQV6orA2lHr+aiqsLycpPt6FVDBA83gfSjJG88ki+5JPo129r4zPfWDViCPmvEUBrqQ6zfeSijbmGj60O81+7t4Kmld87iL596jcMZjvoTKQWpTirBAKflyWHC8BqW3HFh1iOE4xK329wZ2c95c9pMgfC3P92cUTXJjoMfsONg5tOXep3kAW7/3jrP30Mk31JdOZyOSR6inRzSJfl0VZyJuiP0zjlVyjceKZqm+cuLHYKISFoRF+3tMnVsPW/sbU+73mBHxGejbBN9ZcDo0tA8kZLwkXH1vL4nfTLzszHDqjl2ojtlW14EeGNvO2OHVRMI2ClTKRvRnnt/N2+6p9OvlG2iN8tHW7eI5MPpmOTjvesS+8OnszfNOg4YWRvyfI6tsu1HfyKXiSVERHIQqjBcnmbAXLq2hXM9nLkSyjjRV+ZrnlERkSyFexxr77+CG2aMzcvrXX/emLy8TjrlW3VT7ABEpKRk0ssln2ZlML1Epp59bQ/PvrbHs9uYlm2JPh+DQ0SkvPQzASSO8i4ABgxPZoqFMk70K770sfINXkQGpb8Su3PZdc8YVR8qqRPDjTPGqR99ssGORBMRAdifp0GRuVQZxU805zTWctTDqZ/LtlC84ksfK3YIIiI5tQs44LaLJnF2w9CspynPRtmW6KeOHcZZI4awI800qSIi5WDp797tvd+AV8q2RA8oyYtI2ZswvMazRti4sk70IiLlbtfh48xatMqz+8VCGVfdeLlRREQKKT5FsVfKtkRfAtPoi4jkxc827uWSh1/y7PU9S/RmdrWZbTWz7WY2P//voEwvIv7h5U2gPEn0ZlYBfAe4BpgKfNrMpubzPdbcd3k+X05EpKhO9DjP7rPhVYl+FrDdOfcH59wJ4Glgbl7fII/zTIiI+JlXiX4csCvh792xZSIiksbOh6715HW9SvSpppDoUwFlZneZ2XozW9/W1pb1G3i1QURE/Mar7pW7gQkJf48H9iau4Jx7FHgUoLm5WS2rImVOha/S5VWifwWYbGZnAXuAW4Bb8/0mOrBERAbmSaJ3znWb2T3A80AF8JhzbrMX7yUiIv3zbGSsc24FsMKr1xcRkcyU7chYERHJjBK9iIjPKdGLiPicEr2IiM+ZlxPpZByEWRvwbhZPGQkc8CicXJRqXFC6sSmu7JVqbIore7nGNsk51zDQSiWR6LNlZuudc97dYHGQSjUuKN3YFFf2SjU2xZW9QsWmqhsREZ9TohcR8blyTfSPFjuANEo1Lijd2BRX9ko1NsWVvYLEVpZ19CIikrlyLdGLiEiGyirRe38f2n7fe4KZvWRmb5rZZjP7cmz5g2a2x8w2xn7mJDzn/lisW83sKo/j22lmm2IxrI8tO9PMXjCzbbHfwwsZm5lNSdguG82s3cy+UqxtZmaPmVmrmb2RsCzrbWRmF8a29XYzW2xmqe6/kGtc/2Bmb5nZ62a2zMzOiC1vMrPjCdvuXwscV9b7Lt9x9RPbjxLi2mlmG2PLC7nN0uWJ4h5nzrmy+CE6C+Y7wNlAFfB7YGoB338McEHscR3wNtH74T4I/HWK9afGYgwBZ8Vir/Awvp3AyKRl3wTmxx7PBx4uRmwJ++89YFKxthnwceAC4I1cthGwDvgo0RvsrASu8SCuPwOCsccPJ8TVlLhe0usUIq6s912+40oXW9L/vwX8ryJss3R5oqjHWTmV6D2/D21/nHP7nHOvxh53AG/S/+0R5wJPO+fCzrkdwHain6GQ5gKPxx4/DswrYmxXAO845/obGOdpXM653wCHUrxnxtvIzMYA9c65l1302/gfCc/JW1zOuV8657pjf/6O6M170ipUXP0o2PYaKLZYyfdm4Kn+XsOjbZYuTxT1OCunRF8y96E1syZgJrA2tuie2CX2YwmXZIWO1wG/NLMNZnZXbNko59w+iB6AQGORYoPozWcSv3ilsM0g+200Lva4kDF+nmiJLu4sM3vNzH5tZpfElhUyrmz2XTG21yXAfufctoRlBd9mSXmiqMdZOSX6Ae9DW5AgzGqBZ4GvOOfage8CHwJmAPuIXjJC4eO92Dl3AXANcLeZfbyfdQsam5lVATcAP44tKpVt1p90sRR62z0AdAM/jC3aB0x0zs0Evgo8aWb1BYwr231XjH36afoWKgq+zVLkibSrpokhr7GVU6If8D60XjOzSqI774fOuZ8AOOf2O+d6nHMR4N84WdVQ0Hidc3tjv1uBZbE49scuAeOXqa3FiI3oyedV59z+WIwlsc1ist1Gu+lbjeJZjGb2WeA64LbY5TuxS/yDsccbiNbpnluouAax7wq2vQDMLAjcBPwoIeaCbrNUeYIiH2fllOh770MbKyHeAjxXqDeP1ft9D3jTOffthOVjEla7EYj3AngOuMXMQha9d+5koo0rXsQ21Mzq4o+JNuS9EYvhs7HVPgv8rNCxxfQpYZXCNkuQ1TaKXXZ3mNlFsWPiMwnPyRszuxq4D7jBOXcsYXmDmVXEHp8di+sPBYwrq31XqLgS/CnwlnOut9qjkNssXZ6g2MdZLi3Mhf4B5hBtxX4HeKDA7/0xopdOrwMbYz9zgCeATbHlzwFjEp7zQCzWreShp0E/sZ1NtOX+98Dm+LYBRgCrgG2x32cWIbYhwEFgWMKyomwzoiebfUAX0RLTnYPZRkAz0QT3DvAIsYGHeY5rO9G62/ix9q+xdT8R28e/B14Fri9wXFnvu3zHlS622PIfAH+etG4ht1m6PFHU40wjY0VEfK6cqm5ERGQQlOhFRHxOiV5ExOeU6EVEfE6JXkTE55ToRUR8ToleRMTnlOhFRHzu/wN8VxCgox6tdgAAAABJRU5ErkJggg==\n", "text/plain": [ "
" ] }, "metadata": { "needs_background": "light" }, "output_type": "display_data" } ], "source": [ "plt.plot(size_1,time_1,'*')" ] }, { "cell_type": "markdown", "metadata": { "hideCode": true, "hidePrompt": true }, "source": [ "La durée d'envoi des données ne semble pas linéairement dépendante de la taille. On voit un seuil aux alentours de 1500 octets, à partir duquel le temps d'envoi des données augmente brutalement. On sépare les données en deux et on effectue une régression linéaire sur les deux jeux parties séparées" ] }, { "cell_type": "code", "execution_count": 20, "metadata": { "hideCode": true, "hidePrompt": true }, "outputs": [], "source": [ "ind_low=size_1<1500\n", "ind_high=size_1>=1500\n", "\n", "size_low=size_1[ind_low]\n", "size_high=size_1[ind_high]\n", "\n", "time_low=time_1[ind_low]\n", "time_high=time_1[ind_high]\n", "\n", "reg_low = LinearRegression() # create object for the class\n", "reg_low.fit(size_low.values.reshape(-1,1), time_low.values.reshape(-1,1)) # perform linear regression\n", "\n", "time_low_reg = reg_low.predict(size_low.values.reshape(-1,1)) # make predictions\n", "\n", "reg_high = LinearRegression() # create object for the class\n", "reg_high.fit(size_high.values.reshape(-1,1), time_high.values.reshape(-1,1)) # perform linear regression\n", "\n", "time_high_reg = reg_high.predict(size_high.values.reshape(-1,1)) # make predictions" ] }, { "cell_type": "code", "execution_count": 21, "metadata": { "hideCode": true, "hidePrompt": true }, "outputs": [ { "data": { "text/plain": [ "[,\n", " ,\n", " ]" ] }, "execution_count": 21, "metadata": {}, "output_type": "execute_result" }, { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXoAAAD8CAYAAAB5Pm/hAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvIxREBQAAIABJREFUeJzt3Xt8VPWd//HXZzLJJJBwERLuEG2RLZcWNAt21a7ouipWQfuotV7a/urvYbeXbfvo7k9xZX/1t4Wu7W67u6zdLm5r60rV2rW0boFaZXuBPiwISkXwAhYMN0m4SIKQyWW+vz9mJkyGmWQmM2cuh/fz8cgjk5MzZz5z5sznfM/3dsw5h4iI+Feg2AGIiIi3lOhFRHxOiV5ExOeU6EVEfE6JXkTE55ToRUR8ToleRMTnlOhFRHxOiV5ExOeCxQ4AYPTo0a6xsbHYYYiIlJUtW7Ycds7VD7ReSST6xsZGNm/eXOwwRETKipm9mcl6qroREfE5JXoREZ9TohcR8TklehERn1OiFxHxOSV6KZiWtg5uWvEcLe0dxQ5F5KyiRC8Fs3zdTp7fc5Tlz+4sdigiZ5WS6Ecv/jZtyVrC3ZHev1dubGblxmZCwQCvLb2miJGJnB1UohfPrb9rPtfPHk91ZfRwq64MsHD2eNbfPb/IkYmcHZToxXMNw6qpCwUJd0cIBQOEuyPUhYI01FUXOzSRs4KqbqQgDp8Ic+u8KdwydzKPbmqmVQ2yIgVjzrlix0BTU5PTXDciItkxsy3OuaaB1lPVjYiIzynRi4j4nBK9iIjPKdGLiPicEr2IiM8p0YuI+JwSvYiIzynRi4j4nBK9iIjPKdGLiPicEr2IiM8NmOjNbJKZ/dLMXjGz7Wb2hdjy+8xsv5ltjf0sSHjOPWa2y8xeM7OrvHwDIiLSv0xmr+wG/so594KZ1QFbzOyZ2P/+yTn3j4krm9l04GZgBjAeeNbMznfO9eQzcBERycyAJXrn3EHn3Auxx+3AK8CEfp6yEHjcORd2zu0GdgFz8xGsiIhkL6s6ejNrBOYAG2OLPmdmL5nZQ2Y2MrZsArA34Wn76P/EICIiHso40ZtZLfAk8EXnXBvwbeBdwGzgIPCN+Kopnn7GpPdmdqeZbTazza2trVkHLiIimcko0ZtZJdEk/wPn3I8BnHOHnHM9zrkI8B+crp7ZB0xKePpE4EDyNp1zDzrnmpxzTfX19bm8BxER6UcmvW4M+C7winPumwnLxyWsdgPwcuzxU8DNZhYys3OBqcCm/IUsIiLZyKTXzcXA7cA2M9saW/Y3wEfNbDbRapk9wKcAnHPbzewJYAfRHjufVY8bEZHiGTDRO+c2kLrefU0/z1kGLMshLhERyRONjBUR8TklehERn1OiFxHxOSV6ERGfU6IXEfE5JXoREZ9TohcR8TklehERn1OiFxHxOSV6ERGfU6IXEfE5JXoREZ9TohcR8TklehERn1OiFxHxOSV6ERGfU6IXEfE5JXoREZ9TohcR8TklehERn1OiFxHxOSV6ERGfU6IXEfE5JXoREZ9Toi9xLW0d3LTiOVraO4odioiUKSX6Erd83U6e33OU5c/uLHYoIlKmgsUOQFKbtmQt4e5I798rNzazcmMzoWCA15ZeU8TIRKTcDFiiN7NJZvZLM3vFzLab2Rdiy88xs2fMbGfs98iE59xjZrvM7DUzu8rLN+BX6++az/Wzx1NdGf2IqisDLJw9nvV3zy9yZCJSbjKpuukG/so59x7gIuCzZjYdWAysc85NBdbF/ib2v5uBGcDVwL+ZWYUXwftZw7Bq6kJBwt0RQsEA4e4IdaEgDXXVxQ5NRMrMgIneOXfQOfdC7HE78AowAVgIPBxb7WFgUezxQuBx51zYObcb2AXMzXfgZ4PDJ8LcOm8Kqz5zMbfOm0LriXCxQxKRMpRVHb2ZNQJzgI3AGOfcQYieDMysIbbaBOB3CU/bF1smWVpxe1Pv46WLZhYxEhEpZxn3ujGzWuBJ4IvOubb+Vk2xzKXY3p1mttnMNre2tmYahoiIZCmjRG9mlUST/A+ccz+OLT5kZuNi/x8HtMSW7wMmJTx9InAgeZvOuQedc03Ouab6+vrBxi8iIgPIpNeNAd8FXnHOfTPhX08BH489/jjw04TlN5tZyMzOBaYCm/IXsoiIZCOTOvqLgduBbWa2Nbbsb4D7gSfM7A6gGfgwgHNuu5k9Aewg2mPns865nrxHLiIiGRkw0TvnNpC63h3gijTPWQYsyyEuERHJE02BICLic0r0IuJLmhDwNCV6EfElTQh4miY1ExFf0YSAZ1KJXkR8RRMCnkmJXkR8RRMCnklVNyLiO/EJAW+ZO5lHNzXTepY3yJpzZ0xDU3BNTU1u8+bNxQ5DRKSsmNkW51zTQOup6kZExOeU6EVEfE6JXkTE55ToRUR8ToleRMTnlOhFRHxOiV5ExOeU6EVEfE6JXkTE55ToRUR8ToleRMTnlOhFRHxOiV5ExOeU6EVEfE6JXkTE55ToRUR8ToleRMTnlOhFRHxOiV7OWi1tHdy04jlazvL7iYr/DZjozewhM2sxs5cTlt1nZvvNbGvsZ0HC/+4xs11m9pqZXeVV4CK5Wr5uJ8/vOcryZ3cWOxQRTwUzWOf7wAPAfyYt/yfn3D8mLjCz6cDNwAxgPPCsmZ3vnOvJQ6wieTFtyVrC3ZHev1dubGblxmZCwQCvLb2miJGJeGPAEr1z7jfA0Qy3txB43DkXds7tBnYBc3OITyTv1t81n+tnj6e6Mnr4V1cGWDh7POvvnl/kyES8kUsd/efM7KVY1c7I2LIJwN6EdfbFlomUjIZh1dSFgoS7I4SCAcLdEepCQRrqqosdmognBpvovw28C5gNHAS+EVtuKdZ1qTZgZnea2WYz29za2jrIMEQG5/CJMLfOm8Kqz1zMrfOm0HoiXOyQRDyTSR39GZxzh+KPzew/gJ/F/twHTEpYdSJwIM02HgQeBGhqakp5MhDxyorbm3ofL100s4iRiHhvUCV6MxuX8OcNQLxHzlPAzWYWMrNzganAptxCFBGRXAxYojezx4DLgNFmtg/4MnCZmc0mWi2zB/gUgHNuu5k9AewAuoHPqseNiEhxmXPFrzVpampymzdvLnYYIiJlxcy2OOeaBlpPI2NFRHxOiV5ExOeU6EVEfE6JXkTEA6U0aZ4SvYiIB0pp0rxBDZgSEZHUSnHSPJXoRUTyqBQnzVOiFxHJo1KcNE9VNyIieRafNO+WuZN5dFMzrUVukNXIWBGRMqWRsSIiAijRi4j4nhK9iIjPKdGLiPicEr2IiM8p0YuI+JwSvYiIzynRi4j4nBK9iIjPKdGLiPicEr2IiM8p0YuI+JwSvYiIzynRi4j4nBK9iIjPKdGLiPicEr2IlISWtg5uWvEcLUW+G5MfDZjozewhM2sxs5cTlp1jZs+Y2c7Y75EJ/7vHzHaZ2WtmdpVXgYuIvyxft5Pn9xxl+bM7ix2K7wx4K0Ez+wBwAvhP59zM2LKvA0edc/eb2WJgpHPubjObDjwGzAXGA88C5zvnevp7Dd1KUOTsNW3JWsLdkTOWh4IBXlt6TREiKh95u5Wgc+43wNGkxQuBh2OPHwYWJSx/3DkXds7tBnYRTfoiIimtv2s+188eT3VlNB1VVwZYOHs86++eX+TI/GOwdfRjnHMHAWK/G2LLJwB7E9bbF1smIpJSw7Bq6kJBwt0RQsEA4e4IdaEgDXXVxQ7NN/LdGGsplqWsGzKzO81ss5ltbm1tzXMYUo7UGHf2OnwizK3zprDqMxdz67wptJ4IFzskzxTjOB9soj9kZuMAYr9bYsv3AZMS1psIHEi1Aefcg865JudcU319/SDDED/xa2OcTmADW3F7E0sXzWT6+GEsXTSTFbcPWO1ctopxnA/YGAtgZo3AzxIaY/8BOJLQGHuOc+4uM5sBPMrpxth1wNRSbIxtaevgc4+9yAO3zNElYpH5vTFuyapt/GBTM7fOnczSG2YVOxwpEi+O87w1xprZY8BzwDQz22dmdwD3A1ea2U7gytjfOOe2A08AO4CfA58dKMkXi19Lj+XIr41x05aspXHxalZubMY5WLmxmcbFq5m2ZG2xQ5MiKOZxHhxoBefcR9P864o06y8DluUSlJeSz6orNzazcmOzb0qP5civjXHr75rP0jWv8Ivtb9HRFaG6MsBVM8Zy77XvKXZoRZHNVbQfr7iLeZyfdSNj/Vp6LDXZ1kv7sTHOryewwcrmKjpfV9yl1j5SrON8wBK93+jLVxiJX9RM6qUTG9+WLprpZWgFFf9i3zJ3Mo9uaqa1RBJOIcRL5Vubj9HZc7otsL+r6IGuuLMt6ac7Dot1xbDi9iZa2jr41CNbcMCDH7uwIK+bUWOs1wrdGPupRzZTX1fd58vn51b+QvKyYdWPl/N+0dLWwZ2PbMEMVtx+IQ111b2N0DfOmUBXxKWswmqoq+7zueJg6ZpXePrlg4S7HaGgcfXMcXz4wol8euULXHr+aNa+/Ba3zp3M56+Y2vuayxbN5L7/3sEDt8zhcHuYBcs3pIyzKhjg9aXXsGTVNlZubGbU0CrGDa8mWBHgwY9d2Oe4SnW8pTsG48vvu256bxzJ7y3+9wf/dQMt7dGS/G3zcmugz7Qx9qxM9OKdlraOtPXSuSZn9V4pTS1tHVzzL+s58k4nABUGPQOklVFDq3jkjrnc9987qAtVsO7VVq6dNZYvXzejz7bi6yb+ncrUhlp2tZ6gvjZEdWWA5qOnqAhAT1KZw0gzsIdo0r1l3mQ+suJ3fPu2C/jSE7+n9USYG+dMYO+xU9x33XQ+8b3naWkP9yboeCKfNKKGH2/dz7vrT8fxzZvexye+9zzdEcfo2iqOn+yk68wyEDD4gpASvRTNvau28eimZqoqAnT2RHJOzH7vflnOzr93TZ9qGcnehZNH8O3bLxxUQShv3StFspXvBic1oJemaUvWKsnnwUv7j3teFXnWNcaK9/LdsFquDeh+blNId5Ul2evqcTQuXg3Anvuv9eQ1VKKXslCO3S/9PChv/V26msq3lf/bu4l+VUcvkmdnQ5uCSvT5N5jSvOroJWelNtikXPi9TUFJvvwo0ZeYUkqufq568FK5tilkav1d8/nzGWOKHYbvNC5e3VtXn29qjC0x2Y4o9YLmA8qdn0fENgyr5hfbDxU7DF/yqp5edfQlopTqdb0c9CT+8NEHn+O5PyTfYVRylW09veroy0wp1ev6vepBcvdC89vFDsF3KitS3aAvP5ToS0SpJddy7M4ohbP+rvlUVhQ7Cn/ZuWyBZ9tWHX0JKaV6Xb/OJin5cenXf0lXSd5SqHw1Ll7tWVWt6uhFJGstbR3M/eq6YofhO/HZNTOVaR29SvQikpX++tFXWHR2yIiLzhTZMCzEobb01X41lQFOpZvS8Sy0waM2OdXRi0hW4h0HAinaDqsrK3BEe4thUFURINhPlsk0yTeOGtLbUaHcXDtzLKFggIDByJrKtOuNGRbyrE2uPPeceKKUBmtlotziLbZ87a94xwEHvcn+imn1nDOkknc6e1gwayyrPnMxzsHeY6fIxyDaPUdO0lGAkv+l7xrF8Jr8VHRUVhi3XTSFbuf48IUTcUBtdZDbLprC5JE1fdYdXh1k9qQReXndVJTopVe5jYTNNN5cEpyfTib5/HzjHQd+9peXcttFU3i95QRHT3YBsGN/O3+zalvOr5GsqsLwqgfitTPHUmHG+jeOcPxUd87bq64MMGP8cJ54vpmntx9i5cbm3hPfyt+9SfOxUwyvCWLA8JogocoKT+9y5/vGWD9PFZsvpTRYKxPZxpvLnan8cFcrLz/fgea9CQbIS4k+UzWVASIRRyBgWdf9zxg/jB0H28g2JQ6tquCdztRdkAIGH3zf+N7Bh/0ZzOehO0zF+OGL6rVijITN5QScaby5JLhSOPmlug/rYLfj1ee748BxFn3rt0W/AUkAiADjhlfz3D1XcOU3f83OlhN917FoI3GyQp+MkuXyeZz1I2OnLVlL4+LVvZdMKzc207h4NdOWrO2znp8uzQerGIO1cqlGyDTeXEYbl8JI5eXrdrJ179u82Px2TtUtXn2+05asZcHyDRkn+YqAMaTqzFFWVXmoj4nn6YPHO2hcvJqdLScIBQNMGTWEmsoARuokD/lJ8qkaphMNqapIu05HV4Sf/f6Ap98333avXH/X/LSlmESlMIlYKSjUYK18TZiWSby5JLhijlROdTWR68Ry+f58s52quKrC6Io4Rg2t4mTnqT7/8+JqwIBwd4Q3j5xkakPtGaX7fIu49FcMACfTVO1ANNZLp472JrD4a/i56qa/m1SXwqX5YOXa7lDMdotCVxN96pHN1NdV90lwmTZ65fLcXLS0dbDkpy/z7I5DvYmjwuDK6WP4u0UzS6KtKf45/uz3B9Imt0QLZo3jnKFVtLZ38JWFM1m65hWefvkg4e7M8k9NMECosoJQMIAFjLeOl94VuAETR9aw99gpjOh4gmx4eeMR35boof9STKYl/lKU61VIf8/3+iRQ6JJyLlM5FGsaiIZh1dTXhvok0B4Ho2u962edrYZh1Ty19UDG66/ZdhCIFqQahlVnfIKIO9Ud4VR3hNvmTebIO52sPf5WtiHnRWWF0ZXiCmTSyBr2vX2Ko+90AnDNrHG97zkTXt5GEHJM9Ga2B2gHeoBu51yTmZ0D/BBoBPYANznnjuUW5uD090UttUnEMpFrtUcmz8/1JJLJicKLaqJsT1Cl3hvr8Ikwk0bW8N6J0b7VL+17u6Qmlktu68qEAdPHD6OlvYMPTB3NniMnaT56MquEv3Jjc+/jQo+qvWxaPRNG1PCDhBji9h6LVkfFe99kk+QBbvvOJk9rE3Kquokl+ibn3OGEZV8Hjjrn7jezxcBI59zd/W2nWHPdFOvSfLByrfbo7/mXfu2XeanKKnQvp3jCnjSyhh+/uD/j11VvrNycf+9aOnuyS7JDqyo42dXTu8/jVaslUHtcMrL9vhWke2WaRP8acJlz7qCZjQN+5Zyb1t92NKlZVCalzP7aHTKR7vm5nkSK1ebxrntWk6otL93reh1nqV8p5Eu8t9qeIyeLHUpBTRpZQ0t7OKd75o4fUc2xE2FOJbRPVASMD753XNZtVYXqXumAX5jZFjO7M7ZsjHPuIEDsd0OOr3HWyKTLYa7zxKd7fq5VWYXujhjvPpsqyff3uvmOM7l7brmNLh6shmHVdGdT55KkNhStNZ44sobEXof5GPj6/vNG5WErqe09dirnG6O/dbyDD0xrYGpDLUa0ob0n4jytOs61MfZi59wBM2sAnjGzVzN9YuzEcCfA5MmTcwyjPMVLf1ubj/XpYtZf3XuuDYTx57e0dfD6oXYeuGVO7/9yqTvP9ESRrxJvcmM6RLu3Oej3C5PrCS05/nhif/9X1/U56fj9PrvZdq9MdiIcnWZg37G+XS2vmTWOnYfas+4OGQBqYiNU32rLX4+c6qDRkWHPoEwFA8YXrpjKrd/ZyI0XTOSOS871/P4TOZXonXMHYr9bgFXAXOBQrMqG2O+WNM990DnX5Jxrqq+vzyWMlDIZCBVfZ8eB40UZNBVPEte9b7znpeFMSp4rbm9i6aKZjK6t4vVD7XwlyxNJJlcb+SrxJibs+ECUa2aM7fO66Y6BXK6K4vFf9NV1fQbkJV9ZFGOAVSEH/yVfGcU11FXltN012w4Oqs97hNMNobsPv5NTDInyneQhOm5gwfINHDvZRU1lgOnjh7F00czSnOvGzIYCAedce+zxM8DfAVcARxIaY89xzt3V37a8qKPPpLEtvs6762vZ1XqiYA1z/ZWGqoIBugZR9z6Q+HtNN0IwseTpRUOlF3XjqRrTv7JwZm+Je/mzO/P2PgYqwVZXBhg7rJo3j54cdPtJrhI/t89fMTXrK6dsr7bOu2d1Vj1mMhUKGuFuR8Ci+/VkZ3561iyYNY5XDhxndwm2Kwz2e+B5Y6yZnUe0FA/RKqBHnXPLzGwU8AQwGWgGPuyc6/d28flM9Om+kFUVAWZPHsEDt8xJ28MkzuvL7VQNnwGMk109XDtzLCNrQ4PqAZTqi5pJgsp3z5t0sSVXtTSOGsITf/H+vNZLLlm1rU8XvES5vI9Un9nYYdXsOXKSUDCa2CeOqOFPpzWk7cXlVUNtf5/xbfMyP9mkOsH3F/MnHtrIr14/nGpT/TpnSGXvTJfJ6kJB2sPdvQOOqoIBJoyoZvfh9Mk5GICxw2vOqAaKi3+nHt34picnplwEDK573/hBDxg8ayc1S9d7JGjGj7fu7y3tpBqZFwoGuHqmt5N5xQ3UtWwwSSndF3WgBJWvnjcDSVcC9HoWxXy9j+QeS/HEfvWMsXzpia1MH1fH9z85L+3zverSmeokmqy/fXz+vWtSTkMQCgb48IUT08Y8mHr68cOrmf9HDSn7oierC1XQHu6hMmDUVQcJVgRoae+/mi1YYXQnvJfJI2s43tHFuaNr+eoNM/n6z18d1MnJa16X6H03Mja5sa2jK8JPE0bwxRvJ4g138fkpKgw6ewo3aCpeTzzv3JH89Y9eorM7goNBjdAdaCBUfH9UVRgdXRE6uyPcdtGZja5eDyKLD5I5eLyjt249XprJVXLjbEXA6Ik4qiosb+8jVWP10kUzWbJqG60nwkwcOSbl8/I1v0+60nXi51YVDNDZHYn25HCZHU/XvW88T76wv89zOrsjhLsjvVdHqWJe9Zk/YcHyDRnHD3DgeEdGSR6gPRytc++KuLRXAMm6k05YzbFS/ta9b7Pwgd9y5YzUn1E+xGfQTJR4a8V0hlRV8Kv/c5lncYFPZ69MbGz70AUTGDu8OnprM8AMrp4xhg9MHc2NcyYwNBTkvNFDmXveOYPqrjhY8YbPjX84SjiW5AebXAfqMhjfH382fSwQ7bO7dNHMlI1Ah0+EuWHOBKY21HLjnIl53R/f/+Q8Ln73aDp7oicSR7QHwucefTFvdz2Kn6R6Io6pDbX85LOX5O1zjX9m8f32q9daM5ohNdsunekaVeMNwR9cviFtA/NPPnMxUxtq6XEDH0/xLqpPvrAfON2g3NEVYdHsCQPG/GiGCTtZqhksC6Er4lizLTp1Qr5uYBJMmJIy1bVNj+s/yUN0wrO5y9YNarRxpnxXooe+XRC/cdNs7l21rbcU4Ry80foOz3zpT1myahsnwt1c+Z4x7Hv7FJ+/4t0FG+SS6rI33B2hwizrpDRQSfxXr7X2ea29x07RuHh12u6bS1ZtY/vBNmZPGsE3bspvT4DkUvGvX2th39unBjXlQnIJN1WJO56UvZDpfEnZXCm1tHXwwX/dQEt7uHefJB8rLe1h5i5b1+fzSzzmz6sfyrzzRg3YTTbVVdClU0czamiIE+EuRteGUsaca9fK/mZyLJR8TZiZy1iCRFfPiE5Y5xXf1dEny+agDBj84e+zn0EuWy1tHXzqkS3UDwvxm9dbc64Pb2nr4Kp//g2Xv6eBOy4+74yGwELcqCNb+XitUpjGINORyp94aBM7DrbxzY+8j5+/fChlY3v6jgTRibRSfVPj+2uwDb3J8d84ZwJ7j53igVvm8Lc/eTnlFCEtbR1c9PfrSq5hs5gqApDljBB9TG2o5Zkv/WnWzzvrbzwSt/6u+Vw1Y0yfS7WAwdhhZ34ZIo6Ul97Jcu2v/LWfv8qLe9/m17GSdq714cvX7eTtU13UBCvOqI6JJ4BgwDy9UUe2cnmtTG8q058dB44z68tPs+Pg8UG/B8i8T/7EkTW0ngjz821vpewznS7JG7Bh8eU0jhraZ3mF9R0B/LWfv8qm3Ue576ntWR2byfFv2n20d5zDVxbO5PVD7Yyuq+oTc8OwahbNnpDR9s8WAyX5y/+ooU81T7KdLSeyPoaz4cuqm0QNw6oZXRvqc6kWcVBXHeSttr43C8i0IXSwMzwmf5njjyPORZNElieObGajPPh2jac36shW4muZkdVrZTvFdPxkd99107nvv3fwwC1z+MLjW2kPd/OFx7b2lqRSlYoHKikPNFI504bY+HtKnvrXAXOXrTtjuz0u2hUxuUtsvA76omXraDr3nAFL+PH408UJpDzO3+nM/QbaZwMDLpwykvHDT08ZEQoG+MaH38uyNa9yMDavvtfTpPu2RJ9Y6o5P+XrtrHFcO2sck0bWcPxUFzdeMIHhNZVANOH3N2z/phXPcf69a7IqSSaX/COR1Kf9rh7HjzbvzbrffLxUHApGSwqhoPWW8pJLvfG7zy/61m/7jHpNjjGbUaPZjD5Otc7hE2Gm1tfiHEytr824bSLVCem5N46kXT9+svvC41vZtPsoc5et6x19GS9JNS5enXLUbrYjeZPf7+nPKPpVCwXTX7k898aZ3f4MmDCipvf5FQHjsmn1fOiCaEN5uqrXCLBpd3QEbyYxTx83jD+fMeaMka6Q+jhfcXsTl50/msZRQ1Juszro29SSFQdsfvNYn7Ed4e4In3tsa2+Sjy/zssefbz6N+Bdsw85WZn35af7fU9t7v6Arbm9i/d2X861bL+Bbt17A+rsvZ9O9f8aQygqOnexiakMtP/vLSwcctp88VYEZXDVjTO+XdqBpBq6cMTZl7JedP7p3nu5snE540S97uNsRNKOhrppVn/kTRg2tIt7BoaoCRg2t4sr3NPSJKTnG5J4lyQN+sp3AK77O/Wte5YZv/ZZF3/otLe0dTFuylqe3H+L1WMJ9veUET28/lPGla+IJaWp9bW/jZaLkk91AQ+uTT+ADndSTq3/iDambdkf3SXK1GfT9QidOwfHBf91Aa3sn5zfUsmBm9DiJDxo63N7RpzfRb3cd5o5LG1lxexMb7r6cKWmSLZyujjz3ntW0tHf0+Qzjj7+29lW27nub3a3v9HbDhdM9U1KdnFraOvj1zsNpZ68cN9y/M3d6IX6MecU3jbHxhrlMBiBl2hDYX0NuvMonsRHlr57YypMv7E/Zn7Y/UxuiUzBcM3Ms618/zLdvu4Dl/7Or97I7sfoAR281xLXLN6RsoKusMK6P9Y3OVlUwwOsJ+yDxte9f8yo/fnF/2ntjVlUYry9bAPS/7z50wQRefaudA2+f4viprt5txUfKvv5WOx9/aBMP3zGXS959eh6k5CqY5MngEuOYPXl5dsMDAAALhUlEQVQk9103nX//zR8GvGXdpHNqOBnu4US4i3C3IxQ0hlQFed/E4fxu99GUI3l3HDjeu//PHTWEPUdOZn3ruGtnjWX1ttR3SgoYjB1ezYG3oyfVyefUUBkI8EZsHpf4cdfS1sElX/8lnd2RlLevCwUDjBpaxYHjHYysqeTy9zT0ztv/g43NaY+fxlFD+5wYk0fY9jcCGaJVEeGuSNb7pBwN5raByYZWVfCjT7+f6eOGZ/faZ8vI2Ex61VQE4OFPRpNGS1sHdz6yhZa2Dg7ELp1CwQBDqiqorwtRFQxQWRFg2aKZ3PVfL7H32EmOnypOfWRDXYjv/68/5hPfe56W9jC3zYvO8hmfnyfXGx5PGFHDweOn+iTtuuoKuiOOMbUh3jx6irrqIG0dmb3/0bVV/PNHZvPplS/w7dsu4JHfvcnT2w/lFOPKO+ay/H92cd910/nE956n9US4970HA8bF7x7FxoRkPHpoFYdjt3O7duZY1m5/K23vkI9cOJEfbtlHZQDiA0rjVUFeqa4MpB29mouqCsvLTbajVw0RPNwF0o+SvPFIvuSS6DfsbOVj3900YAn63FFDqR8WYvOeoxl1Cxs7LMRbbd4Onlp5x1z+8rEXOZbhqD+RUpDqpBIMcFaeHCaNrGHF7RdmPUI4LnG/LZyd/Zw3Z80UCH/7k+0ZVZPsPvIOu49kPn2p10ke4LbvbvL8NUTyLdWVw9mY5CHaySFdkk9XxZmoO0LvnFOlfOORomlcvLrYIYiIpBVx0d4u08cP4+UDbWnXG+yI+GyUbaKvDBhdGponUhLeO2EYL+1Pn8z8bNzwak52dqdsy4sALx9oY/zwagIBO2MqZSPac+/vFs30dPqVsk30Zvlo6xaRfDgbk3y8d11if/h0DqRZxwGja0Oez7FVtv3oO3OZWEJEJAehCsPlaQbMlRubOd/DmSuhjBN9Zb7mGRURyVK4x7Hxniu4fvb4vGzvulnj8rKddMq36qbYAYhIScmkl0s+zc1geolMPfnifp58cb9ntzEt2xJ9PgaHiEh56WcCSBzlXQAMGJ7MFAtlnOjXfP6S8g1eRAalvxK7c9l1zxgzLFRSJ4YbZk9QP/pkgx2JJiICcChPgyJzqTKKn2je3VDLCQ+nfi7bQvGaz19S7BBERHJqF3DArRdN4bz6oVlPU56Nsi3RTx8/nHNHDWF3mmlSRcTHnKMy0k1VdxdVPdGfyp5uQrHHp5d3U9XTxbTWN6ntPElNVzj200FNd5ghnR2EujsZ0tVBTVeY6u4wQ+LrdKcu8fdYgOYRY6jq7u597fjrVLjsu31/9OZlvPCuObnukX6VbaIHlORFSsQf732ZHz26uNhhFESFi3DusYN52940O8m/eNQIG1fWiV5ESsPkt3ObjnowOgNBOoOVdMV+d1bEf4KE+/xdyWV/2ELEjFOVIU5VVnOqMsTJymo6gqHYshCngon/C9HRZ/np/x0eMoLj1bV0xbYdfa0gnRWVRAIVg3ov31+2zrOulVDGid6rm+iKSPaenHUFT866othhlK34FMVeKdvG2BKYRl/k7OAcgUgPFZEegj3RevFQV5jqrg5qOjsYGj5JbVjVqLn46dYDXPq1X3q2fc9K9GZ2NfAvQAXwHefc/fl9BQfO8emN/8X8N57HHBiOgIsQcA5wmIOAi95izVz0f+Yc1ud/rndZwEV/LPb8QPw5seeffm7f/+EcAeLbJ7ZOpHdbBoNqpBEpJ/946W088Cc3FzuMsuXlTaA8SfRmVgF8C7gS2Ac8b2ZPOed25Os1Ntx9Odfc+yR3//rhfG1SRNLosQAOcGZEzHAWwBGd2CtiATqCVayddnGxwyxrnT2OxsWr2XP/tXnftlcl+rnALufcHwDM7HFgIZC3RD/3q+tg6Agu+dR3GNd+GGcWO/CMSJ+DMvqY2AHa+z9ij81iz40esBEziG0rEj+oY9vt+xrR5xN/nd7tEVsnEPtCnN42Vkrj8ETkbOFVop8A7E34ex8wz4sX2jdiLPtGjPVi0yIiBeVFaR68a4xNVXTtUwFlZnea2WYz29za2pr1C3i1Q0RE/MarEv0+YFLC3xOBA4krOOceBB4EaGpqUh8akTKnwlfp8irRPw9MNbNzgf3AzcAt+X4RHVgiIgPzJNE757rN7HPA00S7Vz7knNvuxWuJiEj/POtH75xbA6zxavsiIpKZsh0ZKyIimVGiFxHxOSV6ERGfU6IXEfE583IinYyDMGsF3sziKaOBwx6Fk4tSjQtKNzbFlb1SjU1xZS/X2KY45+oHWqkkEn22zGyzc867GywOUqnGBaUbm+LKXqnGpriyV6jYVHUjIuJzSvQiIj5Xron+wWIHkEapxgWlG5viyl6pxqa4sleQ2Mqyjl5ERDJXriV6ERHJUFklejO72sxeM7NdZra4wK89ycx+aWavmNl2M/tCbPl9ZrbfzLbGfhYkPOeeWKyvmdlVHse3x8y2xWLYHFt2jpk9Y2Y7Y79HFjI2M5uWsF+2mlmbmX2xWPvMzB4ysxYzezlhWdb7yMwujO3rXWa23Cy3W4eliesfzOxVM3vJzFaZ2YjY8kYzO5Ww7/69wHFl/dnlO65+YvthQlx7zGxrbHkh91m6PFHc48w5VxY/RGfBfAM4D6gCfg9ML+DrjwMuiD2uA14HpgP3AX+dYv3psRhDwLmx2Cs8jG8PMDpp2deBxbHHi4GvFSO2hM/vLWBKsfYZ8AHgAuDlXPYRsAl4P9Eb7KwFrvEgrj8HgrHHX0uIqzFxvaTtFCKurD+7fMeVLrak/38D+L9F2Gfp8kRRj7NyKtH33ofWOdcJxO9DWxDOuYPOuRdij9uBV4jeMjGdhcDjzrmwc243sIvoeyikhUD87ukPA4uKGNsVwBvOuf4Gxnkal3PuN8DRFK+Z8T4ys3HAMOfccy76bfzPhOfkLS7n3C+cc92xP39H9OY9aRUqrn4UbH8NFFus5HsT8Fh/2/Bon6XLE0U9zsop0ae6D21/idYzZtYIzAE2xhZ9LnaJ/VDCJVmh43XAL8xsi5ndGVs2xjl3EKIHINBQpNggevOZxC9eKewzyH4fTYg9LmSMnyRaoos718xeNLNfm9mlsWWFjCubz64Y++tS4JBzbmfCsoLvs6Q8UdTjrJwS/YD3oS1IEGa1wJPAF51zbcC3gXcBs4GDRC8ZofDxXuycuwC4BvismX2gn3ULGpuZVQHXAz+KLSqVfdafdLEUet/dC3QDP4gtOghMds7NAb4EPGpmwwoYV7afXTE+04/St1BR8H2WIk+kXTVNDHmNrZwS/YD3ofWamVUS/fB+4Jz7MYBz7pBzrsc5FwH+g9NVDQWN1zl3IPa7BVgVi+NQ7BIwfpnaUozYiJ58XnDOHYrFWBL7LCbbfbSPvtUonsVoZh8HPgjcGrt8J3aJfyT2eAvROt3zCxXXID67gu0vADMLAjcCP0yIuaD7LFWeoMjHWTkl+t770MZKiDcDTxXqxWP1ft8FXnHOfTNh+biE1W4A4r0AngJuNrOQRe+dO5Vo44oXsQ01s7r4Y6INeS/HYvh4bLWPAz8tdGwxfUpYpbDPEmS1j2KX3e1mdlHsmPhYwnPyxsyuBu4GrnfOnUxYXm9mFbHH58Xi+kMB48rqsytUXAn+DHjVOddb7VHIfZYuT1Ds4yyXFuZC/wALiLZivwHcW+DXvoTopdNLwNbYzwLgEWBbbPlTwLiE59wbi/U18tDToJ/YziPacv97YHt83wCjgHXAztjvc4oQ2xDgCDA8YVlR9hnRk81BoItoiemOwewjoIlognsDeIDYwMM8x7WLaN1t/Fj799i6H4p9xr8HXgCuK3BcWX92+Y4rXWyx5d8H/iJp3ULus3R5oqjHmUbGioj4XDlV3YiIyCAo0YuI+JwSvYiIzynRi4j4nBK9iIjPKdGLiPicEr2IiM8p0YuI+Nz/B9+sHLcUQ3SaAAAAAElFTkSuQmCC\n", "text/plain": [ "
" ] }, "metadata": { "needs_background": "light" }, "output_type": "display_data" } ], "source": [ "plt.plot(size_1,time_1,'*',size_low.values.reshape(-1,1),time_low_reg,'r',size_high.values.reshape(-1,1),time_high_reg,'r')" ] }, { "cell_type": "code", "execution_count": 37, "metadata": { "hideCode": true, "hidePrompt": true }, "outputs": [ { "data": { "text/plain": [ "array([[0.00061726]])" ] }, "execution_count": 37, "metadata": {}, "output_type": "execute_result" } ], "source": [ "reg_low.coef_" ] }, { "cell_type": "code", "execution_count": 38, "metadata": { "hideCode": true, "hidePrompt": true }, "outputs": [ { "data": { "text/plain": [ "array([3.12808083])" ] }, "execution_count": 38, "metadata": {}, "output_type": "execute_result" } ], "source": [ "reg_low.intercept_" ] }, { "cell_type": "code", "execution_count": 39, "metadata": { "hideCode": true, "hidePrompt": true }, "outputs": [ { "data": { "text/plain": [ "array([[0.00286134]])" ] }, "execution_count": 39, "metadata": {}, "output_type": "execute_result" } ], "source": [ "reg_high.coef_" ] }, { "cell_type": "code", "execution_count": 40, "metadata": { "hideCode": true, "hidePrompt": true }, "outputs": [ { "data": { "text/plain": [ "array([4.77022699])" ] }, "execution_count": 40, "metadata": {}, "output_type": "execute_result" } ], "source": [ "reg_high.intercept_" ] }, { "cell_type": "markdown", "metadata": { "hideCode": true, "hidePrompt": true }, "source": [ "While the lag time seems to be more or less the same in the two categories (3 to 5 seconds according to the regressions), the coeff" ] } ], "metadata": { "hide_code_all_hidden": true, "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.6.4" } }, "nbformat": 4, "nbformat_minor": 2 }