Aula_4_Desafios.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Aula 4 - Desafios.ipynb",
      "provenance": [],
      "authorship_tag": "ABX9TyMFIXN6RlUI1pAh5RxRq9Qu",
      "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/mateus558/Imersao_dados_3_alura/blob/main/Aula_4_Desafios.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "NjMh0fauwrMt"
      },
      "source": [
        "# Importação de bibliotecas e configuração"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "SWbI5t-mwDTm"
      },
      "source": [
        "import pandas as pd\n",
        "import seaborn as sns\n",
        "import matplotlib.pyplot as plt\n",
        "import numpy as np\n",
        "\n",
        "sns.set(font_scale=1.2)\n",
        "url_dados = \"https://github.com/alura-cursos/imersaodados3/blob/main/dados/dados_experimentos.zip?raw=true\""
      ],
      "execution_count": 1,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "9-P7NxPtwxee"
      },
      "source": [
        "# Carregamento e preparação dos dados"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 0
        },
        "id": "8zVXPJzhwQWa",
        "outputId": "87efe957-a7cc-4271-e20d-c5cd9e36ce40"
      },
      "source": [
        "dados = pd.read_csv(url_dados, compression='zip')\n",
        "mapa = {'droga': 'composto'}\n",
        "dados.rename(columns=mapa, inplace=True)\n",
        "dados.rename(lambda x: x.replace('-',''), axis=1, inplace=True)\n",
        "dados.head()"
      ],
      "execution_count": 2,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>id</th>\n",
              "      <th>tratamento</th>\n",
              "      <th>tempo</th>\n",
              "      <th>dose</th>\n",
              "      <th>composto</th>\n",
              "      <th>g0</th>\n",
              "      <th>g1</th>\n",
              "      <th>g2</th>\n",
              "      <th>g3</th>\n",
              "      <th>g4</th>\n",
              "      <th>g5</th>\n",
              "      <th>g6</th>\n",
              "      <th>g7</th>\n",
              "      <th>g8</th>\n",
              "      <th>g9</th>\n",
              "      <th>g10</th>\n",
              "      <th>g11</th>\n",
              "      <th>g12</th>\n",
              "      <th>g13</th>\n",
              "      <th>g14</th>\n",
              "      <th>g15</th>\n",
              "      <th>g16</th>\n",
              "      <th>g17</th>\n",
              "      <th>g18</th>\n",
              "      <th>g19</th>\n",
              "      <th>g20</th>\n",
              "      <th>g21</th>\n",
              "      <th>g22</th>\n",
              "      <th>g23</th>\n",
              "      <th>g24</th>\n",
              "      <th>g25</th>\n",
              "      <th>g26</th>\n",
              "      <th>g27</th>\n",
              "      <th>g28</th>\n",
              "      <th>g29</th>\n",
              "      <th>g30</th>\n",
              "      <th>g31</th>\n",
              "      <th>g32</th>\n",
              "      <th>g33</th>\n",
              "      <th>g34</th>\n",
              "      <th>...</th>\n",
              "      <th>c60</th>\n",
              "      <th>c61</th>\n",
              "      <th>c62</th>\n",
              "      <th>c63</th>\n",
              "      <th>c64</th>\n",
              "      <th>c65</th>\n",
              "      <th>c66</th>\n",
              "      <th>c67</th>\n",
              "      <th>c68</th>\n",
              "      <th>c69</th>\n",
              "      <th>c70</th>\n",
              "      <th>c71</th>\n",
              "      <th>c72</th>\n",
              "      <th>c73</th>\n",
              "      <th>c74</th>\n",
              "      <th>c75</th>\n",
              "      <th>c76</th>\n",
              "      <th>c77</th>\n",
              "      <th>c78</th>\n",
              "      <th>c79</th>\n",
              "      <th>c80</th>\n",
              "      <th>c81</th>\n",
              "      <th>c82</th>\n",
              "      <th>c83</th>\n",
              "      <th>c84</th>\n",
              "      <th>c85</th>\n",
              "      <th>c86</th>\n",
              "      <th>c87</th>\n",
              "      <th>c88</th>\n",
              "      <th>c89</th>\n",
              "      <th>c90</th>\n",
              "      <th>c91</th>\n",
              "      <th>c92</th>\n",
              "      <th>c93</th>\n",
              "      <th>c94</th>\n",
              "      <th>c95</th>\n",
              "      <th>c96</th>\n",
              "      <th>c97</th>\n",
              "      <th>c98</th>\n",
              "      <th>c99</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  ...     c96     c97     c98     c99\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": 2
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 0
        },
        "id": "mbdNqwyXwSJD",
        "outputId": "321c223f-4df2-4bf4-e232-9e37236dc87d"
      },
      "source": [
        "dados_resultados = pd.read_csv('https://raw.githubusercontent.com/alura-cursos/imersao-dados-desafio-final/main/Dados/dados_resultados.csv')\n",
        "dados_resultados['n_moa'] = dados_resultados.drop('id', axis=1).sum(axis=1)\n",
        "dados_resultados['ativo_moa'] = (dados_resultados['n_moa'] != 0)\n",
        "\n",
        "dados_resultados.head()"
      ],
      "execution_count": 3,
      "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": 3
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 0
        },
        "id": "DZHZxBQ9wfN1",
        "outputId": "6fb92918-fce7-426f-93ac-fe008233d7c8"
      },
      "source": [
        "dados_combinados = pd.merge(dados, dados_resultados[['id', 'n_moa', 'ativo_moa']], on='id')\n",
        "dados_combinados.head()"
      ],
      "execution_count": 4,
      "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>composto</th>\n",
              "      <th>g0</th>\n",
              "      <th>g1</th>\n",
              "      <th>g2</th>\n",
              "      <th>g3</th>\n",
              "      <th>g4</th>\n",
              "      <th>g5</th>\n",
              "      <th>g6</th>\n",
              "      <th>g7</th>\n",
              "      <th>g8</th>\n",
              "      <th>g9</th>\n",
              "      <th>g10</th>\n",
              "      <th>g11</th>\n",
              "      <th>g12</th>\n",
              "      <th>g13</th>\n",
              "      <th>g14</th>\n",
              "      <th>g15</th>\n",
              "      <th>g16</th>\n",
              "      <th>g17</th>\n",
              "      <th>g18</th>\n",
              "      <th>g19</th>\n",
              "      <th>g20</th>\n",
              "      <th>g21</th>\n",
              "      <th>g22</th>\n",
              "      <th>g23</th>\n",
              "      <th>g24</th>\n",
              "      <th>g25</th>\n",
              "      <th>g26</th>\n",
              "      <th>g27</th>\n",
              "      <th>g28</th>\n",
              "      <th>g29</th>\n",
              "      <th>g30</th>\n",
              "      <th>g31</th>\n",
              "      <th>g32</th>\n",
              "      <th>g33</th>\n",
              "      <th>g34</th>\n",
              "      <th>...</th>\n",
              "      <th>c62</th>\n",
              "      <th>c63</th>\n",
              "      <th>c64</th>\n",
              "      <th>c65</th>\n",
              "      <th>c66</th>\n",
              "      <th>c67</th>\n",
              "      <th>c68</th>\n",
              "      <th>c69</th>\n",
              "      <th>c70</th>\n",
              "      <th>c71</th>\n",
              "      <th>c72</th>\n",
              "      <th>c73</th>\n",
              "      <th>c74</th>\n",
              "      <th>c75</th>\n",
              "      <th>c76</th>\n",
              "      <th>c77</th>\n",
              "      <th>c78</th>\n",
              "      <th>c79</th>\n",
              "      <th>c80</th>\n",
              "      <th>c81</th>\n",
              "      <th>c82</th>\n",
              "      <th>c83</th>\n",
              "      <th>c84</th>\n",
              "      <th>c85</th>\n",
              "      <th>c86</th>\n",
              "      <th>c87</th>\n",
              "      <th>c88</th>\n",
              "      <th>c89</th>\n",
              "      <th>c90</th>\n",
              "      <th>c91</th>\n",
              "      <th>c92</th>\n",
              "      <th>c93</th>\n",
              "      <th>c94</th>\n",
              "      <th>c95</th>\n",
              "      <th>c96</th>\n",
              "      <th>c97</th>\n",
              "      <th>c98</th>\n",
              "      <th>c99</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  ...     c98     c99  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": 4
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "0Tu-pPyOw1t2"
      },
      "source": [
        "# Desafio 01: Encontrar o top 10, das ações do MOA (inibidor, agonista...)"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "BdHOI-2lwnkj",
        "outputId": "f36b5e3d-46e5-4e7f-dc93-20a68e04191e"
      },
      "source": [
        "unique_moa_types = np.unique([col.split('_')[-1] for col in dados_resultados.drop('id',axis=1).columns])\n",
        "print(unique_moa_types)\n",
        "print(f\"Length: {len(unique_moa_types)}\")"
      ],
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "['activator' 'agent' 'agonist' 'analgesic' 'antagonist'\n",
            " 'anti-inflammatory' 'antiarrhythmic' 'antibiotic' 'anticonvulsant'\n",
            " 'antifolate' 'antifungal' 'antihistamine' 'antimalarial' 'antioxidant'\n",
            " 'antiprotozoal' 'antiviral' 'b' 'blocker' 'diuretic' 'donor'\n",
            " 'immunosuppressant' 'inhibitor' 'laxative' 'local' 'medium' 'moa'\n",
            " 'scavenger' 'secretagogue' 'sensitizer' 'steroid' 'stimulant']\n",
            "Length: 31\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 0
        },
        "id": "K7YfoNEF2Uv-",
        "outputId": "0671a2bf-04de-4642-968a-574a1908d879"
      },
      "source": [
        "frequencias = dados_resultados.drop(['id','n_moa', 'ativo_moa'], axis=1).sum()\n",
        "contadores = dict.fromkeys(unique_moa_types , [0])\n",
        "for name in frequencias.index:\n",
        "  contadores[name.split('_')[-1]] += frequencias[name]\n",
        "\n",
        "contagem_final = pd.DataFrame.from_dict(contadores).T.rename({0:\"count\"},axis=1).sort_values(by='count', ascending=False)\n",
        "contagem_final.head(10)"
      ],
      "execution_count": 6,
      "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>count</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>inhibitor</th>\n",
              "      <td>9693</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>antagonist</th>\n",
              "      <td>3449</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>agonist</th>\n",
              "      <td>2330</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>blocker</th>\n",
              "      <td>323</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>agent</th>\n",
              "      <td>150</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>activator</th>\n",
              "      <td>115</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>local</th>\n",
              "      <td>80</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>antioxidant</th>\n",
              "      <td>73</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>anti-inflammatory</th>\n",
              "      <td>73</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>immunosuppressant</th>\n",
              "      <td>73</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                   count\n",
              "inhibitor           9693\n",
              "antagonist          3449\n",
              "agonist             2330\n",
              "blocker              323\n",
              "agent                150\n",
              "activator            115\n",
              "local                 80\n",
              "antioxidant           73\n",
              "anti-inflammatory     73\n",
              "immunosuppressant     73"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "5HxSPOgExAkm"
      },
      "source": [
        "# Desafio 02: Criar a coluna eh_controle para quando na linha tratamento == com_controle"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 0
        },
        "id": "QJabOo2KxEI8",
        "outputId": "525d968b-da38-43d2-9bb6-5e51e539e27d"
      },
      "source": [
        "dados_combinados['eh_controle'] = dados_combinados['tratamento'] == 'com_controle'\n",
        "dados_combinados.head()"
      ],
      "execution_count": 7,
      "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>composto</th>\n",
              "      <th>g0</th>\n",
              "      <th>g1</th>\n",
              "      <th>g2</th>\n",
              "      <th>g3</th>\n",
              "      <th>g4</th>\n",
              "      <th>g5</th>\n",
              "      <th>g6</th>\n",
              "      <th>g7</th>\n",
              "      <th>g8</th>\n",
              "      <th>g9</th>\n",
              "      <th>g10</th>\n",
              "      <th>g11</th>\n",
              "      <th>g12</th>\n",
              "      <th>g13</th>\n",
              "      <th>g14</th>\n",
              "      <th>g15</th>\n",
              "      <th>g16</th>\n",
              "      <th>g17</th>\n",
              "      <th>g18</th>\n",
              "      <th>g19</th>\n",
              "      <th>g20</th>\n",
              "      <th>g21</th>\n",
              "      <th>g22</th>\n",
              "      <th>g23</th>\n",
              "      <th>g24</th>\n",
              "      <th>g25</th>\n",
              "      <th>g26</th>\n",
              "      <th>g27</th>\n",
              "      <th>g28</th>\n",
              "      <th>g29</th>\n",
              "      <th>g30</th>\n",
              "      <th>g31</th>\n",
              "      <th>g32</th>\n",
              "      <th>g33</th>\n",
              "      <th>g34</th>\n",
              "      <th>...</th>\n",
              "      <th>c63</th>\n",
              "      <th>c64</th>\n",
              "      <th>c65</th>\n",
              "      <th>c66</th>\n",
              "      <th>c67</th>\n",
              "      <th>c68</th>\n",
              "      <th>c69</th>\n",
              "      <th>c70</th>\n",
              "      <th>c71</th>\n",
              "      <th>c72</th>\n",
              "      <th>c73</th>\n",
              "      <th>c74</th>\n",
              "      <th>c75</th>\n",
              "      <th>c76</th>\n",
              "      <th>c77</th>\n",
              "      <th>c78</th>\n",
              "      <th>c79</th>\n",
              "      <th>c80</th>\n",
              "      <th>c81</th>\n",
              "      <th>c82</th>\n",
              "      <th>c83</th>\n",
              "      <th>c84</th>\n",
              "      <th>c85</th>\n",
              "      <th>c86</th>\n",
              "      <th>c87</th>\n",
              "      <th>c88</th>\n",
              "      <th>c89</th>\n",
              "      <th>c90</th>\n",
              "      <th>c91</th>\n",
              "      <th>c92</th>\n",
              "      <th>c93</th>\n",
              "      <th>c94</th>\n",
              "      <th>c95</th>\n",
              "      <th>c96</th>\n",
              "      <th>c97</th>\n",
              "      <th>c98</th>\n",
              "      <th>c99</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  ...     c99  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": 7
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "ORAHmONnxFZF"
      },
      "source": [
        "# Desafio 03: Criar três colunas para indicar o tempo 24, 48, 72"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 0
        },
        "id": "YEx3C7G7xHvC",
        "outputId": "5507c81e-4f04-4353-e45c-e339e43dcfac"
      },
      "source": [
        "new_columns = pd.get_dummies(dados_combinados['tempo'])\n",
        "new_columns['id'] = dados_combinados['id']\n",
        "dados_combinados = pd.merge(dados_combinados, new_columns, on='id').rename(columns={24:\"tempo_24\", 48:\"tempo_48\", 72:\"tempo_72\"})\n",
        "dados_combinados.head()"
      ],
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>id</th>\n",
              "      <th>tratamento</th>\n",
              "      <th>tempo</th>\n",
              "      <th>dose</th>\n",
              "      <th>composto</th>\n",
              "      <th>g0</th>\n",
              "      <th>g1</th>\n",
              "      <th>g2</th>\n",
              "      <th>g3</th>\n",
              "      <th>g4</th>\n",
              "      <th>g5</th>\n",
              "      <th>g6</th>\n",
              "      <th>g7</th>\n",
              "      <th>g8</th>\n",
              "      <th>g9</th>\n",
              "      <th>g10</th>\n",
              "      <th>g11</th>\n",
              "      <th>g12</th>\n",
              "      <th>g13</th>\n",
              "      <th>g14</th>\n",
              "      <th>g15</th>\n",
              "      <th>g16</th>\n",
              "      <th>g17</th>\n",
              "      <th>g18</th>\n",
              "      <th>g19</th>\n",
              "      <th>g20</th>\n",
              "      <th>g21</th>\n",
              "      <th>g22</th>\n",
              "      <th>g23</th>\n",
              "      <th>g24</th>\n",
              "      <th>g25</th>\n",
              "      <th>g26</th>\n",
              "      <th>g27</th>\n",
              "      <th>g28</th>\n",
              "      <th>g29</th>\n",
              "      <th>g30</th>\n",
              "      <th>g31</th>\n",
              "      <th>g32</th>\n",
              "      <th>g33</th>\n",
              "      <th>g34</th>\n",
              "      <th>...</th>\n",
              "      <th>c66</th>\n",
              "      <th>c67</th>\n",
              "      <th>c68</th>\n",
              "      <th>c69</th>\n",
              "      <th>c70</th>\n",
              "      <th>c71</th>\n",
              "      <th>c72</th>\n",
              "      <th>c73</th>\n",
              "      <th>c74</th>\n",
              "      <th>c75</th>\n",
              "      <th>c76</th>\n",
              "      <th>c77</th>\n",
              "      <th>c78</th>\n",
              "      <th>c79</th>\n",
              "      <th>c80</th>\n",
              "      <th>c81</th>\n",
              "      <th>c82</th>\n",
              "      <th>c83</th>\n",
              "      <th>c84</th>\n",
              "      <th>c85</th>\n",
              "      <th>c86</th>\n",
              "      <th>c87</th>\n",
              "      <th>c88</th>\n",
              "      <th>c89</th>\n",
              "      <th>c90</th>\n",
              "      <th>c91</th>\n",
              "      <th>c92</th>\n",
              "      <th>c93</th>\n",
              "      <th>c94</th>\n",
              "      <th>c95</th>\n",
              "      <th>c96</th>\n",
              "      <th>c97</th>\n",
              "      <th>c98</th>\n",
              "      <th>c99</th>\n",
              "      <th>n_moa</th>\n",
              "      <th>ativo_moa</th>\n",
              "      <th>eh_controle</th>\n",
              "      <th>tempo_24</th>\n",
              "      <th>tempo_48</th>\n",
              "      <th>tempo_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>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</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>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</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>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</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>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</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>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 883 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "             id tratamento  tempo  ... tempo_24 tempo_48  tempo_72\n",
              "0  id_000644bb2  com_droga     24  ...        1        0         0\n",
              "1  id_000779bfc  com_droga     72  ...        0        0         1\n",
              "2  id_000a6266a  com_droga     48  ...        0        1         0\n",
              "3  id_0015fd391  com_droga     48  ...        0        1         0\n",
              "4  id_001626bd3  com_droga     72  ...        0        0         1\n",
              "\n",
              "[5 rows x 883 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "BY2R4GSxxIaK"
      },
      "source": [
        "#Desafio 04: Estudar sobre combinações de DF https://pandas.pydata.org/pandas-docs/stable/user_guide/merging.html"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "O2mIF8UPxNwt"
      },
      "source": [
        "#Desafio 05: Fazer análise mais detalhada considerando tempo e dose, para comparar as distribuições (Escolher uma droga e comparar com controle)"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 0
        },
        "id": "ArnZQl9FxKxB",
        "outputId": "ad3c7327-5f02-4013-9caa-a0ada48a433f"
      },
      "source": [
        "fig, axs = plt.subplots(1,2,figsize=(20,8), sharey=True)\n",
        "composto_principal = dados_combinados['composto'].value_counts().index[1:2]\n",
        "sns.boxplot(data=dados_combinados.query('composto in @composto_principal'), x='tempo', y='g0', hue='dose',ax=axs[0])\n",
        "axs[0].set_title(f\"{composto_principal[0]}\")\n",
        "composto_principal = dados_combinados.query('tratamento == \"com_controle\"')['composto'].value_counts().index[0]\n",
        "sns.boxplot(data=dados_combinados.query('composto in @composto_principal'), x='tempo', y='g0', hue='dose',ax=axs[1])\n",
        "axs[1].set_title(f\"{composto_principal} (controle)\")\n",
        "axs[1].set_ylabel(\"\")\n",
        "plt.show()"
      ],
      "execution_count": 9,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAABJkAAAH6CAYAAACkkp14AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nOzde3xcdZ3/8dfkQgukJL0AxbUUBfe7IndBCYktclFXSaWIl62Wi7gqcpEVpRWBVdC1dVF/oty8FQWRXZBqowvKFtuSUrkKiC5fWpG2IMXeJqVCaTPJ748zKWla2qST5JxMXs/HI492Zs6c85mTyeTkfT7f78l1dHQgSZIkSZIklaIi7QIkSZIkSZI0+BkySZIkSZIkqWSGTJIkSZIkSSqZIZMkSZIkSZJKZsgkSZIkSZKkkhkySZIkSZIkqWRVaRcgSQAhhGOB3wLjYozPpFyOJEmSJKmXDJkk9VgIoQK4BDgN+AdgJfBz4PMxxr8Xl5kHTNzG01+MMe7ei219Efj3V3n4LTHGB4rL/T+gHjgY2CXGuN3PtRDCDcDpwKUxxi93uf9K4CTgtUAB+CPwlRjjr7o9fzzwH8A7gRpgKfDZGGNzl2XGAFcA7wVGA38F/iPG+L2evHZJklTe+urkWghhP+AvwNtijC19U13/CCEcCTQDB3QeNw5GxWPJ18YYT+jFc64H1scYL+y3wqSMMGSS1BsXAp8FzgQeAgIwCxgGfKK4zCnALl2ekwMeAH7dy21dCVzX7b5vA4cBD3a5rxK4GRgHXLC9FYYQziAJo/66jYf/CNwBPA1UA2cAvwghvDXG+FDx+f8A/I7koPAkYAUwHljXZRs1wALgWeBfSEKofYp1SpIk9UgI4WDgIuBtwFjgOeAXwBdjjPleruv1wNeACcDuwJPAzBjjLdvY5leKy+0CLAE+FmO8v8syZwCfB/YjCbiuiDH+pAdlfBP42kAHTCGE75MEW8cO5Ha7uRx4MoRwdYzxqRTrkPqdIZOk3mgA7oox/qx4++kQwk+B4zoXiDGu6fqEEMKJJF1P13W7/zxgGjAKuAfY4uAkxrgeWN9l+Vrg3SQHVh1dljuv+PgZ2ys8hHAgMIPkQO2u7o/HGGd1u2t6COETQCNJoAZJB9PTMcYpXZZ7utvzPgfsBpwUY3z5VZaRJEnakSNIjoU+BjwFHABcTXKS7597ua5mkg70fwbWAh8Gbg4hLIsx3gsQQjiU5Jjsh8CXgDXAG4rLU1zmZOAHJCcd7yA56fbjEMKaGOMdr7bxEMJRwFHApF7WPWBCCLvEGDf2x7pjjM+GEOYCnyLZd1LZMmSS1BstwGdDCIfEGB8rnhV7N/Cz7Tznk8DvO4e3AYQQ3ktyNusi4Jckwc9/7mDbp5F8Zt3Q26JDCLsB/w18Lsa4OISwo+WrSLqQakgOtjqHCp4M/KAYrB0PPE/SRfWfMca24tPfR7KfvhlCmAy0khzY/XuM8cXe1i5JktIRQjgHOAfYn+T3+T0xxvcVH5sCfBr4J2ATcB/wbzHGJ7s8fy9gJsmxUi1Jd/PMGOMPu2zm8BDC7cAhJF1D58cY7waIMf4I+FGXZZ8KIUwDbgsh7BFjXNflsf1CCF8CjiHpeLq4s0sphFAHHAhM6uzOBq4IIVxAEvzcW7zvKuBXMcauneF/6bZbLgL+K8b4zeLtJ0IIbyU5cfiqIRNJqLUgxri2650hhDeTdE4dQ3JRqj8B58UY7ys+fnpx3QcAfyM5Dvxi53FXcZqGJST79hyS7qtfAp+KMa4vTr9wVnHZzpOUZ8YYbyje/jRwNPAe4E7ggzva5raEED4ETCd5P6wAbieZmqFr19ZskhOWhkwqa15dTlJvfB34DvBwCGET8GeSEObSbS0cQtiH5IzV9d0e+hzJAco3YoxPxhh/ANy4g21/Arg9xrhyJ+q+Gng4xrjdbYQQTgohrAdeBr4FnBxjfLj48J7AHiRnoP5KMifTjOJr+VKX1ewPnFpctonkYOyDgPMxSZI0SBQDm5nANSRD7d8FPNxlkWHAl0m6jU4kmc/xVyGEXYrP3xWYDxxKErAcCJwHdD/h9A2SoVSHkwRVzcXjp1dTB2wEugceXyPpQDqM5ATYT0IIhwMUh9Y9Dnw4hFAbQqgohiK7AXOL9Y4hGSL3eAjhf0IIK0MID4UQPt5ln+xCEkrd2W3bdwJHhxC2NzXAROD+rneEEN5EMsXAWpKu+MNJTkJWFB9/T/E13QgcRDJtwzlsPWfnqSSd8ccCHyLprppWfOzK4v5YRDJ9wT7Af3V57r+ThGxHAJf0YptdX8cZwLUkx8kHkpwYPYGtp324DxgbQnjjq61LKgd2MknqjVNJQpYzgUdI2rW/SXKQ9YVtLP9RYAPJL/euDgR+2u2+FpJf5FsJITQAbwLO7W3BIYQPkwzzO6IHi/+W5OBsJPB+4MYQwgnFoKkzlP9Dl0kbf188ELyUV15/BbCa5CzZpmINuwC3hhDO6z6cUJIkZUsIYXeSk0SXxhi/0+WhzSFT92H2xaBhNUkIsxCYAryOZC6gzom9tzUXz4wY4y+L6/gESTjxKbZxAi+EMJbkxNZ3ttEd/YMu8yJdEkI4DvgMMLV43wkkXd15koDqReB9McbHi4/vX/z3C8VtXEzSXXRVCKGjePGSMSR/P67otu0VJKHbKJIhedvyOpL5KruaTtKF9OEYY3vxvsXdHv9ZjPGrxdtPFvfBjBDCFV2Gti2NMf5b8f9PhBD+q/h6Ly12M70EbIwxdq8b4Oddv8chhB/2cJtdfZHkIjidJzOfCiGcC8wPIZzfpXur833weuD/trEeqSwYMknqja8D3+ryS/QPxTN1Pyz+4t3QuWBxeNm/Aj+JMb5Q4nY/CTwRY5y3E889kaTdOd9lmFwl8KUQwiUxxuGddxZbmpcUbz5QnJvgIpKzYqtI2uH/2G39fwT2CCGMLB5EPEcyb9OmbstAMkm4IZMkSdn2JmA48JtXWyCEcBhJd8thJOFLrvjQeJKQ6c3An3pw5bhFnf+JMbaFEO4vbr/79vYq1vMYyaTbr7qeooUkQ/sJIeRIuroLJN0+rSQXarklhPD24hC6zpNpv4oxziz+/5HinJbnUXpH9q4kJx67ejNwZ5eAqbs3sWXXESTdYcNJQrHOoObRbst0dpz3xP3dbvd0mwCEEPYk+Z5/o3il4k6d74cDSC6AA6+8/l17WJs0KDlcTlJv7A50PxAokPwizXW7/10kv3S7D5WDZLz9Md3ua9jWBkMIo0g6qL7b22KLvkAyz8FhXb7+SnKw9eYdPLeC5KCCYmh0H8lY+y1KBFq7nKW6BzigOK9T12XACcAlSRr0inM9/gboIOnufgtJB1MHW15ht6+291qSoGMpcEq3E1k98XaSOSOnxBjnxxgfiTFeRhJ+dHYAPVf8d1sn08YX/7+KpAtqbLdl9iaZamB7J9JWknQ69Yfu3UUd9Pzv3FKvdNe5nU+z5bHmoSSTpv+hy7Kdr39npn6QBg07mST1xs9JJv5eAvyeJDz5MnBHjPGlbst+Anggxvj7bazn6yTDx+4H/ofkCm5Tt7EcwOnFf3+0rQdDCAeQTNC9b/H2YcWHlsQY18cYn6Vbe3ZxPqm/xRj/WLy9N0lr+v+QtHzXkUz8fTzJQVmnrwK/LM7TcBPwRpIQ61tdlrkS+ABwTQjhGyRj/68Eftx9sktJkpRJfyLpOnkHSedQd28kmavxCzHG/wMIIRzDlifcHgI+GkJ47Q66mY4ubq/zwiNvocs8lSGE/YH/JRmq96HtBExHkxzHdDqmc70kJwkhOTHYVeeJQkgCrOVs+2Ta0wAxxo0hhAdIuoR+3GWZdwG/izF2X39XD7N1h9ZDwPEhhIpX6Wb6I8k8UV2HLE4EXiKZF7SnNpJ0sfdEr7YZY3w+hLAcCMUhhdtzMMk+39axsVQ2DJkk9cb5JGepvg68huSKG78ELum6UAjhH0iu0vGJba0kxjg7hHAhyVC0GSQt3dPY9pXjPg7ctp25jL5P8su/U+cv7rcD83b0goo2kpxx+leSlvc1JGee3h1j3Dy5ZYzxf0II/wJcVqx3GUmA9PUuyzwaQnh38XU9QhJa3cp2JoyUJEnZUZzH5+vAF4vz+dxFMsTp3cW5epaSdO6cV1xuP5Lf+x1dVvNTkuOcOSGEi0gCitcDY2KMXYdjTQ8hrCC5ittnSMKrawCKQ9X+lyToOh8Y3WXo/8puoc5ZIYQngAeBjwD1JMPcIJnYeiVwQwjhUmAdyXC5E0hOjBFj7AghfBX4dvGqeneSdJl/nGTi605fI7m63f3FZd5TXFfTDnbr/7D1VdW+RtIl/pPiflxLMofmMzHGRSQn95pDCNNJrtZ2GMn8R19/lbmRXs1fgPcXJxp/Hnghxvjyqyy7M9v8AsnVh9cCvyCZXuGNwD/HGLseCx8LtHS7KqBUdnIdHR07XkqSJEmShojiPEbnk3Q6v44kAFkQY3x/8fFTSQKJcSTz9FxAcqW2j8UYbyguM5YkSHk3Sdf10yQTfd8QQjiW5IIj7yU5EXUQSRD16RjjXcXnf5FXP0n1uhjj0yGE/UhClNOAs0g6mp4j6bLafOGVYqf3V0g6pXYlmYPyW9uYwPy84mt5TbGe/xdj/H63Zc4gmRi8c9tXxBhv2sH+HEHSWf6uGOO9Xe5/C/AfJKFYO0kn0fkxxvuLj59OMgH4/hSDMuDfY4xtxcfnkXSvf6zLOi8h+T7sV7w9iqQDvYHk6r9nFr8HHcDU7rX3YJs3AK+NMZ7Q5Tknk5yAPJRkSOFTJFdFvrz4eK5438Uxxu4Xv5HKiiGTJEmSJKlfFbuo3hxjPDntWgZaCOEDJFcMPGwHwwqlQc+JvyVJkiRJ/e0/gYdCCLvvcMnyM4ykg8qASWXPTiZJkiRJkiSVrFwn/h5GchnR59j6KgqSJKk8VJJcwfEBkkl4lT6PwSRJKm/bPf4q15DpKOCetIuQJEkD4m1AS9pFCPAYTJKkoWKbx1/lGjI9B7B27d9pb3c4oCRJ5aiiIsfIkbtD8fe+MsFjMEmSytiOjr/KNWQqALS3d3iAI0lS+XNYVnZ4DCZJ0tCwzeMvry4nSZIkSZKkkhkySZIkSZIkqWSGTJIkSZIkSSqZIZMkSZIkSZJKVq4Tf0uSJEmSJPVaR0cHa9euZOPGDcDQu5BFZWUVNTV17Lrr7r1+riGTJEmSJElS0fr1reRyOfbe+7XkckNrAFhHRwebNm0kn18J0OugaWjtLUmSJEmSpO146aX1jBhRN+QCJoBcLscuuwyjrm5P1q/P9/r5Q2+PSZIkSZIkvYr29gKVlUN74Fd19S4UCm29fp4hkyRJkiRJUhe5XC7tElK1s6/fkEmSJEmSJEklM2SSJEmSJEnqZz/4wfV88IMnp11GvzJkkiRJkiRJUskMmSRJkiRJklSyoT1duiT1sbvvvoubbprF6aefxcSJx6ddjiRJkqQUvPzyy3z729/grrvuJJer4IQT3kFNzYjNj3d0dPDTn97E7Nm3sXLl8+y1196ceuoH+cAHpmxe5p575vHDH36XZcuWUl1dzbhx+/K5z13MP/7jPwHwzDPLufbaq3jooQeAHG9844Gce+6/sf/+Bwz0y90slZAphPAh4BzgUGBEjDHX7fHDgauBw4BVwJUxxqsGvFBJ6qWbbroBgB/96IeGTJIkSdIQdf3132HevLu55JIvse+++9Hc/HNuv/1WRo4cCcDtt9/K979/HZ/+9IUcccSRPPTQ/Vx11TfYbbfdOOmkk1m9ehWXXjqdf/3Xs3n7209g48aNPPlkpLIyiXHWrFnNpz71MSZMOJarr/4+1dVV/Oxn/815532Cn/zkts3bGWhpDZdbC1wDXND9gRDCHsCdwK+BUcAHgC+GEE4d0AolqZfuvvsuoKN4q4P58+emWY4kSZKkFLz00kv8/Oc/4+Mf/xRve9uxjB+/H+eeewHjxu27eZmf/ORHnHrqB3jve09h3Lh9OfnkUzn55Pfxox/NAmD16lW0tbVx3HEn8prX/AP77fc63vGOd23uUpo9+zbGjt2Hz3728+y//wHsu+9+XHDB56ipqeGuu+5I5XVDSp1MMcZfA4QQjt3Gw6cABeCKGGM78LsQwveATwG3DViR0hCxcOECWlrm7/TzW1vzANTW1pVUR2PjRBoaJpS0jrR1djF1sptJfa3Un1fom5/Zcvh5lSRJ6i/PPvsMGzdu5KCDDtni/kMOOYx7772Hv/99PX/72/MceugRWzx+2GFv5tZbb2HDhg3sv/8beMtb6jnttA9y5JFv5fDD38zEiW9n773HAvDEE38ixv/jxBPftsU6Xn75ZZYvX96/L3A7sjgn06HA74sBU6cHgX/t7YpGj67ps6KkcrXHHrtSXV25089ft64VgDFjRpdcx557jtjxgpnWsdXtwf+alCWl/rxC3/zMlsfPq/qTx2CSpMHsb3+roKpq5wd+VVYmMwJVVW25nooKyOXYfF9lZW6Lx195Xo5hw6r51re+w5/+9EceeOA+Fiy4m+uv/w5f+cpMGhsn0NHRwVFHvYULL5y21fZrakaUVP8r9Vb0+pgviyHTHkC+23354v29snr1etrbu//RJ6mrgw8+ioMPPmqnnz9z5hUAfOYzF5dcy8qVL5S8jnTl2DJoypXBa1KWlPrzCn33M5uF93ZFRc4wI6M8BpMkDWbt7e20tbXveMFXMXbsP1BdXc0jjzzCvvu+bvP9jz76KB0dMGzYbuy11948/PBDHH104+bHH3roQfbZ5zVUVQ3bvP0QDiSEA/nIR87kM585j+bmX3D00Y2E8EbuuOOXjBq1J8OGDduqhlLq79Te3r7VMd+Ojr/SmpNpe9YBtd3uqyveL0mZ9ZGPnLHF7dNP/2g6hUiSJElKza677sp73/s+vve9a2lpmc+yZU9zzTXfYtmypZuX+chHzuC22/6bOXNms3z5Mn7+85/x85//jNNOOxOAP/zhUW644fv88Y+Ps2LFCh588H7+/OfF7Lff6wF43/s+QKFQ4POfv5BHH/09zz33Vx599BGuv/5q/vCHR1N53ZDNTqZHgQ+EECq6DJl7M/BIijVJ0g4dd9yJxXmZOoCc8zFJkiRJQ9TZZ5/Lxo0vc8UVlwFw3HHv4JRT3s9vf/u/AEyefCobNrzEjTfO4utfn8Fee43lk588l5NOOhmA3Xev4fHHH+P222/lhRfWMWrUaN7xjn/mjDM+BsCoUaO5/vpZXH/91XzhC5/j73//O6NGjebQQw9n9Ogx6bxoINfRMfCtzCGESqAamEByFbldiw9tBGqAxcB3gK+RzNF0B/DJGOOtPdzEfsBfbNWW+l/n0Jtp0y5NuZJsuPvuu7jpplmcfvpZhkzKpHL6me3Srv064Ol0q1HRfngMJkka5FasWMrYsePTLiN129oPOzr+SquTaSowq8vtl4r/vj3GOC+E8C7gGuBiYBXwpV4ETJKUmuOOO5Hjjjsx7TIkSZIkacClEjLFGG8AbtjO478H6geqHkmSJEmSJJUmixN/S5IkSZIkaZAxZJIkSZIkSVLJDJkkSZIkSZJUMkMmSZIkSZIklcyQSZIkSZIkSSUzZJIkSZIkSVLJDJkkSZIkSZJUsqq0C5AkSZIkScqyGV+bwdp8a79vZ2RdLdMvmt7v2+kvhkySVLRw4QJaWuaXtI7W1jwAtbV1O72OxsaJNDRMKKkOSZIkSX1nbb6VDSPr+387axf1avlzz/04jz/+GNXVu1BRkaOmZgQHHngQkyefyhFHHAnAgw/ez403zmLx4idZt66VW2+dwz77vKY/yjdkkqS+1NqanN0oJWTSlkoN//oi+APDP0mSJGXT1KlnctZZnwBg1apV/PrXv+LCC8/j3HMv4H3v+yDDh+/Ku971Hj74wQ9z0UUX9GsthkySVNTQMKHkEGHmzCsAmDbt0r4oSX3A4E+SJElDxZgxY/jwh0/n5Zdf5tprv8073/keDjroYA466GCee+6v/b59QyZJUqaVGv4Z/EmSJGmoOeGEd/LDH36Xxx9/jKOPPmbAtuvV5SRJkiRJksrI3nvvDcC6desGdLuGTJIkSZIkSWXk+eefB6C2tnZAt2vIJEmSJEmSVEbmzv0Nw4cP501vOnhAt+ucTJIkSZIkSWVg9epV3HXXndx44yzOOecCampqaG9vZ9OmTWzatBGATZs28vLLL1NVVUVlZWWfbt+QSZIkSZIkaTtG1tWydu2iAdlOb9144yxuueUmIMeIESM48MCDuPLKqzjiiCMBeOSRhzn//E9uXn7KlFMBuPjif+fd727qk7o7GTJJkiRJkiRtx/SLpqddwjZ95zvf3eEyRxxxJC0tDw5ANc7JJEmSJEmSpD5gyCRJkiRJkqSSGTJJkiRJkiSpZIZMkiRJkiRJKpkhkyRJkiRJkkpmyJRx+fxaZsy4nNbWfNqlSJIkSZIkvSpDpoxrbp7N4sWROXNuT7sUSZIkSZKkV2XIlGH5/FpaWubT0dFBS8sCu5kkSZIkSVJmVaVdgF5dc/Ns2ts7AGhvb2fOnNuZOvWjKVclSZIkSdLQ8q0rr2B965p+305N7Sg+/dlL+307/cWQKcMWLVpIodAGQKHQxqJFCw2ZJEmSJEkaYOtb1zD19f2/nRuf6l2Qde65H+fxxx+junoXKipy1NSM4MADD2Ly5FM54ogjAfjpT2/irrvu4Nlnn2GXXYZx6KGHc845n2affV7T5/U7XC7D6usbqKxMcsDKyirq6xtSrkiSJEmSJGXJ1KlnctddC/j1r+dz/fU38E//9EYuvPA8fvaz/wKgrW0TF1zwOebM+Q233HI7w4YNY9q0f+uXWgyZMqypaTIVFTkAKioqmDTplJQrkiRJkiRJWTVmzBg+/OHTmTr1TK699tusX7+eqVPP5JBDDmPYsGHsvnsNH/7waTz11J9Zt661z7dvyJRhdXUjaWycSC6Xo7FxArW1dWmXJEmSJEmSMu6EE97Jhg0bePzxx7Z67MEHH2CvvfZmjz1q+3y7zsmUcU1Nk3n22WfsYpIkSZIkST2y9957A7Bu3bot7n/00d/zve9dw5e+9NV+2a4hU8bV1Y1k+vTL0i5DkiRJkiQNEs8//zwAtbWvdCs9/PCDXHzx57jooi9wzDGN/bJdh8tJkiRJkiSVkblzf8Pw4cN505sOBpKr11988Wf5/Ocv5cQT39Vv27WTSZIkSZIkqQysXr2Ku+66kxtvnMU551xATU0N8+bN5atfvZwvfvEr1Nf3TwdTJ0MmSZIkSZKkQerGG2dxyy03ATlGjBjBgQcexJVXXsURRxwJwNVXf4sNGzZw2WWf3+J5V155FYceenif1mLIJEmSJEmStB01taO48ak1A7Kd3vjOd767w2VuvXXOzpbTa4ZMkiRJkiRJ2/Hpz16adgmDghN/S5IkSZIkqWSGTJIkSZIkSSqZIZMkSZIkSZJKZsgkSZIkSZLURUdHR9olpGpnX78hkyRJkiRJUlFFRSWFQlvaZaRq06aNVFb2/lpxmb26XAhhb+CbwAnALsCfgOkxxgWpFiZJkiRJksrWrrvW8MILeerqRpPLDa3enI6ODjZt2kg+v5IRI0b2+vmZDZmAa4DRwIHAWuAC4FchhHExxnyqlUmSJEmSpLJUU1PL2rUref75Z4ChN2yusrKKESNGsuuuu/f6uVkOmQ4AvhtjXAUQQrgeuBLYH3gozcIkSZIkSVJ5yuVyjBq1V9plDEpZDplmAmeFEH4GrAbOAZ4EHu/pCkaPrumn0iR1qq6uBGDPPUekXEk2uD+yx+/JltwfGggeg0mSNDRlOWS6FzgNeA4okARNJ8cYX+7pClavXk97+9BrbZMG0qZNBQBWrnwh5Uqywf2RPX5PtlRO+6OiImeYkVEeg0mSVJ52dPyVyRmsQggVwFzgGWAUMBz4OHBHCOHgNGuTJEmSJEnS1rLayTQSeD1J59La4n2/CCE8BbwD+ENqlUmSJEmSJGkrmQyZYoyrQwj/B5wbQvgcsB44CXgTTvotSZIkSZKUOZkMmYreC/wnsIRkuNxS4JwY47w0i5IkSZIkSdLWMhsyxRgXAyenXYckSZIkSZJ2LLMhUzlYuHABLS3zS1pHa2segNraupLW09g4kYaGCSWtQ5IkSZIk6dVk8upyekVrayutra1plyFJkiRJkrRddjL1o4aGCSV3D82ceQUA06Zd2hclSZIkSZIk9Qs7mSRJkiRJklQyQyZJkiRJkiSVzJBJkiRJkiRJJTNkkiRJkiRJUskMmSRJkiRJklQyQyZJkiRJkiSVrCrtAiRJGipuvvnHLF++NNUali1Ltj9z5hWp1jFu3HimTDkt1RokSZLUtwyZJEkaIMuXL+XpJU8wtia9X7+70Q7AhhVLUqthxfq21LYtSZKk/mPIJEnSABpbU8WZh4xKu4xUzXpsTdolSJIkqR84J5MkSZIkSZJKZieTNIg5v8srnN9FkiRJktJlyCQNYsuXLyUuXkLl8LrUamgvVAKwZPmq1GoobMintm1JkiRJUsKQSRrkKofXsdv449MuI1UvLp2bdgmSJEmSNOQ5J5MkSZIkSZJKZsgkSZIkSZKkkhkySZIkSZIkqWSGTJIkSZIkSSqZIZMkSZIkSZJKZsikQSWfX8uMGZfT2uol6yVJkiRJyhJDJg0qzc2zWbw4MmfO7WmXIkmSJEmSujBk0qCRz6+lpWU+HR0dtLQssJtJkiRJkqQMMWTSoNHcPJv29g4A2tvb7WaSJEmSJClDDJk0aCxatJBCoQ2AQqGNRYsWplyRJEmSJEnqZMikQaO+voHKyioAKiurqK9vSLkiSZIkSZLUyZBJg0ZT02QqKnIAVFRUMGnSKSlXJEmSJEmSOhkyadCoqxtJY+NEcrkcjY0TqK2tS7skSZIkSZJUVJV2AVJvNDVN5tlnn7GLSZIkSZKkjDFk0qBSVzeS6dMvS7sMSZIkSZLUjcPlJEmSJEmSVDJDJkmSJEmSJJXMkEmSJEmSJEklM2SSJEmSJElSyZz4W5LUb26++ccsX7401RqWLUu2P3PmFanWMW7c+FS3L0mSJPU3QyZJZcNA4xXjxo1nypTTUq0BYPnypcTFS6gcXpdaDe2FSgCWLF+VWlQB1+wAACAASURBVA2FDfnUti1JkiQNFEMmSWVj+fKlPL3kCcbWpPfRthvtAGxYsSS1Glasb0tt29tSObyO3cYfn3YZqXpx6dy0S5AkSZL6nSGTpLIytqaKMw8ZlXYZqZr12Jq0S5AkSZI0BDnxtyRJkiRJkkpmyCRJkiRJkqSSGTJJkiRJkiSpZIZMkiRJkiRJKlmmJ/4OIUwEvgwcDmwE7okxvjfdqiRJkiRJktRdZkOmEMIEYA7wKeB2oAAclmpRUsa0tuYpbMgP+cujFzbkaW2tora2Lu1SJEmSJGnIymzIBMwAvhtj/EmX++5PqxhJkiRJkiS9ukyGTCGE3YG3AgtDCA8CrwOeBC6JMQ7tlg2pi9raOlaua2O38cenXUqqXlw61y4mSZIkSUpZJkMmYCTJpOQfAd4NPA6cATSHEA6KMT7Vk5WMHl3TbwUOlOrqSgD23HNEypUoizrfH3plX2xIuY6sqK6uzMTnhu/RV/ge3VJW3qPqH+VwDCZJknovqyHTC8V/fxhj/H3x/98LIVwAvBO4ticrWb16Pe3tHf1R34DZtKkAwMqVL+xgSQ1Fne8PuS+627SpkInPDb8vr3BfbKkv3qMVFTnDjIwqh2MwSZK0tR0df1UMYC09FmNsBZ4Cuh+deLQiSZIkSZKUQVntZAK4GvhsCOG/gD8BpwH7AXekWZQkSZIkSZK2luWQ6ZtADfDr4r9/BN4TY3w6zaIkSZIkSZK0tcyGTDHGDuDy4pckSZIkSZIyLJNzMkmvJp9fy4wZl9Pamk+7FEmSJEmS1EVmO5mkbbnttlt48sknuO22WzjrrE+mXY4k9Upra56169uY9diatEtJ1Yr1bYz0ZIEkSVLZsZNJg0Y+v5bf/W4hAIsWtdjNJEmSJElShtjJpEHjtttuob29HYD29na7mSQNOrW1dQx7aRVnHjIq7VJSNeuxNQyvrUu7DEmSJPUxO5k0aNx3371b3O7sapIkSZIkSekzZJIkSZIkSVLJDJk0aLz1rcds97YkSZIkSUqPIZMGjVNP/RC5XA6AXK6C97//X1KuSJIkSZIkdTJk0qBRVzeS+vpGAOrrG6h10lhJkiRJkjLDq8ttx803/5jly5emWsOyZcn2Z868ItU6xo0bz5Qpp6VaAyTdTKtWrbSLSZIkSZKkjDFk2o7ly5cSFy+hcnh6HTPthUoAlixflVoNhQ351LbdXV3dSKZPvyztMiRJkiRJUjeGTDtQObyO3cYfn3YZqXpx6dw+Wc/ChQtoaZlf0jpaW5PAq5Shco2NE2lomFBSHZIkSZIkaUvOyaRBpbW1ldbW1rTLkCRJkiRJ3djJpAHT0DCh5A6izrmppk27tC9KkiRJkiRJfcROJkmSJEmSJJXMkEmSJEmSJEklM2SSJEmSJElSyZyTSRrkChvyfXYFwJ3R3rYBgIqq4anVUNiQB8aktn1JkiRJkiGTNKiNGzc+7RJYtmwpAPuOSzPkGcO4ceNZvnxpijVoW1pb86kHoVlQ2JCntbWK2tq6tEuRJEmS+o0hkzSITZlyWtolZOqKf521SJIkSZIGniGTpLLR2ppn7fo2Zj22Ju1SUrVifRsjW/NplwFAbW0dK9e1sdv449MuJVUvLp1rF5MkSZLKnhN/S5IkSZIkqWR2MkkqG7W1dQx7aRVnHjIq7VJSNeuxNQy3a0aSJEnSALOTSZIkSZIkSSUzZJIkSZIkSVLJDJkkSZIkSZL6UT6/lhkzLqc1Ixfo6S+GTJIkSZIkSf2ouXk2ixdH5sy5Pe1S+pUhkyRJkiRJUj/J59fS0jKfjo4OWloWlHU3kyGTJEmSJElSP2lunk17ewcA7e3tZd3NZMgkSZIkSZLUTxYtWkih0AZAodDGokULU66o/xgySZIkSZIk9ZP6+gYqK6sAqKysor6+IeWK+o8hkyRJkiRJUj9pappMRUUOgIqKCiZNOiXlivqPIZMkSZIkSVI/qasbSWPjRHK5HI2NE6itrUu7pH5TlXYBkiRJkiRJ5aypaTLPPvtMWXcxgZ1MkiRJkqRBLp9fy4wZl5f1peE1uNXVjWT69MvKuosJDJkkSZIkSYNcc/NsFi+OZX1peGkwMGSSJEmSJA1a+fxaWlrm09HRQUvLAruZpBQ5J5MkqV8VNuR5cenc1Lbf3rYBgIqq4anVUNiQB8aktn1JkspZc/Ns2ts7AGhvb2fOnNuZOvWjKVclDU2GTNvR2ppP/Y+jLChsyNPa6ltFUu+NGzc+7RJYtmwpAPuOSzPkGcO4ceNZvnxpijVIklSeFi1aSKHQBkCh0MaiRQsNmaSUmBxIkvrNlCmnpV0CM2deAcC0aZemXElSy4r1bcx6bE1qNazf2A5AzS7pjZhfsb6N/VLbuiSp3NTXN7BgwTwKhTYqK6uor29IuyRpyDJk2o7a2jpWrmtjt/HHp11Kql5cOrfsZ8CXpIGQhc6uvxU7u8aMTa+W/cjGvpAklYempsm0tMynUICKioqyv0S8lGWGTJIkDRA7uyRJ6nt1dSNpbJzIvHlzaWyc4AlyKUWGTJIkSZKkQa2paTLPPvuMXUxSygyZJEmSJEmDWl3dSKZPvyztMqQhb1CETCGE2cDJwNtjjPNSLkdShjmpspMqS5IkSUpH5kOmEMJpwG5p1yEp+7IwkbCTKkuSJEkaqjIdMoUQXgt8GWgElqZcjqSMc1JlSZIkSUpPZkOmEEIO+CHw5RjjshBCr9cxenRNSTVUV1eW9PxyUl1dyZ57jki7jM3fkyzUooTfky25P7LH78mW3B8aCKUeg0mSpMEpsyETcDaQizF+d2dXsHr1etrbO3a6gE2bCjv93HKzaVOBlStfSLuMzd+TLNSihN+TLbk/ssfvyZbKaX9UVOQMMzKq1GMwSZKUTTs6/spkyBRC2B+4FDg67VokSZIkSZK0Y+ld/mj73gaMBh4KIawKIawq3v+LEMK1KdYlSZIkSZKkbchqyPTfwOuBw7p8AXwMuDitoiRJkiRJ2ZPPr2XGjMtpbc2nXYo0pGVyuFyM8UXgxa73FSf+XhljXJtKUZIkSZKkTGpuns3ixZE5c25n6tSPpl2ONGRltZNpKzHGXIxxXtp1SJIkSZKyI59fS0vLfDo6OmhpWWA3kzJpqHTbDZqQSZIkSZKk7pqbZ2++omV7eztz5tyeckXS1rp225UzQyZJkiRJ0qC1aNFCCoU2AAqFNhYtWphyRdKWhlK3nSGTJEmSJGnQqq9voLIymW64srKK+vqGlCuStjSUuu0MmSRJkiRJg1ZT02QqKnIAVFRUMGnSKSlXJG1pKHXbZfLqcsqmm2/+McuXL021hmXLku3PnHlFqnWMGzeeKVNOS7UGSZIkDV35/Fquu+7bnH32+dTW1qVdTqrq6kZy1FFHc++993DUUW8d8vtD2VNf38CCBfMoFNrKvtvOkEk9tnz5Up5e8gRja9J72+xGOwAbVixJrYYV69tS27YkSZIEW04iPHXqR9MuJzNyuVzaJUhbaWqaTEvLfAqF8u+2M2RSr4ytqeLMQ0alXUaqZj22Ju0SJEmSNIR1n0R40qRThnT3Tj6/lgce+B0A99//O0499UNDen8oe+rqRtLYOJF58+bS2DihrN+fzskkSZIkSYPIUJpEuCfcHxoMmpom84Y3hLLuYgJDJkmSJEkaVIbSJMI94f7QYFBXN5Lp0y8r6y4mMGSSJEmStpLPr2XGjMtpbc2nXYq0lfr6Biork5lPyn0S4Z5wf0jZYcgkSZIkddN1UmUpa5qaJlNRkUxwXe6TCPeE+0PKDkMmSZIkqYvukyrbzaSs6ZxEOJfLlf0kwj3h/pCyw5BJkiRJ6sJJhDUYDJVJhHvK/SFlQ1XaBWRdYUOeF5fOTW377W0bAKioGp5aDYUNeWBMatuXJEkaSNuaRHjq1I+mXJW0pc5JhJVwf0jZYMi0HePGjU+7BJYtWwrAvuPSDHnGMG7ceJYvX5piDZIkSQOjvr6BBQvmUSi0OYmwJEm9YMi0HVOmnJZ2CcyceQUA06ZdmnIlr9QiSZJUzpqaJtPSMp9CwUmEJUnqDedkkiRJkrpwEmFJknaOnUySJElSN01Nk3n22WfsYpIkqRcMmSRJkqRunERYkqTec7icJEmSJEmSSmbIJEmSJEmSpJI5XE491tqaZ+36NmY9tibtUlK1Yn0bI1vzaZchSZIkSVKm2MkkSZIkSZKkktnJpB6rra1j2EurOPOQUWmXkqpZj61huJcyliRJkiRpC3YySZIkSZIkqWQ97mQKIewKHA7sU7zrOeD3McaX+qMwSZIkSZIkDR47DJlCCDngK8B5wO7dHv57COEq4JIYY0c/1Cepny1cuICWlvk7/fxly5YCMHPmFSXV0dg4kYaGCSWtQ5KkvpLPr+W6677N2WefT+0QHybvvpAk9VRPhst9BfgEMA04AKgpfu1fvO8TQGl/XUoatGpra6mtrU27DEmS+lRz82wWL47MmXN72qWk7uabf8yTTz7BzTf/OO1SJA0i+fxaZsy4nFavzD2k9GS43BnAmTHGOd3u/wtwTQjhGeA64JI+rk3SAGhomGAHkSRJXeTza2lpmU9HRwctLQuYNOmUIdvBk8+v5cEH7wPggQd+x5Qppw3ZfSGpd7qG9VOnfjTtcjRAetLJNBJYvJ3HlwD+ppEkSVJZaG6eTXt7MhNEe3v7kO5m6t69ZDeTpJ7oHtbbzTR09CRkehi4cDuPf6a4jCRJkjToLVq0kEKhDYBCoY1FixamXFF6OruYOj3wwO9SqkTdORRJWWZYP3T1ZLjcZ4DfhBDeAfwGWFG8fyxwIlALvKN/ypMkSZIGVn19AwsWzKNQaKOysor6+oa0S5K24lAkZdm2wnrfp0PDDjuZYoz3AW8CbiKZ+Pv9xa8DivcdFGO8vz+LlCRJkgZKU9NkKipyAFRUVDBp0ikpV5SevffeZ7u3lQ6HIinr6usbqKxMeloM64eWngyXI8b4TIzx4hjjsTHGUPw6Nsb4hRjjM/1dpCRJkjRQ6upG0tg4kVwuR2PjhCE90fXZZ5+3xe1Pfer8lCpRVw5FUtYZ1m9tqAxx7clwOQBCCIuBjm081AFsAJ4EvhtjvKuPapMkSZJS0dQ0mWeffWbI/2G0xx61272tdDgUSVnXGdbPmzd3yIf1nYbKENcedTIV3QrsBawGfln8WlW8725gFHBnCKGpr4uUJEmSBlJd3UimT79syP9h1Nw8m8rKSgAqKyvtmMmI+voGcrmkSySXyzkUSZnU1DSZN7whDPmwHpIupnvu6RziOr+su5l6EzLVAtfEGOtjjJ8pfh0DXA1UxxiPB64ELumPQiVJkiQNrKRjpgBAoVAY0lfay5KJE4+joyMZZNLR0cGxxx6fckXS1gzrX9HcPHtz92FbW1tZB/Y9Hi4HfAg4ehv3/wi4DzgXuBH4ZB/UpYxasb6NWY+tSW376ze2A1CzS2/y0b61Yn0b+6W2dUmSpIHjlfayaf78u7e4PW/e3LIeftMT+fxarrvu25x99vmGGsqce+9t2SIYvvfelrL9me1NyFQJ/COwuNv9/8grHVEvA+19UJcyaNy48WmXwN+WLQVgzNj0atmPbOwLSZKk/tbUNJmWlvkUCk7emyXdO8qck2nozHejwWn06NH89a/PbnG7XPUmZPpv4PshhM+TdC51APXAl4FbisvUA0/0aYXKjClTTku7BGbOvAKAadMuTbkSSZJUzuyKSDh5bzYdccSR3HvvPVvcHsry+bW0tHTOd7OASZNO8b2qTFm9evV2b5eT3oRM55NcRe46oBrIARuB64GLiss8DHysLwuUpIGycOECWlrml7SOZcVuu85AdGc0Nk6koWFCSXVIkkpjV8QrvNJe9nVOAj5UNTfPpr09GYrU3t7uz60y55hjGvntb+eS9OrkOOaYxrRL6jc9DplijBuA80MI04EDincviTG+2GWZx/u4PkkaVGprvbSzJA125dYVUepJlM6rIF133bdLqsOTKH3n4Ycf3OL2Qw89wFlnDd2pcZMJ6pNJlQuFNocPKnOamiZzzz3zaGtro6qqqqxD+950MgFQDJUe64daJClVDQ0TPPiVJNkV0U1rayvAoA7ayk19fQPz5s2lo6ODXC435Cdkr69v2KJLZKjvD/W9vhjxUF29C21tbey+++47HdoPhrC+1yHTQAghzAROAsYB64E7gItijOU7cFGSJEmZUG5dEaWeRHFOzOxpaprMb3/7v0Bypapy7oroiYkTj9u8P6CDY489PtV6pG1JQuEKxozZM+1S+lUmQyagAHwEeBwYCdwE3AA0pViTJEmShoD6+gYWLJhHodBGZWWVXRHKnHXrWre6PZQ7zebPv5tcLre5s2vevLmDOhhW9vTFiIehEthXpF3AtsQYL44x/j7GuCnG+DfgKmBi2nVJkiSp/DU1TaaiIplIuaKiYsh3iSh7rr32qi1uX3PNt1KqJBsWLVpIR0cyxLWjo4NFixamXJE0dGW1k6m744FHe/uk0aNr+qGUgVVdXQnAnnuOSLmSbHB/SOotPze25P7QQBjsx2B77jmCE044gTvvvJMTTzyBAw4Yl3ZJqfJzI3uef37FVreH8vfn7W8/lt/85jcUCgUqKys57ri3D+n9oWwaKp+lmQ+ZQggfAD7GTnQyrV69fvOkjYPVpk0FAFaufCHlSrLB/SGpt/zc2FI57Y+KitygDzPKVTkcg5144kn8+c9/4cQTTyqLn5dSlNPnRrnoHBrW9fZQ/v6ceOJJ3HnnnQC0t3f4c6tMKpfP0h0df2U6ZAohfAi4FpgUY3w47XokSUpTX1zZZNmypcAr8wLsjMFwZROpVHV1I5k+/bK0y5C26c1vfgsPPnjf5ttHHvmWFKvJhlfmZEq7Emloy+ScTAAhhLOAa4CTYoy/TbseSZLKQW1tLbW1tWmXIUkqwZQpp3W7fXpKlWRDc/NscsV0KZfLMWfO7SlXJA1dmexkCiGcD1wGvCPG+GDa9UiSlAV9cWUTSdLgV1c3kiOPfCsPPngfRx311iF9ZTlIJv4uFJKhSIVCgUWLFnp1OSklmQyZgG8BbcC8EELX+w+MMS5LpyRJkiQNFfn8Wq677tucffb5Q/4PePW9vhj+vGbNaqqrq1mzZs1OD4HOyvDnUvfHsGHD2LDhpS1u78w+ycr+kAazTIZMMUZH0kqSJCk1zc2zWbw4MmfO7XZEKJPWr19PVVU1VVWZ/JNuQI0ZM4bW1jyQDJcbM2bPlCuShi4/kSRJmVbq2c2+mOgaPLspDSX5/FpaWubT0dFBS8sCJk06xW4m9am+GP7c+Xtt2rRL+6KkVPXF/vi3f/sUra15jj32eIPhPtAX3XadwV+pn58egw0umZ34W5KkvuBE15J6q7l5Nu3tyeXh29vbnURYGgTGjBnDrrvuyqRJp6RdiopaW1tpbW1NuwwNMDuZJEmZ5mTXkgZaMolwGwCFQpuTCEuDQFVVNfvuu59dh33EbjvtLDuZJEmSpC7q6xuorEzOxVZWVlFf35ByRZIkDQ52MkmSJKmslDqXSFvbps2dTO3tBZYtW+qVqiRJ6gE7mSRJkqQuqqqqqaysBGCPPWq9epckST3kb0xJkiSVlb6YS+QrX7mMv/71Wb74xf9wjhdJknrITiZJkiSpGycRliSp9wyZJEmSJEmSVDJDJkmSJEmSJJXMkEmSJEmSJEklM2SSJEmSJElSyQyZJEmSJEmSVDJDJkmSJEmSJJXMkEmSJEmSJEklM2SSJEmSJElSyQyZJEmSJEmSVLKqtAsoZwsXLqClZX5J61i2bCkAM2deUdJ6Ghsn0tAwoaR1lCor+yML+0KSJEmSpHJjyJRxtbW1aZeQKe4PSZIkSZKyyZCpHzU0TLBjpgv3hyRJkiRJ5cs5mSRJkiRJklQyQyZJkiRJkiSVzJBJkiRJkiRJJTNkkiRJkiRJUskMmSRJkiRJklQyQyZJkiRJkiSVzJBJkiRJkiRJJTNkkiRJkiRJUskMmSRJkiRJklQyQyZJkiRJkiSVrCrtAiRJkiRt2803/5jly5emWsOyZcn2Z868ItU6AMaNG8+UKaelXYakQSQLn6OQnc/S/v4cNWSSJEmSMmr58qU8veQJxtakd9i+G+0AbFixJLUaAFasb0t1+5IGpyx8jkI2PksH4nPUkEmSJEnKsLE1VZx5yKi0y0jdrMfWpF2CpEHKz9HEQHyOOieTJEmSJEmSSmYnkyRJkiRppzjfzZacN0xDnSGTJEmSJPVCFoKVrIQqzz+/gpdeyDvfDc4bJoEhkyRJkiT1yvLlS4mLl1A5vC61GtoLlQAsWb4qtRoKG/LsOqza+W6KnDdMMmSSJEmSpF6rHF7HbuOPT7uMVL24dC50/D3tMiRliBN/S5IkSZIkqWSGTJIkSZIkSSqZw+UkSZKUKU6q/Irnn19BbaoVSBqM/Bx9hZ+jA8uQSZIkSZnipMqJzkmV2SW1EiQNUn6OJvwcHXiGTJIkScocJ1V2UmVJpfFz1M/RNGQ2ZAohVABfBs4CdgdagE/EGNPt+ZMkSZIkSdJWMhsyARcB/wJMAJ4FvgE0hxAOizG2p1qZJEmSJEnKvLa2NlZsbGPWY2vSLiV1K9a3MbI136/byHLI9ElgZowxAoQQLgKeBxqBBWkWJkmSJA0E/zh6xUD8cSRJKk0mQ6YQQi0wHniw874YYz6EsAQ4jB6GTKNH1/RPgZIkSXpVpR6DVVdX9lElg18ul3YF2VJZWcGee45Iuwzfo134Ht1SdXWl79GMqa6uYs/qDs48ZFTapaRu1mNrGDFmdL++RzMZMgF7FP/tfqoi3+WxHVq9ej3t7R19VpQkScqOioqcJ5QyqtRjsE2bCn1YzeBWWVnFXrv6xxEkfxwNr9mDlStfSLsU36NdbNrUxoqX7baDpNvu5VWrfY9mTIeRwBY2bSqU9B7d0fFXxU6vuX+tK/5b2+3+ui6PSZIkSZIkKSMy2ckUY2wNISwFjqQ4ZK44hG5/4JE0a5MkSZIkJaqqqthrF7vtoNhtV1uXdhlSqjIZMhVdB3wuhHA3ydXlZgJPAi2pViVJkiRJkqStZDlk+hrJcLkWYPfiv5NijO2pViVJkiRpSGttzVPYkOfFpXPTLiVVhQ152ipzsEvalUjKisyGTMUw6fPFL0mSJEmSJGVYZkMmSZIkDU12iSTsEsmu2to6Vq5rY7fxx6ddSqpeXDqXqo6/A5vSLkVSRmT16nL/v717D7OrLu8F/p2ZJIQ6YSYJJIFyCaV0yU3uHCMRlCJ4IUAA4RwwgHdRVFRAwKJt0XPAQj2KlMQb+oQK1RKU4K0UyyU0PeVSuVi6pMpFqEAImYSh5Dazzx97iJMQwmVn9tqT+XyeJw+z19p7r3cN88y8+7vf9dsAAAAADCMmmQAAaCmmROpMiQCvlonQOhOhzWeSCQAAAICGmWQCAACATYiJ0LrnJ0If730uV9zzdKW19K7sT5J0jqlu1ufx3tWZOsTHEDIBAADwqj3eu9oL+DTnBTyv3Nixm2XS9jtUXUaefOThJMmWU6qrZWqS7bYb2uMLmQAAAHhVvID/vakZ+hfwvHKTJk3Jpz99ftVl5KKLLkiSlqhlKAmZAACghVU9JdIKEyKJKZFW5QU8MJiQCQAAWlQrTIm0woRIYkoEYDgQMgEAQItqhSkREyLrV/XHw/evXp4kaR81trIa+pb3JNmysuMDrUfIBAAA8Aq0wkTVIwMTZttvV2XIs2VLfC+A1iFkAgAAeAVOPPHkqkswYQa0JCETAAAtx6VILkUCYPgRMgEA0FJa4fIblyIBwCsnZAIAoKW4FAkAhichEwAAAGxiXHbssuMqCJkAAABgE9IKl9q67HhkEjIBAADAJsRlx1SlveoCAAAAABj+hEwAAAAANEzIBAAAAEDDhEwAAAAANEzIBAAAAEDDhEwAAAAANEzIBAAAAEDDhEwAAAAANEzIBAAAAEDDhEwAAAAANEzIBAAAAEDDhEwAAAAANEzIBAAAAEDDhEwAAAAANEzIBAAAAEDDhEwAAAAANEzIBAAAAEDDhEwAAAAANEzIBAAAAEDDRlVdAAAAACPXbbfdkgULbm7oOR555OEkyUUXXfCqn2P69INz4IEHNVQHjHRCJgAAAIa1rq6uqksAImQCAACgQgceeJAJIthEWJMJAAAAgIYJmQAAAABomJAJAAAAgIa15JpMRVF8KslJSXZKsjzJLUnOKsvyoSrrAgCg9fmkKgA2Jn9XXr5WnWQak+SjSSYn2TnJc0nmV1oRAAAjRldXl0+rAmCjGSl/V1pykqksy/8z6Obyoii+mOTeoigmlGX5dFV1AQDQ+nxSFa3OVAQML/6uvHwtGTKtx58mefSVBkwTJ3YOUTkAALwYPdimZfTojiTJVluNq7iSTccWW2y+5vv6ak2cOCFJGnqeLbbY3P9XhozfHSNTU0Omoii+neSUDdzlmrIsj1vnMW9M8oUkJ7zS4y1e3Jv+/torfRgAMAy0t7cJM1qUHmzTsmpVX5Jk0aJnKq5k07HHHvtnjz32r7qMJP6/MnT87tg0vVT/1exJptOTnLmB/SsG3yiK4k1Jrk3y/rIsfzSEdQEAAABpnUs6E5d1DjdNDZnKsuxN0vty7lsUxduSXJXkPWVZzhvSwgAAYBPV6ItFLxSBV2MkLHLNC7XkmkxFURyb5FtJ/ldZlj+uuh4AABipvFCEkcdC17xabbVa610vXxTFg0m2S7J8nV1vK8vy1pfxFFOTPGg9AADYdA1aE2DHJA9VWw0DpkYPBgCbrJfqv1pykqksyx2rrgEAgJGrp2dJZs++NKed9rF0dXVXXQ4ADAvtVRcAAACtZv78a/PAA2Wuu87SoADwcgmZAABgkJ6eJVmw4ObUarUsWHBLli7tqbokeIGeniW58MK/9PMJtBQhEwAADDJ//rVr1pTq7+83zURLMm0HtCIhEwAADLJw4W3p61udA3C4/AAAFbNJREFUJOnrW52FC2+ruCJYm2k7oFUJmQAAYJBp0w5MR0f983E6OkZl2rQDK64I1mbaDmhVQiYAABhkxoyZaW9vS5K0t7fnyCOPqbgiWJtpO6BVCZkAAGCQ7u7xmT794LS1tWX69IPS1dVddUmwFtN2QKsSMgEAwDpmzJiZnXcuTDHRkkzbAa1KyAQAAOvo7h6fc875rCkmWpJpO6BVjaq6AAAAAF6ZGTNm5rHHHjXFBLQUIRMAAMAw8/y0HUArcbkcAAAAAA0TMgEAAADQMCETAAAAAA0TMgEAAADQMCETAAAAAA0TMgEAAADQMCETAAAAAA0TMgEAAADQsFFVF1CV5557Nr29PenrW111KU3X0TEqnZ3d2Xzz11RdCgAAALCJGJEh03PPPZtnnlmS7u6tMnr0mLS1tVVdUtPUarWsWrUyPT2LkkTQBAAAAGwUI/Jyud7ennR3b5UxYzYbUQFTkrS1tWXMmM3S3b1Vent7qi4HAAAA2ESMyJCpr291Ro8eU3UZlRo9esyIvFQQAAAAGBojMmRKMuImmNY10s8fAACGs56eJbnwwr/M0qWuTgBax4gNmQAAAIar+fOvzQMPlLnuunlVlwKwhpBpI/vmN+fkhBOOrroMAABgE9XTsyQLFtycWq2WBQtuMc0Uk13QKoRMAAAAw8j8+demv7+WJOnv7zfNFJNd0CqETAAAAMPIwoW3rfkQn76+1Vm48LaKK6qWyS5oHaOqLmA4W7FiRS699K9zww0/TVtbew499LB0do5bs79Wq+Wqq67Mtdf+fRYteiKTJk3OccedkOOPP3HNfW699aZ861tfyyOPPJzRo0dnu+22z1lnnZc/+ZPXJkkeffS3ufzyr+TOO29P0pZddtk1p5/+iey00x83+3QBAIAWMG3agbnllpvS17c6HR2jMm3agVWXVKn1TXbNmvWeiquCkckkUwPmzPlqbrrp5/mzP/uLzJlzRcaO3Tzz5n1/zf55876fb3xjdt71rlMyd+73cuKJszJ79ldz/fU/SJIsXvxUzj//nBx66OGZO/d7mT37irzznSemo6Oe/T399OJ8+MPvy/jxE3LZZd/I1752Rbbffod89KMfzJIlSyo5ZwAAoFozZsxMe3v906Lb29tz5JHHVFxRtUx2QesQMr1Kzz33XH7wg2vygQ98OG9845uyww5Tc/rpZ2S77bZfc5+//dvv5Ljjjs9RRx2T7bbbPkcffVyOPvrYfOc7VySph0yrV6/OIYe8Jdts84eZOnXHHHbYW9dMKV177d9nypStc+aZ52annf44228/NWeccVY6Oztzww0/qeS8AQCAanV3j8/06Qenra0t06cflK6u7qpLqtS0aQeueaPeZBdUy+Vyr9Jjjz2alStXZvfdX7fW9te9bq/88z/fmmef7c2TTz6RPffcZ639e+21b77//auzfPny7LTTzjnggGk5+eQTst9+/yN7771vDj74zZk8eUqS5D/+499TlvfnLW9541rPsWLFivz2t78d2hMEAABa1owZM/PYY4+O+CmmpP69WLDg5vT1meyCqgmZKtTR0ZFLLvlK7r//l7njjn/NzTf/PLNnfzUXXHBhDjzwjenvr2XffQ/IJz959gse+5rXdFZQMQAA0Aq6u8fnnHM+W3UZLeH5ya6bbrrRZBdUzOVyr9If/uG2GT16dO677561tt97791J6iHQpEmTc/fdd621/xe/uDNbb71Nxo4dmyRpa2vLrrvunpNPfk8uu+zr2WuvffLjH1+XJHnta3fJQw/9JlttNSnbbrvdWv/Gjx/fhLMEAABofTNmzMzOOxemmKBiJplepc033zxHHXVsvv71yzNhwoRsv/0Ouf76H+aRRx5eEwC9612n5qtf/b/Zdtvts/fe++bOO2/PD35wzZrJpHvvvTt33nl79t//9Zk4ccs8+ugj+fWvH8gRRxyVJDn22ONz/fU/zLnnfiqnnPLeTJo0OU8++WT+5V9uyxveMD177LFnZecPAADQKkx2QWsQMjXgtNNOz8qVK3LBBfVfZocccliOOead+ad/+sckycyZx2X58ucyd+4VueSSCzNp0pR86EOn54gjjk5Sn3a67757Mm/e9/PMM8syYcLEHHbY23Lqqe9LkkyYMDFz5lyROXMuy2c+c1aeffbZTJgwMXvuuXcmTtyympMGAAAAWI+2Wq1WdQ1DYWqSBxcv7k1//wvP7/HHH86UKTs0vahW4/sAwHDW3t6WiRM7k2THJA9VWw0DpmYDPRgAMLy9VP9lTSYAAAAAGiZkAgAAAKBhQiYAAAAAGiZkAgAAAKBhQiYAAAAAGiZkAgAAAKBhLR8yFUXxpaIoakVRnFp1LQAAAACsX0uHTEVRvCnJIUl+V3EpAAAAAGxAy4ZMRVGMS/L1JO9NsrLicgAAAADYgFFVF7ABX0ry/bIs7yiKYsgPduEXL8ySnqVDfpwkGd/dlXPOPqcpxwIAAABohqaGTEVRfDvJKRu4yzVlWR5XFMXbk7w+yb6NHG/ixM71bn/yyfaMGrX2ENeSpUuzfPy0Rg73si3pWfiC47+Y0057f+699+6MGTMmbW3tGTeuM7vttkeOOead2Xff/ZIkt9/+//Kd73wrv/rVr7Js2dLMm3d9ttlmm5d87vb29my11biGzgUAYF0v1oMBAJu2Zk8ynZ7kzA3sX1EUxfgks5McW5blikYOtnhxb/r7ay/Y3t/fn9Wr+9fe+MK7DZ1aXnj8F7trrZZZs96d9773g0mSp556Kj/72Y9yxhkfyemnn5Fjjz0ho0ePzeGHvyPHH39Szj77jPT1ref81qO/vz+LFj3T0KkAQFXa29uEGS3qxXowAGB4e6n+q6khU1mWvUl6N3SfgcW+t0nyk0GXyY1PcmlRFMeVZXnEkBbZ4rbccsucdNIpWbFiRS6//NIcfvg7svvue2T33ffI7373X1WXBwAAAIxQrbjw98IkU5PsNejffyX5bJJ3V1dWazn00MOzfPny3HffPVWXAgAAANB6C38PXCL36OBtRVH0JVlSluWiaqpqPZMnT06SLFu2rOJKAAAAAFowZFqfsiynVl1Dq3niiSeSJF1dXRVXAgAAANCal8vxMtx44z9k7Nix2W23PaouBQAAAGB4TDLxe4sXP5Ubbvhp5s69Ih/5yBnp7OxMf39/Vq1alVWrViZJVq1amRUrVmTUqFHp6OiouGIAAABgJBAyDRjf3ZUlSxY27VivxNy5V+Tqq69M0pZx48Zl1113z8UXfyX77LNfkuQXv7grH/vYh9bc/8QTj0uSnHfe5/L2t8/YaHUDAAAAvJi2Wq1WdQ1DYWqSBxcv7k1//wvP7/HHH86UKTs0vahW4/sAwHDW3t6WiRM7k2THJA9VWw0DpmYDPRgAMLy9VP9lTSYAAAAAGiZkAgAAAKBhQiYAAAAAGiZkAgAAAKBhQiYAAAAAGiZkAgAAAKBhQiYAAAAAGiZkAgAAAKBho6ouoFV8+eIL0rv06aYcq7NrQj5+5vlNORYAAABAMwiZBvQufTqz/qg5x5r7m5cfZp1++gdy3333ZPToMWlvb0tn57jsuuvumTnzuOyzz35JkquuujI33PCTPPbYoxkzZrPsuefe+chHPp6tt95mqE4BAACgZfT0LMns2ZfmtNM+lq6u7qrLgRHL5XLDwKxZ784NN9ySn/3s5syZ8+289rW75FOf+miuuebvkiSrV6/KGWecleuu+4dcffW8bLbZZvn0pz9RcdUAAADNMX/+tXnggTLXXTev6lJgRBMyDTNbbrllTjrplMya9e5cfvml6e3tzaxZ787rXrdXNttss7zmNZ056aST85vf/DrLli2tulwAAIAh1dOzJAsW3JxarZYFC27J0qU9VZcEI5aQaZg69NDDs3z58tx33z0v2HfHHbdn0qTJ2WKLrgoqAwAAaJ75869Nf38tSdLf32+aCSokZBqmJk+enCRZtmzZWtvvvvvf8vWv/03OPPPcKsoCAABoqoULb0tf3+okSV/f6ixceFvFFcHIJWQapp544okkSVfX76eV7rrrjnz605/M2Wd/Jm94w/SqSgMAAGiaadMOTEdH/TOtOjpGZdq0AyuuCEYuIdMwdeON/5CxY8dmt932SFJP788778yce+75ectb3lpxdQAAAM0xY8bMtLe3JUna29tz5JHHVFwRjFxCpmFm8eKncvXVV2bu3Cty2mkfS2dnZ2666cb8+Z+fl8997vM5+OBDqi4RAACgabq7x2f69IPT1taW6dMPSldXd9UlwYg1quoCWkVn14TM/c3TTTvWKzF37hW5+uork7Rl3Lhx2XXX3XPxxV/JPvvslyS57LIvZ/ny5fnsZ9deh+nii7+SPffce2OVDQAA0JJmzJiZxx571BQTVKytVqtVXcNQmJrkwcWLe9d8ysBgjz/+cKZM2aHpRbUa3wcAhrP29rZMnNiZJDsmeajaahgwNRvowQCA4e2l+i+XywEAAADQMCETAAAAAA0TMgEAAADQMCETAAAAAA0bsSHTJrrg+cs20s8fAAAA2LhGZMjU0TEqq1atrLqMSq1atTIdHaOqLgMAAADYRIzIkKmzszs9PYuycuWKETfRU6vVsnLlivT0LEpnZ3fV5QAAAACbiBE5yrL55q9Jkixd+lT6+lZXXE3zdXSMyrhx49d8HwAAAAAaNSJDpqQeNAlZAAAAADaOEXm5HAAAAAAbl5AJAAAAgIYJmQAAAABo2Ka6JlNHkrS3t1VdBwAwRAb9ne+osg7WogcDgE3YS/Vfm2rItHWSjB9vYW8AGAG2TvLrqosgiR4MAEaK9fZfbbVarYJahtxmSfZP8rskfRXXAgAMjY7UG5zbk6youBbq9GAAsGnbYP+1qYZMAAAAADSRhb8BAAAAaJiQCQAAAICGCZkAAAAAaJiQCQAAAICGCZkAAAAAaJiQCQAAAICGCZkAAAAAaJiQCQAAAICGCZkAAAAAaNioqgugdRRFcVGSI5Jsl6Q3yU+SnF2W5eL13HffJP+S5LayLN/UzDrheUVRXJvk6CRvLsvypoFtn0jy4SRTkjyV5FtJPl+WZa2qOhlZiqL4ZZIdBm1qT7J5kmOS/C7J+Un2G9j2n6n/fM5rdp1A69CDMdzowWg1+q/WYZKJwfqSvCvJxCR7pd7ofHvdOxVFMXZg+81NrA3WUhTFyUn+YJ1tM5L87yTvSbJFkiOTfHTgNjRFWZa7lWXZ+fy/JOckWZz6i8YJSf4uyW5JupN8Icl3i6I4oLKCgVagB2PY0IPRivRfrcMkE2uUZXneoJtPFkXxlSTfXc9dv5DkxiQ9Sd7UhNJgLUVRbJvk80mmJ3l40K4/TnJfWZa3Dty+tyiKW1Jv2KEqpyX5ZlmWy5P8eJ191xRFcW7qP8v/2vTKgJagB2O40IMxjOi/KmKSiQ350yR3D95QFMVBqY9zn7feR8AQK4qiLb8fv35knd1XJdm8KIo3F0XRXhTF3qn/8fhhs+uEJCmK4pAkf5Jk9ovs3ybJLlnndy0w4unBaDl6MIYL/Ve1hEysV1EUxyd5X5KPD9rWmfoflveXZfnfVdXGiHdakrayLL+2nn2Lklyd+ljsyiR3JvlGWZb/2MT6YLAPJ/lpWZYPrrtj4HfqvCTzy7K8semVAS1JD0YL04MxXOi/KiRk4gWKovifSeYkObIsy7sG7bo4yY/LsrylmsoY6Yqi2Cn1Rfve9yJ3+bPUr/0/IMmYJDsnOawois83p0L4vYF3yY5K8jfr2deV5KepL0R5cpNLA1qUHoxWpQdjuNB/Vc+aTKylKIr3JvmrJEeUZXnbOrvfmqS7KIoTB27/QZLRRVE8lWT/9SXFsJG9MfVFUe8simLw9h8WRfHdJNsmubYsy3sGtv+6KIork7w/9eYHmukDSX6b+ru6axRFMTHJz5I8kGRWWZarK6gNaDF6MFqcHozhQv9VMZNMrFEUxceSXJTksPU0N0ny+iS7p76A316pX+N6x8DX616XDUPhe0n+KL//GXx+Mcn3pb5Gxa1JjiqKYtckKYpih9Q/refO5pfKSFYUxajUG+s5ZVn2D9o+JfVPhbonyUkaHCDRgzEs6MFoefqv1mCSicG+nGR1kpvWeYdi17IsHynL8vHBG4uiWJZkRVmWjzaxRkawgXUo1lqLYuBndVFZlkuKorgkybgk1xdFsVWSZal/msRZza6VEe+o1N/x/eY62z+Y+sfn7pjk+EG/a68sy/JDzSsPaDF6MFqaHoxhQv/VAtpqtVrVNQAAAAAwzLlcDgAAAICGCZkAAAAAaJiQCQAAAICGCZkAAAAAaJiQCQAAAICGCZkAAAAAaJiQCQAAAICGCZmApiuK4h+Lovh21XUAAIwkejBgqAmZAAAAAGhYW61Wq7oGYAQZePfslHU2vznJ/UkuSvKOJGOT3JPk3LIsbxl43JuS/NPA/vOT7JXk35OcPPAcc5Lsk+S+JKeWZfnvA487Nck3krw1yZeT7JTk7iQfLMvyF4PqenuSC5LsnmRpkr9PclZZls9urHMHAKiKHgxoBpNMQLN9PMmtSb6XZOuBf/+WevMyLsnbkuyd5MdJbiiKYpd1Hv+FJJ9Jsm+SlUmuSnJ5ks8N2nbFOo9pT/LFJB9OckCSRUl+VBTF5klSFMXrklyX5JYke6begB2RZPZGOmcAgKrpwYAhJ2QCmqosy6WpNyHPlWX5eFmWjyeZmWSLJCeUZXlHWZb/WZblF5LcluSD6zzFX5Rl+fOBd8n+OskeSb5cluWNZVnen+SSJAcURdE56DFtqb8jdnNZlvckmZWkK8mJA/vPSnJXWZafKMvyP8qy/EmSjyY5qSiKHYbi+wAA0Ex6MKAZRlVdAECS/ZNMSdJTFMXg7ZsleW6d+9496OvHB/57z3q2TUrSO2j7wue/KMtySVEU9yfZbWDTbkl+vs5xbk69Mdo1ycMv6ywAAIYXPRiwUQmZgFbQnvp6ADPXs++/17m9atDXtQ1sM6kJALBhejBgoxIyAVVYmaRj0O07Ul88cllZlk8O0TFfn4F3yoqi6E6yS+oLVSbJL5MctM79D069WfrlENUDANBsejBgSAmZgCo8mOTNRVHslPqniHwvySdSXwjyM0l+lWRykkOS3F+W5Q8aPF4tyReLovhkkiWpL1z5TJLvDuz/qyR3FUXxpdSbnqlJLk3yt2VZPtLgsQEAWoUeDBhSRhmBKlyS5KnUr+1flPonkhyc+rtpV6Te4MxL/VNINsa1+P1Jzku9ebkj9bUH3lGW5X8nycBClEem/k7a3UnmJvlRkg9thGMDALQKPRgwpNpqtdpL3wtgmCqK4tQk3yjL0uQmAECT6MFgZDLJBAAAAEDDhEwAAAAANMzlcgAAAAA0zCQTAAAAAA0TMgEAAADQMCETAAAAAA0TMgEAAADQMCETAAAAAA37/6jqc0U5TILsAAAAAElFTkSuQmCC\n",
            "text/plain": [
              "<Figure size 1440x576 with 2 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "yWweXSdwxRiQ"
      },
      "source": [
        "#Desafio 06: Descobrir se tem algum composto que dependendo da configuração do experimento, ativa ou não ativa algum MOA "
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "kc6aAzqQxR8H",
        "outputId": "2e8f92ef-e840-4b28-bfd9-5c7ed607435c"
      },
      "source": [
        "unique_moas = dados_resultados.drop(['id', 'n_moa', 'ativo_moa'],axis=1).columns\n",
        "print(unique_moas)"
      ],
      "execution_count": 10,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Index(['5-alpha_reductase_inhibitor', '11-beta-hsd1_inhibitor',\n",
            "       'acat_inhibitor', 'acetylcholine_receptor_agonist',\n",
            "       'acetylcholine_receptor_antagonist', 'acetylcholinesterase_inhibitor',\n",
            "       'adenosine_receptor_agonist', 'adenosine_receptor_antagonist',\n",
            "       'adenylyl_cyclase_activator', 'adrenergic_receptor_agonist',\n",
            "       ...\n",
            "       'tropomyosin_receptor_kinase_inhibitor', 'trpv_agonist',\n",
            "       'trpv_antagonist', 'tubulin_inhibitor', 'tyrosine_kinase_inhibitor',\n",
            "       'ubiquitin_specific_protease_inhibitor', 'vegfr_inhibitor', 'vitamin_b',\n",
            "       'vitamin_d_receptor_agonist', 'wnt_inhibitor'],\n",
            "      dtype='object', length=206)\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "rvmoaLJjVImu",
        "outputId": "e3e7b17a-d391-4df5-8b8c-5212ddeedb12"
      },
      "source": [
        "compostos = dados_combinados['composto'].value_counts().sort_values(ascending=False).index[1:]\n",
        "compostos"
      ],
      "execution_count": 11,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['87d714366', '9f80f3f77', '8b87a7a83', '5628cb3ee', 'd08af5d4b',\n",
              "       '292ab2c28', 'd50f18348', 'd1b47f29d', '67c879e79', '83a9ea167',\n",
              "       ...\n",
              "       '00dba5599', 'a16b60c44', 'dac782c74', '161572520', 'b2fe3eca7',\n",
              "       '29d24570f', 'c0521523c', '7226e2204', 'fb8a93a83', 'd778ccd51'],\n",
              "      dtype='object', length=3288)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 270
        },
        "id": "YHFRBgEqWLvG",
        "outputId": "c38c5114-1b49-43b7-ea87-7aae94891309"
      },
      "source": [
        "dados_selec_compostos = pd.merge(dados_combinados, dados_resultados, on='id').query(\"composto in @ compostos\")\n",
        "dados_selec_compostos.head()"
      ],
      "execution_count": 12,
      "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>composto</th>\n",
              "      <th>g0</th>\n",
              "      <th>g1</th>\n",
              "      <th>g2</th>\n",
              "      <th>g3</th>\n",
              "      <th>g4</th>\n",
              "      <th>g5</th>\n",
              "      <th>g6</th>\n",
              "      <th>g7</th>\n",
              "      <th>g8</th>\n",
              "      <th>g9</th>\n",
              "      <th>g10</th>\n",
              "      <th>g11</th>\n",
              "      <th>g12</th>\n",
              "      <th>g13</th>\n",
              "      <th>g14</th>\n",
              "      <th>g15</th>\n",
              "      <th>g16</th>\n",
              "      <th>g17</th>\n",
              "      <th>g18</th>\n",
              "      <th>g19</th>\n",
              "      <th>g20</th>\n",
              "      <th>g21</th>\n",
              "      <th>g22</th>\n",
              "      <th>g23</th>\n",
              "      <th>g24</th>\n",
              "      <th>g25</th>\n",
              "      <th>g26</th>\n",
              "      <th>g27</th>\n",
              "      <th>g28</th>\n",
              "      <th>g29</th>\n",
              "      <th>g30</th>\n",
              "      <th>g31</th>\n",
              "      <th>g32</th>\n",
              "      <th>g33</th>\n",
              "      <th>g34</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_y</th>\n",
              "      <th>ativo_moa_y</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</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>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>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</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>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>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</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>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>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>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>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>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</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>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 × 1091 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "             id tratamento  tempo  ... wnt_inhibitor n_moa_y  ativo_moa_y\n",
              "0  id_000644bb2  com_droga     24  ...             0       1         True\n",
              "1  id_000779bfc  com_droga     72  ...             0       0        False\n",
              "2  id_000a6266a  com_droga     48  ...             0       3         True\n",
              "3  id_0015fd391  com_droga     48  ...             0       0        False\n",
              "4  id_001626bd3  com_droga     72  ...             0       1         True\n",
              "\n",
              "[5 rows x 1091 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 12
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "eVlG_62OX49E",
        "outputId": "41f51176-70a0-4909-9acc-2ba7b451780b"
      },
      "source": [
        "activated_moas = [moa for moa in unique_moas if dados_selec_compostos[unique_moas].any()[moa]]\n",
        "print(activated_moas)\n",
        "print(f\"Foram ativados {len(activated_moas)} moas\")"
      ],
      "execution_count": 13,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "['5-alpha_reductase_inhibitor', '11-beta-hsd1_inhibitor', 'acat_inhibitor', 'acetylcholine_receptor_agonist', 'acetylcholine_receptor_antagonist', 'acetylcholinesterase_inhibitor', 'adenosine_receptor_agonist', 'adenosine_receptor_antagonist', 'adenylyl_cyclase_activator', 'adrenergic_receptor_agonist', 'adrenergic_receptor_antagonist', 'akt_inhibitor', 'aldehyde_dehydrogenase_inhibitor', 'alk_inhibitor', 'ampk_activator', 'analgesic', 'androgen_receptor_agonist', 'androgen_receptor_antagonist', 'anesthetic_-_local', 'angiogenesis_inhibitor', 'angiotensin_receptor_antagonist', 'anti-inflammatory', 'antiarrhythmic', 'antibiotic', 'anticonvulsant', 'antifungal', 'antihistamine', 'antimalarial', 'antioxidant', 'antiprotozoal', 'antiviral', 'apoptosis_stimulant', 'aromatase_inhibitor', 'atm_kinase_inhibitor', 'atp-sensitive_potassium_channel_antagonist', 'atp_synthase_inhibitor', 'atpase_inhibitor', 'atr_kinase_inhibitor', 'aurora_kinase_inhibitor', 'autotaxin_inhibitor', 'bacterial_30s_ribosomal_subunit_inhibitor', 'bacterial_50s_ribosomal_subunit_inhibitor', 'bacterial_antifolate', 'bacterial_cell_wall_synthesis_inhibitor', 'bacterial_dna_gyrase_inhibitor', 'bacterial_dna_inhibitor', 'bacterial_membrane_integrity_inhibitor', 'bcl_inhibitor', 'bcr-abl_inhibitor', 'benzodiazepine_receptor_agonist', 'beta_amyloid_inhibitor', 'bromodomain_inhibitor', 'btk_inhibitor', 'calcineurin_inhibitor', 'calcium_channel_blocker', 'cannabinoid_receptor_agonist', 'cannabinoid_receptor_antagonist', 'carbonic_anhydrase_inhibitor', 'casein_kinase_inhibitor', 'caspase_activator', 'catechol_o_methyltransferase_inhibitor', 'cc_chemokine_receptor_antagonist', 'cck_receptor_antagonist', 'cdk_inhibitor', 'chelating_agent', 'chk_inhibitor', 'chloride_channel_blocker', 'cholesterol_inhibitor', 'cholinergic_receptor_antagonist', 'coagulation_factor_inhibitor', 'corticosteroid_agonist', 'cyclooxygenase_inhibitor', 'cytochrome_p450_inhibitor', 'dihydrofolate_reductase_inhibitor', 'dipeptidyl_peptidase_inhibitor', 'diuretic', 'dna_alkylating_agent', 'dna_inhibitor', 'dopamine_receptor_agonist', 'dopamine_receptor_antagonist', 'egfr_inhibitor', 'elastase_inhibitor', 'erbb2_inhibitor', 'estrogen_receptor_agonist', 'estrogen_receptor_antagonist', 'faah_inhibitor', 'farnesyltransferase_inhibitor', 'fatty_acid_receptor_agonist', 'fgfr_inhibitor', 'flt3_inhibitor', 'focal_adhesion_kinase_inhibitor', 'free_radical_scavenger', 'fungal_squalene_epoxidase_inhibitor', 'gaba_receptor_agonist', 'gaba_receptor_antagonist', 'gamma_secretase_inhibitor', 'glucocorticoid_receptor_agonist', 'glutamate_inhibitor', 'glutamate_receptor_agonist', 'glutamate_receptor_antagonist', 'gonadotropin_receptor_agonist', 'gsk_inhibitor', 'hcv_inhibitor', 'hdac_inhibitor', 'histamine_receptor_agonist', 'histamine_receptor_antagonist', 'histone_lysine_demethylase_inhibitor', 'histone_lysine_methyltransferase_inhibitor', 'hiv_inhibitor', 'hmgcr_inhibitor', 'hsp_inhibitor', 'igf-1_inhibitor', 'ikk_inhibitor', 'imidazoline_receptor_agonist', 'immunosuppressant', 'insulin_secretagogue', 'insulin_sensitizer', 'integrin_inhibitor', 'jak_inhibitor', 'kit_inhibitor', 'laxative', 'leukotriene_inhibitor', 'leukotriene_receptor_antagonist', 'lipase_inhibitor', 'lipoxygenase_inhibitor', 'lxr_agonist', 'mdm_inhibitor', 'mek_inhibitor', 'membrane_integrity_inhibitor', 'mineralocorticoid_receptor_antagonist', 'monoacylglycerol_lipase_inhibitor', 'monoamine_oxidase_inhibitor', 'monopolar_spindle_1_kinase_inhibitor', 'mtor_inhibitor', 'mucolytic_agent', 'neuropeptide_receptor_antagonist', 'nfkb_inhibitor', 'nicotinic_receptor_agonist', 'nitric_oxide_donor', 'nitric_oxide_production_inhibitor', 'nitric_oxide_synthase_inhibitor', 'norepinephrine_reuptake_inhibitor', 'nrf2_activator', 'opioid_receptor_agonist', 'opioid_receptor_antagonist', 'orexin_receptor_antagonist', 'p38_mapk_inhibitor', 'p-glycoprotein_inhibitor', 'parp_inhibitor', 'pdgfr_inhibitor', 'pdk_inhibitor', 'phosphodiesterase_inhibitor', 'phospholipase_inhibitor', 'pi3k_inhibitor', 'pkc_inhibitor', 'potassium_channel_activator', 'potassium_channel_antagonist', 'ppar_receptor_agonist', 'ppar_receptor_antagonist', 'progesterone_receptor_agonist', 'progesterone_receptor_antagonist', 'prostaglandin_inhibitor', 'prostanoid_receptor_antagonist', 'proteasome_inhibitor', 'protein_kinase_inhibitor', 'protein_phosphatase_inhibitor', 'protein_synthesis_inhibitor', 'protein_tyrosine_kinase_inhibitor', 'radiopaque_medium', 'raf_inhibitor', 'ras_gtpase_inhibitor', 'retinoid_receptor_agonist', 'retinoid_receptor_antagonist', 'rho_associated_kinase_inhibitor', 'ribonucleoside_reductase_inhibitor', 'rna_polymerase_inhibitor', 'serotonin_receptor_agonist', 'serotonin_receptor_antagonist', 'serotonin_reuptake_inhibitor', 'sigma_receptor_agonist', 'sigma_receptor_antagonist', 'smoothened_receptor_antagonist', 'sodium_channel_inhibitor', 'sphingosine_receptor_agonist', 'src_inhibitor', 'steroid', 'syk_inhibitor', 'tachykinin_antagonist', 'tgf-beta_receptor_inhibitor', 'thrombin_inhibitor', 'thymidylate_synthase_inhibitor', 'tlr_agonist', 'tlr_antagonist', 'tnf_inhibitor', 'topoisomerase_inhibitor', 'transient_receptor_potential_channel_antagonist', 'tropomyosin_receptor_kinase_inhibitor', 'trpv_agonist', 'trpv_antagonist', 'tubulin_inhibitor', 'tyrosine_kinase_inhibitor', 'ubiquitin_specific_protease_inhibitor', 'vegfr_inhibitor', 'vitamin_b', 'vitamin_d_receptor_agonist', 'wnt_inhibitor']\n",
            "Foram ativados 206 moas\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "SH2gjGreZWBc",
        "outputId": "554c051e-a423-4a47-d872-a75abcc7ad2c"
      },
      "source": [
        "_moa_not_active = dados_selec_compostos.query('tubulin_inhibitor == 0')\n",
        "_moa_active = dados_selec_compostos.query('tubulin_inhibitor == 1')\n",
        "print(f\"O moa foi ativado em {len(_moa_active)} experimentos e não ativado em {len(_moa_not_active)}\")\n",
        "print(_moa_active.query('composto == \"d08af5d4b\"').head())\n",
        "print(_moa_not_active.query('composto == \"d08af5d4b\"').head())"
      ],
      "execution_count": 14,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "O moa foi ativado em 316 experimentos e não ativado em 21632\n",
            "               id tratamento  tempo  ... wnt_inhibitor n_moa_y  ativo_moa_y\n",
            "129  id_017652e9a  com_droga     72  ...             0       1         True\n",
            "380  id_041040719  com_droga     24  ...             0       1         True\n",
            "522  id_0565d8be2  com_droga     24  ...             0       1         True\n",
            "608  id_06428d31f  com_droga     24  ...             0       1         True\n",
            "686  id_06ec6d4c8  com_droga     24  ...             0       1         True\n",
            "\n",
            "[5 rows x 1091 columns]\n",
            "Empty DataFrame\n",
            "Columns: [id, tratamento, tempo, dose, composto, g0, g1, g2, g3, g4, g5, g6, g7, g8, g9, g10, g11, g12, g13, g14, g15, g16, g17, g18, g19, g20, g21, g22, g23, g24, g25, g26, g27, g28, g29, g30, g31, g32, g33, g34, g35, g36, g37, g38, g39, g40, g41, g42, g43, g44, g45, g46, g47, g48, g49, g50, g51, g52, g53, g54, g55, g56, g57, g58, g59, g60, g61, g62, g63, g64, g65, g66, g67, g68, g69, g70, g71, g72, g73, g74, g75, g76, g77, g78, g79, g80, g81, g82, g83, g84, g85, g86, g87, g88, g89, g90, g91, g92, g93, g94, ...]\n",
            "Index: []\n",
            "\n",
            "[0 rows x 1091 columns]\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "cbL-bGfzah8T",
        "outputId": "2b7d7051-d844-49f4-a9f7-2c2914d68c96"
      },
      "source": [
        "from tqdm import tqdm\n",
        "\n",
        "history = []\n",
        "for comp in tqdm(compostos, position=0, leave=True):\n",
        "  dados_composto = dados_selec_compostos.query('composto == @comp')\n",
        "  for moa in activated_moas:\n",
        "    moa_active = dados_composto[dados_composto[moa] == 1]\n",
        "    if len(moa_active) == 0:\n",
        "      continue\n",
        "    moa_not_active = dados_composto[dados_composto[moa] == 0]\n",
        "    \n",
        "    configs_not_active = {'dose': moa_not_active['dose'].unique(), 'tempo': moa_not_active['tempo'].unique()}\n",
        "    configs_active = {'dose': moa_active['dose'].unique(), 'tempo': moa_active['tempo'].unique()}\n",
        "    if (len(configs_not_active['dose']) > 0) or (len(configs_not_active['tempo']) > 0):\n",
        "      print(f\"O moa {moa} foi ativado em {len(moa_active)} experimentos para o composto {comp}\")\n",
        "      print(configs_active)\n",
        "      print(configs_not_active)\n",
        "      history.append({'composto': comp, 'moa': moa, 'configs_ativo': configs_active, 'configs_nao_ativo': configs_not_active})\n",
        "      print()"
      ],
      "execution_count": 15,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "100%|██████████| 3288/3288 [09:56<00:00,  5.51it/s]\n"
          ],
          "name": "stderr"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "8meb-TC6xUpw"
      },
      "source": [
        "#Desafio 07: Descobrir se tem algum composto que dependendo da configuração do experimento, ativa MOAs diferentes"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 270
        },
        "id": "GnfKbn4ws_EK",
        "outputId": "8f1c96b5-9f09-4224-97d9-94e0d9dd6319"
      },
      "source": [
        "dados_selec_compostos.head()"
      ],
      "execution_count": 16,
      "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>composto</th>\n",
              "      <th>g0</th>\n",
              "      <th>g1</th>\n",
              "      <th>g2</th>\n",
              "      <th>g3</th>\n",
              "      <th>g4</th>\n",
              "      <th>g5</th>\n",
              "      <th>g6</th>\n",
              "      <th>g7</th>\n",
              "      <th>g8</th>\n",
              "      <th>g9</th>\n",
              "      <th>g10</th>\n",
              "      <th>g11</th>\n",
              "      <th>g12</th>\n",
              "      <th>g13</th>\n",
              "      <th>g14</th>\n",
              "      <th>g15</th>\n",
              "      <th>g16</th>\n",
              "      <th>g17</th>\n",
              "      <th>g18</th>\n",
              "      <th>g19</th>\n",
              "      <th>g20</th>\n",
              "      <th>g21</th>\n",
              "      <th>g22</th>\n",
              "      <th>g23</th>\n",
              "      <th>g24</th>\n",
              "      <th>g25</th>\n",
              "      <th>g26</th>\n",
              "      <th>g27</th>\n",
              "      <th>g28</th>\n",
              "      <th>g29</th>\n",
              "      <th>g30</th>\n",
              "      <th>g31</th>\n",
              "      <th>g32</th>\n",
              "      <th>g33</th>\n",
              "      <th>g34</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_y</th>\n",
              "      <th>ativo_moa_y</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</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>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>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</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>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>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</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>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>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>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>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>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</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>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 × 1091 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "             id tratamento  tempo  ... wnt_inhibitor n_moa_y  ativo_moa_y\n",
              "0  id_000644bb2  com_droga     24  ...             0       1         True\n",
              "1  id_000779bfc  com_droga     72  ...             0       0        False\n",
              "2  id_000a6266a  com_droga     48  ...             0       3         True\n",
              "3  id_0015fd391  com_droga     48  ...             0       0        False\n",
              "4  id_001626bd3  com_droga     72  ...             0       1         True\n",
              "\n",
              "[5 rows x 1091 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 16
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "KGCewyzkxVBH",
        "outputId": "bdfd34cf-cca3-4ff7-9ce7-8522053e5529"
      },
      "source": [
        "res = dados_selec_compostos[['composto', 'tempo', 'dose']+activated_moas].groupby('composto')\n",
        "comp_history = []\n",
        "for name, group in tqdm(res, position=0, leave=True):\n",
        "  df = group.groupby(['tempo', 'dose']).count().to_numpy()\n",
        "  if len(np.unique(df)) > 1:\n",
        "    comp_history.append(name)"
      ],
      "execution_count": 17,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "100%|██████████| 3288/3288 [00:07<00:00, 430.64it/s]\n"
          ],
          "name": "stderr"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "6ayxNJCWyRGf",
        "outputId": "7be28b09-cab8-4aec-8211-366f7d03c2ce"
      },
      "source": [
        "to_analyse = comp_history[3]\n",
        "print(len(comp_history))"
      ],
      "execution_count": 18,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "245\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "2ER5CM7x1yZO"
      },
      "source": [
        "select_comp = dados_selec_compostos.query('composto == @to_analyse')"
      ],
      "execution_count": 19,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "T6OhXM6v2Dfa",
        "outputId": "a56fcc1c-eecf-4c42-cc4c-36ae57509a8e"
      },
      "source": [
        "for comp in tqdm(comp_history, position=0, leave=True):\n",
        "  select_comp = dados_selec_compostos.query('composto == @comp')\n",
        "  analise = select_comp.groupby(['dose', 'tempo'])\n",
        "  current_moas = None\n",
        "  for name, group in analise:\n",
        "    moas = []\n",
        "    for index in group.index:\n",
        "      for moa in unique_moas:\n",
        "        if group.loc[index, moa] > 0:\n",
        "          moas.append(moa)\n",
        "\n",
        "    if (current_moas is not None) and (len(np.array(current_moas)) != len(np.unique(moas))):\n",
        "      print(np.unique(moas))\n",
        "    elif (current_moas is not None) and not (np.array(current_moas) == np.unique(moas)).all():\n",
        "      print(current_moas, np.unique(moas))\n",
        "    current_moas = np.unique(moas)\n",
        "    moas.clear()"
      ],
      "execution_count": 20,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "100%|██████████| 245/245 [00:23<00:00, 10.36it/s]\n"
          ],
          "name": "stderr"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "gOdkkPP8xdUb"
      },
      "source": [
        "#Desafio 08: Resumo do que você aprendeu com os dados"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "whnmo3hQxd1v"
      },
      "source": [
        ""
      ],
      "execution_count": 20,
      "outputs": []
    }
  ]
}