31-rotulagem-genero-nome.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "arquivo = 'dados/afastamentos'\n",
    "#arquivo = 'dados/cadastro'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(arquivo + '-nomes.csv', index_col=0,\n",
    "                 dtype={'QTDE': 'uint32', 'PERC': np.float32})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>QTDE</th>\n",
       "      <th>PERC</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PNOME</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>MARIA</th>\n",
       "      <td>2937</td>\n",
       "      <td>4.5953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JOSE</th>\n",
       "      <td>2766</td>\n",
       "      <td>4.3278</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ANTONIO</th>\n",
       "      <td>1257</td>\n",
       "      <td>1.9667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FRANCISCO</th>\n",
       "      <td>1014</td>\n",
       "      <td>1.5865</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JOAO</th>\n",
       "      <td>993</td>\n",
       "      <td>1.5537</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CARLOS</th>\n",
       "      <td>979</td>\n",
       "      <td>1.5318</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ANA</th>\n",
       "      <td>938</td>\n",
       "      <td>1.4676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PAULO</th>\n",
       "      <td>907</td>\n",
       "      <td>1.4191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LUIZ</th>\n",
       "      <td>829</td>\n",
       "      <td>1.2971</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MARCOS</th>\n",
       "      <td>515</td>\n",
       "      <td>0.8058</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JORGE</th>\n",
       "      <td>507</td>\n",
       "      <td>0.7933</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MARCELO</th>\n",
       "      <td>424</td>\n",
       "      <td>0.6634</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PEDRO</th>\n",
       "      <td>421</td>\n",
       "      <td>0.6587</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RAIMUNDO</th>\n",
       "      <td>395</td>\n",
       "      <td>0.6180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SERGIO</th>\n",
       "      <td>394</td>\n",
       "      <td>0.6165</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MANOEL</th>\n",
       "      <td>344</td>\n",
       "      <td>0.5382</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FERNANDO</th>\n",
       "      <td>342</td>\n",
       "      <td>0.5351</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ANDRE</th>\n",
       "      <td>328</td>\n",
       "      <td>0.5132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RICARDO</th>\n",
       "      <td>318</td>\n",
       "      <td>0.4976</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MARCIA</th>\n",
       "      <td>314</td>\n",
       "      <td>0.4913</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LUIS</th>\n",
       "      <td>297</td>\n",
       "      <td>0.4647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ALEXANDRE</th>\n",
       "      <td>287</td>\n",
       "      <td>0.4490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ROBERTO</th>\n",
       "      <td>284</td>\n",
       "      <td>0.4444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EDUARDO</th>\n",
       "      <td>275</td>\n",
       "      <td>0.4303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CLAUDIO</th>\n",
       "      <td>271</td>\n",
       "      <td>0.4240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PATRICIA</th>\n",
       "      <td>270</td>\n",
       "      <td>0.4224</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RODRIGO</th>\n",
       "      <td>253</td>\n",
       "      <td>0.3959</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CLAUDIA</th>\n",
       "      <td>245</td>\n",
       "      <td>0.3833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JULIANA</th>\n",
       "      <td>240</td>\n",
       "      <td>0.3755</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LUCIANA</th>\n",
       "      <td>235</td>\n",
       "      <td>0.3677</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           QTDE    PERC\n",
       "PNOME                  \n",
       "MARIA      2937  4.5953\n",
       "JOSE       2766  4.3278\n",
       "ANTONIO    1257  1.9667\n",
       "FRANCISCO  1014  1.5865\n",
       "JOAO        993  1.5537\n",
       "CARLOS      979  1.5318\n",
       "ANA         938  1.4676\n",
       "PAULO       907  1.4191\n",
       "LUIZ        829  1.2971\n",
       "MARCOS      515  0.8058\n",
       "JORGE       507  0.7933\n",
       "MARCELO     424  0.6634\n",
       "PEDRO       421  0.6587\n",
       "RAIMUNDO    395  0.6180\n",
       "SERGIO      394  0.6165\n",
       "MANOEL      344  0.5382\n",
       "FERNANDO    342  0.5351\n",
       "ANDRE       328  0.5132\n",
       "RICARDO     318  0.4976\n",
       "MARCIA      314  0.4913\n",
       "LUIS        297  0.4647\n",
       "ALEXANDRE   287  0.4490\n",
       "ROBERTO     284  0.4444\n",
       "EDUARDO     275  0.4303\n",
       "CLAUDIO     271  0.4240\n",
       "PATRICIA    270  0.4224\n",
       "RODRIGO     253  0.3959\n",
       "CLAUDIA     245  0.3833\n",
       "JULIANA     240  0.3755\n",
       "LUCIANA     235  0.3677"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(30)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>QTDE</th>\n",
       "      <th>PERC</th>\n",
       "      <th>SEXO</th>\n",
       "      <th>REV</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PNOME</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>MARIA</th>\n",
       "      <td>2937</td>\n",
       "      <td>4.5953</td>\n",
       "      <td>None</td>\n",
       "      <td>AIRAM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JOSE</th>\n",
       "      <td>2766</td>\n",
       "      <td>4.3278</td>\n",
       "      <td>None</td>\n",
       "      <td>ESOJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ANTONIO</th>\n",
       "      <td>1257</td>\n",
       "      <td>1.9667</td>\n",
       "      <td>None</td>\n",
       "      <td>OINOTNA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FRANCISCO</th>\n",
       "      <td>1014</td>\n",
       "      <td>1.5865</td>\n",
       "      <td>None</td>\n",
       "      <td>OCSICNARF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JOAO</th>\n",
       "      <td>993</td>\n",
       "      <td>1.5537</td>\n",
       "      <td>None</td>\n",
       "      <td>OAOJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CARLOS</th>\n",
       "      <td>979</td>\n",
       "      <td>1.5318</td>\n",
       "      <td>None</td>\n",
       "      <td>SOLRAC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ANA</th>\n",
       "      <td>938</td>\n",
       "      <td>1.4676</td>\n",
       "      <td>None</td>\n",
       "      <td>ANA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PAULO</th>\n",
       "      <td>907</td>\n",
       "      <td>1.4191</td>\n",
       "      <td>None</td>\n",
       "      <td>OLUAP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LUIZ</th>\n",
       "      <td>829</td>\n",
       "      <td>1.2971</td>\n",
       "      <td>None</td>\n",
       "      <td>ZIUL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MARCOS</th>\n",
       "      <td>515</td>\n",
       "      <td>0.8058</td>\n",
       "      <td>None</td>\n",
       "      <td>SOCRAM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JORGE</th>\n",
       "      <td>507</td>\n",
       "      <td>0.7933</td>\n",
       "      <td>None</td>\n",
       "      <td>EGROJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MARCELO</th>\n",
       "      <td>424</td>\n",
       "      <td>0.6634</td>\n",
       "      <td>None</td>\n",
       "      <td>OLECRAM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PEDRO</th>\n",
       "      <td>421</td>\n",
       "      <td>0.6587</td>\n",
       "      <td>None</td>\n",
       "      <td>ORDEP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RAIMUNDO</th>\n",
       "      <td>395</td>\n",
       "      <td>0.6180</td>\n",
       "      <td>None</td>\n",
       "      <td>ODNUMIAR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SERGIO</th>\n",
       "      <td>394</td>\n",
       "      <td>0.6165</td>\n",
       "      <td>None</td>\n",
       "      <td>OIGRES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MANOEL</th>\n",
       "      <td>344</td>\n",
       "      <td>0.5382</td>\n",
       "      <td>None</td>\n",
       "      <td>LEONAM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FERNANDO</th>\n",
       "      <td>342</td>\n",
       "      <td>0.5351</td>\n",
       "      <td>None</td>\n",
       "      <td>ODNANREF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ANDRE</th>\n",
       "      <td>328</td>\n",
       "      <td>0.5132</td>\n",
       "      <td>None</td>\n",
       "      <td>ERDNA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RICARDO</th>\n",
       "      <td>318</td>\n",
       "      <td>0.4976</td>\n",
       "      <td>None</td>\n",
       "      <td>ODRACIR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MARCIA</th>\n",
       "      <td>314</td>\n",
       "      <td>0.4913</td>\n",
       "      <td>None</td>\n",
       "      <td>AICRAM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LUIS</th>\n",
       "      <td>297</td>\n",
       "      <td>0.4647</td>\n",
       "      <td>None</td>\n",
       "      <td>SIUL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ALEXANDRE</th>\n",
       "      <td>287</td>\n",
       "      <td>0.4490</td>\n",
       "      <td>None</td>\n",
       "      <td>ERDNAXELA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ROBERTO</th>\n",
       "      <td>284</td>\n",
       "      <td>0.4444</td>\n",
       "      <td>None</td>\n",
       "      <td>OTREBOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EDUARDO</th>\n",
       "      <td>275</td>\n",
       "      <td>0.4303</td>\n",
       "      <td>None</td>\n",
       "      <td>ODRAUDE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CLAUDIO</th>\n",
       "      <td>271</td>\n",
       "      <td>0.4240</td>\n",
       "      <td>None</td>\n",
       "      <td>OIDUALC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PATRICIA</th>\n",
       "      <td>270</td>\n",
       "      <td>0.4224</td>\n",
       "      <td>None</td>\n",
       "      <td>AICIRTAP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RODRIGO</th>\n",
       "      <td>253</td>\n",
       "      <td>0.3959</td>\n",
       "      <td>None</td>\n",
       "      <td>OGIRDOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CLAUDIA</th>\n",
       "      <td>245</td>\n",
       "      <td>0.3833</td>\n",
       "      <td>None</td>\n",
       "      <td>AIDUALC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JULIANA</th>\n",
       "      <td>240</td>\n",
       "      <td>0.3755</td>\n",
       "      <td>None</td>\n",
       "      <td>ANAILUJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LUCIANA</th>\n",
       "      <td>235</td>\n",
       "      <td>0.3677</td>\n",
       "      <td>None</td>\n",
       "      <td>ANAICUL</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           QTDE    PERC  SEXO        REV\n",
       "PNOME                                   \n",
       "MARIA      2937  4.5953  None      AIRAM\n",
       "JOSE       2766  4.3278  None       ESOJ\n",
       "ANTONIO    1257  1.9667  None    OINOTNA\n",
       "FRANCISCO  1014  1.5865  None  OCSICNARF\n",
       "JOAO        993  1.5537  None       OAOJ\n",
       "CARLOS      979  1.5318  None     SOLRAC\n",
       "ANA         938  1.4676  None        ANA\n",
       "PAULO       907  1.4191  None      OLUAP\n",
       "LUIZ        829  1.2971  None       ZIUL\n",
       "MARCOS      515  0.8058  None     SOCRAM\n",
       "JORGE       507  0.7933  None      EGROJ\n",
       "MARCELO     424  0.6634  None    OLECRAM\n",
       "PEDRO       421  0.6587  None      ORDEP\n",
       "RAIMUNDO    395  0.6180  None   ODNUMIAR\n",
       "SERGIO      394  0.6165  None     OIGRES\n",
       "MANOEL      344  0.5382  None     LEONAM\n",
       "FERNANDO    342  0.5351  None   ODNANREF\n",
       "ANDRE       328  0.5132  None      ERDNA\n",
       "RICARDO     318  0.4976  None    ODRACIR\n",
       "MARCIA      314  0.4913  None     AICRAM\n",
       "LUIS        297  0.4647  None       SIUL\n",
       "ALEXANDRE   287  0.4490  None  ERDNAXELA\n",
       "ROBERTO     284  0.4444  None    OTREBOR\n",
       "EDUARDO     275  0.4303  None    ODRAUDE\n",
       "CLAUDIO     271  0.4240  None    OIDUALC\n",
       "PATRICIA    270  0.4224  None   AICIRTAP\n",
       "RODRIGO     253  0.3959  None    OGIRDOR\n",
       "CLAUDIA     245  0.3833  None    AIDUALC\n",
       "JULIANA     240  0.3755  None    ANAILUJ\n",
       "LUCIANA     235  0.3677  None    ANAICUL"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['SEXO'] = None\n",
    "#df['LETRAS'] = 0\n",
    "df['REV'] = df.index\n",
    "df['REV'] = df['REV'].apply(lambda x: x[::-1])\n",
    "#df['LETRAS'] = df['REV'].apply(lambda x: len(x))\n",
    "df.head(30)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "QTDE     uint32\n",
       "PERC    float32\n",
       "SEXO     object\n",
       "REV      object\n",
       "dtype: object"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dtypes"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 1) Masculino se terminar com O, Feminino se terminar com A"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.loc[df['REV'].str.startswith('O'), 'SEXO'] = 'M'\n",
    "df.loc[df['REV'].str.startswith('A'), 'SEXO'] = 'F'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 2) Masculino se terminar com R, X ou L"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.loc[df['REV'].str.startswith('R'), 'SEXO'] = 'M'\n",
    "df.loc[df['REV'].str.startswith('X'), 'SEXO'] = 'M'\n",
    "df.loc[df['REV'].str.startswith('L'), 'SEXO'] = 'M'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 3) Masculino se terminar com ..."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "sufixos = [\n",
    "\"DRE\",\n",
    "\"UIS\",\n",
    "\"QUE\",\n",
    "\"ERT\",\n",
    "\"ERG\"\n",
    "]\n",
    "\n",
    "for suf in sufixos:\n",
    "    df.loc[df['REV'].str.startswith(suf[::-1]), 'SEXO'] = 'M'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 4) Masculino se terminar com ..."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "sufixos = [\n",
    "\"OS\",\n",
    "\"ON\",\n",
    "\"AS\",\n",
    "\"AZ\",\n",
    "\"US\",\n",
    "\"ES\",\n",
    "\"PE\",\n",
    "\"PH\",\n",
    "\"IM\",\n",
    "\"NS\",\n",
    "\"UE\",\n",
    "\"EI\",\n",
    "\"EY\",\n",
    "\"EU\",\n",
    "\"AU\",\n",
    "\"AN\",\n",
    "\"AC\",\n",
    "\"IC\",\n",
    "\"ICK\",\n",
    "\"IK\"\n",
    "]\n",
    "\n",
    "for suf in sufixos:\n",
    "    df.loc[df['REV'].str.startswith(suf[::-1]), 'SEXO'] = 'M'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 5) Feminino se terminar com ..."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "sufixos = [\n",
    "\"ELE\",\n",
    "\"ELLE\",\n",
    "\"LLE\",\n",
    "\"ETE\",\n",
    "\"ETTE\",\n",
    "\"ETI\",\n",
    "\"ETTI\",\n",
    "\"ETH\",\n",
    "\"ETHE\",\n",
    "\"ISE\",\n",
    "\"IZE\",\n",
    "\"ITE\"\n",
    "]\n",
    "\n",
    "for suf in sufixos:\n",
    "    df.loc[df['REV'].str.startswith(suf[::-1]), 'SEXO'] = 'F'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 6) Feminino se terminar com ..."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "sufixos = [\n",
    "\"NE\",\n",
    "\"LI\",\n",
    "\"LY\",\n",
    "\"LYN\",\n",
    "\"CE\",\n",
    "\"EN\",\n",
    "\"DE\",\n",
    "\"SE\",\n",
    "\"SY\",\n",
    "\"ANI\",\n",
    "\"AIS\",\n",
    "\"AH\",\n",
    "\"ENI\",\n",
    "\"IE\",\n",
    "\"IRE\"\n",
    "]\n",
    "\n",
    "for suf in sufixos:\n",
    "    df.loc[df['REV'].str.startswith(suf[::-1]), 'SEXO'] = 'F'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 8) Nomes Masculinos ainda não classificados ou reclassificados"
   ]
  },
  {
   "cell_type": "raw",
   "metadata": {},
   "source": [
    "nomes = [\n",
    "\"JOSE\",\n",
    "\"JORGE\",\n",
    "\"LUIZ\",\n",
    "]"
   ]
  },
  {
   "cell_type": "raw",
   "metadata": {},
   "source": [
    "with open('rotulagem/nomes-masculinos.txt', 'w') as f:\n",
    "    for nome in nomes:\n",
    "        f.write(\"%s\\n\" % nome)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "nomes = []\n",
    "with open('rotulagem/nomes-masculinos.txt', 'r') as f:\n",
    "    nomes = [nome.rstrip() for nome in f.readlines()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "for nome in nomes:\n",
    "    df.loc[df['REV'] == nome[::-1], 'SEXO'] = 'M'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 9) Nomes Femininos ainda não classificados ou reclassificados"
   ]
  },
  {
   "cell_type": "raw",
   "metadata": {},
   "source": [
    "nomes = [\n",
    "\"RAQUEL\",\n",
    "\"ISABEL\",\n",
    "\"LEONOR\"\n",
    "]"
   ]
  },
  {
   "cell_type": "raw",
   "metadata": {},
   "source": [
    "with open('rotulagem/nomes-femininos.txt', 'w') as f:\n",
    "    for nome in nomes:\n",
    "        f.write(\"%s\\n\" % nome)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "nomes = []\n",
    "with open('rotulagem/nomes-femininos.txt', 'r') as f:\n",
    "    nomes = [nome.rstrip() for nome in f.readlines()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "for nome in nomes:\n",
    "    df.loc[df['REV'] == nome[::-1], 'SEXO'] = 'F'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Casos indefinidos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>QTDE</th>\n",
       "      <th>PERC</th>\n",
       "      <th>SEXO</th>\n",
       "      <th>REV</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PNOME</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>VALDECI</th>\n",
       "      <td>24</td>\n",
       "      <td>0.0376</td>\n",
       "      <td>None</td>\n",
       "      <td>ICEDLAV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JURACI</th>\n",
       "      <td>13</td>\n",
       "      <td>0.0203</td>\n",
       "      <td>None</td>\n",
       "      <td>ICARUJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DARCY</th>\n",
       "      <td>12</td>\n",
       "      <td>0.0188</td>\n",
       "      <td>None</td>\n",
       "      <td>YCRAD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IRACI</th>\n",
       "      <td>9</td>\n",
       "      <td>0.0141</td>\n",
       "      <td>None</td>\n",
       "      <td>ICARI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JACY</th>\n",
       "      <td>9</td>\n",
       "      <td>0.0141</td>\n",
       "      <td>None</td>\n",
       "      <td>YCAJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DARCI</th>\n",
       "      <td>9</td>\n",
       "      <td>0.0141</td>\n",
       "      <td>None</td>\n",
       "      <td>ICRAD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JACI</th>\n",
       "      <td>9</td>\n",
       "      <td>0.0141</td>\n",
       "      <td>None</td>\n",
       "      <td>ICAJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UBIRACI</th>\n",
       "      <td>6</td>\n",
       "      <td>0.0094</td>\n",
       "      <td>None</td>\n",
       "      <td>ICARIBU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NELCI</th>\n",
       "      <td>6</td>\n",
       "      <td>0.0094</td>\n",
       "      <td>None</td>\n",
       "      <td>ICLEN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GUARACI</th>\n",
       "      <td>5</td>\n",
       "      <td>0.0078</td>\n",
       "      <td>None</td>\n",
       "      <td>ICARAUG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JURACY</th>\n",
       "      <td>5</td>\n",
       "      <td>0.0078</td>\n",
       "      <td>None</td>\n",
       "      <td>YCARUJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GLADYS</th>\n",
       "      <td>5</td>\n",
       "      <td>0.0078</td>\n",
       "      <td>None</td>\n",
       "      <td>SYDALG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VALDI</th>\n",
       "      <td>5</td>\n",
       "      <td>0.0078</td>\n",
       "      <td>None</td>\n",
       "      <td>IDLAV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VALDECY</th>\n",
       "      <td>5</td>\n",
       "      <td>0.0078</td>\n",
       "      <td>None</td>\n",
       "      <td>YCEDLAV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CLECI</th>\n",
       "      <td>4</td>\n",
       "      <td>0.0063</td>\n",
       "      <td>None</td>\n",
       "      <td>ICELC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LEONI</th>\n",
       "      <td>4</td>\n",
       "      <td>0.0063</td>\n",
       "      <td>None</td>\n",
       "      <td>INOEL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JAMILE</th>\n",
       "      <td>4</td>\n",
       "      <td>0.0063</td>\n",
       "      <td>None</td>\n",
       "      <td>ELIMAJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IRANDI</th>\n",
       "      <td>4</td>\n",
       "      <td>0.0063</td>\n",
       "      <td>None</td>\n",
       "      <td>IDNARI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FRANCY</th>\n",
       "      <td>3</td>\n",
       "      <td>0.0047</td>\n",
       "      <td>None</td>\n",
       "      <td>YCNARF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DORACI</th>\n",
       "      <td>3</td>\n",
       "      <td>0.0047</td>\n",
       "      <td>None</td>\n",
       "      <td>ICAROD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ROSEMERE</th>\n",
       "      <td>3</td>\n",
       "      <td>0.0047</td>\n",
       "      <td>None</td>\n",
       "      <td>EREMESOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GECY</th>\n",
       "      <td>3</td>\n",
       "      <td>0.0047</td>\n",
       "      <td>None</td>\n",
       "      <td>YCEG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GENECI</th>\n",
       "      <td>3</td>\n",
       "      <td>0.0047</td>\n",
       "      <td>None</td>\n",
       "      <td>ICENEG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AGLAE</th>\n",
       "      <td>3</td>\n",
       "      <td>0.0047</td>\n",
       "      <td>None</td>\n",
       "      <td>EALGA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IRACY</th>\n",
       "      <td>3</td>\n",
       "      <td>0.0047</td>\n",
       "      <td>None</td>\n",
       "      <td>YCARI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ALDECI</th>\n",
       "      <td>3</td>\n",
       "      <td>0.0047</td>\n",
       "      <td>None</td>\n",
       "      <td>ICEDLA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IVANY</th>\n",
       "      <td>3</td>\n",
       "      <td>0.0047</td>\n",
       "      <td>None</td>\n",
       "      <td>YNAVI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JURANDY</th>\n",
       "      <td>3</td>\n",
       "      <td>0.0047</td>\n",
       "      <td>None</td>\n",
       "      <td>YDNARUJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ALDERI</th>\n",
       "      <td>3</td>\n",
       "      <td>0.0047</td>\n",
       "      <td>None</td>\n",
       "      <td>IREDLA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AVANY</th>\n",
       "      <td>3</td>\n",
       "      <td>0.0047</td>\n",
       "      <td>None</td>\n",
       "      <td>YNAVA</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          QTDE    PERC  SEXO       REV\n",
       "PNOME                                 \n",
       "VALDECI     24  0.0376  None   ICEDLAV\n",
       "JURACI      13  0.0203  None    ICARUJ\n",
       "DARCY       12  0.0188  None     YCRAD\n",
       "IRACI        9  0.0141  None     ICARI\n",
       "JACY         9  0.0141  None      YCAJ\n",
       "DARCI        9  0.0141  None     ICRAD\n",
       "JACI         9  0.0141  None      ICAJ\n",
       "UBIRACI      6  0.0094  None   ICARIBU\n",
       "NELCI        6  0.0094  None     ICLEN\n",
       "GUARACI      5  0.0078  None   ICARAUG\n",
       "JURACY       5  0.0078  None    YCARUJ\n",
       "GLADYS       5  0.0078  None    SYDALG\n",
       "VALDI        5  0.0078  None     IDLAV\n",
       "VALDECY      5  0.0078  None   YCEDLAV\n",
       "CLECI        4  0.0063  None     ICELC\n",
       "LEONI        4  0.0063  None     INOEL\n",
       "JAMILE       4  0.0063  None    ELIMAJ\n",
       "IRANDI       4  0.0063  None    IDNARI\n",
       "FRANCY       3  0.0047  None    YCNARF\n",
       "DORACI       3  0.0047  None    ICAROD\n",
       "ROSEMERE     3  0.0047  None  EREMESOR\n",
       "GECY         3  0.0047  None      YCEG\n",
       "GENECI       3  0.0047  None    ICENEG\n",
       "AGLAE        3  0.0047  None     EALGA\n",
       "IRACY        3  0.0047  None     YCARI\n",
       "ALDECI       3  0.0047  None    ICEDLA\n",
       "IVANY        3  0.0047  None     YNAVI\n",
       "JURANDY      3  0.0047  None   YDNARUJ\n",
       "ALDERI       3  0.0047  None    IREDLA\n",
       "AVANY        3  0.0047  None     YNAVA"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['SEXO'].isnull()].head(30)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Testes com outros casos"
   ]
  },
  {
   "cell_type": "raw",
   "metadata": {
    "scrolled": false
   },
   "source": [
    "df = df[df['REV'].str.startswith('IA')]\n",
    "\n",
    "df[df['SEXO'].isnull()].head(100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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>SEXO</th>\n",
       "      <th>REV</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>8711</td>\n",
       "      <td>9726</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unique</th>\n",
       "      <td>2</td>\n",
       "      <td>9726</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>top</th>\n",
       "      <td>F</td>\n",
       "      <td>AIVALF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>freq</th>\n",
       "      <td>4384</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        SEXO     REV\n",
       "count   8711    9726\n",
       "unique     2    9726\n",
       "top        F  AIVALF\n",
       "freq    4384       1"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.describe(include=['O'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>QTDE</th>\n",
       "      <th>PERC</th>\n",
       "      <th>SEXO</th>\n",
       "      <th>REV</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PNOME</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>MARIA</th>\n",
       "      <td>2937</td>\n",
       "      <td>4.5953</td>\n",
       "      <td>F</td>\n",
       "      <td>AIRAM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JOSE</th>\n",
       "      <td>2766</td>\n",
       "      <td>4.3278</td>\n",
       "      <td>M</td>\n",
       "      <td>ESOJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ANTONIO</th>\n",
       "      <td>1257</td>\n",
       "      <td>1.9667</td>\n",
       "      <td>M</td>\n",
       "      <td>OINOTNA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FRANCISCO</th>\n",
       "      <td>1014</td>\n",
       "      <td>1.5865</td>\n",
       "      <td>M</td>\n",
       "      <td>OCSICNARF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JOAO</th>\n",
       "      <td>993</td>\n",
       "      <td>1.5537</td>\n",
       "      <td>M</td>\n",
       "      <td>OAOJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SEVERINO</th>\n",
       "      <td>53</td>\n",
       "      <td>0.0829</td>\n",
       "      <td>M</td>\n",
       "      <td>ONIREVES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JAQUELINE</th>\n",
       "      <td>53</td>\n",
       "      <td>0.0829</td>\n",
       "      <td>F</td>\n",
       "      <td>ENILEUQAJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HELENA</th>\n",
       "      <td>53</td>\n",
       "      <td>0.0829</td>\n",
       "      <td>F</td>\n",
       "      <td>ANELEH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DOUGLAS</th>\n",
       "      <td>52</td>\n",
       "      <td>0.0814</td>\n",
       "      <td>M</td>\n",
       "      <td>SALGUOD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HELOISA</th>\n",
       "      <td>52</td>\n",
       "      <td>0.0814</td>\n",
       "      <td>F</td>\n",
       "      <td>ASIOLEH</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>200 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           QTDE    PERC SEXO        REV\n",
       "PNOME                                  \n",
       "MARIA      2937  4.5953    F      AIRAM\n",
       "JOSE       2766  4.3278    M       ESOJ\n",
       "ANTONIO    1257  1.9667    M    OINOTNA\n",
       "FRANCISCO  1014  1.5865    M  OCSICNARF\n",
       "JOAO        993  1.5537    M       OAOJ\n",
       "...         ...     ...  ...        ...\n",
       "SEVERINO     53  0.0829    M   ONIREVES\n",
       "JAQUELINE    53  0.0829    F  ENILEUQAJ\n",
       "HELENA       53  0.0829    F     ANELEH\n",
       "DOUGLAS      52  0.0814    M    SALGUOD\n",
       "HELOISA      52  0.0814    F    ASIOLEH\n",
       "\n",
       "[200 rows x 4 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(200)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Testes com outros casos"
   ]
  },
  {
   "cell_type": "raw",
   "metadata": {},
   "source": [
    "df[df['REV'].str.startswith('EZI')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "#df.loc['PHILIP']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Últimas transformações"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.loc[df['SEXO'].isnull(), 'SEXO'] = 'X'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Análise das quantidades"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "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>QTDE</th>\n",
       "      <th>PERC</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SEXO</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>F</th>\n",
       "      <td>4384</td>\n",
       "      <td>45.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M</th>\n",
       "      <td>4327</td>\n",
       "      <td>44.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>X</th>\n",
       "      <td>1015</td>\n",
       "      <td>10.43</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      QTDE   PERC\n",
       "SEXO             \n",
       "F     4384  45.07\n",
       "M     4327  44.48\n",
       "X     1015  10.43"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2 = df[['QTDE', 'SEXO']].groupby(['SEXO']).count()\n",
    "total = df2['QTDE'].sum()\n",
    "df2['PERC'] = df2['QTDE'].apply(lambda x: int(x / total * 10000) / 100)\n",
    "df2"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Geração do arquivo final"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "df[['SEXO', 'QTDE']].to_csv(arquivo + '-nomes-sexo.csv', header=True)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}