Pandas-DataSet-VolumeDeTrafego.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Projeto_Final_G03_VolTrafego2019 (Pedagio) - PANDAS.ipynb",
      "provenance": [],
      "collapsed_sections": [],
      "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/Isiumlord/ProjetoFinal-AcidentesTerrestres/blob/main/DataSet-VolumeDeTrafego-Pandas.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "rcyu5gvEnlKl"
      },
      "source": [
        "#1 - IMPORTANDO PANDAS, JSON E BIBLIOTECAS\n",
        "\n",
        "import json\n",
        "import pandas as pd\n",
        "import numpy as np\n",
        "from pandas import json_normalize"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "tgqgKp0bmqGU",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "02312233-70bd-465b-d7a1-592f327e19de"
      },
      "source": [
        "#2 - INTEGRANDO COM A GCP\n",
        "\n",
        "from google.colab import auth\n",
        "auth.authenticate_user()\n",
        "project_id = 'projeto-final-grupo03'\n",
        "!gcloud config set project projeto-final-grupo03"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Updated property [core/project].\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "pcHgRdvaoQBr",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "502999ff-f583-4d8d-9e30-4130075b0b45"
      },
      "source": [
        "#3 - IMPORTANDO ARQUIVO DA GCP PARA O COLAB\n",
        "\n",
        "!gsutil cp gs://datasets_gp03/VolTrafego2019.json /tmp/VolTrafego2019.json\n",
        "!gsutil cp gs://datasets_gp03/VolTrafego2020.json /tmp/VolTrafego2020.json\n",
        "#Print do resultado para garantir que a transferencia funcionou.\n",
        "#!cat /tmp/VolTrafego2019.json\n",
        "#!cat /tmp/VolTrafego2020.json"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Copying gs://datasets_gp03/VolTrafego2019.json...\n",
            "- [1 files][  6.5 MiB/  6.5 MiB]                                                \n",
            "Operation completed over 1 objects/6.5 MiB.                                      \n",
            "Copying gs://datasets_gp03/VolTrafego2020.json...\n",
            "- [1 files][  6.8 MiB/  6.8 MiB]                                                \n",
            "Operation completed over 1 objects/6.8 MiB.                                      \n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "wSaBvGCN_vSG"
      },
      "source": [
        "#4 - IMPORTANDO O DOCUMENTO E CODIFICANDO DADOS\n",
        "\n",
        "'''with open(\"tmp/VolTrafego2019.json\") as grades:    \n",
        "  dados = json.load(grades)'''\n",
        "\n",
        "df1 = pd.read_json(\"/tmp/VolTrafego2019.json\")\n",
        "df2 = pd.read_json(\"/tmp/VolTrafego2020.json\")"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "EYQ62LZT3vmH",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 423
        },
        "outputId": "63af8722-1701-4900-d869-0de8c93de052"
      },
      "source": [
        "#5 - CONSULTANDO DATAFRAME EM JSON PARA VER SE OS DADOS CARREGARAM DE FORMA CORRETA\n",
        "\n",
        "df1"
      ],
      "execution_count": null,
      "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>empresas_habilitadas_regular</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>{'Concessionaria': 'NOVADUTRA', 'mes_ano': '01...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>{'Concessionaria': 'NOVADUTRA', 'mes_ano': '01...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>{'Concessionaria': 'NOVADUTRA', 'mes_ano': '01...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>{'Concessionaria': 'NOVADUTRA', 'mes_ano': '01...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>{'Concessionaria': 'NOVADUTRA', 'mes_ano': '01...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33631</th>\n",
              "      <td>{'Concessionaria': 'AUTOPISTA FERNÃO DIAS', 'm...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33632</th>\n",
              "      <td>{'Concessionaria': 'AUTOPISTA FERNÃO DIAS', 'm...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33633</th>\n",
              "      <td>{'Concessionaria': 'AUTOPISTA FERNÃO DIAS', 'm...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33634</th>\n",
              "      <td>{'Concessionaria': 'AUTOPISTA FERNÃO DIAS', 'm...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33635</th>\n",
              "      <td>{'Concessionaria': 'AUTOPISTA FERNÃO DIAS', 'm...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>33636 rows × 1 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                            empresas_habilitadas_regular\n",
              "0      {'Concessionaria': 'NOVADUTRA', 'mes_ano': '01...\n",
              "1      {'Concessionaria': 'NOVADUTRA', 'mes_ano': '01...\n",
              "2      {'Concessionaria': 'NOVADUTRA', 'mes_ano': '01...\n",
              "3      {'Concessionaria': 'NOVADUTRA', 'mes_ano': '01...\n",
              "4      {'Concessionaria': 'NOVADUTRA', 'mes_ano': '01...\n",
              "...                                                  ...\n",
              "33631  {'Concessionaria': 'AUTOPISTA FERNÃO DIAS', 'm...\n",
              "33632  {'Concessionaria': 'AUTOPISTA FERNÃO DIAS', 'm...\n",
              "33633  {'Concessionaria': 'AUTOPISTA FERNÃO DIAS', 'm...\n",
              "33634  {'Concessionaria': 'AUTOPISTA FERNÃO DIAS', 'm...\n",
              "33635  {'Concessionaria': 'AUTOPISTA FERNÃO DIAS', 'm...\n",
              "\n",
              "[33636 rows x 1 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "eO2qQ5v8AB07"
      },
      "source": [
        "#6 - NORMALIZANDO DADOS CONTIDOS NOS ARQUIVOS JSON\n",
        "\n",
        "df1 = pd.json_normalize(df1[\"empresas_habilitadas_regular\"])\n",
        "df2 = pd.json_normalize(df2[\"empresas_habilitadas_regular\"])"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ifga0RpyfV30",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "c1b5aaff-0574-4a51-c78e-cfa59af734ab"
      },
      "source": [
        "#7 - CONSULTANDO TIPO DE DADOS DO DATAFRAME\n",
        "\n",
        "df1.info()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 33636 entries, 0 to 33635\n",
            "Data columns (total 7 columns):\n",
            " #   Column           Non-Null Count  Dtype \n",
            "---  ------           --------------  ----- \n",
            " 0   Concessionaria   33636 non-null  object\n",
            " 1   mes_ano          33636 non-null  object\n",
            " 2   Sentido          33636 non-null  object\n",
            " 3   Praca            33636 non-null  object\n",
            " 4   Categoria        33636 non-null  object\n",
            " 5   Tipo_de_veiculo  33636 non-null  object\n",
            " 6   Volume_total     33636 non-null  object\n",
            "dtypes: object(7)\n",
            "memory usage: 1.8+ MB\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "_-k5ZdW1e-J-"
      },
      "source": [
        "#8 - NORMALIZANDO TIPO DATE NO DATAFRAME1\n",
        "\n",
        "df1[\"mes_ano\"] = pd.to_datetime(df1[\"mes_ano\"], dayfirst=True)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "NrXbbUfUfTAA"
      },
      "source": [
        "#9 - NORMALIZANDO TIPO DATE NO DATAFRAME2\n",
        "\n",
        "df2[\"mes_ano\"] = pd.to_datetime(df2[\"mes_ano\"], dayfirst=True)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "N8M02LA546jU"
      },
      "source": [
        "#10 - CONCATENANDO DATAFRAMES\n",
        "\n",
        "frames = [df1, df2]\n",
        "df = pd.concat(frames)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "HDpXivMpASrq",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 423
        },
        "outputId": "133ba982-6d4f-4b3a-9736-f81827af3c05"
      },
      "source": [
        "#11 - VISUALIZANDO DATAFRAME\n",
        "\n",
        "df"
      ],
      "execution_count": null,
      "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>Concessionaria</th>\n",
              "      <th>mes_ano</th>\n",
              "      <th>Sentido</th>\n",
              "      <th>Praca</th>\n",
              "      <th>Categoria</th>\n",
              "      <th>Tipo_de_veiculo</th>\n",
              "      <th>Volume_total</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-01-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 01 BR-116/SP km 204,50</td>\n",
              "      <td>Categoria 1</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>640429</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-01-01</td>\n",
              "      <td>Norte</td>\n",
              "      <td>Praça 01 BR-116/SP km 204,50</td>\n",
              "      <td>Categoria 1</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>787419</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-02-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 01 BR-116/SP km 204,50</td>\n",
              "      <td>Categoria 1</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>511718</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-02-01</td>\n",
              "      <td>Norte</td>\n",
              "      <td>Praça 01 BR-116/SP km 204,50</td>\n",
              "      <td>Categoria 1</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>638796</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-03-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 01 BR-116/SP km 204,50</td>\n",
              "      <td>Categoria 1</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>579422</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35538</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 06 BR-381/MG km 659</td>\n",
              "      <td>Outros</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>16137</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35539</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Norte</td>\n",
              "      <td>Praça 07 BR-381/MG km 596,935</td>\n",
              "      <td>Outros</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>15141</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35540</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 07 BR-381/MG km 596,935</td>\n",
              "      <td>Outros</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>15863</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35541</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Norte</td>\n",
              "      <td>Praça 08 BR-381/MG km 546</td>\n",
              "      <td>Outros</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>14362</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35542</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 08 BR-381/MG km 546</td>\n",
              "      <td>Outros</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>14988</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>69179 rows × 7 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "              Concessionaria    mes_ano  ... Tipo_de_veiculo Volume_total\n",
              "0                  NOVADUTRA 2019-01-01  ...         Passeio       640429\n",
              "1                  NOVADUTRA 2019-01-01  ...         Passeio       787419\n",
              "2                  NOVADUTRA 2019-02-01  ...         Passeio       511718\n",
              "3                  NOVADUTRA 2019-02-01  ...         Passeio       638796\n",
              "4                  NOVADUTRA 2019-03-01  ...         Passeio       579422\n",
              "...                      ...        ...  ...             ...          ...\n",
              "35538  AUTOPISTA FERNÃO DIAS 2020-12-01  ...       Comercial        16137\n",
              "35539  AUTOPISTA FERNÃO DIAS 2020-12-01  ...       Comercial        15141\n",
              "35540  AUTOPISTA FERNÃO DIAS 2020-12-01  ...       Comercial        15863\n",
              "35541  AUTOPISTA FERNÃO DIAS 2020-12-01  ...       Comercial        14362\n",
              "35542  AUTOPISTA FERNÃO DIAS 2020-12-01  ...       Comercial        14988\n",
              "\n",
              "[69179 rows x 7 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 12
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "cji8j43ZLfRc",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "5d9902f8-5c0e-4d44-ce9b-301a704abb8b"
      },
      "source": [
        "#12 - ANALISANDO O TIPO DE DADOS (STRING, INT, FLOAT)\n",
        "\n",
        "df.dtypes"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Concessionaria             object\n",
              "mes_ano            datetime64[ns]\n",
              "Sentido                    object\n",
              "Praca                      object\n",
              "Categoria                  object\n",
              "Tipo_de_veiculo            object\n",
              "Volume_total               object\n",
              "dtype: object"
            ]
          },
          "metadata": {},
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Yul2jFbfhzb7"
      },
      "source": [
        "#13 - EDITANDO TIPOS DE DADOS DO DATAFRAME\n",
        "\n",
        "df.Concessionaria = df.Concessionaria.convert_dtypes(convert_string=True)\n",
        "df.Sentido = df.Sentido.convert_dtypes(convert_string=True)\n",
        "df.Praca = df.Praca.convert_dtypes(convert_string=True)\n",
        "df.Categoria = df.Categoria.convert_dtypes(convert_string=True)\n",
        "df.Tipo_de_veiculo = df.Tipo_de_veiculo.convert_dtypes(convert_string=True)\n",
        "df.Volume_total = df.Volume_total.convert_dtypes(convert_integer=True)\n"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "tVtHanFuidZu",
        "outputId": "f475668a-ab10-4b3c-9e28-2afef8db3b56"
      },
      "source": [
        "#14 - ANALISANDO O TIPO DE DADOS (STRING, INT, FLOAT) PARA VER SE AS TROCAS DERAM CERTO\n",
        "\n",
        "df.info()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "Int64Index: 69179 entries, 0 to 35542\n",
            "Data columns (total 7 columns):\n",
            " #   Column           Non-Null Count  Dtype         \n",
            "---  ------           --------------  -----         \n",
            " 0   Concessionaria   69179 non-null  string        \n",
            " 1   mes_ano          69179 non-null  datetime64[ns]\n",
            " 2   Sentido          69179 non-null  string        \n",
            " 3   Praca            69179 non-null  string        \n",
            " 4   Categoria        69179 non-null  string        \n",
            " 5   Tipo_de_veiculo  69179 non-null  string        \n",
            " 6   Volume_total     69179 non-null  object        \n",
            "dtypes: datetime64[ns](1), object(1), string(5)\n",
            "memory usage: 4.2+ MB\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "kAPCD_LVy9r5"
      },
      "source": [
        "#16 - CONVERTENDO O VALOR DA COLUNA \"Volume Total\" DE OBJETO PARA NÚMERICO\n",
        "\n",
        "df['Volume_total'] = pd.to_numeric(df['Volume_total'],errors = 'coerce')"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "F8uzvQP12KXK",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "bacb7159-7300-4d0e-97d9-5c465b0862de"
      },
      "source": [
        "#17 - VERIFICANDO AS TROCAS DOS TIPOS DE DADOS\n",
        "\n",
        "df.info()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "Int64Index: 69179 entries, 0 to 35542\n",
            "Data columns (total 7 columns):\n",
            " #   Column           Non-Null Count  Dtype         \n",
            "---  ------           --------------  -----         \n",
            " 0   Concessionaria   69179 non-null  string        \n",
            " 1   mes_ano          69179 non-null  datetime64[ns]\n",
            " 2   Sentido          69179 non-null  string        \n",
            " 3   Praca            69179 non-null  string        \n",
            " 4   Categoria        69179 non-null  string        \n",
            " 5   Tipo_de_veiculo  69179 non-null  string        \n",
            " 6   Volume_total     68108 non-null  float64       \n",
            "dtypes: datetime64[ns](1), float64(1), string(5)\n",
            "memory usage: 4.2 MB\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "k3kDGFb4MGsU"
      },
      "source": [
        "#18 - BACKUP DE SEGURANÇA CASO QUALQUER EDIÇÃO SEJA EQUIVOCADA\n",
        "\n",
        "df = df.copy()"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "36gk1Gtn2Q37",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 423
        },
        "outputId": "5ea56ae5-d8ff-4fa3-bfbd-899b80a9fe0d"
      },
      "source": [
        "#19 - VISUALIZANDO DATAFRAME\n",
        "\n",
        "df"
      ],
      "execution_count": null,
      "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>Concessionaria</th>\n",
              "      <th>mes_ano</th>\n",
              "      <th>Sentido</th>\n",
              "      <th>Praca</th>\n",
              "      <th>Categoria</th>\n",
              "      <th>Tipo_de_veiculo</th>\n",
              "      <th>Volume_total</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-01-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 01 BR-116/SP km 204,50</td>\n",
              "      <td>Categoria 1</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>640429.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-01-01</td>\n",
              "      <td>Norte</td>\n",
              "      <td>Praça 01 BR-116/SP km 204,50</td>\n",
              "      <td>Categoria 1</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>787419.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-02-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 01 BR-116/SP km 204,50</td>\n",
              "      <td>Categoria 1</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>511718.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-02-01</td>\n",
              "      <td>Norte</td>\n",
              "      <td>Praça 01 BR-116/SP km 204,50</td>\n",
              "      <td>Categoria 1</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>638796.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-03-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 01 BR-116/SP km 204,50</td>\n",
              "      <td>Categoria 1</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>579422.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35538</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 06 BR-381/MG km 659</td>\n",
              "      <td>Outros</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>16137.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35539</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Norte</td>\n",
              "      <td>Praça 07 BR-381/MG km 596,935</td>\n",
              "      <td>Outros</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>15141.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35540</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 07 BR-381/MG km 596,935</td>\n",
              "      <td>Outros</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>15863.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35541</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Norte</td>\n",
              "      <td>Praça 08 BR-381/MG km 546</td>\n",
              "      <td>Outros</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>14362.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35542</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 08 BR-381/MG km 546</td>\n",
              "      <td>Outros</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>14988.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>69179 rows × 7 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "              Concessionaria    mes_ano  ... Tipo_de_veiculo Volume_total\n",
              "0                  NOVADUTRA 2019-01-01  ...         Passeio     640429.0\n",
              "1                  NOVADUTRA 2019-01-01  ...         Passeio     787419.0\n",
              "2                  NOVADUTRA 2019-02-01  ...         Passeio     511718.0\n",
              "3                  NOVADUTRA 2019-02-01  ...         Passeio     638796.0\n",
              "4                  NOVADUTRA 2019-03-01  ...         Passeio     579422.0\n",
              "...                      ...        ...  ...             ...          ...\n",
              "35538  AUTOPISTA FERNÃO DIAS 2020-12-01  ...       Comercial      16137.0\n",
              "35539  AUTOPISTA FERNÃO DIAS 2020-12-01  ...       Comercial      15141.0\n",
              "35540  AUTOPISTA FERNÃO DIAS 2020-12-01  ...       Comercial      15863.0\n",
              "35541  AUTOPISTA FERNÃO DIAS 2020-12-01  ...       Comercial      14362.0\n",
              "35542  AUTOPISTA FERNÃO DIAS 2020-12-01  ...       Comercial      14988.0\n",
              "\n",
              "[69179 rows x 7 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 19
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "gDe6B2oHCmUr"
      },
      "source": [
        "#20 - TROCANDO NOME DA COLUNA \"mes_ano\" - df.rename(columns={\"NomeQueQueroMudar\": \"NomeNovo\"}) + inplace=True\n",
        "\n",
        "df.rename(columns={\"mes_ano\": \"Data\"}, inplace=True)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "TdK2I0ahMNpC",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "8edab54d-e47c-4e74-cd12-038083564d9c"
      },
      "source": [
        "#21 - ANALIZANDO DADOS DAS COLUNAS | COLUNA \"Sentido\"  - tem de dropar ela, não consta nada de relevante\n",
        "\n",
        "pd.unique(df[\"Sentido\"])"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<StringArray>\n",
              "['Sul', 'Norte', 'Sentido 1', 'Sentido 2', 'Leste', 'Oeste']\n",
              "Length: 6, dtype: string"
            ]
          },
          "metadata": {},
          "execution_count": 21
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "KHhlg7OMBD0v",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "033f529d-c54b-4c32-9034-4db032fd5fd7"
      },
      "source": [
        "#22 - ANALIZANDO DADOS DAS COLUNAS | COLUNA \"Categoria\"  - tem de dropar ela, não consta nada de relevante\n",
        "\n",
        "pd.unique(df[\"Categoria\"])"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<StringArray>\n",
              "[                     'Categoria 1',                      'Categoria 2',\n",
              "                      'Categoria 3',                      'Categoria 4',\n",
              "                      'Categoria 5',                      'Categoria 6',\n",
              "                      'Categoria 7',                      'Categoria 8',\n",
              "                      'Categoria 9',                'Categoria Esp. 07',\n",
              "                'Categoria Esp. 08',                'Categoria Esp. 09',\n",
              "                'Categoria Esp. 10',                           'Outros',\n",
              "                     'Categoria 10',                     'Categoria 11',\n",
              "               'Categoria Especial',                     'Categoria 12',\n",
              "          'Veículo Passeio 2 eixos',        'Veículo Comercial 2 eixos',\n",
              "          'Veículo Passeio 3 eixos',        'Veículo Comercial 3 eixos',\n",
              "          'Veículo Passeio 4 eixos',        'Veículo Comercial 4 eixos',\n",
              "        'Veículo Comercial 5 eixos',        'Veículo Comercial 6 eixos',\n",
              "                             'Moto',        'Veículo Comercial 7 eixos',\n",
              "        'Veículo Comercial 8 eixos',        'Veículo Comercial 9 eixos',\n",
              "       'Veículo Comercial 10 eixos', 'Veículo Comercial Acima 10 eixos']\n",
              "Length: 32, dtype: string"
            ]
          },
          "metadata": {},
          "execution_count": 22
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "7TCq1t5FCOuZ"
      },
      "source": [
        "#23 - DROPANDO COLUNAS - APENAS PARA MELHOR VISUALIZAÇÃO DE DADOS MAIS PERTINENTES | UM BACKUP SERA FEITO SOBRE ALGUMAS DESSAS COLUNAS, CASO ELAS NECESSITEM SER CONSULTADAS\n",
        "\n",
        "df[\"backup_Categoria\"] = df.Categoria\n",
        "\n",
        "df.drop([\"Categoria\"], axis=1, inplace=True)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "aiyJiGJmCg0v",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 423
        },
        "outputId": "99d1d3f5-4072-40ba-eb53-401b8f0f2421"
      },
      "source": [
        "#24 - VERIFICANDO DROP / BACKUP\n",
        "\n",
        "df"
      ],
      "execution_count": null,
      "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>Concessionaria</th>\n",
              "      <th>Data</th>\n",
              "      <th>Sentido</th>\n",
              "      <th>Praca</th>\n",
              "      <th>Tipo_de_veiculo</th>\n",
              "      <th>Volume_total</th>\n",
              "      <th>backup_Categoria</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-01-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 01 BR-116/SP km 204,50</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>640429.0</td>\n",
              "      <td>Categoria 1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-01-01</td>\n",
              "      <td>Norte</td>\n",
              "      <td>Praça 01 BR-116/SP km 204,50</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>787419.0</td>\n",
              "      <td>Categoria 1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-02-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 01 BR-116/SP km 204,50</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>511718.0</td>\n",
              "      <td>Categoria 1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-02-01</td>\n",
              "      <td>Norte</td>\n",
              "      <td>Praça 01 BR-116/SP km 204,50</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>638796.0</td>\n",
              "      <td>Categoria 1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-03-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 01 BR-116/SP km 204,50</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>579422.0</td>\n",
              "      <td>Categoria 1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35538</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 06 BR-381/MG km 659</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>16137.0</td>\n",
              "      <td>Outros</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35539</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Norte</td>\n",
              "      <td>Praça 07 BR-381/MG km 596,935</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>15141.0</td>\n",
              "      <td>Outros</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35540</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 07 BR-381/MG km 596,935</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>15863.0</td>\n",
              "      <td>Outros</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35541</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Norte</td>\n",
              "      <td>Praça 08 BR-381/MG km 546</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>14362.0</td>\n",
              "      <td>Outros</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35542</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 08 BR-381/MG km 546</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>14988.0</td>\n",
              "      <td>Outros</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>69179 rows × 7 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "              Concessionaria       Data  ... Volume_total backup_Categoria\n",
              "0                  NOVADUTRA 2019-01-01  ...     640429.0      Categoria 1\n",
              "1                  NOVADUTRA 2019-01-01  ...     787419.0      Categoria 1\n",
              "2                  NOVADUTRA 2019-02-01  ...     511718.0      Categoria 1\n",
              "3                  NOVADUTRA 2019-02-01  ...     638796.0      Categoria 1\n",
              "4                  NOVADUTRA 2019-03-01  ...     579422.0      Categoria 1\n",
              "...                      ...        ...  ...          ...              ...\n",
              "35538  AUTOPISTA FERNÃO DIAS 2020-12-01  ...      16137.0           Outros\n",
              "35539  AUTOPISTA FERNÃO DIAS 2020-12-01  ...      15141.0           Outros\n",
              "35540  AUTOPISTA FERNÃO DIAS 2020-12-01  ...      15863.0           Outros\n",
              "35541  AUTOPISTA FERNÃO DIAS 2020-12-01  ...      14362.0           Outros\n",
              "35542  AUTOPISTA FERNÃO DIAS 2020-12-01  ...      14988.0           Outros\n",
              "\n",
              "[69179 rows x 7 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 24
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Qn4i5DWbgu8s"
      },
      "source": [
        "#25 - DROPANDO COLUNAS SEM RELEVÂNCIA PARA O TRABALHO\n",
        "\n",
        "df.drop([\"backup_Categoria\"], axis=1, inplace=True)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "6ghRdrIkhAkx",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 423
        },
        "outputId": "f6f73e0c-2d03-4d0b-fc3e-c221e245328a"
      },
      "source": [
        "#26 - VERIFICANDO DROP\n",
        "\n",
        "df"
      ],
      "execution_count": null,
      "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>Concessionaria</th>\n",
              "      <th>Data</th>\n",
              "      <th>Sentido</th>\n",
              "      <th>Praca</th>\n",
              "      <th>Tipo_de_veiculo</th>\n",
              "      <th>Volume_total</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-01-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 01 BR-116/SP km 204,50</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>640429.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-01-01</td>\n",
              "      <td>Norte</td>\n",
              "      <td>Praça 01 BR-116/SP km 204,50</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>787419.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-02-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 01 BR-116/SP km 204,50</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>511718.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-02-01</td>\n",
              "      <td>Norte</td>\n",
              "      <td>Praça 01 BR-116/SP km 204,50</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>638796.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-03-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 01 BR-116/SP km 204,50</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>579422.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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35538</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 06 BR-381/MG km 659</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>16137.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35539</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Norte</td>\n",
              "      <td>Praça 07 BR-381/MG km 596,935</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>15141.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35540</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 07 BR-381/MG km 596,935</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>15863.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35541</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Norte</td>\n",
              "      <td>Praça 08 BR-381/MG km 546</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>14362.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35542</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 08 BR-381/MG km 546</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>14988.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>69179 rows × 6 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "              Concessionaria       Data  ... Tipo_de_veiculo Volume_total\n",
              "0                  NOVADUTRA 2019-01-01  ...         Passeio     640429.0\n",
              "1                  NOVADUTRA 2019-01-01  ...         Passeio     787419.0\n",
              "2                  NOVADUTRA 2019-02-01  ...         Passeio     511718.0\n",
              "3                  NOVADUTRA 2019-02-01  ...         Passeio     638796.0\n",
              "4                  NOVADUTRA 2019-03-01  ...         Passeio     579422.0\n",
              "...                      ...        ...  ...             ...          ...\n",
              "35538  AUTOPISTA FERNÃO DIAS 2020-12-01  ...       Comercial      16137.0\n",
              "35539  AUTOPISTA FERNÃO DIAS 2020-12-01  ...       Comercial      15141.0\n",
              "35540  AUTOPISTA FERNÃO DIAS 2020-12-01  ...       Comercial      15863.0\n",
              "35541  AUTOPISTA FERNÃO DIAS 2020-12-01  ...       Comercial      14362.0\n",
              "35542  AUTOPISTA FERNÃO DIAS 2020-12-01  ...       Comercial      14988.0\n",
              "\n",
              "[69179 rows x 6 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 26
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 423
        },
        "id": "Gpo4CFrxkrhE",
        "outputId": "244e3464-187b-4999-f43d-f14f0d0e2b8a"
      },
      "source": [
        "#27 - DIVIDINDO DADOS DA COLUNA DE PRAÇAS PARA VISUALIZAR COMO EXTRAIR OS DADOS\n",
        "\n",
        "df['Praca'].str.split(\" \", expand=True)"
      ],
      "execution_count": null,
      "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>0</th>\n",
              "      <th>1</th>\n",
              "      <th>2</th>\n",
              "      <th>3</th>\n",
              "      <th>4</th>\n",
              "      <th>5</th>\n",
              "      <th>6</th>\n",
              "      <th>7</th>\n",
              "      <th>8</th>\n",
              "      <th>9</th>\n",
              "      <th>10</th>\n",
              "      <th>11</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Praça</td>\n",
              "      <td>01</td>\n",
              "      <td>BR-116/SP</td>\n",
              "      <td>km</td>\n",
              "      <td>204,50</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Praça</td>\n",
              "      <td>01</td>\n",
              "      <td>BR-116/SP</td>\n",
              "      <td>km</td>\n",
              "      <td>204,50</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Praça</td>\n",
              "      <td>01</td>\n",
              "      <td>BR-116/SP</td>\n",
              "      <td>km</td>\n",
              "      <td>204,50</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Praça</td>\n",
              "      <td>01</td>\n",
              "      <td>BR-116/SP</td>\n",
              "      <td>km</td>\n",
              "      <td>204,50</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Praça</td>\n",
              "      <td>01</td>\n",
              "      <td>BR-116/SP</td>\n",
              "      <td>km</td>\n",
              "      <td>204,50</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35538</th>\n",
              "      <td>Praça</td>\n",
              "      <td>06</td>\n",
              "      <td>BR-381/MG</td>\n",
              "      <td>km</td>\n",
              "      <td>659</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35539</th>\n",
              "      <td>Praça</td>\n",
              "      <td>07</td>\n",
              "      <td>BR-381/MG</td>\n",
              "      <td>km</td>\n",
              "      <td>596,935</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35540</th>\n",
              "      <td>Praça</td>\n",
              "      <td>07</td>\n",
              "      <td>BR-381/MG</td>\n",
              "      <td>km</td>\n",
              "      <td>596,935</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35541</th>\n",
              "      <td>Praça</td>\n",
              "      <td>08</td>\n",
              "      <td>BR-381/MG</td>\n",
              "      <td>km</td>\n",
              "      <td>546</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35542</th>\n",
              "      <td>Praça</td>\n",
              "      <td>08</td>\n",
              "      <td>BR-381/MG</td>\n",
              "      <td>km</td>\n",
              "      <td>546</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>69179 rows × 12 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "          0   1          2   3        4   ...    7     8     9     10    11\n",
              "0      Praça  01  BR-116/SP  km   204,50  ...  <NA>  <NA>  <NA>  <NA>  <NA>\n",
              "1      Praça  01  BR-116/SP  km   204,50  ...  <NA>  <NA>  <NA>  <NA>  <NA>\n",
              "2      Praça  01  BR-116/SP  km   204,50  ...  <NA>  <NA>  <NA>  <NA>  <NA>\n",
              "3      Praça  01  BR-116/SP  km   204,50  ...  <NA>  <NA>  <NA>  <NA>  <NA>\n",
              "4      Praça  01  BR-116/SP  km   204,50  ...  <NA>  <NA>  <NA>  <NA>  <NA>\n",
              "...      ...  ..        ...  ..      ...  ...   ...   ...   ...   ...   ...\n",
              "35538  Praça  06  BR-381/MG  km      659  ...  <NA>  <NA>  <NA>  <NA>  <NA>\n",
              "35539  Praça  07  BR-381/MG  km  596,935  ...  <NA>  <NA>  <NA>  <NA>  <NA>\n",
              "35540  Praça  07  BR-381/MG  km  596,935  ...  <NA>  <NA>  <NA>  <NA>  <NA>\n",
              "35541  Praça  08  BR-381/MG  km      546  ...  <NA>  <NA>  <NA>  <NA>  <NA>\n",
              "35542  Praça  08  BR-381/MG  km      546  ...  <NA>  <NA>  <NA>  <NA>  <NA>\n",
              "\n",
              "[69179 rows x 12 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 28
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "dl1h2ldBlEhD"
      },
      "source": [
        "#28 - DIVIDINDO DADOS DA COLUNA DE PRAÇAS E SALVANDO ELAS EM COLUNAS\n",
        "\n",
        "df [[\"1\", \"2\", \"BRUF\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\",\"10\",\"11\"]] = df[\"Praca\"].str.split(\" \", expand=True)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "EGLXagtklLar"
      },
      "source": [
        "#29 - EXCLUINDO COLUNAS RESULTANTES DA DIVISÃO\n",
        "\n",
        "df.drop([\"1\"], axis=1, inplace=True)\n",
        "df.drop([\"2\"], axis=1, inplace=True)\n",
        "df.drop([\"3\"], axis=1, inplace=True)\n",
        "df.drop([\"4\"], axis=1, inplace=True)\n",
        "df.drop([\"5\"], axis=1, inplace=True)\n",
        "df.drop([\"6\"], axis=1, inplace=True)\n",
        "df.drop([\"7\"], axis=1, inplace=True)\n",
        "df.drop([\"8\"], axis=1, inplace=True)\n",
        "df.drop([\"9\"], axis=1, inplace=True)\n",
        "df.drop([\"10\"], axis=1, inplace=True)\n",
        "df.drop([\"11\"], axis=1, inplace=True)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 423
        },
        "id": "TqnD0rGIlN2r",
        "outputId": "58291699-5761-4409-b8f8-626477221a19"
      },
      "source": [
        "#30 - VISUALIZANDO DATAFRAME\n",
        "\n",
        "df"
      ],
      "execution_count": null,
      "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>Concessionaria</th>\n",
              "      <th>Data</th>\n",
              "      <th>Sentido</th>\n",
              "      <th>Praca</th>\n",
              "      <th>Tipo_de_veiculo</th>\n",
              "      <th>Volume_total</th>\n",
              "      <th>BRUF</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-01-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 01 BR-116/SP km 204,50</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>640429.0</td>\n",
              "      <td>BR-116/SP</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-01-01</td>\n",
              "      <td>Norte</td>\n",
              "      <td>Praça 01 BR-116/SP km 204,50</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>787419.0</td>\n",
              "      <td>BR-116/SP</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-02-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 01 BR-116/SP km 204,50</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>511718.0</td>\n",
              "      <td>BR-116/SP</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-02-01</td>\n",
              "      <td>Norte</td>\n",
              "      <td>Praça 01 BR-116/SP km 204,50</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>638796.0</td>\n",
              "      <td>BR-116/SP</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-03-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 01 BR-116/SP km 204,50</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>579422.0</td>\n",
              "      <td>BR-116/SP</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35538</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 06 BR-381/MG km 659</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>16137.0</td>\n",
              "      <td>BR-381/MG</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35539</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Norte</td>\n",
              "      <td>Praça 07 BR-381/MG km 596,935</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>15141.0</td>\n",
              "      <td>BR-381/MG</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35540</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 07 BR-381/MG km 596,935</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>15863.0</td>\n",
              "      <td>BR-381/MG</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35541</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Norte</td>\n",
              "      <td>Praça 08 BR-381/MG km 546</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>14362.0</td>\n",
              "      <td>BR-381/MG</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35542</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Praça 08 BR-381/MG km 546</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>14988.0</td>\n",
              "      <td>BR-381/MG</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>69179 rows × 7 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "              Concessionaria       Data  ... Volume_total       BRUF\n",
              "0                  NOVADUTRA 2019-01-01  ...     640429.0  BR-116/SP\n",
              "1                  NOVADUTRA 2019-01-01  ...     787419.0  BR-116/SP\n",
              "2                  NOVADUTRA 2019-02-01  ...     511718.0  BR-116/SP\n",
              "3                  NOVADUTRA 2019-02-01  ...     638796.0  BR-116/SP\n",
              "4                  NOVADUTRA 2019-03-01  ...     579422.0  BR-116/SP\n",
              "...                      ...        ...  ...          ...        ...\n",
              "35538  AUTOPISTA FERNÃO DIAS 2020-12-01  ...      16137.0  BR-381/MG\n",
              "35539  AUTOPISTA FERNÃO DIAS 2020-12-01  ...      15141.0  BR-381/MG\n",
              "35540  AUTOPISTA FERNÃO DIAS 2020-12-01  ...      15863.0  BR-381/MG\n",
              "35541  AUTOPISTA FERNÃO DIAS 2020-12-01  ...      14362.0  BR-381/MG\n",
              "35542  AUTOPISTA FERNÃO DIAS 2020-12-01  ...      14988.0  BR-381/MG\n",
              "\n",
              "[69179 rows x 7 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 32
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "MqdhtrAElUu8"
      },
      "source": [
        "#31 - DIVIDINDO DADOS DA COLUNA \"BRUF\" E SALVANDO EM COLUNAS\n",
        "\n",
        "df [[\"BR\", \"UF\"]] = df[\"BRUF\"].str.split(\"/\", expand=True)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "kFXaPEpolWBi"
      },
      "source": [
        "#32 - DROPANDO COLUNAS QUE FICARAM REPETIDAS\n",
        "\n",
        "df.drop([\"BRUF\"], axis=1, inplace=True)\n",
        "df.drop([\"Praca\"], axis=1, inplace=True)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 423
        },
        "id": "ozuOXLjXlaHq",
        "outputId": "bce54788-fb07-44d4-a960-c64deeabf181"
      },
      "source": [
        "#33 - VISUALIZANDO DATAFRAME\n",
        "\n",
        "df"
      ],
      "execution_count": null,
      "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>Concessionaria</th>\n",
              "      <th>Data</th>\n",
              "      <th>Sentido</th>\n",
              "      <th>Tipo_de_veiculo</th>\n",
              "      <th>Volume_total</th>\n",
              "      <th>BR</th>\n",
              "      <th>UF</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-01-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>640429.0</td>\n",
              "      <td>BR-116</td>\n",
              "      <td>SP</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-01-01</td>\n",
              "      <td>Norte</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>787419.0</td>\n",
              "      <td>BR-116</td>\n",
              "      <td>SP</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-02-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>511718.0</td>\n",
              "      <td>BR-116</td>\n",
              "      <td>SP</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-02-01</td>\n",
              "      <td>Norte</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>638796.0</td>\n",
              "      <td>BR-116</td>\n",
              "      <td>SP</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>NOVADUTRA</td>\n",
              "      <td>2019-03-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Passeio</td>\n",
              "      <td>579422.0</td>\n",
              "      <td>BR-116</td>\n",
              "      <td>SP</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35538</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>16137.0</td>\n",
              "      <td>BR-381</td>\n",
              "      <td>MG</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35539</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Norte</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>15141.0</td>\n",
              "      <td>BR-381</td>\n",
              "      <td>MG</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35540</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>15863.0</td>\n",
              "      <td>BR-381</td>\n",
              "      <td>MG</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35541</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Norte</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>14362.0</td>\n",
              "      <td>BR-381</td>\n",
              "      <td>MG</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35542</th>\n",
              "      <td>AUTOPISTA FERNÃO DIAS</td>\n",
              "      <td>2020-12-01</td>\n",
              "      <td>Sul</td>\n",
              "      <td>Comercial</td>\n",
              "      <td>14988.0</td>\n",
              "      <td>BR-381</td>\n",
              "      <td>MG</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>69179 rows × 7 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "              Concessionaria       Data Sentido  ... Volume_total      BR  UF\n",
              "0                  NOVADUTRA 2019-01-01     Sul  ...     640429.0  BR-116  SP\n",
              "1                  NOVADUTRA 2019-01-01   Norte  ...     787419.0  BR-116  SP\n",
              "2                  NOVADUTRA 2019-02-01     Sul  ...     511718.0  BR-116  SP\n",
              "3                  NOVADUTRA 2019-02-01   Norte  ...     638796.0  BR-116  SP\n",
              "4                  NOVADUTRA 2019-03-01     Sul  ...     579422.0  BR-116  SP\n",
              "...                      ...        ...     ...  ...          ...     ...  ..\n",
              "35538  AUTOPISTA FERNÃO DIAS 2020-12-01     Sul  ...      16137.0  BR-381  MG\n",
              "35539  AUTOPISTA FERNÃO DIAS 2020-12-01   Norte  ...      15141.0  BR-381  MG\n",
              "35540  AUTOPISTA FERNÃO DIAS 2020-12-01     Sul  ...      15863.0  BR-381  MG\n",
              "35541  AUTOPISTA FERNÃO DIAS 2020-12-01   Norte  ...      14362.0  BR-381  MG\n",
              "35542  AUTOPISTA FERNÃO DIAS 2020-12-01     Sul  ...      14988.0  BR-381  MG\n",
              "\n",
              "[69179 rows x 7 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 35
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "DYc7lMNSLgdo",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "7051a2ce-a2d0-45d6-b66f-8ec63e782e33"
      },
      "source": [
        "#34 - SALVANDO O ARQUIVO NORMALIZADO NO BUCKET\n",
        "\n",
        "df.to_csv('pedagio_tratado.csv')\n",
        "!gsutil cp pedagio_tratado.csv gs://notebooks_pandas_gp03/\n",
        "#!gsutil cat gs://notebooks_pandas_gp03/pedagio_tratado.csv"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Copying file://pedagio_tratado.csv [Content-Type=text/csv]...\n",
            "-\n",
            "Operation completed over 1 objects/4.0 MiB.                                      \n"
          ]
        }
      ]
    }
  ]
}