criar_bd_sql.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# ! pip install -q ipython-sql"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import sqlite3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "## Carregar arquivo original e armazenar em um dataframe\n",
    "df = pd.read_csv('database/diabetes.csv', sep=',')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>Pregnancies</th>\n",
       "      <th>Glucose</th>\n",
       "      <th>BloodPressure</th>\n",
       "      <th>SkinThickness</th>\n",
       "      <th>Insulin</th>\n",
       "      <th>BMI</th>\n",
       "      <th>DiabetesPedigreeFunction</th>\n",
       "      <th>Age</th>\n",
       "      <th>Outcome</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>6</td>\n",
       "      <td>148</td>\n",
       "      <td>72</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>33.6</td>\n",
       "      <td>0.627</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>85</td>\n",
       "      <td>66</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>26.6</td>\n",
       "      <td>0.351</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>8</td>\n",
       "      <td>183</td>\n",
       "      <td>64</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>23.3</td>\n",
       "      <td>0.672</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>89</td>\n",
       "      <td>66</td>\n",
       "      <td>23</td>\n",
       "      <td>94</td>\n",
       "      <td>28.1</td>\n",
       "      <td>0.167</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>137</td>\n",
       "      <td>40</td>\n",
       "      <td>35</td>\n",
       "      <td>168</td>\n",
       "      <td>43.1</td>\n",
       "      <td>2.288</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Pregnancies  Glucose  BloodPressure  SkinThickness  Insulin   BMI  \\\n",
       "0            6      148             72             35        0  33.6   \n",
       "1            1       85             66             29        0  26.6   \n",
       "2            8      183             64              0        0  23.3   \n",
       "3            1       89             66             23       94  28.1   \n",
       "4            0      137             40             35      168  43.1   \n",
       "\n",
       "   DiabetesPedigreeFunction  Age  Outcome  \n",
       "0                     0.627   50        1  \n",
       "1                     0.351   31        0  \n",
       "2                     0.672   32        1  \n",
       "3                     0.167   21        0  \n",
       "4                     2.288   33        1  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(768, 9)"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "# criar conexao com o banco de dados\n",
    "cnn = sqlite3.connect('database/pacientes.db')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "768"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# criar tabela no banco de dados\n",
    "df.to_sql('diabetes', cnn, if_exists='replace', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "%load_ext sql # carregar extensao sql"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "%sql sqlite:///database/pacientes.db # conectar ao banco de dados"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///database/pacientes.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>Pregnancies</th>\n",
       "        <th>Glucose</th>\n",
       "        <th>BloodPressure</th>\n",
       "        <th>SkinThickness</th>\n",
       "        <th>Insulin</th>\n",
       "        <th>BMI</th>\n",
       "        <th>DiabetesPedigreeFunction</th>\n",
       "        <th>Age</th>\n",
       "        <th>Outcome</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>148</td>\n",
       "        <td>72</td>\n",
       "        <td>35</td>\n",
       "        <td>0</td>\n",
       "        <td>33.6</td>\n",
       "        <td>0.627</td>\n",
       "        <td>50</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>85</td>\n",
       "        <td>66</td>\n",
       "        <td>29</td>\n",
       "        <td>0</td>\n",
       "        <td>26.6</td>\n",
       "        <td>0.351</td>\n",
       "        <td>31</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>183</td>\n",
       "        <td>64</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>23.3</td>\n",
       "        <td>0.672</td>\n",
       "        <td>32</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>89</td>\n",
       "        <td>66</td>\n",
       "        <td>23</td>\n",
       "        <td>94</td>\n",
       "        <td>28.1</td>\n",
       "        <td>0.167</td>\n",
       "        <td>21</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>137</td>\n",
       "        <td>40</td>\n",
       "        <td>35</td>\n",
       "        <td>168</td>\n",
       "        <td>43.1</td>\n",
       "        <td>2.288</td>\n",
       "        <td>33</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(6, 148, 72, 35, 0, 33.6, 0.627, 50, 1),\n",
       " (1, 85, 66, 29, 0, 26.6, 0.351, 31, 0),\n",
       " (8, 183, 64, 0, 0, 23.3, 0.672, 32, 1),\n",
       " (1, 89, 66, 23, 94, 28.1, 0.167, 21, 0),\n",
       " (0, 137, 40, 35, 168, 43.1, 2.288, 33, 1)]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "\n",
    "SELECT * FROM diabetes LIMIT 5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///database/pacientes.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>total_registros</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>768</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(768,)]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "\n",
    "SELECT COUNT(*) AS total_registros FROM diabetes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///database/pacientes.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>Age</th>\n",
       "        <th>Glucose</th>\n",
       "        <th>Outcome</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>53</td>\n",
       "        <td>197</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>41</td>\n",
       "        <td>196</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>41</td>\n",
       "        <td>194</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>57</td>\n",
       "        <td>196</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>31</td>\n",
       "        <td>197</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>24</td>\n",
       "        <td>193</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>34</td>\n",
       "        <td>191</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>59</td>\n",
       "        <td>194</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>29</td>\n",
       "        <td>196</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>25</td>\n",
       "        <td>193</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>39</td>\n",
       "        <td>197</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>67</td>\n",
       "        <td>194</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>55</td>\n",
       "        <td>195</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>28</td>\n",
       "        <td>198</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>62</td>\n",
       "        <td>197</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>22</td>\n",
       "        <td>199</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>31</td>\n",
       "        <td>195</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(53, 197, 1),\n",
       " (41, 196, 1),\n",
       " (41, 194, 1),\n",
       " (57, 196, 1),\n",
       " (31, 197, 0),\n",
       " (24, 193, 0),\n",
       " (34, 191, 0),\n",
       " (59, 194, 1),\n",
       " (29, 196, 1),\n",
       " (25, 193, 1),\n",
       " (39, 197, 1),\n",
       " (67, 194, 0),\n",
       " (55, 195, 1),\n",
       " (28, 198, 1),\n",
       " (62, 197, 1),\n",
       " (22, 199, 1),\n",
       " (31, 195, 1)]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "\n",
    "SELECT Age, Glucose, Outcome FROM diabetes WHERE Glucose > 190"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///database/pacientes.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>Pregnancies</th>\n",
       "        <th>Glucose</th>\n",
       "        <th>BloodPressure</th>\n",
       "        <th>SkinThickness</th>\n",
       "        <th>Insulin</th>\n",
       "        <th>BMI</th>\n",
       "        <th>DiabetesPedigreeFunction</th>\n",
       "        <th>Age</th>\n",
       "        <th>Outcome</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>197</td>\n",
       "        <td>70</td>\n",
       "        <td>45</td>\n",
       "        <td>543</td>\n",
       "        <td>30.5</td>\n",
       "        <td>0.158</td>\n",
       "        <td>53</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>196</td>\n",
       "        <td>90</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>39.8</td>\n",
       "        <td>0.451</td>\n",
       "        <td>41</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>194</td>\n",
       "        <td>68</td>\n",
       "        <td>28</td>\n",
       "        <td>0</td>\n",
       "        <td>35.9</td>\n",
       "        <td>0.745</td>\n",
       "        <td>41</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>196</td>\n",
       "        <td>76</td>\n",
       "        <td>29</td>\n",
       "        <td>280</td>\n",
       "        <td>37.5</td>\n",
       "        <td>0.605</td>\n",
       "        <td>57</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>194</td>\n",
       "        <td>78</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>23.5</td>\n",
       "        <td>0.129</td>\n",
       "        <td>59</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>196</td>\n",
       "        <td>76</td>\n",
       "        <td>36</td>\n",
       "        <td>249</td>\n",
       "        <td>36.5</td>\n",
       "        <td>0.875</td>\n",
       "        <td>29</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>193</td>\n",
       "        <td>70</td>\n",
       "        <td>31</td>\n",
       "        <td>0</td>\n",
       "        <td>34.9</td>\n",
       "        <td>0.241</td>\n",
       "        <td>25</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>197</td>\n",
       "        <td>74</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>25.9</td>\n",
       "        <td>1.191</td>\n",
       "        <td>39</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>195</td>\n",
       "        <td>70</td>\n",
       "        <td>33</td>\n",
       "        <td>145</td>\n",
       "        <td>25.1</td>\n",
       "        <td>0.163</td>\n",
       "        <td>55</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>198</td>\n",
       "        <td>66</td>\n",
       "        <td>32</td>\n",
       "        <td>274</td>\n",
       "        <td>41.3</td>\n",
       "        <td>0.502</td>\n",
       "        <td>28</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>197</td>\n",
       "        <td>70</td>\n",
       "        <td>99</td>\n",
       "        <td>0</td>\n",
       "        <td>34.7</td>\n",
       "        <td>0.575</td>\n",
       "        <td>62</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>199</td>\n",
       "        <td>76</td>\n",
       "        <td>43</td>\n",
       "        <td>0</td>\n",
       "        <td>42.9</td>\n",
       "        <td>1.394</td>\n",
       "        <td>22</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>195</td>\n",
       "        <td>70</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>30.9</td>\n",
       "        <td>0.328</td>\n",
       "        <td>31</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(2, 197, 70, 45, 543, 30.5, 0.158, 53, 1),\n",
       " (7, 196, 90, 0, 0, 39.8, 0.451, 41, 1),\n",
       " (7, 194, 68, 28, 0, 35.9, 0.745, 41, 1),\n",
       " (8, 196, 76, 29, 280, 37.5, 0.605, 57, 1),\n",
       " (6, 194, 78, 0, 0, 23.5, 0.129, 59, 1),\n",
       " (1, 196, 76, 36, 249, 36.5, 0.875, 29, 1),\n",
       " (3, 193, 70, 31, 0, 34.9, 0.241, 25, 1),\n",
       " (8, 197, 74, 0, 0, 25.9, 1.191, 39, 1),\n",
       " (7, 195, 70, 33, 145, 25.1, 0.163, 55, 1),\n",
       " (0, 198, 66, 32, 274, 41.3, 0.502, 28, 1),\n",
       " (2, 197, 70, 99, 0, 34.7, 0.575, 62, 1),\n",
       " (1, 199, 76, 43, 0, 42.9, 1.394, 22, 1),\n",
       " (6, 195, 70, 0, 0, 30.9, 0.328, 31, 1)]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "\n",
    "SELECT * FROM diabetes WHERE Glucose > 190 AND Outcome = 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///database/pacientes.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>Age</th>\n",
       "        <th>Glucose</th>\n",
       "        <th>Outcome</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>53</td>\n",
       "        <td>197</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>41</td>\n",
       "        <td>196</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>41</td>\n",
       "        <td>194</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>57</td>\n",
       "        <td>196</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>31</td>\n",
       "        <td>197</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>24</td>\n",
       "        <td>193</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>34</td>\n",
       "        <td>191</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>59</td>\n",
       "        <td>194</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>29</td>\n",
       "        <td>196</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>25</td>\n",
       "        <td>193</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>39</td>\n",
       "        <td>197</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>67</td>\n",
       "        <td>194</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>55</td>\n",
       "        <td>195</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>28</td>\n",
       "        <td>198</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>62</td>\n",
       "        <td>197</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>22</td>\n",
       "        <td>199</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>31</td>\n",
       "        <td>195</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(53, 197, 1),\n",
       " (41, 196, 1),\n",
       " (41, 194, 1),\n",
       " (57, 196, 1),\n",
       " (31, 197, 0),\n",
       " (24, 193, 0),\n",
       " (34, 191, 0),\n",
       " (59, 194, 1),\n",
       " (29, 196, 1),\n",
       " (25, 193, 1),\n",
       " (39, 197, 1),\n",
       " (67, 194, 0),\n",
       " (55, 195, 1),\n",
       " (28, 198, 1),\n",
       " (62, 197, 1),\n",
       " (22, 199, 1),\n",
       " (31, 195, 1)]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "\n",
    "SELECT Age, Glucose, Outcome FROM diabetes WHERE Glucose > 190\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# criar tabela vazia no banco de dados"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///database/pacientes.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "[]"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "\n",
    "CREATE TABLE pacientes (Pregnancies INT,\n",
    "                        Glucose INT,\n",
    "                        BloodPressure INT,\n",
    "                        SkinThickness INT,\n",
    "                        Insulin INT,\n",
    "                        BMI DECIMAL(8, 2),\n",
    "                        DiabetesPedigreeFunction DECIMAL(8, 2),\n",
    "                        Age INT,\n",
    "                        Outcome INT);"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///database/pacientes.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>Pregnancies</th>\n",
       "        <th>Glucose</th>\n",
       "        <th>BloodPressure</th>\n",
       "        <th>SkinThickness</th>\n",
       "        <th>Insulin</th>\n",
       "        <th>BMI</th>\n",
       "        <th>DiabetesPedigreeFunction</th>\n",
       "        <th>Age</th>\n",
       "        <th>Outcome</th>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "\n",
    "SELECT * FROM pacientes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# mover aqueles com idade maior que 50 anos para a tabela pacientes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///database/pacientes.db\n",
      "81 rows affected.\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "[]"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "\n",
    "INSERT INTO pacientes(Pregnancies, \n",
    "                      Glucose, \n",
    "                      BloodPressure, \n",
    "                      SkinThickness, \n",
    "                      Insulin, \n",
    "                      BMI, \n",
    "                      DiabetesPedigreeFunction, \n",
    "                      Age, \n",
    "                      Outcome) \n",
    "SELECT Pregnancies, \n",
    "       Glucose, \n",
    "       BloodPressure, \n",
    "       SkinThickness, \n",
    "       Insulin, \n",
    "       BMI, \n",
    "       DiabetesPedigreeFunction, \n",
    "       Age, \n",
    "       Outcome \n",
    "FROM diabetes WHERE Age > 50;"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///database/pacientes.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>Pregnancies</th>\n",
       "        <th>Glucose</th>\n",
       "        <th>BloodPressure</th>\n",
       "        <th>SkinThickness</th>\n",
       "        <th>Insulin</th>\n",
       "        <th>BMI</th>\n",
       "        <th>DiabetesPedigreeFunction</th>\n",
       "        <th>Age</th>\n",
       "        <th>Outcome</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>197</td>\n",
       "        <td>70</td>\n",
       "        <td>45</td>\n",
       "        <td>543</td>\n",
       "        <td>30.5</td>\n",
       "        <td>0.158</td>\n",
       "        <td>53</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>125</td>\n",
       "        <td>96</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>0.232</td>\n",
       "        <td>54</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>139</td>\n",
       "        <td>80</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>27.1</td>\n",
       "        <td>1.441</td>\n",
       "        <td>57</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>189</td>\n",
       "        <td>60</td>\n",
       "        <td>23</td>\n",
       "        <td>846</td>\n",
       "        <td>30.1</td>\n",
       "        <td>0.398</td>\n",
       "        <td>59</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>166</td>\n",
       "        <td>72</td>\n",
       "        <td>19</td>\n",
       "        <td>175</td>\n",
       "        <td>25.8</td>\n",
       "        <td>0.587</td>\n",
       "        <td>51</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "        <td>143</td>\n",
       "        <td>94</td>\n",
       "        <td>33</td>\n",
       "        <td>146</td>\n",
       "        <td>36.6</td>\n",
       "        <td>0.254</td>\n",
       "        <td>51</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>13</td>\n",
       "        <td>145</td>\n",
       "        <td>82</td>\n",
       "        <td>19</td>\n",
       "        <td>110</td>\n",
       "        <td>22.2</td>\n",
       "        <td>0.245</td>\n",
       "        <td>57</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>109</td>\n",
       "        <td>75</td>\n",
       "        <td>26</td>\n",
       "        <td>0</td>\n",
       "        <td>36</td>\n",
       "        <td>0.546</td>\n",
       "        <td>60</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>111</td>\n",
       "        <td>72</td>\n",
       "        <td>47</td>\n",
       "        <td>207</td>\n",
       "        <td>37.1</td>\n",
       "        <td>1.39</td>\n",
       "        <td>56</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>171</td>\n",
       "        <td>110</td>\n",
       "        <td>24</td>\n",
       "        <td>240</td>\n",
       "        <td>45.4</td>\n",
       "        <td>0.721</td>\n",
       "        <td>54</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>176</td>\n",
       "        <td>90</td>\n",
       "        <td>34</td>\n",
       "        <td>300</td>\n",
       "        <td>33.7</td>\n",
       "        <td>0.467</td>\n",
       "        <td>58</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>109</td>\n",
       "        <td>92</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>42.7</td>\n",
       "        <td>0.845</td>\n",
       "        <td>54</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>134</td>\n",
       "        <td>72</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>23.8</td>\n",
       "        <td>0.277</td>\n",
       "        <td>60</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>146</td>\n",
       "        <td>92</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>31.2</td>\n",
       "        <td>0.539</td>\n",
       "        <td>61</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>132</td>\n",
       "        <td>80</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>26.8</td>\n",
       "        <td>0.186</td>\n",
       "        <td>69</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>105</td>\n",
       "        <td>84</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>27.9</td>\n",
       "        <td>0.741</td>\n",
       "        <td>62</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>128</td>\n",
       "        <td>78</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>21.1</td>\n",
       "        <td>0.268</td>\n",
       "        <td>55</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>147</td>\n",
       "        <td>78</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>33.7</td>\n",
       "        <td>0.218</td>\n",
       "        <td>65</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>181</td>\n",
       "        <td>68</td>\n",
       "        <td>36</td>\n",
       "        <td>495</td>\n",
       "        <td>30.1</td>\n",
       "        <td>0.615</td>\n",
       "        <td>60</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>103</td>\n",
       "        <td>72</td>\n",
       "        <td>32</td>\n",
       "        <td>190</td>\n",
       "        <td>37.7</td>\n",
       "        <td>0.324</td>\n",
       "        <td>55</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>196</td>\n",
       "        <td>76</td>\n",
       "        <td>29</td>\n",
       "        <td>280</td>\n",
       "        <td>37.5</td>\n",
       "        <td>0.605</td>\n",
       "        <td>57</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>162</td>\n",
       "        <td>104</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>37.7</td>\n",
       "        <td>0.151</td>\n",
       "        <td>52</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>179</td>\n",
       "        <td>95</td>\n",
       "        <td>31</td>\n",
       "        <td>0</td>\n",
       "        <td>34.2</td>\n",
       "        <td>0.164</td>\n",
       "        <td>60</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>158</td>\n",
       "        <td>90</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>31.6</td>\n",
       "        <td>0.805</td>\n",
       "        <td>66</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>142</td>\n",
       "        <td>60</td>\n",
       "        <td>33</td>\n",
       "        <td>190</td>\n",
       "        <td>28.8</td>\n",
       "        <td>0.687</td>\n",
       "        <td>61</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>181</td>\n",
       "        <td>84</td>\n",
       "        <td>21</td>\n",
       "        <td>192</td>\n",
       "        <td>35.9</td>\n",
       "        <td>0.586</td>\n",
       "        <td>51</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "        <td>155</td>\n",
       "        <td>76</td>\n",
       "        <td>28</td>\n",
       "        <td>150</td>\n",
       "        <td>33.3</td>\n",
       "        <td>1.353</td>\n",
       "        <td>51</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>142</td>\n",
       "        <td>80</td>\n",
       "        <td>15</td>\n",
       "        <td>0</td>\n",
       "        <td>32.4</td>\n",
       "        <td>0.2</td>\n",
       "        <td>63</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>13</td>\n",
       "        <td>106</td>\n",
       "        <td>70</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>34.2</td>\n",
       "        <td>0.251</td>\n",
       "        <td>52</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>114</td>\n",
       "        <td>74</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>24.9</td>\n",
       "        <td>0.744</td>\n",
       "        <td>57</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>108</td>\n",
       "        <td>80</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>27</td>\n",
       "        <td>0.259</td>\n",
       "        <td>52</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>136</td>\n",
       "        <td>74</td>\n",
       "        <td>26</td>\n",
       "        <td>135</td>\n",
       "        <td>26</td>\n",
       "        <td>0.647</td>\n",
       "        <td>51</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>161</td>\n",
       "        <td>50</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>21.9</td>\n",
       "        <td>0.254</td>\n",
       "        <td>65</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>112</td>\n",
       "        <td>72</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>23.6</td>\n",
       "        <td>0.84</td>\n",
       "        <td>58</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>194</td>\n",
       "        <td>78</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>23.5</td>\n",
       "        <td>0.129</td>\n",
       "        <td>59</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>95</td>\n",
       "        <td>72</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>36.8</td>\n",
       "        <td>0.485</td>\n",
       "        <td>57</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>158</td>\n",
       "        <td>70</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>29.8</td>\n",
       "        <td>0.207</td>\n",
       "        <td>63</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>103</td>\n",
       "        <td>108</td>\n",
       "        <td>37</td>\n",
       "        <td>0</td>\n",
       "        <td>39.2</td>\n",
       "        <td>0.305</td>\n",
       "        <td>65</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>146</td>\n",
       "        <td>78</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>38.5</td>\n",
       "        <td>0.52</td>\n",
       "        <td>67</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12</td>\n",
       "        <td>140</td>\n",
       "        <td>82</td>\n",
       "        <td>43</td>\n",
       "        <td>325</td>\n",
       "        <td>39.2</td>\n",
       "        <td>0.528</td>\n",
       "        <td>58</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>144</td>\n",
       "        <td>82</td>\n",
       "        <td>26</td>\n",
       "        <td>285</td>\n",
       "        <td>32</td>\n",
       "        <td>0.452</td>\n",
       "        <td>58</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>137</td>\n",
       "        <td>61</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>24.2</td>\n",
       "        <td>0.151</td>\n",
       "        <td>55</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>119</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>19.6</td>\n",
       "        <td>0.832</td>\n",
       "        <td>72</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>135</td>\n",
       "        <td>54</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>26.7</td>\n",
       "        <td>0.687</td>\n",
       "        <td>62</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>148</td>\n",
       "        <td>84</td>\n",
       "        <td>48</td>\n",
       "        <td>237</td>\n",
       "        <td>37.6</td>\n",
       "        <td>1.001</td>\n",
       "        <td>51</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>134</td>\n",
       "        <td>74</td>\n",
       "        <td>33</td>\n",
       "        <td>60</td>\n",
       "        <td>25.9</td>\n",
       "        <td>0.46</td>\n",
       "        <td>81</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>137</td>\n",
       "        <td>84</td>\n",
       "        <td>27</td>\n",
       "        <td>0</td>\n",
       "        <td>27.3</td>\n",
       "        <td>0.231</td>\n",
       "        <td>59</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>132</td>\n",
       "        <td>86</td>\n",
       "        <td>31</td>\n",
       "        <td>0</td>\n",
       "        <td>28</td>\n",
       "        <td>0.419</td>\n",
       "        <td>63</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>173</td>\n",
       "        <td>78</td>\n",
       "        <td>32</td>\n",
       "        <td>265</td>\n",
       "        <td>46.5</td>\n",
       "        <td>1.159</td>\n",
       "        <td>58</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>194</td>\n",
       "        <td>80</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>26.1</td>\n",
       "        <td>0.551</td>\n",
       "        <td>67</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>166</td>\n",
       "        <td>74</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>26.6</td>\n",
       "        <td>0.304</td>\n",
       "        <td>66</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>195</td>\n",
       "        <td>70</td>\n",
       "        <td>33</td>\n",
       "        <td>145</td>\n",
       "        <td>25.1</td>\n",
       "        <td>0.163</td>\n",
       "        <td>55</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>120</td>\n",
       "        <td>78</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>25</td>\n",
       "        <td>0.409</td>\n",
       "        <td>64</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>91</td>\n",
       "        <td>68</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>24.2</td>\n",
       "        <td>0.2</td>\n",
       "        <td>58</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>145</td>\n",
       "        <td>88</td>\n",
       "        <td>34</td>\n",
       "        <td>165</td>\n",
       "        <td>30.3</td>\n",
       "        <td>0.771</td>\n",
       "        <td>53</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>125</td>\n",
       "        <td>86</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>37.6</td>\n",
       "        <td>0.304</td>\n",
       "        <td>51</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>129</td>\n",
       "        <td>90</td>\n",
       "        <td>7</td>\n",
       "        <td>326</td>\n",
       "        <td>19.6</td>\n",
       "        <td>0.582</td>\n",
       "        <td>60</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>57</td>\n",
       "        <td>60</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>21.7</td>\n",
       "        <td>0.735</td>\n",
       "        <td>67</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>90</td>\n",
       "        <td>85</td>\n",
       "        <td>32</td>\n",
       "        <td>0</td>\n",
       "        <td>34.9</td>\n",
       "        <td>0.825</td>\n",
       "        <td>56</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>187</td>\n",
       "        <td>76</td>\n",
       "        <td>27</td>\n",
       "        <td>207</td>\n",
       "        <td>43.6</td>\n",
       "        <td>1.034</td>\n",
       "        <td>53</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>114</td>\n",
       "        <td>88</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>27.8</td>\n",
       "        <td>0.247</td>\n",
       "        <td>66</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>110</td>\n",
       "        <td>76</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>27.8</td>\n",
       "        <td>0.237</td>\n",
       "        <td>58</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>125</td>\n",
       "        <td>76</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>33.8</td>\n",
       "        <td>0.121</td>\n",
       "        <td>54</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>197</td>\n",
       "        <td>70</td>\n",
       "        <td>99</td>\n",
       "        <td>0</td>\n",
       "        <td>34.7</td>\n",
       "        <td>0.575</td>\n",
       "        <td>62</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12</td>\n",
       "        <td>121</td>\n",
       "        <td>78</td>\n",
       "        <td>17</td>\n",
       "        <td>0</td>\n",
       "        <td>26.5</td>\n",
       "        <td>0.259</td>\n",
       "        <td>62</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>124</td>\n",
       "        <td>76</td>\n",
       "        <td>24</td>\n",
       "        <td>600</td>\n",
       "        <td>28.7</td>\n",
       "        <td>0.687</td>\n",
       "        <td>52</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>176</td>\n",
       "        <td>86</td>\n",
       "        <td>27</td>\n",
       "        <td>156</td>\n",
       "        <td>33.3</td>\n",
       "        <td>1.154</td>\n",
       "        <td>52</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>150</td>\n",
       "        <td>78</td>\n",
       "        <td>29</td>\n",
       "        <td>126</td>\n",
       "        <td>35.2</td>\n",
       "        <td>0.692</td>\n",
       "        <td>54</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "        <td>127</td>\n",
       "        <td>106</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>39</td>\n",
       "        <td>0.19</td>\n",
       "        <td>51</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>162</td>\n",
       "        <td>84</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>27.7</td>\n",
       "        <td>0.182</td>\n",
       "        <td>54</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>145</td>\n",
       "        <td>82</td>\n",
       "        <td>18</td>\n",
       "        <td>0</td>\n",
       "        <td>32.5</td>\n",
       "        <td>0.235</td>\n",
       "        <td>70</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>91</td>\n",
       "        <td>82</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>35.6</td>\n",
       "        <td>0.587</td>\n",
       "        <td>68</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>156</td>\n",
       "        <td>86</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>24.8</td>\n",
       "        <td>0.23</td>\n",
       "        <td>53</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>136</td>\n",
       "        <td>82</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>0.64</td>\n",
       "        <td>69</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>168</td>\n",
       "        <td>88</td>\n",
       "        <td>29</td>\n",
       "        <td>0</td>\n",
       "        <td>35</td>\n",
       "        <td>0.905</td>\n",
       "        <td>52</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>94</td>\n",
       "        <td>72</td>\n",
       "        <td>18</td>\n",
       "        <td>0</td>\n",
       "        <td>23.1</td>\n",
       "        <td>0.595</td>\n",
       "        <td>56</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>97</td>\n",
       "        <td>76</td>\n",
       "        <td>27</td>\n",
       "        <td>0</td>\n",
       "        <td>35.6</td>\n",
       "        <td>0.378</td>\n",
       "        <td>52</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>105</td>\n",
       "        <td>75</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>23.3</td>\n",
       "        <td>0.56</td>\n",
       "        <td>53</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>123</td>\n",
       "        <td>72</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>36.3</td>\n",
       "        <td>0.258</td>\n",
       "        <td>52</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>190</td>\n",
       "        <td>92</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>35.5</td>\n",
       "        <td>0.278</td>\n",
       "        <td>66</td>\n",
       "        <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>101</td>\n",
       "        <td>76</td>\n",
       "        <td>48</td>\n",
       "        <td>180</td>\n",
       "        <td>32.9</td>\n",
       "        <td>0.171</td>\n",
       "        <td>63</td>\n",
       "        <td>0</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(2, 197, 70, 45, 543, 30.5, 0.158, 53, 1),\n",
       " (8, 125, 96, 0, 0, 0, 0.232, 54, 1),\n",
       " (10, 139, 80, 0, 0, 27.1, 1.441, 57, 0),\n",
       " (1, 189, 60, 23, 846, 30.1, 0.398, 59, 1),\n",
       " (5, 166, 72, 19, 175, 25.8, 0.587, 51, 1),\n",
       " (11, 143, 94, 33, 146, 36.6, 0.254, 51, 1),\n",
       " (13, 145, 82, 19, 110, 22.2, 0.245, 57, 0),\n",
       " (5, 109, 75, 26, 0, 36, 0.546, 60, 0),\n",
       " (4, 111, 72, 47, 207, 37.1, 1.39, 56, 1),\n",
       " (9, 171, 110, 24, 240, 45.4, 0.721, 54, 1),\n",
       " (8, 176, 90, 34, 300, 33.7, 0.467, 58, 1),\n",
       " (2, 109, 92, 0, 0, 42.7, 0.845, 54, 0),\n",
       " (4, 134, 72, 0, 0, 23.8, 0.277, 60, 1),\n",
       " (4, 146, 92, 0, 0, 31.2, 0.539, 61, 1),\n",
       " (5, 132, 80, 0, 0, 26.8, 0.186, 69, 0),\n",
       " (0, 105, 84, 0, 0, 27.9, 0.741, 62, 1),\n",
       " (3, 128, 78, 0, 0, 21.1, 0.268, 55, 0),\n",
       " (5, 147, 78, 0, 0, 33.7, 0.218, 65, 0),\n",
       " (8, 181, 68, 36, 495, 30.1, 0.615, 60, 1),\n",
       " (6, 103, 72, 32, 190, 37.7, 0.324, 55, 0),\n",
       " (8, 196, 76, 29, 280, 37.5, 0.605, 57, 1),\n",
       " (5, 162, 104, 0, 0, 37.7, 0.151, 52, 1),\n",
       " (7, 179, 95, 31, 0, 34.2, 0.164, 60, 0),\n",
       " (2, 158, 90, 0, 0, 31.6, 0.805, 66, 1),\n",
       " (7, 142, 60, 33, 190, 28.8, 0.687, 61, 0),\n",
       " (7, 181, 84, 21, 192, 35.9, 0.586, 51, 1),\n",
       " (11, 155, 76, 28, 150, 33.3, 1.353, 51, 1),\n",
       " (3, 142, 80, 15, 0, 32.4, 0.2, 63, 0),\n",
       " (13, 106, 70, 0, 0, 34.2, 0.251, 52, 0),\n",
       " (5, 114, 74, 0, 0, 24.9, 0.744, 57, 0),\n",
       " (2, 108, 80, 0, 0, 27, 0.259, 52, 1),\n",
       " (7, 136, 74, 26, 135, 26, 0.647, 51, 0),\n",
       " (0, 161, 50, 0, 0, 21.9, 0.254, 65, 0),\n",
       " (8, 112, 72, 0, 0, 23.6, 0.84, 58, 0),\n",
       " (6, 194, 78, 0, 0, 23.5, 0.129, 59, 1),\n",
       " (8, 95, 72, 0, 0, 36.8, 0.485, 57, 0),\n",
       " (5, 158, 70, 0, 0, 29.8, 0.207, 63, 0),\n",
       " (5, 103, 108, 37, 0, 39.2, 0.305, 65, 0),\n",
       " (4, 146, 78, 0, 0, 38.5, 0.52, 67, 1),\n",
       " (12, 140, 82, 43, 325, 39.2, 0.528, 58, 1),\n",
       " (5, 144, 82, 26, 285, 32, 0.452, 58, 1),\n",
       " (6, 137, 61, 0, 0, 24.2, 0.151, 55, 0),\n",
       " (2, 119, 0, 0, 0, 19.6, 0.832, 72, 0),\n",
       " (1, 135, 54, 0, 0, 26.7, 0.687, 62, 0),\n",
       " (10, 148, 84, 48, 237, 37.6, 1.001, 51, 1),\n",
       " (9, 134, 74, 33, 60, 25.9, 0.46, 81, 0),\n",
       " (0, 137, 84, 27, 0, 27.3, 0.231, 59, 0),\n",
       " (4, 132, 86, 31, 0, 28, 0.419, 63, 0),\n",
       " (0, 173, 78, 32, 265, 46.5, 1.159, 58, 0),\n",
       " (8, 194, 80, 0, 0, 26.1, 0.551, 67, 0),\n",
       " (6, 166, 74, 0, 0, 26.6, 0.304, 66, 0),\n",
       " (7, 195, 70, 33, 145, 25.1, 0.163, 55, 1),\n",
       " (8, 120, 78, 0, 0, 25, 0.409, 64, 0),\n",
       " (9, 91, 68, 0, 0, 24.2, 0.2, 58, 0),\n",
       " (9, 145, 88, 34, 165, 30.3, 0.771, 53, 1),\n",
       " (7, 125, 86, 0, 0, 37.6, 0.304, 51, 0),\n",
       " (6, 129, 90, 7, 326, 19.6, 0.582, 60, 0),\n",
       " (0, 57, 60, 0, 0, 21.7, 0.735, 67, 0),\n",
       " (10, 90, 85, 32, 0, 34.9, 0.825, 56, 1),\n",
       " (5, 187, 76, 27, 207, 43.6, 1.034, 53, 1),\n",
       " (6, 114, 88, 0, 0, 27.8, 0.247, 66, 0),\n",
       " (8, 110, 76, 0, 0, 27.8, 0.237, 58, 0),\n",
       " (6, 125, 76, 0, 0, 33.8, 0.121, 54, 1),\n",
       " (2, 197, 70, 99, 0, 34.7, 0.575, 62, 1),\n",
       " (12, 121, 78, 17, 0, 26.5, 0.259, 62, 0),\n",
       " (8, 124, 76, 24, 600, 28.7, 0.687, 52, 1),\n",
       " (3, 176, 86, 27, 156, 33.3, 1.154, 52, 1),\n",
       " (7, 150, 78, 29, 126, 35.2, 0.692, 54, 1),\n",
       " (11, 127, 106, 0, 0, 39, 0.19, 51, 0),\n",
       " (10, 162, 84, 0, 0, 27.7, 0.182, 54, 0),\n",
       " (4, 145, 82, 18, 0, 32.5, 0.235, 70, 1),\n",
       " (8, 91, 82, 0, 0, 35.6, 0.587, 68, 0),\n",
       " (9, 156, 86, 0, 0, 24.8, 0.23, 53, 1),\n",
       " (5, 136, 82, 0, 0, 0, 0.64, 69, 0),\n",
       " (1, 168, 88, 29, 0, 35, 0.905, 52, 1),\n",
       " (10, 94, 72, 18, 0, 23.1, 0.595, 56, 0),\n",
       " (5, 97, 76, 27, 0, 35.6, 0.378, 52, 1),\n",
       " (2, 105, 75, 0, 0, 23.3, 0.56, 53, 0),\n",
       " (0, 123, 72, 0, 0, 36.3, 0.258, 52, 1),\n",
       " (6, 190, 92, 0, 0, 35.5, 0.278, 66, 1),\n",
       " (10, 101, 76, 48, 180, 32.9, 0.171, 63, 0)]"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "\n",
    "SELECT * FROM pacientes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# criar nova coluna com Perfil do paciente "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///database/pacientes.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "[]"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql \n",
    "\n",
    "ALTER TABLE pacientes\n",
    "ADD Perfil VARCHAR(10);"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///database/pacientes.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>Pregnancies</th>\n",
       "        <th>Glucose</th>\n",
       "        <th>BloodPressure</th>\n",
       "        <th>SkinThickness</th>\n",
       "        <th>Insulin</th>\n",
       "        <th>BMI</th>\n",
       "        <th>DiabetesPedigreeFunction</th>\n",
       "        <th>Age</th>\n",
       "        <th>Outcome</th>\n",
       "        <th>Perfil</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>197</td>\n",
       "        <td>70</td>\n",
       "        <td>45</td>\n",
       "        <td>543</td>\n",
       "        <td>30.5</td>\n",
       "        <td>0.158</td>\n",
       "        <td>53</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>125</td>\n",
       "        <td>96</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>0.232</td>\n",
       "        <td>54</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>139</td>\n",
       "        <td>80</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>27.1</td>\n",
       "        <td>1.441</td>\n",
       "        <td>57</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>189</td>\n",
       "        <td>60</td>\n",
       "        <td>23</td>\n",
       "        <td>846</td>\n",
       "        <td>30.1</td>\n",
       "        <td>0.398</td>\n",
       "        <td>59</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>166</td>\n",
       "        <td>72</td>\n",
       "        <td>19</td>\n",
       "        <td>175</td>\n",
       "        <td>25.8</td>\n",
       "        <td>0.587</td>\n",
       "        <td>51</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "        <td>143</td>\n",
       "        <td>94</td>\n",
       "        <td>33</td>\n",
       "        <td>146</td>\n",
       "        <td>36.6</td>\n",
       "        <td>0.254</td>\n",
       "        <td>51</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>13</td>\n",
       "        <td>145</td>\n",
       "        <td>82</td>\n",
       "        <td>19</td>\n",
       "        <td>110</td>\n",
       "        <td>22.2</td>\n",
       "        <td>0.245</td>\n",
       "        <td>57</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>109</td>\n",
       "        <td>75</td>\n",
       "        <td>26</td>\n",
       "        <td>0</td>\n",
       "        <td>36</td>\n",
       "        <td>0.546</td>\n",
       "        <td>60</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>111</td>\n",
       "        <td>72</td>\n",
       "        <td>47</td>\n",
       "        <td>207</td>\n",
       "        <td>37.1</td>\n",
       "        <td>1.39</td>\n",
       "        <td>56</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>171</td>\n",
       "        <td>110</td>\n",
       "        <td>24</td>\n",
       "        <td>240</td>\n",
       "        <td>45.4</td>\n",
       "        <td>0.721</td>\n",
       "        <td>54</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>176</td>\n",
       "        <td>90</td>\n",
       "        <td>34</td>\n",
       "        <td>300</td>\n",
       "        <td>33.7</td>\n",
       "        <td>0.467</td>\n",
       "        <td>58</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>109</td>\n",
       "        <td>92</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>42.7</td>\n",
       "        <td>0.845</td>\n",
       "        <td>54</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>134</td>\n",
       "        <td>72</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>23.8</td>\n",
       "        <td>0.277</td>\n",
       "        <td>60</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>146</td>\n",
       "        <td>92</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>31.2</td>\n",
       "        <td>0.539</td>\n",
       "        <td>61</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>132</td>\n",
       "        <td>80</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>26.8</td>\n",
       "        <td>0.186</td>\n",
       "        <td>69</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>105</td>\n",
       "        <td>84</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>27.9</td>\n",
       "        <td>0.741</td>\n",
       "        <td>62</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>128</td>\n",
       "        <td>78</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>21.1</td>\n",
       "        <td>0.268</td>\n",
       "        <td>55</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>147</td>\n",
       "        <td>78</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>33.7</td>\n",
       "        <td>0.218</td>\n",
       "        <td>65</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>181</td>\n",
       "        <td>68</td>\n",
       "        <td>36</td>\n",
       "        <td>495</td>\n",
       "        <td>30.1</td>\n",
       "        <td>0.615</td>\n",
       "        <td>60</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>103</td>\n",
       "        <td>72</td>\n",
       "        <td>32</td>\n",
       "        <td>190</td>\n",
       "        <td>37.7</td>\n",
       "        <td>0.324</td>\n",
       "        <td>55</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>196</td>\n",
       "        <td>76</td>\n",
       "        <td>29</td>\n",
       "        <td>280</td>\n",
       "        <td>37.5</td>\n",
       "        <td>0.605</td>\n",
       "        <td>57</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>162</td>\n",
       "        <td>104</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>37.7</td>\n",
       "        <td>0.151</td>\n",
       "        <td>52</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>179</td>\n",
       "        <td>95</td>\n",
       "        <td>31</td>\n",
       "        <td>0</td>\n",
       "        <td>34.2</td>\n",
       "        <td>0.164</td>\n",
       "        <td>60</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>158</td>\n",
       "        <td>90</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>31.6</td>\n",
       "        <td>0.805</td>\n",
       "        <td>66</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>142</td>\n",
       "        <td>60</td>\n",
       "        <td>33</td>\n",
       "        <td>190</td>\n",
       "        <td>28.8</td>\n",
       "        <td>0.687</td>\n",
       "        <td>61</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>181</td>\n",
       "        <td>84</td>\n",
       "        <td>21</td>\n",
       "        <td>192</td>\n",
       "        <td>35.9</td>\n",
       "        <td>0.586</td>\n",
       "        <td>51</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "        <td>155</td>\n",
       "        <td>76</td>\n",
       "        <td>28</td>\n",
       "        <td>150</td>\n",
       "        <td>33.3</td>\n",
       "        <td>1.353</td>\n",
       "        <td>51</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>142</td>\n",
       "        <td>80</td>\n",
       "        <td>15</td>\n",
       "        <td>0</td>\n",
       "        <td>32.4</td>\n",
       "        <td>0.2</td>\n",
       "        <td>63</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>13</td>\n",
       "        <td>106</td>\n",
       "        <td>70</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>34.2</td>\n",
       "        <td>0.251</td>\n",
       "        <td>52</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>114</td>\n",
       "        <td>74</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>24.9</td>\n",
       "        <td>0.744</td>\n",
       "        <td>57</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>108</td>\n",
       "        <td>80</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>27</td>\n",
       "        <td>0.259</td>\n",
       "        <td>52</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>136</td>\n",
       "        <td>74</td>\n",
       "        <td>26</td>\n",
       "        <td>135</td>\n",
       "        <td>26</td>\n",
       "        <td>0.647</td>\n",
       "        <td>51</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>161</td>\n",
       "        <td>50</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>21.9</td>\n",
       "        <td>0.254</td>\n",
       "        <td>65</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>112</td>\n",
       "        <td>72</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>23.6</td>\n",
       "        <td>0.84</td>\n",
       "        <td>58</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>194</td>\n",
       "        <td>78</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>23.5</td>\n",
       "        <td>0.129</td>\n",
       "        <td>59</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>95</td>\n",
       "        <td>72</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>36.8</td>\n",
       "        <td>0.485</td>\n",
       "        <td>57</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>158</td>\n",
       "        <td>70</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>29.8</td>\n",
       "        <td>0.207</td>\n",
       "        <td>63</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>103</td>\n",
       "        <td>108</td>\n",
       "        <td>37</td>\n",
       "        <td>0</td>\n",
       "        <td>39.2</td>\n",
       "        <td>0.305</td>\n",
       "        <td>65</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>146</td>\n",
       "        <td>78</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>38.5</td>\n",
       "        <td>0.52</td>\n",
       "        <td>67</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12</td>\n",
       "        <td>140</td>\n",
       "        <td>82</td>\n",
       "        <td>43</td>\n",
       "        <td>325</td>\n",
       "        <td>39.2</td>\n",
       "        <td>0.528</td>\n",
       "        <td>58</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>144</td>\n",
       "        <td>82</td>\n",
       "        <td>26</td>\n",
       "        <td>285</td>\n",
       "        <td>32</td>\n",
       "        <td>0.452</td>\n",
       "        <td>58</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>137</td>\n",
       "        <td>61</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>24.2</td>\n",
       "        <td>0.151</td>\n",
       "        <td>55</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>119</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>19.6</td>\n",
       "        <td>0.832</td>\n",
       "        <td>72</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>135</td>\n",
       "        <td>54</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>26.7</td>\n",
       "        <td>0.687</td>\n",
       "        <td>62</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>148</td>\n",
       "        <td>84</td>\n",
       "        <td>48</td>\n",
       "        <td>237</td>\n",
       "        <td>37.6</td>\n",
       "        <td>1.001</td>\n",
       "        <td>51</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>134</td>\n",
       "        <td>74</td>\n",
       "        <td>33</td>\n",
       "        <td>60</td>\n",
       "        <td>25.9</td>\n",
       "        <td>0.46</td>\n",
       "        <td>81</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>137</td>\n",
       "        <td>84</td>\n",
       "        <td>27</td>\n",
       "        <td>0</td>\n",
       "        <td>27.3</td>\n",
       "        <td>0.231</td>\n",
       "        <td>59</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>132</td>\n",
       "        <td>86</td>\n",
       "        <td>31</td>\n",
       "        <td>0</td>\n",
       "        <td>28</td>\n",
       "        <td>0.419</td>\n",
       "        <td>63</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>173</td>\n",
       "        <td>78</td>\n",
       "        <td>32</td>\n",
       "        <td>265</td>\n",
       "        <td>46.5</td>\n",
       "        <td>1.159</td>\n",
       "        <td>58</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>194</td>\n",
       "        <td>80</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>26.1</td>\n",
       "        <td>0.551</td>\n",
       "        <td>67</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>166</td>\n",
       "        <td>74</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>26.6</td>\n",
       "        <td>0.304</td>\n",
       "        <td>66</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>195</td>\n",
       "        <td>70</td>\n",
       "        <td>33</td>\n",
       "        <td>145</td>\n",
       "        <td>25.1</td>\n",
       "        <td>0.163</td>\n",
       "        <td>55</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>120</td>\n",
       "        <td>78</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>25</td>\n",
       "        <td>0.409</td>\n",
       "        <td>64</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>91</td>\n",
       "        <td>68</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>24.2</td>\n",
       "        <td>0.2</td>\n",
       "        <td>58</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>145</td>\n",
       "        <td>88</td>\n",
       "        <td>34</td>\n",
       "        <td>165</td>\n",
       "        <td>30.3</td>\n",
       "        <td>0.771</td>\n",
       "        <td>53</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>125</td>\n",
       "        <td>86</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>37.6</td>\n",
       "        <td>0.304</td>\n",
       "        <td>51</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>129</td>\n",
       "        <td>90</td>\n",
       "        <td>7</td>\n",
       "        <td>326</td>\n",
       "        <td>19.6</td>\n",
       "        <td>0.582</td>\n",
       "        <td>60</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>57</td>\n",
       "        <td>60</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>21.7</td>\n",
       "        <td>0.735</td>\n",
       "        <td>67</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>90</td>\n",
       "        <td>85</td>\n",
       "        <td>32</td>\n",
       "        <td>0</td>\n",
       "        <td>34.9</td>\n",
       "        <td>0.825</td>\n",
       "        <td>56</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>187</td>\n",
       "        <td>76</td>\n",
       "        <td>27</td>\n",
       "        <td>207</td>\n",
       "        <td>43.6</td>\n",
       "        <td>1.034</td>\n",
       "        <td>53</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>114</td>\n",
       "        <td>88</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>27.8</td>\n",
       "        <td>0.247</td>\n",
       "        <td>66</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>110</td>\n",
       "        <td>76</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>27.8</td>\n",
       "        <td>0.237</td>\n",
       "        <td>58</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>125</td>\n",
       "        <td>76</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>33.8</td>\n",
       "        <td>0.121</td>\n",
       "        <td>54</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>197</td>\n",
       "        <td>70</td>\n",
       "        <td>99</td>\n",
       "        <td>0</td>\n",
       "        <td>34.7</td>\n",
       "        <td>0.575</td>\n",
       "        <td>62</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12</td>\n",
       "        <td>121</td>\n",
       "        <td>78</td>\n",
       "        <td>17</td>\n",
       "        <td>0</td>\n",
       "        <td>26.5</td>\n",
       "        <td>0.259</td>\n",
       "        <td>62</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>124</td>\n",
       "        <td>76</td>\n",
       "        <td>24</td>\n",
       "        <td>600</td>\n",
       "        <td>28.7</td>\n",
       "        <td>0.687</td>\n",
       "        <td>52</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>176</td>\n",
       "        <td>86</td>\n",
       "        <td>27</td>\n",
       "        <td>156</td>\n",
       "        <td>33.3</td>\n",
       "        <td>1.154</td>\n",
       "        <td>52</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>150</td>\n",
       "        <td>78</td>\n",
       "        <td>29</td>\n",
       "        <td>126</td>\n",
       "        <td>35.2</td>\n",
       "        <td>0.692</td>\n",
       "        <td>54</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "        <td>127</td>\n",
       "        <td>106</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>39</td>\n",
       "        <td>0.19</td>\n",
       "        <td>51</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>162</td>\n",
       "        <td>84</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>27.7</td>\n",
       "        <td>0.182</td>\n",
       "        <td>54</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>145</td>\n",
       "        <td>82</td>\n",
       "        <td>18</td>\n",
       "        <td>0</td>\n",
       "        <td>32.5</td>\n",
       "        <td>0.235</td>\n",
       "        <td>70</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>91</td>\n",
       "        <td>82</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>35.6</td>\n",
       "        <td>0.587</td>\n",
       "        <td>68</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>156</td>\n",
       "        <td>86</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>24.8</td>\n",
       "        <td>0.23</td>\n",
       "        <td>53</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>136</td>\n",
       "        <td>82</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>0.64</td>\n",
       "        <td>69</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>168</td>\n",
       "        <td>88</td>\n",
       "        <td>29</td>\n",
       "        <td>0</td>\n",
       "        <td>35</td>\n",
       "        <td>0.905</td>\n",
       "        <td>52</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>94</td>\n",
       "        <td>72</td>\n",
       "        <td>18</td>\n",
       "        <td>0</td>\n",
       "        <td>23.1</td>\n",
       "        <td>0.595</td>\n",
       "        <td>56</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>97</td>\n",
       "        <td>76</td>\n",
       "        <td>27</td>\n",
       "        <td>0</td>\n",
       "        <td>35.6</td>\n",
       "        <td>0.378</td>\n",
       "        <td>52</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>105</td>\n",
       "        <td>75</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>23.3</td>\n",
       "        <td>0.56</td>\n",
       "        <td>53</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>123</td>\n",
       "        <td>72</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>36.3</td>\n",
       "        <td>0.258</td>\n",
       "        <td>52</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>190</td>\n",
       "        <td>92</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>35.5</td>\n",
       "        <td>0.278</td>\n",
       "        <td>66</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>101</td>\n",
       "        <td>76</td>\n",
       "        <td>48</td>\n",
       "        <td>180</td>\n",
       "        <td>32.9</td>\n",
       "        <td>0.171</td>\n",
       "        <td>63</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(2, 197, 70, 45, 543, 30.5, 0.158, 53, 1, None),\n",
       " (8, 125, 96, 0, 0, 0, 0.232, 54, 1, None),\n",
       " (10, 139, 80, 0, 0, 27.1, 1.441, 57, 0, None),\n",
       " (1, 189, 60, 23, 846, 30.1, 0.398, 59, 1, None),\n",
       " (5, 166, 72, 19, 175, 25.8, 0.587, 51, 1, None),\n",
       " (11, 143, 94, 33, 146, 36.6, 0.254, 51, 1, None),\n",
       " (13, 145, 82, 19, 110, 22.2, 0.245, 57, 0, None),\n",
       " (5, 109, 75, 26, 0, 36, 0.546, 60, 0, None),\n",
       " (4, 111, 72, 47, 207, 37.1, 1.39, 56, 1, None),\n",
       " (9, 171, 110, 24, 240, 45.4, 0.721, 54, 1, None),\n",
       " (8, 176, 90, 34, 300, 33.7, 0.467, 58, 1, None),\n",
       " (2, 109, 92, 0, 0, 42.7, 0.845, 54, 0, None),\n",
       " (4, 134, 72, 0, 0, 23.8, 0.277, 60, 1, None),\n",
       " (4, 146, 92, 0, 0, 31.2, 0.539, 61, 1, None),\n",
       " (5, 132, 80, 0, 0, 26.8, 0.186, 69, 0, None),\n",
       " (0, 105, 84, 0, 0, 27.9, 0.741, 62, 1, None),\n",
       " (3, 128, 78, 0, 0, 21.1, 0.268, 55, 0, None),\n",
       " (5, 147, 78, 0, 0, 33.7, 0.218, 65, 0, None),\n",
       " (8, 181, 68, 36, 495, 30.1, 0.615, 60, 1, None),\n",
       " (6, 103, 72, 32, 190, 37.7, 0.324, 55, 0, None),\n",
       " (8, 196, 76, 29, 280, 37.5, 0.605, 57, 1, None),\n",
       " (5, 162, 104, 0, 0, 37.7, 0.151, 52, 1, None),\n",
       " (7, 179, 95, 31, 0, 34.2, 0.164, 60, 0, None),\n",
       " (2, 158, 90, 0, 0, 31.6, 0.805, 66, 1, None),\n",
       " (7, 142, 60, 33, 190, 28.8, 0.687, 61, 0, None),\n",
       " (7, 181, 84, 21, 192, 35.9, 0.586, 51, 1, None),\n",
       " (11, 155, 76, 28, 150, 33.3, 1.353, 51, 1, None),\n",
       " (3, 142, 80, 15, 0, 32.4, 0.2, 63, 0, None),\n",
       " (13, 106, 70, 0, 0, 34.2, 0.251, 52, 0, None),\n",
       " (5, 114, 74, 0, 0, 24.9, 0.744, 57, 0, None),\n",
       " (2, 108, 80, 0, 0, 27, 0.259, 52, 1, None),\n",
       " (7, 136, 74, 26, 135, 26, 0.647, 51, 0, None),\n",
       " (0, 161, 50, 0, 0, 21.9, 0.254, 65, 0, None),\n",
       " (8, 112, 72, 0, 0, 23.6, 0.84, 58, 0, None),\n",
       " (6, 194, 78, 0, 0, 23.5, 0.129, 59, 1, None),\n",
       " (8, 95, 72, 0, 0, 36.8, 0.485, 57, 0, None),\n",
       " (5, 158, 70, 0, 0, 29.8, 0.207, 63, 0, None),\n",
       " (5, 103, 108, 37, 0, 39.2, 0.305, 65, 0, None),\n",
       " (4, 146, 78, 0, 0, 38.5, 0.52, 67, 1, None),\n",
       " (12, 140, 82, 43, 325, 39.2, 0.528, 58, 1, None),\n",
       " (5, 144, 82, 26, 285, 32, 0.452, 58, 1, None),\n",
       " (6, 137, 61, 0, 0, 24.2, 0.151, 55, 0, None),\n",
       " (2, 119, 0, 0, 0, 19.6, 0.832, 72, 0, None),\n",
       " (1, 135, 54, 0, 0, 26.7, 0.687, 62, 0, None),\n",
       " (10, 148, 84, 48, 237, 37.6, 1.001, 51, 1, None),\n",
       " (9, 134, 74, 33, 60, 25.9, 0.46, 81, 0, None),\n",
       " (0, 137, 84, 27, 0, 27.3, 0.231, 59, 0, None),\n",
       " (4, 132, 86, 31, 0, 28, 0.419, 63, 0, None),\n",
       " (0, 173, 78, 32, 265, 46.5, 1.159, 58, 0, None),\n",
       " (8, 194, 80, 0, 0, 26.1, 0.551, 67, 0, None),\n",
       " (6, 166, 74, 0, 0, 26.6, 0.304, 66, 0, None),\n",
       " (7, 195, 70, 33, 145, 25.1, 0.163, 55, 1, None),\n",
       " (8, 120, 78, 0, 0, 25, 0.409, 64, 0, None),\n",
       " (9, 91, 68, 0, 0, 24.2, 0.2, 58, 0, None),\n",
       " (9, 145, 88, 34, 165, 30.3, 0.771, 53, 1, None),\n",
       " (7, 125, 86, 0, 0, 37.6, 0.304, 51, 0, None),\n",
       " (6, 129, 90, 7, 326, 19.6, 0.582, 60, 0, None),\n",
       " (0, 57, 60, 0, 0, 21.7, 0.735, 67, 0, None),\n",
       " (10, 90, 85, 32, 0, 34.9, 0.825, 56, 1, None),\n",
       " (5, 187, 76, 27, 207, 43.6, 1.034, 53, 1, None),\n",
       " (6, 114, 88, 0, 0, 27.8, 0.247, 66, 0, None),\n",
       " (8, 110, 76, 0, 0, 27.8, 0.237, 58, 0, None),\n",
       " (6, 125, 76, 0, 0, 33.8, 0.121, 54, 1, None),\n",
       " (2, 197, 70, 99, 0, 34.7, 0.575, 62, 1, None),\n",
       " (12, 121, 78, 17, 0, 26.5, 0.259, 62, 0, None),\n",
       " (8, 124, 76, 24, 600, 28.7, 0.687, 52, 1, None),\n",
       " (3, 176, 86, 27, 156, 33.3, 1.154, 52, 1, None),\n",
       " (7, 150, 78, 29, 126, 35.2, 0.692, 54, 1, None),\n",
       " (11, 127, 106, 0, 0, 39, 0.19, 51, 0, None),\n",
       " (10, 162, 84, 0, 0, 27.7, 0.182, 54, 0, None),\n",
       " (4, 145, 82, 18, 0, 32.5, 0.235, 70, 1, None),\n",
       " (8, 91, 82, 0, 0, 35.6, 0.587, 68, 0, None),\n",
       " (9, 156, 86, 0, 0, 24.8, 0.23, 53, 1, None),\n",
       " (5, 136, 82, 0, 0, 0, 0.64, 69, 0, None),\n",
       " (1, 168, 88, 29, 0, 35, 0.905, 52, 1, None),\n",
       " (10, 94, 72, 18, 0, 23.1, 0.595, 56, 0, None),\n",
       " (5, 97, 76, 27, 0, 35.6, 0.378, 52, 1, None),\n",
       " (2, 105, 75, 0, 0, 23.3, 0.56, 53, 0, None),\n",
       " (0, 123, 72, 0, 0, 36.3, 0.258, 52, 1, None),\n",
       " (6, 190, 92, 0, 0, 35.5, 0.278, 66, 1, None),\n",
       " (10, 101, 76, 48, 180, 32.9, 0.171, 63, 0, None)]"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "\n",
    "SELECT * FROM pacientes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# BMI maior que 30 obeso, menor que 30 normal"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///database/pacientes.db\n",
      "38 rows affected.\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "[]"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "\n",
    "UPDATE pacientes\n",
    "SET Perfil = 'Normal'\n",
    "WHERE BMI < 30;"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///database/pacientes.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>Pregnancies</th>\n",
       "        <th>Glucose</th>\n",
       "        <th>BloodPressure</th>\n",
       "        <th>SkinThickness</th>\n",
       "        <th>Insulin</th>\n",
       "        <th>BMI</th>\n",
       "        <th>DiabetesPedigreeFunction</th>\n",
       "        <th>Age</th>\n",
       "        <th>Outcome</th>\n",
       "        <th>Perfil</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>197</td>\n",
       "        <td>70</td>\n",
       "        <td>45</td>\n",
       "        <td>543</td>\n",
       "        <td>30.5</td>\n",
       "        <td>0.158</td>\n",
       "        <td>53</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>125</td>\n",
       "        <td>96</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>0.232</td>\n",
       "        <td>54</td>\n",
       "        <td>1</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>139</td>\n",
       "        <td>80</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>27.1</td>\n",
       "        <td>1.441</td>\n",
       "        <td>57</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>189</td>\n",
       "        <td>60</td>\n",
       "        <td>23</td>\n",
       "        <td>846</td>\n",
       "        <td>30.1</td>\n",
       "        <td>0.398</td>\n",
       "        <td>59</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>166</td>\n",
       "        <td>72</td>\n",
       "        <td>19</td>\n",
       "        <td>175</td>\n",
       "        <td>25.8</td>\n",
       "        <td>0.587</td>\n",
       "        <td>51</td>\n",
       "        <td>1</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "        <td>143</td>\n",
       "        <td>94</td>\n",
       "        <td>33</td>\n",
       "        <td>146</td>\n",
       "        <td>36.6</td>\n",
       "        <td>0.254</td>\n",
       "        <td>51</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>13</td>\n",
       "        <td>145</td>\n",
       "        <td>82</td>\n",
       "        <td>19</td>\n",
       "        <td>110</td>\n",
       "        <td>22.2</td>\n",
       "        <td>0.245</td>\n",
       "        <td>57</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>109</td>\n",
       "        <td>75</td>\n",
       "        <td>26</td>\n",
       "        <td>0</td>\n",
       "        <td>36</td>\n",
       "        <td>0.546</td>\n",
       "        <td>60</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>111</td>\n",
       "        <td>72</td>\n",
       "        <td>47</td>\n",
       "        <td>207</td>\n",
       "        <td>37.1</td>\n",
       "        <td>1.39</td>\n",
       "        <td>56</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>171</td>\n",
       "        <td>110</td>\n",
       "        <td>24</td>\n",
       "        <td>240</td>\n",
       "        <td>45.4</td>\n",
       "        <td>0.721</td>\n",
       "        <td>54</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>176</td>\n",
       "        <td>90</td>\n",
       "        <td>34</td>\n",
       "        <td>300</td>\n",
       "        <td>33.7</td>\n",
       "        <td>0.467</td>\n",
       "        <td>58</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>109</td>\n",
       "        <td>92</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>42.7</td>\n",
       "        <td>0.845</td>\n",
       "        <td>54</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>134</td>\n",
       "        <td>72</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>23.8</td>\n",
       "        <td>0.277</td>\n",
       "        <td>60</td>\n",
       "        <td>1</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>146</td>\n",
       "        <td>92</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>31.2</td>\n",
       "        <td>0.539</td>\n",
       "        <td>61</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>132</td>\n",
       "        <td>80</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>26.8</td>\n",
       "        <td>0.186</td>\n",
       "        <td>69</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>105</td>\n",
       "        <td>84</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>27.9</td>\n",
       "        <td>0.741</td>\n",
       "        <td>62</td>\n",
       "        <td>1</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>128</td>\n",
       "        <td>78</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>21.1</td>\n",
       "        <td>0.268</td>\n",
       "        <td>55</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>147</td>\n",
       "        <td>78</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>33.7</td>\n",
       "        <td>0.218</td>\n",
       "        <td>65</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>181</td>\n",
       "        <td>68</td>\n",
       "        <td>36</td>\n",
       "        <td>495</td>\n",
       "        <td>30.1</td>\n",
       "        <td>0.615</td>\n",
       "        <td>60</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>103</td>\n",
       "        <td>72</td>\n",
       "        <td>32</td>\n",
       "        <td>190</td>\n",
       "        <td>37.7</td>\n",
       "        <td>0.324</td>\n",
       "        <td>55</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>196</td>\n",
       "        <td>76</td>\n",
       "        <td>29</td>\n",
       "        <td>280</td>\n",
       "        <td>37.5</td>\n",
       "        <td>0.605</td>\n",
       "        <td>57</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>162</td>\n",
       "        <td>104</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>37.7</td>\n",
       "        <td>0.151</td>\n",
       "        <td>52</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>179</td>\n",
       "        <td>95</td>\n",
       "        <td>31</td>\n",
       "        <td>0</td>\n",
       "        <td>34.2</td>\n",
       "        <td>0.164</td>\n",
       "        <td>60</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>158</td>\n",
       "        <td>90</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>31.6</td>\n",
       "        <td>0.805</td>\n",
       "        <td>66</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>142</td>\n",
       "        <td>60</td>\n",
       "        <td>33</td>\n",
       "        <td>190</td>\n",
       "        <td>28.8</td>\n",
       "        <td>0.687</td>\n",
       "        <td>61</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>181</td>\n",
       "        <td>84</td>\n",
       "        <td>21</td>\n",
       "        <td>192</td>\n",
       "        <td>35.9</td>\n",
       "        <td>0.586</td>\n",
       "        <td>51</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "        <td>155</td>\n",
       "        <td>76</td>\n",
       "        <td>28</td>\n",
       "        <td>150</td>\n",
       "        <td>33.3</td>\n",
       "        <td>1.353</td>\n",
       "        <td>51</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>142</td>\n",
       "        <td>80</td>\n",
       "        <td>15</td>\n",
       "        <td>0</td>\n",
       "        <td>32.4</td>\n",
       "        <td>0.2</td>\n",
       "        <td>63</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>13</td>\n",
       "        <td>106</td>\n",
       "        <td>70</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>34.2</td>\n",
       "        <td>0.251</td>\n",
       "        <td>52</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>114</td>\n",
       "        <td>74</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>24.9</td>\n",
       "        <td>0.744</td>\n",
       "        <td>57</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>108</td>\n",
       "        <td>80</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>27</td>\n",
       "        <td>0.259</td>\n",
       "        <td>52</td>\n",
       "        <td>1</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>136</td>\n",
       "        <td>74</td>\n",
       "        <td>26</td>\n",
       "        <td>135</td>\n",
       "        <td>26</td>\n",
       "        <td>0.647</td>\n",
       "        <td>51</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>161</td>\n",
       "        <td>50</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>21.9</td>\n",
       "        <td>0.254</td>\n",
       "        <td>65</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>112</td>\n",
       "        <td>72</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>23.6</td>\n",
       "        <td>0.84</td>\n",
       "        <td>58</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>194</td>\n",
       "        <td>78</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>23.5</td>\n",
       "        <td>0.129</td>\n",
       "        <td>59</td>\n",
       "        <td>1</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>95</td>\n",
       "        <td>72</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>36.8</td>\n",
       "        <td>0.485</td>\n",
       "        <td>57</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>158</td>\n",
       "        <td>70</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>29.8</td>\n",
       "        <td>0.207</td>\n",
       "        <td>63</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>103</td>\n",
       "        <td>108</td>\n",
       "        <td>37</td>\n",
       "        <td>0</td>\n",
       "        <td>39.2</td>\n",
       "        <td>0.305</td>\n",
       "        <td>65</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>146</td>\n",
       "        <td>78</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>38.5</td>\n",
       "        <td>0.52</td>\n",
       "        <td>67</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12</td>\n",
       "        <td>140</td>\n",
       "        <td>82</td>\n",
       "        <td>43</td>\n",
       "        <td>325</td>\n",
       "        <td>39.2</td>\n",
       "        <td>0.528</td>\n",
       "        <td>58</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>144</td>\n",
       "        <td>82</td>\n",
       "        <td>26</td>\n",
       "        <td>285</td>\n",
       "        <td>32</td>\n",
       "        <td>0.452</td>\n",
       "        <td>58</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>137</td>\n",
       "        <td>61</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>24.2</td>\n",
       "        <td>0.151</td>\n",
       "        <td>55</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>119</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>19.6</td>\n",
       "        <td>0.832</td>\n",
       "        <td>72</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>135</td>\n",
       "        <td>54</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>26.7</td>\n",
       "        <td>0.687</td>\n",
       "        <td>62</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>148</td>\n",
       "        <td>84</td>\n",
       "        <td>48</td>\n",
       "        <td>237</td>\n",
       "        <td>37.6</td>\n",
       "        <td>1.001</td>\n",
       "        <td>51</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>134</td>\n",
       "        <td>74</td>\n",
       "        <td>33</td>\n",
       "        <td>60</td>\n",
       "        <td>25.9</td>\n",
       "        <td>0.46</td>\n",
       "        <td>81</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>137</td>\n",
       "        <td>84</td>\n",
       "        <td>27</td>\n",
       "        <td>0</td>\n",
       "        <td>27.3</td>\n",
       "        <td>0.231</td>\n",
       "        <td>59</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>132</td>\n",
       "        <td>86</td>\n",
       "        <td>31</td>\n",
       "        <td>0</td>\n",
       "        <td>28</td>\n",
       "        <td>0.419</td>\n",
       "        <td>63</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>173</td>\n",
       "        <td>78</td>\n",
       "        <td>32</td>\n",
       "        <td>265</td>\n",
       "        <td>46.5</td>\n",
       "        <td>1.159</td>\n",
       "        <td>58</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>194</td>\n",
       "        <td>80</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>26.1</td>\n",
       "        <td>0.551</td>\n",
       "        <td>67</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>166</td>\n",
       "        <td>74</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>26.6</td>\n",
       "        <td>0.304</td>\n",
       "        <td>66</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>195</td>\n",
       "        <td>70</td>\n",
       "        <td>33</td>\n",
       "        <td>145</td>\n",
       "        <td>25.1</td>\n",
       "        <td>0.163</td>\n",
       "        <td>55</td>\n",
       "        <td>1</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>120</td>\n",
       "        <td>78</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>25</td>\n",
       "        <td>0.409</td>\n",
       "        <td>64</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>91</td>\n",
       "        <td>68</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>24.2</td>\n",
       "        <td>0.2</td>\n",
       "        <td>58</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>145</td>\n",
       "        <td>88</td>\n",
       "        <td>34</td>\n",
       "        <td>165</td>\n",
       "        <td>30.3</td>\n",
       "        <td>0.771</td>\n",
       "        <td>53</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>125</td>\n",
       "        <td>86</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>37.6</td>\n",
       "        <td>0.304</td>\n",
       "        <td>51</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>129</td>\n",
       "        <td>90</td>\n",
       "        <td>7</td>\n",
       "        <td>326</td>\n",
       "        <td>19.6</td>\n",
       "        <td>0.582</td>\n",
       "        <td>60</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>57</td>\n",
       "        <td>60</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>21.7</td>\n",
       "        <td>0.735</td>\n",
       "        <td>67</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>90</td>\n",
       "        <td>85</td>\n",
       "        <td>32</td>\n",
       "        <td>0</td>\n",
       "        <td>34.9</td>\n",
       "        <td>0.825</td>\n",
       "        <td>56</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>187</td>\n",
       "        <td>76</td>\n",
       "        <td>27</td>\n",
       "        <td>207</td>\n",
       "        <td>43.6</td>\n",
       "        <td>1.034</td>\n",
       "        <td>53</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>114</td>\n",
       "        <td>88</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>27.8</td>\n",
       "        <td>0.247</td>\n",
       "        <td>66</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>110</td>\n",
       "        <td>76</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>27.8</td>\n",
       "        <td>0.237</td>\n",
       "        <td>58</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>125</td>\n",
       "        <td>76</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>33.8</td>\n",
       "        <td>0.121</td>\n",
       "        <td>54</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>197</td>\n",
       "        <td>70</td>\n",
       "        <td>99</td>\n",
       "        <td>0</td>\n",
       "        <td>34.7</td>\n",
       "        <td>0.575</td>\n",
       "        <td>62</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12</td>\n",
       "        <td>121</td>\n",
       "        <td>78</td>\n",
       "        <td>17</td>\n",
       "        <td>0</td>\n",
       "        <td>26.5</td>\n",
       "        <td>0.259</td>\n",
       "        <td>62</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>124</td>\n",
       "        <td>76</td>\n",
       "        <td>24</td>\n",
       "        <td>600</td>\n",
       "        <td>28.7</td>\n",
       "        <td>0.687</td>\n",
       "        <td>52</td>\n",
       "        <td>1</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>176</td>\n",
       "        <td>86</td>\n",
       "        <td>27</td>\n",
       "        <td>156</td>\n",
       "        <td>33.3</td>\n",
       "        <td>1.154</td>\n",
       "        <td>52</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>150</td>\n",
       "        <td>78</td>\n",
       "        <td>29</td>\n",
       "        <td>126</td>\n",
       "        <td>35.2</td>\n",
       "        <td>0.692</td>\n",
       "        <td>54</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "        <td>127</td>\n",
       "        <td>106</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>39</td>\n",
       "        <td>0.19</td>\n",
       "        <td>51</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>162</td>\n",
       "        <td>84</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>27.7</td>\n",
       "        <td>0.182</td>\n",
       "        <td>54</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>145</td>\n",
       "        <td>82</td>\n",
       "        <td>18</td>\n",
       "        <td>0</td>\n",
       "        <td>32.5</td>\n",
       "        <td>0.235</td>\n",
       "        <td>70</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>91</td>\n",
       "        <td>82</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>35.6</td>\n",
       "        <td>0.587</td>\n",
       "        <td>68</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>156</td>\n",
       "        <td>86</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>24.8</td>\n",
       "        <td>0.23</td>\n",
       "        <td>53</td>\n",
       "        <td>1</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>136</td>\n",
       "        <td>82</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>0.64</td>\n",
       "        <td>69</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>168</td>\n",
       "        <td>88</td>\n",
       "        <td>29</td>\n",
       "        <td>0</td>\n",
       "        <td>35</td>\n",
       "        <td>0.905</td>\n",
       "        <td>52</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>94</td>\n",
       "        <td>72</td>\n",
       "        <td>18</td>\n",
       "        <td>0</td>\n",
       "        <td>23.1</td>\n",
       "        <td>0.595</td>\n",
       "        <td>56</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>97</td>\n",
       "        <td>76</td>\n",
       "        <td>27</td>\n",
       "        <td>0</td>\n",
       "        <td>35.6</td>\n",
       "        <td>0.378</td>\n",
       "        <td>52</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>105</td>\n",
       "        <td>75</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>23.3</td>\n",
       "        <td>0.56</td>\n",
       "        <td>53</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>123</td>\n",
       "        <td>72</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>36.3</td>\n",
       "        <td>0.258</td>\n",
       "        <td>52</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>190</td>\n",
       "        <td>92</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>35.5</td>\n",
       "        <td>0.278</td>\n",
       "        <td>66</td>\n",
       "        <td>1</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>101</td>\n",
       "        <td>76</td>\n",
       "        <td>48</td>\n",
       "        <td>180</td>\n",
       "        <td>32.9</td>\n",
       "        <td>0.171</td>\n",
       "        <td>63</td>\n",
       "        <td>0</td>\n",
       "        <td>None</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(2, 197, 70, 45, 543, 30.5, 0.158, 53, 1, None),\n",
       " (8, 125, 96, 0, 0, 0, 0.232, 54, 1, 'Normal'),\n",
       " (10, 139, 80, 0, 0, 27.1, 1.441, 57, 0, 'Normal'),\n",
       " (1, 189, 60, 23, 846, 30.1, 0.398, 59, 1, None),\n",
       " (5, 166, 72, 19, 175, 25.8, 0.587, 51, 1, 'Normal'),\n",
       " (11, 143, 94, 33, 146, 36.6, 0.254, 51, 1, None),\n",
       " (13, 145, 82, 19, 110, 22.2, 0.245, 57, 0, 'Normal'),\n",
       " (5, 109, 75, 26, 0, 36, 0.546, 60, 0, None),\n",
       " (4, 111, 72, 47, 207, 37.1, 1.39, 56, 1, None),\n",
       " (9, 171, 110, 24, 240, 45.4, 0.721, 54, 1, None),\n",
       " (8, 176, 90, 34, 300, 33.7, 0.467, 58, 1, None),\n",
       " (2, 109, 92, 0, 0, 42.7, 0.845, 54, 0, None),\n",
       " (4, 134, 72, 0, 0, 23.8, 0.277, 60, 1, 'Normal'),\n",
       " (4, 146, 92, 0, 0, 31.2, 0.539, 61, 1, None),\n",
       " (5, 132, 80, 0, 0, 26.8, 0.186, 69, 0, 'Normal'),\n",
       " (0, 105, 84, 0, 0, 27.9, 0.741, 62, 1, 'Normal'),\n",
       " (3, 128, 78, 0, 0, 21.1, 0.268, 55, 0, 'Normal'),\n",
       " (5, 147, 78, 0, 0, 33.7, 0.218, 65, 0, None),\n",
       " (8, 181, 68, 36, 495, 30.1, 0.615, 60, 1, None),\n",
       " (6, 103, 72, 32, 190, 37.7, 0.324, 55, 0, None),\n",
       " (8, 196, 76, 29, 280, 37.5, 0.605, 57, 1, None),\n",
       " (5, 162, 104, 0, 0, 37.7, 0.151, 52, 1, None),\n",
       " (7, 179, 95, 31, 0, 34.2, 0.164, 60, 0, None),\n",
       " (2, 158, 90, 0, 0, 31.6, 0.805, 66, 1, None),\n",
       " (7, 142, 60, 33, 190, 28.8, 0.687, 61, 0, 'Normal'),\n",
       " (7, 181, 84, 21, 192, 35.9, 0.586, 51, 1, None),\n",
       " (11, 155, 76, 28, 150, 33.3, 1.353, 51, 1, None),\n",
       " (3, 142, 80, 15, 0, 32.4, 0.2, 63, 0, None),\n",
       " (13, 106, 70, 0, 0, 34.2, 0.251, 52, 0, None),\n",
       " (5, 114, 74, 0, 0, 24.9, 0.744, 57, 0, 'Normal'),\n",
       " (2, 108, 80, 0, 0, 27, 0.259, 52, 1, 'Normal'),\n",
       " (7, 136, 74, 26, 135, 26, 0.647, 51, 0, 'Normal'),\n",
       " (0, 161, 50, 0, 0, 21.9, 0.254, 65, 0, 'Normal'),\n",
       " (8, 112, 72, 0, 0, 23.6, 0.84, 58, 0, 'Normal'),\n",
       " (6, 194, 78, 0, 0, 23.5, 0.129, 59, 1, 'Normal'),\n",
       " (8, 95, 72, 0, 0, 36.8, 0.485, 57, 0, None),\n",
       " (5, 158, 70, 0, 0, 29.8, 0.207, 63, 0, 'Normal'),\n",
       " (5, 103, 108, 37, 0, 39.2, 0.305, 65, 0, None),\n",
       " (4, 146, 78, 0, 0, 38.5, 0.52, 67, 1, None),\n",
       " (12, 140, 82, 43, 325, 39.2, 0.528, 58, 1, None),\n",
       " (5, 144, 82, 26, 285, 32, 0.452, 58, 1, None),\n",
       " (6, 137, 61, 0, 0, 24.2, 0.151, 55, 0, 'Normal'),\n",
       " (2, 119, 0, 0, 0, 19.6, 0.832, 72, 0, 'Normal'),\n",
       " (1, 135, 54, 0, 0, 26.7, 0.687, 62, 0, 'Normal'),\n",
       " (10, 148, 84, 48, 237, 37.6, 1.001, 51, 1, None),\n",
       " (9, 134, 74, 33, 60, 25.9, 0.46, 81, 0, 'Normal'),\n",
       " (0, 137, 84, 27, 0, 27.3, 0.231, 59, 0, 'Normal'),\n",
       " (4, 132, 86, 31, 0, 28, 0.419, 63, 0, 'Normal'),\n",
       " (0, 173, 78, 32, 265, 46.5, 1.159, 58, 0, None),\n",
       " (8, 194, 80, 0, 0, 26.1, 0.551, 67, 0, 'Normal'),\n",
       " (6, 166, 74, 0, 0, 26.6, 0.304, 66, 0, 'Normal'),\n",
       " (7, 195, 70, 33, 145, 25.1, 0.163, 55, 1, 'Normal'),\n",
       " (8, 120, 78, 0, 0, 25, 0.409, 64, 0, 'Normal'),\n",
       " (9, 91, 68, 0, 0, 24.2, 0.2, 58, 0, 'Normal'),\n",
       " (9, 145, 88, 34, 165, 30.3, 0.771, 53, 1, None),\n",
       " (7, 125, 86, 0, 0, 37.6, 0.304, 51, 0, None),\n",
       " (6, 129, 90, 7, 326, 19.6, 0.582, 60, 0, 'Normal'),\n",
       " (0, 57, 60, 0, 0, 21.7, 0.735, 67, 0, 'Normal'),\n",
       " (10, 90, 85, 32, 0, 34.9, 0.825, 56, 1, None),\n",
       " (5, 187, 76, 27, 207, 43.6, 1.034, 53, 1, None),\n",
       " (6, 114, 88, 0, 0, 27.8, 0.247, 66, 0, 'Normal'),\n",
       " (8, 110, 76, 0, 0, 27.8, 0.237, 58, 0, 'Normal'),\n",
       " (6, 125, 76, 0, 0, 33.8, 0.121, 54, 1, None),\n",
       " (2, 197, 70, 99, 0, 34.7, 0.575, 62, 1, None),\n",
       " (12, 121, 78, 17, 0, 26.5, 0.259, 62, 0, 'Normal'),\n",
       " (8, 124, 76, 24, 600, 28.7, 0.687, 52, 1, 'Normal'),\n",
       " (3, 176, 86, 27, 156, 33.3, 1.154, 52, 1, None),\n",
       " (7, 150, 78, 29, 126, 35.2, 0.692, 54, 1, None),\n",
       " (11, 127, 106, 0, 0, 39, 0.19, 51, 0, None),\n",
       " (10, 162, 84, 0, 0, 27.7, 0.182, 54, 0, 'Normal'),\n",
       " (4, 145, 82, 18, 0, 32.5, 0.235, 70, 1, None),\n",
       " (8, 91, 82, 0, 0, 35.6, 0.587, 68, 0, None),\n",
       " (9, 156, 86, 0, 0, 24.8, 0.23, 53, 1, 'Normal'),\n",
       " (5, 136, 82, 0, 0, 0, 0.64, 69, 0, 'Normal'),\n",
       " (1, 168, 88, 29, 0, 35, 0.905, 52, 1, None),\n",
       " (10, 94, 72, 18, 0, 23.1, 0.595, 56, 0, 'Normal'),\n",
       " (5, 97, 76, 27, 0, 35.6, 0.378, 52, 1, None),\n",
       " (2, 105, 75, 0, 0, 23.3, 0.56, 53, 0, 'Normal'),\n",
       " (0, 123, 72, 0, 0, 36.3, 0.258, 52, 1, None),\n",
       " (6, 190, 92, 0, 0, 35.5, 0.278, 66, 1, None),\n",
       " (10, 101, 76, 48, 180, 32.9, 0.171, 63, 0, None)]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "\n",
    "SELECT * FROM pacientes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///database/pacientes.db\n",
      "43 rows affected.\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "[]"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "\n",
    "UPDATE pacientes\n",
    "SET Perfil = 'Obeso'\n",
    "WHERE BMI >= 30;"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///database/pacientes.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "    <tr>\n",
       "        <th>Pregnancies</th>\n",
       "        <th>Glucose</th>\n",
       "        <th>BloodPressure</th>\n",
       "        <th>SkinThickness</th>\n",
       "        <th>Insulin</th>\n",
       "        <th>BMI</th>\n",
       "        <th>DiabetesPedigreeFunction</th>\n",
       "        <th>Age</th>\n",
       "        <th>Outcome</th>\n",
       "        <th>Perfil</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>197</td>\n",
       "        <td>70</td>\n",
       "        <td>45</td>\n",
       "        <td>543</td>\n",
       "        <td>30.5</td>\n",
       "        <td>0.158</td>\n",
       "        <td>53</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>125</td>\n",
       "        <td>96</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>0.232</td>\n",
       "        <td>54</td>\n",
       "        <td>1</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>139</td>\n",
       "        <td>80</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>27.1</td>\n",
       "        <td>1.441</td>\n",
       "        <td>57</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>189</td>\n",
       "        <td>60</td>\n",
       "        <td>23</td>\n",
       "        <td>846</td>\n",
       "        <td>30.1</td>\n",
       "        <td>0.398</td>\n",
       "        <td>59</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>166</td>\n",
       "        <td>72</td>\n",
       "        <td>19</td>\n",
       "        <td>175</td>\n",
       "        <td>25.8</td>\n",
       "        <td>0.587</td>\n",
       "        <td>51</td>\n",
       "        <td>1</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "        <td>143</td>\n",
       "        <td>94</td>\n",
       "        <td>33</td>\n",
       "        <td>146</td>\n",
       "        <td>36.6</td>\n",
       "        <td>0.254</td>\n",
       "        <td>51</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>13</td>\n",
       "        <td>145</td>\n",
       "        <td>82</td>\n",
       "        <td>19</td>\n",
       "        <td>110</td>\n",
       "        <td>22.2</td>\n",
       "        <td>0.245</td>\n",
       "        <td>57</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>109</td>\n",
       "        <td>75</td>\n",
       "        <td>26</td>\n",
       "        <td>0</td>\n",
       "        <td>36</td>\n",
       "        <td>0.546</td>\n",
       "        <td>60</td>\n",
       "        <td>0</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>111</td>\n",
       "        <td>72</td>\n",
       "        <td>47</td>\n",
       "        <td>207</td>\n",
       "        <td>37.1</td>\n",
       "        <td>1.39</td>\n",
       "        <td>56</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>171</td>\n",
       "        <td>110</td>\n",
       "        <td>24</td>\n",
       "        <td>240</td>\n",
       "        <td>45.4</td>\n",
       "        <td>0.721</td>\n",
       "        <td>54</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>176</td>\n",
       "        <td>90</td>\n",
       "        <td>34</td>\n",
       "        <td>300</td>\n",
       "        <td>33.7</td>\n",
       "        <td>0.467</td>\n",
       "        <td>58</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>109</td>\n",
       "        <td>92</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>42.7</td>\n",
       "        <td>0.845</td>\n",
       "        <td>54</td>\n",
       "        <td>0</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>134</td>\n",
       "        <td>72</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>23.8</td>\n",
       "        <td>0.277</td>\n",
       "        <td>60</td>\n",
       "        <td>1</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>146</td>\n",
       "        <td>92</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>31.2</td>\n",
       "        <td>0.539</td>\n",
       "        <td>61</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>132</td>\n",
       "        <td>80</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>26.8</td>\n",
       "        <td>0.186</td>\n",
       "        <td>69</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>105</td>\n",
       "        <td>84</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>27.9</td>\n",
       "        <td>0.741</td>\n",
       "        <td>62</td>\n",
       "        <td>1</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>128</td>\n",
       "        <td>78</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>21.1</td>\n",
       "        <td>0.268</td>\n",
       "        <td>55</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>147</td>\n",
       "        <td>78</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>33.7</td>\n",
       "        <td>0.218</td>\n",
       "        <td>65</td>\n",
       "        <td>0</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>181</td>\n",
       "        <td>68</td>\n",
       "        <td>36</td>\n",
       "        <td>495</td>\n",
       "        <td>30.1</td>\n",
       "        <td>0.615</td>\n",
       "        <td>60</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>103</td>\n",
       "        <td>72</td>\n",
       "        <td>32</td>\n",
       "        <td>190</td>\n",
       "        <td>37.7</td>\n",
       "        <td>0.324</td>\n",
       "        <td>55</td>\n",
       "        <td>0</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>196</td>\n",
       "        <td>76</td>\n",
       "        <td>29</td>\n",
       "        <td>280</td>\n",
       "        <td>37.5</td>\n",
       "        <td>0.605</td>\n",
       "        <td>57</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>162</td>\n",
       "        <td>104</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>37.7</td>\n",
       "        <td>0.151</td>\n",
       "        <td>52</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>179</td>\n",
       "        <td>95</td>\n",
       "        <td>31</td>\n",
       "        <td>0</td>\n",
       "        <td>34.2</td>\n",
       "        <td>0.164</td>\n",
       "        <td>60</td>\n",
       "        <td>0</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>158</td>\n",
       "        <td>90</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>31.6</td>\n",
       "        <td>0.805</td>\n",
       "        <td>66</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>142</td>\n",
       "        <td>60</td>\n",
       "        <td>33</td>\n",
       "        <td>190</td>\n",
       "        <td>28.8</td>\n",
       "        <td>0.687</td>\n",
       "        <td>61</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>181</td>\n",
       "        <td>84</td>\n",
       "        <td>21</td>\n",
       "        <td>192</td>\n",
       "        <td>35.9</td>\n",
       "        <td>0.586</td>\n",
       "        <td>51</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "        <td>155</td>\n",
       "        <td>76</td>\n",
       "        <td>28</td>\n",
       "        <td>150</td>\n",
       "        <td>33.3</td>\n",
       "        <td>1.353</td>\n",
       "        <td>51</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>142</td>\n",
       "        <td>80</td>\n",
       "        <td>15</td>\n",
       "        <td>0</td>\n",
       "        <td>32.4</td>\n",
       "        <td>0.2</td>\n",
       "        <td>63</td>\n",
       "        <td>0</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>13</td>\n",
       "        <td>106</td>\n",
       "        <td>70</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>34.2</td>\n",
       "        <td>0.251</td>\n",
       "        <td>52</td>\n",
       "        <td>0</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>114</td>\n",
       "        <td>74</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>24.9</td>\n",
       "        <td>0.744</td>\n",
       "        <td>57</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>108</td>\n",
       "        <td>80</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>27</td>\n",
       "        <td>0.259</td>\n",
       "        <td>52</td>\n",
       "        <td>1</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>136</td>\n",
       "        <td>74</td>\n",
       "        <td>26</td>\n",
       "        <td>135</td>\n",
       "        <td>26</td>\n",
       "        <td>0.647</td>\n",
       "        <td>51</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>161</td>\n",
       "        <td>50</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>21.9</td>\n",
       "        <td>0.254</td>\n",
       "        <td>65</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>112</td>\n",
       "        <td>72</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>23.6</td>\n",
       "        <td>0.84</td>\n",
       "        <td>58</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>194</td>\n",
       "        <td>78</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>23.5</td>\n",
       "        <td>0.129</td>\n",
       "        <td>59</td>\n",
       "        <td>1</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>95</td>\n",
       "        <td>72</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>36.8</td>\n",
       "        <td>0.485</td>\n",
       "        <td>57</td>\n",
       "        <td>0</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>158</td>\n",
       "        <td>70</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>29.8</td>\n",
       "        <td>0.207</td>\n",
       "        <td>63</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>103</td>\n",
       "        <td>108</td>\n",
       "        <td>37</td>\n",
       "        <td>0</td>\n",
       "        <td>39.2</td>\n",
       "        <td>0.305</td>\n",
       "        <td>65</td>\n",
       "        <td>0</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>146</td>\n",
       "        <td>78</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>38.5</td>\n",
       "        <td>0.52</td>\n",
       "        <td>67</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12</td>\n",
       "        <td>140</td>\n",
       "        <td>82</td>\n",
       "        <td>43</td>\n",
       "        <td>325</td>\n",
       "        <td>39.2</td>\n",
       "        <td>0.528</td>\n",
       "        <td>58</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>144</td>\n",
       "        <td>82</td>\n",
       "        <td>26</td>\n",
       "        <td>285</td>\n",
       "        <td>32</td>\n",
       "        <td>0.452</td>\n",
       "        <td>58</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>137</td>\n",
       "        <td>61</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>24.2</td>\n",
       "        <td>0.151</td>\n",
       "        <td>55</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>119</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>19.6</td>\n",
       "        <td>0.832</td>\n",
       "        <td>72</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>135</td>\n",
       "        <td>54</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>26.7</td>\n",
       "        <td>0.687</td>\n",
       "        <td>62</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>148</td>\n",
       "        <td>84</td>\n",
       "        <td>48</td>\n",
       "        <td>237</td>\n",
       "        <td>37.6</td>\n",
       "        <td>1.001</td>\n",
       "        <td>51</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>134</td>\n",
       "        <td>74</td>\n",
       "        <td>33</td>\n",
       "        <td>60</td>\n",
       "        <td>25.9</td>\n",
       "        <td>0.46</td>\n",
       "        <td>81</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>137</td>\n",
       "        <td>84</td>\n",
       "        <td>27</td>\n",
       "        <td>0</td>\n",
       "        <td>27.3</td>\n",
       "        <td>0.231</td>\n",
       "        <td>59</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>132</td>\n",
       "        <td>86</td>\n",
       "        <td>31</td>\n",
       "        <td>0</td>\n",
       "        <td>28</td>\n",
       "        <td>0.419</td>\n",
       "        <td>63</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>173</td>\n",
       "        <td>78</td>\n",
       "        <td>32</td>\n",
       "        <td>265</td>\n",
       "        <td>46.5</td>\n",
       "        <td>1.159</td>\n",
       "        <td>58</td>\n",
       "        <td>0</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>194</td>\n",
       "        <td>80</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>26.1</td>\n",
       "        <td>0.551</td>\n",
       "        <td>67</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>166</td>\n",
       "        <td>74</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>26.6</td>\n",
       "        <td>0.304</td>\n",
       "        <td>66</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>195</td>\n",
       "        <td>70</td>\n",
       "        <td>33</td>\n",
       "        <td>145</td>\n",
       "        <td>25.1</td>\n",
       "        <td>0.163</td>\n",
       "        <td>55</td>\n",
       "        <td>1</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>120</td>\n",
       "        <td>78</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>25</td>\n",
       "        <td>0.409</td>\n",
       "        <td>64</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>91</td>\n",
       "        <td>68</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>24.2</td>\n",
       "        <td>0.2</td>\n",
       "        <td>58</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>145</td>\n",
       "        <td>88</td>\n",
       "        <td>34</td>\n",
       "        <td>165</td>\n",
       "        <td>30.3</td>\n",
       "        <td>0.771</td>\n",
       "        <td>53</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>125</td>\n",
       "        <td>86</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>37.6</td>\n",
       "        <td>0.304</td>\n",
       "        <td>51</td>\n",
       "        <td>0</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>129</td>\n",
       "        <td>90</td>\n",
       "        <td>7</td>\n",
       "        <td>326</td>\n",
       "        <td>19.6</td>\n",
       "        <td>0.582</td>\n",
       "        <td>60</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>57</td>\n",
       "        <td>60</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>21.7</td>\n",
       "        <td>0.735</td>\n",
       "        <td>67</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>90</td>\n",
       "        <td>85</td>\n",
       "        <td>32</td>\n",
       "        <td>0</td>\n",
       "        <td>34.9</td>\n",
       "        <td>0.825</td>\n",
       "        <td>56</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>187</td>\n",
       "        <td>76</td>\n",
       "        <td>27</td>\n",
       "        <td>207</td>\n",
       "        <td>43.6</td>\n",
       "        <td>1.034</td>\n",
       "        <td>53</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>114</td>\n",
       "        <td>88</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>27.8</td>\n",
       "        <td>0.247</td>\n",
       "        <td>66</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>110</td>\n",
       "        <td>76</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>27.8</td>\n",
       "        <td>0.237</td>\n",
       "        <td>58</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>125</td>\n",
       "        <td>76</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>33.8</td>\n",
       "        <td>0.121</td>\n",
       "        <td>54</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>197</td>\n",
       "        <td>70</td>\n",
       "        <td>99</td>\n",
       "        <td>0</td>\n",
       "        <td>34.7</td>\n",
       "        <td>0.575</td>\n",
       "        <td>62</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>12</td>\n",
       "        <td>121</td>\n",
       "        <td>78</td>\n",
       "        <td>17</td>\n",
       "        <td>0</td>\n",
       "        <td>26.5</td>\n",
       "        <td>0.259</td>\n",
       "        <td>62</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>124</td>\n",
       "        <td>76</td>\n",
       "        <td>24</td>\n",
       "        <td>600</td>\n",
       "        <td>28.7</td>\n",
       "        <td>0.687</td>\n",
       "        <td>52</td>\n",
       "        <td>1</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>3</td>\n",
       "        <td>176</td>\n",
       "        <td>86</td>\n",
       "        <td>27</td>\n",
       "        <td>156</td>\n",
       "        <td>33.3</td>\n",
       "        <td>1.154</td>\n",
       "        <td>52</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>7</td>\n",
       "        <td>150</td>\n",
       "        <td>78</td>\n",
       "        <td>29</td>\n",
       "        <td>126</td>\n",
       "        <td>35.2</td>\n",
       "        <td>0.692</td>\n",
       "        <td>54</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>11</td>\n",
       "        <td>127</td>\n",
       "        <td>106</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>39</td>\n",
       "        <td>0.19</td>\n",
       "        <td>51</td>\n",
       "        <td>0</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>162</td>\n",
       "        <td>84</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>27.7</td>\n",
       "        <td>0.182</td>\n",
       "        <td>54</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>4</td>\n",
       "        <td>145</td>\n",
       "        <td>82</td>\n",
       "        <td>18</td>\n",
       "        <td>0</td>\n",
       "        <td>32.5</td>\n",
       "        <td>0.235</td>\n",
       "        <td>70</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>8</td>\n",
       "        <td>91</td>\n",
       "        <td>82</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>35.6</td>\n",
       "        <td>0.587</td>\n",
       "        <td>68</td>\n",
       "        <td>0</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>9</td>\n",
       "        <td>156</td>\n",
       "        <td>86</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>24.8</td>\n",
       "        <td>0.23</td>\n",
       "        <td>53</td>\n",
       "        <td>1</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>136</td>\n",
       "        <td>82</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>0.64</td>\n",
       "        <td>69</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>1</td>\n",
       "        <td>168</td>\n",
       "        <td>88</td>\n",
       "        <td>29</td>\n",
       "        <td>0</td>\n",
       "        <td>35</td>\n",
       "        <td>0.905</td>\n",
       "        <td>52</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>94</td>\n",
       "        <td>72</td>\n",
       "        <td>18</td>\n",
       "        <td>0</td>\n",
       "        <td>23.1</td>\n",
       "        <td>0.595</td>\n",
       "        <td>56</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>5</td>\n",
       "        <td>97</td>\n",
       "        <td>76</td>\n",
       "        <td>27</td>\n",
       "        <td>0</td>\n",
       "        <td>35.6</td>\n",
       "        <td>0.378</td>\n",
       "        <td>52</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>2</td>\n",
       "        <td>105</td>\n",
       "        <td>75</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>23.3</td>\n",
       "        <td>0.56</td>\n",
       "        <td>53</td>\n",
       "        <td>0</td>\n",
       "        <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>0</td>\n",
       "        <td>123</td>\n",
       "        <td>72</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>36.3</td>\n",
       "        <td>0.258</td>\n",
       "        <td>52</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>6</td>\n",
       "        <td>190</td>\n",
       "        <td>92</td>\n",
       "        <td>0</td>\n",
       "        <td>0</td>\n",
       "        <td>35.5</td>\n",
       "        <td>0.278</td>\n",
       "        <td>66</td>\n",
       "        <td>1</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "        <td>10</td>\n",
       "        <td>101</td>\n",
       "        <td>76</td>\n",
       "        <td>48</td>\n",
       "        <td>180</td>\n",
       "        <td>32.9</td>\n",
       "        <td>0.171</td>\n",
       "        <td>63</td>\n",
       "        <td>0</td>\n",
       "        <td>Obeso</td>\n",
       "    </tr>\n",
       "</table>"
      ],
      "text/plain": [
       "[(2, 197, 70, 45, 543, 30.5, 0.158, 53, 1, 'Obeso'),\n",
       " (8, 125, 96, 0, 0, 0, 0.232, 54, 1, 'Normal'),\n",
       " (10, 139, 80, 0, 0, 27.1, 1.441, 57, 0, 'Normal'),\n",
       " (1, 189, 60, 23, 846, 30.1, 0.398, 59, 1, 'Obeso'),\n",
       " (5, 166, 72, 19, 175, 25.8, 0.587, 51, 1, 'Normal'),\n",
       " (11, 143, 94, 33, 146, 36.6, 0.254, 51, 1, 'Obeso'),\n",
       " (13, 145, 82, 19, 110, 22.2, 0.245, 57, 0, 'Normal'),\n",
       " (5, 109, 75, 26, 0, 36, 0.546, 60, 0, 'Obeso'),\n",
       " (4, 111, 72, 47, 207, 37.1, 1.39, 56, 1, 'Obeso'),\n",
       " (9, 171, 110, 24, 240, 45.4, 0.721, 54, 1, 'Obeso'),\n",
       " (8, 176, 90, 34, 300, 33.7, 0.467, 58, 1, 'Obeso'),\n",
       " (2, 109, 92, 0, 0, 42.7, 0.845, 54, 0, 'Obeso'),\n",
       " (4, 134, 72, 0, 0, 23.8, 0.277, 60, 1, 'Normal'),\n",
       " (4, 146, 92, 0, 0, 31.2, 0.539, 61, 1, 'Obeso'),\n",
       " (5, 132, 80, 0, 0, 26.8, 0.186, 69, 0, 'Normal'),\n",
       " (0, 105, 84, 0, 0, 27.9, 0.741, 62, 1, 'Normal'),\n",
       " (3, 128, 78, 0, 0, 21.1, 0.268, 55, 0, 'Normal'),\n",
       " (5, 147, 78, 0, 0, 33.7, 0.218, 65, 0, 'Obeso'),\n",
       " (8, 181, 68, 36, 495, 30.1, 0.615, 60, 1, 'Obeso'),\n",
       " (6, 103, 72, 32, 190, 37.7, 0.324, 55, 0, 'Obeso'),\n",
       " (8, 196, 76, 29, 280, 37.5, 0.605, 57, 1, 'Obeso'),\n",
       " (5, 162, 104, 0, 0, 37.7, 0.151, 52, 1, 'Obeso'),\n",
       " (7, 179, 95, 31, 0, 34.2, 0.164, 60, 0, 'Obeso'),\n",
       " (2, 158, 90, 0, 0, 31.6, 0.805, 66, 1, 'Obeso'),\n",
       " (7, 142, 60, 33, 190, 28.8, 0.687, 61, 0, 'Normal'),\n",
       " (7, 181, 84, 21, 192, 35.9, 0.586, 51, 1, 'Obeso'),\n",
       " (11, 155, 76, 28, 150, 33.3, 1.353, 51, 1, 'Obeso'),\n",
       " (3, 142, 80, 15, 0, 32.4, 0.2, 63, 0, 'Obeso'),\n",
       " (13, 106, 70, 0, 0, 34.2, 0.251, 52, 0, 'Obeso'),\n",
       " (5, 114, 74, 0, 0, 24.9, 0.744, 57, 0, 'Normal'),\n",
       " (2, 108, 80, 0, 0, 27, 0.259, 52, 1, 'Normal'),\n",
       " (7, 136, 74, 26, 135, 26, 0.647, 51, 0, 'Normal'),\n",
       " (0, 161, 50, 0, 0, 21.9, 0.254, 65, 0, 'Normal'),\n",
       " (8, 112, 72, 0, 0, 23.6, 0.84, 58, 0, 'Normal'),\n",
       " (6, 194, 78, 0, 0, 23.5, 0.129, 59, 1, 'Normal'),\n",
       " (8, 95, 72, 0, 0, 36.8, 0.485, 57, 0, 'Obeso'),\n",
       " (5, 158, 70, 0, 0, 29.8, 0.207, 63, 0, 'Normal'),\n",
       " (5, 103, 108, 37, 0, 39.2, 0.305, 65, 0, 'Obeso'),\n",
       " (4, 146, 78, 0, 0, 38.5, 0.52, 67, 1, 'Obeso'),\n",
       " (12, 140, 82, 43, 325, 39.2, 0.528, 58, 1, 'Obeso'),\n",
       " (5, 144, 82, 26, 285, 32, 0.452, 58, 1, 'Obeso'),\n",
       " (6, 137, 61, 0, 0, 24.2, 0.151, 55, 0, 'Normal'),\n",
       " (2, 119, 0, 0, 0, 19.6, 0.832, 72, 0, 'Normal'),\n",
       " (1, 135, 54, 0, 0, 26.7, 0.687, 62, 0, 'Normal'),\n",
       " (10, 148, 84, 48, 237, 37.6, 1.001, 51, 1, 'Obeso'),\n",
       " (9, 134, 74, 33, 60, 25.9, 0.46, 81, 0, 'Normal'),\n",
       " (0, 137, 84, 27, 0, 27.3, 0.231, 59, 0, 'Normal'),\n",
       " (4, 132, 86, 31, 0, 28, 0.419, 63, 0, 'Normal'),\n",
       " (0, 173, 78, 32, 265, 46.5, 1.159, 58, 0, 'Obeso'),\n",
       " (8, 194, 80, 0, 0, 26.1, 0.551, 67, 0, 'Normal'),\n",
       " (6, 166, 74, 0, 0, 26.6, 0.304, 66, 0, 'Normal'),\n",
       " (7, 195, 70, 33, 145, 25.1, 0.163, 55, 1, 'Normal'),\n",
       " (8, 120, 78, 0, 0, 25, 0.409, 64, 0, 'Normal'),\n",
       " (9, 91, 68, 0, 0, 24.2, 0.2, 58, 0, 'Normal'),\n",
       " (9, 145, 88, 34, 165, 30.3, 0.771, 53, 1, 'Obeso'),\n",
       " (7, 125, 86, 0, 0, 37.6, 0.304, 51, 0, 'Obeso'),\n",
       " (6, 129, 90, 7, 326, 19.6, 0.582, 60, 0, 'Normal'),\n",
       " (0, 57, 60, 0, 0, 21.7, 0.735, 67, 0, 'Normal'),\n",
       " (10, 90, 85, 32, 0, 34.9, 0.825, 56, 1, 'Obeso'),\n",
       " (5, 187, 76, 27, 207, 43.6, 1.034, 53, 1, 'Obeso'),\n",
       " (6, 114, 88, 0, 0, 27.8, 0.247, 66, 0, 'Normal'),\n",
       " (8, 110, 76, 0, 0, 27.8, 0.237, 58, 0, 'Normal'),\n",
       " (6, 125, 76, 0, 0, 33.8, 0.121, 54, 1, 'Obeso'),\n",
       " (2, 197, 70, 99, 0, 34.7, 0.575, 62, 1, 'Obeso'),\n",
       " (12, 121, 78, 17, 0, 26.5, 0.259, 62, 0, 'Normal'),\n",
       " (8, 124, 76, 24, 600, 28.7, 0.687, 52, 1, 'Normal'),\n",
       " (3, 176, 86, 27, 156, 33.3, 1.154, 52, 1, 'Obeso'),\n",
       " (7, 150, 78, 29, 126, 35.2, 0.692, 54, 1, 'Obeso'),\n",
       " (11, 127, 106, 0, 0, 39, 0.19, 51, 0, 'Obeso'),\n",
       " (10, 162, 84, 0, 0, 27.7, 0.182, 54, 0, 'Normal'),\n",
       " (4, 145, 82, 18, 0, 32.5, 0.235, 70, 1, 'Obeso'),\n",
       " (8, 91, 82, 0, 0, 35.6, 0.587, 68, 0, 'Obeso'),\n",
       " (9, 156, 86, 0, 0, 24.8, 0.23, 53, 1, 'Normal'),\n",
       " (5, 136, 82, 0, 0, 0, 0.64, 69, 0, 'Normal'),\n",
       " (1, 168, 88, 29, 0, 35, 0.905, 52, 1, 'Obeso'),\n",
       " (10, 94, 72, 18, 0, 23.1, 0.595, 56, 0, 'Normal'),\n",
       " (5, 97, 76, 27, 0, 35.6, 0.378, 52, 1, 'Obeso'),\n",
       " (2, 105, 75, 0, 0, 23.3, 0.56, 53, 0, 'Normal'),\n",
       " (0, 123, 72, 0, 0, 36.3, 0.258, 52, 1, 'Obeso'),\n",
       " (6, 190, 92, 0, 0, 35.5, 0.278, 66, 1, 'Obeso'),\n",
       " (10, 101, 76, 48, 180, 32.9, 0.171, 63, 0, 'Obeso')]"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "\n",
    "SELECT * FROM pacientes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# carregando os dados da tabela pacientes para um dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<sqlite3.Cursor at 0x1cfa88ba9d0>"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "query = cnn.execute(\"SELECT * FROM pacientes\")\n",
    "query"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Pregnancies',\n",
       " 'Glucose',\n",
       " 'BloodPressure',\n",
       " 'SkinThickness',\n",
       " 'Insulin',\n",
       " 'BMI',\n",
       " 'DiabetesPedigreeFunction',\n",
       " 'Age',\n",
       " 'Outcome',\n",
       " 'Perfil']"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# list comprehension para criar uma lista com os nomes das colunas\n",
    "# gravar cada coluna na lista cols\n",
    "cols = [coluna[0] for coluna in query.description]\n",
    "cols"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [],
   "source": [
    "resultado = pd.DataFrame.from_records(data = query.fetchall(), columns = cols)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(81, 10)"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "resultado.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "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>Pregnancies</th>\n",
       "      <th>Glucose</th>\n",
       "      <th>BloodPressure</th>\n",
       "      <th>SkinThickness</th>\n",
       "      <th>Insulin</th>\n",
       "      <th>BMI</th>\n",
       "      <th>DiabetesPedigreeFunction</th>\n",
       "      <th>Age</th>\n",
       "      <th>Outcome</th>\n",
       "      <th>Perfil</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2</td>\n",
       "      <td>197</td>\n",
       "      <td>70</td>\n",
       "      <td>45</td>\n",
       "      <td>543</td>\n",
       "      <td>30.5</td>\n",
       "      <td>0.158</td>\n",
       "      <td>53</td>\n",
       "      <td>1</td>\n",
       "      <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>8</td>\n",
       "      <td>125</td>\n",
       "      <td>96</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.232</td>\n",
       "      <td>54</td>\n",
       "      <td>1</td>\n",
       "      <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>10</td>\n",
       "      <td>139</td>\n",
       "      <td>80</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>27.1</td>\n",
       "      <td>1.441</td>\n",
       "      <td>57</td>\n",
       "      <td>0</td>\n",
       "      <td>Normal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>189</td>\n",
       "      <td>60</td>\n",
       "      <td>23</td>\n",
       "      <td>846</td>\n",
       "      <td>30.1</td>\n",
       "      <td>0.398</td>\n",
       "      <td>59</td>\n",
       "      <td>1</td>\n",
       "      <td>Obeso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>166</td>\n",
       "      <td>72</td>\n",
       "      <td>19</td>\n",
       "      <td>175</td>\n",
       "      <td>25.8</td>\n",
       "      <td>0.587</td>\n",
       "      <td>51</td>\n",
       "      <td>1</td>\n",
       "      <td>Normal</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Pregnancies  Glucose  BloodPressure  SkinThickness  Insulin   BMI  \\\n",
       "0            2      197             70             45      543  30.5   \n",
       "1            8      125             96              0        0   0.0   \n",
       "2           10      139             80              0        0  27.1   \n",
       "3            1      189             60             23      846  30.1   \n",
       "4            5      166             72             19      175  25.8   \n",
       "\n",
       "   DiabetesPedigreeFunction  Age  Outcome  Perfil  \n",
       "0                     0.158   53        1   Obeso  \n",
       "1                     0.232   54        1  Normal  \n",
       "2                     1.441   57        0  Normal  \n",
       "3                     0.398   59        1   Obeso  \n",
       "4                     0.587   51        1  Normal  "
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "resultado.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Salva em CSV\n",
    "resultado.to_csv('dataset/pacientes.csv', index = False)"
   ]
  }
 ],
 "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.9.13"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "5ec125515043d772dd9b98c3c24b49c8fbf1206347d4394bcaf1be4516bae761"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}