transformacao.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "transformacao.ipynb",
      "provenance": [],
      "collapsed_sections": [],
      "authorship_tag": "ABX9TyOZ4C9VDAZ/c6qekDzaCytL",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/lucianocoelho-28/dio-curso-etl/blob/main/transformacao.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "F6WVvKvlTK33"
      },
      "source": [
        "# Fundamentos de ETL com Python"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "CylBw-C6Ucym"
      },
      "source": [
        "### Acessar os dados no link do CENIPA\n",
        "link: https://www2.fab.mil.br/cenipa/"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "yvQj_uPyUel3"
      },
      "source": [
        "https://dados.gov.br/dataset/ocorrencias-aeronauticas-da-aviacao-civil-brasileira"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "6dazMBVWXDUt"
      },
      "source": [
        "## 1. Etapa de realização de extração de dados"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "tkhRILx-a5qr",
        "outputId": "258a5e51-6db5-4a68-e60f-bf5b07665bba"
      },
      "source": [
        "#Instalando a biblioteca pandera no Google Colab\n",
        "!pip install pandera"
      ],
      "execution_count": 1,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Requirement already satisfied: pandera in /usr/local/lib/python3.7/dist-packages (0.6.4)\n",
            "Requirement already satisfied: typing-extensions>=3.7.4.3; python_version < \"3.8\" in /usr/local/lib/python3.7/dist-packages (from pandera) (3.7.4.3)\n",
            "Requirement already satisfied: typing-inspect>=0.6.0 in /usr/local/lib/python3.7/dist-packages (from pandera) (0.7.1)\n",
            "Requirement already satisfied: numpy>=1.9.0 in /usr/local/lib/python3.7/dist-packages (from pandera) (1.19.5)\n",
            "Requirement already satisfied: wrapt in /usr/local/lib/python3.7/dist-packages (from pandera) (1.12.1)\n",
            "Requirement already satisfied: packaging>=20.0 in /usr/local/lib/python3.7/dist-packages (from pandera) (20.9)\n",
            "Requirement already satisfied: pandas>=0.25.3 in /usr/local/lib/python3.7/dist-packages (from pandera) (1.1.5)\n",
            "Requirement already satisfied: mypy-extensions>=0.3.0 in /usr/local/lib/python3.7/dist-packages (from typing-inspect>=0.6.0->pandera) (0.4.3)\n",
            "Requirement already satisfied: pyparsing>=2.0.2 in /usr/local/lib/python3.7/dist-packages (from packaging>=20.0->pandera) (2.4.7)\n",
            "Requirement already satisfied: pytz>=2017.2 in /usr/local/lib/python3.7/dist-packages (from pandas>=0.25.3->pandera) (2018.9)\n",
            "Requirement already satisfied: python-dateutil>=2.7.3 in /usr/local/lib/python3.7/dist-packages (from pandas>=0.25.3->pandera) (2.8.1)\n",
            "Requirement already satisfied: six>=1.5 in /usr/local/lib/python3.7/dist-packages (from python-dateutil>=2.7.3->pandas>=0.25.3->pandera) (1.15.0)\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "RW2KnPUqSz9F"
      },
      "source": [
        "#Importando as bibliotecas\n",
        "import pandas as pd\n",
        "import pandera as pa"
      ],
      "execution_count": 2,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 396
        },
        "id": "UpRuxz7ETTco",
        "outputId": "a6defa7b-a56f-4fde-99df-4baca45fd7b3"
      },
      "source": [
        "#Criando nosso DataFrame\n",
        "df = pd.read_csv(\"/content/ocorrencia_2010_2020.csv\", sep=\";\", parse_dates=['ocorrencia_dia'], dayfirst=True)\n",
        "df.head(10)"
      ],
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>codigo_ocorrencia</th>\n",
              "      <th>codigo_ocorrencia2</th>\n",
              "      <th>ocorrencia_classificacao</th>\n",
              "      <th>ocorrencia_cidade</th>\n",
              "      <th>ocorrencia_uf</th>\n",
              "      <th>ocorrencia_aerodromo</th>\n",
              "      <th>ocorrencia_dia</th>\n",
              "      <th>ocorrencia_hora</th>\n",
              "      <th>total_recomendacoes</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>40211</td>\n",
              "      <td>40211</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>RJ</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-03</td>\n",
              "      <td>12:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>40349</td>\n",
              "      <td>40349</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>BELÉM</td>\n",
              "      <td>PA</td>\n",
              "      <td>SBBE</td>\n",
              "      <td>2010-01-03</td>\n",
              "      <td>11:05:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>40351</td>\n",
              "      <td>40351</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>RJ</td>\n",
              "      <td>SBRJ</td>\n",
              "      <td>2010-01-03</td>\n",
              "      <td>03:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>39527</td>\n",
              "      <td>39527</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>LUCAS DO RIO VERDE</td>\n",
              "      <td>MT</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-04</td>\n",
              "      <td>17:30:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>40324</td>\n",
              "      <td>40324</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>PELOTAS</td>\n",
              "      <td>RS</td>\n",
              "      <td>SBPK</td>\n",
              "      <td>2010-01-05</td>\n",
              "      <td>19:25:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>39807</td>\n",
              "      <td>39807</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>SALVADOR</td>\n",
              "      <td>BA</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-06</td>\n",
              "      <td>17:53:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>40215</td>\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</td>\n",
              "      <td>18:40:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>39707</td>\n",
              "      <td>39707</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>CANUTAMA</td>\n",
              "      <td>AM</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-09</td>\n",
              "      <td>12:30:00</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>39156</td>\n",
              "      <td>39156</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>CASCAVEL</td>\n",
              "      <td>PR</td>\n",
              "      <td>SBCA</td>\n",
              "      <td>2010-01-10</td>\n",
              "      <td>23:15:00</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>39711</td>\n",
              "      <td>39711</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>PARÁ DE MINAS</td>\n",
              "      <td>MG</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-10</td>\n",
              "      <td>20:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   codigo_ocorrencia  codigo_ocorrencia2  ... ocorrencia_hora total_recomendacoes\n",
              "0              40211               40211  ...        12:00:00                   0\n",
              "1              40349               40349  ...        11:05:00                   0\n",
              "2              40351               40351  ...        03:00:00                   0\n",
              "3              39527               39527  ...        17:30:00                   0\n",
              "4              40324               40324  ...        19:25:00                   0\n",
              "5              39807               39807  ...        17:53:00                   0\n",
              "6              40215               40215  ...        18:40:00                   0\n",
              "7              39707               39707  ...        12:30:00                   3\n",
              "8              39156               39156  ...        23:15:00                   2\n",
              "9              39711               39711  ...        20:00:00                   0\n",
              "\n",
              "[10 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 3
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "ZtAylek4XUrn"
      },
      "source": [
        "## 2. Etapa de validação de dados"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "C4Y4AalVXgcd"
      },
      "source": [
        "schema = pa.DataFrameSchema(\n",
        "    columns = {\n",
        "        \"codigo\":pa.Column(pa.Int, required=False),\n",
        "        \"codigo_ocorrencia\":pa.Column(pa.Int),\n",
        "        \"codigo_ocorrencia2\":pa.Column(pa.Int),\n",
        "        \"ocorrencia_classificacao\":pa.Column(pa.String),\n",
        "        \"ocorrencia_cidade\":pa.Column(pa.String),\n",
        "        \"ocorrencia_uf\":pa.Column(pa.String, pa.Check.str_length(2,3)),\n",
        "        \"ocorrencia_aerodromo\":pa.Column(pa.String),\n",
        "        \"ocorrencia_dia\":pa.Column(pa.DateTime),\n",
        "        \"ocorrencia_hora\": pa.Column(pa.String, pa.Check.str_matches(r'^([0-1]?[0-9]|[2][0-3]):([0-5][0-9])(:[0-5][0-9])?$'), nullable=True),\n",
        "        \"total_recomendacoes\":pa.Column(pa.Int)\n",
        "    }\n",
        ")"
      ],
      "execution_count": 4,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 473
        },
        "id": "FUjxwuKkcxIr",
        "outputId": "759b4e62-e146-4ea0-e203-9d95d22c2f35"
      },
      "source": [
        "schema.validate(df) "
      ],
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>codigo_ocorrencia</th>\n",
              "      <th>codigo_ocorrencia2</th>\n",
              "      <th>ocorrencia_classificacao</th>\n",
              "      <th>ocorrencia_cidade</th>\n",
              "      <th>ocorrencia_uf</th>\n",
              "      <th>ocorrencia_aerodromo</th>\n",
              "      <th>ocorrencia_dia</th>\n",
              "      <th>ocorrencia_hora</th>\n",
              "      <th>total_recomendacoes</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>40211</td>\n",
              "      <td>40211</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>RJ</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-03</td>\n",
              "      <td>12:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>40349</td>\n",
              "      <td>40349</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>BELÉM</td>\n",
              "      <td>PA</td>\n",
              "      <td>SBBE</td>\n",
              "      <td>2010-01-03</td>\n",
              "      <td>11:05:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>40351</td>\n",
              "      <td>40351</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>RJ</td>\n",
              "      <td>SBRJ</td>\n",
              "      <td>2010-01-03</td>\n",
              "      <td>03:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>39527</td>\n",
              "      <td>39527</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>LUCAS DO RIO VERDE</td>\n",
              "      <td>MT</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-04</td>\n",
              "      <td>17:30:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>40324</td>\n",
              "      <td>40324</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>PELOTAS</td>\n",
              "      <td>RS</td>\n",
              "      <td>SBPK</td>\n",
              "      <td>2010-01-05</td>\n",
              "      <td>19:25:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5747</th>\n",
              "      <td>79804</td>\n",
              "      <td>79804</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>CAMPINAS</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBKP</td>\n",
              "      <td>2020-12-29</td>\n",
              "      <td>19:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5748</th>\n",
              "      <td>79757</td>\n",
              "      <td>79757</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>LAGOA DA CONFUSÃO</td>\n",
              "      <td>TO</td>\n",
              "      <td>****</td>\n",
              "      <td>2020-12-30</td>\n",
              "      <td>18:30:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5749</th>\n",
              "      <td>79802</td>\n",
              "      <td>79802</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>RJ</td>\n",
              "      <td>SBGL</td>\n",
              "      <td>2020-12-30</td>\n",
              "      <td>00:54:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5750</th>\n",
              "      <td>79756</td>\n",
              "      <td>79756</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>VICENTINA</td>\n",
              "      <td>MS</td>\n",
              "      <td>****</td>\n",
              "      <td>2020-12-31</td>\n",
              "      <td>09:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5751</th>\n",
              "      <td>79844</td>\n",
              "      <td>79844</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>RJ</td>\n",
              "      <td>SBJR</td>\n",
              "      <td>2020-12-31</td>\n",
              "      <td>13:24:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5752 rows × 9 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "      codigo_ocorrencia  ...  total_recomendacoes\n",
              "0                 40211  ...                    0\n",
              "1                 40349  ...                    0\n",
              "2                 40351  ...                    0\n",
              "3                 39527  ...                    0\n",
              "4                 40324  ...                    0\n",
              "...                 ...  ...                  ...\n",
              "5747              79804  ...                    0\n",
              "5748              79757  ...                    0\n",
              "5749              79802  ...                    0\n",
              "5750              79756  ...                    0\n",
              "5751              79844  ...                    0\n",
              "\n",
              "[5752 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "OXzlF5pITHEx",
        "outputId": "660a1c92-9956-43a0-c3d5-5ea50e3297c5"
      },
      "source": [
        "#Visualizar o tipo de dados das colunas\n",
        "df.dtypes"
      ],
      "execution_count": 6,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "codigo_ocorrencia                    int64\n",
              "codigo_ocorrencia2                   int64\n",
              "ocorrencia_classificacao            object\n",
              "ocorrencia_cidade                   object\n",
              "ocorrencia_uf                       object\n",
              "ocorrencia_aerodromo                object\n",
              "ocorrencia_dia              datetime64[ns]\n",
              "ocorrencia_hora                     object\n",
              "total_recomendacoes                  int64\n",
              "dtype: object"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "OBGUfaEPiSTb"
      },
      "source": [
        "## 3. Etapa de transformação de dados"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "1ERa5LtObpFk",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "98f6d5c1-f298-4332-9cfe-765e31297801"
      },
      "source": [
        "df.loc[1]"
      ],
      "execution_count": 7,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "codigo_ocorrencia                         40349\n",
              "codigo_ocorrencia2                        40349\n",
              "ocorrencia_classificacao              INCIDENTE\n",
              "ocorrencia_cidade                         BELÉM\n",
              "ocorrencia_uf                                PA\n",
              "ocorrencia_aerodromo                       SBBE\n",
              "ocorrencia_dia              2010-01-03 00:00:00\n",
              "ocorrencia_hora                        11:05:00\n",
              "total_recomendacoes                           0\n",
              "Name: 1, dtype: object"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "JjqBjvp7brZU",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "f421a4b0-c9ba-4f06-e240-ba54895db12b"
      },
      "source": [
        "df.iloc[1]"
      ],
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "codigo_ocorrencia                         40349\n",
              "codigo_ocorrencia2                        40349\n",
              "ocorrencia_classificacao              INCIDENTE\n",
              "ocorrencia_cidade                         BELÉM\n",
              "ocorrencia_uf                                PA\n",
              "ocorrencia_aerodromo                       SBBE\n",
              "ocorrencia_dia              2010-01-03 00:00:00\n",
              "ocorrencia_hora                        11:05:00\n",
              "total_recomendacoes                           0\n",
              "Name: 1, dtype: object"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "MlIhfjivbuAx",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "254f9df5-f0a5-45c9-9660-dec2a2db58d4"
      },
      "source": [
        "df.iloc[-1]"
      ],
      "execution_count": 9,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "codigo_ocorrencia                         79844\n",
              "codigo_ocorrencia2                        79844\n",
              "ocorrencia_classificacao              INCIDENTE\n",
              "ocorrencia_cidade                RIO DE JANEIRO\n",
              "ocorrencia_uf                                RJ\n",
              "ocorrencia_aerodromo                       SBJR\n",
              "ocorrencia_dia              2020-12-31 00:00:00\n",
              "ocorrencia_hora                        13:24:00\n",
              "total_recomendacoes                           0\n",
              "Name: 5751, dtype: object"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ncO-5nPabwQ5",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 241
        },
        "outputId": "5e752200-301a-4b6e-a7a3-c4b119be67b5"
      },
      "source": [
        "df.tail()"
      ],
      "execution_count": 10,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>5747</th>\n",
              "      <td>79804</td>\n",
              "      <td>79804</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>CAMPINAS</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBKP</td>\n",
              "      <td>2020-12-29</td>\n",
              "      <td>19:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5748</th>\n",
              "      <td>79757</td>\n",
              "      <td>79757</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>LAGOA DA CONFUSÃO</td>\n",
              "      <td>TO</td>\n",
              "      <td>****</td>\n",
              "      <td>2020-12-30</td>\n",
              "      <td>18:30:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5749</th>\n",
              "      <td>79802</td>\n",
              "      <td>79802</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>RJ</td>\n",
              "      <td>SBGL</td>\n",
              "      <td>2020-12-30</td>\n",
              "      <td>00:54:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5750</th>\n",
              "      <td>79756</td>\n",
              "      <td>79756</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>VICENTINA</td>\n",
              "      <td>MS</td>\n",
              "      <td>****</td>\n",
              "      <td>2020-12-31</td>\n",
              "      <td>09:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5751</th>\n",
              "      <td>79844</td>\n",
              "      <td>79844</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>RJ</td>\n",
              "      <td>SBJR</td>\n",
              "      <td>2020-12-31</td>\n",
              "      <td>13:24:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      codigo_ocorrencia  ...  total_recomendacoes\n",
              "5747              79804  ...                    0\n",
              "5748              79757  ...                    0\n",
              "5749              79802  ...                    0\n",
              "5750              79756  ...                    0\n",
              "5751              79844  ...                    0\n",
              "\n",
              "[5 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "rml-cxagbyuU",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 241
        },
        "outputId": "6c52c7c8-42c6-4456-d178-eb34fd9dc8f3"
      },
      "source": [
        "df.iloc[10:15]"
      ],
      "execution_count": 11,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>11</th>\n",
              "      <td>40069</td>\n",
              "      <td>40069</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBMT</td>\n",
              "      <td>2010-01-10</td>\n",
              "      <td>14:50:00</td>\n",
              "      <td>8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>40414</td>\n",
              "      <td>40414</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>BRASÍLIA</td>\n",
              "      <td>DF</td>\n",
              "      <td>SBBR</td>\n",
              "      <td>2010-01-10</td>\n",
              "      <td>03:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>39507</td>\n",
              "      <td>39507</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>PRIMAVERA DO LESTE</td>\n",
              "      <td>MT</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-11</td>\n",
              "      <td>17:00:00</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>40107</td>\n",
              "      <td>40107</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>GURUPÁ</td>\n",
              "      <td>PA</td>\n",
              "      <td>SNGU</td>\n",
              "      <td>2010-01-12</td>\n",
              "      <td>14:30:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "    codigo_ocorrencia  codigo_ocorrencia2  ... ocorrencia_hora total_recomendacoes\n",
              "10              39789               39789  ...        21:30:00                   0\n",
              "11              40069               40069  ...        14:50:00                   8\n",
              "12              40414               40414  ...        03:00:00                   0\n",
              "13              39507               39507  ...        17:00:00                   2\n",
              "14              40107               40107  ...        14:30:00                   0\n",
              "\n",
              "[5 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "TsWRIC3Sb1iv",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 272
        },
        "outputId": "3f8d8452-d53d-4d83-edb6-828689df3981"
      },
      "source": [
        "df.loc[10:15]"
      ],
      "execution_count": 12,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>11</th>\n",
              "      <td>40069</td>\n",
              "      <td>40069</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBMT</td>\n",
              "      <td>2010-01-10</td>\n",
              "      <td>14:50:00</td>\n",
              "      <td>8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>40414</td>\n",
              "      <td>40414</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>BRASÍLIA</td>\n",
              "      <td>DF</td>\n",
              "      <td>SBBR</td>\n",
              "      <td>2010-01-10</td>\n",
              "      <td>03:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>39507</td>\n",
              "      <td>39507</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>PRIMAVERA DO LESTE</td>\n",
              "      <td>MT</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-11</td>\n",
              "      <td>17:00:00</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>40107</td>\n",
              "      <td>40107</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>GURUPÁ</td>\n",
              "      <td>PA</td>\n",
              "      <td>SNGU</td>\n",
              "      <td>2010-01-12</td>\n",
              "      <td>14:30:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>39315</td>\n",
              "      <td>39315</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>CANUTAMA</td>\n",
              "      <td>AM</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-15</td>\n",
              "      <td>21:22:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "    codigo_ocorrencia  codigo_ocorrencia2  ... ocorrencia_hora total_recomendacoes\n",
              "10              39789               39789  ...        21:30:00                   0\n",
              "11              40069               40069  ...        14:50:00                   8\n",
              "12              40414               40414  ...        03:00:00                   0\n",
              "13              39507               39507  ...        17:00:00                   2\n",
              "14              40107               40107  ...        14:30:00                   0\n",
              "15              39315               39315  ...        21:22:00                   0\n",
              "\n",
              "[6 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 12
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ahfK783bb3oa",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "5ae03d99-970a-40cf-b564-dd6b05734c4e"
      },
      "source": [
        "df.loc[:,'ocorrencia_uf']"
      ],
      "execution_count": 13,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "0       RJ\n",
              "1       PA\n",
              "2       RJ\n",
              "3       MT\n",
              "4       RS\n",
              "        ..\n",
              "5747    SP\n",
              "5748    TO\n",
              "5749    RJ\n",
              "5750    MS\n",
              "5751    RJ\n",
              "Name: ocorrencia_uf, Length: 5752, dtype: object"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "HAH39yzjb58i",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "35f95246-b1cf-44dd-a355-84c05454e85c"
      },
      "source": [
        "df['ocorrencia_uf']"
      ],
      "execution_count": 14,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "0       RJ\n",
              "1       PA\n",
              "2       RJ\n",
              "3       MT\n",
              "4       RS\n",
              "        ..\n",
              "5747    SP\n",
              "5748    TO\n",
              "5749    RJ\n",
              "5750    MS\n",
              "5751    RJ\n",
              "Name: ocorrencia_uf, Length: 5752, dtype: object"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 14
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "zaMuUl0Fb8BJ",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "50971c70-5fdb-4492-da79-48a96ab0a453"
      },
      "source": [
        "df.isna().sum()"
      ],
      "execution_count": 15,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "codigo_ocorrencia           0\n",
              "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             1\n",
              "total_recomendacoes         0\n",
              "dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 15
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "C9rKgSZBb9-d",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "e05bd100-289c-4d51-b6e0-56e4fecd850d"
      },
      "source": [
        "df.isnull().sum()"
      ],
      "execution_count": 16,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "codigo_ocorrencia           0\n",
              "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             1\n",
              "total_recomendacoes         0\n",
              "dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 16
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "637pIK05b_9I",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 69
        },
        "outputId": "e7507c42-b0de-4ade-9fd5-a2cdd4252e3d"
      },
      "source": [
        "filtro = df.ocorrencia_uf.isnull()\n",
        "df.loc[filtro]"
      ],
      "execution_count": 17,
      "outputs": [
        {
          "output_type": "execute_result",
          "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",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "Empty DataFrame\n",
              "Columns: [codigo_ocorrencia, codigo_ocorrencia2, ocorrencia_classificacao, ocorrencia_cidade, ocorrencia_uf, ocorrencia_aerodromo, ocorrencia_dia, ocorrencia_hora, total_recomendacoes]\n",
              "Index: []"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 17
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "5tDg4mE3cDD6",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 69
        },
        "outputId": "595184f8-c6b3-4df3-b577-b63091b9fdd2"
      },
      "source": [
        "filtro = df.ocorrencia_aerodromo.isnull()\n",
        "df.loc[filtro]"
      ],
      "execution_count": 18,
      "outputs": [
        {
          "output_type": "execute_result",
          "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",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "Empty DataFrame\n",
              "Columns: [codigo_ocorrencia, codigo_ocorrencia2, ocorrencia_classificacao, ocorrencia_cidade, ocorrencia_uf, ocorrencia_aerodromo, ocorrencia_dia, ocorrencia_hora, total_recomendacoes]\n",
              "Index: []"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 18
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "wQAuFUTQcFe2",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 100
        },
        "outputId": "40c91e61-fcf3-49ee-9b33-bf0f291c697b"
      },
      "source": [
        "filtro = df.ocorrencia_hora.isnull()\n",
        "df.loc[filtro]"
      ],
      "execution_count": 19,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>4100</th>\n",
              "      <td>78823</td>\n",
              "      <td>78823</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>CORUMBÁ</td>\n",
              "      <td>MS</td>\n",
              "      <td>*****</td>\n",
              "      <td>2017-07-09</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      codigo_ocorrencia  ...  total_recomendacoes\n",
              "4100              78823  ...                    0\n",
              "\n",
              "[1 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 19
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "B4XH3XevcH3C",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "e9f44614-0f06-47ba-ccb3-791b8fad148c"
      },
      "source": [
        "df.count()"
      ],
      "execution_count": 20,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "codigo_ocorrencia           5752\n",
              "codigo_ocorrencia2          5752\n",
              "ocorrencia_classificacao    5752\n",
              "ocorrencia_cidade           5752\n",
              "ocorrencia_uf               5752\n",
              "ocorrencia_aerodromo        5752\n",
              "ocorrencia_dia              5752\n",
              "ocorrencia_hora             5751\n",
              "total_recomendacoes         5752\n",
              "dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 20
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "dHInGm2xcJw3",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 396
        },
        "outputId": "04a25de3-b13a-4d70-a608-0f5ed86392a3"
      },
      "source": [
        "#ocorrências com mais de 10 recomendações\n",
        "filtro = df.total_recomendacoes > 10\n",
        "df.loc[filtro]"
      ],
      "execution_count": 21,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>63</th>\n",
              "      <td>39992</td>\n",
              "      <td>39992</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBMT</td>\n",
              "      <td>2010-02-17</td>\n",
              "      <td>20:07:00</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>326</th>\n",
              "      <td>42250</td>\n",
              "      <td>42250</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>RJ</td>\n",
              "      <td>SBRJ</td>\n",
              "      <td>2010-08-12</td>\n",
              "      <td>12:26:00</td>\n",
              "      <td>19</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>530</th>\n",
              "      <td>43471</td>\n",
              "      <td>43471</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>SP</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-12-14</td>\n",
              "      <td>20:15:00</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>727</th>\n",
              "      <td>44377</td>\n",
              "      <td>44377</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>ITÁPOLIS</td>\n",
              "      <td>SP</td>\n",
              "      <td>SDIO</td>\n",
              "      <td>2011-04-09</td>\n",
              "      <td>14:50:00</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>872</th>\n",
              "      <td>44796</td>\n",
              "      <td>44796</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>RECIFE</td>\n",
              "      <td>PE</td>\n",
              "      <td>SBRF</td>\n",
              "      <td>2011-07-13</td>\n",
              "      <td>09:54:00</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>884</th>\n",
              "      <td>44888</td>\n",
              "      <td>44888</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>SÃO JOSÉ DOS PINHAIS</td>\n",
              "      <td>PR</td>\n",
              "      <td>SBCT</td>\n",
              "      <td>2011-07-15</td>\n",
              "      <td>17:05:00</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1062</th>\n",
              "      <td>45554</td>\n",
              "      <td>45554</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>UBERLÂNDIA</td>\n",
              "      <td>MG</td>\n",
              "      <td>SBUL</td>\n",
              "      <td>2011-11-15</td>\n",
              "      <td>02:15:00</td>\n",
              "      <td>20</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1972</th>\n",
              "      <td>47938</td>\n",
              "      <td>47938</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>BRASÍLIA</td>\n",
              "      <td>DF</td>\n",
              "      <td>SBBR</td>\n",
              "      <td>2013-04-13</td>\n",
              "      <td>18:00:00</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2795</th>\n",
              "      <td>52265</td>\n",
              "      <td>52265</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>SANTOS</td>\n",
              "      <td>SP</td>\n",
              "      <td>****</td>\n",
              "      <td>2014-08-13</td>\n",
              "      <td>13:03:00</td>\n",
              "      <td>13</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3930</th>\n",
              "      <td>66432</td>\n",
              "      <td>66432</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>VITÓRIA</td>\n",
              "      <td>ES</td>\n",
              "      <td>****</td>\n",
              "      <td>2017-02-21</td>\n",
              "      <td>11:47:00</td>\n",
              "      <td>12</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      codigo_ocorrencia  ...  total_recomendacoes\n",
              "63                39992  ...                   11\n",
              "326               42250  ...                   19\n",
              "530               43471  ...                   11\n",
              "727               44377  ...                   11\n",
              "872               44796  ...                   23\n",
              "884               44888  ...                   11\n",
              "1062              45554  ...                   20\n",
              "1972              47938  ...                   11\n",
              "2795              52265  ...                   13\n",
              "3930              66432  ...                   12\n",
              "\n",
              "[10 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 21
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "jX4ULqTxcMKK",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 359
        },
        "outputId": "c2b3f30a-ce26-43c9-cf75-d93eec00f295"
      },
      "source": [
        "#ocorrências com mais de 10 recomendações\n",
        "filtro = df.total_recomendacoes > 10\n",
        "df.loc[filtro, ['ocorrencia_cidade', 'total_recomendacoes']]"
      ],
      "execution_count": 22,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>ocorrencia_cidade</th>\n",
              "      <th>total_recomendacoes</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>63</th>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>326</th>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>19</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>530</th>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>727</th>\n",
              "      <td>ITÁPOLIS</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>872</th>\n",
              "      <td>RECIFE</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>884</th>\n",
              "      <td>SÃO JOSÉ DOS PINHAIS</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1062</th>\n",
              "      <td>UBERLÂNDIA</td>\n",
              "      <td>20</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1972</th>\n",
              "      <td>BRASÍLIA</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2795</th>\n",
              "      <td>SANTOS</td>\n",
              "      <td>13</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3930</th>\n",
              "      <td>VITÓRIA</td>\n",
              "      <td>12</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "         ocorrencia_cidade  total_recomendacoes\n",
              "63               SÃO PAULO                   11\n",
              "326         RIO DE JANEIRO                   19\n",
              "530              SÃO PAULO                   11\n",
              "727               ITÁPOLIS                   11\n",
              "872                 RECIFE                   23\n",
              "884   SÃO JOSÉ DOS PINHAIS                   11\n",
              "1062            UBERLÂNDIA                   20\n",
              "1972              BRASÍLIA                   11\n",
              "2795                SANTOS                   13\n",
              "3930               VITÓRIA                   12"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 22
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "AA6saB0tcPPV",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 456
        },
        "outputId": "0484a340-159e-4003-9951-8c9a7e00841f"
      },
      "source": [
        "#ocorrências cuja classificação == INCIDENTE GRAVE\t\n",
        "filtro = df.ocorrencia_classificacao == 'INCIDENTE GRAVE'\n",
        "df.loc[filtro]"
      ],
      "execution_count": 23,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>7</th>\n",
              "      <td>39707</td>\n",
              "      <td>39707</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>CANUTAMA</td>\n",
              "      <td>AM</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-09</td>\n",
              "      <td>12:30:00</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>39156</td>\n",
              "      <td>39156</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>CASCAVEL</td>\n",
              "      <td>PR</td>\n",
              "      <td>SBCA</td>\n",
              "      <td>2010-01-10</td>\n",
              "      <td>23:15:00</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>39711</td>\n",
              "      <td>39711</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>PARÁ DE MINAS</td>\n",
              "      <td>MG</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-10</td>\n",
              "      <td>20:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>39709</td>\n",
              "      <td>39709</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>CURITIBA</td>\n",
              "      <td>PR</td>\n",
              "      <td>SBBI</td>\n",
              "      <td>2010-01-23</td>\n",
              "      <td>16:36:00</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>39487</td>\n",
              "      <td>39487</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>PALMAS</td>\n",
              "      <td>TO</td>\n",
              "      <td>SBPJ</td>\n",
              "      <td>2010-01-26</td>\n",
              "      <td>16:50:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5741</th>\n",
              "      <td>79754</td>\n",
              "      <td>79754</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>NOVA MARINGÁ</td>\n",
              "      <td>MT</td>\n",
              "      <td>****</td>\n",
              "      <td>2020-12-28</td>\n",
              "      <td>13:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5744</th>\n",
              "      <td>79753</td>\n",
              "      <td>79753</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>GOIATUBA</td>\n",
              "      <td>GO</td>\n",
              "      <td>****</td>\n",
              "      <td>2020-12-29</td>\n",
              "      <td>12:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5746</th>\n",
              "      <td>79769</td>\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</td>\n",
              "      <td>18:30:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5748</th>\n",
              "      <td>79757</td>\n",
              "      <td>79757</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>LAGOA DA CONFUSÃO</td>\n",
              "      <td>TO</td>\n",
              "      <td>****</td>\n",
              "      <td>2020-12-30</td>\n",
              "      <td>18:30:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5750</th>\n",
              "      <td>79756</td>\n",
              "      <td>79756</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>VICENTINA</td>\n",
              "      <td>MS</td>\n",
              "      <td>****</td>\n",
              "      <td>2020-12-31</td>\n",
              "      <td>09:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>737 rows × 9 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "      codigo_ocorrencia  ...  total_recomendacoes\n",
              "7                 39707  ...                    3\n",
              "8                 39156  ...                    2\n",
              "9                 39711  ...                    0\n",
              "29                39709  ...                    2\n",
              "35                39487  ...                    0\n",
              "...                 ...  ...                  ...\n",
              "5741              79754  ...                    0\n",
              "5744              79753  ...                    0\n",
              "5746              79769  ...                    0\n",
              "5748              79757  ...                    0\n",
              "5750              79756  ...                    0\n",
              "\n",
              "[737 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 23
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "3waOcs8VcR17",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 456
        },
        "outputId": "61b7a4c4-3e54-457a-931e-884853fbd1d6"
      },
      "source": [
        "#ocorrências cuja classificação == INCIDENTE GRAVE e o estado == SP\n",
        "filtro1 = df.ocorrencia_classificacao == 'INCIDENTE GRAVE'\n",
        "filtro2 = df.ocorrencia_uf == 'SP'\n",
        "df.loc[filtro1 & filtro2]"
      ],
      "execution_count": 24,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>136</th>\n",
              "      <td>40270</td>\n",
              "      <td>40270</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>PIRASSUNUNGA</td>\n",
              "      <td>SP</td>\n",
              "      <td>SDPY</td>\n",
              "      <td>2010-04-15</td>\n",
              "      <td>20:15:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>171</th>\n",
              "      <td>40620</td>\n",
              "      <td>40620</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>GUARULHOS</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBGR</td>\n",
              "      <td>2010-05-06</td>\n",
              "      <td>15:50:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>219</th>\n",
              "      <td>41411</td>\n",
              "      <td>41411</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBMT</td>\n",
              "      <td>2010-06-08</td>\n",
              "      <td>19:30:00</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>297</th>\n",
              "      <td>42289</td>\n",
              "      <td>42289</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBMT</td>\n",
              "      <td>2010-07-29</td>\n",
              "      <td>20:06:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>314</th>\n",
              "      <td>42323</td>\n",
              "      <td>42323</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>SÃO JOSÉ DO RIO PRETO</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBSR</td>\n",
              "      <td>2010-08-05</td>\n",
              "      <td>12:01:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5591</th>\n",
              "      <td>79540</td>\n",
              "      <td>79540</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>SP</td>\n",
              "      <td>****</td>\n",
              "      <td>2020-09-12</td>\n",
              "      <td>13:10:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5610</th>\n",
              "      <td>79566</td>\n",
              "      <td>79566</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>REGENTE FEIJÓ</td>\n",
              "      <td>SP</td>\n",
              "      <td>SDYJ</td>\n",
              "      <td>2020-09-27</td>\n",
              "      <td>19:33:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5704</th>\n",
              "      <td>79739</td>\n",
              "      <td>79739</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBSP</td>\n",
              "      <td>2020-12-03</td>\n",
              "      <td>14:42:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5705</th>\n",
              "      <td>79705</td>\n",
              "      <td>79705</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>SOROCABA</td>\n",
              "      <td>SP</td>\n",
              "      <td>SDCO</td>\n",
              "      <td>2020-12-04</td>\n",
              "      <td>15:30:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5715</th>\n",
              "      <td>79718</td>\n",
              "      <td>79718</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBMT</td>\n",
              "      <td>2020-12-11</td>\n",
              "      <td>13:50:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>137 rows × 9 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "      codigo_ocorrencia  ...  total_recomendacoes\n",
              "136               40270  ...                    0\n",
              "171               40620  ...                    0\n",
              "219               41411  ...                    2\n",
              "297               42289  ...                    0\n",
              "314               42323  ...                    0\n",
              "...                 ...  ...                  ...\n",
              "5591              79540  ...                    0\n",
              "5610              79566  ...                    0\n",
              "5704              79739  ...                    0\n",
              "5705              79705  ...                    0\n",
              "5715              79718  ...                    0\n",
              "\n",
              "[137 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 24
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "cOWgnc-dcUYU",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 456
        },
        "outputId": "509ce5a1-3dad-4892-84c2-13823ea485fb"
      },
      "source": [
        "#ocorrências cuja classificação == INCIDENTE GRAVE ou o estado == SP\n",
        "filtro1 = df.ocorrencia_classificacao == 'INCIDENTE GRAVE'\n",
        "filtro2 = df.ocorrencia_uf == 'SP'\n",
        "df.loc[filtro1 | filtro2]"
      ],
      "execution_count": 25,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>7</th>\n",
              "      <td>39707</td>\n",
              "      <td>39707</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>CANUTAMA</td>\n",
              "      <td>AM</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-09</td>\n",
              "      <td>12:30:00</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>39156</td>\n",
              "      <td>39156</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>CASCAVEL</td>\n",
              "      <td>PR</td>\n",
              "      <td>SBCA</td>\n",
              "      <td>2010-01-10</td>\n",
              "      <td>23:15:00</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>39711</td>\n",
              "      <td>39711</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>PARÁ DE MINAS</td>\n",
              "      <td>MG</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-10</td>\n",
              "      <td>20:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>40069</td>\n",
              "      <td>40069</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBMT</td>\n",
              "      <td>2010-01-10</td>\n",
              "      <td>14:50:00</td>\n",
              "      <td>8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>39809</td>\n",
              "      <td>39809</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>SP</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-15</td>\n",
              "      <td>15:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5744</th>\n",
              "      <td>79753</td>\n",
              "      <td>79753</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>GOIATUBA</td>\n",
              "      <td>GO</td>\n",
              "      <td>****</td>\n",
              "      <td>2020-12-29</td>\n",
              "      <td>12:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5746</th>\n",
              "      <td>79769</td>\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</td>\n",
              "      <td>18:30:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5747</th>\n",
              "      <td>79804</td>\n",
              "      <td>79804</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>CAMPINAS</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBKP</td>\n",
              "      <td>2020-12-29</td>\n",
              "      <td>19:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5748</th>\n",
              "      <td>79757</td>\n",
              "      <td>79757</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>LAGOA DA CONFUSÃO</td>\n",
              "      <td>TO</td>\n",
              "      <td>****</td>\n",
              "      <td>2020-12-30</td>\n",
              "      <td>18:30:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5750</th>\n",
              "      <td>79756</td>\n",
              "      <td>79756</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>VICENTINA</td>\n",
              "      <td>MS</td>\n",
              "      <td>****</td>\n",
              "      <td>2020-12-31</td>\n",
              "      <td>09:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1973 rows × 9 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "      codigo_ocorrencia  ...  total_recomendacoes\n",
              "7                 39707  ...                    3\n",
              "8                 39156  ...                    2\n",
              "9                 39711  ...                    0\n",
              "11                40069  ...                    8\n",
              "16                39809  ...                    0\n",
              "...                 ...  ...                  ...\n",
              "5744              79753  ...                    0\n",
              "5746              79769  ...                    0\n",
              "5747              79804  ...                    0\n",
              "5748              79757  ...                    0\n",
              "5750              79756  ...                    0\n",
              "\n",
              "[1973 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 25
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "QK9jy7umcW5O",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 439
        },
        "outputId": "f07bded3-f72f-48ad-8d21-38e6fc68de67"
      },
      "source": [
        "#ocorrências cuja (classificação == INCIDENTE GRAVE ou classificação == INCIDENTE) e o estado == SP\n",
        "filtro1 = df.ocorrencia_classificacao.isin(['INCIDENTE GRAVE', 'INCIDENTE'])\n",
        "filtro2 = df.ocorrencia_uf == 'SP'\n",
        "df.loc[filtro1 & filtro2]"
      ],
      "execution_count": 26,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>16</th>\n",
              "      <td>39809</td>\n",
              "      <td>39809</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>SP</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-15</td>\n",
              "      <td>15:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>39828</td>\n",
              "      <td>39828</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>SANTOS</td>\n",
              "      <td>SP</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-15</td>\n",
              "      <td>17:45:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>39847</td>\n",
              "      <td>39847</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>SOROCABA</td>\n",
              "      <td>SP</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-20</td>\n",
              "      <td>13:10:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>39768</td>\n",
              "      <td>39768</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>CAMPINAS</td>\n",
              "      <td>SP</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-21</td>\n",
              "      <td>20:45:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>39848</td>\n",
              "      <td>39848</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>GUARULHOS</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBGR</td>\n",
              "      <td>2010-01-25</td>\n",
              "      <td>17:05:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5704</th>\n",
              "      <td>79739</td>\n",
              "      <td>79739</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBSP</td>\n",
              "      <td>2020-12-03</td>\n",
              "      <td>14:42:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5705</th>\n",
              "      <td>79705</td>\n",
              "      <td>79705</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>SOROCABA</td>\n",
              "      <td>SP</td>\n",
              "      <td>SDCO</td>\n",
              "      <td>2020-12-04</td>\n",
              "      <td>15:30:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5715</th>\n",
              "      <td>79718</td>\n",
              "      <td>79718</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBMT</td>\n",
              "      <td>2020-12-11</td>\n",
              "      <td>13:50:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5742</th>\n",
              "      <td>79800</td>\n",
              "      <td>79800</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBMT</td>\n",
              "      <td>2020-12-28</td>\n",
              "      <td>10:15:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5747</th>\n",
              "      <td>79804</td>\n",
              "      <td>79804</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>CAMPINAS</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBKP</td>\n",
              "      <td>2020-12-29</td>\n",
              "      <td>19:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>985 rows × 9 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "      codigo_ocorrencia  ...  total_recomendacoes\n",
              "16                39809  ...                    0\n",
              "18                39828  ...                    0\n",
              "26                39847  ...                    0\n",
              "27                39768  ...                    0\n",
              "33                39848  ...                    0\n",
              "...                 ...  ...                  ...\n",
              "5704              79739  ...                    0\n",
              "5705              79705  ...                    0\n",
              "5715              79718  ...                    0\n",
              "5742              79800  ...                    0\n",
              "5747              79804  ...                    0\n",
              "\n",
              "[985 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 26
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "KwL-aCkRcZOB",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 439
        },
        "outputId": "2629b4f8-a40d-44e4-a1d8-385073464241"
      },
      "source": [
        "#ocorrências cuja cidade comecem com a letra C\n",
        "filtro = df.ocorrencia_cidade.str[0] == 'C'\n",
        "df.loc[filtro]"
      ],
      "execution_count": 27,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>6</th>\n",
              "      <td>40215</td>\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</td>\n",
              "      <td>18:40:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>39707</td>\n",
              "      <td>39707</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>CANUTAMA</td>\n",
              "      <td>AM</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-09</td>\n",
              "      <td>12:30:00</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>39156</td>\n",
              "      <td>39156</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>CASCAVEL</td>\n",
              "      <td>PR</td>\n",
              "      <td>SBCA</td>\n",
              "      <td>2010-01-10</td>\n",
              "      <td>23:15:00</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>39315</td>\n",
              "      <td>39315</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>CANUTAMA</td>\n",
              "      <td>AM</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-15</td>\n",
              "      <td>21:22:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>40310</td>\n",
              "      <td>40310</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>CRUZEIRO DO SUL</td>\n",
              "      <td>AC</td>\n",
              "      <td>SBCZ</td>\n",
              "      <td>2010-01-18</td>\n",
              "      <td>19:32:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5661</th>\n",
              "      <td>79649</td>\n",
              "      <td>79649</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>CAMPINAS</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBKP</td>\n",
              "      <td>2020-11-04</td>\n",
              "      <td>22:39:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5663</th>\n",
              "      <td>79652</td>\n",
              "      <td>79652</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>CONFINS</td>\n",
              "      <td>MG</td>\n",
              "      <td>SBCF</td>\n",
              "      <td>2020-11-06</td>\n",
              "      <td>14:20:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5680</th>\n",
              "      <td>79683</td>\n",
              "      <td>79683</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>CRUZEIRO DO SUL</td>\n",
              "      <td>AC</td>\n",
              "      <td>SBCZ</td>\n",
              "      <td>2020-11-16</td>\n",
              "      <td>22:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5696</th>\n",
              "      <td>79692</td>\n",
              "      <td>79692</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>CATANDUVA</td>\n",
              "      <td>SP</td>\n",
              "      <td>SDCD</td>\n",
              "      <td>2020-11-28</td>\n",
              "      <td>12:50:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5747</th>\n",
              "      <td>79804</td>\n",
              "      <td>79804</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>CAMPINAS</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBKP</td>\n",
              "      <td>2020-12-29</td>\n",
              "      <td>19:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>825 rows × 9 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "      codigo_ocorrencia  ...  total_recomendacoes\n",
              "6                 40215  ...                    0\n",
              "7                 39707  ...                    3\n",
              "8                 39156  ...                    2\n",
              "15                39315  ...                    0\n",
              "20                40310  ...                    0\n",
              "...                 ...  ...                  ...\n",
              "5661              79649  ...                    0\n",
              "5663              79652  ...                    0\n",
              "5680              79683  ...                    0\n",
              "5696              79692  ...                    0\n",
              "5747              79804  ...                    0\n",
              "\n",
              "[825 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 27
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Q_THIOFIcbtb",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 439
        },
        "outputId": "e537bec9-1168-4bca-980c-8ea96bfbd96d"
      },
      "source": [
        "#ocorrências cuja cidade terminam com a letra A\n",
        "filtro = df.ocorrencia_cidade.str[-1] == 'A'\n",
        "df.loc[filtro]"
      ],
      "execution_count": 28,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>7</th>\n",
              "      <td>39707</td>\n",
              "      <td>39707</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>CANUTAMA</td>\n",
              "      <td>AM</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-09</td>\n",
              "      <td>12:30:00</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>40414</td>\n",
              "      <td>40414</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>BRASÍLIA</td>\n",
              "      <td>DF</td>\n",
              "      <td>SBBR</td>\n",
              "      <td>2010-01-10</td>\n",
              "      <td>03:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>39315</td>\n",
              "      <td>39315</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>CANUTAMA</td>\n",
              "      <td>AM</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-15</td>\n",
              "      <td>21:22:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>39772</td>\n",
              "      <td>39772</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>UBERLÂNDIA</td>\n",
              "      <td>MG</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-20</td>\n",
              "      <td>18:58:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>39847</td>\n",
              "      <td>39847</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>SOROCABA</td>\n",
              "      <td>SP</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-20</td>\n",
              "      <td>13:10:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5738</th>\n",
              "      <td>79787</td>\n",
              "      <td>79787</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>FORTALEZA</td>\n",
              "      <td>CE</td>\n",
              "      <td>SBFZ</td>\n",
              "      <td>2020-12-23</td>\n",
              "      <td>18:30:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5739</th>\n",
              "      <td>79749</td>\n",
              "      <td>79749</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>MARITUBA</td>\n",
              "      <td>PA</td>\n",
              "      <td>****</td>\n",
              "      <td>2020-12-26</td>\n",
              "      <td>12:05:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5743</th>\n",
              "      <td>79824</td>\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</td>\n",
              "      <td>17:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5744</th>\n",
              "      <td>79753</td>\n",
              "      <td>79753</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>GOIATUBA</td>\n",
              "      <td>GO</td>\n",
              "      <td>****</td>\n",
              "      <td>2020-12-29</td>\n",
              "      <td>12:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5750</th>\n",
              "      <td>79756</td>\n",
              "      <td>79756</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>VICENTINA</td>\n",
              "      <td>MS</td>\n",
              "      <td>****</td>\n",
              "      <td>2020-12-31</td>\n",
              "      <td>09:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1556 rows × 9 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "      codigo_ocorrencia  ...  total_recomendacoes\n",
              "7                 39707  ...                    3\n",
              "12                40414  ...                    0\n",
              "15                39315  ...                    0\n",
              "25                39772  ...                    0\n",
              "26                39847  ...                    0\n",
              "...                 ...  ...                  ...\n",
              "5738              79787  ...                    0\n",
              "5739              79749  ...                    0\n",
              "5743              79824  ...                    0\n",
              "5744              79753  ...                    0\n",
              "5750              79756  ...                    0\n",
              "\n",
              "[1556 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 28
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "i496SQvTcex8",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 999
        },
        "outputId": "848c94cd-13f7-4706-f47c-34c33d52c4d0"
      },
      "source": [
        "#ocorrências cuja cidade terminam com os caracteres MA\n",
        "filtro = df.ocorrencia_cidade.str[-2:] == 'MA'\n",
        "df.loc[filtro]"
      ],
      "execution_count": 29,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>7</th>\n",
              "      <td>39707</td>\n",
              "      <td>39707</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>CANUTAMA</td>\n",
              "      <td>AM</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-09</td>\n",
              "      <td>12:30:00</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>39315</td>\n",
              "      <td>39315</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>CANUTAMA</td>\n",
              "      <td>AM</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-15</td>\n",
              "      <td>21:22:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>408</th>\n",
              "      <td>43062</td>\n",
              "      <td>43062</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>NOVO GAMA</td>\n",
              "      <td>GO</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-09-25</td>\n",
              "      <td>16:30:00</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>688</th>\n",
              "      <td>44198</td>\n",
              "      <td>44198</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>BURITAMA</td>\n",
              "      <td>SP</td>\n",
              "      <td>****</td>\n",
              "      <td>2011-03-19</td>\n",
              "      <td>11:18:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1035</th>\n",
              "      <td>51785</td>\n",
              "      <td>51785</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>BURITAMA</td>\n",
              "      <td>SP</td>\n",
              "      <td>SIBX</td>\n",
              "      <td>2011-10-25</td>\n",
              "      <td>19:15:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1377</th>\n",
              "      <td>45939</td>\n",
              "      <td>45939</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>UMUARAMA</td>\n",
              "      <td>PR</td>\n",
              "      <td>****</td>\n",
              "      <td>2012-05-30</td>\n",
              "      <td>19:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1401</th>\n",
              "      <td>46180</td>\n",
              "      <td>46180</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>AURIFLAMA</td>\n",
              "      <td>SP</td>\n",
              "      <td>****</td>\n",
              "      <td>2012-06-16</td>\n",
              "      <td>19:30:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2099</th>\n",
              "      <td>49113</td>\n",
              "      <td>49113</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>NOVA LIMA</td>\n",
              "      <td>MG</td>\n",
              "      <td>****</td>\n",
              "      <td>2013-06-15</td>\n",
              "      <td>12:00:00</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2102</th>\n",
              "      <td>48799</td>\n",
              "      <td>48799</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>CANUTAMA</td>\n",
              "      <td>AM</td>\n",
              "      <td>****</td>\n",
              "      <td>2013-06-18</td>\n",
              "      <td>21:30:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2655</th>\n",
              "      <td>51347</td>\n",
              "      <td>51347</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>DIADEMA</td>\n",
              "      <td>SP</td>\n",
              "      <td>****</td>\n",
              "      <td>2014-05-04</td>\n",
              "      <td>16:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2855</th>\n",
              "      <td>52340</td>\n",
              "      <td>52340</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>FAMA</td>\n",
              "      <td>MG</td>\n",
              "      <td>****</td>\n",
              "      <td>2014-09-20</td>\n",
              "      <td>15:00:00</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2966</th>\n",
              "      <td>52832</td>\n",
              "      <td>52832</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>BURITAMA</td>\n",
              "      <td>SP</td>\n",
              "      <td>****</td>\n",
              "      <td>2014-12-14</td>\n",
              "      <td>23:40:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2997</th>\n",
              "      <td>52979</td>\n",
              "      <td>52979</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>IVINHEMA</td>\n",
              "      <td>MS</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-01-02</td>\n",
              "      <td>14:50:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3040</th>\n",
              "      <td>52984</td>\n",
              "      <td>52984</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>NOVA LIMA</td>\n",
              "      <td>MG</td>\n",
              "      <td>SJLY</td>\n",
              "      <td>2015-02-01</td>\n",
              "      <td>15:10:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3092</th>\n",
              "      <td>53596</td>\n",
              "      <td>53596</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>ITAPEMA</td>\n",
              "      <td>SC</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-03-10</td>\n",
              "      <td>21:35:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3157</th>\n",
              "      <td>53223</td>\n",
              "      <td>53223</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>PINDORAMA</td>\n",
              "      <td>SP</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-04-22</td>\n",
              "      <td>12:45:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3171</th>\n",
              "      <td>53265</td>\n",
              "      <td>53265</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>PACARAIMA</td>\n",
              "      <td>RR</td>\n",
              "      <td>SDMM</td>\n",
              "      <td>2015-05-05</td>\n",
              "      <td>16:05:00</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3189</th>\n",
              "      <td>53271</td>\n",
              "      <td>53271</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>UMUARAMA</td>\n",
              "      <td>PR</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-05-17</td>\n",
              "      <td>17:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3682</th>\n",
              "      <td>65414</td>\n",
              "      <td>65414</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>NOVA LIMA</td>\n",
              "      <td>MG</td>\n",
              "      <td>SJLY</td>\n",
              "      <td>2016-07-08</td>\n",
              "      <td>19:50:00</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3725</th>\n",
              "      <td>65633</td>\n",
              "      <td>65633</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>NOVA LIMA</td>\n",
              "      <td>MG</td>\n",
              "      <td>****</td>\n",
              "      <td>2016-08-31</td>\n",
              "      <td>17:40:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3881</th>\n",
              "      <td>66265</td>\n",
              "      <td>66265</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>BURITAMA</td>\n",
              "      <td>SP</td>\n",
              "      <td>****</td>\n",
              "      <td>2017-01-13</td>\n",
              "      <td>16:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4229</th>\n",
              "      <td>77371</td>\n",
              "      <td>77371</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>CANUTAMA</td>\n",
              "      <td>AM</td>\n",
              "      <td>SDKH</td>\n",
              "      <td>2017-11-02</td>\n",
              "      <td>19:30:00</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4311</th>\n",
              "      <td>77612</td>\n",
              "      <td>77612</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>ITAPEMA</td>\n",
              "      <td>SC</td>\n",
              "      <td>****</td>\n",
              "      <td>2018-01-06</td>\n",
              "      <td>10:30:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4574</th>\n",
              "      <td>78080</td>\n",
              "      <td>78080</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>ITAPEMA</td>\n",
              "      <td>SC</td>\n",
              "      <td>****</td>\n",
              "      <td>2018-07-28</td>\n",
              "      <td>14:20:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4986</th>\n",
              "      <td>78867</td>\n",
              "      <td>78867</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>IRACEMA</td>\n",
              "      <td>RR</td>\n",
              "      <td>*****</td>\n",
              "      <td>2019-07-06</td>\n",
              "      <td>00:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5070</th>\n",
              "      <td>78923</td>\n",
              "      <td>78923</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>CANUTAMA</td>\n",
              "      <td>AM</td>\n",
              "      <td>*****</td>\n",
              "      <td>2019-09-03</td>\n",
              "      <td>14:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5080</th>\n",
              "      <td>78782</td>\n",
              "      <td>78782</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>IVINHEMA</td>\n",
              "      <td>MS</td>\n",
              "      <td>****</td>\n",
              "      <td>2019-09-08</td>\n",
              "      <td>17:45:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5405</th>\n",
              "      <td>79282</td>\n",
              "      <td>79282</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>ITURAMA</td>\n",
              "      <td>MG</td>\n",
              "      <td>****</td>\n",
              "      <td>2020-04-11</td>\n",
              "      <td>12:20:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5440</th>\n",
              "      <td>79338</td>\n",
              "      <td>79338</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>IVINHEMA</td>\n",
              "      <td>MS</td>\n",
              "      <td>*****</td>\n",
              "      <td>2020-05-15</td>\n",
              "      <td>09:40:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5474</th>\n",
              "      <td>79400</td>\n",
              "      <td>79400</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>IBIRAMA</td>\n",
              "      <td>SC</td>\n",
              "      <td>****</td>\n",
              "      <td>2020-06-09</td>\n",
              "      <td>14:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      codigo_ocorrencia  ...  total_recomendacoes\n",
              "7                 39707  ...                    3\n",
              "15                39315  ...                    0\n",
              "408               43062  ...                    1\n",
              "688               44198  ...                    0\n",
              "1035              51785  ...                    0\n",
              "1377              45939  ...                    0\n",
              "1401              46180  ...                    0\n",
              "2099              49113  ...                    4\n",
              "2102              48799  ...                    0\n",
              "2655              51347  ...                    0\n",
              "2855              52340  ...                    1\n",
              "2966              52832  ...                    0\n",
              "2997              52979  ...                    0\n",
              "3040              52984  ...                    0\n",
              "3092              53596  ...                    0\n",
              "3157              53223  ...                    0\n",
              "3171              53265  ...                    2\n",
              "3189              53271  ...                    0\n",
              "3682              65414  ...                    1\n",
              "3725              65633  ...                    0\n",
              "3881              66265  ...                    0\n",
              "4229              77371  ...                    1\n",
              "4311              77612  ...                    0\n",
              "4574              78080  ...                    0\n",
              "4986              78867  ...                    0\n",
              "5070              78923  ...                    0\n",
              "5080              78782  ...                    0\n",
              "5405              79282  ...                    0\n",
              "5440              79338  ...                    0\n",
              "5474              79400  ...                    0\n",
              "\n",
              "[30 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 29
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "UFfX4uBqcg-L",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 456
        },
        "outputId": "83406bee-8df6-4c2d-c872-3ea2d8544655"
      },
      "source": [
        "#ocorrências cuja cidade contém (em qualquer parte do conteúdo) os caracteres MA ou AL\n",
        "filtro = df.ocorrencia_cidade.str.contains('MA|AL')\n",
        "df.loc[filtro]"
      ],
      "execution_count": 30,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>5</th>\n",
              "      <td>39807</td>\n",
              "      <td>39807</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>SALVADOR</td>\n",
              "      <td>BA</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-06</td>\n",
              "      <td>17:53:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>39707</td>\n",
              "      <td>39707</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>CANUTAMA</td>\n",
              "      <td>AM</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-09</td>\n",
              "      <td>12:30:00</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>39507</td>\n",
              "      <td>39507</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>PRIMAVERA DO LESTE</td>\n",
              "      <td>MT</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-11</td>\n",
              "      <td>17:00:00</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>39315</td>\n",
              "      <td>39315</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>CANUTAMA</td>\n",
              "      <td>AM</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-15</td>\n",
              "      <td>21:22:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>39810</td>\n",
              "      <td>39810</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>SALVADOR</td>\n",
              "      <td>BA</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-15</td>\n",
              "      <td>18:23:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5738</th>\n",
              "      <td>79787</td>\n",
              "      <td>79787</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>FORTALEZA</td>\n",
              "      <td>CE</td>\n",
              "      <td>SBFZ</td>\n",
              "      <td>2020-12-23</td>\n",
              "      <td>18:30:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5739</th>\n",
              "      <td>79749</td>\n",
              "      <td>79749</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>MARITUBA</td>\n",
              "      <td>PA</td>\n",
              "      <td>****</td>\n",
              "      <td>2020-12-26</td>\n",
              "      <td>12:05:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5741</th>\n",
              "      <td>79754</td>\n",
              "      <td>79754</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>NOVA MARINGÁ</td>\n",
              "      <td>MT</td>\n",
              "      <td>****</td>\n",
              "      <td>2020-12-28</td>\n",
              "      <td>13:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5745</th>\n",
              "      <td>79755</td>\n",
              "      <td>79755</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>MATO RICO</td>\n",
              "      <td>PR</td>\n",
              "      <td>****</td>\n",
              "      <td>2020-12-29</td>\n",
              "      <td>10:30:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5746</th>\n",
              "      <td>79769</td>\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</td>\n",
              "      <td>18:30:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>903 rows × 9 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "      codigo_ocorrencia  ...  total_recomendacoes\n",
              "5                 39807  ...                    0\n",
              "7                 39707  ...                    3\n",
              "13                39507  ...                    2\n",
              "15                39315  ...                    0\n",
              "17                39810  ...                    0\n",
              "...                 ...  ...                  ...\n",
              "5738              79787  ...                    0\n",
              "5739              79749  ...                    0\n",
              "5741              79754  ...                    0\n",
              "5745              79755  ...                    0\n",
              "5746              79769  ...                    0\n",
              "\n",
              "[903 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 30
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "AaWkxw3ecjfy",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 456
        },
        "outputId": "c39f567e-1d07-4513-c49f-376b862e33ee"
      },
      "source": [
        "#ocorrências do ano de 2015\n",
        "filtro = df.ocorrencia_dia.dt.year == 2015\n",
        "df.loc[filtro]"
      ],
      "execution_count": 31,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>2996</th>\n",
              "      <td>52992</td>\n",
              "      <td>52992</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>SALVADOR</td>\n",
              "      <td>BA</td>\n",
              "      <td>SBSV</td>\n",
              "      <td>2015-01-01</td>\n",
              "      <td>11:40:00</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2997</th>\n",
              "      <td>52979</td>\n",
              "      <td>52979</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>IVINHEMA</td>\n",
              "      <td>MS</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-01-02</td>\n",
              "      <td>14:50:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2998</th>\n",
              "      <td>53073</td>\n",
              "      <td>53073</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>TEFÉ</td>\n",
              "      <td>AM</td>\n",
              "      <td>SBTF</td>\n",
              "      <td>2015-01-02</td>\n",
              "      <td>16:28:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2999</th>\n",
              "      <td>53074</td>\n",
              "      <td>53074</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>BELO HORIZONTE</td>\n",
              "      <td>MG</td>\n",
              "      <td>SBBH</td>\n",
              "      <td>2015-01-02</td>\n",
              "      <td>20:34:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3000</th>\n",
              "      <td>52976</td>\n",
              "      <td>52976</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>TOLEDO</td>\n",
              "      <td>PR</td>\n",
              "      <td>SBTD</td>\n",
              "      <td>2015-01-04</td>\n",
              "      <td>22:04:00</td>\n",
              "      <td>6</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>3462</th>\n",
              "      <td>60632</td>\n",
              "      <td>60632</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>ITABERÁ</td>\n",
              "      <td>SP</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-12-24</td>\n",
              "      <td>14:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3463</th>\n",
              "      <td>60600</td>\n",
              "      <td>60600</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>GUARULHOS</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBGR</td>\n",
              "      <td>2015-12-25</td>\n",
              "      <td>19:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3464</th>\n",
              "      <td>60642</td>\n",
              "      <td>60642</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>SÃO FRANCISCO DO SUL</td>\n",
              "      <td>SC</td>\n",
              "      <td>SSSS</td>\n",
              "      <td>2015-12-26</td>\n",
              "      <td>16:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3465</th>\n",
              "      <td>60631</td>\n",
              "      <td>60631</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>MAÇAMBARÁ</td>\n",
              "      <td>RS</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-12-28</td>\n",
              "      <td>19:00:00</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3466</th>\n",
              "      <td>60649</td>\n",
              "      <td>60649</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>PORTO BELO</td>\n",
              "      <td>SC</td>\n",
              "      <td>SDEN</td>\n",
              "      <td>2015-12-31</td>\n",
              "      <td>14:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>471 rows × 9 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "      codigo_ocorrencia  ...  total_recomendacoes\n",
              "2996              52992  ...                    3\n",
              "2997              52979  ...                    0\n",
              "2998              53073  ...                    0\n",
              "2999              53074  ...                    0\n",
              "3000              52976  ...                    6\n",
              "...                 ...  ...                  ...\n",
              "3462              60632  ...                    0\n",
              "3463              60600  ...                    0\n",
              "3464              60642  ...                    0\n",
              "3465              60631  ...                    2\n",
              "3466              60649  ...                    0\n",
              "\n",
              "[471 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 31
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "U6Hifx7Rcl9P",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "995338a9-d881-40b2-a5f9-cbbc28aeeff7"
      },
      "source": [
        "df.dtypes"
      ],
      "execution_count": 32,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "codigo_ocorrencia                    int64\n",
              "codigo_ocorrencia2                   int64\n",
              "ocorrencia_classificacao            object\n",
              "ocorrencia_cidade                   object\n",
              "ocorrencia_uf                       object\n",
              "ocorrencia_aerodromo                object\n",
              "ocorrencia_dia              datetime64[ns]\n",
              "ocorrencia_hora                     object\n",
              "total_recomendacoes                  int64\n",
              "dtype: object"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 32
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "0IOTi98ScoYm",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 334
        },
        "outputId": "a9b8edbe-41b0-4a8f-d526-90ae3e1fd511"
      },
      "source": [
        "#ocorrências do ano de 2015 e mês 12 e dias entre 3 e 8\n",
        "filtro_ano = df.ocorrencia_dia.dt.year == 2015\n",
        "filtro_mes = df.ocorrencia_dia.dt.month == 12\n",
        "filtro_dia_inicio = df.ocorrencia_dia.dt.day > 2 \n",
        "filtro_dia_fim = df.ocorrencia_dia.dt.day < 9\n",
        "df.loc[filtro_ano & filtro_mes & filtro_dia_inicio & filtro_dia_fim]"
      ],
      "execution_count": 33,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>3432</th>\n",
              "      <td>53575</td>\n",
              "      <td>53575</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>CAMPOS DOS GOYTACAZES</td>\n",
              "      <td>RJ</td>\n",
              "      <td>SBFS</td>\n",
              "      <td>2015-12-03</td>\n",
              "      <td>10:50:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3433</th>\n",
              "      <td>60637</td>\n",
              "      <td>60637</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>BELO HORIZONTE</td>\n",
              "      <td>MG</td>\n",
              "      <td>SBBH</td>\n",
              "      <td>2015-12-03</td>\n",
              "      <td>16:47:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3434</th>\n",
              "      <td>53625</td>\n",
              "      <td>53625</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>TRINDADE</td>\n",
              "      <td>GO</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-12-06</td>\n",
              "      <td>13:10:00</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3435</th>\n",
              "      <td>53626</td>\n",
              "      <td>53626</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>AMERICANA</td>\n",
              "      <td>SP</td>\n",
              "      <td>SDAI</td>\n",
              "      <td>2015-12-06</td>\n",
              "      <td>15:00:00</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3436</th>\n",
              "      <td>53628</td>\n",
              "      <td>53628</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>AGUAÍ</td>\n",
              "      <td>SP</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-12-08</td>\n",
              "      <td>14:30:00</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3437</th>\n",
              "      <td>53629</td>\n",
              "      <td>53629</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>JALES</td>\n",
              "      <td>SP</td>\n",
              "      <td>SDJL</td>\n",
              "      <td>2015-12-08</td>\n",
              "      <td>10:20:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3438</th>\n",
              "      <td>53631</td>\n",
              "      <td>53631</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>CAMPINAS</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBKP</td>\n",
              "      <td>2015-12-08</td>\n",
              "      <td>16:19:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3439</th>\n",
              "      <td>60636</td>\n",
              "      <td>60636</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>CAXIAS DO SUL</td>\n",
              "      <td>RS</td>\n",
              "      <td>SBCX</td>\n",
              "      <td>2015-12-08</td>\n",
              "      <td>13:00:00</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      codigo_ocorrencia  ...  total_recomendacoes\n",
              "3432              53575  ...                    0\n",
              "3433              60637  ...                    0\n",
              "3434              53625  ...                    3\n",
              "3435              53626  ...                    1\n",
              "3436              53628  ...                    1\n",
              "3437              53629  ...                    0\n",
              "3438              53631  ...                    0\n",
              "3439              60636  ...                    0\n",
              "\n",
              "[8 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 33
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Hp-p-i6Tcqov"
      },
      "source": [
        "df['ocorrencia_dia_hora'] = pd.to_datetime(df.ocorrencia_dia.astype(str) + ' '  + df.ocorrencia_hora)"
      ],
      "execution_count": 34,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Z_at64Q5cs1w",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 241
        },
        "outputId": "9b561004-fe0d-4d86-c288-1870b4b2f2a5"
      },
      "source": [
        "df.head()"
      ],
      "execution_count": 35,
      "outputs": [
        {
          "output_type": "execute_result",
          "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",
              "      <th>ocorrencia_dia_hora</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",
              "      <td>2010-01-03 12:00:00</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",
              "      <td>2010-01-03 11:05:00</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",
              "      <td>2010-01-03 03:00:00</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",
              "      <td>2010-01-04 17:30:00</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",
              "      <td>2010-01-05 19:25:00</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   codigo_ocorrencia  ...  ocorrencia_dia_hora\n",
              "0              40211  ...  2010-01-03 12:00:00\n",
              "1              40349  ...  2010-01-03 11:05:00\n",
              "2              40351  ...  2010-01-03 03:00:00\n",
              "3              39527  ...  2010-01-04 17:30:00\n",
              "4              40324  ...  2010-01-05 19:25:00\n",
              "\n",
              "[5 rows x 10 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 35
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "YlzLK1lhcu-q",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "4119af98-9ee0-4777-efb4-ebf8491ce1b7"
      },
      "source": [
        "df.dtypes"
      ],
      "execution_count": 36,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "codigo_ocorrencia                    int64\n",
              "codigo_ocorrencia2                   int64\n",
              "ocorrencia_classificacao            object\n",
              "ocorrencia_cidade                   object\n",
              "ocorrencia_uf                       object\n",
              "ocorrencia_aerodromo                object\n",
              "ocorrencia_dia              datetime64[ns]\n",
              "ocorrencia_hora                     object\n",
              "total_recomendacoes                  int64\n",
              "ocorrencia_dia_hora         datetime64[ns]\n",
              "dtype: object"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 36
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "LH_MZnP8cxMY",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 334
        },
        "outputId": "b5295324-78ca-4c8d-9082-fc262b5e9fd3"
      },
      "source": [
        "#ocorrências do ano de 2015 e mês 12 e dias entre 3 e 8\n",
        "filtro_ano = df.ocorrencia_dia_hora.dt.year == 2015\n",
        "filtro_mes = df.ocorrencia_dia_hora.dt.month == 12\n",
        "filtro_dia_inicio = df.ocorrencia_dia_hora.dt.day > 2 \n",
        "filtro_dia_fim = df.ocorrencia_dia_hora.dt.day < 9\n",
        "df.loc[filtro_ano & filtro_mes & filtro_dia_inicio & filtro_dia_fim]"
      ],
      "execution_count": 37,
      "outputs": [
        {
          "output_type": "execute_result",
          "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",
              "      <th>ocorrencia_dia_hora</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>3432</th>\n",
              "      <td>53575</td>\n",
              "      <td>53575</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>CAMPOS DOS GOYTACAZES</td>\n",
              "      <td>RJ</td>\n",
              "      <td>SBFS</td>\n",
              "      <td>2015-12-03</td>\n",
              "      <td>10:50:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-12-03 10:50:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3433</th>\n",
              "      <td>60637</td>\n",
              "      <td>60637</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>BELO HORIZONTE</td>\n",
              "      <td>MG</td>\n",
              "      <td>SBBH</td>\n",
              "      <td>2015-12-03</td>\n",
              "      <td>16:47:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-12-03 16:47:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3434</th>\n",
              "      <td>53625</td>\n",
              "      <td>53625</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>TRINDADE</td>\n",
              "      <td>GO</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-12-06</td>\n",
              "      <td>13:10:00</td>\n",
              "      <td>3</td>\n",
              "      <td>2015-12-06 13:10:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3435</th>\n",
              "      <td>53626</td>\n",
              "      <td>53626</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>AMERICANA</td>\n",
              "      <td>SP</td>\n",
              "      <td>SDAI</td>\n",
              "      <td>2015-12-06</td>\n",
              "      <td>15:00:00</td>\n",
              "      <td>1</td>\n",
              "      <td>2015-12-06 15:00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3436</th>\n",
              "      <td>53628</td>\n",
              "      <td>53628</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>AGUAÍ</td>\n",
              "      <td>SP</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-12-08</td>\n",
              "      <td>14:30:00</td>\n",
              "      <td>1</td>\n",
              "      <td>2015-12-08 14:30:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3437</th>\n",
              "      <td>53629</td>\n",
              "      <td>53629</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>JALES</td>\n",
              "      <td>SP</td>\n",
              "      <td>SDJL</td>\n",
              "      <td>2015-12-08</td>\n",
              "      <td>10:20:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-12-08 10:20:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3438</th>\n",
              "      <td>53631</td>\n",
              "      <td>53631</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>CAMPINAS</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBKP</td>\n",
              "      <td>2015-12-08</td>\n",
              "      <td>16:19:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-12-08 16:19:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3439</th>\n",
              "      <td>60636</td>\n",
              "      <td>60636</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>CAXIAS DO SUL</td>\n",
              "      <td>RS</td>\n",
              "      <td>SBCX</td>\n",
              "      <td>2015-12-08</td>\n",
              "      <td>13:00:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-12-08 13:00:00</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      codigo_ocorrencia  ...  ocorrencia_dia_hora\n",
              "3432              53575  ...  2015-12-03 10:50:00\n",
              "3433              60637  ...  2015-12-03 16:47:00\n",
              "3434              53625  ...  2015-12-06 13:10:00\n",
              "3435              53626  ...  2015-12-06 15:00:00\n",
              "3436              53628  ...  2015-12-08 14:30:00\n",
              "3437              53629  ...  2015-12-08 10:20:00\n",
              "3438              53631  ...  2015-12-08 16:19:00\n",
              "3439              60636  ...  2015-12-08 13:00:00\n",
              "\n",
              "[8 rows x 10 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 37
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "3c_bDvcMczvG",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 255
        },
        "outputId": "11c6d967-4e91-4ba7-f5ea-08cad17d3d95"
      },
      "source": [
        "filtro1 = df.ocorrencia_dia_hora >= '2015-12-03 11:00:00'\n",
        "filtro2 = df.ocorrencia_dia_hora <= '2015-12-08 14:30:00'\n",
        "df.loc[filtro1 & filtro2]"
      ],
      "execution_count": 38,
      "outputs": [
        {
          "output_type": "execute_result",
          "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",
              "      <th>ocorrencia_dia_hora</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>3433</th>\n",
              "      <td>60637</td>\n",
              "      <td>60637</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>BELO HORIZONTE</td>\n",
              "      <td>MG</td>\n",
              "      <td>SBBH</td>\n",
              "      <td>2015-12-03</td>\n",
              "      <td>16:47:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-12-03 16:47:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3434</th>\n",
              "      <td>53625</td>\n",
              "      <td>53625</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>TRINDADE</td>\n",
              "      <td>GO</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-12-06</td>\n",
              "      <td>13:10:00</td>\n",
              "      <td>3</td>\n",
              "      <td>2015-12-06 13:10:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3435</th>\n",
              "      <td>53626</td>\n",
              "      <td>53626</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>AMERICANA</td>\n",
              "      <td>SP</td>\n",
              "      <td>SDAI</td>\n",
              "      <td>2015-12-06</td>\n",
              "      <td>15:00:00</td>\n",
              "      <td>1</td>\n",
              "      <td>2015-12-06 15:00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3436</th>\n",
              "      <td>53628</td>\n",
              "      <td>53628</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>AGUAÍ</td>\n",
              "      <td>SP</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-12-08</td>\n",
              "      <td>14:30:00</td>\n",
              "      <td>1</td>\n",
              "      <td>2015-12-08 14:30:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3437</th>\n",
              "      <td>53629</td>\n",
              "      <td>53629</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>JALES</td>\n",
              "      <td>SP</td>\n",
              "      <td>SDJL</td>\n",
              "      <td>2015-12-08</td>\n",
              "      <td>10:20:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-12-08 10:20:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3439</th>\n",
              "      <td>60636</td>\n",
              "      <td>60636</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>CAXIAS DO SUL</td>\n",
              "      <td>RS</td>\n",
              "      <td>SBCX</td>\n",
              "      <td>2015-12-08</td>\n",
              "      <td>13:00:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-12-08 13:00:00</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      codigo_ocorrencia  ...  ocorrencia_dia_hora\n",
              "3433              60637  ...  2015-12-03 16:47:00\n",
              "3434              53625  ...  2015-12-06 13:10:00\n",
              "3435              53626  ...  2015-12-06 15:00:00\n",
              "3436              53628  ...  2015-12-08 14:30:00\n",
              "3437              53629  ...  2015-12-08 10:20:00\n",
              "3439              60636  ...  2015-12-08 13:00:00\n",
              "\n",
              "[6 rows x 10 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 38
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "3u8akdVHc13k",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "eb726326-384d-41ff-988f-0963d58baf73"
      },
      "source": [
        "#ocorrências do ano de 2015 e mês 03\n",
        "filtro1 = df.ocorrencia_dia.dt.year == 2015\n",
        "filtro2 = df.ocorrencia_dia.dt.month == 3\n",
        "df201503 = df.loc[filtro1 & filtro2]\n",
        "df201503"
      ],
      "execution_count": 39,
      "outputs": [
        {
          "output_type": "execute_result",
          "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",
              "      <th>ocorrencia_dia_hora</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>3086</th>\n",
              "      <td>53183</td>\n",
              "      <td>53183</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>AMAPORÃ</td>\n",
              "      <td>PR</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-03-02</td>\n",
              "      <td>23:00:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-02 23:00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3087</th>\n",
              "      <td>53120</td>\n",
              "      <td>53120</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>CHAVES</td>\n",
              "      <td>PA</td>\n",
              "      <td>SNXW</td>\n",
              "      <td>2015-03-04</td>\n",
              "      <td>13:30:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-04 13:30:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3088</th>\n",
              "      <td>53109</td>\n",
              "      <td>53109</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>CAMPO GRANDE</td>\n",
              "      <td>MS</td>\n",
              "      <td>SSIE</td>\n",
              "      <td>2015-03-05</td>\n",
              "      <td>13:50:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-05 13:50:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3089</th>\n",
              "      <td>53112</td>\n",
              "      <td>53112</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>MOGI GUAÇU</td>\n",
              "      <td>SP</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-03-06</td>\n",
              "      <td>21:00:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-06 21:00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3090</th>\n",
              "      <td>53152</td>\n",
              "      <td>53152</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>RJ</td>\n",
              "      <td>SBRJ</td>\n",
              "      <td>2015-03-10</td>\n",
              "      <td>11:30:00</td>\n",
              "      <td>2</td>\n",
              "      <td>2015-03-10 11:30:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3091</th>\n",
              "      <td>53167</td>\n",
              "      <td>53167</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>MARABÁ</td>\n",
              "      <td>PA</td>\n",
              "      <td>SBMA</td>\n",
              "      <td>2015-03-10</td>\n",
              "      <td>17:33:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-10 17:33:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3092</th>\n",
              "      <td>53596</td>\n",
              "      <td>53596</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>ITAPEMA</td>\n",
              "      <td>SC</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-03-10</td>\n",
              "      <td>21:35:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-10 21:35:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3093</th>\n",
              "      <td>53149</td>\n",
              "      <td>53149</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>TABATINGA</td>\n",
              "      <td>AM</td>\n",
              "      <td>SBTT</td>\n",
              "      <td>2015-03-11</td>\n",
              "      <td>23:25:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-11 23:25:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3094</th>\n",
              "      <td>53148</td>\n",
              "      <td>53148</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>ARARAS</td>\n",
              "      <td>SP</td>\n",
              "      <td>SDEH</td>\n",
              "      <td>2015-03-12</td>\n",
              "      <td>12:40:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-12 12:40:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3095</th>\n",
              "      <td>53153</td>\n",
              "      <td>53153</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>PORTO ALEGRE</td>\n",
              "      <td>RS</td>\n",
              "      <td>SBPA</td>\n",
              "      <td>2015-03-13</td>\n",
              "      <td>15:45:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-13 15:45:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3096</th>\n",
              "      <td>53154</td>\n",
              "      <td>53154</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>SOROCABA</td>\n",
              "      <td>SP</td>\n",
              "      <td>SDCO</td>\n",
              "      <td>2015-03-13</td>\n",
              "      <td>14:40:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-13 14:40:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3097</th>\n",
              "      <td>53238</td>\n",
              "      <td>53238</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>SERRA</td>\n",
              "      <td>ES</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-03-13</td>\n",
              "      <td>11:30:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-13 11:30:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3098</th>\n",
              "      <td>53189</td>\n",
              "      <td>53189</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>CONFINS</td>\n",
              "      <td>MG</td>\n",
              "      <td>SBCF</td>\n",
              "      <td>2015-03-14</td>\n",
              "      <td>07:20:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-14 07:20:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3099</th>\n",
              "      <td>53193</td>\n",
              "      <td>53193</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>CANARANA</td>\n",
              "      <td>MT</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-03-14</td>\n",
              "      <td>18:00:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-14 18:00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3100</th>\n",
              "      <td>53164</td>\n",
              "      <td>53164</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>PRINCESA ISABEL</td>\n",
              "      <td>PB</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-03-15</td>\n",
              "      <td>18:30:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-15 18:30:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3101</th>\n",
              "      <td>53151</td>\n",
              "      <td>53151</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>MAUÉS</td>\n",
              "      <td>AM</td>\n",
              "      <td>SWMW</td>\n",
              "      <td>2015-03-16</td>\n",
              "      <td>18:07:00</td>\n",
              "      <td>1</td>\n",
              "      <td>2015-03-16 18:07:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3102</th>\n",
              "      <td>53168</td>\n",
              "      <td>53168</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>PARÁ DE MINAS</td>\n",
              "      <td>MG</td>\n",
              "      <td>SNPA</td>\n",
              "      <td>2015-03-16</td>\n",
              "      <td>21:05:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-16 21:05:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3103</th>\n",
              "      <td>53169</td>\n",
              "      <td>53169</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>BELÉM</td>\n",
              "      <td>PA</td>\n",
              "      <td>SBBE</td>\n",
              "      <td>2015-03-19</td>\n",
              "      <td>03:25:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-19 03:25:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3104</th>\n",
              "      <td>53165</td>\n",
              "      <td>53165</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>SÃO DESIDÉRIO</td>\n",
              "      <td>BA</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-03-20</td>\n",
              "      <td>14:35:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-20 14:35:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3105</th>\n",
              "      <td>53188</td>\n",
              "      <td>53188</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>RJ</td>\n",
              "      <td>SBJR</td>\n",
              "      <td>2015-03-20</td>\n",
              "      <td>21:00:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-20 21:00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3106</th>\n",
              "      <td>53184</td>\n",
              "      <td>53184</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>PORTO UNIÃO</td>\n",
              "      <td>SC</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-03-22</td>\n",
              "      <td>13:44:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-22 13:44:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3107</th>\n",
              "      <td>53178</td>\n",
              "      <td>53178</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>DIAMANTINO</td>\n",
              "      <td>MT</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-03-23</td>\n",
              "      <td>17:15:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-23 17:15:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3108</th>\n",
              "      <td>53182</td>\n",
              "      <td>53182</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>SANTA LUZIA</td>\n",
              "      <td>MA</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-03-23</td>\n",
              "      <td>20:40:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-23 20:40:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3109</th>\n",
              "      <td>53166</td>\n",
              "      <td>53166</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>RIACHÃO DAS NEVES</td>\n",
              "      <td>BA</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-03-24</td>\n",
              "      <td>14:45:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-24 14:45:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3110</th>\n",
              "      <td>53170</td>\n",
              "      <td>53170</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>CONFINS</td>\n",
              "      <td>MG</td>\n",
              "      <td>SBCF</td>\n",
              "      <td>2015-03-24</td>\n",
              "      <td>17:57:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-24 17:57:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3111</th>\n",
              "      <td>53185</td>\n",
              "      <td>53185</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>CURITIBA</td>\n",
              "      <td>PR</td>\n",
              "      <td>SBCT</td>\n",
              "      <td>2015-03-24</td>\n",
              "      <td>23:01:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-24 23:01:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3112</th>\n",
              "      <td>53412</td>\n",
              "      <td>53412</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>MACAÉ</td>\n",
              "      <td>RJ</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-03-24</td>\n",
              "      <td>16:35:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-24 16:35:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3113</th>\n",
              "      <td>53194</td>\n",
              "      <td>53194</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>GUARACIABA DO NORTE</td>\n",
              "      <td>CE</td>\n",
              "      <td>SWBE</td>\n",
              "      <td>2015-03-26</td>\n",
              "      <td>20:30:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-26 20:30:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3114</th>\n",
              "      <td>53186</td>\n",
              "      <td>53186</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>BRASÍLIA</td>\n",
              "      <td>DF</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-03-27</td>\n",
              "      <td>14:55:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-27 14:55:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3115</th>\n",
              "      <td>53179</td>\n",
              "      <td>53179</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>CAIAPÔNIA</td>\n",
              "      <td>GO</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-03-28</td>\n",
              "      <td>10:30:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-28 10:30:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3116</th>\n",
              "      <td>53180</td>\n",
              "      <td>53180</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>ARAGUARI</td>\n",
              "      <td>MG</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-03-28</td>\n",
              "      <td>18:52:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-28 18:52:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3117</th>\n",
              "      <td>53190</td>\n",
              "      <td>53190</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>CAMPINAS</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBKP</td>\n",
              "      <td>2015-03-28</td>\n",
              "      <td>16:26:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-28 16:26:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3118</th>\n",
              "      <td>53212</td>\n",
              "      <td>53212</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>JUNDIAÍ</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBJD</td>\n",
              "      <td>2015-03-28</td>\n",
              "      <td>17:32:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-28 17:32:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3119</th>\n",
              "      <td>53213</td>\n",
              "      <td>53213</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>JUNDIAÍ</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBJD</td>\n",
              "      <td>2015-03-28</td>\n",
              "      <td>15:51:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-28 15:51:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3120</th>\n",
              "      <td>53181</td>\n",
              "      <td>53181</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>COLÍDER</td>\n",
              "      <td>MT</td>\n",
              "      <td>****</td>\n",
              "      <td>2015-03-29</td>\n",
              "      <td>20:17:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-29 20:17:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3121</th>\n",
              "      <td>53187</td>\n",
              "      <td>53187</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>JOINVILLE</td>\n",
              "      <td>SC</td>\n",
              "      <td>SBJV</td>\n",
              "      <td>2015-03-29</td>\n",
              "      <td>18:36:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-29 18:36:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3122</th>\n",
              "      <td>53211</td>\n",
              "      <td>53211</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>BAURU</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBBU</td>\n",
              "      <td>2015-03-30</td>\n",
              "      <td>19:40:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2015-03-30 19:40:00</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      codigo_ocorrencia  ...  ocorrencia_dia_hora\n",
              "3086              53183  ...  2015-03-02 23:00:00\n",
              "3087              53120  ...  2015-03-04 13:30:00\n",
              "3088              53109  ...  2015-03-05 13:50:00\n",
              "3089              53112  ...  2015-03-06 21:00:00\n",
              "3090              53152  ...  2015-03-10 11:30:00\n",
              "3091              53167  ...  2015-03-10 17:33:00\n",
              "3092              53596  ...  2015-03-10 21:35:00\n",
              "3093              53149  ...  2015-03-11 23:25:00\n",
              "3094              53148  ...  2015-03-12 12:40:00\n",
              "3095              53153  ...  2015-03-13 15:45:00\n",
              "3096              53154  ...  2015-03-13 14:40:00\n",
              "3097              53238  ...  2015-03-13 11:30:00\n",
              "3098              53189  ...  2015-03-14 07:20:00\n",
              "3099              53193  ...  2015-03-14 18:00:00\n",
              "3100              53164  ...  2015-03-15 18:30:00\n",
              "3101              53151  ...  2015-03-16 18:07:00\n",
              "3102              53168  ...  2015-03-16 21:05:00\n",
              "3103              53169  ...  2015-03-19 03:25:00\n",
              "3104              53165  ...  2015-03-20 14:35:00\n",
              "3105              53188  ...  2015-03-20 21:00:00\n",
              "3106              53184  ...  2015-03-22 13:44:00\n",
              "3107              53178  ...  2015-03-23 17:15:00\n",
              "3108              53182  ...  2015-03-23 20:40:00\n",
              "3109              53166  ...  2015-03-24 14:45:00\n",
              "3110              53170  ...  2015-03-24 17:57:00\n",
              "3111              53185  ...  2015-03-24 23:01:00\n",
              "3112              53412  ...  2015-03-24 16:35:00\n",
              "3113              53194  ...  2015-03-26 20:30:00\n",
              "3114              53186  ...  2015-03-27 14:55:00\n",
              "3115              53179  ...  2015-03-28 10:30:00\n",
              "3116              53180  ...  2015-03-28 18:52:00\n",
              "3117              53190  ...  2015-03-28 16:26:00\n",
              "3118              53212  ...  2015-03-28 17:32:00\n",
              "3119              53213  ...  2015-03-28 15:51:00\n",
              "3120              53181  ...  2015-03-29 20:17:00\n",
              "3121              53187  ...  2015-03-29 18:36:00\n",
              "3122              53211  ...  2015-03-30 19:40:00\n",
              "\n",
              "[37 rows x 10 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 39
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "wd2pm_oRc4H0",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "b5d814df-4957-430d-fd14-351f9773a987"
      },
      "source": [
        "df201503.count()"
      ],
      "execution_count": 40,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "codigo_ocorrencia           37\n",
              "codigo_ocorrencia2          37\n",
              "ocorrencia_classificacao    37\n",
              "ocorrencia_cidade           37\n",
              "ocorrencia_uf               37\n",
              "ocorrencia_aerodromo        37\n",
              "ocorrencia_dia              37\n",
              "ocorrencia_hora             37\n",
              "total_recomendacoes         37\n",
              "ocorrencia_dia_hora         37\n",
              "dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 40
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ivmNzgcRc6yV",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "8f55c987-76b9-46fb-e73e-4ca9a9ffe4b8"
      },
      "source": [
        "df201503.groupby(['ocorrencia_classificacao']).codigo_ocorrencia.count()"
      ],
      "execution_count": 41,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "ocorrencia_classificacao\n",
              "ACIDENTE           15\n",
              "INCIDENTE          17\n",
              "INCIDENTE GRAVE     5\n",
              "Name: codigo_ocorrencia, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 41
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "rl1hdRrDc8vO",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "a04d309e-62a8-47db-93fb-ea810e6736cf"
      },
      "source": [
        "df201503.groupby(['ocorrencia_classificacao']).ocorrencia_aerodromo.count()"
      ],
      "execution_count": 42,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "ocorrencia_classificacao\n",
              "ACIDENTE           15\n",
              "INCIDENTE          17\n",
              "INCIDENTE GRAVE     5\n",
              "Name: ocorrencia_aerodromo, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 42
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ULepmP7Rc-64",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "fce4e03f-b9ed-418c-e74d-f7561e3ed0fe"
      },
      "source": [
        "df201503.groupby(['ocorrencia_classificacao']).size()"
      ],
      "execution_count": 43,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "ocorrencia_classificacao\n",
              "ACIDENTE           15\n",
              "INCIDENTE          17\n",
              "INCIDENTE GRAVE     5\n",
              "dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 43
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "KrGsmM9idBoL",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "bf7140ee-be0c-49ca-f58f-a0bc3e0a6756"
      },
      "source": [
        "df201503.groupby(['ocorrencia_classificacao']).size().sort_values()"
      ],
      "execution_count": 44,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "ocorrencia_classificacao\n",
              "INCIDENTE GRAVE     5\n",
              "ACIDENTE           15\n",
              "INCIDENTE          17\n",
              "dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 44
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "G-1Cx8irdD1A",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "bb2ffdf2-52c5-4e01-f414-cfdcdf90552b"
      },
      "source": [
        "df201503.groupby(['ocorrencia_classificacao']).size().sort_values(ascending=False)"
      ],
      "execution_count": 45,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "ocorrencia_classificacao\n",
              "INCIDENTE          17\n",
              "ACIDENTE           15\n",
              "INCIDENTE GRAVE     5\n",
              "dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 45
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "kBUaZkA6dFy3",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 439
        },
        "outputId": "92b50e54-12ab-4963-9d98-b8edd1ddf8f3"
      },
      "source": [
        "filtro1 = df.ocorrencia_dia.dt.year == 2010\n",
        "filtro2 = df.ocorrencia_uf.isin(['SP','MG','ES','RJ'])\n",
        "dfsudeste2010 = df.loc[filtro1 & filtro2]\n",
        "dfsudeste2010"
      ],
      "execution_count": 46,
      "outputs": [
        {
          "output_type": "execute_result",
          "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",
              "      <th>ocorrencia_dia_hora</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",
              "      <td>2010-01-03 12:00:00</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",
              "      <td>2010-01-03 03:00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>39711</td>\n",
              "      <td>39711</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>PARÁ DE MINAS</td>\n",
              "      <td>MG</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-10</td>\n",
              "      <td>20:00:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2010-01-10 20:00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>40069</td>\n",
              "      <td>40069</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBMT</td>\n",
              "      <td>2010-01-10</td>\n",
              "      <td>14:50:00</td>\n",
              "      <td>8</td>\n",
              "      <td>2010-01-10 14:50:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>39809</td>\n",
              "      <td>39809</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>SP</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-01-15</td>\n",
              "      <td>15:00:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2010-01-15 15:00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>541</th>\n",
              "      <td>43722</td>\n",
              "      <td>43722</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>CAJOBI</td>\n",
              "      <td>SP</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-12-23</td>\n",
              "      <td>11:00:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2010-12-23 11:00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>544</th>\n",
              "      <td>43548</td>\n",
              "      <td>43548</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBSP</td>\n",
              "      <td>2010-12-26</td>\n",
              "      <td>22:10:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2010-12-26 22:10:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>548</th>\n",
              "      <td>43724</td>\n",
              "      <td>43724</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>COSMÓPOLIS</td>\n",
              "      <td>SP</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-12-29</td>\n",
              "      <td>12:00:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2010-12-29 12:00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>550</th>\n",
              "      <td>43730</td>\n",
              "      <td>43730</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>VITÓRIA</td>\n",
              "      <td>ES</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-12-30</td>\n",
              "      <td>18:10:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2010-12-30 18:10:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>551</th>\n",
              "      <td>43975</td>\n",
              "      <td>43975</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>ARRAIAL DO CABO</td>\n",
              "      <td>RJ</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-12-30</td>\n",
              "      <td>14:28:00</td>\n",
              "      <td>0</td>\n",
              "      <td>2010-12-30 14:28:00</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>228 rows × 10 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "     codigo_ocorrencia  ...  ocorrencia_dia_hora\n",
              "0                40211  ...  2010-01-03 12:00:00\n",
              "2                40351  ...  2010-01-03 03:00:00\n",
              "9                39711  ...  2010-01-10 20:00:00\n",
              "11               40069  ...  2010-01-10 14:50:00\n",
              "16               39809  ...  2010-01-15 15:00:00\n",
              "..                 ...  ...                  ...\n",
              "541              43722  ...  2010-12-23 11:00:00\n",
              "544              43548  ...  2010-12-26 22:10:00\n",
              "548              43724  ...  2010-12-29 12:00:00\n",
              "550              43730  ...  2010-12-30 18:10:00\n",
              "551              43975  ...  2010-12-30 14:28:00\n",
              "\n",
              "[228 rows x 10 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 46
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "NwyrjxtFdJQ9",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "795744f0-3e7f-4053-a0a5-29989409e89e"
      },
      "source": [
        "dfsudeste2010.groupby(['ocorrencia_classificacao']).size()"
      ],
      "execution_count": 47,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "ocorrencia_classificacao\n",
              "ACIDENTE            40\n",
              "INCIDENTE          170\n",
              "INCIDENTE GRAVE     18\n",
              "dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 47
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "U44pSU4edL1l",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "e4693556-049b-4ee7-92d8-4a87645c7eed"
      },
      "source": [
        "dfsudeste2010.count()"
      ],
      "execution_count": 48,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "codigo_ocorrencia           228\n",
              "codigo_ocorrencia2          228\n",
              "ocorrencia_classificacao    228\n",
              "ocorrencia_cidade           228\n",
              "ocorrencia_uf               228\n",
              "ocorrencia_aerodromo        228\n",
              "ocorrencia_dia              228\n",
              "ocorrencia_hora             228\n",
              "total_recomendacoes         228\n",
              "ocorrencia_dia_hora         228\n",
              "dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 48
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "PipjBIZidN9S",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "75027986-a5f0-45c0-e579-974016b810eb"
      },
      "source": [
        "dfsudeste2010.groupby(['ocorrencia_uf', 'ocorrencia_classificacao']).size()"
      ],
      "execution_count": 49,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "ocorrencia_uf  ocorrencia_classificacao\n",
              "ES             INCIDENTE                    5\n",
              "MG             ACIDENTE                     7\n",
              "               INCIDENTE                   39\n",
              "               INCIDENTE GRAVE              5\n",
              "RJ             ACIDENTE                     9\n",
              "               INCIDENTE                   52\n",
              "               INCIDENTE GRAVE              4\n",
              "SP             ACIDENTE                    24\n",
              "               INCIDENTE                   74\n",
              "               INCIDENTE GRAVE              9\n",
              "dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 49
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "vAewKG5bdQTI",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "3709809a-6edd-4c8e-e286-cf5a64b8973d"
      },
      "source": [
        "dfsudeste2010.groupby(['ocorrencia_cidade']).size().sort_values(ascending=False)"
      ],
      "execution_count": 50,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "ocorrencia_cidade\n",
              "RIO DE JANEIRO           47\n",
              "SÃO PAULO                33\n",
              "GUARULHOS                18\n",
              "BELO HORIZONTE           17\n",
              "CAMPINAS                 13\n",
              "MACAÉ                    12\n",
              "CONFINS                   7\n",
              "UBERLÂNDIA                5\n",
              "VITÓRIA                   4\n",
              "JUIZ DE FORA              4\n",
              "SÃO JOSÉ DO RIO PRETO     3\n",
              "SÃO JOSÉ DOS CAMPOS       3\n",
              "MARÍLIA                   3\n",
              "ARARAQUARA                2\n",
              "MONTES CLAROS             2\n",
              "CAMPOS DOS GOYTACAZES     2\n",
              "DIVINÓPOLIS               2\n",
              "IPATINGA                  2\n",
              "ITANHAÉM                  2\n",
              "JUNDIAÍ                   2\n",
              "POÇOS DE CALDAS           2\n",
              "RIBEIRÃO PRETO            2\n",
              "SOROCABA                  2\n",
              "UBERABA                   2\n",
              "BAURU                     2\n",
              "AREALVA                   2\n",
              "BOITUVA                   1\n",
              "BOCAINA                   1\n",
              "BOM JESUS DO AMPARO       1\n",
              "BOM JESUS DO GALHO        1\n",
              "BEBEDOURO                 1\n",
              "BRAGANÇA PAULISTA         1\n",
              "BROTAS                    1\n",
              "CAJOBI                    1\n",
              "ARRAIAL DO CABO           1\n",
              "CAMANDUCAIA               1\n",
              "TIMÓTEO                   1\n",
              "ARAÇATUBA                 1\n",
              "CASIMIRO DE ABREU         1\n",
              "SANTOS                    1\n",
              "COROMANDEL                1\n",
              "OLÍMPIA                   1\n",
              "RESENDE                   1\n",
              "POUSO ALEGRE              1\n",
              "PIRASSUNUNGA              1\n",
              "PIRACICABA                1\n",
              "PIACATU                   1\n",
              "PENÁPOLIS                 1\n",
              "PARÁ DE MINAS             1\n",
              "NOVO HORIZONTE            1\n",
              "COSMÓPOLIS                1\n",
              "MANGARATIBA               1\n",
              "LINHARES                  1\n",
              "SÃO BERNARDO DO CAMPO     1\n",
              "ITÁPOLIS                  1\n",
              "IPERÓ                     1\n",
              "SERRA NEGRA               1\n",
              "DIAMANTINA                1\n",
              "AMERICANA                 1\n",
              "dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 50
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "a8-hBkBVdSgi",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 162
        },
        "outputId": "5b6abaf7-b921-4e45-edc3-16408d517329"
      },
      "source": [
        "filtro1 = dfsudeste2010.ocorrencia_cidade == 'RIO DE JANEIRO'\n",
        "filtro2 = dfsudeste2010.total_recomendacoes > 0\n",
        "dfsudeste2010.loc[filtro1 & filtro2]"
      ],
      "execution_count": 51,
      "outputs": [
        {
          "output_type": "execute_result",
          "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",
              "      <th>ocorrencia_dia_hora</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>119</th>\n",
              "      <td>40190</td>\n",
              "      <td>40190</td>\n",
              "      <td>INCIDENTE</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>RJ</td>\n",
              "      <td>SBGL</td>\n",
              "      <td>2010-04-06</td>\n",
              "      <td>02:35:00</td>\n",
              "      <td>3</td>\n",
              "      <td>2010-04-06 02:35:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>274</th>\n",
              "      <td>41750</td>\n",
              "      <td>41750</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>RJ</td>\n",
              "      <td>SBJR</td>\n",
              "      <td>2010-07-12</td>\n",
              "      <td>19:53:00</td>\n",
              "      <td>3</td>\n",
              "      <td>2010-07-12 19:53:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>326</th>\n",
              "      <td>42250</td>\n",
              "      <td>42250</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>RIO DE JANEIRO</td>\n",
              "      <td>RJ</td>\n",
              "      <td>SBRJ</td>\n",
              "      <td>2010-08-12</td>\n",
              "      <td>12:26:00</td>\n",
              "      <td>19</td>\n",
              "      <td>2010-08-12 12:26:00</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "     codigo_ocorrencia  ...  ocorrencia_dia_hora\n",
              "119              40190  ...  2010-04-06 02:35:00\n",
              "274              41750  ...  2010-07-12 19:53:00\n",
              "326              42250  ...  2010-08-12 12:26:00\n",
              "\n",
              "[3 rows x 10 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 51
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "FPOWlbLxdVNr",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "d8e5e9f2-d474-4cdb-c451-5b2cb8e9b6af"
      },
      "source": [
        "filtro = dfsudeste2010.ocorrencia_cidade == 'RIO DE JANEIRO'\n",
        "dfsudeste2010.loc[filtro].total_recomendacoes.sum()"
      ],
      "execution_count": 52,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "25"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 52
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "OO6xfmJBdXwo",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "5deaa881-3240-4c3c-ea02-224082db4d9d"
      },
      "source": [
        "dfsudeste2010.groupby(['ocorrencia_aerodromo'], dropna=False).total_recomendacoes.sum()"
      ],
      "execution_count": 53,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "ocorrencia_aerodromo\n",
              "****    45\n",
              "SBAE     0\n",
              "SBAQ     0\n",
              "SBBH     0\n",
              "SBBP     9\n",
              "SBBU     0\n",
              "SBCF     0\n",
              "SBGL     3\n",
              "SBGR     0\n",
              "SBIP     0\n",
              "SBJD     7\n",
              "SBJR     3\n",
              "SBKP     0\n",
              "SBME     0\n",
              "SBMK     0\n",
              "SBML     0\n",
              "SBMT    27\n",
              "SBPC     0\n",
              "SBPR     1\n",
              "SBRJ    19\n",
              "SBRP     0\n",
              "SBSJ     0\n",
              "SBSP     0\n",
              "SBSR     0\n",
              "SBUL     0\n",
              "SBUR     0\n",
              "SBVT     0\n",
              "SDAM     0\n",
              "SDOI     1\n",
              "SDPW     0\n",
              "SDPY     0\n",
              "SNDT     0\n",
              "SNDV     0\n",
              "SNXT     0\n",
              "Name: total_recomendacoes, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 53
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "wXagjKCsdaFq",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "97f26a9a-029f-4398-d470-5fd6264cc65a"
      },
      "source": [
        "dfsudeste2010.groupby(['ocorrencia_cidade']).total_recomendacoes.sum()"
      ],
      "execution_count": 54,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "ocorrencia_cidade\n",
              "AMERICANA                 0\n",
              "ARARAQUARA                0\n",
              "ARAÇATUBA                 0\n",
              "AREALVA                   0\n",
              "ARRAIAL DO CABO           0\n",
              "BAURU                     0\n",
              "BEBEDOURO                 0\n",
              "BELO HORIZONTE            2\n",
              "BOCAINA                   0\n",
              "BOITUVA                   1\n",
              "BOM JESUS DO AMPARO       0\n",
              "BOM JESUS DO GALHO        1\n",
              "BRAGANÇA PAULISTA         9\n",
              "BROTAS                    0\n",
              "CAJOBI                    0\n",
              "CAMANDUCAIA               9\n",
              "CAMPINAS                  0\n",
              "CAMPOS DOS GOYTACAZES     0\n",
              "CASIMIRO DE ABREU         0\n",
              "CONFINS                   0\n",
              "COROMANDEL                0\n",
              "COSMÓPOLIS                0\n",
              "DIAMANTINA                0\n",
              "DIVINÓPOLIS               0\n",
              "GUARULHOS                 0\n",
              "IPATINGA                  0\n",
              "IPERÓ                     3\n",
              "ITANHAÉM                  1\n",
              "ITÁPOLIS                  0\n",
              "JUIZ DE FORA              0\n",
              "JUNDIAÍ                   7\n",
              "LINHARES                  0\n",
              "MACAÉ                     0\n",
              "MANGARATIBA               0\n",
              "MARÍLIA                   0\n",
              "MONTES CLAROS             0\n",
              "NOVO HORIZONTE            3\n",
              "OLÍMPIA                   0\n",
              "PARÁ DE MINAS             0\n",
              "PENÁPOLIS                 0\n",
              "PIACATU                   0\n",
              "PIRACICABA                0\n",
              "PIRASSUNUNGA              0\n",
              "POUSO ALEGRE              0\n",
              "POÇOS DE CALDAS           0\n",
              "RESENDE                   8\n",
              "RIBEIRÃO PRETO            0\n",
              "RIO DE JANEIRO           25\n",
              "SANTOS                    0\n",
              "SERRA NEGRA               0\n",
              "SOROCABA                  0\n",
              "SÃO BERNARDO DO CAMPO     2\n",
              "SÃO JOSÉ DO RIO PRETO     0\n",
              "SÃO JOSÉ DOS CAMPOS       0\n",
              "SÃO PAULO                41\n",
              "TIMÓTEO                   3\n",
              "UBERABA                   0\n",
              "UBERLÂNDIA                0\n",
              "VITÓRIA                   0\n",
              "Name: total_recomendacoes, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 54
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "5qVQoQpGdc0X",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "de4244ab-7b94-4796-8534-8ff6482e9863"
      },
      "source": [
        "filtro = dfsudeste2010.total_recomendacoes > 0\n",
        "dfsudeste2010.loc[filtro].groupby(['ocorrencia_cidade']).total_recomendacoes.sum().sort_values()"
      ],
      "execution_count": 55,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "ocorrencia_cidade\n",
              "BOITUVA                   1\n",
              "BOM JESUS DO GALHO        1\n",
              "ITANHAÉM                  1\n",
              "BELO HORIZONTE            2\n",
              "SÃO BERNARDO DO CAMPO     2\n",
              "IPERÓ                     3\n",
              "NOVO HORIZONTE            3\n",
              "TIMÓTEO                   3\n",
              "JUNDIAÍ                   7\n",
              "RESENDE                   8\n",
              "BRAGANÇA PAULISTA         9\n",
              "CAMANDUCAIA               9\n",
              "RIO DE JANEIRO           25\n",
              "SÃO PAULO                41\n",
              "Name: total_recomendacoes, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 55
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "3EqNKlt9dg0j",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "f5f6ca97-6ae4-4097-d5b4-d7700cc7dac1"
      },
      "source": [
        "dfsudeste2010.loc[filtro].groupby(['ocorrencia_cidade', dfsudeste2010.ocorrencia_dia.dt.month]).total_recomendacoes.sum()"
      ],
      "execution_count": 56,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "ocorrencia_cidade      ocorrencia_dia\n",
              "BELO HORIZONTE         2                  1\n",
              "                       3                  1\n",
              "BOITUVA                7                  1\n",
              "BOM JESUS DO GALHO     12                 1\n",
              "BRAGANÇA PAULISTA      11                 9\n",
              "CAMANDUCAIA            7                  9\n",
              "IPERÓ                  1                  3\n",
              "ITANHAÉM               9                  1\n",
              "JUNDIAÍ                5                  5\n",
              "                       6                  2\n",
              "NOVO HORIZONTE         7                  3\n",
              "RESENDE                4                  8\n",
              "RIO DE JANEIRO         4                  3\n",
              "                       7                  3\n",
              "                       8                 19\n",
              "SÃO BERNARDO DO CAMPO  1                  2\n",
              "SÃO PAULO              1                  8\n",
              "                       2                 14\n",
              "                       6                  2\n",
              "                       11                 6\n",
              "                       12                11\n",
              "TIMÓTEO                2                  3\n",
              "Name: total_recomendacoes, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 56
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "zkwH7rv6djfB",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 255
        },
        "outputId": "6f13ab59-a31b-4d8c-8e0d-30de9c7ded25"
      },
      "source": [
        "filtro1 = dfsudeste2010.total_recomendacoes > 0\n",
        "filtro2 = dfsudeste2010.ocorrencia_cidade == 'SÃO PAULO'\n",
        "dfsudeste2010.loc[filtro1 & filtro2]"
      ],
      "execution_count": 57,
      "outputs": [
        {
          "output_type": "execute_result",
          "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",
              "      <th>ocorrencia_dia_hora</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>40069</td>\n",
              "      <td>40069</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBMT</td>\n",
              "      <td>2010-01-10</td>\n",
              "      <td>14:50:00</td>\n",
              "      <td>8</td>\n",
              "      <td>2010-01-10 14:50:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>58</th>\n",
              "      <td>39275</td>\n",
              "      <td>39275</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>SP</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-02-10</td>\n",
              "      <td>09:03:00</td>\n",
              "      <td>3</td>\n",
              "      <td>2010-02-10 09:03:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>63</th>\n",
              "      <td>39992</td>\n",
              "      <td>39992</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBMT</td>\n",
              "      <td>2010-02-17</td>\n",
              "      <td>20:07:00</td>\n",
              "      <td>11</td>\n",
              "      <td>2010-02-17 20:07:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>219</th>\n",
              "      <td>41411</td>\n",
              "      <td>41411</td>\n",
              "      <td>INCIDENTE GRAVE</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBMT</td>\n",
              "      <td>2010-06-08</td>\n",
              "      <td>19:30:00</td>\n",
              "      <td>2</td>\n",
              "      <td>2010-06-08 19:30:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>469</th>\n",
              "      <td>43450</td>\n",
              "      <td>43450</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>SP</td>\n",
              "      <td>SBMT</td>\n",
              "      <td>2010-11-04</td>\n",
              "      <td>10:55:00</td>\n",
              "      <td>6</td>\n",
              "      <td>2010-11-04 10:55:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>530</th>\n",
              "      <td>43471</td>\n",
              "      <td>43471</td>\n",
              "      <td>ACIDENTE</td>\n",
              "      <td>SÃO PAULO</td>\n",
              "      <td>SP</td>\n",
              "      <td>****</td>\n",
              "      <td>2010-12-14</td>\n",
              "      <td>20:15:00</td>\n",
              "      <td>11</td>\n",
              "      <td>2010-12-14 20:15:00</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "     codigo_ocorrencia  ...  ocorrencia_dia_hora\n",
              "11               40069  ...  2010-01-10 14:50:00\n",
              "58               39275  ...  2010-02-10 09:03:00\n",
              "63               39992  ...  2010-02-17 20:07:00\n",
              "219              41411  ...  2010-06-08 19:30:00\n",
              "469              43450  ...  2010-11-04 10:55:00\n",
              "530              43471  ...  2010-12-14 20:15:00\n",
              "\n",
              "[6 rows x 10 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 57
        }
      ]
    }
  ]
}