limpeza.ipynb

{
 "cells": [
  {
   "cell_type": "raw",
   "id": "debfcc63-7283-487e-ae58-868680f7ea9b",
   "metadata": {},
   "source": [
    "Notebook para limpeza dos dados"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "5651d956-ba8c-45be-a95b-37d5541dfe68",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "0d0538d4-0103-4a99-877c-617001b34492",
   "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>codigo_ocorrencia</th>\n",
       "      <th>codigo_ocorrencia2</th>\n",
       "      <th>ocorrencia_classificacao</th>\n",
       "      <th>ocorrencia_cidade</th>\n",
       "      <th>ocorrencia_uf</th>\n",
       "      <th>ocorrencia_aerodromo</th>\n",
       "      <th>ocorrencia_dia</th>\n",
       "      <th>ocorrencia_hora</th>\n",
       "      <th>total_recomendacoes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>40211</td>\n",
       "      <td>40211</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RIO DE JANEIRO</td>\n",
       "      <td>RJ</td>\n",
       "      <td>****</td>\n",
       "      <td>2010-01-03</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>40349</td>\n",
       "      <td>40349</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>BELÉM</td>\n",
       "      <td>PA</td>\n",
       "      <td>SBBE</td>\n",
       "      <td>2010-01-03</td>\n",
       "      <td>11:05:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>40351</td>\n",
       "      <td>40351</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RIO DE JANEIRO</td>\n",
       "      <td>RJ</td>\n",
       "      <td>SBRJ</td>\n",
       "      <td>2010-01-03</td>\n",
       "      <td>03:00:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>39527</td>\n",
       "      <td>39527</td>\n",
       "      <td>ACIDENTE</td>\n",
       "      <td>LUCAS DO RIO VERDE</td>\n",
       "      <td>MT</td>\n",
       "      <td>****</td>\n",
       "      <td>2010-01-04</td>\n",
       "      <td>17:30:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>40324</td>\n",
       "      <td>40324</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>PELOTAS</td>\n",
       "      <td>RS</td>\n",
       "      <td>SBPK</td>\n",
       "      <td>2010-01-05</td>\n",
       "      <td>19:25:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5747</th>\n",
       "      <td>79804</td>\n",
       "      <td>79804</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>CAMPINAS</td>\n",
       "      <td>SP</td>\n",
       "      <td>SBKP</td>\n",
       "      <td>2020-12-29</td>\n",
       "      <td>19:00:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5748</th>\n",
       "      <td>79757</td>\n",
       "      <td>79757</td>\n",
       "      <td>INCIDENTE GRAVE</td>\n",
       "      <td>LAGOA DA CONFUSÃO</td>\n",
       "      <td>TO</td>\n",
       "      <td>****</td>\n",
       "      <td>2020-12-30</td>\n",
       "      <td>18:30:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5749</th>\n",
       "      <td>79802</td>\n",
       "      <td>79802</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RIO DE JANEIRO</td>\n",
       "      <td>RJ</td>\n",
       "      <td>SBGL</td>\n",
       "      <td>2020-12-30</td>\n",
       "      <td>00:54:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5750</th>\n",
       "      <td>79756</td>\n",
       "      <td>79756</td>\n",
       "      <td>INCIDENTE GRAVE</td>\n",
       "      <td>VICENTINA</td>\n",
       "      <td>MS</td>\n",
       "      <td>****</td>\n",
       "      <td>2020-12-31</td>\n",
       "      <td>09:00:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5751</th>\n",
       "      <td>79844</td>\n",
       "      <td>79844</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RIO DE JANEIRO</td>\n",
       "      <td>RJ</td>\n",
       "      <td>SBJR</td>\n",
       "      <td>2020-12-31</td>\n",
       "      <td>13:24:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5752 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      codigo_ocorrencia  codigo_ocorrencia2 ocorrencia_classificacao  \\\n",
       "0                 40211               40211                INCIDENTE   \n",
       "1                 40349               40349                INCIDENTE   \n",
       "2                 40351               40351                INCIDENTE   \n",
       "3                 39527               39527                 ACIDENTE   \n",
       "4                 40324               40324                INCIDENTE   \n",
       "...                 ...                 ...                      ...   \n",
       "5747              79804               79804                INCIDENTE   \n",
       "5748              79757               79757          INCIDENTE GRAVE   \n",
       "5749              79802               79802                INCIDENTE   \n",
       "5750              79756               79756          INCIDENTE GRAVE   \n",
       "5751              79844               79844                INCIDENTE   \n",
       "\n",
       "       ocorrencia_cidade ocorrencia_uf ocorrencia_aerodromo ocorrencia_dia  \\\n",
       "0         RIO DE JANEIRO            RJ                 ****     2010-01-03   \n",
       "1                  BELÉM            PA                 SBBE     2010-01-03   \n",
       "2         RIO DE JANEIRO            RJ                 SBRJ     2010-01-03   \n",
       "3     LUCAS DO RIO VERDE            MT                 ****     2010-01-04   \n",
       "4                PELOTAS            RS                 SBPK     2010-01-05   \n",
       "...                  ...           ...                  ...            ...   \n",
       "5747            CAMPINAS            SP                 SBKP     2020-12-29   \n",
       "5748   LAGOA DA CONFUSÃO            TO                 ****     2020-12-30   \n",
       "5749      RIO DE JANEIRO            RJ                 SBGL     2020-12-30   \n",
       "5750           VICENTINA            MS                 ****     2020-12-31   \n",
       "5751      RIO DE JANEIRO            RJ                 SBJR     2020-12-31   \n",
       "\n",
       "     ocorrencia_hora  total_recomendacoes  \n",
       "0           12:00:00                    0  \n",
       "1           11:05:00                    0  \n",
       "2           03:00:00                    0  \n",
       "3           17:30:00                    0  \n",
       "4           19:25:00                    0  \n",
       "...              ...                  ...  \n",
       "5747        19:00:00                    0  \n",
       "5748        18:30:00                    0  \n",
       "5749        00:54:00                    0  \n",
       "5750        09:00:00                    0  \n",
       "5751        13:24:00                    0  \n",
       "\n",
       "[5752 rows x 9 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"ocorrencia_2010_2020.csv\", sep=\";\", parse_dates = [\"ocorrencia_dia\"], dayfirst = True)\n",
    "df"
   ]
  },
  {
   "cell_type": "raw",
   "id": "0a1eda6e-8c25-443b-9b2c-3060296efe00",
   "metadata": {},
   "source": [
    "Localização de um dado desejado por linha e coluna:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "425ea78a-5e88-442d-91ec-670140716026",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'BELÉM'"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[1,'ocorrencia_cidade']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "6ec4db38-141a-4dad-a2c0-3590be7c3ac1",
   "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>codigo_ocorrencia</th>\n",
       "      <th>codigo_ocorrencia2</th>\n",
       "      <th>ocorrencia_classificacao</th>\n",
       "      <th>ocorrencia_cidade</th>\n",
       "      <th>ocorrencia_uf</th>\n",
       "      <th>ocorrencia_aerodromo</th>\n",
       "      <th>ocorrencia_dia</th>\n",
       "      <th>ocorrencia_hora</th>\n",
       "      <th>total_recomendacoes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>40211</td>\n",
       "      <td>40211</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RIO DE JANEIRO</td>\n",
       "      <td>RJ</td>\n",
       "      <td>****</td>\n",
       "      <td>2010-01-03</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>40349</td>\n",
       "      <td>40349</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>BELÉM</td>\n",
       "      <td>PA</td>\n",
       "      <td>SBBE</td>\n",
       "      <td>2010-01-03</td>\n",
       "      <td>11:05:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>40351</td>\n",
       "      <td>40351</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RIO DE JANEIRO</td>\n",
       "      <td>RJ</td>\n",
       "      <td>SBRJ</td>\n",
       "      <td>2010-01-03</td>\n",
       "      <td>03:00:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>39527</td>\n",
       "      <td>39527</td>\n",
       "      <td>ACIDENTE</td>\n",
       "      <td>LUCAS DO RIO VERDE</td>\n",
       "      <td>MT</td>\n",
       "      <td>****</td>\n",
       "      <td>2010-01-04</td>\n",
       "      <td>17:30:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   codigo_ocorrencia  codigo_ocorrencia2 ocorrencia_classificacao  \\\n",
       "0              40211               40211                INCIDENTE   \n",
       "1              40349               40349                INCIDENTE   \n",
       "2              40351               40351                INCIDENTE   \n",
       "3              39527               39527                 ACIDENTE   \n",
       "\n",
       "    ocorrencia_cidade ocorrencia_uf ocorrencia_aerodromo ocorrencia_dia  \\\n",
       "0      RIO DE JANEIRO            RJ                 ****     2010-01-03   \n",
       "1               BELÉM            PA                 SBBE     2010-01-03   \n",
       "2      RIO DE JANEIRO            RJ                 SBRJ     2010-01-03   \n",
       "3  LUCAS DO RIO VERDE            MT                 ****     2010-01-04   \n",
       "\n",
       "  ocorrencia_hora  total_recomendacoes  \n",
       "0        12:00:00                    0  \n",
       "1        11:05:00                    0  \n",
       "2        03:00:00                    0  \n",
       "3        17:30:00                    0  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[0:3]"
   ]
  },
  {
   "cell_type": "raw",
   "id": "2cf3b42c-8e52-4297-b835-d50e7073f385",
   "metadata": {},
   "source": [
    "Mostra os dados da linha 10 e da linha 40:\n",
    "df.loc[[10,40]]"
   ]
  },
  {
   "cell_type": "raw",
   "id": "a67c414a-b4bb-48f0-8b3f-eb141a3eea7f",
   "metadata": {},
   "source": [
    "Mostra todos os dados da coluna 'ocorrencia_cidade':\n",
    "df.loc[:,'ocorrencia_cidade']"
   ]
  },
  {
   "cell_type": "raw",
   "id": "c7b70286-fcad-481a-8fed-11c47d20c0b7",
   "metadata": {},
   "source": [
    "Verifica se a coluna tem valores únicos:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "2b242cff-ffe6-4938-9d95-acc18c65e709",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.codigo_ocorrencia.is_unique"
   ]
  },
  {
   "cell_type": "raw",
   "id": "c0d5f9cd-bbd2-4a92-9938-0588c6c0d155",
   "metadata": {},
   "source": [
    "Definindo a coluna como label do dataframe nesse momento(não é alteração no dataframe inteiro):\n",
    "df.set_index('codigo_ocorrencia')"
   ]
  },
  {
   "cell_type": "raw",
   "id": "0cb5cd97-b87b-4b15-9208-d184b31368a3",
   "metadata": {},
   "source": [
    "Alterando o label no dataframe:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "88e5208e-7d34-4a90-866a-d9108adfc2e4",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.set_index('codigo_ocorrencia',inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "16d8e08d-bf6c-4b6d-b7e3-f4bf6737403c",
   "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>codigo_ocorrencia2</th>\n",
       "      <th>ocorrencia_classificacao</th>\n",
       "      <th>ocorrencia_uf</th>\n",
       "      <th>ocorrencia_aerodromo</th>\n",
       "      <th>ocorrencia_dia</th>\n",
       "      <th>ocorrencia_hora</th>\n",
       "      <th>total_recomendacoes</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>codigo_ocorrencia</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>40211</th>\n",
       "      <td>40211</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RJ</td>\n",
       "      <td>****</td>\n",
       "      <td>2010-01-03</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40349</th>\n",
       "      <td>40349</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>PA</td>\n",
       "      <td>SBBE</td>\n",
       "      <td>2010-01-03</td>\n",
       "      <td>11:05:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40351</th>\n",
       "      <td>40351</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RJ</td>\n",
       "      <td>SBRJ</td>\n",
       "      <td>2010-01-03</td>\n",
       "      <td>03:00:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39527</th>\n",
       "      <td>39527</td>\n",
       "      <td>ACIDENTE</td>\n",
       "      <td>MT</td>\n",
       "      <td>****</td>\n",
       "      <td>2010-01-04</td>\n",
       "      <td>17:30:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40324</th>\n",
       "      <td>40324</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RS</td>\n",
       "      <td>SBPK</td>\n",
       "      <td>2010-01-05</td>\n",
       "      <td>19:25:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   codigo_ocorrencia2 ocorrencia_classificacao ocorrencia_uf  \\\n",
       "codigo_ocorrencia                                                              \n",
       "40211                           40211                INCIDENTE            RJ   \n",
       "40349                           40349                INCIDENTE            PA   \n",
       "40351                           40351                INCIDENTE            RJ   \n",
       "39527                           39527                 ACIDENTE            MT   \n",
       "40324                           40324                INCIDENTE            RS   \n",
       "\n",
       "                  ocorrencia_aerodromo ocorrencia_dia ocorrencia_hora  \\\n",
       "codigo_ocorrencia                                                       \n",
       "40211                             ****     2010-01-03        12:00:00   \n",
       "40349                             SBBE     2010-01-03        11:05:00   \n",
       "40351                             SBRJ     2010-01-03        03:00:00   \n",
       "39527                             ****     2010-01-04        17:30:00   \n",
       "40324                             SBPK     2010-01-05        19:25:00   \n",
       "\n",
       "                   total_recomendacoes  \n",
       "codigo_ocorrencia                       \n",
       "40211                                0  \n",
       "40349                                0  \n",
       "40351                                0  \n",
       "39527                                0  \n",
       "40324                                0  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "raw",
   "id": "3772222a-5d14-4fe5-a68b-387687d4da19",
   "metadata": {},
   "source": [
    "Buscando os dados pelo novo label:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "dd81ff89-6478-482d-81a8-e134e71d29b6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "codigo_ocorrencia2                        40211\n",
       "ocorrencia_classificacao              INCIDENTE\n",
       "ocorrencia_uf                                RJ\n",
       "ocorrencia_aerodromo                       ****\n",
       "ocorrencia_dia              2010-01-03 00:00:00\n",
       "ocorrencia_hora                        12:00:00\n",
       "total_recomendacoes                           0\n",
       "Name: 40211, dtype: object"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[40211]"
   ]
  },
  {
   "cell_type": "raw",
   "id": "8cfb95ba-a263-4d00-a85d-b6fb97a27585",
   "metadata": {},
   "source": [
    "Resetando o label do dataframe para o original:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "0299f435-314b-4f5c-9dfd-6b2b601d4ae9",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.reset_index(drop=True, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "9ca20c3f-90de-4044-9667-0c40d1d186c5",
   "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>codigo_ocorrencia2</th>\n",
       "      <th>ocorrencia_classificacao</th>\n",
       "      <th>ocorrencia_uf</th>\n",
       "      <th>ocorrencia_aerodromo</th>\n",
       "      <th>ocorrencia_dia</th>\n",
       "      <th>ocorrencia_hora</th>\n",
       "      <th>total_recomendacoes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>40211</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RJ</td>\n",
       "      <td>****</td>\n",
       "      <td>2010-01-03</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>40349</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>PA</td>\n",
       "      <td>SBBE</td>\n",
       "      <td>2010-01-03</td>\n",
       "      <td>11:05:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>40351</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RJ</td>\n",
       "      <td>SBRJ</td>\n",
       "      <td>2010-01-03</td>\n",
       "      <td>03:00:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>39527</td>\n",
       "      <td>ACIDENTE</td>\n",
       "      <td>MT</td>\n",
       "      <td>****</td>\n",
       "      <td>2010-01-04</td>\n",
       "      <td>17:30:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>40324</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RS</td>\n",
       "      <td>SBPK</td>\n",
       "      <td>2010-01-05</td>\n",
       "      <td>19:25:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   codigo_ocorrencia2 ocorrencia_classificacao ocorrencia_uf  \\\n",
       "0               40211                INCIDENTE            RJ   \n",
       "1               40349                INCIDENTE            PA   \n",
       "2               40351                INCIDENTE            RJ   \n",
       "3               39527                 ACIDENTE            MT   \n",
       "4               40324                INCIDENTE            RS   \n",
       "\n",
       "  ocorrencia_aerodromo ocorrencia_dia ocorrencia_hora  total_recomendacoes  \n",
       "0                 ****     2010-01-03        12:00:00                    0  \n",
       "1                 SBBE     2010-01-03        11:05:00                    0  \n",
       "2                 SBRJ     2010-01-03        03:00:00                    0  \n",
       "3                 ****     2010-01-04        17:30:00                    0  \n",
       "4                 SBPK     2010-01-05        19:25:00                    0  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "raw",
   "id": "0f89b9d5-6d34-40ce-8458-2826a965ce82",
   "metadata": {},
   "source": [
    "Altera valor da linha 0 e coluna 'ocorrencia_aerodromo' para vazio:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "0c7da917-5b6d-4213-9045-578184d9614d",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.loc[0,'ocorrencia_aerodromo'] = ''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "0df3c06c-b40b-475a-8733-360f3263338f",
   "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>codigo_ocorrencia2</th>\n",
       "      <th>ocorrencia_classificacao</th>\n",
       "      <th>ocorrencia_uf</th>\n",
       "      <th>ocorrencia_aerodromo</th>\n",
       "      <th>ocorrencia_dia</th>\n",
       "      <th>ocorrencia_hora</th>\n",
       "      <th>total_recomendacoes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>40211</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RJ</td>\n",
       "      <td></td>\n",
       "      <td>2010-01-03</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   codigo_ocorrencia2 ocorrencia_classificacao ocorrencia_uf  \\\n",
       "0               40211                INCIDENTE            RJ   \n",
       "\n",
       "  ocorrencia_aerodromo ocorrencia_dia ocorrencia_hora  total_recomendacoes  \n",
       "0                          2010-01-03        12:00:00                    0  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(1)"
   ]
  },
  {
   "cell_type": "raw",
   "id": "e343bee3-65b1-43f4-bc5d-2019e43712e5",
   "metadata": {},
   "source": [
    "Altera todos os valores da linha 1 para 20:\n",
    "df.loc[1] = 20\n",
    "\n",
    "Altera todos os valores da coluna 'total_recomendacoes' para 10:\n",
    "df.loc[:,'total_recomendacoes'] = 10"
   ]
  },
  {
   "cell_type": "raw",
   "id": "1a109ab0-3c9b-4e52-aca3-060886d96c55",
   "metadata": {},
   "source": [
    "Fazendo o backup de uma coluna antes de alterá-la, ou seja, criando uma nova:\n",
    "df['ocorrencia_uf_bkp'] = df.ocorrencia_uf"
   ]
  },
  {
   "cell_type": "raw",
   "id": "26b2b8fd-fe44-4a27-b69b-ac6c31cc899c",
   "metadata": {},
   "source": [
    "Alterando para 'GRAVE' o valor da coluna 'ocorrencia_classificacao' onde a 'ocorrencia_uf' seja 'SP' (usando filtro):\n",
    "df.loc[df.ocorrencia_uf == 'SP', ['ocorrencia_classificacao']] = 'GRAVE'    "
   ]
  },
  {
   "cell_type": "raw",
   "id": "603bb46c-d589-4b2f-b4f9-0ca1db89d4da",
   "metadata": {},
   "source": [
    "Filtrando os dados onde 'ocorrencia_uf' seja igual a 'SP':\n",
    "df.loc[df.ocorrencia_uf == 'SP']"
   ]
  },
  {
   "cell_type": "raw",
   "id": "c1a25ec2-b5a5-4e10-b016-970cbb49836c",
   "metadata": {},
   "source": [
    "Dados para limpeza\n",
    "\n",
    "ocorrencia_uf: \n",
    "**\n",
    "\n",
    "ocorrencia_aerodromo:\n",
    "****\n",
    "*****\n",
    "###!\n",
    "####\n",
    "\n",
    "ocorrencia_hora:\n",
    "NULL\n",
    "\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "raw",
   "id": "c7a946e1-3063-4073-b347-a304389186a6",
   "metadata": {},
   "source": [
    "Alterando o valor da célula onde tem '****' da coluna ocorrencia_aerodromo usando a forma de atribuir valores não informados pelo próprio pandas. Dessa forma, teria que alterar para cada símbolo, o que é trabalhoso."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "e664ee0e-c479-48f5-8364-81a6bf883849",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.loc[df.ocorrencia_aerodromo == '****', ['ocorrencia_aerodromo']] = pd.NA"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "fafbd9a1-eafd-41cc-bf34-02a3cce96c67",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.replace(['**', '****', '*****', '###!', '####', 'NULL', ''], pd.NA, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "44a55378-0137-460b-8380-89d9ae939ab7",
   "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>codigo_ocorrencia2</th>\n",
       "      <th>ocorrencia_classificacao</th>\n",
       "      <th>ocorrencia_uf</th>\n",
       "      <th>ocorrencia_aerodromo</th>\n",
       "      <th>ocorrencia_dia</th>\n",
       "      <th>ocorrencia_hora</th>\n",
       "      <th>total_recomendacoes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>40211</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RJ</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>2010-01-03</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>40349</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>PA</td>\n",
       "      <td>SBBE</td>\n",
       "      <td>2010-01-03</td>\n",
       "      <td>11:05:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>40351</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RJ</td>\n",
       "      <td>SBRJ</td>\n",
       "      <td>2010-01-03</td>\n",
       "      <td>03:00:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>39527</td>\n",
       "      <td>ACIDENTE</td>\n",
       "      <td>MT</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>2010-01-04</td>\n",
       "      <td>17:30:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>40324</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RS</td>\n",
       "      <td>SBPK</td>\n",
       "      <td>2010-01-05</td>\n",
       "      <td>19:25:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5747</th>\n",
       "      <td>79804</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>SP</td>\n",
       "      <td>SBKP</td>\n",
       "      <td>2020-12-29</td>\n",
       "      <td>19:00:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5748</th>\n",
       "      <td>79757</td>\n",
       "      <td>INCIDENTE GRAVE</td>\n",
       "      <td>TO</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>2020-12-30</td>\n",
       "      <td>18:30:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5749</th>\n",
       "      <td>79802</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RJ</td>\n",
       "      <td>SBGL</td>\n",
       "      <td>2020-12-30</td>\n",
       "      <td>00:54:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5750</th>\n",
       "      <td>79756</td>\n",
       "      <td>INCIDENTE GRAVE</td>\n",
       "      <td>MS</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>2020-12-31</td>\n",
       "      <td>09:00:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5751</th>\n",
       "      <td>79844</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RJ</td>\n",
       "      <td>SBJR</td>\n",
       "      <td>2020-12-31</td>\n",
       "      <td>13:24:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5752 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      codigo_ocorrencia2 ocorrencia_classificacao ocorrencia_uf  \\\n",
       "0                  40211                INCIDENTE            RJ   \n",
       "1                  40349                INCIDENTE            PA   \n",
       "2                  40351                INCIDENTE            RJ   \n",
       "3                  39527                 ACIDENTE            MT   \n",
       "4                  40324                INCIDENTE            RS   \n",
       "...                  ...                      ...           ...   \n",
       "5747               79804                INCIDENTE            SP   \n",
       "5748               79757          INCIDENTE GRAVE            TO   \n",
       "5749               79802                INCIDENTE            RJ   \n",
       "5750               79756          INCIDENTE GRAVE            MS   \n",
       "5751               79844                INCIDENTE            RJ   \n",
       "\n",
       "     ocorrencia_aerodromo ocorrencia_dia ocorrencia_hora  total_recomendacoes  \n",
       "0                    <NA>     2010-01-03        12:00:00                    0  \n",
       "1                    SBBE     2010-01-03        11:05:00                    0  \n",
       "2                    SBRJ     2010-01-03        03:00:00                    0  \n",
       "3                    <NA>     2010-01-04        17:30:00                    0  \n",
       "4                    SBPK     2010-01-05        19:25:00                    0  \n",
       "...                   ...            ...             ...                  ...  \n",
       "5747                 SBKP     2020-12-29        19:00:00                    0  \n",
       "5748                 <NA>     2020-12-30        18:30:00                    0  \n",
       "5749                 SBGL     2020-12-30        00:54:00                    0  \n",
       "5750                 <NA>     2020-12-31        09:00:00                    0  \n",
       "5751                 SBJR     2020-12-31        13:24:00                    0  \n",
       "\n",
       "[5752 rows x 7 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "raw",
   "id": "3cbbeada-a112-48be-b603-8dce2f8c472c",
   "metadata": {},
   "source": [
    "Soma os valores que sejam do tipo NA, não informado:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "711b1180-242e-4f89-a1ae-6d97c4f2abfc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "codigo_ocorrencia2             0\n",
       "ocorrencia_classificacao       0\n",
       "ocorrencia_uf                  1\n",
       "ocorrencia_aerodromo        2349\n",
       "ocorrencia_dia                 0\n",
       "ocorrencia_hora                1\n",
       "total_recomendacoes            0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isna().sum()"
   ]
  },
  {
   "cell_type": "raw",
   "id": "8beef2d3-eb11-49d8-b61e-9a903e794b18",
   "metadata": {},
   "source": [
    "Cria coluna de backup:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "367ca788-31e0-443f-99e5-1803bf0acb1c",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['total_recomendacoes_bkp'] = df.total_recomendacoes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "041c6cc4-fb97-45db-9047-6578270b7fda",
   "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>codigo_ocorrencia2</th>\n",
       "      <th>ocorrencia_classificacao</th>\n",
       "      <th>ocorrencia_uf</th>\n",
       "      <th>ocorrencia_aerodromo</th>\n",
       "      <th>ocorrencia_dia</th>\n",
       "      <th>ocorrencia_hora</th>\n",
       "      <th>total_recomendacoes</th>\n",
       "      <th>total_recomendacoes_bkp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>40211</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RJ</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>2010-01-03</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>40349</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>PA</td>\n",
       "      <td>SBBE</td>\n",
       "      <td>2010-01-03</td>\n",
       "      <td>11:05:00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>40351</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RJ</td>\n",
       "      <td>SBRJ</td>\n",
       "      <td>2010-01-03</td>\n",
       "      <td>03:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>39527</td>\n",
       "      <td>ACIDENTE</td>\n",
       "      <td>MT</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>2010-01-04</td>\n",
       "      <td>17:30:00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>40324</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RS</td>\n",
       "      <td>SBPK</td>\n",
       "      <td>2010-01-05</td>\n",
       "      <td>19:25:00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5747</th>\n",
       "      <td>79804</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>SP</td>\n",
       "      <td>SBKP</td>\n",
       "      <td>2020-12-29</td>\n",
       "      <td>19:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5748</th>\n",
       "      <td>79757</td>\n",
       "      <td>INCIDENTE GRAVE</td>\n",
       "      <td>TO</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>2020-12-30</td>\n",
       "      <td>18:30:00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5749</th>\n",
       "      <td>79802</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RJ</td>\n",
       "      <td>SBGL</td>\n",
       "      <td>2020-12-30</td>\n",
       "      <td>00:54:00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5750</th>\n",
       "      <td>79756</td>\n",
       "      <td>INCIDENTE GRAVE</td>\n",
       "      <td>MS</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>2020-12-31</td>\n",
       "      <td>09:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5751</th>\n",
       "      <td>79844</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RJ</td>\n",
       "      <td>SBJR</td>\n",
       "      <td>2020-12-31</td>\n",
       "      <td>13:24:00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5752 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     codigo_ocorrencia2 ocorrencia_classificacao ocorrencia_uf  \\\n",
       "0                 40211                INCIDENTE            RJ   \n",
       "1                 40349                INCIDENTE            PA   \n",
       "2                 40351                INCIDENTE            RJ   \n",
       "3                 39527                 ACIDENTE            MT   \n",
       "4                 40324                INCIDENTE            RS   \n",
       "...                 ...                      ...           ...   \n",
       "5747              79804                INCIDENTE            SP   \n",
       "5748              79757          INCIDENTE GRAVE            TO   \n",
       "5749              79802                INCIDENTE            RJ   \n",
       "5750              79756          INCIDENTE GRAVE            MS   \n",
       "5751              79844                INCIDENTE            RJ   \n",
       "\n",
       "     ocorrencia_aerodromo ocorrencia_dia ocorrencia_hora  total_recomendacoes  \\\n",
       "0                    <NA>     2010-01-03        12:00:00                    0   \n",
       "1                    SBBE     2010-01-03        11:05:00                    0   \n",
       "2                    SBRJ     2010-01-03        03:00:00                    0   \n",
       "3                    <NA>     2010-01-04        17:30:00                    0   \n",
       "4                    SBPK     2010-01-05        19:25:00                    0   \n",
       "...                   ...            ...             ...                  ...   \n",
       "5747                 SBKP     2020-12-29        19:00:00                    0   \n",
       "5748                 <NA>     2020-12-30        18:30:00                    0   \n",
       "5749                 SBGL     2020-12-30        00:54:00                    0   \n",
       "5750                 <NA>     2020-12-31        09:00:00                    0   \n",
       "5751                 SBJR     2020-12-31        13:24:00                    0   \n",
       "\n",
       "      total_recomendacoes_bkp  \n",
       "0                           0  \n",
       "1                           0  \n",
       "2                           0  \n",
       "3                           0  \n",
       "4                           0  \n",
       "...                       ...  \n",
       "5747                        0  \n",
       "5748                        0  \n",
       "5749                        0  \n",
       "5750                        0  \n",
       "5751                        0  \n",
       "\n",
       "[5752 rows x 8 columns]"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "raw",
   "id": "5ef191d7-6eec-47be-9f58-a81f1246d912",
   "metadata": {},
   "source": [
    "Deletando a coluna criada anteriormente do dataframe:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "54498035-ffd5-4561-ac4d-8e9a51f6c417",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.drop(['total_recomendacoes_bkp'],axis=1, inplace=True) "
   ]
  },
  {
   "cell_type": "raw",
   "id": "7defac55-e11d-448e-928c-02cec5c49f12",
   "metadata": {},
   "source": [
    "Deletando todas as linhas que tenham valor NA do dataframe nesse instante (não substitui no dataframe):"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "40cfa22c-b572-4257-a4f6-872dbb11d71a",
   "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>codigo_ocorrencia2</th>\n",
       "      <th>ocorrencia_classificacao</th>\n",
       "      <th>ocorrencia_uf</th>\n",
       "      <th>ocorrencia_aerodromo</th>\n",
       "      <th>ocorrencia_dia</th>\n",
       "      <th>ocorrencia_hora</th>\n",
       "      <th>total_recomendacoes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>40349</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>PA</td>\n",
       "      <td>SBBE</td>\n",
       "      <td>2010-01-03</td>\n",
       "      <td>11:05:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>40351</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RJ</td>\n",
       "      <td>SBRJ</td>\n",
       "      <td>2010-01-03</td>\n",
       "      <td>03:00:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>40324</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RS</td>\n",
       "      <td>SBPK</td>\n",
       "      <td>2010-01-05</td>\n",
       "      <td>19:25:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>40215</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>AM</td>\n",
       "      <td>SBUY</td>\n",
       "      <td>2010-01-07</td>\n",
       "      <td>18:40:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>39156</td>\n",
       "      <td>INCIDENTE GRAVE</td>\n",
       "      <td>PR</td>\n",
       "      <td>SBCA</td>\n",
       "      <td>2010-01-10</td>\n",
       "      <td>23:15:00</td>\n",
       "      <td>2</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5743</th>\n",
       "      <td>79824</td>\n",
       "      <td>ACIDENTE</td>\n",
       "      <td>MG</td>\n",
       "      <td>SNRP</td>\n",
       "      <td>2020-12-28</td>\n",
       "      <td>17:00:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5746</th>\n",
       "      <td>79769</td>\n",
       "      <td>INCIDENTE GRAVE</td>\n",
       "      <td>AC</td>\n",
       "      <td>SIMB</td>\n",
       "      <td>2020-12-29</td>\n",
       "      <td>18:30:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5747</th>\n",
       "      <td>79804</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>SP</td>\n",
       "      <td>SBKP</td>\n",
       "      <td>2020-12-29</td>\n",
       "      <td>19:00:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5749</th>\n",
       "      <td>79802</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RJ</td>\n",
       "      <td>SBGL</td>\n",
       "      <td>2020-12-30</td>\n",
       "      <td>00:54:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5751</th>\n",
       "      <td>79844</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RJ</td>\n",
       "      <td>SBJR</td>\n",
       "      <td>2020-12-31</td>\n",
       "      <td>13:24:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3403 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     codigo_ocorrencia2 ocorrencia_classificacao ocorrencia_uf  \\\n",
       "1                 40349                INCIDENTE            PA   \n",
       "2                 40351                INCIDENTE            RJ   \n",
       "4                 40324                INCIDENTE            RS   \n",
       "6                 40215                INCIDENTE            AM   \n",
       "8                 39156          INCIDENTE GRAVE            PR   \n",
       "...                 ...                      ...           ...   \n",
       "5743              79824                 ACIDENTE            MG   \n",
       "5746              79769          INCIDENTE GRAVE            AC   \n",
       "5747              79804                INCIDENTE            SP   \n",
       "5749              79802                INCIDENTE            RJ   \n",
       "5751              79844                INCIDENTE            RJ   \n",
       "\n",
       "     ocorrencia_aerodromo ocorrencia_dia ocorrencia_hora  total_recomendacoes  \n",
       "1                    SBBE     2010-01-03        11:05:00                    0  \n",
       "2                    SBRJ     2010-01-03        03:00:00                    0  \n",
       "4                    SBPK     2010-01-05        19:25:00                    0  \n",
       "6                    SBUY     2010-01-07        18:40:00                    0  \n",
       "8                    SBCA     2010-01-10        23:15:00                    2  \n",
       "...                   ...            ...             ...                  ...  \n",
       "5743                 SNRP     2020-12-28        17:00:00                    0  \n",
       "5746                 SIMB     2020-12-29        18:30:00                    0  \n",
       "5747                 SBKP     2020-12-29        19:00:00                    0  \n",
       "5749                 SBGL     2020-12-30        00:54:00                    0  \n",
       "5751                 SBJR     2020-12-31        13:24:00                    0  \n",
       "\n",
       "[3403 rows x 7 columns]"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dropna()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "21585a46-d168-4ea0-8cff-b4272c301a58",
   "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>codigo_ocorrencia2</th>\n",
       "      <th>ocorrencia_classificacao</th>\n",
       "      <th>ocorrencia_uf</th>\n",
       "      <th>ocorrencia_aerodromo</th>\n",
       "      <th>ocorrencia_dia</th>\n",
       "      <th>ocorrencia_hora</th>\n",
       "      <th>total_recomendacoes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>40211</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RJ</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>2010-01-03</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>40349</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>PA</td>\n",
       "      <td>SBBE</td>\n",
       "      <td>2010-01-03</td>\n",
       "      <td>11:05:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>40351</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RJ</td>\n",
       "      <td>SBRJ</td>\n",
       "      <td>2010-01-03</td>\n",
       "      <td>03:00:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>39527</td>\n",
       "      <td>ACIDENTE</td>\n",
       "      <td>MT</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>2010-01-04</td>\n",
       "      <td>17:30:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>40324</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RS</td>\n",
       "      <td>SBPK</td>\n",
       "      <td>2010-01-05</td>\n",
       "      <td>19:25:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5747</th>\n",
       "      <td>79804</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>SP</td>\n",
       "      <td>SBKP</td>\n",
       "      <td>2020-12-29</td>\n",
       "      <td>19:00:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5748</th>\n",
       "      <td>79757</td>\n",
       "      <td>INCIDENTE GRAVE</td>\n",
       "      <td>TO</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>2020-12-30</td>\n",
       "      <td>18:30:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5749</th>\n",
       "      <td>79802</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RJ</td>\n",
       "      <td>SBGL</td>\n",
       "      <td>2020-12-30</td>\n",
       "      <td>00:54:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5750</th>\n",
       "      <td>79756</td>\n",
       "      <td>INCIDENTE GRAVE</td>\n",
       "      <td>MS</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>2020-12-31</td>\n",
       "      <td>09:00:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5751</th>\n",
       "      <td>79844</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>RJ</td>\n",
       "      <td>SBJR</td>\n",
       "      <td>2020-12-31</td>\n",
       "      <td>13:24:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5752 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     codigo_ocorrencia2 ocorrencia_classificacao ocorrencia_uf  \\\n",
       "0                 40211                INCIDENTE            RJ   \n",
       "1                 40349                INCIDENTE            PA   \n",
       "2                 40351                INCIDENTE            RJ   \n",
       "3                 39527                 ACIDENTE            MT   \n",
       "4                 40324                INCIDENTE            RS   \n",
       "...                 ...                      ...           ...   \n",
       "5747              79804                INCIDENTE            SP   \n",
       "5748              79757          INCIDENTE GRAVE            TO   \n",
       "5749              79802                INCIDENTE            RJ   \n",
       "5750              79756          INCIDENTE GRAVE            MS   \n",
       "5751              79844                INCIDENTE            RJ   \n",
       "\n",
       "     ocorrencia_aerodromo ocorrencia_dia ocorrencia_hora  total_recomendacoes  \n",
       "0                    <NA>     2010-01-03        12:00:00                    0  \n",
       "1                    SBBE     2010-01-03        11:05:00                    0  \n",
       "2                    SBRJ     2010-01-03        03:00:00                    0  \n",
       "3                    <NA>     2010-01-04        17:30:00                    0  \n",
       "4                    SBPK     2010-01-05        19:25:00                    0  \n",
       "...                   ...            ...             ...                  ...  \n",
       "5747                 SBKP     2020-12-29        19:00:00                    0  \n",
       "5748                 <NA>     2020-12-30        18:30:00                    0  \n",
       "5749                 SBGL     2020-12-30        00:54:00                    0  \n",
       "5750                 <NA>     2020-12-31        09:00:00                    0  \n",
       "5751                 SBJR     2020-12-31        13:24:00                    0  \n",
       "\n",
       "[5752 rows x 7 columns]"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  }
 ],
 "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.8.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}