Week02/AluraShop_IdadeGenero.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "f547a87c",
   "metadata": {},
   "source": [
    "#### Importing libries to the project"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 249,
   "id": "9e9dfa88",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import psycopg2\n",
    "import os\n",
    "from io import StringIO"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2cc28ec1",
   "metadata": {},
   "source": [
    "#### Importing Datasets"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 250,
   "id": "769af6c3",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfIdadeGenero = pd.read_json('Datasets\\Tabela_idade_e_genero.json')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 251,
   "id": "9addfbca",
   "metadata": {
    "scrolled": false
   },
   "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>Idade</th>\n",
       "      <th>Gênero</th>\n",
       "      <th>Dia</th>\n",
       "      <th>FIELD4</th>\n",
       "      <th>Alcance</th>\n",
       "      <th>Impressões</th>\n",
       "      <th>Quantia gasta (BRL)</th>\n",
       "      <th>Cliques no link</th>\n",
       "      <th>Visualizações por página</th>\n",
       "      <th>Compras no website</th>\n",
       "      <th>Compras no facebook</th>\n",
       "      <th>Adicionados ao carrinho</th>\n",
       "      <th>Valor de conversão adicionado ao carrinho</th>\n",
       "      <th>Checkouts Iniciados</th>\n",
       "      <th>Valor de conversão de checkouts iniciados</th>\n",
       "      <th>Valor de conversão de compras</th>\n",
       "      <th>Compras</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>45-54</td>\n",
       "      <td>Feminino</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td></td>\n",
       "      <td>1116.0</td>\n",
       "      <td>1489.0</td>\n",
       "      <td>9,42</td>\n",
       "      <td>24,00</td>\n",
       "      <td>20,00</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>1,00</td>\n",
       "      <td>63,90</td>\n",
       "      <td>1,00</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>35-44</td>\n",
       "      <td>Outros</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td></td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0,03</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>45-54</td>\n",
       "      <td>Outros</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td></td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>65+</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td></td>\n",
       "      <td>24.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>0,11</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>25</td>\n",
       "      <td>Outros</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td></td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0,01</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>506</th>\n",
       "      <td>55-64</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>2021-07-01</td>\n",
       "      <td></td>\n",
       "      <td>400.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1,07</td>\n",
       "      <td>2,00</td>\n",
       "      <td>1,00</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>507</th>\n",
       "      <td>65+</td>\n",
       "      <td>Feminino</td>\n",
       "      <td>2021-07-01</td>\n",
       "      <td></td>\n",
       "      <td>212.0</td>\n",
       "      <td>230.0</td>\n",
       "      <td>0,88</td>\n",
       "      <td>2,00</td>\n",
       "      <td>1,00</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>508</th>\n",
       "      <td>65+</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>2021-07-01</td>\n",
       "      <td></td>\n",
       "      <td>136.0</td>\n",
       "      <td>157.0</td>\n",
       "      <td>0,48</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>509</th>\n",
       "      <td>25-34</td>\n",
       "      <td>Outros</td>\n",
       "      <td>2021-07-01</td>\n",
       "      <td></td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>510</th>\n",
       "      <td>35-44</td>\n",
       "      <td>Outros</td>\n",
       "      <td>2021-07-01</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0,03</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>511 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Idade     Gênero         Dia FIELD4  Alcance  Impressões  \\\n",
       "0    45-54   Feminino  2021-07-31          1116.0      1489.0   \n",
       "1    35-44     Outros  2021-07-31             4.0         5.0   \n",
       "2    45-54     Outros  2021-07-31             3.0         3.0   \n",
       "3      65+  Masculino  2021-07-31            24.0        36.0   \n",
       "4       25     Outros  2021-07-31             4.0         4.0   \n",
       "..     ...        ...         ...    ...      ...         ...   \n",
       "506  55-64  Masculino  2021-07-01           400.0       400.0   \n",
       "507    65+   Feminino  2021-07-01           212.0       230.0   \n",
       "508    65+  Masculino  2021-07-01           136.0       157.0   \n",
       "509  25-34     Outros  2021-07-01             4.0         4.0   \n",
       "510  35-44     Outros  2021-07-01             NaN         5.0   \n",
       "\n",
       "    Quantia gasta (BRL) Cliques no link Visualizações por página  \\\n",
       "0                  9,42           24,00                    20,00   \n",
       "1                  0,03                                            \n",
       "2                                                                  \n",
       "3                  0,11                                            \n",
       "4                  0,01                                            \n",
       "..                  ...             ...                      ...   \n",
       "506                1,07            2,00                     1,00   \n",
       "507                0,88            2,00                     1,00   \n",
       "508                0,48                                            \n",
       "509                                                                \n",
       "510                0,03                                            \n",
       "\n",
       "    Compras no website Compras no facebook Adicionados ao carrinho  \\\n",
       "0                                                             1,00   \n",
       "1                                                                    \n",
       "2                                                                    \n",
       "3                                                                    \n",
       "4                                                                    \n",
       "..                 ...                 ...                     ...   \n",
       "506                                                                  \n",
       "507                                                                  \n",
       "508                                                                  \n",
       "509                                                                  \n",
       "510                                                                  \n",
       "\n",
       "    Valor de conversão adicionado ao carrinho Checkouts Iniciados  \\\n",
       "0                                       63,90                1,00   \n",
       "1                                                                   \n",
       "2                                                                   \n",
       "3                                                                   \n",
       "4                                                                   \n",
       "..                                        ...                 ...   \n",
       "506                                                                 \n",
       "507                                                                 \n",
       "508                                                                 \n",
       "509                                                                 \n",
       "510                                                                 \n",
       "\n",
       "    Valor de conversão de checkouts iniciados Valor de conversão de compras  \\\n",
       "0                                                                             \n",
       "1                                                                             \n",
       "2                                                                             \n",
       "3                                                                             \n",
       "4                                                                             \n",
       "..                                        ...                           ...   \n",
       "506                                                                           \n",
       "507                                                                           \n",
       "508                                                                           \n",
       "509                                                                           \n",
       "510                                                                           \n",
       "\n",
       "    Compras  \n",
       "0            \n",
       "1            \n",
       "2            \n",
       "3            \n",
       "4            \n",
       "..      ...  \n",
       "506          \n",
       "507          \n",
       "508          \n",
       "509          \n",
       "510          \n",
       "\n",
       "[511 rows x 17 columns]"
      ]
     },
     "execution_count": 251,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfIdadeGenero"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fd0096cf",
   "metadata": {},
   "source": [
    "Replacing (,) to (.)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 252,
   "id": "809befd7",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfIdadeGenero = dfIdadeGenero.replace({',': '.'}, regex=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 253,
   "id": "9065cf3f",
   "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>Idade</th>\n",
       "      <th>Gênero</th>\n",
       "      <th>Dia</th>\n",
       "      <th>FIELD4</th>\n",
       "      <th>Alcance</th>\n",
       "      <th>Impressões</th>\n",
       "      <th>Quantia gasta (BRL)</th>\n",
       "      <th>Cliques no link</th>\n",
       "      <th>Visualizações por página</th>\n",
       "      <th>Compras no website</th>\n",
       "      <th>Compras no facebook</th>\n",
       "      <th>Adicionados ao carrinho</th>\n",
       "      <th>Valor de conversão adicionado ao carrinho</th>\n",
       "      <th>Checkouts Iniciados</th>\n",
       "      <th>Valor de conversão de checkouts iniciados</th>\n",
       "      <th>Valor de conversão de compras</th>\n",
       "      <th>Compras</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>45-54</td>\n",
       "      <td>Feminino</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td></td>\n",
       "      <td>1116.0</td>\n",
       "      <td>1489.0</td>\n",
       "      <td>9.42</td>\n",
       "      <td>24.00</td>\n",
       "      <td>20.00</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>1.00</td>\n",
       "      <td>63.90</td>\n",
       "      <td>1.00</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>35-44</td>\n",
       "      <td>Outros</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td></td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.03</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>45-54</td>\n",
       "      <td>Outros</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td></td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>65+</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td></td>\n",
       "      <td>24.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>0.11</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>25</td>\n",
       "      <td>Outros</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td></td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>506</th>\n",
       "      <td>55-64</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>2021-07-01</td>\n",
       "      <td></td>\n",
       "      <td>400.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.07</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>507</th>\n",
       "      <td>65+</td>\n",
       "      <td>Feminino</td>\n",
       "      <td>2021-07-01</td>\n",
       "      <td></td>\n",
       "      <td>212.0</td>\n",
       "      <td>230.0</td>\n",
       "      <td>0.88</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>508</th>\n",
       "      <td>65+</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>2021-07-01</td>\n",
       "      <td></td>\n",
       "      <td>136.0</td>\n",
       "      <td>157.0</td>\n",
       "      <td>0.48</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>509</th>\n",
       "      <td>25-34</td>\n",
       "      <td>Outros</td>\n",
       "      <td>2021-07-01</td>\n",
       "      <td></td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>510</th>\n",
       "      <td>35-44</td>\n",
       "      <td>Outros</td>\n",
       "      <td>2021-07-01</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.03</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>511 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Idade     Gênero         Dia FIELD4  Alcance  Impressões  \\\n",
       "0    45-54   Feminino  2021-07-31          1116.0      1489.0   \n",
       "1    35-44     Outros  2021-07-31             4.0         5.0   \n",
       "2    45-54     Outros  2021-07-31             3.0         3.0   \n",
       "3      65+  Masculino  2021-07-31            24.0        36.0   \n",
       "4       25     Outros  2021-07-31             4.0         4.0   \n",
       "..     ...        ...         ...    ...      ...         ...   \n",
       "506  55-64  Masculino  2021-07-01           400.0       400.0   \n",
       "507    65+   Feminino  2021-07-01           212.0       230.0   \n",
       "508    65+  Masculino  2021-07-01           136.0       157.0   \n",
       "509  25-34     Outros  2021-07-01             4.0         4.0   \n",
       "510  35-44     Outros  2021-07-01             NaN         5.0   \n",
       "\n",
       "    Quantia gasta (BRL) Cliques no link Visualizações por página  \\\n",
       "0                  9.42           24.00                    20.00   \n",
       "1                  0.03                                            \n",
       "2                                                                  \n",
       "3                  0.11                                            \n",
       "4                  0.01                                            \n",
       "..                  ...             ...                      ...   \n",
       "506                1.07            2.00                     1.00   \n",
       "507                0.88            2.00                     1.00   \n",
       "508                0.48                                            \n",
       "509                                                                \n",
       "510                0.03                                            \n",
       "\n",
       "    Compras no website Compras no facebook Adicionados ao carrinho  \\\n",
       "0                                                             1.00   \n",
       "1                                                                    \n",
       "2                                                                    \n",
       "3                                                                    \n",
       "4                                                                    \n",
       "..                 ...                 ...                     ...   \n",
       "506                                                                  \n",
       "507                                                                  \n",
       "508                                                                  \n",
       "509                                                                  \n",
       "510                                                                  \n",
       "\n",
       "    Valor de conversão adicionado ao carrinho Checkouts Iniciados  \\\n",
       "0                                       63.90                1.00   \n",
       "1                                                                   \n",
       "2                                                                   \n",
       "3                                                                   \n",
       "4                                                                   \n",
       "..                                        ...                 ...   \n",
       "506                                                                 \n",
       "507                                                                 \n",
       "508                                                                 \n",
       "509                                                                 \n",
       "510                                                                 \n",
       "\n",
       "    Valor de conversão de checkouts iniciados Valor de conversão de compras  \\\n",
       "0                                                                             \n",
       "1                                                                             \n",
       "2                                                                             \n",
       "3                                                                             \n",
       "4                                                                             \n",
       "..                                        ...                           ...   \n",
       "506                                                                           \n",
       "507                                                                           \n",
       "508                                                                           \n",
       "509                                                                           \n",
       "510                                                                           \n",
       "\n",
       "    Compras  \n",
       "0            \n",
       "1            \n",
       "2            \n",
       "3            \n",
       "4            \n",
       "..      ...  \n",
       "506          \n",
       "507          \n",
       "508          \n",
       "509          \n",
       "510          \n",
       "\n",
       "[511 rows x 17 columns]"
      ]
     },
     "execution_count": 253,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfIdadeGenero"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1505c2f0",
   "metadata": {},
   "source": [
    "#### Replacing nothing to 0 (this is necessary due to the conversion of columns type to int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 254,
   "id": "188c8772",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfIdadeGenero = dfIdadeGenero.replace({'': '0'}, regex=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 255,
   "id": "a21f79c9",
   "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>Idade</th>\n",
       "      <th>Gênero</th>\n",
       "      <th>Dia</th>\n",
       "      <th>FIELD4</th>\n",
       "      <th>Alcance</th>\n",
       "      <th>Impressões</th>\n",
       "      <th>Quantia gasta (BRL)</th>\n",
       "      <th>Cliques no link</th>\n",
       "      <th>Visualizações por página</th>\n",
       "      <th>Compras no website</th>\n",
       "      <th>Compras no facebook</th>\n",
       "      <th>Adicionados ao carrinho</th>\n",
       "      <th>Valor de conversão adicionado ao carrinho</th>\n",
       "      <th>Checkouts Iniciados</th>\n",
       "      <th>Valor de conversão de checkouts iniciados</th>\n",
       "      <th>Valor de conversão de compras</th>\n",
       "      <th>Compras</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>45-54</td>\n",
       "      <td>Feminino</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td>0</td>\n",
       "      <td>1116.0</td>\n",
       "      <td>1489.0</td>\n",
       "      <td>9.42</td>\n",
       "      <td>24.00</td>\n",
       "      <td>20.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.00</td>\n",
       "      <td>63.90</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>35-44</td>\n",
       "      <td>Outros</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td>0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.03</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>45-54</td>\n",
       "      <td>Outros</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td>0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>65+</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td>0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>0.11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>25</td>\n",
       "      <td>Outros</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td>0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>506</th>\n",
       "      <td>55-64</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>2021-07-01</td>\n",
       "      <td>0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.07</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>507</th>\n",
       "      <td>65+</td>\n",
       "      <td>Feminino</td>\n",
       "      <td>2021-07-01</td>\n",
       "      <td>0</td>\n",
       "      <td>212.0</td>\n",
       "      <td>230.0</td>\n",
       "      <td>0.88</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>508</th>\n",
       "      <td>65+</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>2021-07-01</td>\n",
       "      <td>0</td>\n",
       "      <td>136.0</td>\n",
       "      <td>157.0</td>\n",
       "      <td>0.48</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>509</th>\n",
       "      <td>25-34</td>\n",
       "      <td>Outros</td>\n",
       "      <td>2021-07-01</td>\n",
       "      <td>0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>510</th>\n",
       "      <td>35-44</td>\n",
       "      <td>Outros</td>\n",
       "      <td>2021-07-01</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.03</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>511 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Idade     Gênero         Dia FIELD4  Alcance  Impressões  \\\n",
       "0    45-54   Feminino  2021-07-31      0   1116.0      1489.0   \n",
       "1    35-44     Outros  2021-07-31      0      4.0         5.0   \n",
       "2    45-54     Outros  2021-07-31      0      3.0         3.0   \n",
       "3      65+  Masculino  2021-07-31      0     24.0        36.0   \n",
       "4       25     Outros  2021-07-31      0      4.0         4.0   \n",
       "..     ...        ...         ...    ...      ...         ...   \n",
       "506  55-64  Masculino  2021-07-01      0    400.0       400.0   \n",
       "507    65+   Feminino  2021-07-01      0    212.0       230.0   \n",
       "508    65+  Masculino  2021-07-01      0    136.0       157.0   \n",
       "509  25-34     Outros  2021-07-01      0      4.0         4.0   \n",
       "510  35-44     Outros  2021-07-01      0      NaN         5.0   \n",
       "\n",
       "    Quantia gasta (BRL) Cliques no link Visualizações por página  \\\n",
       "0                  9.42           24.00                    20.00   \n",
       "1                  0.03               0                        0   \n",
       "2                     0               0                        0   \n",
       "3                  0.11               0                        0   \n",
       "4                  0.01               0                        0   \n",
       "..                  ...             ...                      ...   \n",
       "506                1.07            2.00                     1.00   \n",
       "507                0.88            2.00                     1.00   \n",
       "508                0.48               0                        0   \n",
       "509                   0               0                        0   \n",
       "510                0.03               0                        0   \n",
       "\n",
       "    Compras no website Compras no facebook Adicionados ao carrinho  \\\n",
       "0                    0                   0                    1.00   \n",
       "1                    0                   0                       0   \n",
       "2                    0                   0                       0   \n",
       "3                    0                   0                       0   \n",
       "4                    0                   0                       0   \n",
       "..                 ...                 ...                     ...   \n",
       "506                  0                   0                       0   \n",
       "507                  0                   0                       0   \n",
       "508                  0                   0                       0   \n",
       "509                  0                   0                       0   \n",
       "510                  0                   0                       0   \n",
       "\n",
       "    Valor de conversão adicionado ao carrinho Checkouts Iniciados  \\\n",
       "0                                       63.90                1.00   \n",
       "1                                           0                   0   \n",
       "2                                           0                   0   \n",
       "3                                           0                   0   \n",
       "4                                           0                   0   \n",
       "..                                        ...                 ...   \n",
       "506                                         0                   0   \n",
       "507                                         0                   0   \n",
       "508                                         0                   0   \n",
       "509                                         0                   0   \n",
       "510                                         0                   0   \n",
       "\n",
       "    Valor de conversão de checkouts iniciados Valor de conversão de compras  \\\n",
       "0                                           0                             0   \n",
       "1                                           0                             0   \n",
       "2                                           0                             0   \n",
       "3                                           0                             0   \n",
       "4                                           0                             0   \n",
       "..                                        ...                           ...   \n",
       "506                                         0                             0   \n",
       "507                                         0                             0   \n",
       "508                                         0                             0   \n",
       "509                                         0                             0   \n",
       "510                                         0                             0   \n",
       "\n",
       "    Compras  \n",
       "0         0  \n",
       "1         0  \n",
       "2         0  \n",
       "3         0  \n",
       "4         0  \n",
       "..      ...  \n",
       "506       0  \n",
       "507       0  \n",
       "508       0  \n",
       "509       0  \n",
       "510       0  \n",
       "\n",
       "[511 rows x 17 columns]"
      ]
     },
     "execution_count": 255,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfIdadeGenero"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "941ce844",
   "metadata": {},
   "source": [
    "#### Spliting column values to the .0 to transform then in intenger numbers, here I am creating an extra column in dataframe tha should be discarted next"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 256,
   "id": "a8f80b31",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfIdadeGenero[['Cliques no link', 'Cliques no link2']] = dfIdadeGenero['Cliques no link'].str.split('.', expand=True)\n",
    "dfIdadeGenero[['Visualizações por página', 'Visualizações por página2']] = dfIdadeGenero['Visualizações por página'].str.split('.', expand=True)\n",
    "dfIdadeGenero[['Compras no website', 'Compras no website2']] = dfIdadeGenero['Compras no website'].str.split('.', expand=True)\n",
    "dfIdadeGenero[['Adicionados ao carrinho', 'Adicionados ao carrinho2']] = dfIdadeGenero['Adicionados ao carrinho'].str.split('.', expand=True)\n",
    "dfIdadeGenero[['Checkouts Iniciados', 'Checkouts Iniciados2']] = dfIdadeGenero['Checkouts Iniciados'].str.split('.', expand=True)\n",
    "dfIdadeGenero[['Compras', 'Compras2']] = dfIdadeGenero['Compras'].str.split('.', expand=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 257,
   "id": "bd0f86fd",
   "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>Idade</th>\n",
       "      <th>Gênero</th>\n",
       "      <th>Dia</th>\n",
       "      <th>FIELD4</th>\n",
       "      <th>Alcance</th>\n",
       "      <th>Impressões</th>\n",
       "      <th>Quantia gasta (BRL)</th>\n",
       "      <th>Cliques no link</th>\n",
       "      <th>Visualizações por página</th>\n",
       "      <th>Compras no website</th>\n",
       "      <th>...</th>\n",
       "      <th>Checkouts Iniciados</th>\n",
       "      <th>Valor de conversão de checkouts iniciados</th>\n",
       "      <th>Valor de conversão de compras</th>\n",
       "      <th>Compras</th>\n",
       "      <th>Cliques no link2</th>\n",
       "      <th>Visualizações por página2</th>\n",
       "      <th>Compras no website2</th>\n",
       "      <th>Adicionados ao carrinho2</th>\n",
       "      <th>Checkouts Iniciados2</th>\n",
       "      <th>Compras2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>45-54</td>\n",
       "      <td>Feminino</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td>0</td>\n",
       "      <td>1116.0</td>\n",
       "      <td>1489.0</td>\n",
       "      <td>9.42</td>\n",
       "      <td>24</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>00</td>\n",
       "      <td>00</td>\n",
       "      <td>None</td>\n",
       "      <td>00</td>\n",
       "      <td>00</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>35-44</td>\n",
       "      <td>Outros</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td>0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.03</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>45-54</td>\n",
       "      <td>Outros</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td>0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>65+</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td>0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>0.11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>25</td>\n",
       "      <td>Outros</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td>0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>506</th>\n",
       "      <td>55-64</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>2021-07-01</td>\n",
       "      <td>0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.07</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>00</td>\n",
       "      <td>00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>507</th>\n",
       "      <td>65+</td>\n",
       "      <td>Feminino</td>\n",
       "      <td>2021-07-01</td>\n",
       "      <td>0</td>\n",
       "      <td>212.0</td>\n",
       "      <td>230.0</td>\n",
       "      <td>0.88</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>00</td>\n",
       "      <td>00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>508</th>\n",
       "      <td>65+</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>2021-07-01</td>\n",
       "      <td>0</td>\n",
       "      <td>136.0</td>\n",
       "      <td>157.0</td>\n",
       "      <td>0.48</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>509</th>\n",
       "      <td>25-34</td>\n",
       "      <td>Outros</td>\n",
       "      <td>2021-07-01</td>\n",
       "      <td>0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>510</th>\n",
       "      <td>35-44</td>\n",
       "      <td>Outros</td>\n",
       "      <td>2021-07-01</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.03</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>511 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Idade     Gênero         Dia FIELD4  Alcance  Impressões  \\\n",
       "0    45-54   Feminino  2021-07-31      0   1116.0      1489.0   \n",
       "1    35-44     Outros  2021-07-31      0      4.0         5.0   \n",
       "2    45-54     Outros  2021-07-31      0      3.0         3.0   \n",
       "3      65+  Masculino  2021-07-31      0     24.0        36.0   \n",
       "4       25     Outros  2021-07-31      0      4.0         4.0   \n",
       "..     ...        ...         ...    ...      ...         ...   \n",
       "506  55-64  Masculino  2021-07-01      0    400.0       400.0   \n",
       "507    65+   Feminino  2021-07-01      0    212.0       230.0   \n",
       "508    65+  Masculino  2021-07-01      0    136.0       157.0   \n",
       "509  25-34     Outros  2021-07-01      0      4.0         4.0   \n",
       "510  35-44     Outros  2021-07-01      0      NaN         5.0   \n",
       "\n",
       "    Quantia gasta (BRL) Cliques no link Visualizações por página  \\\n",
       "0                  9.42              24                       20   \n",
       "1                  0.03               0                        0   \n",
       "2                     0               0                        0   \n",
       "3                  0.11               0                        0   \n",
       "4                  0.01               0                        0   \n",
       "..                  ...             ...                      ...   \n",
       "506                1.07               2                        1   \n",
       "507                0.88               2                        1   \n",
       "508                0.48               0                        0   \n",
       "509                   0               0                        0   \n",
       "510                0.03               0                        0   \n",
       "\n",
       "    Compras no website  ... Checkouts Iniciados  \\\n",
       "0                    0  ...                   1   \n",
       "1                    0  ...                   0   \n",
       "2                    0  ...                   0   \n",
       "3                    0  ...                   0   \n",
       "4                    0  ...                   0   \n",
       "..                 ...  ...                 ...   \n",
       "506                  0  ...                   0   \n",
       "507                  0  ...                   0   \n",
       "508                  0  ...                   0   \n",
       "509                  0  ...                   0   \n",
       "510                  0  ...                   0   \n",
       "\n",
       "    Valor de conversão de checkouts iniciados Valor de conversão de compras  \\\n",
       "0                                           0                             0   \n",
       "1                                           0                             0   \n",
       "2                                           0                             0   \n",
       "3                                           0                             0   \n",
       "4                                           0                             0   \n",
       "..                                        ...                           ...   \n",
       "506                                         0                             0   \n",
       "507                                         0                             0   \n",
       "508                                         0                             0   \n",
       "509                                         0                             0   \n",
       "510                                         0                             0   \n",
       "\n",
       "    Compras Cliques no link2 Visualizações por página2 Compras no website2  \\\n",
       "0         0               00                        00                None   \n",
       "1         0             None                      None                None   \n",
       "2         0             None                      None                None   \n",
       "3         0             None                      None                None   \n",
       "4         0             None                      None                None   \n",
       "..      ...              ...                       ...                 ...   \n",
       "506       0               00                        00                None   \n",
       "507       0               00                        00                None   \n",
       "508       0             None                      None                None   \n",
       "509       0             None                      None                None   \n",
       "510       0             None                      None                None   \n",
       "\n",
       "    Adicionados ao carrinho2 Checkouts Iniciados2 Compras2  \n",
       "0                         00                   00     None  \n",
       "1                       None                 None     None  \n",
       "2                       None                 None     None  \n",
       "3                       None                 None     None  \n",
       "4                       None                 None     None  \n",
       "..                       ...                  ...      ...  \n",
       "506                     None                 None     None  \n",
       "507                     None                 None     None  \n",
       "508                     None                 None     None  \n",
       "509                     None                 None     None  \n",
       "510                     None                 None     None  \n",
       "\n",
       "[511 rows x 23 columns]"
      ]
     },
     "execution_count": 257,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfIdadeGenero"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "aa252a69",
   "metadata": {},
   "source": [
    "#### Dropping no valuable columns from dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 258,
   "id": "ea360f13",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfIdadeGenero = dfIdadeGenero.drop(['Cliques no link2','Visualizações por página2','Compras no website2',\n",
    "                     'Adicionados ao carrinho2','Checkouts Iniciados2','Compras2', 'FIELD4'], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 259,
   "id": "04be2fc5",
   "metadata": {
    "scrolled": false
   },
   "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>Idade</th>\n",
       "      <th>Gênero</th>\n",
       "      <th>Dia</th>\n",
       "      <th>Alcance</th>\n",
       "      <th>Impressões</th>\n",
       "      <th>Quantia gasta (BRL)</th>\n",
       "      <th>Cliques no link</th>\n",
       "      <th>Visualizações por página</th>\n",
       "      <th>Compras no website</th>\n",
       "      <th>Compras no facebook</th>\n",
       "      <th>Adicionados ao carrinho</th>\n",
       "      <th>Valor de conversão adicionado ao carrinho</th>\n",
       "      <th>Checkouts Iniciados</th>\n",
       "      <th>Valor de conversão de checkouts iniciados</th>\n",
       "      <th>Valor de conversão de compras</th>\n",
       "      <th>Compras</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>45-54</td>\n",
       "      <td>Feminino</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td>1116.0</td>\n",
       "      <td>1489.0</td>\n",
       "      <td>9.42</td>\n",
       "      <td>24</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>63.90</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>35-44</td>\n",
       "      <td>Outros</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.03</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>45-54</td>\n",
       "      <td>Outros</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>65+</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td>24.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>0.11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>25</td>\n",
       "      <td>Outros</td>\n",
       "      <td>2021-07-31</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>506</th>\n",
       "      <td>55-64</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>2021-07-01</td>\n",
       "      <td>400.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.07</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>507</th>\n",
       "      <td>65+</td>\n",
       "      <td>Feminino</td>\n",
       "      <td>2021-07-01</td>\n",
       "      <td>212.0</td>\n",
       "      <td>230.0</td>\n",
       "      <td>0.88</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>508</th>\n",
       "      <td>65+</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>2021-07-01</td>\n",
       "      <td>136.0</td>\n",
       "      <td>157.0</td>\n",
       "      <td>0.48</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>509</th>\n",
       "      <td>25-34</td>\n",
       "      <td>Outros</td>\n",
       "      <td>2021-07-01</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>510</th>\n",
       "      <td>35-44</td>\n",
       "      <td>Outros</td>\n",
       "      <td>2021-07-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.03</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>511 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Idade     Gênero         Dia  Alcance  Impressões Quantia gasta (BRL)  \\\n",
       "0    45-54   Feminino  2021-07-31   1116.0      1489.0                9.42   \n",
       "1    35-44     Outros  2021-07-31      4.0         5.0                0.03   \n",
       "2    45-54     Outros  2021-07-31      3.0         3.0                   0   \n",
       "3      65+  Masculino  2021-07-31     24.0        36.0                0.11   \n",
       "4       25     Outros  2021-07-31      4.0         4.0                0.01   \n",
       "..     ...        ...         ...      ...         ...                 ...   \n",
       "506  55-64  Masculino  2021-07-01    400.0       400.0                1.07   \n",
       "507    65+   Feminino  2021-07-01    212.0       230.0                0.88   \n",
       "508    65+  Masculino  2021-07-01    136.0       157.0                0.48   \n",
       "509  25-34     Outros  2021-07-01      4.0         4.0                   0   \n",
       "510  35-44     Outros  2021-07-01      NaN         5.0                0.03   \n",
       "\n",
       "    Cliques no link Visualizações por página Compras no website  \\\n",
       "0                24                       20                  0   \n",
       "1                 0                        0                  0   \n",
       "2                 0                        0                  0   \n",
       "3                 0                        0                  0   \n",
       "4                 0                        0                  0   \n",
       "..              ...                      ...                ...   \n",
       "506               2                        1                  0   \n",
       "507               2                        1                  0   \n",
       "508               0                        0                  0   \n",
       "509               0                        0                  0   \n",
       "510               0                        0                  0   \n",
       "\n",
       "    Compras no facebook Adicionados ao carrinho  \\\n",
       "0                     0                       1   \n",
       "1                     0                       0   \n",
       "2                     0                       0   \n",
       "3                     0                       0   \n",
       "4                     0                       0   \n",
       "..                  ...                     ...   \n",
       "506                   0                       0   \n",
       "507                   0                       0   \n",
       "508                   0                       0   \n",
       "509                   0                       0   \n",
       "510                   0                       0   \n",
       "\n",
       "    Valor de conversão adicionado ao carrinho Checkouts Iniciados  \\\n",
       "0                                       63.90                   1   \n",
       "1                                           0                   0   \n",
       "2                                           0                   0   \n",
       "3                                           0                   0   \n",
       "4                                           0                   0   \n",
       "..                                        ...                 ...   \n",
       "506                                         0                   0   \n",
       "507                                         0                   0   \n",
       "508                                         0                   0   \n",
       "509                                         0                   0   \n",
       "510                                         0                   0   \n",
       "\n",
       "    Valor de conversão de checkouts iniciados Valor de conversão de compras  \\\n",
       "0                                           0                             0   \n",
       "1                                           0                             0   \n",
       "2                                           0                             0   \n",
       "3                                           0                             0   \n",
       "4                                           0                             0   \n",
       "..                                        ...                           ...   \n",
       "506                                         0                             0   \n",
       "507                                         0                             0   \n",
       "508                                         0                             0   \n",
       "509                                         0                             0   \n",
       "510                                         0                             0   \n",
       "\n",
       "    Compras  \n",
       "0         0  \n",
       "1         0  \n",
       "2         0  \n",
       "3         0  \n",
       "4         0  \n",
       "..      ...  \n",
       "506       0  \n",
       "507       0  \n",
       "508       0  \n",
       "509       0  \n",
       "510       0  \n",
       "\n",
       "[511 rows x 16 columns]"
      ]
     },
     "execution_count": 259,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfIdadeGenero"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "07c9a266",
   "metadata": {},
   "source": [
    "#### Converting columns type"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 260,
   "id": "e24667e2",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfIdadeGenero = dfIdadeGenero.astype({\n",
    "    \n",
    "    'Quantia gasta (BRL)' : float,\n",
    "    'Cliques no link' : int,\n",
    "    'Visualizações por página' : int,\n",
    "    'Compras no website' : int, \n",
    "    'Compras no facebook' : int,\n",
    "    'Adicionados ao carrinho' : int,\n",
    "    'Valor de conversão adicionado ao carrinho' : float,\n",
    "    'Checkouts Iniciados' : int,\n",
    "    'Valor de conversão de checkouts iniciados' : int,\n",
    "    'Valor de conversão de compras' : float,\n",
    "    'Compras' : int    \n",
    "})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 261,
   "id": "9fd52b30",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Idade                                         object\n",
       "Gênero                                        object\n",
       "Dia                                           object\n",
       "Alcance                                      float64\n",
       "Impressões                                   float64\n",
       "Quantia gasta (BRL)                          float64\n",
       "Cliques no link                                int32\n",
       "Visualizações por página                       int32\n",
       "Compras no website                             int32\n",
       "Compras no facebook                            int32\n",
       "Adicionados ao carrinho                        int32\n",
       "Valor de conversão adicionado ao carrinho    float64\n",
       "Checkouts Iniciados                            int32\n",
       "Valor de conversão de checkouts iniciados      int32\n",
       "Valor de conversão de compras                float64\n",
       "Compras                                        int32\n",
       "dtype: object"
      ]
     },
     "execution_count": 261,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfIdadeGenero.dtypes"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2f49b5bc",
   "metadata": {},
   "source": [
    "#### Replacing NaN in dataframe to 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 262,
   "id": "45367456",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfIdadeGenero = dfIdadeGenero.replace(np.nan, 0)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4614a798",
   "metadata": {},
   "source": [
    "#### Renaming Columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 263,
   "id": "99ff4558",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfIdadeGenero.columns = [\"idade\", \"genero\", \"dia\", \"alcance\", \n",
    "                         \"impressoes\", \"quantia_gasta_brl\", \"cliques_no_link\", \"visualizacoes_por_pagina\",\n",
    "                         \"compras_no_website\", \"compras_no_facebook\", \"adicionados_ao_carrinho\", \n",
    "                         \"valor_de_conversao_adicionado_ao_carrinho\", \"checkouts_iniciados\",\n",
    "                         \"valor_de_conversao_de_checkouts_iniciados\", \"valor_de_conversao_de_compras\", \n",
    "                         \"compras\"]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1fb656c2",
   "metadata": {},
   "source": [
    "#### Creating a index name column"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 264,
   "id": "861bc3ff",
   "metadata": {},
   "outputs": [],
   "source": [
    "index = dfIdadeGenero.index\n",
    "index.name = \"id\""
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1b2b3cf0",
   "metadata": {},
   "source": [
    "#### Connecting to PostgreSQL database"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 265,
   "id": "fe90cb69",
   "metadata": {},
   "outputs": [],
   "source": [
    "conn = psycopg2.connect(host=\"localhost\", port = 5432, database=\"db_alurashop\", user=\"postgres\", password=\"123456\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4205e3b5",
   "metadata": {},
   "source": [
    "#### Creating a dataframe buffer in memory as CSV before insert data into database"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 266,
   "id": "18d1d815",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 266,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sio = StringIO()\n",
    "sio.write(dfIdadeGenero.to_csv(index=None, header=None)) \n",
    "sio.seek(0)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "16db65c4",
   "metadata": {},
   "source": [
    "#### Inserting data into database using the temporary CSV file"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 267,
   "id": "262b57c2",
   "metadata": {},
   "outputs": [],
   "source": [
    "with conn.cursor() as c:\n",
    "    c.copy_from(sio, \"idadegenero\", columns=dfIdadeGenero.columns, sep=',')\n",
    "    conn.commit()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}