.. _td2aecoexercicesdemanipulationdedonneescorrectionbrst:

==================================================================================================
2A.eco - Mise en pratique des séances 1 et 2 - Utilisation de pandas et visualisation - correction
==================================================================================================


.. only:: html

    **Links:** :download:`notebook <td2a_eco_exercices_de_manipulation_de_donnees_correction_b.ipynb>`, :downloadlink:`html <td2a_eco_exercices_de_manipulation_de_donnees_correction_b2html.html>`, :download:`python <td2a_eco_exercices_de_manipulation_de_donnees_correction_b.py>`, :downloadlink:`slides <td2a_eco_exercices_de_manipulation_de_donnees_correction_b.slides.html>`, :githublink:`GitHub|_doc/notebooks/td2a_eco/td2a_eco_exercices_de_manipulation_de_donnees_correction_b.ipynb|*`


Correction de l’exercice 2 et manipulations classiques de texte.

.. code:: ipython3

    %matplotlib inline

.. code:: ipython3

    from jyquickhelper import add_notebook_menu
    add_notebook_menu()






.. contents::
    :local:





.. code:: ipython3

    from pyensae.datasource import download_data
    files = download_data("td2a_eco_exercices_de_manipulation_de_donnees.zip",
                          url="https://github.com/sdpython/ensae_teaching_cs/raw/master/_doc/notebooks/td2a_eco/data/")
    files




.. parsed-literal::
    ['Players_WC2014.xlsx', '.\\velib_t1.txt', '.\\velib_t2.txt', '.\\villes.txt']



Exercice 2 - Les villes
-----------------------

Durée : 40 minutes

1. Importer la base des villes villes.xls
2. Les noms de variables et les observations contiennent des espaces
   inutiles (exemple : ‘MAJ’) : commnecer par nettoyer l’ensemble des
   chaines de caractères (à la fois dans les noms de colonnes et dans
   les observations)
3. Trouver le nombre de codes INSEE différents (attention aux doublons)
4. Comment calculer rapidement la moyenne, le nombre et le maximum pour
   chaque variable numérique ? (une ligne de code)
5. Compter le nombre de villes dans chaque Region et en faire un
   dictionnaire où la clé est la région et la valeur le nombre de villes
6. Représenter les communes en utilisant

   -  matplotlib
   -  une librairie de cartographie (ex : folium)

.. code:: ipython3

    import pandas
    df_villes = pandas.read_csv("villes.txt", sep="\t", encoding="utf-8")
    print(df_villes.columns)


.. parsed-literal::
    Index([' Nom Ville ', 'MAJ   ', ' Code Postal ', ' Code INSEE ', 'Code Région',
           ' Latitude ', ' Longitude ', ' Eloignement '],
          dtype='object')


.. code:: ipython3

    df_villes.head()






.. raw:: html

    <div>
    <style>
        .dataframe thead tr:only-child th {
            text-align: right;
        }

        .dataframe thead th {
            text-align: left;
        }

        .dataframe tbody tr th {
            vertical-align: top;
        }
    </style>
    <table border="1" class="dataframe">
      <thead>
        <tr style="text-align: right;">
          <th></th>
          <th>Nom Ville</th>
          <th>MAJ</th>
          <th>Code Postal</th>
          <th>Code INSEE</th>
          <th>Code Région</th>
          <th>Latitude</th>
          <th>Longitude</th>
          <th>Eloignement</th>
        </tr>
      </thead>
      <tbody>
        <tr>
          <th>0</th>
          <td>L'Abergement-Clémenciat</td>
          <td>L ABERGEMENT CLEMENCIAT</td>
          <td>1400</td>
          <td>1001</td>
          <td>82</td>
          <td>46.150000</td>
          <td>4.916667</td>
          <td>1.46</td>
        </tr>
        <tr>
          <th>1</th>
          <td>L'Abergement-de-Varey</td>
          <td>L ABERGEMENT DE VAREY</td>
          <td>1640</td>
          <td>1002</td>
          <td>82</td>
          <td>46.000000</td>
          <td>5.416667</td>
          <td>1</td>
        </tr>
        <tr>
          <th>2</th>
          <td>Amareins</td>
          <td>AMAREINS</td>
          <td>1090</td>
          <td>1003</td>
          <td>82</td>
          <td>46.083333</td>
          <td>4.8</td>
          <td>1.85</td>
        </tr>
        <tr>
          <th>3</th>
          <td>Ambérieu-en-Bugey</td>
          <td>AMBERIEU EN BUGEY</td>
          <td>1500</td>
          <td>1004</td>
          <td>82</td>
          <td>45.950000</td>
          <td>5.35</td>
          <td>0.8</td>
        </tr>
        <tr>
          <th>4</th>
          <td>Ambérieux-en-Dombes</td>
          <td>AMBERIEUX EN DOMBES</td>
          <td>1330</td>
          <td>1005</td>
          <td>82</td>
          <td>46.000000</td>
          <td>4.9</td>
          <td>1.72</td>
        </tr>
      </tbody>
    </table>
    </div>



Nettoyage des noms
------------------

.. code:: ipython3

    # Corriger les espaces en trop
    # solution pour les espaces
    # les colonnes
    df_villes.rename(columns=lambda x: x.strip(),inplace = True)
    # les observations
    df_villes['Nom Ville'] = df_villes[['Nom Ville']].applymap(lambda x: x.strip())
    df_villes['MAJ'] = df_villes[['MAJ']].applymap(lambda x: x.strip())

.. code:: ipython3

    df_villes.columns




.. parsed-literal::
    Index(['Nom Ville', 'MAJ', 'Code Postal', 'Code INSEE', 'Code Région',
           'Latitude', 'Longitude', 'Eloignement'],
          dtype='object')



Nombre de codes commune
-----------------------

.. code:: ipython3

    len(df_villes['Code INSEE'].unique())




.. parsed-literal::
    35248



Stats desc
----------

.. code:: ipython3

    df_villes.describe()






