Aula 1 - Ánalise de dados, Python, Pandas e Genética..ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 174,
   "metadata": {},
   "outputs": [],
   "source": [
    "dados = pd.read_csv('dados_experimentos.csv')\n",
    "#na aula ele criou uma variável com o link fornecido pelo próprio github e forneceu a esse comando que usei essa url\n",
    "#só q na url o arquivo ta zipado, então ele deu o parâmetro compression = 'zip'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 143,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "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>...</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>...</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>...</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>...</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>...</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>...</td>\n",
       "      <td>0.0042</td>\n",
       "      <td>0.0048</td>\n",
       "      <td>0.6670</td>\n",
       "      <td>1.0690</td>\n",
       "      <td>0.5523</td>\n",
       "      <td>-0.3031</td>\n",
       "      <td>0.1094</td>\n",
       "      <td>0.2885</td>\n",
       "      <td>-0.3786</td>\n",
       "      <td>0.7125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </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>...</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>...</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>...</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>...</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>...</td>\n",
       "      <td>-3.3890</td>\n",
       "      <td>-1.7450</td>\n",
       "      <td>-6.6300</td>\n",
       "      <td>-4.0950</td>\n",
       "      <td>-7.3860</td>\n",
       "      <td>-1.4160</td>\n",
       "      <td>-3.5770</td>\n",
       "      <td>-0.4775</td>\n",
       "      <td>-2.1500</td>\n",
       "      <td>-4.2520</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>23814 rows × 877 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 id    tratamento  tempo dose      droga     g-0     g-1  \\\n",
       "0      id_000644bb2     com_droga     24   D1  b68db1d53  1.0620  0.5577   \n",
       "1      id_000779bfc     com_droga     72   D1  df89a8e5a  0.0743  0.4087   \n",
       "2      id_000a6266a     com_droga     48   D1  18bb41b2c  0.6280  0.5817   \n",
       "3      id_0015fd391     com_droga     48   D1  8c7f86626 -0.5138 -0.2491   \n",
       "4      id_001626bd3     com_droga     72   D2  7cbed3131 -0.3254 -0.4009   \n",
       "...             ...           ...    ...  ...        ...     ...     ...   \n",
       "23809  id_fffb1ceed     com_droga     24   D2  df1d0a5a1  0.1394 -0.0636   \n",
       "23810  id_fffb70c0c     com_droga     24   D2  ecf3b6b74 -1.3260  0.3478   \n",
       "23811  id_fffc1c3f4  com_controle     48   D2  cacb2b860  0.3942  0.3756   \n",
       "23812  id_fffcb9e7c     com_droga     24   D1  8b87a7a83  0.6660  0.2324   \n",
       "23813  id_ffffdd77b     com_droga     72   D1  972f41291 -0.8598  1.0240   \n",
       "\n",
       "          g-2     g-3     g-4  ...    c-90    c-91    c-92    c-93    c-94  \\\n",
       "0     -0.2479 -0.6208 -0.1944  ...  0.2862  0.2584  0.8076  0.5523 -0.1912   \n",
       "1      0.2991  0.0604  1.0190  ... -0.4265  0.7543  0.4708  0.0230  0.2957   \n",
       "2      1.5540 -0.0764 -0.0323  ... -0.7250 -0.6297  0.6103  0.0223 -1.3240   \n",
       "3     -0.2656  0.5288  4.0620  ... -2.0990 -0.6441 -5.6300 -1.3780 -0.8632   \n",
       "4      0.9700  0.6919  1.4180  ...  0.0042  0.0048  0.6670  1.0690  0.5523   \n",
       "...       ...     ...     ...  ...     ...     ...     ...     ...     ...   \n",
       "23809 -0.1112 -0.5080 -0.4713  ...  0.1969  0.0262 -0.8121  0.3434  0.5372   \n",
       "23810 -0.3743  0.9905 -0.7178  ...  0.4286  0.4426  0.0423 -0.3195 -0.8086   \n",
       "23811  0.3109 -0.7389  0.5505  ...  0.5409  0.3755  0.7343  0.2807  0.4116   \n",
       "23812  0.4392  0.2044  0.8531  ... -0.1105  0.4258 -0.2012  0.1506  1.5230   \n",
       "23813 -0.1361  0.7952 -0.3611  ... -3.3890 -1.7450 -6.6300 -4.0950 -7.3860   \n",
       "\n",
       "         c-95    c-96    c-97    c-98    c-99  \n",
       "0      0.6584 -0.3981  0.2139  0.3801  0.4176  \n",
       "1      0.4899  0.1522  0.1241  0.6077  0.7371  \n",
       "2     -0.3174 -0.6417 -0.2187 -1.4080  0.6931  \n",
       "3     -1.2880 -1.6210 -0.8784 -0.3876 -0.8154  \n",
       "4     -0.3031  0.1094  0.2885 -0.3786  0.7125  \n",
       "...       ...     ...     ...     ...     ...  \n",
       "23809 -0.3246  0.0631  0.9171  0.5258  0.4680  \n",
       "23810 -0.9798 -0.2084 -0.1224 -0.2715  0.3689  \n",
       "23811  0.6422  0.2256  0.7592  0.6656  0.3808  \n",
       "23812  0.7101  0.1732  0.7015 -0.6290  0.0740  \n",
       "23813 -1.4160 -3.5770 -0.4775 -2.1500 -4.2520  \n",
       "\n",
       "[23814 rows x 877 columns]"
      ]
     },
     "execution_count": 143,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "#cada linha é uma culura de célula segunda a Vanessa Leiko"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Como cientista de dados a primeira coisa que eu quero fazer quando pego um problema que eu não conheço é saber"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "#que tipo de informação eu vou estar trabalhando"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Por exemplo, esperamos que o id seja um indentificador único para cada parada"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Geralmente plotamos só o começo da tabela"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "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>...</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>...</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>...</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>...</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>...</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>...</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      droga     g-0     g-1     g-2  \\\n",
       "0  id_000644bb2  com_droga     24   D1  b68db1d53  1.0620  0.5577 -0.2479   \n",
       "1  id_000779bfc  com_droga     72   D1  df89a8e5a  0.0743  0.4087  0.2991   \n",
       "2  id_000a6266a  com_droga     48   D1  18bb41b2c  0.6280  0.5817  1.5540   \n",
       "3  id_0015fd391  com_droga     48   D1  8c7f86626 -0.5138 -0.2491 -0.2656   \n",
       "4  id_001626bd3  com_droga     72   D2  7cbed3131 -0.3254 -0.4009  0.9700   \n",
       "\n",
       "      g-3     g-4  ...    c-90    c-91    c-92    c-93    c-94    c-95  \\\n",
       "0 -0.6208 -0.1944  ...  0.2862  0.2584  0.8076  0.5523 -0.1912  0.6584   \n",
       "1  0.0604  1.0190  ... -0.4265  0.7543  0.4708  0.0230  0.2957  0.4899   \n",
       "2 -0.0764 -0.0323  ... -0.7250 -0.6297  0.6103  0.0223 -1.3240 -0.3174   \n",
       "3  0.5288  4.0620  ... -2.0990 -0.6441 -5.6300 -1.3780 -0.8632 -1.2880   \n",
       "4  0.6919  1.4180  ...  0.0042  0.0048  0.6670  1.0690  0.5523 -0.3031   \n",
       "\n",
       "     c-96    c-97    c-98    c-99  \n",
       "0 -0.3981  0.2139  0.3801  0.4176  \n",
       "1  0.1522  0.1241  0.6077  0.7371  \n",
       "2 -0.6417 -0.2187 -1.4080  0.6931  \n",
       "3 -1.6210 -0.8784 -0.3876 -0.8154  \n",
       "4  0.1094  0.2885 -0.3786  0.7125  \n",
       "\n",
       "[5 rows x 877 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "#mas ai perdemos a informação do tamanho da tabela, contudo, podemos recuperar com o shape:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(23814, 877)"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "#vamos começar com a coluna tratamento: que será uma série, e lembrando, a tabela é um dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0           com_droga\n",
       "1           com_droga\n",
       "2           com_droga\n",
       "3           com_droga\n",
       "4           com_droga\n",
       "             ...     \n",
       "23809       com_droga\n",
       "23810       com_droga\n",
       "23811    com_controle\n",
       "23812       com_droga\n",
       "23813       com_droga\n",
       "Name: tratamento, Length: 23814, dtype: object"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados['tratamento']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "#queremos ver os valores únicos:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['com_droga', 'com_controle'], dtype=object)"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados['tratamento'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Interessante, temos só esses 2 valores, e a vanessa disse q o com controle é um grupo que está submetido a cond\n",
    "# normais a fim de comparação para ver a influência da variável que estamos testando!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([24, 72, 48])"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#prox coluna\n",
    "dados['tempo'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['D1', 'D2'], dtype=object)"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados['dose'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['b68db1d53', 'df89a8e5a', '18bb41b2c', ..., '573c787a2',\n",
       "       'b2fe3eca7', 'dd4a96d16'], dtype=object)"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados['droga'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "#tem uma cacetada, então não tem como tirar tantas conclusões, contudo, a van disse que aqui os nomes foram\n",
    "#propositalmente escondidos para não termos viezes por sabermos qual droga estamos testando e o que esperamos dela"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([ 1.062 ,  0.0743,  0.628 , ...,  0.3942,  0.666 , -0.8598])"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados['g-0'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Segundo a Van esse g se refere a gene, e esses valores são a expressão desse gene em relação a exposição a droga"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Sendo apresentado ao background de biologia da situação o Thiago já formulou a hipótese de que os valores\n",
    "#provavelmente estão normalizados =]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "com_droga       21948\n",
       "com_controle     1866\n",
       "Name: tratamento, dtype: int64"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Queremos agora uma análise mais quantitativa\n",
    "dados['tratamento'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Desafio 1: por que essa dispariedade entre o número de com droga e controle?\n",
    "#Desafio 2: Plotar as 5 últimas linhas da tabela\n",
    "#Desafio 3: Proporção das classes tratamento\n",
    "#Desafio 4: Quantos tipos de drogas foram investigados?"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "A dispariedade entre o número de testes com droga e com controle tem origem no fato de que, como o grupo controle já é bem estudado e temos uma margem de resultados já esperados, podemos realizar uma menor quantidade de testes controle."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "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>...</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>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>...</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>...</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>...</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>...</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>...</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>5 rows × 877 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 id    tratamento  tempo dose      droga     g-0     g-1  \\\n",
       "23809  id_fffb1ceed     com_droga     24   D2  df1d0a5a1  0.1394 -0.0636   \n",
       "23810  id_fffb70c0c     com_droga     24   D2  ecf3b6b74 -1.3260  0.3478   \n",
       "23811  id_fffc1c3f4  com_controle     48   D2  cacb2b860  0.3942  0.3756   \n",
       "23812  id_fffcb9e7c     com_droga     24   D1  8b87a7a83  0.6660  0.2324   \n",
       "23813  id_ffffdd77b     com_droga     72   D1  972f41291 -0.8598  1.0240   \n",
       "\n",
       "          g-2     g-3     g-4  ...    c-90    c-91    c-92    c-93    c-94  \\\n",
       "23809 -0.1112 -0.5080 -0.4713  ...  0.1969  0.0262 -0.8121  0.3434  0.5372   \n",
       "23810 -0.3743  0.9905 -0.7178  ...  0.4286  0.4426  0.0423 -0.3195 -0.8086   \n",
       "23811  0.3109 -0.7389  0.5505  ...  0.5409  0.3755  0.7343  0.2807  0.4116   \n",
       "23812  0.4392  0.2044  0.8531  ... -0.1105  0.4258 -0.2012  0.1506  1.5230   \n",
       "23813 -0.1361  0.7952 -0.3611  ... -3.3890 -1.7450 -6.6300 -4.0950 -7.3860   \n",
       "\n",
       "         c-95    c-96    c-97    c-98    c-99  \n",
       "23809 -0.3246  0.0631  0.9171  0.5258  0.4680  \n",
       "23810 -0.9798 -0.2084 -0.1224 -0.2715  0.3689  \n",
       "23811  0.6422  0.2256  0.7592  0.6656  0.3808  \n",
       "23812  0.7101  0.1732  0.7015 -0.6290  0.0740  \n",
       "23813 -1.4160 -3.5770 -0.4775 -2.1500 -4.2520  \n",
       "\n",
       "[5 rows x 877 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Desafio 2:\n",
    "dados[23809:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "com_droga       0.921643\n",
       "com_controle    0.078357\n",
       "Name: tratamento, dtype: float64"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados['tratamento'].value_counts(normalize = True) # =]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "cacb2b860    1866\n",
       "87d714366     718\n",
       "9f80f3f77     246\n",
       "8b87a7a83     203\n",
       "5628cb3ee     202\n",
       "             ... \n",
       "d70cdde82       1\n",
       "18a406358       1\n",
       "b01cf573a       1\n",
       "ed64cad3a       1\n",
       "758c4ac3d       1\n",
       "Name: droga, Length: 3289, dtype: int64"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados['droga'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [],
   "source": [
    "#3289 drogas :o"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "D1    12147\n",
       "D2    11667\n",
       "Name: dose, dtype: int64"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados['dose'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "D1    0.510078\n",
       "D2    0.489922\n",
       "Name: dose, dtype: float64"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados['dose'].value_counts(normalize = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "#vamos fazer gráficos de pizza para vizualizar melhor agora:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:ylabel='tratamento'>"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAUEAAADnCAYAAACAPOR2AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAAAaEklEQVR4nO3deZwdVZ338c8vSROWQBJIZHNIARqWGMIWSdgSQFSmVFAGBBn2QZ1h2AVLcLRxeSiHh0VAIkYgwAMDowIaiwEhkrAIUQRCiIKOWCwCAQQ6YetOd5/nj6qWm0jSt/vevqfure/79bqvTt+uvueb7dt1aznHnHOIiJTVMN8BRER8UgmKSKmpBEWk1FSCIlJqKkERKTWVoIiUmkpQREpNJSgipaYSFJFSUwmKSKmpBEWk1FSCIlJqKkERKTWVoIiUmkpQREpNJSgipaYSFJFSUwmKSKmpBEWk1FSCIlJqKkERKTWVoIiUmkpQREpNJSgipaYSFJFSUwmKSKmpBEWk1Eb4DiDNK4iSzYGJ+WNTYDSwQf6x8rE+4IB38sfbFb9+B3gTWAo8lz+eBZ4Cnk/j0DXudyRlZM7p35isXhAlBmwL7Axsw7ul90Fg1BAP/zZZGT4J/AZ4EHgojcM3hnhcKRGVoKwkiJIRwFRgJrAHMA3YyGemVfQAS4CFZKW4EPid9hhlsFSCQhAl7wcOBvYH9iZ7+9pMXgTmArcA89I47PKcR5qISrCkgijZGDgEOAzYHTC/iepmOXAbcCtwWxqHy/zGkaJTCZZIECUbAZ8hK74ZwHC/iYZcF3AXMBuYm8Zhj+c8UkAqwRIIomQqcAZZAbZ5juPLs8AVwOw0Dl/yHUaKQyXYooIoGQYcBJxOdoJDMl3AT4DL0zi8z3cY8U8l2GKCKFkPOA44Bdjac5yiWwR8B7gpjcNe32HED5VgiwiiZF2yt7ynAWM9x2k2S4B24Ce61KZ8VIJNLn/bexTwLWBzz3Ga3SPAWWkc3uU7iDSOSrCJBVGyD3ABsJPvLC3mF2RluMh3EBl6KsEmFETJNsD5wCd9Z2lhvcBlwNlpHL7pO4wMHZVgEwmiZCTZsasvockvGiUFPp/G4Z2+g8jQUAk2iSBKPgzMAbbzHKWs5gCnp3H4mu8gUl8qwYILoqQNOBc4i9a/w6PoXgROTOPwZt9BpH5UggWWH/u7HtjFdxZZyY3ACZrSqzVoZumCCqLkeOBhVIBFdBiwMP8hJU1Oe4IFk8/ndzFwouco0r9lwNFpHN7qO4gMnkqwQIIoGQv8CNjPdxapmgNi4Ku69a45qQQLIoiSbYGfkU1bL83nTuDwNA7/6juIDIxKsACCKPk42cH20b6zSE3+DHwkjcOnfAeR6unEiGdBlJwE/BwVYCvYErg3iJJJvoNI9VSCHgVRchZwCbr+r5VsBiwIomRX30GkOipBT4IoicjmspPWsxEwL4iSvXwHkf6pBD0IouRs4DzfOWRIbQDcEUTJAb6DyJqpBBssiJKvAt/2nUMaYh3gp0GUfNp3EFk9nR1uoCBKvkZ2H7CUSydwQBqHd/sOIn9PJdggQZScClzkO4d4sxyYkcbhI76DyMpUgg0QRElIdiG0Dj+U20vAdF1HWCwqwSEWRMlk4H5gfd9ZpBCeICvC130HkYz2TIZQECXvA+aiApR3bQvcnM8TKQWgEhwi+VT4twATfGeRwtkH+J7vEJJRCQ6dK4HdfYeQwjohiJLP+Q4hOiY4JIIoOQ240HcOKbzlwE5pHP7Jd5AyUwnWWRAlOwILgbU8R5Hm8Ftg9zQOu3wHKSu9Ha6jIErWBf4LFaBUbxeySVnFE5VgfV1AdvZPZCBOza8lFQ/0drhOgijZH/iF7xzStF4BpqRx+LzvIGWjPcE6CKJkNNnZYJHBGke2wJY0mEqwPi4A/sF3CGl6h+TvKKSB9Ha4RkGUTCU7G2y+s0hL+AMwWWeLG0d7grW7GBWg1M9E4Eu+Q5SJ9gRrEETJYWSXxIjU01vAdmkcPuM7SBloT3CQgihZG60RIkNjXXSSpGFUgoN3BrCF7xDSsj4dRMlHfYcoA5XgIARRsikQ+c4hLa/dd4AyUAkOzjeAUb5DSMubHkTJfr5DtDqV4AAFUbIZcJTvHFIaX/UdoNWpBAfuZDRBgjTOzCBK9vQdopWpBAcgiJJRwBd855DS+Q/fAVqZSnBgTgDG+A4hpfPR/M4kGQIqwSoFUTICONV3Dimtc3wHaFUqweodiq4LFH8+EUSJJukYAirB6p3uO4CU2nDgON8hWpHuHa5CECUfAhb7ziGl9ywQpHHY6ztIK9GeYHUO9x1AhGzOSt1KV2cqweqoBKUojvQdoNXo7XA/giiZDvzKdw6R3FvAxmkcvuE7SKvQnmD/tBcoRbIu8BnfIVpJIUvQzI4xs8t85wiiZDjZpTEiRfJp3wFaSSFLcHXMbESDh9wP2LjBY4r0Z98gStp8h2gVVZWgmR1lZo+Z2SIzu87MJpjZvPy5eWa2Rb7dHDObZWZ3m9lTZjbDzK4ys9+b2Zx+xviumb1qZs9S8RY0f80Lzexu4DtmtqOZPZiPfYuZjc23m5o/94CZnW9mj+fPB2Z2r5k9nD92H8Cfz0ED2FakUTYApvsO0Sr6LUEzm0R2y86+zrkpwCnAZcC1zrkdgOuBSyq+ZSywL3AaMBe4CJgETDazHVczxiVkExO0k83VtxswrWKTicBHnHNnANcCX87HXgx8Pd/mauCLzrnpQE/F974E7O+c2xn47CpZ+6PlD6WoPuY7QKuoZk9wX+DHzrlXAJxzr5L9FLoh//p1QOVUP3Nddsp5MbDUObfYOdcLLAGC1YzxKeC/nXOXOOdmkxVb5bY/cs71mNloYIxzbkH+/DXA3mY2BljfOdd3FveGiu9tA2ab2WLgR8D2VfyeCaJkAvCBarYV8UAlWCfVlKAB/V1HU/n1zvxjb8Wv+z5f0zG9ymMc66zytTf7GX9NS16eBiwFpgC7Uv1cgJrRV4ps5yBKxvsO0QqqKcF5wKFmthGAmW1Idt3cYfnXjwDuqzHHd4BDzOy/zOxasrfFv111I+dcB/Came2VP3UksMA59xqw3Mz63kIfVvFto4EX8r3RI8nuwazGzAH/LkQax9DdI3XR79lW59wSM/s2sMDMeoBHyGZXvsrMzgReBo6tJYRzbpaZjQTOBF4je4vduZrNjwa+b2brAk9VjH082dveN4H5QEf+/OXAT8zsEOBu+t+r7LNX/5uIeLU/2TF5qUEh7hgxs3nOuf36e66f1xjlnHsj/3UEbOqcO2UweYIo2Rx4bjDfK9JAj6dxONl3iGbn9TpBM1s7f3s9zszGmtmG+SMANhvgy4Vm9mh+acxewLdqiLZHDd8r0ijbBFGi9W5q1OiLjzGzhcDI/NNxwHiy4xu/5d0THMuA7w3kdZ1zNwE31SnmDnV6HZGh1EZ2tcOjnnM0tYaXoHNut1WfM7OTnHOXNjrLGmzrO4BIlaagEqxJw0vwvTjnLs3v5AioyOScu9ZTJJWgNIspvgM0u0KUoJldB2xN9hOt724PR3Z3SEPlkyZ8sNHjigySSrBGhShBsouYt3dFOFUNW6HF1aV56Ph1jYoyi8zjwCa+Q+T0VliayTjdOVKbouwJjgN+Z2a/puIiaefcpzxkUQlKs9mE7KYFGYSilGC77wAVdDxQms3GaDXEQStECTrnFpjZBOCDzrm78lviqr3Ht97GeRpXZLA08W8NCnFM0MxOAH4MXJE/tTlwq6c4Yz2NKzJYRTme3pQKUYLAiWS3qi0DcM79EXifpyxjPI0rMljaE6xBUUqw0znX1fdJvpaIr8tltCcozUYlWIOilOACMzsbWMfM9iebAXqupywqQWk2KsEaFKUEI7JT/IvJ1hq5Dfhqo0MEUTIMWL/R44rUSD+4a1CUs8O9wOz84dMY1jxVv0gRFeL/cbMqxJ6gmX3CzB7Jl9xcZmbLzWyZhyjreRhTpFa+LidrCUX5CXIx8Blgsef7h7s9ji0yWEX5f9yUivKH9yzweAEmUFjduiZSM+eOG377g2eNuHH8WnRv6DtNK+lh2DJ41XeMplWUEjwLuM3MFrDyvcMXNjhHV/+byOCYXdVzwPSbema+cV7bDx/65LAHdjHTSah6GEbPqkvUygAU4pgg8G3gLWBtsrOzfY9G057gEHuTdUadvOKkmbt2zup8oGe7Bc7pB08d6M+wBkVZbe4h59yuvnMABFHSi84QN8wEe/G5H7Rd+PREe266WWF+KDeb+2nv2NN3iGZVlH90d5lZURaS1k/VBnrabfL+j3X95x4HdX3jf190Y3/jO0+TWuE7QDMrSgmeCNxuZm97vkQGVIJeLHIfmDit83tTj+8649Hlbp0lvvM0mbd9B2hmhShB59z6zrlhzrl1nHMb5J9v4CnOck/jCjCvd5cdJ3deOensFcc92OlGPOU7T5N41neAZlaIEgTIF1//sJnt3ffwFOUFT+NKhRt6PjJtu845Ey7tPujeHjdMfydrlvoO0MwKUYJm9i/APcAdwLn5x3ZPcZ73NK6sopdhwy/oPnSvSZ1Xjrmpe8b8XsfrvjMVVOo7QDMrRAkCpwBTgaedc/sAO+FvzQSVYMG8w8h1vtz9hZk7df6Au3umzHeOd3xnKpinfQdoZkUpwXecc+8AmNlI59wTwDaesuj4SkF1MGrMsSu+PHPPzu++trg3uNe5v61RXXap7wDNrCgl+JyZjSGbUv9OM/sp/vbI/uxpXKnSXxi/6Se7/s9e/9h1Xvps7/iFvvN41omOY9ekEBdLVzKzGcBo4H+ccw2//imIkmnAA40eVwZvz2GLF1/admnvWHtjiu8sHvwv7R1aIbEGhdgTNLPr+n7tnFvgnPsZcJWnOLoso8nc1zt58k6dP5hyWte//uZtt9YffOdpsNR3gGZXiBIEJlV+YmbDgV18BEnj8CXgFR9jS21u6d1r6vadV33gP1d89v5uN+w533kaRCdFauS1BM3sK2a2HNghv1NkWf75S8BPPUbT7VtNyjFs2OU9B+6xfefV46/t3n9Br7O/+s40xFLfAZqd1xJ0zp3nnFsfOD+/U6TvbpGNnHNf8Rjt1x7Hljroom3k17qPnbFD5+y223umzneON31nGiKP+w7Q7Arxdtg595UC3TECKsGW8QbrbvDFFafN3K3ze2891DvxHudabrKBX/kO0OwKcXY4v2PkFOD9wKPANOAB59y+PvIEUTKe7C25tJit7PmnZ7dd8PxW9sI0s6afMu2PtHdM9B2i2RViT5Bi3TFCGocvo2MtLekpt9mE/boumH5I19efeNmN/q3vPDW633eAVlCUEizSHSN9dHKkhT3kttluauesXb7YdcrDb7i1f+c7zyC11FthMxtjZv82iO+baWY/H+y4RSnBIt0x0qfsdyKUwu29u+38oc4rtzt3xZEPdLnhzXa5yT2+A9TZGOA9SzC/bG5IFKIEnXOfds697pxrB/4DuBI4yGsouN3z+NIwZlf3HDB9u845m1/RHd7T46wZjgc/Q3vHk9VsaGZHmdljZrbIzK4zswlmNi9/bp6ZbZFvN8fMZpnZ3Wb2lJnNMLOrzOz3ZjannzE+bmYP52PMy5/b0Mxuzcd50Mx2yJ9vz193fj7OyfnLxMDWZvaomZ2f7+HdbWY3AIvNbG0zu9rMFufrlO/zHjnWy1/7N/k2B/b35+O9BM1smJn97TR/3x0jzjmvMzyncbgE+JPPDNJYPQwfcV73EXtP7rxyvVt69pjvHL5mN6/GndVsZGaTgHOAfZ1zU8iOv18GXOuc2wG4Hrik4lvGAvsCpwFzgYvIbmaYbGY7rmaM8cBs4OB8jEPyL50LPJKPczZwbcW3bQt8DPgw8HUzawMi4E/OuR2dc2fm230YOMc5tz3ZDPQ45yYDhwPXmNnaq8Q5B/ilc24qsA9wvpmtt6Y/I+8l6JzrBRb1/TQqmLm+A0jjvcXa65224sSZO3d+v/v+nkkLnCvkKoR3VLndvsCPnXOvADjnXgWmAzfkX78OqFykaW6+/vdiYKlzbnH+f3QJEKxmjGnAPc65P1eMQf661+XP/RLYyMxG519LnHOdea6XgI1X89q/7nvdVV7vCbK7ZVY9O/5RIDKzR4H5ZCtYrrFbirLu8KbAEjP7Nbx7Uatz7lP+IgHwM+BUzxnEk9fYYMMjVpwzYwtb+twVbRc+va09W5QV8XqBu6rc1oD+roOr/Hpf4fey8hK0vay+L1Y3xntdgtS3XeVr96zhtSsvcq/mkiYj2yOt6lABFGBPMDcK+ATwDeAC4EJW/5Ohke4FXvMdQvx6xm38/gO6vrPHgV3f/NMLbsMiXDXwAO0d1f67nAccamYbQXacjuys8mH5148A7qs5D8wwsy0rxoDsxM0R+XMzgVecc2s6xLCcNa83Xvl6E8n28FYtuzuAk8zM8u126i98UUpwRH4ssO8xH1jHd6g0DruB23znkGJ4zG39wemdl009tuvMRcvcuos9RplT7YbOuSXAt4EFZraIbAfjZOBYM3sMOJLsOOGgOedeBj4P3JyPcVP+pXZg13ycGDi6n9f5K3C/mT1uZue/xyaXA8PNbHE+xjHOuVUPVXwTaAMey881fLO//F7vGDGzfyU7Jb4VK5+EWB+43zn3z16CVQii5FDe/UsV+ZvDhv9yYfuIa8atbSu2buCwbwKb0t6hVRHrxHcJjiY7G3Ue2ZmhPssrDq56FUTJKLKZe0f5ziLFM4zenpNH3Pyrfx9+6wdGWO+mDRjyato7jmvAOKVRiHuHiy6IkivIdvdF3tNIut45d8Q1Cw8dfveUYcaYIRxqT9o7vN0uZ2YLgZGrPH2kc87n4YGaqASrEETJjsAjvnNI8W3AGx0Xtc16ZN9hj+xmVvfj2k/Q3rFdnV+z9IpyYqTQ0jh8FN1GJ1VYxqjRx684c+bunZd2LOrdqt4r4vlacqKlqQSr933fAaR5vMBGmxzY9a29Pt4VP/N07/serMNLdrPyHRdSJyrB6t2ErhmUAXrSbbHljK6Lp32u6+wlr7r1H63hpX5Oe8fSeuWSd6kEq5TG4dvANb5zSHP6Ve+HJu3cecWOp3Sd+NBbbq2q72aocGXdQwmgEhyoWWS3D4kMyk9799h1+86rJ5634vD7V7jhz1b5bU8D/zOUucpMZ4cHKIiSG4HP+s4hza+N7q6zR1z/4NHDf7H9MHPj1rDpCbR3/LBhwUpGe4ID9w20Nyh1sIIRa53bffTekzt/ODLp2W2+c7zxHps9xQBuk5OB057gIARRchNwqO8c0lrG8frLl6/13d9PtSenm9GWP30M7R06Fj2EVIKDEETJtmTrvQ7ZlN9SXlva88/Mbrvwua3t+Q3N+BDtHfW81lBWoRIcpCBKZgP/4juHtK5/sKUH33vecTf7ztHqdExw8NqBt32HkJb1oAqwMVSCg5TG4V/I1l8QGQqn+w5QFirB2nwLLcYk9fffaRw+4DtEWagEa5DfRfIF3zmkpbxKjTM9y8CoBGuUxuE8dB2X1M+paRy+6DtEmagE6+MMsmUDRWqRpHF4ne8QZaMSrIM0DvUWRmrVgQ6teKESrJM0Dm9EK9PJ4J2RX3EgDaYSrK/PAy/7DiFN5xdpHGqqLE9UgnWU/yQ/DOo6pbq0tpeB432HKDOVYJ2lcfhL4Gu+c0hT6AYOSePwOd9BykwlODTOA+b6DiGF96U0Dhf4DlF2mkBhiARRMgZ4CNjacxQppuvSODzKdwjRnuCQSePwdeBgNMmC/L2H0eUwhaESHEJpHC4im25Lu9vS5xXgM/ktl1IAKsEhlsbhDcCpvnNIIbwNHJzG4dO+g8i7VIINkMbhJWRrk0h5dZHtAd7jO4isTCdGGiiIkkuAk3znkIbrBg5N4/AW30Hk72lPsLFOAf6f7xDSUL3A0SrA4lIJNlAahw44Fl1DWBYO+EJ+XFgKSiXYYGkcdpMt1/kz31lkyJ2SxqEWTS84laAHaRy+Q3YNoeaOa029wL+lcXip7yDSP5WgJ/ke4dHAxZ6jSH29A/xTGoezfAeR6ujscAEEUXI68H8B851FavIacGAah/f6DiLVUwkWRBAlfW+P1/GdRQblj8An0jj8g+8gMjB6O1wQaRz+BNgH0LRKzeduYJoKsDmpBAskjcOFwI5A4jmKVMcBFwIfy9eZkSakt8MFFESJAaeTzUvY5jmOvLelZBdB3+E7iNRGJVhgQZRMA24EJvjOIiu5HTgmjcOlvoNI7fR2uMDSOHwQ2Am41XMUyXSR7aH/owqwdWhPsEkEUXIMcD4wznOUsnoC+Fwah4/4DiL1pT3BJpHG4RxgG2A2mqS1kd4EvgJMUQG2Ju0JNqEgSqYDs4ApvrO0uJvIFkPSZUstTCXYpIIoGQ6cTDZZ6yjPcVrNEuDf0zic7zuIDD2VYJMLomQz4ByyBbxHeo7T7F4HzgUuy+/tlhJQCbaIIEo2ByKyhZ3W9hyn2bwEXARcnsbhMt9hpLFUgi0m3zM8i2xJR5Xhmj1Ddsb9Sq3+Vl4qwRYVRMkmZGV4PLCB5zhF8yQQA9encbjCdxjxSyXY4oIoWQ/4HPBFYGfPcXzqAW4Dfgj8PI3DXs95pCBUgiUSRMkuZBO5Hk55Lrp+ArgWmJPG4Qu+w0jxqARLKIiSNiAEPgt8FNjQb6K6+wvZPdfX6wJn6Y9KsOTy6w13Aw7IHzvTfDNcvw3cC9yZPx7LV/YT6ZdKUFYSRMnGwMfzx27Aln4TvScHPMq7pXdfvniVyICpBGWNgigZQzbR604VH7cDRjQowqvA48Diisfjup5P6kUlKAMWRMlIsiLcHNgU2Cz/WPkYD6zF6ifp6AH+Snah8ssVH/t+/WdgcRqHzw/Zb0QElaAMsfyY41pke469FY8uHbeTIlAJikipaT5BESk1laCIlJpKUERKTSUoIqWmEhSRUlMJikipqQRFpNRUgiJSaipBESk1laCIlJpKUERKTSUoIqWmEhSRUlMJikipqQRFpNRUgiJSaipBESk1laCIlJpKUERKTSUoIqWmEhSRUlMJikipqQRFpNRUgiJSaipBESk1laCIlJpKUERK7f8DhiTWOdjQsUUAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "dados['tratamento'].value_counts().plot.pie()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:ylabel='tempo'>"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAPUAAADnCAYAAADGrxD1AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAAAY7klEQVR4nO3de5RcZZnv8e9TVV2de3WSTiAQpAA93GzkEkBIDjhmFLHBhXMcRh21lINwBkYZA9FSbttxMD04yCUggiwxSPAGOHEoBUEFUQjh7oYENIEGYkIkQCohl+50+j1/7I50Ip2u7q69n9p7P5+1aoVuquv9sciv9/V9tzjnMMYkR0Y7gDGmvqzUxiSMldqYhLFSG5MwVmpjEsZKbUzCWKmNSRgrtTEJY6U2JmGs1MYkjJXamISxUhuTMFZqYxLGSm1MwlipjUkYK7UxCWOlNiZhrNTGJIyV2piEsVIbkzBWamMSxkptTMJYqY1JGCu1MQljpTYmYazUJvZEJCsij4vIHX1fHyoii0XkCRF5RESO0s4YJSu1SYJzgGX9vr4U+Kpz7lDgor6vUyOnHcDUX7FcEWBPYB9gX6AITAEmA5OACcB4YCwgQG/fy/X9uRV4HXi132stsAZYAfyps6N9TWT/QbsgItOBduASYE7ftx3BfyNAAVilEE2N2APy4q1YruwBHNH3OhzYH9gbaA556A3A8r7XU8DDwEOdHe2vhTzuDkTkVmAewS+p85xzJ4nIgcBdBL+wMsCxzrkXosylyUodI31b4MOB9wEzCYo8TTXU31oOLAEeAn7T2dHuhzWQiJwEfNA5d5aIvIc3S30VcJ9z7jYRORU4wzn392HlaDRW6gZXLFf2BN7f95pNsBsdJyuBO4FfAPd0drSvr9cHi8g84JNADzCKYJf7duBkoMU550REgKpzbsLAn5QsVuoGVCxXpgGnAh8DjlaOU09bgd8BPwR+3NnRvq5eH7zTlnoZ8C/OuXtFZDZwqXPuiHqN1eis1A2iWK5MBD5CUOTjSf6ViS6gAtwMVDo72rtH8mE7lXoWcCXBieAtwFnOuUdHFjc+rNTKiuXKocDnCMo8WjeNmteB7wNXdXa0r9AOE3dWagXFciUH/ANBmWcpx2kkvcAdwOWdHe33KmeJLSt1hIrlSjNwJvBFguvIZmBPAJcDt3R2tPcoZ4kVK3UEiuVKHjgd+ApW5qFaDvw7sLCzo71XO0wcWKlD1LebfRpwPvA25ThxtxT4SmdH+yLtII3OSh2SYrnyXmA+cJB2loT5PfD5zo72x7SDNCordZ0Vy5XpwGUE15lNOLYB3wIuqOfNLElhpa6TvuPmOcAFBBMlTPhWA1/o7Gj/kXaQRmKlroO+a80LgEOUo6TVL4EzOjvaUzNpY1eSftdSuLxCdu75cz9PMIHBCq3n/cCTxXLlo9pBGoFtqYfLK+wFLOx1cvAxXfN71jBpqnYkAwS3nZ6d5mNt21IPh1f4B+BJ4H9nxE1a1Hyh7fY1jk8ATxTLlWO1g2ixUg+FVxiNV7gOuA2YuP3bu8vrR34p94Pf6gUzO9kHuK9YrpytHUSD7X7XyitMAv4HeMstgHNs/Pvub6xd4fbcO9pgZhDXAZ/r7Gjfqh0kKralrkVw/Hw/AxQaQISxP81fvD5D77bogpkanAncUyxXWrWDRMVKPRivcDDwADXcGTZBNrVd1nTt/eGHMkN0HPBwsVxp0w4SBSv1rniFmQRb6Om1/sgpmd/PnCHPLhv8nSZiRYLj7GO0g4TNSj0Qr/Ah4G76nRCrhQhNC/NfzzfTvSWcYGYEJgJ3F8uV2dpBwmSlfite4XSCBeyGtRJJs2zd78amSx+qbyhTJ2OBSrFcOUU7SFis1DvzChcC3wGyI/mYYzJLjzshs+Tx+oQyddYM/KRYrnxCO0gY7JJWf17hUmBuvT6ux2VWHdZ13dgNjC3U6zNNXW0D/qmzo/027SD1ZFvq7bzCWdSx0AA56d3j1vxXn6rnZ5q6ygK3FMuVRC30b6UG8AonAleF8dH7Z1bOLGXvfDCMzzZ1kQd+WixXErO+uu1+e4VDCBaYHx/WEL2O14/turr7ZSbtFtYYZsReA47r7Gh/WjvISKV7S+0VphEsSRtaoQEywsRFzRe8FOYYZsQmAXcWy5XY/+JNb6m9whiCe7n3imK43WTdjC/nFtqkj8Y2Hbi1WK40aQcZiXSW2itkgIUET42MzBnZyox3yMrOKMc0QzaLYMHI2EpnqeFS4JSoBxVhzO35izfapI+Gd2axXDlTO8Rwpa/UXuEM4Fyt4cfL5oOvaLrGJn00vvnFcmWmdojhSNfZb69wAMHjXJo1YzhHz6ndF/3pYXfAgZo5zKBeAA6J29JI6dlSB8fR30W50AAi5G7Oz8uPomuzdhazS3sD12iHGKr0lBo+DzTMtLtm2brf9/KXLtHOYQb1iWK58k/aIYYiHaX2CvsCl2jH2NnRsuy4D2YessfHNL5r+568EgvJL7VXEIJZV2O0o+xMBLmqaf60CbxR1c5idmki8D3tELVKfqnhDOC92iEGkpPeabflPZv00fhmF8uVT2mHqEWyS+0VphNck25o78ismnla9hcPaOcwg/qvYrkySTvEYJJd6mB52AnaIWpxQe77B03j1Ze1c5hdmgJ8XTvEYJJbaq/wSeCD2jFqlRFaFjVfuFI7hxnUZ4vlyuHaIXYlmaX2CuOBb2rHGKqpsm7G+bmbbdJHY8sQ0tz7eklmqeEcIJaLt5+e/fmM/yUvPa+dw+zSzGK5cpJ2iIEk7zZRr9ACPA+06AYZvg1u9NOHdl2//zayOe0sZkCPA0d0drQ3XIGSuKWeQ4wLDcGkjyubrv6ddg6zS4cB/0c7xFtJ1pY6eIhdJyGvZBIF5+j5aPcFf3zIHTTo436MmqVAW2dHe692kP6StqX+NxJQaAgmfdyU7xhtkz4a2kHAx7VD7Cw5pfYKY4FEPY+4WXr2uSnfYZM+GtsXtQPsLDmlhtMIFo9LlCPl2ePaM4sf1c5hBtRWLFf+TjtEf8kotVfIEpwgS5xg0sfVexR4Y512FjOgc7QD9JeMUsM/EjyqNJGy0jvt9vzFS7VzmAGdXCxX9tEOsV1SSv2v2gHCtl9m9bGnZys26aMxZWigv4Pxv6QVzMR6ERDtKGHrdayb1XXV5lW0TtPOYv7GOmD3zo72Lu0gSdhS/yMpKDT8ddLHKoj7b+JEagHatUNAckqdGlOkesRFue/bEsON6Z+1A0Dcd7+9wl4Ey7imYku9nXNsPrG7Y/Uz7m37amcxO+gCduvsaFddniruW+qPkLJCA4gw+ta8tyXLth7tLGYHzTTA/eBxL3Wqdr37GydbDprfNP/32jnM31C/bTS+pQ52vd+tHUPTiZklM9+deTr2z1NOmOOL5UpBM0B8S53SXe/+RMjd1PSfY0bTtUk7i/mrHDBbM0CcS32qdoBGkJeefb6fn/eIdg6zgw9oDh7PUge73kdrx2gUMzJ/PO7kzANW7MZxgubg8Sw1HE/Kd713dkXTNdNb2PC6dg4DwNuK5YraE03jWuqGXqJVQ1bc7rfnL35GO4f5q/drDWylTpB9My8fc0b2DrvM1RjUDg/jV+rggXeHacdoVF/O3fLOPXlltXYOw5FaA8ev1PB2YvIoHQ0iFBY1X7jaJn2oe3uxXJmoMXAcS2273oNolfWHe7kFNulD3wyNQeNY6iO0A8RBKfvLow6UF1Zo50g5lV3wOJbattQ1EGHUrfmvdufo2aqdJcVUzv3EsdR2kqxGY2XLgVc3XWVLIOl5u8agNZVaRHYTkZP6XlPDDjUgr7APCVwGOEwnZB6ZNTPz1FPaOVJqP41BBy21iJwKLCGY5ngq8JCIfCTsYAOwrfQQiZC9senScWPYslE7SwqNL5YrU6IetJYt9fnAkc65knPuU8BRwIXhxhrQdKVxYy0vPcWb81+3BwLoiHwXvJZSZ5xzf+n39as1/lwYVK77JcHhmeXHnZL5nU36iF7ku+C1lPNOEblLRD4tIp8GKsDPw401oBalcRPhsqZr95rI+te0c6TMXlEPOGipnXNzgeuAQ4B3Adc7574UdrAB2JZ6BLLidvtp/uJntXOkTOQndmvdjX4AuA/4NfBgeHEGZaUeoWJmzTH/L/szm/QRncYrtYicTnD2+8MESwgtFpHTwg42ACt1HXwp98N3TpdXVmnnSInI/87WsqWeCxzmnPu0c65EcJum7X7HmAiFRfkL1tikj0g03pYaWAls6Pf1BuClcOIMykpdJ5Nlw2Ffy934W+0cKdCQpf4zwQ0nnohcDCwGlovIHBGJ+pnQVuo6+kT2nqMPkk6b9BGusVEPWEupVwD/DWzfVVsErAbG972i4RXywJjIxkuBvkkfW23SR6iyUQ+YG+wNzrmvRhGkBi3aAZJojHQdcG3Tlfd9duu5x2tnSajGK7WIzCC4VXTv/u93zh0SYq63EscZZbGwccIzo8ZNKdtNKaHIrIv6CbeDlhpYSHAG3Ad6w42zS/YUihA4cJe0TmwRsdlv4ehdF/WItZT6Fefcz4b6wSKyP/Cjft/aF7gI2BM4GegmOF7/jHNuXQ0fabOMQnDzhPEPbslkjtXOkWDdUQ846POpRWQ28DHgVwTP3wXAOXd7zYOIZAnOoh8N7A/82jnXIyL/2fdZtV339gpbCB4XaupgG2w7srjXi1tF9tHOkmC+X/IjPVStZUv9GeAAoIk3d78dUHOpCR4YtsI59wLBQ+K3W0xwl1qtNmGlrpvrWyY8uFVklnaOhIt8S11Lqd/lnGsb4TgfBX7wFt8/jR130QfzBnatui66ofu6lkJRO0cKRF7qWs4oLxaRg4Y7gIjkgQ8BP9np++cDPQQn4mq1drg5zI6umNSyeJuILToRvj9HPWAtW+pZQElEnic4phbADeGS1onAY865Ndu/ISIl4CRgthvsoH5Hfxn8LWYwm0U2LZww/gDtHCnxfNQD1lLqkT5r92P02/UWkQ8QTAg53jk31MtUr4wwiwHmTZ64pFfkPdo5UuK5qAesZZGEFwhWb3hv3z9vquXnAERkDPA+djypdjXB7aV3i8gTIvLtIeS1LfUIbRBZ/9/jxr5LO0eKNN6Wum8SxwyCS1E3EpwFvxmYOdjP9m2JJ+/0vZEsxGalHqGLp0x+zNlWOkqRl7qWLe6HCU50bQRwzq0iyokcO+pUGjcRXs9kXrt7zGh7bFF0HDtewo1ELaXu7juZ5QBEJPKpZP08rjh27JWnTPYR0fqFnEar/JLfNfjb6quWUv9YRK4DWkTks8A9wHfCjTWgP7Hjgg2mRmuy2TUPjB51lHaOlIl81xtqK/UU4FbgNoLj6ovQWlTfqzrgSZWxY+68qa3PIjJaO0fKNGyp3+ecu9s5N9c5d55z7m6Ca89aHlMcO5ZezOVWPtGcP0Y7RwqplHrAs98i8i/AWcC+IvKHfv9qPKC5xKwdVw/RF6a2voDdPaZBZamoXV3SugX4BTAPKPf7/gbnnOaEettSD8GzTU3P/THf9G7tHCml8hjhAUvtnKsCVYI7whrJUmALMEo7SBzM2a11DSL7audIoRf9kr9cY+D4LRHkVXsIVmExg3iyOf/si7mcbaV1/Epr4PiVOmDH1TWYM7V1PSKinSOlrNRDZMfVg/j96FH+X3K5I7VzpNivtQaOa6nv1Q7Q6MpTJm/TzpBiS/2Sv1pr8HiW2qs+CzylHaNR/XLM6MfWZbOHaudIMbVdb4hrqQM/Gfwt6XTRlMm2jpsuK/UwWanfwm3jxi7ZmMkcrJ0jxbahfHgY31J71WXA09oxGkkv9M6bPNEWZtT1iF/yq5oB4lvqgG2t+7lpwvjFXZnMO7RzpNyd2gGs1AnRAz1XTWrZQztHyvUSrA6kKt6l9qpLCW4bTb1vtxQe3CpS1M6Rcnf5JT/ylU52Fu9SB1K/te6GrhtaJtj93fqGsohmaJJQ6lu1A2i7bNLExdtE9tTOkXIrgYp2CEhCqb3qU6R4F3yzyKYfTBg37CeomLq5wS/5DXEXX/xLHfimdgAt/zF54hInMkU7R8ptA27QDrFdUkp9E/CSdoiorc9I9X/GjT1UO4fhDr/kR/7MrIEko9RedSvwDe0YUbuodfITTqRFO4fhOu0A/SWj1IEbSNETPF7NZNb+yhbmbwSdwF3aIfpLTqm96mZSdGxdntr6NCLjtHMYrvdLfq92iP6SU+rAt4DXtUOEbXU2u3rxqOajtXMYXgWu0Q6xs2SV2qtuAOZrxwjbuVNblyNiCy/q+7pf8tdrh9hZskoduBJ4QztEWDpzuRf95rwtJqjvRRpwKw1JLLVXfQ24VjtGWL6wW+tLiDRp5zBcrPHwu1okr9SBy4DN2iHqbVm+acXypiZ7fI6+pwnujWhIySy1V10D/Id2jHqbM7X1FUSS+f8sXs5ptDPe/SX5L8g3SNA94Y82Ny9bmcvZGW99t/klX3UNssEkt9TBXWZnAk47Sj3MnTp5oy3Mr24zMEc7xGCSW2oAr/o74LvaMUbq/tGj/vBKLjdDO4dhnl/yX9QOMZhklzrwRWJ+++iXp0xOxN5GzP2JmMwvSH6pg0tcZ2jHGK5fjB3zaDWbfZd2jpTrAk71S/4W7SC1SH6pAbzqIhr4EsSueK2TRmtnMMzxS/4T2iFqlY5SBz5PsORMbPx4/LjFmzIZW9VE10/8kv8t7RBDkZ5Se9UqcBoxORveC72XTmpp1c6Rcs8Bp2uHGKr0lBrAq94NdGjHqMX3CuMf7Mpk3q6dI8W6CY6jG27CxmDSVerA+TT4CqQ90DN/Yst07Rwpd55f8h/VDjEc6Su1V3XAp4Al2lEGcs3EwoM9Intr50ix2/2SH9spvOkrNWxfJeVDgPrTFHbWDV3fLUyw3W49zwP/VzvESKSz1LB90sdJQEMdM31j8sTFvSLTtHOk1EaC4+h12kFGIr2lhu0PAjiVYN1mdZtENv5ovC3Mr2QzcLJf8h/RDjJS6S41gFe9C/icdgyAr7VOetgW5lfRBXzYL/m/0Q5SD1ZqAK96LXCFZoRqRqp3jB1zmGaGlNpKsMvdUMv8joSV+k3nAj/VGvyC1smPI1LQGj+ltgEf90v+z7SD1JOVejuv2ktwfB35PeJrs5lX7h0z+siox025XqDkl/yGvmdhOKzU/XnVHuDTRDzF7ktTWpciMjbKMVPOAWf4JX+hdpAwiHOxuBU6el5hDvBfQKirjfw5l131gel7TEakOcxxzA7OjtskjaGwLfVAvOo3gU8SnEgJzblTW1dYoSOzDfhckgsNVupd86oLCe482xjGxz/XlHvh6XzelvyNxqvACX7Jv1o7SNis1IPxqncC7wXW1vuj50ydshKRXL0/1/yNx4EZjb4KaL1YqWvhVZcAs6jjveJL803LVzTlbCsdvluAmX7J79QOEhU7UTYUXmF3gtVJTxzpR50wfY+HVjXZOt4h2gbM9Uv+5dpBomalHg6vcBbBZa8xw/nxh0c1Lz1t2m52j3d41hLcJZaI2z6Hyna/h8Orfgs4HHh4OD/+xSmtiXvOVwPZfvycykKDlXr4vOqzwLHAvzOEWV73jR715Npc9ojQcqWXA75NcPzccPPko2S73/XgFY4GbgYGXdxg5tv2/MP6bPaQ8EOlyjMEd4jdrx2kEdiWuh686kPAocD1u3rbHWPHPGKFrqtugj2lQ63Qb7Itdb15hXZgPrBP/287cEfvPf2ZzZnMgTrBEude4F/9kv+0dpBGY6UOg1fIA2cDFwCTAH44ftziS1onvVs1VzI8T3Cp6jbtII3KSh0mr9ACfLkXzj5y771e7s7IftqRYmwjMA+4LC7PtNJipY7Ady+fPv3ySRPPJ3hCSF47T8ysA74DXOGX/FXKWWLBSh2htgVt04EywaNcbGbWrq0ArgRu9Ev+G7X+kIjsRbDQxe4ECyFc75y7st+/P4/gxqEpzrm638/fCKzUCtoWtO0BzAU+A9gSRjv6LXA58DO/5PcO9YclWF55mnPuMREZDzwKnOKcW9pX+BuAA4AjrNSm7toWtI0imNr5KeAEIK0ztrYCPwYur/ejbkRkEXC1c+5uEbkV+BqwCJhhpTahalvQNhX4OEHB07Kq6CqCXeWr/ZL/53p/uIgUCbb87wTeA8x2zp0jIp1YqU2U2ha0HUxQ7n8G9lSOU08OeAS4A7jDL/mPhTWQiIwD7gMuAe4EfgO83zlXtVIbNW0L2jLAbOAjwEzgIEJeMy0EbwD3EBS54pf8l8MeUESa+sa7yzn3TRFpA34FbOp7y3SCvYSjnHOh54malTpG2ha0tQDHEEwkORY4ChinmWkAzwE/JyjWvX7J74pqYBERYAHwmnPu3wZ4Tye2pTaNqG1BWxY4hDdLfixQjGh4B3QCS4FlfX8uBZZpPqhdRGYB9wM+wSUtgK84537e7z2dWKlNXLQtaBsLTOt77b7Tn/3/uZWBJ/RsIXga6HpgQ9+fawlmQ20v8DN+ybd54Q3ISp1SbQvacsB4grngO7yGc33YNA4rtTEJY/OpjUkYK7UxCWOlNiZhrNTGJIyV2piEsVIbkzBWamMSxkptTMJYqY1JGCu1MQljpTYmYazUxiSMldqYhLFSG5MwVmpjEsZKbUzCWKmNSRgrtTEJY6U2JmGs1MYkjJXamISxUhuTMFZqYxLGSm1MwlipjUkYK7UxCWOlNiZh/j8gxplF5wfuWQAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "dados['tempo'].value_counts().plot.pie()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Esses gráficos q tem nome de comida geralmente não são utilizados rs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:>"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX0AAAD7CAYAAACG50QgAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAAAT40lEQVR4nO3dcayd933X8fendpu5LaHJchMFXxd7yGw4kZrOl+ARCVjTLd6K4vwT4Y4tFkQYRYZ1Y4Cc8Uc1CYuABmORcCSrK3G2UcvLWmKGUma5rSZQiHvTBlw7NfHi1r7Ys+8K69wN3CX98sf5TRzZx/eemznnJPm9X9LR8zzf5/d7zu/qSJ/z3N95znlSVUiS+vCOaQ9AkjQ5hr4kdcTQl6SOGPqS1BFDX5I6YuhLUkdWT3sAy7nllltq/fr10x6GJL2lvPDCC79bVTNX1t/0ob9+/Xrm5+enPQxJektJ8vVRdad3JKkjhr4kdcTQl6SOGPqS1BFDX5I6YuhLUkcMfUnqiKEvSR150385a9LW7/6P0x7CG+Zrj31k2kOQNGWe6UtSRwx9SerIWKGf5KeTHE/ylSSfSvJdSW5OcjjJy21501D7R5OcSnIyyX1D9c1JjrV9jyfJG/FHSZJGWzb0k6wFfhKYq6o7gVXAdmA3cKSqNgJH2jZJNrX9dwBbgb1JVrXDPQHsBDa2x9br+tdIkpY07vTOamBNktXAu4FzwDZgf9u/H3igrW8DDlTV5ao6DZwC7k5yO3BjVT1XVQU8NdRHkjQBy4Z+Vf1P4OeBM8B54JtV9ZvAbVV1vrU5D9zauqwFzg4dYqHV1rb1K+tXSbIzyXyS+cXFxZX9RZKkaxpneucmBmfvG4A/A7wnyY8v1WVErZaoX12s2ldVc1U1NzNz1T0AJEmv0zjTOx8GTlfVYlX9EfBp4C8DF9qUDW15sbVfANYN9Z9lMB200NavrEuSJmSc0D8DbEny7na1zb3AS8AhYEdrswN4pq0fArYnuSHJBgYf2B5tU0CXkmxpx3loqI8kaQKW/UZuVT2f5GngS8CrwJeBfcB7gYNJHmbwxvBga388yUHgRGu/q6pea4d7BHgSWAM82x6SpAkZ62cYqurjwMevKF9mcNY/qv0eYM+I+jxw5wrHKI3l7fwTGuDPaOj68Ld3JL0p+KY9Gf4MgyR1xNCXpI4Y+pLUEUNfkjpi6EtSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOGPqS1BFDX5I6YuhLUkcMfUnqiKEvSR0Z58bo35vkxaHH7yf5qSQ3Jzmc5OW2vGmoz6NJTiU5meS+ofrmJMfavsfbbRMlSROybOhX1cmququq7gI2A38IfAbYDRypqo3AkbZNkk3AduAOYCuwN8mqdrgngJ0M7pu7se2XJE3ISqd37gV+u6q+DmwD9rf6fuCBtr4NOFBVl6vqNHAKuDvJ7cCNVfVcVRXw1FAfSdIErDT0twOfauu3VdV5gLa8tdXXAmeH+iy02tq2fmX9Kkl2JplPMr+4uLjCIUqSrmXs0E/yLuB+4NeWazqiVkvUry5W7auquaqam5mZGXeIkqRlrORM/0eAL1XVhbZ9oU3Z0JYXW30BWDfUbxY41+qzI+qSpAlZSeh/lP8/tQNwCNjR1ncAzwzVtye5IckGBh/YHm1TQJeSbGlX7Tw01EeSNAGrx2mU5N3ADwF/d6j8GHAwycPAGeBBgKo6nuQgcAJ4FdhVVa+1Po8ATwJrgGfbQ5I0IWOFflX9IfDdV9S+weBqnlHt9wB7RtTngTtXPkxJ0vXgN3IlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOGPqS1BFDX5I6YuhLUkcMfUnqiKEvSR0ZK/STvC/J00m+muSlJD+Q5OYkh5O83JY3DbV/NMmpJCeT3DdU35zkWNv3eLttoiRpQsY90/9F4LNV9X3AB4CXgN3AkaraCBxp2yTZBGwH7gC2AnuTrGrHeQLYyeC+uRvbfknShCwb+kluBP4K8EsAVfXtqvo9YBuwvzXbDzzQ1rcBB6rqclWdBk4Bdye5Hbixqp6rqgKeGuojSZqAcc70vwdYBP5tki8n+USS9wC3VdV5gLa8tbVfC5wd6r/Qamvb+pX1qyTZmWQ+yfzi4uKK/iBJ0rWNE/qrge8HnqiqDwJ/QJvKuYZR8/S1RP3qYtW+qpqrqrmZmZkxhihJGsc4ob8ALFTV8237aQZvAhfalA1teXGo/bqh/rPAuVafHVGXJE3IsqFfVb8DnE3yva10L3ACOATsaLUdwDNt/RCwPckNSTYw+MD2aJsCupRkS7tq56GhPpKkCVg9Zru/D/xqkncBrwB/i8EbxsEkDwNngAcBqup4koMM3hheBXZV1WvtOI8ATwJrgGfbQ5I0IWOFflW9CMyN2HXvNdrvAfaMqM8Dd65gfJKk68hv5EpSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOGPqS1BFDX5I6YuhLUkcMfUnqiKEvSR0x9CWpI4a+JHXE0Jekjhj6ktQRQ1+SOjJW6Cf5WpJjSV5MMt9qNyc5nOTltrxpqP2jSU4lOZnkvqH65nacU0keb7dNlCRNyErO9H+wqu6qqj++g9Zu4EhVbQSOtG2SbAK2A3cAW4G9SVa1Pk8AOxncN3dj2y9JmpA/yfTONmB/W98PPDBUP1BVl6vqNHAKuDvJ7cCNVfVcVRXw1FAfSdIEjBv6BfxmkheS7Gy126rqPEBb3trqa4GzQ30XWm1tW7+yLkmakLFujA7cU1XnktwKHE7y1SXajpqnryXqVx9g8MayE+D973//mEOUJC1nrDP9qjrXlheBzwB3AxfalA1tebE1XwDWDXWfBc61+uyI+qjn21dVc1U1NzMzM/5fI0la0rKhn+Q9Sf7UH68DPwx8BTgE7GjNdgDPtPVDwPYkNyTZwOAD26NtCuhSki3tqp2HhvpIkiZgnOmd24DPtKsrVwP/rqo+m+SLwMEkDwNngAcBqup4koPACeBVYFdVvdaO9QjwJLAGeLY9JEkTsmzoV9UrwAdG1L8B3HuNPnuAPSPq88CdKx+mJOl68Bu5ktQRQ1+SOmLoS1JHDH1J6oihL0kdMfQlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOjB36SVYl+XKS32jbNyc5nOTltrxpqO2jSU4lOZnkvqH65iTH2r7H220TJUkTspIz/Y8BLw1t7waOVNVG4EjbJskmYDtwB7AV2JtkVevzBLCTwX1zN7b9kqQJGSv0k8wCHwE+MVTeBuxv6/uBB4bqB6rqclWdBk4Bdye5Hbixqp6rqgKeGuojSZqAcc/0/zXwj4HvDNVuq6rzAG15a6uvBc4OtVtotbVt/cq6JGlClg39JH8duFhVL4x5zFHz9LVEfdRz7kwyn2R+cXFxzKeVJC1nnDP9e4D7k3wNOAB8KMmvABfalA1tebG1XwDWDfWfBc61+uyI+lWqal9VzVXV3MzMzAr+HEnSUpYN/ap6tKpmq2o9gw9oP1dVPw4cAna0ZjuAZ9r6IWB7khuSbGDwge3RNgV0KcmWdtXOQ0N9JEkTsPpP0Pcx4GCSh4EzwIMAVXU8yUHgBPAqsKuqXmt9HgGeBNYAz7aHJGlCVhT6VfUF4Att/RvAvddotwfYM6I+D9y50kFKkq4Pv5ErSR0x9CWpI4a+JHXE0Jekjhj6ktQRQ1+SOmLoS1JHDH1J6oihL0kdMfQlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSRwx9SerIODdG/64kR5P8tyTHk/xcq9+c5HCSl9vypqE+jyY5leRkkvuG6puTHGv7Hm+3TZQkTcg4Z/qXgQ9V1QeAu4CtSbYAu4EjVbURONK2SbKJwb107wC2AnuTrGrHegLYyeC+uRvbfknShIxzY/Sqqm+1zXe2RwHbgP2tvh94oK1vAw5U1eWqOg2cAu5OcjtwY1U9V1UFPDXUR5I0AWPN6SdZleRF4CJwuKqeB26rqvMAbXlra74WODvUfaHV1rb1K+uSpAkZK/Sr6rWquguYZXDWvtTNzUfN09cS9asPkOxMMp9kfnFxcZwhSpLGsKKrd6rq94AvMJiLv9CmbGjLi63ZArBuqNsscK7VZ0fURz3Pvqqaq6q5mZmZlQxRkrSEca7emUnyvra+Bvgw8FXgELCjNdsBPNPWDwHbk9yQZAODD2yPtimgS0m2tKt2HhrqI0magNVjtLkd2N+uwHkHcLCqfiPJc8DBJA8DZ4AHAarqeJKDwAngVWBXVb3WjvUI8CSwBni2PSRJE7Js6FfVfwc+OKL+DeDea/TZA+wZUZ8Hlvo8QJL0BvIbuZLUEUNfkjpi6EtSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOGPqS1BFDX5I6YuhLUkcMfUnqiKEvSR0x9CWpI4a+JHXE0Jekjoxzu8R1ST6f5KUkx5N8rNVvTnI4ycttedNQn0eTnEpyMsl9Q/XNSY61fY+32yZKkiZknDP9V4Gfqaq/AGwBdiXZBOwGjlTVRuBI26bt2w7cweAG6nvbrRYBngB2Mrhv7sa2X5I0IcuGflWdr6ovtfVLwEvAWmAbsL812w880Na3AQeq6nJVnQZOAXcnuR24saqeq6oCnhrqI0magBXN6SdZz+B+uc8Dt1XVeRi8MQC3tmZrgbND3RZabW1bv7IuSZqQsUM/yXuBXwd+qqp+f6mmI2q1RH3Uc+1MMp9kfnFxcdwhSpKWMVboJ3kng8D/1ar6dCtfaFM2tOXFVl8A1g11nwXOtfrsiPpVqmpfVc1V1dzMzMy4f4skaRnjXL0T4JeAl6rqXw3tOgTsaOs7gGeG6tuT3JBkA4MPbI+2KaBLSba0Yz401EeSNAGrx2hzD/ATwLEkL7bazwKPAQeTPAycAR4EqKrjSQ4CJxhc+bOrql5r/R4BngTWAM+2hyRpQpYN/ar6z4yejwe49xp99gB7RtTngTtXMkBJ0vXjN3IlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOGPqS1BFDX5I6YuhLUkcMfUnqiKEvSR0x9CWpI+PcI/eTSS4m+cpQ7eYkh5O83JY3De17NMmpJCeT3DdU35zkWNv3eLtPriRpgsY5038S2HpFbTdwpKo2AkfaNkk2AduBO1qfvUlWtT5PADsZ3Ch944hjSpLeYMuGflX9FvC/rihvA/a39f3AA0P1A1V1uapOA6eAu5PcDtxYVc9VVQFPDfWRJE3I653Tv62qzgO05a2tvhY4O9RuodXWtvUr6yMl2ZlkPsn84uLi6xyiJOlK1/uD3FHz9LVEfaSq2ldVc1U1NzMzc90GJ0m9e72hf6FN2dCWF1t9AVg31G4WONfqsyPqkqQJer2hfwjY0dZ3AM8M1bcnuSHJBgYf2B5tU0CXkmxpV+08NNRHkjQhq5drkORTwF8DbkmyAHwceAw4mORh4AzwIEBVHU9yEDgBvArsqqrX2qEeYXAl0Brg2faQJE3QsqFfVR+9xq57r9F+D7BnRH0euHNFo5MkXVd+I1eSOmLoS1JHDH1J6oihL0kdMfQlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOGPqS1JGJh36SrUlOJjmVZPekn1+SejbR0E+yCvg3wI8Am4CPJtk0yTFIUs8mfaZ/N3Cqql6pqm8DB4BtEx6DJHVr2XvkXmdrgbND2wvAX7qyUZKdwM62+a0kJycwtmm5BfjdSTxR/vkknqUrE3vtwNfvDfB2f/3+7KjipEM/I2p1VaFqH7DvjR/O9CWZr6q5aY9DK+dr99bW6+s36emdBWDd0PYscG7CY5Ckbk069L8IbEyyIcm7gO3AoQmPQZK6NdHpnap6NcnfA/4TsAr4ZFUdn+QY3oS6mMZ6m/K1e2vr8vVL1VVT6pKktym/kStJHTH0Jakjhr4kdcTQl9SdJLdOewzTYuhPSJK5JJ9P8itJ1iU5nOSbSb6Y5IPTHp+WluTGJP8syS8n+bEr9u2d1ri0vCQ3X/H4buBokpuS3Dzt8U2aV+9MSJKjwMeB9wH/Avjpqno6yb3AP62qH5jm+LS0JL8OvAz8V+BvA38E/FhVXU7ypar6/qkOUNeU5DvA168ozzL4smhV1fdMflTTY+hPSJIvV9UH2/qZqnr/qH16c0ryYlXdNbT9T4AfBe4HDhv6b15J/iHwYeAfVdWxVjtdVRumO7LpmPRv7/Ts/yb5YeBPA5Xkgar690n+KvDalMem5d2Q5B1V9R2AqtqTZAH4LeC90x2allJVP5/kAPALSc4y+I+727Nd5/Qn5xHgZxhMDdwH/GCS/w3sBT42zYFpLP8B+NBwoar2M3hNvz2VEWlsVbVQVQ8CnwcOA++e8pCmxumdKUryy1X1E9Meh5aX5CeBz1TV2WUb600nyfcx+Gn35xn8Z/3nquorSbZW1WenO7rJMvQnJMmoH5b7EPA5gKq6f7Ij0kok+SbwB8BvA58Cfq2qFqc7Ko2jvWHvAl4C7gI+VlXPtH3dfQjvnP7krAOOA59gMJ8Y4C8C/3Kag9LYXgE2M/hA8G8AP5fkBQZvAJ+uqkvTHJyW9HeAzVX1rSTrgaeTrK+qX2T0PT7e1jzTn5Ak72Awd/+jDK4ieDHJK71dLvZWdeUZYZJ3MrjX80eBD1fVzNQGpyUlOVFVm4a23ws8DZwAPjR8VVYPDP0JSzIL/AJwAbh/+NJNvXktdVltkjVV9X8mPSaNJ8nngH9QVS8O1VYDnwT+ZlWtmtbYpsHQn5IkHwHuqaqfnfZYtLwkf76q/se0x6GVaydar1bV74zYd09V/ZcpDGtqDH1J6ojX6UtSRwx9SeqIoS9JHTH0Jakjhr4kdeT/AWdy4vJ9NQFMAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "#Vamos fazer outro gráfico simples mas q é útil\n",
    "dados['tempo'].value_counts().plot.bar()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Guilherme comentou que, como os valores parecem estar normalizados, ele olharia em quais linhas esses valores\n",
    "#estão acima de 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [
    {
     "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>...</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>...</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>...</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>...</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>...</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>...</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      droga     g-0     g-1     g-2  \\\n",
       "0  id_000644bb2  com_droga     24   D1  b68db1d53  1.0620  0.5577 -0.2479   \n",
       "1  id_000779bfc  com_droga     72   D1  df89a8e5a  0.0743  0.4087  0.2991   \n",
       "2  id_000a6266a  com_droga     48   D1  18bb41b2c  0.6280  0.5817  1.5540   \n",
       "6  id_001bd861f  com_droga     24   D2  746ca1f5a  2.0440  1.7000 -1.5390   \n",
       "7  id_0020d0484  com_droga     48   D1  8b87a7a83  0.2711  0.5133 -0.1327   \n",
       "\n",
       "      g-3     g-4  ...    c-90    c-91    c-92    c-93    c-94    c-95  \\\n",
       "0 -0.6208 -0.1944  ...  0.2862  0.2584  0.8076  0.5523 -0.1912  0.6584   \n",
       "1  0.0604  1.0190  ... -0.4265  0.7543  0.4708  0.0230  0.2957  0.4899   \n",
       "2 -0.0764 -0.0323  ... -0.7250 -0.6297  0.6103  0.0223 -1.3240 -0.3174   \n",
       "6  5.9440 -2.1670  ...  0.1855  1.1720  0.8325  0.6486  0.8090  1.5880   \n",
       "7  2.5950  0.6980  ...  0.3230 -0.4140  0.2532  0.0513  0.8600  1.4250   \n",
       "\n",
       "     c-96    c-97    c-98    c-99  \n",
       "0 -0.3981  0.2139  0.3801  0.4176  \n",
       "1  0.1522  0.1241  0.6077  0.7371  \n",
       "2 -0.6417 -0.2187 -1.4080  0.6931  \n",
       "6  2.4670  0.0357  0.1351 -0.3179  \n",
       "7  0.6633  0.4562 -0.9622  0.0260  \n",
       "\n",
       "[5 rows x 877 columns]"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "g0maior0 = dados[dados['g-0'] > 0]\n",
    "g0maior0.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Desafio 5: Procurar na documentação o método query(pandas)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [
    {
     "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>...</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>...</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>...</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>...</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>...</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>...</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",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </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>...</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>...</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>...</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>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>...</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>...</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",
       "  </tbody>\n",
       "</table>\n",
       "<p>11769 rows × 877 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 id    tratamento  tempo dose      droga     g-0     g-1  \\\n",
       "0      id_000644bb2     com_droga     24   D1  b68db1d53  1.0620  0.5577   \n",
       "1      id_000779bfc     com_droga     72   D1  df89a8e5a  0.0743  0.4087   \n",
       "2      id_000a6266a     com_droga     48   D1  18bb41b2c  0.6280  0.5817   \n",
       "6      id_001bd861f     com_droga     24   D2  746ca1f5a  2.0440  1.7000   \n",
       "7      id_0020d0484     com_droga     48   D1  8b87a7a83  0.2711  0.5133   \n",
       "...             ...           ...    ...  ...        ...     ...     ...   \n",
       "23807  id_fff7e6992     com_droga     48   D1  a28556d51  0.1420 -0.3696   \n",
       "23808  id_fff8c2444     com_droga     72   D1  6c3a459be  0.1608 -1.0500   \n",
       "23809  id_fffb1ceed     com_droga     24   D2  df1d0a5a1  0.1394 -0.0636   \n",
       "23811  id_fffc1c3f4  com_controle     48   D2  cacb2b860  0.3942  0.3756   \n",
       "23812  id_fffcb9e7c     com_droga     24   D1  8b87a7a83  0.6660  0.2324   \n",
       "\n",
       "          g-2     g-3     g-4  ...    c-90    c-91    c-92    c-93    c-94  \\\n",
       "0     -0.2479 -0.6208 -0.1944  ...  0.2862  0.2584  0.8076  0.5523 -0.1912   \n",
       "1      0.2991  0.0604  1.0190  ... -0.4265  0.7543  0.4708  0.0230  0.2957   \n",
       "2      1.5540 -0.0764 -0.0323  ... -0.7250 -0.6297  0.6103  0.0223 -1.3240   \n",
       "6     -1.5390  5.9440 -2.1670  ...  0.1855  1.1720  0.8325  0.6486  0.8090   \n",
       "7     -0.1327  2.5950  0.6980  ...  0.3230 -0.4140  0.2532  0.0513  0.8600   \n",
       "...       ...     ...     ...  ...     ...     ...     ...     ...     ...   \n",
       "23807 -0.0093 -0.2495 -0.0175  ...  0.8775  0.5230  0.1589  0.7715  0.5497   \n",
       "23808  0.2551 -0.2239 -0.2431  ...  0.0789  0.3538  0.0558  0.3377 -0.4753   \n",
       "23809 -0.1112 -0.5080 -0.4713  ...  0.1969  0.0262 -0.8121  0.3434  0.5372   \n",
       "23811  0.3109 -0.7389  0.5505  ...  0.5409  0.3755  0.7343  0.2807  0.4116   \n",
       "23812  0.4392  0.2044  0.8531  ... -0.1105  0.4258 -0.2012  0.1506  1.5230   \n",
       "\n",
       "         c-95    c-96    c-97    c-98    c-99  \n",
       "0      0.6584 -0.3981  0.2139  0.3801  0.4176  \n",
       "1      0.4899  0.1522  0.1241  0.6077  0.7371  \n",
       "2     -0.3174 -0.6417 -0.2187 -1.4080  0.6931  \n",
       "6      1.5880  2.4670  0.0357  0.1351 -0.3179  \n",
       "7      1.4250  0.6633  0.4562 -0.9622  0.0260  \n",
       "...       ...     ...     ...     ...     ...  \n",
       "23807  0.6929  0.3738  0.8636  0.4494  0.1218  \n",
       "23808 -0.2504 -0.7415  0.8413 -0.4259  0.2434  \n",
       "23809 -0.3246  0.0631  0.9171  0.5258  0.4680  \n",
       "23811  0.6422  0.2256  0.7592  0.6656  0.3808  \n",
       "23812  0.7101  0.1732  0.7015 -0.6290  0.0740  \n",
       "\n",
       "[11769 rows x 877 columns]"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#no caso poderiamos ter feito a operação previa da seguinte forma:\n",
    "dados.query('`g-0` > 0') #só vem"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Desafio 6: Colocar título no gráfico:\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:title={'center':'Time'}>"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX0AAAELCAYAAAA1AlaNAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAAAVLklEQVR4nO3dcaydd33f8fcnNqQG5uI0N1Fqm9nt3HZOJELtZe6Q1pZkxJQW559opmtjbelcRdkKXbcp6f5gnWotm9qxRmqiWcDiQIdlUli8TgE8A+o2ZZgbyGbs4MUlEN/atS+spYZ2Bpvv/jg/tCP7+N5zqX1O4Pd+SUfP83yf3+85v6Mrf87j33nOeVJVSJL6cM20ByBJmhxDX5I6YuhLUkcMfUnqiKEvSR0x9CWpI4a+tIAkR5L8xLTHIV0py6c9AGmaknx1aPMVwDngQtv+xaq6efKjkq6e+OUsaSDJF4BfqKr/Mu2xSFeL0zvSApJ8Ickdbf2fJ/lAkvclOZvkcJIfSvJgkjNJTiR541Df703y7iSnkvxhkl9Psmx6r0Yy9KWl+hngvcAq4DPARxj8O1oN/Avg3w213QOcB/4K8DrgjcAvTHKw0sUMfWlp/mtVfaSqzgMfAGaAh6rqG8BeYF2SVye5EXgT8Paq+lpVnQHeCWyf2sgl/CBXWqrTQ+t/Dnypqi4MbQO8Cvh+4GXAqSTfan8NcGISg5Qux9CXro4TDK4Eur79r0B6SXB6R7oKquoU8FHgN5OsTHJNkh9M8uPTHpv6ZuhLV889wMuBo8AfA08AN011ROqe1+lLUkc805ekjhj6ktQRQ1+SOmLoS1JHDH1J6shL/stZ119/fa1bt27aw5Ck7yjPPPPMl6pq5uL6Sz70161bx+zs7LSHIUnfUZJ8cVTd6R1J6oihL0kdMfQlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSR17yX86atHUP/OdpD+Gq+cJDb572ECRNmWf6ktQRQ1+SOjJW6Cf55SRHknw2yfuTfE+S65IcSPJ8W64aav9gkuNJjiW5c6i+Kcnhtu/hJLkaL0qSNNqioZ9kNfBLwOaqugVYBmwHHgAOVtUG4GDbJsnGtv9mYCvwSJJl7XCPAjuBDe2x9Yq+GknSgsad3lkOrEiyHHgFcBLYBuxp+/cAd7X1bcDeqjpXVS8Ax4HbktwErKyqp2twN/bHh/pIkiZg0dCvqj8EfgN4ETgFfKWqPgrcWFWnWptTwA2ty2rgxNAh5lptdVu/uH6JJDuTzCaZnZ+fX9orkiRd1jjTO6sYnL2vB74feGWSn1uoy4haLVC/tFi1u6o2V9XmmZlL7gEgSfo2jTO9cwfwQlXNV9U3gA8CfwM43aZsaMszrf0csHao/xoG00Fzbf3iuiRpQsYJ/ReBLUle0a62uR14DtgP7GhtdgBPtvX9wPYk1yZZz+AD20NtCuhski3tOPcM9ZEkTcCi38itqk8meQL4NHAe+AywG3gVsC/JvQzeGO5u7Y8k2Qccbe3vr6oL7XD3AY8BK4Cn2kOSNCFj/QxDVb0DeMdF5XMMzvpHtd8F7BpRnwVuWeIYpbF8N/+EBvgzGroy/O0dSS8JvmlPhj/DIEkdMfQlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOGPqS1BFDX5I6YuhLUkfGuTH6Dyd5dujxp0nenuS6JAeSPN+Wq4b6PJjkeJJjSe4cqm9Kcrjte7jdNlGSNCGLhn5VHauqW6vqVmAT8GfAh4AHgINVtQE42LZJshHYDtwMbAUeSbKsHe5RYCeD++ZuaPslSROy1Omd24E/qKovAtuAPa2+B7irrW8D9lbVuap6ATgO3JbkJmBlVT1dVQU8PtRHkjQBSw397cD72/qNVXUKoC1vaPXVwImhPnOttrqtX1y/RJKdSWaTzM7Pzy9xiJKkyxk79JO8HHgL8IHFmo6o1QL1S4tVu6tqc1VtnpmZGXeIkqRFLOVM/03Ap6vqdNs+3aZsaMszrT4HrB3qtwY42eprRtQlSROylNB/K/9/agdgP7Cjre8Anhyqb09ybZL1DD6wPdSmgM4m2dKu2rlnqI8kaQKWj9MoySuAvwX84lD5IWBfknuBF4G7AarqSJJ9wFHgPHB/VV1ofe4DHgNWAE+1hyRpQsYK/ar6M+D7Lqp9mcHVPKPa7wJ2jajPArcsfZiSpCvBb+RKUkcMfUnqiKEvSR0x9CWpI4a+JHXE0Jekjhj6ktQRQ1+SOmLoS1JHDH1J6oihL0kdMfQlqSOGviR1xNCXpI4Y+pLUEUNfkjoyVugneXWSJ5J8LslzSX4syXVJDiR5vi1XDbV/MMnxJMeS3DlU35TkcNv3cLttoiRpQsY90/8t4MNV9SPAa4HngAeAg1W1ATjYtkmyEdgO3AxsBR5Jsqwd51FgJ4P75m5o+yVJE7Jo6CdZCfxN4N0AVfX1qvoTYBuwpzXbA9zV1rcBe6vqXFW9ABwHbktyE7Cyqp6uqgIeH+ojSZqAcc70fwCYB/59ks8keVeSVwI3VtUpgLa8obVfDZwY6j/Xaqvb+sX1SyTZmWQ2yez8/PySXpAk6fLGCf3lwI8Cj1bV64Cv0aZyLmPUPH0tUL+0WLW7qjZX1eaZmZkxhihJGsc4oT8HzFXVJ9v2EwzeBE63KRva8sxQ+7VD/dcAJ1t9zYi6JGlCFg39qvoj4ESSH26l24GjwH5gR6vtAJ5s6/uB7UmuTbKewQe2h9oU0NkkW9pVO/cM9ZEkTcDyMdv9Q+B3krwc+Dzwdxm8YexLci/wInA3QFUdSbKPwRvDeeD+qrrQjnMf8BiwAniqPSRJEzJW6FfVs8DmEbtuv0z7XcCuEfVZ4JYljE+SdAX5jVxJ6oihL0kdMfQlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOGPqS1BFDX5I6YuhLUkfGCv0kX0hyOMmzSWZb7bokB5I835arhto/mOR4kmNJ7hyqb2rHOZ7k4XbbREnShCzlTP8nq+rWqvrWHbQeAA5W1QbgYNsmyUZgO3AzsBV4JMmy1udRYCeD++ZuaPslSRPyF5ne2Qbsaet7gLuG6nur6lxVvQAcB25LchOwsqqerqoCHh/qI0magHFDv4CPJnkmyc5Wu7GqTgG05Q2tvho4MdR3rtVWt/WL65KkCRnrxujA66vqZJIbgANJPrdA21Hz9LVA/dIDDN5YdgK85jWvGXOIkqTFjHWmX1Un2/IM8CHgNuB0m7KhLc+05nPA2qHua4CTrb5mRH3U8+2uqs1VtXlmZmb8VyNJWtCioZ/klUn+0rfWgTcCnwX2Aztasx3Ak219P7A9ybVJ1jP4wPZQmwI6m2RLu2rnnqE+kqQJGGd650bgQ+3qyuXAf6iqDyf5FLAvyb3Ai8DdAFV1JMk+4ChwHri/qi60Y90HPAasAJ5qD0nShCwa+lX1eeC1I+pfBm6/TJ9dwK4R9VnglqUPU5J0JfiNXEnqiKEvSR0x9CWpI4a+JHXE0Jekjhj6ktQRQ1+SOmLoS1JHDH1J6oihL0kdMfQlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSR8YO/STLknwmye+17euSHEjyfFuuGmr7YJLjSY4luXOovinJ4bbv4XbbREnShCzlTP9twHND2w8AB6tqA3CwbZNkI7AduBnYCjySZFnr8yiwk8F9cze0/ZKkCRkr9JOsAd4MvGuovA3Y09b3AHcN1fdW1bmqegE4DtyW5CZgZVU9XVUFPD7UR5I0AeOe6f9b4J8C3xyq3VhVpwDa8oZWXw2cGGo312qr2/rFdUnShCwa+kl+GjhTVc+MecxR8/S1QH3Uc+5MMptkdn5+fsynlSQtZpwz/dcDb0nyBWAv8IYk7wNOtykb2vJMaz8HrB3qvwY42eprRtQvUVW7q2pzVW2emZlZwsuRJC1k0dCvqgerak1VrWPwAe3HqurngP3AjtZsB/BkW98PbE9ybZL1DD6wPdSmgM4m2dKu2rlnqI8kaQKW/wX6PgTsS3Iv8CJwN0BVHUmyDzgKnAfur6oLrc99wGPACuCp9pAkTciSQr+qPgF8oq1/Gbj9Mu12AbtG1GeBW5Y6SEnSleE3ciWpI4a+JHXE0Jekjhj6ktQRQ1+SOmLoS1JHDH1J6oihL0kdMfQlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSRwx9SeqIoS9JHRnnxujfk+RQkv+Z5EiSX2v165IcSPJ8W64a6vNgkuNJjiW5c6i+Kcnhtu/hdttESdKEjHOmfw54Q1W9FrgV2JpkC/AAcLCqNgAH2zZJNjK4l+7NwFbgkSTL2rEeBXYyuG/uhrZfkjQh49wYvarqq23zZe1RwDZgT6vvAe5q69uAvVV1rqpeAI4DtyW5CVhZVU9XVQGPD/WRJE3AWHP6SZYleRY4Axyoqk8CN1bVKYC2vKE1Xw2cGOo+12qr2/rFdUnShIwV+lV1oapuBdYwOGtf6Obmo+bpa4H6pQdIdiaZTTI7Pz8/zhAlSWNY0tU7VfUnwCcYzMWfblM2tOWZ1mwOWDvUbQ1wstXXjKiPep7dVbW5qjbPzMwsZYiSpAWMc/XOTJJXt/UVwB3A54D9wI7WbAfwZFvfD2xPcm2S9Qw+sD3UpoDOJtnSrtq5Z6iPJGkClo/R5iZgT7sC5xpgX1X9XpKngX1J7gVeBO4GqKojSfYBR4HzwP1VdaEd6z7gMWAF8FR7SJImZNHQr6r/BbxuRP3LwO2X6bML2DWiPgss9HmAJOkq8hu5ktQRQ1+SOmLoS1JHDH1J6oihL0kdMfQlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOjHO7xLVJPp7kuSRHkryt1a9LciDJ8225aqjPg0mOJzmW5M6h+qYkh9u+h9ttEyVJEzLOmf554Feq6q8CW4D7k2wEHgAOVtUG4GDbpu3bDtzM4Abqj7RbLQI8CuxkcN/cDW2/JGlCFg39qjpVVZ9u62eB54DVwDZgT2u2B7irrW8D9lbVuap6ATgO3JbkJmBlVT1dVQU8PtRHkjQBS5rTT7KOwf1yPwncWFWnYPDGANzQmq0GTgx1m2u11W394rokaULGDv0krwJ+F3h7Vf3pQk1H1GqB+qjn2plkNsns/Pz8uEOUJC1irNBP8jIGgf87VfXBVj7dpmxoyzOtPgesHeq+BjjZ6mtG1C9RVburanNVbZ6ZmRn3tUiSFjHO1TsB3g08V1X/ZmjXfmBHW98BPDlU357k2iTrGXxge6hNAZ1NsqUd856hPpKkCVg+RpvXAz8PHE7ybKv9KvAQsC/JvcCLwN0AVXUkyT7gKIMrf+6vqgut333AY8AK4Kn2kCRNyKKhX1X/jdHz8QC3X6bPLmDXiPoscMtSBihJunL8Rq4kdcTQl6SOGPqS1BFDX5I6YuhLUkcMfUnqiKEvSR0x9CWpI4a+JHXE0Jekjhj6ktQRQ1+SOmLoS1JHDH1J6oihL0kdMfQlqSOGviR1ZJx75L4nyZkknx2qXZfkQJLn23LV0L4HkxxPcizJnUP1TUkOt30Pt/vkSpImaJwz/ceArRfVHgAOVtUG4GDbJslGYDtwc+vzSJJlrc+jwE4GN0rfMOKYkqSrbNHQr6rfB/7PReVtwJ62vge4a6i+t6rOVdULwHHgtiQ3ASur6umqKuDxoT6SpAn5duf0b6yqUwBteUOrrwZODLWba7XVbf3i+khJdiaZTTI7Pz//bQ5RknSxK/1B7qh5+lqgPlJV7a6qzVW1eWZm5ooNTpJ69+2G/uk2ZUNbnmn1OWDtULs1wMlWXzOiLkmaoG839PcDO9r6DuDJofr2JNcmWc/gA9tDbQrobJIt7aqde4b6SJImZPliDZK8H/gJ4Pokc8A7gIeAfUnuBV4E7gaoqiNJ9gFHgfPA/VV1oR3qPgZXAq0AnmoPSdIELRr6VfXWy+y6/TLtdwG7RtRngVuWNDpJ0hXlN3IlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOGPqS1BFDX5I6YuhLUkcMfUnqiKEvSR2ZeOgn2ZrkWJLjSR6Y9PNLUs8mGvpJlgG/DbwJ2Ai8NcnGSY5Bkno26TP924DjVfX5qvo6sBfYNuExSFK3Fr1H7hW2GjgxtD0H/PWLGyXZCexsm19NcmwCY5uW64EvTeKJ8q8m8SxdmdjfDvz7XQXf7X+/vzyqOOnQz4haXVKo2g3svvrDmb4ks1W1edrj0NL5t/vO1uvfb9LTO3PA2qHtNcDJCY9Bkro16dD/FLAhyfokLwe2A/snPAZJ6tZEp3eq6nySfwB8BFgGvKeqjkxyDC9BXUxjfZfyb/edrcu/X6oumVKXJH2X8hu5ktQRQ1+SOmLoS1JHDH1J3Ulyw7THMC2G/oQk2Zzk40nel2RtkgNJvpLkU0leN+3xaWFJVib5l0nem+RnL9r3yLTGpcUlue6ix/cBh5KsSnLdtMc3aV69MyFJDgHvAF4N/Gvgl6vqiSS3A79eVT82zfFpYUl+F3ge+B/A3wO+AfxsVZ1L8umq+tGpDlCXleSbwBcvKq9h8GXRqqofmPyopsfQn5Akn6mq17X1F6vqNaP26aUpybNVdevQ9j8Dfgp4C3DA0H/pSvKPgTuAf1JVh1vthapaP92RTcekf3unZ/83yRuB7wUqyV1V9R+T/DhwYcpj0+KuTXJNVX0ToKp2JZkDfh941XSHpoVU1W8k2Qu8M8kJBv/j7vZs1zn9ybkP+BUGUwN3Aj+Z5I+BR4C3TXNgGst/At4wXKiqPQz+pl+fyog0tqqaq6q7gY8DB4BXTHlIU+P0zhQleW9V/fy0x6HFJfkl4ENVdWLRxnrJSfIjDH7a/ZMM/mf9g1X12SRbq+rD0x3dZBn6E5Jk1A/LvQH4GEBVvWWyI9JSJPkK8DXgD4D3Ax+oqvnpjkrjaG/Y9wPPAbcCb6uqJ9u+7j6Ed05/ctYCR4B3MZhPDPDXgN+c5qA0ts8Dmxh8IPi3gV9L8gyDN4APVtXZaQ5OC/r7wKaq+mqSdcATSdZV1W8x+h4f39U805+QJNcwmLv/KQZXETyb5PO9XS72neriM8IkL2Nwr+e3AndU1czUBqcFJTlaVRuHtl8FPAEcBd4wfFVWDwz9CUuyBngncBp4y/Clm3rpWuiy2iQrqurPJz0mjSfJx4B/VFXPDtWWA+8B/k5VLZvW2KbB0J+SJG8GXl9VvzrtsWhxSX6oqv73tMehpWsnWuer6o9G7Ht9Vf33KQxragx9SeqI1+lLUkcMfUnqiKEvSR0x9CWpI4a+JHXk/wFckjcULr303AAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "dados['tempo'].value_counts().plot.bar(title = 'Time')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 178,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Desafio 7: Renomear as colunas tirando o hífen.\n",
    "#uma só:\n",
    "newdf = dados.rename(columns={'g-0':'g0'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 176,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Todas\n",
    "colunas = []\n",
    "dados2 = dados\n",
    "for i in dados2.columns:\n",
    "    i = i.replace('-', '')\n",
    "    colunas.append(i)\n",
    "dados2.columns = colunas    \n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 177,
   "metadata": {},
   "outputs": [
    {
     "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>...</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>...</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>...</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>...</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>...</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>...</td>\n",
       "      <td>0.0042</td>\n",
       "      <td>0.0048</td>\n",
       "      <td>0.6670</td>\n",
       "      <td>1.0690</td>\n",
       "      <td>0.5523</td>\n",
       "      <td>-0.3031</td>\n",
       "      <td>0.1094</td>\n",
       "      <td>0.2885</td>\n",
       "      <td>-0.3786</td>\n",
       "      <td>0.7125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </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>...</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>...</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>...</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>...</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>...</td>\n",
       "      <td>-3.3890</td>\n",
       "      <td>-1.7450</td>\n",
       "      <td>-6.6300</td>\n",
       "      <td>-4.0950</td>\n",
       "      <td>-7.3860</td>\n",
       "      <td>-1.4160</td>\n",
       "      <td>-3.5770</td>\n",
       "      <td>-0.4775</td>\n",
       "      <td>-2.1500</td>\n",
       "      <td>-4.2520</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>23814 rows × 877 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 id    tratamento  tempo dose      droga      g0      g1  \\\n",
       "0      id_000644bb2     com_droga     24   D1  b68db1d53  1.0620  0.5577   \n",
       "1      id_000779bfc     com_droga     72   D1  df89a8e5a  0.0743  0.4087   \n",
       "2      id_000a6266a     com_droga     48   D1  18bb41b2c  0.6280  0.5817   \n",
       "3      id_0015fd391     com_droga     48   D1  8c7f86626 -0.5138 -0.2491   \n",
       "4      id_001626bd3     com_droga     72   D2  7cbed3131 -0.3254 -0.4009   \n",
       "...             ...           ...    ...  ...        ...     ...     ...   \n",
       "23809  id_fffb1ceed     com_droga     24   D2  df1d0a5a1  0.1394 -0.0636   \n",
       "23810  id_fffb70c0c     com_droga     24   D2  ecf3b6b74 -1.3260  0.3478   \n",
       "23811  id_fffc1c3f4  com_controle     48   D2  cacb2b860  0.3942  0.3756   \n",
       "23812  id_fffcb9e7c     com_droga     24   D1  8b87a7a83  0.6660  0.2324   \n",
       "23813  id_ffffdd77b     com_droga     72   D1  972f41291 -0.8598  1.0240   \n",
       "\n",
       "           g2      g3      g4  ...     c90     c91     c92     c93     c94  \\\n",
       "0     -0.2479 -0.6208 -0.1944  ...  0.2862  0.2584  0.8076  0.5523 -0.1912   \n",
       "1      0.2991  0.0604  1.0190  ... -0.4265  0.7543  0.4708  0.0230  0.2957   \n",
       "2      1.5540 -0.0764 -0.0323  ... -0.7250 -0.6297  0.6103  0.0223 -1.3240   \n",
       "3     -0.2656  0.5288  4.0620  ... -2.0990 -0.6441 -5.6300 -1.3780 -0.8632   \n",
       "4      0.9700  0.6919  1.4180  ...  0.0042  0.0048  0.6670  1.0690  0.5523   \n",
       "...       ...     ...     ...  ...     ...     ...     ...     ...     ...   \n",
       "23809 -0.1112 -0.5080 -0.4713  ...  0.1969  0.0262 -0.8121  0.3434  0.5372   \n",
       "23810 -0.3743  0.9905 -0.7178  ...  0.4286  0.4426  0.0423 -0.3195 -0.8086   \n",
       "23811  0.3109 -0.7389  0.5505  ...  0.5409  0.3755  0.7343  0.2807  0.4116   \n",
       "23812  0.4392  0.2044  0.8531  ... -0.1105  0.4258 -0.2012  0.1506  1.5230   \n",
       "23813 -0.1361  0.7952 -0.3611  ... -3.3890 -1.7450 -6.6300 -4.0950 -7.3860   \n",
       "\n",
       "          c95     c96     c97     c98     c99  \n",
       "0      0.6584 -0.3981  0.2139  0.3801  0.4176  \n",
       "1      0.4899  0.1522  0.1241  0.6077  0.7371  \n",
       "2     -0.3174 -0.6417 -0.2187 -1.4080  0.6931  \n",
       "3     -1.2880 -1.6210 -0.8784 -0.3876 -0.8154  \n",
       "4     -0.3031  0.1094  0.2885 -0.3786  0.7125  \n",
       "...       ...     ...     ...     ...     ...  \n",
       "23809 -0.3246  0.0631  0.9171  0.5258  0.4680  \n",
       "23810 -0.9798 -0.2084 -0.1224 -0.2715  0.3689  \n",
       "23811  0.6422  0.2256  0.7592  0.6656  0.3808  \n",
       "23812  0.7101  0.1732  0.7015 -0.6290  0.0740  \n",
       "23813 -1.4160 -3.5770 -0.4775 -2.1500 -4.2520  \n",
       "\n",
       "[23814 rows x 877 columns]"
      ]
     },
     "execution_count": 177,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados2 #SOU UM GÊNIO"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#desafio 8: Resumo do que você aprendeu"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}