imersaodados3_aula1.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "imersaodados3-aula1.ipynb",
      "provenance": [],
      "collapsed_sections": [
        "w4e3kNh2aoYN",
        "4PDtixak0b-Z"
      ],
      "authorship_tag": "ABX9TyO0/bcvV20V6vITaD8bl9lV",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/leonardo-melniski/colab/blob/main/imersaodados3_aula1.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "H6WlJGuirfD-"
      },
      "source": [
        "# Imersão Dados\n",
        "## 1 Análise de dados, python, pandas e novos fármacos\n",
        "link: [alura.com.br/imersaodados3/aula01](\n",
        "https://www.alura.com.br/imersao-dados/aula01-python-pandas-farmacologia?utm_campaign=imersao_dados_3_aulas_aula_1&utm_medium=email&utm_source=RD+Station)\n",
        "\n",
        "Neste link, temos o Github do projeto onde está localizado a [base de dados](https://github.com/alura-cursos/imersaodados3).\n",
        "\n",
        "Para dar um mergulho ainda mais profundo, dê uma olhada neste [artigo](https://www.alura.com.br/artigos/grafico-de-pizza?utm_source=gnarus&utm_medium=timeline) sobre o gráfico de pizza.\n",
        "\n",
        "Esse projeto foi inspirado em um desafio do [Laboratory innovation science at Harvard](https://lish.harvard.edu/) disponibilizando os dados em uma competição no [kaggle](https://www.kaggle.com/c/lish-moa)."
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "iiccdlVCvs3Y"
      },
      "source": [
        "## Aula 01 - Parte 1\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Lv6eacghoedm"
      },
      "source": [
        "import pandas as pd"
      ],
      "execution_count": 5,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "-TkAUGCLpPrt"
      },
      "source": [
        "url_dados = 'https://github.com/alura-cursos/imersaodados3/blob/main/dados/dados_experimentos.zip?raw=true'\n",
        "dados = pd.read_csv(url_dados, compression = 'zip')"
      ],
      "execution_count": 6,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 256
        },
        "id": "l6WQ3OhOpnp4",
        "outputId": "0da54daf-e572-4fe0-c5f5-bbd8c2beaa6e"
      },
      "source": [
        "dados.head()"
      ],
      "execution_count": 7,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>id</th>\n",
              "      <th>tratamento</th>\n",
              "      <th>tempo</th>\n",
              "      <th>dose</th>\n",
              "      <th>droga</th>\n",
              "      <th>g-0</th>\n",
              "      <th>g-1</th>\n",
              "      <th>g-2</th>\n",
              "      <th>g-3</th>\n",
              "      <th>g-4</th>\n",
              "      <th>g-5</th>\n",
              "      <th>g-6</th>\n",
              "      <th>g-7</th>\n",
              "      <th>g-8</th>\n",
              "      <th>g-9</th>\n",
              "      <th>g-10</th>\n",
              "      <th>g-11</th>\n",
              "      <th>g-12</th>\n",
              "      <th>g-13</th>\n",
              "      <th>g-14</th>\n",
              "      <th>g-15</th>\n",
              "      <th>g-16</th>\n",
              "      <th>g-17</th>\n",
              "      <th>g-18</th>\n",
              "      <th>g-19</th>\n",
              "      <th>g-20</th>\n",
              "      <th>g-21</th>\n",
              "      <th>g-22</th>\n",
              "      <th>g-23</th>\n",
              "      <th>g-24</th>\n",
              "      <th>g-25</th>\n",
              "      <th>g-26</th>\n",
              "      <th>g-27</th>\n",
              "      <th>g-28</th>\n",
              "      <th>g-29</th>\n",
              "      <th>g-30</th>\n",
              "      <th>g-31</th>\n",
              "      <th>g-32</th>\n",
              "      <th>g-33</th>\n",
              "      <th>g-34</th>\n",
              "      <th>...</th>\n",
              "      <th>c-60</th>\n",
              "      <th>c-61</th>\n",
              "      <th>c-62</th>\n",
              "      <th>c-63</th>\n",
              "      <th>c-64</th>\n",
              "      <th>c-65</th>\n",
              "      <th>c-66</th>\n",
              "      <th>c-67</th>\n",
              "      <th>c-68</th>\n",
              "      <th>c-69</th>\n",
              "      <th>c-70</th>\n",
              "      <th>c-71</th>\n",
              "      <th>c-72</th>\n",
              "      <th>c-73</th>\n",
              "      <th>c-74</th>\n",
              "      <th>c-75</th>\n",
              "      <th>c-76</th>\n",
              "      <th>c-77</th>\n",
              "      <th>c-78</th>\n",
              "      <th>c-79</th>\n",
              "      <th>c-80</th>\n",
              "      <th>c-81</th>\n",
              "      <th>c-82</th>\n",
              "      <th>c-83</th>\n",
              "      <th>c-84</th>\n",
              "      <th>c-85</th>\n",
              "      <th>c-86</th>\n",
              "      <th>c-87</th>\n",
              "      <th>c-88</th>\n",
              "      <th>c-89</th>\n",
              "      <th>c-90</th>\n",
              "      <th>c-91</th>\n",
              "      <th>c-92</th>\n",
              "      <th>c-93</th>\n",
              "      <th>c-94</th>\n",
              "      <th>c-95</th>\n",
              "      <th>c-96</th>\n",
              "      <th>c-97</th>\n",
              "      <th>c-98</th>\n",
              "      <th>c-99</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>id_000644bb2</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>b68db1d53</td>\n",
              "      <td>1.0620</td>\n",
              "      <td>0.5577</td>\n",
              "      <td>-0.2479</td>\n",
              "      <td>-0.6208</td>\n",
              "      <td>-0.1944</td>\n",
              "      <td>-1.0120</td>\n",
              "      <td>-1.0220</td>\n",
              "      <td>-0.0326</td>\n",
              "      <td>0.5548</td>\n",
              "      <td>-0.0921</td>\n",
              "      <td>1.1830</td>\n",
              "      <td>0.1530</td>\n",
              "      <td>0.5574</td>\n",
              "      <td>-0.4015</td>\n",
              "      <td>0.1789</td>\n",
              "      <td>-0.6528</td>\n",
              "      <td>-0.7969</td>\n",
              "      <td>0.6342</td>\n",
              "      <td>0.1778</td>\n",
              "      <td>-0.3694</td>\n",
              "      <td>-0.5688</td>\n",
              "      <td>-1.1360</td>\n",
              "      <td>-1.1880</td>\n",
              "      <td>0.6940</td>\n",
              "      <td>0.4393</td>\n",
              "      <td>0.2664</td>\n",
              "      <td>0.1907</td>\n",
              "      <td>0.1628</td>\n",
              "      <td>-0.2853</td>\n",
              "      <td>0.5819</td>\n",
              "      <td>0.2934</td>\n",
              "      <td>-0.5584</td>\n",
              "      <td>-0.0916</td>\n",
              "      <td>-0.3010</td>\n",
              "      <td>-0.1537</td>\n",
              "      <td>...</td>\n",
              "      <td>0.4805</td>\n",
              "      <td>0.4965</td>\n",
              "      <td>0.3680</td>\n",
              "      <td>0.8427</td>\n",
              "      <td>0.1042</td>\n",
              "      <td>0.1403</td>\n",
              "      <td>0.1758</td>\n",
              "      <td>1.2570</td>\n",
              "      <td>-0.5979</td>\n",
              "      <td>1.2250</td>\n",
              "      <td>-0.0553</td>\n",
              "      <td>0.7351</td>\n",
              "      <td>0.5810</td>\n",
              "      <td>0.9590</td>\n",
              "      <td>0.2427</td>\n",
              "      <td>0.0495</td>\n",
              "      <td>0.4141</td>\n",
              "      <td>0.8432</td>\n",
              "      <td>0.6162</td>\n",
              "      <td>-0.7318</td>\n",
              "      <td>1.2120</td>\n",
              "      <td>0.6362</td>\n",
              "      <td>-0.4427</td>\n",
              "      <td>0.1288</td>\n",
              "      <td>1.4840</td>\n",
              "      <td>0.1799</td>\n",
              "      <td>0.5367</td>\n",
              "      <td>-0.1111</td>\n",
              "      <td>-1.0120</td>\n",
              "      <td>0.6685</td>\n",
              "      <td>0.2862</td>\n",
              "      <td>0.2584</td>\n",
              "      <td>0.8076</td>\n",
              "      <td>0.5523</td>\n",
              "      <td>-0.1912</td>\n",
              "      <td>0.6584</td>\n",
              "      <td>-0.3981</td>\n",
              "      <td>0.2139</td>\n",
              "      <td>0.3801</td>\n",
              "      <td>0.4176</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>id_000779bfc</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>72</td>\n",
              "      <td>D1</td>\n",
              "      <td>df89a8e5a</td>\n",
              "      <td>0.0743</td>\n",
              "      <td>0.4087</td>\n",
              "      <td>0.2991</td>\n",
              "      <td>0.0604</td>\n",
              "      <td>1.0190</td>\n",
              "      <td>0.5207</td>\n",
              "      <td>0.2341</td>\n",
              "      <td>0.3372</td>\n",
              "      <td>-0.4047</td>\n",
              "      <td>0.8507</td>\n",
              "      <td>-1.1520</td>\n",
              "      <td>-0.4201</td>\n",
              "      <td>-0.0958</td>\n",
              "      <td>0.4590</td>\n",
              "      <td>0.0803</td>\n",
              "      <td>0.2250</td>\n",
              "      <td>0.5293</td>\n",
              "      <td>0.2839</td>\n",
              "      <td>-0.3494</td>\n",
              "      <td>0.2883</td>\n",
              "      <td>0.9449</td>\n",
              "      <td>-0.1646</td>\n",
              "      <td>-0.2657</td>\n",
              "      <td>-0.3372</td>\n",
              "      <td>0.3135</td>\n",
              "      <td>-0.4316</td>\n",
              "      <td>0.4773</td>\n",
              "      <td>0.2075</td>\n",
              "      <td>-0.4216</td>\n",
              "      <td>-0.1161</td>\n",
              "      <td>-0.0499</td>\n",
              "      <td>-0.2627</td>\n",
              "      <td>0.9959</td>\n",
              "      <td>-0.2483</td>\n",
              "      <td>0.2655</td>\n",
              "      <td>...</td>\n",
              "      <td>0.4083</td>\n",
              "      <td>0.0319</td>\n",
              "      <td>0.3905</td>\n",
              "      <td>0.7099</td>\n",
              "      <td>0.2912</td>\n",
              "      <td>0.4151</td>\n",
              "      <td>-0.2840</td>\n",
              "      <td>-0.3104</td>\n",
              "      <td>-0.6373</td>\n",
              "      <td>0.2887</td>\n",
              "      <td>-0.0765</td>\n",
              "      <td>0.2539</td>\n",
              "      <td>0.4443</td>\n",
              "      <td>0.5932</td>\n",
              "      <td>0.2031</td>\n",
              "      <td>0.7639</td>\n",
              "      <td>0.5499</td>\n",
              "      <td>-0.3322</td>\n",
              "      <td>-0.0977</td>\n",
              "      <td>0.4329</td>\n",
              "      <td>-0.2782</td>\n",
              "      <td>0.7827</td>\n",
              "      <td>0.5934</td>\n",
              "      <td>0.3402</td>\n",
              "      <td>0.1499</td>\n",
              "      <td>0.4420</td>\n",
              "      <td>0.9366</td>\n",
              "      <td>0.8193</td>\n",
              "      <td>-0.4236</td>\n",
              "      <td>0.3192</td>\n",
              "      <td>-0.4265</td>\n",
              "      <td>0.7543</td>\n",
              "      <td>0.4708</td>\n",
              "      <td>0.0230</td>\n",
              "      <td>0.2957</td>\n",
              "      <td>0.4899</td>\n",
              "      <td>0.1522</td>\n",
              "      <td>0.1241</td>\n",
              "      <td>0.6077</td>\n",
              "      <td>0.7371</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>id_000a6266a</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>48</td>\n",
              "      <td>D1</td>\n",
              "      <td>18bb41b2c</td>\n",
              "      <td>0.6280</td>\n",
              "      <td>0.5817</td>\n",
              "      <td>1.5540</td>\n",
              "      <td>-0.0764</td>\n",
              "      <td>-0.0323</td>\n",
              "      <td>1.2390</td>\n",
              "      <td>0.1715</td>\n",
              "      <td>0.2155</td>\n",
              "      <td>0.0065</td>\n",
              "      <td>1.2300</td>\n",
              "      <td>-0.4797</td>\n",
              "      <td>-0.5631</td>\n",
              "      <td>-0.0366</td>\n",
              "      <td>-1.8300</td>\n",
              "      <td>0.6057</td>\n",
              "      <td>-0.3278</td>\n",
              "      <td>0.6042</td>\n",
              "      <td>-0.3075</td>\n",
              "      <td>-0.1147</td>\n",
              "      <td>-0.0570</td>\n",
              "      <td>-0.0799</td>\n",
              "      <td>-0.8181</td>\n",
              "      <td>-1.5320</td>\n",
              "      <td>0.2307</td>\n",
              "      <td>0.4901</td>\n",
              "      <td>0.4780</td>\n",
              "      <td>-1.3970</td>\n",
              "      <td>4.6240</td>\n",
              "      <td>-0.0437</td>\n",
              "      <td>1.2870</td>\n",
              "      <td>-1.8530</td>\n",
              "      <td>0.6069</td>\n",
              "      <td>0.4290</td>\n",
              "      <td>0.1783</td>\n",
              "      <td>0.0018</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.5477</td>\n",
              "      <td>-0.7576</td>\n",
              "      <td>-0.0444</td>\n",
              "      <td>0.1894</td>\n",
              "      <td>-0.0014</td>\n",
              "      <td>-2.3640</td>\n",
              "      <td>-0.4682</td>\n",
              "      <td>0.1210</td>\n",
              "      <td>-0.5177</td>\n",
              "      <td>-0.0604</td>\n",
              "      <td>0.1682</td>\n",
              "      <td>-0.4436</td>\n",
              "      <td>0.4963</td>\n",
              "      <td>0.1363</td>\n",
              "      <td>0.3335</td>\n",
              "      <td>0.9760</td>\n",
              "      <td>-0.0427</td>\n",
              "      <td>-0.1235</td>\n",
              "      <td>0.0959</td>\n",
              "      <td>0.0690</td>\n",
              "      <td>-0.9416</td>\n",
              "      <td>-0.7548</td>\n",
              "      <td>-0.1109</td>\n",
              "      <td>-0.6272</td>\n",
              "      <td>0.3019</td>\n",
              "      <td>0.1172</td>\n",
              "      <td>0.1093</td>\n",
              "      <td>-0.3113</td>\n",
              "      <td>0.3019</td>\n",
              "      <td>-0.0873</td>\n",
              "      <td>-0.7250</td>\n",
              "      <td>-0.6297</td>\n",
              "      <td>0.6103</td>\n",
              "      <td>0.0223</td>\n",
              "      <td>-1.3240</td>\n",
              "      <td>-0.3174</td>\n",
              "      <td>-0.6417</td>\n",
              "      <td>-0.2187</td>\n",
              "      <td>-1.4080</td>\n",
              "      <td>0.6931</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>id_0015fd391</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>48</td>\n",
              "      <td>D1</td>\n",
              "      <td>8c7f86626</td>\n",
              "      <td>-0.5138</td>\n",
              "      <td>-0.2491</td>\n",
              "      <td>-0.2656</td>\n",
              "      <td>0.5288</td>\n",
              "      <td>4.0620</td>\n",
              "      <td>-0.8095</td>\n",
              "      <td>-1.9590</td>\n",
              "      <td>0.1792</td>\n",
              "      <td>-0.1321</td>\n",
              "      <td>-1.0600</td>\n",
              "      <td>-0.8269</td>\n",
              "      <td>-0.3584</td>\n",
              "      <td>-0.8511</td>\n",
              "      <td>-0.5844</td>\n",
              "      <td>-2.5690</td>\n",
              "      <td>0.8183</td>\n",
              "      <td>-0.0532</td>\n",
              "      <td>-0.8554</td>\n",
              "      <td>0.1160</td>\n",
              "      <td>-2.3520</td>\n",
              "      <td>2.1200</td>\n",
              "      <td>-1.1580</td>\n",
              "      <td>-0.7191</td>\n",
              "      <td>-0.8004</td>\n",
              "      <td>-1.4670</td>\n",
              "      <td>-0.0107</td>\n",
              "      <td>-0.8995</td>\n",
              "      <td>0.2406</td>\n",
              "      <td>-0.2479</td>\n",
              "      <td>-1.0890</td>\n",
              "      <td>-0.7575</td>\n",
              "      <td>0.0881</td>\n",
              "      <td>-2.7370</td>\n",
              "      <td>0.8745</td>\n",
              "      <td>0.5787</td>\n",
              "      <td>...</td>\n",
              "      <td>-2.1220</td>\n",
              "      <td>-0.3752</td>\n",
              "      <td>-2.3820</td>\n",
              "      <td>-3.7350</td>\n",
              "      <td>-2.9740</td>\n",
              "      <td>-1.4930</td>\n",
              "      <td>-1.6600</td>\n",
              "      <td>-3.1660</td>\n",
              "      <td>0.2816</td>\n",
              "      <td>-0.2990</td>\n",
              "      <td>-1.1870</td>\n",
              "      <td>-0.5044</td>\n",
              "      <td>-1.7750</td>\n",
              "      <td>-1.6120</td>\n",
              "      <td>-0.9215</td>\n",
              "      <td>-1.0810</td>\n",
              "      <td>-3.0520</td>\n",
              "      <td>-3.4470</td>\n",
              "      <td>-2.7740</td>\n",
              "      <td>-1.8460</td>\n",
              "      <td>-0.5568</td>\n",
              "      <td>-3.3960</td>\n",
              "      <td>-2.9510</td>\n",
              "      <td>-1.1550</td>\n",
              "      <td>-3.2620</td>\n",
              "      <td>-1.5390</td>\n",
              "      <td>-2.4600</td>\n",
              "      <td>-0.9417</td>\n",
              "      <td>-1.5550</td>\n",
              "      <td>0.2431</td>\n",
              "      <td>-2.0990</td>\n",
              "      <td>-0.6441</td>\n",
              "      <td>-5.6300</td>\n",
              "      <td>-1.3780</td>\n",
              "      <td>-0.8632</td>\n",
              "      <td>-1.2880</td>\n",
              "      <td>-1.6210</td>\n",
              "      <td>-0.8784</td>\n",
              "      <td>-0.3876</td>\n",
              "      <td>-0.8154</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>id_001626bd3</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>72</td>\n",
              "      <td>D2</td>\n",
              "      <td>7cbed3131</td>\n",
              "      <td>-0.3254</td>\n",
              "      <td>-0.4009</td>\n",
              "      <td>0.9700</td>\n",
              "      <td>0.6919</td>\n",
              "      <td>1.4180</td>\n",
              "      <td>-0.8244</td>\n",
              "      <td>-0.2800</td>\n",
              "      <td>-0.1498</td>\n",
              "      <td>-0.8789</td>\n",
              "      <td>0.8630</td>\n",
              "      <td>-0.2219</td>\n",
              "      <td>-0.5121</td>\n",
              "      <td>-0.9577</td>\n",
              "      <td>1.1750</td>\n",
              "      <td>0.2042</td>\n",
              "      <td>0.1970</td>\n",
              "      <td>0.1244</td>\n",
              "      <td>-1.7090</td>\n",
              "      <td>-0.3543</td>\n",
              "      <td>-0.5160</td>\n",
              "      <td>-0.3330</td>\n",
              "      <td>-0.2685</td>\n",
              "      <td>0.7649</td>\n",
              "      <td>0.2057</td>\n",
              "      <td>1.3720</td>\n",
              "      <td>0.6835</td>\n",
              "      <td>0.8056</td>\n",
              "      <td>-0.3754</td>\n",
              "      <td>-1.2090</td>\n",
              "      <td>0.2965</td>\n",
              "      <td>-0.0712</td>\n",
              "      <td>0.6389</td>\n",
              "      <td>0.6674</td>\n",
              "      <td>-0.0783</td>\n",
              "      <td>1.1740</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.2274</td>\n",
              "      <td>0.3215</td>\n",
              "      <td>0.1535</td>\n",
              "      <td>-0.4640</td>\n",
              "      <td>-0.5943</td>\n",
              "      <td>0.3973</td>\n",
              "      <td>0.1500</td>\n",
              "      <td>0.5178</td>\n",
              "      <td>0.5159</td>\n",
              "      <td>0.6091</td>\n",
              "      <td>0.1813</td>\n",
              "      <td>-0.4249</td>\n",
              "      <td>0.7832</td>\n",
              "      <td>0.6529</td>\n",
              "      <td>0.5648</td>\n",
              "      <td>0.4817</td>\n",
              "      <td>0.0587</td>\n",
              "      <td>0.5303</td>\n",
              "      <td>0.6376</td>\n",
              "      <td>-0.3966</td>\n",
              "      <td>-1.4950</td>\n",
              "      <td>-0.9625</td>\n",
              "      <td>-0.0541</td>\n",
              "      <td>0.6273</td>\n",
              "      <td>0.4563</td>\n",
              "      <td>0.0698</td>\n",
              "      <td>0.8134</td>\n",
              "      <td>0.1924</td>\n",
              "      <td>0.6054</td>\n",
              "      <td>-0.1824</td>\n",
              "      <td>0.0042</td>\n",
              "      <td>0.0048</td>\n",
              "      <td>0.6670</td>\n",
              "      <td>1.0690</td>\n",
              "      <td>0.5523</td>\n",
              "      <td>-0.3031</td>\n",
              "      <td>0.1094</td>\n",
              "      <td>0.2885</td>\n",
              "      <td>-0.3786</td>\n",
              "      <td>0.7125</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 877 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "             id tratamento  tempo dose  ...    c-96    c-97    c-98    c-99\n",
              "0  id_000644bb2  com_droga     24   D1  ... -0.3981  0.2139  0.3801  0.4176\n",
              "1  id_000779bfc  com_droga     72   D1  ...  0.1522  0.1241  0.6077  0.7371\n",
              "2  id_000a6266a  com_droga     48   D1  ... -0.6417 -0.2187 -1.4080  0.6931\n",
              "3  id_0015fd391  com_droga     48   D1  ... -1.6210 -0.8784 -0.3876 -0.8154\n",
              "4  id_001626bd3  com_droga     72   D2  ...  0.1094  0.2885 -0.3786  0.7125\n",
              "\n",
              "[5 rows x 877 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "tqnl9GNksy_T",
        "outputId": "9b883f14-1cc2-47aa-cf67-e5d2f0a19ce5"
      },
      "source": [
        "dados.shape"
      ],
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(23814, 877)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "dm6756Spsmhj",
        "outputId": "07bc16ef-bafe-4fd9-b214-11f5bf3671b9"
      },
      "source": [
        "dados['tratamento']\n",
        "dados['tratamento'].unique()"
      ],
      "execution_count": 9,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array(['com_droga', 'com_controle'], dtype=object)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "GQSUBk6NtBTp",
        "outputId": "b21c0d92-5b51-4a45-f014-a757fa4e15d5"
      },
      "source": [
        "dados['tempo'].unique()"
      ],
      "execution_count": 10,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array([24, 72, 48])"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "mNlBZcRGtC4k",
        "outputId": "4d177c66-616b-404f-ed8b-9837e88c0c22"
      },
      "source": [
        "dados['dose'].unique()"
      ],
      "execution_count": 11,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array(['D1', 'D2'], dtype=object)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "tmYCE8YytEKQ",
        "outputId": "f9479cfa-7b45-4cbb-d6aa-b469fb33a42d"
      },
      "source": [
        "dados['droga'].unique()"
      ],
      "execution_count": 12,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array(['b68db1d53', 'df89a8e5a', '18bb41b2c', ..., '573c787a2',\n",
              "       'b2fe3eca7', 'dd4a96d16'], dtype=object)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 12
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "mdDpg8Setnla",
        "outputId": "f5f3ed95-1091-4f67-d8e8-8ebd67e06671"
      },
      "source": [
        "dados['g-0'].unique()"
      ],
      "execution_count": 13,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array([ 1.062 ,  0.0743,  0.628 , ...,  0.3942,  0.666 , -0.8598])"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "W8nPi05ct6J5",
        "outputId": "41827ed9-99f1-41e9-fdd1-53e565b0f42f"
      },
      "source": [
        "# frequencia dos dados da coluna tratamento\n",
        "dados.value_counts(['tratamento'])"
      ],
      "execution_count": 14,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "tratamento  \n",
              "com_droga       21948\n",
              "com_controle     1866\n",
              "dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 14
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "5hwVh9feuVeZ"
      },
      "source": [
        "### Desafio 01: Investigar pq a classe tratamento é tão desbalanceada?"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 112
        },
        "id": "mdTr3uUvLNN3",
        "outputId": "68ed7901-acb8-45d5-8db6-078a58a66996"
      },
      "source": [
        "# relação bivariada\n",
        "x = pd.crosstab(dados['droga'], dados['tratamento'])\n",
        "x[x['com_controle'] >= 1]\n",
        "\n",
        "## experimento - com_controle recebeu label 'cacb2b860' na coluna 'droga'\n",
        "## i.e. podemos ignorar a coluna tratamento em futuras comparações multi variadas com  col.'droga'"
      ],
      "execution_count": 15,
      "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>tratamento</th>\n",
              "      <th>com_controle</th>\n",
              "      <th>com_droga</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>droga</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>cacb2b860</th>\n",
              "      <td>1866</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "tratamento  com_controle  com_droga\n",
              "droga                              \n",
              "cacb2b860           1866          0"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 15
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "-CLz5MWcT3Fl",
        "outputId": "80f460cc-f54c-49cd-b91c-87d0260c2c6d"
      },
      "source": [
        "# tamanho dos ensaios do experimento por 'dose' e 'tempo'\n",
        "dados.groupby(['dose', 'tempo', 'tratamento']).size()"
      ],
      "execution_count": 16,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "dose  tempo  tratamento  \n",
              "D1    24     com_controle     301\n",
              "             com_droga       3585\n",
              "      48     com_controle     343\n",
              "             com_droga       4011\n",
              "      72     com_controle     307\n",
              "             com_droga       3600\n",
              "D2    24     com_controle     305\n",
              "             com_droga       3581\n",
              "      48     com_controle     305\n",
              "             com_droga       3591\n",
              "      72     com_controle     305\n",
              "             com_droga       3580\n",
              "dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 16
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 256
        },
        "id": "VZZyXDgNVdAe",
        "outputId": "2c10fbba-171f-466a-eb38-176572f90100"
      },
      "source": [
        "df_d1_24 = dados[(dados['dose'] == 'D1') & (dados['tempo'] == 24)]\n",
        "df_d1_24.head()"
      ],
      "execution_count": 17,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>id</th>\n",
              "      <th>tratamento</th>\n",
              "      <th>tempo</th>\n",
              "      <th>dose</th>\n",
              "      <th>droga</th>\n",
              "      <th>g-0</th>\n",
              "      <th>g-1</th>\n",
              "      <th>g-2</th>\n",
              "      <th>g-3</th>\n",
              "      <th>g-4</th>\n",
              "      <th>g-5</th>\n",
              "      <th>g-6</th>\n",
              "      <th>g-7</th>\n",
              "      <th>g-8</th>\n",
              "      <th>g-9</th>\n",
              "      <th>g-10</th>\n",
              "      <th>g-11</th>\n",
              "      <th>g-12</th>\n",
              "      <th>g-13</th>\n",
              "      <th>g-14</th>\n",
              "      <th>g-15</th>\n",
              "      <th>g-16</th>\n",
              "      <th>g-17</th>\n",
              "      <th>g-18</th>\n",
              "      <th>g-19</th>\n",
              "      <th>g-20</th>\n",
              "      <th>g-21</th>\n",
              "      <th>g-22</th>\n",
              "      <th>g-23</th>\n",
              "      <th>g-24</th>\n",
              "      <th>g-25</th>\n",
              "      <th>g-26</th>\n",
              "      <th>g-27</th>\n",
              "      <th>g-28</th>\n",
              "      <th>g-29</th>\n",
              "      <th>g-30</th>\n",
              "      <th>g-31</th>\n",
              "      <th>g-32</th>\n",
              "      <th>g-33</th>\n",
              "      <th>g-34</th>\n",
              "      <th>...</th>\n",
              "      <th>c-60</th>\n",
              "      <th>c-61</th>\n",
              "      <th>c-62</th>\n",
              "      <th>c-63</th>\n",
              "      <th>c-64</th>\n",
              "      <th>c-65</th>\n",
              "      <th>c-66</th>\n",
              "      <th>c-67</th>\n",
              "      <th>c-68</th>\n",
              "      <th>c-69</th>\n",
              "      <th>c-70</th>\n",
              "      <th>c-71</th>\n",
              "      <th>c-72</th>\n",
              "      <th>c-73</th>\n",
              "      <th>c-74</th>\n",
              "      <th>c-75</th>\n",
              "      <th>c-76</th>\n",
              "      <th>c-77</th>\n",
              "      <th>c-78</th>\n",
              "      <th>c-79</th>\n",
              "      <th>c-80</th>\n",
              "      <th>c-81</th>\n",
              "      <th>c-82</th>\n",
              "      <th>c-83</th>\n",
              "      <th>c-84</th>\n",
              "      <th>c-85</th>\n",
              "      <th>c-86</th>\n",
              "      <th>c-87</th>\n",
              "      <th>c-88</th>\n",
              "      <th>c-89</th>\n",
              "      <th>c-90</th>\n",
              "      <th>c-91</th>\n",
              "      <th>c-92</th>\n",
              "      <th>c-93</th>\n",
              "      <th>c-94</th>\n",
              "      <th>c-95</th>\n",
              "      <th>c-96</th>\n",
              "      <th>c-97</th>\n",
              "      <th>c-98</th>\n",
              "      <th>c-99</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>id_000644bb2</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>b68db1d53</td>\n",
              "      <td>1.0620</td>\n",
              "      <td>0.5577</td>\n",
              "      <td>-0.2479</td>\n",
              "      <td>-0.6208</td>\n",
              "      <td>-0.1944</td>\n",
              "      <td>-1.0120</td>\n",
              "      <td>-1.0220</td>\n",
              "      <td>-0.0326</td>\n",
              "      <td>0.5548</td>\n",
              "      <td>-0.0921</td>\n",
              "      <td>1.1830</td>\n",
              "      <td>0.1530</td>\n",
              "      <td>0.5574</td>\n",
              "      <td>-0.4015</td>\n",
              "      <td>0.1789</td>\n",
              "      <td>-0.6528</td>\n",
              "      <td>-0.7969</td>\n",
              "      <td>0.6342</td>\n",
              "      <td>0.1778</td>\n",
              "      <td>-0.3694</td>\n",
              "      <td>-0.5688</td>\n",
              "      <td>-1.1360</td>\n",
              "      <td>-1.1880</td>\n",
              "      <td>0.6940</td>\n",
              "      <td>0.4393</td>\n",
              "      <td>0.2664</td>\n",
              "      <td>0.1907</td>\n",
              "      <td>0.1628</td>\n",
              "      <td>-0.2853</td>\n",
              "      <td>0.5819</td>\n",
              "      <td>0.2934</td>\n",
              "      <td>-0.5584</td>\n",
              "      <td>-0.0916</td>\n",
              "      <td>-0.3010</td>\n",
              "      <td>-0.1537</td>\n",
              "      <td>...</td>\n",
              "      <td>0.4805</td>\n",
              "      <td>0.4965</td>\n",
              "      <td>0.3680</td>\n",
              "      <td>0.8427</td>\n",
              "      <td>0.1042</td>\n",
              "      <td>0.1403</td>\n",
              "      <td>0.1758</td>\n",
              "      <td>1.2570</td>\n",
              "      <td>-0.5979</td>\n",
              "      <td>1.2250</td>\n",
              "      <td>-0.0553</td>\n",
              "      <td>0.7351</td>\n",
              "      <td>0.5810</td>\n",
              "      <td>0.9590</td>\n",
              "      <td>0.2427</td>\n",
              "      <td>0.0495</td>\n",
              "      <td>0.4141</td>\n",
              "      <td>0.8432</td>\n",
              "      <td>0.6162</td>\n",
              "      <td>-0.7318</td>\n",
              "      <td>1.2120</td>\n",
              "      <td>0.6362</td>\n",
              "      <td>-0.4427</td>\n",
              "      <td>0.1288</td>\n",
              "      <td>1.4840</td>\n",
              "      <td>0.1799</td>\n",
              "      <td>0.5367</td>\n",
              "      <td>-0.1111</td>\n",
              "      <td>-1.0120</td>\n",
              "      <td>0.6685</td>\n",
              "      <td>0.2862</td>\n",
              "      <td>0.2584</td>\n",
              "      <td>0.8076</td>\n",
              "      <td>0.5523</td>\n",
              "      <td>-0.1912</td>\n",
              "      <td>0.6584</td>\n",
              "      <td>-0.3981</td>\n",
              "      <td>0.2139</td>\n",
              "      <td>0.3801</td>\n",
              "      <td>0.4176</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>id_001762a82</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>e06749542</td>\n",
              "      <td>-0.6111</td>\n",
              "      <td>0.2941</td>\n",
              "      <td>-0.9901</td>\n",
              "      <td>0.2277</td>\n",
              "      <td>1.2810</td>\n",
              "      <td>0.5203</td>\n",
              "      <td>0.0543</td>\n",
              "      <td>-0.2225</td>\n",
              "      <td>-0.1586</td>\n",
              "      <td>0.4289</td>\n",
              "      <td>0.0361</td>\n",
              "      <td>0.3543</td>\n",
              "      <td>0.8310</td>\n",
              "      <td>-0.9129</td>\n",
              "      <td>0.7677</td>\n",
              "      <td>-0.2512</td>\n",
              "      <td>0.7087</td>\n",
              "      <td>0.0481</td>\n",
              "      <td>-0.4486</td>\n",
              "      <td>1.2570</td>\n",
              "      <td>1.2550</td>\n",
              "      <td>0.3359</td>\n",
              "      <td>-0.5103</td>\n",
              "      <td>-0.2993</td>\n",
              "      <td>-1.1950</td>\n",
              "      <td>-0.3208</td>\n",
              "      <td>-0.1187</td>\n",
              "      <td>1.0030</td>\n",
              "      <td>0.9133</td>\n",
              "      <td>0.0376</td>\n",
              "      <td>0.3015</td>\n",
              "      <td>-0.9578</td>\n",
              "      <td>0.5354</td>\n",
              "      <td>1.1360</td>\n",
              "      <td>1.1310</td>\n",
              "      <td>...</td>\n",
              "      <td>0.6701</td>\n",
              "      <td>2.0780</td>\n",
              "      <td>1.3350</td>\n",
              "      <td>0.9889</td>\n",
              "      <td>0.5017</td>\n",
              "      <td>2.0020</td>\n",
              "      <td>0.8918</td>\n",
              "      <td>0.4290</td>\n",
              "      <td>0.0716</td>\n",
              "      <td>0.8465</td>\n",
              "      <td>0.6596</td>\n",
              "      <td>1.3710</td>\n",
              "      <td>1.0580</td>\n",
              "      <td>1.7570</td>\n",
              "      <td>1.0030</td>\n",
              "      <td>0.2152</td>\n",
              "      <td>1.6920</td>\n",
              "      <td>-0.2930</td>\n",
              "      <td>1.4590</td>\n",
              "      <td>1.0950</td>\n",
              "      <td>0.5854</td>\n",
              "      <td>1.7270</td>\n",
              "      <td>0.5580</td>\n",
              "      <td>1.3090</td>\n",
              "      <td>1.0100</td>\n",
              "      <td>0.6980</td>\n",
              "      <td>0.5455</td>\n",
              "      <td>1.0170</td>\n",
              "      <td>1.2910</td>\n",
              "      <td>1.5430</td>\n",
              "      <td>1.8390</td>\n",
              "      <td>1.1570</td>\n",
              "      <td>-1.0120</td>\n",
              "      <td>1.9010</td>\n",
              "      <td>1.4270</td>\n",
              "      <td>0.4519</td>\n",
              "      <td>1.2120</td>\n",
              "      <td>0.3765</td>\n",
              "      <td>0.7848</td>\n",
              "      <td>1.3990</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>id_00762e877</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>0c3e1a7e3</td>\n",
              "      <td>-0.4026</td>\n",
              "      <td>0.1662</td>\n",
              "      <td>-0.6307</td>\n",
              "      <td>-0.4438</td>\n",
              "      <td>-0.5992</td>\n",
              "      <td>-0.2523</td>\n",
              "      <td>-1.3770</td>\n",
              "      <td>-0.7637</td>\n",
              "      <td>-1.4880</td>\n",
              "      <td>-0.1970</td>\n",
              "      <td>-0.5229</td>\n",
              "      <td>0.2942</td>\n",
              "      <td>-0.6387</td>\n",
              "      <td>-1.0830</td>\n",
              "      <td>0.2464</td>\n",
              "      <td>0.6330</td>\n",
              "      <td>0.2837</td>\n",
              "      <td>0.0104</td>\n",
              "      <td>-0.0121</td>\n",
              "      <td>-0.1858</td>\n",
              "      <td>-0.6253</td>\n",
              "      <td>0.5023</td>\n",
              "      <td>0.4164</td>\n",
              "      <td>-0.4699</td>\n",
              "      <td>0.3135</td>\n",
              "      <td>-0.2699</td>\n",
              "      <td>0.6885</td>\n",
              "      <td>0.2043</td>\n",
              "      <td>-0.1817</td>\n",
              "      <td>-0.8334</td>\n",
              "      <td>0.7470</td>\n",
              "      <td>0.3260</td>\n",
              "      <td>0.0979</td>\n",
              "      <td>0.3905</td>\n",
              "      <td>-1.2800</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.1907</td>\n",
              "      <td>-1.1300</td>\n",
              "      <td>0.6586</td>\n",
              "      <td>0.5898</td>\n",
              "      <td>-0.5857</td>\n",
              "      <td>0.7819</td>\n",
              "      <td>0.0693</td>\n",
              "      <td>-0.3232</td>\n",
              "      <td>0.6517</td>\n",
              "      <td>-0.3393</td>\n",
              "      <td>-0.4067</td>\n",
              "      <td>0.6806</td>\n",
              "      <td>0.3383</td>\n",
              "      <td>0.6075</td>\n",
              "      <td>-0.1051</td>\n",
              "      <td>0.3936</td>\n",
              "      <td>-0.2994</td>\n",
              "      <td>0.5334</td>\n",
              "      <td>0.3730</td>\n",
              "      <td>0.3277</td>\n",
              "      <td>-1.7540</td>\n",
              "      <td>-0.2032</td>\n",
              "      <td>-0.2044</td>\n",
              "      <td>0.7913</td>\n",
              "      <td>-0.0901</td>\n",
              "      <td>-0.6183</td>\n",
              "      <td>-0.0817</td>\n",
              "      <td>0.5161</td>\n",
              "      <td>-0.2544</td>\n",
              "      <td>0.5790</td>\n",
              "      <td>-0.6357</td>\n",
              "      <td>-0.1639</td>\n",
              "      <td>-0.0852</td>\n",
              "      <td>0.1438</td>\n",
              "      <td>0.0083</td>\n",
              "      <td>0.7504</td>\n",
              "      <td>0.5418</td>\n",
              "      <td>0.8407</td>\n",
              "      <td>0.3193</td>\n",
              "      <td>0.4817</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>id_0079af0fb</td>\n",
              "      <td>com_controle</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>cacb2b860</td>\n",
              "      <td>-0.1636</td>\n",
              "      <td>-1.8230</td>\n",
              "      <td>-0.5211</td>\n",
              "      <td>0.3054</td>\n",
              "      <td>-1.1280</td>\n",
              "      <td>0.6041</td>\n",
              "      <td>0.3856</td>\n",
              "      <td>-0.1670</td>\n",
              "      <td>-0.5400</td>\n",
              "      <td>0.2721</td>\n",
              "      <td>-0.2479</td>\n",
              "      <td>0.0761</td>\n",
              "      <td>-0.4054</td>\n",
              "      <td>2.9760</td>\n",
              "      <td>-0.7679</td>\n",
              "      <td>0.6995</td>\n",
              "      <td>0.0752</td>\n",
              "      <td>0.5943</td>\n",
              "      <td>0.4266</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>1.0410</td>\n",
              "      <td>-0.1131</td>\n",
              "      <td>0.6593</td>\n",
              "      <td>-0.6890</td>\n",
              "      <td>0.5115</td>\n",
              "      <td>-0.2512</td>\n",
              "      <td>-0.8775</td>\n",
              "      <td>-1.3810</td>\n",
              "      <td>0.1419</td>\n",
              "      <td>-0.0363</td>\n",
              "      <td>0.2559</td>\n",
              "      <td>2.5290</td>\n",
              "      <td>0.2853</td>\n",
              "      <td>1.4690</td>\n",
              "      <td>-0.3626</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.3420</td>\n",
              "      <td>0.2815</td>\n",
              "      <td>-0.7493</td>\n",
              "      <td>-0.2701</td>\n",
              "      <td>0.1205</td>\n",
              "      <td>0.2396</td>\n",
              "      <td>0.3506</td>\n",
              "      <td>-0.9233</td>\n",
              "      <td>0.2490</td>\n",
              "      <td>-0.0824</td>\n",
              "      <td>0.4841</td>\n",
              "      <td>1.1940</td>\n",
              "      <td>-1.1650</td>\n",
              "      <td>-0.4853</td>\n",
              "      <td>1.1080</td>\n",
              "      <td>-0.5979</td>\n",
              "      <td>0.7438</td>\n",
              "      <td>0.2050</td>\n",
              "      <td>-0.2761</td>\n",
              "      <td>-0.1748</td>\n",
              "      <td>0.3385</td>\n",
              "      <td>-0.3500</td>\n",
              "      <td>-0.0309</td>\n",
              "      <td>-0.0409</td>\n",
              "      <td>-0.0735</td>\n",
              "      <td>0.2732</td>\n",
              "      <td>-1.2100</td>\n",
              "      <td>0.0089</td>\n",
              "      <td>0.0317</td>\n",
              "      <td>0.4721</td>\n",
              "      <td>-0.3880</td>\n",
              "      <td>-0.6828</td>\n",
              "      <td>-0.6594</td>\n",
              "      <td>-0.2043</td>\n",
              "      <td>0.3571</td>\n",
              "      <td>-0.1319</td>\n",
              "      <td>0.2187</td>\n",
              "      <td>0.0737</td>\n",
              "      <td>0.6498</td>\n",
              "      <td>-1.4820</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\n",
              "      <td>id_0079d45d3</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>292ab2c28</td>\n",
              "      <td>1.6310</td>\n",
              "      <td>-2.1430</td>\n",
              "      <td>-0.0943</td>\n",
              "      <td>-1.1990</td>\n",
              "      <td>0.4869</td>\n",
              "      <td>-0.0935</td>\n",
              "      <td>1.2090</td>\n",
              "      <td>-3.8910</td>\n",
              "      <td>-1.5450</td>\n",
              "      <td>-2.2870</td>\n",
              "      <td>-2.2040</td>\n",
              "      <td>-0.8888</td>\n",
              "      <td>-1.1730</td>\n",
              "      <td>0.0444</td>\n",
              "      <td>-3.9430</td>\n",
              "      <td>0.1673</td>\n",
              "      <td>-0.9502</td>\n",
              "      <td>-1.1750</td>\n",
              "      <td>0.1686</td>\n",
              "      <td>3.8480</td>\n",
              "      <td>-2.9760</td>\n",
              "      <td>-0.0389</td>\n",
              "      <td>1.6330</td>\n",
              "      <td>-0.0655</td>\n",
              "      <td>1.3810</td>\n",
              "      <td>-2.4340</td>\n",
              "      <td>-1.8040</td>\n",
              "      <td>0.3945</td>\n",
              "      <td>-1.2080</td>\n",
              "      <td>-0.1963</td>\n",
              "      <td>-2.0170</td>\n",
              "      <td>0.6004</td>\n",
              "      <td>-2.5860</td>\n",
              "      <td>-1.4550</td>\n",
              "      <td>-0.4141</td>\n",
              "      <td>...</td>\n",
              "      <td>-1.8210</td>\n",
              "      <td>-1.2440</td>\n",
              "      <td>-2.5430</td>\n",
              "      <td>-6.4260</td>\n",
              "      <td>-2.5320</td>\n",
              "      <td>-4.3570</td>\n",
              "      <td>-4.7560</td>\n",
              "      <td>-0.8781</td>\n",
              "      <td>-3.7800</td>\n",
              "      <td>-1.6340</td>\n",
              "      <td>-3.9660</td>\n",
              "      <td>-1.7890</td>\n",
              "      <td>-3.2480</td>\n",
              "      <td>-2.6720</td>\n",
              "      <td>-1.3250</td>\n",
              "      <td>-2.3430</td>\n",
              "      <td>-3.2220</td>\n",
              "      <td>-2.5160</td>\n",
              "      <td>-2.3410</td>\n",
              "      <td>-2.4620</td>\n",
              "      <td>-3.8760</td>\n",
              "      <td>-2.2450</td>\n",
              "      <td>-3.9450</td>\n",
              "      <td>-1.7400</td>\n",
              "      <td>-4.4320</td>\n",
              "      <td>-3.6740</td>\n",
              "      <td>-2.9810</td>\n",
              "      <td>-4.5770</td>\n",
              "      <td>-1.8620</td>\n",
              "      <td>-1.9120</td>\n",
              "      <td>-2.9240</td>\n",
              "      <td>-5.7720</td>\n",
              "      <td>-1.9360</td>\n",
              "      <td>-2.8860</td>\n",
              "      <td>-2.7680</td>\n",
              "      <td>-2.4840</td>\n",
              "      <td>-2.7020</td>\n",
              "      <td>-2.2530</td>\n",
              "      <td>-4.8360</td>\n",
              "      <td>-0.6461</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",
              "5   id_001762a82     com_droga     24   D1  ...  1.2120  0.3765  0.7848  1.3990\n",
              "36  id_00762e877     com_droga     24   D1  ...  0.5418  0.8407  0.3193  0.4817\n",
              "38  id_0079af0fb  com_controle     24   D1  ...  0.2187  0.0737  0.6498 -1.4820\n",
              "39  id_0079d45d3     com_droga     24   D1  ... -2.7020 -2.2530 -4.8360 -0.6461\n",
              "\n",
              "[5 rows x 877 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 17
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "v86FRH86upEp"
      },
      "source": [
        "### Desafio 02: Plotar as 5 últimas linhas da tabela\n",
        "#### 02.1: últimas 10 linhas\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 412
        },
        "id": "4cOimthgumTT",
        "outputId": "ceaf1e61-f109-4576-a0c0-531734952112"
      },
      "source": [
        "dados.tail(n = 10)"
      ],
      "execution_count": 18,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>id</th>\n",
              "      <th>tratamento</th>\n",
              "      <th>tempo</th>\n",
              "      <th>dose</th>\n",
              "      <th>droga</th>\n",
              "      <th>g-0</th>\n",
              "      <th>g-1</th>\n",
              "      <th>g-2</th>\n",
              "      <th>g-3</th>\n",
              "      <th>g-4</th>\n",
              "      <th>g-5</th>\n",
              "      <th>g-6</th>\n",
              "      <th>g-7</th>\n",
              "      <th>g-8</th>\n",
              "      <th>g-9</th>\n",
              "      <th>g-10</th>\n",
              "      <th>g-11</th>\n",
              "      <th>g-12</th>\n",
              "      <th>g-13</th>\n",
              "      <th>g-14</th>\n",
              "      <th>g-15</th>\n",
              "      <th>g-16</th>\n",
              "      <th>g-17</th>\n",
              "      <th>g-18</th>\n",
              "      <th>g-19</th>\n",
              "      <th>g-20</th>\n",
              "      <th>g-21</th>\n",
              "      <th>g-22</th>\n",
              "      <th>g-23</th>\n",
              "      <th>g-24</th>\n",
              "      <th>g-25</th>\n",
              "      <th>g-26</th>\n",
              "      <th>g-27</th>\n",
              "      <th>g-28</th>\n",
              "      <th>g-29</th>\n",
              "      <th>g-30</th>\n",
              "      <th>g-31</th>\n",
              "      <th>g-32</th>\n",
              "      <th>g-33</th>\n",
              "      <th>g-34</th>\n",
              "      <th>...</th>\n",
              "      <th>c-60</th>\n",
              "      <th>c-61</th>\n",
              "      <th>c-62</th>\n",
              "      <th>c-63</th>\n",
              "      <th>c-64</th>\n",
              "      <th>c-65</th>\n",
              "      <th>c-66</th>\n",
              "      <th>c-67</th>\n",
              "      <th>c-68</th>\n",
              "      <th>c-69</th>\n",
              "      <th>c-70</th>\n",
              "      <th>c-71</th>\n",
              "      <th>c-72</th>\n",
              "      <th>c-73</th>\n",
              "      <th>c-74</th>\n",
              "      <th>c-75</th>\n",
              "      <th>c-76</th>\n",
              "      <th>c-77</th>\n",
              "      <th>c-78</th>\n",
              "      <th>c-79</th>\n",
              "      <th>c-80</th>\n",
              "      <th>c-81</th>\n",
              "      <th>c-82</th>\n",
              "      <th>c-83</th>\n",
              "      <th>c-84</th>\n",
              "      <th>c-85</th>\n",
              "      <th>c-86</th>\n",
              "      <th>c-87</th>\n",
              "      <th>c-88</th>\n",
              "      <th>c-89</th>\n",
              "      <th>c-90</th>\n",
              "      <th>c-91</th>\n",
              "      <th>c-92</th>\n",
              "      <th>c-93</th>\n",
              "      <th>c-94</th>\n",
              "      <th>c-95</th>\n",
              "      <th>c-96</th>\n",
              "      <th>c-97</th>\n",
              "      <th>c-98</th>\n",
              "      <th>c-99</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>23804</th>\n",
              "      <td>id_fff506720</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>74515bfd2</td>\n",
              "      <td>-1.0140</td>\n",
              "      <td>0.1709</td>\n",
              "      <td>-0.4291</td>\n",
              "      <td>1.8750</td>\n",
              "      <td>0.9859</td>\n",
              "      <td>0.3009</td>\n",
              "      <td>0.0650</td>\n",
              "      <td>-1.3920</td>\n",
              "      <td>-1.0410</td>\n",
              "      <td>1.4790</td>\n",
              "      <td>-0.4459</td>\n",
              "      <td>0.7377</td>\n",
              "      <td>-0.0037</td>\n",
              "      <td>-0.0995</td>\n",
              "      <td>-0.2393</td>\n",
              "      <td>-1.1670</td>\n",
              "      <td>-0.9359</td>\n",
              "      <td>1.1260</td>\n",
              "      <td>0.3450</td>\n",
              "      <td>-1.0780</td>\n",
              "      <td>2.7230</td>\n",
              "      <td>0.5255</td>\n",
              "      <td>0.6368</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>-0.1172</td>\n",
              "      <td>0.8256</td>\n",
              "      <td>0.2120</td>\n",
              "      <td>2.1500</td>\n",
              "      <td>0.5925</td>\n",
              "      <td>-0.7637</td>\n",
              "      <td>0.1157</td>\n",
              "      <td>0.0919</td>\n",
              "      <td>-0.5855</td>\n",
              "      <td>-0.6233</td>\n",
              "      <td>-0.7982</td>\n",
              "      <td>...</td>\n",
              "      <td>-1.1130</td>\n",
              "      <td>0.6549</td>\n",
              "      <td>-1.0250</td>\n",
              "      <td>-2.6910</td>\n",
              "      <td>-0.6001</td>\n",
              "      <td>-1.3260</td>\n",
              "      <td>-1.5960</td>\n",
              "      <td>-0.3137</td>\n",
              "      <td>-0.4209</td>\n",
              "      <td>-0.9542</td>\n",
              "      <td>-1.4760</td>\n",
              "      <td>-1.0180</td>\n",
              "      <td>-1.1360</td>\n",
              "      <td>0.1523</td>\n",
              "      <td>-1.0130</td>\n",
              "      <td>-0.4065</td>\n",
              "      <td>0.8502</td>\n",
              "      <td>-0.0978</td>\n",
              "      <td>-0.7339</td>\n",
              "      <td>-0.5680</td>\n",
              "      <td>-0.5700</td>\n",
              "      <td>0.7834</td>\n",
              "      <td>-2.5930</td>\n",
              "      <td>-2.1570</td>\n",
              "      <td>-0.7917</td>\n",
              "      <td>-0.9154</td>\n",
              "      <td>1.5140</td>\n",
              "      <td>-3.1070</td>\n",
              "      <td>-0.2346</td>\n",
              "      <td>-0.2662</td>\n",
              "      <td>-0.6730</td>\n",
              "      <td>0.3175</td>\n",
              "      <td>-1.5510</td>\n",
              "      <td>-1.2800</td>\n",
              "      <td>-0.7632</td>\n",
              "      <td>-0.6736</td>\n",
              "      <td>-0.4097</td>\n",
              "      <td>0.2282</td>\n",
              "      <td>-0.3213</td>\n",
              "      <td>-0.0836</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23805</th>\n",
              "      <td>id_fff6df1c5</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>48</td>\n",
              "      <td>D2</td>\n",
              "      <td>5628cb3ee</td>\n",
              "      <td>1.7380</td>\n",
              "      <td>-1.2900</td>\n",
              "      <td>-0.4533</td>\n",
              "      <td>-1.1640</td>\n",
              "      <td>-0.4841</td>\n",
              "      <td>-0.2392</td>\n",
              "      <td>-0.1774</td>\n",
              "      <td>-1.3980</td>\n",
              "      <td>-0.4059</td>\n",
              "      <td>0.1553</td>\n",
              "      <td>0.1083</td>\n",
              "      <td>-0.8020</td>\n",
              "      <td>-0.5039</td>\n",
              "      <td>-0.7167</td>\n",
              "      <td>-0.5016</td>\n",
              "      <td>-0.9369</td>\n",
              "      <td>-0.5864</td>\n",
              "      <td>-0.1009</td>\n",
              "      <td>0.8987</td>\n",
              "      <td>0.3389</td>\n",
              "      <td>-1.3460</td>\n",
              "      <td>-0.5087</td>\n",
              "      <td>-0.0892</td>\n",
              "      <td>-0.6559</td>\n",
              "      <td>0.0864</td>\n",
              "      <td>-0.6251</td>\n",
              "      <td>0.2471</td>\n",
              "      <td>-0.4523</td>\n",
              "      <td>-0.0389</td>\n",
              "      <td>1.0340</td>\n",
              "      <td>0.0796</td>\n",
              "      <td>-0.2560</td>\n",
              "      <td>-0.7851</td>\n",
              "      <td>-0.1687</td>\n",
              "      <td>-1.2890</td>\n",
              "      <td>...</td>\n",
              "      <td>0.2866</td>\n",
              "      <td>0.3854</td>\n",
              "      <td>-0.4986</td>\n",
              "      <td>0.2883</td>\n",
              "      <td>0.5843</td>\n",
              "      <td>0.0907</td>\n",
              "      <td>-0.9303</td>\n",
              "      <td>0.1981</td>\n",
              "      <td>0.6515</td>\n",
              "      <td>0.2877</td>\n",
              "      <td>0.4389</td>\n",
              "      <td>-0.3859</td>\n",
              "      <td>0.5203</td>\n",
              "      <td>-1.1070</td>\n",
              "      <td>2.3870</td>\n",
              "      <td>0.1820</td>\n",
              "      <td>-0.6434</td>\n",
              "      <td>-0.9722</td>\n",
              "      <td>-0.4200</td>\n",
              "      <td>-0.5693</td>\n",
              "      <td>1.0700</td>\n",
              "      <td>1.1110</td>\n",
              "      <td>-0.5117</td>\n",
              "      <td>-1.2130</td>\n",
              "      <td>0.3769</td>\n",
              "      <td>0.5296</td>\n",
              "      <td>1.0400</td>\n",
              "      <td>0.0587</td>\n",
              "      <td>1.0150</td>\n",
              "      <td>-0.7669</td>\n",
              "      <td>0.2865</td>\n",
              "      <td>0.5974</td>\n",
              "      <td>-0.2727</td>\n",
              "      <td>0.1188</td>\n",
              "      <td>1.0770</td>\n",
              "      <td>-1.0250</td>\n",
              "      <td>0.1516</td>\n",
              "      <td>0.4503</td>\n",
              "      <td>-0.6312</td>\n",
              "      <td>-0.8302</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23806</th>\n",
              "      <td>id_fff790a17</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>48</td>\n",
              "      <td>D2</td>\n",
              "      <td>47dd8f190</td>\n",
              "      <td>-0.1150</td>\n",
              "      <td>-0.8037</td>\n",
              "      <td>0.0988</td>\n",
              "      <td>-0.1301</td>\n",
              "      <td>0.2013</td>\n",
              "      <td>0.9126</td>\n",
              "      <td>0.2234</td>\n",
              "      <td>0.8321</td>\n",
              "      <td>0.0486</td>\n",
              "      <td>-0.4505</td>\n",
              "      <td>0.3666</td>\n",
              "      <td>-0.0418</td>\n",
              "      <td>0.5645</td>\n",
              "      <td>0.4406</td>\n",
              "      <td>0.5708</td>\n",
              "      <td>-0.0984</td>\n",
              "      <td>1.2150</td>\n",
              "      <td>-0.0770</td>\n",
              "      <td>0.4057</td>\n",
              "      <td>0.7522</td>\n",
              "      <td>-0.3141</td>\n",
              "      <td>-0.2469</td>\n",
              "      <td>-0.5490</td>\n",
              "      <td>-0.1521</td>\n",
              "      <td>0.5957</td>\n",
              "      <td>-0.0912</td>\n",
              "      <td>0.4107</td>\n",
              "      <td>-0.0944</td>\n",
              "      <td>-0.1861</td>\n",
              "      <td>0.5627</td>\n",
              "      <td>-0.0437</td>\n",
              "      <td>-0.5673</td>\n",
              "      <td>0.2384</td>\n",
              "      <td>0.5478</td>\n",
              "      <td>0.3555</td>\n",
              "      <td>...</td>\n",
              "      <td>0.1608</td>\n",
              "      <td>-0.2668</td>\n",
              "      <td>0.8981</td>\n",
              "      <td>-0.5505</td>\n",
              "      <td>0.5671</td>\n",
              "      <td>0.2905</td>\n",
              "      <td>0.8563</td>\n",
              "      <td>-0.4375</td>\n",
              "      <td>0.3678</td>\n",
              "      <td>0.3119</td>\n",
              "      <td>0.4316</td>\n",
              "      <td>-0.6997</td>\n",
              "      <td>0.5957</td>\n",
              "      <td>0.1860</td>\n",
              "      <td>0.3508</td>\n",
              "      <td>0.2853</td>\n",
              "      <td>1.0110</td>\n",
              "      <td>0.0014</td>\n",
              "      <td>-0.2718</td>\n",
              "      <td>-0.1950</td>\n",
              "      <td>1.0390</td>\n",
              "      <td>-0.3072</td>\n",
              "      <td>0.8025</td>\n",
              "      <td>-0.1202</td>\n",
              "      <td>-1.0380</td>\n",
              "      <td>0.9099</td>\n",
              "      <td>0.2493</td>\n",
              "      <td>-0.7423</td>\n",
              "      <td>0.3864</td>\n",
              "      <td>1.2630</td>\n",
              "      <td>0.2358</td>\n",
              "      <td>0.1086</td>\n",
              "      <td>-0.1686</td>\n",
              "      <td>-0.3482</td>\n",
              "      <td>0.4121</td>\n",
              "      <td>0.5728</td>\n",
              "      <td>1.2630</td>\n",
              "      <td>0.7823</td>\n",
              "      <td>-0.6947</td>\n",
              "      <td>0.7277</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23807</th>\n",
              "      <td>id_fff7e6992</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>48</td>\n",
              "      <td>D1</td>\n",
              "      <td>a28556d51</td>\n",
              "      <td>0.1420</td>\n",
              "      <td>-0.3696</td>\n",
              "      <td>-0.0093</td>\n",
              "      <td>-0.2495</td>\n",
              "      <td>-0.0175</td>\n",
              "      <td>0.0959</td>\n",
              "      <td>-0.2201</td>\n",
              "      <td>0.2443</td>\n",
              "      <td>0.4879</td>\n",
              "      <td>0.3432</td>\n",
              "      <td>0.4151</td>\n",
              "      <td>0.9056</td>\n",
              "      <td>0.3538</td>\n",
              "      <td>0.5246</td>\n",
              "      <td>-0.4441</td>\n",
              "      <td>-0.1605</td>\n",
              "      <td>-0.3720</td>\n",
              "      <td>-0.5619</td>\n",
              "      <td>-0.1409</td>\n",
              "      <td>0.1255</td>\n",
              "      <td>0.1214</td>\n",
              "      <td>-0.1975</td>\n",
              "      <td>-0.4367</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.4301</td>\n",
              "      <td>-0.7606</td>\n",
              "      <td>-0.0248</td>\n",
              "      <td>0.0270</td>\n",
              "      <td>-0.0367</td>\n",
              "      <td>-1.2480</td>\n",
              "      <td>0.0559</td>\n",
              "      <td>-0.0984</td>\n",
              "      <td>0.5537</td>\n",
              "      <td>0.1063</td>\n",
              "      <td>0.3893</td>\n",
              "      <td>...</td>\n",
              "      <td>0.5554</td>\n",
              "      <td>0.2225</td>\n",
              "      <td>-0.0903</td>\n",
              "      <td>0.9227</td>\n",
              "      <td>-0.0460</td>\n",
              "      <td>0.3756</td>\n",
              "      <td>1.0730</td>\n",
              "      <td>-0.6904</td>\n",
              "      <td>0.9298</td>\n",
              "      <td>1.0500</td>\n",
              "      <td>0.4646</td>\n",
              "      <td>0.4481</td>\n",
              "      <td>0.9771</td>\n",
              "      <td>0.7187</td>\n",
              "      <td>0.5299</td>\n",
              "      <td>0.1079</td>\n",
              "      <td>1.2010</td>\n",
              "      <td>0.2529</td>\n",
              "      <td>-0.4546</td>\n",
              "      <td>0.7998</td>\n",
              "      <td>0.6401</td>\n",
              "      <td>-1.3370</td>\n",
              "      <td>0.6542</td>\n",
              "      <td>0.8561</td>\n",
              "      <td>0.4829</td>\n",
              "      <td>0.3213</td>\n",
              "      <td>-0.0177</td>\n",
              "      <td>-0.2656</td>\n",
              "      <td>0.4626</td>\n",
              "      <td>0.0030</td>\n",
              "      <td>0.8775</td>\n",
              "      <td>0.5230</td>\n",
              "      <td>0.1589</td>\n",
              "      <td>0.7715</td>\n",
              "      <td>0.5497</td>\n",
              "      <td>0.6929</td>\n",
              "      <td>0.3738</td>\n",
              "      <td>0.8636</td>\n",
              "      <td>0.4494</td>\n",
              "      <td>0.1218</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23808</th>\n",
              "      <td>id_fff8c2444</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>72</td>\n",
              "      <td>D1</td>\n",
              "      <td>6c3a459be</td>\n",
              "      <td>0.1608</td>\n",
              "      <td>-1.0500</td>\n",
              "      <td>0.2551</td>\n",
              "      <td>-0.2239</td>\n",
              "      <td>-0.2431</td>\n",
              "      <td>0.4256</td>\n",
              "      <td>-0.1166</td>\n",
              "      <td>-0.1777</td>\n",
              "      <td>-0.7480</td>\n",
              "      <td>0.1368</td>\n",
              "      <td>0.5493</td>\n",
              "      <td>-0.5083</td>\n",
              "      <td>0.4112</td>\n",
              "      <td>0.1181</td>\n",
              "      <td>0.7861</td>\n",
              "      <td>-0.1877</td>\n",
              "      <td>0.2476</td>\n",
              "      <td>0.1956</td>\n",
              "      <td>0.0273</td>\n",
              "      <td>0.1182</td>\n",
              "      <td>-0.5037</td>\n",
              "      <td>-0.5939</td>\n",
              "      <td>0.4825</td>\n",
              "      <td>-0.5187</td>\n",
              "      <td>0.1618</td>\n",
              "      <td>-0.2253</td>\n",
              "      <td>0.3153</td>\n",
              "      <td>0.4839</td>\n",
              "      <td>0.0520</td>\n",
              "      <td>1.3850</td>\n",
              "      <td>0.6502</td>\n",
              "      <td>-0.4198</td>\n",
              "      <td>0.2723</td>\n",
              "      <td>-0.3629</td>\n",
              "      <td>1.0820</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.2720</td>\n",
              "      <td>-0.6021</td>\n",
              "      <td>0.2451</td>\n",
              "      <td>0.6607</td>\n",
              "      <td>-0.1849</td>\n",
              "      <td>-0.6546</td>\n",
              "      <td>-0.5798</td>\n",
              "      <td>0.3449</td>\n",
              "      <td>-0.6208</td>\n",
              "      <td>0.2949</td>\n",
              "      <td>0.4158</td>\n",
              "      <td>0.8586</td>\n",
              "      <td>0.3868</td>\n",
              "      <td>1.0030</td>\n",
              "      <td>-0.4593</td>\n",
              "      <td>0.6498</td>\n",
              "      <td>0.8293</td>\n",
              "      <td>-0.7645</td>\n",
              "      <td>0.5379</td>\n",
              "      <td>0.5610</td>\n",
              "      <td>0.2577</td>\n",
              "      <td>-0.5493</td>\n",
              "      <td>0.2690</td>\n",
              "      <td>0.6392</td>\n",
              "      <td>-0.5774</td>\n",
              "      <td>-0.3393</td>\n",
              "      <td>0.5068</td>\n",
              "      <td>-0.2005</td>\n",
              "      <td>-0.4559</td>\n",
              "      <td>0.3734</td>\n",
              "      <td>0.0789</td>\n",
              "      <td>0.3538</td>\n",
              "      <td>0.0558</td>\n",
              "      <td>0.3377</td>\n",
              "      <td>-0.4753</td>\n",
              "      <td>-0.2504</td>\n",
              "      <td>-0.7415</td>\n",
              "      <td>0.8413</td>\n",
              "      <td>-0.4259</td>\n",
              "      <td>0.2434</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23809</th>\n",
              "      <td>id_fffb1ceed</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D2</td>\n",
              "      <td>df1d0a5a1</td>\n",
              "      <td>0.1394</td>\n",
              "      <td>-0.0636</td>\n",
              "      <td>-0.1112</td>\n",
              "      <td>-0.5080</td>\n",
              "      <td>-0.4713</td>\n",
              "      <td>0.7201</td>\n",
              "      <td>0.5773</td>\n",
              "      <td>0.3055</td>\n",
              "      <td>-0.4726</td>\n",
              "      <td>0.1269</td>\n",
              "      <td>0.2531</td>\n",
              "      <td>0.1730</td>\n",
              "      <td>-0.4532</td>\n",
              "      <td>-1.0790</td>\n",
              "      <td>0.2474</td>\n",
              "      <td>-0.4550</td>\n",
              "      <td>0.3588</td>\n",
              "      <td>0.1600</td>\n",
              "      <td>-0.7362</td>\n",
              "      <td>-0.1103</td>\n",
              "      <td>0.8550</td>\n",
              "      <td>-0.4139</td>\n",
              "      <td>0.5541</td>\n",
              "      <td>0.2310</td>\n",
              "      <td>-0.5573</td>\n",
              "      <td>-0.4397</td>\n",
              "      <td>-0.9260</td>\n",
              "      <td>-0.2424</td>\n",
              "      <td>-0.6686</td>\n",
              "      <td>0.2326</td>\n",
              "      <td>0.6456</td>\n",
              "      <td>0.0136</td>\n",
              "      <td>-0.5141</td>\n",
              "      <td>-0.6320</td>\n",
              "      <td>0.7166</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0807</td>\n",
              "      <td>0.4024</td>\n",
              "      <td>-0.0895</td>\n",
              "      <td>0.4420</td>\n",
              "      <td>0.9641</td>\n",
              "      <td>-0.1846</td>\n",
              "      <td>-0.0014</td>\n",
              "      <td>0.3154</td>\n",
              "      <td>-0.2071</td>\n",
              "      <td>-0.6158</td>\n",
              "      <td>-0.2977</td>\n",
              "      <td>0.0992</td>\n",
              "      <td>0.6838</td>\n",
              "      <td>0.5259</td>\n",
              "      <td>0.7882</td>\n",
              "      <td>0.3119</td>\n",
              "      <td>-0.7697</td>\n",
              "      <td>0.2203</td>\n",
              "      <td>-1.0710</td>\n",
              "      <td>0.5979</td>\n",
              "      <td>0.0848</td>\n",
              "      <td>-0.2555</td>\n",
              "      <td>0.6293</td>\n",
              "      <td>1.1660</td>\n",
              "      <td>0.3329</td>\n",
              "      <td>0.2754</td>\n",
              "      <td>0.4108</td>\n",
              "      <td>-0.1252</td>\n",
              "      <td>-0.2340</td>\n",
              "      <td>0.2267</td>\n",
              "      <td>0.1969</td>\n",
              "      <td>0.0262</td>\n",
              "      <td>-0.8121</td>\n",
              "      <td>0.3434</td>\n",
              "      <td>0.5372</td>\n",
              "      <td>-0.3246</td>\n",
              "      <td>0.0631</td>\n",
              "      <td>0.9171</td>\n",
              "      <td>0.5258</td>\n",
              "      <td>0.4680</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23810</th>\n",
              "      <td>id_fffb70c0c</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D2</td>\n",
              "      <td>ecf3b6b74</td>\n",
              "      <td>-1.3260</td>\n",
              "      <td>0.3478</td>\n",
              "      <td>-0.3743</td>\n",
              "      <td>0.9905</td>\n",
              "      <td>-0.7178</td>\n",
              "      <td>0.6621</td>\n",
              "      <td>-0.2252</td>\n",
              "      <td>-0.5565</td>\n",
              "      <td>0.5112</td>\n",
              "      <td>0.6727</td>\n",
              "      <td>-0.1851</td>\n",
              "      <td>2.8650</td>\n",
              "      <td>-0.2140</td>\n",
              "      <td>-0.6153</td>\n",
              "      <td>0.8362</td>\n",
              "      <td>0.5584</td>\n",
              "      <td>-0.2589</td>\n",
              "      <td>0.1292</td>\n",
              "      <td>0.0148</td>\n",
              "      <td>0.0949</td>\n",
              "      <td>-0.2182</td>\n",
              "      <td>-0.9235</td>\n",
              "      <td>0.0749</td>\n",
              "      <td>-1.5910</td>\n",
              "      <td>-0.8359</td>\n",
              "      <td>-0.9217</td>\n",
              "      <td>0.3013</td>\n",
              "      <td>0.1716</td>\n",
              "      <td>0.0880</td>\n",
              "      <td>0.1842</td>\n",
              "      <td>0.1835</td>\n",
              "      <td>0.5436</td>\n",
              "      <td>-0.0533</td>\n",
              "      <td>-0.0491</td>\n",
              "      <td>0.9543</td>\n",
              "      <td>...</td>\n",
              "      <td>0.1410</td>\n",
              "      <td>1.2640</td>\n",
              "      <td>-0.8663</td>\n",
              "      <td>0.8129</td>\n",
              "      <td>-0.1514</td>\n",
              "      <td>-0.4652</td>\n",
              "      <td>-0.7390</td>\n",
              "      <td>-1.3270</td>\n",
              "      <td>0.9925</td>\n",
              "      <td>1.0570</td>\n",
              "      <td>-0.3355</td>\n",
              "      <td>-0.2555</td>\n",
              "      <td>0.8219</td>\n",
              "      <td>0.6995</td>\n",
              "      <td>-0.2942</td>\n",
              "      <td>0.2408</td>\n",
              "      <td>-0.7781</td>\n",
              "      <td>-0.0929</td>\n",
              "      <td>-0.0329</td>\n",
              "      <td>0.0781</td>\n",
              "      <td>-1.4440</td>\n",
              "      <td>-0.0921</td>\n",
              "      <td>0.3188</td>\n",
              "      <td>-1.1080</td>\n",
              "      <td>0.4895</td>\n",
              "      <td>-0.2144</td>\n",
              "      <td>1.0960</td>\n",
              "      <td>0.3335</td>\n",
              "      <td>0.4444</td>\n",
              "      <td>-1.1130</td>\n",
              "      <td>0.4286</td>\n",
              "      <td>0.4426</td>\n",
              "      <td>0.0423</td>\n",
              "      <td>-0.3195</td>\n",
              "      <td>-0.8086</td>\n",
              "      <td>-0.9798</td>\n",
              "      <td>-0.2084</td>\n",
              "      <td>-0.1224</td>\n",
              "      <td>-0.2715</td>\n",
              "      <td>0.3689</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23811</th>\n",
              "      <td>id_fffc1c3f4</td>\n",
              "      <td>com_controle</td>\n",
              "      <td>48</td>\n",
              "      <td>D2</td>\n",
              "      <td>cacb2b860</td>\n",
              "      <td>0.3942</td>\n",
              "      <td>0.3756</td>\n",
              "      <td>0.3109</td>\n",
              "      <td>-0.7389</td>\n",
              "      <td>0.5505</td>\n",
              "      <td>-0.0159</td>\n",
              "      <td>-0.2541</td>\n",
              "      <td>0.1745</td>\n",
              "      <td>-0.0340</td>\n",
              "      <td>0.4865</td>\n",
              "      <td>-0.1854</td>\n",
              "      <td>0.0716</td>\n",
              "      <td>0.1729</td>\n",
              "      <td>-0.0434</td>\n",
              "      <td>0.1542</td>\n",
              "      <td>-0.2192</td>\n",
              "      <td>-0.0302</td>\n",
              "      <td>-0.4218</td>\n",
              "      <td>0.4057</td>\n",
              "      <td>-0.5372</td>\n",
              "      <td>0.1521</td>\n",
              "      <td>-0.2651</td>\n",
              "      <td>0.2310</td>\n",
              "      <td>-0.8101</td>\n",
              "      <td>0.4943</td>\n",
              "      <td>0.6905</td>\n",
              "      <td>-0.3720</td>\n",
              "      <td>-1.4110</td>\n",
              "      <td>0.4516</td>\n",
              "      <td>1.2300</td>\n",
              "      <td>-0.1949</td>\n",
              "      <td>-1.3280</td>\n",
              "      <td>-0.4276</td>\n",
              "      <td>-0.0040</td>\n",
              "      <td>-0.3086</td>\n",
              "      <td>...</td>\n",
              "      <td>0.6845</td>\n",
              "      <td>0.7127</td>\n",
              "      <td>0.7294</td>\n",
              "      <td>0.4718</td>\n",
              "      <td>-0.2020</td>\n",
              "      <td>0.2783</td>\n",
              "      <td>0.4934</td>\n",
              "      <td>0.4144</td>\n",
              "      <td>0.5449</td>\n",
              "      <td>1.4690</td>\n",
              "      <td>-0.6142</td>\n",
              "      <td>0.6068</td>\n",
              "      <td>0.3434</td>\n",
              "      <td>0.9880</td>\n",
              "      <td>-0.0468</td>\n",
              "      <td>-0.1882</td>\n",
              "      <td>-0.0087</td>\n",
              "      <td>-0.0356</td>\n",
              "      <td>0.5718</td>\n",
              "      <td>0.4971</td>\n",
              "      <td>0.1057</td>\n",
              "      <td>0.2111</td>\n",
              "      <td>0.6992</td>\n",
              "      <td>0.0708</td>\n",
              "      <td>0.6169</td>\n",
              "      <td>0.2248</td>\n",
              "      <td>0.5994</td>\n",
              "      <td>0.2689</td>\n",
              "      <td>0.0305</td>\n",
              "      <td>1.2320</td>\n",
              "      <td>0.5409</td>\n",
              "      <td>0.3755</td>\n",
              "      <td>0.7343</td>\n",
              "      <td>0.2807</td>\n",
              "      <td>0.4116</td>\n",
              "      <td>0.6422</td>\n",
              "      <td>0.2256</td>\n",
              "      <td>0.7592</td>\n",
              "      <td>0.6656</td>\n",
              "      <td>0.3808</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23812</th>\n",
              "      <td>id_fffcb9e7c</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>8b87a7a83</td>\n",
              "      <td>0.6660</td>\n",
              "      <td>0.2324</td>\n",
              "      <td>0.4392</td>\n",
              "      <td>0.2044</td>\n",
              "      <td>0.8531</td>\n",
              "      <td>-0.0343</td>\n",
              "      <td>0.0323</td>\n",
              "      <td>0.0463</td>\n",
              "      <td>0.4299</td>\n",
              "      <td>-0.7985</td>\n",
              "      <td>0.5742</td>\n",
              "      <td>0.1421</td>\n",
              "      <td>2.2700</td>\n",
              "      <td>0.2046</td>\n",
              "      <td>0.5363</td>\n",
              "      <td>-1.7330</td>\n",
              "      <td>0.1450</td>\n",
              "      <td>0.6097</td>\n",
              "      <td>0.2024</td>\n",
              "      <td>0.9865</td>\n",
              "      <td>-0.7805</td>\n",
              "      <td>0.9608</td>\n",
              "      <td>0.3440</td>\n",
              "      <td>2.7650</td>\n",
              "      <td>0.4925</td>\n",
              "      <td>0.6698</td>\n",
              "      <td>0.2374</td>\n",
              "      <td>-0.3372</td>\n",
              "      <td>0.8771</td>\n",
              "      <td>-2.6560</td>\n",
              "      <td>-0.2000</td>\n",
              "      <td>-0.2043</td>\n",
              "      <td>0.6797</td>\n",
              "      <td>-0.0248</td>\n",
              "      <td>-0.0927</td>\n",
              "      <td>...</td>\n",
              "      <td>0.3360</td>\n",
              "      <td>-0.6136</td>\n",
              "      <td>0.5011</td>\n",
              "      <td>0.9261</td>\n",
              "      <td>0.4419</td>\n",
              "      <td>0.0295</td>\n",
              "      <td>0.4220</td>\n",
              "      <td>0.4677</td>\n",
              "      <td>-0.1184</td>\n",
              "      <td>0.4524</td>\n",
              "      <td>0.4135</td>\n",
              "      <td>0.1356</td>\n",
              "      <td>-0.5801</td>\n",
              "      <td>0.0411</td>\n",
              "      <td>1.0240</td>\n",
              "      <td>1.0340</td>\n",
              "      <td>-0.0270</td>\n",
              "      <td>-0.4194</td>\n",
              "      <td>0.7403</td>\n",
              "      <td>-0.6793</td>\n",
              "      <td>-0.1423</td>\n",
              "      <td>0.7307</td>\n",
              "      <td>0.7946</td>\n",
              "      <td>-0.0650</td>\n",
              "      <td>0.9038</td>\n",
              "      <td>0.2324</td>\n",
              "      <td>0.9676</td>\n",
              "      <td>1.0940</td>\n",
              "      <td>0.4290</td>\n",
              "      <td>0.5187</td>\n",
              "      <td>-0.1105</td>\n",
              "      <td>0.4258</td>\n",
              "      <td>-0.2012</td>\n",
              "      <td>0.1506</td>\n",
              "      <td>1.5230</td>\n",
              "      <td>0.7101</td>\n",
              "      <td>0.1732</td>\n",
              "      <td>0.7015</td>\n",
              "      <td>-0.6290</td>\n",
              "      <td>0.0740</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23813</th>\n",
              "      <td>id_ffffdd77b</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>72</td>\n",
              "      <td>D1</td>\n",
              "      <td>972f41291</td>\n",
              "      <td>-0.8598</td>\n",
              "      <td>1.0240</td>\n",
              "      <td>-0.1361</td>\n",
              "      <td>0.7952</td>\n",
              "      <td>-0.3611</td>\n",
              "      <td>-3.6750</td>\n",
              "      <td>-1.2420</td>\n",
              "      <td>0.9146</td>\n",
              "      <td>3.0790</td>\n",
              "      <td>1.2460</td>\n",
              "      <td>1.9460</td>\n",
              "      <td>1.4370</td>\n",
              "      <td>2.9780</td>\n",
              "      <td>2.2370</td>\n",
              "      <td>-0.6818</td>\n",
              "      <td>0.6870</td>\n",
              "      <td>-1.1060</td>\n",
              "      <td>0.0182</td>\n",
              "      <td>-0.9247</td>\n",
              "      <td>-0.0738</td>\n",
              "      <td>-0.1919</td>\n",
              "      <td>-0.7722</td>\n",
              "      <td>-1.4050</td>\n",
              "      <td>-1.0050</td>\n",
              "      <td>-1.1170</td>\n",
              "      <td>-0.5293</td>\n",
              "      <td>-1.1720</td>\n",
              "      <td>-0.2885</td>\n",
              "      <td>0.1599</td>\n",
              "      <td>-0.4250</td>\n",
              "      <td>0.3591</td>\n",
              "      <td>-0.1420</td>\n",
              "      <td>-0.9530</td>\n",
              "      <td>-0.2005</td>\n",
              "      <td>-1.8340</td>\n",
              "      <td>...</td>\n",
              "      <td>-6.9170</td>\n",
              "      <td>-1.8640</td>\n",
              "      <td>-2.5090</td>\n",
              "      <td>-4.7130</td>\n",
              "      <td>-1.7250</td>\n",
              "      <td>-3.8650</td>\n",
              "      <td>-3.0800</td>\n",
              "      <td>-4.1530</td>\n",
              "      <td>-1.2030</td>\n",
              "      <td>-1.1690</td>\n",
              "      <td>-4.1460</td>\n",
              "      <td>-1.2670</td>\n",
              "      <td>-1.1300</td>\n",
              "      <td>-2.4390</td>\n",
              "      <td>0.1591</td>\n",
              "      <td>-2.2490</td>\n",
              "      <td>-2.5860</td>\n",
              "      <td>-1.9520</td>\n",
              "      <td>-2.1810</td>\n",
              "      <td>-4.6690</td>\n",
              "      <td>-3.9450</td>\n",
              "      <td>-2.9560</td>\n",
              "      <td>-2.7930</td>\n",
              "      <td>-2.1560</td>\n",
              "      <td>-2.4100</td>\n",
              "      <td>-1.8190</td>\n",
              "      <td>-3.3480</td>\n",
              "      <td>-0.1414</td>\n",
              "      <td>-2.6430</td>\n",
              "      <td>-2.5810</td>\n",
              "      <td>-3.3890</td>\n",
              "      <td>-1.7450</td>\n",
              "      <td>-6.6300</td>\n",
              "      <td>-4.0950</td>\n",
              "      <td>-7.3860</td>\n",
              "      <td>-1.4160</td>\n",
              "      <td>-3.5770</td>\n",
              "      <td>-0.4775</td>\n",
              "      <td>-2.1500</td>\n",
              "      <td>-4.2520</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>10 rows × 877 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                 id    tratamento  tempo dose  ...    c-96    c-97    c-98    c-99\n",
              "23804  id_fff506720     com_droga     24   D1  ... -0.4097  0.2282 -0.3213 -0.0836\n",
              "23805  id_fff6df1c5     com_droga     48   D2  ...  0.1516  0.4503 -0.6312 -0.8302\n",
              "23806  id_fff790a17     com_droga     48   D2  ...  1.2630  0.7823 -0.6947  0.7277\n",
              "23807  id_fff7e6992     com_droga     48   D1  ...  0.3738  0.8636  0.4494  0.1218\n",
              "23808  id_fff8c2444     com_droga     72   D1  ... -0.7415  0.8413 -0.4259  0.2434\n",
              "23809  id_fffb1ceed     com_droga     24   D2  ...  0.0631  0.9171  0.5258  0.4680\n",
              "23810  id_fffb70c0c     com_droga     24   D2  ... -0.2084 -0.1224 -0.2715  0.3689\n",
              "23811  id_fffc1c3f4  com_controle     48   D2  ...  0.2256  0.7592  0.6656  0.3808\n",
              "23812  id_fffcb9e7c     com_droga     24   D1  ...  0.1732  0.7015 -0.6290  0.0740\n",
              "23813  id_ffffdd77b     com_droga     72   D1  ... -3.5770 -0.4775 -2.1500 -4.2520\n",
              "\n",
              "[10 rows x 877 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 18
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "J9ppq6rou_La"
      },
      "source": [
        "### Desafio 03: Proporção das classes de tratamento.\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "tkltDxq9vhpv",
        "outputId": "19827144-6347-4c1f-a77a-5f2539dd27d6"
      },
      "source": [
        "dados['tratamento'].value_counts(normalize=True)"
      ],
      "execution_count": 19,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "com_droga       0.921643\n",
              "com_controle    0.078357\n",
              "Name: tratamento, dtype: float64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 19
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "vqQsI531vGh4"
      },
      "source": [
        "### Desafio 04: Quantos tipos de drogas foram investigadas."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "01nIn-G9Z56d",
        "outputId": "f76669fa-7c9a-42b5-8c7e-7814215741dd"
      },
      "source": [
        "dados['droga'].unique().size"
      ],
      "execution_count": 20,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "3289"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 20
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "w4e3kNh2aoYN"
      },
      "source": [
        "#### Desafio 04.1 - quantos experimentos por droga"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "phFZaFFVaxWR",
        "outputId": "df97af0c-7be2-474b-cdfe-b795daa91034"
      },
      "source": [
        "dados.groupby(['droga']).size().value_counts()\n",
        "\n",
        "# set_drogas = dados.groupby(['droga']).size()[dados.groupby(['droga']).size() < 200].index\n",
        "\n",
        "# dados[dados['droga'].isin(set_drogas)][['tratamento', 'tempo', 'dose', 'droga']]\n"
      ],
      "execution_count": 21,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "6       2774\n",
              "7        196\n",
              "1        129\n",
              "5         66\n",
              "12        64\n",
              "13        25\n",
              "14         6\n",
              "11         4\n",
              "8          4\n",
              "2          3\n",
              "4          3\n",
              "18         3\n",
              "3          2\n",
              "178        1\n",
              "203        1\n",
              "186        1\n",
              "194        1\n",
              "196        1\n",
              "19         1\n",
              "246        1\n",
              "718        1\n",
              "1866       1\n",
              "202        1\n",
              "dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 21
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "NMJaDZkkvmFy"
      },
      "source": [
        "## Aula 01 - Parte 02"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "WYC4-oRNvPXQ",
        "outputId": "54e85484-1c08-4c90-f086-98e8e909dada"
      },
      "source": [
        "dados['dose'].value_counts(normalize=True)"
      ],
      "execution_count": 22,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "D1    0.510078\n",
              "D2    0.489922\n",
              "Name: dose, dtype: float64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 22
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 266
        },
        "id": "qGf9PaXQv2c5",
        "outputId": "20edbf21-3efc-47a9-be08-073dc917b13d"
      },
      "source": [
        "dados['tempo'].value_counts().plot.pie()"
      ],
      "execution_count": 23,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7f9f2df917d0>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 23
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAPUAAADnCAYAAADGrxD1AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAY80lEQVR4nO3deZRcZZnH8e9TVd2dpJNUJ+kkBAIUiwMGm2FJ2MLADKiIjR4cHca9lEGckVHGYLCU7ToOpkWRJSCCHDFIcAM0DqVBdABBSMLuhbCYQIMYiARIJWTpTqff+eN2pBPpdHV33fvUvff5nFMnpKiu95cDv9z1fa845zDGJEdGO4Axpras1MYkjJXamISxUhuTMFZqYxLGSm1MwlipjUkYK7UxCWOlNiZhrNTGJIyV2piEsVIbkzBWamMSxkptTMJYqY1JGCu1MQljpTYmYazUxiSMldqYhLFSG5MwVmpjEsZKbUzCWKmNSRgrtTEJY6U2JmGs1Cb2RCQrIg+LyK19vz9eRB4SkUdE5B4R2Vc7Y5Ss1CYJzgSe6Pf7q4CPOOcOAm4EzlVJpSSnHcDUXqFUFmA3YC9gb6AATAYmAROB8cA4oBkQoLfv5fp+3QK8BrzS77UGWA2sBP7Y2dG+OrI/0E6IyHSgHbgQmNP3tiP4MwLkgVUK0dSIPSAv3gql8q7AoX2vQ4D9gD2BppCHXg+s6Hs9BtwPLO3saH815HG3IyI3AfMI/pL6gnPuJBH5B+DnwCZgHXCEc25dlLk0WaljpG8LfAjwDmA2QZGnqYb6WyuAZcBS4I7OjnY/rIFE5CTg3c65z4jIP/JGqW8Bvu6cWyoic4H9nHOnhZWj3lip61yhVN4NeGff63iC3eg4eQFYDPwK+E1nR3vNtpgiMg/4GNADjCLY5b4D2N85t0/fZ/YAFjvnZtRq3Hpnpa5DhVJ5GnAK8CHgcOU4tbQFuAf4EfCTzo72tbX64m1bauBk4CXgKOfc0yLybwRb8/fXaqx6Z6WuE4VSeQLwAYIiH0vyr0x0AWXgBqDc2dHePZIv22H3+33AfxOc9HsNONU598wI88aGlVpZoVQ+CPgsQZlHK8fR8hrwA+Dyzo72ldph4s5KraBQKueAfyYo89HKcepJL3ArcElnR/udylliy0odoUKp3AR8Gjib4DqyGdgjwCXAjZ0d7T3aYeLESh2BQqncCJwGfBkr81CtIDg+XtjZ0d6rHSYOrNQh6tvNPhU4B9hDOU7cLQe+3NnRvkg7SL2zUoekUCofB8wHUnN9NCK/Bz7X2dH+kHaQemWlrrFCqTwduJjgOrMJx1bg28C5tbyZJSms1DXSd9w8h2BGULNynLR4Efh8Z0f7j7WD1BMrdQ30XWteAByonSWlfg2c3tnR/px2kHqQ9LuWwuXls3PPmfs5ggkMVmg97wQeLZTKH9QOUg9sSz1cXn53YGGvkwOO7Jrfs5qJU7QjGSC47fSMNB9r25Z6OLz8PwOPAv+QETdxUdN5tttXPz4KPFIolY/SDqLFSj0UXn40Xv5q4GZgwra3d5HXZn0x98Pf6QUzO9gLuKtQKp+hHUSD7X5Xy8tPBP4XeNMtgHNseHv3N9asdLvtGW0wM4irgc92drRv0Q4SFSt1NYLj58UMciPJOjfGP6jrmhm9ZLLRBDNV+h3w/s6O9jXaQaJgu9+D8fIHAPdSxZ1h42Vj28UNV90dfigzRMcA9xdK5TbtIFGwUu+Ml58N3A1Mr/ZHTs78fvZMeeqJwT9pIlYgOM4+UjtI2KzUA/Hy7wVup98JsWqI0LCw8WuNTXRvDieYGYEJwO2FUvl47SBhslK/GS9/GnALw1yJpEm27HNdw0VLaxvK1EgzUC6UyidrBwmLlXpHXv484LvAiE52HZlZfswJmWUP1yaUqbEm4KeFUvmj2kHCYGe/+/PyFwFza/V1PS6z6uCuq5vX05yv1XeamtoK/GtnR/vN2kFqybbU23j5z1DDQgPkpHfXmxq/8lgtv9PUVBa4sVAqv107SC1ZqQG8/InA5WF89X6ZF2YXs4vvC+O7TU00Aj8rlMqJWV/ddr+9/IEEC8yPC2uIXsdrR3Vd0f0SE6eGNYYZsVeBYzo72h/XDjJS6d5Se/lpBEvShlZogIwwYVHTuX8KcwwzYhOBxYVSOfZ/8aa31F5+DMG93LtHMdxUWTvzS7mFNumjvk0HbiqUyg3aQUYinaX28hlgIcFTIyNzerY88y3yQmeUY5ohO5pgwcjYSmep4SKCB6lFSoQxtzResCFD79aoxzZD8ulCqfxp7RDDlb5Se/nTgbO0hh8nmw64tOFKm/RR/+YXSuXZ2iGGI11nv738/gSPc2nSjOEcPad0n//H+93+b9XMYQb1HHBg3JZGSs+WOjiO/h7KhQYQIXdD47zGUXRt0s5idmpP4ErtEEOVnlLD54C6mXbXJFv2+X7jRcu0c5hBfbRQKv+rdoihSEepvfzewIXaMXZ0uDxxzLszS+3xMfXvqr4nr8RC8kvt5YVg1tUY7Sg7EkEub5g/bTyvV7SzmJ2aAHxfO0S1kl9qOB04TjvEQHLSO+3mRs8mfdS/4wul8se1Q1Qj2aX28tMJrknXtbdkVs0+Nfure7VzmEF9s1AqT9QOMZhklzpYHna8dohqnJv7wYxpvPKSdg6zU5OBr2mHGExyS+3lPwa8WztGtTJCy6Km817QzmEG9alCqXyIdoidSWapvfw44FvaMYZqiqydeU7uBpv0Ud8yhDT3vlaSWWo4E2jVDjEcp2V/OfPv5E/PaucwOzW7UCqfpB1iIMm7TdTLtwDPAi3aUYZrvRv9+EFd1+y3lWxOO4sZ0MPAoZ0d7XVXoCRuqecQ40JDMOnjsoYr7tHOYXbqYOD92iHeTLK21MFD7DoJeSWTKDhHzwe7z316qZsx6ON+jJrlQFtnR3uvdpD+kral/i8SUGgIJn1c39gx2iZ91LUZwIe1Q+woOaX28s1Aop5H3CQ9e13f2GGTPurb2doBdpScUsOpBIvHJcoseeqY9sySB7VzmAG1FUrlf9IO0V8ySu3lswQnyBInmPRxxa55Xl+rncUM6EztAP0lo9TwLwSPKk2krPROu6XxguXaOcyA3lMolffSDrFNUkr9n9oBwrZP5sWjTsuWbdJHfcpQR/8Pxv+SVjAT63lAtKOErdex9uiuyzetonWadhbzN9YCu3R2tHdpB0nClvpfSEGh4a+TPlZB3P8mTqQWoF07BCSn1KkxWSqHnp/7gS0xXJ8+oh0A4r777eV3J1jGNRVb6m2cY9OJ3R0vPun22Fs7i9lOFzC1s6NddXmquG+pP0DKCg0gwuibGr3NWbb2aGcx22miDu4Hj3upU7Xr3d9Y2TxjfsP832vnMH9D/bbR+JY62PU+QjuGphMzy2YfkXk89s9TTphjC6VyXjNAfEud0l3v/kTIXd/w9TGj6dqoncX8VQ44XjNAnEt9inaAetAoPXv9oHHeA9o5zHbepTl4PEsd7Hofrh2jXszMPH3MezL3WrHrxwmag8ez1HAsKd/13tGlDVdOb2H9a9o5DAB7FEpltSeaxrXUdb1Eq4asuF1uabzgSe0c5q/eqTWwlTpB9s68dOTp2VvtMld9UDs8jF+pgwfeHawdo159KXfj23bj5Re1cxhmaQ0cv1LDvsTkUToaRMgvajrvRZv0oW7fQqk8QWPgOJbadr0H0SrrDvFyC2zSh76ZGoPGsdSHageIg2L214e9VZ5bqZ0j5VR2weNYattSV0GEUTc1fqU7R88W7SwppnLuJ46ltpNkVWqWzW+9ouFyWwJJz74ag1ZVahGZKiIn9b2mhB1qQF5+LxK4DHCYTsg8cPTszGOPaedIqX00Bh201CJyCrCMYJrjKcBSEflA2MEGYFvpIRIhe13DRWPHsHmDdpYUGlcolSdHPWg1W+pzgFnOuaJz7uPAYcB54cYa0HSlcWOtUXoKNzR+zR4IoCPyXfBqSp1xzv2l3+9fqfLnwqBy3S8JDsmsOObkzD026SN6ke+CV1POxSJym4h8QkQ+AZSBX4Yba0CxfkSttosbrtp9Aute1c6RMrtHPeCgpXbOzQWuBg7se13jnPti2MEGYFvqEciKm/qzxgue0s6RMpGf2K12N/pe4C7gDuC+8OIMyko9QoXM6iP/PfsLm/QRnfortYicRnD2+30ESwgtEZFTww42ACt1DXwx96O3TZeXV2nnSInI/5+tZks9FzjYOfcJ51yR4DZN2/2OMRHyixrPXW2TPiJRf1tqgrPd6/v9fn3fexqs1DUySdYf/NXcdb/TzpECdVnqFQQ3nHgicgGwBHhaROaISNTPhLZS19BHs785fIZ02qSPcDVHPWA1pV4J/BzYtqu2CHgWGNf3ioaXbwTGRDZeCvRN+thikz5ClY16wNxgH3DOfSWKIFWwa9QhGCNd+1/VcNldn9py1rHaWRKq/kotIjMJbhXds//nnXMHhpjrzcRxRlksbBj/5Kixk0t2U0ooMmujfsLtoKUGFhKcAfeB3nDj7JQ9hSIEDtyFrRNaRGz2Wzh610Y9YjWlftk594uhfrGI7Af8uN9bewPnA7sB7wG6CY7XP+mcq+YPbrOMQnDD+HH3bc5kjtLOkWDdUQ846POpReR44EPAbwmevwuAc+6WqgcRyQJ/Jlg2dT/g/5xzPSLy9b7vqu66t5ffTPC4UFMDW2HrrMLuz28R2Us7S4L5ftGP9FC1mi31J4H9gQbe2P12QNWlJnhg2Ern3HMED4nfZgnBXWrV2oiVumauaRl/3xaRo7VzJFzkW+pqSj3LObffCMf5IPDDN3n/VLbfRR/M69i16prohu6rW/IF7RwpEHmpqzmjfK+IzBjuACLSCLwX+OkO758D9BCciKvWmuHmMNu7dGLLkq0ituhE+P4c9YDVbKmPAB4RkWcJjqkFcEO4pHUi8JBzbvW2N/rmZZ8EHO8GO6jf3l8G/4gZzCaRjQvHj9tfO0dKPBv1gNWUeqTP2v0Q/Xa9ReRdwNnAsc65oV6menmEWQwwb9KEZb0i/6idIyWeiXrAahZJeI5g9Ybj+v55YzU/ByAizcA72P6k2hUEt5feLiKPiMh3hpDXttQjtF5k3c/HNv+9do4Uqb8tdd8kjpkEl6KuIzgLfgMwe7Cfdc5tACbt8N5IFmKzUo/QBZMnPeRsKx2lyEtdzRb3fQQnujYAOOdWEeVEju11Ko2bCK9lMq/ePma0PbYoOo7tL+FGoppSd/edzHLw111qLQ8rjh17pcmTfES0/kJOo1V+0e8a/GO1VU2pfyIiVwMtIvIp4DfAd8ONNaA/sv2CDaZKq7PZ1feOHnWYdo6UiXzXG6or9WTgJuBmguPq89FaVN+rOOBRlbFj7gtTWp9CZLR2jpSp21K/wzl3u3NurnPuC8652wmuPWt5SHHsWHo+l3vhkabGI7VzpJBKqQc8+y0i/wF8BthbRP7Q71+NAzSXmLXj6iH6/JTW57C7xzSoLBW1s0taNwK/AuYBpX7vr3fOaU6oty31EDzV0PDM040NR2jnSCmVxwgPWGrnXAWoENwRVk+WA5uBUdpB4mDO1NbViOytnSOFnveL/gqNgeO3RJBX6SFYhcUM4tGmxqeez+VsK63jt1oDx6/UATuursKcKa3rEBHtHCllpR4iO64exO9Hj/L/ksvN0s6RYv+nNXBcS32ndoB6V5o8aat2hhRb7hf9F7UGj2epvcpTwGPaMerVr8eMfmhtNnuQdo4UU9v1hriWOvDTwT+STudPnmTruOmyUg+TlfpN3Dy2edmGTOYA7RwpthXlw8P4ltqrPAE8rh2jnvRC77xJE2xhRl0P+EW/ohkgvqUO2Na6n+vHj1vSlcm8RTtHyi3WDmClToge6Ll8Ysuu2jlSrpdgdSBV8S61V1lOcNto6n2nJX/fFpGCdo6Uu80v+pGvdLKjeJc6kPqtdTd0Xdsy3u7v1jeURTRDk4RS36QdQNvFEycs2Sqym3aOlHsBKGuHgCSU2qs8Rop3wTeJbPzh+LHDfoKKqZlr/aJfF3fxxb/UgW9pB9DyP5MmLHMik7VzpNxW4FrtENskpdTXA3/SDhG1dRmp/O/YZrsdVN+tftGP/JlZA0lGqb3KFuAb2jGidn7rpEecSIt2DsPV2gH6S0apA9eSoid4vJLJrPmtLcxfDzqB27RD9JecUnuVTaTo2Lo0pfVxRMZq5zBc4xf9Xu0Q/SWn1IFvA69phwjbi9nsi0tGNR2uncPwCnCldogdJavUXmU9MF87RtjOmtK6AhFbeFHf1/yiv047xI6SVerAZcDr2iHC0pnLPe83Ndpigvqepw630pDEUnuVV4GrtGOE5fNTW/+ESIN2DsMFGg+/q0bySh24GNikHaLWnmhsWLmiocEen6PvcYJ7I+pSMkvtVVYD/6Mdo9bmTGl9GZFk/jeLlzPr7Yx3f0n+H+QbJOie8Aebmp54IZezM976bvaLvuoaZINJbqmDu8w+DTjtKLUwd8qkDbYwv7pNwBztEINJbqkBvMo9wPe0Y4zU3aNH/eHlXG6mdg7DPL/oP68dYjDJLnXgbGJ+++iXJk9KxN5GzP2RmMwvSH6pg0tcp2vHGK5fNY95sJLN/r12jpTrAk7xi/5m7SDVSH6pAbzKIur4EsTOeK0TR2tnMMzxi/4j2iGqlY5SBz5HsORMbPxk3NglGzMZW9VE10/9ov9t7RBDkZ5Se5UKcCoxORveC70XTWxp1c6Rcs8Ap2mHGKr0lBrAq9wOdGjHqMb38+Pu68pk9tXOkWLdBMfRdTdhYzDpKnXgHOp8BdIe6Jk/oWW6do6U+4Jf9B/UDjEc6Su1V3HAx4Fl2lEGcuWE/H09Intq50ixW/yiH9spvOkrNWxbJeW9gPrTFHbUDV3fy4+33W49zwL/ph1iJNJZatg26eMkoK6Omb4xacKSXpFp2jlSagPBcfRa7SAjkd5Sw7YHAZxCsG6zuo0iG348zhbmV7IJeI9f9B/QDjJS6S41gFe5DfisdgyAr7ZOvN8W5lfRBbzPL/p3aAepBSs1gFe5CrhUM0IlI5Vbm8ccrJkhpbYQ7HLX1TK/I2GlfsNZwM+0Bj+3ddLDiOS1xk+prcCH/aL/C+0gtWSl3sar9BIcX0d+j/iabOblO8eMnhX1uCnXCxT9ol/X9ywMh5W6P6/SA3yCiKfYfXFy63JEmqMcM+UccLpf9BdqBwmDOBeLW6Gj5+XnAN8EQl1t5M+57Kp3Td91EiJNYY5jtnNG3CZpDIVtqQfiVb4FfIzgREpozprSutIKHZmtwGeTXGiwUu+cV1lIcOfZhjC+/pmG3HOPNzbakr/ReAU4wS/6V2gHCZuVejBeZTFwHLCm1l89Z8rkFxDJ1fp7zd94GJhZ76uA1oqVuhpeZRlwNDW8V3x5Y8OKlQ0520qH70Zgtl/0O7WDRMVOlA2Fl9+FYHXSE0f6VSdM33XpqgZbxztEW4G5ftG/RDtI1KzUw+HlP0Nw2WvMcH78/lFNy0+dNtXu8Q7PGoK7xBJx2+dQ2e73cHiVbwOHAPcP58fPntyauOd81ZFtx8+pLDRYqYfPqzwFHAX8N0OY5XXX6FGPrsllDw0tV3o54DsEx891N08+Srb7XQte/nDgBmDQxQ1m77HbH9ZlsweGHypVniS4Q+xu7SD1wLbUteBVlgIHAdfs7GO3No95wApdU90Ee0oHWaHfYFvqWvPy7cB8YK/+bztwh+85/clNmcxbdYIlzp3Af/pF/3HtIPXGSh0GL98InAGcC0wE+NG4sUsubJ14hGquZHiW4FLVzdpB6pWVOkxevgX4Ui+cMWvP3V/qzsg+2pFibAMwD7g4Ls+00mKljsD3Lpk+/ZKJE84heEJIo3aemFkLfBe41C/6q7TDxIGVOkJtC9qmAyWCR7nYzKydWwlcBlznF/3Xq/0hEdmdYKGLqQSXua5xzl3W79+fRTCldrJzrub389cDK7WCtgVtuwJzgU8CtoTR9n4HXAL8wi/6vUP9YQmWV57mnHtIRMYBDwInO+eW9xX+WmB/4FArtam5tgVtowimdn4cOAFI64ytLcBPgEtq/agbEVkEXOGcu11EbgK+CiwCZlqpTajaFrRNAT5MUPC0rCq6imBX+Qq/6P+51l8uIgWCLf/bgH8CjnPOnSkinVipTZTaFrQdQFDujwC7KcepJQc8ANwK3OoX/YfCGkhExgJ3ARcCi4E7gHc65ypWaqOmbUFbBjge+AAwG5hByGumheB14DcERS77Rf+lsAcUkYa+8W5zzn1LRNqA3wIb+z4ynWAv4TDnXOh5omaljpG2BW0twJEEE0mOAg4DxqqGenPPAL8kKNadftHvimpgERFgAfCqc+6/BvhMJ7alNvWobUFbFjiQN0p+FFCIaHgHdALLgSf6fl0OPKH5oHYRORq4G/AJ1vYG+LJz7pf9PtOJldrERduCtmZgWt9rlx1+7f/PrQw8oWczwdNA1wHr+35dQzAbaluBn/SLvs0Lr0NW6pRqW9CWA8YRzAXf7jWc68OmflipjUkYm09tTMJYqY1JGCu1MQljpTYmYazUxiSMldqYhLFSG5MwVmpjEsZKbUzCWKmNSRgrtTEJY6U2JmGs1MYkjJXamISxUhuTMFZqYxLGSm1MwlipjUkYK7UxCWOlNiZhrNTGJIyV2piEsVIbkzBWamMSxkptTMJYqY1JGCu1MQnz/7CVnk+ss896AAAAAElFTkSuQmCC\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": []
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 286
        },
        "id": "mQTXn-hGy_3m",
        "outputId": "d2ac88ea-83c4-4ada-f53b-f03385467980"
      },
      "source": [
        "dados['tempo'].value_counts().plot.bar()"
      ],
      "execution_count": 24,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7f9f2d0c1350>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 24
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX0AAAD7CAYAAACG50QgAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAATx0lEQVR4nO3dbaxd1Z3f8e8vODBD0mIDdyxqm9rTeCYiVUOIC4yoqhYSY0iFeZEwpKNiIavuC7eTaUczhekLayCoidQpDVWD5AZPTDQNISQRngwK45qMRq3Ew+WhhIdQ30CIbfFwgw0zCUqmJv++OMuZE8+9vufC9bkm6/uRrs7a/732PmvL8m9vrbPP2akqJEl9eMdiD0CSND6GviR1xNCXpI4Y+pLUEUNfkjpi6EtSR5Ys9gCO5cwzz6zVq1cv9jAk6W3l4Ycf/n5VTcy07oQO/dWrVzM5ObnYw5Ckt5Ukz8+2zukdSeqIoS9JHTH0Jakjhr4kdcTQl6SOGPqS1BFDX5I6YuhLUkdO6C9njdvq6/5ksYdwXH33Ux9Z7CFIWmRe6UtSRwx9SerISKGf5N8meTLJE0m+mOQXkqxJ8kCSqSRfSnJy63tKW55q61cP7ef6Vn8myaXH55AkSbOZM/STrAB+E1hXVX8fOAm4Gvg0cHNVvQc4BGxum2wGDrX6za0fSc5p270P2AB8NslJC3s4kqRjGXV6Zwnwi0mWAKcCLwAXA3e19TuBK1t7Y1umrb8kSVr9jqr6cVU9B0wB57/1Q5AkjWrO0K+qA8B/Ar7HIOxfAx4GXq2qw63bfmBFa68A9rVtD7f+ZwzXZ9jmp5JsSTKZZHJ6evrNHJMkaRajTO8sY3CVvgb4O8C7GEzPHBdVtb2q1lXVuomJGZ8BIEl6k0aZ3vkQ8FxVTVfV/wO+ClwELG3TPQArgQOtfQBYBdDWnwa8MlyfYRtJ0hiMEvrfAy5Mcmqbm78EeAr4JvDR1mcTcHdr72rLtPX3VVW1+tXt7p41wFrgwYU5DEnSKOb8Rm5VPZDkLuAR4DDwKLAd+BPgjiSfbLXb2ia3AV9IMgUcZHDHDlX1ZJI7GZwwDgNbq+qNBT4eSdIxjPQzDFW1Ddh2VPlZZrj7pqp+BHxslv3cBNw0zzFKI/FnNKS5+ds7khadJ+zx8WcYJKkjhr4kdcTQl6SOGPqS1BFDX5I6YuhLUkcMfUnqiKEvSR0x9CWpI4a+JHXE0Jekjhj6ktQRQ1+SOmLoS1JHDH1J6sgoD0b/1SSPDf39RZLfSnJ6kt1J9rbXZa1/ktySZCrJ40nOG9rXptZ/b5JNs7+rJOl4mDP0q+qZqjq3qs4FPgi8DnwNuA7YU1VrgT1tGeAyBs+/XQtsAW4FSHI6g6dvXcDgiVvbjpwoJEnjMd/pnUuA71TV88BGYGer7wSubO2NwO01cD+wNMlZwKXA7qo6WFWHgN3Ahrd8BJKkkc039K8Gvtjay6vqhdZ+EVje2iuAfUPb7G+12eo/I8mWJJNJJqenp+c5PEnSsYwc+klOBq4Avnz0uqoqoBZiQFW1varWVdW6iYmJhdilJKmZz5X+ZcAjVfVSW36pTdvQXl9u9QPAqqHtVrbabHVJ0pjMJ/Q/zl9P7QDsAo7cgbMJuHuofk27i+dC4LU2DXQvsD7JsvYB7vpWkySNyZJROiV5F/Bh4F8NlT8F3JlkM/A8cFWr3wNcDkwxuNPnWoCqOpjkRuCh1u+Gqjr4lo9AkjSykUK/qn4InHFU7RUGd/Mc3beArbPsZwewY/7DlCQtBL+RK0kdMfQlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOGPqS1BFDX5I6YuhLUkcMfUnqyEihn2RpkruSfDvJ00l+LcnpSXYn2dtel7W+SXJLkqkkjyc5b2g/m1r/vUk2zf6OkqTjYdQr/c8A36iq9wLvB54GrgP2VNVaYE9bhsED1Ne2vy3ArQBJTge2ARcA5wPbjpwoJEnjMWfoJzkN+MfAbQBV9VdV9SqwEdjZuu0ErmztjcDtNXA/sDTJWcClwO6qOlhVh4DdwIYFPRpJ0jGNcqW/BpgG/jDJo0k+1x6UvryqXmh9XgSWt/YKYN/Q9vtbbbb6z0iyJclkksnp6en5HY0k6ZhGCf0lwHnArVX1AeCH/PVUDvDTh6HXQgyoqrZX1bqqWjcxMbEQu5QkNaOE/n5gf1U90JbvYnASeKlN29BeX27rDwCrhrZf2Wqz1SVJYzJn6FfVi8C+JL/aSpcATwG7gCN34GwC7m7tXcA17S6eC4HX2jTQvcD6JMvaB7jrW02SNCZLRuz3b4A/SnIy8CxwLYMTxp1JNgPPA1e1vvcAlwNTwOutL1V1MMmNwEOt3w1VdXBBjkKSNJKRQr+qHgPWzbDqkhn6FrB1lv3sAHbMZ4CSpIXjN3IlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOGPqS1BFDX5I6YuhLUkcMfUnqiKEvSR0ZKfSTfDfJt5I8lmSy1U5PsjvJ3va6rNWT5JYkU0keT3Le0H42tf57k2ya7f0kScfHfK70/2lVnVtVR56gdR2wp6rWAnvaMsBlwNr2twW4FQYnCWAbcAFwPrDtyIlCkjQeb2V6ZyOws7V3AlcO1W+vgfuBpUnOAi4FdlfVwao6BOwGNryF95ckzdOooV/AnyZ5OMmWVlteVS+09ovA8tZeAewb2nZ/q81WlySNyUgPRgf+UVUdSPJLwO4k3x5eWVWVpBZiQO2ksgXg7LPPXohdSpKaka70q+pAe30Z+BqDOfmX2rQN7fXl1v0AsGpo85WtNlv96PfaXlXrqmrdxMTE/I5GknRMc4Z+kncl+VtH2sB64AlgF3DkDpxNwN2tvQu4pt3FcyHwWpsGuhdYn2RZ+wB3fatJksZklOmd5cDXkhzp/z+q6htJHgLuTLIZeB64qvW/B7gcmAJeB64FqKqDSW4EHmr9bqiqgwt2JJKkOc0Z+lX1LPD+GeqvAJfMUC9g6yz72gHsmP8wJUkLwW/kSlJHDH1J6oihL0kdMfQlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOGPqS1BFDX5I6MnLoJzkpyaNJvt6W1yR5IMlUki8lObnVT2nLU2396qF9XN/qzyS5dKEPRpJ0bPO50v8E8PTQ8qeBm6vqPcAhYHOrbwYOtfrNrR9JzgGuBt4HbAA+m+SktzZ8SdJ8jBT6SVYCHwE+15YDXAzc1brsBK5s7Y1tmbb+ktZ/I3BHVf24qp5j8Azd8xfiICRJoxn1Sv+/AL8L/KQtnwG8WlWH2/J+YEVrrwD2AbT1r7X+P63PsI0kaQzmDP0k/wx4uaoeHsN4SLIlyWSSyenp6XG8pSR1Y5Qr/YuAK5J8F7iDwbTOZ4ClSZa0PiuBA619AFgF0NafBrwyXJ9hm5+qqu1Vta6q1k1MTMz7gCRJs5sz9Kvq+qpaWVWrGXwQe19V/QbwTeCjrdsm4O7W3tWWaevvq6pq9avb3T1rgLXAgwt2JJKkOS2Zu8us/j1wR5JPAo8Ct7X6bcAXkkwBBxmcKKiqJ5PcCTwFHAa2VtUbb+H9JUnzNK/Qr6o/A/6stZ9lhrtvqupHwMdm2f4m4Kb5DlKStDD8Rq4kdcTQl6SOGPqS1BFDX5I6YuhLUkcMfUnqiKEvSR0x9CWpI4a+JHXE0Jekjhj6ktQRQ1+SOmLoS1JHDH1J6oihL0kdMfQlqSOjPBj9F5I8mOT/JHkyye+3+pokDySZSvKlJCe3+ilteaqtXz20r+tb/Zkklx6vg5IkzWyUK/0fAxdX1fuBc4ENSS4EPg3cXFXvAQ4Bm1v/zcChVr+59SPJOQwenfg+YAPw2SQnLeTBSJKObZQHo1dV/aAtvrP9FXAxcFer7wSubO2NbZm2/pIkafU7qurHVfUcMMUMj1uUJB0/I83pJzkpyWPAy8Bu4DvAq1V1uHXZD6xo7RXAPoC2/jXgjOH6DNtIksZgpNCvqjeq6lxgJYOr8/cerwEl2ZJkMsnk9PT08XobSerSvO7eqapXgW8CvwYsTbKkrVoJHGjtA8AqgLb+NOCV4foM2wy/x/aqWldV6yYmJuYzPEnSHEa5e2ciydLW/kXgw8DTDML/o63bJuDu1t7Vlmnr76uqavWr2909a4C1wIMLdSCSpLktmbsLZwE725027wDurKqvJ3kKuCPJJ4FHgdta/9uALySZAg4yuGOHqnoyyZ3AU8BhYGtVvbGwhyNJOpY5Q7+qHgc+MEP9WWa4+6aqfgR8bJZ93QTcNP9hSpIWgt/IlaSOGPqS1BFDX5I6YuhLUkcMfUnqiKEvSR0x9CWpI4a+JHXE0Jekjhj6ktQRQ1+SOmLoS1JHDH1J6oihL0kdMfQlqSOGviR1ZJTHJa5K8s0kTyV5MsknWv30JLuT7G2vy1o9SW5JMpXk8STnDe1rU+u/N8mm2d5TknR8jHKlfxj47ao6B7gQ2JrkHOA6YE9VrQX2tGWAyxg8/3YtsAW4FQYnCWAbcAGDJ25tO3KikCSNx5yhX1UvVNUjrf2XDB6KvgLYCOxs3XYCV7b2RuD2GrgfWJrkLOBSYHdVHayqQ8BuYMOCHo0k6ZjmNaefZDWD5+U+ACyvqhfaqheB5a29Atg3tNn+VputLkkak5FDP8m7ga8Av1VVfzG8rqoKqIUYUJItSSaTTE5PTy/ELiVJzUihn+SdDAL/j6rqq638Upu2ob2+3OoHgFVDm69stdnqP6OqtlfVuqpaNzExMZ9jkSTNYZS7dwLcBjxdVf95aNUu4MgdOJuAu4fq17S7eC4EXmvTQPcC65Msax/grm81SdKYLBmhz0XAvwC+leSxVvs94FPAnUk2A88DV7V19wCXA1PA68C1AFV1MMmNwEOt3w1VdXBBjkKSNJI5Q7+q/heQWVZfMkP/ArbOsq8dwI75DFCStHD8Rq4kdcTQl6SOGPqS1BFDX5I6YuhLUkcMfUnqiKEvSR0x9CWpI4a+JHXE0Jekjhj6ktQRQ1+SOmLoS1JHDH1J6oihL0kdMfQlqSOGviR1ZJRn5O5I8nKSJ4ZqpyfZnWRve13W6klyS5KpJI8nOW9om02t/94km2Z6L0nS8TXKlf7ngQ1H1a4D9lTVWmBPWwa4DFjb/rYAt8LgJAFsAy4Azge2HTlRSJLGZ87Qr6o/B45+gPlGYGdr7wSuHKrfXgP3A0uTnAVcCuyuqoNVdQjYzd88kUiSjrM3O6e/vKpeaO0XgeWtvQLYN9Rvf6vNVv8bkmxJMplkcnp6+k0OT5I0k7f8QW5VFVALMJYj+9teVeuqat3ExMRC7VaSxJsP/ZfatA3t9eVWPwCsGuq3stVmq0uSxujNhv4u4MgdOJuAu4fq17S7eC4EXmvTQPcC65Msax/grm81SdIYLZmrQ5IvAv8EODPJfgZ34XwKuDPJZuB54KrW/R7gcmAKeB24FqCqDia5EXio9buhqo7+cFiSdJzNGfpV9fFZVl0yQ98Cts6ynx3AjnmNTpK0oPxGriR1xNCXpI4Y+pLUEUNfkjpi6EtSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOGPqS1BFDX5I6YuhLUkcMfUnqiKEvSR0x9CWpI2MP/SQbkjyTZCrJdeN+f0nq2VhDP8lJwH8DLgPOAT6e5JxxjkGSejbuK/3zgamqeraq/gq4A9g45jFIUrfmfEbuAlsB7Bta3g9cMNwhyRZgS1v8QZJnxjS2xXAm8P1xvVk+Pa536ob/fm9fP+//dn93thXjDv05VdV2YPtij2MckkxW1brFHofeHP/93r56/rcb9/TOAWDV0PLKVpMkjcG4Q/8hYG2SNUlOBq4Gdo15DJLUrbFO71TV4ST/GrgXOAnYUVVPjnMMJ5guprF+jvnv9/bV7b9dqmqxxyBJGhO/kStJHTH0Jakjhr4kdcTQl9SdJL+02GNYLIb+mCT55SQ7knwyybuT/PckTyT5cpLViz0+HVuSv53kPyb5QpJ/ftS6zy7WuDS3JKcf9XcG8GCSZUlOX+zxjZuhPz6fZ/A9hR8A9wPfZvDDc98AdizesDSiPwQCfAW4OslXkpzS1l24eMPSCL4PPDz0N8ngJ2Eeae2ueMvmmCR5tKo+0Nrfq6qzZ1qnE1OSx6rq3KHl/wBcDlwB7K6q8xZtcDqmJL8NfBj4nar6Vqs9V1VrFndki+OE++2dn2M/SfIrwGnAqUnWVdVkkvcw+KKaTmynJHlHVf0EoKpuSnIA+HPg3Ys7NB1LVf1Bki8BNyfZB2wDur3aNfTH53eBPwZ+AlwJXJ/kHzA4CWw51oY6IfwxcDHwP48UqurzSV4E/uuijUojqar9wMeSXAHsBk5d5CEtGqd3FlGSrwNXHLl61IkryW8CX6uqfXN21gknyXsZzOM/ALwB/L2qeiLJhqr6xuKObrwM/TFJMtMPy10M3AdQVVeMd0SajySvAT8EvgN8EfhyVU0v7qg0inbC3go8DZwLfKKq7m7rHunt8xind8ZnFfAk8DkG84kB/iHwB4s5KI3sWeCDwIeAXwd+P8nDDE4AX62qv1zMwemY/iXwwar6Qbs9+q4kq6vqMwz+H3bFK/0xSfIO4BMM7vj4nap6LMmzVfXLizw0jeDoK8Ik72Rwy+3HgQ9V1cSiDU7HlOTJqnrf0PK7gbuAp4CLh+/K6oGhP2ZJVgI3Ay8xmM8/e45NdAI41m21SU6tqtfHPSaNJsl9wL+rqseGaksYfD/mN6qqq7vnDP1FkuQjwEVV9XuLPRbNLcmvVNX/XexxaP7ahdbhqnpxhnUXVdX/XoRhLRpDX5I64s8wSFJHDH1J6oihL0kdMfQlqSOGviR15P8DM6e/nzPiDjoAAAAASUVORK5CYII=\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 256
        },
        "id": "OM_iz_jtz6EH",
        "outputId": "2e1e3586-c50b-48bc-8d28-a6e3282626cd"
      },
      "source": [
        "dados_filtrados = dados[dados['g-0'] > 0]\n",
        "dados_filtrados.head()"
      ],
      "execution_count": 25,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>id</th>\n",
              "      <th>tratamento</th>\n",
              "      <th>tempo</th>\n",
              "      <th>dose</th>\n",
              "      <th>droga</th>\n",
              "      <th>g-0</th>\n",
              "      <th>g-1</th>\n",
              "      <th>g-2</th>\n",
              "      <th>g-3</th>\n",
              "      <th>g-4</th>\n",
              "      <th>g-5</th>\n",
              "      <th>g-6</th>\n",
              "      <th>g-7</th>\n",
              "      <th>g-8</th>\n",
              "      <th>g-9</th>\n",
              "      <th>g-10</th>\n",
              "      <th>g-11</th>\n",
              "      <th>g-12</th>\n",
              "      <th>g-13</th>\n",
              "      <th>g-14</th>\n",
              "      <th>g-15</th>\n",
              "      <th>g-16</th>\n",
              "      <th>g-17</th>\n",
              "      <th>g-18</th>\n",
              "      <th>g-19</th>\n",
              "      <th>g-20</th>\n",
              "      <th>g-21</th>\n",
              "      <th>g-22</th>\n",
              "      <th>g-23</th>\n",
              "      <th>g-24</th>\n",
              "      <th>g-25</th>\n",
              "      <th>g-26</th>\n",
              "      <th>g-27</th>\n",
              "      <th>g-28</th>\n",
              "      <th>g-29</th>\n",
              "      <th>g-30</th>\n",
              "      <th>g-31</th>\n",
              "      <th>g-32</th>\n",
              "      <th>g-33</th>\n",
              "      <th>g-34</th>\n",
              "      <th>...</th>\n",
              "      <th>c-60</th>\n",
              "      <th>c-61</th>\n",
              "      <th>c-62</th>\n",
              "      <th>c-63</th>\n",
              "      <th>c-64</th>\n",
              "      <th>c-65</th>\n",
              "      <th>c-66</th>\n",
              "      <th>c-67</th>\n",
              "      <th>c-68</th>\n",
              "      <th>c-69</th>\n",
              "      <th>c-70</th>\n",
              "      <th>c-71</th>\n",
              "      <th>c-72</th>\n",
              "      <th>c-73</th>\n",
              "      <th>c-74</th>\n",
              "      <th>c-75</th>\n",
              "      <th>c-76</th>\n",
              "      <th>c-77</th>\n",
              "      <th>c-78</th>\n",
              "      <th>c-79</th>\n",
              "      <th>c-80</th>\n",
              "      <th>c-81</th>\n",
              "      <th>c-82</th>\n",
              "      <th>c-83</th>\n",
              "      <th>c-84</th>\n",
              "      <th>c-85</th>\n",
              "      <th>c-86</th>\n",
              "      <th>c-87</th>\n",
              "      <th>c-88</th>\n",
              "      <th>c-89</th>\n",
              "      <th>c-90</th>\n",
              "      <th>c-91</th>\n",
              "      <th>c-92</th>\n",
              "      <th>c-93</th>\n",
              "      <th>c-94</th>\n",
              "      <th>c-95</th>\n",
              "      <th>c-96</th>\n",
              "      <th>c-97</th>\n",
              "      <th>c-98</th>\n",
              "      <th>c-99</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>id_000644bb2</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>b68db1d53</td>\n",
              "      <td>1.0620</td>\n",
              "      <td>0.5577</td>\n",
              "      <td>-0.2479</td>\n",
              "      <td>-0.6208</td>\n",
              "      <td>-0.1944</td>\n",
              "      <td>-1.0120</td>\n",
              "      <td>-1.0220</td>\n",
              "      <td>-0.0326</td>\n",
              "      <td>0.5548</td>\n",
              "      <td>-0.0921</td>\n",
              "      <td>1.1830</td>\n",
              "      <td>0.1530</td>\n",
              "      <td>0.5574</td>\n",
              "      <td>-0.4015</td>\n",
              "      <td>0.1789</td>\n",
              "      <td>-0.6528</td>\n",
              "      <td>-0.7969</td>\n",
              "      <td>0.6342</td>\n",
              "      <td>0.1778</td>\n",
              "      <td>-0.3694</td>\n",
              "      <td>-0.5688</td>\n",
              "      <td>-1.1360</td>\n",
              "      <td>-1.1880</td>\n",
              "      <td>0.6940</td>\n",
              "      <td>0.4393</td>\n",
              "      <td>0.2664</td>\n",
              "      <td>0.1907</td>\n",
              "      <td>0.1628</td>\n",
              "      <td>-0.2853</td>\n",
              "      <td>0.5819</td>\n",
              "      <td>0.2934</td>\n",
              "      <td>-0.5584</td>\n",
              "      <td>-0.0916</td>\n",
              "      <td>-0.3010</td>\n",
              "      <td>-0.1537</td>\n",
              "      <td>...</td>\n",
              "      <td>0.4805</td>\n",
              "      <td>0.4965</td>\n",
              "      <td>0.3680</td>\n",
              "      <td>0.8427</td>\n",
              "      <td>0.1042</td>\n",
              "      <td>0.1403</td>\n",
              "      <td>0.1758</td>\n",
              "      <td>1.2570</td>\n",
              "      <td>-0.5979</td>\n",
              "      <td>1.2250</td>\n",
              "      <td>-0.0553</td>\n",
              "      <td>0.7351</td>\n",
              "      <td>0.5810</td>\n",
              "      <td>0.9590</td>\n",
              "      <td>0.2427</td>\n",
              "      <td>0.0495</td>\n",
              "      <td>0.4141</td>\n",
              "      <td>0.8432</td>\n",
              "      <td>0.6162</td>\n",
              "      <td>-0.7318</td>\n",
              "      <td>1.2120</td>\n",
              "      <td>0.6362</td>\n",
              "      <td>-0.4427</td>\n",
              "      <td>0.1288</td>\n",
              "      <td>1.4840</td>\n",
              "      <td>0.1799</td>\n",
              "      <td>0.5367</td>\n",
              "      <td>-0.1111</td>\n",
              "      <td>-1.0120</td>\n",
              "      <td>0.6685</td>\n",
              "      <td>0.2862</td>\n",
              "      <td>0.2584</td>\n",
              "      <td>0.8076</td>\n",
              "      <td>0.5523</td>\n",
              "      <td>-0.1912</td>\n",
              "      <td>0.6584</td>\n",
              "      <td>-0.3981</td>\n",
              "      <td>0.2139</td>\n",
              "      <td>0.3801</td>\n",
              "      <td>0.4176</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>id_000779bfc</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>72</td>\n",
              "      <td>D1</td>\n",
              "      <td>df89a8e5a</td>\n",
              "      <td>0.0743</td>\n",
              "      <td>0.4087</td>\n",
              "      <td>0.2991</td>\n",
              "      <td>0.0604</td>\n",
              "      <td>1.0190</td>\n",
              "      <td>0.5207</td>\n",
              "      <td>0.2341</td>\n",
              "      <td>0.3372</td>\n",
              "      <td>-0.4047</td>\n",
              "      <td>0.8507</td>\n",
              "      <td>-1.1520</td>\n",
              "      <td>-0.4201</td>\n",
              "      <td>-0.0958</td>\n",
              "      <td>0.4590</td>\n",
              "      <td>0.0803</td>\n",
              "      <td>0.2250</td>\n",
              "      <td>0.5293</td>\n",
              "      <td>0.2839</td>\n",
              "      <td>-0.3494</td>\n",
              "      <td>0.2883</td>\n",
              "      <td>0.9449</td>\n",
              "      <td>-0.1646</td>\n",
              "      <td>-0.2657</td>\n",
              "      <td>-0.3372</td>\n",
              "      <td>0.3135</td>\n",
              "      <td>-0.4316</td>\n",
              "      <td>0.4773</td>\n",
              "      <td>0.2075</td>\n",
              "      <td>-0.4216</td>\n",
              "      <td>-0.1161</td>\n",
              "      <td>-0.0499</td>\n",
              "      <td>-0.2627</td>\n",
              "      <td>0.9959</td>\n",
              "      <td>-0.2483</td>\n",
              "      <td>0.2655</td>\n",
              "      <td>...</td>\n",
              "      <td>0.4083</td>\n",
              "      <td>0.0319</td>\n",
              "      <td>0.3905</td>\n",
              "      <td>0.7099</td>\n",
              "      <td>0.2912</td>\n",
              "      <td>0.4151</td>\n",
              "      <td>-0.2840</td>\n",
              "      <td>-0.3104</td>\n",
              "      <td>-0.6373</td>\n",
              "      <td>0.2887</td>\n",
              "      <td>-0.0765</td>\n",
              "      <td>0.2539</td>\n",
              "      <td>0.4443</td>\n",
              "      <td>0.5932</td>\n",
              "      <td>0.2031</td>\n",
              "      <td>0.7639</td>\n",
              "      <td>0.5499</td>\n",
              "      <td>-0.3322</td>\n",
              "      <td>-0.0977</td>\n",
              "      <td>0.4329</td>\n",
              "      <td>-0.2782</td>\n",
              "      <td>0.7827</td>\n",
              "      <td>0.5934</td>\n",
              "      <td>0.3402</td>\n",
              "      <td>0.1499</td>\n",
              "      <td>0.4420</td>\n",
              "      <td>0.9366</td>\n",
              "      <td>0.8193</td>\n",
              "      <td>-0.4236</td>\n",
              "      <td>0.3192</td>\n",
              "      <td>-0.4265</td>\n",
              "      <td>0.7543</td>\n",
              "      <td>0.4708</td>\n",
              "      <td>0.0230</td>\n",
              "      <td>0.2957</td>\n",
              "      <td>0.4899</td>\n",
              "      <td>0.1522</td>\n",
              "      <td>0.1241</td>\n",
              "      <td>0.6077</td>\n",
              "      <td>0.7371</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>id_000a6266a</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>48</td>\n",
              "      <td>D1</td>\n",
              "      <td>18bb41b2c</td>\n",
              "      <td>0.6280</td>\n",
              "      <td>0.5817</td>\n",
              "      <td>1.5540</td>\n",
              "      <td>-0.0764</td>\n",
              "      <td>-0.0323</td>\n",
              "      <td>1.2390</td>\n",
              "      <td>0.1715</td>\n",
              "      <td>0.2155</td>\n",
              "      <td>0.0065</td>\n",
              "      <td>1.2300</td>\n",
              "      <td>-0.4797</td>\n",
              "      <td>-0.5631</td>\n",
              "      <td>-0.0366</td>\n",
              "      <td>-1.8300</td>\n",
              "      <td>0.6057</td>\n",
              "      <td>-0.3278</td>\n",
              "      <td>0.6042</td>\n",
              "      <td>-0.3075</td>\n",
              "      <td>-0.1147</td>\n",
              "      <td>-0.0570</td>\n",
              "      <td>-0.0799</td>\n",
              "      <td>-0.8181</td>\n",
              "      <td>-1.5320</td>\n",
              "      <td>0.2307</td>\n",
              "      <td>0.4901</td>\n",
              "      <td>0.4780</td>\n",
              "      <td>-1.3970</td>\n",
              "      <td>4.6240</td>\n",
              "      <td>-0.0437</td>\n",
              "      <td>1.2870</td>\n",
              "      <td>-1.8530</td>\n",
              "      <td>0.6069</td>\n",
              "      <td>0.4290</td>\n",
              "      <td>0.1783</td>\n",
              "      <td>0.0018</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.5477</td>\n",
              "      <td>-0.7576</td>\n",
              "      <td>-0.0444</td>\n",
              "      <td>0.1894</td>\n",
              "      <td>-0.0014</td>\n",
              "      <td>-2.3640</td>\n",
              "      <td>-0.4682</td>\n",
              "      <td>0.1210</td>\n",
              "      <td>-0.5177</td>\n",
              "      <td>-0.0604</td>\n",
              "      <td>0.1682</td>\n",
              "      <td>-0.4436</td>\n",
              "      <td>0.4963</td>\n",
              "      <td>0.1363</td>\n",
              "      <td>0.3335</td>\n",
              "      <td>0.9760</td>\n",
              "      <td>-0.0427</td>\n",
              "      <td>-0.1235</td>\n",
              "      <td>0.0959</td>\n",
              "      <td>0.0690</td>\n",
              "      <td>-0.9416</td>\n",
              "      <td>-0.7548</td>\n",
              "      <td>-0.1109</td>\n",
              "      <td>-0.6272</td>\n",
              "      <td>0.3019</td>\n",
              "      <td>0.1172</td>\n",
              "      <td>0.1093</td>\n",
              "      <td>-0.3113</td>\n",
              "      <td>0.3019</td>\n",
              "      <td>-0.0873</td>\n",
              "      <td>-0.7250</td>\n",
              "      <td>-0.6297</td>\n",
              "      <td>0.6103</td>\n",
              "      <td>0.0223</td>\n",
              "      <td>-1.3240</td>\n",
              "      <td>-0.3174</td>\n",
              "      <td>-0.6417</td>\n",
              "      <td>-0.2187</td>\n",
              "      <td>-1.4080</td>\n",
              "      <td>0.6931</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>id_001bd861f</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D2</td>\n",
              "      <td>746ca1f5a</td>\n",
              "      <td>2.0440</td>\n",
              "      <td>1.7000</td>\n",
              "      <td>-1.5390</td>\n",
              "      <td>5.9440</td>\n",
              "      <td>-2.1670</td>\n",
              "      <td>-4.0360</td>\n",
              "      <td>3.6950</td>\n",
              "      <td>1.4530</td>\n",
              "      <td>0.9724</td>\n",
              "      <td>-2.4380</td>\n",
              "      <td>5.1340</td>\n",
              "      <td>-4.6600</td>\n",
              "      <td>5.7960</td>\n",
              "      <td>4.9700</td>\n",
              "      <td>1.5540</td>\n",
              "      <td>2.4790</td>\n",
              "      <td>-3.8010</td>\n",
              "      <td>-1.0230</td>\n",
              "      <td>5.3110</td>\n",
              "      <td>-0.5660</td>\n",
              "      <td>-4.4450</td>\n",
              "      <td>1.2210</td>\n",
              "      <td>1.3750</td>\n",
              "      <td>0.3932</td>\n",
              "      <td>0.3392</td>\n",
              "      <td>4.3510</td>\n",
              "      <td>5.7540</td>\n",
              "      <td>-1.6590</td>\n",
              "      <td>5.3000</td>\n",
              "      <td>5.6050</td>\n",
              "      <td>5.5320</td>\n",
              "      <td>3.7860</td>\n",
              "      <td>0.9197</td>\n",
              "      <td>1.9310</td>\n",
              "      <td>2.4870</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.8904</td>\n",
              "      <td>2.0590</td>\n",
              "      <td>0.5052</td>\n",
              "      <td>0.6890</td>\n",
              "      <td>0.5340</td>\n",
              "      <td>0.5135</td>\n",
              "      <td>0.6507</td>\n",
              "      <td>0.9838</td>\n",
              "      <td>0.4532</td>\n",
              "      <td>-0.3212</td>\n",
              "      <td>0.2662</td>\n",
              "      <td>0.6864</td>\n",
              "      <td>1.6300</td>\n",
              "      <td>1.3810</td>\n",
              "      <td>0.0061</td>\n",
              "      <td>0.2908</td>\n",
              "      <td>0.2598</td>\n",
              "      <td>0.1266</td>\n",
              "      <td>-0.3526</td>\n",
              "      <td>1.1750</td>\n",
              "      <td>-1.1030</td>\n",
              "      <td>1.3650</td>\n",
              "      <td>1.0610</td>\n",
              "      <td>0.4034</td>\n",
              "      <td>1.0880</td>\n",
              "      <td>-0.4230</td>\n",
              "      <td>0.4013</td>\n",
              "      <td>0.1726</td>\n",
              "      <td>0.7464</td>\n",
              "      <td>0.9418</td>\n",
              "      <td>0.1855</td>\n",
              "      <td>1.1720</td>\n",
              "      <td>0.8325</td>\n",
              "      <td>0.6486</td>\n",
              "      <td>0.8090</td>\n",
              "      <td>1.5880</td>\n",
              "      <td>2.4670</td>\n",
              "      <td>0.0357</td>\n",
              "      <td>0.1351</td>\n",
              "      <td>-0.3179</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>id_0020d0484</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>48</td>\n",
              "      <td>D1</td>\n",
              "      <td>8b87a7a83</td>\n",
              "      <td>0.2711</td>\n",
              "      <td>0.5133</td>\n",
              "      <td>-0.1327</td>\n",
              "      <td>2.5950</td>\n",
              "      <td>0.6980</td>\n",
              "      <td>0.5846</td>\n",
              "      <td>-0.2633</td>\n",
              "      <td>-2.1490</td>\n",
              "      <td>0.4881</td>\n",
              "      <td>1.4750</td>\n",
              "      <td>-0.0488</td>\n",
              "      <td>-0.0561</td>\n",
              "      <td>0.1641</td>\n",
              "      <td>0.1749</td>\n",
              "      <td>-0.3464</td>\n",
              "      <td>-0.1811</td>\n",
              "      <td>0.5685</td>\n",
              "      <td>1.2970</td>\n",
              "      <td>1.0510</td>\n",
              "      <td>-0.9585</td>\n",
              "      <td>0.7911</td>\n",
              "      <td>-0.2991</td>\n",
              "      <td>2.7420</td>\n",
              "      <td>-0.5979</td>\n",
              "      <td>-1.0240</td>\n",
              "      <td>0.7268</td>\n",
              "      <td>0.1590</td>\n",
              "      <td>-1.9730</td>\n",
              "      <td>1.1340</td>\n",
              "      <td>-2.5720</td>\n",
              "      <td>0.2068</td>\n",
              "      <td>0.9992</td>\n",
              "      <td>-0.1958</td>\n",
              "      <td>0.2262</td>\n",
              "      <td>1.0140</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.2623</td>\n",
              "      <td>-0.5500</td>\n",
              "      <td>-0.0530</td>\n",
              "      <td>0.2077</td>\n",
              "      <td>-0.0825</td>\n",
              "      <td>0.2156</td>\n",
              "      <td>0.8142</td>\n",
              "      <td>1.0990</td>\n",
              "      <td>1.0860</td>\n",
              "      <td>0.4011</td>\n",
              "      <td>-0.1342</td>\n",
              "      <td>0.4653</td>\n",
              "      <td>-0.1104</td>\n",
              "      <td>0.3935</td>\n",
              "      <td>1.2370</td>\n",
              "      <td>-0.5072</td>\n",
              "      <td>0.0351</td>\n",
              "      <td>0.5084</td>\n",
              "      <td>-0.1248</td>\n",
              "      <td>0.4351</td>\n",
              "      <td>0.1389</td>\n",
              "      <td>0.6726</td>\n",
              "      <td>0.6070</td>\n",
              "      <td>0.3431</td>\n",
              "      <td>-0.4116</td>\n",
              "      <td>0.1194</td>\n",
              "      <td>0.3420</td>\n",
              "      <td>0.1331</td>\n",
              "      <td>0.8541</td>\n",
              "      <td>0.6282</td>\n",
              "      <td>0.3230</td>\n",
              "      <td>-0.4140</td>\n",
              "      <td>0.2532</td>\n",
              "      <td>0.0513</td>\n",
              "      <td>0.8600</td>\n",
              "      <td>1.4250</td>\n",
              "      <td>0.6633</td>\n",
              "      <td>0.4562</td>\n",
              "      <td>-0.9622</td>\n",
              "      <td>0.0260</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",
              "6  id_001bd861f  com_droga     24   D2  ...  2.4670  0.0357  0.1351 -0.3179\n",
              "7  id_0020d0484  com_droga     48   D1  ...  0.6633  0.4562 -0.9622  0.0260\n",
              "\n",
              "[5 rows x 877 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 25
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "4PDtixak0b-Z"
      },
      "source": [
        "### Desafio 5: Procurar na documentação o método query (pandas)."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 0
        },
        "id": "6X43sR03ewQh",
        "outputId": "820c108a-be7d-42af-e1e5-070ae1957a5e"
      },
      "source": [
        "dados.query('`g-0` > `g-1` and `g-1` > `g-2`').head()"
      ],
      "execution_count": 26,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>id</th>\n",
              "      <th>tratamento</th>\n",
              "      <th>tempo</th>\n",
              "      <th>dose</th>\n",
              "      <th>droga</th>\n",
              "      <th>g-0</th>\n",
              "      <th>g-1</th>\n",
              "      <th>g-2</th>\n",
              "      <th>g-3</th>\n",
              "      <th>g-4</th>\n",
              "      <th>g-5</th>\n",
              "      <th>g-6</th>\n",
              "      <th>g-7</th>\n",
              "      <th>g-8</th>\n",
              "      <th>g-9</th>\n",
              "      <th>g-10</th>\n",
              "      <th>g-11</th>\n",
              "      <th>g-12</th>\n",
              "      <th>g-13</th>\n",
              "      <th>g-14</th>\n",
              "      <th>g-15</th>\n",
              "      <th>g-16</th>\n",
              "      <th>g-17</th>\n",
              "      <th>g-18</th>\n",
              "      <th>g-19</th>\n",
              "      <th>g-20</th>\n",
              "      <th>g-21</th>\n",
              "      <th>g-22</th>\n",
              "      <th>g-23</th>\n",
              "      <th>g-24</th>\n",
              "      <th>g-25</th>\n",
              "      <th>g-26</th>\n",
              "      <th>g-27</th>\n",
              "      <th>g-28</th>\n",
              "      <th>g-29</th>\n",
              "      <th>g-30</th>\n",
              "      <th>g-31</th>\n",
              "      <th>g-32</th>\n",
              "      <th>g-33</th>\n",
              "      <th>g-34</th>\n",
              "      <th>...</th>\n",
              "      <th>c-60</th>\n",
              "      <th>c-61</th>\n",
              "      <th>c-62</th>\n",
              "      <th>c-63</th>\n",
              "      <th>c-64</th>\n",
              "      <th>c-65</th>\n",
              "      <th>c-66</th>\n",
              "      <th>c-67</th>\n",
              "      <th>c-68</th>\n",
              "      <th>c-69</th>\n",
              "      <th>c-70</th>\n",
              "      <th>c-71</th>\n",
              "      <th>c-72</th>\n",
              "      <th>c-73</th>\n",
              "      <th>c-74</th>\n",
              "      <th>c-75</th>\n",
              "      <th>c-76</th>\n",
              "      <th>c-77</th>\n",
              "      <th>c-78</th>\n",
              "      <th>c-79</th>\n",
              "      <th>c-80</th>\n",
              "      <th>c-81</th>\n",
              "      <th>c-82</th>\n",
              "      <th>c-83</th>\n",
              "      <th>c-84</th>\n",
              "      <th>c-85</th>\n",
              "      <th>c-86</th>\n",
              "      <th>c-87</th>\n",
              "      <th>c-88</th>\n",
              "      <th>c-89</th>\n",
              "      <th>c-90</th>\n",
              "      <th>c-91</th>\n",
              "      <th>c-92</th>\n",
              "      <th>c-93</th>\n",
              "      <th>c-94</th>\n",
              "      <th>c-95</th>\n",
              "      <th>c-96</th>\n",
              "      <th>c-97</th>\n",
              "      <th>c-98</th>\n",
              "      <th>c-99</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>id_000644bb2</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>b68db1d53</td>\n",
              "      <td>1.0620</td>\n",
              "      <td>0.5577</td>\n",
              "      <td>-0.2479</td>\n",
              "      <td>-0.6208</td>\n",
              "      <td>-0.1944</td>\n",
              "      <td>-1.0120</td>\n",
              "      <td>-1.0220</td>\n",
              "      <td>-0.0326</td>\n",
              "      <td>0.5548</td>\n",
              "      <td>-0.0921</td>\n",
              "      <td>1.1830</td>\n",
              "      <td>0.1530</td>\n",
              "      <td>0.5574</td>\n",
              "      <td>-0.4015</td>\n",
              "      <td>0.1789</td>\n",
              "      <td>-0.6528</td>\n",
              "      <td>-0.7969</td>\n",
              "      <td>0.6342</td>\n",
              "      <td>0.1778</td>\n",
              "      <td>-0.3694</td>\n",
              "      <td>-0.5688</td>\n",
              "      <td>-1.1360</td>\n",
              "      <td>-1.1880</td>\n",
              "      <td>0.6940</td>\n",
              "      <td>0.4393</td>\n",
              "      <td>0.2664</td>\n",
              "      <td>0.1907</td>\n",
              "      <td>0.1628</td>\n",
              "      <td>-0.2853</td>\n",
              "      <td>0.5819</td>\n",
              "      <td>0.2934</td>\n",
              "      <td>-0.5584</td>\n",
              "      <td>-0.0916</td>\n",
              "      <td>-0.3010</td>\n",
              "      <td>-0.1537</td>\n",
              "      <td>...</td>\n",
              "      <td>0.4805</td>\n",
              "      <td>0.4965</td>\n",
              "      <td>0.3680</td>\n",
              "      <td>0.8427</td>\n",
              "      <td>0.1042</td>\n",
              "      <td>0.1403</td>\n",
              "      <td>0.1758</td>\n",
              "      <td>1.2570</td>\n",
              "      <td>-0.5979</td>\n",
              "      <td>1.2250</td>\n",
              "      <td>-0.0553</td>\n",
              "      <td>0.7351</td>\n",
              "      <td>0.5810</td>\n",
              "      <td>0.9590</td>\n",
              "      <td>0.2427</td>\n",
              "      <td>0.0495</td>\n",
              "      <td>0.4141</td>\n",
              "      <td>0.8432</td>\n",
              "      <td>0.6162</td>\n",
              "      <td>-0.7318</td>\n",
              "      <td>1.2120</td>\n",
              "      <td>0.6362</td>\n",
              "      <td>-0.4427</td>\n",
              "      <td>0.1288</td>\n",
              "      <td>1.4840</td>\n",
              "      <td>0.1799</td>\n",
              "      <td>0.5367</td>\n",
              "      <td>-0.1111</td>\n",
              "      <td>-1.0120</td>\n",
              "      <td>0.6685</td>\n",
              "      <td>0.2862</td>\n",
              "      <td>0.2584</td>\n",
              "      <td>0.8076</td>\n",
              "      <td>0.5523</td>\n",
              "      <td>-0.1912</td>\n",
              "      <td>0.6584</td>\n",
              "      <td>-0.3981</td>\n",
              "      <td>0.2139</td>\n",
              "      <td>0.3801</td>\n",
              "      <td>0.4176</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>id_001bd861f</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D2</td>\n",
              "      <td>746ca1f5a</td>\n",
              "      <td>2.0440</td>\n",
              "      <td>1.7000</td>\n",
              "      <td>-1.5390</td>\n",
              "      <td>5.9440</td>\n",
              "      <td>-2.1670</td>\n",
              "      <td>-4.0360</td>\n",
              "      <td>3.6950</td>\n",
              "      <td>1.4530</td>\n",
              "      <td>0.9724</td>\n",
              "      <td>-2.4380</td>\n",
              "      <td>5.1340</td>\n",
              "      <td>-4.6600</td>\n",
              "      <td>5.7960</td>\n",
              "      <td>4.9700</td>\n",
              "      <td>1.5540</td>\n",
              "      <td>2.4790</td>\n",
              "      <td>-3.8010</td>\n",
              "      <td>-1.0230</td>\n",
              "      <td>5.3110</td>\n",
              "      <td>-0.5660</td>\n",
              "      <td>-4.4450</td>\n",
              "      <td>1.2210</td>\n",
              "      <td>1.3750</td>\n",
              "      <td>0.3932</td>\n",
              "      <td>0.3392</td>\n",
              "      <td>4.3510</td>\n",
              "      <td>5.7540</td>\n",
              "      <td>-1.6590</td>\n",
              "      <td>5.3000</td>\n",
              "      <td>5.6050</td>\n",
              "      <td>5.5320</td>\n",
              "      <td>3.7860</td>\n",
              "      <td>0.9197</td>\n",
              "      <td>1.9310</td>\n",
              "      <td>2.4870</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.8904</td>\n",
              "      <td>2.0590</td>\n",
              "      <td>0.5052</td>\n",
              "      <td>0.6890</td>\n",
              "      <td>0.5340</td>\n",
              "      <td>0.5135</td>\n",
              "      <td>0.6507</td>\n",
              "      <td>0.9838</td>\n",
              "      <td>0.4532</td>\n",
              "      <td>-0.3212</td>\n",
              "      <td>0.2662</td>\n",
              "      <td>0.6864</td>\n",
              "      <td>1.6300</td>\n",
              "      <td>1.3810</td>\n",
              "      <td>0.0061</td>\n",
              "      <td>0.2908</td>\n",
              "      <td>0.2598</td>\n",
              "      <td>0.1266</td>\n",
              "      <td>-0.3526</td>\n",
              "      <td>1.1750</td>\n",
              "      <td>-1.1030</td>\n",
              "      <td>1.3650</td>\n",
              "      <td>1.0610</td>\n",
              "      <td>0.4034</td>\n",
              "      <td>1.0880</td>\n",
              "      <td>-0.4230</td>\n",
              "      <td>0.4013</td>\n",
              "      <td>0.1726</td>\n",
              "      <td>0.7464</td>\n",
              "      <td>0.9418</td>\n",
              "      <td>0.1855</td>\n",
              "      <td>1.1720</td>\n",
              "      <td>0.8325</td>\n",
              "      <td>0.6486</td>\n",
              "      <td>0.8090</td>\n",
              "      <td>1.5880</td>\n",
              "      <td>2.4670</td>\n",
              "      <td>0.0357</td>\n",
              "      <td>0.1351</td>\n",
              "      <td>-0.3179</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>id_0024bcd70</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>48</td>\n",
              "      <td>D2</td>\n",
              "      <td>b877aa048</td>\n",
              "      <td>-0.3864</td>\n",
              "      <td>-0.5551</td>\n",
              "      <td>-0.8978</td>\n",
              "      <td>-0.2616</td>\n",
              "      <td>-0.2801</td>\n",
              "      <td>-0.7128</td>\n",
              "      <td>-0.2960</td>\n",
              "      <td>-0.1811</td>\n",
              "      <td>0.4521</td>\n",
              "      <td>1.6000</td>\n",
              "      <td>-0.2325</td>\n",
              "      <td>0.2750</td>\n",
              "      <td>-0.3063</td>\n",
              "      <td>0.4162</td>\n",
              "      <td>0.4514</td>\n",
              "      <td>-0.1926</td>\n",
              "      <td>-0.3090</td>\n",
              "      <td>0.2198</td>\n",
              "      <td>-0.5743</td>\n",
              "      <td>-0.3183</td>\n",
              "      <td>-0.4053</td>\n",
              "      <td>-0.5434</td>\n",
              "      <td>0.4164</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.5475</td>\n",
              "      <td>0.3858</td>\n",
              "      <td>0.0109</td>\n",
              "      <td>-0.4169</td>\n",
              "      <td>0.2151</td>\n",
              "      <td>0.3453</td>\n",
              "      <td>-0.7071</td>\n",
              "      <td>-0.0849</td>\n",
              "      <td>-0.2968</td>\n",
              "      <td>0.1824</td>\n",
              "      <td>0.8732</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.0314</td>\n",
              "      <td>-0.5320</td>\n",
              "      <td>0.0589</td>\n",
              "      <td>0.8906</td>\n",
              "      <td>0.6207</td>\n",
              "      <td>0.0469</td>\n",
              "      <td>0.3254</td>\n",
              "      <td>0.0787</td>\n",
              "      <td>0.2399</td>\n",
              "      <td>0.3990</td>\n",
              "      <td>0.1501</td>\n",
              "      <td>0.4105</td>\n",
              "      <td>0.3239</td>\n",
              "      <td>-0.5079</td>\n",
              "      <td>-0.7841</td>\n",
              "      <td>0.2495</td>\n",
              "      <td>-0.0202</td>\n",
              "      <td>0.7055</td>\n",
              "      <td>0.3081</td>\n",
              "      <td>0.2200</td>\n",
              "      <td>-0.5511</td>\n",
              "      <td>-0.1174</td>\n",
              "      <td>0.2932</td>\n",
              "      <td>0.6291</td>\n",
              "      <td>-0.9436</td>\n",
              "      <td>-1.0680</td>\n",
              "      <td>0.5833</td>\n",
              "      <td>-0.0413</td>\n",
              "      <td>0.1107</td>\n",
              "      <td>0.6545</td>\n",
              "      <td>0.2856</td>\n",
              "      <td>-0.1953</td>\n",
              "      <td>0.7269</td>\n",
              "      <td>-0.5909</td>\n",
              "      <td>-0.0241</td>\n",
              "      <td>0.0299</td>\n",
              "      <td>0.2731</td>\n",
              "      <td>0.6306</td>\n",
              "      <td>0.8285</td>\n",
              "      <td>0.3605</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>id_003603254</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>72</td>\n",
              "      <td>D2</td>\n",
              "      <td>3cda750b5</td>\n",
              "      <td>-0.4694</td>\n",
              "      <td>-1.5180</td>\n",
              "      <td>-2.0430</td>\n",
              "      <td>0.5750</td>\n",
              "      <td>0.5077</td>\n",
              "      <td>0.2880</td>\n",
              "      <td>-0.3198</td>\n",
              "      <td>-0.6101</td>\n",
              "      <td>0.1249</td>\n",
              "      <td>0.4362</td>\n",
              "      <td>-0.6237</td>\n",
              "      <td>0.5495</td>\n",
              "      <td>-1.3170</td>\n",
              "      <td>-1.1880</td>\n",
              "      <td>-1.1790</td>\n",
              "      <td>0.5008</td>\n",
              "      <td>-0.0821</td>\n",
              "      <td>0.1371</td>\n",
              "      <td>-0.2100</td>\n",
              "      <td>0.1626</td>\n",
              "      <td>1.4410</td>\n",
              "      <td>-0.4535</td>\n",
              "      <td>0.4796</td>\n",
              "      <td>0.5551</td>\n",
              "      <td>-1.4560</td>\n",
              "      <td>-0.2305</td>\n",
              "      <td>-0.7454</td>\n",
              "      <td>0.6339</td>\n",
              "      <td>-0.1980</td>\n",
              "      <td>-0.7012</td>\n",
              "      <td>-0.0882</td>\n",
              "      <td>-0.7792</td>\n",
              "      <td>-1.3130</td>\n",
              "      <td>0.9740</td>\n",
              "      <td>0.6500</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.2869</td>\n",
              "      <td>-0.8081</td>\n",
              "      <td>0.7787</td>\n",
              "      <td>-2.3180</td>\n",
              "      <td>-0.1749</td>\n",
              "      <td>-1.5440</td>\n",
              "      <td>-0.2516</td>\n",
              "      <td>0.0398</td>\n",
              "      <td>-1.0300</td>\n",
              "      <td>-1.2490</td>\n",
              "      <td>-1.4980</td>\n",
              "      <td>0.6580</td>\n",
              "      <td>-1.2280</td>\n",
              "      <td>-0.3264</td>\n",
              "      <td>-0.4176</td>\n",
              "      <td>0.4094</td>\n",
              "      <td>-1.1720</td>\n",
              "      <td>-1.5150</td>\n",
              "      <td>0.7748</td>\n",
              "      <td>0.1379</td>\n",
              "      <td>-0.9742</td>\n",
              "      <td>-0.4860</td>\n",
              "      <td>-1.8320</td>\n",
              "      <td>-0.2079</td>\n",
              "      <td>-1.5640</td>\n",
              "      <td>0.0375</td>\n",
              "      <td>-1.0310</td>\n",
              "      <td>1.0830</td>\n",
              "      <td>-1.5510</td>\n",
              "      <td>-0.5745</td>\n",
              "      <td>-1.4650</td>\n",
              "      <td>-0.3515</td>\n",
              "      <td>-0.3931</td>\n",
              "      <td>-0.5623</td>\n",
              "      <td>-1.0300</td>\n",
              "      <td>-1.3360</td>\n",
              "      <td>-1.3790</td>\n",
              "      <td>-0.4393</td>\n",
              "      <td>-0.0259</td>\n",
              "      <td>0.9765</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>id_0036b0342</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>48</td>\n",
              "      <td>D1</td>\n",
              "      <td>d14919a0e</td>\n",
              "      <td>-0.1428</td>\n",
              "      <td>-0.1957</td>\n",
              "      <td>-0.6397</td>\n",
              "      <td>0.0726</td>\n",
              "      <td>-0.8058</td>\n",
              "      <td>1.0030</td>\n",
              "      <td>0.4961</td>\n",
              "      <td>0.1661</td>\n",
              "      <td>0.1585</td>\n",
              "      <td>-0.1017</td>\n",
              "      <td>-0.6012</td>\n",
              "      <td>0.2375</td>\n",
              "      <td>0.6891</td>\n",
              "      <td>1.0230</td>\n",
              "      <td>0.1307</td>\n",
              "      <td>-0.0348</td>\n",
              "      <td>-0.0599</td>\n",
              "      <td>-0.8773</td>\n",
              "      <td>0.6515</td>\n",
              "      <td>0.1524</td>\n",
              "      <td>0.3350</td>\n",
              "      <td>-0.4348</td>\n",
              "      <td>-0.5091</td>\n",
              "      <td>-0.4875</td>\n",
              "      <td>0.3864</td>\n",
              "      <td>0.6467</td>\n",
              "      <td>-0.1579</td>\n",
              "      <td>-0.6164</td>\n",
              "      <td>0.8317</td>\n",
              "      <td>0.6261</td>\n",
              "      <td>-0.0525</td>\n",
              "      <td>0.4118</td>\n",
              "      <td>0.5612</td>\n",
              "      <td>-0.1622</td>\n",
              "      <td>0.3007</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.4549</td>\n",
              "      <td>0.1426</td>\n",
              "      <td>0.3224</td>\n",
              "      <td>0.5182</td>\n",
              "      <td>-0.2108</td>\n",
              "      <td>-0.4321</td>\n",
              "      <td>0.7119</td>\n",
              "      <td>0.4460</td>\n",
              "      <td>-0.1447</td>\n",
              "      <td>0.3731</td>\n",
              "      <td>0.3752</td>\n",
              "      <td>-0.0814</td>\n",
              "      <td>0.4946</td>\n",
              "      <td>-0.2430</td>\n",
              "      <td>0.4539</td>\n",
              "      <td>-0.7639</td>\n",
              "      <td>-0.1048</td>\n",
              "      <td>1.1200</td>\n",
              "      <td>0.5435</td>\n",
              "      <td>0.3051</td>\n",
              "      <td>-0.0986</td>\n",
              "      <td>0.2992</td>\n",
              "      <td>-0.1557</td>\n",
              "      <td>0.3361</td>\n",
              "      <td>-0.3646</td>\n",
              "      <td>0.7881</td>\n",
              "      <td>-0.4541</td>\n",
              "      <td>0.5163</td>\n",
              "      <td>0.7364</td>\n",
              "      <td>-0.3632</td>\n",
              "      <td>-0.1851</td>\n",
              "      <td>-0.1995</td>\n",
              "      <td>0.3496</td>\n",
              "      <td>0.3608</td>\n",
              "      <td>0.7261</td>\n",
              "      <td>-0.0030</td>\n",
              "      <td>0.2853</td>\n",
              "      <td>0.3129</td>\n",
              "      <td>0.4251</td>\n",
              "      <td>0.4308</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",
              "6   id_001bd861f  com_droga     24   D2  ...  2.4670  0.0357  0.1351 -0.3179\n",
              "11  id_0024bcd70  com_droga     48   D2  ...  0.2731  0.6306  0.8285  0.3605\n",
              "18  id_003603254  com_droga     72   D2  ... -1.3790 -0.4393 -0.0259  0.9765\n",
              "19  id_0036b0342  com_droga     48   D1  ...  0.2853  0.3129  0.4251  0.4308\n",
              "\n",
              "[5 rows x 877 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 26
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 0
        },
        "id": "uvvRqpJJhQfd",
        "outputId": "f512fcf1-3f43-48ea-d311-f9677b3a813f"
      },
      "source": [
        "custom_cmp = lambda x, y: '`g-{}` > `g-{}`'.format(x, y)\n",
        "query = ' and '.join(map(custom_cmp, range(5), range(1, 6)))\n",
        "print('query = {}'.format(query))\n",
        "dados.query(query).head()"
      ],
      "execution_count": 27,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "query = `g-0` > `g-1` and `g-1` > `g-2` and `g-2` > `g-3` and `g-3` > `g-4` and `g-4` > `g-5`\n"
          ],
          "name": "stdout"
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>id</th>\n",
              "      <th>tratamento</th>\n",
              "      <th>tempo</th>\n",
              "      <th>dose</th>\n",
              "      <th>droga</th>\n",
              "      <th>g-0</th>\n",
              "      <th>g-1</th>\n",
              "      <th>g-2</th>\n",
              "      <th>g-3</th>\n",
              "      <th>g-4</th>\n",
              "      <th>g-5</th>\n",
              "      <th>g-6</th>\n",
              "      <th>g-7</th>\n",
              "      <th>g-8</th>\n",
              "      <th>g-9</th>\n",
              "      <th>g-10</th>\n",
              "      <th>g-11</th>\n",
              "      <th>g-12</th>\n",
              "      <th>g-13</th>\n",
              "      <th>g-14</th>\n",
              "      <th>g-15</th>\n",
              "      <th>g-16</th>\n",
              "      <th>g-17</th>\n",
              "      <th>g-18</th>\n",
              "      <th>g-19</th>\n",
              "      <th>g-20</th>\n",
              "      <th>g-21</th>\n",
              "      <th>g-22</th>\n",
              "      <th>g-23</th>\n",
              "      <th>g-24</th>\n",
              "      <th>g-25</th>\n",
              "      <th>g-26</th>\n",
              "      <th>g-27</th>\n",
              "      <th>g-28</th>\n",
              "      <th>g-29</th>\n",
              "      <th>g-30</th>\n",
              "      <th>g-31</th>\n",
              "      <th>g-32</th>\n",
              "      <th>g-33</th>\n",
              "      <th>g-34</th>\n",
              "      <th>...</th>\n",
              "      <th>c-60</th>\n",
              "      <th>c-61</th>\n",
              "      <th>c-62</th>\n",
              "      <th>c-63</th>\n",
              "      <th>c-64</th>\n",
              "      <th>c-65</th>\n",
              "      <th>c-66</th>\n",
              "      <th>c-67</th>\n",
              "      <th>c-68</th>\n",
              "      <th>c-69</th>\n",
              "      <th>c-70</th>\n",
              "      <th>c-71</th>\n",
              "      <th>c-72</th>\n",
              "      <th>c-73</th>\n",
              "      <th>c-74</th>\n",
              "      <th>c-75</th>\n",
              "      <th>c-76</th>\n",
              "      <th>c-77</th>\n",
              "      <th>c-78</th>\n",
              "      <th>c-79</th>\n",
              "      <th>c-80</th>\n",
              "      <th>c-81</th>\n",
              "      <th>c-82</th>\n",
              "      <th>c-83</th>\n",
              "      <th>c-84</th>\n",
              "      <th>c-85</th>\n",
              "      <th>c-86</th>\n",
              "      <th>c-87</th>\n",
              "      <th>c-88</th>\n",
              "      <th>c-89</th>\n",
              "      <th>c-90</th>\n",
              "      <th>c-91</th>\n",
              "      <th>c-92</th>\n",
              "      <th>c-93</th>\n",
              "      <th>c-94</th>\n",
              "      <th>c-95</th>\n",
              "      <th>c-96</th>\n",
              "      <th>c-97</th>\n",
              "      <th>c-98</th>\n",
              "      <th>c-99</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>857</th>\n",
              "      <td>id_08a9df853</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>48</td>\n",
              "      <td>D1</td>\n",
              "      <td>262da47c0</td>\n",
              "      <td>2.1370</td>\n",
              "      <td>0.9874</td>\n",
              "      <td>0.8352</td>\n",
              "      <td>-0.1140</td>\n",
              "      <td>-0.2896</td>\n",
              "      <td>-2.224</td>\n",
              "      <td>-0.1310</td>\n",
              "      <td>0.1331</td>\n",
              "      <td>0.6088</td>\n",
              "      <td>2.4150</td>\n",
              "      <td>0.4595</td>\n",
              "      <td>-0.6894</td>\n",
              "      <td>0.8424</td>\n",
              "      <td>1.4940</td>\n",
              "      <td>1.1990</td>\n",
              "      <td>0.1916</td>\n",
              "      <td>-1.5800</td>\n",
              "      <td>1.8560</td>\n",
              "      <td>0.4438</td>\n",
              "      <td>0.3779</td>\n",
              "      <td>-1.1260</td>\n",
              "      <td>-0.3248</td>\n",
              "      <td>1.1800</td>\n",
              "      <td>-0.1221</td>\n",
              "      <td>-0.6473</td>\n",
              "      <td>0.7097</td>\n",
              "      <td>0.0355</td>\n",
              "      <td>-0.2417</td>\n",
              "      <td>0.2556</td>\n",
              "      <td>-0.0280</td>\n",
              "      <td>0.2260</td>\n",
              "      <td>-0.0837</td>\n",
              "      <td>-4.2930</td>\n",
              "      <td>-0.5655</td>\n",
              "      <td>0.1561</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.2564</td>\n",
              "      <td>-0.5512</td>\n",
              "      <td>-1.0630</td>\n",
              "      <td>-0.2676</td>\n",
              "      <td>0.1783</td>\n",
              "      <td>0.2123</td>\n",
              "      <td>-0.4390</td>\n",
              "      <td>-0.5301</td>\n",
              "      <td>-0.0579</td>\n",
              "      <td>1.2700</td>\n",
              "      <td>0.0205</td>\n",
              "      <td>-0.2345</td>\n",
              "      <td>-0.0305</td>\n",
              "      <td>0.6190</td>\n",
              "      <td>-0.0150</td>\n",
              "      <td>-0.6213</td>\n",
              "      <td>-0.2921</td>\n",
              "      <td>-0.3737</td>\n",
              "      <td>-1.2350</td>\n",
              "      <td>0.3021</td>\n",
              "      <td>-0.7832</td>\n",
              "      <td>-0.1642</td>\n",
              "      <td>-0.3439</td>\n",
              "      <td>-0.2823</td>\n",
              "      <td>-0.4583</td>\n",
              "      <td>-0.5461</td>\n",
              "      <td>0.0825</td>\n",
              "      <td>-0.1178</td>\n",
              "      <td>0.1792</td>\n",
              "      <td>-0.4383</td>\n",
              "      <td>-0.6636</td>\n",
              "      <td>0.0159</td>\n",
              "      <td>-0.9761</td>\n",
              "      <td>-0.2804</td>\n",
              "      <td>-0.9941</td>\n",
              "      <td>-1.3320</td>\n",
              "      <td>0.2735</td>\n",
              "      <td>-0.0270</td>\n",
              "      <td>-0.9156</td>\n",
              "      <td>-0.2829</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1518</th>\n",
              "      <td>id_103317914</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>00321ea80</td>\n",
              "      <td>-0.1156</td>\n",
              "      <td>-0.4923</td>\n",
              "      <td>-0.5274</td>\n",
              "      <td>-0.6043</td>\n",
              "      <td>-1.1520</td>\n",
              "      <td>-2.859</td>\n",
              "      <td>0.0651</td>\n",
              "      <td>0.8228</td>\n",
              "      <td>0.7025</td>\n",
              "      <td>-0.1881</td>\n",
              "      <td>1.7700</td>\n",
              "      <td>-0.8884</td>\n",
              "      <td>1.6020</td>\n",
              "      <td>-0.4110</td>\n",
              "      <td>-0.7002</td>\n",
              "      <td>-0.0997</td>\n",
              "      <td>-1.5130</td>\n",
              "      <td>-0.2553</td>\n",
              "      <td>0.1066</td>\n",
              "      <td>0.3360</td>\n",
              "      <td>-0.5497</td>\n",
              "      <td>-0.0067</td>\n",
              "      <td>-0.7577</td>\n",
              "      <td>0.2826</td>\n",
              "      <td>-0.1390</td>\n",
              "      <td>0.1120</td>\n",
              "      <td>-0.4424</td>\n",
              "      <td>0.4938</td>\n",
              "      <td>-0.1619</td>\n",
              "      <td>-0.6270</td>\n",
              "      <td>-0.6497</td>\n",
              "      <td>-0.5204</td>\n",
              "      <td>0.0712</td>\n",
              "      <td>5.0000</td>\n",
              "      <td>0.0266</td>\n",
              "      <td>...</td>\n",
              "      <td>1.3600</td>\n",
              "      <td>-0.3677</td>\n",
              "      <td>0.5125</td>\n",
              "      <td>0.6440</td>\n",
              "      <td>0.7195</td>\n",
              "      <td>0.8331</td>\n",
              "      <td>0.7629</td>\n",
              "      <td>0.1368</td>\n",
              "      <td>0.5904</td>\n",
              "      <td>-0.0465</td>\n",
              "      <td>0.4354</td>\n",
              "      <td>1.3660</td>\n",
              "      <td>0.4243</td>\n",
              "      <td>1.2040</td>\n",
              "      <td>-0.2528</td>\n",
              "      <td>-1.2850</td>\n",
              "      <td>0.0771</td>\n",
              "      <td>0.1484</td>\n",
              "      <td>-0.2250</td>\n",
              "      <td>1.1580</td>\n",
              "      <td>-0.3166</td>\n",
              "      <td>-0.0643</td>\n",
              "      <td>0.9463</td>\n",
              "      <td>-0.1822</td>\n",
              "      <td>1.0280</td>\n",
              "      <td>0.0852</td>\n",
              "      <td>1.2700</td>\n",
              "      <td>0.1992</td>\n",
              "      <td>1.1080</td>\n",
              "      <td>0.8193</td>\n",
              "      <td>0.8328</td>\n",
              "      <td>0.5680</td>\n",
              "      <td>0.1268</td>\n",
              "      <td>1.0960</td>\n",
              "      <td>1.4270</td>\n",
              "      <td>0.4209</td>\n",
              "      <td>0.3227</td>\n",
              "      <td>0.8924</td>\n",
              "      <td>0.2244</td>\n",
              "      <td>0.5785</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1599</th>\n",
              "      <td>id_1106d898d</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>48</td>\n",
              "      <td>D1</td>\n",
              "      <td>bce9dc5c8</td>\n",
              "      <td>1.0790</td>\n",
              "      <td>0.5159</td>\n",
              "      <td>-0.0969</td>\n",
              "      <td>-0.6255</td>\n",
              "      <td>-0.7203</td>\n",
              "      <td>-2.145</td>\n",
              "      <td>-3.1550</td>\n",
              "      <td>-1.6640</td>\n",
              "      <td>2.9620</td>\n",
              "      <td>-2.2220</td>\n",
              "      <td>-2.6290</td>\n",
              "      <td>-2.1320</td>\n",
              "      <td>-1.5990</td>\n",
              "      <td>1.4800</td>\n",
              "      <td>-0.6379</td>\n",
              "      <td>-1.3980</td>\n",
              "      <td>-2.5180</td>\n",
              "      <td>-1.6120</td>\n",
              "      <td>-0.2091</td>\n",
              "      <td>0.5001</td>\n",
              "      <td>-1.2630</td>\n",
              "      <td>-1.4460</td>\n",
              "      <td>-0.1937</td>\n",
              "      <td>3.4330</td>\n",
              "      <td>-1.0920</td>\n",
              "      <td>1.0150</td>\n",
              "      <td>-2.2860</td>\n",
              "      <td>-1.1920</td>\n",
              "      <td>-0.2749</td>\n",
              "      <td>-2.0340</td>\n",
              "      <td>-3.7050</td>\n",
              "      <td>1.7590</td>\n",
              "      <td>-5.4870</td>\n",
              "      <td>7.5930</td>\n",
              "      <td>-2.6340</td>\n",
              "      <td>...</td>\n",
              "      <td>-9.2030</td>\n",
              "      <td>-4.0260</td>\n",
              "      <td>-4.4830</td>\n",
              "      <td>-8.2670</td>\n",
              "      <td>-4.2940</td>\n",
              "      <td>-9.6820</td>\n",
              "      <td>-3.5890</td>\n",
              "      <td>-3.1810</td>\n",
              "      <td>-2.7530</td>\n",
              "      <td>-1.2570</td>\n",
              "      <td>-0.7796</td>\n",
              "      <td>-1.2590</td>\n",
              "      <td>-3.6860</td>\n",
              "      <td>-4.9220</td>\n",
              "      <td>-1.5480</td>\n",
              "      <td>-9.3220</td>\n",
              "      <td>-4.2800</td>\n",
              "      <td>-3.0480</td>\n",
              "      <td>-0.0579</td>\n",
              "      <td>-1.3200</td>\n",
              "      <td>-7.3100</td>\n",
              "      <td>-4.8490</td>\n",
              "      <td>-2.2280</td>\n",
              "      <td>-1.9440</td>\n",
              "      <td>-7.5610</td>\n",
              "      <td>-1.8850</td>\n",
              "      <td>-6.1280</td>\n",
              "      <td>0.2223</td>\n",
              "      <td>-5.2530</td>\n",
              "      <td>-1.5040</td>\n",
              "      <td>-3.9660</td>\n",
              "      <td>-6.8140</td>\n",
              "      <td>-5.2500</td>\n",
              "      <td>-7.4510</td>\n",
              "      <td>-6.8440</td>\n",
              "      <td>-2.0850</td>\n",
              "      <td>-4.2970</td>\n",
              "      <td>-1.9390</td>\n",
              "      <td>-5.8430</td>\n",
              "      <td>-3.8400</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1857</th>\n",
              "      <td>id_14188fcfe</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>1f4fc34c5</td>\n",
              "      <td>1.9840</td>\n",
              "      <td>0.7341</td>\n",
              "      <td>0.4142</td>\n",
              "      <td>-1.0520</td>\n",
              "      <td>-1.6340</td>\n",
              "      <td>-2.969</td>\n",
              "      <td>3.5170</td>\n",
              "      <td>1.8030</td>\n",
              "      <td>-1.4410</td>\n",
              "      <td>-3.2300</td>\n",
              "      <td>3.3380</td>\n",
              "      <td>1.3490</td>\n",
              "      <td>-2.0680</td>\n",
              "      <td>-0.8469</td>\n",
              "      <td>2.3660</td>\n",
              "      <td>1.6100</td>\n",
              "      <td>0.3638</td>\n",
              "      <td>-5.8180</td>\n",
              "      <td>0.1235</td>\n",
              "      <td>0.7090</td>\n",
              "      <td>4.1550</td>\n",
              "      <td>0.8915</td>\n",
              "      <td>-1.4510</td>\n",
              "      <td>-2.2070</td>\n",
              "      <td>-2.5580</td>\n",
              "      <td>1.6340</td>\n",
              "      <td>1.9340</td>\n",
              "      <td>-2.1100</td>\n",
              "      <td>-0.6105</td>\n",
              "      <td>1.8760</td>\n",
              "      <td>2.5160</td>\n",
              "      <td>0.0654</td>\n",
              "      <td>0.9362</td>\n",
              "      <td>3.1050</td>\n",
              "      <td>1.4890</td>\n",
              "      <td>...</td>\n",
              "      <td>0.4301</td>\n",
              "      <td>0.1256</td>\n",
              "      <td>-0.9150</td>\n",
              "      <td>-0.1875</td>\n",
              "      <td>-0.9384</td>\n",
              "      <td>0.1298</td>\n",
              "      <td>-0.9929</td>\n",
              "      <td>-1.7200</td>\n",
              "      <td>0.4413</td>\n",
              "      <td>0.8085</td>\n",
              "      <td>0.0535</td>\n",
              "      <td>-0.7179</td>\n",
              "      <td>0.2045</td>\n",
              "      <td>-0.7776</td>\n",
              "      <td>-0.1325</td>\n",
              "      <td>-0.0943</td>\n",
              "      <td>-0.0396</td>\n",
              "      <td>0.3713</td>\n",
              "      <td>0.2776</td>\n",
              "      <td>-0.4445</td>\n",
              "      <td>-0.5914</td>\n",
              "      <td>-0.3147</td>\n",
              "      <td>0.3708</td>\n",
              "      <td>-0.0545</td>\n",
              "      <td>-0.3082</td>\n",
              "      <td>-0.2107</td>\n",
              "      <td>0.1655</td>\n",
              "      <td>-1.5810</td>\n",
              "      <td>0.3946</td>\n",
              "      <td>-1.1540</td>\n",
              "      <td>-1.5410</td>\n",
              "      <td>-0.6355</td>\n",
              "      <td>-0.6270</td>\n",
              "      <td>-1.7590</td>\n",
              "      <td>0.3223</td>\n",
              "      <td>-0.6287</td>\n",
              "      <td>-0.3431</td>\n",
              "      <td>-0.2995</td>\n",
              "      <td>-0.0477</td>\n",
              "      <td>0.3979</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2309</th>\n",
              "      <td>id_18b623be6</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>4a75f1d42</td>\n",
              "      <td>1.1400</td>\n",
              "      <td>1.1360</td>\n",
              "      <td>1.0680</td>\n",
              "      <td>0.5418</td>\n",
              "      <td>-0.2376</td>\n",
              "      <td>-0.404</td>\n",
              "      <td>0.2368</td>\n",
              "      <td>0.2821</td>\n",
              "      <td>1.4240</td>\n",
              "      <td>2.6410</td>\n",
              "      <td>0.7564</td>\n",
              "      <td>-0.0607</td>\n",
              "      <td>1.7840</td>\n",
              "      <td>-0.8255</td>\n",
              "      <td>0.9151</td>\n",
              "      <td>-1.0850</td>\n",
              "      <td>-0.2531</td>\n",
              "      <td>0.7998</td>\n",
              "      <td>-0.8117</td>\n",
              "      <td>0.2991</td>\n",
              "      <td>-0.7564</td>\n",
              "      <td>1.0140</td>\n",
              "      <td>0.3209</td>\n",
              "      <td>1.7590</td>\n",
              "      <td>-0.4906</td>\n",
              "      <td>-0.4622</td>\n",
              "      <td>0.4539</td>\n",
              "      <td>0.8064</td>\n",
              "      <td>0.1438</td>\n",
              "      <td>0.2077</td>\n",
              "      <td>0.0641</td>\n",
              "      <td>-0.0442</td>\n",
              "      <td>-0.6896</td>\n",
              "      <td>-0.1088</td>\n",
              "      <td>-0.5470</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.1809</td>\n",
              "      <td>0.0095</td>\n",
              "      <td>-0.0324</td>\n",
              "      <td>0.3509</td>\n",
              "      <td>0.1672</td>\n",
              "      <td>-0.7792</td>\n",
              "      <td>-0.0082</td>\n",
              "      <td>0.9969</td>\n",
              "      <td>-0.3537</td>\n",
              "      <td>-0.4692</td>\n",
              "      <td>-0.4420</td>\n",
              "      <td>-0.3025</td>\n",
              "      <td>-0.8391</td>\n",
              "      <td>-0.1345</td>\n",
              "      <td>-0.6748</td>\n",
              "      <td>-1.2950</td>\n",
              "      <td>0.1304</td>\n",
              "      <td>0.3443</td>\n",
              "      <td>-0.7444</td>\n",
              "      <td>-0.3683</td>\n",
              "      <td>-0.4917</td>\n",
              "      <td>-0.1364</td>\n",
              "      <td>-0.4161</td>\n",
              "      <td>-0.1041</td>\n",
              "      <td>0.2153</td>\n",
              "      <td>0.5247</td>\n",
              "      <td>0.8181</td>\n",
              "      <td>-0.2965</td>\n",
              "      <td>-0.5027</td>\n",
              "      <td>-0.5854</td>\n",
              "      <td>0.1914</td>\n",
              "      <td>-0.7458</td>\n",
              "      <td>-0.1296</td>\n",
              "      <td>1.1160</td>\n",
              "      <td>0.4174</td>\n",
              "      <td>0.8688</td>\n",
              "      <td>-0.1563</td>\n",
              "      <td>0.6033</td>\n",
              "      <td>0.0684</td>\n",
              "      <td>-0.8127</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",
              "857   id_08a9df853  com_droga     48   D1  ...  0.2735 -0.0270 -0.9156 -0.2829\n",
              "1518  id_103317914  com_droga     24   D1  ...  0.3227  0.8924  0.2244  0.5785\n",
              "1599  id_1106d898d  com_droga     48   D1  ... -4.2970 -1.9390 -5.8430 -3.8400\n",
              "1857  id_14188fcfe  com_droga     24   D1  ... -0.3431 -0.2995 -0.0477  0.3979\n",
              "2309  id_18b623be6  com_droga     24   D1  ... -0.1563  0.6033  0.0684 -0.8127\n",
              "\n",
              "[5 rows x 877 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 27
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "T7Lap9qveUYY"
      },
      "source": [
        "### Desafio 6: Renomear colunas tirando o hífen."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 256
        },
        "id": "rQi1MExXh7f9",
        "outputId": "ba09efaf-25b8-40a8-c4ab-352436bf62da"
      },
      "source": [
        "dados.columns = dados.columns.str.replace('-', '')\n",
        "dados.head()"
      ],
      "execution_count": 28,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>id</th>\n",
              "      <th>tratamento</th>\n",
              "      <th>tempo</th>\n",
              "      <th>dose</th>\n",
              "      <th>droga</th>\n",
              "      <th>g0</th>\n",
              "      <th>g1</th>\n",
              "      <th>g2</th>\n",
              "      <th>g3</th>\n",
              "      <th>g4</th>\n",
              "      <th>g5</th>\n",
              "      <th>g6</th>\n",
              "      <th>g7</th>\n",
              "      <th>g8</th>\n",
              "      <th>g9</th>\n",
              "      <th>g10</th>\n",
              "      <th>g11</th>\n",
              "      <th>g12</th>\n",
              "      <th>g13</th>\n",
              "      <th>g14</th>\n",
              "      <th>g15</th>\n",
              "      <th>g16</th>\n",
              "      <th>g17</th>\n",
              "      <th>g18</th>\n",
              "      <th>g19</th>\n",
              "      <th>g20</th>\n",
              "      <th>g21</th>\n",
              "      <th>g22</th>\n",
              "      <th>g23</th>\n",
              "      <th>g24</th>\n",
              "      <th>g25</th>\n",
              "      <th>g26</th>\n",
              "      <th>g27</th>\n",
              "      <th>g28</th>\n",
              "      <th>g29</th>\n",
              "      <th>g30</th>\n",
              "      <th>g31</th>\n",
              "      <th>g32</th>\n",
              "      <th>g33</th>\n",
              "      <th>g34</th>\n",
              "      <th>...</th>\n",
              "      <th>c60</th>\n",
              "      <th>c61</th>\n",
              "      <th>c62</th>\n",
              "      <th>c63</th>\n",
              "      <th>c64</th>\n",
              "      <th>c65</th>\n",
              "      <th>c66</th>\n",
              "      <th>c67</th>\n",
              "      <th>c68</th>\n",
              "      <th>c69</th>\n",
              "      <th>c70</th>\n",
              "      <th>c71</th>\n",
              "      <th>c72</th>\n",
              "      <th>c73</th>\n",
              "      <th>c74</th>\n",
              "      <th>c75</th>\n",
              "      <th>c76</th>\n",
              "      <th>c77</th>\n",
              "      <th>c78</th>\n",
              "      <th>c79</th>\n",
              "      <th>c80</th>\n",
              "      <th>c81</th>\n",
              "      <th>c82</th>\n",
              "      <th>c83</th>\n",
              "      <th>c84</th>\n",
              "      <th>c85</th>\n",
              "      <th>c86</th>\n",
              "      <th>c87</th>\n",
              "      <th>c88</th>\n",
              "      <th>c89</th>\n",
              "      <th>c90</th>\n",
              "      <th>c91</th>\n",
              "      <th>c92</th>\n",
              "      <th>c93</th>\n",
              "      <th>c94</th>\n",
              "      <th>c95</th>\n",
              "      <th>c96</th>\n",
              "      <th>c97</th>\n",
              "      <th>c98</th>\n",
              "      <th>c99</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>id_000644bb2</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>24</td>\n",
              "      <td>D1</td>\n",
              "      <td>b68db1d53</td>\n",
              "      <td>1.0620</td>\n",
              "      <td>0.5577</td>\n",
              "      <td>-0.2479</td>\n",
              "      <td>-0.6208</td>\n",
              "      <td>-0.1944</td>\n",
              "      <td>-1.0120</td>\n",
              "      <td>-1.0220</td>\n",
              "      <td>-0.0326</td>\n",
              "      <td>0.5548</td>\n",
              "      <td>-0.0921</td>\n",
              "      <td>1.1830</td>\n",
              "      <td>0.1530</td>\n",
              "      <td>0.5574</td>\n",
              "      <td>-0.4015</td>\n",
              "      <td>0.1789</td>\n",
              "      <td>-0.6528</td>\n",
              "      <td>-0.7969</td>\n",
              "      <td>0.6342</td>\n",
              "      <td>0.1778</td>\n",
              "      <td>-0.3694</td>\n",
              "      <td>-0.5688</td>\n",
              "      <td>-1.1360</td>\n",
              "      <td>-1.1880</td>\n",
              "      <td>0.6940</td>\n",
              "      <td>0.4393</td>\n",
              "      <td>0.2664</td>\n",
              "      <td>0.1907</td>\n",
              "      <td>0.1628</td>\n",
              "      <td>-0.2853</td>\n",
              "      <td>0.5819</td>\n",
              "      <td>0.2934</td>\n",
              "      <td>-0.5584</td>\n",
              "      <td>-0.0916</td>\n",
              "      <td>-0.3010</td>\n",
              "      <td>-0.1537</td>\n",
              "      <td>...</td>\n",
              "      <td>0.4805</td>\n",
              "      <td>0.4965</td>\n",
              "      <td>0.3680</td>\n",
              "      <td>0.8427</td>\n",
              "      <td>0.1042</td>\n",
              "      <td>0.1403</td>\n",
              "      <td>0.1758</td>\n",
              "      <td>1.2570</td>\n",
              "      <td>-0.5979</td>\n",
              "      <td>1.2250</td>\n",
              "      <td>-0.0553</td>\n",
              "      <td>0.7351</td>\n",
              "      <td>0.5810</td>\n",
              "      <td>0.9590</td>\n",
              "      <td>0.2427</td>\n",
              "      <td>0.0495</td>\n",
              "      <td>0.4141</td>\n",
              "      <td>0.8432</td>\n",
              "      <td>0.6162</td>\n",
              "      <td>-0.7318</td>\n",
              "      <td>1.2120</td>\n",
              "      <td>0.6362</td>\n",
              "      <td>-0.4427</td>\n",
              "      <td>0.1288</td>\n",
              "      <td>1.4840</td>\n",
              "      <td>0.1799</td>\n",
              "      <td>0.5367</td>\n",
              "      <td>-0.1111</td>\n",
              "      <td>-1.0120</td>\n",
              "      <td>0.6685</td>\n",
              "      <td>0.2862</td>\n",
              "      <td>0.2584</td>\n",
              "      <td>0.8076</td>\n",
              "      <td>0.5523</td>\n",
              "      <td>-0.1912</td>\n",
              "      <td>0.6584</td>\n",
              "      <td>-0.3981</td>\n",
              "      <td>0.2139</td>\n",
              "      <td>0.3801</td>\n",
              "      <td>0.4176</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>id_000779bfc</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>72</td>\n",
              "      <td>D1</td>\n",
              "      <td>df89a8e5a</td>\n",
              "      <td>0.0743</td>\n",
              "      <td>0.4087</td>\n",
              "      <td>0.2991</td>\n",
              "      <td>0.0604</td>\n",
              "      <td>1.0190</td>\n",
              "      <td>0.5207</td>\n",
              "      <td>0.2341</td>\n",
              "      <td>0.3372</td>\n",
              "      <td>-0.4047</td>\n",
              "      <td>0.8507</td>\n",
              "      <td>-1.1520</td>\n",
              "      <td>-0.4201</td>\n",
              "      <td>-0.0958</td>\n",
              "      <td>0.4590</td>\n",
              "      <td>0.0803</td>\n",
              "      <td>0.2250</td>\n",
              "      <td>0.5293</td>\n",
              "      <td>0.2839</td>\n",
              "      <td>-0.3494</td>\n",
              "      <td>0.2883</td>\n",
              "      <td>0.9449</td>\n",
              "      <td>-0.1646</td>\n",
              "      <td>-0.2657</td>\n",
              "      <td>-0.3372</td>\n",
              "      <td>0.3135</td>\n",
              "      <td>-0.4316</td>\n",
              "      <td>0.4773</td>\n",
              "      <td>0.2075</td>\n",
              "      <td>-0.4216</td>\n",
              "      <td>-0.1161</td>\n",
              "      <td>-0.0499</td>\n",
              "      <td>-0.2627</td>\n",
              "      <td>0.9959</td>\n",
              "      <td>-0.2483</td>\n",
              "      <td>0.2655</td>\n",
              "      <td>...</td>\n",
              "      <td>0.4083</td>\n",
              "      <td>0.0319</td>\n",
              "      <td>0.3905</td>\n",
              "      <td>0.7099</td>\n",
              "      <td>0.2912</td>\n",
              "      <td>0.4151</td>\n",
              "      <td>-0.2840</td>\n",
              "      <td>-0.3104</td>\n",
              "      <td>-0.6373</td>\n",
              "      <td>0.2887</td>\n",
              "      <td>-0.0765</td>\n",
              "      <td>0.2539</td>\n",
              "      <td>0.4443</td>\n",
              "      <td>0.5932</td>\n",
              "      <td>0.2031</td>\n",
              "      <td>0.7639</td>\n",
              "      <td>0.5499</td>\n",
              "      <td>-0.3322</td>\n",
              "      <td>-0.0977</td>\n",
              "      <td>0.4329</td>\n",
              "      <td>-0.2782</td>\n",
              "      <td>0.7827</td>\n",
              "      <td>0.5934</td>\n",
              "      <td>0.3402</td>\n",
              "      <td>0.1499</td>\n",
              "      <td>0.4420</td>\n",
              "      <td>0.9366</td>\n",
              "      <td>0.8193</td>\n",
              "      <td>-0.4236</td>\n",
              "      <td>0.3192</td>\n",
              "      <td>-0.4265</td>\n",
              "      <td>0.7543</td>\n",
              "      <td>0.4708</td>\n",
              "      <td>0.0230</td>\n",
              "      <td>0.2957</td>\n",
              "      <td>0.4899</td>\n",
              "      <td>0.1522</td>\n",
              "      <td>0.1241</td>\n",
              "      <td>0.6077</td>\n",
              "      <td>0.7371</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>id_000a6266a</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>48</td>\n",
              "      <td>D1</td>\n",
              "      <td>18bb41b2c</td>\n",
              "      <td>0.6280</td>\n",
              "      <td>0.5817</td>\n",
              "      <td>1.5540</td>\n",
              "      <td>-0.0764</td>\n",
              "      <td>-0.0323</td>\n",
              "      <td>1.2390</td>\n",
              "      <td>0.1715</td>\n",
              "      <td>0.2155</td>\n",
              "      <td>0.0065</td>\n",
              "      <td>1.2300</td>\n",
              "      <td>-0.4797</td>\n",
              "      <td>-0.5631</td>\n",
              "      <td>-0.0366</td>\n",
              "      <td>-1.8300</td>\n",
              "      <td>0.6057</td>\n",
              "      <td>-0.3278</td>\n",
              "      <td>0.6042</td>\n",
              "      <td>-0.3075</td>\n",
              "      <td>-0.1147</td>\n",
              "      <td>-0.0570</td>\n",
              "      <td>-0.0799</td>\n",
              "      <td>-0.8181</td>\n",
              "      <td>-1.5320</td>\n",
              "      <td>0.2307</td>\n",
              "      <td>0.4901</td>\n",
              "      <td>0.4780</td>\n",
              "      <td>-1.3970</td>\n",
              "      <td>4.6240</td>\n",
              "      <td>-0.0437</td>\n",
              "      <td>1.2870</td>\n",
              "      <td>-1.8530</td>\n",
              "      <td>0.6069</td>\n",
              "      <td>0.4290</td>\n",
              "      <td>0.1783</td>\n",
              "      <td>0.0018</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.5477</td>\n",
              "      <td>-0.7576</td>\n",
              "      <td>-0.0444</td>\n",
              "      <td>0.1894</td>\n",
              "      <td>-0.0014</td>\n",
              "      <td>-2.3640</td>\n",
              "      <td>-0.4682</td>\n",
              "      <td>0.1210</td>\n",
              "      <td>-0.5177</td>\n",
              "      <td>-0.0604</td>\n",
              "      <td>0.1682</td>\n",
              "      <td>-0.4436</td>\n",
              "      <td>0.4963</td>\n",
              "      <td>0.1363</td>\n",
              "      <td>0.3335</td>\n",
              "      <td>0.9760</td>\n",
              "      <td>-0.0427</td>\n",
              "      <td>-0.1235</td>\n",
              "      <td>0.0959</td>\n",
              "      <td>0.0690</td>\n",
              "      <td>-0.9416</td>\n",
              "      <td>-0.7548</td>\n",
              "      <td>-0.1109</td>\n",
              "      <td>-0.6272</td>\n",
              "      <td>0.3019</td>\n",
              "      <td>0.1172</td>\n",
              "      <td>0.1093</td>\n",
              "      <td>-0.3113</td>\n",
              "      <td>0.3019</td>\n",
              "      <td>-0.0873</td>\n",
              "      <td>-0.7250</td>\n",
              "      <td>-0.6297</td>\n",
              "      <td>0.6103</td>\n",
              "      <td>0.0223</td>\n",
              "      <td>-1.3240</td>\n",
              "      <td>-0.3174</td>\n",
              "      <td>-0.6417</td>\n",
              "      <td>-0.2187</td>\n",
              "      <td>-1.4080</td>\n",
              "      <td>0.6931</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>id_0015fd391</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>48</td>\n",
              "      <td>D1</td>\n",
              "      <td>8c7f86626</td>\n",
              "      <td>-0.5138</td>\n",
              "      <td>-0.2491</td>\n",
              "      <td>-0.2656</td>\n",
              "      <td>0.5288</td>\n",
              "      <td>4.0620</td>\n",
              "      <td>-0.8095</td>\n",
              "      <td>-1.9590</td>\n",
              "      <td>0.1792</td>\n",
              "      <td>-0.1321</td>\n",
              "      <td>-1.0600</td>\n",
              "      <td>-0.8269</td>\n",
              "      <td>-0.3584</td>\n",
              "      <td>-0.8511</td>\n",
              "      <td>-0.5844</td>\n",
              "      <td>-2.5690</td>\n",
              "      <td>0.8183</td>\n",
              "      <td>-0.0532</td>\n",
              "      <td>-0.8554</td>\n",
              "      <td>0.1160</td>\n",
              "      <td>-2.3520</td>\n",
              "      <td>2.1200</td>\n",
              "      <td>-1.1580</td>\n",
              "      <td>-0.7191</td>\n",
              "      <td>-0.8004</td>\n",
              "      <td>-1.4670</td>\n",
              "      <td>-0.0107</td>\n",
              "      <td>-0.8995</td>\n",
              "      <td>0.2406</td>\n",
              "      <td>-0.2479</td>\n",
              "      <td>-1.0890</td>\n",
              "      <td>-0.7575</td>\n",
              "      <td>0.0881</td>\n",
              "      <td>-2.7370</td>\n",
              "      <td>0.8745</td>\n",
              "      <td>0.5787</td>\n",
              "      <td>...</td>\n",
              "      <td>-2.1220</td>\n",
              "      <td>-0.3752</td>\n",
              "      <td>-2.3820</td>\n",
              "      <td>-3.7350</td>\n",
              "      <td>-2.9740</td>\n",
              "      <td>-1.4930</td>\n",
              "      <td>-1.6600</td>\n",
              "      <td>-3.1660</td>\n",
              "      <td>0.2816</td>\n",
              "      <td>-0.2990</td>\n",
              "      <td>-1.1870</td>\n",
              "      <td>-0.5044</td>\n",
              "      <td>-1.7750</td>\n",
              "      <td>-1.6120</td>\n",
              "      <td>-0.9215</td>\n",
              "      <td>-1.0810</td>\n",
              "      <td>-3.0520</td>\n",
              "      <td>-3.4470</td>\n",
              "      <td>-2.7740</td>\n",
              "      <td>-1.8460</td>\n",
              "      <td>-0.5568</td>\n",
              "      <td>-3.3960</td>\n",
              "      <td>-2.9510</td>\n",
              "      <td>-1.1550</td>\n",
              "      <td>-3.2620</td>\n",
              "      <td>-1.5390</td>\n",
              "      <td>-2.4600</td>\n",
              "      <td>-0.9417</td>\n",
              "      <td>-1.5550</td>\n",
              "      <td>0.2431</td>\n",
              "      <td>-2.0990</td>\n",
              "      <td>-0.6441</td>\n",
              "      <td>-5.6300</td>\n",
              "      <td>-1.3780</td>\n",
              "      <td>-0.8632</td>\n",
              "      <td>-1.2880</td>\n",
              "      <td>-1.6210</td>\n",
              "      <td>-0.8784</td>\n",
              "      <td>-0.3876</td>\n",
              "      <td>-0.8154</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>id_001626bd3</td>\n",
              "      <td>com_droga</td>\n",
              "      <td>72</td>\n",
              "      <td>D2</td>\n",
              "      <td>7cbed3131</td>\n",
              "      <td>-0.3254</td>\n",
              "      <td>-0.4009</td>\n",
              "      <td>0.9700</td>\n",
              "      <td>0.6919</td>\n",
              "      <td>1.4180</td>\n",
              "      <td>-0.8244</td>\n",
              "      <td>-0.2800</td>\n",
              "      <td>-0.1498</td>\n",
              "      <td>-0.8789</td>\n",
              "      <td>0.8630</td>\n",
              "      <td>-0.2219</td>\n",
              "      <td>-0.5121</td>\n",
              "      <td>-0.9577</td>\n",
              "      <td>1.1750</td>\n",
              "      <td>0.2042</td>\n",
              "      <td>0.1970</td>\n",
              "      <td>0.1244</td>\n",
              "      <td>-1.7090</td>\n",
              "      <td>-0.3543</td>\n",
              "      <td>-0.5160</td>\n",
              "      <td>-0.3330</td>\n",
              "      <td>-0.2685</td>\n",
              "      <td>0.7649</td>\n",
              "      <td>0.2057</td>\n",
              "      <td>1.3720</td>\n",
              "      <td>0.6835</td>\n",
              "      <td>0.8056</td>\n",
              "      <td>-0.3754</td>\n",
              "      <td>-1.2090</td>\n",
              "      <td>0.2965</td>\n",
              "      <td>-0.0712</td>\n",
              "      <td>0.6389</td>\n",
              "      <td>0.6674</td>\n",
              "      <td>-0.0783</td>\n",
              "      <td>1.1740</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.2274</td>\n",
              "      <td>0.3215</td>\n",
              "      <td>0.1535</td>\n",
              "      <td>-0.4640</td>\n",
              "      <td>-0.5943</td>\n",
              "      <td>0.3973</td>\n",
              "      <td>0.1500</td>\n",
              "      <td>0.5178</td>\n",
              "      <td>0.5159</td>\n",
              "      <td>0.6091</td>\n",
              "      <td>0.1813</td>\n",
              "      <td>-0.4249</td>\n",
              "      <td>0.7832</td>\n",
              "      <td>0.6529</td>\n",
              "      <td>0.5648</td>\n",
              "      <td>0.4817</td>\n",
              "      <td>0.0587</td>\n",
              "      <td>0.5303</td>\n",
              "      <td>0.6376</td>\n",
              "      <td>-0.3966</td>\n",
              "      <td>-1.4950</td>\n",
              "      <td>-0.9625</td>\n",
              "      <td>-0.0541</td>\n",
              "      <td>0.6273</td>\n",
              "      <td>0.4563</td>\n",
              "      <td>0.0698</td>\n",
              "      <td>0.8134</td>\n",
              "      <td>0.1924</td>\n",
              "      <td>0.6054</td>\n",
              "      <td>-0.1824</td>\n",
              "      <td>0.0042</td>\n",
              "      <td>0.0048</td>\n",
              "      <td>0.6670</td>\n",
              "      <td>1.0690</td>\n",
              "      <td>0.5523</td>\n",
              "      <td>-0.3031</td>\n",
              "      <td>0.1094</td>\n",
              "      <td>0.2885</td>\n",
              "      <td>-0.3786</td>\n",
              "      <td>0.7125</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 877 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "             id tratamento  tempo dose  ...     c96     c97     c98     c99\n",
              "0  id_000644bb2  com_droga     24   D1  ... -0.3981  0.2139  0.3801  0.4176\n",
              "1  id_000779bfc  com_droga     72   D1  ...  0.1522  0.1241  0.6077  0.7371\n",
              "2  id_000a6266a  com_droga     48   D1  ... -0.6417 -0.2187 -1.4080  0.6931\n",
              "3  id_0015fd391  com_droga     48   D1  ... -1.6210 -0.8784 -0.3876 -0.8154\n",
              "4  id_001626bd3  com_droga     72   D2  ...  0.1094  0.2885 -0.3786  0.7125\n",
              "\n",
              "[5 rows x 877 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 28
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "-5o-r_kBeafx"
      },
      "source": [
        "### Desafio 7: Customizar o gráfico (titulo, label, etc..).\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 175
        },
        "id": "R_rbgVNfnIIp",
        "outputId": "e10e8051-d0ff-4f23-d208-37c408caa3c5"
      },
      "source": [
        "dados_plot = dados.groupby(['dose', 'tempo'], as_index=False)['tratamento'].count() \n",
        "dados_plot.head()"
      ],
      "execution_count": 119,
      "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>dose</th>\n",
              "      <th>D1</th>\n",
              "      <th>D2</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>tempo</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>3886</td>\n",
              "      <td>3886</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>4354</td>\n",
              "      <td>3896</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>72</th>\n",
              "      <td>3907</td>\n",
              "      <td>3885</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "dose     D1    D2\n",
              "tempo            \n",
              "24     3886  3886\n",
              "48     4354  3896\n",
              "72     3907  3885"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 119
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "uYpEvz49xUez"
      },
      "source": [
        "dados_plot_pivot = dados_plot.pivot(index='tempo', columns='dose', values='tratamento')\n",
        "dados_plot_pivot.head()"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 422
        },
        "id": "8baKqe4YeThJ",
        "outputId": "d11d1bb2-657c-475c-f1da-c7b4762f7658"
      },
      "source": [
        "import matplotlib.pyplot as plt\n",
        "\n",
        "dados_plot_pivot.plot.bar(\n",
        "    figsize=(10, 6)\n",
        ")\n",
        "plt.title('Experimentos')\n",
        "plt.xlabel('Tempo')\n",
        "plt.ylabel('Quantidade')\n",
        "plt.xticks(rotation=0, horizontalalignment=\"center\")\n",
        "plt.legend(ncol=2, title='Doses')\n"
      ],
      "execution_count": 120,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.legend.Legend at 0x7f9f2a71b5d0>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 120
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAmoAAAGDCAYAAACbcTyoAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3de7QedX3v8fenSSApKCAkCAQNKKJEJEhEEG0RlqAgxVtbiiBQLCIXL7QVpZwjoJxiTxVPxcqhFUFgCSheUGkFAe2RVmuC4SYCaQRJCiRyC2q4Jd/zxzPB3TSXnbCfPL+dvF9r7fXM/OY383xH9oqf/Zv5zaSqkCRJUnt+Z9AFSJIkafkMapIkSY0yqEmSJDXKoCZJktQog5okSVKjDGqSJEmNMqhJ0hBJXpfkjkHXIUkA8TlqklqR5G5gS2DxkOYLquqEwVS09iSZAvwcGFdVTw+2GkmtGDvoAiRpGQdV1XcH8cVJxhqSJLXES5+Smpfkc0muGLL+iSTXpmfvJHOTnJLkl0nuTvLOIX03TPK3SX6R5IEk5yaZ0G1buu/JSe4HvrC0bcj+dyf5yyQ3J/l1ks8n2TLJPyV5LMl3k2w2pP8eSf41ySNJbkqy95Bt30vysSQ3dPtenWSLbvO/dJ+PJPlVkj2T/E6SU5Pck2R+ki8m2aQ71vgkFyd5sPuuHyfZsh//+0saHIOapNHgz4GdkxyZ5HXA0cAR9dt7N54PbAFsAxwBnJdkx27bWcBLgGnAi7s+/3PIsZ8PPA94IXDMCr7/7cAbuuMcBPwTcAowkd6/o+8DSLIN8G3g490x/wK4IsnEIcc6FDgKmARs0PUB+L3uc9Oq2riq/g04svt5PbA9sDFwTtfvCGATYFtgc+BYYNEK6pc0ShnUJLXm690I0dKfP6uq3wCHA58CLgZOrKq5y+z3P6rqiar6Pr2w9EdJQi98fbCqHqqqx4D/BRwyZL8lwEe7fVcUdD5TVQ9U1Tzg/wE/qqqfVNXjwNeAXbt+hwFXVdVVVbWkqq4BZgAHDDnWF6rqzu67LqcXIFfkncCnqmpOVf0K+AhwSJKxwFP0AtqLq2pxVc2sqoUrOZakUch71CS15i3Lu0etqn6UZA69kajLl9n8cFX9esj6PcDW9Ea8fheY2ctsAAQYM6Tvgi5wrcwDQ5YXLWd94275hcAfJjloyPZxwPVD1u8fsvybIfsuz9b0zmWpe+j9u70lcBG90bRLk2xKL8D+VVU9tYpzkTSKOKImaVRIcjywIfCfwIeW2bxZko2GrL+g6/dLekFqalVt2v1sUlVDw9FITn2/F7hoyHdtWlUbVdVZw9h3eXX8J73wt9QLgKeBB6rqqao6vap2Al4DvBl417M9AUltMahJal6Sl9C77+swepdAP5Rk2UuGpyfZoLuH7c3Al6tqCfAPwNlJJnXH2ibJ/n0q9WLgoCT7JxnT3fC/d5LJw9h3Ab3LsNsPafsS8MEk2yXZmN5l28uq6ukkr0+yc5IxwEJ6l0KXjPD5SBowg5qk1nyzm/W49Odr9ALQJ6rqpqq6i96N/Bcl2bDb537gYXojUJcAx1bVz7ptJwOzgR8mWQh8F9iRPqiqe4GDu/oW0Bth+0uG8W9tdx/emcAN3b15ewDn07vE+S/0nrH2OHBit8vzga/QC2m3A9/v+kpah/jAW0mjWvf4i4urajijVpI0qjiiJkmS1CiDmiRJUqO89ClJktQoR9QkSZIaZVCTJElq1Dr5ZoItttiipkyZMugyJEmSVmnmzJm/rKqJy9u2Tga1KVOmMGPGjEGXIUmStEpJ7lnRNi99SpIkNcqgJkmS1CiDmiRJUqPWyXvUJElaVz311FPMnTuXxx9/fNClaDWNHz+eyZMnM27cuGHvY1CTJGkUmTt3Ls95znOYMmUKSQZdjoapqnjwwQeZO3cu22233bD389KnJEmjyOOPP87mm29uSBtlkrD55puv9kioQU2SpFHGkDY6rcl/N4OaJEkacWPGjGHatGlMnTqVXXbZhU9+8pMsWbJk0GWNOt6jJkmSRtyECROYNWsWAPPnz+fQQw9l4cKFnH766QOubHRxRE2SJPXVpEmTOO+88zjnnHOoKh5//HGOOuoodt55Z3bddVeuv/56AG677TZ23313pk2bxite8QruuusuAC6++OJn2t/znvewePFiFi9ezJFHHsnLX/5ydt55Z84+++xBnmLfOKImSZL6bvvtt2fx4sXMnz+fiy++mCTccsst/OxnP2O//fbjzjvv5Nxzz+X9738/73znO3nyySdZvHgxt99+O5dddhk33HAD48aN47jjjuOSSy5h6tSpzJs3j1tvvRWARx55ZMBn2B8GNUmStFb94Ac/4MQTTwTgpS99KS984Qu588472XPPPTnzzDOZO3cub3vb29hhhx249tprmTlzJq961asAWLRoEZMmTeKggw5izpw5nHjiiRx44IHst99+gzylvvHSpyRJ6rs5c+YwZswYJk2atMI+hx56KFdeeSUTJkzggAMO4LrrrqOqOOKII5g1axazZs3ijjvu4LTTTmOzzTbjpptuYu+99+bcc8/l3e9+91o8m7XHETVJa92UD3970CWskbvPOnDQJUij0oIFCzj22GM54YQTSMLrXvc6LrnkEvbZZx/uvPNOfvGLX7DjjjsyZ84ctt9+e973vvfxi1/8gptvvpn99tuPgw8+mA9+8INMmjSJhx56iMcee4yNNtqIDTbYgLe//e3suOOOHHbYYYM+zb4wqEmSpBG3aNEipk2bxlNPPcXYsWM5/PDDOemkkwA47rjjeO9738vOO+/M2LFjueCCC9hwww25/PLLueiiixg3bhzPf/7zOeWUU3je857Hxz/+cfbbbz+WLFnCuHHj+OxnP8uECRM46qijnnnkx1//9V8P8nT7JlU16BpG3PTp02vGjBmDLkPSCjiiJq2522+/nZe97GWDLkNraHn//ZLMrKrpy+vvPWqSJEmNMqhJkiQ1yqAmSZLUKIOaJElSowxqkiRJjTKoSZIkNcqgJkmSVsuYMWOYNm0aU6dOZZddduGTn/zkM88ze/DBB3n961/PxhtvzAknnDDgSkfWys77mmuuYbfddmPnnXdmt91247rrrhuR7/SBt5IkjWIj/VzC4TwvcMKECcyaNQuA+fPnc+ihh7Jw4UJOP/10xo8fz8c+9jFuvfXWZ16Y3henbTLCx3t0lV1Wdt5bbLEF3/zmN9l666259dZb2X///Zk3b96zLssRNUmStMYmTZrEeeedxznnnENVsdFGG/Ha176W8ePHD7q0vlr2vHfddVe23nprAKZOncqiRYt44oknnvX3GNQkSdKzsv3227N48WLmz58/6FLWqhWd9xVXXMErX/lKNtxww2f9HV76lCRJGiG33XYbJ598MldfffWIHM8RNUmS9KzMmTOHMWPGMGnSpEGXslYte95z587lrW99K1/84hd50YteNCLfYVCTJElrbMGCBRx77LGccMIJJBl0OWvNsuf9yCOPcOCBB3LWWWex1157jdj3eOlTkiStlkWLFjFt2jSeeuopxo4dy+GHH85JJ530zPYpU6awcOFCnnzySb7+9a9z9dVXs9NOOw2w4pGxsvM+55xzmD17NmeccQZnnHEGAFdfffWzHmU0qEmSNIoN53EaI23x4sUr3X733Xf3v4hhPE5jpK3svE899VROPfXUEf9OL31KkiQ1yqAmSZLUKIOaJElSowxqkiSNMlU16BK0Btbkv1vfg1qSMUl+kuRb3fp2SX6UZHaSy5Js0LVv2K3P7rZPGXKMj3TtdyTZv981S5LUqvHjx/Pggw8a1kaZquLBBx9c7VdrrY1Zn+8Hbgee261/Aji7qi5Nci5wNPC57vPhqnpxkkO6fn+cZCfgEGAqsDXw3SQvqaqVTzmRJGkdNHnyZObOncuCBQsGXYpW0/jx45k8efJq7dPXoJZkMnAgcCZwUnpPwtsHOLTrciFwGr2gdnC3DPAV4Jyu/8HApVX1BPDzJLOB3YF/62ftkiS1aNy4cWy33XaDLkNrSb8vfX4a+BCwpFvfHHikqp7u1ucC23TL2wD3AnTbH+36P9O+nH2ekeSYJDOSzPCvDEmStC7oW1BL8mZgflXN7Nd3DFVV51XV9KqaPnHixLXxlZIkSX3Vz0ufewF/kOQAYDy9e9T+D7BpkrHdqNlkYF7Xfx6wLTA3yVhgE+DBIe1LDd1HkiRpndW3EbWq+khVTa6qKfQmA1xXVe8Ergfe0XU7AvhGt3xlt063/brqTWm5EjikmxW6HbAD8O/9qluSJKkVg3jX58nApUk+DvwE+HzX/nngom6ywEP0wh1VdVuSy4GfAk8DxzvjU5IkrQ/WSlCrqu8B3+uW59Cbtblsn8eBP1zB/mfSmzkqSZK03vDNBJIkSY0axKVPSZLWeVM+/O1Bl7BG7j7rwEGXoCEMapI0XKdtMugK1txpjw66AklrwKDWmFH7F9j4Q1fdqVX+H5gk/ZZ/kDTFe9QkSZIaZVCTJElqlEFNkiSpUQY1SZKkRhnUJEmSGmVQkyRJapRBTZIkqVEGNUmSpEYZ1CRJkhplUJMkSWqUQU2SJKlRBjVJkqRGGdQkSZIaZVCTJElqlEFNkiSpUQY1SZKkRhnUJEmSGmVQkyRJapRBTZIkqVEGNUmSpEYZ1CRJkhplUJMkSWqUQU2SJKlRBjVJkqRGGdQkSZIaZVCTJElqlEFNkiSpUQY1SZKkRhnUJEmSGmVQkyRJapRBTZIkqVEGNUmSpEYZ1CRJkhplUJMkSWqUQU2SJKlRBjVJkqRGGdQkSZIaZVCTJElqlEFNkiSpUQY1SZKkRhnUJEmSGmVQkyRJapRBTZIkqVEGNUmSpEYZ1CRJkhplUJMkSWqUQU2SJKlRBjVJkqRGGdQkSZIaZVCTJElqlEFNkiSpUQY1SZKkRhnUJEmSGmVQkyRJapRBTZIkqVEGNUmSpEYZ1CRJkhplUJMkSWpU34JakvFJ/j3JTUluS3J6175dkh8lmZ3ksiQbdO0bduuzu+1ThhzrI137HUn271fNkiRJLenniNoTwD5VtQswDXhjkj2ATwBnV9WLgYeBo7v+RwMPd+1nd/1IshNwCDAVeCPw90nG9LFuSZKkJvQtqFXPr7rVcd1PAfsAX+naLwTe0i0f3K3Tbd83Sbr2S6vqiar6OTAb2L1fdUuSJLWir/eoJRmTZBYwH7gG+A/gkap6uusyF9imW94GuBeg2/4osPnQ9uXsI0mStM7qa1CrqsVVNQ2YTG8U7KX9+q4kxySZkWTGggUL+vU1kiRJa81amfVZVY8A1wN7ApsmGdttmgzM65bnAdsCdNs3AR4c2r6cfYZ+x3lVNb2qpk+cOLEv5yFJkrQ29XPW58Qkm3bLE4A3ALfTC2zv6LodAXyjW76yW6fbfl1VVdd+SDcrdDtgB+Df+1W3JElSK8auussa2wq4sJuh+TvA5VX1rSQ/BS5N8nHgJ8Dnu/6fBy5KMht4iN5MT6rqtiSXAz8FngaOr6rFfaxbkiSpCX0LalV1M7DrctrnsJxZm1X1OPCHKzjWmcCZI12jJElSy3wzgSRJUqMMapIkSY0yqEmSJDXKoCZJktQog5okSVKjDGqSJEmNMqhJkiQ1yqAmSZLUKIOaJElSowxqkiRJjTKoSZIkNcqgJkmS1CiDmiRJUqMMapIkSY0yqEmSJDXKoCZJktQog5okSVKjDGqSJEmNMqhJkiQ1alhBLcmWST6f5J+69Z2SHN3f0iRJktZvwx1RuwD4DrB1t34n8IF+FCRJkqSe4Qa1LarqcmAJQFU9DSzuW1WSJEkadlD7dZLNgQJIsgfwaN+qkiRJEmOH2e8k4ErgRUluACYC7+hbVZIkSRpeUKuqG5P8PrAjEOCOqnqqr5VJkiSt51Ya1JK8bQWbXpKEqvpqH2qSJEkSqx5RO6j7nAS8BriuW3898K+AQU2SJKlPVhrUquoogCRXAztV1X3d+lb0HtkhSZKkPhnurM9tl4a0zgPAC/pQjyRJkjrDnfV5bZLvAF/q1v8Y+G5/SpIkSRIMf9bnCd3Egtd1TedV1df6V5YkSZKGO6K2dIankwckSZLWkuG+lH2PJD9O8qskTyZZnGRhv4uTJElanw13MsE5wJ8AdwETgHcDn+1XUZIkSRp+UKOqZgNjqmpxVX0BeGP/ypIkSdJw71H7TZINgFlJ/ga4j9UIeZIkSVp9ww1bhwNjgBOAXwPbAm/vV1GSJEka/uM57ukWFwGn968cSZIkLbWql7LfAtSKtlfVK0a8IkmSJAGrHlF7c/d5fPd5Ufd5GCsJcJIkSXr2VvVS9nsAkryhqnYdsunkJDcCH+5ncZIkSeuz4U4mSJK9hqy8ZjX2lSRJ0hoY7uM5jgbOT7IJEOBh4E/7VpUkSZKGPetzJrBLF9Soqkf7WpUkSZJWOevzsKq6OMlJy7QDUFWf6mNtkiRJ67VVjaht1H0+ZznbnPUpSZLUR6ua9fl/u8XvVtUNQ7cNnVwgSZKkkTfcmZufGWabJEmSRsiq7lHbE3gNMHGZ+9SeS+/dn5IkSeqTVd2jtgGwcddv6H1qC4F39KsoSZIkrfoete8D309ywZAXs0uSJGktGO4DbzdMch4wZeg+VbVPP4qSJEnS8IPal4FzgX8EFvevHEmSJC013KD2dFV9rq+VSJIk6b8Y7uM5vpnkuCRbJXne0p++ViZJkrSeG+6I2hHd518OaStg+5EtR5IkSUsN96Xs2/W7EEmSJP1Xwx1RI8nLgZ2A8UvbquqL/ShKkiRJwwxqST4K7E0vqF0FvAn4AWBQkyRJ6pPhTiZ4B7AvcH9VHQXsAmzSt6okSZI07KC2qKqWAE8neS4wH9i2f2VJkiRpuPeozUiyKfAPwEzgV8C/9a0qSZIkDXvW53Hd4rlJ/hl4blXd3L+yJEmSNKxLn0l+b+kP8AJg0255Zftsm+T6JD9NcluS93ftz0tyTZK7us/NuvYk+bsks5PcnOSVQ451RNf/riRHrOg7JUmS1iXDvfQ59EG344Hd6V0CXdlL2Z8G/ryqbkzyHGBmkmuAI4Frq+qsJB8GPgycTG8m6Q7dz6uBzwGv7t6A8FFgOr2H7M5McmVVPTzM2iVJkkal4V76PGjoepJtgU+vYp/7gPu65ceS3A5sAxxM71EfABcC36MX1A4GvlhVBfwwyaZJtur6XlNVD3XffQ3wRuBLw6ldkiRptBrurM9lzQVeNtzOSaYAuwI/ArbsQhzA/cCW3fI2wL3LfMc2K2lf9juOSTIjyYwFCxYMtzRJkqRmDfeBt5+hd9kReuFuV+DGYe67MXAF8IGqWpjkmW1VVUlqhTuvhqo6DzgPYPr06SNyTEmSpEEa7j1qPwPGdMsPAl+qqhtWtVOScfRC2iVV9dWu+YEkW1XVfd2lzfld+zz+67PZJndt8/jtpdKl7d8bZt2SJEmj1kovfSYZl+TTwMfoTQI4Evgb4HXd9mkr2TfA54Hbq+pTQzZdCSyduXkE8I0h7e/qZn/uATzaXSL9DrBfks26GaL7dW2SJEnrtFWNqH0S+F3ghVX1GED3ZoK/TfI5ejf1b7eCffcCDgduSTKrazsFOAu4PMnRwD3AH3XbrgIOAGYDvwGOAqiqh5J8DPhx1++MpRMLJEmS1mWrCmoHADt0MzEB6O4zey/wS3qP1FiuqvoBkBVs3nc5/Qs4fgXHOh84fxW1SpIkrVNWNetzydCQtlRVLQYWVNUP+1OWJEmSVhXUfprkXcs2JjkMuL0/JUmSJAlWfenzeOCrSf6U3psIoPeGgAnAW/tZmCRJ0vpupUGtqubRe43TPsDUrvmqqrq275VJkiSt54b7CqnrgOv6XIskSZKGWNNXSEmSJKnPDGqSJEmNMqhJkiQ1yqAmSZLUKIOaJElSowxqkiRJjTKoSZIkNcqgJkmS1CiDmiRJUqMMapIkSY0yqEmSJDXKoCZJktQog5okSVKjDGqSJEmNMqhJkiQ1yqAmSZLUKIOaJElSowxqkiRJjTKoSZIkNcqgJkmS1CiDmiRJUqMMapIkSY0yqEmSJDXKoCZJktQog5okSVKjDGqSJEmNMqhJkiQ1yqAmSZLUKIOaJElSowxqkiRJjTKoSZIkNcqgJkmS1CiDmiRJUqMMapIkSY0yqEmSJDXKoCZJktQog5okSVKjDGqSJEmNMqhJkiQ1yqAmSZLUKIOaJElSowxqkiRJjTKoSZIkNcqgJkmS1CiDmiRJUqMMapIkSY0yqEmSJDXKoCZJktQog5okSVKjDGqSJEmNMqhJkiQ1yqAmSZLUKIOaJElSowxqkiRJjTKoSZIkNcqgJkmS1CiDmiRJUqP6FtSSnJ9kfpJbh7Q9L8k1Se7qPjfr2pPk75LMTnJzklcO2eeIrv9dSY7oV72SJEmt6eeI2gXAG5dp+zBwbVXtAFzbrQO8Cdih+zkG+Bz0gh3wUeDVwO7AR5eGO0mSpHVd34JaVf0L8NAyzQcDF3bLFwJvGdL+xer5IbBpkq2A/YFrquqhqnoYuIb/Hv4kSZLWSWv7HrUtq+q+bvl+YMtueRvg3iH95nZtK2r/b5Ick2RGkhkLFiwY2aolSZIGYGCTCaqqgBrB451XVdOravrEiRNH6rCSJEkDs7aD2gPdJU26z/ld+zxg2yH9JndtK2qXJEla563toHYlsHTm5hHAN4a0v6ub/bkH8Gh3ifQ7wH5JNusmEezXtUmSJK3zxvbrwEm+BOwNbJFkLr3Zm2cBlyc5GrgH+KOu+1XAAcBs4DfAUQBV9VCSjwE/7vqdUVXLTlCQJElaJ/UtqFXVn6xg077L6VvA8Ss4zvnA+SNYmiRJ0qjgmwkkSZIaZVCTJElqlEFNkiSpUQY1SZKkRhnUJEmSGmVQkyRJapRBTZIkqVEGNUmSpEYZ1CRJkhplUJMkSWqUQU2SJKlRBjVJkqRGGdQkSZIaZVCTJElqlEFNkiSpUQY1SZKkRhnUJEmSGmVQkyRJapRBTZIkqVEGNUmSpEYZ1CRJkhplUJMkSWqUQU2SJKlRBjVJkqRGGdQkSZIaZVCTJElqlEFNkiSpUQY1SZKkRhnUJEmSGmVQkyRJapRBTZIkqVEGNUmSpEYZ1CRJkhplUJMkSWqUQU2SJKlRBjVJkqRGGdQkSZIaZVCTJElqlEFNkiSpUQY1SZKkRhnUJEmSGmVQkyRJapRBTZIkqVEGNUmSpEYZ1CRJkhplUJMkSWqUQU2SJKlRBjVJkqRGGdQkSZIaZVCTJElqlEFNkiSpUQY1SZKkRhnUJEmSGmVQkyRJapRBTZIkqVEGNUmSpEYZ1CRJkhplUJMkSWqUQU2SJKlRBjVJkqRGGdQkSZIaZVCTJElq1KgJaknemOSOJLOTfHjQ9UiSJPXbqAhqScYAnwXeBOwE/EmSnQZblSRJUn+NiqAG7A7Mrqo5VfUkcClw8IBrkiRJ6qvREtS2Ae4dsj63a5MkSVpnjR10ASMlyTHAMd3qr5LcMch61jeBLYBfDrqONXJ6Bl2BRgl/z7U+8Pd8IF64og2jJajNA7Ydsj65a3tGVZ0HnLc2i9JvJZlRVdMHXYfUT/6ea33g73lbRsulzx8DOyTZLskGwCHAlQOuSZIkqa9GxYhaVT2d5ATgO8AY4Pyqum3AZUmSJPXVqAhqAFV1FXDVoOvQCnnZWesDf8+1PvD3vCGpqkHXIEmSpOUYLfeoSZIkrXcMalptSbZNcn2Snya5Lcn7l9n+50kqyRaDqlEaKUnGJPlJkm916/smuTHJrCQ/SPLiQdcorakkO3a/y0t/Fib5QJL/neRnSW5O8rUkmw661vWVlz612pJsBWxVVTcmeQ4wE3hLVf00ybbAPwIvBXarqtH5LB6pk+QkYDrw3Kp6c5I7gYOr6vYkxwG7V9WRAy1SGgHd6xrnAa8GdgSu6ybzfQKgqk4eZH3rK0fUtNqq6r6qurFbfgy4nd++KeJs4EOAfwFo1EsyGTiQ3h8fSxXw3G55E+A/13ZdUp/sC/xHVd1TVVdX1dNd+w/pPb9UAzBqZn2qTUmmALsCP0pyMDCvqm5KRu3ToaWhPk3vD4/nDGl7N3BVkkXAQmCPQRQm9cEhwJeW0/6nwGVruRZ1HFHTGkuyMXAF8AHgaeAU4H8OtChphCR5MzC/qmYus+mDwAFVNRn4AvCptV6cNMK6h8n/AfDlZdr/it6/75cMoi45oqY1lGQcvZB2SVV9NcnOwHbA0tG0ycCNSXavqvsHWKq0pvYC/iDJAcB44LlJvg28tKp+1PW5DPjnQRUojaA3ATdW1QNLG5IcCbwZ2Le8oX1gnEyg1ZZeErsQeKiqPrCCPncD051MoHVBkr2BvwDeAtwPvKaq7kxyNL3RtbcPsj7p2UpyKfCdqvpCt/5GeqPFv19VCwZa3HrOETWtib2Aw4Fbkszq2k7p3h4hrbO6GXB/BlyRZAnwML37d6RRK8lGwBuA9wxpPgfYELimu0ryw6o6dgDlrfccUZMkSWqUkwkkSZIaZVCTJElqlEFNkiSpUQY1SZKkRhnUJEmSGuXjOSStN5JsDlzbrT4fWAwsfUbU7lX15EAKk6QV8PEcktZLSU4DflVVfzvoWiRpRbz0KWm9lmS3JN9PMjPJd5Js1bV/L8nZSWYkuT3Jq5J8NcldST7e9ZmS5GdJLun6fCXJ73bb9k3ykyS3JDk/yYaDPE9Jo5NBTdL6LMBngHdU1W7A+cCZQ7Y/WVXTgXOBbwDHAy8HjuwuowLsCPx9Vb0MWAgcl2Q8cAHwx1W1M73bTN67Fs5H0jrGoCZpfbYhveB1Tfc6tFOByUO2X9l93gLcVlX3VdUTwBxg227bvVV1Q7d8MfBaeuHt51V1Z9d+IfB7/TsNSesqJxNIWp+FXgDbcwXbn+g+lwxZXrq+9N/PZW/09cZfSSPGETVJ67MngIlJ9gRIMi7J1NU8xguW7g8cCvwAuAOYkuTFXfvhwPdHomBJ6xeDmqT12RLgHcAnktwEzAJes5rHuAM4PsntwGbA56rqceAo4MtJbum+59yRK1vS+sLHc0jSGkoyBfhWVb18wKVIWkc5oiZJktQoR9QkSZIa5YiaJElSowxqkiRJjTKoSZIkNc2A+RoAAAAZSURBVMqgJkmS1CiDmiRJUqMMapIkSY36/9nQLcVeo+hLAAAAAElFTkSuQmCC\n",
            "text/plain": [
              "<Figure size 720x432 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    }
  ]
}