Alura Challenges - Semana 1.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "8152f06c",
   "metadata": {},
   "source": [
    "# Challenge Data Science - Semana 1"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4efe3192",
   "metadata": {},
   "source": [
    "Na reunião inicial com as pessoas responsáveis pela área de vendas da empresa, foi explicada a importância de se reduzir a Taxa de Evasão de Clientes, conhecido como Churn Rate (quanto a empresa perdeu de receita ou clientes em um período de tempo)."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b07edfad",
   "metadata": {},
   "source": [
    "Através da API da Alura Voz, teremos acesso à base de dados e às suas informações.\n",
    "\n",
    "Na primeira semana sera feito uma analise dos dados para verificação de inconsistencias e sera feito correção delas caso encontrar algo"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ee79ae4e",
   "metadata": {},
   "source": [
    "# Importando Base de Dados"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "89e1df12",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "9a358c2e",
   "metadata": {},
   "outputs": [],
   "source": [
    "dados = pd.read_json('dados/Telco-Customer-Churn.json')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "52c1be01",
   "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>customerID</th>\n",
       "      <th>Churn</th>\n",
       "      <th>customer</th>\n",
       "      <th>phone</th>\n",
       "      <th>internet</th>\n",
       "      <th>account</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0002-ORFBO</td>\n",
       "      <td>No</td>\n",
       "      <td>{'gender': 'Female', 'SeniorCitizen': 0, 'Part...</td>\n",
       "      <td>{'PhoneService': 'Yes', 'MultipleLines': 'No'}</td>\n",
       "      <td>{'InternetService': 'DSL', 'OnlineSecurity': '...</td>\n",
       "      <td>{'Contract': 'One year', 'PaperlessBilling': '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0003-MKNFE</td>\n",
       "      <td>No</td>\n",
       "      <td>{'gender': 'Male', 'SeniorCitizen': 0, 'Partne...</td>\n",
       "      <td>{'PhoneService': 'Yes', 'MultipleLines': 'Yes'}</td>\n",
       "      <td>{'InternetService': 'DSL', 'OnlineSecurity': '...</td>\n",
       "      <td>{'Contract': 'Month-to-month', 'PaperlessBilli...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0004-TLHLJ</td>\n",
       "      <td>Yes</td>\n",
       "      <td>{'gender': 'Male', 'SeniorCitizen': 0, 'Partne...</td>\n",
       "      <td>{'PhoneService': 'Yes', 'MultipleLines': 'No'}</td>\n",
       "      <td>{'InternetService': 'Fiber optic', 'OnlineSecu...</td>\n",
       "      <td>{'Contract': 'Month-to-month', 'PaperlessBilli...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0011-IGKFF</td>\n",
       "      <td>Yes</td>\n",
       "      <td>{'gender': 'Male', 'SeniorCitizen': 1, 'Partne...</td>\n",
       "      <td>{'PhoneService': 'Yes', 'MultipleLines': 'No'}</td>\n",
       "      <td>{'InternetService': 'Fiber optic', 'OnlineSecu...</td>\n",
       "      <td>{'Contract': 'Month-to-month', 'PaperlessBilli...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0013-EXCHZ</td>\n",
       "      <td>Yes</td>\n",
       "      <td>{'gender': 'Female', 'SeniorCitizen': 1, 'Part...</td>\n",
       "      <td>{'PhoneService': 'Yes', 'MultipleLines': 'No'}</td>\n",
       "      <td>{'InternetService': 'Fiber optic', 'OnlineSecu...</td>\n",
       "      <td>{'Contract': 'Month-to-month', 'PaperlessBilli...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   customerID Churn                                           customer  \\\n",
       "0  0002-ORFBO    No  {'gender': 'Female', 'SeniorCitizen': 0, 'Part...   \n",
       "1  0003-MKNFE    No  {'gender': 'Male', 'SeniorCitizen': 0, 'Partne...   \n",
       "2  0004-TLHLJ   Yes  {'gender': 'Male', 'SeniorCitizen': 0, 'Partne...   \n",
       "3  0011-IGKFF   Yes  {'gender': 'Male', 'SeniorCitizen': 1, 'Partne...   \n",
       "4  0013-EXCHZ   Yes  {'gender': 'Female', 'SeniorCitizen': 1, 'Part...   \n",
       "\n",
       "                                             phone  \\\n",
       "0   {'PhoneService': 'Yes', 'MultipleLines': 'No'}   \n",
       "1  {'PhoneService': 'Yes', 'MultipleLines': 'Yes'}   \n",
       "2   {'PhoneService': 'Yes', 'MultipleLines': 'No'}   \n",
       "3   {'PhoneService': 'Yes', 'MultipleLines': 'No'}   \n",
       "4   {'PhoneService': 'Yes', 'MultipleLines': 'No'}   \n",
       "\n",
       "                                            internet  \\\n",
       "0  {'InternetService': 'DSL', 'OnlineSecurity': '...   \n",
       "1  {'InternetService': 'DSL', 'OnlineSecurity': '...   \n",
       "2  {'InternetService': 'Fiber optic', 'OnlineSecu...   \n",
       "3  {'InternetService': 'Fiber optic', 'OnlineSecu...   \n",
       "4  {'InternetService': 'Fiber optic', 'OnlineSecu...   \n",
       "\n",
       "                                             account  \n",
       "0  {'Contract': 'One year', 'PaperlessBilling': '...  \n",
       "1  {'Contract': 'Month-to-month', 'PaperlessBilli...  \n",
       "2  {'Contract': 'Month-to-month', 'PaperlessBilli...  \n",
       "3  {'Contract': 'Month-to-month', 'PaperlessBilli...  \n",
       "4  {'Contract': 'Month-to-month', 'PaperlessBilli...  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "b0a02f43",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Quantidades de linhas e colunas:  (7267, 6)\n"
     ]
    }
   ],
   "source": [
    "print(\"Quantidades de linhas e colunas: \", dados.shape)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "90e44d61",
   "metadata": {},
   "source": [
    "Constatamos que as colunas de **customer, phone, internet, account** estão com vários valores dentro de chaves, e dificulta a analise dos dados, precisamos expandir essas chaves e transforma-las em novas colunas no nosso dataframe"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "08dbe370",
   "metadata": {},
   "source": [
    "### Normalizando os dados"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "def75024",
   "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>gender</th>\n",
       "      <th>SeniorCitizen</th>\n",
       "      <th>Partner</th>\n",
       "      <th>Dependents</th>\n",
       "      <th>tenure</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Female</td>\n",
       "      <td>0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Male</td>\n",
       "      <td>0</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Male</td>\n",
       "      <td>0</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Male</td>\n",
       "      <td>1</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Female</td>\n",
       "      <td>1</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   gender  SeniorCitizen Partner Dependents  tenure\n",
       "0  Female              0     Yes        Yes       9\n",
       "1    Male              0      No         No       9\n",
       "2    Male              0      No         No       4\n",
       "3    Male              1     Yes         No      13\n",
       "4  Female              1     Yes         No       3"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "customer_dados = pd.json_normalize(data=dados.customer)\n",
    "customer_dados.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "c700ce21",
   "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>PhoneService</th>\n",
       "      <th>MultipleLines</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  PhoneService MultipleLines\n",
       "0          Yes            No\n",
       "1          Yes           Yes\n",
       "2          Yes            No\n",
       "3          Yes            No\n",
       "4          Yes            No"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "phone_dados = pd.json_normalize(data=dados.phone)\n",
    "phone_dados.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "6fc1216f",
   "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>InternetService</th>\n",
       "      <th>OnlineSecurity</th>\n",
       "      <th>OnlineBackup</th>\n",
       "      <th>DeviceProtection</th>\n",
       "      <th>TechSupport</th>\n",
       "      <th>StreamingTV</th>\n",
       "      <th>StreamingMovies</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>DSL</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>DSL</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Fiber optic</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Fiber optic</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Fiber optic</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  InternetService OnlineSecurity OnlineBackup DeviceProtection TechSupport  \\\n",
       "0             DSL             No          Yes               No         Yes   \n",
       "1             DSL             No           No               No          No   \n",
       "2     Fiber optic             No           No              Yes          No   \n",
       "3     Fiber optic             No          Yes              Yes          No   \n",
       "4     Fiber optic             No           No               No         Yes   \n",
       "\n",
       "  StreamingTV StreamingMovies  \n",
       "0         Yes              No  \n",
       "1          No             Yes  \n",
       "2          No              No  \n",
       "3         Yes             Yes  \n",
       "4         Yes              No  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "internet_dados = pd.json_normalize(data=dados.internet)\n",
    "internet_dados.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "9a6281c3",
   "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>Contract</th>\n",
       "      <th>PaperlessBilling</th>\n",
       "      <th>PaymentMethod</th>\n",
       "      <th>Charges_Monthly</th>\n",
       "      <th>Charges_Total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>One year</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Mailed check</td>\n",
       "      <td>65.6</td>\n",
       "      <td>593.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Month-to-month</td>\n",
       "      <td>No</td>\n",
       "      <td>Mailed check</td>\n",
       "      <td>59.9</td>\n",
       "      <td>542.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Month-to-month</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Electronic check</td>\n",
       "      <td>73.9</td>\n",
       "      <td>280.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Month-to-month</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Electronic check</td>\n",
       "      <td>98.0</td>\n",
       "      <td>1237.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Month-to-month</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Mailed check</td>\n",
       "      <td>83.9</td>\n",
       "      <td>267.4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Contract PaperlessBilling     PaymentMethod  Charges_Monthly  \\\n",
       "0        One year              Yes      Mailed check             65.6   \n",
       "1  Month-to-month               No      Mailed check             59.9   \n",
       "2  Month-to-month              Yes  Electronic check             73.9   \n",
       "3  Month-to-month              Yes  Electronic check             98.0   \n",
       "4  Month-to-month              Yes      Mailed check             83.9   \n",
       "\n",
       "  Charges_Total  \n",
       "0         593.3  \n",
       "1         542.4  \n",
       "2        280.85  \n",
       "3       1237.85  \n",
       "4         267.4  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "account_dados = pd.json_normalize(data=dados.account, sep='_')\n",
    "account_dados.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "29986b2c",
   "metadata": {},
   "source": [
    "Com todos os valores que estavam em chaves normalizados podemos juntar tudo em um unico dataframe com a função **concat()**"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7ba03056",
   "metadata": {},
   "source": [
    "### Juntando todas as normalizações"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "b2c7970f",
   "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>customerID</th>\n",
       "      <th>Churn</th>\n",
       "      <th>gender</th>\n",
       "      <th>SeniorCitizen</th>\n",
       "      <th>Partner</th>\n",
       "      <th>Dependents</th>\n",
       "      <th>tenure</th>\n",
       "      <th>PhoneService</th>\n",
       "      <th>MultipleLines</th>\n",
       "      <th>InternetService</th>\n",
       "      <th>...</th>\n",
       "      <th>OnlineBackup</th>\n",
       "      <th>DeviceProtection</th>\n",
       "      <th>TechSupport</th>\n",
       "      <th>StreamingTV</th>\n",
       "      <th>StreamingMovies</th>\n",
       "      <th>Contract</th>\n",
       "      <th>PaperlessBilling</th>\n",
       "      <th>PaymentMethod</th>\n",
       "      <th>Charges_Monthly</th>\n",
       "      <th>Charges_Total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0002-ORFBO</td>\n",
       "      <td>No</td>\n",
       "      <td>Female</td>\n",
       "      <td>0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>9</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>One year</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Mailed check</td>\n",
       "      <td>65.6</td>\n",
       "      <td>593.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0003-MKNFE</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>0</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>9</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Month-to-month</td>\n",
       "      <td>No</td>\n",
       "      <td>Mailed check</td>\n",
       "      <td>59.9</td>\n",
       "      <td>542.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0004-TLHLJ</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Male</td>\n",
       "      <td>0</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>4</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Fiber optic</td>\n",
       "      <td>...</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Month-to-month</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Electronic check</td>\n",
       "      <td>73.9</td>\n",
       "      <td>280.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0011-IGKFF</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Male</td>\n",
       "      <td>1</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>13</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Fiber optic</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Month-to-month</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Electronic check</td>\n",
       "      <td>98.0</td>\n",
       "      <td>1237.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0013-EXCHZ</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Female</td>\n",
       "      <td>1</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>3</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Fiber optic</td>\n",
       "      <td>...</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Month-to-month</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Mailed check</td>\n",
       "      <td>83.9</td>\n",
       "      <td>267.4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   customerID Churn  gender  SeniorCitizen Partner Dependents  tenure  \\\n",
       "0  0002-ORFBO    No  Female              0     Yes        Yes       9   \n",
       "1  0003-MKNFE    No    Male              0      No         No       9   \n",
       "2  0004-TLHLJ   Yes    Male              0      No         No       4   \n",
       "3  0011-IGKFF   Yes    Male              1     Yes         No      13   \n",
       "4  0013-EXCHZ   Yes  Female              1     Yes         No       3   \n",
       "\n",
       "  PhoneService MultipleLines InternetService  ... OnlineBackup  \\\n",
       "0          Yes            No             DSL  ...          Yes   \n",
       "1          Yes           Yes             DSL  ...           No   \n",
       "2          Yes            No     Fiber optic  ...           No   \n",
       "3          Yes            No     Fiber optic  ...          Yes   \n",
       "4          Yes            No     Fiber optic  ...           No   \n",
       "\n",
       "  DeviceProtection TechSupport StreamingTV StreamingMovies        Contract  \\\n",
       "0               No         Yes         Yes              No        One year   \n",
       "1               No          No          No             Yes  Month-to-month   \n",
       "2              Yes          No          No              No  Month-to-month   \n",
       "3              Yes          No         Yes             Yes  Month-to-month   \n",
       "4               No         Yes         Yes              No  Month-to-month   \n",
       "\n",
       "  PaperlessBilling     PaymentMethod Charges_Monthly  Charges_Total  \n",
       "0              Yes      Mailed check            65.6          593.3  \n",
       "1               No      Mailed check            59.9          542.4  \n",
       "2              Yes  Electronic check            73.9         280.85  \n",
       "3              Yes  Electronic check            98.0        1237.85  \n",
       "4              Yes      Mailed check            83.9          267.4  \n",
       "\n",
       "[5 rows x 21 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados = pd.concat([dados[['customerID', 'Churn']], customer_dados, phone_dados, internet_dados, account_dados], axis=1)\n",
    "dados.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b2593386",
   "metadata": {},
   "source": [
    "Agora que temos o dataframe normalizado podemos fazer uma análise para entender as informações que temos e procurar por inconsistencias e possiveis problemas nos dados"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7ac3f70c",
   "metadata": {},
   "source": [
    "## Análise exploratoria dos dados"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "cfa2a145",
   "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>customerID</th>\n",
       "      <th>Churn</th>\n",
       "      <th>gender</th>\n",
       "      <th>SeniorCitizen</th>\n",
       "      <th>Partner</th>\n",
       "      <th>Dependents</th>\n",
       "      <th>tenure</th>\n",
       "      <th>PhoneService</th>\n",
       "      <th>MultipleLines</th>\n",
       "      <th>InternetService</th>\n",
       "      <th>...</th>\n",
       "      <th>OnlineBackup</th>\n",
       "      <th>DeviceProtection</th>\n",
       "      <th>TechSupport</th>\n",
       "      <th>StreamingTV</th>\n",
       "      <th>StreamingMovies</th>\n",
       "      <th>Contract</th>\n",
       "      <th>PaperlessBilling</th>\n",
       "      <th>PaymentMethod</th>\n",
       "      <th>Charges_Monthly</th>\n",
       "      <th>Charges_Total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0002-ORFBO</td>\n",
       "      <td>No</td>\n",
       "      <td>Female</td>\n",
       "      <td>0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>9</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>One year</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Mailed check</td>\n",
       "      <td>65.60</td>\n",
       "      <td>593.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0003-MKNFE</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>0</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>9</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Month-to-month</td>\n",
       "      <td>No</td>\n",
       "      <td>Mailed check</td>\n",
       "      <td>59.90</td>\n",
       "      <td>542.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0004-TLHLJ</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Male</td>\n",
       "      <td>0</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>4</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Fiber optic</td>\n",
       "      <td>...</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Month-to-month</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Electronic check</td>\n",
       "      <td>73.90</td>\n",
       "      <td>280.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0011-IGKFF</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Male</td>\n",
       "      <td>1</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>13</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Fiber optic</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Month-to-month</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Electronic check</td>\n",
       "      <td>98.00</td>\n",
       "      <td>1237.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0013-EXCHZ</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Female</td>\n",
       "      <td>1</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>3</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Fiber optic</td>\n",
       "      <td>...</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Month-to-month</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Mailed check</td>\n",
       "      <td>83.90</td>\n",
       "      <td>267.4</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>7262</th>\n",
       "      <td>9987-LUTYD</td>\n",
       "      <td>No</td>\n",
       "      <td>Female</td>\n",
       "      <td>0</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>13</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>One year</td>\n",
       "      <td>No</td>\n",
       "      <td>Mailed check</td>\n",
       "      <td>55.15</td>\n",
       "      <td>742.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7263</th>\n",
       "      <td>9992-RRAMN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Male</td>\n",
       "      <td>0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>22</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Fiber optic</td>\n",
       "      <td>...</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Month-to-month</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Electronic check</td>\n",
       "      <td>85.10</td>\n",
       "      <td>1873.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7264</th>\n",
       "      <td>9992-UJOEL</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>0</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>2</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Month-to-month</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Mailed check</td>\n",
       "      <td>50.30</td>\n",
       "      <td>92.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7265</th>\n",
       "      <td>9993-LHIEB</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>67</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Two year</td>\n",
       "      <td>No</td>\n",
       "      <td>Mailed check</td>\n",
       "      <td>67.85</td>\n",
       "      <td>4627.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7266</th>\n",
       "      <td>9995-HOTOH</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>63</td>\n",
       "      <td>No</td>\n",
       "      <td>No phone service</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Two year</td>\n",
       "      <td>No</td>\n",
       "      <td>Electronic check</td>\n",
       "      <td>59.00</td>\n",
       "      <td>3707.6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7267 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      customerID Churn  gender  SeniorCitizen Partner Dependents  tenure  \\\n",
       "0     0002-ORFBO    No  Female              0     Yes        Yes       9   \n",
       "1     0003-MKNFE    No    Male              0      No         No       9   \n",
       "2     0004-TLHLJ   Yes    Male              0      No         No       4   \n",
       "3     0011-IGKFF   Yes    Male              1     Yes         No      13   \n",
       "4     0013-EXCHZ   Yes  Female              1     Yes         No       3   \n",
       "...          ...   ...     ...            ...     ...        ...     ...   \n",
       "7262  9987-LUTYD    No  Female              0      No         No      13   \n",
       "7263  9992-RRAMN   Yes    Male              0     Yes         No      22   \n",
       "7264  9992-UJOEL    No    Male              0      No         No       2   \n",
       "7265  9993-LHIEB    No    Male              0     Yes        Yes      67   \n",
       "7266  9995-HOTOH    No    Male              0     Yes        Yes      63   \n",
       "\n",
       "     PhoneService     MultipleLines InternetService  ... OnlineBackup  \\\n",
       "0             Yes                No             DSL  ...          Yes   \n",
       "1             Yes               Yes             DSL  ...           No   \n",
       "2             Yes                No     Fiber optic  ...           No   \n",
       "3             Yes                No     Fiber optic  ...          Yes   \n",
       "4             Yes                No     Fiber optic  ...           No   \n",
       "...           ...               ...             ...  ...          ...   \n",
       "7262          Yes                No             DSL  ...           No   \n",
       "7263          Yes               Yes     Fiber optic  ...           No   \n",
       "7264          Yes                No             DSL  ...          Yes   \n",
       "7265          Yes                No             DSL  ...           No   \n",
       "7266           No  No phone service             DSL  ...          Yes   \n",
       "\n",
       "     DeviceProtection TechSupport StreamingTV StreamingMovies        Contract  \\\n",
       "0                  No         Yes         Yes              No        One year   \n",
       "1                  No          No          No             Yes  Month-to-month   \n",
       "2                 Yes          No          No              No  Month-to-month   \n",
       "3                 Yes          No         Yes             Yes  Month-to-month   \n",
       "4                  No         Yes         Yes              No  Month-to-month   \n",
       "...               ...         ...         ...             ...             ...   \n",
       "7262               No         Yes          No              No        One year   \n",
       "7263               No          No          No             Yes  Month-to-month   \n",
       "7264               No          No          No              No  Month-to-month   \n",
       "7265              Yes         Yes          No             Yes        Two year   \n",
       "7266              Yes          No         Yes             Yes        Two year   \n",
       "\n",
       "     PaperlessBilling     PaymentMethod Charges_Monthly  Charges_Total  \n",
       "0                 Yes      Mailed check           65.60          593.3  \n",
       "1                  No      Mailed check           59.90          542.4  \n",
       "2                 Yes  Electronic check           73.90         280.85  \n",
       "3                 Yes  Electronic check           98.00        1237.85  \n",
       "4                 Yes      Mailed check           83.90          267.4  \n",
       "...               ...               ...             ...            ...  \n",
       "7262               No      Mailed check           55.15          742.9  \n",
       "7263              Yes  Electronic check           85.10         1873.7  \n",
       "7264              Yes      Mailed check           50.30          92.75  \n",
       "7265               No      Mailed check           67.85        4627.65  \n",
       "7266               No  Electronic check           59.00         3707.6  \n",
       "\n",
       "[7267 rows x 21 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ecbe0c21",
   "metadata": {},
   "source": [
    "Podemos utlizar um dicionario que a empresa disponibizou para poder endenter mais detalhadamente o significado de cada coluna\n",
    "\n",
    "### Dicionário de dados\n",
    "* __customerID:__ número de identificação único de cada cliente\n",
    "* __Churn:__ se o cliente deixou ou não a empresa\n",
    "* __gender:__ gênero (masculino e feminino)\n",
    "* __SeniorCitizen:__ informação sobre um cliente ter ou não idade igual ou maior que 65 anos\n",
    "* __Partner:__ se o cliente possui ou não um parceiro ou parceira\n",
    "* __Dependents:__ se o cliente possui ou não dependentes\n",
    "* __tenure:__ meses de contrato do cliente\n",
    "* __PhoneService:__ assinatura de serviço telefônico\n",
    "* __MultipleLines:__ assisnatura de mais de uma linha de telefone\n",
    "* __InternetService:__ assinatura de um provedor internet\n",
    "* __OnlineSecurity:__ assinatura adicional de segurança online\n",
    "* __OnlineBackup:__ assinatura adicional de backup online\n",
    "* __DeviceProtection:__ assinatura adicional de proteção no dispositivo\n",
    "* __TechSupport:__ assinatura adicional de suporte técnico, menos tempo de espera\n",
    "* __StreamingTV:__ assinatura de TV a cabo\n",
    "* __StreamingMovies:__ assinatura de streaming de filmes\n",
    "* __Contract:__ tipo de contrato\n",
    "* __PaperlessBilling:__ se o cliente prefere receber online a fatura\n",
    "* __PaymentMethod:__ forma de pagamento\n",
    "* __Charges.Monthly:__ total de todos os serviços do cliente por mês\n",
    "* __Charges.Total:__ total gasto pelo cliente"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "d25186e5",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Quantidades de linhas e colunas:  (7267, 21)\n"
     ]
    }
   ],
   "source": [
    "print(\"Quantidades de linhas e colunas: \", dados.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "9389eeca",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 7267 entries, 0 to 7266\n",
      "Data columns (total 21 columns):\n",
      " #   Column            Non-Null Count  Dtype  \n",
      "---  ------            --------------  -----  \n",
      " 0   customerID        7267 non-null   object \n",
      " 1   Churn             7267 non-null   object \n",
      " 2   gender            7267 non-null   object \n",
      " 3   SeniorCitizen     7267 non-null   int64  \n",
      " 4   Partner           7267 non-null   object \n",
      " 5   Dependents        7267 non-null   object \n",
      " 6   tenure            7267 non-null   int64  \n",
      " 7   PhoneService      7267 non-null   object \n",
      " 8   MultipleLines     7267 non-null   object \n",
      " 9   InternetService   7267 non-null   object \n",
      " 10  OnlineSecurity    7267 non-null   object \n",
      " 11  OnlineBackup      7267 non-null   object \n",
      " 12  DeviceProtection  7267 non-null   object \n",
      " 13  TechSupport       7267 non-null   object \n",
      " 14  StreamingTV       7267 non-null   object \n",
      " 15  StreamingMovies   7267 non-null   object \n",
      " 16  Contract          7267 non-null   object \n",
      " 17  PaperlessBilling  7267 non-null   object \n",
      " 18  PaymentMethod     7267 non-null   object \n",
      " 19  Charges_Monthly   7267 non-null   float64\n",
      " 20  Charges_Total     7267 non-null   object \n",
      "dtypes: float64(1), int64(2), object(18)\n",
      "memory usage: 1.2+ MB\n"
     ]
    }
   ],
   "source": [
    "dados.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "516112d4",
   "metadata": {},
   "source": [
    "Vamos utilizar o método value_counts() em cada uma das colunas para indentificar possíveis categorias com nomes incorretos ou incoerentes."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "5e718d96",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "---------\n",
      "Numero de dados unicos: 7267\n",
      "Dados unicos: ['0002-ORFBO' '0003-MKNFE' '0004-TLHLJ' ... '9992-UJOEL' '9993-LHIEB'\n",
      " '9995-HOTOH']\n",
      "0002-ORFBO    1\n",
      "6614-VBEGU    1\n",
      "6637-KYRCV    1\n",
      "6635-MYYYZ    1\n",
      "6635-CPNUN    1\n",
      "             ..\n",
      "3374-TTZTK    1\n",
      "3374-PZLXD    1\n",
      "3374-LXDEV    1\n",
      "3373-YZZYM    1\n",
      "9995-HOTOH    1\n",
      "Name: customerID, Length: 7267, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 3\n",
      "Dados unicos: ['No' 'Yes' '']\n",
      "No     5174\n",
      "Yes    1869\n",
      "        224\n",
      "Name: Churn, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 2\n",
      "Dados unicos: ['Female' 'Male']\n",
      "Male      3675\n",
      "Female    3592\n",
      "Name: gender, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 2\n",
      "Dados unicos: [0 1]\n",
      "0    6085\n",
      "1    1182\n",
      "Name: SeniorCitizen, dtype: int64\n",
      "Tipo da coluna: int64\n",
      "---------\n",
      "Numero de dados unicos: 2\n",
      "Dados unicos: ['Yes' 'No']\n",
      "No     3749\n",
      "Yes    3518\n",
      "Name: Partner, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 2\n",
      "Dados unicos: ['Yes' 'No']\n",
      "No     5086\n",
      "Yes    2181\n",
      "Name: Dependents, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 73\n",
      "Dados unicos: [ 9  4 13  3 71 63  7 65 54 72  5 56 34  1 45 50 23 55 26 69 11 37 49 66\n",
      " 67 20 43 59 12 27  2 25 29 14 35 64 39 40  6 30 70 57 58 16 32 33 10 21\n",
      " 61 15 44 22 24 19 47 62 46 52  8 60 48 28 41 53 68 51 31 36 17 18 38 42\n",
      "  0]\n",
      "1     634\n",
      "72    369\n",
      "2     246\n",
      "3     207\n",
      "4     185\n",
      "     ... \n",
      "38     60\n",
      "39     59\n",
      "44     54\n",
      "36     50\n",
      "0      11\n",
      "Name: tenure, Length: 73, dtype: int64\n",
      "Tipo da coluna: int64\n",
      "---------\n",
      "Numero de dados unicos: 2\n",
      "Dados unicos: ['Yes' 'No']\n",
      "Yes    6560\n",
      "No      707\n",
      "Name: PhoneService, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 3\n",
      "Dados unicos: ['No' 'Yes' 'No phone service']\n",
      "No                  3495\n",
      "Yes                 3065\n",
      "No phone service     707\n",
      "Name: MultipleLines, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 3\n",
      "Dados unicos: ['DSL' 'Fiber optic' 'No']\n",
      "Fiber optic    3198\n",
      "DSL            2488\n",
      "No             1581\n",
      "Name: InternetService, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 3\n",
      "Dados unicos: ['No' 'Yes' 'No internet service']\n",
      "No                     3608\n",
      "Yes                    2078\n",
      "No internet service    1581\n",
      "Name: OnlineSecurity, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 3\n",
      "Dados unicos: ['Yes' 'No' 'No internet service']\n",
      "No                     3182\n",
      "Yes                    2504\n",
      "No internet service    1581\n",
      "Name: OnlineBackup, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 3\n",
      "Dados unicos: ['No' 'Yes' 'No internet service']\n",
      "No                     3195\n",
      "Yes                    2491\n",
      "No internet service    1581\n",
      "Name: DeviceProtection, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 3\n",
      "Dados unicos: ['Yes' 'No' 'No internet service']\n",
      "No                     3582\n",
      "Yes                    2104\n",
      "No internet service    1581\n",
      "Name: TechSupport, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 3\n",
      "Dados unicos: ['Yes' 'No' 'No internet service']\n",
      "No                     2896\n",
      "Yes                    2790\n",
      "No internet service    1581\n",
      "Name: StreamingTV, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 3\n",
      "Dados unicos: ['No' 'Yes' 'No internet service']\n",
      "No                     2870\n",
      "Yes                    2816\n",
      "No internet service    1581\n",
      "Name: StreamingMovies, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 3\n",
      "Dados unicos: ['One year' 'Month-to-month' 'Two year']\n",
      "Month-to-month    4005\n",
      "Two year          1743\n",
      "One year          1519\n",
      "Name: Contract, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 2\n",
      "Dados unicos: ['Yes' 'No']\n",
      "Yes    4311\n",
      "No     2956\n",
      "Name: PaperlessBilling, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 4\n",
      "Dados unicos: ['Mailed check' 'Electronic check' 'Credit card (automatic)'\n",
      " 'Bank transfer (automatic)']\n",
      "Electronic check             2445\n",
      "Mailed check                 1665\n",
      "Bank transfer (automatic)    1589\n",
      "Credit card (automatic)      1568\n",
      "Name: PaymentMethod, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 1585\n",
      "Dados unicos: [65.6  59.9  73.9  ... 91.75 68.8  67.85]\n",
      "20.05     65\n",
      "19.85     46\n",
      "19.90     46\n",
      "19.70     45\n",
      "19.55     45\n",
      "          ..\n",
      "23.45      1\n",
      "116.55     1\n",
      "106.85     1\n",
      "68.55      1\n",
      "67.85      1\n",
      "Name: Charges_Monthly, Length: 1585, dtype: int64\n",
      "Tipo da coluna: float64\n",
      "---------\n",
      "Numero de dados unicos: 6531\n",
      "Dados unicos: ['593.3' '542.4' '280.85' ... '742.9' '4627.65' '3707.6']\n",
      "           11\n",
      "20.2       11\n",
      "19.75       9\n",
      "19.55       9\n",
      "19.9        9\n",
      "           ..\n",
      "272         1\n",
      "1426.45     1\n",
      "371.6       1\n",
      "6786.4      1\n",
      "3707.6      1\n",
      "Name: Charges_Total, Length: 6531, dtype: int64\n",
      "Tipo da coluna: object\n"
     ]
    }
   ],
   "source": [
    "for coluna in dados.columns:\n",
    "    print('---------')\n",
    "    print(f'Numero de dados unicos: {dados[coluna].nunique()}')\n",
    "    print(f'Dados unicos: {dados[coluna].unique()}')\n",
    "    print(dados[coluna].value_counts())\n",
    "    print(f'Tipo da coluna: {dados[coluna].dtype}')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "32f765cb",
   "metadata": {},
   "source": [
    "### Relatorio da Analise dos Dados"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4cd22bec",
   "metadata": {},
   "source": [
    "- Observando a coluna _customerID_ podemos concluir que não há nenhum ID duplicado e podemos dizer que não há linhas duplicadas no dataset\n",
    "\n",
    "- Na coluna _Churn_ temos 224 dados não nomeados que precisam ser melhor analisados\n",
    "\n",
    "- Segundo o dicionario a coluna _SeniorCitzen_ contem informações sobre o cliente ter idade igual ou maior de 65 anos, e pelo padrão adotado por outras colunas podemos substituir os valores (0 1) por (Yes' 'No') para manter o padrão do dataset\n",
    "\n",
    "- Em Charges.Total tambem temos dados não faltantes e tambem podemos ver que o tipo da coluna é object e devemos mudar para float"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "be2dec10",
   "metadata": {},
   "source": [
    "## Corrigindo as incosistências nos dados"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2937cc8f",
   "metadata": {},
   "source": [
    "#### Analisando a coluna _Churn_"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "ff568ad3",
   "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>customerID</th>\n",
       "      <th>Churn</th>\n",
       "      <th>gender</th>\n",
       "      <th>SeniorCitizen</th>\n",
       "      <th>Partner</th>\n",
       "      <th>Dependents</th>\n",
       "      <th>tenure</th>\n",
       "      <th>PhoneService</th>\n",
       "      <th>MultipleLines</th>\n",
       "      <th>InternetService</th>\n",
       "      <th>...</th>\n",
       "      <th>OnlineBackup</th>\n",
       "      <th>DeviceProtection</th>\n",
       "      <th>TechSupport</th>\n",
       "      <th>StreamingTV</th>\n",
       "      <th>StreamingMovies</th>\n",
       "      <th>Contract</th>\n",
       "      <th>PaperlessBilling</th>\n",
       "      <th>PaymentMethod</th>\n",
       "      <th>Charges_Monthly</th>\n",
       "      <th>Charges_Total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>0047-ZHDTW</td>\n",
       "      <td></td>\n",
       "      <td>Female</td>\n",
       "      <td>0</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>11</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Fiber optic</td>\n",
       "      <td>...</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Month-to-month</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Bank transfer (automatic)</td>\n",
       "      <td>79.00</td>\n",
       "      <td>929.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>0120-YZLQA</td>\n",
       "      <td></td>\n",
       "      <td>Male</td>\n",
       "      <td>0</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>71</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>Two year</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Credit card (automatic)</td>\n",
       "      <td>19.90</td>\n",
       "      <td>1355.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>0154-QYHJU</td>\n",
       "      <td></td>\n",
       "      <td>Male</td>\n",
       "      <td>0</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>29</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>One year</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Electronic check</td>\n",
       "      <td>58.75</td>\n",
       "      <td>1696.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>0162-RZGMZ</td>\n",
       "      <td></td>\n",
       "      <td>Female</td>\n",
       "      <td>1</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>5</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Month-to-month</td>\n",
       "      <td>No</td>\n",
       "      <td>Credit card (automatic)</td>\n",
       "      <td>59.90</td>\n",
       "      <td>287.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>0274-VVQOQ</td>\n",
       "      <td></td>\n",
       "      <td>Male</td>\n",
       "      <td>1</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>65</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Fiber optic</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>One year</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Bank transfer (automatic)</td>\n",
       "      <td>103.15</td>\n",
       "      <td>6792.45</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>7158</th>\n",
       "      <td>9840-GSRFX</td>\n",
       "      <td></td>\n",
       "      <td>Female</td>\n",
       "      <td>0</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>14</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>One year</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Mailed check</td>\n",
       "      <td>54.25</td>\n",
       "      <td>773.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7180</th>\n",
       "      <td>9872-RZQQB</td>\n",
       "      <td></td>\n",
       "      <td>Female</td>\n",
       "      <td>0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>49</td>\n",
       "      <td>No</td>\n",
       "      <td>No phone service</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Month-to-month</td>\n",
       "      <td>No</td>\n",
       "      <td>Bank transfer (automatic)</td>\n",
       "      <td>40.65</td>\n",
       "      <td>2070.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7211</th>\n",
       "      <td>9920-GNDMB</td>\n",
       "      <td></td>\n",
       "      <td>Male</td>\n",
       "      <td>0</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>9</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Fiber optic</td>\n",
       "      <td>...</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Month-to-month</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Electronic check</td>\n",
       "      <td>76.25</td>\n",
       "      <td>684.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7239</th>\n",
       "      <td>9955-RVWSC</td>\n",
       "      <td></td>\n",
       "      <td>Female</td>\n",
       "      <td>0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>67</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>Two year</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Bank transfer (automatic)</td>\n",
       "      <td>19.25</td>\n",
       "      <td>1372.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7247</th>\n",
       "      <td>9966-VYRTZ</td>\n",
       "      <td></td>\n",
       "      <td>Female</td>\n",
       "      <td>0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>31</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>Month-to-month</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Mailed check</td>\n",
       "      <td>19.55</td>\n",
       "      <td>658.95</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>224 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      customerID Churn  gender  SeniorCitizen Partner Dependents  tenure  \\\n",
       "30    0047-ZHDTW        Female              0      No         No      11   \n",
       "75    0120-YZLQA          Male              0      No         No      71   \n",
       "96    0154-QYHJU          Male              0      No         No      29   \n",
       "98    0162-RZGMZ        Female              1      No         No       5   \n",
       "175   0274-VVQOQ          Male              1     Yes         No      65   \n",
       "...          ...   ...     ...            ...     ...        ...     ...   \n",
       "7158  9840-GSRFX        Female              0      No         No      14   \n",
       "7180  9872-RZQQB        Female              0     Yes         No      49   \n",
       "7211  9920-GNDMB          Male              0      No         No       9   \n",
       "7239  9955-RVWSC        Female              0     Yes        Yes      67   \n",
       "7247  9966-VYRTZ        Female              0     Yes        Yes      31   \n",
       "\n",
       "     PhoneService     MultipleLines InternetService  ...         OnlineBackup  \\\n",
       "30            Yes               Yes     Fiber optic  ...                   No   \n",
       "75            Yes                No              No  ...  No internet service   \n",
       "96            Yes                No             DSL  ...                  Yes   \n",
       "98            Yes                No             DSL  ...                  Yes   \n",
       "175           Yes               Yes     Fiber optic  ...                  Yes   \n",
       "...           ...               ...             ...  ...                  ...   \n",
       "7158          Yes               Yes             DSL  ...                  Yes   \n",
       "7180           No  No phone service             DSL  ...                   No   \n",
       "7211          Yes               Yes     Fiber optic  ...                   No   \n",
       "7239          Yes                No              No  ...  No internet service   \n",
       "7247          Yes                No              No  ...  No internet service   \n",
       "\n",
       "         DeviceProtection          TechSupport          StreamingTV  \\\n",
       "30                     No                   No                   No   \n",
       "75    No internet service  No internet service  No internet service   \n",
       "96                     No                  Yes                   No   \n",
       "98                     No                  Yes                   No   \n",
       "175                   Yes                   No                  Yes   \n",
       "...                   ...                  ...                  ...   \n",
       "7158                   No                   No                   No   \n",
       "7180                   No                   No                  Yes   \n",
       "7211                   No                   No                   No   \n",
       "7239  No internet service  No internet service  No internet service   \n",
       "7247  No internet service  No internet service  No internet service   \n",
       "\n",
       "          StreamingMovies        Contract PaperlessBilling  \\\n",
       "30                     No  Month-to-month              Yes   \n",
       "75    No internet service        Two year              Yes   \n",
       "96                     No        One year              Yes   \n",
       "98                     No  Month-to-month               No   \n",
       "175                   Yes        One year              Yes   \n",
       "...                   ...             ...              ...   \n",
       "7158                   No        One year              Yes   \n",
       "7180                   No  Month-to-month               No   \n",
       "7211                   No  Month-to-month              Yes   \n",
       "7239  No internet service        Two year              Yes   \n",
       "7247  No internet service  Month-to-month              Yes   \n",
       "\n",
       "                  PaymentMethod Charges_Monthly  Charges_Total  \n",
       "30    Bank transfer (automatic)           79.00          929.3  \n",
       "75      Credit card (automatic)           19.90         1355.1  \n",
       "96             Electronic check           58.75         1696.2  \n",
       "98      Credit card (automatic)           59.90         287.85  \n",
       "175   Bank transfer (automatic)          103.15        6792.45  \n",
       "...                         ...             ...            ...  \n",
       "7158               Mailed check           54.25          773.2  \n",
       "7180  Bank transfer (automatic)           40.65        2070.75  \n",
       "7211           Electronic check           76.25         684.85  \n",
       "7239  Bank transfer (automatic)           19.25         1372.9  \n",
       "7247               Mailed check           19.55         658.95  \n",
       "\n",
       "[224 rows x 21 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados.loc[dados['Churn']== '']"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9fc8b22c",
   "metadata": {},
   "source": [
    "Analisando o dataset não podemos achar um motivo para a ausencia dos dados (provavelmente foi algum erro estrutural que ocasionou a falta desses dados)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "441e1fad",
   "metadata": {},
   "source": [
    "Para não ter problemas nas analises futuras do nosso dataset iremos remover esses dados"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "5828bcb3",
   "metadata": {},
   "outputs": [],
   "source": [
    "dados = dados.loc[dados['Churn'] != ''].reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "a7b8e1d1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "No     5174\n",
       "Yes    1869\n",
       "Name: Churn, dtype: int64"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados['Churn'].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d88ef474",
   "metadata": {},
   "source": [
    "### Analisando _SeniorCitzen_\n",
    "\n",
    "**Na hora de fazer analises com os dados foi constatado que era melhor usar valores numericos aqui então vou comentar por enquanto**"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0ce045a5",
   "metadata": {},
   "source": [
    "Iremos substuir os valores para manter o padão do resto das colunas do dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "711db2bf",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    5901\n",
       "1    1142\n",
       "Name: SeniorCitizen, dtype: int64"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados['SeniorCitizen'].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "475e0014",
   "metadata": {},
   "source": [
    "Sera criado um dicionario que contem as chaves com os valores que serão trocados e depois sera itilizado a função replace() "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "e8d5ea41",
   "metadata": {},
   "outputs": [],
   "source": [
    "# yes_no = {\n",
    "#     0 : 'No',\n",
    "#     1 : 'Yes'\n",
    "# }"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "09e3c372",
   "metadata": {},
   "outputs": [],
   "source": [
    "# dados.loc[:, 'SeniorCitizen'] = dados['SeniorCitizen'].replace(yes_no)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "07b469cc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    5901\n",
       "1    1142\n",
       "Name: SeniorCitizen, dtype: int64"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados['SeniorCitizen'].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "24288b50",
   "metadata": {},
   "source": [
    "### Analisando _Charges.Total_ "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "d3942c3f",
   "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>customerID</th>\n",
       "      <th>Churn</th>\n",
       "      <th>gender</th>\n",
       "      <th>SeniorCitizen</th>\n",
       "      <th>Partner</th>\n",
       "      <th>Dependents</th>\n",
       "      <th>tenure</th>\n",
       "      <th>PhoneService</th>\n",
       "      <th>MultipleLines</th>\n",
       "      <th>InternetService</th>\n",
       "      <th>...</th>\n",
       "      <th>OnlineBackup</th>\n",
       "      <th>DeviceProtection</th>\n",
       "      <th>TechSupport</th>\n",
       "      <th>StreamingTV</th>\n",
       "      <th>StreamingMovies</th>\n",
       "      <th>Contract</th>\n",
       "      <th>PaperlessBilling</th>\n",
       "      <th>PaymentMethod</th>\n",
       "      <th>Charges_Monthly</th>\n",
       "      <th>Charges_Total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>945</th>\n",
       "      <td>1371-DWPAZ</td>\n",
       "      <td>No</td>\n",
       "      <td>Female</td>\n",
       "      <td>0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>0</td>\n",
       "      <td>No</td>\n",
       "      <td>No phone service</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Two year</td>\n",
       "      <td>No</td>\n",
       "      <td>Credit card (automatic)</td>\n",
       "      <td>56.05</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1731</th>\n",
       "      <td>2520-SGTTA</td>\n",
       "      <td>No</td>\n",
       "      <td>Female</td>\n",
       "      <td>0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>Two year</td>\n",
       "      <td>No</td>\n",
       "      <td>Mailed check</td>\n",
       "      <td>20.00</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1906</th>\n",
       "      <td>2775-SEFEE</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>0</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Two year</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Bank transfer (automatic)</td>\n",
       "      <td>61.90</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025</th>\n",
       "      <td>2923-ARZLG</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>One year</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Mailed check</td>\n",
       "      <td>19.70</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2176</th>\n",
       "      <td>3115-CZMZD</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>0</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>Two year</td>\n",
       "      <td>No</td>\n",
       "      <td>Mailed check</td>\n",
       "      <td>20.25</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2250</th>\n",
       "      <td>3213-VVOLG</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>Two year</td>\n",
       "      <td>No</td>\n",
       "      <td>Mailed check</td>\n",
       "      <td>25.35</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2855</th>\n",
       "      <td>4075-WKNIU</td>\n",
       "      <td>No</td>\n",
       "      <td>Female</td>\n",
       "      <td>0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Two year</td>\n",
       "      <td>No</td>\n",
       "      <td>Mailed check</td>\n",
       "      <td>73.35</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3052</th>\n",
       "      <td>4367-NUYAO</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>Two year</td>\n",
       "      <td>No</td>\n",
       "      <td>Mailed check</td>\n",
       "      <td>25.75</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3118</th>\n",
       "      <td>4472-LVYGI</td>\n",
       "      <td>No</td>\n",
       "      <td>Female</td>\n",
       "      <td>0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>0</td>\n",
       "      <td>No</td>\n",
       "      <td>No phone service</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Two year</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Bank transfer (automatic)</td>\n",
       "      <td>52.55</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4054</th>\n",
       "      <td>5709-LVOEQ</td>\n",
       "      <td>No</td>\n",
       "      <td>Female</td>\n",
       "      <td>0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Two year</td>\n",
       "      <td>No</td>\n",
       "      <td>Mailed check</td>\n",
       "      <td>80.85</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5433</th>\n",
       "      <td>7644-OMVMY</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>...</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>No internet service</td>\n",
       "      <td>Two year</td>\n",
       "      <td>No</td>\n",
       "      <td>Mailed check</td>\n",
       "      <td>19.85</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      customerID Churn  gender  SeniorCitizen Partner Dependents  tenure  \\\n",
       "945   1371-DWPAZ    No  Female              0     Yes        Yes       0   \n",
       "1731  2520-SGTTA    No  Female              0     Yes        Yes       0   \n",
       "1906  2775-SEFEE    No    Male              0      No        Yes       0   \n",
       "2025  2923-ARZLG    No    Male              0     Yes        Yes       0   \n",
       "2176  3115-CZMZD    No    Male              0      No        Yes       0   \n",
       "2250  3213-VVOLG    No    Male              0     Yes        Yes       0   \n",
       "2855  4075-WKNIU    No  Female              0     Yes        Yes       0   \n",
       "3052  4367-NUYAO    No    Male              0     Yes        Yes       0   \n",
       "3118  4472-LVYGI    No  Female              0     Yes        Yes       0   \n",
       "4054  5709-LVOEQ    No  Female              0     Yes        Yes       0   \n",
       "5433  7644-OMVMY    No    Male              0     Yes        Yes       0   \n",
       "\n",
       "     PhoneService     MultipleLines InternetService  ...         OnlineBackup  \\\n",
       "945            No  No phone service             DSL  ...                  Yes   \n",
       "1731          Yes                No              No  ...  No internet service   \n",
       "1906          Yes               Yes             DSL  ...                  Yes   \n",
       "2025          Yes                No              No  ...  No internet service   \n",
       "2176          Yes                No              No  ...  No internet service   \n",
       "2250          Yes               Yes              No  ...  No internet service   \n",
       "2855          Yes               Yes             DSL  ...                  Yes   \n",
       "3052          Yes               Yes              No  ...  No internet service   \n",
       "3118           No  No phone service             DSL  ...                   No   \n",
       "4054          Yes                No             DSL  ...                  Yes   \n",
       "5433          Yes                No              No  ...  No internet service   \n",
       "\n",
       "         DeviceProtection          TechSupport          StreamingTV  \\\n",
       "945                   Yes                  Yes                  Yes   \n",
       "1731  No internet service  No internet service  No internet service   \n",
       "1906                   No                  Yes                   No   \n",
       "2025  No internet service  No internet service  No internet service   \n",
       "2176  No internet service  No internet service  No internet service   \n",
       "2250  No internet service  No internet service  No internet service   \n",
       "2855                  Yes                  Yes                  Yes   \n",
       "3052  No internet service  No internet service  No internet service   \n",
       "3118                  Yes                  Yes                  Yes   \n",
       "4054                  Yes                   No                  Yes   \n",
       "5433  No internet service  No internet service  No internet service   \n",
       "\n",
       "          StreamingMovies  Contract PaperlessBilling  \\\n",
       "945                    No  Two year               No   \n",
       "1731  No internet service  Two year               No   \n",
       "1906                   No  Two year              Yes   \n",
       "2025  No internet service  One year              Yes   \n",
       "2176  No internet service  Two year               No   \n",
       "2250  No internet service  Two year               No   \n",
       "2855                   No  Two year               No   \n",
       "3052  No internet service  Two year               No   \n",
       "3118                   No  Two year              Yes   \n",
       "4054                  Yes  Two year               No   \n",
       "5433  No internet service  Two year               No   \n",
       "\n",
       "                  PaymentMethod Charges_Monthly  Charges_Total  \n",
       "945     Credit card (automatic)           56.05                 \n",
       "1731               Mailed check           20.00                 \n",
       "1906  Bank transfer (automatic)           61.90                 \n",
       "2025               Mailed check           19.70                 \n",
       "2176               Mailed check           20.25                 \n",
       "2250               Mailed check           25.35                 \n",
       "2855               Mailed check           73.35                 \n",
       "3052               Mailed check           25.75                 \n",
       "3118  Bank transfer (automatic)           52.55                 \n",
       "4054               Mailed check           80.85                 \n",
       "5433               Mailed check           19.85                 \n",
       "\n",
       "[11 rows x 21 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados.loc[dados['Charges_Total'] == ' ']"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a872a6ee",
   "metadata": {},
   "source": [
    "Usando o dicionario podemos observar que a coluna _Charges.Total_ tem uma relação com as colunas _Charges.Monthly_ e _tenure_."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "73e09af6",
   "metadata": {},
   "source": [
    " - A coluna __tenure__ representa a quantidade de meses em que o cliente estava assinando o serviço. \n",
    " - A coluna __Charges.Monthly__ representa os gastos mensais do cliente \n",
    " - __Charges.Total__ é a quantidade total de gastos, portanto seria uma multiplicação de Charges.Monthly por tenure."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e012eb7a",
   "metadata": {},
   "source": [
    "Quando tenure == 0, os dados de Charges.Total é vazio (' ')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8054c984",
   "metadata": {},
   "source": [
    "Vamos selecionar todas as linhas onde o _tenure_ == 0, ou seja, os clientes que assinaram o serviço por 0 meses, e mostrar os resultados para as colunas _Charges.Total_ e _Charges.Monthly._"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "1c94a30a",
   "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>tenure</th>\n",
       "      <th>Charges_Monthly</th>\n",
       "      <th>Charges_Total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>945</th>\n",
       "      <td>0</td>\n",
       "      <td>56.05</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1731</th>\n",
       "      <td>0</td>\n",
       "      <td>20.00</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1906</th>\n",
       "      <td>0</td>\n",
       "      <td>61.90</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025</th>\n",
       "      <td>0</td>\n",
       "      <td>19.70</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2176</th>\n",
       "      <td>0</td>\n",
       "      <td>20.25</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2250</th>\n",
       "      <td>0</td>\n",
       "      <td>25.35</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2855</th>\n",
       "      <td>0</td>\n",
       "      <td>73.35</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3052</th>\n",
       "      <td>0</td>\n",
       "      <td>25.75</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3118</th>\n",
       "      <td>0</td>\n",
       "      <td>52.55</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4054</th>\n",
       "      <td>0</td>\n",
       "      <td>80.85</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5433</th>\n",
       "      <td>0</td>\n",
       "      <td>19.85</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      tenure  Charges_Monthly Charges_Total\n",
       "945        0            56.05              \n",
       "1731       0            20.00              \n",
       "1906       0            61.90              \n",
       "2025       0            19.70              \n",
       "2176       0            20.25              \n",
       "2250       0            25.35              \n",
       "2855       0            73.35              \n",
       "3052       0            25.75              \n",
       "3118       0            52.55              \n",
       "4054       0            80.85              \n",
       "5433       0            19.85              "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados.loc[dados['tenure'] == 0, ['tenure', 'Charges_Monthly', 'Charges_Total']]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0deb61cc",
   "metadata": {},
   "source": [
    "Percebe-se que todas as linhas de __Charges.Total__ que estão vazias é porque o cliente não assinou nem por um mês. Temos que preencher esse valor com o mesmo valor que está presente em __Charges.Monthly__ pois esse representa o total."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "66737413",
   "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>tenure</th>\n",
       "      <th>Charges_Monthly</th>\n",
       "      <th>Charges_Total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>945</th>\n",
       "      <td>0</td>\n",
       "      <td>56.05</td>\n",
       "      <td>56.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1731</th>\n",
       "      <td>0</td>\n",
       "      <td>20.00</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1906</th>\n",
       "      <td>0</td>\n",
       "      <td>61.90</td>\n",
       "      <td>61.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025</th>\n",
       "      <td>0</td>\n",
       "      <td>19.70</td>\n",
       "      <td>19.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2176</th>\n",
       "      <td>0</td>\n",
       "      <td>20.25</td>\n",
       "      <td>20.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2250</th>\n",
       "      <td>0</td>\n",
       "      <td>25.35</td>\n",
       "      <td>25.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2855</th>\n",
       "      <td>0</td>\n",
       "      <td>73.35</td>\n",
       "      <td>73.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3052</th>\n",
       "      <td>0</td>\n",
       "      <td>25.75</td>\n",
       "      <td>25.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3118</th>\n",
       "      <td>0</td>\n",
       "      <td>52.55</td>\n",
       "      <td>52.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4054</th>\n",
       "      <td>0</td>\n",
       "      <td>80.85</td>\n",
       "      <td>80.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5433</th>\n",
       "      <td>0</td>\n",
       "      <td>19.85</td>\n",
       "      <td>19.85</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      tenure  Charges_Monthly Charges_Total\n",
       "945        0            56.05         56.05\n",
       "1731       0            20.00          20.0\n",
       "1906       0            61.90          61.9\n",
       "2025       0            19.70          19.7\n",
       "2176       0            20.25         20.25\n",
       "2250       0            25.35         25.35\n",
       "2855       0            73.35         73.35\n",
       "3052       0            25.75         25.75\n",
       "3118       0            52.55         52.55\n",
       "4054       0            80.85         80.85\n",
       "5433       0            19.85         19.85"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "idx = dados.loc[dados['Charges_Total'] == ' '].index\n",
    "dados.loc[idx, \"Charges_Total\"] = dados.loc[idx, \"Charges_Monthly\"]\n",
    "dados.loc[dados['tenure'] == 0, ['tenure', 'Charges_Monthly', 'Charges_Total']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "9f794adb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "20.2      11\n",
       "19.75      9\n",
       "19.65      8\n",
       "20.05      8\n",
       "19.9       8\n",
       "          ..\n",
       "2058.5     1\n",
       "829.55     1\n",
       "625.65     1\n",
       "462.8      1\n",
       "3707.6     1\n",
       "Name: Charges_Total, Length: 6541, dtype: int64"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados['Charges_Total'].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "124b98ef",
   "metadata": {},
   "source": [
    "E tambem precisamos mudar o tipo da coluna para float"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "c0aa58cc",
   "metadata": {},
   "outputs": [],
   "source": [
    "dados['Charges_Total'] = dados['Charges_Total'].astype('float64')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "1d332130",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "---------\n",
      "Numero de dados unicos: 7043\n",
      "Dados unicos: ['0002-ORFBO' '0003-MKNFE' '0004-TLHLJ' ... '9992-UJOEL' '9993-LHIEB'\n",
      " '9995-HOTOH']\n",
      "0002-ORFBO    1\n",
      "6616-AALSR    1\n",
      "6625-UTXEW    1\n",
      "6625-IUTTT    1\n",
      "6625-FLENO    1\n",
      "             ..\n",
      "3352-RICWQ    1\n",
      "3352-ALMCK    1\n",
      "3351-NQLDI    1\n",
      "3351-NGXYI    1\n",
      "9995-HOTOH    1\n",
      "Name: customerID, Length: 7043, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 2\n",
      "Dados unicos: ['No' 'Yes']\n",
      "No     5174\n",
      "Yes    1869\n",
      "Name: Churn, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 2\n",
      "Dados unicos: ['Female' 'Male']\n",
      "Male      3555\n",
      "Female    3488\n",
      "Name: gender, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 2\n",
      "Dados unicos: [0 1]\n",
      "0    5901\n",
      "1    1142\n",
      "Name: SeniorCitizen, dtype: int64\n",
      "Tipo da coluna: int64\n",
      "---------\n",
      "Numero de dados unicos: 2\n",
      "Dados unicos: ['Yes' 'No']\n",
      "No     3641\n",
      "Yes    3402\n",
      "Name: Partner, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 2\n",
      "Dados unicos: ['Yes' 'No']\n",
      "No     4933\n",
      "Yes    2110\n",
      "Name: Dependents, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 73\n",
      "Dados unicos: [ 9  4 13  3 71 63  7 65 54 72  5 56 34  1 45 50 23 55 26 69 37 49 66 67\n",
      " 20 43 59 12 27  2 25 29 14 35 64 39 40 11  6 30 70 57 58 16 32 33 10 21\n",
      " 61 15 44 22 24 19 47 62 46 52  8 60 48 28 41 53 68 31 36 17 18 51 38 42\n",
      "  0]\n",
      "1     613\n",
      "72    362\n",
      "2     238\n",
      "3     200\n",
      "4     176\n",
      "     ... \n",
      "28     57\n",
      "39     56\n",
      "44     51\n",
      "36     50\n",
      "0      11\n",
      "Name: tenure, Length: 73, dtype: int64\n",
      "Tipo da coluna: int64\n",
      "---------\n",
      "Numero de dados unicos: 2\n",
      "Dados unicos: ['Yes' 'No']\n",
      "Yes    6361\n",
      "No      682\n",
      "Name: PhoneService, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 3\n",
      "Dados unicos: ['No' 'Yes' 'No phone service']\n",
      "No                  3390\n",
      "Yes                 2971\n",
      "No phone service     682\n",
      "Name: MultipleLines, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 3\n",
      "Dados unicos: ['DSL' 'Fiber optic' 'No']\n",
      "Fiber optic    3096\n",
      "DSL            2421\n",
      "No             1526\n",
      "Name: InternetService, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 3\n",
      "Dados unicos: ['No' 'Yes' 'No internet service']\n",
      "No                     3498\n",
      "Yes                    2019\n",
      "No internet service    1526\n",
      "Name: OnlineSecurity, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 3\n",
      "Dados unicos: ['Yes' 'No' 'No internet service']\n",
      "No                     3088\n",
      "Yes                    2429\n",
      "No internet service    1526\n",
      "Name: OnlineBackup, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 3\n",
      "Dados unicos: ['No' 'Yes' 'No internet service']\n",
      "No                     3095\n",
      "Yes                    2422\n",
      "No internet service    1526\n",
      "Name: DeviceProtection, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 3\n",
      "Dados unicos: ['Yes' 'No' 'No internet service']\n",
      "No                     3473\n",
      "Yes                    2044\n",
      "No internet service    1526\n",
      "Name: TechSupport, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 3\n",
      "Dados unicos: ['Yes' 'No' 'No internet service']\n",
      "No                     2810\n",
      "Yes                    2707\n",
      "No internet service    1526\n",
      "Name: StreamingTV, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 3\n",
      "Dados unicos: ['No' 'Yes' 'No internet service']\n",
      "No                     2785\n",
      "Yes                    2732\n",
      "No internet service    1526\n",
      "Name: StreamingMovies, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 3\n",
      "Dados unicos: ['One year' 'Month-to-month' 'Two year']\n",
      "Month-to-month    3875\n",
      "Two year          1695\n",
      "One year          1473\n",
      "Name: Contract, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 2\n",
      "Dados unicos: ['Yes' 'No']\n",
      "Yes    4171\n",
      "No     2872\n",
      "Name: PaperlessBilling, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 4\n",
      "Dados unicos: ['Mailed check' 'Electronic check' 'Credit card (automatic)'\n",
      " 'Bank transfer (automatic)']\n",
      "Electronic check             2365\n",
      "Mailed check                 1612\n",
      "Bank transfer (automatic)    1544\n",
      "Credit card (automatic)      1522\n",
      "Name: PaymentMethod, dtype: int64\n",
      "Tipo da coluna: object\n",
      "---------\n",
      "Numero de dados unicos: 1585\n",
      "Dados unicos: [65.6  59.9  73.9  ... 91.75 68.8  67.85]\n",
      "20.05     61\n",
      "19.85     45\n",
      "19.95     44\n",
      "19.90     44\n",
      "20.00     43\n",
      "          ..\n",
      "116.55     1\n",
      "106.85     1\n",
      "68.55      1\n",
      "108.80     1\n",
      "67.85      1\n",
      "Name: Charges_Monthly, Length: 1585, dtype: int64\n",
      "Tipo da coluna: float64\n",
      "---------\n",
      "Numero de dados unicos: 6534\n",
      "Dados unicos: [ 593.3   542.4   280.85 ...  742.9  4627.65 3707.6 ]\n",
      "20.20      11\n",
      "19.75       9\n",
      "19.90       8\n",
      "19.65       8\n",
      "20.05       8\n",
      "           ..\n",
      "2387.75     1\n",
      "6302.80     1\n",
      "2058.50     1\n",
      "829.55      1\n",
      "3707.60     1\n",
      "Name: Charges_Total, Length: 6534, dtype: int64\n",
      "Tipo da coluna: float64\n"
     ]
    }
   ],
   "source": [
    "for coluna in dados.columns:\n",
    "    print('---------')\n",
    "    print(f'Numero de dados unicos: {dados[coluna].nunique()}')\n",
    "    print(f'Dados unicos: {dados[coluna].unique()}')\n",
    "    print(dados[coluna].value_counts())\n",
    "    print(f'Tipo da coluna: {dados[coluna].dtype}')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b3b35f0c",
   "metadata": {},
   "source": [
    "## Tradução das colunas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "9f92e5fe",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['customerID', 'Churn', 'gender', 'SeniorCitizen', 'Partner',\n",
       "       'Dependents', 'tenure', 'PhoneService', 'MultipleLines',\n",
       "       'InternetService', 'OnlineSecurity', 'OnlineBackup', 'DeviceProtection',\n",
       "       'TechSupport', 'StreamingTV', 'StreamingMovies', 'Contract',\n",
       "       'PaperlessBilling', 'PaymentMethod', 'Charges_Monthly',\n",
       "       'Charges_Total'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "ddf6fcec",
   "metadata": {},
   "outputs": [],
   "source": [
    "renomear = {\n",
    "    'customerID' : 'Cliente_ID',\n",
    "    'Churn' : 'Evasao',\n",
    "    'gender': 'Genero',\n",
    "    'SeniorCitizen' : 'Idoso',\n",
    "    'Partner' : 'Companheiro',\n",
    "    'Dependents' : 'Dependentes',\n",
    "    'tenure' : 'meses',\n",
    "    'PhoneService' : 'Servico_Telefonico',\n",
    "    'MultipleLines' : 'Multiplas_Linhas',\n",
    "    'InternetService' : 'Provedor_Internet',\n",
    "    'OnlineSecurity' : 'Seguranca_Online',\n",
    "    'OnlineBackup' : 'Backup_Online',\n",
    "    'DeviceProtection' : 'Protecao_de_Dispositivo',\n",
    "    'TechSupport' : 'Suporte_Tecnico',\n",
    "    'StreamingTV' : 'TV_a_Cabo',\n",
    "    'StreamingMovies' : 'Streaming_de_Filmes',\n",
    "    'Contract' : 'Contrato',\n",
    "    'PaperlessBilling' : 'Fatura_Online',\n",
    "    'PaymentMethod' : 'Metodo_de_Pagamento',\n",
    "    'Charges_Monthly' : 'Valor_Mensal',\n",
    "    'Charges_Total' : 'Valor_Total'\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "a57a9de6",
   "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>Cliente_ID</th>\n",
       "      <th>Evasao</th>\n",
       "      <th>Genero</th>\n",
       "      <th>Idoso</th>\n",
       "      <th>Companheiro</th>\n",
       "      <th>Dependentes</th>\n",
       "      <th>meses</th>\n",
       "      <th>Servico_Telefonico</th>\n",
       "      <th>Multiplas_Linhas</th>\n",
       "      <th>Provedor_Internet</th>\n",
       "      <th>...</th>\n",
       "      <th>Backup_Online</th>\n",
       "      <th>Protecao_de_Dispositivo</th>\n",
       "      <th>Suporte_Tecnico</th>\n",
       "      <th>TV_a_Cabo</th>\n",
       "      <th>Streaming_de_Filmes</th>\n",
       "      <th>Contrato</th>\n",
       "      <th>Fatura_Online</th>\n",
       "      <th>Metodo_de_Pagamento</th>\n",
       "      <th>Valor_Mensal</th>\n",
       "      <th>Valor_Total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0002-ORFBO</td>\n",
       "      <td>No</td>\n",
       "      <td>Female</td>\n",
       "      <td>0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>9</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>One year</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Mailed check</td>\n",
       "      <td>65.6</td>\n",
       "      <td>593.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0003-MKNFE</td>\n",
       "      <td>No</td>\n",
       "      <td>Male</td>\n",
       "      <td>0</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>9</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Month-to-month</td>\n",
       "      <td>No</td>\n",
       "      <td>Mailed check</td>\n",
       "      <td>59.9</td>\n",
       "      <td>542.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0004-TLHLJ</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Male</td>\n",
       "      <td>0</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>4</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Fiber optic</td>\n",
       "      <td>...</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Month-to-month</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Electronic check</td>\n",
       "      <td>73.9</td>\n",
       "      <td>280.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0011-IGKFF</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Male</td>\n",
       "      <td>1</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>13</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Fiber optic</td>\n",
       "      <td>...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Month-to-month</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Electronic check</td>\n",
       "      <td>98.0</td>\n",
       "      <td>1237.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0013-EXCHZ</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Female</td>\n",
       "      <td>1</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>3</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Fiber optic</td>\n",
       "      <td>...</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Month-to-month</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Mailed check</td>\n",
       "      <td>83.9</td>\n",
       "      <td>267.40</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Cliente_ID Evasao  Genero  Idoso Companheiro Dependentes  meses  \\\n",
       "0  0002-ORFBO     No  Female      0         Yes         Yes      9   \n",
       "1  0003-MKNFE     No    Male      0          No          No      9   \n",
       "2  0004-TLHLJ    Yes    Male      0          No          No      4   \n",
       "3  0011-IGKFF    Yes    Male      1         Yes          No     13   \n",
       "4  0013-EXCHZ    Yes  Female      1         Yes          No      3   \n",
       "\n",
       "  Servico_Telefonico Multiplas_Linhas Provedor_Internet  ... Backup_Online  \\\n",
       "0                Yes               No               DSL  ...           Yes   \n",
       "1                Yes              Yes               DSL  ...            No   \n",
       "2                Yes               No       Fiber optic  ...            No   \n",
       "3                Yes               No       Fiber optic  ...           Yes   \n",
       "4                Yes               No       Fiber optic  ...            No   \n",
       "\n",
       "  Protecao_de_Dispositivo Suporte_Tecnico TV_a_Cabo Streaming_de_Filmes  \\\n",
       "0                      No             Yes       Yes                  No   \n",
       "1                      No              No        No                 Yes   \n",
       "2                     Yes              No        No                  No   \n",
       "3                     Yes              No       Yes                 Yes   \n",
       "4                      No             Yes       Yes                  No   \n",
       "\n",
       "         Contrato Fatura_Online Metodo_de_Pagamento Valor_Mensal  Valor_Total  \n",
       "0        One year           Yes        Mailed check         65.6       593.30  \n",
       "1  Month-to-month            No        Mailed check         59.9       542.40  \n",
       "2  Month-to-month           Yes    Electronic check         73.9       280.85  \n",
       "3  Month-to-month           Yes    Electronic check         98.0      1237.85  \n",
       "4  Month-to-month           Yes        Mailed check         83.9       267.40  \n",
       "\n",
       "[5 rows x 21 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados.rename(columns = renomear, inplace = True)\n",
    "dados.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "9bd65e13",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['No' 'Yes']\n",
      "['Female' 'Male']\n",
      "[0 1]\n",
      "['Yes' 'No']\n",
      "['Yes' 'No']\n",
      "[ 9  4 13  3 71 63  7 65 54 72  5 56 34  1 45 50 23 55 26 69 37 49 66 67\n",
      " 20 43 59 12 27  2 25 29 14 35 64 39 40 11  6 30 70 57 58 16 32 33 10 21\n",
      " 61 15 44 22 24 19 47 62 46 52  8 60 48 28 41 53 68 31 36 17 18 51 38 42\n",
      "  0]\n",
      "['Yes' 'No']\n",
      "['No' 'Yes' 'No phone service']\n",
      "['DSL' 'Fiber optic' 'No']\n",
      "['No' 'Yes' 'No internet service']\n",
      "['Yes' 'No' 'No internet service']\n",
      "['No' 'Yes' 'No internet service']\n",
      "['Yes' 'No' 'No internet service']\n",
      "['Yes' 'No' 'No internet service']\n",
      "['No' 'Yes' 'No internet service']\n",
      "['One year' 'Month-to-month' 'Two year']\n",
      "['Yes' 'No']\n",
      "['Mailed check' 'Electronic check' 'Credit card (automatic)'\n",
      " 'Bank transfer (automatic)']\n",
      "[65.6  59.9  73.9  ... 91.75 68.8  67.85]\n",
      "[ 593.3   542.4   280.85 ...  742.9  4627.65 3707.6 ]\n"
     ]
    }
   ],
   "source": [
    "for coluna in dados.columns[1:]:\n",
    "    print(dados[coluna].unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "2a917b42",
   "metadata": {},
   "outputs": [],
   "source": [
    "renomear_variaveis = {\n",
    "    'No' : 'Nao',\n",
    "    'Yes' : 'Sim',\n",
    "    'Female' : 'Feminino',\n",
    "    'Male' : 'Masculino',\n",
    "    'No phone service' : 'Sem servico telefonico',\n",
    "    'DSL' : 'DSL',\n",
    "    'Fiber optic' : 'Fibra optica',\n",
    "    'No internet service' : 'Sem servico de internet',\n",
    "    'One year' : 'Um ano',\n",
    "    'Month-to-month' : 'Mensal',\n",
    "    'Two year' : 'Dois anos',\n",
    "    'Mailed check' : 'Cheque via correio',\n",
    "    'Electronic check' :'Cheque electrónico',\n",
    "    'Credit card (automatic)' : 'Cartao de credito (automatico)',\n",
    "    'Bank transfer (automatic)' : 'Transferencia bancaria (automatico)'\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "f6c74d9f",
   "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>Cliente_ID</th>\n",
       "      <th>Evasao</th>\n",
       "      <th>Genero</th>\n",
       "      <th>Idoso</th>\n",
       "      <th>Companheiro</th>\n",
       "      <th>Dependentes</th>\n",
       "      <th>meses</th>\n",
       "      <th>Servico_Telefonico</th>\n",
       "      <th>Multiplas_Linhas</th>\n",
       "      <th>Provedor_Internet</th>\n",
       "      <th>...</th>\n",
       "      <th>Backup_Online</th>\n",
       "      <th>Protecao_de_Dispositivo</th>\n",
       "      <th>Suporte_Tecnico</th>\n",
       "      <th>TV_a_Cabo</th>\n",
       "      <th>Streaming_de_Filmes</th>\n",
       "      <th>Contrato</th>\n",
       "      <th>Fatura_Online</th>\n",
       "      <th>Metodo_de_Pagamento</th>\n",
       "      <th>Valor_Mensal</th>\n",
       "      <th>Valor_Total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0002-ORFBO</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Feminino</td>\n",
       "      <td>0</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>9</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Um ano</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Cheque via correio</td>\n",
       "      <td>65.60</td>\n",
       "      <td>593.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0003-MKNFE</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>0</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>9</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Mensal</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Cheque via correio</td>\n",
       "      <td>59.90</td>\n",
       "      <td>542.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0004-TLHLJ</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>0</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>4</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Fibra optica</td>\n",
       "      <td>...</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Mensal</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Cheque electrónico</td>\n",
       "      <td>73.90</td>\n",
       "      <td>280.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0011-IGKFF</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>1</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>13</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Fibra optica</td>\n",
       "      <td>...</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Mensal</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Cheque electrónico</td>\n",
       "      <td>98.00</td>\n",
       "      <td>1237.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0013-EXCHZ</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Feminino</td>\n",
       "      <td>1</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>3</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Fibra optica</td>\n",
       "      <td>...</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Mensal</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Cheque via correio</td>\n",
       "      <td>83.90</td>\n",
       "      <td>267.40</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>7038</th>\n",
       "      <td>9987-LUTYD</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Feminino</td>\n",
       "      <td>0</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>13</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Um ano</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Cheque via correio</td>\n",
       "      <td>55.15</td>\n",
       "      <td>742.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7039</th>\n",
       "      <td>9992-RRAMN</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>0</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>22</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Fibra optica</td>\n",
       "      <td>...</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Mensal</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Cheque electrónico</td>\n",
       "      <td>85.10</td>\n",
       "      <td>1873.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7040</th>\n",
       "      <td>9992-UJOEL</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>0</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>2</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Mensal</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Cheque via correio</td>\n",
       "      <td>50.30</td>\n",
       "      <td>92.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7041</th>\n",
       "      <td>9993-LHIEB</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>0</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>67</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Dois anos</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Cheque via correio</td>\n",
       "      <td>67.85</td>\n",
       "      <td>4627.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7042</th>\n",
       "      <td>9995-HOTOH</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>0</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>63</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Sem servico telefonico</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Dois anos</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Cheque electrónico</td>\n",
       "      <td>59.00</td>\n",
       "      <td>3707.60</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7043 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Cliente_ID Evasao     Genero  Idoso Companheiro Dependentes  meses  \\\n",
       "0     0002-ORFBO    Nao   Feminino      0         Sim         Sim      9   \n",
       "1     0003-MKNFE    Nao  Masculino      0         Nao         Nao      9   \n",
       "2     0004-TLHLJ    Sim  Masculino      0         Nao         Nao      4   \n",
       "3     0011-IGKFF    Sim  Masculino      1         Sim         Nao     13   \n",
       "4     0013-EXCHZ    Sim   Feminino      1         Sim         Nao      3   \n",
       "...          ...    ...        ...    ...         ...         ...    ...   \n",
       "7038  9987-LUTYD    Nao   Feminino      0         Nao         Nao     13   \n",
       "7039  9992-RRAMN    Sim  Masculino      0         Sim         Nao     22   \n",
       "7040  9992-UJOEL    Nao  Masculino      0         Nao         Nao      2   \n",
       "7041  9993-LHIEB    Nao  Masculino      0         Sim         Sim     67   \n",
       "7042  9995-HOTOH    Nao  Masculino      0         Sim         Sim     63   \n",
       "\n",
       "     Servico_Telefonico        Multiplas_Linhas Provedor_Internet  ...  \\\n",
       "0                   Sim                     Nao               DSL  ...   \n",
       "1                   Sim                     Sim               DSL  ...   \n",
       "2                   Sim                     Nao      Fibra optica  ...   \n",
       "3                   Sim                     Nao      Fibra optica  ...   \n",
       "4                   Sim                     Nao      Fibra optica  ...   \n",
       "...                 ...                     ...               ...  ...   \n",
       "7038                Sim                     Nao               DSL  ...   \n",
       "7039                Sim                     Sim      Fibra optica  ...   \n",
       "7040                Sim                     Nao               DSL  ...   \n",
       "7041                Sim                     Nao               DSL  ...   \n",
       "7042                Nao  Sem servico telefonico               DSL  ...   \n",
       "\n",
       "     Backup_Online Protecao_de_Dispositivo Suporte_Tecnico TV_a_Cabo  \\\n",
       "0              Sim                     Nao             Sim       Sim   \n",
       "1              Nao                     Nao             Nao       Nao   \n",
       "2              Nao                     Sim             Nao       Nao   \n",
       "3              Sim                     Sim             Nao       Sim   \n",
       "4              Nao                     Nao             Sim       Sim   \n",
       "...            ...                     ...             ...       ...   \n",
       "7038           Nao                     Nao             Sim       Nao   \n",
       "7039           Nao                     Nao             Nao       Nao   \n",
       "7040           Sim                     Nao             Nao       Nao   \n",
       "7041           Nao                     Sim             Sim       Nao   \n",
       "7042           Sim                     Sim             Nao       Sim   \n",
       "\n",
       "     Streaming_de_Filmes   Contrato Fatura_Online Metodo_de_Pagamento  \\\n",
       "0                    Nao     Um ano           Sim  Cheque via correio   \n",
       "1                    Sim     Mensal           Nao  Cheque via correio   \n",
       "2                    Nao     Mensal           Sim  Cheque electrónico   \n",
       "3                    Sim     Mensal           Sim  Cheque electrónico   \n",
       "4                    Nao     Mensal           Sim  Cheque via correio   \n",
       "...                  ...        ...           ...                 ...   \n",
       "7038                 Nao     Um ano           Nao  Cheque via correio   \n",
       "7039                 Sim     Mensal           Sim  Cheque electrónico   \n",
       "7040                 Nao     Mensal           Sim  Cheque via correio   \n",
       "7041                 Sim  Dois anos           Nao  Cheque via correio   \n",
       "7042                 Sim  Dois anos           Nao  Cheque electrónico   \n",
       "\n",
       "     Valor_Mensal  Valor_Total  \n",
       "0           65.60       593.30  \n",
       "1           59.90       542.40  \n",
       "2           73.90       280.85  \n",
       "3           98.00      1237.85  \n",
       "4           83.90       267.40  \n",
       "...           ...          ...  \n",
       "7038        55.15       742.90  \n",
       "7039        85.10      1873.70  \n",
       "7040        50.30        92.75  \n",
       "7041        67.85      4627.65  \n",
       "7042        59.00      3707.60  \n",
       "\n",
       "[7043 rows x 21 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados.replace(renomear_variaveis, inplace=True)\n",
    "dados"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "d7edfc02",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['Nao' 'Sim']\n",
      "['Feminino' 'Masculino']\n",
      "[0 1]\n",
      "['Sim' 'Nao']\n",
      "['Sim' 'Nao']\n",
      "[ 9  4 13  3 71 63  7 65 54 72  5 56 34  1 45 50 23 55 26 69 37 49 66 67\n",
      " 20 43 59 12 27  2 25 29 14 35 64 39 40 11  6 30 70 57 58 16 32 33 10 21\n",
      " 61 15 44 22 24 19 47 62 46 52  8 60 48 28 41 53 68 31 36 17 18 51 38 42\n",
      "  0]\n",
      "['Sim' 'Nao']\n",
      "['Nao' 'Sim' 'Sem servico telefonico']\n",
      "['DSL' 'Fibra optica' 'Nao']\n",
      "['Nao' 'Sim' 'Sem servico de internet']\n",
      "['Sim' 'Nao' 'Sem servico de internet']\n",
      "['Nao' 'Sim' 'Sem servico de internet']\n",
      "['Sim' 'Nao' 'Sem servico de internet']\n",
      "['Sim' 'Nao' 'Sem servico de internet']\n",
      "['Nao' 'Sim' 'Sem servico de internet']\n",
      "['Um ano' 'Mensal' 'Dois anos']\n",
      "['Sim' 'Nao']\n",
      "['Cheque via correio' 'Cheque electrónico'\n",
      " 'Cartao de credito (automatico)' 'Transferencia bancaria (automatico)']\n",
      "[65.6  59.9  73.9  ... 91.75 68.8  67.85]\n",
      "[ 593.3   542.4   280.85 ...  742.9  4627.65 3707.6 ]\n"
     ]
    }
   ],
   "source": [
    "for coluna in dados.columns[1:]:\n",
    "    print(dados[coluna].unique())"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e84306e6",
   "metadata": {},
   "source": [
    "## Criar coluna de contas diárias"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "abf1b667",
   "metadata": {},
   "source": [
    "Crie uma nova coluna contendo os gastos diários do(a) cliente e insira na posição 18 do Data Frame."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "16348ace",
   "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>Cliente_ID</th>\n",
       "      <th>Evasao</th>\n",
       "      <th>Genero</th>\n",
       "      <th>Idoso</th>\n",
       "      <th>Companheiro</th>\n",
       "      <th>Dependentes</th>\n",
       "      <th>meses</th>\n",
       "      <th>Servico_Telefonico</th>\n",
       "      <th>Multiplas_Linhas</th>\n",
       "      <th>Provedor_Internet</th>\n",
       "      <th>...</th>\n",
       "      <th>Protecao_de_Dispositivo</th>\n",
       "      <th>Suporte_Tecnico</th>\n",
       "      <th>TV_a_Cabo</th>\n",
       "      <th>Streaming_de_Filmes</th>\n",
       "      <th>Contrato</th>\n",
       "      <th>Fatura_Online</th>\n",
       "      <th>Metodo_de_Pagamento</th>\n",
       "      <th>Valor_Diario</th>\n",
       "      <th>Valor_Mensal</th>\n",
       "      <th>Valor_Total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0002-ORFBO</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Feminino</td>\n",
       "      <td>0</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>9</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Um ano</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Cheque via correio</td>\n",
       "      <td>2.19</td>\n",
       "      <td>65.60</td>\n",
       "      <td>593.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0003-MKNFE</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>0</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>9</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Mensal</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Cheque via correio</td>\n",
       "      <td>2.00</td>\n",
       "      <td>59.90</td>\n",
       "      <td>542.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0004-TLHLJ</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>0</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>4</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Fibra optica</td>\n",
       "      <td>...</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Mensal</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Cheque electrónico</td>\n",
       "      <td>2.46</td>\n",
       "      <td>73.90</td>\n",
       "      <td>280.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0011-IGKFF</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>1</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>13</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Fibra optica</td>\n",
       "      <td>...</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Mensal</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Cheque electrónico</td>\n",
       "      <td>3.27</td>\n",
       "      <td>98.00</td>\n",
       "      <td>1237.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0013-EXCHZ</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Feminino</td>\n",
       "      <td>1</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>3</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Fibra optica</td>\n",
       "      <td>...</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Mensal</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Cheque via correio</td>\n",
       "      <td>2.80</td>\n",
       "      <td>83.90</td>\n",
       "      <td>267.40</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>7038</th>\n",
       "      <td>9987-LUTYD</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Feminino</td>\n",
       "      <td>0</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>13</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Um ano</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Cheque via correio</td>\n",
       "      <td>1.84</td>\n",
       "      <td>55.15</td>\n",
       "      <td>742.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7039</th>\n",
       "      <td>9992-RRAMN</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>0</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>22</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Fibra optica</td>\n",
       "      <td>...</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Mensal</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Cheque electrónico</td>\n",
       "      <td>2.84</td>\n",
       "      <td>85.10</td>\n",
       "      <td>1873.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7040</th>\n",
       "      <td>9992-UJOEL</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>0</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>2</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Mensal</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Cheque via correio</td>\n",
       "      <td>1.68</td>\n",
       "      <td>50.30</td>\n",
       "      <td>92.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7041</th>\n",
       "      <td>9993-LHIEB</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>0</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>67</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Dois anos</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Cheque via correio</td>\n",
       "      <td>2.26</td>\n",
       "      <td>67.85</td>\n",
       "      <td>4627.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7042</th>\n",
       "      <td>9995-HOTOH</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Masculino</td>\n",
       "      <td>0</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>63</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Sem servico telefonico</td>\n",
       "      <td>DSL</td>\n",
       "      <td>...</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Sim</td>\n",
       "      <td>Dois anos</td>\n",
       "      <td>Nao</td>\n",
       "      <td>Cheque electrónico</td>\n",
       "      <td>1.97</td>\n",
       "      <td>59.00</td>\n",
       "      <td>3707.60</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7043 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Cliente_ID Evasao     Genero  Idoso Companheiro Dependentes  meses  \\\n",
       "0     0002-ORFBO    Nao   Feminino      0         Sim         Sim      9   \n",
       "1     0003-MKNFE    Nao  Masculino      0         Nao         Nao      9   \n",
       "2     0004-TLHLJ    Sim  Masculino      0         Nao         Nao      4   \n",
       "3     0011-IGKFF    Sim  Masculino      1         Sim         Nao     13   \n",
       "4     0013-EXCHZ    Sim   Feminino      1         Sim         Nao      3   \n",
       "...          ...    ...        ...    ...         ...         ...    ...   \n",
       "7038  9987-LUTYD    Nao   Feminino      0         Nao         Nao     13   \n",
       "7039  9992-RRAMN    Sim  Masculino      0         Sim         Nao     22   \n",
       "7040  9992-UJOEL    Nao  Masculino      0         Nao         Nao      2   \n",
       "7041  9993-LHIEB    Nao  Masculino      0         Sim         Sim     67   \n",
       "7042  9995-HOTOH    Nao  Masculino      0         Sim         Sim     63   \n",
       "\n",
       "     Servico_Telefonico        Multiplas_Linhas Provedor_Internet  ...  \\\n",
       "0                   Sim                     Nao               DSL  ...   \n",
       "1                   Sim                     Sim               DSL  ...   \n",
       "2                   Sim                     Nao      Fibra optica  ...   \n",
       "3                   Sim                     Nao      Fibra optica  ...   \n",
       "4                   Sim                     Nao      Fibra optica  ...   \n",
       "...                 ...                     ...               ...  ...   \n",
       "7038                Sim                     Nao               DSL  ...   \n",
       "7039                Sim                     Sim      Fibra optica  ...   \n",
       "7040                Sim                     Nao               DSL  ...   \n",
       "7041                Sim                     Nao               DSL  ...   \n",
       "7042                Nao  Sem servico telefonico               DSL  ...   \n",
       "\n",
       "     Protecao_de_Dispositivo Suporte_Tecnico TV_a_Cabo Streaming_de_Filmes  \\\n",
       "0                        Nao             Sim       Sim                 Nao   \n",
       "1                        Nao             Nao       Nao                 Sim   \n",
       "2                        Sim             Nao       Nao                 Nao   \n",
       "3                        Sim             Nao       Sim                 Sim   \n",
       "4                        Nao             Sim       Sim                 Nao   \n",
       "...                      ...             ...       ...                 ...   \n",
       "7038                     Nao             Sim       Nao                 Nao   \n",
       "7039                     Nao             Nao       Nao                 Sim   \n",
       "7040                     Nao             Nao       Nao                 Nao   \n",
       "7041                     Sim             Sim       Nao                 Sim   \n",
       "7042                     Sim             Nao       Sim                 Sim   \n",
       "\n",
       "       Contrato Fatura_Online Metodo_de_Pagamento Valor_Diario Valor_Mensal  \\\n",
       "0        Um ano           Sim  Cheque via correio         2.19        65.60   \n",
       "1        Mensal           Nao  Cheque via correio         2.00        59.90   \n",
       "2        Mensal           Sim  Cheque electrónico         2.46        73.90   \n",
       "3        Mensal           Sim  Cheque electrónico         3.27        98.00   \n",
       "4        Mensal           Sim  Cheque via correio         2.80        83.90   \n",
       "...         ...           ...                 ...          ...          ...   \n",
       "7038     Um ano           Nao  Cheque via correio         1.84        55.15   \n",
       "7039     Mensal           Sim  Cheque electrónico         2.84        85.10   \n",
       "7040     Mensal           Sim  Cheque via correio         1.68        50.30   \n",
       "7041  Dois anos           Nao  Cheque via correio         2.26        67.85   \n",
       "7042  Dois anos           Nao  Cheque electrónico         1.97        59.00   \n",
       "\n",
       "      Valor_Total  \n",
       "0          593.30  \n",
       "1          542.40  \n",
       "2          280.85  \n",
       "3         1237.85  \n",
       "4          267.40  \n",
       "...           ...  \n",
       "7038       742.90  \n",
       "7039      1873.70  \n",
       "7040        92.75  \n",
       "7041      4627.65  \n",
       "7042      3707.60  \n",
       "\n",
       "[7043 rows x 22 columns]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dados.insert(19, 'Valor_Diario', (dados['Valor_Mensal'] / 30).round(2))\n",
    "dados"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a54ce12b",
   "metadata": {},
   "source": [
    "## Armazenar os dados tratados em um novo arquivo"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "24dc2142",
   "metadata": {},
   "outputs": [],
   "source": [
    "dados.to_json(\"dados/Telco-Customer-Churn-limpeza.json\")  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "1136e415",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}