pandas-analysis/jupyter-notebook-president-schedule-pandas-analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 129,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "agenda2018 = pd.read_csv(\"agenda2018.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "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>2016-05-13 09:00</th>\n",
       "      <th>Reunião Ministerial</th>\n",
       "      <th>Local: Palácio do Planalto</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2016-05-16 15:00</td>\n",
       "      <td>Eliseu Padilha, ministro-chefe da Casa Civil; ...</td>\n",
       "      <td>\\nLocal: Palácio do Planalto</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2016-05-16 17:00</td>\n",
       "      <td>Mendonça Filho, ministro da Educação e Cultura...</td>\n",
       "      <td>\\nLocal: Palácio do Planalto</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2016-05-16 18:00</td>\n",
       "      <td>Eliseu Padilha, ministro chefe da Casa Civil d...</td>\n",
       "      <td>\\nLocal: Palácio do Planalto</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2016-05-17 10:00</td>\n",
       "      <td>Despachos Internos</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2016-05-17 14:00</td>\n",
       "      <td>Reunião de Líderes da Câmara dos Deputados</td>\n",
       "      <td>\\nLocal: Palácio do Planalto</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   2016-05-13 09:00                                Reunião Ministerial  \\\n",
       "0  2016-05-16 15:00  Eliseu Padilha, ministro-chefe da Casa Civil; ...   \n",
       "1  2016-05-16 17:00  Mendonça Filho, ministro da Educação e Cultura...   \n",
       "2  2016-05-16 18:00  Eliseu Padilha, ministro chefe da Casa Civil d...   \n",
       "3  2016-05-17 10:00                                 Despachos Internos   \n",
       "4  2016-05-17 14:00         Reunião de Líderes da Câmara dos Deputados   \n",
       "\n",
       "   \\nLocal: Palácio do Planalto  Unnamed: 3  \n",
       "0  \\nLocal: Palácio do Planalto         NaN  \n",
       "1  \\nLocal: Palácio do Planalto         NaN  \n",
       "2  \\nLocal: Palácio do Planalto         NaN  \n",
       "3                           NaN         NaN  \n",
       "4  \\nLocal: Palácio do Planalto         NaN  "
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "agenda2018.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 220 entries, 0 to 219\n",
      "Data columns (total 4 columns):\n",
      "2016-05-13 09:00               220 non-null object\n",
      "Reunião Ministerial            220 non-null object\n",
      "\n",
      "Local: Palácio do Planalto    210 non-null object\n",
      "Unnamed: 3                     0 non-null float64\n",
      "dtypes: float64(1), object(3)\n",
      "memory usage: 7.0+ KB\n"
     ]
    }
   ],
   "source": [
    "agenda2018.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "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>Unnamed: 3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 3\n",
       "count         0.0\n",
       "mean          NaN\n",
       "std           NaN\n",
       "min           NaN\n",
       "25%           NaN\n",
       "50%           NaN\n",
       "75%           NaN\n",
       "max           NaN"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "agenda2018.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "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>quando</th>\n",
       "      <th>oque</th>\n",
       "      <th>onde</th>\n",
       "      <th>nda</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2016-05-16 15:00</td>\n",
       "      <td>Eliseu Padilha, ministro-chefe da Casa Civil; ...</td>\n",
       "      <td>\\nLocal: Palácio do Planalto</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2016-05-16 17:00</td>\n",
       "      <td>Mendonça Filho, ministro da Educação e Cultura...</td>\n",
       "      <td>\\nLocal: Palácio do Planalto</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             quando                                               oque  \\\n",
       "0  2016-05-16 15:00  Eliseu Padilha, ministro-chefe da Casa Civil; ...   \n",
       "1  2016-05-16 17:00  Mendonça Filho, ministro da Educação e Cultura...   \n",
       "\n",
       "                           onde  nda  \n",
       "0  \\nLocal: Palácio do Planalto  NaN  \n",
       "1  \\nLocal: Palácio do Planalto  NaN  "
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "agenda2018.columns = [\"quando\", \"oque\", \"onde\", \"nda\"]\n",
    "agenda2018.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "agenda2018[[\"ano\", \"mes\", \"dia\"]] = agenda2018.quando.str.split(\"-\", expand=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "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>quando</th>\n",
       "      <th>oque</th>\n",
       "      <th>onde</th>\n",
       "      <th>nda</th>\n",
       "      <th>ano</th>\n",
       "      <th>mes</th>\n",
       "      <th>dia</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2016-05-16 15:00</td>\n",
       "      <td>Eliseu Padilha, ministro-chefe da Casa Civil; ...</td>\n",
       "      <td>\\nLocal: Palácio do Planalto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016</td>\n",
       "      <td>05</td>\n",
       "      <td>16 15:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2016-05-16 17:00</td>\n",
       "      <td>Mendonça Filho, ministro da Educação e Cultura...</td>\n",
       "      <td>\\nLocal: Palácio do Planalto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016</td>\n",
       "      <td>05</td>\n",
       "      <td>16 17:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             quando                                               oque  \\\n",
       "0  2016-05-16 15:00  Eliseu Padilha, ministro-chefe da Casa Civil; ...   \n",
       "1  2016-05-16 17:00  Mendonça Filho, ministro da Educação e Cultura...   \n",
       "\n",
       "                           onde  nda   ano mes       dia  \n",
       "0  \\nLocal: Palácio do Planalto  NaN  2016  05  16 15:00  \n",
       "1  \\nLocal: Palácio do Planalto  NaN  2016  05  16 17:00  "
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "agenda2018.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [],
   "source": [
    "agenda2018[[\"dia\", \"hora\"]] = agenda2018.dia.str.split(\" \", expand=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "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>quando</th>\n",
       "      <th>oque</th>\n",
       "      <th>onde</th>\n",
       "      <th>nda</th>\n",
       "      <th>ano</th>\n",
       "      <th>mes</th>\n",
       "      <th>dia</th>\n",
       "      <th>hora</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2016-05-16 15:00</td>\n",
       "      <td>Eliseu Padilha, ministro-chefe da Casa Civil; ...</td>\n",
       "      <td>\\nLocal: Palácio do Planalto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016</td>\n",
       "      <td>05</td>\n",
       "      <td>16</td>\n",
       "      <td>15:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2016-05-16 17:00</td>\n",
       "      <td>Mendonça Filho, ministro da Educação e Cultura...</td>\n",
       "      <td>\\nLocal: Palácio do Planalto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016</td>\n",
       "      <td>05</td>\n",
       "      <td>16</td>\n",
       "      <td>17:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             quando                                               oque  \\\n",
       "0  2016-05-16 15:00  Eliseu Padilha, ministro-chefe da Casa Civil; ...   \n",
       "1  2016-05-16 17:00  Mendonça Filho, ministro da Educação e Cultura...   \n",
       "\n",
       "                           onde  nda   ano mes dia   hora  \n",
       "0  \\nLocal: Palácio do Planalto  NaN  2016  05  16  15:00  \n",
       "1  \\nLocal: Palácio do Planalto  NaN  2016  05  16  17:00  "
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "agenda2018.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "agenda2018_limpa = agenda2018.drop([\"quando\", \"nda\"], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "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>oque</th>\n",
       "      <th>onde</th>\n",
       "      <th>ano</th>\n",
       "      <th>mes</th>\n",
       "      <th>dia</th>\n",
       "      <th>hora</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Eliseu Padilha, ministro-chefe da Casa Civil; ...</td>\n",
       "      <td>\\nLocal: Palácio do Planalto</td>\n",
       "      <td>2016</td>\n",
       "      <td>05</td>\n",
       "      <td>16</td>\n",
       "      <td>15:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Mendonça Filho, ministro da Educação e Cultura...</td>\n",
       "      <td>\\nLocal: Palácio do Planalto</td>\n",
       "      <td>2016</td>\n",
       "      <td>05</td>\n",
       "      <td>16</td>\n",
       "      <td>17:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                oque  \\\n",
       "0  Eliseu Padilha, ministro-chefe da Casa Civil; ...   \n",
       "1  Mendonça Filho, ministro da Educação e Cultura...   \n",
       "\n",
       "                           onde   ano mes dia   hora  \n",
       "0  \\nLocal: Palácio do Planalto  2016  05  16  15:00  \n",
       "1  \\nLocal: Palácio do Planalto  2016  05  16  17:00  "
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "agenda2018_limpa.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [],
   "source": [
    "agenda2018_limpa[[\"nda\", \"onde\"]] = agenda2018_limpa.onde.str.split(\"Local: \", expand=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "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>oque</th>\n",
       "      <th>onde</th>\n",
       "      <th>ano</th>\n",
       "      <th>mes</th>\n",
       "      <th>dia</th>\n",
       "      <th>hora</th>\n",
       "      <th>nda</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Eliseu Padilha, ministro-chefe da Casa Civil; ...</td>\n",
       "      <td>Palácio do Planalto</td>\n",
       "      <td>2016</td>\n",
       "      <td>05</td>\n",
       "      <td>16</td>\n",
       "      <td>15:00</td>\n",
       "      <td>\\n</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Mendonça Filho, ministro da Educação e Cultura...</td>\n",
       "      <td>Palácio do Planalto</td>\n",
       "      <td>2016</td>\n",
       "      <td>05</td>\n",
       "      <td>16</td>\n",
       "      <td>17:00</td>\n",
       "      <td>\\n</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                oque                 onde  \\\n",
       "0  Eliseu Padilha, ministro-chefe da Casa Civil; ...  Palácio do Planalto   \n",
       "1  Mendonça Filho, ministro da Educação e Cultura...  Palácio do Planalto   \n",
       "\n",
       "    ano mes dia   hora nda  \n",
       "0  2016  05  16  15:00  \\n  \n",
       "1  2016  05  16  17:00  \\n  "
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "agenda2018_limpa.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [],
   "source": [
    "agenda2018_limpaFinal = agenda2018_limpa.drop([\"nda\"], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "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>oque</th>\n",
       "      <th>onde</th>\n",
       "      <th>ano</th>\n",
       "      <th>mes</th>\n",
       "      <th>dia</th>\n",
       "      <th>hora</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Eliseu Padilha, ministro-chefe da Casa Civil; ...</td>\n",
       "      <td>Palácio do Planalto</td>\n",
       "      <td>2016</td>\n",
       "      <td>05</td>\n",
       "      <td>16</td>\n",
       "      <td>15:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Mendonça Filho, ministro da Educação e Cultura...</td>\n",
       "      <td>Palácio do Planalto</td>\n",
       "      <td>2016</td>\n",
       "      <td>05</td>\n",
       "      <td>16</td>\n",
       "      <td>17:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Eliseu Padilha, ministro chefe da Casa Civil d...</td>\n",
       "      <td>Palácio do Planalto</td>\n",
       "      <td>2016</td>\n",
       "      <td>05</td>\n",
       "      <td>16</td>\n",
       "      <td>18:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Despachos Internos</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016</td>\n",
       "      <td>05</td>\n",
       "      <td>17</td>\n",
       "      <td>10:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Reunião de Líderes da Câmara dos Deputados</td>\n",
       "      <td>Palácio do Planalto</td>\n",
       "      <td>2016</td>\n",
       "      <td>05</td>\n",
       "      <td>17</td>\n",
       "      <td>14:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Reunião com o Ministro da Fazenda, Henrique Me...</td>\n",
       "      <td>Palácio do Planalto</td>\n",
       "      <td>2016</td>\n",
       "      <td>05</td>\n",
       "      <td>17</td>\n",
       "      <td>16:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Ex-presidente José Sarney</td>\n",
       "      <td>Palácio do Planalto</td>\n",
       "      <td>2016</td>\n",
       "      <td>05</td>\n",
       "      <td>17</td>\n",
       "      <td>17:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Embaixador Mauro Vieira</td>\n",
       "      <td>Palácio do Planalto</td>\n",
       "      <td>2016</td>\n",
       "      <td>05</td>\n",
       "      <td>17</td>\n",
       "      <td>18:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Senadora Marta Suplicy (PMDB/SP)</td>\n",
       "      <td>Palácio do Planalto</td>\n",
       "      <td>2016</td>\n",
       "      <td>05</td>\n",
       "      <td>17</td>\n",
       "      <td>18:15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Senador Renan Calheiros</td>\n",
       "      <td>None</td>\n",
       "      <td>2016</td>\n",
       "      <td>05</td>\n",
       "      <td>17</td>\n",
       "      <td>18:40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Mendonça Filho</td>\n",
       "      <td>None</td>\n",
       "      <td>2016</td>\n",
       "      <td>05</td>\n",
       "      <td>17</td>\n",
       "      <td>19:25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>José Serra</td>\n",
       "      <td>None</td>\n",
       "      <td>2016</td>\n",
       "      <td>05</td>\n",
       "      <td>17</td>\n",
       "      <td>20:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Café da manhã com líderes do Senado Federal</td>\n",
       "      <td>Palácio do Jaburu</td>\n",
       "      <td>2016</td>\n",
       "      <td>05</td>\n",
       "      <td>18</td>\n",
       "      <td>09:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Gilberto Kassab</td>\n",
       "      <td>None</td>\n",
       "      <td>2016</td>\n",
       "      <td>05</td>\n",
       "      <td>18</td>\n",
       "      <td>17:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Fernando Coelho Filho</td>\n",
       "      <td>None</td>\n",
       "      <td>2016</td>\n",
       "      <td>05</td>\n",
       "      <td>18</td>\n",
       "      <td>17:30</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 oque                 onde  \\\n",
       "0   Eliseu Padilha, ministro-chefe da Casa Civil; ...  Palácio do Planalto   \n",
       "1   Mendonça Filho, ministro da Educação e Cultura...  Palácio do Planalto   \n",
       "2   Eliseu Padilha, ministro chefe da Casa Civil d...  Palácio do Planalto   \n",
       "3                                  Despachos Internos                  NaN   \n",
       "4          Reunião de Líderes da Câmara dos Deputados  Palácio do Planalto   \n",
       "5   Reunião com o Ministro da Fazenda, Henrique Me...  Palácio do Planalto   \n",
       "6                           Ex-presidente José Sarney  Palácio do Planalto   \n",
       "7                             Embaixador Mauro Vieira  Palácio do Planalto   \n",
       "8                    Senadora Marta Suplicy (PMDB/SP)  Palácio do Planalto   \n",
       "9                             Senador Renan Calheiros                 None   \n",
       "10                                     Mendonça Filho                 None   \n",
       "11                                         José Serra                 None   \n",
       "12        Café da manhã com líderes do Senado Federal    Palácio do Jaburu   \n",
       "13                                    Gilberto Kassab                 None   \n",
       "14                              Fernando Coelho Filho                 None   \n",
       "\n",
       "     ano mes dia   hora  \n",
       "0   2016  05  16  15:00  \n",
       "1   2016  05  16  17:00  \n",
       "2   2016  05  16  18:00  \n",
       "3   2016  05  17  10:00  \n",
       "4   2016  05  17  14:00  \n",
       "5   2016  05  17  16:00  \n",
       "6   2016  05  17  17:00  \n",
       "7   2016  05  17  18:00  \n",
       "8   2016  05  17  18:15  \n",
       "9   2016  05  17  18:40  \n",
       "10  2016  05  17  19:25  \n",
       "11  2016  05  17  20:00  \n",
       "12  2016  05  18  09:00  \n",
       "13  2016  05  18  17:00  \n",
       "14  2016  05  18  17:30  "
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "agenda2018_limpaFinal.head(15)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "metadata": {},
   "outputs": [],
   "source": [
    "agenda2016 = agenda2018_limpaFinal.fillna(\"semLocal\") # corrigindo o nome da variavel"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "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>oque</th>\n",
       "      <th>onde</th>\n",
       "      <th>ano</th>\n",
       "      <th>mes</th>\n",
       "      <th>dia</th>\n",
       "      <th>hora</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Eliseu Padilha, ministro-chefe da Casa Civil; ...</td>\n",
       "      <td>Palácio do Planalto</td>\n",
       "      <td>2016</td>\n",
       "      <td>05</td>\n",
       "      <td>16</td>\n",
       "      <td>15:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Mendonça Filho, ministro da Educação e Cultura...</td>\n",
       "      <td>Palácio do Planalto</td>\n",
       "      <td>2016</td>\n",
       "      <td>05</td>\n",
       "      <td>16</td>\n",
       "      <td>17:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Eliseu Padilha, ministro chefe da Casa Civil d...</td>\n",
       "      <td>Palácio do Planalto</td>\n",
       "      <td>2016</td>\n",
       "      <td>05</td>\n",
       "      <td>16</td>\n",
       "      <td>18:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Despachos Internos</td>\n",
       "      <td>semLocal</td>\n",
       "      <td>2016</td>\n",
       "      <td>05</td>\n",
       "      <td>17</td>\n",
       "      <td>10:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Reunião de Líderes da Câmara dos Deputados</td>\n",
       "      <td>Palácio do Planalto</td>\n",
       "      <td>2016</td>\n",
       "      <td>05</td>\n",
       "      <td>17</td>\n",
       "      <td>14:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                oque                 onde  \\\n",
       "0  Eliseu Padilha, ministro-chefe da Casa Civil; ...  Palácio do Planalto   \n",
       "1  Mendonça Filho, ministro da Educação e Cultura...  Palácio do Planalto   \n",
       "2  Eliseu Padilha, ministro chefe da Casa Civil d...  Palácio do Planalto   \n",
       "3                                 Despachos Internos             semLocal   \n",
       "4         Reunião de Líderes da Câmara dos Deputados  Palácio do Planalto   \n",
       "\n",
       "    ano mes dia   hora  \n",
       "0  2016  05  16  15:00  \n",
       "1  2016  05  16  17:00  \n",
       "2  2016  05  16  18:00  \n",
       "3  2016  05  17  10:00  \n",
       "4  2016  05  17  14:00  "
      ]
     },
     "execution_count": 96,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "agenda2016.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "metadata": {},
   "outputs": [],
   "source": [
    "encontros2016 = agenda2016[\"oque\"].str.lower().str.split(\",\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0      [eliseu padilha,  ministro-chefe da casa civil...\n",
       "1      [mendonça filho,  ministro da educação e cultu...\n",
       "2      [eliseu padilha,  ministro chefe da casa civil...\n",
       "3                                   [despachos internos]\n",
       "4          [ reunião de líderes da câmara dos deputados]\n",
       "5      [reunião com o ministro da fazenda,  henrique ...\n",
       "6                            [ex-presidente josé sarney]\n",
       "7                              [embaixador mauro vieira]\n",
       "8                     [senadora marta suplicy (pmdb/sp)]\n",
       "9                              [senador renan calheiros]\n",
       "10                                      [mendonça filho]\n",
       "11                                          [josé serra]\n",
       "12         [café da manhã com líderes do senado federal]\n",
       "13                                     [gilberto kassab]\n",
       "14                               [fernando coelho filho]\n",
       "15     [reunião com a bancada feminina da câmara dos ...\n",
       "16     [general do exército sérgio etchegoyen,  minis...\n",
       "17                                 [fábio medina osório]\n",
       "18                             [fabiano augusto martins]\n",
       "19                                        [sarney filho]\n",
       "20     [eliseu padilha,  ministro-chefe da casa civil...\n",
       "21                                  [despachos internos]\n",
       "22                                     [renan calheiros]\n",
       "23                 [apresentação das medidas econômicas]\n",
       "24     [eduardo paes,  prefeito do rio de janeiro,  e...\n",
       "25     [solenidade de posse do senhor marcelo calero,...\n",
       "26     [senador antônio carlos valadares (psb/se),  s...\n",
       "27                            [senador romário (psb/rj)]\n",
       "28     [marconi perillo,  governador do estado de goiás]\n",
       "29     [cerimônia de apresentação de credenciais dos ...\n",
       "                             ...                        \n",
       "190    [reunião com ministros do núcleo de infraestru...\n",
       "191                   [senador vicentinho alves (pr/to)]\n",
       "192           [henrique meirelles - ministro da fazenda]\n",
       "193                            [paulo rabello de castro]\n",
       "194    [fernando figueiredo - presidente-executivo da...\n",
       "195    [ato de assinatura de decretos de promoção dos...\n",
       "196                      [senador aécio neves (psdb mg)]\n",
       "197                                      [pedro parente]\n",
       "198                            [guilherme afif domingos]\n",
       "199                                     [marcos pereira]\n",
       "200              [deputado jorge tadeu mudalen (dem/sp)]\n",
       "201                     [senador valdir raupp (pmdb/rr)]\n",
       "202                  [senador ricardo ferraço (psdb/es)]\n",
       "203    [joão martins da silva júnior - presidente da ...\n",
       "204    [alexandre de moraes - ministro da justiça e c...\n",
       "205    [evandro guimarães - presidente executivo do i...\n",
       "206    [josé roberto maciel - presidente do sistema b...\n",
       "207    [henrique meirelles,  ministro da fazenda e ro...\n",
       "208    [henrique meirelles,  ministro da fazenda e dy...\n",
       "209                [bruno araújo - ministro das cidades]\n",
       "210                                 [despachos internos]\n",
       "211                                 [henrique meirelles]\n",
       "212                                        [paulo skaff]\n",
       "213    [raul jungmann,  ministro da defesa; general s...\n",
       "214          [partida de brasília para o rio de janeiro]\n",
       "215                          [chegada ao rio de janeiro]\n",
       "216      [apresentação sobre a obra da linha 4 do metrô]\n",
       "217       [cerimônia de inauguração da linha 4 do metrô]\n",
       "218            [partida do rio de janeiro para brasília]\n",
       "219                                 [chegada a brasília]\n",
       "Name: oque, Length: 220, dtype: object"
      ]
     },
     "execution_count": 101,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "encontros2016"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 128,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict_items([('', 15), ('Gandra', 1), ('(PSC/SE),', 2), ('Sarney', 2), ('PR;', 1), ('Wellington', 1), ('FIES', 1), ('Tribunal', 1), ('Partido', 2), ('Forte', 1), ('Empresariais', 2), ('Maia,', 2), ('chefe', 1), ('(PMDB/AM)', 1), ('(PDT/AP),', 1), ('Cidadania;', 2), ('Patah,', 1), ('disciplina', 1), ('Inovações', 3), ('Solidariedade', 1), ('Góes', 1), ('Alves', 2), ('ministro-chefe', 3), ('econômica', 1), ('2016', 1), ('Atletas', 1), ('Raul', 4), ('(PDT/RR)', 1), ('Senadora', 3), ('Estudantil', 1), ('e', 64), ('ministro', 33), ('CONCEPAB', 1), ('MJ', 1), ('Sul.', 1), ('Avelino', 1), ('Zezé', 1), ('Institucional;', 1), ('do', 85), ('Encontro', 3), ('Hélio', 1), ('Franco', 2), ('estado', 1), ('Maggi', 1), ('Carlos', 6), ('celulose', 1), ('Dyogo', 3), ('Inovação', 1), ('Esporte;', 1), ('Jungmann,', 3), ('Civil;', 4), ('Governo.', 1), ('Vida', 1), ('Minas', 3), ('GSIPR;', 1), ('promoção', 1), ('Eladio', 1), ('Civil', 3), ('Distrito', 1), ('em', 3), ('Congresso', 2), ('Calixto', 1), ('governador', 3), ('senador', 3), ('Agricultura,', 1), ('Barbosa', 1), ('Ar', 1), ('Waldir', 2), ('Educação', 3), ('Luta', 1), ('Leal', 1), ('Figueiredo', 1), ('de', 97), ('Lozardo,', 1), ('Marconi', 1), ('(PMDB/RO)', 2), ('Embaixador', 1), ('Borba', 1), ('Westphalen', 1), ('Suplicy', 1), ('(PTB/MG)', 1), ('Santana', 1), ('Miranda', 1), ('Decolagem', 1), ('João', 2), ('Buarque', 1), ('Econômico.', 1), ('Joseph', 1), ('Pecuária', 2), ('econômicas', 1), ('nova', 2), ('pela', 1), ('Marta', 1), ('Justiça', 4), ('Cristovam', 1), ('Rossi', 1), ('Calheiros', 2), ('Guimarães', 2), ('Sanção', 1), ('Sindicais', 2), ('Serra,', 2), ('Meirelles,', 9), ('Parlamento', 1), ('ABIQUIM', 1), ('–', 3), ('manhã', 1), ('trabalho', 1), ('Antônio', 3), ('José', 11), ('Executivo', 2), ('(PR/PR)', 1), ('concede', 1), ('Aníbal', 1), ('SBT', 1), ('Exteriores;', 1), ('Valmir', 1), ('Pescadores', 1), ('que', 2), ('Tecnologia,', 3), ('Ademir', 2), ('Quintão,', 1), ('Ciência,', 3), ('Osmar', 1), ('Occhi,', 3), ('Feminina', 1), ('Bezerra', 1), ('fundo', 1), ('Vieira', 3), ('das', 10), ('Alencar', 1), ('secretário-executivo', 2), ('Oficial', 1), ('Santa', 1), ('Lima,', 2), ('Associação', 3), ('Marinha;', 1), ('Agricultura', 1), ('Maciel', 1), ('Wilson', 1), ('Ivo', 1), ('Agribusiness', 1), ('Rossi,', 1), ('Presidência', 1), ('Bunge', 1), ('Gestão', 4), ('Coelho', 5), ('Moreira', 3), ('restituição', 1), ('Fenabrave', 1), ('Recepção', 1), ('Roberto', 3), ('(DEM/SE)', 1), ('Delegação', 1), ('Alfredo', 1), ('Skaf', 1), ('homenagem', 1), ('Brasília/DF', 1), ('Turra', 1), ('PPS', 1), ('Brasil', 6), ('Tenente-Brigadeiro', 1), ('Frente', 2), ('Ferreira,', 1), ('Institucional', 3), ('(DEM/RJ),', 1), ('Osório', 1), ('Quintella,', 1), ('Serviços', 1), ('Bruno', 4), ('Papa', 1), ('(DEM/SP)', 1), ('Ministro-Chefe', 3), ('Trezza,', 1), ('(PR/MT),', 1), ('a', 7), ('Energia;', 1), ('Senador', 25), ('Sobrinho,', 2), ('no', 9), ('Primeiro', 1), ('Conselhos', 1), ('embaixadores', 1), ('Jardim', 1), ('Congresso,', 1), ('Otto', 1), ('Bernardo', 1), ('Arthur', 2), ('Francisco', 2), ('Nogueira', 1), ('semestre,', 1), ('Exterior', 1), ('Ato', 2), ('MG)', 1), ('Câmara', 9), ('MS.', 1), ('(PSDB/SP)', 1), ('Presidente', 21), ('Forum', 1), ('Distribuição', 1), ('(PTdoB/MG)', 1), ('Filho', 8), ('Aleluia', 1), ('ANAJURE.', 1), ('(PPS/PR)', 1), ('Vice-Presidente', 1), ('Econômico', 2), ('competência', 1), ('Foletto,', 1), ('Municípios', 1), ('Mauro', 3), ('Turismo;', 1), ('Ometto', 1), ('Kassab', 2), ('Nacional', 13), ('(PSB/SE),', 1), ('Picciani,', 1), ('Aeronáutica;', 1), ('Prata,', 1), ('Alves,', 1), ('Assembleias', 1), ('Mesquita', 1), ('Empresarial', 1), ('Financiamento', 1), ('Loizaga', 1), ('Augusto', 2), ('Calero', 2), ('Grosso', 1), ('(PR/ES)', 1), ('Televisão', 1), ('Brasil;', 1), ('Líder', 2), ('Etchegoyen.', 1), ('Fagundes', 1), ('eventos,', 1), ('Partida', 2), ('apresentação', 2), ('Silvia', 1), ('Bach,', 1), ('Nardes', 1), ('Vicentinho', 1), ('Monteiro', 1), ('Almirante-de-Esquadra', 1), ('Ambev', 1), ('André', 2), ('Freitas', 1), ('Barros', 1), ('Parente,', 1), ('Brasileiro', 3), ('medidas', 1), ('Pontes', 1), ('Evangélicas', 1), ('Franco,', 1), ('Chegada', 5), ('Internacional', 1), ('Sartori', 1), ('Núcleo', 6), ('Maria', 1), ('Olímpico', 3), ('Borba/PR', 1), ('Embaixadores', 1), ('Defesa.', 1), ('Tripoli', 1), ('equipe', 1), ('Goergen', 1), ('Luiz', 2), ('4', 2), ('Vaz', 1), ('Etchegoyen', 1), ('federativas', 1), ('senhor', 3), ('Assumpção', 1), ('COI', 1), ('Ambiente;', 1), ('coletivo', 1), ('Baleia', 2), ('Andrei', 1), ('Ministros', 1), ('sobre', 1), ('liberação', 1), ('Agrário', 1), ('italiana', 1), ('EMCFA;', 1), ('Araújo', 2), ('Malta', 2), ('Instituto', 3), ('Aeronáutica', 1), ('Secretaria', 2), ('(PPS/DF);', 1), ('Serra', 1), ('Bueno,', 1), ('Banco', 5), ('(Agência', 1), ('Alcolumbre', 1), ('Renan', 5), ('Segurança', 4), ('prefeito', 1), ('Brasileiras;', 1), ('Botos', 1), ('Jayme', 1), ('Lei', 2), ('Beto', 1), ('Geografia', 1), ('Ministro', 23), ('unidades', 1), ('Alberto', 1), ('Metrô', 2), ('Nuzman,', 1), ('(PSDB/ES)', 2), ('Gabinete', 1), ('Robson', 1), ('Federal.', 1), ('individual', 1), ('Comitê', 3), ('(PSB/RJ)', 1), ('Janot', 1), ('RJ', 1), ('Rio', 7), ('Júnior', 2), ('Linha', 2), ('Pedro', 3), ('(DEM/AM)', 1), ('Petrobras', 1), ('Brasíleiro', 1), ('Popular', 1), ('fábrica', 1), ('Global', 1), ('Rondônia', 1), ('(PMDB/RR)', 1), ('Minha', 2), ('senhores', 1), ('Rabello', 2), ('Nivaldo', 1), ('Skaff', 1), ('com', 13), ('Fazenda;', 3), ('Desenvolvimento', 6), ('IBM', 1), ('Grande', 1), ('Lopes,', 2), ('(FPA)', 1), ('abertura', 1), ('Geddel', 2), ('Fazenda', 6), ('Pequena', 1), ('Giacobo', 1), ('Jerônimo', 1), ('Marques,', 1), ('Federal,', 3), ('(Ipea)', 1), ('Indústria,', 1), ('Bueno', 2), ('Valadares', 2), ('Parque', 1), ('Exército;', 1), ('(PMDB/RR),', 1), ('(PP/PI)', 1), ('Freitas,', 1), ('anúncio', 2), ('Aviação', 1), ('líderes', 2), ('(BNDES)', 1), ('Caixa', 3), ('Federação', 1), ('Sergio', 1), ('Cafarelli,', 1), ('Indústria', 2), ('Pinheiro', 1), ('Porto', 1), ('Helder', 3), ('Eliseu', 7), ('Acre', 1), ('Social', 3), ('Moura,', 1), ('Paes,', 1), ('Parlamentar', 1), ('(DEM/AP)', 1), ('Solenidade', 1), ('ministros', 4), ('Faria', 1), ('Suely', 1), ('diretor-geral', 1), ('Blairo', 1), ('processo', 1), ('interino', 1), ('Tibé', 1), ('o', 6), ('Educação.', 1), ('Claudio', 1), ('Raupp', 3), ('Ricardo', 6), ('ABME', 1), ('recursos', 1), ('Rodrigues,', 1), ('Fernando', 6), ('Família', 1), ('Goiás', 1), ('Micro', 1), ('2º', 1), ('Ives', 1), ('Confederação', 4), ('Administração', 1), ('Amorim', 3), ('Brasileira', 4), ('Nogueira,', 1), ('Laguna/SC', 1), ('Benito', 1), ('Oliveira', 4), ('Portos', 1), ('Jatene', 1), ('(PP/MA)', 1), ('Rodrigo', 6), ('mil', 1), ('Conselho', 2), ('Tadeu', 1), ('Afif', 1), ('Fabiano', 1), ('Silveira', 1), ('Cidadania', 2), ('Pastores', 1), ('Guilherme', 2), ('Couri', 1), ('Despachos', 7), ('Mobilização', 1), ('Direção', 1), ('Automotores', 1), ('Sérgio', 7), ('Veículos', 1), ('residentes', 1), ('Medina', 1), ('Marcos', 2), ('Moraes', 2), ('Fábio', 1), ('Proteína', 1), ('Ética', 1), ('sanção', 1), ('Bastos', 1), ('-', 42), ('Mello', 1), ('Relações', 2), ('Abertura', 1), ('SP', 1), ('Programa', 2), ('da', 94), ('CEO', 1), ('Transparência,', 1), ('(SD/SP)', 1), ('Aplicada', 1), ('Defesa;', 2), ('Internos', 2), ('Café', 1), ('Pôr', 1), ('grandes', 1), ('Interino', 1), ('Mariani', 1), ('Romário', 1), ('Barbalho', 2), ('dos', 16), ('Marcelo', 6), ('Perrella', 1), ('estados', 1), ('Pauderney', 2), ('italiano', 1), ('Rose', 2), ('Marun,', 1), ('Alexandre', 5), ('Credenciais', 1), ('Santander', 1), ('Ronaldo', 1), ('Ibsen', 1), ('UGT;', 1), ('secretário', 1), ('FNL', 1), ('(PP/RS)', 1), ('Exército', 2), ('Janeiro', 4), ('Davi', 1), ('Gerdau', 2), ('MG', 2), ('Comandante', 3), ('ETCO', 1), ('Rodovalho', 1), ('Antonio', 1), ('Silva,', 1), ('bancadas', 1), ('Parente', 1), ('Química', 1), ('Centrais', 2), ('Comandantes', 1), ('NCST;', 1), ('Governadores', 1), ('Rossato,', 1), ('Federal', 10), ('Souza', 2), ('Chefe', 1), ('Henrique', 15), ('Maurício', 1), ('Gama', 1), ('CACB', 1), ('Jorge', 4), ('aumento', 1), ('(PP/AL)', 2), ('Kassab,', 2), ('(PSDB', 1), ('Robinson', 1), ('obra', 1), ('Câncer', 1), ('Renata', 1), ('Ataídes', 1), ('Almirante', 2), ('Central', 1), ('após', 1), ('Embarque', 2), ('senadores', 1), ('(PSD/BA),', 1), ('Castro', 2), ('(PMDB/AL)', 1), ('PRB', 1), ('Pereira', 4), ('Parada', 1), ('representantes', 2), ('Distrital', 1), ('Puccinelli,', 1), ('Domingos', 1), ('injunção', 1), ('Gilberto', 7), ('Capital', 1), ('Mota', 1), ('Portas', 1), ('Araújo,', 3), ('Imbassahy,', 1), ('Johannpeter', 1), ('Rollemberg,', 1), ('SIMPI', 1), ('Deputados', 8), ('Deputado', 23), ('Pesquisa', 1), ('Olímpicos', 1), ('Integração', 2), ('Camilo', 1), ('norma', 1), ('Agropecuária', 1), ('Eduardo', 9), ('Azevêdo,', 1), ('Rial', 1), ('Mídias', 1), ('Avelino,', 1), ('Torquato', 1), ('Cultura', 4), ('(PSDB/TO)', 1), ('República;', 1), ('mandado', 1), ('edital', 1), ('Almoço', 1), ('presidente', 19), ('Animal', 1), ('Sul', 1), ('2016,', 1), ('Taques', 1), ('Ferraço', 2), ('Estado', 5), ('Exteriores', 1), ('Perillo,', 1), ('Inteligência)', 1), ('Marinha,', 1), ('Padilha,', 8), ('Moraes,', 3), ('Paz', 1), ('posse', 3), ('Presidente-Executivo', 1), ('Generais', 1), ('aos', 1), ('Picciani', 1), ('Reunião', 12), ('Amapá', 1), ('Luis', 1), ('Bancada', 3), ('novo', 1), ('diretor', 1), ('(PTB/BA)', 1), ('Maranhão', 3), ('Moinho', 1), ('Meirelles', 4), ('Leonardo', 3), ('Despacho', 1), ('(PSB/CE)', 1), ('Infraestrutura', 2), ('Parcerias', 1), ('Goldfajn', 1), ('deputada', 1), ('Oficiais', 1), ('Educação;', 2), ('Etchegoyen,', 4), ('Abin', 1), ('Secretário', 1), ('Waldez', 1), ('Ernesto', 1), ('Brasília', 6), ('Defensor', 1), ('Klabin', 1), ('Costa', 1), ('assinatura', 2), ('(PMDB/SP)', 2), ('Investimento.', 1), ('Valdir', 3), ('(PSC/SE)', 1), ('Sindical', 1), ('Telmário', 1), ('Inauguração', 2), ('CNA', 1), ('general', 1), ('Braga', 1), ('70', 1), ('Nacional;', 2), ('Diretor-Geral', 1), ('Telêmaco', 2), ('Boas,', 1), ('Estatística-IBGE,', 1), ('na', 2), ('Benedito', 1), ('Científica', 1), ('Apresentação', 2), ('Filho,', 5), ('(MEI)', 1), ('PMDB', 4), ('Barbalho,', 1), ('Pinto', 1), ('líder', 2), ('(PMDB/SC)', 1), ('Senado', 5), ('Comunicações', 3), ('Residentes', 1), ('Rogério', 2), ('Força', 1), ('ao', 5), ('Mara', 1), ('governo', 2), ('Visita', 1), ('ABPA', 1), ('General', 5), ('Brasil,', 1), ('Socialista', 1), ('Governo', 2), ('Posse', 3), ('Romero', 2), ('Silva', 2), ('Barretos/SP', 1), ('Aécio', 1), ('Fazenda,', 1), ('Martins', 3), ('Legislativas', 1), ('Trabalho;', 1), ('Cidades', 3), ('Ilan', 1), ('Jucá', 1), ('Líderes', 5), ('(PR/TO)', 1), ('Paiva', 1), ('Sé', 1), ('Ramos,', 1), ('Neto,', 1), ('Pinho', 1), ('Sindicato', 1), ('(PSB/SE)', 1), ('Campos,', 1), ('título', 1), ('Chammas', 1), ('Central,', 1), ('Danilo', 1), ('Alarico', 1), ('Mendonça', 6), ('Fazenda.', 1), ('Hospital', 1), ('Caffarelli,', 1), ('internos', 5), ('Fiscalização', 1), ('IBAMA', 1), ('estrangeiros', 1), ('(PSDB/BA)', 1), ('Correios', 1), ('Mudalen', 1), ('(PMDB/DF)', 1), ('Lewandowski,', 1), ('Calheiros,', 3), ('.', 1), ('Heringer', 1), ('Janeiro,', 1), ('federais', 1), ('Janeiro.', 1), ('Supremo', 1), ('governo.', 1), ('ex-governador', 1), ('(PMDB/PB)', 1), ('Público', 1), ('Oliveira,', 1), ('Sistema', 1), ('Terra', 1), ('membros', 2), ('Bolsa', 1), ('Sol', 1), ('Energia', 2), ('Evandro', 1), ('OMC', 1), ('Controle', 1), ('Embaixada', 1), ('vagas.', 1), ('Calero,', 1), ('Ex-presidente', 1), ('Neto', 1), ('Meio', 1), ('Kaefer', 1), ('Econômica', 4), ('Transportes,', 1), ('Maia', 2), ('Comunidade', 1), ('Planejamento,', 4), ('Lira', 2), ('Abastecimento', 1), ('entrega', 1), ('Mato', 1), ('Magno', 2), ('julgamento', 1), ('Sesi', 1), ('interno', 1), ('Concorrencial', 1), ('Comerciais', 1), ('credenciais', 1), ('decretos', 1), ('São', 2), ('Grupo', 1), ('Mario', 1), ('Richa', 1), ('Cruz,', 1), ('Rubens', 3), ('Villas', 1), ('Ciro', 1), ('Cerimônia', 12), ('/', 2), ('Paulo', 11), ('delegação', 1), ('Casa', 7), ('Simão', 1), ('Neves', 1), ('Associações', 1), ('município', 1), ('Jucá,', 1), ('Thomas', 1), ('(PMDB/ES)', 1), ('Comércio', 1), ('cargo', 6), ('Presidentes', 1), ('para', 8), ('Estaduais', 1)])"
      ]
     },
     "execution_count": 128,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from collections import Counter\n",
    "result = Counter(\" \".join(agenda2016[\"oque\"].values.tolist()).split(\" \")).items()\n",
    "result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.5.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}