imersao_dados_alura_aula_04.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "imersao_dados_alura_aula-04.ipynb",
      "provenance": [],
      "collapsed_sections": [],
      "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/Juliaocmc/imersao_dados_alura/blob/main/imersao_dados_alura_aula_04.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "X_Lg2XTu20ND"
      },
      "source": [
        "#Aula 04\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 247
        },
        "id": "NNlJ4gcoWe1c",
        "outputId": "7e508da3-0fdb-451e-fac7-2cf6eb150980"
      },
      "source": [
        "import pandas as pd\n",
        "import seaborn as sns\n",
        "import matplotlib.pyplot as plt\n",
        "import numpy as np\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.head()"
      ],
      "execution_count": null,
      "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",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 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",
              "[5 rows x 877 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 1
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 265
        },
        "id": "iV5BAXmSWwMn",
        "outputId": "84ea02dd-21e6-4905-d2ee-ea46f3f169bc"
      },
      "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": null,
      "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": "dhKclmeUXLUJ",
        "outputId": "cd760bcb-728f-44d7-f395-5f3f3bb0c60c"
      },
      "source": [
        "contagem_moa = dados_resultados.drop('id', axis=1).sum().sort_values(ascending=False)\n",
        "contagem_moa"
      ],
      "execution_count": null,
      "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": 3
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 265
        },
        "id": "CPv-LIiIXLqW",
        "outputId": "2e85dfa0-fd34-4ff8-d80c-ba3e2666d9cd"
      },
      "source": [
        "dados_resultados.drop('id', axis=1).sum(axis=1)\n",
        "dados_resultados.head()"
      ],
      "execution_count": null,
      "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": 4
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "2RS7UOsJXLv2",
        "outputId": "c7f6008b-6539-4692-fa2f-d57fab6d50bb"
      },
      "source": [
        "dados_resultados['n_moa'] = dados_resultados.drop('id', axis=1).sum(axis=1)\n",
        "dados_resultados['n_moa'] != 0"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "0         True\n",
              "1        False\n",
              "2         True\n",
              "3        False\n",
              "4         True\n",
              "         ...  \n",
              "23809     True\n",
              "23810     True\n",
              "23811    False\n",
              "23812     True\n",
              "23813    False\n",
              "Name: n_moa, Length: 23814, dtype: bool"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 265
        },
        "id": "uTRYbbfSXL1b",
        "outputId": "5c14088f-f138-4c45-bd26-49ba3ded206a"
      },
      "source": [
        "dados_resultados['ativo_moa'] = (dados_resultados['n_moa'] != 0)\n",
        "dados_resultados.head()"
      ],
      "execution_count": null,
      "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": 6
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 247
        },
        "id": "RBezYs38XL5p",
        "outputId": "3e63470b-4816-4d0a-bcfd-26cfdb920903"
      },
      "source": [
        " dados_combinados = pd.merge(dados, dados_resultados[['id','n_moa', 'ativo_moa']], on='id')\n",
        " dados_combinados.head()"
      ],
      "execution_count": null,
      "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": 7
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "od0m1EQbXf03",
        "outputId": "eee95e48-5e6f-4884-eb5c-9ade3f55c447"
      },
      "source": [
        "  dados_combinados.query('tratamento == \"com_droga\"' )['ativo_moa'].value_counts()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "True     14447\n",
              "False     7501\n",
              "Name: ativo_moa, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "PkUKLv35XgC1"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "cDS8U6zaXgIr"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "f0omdurCXgOS"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "h47xxNhGWGLg"
      },
      "source": [
        "\n",
        "###Desafio 01: Encontrar o top 10, das ações do MOA (inibidor, agonista...)\n",
        "\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 348
        },
        "id": "hpGmOsS_rbFY",
        "outputId": "e0b91b06-8bad-4624-848a-653896e4bf5f"
      },
      "source": [
        "inibidores = contagem_moa.filter(like='inhibitor').head(10)\n",
        "table_inibidores = pd.DataFrame(inibidores)\n",
        "table_inibidores.rename(columns={'index':'inibidores',0: 'Contagem'}, inplace=True)\n",
        "table_inibidores"
      ],
      "execution_count": null,
      "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>Contagem</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>nfkb_inhibitor</th>\n",
              "      <td>832</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>proteasome_inhibitor</th>\n",
              "      <td>726</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>cyclooxygenase_inhibitor</th>\n",
              "      <td>435</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>dna_inhibitor</th>\n",
              "      <td>402</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>cdk_inhibitor</th>\n",
              "      <td>340</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>egfr_inhibitor</th>\n",
              "      <td>336</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>tubulin_inhibitor</th>\n",
              "      <td>316</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>pdgfr_inhibitor</th>\n",
              "      <td>297</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>hmgcr_inhibitor</th>\n",
              "      <td>283</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>flt3_inhibitor</th>\n",
              "      <td>279</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                          Contagem\n",
              "nfkb_inhibitor                 832\n",
              "proteasome_inhibitor           726\n",
              "cyclooxygenase_inhibitor       435\n",
              "dna_inhibitor                  402\n",
              "cdk_inhibitor                  340\n",
              "egfr_inhibitor                 336\n",
              "tubulin_inhibitor              316\n",
              "pdgfr_inhibitor                297\n",
              "hmgcr_inhibitor                283\n",
              "flt3_inhibitor                 279"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 28
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 348
        },
        "id": "A0xHtlwbtpHR",
        "outputId": "d9541800-f77c-41df-e1cd-80e64a1d7fb8"
      },
      "source": [
        "agonistas = contagem_moa.filter(like='_agonist').head(10)\n",
        "tabela_agonistas= pd.DataFrame(agonistas)\n",
        "tabela_agonistas.rename(columns={'index':'agonistas',0: 'Contagem'}, inplace=True)\n",
        "tabela_agonistas "
      ],
      "execution_count": null,
      "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>Contagem</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>adrenergic_receptor_agonist</th>\n",
              "      <td>270</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>glucocorticoid_receptor_agonist</th>\n",
              "      <td>266</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>serotonin_receptor_agonist</th>\n",
              "      <td>236</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>acetylcholine_receptor_agonist</th>\n",
              "      <td>190</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>estrogen_receptor_agonist</th>\n",
              "      <td>158</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>dopamine_receptor_agonist</th>\n",
              "      <td>121</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>progesterone_receptor_agonist</th>\n",
              "      <td>119</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ppar_receptor_agonist</th>\n",
              "      <td>115</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>gaba_receptor_agonist</th>\n",
              "      <td>106</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>glutamate_receptor_agonist</th>\n",
              "      <td>74</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                 Contagem\n",
              "adrenergic_receptor_agonist           270\n",
              "glucocorticoid_receptor_agonist       266\n",
              "serotonin_receptor_agonist            236\n",
              "acetylcholine_receptor_agonist        190\n",
              "estrogen_receptor_agonist             158\n",
              "dopamine_receptor_agonist             121\n",
              "progesterone_receptor_agonist         119\n",
              "ppar_receptor_agonist                 115\n",
              "gaba_receptor_agonist                 106\n",
              "glutamate_receptor_agonist             74"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 31
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 348
        },
        "id": "3G0qHFGIuFOJ",
        "outputId": "bb3b1f78-30b3-4bfd-c46c-81ab6e678dfc"
      },
      "source": [
        "antagonista = contagem_moa.filter(like='antagonist').head(10)\n",
        "tabela_antagonistas= pd.DataFrame(agonistas)\n",
        "tabela_antagonistas.rename(columns={'index':'antagonista',0: 'Contagem'}, inplace=True)\n",
        "tabela_antagonistas \n"
      ],
      "execution_count": null,
      "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>Contagem</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>adrenergic_receptor_agonist</th>\n",
              "      <td>270</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>glucocorticoid_receptor_agonist</th>\n",
              "      <td>266</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>serotonin_receptor_agonist</th>\n",
              "      <td>236</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>acetylcholine_receptor_agonist</th>\n",
              "      <td>190</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>estrogen_receptor_agonist</th>\n",
              "      <td>158</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>dopamine_receptor_agonist</th>\n",
              "      <td>121</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>progesterone_receptor_agonist</th>\n",
              "      <td>119</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ppar_receptor_agonist</th>\n",
              "      <td>115</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>gaba_receptor_agonist</th>\n",
              "      <td>106</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>glutamate_receptor_agonist</th>\n",
              "      <td>74</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                 Contagem\n",
              "adrenergic_receptor_agonist           270\n",
              "glucocorticoid_receptor_agonist       266\n",
              "serotonin_receptor_agonist            236\n",
              "acetylcholine_receptor_agonist        190\n",
              "estrogen_receptor_agonist             158\n",
              "dopamine_receptor_agonist             121\n",
              "progesterone_receptor_agonist         119\n",
              "ppar_receptor_agonist                 115\n",
              "gaba_receptor_agonist                 106\n",
              "glutamate_receptor_agonist             74"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 35
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "7dtg1cinWGbD"
      },
      "source": [
        "###Desafio 02: Criar a coluna eh_controle para quando na linha tratamento == com_controle\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 247
        },
        "id": "eFQtvAx5vP2q",
        "outputId": "3a3b20c1-9034-44d6-c623-e07a5189fae9"
      },
      "source": [
        "dados_combinados['eh_controle'] = (dados_combinados['tratamento'] != \"com_droga\")\n",
        "dados_combinados.head()"
      ],
      "execution_count": null,
      "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-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",
              "      <th>eh_controle</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.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",
              "      <td>False</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.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",
              "      <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.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",
              "      <td>False</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>-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",
              "      <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.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",
              "      <td>False</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 880 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "             id tratamento  tempo dose  ...    c-99  n_moa  ativo_moa  eh_controle\n",
              "0  id_000644bb2  com_droga     24   D1  ...  0.4176      1       True        False\n",
              "1  id_000779bfc  com_droga     72   D1  ...  0.7371      0      False        False\n",
              "2  id_000a6266a  com_droga     48   D1  ...  0.6931      3       True        False\n",
              "3  id_0015fd391  com_droga     48   D1  ... -0.8154      0      False        False\n",
              "4  id_001626bd3  com_droga     72   D2  ...  0.7125      1       True        False\n",
              "\n",
              "[5 rows x 880 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "zH3YPJ6rWGjm"
      },
      "source": [
        "###Desafio 03: Criar três colunas para indicar o tempo 24, 48, 72\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 247
        },
        "id": "f7LQu37DyRcS",
        "outputId": "bdef6b94-2389-42a2-8506-3550dd53ab7c"
      },
      "source": [
        "dados_combinados['24'] = (dados_combinados['tempo'] == 24)\n",
        "dados_combinados['48'] = (dados_combinados['tempo'] == 48)\n",
        "dados_combinados['72'] = (dados_combinados['tempo'] == 72)\n",
        "dados_combinados.head()"
      ],
      "execution_count": null,
      "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-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",
              "      <th>eh_controle</th>\n",
              "      <th>24</th>\n",
              "      <th>48</th>\n",
              "      <th>72</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.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",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>False</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.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",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>True</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.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",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>False</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>-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",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>True</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.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",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 883 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "             id tratamento  tempo dose  ... eh_controle     24     48     72\n",
              "0  id_000644bb2  com_droga     24   D1  ...       False   True  False  False\n",
              "1  id_000779bfc  com_droga     72   D1  ...       False  False  False   True\n",
              "2  id_000a6266a  com_droga     48   D1  ...       False  False   True  False\n",
              "3  id_0015fd391  com_droga     48   D1  ...       False  False   True  False\n",
              "4  id_001626bd3  com_droga     72   D2  ...       False  False  False   True\n",
              "\n",
              "[5 rows x 883 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "A7__IPRVWGtA"
      },
      "source": [
        "\n",
        "###Desafio 04: Estudar sobre combinações de DF https://pandas.pydata.org/pandas-docs/stable/user_guide/merging.html\n"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "h3HerHXyWG3V"
      },
      "source": [
        "\n",
        "\n",
        "###Desafio 05: Fazer análise mais detalhada considerando tempo e dose, para comparar as distribuições (Escolher uma droga e comparar com controle)\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "DJ1pSRSI3Q95",
        "outputId": "ac0d6e65-ff5b-422d-feb6-fa7476ba7bbe"
      },
      "source": [
        "mais_ativadas = dados_combinados[['n_moa','droga']].value_counts()\n",
        "mais_ativadas.sort_values(ascending=False)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "n_moa  droga    \n",
              "0      cacb2b860    1866\n",
              "2      87d714366     718\n",
              "1      9f80f3f77     246\n",
              "       8b87a7a83     203\n",
              "       5628cb3ee     202\n",
              "                    ... \n",
              "       b2fe3eca7       1\n",
              "       861a693e3       1\n",
              "0      b046f598b       1\n",
              "2      f0d1b8dbc       1\n",
              "1      36dc71f82       1\n",
              "Length: 3289, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 515
        },
        "id": "VY7rTsTzy7He",
        "outputId": "f8acd380-8dfe-4cd5-d165-5bff09f6fb42"
      },
      "source": [
        "\n",
        "\n",
        "lista_de_drogas = ['87d714366', '9f80f3f77', 'cacb2b860' ]\n",
        "\n",
        "droga_principal = dados_combinados['droga'].value_counts().index[:5]\n",
        "plt.figure(figsize=(12,8))\n",
        "sns.boxplot(data = dados_combinados.query('droga in @lista_de_drogas'), y= 'g-0', x='droga', hue='tempo')\n"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7f785424ca90>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 12
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAs8AAAHgCAYAAABaYIDJAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3de3hcdbn3/889TeiBgkCnltJYw88UKIdSICA+CFIglQiPiGy3B7YOPPpQ/Wm7FcUjYvmJwsatQIo+Ftk8zt4e4Cce2gsaSEAB8QEx2FLONGwiDMdO2IWWtpA29/PHTEpae1hJZtY3s9b7dV296FqzZr739GJlPrnnu9bX3F0AAAAAdi0TugAAAACgVhCeAQAAgIgIzwAAAEBEhGcAAAAgIsIzAAAAEBHhGQAAAIioLnQBQ5HNZr2xsTF0GQAAAEi4+++/v+juk7fdX1PhubGxUV1dXaHLAAAAQMKZ2d+2t59pGwAAAEBEhGcAAAAgIsIzAAAAEFFNzXkGAADA6NLX16dCoaCNGzeGLmVYxo0bp4aGBtXX10c6nvAMAACAYSsUCtpjjz3U2NgoMwtdzpC4u3p7e1UoFLT//vtHeg7TNgAAADBsGzdu1KRJk2ouOEuSmWnSpElD6poTngEAADAitRicBwy1dsIzAAAAqmbNmjX60Y9+FLqMiiE8AwAAoGoIzwAAAEBEX/3qV/Xkk09q9uzZuuCCC/S9731PRx99tGbNmqVvfetbkqSenh4ddNBBOuecc3TAAQfo7LPP1m233abjjjtOM2bM0H333SdJWrhwoT7+8Y/rXe96l2bMmKGf/OQnkkoX/l1wwQU69NBDddhhh+mGG26o2vvhbhsAAAComssuu0wPPfSQVqxYoY6ODt14442677775O56//vfr7vuukvTp09Xd3e3fvWrX+m6667T0UcfrV/84he6++67tXTpUn33u9/V7373O0nSypUrde+99+q1117TEUccodNOO0333HOPVqxYoQceeEDFYlFHH320TjjhBE2dOrXi74fOMwAAAGLR0dGhjo4OHXHEETryyCP12GOPadWqVZKk/fffX4cddpgymYwOOeQQnXzyyTIzHXbYYerp6dnyGmeccYbGjx+vbDarOXPm6L777tPdd9+tj370oxozZoymTJmi97znPfrLX/5SlfdA5xkAAACxcHd97Wtf07x587ba39PTo7Fjx27ZzmQyW7YzmYw2bdq05bFt744R950+6DwDAACgavbYYw+tXbtWkvTe975X1113ndatWydJevbZZ/XSSy8N6fWWLFmijRs3qre3V3fccYeOPvpoHX/88brhhhu0efNmrV69WnfddZeOOeaYir8XKYbOs5ldJ+l0SS+5+6HlfftIukFSo6QeSf/o7v9V7VoAAAAQr0mTJum4447ToYceqtbWVn3sYx/Tu971LknSxIkT9bOf/UxjxoyJ/HqzZs3SnDlzVCwW9c1vflP77befzjzzTN1zzz06/PDDZWa6/PLLte+++1bl/Zi7V+WFtwxgdoKkdZL+fVB4vlzSy+5+mZl9VdLe7v6VXb1Wc3Ozd3V1VbVeAAAARPfoo49q5syZsYy1cOFCTZw4UV/60pcq+rrbew9mdr+7N297bNWnbbj7XZJe3mb3GZLy5b/nJX2g2nUAAAAAIxXqgsEp7v58+e8vSJoSqA4MQVtbm7q7u4f13EKhIElqaGgY8nObmpq0YMGCYY07XKHeqxTm/QIAUAsWLlwYuoTwd9twdzezHc4dMbPzJJ0nSdOnT4+tLlTWhg0bQpcQmzS9VwAA0iZUeH7RzKa6+/NmNlXSDi+zdPdrJF0jleY8x1Ug/t5IuqEDz21ra6tUOVWVpvcKAACiC3WruqWScuW/5yQtCVQHAAAAEFnVw7OZ/VLSPZIONLOCmX1S0mWSWsxslaRTytsAAADAqBbH3TY+6u5T3b3e3Rvc/d/cvdfdT3b3Ge5+irtvezcOAAAAIJJnnnlGc+bM0cEHH6xDDjlEV1111VaPf//735eZqVgsjnis4BcMAgAAIDk++/kv6cVi5fqiU7L76IdX/utOj6mrq9P3v/99HXnkkVq7dq2OOuootbS06OCDD9Yzzzyjjo6Oit14gvAMAACAinmx+LKemnpi5V7w+Tt2ecjUqVM1depUSaXlwGfOnKlnn31WBx98sL7whS/o8ssv1xlnnFGRckJdMAgAAABUXE9Pj5YvX653vvOdWrJkiaZNm6bDDz+8Yq9P5xkAAACJsG7dOp111lm68sorVVdXp+9+97vq6Oio6Bh0ngEAAFDz+vr6dNZZZ+nss8/WBz/4QT355JN66qmndPjhh6uxsVGFQkFHHnmkXnjhhRGNQ+cZAAAANc3d9clPflIzZ87U+eefL0k67LDD9NJLb67D19jYqK6uLmWz2RGNRecZAAAANe1Pf/qT/uM//kO///3vNXv2bM2ePVvLli2rylh0ngEAAFAxU7L7RLpDxpBebxfe/e53y913ekxPT09F6iE8AwAAoGJ2dU/mWse0DQAAACAiwjMAAAAQEeEZAAAAiIjwDAAAAEREeAYAAAAiIjwDAACg5m3evFlHHHGETj/9dEnS7bffriOPPFKzZ8/Wu9/9bnV3d1dkHG5VBwAAgIr52hc+q1d6R7YE9mBvmbSvLr3ih7s87qqrrtLMmTP16quvSpI+85nPaMmSJZo5c6Z+9KMf6ZJLLtFPf/rTEddDeAYAAEDFvNL7gr7a9ETFXu+yCA3jQqGgm2++Wd/4xjf0gx/8QJJkZluC9CuvvKL99tuvIvUQngEAAFDTPv/5z+vyyy/X2rVrt+y79tpr9b73vU/jx4/XnnvuqXvvvbciYzHnGQAAADXrpptu0lvf+lYdddRRW+2/4oortGzZMhUKBZ177rk6//zzKzIenWcAAADUrD/96U9aunSpli1bpo0bN+rVV1/Vaaedpscee0zvfOc7JUkf/vCHdeqpp1ZkPDrPAAAAqFmXXnqpCoWCenp6dP311+ukk07SkiVL9Morr+iJJ0pzrzs7OzVz5syKjEfnGQAAAIlSV1enn/zkJzrrrLOUyWS0995767rrrqvMa1fkVQAAAACVbi0X5Q4ZQ3m9qE488USdeOKJkqQzzzxTZ555ZuUKKSM8AwAAoGKi3JO5ljHnOZBisaj58+ert7c3dCkAAACIiPAcSD6f18qVK5XP50OXAgAAgIgIzwEUi0W1t7fL3dXe3k73GQAAoEYQngPI5/Nyd0lSf38/3WcAAIAaQXgOoLOzU319fZKkvr4+dXR0BK4IAAAAURCeA2hpaVF9fb0kqb6+XnPnzg1cEQAAQO16/PHHNXv27C1/9txzT1155ZW64IILdNBBB2nWrFk688wztWbNmhGPxa3qAsjlcmpvb5ckZTIZ5XK5wBUBAABUxue++Dm92PtixV5vyqQpuvr7V+/0mAMPPFArVqyQJG3evFnTpk3TmWeeqccff1yXXnqp6urq9JWvfEWXXnqp/uVf/mVE9RCeA8hms2ptbdXSpUvV2tqqSZMmhS4JAACgIl7sfVHPHfVc5V7w/qEdfvvtt+sd73iH3v72t+vtb3/7lv3HHnusbrzxxhGXw7SNQHK5nGbNmkXXGQAAoIKuv/56ffSjH/27/dddd51aW1tH/PqE50Cy2awWLVpE1xkAAKBC3njjDS1dulQf+tCHttr/ne98R3V1dTr77LNHPAbTNgAAAJAI7e3tOvLIIzVlypQt+37605/qpptu0u233y4zG/EYhGcAAAAkwi9/+cutpmzccsstuvzyy3XnnXdqwoQJFRmDaRsAAACoea+99po6Ozv1wQ9+cMu+z33uc1q7dq1aWlo0e/ZsffrTnx7xOHSeAQAAUDFTJk0Z8h0ydvl6Eey+++7q7e3dal93d3flCikjPAMAAKBidnVP5lrHtA0AAAAgIsIzAAAAEBHhGQAAACPi7qFLGLah1k54BgAAwLCNGzdOvb29NRmg3V29vb0aN25c5OdwwSAAAACGraGhQYVCQatXrw5dyrCMGzdODQ0NkY8PGp7N7AuSPiXJJT0o6Vx33xiyJgAAAERXX1+v/fffP3QZsQk2bcPMpklaIKnZ3Q+VNEbSR0LVAwAAAOxK6DnPdZLGm1mdpAmSngtcDwAAALBDwcKzuz8r6V8lPS3peUmvuHtHqHoAAACAXQk5bWNvSWdI2l/SfpJ2N7N/2s5x55lZl5l11epEdAAAACRDyGkbp0h6yt1Xu3ufpN9I+m/bHuTu17h7s7s3T548OfYiAQAAgAEhw/PTko41swlmZpJOlvRowHoAAACAnQo55/nPkm6U9FeVblOXkXRNqHriViwWNX/+fPX29oYuBQAAABEFvduGu3/L3Q9y90Pd/ePu/nrIeuKUz+e1cuVK5fP50KUAAAAgotC3qkulYrGoZcuWyd118803030GAACoEYTnAPL5vPr6+iRJfX19dJ8BAABqBOE5gFtvvXWr7VtuuSVQJQAAABgKwnMAdXV1O90GAADA6ER4DmDdunU73QYAAMDoRHgOoLGxcafbAAAAGJ0IzwFceOGFW21fdNFFgSoBAADAUBCeAzjggAO2dJsbGxvV1NQUtiAAAABEQngO5MILL9Tuu+9O1xkAAKCGcJuHQA444AC1t7eHLgMAAABDQOcZAAAAiIjwDAAAAEREeAYAAAAiIjwDAAAAERGeAQAAgIgIzwAAAEBEhGcAAAAgIsIzAAAAEBGLpIxAW1uburu7h/XcQqEgSWpoaBjW85uamrRgwYJhPRcAAADDQ3gOZMOGDaFLAAAAwBARnkdgJJ3fgee2tbVVqhwAAABUGXOeAQAAgIgIzwAAAEBEhGcAAAAgIsIzAAAAEBEXDKbMSG6vNxKrVq2SNLKLLIeDW/oBAIBKIjynTHd3t5546K+aPnFzrOPu1lf6kmNjz19iG/PpdWNiGwsAAKQD4TmFpk/crAub14Uuo+ou6ZoYugQAAJAwzHkGAAAAIiI8AwAAABExbQOJVigUYr9gkIsjAQBILsIzEm3Dhg1a/vByaa8YB+0v/Wf5s8vjG3NNfEMBAJBmhGck315S/4n9oauoqswdzMACACAOfOICAAAAERGeAQAAgIgIzwAAAEBEhGcAAAAgIsIzAAAAEBHhGQAAAIiI8AwAAABERHgGAAAAIiI8AwAAABERngEAAICICM8AAABAREHDs5ntZWY3mtljZvaomb0rZD0AAADAztQFHv8qSbe4+z+Y2W6SJgSuBwAAANihYOHZzN4i6QRJ50iSu78h6Y1Q9QAAAAC7EnLaxv6SVkv632a23MyuNbPdA9YDAAAA7FTI8Fwn6UhJ/8vdj5D0mqSvbnuQmZ1nZl1m1rV69eq4awQAAAC2CBmeC5IK7v7n8vaNKoXprbj7Ne7e7O7NkydPjrVAAAAAYLBg4dndX5D0jJkdWN51sqRHQtUDAAAA7Erou23Ml/Tz8p02/lPSuYHrAQAAAHYoaHh29xWSmkPWAAAAAETFCoMAAABARIRnAAAAICLCMwAAABAR4RkAAACIiPAMAAAARER4BgAAACIKfZ9nxKxQKOi1tWN0SdfE0KVU3d/WjlGfvS5NCF0JAABICsIzEm3z5s3SGilzR8K/ZFkjFbwQugoAABKP8JwyDQ0N2rjpeV3YvC50KVV3SddEda/bTf3qD10KAABICMIzEm3s2LHqm9Cn/hOTHaAzd2TUMK0hdBkAACRewr/LBgAAACqH8AwAAABERHgGAAAAIiI8AwAAABERngEAAICICM8AAABARIRnAAAAICLCMwAAABAR4RkAAACIiPAMAAAARER4BgAAACIiPAMAAAAREZ4BAACAiAjPAAAAQESEZwAAACAiwjMAAAAQEeEZAJAIxWJR8+fPV29vb+hSACQY4RkAkAj5fF4rV65UPp8PXQqABCM8AwBqXrFYVHt7u9xd7e3tdJ8BVA3hGQBQ8/L5vNxdktTf30/3GUDVEJ4BADWvs7NTfX19kqS+vj51dHQErghAUhGeAQA1r6WlRfX19ZKk+vp6zZ07N3BFAJKqLnQBo0FbW5u6u7tjHXPVqlWSpAULFsQ6bqFQUDbWEQGg+nK5nNrb2yVJmUxGuVwucEUAkorwLKm7u1vLH3xE/RP2iW1Me6M0N+/+J1+IbczM+pc1cVy9nn59jC7pmhjbuJL04vrSlxxTJvTHNubT68bIxsY2HICAstmsWltbtXTpUrW2tmrSpEmhSwKQUITnsv4J+2jjwaeHLqOqxj1yk8aP3aSGGTNiH/uNcqd9XGN8Yx+gUqd9ndbFNiaAcHK5nHp6eug6A6gqwnPKNDQ0qK2tLfZxB6anxD32ggULtPrZ1bGOCYwmxWJRF198sRYuXJj4bmw2m9WiRYtClwEg4bhgEAASjIVDAKCyCM8AkFAsHAIAlce0DSTfGilzR4y/Jw5MsY7zmsw1kqbFOB5qwvYWDjn//PMDVwUAtY3wjERramqKfcyB2xDOmBbjhZnTwrxXjG7bWziE8AwAI0N4RqLFfR/twWOGuDATGKylpUXLli1TX18fC4cAQIUw5xkAEiqXy8nMJLFwCABUCuEZABJqYOEQM2PhEACoEKZtAECCsXAIAFQW4RkAEoyFQwCgsoJP2zCzMWa23MxuCl0LAAAAsDPBw7Okf5b0aOgiAAAAgF0JGp7NrEHSaZKuDVkHAAAAEEXozvOVkr4sqX9HB5jZeWbWZWZdq1evjq8yAAAAYBvBwrOZnS7pJXe/f2fHufs17t7s7s2TJ0+OqToAAADg74XsPB8n6f1m1iPpekknmdnPAtYDAAAA7FSw8OzuX3P3BndvlPQRSb93938KVQ8AAACwK6HnPAMAqqhYLGr+/Pnq7e0NXQoAJMKoCM/ufoe7nx66DgBImnw+r5UrVyqfz4cuBQASYVSEZwBA5RWLRbW3t8vd1d7envjuM112AHEgPANAQuXzebm7JKm/vz/x3We67ADiQHgGgITq7OxUX1+fJKmvr08dHR2BK6qetHXZAYRDeAaAhGppaVF9fb0kqb6+XnPnzg1cUfWkrcsOIBzCMwAkVC6Xk5lJkjKZjHK5XOCKqidNXXYAYRGeASChstms5syZI0maM2eOJk2aFLii6klTlx1AWIRnAEiw119/fav/JlWauuwAwiI8A0BCFYtF3XXXXZKkO++8M9EX0WWzWbW2tsrM1NramuguO4Cw6kIXMBoUCgVl1r+icY/cFLqUqsqs71WhsCl0GQBisnjxYvX390sqXUS3ePFiff3rXw9cVfXkcjn19PTQdQZQVXSeASChbr/99q22b7vttkCVxCObzWrRokV0nQFUFZ1nSQ0NDXrx9TptPDjZK4SPe+QmNTTsG7oMADEZuHXbjrYBAENH5xlAqqRpCedTTjllq+2WlpZAlQDpOveQbIRnAKmSpiWc582bp0ym9GM+k8lo3rx5gStCmqXp3EOyEZ4BpEbalnDOZrNbus1z585lLjCCSdu5h2QjPANIjTQu4Txv3jwdfvjhdJ0RVBrPPSQX4RlAaqRxCWfuQIHRII3nHpKL8AwgNVjCGQiDcw9JQngGkBos4QyEwbmHJCE8A0gNlnAGwuDcQ5KwSAqAVGEJZyAMzj0kBeEZQKoMXEAHIF6ce0gKpm0AAAAAERGeAQBA1bE8N5KC8AwAAKqO5bmRFIRnAABQVSzPjSQhPAMAgKpieW4kCeEZAABUFctzI0l2eas6MztI0hmSppV3PStpqbs/Ws3CAABAMrS0tGjZsmXq6+tjeW7UvJ12ns3sK5Kul2SS7iv/MUm/NLOvVr88AKisJ554Qq2treru7g5dCiqMuzmMXizPjSTZVef5k5IOcfe+wTvN7AeSHpZ0WbUKi1tm/csa98hNsY1nG1+VJPm4PWMbM7P+ZUn7xjYeMBpddNFFeu2113ThhRfq+uuvD10OKmjw3RzOP//80OVgkIHluZcuXcry3Kh5uwrP/ZL2k/S3bfZPLT+WCE1NTbGPuWrVWknSjHfEGWb3DfJegdHiiSee0HPPPSdJeu6559Td3c05kRDb3s0hl8sR0EYZludGUuwqPH9e0u1mtkrSM+V90yU1SfpcNQuL04IFC4KN2dbWFvvYQFpddNFFW23TfU6O7d3Nge7z6MLy3EiKnc55dvdbJB0g6WJJt5b/LJR0YPkxAKgZA13nHW0nUVrmAXM3BwBx2eWt6ty9393vdfdfu/uvJc1y980x1AYAGKG0rOrW0tKi+vp6SeJuDhgV0vKLaxoN5z7Pn654FQAQg6lTp261vd9++wWqJB5pWtVt8DxaM2NeLYJLyy+uaTSc8GwVrwIAYvDtb397q+1LLrkkUCXxyOfz6u8vXdu9efPmRH+IZ7NZTZtWWo5gv/3242JBBJWmX1zTKFJ4NrPzB/5I+nX57580s9lVrg8AKmafffbZanvvvfcOVEk8Ojs7tWnTJknSpk2bEj0PuFgsbnUnFcIKQmI58mSL2nluVmm6xjRJe0uaJ+lUST8xsy9XqTYAqKh8Pq8xY8ZIksaMGZP4D7Tjjz9+q+0TTjghUCXVN7jLTlhBaFzAmmxRw3ODpCPd/Yvu/kVJR0l6q6QTJJ1TpdoAoKI6Ozu1eXPpeufNmzfzgZYgaeqyY/TjAtZkixqe3yrp9UHbfZKmuPuGbfYDwKiVtg+0P/7xj1tt33XXXYEqqb40ddkx+rEcebJFDc8/l/RnM/uWmX1L0p8k/cLMdpf0SNWqA4AKGvyBloY7MrS0tGy1nfRfFoDRYmA5cjNjOfIE2tUKg5Ikd/+2mbVLOq6869Pu3lX++9lVqQyjTltbm7q7u4f13FWrVkka3mqOTU1NQVaBRPJks1lNmTJFzzzzjKZMmZL4D7Tjjz9eS5Ys2bL9nve8J2A11bW9LvvXv/71QNUALEeeZJFvVefuXe5+VflP166fAbxp/PjxGj9+fOgykHLFYlGFQkGSVCgUEn9Hhquvvnqr7auuuipQJdXX0tKiurpSP6iuro4uO4IbWI486b+kS+lbECZS5xmQhtc1BkaTxYsXb7l9lLtr8eLFie5O9vT07HQ7SXK5nNrb2yWV7qRCtw+Iz+AFYc4///zQ5VRdsPBsZm+T9O+SpkhySde4e3LbIgCCu+2227ba7uzsTHR4bmxs3CowNzY2BqtlKIY7RWxgPvvEiRN18cUXD/n5TBFDJRWLRV188cVauHBhorvP2y4Ik8vlEv1+peGtMFgpmyR90d0PlnSspM+a2cEB6wGQcAPhakfbSfOJT3xiq+1zzz03UCXxyGQyymQy2nfffUOXAqRmee40LggTrPPs7s9Ler7897Vm9qhKi7Bw9w4AVXHyySfr1ltv3bJ9yimnBKym+q699tqtthcvXqw5c+YEqia64XZ/B57X1tZWyXKAIUtTN3Z7C8IkfepGyM7zFmbWKOkISX8OWwmAJJs3b54ymdKPvUwmo3nz5gWuqLoGlqve0TaA6khTNzZt98+XRsEFg2Y2UdKvJX3e3V/dzuPnSTpPkqZPnx5zdQCSJJvNqqWlRbfeeqvmzp2b2E4QUE3DnZM+cKebhoaGYY1bS3PS09SNHXyxbloWhAnaeTazepWC88/d/TfbO8bdr3H3Zndvnjx5crwFAkicefPm6fDDD09811mSpk6dutX2fvvtF6gSQNqwYYM2bNgQuoxYpKkbm8YFYULebcMk/ZukR939B6HqAJAuA/derSXD7fTtscceev7557dsT5w4cUidu1rq9CE+zEnftbR1Y9O2IEzIzvNxkj4u6SQzW1H+876A9QBAokyYMGHL33fbbbettgFUT9q6sWlaEEYKe7eNuyUl+z5RAKomTfMuRzLepz71KXV3d+vHP/6xmpqaKlgVgJ1JWzc2TYJfMAgAcUrLnMsBEyZM0KxZswjOQMxqcYoYoiE8A6hJzLsEAIRAeAa2Y7hTAiRp1apVkoYf7rhICwCA0YvwDFTY+PHjQ5cAAMCQpelakpEgPAPbUUsnMQAAIaXtWhLCMwAAwHaMZApfLXZjuZYkGsIzAABAhaWtG5smhGcAAIDtGEnnN23d2DQJucIgAAAAUFMIzwAAAEBEhGcAAAAgIsIzAAAAEBHhGQAAAIiI8AwAAABERHgGAAAAIiI8AwAAABERngEAAICICM8AAABARCzPPQJtbW3q7u4e1nNXrVolafhLfzY1NY1o2VAAAAAMHeE5kPHjx4cuAQAAAENEeB4BOr8AAADpwpxnAAAAICLCMwAAABAR4RkAAACIiPAMAAAARER4BgAAACIiPAMAAAARcas6AACAhBjJAm7DNdKF30YixKJxhGcAAICE6O7u1vKHl0t7xThof+k/y59dHuOgktbEO9wAwjMAAECS7CX1n9gfuoqqy9wRZvYx4RkAgJThq31g+AjPAACkTHd3t5Y/+Ij6J+wT25j2hkuS7n/yhdjGlKTM+pdjHQ/JR3gGACCF+ifso40Hnx66jKob98hNoUtAwhCeAQBAohUKhdinbYSaplIoFCSLdcjUITwDAIBE27Bhg5546K+aPnFzbGPu1le6mG1jz19iG/PpdWNkY/eQJsQ2ZCoRngEAFZemC9K4GK02TJ+4WRc2rwtdRlVd0jVRz/SFriL5CM8AEJM0BcpCoaDVr6xO/r1mA91nFkA4hGcAwaQpTDY1Nam7uztdXx2n4F6zoe4zCyAcwjOAYNJyu6zBt8riq2MAqG2EZwBBpeF2WdwqC0BcXn/9demNlHwrskYqeCH2YVPwLwsAAABUBp1nAACAhBg7dqz6JvQl/noDqdRdb5jWEP+4sY8IAAAA1Cg6zwAAINFef/11/W3jGF3SNTF0KVX1t7Vj1Gevs0hKlQUNz2Z2qqSrJI2RdK27XxayHgAA0qBQKCiz/pVUXMyaWd+rzf2bVc937aiQYOHZzMZI+qGkFkkFSX8xs6Xu/kiomgAAQPKMGTNGb5/4RkpuEzlWfeJekdUUsvN8jKRud/9PSTKz6yWdIYnwDABAFTU0NOjF1+sSf5tIqXSryLH9ayVtCF0KEiLklxjTJD0zaLtQ3gcAAACMSqN+BpCZnWdmXWbWtXr16tDlAAAAIMVCTtt4VtLbBm03lPdtxd2vkTqQj9QAABOjSURBVHSNJDU3N3s8pQFA5RUKBb22liv+AaCWhQzPf5E0w8z2Vyk0f0TSxwLWAyBmabniP7O+V4XCptBlAEiLNTEvzz1wHWbcfYE1CjLhN1h4dvdNZvY5SbeqdKu669z94VD1AEC1NTQ0aOOm51NxxX/3OsX/AR7CGqnghdBVAFuMHz9eM2bMiHXMVatWSZJmTIt3XE2Tmpqa4h1Tge/z7O7LJC0LWQOAcNJyxf+4R25SQ8O+ocsAkAINDQ1qa2uLdcwFCxZIUuzjhsIKgwCAihs7dqz6JvSp/8T+0KVUVeaOjBqmNYQuA0CMEv59GgAAAFA5hGcAAAAgIqZtAACQQpn1L8d6pxvb+KokycftGduYUul9alx9rGMi2QjPAACkTIg7FKxatVaSNOMdcV88u68KhYK0aU3M4yKpCM8AAKTMwN0RQowZ4o4MCxYs0Mae52MfF8lEeAYAAIn39Lp4V/d8cX3psrIpE+K748zT68bogNhGSy/CMwAASLQQ01TeKC8cMq4xvoVDDlCY95o2hGcAAJBoaZumguoiPANAjNLy1bGNjW04AIgV4RkAYpKmr44LhYLWaV1sYwJAXAjPABCTNH11vGDBAq1+dnWsYwJAHAjPAIJKw0INmfUvS4r73rYAgGogPAMIJj0LNeybzivg10iZOzLxjTcwSyS+KeXSGknTYhwPQHCEZwDBpGkaQ9qE+cWoNL97xrT45ndrGrcGA9KG8AwAqDh+MQKQVDF+nwYAAADUNsIzAAAAEBHhGQAAAIiI8AwAAABERHgGAAAAIiI8AwAAABERngEAAICICM8AAABARCySAgAAALW1tam7u3vIzxtY3XO4iyM1NTUFWVhpuAjPAAAAGLbx48eHLiFWhGcAAADUVPc3JOY8AwAAABERngEAADBsxWJR8+fPV29vb+hSYkF4BgAAwLDl83mtXLlS+Xw+dCmxIDwDAABgWIrFotrb2+Xuam9vT0X3mfAMAACAYcnn83J3SVJ/f38qus+EZwAAAAxLZ2en+vr6JEl9fX3q6OgIXFH1EZ4BAAAwLC0tLaqvr5ck1dfXa+7cuYErqj7u8wwAALAdw11xT0rPqnu5XE7t7e2SpEwmo1wuF7ii6iM8AwCAyFjCOZq0rLqXzWbV2tqqpUuXqrW1VZMmTQpdUtURngEAQNXVYpispbAeUi6XU09PTyq6zhLhGQAADAGBEtvKZrNatGhR6DJiwwWDAAAAQESEZwAAACAiwjMAAAAQEeEZAAAAiIjwDAAAAEREeAYAAAAiChKezex7ZvaYma00s9+a2V4h6gAAAACGIlTnuVPSoe4+S9ITkr4WqA4AAAAgsiCLpLh7x6DNeyX9Q4g6AKAWDHc5ZGlkSyLX2nLIABCH0bDC4P+QdEPoIgAgiWpxSWQAGM2qFp7N7DZJ+27noW+4+5LyMd+QtEnSz3fyOudJOk+Spk+fXoVKAWB0o/sLAKNH1cKzu5+ys8fN7BxJp0s62d19J69zjaRrJKm5uXmHxwEAkmG401RGMkVFYpoKgGiCTNsws1MlfVnSe9x9fYgaAADJwhQVAHGwnTR9qzeoWbeksZJ6y7vudfdP7+p5zc3N3tXVVdXaANSGkXYnZ8yYMaxx6U4CQDqY2f3u3rzt/lB322gKMS4A0J0EAIzEaLjbBgAMGd1fAEAILM8NIFWKxaLmz5+v3t7eXR8MAMA2CM8AUiWfz2vlypXK5/OhSwEA1CDCM4DUKBaLam9vl7urvb09Fd1nOu0AUFmEZwCpkc/nNXCHof7+/lR0n+m0A0BlEZ4BpEZnZ6f6+vokSX19fero6AhcUXWlsdMOANVGeAaQGi0tLaqvr5ck1dfXa+7cuYErqq40dtoBoNoIzwBSI5fLycwkSZlMRrlcLnBF1ZW2TjsAxIHwDCA1stmsWltbZWZqbW3VpEmTQpdUVWnrtANAHAjPAFIll8tp1qxZie86S+nrtANAHAjPAFIlm81q0aJFie86S+nrtANAHFieGwASLJfLqaenh64zAFQI4RkAEmyg0w4AqAymbQAAAAAREZ4BAACAiAjPAAAAQESEZwAAACAiwjMAAAAQEeEZAAAAiIjwDAAAAEREeAYAAAAiIjwDAAAAERGeAQAAgIgIzwAAAEBEhGcAAAAgIsIzACRYsVjU/Pnz1dvbG7oUAEgEwjMAJNjixYv1wAMPaPHixaFLAYBEIDwDQEIVi0V1dnZKkjo6Oug+A0AFEJ4BIKEWL16s/v5+SVJ/fz/dZwCoAMIzACTUbbfdttX2QBcaADB8hGcASCgz2+k2AGDoCM8AkFAnn3zyVtunnHJKoEoAIDkIzwCQUPPmzVMmU/oxn8lkNG/evMAVAUDtIzwDQEJls1m1tLRIkubOnatJkyYFrggAal9d6AIAANUzb948vfDCC3SdAaBCCM8AkGDZbFaLFi0KXQYAJAbTNgAAAICICM8AAABARIRnAAAAICLCMwAAABAR4RkAAACIiPAMAAAARER4BgAAACIiPAMAAAARBQ3PZvZFM3Mzy4asAwAAAIgiWHg2s7dJmivp6VA1AAAAAEMRsvN8haQvS/KANQAAAACRBQnPZnaGpGfd/YEQ4wMAAADDUVetFzaz2yTtu52HviHp6ypN2YjyOudJOk+Spk+fXrH6AAAAgKEy93hnTZjZYZJul7S+vKtB0nOSjnH3F3b23ObmZu/q6qpyhQAAAEg7M7vf3Zu33V+1zvOOuPuDkt46sG1mPZKa3b0Ydy0AAADAUHCfZwAAACCi2DvP23L3xtA1AAAAAFHQeQYAAAAiIjwDAAAAERGeAQAAgIgIzwAAAEBEhGcAAAAgIsIzAAAAEBHhGQAAAIiI8AwAAABERHgGAAAAIiI8AwAAABERngEAAICICM8AAABARIRnAAAAICLCMwAAABAR4RkAEqxYLGr+/Pnq7e0NXQoAJALhGQASLJ/Pa+XKlcrn86FLAYBEIDwDQEIVi0W1t7fL3dXe3k73GQAqgPAMAAmVz+fl7pKk/v5+us8AUAGEZwBIqM7OTvX19UmS+vr61NHREbgiAKh9hGcASKiWlhbV19dLkurr6zV37tzAFQFA7SM8A0BC5XI5mZkkKZPJKJfLBa4IAGof4RkAEiqbzaq1tVVmptbWVk2aNCl0SQBQ8+pCFwAAqJ5cLqeenh66zgBQIYRnAEiwbDarRYsWhS4DABKDaRsAAABARIRnAAAAICLCMwAAABAR4RkAAACIiPAMAAAARER4BgAAACIiPAMAAAAREZ4BAACAiAjPAAAAQESEZwAAACAiwjMAAAAQEeEZAAAAiIjwDAAAAEREeAYAAAAiMncPXUNkZrZa0t9C14Fhy0oqhi4CSCHOPSAMzr3a9nZ3n7ztzpoKz6htZtbl7s2h6wDShnMPCINzL5mYtgEAAABERHgGAAAAIiI8I07XhC4ASCnOPSAMzr0EYs4zAAAAEBGdZwAAACAiwnPKmdkXzOxhM3vIzH5pZuPM7I9mtqL85zkz+90OnttjZlkzO3DQ8SvM7FUz+3z5mA+VX7/fzP7uimMzm25m68zsS+XtcWZ2n5k9UH7exYOONTP7jpk9YWaPmtmCQY+dWB77YTO7s/L/UsDoY2brdrD/e2b2mJmtNLPfmtle5f3nmNnVO3jO3/0sKO/f7nlX3t9mZt3lcY6s1vsEqsnM/rn8//3Dgz67Dip/piw3s3fs5PzY38z+XD4PbjCz3cr7J5f3Lzez483slkGfaz82szHbGWdnn6U3DNrfY2YrQv17gfCcamY2TdICSc3ufqikMZI+4u7Hu/tsd58t6R5Jv9nZ67j744OOP0rSekm/LT/8kKQPSrprB0//gaT2QduvSzrJ3Q+XNFvSqWZ2bPmxcyS9TdJB7j5T0vXl97GXpB9Jer+7HyLpQ1H/DYCE6pR0qLvPkvSEpK/t7OAd/SwoP3yOtnPeSWqVNKP85zxJ/6vC7wGoOjM7VNL/lHSMpMMlnW5mTZI+IOlGdz9C0kbt+Pz4F0lXuHuTpP+S9Mny/pMlPejuR7j7HyX9Y/lz7VBJk/Xm59SWcXb2WeruHx702K+1i89lVBfhGXWSxptZnaQJkp4beMDM9pR0kqTflbcnmVlH+TfnayXZdl7vZElPuvvfJMndH3X3x7c3sJl9QNJTkh4e2OclA920+vKfgYn5n5H0/7l7f/nYl8r7PybpN+7+9Db7gVHNzD5R7to+YGb/YWb/fVC36jYzm1I+bqKZ/W8ze7B8/FmDXuOK8jl5u5lNliR373D3TeVD7pXUMGjYt5nZHWa2ysy+NWj/jn4W7Oi8O0PSv5fP2Xsl7WVmUyv7LwRU3UxJf3b39eVz5k6VPlM+L+kzZvaH8nF/d36Yman0GXlj+Zi8pA+Y2WxJl0s6o9wpHu/urw56nd0kuZm9bzvjDNjqs3RAecx/lPTLSv0DYOgIzynm7s9K+ldJT0t6XtIr7t4x6JAPSLp90En/LUl3l7u7v5U0fTsv+xFFOKnNbKKkr0i6eDuPjSl/JfWSpE53/3P5oXdI+rCZdZlZu5nNKO8/QNLe5UBwv5l9YlfjA6GZ2SGSLtSb37T8s6S7JR1b7nZdL+nL5cO/qdL5eVi5m/z78v7dJXWVz8k7VTpHt/U/tPW3O8dIOkvSLEkfMrPmXfws2NF5N03SM4Net1DeB9SShyQdX24OTZD0PpU6wz9WqaM8ZyfnxyRJawb9olqQNM3dV0i6SNIN5W7xBkkys1tV+lxbq1K3edngcbapa0efpcdLetHdV1XqHwBDR3hOMTPbW6Xu0f6S9pO0u5n906BDPqqtT94TJP1Mktz9ZpW+ohr8ertJer+kX0UYfqFKPzD+bs6mu28ufzXVIOmY8tdqkjRW0sbyak0/kXRdeX+dSl9xnSbpvZK+aWYHRKgBCOkkSb9y96IkufvLKv0/f6uZPSjpAkmHlI89RdIPB57o7gPnXr+kG8p//5mkdw8ewMy+IWmTpJ8P2t3p7r3lD/TfSHr3Ln4W7Oi8A2qeuz+q0tSLDkm3SFohafPgYyJ8VkYd672Spqp0Tp20o+N28Vm67ecyAiA8p9spkp5y99Xu3qfSB+l/kyQzy6rUobp5CK/XKumv7v5ihGPfKelyM+tR6Wurr5vZ5wYf4O5rJP1B0qnlXQW9Oc/rtyp1zgb23+rur5WDyF0qzV0Das0iSVe7+2GS5kkaN8Tnb7n3qJmdI+l0SWf71vck3fb+pK6d/CzQjs+7Z1WaCz2gobwPqCnu/m/ufpS7n6BSU+iJbQ7Z0fnRq9J0pbrycbs8B9x9o6QlKoXxHdnuZ2l5nA/qzV+YEQjhOd2elnSsmU0oz6M6WdKj5cf+QdJN5RN9wF0qzQWTmbVK2nub14v8G3H5osRGd2+UdKWk77r71eUrlAfuDDBeUoukx8pP+52kga+23qM3f8AtUal7Vlf+2u2dg94HMFr9XqVpE5Mkycz2kfQWvfnhmxt0bKekzw5slDthUuln+D+U//4xlaZ9yMxOVWnKx/vdff0247aY2T7l8+sDkv6knf8s2NF5t1TSJ6zkWJW+yn5+6P8MQFhm9tbyf6erFE5/sc0h2z0/yr+U/kFvnoM5lT6Ptn39iQPXA5QD8Gl683Nte3b0WXqKpMfcvRD1vaE66nZ9CJLK3f9sZjdK+qtKX+0u15urIX1E0mXbPOViSb80s4cl/R+VfqBIksxsd5WC7rzBTzCzM1Xqpk2WdLOZrSh/dbUjUyXlrXQbn4yk/9/dbyo/dpmkn5vZFyStk/Sp8vt41MxukbRSpa+xr3X3h6L/SwDxc/eHzew7ku40s80qnX8LJf3KzP5LpXC9f/nwSyT90MweUukr5YtV6n69ptLUpgtVmkv54fLxV6v01XBn6bNe97r7p8uP3afS1foNkn7m7l2StJOfBds97yQtU2l+aLdKdwU4tzL/MkDsfl3+JbZP0mfdfU35vJG0y8/Kr0i63swuKe//t+28/u6SlprZWJU+1/6g0lznv7Ojz9KySNcUofpYYRAAAACIiGkbAAAAQESEZwAAACAiwjMAAAAQEeEZAAAAiIjwDAAAAEREeAaAGmVmC83sS6HrAIA0ITwDQIIMWu0MAFAFhGcAqCFm9g0ze8LM7pZ0YHnfHWZ2pZl1SfpnMzvZzJab2YNmdl15cQaZ2fvM7DEzu9/M2szspvL+Y8zsnvJz/o+ZHRjuHQLA6EZ4BoAaYWZHqbTK2GyVVvc7etDDu7l7s6QfSvqppA+7+2EqrST7GTMbJ2mxpFZ3P0qlVT8HPCbpeHc/QtJFkr5b7fcCALWK8AwAteN4Sb919/Xu/qqkpYMeu6H83wMlPeXuT5S385JOkHSQpP9096fK+wcv8/sWlZYFf0jSFZIOqdYbAIBaR3gGgGR4bQTP/bakP7j7oZL+u6RxlSkJAJKH8AwAteMuSR8ws/FmtodKQXdbj0tqNLOm8vbHJd1Z3v//mFljef+HBz3nLZKeLf/9nArXDACJQngGgBrh7n9VaXrGA5LaJf1lO8dslHSuStMwHpTUL+nH7r5B0v8r6RYzu1/SWkmvlJ92uaRLzWy5SnOkAQA7YO4eugYAQAzMbKK7rzMzU+nCwlXufkXougCgltB5BoD0+J9mtkLSwypN1VgcuB4AqDl0ngEAAICI6DwDAAAAERGeAQAAgIgIzwAAAEBEhGcAAAAgIsIzAAAAEBHhGQAAAIjo/wLdlZAV8f1WiAAAAABJRU5ErkJggg==\n",
            "text/plain": [
              "<Figure size 864x576 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 515
        },
        "id": "k-X-Godo1xxD",
        "outputId": "ab389f8e-145f-4a88-9d22-2bbaa373a0cc"
      },
      "source": [
        "\n",
        "plt.figure(figsize=(12,8))\n",
        "sns.boxplot(data = dados_combinados.query('droga in @lista_de_drogas'), y= 'g-0', x='droga', hue='dose')"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7f7854086e50>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 13
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAs8AAAHgCAYAAABaYIDJAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3df3xcdZ3v8fcnM6UtRQSmtIst3QJB1NJSILDcKz8UUgiiVRZ3YVE7rN6t7N22EV1kV0FaBW5xFbct3ut20b2JuOJdUaRSYlPll7srmEKlxaJksUAjtGUQCm1amuRz/5iTkrb58Q3N5Htm8no+HnmQc+bMOZ8MPXPe853v+X7N3QUAAABgYFWxCwAAAADKBeEZAAAACER4BgAAAAIRngEAAIBAhGcAAAAgEOEZAAAACJSNXcBgjB8/3qdOnRq7DAAAAFS4NWvWvOjuR+67vqzC89SpU9XS0hK7DAAAAFQ4M3umt/V02wAAAAACEZ4BAACAQIRnAAAAIFBZ9XkGAABAOuzevVubNm3Szp07Y5dyQMaMGaPJkydr1KhRQdsTngEAADBomzZt0lve8hZNnTpVZha7nDfF3VUoFLRp0yYdc8wxQc+h2wYAAAAGbefOncrlcmUbnCXJzJTL5QbVek54BgAAwJtSzsG522D/BsIzAAAAolm4cKG+8pWvxC4jGOEZAAAACER4BgAAwLC68cYb9fa3v11nnnmmfvOb30iS1q5dqzPOOEMzZszQxRdfrD/84Q+SpKVLl+pd73qXZsyYocsuu0yStH37dn384x/X6aefrpNPPlk/+tGPhq12wjMAAACGzZo1a3THHXdo7dq1WrlypX75y19KkubMmaObb75Zjz/+uKZPn65FixZJkhYvXqzHHntMjz/+uL7xjW9IKobvc889V4888ojuu+8+XX311dq+ffuw1E94BgAAwLB56KGHdPHFF+vggw/WoYceqtmzZ2v79u16+eWXdc4550iS8vm8HnzwQUnSjBkz9JGPfES33367stniKMurVq3S4sWLNXPmTL3nPe/Rzp079eyzzw5L/YzzDAAAgNS655579OCDD2rFihW68cYbtW7dOrm77rzzTp1wwgnDXg8tzwAAABg2Z599tu666y61t7fr1Vdf1YoVKzRu3DgdfvjheuihhyRJ3/72t3XOOeeoq6tLzz33nN773vfq5ptv1iuvvKLXXntNF1xwgZYtWyZ3lyQ99thjw1Z/ycOzmX3LzLaY2foe644ws2Yzeyr57+GlrqOSFAoFLViwQIVCIXYpAAAAg3LKKafo0ksv1UknnaQLL7xQp512miSpoaFBV199tWbMmKG1a9fqC1/4gjo7O/XRj35U06dP18knn6wFCxbosMMO03XXXafdu3drxowZmjZtmq677rphq9+6E3vJDmB2tqTXJDW6+4nJui9LesndF5vZ30k63N2vGWhfNTU13tLSUtJ6y8Ett9yiFStWaPbs2brqqqtilwMAAEagDRs26J3vfGfsMoZEb3+Lma1x95p9ty15y7O7PyjppX1Wf1BSQ/J7g6QPlbqOSlEoFNTU1CR3V1NTE63PAAAAwyjWDYMT3f355PcXJE2MVEfZaWhoUFdXlySps7NTjY2NI7r1edmyZWptbR3y/ba1tUmSJk2aNOT7rq6u1vz584d8vwAAoPSi3zDoxX4jffYdMbO5ZtZiZi1bt24dxsrSafXq1ero6JAkdXR0qLm5OXJFlam9vV3t7e2xywAAACkTq+V5s5kd5e7Pm9lRkrb0taG7L5e0XCr2eR6uAtOqtrZW99xzjzo7O5XJZDRr1qzYJUVVqhbc+vp6SdKSJUtKsn8AAFCeYrU83y0pn/yelzR8cyqWuXw+v2dYFnfXnDlzIlcEAAAwcgzHUHXflfSfkk4ws01m9glJiyXNMrOnJNUmywAAAECqDcdoG3/h7ke5+yh3n+zu33T3gruf5+7Hu3utu+87Ggf60NDQoKqq4v+2qqoqNTY2Rq4IAAAgjkwmo5kzZ2ratGk66aST9NWvfnXPwAqFQkHvfe97dcghh2jevHlDdkym5y4zvd0wOJJH2wAAAOkw79NXa8uLQ9ceOmH8Ebr1ln/od5uxY8dq7dq1kqQtW7bo8ssv17Zt27Ro0SKNGTNGX/rSl7R+/XqtX7++3/0MBuG5zNTW1mrlypXq6OhQNpsd8TcMAgCAdNjy4kv6r4nnDN0ONz8wqM0nTJig5cuX67TTTtPChQs1btw4nXnmmUM+pG30oeowOPl8fk+3jUwmww2DAAAAiWOPPVadnZ3asqXPgdwOGOG5zORyOdXV1cnMVFdXp1wuF7skAACAEYNuGyVUqtnvnnvuOWUyGT311FN7xiMeKsx+BwAAytXTTz+tTCajCRMmlOwYtDyXoV27dmn06NEaNWpU7FIAAABSYevWrbryyis1b948mVnJjkPLcwkx+x0AAEDptLe3a+bMmdq9e7ey2aw+9rGP6dOf/vSex6dOnapt27bp9ddf11133aVVq1bpXe961wEdk/AMAACAAzZh/BGDHiFjwP0NoLOzs9/HN27cOETVvIHwDAAAgAM20JjMlYI+zwAAAEAgwjMAAAAQiPAMAAAABCI8AwAAAIEIzwAAAEAgwjMAAADKUiaT0cyZMzVt2jSddNJJ+upXv6quri5JUnNzs0499VRNnz5dp556qn72s58NyTEZqg4AAAAH7HOfmadXXtw8ZPt76/iJuumrt/a7zdixY7V27VpJ0pYtW3T55Zdr27ZtWrRokcaPH68VK1bobW97m9avX68LLrhAbW1tB1wX4RkAAAAH7JUXN+ua454csv3d/F+D237ChAlavny5TjvtNC1cuFAnn3zynsemTZum9vZ27dq1S6NHjz6guui2AQAAgIpw7LHHqrOzU1u2bNlr/Z133qlTTjnlgIOzRMszAAAAKtgTTzyha665RqtWrRqS/dHyDAAAgIrw9NNPK5PJaMKECZKkTZs26eKLL1ZjY6OOO+64ITkG4RkAAABlb+vWrbryyis1b948mZlefvllXXTRRVq8eLHe/e53D9lxCM8AAAAoS+3t7XuGqqutrdX555+v66+/XpJ06623qrW1VV/84hc1c+ZMzZw5c7++0G8GfZ4BAABwwN46fuKgR8gYaH8D6ezs7POxa6+9Vtdee+3QFZQgPAMAAOCADTQmc6Wg2wYAAAAQiPAMAAAABCI8AwAA4E1x99glHLDB/g2EZwAAAAzamDFjVCgUyjpAu7sKhYLGjBkT/BxuGAQAAMCgTZ48WZs2bdLWrVtjl3JAxowZo8mTJwdvT3gGAADAoI0aNUrHHHNM7DKGHd02AAAAgECEZwAAACAQ4RkAAAAIRHgGAAAAAhGeAQAAgECEZwAAACAQ4RkAAAAIRHgGAAAAAhGeAQAAgECEZwAAACAQ4RkAAAAIRHgGAAAAAhGeAQAAgECEZwAAACBQ1PBsZleZ2RNmtt7MvmtmY2LWAwAAAPQnWng2s0mSFkiqcfcTJWUkXRarHgAAAGAgsbttZCWNNbOspIMl/T5yPQAAAECfooVnd2+T9BVJz0p6XtIr7r4qVj0AAADAQGJ22zhc0gclHSPpbZLGmdlHe9lurpm1mFnL1q1bh7tMAAAAYI+Y3TZqJf3O3be6+25JP5D03/fdyN2Xu3uNu9cceeSRw14kAAAA0C1meH5W0hlmdrCZmaTzJG2IWA8AAADQr5h9nh+W9H1Jj0pal9SyPFY9AAAAwECyMQ/u7tdLuj5mDQAAAECo2EPVAQAAAGWD8AwAAAAEIjwDAAAAgQjPAAAAQCDCMwAAABCI8AwAAAAEIjwDAAAAgQjPAAAAQCDCMwAAABCI8AwAAAAEIjwDAAAAgQjPAAAAQCDCMwAAABCI8AwAAAAEIjwDAAAAgQjPAAAAQCDCMwAAABCI8AwAAAAEIjwDAAAAgQjPAAAAQCDCMwAAABCI8AwAAAAEIjwDAAAAgQjPAAAAQCDCMwAAABCI8AwAAAAEIjwDAAAAgQjPAAAAQCDCMwAAABCI8AwAAAAEIjwDAAAAgQjPAAAAQCDCMwAAABCI8AwAAAAEIjwDAAAAgQjPAAAAQKBs7ALSYNmyZWptbY1dRrDuWuvr6yNXEq66ulrz58+PXQYAAMABITyrGEbXrt+gzoOPiF1KkKrXXZK05unNkSsJk9nxUuwSAAAAhgThOdF58BFqf8f7YpdRkcY+uTJ2CQAAAEOCPs8AAABAIMIzAAAAEIjwDAAAAAQiPAMAAACBCM8AAABAoKjh2cwOM7Pvm9mTZrbBzP5bzHoAAACA/sQeqm6JpCZ3/7CZHSTp4Mj1AAAAAH2KFp7N7K2SzpZ0hSS5++uSXo9VDwAAADCQmN02jpG0VdK/mNljZnabmY2LWA8AAADQr5jdNrKSTpE0390fNrMlkv5O0nU9NzKzuZLmStKUKVOGvUgMjba2NtXX18cuI1hra6sklVXN1dXVmj9/fuwyAACoaDHD8yZJm9z94WT5+yqG5724+3JJyyWppqbGh688DKX29nY99cRjmnJIZ+xSghy0u/ilzK5nWiJXEubZ1zKxSwAAYESIFp7d/QUze87MTnD330g6T9KvY9WD0ptySKc+d8q22GVUpJsePTR2CQAAjAixR9uYL+k7yUgbT0v6y8j1AAAAAH2KGp7dfa2kmpg1AAAAAKGYYRAAAAAIRHgGAAAAAhGeAQAAgECEZwAAACAQ4RkAAAAIRHgGAAAAAhGeAQAAgECEZwAAACAQ4RkAAAAIRHgGAAAAAhGeAQAAgECEZwAAACAQ4RkAAAAIRHgGAAAAAhGeAQAAgECEZwAAACBQNnYBadDW1qbMjlc09smVsUupSJkdBe0yl0bFrgQAAODA0PIMAAAABKLlWdKkSZP0wq6s2t/xvtilVKSxT67UIV2vSmqPXQoAAMABoeUZAAAACER4BgAAAAIRngEAAIBAhGcAAAAgEOEZAAAACER4BgAAAAIRngEAAIBAhGcAQGoUCgUtWLBAhUIhdikA0CvCMwAgNRoaGrRu3To1NjbGLgUAekV4BgCkQqFQUFNTk9xdTU1NtD4DSCXCMwAgFRoaGtTV1SVJ6uzspPUZQCoRngEAqbB69Wp1dHRIkjo6OtTc3By5IgDYH+EZAJAKtbW1ymazkqRsNqtZs2ZFrggA9kd4BgCkQj6fV1VV8bKUyWQ0Z86cyBUBwP4IzwCAVMjlcqqrq5OZqa6uTrlcLnZJALCfbOwCAADols/ntXHjRlqdAaQWLc8AAABAIFqeMSx27dqlZ3ZmdNOjh8YupSI982pG49raYpcBHLCek6RcddVVscsBgP3Q8gwASAUmSQFQDmh5xrAYPXq0jh7Vrs+dsi12KRXppkcP1ehJk2KXARyQ3iZJofUZQNrQ8gwASAUmSQFQDgjPAIBUYJIUAOWA8AwASAUmSQFQDujznMjseEljn1wZu4wgVTuL/Ya7xpTHyBWZHS9JY0bFLgNAynVPkrJixQomSQGQWoRnSdXV1bFLGJTW1lclSdXHToxcSaiJamtrkzpejl0IgJRjkhQAaUd4ljR//vzYJQxKfX29JGnJkiWRKwlXX1+vXc88H7sMACmXy+W0dOnS2GUAQJ+i93k2s4yZPWZmP45dCwAAANCf6OFZUr2kDbGLAAAAAAYSNTyb2WRJF0m6LWYdAAAAQIjYLc//KOmzkrr62sDM5ppZi5m1bN26dfgqAwAAAPYRLTyb2fslbXH3Nf1t5+7L3b3G3WuOPPLIYaoOAAAA2F/Mlud3S5ptZhsl3SHpXDO7PWI9AAAAQL+ihWd3/3t3n+zuUyVdJuln7v7RWPUAAAAAA4nd5xkAgD0KhYIWLFigQqEQuxQA6FUqwrO73+/u749dBwAgroaGBq1bt06NjY2xSwGAXqUiPAMAUCgU1NTUJHfXvffeS+szgFQiPAMAUqGhoUG7d++WJO3evZvWZwCpRHgGAKRCc3Oz3F2S5O5atWpV5IoAYH+EZwBAKkycOLHfZQBIA8IzACAVNm/e3O8yAKQB4RkAkAqzZs3aa/n888+PVAkA9I3wDACBGIO4tPL5vMxMklRVVaU5c+ZErggA9kd4BoBAjEFcet3hGQDSivAMAAF6jkHc1NRE63MJNDQ0qKqqeFmqqqriQwqAVCI8A0CAhoYGdXV1SZI6OzsJdiWwevVqdXR0SJI6OjrU3NwcuSIA2B/hGQACEOxKr7a2VtlsVpKUzWb3u4EQANKA8AwAAWpra5XJZCRJmUyGYFcC+Xx+T7eNTCbDDYPAMOOm6DCEZwAIkM/n95r9jmA39HK5nOrq6mRmqqurUy6Xi10SMKJwU3QYwjMAIDXy+bymT5/OhxNgmHFTdDjCMwAEYCSI4ZHL5bR06VJanYFhxk3R4QjPABCAGwYBVDLe48IRngEgACNBAKhkvMeFy8YuACPHs69ldNOjh8YuI8jmHcXPlRMP7opcSZhnX8vo+NhFVLh8Pq+mpiZJjAQBoPLwHheO8IxhUV1dHbuEQXm9tVWSNPqPy6Pu41V+r3G56R4JYsWKFYwEAaDi8B4XjvCMYTF//vzYJQxKfX29JGnJkiWRK0Ga5PN5bdy4kRYZABWJ97gwhGcACNQ9EgQAVCLe48JwwyAAAAAQiPAMAABSjWmjkSaEZwAAkGpMG400ITwDAIDUYtpopA3hGQAApBbTRiNtCM8AACC1mDYaaTPgUHVm9g5JH5Q0KVnVJulud99QysIAAABqa2u1cuVKdXR0MG00UqHflmczu0bSHZJM0iPJj0n6rpn9XenLA4D0aG1t1UUXXaTWZAZKDD1GVcC+8vm8qqqKcYVpo5EGA3Xb+ISk09x9sbvfnvwslnR68hgAjBg33HCDtm/frhtuuCF2KRVr2bJlevzxx7Vs2bLYpSAluqeNNjOmjUYqDBSeuyS9rZf1RyWPAcCI0Nraqo0bN0qSNm7cSOtzCRQKBd1///2SpPvvv5/WZ+yRz+c1ffp0Wp2RCgOF509J+qmZ3Wtmy5OfJkk/lVRf+vIAIB32bW2m9Xno7dvaTOszunVPG02rM9Kg3xsG3b3JzN6uYjeNnjcM/tLdO0tdHACkRXerc1/LOHAPPPBAv8sAkAYDDlXn7l3u/gt3v9Pd75Q0g+AMYKSZOnVqv8s4cO7e7zJGLm4kRZq8mXGerxzyKgAg5ebNm7fX8vz58yNVUrkmT5681/LRRx8dqRKkDdNzI03eTHi2Ia8CAFLuwQcf7HcZB27hwoV7LV9//fVxCkGqMD030iYoPJvZp7t/JN2Z/P4JM5tZ4voAIBVWr1691zKznAHDg+m5kTahLc81KnbXmCTpcEmflFQn6Z/N7LMlqg0AUuOss87qdxkHjhFN0Bum50bahIbnyZJOcffPuPtnJJ0qaYKksyVdUaLaACA1uHmt9BjRBL2pra1VNlscHIzpuZEGoeF5gqRdPZZ3S5ro7u37rAeAivTzn/98r+WHHnooUiWVa98bBLlhEBLTcyN9QsPzdyQ9bGbXm9n1kv5d0r+a2ThJvy5ZdQCQErW1tXst0/o19I499ti9lo877rhIlSBNmJ4baRMUnt39S5LmSno5+bnS3b/o7tvd/SOlLBAA0mD27Nl7LX/gAx+IVEnleuSRR/ZafvjhhyNVgrRhem6kSfBQde7e4u5Lkp+WUhYFAGlz991377W8YsWKSJVUrn1bFMePHx+pEqQN03MjTd7MOM8AMOLse4f/qlWrIlVSudra2vZa3rRpU6RKAKBv0cKzmR1tZveZ2a/N7Akzq49VCwAMZOLEif0uAwBGhmzEY3dI+oy7P2pmb5G0xsya3Z0bEAGkzgsvvNDv8ki0bNkytba2Dtn+9h0O0N1VXz907SrV1dVMq15iQ/1volv3txKTJk0a8n3z7wKDFa3l2d2fd/dHk99flbRBxUlYACB1jjjiiH6XceAOP/zwfpcxcrW3t6u9vT12GYCkuC3Pe5jZVEknS+LWagCp9Pvf/77f5ZFoqFvrCoWCLrnkEklSVVWVbrvtNm4QKzOlasHt/gZiyZIlJdk/MBjRbxg0s0Mk3SnpU+6+rZfH55pZi5m1bN26dfgLBAAMi1wut6e1edasWQRnAKkUNTyb2SgVg/N33P0HvW3j7svdvcbda4488sjhLRAAEpMnT95rmdnvSuOoo47SuHHjNHfu3NilAECvYo62YZK+KWmDu98Sqw4ACLFw4cK9lq+//vo4hVS4UaNGqbq6mlZnAKkVs+X53ZI+JulcM1ub/LwvYj0A0CduZgMASHFH2/i5u5u7z3D3mcnPylj1AEB/GhoalMlkJEmZTEaNjY2RKwIAxBD9hkEAKAerV69WZ2enJKmzs3O/GQcBACNDKoaqA4ChVIqJGsaOHasdO3bstcwEHgAw8tDyDAABek7HbWZMzw0AIxQtzwAqTqlacC+55BIVCgXNnj1bV111VUmOAQADKbdp0CvtmzXCMwAEmjhxonbu3Kk5c+bELgUAhhxToIchPANAIMYgBpAGTIMeF32eAQAAgECEZwAAACAQ4RkAAAAIRHgGAAAAAhGeAQAAgECEZwAAACAQ4RkAAAAIRHgGAAAAAhGeAQAAgECEZwAAACAQ4RkAAAAIRHgGAAAAAmVjF1DJli1bptbW1iHfb/c+6+vrh3zf1dXVmj9//pDvt1R4jQEAwHAiPJehsWPHxi6h4vEaAwCA3hCeS4jWxdLjNQYAAMOJPs8AAABAIMIzAAAAEIjwDAAAAAQiPAMAAACBCM8AAABAIMIzAAAAEIjwDAAAAAQiPAMAAACBmCQFAIARaNmyZWptbY1dRpDuOuvr6yNXEq66upqJvCoU4RkAgBGotbVVa9dvUOfBR8QuZUBVr7skac3TmyNXEiaz46XYJaCECM8AAIxQnQcfofZ3vC92GRVn7JMrY5eAEiI8AwAAlEA5dY2Ryq97TKyuMYRnAKhw5XQBL7eLt0TfVvSttbVVTz3xmKYc0hm7lCAH7S6OI7HrmZbIlQzs2dcy0Y5NeAaACldOF/ByunhLcS/gKA9TDunU507ZFruMinPTo4dGOzbhGQBGAC7gpRHzAg4gDsZ5BgAAAAIRngEAAIBAhGcAAAAgEOEZAAAACMQNgwCiKach1KTyHUYNADB0CM8Aoimn6YElpggGABCeAUTG9MClwxTBQFxtbW3a/mqGIQ1L4JlXMxrX1hbl2IRnAABGoLa2NmV2vMKHrBLI7Ciora0jdhkokajh2czqJC2RlJF0m7svjlkPAADAUJk0aZJ2dTzPBEUlcNOjh2r0pElRjh0tPJtZRtLXJc2StEnSL83sbnf/dayaAAAYKSZNmqQXdmXpNlUCY59cqUmTJsYuAyUSc6i60yW1uvvT7v66pDskfTBiPQAAAEC/YnbbmCTpuR7LmyT9SaRaAKBicdNS6cS8aQlAHKmfJMXM5ppZi5m1bN26NXY5AAAAGMFitjy3STq6x/LkZN1e3H25pOWSVFNT48NTGgBUDm5aKp2YNy0BiCNmy/MvJR1vZseY2UGSLpN0d8R6AAAAgH5Fa3l29w4zmyfpJyoOVfctd38iVj0AAADAQKKO8+zuKyUxOjsAAADKQupvGAQAAADSgum5AUTD9MCl1T1F8CRuaAOAIUPLMwAAABCIlmcA0TA9cGkxRTAGktnxUll881O1szjMYteY8pjoJ7PjJUmce5WK8AwAwAhUXV0du4Rgra2vSpKqjy2XQDpR1dXVam1tjV0ISoDwDADACDR//vzYJQSrr6+XJC1ZsiRyJYNTX1+vZ1/L6KZHy6PFfPOOYm/eiQd3Ra5kYM++ltHxkY5NeAYAACiBcmrdl6TXk5by0X+c/rqPV7zXl/AMACNAubR+lVPLlxS39QvpV06t+1L5tvAPN8IzAFS4cmr9KqeWLylu6xeAOAjPAFDhyqn1i5YvAGnHOM8AAABAIMIzAAAAEIjwDAAAAASizzOAqMplhjOJWc4AAIRnABGV2ygF5TrLGQBg6BCeAURTTqNASIwEAQCgzzMAAAAQjPAMAAAABCI8AwAAAIEIzwAAAEAgwjMAAAAQiPAMAAAABCI8AwAAAIEIzwAAAEAgwjMAAAAQiPAMAAAABCI8AwAAAIEIzwAAAEAgwjMAAAAQiPAMAAAABCI8AwAAAIEIzwAAAEAgwjMAAAAQiPAMAAAABMrGLgAAAADhli1bptbW1iHfb/c+6+vrh3S/1dXVmj9//pDuMybCMwAAGBLlFuqkygt2B2Ls2LGxSygLhGcAAJBqhLq9EfbjIjwDAIAhQajDSMANgwAAAEAgwjMAAAAQiPAMAAAABCI8AwAAAIEIzwAAAEAgwjMAAAAQKEp4NrN/MLMnzexxM/uhmR0Wow4AAABgMGK1PDdLOtHdZ0j6raS/j1QHAAAAECzKJCnuvqrH4i8kfThGHQCAN68UUzEzDTOAtEvDDIMfl/S92EUAAOJjGmYAaVey8GxmqyX9US8Pfd7df5Rs83lJHZK+089+5kqaK0lTpkwpQaUAgDejFK24hUJBixYt0he+8AXlcrkh3z8AHChz9zgHNrtC0iclnefuO0KeU1NT4y0tLSWtC0D5K0V3AumNLgXV1dVDvm+6FBTdcsstWrFihWbPnq2rrroqdjkARjAzW+PuNfuujzXaRp2kz0qaHRqcASC2sWPH0q2ghAqFgpqamuTuampqUqFQiF0SAOwnVp/nWyWNltRsZpL0C3e/MlItACoMLbjlqaGhQV1dXZKkzs5ONTY20voMIHWitDy7e7W7H+3uM5MfgjMAjHCrV69WR0eHJKmjo0PNzc2RKwKA/THDIAAgFWpra5XNFr8QzWazmjVrVuSKAGB/hGcACFQoFLRgwQL64pZIPp9XVVXxspTJZDRnzpzIFQHA/gjPABCooaFB69atU2NjY+xSKlIul1NdXZ3MTHV1dQxVByCVCM8AEKDnSBD33nsvrc8lks/nNX36dFqdAaQW4RkAAjQ0NGj37t2SpN27d9P6XCK5XE5Lly6l1RlAahGeASBAc3OzuieVcnetWrUqckUAgBgIzwAQYOLEif0uAwBGBsIzAATYvHlzv8sAgJGB8AwAAWbNmqVkRlSZmc4///zIFbe/GVUAAA4MSURBVAEAYiA8A0CAfD6/ZwKPUaNGMRoEAIxQhGcACJDL5XThhRfKzHThhRcyGgQAjFDZ2AUAQLnI5/PauHEjrc4AMIIRngEgUPcYxACAkYtuGwAAAEAgwjMAAAAQiPAMAAAABCI8AwAAAIEIzwAAAEAgwjMAAAAQiPAMAAAABCI8AwAAAIEIzwAAAEAgwjMAAAAQiPAMAAAABCI8AwAAAIEIzwAQqFAoaMGCBSoUCrFLAQBEQngGgEANDQ1at26dGhsbY5dSsfiAAiDtCM8AEKBQKKipqUnurqamJsJdifABBUDaEZ4BIEBDQ4O6urokSZ2dnYS7EuADCoByQHgGgACrV69WR0eHJKmjo0PNzc2RK6o8fEABUA4IzwAQoLa2VtlsVpKUzWY1a9asyBVVHj6gACgHhGcACJDP51VVVXzLzGQymjNnTuSKKg8fUACUA8IzAATI5XKqq6uTmamurk65XC52SRWHDygAygHhGQAC5fN5TZ8+nVBXInxAAVAOsrELAIBykcvltHTp0thlVLR8Pq+NGzfyAQVAahGeAQCpwQcUAGlHtw0AAAAgEOEZAAAACER4BgAAAAIRngEAAIBAhGcAAAAgEOEZAAAACER4BgAAAAIRngEAAIBAUcOzmX3GzNzMxsesAwAAAAgRLTyb2dGSzpf0bKwaAAAAgMGI2fL8NUmfleQRawAAAACCRQnPZvZBSW3u/qsYxwcAAADejGypdmxmqyX9US8PfV7S51TsshGyn7mS5krSlClThqw+AAAAYLDMfXh7TZjZdEk/lbQjWTVZ0u8lne7uL/T33JqaGm9paSlxhQAAABjpzGyNu9fsu75kLc99cfd1kiZ0L5vZRkk17v7icNcCAAAADAbjPAMAAACBhr3leV/uPjV2DQAAAEAIWp4BAACAQIRnAAAAIBDhGQAAAAhEeAYAAAACEZ4BAACAQIRnAAAAIBDhGQAAAAhEeAYAAAACEZ4BAACAQIRnAAAAIBDhGQAAAAhEeAYAAAACEZ4BAACAQIRnAAAAIBDhGQCQGoVCQQsWLFChUIhdCgD0ivAMAEiNhoYGrVu3To2NjbFLAYBeEZ4BAKlQKBTU1NQkd1dTUxOtzwBSifAMAEiFhoYGdXV1SZI6OztpfQaQSoRnAEAqrF69Wh0dHZKkjo4ONTc3R64IAPZHeAYApEJtba2y2awkKZvNatasWZErAoD9EZ4BAKmQz+dVVVW8LGUyGc2ZMydyRQCwP8IzACAVcrmc6urqZGaqq6tTLpeLXRIA7CcbuwAAALrl83lt3LiRVmcAqUV4BgCkRi6X09KlS2OXAQB9otsGAAAAEIjwDAAAAAQiPAMAAACBCM8AAABAIMIzAAAAEIjwDAAAAAQiPAMAAACBCM8AAABAIMIzAAAAEIjwDAAAAAQiPAMAAACBCM8AAABAIMIzAAAAEIjwDAAAAAQyd49dQzAz2yrpmdh14E0bL+nF2EUAIxDnHhAH5155+2N3P3LflWUVnlHezKzF3Wti1wGMNJx7QByce5WJbhsAAABAIMIzAAAAEIjwjOG0PHYBwAjFuQfEwblXgejzDAAAAASi5RkAAAAIRHge4czsKjN7wszWm9l3zWyMmT1kZmuTn9+b2V19PHejmY03sxN6bL/WzLaZ2aeSbf4s2X+Xme13x7GZTTGz18zsb5PlMWb2iJn9Knneoh7bmpndaGa/NbMNZragx2PvSY79hJk9MPSvFJA+ZvZaH+v/wcyeNLPHzeyHZnZYsv4KM7u1j+fs916QrO/1vEvWLzWz1uQ4p5Tq7wRKyczqk3/3T/S4dr0juaY8ZmbH9XN+HGNmDyfnwffM7KBk/ZHJ+sfM7Cwza+pxXfuGmWV6OU5/19Lv9Vi/0czWxnq9QHge0cxskqQFkmrc/URJGUmXuftZ7j7T3WdK+k9JP+hvP+7+mx7bnypph6QfJg+vl/Snkh7s4+m3SLq3x/IuSee6+0mSZkqqM7MzkseukHS0pHe4+zsl3ZH8HYdJ+t+SZrv7NEl/FvoaABWqWdKJ7j5D0m8l/X1/G/f1XpA8fIV6Oe8kXSjp+ORnrqT/M8R/A1ByZnaipL+SdLqkkyS938yqJX1I0vfd/WRJO9X3+XGzpK+5e7WkP0j6RLL+PEnr3P1kd39I0p8n17UTJR2pN65Te47T37XU3S/t8didGuC6jNIiPCMraayZZSUdLOn33Q+Y2aGSzpV0V7KcM7NVySfn2yRZL/s7T9J/ufszkuTuG9z9N70d2Mw+JOl3kp7oXudF3a1po5Kf7o75fy3pi+7elWy7JVl/uaQfuPuz+6wHUs3M5iSttr8ys2+b2Qd6tFatNrOJyXaHmNm/mNm6ZPtLeuzja8k5+VMzO1KS3H2Vu3ckm/xC0uQehz3azO43s6fM7Poe6/t6L+jrvPugpMbknP2FpMPM7KihfYWAknunpIfdfUdyzjyg4jXlU5L+2szuS7bb7/wwM1PxGvn9ZJsGSR8ys5mSvizpg0lL8Vh339ZjPwdJcjN7Xy/H6bbXtbRbcsw/l/TdoXoBMHiE5xHM3dskfUXSs5Kel/SKu6/qscmHJP20x0l/vaSfJ627P5Q0pZfdXqaAk9rMDpF0jaRFvTyWSb6S2iKp2d0fTh46TtKlZtZiZvea2fHJ+rdLOjwJBGvMbM5AxwdiM7Npkq7VG9+01Ev6uaQzktauOyR9Ntn8OhXPz+lJa/LPkvXjJLUk5+QDKp6j+/q49v5253RJl0iaIenPzKxmgPeCvs67SZKe67HfTck6oJysl3RW0jh0sKT3qdgy/A0VW5Tf28/5kZP0co8PqpskTXL3tZK+IOl7SWtxuySZ2U9UvK69qmJr88qex9mnrr6upWdJ2uzuTw3VC4DBIzyPYGZ2uIqtR8dIepukcWb20R6b/IX2PnnPlnS7JLn7PSp+RdVzfwdJmi3p3wIOv1DFN4z9+my6e2fy1dRkSacnX6tJ0mhJO5PZmv5Z0reS9VkVv+K6SNIFkq4zs7cH1ADEdK6kf3P3FyXJ3V9S8d/8T8xsnaSrJU1Ltq2V9PXuJ7p797nXJel7ye+3Szqz5wHM7POSOiR9p8fqZncvJBf0H0g6c4D3gr7OO6DsufsGFbterJLUJGmtpM6e2wRcK0OPdYGko1Q8p87ta7sBrqX7XpcRAeF5ZKuV9Dt33+ruu1W8kP53STKz8Sq2UN0ziP1dKOlRd98csO2fSPqymW1U8Wurz5nZvJ4buPvLku6TVJes2qQ3+nn9UMWWs+71P3H37UkQeVDFvmtAuVkm6VZ3ny7pk5LGDPL5e8YeNbMrJL1f0kd87zFJ9x2f1NXPe4H6Pu/aVOwL3W1ysg4oK+7+TXc/1d3PVrFR6Lf7bNLX+VFQsbtSNtluwHPA3XdK+pGKYbwvvV5Lk+P8qd74wIxICM8j27OSzjCzg5N+VOdJ2pA89mFJP05O9G4PqtgXTGZ2oaTD99lf8Cfi5KbEqe4+VdI/SrrJ3W9N7lDuHhlgrKRZkp5MnnaXpO6vts7RG29wP1Kx9SybfO32Jz3+DiCtfqZit4mcJJnZEZLeqjcuvvke2zZL+pvuhaQlTCq+h384+f1yFbt9yMzqVOzyMdvdd+xz3FlmdkRyfn1I0r+r//eCvs67uyXNsaIzVPwq+/nBvwxAXGY2IfnvFBXD6b/us0mv50fyofQ+vXEO5lW8Hu27/0O67wdIAvBFeuO61pu+rqW1kp50902hfxtKIzvwJqhU7v6wmX1f0qMqfrX7mN6YDekySYv3ecoiSd81syck/YeKbyiSJDMbp2LQ/WTPJ5jZxSq2ph0p6R4zW5t8ddWXoyQ1WHEYnypJ/8/df5w8tljSd8zsKkmvSfofyd+xwcyaJD2u4tfYt7n7+vBXAhh+7v6Emd0o6QEz61Tx/Fso6d/M7A8qhutjks1vkPR1M1uv4lfKi1Rs/dquYtema1XsS3lpsv2tKn413Fy81usX7n5l8tgjKt6tP1nS7e7eIkn9vBf0et5JWqli/9BWFUcF+MuheWWAYXdn8iF2t6S/cfeXk/NG0oDXymsk3WFmNyTrv9nL/sdJutvMRqt4XbtPxb7O++nrWpoIuqcIpccMgwAAAEAgum0AAAAAgQjPAAAAQCDCMwAAABCI8AwAAAAEIjwDAAAAgQjPAFCmzGyhmf1t7DoAYCQhPANABekx2xkAoAQIzwBQRszs82b2WzP7uaQTknX3m9k/mlmLpHozO8/MHjOzdWb2rWRyBpnZ+8zsSTNbY2ZLzezHyfrTzew/k+f8h5mdEO8vBIB0IzwDQJkws1NVnGVspoqz+53W4+GD3L1G0tcl/V9Jl7r7dBVnkv1rMxsj6Z8kXejup6o462e3JyWd5e4nS/qCpJtK/bcAQLkiPANA+ThL0g/dfYe7b5N0d4/Hvpf89wRJv3P33ybLDZLOlvQOSU+7+++S9T2n+X2ritOCr5f0NUnTSvUHAEC5IzwDQGXYfgDP/ZKk+9z9REkfkDRmaEoCgMpDeAaA8vGgpA+Z2Vgze4uKQXdfv5E01cyqk+WPSXogWX+smU1N1l/a4zlvldSW/H7FENcMABWF8AwAZcLdH1Wxe8avJN0r6Ze9bLNT0l+q2A1jnaQuSd9w93ZJ/1NSk5mtkfSqpFeSp31Z0v8ys8dU7CMNAOiDuXvsGgAAw8DMDnH318zMVLyx8Cl3/1rsugCgnNDyDAAjx1+Z2VpJT6jYVeOfItcDAGWHlmcAAAAgEC3PAAAAQCDCMwAAABCI8AwAAAAEIjwDAAAAgQjPAAAAQCDCMwAAABDo/wNRHNjS7TYgtAAAAABJRU5ErkJggg==\n",
            "text/plain": [
              "<Figure size 864x576 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "YC6VUiM_WG_K"
      },
      "source": [
        "\n",
        "###Desafio 06: Descobrir se tem algum composto que dependendo da configuração do experimento, ativa ou não ativa algum MOA \n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "xeUAwT9r5Ifa",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "ae94fdf8-acc9-41e1-b8c7-e467e2d614b2"
      },
      "source": [
        "dados_combinados.groupby(['droga','ativo_moa']).count().reset_index().duplicated(subset=['droga']).unique()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array([False])"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 67
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "5IkcxSy4WHIK"
      },
      "source": [
        "###Desafio 07: Descobrir se tem algum composto que dependendo da configuração do experimento, ativa MOAs diferentes\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "2JAL4esZ7C3u"
      },
      "source": [
        ""
      ],
      "execution_count": 74,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "A44j9jwAWHPN"
      },
      "source": [
        "\n",
        "###Desafio 08: Resumo do que você aprendeu com os dados"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "sC6pvo-EWUyB"
      },
      "source": [
        "## em produção"
      ],
      "execution_count": null,
      "outputs": []
    }
  ]
}