Dia_1.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "555a083f",
   "metadata": {},
   "source": [
    "## Comando para importar a Biblioteca Pandas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "1e983ef2",
   "metadata": {},
   "outputs": [],
   "source": [
    "#importando a biblioteca do pandas \n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "47398403",
   "metadata": {},
   "source": [
    "## Carregando os dados do GITHUB.\n",
    "## Carregando um arquivo individualmente"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "id": "b9181265",
   "metadata": {},
   "outputs": [],
   "source": [
    "#comando de carregamento de dados no pandas. Colocar aqui o link do visualizador de RAW\n",
    "emprestimos = 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')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c3395e4a",
   "metadata": {},
   "source": [
    "## Comando pd.head para visualizar o dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "7634d857",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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>0</th>\n",
       "      <td>709684</td>\n",
       "      <td>L095049</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010/01/04 07:44:10.721000000</td>\n",
       "      <td>2010/01/05 16:26:12.662000000</td>\n",
       "      <td>2.008023e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>709685</td>\n",
       "      <td>L167050</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010/01/04 07:44:10.750000000</td>\n",
       "      <td>2010/01/12 07:34:13.934000000</td>\n",
       "      <td>2.008023e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>709686</td>\n",
       "      <td>2006017618</td>\n",
       "      <td>2010/01/26 08:07:01.738000000</td>\n",
       "      <td>2010/01/04 08:08:44.081000000</td>\n",
       "      <td>2010/02/25 07:36:25.800000000</td>\n",
       "      <td>2.008112e+09</td>\n",
       "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>709687</td>\n",
       "      <td>L184117</td>\n",
       "      <td>2010/01/18 11:07:46.470000000</td>\n",
       "      <td>2010/01/04 08:24:21.284000000</td>\n",
       "      <td>2010/02/03 08:58:45.692000000</td>\n",
       "      <td>2.007211e+08</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>709684</td>\n",
       "      <td>L095049</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010/01/04 07:44:10.721000000</td>\n",
       "      <td>2010/01/05 16:26:12.662000000</td>\n",
       "      <td>2.008023e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id_emprestimo codigo_barras                 data_renovacao  \\\n",
       "0         709684       L095049                            NaN   \n",
       "1         709685       L167050                            NaN   \n",
       "2         709686    2006017618  2010/01/26 08:07:01.738000000   \n",
       "3         709687       L184117  2010/01/18 11:07:46.470000000   \n",
       "4         709684       L095049                            NaN   \n",
       "\n",
       "                 data_emprestimo                 data_devolucao  \\\n",
       "0  2010/01/04 07:44:10.721000000  2010/01/05 16:26:12.662000000   \n",
       "1  2010/01/04 07:44:10.750000000  2010/01/12 07:34:13.934000000   \n",
       "2  2010/01/04 08:08:44.081000000  2010/02/25 07:36:25.800000000   \n",
       "3  2010/01/04 08:24:21.284000000  2010/02/03 08:58:45.692000000   \n",
       "4  2010/01/04 07:44:10.721000000  2010/01/05 16:26:12.662000000   \n",
       "\n",
       "   matricula_ou_siape    tipo_vinculo_usuario  \n",
       "0        2.008023e+09      ALUNO DE GRADUAÇÃO  \n",
       "1        2.008023e+09      ALUNO DE GRADUAÇÃO  \n",
       "2        2.008112e+09  ALUNO DE PÓS-GRADUAÇÃO  \n",
       "3        2.007211e+08      ALUNO DE GRADUAÇÃO  \n",
       "4        2.008023e+09      ALUNO DE GRADUAÇÃO  "
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "emprestimos.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6864389d",
   "metadata": {},
   "source": [
    "## Carregando todos os dados de empréstimo"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "c3a567b6",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Carregando cada CSV individualmente\n",
    "\n",
    "emprestimos_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",
    "emprestimos_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",
    "emprestimos_3 = 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",
    "emprestimos_4 = 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",
    "emprestimos_5 = 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",
    "emprestimos_6 = 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",
    "emprestimos_7 = 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",
    "emprestimos_8 = 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",
    "emprestimos_9 = 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",
    "emprestimos_10 = 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",
    "emprestimos_11 = 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",
    "emprestimos_12 = 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",
    "emprestimos_13 = 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",
    "emprestimos_14 = 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",
    "emprestimos_15 = 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",
    "emprestimos_16 = 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",
    "emprestimos_17 = 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",
    "emprestimos_18 = 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",
    "emprestimos_19 = 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",
    "emprestimos_20 = 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",
    "emprestimos_21 = 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"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "5bc0183d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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>0</th>\n",
       "      <td>709684</td>\n",
       "      <td>L095049</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010/01/04 07:44:10.721000000</td>\n",
       "      <td>2010/01/05 16:26:12.662000000</td>\n",
       "      <td>2.008023e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>709685</td>\n",
       "      <td>L167050</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010/01/04 07:44:10.750000000</td>\n",
       "      <td>2010/01/12 07:34:13.934000000</td>\n",
       "      <td>2.008023e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>709686</td>\n",
       "      <td>2006017618</td>\n",
       "      <td>2010/01/26 08:07:01.738000000</td>\n",
       "      <td>2010/01/04 08:08:44.081000000</td>\n",
       "      <td>2010/02/25 07:36:25.800000000</td>\n",
       "      <td>2.008112e+09</td>\n",
       "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>709687</td>\n",
       "      <td>L184117</td>\n",
       "      <td>2010/01/18 11:07:46.470000000</td>\n",
       "      <td>2010/01/04 08:24:21.284000000</td>\n",
       "      <td>2010/02/03 08:58:45.692000000</td>\n",
       "      <td>2.007211e+08</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>709684</td>\n",
       "      <td>L095049</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010/01/04 07:44:10.721000000</td>\n",
       "      <td>2010/01/05 16:26:12.662000000</td>\n",
       "      <td>2.008023e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id_emprestimo codigo_barras                 data_renovacao  \\\n",
       "0         709684       L095049                            NaN   \n",
       "1         709685       L167050                            NaN   \n",
       "2         709686    2006017618  2010/01/26 08:07:01.738000000   \n",
       "3         709687       L184117  2010/01/18 11:07:46.470000000   \n",
       "4         709684       L095049                            NaN   \n",
       "\n",
       "                 data_emprestimo                 data_devolucao  \\\n",
       "0  2010/01/04 07:44:10.721000000  2010/01/05 16:26:12.662000000   \n",
       "1  2010/01/04 07:44:10.750000000  2010/01/12 07:34:13.934000000   \n",
       "2  2010/01/04 08:08:44.081000000  2010/02/25 07:36:25.800000000   \n",
       "3  2010/01/04 08:24:21.284000000  2010/02/03 08:58:45.692000000   \n",
       "4  2010/01/04 07:44:10.721000000  2010/01/05 16:26:12.662000000   \n",
       "\n",
       "   matricula_ou_siape    tipo_vinculo_usuario  \n",
       "0        2.008023e+09      ALUNO DE GRADUAÇÃO  \n",
       "1        2.008023e+09      ALUNO DE GRADUAÇÃO  \n",
       "2        2.008112e+09  ALUNO DE PÓS-GRADUAÇÃO  \n",
       "3        2.007211e+08      ALUNO DE GRADUAÇÃO  \n",
       "4        2.008023e+09      ALUNO DE GRADUAÇÃO  "
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "emprestimos_1.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "26712835",
   "metadata": {},
   "source": [
    "## Unificando as tabelas carregadas utilizando a função concat"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f54a316e",
   "metadata": {},
   "source": [
    "A função pd.concat serve para unir as tabelas uma em cima da outra. O pandas detecta o nome dos campos e adiciona os dados conforme os nomes. \n",
    "\n",
    "A função serve para esse caso pois todas as tabelas possuem campos com nomes semelhantes.\n",
    "\n",
    "Detalhe que por padrão ele puxa os índices. As vezes esses índices podem significar nada na tabela. \n",
    "\n",
    "Por isso ao final usamos o comando ignore_index = True para ignorar o índice padrão\n",
    "\n",
    "Colocamos colchetes [] dentro de () porque trata-se de uma lista. \n",
    "\n",
    "Assim no exemplo a emprestimos_1 recebe os dados da emprestimos_2 embaixo e assim por diante...\n",
    "\n",
    "Além das lista e do parâmetro ignore_index entre parenteses outros parâmetros podem ser usados.\n",
    "\n",
    "Exemplos:\n",
    "\n",
    "1- Apresenta duas tabelas com os seguintes dados separados:\n",
    "\n",
    "In[66] pd.concat([emprestimo_1, emprestimos_2], keys = ['ALUNO DE GRADUAÇÃO1', 'ALUNO DE PÓS-GRADUAÇÃO']) \n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "28b31d46",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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>0</th>\n",
       "      <td>709684</td>\n",
       "      <td>L095049</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010/01/04 07:44:10.721000000</td>\n",
       "      <td>2010/01/05 16:26:12.662000000</td>\n",
       "      <td>2.008023e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>709685</td>\n",
       "      <td>L167050</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010/01/04 07:44:10.750000000</td>\n",
       "      <td>2010/01/12 07:34:13.934000000</td>\n",
       "      <td>2.008023e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>709686</td>\n",
       "      <td>2006017618</td>\n",
       "      <td>2010/01/26 08:07:01.738000000</td>\n",
       "      <td>2010/01/04 08:08:44.081000000</td>\n",
       "      <td>2010/02/25 07:36:25.800000000</td>\n",
       "      <td>2.008112e+09</td>\n",
       "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>709687</td>\n",
       "      <td>L184117</td>\n",
       "      <td>2010/01/18 11:07:46.470000000</td>\n",
       "      <td>2010/01/04 08:24:21.284000000</td>\n",
       "      <td>2010/02/03 08:58:45.692000000</td>\n",
       "      <td>2.007211e+08</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>709684</td>\n",
       "      <td>L095049</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010/01/04 07:44:10.721000000</td>\n",
       "      <td>2010/01/05 16:26:12.662000000</td>\n",
       "      <td>2.008023e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2258013</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2258014</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2258015</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2258016</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2258017</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",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2258018 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         id_emprestimo codigo_barras                 data_renovacao  \\\n",
       "0               709684       L095049                            NaN   \n",
       "1               709685       L167050                            NaN   \n",
       "2               709686    2006017618  2010/01/26 08:07:01.738000000   \n",
       "3               709687       L184117  2010/01/18 11:07:46.470000000   \n",
       "4               709684       L095049                            NaN   \n",
       "...                ...           ...                            ...   \n",
       "2258013        2989086    2008047044                            NaN   \n",
       "2258014        2989087    2008047047                            NaN   \n",
       "2258015        2989088    2010052905                            NaN   \n",
       "2258016        2989089    2010048023                            NaN   \n",
       "2258017        2989090    2013106838                            NaN   \n",
       "\n",
       "                       data_emprestimo                 data_devolucao  \\\n",
       "0        2010/01/04 07:44:10.721000000  2010/01/05 16:26:12.662000000   \n",
       "1        2010/01/04 07:44:10.750000000  2010/01/12 07:34:13.934000000   \n",
       "2        2010/01/04 08:08:44.081000000  2010/02/25 07:36:25.800000000   \n",
       "3        2010/01/04 08:24:21.284000000  2010/02/03 08:58:45.692000000   \n",
       "4        2010/01/04 07:44:10.721000000  2010/01/05 16:26:12.662000000   \n",
       "...                                ...                            ...   \n",
       "2258013  2020/05/05 19:51:06.059000000  2021/05/13 14:53:31.000000000   \n",
       "2258014  2020/05/05 19:51:06.135000000  2021/05/13 14:53:38.000000000   \n",
       "2258015  2020/05/05 19:51:06.164000000  2021/05/13 15:01:46.000000000   \n",
       "2258016  2020/06/09 11:54:02.669000000  2021/07/21 15:33:55.000000000   \n",
       "2258017  2020/06/09 11:54:02.852000000  2021/07/21 15:33:45.000000000   \n",
       "\n",
       "         matricula_ou_siape             tipo_vinculo_usuario  \n",
       "0              2.008023e+09               ALUNO DE GRADUAÇÃO  \n",
       "1              2.008023e+09               ALUNO DE GRADUAÇÃO  \n",
       "2              2.008112e+09           ALUNO DE PÓS-GRADUAÇÃO  \n",
       "3              2.007211e+08               ALUNO DE GRADUAÇÃO  \n",
       "4              2.008023e+09               ALUNO DE GRADUAÇÃO  \n",
       "...                     ...                              ...  \n",
       "2258013        3.067431e+06  SERVIDOR TÉCNICO-ADMINISTRATIVO  \n",
       "2258014        3.067431e+06  SERVIDOR TÉCNICO-ADMINISTRATIVO  \n",
       "2258015        3.067431e+06  SERVIDOR TÉCNICO-ADMINISTRATIVO  \n",
       "2258016        2.020101e+10           ALUNO DE PÓS-GRADUAÇÃO  \n",
       "2258017        2.020101e+10           ALUNO DE PÓS-GRADUAÇÃO  \n",
       "\n",
       "[2258018 rows x 7 columns]"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#unificandos os dataframes, colcheters para dizer que é uma lista, .concat é a função utilizada. \n",
    "#O parâmetro ignore_index=True garante que o índice do DataFrame combinado seja redefinido, \n",
    "#para que os índices dos DataFrames originais não se sobreponham.\n",
    "\n",
    "emprestimos_concatenados = pd.concat([emprestimos_1,\n",
    "emprestimos_2,\n",
    "emprestimos_3,\n",
    "emprestimos_4,\n",
    "emprestimos_5,\n",
    "emprestimos_6,\n",
    "emprestimos_7,\n",
    "emprestimos_8,\n",
    "emprestimos_9,\n",
    "emprestimos_10,\n",
    "emprestimos_11,\n",
    "emprestimos_12,\n",
    "emprestimos_13,\n",
    "emprestimos_14,\n",
    "emprestimos_15,\n",
    "emprestimos_16,\n",
    "emprestimos_17,\n",
    "emprestimos_18,\n",
    "emprestimos_19,\n",
    "emprestimos_20,\n",
    "emprestimos_21], ignore_index = True)\n",
    "\n",
    "emprestimos_concatenados"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "id": "cd659118",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></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 rowspan=\"5\" valign=\"top\">ALUNO DE PÓS-GRADUAÇÃO</th>\n",
       "      <th>0</th>\n",
       "      <td>709684</td>\n",
       "      <td>L095049</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010/01/04 07:44:10.721000000</td>\n",
       "      <td>2010/01/05 16:26:12.662000000</td>\n",
       "      <td>2.008023e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>709685</td>\n",
       "      <td>L167050</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010/01/04 07:44:10.750000000</td>\n",
       "      <td>2010/01/12 07:34:13.934000000</td>\n",
       "      <td>2.008023e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>709686</td>\n",
       "      <td>2006017618</td>\n",
       "      <td>2010/01/26 08:07:01.738000000</td>\n",
       "      <td>2010/01/04 08:08:44.081000000</td>\n",
       "      <td>2010/02/25 07:36:25.800000000</td>\n",
       "      <td>2.008112e+09</td>\n",
       "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>709687</td>\n",
       "      <td>L184117</td>\n",
       "      <td>2010/01/18 11:07:46.470000000</td>\n",
       "      <td>2010/01/04 08:24:21.284000000</td>\n",
       "      <td>2010/02/03 08:58:45.692000000</td>\n",
       "      <td>2.007211e+08</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>709684</td>\n",
       "      <td>L095049</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010/01/04 07:44:10.721000000</td>\n",
       "      <td>2010/01/05 16:26:12.662000000</td>\n",
       "      <td>2.008023e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">ALUNO DE GRADUAÇÃO</th>\n",
       "      <th>100691</th>\n",
       "      <td>920241</td>\n",
       "      <td>2010049629</td>\n",
       "      <td>2011/01/14 15:59:20.653000000</td>\n",
       "      <td>2010/12/30 15:40:46.929000000</td>\n",
       "      <td>2011/02/01 16:28:43.000000000</td>\n",
       "      <td>2.010065e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100692</th>\n",
       "      <td>920242</td>\n",
       "      <td>2003005918</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010/12/30 16:03:29.379000000</td>\n",
       "      <td>2011/01/03 11:43:41.000000000</td>\n",
       "      <td>2.011112e+09</td>\n",
       "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100693</th>\n",
       "      <td>920243</td>\n",
       "      <td>2008015977</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010/12/30 16:28:10.564000000</td>\n",
       "      <td>2011/01/25 15:10:52.000000000</td>\n",
       "      <td>2.010106e+09</td>\n",
       "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100694</th>\n",
       "      <td>920244</td>\n",
       "      <td>S023356</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010/12/30 16:52:19.743000000</td>\n",
       "      <td>2011/01/14 10:33:20.000000000</td>\n",
       "      <td>2.008000e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100695</th>\n",
       "      <td>920245</td>\n",
       "      <td>S024938</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010/12/30 16:52:19.891000000</td>\n",
       "      <td>2011/01/14 10:33:04.000000000</td>\n",
       "      <td>2.008000e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>196053 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                               id_emprestimo codigo_barras  \\\n",
       "ALUNO DE PÓS-GRADUAÇÃO 0              709684       L095049   \n",
       "                       1              709685       L167050   \n",
       "                       2              709686    2006017618   \n",
       "                       3              709687       L184117   \n",
       "                       4              709684       L095049   \n",
       "...                                      ...           ...   \n",
       "ALUNO DE GRADUAÇÃO     100691         920241    2010049629   \n",
       "                       100692         920242    2003005918   \n",
       "                       100693         920243    2008015977   \n",
       "                       100694         920244       S023356   \n",
       "                       100695         920245       S024938   \n",
       "\n",
       "                                              data_renovacao  \\\n",
       "ALUNO DE PÓS-GRADUAÇÃO 0                                 NaN   \n",
       "                       1                                 NaN   \n",
       "                       2       2010/01/26 08:07:01.738000000   \n",
       "                       3       2010/01/18 11:07:46.470000000   \n",
       "                       4                                 NaN   \n",
       "...                                                      ...   \n",
       "ALUNO DE GRADUAÇÃO     100691  2011/01/14 15:59:20.653000000   \n",
       "                       100692                            NaN   \n",
       "                       100693                            NaN   \n",
       "                       100694                            NaN   \n",
       "                       100695                            NaN   \n",
       "\n",
       "                                             data_emprestimo  \\\n",
       "ALUNO DE PÓS-GRADUAÇÃO 0       2010/01/04 07:44:10.721000000   \n",
       "                       1       2010/01/04 07:44:10.750000000   \n",
       "                       2       2010/01/04 08:08:44.081000000   \n",
       "                       3       2010/01/04 08:24:21.284000000   \n",
       "                       4       2010/01/04 07:44:10.721000000   \n",
       "...                                                      ...   \n",
       "ALUNO DE GRADUAÇÃO     100691  2010/12/30 15:40:46.929000000   \n",
       "                       100692  2010/12/30 16:03:29.379000000   \n",
       "                       100693  2010/12/30 16:28:10.564000000   \n",
       "                       100694  2010/12/30 16:52:19.743000000   \n",
       "                       100695  2010/12/30 16:52:19.891000000   \n",
       "\n",
       "                                              data_devolucao  \\\n",
       "ALUNO DE PÓS-GRADUAÇÃO 0       2010/01/05 16:26:12.662000000   \n",
       "                       1       2010/01/12 07:34:13.934000000   \n",
       "                       2       2010/02/25 07:36:25.800000000   \n",
       "                       3       2010/02/03 08:58:45.692000000   \n",
       "                       4       2010/01/05 16:26:12.662000000   \n",
       "...                                                      ...   \n",
       "ALUNO DE GRADUAÇÃO     100691  2011/02/01 16:28:43.000000000   \n",
       "                       100692  2011/01/03 11:43:41.000000000   \n",
       "                       100693  2011/01/25 15:10:52.000000000   \n",
       "                       100694  2011/01/14 10:33:20.000000000   \n",
       "                       100695  2011/01/14 10:33:04.000000000   \n",
       "\n",
       "                               matricula_ou_siape    tipo_vinculo_usuario  \n",
       "ALUNO DE PÓS-GRADUAÇÃO 0             2.008023e+09      ALUNO DE GRADUAÇÃO  \n",
       "                       1             2.008023e+09      ALUNO DE GRADUAÇÃO  \n",
       "                       2             2.008112e+09  ALUNO DE PÓS-GRADUAÇÃO  \n",
       "                       3             2.007211e+08      ALUNO DE GRADUAÇÃO  \n",
       "                       4             2.008023e+09      ALUNO DE GRADUAÇÃO  \n",
       "...                                           ...                     ...  \n",
       "ALUNO DE GRADUAÇÃO     100691        2.010065e+09      ALUNO DE GRADUAÇÃO  \n",
       "                       100692        2.011112e+09  ALUNO DE PÓS-GRADUAÇÃO  \n",
       "                       100693        2.010106e+09  ALUNO DE PÓS-GRADUAÇÃO  \n",
       "                       100694        2.008000e+09      ALUNO DE GRADUAÇÃO  \n",
       "                       100695        2.008000e+09      ALUNO DE GRADUAÇÃO  \n",
       "\n",
       "[196053 rows x 7 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "#Note que ele cria um novo campo com os nomes da keys.\n",
    "\n",
    "emprestimos_concatenados_tabelas = pd.concat([emprestimos_1,\n",
    "emprestimos_2,\n",
    "emprestimos_3,\n",
    "emprestimos_4,\n",
    "emprestimos_5,\n",
    "emprestimos_6,\n",
    "emprestimos_7,\n",
    "emprestimos_8,\n",
    "emprestimos_9,\n",
    "emprestimos_10,\n",
    "emprestimos_11,\n",
    "emprestimos_12,\n",
    "emprestimos_13,\n",
    "emprestimos_14,\n",
    "emprestimos_15,\n",
    "emprestimos_16,\n",
    "emprestimos_17,\n",
    "emprestimos_18,\n",
    "emprestimos_19,\n",
    "emprestimos_20,\n",
    "emprestimos_21], keys = ['ALUNO DE PÓS-GRADUAÇÃO', 'ALUNO DE GRADUAÇÃO'])\n",
    "\n",
    "display(emprestimos_concatenados_tabelas)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8be388dd",
   "metadata": {},
   "source": [
    "## Verificando dados duplicados usando a função pd.duplicated()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "13fe4a3e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0          False\n",
       "1          False\n",
       "2          False\n",
       "3          False\n",
       "4           True\n",
       "           ...  \n",
       "2258013    False\n",
       "2258014    False\n",
       "2258015    False\n",
       "2258016    False\n",
       "2258017    False\n",
       "Length: 2258018, dtype: bool"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#verificando dados duplicados. .duplicated retorna um serie booleana de dados duplicados. Note que o 4 é True ou seja duplicado\n",
    "duplicado = emprestimos_concatenados.duplicated()\n",
    "duplicado"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6b706622",
   "metadata": {},
   "source": [
    "## Mostrando os dados duplicados"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "b829675b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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>4</th>\n",
       "      <td>709684</td>\n",
       "      <td>L095049</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010/01/04 07:44:10.721000000</td>\n",
       "      <td>2010/01/05 16:26:12.662000000</td>\n",
       "      <td>2.008023e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>709685</td>\n",
       "      <td>L167050</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010/01/04 07:44:10.750000000</td>\n",
       "      <td>2010/01/12 07:34:13.934000000</td>\n",
       "      <td>2.008023e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>709686</td>\n",
       "      <td>2006017618</td>\n",
       "      <td>2010/01/26 08:07:01.738000000</td>\n",
       "      <td>2010/01/04 08:08:44.081000000</td>\n",
       "      <td>2010/02/25 07:36:25.800000000</td>\n",
       "      <td>2.008112e+09</td>\n",
       "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>709687</td>\n",
       "      <td>L184117</td>\n",
       "      <td>2010/01/18 11:07:46.470000000</td>\n",
       "      <td>2010/01/04 08:24:21.284000000</td>\n",
       "      <td>2010/02/03 08:58:45.692000000</td>\n",
       "      <td>2.007211e+08</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>709698</td>\n",
       "      <td>2009047725</td>\n",
       "      <td>2010/01/18 14:44:41.163000000</td>\n",
       "      <td>2010/01/04 09:21:19.099000000</td>\n",
       "      <td>2010/02/02 12:02:38.444000000</td>\n",
       "      <td>2.009047e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>709698</td>\n",
       "      <td>2009047725</td>\n",
       "      <td>2010/01/18 14:44:41.163000000</td>\n",
       "      <td>2010/01/04 09:21:19.099000000</td>\n",
       "      <td>2010/02/02 12:02:38.444000000</td>\n",
       "      <td>2.009047e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>709704</td>\n",
       "      <td>2006021442</td>\n",
       "      <td>2010/01/17 18:56:43.923000000</td>\n",
       "      <td>2010/01/04 09:58:46.522000000</td>\n",
       "      <td>2010/02/01 13:59:02.528000000</td>\n",
       "      <td>2.008010e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>709705</td>\n",
       "      <td>2009032168</td>\n",
       "      <td>2010/01/17 18:56:43.909000000</td>\n",
       "      <td>2010/01/04 09:58:46.549000000</td>\n",
       "      <td>2010/01/20 13:14:34.464000000</td>\n",
       "      <td>2.008010e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>709704</td>\n",
       "      <td>2006021442</td>\n",
       "      <td>2010/01/17 18:56:43.923000000</td>\n",
       "      <td>2010/01/04 09:58:46.522000000</td>\n",
       "      <td>2010/02/01 13:59:02.528000000</td>\n",
       "      <td>2.008010e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>709705</td>\n",
       "      <td>2009032168</td>\n",
       "      <td>2010/01/17 18:56:43.909000000</td>\n",
       "      <td>2010/01/04 09:58:46.549000000</td>\n",
       "      <td>2010/01/20 13:14:34.464000000</td>\n",
       "      <td>2.008010e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>709704</td>\n",
       "      <td>2006021442</td>\n",
       "      <td>2010/01/17 18:56:43.923000000</td>\n",
       "      <td>2010/01/04 09:58:46.522000000</td>\n",
       "      <td>2010/02/01 13:59:02.528000000</td>\n",
       "      <td>2.008010e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>709705</td>\n",
       "      <td>2009032168</td>\n",
       "      <td>2010/01/17 18:56:43.909000000</td>\n",
       "      <td>2010/01/04 09:58:46.549000000</td>\n",
       "      <td>2010/01/20 13:14:34.464000000</td>\n",
       "      <td>2.008010e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>709704</td>\n",
       "      <td>2006021442</td>\n",
       "      <td>2010/01/17 18:56:43.923000000</td>\n",
       "      <td>2010/01/04 09:58:46.522000000</td>\n",
       "      <td>2010/02/01 13:59:02.528000000</td>\n",
       "      <td>2.008010e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>709705</td>\n",
       "      <td>2009032168</td>\n",
       "      <td>2010/01/17 18:56:43.909000000</td>\n",
       "      <td>2010/01/04 09:58:46.549000000</td>\n",
       "      <td>2010/01/20 13:14:34.464000000</td>\n",
       "      <td>2.008010e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>709704</td>\n",
       "      <td>2006021442</td>\n",
       "      <td>2010/01/17 18:56:43.923000000</td>\n",
       "      <td>2010/01/04 09:58:46.522000000</td>\n",
       "      <td>2010/02/01 13:59:02.528000000</td>\n",
       "      <td>2.008010e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>709705</td>\n",
       "      <td>2009032168</td>\n",
       "      <td>2010/01/17 18:56:43.909000000</td>\n",
       "      <td>2010/01/04 09:58:46.549000000</td>\n",
       "      <td>2010/01/20 13:14:34.464000000</td>\n",
       "      <td>2.008010e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>709704</td>\n",
       "      <td>2006021442</td>\n",
       "      <td>2010/01/17 18:56:43.923000000</td>\n",
       "      <td>2010/01/04 09:58:46.522000000</td>\n",
       "      <td>2010/02/01 13:59:02.528000000</td>\n",
       "      <td>2.008010e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>709705</td>\n",
       "      <td>2009032168</td>\n",
       "      <td>2010/01/17 18:56:43.909000000</td>\n",
       "      <td>2010/01/04 09:58:46.549000000</td>\n",
       "      <td>2010/01/20 13:14:34.464000000</td>\n",
       "      <td>2.008010e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1394906</th>\n",
       "      <td>2351375</td>\n",
       "      <td>L057436</td>\n",
       "      <td>2016/01/31 07:30:36.293000000</td>\n",
       "      <td>2016/01/02 08:38:40.009000000</td>\n",
       "      <td>2016/02/21 13:16:29.000000000</td>\n",
       "      <td>2.016101e+10</td>\n",
       "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1394907</th>\n",
       "      <td>2351376</td>\n",
       "      <td>H004983</td>\n",
       "      <td>2016/01/31 07:31:36.786000000</td>\n",
       "      <td>2016/01/02 08:46:42.991000000</td>\n",
       "      <td>2016/02/22 16:10:28.000000000</td>\n",
       "      <td>2.016101e+10</td>\n",
       "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1394908</th>\n",
       "      <td>2351377</td>\n",
       "      <td>H011333</td>\n",
       "      <td>2016/01/31 07:31:36.658000000</td>\n",
       "      <td>2016/01/02 08:46:43.400000000</td>\n",
       "      <td>2016/02/22 16:10:40.000000000</td>\n",
       "      <td>2.016101e+10</td>\n",
       "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1394924</th>\n",
       "      <td>2351385</td>\n",
       "      <td>2013114886</td>\n",
       "      <td>2016/01/16 07:41:19.590000000</td>\n",
       "      <td>2016/01/02 10:02:44.456000000</td>\n",
       "      <td>2016/01/30 07:52:10.000000000</td>\n",
       "      <td>2.015316e+09</td>\n",
       "      <td>ALUNO MÉDIO/TÉCNICO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1394925</th>\n",
       "      <td>2351386</td>\n",
       "      <td>2015005192</td>\n",
       "      <td>2016/01/16 07:41:19.537000000</td>\n",
       "      <td>2016/01/02 10:02:44.507000000</td>\n",
       "      <td>2016/01/30 07:52:07.000000000</td>\n",
       "      <td>2.015316e+09</td>\n",
       "      <td>ALUNO MÉDIO/TÉCNICO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1394926</th>\n",
       "      <td>2351387</td>\n",
       "      <td>2015004940</td>\n",
       "      <td>2016/01/16 07:41:19.473000000</td>\n",
       "      <td>2016/01/02 10:02:44.560000000</td>\n",
       "      <td>2016/01/30 07:52:00.000000000</td>\n",
       "      <td>2.015316e+09</td>\n",
       "      <td>ALUNO MÉDIO/TÉCNICO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1394927</th>\n",
       "      <td>2351388</td>\n",
       "      <td>2012029817</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016/01/02 10:08:27.599000000</td>\n",
       "      <td>2016/01/23 16:28:01.000000000</td>\n",
       "      <td>2.016101e+10</td>\n",
       "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1394928</th>\n",
       "      <td>2351389</td>\n",
       "      <td>2014077426</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016/01/02 10:08:27.658000000</td>\n",
       "      <td>2016/01/23 16:27:57.000000000</td>\n",
       "      <td>2.016101e+10</td>\n",
       "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1394929</th>\n",
       "      <td>2351390</td>\n",
       "      <td>2015007050</td>\n",
       "      <td>2016/01/31 23:03:17.389000000</td>\n",
       "      <td>2016/01/02 10:08:27.720000000</td>\n",
       "      <td>2016/03/16 16:26:37.000000000</td>\n",
       "      <td>2.016101e+10</td>\n",
       "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1394930</th>\n",
       "      <td>2351391</td>\n",
       "      <td>L195470</td>\n",
       "      <td>2016/01/17 16:03:38.760000000</td>\n",
       "      <td>2016/01/02 10:12:01.462000000</td>\n",
       "      <td>2016/01/27 16:37:55.000000000</td>\n",
       "      <td>2.014036e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1394931</th>\n",
       "      <td>2351392</td>\n",
       "      <td>2015008037</td>\n",
       "      <td>2016/01/17 16:03:38.705000000</td>\n",
       "      <td>2016/01/02 10:12:01.529000000</td>\n",
       "      <td>2016/01/27 16:37:59.000000000</td>\n",
       "      <td>2.014036e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1504567</th>\n",
       "      <td>2461092</td>\n",
       "      <td>2014007909</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016/06/14 11:13:44.817000000</td>\n",
       "      <td>2016/06/16 09:55:01.000000000</td>\n",
       "      <td>2.016089e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1504568</th>\n",
       "      <td>2461093</td>\n",
       "      <td>2014007908</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016/06/14 11:15:48.131000000</td>\n",
       "      <td>2016/06/23 10:06:35.000000000</td>\n",
       "      <td>2.016014e+10</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1504569</th>\n",
       "      <td>2461094</td>\n",
       "      <td>2014007910</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016/06/14 11:16:34.407000000</td>\n",
       "      <td>2016/06/22 08:04:20.000000000</td>\n",
       "      <td>2.016013e+10</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1504570</th>\n",
       "      <td>2461095</td>\n",
       "      <td>2014007744</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016/06/14 11:16:34.459000000</td>\n",
       "      <td>2016/06/22 08:04:39.000000000</td>\n",
       "      <td>2.016013e+10</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1504571</th>\n",
       "      <td>2461096</td>\n",
       "      <td>2016005538</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016/06/14 11:16:58.596000000</td>\n",
       "      <td>2016/07/04 16:07:41.000000000</td>\n",
       "      <td>2.016014e+10</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1504572</th>\n",
       "      <td>2461097</td>\n",
       "      <td>2014083427</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016/06/14 11:17:29.152000000</td>\n",
       "      <td>2016/06/16 09:17:19.000000000</td>\n",
       "      <td>2.016014e+10</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1504573</th>\n",
       "      <td>2461098</td>\n",
       "      <td>2014049460</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016/06/14 11:18:59.254000000</td>\n",
       "      <td>2016/06/26 13:44:13.000000000</td>\n",
       "      <td>2.017005e+10</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1504574</th>\n",
       "      <td>2461099</td>\n",
       "      <td>2012008348</td>\n",
       "      <td>2016/06/27 20:35:46.855000000</td>\n",
       "      <td>2016/06/14 11:20:33.254000000</td>\n",
       "      <td>2016/07/11 14:37:29.000000000</td>\n",
       "      <td>2.015022e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         id_emprestimo codigo_barras                 data_renovacao  \\\n",
       "4               709684       L095049                            NaN   \n",
       "5               709685       L167050                            NaN   \n",
       "6               709686    2006017618  2010/01/26 08:07:01.738000000   \n",
       "7               709687       L184117  2010/01/18 11:07:46.470000000   \n",
       "19              709698    2009047725  2010/01/18 14:44:41.163000000   \n",
       "20              709698    2009047725  2010/01/18 14:44:41.163000000   \n",
       "28              709704    2006021442  2010/01/17 18:56:43.923000000   \n",
       "29              709705    2009032168  2010/01/17 18:56:43.909000000   \n",
       "30              709704    2006021442  2010/01/17 18:56:43.923000000   \n",
       "31              709705    2009032168  2010/01/17 18:56:43.909000000   \n",
       "32              709704    2006021442  2010/01/17 18:56:43.923000000   \n",
       "33              709705    2009032168  2010/01/17 18:56:43.909000000   \n",
       "34              709704    2006021442  2010/01/17 18:56:43.923000000   \n",
       "35              709705    2009032168  2010/01/17 18:56:43.909000000   \n",
       "36              709704    2006021442  2010/01/17 18:56:43.923000000   \n",
       "37              709705    2009032168  2010/01/17 18:56:43.909000000   \n",
       "38              709704    2006021442  2010/01/17 18:56:43.923000000   \n",
       "39              709705    2009032168  2010/01/17 18:56:43.909000000   \n",
       "1394906        2351375       L057436  2016/01/31 07:30:36.293000000   \n",
       "1394907        2351376       H004983  2016/01/31 07:31:36.786000000   \n",
       "1394908        2351377       H011333  2016/01/31 07:31:36.658000000   \n",
       "1394924        2351385    2013114886  2016/01/16 07:41:19.590000000   \n",
       "1394925        2351386    2015005192  2016/01/16 07:41:19.537000000   \n",
       "1394926        2351387    2015004940  2016/01/16 07:41:19.473000000   \n",
       "1394927        2351388    2012029817                            NaN   \n",
       "1394928        2351389    2014077426                            NaN   \n",
       "1394929        2351390    2015007050  2016/01/31 23:03:17.389000000   \n",
       "1394930        2351391       L195470  2016/01/17 16:03:38.760000000   \n",
       "1394931        2351392    2015008037  2016/01/17 16:03:38.705000000   \n",
       "1504567        2461092    2014007909                            NaN   \n",
       "1504568        2461093    2014007908                            NaN   \n",
       "1504569        2461094    2014007910                            NaN   \n",
       "1504570        2461095    2014007744                            NaN   \n",
       "1504571        2461096    2016005538                            NaN   \n",
       "1504572        2461097    2014083427                            NaN   \n",
       "1504573        2461098    2014049460                            NaN   \n",
       "1504574        2461099    2012008348  2016/06/27 20:35:46.855000000   \n",
       "\n",
       "                       data_emprestimo                 data_devolucao  \\\n",
       "4        2010/01/04 07:44:10.721000000  2010/01/05 16:26:12.662000000   \n",
       "5        2010/01/04 07:44:10.750000000  2010/01/12 07:34:13.934000000   \n",
       "6        2010/01/04 08:08:44.081000000  2010/02/25 07:36:25.800000000   \n",
       "7        2010/01/04 08:24:21.284000000  2010/02/03 08:58:45.692000000   \n",
       "19       2010/01/04 09:21:19.099000000  2010/02/02 12:02:38.444000000   \n",
       "20       2010/01/04 09:21:19.099000000  2010/02/02 12:02:38.444000000   \n",
       "28       2010/01/04 09:58:46.522000000  2010/02/01 13:59:02.528000000   \n",
       "29       2010/01/04 09:58:46.549000000  2010/01/20 13:14:34.464000000   \n",
       "30       2010/01/04 09:58:46.522000000  2010/02/01 13:59:02.528000000   \n",
       "31       2010/01/04 09:58:46.549000000  2010/01/20 13:14:34.464000000   \n",
       "32       2010/01/04 09:58:46.522000000  2010/02/01 13:59:02.528000000   \n",
       "33       2010/01/04 09:58:46.549000000  2010/01/20 13:14:34.464000000   \n",
       "34       2010/01/04 09:58:46.522000000  2010/02/01 13:59:02.528000000   \n",
       "35       2010/01/04 09:58:46.549000000  2010/01/20 13:14:34.464000000   \n",
       "36       2010/01/04 09:58:46.522000000  2010/02/01 13:59:02.528000000   \n",
       "37       2010/01/04 09:58:46.549000000  2010/01/20 13:14:34.464000000   \n",
       "38       2010/01/04 09:58:46.522000000  2010/02/01 13:59:02.528000000   \n",
       "39       2010/01/04 09:58:46.549000000  2010/01/20 13:14:34.464000000   \n",
       "1394906  2016/01/02 08:38:40.009000000  2016/02/21 13:16:29.000000000   \n",
       "1394907  2016/01/02 08:46:42.991000000  2016/02/22 16:10:28.000000000   \n",
       "1394908  2016/01/02 08:46:43.400000000  2016/02/22 16:10:40.000000000   \n",
       "1394924  2016/01/02 10:02:44.456000000  2016/01/30 07:52:10.000000000   \n",
       "1394925  2016/01/02 10:02:44.507000000  2016/01/30 07:52:07.000000000   \n",
       "1394926  2016/01/02 10:02:44.560000000  2016/01/30 07:52:00.000000000   \n",
       "1394927  2016/01/02 10:08:27.599000000  2016/01/23 16:28:01.000000000   \n",
       "1394928  2016/01/02 10:08:27.658000000  2016/01/23 16:27:57.000000000   \n",
       "1394929  2016/01/02 10:08:27.720000000  2016/03/16 16:26:37.000000000   \n",
       "1394930  2016/01/02 10:12:01.462000000  2016/01/27 16:37:55.000000000   \n",
       "1394931  2016/01/02 10:12:01.529000000  2016/01/27 16:37:59.000000000   \n",
       "1504567  2016/06/14 11:13:44.817000000  2016/06/16 09:55:01.000000000   \n",
       "1504568  2016/06/14 11:15:48.131000000  2016/06/23 10:06:35.000000000   \n",
       "1504569  2016/06/14 11:16:34.407000000  2016/06/22 08:04:20.000000000   \n",
       "1504570  2016/06/14 11:16:34.459000000  2016/06/22 08:04:39.000000000   \n",
       "1504571  2016/06/14 11:16:58.596000000  2016/07/04 16:07:41.000000000   \n",
       "1504572  2016/06/14 11:17:29.152000000  2016/06/16 09:17:19.000000000   \n",
       "1504573  2016/06/14 11:18:59.254000000  2016/06/26 13:44:13.000000000   \n",
       "1504574  2016/06/14 11:20:33.254000000  2016/07/11 14:37:29.000000000   \n",
       "\n",
       "         matricula_ou_siape    tipo_vinculo_usuario  \n",
       "4              2.008023e+09      ALUNO DE GRADUAÇÃO  \n",
       "5              2.008023e+09      ALUNO DE GRADUAÇÃO  \n",
       "6              2.008112e+09  ALUNO DE PÓS-GRADUAÇÃO  \n",
       "7              2.007211e+08      ALUNO DE GRADUAÇÃO  \n",
       "19             2.009047e+09      ALUNO DE GRADUAÇÃO  \n",
       "20             2.009047e+09      ALUNO DE GRADUAÇÃO  \n",
       "28             2.008010e+09      ALUNO DE GRADUAÇÃO  \n",
       "29             2.008010e+09      ALUNO DE GRADUAÇÃO  \n",
       "30             2.008010e+09      ALUNO DE GRADUAÇÃO  \n",
       "31             2.008010e+09      ALUNO DE GRADUAÇÃO  \n",
       "32             2.008010e+09      ALUNO DE GRADUAÇÃO  \n",
       "33             2.008010e+09      ALUNO DE GRADUAÇÃO  \n",
       "34             2.008010e+09      ALUNO DE GRADUAÇÃO  \n",
       "35             2.008010e+09      ALUNO DE GRADUAÇÃO  \n",
       "36             2.008010e+09      ALUNO DE GRADUAÇÃO  \n",
       "37             2.008010e+09      ALUNO DE GRADUAÇÃO  \n",
       "38             2.008010e+09      ALUNO DE GRADUAÇÃO  \n",
       "39             2.008010e+09      ALUNO DE GRADUAÇÃO  \n",
       "1394906        2.016101e+10  ALUNO DE PÓS-GRADUAÇÃO  \n",
       "1394907        2.016101e+10  ALUNO DE PÓS-GRADUAÇÃO  \n",
       "1394908        2.016101e+10  ALUNO DE PÓS-GRADUAÇÃO  \n",
       "1394924        2.015316e+09     ALUNO MÉDIO/TÉCNICO  \n",
       "1394925        2.015316e+09     ALUNO MÉDIO/TÉCNICO  \n",
       "1394926        2.015316e+09     ALUNO MÉDIO/TÉCNICO  \n",
       "1394927        2.016101e+10  ALUNO DE PÓS-GRADUAÇÃO  \n",
       "1394928        2.016101e+10  ALUNO DE PÓS-GRADUAÇÃO  \n",
       "1394929        2.016101e+10  ALUNO DE PÓS-GRADUAÇÃO  \n",
       "1394930        2.014036e+09      ALUNO DE GRADUAÇÃO  \n",
       "1394931        2.014036e+09      ALUNO DE GRADUAÇÃO  \n",
       "1504567        2.016089e+09      ALUNO DE GRADUAÇÃO  \n",
       "1504568        2.016014e+10      ALUNO DE GRADUAÇÃO  \n",
       "1504569        2.016013e+10      ALUNO DE GRADUAÇÃO  \n",
       "1504570        2.016013e+10      ALUNO DE GRADUAÇÃO  \n",
       "1504571        2.016014e+10      ALUNO DE GRADUAÇÃO  \n",
       "1504572        2.016014e+10      ALUNO DE GRADUAÇÃO  \n",
       "1504573        2.017005e+10      ALUNO DE GRADUAÇÃO  \n",
       "1504574        2.015022e+09      ALUNO DE GRADUAÇÃO  "
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Mostrando somente os dados duplicados\n",
    "linhas_duplicadas = emprestimos_concatenados[duplicado]\n",
    "linhas_duplicadas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "da2aa126",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "id_emprestimo  codigo_barras  data_renovacao                 data_emprestimo                data_devolucao                 matricula_ou_siape  tipo_vinculo_usuario  \n",
       "709704         2006021442     2010/01/17 18:56:43.923000000  2010/01/04 09:58:46.522000000  2010/02/01 13:59:02.528000000  2.008010e+09        ALUNO DE GRADUAÇÃO        7\n",
       "709705         2009032168     2010/01/17 18:56:43.909000000  2010/01/04 09:58:46.549000000  2010/01/20 13:14:34.464000000  2.008010e+09        ALUNO DE GRADUAÇÃO        7\n",
       "709698         2009047725     2010/01/18 14:44:41.163000000  2010/01/04 09:21:19.099000000  2010/02/02 12:02:38.444000000  2.009047e+09        ALUNO DE GRADUAÇÃO        3\n",
       "709686         2006017618     2010/01/26 08:07:01.738000000  2010/01/04 08:08:44.081000000  2010/02/25 07:36:25.800000000  2.008112e+09        ALUNO DE PÓS-GRADUAÇÃO    2\n",
       "2461099        2012008348     2016/06/27 20:35:46.855000000  2016/06/14 11:20:33.254000000  2016/07/11 14:37:29.000000000  2.015022e+09        ALUNO DE GRADUAÇÃO        2\n",
       "                                                                                                                                                                        ..\n",
       "1443389        2011018954     2013/03/22 13:18:55.037000000  2013/03/07 11:21:26.480000000  2013/04/08 20:26:07.000000000  2.010046e+09        ALUNO DE GRADUAÇÃO        1\n",
       "1443390        2009056314     2013/03/21 09:28:45.689000000  2013/03/07 11:21:28.899000000  2013/04/05 18:18:00.000000000  2.011015e+09        ALUNO DE GRADUAÇÃO        1\n",
       "1443393        2012037906     2013/03/20 20:17:10.574000000  2013/03/07 11:24:19.326000000  2013/03/25 08:58:44.000000000  2.011038e+09        ALUNO DE GRADUAÇÃO        1\n",
       "1443395        2011033069     2013/04/07 01:06:51.679000000  2013/03/07 11:25:22.661000000  2013/05/07 16:19:34.000000000  2.011106e+09        ALUNO DE PÓS-GRADUAÇÃO    1\n",
       "10322328       2014070441     2018/01/15 12:26:00.697000000  2017/12/29 18:21:09.060000000  2018/01/31 18:50:25.000000000  2.014063e+09        ALUNO DE GRADUAÇÃO        1\n",
       "Length: 968028, dtype: int64"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Antes de remover os duplicados vamos verificar quantas dados existem usando .valeu_counts()\n",
    "emprestimos_concatenados.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "ae3a4278",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Vamos remover os dados duplicados usando a função .drop_duplicates e depois vendo com o value counts\n",
    "emprestimos_concatenados = emprestimos_concatenados.drop_duplicates()\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "d5e2975c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "id_emprestimo  codigo_barras  data_renovacao                 data_emprestimo                data_devolucao                 matricula_ou_siape  tipo_vinculo_usuario  \n",
       "709686         2006017618     2010/01/26 08:07:01.738000000  2010/01/04 08:08:44.081000000  2010/02/25 07:36:25.800000000  2.008112e+09        ALUNO DE PÓS-GRADUAÇÃO    1\n",
       "2336122        2011033079     2016/11/21 02:01:58.488000000  2016/11/10 17:00:12.989000000  2016/12/02 14:21:49.000000000  2.016023e+09        ALUNO DE GRADUAÇÃO        1\n",
       "2336103        2014085936     2016/11/25 19:25:36.215000000  2016/11/10 16:54:52.447000000  2016/12/13 14:30:52.000000000  2.014047e+09        ALUNO DE GRADUAÇÃO        1\n",
       "2336104        2011027960     2016/11/23 17:27:54.642000000  2016/11/10 16:55:17.956000000  2016/11/28 10:32:38.000000000  2.016083e+09        ALUNO DE GRADUAÇÃO        1\n",
       "2336105        2014000897     2016/12/02 15:02:53.356000000  2016/11/10 16:55:19.851000000  2016/12/23 13:53:23.000000000  2.014071e+09        ALUNO DE GRADUAÇÃO        1\n",
       "                                                                                                                                                                        ..\n",
       "1443383        2010043058     2013/03/21 14:06:09.837000000  2013/03/07 11:17:25.008000000  2013/03/22 11:31:20.000000000  2.010023e+09        ALUNO DE GRADUAÇÃO        1\n",
       "1443387        L147018        2013/03/21 19:43:42.047000000  2013/03/07 11:20:01.159000000  2013/04/04 10:50:22.000000000  2.013053e+09        ALUNO DE GRADUAÇÃO        1\n",
       "1443389        2011018954     2013/03/22 13:18:55.037000000  2013/03/07 11:21:26.480000000  2013/04/08 20:26:07.000000000  2.010046e+09        ALUNO DE GRADUAÇÃO        1\n",
       "1443390        2009056314     2013/03/21 09:28:45.689000000  2013/03/07 11:21:28.899000000  2013/04/05 18:18:00.000000000  2.011015e+09        ALUNO DE GRADUAÇÃO        1\n",
       "10322328       2014070441     2018/01/15 12:26:00.697000000  2017/12/29 18:21:09.060000000  2018/01/31 18:50:25.000000000  2.014063e+09        ALUNO DE GRADUAÇÃO        1\n",
       "Length: 968028, dtype: int64"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "emprestimos_concatenados.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "dae379ae",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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>0</th>\n",
       "      <td>709684</td>\n",
       "      <td>L095049</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010/01/04 07:44:10.721000000</td>\n",
       "      <td>2010/01/05 16:26:12.662000000</td>\n",
       "      <td>2.008023e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>709685</td>\n",
       "      <td>L167050</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010/01/04 07:44:10.750000000</td>\n",
       "      <td>2010/01/12 07:34:13.934000000</td>\n",
       "      <td>2.008023e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>709686</td>\n",
       "      <td>2006017618</td>\n",
       "      <td>2010/01/26 08:07:01.738000000</td>\n",
       "      <td>2010/01/04 08:08:44.081000000</td>\n",
       "      <td>2010/02/25 07:36:25.800000000</td>\n",
       "      <td>2.008112e+09</td>\n",
       "      <td>ALUNO DE PÓS-GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>709687</td>\n",
       "      <td>L184117</td>\n",
       "      <td>2010/01/18 11:07:46.470000000</td>\n",
       "      <td>2010/01/04 08:24:21.284000000</td>\n",
       "      <td>2010/02/03 08:58:45.692000000</td>\n",
       "      <td>2.007211e+08</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>709688</td>\n",
       "      <td>2007027500</td>\n",
       "      <td>2010/01/19 15:59:26.464000000</td>\n",
       "      <td>2010/01/04 08:27:33.569000000</td>\n",
       "      <td>2010/02/03 13:06:30.662000000</td>\n",
       "      <td>2.009046e+09</td>\n",
       "      <td>ALUNO DE GRADUAÇÃO</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id_emprestimo codigo_barras                 data_renovacao  \\\n",
       "0         709684       L095049                            NaN   \n",
       "1         709685       L167050                            NaN   \n",
       "2         709686    2006017618  2010/01/26 08:07:01.738000000   \n",
       "3         709687       L184117  2010/01/18 11:07:46.470000000   \n",
       "8         709688    2007027500  2010/01/19 15:59:26.464000000   \n",
       "\n",
       "                 data_emprestimo                 data_devolucao  \\\n",
       "0  2010/01/04 07:44:10.721000000  2010/01/05 16:26:12.662000000   \n",
       "1  2010/01/04 07:44:10.750000000  2010/01/12 07:34:13.934000000   \n",
       "2  2010/01/04 08:08:44.081000000  2010/02/25 07:36:25.800000000   \n",
       "3  2010/01/04 08:24:21.284000000  2010/02/03 08:58:45.692000000   \n",
       "8  2010/01/04 08:27:33.569000000  2010/02/03 13:06:30.662000000   \n",
       "\n",
       "   matricula_ou_siape    tipo_vinculo_usuario  \n",
       "0        2.008023e+09      ALUNO DE GRADUAÇÃO  \n",
       "1        2.008023e+09      ALUNO DE GRADUAÇÃO  \n",
       "2        2.008112e+09  ALUNO DE PÓS-GRADUAÇÃO  \n",
       "3        2.007211e+08      ALUNO DE GRADUAÇÃO  \n",
       "8        2.009046e+09      ALUNO DE GRADUAÇÃO  "
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Vendo o cabeçalho note que o 4 que era True saiu da lista após o drop_duplicates.\n",
    "emprestimos_concatenados.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8ca4863b",
   "metadata": {},
   "source": [
    "## Carregando os dados do acervo"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "c66c321f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>568580</th>\n",
       "      <td>1353472</td>\n",
       "      <td>2021011150</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>568581</th>\n",
       "      <td>1353473</td>\n",
       "      <td>2019013454</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>568582</th>\n",
       "      <td>1353474</td>\n",
       "      <td>2019012811</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>568583</th>\n",
       "      <td>1353475</td>\n",
       "      <td>2019013451</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>568584</th>\n",
       "      <td>1353476</td>\n",
       "      <td>2019012276</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>546237 rows × 7 columns</p>\n",
       "</div>"
      ],
      "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",
       "568580      1353472    2021011150  Acervo Circulante   \n",
       "568581      1353473    2019013454  Acervo Circulante   \n",
       "568582      1353474    2019012811  Acervo Circulante   \n",
       "568583      1353475    2019013451  Acervo Circulante   \n",
       "568584      1353476    2019012276  Acervo Circulante   \n",
       "\n",
       "                                               biblioteca status_material  \\\n",
       "index                                                                       \n",
       "0                          Biblioteca Central Zila Mamede         REGULAR   \n",
       "1                          Biblioteca Central Zila Mamede         REGULAR   \n",
       "2                          Biblioteca Central Zila Mamede        ESPECIAL   \n",
       "3                          Biblioteca Central Zila Mamede         REGULAR   \n",
       "5                          Biblioteca Central Zila Mamede        ESPECIAL   \n",
       "...                                                   ...             ...   \n",
       "568580  Biblioteca Setorial do Núcleo de Educação da I...         REGULAR   \n",
       "568581                     Biblioteca Central Zila Mamede        ESPECIAL   \n",
       "568582                     Biblioteca Central Zila Mamede        ESPECIAL   \n",
       "568583                     Biblioteca Central Zila Mamede        ESPECIAL   \n",
       "568584                     Biblioteca Central Zila Mamede        ESPECIAL   \n",
       "\n",
       "        localizacao  registro_sistema  \n",
       "index                                  \n",
       "0               694                 1  \n",
       "1               688                 1  \n",
       "2               638                 1  \n",
       "3               616                 5  \n",
       "5               657                15  \n",
       "...             ...               ...  \n",
       "568580          951            268231  \n",
       "568581          997            268233  \n",
       "568582          987            268234  \n",
       "568583          764            268235  \n",
       "568584          962            268236  \n",
       "\n",
       "[546237 rows x 7 columns]"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Carregando os exemplares do acervo \n",
    "exemplares_acervo = pd.read_parquet('https://github.com/FranciscoFoz/7_Days_of_Code_Alura-Python-Pandas/raw/main/Dia_1-Importando_dados/Datasets/dados_exemplares.parquet')\n",
    "exemplares_acervo\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2b72c584",
   "metadata": {},
   "source": [
    "## Utilizando a função .merge para unir os dataframes carregados"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e3ccf09f",
   "metadata": {},
   "source": [
    "A função pd.merge mescla as tabelas com base em um campo que possua valores em comum.\n",
    "\n",
    "É possível passar um parâmetro usando a função on com base em uma coluna\n",
    "\n",
    "Ele vai colocar uma tabela ao lado da outra utilizando padrão INNER.\n",
    "\n",
    "Ou seja, só vai incluir os dados que existem nas duas tabelas ao mesmo tempo\n",
    "\n",
    "Exemplo:\n",
    "\n",
    "todos_emprestimos = pd.merge(emprestimos_concatenados, exemplares_acervo, on = 'codigo_barras')\n",
    "\n",
    "Se as tabelas tivesse campos com nomes diferentes:\n",
    "\n",
    "1-Ou renomear os campos para deixar com nomes iguais.\n",
    "\n",
    "2-Ou usar o parâmetro = pd.merge(emprestimos_concatenados, exemplares_acervo, left_on = 'codigo_barras', right_on = 'outronome')\n",
    "\n",
    "Também é possível usar o parâmetro só how e on.\n",
    "\n",
    "Exemplo:\n",
    "\n",
    "todos_emprestimos = pd.merge(emprestimos_concatenados, exemplares_acervo, on = \"tipo_vinculo_usuario\" how='left')\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3c995ada",
   "metadata": {},
   "source": [
    "##  Diferença entre INNER, OUTER, LEFT E RIGHT"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6704176b",
   "metadata": {},
   "source": [
    "Vimos que o padrão é o INNER\n",
    "\n",
    "INNER = vai pegar somente os dados que contém nas duas tabela.\n",
    "LEFT = vai pegar todos os dados da tabela da Esquerda bem como a INNER. \n",
    "RIGHT = todos os dados da tabela da direita bem como a INNER\n",
    "OUTER = todas as informações que estão em todas as tabelas. Ele não é a soma, porque ainda tem o INNER"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "45093362",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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>NaN</td>\n",
       "      <td>2010/01/04 07:44:10.721000000</td>\n",
       "      <td>2010/01/05 16:26:12.662000000</td>\n",
       "      <td>2.008023e+09</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>726965</td>\n",
       "      <td>L095049</td>\n",
       "      <td>2010/03/31 12:41:08.684000000</td>\n",
       "      <td>2010/03/01 12:40:56.212000000</td>\n",
       "      <td>2010/04/30 14:42:35.366000000</td>\n",
       "      <td>2.009122e+09</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>2</th>\n",
       "      <td>709685</td>\n",
       "      <td>L167050</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010/01/04 07:44:10.750000000</td>\n",
       "      <td>2010/01/12 07:34:13.934000000</td>\n",
       "      <td>2.008023e+09</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>3</th>\n",
       "      <td>717763</td>\n",
       "      <td>L167050</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010/02/11 11:16:30.335000000</td>\n",
       "      <td>2010/03/04 08:54:32.262000000</td>\n",
       "      <td>2.008050e+09</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>4</th>\n",
       "      <td>729996</td>\n",
       "      <td>L167050</td>\n",
       "      <td>2010/03/17 09:08:26.874000000</td>\n",
       "      <td>2010/03/04 13:36:26.599000000</td>\n",
       "      <td>2010/03/31 18:04:29.669000000</td>\n",
       "      <td>2.007226e+08</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>2072517</th>\n",
       "      <td>2989018</td>\n",
       "      <td>2009036492</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020/03/17 19:49:10.187000000</td>\n",
       "      <td>2020/12/03 08:12:20.000000000</td>\n",
       "      <td>2.015011e+10</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>2072518</th>\n",
       "      <td>2989020</td>\n",
       "      <td>2014062640</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020/03/17 19:51:15.700000000</td>\n",
       "      <td>2021/01/07 11:16:28.000000000</td>\n",
       "      <td>2.019004e+10</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>2072519</th>\n",
       "      <td>2989032</td>\n",
       "      <td>2018003324</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020/03/17 20:00:11.416000000</td>\n",
       "      <td>2021/08/30 13:29:44.000000000</td>\n",
       "      <td>2.019102e+10</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>2072520</th>\n",
       "      <td>2989049</td>\n",
       "      <td>2006024313</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020/03/17 20:47:18.741000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.015013e+10</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>2072521</th>\n",
       "      <td>2989061</td>\n",
       "      <td>2018031352</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020/03/17 21:22:22.138000000</td>\n",
       "      <td>2021/07/26 15:05:20.000000000</td>\n",
       "      <td>2.020001e+10</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>"
      ],
      "text/plain": [
       "         id_emprestimo codigo_barras                 data_renovacao  \\\n",
       "0               709684       L095049                            NaN   \n",
       "1               726965       L095049  2010/03/31 12:41:08.684000000   \n",
       "2               709685       L167050                            NaN   \n",
       "3               717763       L167050                            NaN   \n",
       "4               729996       L167050  2010/03/17 09:08:26.874000000   \n",
       "...                ...           ...                            ...   \n",
       "2072517        2989018    2009036492                            NaN   \n",
       "2072518        2989020    2014062640                            NaN   \n",
       "2072519        2989032    2018003324                            NaN   \n",
       "2072520        2989049    2006024313                            NaN   \n",
       "2072521        2989061    2018031352                            NaN   \n",
       "\n",
       "                       data_emprestimo                 data_devolucao  \\\n",
       "0        2010/01/04 07:44:10.721000000  2010/01/05 16:26:12.662000000   \n",
       "1        2010/03/01 12:40:56.212000000  2010/04/30 14:42:35.366000000   \n",
       "2        2010/01/04 07:44:10.750000000  2010/01/12 07:34:13.934000000   \n",
       "3        2010/02/11 11:16:30.335000000  2010/03/04 08:54:32.262000000   \n",
       "4        2010/03/04 13:36:26.599000000  2010/03/31 18:04:29.669000000   \n",
       "...                                ...                            ...   \n",
       "2072517  2020/03/17 19:49:10.187000000  2020/12/03 08:12:20.000000000   \n",
       "2072518  2020/03/17 19:51:15.700000000  2021/01/07 11:16:28.000000000   \n",
       "2072519  2020/03/17 20:00:11.416000000  2021/08/30 13:29:44.000000000   \n",
       "2072520  2020/03/17 20:47:18.741000000                            NaN   \n",
       "2072521  2020/03/17 21:22:22.138000000  2021/07/26 15:05:20.000000000   \n",
       "\n",
       "         matricula_ou_siape    tipo_vinculo_usuario  id_exemplar  \\\n",
       "0              2.008023e+09      ALUNO DE GRADUAÇÃO        13259   \n",
       "1              2.009122e+09  ALUNO DE PÓS-GRADUAÇÃO        13259   \n",
       "2              2.008023e+09      ALUNO DE GRADUAÇÃO        70865   \n",
       "3              2.008050e+09      ALUNO DE GRADUAÇÃO        70865   \n",
       "4              2.007226e+08      ALUNO DE GRADUAÇÃO        70865   \n",
       "...                     ...                     ...          ...   \n",
       "2072517        2.015011e+10      ALUNO DE GRADUAÇÃO       274820   \n",
       "2072518        2.019004e+10      ALUNO DE GRADUAÇÃO      1157915   \n",
       "2072519        2.019102e+10  ALUNO DE PÓS-GRADUAÇÃO      1317173   \n",
       "2072520        2.015013e+10      ALUNO DE GRADUAÇÃO       206073   \n",
       "2072521        2.020001e+10      ALUNO DE GRADUAÇÃO      1342535   \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",
       "2072517  Acervo Circulante                     Biblioteca Central Zila Mamede   \n",
       "2072518  Acervo Circulante                     Biblioteca Central Zila Mamede   \n",
       "2072519  Acervo Circulante  Biblioteca Setorial da Faculdade de Ciências d...   \n",
       "2072520  Acervo Circulante                     Biblioteca Central Zila Mamede   \n",
       "2072521  Acervo Circulante                     Biblioteca Central Zila Mamede   \n",
       "\n",
       "        status_material  localizacao  registro_sistema  \n",
       "0               REGULAR          630              4225  \n",
       "1               REGULAR          630              4225  \n",
       "2               REGULAR          647             25009  \n",
       "3               REGULAR          647             25009  \n",
       "4               REGULAR          647             25009  \n",
       "...                 ...          ...               ...  \n",
       "2072517         REGULAR          676            120845  \n",
       "2072518         REGULAR          228            213248  \n",
       "2072519         REGULAR          784            255835  \n",
       "2072520         REGULAR          663             82178  \n",
       "2072521         REGULAR          355            174443  \n",
       "\n",
       "[2072522 rows x 13 columns]"
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#juntando os dadaframes emprestimos_concatenados + exemplares_acervo e vamos criar um data frame todos_emprestimos\n",
    "#vamos utilizar a função .merge\n",
    "todos_emprestimos = emprestimos_concatenados.merge(exemplares_acervo)\n",
    "todos_emprestimos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "932bdd30",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}