Desafio_1.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "source": [
        "# Importação de dados:"
      ],
      "metadata": {
        "id": "_jF35lfnhUZC"
      }
    },
    {
      "cell_type": "code",
      "execution_count": 82,
      "metadata": {
        "id": "_HzYy_XIjb4n"
      },
      "outputs": [],
      "source": [
        "import pandas as pd"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Empréstimos:"
      ],
      "metadata": {
        "id": "AraPj_aDm1nD"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "emprestimo_2010_1 = pd.read_csv('https://raw.githubusercontent.com/FranciscoFoz/7_Days_of_Code_Alura-Python-Pandas/main/Dia_1-Importando_dados/Datasets/dados_emprestimos/emprestimos-20101.csv')\n",
        "emprestimo_2010_2 = pd.read_csv('https://raw.githubusercontent.com/FranciscoFoz/7_Days_of_Code_Alura-Python-Pandas/main/Dia_1-Importando_dados/Datasets/dados_emprestimos/emprestimos-20102.csv')\n",
        "emprestimo_2011_1 = pd.read_csv('https://raw.githubusercontent.com/FranciscoFoz/7_Days_of_Code_Alura-Python-Pandas/main/Dia_1-Importando_dados/Datasets/dados_emprestimos/emprestimos-20111.csv')\n",
        "emprestimo_2011_2 = pd.read_csv('https://raw.githubusercontent.com/FranciscoFoz/7_Days_of_Code_Alura-Python-Pandas/main/Dia_1-Importando_dados/Datasets/dados_emprestimos/emprestimos-20112.csv')\n",
        "emprestimo_2012_1 = pd.read_csv('https://raw.githubusercontent.com/FranciscoFoz/7_Days_of_Code_Alura-Python-Pandas/main/Dia_1-Importando_dados/Datasets/dados_emprestimos/emprestimos-20121.csv')\n",
        "emprestimo_2012_2 = pd.read_csv('https://raw.githubusercontent.com/FranciscoFoz/7_Days_of_Code_Alura-Python-Pandas/main/Dia_1-Importando_dados/Datasets/dados_emprestimos/emprestimos-20122.csv')\n",
        "emprestimo_2013_1 = pd.read_csv('https://raw.githubusercontent.com/FranciscoFoz/7_Days_of_Code_Alura-Python-Pandas/main/Dia_1-Importando_dados/Datasets/dados_emprestimos/emprestimos-20131.csv')\n",
        "emprestimo_2013_2 = pd.read_csv('https://raw.githubusercontent.com/FranciscoFoz/7_Days_of_Code_Alura-Python-Pandas/main/Dia_1-Importando_dados/Datasets/dados_emprestimos/emprestimos-20132.csv')\n",
        "emprestimo_2014_1 = pd.read_csv('https://raw.githubusercontent.com/FranciscoFoz/7_Days_of_Code_Alura-Python-Pandas/main/Dia_1-Importando_dados/Datasets/dados_emprestimos/emprestimos-20141.csv')\n",
        "emprestimo_2014_2 = pd.read_csv('https://raw.githubusercontent.com/FranciscoFoz/7_Days_of_Code_Alura-Python-Pandas/main/Dia_1-Importando_dados/Datasets/dados_emprestimos/emprestimos-20142.csv')\n",
        "emprestimo_2015_1 = pd.read_csv('https://raw.githubusercontent.com/FranciscoFoz/7_Days_of_Code_Alura-Python-Pandas/main/Dia_1-Importando_dados/Datasets/dados_emprestimos/emprestimos-20151.csv')\n",
        "emprestimo_2015_2 = pd.read_csv('https://raw.githubusercontent.com/FranciscoFoz/7_Days_of_Code_Alura-Python-Pandas/main/Dia_1-Importando_dados/Datasets/dados_emprestimos/emprestimos-20152.csv')\n",
        "emprestimo_2016_1 = pd.read_csv('https://raw.githubusercontent.com/FranciscoFoz/7_Days_of_Code_Alura-Python-Pandas/main/Dia_1-Importando_dados/Datasets/dados_emprestimos/emprestimos-20161.csv')\n",
        "emprestimo_2016_2 = pd.read_csv('https://raw.githubusercontent.com/FranciscoFoz/7_Days_of_Code_Alura-Python-Pandas/main/Dia_1-Importando_dados/Datasets/dados_emprestimos/emprestimos-20162.csv')\n",
        "emprestimo_2017_1 = pd.read_csv('https://raw.githubusercontent.com/FranciscoFoz/7_Days_of_Code_Alura-Python-Pandas/main/Dia_1-Importando_dados/Datasets/dados_emprestimos/emprestimos-20171.csv')\n",
        "emprestimo_2017_2 = pd.read_csv('https://raw.githubusercontent.com/FranciscoFoz/7_Days_of_Code_Alura-Python-Pandas/main/Dia_1-Importando_dados/Datasets/dados_emprestimos/emprestimos-20172.csv')\n",
        "emprestimo_2018_1 = pd.read_csv('https://raw.githubusercontent.com/FranciscoFoz/7_Days_of_Code_Alura-Python-Pandas/main/Dia_1-Importando_dados/Datasets/dados_emprestimos/emprestimos-20181.csv')\n",
        "emprestimo_2018_2 = pd.read_csv('https://raw.githubusercontent.com/FranciscoFoz/7_Days_of_Code_Alura-Python-Pandas/main/Dia_1-Importando_dados/Datasets/dados_emprestimos/emprestimos-20182.csv')\n",
        "emprestimo_2019_1 = pd.read_csv('https://raw.githubusercontent.com/FranciscoFoz/7_Days_of_Code_Alura-Python-Pandas/main/Dia_1-Importando_dados/Datasets/dados_emprestimos/emprestimos-20191.csv')\n",
        "emprestimo_2019_2 = pd.read_csv('https://raw.githubusercontent.com/FranciscoFoz/7_Days_of_Code_Alura-Python-Pandas/main/Dia_1-Importando_dados/Datasets/dados_emprestimos/emprestimos-20192.csv')\n",
        "emprestimo_2020_1 = pd.read_csv('https://raw.githubusercontent.com/FranciscoFoz/7_Days_of_Code_Alura-Python-Pandas/main/Dia_1-Importando_dados/Datasets/dados_emprestimos/emprestimos-20201.csv')"
      ],
      "metadata": {
        "id": "9BYEWzdejxVB"
      },
      "execution_count": 83,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "emprestimos = pd.concat([emprestimo_2010_1, emprestimo_2010_2, emprestimo_2011_1, emprestimo_2011_2, \n",
        "                         emprestimo_2012_1, emprestimo_2012_2, emprestimo_2013_1, emprestimo_2013_2, \n",
        "                         emprestimo_2014_1, emprestimo_2014_2, emprestimo_2015_1, emprestimo_2015_2, \n",
        "                         emprestimo_2016_1, emprestimo_2016_2, emprestimo_2017_1, emprestimo_2017_2, \n",
        "                         emprestimo_2018_1, emprestimo_2018_2, emprestimo_2019_1, emprestimo_2019_2, \n",
        "                         emprestimo_2020_1])"
      ],
      "metadata": {
        "id": "BRFnlGJ0r6Sc"
      },
      "execution_count": 84,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "emprestimos.sample(3)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 240
        },
        "id": "Tm8pxlcIc3zl",
        "outputId": "f7a3c82a-322e-42ac-fcab-a6587b6e1cb7"
      },
      "execution_count": 85,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "       id_emprestimo codigo_barras                 data_renovacao  \\\n",
              "52414        2633045    2014058897  2018/04/20 09:26:17.891000000   \n",
              "60365        2640998    2012009825  2018/04/30 21:39:23.754000000   \n",
              "78598        2861500    2017036680                            NaN   \n",
              "\n",
              "                     data_emprestimo                 data_devolucao  \\\n",
              "52414  2018/04/05 18:44:07.182000000  2018/05/10 16:14:37.000000000   \n",
              "60365  2018/04/17 12:53:53.036000000  2018/05/08 13:33:23.000000000   \n",
              "78598  2019/05/22 10:35:32.372000000  2019/06/06 20:32:12.000000000   \n",
              "\n",
              "       matricula_ou_siape tipo_vinculo_usuario  \n",
              "52414        2.016011e+10   ALUNO DE GRADUAÇÃO  \n",
              "60365        2.015010e+09   ALUNO DE GRADUAÇÃO  \n",
              "78598        2.015054e+09   ALUNO DE GRADUAÇÃO  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-a61daebf-f469-4582-bfbf-844d8898f78b\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>id_emprestimo</th>\n",
              "      <th>codigo_barras</th>\n",
              "      <th>data_renovacao</th>\n",
              "      <th>data_emprestimo</th>\n",
              "      <th>data_devolucao</th>\n",
              "      <th>matricula_ou_siape</th>\n",
              "      <th>tipo_vinculo_usuario</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>52414</th>\n",
              "      <td>2633045</td>\n",
              "      <td>2014058897</td>\n",
              "      <td>2018/04/20 09:26:17.891000000</td>\n",
              "      <td>2018/04/05 18:44:07.182000000</td>\n",
              "      <td>2018/05/10 16:14:37.000000000</td>\n",
              "      <td>2.016011e+10</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>60365</th>\n",
              "      <td>2640998</td>\n",
              "      <td>2012009825</td>\n",
              "      <td>2018/04/30 21:39:23.754000000</td>\n",
              "      <td>2018/04/17 12:53:53.036000000</td>\n",
              "      <td>2018/05/08 13:33:23.000000000</td>\n",
              "      <td>2.015010e+09</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>78598</th>\n",
              "      <td>2861500</td>\n",
              "      <td>2017036680</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2019/05/22 10:35:32.372000000</td>\n",
              "      <td>2019/06/06 20:32:12.000000000</td>\n",
              "      <td>2.015054e+09</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-a61daebf-f469-4582-bfbf-844d8898f78b')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-a61daebf-f469-4582-bfbf-844d8898f78b button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-a61daebf-f469-4582-bfbf-844d8898f78b');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 85
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "emprestimos.shape"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "kCg2ZmdSfXpY",
        "outputId": "9b0a6c40-840a-4eea-83bf-da64538faa34"
      },
      "execution_count": 86,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(2258018, 7)"
            ]
          },
          "metadata": {},
          "execution_count": 86
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "emprestimos.dtypes"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "G62A62oydAPv",
        "outputId": "06e8e5fd-dba5-4b22-c401-fe778de8333b"
      },
      "execution_count": 87,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "id_emprestimo             int64\n",
              "codigo_barras            object\n",
              "data_renovacao           object\n",
              "data_emprestimo          object\n",
              "data_devolucao           object\n",
              "matricula_ou_siape      float64\n",
              "tipo_vinculo_usuario     object\n",
              "dtype: object"
            ]
          },
          "metadata": {},
          "execution_count": 87
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "emprestimos[['data_renovacao', 'data_emprestimo', 'data_devolucao']] = emprestimos[['data_renovacao', \n",
        "                                                                                    'data_emprestimo', \n",
        "                                                                                    'data_devolucao']].apply(pd.to_datetime)\n",
        "emprestimos['matricula_ou_siape'] = emprestimos.matricula_ou_siape.astype(str)\n",
        "emprestimos.sample(3)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 143
        },
        "id": "ixzwbA4RjLbn",
        "outputId": "34b42e0a-b020-4ea4-c353-df85a6567aac"
      },
      "execution_count": 88,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "        id_emprestimo codigo_barras          data_renovacao  \\\n",
              "14855         2702607    2012036700 2018-08-20 14:32:09.775   \n",
              "344           1282844    2012034109                     NaT   \n",
              "101729        1501795    2012067672                     NaT   \n",
              "\n",
              "               data_emprestimo      data_devolucao matricula_ou_siape  \\\n",
              "14855  2018-08-06 10:41:48.135 2018-08-29 20:22:28       2012941680.0   \n",
              "344    2012-07-02 20:35:08.323 2012-07-12 08:54:48       2011307082.0   \n",
              "101729 2013-05-09 15:34:41.160 2013-05-15 15:01:18       2010018583.0   \n",
              "\n",
              "       tipo_vinculo_usuario  \n",
              "14855    ALUNO DE GRADUAÇÃO  \n",
              "344     ALUNO MÉDIO/TÉCNICO  \n",
              "101729   ALUNO DE GRADUAÇÃO  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-be49d95d-0a63-4034-b63c-5f13807ffbcb\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>id_emprestimo</th>\n",
              "      <th>codigo_barras</th>\n",
              "      <th>data_renovacao</th>\n",
              "      <th>data_emprestimo</th>\n",
              "      <th>data_devolucao</th>\n",
              "      <th>matricula_ou_siape</th>\n",
              "      <th>tipo_vinculo_usuario</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>14855</th>\n",
              "      <td>2702607</td>\n",
              "      <td>2012036700</td>\n",
              "      <td>2018-08-20 14:32:09.775</td>\n",
              "      <td>2018-08-06 10:41:48.135</td>\n",
              "      <td>2018-08-29 20:22:28</td>\n",
              "      <td>2012941680.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>344</th>\n",
              "      <td>1282844</td>\n",
              "      <td>2012034109</td>\n",
              "      <td>NaT</td>\n",
              "      <td>2012-07-02 20:35:08.323</td>\n",
              "      <td>2012-07-12 08:54:48</td>\n",
              "      <td>2011307082.0</td>\n",
              "      <td>ALUNO MÉDIO/TÉCNICO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>101729</th>\n",
              "      <td>1501795</td>\n",
              "      <td>2012067672</td>\n",
              "      <td>NaT</td>\n",
              "      <td>2013-05-09 15:34:41.160</td>\n",
              "      <td>2013-05-15 15:01:18</td>\n",
              "      <td>2010018583.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-be49d95d-0a63-4034-b63c-5f13807ffbcb')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-be49d95d-0a63-4034-b63c-5f13807ffbcb button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-be49d95d-0a63-4034-b63c-5f13807ffbcb');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 88
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "emprestimos.dtypes"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "6tIwPXUvnUtG",
        "outputId": "6609799e-7ded-4128-e373-286a181eb0d6"
      },
      "execution_count": 89,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "id_emprestimo                    int64\n",
              "codigo_barras                   object\n",
              "data_renovacao          datetime64[ns]\n",
              "data_emprestimo         datetime64[ns]\n",
              "data_devolucao          datetime64[ns]\n",
              "matricula_ou_siape              object\n",
              "tipo_vinculo_usuario            object\n",
              "dtype: object"
            ]
          },
          "metadata": {},
          "execution_count": 89
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "emprestimos.isna().sum()"
      ],
      "metadata": {
        "id": "YU2EvfQCjLT-",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "dc1dd0f0-3e44-4e57-c36d-180a10716082"
      },
      "execution_count": 90,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "id_emprestimo                 0\n",
              "codigo_barras                 0\n",
              "data_renovacao          1285720\n",
              "data_emprestimo               0\n",
              "data_devolucao             6471\n",
              "matricula_ou_siape            0\n",
              "tipo_vinculo_usuario          0\n",
              "dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 90
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Acervo:"
      ],
      "metadata": {
        "id": "qe3uaKNJh1gk"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "acervo = pd.read_parquet('/content/dados_exemplares.parquet')\n",
        "acervo.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 238
        },
        "id": "YEWxRGeyovEI",
        "outputId": "a83d2003-f9e8-4e18-f620-de88bd171995"
      },
      "execution_count": 91,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "       id_exemplar codigo_barras            colecao  \\\n",
              "index                                                 \n",
              "0                5       L000003  Acervo Circulante   \n",
              "1                4       L000002  Acervo Circulante   \n",
              "2                3       L000001  Acervo Circulante   \n",
              "3                7       L000114  Acervo Circulante   \n",
              "5               10       L000041  Acervo Circulante   \n",
              "\n",
              "                           biblioteca status_material  localizacao  \\\n",
              "index                                                                \n",
              "0      Biblioteca Central Zila Mamede         REGULAR          694   \n",
              "1      Biblioteca Central Zila Mamede         REGULAR          688   \n",
              "2      Biblioteca Central Zila Mamede        ESPECIAL          638   \n",
              "3      Biblioteca Central Zila Mamede         REGULAR          616   \n",
              "5      Biblioteca Central Zila Mamede        ESPECIAL          657   \n",
              "\n",
              "       registro_sistema  \n",
              "index                    \n",
              "0                     1  \n",
              "1                     1  \n",
              "2                     1  \n",
              "3                     5  \n",
              "5                    15  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-2477a654-f12a-4aec-acd8-de67ce67017b\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>id_exemplar</th>\n",
              "      <th>codigo_barras</th>\n",
              "      <th>colecao</th>\n",
              "      <th>biblioteca</th>\n",
              "      <th>status_material</th>\n",
              "      <th>localizacao</th>\n",
              "      <th>registro_sistema</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>index</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>5</td>\n",
              "      <td>L000003</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>694</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>4</td>\n",
              "      <td>L000002</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>688</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>L000001</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>ESPECIAL</td>\n",
              "      <td>638</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>7</td>\n",
              "      <td>L000114</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>616</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>10</td>\n",
              "      <td>L000041</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>ESPECIAL</td>\n",
              "      <td>657</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-2477a654-f12a-4aec-acd8-de67ce67017b')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-2477a654-f12a-4aec-acd8-de67ce67017b button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-2477a654-f12a-4aec-acd8-de67ce67017b');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 91
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "acervo.sample(5)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 238
        },
        "id": "G2h7p-9ItB5R",
        "outputId": "abd0c6f4-34e9-4960-87f1-f43b6f9a2e72"
      },
      "execution_count": 92,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "        id_exemplar codigo_barras            colecao  \\\n",
              "index                                                  \n",
              "406136      1021441    2012062722         Multimeios   \n",
              "261463       259614    2008032080  Acervo Circulante   \n",
              "503782      1213189    2016001046  Acervo Circulante   \n",
              "545643      1343826    2018031319           Folhetos   \n",
              "69797       1194550    2015022909  Acervo Circulante   \n",
              "\n",
              "                                               biblioteca status_material  \\\n",
              "index                                                                       \n",
              "406136  Biblioteca Setorial Pe. Jaime Diniz - Escola d...        ESPECIAL   \n",
              "261463  Biblioteca Setorial do Centro de Ciências Huma...         REGULAR   \n",
              "503782                     Biblioteca Central Zila Mamede         REGULAR   \n",
              "545643                     Biblioteca Central Zila Mamede         REGULAR   \n",
              "69797   Biblioteca Setorial Pe. Jaime Diniz - Escola d...         REGULAR   \n",
              "\n",
              "        localizacao  registro_sistema  \n",
              "index                                  \n",
              "406136          336            187898  \n",
              "261463          648            112264  \n",
              "503782          540            228129  \n",
              "545643          716            249854  \n",
              "69797           667             26548  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-fecd56c2-de91-44d0-aaa5-3db4e66ec97c\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>id_exemplar</th>\n",
              "      <th>codigo_barras</th>\n",
              "      <th>colecao</th>\n",
              "      <th>biblioteca</th>\n",
              "      <th>status_material</th>\n",
              "      <th>localizacao</th>\n",
              "      <th>registro_sistema</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>index</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>406136</th>\n",
              "      <td>1021441</td>\n",
              "      <td>2012062722</td>\n",
              "      <td>Multimeios</td>\n",
              "      <td>Biblioteca Setorial Pe. Jaime Diniz - Escola d...</td>\n",
              "      <td>ESPECIAL</td>\n",
              "      <td>336</td>\n",
              "      <td>187898</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>261463</th>\n",
              "      <td>259614</td>\n",
              "      <td>2008032080</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Setorial do Centro de Ciências Huma...</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>648</td>\n",
              "      <td>112264</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>503782</th>\n",
              "      <td>1213189</td>\n",
              "      <td>2016001046</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>540</td>\n",
              "      <td>228129</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>545643</th>\n",
              "      <td>1343826</td>\n",
              "      <td>2018031319</td>\n",
              "      <td>Folhetos</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>716</td>\n",
              "      <td>249854</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>69797</th>\n",
              "      <td>1194550</td>\n",
              "      <td>2015022909</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Setorial Pe. Jaime Diniz - Escola d...</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>667</td>\n",
              "      <td>26548</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-fecd56c2-de91-44d0-aaa5-3db4e66ec97c')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-fecd56c2-de91-44d0-aaa5-3db4e66ec97c button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-fecd56c2-de91-44d0-aaa5-3db4e66ec97c');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 92
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "acervo.shape"
      ],
      "metadata": {
        "id": "X52r2_x1vMT1",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "fbcd56af-1819-42e9-86a1-e9421281f6bb"
      },
      "execution_count": 93,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(546237, 7)"
            ]
          },
          "metadata": {},
          "execution_count": 93
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "acervo.dtypes"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "lnpOgcDipVVJ",
        "outputId": "edd31039-a784-4b25-aa70-be22c3467667"
      },
      "execution_count": 94,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "id_exemplar          int64\n",
              "codigo_barras       object\n",
              "colecao             object\n",
              "biblioteca          object\n",
              "status_material     object\n",
              "localizacao          int64\n",
              "registro_sistema     int64\n",
              "dtype: object"
            ]
          },
          "metadata": {},
          "execution_count": 94
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "acervo.isna().sum()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "PGfg6FEVpYnI",
        "outputId": "8b1ae276-ee48-43cc-b513-876492e509d7"
      },
      "execution_count": 95,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "id_exemplar         0\n",
              "codigo_barras       0\n",
              "colecao             0\n",
              "biblioteca          0\n",
              "status_material     0\n",
              "localizacao         0\n",
              "registro_sistema    0\n",
              "dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 95
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Merge:"
      ],
      "metadata": {
        "id": "FqQ1_QgGt3jQ"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "teste = pd.read_csv('https://raw.githubusercontent.com/FranciscoFoz/7_Days_of_Code_Alura-Python-Pandas/main/Dia_1-Importando_dados/Datasets/dados_emprestimos/emprestimos-20201.csv')\n",
        "teste.shape"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "OOjh2bHvJUCn",
        "outputId": "89ebffe1-4780-48a6-af39-0bf9e48c1364"
      },
      "execution_count": 96,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(26561, 7)"
            ]
          },
          "metadata": {},
          "execution_count": 96
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "teste.merge(acervo, how = 'inner', on = 'codigo_barras')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 939
        },
        "id": "YSSXafwiJT_4",
        "outputId": "3aef22db-0d01-46f4-ab8f-44d775cb389b"
      },
      "execution_count": 97,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "       id_emprestimo codigo_barras                 data_renovacao  \\\n",
              "0            2962509    2007005628                            NaN   \n",
              "1            2962511    2012008328                            NaN   \n",
              "2            2962852    2012008328                            NaN   \n",
              "3            2962512    2012055016  2020/01/17 09:56:18.380000000   \n",
              "4            2962513       L197391  2020/01/17 23:50:18.862000000   \n",
              "...              ...           ...                            ...   \n",
              "25605        2989076    2019014718                            NaN   \n",
              "25606        2989077    2014012921                            NaN   \n",
              "25607        2989079    2012010451                            NaN   \n",
              "25608        2989089    2010048023                            NaN   \n",
              "25609        2989090    2013106838                            NaN   \n",
              "\n",
              "                     data_emprestimo                 data_devolucao  \\\n",
              "0      2020/01/02 08:17:30.290000000  2020/01/07 11:14:07.000000000   \n",
              "1      2020/01/02 08:17:30.436000000  2020/01/07 11:24:46.000000000   \n",
              "2      2020/01/07 11:27:49.186000000  2020/01/07 11:27:56.000000000   \n",
              "3      2020/01/02 08:36:40.163000000  2020/01/31 14:53:52.000000000   \n",
              "4      2020/01/02 09:36:03.877000000  2020/01/24 08:18:19.000000000   \n",
              "...                              ...                            ...   \n",
              "25605  2020/03/19 10:18:42.837000000                            NaN   \n",
              "25606  2020/03/19 14:41:57.754000000  2021/08/18 16:28:37.000000000   \n",
              "25607  2020/03/19 14:43:40.666000000  2021/08/18 16:29:00.000000000   \n",
              "25608  2020/06/09 11:54:02.669000000  2021/07/21 15:33:55.000000000   \n",
              "25609  2020/06/09 11:54:02.852000000  2021/07/21 15:33:45.000000000   \n",
              "\n",
              "       matricula_ou_siape    tipo_vinculo_usuario  id_exemplar  \\\n",
              "0            2.018103e+10  ALUNO DE PÓS-GRADUAÇÃO       216276   \n",
              "1            2.018103e+10  ALUNO DE PÓS-GRADUAÇÃO       971301   \n",
              "2            1.985042e+08                 DOCENTE       971301   \n",
              "3            2.019015e+10      ALUNO DE GRADUAÇÃO      1019380   \n",
              "4            2.018005e+10      ALUNO DE GRADUAÇÃO       177552   \n",
              "...                   ...                     ...          ...   \n",
              "25605        2.019101e+10  ALUNO DE PÓS-GRADUAÇÃO      1323312   \n",
              "25606        2.019102e+10  ALUNO DE PÓS-GRADUAÇÃO      1107682   \n",
              "25607        2.019102e+10  ALUNO DE PÓS-GRADUAÇÃO       984573   \n",
              "25608        2.020101e+10  ALUNO DE PÓS-GRADUAÇÃO       804885   \n",
              "25609        2.020101e+10  ALUNO DE PÓS-GRADUAÇÃO      1099777   \n",
              "\n",
              "                 colecao                                         biblioteca  \\\n",
              "0      Acervo Circulante                     Biblioteca Central Zila Mamede   \n",
              "1      Acervo Circulante                     Biblioteca Central Zila Mamede   \n",
              "2      Acervo Circulante                     Biblioteca Central Zila Mamede   \n",
              "3      Acervo Circulante                     Biblioteca Central Zila Mamede   \n",
              "4      Acervo Circulante                     Biblioteca Central Zila Mamede   \n",
              "...                  ...                                                ...   \n",
              "25605  Acervo Circulante  Biblioteca Setorial do Núcleo de Educação da I...   \n",
              "25606  Acervo Circulante  Biblioteca Setorial da Faculdade de Ciências d...   \n",
              "25607  Acervo Circulante  Biblioteca Setorial da Faculdade de Ciências d...   \n",
              "25608  Acervo Circulante                     Biblioteca Central Zila Mamede   \n",
              "25609  Acervo Circulante                     Biblioteca Central Zila Mamede   \n",
              "\n",
              "      status_material  localizacao  registro_sistema  \n",
              "0             REGULAR          640             87626  \n",
              "1             REGULAR          350            176661  \n",
              "2             REGULAR          350            176661  \n",
              "3             REGULAR          696            168729  \n",
              "4             REGULAR          699             67693  \n",
              "...               ...          ...               ...  \n",
              "25605         REGULAR          514            236084  \n",
              "25606         REGULAR          364            178538  \n",
              "25607         REGULAR          379            179637  \n",
              "25608         REGULAR          675             67712  \n",
              "25609         REGULAR           14            205153  \n",
              "\n",
              "[25610 rows x 13 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-ad4d92c4-0ffe-4433-abcd-4d0b50093227\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>id_emprestimo</th>\n",
              "      <th>codigo_barras</th>\n",
              "      <th>data_renovacao</th>\n",
              "      <th>data_emprestimo</th>\n",
              "      <th>data_devolucao</th>\n",
              "      <th>matricula_ou_siape</th>\n",
              "      <th>tipo_vinculo_usuario</th>\n",
              "      <th>id_exemplar</th>\n",
              "      <th>colecao</th>\n",
              "      <th>biblioteca</th>\n",
              "      <th>status_material</th>\n",
              "      <th>localizacao</th>\n",
              "      <th>registro_sistema</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2962509</td>\n",
              "      <td>2007005628</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2020/01/02 08:17:30.290000000</td>\n",
              "      <td>2020/01/07 11:14:07.000000000</td>\n",
              "      <td>2.018103e+10</td>\n",
              "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
              "      <td>216276</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>640</td>\n",
              "      <td>87626</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2962511</td>\n",
              "      <td>2012008328</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2020/01/02 08:17:30.436000000</td>\n",
              "      <td>2020/01/07 11:24:46.000000000</td>\n",
              "      <td>2.018103e+10</td>\n",
              "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
              "      <td>971301</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>350</td>\n",
              "      <td>176661</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2962852</td>\n",
              "      <td>2012008328</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2020/01/07 11:27:49.186000000</td>\n",
              "      <td>2020/01/07 11:27:56.000000000</td>\n",
              "      <td>1.985042e+08</td>\n",
              "      <td>DOCENTE</td>\n",
              "      <td>971301</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>350</td>\n",
              "      <td>176661</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2962512</td>\n",
              "      <td>2012055016</td>\n",
              "      <td>2020/01/17 09:56:18.380000000</td>\n",
              "      <td>2020/01/02 08:36:40.163000000</td>\n",
              "      <td>2020/01/31 14:53:52.000000000</td>\n",
              "      <td>2.019015e+10</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>1019380</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>696</td>\n",
              "      <td>168729</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2962513</td>\n",
              "      <td>L197391</td>\n",
              "      <td>2020/01/17 23:50:18.862000000</td>\n",
              "      <td>2020/01/02 09:36:03.877000000</td>\n",
              "      <td>2020/01/24 08:18:19.000000000</td>\n",
              "      <td>2.018005e+10</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>177552</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>699</td>\n",
              "      <td>67693</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",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25605</th>\n",
              "      <td>2989076</td>\n",
              "      <td>2019014718</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2020/03/19 10:18:42.837000000</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.019101e+10</td>\n",
              "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
              "      <td>1323312</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Setorial do Núcleo de Educação da I...</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>514</td>\n",
              "      <td>236084</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25606</th>\n",
              "      <td>2989077</td>\n",
              "      <td>2014012921</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2020/03/19 14:41:57.754000000</td>\n",
              "      <td>2021/08/18 16:28:37.000000000</td>\n",
              "      <td>2.019102e+10</td>\n",
              "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
              "      <td>1107682</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Setorial da Faculdade de Ciências d...</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>364</td>\n",
              "      <td>178538</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25607</th>\n",
              "      <td>2989079</td>\n",
              "      <td>2012010451</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2020/03/19 14:43:40.666000000</td>\n",
              "      <td>2021/08/18 16:29:00.000000000</td>\n",
              "      <td>2.019102e+10</td>\n",
              "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
              "      <td>984573</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Setorial da Faculdade de Ciências d...</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>379</td>\n",
              "      <td>179637</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25608</th>\n",
              "      <td>2989089</td>\n",
              "      <td>2010048023</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2020/06/09 11:54:02.669000000</td>\n",
              "      <td>2021/07/21 15:33:55.000000000</td>\n",
              "      <td>2.020101e+10</td>\n",
              "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
              "      <td>804885</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>675</td>\n",
              "      <td>67712</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25609</th>\n",
              "      <td>2989090</td>\n",
              "      <td>2013106838</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2020/06/09 11:54:02.852000000</td>\n",
              "      <td>2021/07/21 15:33:45.000000000</td>\n",
              "      <td>2.020101e+10</td>\n",
              "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
              "      <td>1099777</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>14</td>\n",
              "      <td>205153</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>25610 rows × 13 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-ad4d92c4-0ffe-4433-abcd-4d0b50093227')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-ad4d92c4-0ffe-4433-abcd-4d0b50093227 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-ad4d92c4-0ffe-4433-abcd-4d0b50093227');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 97
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "teste.merge(acervo, how = 'left', on = 'codigo_barras')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 922
        },
        "id": "QHQmUoG5JT9J",
        "outputId": "0e26b818-3294-4d5f-ad38-39ef08147407"
      },
      "execution_count": 98,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "       id_emprestimo codigo_barras                 data_renovacao  \\\n",
              "0            2962509    2007005628                            NaN   \n",
              "1            2962510       L202802                            NaN   \n",
              "2            2962511    2012008328                            NaN   \n",
              "3            2962512    2012055016  2020/01/17 09:56:18.380000000   \n",
              "4            2962513       L197391  2020/01/17 23:50:18.862000000   \n",
              "...              ...           ...                            ...   \n",
              "26631        2989086    2008047044                            NaN   \n",
              "26632        2989087    2008047047                            NaN   \n",
              "26633        2989088    2010052905                            NaN   \n",
              "26634        2989089    2010048023                            NaN   \n",
              "26635        2989090    2013106838                            NaN   \n",
              "\n",
              "                     data_emprestimo                 data_devolucao  \\\n",
              "0      2020/01/02 08:17:30.290000000  2020/01/07 11:14:07.000000000   \n",
              "1      2020/01/02 08:17:30.391000000  2020/01/07 11:14:17.000000000   \n",
              "2      2020/01/02 08:17:30.436000000  2020/01/07 11:24:46.000000000   \n",
              "3      2020/01/02 08:36:40.163000000  2020/01/31 14:53:52.000000000   \n",
              "4      2020/01/02 09:36:03.877000000  2020/01/24 08:18:19.000000000   \n",
              "...                              ...                            ...   \n",
              "26631  2020/05/05 19:51:06.059000000  2021/05/13 14:53:31.000000000   \n",
              "26632  2020/05/05 19:51:06.135000000  2021/05/13 14:53:38.000000000   \n",
              "26633  2020/05/05 19:51:06.164000000  2021/05/13 15:01:46.000000000   \n",
              "26634  2020/06/09 11:54:02.669000000  2021/07/21 15:33:55.000000000   \n",
              "26635  2020/06/09 11:54:02.852000000  2021/07/21 15:33:45.000000000   \n",
              "\n",
              "       matricula_ou_siape             tipo_vinculo_usuario  id_exemplar  \\\n",
              "0            2.018103e+10           ALUNO DE PÓS-GRADUAÇÃO     216276.0   \n",
              "1            2.018103e+10           ALUNO DE PÓS-GRADUAÇÃO          NaN   \n",
              "2            2.018103e+10           ALUNO DE PÓS-GRADUAÇÃO     971301.0   \n",
              "3            2.019015e+10               ALUNO DE GRADUAÇÃO    1019380.0   \n",
              "4            2.018005e+10               ALUNO DE GRADUAÇÃO     177552.0   \n",
              "...                   ...                              ...          ...   \n",
              "26631        3.067431e+06  SERVIDOR TÉCNICO-ADMINISTRATIVO     256297.0   \n",
              "26632        3.067431e+06  SERVIDOR TÉCNICO-ADMINISTRATIVO     256406.0   \n",
              "26633        3.067431e+06  SERVIDOR TÉCNICO-ADMINISTRATIVO     807821.0   \n",
              "26634        2.020101e+10           ALUNO DE PÓS-GRADUAÇÃO     804885.0   \n",
              "26635        2.020101e+10           ALUNO DE PÓS-GRADUAÇÃO    1099777.0   \n",
              "\n",
              "                 colecao                                         biblioteca  \\\n",
              "0      Acervo Circulante                     Biblioteca Central Zila Mamede   \n",
              "1                    NaN                                                NaN   \n",
              "2      Acervo Circulante                     Biblioteca Central Zila Mamede   \n",
              "3      Acervo Circulante                     Biblioteca Central Zila Mamede   \n",
              "4      Acervo Circulante                     Biblioteca Central Zila Mamede   \n",
              "...                  ...                                                ...   \n",
              "26631  Acervo Circulante  Biblioteca Setorial da Faculdade de Ciências d...   \n",
              "26632  Acervo Circulante  Biblioteca Setorial da Faculdade de Ciências d...   \n",
              "26633  Acervo Circulante  Biblioteca Setorial da Faculdade de Ciências d...   \n",
              "26634  Acervo Circulante                     Biblioteca Central Zila Mamede   \n",
              "26635  Acervo Circulante                     Biblioteca Central Zila Mamede   \n",
              "\n",
              "      status_material  localizacao  registro_sistema  \n",
              "0             REGULAR        640.0           87626.0  \n",
              "1                 NaN          NaN               NaN  \n",
              "2             REGULAR        350.0          176661.0  \n",
              "3             REGULAR        696.0          168729.0  \n",
              "4             REGULAR        699.0           67693.0  \n",
              "...               ...          ...               ...  \n",
              "26631         REGULAR        684.0          110098.0  \n",
              "26632         REGULAR        628.0          110171.0  \n",
              "26633         REGULAR        653.0          134173.0  \n",
              "26634         REGULAR        675.0           67712.0  \n",
              "26635         REGULAR         14.0          205153.0  \n",
              "\n",
              "[26636 rows x 13 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-cf747ea6-5a11-4c93-af1c-990d7b4930f1\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>id_emprestimo</th>\n",
              "      <th>codigo_barras</th>\n",
              "      <th>data_renovacao</th>\n",
              "      <th>data_emprestimo</th>\n",
              "      <th>data_devolucao</th>\n",
              "      <th>matricula_ou_siape</th>\n",
              "      <th>tipo_vinculo_usuario</th>\n",
              "      <th>id_exemplar</th>\n",
              "      <th>colecao</th>\n",
              "      <th>biblioteca</th>\n",
              "      <th>status_material</th>\n",
              "      <th>localizacao</th>\n",
              "      <th>registro_sistema</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2962509</td>\n",
              "      <td>2007005628</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2020/01/02 08:17:30.290000000</td>\n",
              "      <td>2020/01/07 11:14:07.000000000</td>\n",
              "      <td>2.018103e+10</td>\n",
              "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
              "      <td>216276.0</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>640.0</td>\n",
              "      <td>87626.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2962510</td>\n",
              "      <td>L202802</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2020/01/02 08:17:30.391000000</td>\n",
              "      <td>2020/01/07 11:14:17.000000000</td>\n",
              "      <td>2.018103e+10</td>\n",
              "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2962511</td>\n",
              "      <td>2012008328</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2020/01/02 08:17:30.436000000</td>\n",
              "      <td>2020/01/07 11:24:46.000000000</td>\n",
              "      <td>2.018103e+10</td>\n",
              "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
              "      <td>971301.0</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>350.0</td>\n",
              "      <td>176661.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2962512</td>\n",
              "      <td>2012055016</td>\n",
              "      <td>2020/01/17 09:56:18.380000000</td>\n",
              "      <td>2020/01/02 08:36:40.163000000</td>\n",
              "      <td>2020/01/31 14:53:52.000000000</td>\n",
              "      <td>2.019015e+10</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>1019380.0</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>696.0</td>\n",
              "      <td>168729.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2962513</td>\n",
              "      <td>L197391</td>\n",
              "      <td>2020/01/17 23:50:18.862000000</td>\n",
              "      <td>2020/01/02 09:36:03.877000000</td>\n",
              "      <td>2020/01/24 08:18:19.000000000</td>\n",
              "      <td>2.018005e+10</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>177552.0</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>699.0</td>\n",
              "      <td>67693.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",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26631</th>\n",
              "      <td>2989086</td>\n",
              "      <td>2008047044</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2020/05/05 19:51:06.059000000</td>\n",
              "      <td>2021/05/13 14:53:31.000000000</td>\n",
              "      <td>3.067431e+06</td>\n",
              "      <td>SERVIDOR TÉCNICO-ADMINISTRATIVO</td>\n",
              "      <td>256297.0</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Setorial da Faculdade de Ciências d...</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>684.0</td>\n",
              "      <td>110098.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26632</th>\n",
              "      <td>2989087</td>\n",
              "      <td>2008047047</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2020/05/05 19:51:06.135000000</td>\n",
              "      <td>2021/05/13 14:53:38.000000000</td>\n",
              "      <td>3.067431e+06</td>\n",
              "      <td>SERVIDOR TÉCNICO-ADMINISTRATIVO</td>\n",
              "      <td>256406.0</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Setorial da Faculdade de Ciências d...</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>628.0</td>\n",
              "      <td>110171.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26633</th>\n",
              "      <td>2989088</td>\n",
              "      <td>2010052905</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2020/05/05 19:51:06.164000000</td>\n",
              "      <td>2021/05/13 15:01:46.000000000</td>\n",
              "      <td>3.067431e+06</td>\n",
              "      <td>SERVIDOR TÉCNICO-ADMINISTRATIVO</td>\n",
              "      <td>807821.0</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Setorial da Faculdade de Ciências d...</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>653.0</td>\n",
              "      <td>134173.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26634</th>\n",
              "      <td>2989089</td>\n",
              "      <td>2010048023</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2020/06/09 11:54:02.669000000</td>\n",
              "      <td>2021/07/21 15:33:55.000000000</td>\n",
              "      <td>2.020101e+10</td>\n",
              "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
              "      <td>804885.0</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>675.0</td>\n",
              "      <td>67712.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26635</th>\n",
              "      <td>2989090</td>\n",
              "      <td>2013106838</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2020/06/09 11:54:02.852000000</td>\n",
              "      <td>2021/07/21 15:33:45.000000000</td>\n",
              "      <td>2.020101e+10</td>\n",
              "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
              "      <td>1099777.0</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>14.0</td>\n",
              "      <td>205153.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>26636 rows × 13 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-cf747ea6-5a11-4c93-af1c-990d7b4930f1')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-cf747ea6-5a11-4c93-af1c-990d7b4930f1 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-cf747ea6-5a11-4c93-af1c-990d7b4930f1');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 98
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "teste.merge(acervo, how = 'right', on = 'codigo_barras')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 870
        },
        "id": "2dafHelrJT59",
        "outputId": "3f4f8c85-4e9b-4308-9a2a-263ac65e9908"
      },
      "execution_count": 99,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "        id_emprestimo codigo_barras data_renovacao data_emprestimo  \\\n",
              "0                 NaN       L000003            NaN             NaN   \n",
              "1                 NaN       L000002            NaN             NaN   \n",
              "2                 NaN       L000001            NaN             NaN   \n",
              "3                 NaN       L000114            NaN             NaN   \n",
              "4                 NaN       L000041            NaN             NaN   \n",
              "...               ...           ...            ...             ...   \n",
              "549749            NaN    2021011150            NaN             NaN   \n",
              "549750            NaN    2019013454            NaN             NaN   \n",
              "549751            NaN    2019012811            NaN             NaN   \n",
              "549752            NaN    2019013451            NaN             NaN   \n",
              "549753            NaN    2019012276            NaN             NaN   \n",
              "\n",
              "       data_devolucao  matricula_ou_siape tipo_vinculo_usuario  id_exemplar  \\\n",
              "0                 NaN                 NaN                  NaN            5   \n",
              "1                 NaN                 NaN                  NaN            4   \n",
              "2                 NaN                 NaN                  NaN            3   \n",
              "3                 NaN                 NaN                  NaN            7   \n",
              "4                 NaN                 NaN                  NaN           10   \n",
              "...               ...                 ...                  ...          ...   \n",
              "549749            NaN                 NaN                  NaN      1353472   \n",
              "549750            NaN                 NaN                  NaN      1353473   \n",
              "549751            NaN                 NaN                  NaN      1353474   \n",
              "549752            NaN                 NaN                  NaN      1353475   \n",
              "549753            NaN                 NaN                  NaN      1353476   \n",
              "\n",
              "                  colecao                                         biblioteca  \\\n",
              "0       Acervo Circulante                     Biblioteca Central Zila Mamede   \n",
              "1       Acervo Circulante                     Biblioteca Central Zila Mamede   \n",
              "2       Acervo Circulante                     Biblioteca Central Zila Mamede   \n",
              "3       Acervo Circulante                     Biblioteca Central Zila Mamede   \n",
              "4       Acervo Circulante                     Biblioteca Central Zila Mamede   \n",
              "...                   ...                                                ...   \n",
              "549749  Acervo Circulante  Biblioteca Setorial do Núcleo de Educação da I...   \n",
              "549750  Acervo Circulante                     Biblioteca Central Zila Mamede   \n",
              "549751  Acervo Circulante                     Biblioteca Central Zila Mamede   \n",
              "549752  Acervo Circulante                     Biblioteca Central Zila Mamede   \n",
              "549753  Acervo Circulante                     Biblioteca Central Zila Mamede   \n",
              "\n",
              "       status_material  localizacao  registro_sistema  \n",
              "0              REGULAR          694                 1  \n",
              "1              REGULAR          688                 1  \n",
              "2             ESPECIAL          638                 1  \n",
              "3              REGULAR          616                 5  \n",
              "4             ESPECIAL          657                15  \n",
              "...                ...          ...               ...  \n",
              "549749         REGULAR          951            268231  \n",
              "549750        ESPECIAL          997            268233  \n",
              "549751        ESPECIAL          987            268234  \n",
              "549752        ESPECIAL          764            268235  \n",
              "549753        ESPECIAL          962            268236  \n",
              "\n",
              "[549754 rows x 13 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-972e9eda-ab43-4d71-ae21-3cb9990db29c\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>id_emprestimo</th>\n",
              "      <th>codigo_barras</th>\n",
              "      <th>data_renovacao</th>\n",
              "      <th>data_emprestimo</th>\n",
              "      <th>data_devolucao</th>\n",
              "      <th>matricula_ou_siape</th>\n",
              "      <th>tipo_vinculo_usuario</th>\n",
              "      <th>id_exemplar</th>\n",
              "      <th>colecao</th>\n",
              "      <th>biblioteca</th>\n",
              "      <th>status_material</th>\n",
              "      <th>localizacao</th>\n",
              "      <th>registro_sistema</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>NaN</td>\n",
              "      <td>L000003</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>694</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>NaN</td>\n",
              "      <td>L000002</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>688</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>NaN</td>\n",
              "      <td>L000001</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>ESPECIAL</td>\n",
              "      <td>638</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>NaN</td>\n",
              "      <td>L000114</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>616</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>NaN</td>\n",
              "      <td>L000041</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>10</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>ESPECIAL</td>\n",
              "      <td>657</td>\n",
              "      <td>15</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",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>549749</th>\n",
              "      <td>NaN</td>\n",
              "      <td>2021011150</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1353472</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Setorial do Núcleo de Educação da I...</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>951</td>\n",
              "      <td>268231</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>549750</th>\n",
              "      <td>NaN</td>\n",
              "      <td>2019013454</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1353473</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>ESPECIAL</td>\n",
              "      <td>997</td>\n",
              "      <td>268233</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>549751</th>\n",
              "      <td>NaN</td>\n",
              "      <td>2019012811</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1353474</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>ESPECIAL</td>\n",
              "      <td>987</td>\n",
              "      <td>268234</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>549752</th>\n",
              "      <td>NaN</td>\n",
              "      <td>2019013451</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1353475</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>ESPECIAL</td>\n",
              "      <td>764</td>\n",
              "      <td>268235</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>549753</th>\n",
              "      <td>NaN</td>\n",
              "      <td>2019012276</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1353476</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>ESPECIAL</td>\n",
              "      <td>962</td>\n",
              "      <td>268236</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>549754 rows × 13 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-972e9eda-ab43-4d71-ae21-3cb9990db29c')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-972e9eda-ab43-4d71-ae21-3cb9990db29c button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-972e9eda-ab43-4d71-ae21-3cb9990db29c');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 99
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "\n",
        "Diante o resultado destes testes, achei melhor fazer a união através do *inner* e perder alguns registros, do que acabar criando dados.\n",
        "\n",
        "---\n",
        "\n"
      ],
      "metadata": {
        "id": "dvKsIk2NJ7F7"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "dados = emprestimos.merge(acervo, how = 'inner', on = 'codigo_barras')\n",
        "dados.head(3)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 312
        },
        "id": "5WkCaWu2qVFw",
        "outputId": "cc0a4a4c-00f7-448e-e01d-3c197aabf741"
      },
      "execution_count": 100,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   id_emprestimo codigo_barras          data_renovacao  \\\n",
              "0         709684       L095049                     NaT   \n",
              "1         709684       L095049                     NaT   \n",
              "2         726965       L095049 2010-03-31 12:41:08.684   \n",
              "\n",
              "          data_emprestimo          data_devolucao matricula_ou_siape  \\\n",
              "0 2010-01-04 07:44:10.721 2010-01-05 16:26:12.662       2008023265.0   \n",
              "1 2010-01-04 07:44:10.721 2010-01-05 16:26:12.662       2008023265.0   \n",
              "2 2010-03-01 12:40:56.212 2010-04-30 14:42:35.366       2009121584.0   \n",
              "\n",
              "     tipo_vinculo_usuario  id_exemplar            colecao  \\\n",
              "0      ALUNO DE GRADUAÇÃO        13259  Acervo Circulante   \n",
              "1      ALUNO DE GRADUAÇÃO        13259  Acervo Circulante   \n",
              "2  ALUNO DE PÓS-GRADUAÇÃO        13259  Acervo Circulante   \n",
              "\n",
              "                       biblioteca status_material  localizacao  \\\n",
              "0  Biblioteca Central Zila Mamede         REGULAR          630   \n",
              "1  Biblioteca Central Zila Mamede         REGULAR          630   \n",
              "2  Biblioteca Central Zila Mamede         REGULAR          630   \n",
              "\n",
              "   registro_sistema  \n",
              "0              4225  \n",
              "1              4225  \n",
              "2              4225  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-52572947-48cc-4b92-b99b-a95c3d506588\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>id_emprestimo</th>\n",
              "      <th>codigo_barras</th>\n",
              "      <th>data_renovacao</th>\n",
              "      <th>data_emprestimo</th>\n",
              "      <th>data_devolucao</th>\n",
              "      <th>matricula_ou_siape</th>\n",
              "      <th>tipo_vinculo_usuario</th>\n",
              "      <th>id_exemplar</th>\n",
              "      <th>colecao</th>\n",
              "      <th>biblioteca</th>\n",
              "      <th>status_material</th>\n",
              "      <th>localizacao</th>\n",
              "      <th>registro_sistema</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>709684</td>\n",
              "      <td>L095049</td>\n",
              "      <td>NaT</td>\n",
              "      <td>2010-01-04 07:44:10.721</td>\n",
              "      <td>2010-01-05 16:26:12.662</td>\n",
              "      <td>2008023265.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>13259</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>630</td>\n",
              "      <td>4225</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>709684</td>\n",
              "      <td>L095049</td>\n",
              "      <td>NaT</td>\n",
              "      <td>2010-01-04 07:44:10.721</td>\n",
              "      <td>2010-01-05 16:26:12.662</td>\n",
              "      <td>2008023265.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>13259</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>630</td>\n",
              "      <td>4225</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>726965</td>\n",
              "      <td>L095049</td>\n",
              "      <td>2010-03-31 12:41:08.684</td>\n",
              "      <td>2010-03-01 12:40:56.212</td>\n",
              "      <td>2010-04-30 14:42:35.366</td>\n",
              "      <td>2009121584.0</td>\n",
              "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
              "      <td>13259</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>630</td>\n",
              "      <td>4225</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-52572947-48cc-4b92-b99b-a95c3d506588')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-52572947-48cc-4b92-b99b-a95c3d506588 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-52572947-48cc-4b92-b99b-a95c3d506588');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 100
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "dados.shape"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "2Nt8T0pUuMS4",
        "outputId": "478b0070-09b9-42a2-a1b3-2879508c881a"
      },
      "execution_count": 101,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(2072558, 13)"
            ]
          },
          "metadata": {},
          "execution_count": 101
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "dados.isna().sum()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "_Y8Q71MkuyEK",
        "outputId": "34447f0f-be16-4937-f7dc-4b9bb3633563"
      },
      "execution_count": 102,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "id_emprestimo                 0\n",
              "codigo_barras                 0\n",
              "data_renovacao          1162088\n",
              "data_emprestimo               0\n",
              "data_devolucao             6178\n",
              "matricula_ou_siape            0\n",
              "tipo_vinculo_usuario          0\n",
              "id_exemplar                   0\n",
              "colecao                       0\n",
              "biblioteca                    0\n",
              "status_material               0\n",
              "localizacao                   0\n",
              "registro_sistema              0\n",
              "dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 102
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Limpeza:"
      ],
      "metadata": {
        "id": "PTYw-HRVwP6x"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "dados.id_emprestimo.value_counts()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "xi5KEQ3bu5CB",
        "outputId": "66e00684-3ab1-4cec-be3e-a9379efb72f0"
      },
      "execution_count": 103,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "709705     7\n",
              "709704     7\n",
              "2422542    6\n",
              "2460196    4\n",
              "2378367    4\n",
              "          ..\n",
              "1275779    1\n",
              "1242892    1\n",
              "1122431    1\n",
              "1099303    1\n",
              "2989061    1\n",
              "Name: id_emprestimo, Length: 1955945, dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 103
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "dados.data_emprestimo.value_counts()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "aHPqfDyjwWZY",
        "outputId": "a5808f8a-3fa5-4b96-9c65-9b4b18010dc7"
      },
      "execution_count": 104,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "2010-01-04 09:58:46.522    7\n",
              "2010-01-04 09:58:46.549    7\n",
              "2018-11-22 18:28:01.619    3\n",
              "2015-06-02 17:56:18.917    3\n",
              "2014-07-14 15:35:51.822    3\n",
              "                          ..\n",
              "2010-12-27 12:09:21.821    1\n",
              "2010-11-12 11:05:56.168    1\n",
              "2010-11-12 11:04:24.054    1\n",
              "2010-11-12 11:04:01.919    1\n",
              "2020-03-17 21:22:22.138    1\n",
              "Name: data_emprestimo, Length: 2068691, dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 104
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "dados.query('id_emprestimo == 709705')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 576
        },
        "id": "YrY2zkLI39MS",
        "outputId": "5475c0e0-c293-4ed8-cf3b-44c459aada1e"
      },
      "execution_count": 105,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "     id_emprestimo codigo_barras          data_renovacao  \\\n",
              "386         709705    2009032168 2010-01-17 18:56:43.909   \n",
              "387         709705    2009032168 2010-01-17 18:56:43.909   \n",
              "388         709705    2009032168 2010-01-17 18:56:43.909   \n",
              "389         709705    2009032168 2010-01-17 18:56:43.909   \n",
              "390         709705    2009032168 2010-01-17 18:56:43.909   \n",
              "391         709705    2009032168 2010-01-17 18:56:43.909   \n",
              "392         709705    2009032168 2010-01-17 18:56:43.909   \n",
              "\n",
              "            data_emprestimo          data_devolucao matricula_ou_siape  \\\n",
              "386 2010-01-04 09:58:46.549 2010-01-20 13:14:34.464       2008009890.0   \n",
              "387 2010-01-04 09:58:46.549 2010-01-20 13:14:34.464       2008009890.0   \n",
              "388 2010-01-04 09:58:46.549 2010-01-20 13:14:34.464       2008009890.0   \n",
              "389 2010-01-04 09:58:46.549 2010-01-20 13:14:34.464       2008009890.0   \n",
              "390 2010-01-04 09:58:46.549 2010-01-20 13:14:34.464       2008009890.0   \n",
              "391 2010-01-04 09:58:46.549 2010-01-20 13:14:34.464       2008009890.0   \n",
              "392 2010-01-04 09:58:46.549 2010-01-20 13:14:34.464       2008009890.0   \n",
              "\n",
              "    tipo_vinculo_usuario  id_exemplar            colecao  \\\n",
              "386   ALUNO DE GRADUAÇÃO       273487  Acervo Circulante   \n",
              "387   ALUNO DE GRADUAÇÃO       273487  Acervo Circulante   \n",
              "388   ALUNO DE GRADUAÇÃO       273487  Acervo Circulante   \n",
              "389   ALUNO DE GRADUAÇÃO       273487  Acervo Circulante   \n",
              "390   ALUNO DE GRADUAÇÃO       273487  Acervo Circulante   \n",
              "391   ALUNO DE GRADUAÇÃO       273487  Acervo Circulante   \n",
              "392   ALUNO DE GRADUAÇÃO       273487  Acervo Circulante   \n",
              "\n",
              "                         biblioteca status_material  localizacao  \\\n",
              "386  Biblioteca Central Zila Mamede         REGULAR          623   \n",
              "387  Biblioteca Central Zila Mamede         REGULAR          623   \n",
              "388  Biblioteca Central Zila Mamede         REGULAR          623   \n",
              "389  Biblioteca Central Zila Mamede         REGULAR          623   \n",
              "390  Biblioteca Central Zila Mamede         REGULAR          623   \n",
              "391  Biblioteca Central Zila Mamede         REGULAR          623   \n",
              "392  Biblioteca Central Zila Mamede         REGULAR          623   \n",
              "\n",
              "     registro_sistema  \n",
              "386            120127  \n",
              "387            120127  \n",
              "388            120127  \n",
              "389            120127  \n",
              "390            120127  \n",
              "391            120127  \n",
              "392            120127  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-a3da129c-10dd-4179-a414-f71a4c8b5a5a\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>id_emprestimo</th>\n",
              "      <th>codigo_barras</th>\n",
              "      <th>data_renovacao</th>\n",
              "      <th>data_emprestimo</th>\n",
              "      <th>data_devolucao</th>\n",
              "      <th>matricula_ou_siape</th>\n",
              "      <th>tipo_vinculo_usuario</th>\n",
              "      <th>id_exemplar</th>\n",
              "      <th>colecao</th>\n",
              "      <th>biblioteca</th>\n",
              "      <th>status_material</th>\n",
              "      <th>localizacao</th>\n",
              "      <th>registro_sistema</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>386</th>\n",
              "      <td>709705</td>\n",
              "      <td>2009032168</td>\n",
              "      <td>2010-01-17 18:56:43.909</td>\n",
              "      <td>2010-01-04 09:58:46.549</td>\n",
              "      <td>2010-01-20 13:14:34.464</td>\n",
              "      <td>2008009890.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>273487</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>623</td>\n",
              "      <td>120127</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>387</th>\n",
              "      <td>709705</td>\n",
              "      <td>2009032168</td>\n",
              "      <td>2010-01-17 18:56:43.909</td>\n",
              "      <td>2010-01-04 09:58:46.549</td>\n",
              "      <td>2010-01-20 13:14:34.464</td>\n",
              "      <td>2008009890.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>273487</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>623</td>\n",
              "      <td>120127</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>388</th>\n",
              "      <td>709705</td>\n",
              "      <td>2009032168</td>\n",
              "      <td>2010-01-17 18:56:43.909</td>\n",
              "      <td>2010-01-04 09:58:46.549</td>\n",
              "      <td>2010-01-20 13:14:34.464</td>\n",
              "      <td>2008009890.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>273487</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>623</td>\n",
              "      <td>120127</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>389</th>\n",
              "      <td>709705</td>\n",
              "      <td>2009032168</td>\n",
              "      <td>2010-01-17 18:56:43.909</td>\n",
              "      <td>2010-01-04 09:58:46.549</td>\n",
              "      <td>2010-01-20 13:14:34.464</td>\n",
              "      <td>2008009890.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>273487</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>623</td>\n",
              "      <td>120127</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>390</th>\n",
              "      <td>709705</td>\n",
              "      <td>2009032168</td>\n",
              "      <td>2010-01-17 18:56:43.909</td>\n",
              "      <td>2010-01-04 09:58:46.549</td>\n",
              "      <td>2010-01-20 13:14:34.464</td>\n",
              "      <td>2008009890.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>273487</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>623</td>\n",
              "      <td>120127</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>391</th>\n",
              "      <td>709705</td>\n",
              "      <td>2009032168</td>\n",
              "      <td>2010-01-17 18:56:43.909</td>\n",
              "      <td>2010-01-04 09:58:46.549</td>\n",
              "      <td>2010-01-20 13:14:34.464</td>\n",
              "      <td>2008009890.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>273487</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>623</td>\n",
              "      <td>120127</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>392</th>\n",
              "      <td>709705</td>\n",
              "      <td>2009032168</td>\n",
              "      <td>2010-01-17 18:56:43.909</td>\n",
              "      <td>2010-01-04 09:58:46.549</td>\n",
              "      <td>2010-01-20 13:14:34.464</td>\n",
              "      <td>2008009890.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>273487</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>623</td>\n",
              "      <td>120127</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-a3da129c-10dd-4179-a414-f71a4c8b5a5a')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-a3da129c-10dd-4179-a414-f71a4c8b5a5a button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-a3da129c-10dd-4179-a414-f71a4c8b5a5a');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 105
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "dados.query('id_emprestimo == 709704')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 576
        },
        "id": "A6-TQmgu0Z8a",
        "outputId": "491612f5-bb55-41b6-f80c-56422455cdc1"
      },
      "execution_count": 106,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "     id_emprestimo codigo_barras          data_renovacao  \\\n",
              "335         709704    2006021442 2010-01-17 18:56:43.923   \n",
              "336         709704    2006021442 2010-01-17 18:56:43.923   \n",
              "337         709704    2006021442 2010-01-17 18:56:43.923   \n",
              "338         709704    2006021442 2010-01-17 18:56:43.923   \n",
              "339         709704    2006021442 2010-01-17 18:56:43.923   \n",
              "340         709704    2006021442 2010-01-17 18:56:43.923   \n",
              "341         709704    2006021442 2010-01-17 18:56:43.923   \n",
              "\n",
              "            data_emprestimo          data_devolucao matricula_ou_siape  \\\n",
              "335 2010-01-04 09:58:46.522 2010-02-01 13:59:02.528       2008009890.0   \n",
              "336 2010-01-04 09:58:46.522 2010-02-01 13:59:02.528       2008009890.0   \n",
              "337 2010-01-04 09:58:46.522 2010-02-01 13:59:02.528       2008009890.0   \n",
              "338 2010-01-04 09:58:46.522 2010-02-01 13:59:02.528       2008009890.0   \n",
              "339 2010-01-04 09:58:46.522 2010-02-01 13:59:02.528       2008009890.0   \n",
              "340 2010-01-04 09:58:46.522 2010-02-01 13:59:02.528       2008009890.0   \n",
              "341 2010-01-04 09:58:46.522 2010-02-01 13:59:02.528       2008009890.0   \n",
              "\n",
              "    tipo_vinculo_usuario  id_exemplar            colecao  \\\n",
              "335   ALUNO DE GRADUAÇÃO       199419  Acervo Circulante   \n",
              "336   ALUNO DE GRADUAÇÃO       199419  Acervo Circulante   \n",
              "337   ALUNO DE GRADUAÇÃO       199419  Acervo Circulante   \n",
              "338   ALUNO DE GRADUAÇÃO       199419  Acervo Circulante   \n",
              "339   ALUNO DE GRADUAÇÃO       199419  Acervo Circulante   \n",
              "340   ALUNO DE GRADUAÇÃO       199419  Acervo Circulante   \n",
              "341   ALUNO DE GRADUAÇÃO       199419  Acervo Circulante   \n",
              "\n",
              "                         biblioteca status_material  localizacao  \\\n",
              "335  Biblioteca Central Zila Mamede         REGULAR          699   \n",
              "336  Biblioteca Central Zila Mamede         REGULAR          699   \n",
              "337  Biblioteca Central Zila Mamede         REGULAR          699   \n",
              "338  Biblioteca Central Zila Mamede         REGULAR          699   \n",
              "339  Biblioteca Central Zila Mamede         REGULAR          699   \n",
              "340  Biblioteca Central Zila Mamede         REGULAR          699   \n",
              "341  Biblioteca Central Zila Mamede         REGULAR          699   \n",
              "\n",
              "     registro_sistema  \n",
              "335             77866  \n",
              "336             77866  \n",
              "337             77866  \n",
              "338             77866  \n",
              "339             77866  \n",
              "340             77866  \n",
              "341             77866  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-20418625-0ae0-4865-b49e-0cf116a04985\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>id_emprestimo</th>\n",
              "      <th>codigo_barras</th>\n",
              "      <th>data_renovacao</th>\n",
              "      <th>data_emprestimo</th>\n",
              "      <th>data_devolucao</th>\n",
              "      <th>matricula_ou_siape</th>\n",
              "      <th>tipo_vinculo_usuario</th>\n",
              "      <th>id_exemplar</th>\n",
              "      <th>colecao</th>\n",
              "      <th>biblioteca</th>\n",
              "      <th>status_material</th>\n",
              "      <th>localizacao</th>\n",
              "      <th>registro_sistema</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>335</th>\n",
              "      <td>709704</td>\n",
              "      <td>2006021442</td>\n",
              "      <td>2010-01-17 18:56:43.923</td>\n",
              "      <td>2010-01-04 09:58:46.522</td>\n",
              "      <td>2010-02-01 13:59:02.528</td>\n",
              "      <td>2008009890.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>199419</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>699</td>\n",
              "      <td>77866</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>336</th>\n",
              "      <td>709704</td>\n",
              "      <td>2006021442</td>\n",
              "      <td>2010-01-17 18:56:43.923</td>\n",
              "      <td>2010-01-04 09:58:46.522</td>\n",
              "      <td>2010-02-01 13:59:02.528</td>\n",
              "      <td>2008009890.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>199419</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>699</td>\n",
              "      <td>77866</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>337</th>\n",
              "      <td>709704</td>\n",
              "      <td>2006021442</td>\n",
              "      <td>2010-01-17 18:56:43.923</td>\n",
              "      <td>2010-01-04 09:58:46.522</td>\n",
              "      <td>2010-02-01 13:59:02.528</td>\n",
              "      <td>2008009890.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>199419</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>699</td>\n",
              "      <td>77866</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>338</th>\n",
              "      <td>709704</td>\n",
              "      <td>2006021442</td>\n",
              "      <td>2010-01-17 18:56:43.923</td>\n",
              "      <td>2010-01-04 09:58:46.522</td>\n",
              "      <td>2010-02-01 13:59:02.528</td>\n",
              "      <td>2008009890.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>199419</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>699</td>\n",
              "      <td>77866</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>339</th>\n",
              "      <td>709704</td>\n",
              "      <td>2006021442</td>\n",
              "      <td>2010-01-17 18:56:43.923</td>\n",
              "      <td>2010-01-04 09:58:46.522</td>\n",
              "      <td>2010-02-01 13:59:02.528</td>\n",
              "      <td>2008009890.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>199419</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>699</td>\n",
              "      <td>77866</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>340</th>\n",
              "      <td>709704</td>\n",
              "      <td>2006021442</td>\n",
              "      <td>2010-01-17 18:56:43.923</td>\n",
              "      <td>2010-01-04 09:58:46.522</td>\n",
              "      <td>2010-02-01 13:59:02.528</td>\n",
              "      <td>2008009890.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>199419</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>699</td>\n",
              "      <td>77866</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>341</th>\n",
              "      <td>709704</td>\n",
              "      <td>2006021442</td>\n",
              "      <td>2010-01-17 18:56:43.923</td>\n",
              "      <td>2010-01-04 09:58:46.522</td>\n",
              "      <td>2010-02-01 13:59:02.528</td>\n",
              "      <td>2008009890.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>199419</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>699</td>\n",
              "      <td>77866</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-20418625-0ae0-4865-b49e-0cf116a04985')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-20418625-0ae0-4865-b49e-0cf116a04985 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-20418625-0ae0-4865-b49e-0cf116a04985');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 106
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "dados.query('id_emprestimo == 2422542')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 510
        },
        "id": "yCMljHWT-5_L",
        "outputId": "5e19f005-62ac-40a4-d90d-8f5892db3f27"
      },
      "execution_count": 107,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "         id_emprestimo codigo_barras data_renovacao         data_emprestimo  \\\n",
              "1942875        2422542    2016015319            NaT 2016-04-20 21:07:44.036   \n",
              "1942876        2422542    2016015319            NaT 2016-04-20 21:07:44.036   \n",
              "1942877        2422542    2016015319            NaT 2016-04-20 21:07:44.036   \n",
              "1942878        2422542    2016015319            NaT 2017-04-20 21:07:44.036   \n",
              "1942879        2422542    2016015319            NaT 2017-04-20 21:07:44.036   \n",
              "1942880        2422542    2016015319            NaT 2017-04-20 21:07:44.036   \n",
              "\n",
              "             data_devolucao matricula_ou_siape tipo_vinculo_usuario  \\\n",
              "1942875 2016-05-02 08:22:54       2015041228.0   ALUNO DE GRADUAÇÃO   \n",
              "1942876 2016-05-02 08:22:54       2015041228.0   ALUNO DE GRADUAÇÃO   \n",
              "1942877 2016-05-02 08:22:54       2015041228.0   ALUNO DE GRADUAÇÃO   \n",
              "1942878 2017-05-02 08:22:54       2015041228.0   ALUNO DE GRADUAÇÃO   \n",
              "1942879 2017-05-02 08:22:54       2015041228.0   ALUNO DE GRADUAÇÃO   \n",
              "1942880 2017-05-02 08:22:54       2015041228.0   ALUNO DE GRADUAÇÃO   \n",
              "\n",
              "         id_exemplar            colecao                      biblioteca  \\\n",
              "1942875      1237700  Acervo Circulante  Biblioteca Central Zila Mamede   \n",
              "1942876      1239476  Acervo Circulante  Biblioteca Central Zila Mamede   \n",
              "1942877      1239477  Acervo Circulante  Biblioteca Central Zila Mamede   \n",
              "1942878      1237700  Acervo Circulante  Biblioteca Central Zila Mamede   \n",
              "1942879      1239476  Acervo Circulante  Biblioteca Central Zila Mamede   \n",
              "1942880      1239477  Acervo Circulante  Biblioteca Central Zila Mamede   \n",
              "\n",
              "        status_material  localizacao  registro_sistema  \n",
              "1942875        ESPECIAL           32            220086  \n",
              "1942876        ESPECIAL            9            220086  \n",
              "1942877        ESPECIAL          535            234806  \n",
              "1942878        ESPECIAL           32            220086  \n",
              "1942879        ESPECIAL            9            220086  \n",
              "1942880        ESPECIAL          535            234806  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-814a80e9-4f25-4ae8-af7e-80df939858c0\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>id_emprestimo</th>\n",
              "      <th>codigo_barras</th>\n",
              "      <th>data_renovacao</th>\n",
              "      <th>data_emprestimo</th>\n",
              "      <th>data_devolucao</th>\n",
              "      <th>matricula_ou_siape</th>\n",
              "      <th>tipo_vinculo_usuario</th>\n",
              "      <th>id_exemplar</th>\n",
              "      <th>colecao</th>\n",
              "      <th>biblioteca</th>\n",
              "      <th>status_material</th>\n",
              "      <th>localizacao</th>\n",
              "      <th>registro_sistema</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1942875</th>\n",
              "      <td>2422542</td>\n",
              "      <td>2016015319</td>\n",
              "      <td>NaT</td>\n",
              "      <td>2016-04-20 21:07:44.036</td>\n",
              "      <td>2016-05-02 08:22:54</td>\n",
              "      <td>2015041228.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>1237700</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>ESPECIAL</td>\n",
              "      <td>32</td>\n",
              "      <td>220086</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1942876</th>\n",
              "      <td>2422542</td>\n",
              "      <td>2016015319</td>\n",
              "      <td>NaT</td>\n",
              "      <td>2016-04-20 21:07:44.036</td>\n",
              "      <td>2016-05-02 08:22:54</td>\n",
              "      <td>2015041228.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>1239476</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>ESPECIAL</td>\n",
              "      <td>9</td>\n",
              "      <td>220086</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1942877</th>\n",
              "      <td>2422542</td>\n",
              "      <td>2016015319</td>\n",
              "      <td>NaT</td>\n",
              "      <td>2016-04-20 21:07:44.036</td>\n",
              "      <td>2016-05-02 08:22:54</td>\n",
              "      <td>2015041228.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>1239477</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>ESPECIAL</td>\n",
              "      <td>535</td>\n",
              "      <td>234806</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1942878</th>\n",
              "      <td>2422542</td>\n",
              "      <td>2016015319</td>\n",
              "      <td>NaT</td>\n",
              "      <td>2017-04-20 21:07:44.036</td>\n",
              "      <td>2017-05-02 08:22:54</td>\n",
              "      <td>2015041228.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>1237700</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>ESPECIAL</td>\n",
              "      <td>32</td>\n",
              "      <td>220086</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1942879</th>\n",
              "      <td>2422542</td>\n",
              "      <td>2016015319</td>\n",
              "      <td>NaT</td>\n",
              "      <td>2017-04-20 21:07:44.036</td>\n",
              "      <td>2017-05-02 08:22:54</td>\n",
              "      <td>2015041228.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>1239476</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>ESPECIAL</td>\n",
              "      <td>9</td>\n",
              "      <td>220086</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1942880</th>\n",
              "      <td>2422542</td>\n",
              "      <td>2016015319</td>\n",
              "      <td>NaT</td>\n",
              "      <td>2017-04-20 21:07:44.036</td>\n",
              "      <td>2017-05-02 08:22:54</td>\n",
              "      <td>2015041228.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>1239477</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>ESPECIAL</td>\n",
              "      <td>535</td>\n",
              "      <td>234806</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-814a80e9-4f25-4ae8-af7e-80df939858c0')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-814a80e9-4f25-4ae8-af7e-80df939858c0 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-814a80e9-4f25-4ae8-af7e-80df939858c0');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 107
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "dados.query('id_emprestimo == 2352752')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 378
        },
        "id": "AqGdRL2__Ji5",
        "outputId": "45c078c6-4522-437e-d369-0533f034e750"
      },
      "execution_count": 108,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "         id_emprestimo codigo_barras          data_renovacao  \\\n",
              "1868642        2352752    2016019472 2016-02-07 13:09:55.390   \n",
              "1868643        2352752    2016019472 2016-02-07 13:09:55.390   \n",
              "1868666        2352752    2016019472 2017-02-07 13:09:55.390   \n",
              "1868667        2352752    2016019472 2017-02-07 13:09:55.390   \n",
              "\n",
              "                data_emprestimo      data_devolucao matricula_ou_siape  \\\n",
              "1868642 2016-01-10 14:34:20.217 2016-02-08 18:09:22       2014109820.0   \n",
              "1868643 2016-01-10 14:34:20.217 2016-02-08 18:09:22       2014109820.0   \n",
              "1868666 2017-01-10 14:34:20.217 2017-02-08 18:09:22       2014109820.0   \n",
              "1868667 2017-01-10 14:34:20.217 2017-02-08 18:09:22       2014109820.0   \n",
              "\n",
              "           tipo_vinculo_usuario  id_exemplar            colecao  \\\n",
              "1868642  ALUNO DE PÓS-GRADUAÇÃO      1234310  Acervo Circulante   \n",
              "1868643  ALUNO DE PÓS-GRADUAÇÃO      1234422  Acervo Circulante   \n",
              "1868666  ALUNO DE PÓS-GRADUAÇÃO      1234310  Acervo Circulante   \n",
              "1868667  ALUNO DE PÓS-GRADUAÇÃO      1234422  Acervo Circulante   \n",
              "\n",
              "                             biblioteca status_material  localizacao  \\\n",
              "1868642  Biblioteca Central Zila Mamede         REGULAR          534   \n",
              "1868643  Biblioteca Central Zila Mamede         REGULAR          553   \n",
              "1868666  Biblioteca Central Zila Mamede         REGULAR          534   \n",
              "1868667  Biblioteca Central Zila Mamede         REGULAR          553   \n",
              "\n",
              "         registro_sistema  \n",
              "1868642            233498  \n",
              "1868643            233539  \n",
              "1868666            233498  \n",
              "1868667            233539  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-4e05c2e2-dab3-4740-984c-d518b36df107\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>id_emprestimo</th>\n",
              "      <th>codigo_barras</th>\n",
              "      <th>data_renovacao</th>\n",
              "      <th>data_emprestimo</th>\n",
              "      <th>data_devolucao</th>\n",
              "      <th>matricula_ou_siape</th>\n",
              "      <th>tipo_vinculo_usuario</th>\n",
              "      <th>id_exemplar</th>\n",
              "      <th>colecao</th>\n",
              "      <th>biblioteca</th>\n",
              "      <th>status_material</th>\n",
              "      <th>localizacao</th>\n",
              "      <th>registro_sistema</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1868642</th>\n",
              "      <td>2352752</td>\n",
              "      <td>2016019472</td>\n",
              "      <td>2016-02-07 13:09:55.390</td>\n",
              "      <td>2016-01-10 14:34:20.217</td>\n",
              "      <td>2016-02-08 18:09:22</td>\n",
              "      <td>2014109820.0</td>\n",
              "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
              "      <td>1234310</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>534</td>\n",
              "      <td>233498</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1868643</th>\n",
              "      <td>2352752</td>\n",
              "      <td>2016019472</td>\n",
              "      <td>2016-02-07 13:09:55.390</td>\n",
              "      <td>2016-01-10 14:34:20.217</td>\n",
              "      <td>2016-02-08 18:09:22</td>\n",
              "      <td>2014109820.0</td>\n",
              "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
              "      <td>1234422</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>553</td>\n",
              "      <td>233539</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1868666</th>\n",
              "      <td>2352752</td>\n",
              "      <td>2016019472</td>\n",
              "      <td>2017-02-07 13:09:55.390</td>\n",
              "      <td>2017-01-10 14:34:20.217</td>\n",
              "      <td>2017-02-08 18:09:22</td>\n",
              "      <td>2014109820.0</td>\n",
              "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
              "      <td>1234310</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>534</td>\n",
              "      <td>233498</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1868667</th>\n",
              "      <td>2352752</td>\n",
              "      <td>2016019472</td>\n",
              "      <td>2017-02-07 13:09:55.390</td>\n",
              "      <td>2017-01-10 14:34:20.217</td>\n",
              "      <td>2017-02-08 18:09:22</td>\n",
              "      <td>2014109820.0</td>\n",
              "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
              "      <td>1234422</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>553</td>\n",
              "      <td>233539</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-4e05c2e2-dab3-4740-984c-d518b36df107')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-4e05c2e2-dab3-4740-984c-d518b36df107 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-4e05c2e2-dab3-4740-984c-d518b36df107');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 108
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "dados.query('id_emprestimo == 2375005')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 447
        },
        "id": "84MErdYY_TV5",
        "outputId": "b451a278-cfea-47a8-88c7-9bfa9dd9f4af"
      },
      "execution_count": 109,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "         id_emprestimo codigo_barras data_renovacao         data_emprestimo  \\\n",
              "1800746        2375005    2015008424            NaT 2016-02-23 08:47:09.769   \n",
              "1800747        2375005    2015008424            NaT 2016-02-23 08:47:09.769   \n",
              "1800756        2375005    2015008424            NaT 2017-02-23 08:47:09.769   \n",
              "1800757        2375005    2015008424            NaT 2017-02-23 08:47:09.769   \n",
              "\n",
              "             data_devolucao matricula_ou_siape tipo_vinculo_usuario  \\\n",
              "1800746 2016-03-03 08:18:40       2012962072.0   ALUNO DE GRADUAÇÃO   \n",
              "1800747 2016-03-03 08:18:40       2012962072.0   ALUNO DE GRADUAÇÃO   \n",
              "1800756 2017-03-03 08:18:40       2012962072.0   ALUNO DE GRADUAÇÃO   \n",
              "1800757 2017-03-03 08:18:40       2012962072.0   ALUNO DE GRADUAÇÃO   \n",
              "\n",
              "         id_exemplar            colecao  \\\n",
              "1800746      1180951  Acervo Circulante   \n",
              "1800747      1181550  Acervo Circulante   \n",
              "1800756      1180951  Acervo Circulante   \n",
              "1800757      1181550  Acervo Circulante   \n",
              "\n",
              "                                                biblioteca status_material  \\\n",
              "1800746  Biblioteca Setorial do Departamento de Artes -...         REGULAR   \n",
              "1800747  Biblioteca Setorial do Departamento de Artes -...         REGULAR   \n",
              "1800756  Biblioteca Setorial do Departamento de Artes -...         REGULAR   \n",
              "1800757  Biblioteca Setorial do Departamento de Artes -...         REGULAR   \n",
              "\n",
              "         localizacao  registro_sistema  \n",
              "1800746          103            219701  \n",
              "1800747           17            219865  \n",
              "1800756          103            219701  \n",
              "1800757           17            219865  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-fa218fa2-feca-479b-b53f-5884c8044663\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>id_emprestimo</th>\n",
              "      <th>codigo_barras</th>\n",
              "      <th>data_renovacao</th>\n",
              "      <th>data_emprestimo</th>\n",
              "      <th>data_devolucao</th>\n",
              "      <th>matricula_ou_siape</th>\n",
              "      <th>tipo_vinculo_usuario</th>\n",
              "      <th>id_exemplar</th>\n",
              "      <th>colecao</th>\n",
              "      <th>biblioteca</th>\n",
              "      <th>status_material</th>\n",
              "      <th>localizacao</th>\n",
              "      <th>registro_sistema</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1800746</th>\n",
              "      <td>2375005</td>\n",
              "      <td>2015008424</td>\n",
              "      <td>NaT</td>\n",
              "      <td>2016-02-23 08:47:09.769</td>\n",
              "      <td>2016-03-03 08:18:40</td>\n",
              "      <td>2012962072.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>1180951</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Setorial do Departamento de Artes -...</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>103</td>\n",
              "      <td>219701</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1800747</th>\n",
              "      <td>2375005</td>\n",
              "      <td>2015008424</td>\n",
              "      <td>NaT</td>\n",
              "      <td>2016-02-23 08:47:09.769</td>\n",
              "      <td>2016-03-03 08:18:40</td>\n",
              "      <td>2012962072.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>1181550</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Setorial do Departamento de Artes -...</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>17</td>\n",
              "      <td>219865</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1800756</th>\n",
              "      <td>2375005</td>\n",
              "      <td>2015008424</td>\n",
              "      <td>NaT</td>\n",
              "      <td>2017-02-23 08:47:09.769</td>\n",
              "      <td>2017-03-03 08:18:40</td>\n",
              "      <td>2012962072.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>1180951</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Setorial do Departamento de Artes -...</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>103</td>\n",
              "      <td>219701</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1800757</th>\n",
              "      <td>2375005</td>\n",
              "      <td>2015008424</td>\n",
              "      <td>NaT</td>\n",
              "      <td>2017-02-23 08:47:09.769</td>\n",
              "      <td>2017-03-03 08:18:40</td>\n",
              "      <td>2012962072.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>1181550</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Setorial do Departamento de Artes -...</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>17</td>\n",
              "      <td>219865</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-fa218fa2-feca-479b-b53f-5884c8044663')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-fa218fa2-feca-479b-b53f-5884c8044663 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-fa218fa2-feca-479b-b53f-5884c8044663');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 109
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "dados = dados.drop_duplicates()\n",
        "dados"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 870
        },
        "id": "34w7tmLtBEeq",
        "outputId": "3dcfa310-54d1-423e-aba3-2f537207b6c5"
      },
      "execution_count": 110,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "         id_emprestimo codigo_barras          data_renovacao  \\\n",
              "0               709684       L095049                     NaT   \n",
              "2               726965       L095049 2010-03-31 12:41:08.684   \n",
              "3               709685       L167050                     NaT   \n",
              "5               717763       L167050                     NaT   \n",
              "6               729996       L167050 2010-03-17 09:08:26.874   \n",
              "...                ...           ...                     ...   \n",
              "2072553        2989018    2009036492                     NaT   \n",
              "2072554        2989020    2014062640                     NaT   \n",
              "2072555        2989032    2018003324                     NaT   \n",
              "2072556        2989049    2006024313                     NaT   \n",
              "2072557        2989061    2018031352                     NaT   \n",
              "\n",
              "                data_emprestimo          data_devolucao matricula_ou_siape  \\\n",
              "0       2010-01-04 07:44:10.721 2010-01-05 16:26:12.662       2008023265.0   \n",
              "2       2010-03-01 12:40:56.212 2010-04-30 14:42:35.366       2009121584.0   \n",
              "3       2010-01-04 07:44:10.750 2010-01-12 07:34:13.934       2008023265.0   \n",
              "5       2010-02-11 11:16:30.335 2010-03-04 08:54:32.262       2008050352.0   \n",
              "6       2010-03-04 13:36:26.599 2010-03-31 18:04:29.669        200722565.0   \n",
              "...                         ...                     ...                ...   \n",
              "2072553 2020-03-17 19:49:10.187 2020-12-03 08:12:20.000      20150109837.0   \n",
              "2072554 2020-03-17 19:51:15.700 2021-01-07 11:16:28.000      20190035012.0   \n",
              "2072555 2020-03-17 20:00:11.416 2021-08-30 13:29:44.000      20191021693.0   \n",
              "2072556 2020-03-17 20:47:18.741                     NaT      20150129867.0   \n",
              "2072557 2020-03-17 21:22:22.138 2021-07-26 15:05:20.000      20200005327.0   \n",
              "\n",
              "           tipo_vinculo_usuario  id_exemplar            colecao  \\\n",
              "0            ALUNO DE GRADUAÇÃO        13259  Acervo Circulante   \n",
              "2        ALUNO DE PÓS-GRADUAÇÃO        13259  Acervo Circulante   \n",
              "3            ALUNO DE GRADUAÇÃO        70865  Acervo Circulante   \n",
              "5            ALUNO DE GRADUAÇÃO        70865  Acervo Circulante   \n",
              "6            ALUNO DE GRADUAÇÃO        70865  Acervo Circulante   \n",
              "...                         ...          ...                ...   \n",
              "2072553      ALUNO DE GRADUAÇÃO       274820  Acervo Circulante   \n",
              "2072554      ALUNO DE GRADUAÇÃO      1157915  Acervo Circulante   \n",
              "2072555  ALUNO DE PÓS-GRADUAÇÃO      1317173  Acervo Circulante   \n",
              "2072556      ALUNO DE GRADUAÇÃO       206073  Acervo Circulante   \n",
              "2072557      ALUNO DE GRADUAÇÃO      1342535  Acervo Circulante   \n",
              "\n",
              "                                                biblioteca status_material  \\\n",
              "0                           Biblioteca Central Zila Mamede         REGULAR   \n",
              "2                           Biblioteca Central Zila Mamede         REGULAR   \n",
              "3                           Biblioteca Central Zila Mamede         REGULAR   \n",
              "5                           Biblioteca Central Zila Mamede         REGULAR   \n",
              "6                           Biblioteca Central Zila Mamede         REGULAR   \n",
              "...                                                    ...             ...   \n",
              "2072553                     Biblioteca Central Zila Mamede         REGULAR   \n",
              "2072554                     Biblioteca Central Zila Mamede         REGULAR   \n",
              "2072555  Biblioteca Setorial da Faculdade de Ciências d...         REGULAR   \n",
              "2072556                     Biblioteca Central Zila Mamede         REGULAR   \n",
              "2072557                     Biblioteca Central Zila Mamede         REGULAR   \n",
              "\n",
              "         localizacao  registro_sistema  \n",
              "0                630              4225  \n",
              "2                630              4225  \n",
              "3                647             25009  \n",
              "5                647             25009  \n",
              "6                647             25009  \n",
              "...              ...               ...  \n",
              "2072553          676            120845  \n",
              "2072554          228            213248  \n",
              "2072555          784            255835  \n",
              "2072556          663             82178  \n",
              "2072557          355            174443  \n",
              "\n",
              "[2072522 rows x 13 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-c1f7966f-a141-456b-b7d9-f468821f80ad\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>id_emprestimo</th>\n",
              "      <th>codigo_barras</th>\n",
              "      <th>data_renovacao</th>\n",
              "      <th>data_emprestimo</th>\n",
              "      <th>data_devolucao</th>\n",
              "      <th>matricula_ou_siape</th>\n",
              "      <th>tipo_vinculo_usuario</th>\n",
              "      <th>id_exemplar</th>\n",
              "      <th>colecao</th>\n",
              "      <th>biblioteca</th>\n",
              "      <th>status_material</th>\n",
              "      <th>localizacao</th>\n",
              "      <th>registro_sistema</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>709684</td>\n",
              "      <td>L095049</td>\n",
              "      <td>NaT</td>\n",
              "      <td>2010-01-04 07:44:10.721</td>\n",
              "      <td>2010-01-05 16:26:12.662</td>\n",
              "      <td>2008023265.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>13259</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>630</td>\n",
              "      <td>4225</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>726965</td>\n",
              "      <td>L095049</td>\n",
              "      <td>2010-03-31 12:41:08.684</td>\n",
              "      <td>2010-03-01 12:40:56.212</td>\n",
              "      <td>2010-04-30 14:42:35.366</td>\n",
              "      <td>2009121584.0</td>\n",
              "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
              "      <td>13259</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>630</td>\n",
              "      <td>4225</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>709685</td>\n",
              "      <td>L167050</td>\n",
              "      <td>NaT</td>\n",
              "      <td>2010-01-04 07:44:10.750</td>\n",
              "      <td>2010-01-12 07:34:13.934</td>\n",
              "      <td>2008023265.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>70865</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>647</td>\n",
              "      <td>25009</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>717763</td>\n",
              "      <td>L167050</td>\n",
              "      <td>NaT</td>\n",
              "      <td>2010-02-11 11:16:30.335</td>\n",
              "      <td>2010-03-04 08:54:32.262</td>\n",
              "      <td>2008050352.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>70865</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>647</td>\n",
              "      <td>25009</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>729996</td>\n",
              "      <td>L167050</td>\n",
              "      <td>2010-03-17 09:08:26.874</td>\n",
              "      <td>2010-03-04 13:36:26.599</td>\n",
              "      <td>2010-03-31 18:04:29.669</td>\n",
              "      <td>200722565.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>70865</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>647</td>\n",
              "      <td>25009</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",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2072553</th>\n",
              "      <td>2989018</td>\n",
              "      <td>2009036492</td>\n",
              "      <td>NaT</td>\n",
              "      <td>2020-03-17 19:49:10.187</td>\n",
              "      <td>2020-12-03 08:12:20.000</td>\n",
              "      <td>20150109837.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>274820</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>676</td>\n",
              "      <td>120845</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2072554</th>\n",
              "      <td>2989020</td>\n",
              "      <td>2014062640</td>\n",
              "      <td>NaT</td>\n",
              "      <td>2020-03-17 19:51:15.700</td>\n",
              "      <td>2021-01-07 11:16:28.000</td>\n",
              "      <td>20190035012.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>1157915</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>228</td>\n",
              "      <td>213248</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2072555</th>\n",
              "      <td>2989032</td>\n",
              "      <td>2018003324</td>\n",
              "      <td>NaT</td>\n",
              "      <td>2020-03-17 20:00:11.416</td>\n",
              "      <td>2021-08-30 13:29:44.000</td>\n",
              "      <td>20191021693.0</td>\n",
              "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
              "      <td>1317173</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Setorial da Faculdade de Ciências d...</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>784</td>\n",
              "      <td>255835</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2072556</th>\n",
              "      <td>2989049</td>\n",
              "      <td>2006024313</td>\n",
              "      <td>NaT</td>\n",
              "      <td>2020-03-17 20:47:18.741</td>\n",
              "      <td>NaT</td>\n",
              "      <td>20150129867.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>206073</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>663</td>\n",
              "      <td>82178</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2072557</th>\n",
              "      <td>2989061</td>\n",
              "      <td>2018031352</td>\n",
              "      <td>NaT</td>\n",
              "      <td>2020-03-17 21:22:22.138</td>\n",
              "      <td>2021-07-26 15:05:20.000</td>\n",
              "      <td>20200005327.0</td>\n",
              "      <td>ALUNO DE GRADUAÇÃO</td>\n",
              "      <td>1342535</td>\n",
              "      <td>Acervo Circulante</td>\n",
              "      <td>Biblioteca Central Zila Mamede</td>\n",
              "      <td>REGULAR</td>\n",
              "      <td>355</td>\n",
              "      <td>174443</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>2072522 rows × 13 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-c1f7966f-a141-456b-b7d9-f468821f80ad')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-c1f7966f-a141-456b-b7d9-f468821f80ad button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-c1f7966f-a141-456b-b7d9-f468821f80ad');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 110
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "W_BCBwnzFreq"
      },
      "execution_count": null,
      "outputs": []
    }
  ]
}