.. raw:: html

    <div>
    <style>
        .dataframe thead tr:only-child th {
            text-align: right;
        }

        .dataframe thead th {
            text-align: left;
        }

        .dataframe tbody tr th {
            vertical-align: top;
        }
    </style>
    <table border="1" class="dataframe">
      <thead>
        <tr style="text-align: right;">
          <th></th>
          <th>Code Postal</th>
          <th>Code INSEE</th>
          <th>Code Région</th>
          <th>Latitude</th>
        </tr>
      </thead>
      <tbody>
        <tr>
          <th>count</th>
          <td>35249.000000</td>
          <td>35249.000000</td>
          <td>35249.000000</td>
          <td>35249.000000</td>
        </tr>
        <tr>
          <th>mean</th>
          <td>46291.014554</td>
          <td>46186.992822</td>
          <td>48.532497</td>
          <td>46.998450</td>
        </tr>
        <tr>
          <th>std</th>
          <td>25418.598824</td>
          <td>25411.240496</td>
          <td>27.264257</td>
          <td>2.206877</td>
        </tr>
        <tr>
          <th>min</th>
          <td>1000.000000</td>
          <td>1001.000000</td>
          <td>0.000000</td>
          <td>41.391667</td>
        </tr>
        <tr>
          <th>25%</th>
          <td>24640.000000</td>
          <td>24550.000000</td>
          <td>24.000000</td>
          <td>45.216667</td>
        </tr>
        <tr>
          <th>50%</th>
          <td>49150.000000</td>
          <td>49074.000000</td>
          <td>43.000000</td>
          <td>47.450000</td>
        </tr>
        <tr>
          <th>75%</th>
          <td>66720.000000</td>
          <td>66203.000000</td>
          <td>72.000000</td>
          <td>48.850000</td>
        </tr>
        <tr>
          <th>max</th>
          <td>95880.000000</td>
          <td>95690.000000</td>
          <td>94.000000</td>
          <td>51.083333</td>
        </tr>
      </tbody>
    </table>
    </div>



Régions et nombre de communes
-----------------------------

.. code:: ipython3

    df_villes.groupby(['Code Région']).size().to_dict()




.. parsed-literal::
    {0: 86,
     11: 4181,
     21: 1462,
     22: 1433,
     23: 1342,
     24: 1766,
     25: 1774,
     26: 1483,
     31: 1494,
     41: 1825,
     43: 1104,
     52: 1188,
     53: 1243,
     54: 830,
     72: 5450,
     73: 1535,
     74: 837,
     82: 2368,
     83: 977,
     91: 1871,
     93: 662,
     94: 338}



Représenter visuellement les communes
-------------------------------------

La conversion depuis Excel (un copier coller) a laissé quelques cellules
négative et presque nulles ``-``. On les remplace par des valeurs
nulles.

.. code:: ipython3

    import pandas
    df_villes.Longitude = df_villes.Longitude.apply(lambda x: "0" if x.strip() == "-" else x)
    df_villes.Longitude = pandas.to_numeric(df_villes.Longitude)

matplotlib
~~~~~~~~~~

.. code:: ipython3

    import matplotlib.pyplot as plt
    plt.figure(figsize=(10,10))
    plt.scatter(df_villes.Longitude, df_villes.Latitude, s=0.1)




.. parsed-literal::
    <matplotlib.collections.PathCollection at 0x218487891d0>




.. image:: td2a_eco_exercices_de_manipulation_de_donnees_correction_b_19_1.png


Exemple avec Folium
~~~~~~~~~~~~~~~~~~~

.. code:: ipython3

    import folium
    import random
    
    locations = df_villes[['Latitude', 'Longitude']].copy()
    print(locations.shape, locations.dropna().shape)
    locations.dropna(inplace = True)
    
    locationlist = locations.values.tolist()
    len(locationlist)
    locationlist[7]


.. parsed-literal::
    (35249, 2) (35249, 2)




.. parsed-literal::

    [45.933333000000005, 5.3333330000000005]



.. code:: ipython3

    communes_random = random.sample(locationlist, 50)

.. code:: ipython3

    map = folium.Map(location=[47.088615, 2.637424], zoom_start=6)
    for point in range(0,len(communes_random)) :
        folium.Marker(communes_random[point]).add_to(map)
    map






