ecn-queries.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# ECN Queries\n",
    "\n",
    "for the MAMI Path Transparency Observatory at https://v3.pto.mami-project.eu\n",
    "\n",
    "#### Configuration\n",
    "\n",
    "If you have an API token with query submission permissions, enter it here, and you can submit queries."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "token = None"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Now some imports and useful functions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import ptoclient\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import matplotlib.dates as mdates\n",
    "\n",
    "\n",
    "def pivot_condition_time(df, prefix, aspect, states):\n",
    "    \"\"\"\n",
    "    Given a dataframe counts of conditions (states of one or more aspects) \n",
    "    over a time series, pivot to a time-indexed table with a column for \n",
    "    each state.\n",
    "    \n",
    "    \"\"\"\n",
    "    \n",
    "    aspect_df = df[df['condition'].map(lambda x: x.startswith(\".\".join((prefix,aspect))))]\n",
    "    \n",
    "    total_df = aspect_df.groupby('time').sum().loc[:,[\"count\"]]\n",
    "    total_df.columns = ['total']\n",
    "    total_df['time'] = total_df.index\n",
    "    \n",
    "    aspect_df = aspect_df.join(total_df, on=\"time\", rsuffix=\"_\")\n",
    "    del(aspect_df['time_'])\n",
    "    \n",
    "    pivot_df = aspect_df.groupby('time').first().loc[:,['total']]\n",
    "    for c in states:\n",
    "        cseries = aspect_df[aspect_df['condition'] == \".\".join((prefix,aspect,c))]\n",
    "        cseries.index = cseries['time']\n",
    "        cseries = cseries.loc[:,['count']]\n",
    "        cseries.columns = [c]\n",
    "        pivot_df = pd.concat([pivot_df, cseries], axis=1)\n",
    "    \n",
    "    return pivot_df.fillna(0)\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Create a client to access the PTO\n",
    "\n",
    "The client object encapsulates a base URL and an API token, and can be used to access queries and observations on the given instance of the PTO."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "c = ptoclient.PTOClient(\"https://v3.pto.mami-project.eu/\", token)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Group all ECN multipoint condition counts by week \n",
    "\n",
    "Generate time series aggregates of ECN negotiation and ECN connectivity for the full dataset for which we have multipoint observations, then pivot those tables to generate plots.\n",
    "\n",
    "First, retrieve the query for all multipoint conditions over time from the PTO; dump metadata for the query."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'__completed': '2018-05-24T20:23:32+02:00',\n",
       " '__created': '2018-05-24T20:09:09+02:00',\n",
       " '__encoded': 'time_start=2014-01-01T00%3A00%3A00Z&time_end=2017-04-01T00%3A00%3A00Z&condition=ecn.multipoint.connectivity.broken&condition=ecn.multipoint.connectivity.offline&condition=ecn.multipoint.connectivity.path_dependent&condition=ecn.multipoint.connectivity.transient&condition=ecn.multipoint.connectivity.unstable&condition=ecn.multipoint.connectivity.works&condition=ecn.multipoint.negotiation.failed&condition=ecn.multipoint.negotiation.path_dependent&condition=ecn.multipoint.negotiation.reflected&condition=ecn.multipoint.negotiation.succeeded&condition=ecn.multipoint.negotiation.unstable&group=condition&group=week',\n",
       " '__executed': '2018-05-24T20:09:09+02:00',\n",
       " '__link': 'https://v3.pto.mami-project.eu/query/9d0a16b4fbb090b661e33140c847b999a8907a49058f21795ab68cdeb6784c95',\n",
       " '__modified': '2018-05-24T20:23:32+02:00',\n",
       " '__result': 'https://v3.pto.mami-project.eu/query/9d0a16b4fbb090b661e33140c847b999a8907a49058f21795ab68cdeb6784c95/result',\n",
       " '__state': 'complete'}"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# This query was created with the following submit command:\n",
    "# q_multipoint = c.submit_query(\n",
    "#                 ptoclient.PTOQuerySpec().time(\"2014-01-01\",\"2017-04-01\")\n",
    "#                                      .condition(\"ecn.multipoint.*\")\n",
    "#                                      .group_by_condition().time_series_week())\n",
    "\n",
    "q_multipoint = c.retrieve_query(url='https://v3.pto.mami-project.eu/query/9d0a16b4fbb090b661e33140c847b999a8907a49058f21795ab68cdeb6784c95')\n",
    "\n",
    "multipoint_df = q_multipoint.results()\n",
    "multipoint_df.columns = [\"count\",\"condition\",\"time\"]\n",
    "multipoint_df[\"time\"] = pd.to_datetime(multipoint_df[\"time\"])\n",
    "\n",
    "q_multipoint.metadata()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Create pivot tables, showing the counts for each state for negotiation and connectivity impact"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>total</th>\n",
       "      <th>succeeded</th>\n",
       "      <th>failed</th>\n",
       "      <th>reflected</th>\n",
       "      <th>path_dependent</th>\n",
       "      <th>unstable</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>time</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2014-08-25</th>\n",
       "      <td>598869</td>\n",
       "      <td>333803</td>\n",
       "      <td>260462</td>\n",
       "      <td>2043.0</td>\n",
       "      <td>2520</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-09-01</th>\n",
       "      <td>598869</td>\n",
       "      <td>332100</td>\n",
       "      <td>261759</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>2938</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-09-08</th>\n",
       "      <td>598869</td>\n",
       "      <td>331663</td>\n",
       "      <td>262356</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>2784</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-07-18</th>\n",
       "      <td>644060</td>\n",
       "      <td>459392</td>\n",
       "      <td>180980</td>\n",
       "      <td>2529.0</td>\n",
       "      <td>1117</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-07-25</th>\n",
       "      <td>642071</td>\n",
       "      <td>461278</td>\n",
       "      <td>177202</td>\n",
       "      <td>2521.0</td>\n",
       "      <td>956</td>\n",
       "      <td>114</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-08-01</th>\n",
       "      <td>640725</td>\n",
       "      <td>461879</td>\n",
       "      <td>175356</td>\n",
       "      <td>2498.0</td>\n",
       "      <td>865</td>\n",
       "      <td>127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-08-08</th>\n",
       "      <td>641768</td>\n",
       "      <td>462528</td>\n",
       "      <td>175470</td>\n",
       "      <td>2487.0</td>\n",
       "      <td>1171</td>\n",
       "      <td>112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-12-05</th>\n",
       "      <td>768401</td>\n",
       "      <td>582825</td>\n",
       "      <td>170581</td>\n",
       "      <td>0.0</td>\n",
       "      <td>413</td>\n",
       "      <td>14582</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-12-12</th>\n",
       "      <td>769254</td>\n",
       "      <td>585159</td>\n",
       "      <td>169467</td>\n",
       "      <td>0.0</td>\n",
       "      <td>476</td>\n",
       "      <td>14152</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-12-19</th>\n",
       "      <td>770301</td>\n",
       "      <td>585622</td>\n",
       "      <td>170052</td>\n",
       "      <td>0.0</td>\n",
       "      <td>344</td>\n",
       "      <td>14283</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-12-26</th>\n",
       "      <td>768755</td>\n",
       "      <td>584396</td>\n",
       "      <td>169557</td>\n",
       "      <td>0.0</td>\n",
       "      <td>528</td>\n",
       "      <td>14274</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-02</th>\n",
       "      <td>765674</td>\n",
       "      <td>581921</td>\n",
       "      <td>168676</td>\n",
       "      <td>0.0</td>\n",
       "      <td>422</td>\n",
       "      <td>14655</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-09</th>\n",
       "      <td>764973</td>\n",
       "      <td>582640</td>\n",
       "      <td>167270</td>\n",
       "      <td>0.0</td>\n",
       "      <td>442</td>\n",
       "      <td>14621</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-16</th>\n",
       "      <td>765820</td>\n",
       "      <td>583382</td>\n",
       "      <td>167015</td>\n",
       "      <td>0.0</td>\n",
       "      <td>685</td>\n",
       "      <td>14738</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-30</th>\n",
       "      <td>763558</td>\n",
       "      <td>581350</td>\n",
       "      <td>165420</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1766</td>\n",
       "      <td>15022</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             total  succeeded  failed  reflected  path_dependent  unstable\n",
       "time                                                                      \n",
       "2014-08-25  598869     333803  260462     2043.0            2520        41\n",
       "2014-09-01  598869     332100  261759     2020.0            2938        52\n",
       "2014-09-08  598869     331663  262356     2017.0            2784        49\n",
       "2016-07-18  644060     459392  180980     2529.0            1117        42\n",
       "2016-07-25  642071     461278  177202     2521.0             956       114\n",
       "2016-08-01  640725     461879  175356     2498.0             865       127\n",
       "2016-08-08  641768     462528  175470     2487.0            1171       112\n",
       "2016-12-05  768401     582825  170581        0.0             413     14582\n",
       "2016-12-12  769254     585159  169467        0.0             476     14152\n",
       "2016-12-19  770301     585622  170052        0.0             344     14283\n",
       "2016-12-26  768755     584396  169557        0.0             528     14274\n",
       "2017-01-02  765674     581921  168676        0.0             422     14655\n",
       "2017-01-09  764973     582640  167270        0.0             442     14621\n",
       "2017-01-16  765820     583382  167015        0.0             685     14738\n",
       "2017-01-30  763558     581350  165420        0.0            1766     15022"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "multipoint_nego_pivot = pivot_condition_time(multipoint_df, \"ecn.multipoint\", \"negotiation\",\n",
    "                                             ('succeeded','failed','reflected','path_dependent','unstable'))\n",
    "multipoint_nego_pivot"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>total</th>\n",
       "      <th>works</th>\n",
       "      <th>broken</th>\n",
       "      <th>transient</th>\n",
       "      <th>offline</th>\n",
       "      <th>path_dependent</th>\n",
       "      <th>unstable</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>time</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2014-08-25</th>\n",
       "      <td>598869</td>\n",
       "      <td>587553</td>\n",
       "      <td>2318</td>\n",
       "      <td>37</td>\n",
       "      <td>7212</td>\n",
       "      <td>897</td>\n",
       "      <td>852</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-09-01</th>\n",
       "      <td>598869</td>\n",
       "      <td>583583</td>\n",
       "      <td>2281</td>\n",
       "      <td>35</td>\n",
       "      <td>9803</td>\n",
       "      <td>1658</td>\n",
       "      <td>1509</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-09-08</th>\n",
       "      <td>598869</td>\n",
       "      <td>583476</td>\n",
       "      <td>2312</td>\n",
       "      <td>50</td>\n",
       "      <td>10818</td>\n",
       "      <td>1109</td>\n",
       "      <td>1104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-07-18</th>\n",
       "      <td>644060</td>\n",
       "      <td>641984</td>\n",
       "      <td>19</td>\n",
       "      <td>40</td>\n",
       "      <td>1746</td>\n",
       "      <td>211</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-07-25</th>\n",
       "      <td>642071</td>\n",
       "      <td>640027</td>\n",
       "      <td>22</td>\n",
       "      <td>33</td>\n",
       "      <td>1747</td>\n",
       "      <td>162</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-08-01</th>\n",
       "      <td>640725</td>\n",
       "      <td>638694</td>\n",
       "      <td>25</td>\n",
       "      <td>37</td>\n",
       "      <td>1746</td>\n",
       "      <td>126</td>\n",
       "      <td>97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-08-08</th>\n",
       "      <td>641768</td>\n",
       "      <td>639535</td>\n",
       "      <td>23</td>\n",
       "      <td>29</td>\n",
       "      <td>1725</td>\n",
       "      <td>271</td>\n",
       "      <td>185</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-12-05</th>\n",
       "      <td>768401</td>\n",
       "      <td>752863</td>\n",
       "      <td>1250</td>\n",
       "      <td>18</td>\n",
       "      <td>13238</td>\n",
       "      <td>619</td>\n",
       "      <td>413</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-12-12</th>\n",
       "      <td>769254</td>\n",
       "      <td>754065</td>\n",
       "      <td>1198</td>\n",
       "      <td>14</td>\n",
       "      <td>12865</td>\n",
       "      <td>638</td>\n",
       "      <td>474</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-12-19</th>\n",
       "      <td>770301</td>\n",
       "      <td>755505</td>\n",
       "      <td>1185</td>\n",
       "      <td>13</td>\n",
       "      <td>12964</td>\n",
       "      <td>349</td>\n",
       "      <td>285</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-12-26</th>\n",
       "      <td>768755</td>\n",
       "      <td>752682</td>\n",
       "      <td>1168</td>\n",
       "      <td>17</td>\n",
       "      <td>13008</td>\n",
       "      <td>1059</td>\n",
       "      <td>821</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-02</th>\n",
       "      <td>765674</td>\n",
       "      <td>750288</td>\n",
       "      <td>1183</td>\n",
       "      <td>16</td>\n",
       "      <td>13353</td>\n",
       "      <td>484</td>\n",
       "      <td>350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-09</th>\n",
       "      <td>764973</td>\n",
       "      <td>749819</td>\n",
       "      <td>1132</td>\n",
       "      <td>16</td>\n",
       "      <td>13394</td>\n",
       "      <td>359</td>\n",
       "      <td>253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-16</th>\n",
       "      <td>765820</td>\n",
       "      <td>750581</td>\n",
       "      <td>1128</td>\n",
       "      <td>22</td>\n",
       "      <td>13496</td>\n",
       "      <td>352</td>\n",
       "      <td>241</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-30</th>\n",
       "      <td>763558</td>\n",
       "      <td>748309</td>\n",
       "      <td>1150</td>\n",
       "      <td>28</td>\n",
       "      <td>13714</td>\n",
       "      <td>169</td>\n",
       "      <td>188</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             total   works  broken  transient  offline  path_dependent  \\\n",
       "time                                                                     \n",
       "2014-08-25  598869  587553    2318         37     7212             897   \n",
       "2014-09-01  598869  583583    2281         35     9803            1658   \n",
       "2014-09-08  598869  583476    2312         50    10818            1109   \n",
       "2016-07-18  644060  641984      19         40     1746             211   \n",
       "2016-07-25  642071  640027      22         33     1747             162   \n",
       "2016-08-01  640725  638694      25         37     1746             126   \n",
       "2016-08-08  641768  639535      23         29     1725             271   \n",
       "2016-12-05  768401  752863    1250         18    13238             619   \n",
       "2016-12-12  769254  754065    1198         14    12865             638   \n",
       "2016-12-19  770301  755505    1185         13    12964             349   \n",
       "2016-12-26  768755  752682    1168         17    13008            1059   \n",
       "2017-01-02  765674  750288    1183         16    13353             484   \n",
       "2017-01-09  764973  749819    1132         16    13394             359   \n",
       "2017-01-16  765820  750581    1128         22    13496             352   \n",
       "2017-01-30  763558  748309    1150         28    13714             169   \n",
       "\n",
       "            unstable  \n",
       "time                  \n",
       "2014-08-25       852  \n",
       "2014-09-01      1509  \n",
       "2014-09-08      1104  \n",
       "2016-07-18        60  \n",
       "2016-07-25        80  \n",
       "2016-08-01        97  \n",
       "2016-08-08       185  \n",
       "2016-12-05       413  \n",
       "2016-12-12       474  \n",
       "2016-12-19       285  \n",
       "2016-12-26       821  \n",
       "2017-01-02       350  \n",
       "2017-01-09       253  \n",
       "2017-01-16       241  \n",
       "2017-01-30       188  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "multipoint_conn_pivot = pivot_condition_time(multipoint_df, \"ecn.multipoint\", \"connectivity\",\n",
    "                                             ('works','broken','transient','offline','path_dependent','unstable'))\n",
    "multipoint_conn_pivot"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Normalize numbers to plot against total observations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "multipoint_nego_pivot['succeeded_p'] = multipoint_nego_pivot['succeeded'] / multipoint_nego_pivot['total']\n",
    "multipoint_conn_pivot['broken_p'] = multipoint_conn_pivot['broken'] / (multipoint_conn_pivot['total'] - multipoint_conn_pivot['offline'])\n",
    "multipoint_conn_pivot['pdep_p'] = multipoint_conn_pivot['path_dependent'] / (multipoint_conn_pivot['total'] - multipoint_conn_pivot['offline'])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "And generate a plot (if you're here because you're reading the paper version of this, hi! You might recognize this plot)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAWkAAAD8CAYAAAC1p1UKAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAIABJREFUeJzt3Xl8FfX1+P/XMaBRZKlIXQiaaMOS5SaQGAFFZBMURFEQUCngvlBQKgg/wd1KNxGooFQFiyCUYBGUTyutUPQnKgmgLAoEiBgUQZYUECTL+f5xJ9dLSG4my03uTc7z8biPe2fmPTNnJpfD3PfMnBFVxRhjTGg6raYDMMYYUzpL0sYYE8IsSRtjTAizJG2MMSHMkrQxxoQwS9LGGBPCgpqkRaSXiGwRkSwRGVfC9ItEZIWIrBORL0TkumDGY4wx4UaCdZ20iEQAW4EeQA6wBhisqpv92swE1qnqDBGJA5apanRQAjLGmDAUzCPpNCBLVXeo6glgPnBDsTYKNHI+Nwa+DWI8xhgTduoFcdnNgW/8hnOAy4u1eRJ4X0R+AzQAupe0IBG5B7gHoEGDBimtW7eu8mCNMaY6ZWZm/qCqzcpqF8wk7cZgYLaq/llEOgBzRCRBVQv9G6nqTGAmQGpqqmZkZNRAqMYYU3VE5Gs37YLZ3bEbaOE3HOWM83cn8HcAVV0NRALnBjEmY4wJK8FM0muAWBGJEZHTgUHAkmJtdgHdAESkDd4kvS+IMRljTFgJWpJW1XxgBPAv4Evg76q6SUSeFpG+TrPfAneLyOfAW8AwtbJ8xhjjE9Q+aVVdBiwrNu5xv8+bgSsqu568vDxycnI4fvx4ZRdl6pDIyEiioqKoX79+TYdiTKlq+sRhlcjJyaFhw4ZER0cjIjUdjgkDqsr+/fvJyckhJiampsMxplS14rbw48eP07RpU0vQxjURoWnTpvbry4S8WpGkAUvQptzsO2PCQa1J0sYYUxtZkg4T2dnZzJs3zzeckZHByJEjA86zfv16li37+bztkiVLmDRpUtBiDAXDhg0jPT29psMw1WD6+uklvpc1LtzU6SQdTn+04kk6NTWVqVOnBpyneJLu27cv48adUozQmLAzff10Znw+A+Ck96J/08WnFf8cTup0kq6qP1p2djZt2rTh7rvvJj4+nmuuuYZjx44BsH37dnr16kVKSgqdOnXiq6++8o1v3749iYmJTJgwgbPPPhvwXnUwZswYEhISSExMZMGCBQCMGzeODz/8kOTkZCZPnszKlSvp06cPAJ999hkdOnSgbdu2dOzYkS1btnDixAkef/xxFixYQHJyMgsWLGD27NmMGDHCF3PXrl3xeDx069aNXbt2Ad4j0ZEjR9KxY0cuueSSEo9Kjx49Su/evUlKSiIhIcEXY3R0ND/88APgPdK/+uqrAThy5AjDhw8nMTERj8fDokWLAPjnP/9Ju3btSEpKolu3br5l33HHHaSlpdG2bVveeecdAAoKChgzZgyXXXYZHo+HV155xbe/RowYQatWrejevTt79+71xTlu3Dji4uLweDw88sgjlf47m9BR2r/dcE3EAalqWL1SUlK0uM2bN58yzo2E2QkVmq+4nTt3akREhK5bt05VVQcMGKBz5sxRVdWuXbvq1q1bVVX1k08+0S5duqiqau/evXXevHmqqjpjxgxt0KCBqqqmp6dr9+7dNT8/X/fs2aMtWrTQb7/9VlesWKG9e/f2rdN/ODc3V/Py8lRVdfny5XrTTTepquqsWbP0wQcf9M3jP9ynTx+dPXu2qqq+9tpresMNN6iq6tChQ7V///5aUFCgmzZt0ksvvfSU7U1PT9e77rrLN3zo0CFVVb344ot13759qqq6Zs0a7dy5s6qqjh07VkeNGuVrf+DAAd27d69GRUXpjh07VFV1//79qqo6fvx43747ePCgxsbG6pEjR/SVV17RZ555RlVVjx8/rikpKbpjxw5dtGiRb3/t3r1bGzdurAsXLtQffvhBW7ZsqYWFhb5llaSi3x1TM15a95ImzE6o9OuldS/V9KYokKEucp6r66RF5DQgCbgQOAZsVNW9gecKTf4/kwAS30gE4P6k+3kg+YEKLzcmJobk5GQAUlJSyM7O5siRI3z88ccMGDDA1+6nn34CYPXq1SxevBiAW2+91Xek99FHHzF48GAiIiI477zz6Ny5M2vWrKFRo0aUJjc3l6FDh7Jt2zZEhLy8vDLjXb16NW+//TYAQ4YMYezYsb5pN954I6eddhpxcXF8//33p8ybmJjIb3/7Wx599FH69OlDp06dAq7r3//+N/Pnz/cN/+IXv2Dp0qVcddVVvmuUzznnHADef/99lixZwp/+9CfAe3nlrl27eP/99/niiy98R/a5ubls27aNVatW+fbXhRdeSNeuXQFo3LgxkZGR3HnnnfTp08f3q8OEr+L/dstyf9L9zPh8BhuGbgC8/9aLPoeTgN0dInKpU5g/C5iEt2rdA8C/ReQTERnuJPCw8UDyA2wYusH3xyr6XJkEDXDGGWf4PkdERJCfn09hYSFNmjRh/fr1vteXX35ZqfWUZOLEiXTp0oWNGzeydOnSSl/7678tWsJd+i1btmTt2rW+rpqnn34agHr16lFY6C1gWNEYVJVFixb59teuXbto06YNqsq0adN843fu3Mk111xT6nLq1avHZ599Rv/+/Xn33Xfp1atXheIxoaP4v13gpH/HxcdV9t90qCgrwT4LvAlcqqo9VfV2Ve2vqh6gL95C/UOCHWS4atSoETExMSxcuBDwJqDPP/8cgPbt2/v6Zv2PMjt16sSCBQsoKChg3759rFq1irS0NBo2bMjhw4dLXE9ubi7NmzcHYPbs2b7xgebp2LGjb71z584t82jY37fffstZZ53F7bffzpgxY1i7di3g7ZPOzMwE8G0bQI8ePXjppZd8wwcPHqR9+/asWrWKnTt3AnDgwAEAevbsybRp03z/Oaxbt843fsaMGb5fCVu3buXo0aNcddVVvv313XffsWLFCsDbD56bm8t1113H5MmTffvd1B73J91f4ntZ48JNwCStqoNVdZWWcDilqntV9UVVfSN44QVXdfzR5s6dy2uvvUZSUhLx8fG+E2EvvvgiL7zwAh6Ph6ysLBo3bgxAv3798Hg8JCUl0bVrV/7whz9w/vnn4/F4iIiIICkpicmTJ5+0jrFjxzJ+/Hjatm1Lfn6+b3yXLl3YvHmz78Shv2nTpjFr1iw8Hg9z5sxhypQprrdpw4YNpKWlkZyczFNPPcWECRMAeOKJJxg1ahSpqalERET42k+YMIGDBw+SkJBAUlISK1asoFmzZsycOZObbrqJpKQkBg4cCHh/FeTl5eHxeIiPj2fixIkA3HXXXcTFxdGuXTsSEhK49957yc/Pp1+/fsTGxhIXF8evf/1rOnToAMDhw4fp06cPHo+HK6+8khdeeMH19pnQ59896f9e9G+6+LTin8OJq2ccisgA4J+qelhEJgJtgWdVdW2wAyyupKL/X375JW3atKnuUCrlxx9/5Mwzz0REmD9/Pm+99ZYvgZvqE47fHVM7iEimqqaW1c5tgaWJqrpQRK7EW//5j8AMTn0clnEpMzOTESNGoKo0adKE119/vaZDMsaEILdJusB57w3MVNX3ROTZIMVUJ3Tq1Mn6SY0xZXJ7ZcZuEXkFGAgsE5EzyjFvtXDTbWOMP/vOmHDgNtHegvcJKz1V9RBwDjAmaFGVU2RkJPv377d/dMY1depJR0ZG1nQoxgTkqrtDVX8UkXeA80TkImf0V8ELq3yioqLIyclh3z57PKJxr+jJLKbiimplhOuVE+HA7R2HvwGeAL4HCp3RCniCFFe51K9f356uYUw1mr5+Og8kP+C7A9CSdPC47e4YBbRS1XhVTXReIZGgjTHVr1YWMgpRbq/u+AbIDWYgxpjQ51/et6jujf/nytbAMadym6R3ACtF5D3gp6KRqmq3cRlTRwQqcBSOhYvChdvujl3AcuB0oKHfyxhTRxQdIZdU1MgEj9urO54CEJGzneEjwQzKGBM6SivvO3399LAtWhRO3NbuSADm4L0+GuAH4NequqmM+XoBU4AI4FVVnVRs+mSgizN4FvBLVW0SaJkl1e4wxlSPoprMRVd3mIqr6todM4HRqrrCWfjVwF+BjgECiABeAnoAOcAaEVmiqpuL2qjqw37tf4O3cJMxJsRZgq4+bvukGxQlaABVXQk0KGOeNCBLVXeo6glgPnBDgPaDgbdcxmOMqQHWvVH93CbpHSIyUUSindcEvFd8BNIc76V7RXKccacQkYuBGOCDUqbfIyIZIpJhdxUaU3PsCLr6uU3SdwDNgLedVzNnXFUZBKSrakFJE1V1pqqmqmpqs2bNqnC1xhgT2txe3XEQGFnOZe8GWvgNRznjSjIIeLCcyzfGmFovYJIWkRdV9SERWYq3VsdJVLVvgNnXALEiEoM3OQ8Cbi1hHa2BXwCryxO4McbUBWUdSc9x3v9U3gWrar6IjMBb4jQCeF1VN4nI00CGqi5xmg4C5pf0HEVjjKnrAiZpVc10Piar6klPKhWRUcB/y5h/GbCs2LjHiw0/6TZYY4ypa9yeOBxawrhhVRiHMcaYEpTVJz0Ybz9yjIgs8ZvUEDgQzMCMMcaU3Sf9MfAdcC7wZ7/xh4EvghWUMcYYr7L6pL8GvgY6VE84xhhj/LnqkxaR9iKyRkSOiMgJESkQkf8FOzhjjKnr3J44/Ave2hrbgDOBu/AWTzLGGBNEbpM0qpoFRKhqgarOAnoFLyxjjDHgvlTpjyJyOrBeRP6A92Si6wRvjDGmYtwm2iFO2xHAUbw1OW4OVlDGGGO83B5JpwDvqer/gKeCGI8xxhg/bo+krwe2isgcEekjIm6TuzHGmEpwlaRVdTjwK2Ah3qs8tovIq8EMzBhjjPvuDlQ1T0T+D2/J0jOBG/FeimeMMSZI3N7Mcq2IzMZ7nfTNwKvA+UGMyxhjDO6PpIcAfwfuVdWfghiPMcYYP2UmaRGJAC5Q1cXVEI8xxhg/ZXZ3OA+HLRSRxtUQjzHGGD9uuzuOABtEZDnem1kAUNXyPpzWGGNMObhN0m87L2OMMdXIVZJW1TdE5EzgIlXdEuSYjDHGONxegnc9sB74pzOcXOxxWsYYY4LA7W3hTwJpwCEAVV0PXBKkmIwxxjjcJuk8Vc0tNq6wqoMxxhhzMrcnDjeJyK1AhIjEAiPxPqTWGGNMELk9kv4NEA/8BLwF/A94qKyZRKSXiGwRkSwRGVdKm1tEZLOIbBKReW4DN8aYusDt1R0/Ao8Bjzl3IDZQ1eOB5nHavQT0AHKANSKyRFU3+7WJBcYDV6jqQRH5ZQW3wxhjaiW3V3fME5FGItIA2ABsFpExZcyWBmSp6g5VPQHMB24o1uZu4CVVPQigqnvLF74xxtRubrs74pynstwI/B8Qg7foUiDNgW/8hnOccf5aAi1F5P8XkU9EpMSH24rIPSKSISIZ+/btcxmyMcaEP7dJur6I1MebpJeoah7eutKVVQ+IBa7G+zCBv4pIk+KNVHWmqqaqamqzZs2qYLXGGBMe3CbpV4BsoAGwSkQuxnvyMJDdeB9YWyTKGecvByfpq+pOYCvepG2MMQb3j8+aqqrNVfU69foa6FLGbGuAWBGJEZHTgUFA8bsUF+M9ikZEzsXb/bGjPBtgjDG1mdsTh01FZKqIrBWRTBGZAgQsXaqq+cAI4F/Al8DfVXWTiDwtIn2dZv8C9ovIZmAFMEZV91d4a4wxppYR1bK7lp0SpauAN51RtwFXq2r3IMZWotTUVM3IyKju1RpjTJUSkUxVTS2rnds7Di9Q1Wf8hp8VkYEVC80YY4xbbk8cvi8ig0TkNOd1C96uCmOMMUEU8EhaRA7jvdRO8N4GXtTdcRrep7U8EtTojDGmjguYpFW1YXUFYowx5lRu+6Rxrsi4yhlcqarvBickY4wxRdxegjcJGAVsdl6jROT5YAZmvKavn17TIRhjapDbE4fXAT1U9XVVfR3oBfQOXlimyIzPZwDeZG0J25i6x22SBvCvqRHwRhZT9WZ8PsOXsI0xdYfbPunngXUisgLvlR5XASUW8TeVN3399JMScuIbiTUYjTGmJrm64xBARC4ALnMGP1PVPUGLKoC6dMdh8WTt7/6k+3kg+YFqjsgYU1Xc3nEYMEmLSLSqZgeYLkBzVc2pUJQVUJeSNHiPojcM3eA7mt4wdEMNR2SMqQpVdVv4H0XkNOAdIBPYB0QCv8JbBa8b8ATekqMmCO5Pur+mQzDG1KCybmYZICJxeAsq3QGcDxzDW9VuGfBcWc86NJVT1KVhydqYuqnME4equllEngUeAK7Ee5v4GiDdEnT1sf5nY+omt1d3vIH3SSxTneFbgb8BtwQjKGOMMV5uk3SCqsb5Da9wCvUbY4wJIrc3s6wVkfZFAyJyOVB3LrEwxpga4vZIOgX4WER2OcMXAVtEZAOgquoJSnTGGFPHuU3SvYIahTHGmBK5StLO08GNMcZUs/IUWDLGGFPNLEkbY0wIsyRtjDEhzJK0McaEsKAmaRHpJSJbRCRLRE6pPy0iw0Rkn4isd153BTMeY4wJN64fRFteIhIBvAT0wFslb42ILFHV4ncqLlDVEcGKwxhjwlkwj6TTgCxV3aGqJ4D5wA1BXJ8xxtQ6QTuSBpoD3/gN5wCXl9DuZhG5CtgKPKyq3xRvICL3APc4g0dEZIvf5IuAXcXncTQGcqt4WrCWG4rrrO59G277p6LzBtqvgeatTfugJvZtqMUaG2CZP1PVoLyA/sCrfsNDgL8Ua9MUOMP5fC/wQQXWsy/AtJlVPS1Yyw3RdVbrvg3D/VPR5Za6XwPNW8v2QbXv2xCMNeByi17B7O7YDbTwG45yxvmo6n5V/ckZfBVvjZDyOhRg2tIgTAvWckNxndW9b8Nt/1R03kD7NdC8tWkf1MS+DbVYy1ouUI4H0ZaXiNTD24XRDW9yXgPcqqqb/NpcoKrfOZ/7AY+qavuSlhdgPRnq4jlhpvxs3waH7dfgqY37Nmh90qqaLyIjgH8BEcDrqrpJRJ4GMlR1CTBSRPoC+cABYFgFVjWzqmI2p7B9Gxy2X4On1u3boB1JG2OMqTy749AYY0KYJWljjAlhlqSNMSaEWZI2xpgQZknaGGNCmCVpY4wJYZakjTEmhFmSNsaYEGZJ2hhjQpglaWOMCWGWpI0xJoRZkjbGmBBmSdoYY0KYJWljjAlhwXzGYVCce+65Gh0dXdNhGGNMpWRmZv6gqs3Kahd2STo6OpqMjIyaDsMYYypFRL520866O4wxJoRZkjbGmBBmSdoYY0JY2PVJm7ohLy+PnJwcjh8/XtOhGFMpkZGRREVFUb9+/QrNb0nahKScnBwaNmxIdHQ0IlLT4RhTIarK/v37ycnJISYmpkLLsO4OE5KOHz9O06ZNLUGbsCYiNG3atFK/CC1Jm5BlCdrUBpX9HluSNsaYEGZJ2tQqk5dvrekQXMvOzmbevHm+4YyMDEaOHBlwnvXr17Ns2TLf8JIlS5g0aVLQYgwFgwcPxuPxMHny5FLbvPzyy/ztb38DYNiwYaSnp1dXeEFnJw5NrTLlP9t4uEfLmg7DlaIkfeuttwKQmppKampqwHnWr19PRkYG1113HQB9+/alb9++QY+1puzZs4c1a9aQlZUVsN19991X4XXk5+dTr17opkI7kjamBNnZ2bRp04a7776b+Ph4rrnmGo4dOwbA9u3b6dWrFykpKXTq1ImvvvrKN759+/YkJiYyYcIEzj77bMB7hn/MmDEkJCSQmJjIggULABg3bhwffvghycnJTJ48mZUrV9KnTx8APvvsMzp06EDbtm3p2LEjW7Zs4cSJEzz++OMsWLCA5ORkFixYwOzZsxkxYoQv5q5du+LxeOjWrRu7du0CvEeWI0eOpGPHjlxyySWlHmX+7W9/w+PxkJSUxJAhQwBYunQpl19+OW3btqV79+58//33ADz55JP86U9/8s2bkJBAdnY2R48epXfv3iQlJZGQkODb1szMTDp37kxKSgo9e/bku+++A2Dq1KnExcXh8XgYNGjQKTFdc8017N69m+TkZD788EP++te/ctlll5GUlMTNN9/Mjz/+WGI8RaKjo/nhhx8A7y+Vq6++2td+yJAhXHHFFQwZMoSCggLGjBnDZZddhsfj4ZVXXinjG1KNVDWsXikpKWpqv82bN7tu+8L7W/TiR9895fXC+1sqvP6dO3dqRESErlu3TlVVBwwYoHPmzFFV1a5du+rWrVtVVfWTTz7RLl26qKpq7969dd68eaqqOmPGDG3QoIGqqqanp2v37t01Pz9f9+zZoy1atNBvv/1WV6xYob179/at0384NzdX8/LyVFV1+fLletNNN6mq6qxZs/TBBx/0zeM/3KdPH509e7aqqr722mt6ww03qKrq0KFDtX///lpQUKCbNm3SSy+99JTt3bhxo8bGxuq+fftUVXX//v2qqnrgwAEtLCxUVdW//vWvOnr0aFVVfeKJJ/SPf/yjb/74+HjduXOnpqen61133eUbf+jQIT1x4oR26NBB9+7dq6qq8+fP1+HDh6uq6gUXXKDHjx9XVdWDBw+W+HeIj4/3Df/www++z4899phOnTr1lHiGDh2qCxcuVFXViy++2LdNa9as0c6dO/vat2vXTn/88UdVVX3llVf0mWeeUVXV48ePa0pKiu7YseOUeCqqpO8zkKEucl7oHuMb49LDPVr6ujiix71H9qTeVbLcmJgYkpOTAUhJSSE7O5sjR47w8ccfM2DAAF+7n376CYDVq1ezePFiAG699VYeeeQRAD766CMGDx5MREQE5513Hp07d2bNmjU0atSo1HXn5uYydOhQtm3bhoiQl5dXZryrV6/m7bffBmDIkCGMHTvWN+3GG2/ktNNOIy4uznc07O+DDz5gwIABnHvuuQCcc845gPd69YEDB/Ldd99x4sSJMq/1TUxM5Le//S2PPvooffr0oVOnTmzcuJGNGzfSo0cPAAoKCrjgggsA8Hg83Hbbbdx4443ceOONZW7jxo0bmTBhAocOHeLIkSP07NmzzHlK07dvX84880wA3n//fb744gvfr4zc3Fy2bdtW4Wubq5IlaWNKccYZZ/g+R0REcOzYMQoLC2nSpAnr168P6ronTpxIly5d+Mc//kF2drbvZ3pF+W+L9yDOnd/85jeMHj2avn37snLlSp588kkA6tWrR2Fhoa9d0XXALVu2ZO3atSxbtowJEybQrVs3+vXrR3x8PKtXrz5l+e+99x6rVq1i6dKlPPfcc2zYsCFg//CwYcNYvHgxSUlJzJ49m5UrVwaM3z/O4tcqN2jQwPdZVZk2bVqlkn6wWJ+0qVVGdYsN6vIbNWpETEwMCxcuBLz/uD///HMA2rdvz6JFiwCYP3++b55OnTqxYMECCgoK2LdvH6tWrSItLY2GDRty+PDhEteTm5tL8+bNAZg9e7ZvfKB5Onbs6Fvv3Llz6dSpk+vt6tq1KwsXLmT//v0AHDhw4JQ43njjDV/76Oho1q5dC8DatWvZuXMnAN9++y1nnXUWt99+O2PGjGHt2rW0atWKffv2+ZJ0Xl4emzZtorCwkG+++YYuXbrw+9//ntzcXI4cORIwzsOHD3PBBReQl5fH3Llzy9yu6OhoMjMzAXx/m5L07NmTGTNm+H6xbN26laNHj5a5/OrgOkmLSC8R2SIiWSIyroTpZ4jIAmf6pyIS7TdtvDN+i4j0LDZfhIisE5F3K7MhxgDVcmXH3Llzee2110hKSiI+Pp533nkHgBdffJEXXngBj8dDVlYWjRs3BqBfv36+E3Jdu3blD3/4A+effz4ej4eIiAiSkpJOubxs7NixjB8/nrZt25Kfn+8b36VLFzZv3uw7cehv2rRpzJo1C4/Hw5w5c5gyZYrrbYqPj+exxx6jc+fOJCUlMXr0aMB7gm3AgAGkpKT4ukIAbr75Zg4cOEB8fDx/+ctfaNnSu983bNhAWloaycnJPPXUU0yYMIHTTz+d9PR0Hn30UZKSkkhOTubjjz+moKCA22+/ncTERNq2bcvIkSNp0qRJwDifeeYZLr/8cq644gpat25d5nY98cQTjBo1itTUVCIiIkptd9dddxEXF0e7du1ISEjg3nvvPWm/1yg3HddABLAduAQ4HfgciCvW5gHgZefzIGCB8znOaX8GEOMsJ8JvvtHAPOBdN7HUtROH/ie/KnMiLNyU58RhqDh69KjvJNtbb72lffv2reGITKiozIlDt0fSaUCWqu5Q1RPAfOCGYm1uAIp+D6UD3cR7P+QNwHxV/UlVdwJZzvIQkSigN/CqyzjqnCn/2QZ4b9Io+mxCU2ZmJsnJyXg8HqZPn86f//znmg7J1AJuTxw2B77xG84BLi+tjarmi0gu0NQZ/0mxeZs7n18ExgINA61cRO4B7gG46KKLXIZcu1iCDn2dOnXy9U8bU1Vq7OoOEekD7FXVTBG5OlBbVZ0JzARITU11f2o6TBU/ao4e994pn0d1iw2bO+uMMRXntrtjN9DCbzjKGVdiGxGpBzQG9geY9wqgr4hk4+0+6Soib5Yz/lrp4R4tyZ7Uu9QrFSxBG1N3uE3Sa4BYEYkRkdPxnhhcUqzNEmCo87k/8IHTOb4EGORc/REDxAKfqep4VY1S1WhneR+o6u2V3J5apSgR+9+ckT2ptyVoY+oQV90dTh/zCOBfeK/0eF1VN4nI03jPUC4BXgPmiEgWcABv4sVp93dgM5APPKiqBUHYllrJ/2g62NcAG2NCj+vrpFV1maq2VNVLVfU5Z9zjToJGVY+r6gBV/ZWqpqnqDr95n3Pma6Wq/1fCsleqap+q2KDapuio2bo4XFrxfE1HEBQVKWvqX75z9uzZfPvtt0GNceXKlXz88ce+4YqUDC2tUFJ18C9wVRG/+93vqjCan9kdh2HCErRL/62dtZWLJ+nU1FSmTp0acJ777ruPX//610DNJOm6xpK0MdWspNKd5S0HunLlSq6++mr69+9P69atue2223y1M0or35mVlUX37t1JSkqiXbt2bN++vdSypoWFhURHR3Po0CFf3LGxsXz//fe+o9L09HQyMjK47bbbSE5O5r333jsIwjDrAAAPxklEQVSpmNHy5cvp16/fKdsfHR3N2LFjSUxMJC0tzVfTuaTypdnZ2bz88stMnjzZV1YUYNWqVWWWSH3uuedo2bIlV155JVu2bPGNL60k7LBhw7jvvvtITU2lZcuWvPuu92bl0sqNBvob/POf/6R169a0a9fOV5wK4OjRo9xxxx2kpaXRtm1b312ls2fP5qabbqJXr17Exsb6iliNGzeOY8eOkZyczG233Rbwe1Vubu54CaVXXbvjsK4q1x2HH/xO9YlGp74++F2F119a6c7ylgNdsWKFNmrUSL/55hstKCjQ9u3b64cffhiwfGdaWpq+/fbbqqp67NgxPXr0aMCypiNHjtTXX39dVb2lU7t166aqJ5fv7Ny5s65Zs0ZVVQsLC7VVq1a+dQ8ePFiXLFlyyj64+OKL9dlnn1VV1TfeeMO3PrflS92USM3IyNCEhAQ9evSo5ubm6qWXXupbRmklYYcOHao9e/bUgoIC3bp1qzZv3lyPHTtWarnR0v4Gx44d06ioKN26dasWFhbqgAEDfNs4fvx4X2nagwcPamxsrB45ckRnzZqlMTExeujQIT127JhedNFFumvXLlVVX2naklipUlO3dRnvfQE82RiezK30Iksr3VmRcqBpaWlERUUBkJycTHZ2Nk2aNCmxfOfhw4fZvXu378g2MjKyzFgHDhzI008/zfDhw5k/fz4DBw4M2F5EGDJkCG+++SbDhw9n9erVvr7r4gYPHux7f/jhh4HylS8tq0Tqhx9+SL9+/TjrrLMAfE+ZCVQSFuCWW27htNNOIzY2lksuuYSvvvqq1HKjp59+eol/g7PPPpuYmBhiY70n5G+//XZmzpwJeEuXLlmyxNc/fvz4cd+vpm7duvnqssTFxfH111/TooX/VcZVy5K0MVWktHKgxUue5ufno6ollu8srcJdIB06dCArK4t9+/axePFiJkyYUOY8w4cP5/rrrycyMpIBAwaUWh7U/0nXRZ9LK19akoqWSC2rJGzxJ3CLSKnlRleuXFni3yAQVWXRokW0atXqpPGffvppuZdVWdYnbWqXzqcUaKyQ0kp3VqYcqL/Sync2bNiQqKgo38MDfvrpJ3788ceAJUpFhH79+jF69GjatGlD06ZNT2lTfP4LL7yQCy+8kGeffZbhw4eXGmdRpb0FCxbQoUMHoPTypYFiLM1VV13F4sWLOXbsGIcPH2bp0qVA4JKwAAsXLqSwsJDt27ezY8cOWrVqVe5yo61btyY7O5vt27cD8NZbb/mm9ezZk2nTpvn+Y1m3bl2Z21K/fn1XD2coL0vSpnYp6vaopNJKd1amHKi/0sp3AsyZM4epU6fi8Xjo2LEje/bsCVjWFLxdHm+++WapXR1FJ9uSk5N9z2q87bbbaNGiBW3atCk1zoMHD+LxeJgyZYpvvaWVL73++uv5xz/+cdKJw7K0a9eOgQMHkpSUxLXXXstll13mm1ZaSVjw1vBJS0vj2muv5eWXXyYyMrLc5UYjIyOZOXMmvXv3pl27dvzyl7/0TZs4cSJ5eXl4PB7i4+OZOHFimdtyzz33+J40U5WkPD9BQkFqaqpmZGTUdBgmyL788suAycNU3ogRI2jbti133nlnidOjo6PJyMg4KRGHgmHDhtGnTx/69+9f06G4VtL3WUQyVTXw4+GxPmlj6qSUlBQaNGhg5VTDgCVpY+qgokdKBZKdnR38QCrA/3FidYH1SZuQFW5dccaUpLLfY0vSJiRFRkayf/9+S9QmrKkq+/fvd3W9e2msu8OEpKioKHJycti3b19Nh2JMpURGRvpupKkIS9ImJNWvXz/gnWzG1BXW3REuamkJTmNMYJakw0UtLcFpjAnMkrQxxoQw65MOZSueP/kI+klv5S06j6uy25+NMaHNknQoC0IJTmNMeLHuDmOMCWGWpMNFFZXgNMaEF0vS4cL6oI2pkyxJG2NMCLMkbYwxIcyStDHGhDBL0sYYE8IsSRtjTAizJG2MMSHMkrQxxoQwS9LGGBPCXCdpEeklIltEJEtETrn9TUTOEJEFzvRPRSTab9p4Z/wWEenpjGshIitEZLOIbBKRUVWxQcYYU5u4StIiEgG8BFwLxAGDRSSuWLM7gYOq+itgMvB7Z944YBAQD/QCpjvLywd+q6pxQHvgwRKWaYwxdZrbI+k0IEtVd6jqCWA+cEOxNjcAbzif04FuIiLO+Pmq+pOq7gSygDRV/U5V1wKo6mHgS6B55TbHGGNqF7dJujnwjd9wDqcmVF8bVc0HcoGmbuZ1ukbaAp+WtHIRuUdEMkQko04/mNQeoWVMnVPjJw5F5GxgEfCQqv6vpDaqOlNVU1U1tVmzZtUbYCixR2gZU+e4TdK7gRZ+w1HOuBLbiEg9oDGwP9C8IlIfb4Keq6pvlzd4Y4yp7dwm6TVArIjEiMjpeE8ELinWZgkw1PncH/hAVdUZP8i5+iMGiAU+c/qrXwO+VNUXKrshtdaK552nsjiPzir6bF0fxtQJrh6fpar5IjIC+BcQAbyuqptE5GkgQ1WX4E24c0QkCziAN5HjtPs7sBnvFR0PqmqBiFwJDAE2iMh6Z1X/n6ouq8oNDHv2CC1jTjF5+VYe7tGypsOoFq6fcegkz2XFxj3u9/k4MKCUeZ8Dnis27iNAyhOsMcYATPnPNoA6kahr/MShKQd7hJYxPkWJevLyrb73os8lCTQtlFmSDnX+fc/2CC1Th01evpXoce8RPe4937joce/5kvWU/2wrMXEXKZoWbixJhzq77M4YwNu1MapbbInTih8l+yfucCfeCzDCR2pqqmZkZNR0GNXHThYacwr/o+kiD9VL58X8/r7hUd1iS03So7rF1nh/tohkqmpqWe3sSDoU2WV3xgRUdESdPam37/2heiffalFSgs6e1JvsSb1rPEGXh+urO0w1ssvujAkoUJLNntSb6HHvnfQOJR99hwM7kjbGhKWHe7SEFc+THXmr71dn0eeH6qWf0r60/uxQZ0fSoc4uuzOmdKX86lTnRKJ/Yg6nLg5/diQd6uyyO2PKrSghh2ti9mdJ2hhTO9TSX52WpI0xtUMt/dVpSdoYY0KYJWljjAlhlqSNMSaEWZI2xoSnOnIHriVpY0z4WfF8nSk+ZknaGBN+6kiCBkvSxphwUlR8rEgdKD5mSdoYEx5K6+LoPO7na6RrYbK2JG2MCQ9dxntrc/hXhXwy9+SbWGphN4glaWNMeKqlt4EXZ1XwjDHhp3gXh/8RdFGftX+bMGZH0saYyqmJfuDiyde/G6Tovcv4WtFHbUnaGFM5Nd0PHGj9NR1bFbAkbYxxL5SPTIti8382qP/4MGVPCzfGuFf09BM3l8MFU6D1Q83G5pLbp4XbiUNjTMX4+oBr4GHJZT2s+b+TnH5qv2lhekRtSdoYE1hpV0+EspIuz/vvpJA6knbL+qSNMYEVv4nE/+qJ/06q+euVS1p/UTKu6diqgB1JG2PcKe3EXE0r6+i4eK0PCLn+6UDsxKExxrXVrz1Ch0uahsWJuVPURN95AG5PHLru7hCRXiKyRUSyROSU3xAicoaILHCmfyoi0X7Txjvjt4hIT7fLNMaElsHbuvidsPMmvOjj806toWGqjKskLSIRwEvAtUAcMFhE4oo1uxM4qKq/AiYDv3fmjQMGAfFAL2C6iES4XKYxJgS9mH9TTYdQfmHaP+2qu0NEOgBPqmpPZ3g8gKo+79fmX06b1SJSD9gDNAPG+bctaufMFnCZJbHuDmOq1+TlW5nyn20lTnuoXjov5vf3DY/qFsvDPVpWV2hhraqvk24OfOM3nANcXlobVc0XkVygqTP+k2LzNnc+l7VMAETkHuAeZ/CIiGzxm3wRsKuUuBsDpXVCVXRasJYbiuus7n0bbvunovMG2q+B5q3xfXD6+b9KObEnK7Po/dHzf5UCH3FiT1YmwOjfw+jKr7My84ZTPogNsMyfqWqZL6A/8Krf8BDgL8XabASi/Ia3A+cCfwFu9xv/mrO8MpfpMrZ9AabNrOppwVpuiK6zWvdtGO6fii631P0aaN5atg+qfd+GYKwBl1v0cnvicDfQwm84yhlXYhunu6MxsD/AvG6W6cahANOWBmFasJYbiuus7n0bbvunovMG2q+B5q1N+6Am9m2oxVrWcgH3fdL1gK1AN7yJdA1wq6pu8mvzIJCoqveJyCDgJlW9RUTigXlAGnAh8B+8h/lS1jJdbYBIhrro1zHlZ/s2OGy/Bk9t3Leu+qTV28c8AvgXEAG8rqqbRORpIENVl+DtxpgjIlnAAbxXdOC0+zuwGcgHHlTVAoCSllmBbZhZgXmMO7Zvg8P2a/DUun0bdjezGGNMXWK1O4wxJoRZkjbGmBAWcklaRFqIyAoR2Swim0RklDP+HBFZLiLbnPdfOONbi8hqEflJRB4pYXkRIrJORN6t7m0JNVW5b0UkW0Q2iMh6EanTdxdV8X5tIiLpIvKViHzp3EhWZ1XVvhWRVs53tej1PxF5qKa2qzxCrk9aRC4ALlDVtSLSEMgEbgSGAQdUdZJT5+MXqvqoiPwSuNhpc1BV/1RseaOBVKCRqvapzm0JNVW5b0UkG0hV1R+qeztCTRXv1zeAD1X1VRE5HThLVcu6ZK/Wqup84CwzAu8VZZer6tfVtS0VFXJH0qr6naqudT4fBr7Ee4fiDcAbTrM38P4RUNW9qroGyCu+LBGJAnoDr1ZD6CGvKvet+VlV7VcRaQxchfdKKVT1RF1O0BC072w3YHs4JGgIwSTtT7yV9NoCnwLnqep3zqQ9wHkuFvEiMBYoDEZ84awK9q0C74tIpnPbvqHS+zUG2AfMcrroXhWRBsGKNdxUwXe2yCDgrSoNLohCNkmLyNnAIuAhVf2f/zT19tEE7KcRkT7AXlXNDF6U4amy+9Zxpaq2w1vF8EERuarqIw0vVbBf6wHtgBmq2hY4ilOgrK6rou8sThdSX2BhlQcZJCGZpEWkPt4/yFxVfdsZ/b3TP1XUT7W3jMVcAfR1+k7nA11F5M0ghRw2qmjfoqq7nfe9wD/w3lFaZ1XRfs0BclT1U2c4HW/SrtOq6jvruBZYq6rfV32kwRFySVpEBG+f3Jeq+oLfpCXAUOfzUOCdQMtR1fGqGqWq0Xh/3nygqrcHIeSwUVX7VkQaOCdxcH6OX4O3wFadVIXf2T3ANyLSyhnVDe+dunVWVe1bP4MJo64OwF0VvOp8AVfi/enyBbDeeV2Ht+zpf4BtwL+Bc5z25+M9Avkf3uIqOXiv5PBf5tXAuzW9bTX9qqp9C1wCfO68NgGP1fS21Yb96kxLBjKcZS3Ge9VCjW9jLdm3DfAWfWtc09tVnlfIXYJnjDHmZyHX3WGMMeZnlqSNMSaEWZI2xpgQZknaGGNCmCVpY4wJYZakjTEmhFmSNsaYEPb/AH6TzqcF2ERuAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x10fab4940>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "f, (ax1, ax2) = plt.subplots(2,1,sharex=True, figsize=(5.5,4))\n",
    "ax1.plot(multipoint_nego_pivot.loc[:,[\"succeeded_p\"]],\"+\",color=\"tab:green\",label=\"negotiation succeeds\")\n",
    "ax1.set_ylim(0.5,0.8)\n",
    "ax1.legend()\n",
    "ax1.set_ylabel(\"p(observations)\")\n",
    "\n",
    "ax2.plot(multipoint_conn_pivot.loc[:,[\"broken_p\"]],\"+\",label=\"negotiation causes failure\")\n",
    "ax2.plot(multipoint_conn_pivot.loc[:,[\"pdep_p\"]],\"+\",label=\"connectivity path dependent\")\n",
    "\n",
    "ax2.set_ylim(0,0.005)\n",
    "ax2.set_xlim(pd.to_datetime(\"2013-12-15\"),pd.to_datetime(\"2017-07-01\"))\n",
    "ax2.legend()\n",
    "\n",
    "ax2.xaxis.set_major_locator(mdates.YearLocator())\n",
    "ax2.xaxis.set_minor_locator(mdates.MonthLocator())\n",
    "\n",
    "f.savefig(\"ecnresult.pdf\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Generate counts of raw and derived observations in the database \n",
    "\n",
    "The following queries count first-stage as well as derived observations per year; we'll sum the counts to get total observation counts. We do this for the appropriate bit of the submitted paper."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "# q_all_count = c.submit_query(\n",
    "#                     ptoclient.PTOQuerySpec().time(\"2014-01-01\",\"2018-01-01\")\n",
    "#                                      .condition(\"ecn.negotiation.*\")\n",
    "#                                      .condition(\"ecn.connectivity.*\")\n",
    "#                                      .condition(\"ecn.ipmark.*\")\n",
    "#                                      .time_series_year())\n",
    "q_all_count = c.retrieve_query('https://v3.pto.mami-project.eu/query/80a720a924566b9d77e0cab57aac276eefff645fa03af386515ca9814664aa84')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "448598576"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "q_all_count.results()[\"count\"].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "q_derived_count = c.submit_query(\n",
    "                    ptoclient.PTOQuerySpec().time(\"2014-01-01\",\"2018-01-01\")\n",
    "                                     .condition(\"ecn.stable.*\")\n",
    "                                     .condition(\"ecn.multipoint.*\")\n",
    "                                     .time_series_year())\n",
    "#q_derived_count = c.retrieve_query('https://v3.pto.mami-project.eu/query/80a720a924566b9d77e0cab57aac276eefff645fa03af386515ca9814664aa84')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "102323404"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "q_derived_count.results()[\"count\"].sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Other example queries"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "List all observations where ECN connectivity failure appears to be path-dependent"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'__completed': '2018-05-25T16:10:35+02:00',\n",
       " '__created': '2018-05-25T16:03:31+02:00',\n",
       " '__encoded': 'time_start=2014-01-01T00%3A00%3A00Z&time_end=2018-01-01T00%3A00%3A00Z&condition=ecn.multipoint.connectivity.path_dependent',\n",
       " '__executed': '2018-05-25T16:03:31+02:00',\n",
       " '__link': 'https://v3.pto.mami-project.eu/query/8da2b65bd4f7cd8d56d90ddfcd85297e8aac54fcd0e04f0a0fa51b2937b3dc62',\n",
       " '__modified': '2018-05-25T16:10:35+02:00',\n",
       " '__result': 'https://v3.pto.mami-project.eu/query/8da2b65bd4f7cd8d56d90ddfcd85297e8aac54fcd0e04f0a0fa51b2937b3dc62/result',\n",
       " '__state': 'complete'}"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# q_all_pathdep = c.submit_query(ptoclient.PTOQuerySpec()\n",
    "#                                .time(\"2014-01-01\",\"2018-01-01\")\n",
    "#                                .condition(\"ecn.multipoint.connectivity.path_dependent\"))\n",
    "q_all_pathdep = c.retrieve_query('https://v3.pto.mami-project.eu/query/8da2b65bd4f7cd8d56d90ddfcd85297e8aac54fcd0e04f0a0fa51b2937b3dc62')\n",
    "q_all_pathdep.metadata()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>condition</th>\n",
       "      <th>path</th>\n",
       "      <th>set_id</th>\n",
       "      <th>time_end</th>\n",
       "      <th>time_start</th>\n",
       "      <th>value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 178.33.224.30</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-28T21:36:57Z</td>\n",
       "      <td>2014-08-28T21:28:30Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 85.25.27.196</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-28T22:01:21Z</td>\n",
       "      <td>2014-08-28T21:53:26Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 85.25.138.49</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-28T23:52:19Z</td>\n",
       "      <td>2014-08-28T23:47:04Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 143.248.5.153</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-28T21:50:36Z</td>\n",
       "      <td>2014-08-28T21:42:22Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 186.202.122.75</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-28T22:40:09Z</td>\n",
       "      <td>2014-08-28T22:34:31Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 85.25.197.237</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-28T22:27:10Z</td>\n",
       "      <td>2014-08-28T22:20:16Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 164.109.105.205</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-28T21:50:26Z</td>\n",
       "      <td>2014-08-28T21:42:13Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 85.25.200.72</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-28T23:56:48Z</td>\n",
       "      <td>2014-08-28T23:51:36Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 190.192.160.69</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-28T23:50:10Z</td>\n",
       "      <td>2014-08-28T23:45:00Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 62.75.196.60</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-28T21:36:07Z</td>\n",
       "      <td>2014-08-28T21:27:42Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 213.174.57.162</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-29T00:32:49Z</td>\n",
       "      <td>2014-08-29T00:27:17Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 213.174.57.202</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-28T23:55:26Z</td>\n",
       "      <td>2014-08-28T23:50:10Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 122.228.248.89</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-28T22:16:10Z</td>\n",
       "      <td>2014-08-28T22:08:46Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 188.138.17.111</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-28T21:49:42Z</td>\n",
       "      <td>2014-08-28T21:41:27Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 173.255.198.164</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-28T23:18:41Z</td>\n",
       "      <td>2014-08-28T23:13:53Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 83.223.8.253</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-28T23:01:36Z</td>\n",
       "      <td>2014-08-28T22:56:46Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 85.25.243.153</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-28T22:50:08Z</td>\n",
       "      <td>2014-08-28T22:44:55Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 200.80.170.77</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-28T22:40:18Z</td>\n",
       "      <td>2014-08-28T22:34:39Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 62.75.236.87</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-28T22:21:31Z</td>\n",
       "      <td>2014-08-28T22:14:20Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 188.138.38.59</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-28T21:52:48Z</td>\n",
       "      <td>2014-08-28T21:44:43Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 85.25.99.100</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-28T23:10:42Z</td>\n",
       "      <td>2014-08-28T23:06:02Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 64.17.153.89</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-28T23:07:49Z</td>\n",
       "      <td>2014-08-28T23:03:11Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 115.47.43.31</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-28T22:30:09Z</td>\n",
       "      <td>2014-08-28T22:23:30Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 217.172.186.27</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-28T23:05:18Z</td>\n",
       "      <td>2014-08-28T23:00:32Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 2607:f298:5:112b::f08:197c</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-28T23:37:25Z</td>\n",
       "      <td>2014-08-28T23:32:23Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 200.58.109.28</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-29T00:21:37Z</td>\n",
       "      <td>2014-08-29T00:16:12Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 121.199.48.107</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-28T22:33:46Z</td>\n",
       "      <td>2014-08-28T22:27:23Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 217.172.181.198</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-29T00:08:48Z</td>\n",
       "      <td>2014-08-29T00:03:33Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 69.162.81.66</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-28T22:26:17Z</td>\n",
       "      <td>2014-08-28T22:19:22Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 85.25.95.55</td>\n",
       "      <td>103</td>\n",
       "      <td>2014-08-28T22:15:06Z</td>\n",
       "      <td>2014-08-28T22:07:39Z</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8433</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 46.30.41.193</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-16T22:21:33Z</td>\n",
       "      <td>2017-01-16T22:17:19Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8434</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 183.61.244.206</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-16T02:40:31Z</td>\n",
       "      <td>2017-01-16T02:34:21Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8435</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 41.110.2.23</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-17T05:54:24Z</td>\n",
       "      <td>2017-01-17T05:39:33Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8436</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 23.224.138.10</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-16T08:02:54Z</td>\n",
       "      <td>2017-01-16T07:57:00Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8437</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 166.66.86.13</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-16T02:36:50Z</td>\n",
       "      <td>2017-01-16T02:36:12Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8438</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 209.160.74.9</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-17T06:54:26Z</td>\n",
       "      <td>2017-01-17T06:48:09Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8439</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 180.97.250.153</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-17T05:25:55Z</td>\n",
       "      <td>2017-01-17T05:15:32Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8440</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 108.167.183.248</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-16T09:58:25Z</td>\n",
       "      <td>2017-01-16T09:51:28Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8441</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 31.220.3.10</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-17T07:28:54Z</td>\n",
       "      <td>2017-01-17T07:24:08Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8442</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 69.39.237.38</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-17T12:43:58Z</td>\n",
       "      <td>2017-01-17T12:33:56Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8443</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 202.43.162.2</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-17T17:54:49Z</td>\n",
       "      <td>2017-01-17T17:43:23Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8444</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 87.107.133.43</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-16T17:54:11Z</td>\n",
       "      <td>2017-01-16T17:49:12Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8445</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 178.248.237.48</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-17T12:04:07Z</td>\n",
       "      <td>2017-01-17T11:55:47Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8446</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 212.143.86.204</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-17T02:15:48Z</td>\n",
       "      <td>2017-01-17T01:52:12Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8447</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 52.222.232.88</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-16T19:08:27Z</td>\n",
       "      <td>2017-01-16T19:05:32Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8448</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 121.127.246.208</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-16T14:59:22Z</td>\n",
       "      <td>2017-01-16T14:52:30Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8449</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 123.138.67.49</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-16T16:12:56Z</td>\n",
       "      <td>2017-01-16T16:04:44Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8450</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 31.220.20.199</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-16T02:21:20Z</td>\n",
       "      <td>2017-01-16T02:10:13Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8451</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 72.29.120.18</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-16T06:15:43Z</td>\n",
       "      <td>2017-01-16T06:07:51Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8452</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 45.35.36.165</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-16T21:52:37Z</td>\n",
       "      <td>2017-01-16T21:44:51Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8453</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 185.34.216.156</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-17T16:34:32Z</td>\n",
       "      <td>2017-01-17T16:26:01Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8454</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 113.200.91.196</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-17T09:23:59Z</td>\n",
       "      <td>2017-01-17T09:20:14Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8455</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 37.61.237.164</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-17T07:45:57Z</td>\n",
       "      <td>2017-01-17T07:35:59Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8456</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 2403:5400:580c::6</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-16T19:03:25Z</td>\n",
       "      <td>2017-01-16T18:53:26Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8457</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 188.10.254.103</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-16T03:01:03Z</td>\n",
       "      <td>2017-01-16T02:55:10Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8458</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 60.190.222.229</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-16T06:35:20Z</td>\n",
       "      <td>2017-01-16T06:29:52Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8459</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 115.236.59.86</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-16T06:44:39Z</td>\n",
       "      <td>2017-01-16T06:43:04Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8460</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 139.224.60.169</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-17T14:13:01Z</td>\n",
       "      <td>2017-01-17T14:01:04Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8461</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 190.102.128.50</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-17T11:56:16Z</td>\n",
       "      <td>2017-01-17T11:22:45Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8462</th>\n",
       "      <td>ecn.multipoint.connectivity.path_dependent</td>\n",
       "      <td>* 62.156.172.70</td>\n",
       "      <td>111</td>\n",
       "      <td>2017-01-17T09:49:15Z</td>\n",
       "      <td>2017-01-17T09:42:20Z</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8463 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       condition  \\\n",
       "0     ecn.multipoint.connectivity.path_dependent   \n",
       "1     ecn.multipoint.connectivity.path_dependent   \n",
       "2     ecn.multipoint.connectivity.path_dependent   \n",
       "3     ecn.multipoint.connectivity.path_dependent   \n",
       "4     ecn.multipoint.connectivity.path_dependent   \n",
       "5     ecn.multipoint.connectivity.path_dependent   \n",
       "6     ecn.multipoint.connectivity.path_dependent   \n",
       "7     ecn.multipoint.connectivity.path_dependent   \n",
       "8     ecn.multipoint.connectivity.path_dependent   \n",
       "9     ecn.multipoint.connectivity.path_dependent   \n",
       "10    ecn.multipoint.connectivity.path_dependent   \n",
       "11    ecn.multipoint.connectivity.path_dependent   \n",
       "12    ecn.multipoint.connectivity.path_dependent   \n",
       "13    ecn.multipoint.connectivity.path_dependent   \n",
       "14    ecn.multipoint.connectivity.path_dependent   \n",
       "15    ecn.multipoint.connectivity.path_dependent   \n",
       "16    ecn.multipoint.connectivity.path_dependent   \n",
       "17    ecn.multipoint.connectivity.path_dependent   \n",
       "18    ecn.multipoint.connectivity.path_dependent   \n",
       "19    ecn.multipoint.connectivity.path_dependent   \n",
       "20    ecn.multipoint.connectivity.path_dependent   \n",
       "21    ecn.multipoint.connectivity.path_dependent   \n",
       "22    ecn.multipoint.connectivity.path_dependent   \n",
       "23    ecn.multipoint.connectivity.path_dependent   \n",
       "24    ecn.multipoint.connectivity.path_dependent   \n",
       "25    ecn.multipoint.connectivity.path_dependent   \n",
       "26    ecn.multipoint.connectivity.path_dependent   \n",
       "27    ecn.multipoint.connectivity.path_dependent   \n",
       "28    ecn.multipoint.connectivity.path_dependent   \n",
       "29    ecn.multipoint.connectivity.path_dependent   \n",
       "...                                          ...   \n",
       "8433  ecn.multipoint.connectivity.path_dependent   \n",
       "8434  ecn.multipoint.connectivity.path_dependent   \n",
       "8435  ecn.multipoint.connectivity.path_dependent   \n",
       "8436  ecn.multipoint.connectivity.path_dependent   \n",
       "8437  ecn.multipoint.connectivity.path_dependent   \n",
       "8438  ecn.multipoint.connectivity.path_dependent   \n",
       "8439  ecn.multipoint.connectivity.path_dependent   \n",
       "8440  ecn.multipoint.connectivity.path_dependent   \n",
       "8441  ecn.multipoint.connectivity.path_dependent   \n",
       "8442  ecn.multipoint.connectivity.path_dependent   \n",
       "8443  ecn.multipoint.connectivity.path_dependent   \n",
       "8444  ecn.multipoint.connectivity.path_dependent   \n",
       "8445  ecn.multipoint.connectivity.path_dependent   \n",
       "8446  ecn.multipoint.connectivity.path_dependent   \n",
       "8447  ecn.multipoint.connectivity.path_dependent   \n",
       "8448  ecn.multipoint.connectivity.path_dependent   \n",
       "8449  ecn.multipoint.connectivity.path_dependent   \n",
       "8450  ecn.multipoint.connectivity.path_dependent   \n",
       "8451  ecn.multipoint.connectivity.path_dependent   \n",
       "8452  ecn.multipoint.connectivity.path_dependent   \n",
       "8453  ecn.multipoint.connectivity.path_dependent   \n",
       "8454  ecn.multipoint.connectivity.path_dependent   \n",
       "8455  ecn.multipoint.connectivity.path_dependent   \n",
       "8456  ecn.multipoint.connectivity.path_dependent   \n",
       "8457  ecn.multipoint.connectivity.path_dependent   \n",
       "8458  ecn.multipoint.connectivity.path_dependent   \n",
       "8459  ecn.multipoint.connectivity.path_dependent   \n",
       "8460  ecn.multipoint.connectivity.path_dependent   \n",
       "8461  ecn.multipoint.connectivity.path_dependent   \n",
       "8462  ecn.multipoint.connectivity.path_dependent   \n",
       "\n",
       "                              path set_id              time_end  \\\n",
       "0                  * 178.33.224.30    103  2014-08-28T21:36:57Z   \n",
       "1                   * 85.25.27.196    103  2014-08-28T22:01:21Z   \n",
       "2                   * 85.25.138.49    103  2014-08-28T23:52:19Z   \n",
       "3                  * 143.248.5.153    103  2014-08-28T21:50:36Z   \n",
       "4                 * 186.202.122.75    103  2014-08-28T22:40:09Z   \n",
       "5                  * 85.25.197.237    103  2014-08-28T22:27:10Z   \n",
       "6                * 164.109.105.205    103  2014-08-28T21:50:26Z   \n",
       "7                   * 85.25.200.72    103  2014-08-28T23:56:48Z   \n",
       "8                 * 190.192.160.69    103  2014-08-28T23:50:10Z   \n",
       "9                   * 62.75.196.60    103  2014-08-28T21:36:07Z   \n",
       "10                * 213.174.57.162    103  2014-08-29T00:32:49Z   \n",
       "11                * 213.174.57.202    103  2014-08-28T23:55:26Z   \n",
       "12                * 122.228.248.89    103  2014-08-28T22:16:10Z   \n",
       "13                * 188.138.17.111    103  2014-08-28T21:49:42Z   \n",
       "14               * 173.255.198.164    103  2014-08-28T23:18:41Z   \n",
       "15                  * 83.223.8.253    103  2014-08-28T23:01:36Z   \n",
       "16                 * 85.25.243.153    103  2014-08-28T22:50:08Z   \n",
       "17                 * 200.80.170.77    103  2014-08-28T22:40:18Z   \n",
       "18                  * 62.75.236.87    103  2014-08-28T22:21:31Z   \n",
       "19                 * 188.138.38.59    103  2014-08-28T21:52:48Z   \n",
       "20                  * 85.25.99.100    103  2014-08-28T23:10:42Z   \n",
       "21                  * 64.17.153.89    103  2014-08-28T23:07:49Z   \n",
       "22                  * 115.47.43.31    103  2014-08-28T22:30:09Z   \n",
       "23                * 217.172.186.27    103  2014-08-28T23:05:18Z   \n",
       "24    * 2607:f298:5:112b::f08:197c    103  2014-08-28T23:37:25Z   \n",
       "25                 * 200.58.109.28    103  2014-08-29T00:21:37Z   \n",
       "26                * 121.199.48.107    103  2014-08-28T22:33:46Z   \n",
       "27               * 217.172.181.198    103  2014-08-29T00:08:48Z   \n",
       "28                  * 69.162.81.66    103  2014-08-28T22:26:17Z   \n",
       "29                   * 85.25.95.55    103  2014-08-28T22:15:06Z   \n",
       "...                            ...    ...                   ...   \n",
       "8433                * 46.30.41.193    111  2017-01-16T22:21:33Z   \n",
       "8434              * 183.61.244.206    111  2017-01-16T02:40:31Z   \n",
       "8435                 * 41.110.2.23    111  2017-01-17T05:54:24Z   \n",
       "8436               * 23.224.138.10    111  2017-01-16T08:02:54Z   \n",
       "8437                * 166.66.86.13    111  2017-01-16T02:36:50Z   \n",
       "8438                * 209.160.74.9    111  2017-01-17T06:54:26Z   \n",
       "8439              * 180.97.250.153    111  2017-01-17T05:25:55Z   \n",
       "8440             * 108.167.183.248    111  2017-01-16T09:58:25Z   \n",
       "8441                 * 31.220.3.10    111  2017-01-17T07:28:54Z   \n",
       "8442                * 69.39.237.38    111  2017-01-17T12:43:58Z   \n",
       "8443                * 202.43.162.2    111  2017-01-17T17:54:49Z   \n",
       "8444               * 87.107.133.43    111  2017-01-16T17:54:11Z   \n",
       "8445              * 178.248.237.48    111  2017-01-17T12:04:07Z   \n",
       "8446              * 212.143.86.204    111  2017-01-17T02:15:48Z   \n",
       "8447               * 52.222.232.88    111  2017-01-16T19:08:27Z   \n",
       "8448             * 121.127.246.208    111  2017-01-16T14:59:22Z   \n",
       "8449               * 123.138.67.49    111  2017-01-16T16:12:56Z   \n",
       "8450               * 31.220.20.199    111  2017-01-16T02:21:20Z   \n",
       "8451                * 72.29.120.18    111  2017-01-16T06:15:43Z   \n",
       "8452                * 45.35.36.165    111  2017-01-16T21:52:37Z   \n",
       "8453              * 185.34.216.156    111  2017-01-17T16:34:32Z   \n",
       "8454              * 113.200.91.196    111  2017-01-17T09:23:59Z   \n",
       "8455               * 37.61.237.164    111  2017-01-17T07:45:57Z   \n",
       "8456           * 2403:5400:580c::6    111  2017-01-16T19:03:25Z   \n",
       "8457              * 188.10.254.103    111  2017-01-16T03:01:03Z   \n",
       "8458              * 60.190.222.229    111  2017-01-16T06:35:20Z   \n",
       "8459               * 115.236.59.86    111  2017-01-16T06:44:39Z   \n",
       "8460              * 139.224.60.169    111  2017-01-17T14:13:01Z   \n",
       "8461              * 190.102.128.50    111  2017-01-17T11:56:16Z   \n",
       "8462               * 62.156.172.70    111  2017-01-17T09:49:15Z   \n",
       "\n",
       "                time_start value  \n",
       "0     2014-08-28T21:28:30Z     3  \n",
       "1     2014-08-28T21:53:26Z     3  \n",
       "2     2014-08-28T23:47:04Z     3  \n",
       "3     2014-08-28T21:42:22Z     3  \n",
       "4     2014-08-28T22:34:31Z     3  \n",
       "5     2014-08-28T22:20:16Z     3  \n",
       "6     2014-08-28T21:42:13Z     3  \n",
       "7     2014-08-28T23:51:36Z     3  \n",
       "8     2014-08-28T23:45:00Z     3  \n",
       "9     2014-08-28T21:27:42Z     3  \n",
       "10    2014-08-29T00:27:17Z     3  \n",
       "11    2014-08-28T23:50:10Z     3  \n",
       "12    2014-08-28T22:08:46Z     3  \n",
       "13    2014-08-28T21:41:27Z     3  \n",
       "14    2014-08-28T23:13:53Z     3  \n",
       "15    2014-08-28T22:56:46Z     3  \n",
       "16    2014-08-28T22:44:55Z     3  \n",
       "17    2014-08-28T22:34:39Z     3  \n",
       "18    2014-08-28T22:14:20Z     3  \n",
       "19    2014-08-28T21:44:43Z     3  \n",
       "20    2014-08-28T23:06:02Z     3  \n",
       "21    2014-08-28T23:03:11Z     3  \n",
       "22    2014-08-28T22:23:30Z     3  \n",
       "23    2014-08-28T23:00:32Z     3  \n",
       "24    2014-08-28T23:32:23Z     3  \n",
       "25    2014-08-29T00:16:12Z     3  \n",
       "26    2014-08-28T22:27:23Z     3  \n",
       "27    2014-08-29T00:03:33Z     3  \n",
       "28    2014-08-28T22:19:22Z     3  \n",
       "29    2014-08-28T22:07:39Z     3  \n",
       "...                    ...   ...  \n",
       "8433  2017-01-16T22:17:19Z     7  \n",
       "8434  2017-01-16T02:34:21Z     7  \n",
       "8435  2017-01-17T05:39:33Z     7  \n",
       "8436  2017-01-16T07:57:00Z     7  \n",
       "8437  2017-01-16T02:36:12Z     7  \n",
       "8438  2017-01-17T06:48:09Z     7  \n",
       "8439  2017-01-17T05:15:32Z     7  \n",
       "8440  2017-01-16T09:51:28Z     7  \n",
       "8441  2017-01-17T07:24:08Z     7  \n",
       "8442  2017-01-17T12:33:56Z     7  \n",
       "8443  2017-01-17T17:43:23Z     7  \n",
       "8444  2017-01-16T17:49:12Z     7  \n",
       "8445  2017-01-17T11:55:47Z     7  \n",
       "8446  2017-01-17T01:52:12Z     7  \n",
       "8447  2017-01-16T19:05:32Z     7  \n",
       "8448  2017-01-16T14:52:30Z     7  \n",
       "8449  2017-01-16T16:04:44Z     7  \n",
       "8450  2017-01-16T02:10:13Z     7  \n",
       "8451  2017-01-16T06:07:51Z     7  \n",
       "8452  2017-01-16T21:44:51Z     7  \n",
       "8453  2017-01-17T16:26:01Z     7  \n",
       "8454  2017-01-17T09:20:14Z     7  \n",
       "8455  2017-01-17T07:35:59Z     7  \n",
       "8456  2017-01-16T18:53:26Z     7  \n",
       "8457  2017-01-16T02:55:10Z     7  \n",
       "8458  2017-01-16T06:29:52Z     7  \n",
       "8459  2017-01-16T06:43:04Z     7  \n",
       "8460  2017-01-17T14:01:04Z     7  \n",
       "8461  2017-01-17T11:22:45Z     7  \n",
       "8462  2017-01-17T09:42:20Z     7  \n",
       "\n",
       "[8463 rows x 6 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "q_all_pathdep.results()"
   ]
  },
  {
   "cell_type": "raw",
   "metadata": {},
   "source": []
  }
 ],
 "metadata": {
  "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.7.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}