limpeza.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "2b2b512b",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "91eaf0bf",
   "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",
       "  </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",
       "4              40324               40324                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",
       "  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  "
      ]
     },
     "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.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "d9760d19",
   "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": 4,
   "id": "15a50a6c",
   "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>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",
       "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",
       "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",
       "1        11:05:00                    0  \n",
       "2        03:00:00                    0  \n",
       "3        17:30:00                    0  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[1:3]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "587188f5",
   "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>10</th>\n",
       "      <td>39789</td>\n",
       "      <td>39789</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>SÃO PEDRO DO SUL</td>\n",
       "      <td>RS</td>\n",
       "      <td>****</td>\n",
       "      <td>2010-01-10</td>\n",
       "      <td>21:30:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>39158</td>\n",
       "      <td>39158</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>BELÉM</td>\n",
       "      <td>PA</td>\n",
       "      <td>****</td>\n",
       "      <td>2010-01-28</td>\n",
       "      <td>16:00:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    codigo_ocorrencia  codigo_ocorrencia2 ocorrencia_classificacao  \\\n",
       "10              39789               39789                INCIDENTE   \n",
       "40              39158               39158                INCIDENTE   \n",
       "\n",
       "   ocorrencia_cidade ocorrencia_uf ocorrencia_aerodromo ocorrencia_dia  \\\n",
       "10  SÃO PEDRO DO SUL            RS                 ****     2010-01-10   \n",
       "40             BELÉM            PA                 ****     2010-01-28   \n",
       "\n",
       "   ocorrencia_hora  total_recomendacoes  \n",
       "10        21:30:00                    0  \n",
       "40        16:00:00                    0  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[[10,40]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "219f553c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0           RIO DE JANEIRO\n",
       "1                    BELÉM\n",
       "2           RIO DE JANEIRO\n",
       "3       LUCAS DO RIO VERDE\n",
       "4                  PELOTAS\n",
       "               ...        \n",
       "5747              CAMPINAS\n",
       "5748     LAGOA DA CONFUSÃO\n",
       "5749        RIO DE JANEIRO\n",
       "5750             VICENTINA\n",
       "5751        RIO DE JANEIRO\n",
       "Name: ocorrencia_cidade, Length: 5752, dtype: object"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[:,'ocorrencia_cidade']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "1fd47fc0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.codigo_ocorrencia.is_unique"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "d5dfc02f",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.set_index('codigo_ocorrencia', inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "2ee9c94d",
   "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_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",
       "    <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",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>40211</th>\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>40349</th>\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>40351</th>\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>39527</th>\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>40324</th>\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",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   codigo_ocorrencia2 ocorrencia_classificacao  \\\n",
       "codigo_ocorrencia                                                \n",
       "40211                           40211                INCIDENTE   \n",
       "40349                           40349                INCIDENTE   \n",
       "40351                           40351                INCIDENTE   \n",
       "39527                           39527                 ACIDENTE   \n",
       "40324                           40324                INCIDENTE   \n",
       "\n",
       "                    ocorrencia_cidade ocorrencia_uf ocorrencia_aerodromo  \\\n",
       "codigo_ocorrencia                                                          \n",
       "40211                  RIO DE JANEIRO            RJ                 ****   \n",
       "40349                           BELÉM            PA                 SBBE   \n",
       "40351                  RIO DE JANEIRO            RJ                 SBRJ   \n",
       "39527              LUCAS DO RIO VERDE            MT                 ****   \n",
       "40324                         PELOTAS            RS                 SBPK   \n",
       "\n",
       "                  ocorrencia_dia ocorrencia_hora  total_recomendacoes  \n",
       "codigo_ocorrencia                                                      \n",
       "40211                 2010-01-03        12:00:00                    0  \n",
       "40349                 2010-01-03        11:05:00                    0  \n",
       "40351                 2010-01-03        03:00:00                    0  \n",
       "39527                 2010-01-04        17:30:00                    0  \n",
       "40324                 2010-01-05        19:25:00                    0  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "f325e1a9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "codigo_ocorrencia2                        40324\n",
       "ocorrencia_classificacao              INCIDENTE\n",
       "ocorrencia_cidade                       PELOTAS\n",
       "ocorrencia_uf                                RS\n",
       "ocorrencia_aerodromo                       SBPK\n",
       "ocorrencia_dia              2010-01-05 00:00:00\n",
       "ocorrencia_hora                        19:25:00\n",
       "total_recomendacoes                           0\n",
       "Name: 40324, dtype: object"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[40324]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "f196a1f8",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.reset_index(drop=True, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "0e673e93",
   "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_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>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>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>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>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>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",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   codigo_ocorrencia2 ocorrencia_classificacao   ocorrencia_cidade  \\\n",
       "0               40211                INCIDENTE      RIO DE JANEIRO   \n",
       "1               40349                INCIDENTE               BELÉM   \n",
       "2               40351                INCIDENTE      RIO DE JANEIRO   \n",
       "3               39527                 ACIDENTE  LUCAS DO RIO VERDE   \n",
       "4               40324                INCIDENTE             PELOTAS   \n",
       "\n",
       "  ocorrencia_uf ocorrencia_aerodromo ocorrencia_dia ocorrencia_hora  \\\n",
       "0            RJ                 ****     2010-01-03        12:00:00   \n",
       "1            PA                 SBBE     2010-01-03        11:05:00   \n",
       "2            RJ                 SBRJ     2010-01-03        03:00:00   \n",
       "3            MT                 ****     2010-01-04        17:30:00   \n",
       "4            RS                 SBPK     2010-01-05        19:25:00   \n",
       "\n",
       "   total_recomendacoes  \n",
       "0                    0  \n",
       "1                    0  \n",
       "2                    0  \n",
       "3                    0  \n",
       "4                    0  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "2918a18c",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.loc[0,'ocorrencia_aerodromo'] = ''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "1cbf6cef",
   "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_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>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",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   codigo_ocorrencia2 ocorrencia_classificacao ocorrencia_cidade  \\\n",
       "0               40211                INCIDENTE    RIO DE JANEIRO   \n",
       "\n",
       "  ocorrencia_uf ocorrencia_aerodromo ocorrencia_dia ocorrencia_hora  \\\n",
       "0            RJ                          2010-01-03        12:00:00   \n",
       "\n",
       "   total_recomendacoes  \n",
       "0                    0  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "9a59f2d5",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.loc[1] = 20"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "e4a44c20",
   "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_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>INCIDENTE</td>\n",
       "      <td>RIO DE JANEIRO</td>\n",
       "      <td>RJ</td>\n",
       "      <td></td>\n",
       "      <td>2010-01-03 00:00:00</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   codigo_ocorrencia2 ocorrencia_classificacao ocorrencia_cidade  \\\n",
       "0               40211                INCIDENTE    RIO DE JANEIRO   \n",
       "1                  20                       20                20   \n",
       "\n",
       "  ocorrencia_uf ocorrencia_aerodromo       ocorrencia_dia ocorrencia_hora  \\\n",
       "0            RJ                       2010-01-03 00:00:00        12:00:00   \n",
       "1            20                   20                   20              20   \n",
       "\n",
       "   total_recomendacoes  \n",
       "0                    0  \n",
       "1                   20  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "1f85f85e",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.loc[:,'total_recomendacoes'] = 10"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "b9ff8800",
   "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_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>INCIDENTE</td>\n",
       "      <td>RIO DE JANEIRO</td>\n",
       "      <td>RJ</td>\n",
       "      <td></td>\n",
       "      <td>2010-01-03 00:00:00</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\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 00:00:00</td>\n",
       "      <td>03:00:00</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\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 00:00:00</td>\n",
       "      <td>17:30:00</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\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 00:00:00</td>\n",
       "      <td>19:25:00</td>\n",
       "      <td>10</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>CAMPINAS</td>\n",
       "      <td>SP</td>\n",
       "      <td>SBKP</td>\n",
       "      <td>2020-12-29 00:00:00</td>\n",
       "      <td>19:00:00</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5748</th>\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 00:00:00</td>\n",
       "      <td>18:30:00</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5749</th>\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 00:00:00</td>\n",
       "      <td>00:54:00</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5750</th>\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 00:00:00</td>\n",
       "      <td>09:00:00</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5751</th>\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 00:00:00</td>\n",
       "      <td>13:24:00</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5752 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      codigo_ocorrencia2 ocorrencia_classificacao   ocorrencia_cidade  \\\n",
       "0                  40211                INCIDENTE      RIO DE JANEIRO   \n",
       "1                     20                       20                  20   \n",
       "2                  40351                INCIDENTE      RIO DE JANEIRO   \n",
       "3                  39527                 ACIDENTE  LUCAS DO RIO VERDE   \n",
       "4                  40324                INCIDENTE             PELOTAS   \n",
       "...                  ...                      ...                 ...   \n",
       "5747               79804                INCIDENTE            CAMPINAS   \n",
       "5748               79757          INCIDENTE GRAVE   LAGOA DA CONFUSÃO   \n",
       "5749               79802                INCIDENTE      RIO DE JANEIRO   \n",
       "5750               79756          INCIDENTE GRAVE           VICENTINA   \n",
       "5751               79844                INCIDENTE      RIO DE JANEIRO   \n",
       "\n",
       "     ocorrencia_uf ocorrencia_aerodromo       ocorrencia_dia ocorrencia_hora  \\\n",
       "0               RJ                       2010-01-03 00:00:00        12:00:00   \n",
       "1               20                   20                   20              20   \n",
       "2               RJ                 SBRJ  2010-01-03 00:00:00        03:00:00   \n",
       "3               MT                 ****  2010-01-04 00:00:00        17:30:00   \n",
       "4               RS                 SBPK  2010-01-05 00:00:00        19:25:00   \n",
       "...            ...                  ...                  ...             ...   \n",
       "5747            SP                 SBKP  2020-12-29 00:00:00        19:00:00   \n",
       "5748            TO                 ****  2020-12-30 00:00:00        18:30:00   \n",
       "5749            RJ                 SBGL  2020-12-30 00:00:00        00:54:00   \n",
       "5750            MS                 ****  2020-12-31 00:00:00        09:00:00   \n",
       "5751            RJ                 SBJR  2020-12-31 00:00:00        13:24:00   \n",
       "\n",
       "      total_recomendacoes  \n",
       "0                      10  \n",
       "1                      10  \n",
       "2                      10  \n",
       "3                      10  \n",
       "4                      10  \n",
       "...                   ...  \n",
       "5747                   10  \n",
       "5748                   10  \n",
       "5749                   10  \n",
       "5750                   10  \n",
       "5751                   10  \n",
       "\n",
       "[5752 rows x 8 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "6bfe3aa4",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['ocorrencia_uf_bkp'] = df.ocorrencia_uf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "884ef712",
   "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_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",
       "      <th>ocorrencia_uf_bkp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\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 00:00:00</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\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 00:00:00</td>\n",
       "      <td>03:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\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 00:00:00</td>\n",
       "      <td>17:30:00</td>\n",
       "      <td>10</td>\n",
       "      <td>MT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\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 00:00:00</td>\n",
       "      <td>19:25:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RS</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>INCIDENTE</td>\n",
       "      <td>CAMPINAS</td>\n",
       "      <td>SP</td>\n",
       "      <td>SBKP</td>\n",
       "      <td>2020-12-29 00:00:00</td>\n",
       "      <td>19:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>SP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5748</th>\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 00:00:00</td>\n",
       "      <td>18:30:00</td>\n",
       "      <td>10</td>\n",
       "      <td>TO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5749</th>\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 00:00:00</td>\n",
       "      <td>00:54:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5750</th>\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 00:00:00</td>\n",
       "      <td>09:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>MS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5751</th>\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 00:00:00</td>\n",
       "      <td>13:24:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5752 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      codigo_ocorrencia2 ocorrencia_classificacao   ocorrencia_cidade  \\\n",
       "0                  40211                INCIDENTE      RIO DE JANEIRO   \n",
       "1                     20                       20                  20   \n",
       "2                  40351                INCIDENTE      RIO DE JANEIRO   \n",
       "3                  39527                 ACIDENTE  LUCAS DO RIO VERDE   \n",
       "4                  40324                INCIDENTE             PELOTAS   \n",
       "...                  ...                      ...                 ...   \n",
       "5747               79804                INCIDENTE            CAMPINAS   \n",
       "5748               79757          INCIDENTE GRAVE   LAGOA DA CONFUSÃO   \n",
       "5749               79802                INCIDENTE      RIO DE JANEIRO   \n",
       "5750               79756          INCIDENTE GRAVE           VICENTINA   \n",
       "5751               79844                INCIDENTE      RIO DE JANEIRO   \n",
       "\n",
       "     ocorrencia_uf ocorrencia_aerodromo       ocorrencia_dia ocorrencia_hora  \\\n",
       "0               RJ                       2010-01-03 00:00:00        12:00:00   \n",
       "1               20                   20                   20              20   \n",
       "2               RJ                 SBRJ  2010-01-03 00:00:00        03:00:00   \n",
       "3               MT                 ****  2010-01-04 00:00:00        17:30:00   \n",
       "4               RS                 SBPK  2010-01-05 00:00:00        19:25:00   \n",
       "...            ...                  ...                  ...             ...   \n",
       "5747            SP                 SBKP  2020-12-29 00:00:00        19:00:00   \n",
       "5748            TO                 ****  2020-12-30 00:00:00        18:30:00   \n",
       "5749            RJ                 SBGL  2020-12-30 00:00:00        00:54:00   \n",
       "5750            MS                 ****  2020-12-31 00:00:00        09:00:00   \n",
       "5751            RJ                 SBJR  2020-12-31 00:00:00        13:24:00   \n",
       "\n",
       "      total_recomendacoes ocorrencia_uf_bkp  \n",
       "0                      10                RJ  \n",
       "1                      10                20  \n",
       "2                      10                RJ  \n",
       "3                      10                MT  \n",
       "4                      10                RS  \n",
       "...                   ...               ...  \n",
       "5747                   10                SP  \n",
       "5748                   10                TO  \n",
       "5749                   10                RJ  \n",
       "5750                   10                MS  \n",
       "5751                   10                RJ  \n",
       "\n",
       "[5752 rows x 9 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "0c933bb7",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.loc[df.ocorrencia_uf == 'SP', ['ocorrencia_classificacao']] = 'GRAVE'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "dc7a8bbf",
   "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_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",
       "      <th>ocorrencia_uf_bkp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\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 00:00:00</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\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 00:00:00</td>\n",
       "      <td>03:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\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 00:00:00</td>\n",
       "      <td>17:30:00</td>\n",
       "      <td>10</td>\n",
       "      <td>MT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\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 00:00:00</td>\n",
       "      <td>19:25:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RS</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>GRAVE</td>\n",
       "      <td>CAMPINAS</td>\n",
       "      <td>SP</td>\n",
       "      <td>SBKP</td>\n",
       "      <td>2020-12-29 00:00:00</td>\n",
       "      <td>19:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>SP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5748</th>\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 00:00:00</td>\n",
       "      <td>18:30:00</td>\n",
       "      <td>10</td>\n",
       "      <td>TO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5749</th>\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 00:00:00</td>\n",
       "      <td>00:54:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5750</th>\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 00:00:00</td>\n",
       "      <td>09:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>MS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5751</th>\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 00:00:00</td>\n",
       "      <td>13:24:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5752 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      codigo_ocorrencia2 ocorrencia_classificacao   ocorrencia_cidade  \\\n",
       "0                  40211                INCIDENTE      RIO DE JANEIRO   \n",
       "1                     20                       20                  20   \n",
       "2                  40351                INCIDENTE      RIO DE JANEIRO   \n",
       "3                  39527                 ACIDENTE  LUCAS DO RIO VERDE   \n",
       "4                  40324                INCIDENTE             PELOTAS   \n",
       "...                  ...                      ...                 ...   \n",
       "5747               79804                    GRAVE            CAMPINAS   \n",
       "5748               79757          INCIDENTE GRAVE   LAGOA DA CONFUSÃO   \n",
       "5749               79802                INCIDENTE      RIO DE JANEIRO   \n",
       "5750               79756          INCIDENTE GRAVE           VICENTINA   \n",
       "5751               79844                INCIDENTE      RIO DE JANEIRO   \n",
       "\n",
       "     ocorrencia_uf ocorrencia_aerodromo       ocorrencia_dia ocorrencia_hora  \\\n",
       "0               RJ                       2010-01-03 00:00:00        12:00:00   \n",
       "1               20                   20                   20              20   \n",
       "2               RJ                 SBRJ  2010-01-03 00:00:00        03:00:00   \n",
       "3               MT                 ****  2010-01-04 00:00:00        17:30:00   \n",
       "4               RS                 SBPK  2010-01-05 00:00:00        19:25:00   \n",
       "...            ...                  ...                  ...             ...   \n",
       "5747            SP                 SBKP  2020-12-29 00:00:00        19:00:00   \n",
       "5748            TO                 ****  2020-12-30 00:00:00        18:30:00   \n",
       "5749            RJ                 SBGL  2020-12-30 00:00:00        00:54:00   \n",
       "5750            MS                 ****  2020-12-31 00:00:00        09:00:00   \n",
       "5751            RJ                 SBJR  2020-12-31 00:00:00        13:24:00   \n",
       "\n",
       "      total_recomendacoes ocorrencia_uf_bkp  \n",
       "0                      10                RJ  \n",
       "1                      10                20  \n",
       "2                      10                RJ  \n",
       "3                      10                MT  \n",
       "4                      10                RS  \n",
       "...                   ...               ...  \n",
       "5747                   10                SP  \n",
       "5748                   10                TO  \n",
       "5749                   10                RJ  \n",
       "5750                   10                MS  \n",
       "5751                   10                RJ  \n",
       "\n",
       "[5752 rows x 9 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "8910b3d5",
   "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_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",
       "      <th>ocorrencia_uf_bkp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>40069</td>\n",
       "      <td>GRAVE</td>\n",
       "      <td>SÃO PAULO</td>\n",
       "      <td>SP</td>\n",
       "      <td>SBMT</td>\n",
       "      <td>2010-01-10 00:00:00</td>\n",
       "      <td>14:50:00</td>\n",
       "      <td>10</td>\n",
       "      <td>SP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>39809</td>\n",
       "      <td>GRAVE</td>\n",
       "      <td>SÃO PAULO</td>\n",
       "      <td>SP</td>\n",
       "      <td>****</td>\n",
       "      <td>2010-01-15 00:00:00</td>\n",
       "      <td>15:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>SP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>39828</td>\n",
       "      <td>GRAVE</td>\n",
       "      <td>SANTOS</td>\n",
       "      <td>SP</td>\n",
       "      <td>****</td>\n",
       "      <td>2010-01-15 00:00:00</td>\n",
       "      <td>17:45:00</td>\n",
       "      <td>10</td>\n",
       "      <td>SP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>39847</td>\n",
       "      <td>GRAVE</td>\n",
       "      <td>SOROCABA</td>\n",
       "      <td>SP</td>\n",
       "      <td>****</td>\n",
       "      <td>2010-01-20 00:00:00</td>\n",
       "      <td>13:10:00</td>\n",
       "      <td>10</td>\n",
       "      <td>SP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>39768</td>\n",
       "      <td>GRAVE</td>\n",
       "      <td>CAMPINAS</td>\n",
       "      <td>SP</td>\n",
       "      <td>****</td>\n",
       "      <td>2010-01-21 00:00:00</td>\n",
       "      <td>20:45:00</td>\n",
       "      <td>10</td>\n",
       "      <td>SP</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>5704</th>\n",
       "      <td>79739</td>\n",
       "      <td>GRAVE</td>\n",
       "      <td>SÃO PAULO</td>\n",
       "      <td>SP</td>\n",
       "      <td>SBSP</td>\n",
       "      <td>2020-12-03 00:00:00</td>\n",
       "      <td>14:42:00</td>\n",
       "      <td>10</td>\n",
       "      <td>SP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5705</th>\n",
       "      <td>79705</td>\n",
       "      <td>GRAVE</td>\n",
       "      <td>SOROCABA</td>\n",
       "      <td>SP</td>\n",
       "      <td>SDCO</td>\n",
       "      <td>2020-12-04 00:00:00</td>\n",
       "      <td>15:30:00</td>\n",
       "      <td>10</td>\n",
       "      <td>SP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5715</th>\n",
       "      <td>79718</td>\n",
       "      <td>GRAVE</td>\n",
       "      <td>SÃO PAULO</td>\n",
       "      <td>SP</td>\n",
       "      <td>SBMT</td>\n",
       "      <td>2020-12-11 00:00:00</td>\n",
       "      <td>13:50:00</td>\n",
       "      <td>10</td>\n",
       "      <td>SP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5742</th>\n",
       "      <td>79800</td>\n",
       "      <td>GRAVE</td>\n",
       "      <td>SÃO PAULO</td>\n",
       "      <td>SP</td>\n",
       "      <td>SBMT</td>\n",
       "      <td>2020-12-28 00:00:00</td>\n",
       "      <td>10:15:00</td>\n",
       "      <td>10</td>\n",
       "      <td>SP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5747</th>\n",
       "      <td>79804</td>\n",
       "      <td>GRAVE</td>\n",
       "      <td>CAMPINAS</td>\n",
       "      <td>SP</td>\n",
       "      <td>SBKP</td>\n",
       "      <td>2020-12-29 00:00:00</td>\n",
       "      <td>19:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>SP</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1373 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      codigo_ocorrencia2 ocorrencia_classificacao ocorrencia_cidade  \\\n",
       "11                 40069                    GRAVE         SÃO PAULO   \n",
       "16                 39809                    GRAVE         SÃO PAULO   \n",
       "18                 39828                    GRAVE            SANTOS   \n",
       "26                 39847                    GRAVE          SOROCABA   \n",
       "27                 39768                    GRAVE          CAMPINAS   \n",
       "...                  ...                      ...               ...   \n",
       "5704               79739                    GRAVE         SÃO PAULO   \n",
       "5705               79705                    GRAVE          SOROCABA   \n",
       "5715               79718                    GRAVE         SÃO PAULO   \n",
       "5742               79800                    GRAVE         SÃO PAULO   \n",
       "5747               79804                    GRAVE          CAMPINAS   \n",
       "\n",
       "     ocorrencia_uf ocorrencia_aerodromo       ocorrencia_dia ocorrencia_hora  \\\n",
       "11              SP                 SBMT  2010-01-10 00:00:00        14:50:00   \n",
       "16              SP                 ****  2010-01-15 00:00:00        15:00:00   \n",
       "18              SP                 ****  2010-01-15 00:00:00        17:45:00   \n",
       "26              SP                 ****  2010-01-20 00:00:00        13:10:00   \n",
       "27              SP                 ****  2010-01-21 00:00:00        20:45:00   \n",
       "...            ...                  ...                  ...             ...   \n",
       "5704            SP                 SBSP  2020-12-03 00:00:00        14:42:00   \n",
       "5705            SP                 SDCO  2020-12-04 00:00:00        15:30:00   \n",
       "5715            SP                 SBMT  2020-12-11 00:00:00        13:50:00   \n",
       "5742            SP                 SBMT  2020-12-28 00:00:00        10:15:00   \n",
       "5747            SP                 SBKP  2020-12-29 00:00:00        19:00:00   \n",
       "\n",
       "      total_recomendacoes ocorrencia_uf_bkp  \n",
       "11                     10                SP  \n",
       "16                     10                SP  \n",
       "18                     10                SP  \n",
       "26                     10                SP  \n",
       "27                     10                SP  \n",
       "...                   ...               ...  \n",
       "5704                   10                SP  \n",
       "5705                   10                SP  \n",
       "5715                   10                SP  \n",
       "5742                   10                SP  \n",
       "5747                   10                SP  \n",
       "\n",
       "[1373 rows x 9 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[df.ocorrencia_uf == 'SP']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "1d220faf",
   "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_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",
       "      <th>ocorrencia_uf_bkp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\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 00:00:00</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\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 00:00:00</td>\n",
       "      <td>03:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\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 00:00:00</td>\n",
       "      <td>17:30:00</td>\n",
       "      <td>10</td>\n",
       "      <td>MT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\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 00:00:00</td>\n",
       "      <td>19:25:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RS</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>GRAVE</td>\n",
       "      <td>CAMPINAS</td>\n",
       "      <td>SP</td>\n",
       "      <td>SBKP</td>\n",
       "      <td>2020-12-29 00:00:00</td>\n",
       "      <td>19:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>SP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5748</th>\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 00:00:00</td>\n",
       "      <td>18:30:00</td>\n",
       "      <td>10</td>\n",
       "      <td>TO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5749</th>\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 00:00:00</td>\n",
       "      <td>00:54:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5750</th>\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 00:00:00</td>\n",
       "      <td>09:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>MS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5751</th>\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 00:00:00</td>\n",
       "      <td>13:24:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5752 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      codigo_ocorrencia2 ocorrencia_classificacao   ocorrencia_cidade  \\\n",
       "0                  40211                INCIDENTE      RIO DE JANEIRO   \n",
       "1                     20                       20                  20   \n",
       "2                  40351                INCIDENTE      RIO DE JANEIRO   \n",
       "3                  39527                 ACIDENTE  LUCAS DO RIO VERDE   \n",
       "4                  40324                INCIDENTE             PELOTAS   \n",
       "...                  ...                      ...                 ...   \n",
       "5747               79804                    GRAVE            CAMPINAS   \n",
       "5748               79757          INCIDENTE GRAVE   LAGOA DA CONFUSÃO   \n",
       "5749               79802                INCIDENTE      RIO DE JANEIRO   \n",
       "5750               79756          INCIDENTE GRAVE           VICENTINA   \n",
       "5751               79844                INCIDENTE      RIO DE JANEIRO   \n",
       "\n",
       "     ocorrencia_uf ocorrencia_aerodromo       ocorrencia_dia ocorrencia_hora  \\\n",
       "0               RJ                       2010-01-03 00:00:00        12:00:00   \n",
       "1               20                   20                   20              20   \n",
       "2               RJ                 SBRJ  2010-01-03 00:00:00        03:00:00   \n",
       "3               MT                 ****  2010-01-04 00:00:00        17:30:00   \n",
       "4               RS                 SBPK  2010-01-05 00:00:00        19:25:00   \n",
       "...            ...                  ...                  ...             ...   \n",
       "5747            SP                 SBKP  2020-12-29 00:00:00        19:00:00   \n",
       "5748            TO                 ****  2020-12-30 00:00:00        18:30:00   \n",
       "5749            RJ                 SBGL  2020-12-30 00:00:00        00:54:00   \n",
       "5750            MS                 ****  2020-12-31 00:00:00        09:00:00   \n",
       "5751            RJ                 SBJR  2020-12-31 00:00:00        13:24:00   \n",
       "\n",
       "      total_recomendacoes ocorrencia_uf_bkp  \n",
       "0                      10                RJ  \n",
       "1                      10                20  \n",
       "2                      10                RJ  \n",
       "3                      10                MT  \n",
       "4                      10                RS  \n",
       "...                   ...               ...  \n",
       "5747                   10                SP  \n",
       "5748                   10                TO  \n",
       "5749                   10                RJ  \n",
       "5750                   10                MS  \n",
       "5751                   10                RJ  \n",
       "\n",
       "[5752 rows x 9 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "5764191b",
   "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_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",
       "      <th>ocorrencia_uf_bkp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\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 00:00:00</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\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 00:00:00</td>\n",
       "      <td>03:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\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 00:00:00</td>\n",
       "      <td>17:30:00</td>\n",
       "      <td>10</td>\n",
       "      <td>MT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\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 00:00:00</td>\n",
       "      <td>19:25:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RS</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   codigo_ocorrencia2 ocorrencia_classificacao   ocorrencia_cidade  \\\n",
       "0               40211                INCIDENTE      RIO DE JANEIRO   \n",
       "1                  20                       20                  20   \n",
       "2               40351                INCIDENTE      RIO DE JANEIRO   \n",
       "3               39527                 ACIDENTE  LUCAS DO RIO VERDE   \n",
       "4               40324                INCIDENTE             PELOTAS   \n",
       "\n",
       "  ocorrencia_uf ocorrencia_aerodromo       ocorrencia_dia ocorrencia_hora  \\\n",
       "0            RJ                       2010-01-03 00:00:00        12:00:00   \n",
       "1            20                   20                   20              20   \n",
       "2            RJ                 SBRJ  2010-01-03 00:00:00        03:00:00   \n",
       "3            MT                 ****  2010-01-04 00:00:00        17:30:00   \n",
       "4            RS                 SBPK  2010-01-05 00:00:00        19:25:00   \n",
       "\n",
       "   total_recomendacoes ocorrencia_uf_bkp  \n",
       "0                   10                RJ  \n",
       "1                   10                20  \n",
       "2                   10                RJ  \n",
       "3                   10                MT  \n",
       "4                   10                RS  "
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "027bf658",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.loc[df.ocorrencia_aerodromo == '****', ['ocorrencia_aerodromo']] = pd.NA"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "86a07a09",
   "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_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",
       "      <th>ocorrencia_uf_bkp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\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 00:00:00</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\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 00:00:00</td>\n",
       "      <td>03:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>39527</td>\n",
       "      <td>ACIDENTE</td>\n",
       "      <td>LUCAS DO RIO VERDE</td>\n",
       "      <td>MT</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>2010-01-04 00:00:00</td>\n",
       "      <td>17:30:00</td>\n",
       "      <td>10</td>\n",
       "      <td>MT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\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 00:00:00</td>\n",
       "      <td>19:25:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RS</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   codigo_ocorrencia2 ocorrencia_classificacao   ocorrencia_cidade  \\\n",
       "0               40211                INCIDENTE      RIO DE JANEIRO   \n",
       "1                  20                       20                  20   \n",
       "2               40351                INCIDENTE      RIO DE JANEIRO   \n",
       "3               39527                 ACIDENTE  LUCAS DO RIO VERDE   \n",
       "4               40324                INCIDENTE             PELOTAS   \n",
       "\n",
       "  ocorrencia_uf ocorrencia_aerodromo       ocorrencia_dia ocorrencia_hora  \\\n",
       "0            RJ                       2010-01-03 00:00:00        12:00:00   \n",
       "1            20                   20                   20              20   \n",
       "2            RJ                 SBRJ  2010-01-03 00:00:00        03:00:00   \n",
       "3            MT                 <NA>  2010-01-04 00:00:00        17:30:00   \n",
       "4            RS                 SBPK  2010-01-05 00:00:00        19:25:00   \n",
       "\n",
       "   total_recomendacoes ocorrencia_uf_bkp  \n",
       "0                   10                RJ  \n",
       "1                   10                20  \n",
       "2                   10                RJ  \n",
       "3                   10                MT  \n",
       "4                   10                RS  "
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "raw",
   "id": "2c966754",
   "metadata": {},
   "source": [
    "ocorrencia_uf\n",
    "** \n",
    "ocorrencia_aerodromo\n",
    "###!\n",
    "####\n",
    "****\n",
    "*****\n",
    "ocorrencia_hora\n",
    "NULL"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "e3ff0f06",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.replace(['**','###!','####','****','*****','NULL'], pd.NA, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "93995540",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "codigo_ocorrencia2             0\n",
       "ocorrencia_classificacao       0\n",
       "ocorrencia_cidade              0\n",
       "ocorrencia_uf                  1\n",
       "ocorrencia_aerodromo        2348\n",
       "ocorrencia_dia                 0\n",
       "ocorrencia_hora                1\n",
       "total_recomendacoes            0\n",
       "ocorrencia_uf_bkp              1\n",
       "dtype: int64"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isna().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "f6f55bb4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "codigo_ocorrencia2             0\n",
       "ocorrencia_classificacao       0\n",
       "ocorrencia_cidade              0\n",
       "ocorrencia_uf                  1\n",
       "ocorrencia_aerodromo        2348\n",
       "ocorrencia_dia                 0\n",
       "ocorrencia_hora                1\n",
       "total_recomendacoes            0\n",
       "ocorrencia_uf_bkp              1\n",
       "dtype: int64"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "a041e3d9",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.fillna(10, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "b34fe84a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "codigo_ocorrencia2          0\n",
       "ocorrencia_classificacao    0\n",
       "ocorrencia_cidade           0\n",
       "ocorrencia_uf               0\n",
       "ocorrencia_aerodromo        0\n",
       "ocorrencia_dia              0\n",
       "ocorrencia_hora             0\n",
       "total_recomendacoes         0\n",
       "ocorrencia_uf_bkp           0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "e8ab23f8",
   "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_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",
       "      <th>ocorrencia_uf_bkp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\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 00:00:00</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\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 00:00:00</td>\n",
       "      <td>03:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>39527</td>\n",
       "      <td>ACIDENTE</td>\n",
       "      <td>LUCAS DO RIO VERDE</td>\n",
       "      <td>MT</td>\n",
       "      <td>10</td>\n",
       "      <td>2010-01-04 00:00:00</td>\n",
       "      <td>17:30:00</td>\n",
       "      <td>10</td>\n",
       "      <td>MT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\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 00:00:00</td>\n",
       "      <td>19:25:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RS</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   codigo_ocorrencia2 ocorrencia_classificacao   ocorrencia_cidade  \\\n",
       "0               40211                INCIDENTE      RIO DE JANEIRO   \n",
       "1                  20                       20                  20   \n",
       "2               40351                INCIDENTE      RIO DE JANEIRO   \n",
       "3               39527                 ACIDENTE  LUCAS DO RIO VERDE   \n",
       "4               40324                INCIDENTE             PELOTAS   \n",
       "\n",
       "  ocorrencia_uf ocorrencia_aerodromo       ocorrencia_dia ocorrencia_hora  \\\n",
       "0            RJ                       2010-01-03 00:00:00        12:00:00   \n",
       "1            20                   20                   20              20   \n",
       "2            RJ                 SBRJ  2010-01-03 00:00:00        03:00:00   \n",
       "3            MT                   10  2010-01-04 00:00:00        17:30:00   \n",
       "4            RS                 SBPK  2010-01-05 00:00:00        19:25:00   \n",
       "\n",
       "   total_recomendacoes ocorrencia_uf_bkp  \n",
       "0                   10                RJ  \n",
       "1                   10                20  \n",
       "2                   10                RJ  \n",
       "3                   10                MT  \n",
       "4                   10                RS  "
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "61aac007",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.replace([10], pd.NA, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "232a8568",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "codigo_ocorrencia2             0\n",
       "ocorrencia_classificacao       0\n",
       "ocorrencia_cidade              0\n",
       "ocorrencia_uf                  1\n",
       "ocorrencia_aerodromo        2348\n",
       "ocorrencia_dia                 0\n",
       "ocorrencia_hora                1\n",
       "total_recomendacoes         5752\n",
       "ocorrencia_uf_bkp              1\n",
       "dtype: int64"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "cd7fd4e2",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.fillna(value={'total_recomendacoes':10}, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "5f8f51dc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "codigo_ocorrencia2             0\n",
       "ocorrencia_classificacao       0\n",
       "ocorrencia_cidade              0\n",
       "ocorrencia_uf                  1\n",
       "ocorrencia_aerodromo        2348\n",
       "ocorrencia_dia                 0\n",
       "ocorrencia_hora                1\n",
       "total_recomendacoes            0\n",
       "ocorrencia_uf_bkp              1\n",
       "dtype: int64"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "6bb02c36",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['total_recomendacoes_bkp'] = df.total_recomendacoes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "ee660f19",
   "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_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",
       "      <th>ocorrencia_uf_bkp</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>RIO DE JANEIRO</td>\n",
       "      <td>RJ</td>\n",
       "      <td></td>\n",
       "      <td>2010-01-03 00:00:00</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\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 00:00:00</td>\n",
       "      <td>03:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>39527</td>\n",
       "      <td>ACIDENTE</td>\n",
       "      <td>LUCAS DO RIO VERDE</td>\n",
       "      <td>MT</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>2010-01-04 00:00:00</td>\n",
       "      <td>17:30:00</td>\n",
       "      <td>10</td>\n",
       "      <td>MT</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\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 00:00:00</td>\n",
       "      <td>19:25:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RS</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  codigo_ocorrencia2 ocorrencia_classificacao   ocorrencia_cidade  \\\n",
       "0              40211                INCIDENTE      RIO DE JANEIRO   \n",
       "1                 20                       20                  20   \n",
       "2              40351                INCIDENTE      RIO DE JANEIRO   \n",
       "3              39527                 ACIDENTE  LUCAS DO RIO VERDE   \n",
       "4              40324                INCIDENTE             PELOTAS   \n",
       "\n",
       "  ocorrencia_uf ocorrencia_aerodromo       ocorrencia_dia ocorrencia_hora  \\\n",
       "0            RJ                       2010-01-03 00:00:00        12:00:00   \n",
       "1            20                   20                   20              20   \n",
       "2            RJ                 SBRJ  2010-01-03 00:00:00        03:00:00   \n",
       "3            MT                 <NA>  2010-01-04 00:00:00        17:30:00   \n",
       "4            RS                 SBPK  2010-01-05 00:00:00        19:25:00   \n",
       "\n",
       "   total_recomendacoes ocorrencia_uf_bkp  total_recomendacoes_bkp  \n",
       "0                   10                RJ                       10  \n",
       "1                   10                20                       10  \n",
       "2                   10                RJ                       10  \n",
       "3                   10                MT                       10  \n",
       "4                   10                RS                       10  "
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "8a157255",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.drop(['total_recomendacoes_bkp'], axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "26f1ddb6",
   "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_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",
       "      <th>ocorrencia_uf_bkp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\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 00:00:00</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\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 00:00:00</td>\n",
       "      <td>03:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>39527</td>\n",
       "      <td>ACIDENTE</td>\n",
       "      <td>LUCAS DO RIO VERDE</td>\n",
       "      <td>MT</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>2010-01-04 00:00:00</td>\n",
       "      <td>17:30:00</td>\n",
       "      <td>10</td>\n",
       "      <td>MT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\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 00:00:00</td>\n",
       "      <td>19:25:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RS</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  codigo_ocorrencia2 ocorrencia_classificacao   ocorrencia_cidade  \\\n",
       "0              40211                INCIDENTE      RIO DE JANEIRO   \n",
       "1                 20                       20                  20   \n",
       "2              40351                INCIDENTE      RIO DE JANEIRO   \n",
       "3              39527                 ACIDENTE  LUCAS DO RIO VERDE   \n",
       "4              40324                INCIDENTE             PELOTAS   \n",
       "\n",
       "  ocorrencia_uf ocorrencia_aerodromo       ocorrencia_dia ocorrencia_hora  \\\n",
       "0            RJ                       2010-01-03 00:00:00        12:00:00   \n",
       "1            20                   20                   20              20   \n",
       "2            RJ                 SBRJ  2010-01-03 00:00:00        03:00:00   \n",
       "3            MT                 <NA>  2010-01-04 00:00:00        17:30:00   \n",
       "4            RS                 SBPK  2010-01-05 00:00:00        19:25:00   \n",
       "\n",
       "   total_recomendacoes ocorrencia_uf_bkp  \n",
       "0                   10                RJ  \n",
       "1                   10                20  \n",
       "2                   10                RJ  \n",
       "3                   10                MT  \n",
       "4                   10                RS  "
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "13513956",
   "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_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",
       "      <th>ocorrencia_uf_bkp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\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 00:00:00</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\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 00:00:00</td>\n",
       "      <td>03:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\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 00:00:00</td>\n",
       "      <td>19:25:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>40215</td>\n",
       "      <td>INCIDENTE</td>\n",
       "      <td>COARI</td>\n",
       "      <td>AM</td>\n",
       "      <td>SBUY</td>\n",
       "      <td>2010-01-07 00:00:00</td>\n",
       "      <td>18:40:00</td>\n",
       "      <td>10</td>\n",
       "      <td>AM</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>5743</th>\n",
       "      <td>79824</td>\n",
       "      <td>ACIDENTE</td>\n",
       "      <td>RIO PARANAÍBA</td>\n",
       "      <td>MG</td>\n",
       "      <td>SNRP</td>\n",
       "      <td>2020-12-28 00:00:00</td>\n",
       "      <td>17:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>MG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5746</th>\n",
       "      <td>79769</td>\n",
       "      <td>INCIDENTE GRAVE</td>\n",
       "      <td>MANOEL URBANO</td>\n",
       "      <td>AC</td>\n",
       "      <td>SIMB</td>\n",
       "      <td>2020-12-29 00:00:00</td>\n",
       "      <td>18:30:00</td>\n",
       "      <td>10</td>\n",
       "      <td>AC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5747</th>\n",
       "      <td>79804</td>\n",
       "      <td>GRAVE</td>\n",
       "      <td>CAMPINAS</td>\n",
       "      <td>SP</td>\n",
       "      <td>SBKP</td>\n",
       "      <td>2020-12-29 00:00:00</td>\n",
       "      <td>19:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>SP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5749</th>\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 00:00:00</td>\n",
       "      <td>00:54:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5751</th>\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 00:00:00</td>\n",
       "      <td>13:24:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3404 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     codigo_ocorrencia2 ocorrencia_classificacao ocorrencia_cidade  \\\n",
       "0                 40211                INCIDENTE    RIO DE JANEIRO   \n",
       "1                    20                       20                20   \n",
       "2                 40351                INCIDENTE    RIO DE JANEIRO   \n",
       "4                 40324                INCIDENTE           PELOTAS   \n",
       "6                 40215                INCIDENTE             COARI   \n",
       "...                 ...                      ...               ...   \n",
       "5743              79824                 ACIDENTE     RIO PARANAÍBA   \n",
       "5746              79769          INCIDENTE GRAVE     MANOEL URBANO   \n",
       "5747              79804                    GRAVE          CAMPINAS   \n",
       "5749              79802                INCIDENTE    RIO DE JANEIRO   \n",
       "5751              79844                INCIDENTE    RIO DE JANEIRO   \n",
       "\n",
       "     ocorrencia_uf ocorrencia_aerodromo       ocorrencia_dia ocorrencia_hora  \\\n",
       "0               RJ                       2010-01-03 00:00:00        12:00:00   \n",
       "1               20                   20                   20              20   \n",
       "2               RJ                 SBRJ  2010-01-03 00:00:00        03:00:00   \n",
       "4               RS                 SBPK  2010-01-05 00:00:00        19:25:00   \n",
       "6               AM                 SBUY  2010-01-07 00:00:00        18:40:00   \n",
       "...            ...                  ...                  ...             ...   \n",
       "5743            MG                 SNRP  2020-12-28 00:00:00        17:00:00   \n",
       "5746            AC                 SIMB  2020-12-29 00:00:00        18:30:00   \n",
       "5747            SP                 SBKP  2020-12-29 00:00:00        19:00:00   \n",
       "5749            RJ                 SBGL  2020-12-30 00:00:00        00:54:00   \n",
       "5751            RJ                 SBJR  2020-12-31 00:00:00        13:24:00   \n",
       "\n",
       "      total_recomendacoes ocorrencia_uf_bkp  \n",
       "0                      10                RJ  \n",
       "1                      10                20  \n",
       "2                      10                RJ  \n",
       "4                      10                RS  \n",
       "6                      10                AM  \n",
       "...                   ...               ...  \n",
       "5743                   10                MG  \n",
       "5746                   10                AC  \n",
       "5747                   10                SP  \n",
       "5749                   10                RJ  \n",
       "5751                   10                RJ  \n",
       "\n",
       "[3404 rows x 9 columns]"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dropna()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "0159f3cc",
   "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_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",
       "      <th>ocorrencia_uf_bkp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\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 00:00:00</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\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 00:00:00</td>\n",
       "      <td>03:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>39527</td>\n",
       "      <td>ACIDENTE</td>\n",
       "      <td>LUCAS DO RIO VERDE</td>\n",
       "      <td>MT</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>2010-01-04 00:00:00</td>\n",
       "      <td>17:30:00</td>\n",
       "      <td>10</td>\n",
       "      <td>MT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\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 00:00:00</td>\n",
       "      <td>19:25:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RS</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>GRAVE</td>\n",
       "      <td>CAMPINAS</td>\n",
       "      <td>SP</td>\n",
       "      <td>SBKP</td>\n",
       "      <td>2020-12-29 00:00:00</td>\n",
       "      <td>19:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>SP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5748</th>\n",
       "      <td>79757</td>\n",
       "      <td>INCIDENTE GRAVE</td>\n",
       "      <td>LAGOA DA CONFUSÃO</td>\n",
       "      <td>TO</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>2020-12-30 00:00:00</td>\n",
       "      <td>18:30:00</td>\n",
       "      <td>10</td>\n",
       "      <td>TO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5749</th>\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 00:00:00</td>\n",
       "      <td>00:54:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5750</th>\n",
       "      <td>79756</td>\n",
       "      <td>INCIDENTE GRAVE</td>\n",
       "      <td>VICENTINA</td>\n",
       "      <td>MS</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>2020-12-31 00:00:00</td>\n",
       "      <td>09:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>MS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5751</th>\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 00:00:00</td>\n",
       "      <td>13:24:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5752 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     codigo_ocorrencia2 ocorrencia_classificacao   ocorrencia_cidade  \\\n",
       "0                 40211                INCIDENTE      RIO DE JANEIRO   \n",
       "1                    20                       20                  20   \n",
       "2                 40351                INCIDENTE      RIO DE JANEIRO   \n",
       "3                 39527                 ACIDENTE  LUCAS DO RIO VERDE   \n",
       "4                 40324                INCIDENTE             PELOTAS   \n",
       "...                 ...                      ...                 ...   \n",
       "5747              79804                    GRAVE            CAMPINAS   \n",
       "5748              79757          INCIDENTE GRAVE   LAGOA DA CONFUSÃO   \n",
       "5749              79802                INCIDENTE      RIO DE JANEIRO   \n",
       "5750              79756          INCIDENTE GRAVE           VICENTINA   \n",
       "5751              79844                INCIDENTE      RIO DE JANEIRO   \n",
       "\n",
       "     ocorrencia_uf ocorrencia_aerodromo       ocorrencia_dia ocorrencia_hora  \\\n",
       "0               RJ                       2010-01-03 00:00:00        12:00:00   \n",
       "1               20                   20                   20              20   \n",
       "2               RJ                 SBRJ  2010-01-03 00:00:00        03:00:00   \n",
       "3               MT                 <NA>  2010-01-04 00:00:00        17:30:00   \n",
       "4               RS                 SBPK  2010-01-05 00:00:00        19:25:00   \n",
       "...            ...                  ...                  ...             ...   \n",
       "5747            SP                 SBKP  2020-12-29 00:00:00        19:00:00   \n",
       "5748            TO                 <NA>  2020-12-30 00:00:00        18:30:00   \n",
       "5749            RJ                 SBGL  2020-12-30 00:00:00        00:54:00   \n",
       "5750            MS                 <NA>  2020-12-31 00:00:00        09:00:00   \n",
       "5751            RJ                 SBJR  2020-12-31 00:00:00        13:24:00   \n",
       "\n",
       "      total_recomendacoes ocorrencia_uf_bkp  \n",
       "0                      10                RJ  \n",
       "1                      10                20  \n",
       "2                      10                RJ  \n",
       "3                      10                MT  \n",
       "4                      10                RS  \n",
       "...                   ...               ...  \n",
       "5747                   10                SP  \n",
       "5748                   10                TO  \n",
       "5749                   10                RJ  \n",
       "5750                   10                MS  \n",
       "5751                   10                RJ  \n",
       "\n",
       "[5752 rows x 9 columns]"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "c65af65d",
   "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_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",
       "      <th>ocorrencia_uf_bkp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\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 00:00:00</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\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 00:00:00</td>\n",
       "      <td>03:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>39527</td>\n",
       "      <td>ACIDENTE</td>\n",
       "      <td>LUCAS DO RIO VERDE</td>\n",
       "      <td>MT</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>2010-01-04 00:00:00</td>\n",
       "      <td>17:30:00</td>\n",
       "      <td>10</td>\n",
       "      <td>MT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\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 00:00:00</td>\n",
       "      <td>19:25:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RS</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>GRAVE</td>\n",
       "      <td>CAMPINAS</td>\n",
       "      <td>SP</td>\n",
       "      <td>SBKP</td>\n",
       "      <td>2020-12-29 00:00:00</td>\n",
       "      <td>19:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>SP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5748</th>\n",
       "      <td>79757</td>\n",
       "      <td>INCIDENTE GRAVE</td>\n",
       "      <td>LAGOA DA CONFUSÃO</td>\n",
       "      <td>TO</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>2020-12-30 00:00:00</td>\n",
       "      <td>18:30:00</td>\n",
       "      <td>10</td>\n",
       "      <td>TO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5749</th>\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 00:00:00</td>\n",
       "      <td>00:54:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5750</th>\n",
       "      <td>79756</td>\n",
       "      <td>INCIDENTE GRAVE</td>\n",
       "      <td>VICENTINA</td>\n",
       "      <td>MS</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>2020-12-31 00:00:00</td>\n",
       "      <td>09:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>MS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5751</th>\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 00:00:00</td>\n",
       "      <td>13:24:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5751 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     codigo_ocorrencia2 ocorrencia_classificacao   ocorrencia_cidade  \\\n",
       "0                 40211                INCIDENTE      RIO DE JANEIRO   \n",
       "1                    20                       20                  20   \n",
       "2                 40351                INCIDENTE      RIO DE JANEIRO   \n",
       "3                 39527                 ACIDENTE  LUCAS DO RIO VERDE   \n",
       "4                 40324                INCIDENTE             PELOTAS   \n",
       "...                 ...                      ...                 ...   \n",
       "5747              79804                    GRAVE            CAMPINAS   \n",
       "5748              79757          INCIDENTE GRAVE   LAGOA DA CONFUSÃO   \n",
       "5749              79802                INCIDENTE      RIO DE JANEIRO   \n",
       "5750              79756          INCIDENTE GRAVE           VICENTINA   \n",
       "5751              79844                INCIDENTE      RIO DE JANEIRO   \n",
       "\n",
       "     ocorrencia_uf ocorrencia_aerodromo       ocorrencia_dia ocorrencia_hora  \\\n",
       "0               RJ                       2010-01-03 00:00:00        12:00:00   \n",
       "1               20                   20                   20              20   \n",
       "2               RJ                 SBRJ  2010-01-03 00:00:00        03:00:00   \n",
       "3               MT                 <NA>  2010-01-04 00:00:00        17:30:00   \n",
       "4               RS                 SBPK  2010-01-05 00:00:00        19:25:00   \n",
       "...            ...                  ...                  ...             ...   \n",
       "5747            SP                 SBKP  2020-12-29 00:00:00        19:00:00   \n",
       "5748            TO                 <NA>  2020-12-30 00:00:00        18:30:00   \n",
       "5749            RJ                 SBGL  2020-12-30 00:00:00        00:54:00   \n",
       "5750            MS                 <NA>  2020-12-31 00:00:00        09:00:00   \n",
       "5751            RJ                 SBJR  2020-12-31 00:00:00        13:24:00   \n",
       "\n",
       "      total_recomendacoes ocorrencia_uf_bkp  \n",
       "0                      10                RJ  \n",
       "1                      10                20  \n",
       "2                      10                RJ  \n",
       "3                      10                MT  \n",
       "4                      10                RS  \n",
       "...                   ...               ...  \n",
       "5747                   10                SP  \n",
       "5748                   10                TO  \n",
       "5749                   10                RJ  \n",
       "5750                   10                MS  \n",
       "5751                   10                RJ  \n",
       "\n",
       "[5751 rows x 9 columns]"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dropna(subset=['ocorrencia_uf'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "628a15fb",
   "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_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",
       "      <th>ocorrencia_uf_bkp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\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 00:00:00</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\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 00:00:00</td>\n",
       "      <td>03:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>39527</td>\n",
       "      <td>ACIDENTE</td>\n",
       "      <td>LUCAS DO RIO VERDE</td>\n",
       "      <td>MT</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>2010-01-04 00:00:00</td>\n",
       "      <td>17:30:00</td>\n",
       "      <td>10</td>\n",
       "      <td>MT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\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 00:00:00</td>\n",
       "      <td>19:25:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RS</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>GRAVE</td>\n",
       "      <td>CAMPINAS</td>\n",
       "      <td>SP</td>\n",
       "      <td>SBKP</td>\n",
       "      <td>2020-12-29 00:00:00</td>\n",
       "      <td>19:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>SP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5748</th>\n",
       "      <td>79757</td>\n",
       "      <td>INCIDENTE GRAVE</td>\n",
       "      <td>LAGOA DA CONFUSÃO</td>\n",
       "      <td>TO</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>2020-12-30 00:00:00</td>\n",
       "      <td>18:30:00</td>\n",
       "      <td>10</td>\n",
       "      <td>TO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5749</th>\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 00:00:00</td>\n",
       "      <td>00:54:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5750</th>\n",
       "      <td>79756</td>\n",
       "      <td>INCIDENTE GRAVE</td>\n",
       "      <td>VICENTINA</td>\n",
       "      <td>MS</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>2020-12-31 00:00:00</td>\n",
       "      <td>09:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>MS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5751</th>\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 00:00:00</td>\n",
       "      <td>13:24:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5752 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     codigo_ocorrencia2 ocorrencia_classificacao   ocorrencia_cidade  \\\n",
       "0                 40211                INCIDENTE      RIO DE JANEIRO   \n",
       "1                    20                       20                  20   \n",
       "2                 40351                INCIDENTE      RIO DE JANEIRO   \n",
       "3                 39527                 ACIDENTE  LUCAS DO RIO VERDE   \n",
       "4                 40324                INCIDENTE             PELOTAS   \n",
       "...                 ...                      ...                 ...   \n",
       "5747              79804                    GRAVE            CAMPINAS   \n",
       "5748              79757          INCIDENTE GRAVE   LAGOA DA CONFUSÃO   \n",
       "5749              79802                INCIDENTE      RIO DE JANEIRO   \n",
       "5750              79756          INCIDENTE GRAVE           VICENTINA   \n",
       "5751              79844                INCIDENTE      RIO DE JANEIRO   \n",
       "\n",
       "     ocorrencia_uf ocorrencia_aerodromo       ocorrencia_dia ocorrencia_hora  \\\n",
       "0               RJ                       2010-01-03 00:00:00        12:00:00   \n",
       "1               20                   20                   20              20   \n",
       "2               RJ                 SBRJ  2010-01-03 00:00:00        03:00:00   \n",
       "3               MT                 <NA>  2010-01-04 00:00:00        17:30:00   \n",
       "4               RS                 SBPK  2010-01-05 00:00:00        19:25:00   \n",
       "...            ...                  ...                  ...             ...   \n",
       "5747            SP                 SBKP  2020-12-29 00:00:00        19:00:00   \n",
       "5748            TO                 <NA>  2020-12-30 00:00:00        18:30:00   \n",
       "5749            RJ                 SBGL  2020-12-30 00:00:00        00:54:00   \n",
       "5750            MS                 <NA>  2020-12-31 00:00:00        09:00:00   \n",
       "5751            RJ                 SBJR  2020-12-31 00:00:00        13:24:00   \n",
       "\n",
       "      total_recomendacoes ocorrencia_uf_bkp  \n",
       "0                      10                RJ  \n",
       "1                      10                20  \n",
       "2                      10                RJ  \n",
       "3                      10                MT  \n",
       "4                      10                RS  \n",
       "...                   ...               ...  \n",
       "5747                   10                SP  \n",
       "5748                   10                TO  \n",
       "5749                   10                RJ  \n",
       "5750                   10                MS  \n",
       "5751                   10                RJ  \n",
       "\n",
       "[5752 rows x 9 columns]"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "87627a4b",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.drop_duplicates(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "cd600015",
   "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_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",
       "      <th>ocorrencia_uf_bkp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\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 00:00:00</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\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 00:00:00</td>\n",
       "      <td>03:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>39527</td>\n",
       "      <td>ACIDENTE</td>\n",
       "      <td>LUCAS DO RIO VERDE</td>\n",
       "      <td>MT</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>2010-01-04 00:00:00</td>\n",
       "      <td>17:30:00</td>\n",
       "      <td>10</td>\n",
       "      <td>MT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\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 00:00:00</td>\n",
       "      <td>19:25:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RS</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>GRAVE</td>\n",
       "      <td>CAMPINAS</td>\n",
       "      <td>SP</td>\n",
       "      <td>SBKP</td>\n",
       "      <td>2020-12-29 00:00:00</td>\n",
       "      <td>19:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>SP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5748</th>\n",
       "      <td>79757</td>\n",
       "      <td>INCIDENTE GRAVE</td>\n",
       "      <td>LAGOA DA CONFUSÃO</td>\n",
       "      <td>TO</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>2020-12-30 00:00:00</td>\n",
       "      <td>18:30:00</td>\n",
       "      <td>10</td>\n",
       "      <td>TO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5749</th>\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 00:00:00</td>\n",
       "      <td>00:54:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5750</th>\n",
       "      <td>79756</td>\n",
       "      <td>INCIDENTE GRAVE</td>\n",
       "      <td>VICENTINA</td>\n",
       "      <td>MS</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>2020-12-31 00:00:00</td>\n",
       "      <td>09:00:00</td>\n",
       "      <td>10</td>\n",
       "      <td>MS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5751</th>\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 00:00:00</td>\n",
       "      <td>13:24:00</td>\n",
       "      <td>10</td>\n",
       "      <td>RJ</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5752 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     codigo_ocorrencia2 ocorrencia_classificacao   ocorrencia_cidade  \\\n",
       "0                 40211                INCIDENTE      RIO DE JANEIRO   \n",
       "1                    20                       20                  20   \n",
       "2                 40351                INCIDENTE      RIO DE JANEIRO   \n",
       "3                 39527                 ACIDENTE  LUCAS DO RIO VERDE   \n",
       "4                 40324                INCIDENTE             PELOTAS   \n",
       "...                 ...                      ...                 ...   \n",
       "5747              79804                    GRAVE            CAMPINAS   \n",
       "5748              79757          INCIDENTE GRAVE   LAGOA DA CONFUSÃO   \n",
       "5749              79802                INCIDENTE      RIO DE JANEIRO   \n",
       "5750              79756          INCIDENTE GRAVE           VICENTINA   \n",
       "5751              79844                INCIDENTE      RIO DE JANEIRO   \n",
       "\n",
       "     ocorrencia_uf ocorrencia_aerodromo       ocorrencia_dia ocorrencia_hora  \\\n",
       "0               RJ                       2010-01-03 00:00:00        12:00:00   \n",
       "1               20                   20                   20              20   \n",
       "2               RJ                 SBRJ  2010-01-03 00:00:00        03:00:00   \n",
       "3               MT                 <NA>  2010-01-04 00:00:00        17:30:00   \n",
       "4               RS                 SBPK  2010-01-05 00:00:00        19:25:00   \n",
       "...            ...                  ...                  ...             ...   \n",
       "5747            SP                 SBKP  2020-12-29 00:00:00        19:00:00   \n",
       "5748            TO                 <NA>  2020-12-30 00:00:00        18:30:00   \n",
       "5749            RJ                 SBGL  2020-12-30 00:00:00        00:54:00   \n",
       "5750            MS                 <NA>  2020-12-31 00:00:00        09:00:00   \n",
       "5751            RJ                 SBJR  2020-12-31 00:00:00        13:24:00   \n",
       "\n",
       "      total_recomendacoes ocorrencia_uf_bkp  \n",
       "0                      10                RJ  \n",
       "1                      10                20  \n",
       "2                      10                RJ  \n",
       "3                      10                MT  \n",
       "4                      10                RS  \n",
       "...                   ...               ...  \n",
       "5747                   10                SP  \n",
       "5748                   10                TO  \n",
       "5749                   10                RJ  \n",
       "5750                   10                MS  \n",
       "5751                   10                RJ  \n",
       "\n",
       "[5752 rows x 9 columns]"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f7f7a3ee",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}