imersaodados3_aula4.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "imersaodados3_aula4.ipynb",
      "provenance": [],
      "authorship_tag": "ABX9TyNyilRZL7tUXFA4BDbk4ceq",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/leonardo-melniski/imersaodados-3/blob/main/imersaodados3_aula4.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "kvScELI8cz11"
      },
      "source": [
        "#Aula 4: Merge de dados e análise de resultados\n",
        "\n",
        "Nesta aula, vamos analisar a base de dados resultados, **combinando** as duas bases com a função **merge** do pandas. Em seguida, vamos analisar a relação entre algumas informações da base de dados experimentais e resultados utilizando o boxplot. Por fim, entenderemos o que é o **mecanismo de ação** (MoA) de uma droga.\n",
        "\n",
        "Para dar um mergulho ainda mais profundo, dê uma olhada na documentação da função [merge](https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.merge.html)."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 439
        },
        "id": "2OvNJXaMdUHt",
        "outputId": "a8a6f1e1-5b72-49b3-c5a9-d2c41ed44e68"
      },
      "source": [
        "import pandas as pd\n",
        "\n",
        "url_dados = 'https://github.com/alura-cursos/imersaodados3/blob/main/dados/dados_experimentos.zip?raw=true'\n",
        "\n",
        "dados = pd.read_csv(url_dados, compression = 'zip')\n",
        "dados"
      ],
      "execution_count": 1,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>id</th>\n",
              "      <th>tratamento</th>\n",
              "      <th>tempo</th>\n",
              "      <th>dose</th>\n",
              "      <th>droga</th>\n",
              "      <th>g-0</th>\n",
              "      <th>g-1</th>\n",
              "      <th>g-2</th>\n",
              "      <th>g-3</th>\n",
              "      <th>g-4</th>\n",
              "      <th>g-5</th>\n",
              "      <th>g-6</th>\n",
              "      <th>g-7</th>\n",
              "      <th>g-8</th>\n",
              "      <th>g-9</th>\n",
              "      <th>g-10</th>\n",
              "      <th>g-11</th>\n",
              "      <th>g-12</th>\n",
              "      <th>g-13</th>\n",
              "      <th>g-14</th>\n",
              "      <th>g-15</th>\n",
              "      <th>g-16</th>\n",
              "      <th>g-17</th>\n",
              "      <th>g-18</th>\n",
              "      <th>g-19</th>\n",
              "      <th>g-20</th>\n",
              "      <th>g-21</th>\n",
              "      <th>g-22</th>\n",
              "      <th>g-23</th>\n",
              "      <th>g-24</th>\n",
              "      <th>g-25</th>\n",
              "      <th>g-26</th>\n",
              "      <th>g-27</th>\n",
              "      <th>g-28</th>\n",
              "      <th>g-29</th>\n",
              "      <th>g-30</th>\n",
              "      <th>g-31</th>\n",
              "      <th>g-32</th>\n",
              "      <th>g-33</th>\n",
              "      <th>g-34</th>\n",
              "      <th>...</th>\n",
              "      <th>c-60</th>\n",
              "      <th>c-61</th>\n",
              "      <th>c-62</th>\n",
              "      <th>c-63</th>\n",
              "      <th>c-64</th>\n",
              "      <th>c-65</th>\n",
              "      <th>c-66</th>\n",
              "      <th>c-67</th>\n",
              "      <th>c-68</th>\n",
              "      <th>c-69</th>\n",
              "      <th>c-70</th>\n",
              "      <th>c-71</th>\n",
              "      <th>c-72</th>\n",
              "      <th>c-73</th>\n",
              "      <th>c-74</th>\n",
              "      <th>c-75</th>\n",
              "      <th>c-76</th>\n",
              "      <th>c-77</th>\n",
              "      <th>c-78</th>\n",
              "      <th>c-79</th>\n",
              "      <th>c-80</th>\n",
              "      <th>c-81</th>\n",
              "      <th>c-82</th>\n",
              "      <th>c-83</th>\n",
              "      <th>c-84</th>\n",
              "      <th>c-85</th>\n",
              "      <th>c-86</th>\n",
              "      <th>c-87</th>\n",
              "      <th>c-88</th>\n",
              "      <th>c-89</th>\n",
              "      <th>c-90</th>\n",
              "      <th>c-91</th>\n",
              "      <th>c-92</th>\n",
              "      <th>c-93</th>\n",
              "      <th>c-94</th>\n",
              "      <th>c-95</th>\n",
              "      <th>c-96</th>\n",
              "      <th>c-97</th>\n",
              "      <th>c-98</th>\n",
              "      <th>c-99</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>id_000644bb2</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>b68db1d53</td>\n",
              "      <td>1.0620</td>\n",
              "      <td>0.5577</td>\n",
              "      <td>-0.2479</td>\n",
              "      <td>-0.6208</td>\n",
              "      <td>-0.1944</td>\n",
              "      <td>-1.0120</td>\n",
              "      <td>-1.0220</td>\n",
              "      <td>-0.0326</td>\n",
              "      <td>0.5548</td>\n",
              "      <td>-0.0921</td>\n",
              "      <td>1.1830</td>\n",
              "      <td>0.1530</td>\n",
              "      <td>0.5574</td>\n",
              "      <td>-0.4015</td>\n",
              "      <td>0.1789</td>\n",
              "      <td>-0.6528</td>\n",
              "      <td>-0.7969</td>\n",
              "      <td>0.6342</td>\n",
              "      <td>0.1778</td>\n",
              "      <td>-0.3694</td>\n",
              "      <td>-0.5688</td>\n",
              "      <td>-1.1360</td>\n",
              "      <td>-1.1880</td>\n",
              "      <td>0.6940</td>\n",
              "      <td>0.4393</td>\n",
              "      <td>0.2664</td>\n",
              "      <td>0.1907</td>\n",
              "      <td>0.1628</td>\n",
              "      <td>-0.2853</td>\n",
              "      <td>0.5819</td>\n",
              "      <td>0.2934</td>\n",
              "      <td>-0.5584</td>\n",
              "      <td>-0.0916</td>\n",
              "      <td>-0.3010</td>\n",
              "      <td>-0.1537</td>\n",
              "      <td>...</td>\n",
              "      <td>0.4805</td>\n",
              "      <td>0.4965</td>\n",
              "      <td>0.3680</td>\n",
              "      <td>0.8427</td>\n",
              "      <td>0.1042</td>\n",
              "      <td>0.1403</td>\n",
              "      <td>0.1758</td>\n",
              "      <td>1.2570</td>\n",
              "      <td>-0.5979</td>\n",
              "      <td>1.2250</td>\n",
              "      <td>-0.0553</td>\n",
              "      <td>0.7351</td>\n",
              "      <td>0.5810</td>\n",
              "      <td>0.9590</td>\n",
              "      <td>0.2427</td>\n",
              "      <td>0.0495</td>\n",
              "      <td>0.4141</td>\n",
              "      <td>0.8432</td>\n",
              "      <td>0.6162</td>\n",
              "      <td>-0.7318</td>\n",
              "      <td>1.2120</td>\n",
              "      <td>0.6362</td>\n",
              "      <td>-0.4427</td>\n",
              "      <td>0.1288</td>\n",
              "      <td>1.4840</td>\n",
              "      <td>0.1799</td>\n",
              "      <td>0.5367</td>\n",
              "      <td>-0.1111</td>\n",
              "      <td>-1.0120</td>\n",
              "      <td>0.6685</td>\n",
              "      <td>0.2862</td>\n",
              "      <td>0.2584</td>\n",
              "      <td>0.8076</td>\n",
              "      <td>0.5523</td>\n",
              "      <td>-0.1912</td>\n",
              "      <td>0.6584</td>\n",
              "      <td>-0.3981</td>\n",
              "      <td>0.2139</td>\n",
              "      <td>0.3801</td>\n",
              "      <td>0.4176</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>id_000779bfc</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>72</td>\n",
              "      <td>D1</td>\n",
              "      <td>df89a8e5a</td>\n",
              "      <td>0.0743</td>\n",
              "      <td>0.4087</td>\n",
              "      <td>0.2991</td>\n",
              "      <td>0.0604</td>\n",
              "      <td>1.0190</td>\n",
              "      <td>0.5207</td>\n",
              "      <td>0.2341</td>\n",
              "      <td>0.3372</td>\n",
              "      <td>-0.4047</td>\n",
              "      <td>0.8507</td>\n",
              "      <td>-1.1520</td>\n",
              "      <td>-0.4201</td>\n",
              "      <td>-0.0958</td>\n",
              "      <td>0.4590</td>\n",
              "      <td>0.0803</td>\n",
              "      <td>0.2250</td>\n",
              "      <td>0.5293</td>\n",
              "      <td>0.2839</td>\n",
              "      <td>-0.3494</td>\n",
              "      <td>0.2883</td>\n",
              "      <td>0.9449</td>\n",
              "      <td>-0.1646</td>\n",
              "      <td>-0.2657</td>\n",
              "      <td>-0.3372</td>\n",
              "      <td>0.3135</td>\n",
              "      <td>-0.4316</td>\n",
              "      <td>0.4773</td>\n",
              "      <td>0.2075</td>\n",
              "      <td>-0.4216</td>\n",
              "      <td>-0.1161</td>\n",
              "      <td>-0.0499</td>\n",
              "      <td>-0.2627</td>\n",
              "      <td>0.9959</td>\n",
              "      <td>-0.2483</td>\n",
              "      <td>0.2655</td>\n",
              "      <td>...</td>\n",
              "      <td>0.4083</td>\n",
              "      <td>0.0319</td>\n",
              "      <td>0.3905</td>\n",
              "      <td>0.7099</td>\n",
              "      <td>0.2912</td>\n",
              "      <td>0.4151</td>\n",
              "      <td>-0.2840</td>\n",
              "      <td>-0.3104</td>\n",
              "      <td>-0.6373</td>\n",
              "      <td>0.2887</td>\n",
              "      <td>-0.0765</td>\n",
              "      <td>0.2539</td>\n",
              "      <td>0.4443</td>\n",
              "      <td>0.5932</td>\n",
              "      <td>0.2031</td>\n",
              "      <td>0.7639</td>\n",
              "      <td>0.5499</td>\n",
              "      <td>-0.3322</td>\n",
              "      <td>-0.0977</td>\n",
              "      <td>0.4329</td>\n",
              "      <td>-0.2782</td>\n",
              "      <td>0.7827</td>\n",
              "      <td>0.5934</td>\n",
              "      <td>0.3402</td>\n",
              "      <td>0.1499</td>\n",
              "      <td>0.4420</td>\n",
              "      <td>0.9366</td>\n",
              "      <td>0.8193</td>\n",
              "      <td>-0.4236</td>\n",
              "      <td>0.3192</td>\n",
              "      <td>-0.4265</td>\n",
              "      <td>0.7543</td>\n",
              "      <td>0.4708</td>\n",
              "      <td>0.0230</td>\n",
              "      <td>0.2957</td>\n",
              "      <td>0.4899</td>\n",
              "      <td>0.1522</td>\n",
              "      <td>0.1241</td>\n",
              "      <td>0.6077</td>\n",
              "      <td>0.7371</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>id_000a6266a</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>48</td>\n",
              "      <td>D1</td>\n",
              "      <td>18bb41b2c</td>\n",
              "      <td>0.6280</td>\n",
              "      <td>0.5817</td>\n",
              "      <td>1.5540</td>\n",
              "      <td>-0.0764</td>\n",
              "      <td>-0.0323</td>\n",
              "      <td>1.2390</td>\n",
              "      <td>0.1715</td>\n",
              "      <td>0.2155</td>\n",
              "      <td>0.0065</td>\n",
              "      <td>1.2300</td>\n",
              "      <td>-0.4797</td>\n",
              "      <td>-0.5631</td>\n",
              "      <td>-0.0366</td>\n",
              "      <td>-1.8300</td>\n",
              "      <td>0.6057</td>\n",
              "      <td>-0.3278</td>\n",
              "      <td>0.6042</td>\n",
              "      <td>-0.3075</td>\n",
              "      <td>-0.1147</td>\n",
              "      <td>-0.0570</td>\n",
              "      <td>-0.0799</td>\n",
              "      <td>-0.8181</td>\n",
              "      <td>-1.5320</td>\n",
              "      <td>0.2307</td>\n",
              "      <td>0.4901</td>\n",
              "      <td>0.4780</td>\n",
              "      <td>-1.3970</td>\n",
              "      <td>4.6240</td>\n",
              "      <td>-0.0437</td>\n",
              "      <td>1.2870</td>\n",
              "      <td>-1.8530</td>\n",
              "      <td>0.6069</td>\n",
              "      <td>0.4290</td>\n",
              "      <td>0.1783</td>\n",
              "      <td>0.0018</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.5477</td>\n",
              "      <td>-0.7576</td>\n",
              "      <td>-0.0444</td>\n",
              "      <td>0.1894</td>\n",
              "      <td>-0.0014</td>\n",
              "      <td>-2.3640</td>\n",
              "      <td>-0.4682</td>\n",
              "      <td>0.1210</td>\n",
              "      <td>-0.5177</td>\n",
              "      <td>-0.0604</td>\n",
              "      <td>0.1682</td>\n",
              "      <td>-0.4436</td>\n",
              "      <td>0.4963</td>\n",
              "      <td>0.1363</td>\n",
              "      <td>0.3335</td>\n",
              "      <td>0.9760</td>\n",
              "      <td>-0.0427</td>\n",
              "      <td>-0.1235</td>\n",
              "      <td>0.0959</td>\n",
              "      <td>0.0690</td>\n",
              "      <td>-0.9416</td>\n",
              "      <td>-0.7548</td>\n",
              "      <td>-0.1109</td>\n",
              "      <td>-0.6272</td>\n",
              "      <td>0.3019</td>\n",
              "      <td>0.1172</td>\n",
              "      <td>0.1093</td>\n",
              "      <td>-0.3113</td>\n",
              "      <td>0.3019</td>\n",
              "      <td>-0.0873</td>\n",
              "      <td>-0.7250</td>\n",
              "      <td>-0.6297</td>\n",
              "      <td>0.6103</td>\n",
              "      <td>0.0223</td>\n",
              "      <td>-1.3240</td>\n",
              "      <td>-0.3174</td>\n",
              "      <td>-0.6417</td>\n",
              "      <td>-0.2187</td>\n",
              "      <td>-1.4080</td>\n",
              "      <td>0.6931</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>id_0015fd391</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>48</td>\n",
              "      <td>D1</td>\n",
              "      <td>8c7f86626</td>\n",
              "      <td>-0.5138</td>\n",
              "      <td>-0.2491</td>\n",
              "      <td>-0.2656</td>\n",
              "      <td>0.5288</td>\n",
              "      <td>4.0620</td>\n",
              "      <td>-0.8095</td>\n",
              "      <td>-1.9590</td>\n",
              "      <td>0.1792</td>\n",
              "      <td>-0.1321</td>\n",
              "      <td>-1.0600</td>\n",
              "      <td>-0.8269</td>\n",
              "      <td>-0.3584</td>\n",
              "      <td>-0.8511</td>\n",
              "      <td>-0.5844</td>\n",
              "      <td>-2.5690</td>\n",
              "      <td>0.8183</td>\n",
              "      <td>-0.0532</td>\n",
              "      <td>-0.8554</td>\n",
              "      <td>0.1160</td>\n",
              "      <td>-2.3520</td>\n",
              "      <td>2.1200</td>\n",
              "      <td>-1.1580</td>\n",
              "      <td>-0.7191</td>\n",
              "      <td>-0.8004</td>\n",
              "      <td>-1.4670</td>\n",
              "      <td>-0.0107</td>\n",
              "      <td>-0.8995</td>\n",
              "      <td>0.2406</td>\n",
              "      <td>-0.2479</td>\n",
              "      <td>-1.0890</td>\n",
              "      <td>-0.7575</td>\n",
              "      <td>0.0881</td>\n",
              "      <td>-2.7370</td>\n",
              "      <td>0.8745</td>\n",
              "      <td>0.5787</td>\n",
              "      <td>...</td>\n",
              "      <td>-2.1220</td>\n",
              "      <td>-0.3752</td>\n",
              "      <td>-2.3820</td>\n",
              "      <td>-3.7350</td>\n",
              "      <td>-2.9740</td>\n",
              "      <td>-1.4930</td>\n",
              "      <td>-1.6600</td>\n",
              "      <td>-3.1660</td>\n",
              "      <td>0.2816</td>\n",
              "      <td>-0.2990</td>\n",
              "      <td>-1.1870</td>\n",
              "      <td>-0.5044</td>\n",
              "      <td>-1.7750</td>\n",
              "      <td>-1.6120</td>\n",
              "      <td>-0.9215</td>\n",
              "      <td>-1.0810</td>\n",
              "      <td>-3.0520</td>\n",
              "      <td>-3.4470</td>\n",
              "      <td>-2.7740</td>\n",
              "      <td>-1.8460</td>\n",
              "      <td>-0.5568</td>\n",
              "      <td>-3.3960</td>\n",
              "      <td>-2.9510</td>\n",
              "      <td>-1.1550</td>\n",
              "      <td>-3.2620</td>\n",
              "      <td>-1.5390</td>\n",
              "      <td>-2.4600</td>\n",
              "      <td>-0.9417</td>\n",
              "      <td>-1.5550</td>\n",
              "      <td>0.2431</td>\n",
              "      <td>-2.0990</td>\n",
              "      <td>-0.6441</td>\n",
              "      <td>-5.6300</td>\n",
              "      <td>-1.3780</td>\n",
              "      <td>-0.8632</td>\n",
              "      <td>-1.2880</td>\n",
              "      <td>-1.6210</td>\n",
              "      <td>-0.8784</td>\n",
              "      <td>-0.3876</td>\n",
              "      <td>-0.8154</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>id_001626bd3</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>72</td>\n",
              "      <td>D2</td>\n",
              "      <td>7cbed3131</td>\n",
              "      <td>-0.3254</td>\n",
              "      <td>-0.4009</td>\n",
              "      <td>0.9700</td>\n",
              "      <td>0.6919</td>\n",
              "      <td>1.4180</td>\n",
              "      <td>-0.8244</td>\n",
              "      <td>-0.2800</td>\n",
              "      <td>-0.1498</td>\n",
              "      <td>-0.8789</td>\n",
              "      <td>0.8630</td>\n",
              "      <td>-0.2219</td>\n",
              "      <td>-0.5121</td>\n",
              "      <td>-0.9577</td>\n",
              "      <td>1.1750</td>\n",
              "      <td>0.2042</td>\n",
              "      <td>0.1970</td>\n",
              "      <td>0.1244</td>\n",
              "      <td>-1.7090</td>\n",
              "      <td>-0.3543</td>\n",
              "      <td>-0.5160</td>\n",
              "      <td>-0.3330</td>\n",
              "      <td>-0.2685</td>\n",
              "      <td>0.7649</td>\n",
              "      <td>0.2057</td>\n",
              "      <td>1.3720</td>\n",
              "      <td>0.6835</td>\n",
              "      <td>0.8056</td>\n",
              "      <td>-0.3754</td>\n",
              "      <td>-1.2090</td>\n",
              "      <td>0.2965</td>\n",
              "      <td>-0.0712</td>\n",
              "      <td>0.6389</td>\n",
              "      <td>0.6674</td>\n",
              "      <td>-0.0783</td>\n",
              "      <td>1.1740</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.2274</td>\n",
              "      <td>0.3215</td>\n",
              "      <td>0.1535</td>\n",
              "      <td>-0.4640</td>\n",
              "      <td>-0.5943</td>\n",
              "      <td>0.3973</td>\n",
              "      <td>0.1500</td>\n",
              "      <td>0.5178</td>\n",
              "      <td>0.5159</td>\n",
              "      <td>0.6091</td>\n",
              "      <td>0.1813</td>\n",
              "      <td>-0.4249</td>\n",
              "      <td>0.7832</td>\n",
              "      <td>0.6529</td>\n",
              "      <td>0.5648</td>\n",
              "      <td>0.4817</td>\n",
              "      <td>0.0587</td>\n",
              "      <td>0.5303</td>\n",
              "      <td>0.6376</td>\n",
              "      <td>-0.3966</td>\n",
              "      <td>-1.4950</td>\n",
              "      <td>-0.9625</td>\n",
              "      <td>-0.0541</td>\n",
              "      <td>0.6273</td>\n",
              "      <td>0.4563</td>\n",
              "      <td>0.0698</td>\n",
              "      <td>0.8134</td>\n",
              "      <td>0.1924</td>\n",
              "      <td>0.6054</td>\n",
              "      <td>-0.1824</td>\n",
              "      <td>0.0042</td>\n",
              "      <td>0.0048</td>\n",
              "      <td>0.6670</td>\n",
              "      <td>1.0690</td>\n",
              "      <td>0.5523</td>\n",
              "      <td>-0.3031</td>\n",
              "      <td>0.1094</td>\n",
              "      <td>0.2885</td>\n",
              "      <td>-0.3786</td>\n",
              "      <td>0.7125</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",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23809</th>\n",
              "      <td>id_fffb1ceed</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D2</td>\n",
              "      <td>df1d0a5a1</td>\n",
              "      <td>0.1394</td>\n",
              "      <td>-0.0636</td>\n",
              "      <td>-0.1112</td>\n",
              "      <td>-0.5080</td>\n",
              "      <td>-0.4713</td>\n",
              "      <td>0.7201</td>\n",
              "      <td>0.5773</td>\n",
              "      <td>0.3055</td>\n",
              "      <td>-0.4726</td>\n",
              "      <td>0.1269</td>\n",
              "      <td>0.2531</td>\n",
              "      <td>0.1730</td>\n",
              "      <td>-0.4532</td>\n",
              "      <td>-1.0790</td>\n",
              "      <td>0.2474</td>\n",
              "      <td>-0.4550</td>\n",
              "      <td>0.3588</td>\n",
              "      <td>0.1600</td>\n",
              "      <td>-0.7362</td>\n",
              "      <td>-0.1103</td>\n",
              "      <td>0.8550</td>\n",
              "      <td>-0.4139</td>\n",
              "      <td>0.5541</td>\n",
              "      <td>0.2310</td>\n",
              "      <td>-0.5573</td>\n",
              "      <td>-0.4397</td>\n",
              "      <td>-0.9260</td>\n",
              "      <td>-0.2424</td>\n",
              "      <td>-0.6686</td>\n",
              "      <td>0.2326</td>\n",
              "      <td>0.6456</td>\n",
              "      <td>0.0136</td>\n",
              "      <td>-0.5141</td>\n",
              "      <td>-0.6320</td>\n",
              "      <td>0.7166</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0807</td>\n",
              "      <td>0.4024</td>\n",
              "      <td>-0.0895</td>\n",
              "      <td>0.4420</td>\n",
              "      <td>0.9641</td>\n",
              "      <td>-0.1846</td>\n",
              "      <td>-0.0014</td>\n",
              "      <td>0.3154</td>\n",
              "      <td>-0.2071</td>\n",
              "      <td>-0.6158</td>\n",
              "      <td>-0.2977</td>\n",
              "      <td>0.0992</td>\n",
              "      <td>0.6838</td>\n",
              "      <td>0.5259</td>\n",
              "      <td>0.7882</td>\n",
              "      <td>0.3119</td>\n",
              "      <td>-0.7697</td>\n",
              "      <td>0.2203</td>\n",
              "      <td>-1.0710</td>\n",
              "      <td>0.5979</td>\n",
              "      <td>0.0848</td>\n",
              "      <td>-0.2555</td>\n",
              "      <td>0.6293</td>\n",
              "      <td>1.1660</td>\n",
              "      <td>0.3329</td>\n",
              "      <td>0.2754</td>\n",
              "      <td>0.4108</td>\n",
              "      <td>-0.1252</td>\n",
              "      <td>-0.2340</td>\n",
              "      <td>0.2267</td>\n",
              "      <td>0.1969</td>\n",
              "      <td>0.0262</td>\n",
              "      <td>-0.8121</td>\n",
              "      <td>0.3434</td>\n",
              "      <td>0.5372</td>\n",
              "      <td>-0.3246</td>\n",
              "      <td>0.0631</td>\n",
              "      <td>0.9171</td>\n",
              "      <td>0.5258</td>\n",
              "      <td>0.4680</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23810</th>\n",
              "      <td>id_fffb70c0c</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D2</td>\n",
              "      <td>ecf3b6b74</td>\n",
              "      <td>-1.3260</td>\n",
              "      <td>0.3478</td>\n",
              "      <td>-0.3743</td>\n",
              "      <td>0.9905</td>\n",
              "      <td>-0.7178</td>\n",
              "      <td>0.6621</td>\n",
              "      <td>-0.2252</td>\n",
              "      <td>-0.5565</td>\n",
              "      <td>0.5112</td>\n",
              "      <td>0.6727</td>\n",
              "      <td>-0.1851</td>\n",
              "      <td>2.8650</td>\n",
              "      <td>-0.2140</td>\n",
              "      <td>-0.6153</td>\n",
              "      <td>0.8362</td>\n",
              "      <td>0.5584</td>\n",
              "      <td>-0.2589</td>\n",
              "      <td>0.1292</td>\n",
              "      <td>0.0148</td>\n",
              "      <td>0.0949</td>\n",
              "      <td>-0.2182</td>\n",
              "      <td>-0.9235</td>\n",
              "      <td>0.0749</td>\n",
              "      <td>-1.5910</td>\n",
              "      <td>-0.8359</td>\n",
              "      <td>-0.9217</td>\n",
              "      <td>0.3013</td>\n",
              "      <td>0.1716</td>\n",
              "      <td>0.0880</td>\n",
              "      <td>0.1842</td>\n",
              "      <td>0.1835</td>\n",
              "      <td>0.5436</td>\n",
              "      <td>-0.0533</td>\n",
              "      <td>-0.0491</td>\n",
              "      <td>0.9543</td>\n",
              "      <td>...</td>\n",
              "      <td>0.1410</td>\n",
              "      <td>1.2640</td>\n",
              "      <td>-0.8663</td>\n",
              "      <td>0.8129</td>\n",
              "      <td>-0.1514</td>\n",
              "      <td>-0.4652</td>\n",
              "      <td>-0.7390</td>\n",
              "      <td>-1.3270</td>\n",
              "      <td>0.9925</td>\n",
              "      <td>1.0570</td>\n",
              "      <td>-0.3355</td>\n",
              "      <td>-0.2555</td>\n",
              "      <td>0.8219</td>\n",
              "      <td>0.6995</td>\n",
              "      <td>-0.2942</td>\n",
              "      <td>0.2408</td>\n",
              "      <td>-0.7781</td>\n",
              "      <td>-0.0929</td>\n",
              "      <td>-0.0329</td>\n",
              "      <td>0.0781</td>\n",
              "      <td>-1.4440</td>\n",
              "      <td>-0.0921</td>\n",
              "      <td>0.3188</td>\n",
              "      <td>-1.1080</td>\n",
              "      <td>0.4895</td>\n",
              "      <td>-0.2144</td>\n",
              "      <td>1.0960</td>\n",
              "      <td>0.3335</td>\n",
              "      <td>0.4444</td>\n",
              "      <td>-1.1130</td>\n",
              "      <td>0.4286</td>\n",
              "      <td>0.4426</td>\n",
              "      <td>0.0423</td>\n",
              "      <td>-0.3195</td>\n",
              "      <td>-0.8086</td>\n",
              "      <td>-0.9798</td>\n",
              "      <td>-0.2084</td>\n",
              "      <td>-0.1224</td>\n",
              "      <td>-0.2715</td>\n",
              "      <td>0.3689</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23811</th>\n",
              "      <td>id_fffc1c3f4</td>\n",
              "      <td>com_controle</td>\n",
              "      <td>48</td>\n",
              "      <td>D2</td>\n",
              "      <td>cacb2b860</td>\n",
              "      <td>0.3942</td>\n",
              "      <td>0.3756</td>\n",
              "      <td>0.3109</td>\n",
              "      <td>-0.7389</td>\n",
              "      <td>0.5505</td>\n",
              "      <td>-0.0159</td>\n",
              "      <td>-0.2541</td>\n",
              "      <td>0.1745</td>\n",
              "      <td>-0.0340</td>\n",
              "      <td>0.4865</td>\n",
              "      <td>-0.1854</td>\n",
              "      <td>0.0716</td>\n",
              "      <td>0.1729</td>\n",
              "      <td>-0.0434</td>\n",
              "      <td>0.1542</td>\n",
              "      <td>-0.2192</td>\n",
              "      <td>-0.0302</td>\n",
              "      <td>-0.4218</td>\n",
              "      <td>0.4057</td>\n",
              "      <td>-0.5372</td>\n",
              "      <td>0.1521</td>\n",
              "      <td>-0.2651</td>\n",
              "      <td>0.2310</td>\n",
              "      <td>-0.8101</td>\n",
              "      <td>0.4943</td>\n",
              "      <td>0.6905</td>\n",
              "      <td>-0.3720</td>\n",
              "      <td>-1.4110</td>\n",
              "      <td>0.4516</td>\n",
              "      <td>1.2300</td>\n",
              "      <td>-0.1949</td>\n",
              "      <td>-1.3280</td>\n",
              "      <td>-0.4276</td>\n",
              "      <td>-0.0040</td>\n",
              "      <td>-0.3086</td>\n",
              "      <td>...</td>\n",
              "      <td>0.6845</td>\n",
              "      <td>0.7127</td>\n",
              "      <td>0.7294</td>\n",
              "      <td>0.4718</td>\n",
              "      <td>-0.2020</td>\n",
              "      <td>0.2783</td>\n",
              "      <td>0.4934</td>\n",
              "      <td>0.4144</td>\n",
              "      <td>0.5449</td>\n",
              "      <td>1.4690</td>\n",
              "      <td>-0.6142</td>\n",
              "      <td>0.6068</td>\n",
              "      <td>0.3434</td>\n",
              "      <td>0.9880</td>\n",
              "      <td>-0.0468</td>\n",
              "      <td>-0.1882</td>\n",
              "      <td>-0.0087</td>\n",
              "      <td>-0.0356</td>\n",
              "      <td>0.5718</td>\n",
              "      <td>0.4971</td>\n",
              "      <td>0.1057</td>\n",
              "      <td>0.2111</td>\n",
              "      <td>0.6992</td>\n",
              "      <td>0.0708</td>\n",
              "      <td>0.6169</td>\n",
              "      <td>0.2248</td>\n",
              "      <td>0.5994</td>\n",
              "      <td>0.2689</td>\n",
              "      <td>0.0305</td>\n",
              "      <td>1.2320</td>\n",
              "      <td>0.5409</td>\n",
              "      <td>0.3755</td>\n",
              "      <td>0.7343</td>\n",
              "      <td>0.2807</td>\n",
              "      <td>0.4116</td>\n",
              "      <td>0.6422</td>\n",
              "      <td>0.2256</td>\n",
              "      <td>0.7592</td>\n",
              "      <td>0.6656</td>\n",
              "      <td>0.3808</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23812</th>\n",
              "      <td>id_fffcb9e7c</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>8b87a7a83</td>\n",
              "      <td>0.6660</td>\n",
              "      <td>0.2324</td>\n",
              "      <td>0.4392</td>\n",
              "      <td>0.2044</td>\n",
              "      <td>0.8531</td>\n",
              "      <td>-0.0343</td>\n",
              "      <td>0.0323</td>\n",
              "      <td>0.0463</td>\n",
              "      <td>0.4299</td>\n",
              "      <td>-0.7985</td>\n",
              "      <td>0.5742</td>\n",
              "      <td>0.1421</td>\n",
              "      <td>2.2700</td>\n",
              "      <td>0.2046</td>\n",
              "      <td>0.5363</td>\n",
              "      <td>-1.7330</td>\n",
              "      <td>0.1450</td>\n",
              "      <td>0.6097</td>\n",
              "      <td>0.2024</td>\n",
              "      <td>0.9865</td>\n",
              "      <td>-0.7805</td>\n",
              "      <td>0.9608</td>\n",
              "      <td>0.3440</td>\n",
              "      <td>2.7650</td>\n",
              "      <td>0.4925</td>\n",
              "      <td>0.6698</td>\n",
              "      <td>0.2374</td>\n",
              "      <td>-0.3372</td>\n",
              "      <td>0.8771</td>\n",
              "      <td>-2.6560</td>\n",
              "      <td>-0.2000</td>\n",
              "      <td>-0.2043</td>\n",
              "      <td>0.6797</td>\n",
              "      <td>-0.0248</td>\n",
              "      <td>-0.0927</td>\n",
              "      <td>...</td>\n",
              "      <td>0.3360</td>\n",
              "      <td>-0.6136</td>\n",
              "      <td>0.5011</td>\n",
              "      <td>0.9261</td>\n",
              "      <td>0.4419</td>\n",
              "      <td>0.0295</td>\n",
              "      <td>0.4220</td>\n",
              "      <td>0.4677</td>\n",
              "      <td>-0.1184</td>\n",
              "      <td>0.4524</td>\n",
              "      <td>0.4135</td>\n",
              "      <td>0.1356</td>\n",
              "      <td>-0.5801</td>\n",
              "      <td>0.0411</td>\n",
              "      <td>1.0240</td>\n",
              "      <td>1.0340</td>\n",
              "      <td>-0.0270</td>\n",
              "      <td>-0.4194</td>\n",
              "      <td>0.7403</td>\n",
              "      <td>-0.6793</td>\n",
              "      <td>-0.1423</td>\n",
              "      <td>0.7307</td>\n",
              "      <td>0.7946</td>\n",
              "      <td>-0.0650</td>\n",
              "      <td>0.9038</td>\n",
              "      <td>0.2324</td>\n",
              "      <td>0.9676</td>\n",
              "      <td>1.0940</td>\n",
              "      <td>0.4290</td>\n",
              "      <td>0.5187</td>\n",
              "      <td>-0.1105</td>\n",
              "      <td>0.4258</td>\n",
              "      <td>-0.2012</td>\n",
              "      <td>0.1506</td>\n",
              "      <td>1.5230</td>\n",
              "      <td>0.7101</td>\n",
              "      <td>0.1732</td>\n",
              "      <td>0.7015</td>\n",
              "      <td>-0.6290</td>\n",
              "      <td>0.0740</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23813</th>\n",
              "      <td>id_ffffdd77b</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>72</td>\n",
              "      <td>D1</td>\n",
              "      <td>972f41291</td>\n",
              "      <td>-0.8598</td>\n",
              "      <td>1.0240</td>\n",
              "      <td>-0.1361</td>\n",
              "      <td>0.7952</td>\n",
              "      <td>-0.3611</td>\n",
              "      <td>-3.6750</td>\n",
              "      <td>-1.2420</td>\n",
              "      <td>0.9146</td>\n",
              "      <td>3.0790</td>\n",
              "      <td>1.2460</td>\n",
              "      <td>1.9460</td>\n",
              "      <td>1.4370</td>\n",
              "      <td>2.9780</td>\n",
              "      <td>2.2370</td>\n",
              "      <td>-0.6818</td>\n",
              "      <td>0.6870</td>\n",
              "      <td>-1.1060</td>\n",
              "      <td>0.0182</td>\n",
              "      <td>-0.9247</td>\n",
              "      <td>-0.0738</td>\n",
              "      <td>-0.1919</td>\n",
              "      <td>-0.7722</td>\n",
              "      <td>-1.4050</td>\n",
              "      <td>-1.0050</td>\n",
              "      <td>-1.1170</td>\n",
              "      <td>-0.5293</td>\n",
              "      <td>-1.1720</td>\n",
              "      <td>-0.2885</td>\n",
              "      <td>0.1599</td>\n",
              "      <td>-0.4250</td>\n",
              "      <td>0.3591</td>\n",
              "      <td>-0.1420</td>\n",
              "      <td>-0.9530</td>\n",
              "      <td>-0.2005</td>\n",
              "      <td>-1.8340</td>\n",
              "      <td>...</td>\n",
              "      <td>-6.9170</td>\n",
              "      <td>-1.8640</td>\n",
              "      <td>-2.5090</td>\n",
              "      <td>-4.7130</td>\n",
              "      <td>-1.7250</td>\n",
              "      <td>-3.8650</td>\n",
              "      <td>-3.0800</td>\n",
              "      <td>-4.1530</td>\n",
              "      <td>-1.2030</td>\n",
              "      <td>-1.1690</td>\n",
              "      <td>-4.1460</td>\n",
              "      <td>-1.2670</td>\n",
              "      <td>-1.1300</td>\n",
              "      <td>-2.4390</td>\n",
              "      <td>0.1591</td>\n",
              "      <td>-2.2490</td>\n",
              "      <td>-2.5860</td>\n",
              "      <td>-1.9520</td>\n",
              "      <td>-2.1810</td>\n",
              "      <td>-4.6690</td>\n",
              "      <td>-3.9450</td>\n",
              "      <td>-2.9560</td>\n",
              "      <td>-2.7930</td>\n",
              "      <td>-2.1560</td>\n",
              "      <td>-2.4100</td>\n",
              "      <td>-1.8190</td>\n",
              "      <td>-3.3480</td>\n",
              "      <td>-0.1414</td>\n",
              "      <td>-2.6430</td>\n",
              "      <td>-2.5810</td>\n",
              "      <td>-3.3890</td>\n",
              "      <td>-1.7450</td>\n",
              "      <td>-6.6300</td>\n",
              "      <td>-4.0950</td>\n",
              "      <td>-7.3860</td>\n",
              "      <td>-1.4160</td>\n",
              "      <td>-3.5770</td>\n",
              "      <td>-0.4775</td>\n",
              "      <td>-2.1500</td>\n",
              "      <td>-4.2520</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>23814 rows × 877 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                 id    tratamento  tempo dose  ...    c-96    c-97    c-98    c-99\n",
              "0      id_000644bb2     com_droga     24   D1  ... -0.3981  0.2139  0.3801  0.4176\n",
              "1      id_000779bfc     com_droga     72   D1  ...  0.1522  0.1241  0.6077  0.7371\n",
              "2      id_000a6266a     com_droga     48   D1  ... -0.6417 -0.2187 -1.4080  0.6931\n",
              "3      id_0015fd391     com_droga     48   D1  ... -1.6210 -0.8784 -0.3876 -0.8154\n",
              "4      id_001626bd3     com_droga     72   D2  ...  0.1094  0.2885 -0.3786  0.7125\n",
              "...             ...           ...    ...  ...  ...     ...     ...     ...     ...\n",
              "23809  id_fffb1ceed     com_droga     24   D2  ...  0.0631  0.9171  0.5258  0.4680\n",
              "23810  id_fffb70c0c     com_droga     24   D2  ... -0.2084 -0.1224 -0.2715  0.3689\n",
              "23811  id_fffc1c3f4  com_controle     48   D2  ...  0.2256  0.7592  0.6656  0.3808\n",
              "23812  id_fffcb9e7c     com_droga     24   D1  ...  0.1732  0.7015 -0.6290  0.0740\n",
              "23813  id_ffffdd77b     com_droga     72   D1  ... -3.5770 -0.4775 -2.1500 -4.2520\n",
              "\n",
              "[23814 rows x 877 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 1
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 270
        },
        "id": "YNUM8kXhdh5g",
        "outputId": "a2e45cc2-5f60-43a1-94b7-2ca86e1fd8f5"
      },
      "source": [
        "dados_resultados = pd.read_csv('https://github.com/alura-cursos/imersaodados3/blob/main/dados/dados_resultados.csv?raw=true')\n",
        "dados_resultados.head()"
      ],
      "execution_count": 2,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>id</th>\n",
              "      <th>5-alpha_reductase_inhibitor</th>\n",
              "      <th>11-beta-hsd1_inhibitor</th>\n",
              "      <th>acat_inhibitor</th>\n",
              "      <th>acetylcholine_receptor_agonist</th>\n",
              "      <th>acetylcholine_receptor_antagonist</th>\n",
              "      <th>acetylcholinesterase_inhibitor</th>\n",
              "      <th>adenosine_receptor_agonist</th>\n",
              "      <th>adenosine_receptor_antagonist</th>\n",
              "      <th>adenylyl_cyclase_activator</th>\n",
              "      <th>adrenergic_receptor_agonist</th>\n",
              "      <th>adrenergic_receptor_antagonist</th>\n",
              "      <th>akt_inhibitor</th>\n",
              "      <th>aldehyde_dehydrogenase_inhibitor</th>\n",
              "      <th>alk_inhibitor</th>\n",
              "      <th>ampk_activator</th>\n",
              "      <th>analgesic</th>\n",
              "      <th>androgen_receptor_agonist</th>\n",
              "      <th>androgen_receptor_antagonist</th>\n",
              "      <th>anesthetic_-_local</th>\n",
              "      <th>angiogenesis_inhibitor</th>\n",
              "      <th>angiotensin_receptor_antagonist</th>\n",
              "      <th>anti-inflammatory</th>\n",
              "      <th>antiarrhythmic</th>\n",
              "      <th>antibiotic</th>\n",
              "      <th>anticonvulsant</th>\n",
              "      <th>antifungal</th>\n",
              "      <th>antihistamine</th>\n",
              "      <th>antimalarial</th>\n",
              "      <th>antioxidant</th>\n",
              "      <th>antiprotozoal</th>\n",
              "      <th>antiviral</th>\n",
              "      <th>apoptosis_stimulant</th>\n",
              "      <th>aromatase_inhibitor</th>\n",
              "      <th>atm_kinase_inhibitor</th>\n",
              "      <th>atp-sensitive_potassium_channel_antagonist</th>\n",
              "      <th>atp_synthase_inhibitor</th>\n",
              "      <th>atpase_inhibitor</th>\n",
              "      <th>atr_kinase_inhibitor</th>\n",
              "      <th>aurora_kinase_inhibitor</th>\n",
              "      <th>...</th>\n",
              "      <th>protein_synthesis_inhibitor</th>\n",
              "      <th>protein_tyrosine_kinase_inhibitor</th>\n",
              "      <th>radiopaque_medium</th>\n",
              "      <th>raf_inhibitor</th>\n",
              "      <th>ras_gtpase_inhibitor</th>\n",
              "      <th>retinoid_receptor_agonist</th>\n",
              "      <th>retinoid_receptor_antagonist</th>\n",
              "      <th>rho_associated_kinase_inhibitor</th>\n",
              "      <th>ribonucleoside_reductase_inhibitor</th>\n",
              "      <th>rna_polymerase_inhibitor</th>\n",
              "      <th>serotonin_receptor_agonist</th>\n",
              "      <th>serotonin_receptor_antagonist</th>\n",
              "      <th>serotonin_reuptake_inhibitor</th>\n",
              "      <th>sigma_receptor_agonist</th>\n",
              "      <th>sigma_receptor_antagonist</th>\n",
              "      <th>smoothened_receptor_antagonist</th>\n",
              "      <th>sodium_channel_inhibitor</th>\n",
              "      <th>sphingosine_receptor_agonist</th>\n",
              "      <th>src_inhibitor</th>\n",
              "      <th>steroid</th>\n",
              "      <th>syk_inhibitor</th>\n",
              "      <th>tachykinin_antagonist</th>\n",
              "      <th>tgf-beta_receptor_inhibitor</th>\n",
              "      <th>thrombin_inhibitor</th>\n",
              "      <th>thymidylate_synthase_inhibitor</th>\n",
              "      <th>tlr_agonist</th>\n",
              "      <th>tlr_antagonist</th>\n",
              "      <th>tnf_inhibitor</th>\n",
              "      <th>topoisomerase_inhibitor</th>\n",
              "      <th>transient_receptor_potential_channel_antagonist</th>\n",
              "      <th>tropomyosin_receptor_kinase_inhibitor</th>\n",
              "      <th>trpv_agonist</th>\n",
              "      <th>trpv_antagonist</th>\n",
              "      <th>tubulin_inhibitor</th>\n",
              "      <th>tyrosine_kinase_inhibitor</th>\n",
              "      <th>ubiquitin_specific_protease_inhibitor</th>\n",
              "      <th>vegfr_inhibitor</th>\n",
              "      <th>vitamin_b</th>\n",
              "      <th>vitamin_d_receptor_agonist</th>\n",
              "      <th>wnt_inhibitor</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>id_000644bb2</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>id_000779bfc</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>id_000a6266a</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>id_0015fd391</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>id_001626bd3</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 207 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "             id  ...  wnt_inhibitor\n",
              "0  id_000644bb2  ...              0\n",
              "1  id_000779bfc  ...              0\n",
              "2  id_000a6266a  ...              0\n",
              "3  id_0015fd391  ...              0\n",
              "4  id_001626bd3  ...              0\n",
              "\n",
              "[5 rows x 207 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 2
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "UOl0p0bZdkFQ",
        "outputId": "aa98812a-21ee-440f-b809-612f9cc5dd4d"
      },
      "source": [
        "dados_resultados.info()"
      ],
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 23814 entries, 0 to 23813\n",
            "Columns: 207 entries, id to wnt_inhibitor\n",
            "dtypes: int64(206), object(1)\n",
            "memory usage: 37.6+ MB\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "m99QXbVzdnMU",
        "outputId": "69367ea3-011f-4c2a-8d74-6671a6f9575c"
      },
      "source": [
        "contagem_moa = dados_resultados.drop('id', axis=1).sum().sort_values(ascending=False)\n",
        "contagem_moa"
      ],
      "execution_count": 4,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "nfkb_inhibitor                                832\n",
              "proteasome_inhibitor                          726\n",
              "cyclooxygenase_inhibitor                      435\n",
              "dopamine_receptor_antagonist                  424\n",
              "serotonin_receptor_antagonist                 404\n",
              "                                             ... \n",
              "protein_phosphatase_inhibitor                   6\n",
              "autotaxin_inhibitor                             6\n",
              "diuretic                                        6\n",
              "erbb2_inhibitor                                 1\n",
              "atp-sensitive_potassium_channel_antagonist      1\n",
              "Length: 206, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 4
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "PNxmd_LXdqog",
        "outputId": "162c2213-6834-4f7a-c80e-b270cebd26b6"
      },
      "source": [
        "dados_resultados.drop('id', axis=1).sum(axis=1)"
      ],
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "0        1\n",
              "1        0\n",
              "2        3\n",
              "3        0\n",
              "4        1\n",
              "        ..\n",
              "23809    1\n",
              "23810    1\n",
              "23811    0\n",
              "23812    1\n",
              "23813    0\n",
              "Length: 23814, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "LPySSHWHdzhl"
      },
      "source": [
        "dados_resultados['n_moa'] = dados_resultados.drop('id', axis=1).sum(axis=1)"
      ],
      "execution_count": 7,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 270
        },
        "id": "x9Zuzm11duqC",
        "outputId": "309780eb-427f-44c6-e45b-ac28286a0d8d"
      },
      "source": [
        "dados_resultados['ativo_moa'] = (dados_resultados['n_moa'] != 0)\n",
        "dados_resultados.head()"
      ],
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>id</th>\n",
              "      <th>5-alpha_reductase_inhibitor</th>\n",
              "      <th>11-beta-hsd1_inhibitor</th>\n",
              "      <th>acat_inhibitor</th>\n",
              "      <th>acetylcholine_receptor_agonist</th>\n",
              "      <th>acetylcholine_receptor_antagonist</th>\n",
              "      <th>acetylcholinesterase_inhibitor</th>\n",
              "      <th>adenosine_receptor_agonist</th>\n",
              "      <th>adenosine_receptor_antagonist</th>\n",
              "      <th>adenylyl_cyclase_activator</th>\n",
              "      <th>adrenergic_receptor_agonist</th>\n",
              "      <th>adrenergic_receptor_antagonist</th>\n",
              "      <th>akt_inhibitor</th>\n",
              "      <th>aldehyde_dehydrogenase_inhibitor</th>\n",
              "      <th>alk_inhibitor</th>\n",
              "      <th>ampk_activator</th>\n",
              "      <th>analgesic</th>\n",
              "      <th>androgen_receptor_agonist</th>\n",
              "      <th>androgen_receptor_antagonist</th>\n",
              "      <th>anesthetic_-_local</th>\n",
              "      <th>angiogenesis_inhibitor</th>\n",
              "      <th>angiotensin_receptor_antagonist</th>\n",
              "      <th>anti-inflammatory</th>\n",
              "      <th>antiarrhythmic</th>\n",
              "      <th>antibiotic</th>\n",
              "      <th>anticonvulsant</th>\n",
              "      <th>antifungal</th>\n",
              "      <th>antihistamine</th>\n",
              "      <th>antimalarial</th>\n",
              "      <th>antioxidant</th>\n",
              "      <th>antiprotozoal</th>\n",
              "      <th>antiviral</th>\n",
              "      <th>apoptosis_stimulant</th>\n",
              "      <th>aromatase_inhibitor</th>\n",
              "      <th>atm_kinase_inhibitor</th>\n",
              "      <th>atp-sensitive_potassium_channel_antagonist</th>\n",
              "      <th>atp_synthase_inhibitor</th>\n",
              "      <th>atpase_inhibitor</th>\n",
              "      <th>atr_kinase_inhibitor</th>\n",
              "      <th>aurora_kinase_inhibitor</th>\n",
              "      <th>...</th>\n",
              "      <th>radiopaque_medium</th>\n",
              "      <th>raf_inhibitor</th>\n",
              "      <th>ras_gtpase_inhibitor</th>\n",
              "      <th>retinoid_receptor_agonist</th>\n",
              "      <th>retinoid_receptor_antagonist</th>\n",
              "      <th>rho_associated_kinase_inhibitor</th>\n",
              "      <th>ribonucleoside_reductase_inhibitor</th>\n",
              "      <th>rna_polymerase_inhibitor</th>\n",
              "      <th>serotonin_receptor_agonist</th>\n",
              "      <th>serotonin_receptor_antagonist</th>\n",
              "      <th>serotonin_reuptake_inhibitor</th>\n",
              "      <th>sigma_receptor_agonist</th>\n",
              "      <th>sigma_receptor_antagonist</th>\n",
              "      <th>smoothened_receptor_antagonist</th>\n",
              "      <th>sodium_channel_inhibitor</th>\n",
              "      <th>sphingosine_receptor_agonist</th>\n",
              "      <th>src_inhibitor</th>\n",
              "      <th>steroid</th>\n",
              "      <th>syk_inhibitor</th>\n",
              "      <th>tachykinin_antagonist</th>\n",
              "      <th>tgf-beta_receptor_inhibitor</th>\n",
              "      <th>thrombin_inhibitor</th>\n",
              "      <th>thymidylate_synthase_inhibitor</th>\n",
              "      <th>tlr_agonist</th>\n",
              "      <th>tlr_antagonist</th>\n",
              "      <th>tnf_inhibitor</th>\n",
              "      <th>topoisomerase_inhibitor</th>\n",
              "      <th>transient_receptor_potential_channel_antagonist</th>\n",
              "      <th>tropomyosin_receptor_kinase_inhibitor</th>\n",
              "      <th>trpv_agonist</th>\n",
              "      <th>trpv_antagonist</th>\n",
              "      <th>tubulin_inhibitor</th>\n",
              "      <th>tyrosine_kinase_inhibitor</th>\n",
              "      <th>ubiquitin_specific_protease_inhibitor</th>\n",
              "      <th>vegfr_inhibitor</th>\n",
              "      <th>vitamin_b</th>\n",
              "      <th>vitamin_d_receptor_agonist</th>\n",
              "      <th>wnt_inhibitor</th>\n",
              "      <th>n_moa</th>\n",
              "      <th>ativo_moa</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>id_000644bb2</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>id_000779bfc</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>id_000a6266a</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>3</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>id_0015fd391</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>id_001626bd3</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 209 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "             id  5-alpha_reductase_inhibitor  ...  n_moa  ativo_moa\n",
              "0  id_000644bb2                            0  ...      1       True\n",
              "1  id_000779bfc                            0  ...      0      False\n",
              "2  id_000a6266a                            0  ...      3       True\n",
              "3  id_0015fd391                            0  ...      0      False\n",
              "4  id_001626bd3                            0  ...      1       True\n",
              "\n",
              "[5 rows x 209 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 253
        },
        "id": "pMEi59Ydd3Xl",
        "outputId": "afb637a4-d2ad-48ca-b69e-c8c83dfa2428"
      },
      "source": [
        " dados_combinados = pd.merge(dados, dados_resultados[['id','n_moa', 'ativo_moa']], on='id')\n",
        " dados_combinados.head()"
      ],
      "execution_count": 9,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>id</th>\n",
              "      <th>tratamento</th>\n",
              "      <th>tempo</th>\n",
              "      <th>dose</th>\n",
              "      <th>droga</th>\n",
              "      <th>g-0</th>\n",
              "      <th>g-1</th>\n",
              "      <th>g-2</th>\n",
              "      <th>g-3</th>\n",
              "      <th>g-4</th>\n",
              "      <th>g-5</th>\n",
              "      <th>g-6</th>\n",
              "      <th>g-7</th>\n",
              "      <th>g-8</th>\n",
              "      <th>g-9</th>\n",
              "      <th>g-10</th>\n",
              "      <th>g-11</th>\n",
              "      <th>g-12</th>\n",
              "      <th>g-13</th>\n",
              "      <th>g-14</th>\n",
              "      <th>g-15</th>\n",
              "      <th>g-16</th>\n",
              "      <th>g-17</th>\n",
              "      <th>g-18</th>\n",
              "      <th>g-19</th>\n",
              "      <th>g-20</th>\n",
              "      <th>g-21</th>\n",
              "      <th>g-22</th>\n",
              "      <th>g-23</th>\n",
              "      <th>g-24</th>\n",
              "      <th>g-25</th>\n",
              "      <th>g-26</th>\n",
              "      <th>g-27</th>\n",
              "      <th>g-28</th>\n",
              "      <th>g-29</th>\n",
              "      <th>g-30</th>\n",
              "      <th>g-31</th>\n",
              "      <th>g-32</th>\n",
              "      <th>g-33</th>\n",
              "      <th>g-34</th>\n",
              "      <th>...</th>\n",
              "      <th>c-62</th>\n",
              "      <th>c-63</th>\n",
              "      <th>c-64</th>\n",
              "      <th>c-65</th>\n",
              "      <th>c-66</th>\n",
              "      <th>c-67</th>\n",
              "      <th>c-68</th>\n",
              "      <th>c-69</th>\n",
              "      <th>c-70</th>\n",
              "      <th>c-71</th>\n",
              "      <th>c-72</th>\n",
              "      <th>c-73</th>\n",
              "      <th>c-74</th>\n",
              "      <th>c-75</th>\n",
              "      <th>c-76</th>\n",
              "      <th>c-77</th>\n",
              "      <th>c-78</th>\n",
              "      <th>c-79</th>\n",
              "      <th>c-80</th>\n",
              "      <th>c-81</th>\n",
              "      <th>c-82</th>\n",
              "      <th>c-83</th>\n",
              "      <th>c-84</th>\n",
              "      <th>c-85</th>\n",
              "      <th>c-86</th>\n",
              "      <th>c-87</th>\n",
              "      <th>c-88</th>\n",
              "      <th>c-89</th>\n",
              "      <th>c-90</th>\n",
              "      <th>c-91</th>\n",
              "      <th>c-92</th>\n",
              "      <th>c-93</th>\n",
              "      <th>c-94</th>\n",
              "      <th>c-95</th>\n",
              "      <th>c-96</th>\n",
              "      <th>c-97</th>\n",
              "      <th>c-98</th>\n",
              "      <th>c-99</th>\n",
              "      <th>n_moa</th>\n",
              "      <th>ativo_moa</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>id_000644bb2</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>b68db1d53</td>\n",
              "      <td>1.0620</td>\n",
              "      <td>0.5577</td>\n",
              "      <td>-0.2479</td>\n",
              "      <td>-0.6208</td>\n",
              "      <td>-0.1944</td>\n",
              "      <td>-1.0120</td>\n",
              "      <td>-1.0220</td>\n",
              "      <td>-0.0326</td>\n",
              "      <td>0.5548</td>\n",
              "      <td>-0.0921</td>\n",
              "      <td>1.1830</td>\n",
              "      <td>0.1530</td>\n",
              "      <td>0.5574</td>\n",
              "      <td>-0.4015</td>\n",
              "      <td>0.1789</td>\n",
              "      <td>-0.6528</td>\n",
              "      <td>-0.7969</td>\n",
              "      <td>0.6342</td>\n",
              "      <td>0.1778</td>\n",
              "      <td>-0.3694</td>\n",
              "      <td>-0.5688</td>\n",
              "      <td>-1.1360</td>\n",
              "      <td>-1.1880</td>\n",
              "      <td>0.6940</td>\n",
              "      <td>0.4393</td>\n",
              "      <td>0.2664</td>\n",
              "      <td>0.1907</td>\n",
              "      <td>0.1628</td>\n",
              "      <td>-0.2853</td>\n",
              "      <td>0.5819</td>\n",
              "      <td>0.2934</td>\n",
              "      <td>-0.5584</td>\n",
              "      <td>-0.0916</td>\n",
              "      <td>-0.3010</td>\n",
              "      <td>-0.1537</td>\n",
              "      <td>...</td>\n",
              "      <td>0.3680</td>\n",
              "      <td>0.8427</td>\n",
              "      <td>0.1042</td>\n",
              "      <td>0.1403</td>\n",
              "      <td>0.1758</td>\n",
              "      <td>1.2570</td>\n",
              "      <td>-0.5979</td>\n",
              "      <td>1.2250</td>\n",
              "      <td>-0.0553</td>\n",
              "      <td>0.7351</td>\n",
              "      <td>0.5810</td>\n",
              "      <td>0.9590</td>\n",
              "      <td>0.2427</td>\n",
              "      <td>0.0495</td>\n",
              "      <td>0.4141</td>\n",
              "      <td>0.8432</td>\n",
              "      <td>0.6162</td>\n",
              "      <td>-0.7318</td>\n",
              "      <td>1.2120</td>\n",
              "      <td>0.6362</td>\n",
              "      <td>-0.4427</td>\n",
              "      <td>0.1288</td>\n",
              "      <td>1.4840</td>\n",
              "      <td>0.1799</td>\n",
              "      <td>0.5367</td>\n",
              "      <td>-0.1111</td>\n",
              "      <td>-1.0120</td>\n",
              "      <td>0.6685</td>\n",
              "      <td>0.2862</td>\n",
              "      <td>0.2584</td>\n",
              "      <td>0.8076</td>\n",
              "      <td>0.5523</td>\n",
              "      <td>-0.1912</td>\n",
              "      <td>0.6584</td>\n",
              "      <td>-0.3981</td>\n",
              "      <td>0.2139</td>\n",
              "      <td>0.3801</td>\n",
              "      <td>0.4176</td>\n",
              "      <td>1</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>id_000779bfc</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>72</td>\n",
              "      <td>D1</td>\n",
              "      <td>df89a8e5a</td>\n",
              "      <td>0.0743</td>\n",
              "      <td>0.4087</td>\n",
              "      <td>0.2991</td>\n",
              "      <td>0.0604</td>\n",
              "      <td>1.0190</td>\n",
              "      <td>0.5207</td>\n",
              "      <td>0.2341</td>\n",
              "      <td>0.3372</td>\n",
              "      <td>-0.4047</td>\n",
              "      <td>0.8507</td>\n",
              "      <td>-1.1520</td>\n",
              "      <td>-0.4201</td>\n",
              "      <td>-0.0958</td>\n",
              "      <td>0.4590</td>\n",
              "      <td>0.0803</td>\n",
              "      <td>0.2250</td>\n",
              "      <td>0.5293</td>\n",
              "      <td>0.2839</td>\n",
              "      <td>-0.3494</td>\n",
              "      <td>0.2883</td>\n",
              "      <td>0.9449</td>\n",
              "      <td>-0.1646</td>\n",
              "      <td>-0.2657</td>\n",
              "      <td>-0.3372</td>\n",
              "      <td>0.3135</td>\n",
              "      <td>-0.4316</td>\n",
              "      <td>0.4773</td>\n",
              "      <td>0.2075</td>\n",
              "      <td>-0.4216</td>\n",
              "      <td>-0.1161</td>\n",
              "      <td>-0.0499</td>\n",
              "      <td>-0.2627</td>\n",
              "      <td>0.9959</td>\n",
              "      <td>-0.2483</td>\n",
              "      <td>0.2655</td>\n",
              "      <td>...</td>\n",
              "      <td>0.3905</td>\n",
              "      <td>0.7099</td>\n",
              "      <td>0.2912</td>\n",
              "      <td>0.4151</td>\n",
              "      <td>-0.2840</td>\n",
              "      <td>-0.3104</td>\n",
              "      <td>-0.6373</td>\n",
              "      <td>0.2887</td>\n",
              "      <td>-0.0765</td>\n",
              "      <td>0.2539</td>\n",
              "      <td>0.4443</td>\n",
              "      <td>0.5932</td>\n",
              "      <td>0.2031</td>\n",
              "      <td>0.7639</td>\n",
              "      <td>0.5499</td>\n",
              "      <td>-0.3322</td>\n",
              "      <td>-0.0977</td>\n",
              "      <td>0.4329</td>\n",
              "      <td>-0.2782</td>\n",
              "      <td>0.7827</td>\n",
              "      <td>0.5934</td>\n",
              "      <td>0.3402</td>\n",
              "      <td>0.1499</td>\n",
              "      <td>0.4420</td>\n",
              "      <td>0.9366</td>\n",
              "      <td>0.8193</td>\n",
              "      <td>-0.4236</td>\n",
              "      <td>0.3192</td>\n",
              "      <td>-0.4265</td>\n",
              "      <td>0.7543</td>\n",
              "      <td>0.4708</td>\n",
              "      <td>0.0230</td>\n",
              "      <td>0.2957</td>\n",
              "      <td>0.4899</td>\n",
              "      <td>0.1522</td>\n",
              "      <td>0.1241</td>\n",
              "      <td>0.6077</td>\n",
              "      <td>0.7371</td>\n",
              "      <td>0</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>id_000a6266a</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>48</td>\n",
              "      <td>D1</td>\n",
              "      <td>18bb41b2c</td>\n",
              "      <td>0.6280</td>\n",
              "      <td>0.5817</td>\n",
              "      <td>1.5540</td>\n",
              "      <td>-0.0764</td>\n",
              "      <td>-0.0323</td>\n",
              "      <td>1.2390</td>\n",
              "      <td>0.1715</td>\n",
              "      <td>0.2155</td>\n",
              "      <td>0.0065</td>\n",
              "      <td>1.2300</td>\n",
              "      <td>-0.4797</td>\n",
              "      <td>-0.5631</td>\n",
              "      <td>-0.0366</td>\n",
              "      <td>-1.8300</td>\n",
              "      <td>0.6057</td>\n",
              "      <td>-0.3278</td>\n",
              "      <td>0.6042</td>\n",
              "      <td>-0.3075</td>\n",
              "      <td>-0.1147</td>\n",
              "      <td>-0.0570</td>\n",
              "      <td>-0.0799</td>\n",
              "      <td>-0.8181</td>\n",
              "      <td>-1.5320</td>\n",
              "      <td>0.2307</td>\n",
              "      <td>0.4901</td>\n",
              "      <td>0.4780</td>\n",
              "      <td>-1.3970</td>\n",
              "      <td>4.6240</td>\n",
              "      <td>-0.0437</td>\n",
              "      <td>1.2870</td>\n",
              "      <td>-1.8530</td>\n",
              "      <td>0.6069</td>\n",
              "      <td>0.4290</td>\n",
              "      <td>0.1783</td>\n",
              "      <td>0.0018</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.0444</td>\n",
              "      <td>0.1894</td>\n",
              "      <td>-0.0014</td>\n",
              "      <td>-2.3640</td>\n",
              "      <td>-0.4682</td>\n",
              "      <td>0.1210</td>\n",
              "      <td>-0.5177</td>\n",
              "      <td>-0.0604</td>\n",
              "      <td>0.1682</td>\n",
              "      <td>-0.4436</td>\n",
              "      <td>0.4963</td>\n",
              "      <td>0.1363</td>\n",
              "      <td>0.3335</td>\n",
              "      <td>0.9760</td>\n",
              "      <td>-0.0427</td>\n",
              "      <td>-0.1235</td>\n",
              "      <td>0.0959</td>\n",
              "      <td>0.0690</td>\n",
              "      <td>-0.9416</td>\n",
              "      <td>-0.7548</td>\n",
              "      <td>-0.1109</td>\n",
              "      <td>-0.6272</td>\n",
              "      <td>0.3019</td>\n",
              "      <td>0.1172</td>\n",
              "      <td>0.1093</td>\n",
              "      <td>-0.3113</td>\n",
              "      <td>0.3019</td>\n",
              "      <td>-0.0873</td>\n",
              "      <td>-0.7250</td>\n",
              "      <td>-0.6297</td>\n",
              "      <td>0.6103</td>\n",
              "      <td>0.0223</td>\n",
              "      <td>-1.3240</td>\n",
              "      <td>-0.3174</td>\n",
              "      <td>-0.6417</td>\n",
              "      <td>-0.2187</td>\n",
              "      <td>-1.4080</td>\n",
              "      <td>0.6931</td>\n",
              "      <td>3</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>id_0015fd391</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>48</td>\n",
              "      <td>D1</td>\n",
              "      <td>8c7f86626</td>\n",
              "      <td>-0.5138</td>\n",
              "      <td>-0.2491</td>\n",
              "      <td>-0.2656</td>\n",
              "      <td>0.5288</td>\n",
              "      <td>4.0620</td>\n",
              "      <td>-0.8095</td>\n",
              "      <td>-1.9590</td>\n",
              "      <td>0.1792</td>\n",
              "      <td>-0.1321</td>\n",
              "      <td>-1.0600</td>\n",
              "      <td>-0.8269</td>\n",
              "      <td>-0.3584</td>\n",
              "      <td>-0.8511</td>\n",
              "      <td>-0.5844</td>\n",
              "      <td>-2.5690</td>\n",
              "      <td>0.8183</td>\n",
              "      <td>-0.0532</td>\n",
              "      <td>-0.8554</td>\n",
              "      <td>0.1160</td>\n",
              "      <td>-2.3520</td>\n",
              "      <td>2.1200</td>\n",
              "      <td>-1.1580</td>\n",
              "      <td>-0.7191</td>\n",
              "      <td>-0.8004</td>\n",
              "      <td>-1.4670</td>\n",
              "      <td>-0.0107</td>\n",
              "      <td>-0.8995</td>\n",
              "      <td>0.2406</td>\n",
              "      <td>-0.2479</td>\n",
              "      <td>-1.0890</td>\n",
              "      <td>-0.7575</td>\n",
              "      <td>0.0881</td>\n",
              "      <td>-2.7370</td>\n",
              "      <td>0.8745</td>\n",
              "      <td>0.5787</td>\n",
              "      <td>...</td>\n",
              "      <td>-2.3820</td>\n",
              "      <td>-3.7350</td>\n",
              "      <td>-2.9740</td>\n",
              "      <td>-1.4930</td>\n",
              "      <td>-1.6600</td>\n",
              "      <td>-3.1660</td>\n",
              "      <td>0.2816</td>\n",
              "      <td>-0.2990</td>\n",
              "      <td>-1.1870</td>\n",
              "      <td>-0.5044</td>\n",
              "      <td>-1.7750</td>\n",
              "      <td>-1.6120</td>\n",
              "      <td>-0.9215</td>\n",
              "      <td>-1.0810</td>\n",
              "      <td>-3.0520</td>\n",
              "      <td>-3.4470</td>\n",
              "      <td>-2.7740</td>\n",
              "      <td>-1.8460</td>\n",
              "      <td>-0.5568</td>\n",
              "      <td>-3.3960</td>\n",
              "      <td>-2.9510</td>\n",
              "      <td>-1.1550</td>\n",
              "      <td>-3.2620</td>\n",
              "      <td>-1.5390</td>\n",
              "      <td>-2.4600</td>\n",
              "      <td>-0.9417</td>\n",
              "      <td>-1.5550</td>\n",
              "      <td>0.2431</td>\n",
              "      <td>-2.0990</td>\n",
              "      <td>-0.6441</td>\n",
              "      <td>-5.6300</td>\n",
              "      <td>-1.3780</td>\n",
              "      <td>-0.8632</td>\n",
              "      <td>-1.2880</td>\n",
              "      <td>-1.6210</td>\n",
              "      <td>-0.8784</td>\n",
              "      <td>-0.3876</td>\n",
              "      <td>-0.8154</td>\n",
              "      <td>0</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>id_001626bd3</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>72</td>\n",
              "      <td>D2</td>\n",
              "      <td>7cbed3131</td>\n",
              "      <td>-0.3254</td>\n",
              "      <td>-0.4009</td>\n",
              "      <td>0.9700</td>\n",
              "      <td>0.6919</td>\n",
              "      <td>1.4180</td>\n",
              "      <td>-0.8244</td>\n",
              "      <td>-0.2800</td>\n",
              "      <td>-0.1498</td>\n",
              "      <td>-0.8789</td>\n",
              "      <td>0.8630</td>\n",
              "      <td>-0.2219</td>\n",
              "      <td>-0.5121</td>\n",
              "      <td>-0.9577</td>\n",
              "      <td>1.1750</td>\n",
              "      <td>0.2042</td>\n",
              "      <td>0.1970</td>\n",
              "      <td>0.1244</td>\n",
              "      <td>-1.7090</td>\n",
              "      <td>-0.3543</td>\n",
              "      <td>-0.5160</td>\n",
              "      <td>-0.3330</td>\n",
              "      <td>-0.2685</td>\n",
              "      <td>0.7649</td>\n",
              "      <td>0.2057</td>\n",
              "      <td>1.3720</td>\n",
              "      <td>0.6835</td>\n",
              "      <td>0.8056</td>\n",
              "      <td>-0.3754</td>\n",
              "      <td>-1.2090</td>\n",
              "      <td>0.2965</td>\n",
              "      <td>-0.0712</td>\n",
              "      <td>0.6389</td>\n",
              "      <td>0.6674</td>\n",
              "      <td>-0.0783</td>\n",
              "      <td>1.1740</td>\n",
              "      <td>...</td>\n",
              "      <td>0.1535</td>\n",
              "      <td>-0.4640</td>\n",
              "      <td>-0.5943</td>\n",
              "      <td>0.3973</td>\n",
              "      <td>0.1500</td>\n",
              "      <td>0.5178</td>\n",
              "      <td>0.5159</td>\n",
              "      <td>0.6091</td>\n",
              "      <td>0.1813</td>\n",
              "      <td>-0.4249</td>\n",
              "      <td>0.7832</td>\n",
              "      <td>0.6529</td>\n",
              "      <td>0.5648</td>\n",
              "      <td>0.4817</td>\n",
              "      <td>0.0587</td>\n",
              "      <td>0.5303</td>\n",
              "      <td>0.6376</td>\n",
              "      <td>-0.3966</td>\n",
              "      <td>-1.4950</td>\n",
              "      <td>-0.9625</td>\n",
              "      <td>-0.0541</td>\n",
              "      <td>0.6273</td>\n",
              "      <td>0.4563</td>\n",
              "      <td>0.0698</td>\n",
              "      <td>0.8134</td>\n",
              "      <td>0.1924</td>\n",
              "      <td>0.6054</td>\n",
              "      <td>-0.1824</td>\n",
              "      <td>0.0042</td>\n",
              "      <td>0.0048</td>\n",
              "      <td>0.6670</td>\n",
              "      <td>1.0690</td>\n",
              "      <td>0.5523</td>\n",
              "      <td>-0.3031</td>\n",
              "      <td>0.1094</td>\n",
              "      <td>0.2885</td>\n",
              "      <td>-0.3786</td>\n",
              "      <td>0.7125</td>\n",
              "      <td>1</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 879 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "             id tratamento  tempo dose  ...    c-98    c-99  n_moa  ativo_moa\n",
              "0  id_000644bb2  com_droga     24   D1  ...  0.3801  0.4176      1       True\n",
              "1  id_000779bfc  com_droga     72   D1  ...  0.6077  0.7371      0      False\n",
              "2  id_000a6266a  com_droga     48   D1  ... -1.4080  0.6931      3       True\n",
              "3  id_0015fd391  com_droga     48   D1  ... -0.3876 -0.8154      0      False\n",
              "4  id_001626bd3  com_droga     72   D2  ... -0.3786  0.7125      1       True\n",
              "\n",
              "[5 rows x 879 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "fJoLbaDed6Jc",
        "outputId": "078d9aab-16a3-4b76-daa8-7e0e53212f0d"
      },
      "source": [
        "dados_combinados.query('tratamento == \"com_controle\"' )['ativo_moa'].value_counts()"
      ],
      "execution_count": 10,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "False    1866\n",
              "Name: ativo_moa, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "EcIPZgD0d9JP",
        "outputId": "9567ecce-aaa3-4b16-e7be-3b3305aba29d"
      },
      "source": [
        "dados_combinados.query('tratamento == \"com_droga\"' )['ativo_moa'].value_counts()"
      ],
      "execution_count": 13,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "True     14447\n",
              "False     7501\n",
              "Name: ativo_moa, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 514
        },
        "id": "7avs_C4wd_T6",
        "outputId": "f6812bfc-5c5e-4c09-c3e2-ad686c43c328"
      },
      "source": [
        "import matplotlib.pyplot as plt\n",
        "import seaborn as sns \n",
        "\n",
        "composto_principal = dados_combinados['droga'].value_counts().index[:11]\n",
        "plt.figure(figsize=(16,8))\n",
        "sns.boxplot(data = dados_combinados.query('droga in @composto_principal'), y= 'g-0', x='droga', hue='ativo_moa')\n"
      ],
      "execution_count": 20,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7f75768c8510>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 20
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAA64AAAHgCAYAAAClyzBHAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nOzdf3xcVZ3/8fcnM4WmlCJMS8XUWjQiCIUKRVG2WGkCQdcvuOx+i6vfTnXduvrdpiL+QFgFV5YV3cVtiqtWBSZaERfFryiEJl1+qYC0pRCwCFFTbLaWMlWgNG0zyfn+cW/aSZqZpMkk50zyej4efXTunTtzP3MyM3fe95x7rznnBAAAAABAqCp8FwAAAAAAQDEEVwAAAABA0AiuAAAAAICgEVwBAAAAAEEjuAIAAAAAgkZwBQAAAAAELem7gEMxffp0N2fOHN9lAAAAAABGwYYNG553zs3oP7+sguucOXO0fv1632UAAAAAAEaBmW0ZaD5DhQEAAAAAQSO4AgAAAACCRnAFAAAAAAStrI5xBQAAAIDxqKurS1u3btWePXt8lzImJk+erFmzZmnSpElDWp7gCgAAAACebd26VUceeaTmzJkjM/NdzqhyzimbzWrr1q06/vjjh/QYhgoDAAAAgGd79uxRKpUa96FVksxMqVTqkHqXCa4AAAAAEICJEFp7HeprJbgCAAAAAIJGcAUAAACAMnLttdf2mX7b297mqZKxQ3AFAAAAgDLSP7j+8pe/9FTJ2CG4AgAAAECgLrroIp1xxhk6+eSTtXr1al1++eXq7OzUvHnz9L73vU+SNHXqVEnSJZdcop/97Gf7H7t06VLddttt2rNnjz7wgQ9o7ty5etOb3qR77rmn4PpuvvlmXXTRRaqtrdWcOXN0ww036Prrr9eb3vQmnXXWWdq5c6ckadOmTTrrrLN06qmn6j3veY/+9Kc/SZK++c1v6swzz9Rpp52miy++WLt37y5JOxBcAQAAACBQN954ozZs2KD169eroaFBn/zkJ1VZWalNmzZpzZo1fZZdvHixfvCDH0iS9u3bp3Xr1uld73qXvvrVr8rM1NraqltuuUXpdLroGX2feOIJ/ehHP9IjjzyiK6+8UlOmTNGjjz6qt771rWpsbJQkLVmyRNddd50ef/xxzZ07V5///OclSX/1V3+lRx55RI899phOOukkffvb3y5JOxBcAQAAACBQDQ0NOu2003TWWWfpD3/4g5555pmCy15wwQW65557tHfvXt11110655xzVFlZqZ///Od6//vfL0k68cQT9ZrXvEZPP/10wed5xzveoSOPPFIzZszQUUcdpXe/+92SpLlz56q9vV0vvPCC/vznP+vtb3+7JCmdTuv++++XFIXeBQsWaO7cuVqzZo2efPLJkrRDsiTPAgAAAAAoqXvvvVctLS168MEHNWXKFC1cuLBoT+nkyZO1cOFC3X333br11lt1ySWXDGu9hx9++P7bFRUV+6crKiqUy+WKPnbp0qX68Y9/rNNOO00333yz7r333mHV0N+o97ia2Y1m9pyZPZE37xgzazazZ+L/jx7tOgAAAACgnLzwwgs6+uijNWXKFD311FN66KGHJEmTJk1SV1fXgI9ZvHixbrrpJj3wwAOqq6uTJC1YsGD/sOKnn35azz77rN7whjcMu66jjjpKRx99tB544AFJ0ne+8539va8vvfSSjjvuOHV1dR00lHkkxmKo8M2S6vrNu1zSOufc6yWti6cBAAAAALG6ujrlcjmddNJJuvzyy3XWWWdJkpYtW6ZTTz11/8mZ8p133nm67777VFNTo8MOO0yS9NGPflQ9PT2aO3euFi9erJtvvrlPr+pwZDIZffKTn9Spp56qTZs26XOf+5wk6Qtf+ILe8pa36Oyzz9aJJ544onXkM+dcyZ6s4ErM5kj6qXPulHj6N5IWOue2mdlxku51zg0a+efPn+/Wr18/qrUCAAAAwFjbvHmzTjrpJN9ljKmBXrOZbXDOze+/rK9jXGc657bFt/8oaaanOlBmVq1apba2toL3d3R0SJKqqqoKLlNdXa3ly5eXvDYAAAAAo8P7yZmcc87MCnb7mtkyScskafbs2WNWF8pTZ2en7xIAAACA4N1999369Kc/3Wfe8ccfr9tvv91TRcX5Cq7bzey4vKHCzxVa0Dm3WtJqKRoqPFYFIkyD9ZSuWLFCkrRy5cqxKAcAAAAoS+eff77OP/9832UMma/ruP5EUjq+nZb0/zzVAQAAAAAI3FhcDucWSQ9KeoOZbTWzv5P0RUm1ZvaMpJp4GgAAAACAg4z6UGHn3HsL3LVotNcNAAAAACh/3k/OBAAAAADwK5FIaO7cufunf/zjH2vOnDkDLjt16lTt2rVrjCqLEFwBAAAAIDD/+PFP6rnnd5bs+Y6dfoxuuP7LBe+vrKzUpk2bSra+UiO4AgAAAEBgnnt+p3478+2le8Lt9x3S4rt27dKFF16oP/3pT+rq6tI111yjCy+8sM8y27Zt0+LFi/Xiiy8ql8vpa1/7mhYsWKC1a9fqqquu0t69e/W6171ON910k6ZOnTqi8n2dVRgAAAAAEIjOzk7NmzdP8+bN03ve8x5NnjxZt99+uzZu3Kh77rlHl112mZzre3XS733vezr//PO1adMmPfbYY5o3b56ef/55XXPNNWppadHGjRs1f/58XX/99SOujx5XAAAAAJjg+g8V7urq0hVXXKH7779fFRUV6ujo0Pbt2/XKV75y/zJnnnmmPvjBD6qrq0sXXXSR5s2bp/vuu0+//vWvdfbZZ0uS9u3bp7e+9a0jro/gCgAAAADoY82aNdqxY4c2bNigSZMmac6cOdqzZ0+fZc455xzdf//9+tnPfqalS5fq4x//uI4++mjV1tbqlltuKWk9DBUGAAAAAPTxwgsv6Nhjj9WkSZN0zz33aMuWLQcts2XLFs2cOVN///d/rw996EPauHGjzjrrLP3iF79QW1ubJOnll1/W008/PeJ66HEFAAAAAPTxvve9T+9+97s1d+5czZ8/XyeeeOJBy9x777368pe/rEmTJmnq1KlqbGzUjBkzdPPNN+u9732v9u7dK0m65pprdMIJJ4yoHoIrAAAAAATm2OnHHPKZgAd9viL6X5d1+vTpevDBB4sum06nlU6nD7r/3HPP1SOPPDLMSgdGcAUAAACAwBS75upExDGuAAAAAICgEVwBAAAAAEEjuAIAAAAAgkZwBQAAAAAEjeAKAAAAAAgaZxUGAAAAgAksm81q0aJFkqQ//vGPSiQSmjFjhiTpV7/6lQ477DCf5UkiuAIAAABAcK647B/1wvPbS/Z8R02fqWv//YYB70ulUtq0aZMk6eqrr9bUqVP1iU98Yv/9uVxOyaTf6EhwBQAAAIDAvPD8dn36dU+V7Pmu++2hLb906VJNnjxZjz76qM4++2xNmzatT6A95ZRT9NOf/lRz5szRd7/7XTU0NGjfvn16y1veov/8z/9UIpEoWe0Sx7gCAAAAAAawdetW/fKXv9T1119fcJnNmzfr1ltv1S9+8Qtt2rRJiURCa9asKXkt9LgCAAAAAA7yN3/zN4P2nK5bt04bNmzQmWeeKUnq7OzUscceW/JaCK4AAAAAgIMcccQR+28nk0n19PTsn96zZ48kyTmndDqtf/3Xfx3VWhgqDAAAAAAoas6cOdq4caMkaePGjfr9738vSVq0aJFuu+02Pffcc5KknTt3asuWLSVfP8EVAAAAAFDUxRdfrJ07d+rkk0/WDTfcoBNOOEGS9MY3vlHXXHONzjvvPJ166qmqra3Vtm3bSr5+hgoDAAAAQGCOmj7zkM8EPNjzDcXVV1894PzKykqtXbt2wPsWL16sxYsXD7e0ISG4AgAAAEBgCl1zdaJiqDAAAAAAIGgEVwAAAABA0AiuAAAAABAA55zvEsbMob5WgisAAAAAeDZ58mRls9kJEV6dc8pms5o8efKQH8PJmQAAAADAs1mzZmnr1q3asWOH71LGxOTJkzVr1qwhL09wBQAAAADPJk2apOOPP953GcFiqDAAAAAAIGgEVwAAAABA0AiuAAAAAICgEVwBAAAAAEEjuAIAAAAAgkZwBQAAAAAEjeAKAAAAAAgawRUAAAAAEDSCKwAAAAAgaARXAAAAAEDQCK4AAAAAgKARXAEAAAAAQSO4AgAAAACC5jW4mtmlZvakmT1hZreY2WSf9QAAAAAAwuMtuJpZlaR6SfOdc6dISki6xFc9AAAAAIAw+R4qnJRUaWZJSVMk/Y/negAAAAAAgfEWXJ1zHZL+TdKzkrZJesE5t9ZXPQAAAACAMPkcKny0pAslHS/pVZKOMLP3D7DcMjNbb2brd+zYMdZlAgAAAAA88zlUuEbS751zO5xzXZJ+JOlt/Rdyzq12zs13zs2fMWPGmBcJAAAAAPDLZ3B9VtJZZjbFzEzSIkmbPdYDAAAAAAiQz2NcH5Z0m6SNklrjWlb7qgcAAAAAEKakz5U7566SdJXPGgAAAAAAYfN9ORwAAAAAAIoiuAIAAAAAgkZwBQAAAAAEjeAKAAAAAAgawRUAAAAAEDSCKwAAAAAgaARXAAAAAEDQCK4AAAAAgKARXAEAAAAAQSO4AgAAAACCRnAFAAAAAASN4AoAAAAACBrBFQAAAAAQNIIrAAAAACBoBFcAAAAAQNAIrgAAAACAoBFcAQAAAABBI7gCAAAAAIJGcAUAAAAABI3gCgAAAAAIGsEVAAAAABA0gisAAAAAIGgEVwAAAABA0AiuAAAAAICgEVwBAAAAAEEjuAIAAAAAgkZwBQAAAAAEjeAKAAAAAAgawRUAAAAAEDSCKwAAAAAgaARXAAAAAEDQCK4AgOBks1nV19crm836LgUAAASA4AoACE4mk1Fra6saGxt9lwIAAAJAcAUABCWbzaqpqUnOOTU1NdHrCgAACK4AgLBkMhn19PRIkrq7u+l1BQAABFcAQFhaWlqUy+UkSblcTs3NzZ4rAgAAvhFcAQBBqampUTKZlCQlk0nV1tZ6rggAAPhGcAUABCWdTquiIto8JRIJLVmyxHNFAADAN4IrACAoqVRKdXV1MjPV1dUplUr5LgkAAHiW9F0AkG/VqlVqa2sb9uN7H7tixYphP0d1dbWWL18+7McDGLl0Oq329nZ6WwEAgCSCKwLT1tamZ558VLOndg/r8Yd1RYMI9m5ZP6zHP7srMazHASitVCqlhoYG32UAAIBAEFwRnNlTu3XF6S96Wfe1G6d5WS8AAACAwjjGFQAAAAAQNIIrAAAAACBoXoOrmb3CzG4zs6fMbLOZvdVnPQAAAACA8Pg+xnWlpCbn3F+b2WGSpniuBwAAAAAQGG/B1cyOknSOpKWS5JzbJ2mfr3oAAAAAAGHyOVT4eEk7JN1kZo+a2bfM7AiP9QAAAAAAAuRzqHBS0umSljvnHjazlZIul/TZ/IXMbJmkZZI0e/bsMS8SAFB6q1atUltbW8H7Ozo6JElVVVUFl6murtby5ctLXhsAAAiPzx7XrZK2OucejqdvUxRk+3DOrXbOzXfOzZ8xY8aYFggA8KOzs1OdnZ2+ywAAAIHw1uPqnPujmf3BzN7gnPuNpEWSfu2rHgDA2Bmsp3TFihWSpJUrV45FOQAAIHC+zyq8XNKa+IzCv5P0Ac/1AAAAAAAC4zW4Ouc2SZrvswYAAAAAQNh8HuMKAAAAAMCgCK4AAAAAgKARXAEAAAAAQSO4AgAAAACCRnAFAAAAAASN4AoAAAAACBrBFQAAAAAQNIIrAAAAACBoBFcAAAAAQNAIrgAAAACAoBFcAQAAAABBI7gCAAAAAIJGcAUAAMCoyWazqq+vVzab9V0KgDJGcAUAAMCoyWQyam1tVWNjo+9SAJQxgisAAABGRTabVVNTk5xzampqotcVwLARXAEAADAqMpmMenp6JEnd3d30ugIYNoIrAAAARkVLS4tyuZwkKZfLqbm52XNFAMoVwRUAAACjYsGCBUWnAWCoCK4AAAAYFc453yUAGCcIrgAAABgVP//5z/tMP/DAA54qAVDuCK4AAAAYFTU1NUokEpKkRCKh2tpazxUBKFcEVwAAAIyKdDq9P7gmk0ktWbLEc0UAyhXBFQAAAKMilUqprq5OZqa6ujqlUinfJQEoU0nfBQAAAGD8SqfTam9vp7cVwIgQXAEAADBqUqmUGhoafJcBoMwRXBGUjo4OvfxSQtdunOZl/VteSuiIjg4v6wYAAAAwMI5xBQKTzWZVX1+vbDbruxQAAAAgCPS4IihVVVXam9umK05/0cv6r904TYdXVXlZd69MJqPW1lY1Njbq0ksv9VoLAAAAEAKC6xhatWqV2traCt7fEQ9RrSoSnKqrq7V8+fKS14YwZLNZNTU1yTmnpqYmLVmyhDMwAgAAYMJjqHBAOjs71dnZ6bsMeJTJZNTT0yNJ6u7uVmNjo+eKAAAAAP/ocR1Dg/WUrlixQpK0cuXKsSgHAWppaVEul5Mk5XI5NTc3M1wYAAAAEx49rkBAampqlExG+5OSyaRqa2s9VwQAAAD4R3AFApJOp1VREX0sE4kEF2sHAAAARHAFgpJKpVRXVyczU11dHSdmAgAAAMQxrkBw0um02tvb6W0FAAAAYvS4AgAAAACCRnAFApPJZNTa2sqlcAAAAIAYwRUISDabVVNTk5xzampqUjab9V0SAAAA4B3BFQhIJpNRT0+PJKm7u5teVwAAAEAEVyAoLS0tyuVykqRcLqfm5mbPFQEAAAD+EVyBgNTU1CiZjE72nUwmVVtb67kiAAAAwD+CKxCQdDqtioroY5lIJLgkDgAAACCCKxCUVCqluro6mZnq6uqUSqV8lwQAAAB4R3AFApNOpzV37lx6WwEA40I2m1V9fT1nygcwIgRXIDCpVEoNDQ30tgIAxgWuTw6gFLwHVzNLmNmjZvZT37UAAACgdLg+OYBS8R5cJa2QtNl3EQAAACgtrk8OoFS8BlczmyXpXZK+5bMOAADGI44thG9cnxxAqfjucf0PSZ+S1FNoATNbZmbrzWz9jh07xq4yAADKHMcWwjeuTw6gVLwFVzP7S0nPOec2FFvOObfaOTffOTd/xowZY1QdAADljWMLEYJ0Oi0zkyRVVFRwxnwAw+azx/VsSf/LzNolfV/SuWb2XY/1AAAwbnBsIUKQSqVUVVUlSXrVq17FGfMBDJu34Oqc+4xzbpZzbo6kSyT9t3Pu/b7qAQBgPOHYQoQgm82qo6NDktTR0UHPP4Bh832MK4B+OJkKgFLg2EKEIJPJ9NmBQs8/gOEKIrg65+51zv2l7zqAEHAyFQClkE6nVVERbeYTiQTHFsKL5uZmOeckSc45rV271nNFAMpVEMEVQCT/ZCp33XUXva4Ahi2VSqmurk5mprq6Oo4thBczZ84sOg0AQ0VwBQKSyWTU1dUlSerq6qLXFcCIpNNpzZ07l95WeLN9+/ai0wAwVARXICAMqQJQSqlUSg0NDfS2wpva2tr9l8MxM5133nmeKwJQrgiuQEAYUgUAGE/S6bQmTZokSZo0aRK9/wCGjeAKBIQhVQCA8ST/WOsLLriA3n8Aw5b0XQDQ37O7Erp247RhPXb77mhfzMwpPcNe9+uH9cjSqK2t1U9+8pP90wypAgCUu3Q6rfb2dnpbAYwIwRVBqa6uHtHj97W1SZIOf83wnuf1JahhJNLptO644w4552RmbOQBAGWv91hrABgJgiuCsnz58hE9fsWKFZKklStXlqIcAAAAAAHgGFcgIKtXr+5zVuHVq1d7rqg8ZbNZ1dfXcx1cAACAcYLgCgRk3bp1RacxNJlMRq2trVwHFwAAYJwguAIB6e1tLTSNwWWzWTU1Nck5p6amJnpdAQAAxgGCKxCQRYsW9ZmuqanxVEn5ymQy6umJzird3d1NryuAEeHQAwAIA8EVCMiHP/zhPtPLli3zVEn5amlpUS6XkyTlcjk1Nzd7rghAOePQAwAIA8EVCIyZ9fkfh6ampkbJZHTC9GQyqdraWs8VAShXHHoAAOEguAIByWQySiQSkqREIsEe/mFIp9OqqIi+2hKJBNfCBTBsHHoAAOHgOq5AQAYa5nrppZd6rqq8pFIp1dXV6Y477lBdXZ1SqZTvkgCUKb6Th2bVqlVqa2sreH9HR4ckqaqqquAy1dXVI76WO4DxjR5XICAMcy2NdDqtuXPn0tsKYET4Ti6Nzs5OdXZ2+i4DQJmjxxUISDqdVlNTkySGuY5EKpVSQ0OD7zIAlDm+k4dmsJ7SFStWSJJWrlw5FuUAGKfocQUC0jvM1cwY5goAnvGdDADhoMcVCEw6nVZ7ezt79gEgAHwnA0AYCK5AYBjmivFisBO2FNP7uN4hhsPByV6iy7l8/vOf11VXXUVv4TDxnYwQ8FkGCK4AxiE28GFoa2vTM08+qtlTuw/5sYd1RUey7N2yfljrfnZXYliPG28ymYxaW1vV2NjI2XCBMsZnGSC4AhiH2MCHY/bUbl1x+otjvt5rN04b83WGJpvNqqmpSc453XXXXVqyZAk7coaBHWHwLf+z3NTUxGcZExYnZwIwrvTfwGezWd8lAV5kMhl1dXVJkrq6utTY2Oi5ovKUvyMM8CGTyainp0eS1N3dzXsRExbBFcC4wgYeiDQ3N8s5J0lyzmnt2rWeKyo/7AhDCFpaWpTL5SRJuVxOzc3NnisC/CC4AhhX2MADkZkzZxadxuDYEYYQ1NTUKJmMju5LJpOqra31XBHgB8EVwLjCBh6IbN++veg0BseOMIQgnU6roiL6yZ5IJLg0EyasQYOrmZ1oZp82s4b436fN7KSxKA4ADhUbeCCyYMGCPtPnnHOOp0rKFzvCEIJUKqW6ujqZmerq6jgxEyasosHVzD4t6fuSTNKv4n8m6RYzu3z0ywMmnvXr1+vcc8/Vhg0bfJdSltjAAxEz811C2WNHGEKRTqc1d+5c3oOY0Abrcf07SWc6577onPtu/O+Lkt4c3wegxD772c+qp6dH//RP/+S7lLLFBh6QHnjggaLTGBw7whCKVCqlhoYG3oOY0Aa7jmuPpFdJ2tJv/nHxfQBKaP369ers7JQkdXZ2asOGDTrjjDM8VxWeVatWqa2treD9HR0dkqR//ud/LrhMdXW1li9fXvLagFDU1NTozjvvVC6XY5jrCKTTabW3t7MjDAA8G6zH9WOS1pnZXWa2Ov7XJGmdpBWjXx4wsXz2s5/tM02v6/B0dnbu3wEATFQMcy0NeroAIAxFe1ydc01mdoKiocFV8ewOSY8457pHuzhgoukftghfAxusp3TFimi/2sqVK8eiHCBIvcNc77jjDoa5AgDK3qBnFXbO9TjnHnLO/dA590NJpxJaAQAIH8d7j1w2m1V9fb2y2azvUgBgQhvOdVz/oeRVAJAkTZ8+veg0ABwKhrmOXCaTUWtrqxobG32XAgAT2nCCK+fXB0bJKaecUnQaADB2stmsmpqa5JxTU1MTva4A4NGQgquZfbz3n6Qfxrf/zszmjXJ9wITy0EMPFZ0GAIydTCajnp7oIgrd3d30ugKAR0PtcZ2vaIhwlaSjJX1YUp2kb5rZp0apNmDCSSQSRacBAGOnpaVFuVxOkpTL5dTc3Oy5IgCYuIYaXGdJOt05d5lz7jJJZ0g6VtI5kpaOUm3AhPPyyy8XnQYAjJ2amholk9EFGLgWLgD4NdTgeqykvXnTXZJmOuc6+80HAAAYF7gWLgCEY6jBdY2kh83sKjO7StIvJH3PzI6Q9OtRqw6YYI477rii0wCAsdN7LVwz41q4AOBZcigLOee+YGZ3STo7nvUPzrn18e33jUplwAS0c+fOotMAgLGVTqfV3t5ObysAeDak4CpJcVBdP+iCAIYtmUxq7969faYBoJBVq1apra2t4P0dHR2SpKqqqoLLVFdXa/ny5SWvbbzovRYuAMAvfhUDAeHkTABKqbOz03cJAACUhLfgamavltQoaaYkJ2m1c26lr3oAACg3g/WUrlixQpK0ciWbVwBAefPZ45qTdJlzbqOZHSlpg5k1O+c42RMAABgTDLcGgPLgLbg657ZJ2hbffsnMNkuqEmcpBgAAgWC4NQCEIYhjXM1sjqQ3SXrYbyXA6Bts735/vUP98rF3H+Wgo6NDL7+U0LUbp435ure8lNARcU8ZUAzDrQGgPAz1Oq6jxsymSvqhpI85514c4P5lZrbezNbv2LFj7AsEAAAAAHjltcfVzCYpCq1rnHM/GmgZ59xqSaslaf78+W4MywNGRbG9+1dddZXuu+++/dMLFy7U1VdfPQZVAaVXVVWlvbltuuL0g/ZJjrprN07T4UWOSQQAAOXFW4+rmZmkb0va7Jy73lcdQEjq6+v7TDMcGAAAAPA7VPhsSf9H0rlmtin+906P9QDepVIpHXXUUZKi3tZUKuW5IgAAAMA/n2cV/rkk87V+IFRVVVXK5XL0tgIAAACxIM4qDOCASZMmqbq6mt5WAAAmCK4nDAyO4AoAAAAEjOsJAwRXAAAAwCuuJwwMzvt1XAEAAAAAKIbgCgAAAAAIGkOFS2iwA+sH0/vY3uEgw8GB+QAAAADGG4JrCbW1temZJx/V7Kndw3r8YV1RB/jeLeuH9fhndyWG9TgAAAAACBnBtcRmT+3WFae/6GXd126c5mW9AAAAADCaOMYVAAAAABA0gisAAAAAIGgEVwAAAABA0AiuAAAAAICgcXImAAAAFMTl/gCEgOAKAACAgrjcH4AQEFwBAABQFJf7A+Abx7gCAAAAAIJGcAUAAAAABI3gCgAAAAAIGse4oqwMdmbDoZy5kDMTAgAAAOWF4IpxpbKy0ncJAAAAAEqM4IqyQk8pAAAAMPEQXAEAAABgghvskLyOjg5JUlVVVcFlRvOQPIIrAAAAAKCozs5Or+snuAIAAADABDdYT2nvyU9Xrlw5FuUchOAKABg1z+5K6NqN0w75cdt3R1drmzmlZ9jrff2wHgkAAEJEcAUAjIrq6uphP3ZffIzN4a8Z3nO8foTrBwAAYSG4AgBGxUhOzuB7OFIoBjtRxmCGcm3rYrjuNQAgFARXAAAC1dbWpmeefFSzp3YP6/GHdUVDrvduWX/Ij312V2JY6wQAYDQQXAEACNjsqd264vQXx3y9wzk2GQCA0bRmv3kAACAASURBVFLhuwAAAAAAAIqhxxUAAIxbvo8TljhWGABKgeAKAADGLZ/HCUscKwwApUJwBQAA45qv44QljhUGgFIhuAIIDkP7AAAAkI/gCiA4bW1t2vTEZnVPOWZYj6/Y5yRJG363fViPT+zeOazHAQAAYHQQXEuoo6NDL7+U8DYsaMtLCR3R0eFl3UCpdU85Rp0nvtPLuiufutPLegEgRPy+ARACgitQYgxzBQAAAEqL4FpCVVVV2pvb5vUEEIdXVXlZNw5gmCsAYDzh9w2AEBBcgVHAMFcAAACEpNxHBRJcAQAAAJS1wUJZR3ycdFWR3vvxfqhVuV/XmuAKAAAAjKJy7+kaDzo7O32XEIRyvq41wRUAAAAYReXe01UOBgvlvaF/5cqVY1EORgHBFQAAjFtcygWhKOeeLiAEBFcAAALlM3QRuAAAIfEaXM2sTtJKSQlJ33LOfdFnPQAAYHzhUi4AMD54C65mlpD0VUm1krZKesTMfuKc+7WvmgAACInP0EXgAgCEpMLjut8sqc059zvn3D5J35d0ocd6AAAAAAAB8hlcqyT9IW96azwPAAAAAID9gj85k5ktk7RMkmbPnu25GgAAAABjjWvhwmdw7ZD06rzpWfG8PpxzqyWtlqT58+e7sSkNAAAAQCi4Fu7IlfvlwXwG10ckvd7MjlcUWC+R9Lce6wFKoqOjQ4ndL6jyqTu9rD+xO6uOjpyXdQMAAIwWroU7sXkLrs65nJn9o6S7FV0O50bn3JO+6gEAAACA8arcLw/m9RhX59ydkvx0SwGjpKqqSn/cm1Tnie/0sv7Kp+5UVdVML+sGAIxPz+4a/vDC7bujIZozp/QMe92vH9Yjw1HuQzSBEAR/ciYAEw/DrQEgHNXV1SN6/L74pDiHv2Z4z/P6EtQAoPwRXAEAAFDQSM+i2nsW15UrV5ainLJU7kM0Q0CvNQiuAILDcGvgAF9DNMfD8EwAwPhBcAUAIFA+h2iOp+GZHJ8JlD96rUujnL8PCa4AAASKIZojx/GZABAp9+9DgisAABi3CP8AECn378MKL2sFAAAAAGCICK4AAAAAgKARXAEAAAAAQeMY1xIr5zN1AQAAAECICK4lVO5n6gIAAACAEBFcS6jcz9SF0kns3qnKp+4c1mMr9kTXJ+uZPLye+8TunZJmDuuxAAAAQIgIrkCJjbTXu63tpeh5Xjvc8DmTnncAADDucEjexEZwBUqMnncAAIDS4pA8EFwBAAAABI2OAXA5HAAAAABA0AiuAAAAAICgMVQYADDmVq1apbb4eKOB9N7XO7RrINXV1SMeOgYAAMoDwRUAEJzKykrfJQBASXFGXGBkCK4AgDFHTymAiYQz4gIjR3AFAAAARhFnxAVGjuAKIEiJ3TtV+dSdw3psxZ4XJUk9k4c3JCuxe6ekmcN6LAAAQDkK/fwTBFcAwRnpcKa2tpei53ntcMPnTIZUAQAA5PF9/gmCK4DgMKQKAABgbIV+/gmu4woAAAAACBrBFQAAAAAQNIIrAAAAACBoBFcAAAAAQNAIrgAAAACAoBFcAQAAAABBI7gCAAAAAIJGcAUAAAAABI3gCgAAAAAIGsEVAAAAABA0gisAAAAAIGhJ3wUAAAD4smrVKrW1tRW8v/e+FStWFFymurpay5cvL3ltAIADCK4AAAAFVFZW+i4BwBCwE2r8I7gCAIAJix+pwMTATqjyR3AFAAAAUNbYCTX+cXImAAAAAEDQCK4AAAAAgKARXAEAAAAAQSO4AgAAAACCxsmZAAAoU1z+AQAwUXjpcTWzL5vZU2b2uJndbmav8FEHAADjWWVlJZeAAACMC756XJslfcY5lzOz6yR9RtKnPdUCAEBZoqcUIaDnH8BY8NLj6pxb65zLxZMPSZrlow4AAACMLnr+AZRCCMe4flDSrb6LAAAAwKGjpxTAWBi14GpmLZJeOcBdVzrn/l+8zJWScpLWFHmeZZKWSdLs2bNHoVIAAAAAQMhGLbg652qK3W9mSyX9paRFzjlX5HlWS1otSfPnzy+4HAAAAABgfPIyVNjM6iR9StLbnXO7fdQAAAAAACgPvo5xvUHS4ZKazUySHnLO/YOnWoAxxdkXAQAAgEPjJbg656p9rBcoB5x5EQAAAOgrhLMKAxMKPaUAAADAofFyHVcAhWWzWdXX1yubzfouBQAAAAgCwRUITCaTUWtrqxobG32XAgAAAASB4AoEJJvNqqmpSc453XXXXfS6AgAAAOIYVyAomUxGXV1dkqSuri41Njbq0ksv9VwVAAAYTVxxABgcPa5AQJqbm+WckyQ557R27VrPFQEAAN8qKyu56gAmPHpcgYDMnDlT7e3tfaYBAMD4Rk8pMDh6XIGAbN++veg0AAAAMBERXIGA1NbWyswkSWam8847z3NFAAAAgH8EVyAg6XRayWQ0gn/SpElasmSJ54oAAAAA/wiuQEBSqZQuuOACmZkuuOACpVIp3yUBAAAA3nFypjHEqc4xFOl0Wu3t7fS2AgAAADF6XAPCqc4hRb2uDQ0N9LYCGLFsNqv6+npls1nfpQAAMCL0uI4hekoBAGMpk8motbVVjY2NuvTSS32XAwDAsNHjCgDAOJTNZtXU1CTnnJqamuh1BQCUNYIrAADjUCaTUU9PjySpu7tbjY2NnisCAGD4CK4AAIxDLS0tyuVykqRcLqfm5mbPFQEAMHwEVwAAxqGampr914VOJpOqra31XBEAAMNHcAUAYBxKp9OqqIg284lEgktsAQDKGsEVAIBxKJVKqa6uTmamuro6LrEFAChrXA4HAIBxKp1Oq729nd5WAEDZI7gCADBOpVIpNTQ0+C4DAIARI7gCKDurVq1SW1tbwft771uxYkXBZaqrq7V8+fKS1wYAAIDSI7gCGHcqKyt9lwAAAIASIrgCKDv0lAIAAEwsnFUYCEw2m1V9fb2y2azvUgAAAIAgEFyBwHzjG9/Q448/rtWrV/suBQAAAAgCwRUISDabVUtLiySpubmZXlcAAABABFcgKN/4xjfU09MjSerp6aHXFQAAABDBFQjKunXr+kz39r4CAAAAExnBFQiImRWdBgAAACYigisQkEWLFhWdBgAAACYigisQkGXLlqmiIvpYVlRUaNmyZZ4rAgAAAPwjuAIBSaVSqq2tlSTV1tYqlUp5rggAAADwL+m7AAB9LVu2TNu2baO3FQAAAIgRXIHApFIpNTQ0+C4DAAAACAZDhQEAAAAAQSO4AgAAAACCRnAFAAAAAASN4AoAAAAACBrBFQAAAAAQNIIrAAAAACBoBFcAAAAAQNAIrgAAAACAoHkNrmZ2mZk5M5vusw4AAAAAQLi8BVcze7Wk8yQ966sGAAAAAED4fPa4fkXSpyQ5jzUAAAAAAALnJbia2YWSOpxzj/lYPwAAAACgfCRH64nNrEXSKwe460pJVygaJjyU51kmaZkkzZ49u2T1AQAAAADKgzk3tiN1zWyupHWSdsezZkn6H0lvds79sdhj58+f79avXz/KFQIAAAAAfDCzDc65+f3nj1qPayHOuVZJx/ZOm1m7pPnOuefHuhYAAAAAQPi4jisAAAAAIGjeg6tzbg69rQAAAONTNptVfX29stms71IAlDHvwRUAAADjVyaTUWtrqxobG32XAqCMEVwBAAAwKrLZrJqamuScU1NTE72uAIaN4AoAAIBRkclk1NPTI0nq7u6m1xXAsBFcAQAAMCpaWlqUy+UkSblcTs3NzZ4rAlCuCK4AAAAYFTU1NUomo6svJpNJ1dbWeq4IQLkiuAIAAGBUpNNpVVREPzcTiYSWLFniuSIA5YrgCgAAgFGRSqVUV1cnM1NdXZ1SqZTvkgCUqaTvAgAAADB+pdNptbe309sKYEQIrgAAABg1qVRKDQ0NvssAUOYYKgwAAAAACBrBFQAAAAAQNIIrAAAAACBoBFcAAAAAQNAIrgAAAACAoBFcgcBks1nV19crm836LgUAAAAIAsEVCEwmk1Fra6saGxt9lwIAAAAEgeAKBCSbzaqpqUnOOTU1NdHrCgAAAIjgCgQlk8mop6dHktTd3U2vKwAAACCCKxCUlpYW5XI5SVIul1Nzc7PnigAAAAD/CK5AQGpqapRMJiVJyWRStbW1nisCAAAA/CO4AgFJp9OqqIg+lolEQkuWLPFcEQAAAOAfwRUISCqVUl1dncxMdXV1SqVSvksCAAAAvEv6LgBAX+l0Wu3t7fS2AgAAADGCKxCYVCqlhoYG32UAAAAAwWCoMAAAAAAgaARXAAAAAEDQCK4AAAAAgKARXAEAAAAAQSO4AgAAAACCRnAFAAAAAASN4AoAAAAACBrBFQAAAAAQNIIrAAAAACBoBFcAAAAAQNAIrgAAAACAoBFcAQAAAABBI7gCAAAAAIJGcAUAAAAABM2cc75rGDIz2yFpi+86BjFd0vO+iyhztOHI0YYjRxuOHG04crRhadCOI0cbjhxtOHK04ciVQxu+xjk3o//Msgqu5cDM1jvn5vuuo5zRhiNHG44cbThytOHI0YalQTuOHG04crThyNGGI1fObchQYQAAAABA0AiuAAAAAICgEVxLb7XvAsYB2nDkaMORow1HjjYcOdqwNGjHkaMNR442HDnacOTKtg05xhUAAAAAEDR6XAEAAAAAQZsQwdXMLjWzJ83sCTO7xcwmm1m7mU0fYNnZZnaPmT1qZo+b2Tvj+e8zs015/3rMbN4g630gb/n/MbMfD7L8JDPLmFmrmW02s8/E8yeb2a/M7LH4dXx+JO0xHAXacEivr7etzewN/drwRTP7WLzM38TP32NmB53pLP677DKzT8TTBdvEIv9iZk/H7Vifd9/CeN1Pmtl9pW+p0WVmuwrM/7KZPRW/Z283s1fE85ea2Q0FHnPQ3zSeP2D7xfMbzKwtXs/po/U6CzGzV8efz1/Hta+I559mZg/Gn507zGxaPL/WzDbE8zeY2blDWEeh74aPx+t93MzWmdlrBnmeQn+TAT/nYyl+ja3xZ2F93vzlcc1PmtmX4nkF29DM3hvPf9zMmgZqt7xlF5rZTwvc15T3Wf66mSVK+XrHgpldbWafiP/vyPuee2feMp+JPz+/MbPz8+bXx++FNWZ2Yvxe3tv7fZe3XKHP7Lfj9nvczG4zs6n9HnexmTmLv1tDeA8OxMxWxK/tSTuwbTgxbsdHzex1RdrgeDN7OG7fW83ssHj+jHj+o2a2oNB7rd96im2rbs2b325mm3y110Dy3ocDblOtyDYhvj8Rt8FP8+YNuK03s8PNrCWevzh+//4m/tvcaGaT4uWOtug78HGLttunFKu9dK0xPHlteIyZNZvZM/H/R8f3H2XRdqb3ffSBITxn/md8oZm9kNemnytWR795l8Wf5emFlvGtf00D1Fyw/czsS/G8zRb93rABnn//ezh+D94af+4fNrM58fw357XvY2b2nrzH32hmz5nZE0Vew5xi948WM3uFRd/hT8Vt8NZD/c4xs0VmtjFe/udmVh3P/0re8zxtZn/Oe8x18ef2CTNbPIQ6B6zJzA4zs5ss2rY8ZmYLR9gkB3POjet/kqok/V5SZTz9A0lLJbVLmj7A8qslfSS+/UZJ7QMsM1fSbw+xjh9KWjLIMn8r6fvx7SlxjXMkmaSp8fxJkh6WdJbvNhzq6xuorSUlJP1R0XWaJOkkSW+QdK+k+QM8x22S/kvSJ+Lpgm0i6QOSGiVVxNPHxv+/QtKvJc3On19O/yTtKjD/PEnJ+PZ1kq6Lby+VdMOh/E2LtN87Jd0Vt/1Zkh728PqPk3R6fPtISU/Hn9NHJL09nv9BSV+Ib79J0qvi26dI6hjCOgp9N7xD0pT49kck3TrI8xT6mwz4OR/jdhzoM/kOSS2SDu/3dx+wDSUlJT3X+zySviTp6iLrXCjppwXumxb/b4q+Sy4Z6/dWCdr0akmf6P1/gPvfKOkxSYdLOl7SbyUl4vuekjSrt90lnSnpX/KfZ5DP7LS85a6XdHne9JGS7pf0kOLv1hDegwO0zymSnojrScbvxWpJl0v6pyG0wQ963zeSvq4D2/FLJH1rsPda/nr61dVnW9Xvvn+X9Dnf770C78MBt6kqsE3Iu//jkr5X5LO6f1uvaDvQknffO+N2NUm35P0Nvizpqvj2iZLWFas9oDb8Uu9nKX5/9H6HX5F3e4aknZIOG+Q58z/jCwu1b7H2kPRqSXdL2qID37tBtFmhugvUPGD7SXqbpF/En7mEpAclLRzg+fe/hyV9VNLX49uXKN4uK/4eiW8fp2hb1Tt9jqTTJT1R5DXMKXb/KLZdRtKH4tuHSXpFv/sH/c5R9LvopLz2uXmAZZZLujG+/S5JzYq+d49Q9Htq2iHUvL8mSf9X0k3x7WMlbVD8W7JU/yZEj6uiP0almSUVvZn/J57/qXivwK9690hIcpKmxbePyls233slfb93wsy+ZmbrrUBvqEW9P+dK6t1L+WaL9qg/ama/NLM35K37iLjOSkn7JL3oIr09bZPif2N9cHKhNhzo9aXMbG3cHt9StBHrb5Gi8L9Fkpxzm51zvxloxWZ2kaIfK0/2zhukTT4i6Z+dcz3xss/F8/9W0o+cc8/2mz9mzGxJvNf5MTP7jpm92w70BrSY2cx4ual5e60eN7OL857jK3HbrjOzGfFrWeucy8WLPCRpVt5qX21m91q01/iqvPmF/qaF2u9CSY1x2z8k6RVmdlxpW6g459w259zG+PZLkjYr+jF7gqIf51L0BXxxvMyjzrne1/Wkotd7uDTo5/ag7wbn3D3Oud3x/X3a2Mw+nbeH8Yvx8oX+JgN+zkfaNiXwEUlfdM7tlQ783Yu0Ye8P1CPiveLTFL+HzKw6fj8/Fu/5fV38+Glm9jOLemW+bmYV8Tp6X39S0cbaxc/zOot6yDZY1OtzYjx/hpn90Mweif+dPbpNMzAzuzLec/1zRSGhmAsVhcW9zrnfS2qT9GYz+7qk10q6y8wudc4955x7RFLXAM8x4Ge2t/3iv0Ol+m4fvqBox8mevHkhvgdPUrQzbHf8ublP0Xf2xyR9xMzuiZc7qA3i132uoh2cUvTj7yKLRkV9SdKFcc9A5UDvNYt6xfuvp1efbVWveJ3/W1FA82qg92GxbaoKbBPMbJaiH7HfKrCe/dt6MztW0nclnRm37eucc3fG2wcn6Vc68J33Rkn/Hdf1lKQ5edu6Q/kMjZoCdVyo6L2k+P+L4ttO0pHxe2CqouCVi7fb6+LvvFYzuzB+7j6f8WHU0esrkj6lg3//9Y44esbM/v6QX3wJFKl7oJoHbL94/mRFn8vDFf2u2x4//wfi5/+VpPzv+/y/0W2SFpmZ5X2PKH7O/et3zt0fr7P/azgj3mY9piiAjSkzO0pRqP62JDnn9jnn8ntF+3znWDQ64t8s6iV93MyWx4sONcf0fne9UdL9zrmcc+5lSY9LqovXcYaZ3Rdvg+/u/5tvgO/B/M/6c5L+LKm014stZQoO9Z+kFZJ2SdohaU08r13SlfHtJYr3finaM9MqaaukP0k6Y4Dn+62kU/Kmj4n/Tyjau3lqv+WXSLotb3qaDuz5qZH0w/j2JEWBeIeklyUty3tMQtKm+HVcF0IbFnl9DTqw9+Vdij5E/Xt3bpT0jwOs51713Ts8VdFet6k6eO/jgG0iKSvpSknrFfUQvj6e/x+SvhqvY4MG6QEfhTY8WdGesN69jsdIOloHTpL2IUn/Ht++TtJ/5D326Ph/J+l98e3PaeDe1DskvT++vVTSNkkpRT9Qn9CBXpcB/6ZF2u+nkv4ib7l1GqB3fAzbc46kZ+PP0y8lXRTP/7iklwZY/q/Vt3dgwM+tCnw39HuuG3SgF+iCeP1T8p+3yN+k4Od8DNvu95I2xp+DZfG8TZI+r2j0wn2SzhxCG/61osCzTdGOg94exIclvSe+PVlRwFioKDy9Nm7zZkl/nfdcdyv6zv1e3vOsy3v/vUXSf8e3v9f7XpQ0W9JmD214hqJtxZT4PdimAz2u7Yo2/jfqwGf3ht73QDz97d7Xr4F7wK9Wv54UFf8evknRj7x78t6Lp+vA9uVeHfjse38PDtCeJyn6fkzFbfqgpFX922GgNpA0XVJb3jKvVtxbogF6GAu81w5q73h+oW3VOZLWB9BuA74P8+7f/3fPa49C24Tb4udbqIG/9/pv6wstN0nR98uCePpaSV+Jb79ZUUg5Y7DafbehpD/nLWO904pGMdwTt+MuSe+K5yd1oEd/evw8vdv3dh3Y9i9UtJ19TNE29uTB/paKAtrKAZ7r6vh5KuN1/kHxCJkA2q9QzQO2X3zfvykKOy9I+pd43nGKtvUzFIXaX+hAj+sTinuy4+nf5q3nLYp2tu5SvD3KW26O+vWoKvrOPie+/eX+949BO85TtMPnZkmPKtqBdETe/X2+cxTtbL5NB/JE72+aBfH7a6uiUYbT+q3nNXHb9373nRe36ZT4PfQ7SZcp+hz/UtKMeLnFintpi9S0TNHoyKSikUV/lnRxKdtp3Pe4WnRMwoWKGvBVivYyvz+++5a8/98a336vom71WYqGvXynt1cgfr63SNrtnMsf+/6/zWyjojfayYr2OOTL37MhRXtA/sui8fNfiR8jRV/o3XGdx0u6zMxeK0nOuW7n3DxFezDfbAWOERkNg7ShdPDrO0fRnlg5536m6AdC/vMdJul/KXpzD+ZqRRu8g47tLNImh0va45ybL+mbin54SNEH6QxFYfp8SZ81sxOGUEOpnCvpv5xzz8f174xrv9vMWiV9UgfeCzWKQrbiZXvbsEfSrfHt70r6i/wVmNmVin4UrMmb3eycyzrnOiX9SNJfDPI3LdR+wbDoGL4fSvqYi3pQPijpo2a2QdFGcV+/5U9WtDPgw3mzi31uB/pu6H2u9yvag/jleFaNoqExu6X9f9f85fv/TQp+zsfQXzjnTlcUuv+vmZ2j6PNxjKLhf5+U9IN4b6qkg9vQouPXPqJ4KLGijf5nzOxISVXOudslyTm3xx3oqf6Vc+53zrluRW27//3rnDtf0Q+UwyWdG/+N36bou3KTpG/E90tRm98Qz/+Jop7cPsd1joEFkm530Z79F+M6JOlrkl6n6EfINkXDqEZssO9h59wH4vmbJS2Ot1vXK/oB0l8I78E+nHObFb2/1kpqUrQjpTt/mSFsi4a6rj7vtULLDbKt6r/d86XQ+7CYgbYJfynpOefchiKPG+pr/k9FPTj/v71zjZWquuL4b1GwIG1QwUeVVCAaX4gYWnw0qBWhQiqK1Ug1KsSa2sakMdFEq2lMbK3xgzZVU/2gxdrWWttaSX3SFoooPoELKG8hFtKiNSkWqy3V1Q9rHebcuWfmXh73zqj/XzKZOfvsc87e6+zn2mvteSaPbyEsdJYSJopLiHe7K2nvDbpNh8eo3PPwK0T5PJio53fmarQBN5vZMsLU/RDgwIrnLSZMz48jlDPF/iCV6TCzvQnz2kpfWOBRd38vxxbziPrdl1Slu1maK+VnYd10FDEuOoToByYQE9D57v6Wu/+X2hioKe7+grsfQ7heXGfpD1+FxR4U+3isxgI80JNn7GH6E8rGn7j78YRS8drS+fr6dwZwj+fKcmnscRUwNecxPyX6gTIzCAXUB3nd08DjxCT1QUJp+AGxcj4amJt19wY6W/NVpek+YsL8MrFY9Bx17fju8rGfuBIvdkMW+O1EI31ynvNSvOL3ZYSvDO6+iFgtKG84MoPSSzKzkYRmaaK7jwEey2uK88OIRuSx0j1uAua5+2jgrFL8C4En3X27xxL7s9QtsXuYDcwjl/H7iIYybJC/7pgCLHb3LT2IewJwq5ltJEy5vmtmV5YjVMhkU6YR4BFgTCn8KXd/Nxv4BcBxO5Hu3uAOQnN4LDEhaNiwNmBHGTazmcBXiRXZqrJdPm5WLxrJbzOxklEwPMP6lJww/ZZYbfkdhPmZu09293FE/Vxfij+cyMcl7r4+w5rWW6rbBszsDGI1epqnSW03aZ1J13fSbT3vbdx9c36/SchmPPnePXiRUJIUm2l0kSEx4MDd12fefk2tDDV8dLNjd38feJSYnPQjVjjGlj5HZdR+hE97EX5IlXKrFbj7llSqfUgofopB5O7Wn2Z1tnj2B8RK6tcIBc5oYH62nycCcyw26ml5GazC3e9193Hufgqh8FxTF6WRDN4mJkb9M163sq0ra42o7KvyOefSwwF0G1JVD78ETMuy8iti0vDzIkJP+3oL0+P9CcuXuLn7O+4+KxXNl+T51/dAPnqbLYVpZH4XbjOzqLWV6wgLliOBi4i8jcu8bqGiT095bMvfjwMDrMnGdoQibCTQke9nOLDYzA4qbln/iJ3O6Z7HaZzmRvKbDjzv7ttSPk9QpziuYEe7mvVyCNEe1BISSrFtRHvYzmwCNrn7C3n8G2Ii2+M2x8J97LjSPR6ia7/caR4D4O4/yL50EqGAWZPfr5b62WPdfXLpWV3S5GFufFXGP5vYW6a+Hd8tPgkT1zeAE81s71w9mEhopCGWvYvvRaX4EwHM7Cii0Xkrj/sRttw7/FsJs4h3ga0WPhtT6p5/HmFKU/YvGkKtU51Zl9bT81mDiYHGKgt/rmJH0kHAJMLRv69oJsOq/C0gBkaY2RTCHLZMjzXV7j7B3Ue4+whCe3Ozu9/ZjUx+T2w0A3AqtUrzKKFZ7p8azBNK+egL/gycb2ZDAcxsPzqXhUtLcedS8rHIlQaIOnte/r4QWJjnzyT8SKZ5bXWrYJLF7oiDCB+dZ2n+ThvJbw5wiQUnAlvd/W87L4ZdJ9N6L2Eaelsp/ID87kdoBe/O432Igda17v5s6Vbd1dsubYOZHU+s+k3zzv7Rc4FZWaaK99rsnVTW850Wxi5iZoNzVbR4/mTC3GrHe09LhL2AfzSR4Wbg6OwoIergSg/f400WvunFro97Z5zxFru/9iNku9DCL6wYHPYnLCJWeWjuN5jZ+XnOzKxQND1NrNwUYbunVwAABqRJREFUeWq6w3svsYDwoxyU8jwr01L2AZpOyBai/sxIeYwEDifMwnpKZZ1NuRS7RhqxQrjK3be6+7BS+/k8URZfpsVlsBGlevx5YkD0y7oolTJIxck8am3jpUR7X3//yrLWJEmN+qozCBlv6mneepHKctgNXfoEd7/O3YdnWZlBmOWXV7Or+vpOmNk3iNW0r6fipgjfx3KXZ8IlZkHW711Je2/QKB1zqPXL5TJVHiceSKxMvU7052+6+3Yz+zJhktkFMzsoyy9mNp7o199ulA53X+7uB5Tq8iZik8K/5y3PtvinhaGEGfJLuy2RnaMq3e81SXMj+b0BnJpjtAHE+GMl4XpyqsX+KQOA80vPLr+j84hy69nP9M9nHEpMjDc2yoDHAsg/zaywArpo90Sy86Rs/mq1fW8mEqa+UN3mzAW+WcrnfoTCb4jVrAknURrnWuwTsS+1OU/hK1uMS8cQixVPA6uB/c3spDw3wMLyqqBLmrJtHpy/JwH/c/fX2JN4H9pvt+pD+G2tIgYQDxDmQRsJs6RlRCU/LOMeTQzsOwhThsml+5xGaIPq7z+bGNz/idAAzyydmw+cWRf/pIy/BPg+uXMx4cf5MGGT/xpwTYaPybjLMg99vothlQyb5G8oUehfJVYcyrvJDSYa6CF110wnGrb/EFrKpyrScCM1f4+GMiE0PI8RPheLCO1Tce6alO0Kwsy0r+V4aT67I8vN2USD/Qphejq/VBbuL8U9N8O3EWYfK4iJcOF7sI7wbVman2KXvZnEhGQesJbc2bGbd1opP0L7dhexmrmcFvi3Eqalnu+9yOtUwu9tTX5uoeZXdAMxQV1a+hS75c6mot7SuG34Y5bN4j5zSum6NsvVUkK50uydVNbzPpThqCxTHZmGwp93L8L8fAVhynZ6D2R4BdEpLiP8eIdm+OFZPpcRZXsU0X4uyLK1mlAu9CNM6V6iVpfvoOazM5IwG+1IWRW+88MILe+yDL+7r8tipuP6LEMLiUnW1URdWp5pmwN8ri7++sz/lFL4Rmpt5EFEW/gO4R+0iZrfXFVf1o/os5Zn+C+o2BGSzj6uLS2DTeT5TKang7CGgK4+ro3arVGEImBd5q0In0nNH65ZWat/TmVfVWo7rmi1vLoph5V9Kk36hNL9TqPOd5Xqvr5TPMIlYj21dqKor8WYZzXR1u7bLO1tJMOhRP+wlmj/Cx/Cg4kxTlHniv0LhhF95nLCRHMluVs3nev4lVn3OgiF0sk7Iw+6+rj+LJ+7Fri8XeTXJM2N5PcpQjm8kmgHbitdPyvv/yLx7x9FnR5I1Pd1eW5Uhl+cMl5K9GfnlO71IOHGsZ2oI5dl+DhqY/9bac2uwmMJM9tlRD0t9kiYTV2bQ5gW30atzbwyw6enbDuIejuqdM2NxCaM5fsMzHu8luVxbF16FlAbL1xeOleVphFEPV9J1JlD97SMisGdEEIIIYQQQgjRlnwSTIWFEEIIIYQQQnyE0cRVCCGEEEIIIURbo4mrEEIIIYQQQoi2RhNXIYQQQgghhBBtjSauQgghhBBCCCHaGk1chRBCiD7GzG40s6tbnQ4hhBDio4ImrkIIIUQbUPyRvBBCCCG6oomrEEII0QeY2fVmtsbMFgJHZNh8M/uRmb0MfMfMJprZEjNbbmb3mdmnM95UM1tlZq+Y2Y/N7A8ZPt7MFuU1z5nZEa3LoRBCCNF7aOIqhBBC9DJmNg6YAYwFpgJfLJ3ey92/ANwFzAYucPdjgf7At8xsIHAPMMXdxwH7l65dBUxw9+OB7wE393ZehBBCiFagiasQQgjR+0wAHnH3f7v7O8Cc0rmH8vsIYIO7r8nj+4FTgCOB1919Q4Y/WLp2CPCwma0AbgeO6a0MCCGEEK1EE1chhBCitby7G9feBMxz99HAWcDAPZMkIYQQor3QxFUIIYTofRYA55jZIDP7LDHJrGc1MMLMDsvji4G/ZPgoMxuR4ReUrhkCbM7fM/dwmoUQQoi2QRNXIYQQopdx98WESXAH8ATwUkWc94FZhOnvcuBD4G53fw/4NvCkmb0C/AvYmpfdCvzQzJYQPrFCCCHExxJz91anQQghhBBNMLPPuPs2MzNiE6e17n57q9MlhBBC9BVacRVCCCHan8vNbCnwKmEefE+L0yOEEEL0KVpxFUIIIYQQQgjR1mjFVQghhBBCCCFEW6OJqxBCCCGEEEKItkYTVyGEEEIIIYQQbY0mrkIIIYQQQggh2hpNXIUQQgghhBBCtDWauAohhBBCCCGEaGv+D3FD9xQHEjNkAAAAAElFTkSuQmCC\n",
            "text/plain": [
              "<Figure size 1152x576 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    }
  ]
}