Aula_04.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "authorship_tag": "ABX9TyNFzjhACcto8HzcGPCwwwgC",
      "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/strawndri/imersao-dados-2021/blob/main/Aula_04.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "E1pEeJvp8xfT"
      },
      "source": [
        "### Importação das Bibliotecas"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "MZC52LBb83O6"
      },
      "source": [
        "import pandas as pd\n",
        "import seaborn as sns\n",
        "import matplotlib.pyplot as plt\n",
        "import numpy as np"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "JCetPCZK9PvR"
      },
      "source": [
        "### Importação dos Dados"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 253
        },
        "id": "7yQkZzJDJV17",
        "outputId": "8ecc22ca-19a4-4a5a-dd2e-5da785f6f14c"
      },
      "source": [
        "url_dados = 'https://github.com/alura-cursos/imersaodados3/blob/main/dados/dados_experimentos.zip?raw=true'\n",
        "\n",
        "dados = pd.read_csv(url_dados, compression = 'zip')\n",
        "\n",
        "# modificando a coluna com nome 'droga' para 'composto'\n",
        "mapa = {'droga':'composto'}\n",
        "dados.rename(columns=mapa, inplace=True)\n",
        "dados.head()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>id</th>\n",
              "      <th>tratamento</th>\n",
              "      <th>tempo</th>\n",
              "      <th>dose</th>\n",
              "      <th>composto</th>\n",
              "      <th>g-0</th>\n",
              "      <th>g-1</th>\n",
              "      <th>g-2</th>\n",
              "      <th>g-3</th>\n",
              "      <th>g-4</th>\n",
              "      <th>g-5</th>\n",
              "      <th>g-6</th>\n",
              "      <th>g-7</th>\n",
              "      <th>g-8</th>\n",
              "      <th>g-9</th>\n",
              "      <th>g-10</th>\n",
              "      <th>g-11</th>\n",
              "      <th>g-12</th>\n",
              "      <th>g-13</th>\n",
              "      <th>g-14</th>\n",
              "      <th>g-15</th>\n",
              "      <th>g-16</th>\n",
              "      <th>g-17</th>\n",
              "      <th>g-18</th>\n",
              "      <th>g-19</th>\n",
              "      <th>g-20</th>\n",
              "      <th>g-21</th>\n",
              "      <th>g-22</th>\n",
              "      <th>g-23</th>\n",
              "      <th>g-24</th>\n",
              "      <th>g-25</th>\n",
              "      <th>g-26</th>\n",
              "      <th>g-27</th>\n",
              "      <th>g-28</th>\n",
              "      <th>g-29</th>\n",
              "      <th>g-30</th>\n",
              "      <th>g-31</th>\n",
              "      <th>g-32</th>\n",
              "      <th>g-33</th>\n",
              "      <th>g-34</th>\n",
              "      <th>...</th>\n",
              "      <th>c-60</th>\n",
              "      <th>c-61</th>\n",
              "      <th>c-62</th>\n",
              "      <th>c-63</th>\n",
              "      <th>c-64</th>\n",
              "      <th>c-65</th>\n",
              "      <th>c-66</th>\n",
              "      <th>c-67</th>\n",
              "      <th>c-68</th>\n",
              "      <th>c-69</th>\n",
              "      <th>c-70</th>\n",
              "      <th>c-71</th>\n",
              "      <th>c-72</th>\n",
              "      <th>c-73</th>\n",
              "      <th>c-74</th>\n",
              "      <th>c-75</th>\n",
              "      <th>c-76</th>\n",
              "      <th>c-77</th>\n",
              "      <th>c-78</th>\n",
              "      <th>c-79</th>\n",
              "      <th>c-80</th>\n",
              "      <th>c-81</th>\n",
              "      <th>c-82</th>\n",
              "      <th>c-83</th>\n",
              "      <th>c-84</th>\n",
              "      <th>c-85</th>\n",
              "      <th>c-86</th>\n",
              "      <th>c-87</th>\n",
              "      <th>c-88</th>\n",
              "      <th>c-89</th>\n",
              "      <th>c-90</th>\n",
              "      <th>c-91</th>\n",
              "      <th>c-92</th>\n",
              "      <th>c-93</th>\n",
              "      <th>c-94</th>\n",
              "      <th>c-95</th>\n",
              "      <th>c-96</th>\n",
              "      <th>c-97</th>\n",
              "      <th>c-98</th>\n",
              "      <th>c-99</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>id_000644bb2</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>b68db1d53</td>\n",
              "      <td>1.0620</td>\n",
              "      <td>0.5577</td>\n",
              "      <td>-0.2479</td>\n",
              "      <td>-0.6208</td>\n",
              "      <td>-0.1944</td>\n",
              "      <td>-1.0120</td>\n",
              "      <td>-1.0220</td>\n",
              "      <td>-0.0326</td>\n",
              "      <td>0.5548</td>\n",
              "      <td>-0.0921</td>\n",
              "      <td>1.1830</td>\n",
              "      <td>0.1530</td>\n",
              "      <td>0.5574</td>\n",
              "      <td>-0.4015</td>\n",
              "      <td>0.1789</td>\n",
              "      <td>-0.6528</td>\n",
              "      <td>-0.7969</td>\n",
              "      <td>0.6342</td>\n",
              "      <td>0.1778</td>\n",
              "      <td>-0.3694</td>\n",
              "      <td>-0.5688</td>\n",
              "      <td>-1.1360</td>\n",
              "      <td>-1.1880</td>\n",
              "      <td>0.6940</td>\n",
              "      <td>0.4393</td>\n",
              "      <td>0.2664</td>\n",
              "      <td>0.1907</td>\n",
              "      <td>0.1628</td>\n",
              "      <td>-0.2853</td>\n",
              "      <td>0.5819</td>\n",
              "      <td>0.2934</td>\n",
              "      <td>-0.5584</td>\n",
              "      <td>-0.0916</td>\n",
              "      <td>-0.3010</td>\n",
              "      <td>-0.1537</td>\n",
              "      <td>...</td>\n",
              "      <td>0.4805</td>\n",
              "      <td>0.4965</td>\n",
              "      <td>0.3680</td>\n",
              "      <td>0.8427</td>\n",
              "      <td>0.1042</td>\n",
              "      <td>0.1403</td>\n",
              "      <td>0.1758</td>\n",
              "      <td>1.2570</td>\n",
              "      <td>-0.5979</td>\n",
              "      <td>1.2250</td>\n",
              "      <td>-0.0553</td>\n",
              "      <td>0.7351</td>\n",
              "      <td>0.5810</td>\n",
              "      <td>0.9590</td>\n",
              "      <td>0.2427</td>\n",
              "      <td>0.0495</td>\n",
              "      <td>0.4141</td>\n",
              "      <td>0.8432</td>\n",
              "      <td>0.6162</td>\n",
              "      <td>-0.7318</td>\n",
              "      <td>1.2120</td>\n",
              "      <td>0.6362</td>\n",
              "      <td>-0.4427</td>\n",
              "      <td>0.1288</td>\n",
              "      <td>1.4840</td>\n",
              "      <td>0.1799</td>\n",
              "      <td>0.5367</td>\n",
              "      <td>-0.1111</td>\n",
              "      <td>-1.0120</td>\n",
              "      <td>0.6685</td>\n",
              "      <td>0.2862</td>\n",
              "      <td>0.2584</td>\n",
              "      <td>0.8076</td>\n",
              "      <td>0.5523</td>\n",
              "      <td>-0.1912</td>\n",
              "      <td>0.6584</td>\n",
              "      <td>-0.3981</td>\n",
              "      <td>0.2139</td>\n",
              "      <td>0.3801</td>\n",
              "      <td>0.4176</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>id_000779bfc</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>72</td>\n",
              "      <td>D1</td>\n",
              "      <td>df89a8e5a</td>\n",
              "      <td>0.0743</td>\n",
              "      <td>0.4087</td>\n",
              "      <td>0.2991</td>\n",
              "      <td>0.0604</td>\n",
              "      <td>1.0190</td>\n",
              "      <td>0.5207</td>\n",
              "      <td>0.2341</td>\n",
              "      <td>0.3372</td>\n",
              "      <td>-0.4047</td>\n",
              "      <td>0.8507</td>\n",
              "      <td>-1.1520</td>\n",
              "      <td>-0.4201</td>\n",
              "      <td>-0.0958</td>\n",
              "      <td>0.4590</td>\n",
              "      <td>0.0803</td>\n",
              "      <td>0.2250</td>\n",
              "      <td>0.5293</td>\n",
              "      <td>0.2839</td>\n",
              "      <td>-0.3494</td>\n",
              "      <td>0.2883</td>\n",
              "      <td>0.9449</td>\n",
              "      <td>-0.1646</td>\n",
              "      <td>-0.2657</td>\n",
              "      <td>-0.3372</td>\n",
              "      <td>0.3135</td>\n",
              "      <td>-0.4316</td>\n",
              "      <td>0.4773</td>\n",
              "      <td>0.2075</td>\n",
              "      <td>-0.4216</td>\n",
              "      <td>-0.1161</td>\n",
              "      <td>-0.0499</td>\n",
              "      <td>-0.2627</td>\n",
              "      <td>0.9959</td>\n",
              "      <td>-0.2483</td>\n",
              "      <td>0.2655</td>\n",
              "      <td>...</td>\n",
              "      <td>0.4083</td>\n",
              "      <td>0.0319</td>\n",
              "      <td>0.3905</td>\n",
              "      <td>0.7099</td>\n",
              "      <td>0.2912</td>\n",
              "      <td>0.4151</td>\n",
              "      <td>-0.2840</td>\n",
              "      <td>-0.3104</td>\n",
              "      <td>-0.6373</td>\n",
              "      <td>0.2887</td>\n",
              "      <td>-0.0765</td>\n",
              "      <td>0.2539</td>\n",
              "      <td>0.4443</td>\n",
              "      <td>0.5932</td>\n",
              "      <td>0.2031</td>\n",
              "      <td>0.7639</td>\n",
              "      <td>0.5499</td>\n",
              "      <td>-0.3322</td>\n",
              "      <td>-0.0977</td>\n",
              "      <td>0.4329</td>\n",
              "      <td>-0.2782</td>\n",
              "      <td>0.7827</td>\n",
              "      <td>0.5934</td>\n",
              "      <td>0.3402</td>\n",
              "      <td>0.1499</td>\n",
              "      <td>0.4420</td>\n",
              "      <td>0.9366</td>\n",
              "      <td>0.8193</td>\n",
              "      <td>-0.4236</td>\n",
              "      <td>0.3192</td>\n",
              "      <td>-0.4265</td>\n",
              "      <td>0.7543</td>\n",
              "      <td>0.4708</td>\n",
              "      <td>0.0230</td>\n",
              "      <td>0.2957</td>\n",
              "      <td>0.4899</td>\n",
              "      <td>0.1522</td>\n",
              "      <td>0.1241</td>\n",
              "      <td>0.6077</td>\n",
              "      <td>0.7371</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>id_000a6266a</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>48</td>\n",
              "      <td>D1</td>\n",
              "      <td>18bb41b2c</td>\n",
              "      <td>0.6280</td>\n",
              "      <td>0.5817</td>\n",
              "      <td>1.5540</td>\n",
              "      <td>-0.0764</td>\n",
              "      <td>-0.0323</td>\n",
              "      <td>1.2390</td>\n",
              "      <td>0.1715</td>\n",
              "      <td>0.2155</td>\n",
              "      <td>0.0065</td>\n",
              "      <td>1.2300</td>\n",
              "      <td>-0.4797</td>\n",
              "      <td>-0.5631</td>\n",
              "      <td>-0.0366</td>\n",
              "      <td>-1.8300</td>\n",
              "      <td>0.6057</td>\n",
              "      <td>-0.3278</td>\n",
              "      <td>0.6042</td>\n",
              "      <td>-0.3075</td>\n",
              "      <td>-0.1147</td>\n",
              "      <td>-0.0570</td>\n",
              "      <td>-0.0799</td>\n",
              "      <td>-0.8181</td>\n",
              "      <td>-1.5320</td>\n",
              "      <td>0.2307</td>\n",
              "      <td>0.4901</td>\n",
              "      <td>0.4780</td>\n",
              "      <td>-1.3970</td>\n",
              "      <td>4.6240</td>\n",
              "      <td>-0.0437</td>\n",
              "      <td>1.2870</td>\n",
              "      <td>-1.8530</td>\n",
              "      <td>0.6069</td>\n",
              "      <td>0.4290</td>\n",
              "      <td>0.1783</td>\n",
              "      <td>0.0018</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.5477</td>\n",
              "      <td>-0.7576</td>\n",
              "      <td>-0.0444</td>\n",
              "      <td>0.1894</td>\n",
              "      <td>-0.0014</td>\n",
              "      <td>-2.3640</td>\n",
              "      <td>-0.4682</td>\n",
              "      <td>0.1210</td>\n",
              "      <td>-0.5177</td>\n",
              "      <td>-0.0604</td>\n",
              "      <td>0.1682</td>\n",
              "      <td>-0.4436</td>\n",
              "      <td>0.4963</td>\n",
              "      <td>0.1363</td>\n",
              "      <td>0.3335</td>\n",
              "      <td>0.9760</td>\n",
              "      <td>-0.0427</td>\n",
              "      <td>-0.1235</td>\n",
              "      <td>0.0959</td>\n",
              "      <td>0.0690</td>\n",
              "      <td>-0.9416</td>\n",
              "      <td>-0.7548</td>\n",
              "      <td>-0.1109</td>\n",
              "      <td>-0.6272</td>\n",
              "      <td>0.3019</td>\n",
              "      <td>0.1172</td>\n",
              "      <td>0.1093</td>\n",
              "      <td>-0.3113</td>\n",
              "      <td>0.3019</td>\n",
              "      <td>-0.0873</td>\n",
              "      <td>-0.7250</td>\n",
              "      <td>-0.6297</td>\n",
              "      <td>0.6103</td>\n",
              "      <td>0.0223</td>\n",
              "      <td>-1.3240</td>\n",
              "      <td>-0.3174</td>\n",
              "      <td>-0.6417</td>\n",
              "      <td>-0.2187</td>\n",
              "      <td>-1.4080</td>\n",
              "      <td>0.6931</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>id_0015fd391</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>48</td>\n",
              "      <td>D1</td>\n",
              "      <td>8c7f86626</td>\n",
              "      <td>-0.5138</td>\n",
              "      <td>-0.2491</td>\n",
              "      <td>-0.2656</td>\n",
              "      <td>0.5288</td>\n",
              "      <td>4.0620</td>\n",
              "      <td>-0.8095</td>\n",
              "      <td>-1.9590</td>\n",
              "      <td>0.1792</td>\n",
              "      <td>-0.1321</td>\n",
              "      <td>-1.0600</td>\n",
              "      <td>-0.8269</td>\n",
              "      <td>-0.3584</td>\n",
              "      <td>-0.8511</td>\n",
              "      <td>-0.5844</td>\n",
              "      <td>-2.5690</td>\n",
              "      <td>0.8183</td>\n",
              "      <td>-0.0532</td>\n",
              "      <td>-0.8554</td>\n",
              "      <td>0.1160</td>\n",
              "      <td>-2.3520</td>\n",
              "      <td>2.1200</td>\n",
              "      <td>-1.1580</td>\n",
              "      <td>-0.7191</td>\n",
              "      <td>-0.8004</td>\n",
              "      <td>-1.4670</td>\n",
              "      <td>-0.0107</td>\n",
              "      <td>-0.8995</td>\n",
              "      <td>0.2406</td>\n",
              "      <td>-0.2479</td>\n",
              "      <td>-1.0890</td>\n",
              "      <td>-0.7575</td>\n",
              "      <td>0.0881</td>\n",
              "      <td>-2.7370</td>\n",
              "      <td>0.8745</td>\n",
              "      <td>0.5787</td>\n",
              "      <td>...</td>\n",
              "      <td>-2.1220</td>\n",
              "      <td>-0.3752</td>\n",
              "      <td>-2.3820</td>\n",
              "      <td>-3.7350</td>\n",
              "      <td>-2.9740</td>\n",
              "      <td>-1.4930</td>\n",
              "      <td>-1.6600</td>\n",
              "      <td>-3.1660</td>\n",
              "      <td>0.2816</td>\n",
              "      <td>-0.2990</td>\n",
              "      <td>-1.1870</td>\n",
              "      <td>-0.5044</td>\n",
              "      <td>-1.7750</td>\n",
              "      <td>-1.6120</td>\n",
              "      <td>-0.9215</td>\n",
              "      <td>-1.0810</td>\n",
              "      <td>-3.0520</td>\n",
              "      <td>-3.4470</td>\n",
              "      <td>-2.7740</td>\n",
              "      <td>-1.8460</td>\n",
              "      <td>-0.5568</td>\n",
              "      <td>-3.3960</td>\n",
              "      <td>-2.9510</td>\n",
              "      <td>-1.1550</td>\n",
              "      <td>-3.2620</td>\n",
              "      <td>-1.5390</td>\n",
              "      <td>-2.4600</td>\n",
              "      <td>-0.9417</td>\n",
              "      <td>-1.5550</td>\n",
              "      <td>0.2431</td>\n",
              "      <td>-2.0990</td>\n",
              "      <td>-0.6441</td>\n",
              "      <td>-5.6300</td>\n",
              "      <td>-1.3780</td>\n",
              "      <td>-0.8632</td>\n",
              "      <td>-1.2880</td>\n",
              "      <td>-1.6210</td>\n",
              "      <td>-0.8784</td>\n",
              "      <td>-0.3876</td>\n",
              "      <td>-0.8154</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>id_001626bd3</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>72</td>\n",
              "      <td>D2</td>\n",
              "      <td>7cbed3131</td>\n",
              "      <td>-0.3254</td>\n",
              "      <td>-0.4009</td>\n",
              "      <td>0.9700</td>\n",
              "      <td>0.6919</td>\n",
              "      <td>1.4180</td>\n",
              "      <td>-0.8244</td>\n",
              "      <td>-0.2800</td>\n",
              "      <td>-0.1498</td>\n",
              "      <td>-0.8789</td>\n",
              "      <td>0.8630</td>\n",
              "      <td>-0.2219</td>\n",
              "      <td>-0.5121</td>\n",
              "      <td>-0.9577</td>\n",
              "      <td>1.1750</td>\n",
              "      <td>0.2042</td>\n",
              "      <td>0.1970</td>\n",
              "      <td>0.1244</td>\n",
              "      <td>-1.7090</td>\n",
              "      <td>-0.3543</td>\n",
              "      <td>-0.5160</td>\n",
              "      <td>-0.3330</td>\n",
              "      <td>-0.2685</td>\n",
              "      <td>0.7649</td>\n",
              "      <td>0.2057</td>\n",
              "      <td>1.3720</td>\n",
              "      <td>0.6835</td>\n",
              "      <td>0.8056</td>\n",
              "      <td>-0.3754</td>\n",
              "      <td>-1.2090</td>\n",
              "      <td>0.2965</td>\n",
              "      <td>-0.0712</td>\n",
              "      <td>0.6389</td>\n",
              "      <td>0.6674</td>\n",
              "      <td>-0.0783</td>\n",
              "      <td>1.1740</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.2274</td>\n",
              "      <td>0.3215</td>\n",
              "      <td>0.1535</td>\n",
              "      <td>-0.4640</td>\n",
              "      <td>-0.5943</td>\n",
              "      <td>0.3973</td>\n",
              "      <td>0.1500</td>\n",
              "      <td>0.5178</td>\n",
              "      <td>0.5159</td>\n",
              "      <td>0.6091</td>\n",
              "      <td>0.1813</td>\n",
              "      <td>-0.4249</td>\n",
              "      <td>0.7832</td>\n",
              "      <td>0.6529</td>\n",
              "      <td>0.5648</td>\n",
              "      <td>0.4817</td>\n",
              "      <td>0.0587</td>\n",
              "      <td>0.5303</td>\n",
              "      <td>0.6376</td>\n",
              "      <td>-0.3966</td>\n",
              "      <td>-1.4950</td>\n",
              "      <td>-0.9625</td>\n",
              "      <td>-0.0541</td>\n",
              "      <td>0.6273</td>\n",
              "      <td>0.4563</td>\n",
              "      <td>0.0698</td>\n",
              "      <td>0.8134</td>\n",
              "      <td>0.1924</td>\n",
              "      <td>0.6054</td>\n",
              "      <td>-0.1824</td>\n",
              "      <td>0.0042</td>\n",
              "      <td>0.0048</td>\n",
              "      <td>0.6670</td>\n",
              "      <td>1.0690</td>\n",
              "      <td>0.5523</td>\n",
              "      <td>-0.3031</td>\n",
              "      <td>0.1094</td>\n",
              "      <td>0.2885</td>\n",
              "      <td>-0.3786</td>\n",
              "      <td>0.7125</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 877 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "             id tratamento  tempo dose  ...    c-96    c-97    c-98    c-99\n",
              "0  id_000644bb2  com_droga     24   D1  ... -0.3981  0.2139  0.3801  0.4176\n",
              "1  id_000779bfc  com_droga     72   D1  ...  0.1522  0.1241  0.6077  0.7371\n",
              "2  id_000a6266a  com_droga     48   D1  ... -0.6417 -0.2187 -1.4080  0.6931\n",
              "3  id_0015fd391  com_droga     48   D1  ... -1.6210 -0.8784 -0.3876 -0.8154\n",
              "4  id_001626bd3  com_droga     72   D2  ...  0.1094  0.2885 -0.3786  0.7125\n",
              "\n",
              "[5 rows x 877 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 32
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 270
        },
        "id": "mqphbkpsdKMM",
        "outputId": "073d50b8-ae98-4dd1-f3ca-4f5965c3f1bf"
      },
      "source": [
        "url_dados_resultado = 'https://github.com/alura-cursos/imersaodados3/blob/main/dados/dados_resultados.csv?raw=true'\n",
        "\n",
        "dados_resultado = pd.read_csv(url_dados_resultado)\n",
        "dados_resultado.head()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>id</th>\n",
              "      <th>5-alpha_reductase_inhibitor</th>\n",
              "      <th>11-beta-hsd1_inhibitor</th>\n",
              "      <th>acat_inhibitor</th>\n",
              "      <th>acetylcholine_receptor_agonist</th>\n",
              "      <th>acetylcholine_receptor_antagonist</th>\n",
              "      <th>acetylcholinesterase_inhibitor</th>\n",
              "      <th>adenosine_receptor_agonist</th>\n",
              "      <th>adenosine_receptor_antagonist</th>\n",
              "      <th>adenylyl_cyclase_activator</th>\n",
              "      <th>adrenergic_receptor_agonist</th>\n",
              "      <th>adrenergic_receptor_antagonist</th>\n",
              "      <th>akt_inhibitor</th>\n",
              "      <th>aldehyde_dehydrogenase_inhibitor</th>\n",
              "      <th>alk_inhibitor</th>\n",
              "      <th>ampk_activator</th>\n",
              "      <th>analgesic</th>\n",
              "      <th>androgen_receptor_agonist</th>\n",
              "      <th>androgen_receptor_antagonist</th>\n",
              "      <th>anesthetic_-_local</th>\n",
              "      <th>angiogenesis_inhibitor</th>\n",
              "      <th>angiotensin_receptor_antagonist</th>\n",
              "      <th>anti-inflammatory</th>\n",
              "      <th>antiarrhythmic</th>\n",
              "      <th>antibiotic</th>\n",
              "      <th>anticonvulsant</th>\n",
              "      <th>antifungal</th>\n",
              "      <th>antihistamine</th>\n",
              "      <th>antimalarial</th>\n",
              "      <th>antioxidant</th>\n",
              "      <th>antiprotozoal</th>\n",
              "      <th>antiviral</th>\n",
              "      <th>apoptosis_stimulant</th>\n",
              "      <th>aromatase_inhibitor</th>\n",
              "      <th>atm_kinase_inhibitor</th>\n",
              "      <th>atp-sensitive_potassium_channel_antagonist</th>\n",
              "      <th>atp_synthase_inhibitor</th>\n",
              "      <th>atpase_inhibitor</th>\n",
              "      <th>atr_kinase_inhibitor</th>\n",
              "      <th>aurora_kinase_inhibitor</th>\n",
              "      <th>...</th>\n",
              "      <th>protein_synthesis_inhibitor</th>\n",
              "      <th>protein_tyrosine_kinase_inhibitor</th>\n",
              "      <th>radiopaque_medium</th>\n",
              "      <th>raf_inhibitor</th>\n",
              "      <th>ras_gtpase_inhibitor</th>\n",
              "      <th>retinoid_receptor_agonist</th>\n",
              "      <th>retinoid_receptor_antagonist</th>\n",
              "      <th>rho_associated_kinase_inhibitor</th>\n",
              "      <th>ribonucleoside_reductase_inhibitor</th>\n",
              "      <th>rna_polymerase_inhibitor</th>\n",
              "      <th>serotonin_receptor_agonist</th>\n",
              "      <th>serotonin_receptor_antagonist</th>\n",
              "      <th>serotonin_reuptake_inhibitor</th>\n",
              "      <th>sigma_receptor_agonist</th>\n",
              "      <th>sigma_receptor_antagonist</th>\n",
              "      <th>smoothened_receptor_antagonist</th>\n",
              "      <th>sodium_channel_inhibitor</th>\n",
              "      <th>sphingosine_receptor_agonist</th>\n",
              "      <th>src_inhibitor</th>\n",
              "      <th>steroid</th>\n",
              "      <th>syk_inhibitor</th>\n",
              "      <th>tachykinin_antagonist</th>\n",
              "      <th>tgf-beta_receptor_inhibitor</th>\n",
              "      <th>thrombin_inhibitor</th>\n",
              "      <th>thymidylate_synthase_inhibitor</th>\n",
              "      <th>tlr_agonist</th>\n",
              "      <th>tlr_antagonist</th>\n",
              "      <th>tnf_inhibitor</th>\n",
              "      <th>topoisomerase_inhibitor</th>\n",
              "      <th>transient_receptor_potential_channel_antagonist</th>\n",
              "      <th>tropomyosin_receptor_kinase_inhibitor</th>\n",
              "      <th>trpv_agonist</th>\n",
              "      <th>trpv_antagonist</th>\n",
              "      <th>tubulin_inhibitor</th>\n",
              "      <th>tyrosine_kinase_inhibitor</th>\n",
              "      <th>ubiquitin_specific_protease_inhibitor</th>\n",
              "      <th>vegfr_inhibitor</th>\n",
              "      <th>vitamin_b</th>\n",
              "      <th>vitamin_d_receptor_agonist</th>\n",
              "      <th>wnt_inhibitor</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>id_000644bb2</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>id_000779bfc</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>id_000a6266a</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>id_0015fd391</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>id_001626bd3</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 207 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "             id  ...  wnt_inhibitor\n",
              "0  id_000644bb2  ...              0\n",
              "1  id_000779bfc  ...              0\n",
              "2  id_000a6266a  ...              0\n",
              "3  id_0015fd391  ...              0\n",
              "4  id_001626bd3  ...              0\n",
              "\n",
              "[5 rows x 207 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 18
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "PdJeZFt2vwHW",
        "outputId": "bcacdd32-56dd-4881-d1cc-4731c3132d39"
      },
      "source": [
        "dados_resultado['acat_inhibitor'].unique()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array([0, 1])"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 4
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "q4LaCn8rzu_z"
      },
      "source": [
        "### Analisando a quantidade de vezes que os mecanismos de ação forama ativados"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "_fkLLoIFyjzA",
        "outputId": "d9650c2f-6dbc-40d6-abe3-ed4321fc501d"
      },
      "source": [
        "# drop() está ignorando a primeira coluna\n",
        "# sum() está somando o valor de cada coluna\n",
        "# sort_values() esta ordenando os resultados em ordem decrescente\n",
        "contagem_mecanismos_acao = dados_resultado.drop('id', axis=1).sum().sort_values(ascending=False)\n",
        "contagem_mecanismos_acao"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "nfkb_inhibitor                                832\n",
              "proteasome_inhibitor                          726\n",
              "cyclooxygenase_inhibitor                      435\n",
              "dopamine_receptor_antagonist                  424\n",
              "serotonin_receptor_antagonist                 404\n",
              "                                             ... \n",
              "protein_phosphatase_inhibitor                   6\n",
              "autotaxin_inhibitor                             6\n",
              "diuretic                                        6\n",
              "erbb2_inhibitor                                 1\n",
              "atp-sensitive_potassium_channel_antagonist      1\n",
              "Length: 206, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "7O5NqWrJyzvt",
        "outputId": "9a04886a-0c4c-46e8-9187-576ba447c42d"
      },
      "source": [
        "# select_dtypes() seleciona apenas os itens do tipo int (inteiro)\n",
        "contagem_mecanismos_acao = dados_resultado.select_dtypes('int64').sum().sort_values(ascending=False)\n",
        "contagem_mecanismos_acao"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "nfkb_inhibitor                                832\n",
              "proteasome_inhibitor                          726\n",
              "cyclooxygenase_inhibitor                      435\n",
              "dopamine_receptor_antagonist                  424\n",
              "serotonin_receptor_antagonist                 404\n",
              "                                             ... \n",
              "protein_phosphatase_inhibitor                   6\n",
              "autotaxin_inhibitor                             6\n",
              "diuretic                                        6\n",
              "erbb2_inhibitor                                 1\n",
              "atp-sensitive_potassium_channel_antagonist      1\n",
              "Length: 206, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Dw_ywoqP1Vqy"
      },
      "source": [
        "# resultado por linha\n",
        "dados_resultado['n_moa'] = dados_resultado.drop('id', axis=1).sum(axis=1)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 270
        },
        "id": "G90XMUucIDyT",
        "outputId": "51f88e41-ee76-430f-eefb-07233aa9d513"
      },
      "source": [
        "# mostrar se foi ativado ou não\n",
        "dados_resultado['ativo_moa'] = (dados_resultado['n_moa'] != 0)\n",
        "dados_resultado.head()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>id</th>\n",
              "      <th>5-alpha_reductase_inhibitor</th>\n",
              "      <th>11-beta-hsd1_inhibitor</th>\n",
              "      <th>acat_inhibitor</th>\n",
              "      <th>acetylcholine_receptor_agonist</th>\n",
              "      <th>acetylcholine_receptor_antagonist</th>\n",
              "      <th>acetylcholinesterase_inhibitor</th>\n",
              "      <th>adenosine_receptor_agonist</th>\n",
              "      <th>adenosine_receptor_antagonist</th>\n",
              "      <th>adenylyl_cyclase_activator</th>\n",
              "      <th>adrenergic_receptor_agonist</th>\n",
              "      <th>adrenergic_receptor_antagonist</th>\n",
              "      <th>akt_inhibitor</th>\n",
              "      <th>aldehyde_dehydrogenase_inhibitor</th>\n",
              "      <th>alk_inhibitor</th>\n",
              "      <th>ampk_activator</th>\n",
              "      <th>analgesic</th>\n",
              "      <th>androgen_receptor_agonist</th>\n",
              "      <th>androgen_receptor_antagonist</th>\n",
              "      <th>anesthetic_-_local</th>\n",
              "      <th>angiogenesis_inhibitor</th>\n",
              "      <th>angiotensin_receptor_antagonist</th>\n",
              "      <th>anti-inflammatory</th>\n",
              "      <th>antiarrhythmic</th>\n",
              "      <th>antibiotic</th>\n",
              "      <th>anticonvulsant</th>\n",
              "      <th>antifungal</th>\n",
              "      <th>antihistamine</th>\n",
              "      <th>antimalarial</th>\n",
              "      <th>antioxidant</th>\n",
              "      <th>antiprotozoal</th>\n",
              "      <th>antiviral</th>\n",
              "      <th>apoptosis_stimulant</th>\n",
              "      <th>aromatase_inhibitor</th>\n",
              "      <th>atm_kinase_inhibitor</th>\n",
              "      <th>atp-sensitive_potassium_channel_antagonist</th>\n",
              "      <th>atp_synthase_inhibitor</th>\n",
              "      <th>atpase_inhibitor</th>\n",
              "      <th>atr_kinase_inhibitor</th>\n",
              "      <th>aurora_kinase_inhibitor</th>\n",
              "      <th>...</th>\n",
              "      <th>radiopaque_medium</th>\n",
              "      <th>raf_inhibitor</th>\n",
              "      <th>ras_gtpase_inhibitor</th>\n",
              "      <th>retinoid_receptor_agonist</th>\n",
              "      <th>retinoid_receptor_antagonist</th>\n",
              "      <th>rho_associated_kinase_inhibitor</th>\n",
              "      <th>ribonucleoside_reductase_inhibitor</th>\n",
              "      <th>rna_polymerase_inhibitor</th>\n",
              "      <th>serotonin_receptor_agonist</th>\n",
              "      <th>serotonin_receptor_antagonist</th>\n",
              "      <th>serotonin_reuptake_inhibitor</th>\n",
              "      <th>sigma_receptor_agonist</th>\n",
              "      <th>sigma_receptor_antagonist</th>\n",
              "      <th>smoothened_receptor_antagonist</th>\n",
              "      <th>sodium_channel_inhibitor</th>\n",
              "      <th>sphingosine_receptor_agonist</th>\n",
              "      <th>src_inhibitor</th>\n",
              "      <th>steroid</th>\n",
              "      <th>syk_inhibitor</th>\n",
              "      <th>tachykinin_antagonist</th>\n",
              "      <th>tgf-beta_receptor_inhibitor</th>\n",
              "      <th>thrombin_inhibitor</th>\n",
              "      <th>thymidylate_synthase_inhibitor</th>\n",
              "      <th>tlr_agonist</th>\n",
              "      <th>tlr_antagonist</th>\n",
              "      <th>tnf_inhibitor</th>\n",
              "      <th>topoisomerase_inhibitor</th>\n",
              "      <th>transient_receptor_potential_channel_antagonist</th>\n",
              "      <th>tropomyosin_receptor_kinase_inhibitor</th>\n",
              "      <th>trpv_agonist</th>\n",
              "      <th>trpv_antagonist</th>\n",
              "      <th>tubulin_inhibitor</th>\n",
              "      <th>tyrosine_kinase_inhibitor</th>\n",
              "      <th>ubiquitin_specific_protease_inhibitor</th>\n",
              "      <th>vegfr_inhibitor</th>\n",
              "      <th>vitamin_b</th>\n",
              "      <th>vitamin_d_receptor_agonist</th>\n",
              "      <th>wnt_inhibitor</th>\n",
              "      <th>n_moa</th>\n",
              "      <th>ativo_moa</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>id_000644bb2</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>id_000779bfc</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>id_000a6266a</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>3</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>id_0015fd391</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>id_001626bd3</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 209 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "             id  5-alpha_reductase_inhibitor  ...  n_moa  ativo_moa\n",
              "0  id_000644bb2                            0  ...      1       True\n",
              "1  id_000779bfc                            0  ...      0      False\n",
              "2  id_000a6266a                            0  ...      3       True\n",
              "3  id_0015fd391                            0  ...      0      False\n",
              "4  id_001626bd3                            0  ...      1       True\n",
              "\n",
              "[5 rows x 209 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 21
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Xk-5bigDJw71"
      },
      "source": [
        "### Combinando Dados (experimento e resultado)"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 253
        },
        "id": "-ZPOQAE7J6vu",
        "outputId": "c3b47040-98af-4664-cc63-a040df723db2"
      },
      "source": [
        "dados_combinados = pd.merge(dados, dados_resultado[['id','n_moa','ativo_moa']], on='id')\n",
        "dados_combinados.head()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>id</th>\n",
              "      <th>tratamento</th>\n",
              "      <th>tempo</th>\n",
              "      <th>dose</th>\n",
              "      <th>composto</th>\n",
              "      <th>g-0</th>\n",
              "      <th>g-1</th>\n",
              "      <th>g-2</th>\n",
              "      <th>g-3</th>\n",
              "      <th>g-4</th>\n",
              "      <th>g-5</th>\n",
              "      <th>g-6</th>\n",
              "      <th>g-7</th>\n",
              "      <th>g-8</th>\n",
              "      <th>g-9</th>\n",
              "      <th>g-10</th>\n",
              "      <th>g-11</th>\n",
              "      <th>g-12</th>\n",
              "      <th>g-13</th>\n",
              "      <th>g-14</th>\n",
              "      <th>g-15</th>\n",
              "      <th>g-16</th>\n",
              "      <th>g-17</th>\n",
              "      <th>g-18</th>\n",
              "      <th>g-19</th>\n",
              "      <th>g-20</th>\n",
              "      <th>g-21</th>\n",
              "      <th>g-22</th>\n",
              "      <th>g-23</th>\n",
              "      <th>g-24</th>\n",
              "      <th>g-25</th>\n",
              "      <th>g-26</th>\n",
              "      <th>g-27</th>\n",
              "      <th>g-28</th>\n",
              "      <th>g-29</th>\n",
              "      <th>g-30</th>\n",
              "      <th>g-31</th>\n",
              "      <th>g-32</th>\n",
              "      <th>g-33</th>\n",
              "      <th>g-34</th>\n",
              "      <th>...</th>\n",
              "      <th>c-62</th>\n",
              "      <th>c-63</th>\n",
              "      <th>c-64</th>\n",
              "      <th>c-65</th>\n",
              "      <th>c-66</th>\n",
              "      <th>c-67</th>\n",
              "      <th>c-68</th>\n",
              "      <th>c-69</th>\n",
              "      <th>c-70</th>\n",
              "      <th>c-71</th>\n",
              "      <th>c-72</th>\n",
              "      <th>c-73</th>\n",
              "      <th>c-74</th>\n",
              "      <th>c-75</th>\n",
              "      <th>c-76</th>\n",
              "      <th>c-77</th>\n",
              "      <th>c-78</th>\n",
              "      <th>c-79</th>\n",
              "      <th>c-80</th>\n",
              "      <th>c-81</th>\n",
              "      <th>c-82</th>\n",
              "      <th>c-83</th>\n",
              "      <th>c-84</th>\n",
              "      <th>c-85</th>\n",
              "      <th>c-86</th>\n",
              "      <th>c-87</th>\n",
              "      <th>c-88</th>\n",
              "      <th>c-89</th>\n",
              "      <th>c-90</th>\n",
              "      <th>c-91</th>\n",
              "      <th>c-92</th>\n",
              "      <th>c-93</th>\n",
              "      <th>c-94</th>\n",
              "      <th>c-95</th>\n",
              "      <th>c-96</th>\n",
              "      <th>c-97</th>\n",
              "      <th>c-98</th>\n",
              "      <th>c-99</th>\n",
              "      <th>n_moa</th>\n",
              "      <th>ativo_moa</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>id_000644bb2</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>b68db1d53</td>\n",
              "      <td>1.0620</td>\n",
              "      <td>0.5577</td>\n",
              "      <td>-0.2479</td>\n",
              "      <td>-0.6208</td>\n",
              "      <td>-0.1944</td>\n",
              "      <td>-1.0120</td>\n",
              "      <td>-1.0220</td>\n",
              "      <td>-0.0326</td>\n",
              "      <td>0.5548</td>\n",
              "      <td>-0.0921</td>\n",
              "      <td>1.1830</td>\n",
              "      <td>0.1530</td>\n",
              "      <td>0.5574</td>\n",
              "      <td>-0.4015</td>\n",
              "      <td>0.1789</td>\n",
              "      <td>-0.6528</td>\n",
              "      <td>-0.7969</td>\n",
              "      <td>0.6342</td>\n",
              "      <td>0.1778</td>\n",
              "      <td>-0.3694</td>\n",
              "      <td>-0.5688</td>\n",
              "      <td>-1.1360</td>\n",
              "      <td>-1.1880</td>\n",
              "      <td>0.6940</td>\n",
              "      <td>0.4393</td>\n",
              "      <td>0.2664</td>\n",
              "      <td>0.1907</td>\n",
              "      <td>0.1628</td>\n",
              "      <td>-0.2853</td>\n",
              "      <td>0.5819</td>\n",
              "      <td>0.2934</td>\n",
              "      <td>-0.5584</td>\n",
              "      <td>-0.0916</td>\n",
              "      <td>-0.3010</td>\n",
              "      <td>-0.1537</td>\n",
              "      <td>...</td>\n",
              "      <td>0.3680</td>\n",
              "      <td>0.8427</td>\n",
              "      <td>0.1042</td>\n",
              "      <td>0.1403</td>\n",
              "      <td>0.1758</td>\n",
              "      <td>1.2570</td>\n",
              "      <td>-0.5979</td>\n",
              "      <td>1.2250</td>\n",
              "      <td>-0.0553</td>\n",
              "      <td>0.7351</td>\n",
              "      <td>0.5810</td>\n",
              "      <td>0.9590</td>\n",
              "      <td>0.2427</td>\n",
              "      <td>0.0495</td>\n",
              "      <td>0.4141</td>\n",
              "      <td>0.8432</td>\n",
              "      <td>0.6162</td>\n",
              "      <td>-0.7318</td>\n",
              "      <td>1.2120</td>\n",
              "      <td>0.6362</td>\n",
              "      <td>-0.4427</td>\n",
              "      <td>0.1288</td>\n",
              "      <td>1.4840</td>\n",
              "      <td>0.1799</td>\n",
              "      <td>0.5367</td>\n",
              "      <td>-0.1111</td>\n",
              "      <td>-1.0120</td>\n",
              "      <td>0.6685</td>\n",
              "      <td>0.2862</td>\n",
              "      <td>0.2584</td>\n",
              "      <td>0.8076</td>\n",
              "      <td>0.5523</td>\n",
              "      <td>-0.1912</td>\n",
              "      <td>0.6584</td>\n",
              "      <td>-0.3981</td>\n",
              "      <td>0.2139</td>\n",
              "      <td>0.3801</td>\n",
              "      <td>0.4176</td>\n",
              "      <td>1</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>id_000779bfc</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>72</td>\n",
              "      <td>D1</td>\n",
              "      <td>df89a8e5a</td>\n",
              "      <td>0.0743</td>\n",
              "      <td>0.4087</td>\n",
              "      <td>0.2991</td>\n",
              "      <td>0.0604</td>\n",
              "      <td>1.0190</td>\n",
              "      <td>0.5207</td>\n",
              "      <td>0.2341</td>\n",
              "      <td>0.3372</td>\n",
              "      <td>-0.4047</td>\n",
              "      <td>0.8507</td>\n",
              "      <td>-1.1520</td>\n",
              "      <td>-0.4201</td>\n",
              "      <td>-0.0958</td>\n",
              "      <td>0.4590</td>\n",
              "      <td>0.0803</td>\n",
              "      <td>0.2250</td>\n",
              "      <td>0.5293</td>\n",
              "      <td>0.2839</td>\n",
              "      <td>-0.3494</td>\n",
              "      <td>0.2883</td>\n",
              "      <td>0.9449</td>\n",
              "      <td>-0.1646</td>\n",
              "      <td>-0.2657</td>\n",
              "      <td>-0.3372</td>\n",
              "      <td>0.3135</td>\n",
              "      <td>-0.4316</td>\n",
              "      <td>0.4773</td>\n",
              "      <td>0.2075</td>\n",
              "      <td>-0.4216</td>\n",
              "      <td>-0.1161</td>\n",
              "      <td>-0.0499</td>\n",
              "      <td>-0.2627</td>\n",
              "      <td>0.9959</td>\n",
              "      <td>-0.2483</td>\n",
              "      <td>0.2655</td>\n",
              "      <td>...</td>\n",
              "      <td>0.3905</td>\n",
              "      <td>0.7099</td>\n",
              "      <td>0.2912</td>\n",
              "      <td>0.4151</td>\n",
              "      <td>-0.2840</td>\n",
              "      <td>-0.3104</td>\n",
              "      <td>-0.6373</td>\n",
              "      <td>0.2887</td>\n",
              "      <td>-0.0765</td>\n",
              "      <td>0.2539</td>\n",
              "      <td>0.4443</td>\n",
              "      <td>0.5932</td>\n",
              "      <td>0.2031</td>\n",
              "      <td>0.7639</td>\n",
              "      <td>0.5499</td>\n",
              "      <td>-0.3322</td>\n",
              "      <td>-0.0977</td>\n",
              "      <td>0.4329</td>\n",
              "      <td>-0.2782</td>\n",
              "      <td>0.7827</td>\n",
              "      <td>0.5934</td>\n",
              "      <td>0.3402</td>\n",
              "      <td>0.1499</td>\n",
              "      <td>0.4420</td>\n",
              "      <td>0.9366</td>\n",
              "      <td>0.8193</td>\n",
              "      <td>-0.4236</td>\n",
              "      <td>0.3192</td>\n",
              "      <td>-0.4265</td>\n",
              "      <td>0.7543</td>\n",
              "      <td>0.4708</td>\n",
              "      <td>0.0230</td>\n",
              "      <td>0.2957</td>\n",
              "      <td>0.4899</td>\n",
              "      <td>0.1522</td>\n",
              "      <td>0.1241</td>\n",
              "      <td>0.6077</td>\n",
              "      <td>0.7371</td>\n",
              "      <td>0</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>id_000a6266a</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>48</td>\n",
              "      <td>D1</td>\n",
              "      <td>18bb41b2c</td>\n",
              "      <td>0.6280</td>\n",
              "      <td>0.5817</td>\n",
              "      <td>1.5540</td>\n",
              "      <td>-0.0764</td>\n",
              "      <td>-0.0323</td>\n",
              "      <td>1.2390</td>\n",
              "      <td>0.1715</td>\n",
              "      <td>0.2155</td>\n",
              "      <td>0.0065</td>\n",
              "      <td>1.2300</td>\n",
              "      <td>-0.4797</td>\n",
              "      <td>-0.5631</td>\n",
              "      <td>-0.0366</td>\n",
              "      <td>-1.8300</td>\n",
              "      <td>0.6057</td>\n",
              "      <td>-0.3278</td>\n",
              "      <td>0.6042</td>\n",
              "      <td>-0.3075</td>\n",
              "      <td>-0.1147</td>\n",
              "      <td>-0.0570</td>\n",
              "      <td>-0.0799</td>\n",
              "      <td>-0.8181</td>\n",
              "      <td>-1.5320</td>\n",
              "      <td>0.2307</td>\n",
              "      <td>0.4901</td>\n",
              "      <td>0.4780</td>\n",
              "      <td>-1.3970</td>\n",
              "      <td>4.6240</td>\n",
              "      <td>-0.0437</td>\n",
              "      <td>1.2870</td>\n",
              "      <td>-1.8530</td>\n",
              "      <td>0.6069</td>\n",
              "      <td>0.4290</td>\n",
              "      <td>0.1783</td>\n",
              "      <td>0.0018</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.0444</td>\n",
              "      <td>0.1894</td>\n",
              "      <td>-0.0014</td>\n",
              "      <td>-2.3640</td>\n",
              "      <td>-0.4682</td>\n",
              "      <td>0.1210</td>\n",
              "      <td>-0.5177</td>\n",
              "      <td>-0.0604</td>\n",
              "      <td>0.1682</td>\n",
              "      <td>-0.4436</td>\n",
              "      <td>0.4963</td>\n",
              "      <td>0.1363</td>\n",
              "      <td>0.3335</td>\n",
              "      <td>0.9760</td>\n",
              "      <td>-0.0427</td>\n",
              "      <td>-0.1235</td>\n",
              "      <td>0.0959</td>\n",
              "      <td>0.0690</td>\n",
              "      <td>-0.9416</td>\n",
              "      <td>-0.7548</td>\n",
              "      <td>-0.1109</td>\n",
              "      <td>-0.6272</td>\n",
              "      <td>0.3019</td>\n",
              "      <td>0.1172</td>\n",
              "      <td>0.1093</td>\n",
              "      <td>-0.3113</td>\n",
              "      <td>0.3019</td>\n",
              "      <td>-0.0873</td>\n",
              "      <td>-0.7250</td>\n",
              "      <td>-0.6297</td>\n",
              "      <td>0.6103</td>\n",
              "      <td>0.0223</td>\n",
              "      <td>-1.3240</td>\n",
              "      <td>-0.3174</td>\n",
              "      <td>-0.6417</td>\n",
              "      <td>-0.2187</td>\n",
              "      <td>-1.4080</td>\n",
              "      <td>0.6931</td>\n",
              "      <td>3</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>id_0015fd391</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>48</td>\n",
              "      <td>D1</td>\n",
              "      <td>8c7f86626</td>\n",
              "      <td>-0.5138</td>\n",
              "      <td>-0.2491</td>\n",
              "      <td>-0.2656</td>\n",
              "      <td>0.5288</td>\n",
              "      <td>4.0620</td>\n",
              "      <td>-0.8095</td>\n",
              "      <td>-1.9590</td>\n",
              "      <td>0.1792</td>\n",
              "      <td>-0.1321</td>\n",
              "      <td>-1.0600</td>\n",
              "      <td>-0.8269</td>\n",
              "      <td>-0.3584</td>\n",
              "      <td>-0.8511</td>\n",
              "      <td>-0.5844</td>\n",
              "      <td>-2.5690</td>\n",
              "      <td>0.8183</td>\n",
              "      <td>-0.0532</td>\n",
              "      <td>-0.8554</td>\n",
              "      <td>0.1160</td>\n",
              "      <td>-2.3520</td>\n",
              "      <td>2.1200</td>\n",
              "      <td>-1.1580</td>\n",
              "      <td>-0.7191</td>\n",
              "      <td>-0.8004</td>\n",
              "      <td>-1.4670</td>\n",
              "      <td>-0.0107</td>\n",
              "      <td>-0.8995</td>\n",
              "      <td>0.2406</td>\n",
              "      <td>-0.2479</td>\n",
              "      <td>-1.0890</td>\n",
              "      <td>-0.7575</td>\n",
              "      <td>0.0881</td>\n",
              "      <td>-2.7370</td>\n",
              "      <td>0.8745</td>\n",
              "      <td>0.5787</td>\n",
              "      <td>...</td>\n",
              "      <td>-2.3820</td>\n",
              "      <td>-3.7350</td>\n",
              "      <td>-2.9740</td>\n",
              "      <td>-1.4930</td>\n",
              "      <td>-1.6600</td>\n",
              "      <td>-3.1660</td>\n",
              "      <td>0.2816</td>\n",
              "      <td>-0.2990</td>\n",
              "      <td>-1.1870</td>\n",
              "      <td>-0.5044</td>\n",
              "      <td>-1.7750</td>\n",
              "      <td>-1.6120</td>\n",
              "      <td>-0.9215</td>\n",
              "      <td>-1.0810</td>\n",
              "      <td>-3.0520</td>\n",
              "      <td>-3.4470</td>\n",
              "      <td>-2.7740</td>\n",
              "      <td>-1.8460</td>\n",
              "      <td>-0.5568</td>\n",
              "      <td>-3.3960</td>\n",
              "      <td>-2.9510</td>\n",
              "      <td>-1.1550</td>\n",
              "      <td>-3.2620</td>\n",
              "      <td>-1.5390</td>\n",
              "      <td>-2.4600</td>\n",
              "      <td>-0.9417</td>\n",
              "      <td>-1.5550</td>\n",
              "      <td>0.2431</td>\n",
              "      <td>-2.0990</td>\n",
              "      <td>-0.6441</td>\n",
              "      <td>-5.6300</td>\n",
              "      <td>-1.3780</td>\n",
              "      <td>-0.8632</td>\n",
              "      <td>-1.2880</td>\n",
              "      <td>-1.6210</td>\n",
              "      <td>-0.8784</td>\n",
              "      <td>-0.3876</td>\n",
              "      <td>-0.8154</td>\n",
              "      <td>0</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>id_001626bd3</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>72</td>\n",
              "      <td>D2</td>\n",
              "      <td>7cbed3131</td>\n",
              "      <td>-0.3254</td>\n",
              "      <td>-0.4009</td>\n",
              "      <td>0.9700</td>\n",
              "      <td>0.6919</td>\n",
              "      <td>1.4180</td>\n",
              "      <td>-0.8244</td>\n",
              "      <td>-0.2800</td>\n",
              "      <td>-0.1498</td>\n",
              "      <td>-0.8789</td>\n",
              "      <td>0.8630</td>\n",
              "      <td>-0.2219</td>\n",
              "      <td>-0.5121</td>\n",
              "      <td>-0.9577</td>\n",
              "      <td>1.1750</td>\n",
              "      <td>0.2042</td>\n",
              "      <td>0.1970</td>\n",
              "      <td>0.1244</td>\n",
              "      <td>-1.7090</td>\n",
              "      <td>-0.3543</td>\n",
              "      <td>-0.5160</td>\n",
              "      <td>-0.3330</td>\n",
              "      <td>-0.2685</td>\n",
              "      <td>0.7649</td>\n",
              "      <td>0.2057</td>\n",
              "      <td>1.3720</td>\n",
              "      <td>0.6835</td>\n",
              "      <td>0.8056</td>\n",
              "      <td>-0.3754</td>\n",
              "      <td>-1.2090</td>\n",
              "      <td>0.2965</td>\n",
              "      <td>-0.0712</td>\n",
              "      <td>0.6389</td>\n",
              "      <td>0.6674</td>\n",
              "      <td>-0.0783</td>\n",
              "      <td>1.1740</td>\n",
              "      <td>...</td>\n",
              "      <td>0.1535</td>\n",
              "      <td>-0.4640</td>\n",
              "      <td>-0.5943</td>\n",
              "      <td>0.3973</td>\n",
              "      <td>0.1500</td>\n",
              "      <td>0.5178</td>\n",
              "      <td>0.5159</td>\n",
              "      <td>0.6091</td>\n",
              "      <td>0.1813</td>\n",
              "      <td>-0.4249</td>\n",
              "      <td>0.7832</td>\n",
              "      <td>0.6529</td>\n",
              "      <td>0.5648</td>\n",
              "      <td>0.4817</td>\n",
              "      <td>0.0587</td>\n",
              "      <td>0.5303</td>\n",
              "      <td>0.6376</td>\n",
              "      <td>-0.3966</td>\n",
              "      <td>-1.4950</td>\n",
              "      <td>-0.9625</td>\n",
              "      <td>-0.0541</td>\n",
              "      <td>0.6273</td>\n",
              "      <td>0.4563</td>\n",
              "      <td>0.0698</td>\n",
              "      <td>0.8134</td>\n",
              "      <td>0.1924</td>\n",
              "      <td>0.6054</td>\n",
              "      <td>-0.1824</td>\n",
              "      <td>0.0042</td>\n",
              "      <td>0.0048</td>\n",
              "      <td>0.6670</td>\n",
              "      <td>1.0690</td>\n",
              "      <td>0.5523</td>\n",
              "      <td>-0.3031</td>\n",
              "      <td>0.1094</td>\n",
              "      <td>0.2885</td>\n",
              "      <td>-0.3786</td>\n",
              "      <td>0.7125</td>\n",
              "      <td>1</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 879 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "             id tratamento  tempo dose  ...    c-98    c-99  n_moa  ativo_moa\n",
              "0  id_000644bb2  com_droga     24   D1  ...  0.3801  0.4176      1       True\n",
              "1  id_000779bfc  com_droga     72   D1  ...  0.6077  0.7371      0      False\n",
              "2  id_000a6266a  com_droga     48   D1  ... -1.4080  0.6931      3       True\n",
              "3  id_0015fd391  com_droga     48   D1  ... -0.3876 -0.8154      0      False\n",
              "4  id_001626bd3  com_droga     72   D2  ... -0.3786  0.7125      1       True\n",
              "\n",
              "[5 rows x 879 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 33
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "oTnjWhVhK-BU",
        "outputId": "ab966245-6473-4c1f-a738-28823255f8af"
      },
      "source": [
        "# analisando se houve a ativação de algum mecanismo de ação apenas com controle (tratamento)\n",
        "# nenhum mecanismo de ação foi ativado\n",
        "dados_combinados.query('tratamento == \"com_controle\"')['ativo_moa']"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "25       False\n",
              "38       False\n",
              "40       False\n",
              "47       False\n",
              "63       False\n",
              "         ...  \n",
              "23729    False\n",
              "23747    False\n",
              "23768    False\n",
              "23793    False\n",
              "23811    False\n",
              "Name: ativo_moa, Length: 1866, dtype: bool"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 25
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "tStkfRAGMmni",
        "outputId": "e35d63d8-b6c9-464a-b8a3-f46635efeb61"
      },
      "source": [
        "# analisando se houve a ativação de mecanismos de ação na utilização de algum composto\n",
        "# 14447 foram ativados\n",
        "# 7501 não foram ativados\n",
        "dados_combinados.query('tratamento == \"com_droga\"')['ativo_moa'].value_counts()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "True     14447\n",
              "False     7501\n",
              "Name: ativo_moa, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 29
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "V1KtSBugO2G7"
      },
      "source": [
        "# armazenando em uma variável os 5 principais compostos\n",
        "compostos_principais = dados_combinados['composto'].value_counts().index[:5]"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 351
        },
        "id": "Nq4CEUplPQ7S",
        "outputId": "56405e69-ee4d-4ca0-f53e-54dbd9383fda"
      },
      "source": [
        "plt.figure(figsize=[10,5])\n",
        "sns.boxplot( data = dados_combinados.query('composto in @compostos_principais'), y='g-0', x='composto', hue='ativo_moa')"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7fe2237f53d0>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 45
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAmAAAAE9CAYAAACsk95kAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3de7xVdZ34/9f7nIOAoqZbtAIJC1NTFBWT8pIJ6GlmGu1bfbUsDjYN1XwDumc289V++bWaZmwAZyrqO4pFl8mym99QIPBSWgEiqDh6KjDwhsdSkYsczuf3x1oHD8dzA/bZa+/D6/l47Ad7rfXZn/U+67P34r0+a63PipQSkiRJqpy6ogOQJEna15iASZIkVZgJmCRJUoWZgEmSJFWYCZgkSVKFmYBJkiRVWEPRAeyOww47LI0ePbroMCRJknq1fPnyp1JKw7taVlMJ2OjRo1m2bFnRYUiSJPUqItZ1t8xTkJIkSRVmAiZJklRhJmCSJEkVVlPXgEmSpOq3fft21q9fz9atW4sOpSKGDBnCyJEjGTRoUJ8/YwImSZLKav369Rx44IGMHj2aiCg6nH6VUqKlpYX169dz1FFH9flznoKUJElltXXrVkql0oBPvgAiglKptNu9fSZgkiSp7PaF5Kvdnvyt/Z6ARcR/RsSTEXFfh3mHRsTCiHg4//eQ/o5DkiSpWlSiB+x6oLHTvMuAxSmlo4HF+bQkSdrHXH311btMv/GNbywoksqKlFL/ryRiNPDzlNIJ+fR/A+eklB6LiFcAS1NKx/RWz/jx45Mj4avWzZkzh+bm5j6V3bBhAwAjRozoU/kxY8Ywffr0PY5NksphzZo1HHfccX0qO2zYMDZt2tTPEfW/rv7miFieUhrfVfmirgE7IqX0WP7+ceCI7gpGxLSIWBYRyzZu3FiZ6KQqsWXLFrZs2VJ0GJJUFhdeeCGnnnoqxx9/PHPnzuWyyy5jy5YtjBs3jksuuQTIEjKAiy++mJtvvnnnZ6dOncqNN97I1q1bufTSSxk7diwnn3wyS5Ys6XZ9119/PRdeeCGTJ09m9OjRXHvttVxzzTWcfPLJTJgwgaeffhqAlStXMmHCBE488UTe9ra38ec//xmAb3zjG5x22mmcdNJJvP3tb2fz5s3l2xgppX5/AaOB+zpM/6XT8j/3pZ5TTz01SfuSGTNmpBkzZhQdhiTtlgceeKDL+S0tLSmllDZv3pyOP/749NRTT6UDDjhglzLt0z/60Y/SlClTUkopbdu2LY0cOTJt3rw5/cu//Eu69NJLU0oprVmzJh155JFpy5YtXa7vuuuuS695zWvSs88+m5588sl00EEHpa9+9asppZQ+8pGPpK985SsppZTGjh2bli5dmlJK6Z/+6Z/SzJkzU0opPfXUUzvr+uxnP5tmz569W38zsCx1k9MU1QP2RH7qkfzfJwuKQ5IkVcjs2bM56aSTmDBhAn/60594+OGHuy37lre8hSVLlrBt2zZ+8YtfcPbZZzN06FDuvPNO3vOe9wBw7LHH8qpXvYqHHnqo23re/OY3c+CBBzJ8+HAOPvhg3vrWtwIwduxY1q5dyzPPPMNf/vIX3vSmNwHQ1NTE7bffDsB9993HWWedxdixY5k/fz73339/uTZFYQnYT4Gm/H0T8JOC4pAkSRWwdOlSFi1axF133cW9997LySef3OPYWUOGDOGcc87hlltu4fvf/z4XXXTRHq138ODBO9/X1dXtnK6rq6O1tbXHz06dOpVrr72W1atXc8UVV5R1ZP9KDEPxXeAu4JiIWB8Rfwd8EZgcEQ8Dk/JpSZI0QD3zzDMccsgh7L///jz44IPcfffdAAwaNIjt27d3+ZmLLrqI6667jjvuuIPGxmxAhbPOOov58+cD8NBDD/HII49wzDG93sfXrYMPPphDDjmEO+64A4BvfetbO3vDnnvuOV7xilewffv2nessl35/FFFK6V3dLJrY3+uWJEnVobGxka997Wscd9xxHHPMMUyYMAGAadOmceKJJ3LKKae8JMk577zzeO9738sFF1zAfvvtB8A//MM/8KEPfYixY8fS0NDA9ddfv0sv156YN28eH/zgB9m8eTOvfvWrue666wD4/Oc/z+mnn87w4cM5/fTTee655/ZqPR1VZBiKcnEYCu1rZs6cCcCsWbMKjkSS+m53hqEYKGplGApJkqR9Vr+fgpQkSepPt9xyC5/+9Kd3mXfUUUdx0003FRRR70zAJElSTTv//PM5//zziw5jt3gKUpIkqcJMwCRJkirMBEySJKnCvAZMkiQNOPX19YwdO3bn9I9//GNGjx7dZdlhw4axadOmCkWWMQGTJEn96sMf+yRPPvV02eo7/LBDufaaL/dYZujQoaxcubJs6yw3EzBJktSvnnzqaX5/xJvKV+ETt+32RzZt2sQFF1zAn//8Z7Zv385VV13FBRdcsEuZxx57jIsuuohnn32W1tZWvvrVr3LWWWdx6623csUVV7Bt2zZe85rXcN111zFs2LC9+hO8BkySJA04W7ZsYdy4cYwbN463ve1tDBkyhJtuuokVK1awZMkSPv7xj9P5aUDf+c53OP/881m5ciX33nsv48aN46mnnuKqq65i0aJFrFixgvHjx3PNNdfsdXz2gEmSpAGn8ynI7du3c/nll3P77bdTV1fHhg0beOKJJ3j5y1++s8xpp53G+973PrZv386FF17IuHHjuO2223jggQc444wzAHjhhRd4wxvesNfxmYBJkqQBb/78+WzcuJHly5czaNAgRo8ezdatW3cpc/bZZ3P77bdz8803M3XqVD72sY9xyCGHMHnyZL773e+WNR5PQUqSpAHvmWee4fDDD2fQoEEsWbKEdevWvaTMunXrOOKII/j7v/973v/+97NixQomTJjAr371K5qbmwF4/vnneeihh/Y6HnvAJEnSgHfJJZfw1re+lbFjxzJ+/HiOPfbYl5RZunQpX/7ylxk0aBDDhg3jhhtuYPjw4Vx//fW8613vYtu2bQBcddVVvPa1r92reEzAJElSvzr8sEP36M7FHuvrRedxvQ477DDuuuuuHss2NTXR1NT0kuXnnnsuv/vd7/Yg0u6ZgEmSpH7V25hd+yKvAZMkSaowEzBJkqQKMwGTJEmqMBMwSZKkCjMBkyRJqjDvgpQkSQNKS0sLEydOBODxxx+nvr6e4cOHA/Db3/6W/fbbr8jwABMwSZLUzy7/+Id55qknylbfwYcdwdX/em23y0ul0s7nQF555ZUMGzaMT3ziEzuXt7a20tBQbApU6Noj4qPA+4EErAYuTSlt7flTkiSpljzz1BN8+jUPlq2+L/1+9z8zdepUhgwZwj333MMZZ5zBQQcdtEtidsIJJ/Dzn/+c0aNH8+1vf5vZs2fzwgsvcPrpp/Mf//Ef1NfXly1+KPAasIgYAcwAxqeUTgDqgYuLikeSJA1s69ev59e//jXXXHNNt2XWrFnD97//fX71q1+xcuVK6uvrmT9/ftljKfoUZAMwNCK2A/sDjxYcjyRJGqDe+c539tqTtXjxYpYvX85pp50GwJYtWzj88MPLHkthCVhKaUNE/AvwCLAFuDWldGtR8UiSpIHtgAMO2Pm+oaGBtra2ndNbt2ZXQKWUaGpq4gtf+EK/xlLkKchDgAuAo4BXAgdExHu6KDctIpZFxLKNGzdWOkxJkjQAjR49mhUrVgCwYsUK/vjHPwIwceJEbrzxRp588kkAnn76adatW1f29Rc5Dtgk4I8ppY0ppe3Aj4A3di6UUpqbUhqfUhrffgupJEnS3nj729/O008/zfHHH8+1117La1/7WgBe97rXcdVVV3Heeedx4oknMnnyZB577LGyr7/Ia8AeASZExP5kpyAnAssKjEeSJPWDgw87Yo/uXOypvr668soru5w/dOhQbr216yufLrroIi666KI9Ca3PirwG7DcRcSOwAmgF7gHmFhWPJEnqHz2N2bWvKvQuyJTSFcAVRcYgSZJUaT4LUpIkqcJMwCRJUtmllIoOoWL25G81AZMkSWU1ZMgQWlpa9okkLKVES0sLQ4YM2a3PFT0SviRJGmBGjhzJ+vXr2VfG7xwyZAgjR47crc+YgEmSpLIaNGgQRx11VNFhVDVPQUqSJFWYCZgkSVKFmYBJkiRVmAmYJElShZmASZIkVZgJmCRJUoWZgEmSJFWYCZgkSVKFmYBJkiRVmAmYJElShZmASZIkVZgJmCRJnbS0tDBjxgxaWlqKDkUDlAmYJEmdzJs3j9WrV3PDDTcUHYoGKBMwSZI6aGlpYcGCBaSUWLBggb1g6hcmYJIkdTBv3jza2toA2LFjh71g6hcmYJIkdbBo0SJaW1sBaG1tZeHChQVHpIHIBEySpA4mTZpEQ0MDAA0NDUyePLngiDQQNRQdgDQQzJkzh+bm5rLX217nzJkzy173mDFjmD59etnrlWpdU1MTCxYsAKC+vp4pU6YUHJEGIhMwqQyam5t5+P57GDVsR1nr3W971km9bd2ystb7yKb6stYnDSSlUonGxkZ+9rOf0djYSKlUKjokDUCFJmAR8TLgm8AJQALel1K6q8iYpD01atgOLj/l2aLD6JOrVxxUdAhSVWtqamLt2rX2fqnfFN0DNgtYkFJ6R0TsB+xfcDySJFEqlZg9e3bRYWgAKywBi4iDgbOBqQAppReAF4qKR5IkqVKK7AE7CtgIXBcRJwHLgZkppecLjEmSNEDtzs0yGzZsAGDEiBF9Ku9NLdpdRQ5D0QCcAnw1pXQy8DxwWedCETEtIpZFxLKNGzdWOkZJ0j5oy5YtbNmypegwNIAV2QO2HlifUvpNPn0jXSRgKaW5wFyA8ePHp8qFJ0kaSHanh6p96JdZs2b1VzjaxxXWA5ZSehz4U0Qck8+aCDxQVDySJEmVUvRdkNOB+fkdkH8ALi04HkmSpH5XaAKWUloJjC8yBkmSpErzWZCSJEkVZgImSZJUYSZgkiRJFWYCJkmSVGEmYJIkSRVmAiZJklRhJmCSJEkVZgImSZJUYSZgkiRJFWYCJkmSVGEmYJIkSRVmAiZJklRhJmCSJEkV1lB0ANJAsGHDBp5/rp6rVxxUdCh9su65eg7YsKHoMHZLS0sLn/vc57jiiisolUpFhyNJe8UeMEk1Yd68eaxevZobbrih6FAkaa/ZA1aD5syZQ3Nzc5/Kbsh7OUaMGNGn8mPGjGH69Ol7HNu+asSIEWxrfYzLT3m26FD65OoVBzG4j9+JatDS0sKCBQtIKbFgwQKmTJliL5ikmmYP2AC3ZcsWtmzZUnQY0l6ZN28ebW1tAOzYscNeMEk1zx6wGrQ7PVQzZ84EYNasWf0VjtTvFi1aRGtrKwCtra0sXLiQj370owVHJUl7zh4wSVVv0qRJNDRkx4sNDQ1Mnjy54Igkae+YgEmqek1NTUQEAHV1dUyZMqXgiCRp75iASap6pVJp540kr3zlK70AX1LNMwGTVPVaWlp49NFHAXj00UdpaWkpOCJJ2jsmYJKqXse7INva2rwLUlLNMwGTVPW6ugtSkmpZ4QlYRNRHxD0R8fOiY5FUnbwLUtJAU3gCBswE1hQdhKTq1dTURF1dtruqr6/3LkhJNa/QBCwiRgJ/DXyzyDgkVbdSqURjYyMRQWNjo3dBSqp5RY+E/2/Ap4ADC45DUpVrampi7dq19n5JGhAK6wGLiL8BnkwpLe+l3LSIWBYRyzZu3Fih6CRVm1KpxOzZs+39kjQgFHkK8gzgbyNiLfA94NyI+HbnQimluSml8Sml8cOHD690jJKqREtLCzNmzHAMMEkDQmEJWErpMymlkSml0cDFwC9TSu8pKh5J1W3u3LmsWrWKuXPnFh2KJO21argLUpJ61NLSsnPsr4ULF9oLJqnmVUUCllJamlL6m6LjkFSd5s6du8tI+PaCSap1VZGASVJPFi9e3OO0JNWaooehkAaMRzbVc/WKg8pa5xObs2OkI/ZvK2u9j2yq5+iy1ti/Uko9TktSrTEBk8pgzJgx/VLvC83NAAx+VXnrP5r+i7k/nHnmmdx22207p88666wCo5GkvWcCJpXB9OnT+6XemTNnAjBr1qx+qb9WRETRIUhSWXkNmKSqd+edd/Y4LUntamXMQBMwSVXPa8Ak9dW8efNYvXo1N9xwQ9Gh9MgETFLVO/PMM3eZ9howSV1paWlhwYIFpJRYsGBBVfeCmYBJqnpDhgzZZXrw4MEFRSKpms2bN2/nmIE7duyo6l4wEzBJVe+OO+7ocVqSABYtWkRraysAra2tO5+gUY1MwCRVvUmTJtHQkN203dDQwOTJkwuOSFI1qqV9hQmYpKrX1NREXV22u6qvr2fKlCkFRySpGtXSvsJxwCRVvVKpRGNjIz/72c9obGykVCoVHZKqxJw5c2jOBywup/Y628fiK6cxY8b029iB+7pSqcQ555zDrbfeyjnnnFPV+woTMEk1oampibVr11b1Ea0qr7m5mYfvv4dRw3aUtd79tme9KNvWLStrvY9sqi9rfXqpWhm4udcELCKOBS4ARuSzNgA/TSmt6c/AJKmjUqnE7Nmziw5DVWjUsB1cfsqzRYfRJ+V+Xqx21dLSwpIlSwBYunQp06ZNq9pesB6vAYuITwPfAwL4bf4K4LsRcVn/hydJmVoZ3VpScQbSMBR/B5yWUvpiSunb+euLwOvzZZJUEVdffTWrVq3iC1/4QtGhSKpSA2kYijbglV3Mf0W+TJL6XUtLC8uXLwdg2bJl9oJJ6tJAGobiI8DiiPhFRMzNXwuAxUD5bw2RpC5cffXVu0zbCyapKwNmGIqU0oKIeC3ZKceOF+H/LqVU3ltOJKkb7b1f7ZYtK++daZIGhlKpxJvf/GZuueWW2h+GIqXUBtzdPh0R01JKd/fwEUmSpEKklIoOoU/2ZCT8D5Y9CkmSpL3U0tLC0qVLgWwYimq+XnRPErDaGOFMkiTtUwbSMBQARMTH2l/AD/P3fxcR4/o5PkmSpD4ZSMNQtBtPdupxBHAI8AGgEfhGRHyqn2KTJEnqs4E0DEW7kcApKaWPp5Q+DpwKHA6cDUztp9gkSZL6rJaGoehrAnY4sK3D9HbgiJTSlk7z+ywijoyIJRHxQETcHxGOKyZJkvZYqVSisbGRiKCxsbG2h6HIzQd+ExE/yaffCnwnIg4AHtjDdbcCH08prYiIA4HlEbEwpbSn9UmSpAFqzpw5NDc391ruT3/6E/X19Tz88MPMnNl7386YMWOYPn16OULcLX1KwFJKn4+IXwBn5LM+mFJqHwnxkj1ZcUrpMeCx/P1zEbGG7BozEzBJkrRHtm3bxuDBgxk0aFDRofSorz1g5AlXvww/HRGjgZOB33SxbBowDWDUqFH9sXpJBenrEW1XejuyLeqoVpW1YcMGnn+unqtXHFR0KH2y7rl6DtiwoegwalJff8/t+4ZZs2b1Zzh7bU/GASuriBgG/BD4SErp2c7LU0pzU0rjU0rjhw8fXvkAJUmSyqzPPWD9ISIGkSVf81NKPyoyFkmV19cj2ssuu4y7737xCWhveMMbfCC3ABgxYgTbWh/j8lNecvxela5ecRCDR4zovaAGvMJ6wCIigP8LrEkpXVNUHJKq3yc/+cldpj/xiU8UFIkklUeRpyDPAN4LnBsRK/PXXxUYj6QqVSqVOPDAA4Gs96uaby2XpL4o7BRkSulOfK6kpD468sgjWbdunb1fkgaEwi/Cl6S+GDRoEGPGjLH3S9KAUOhF+HrR3tyO35P2OvsyGN3u8jZ/SZL2jAlYlWhububh++9h1LAdZa13v+1ZJ+e2deUdwu2RTfVlrU+SpH2JCVgVGTVsR03dSi1JkvaM14BJkiRVmAmYJElShZmASZIkVZgJmCRJUoWZgEmSJFWYd0FKFbY7Y77t7jhujs0mSbXBBEyqYkOHDi06BElSPzABkyrMHipJkgmYJKmmPbKpvuyDQz+xObtE+oj928pa7yOb6jm6rDWqVpmASZJq1pgxY/ql3hfy6y8Hv6q89R9N/8Ws2mICJkmqWf11Sr/9xpdZs2b1S/2Sw1BIkiRVmD1gkiSpELszLE9f7e7wPbujnEP9mIBJkqRCNDc38/D99zBq2I6y1bnf9uzk3rZ1y8pWJ2Q3UJSTCZgkSSrMqGE7uPyUZ4sOo1flvtPWBKxKbNiwgeefK/+t1P1l3XP1HLBhQ9FhSJJUk0zAJJVVf1zTAbVzXYck9YUJWJUYMWIE21ofq4luWMi6YgePGFF0GKpCzc3NrLxvDTv2P7Ss9da9kABY/ocnylpv/eany1qfJPWFCZikstux/6FsOfavig6jT4Y++P+KDkHSPshxwCRJkiqs0B6wiGgEZgH1wDdTSl8sMh5JklQ5tXQDWrlvPiusBywi6oF/B94CvA54V0S8rqh4JEmSKqXIHrDXA80ppT8ARMT3gAuABwqMSZIkVUgt3YBW7pvPirwGbATwpw7T6/N5kiRJA1rVX4QfEdMiYllELNu4cWPR4UiSJO21Ik9BbgCO7DA9Mp+3i5TSXGAuwPjx41NlQpO0pzZs2ED95mdqZniH+s0tbNjQWnQYkvYxRfaA/Q44OiKOioj9gIuBnxYYjyRJUkUU1gOWUmqNiA8Dt5ANQ/GfKaX7i4pHUnmMGDGCx7c11NRArCNGHFF0GJL2MYWOA5ZS+n9AbZynkCRJKhMfRSRJkgrzyKbyDsT6xObs6qoj9m8rW52QxXl0GeszAZMkSYUYM2ZM2et8obkZgMGvKm/dR1PeeE3AJElSIaZPn172OmfOnAnArFmzyl53OZmAVZFyd8NC7XTFSpK0LzEBqxL90Q0LtdMVq4GlfvPTZR8HrG5r9qiStiHlPUip3/w04F2QkirLBKxK9Ec3LNROV6wGjv5KzJubn8vqf3W5k6UjPJiQVHEmYJLKyoMJSepd1T8LUpIkaaCxB0yStE+YM2cOzfl1sb1pL9fe89qbMWPG9FvvrwYmEzBJkjoZOnRo0SFogDMBkyTtE+yhUjXxGjBJkqQKMwGTJEmqMBMwSZKkCjMBkyRJqjATMEmSpAozAZMkSaowEzBJkqQKMwGTJEmqMAdilSRJVa+vj5KqlcdImYBJkqQBo1YeI2UCJkmSqt5Ae5SU14BJkiRVmAmYJElShRWSgEXElyPiwYhYFRE3RcTLiohDkiSpCEX1gC0ETkgpnQg8BHymoDgkSZIqrpAELKV0a0qpNZ+8GxhZRBySJElFqIZrwN4H/KLoICRJkiql34ahiIhFwMu7WPTZlNJP8jKfBVqB+T3UMw2YBjBq1Kh+iFSSJKmy+i0BSylN6ml5REwF/gaYmFJKPdQzF5gLMH78+G7LSao9fR3ZGmpndGtJ6oui7oJsBD4F/G1KaXMRMUiqLYMHD2bbtm1s37696FAkaa8VNRL+tcBgYGFEANydUvpgQbFIKsju9FB94Qtf4JZbbuHII4/kM5/xxmlJta2ouyDHpJSOTCmNy18mX5K61dLSwsKFCwFYuHAhLS0tBUckSXunGu6ClKQezZ07l7a2NgDa2tqYO3duwRFJ0t4xAZNU9RYvXtzjtCTVGhMwSVWv843SPdw4LUk1wQRMUtWbOHHiLtOTJvU4yo0kVT0TMElV7wMf+AB1ddnuqq6ujmnTphUckSTtnaKGodBecPBK7WtKpRKTJk3i1ltvZfLkyZRKpaJDkqS9YgI2wA0dOrToEKSy+MAHPsDjjz9u75ekASFq6WLW8ePHp2XLlhUdhiRJUq8iYnlKaXxXy7wGTJIkqcJMwCRJkirMBEySJKnCTMAkSZIqzARMUk1oaWlhxowZPohb0oBgAiapJnz9619n1apVPohb0oBgAiap6rW0tLBo0SIAFi5caC+YpJpnAiap6n3961+nra0NgLa2NnvBJNU8EzBJVW/x4sW7TLf3hklSrTIBk1T1IqLHaUmqNSZgkqrexIkTe5yWpFpjAiap6k2bNo26umx3VVdX5wO5JdU8EzBJVa9UKjF58mQAJk+eTKlUKjgiSdo7DUUHIEl9MW3aNB577DF7vyQNCCZgkmpCqVRi9uzZRYchSWXhKUhJkqQKKzQBi4iPR0SKiMOKjEOSJKmSCkvAIuJI4DzgkaJikCRJKkKRPWBfAT4FpAJjkCRJqrhCErCIuADYkFK6t4j1S5IkFanf7oKMiEXAy7tY9FngcrLTj32pZxowDWDUqFFli0+SJKkokVJlzwBGxFhgMbA5nzUSeBR4fUrp8Z4+O378+LRs2bJ+jlCSJGnvRcTylNL4rpZVfBywlNJq4PD26YhYC4xPKT1V6VgkSZKK4DhgkiRJFVb4SPgppdFFxyBJklRJ9oBJkiRVmAmYJElShZmASZIkVZgJmCRJUoWZgEmSJFWYCZikmtDS0sKMGTNoaWkpOhRJ2msmYJJqwrx581i9ejU33HBD0aFI0l4zAZNU9VpaWliwYAEpJRYsWGAvmKSaZwImqerNmzePtrY2AHbs2GEvmKSaZwImqeotWrSI1tZWAFpbW1m4cGHBEUnS3jEBk1T1Jk2aREND9uS0hoYGJk+eXHBEkrR3TMAkVb2mpibq6rLdVX19PVOmTCk4IknaOyZgkqpeqVSisbGRiKCxsZFSqVR0SJK0VxqKDkCS+qKpqYm1a9fa+yVpQDABk1QTSqUSs2fPLjoMSSoLT0FKkiRVmAmYJElShZmASZIkVZgJmCRJUoWZgEmSJFWYCZgkSVKFmYBJkiRVWKSUio6hzyJiI7Cu6Dj60WHAU0UHoT1i29U226+22X61a6C33atSSsO7WlBTCdhAFxHLUkrji45Du8+2q222X22z/WrXvtx2noKUJEmqMBMwSZKkCjMBqy5ziw5Ae8y2q222X22z/WrXPtt2XgMmSZJUYfaASZIkVZgJWC8i4qMRcX9E3BcR342IIRGxNiIO66LsqIhYEhH3RMSqiPirfP4lEbGyw6stIsb1st47OpR/NCJ+3Ev5QRExLyJWR8SaiPhMPn9IRPw2Iu7N/47P7c32qCXdtF2ftmt7G0fEMZ3a7tmI+Ehe5p15/W0R8ZK7ePLvw6aI+EQ+3W1bROb/RMRDefvN6LDsnHzd90fEbeXfUgNXRGzqZv6XI+LB/Hd6U0S8LJ8/NSKu7eYzL/k+5fO7bDid0bYAAAz5SURBVLt8/uyIaM7Xc0p//Z3VKv8drc6/v8s6zJ+eb//7I+Kf83mTI2J5Xn55RJzbofy78vmrImJBV/vfDmXPiYifd7NsQYff39cior6cf+9AFREz8+/9/R32f8fm7XpPRLymh9/HURHxm/x38P2I2C+fPzyff09EnNVd23RaT0/74+93mL82IlYWtb36LKXkq5sXMAL4IzA0n/4vYCqwFjisi/JzgQ/l718HrO2izFjg97sZxw+BKb2UeTfwvfz9/nmMo4EAhuXzBwG/ASYUvW2Laru+bteu2hioBx4nG9cF4DjgGGApML6LOm4EfgB8Ip/uti2AS4EbgLp8+vD835cBDwCjOs731efvwaZu5p8HNOTvvwR8KX8/Fbh2d75PPbTdXwG/yNt9AvCbordHAdu/q9/Rm4FFwOBO2+tk4JX5+xOADfn7BuDJ9nqAfwau7GGd5wA/72bZQfm/kf/+Ly56G1X7K2+L+/L/VxrythsDXAb8Y16mp9/Hf7VvZ+BrvPh/5MXAN3trm47r6RTXLvvjTsv+FfjfRW+73l72gPWuARgaEQ1kX8BH8/mfyo/IfhsRY/J5CTgof39wh7IdvQv4XvtERHw1IpZ17hHpsPwg4Fzgx/n06yPirvxo4NcRcUyHdR+QxzkUeAF4NmXaewEG5a995cK/7tquq+1aiohb83b4JtlOoLOJZMnzOoCU0pqU0n93teKIuJBsh3R/+7xe2uJDwP+XUmrLyz6Zz3838KOU0iOd5u8TImJK3utxb0R8KyLe2uGoeVFEHJGXGxYR13XoJXl7hzq+krfr4ogYDpBSujWl1JoXuRsY2WG1R0bE0oh4OCKu6DC/u+9Td213AXBD3u53Ay+LiFeUdwvVpA8BX0wpbYMXt1dK6Z6UUvs2vZ9sWw8m+y0G2f4tyPaxjwJExJj8e3BvRKyIiNfknz8oIm6OiP/Oe1Pq8nU8my9vAPYj//3lPTgL8p63OyLi2Hz+8Ij4YUT8Ln+d0b+bpiodR3bwsDn/zdxGtl/6CPChiFiSl3vJ7yNvr3PJDkYB5gEXRnYG6J+BC/Ieq6FdtU1kZ5E6r6fdLvvjdvk6/yfw3XJtgH5TdAZY7S9gJrAJ2AjMz+etBT6bv59CfrQFvAJYDawH/gyc2kV9vwdO6DB9aHoxm18KnNip/BTgxg7TB/Hikfsk4If5+0Fkid1G4HlgWofP1AMr87/jS0Vv0yLbroftOpv8iAn4a7Idc+cj9/8EPtzFepbSoQcMGAbclf97JXkPWE9tAbQAnwWWkfWaHJ3P/zfg3/N1LKeXntCB9AKOBx7ixZ6PQ4FDePHmofcD/5q//xLwbx0+e0j+bwIuyd//b7ru3foZ8J78/VTgMaBEdiBzX3vbdvd96qHtfg6c2aHcYrroKR3IL7KDkBX5d3daPm8l8DmyHuDbgNO6+Nw7gEWdpp/N2+Z2oD6f/xvgbfn7IWT/8Z8DbAVenf/eFgLv6FDXLWT75+90qGdxh3Y7Hfhl/v477W0IjALWFL1NC2jD4/LfYSnfvncBc7rYt3X1f+VhQHOHMkcC9+Xvp3b+PXbTNrusp0PZ7vbHZwPLit5ufXnZA9aDiDiE7Cj2KOCVZEdg78kXf7fDv2/I378LuD6lNJLs9MO32o+88vpOBzanlO7rsJr/GRErgHvI/sN5Xacw3sWumfzBwA8i4j7gK/lnAF4P7MjjPAr4eES8GiCltCOlNI7sKP/1EXHCbm+MGtNL28FLt+vZwLcBUko3k+0EOta3H/C3ZKcUe3Ml8JX0Ym/XTj20xWBga8pGhP4G2c4FsqPBU8mSwvOBf4qI1/YhhoHgXOAHKaWnAFJKT5Ntt1siYjXwSV78/k8iS1TJy7a3Xxvw/fz9t4EzO64gIj4LtALzO8xemFJqSSltAX4EnNnL96m7tlOWvJwCvAX4XxFxNtl3+lCy07KfBP4r77UAICKOJ0uoP5BPDyLrNTuZbNuvAj4TEQcCI1JKNwGklLamlDbn1fw2pfSHlNIOst/5znZPKZ1PdrA8GDg3IoYBbyTbr64Evp4vh+x7dW0+/6dkPWvDyrqFqlxKaQ1Ze9wKLCBLoHd0LNOH/W1f17VL23RXrpf9ced9e9UyAevZJOCPKaWNKaXtZDvjN+bLOp7Ga3//d2Tnu0kp3UV2RNbxYtGL6fDFiIijgE8AE1NKJwI3559pX34YWWJ1c4c6Pg8sSSmdALy1Q/l3AwtSSttT1qX/K2CXC8NTSn8BlgCNu7ENalW3bdfNdu3NW4AVKaUn+lD2dOCfI2ItWff55RHx4Y4FumiL9XmMADcBJ3aYf0tK6fk8EbkdOGk34h5o5pAdNY8l+w96SC/lO9v5u42IqcDfkPWQdfV77jjd076gu7bbQHbE325kPm+fkVLakP/7JNm2eT359kqZ35IlyYcBRMTIvNyUlNLv82rG5XX8Pm+n/+LFbd/tqnuaTiltBX5CljTUAX9JKY3r8DouL1pHdp1m+/wRXR1YDXQppf+bUjo1pXQ22cHpQ52KdPf7aCE79d6Ql+v1N9CpbbrT5f44X8//4MWDrqpmAtazR4AJEbF/foQ2EViTL7uow793dSg/ESAijiP7z2FjPl1Hdl565/VfZKcTnweeya9leUun9b+D7PTm1g7zDubFL/DUTrGem6/rALKjywfzaxja7/AaCkwGHuz7JqhZPbVdV9v1drIkloh4C9mpro76fFSVUjorpTQ6pTSa7BTi1Smla3tpix+TXZwM8CZe3MH9hKwHpiEi9idL7tr/joHul8A7I6IEEBGHsuv3v6lD2YXA/2qfyI/IIdvHvSN//27gznx5I/Ap4G879Jq0mxwRh+ZtdCHZwUxP36fu2u6nwJTITACeSSk9tvuboTZFxAF5L1X7Puk8slO6O7dX3pu7H/BU/tu4GbgspfSrDlVtAF7Xfv0e2e9mTUrpOWB9ZNdbEhGD898IZL3LR+X73YuAOyO7TvAVedkGsl7lB1N27dEfI+Kd+bKIiPaDnFuB6R3+ph7vXh+oIuLw/N9RZAnOdzoV6fL3kSfMS3jxN9hEtk/rXH+XbdNDSN3tjyeRten6vv5thSr6HGi1v8iuVXiQbMfxLbKu0bVkXbKrgN8BY/KyryPbWd9L1k17Xod6zgHu7qL+68l22IvJjhqmdli2FGjsVP4Nefl7gKvI77Qku97oB2QXrz4AfDKff2JedlX+N1T9nSH92XY9bNcS2c72frLTSOt48dqjA8iO5A7u9Jm3kR3NbwOeIOup6hzDlbx4F2S3bUF2t+PNZNcQ3gWc1GHZJ/M2vQ/4SNHbtcJt2JT/3ffmv5ULgD+QXVP0ZWBpXm4Y2QW+7WX/Rz5/E3BNPv+XwPB8fjPwp/x3uhL4Wj5/KlmCsAR4GLiiD9+nLtuO7MLxfye77nM1+971X6/O2+Le/HfVft3sfmSng+8juz7s3Hz+P5IdkK7s8Gq/Q/KDZAnvKrJr9kr5/KPzdl2VfydeTbavvT1vk/8mu/OuDjiCbH/d/vubw4vX0x5Fdnrt3vy31n496GFkvSmr8vlfK3q7FtSWd+R//71kZ2zgpdeAdff7eDXw2/w394MO86eSXwPWS9t0Xk+X++N82fXAB4veXn19ORK+JElShXkKUpIkqcJMwCRJkirMBEySJKnCTMAkSZIqzARMkiSpwkzAJGkPRcQ5EdHboKCS9BImYJK0586h91HZJeklTMAk1YSImBIRqyLi3oj4VkSMjohf5vMW56N0ExHXR8RXI+LuiPhD3kv1nxGxJiKu71Dfpoj4SkTcn39+eD5/XP7ZVRFxU/uo+hExIyIeyOd/LyJGkw0Q+tGIWBkRZ3UXkyR1ZgImqerlD2j+R7JR008CZpKNlj0vZc9RnQ/M7vCRQ8ieGvFRskcCtT+4fmyHx8kcACxLKR0P3AZckc+/Afh0Xu/qDvMvA07O538wpbSWbJT1r6TsOYF39BKTJO1kAiapFpwL/CBlDyQnpfQ0WYLV/ky6bwFndij/s5Q95mM18ERKaXVKqY3skTij8zJtvPjQ3m+TPXPzYOBlKaXb8vnzgLPz96uA+RHxHqC1mzh7ikmSdjIBkzQQbcv/bevwvn26oZvP9PZctr8me7bjKcDv8ocGS9IeMQGTVAt+CbwzIkoAEXEo8Gvg4nz5JWQPDN4ddcA78vfvBu5MKT0D/Dkizsrnvxe4LSLqgCNTSkuATwMHkz0A/DngwA517m1MkvYRHsFJqnoppfsj4v+QJUM7gHuA6cB1EfFJYCNw6W5W+zzw+oj4R+BJ4KJ8fhPwtYjYH/hDXm898O38FGUAs1NKf4mInwE3RsQFeTx7G5OkfURkl0lI0r4lIjallIYVHYekfZOnICVJkirMHjBJkqQKswdMkiSpwkzAJEmSKswETJIkqcJMwCRJkirMBEySJKnCTMAkSZIq7P8H/tbBC1twDFMAAAAASUVORK5CYII=\n",
            "text/plain": [
              "<Figure size 720x360 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "t_N_U3vZ0VCi"
      },
      "source": [
        "## Desafios Aula 04"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "HaNf9aTB0XEc"
      },
      "source": [
        "### Desafio 01: Encontrar o top 10 das ações do MOA (mecanismo de ação)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "zf2YupYbL2r0"
      },
      "source": [
        "### Desafio 02: Criar a coluna eh_controle quando linha tratamento == com_controle"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "1aZvBhtAL_9-"
      },
      "source": [
        "### Desafio 03: Criar três colunas para indicar o tempo (24, 48 e 72)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "XJALBCA8MQsv"
      },
      "source": [
        "### Desafio 04: Estudar sobre conbinações (merging) de DataFrames"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "vgEX7ykhRx9R"
      },
      "source": [
        "### Desafio 05: Análise mais detalhada do tempo e dose (comparar as distribuiçõe)\n",
        "### Obs: escolha uma droga e compare com o controle."
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "UF8tn60bR_jU"
      },
      "source": [
        "### Desafio 06: Descobrir se temos algum composto que, dependendo da configuração, ativa ou não algum MOA"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "ZG9batCDSWOl"
      },
      "source": [
        "### Desafio 07: Descobrir se algum composto que, dependendo da configuração, ativa MOA's diferentes."
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "BX8S5J50SlrC"
      },
      "source": [
        "### Desafio 08: Resumo do que você aprendeu com os dados."
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "9ocjzRUkS8x9"
      },
      "source": [
        "A partir da aula percebi que, dependendo do composto, há resultados diferentes, uma vez que cada um deles ativa algum mecanismo de ação diferente (ou não ativa). Além disso, todos aqueles que apenas tiveram \"controle\" como tratamento não obtiveram sequer um mecanismo ativado."
      ]
    }
  ]
}