.. raw:: html

    <div style="width:100%;"><div style="position:relative;width:100%;height:0;padding-bottom:60%;"><iframe src="data:text/html;charset=utf-8;base64,PCFET0NUWVBFIGh0bWw+CjxoZWFkPiAgICAKICAgIDxtZXRhIGh0dHAtZXF1aXY9ImNvbnRlbnQtdHlwZSIgY29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PVVURi04IiAvPgogICAgPHNjcmlwdD5MX1BSRUZFUl9DQU5WQVMgPSBmYWxzZTsgTF9OT19UT1VDSCA9IGZhbHNlOyBMX0RJU0FCTEVfM0QgPSBmYWxzZTs8L3NjcmlwdD4KICAgIDxzY3JpcHQgc3JjPSJodHRwczovL2Nkbi5qc2RlbGl2ci5uZXQvbnBtL2xlYWZsZXRAMS4yLjAvZGlzdC9sZWFmbGV0LmpzIj48L3NjcmlwdD4KICAgIDxzY3JpcHQgc3JjPSJodHRwczovL2FqYXguZ29vZ2xlYXBpcy5jb20vYWpheC9saWJzL2pxdWVyeS8xLjExLjEvanF1ZXJ5Lm1pbi5qcyI+PC9zY3JpcHQ+CiAgICA8c2NyaXB0IHNyYz0iaHR0cHM6Ly9tYXhjZG4uYm9vdHN0cmFwY2RuLmNvbS9ib290c3RyYXAvMy4yLjAvanMvYm9vdHN0cmFwLm1pbi5qcyI+PC9zY3JpcHQ+CiAgICA8c2NyaXB0IHNyYz0iaHR0cHM6Ly9jZG5qcy5jbG91ZGZsYXJlLmNvbS9hamF4L2xpYnMvTGVhZmxldC5hd2Vzb21lLW1hcmtlcnMvMi4wLjIvbGVhZmxldC5hd2Vzb21lLW1hcmtlcnMuanMiPjwvc2NyaXB0PgogICAgPGxpbmsgcmVsPSJzdHlsZXNoZWV0IiBocmVmPSJodHRwczovL2Nkbi5qc2RlbGl2ci5uZXQvbnBtL2xlYWZsZXRAMS4yLjAvZGlzdC9sZWFmbGV0LmNzcyIgLz4KICAgIDxsaW5rIHJlbD0ic3R5bGVzaGVldCIgaHJlZj0iaHR0cHM6Ly9tYXhjZG4uYm9vdHN0cmFwY2RuLmNvbS9ib290c3RyYXAvMy4yLjAvY3NzL2Jvb3RzdHJhcC5taW4uY3NzIiAvPgogICAgPGxpbmsgcmVsPSJzdHlsZXNoZWV0IiBocmVmPSJodHRwczovL21heGNkbi5ib290c3RyYXBjZG4uY29tL2Jvb3RzdHJhcC8zLjIuMC9jc3MvYm9vdHN0cmFwLXRoZW1lLm1pbi5jc3MiIC8+CiAgICA8bGluayByZWw9InN0eWxlc2hlZXQiIGhyZWY9Imh0dHBzOi8vbWF4Y2RuLmJvb3RzdHJhcGNkbi5jb20vZm9udC1hd2Vzb21lLzQuNi4zL2Nzcy9mb250LWF3ZXNvbWUubWluLmNzcyIgLz4KICAgIDxsaW5rIHJlbD0ic3R5bGVzaGVldCIgaHJlZj0iaHR0cHM6Ly9jZG5qcy5jbG91ZGZsYXJlLmNvbS9hamF4L2xpYnMvTGVhZmxldC5hd2Vzb21lLW1hcmtlcnMvMi4wLjIvbGVhZmxldC5hd2Vzb21lLW1hcmtlcnMuY3NzIiAvPgogICAgPGxpbmsgcmVsPSJzdHlsZXNoZWV0IiBocmVmPSJodHRwczovL3Jhd2dpdC5jb20vcHl0aG9uLXZpc3VhbGl6YXRpb24vZm9saXVtL21hc3Rlci9mb2xpdW0vdGVtcGxhdGVzL2xlYWZsZXQuYXdlc29tZS5yb3RhdGUuY3NzIiAvPgogICAgPHN0eWxlPmh0bWwsIGJvZHkge3dpZHRoOiAxMDAlO2hlaWdodDogMTAwJTttYXJnaW46IDA7cGFkZGluZzogMDt9PC9zdHlsZT4KICAgIDxzdHlsZT4jbWFwIHtwb3NpdGlvbjphYnNvbHV0ZTt0b3A6MDtib3R0b206MDtyaWdodDowO2xlZnQ6MDt9PC9zdHlsZT4KICAgIAogICAgICAgICAgICA8c3R5bGU+ICNtYXBfZDE3M2U5NGJiZDU1NGU2ZDg1ZTU3YmE0YzRkM2M3YzAgewogICAgICAgICAgICAgICAgcG9zaXRpb24gOiByZWxhdGl2ZTsKICAgICAgICAgICAgICAgIHdpZHRoIDogMTAwLjAlOwogICAgICAgICAgICAgICAgaGVpZ2h0OiAxMDAuMCU7CiAgICAgICAgICAgICAgICBsZWZ0OiAwLjAlOwogICAgICAgICAgICAgICAgdG9wOiAwLjAlOwogICAgICAgICAgICAgICAgfQogICAgICAgICAgICA8L3N0eWxlPgogICAgICAgIAo8L2hlYWQ+Cjxib2R5PiAgICAKICAgIAogICAgICAgICAgICA8ZGl2IGNsYXNzPSJmb2xpdW0tbWFwIiBpZD0ibWFwX2QxNzNlOTRiYmQ1NTRlNmQ4NWU1N2JhNGM0ZDNjN2MwIiA+PC9kaXY+CiAgICAgICAgCjwvYm9keT4KPHNjcmlwdD4gICAgCiAgICAKCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIGJvdW5kcyA9IG51bGw7CiAgICAgICAgICAgIAoKICAgICAgICAgICAgdmFyIG1hcF9kMTczZTk0YmJkNTU0ZTZkODVlNTdiYTRjNGQzYzdjMCA9IEwubWFwKAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgJ21hcF9kMTczZTk0YmJkNTU0ZTZkODVlNTdiYTRjNGQzYzdjMCcsCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB7Y2VudGVyOiBbNDcuMDg4NjE1LDIuNjM3NDI0XSwKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHpvb206IDYsCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBtYXhCb3VuZHM6IGJvdW5kcywKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGxheWVyczogW10sCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB3b3JsZENvcHlKdW1wOiBmYWxzZSwKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGNyczogTC5DUlMuRVBTRzM4NTcKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgfSk7CiAgICAgICAgICAgIAogICAgICAgIAogICAgCiAgICAgICAgICAgIHZhciB0aWxlX2xheWVyX2M1YzY5MGFhYTE0MDRiMzM5MzAxZjMxNmM4ODhlY2EwID0gTC50aWxlTGF5ZXIoCiAgICAgICAgICAgICAgICAnaHR0cHM6Ly97c30udGlsZS5vcGVuc3RyZWV0bWFwLm9yZy97en0ve3h9L3t5fS5wbmcnLAogICAgICAgICAgICAgICAgewogICJhdHRyaWJ1dGlvbiI6IG51bGwsCiAgImRldGVjdFJldGluYSI6IGZhbHNlLAogICJtYXhab29tIjogMTgsCiAgIm1pblpvb20iOiAxLAogICJub1dyYXAiOiBmYWxzZSwKICAic3ViZG9tYWlucyI6ICJhYmMiCn0KICAgICAgICAgICAgICAgICkuYWRkVG8obWFwX2QxNzNlOTRiYmQ1NTRlNmQ4NWU1N2JhNGM0ZDNjN2MwKTsKICAgICAgICAKICAgIAoKICAgICAgICAgICAgdmFyIG1hcmtlcl81OTM5YzA4OGRiMWM0YzJiOGE0YzAyMzY1Zjc2NDNmMCA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzUwLjQxNjY2NywyLjc2NjY2N10sCiAgICAgICAgICAgICAgICB7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogbmV3IEwuSWNvbi5EZWZhdWx0KCkKICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICAgICApCiAgICAgICAgICAgICAgICAuYWRkVG8obWFwX2QxNzNlOTRiYmQ1NTRlNmQ4NWU1N2JhNGM0ZDNjN2MwKTsKICAgICAgICAgICAgCiAgICAKCiAgICAgICAgICAgIHZhciBtYXJrZXJfYjkzZWZlNWM3ZThiNDZjM2FjMmM1ODI1ZTFiYTBkMjQgPSBMLm1hcmtlcigKICAgICAgICAgICAgICAgIFs0OS40MTY2NjcsNC41XSwKICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgICkKICAgICAgICAgICAgICAgIC5hZGRUbyhtYXBfZDE3M2U5NGJiZDU1NGU2ZDg1ZTU3YmE0YzRkM2M3YzApOwogICAgICAgICAgICAKICAgIAoKICAgICAgICAgICAgdmFyIG1hcmtlcl8yYTBmZTZiZDQyOGQ0NTk0YjEzNDQxNWFiMDI3NGQ2ZiA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQ4LjIxNjY2NywtMS41XSwKICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgICkKICAgICAgICAgICAgICAgIC5hZGRUbyhtYXBfZDE3M2U5NGJiZDU1NGU2ZDg1ZTU3YmE0YzRkM2M3YzApOwogICAgICAgICAgICAKICAgIAoKICAgICAgICAgICAgdmFyIG1hcmtlcl9lZDM4ZTVjMDQxYjY0NDY0YTVkNDAyMWQ1YzFhNDliNyA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQ0LjMzMzMzMywyLjQzMzMzM10sCiAgICAgICAgICAgICAgICB7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogbmV3IEwuSWNvbi5EZWZhdWx0KCkKICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICAgICApCiAgICAgICAgICAgICAgICAuYWRkVG8obWFwX2QxNzNlOTRiYmQ1NTRlNmQ4NWU1N2JhNGM0ZDNjN2MwKTsKICAgICAgICAgICAgCiAgICAKCiAgICAgICAgICAgIHZhciBtYXJrZXJfM2Q2MDlhYmQ3ZTU2NGVhNzk0MzkxYjIzOTU5YWIwOWMgPSBMLm1hcmtlcigKICAgICAgICAgICAgICAgIFs0My43MTY2NjcsMC41XSwKICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgICkKICAgICAgICAgICAgICAgIC5hZGRUbyhtYXBfZDE3M2U5NGJiZDU1NGU2ZDg1ZTU3YmE0YzRkM2M3YzApOwogICAgICAgICAgICAKICAgIAoKICAgICAgICAgICAgdmFyIG1hcmtlcl81MGZjMWQxMzYyOGY0NjNkOTNmODk3MDdmMDQxMDEzYiA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQ2LjgxNjY2Njk5OTk5OTk5NSw1LjU4MzMzMzAwMDAwMDAwMDVdLAogICAgICAgICAgICAgICAgewogICAgICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgKQogICAgICAgICAgICAgICAgLmFkZFRvKG1hcF9kMTczZTk0YmJkNTU0ZTZkODVlNTdiYTRjNGQzYzdjMCk7CiAgICAgICAgICAgIAogICAgCgogICAgICAgICAgICB2YXIgbWFya2VyXzJjYzBlNDQ1MjQ2MjQ2OTI4ZGI0ODg3ZjJjMjkwMzQzID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDguNzMzMzMzLDEuMzY2NjY3XSwKICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgICkKICAgICAgICAgICAgICAgIC5hZGRUbyhtYXBfZDE3M2U5NGJiZDU1NGU2ZDg1ZTU3YmE0YzRkM2M3YzApOwogICAgICAgICAgICAKICAgIAoKICAgICAgICAgICAgdmFyIG1hcmtlcl8wMjQ2M2M5MTJjNGI0YjczYWYwYTY4NzNiMWFhMzVhNCA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQ3LjY4MzMzMzAwMDAwMDAwNSw2LjE2NjY2Njk5OTk5OTk5OTVdLAogICAgICAgICAgICAgICAgewogICAgICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgKQogICAgICAgICAgICAgICAgLmFkZFRvKG1hcF9kMTczZTk0YmJkNTU0ZTZkODVlNTdiYTRjNGQzYzdjMCk7CiAgICAgICAgICAgIAogICAgCgogICAgICAgICAgICB2YXIgbWFya2VyXzZjMTU0YmQ3YzhlZDRkNzI5ZGM0Yjc5ODlkMWY4NTU4ID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDkuMjgzMzMzLC0wLjY4MzMzM10sCiAgICAgICAgICAgICAgICB7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogbmV3IEwuSWNvbi5EZWZhdWx0KCkKICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICAgICApCiAgICAgICAgICAgICAgICAuYWRkVG8obWFwX2QxNzNlOTRiYmQ1NTRlNmQ4NWU1N2JhNGM0ZDNjN2MwKTsKICAgICAgICAgICAgCiAgICAKCiAgICAgICAgICAgIHZhciBtYXJrZXJfN2Q0MzhkNGMxZGM5NGM1NjgwZWNiODhjM2YxYThlMjcgPSBMLm1hcmtlcigKICAgICAgICAgICAgICAgIFs0OC4xNjY2NjcsMC4yMzMzMzI5OTk5OTk5OTk5OF0sCiAgICAgICAgICAgICAgICB7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogbmV3IEwuSWNvbi5EZWZhdWx0KCkKICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICAgICApCiAgICAgICAgICAgICAgICAuYWRkVG8obWFwX2QxNzNlOTRiYmQ1NTRlNmQ4NWU1N2JhNGM0ZDNjN2MwKTsKICAgICAgICAgICAgCiAgICAKCiAgICAgICAgICAgIHZhciBtYXJrZXJfNTVkZmExN2QxMDI0NGQxNjk5OWYzMWI1YWYyZTAyNzMgPSBMLm1hcmtlcigKICAgICAgICAgICAgICAgIFs0My4zNSwyLjRdLAogICAgICAgICAgICAgICAgewogICAgICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgKQogICAgICAgICAgICAgICAgLmFkZFRvKG1hcF9kMTczZTk0YmJkNTU0ZTZkODVlNTdiYTRjNGQzYzdjMCk7CiAgICAgICAgICAgIAogICAgCgogICAgICAgICAgICB2YXIgbWFya2VyXzY1MDg3MmFjNDIwMjRkNDA4MTFjMjk5NTMyMmQyODMyID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDguMjMzMzMzLDIuMDVdLAogICAgICAgICAgICAgICAgewogICAgICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgKQogICAgICAgICAgICAgICAgLmFkZFRvKG1hcF9kMTczZTk0YmJkNTU0ZTZkODVlNTdiYTRjNGQzYzdjMCk7CiAgICAgICAgICAgIAogICAgCgogICAgICAgICAgICB2YXIgbWFya2VyXzEzMjRlMzE3YTBlNTRjZTZiYzJiYjc4MDI5YWY2ZWM3ID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDguODMzMzMzLDAuMl0sCiAgICAgICAgICAgICAgICB7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogbmV3IEwuSWNvbi5EZWZhdWx0KCkKICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICAgICApCiAgICAgICAgICAgICAgICAuYWRkVG8obWFwX2QxNzNlOTRiYmQ1NTRlNmQ4NWU1N2JhNGM0ZDNjN2MwKTsKICAgICAgICAgICAgCiAgICAKCiAgICAgICAgICAgIHZhciBtYXJrZXJfNTE4NTYwNTE3ZjJjNGRhZTg3NWQ1OTg3ZmU2YmU0M2QgPSBMLm1hcmtlcigKICAgICAgICAgICAgICAgIFs0Ny44MzMzMzMsLTIuMzVdLAogICAgICAgICAgICAgICAgewogICAgICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgKQogICAgICAgICAgICAgICAgLmFkZFRvKG1hcF9kMTczZTk0YmJkNTU0ZTZkODVlNTdiYTRjNGQzYzdjMCk7CiAgICAgICAgICAgIAogICAgCgogICAgICAgICAgICB2YXIgbWFya2VyXzIzODk4OTEyMThiNjQwYmY4NGQyMWU2ZjU5MTdmOWZhID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDMuNDUsMy43NV0sCiAgICAgICAgICAgICAgICB7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogbmV3IEwuSWNvbi5EZWZhdWx0KCkKICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICAgICApCiAgICAgICAgICAgICAgICAuYWRkVG8obWFwX2QxNzNlOTRiYmQ1NTRlNmQ4NWU1N2JhNGM0ZDNjN2MwKTsKICAgICAgICAgICAgCiAgICAKCiAgICAgICAgICAgIHZhciBtYXJrZXJfNWU0ZTE0Njc5NWRjNGYzZGFjMTcwNGI0N2VmZTVmMzkgPSBMLm1hcmtlcigKICAgICAgICAgICAgICAgIFs0Ny43MzMzMzMsNS4wNjY2NjddLAogICAgICAgICAgICAgICAgewogICAgICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgKQogICAgICAgICAgICAgICAgLmFkZFRvKG1hcF9kMTczZTk0YmJkNTU0ZTZkODVlNTdiYTRjNGQzYzdjMCk7CiAgICAgICAgICAgIAogICAgCgogICAgICAgICAgICB2YXIgbWFya2VyXzNmOTdhYWNlOGYxMDQzYTJhYWNhMDE1YmFjMzI1MDllID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDkuMzE2NjY2OTk5OTk5OTk1LDAuODMzMzMzXSwKICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgICkKICAgICAgICAgICAgICAgIC5hZGRUbyhtYXBfZDE3M2U5NGJiZDU1NGU2ZDg1ZTU3YmE0YzRkM2M3YzApOwogICAgICAgICAgICAKICAgIAoKICAgICAgICAgICAgdmFyIG1hcmtlcl85MzUwOWZkNDVhYzE0NjFjOTlhNTc3NDEwZjYyZmRjOSA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQ5LjEzMzMzMyw2LjU1XSwKICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgICkKICAgICAgICAgICAgICAgIC5hZGRUbyhtYXBfZDE3M2U5NGJiZDU1NGU2ZDg1ZTU3YmE0YzRkM2M3YzApOwogICAgICAgICAgICAKICAgIAoKICAgICAgICAgICAgdmFyIG1hcmtlcl81ZGRhOTAyY2ExYmY0NmI2YjM0M2VlNGI2M2FmNGVhYSA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzUwLjExNjY2NywyLjldLAogICAgICAgICAgICAgICAgewogICAgICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgKQogICAgICAgICAgICAgICAgLmFkZFRvKG1hcF9kMTczZTk0YmJkNTU0ZTZkODVlNTdiYTRjNGQzYzdjMCk7CiAgICAgICAgICAgIAogICAgCgogICAgICAgICAgICB2YXIgbWFya2VyX2MxNzgxNjZhOTZhOTQ5MTJhYmJhYWNhOGRiMDI1NTc3ID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDcuNTY2NjY2OTk5OTk5OTk1LDMuNjVdLAogICAgICAgICAgICAgICAgewogICAgICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgKQogICAgICAgICAgICAgICAgLmFkZFRvKG1hcF9kMTczZTk0YmJkNTU0ZTZkODVlNTdiYTRjNGQzYzdjMCk7CiAgICAgICAgICAgIAogICAgCgogICAgICAgICAgICB2YXIgbWFya2VyXzg1ZWIzOWZiMDg1MjRjMGU5OGRkNDVjYTMyMDI5M2VjID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNTAuODY2NjY3LDEuOTVdLAogICAgICAgICAgICAgICAgewogICAgICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgKQogICAgICAgICAgICAgICAgLmFkZFRvKG1hcF9kMTczZTk0YmJkNTU0ZTZkODVlNTdiYTRjNGQzYzdjMCk7CiAgICAgICAgICAgIAogICAgCgogICAgICAgICAgICB2YXIgbWFya2VyXzc1YzVkYmE0Yzg0ZDQxMjRhNTJiNzRkN2IxZDNmODE0ID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDkuNTMzMzMzLDAuNzMzMzMzXSwKICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgICkKICAgICAgICAgICAgICAgIC5hZGRUbyhtYXBfZDE3M2U5NGJiZDU1NGU2ZDg1ZTU3YmE0YzRkM2M3YzApOwogICAgICAgICAgICAKICAgIAoKICAgICAgICAgICAgdmFyIG1hcmtlcl8zODg4Y2I4NjQ3ZGQ0ZGQzYTI1MzE4ZWNjMjIxNjJhNyA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQ0LjU2NjY2Njk5OTk5OTk5NSwwLjk2NjY2N10sCiAgICAgICAgICAgICAgICB7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogbmV3IEwuSWNvbi5EZWZhdWx0KCkKICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICAgICApCiAgICAgICAgICAgICAgICAuYWRkVG8obWFwX2QxNzNlOTRiYmQ1NTRlNmQ4NWU1N2JhNGM0ZDNjN2MwKTsKICAgICAgICAgICAgCiAgICAKCiAgICAgICAgICAgIHZhciBtYXJrZXJfZTBhMTExYTBlNmI4NGE4N2I4Zjg4N2I1Mjg5NDM1Y2UgPSBMLm1hcmtlcigKICAgICAgICAgICAgICAgIFs0Ny4xMzMzMzMsNS42NV0sCiAgICAgICAgICAgICAgICB7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogbmV3IEwuSWNvbi5EZWZhdWx0KCkKICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICAgICApCiAgICAgICAgICAgICAgICAuYWRkVG8obWFwX2QxNzNlOTRiYmQ1NTRlNmQ4NWU1N2JhNGM0ZDNjN2MwKTsKICAgICAgICAgICAgCiAgICAKCiAgICAgICAgICAgIHZhciBtYXJrZXJfN2RlMzE1MjU0NTIzNDE3YThmNDhlMjc1MWQzOGM3MzIgPSBMLm1hcmtlcigKICAgICAgICAgICAgICAgIFs0OS4wMzMzMzMsLTEuNDE2NjY3XSwKICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgICkKICAgICAgICAgICAgICAgIC5hZGRUbyhtYXBfZDE3M2U5NGJiZDU1NGU2ZDg1ZTU3YmE0YzRkM2M3YzApOwogICAgICAgICAgICAKICAgIAoKICAgICAgICAgICAgdmFyIG1hcmtlcl9lN2IwZDA1NWRmZmY0NDg2ODdkMmNiMTQ5NGZjODg5NCA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQ1LjI2NjY2NywyLjUzMzMzMzAwMDAwMDAwMDNdLAogICAgICAgICAgICAgICAgewogICAgICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgKQogICAgICAgICAgICAgICAgLmFkZFRvKG1hcF9kMTczZTk0YmJkNTU0ZTZkODVlNTdiYTRjNGQzYzdjMCk7CiAgICAgICAgICAgIAogICAgCgogICAgICAgICAgICB2YXIgbWFya2VyXzFiNDQ2ODM1YTE4ODRhMjQ5MmVjNzJhYWNkZmZlOWJjID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDguMDY2NjY2OTk5OTk5OTk1LDcuNDE2NjY2OTk5OTk5OTk5NV0sCiAgICAgICAgICAgICAgICB7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogbmV3IEwuSWNvbi5EZWZhdWx0KCkKICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICAgICApCiAgICAgICAgICAgICAgICAuYWRkVG8obWFwX2QxNzNlOTRiYmQ1NTRlNmQ4NWU1N2JhNGM0ZDNjN2MwKTsKICAgICAgICAgICAgCiAgICAKCiAgICAgICAgICAgIHZhciBtYXJrZXJfNDAxZGQxOWE0YTZkNDg3ZmE2YzViMmJiMGNjZTI5MWQgPSBMLm1hcmtlcigKICAgICAgICAgICAgICAgIFs0OC43ODMzMzMsMS44NV0sCiAgICAgICAgICAgICAgICB7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogbmV3IEwuSWNvbi5EZWZhdWx0KCkKICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICAgICApCiAgICAgICAgICAgICAgICAuYWRkVG8obWFwX2QxNzNlOTRiYmQ1NTRlNmQ4NWU1N2JhNGM0ZDNjN2MwKTsKICAgICAgICAgICAgCiAgICAKCiAgICAgICAgICAgIHZhciBtYXJrZXJfZGFjMGI2NGFkMjUyNDhmMjkwNDZmMGNhN2NlM2JjZDAgPSBMLm1hcmtlcigKICAgICAgICAgICAgICAgIFs0Ny42LDQuMF0sCiAgICAgICAgICAgICAgICB7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogbmV3IEwuSWNvbi5EZWZhdWx0KCkKICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICAgICApCiAgICAgICAgICAgICAgICAuYWRkVG8obWFwX2QxNzNlOTRiYmQ1NTRlNmQ4NWU1N2JhNGM0ZDNjN2MwKTsKICAgICAgICAgICAgCiAgICAKCiAgICAgICAgICAgIHZhciBtYXJrZXJfODEzMjI1N2UyZmFmNDkyNmJkYzEzNzZjMDI3NzE5ZjcgPSBMLm1hcmtlcigKICAgICAgICAgICAgICAgIFs0NS45MzMzMzMwMDAwMDAwMDUsNi4xXSwKICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgICkKICAgICAgICAgICAgICAgIC5hZGRUbyhtYXBfZDE3M2U5NGJiZDU1NGU2ZDg1ZTU3YmE0YzRkM2M3YzApOwogICAgICAgICAgICAKICAgIAoKICAgICAgICAgICAgdmFyIG1hcmtlcl84NTg0YWQ5OWIzMzg0MDY3OWE3N2YyYTM5OTRlNjkzOCA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQ5LjI4MzMzMywwLjk1XSwKICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgICkKICAgICAgICAgICAgICAgIC5hZGRUbyhtYXBfZDE3M2U5NGJiZDU1NGU2ZDg1ZTU3YmE0YzRkM2M3YzApOwogICAgICAgICAgICAKICAgIAoKICAgICAgICAgICAgdmFyIG1hcmtlcl8yMDUzNGNiZGRiYmE0NTFkOWNhZDk3MDliZTc5OGViNiA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQ4LjAxNjY2Nyw0LjQ1XSwKICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgICkKICAgICAgICAgICAgICAgIC5hZGRUbyhtYXBfZDE3M2U5NGJiZDU1NGU2ZDg1ZTU3YmE0YzRkM2M3YzApOwogICAgICAgICAgICAKICAgIAoKICAgICAgICAgICAgdmFyIG1hcmtlcl8xMjhlNDE1ZmIzYmU0MDMzOTcwNDM1ZmNiMzVlNTE0OCA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQ1LjY4MzMzMzAwMDAwMDAwNSwwLjExNjY2N10sCiAgICAgICAgICAgICAgICB7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogbmV3IEwuSWNvbi5EZWZhdWx0KCkKICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICAgICApCiAgICAgICAgICAgICAgICAuYWRkVG8obWFwX2QxNzNlOTRiYmQ1NTRlNmQ4NWU1N2JhNGM0ZDNjN2MwKTsKICAgICAgICAgICAgCiAgICAKCiAgICAgICAgICAgIHZhciBtYXJrZXJfMjkwNjA4NGY1YzJiNGI1MzhjZjg2YWI5ZmEwODRiYjcgPSBMLm1hcmtlcigKICAgICAgICAgICAgICAgIFs0NC44NjY2NjcsNS4wODMzMzMwMDAwMDAwMDA1XSwKICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgICkKICAgICAgICAgICAgICAgIC5hZGRUbyhtYXBfZDE3M2U5NGJiZDU1NGU2ZDg1ZTU3YmE0YzRkM2M3YzApOwogICAgICAgICAgICAKICAgIAoKICAgICAgICAgICAgdmFyIG1hcmtlcl9mYTkxNGM5ODY3NGI0ZTIwODA4MWE4MTJhYzhlNzVlYyA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQ5LjIsMi40NjY2NjY5OTk5OTk5OTk3XSwKICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgICkKICAgICAgICAgICAgICAgIC5hZGRUbyhtYXBfZDE3M2U5NGJiZDU1NGU2ZDg1ZTU3YmE0YzRkM2M3YzApOwogICAgICAgICAgICAKICAgIAoKICAgICAgICAgICAgdmFyIG1hcmtlcl81ZjFkYWEwNDIxMzk0YjlkODY4OGQ4NjhlMmUyMTU3OSA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQ4LjI1LDUuOTVdLAogICAgICAgICAgICAgICAgewogICAgICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgKQogICAgICAgICAgICAgICAgLmFkZFRvKG1hcF9kMTczZTk0YmJkNTU0ZTZkODVlNTdiYTRjNGQzYzdjMCk7CiAgICAgICAgICAgIAogICAgCgogICAgICAgICAgICB2YXIgbWFya2VyX2QwMzhjYzY1ZDBiMjQyNWU4NWVjYmQ1OWVjMGZkZmQ1ID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDguODE2NjY2OTk5OTk5OTk1LDUuNTMzMzMzXSwKICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgICkKICAgICAgICAgICAgICAgIC5hZGRUbyhtYXBfZDE3M2U5NGJiZDU1NGU2ZDg1ZTU3YmE0YzRkM2M3YzApOwogICAgICAgICAgICAKICAgIAoKICAgICAgICAgICAgdmFyIG1hcmtlcl9lZGRiMmU4ZTE2MWQ0YjJjYTNiZDU3MmVjN2FjYmNhMSA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQ5LjcsNC4wODMzMzMwMDAwMDAwMDA1XSwKICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgICkKICAgICAgICAgICAgICAgIC5hZGRUbyhtYXBfZDE3M2U5NGJiZDU1NGU2ZDg1ZTU3YmE0YzRkM2M3YzApOwogICAgICAgICAgICAKICAgIAoKICAgICAgICAgICAgdmFyIG1hcmtlcl82MDMwMDcwNmZkYzA0NjZlYmY2YzU4ZjE5Nzg5NDdmYyA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQ4LjI1LDYuNTY2NjY3XSwKICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgICkKICAgICAgICAgICAgICAgIC5hZGRUbyhtYXBfZDE3M2U5NGJiZDU1NGU2ZDg1ZTU3YmE0YzRkM2M3YzApOwogICAgICAgICAgICAKICAgIAoKICAgICAgICAgICAgdmFyIG1hcmtlcl9lYmVlM2IwMjM0Mzc0MmQ2ODQwMjcxMWE5NzZiYjJhMSA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQ5LjIsMS42NjY2NjddLAogICAgICAgICAgICAgICAgewogICAgICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgKQogICAgICAgICAgICAgICAgLmFkZFRvKG1hcF9kMTczZTk0YmJkNTU0ZTZkODVlNTdiYTRjNGQzYzdjMCk7CiAgICAgICAgICAgIAogICAgCgogICAgICAgICAgICB2YXIgbWFya2VyXzRkYTBmMGI1YTVjOTRmYjdiNzAyMDU4NGY4MDQwM2FkID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDguMTMzMzMzLC0xLjk2NjY2Njk5OTk5OTk5OTddLAogICAgICAgICAgICAgICAgewogICAgICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgKQogICAgICAgICAgICAgICAgLmFkZFRvKG1hcF9kMTczZTk0YmJkNTU0ZTZkODVlNTdiYTRjNGQzYzdjMCk7CiAgICAgICAgICAgIAogICAgCgogICAgICAgICAgICB2YXIgbWFya2VyX2Y1ZTdiZjEzZTI1YjRiZjhhMzBmY2JjZjhlODI4NTFmID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDguOTE2NjY3LDQuODVdLAogICAgICAgICAgICAgICAgewogICAgICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgKQogICAgICAgICAgICAgICAgLmFkZFRvKG1hcF9kMTczZTk0YmJkNTU0ZTZkODVlNTdiYTRjNGQzYzdjMCk7CiAgICAgICAgICAgIAogICAgCgogICAgICAgICAgICB2YXIgbWFya2VyXzk0OWIyNDAzZDg4ODRmOTBhNGE4MDdjMzkwYTNiMDY5ID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDcuMjY2NjY3LDQuNDgzMzMzXSwKICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgICkKICAgICAgICAgICAgICAgIC5hZGRUbyhtYXBfZDE3M2U5NGJiZDU1NGU2ZDg1ZTU3YmE0YzRkM2M3YzApOwogICAgICAgICAgICAKICAgIAoKICAgICAgICAgICAgdmFyIG1hcmtlcl9lNjA1YjFiZDU5YWY0MDc2YWE3MjdiYmU4YTE1MmI5MCA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQ1LjQsMC4zNjY2NjddLAogICAgICAgICAgICAgICAgewogICAgICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgKQogICAgICAgICAgICAgICAgLmFkZFRvKG1hcF9kMTczZTk0YmJkNTU0ZTZkODVlNTdiYTRjNGQzYzdjMCk7CiAgICAgICAgICAgIAogICAgCgogICAgICAgICAgICB2YXIgbWFya2VyX2I3MmI5MjczZTI0YjQ5NGFiMWM2NDU5OTUxNjgwYTZkID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDYuMiwtMC41ODMzMzNdLAogICAgICAgICAgICAgICAgewogICAgICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgKQogICAgICAgICAgICAgICAgLmFkZFRvKG1hcF9kMTczZTk0YmJkNTU0ZTZkODVlNTdiYTRjNGQzYzdjMCk7CiAgICAgICAgICAgIAogICAgCgogICAgICAgICAgICB2YXIgbWFya2VyX2NmZWZjYmViMGY5NzQ5ZTg5YTA3NmRiZTk2MGQ5MTlmID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDYuMjMzMzMzLDEuNDgzMzMzXSwKICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgICkKICAgICAgICAgICAgICAgIC5hZGRUbyhtYXBfZDE3M2U5NGJiZDU1NGU2ZDg1ZTU3YmE0YzRkM2M3YzApOwogICAgICAgICAgICAKICAgIAoKICAgICAgICAgICAgdmFyIG1hcmtlcl8wMjc3MDBlYmU2ODM0Y2U2OTlkYzFmMTY3M2JmYmEyZSA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQ5LjAsNC45NjY2NjddLAogICAgICAgICAgICAgICAgewogICAgICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgKQogICAgICAgICAgICAgICAgLmFkZFRvKG1hcF9kMTczZTk0YmJkNTU0ZTZkODVlNTdiYTRjNGQzYzdjMCk7CiAgICAgICAgICAgIAogICAgCgogICAgICAgICAgICB2YXIgbWFya2VyX2Y0ZWZlNDhhMTE1YTRiY2U5NmZhZDI1YTExOWM1NzFkID0gTC5tYXJrZXIoCiAgICAgICAgICAgICAgICBbNDIuOTE2NjY3LDIuNjMzMzMzMDAwMDAwMDAwNF0sCiAgICAgICAgICAgICAgICB7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogbmV3IEwuSWNvbi5EZWZhdWx0KCkKICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICAgICApCiAgICAgICAgICAgICAgICAuYWRkVG8obWFwX2QxNzNlOTRiYmQ1NTRlNmQ4NWU1N2JhNGM0ZDNjN2MwKTsKICAgICAgICAgICAgCiAgICAKCiAgICAgICAgICAgIHZhciBtYXJrZXJfZjRlMDVlOWE1YzFiNGUzMmFjOTQ4ODNjOWNiY2ZiMmMgPSBMLm1hcmtlcigKICAgICAgICAgICAgICAgIFs0Mi41ODMzMzMsMi4xMTY2NjY5OTk5OTk5OTk2XSwKICAgICAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgICkKICAgICAgICAgICAgICAgIC5hZGRUbyhtYXBfZDE3M2U5NGJiZDU1NGU2ZDg1ZTU3YmE0YzRkM2M3YzApOwogICAgICAgICAgICAKICAgIAoKICAgICAgICAgICAgdmFyIG1hcmtlcl9lZjU0ZDE4ZWRiMTg0YWU3YWJmODAyOWEyY2VhZmYyOSA9IEwubWFya2VyKAogICAgICAgICAgICAgICAgWzQzLjUsMS40NjY2NjddLAogICAgICAgICAgICAgICAgewogICAgICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgKQogICAgICAgICAgICAgICAgLmFkZFRvKG1hcF9kMTczZTk0YmJkNTU0ZTZkODVlNTdiYTRjNGQzYzdjMCk7CiAgICAgICAgICAgIAo8L3NjcmlwdD4=" style="position:absolute;width:100%;height:100%;left:0;top:0;border:none !important;" allowfullscreen webkitallowfullscreen mozallowfullscreen></iframe></div></div>