Ktexto.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "6036ef6a-b208-422d-9120-69a9e639f545",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import unidecode\n",
    "from string import punctuation\n",
    "from nltk import RSLPStemmer\n",
    "from nltk.tokenize import WordPunctTokenizer\n",
    "from nltk.corpus import stopwords\n",
    "from sklearn.feature_extraction.text import TfidfVectorizer\n",
    "from sklearn.cluster import KMeans"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "9db889ac-f811-49e5-82cb-327cfd9b8433",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "[nltk_data] Downloading package stopwords to /home/nanny/nltk_data...\n",
      "[nltk_data]   Package stopwords is already up-to-date!\n",
      "[nltk_data] Downloading package rslp to /home/nanny/nltk_data...\n",
      "[nltk_data]   Unzipping stemmers/rslp.zip.\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from nltk import download as nltkd\n",
    "nltkd('stopwords')\n",
    "nltkd('rslp')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "6c247fce-6ca8-4ee5-b814-849a62214d20",
   "metadata": {},
   "outputs": [],
   "source": [
    "token_pontuacao = WordPunctTokenizer()\n",
    "palavras_irrelevantes = stopwords.words(\"portuguese\")\n",
    "stemmer = RSLPStemmer()\n",
    "stopwords_sem_acento = [unidecode.unidecode(texto) for texto in ([ponto for ponto in punctuation] + palavras_irrelevantes)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "7c2eac21-93aa-43f3-93f3-ffc5aa0722de",
   "metadata": {},
   "outputs": [],
   "source": [
    "def tratamento(coluna_texto):\n",
    "    frase_processada = list()\n",
    "    for opiniao in coluna_texto:\n",
    "        nova_frase = list()\n",
    "        palavras_texto = token_pontuacao.tokenize(\n",
    "            unidecode.unidecode(str(opiniao).lower()))\n",
    "        for palavra in palavras_texto:\n",
    "            if palavra not in stopwords_sem_acento:\n",
    "                nova_frase.append(stemmer.stem(palavra))\n",
    "        frase_processada.append(' '.join(nova_frase))\n",
    "    return frase_processada"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "d73afe2d-b6f6-4565-afff-290918c7143a",
   "metadata": {},
   "outputs": [],
   "source": [
    "df= pd.read_excel(\"evt_202212201043.xlsx\", engine='openpyxl')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "5900b2ca-12b3-455c-bd7d-09b144c0e362",
   "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>EVENTO</th>\n",
       "      <th>DSC_EVT</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1127</th>\n",
       "      <td>2022/253561</td>\n",
       "      <td>Tais Login por cpf da funcionária  - CNPJ 1090...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>604</th>\n",
       "      <td>2022/247094</td>\n",
       "      <td>Mensageria: Protocolo: 2022/13763 - Duvidas so...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1272</th>\n",
       "      <td>2022/255122</td>\n",
       "      <td>Atendimento por e-mail\\nSr. Alef Alves\\nFwd: B...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           EVENTO                                            DSC_EVT\n",
       "1127  2022/253561  Tais Login por cpf da funcionária  - CNPJ 1090...\n",
       "604   2022/247094  Mensageria: Protocolo: 2022/13763 - Duvidas so...\n",
       "1272  2022/255122  Atendimento por e-mail\\nSr. Alef Alves\\nFwd: B..."
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sample(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "fde1b0ae-94f4-4c72-a627-122755dbe4a8",
   "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</th>\n",
       "      <th>texto</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>2022/240012</td>\n",
       "      <td>Info sobre confirmação de pedido de compra. CN...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1938</th>\n",
       "      <td>2022/263739</td>\n",
       "      <td>Atendimento via Teams - Sr. Leandro Santana de...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>2022/240421</td>\n",
       "      <td>Fornecedor informou que não conseguiu realizar...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               id                                              texto\n",
       "128   2022/240012  Info sobre confirmação de pedido de compra. CN...\n",
       "1938  2022/263739  Atendimento via Teams - Sr. Leandro Santana de...\n",
       "154   2022/240421  Fornecedor informou que não conseguiu realizar..."
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.rename(columns={\"EVENTO\":\"id\",\"DSC_EVT\":\"texto\"}, inplace=True)\n",
    "df.sample(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "10b36983-567a-4009-b7c6-87eb1d3279f9",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['pre'] = tratamento(df['texto'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "0193e18c-54e0-4bac-9070-a2590c735c70",
   "metadata": {},
   "outputs": [],
   "source": [
    "vetor_tfidf = TfidfVectorizer(lowercase=False, ngram_range=(1, 2)).fit_transform(df['pre'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "35c45565-e427-4759-bb1c-9f9d821683a7",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['cat'] = KMeans(n_clusters=4, verbose=False).fit(vetor_tfidf).predict(vetor_tfidf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "18fceffa-ca2a-4d39-b74a-0d7fae4a4672",
   "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</th>\n",
       "      <th>texto</th>\n",
       "      <th>cat</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1259</th>\n",
       "      <td>2022/255000</td>\n",
       "      <td>Atendimento  Telefônico\\nSra. Paula - (11) 972...</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>584</th>\n",
       "      <td>2022/246923</td>\n",
       "      <td>DÚVIDA - PARCELA/COMPETÊNCIA PORTAL DO FORNECE...</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1508</th>\n",
       "      <td>2022/258063</td>\n",
       "      <td>Dúvidas sobre o recebimento de e-mail da Gefor...</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1608</th>\n",
       "      <td>2022/258855</td>\n",
       "      <td>Mensageria - Protocolo: 2022/51019\\nIndisponib...</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>809</th>\n",
       "      <td>2022/250517</td>\n",
       "      <td>Atendimento por e-mail\\nSolicitaram orientação...</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1552</th>\n",
       "      <td>2022/258392</td>\n",
       "      <td>upload de nota fiscal/SICAF</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>889</th>\n",
       "      <td>2022/251058</td>\n",
       "      <td>Atendimento por e-mail\\nBB/ GEFOR 34 - Balanço...</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1272</th>\n",
       "      <td>2022/255122</td>\n",
       "      <td>Atendimento por e-mail\\nSr. Alef Alves\\nFwd: B...</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217</th>\n",
       "      <td>2022/241224</td>\n",
       "      <td>Atendimento Telefônico - Sr. Luiz - (91) 98331...</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>838</th>\n",
       "      <td>2022/250647</td>\n",
       "      <td>balanço Patrimonial - questiona a qual contrat...</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>812</th>\n",
       "      <td>2022/250522</td>\n",
       "      <td>Atendimento por e-mail\\nEnvio de Balanço Patri...</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>675</th>\n",
       "      <td>2022/248198</td>\n",
       "      <td>Re: BB GEFOR 34/IMOB – ERRO CADASTRAMENTO PORT...</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1450</th>\n",
       "      <td>2022/257430</td>\n",
       "      <td>Atendimento telefônico: 37 99875-1848\\nQuaesti...</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>359</th>\n",
       "      <td>2022/243502</td>\n",
       "      <td>Atendimento Telefônico - Sr Leonardo - (31) 32...</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2284</th>\n",
       "      <td>2022/269946</td>\n",
       "      <td>Atendimento por e-mail\\nSra. Erica Vieira\\nInf...</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2027</th>\n",
       "      <td>2022/265157</td>\n",
       "      <td>Atendimento Telefônico\\nSr. Lucas - (21) 99183...</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2162</th>\n",
       "      <td>2022/267933</td>\n",
       "      <td>Atendimento por e-mail\\nO fornecedor solicitou...</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1955</th>\n",
       "      <td>2022/264150</td>\n",
       "      <td>upload de nota fiscal</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1657</th>\n",
       "      <td>2022/259503</td>\n",
       "      <td>Atendimento Telefônico\\nSra. Thais - (35) 9881...</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1548</th>\n",
       "      <td>2022/258379</td>\n",
       "      <td>Atendimento telefônico:  46 99912-1240\\nQuesti...</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               id                                              texto  cat\n",
       "1259  2022/255000  Atendimento  Telefônico\\nSra. Paula - (11) 972...    0\n",
       "584   2022/246923  DÚVIDA - PARCELA/COMPETÊNCIA PORTAL DO FORNECE...    0\n",
       "1508  2022/258063  Dúvidas sobre o recebimento de e-mail da Gefor...    0\n",
       "1608  2022/258855  Mensageria - Protocolo: 2022/51019\\nIndisponib...    0\n",
       "809   2022/250517  Atendimento por e-mail\\nSolicitaram orientação...    0\n",
       "1552  2022/258392                        upload de nota fiscal/SICAF    0\n",
       "889   2022/251058  Atendimento por e-mail\\nBB/ GEFOR 34 - Balanço...    0\n",
       "1272  2022/255122  Atendimento por e-mail\\nSr. Alef Alves\\nFwd: B...    0\n",
       "217   2022/241224  Atendimento Telefônico - Sr. Luiz - (91) 98331...    0\n",
       "838   2022/250647  balanço Patrimonial - questiona a qual contrat...    0\n",
       "812   2022/250522  Atendimento por e-mail\\nEnvio de Balanço Patri...    0\n",
       "675   2022/248198  Re: BB GEFOR 34/IMOB – ERRO CADASTRAMENTO PORT...    0\n",
       "1450  2022/257430  Atendimento telefônico: 37 99875-1848\\nQuaesti...    0\n",
       "359   2022/243502  Atendimento Telefônico - Sr Leonardo - (31) 32...    0\n",
       "2284  2022/269946  Atendimento por e-mail\\nSra. Erica Vieira\\nInf...    0\n",
       "2027  2022/265157  Atendimento Telefônico\\nSr. Lucas - (21) 99183...    0\n",
       "2162  2022/267933  Atendimento por e-mail\\nO fornecedor solicitou...    0\n",
       "1955  2022/264150                              upload de nota fiscal    0\n",
       "1657  2022/259503  Atendimento Telefônico\\nSra. Thais - (35) 9881...    0\n",
       "1548  2022/258379  Atendimento telefônico:  46 99912-1240\\nQuesti...    0"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['cat']==0][['id','texto','cat']].sample(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "50c6a99e-ad70-433d-b82f-c4619e33a5da",
   "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</th>\n",
       "      <th>texto</th>\n",
       "      <th>cat</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1604</th>\n",
       "      <td>2022/258766</td>\n",
       "      <td>NF eletrônica enviada via e-mail</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1212</th>\n",
       "      <td>2022/254586</td>\n",
       "      <td>assinatura contrato 202274213787 - signatário ...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1127</th>\n",
       "      <td>2022/253561</td>\n",
       "      <td>Tais Login por cpf da funcionária  - CNPJ 1090...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023</th>\n",
       "      <td>2022/265105</td>\n",
       "      <td>Vinicius - CNPJ 01.451.373/0001-41    Contrato...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>594</th>\n",
       "      <td>2022/247038</td>\n",
       "      <td>Fluxo cancelado - cadastrado incorretamente</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1433</th>\n",
       "      <td>2022/257079</td>\n",
       "      <td>Atendimento por e-mail\\nRe: ACEITE - Contrato ...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>520</th>\n",
       "      <td>2022/245638</td>\n",
       "      <td>RES: MANUAL DE INCLUSÃO DE NOTAS E PLANILHA DE...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>2022/239253</td>\n",
       "      <td>Auxilio cadastro e envio NF. CNPJ. .: 30.092.8...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1354</th>\n",
       "      <td>2022/256238</td>\n",
       "      <td>Fernanda CNPJ 44652512000108 problema no doc p...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>2022/239754</td>\n",
       "      <td>Envio NF. CNPJ. .: 05.607.266/0001-10   \\n</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               id                                              texto  cat\n",
       "1604  2022/258766                   NF eletrônica enviada via e-mail    1\n",
       "1212  2022/254586  assinatura contrato 202274213787 - signatário ...    1\n",
       "1127  2022/253561  Tais Login por cpf da funcionária  - CNPJ 1090...    1\n",
       "2023  2022/265105  Vinicius - CNPJ 01.451.373/0001-41    Contrato...    1\n",
       "594   2022/247038        Fluxo cancelado - cadastrado incorretamente    1\n",
       "1433  2022/257079  Atendimento por e-mail\\nRe: ACEITE - Contrato ...    1\n",
       "520   2022/245638  RES: MANUAL DE INCLUSÃO DE NOTAS E PLANILHA DE...    1\n",
       "75    2022/239253  Auxilio cadastro e envio NF. CNPJ. .: 30.092.8...    1\n",
       "1354  2022/256238  Fernanda CNPJ 44652512000108 problema no doc p...    1\n",
       "107   2022/239754         Envio NF. CNPJ. .: 05.607.266/0001-10   \\n    1"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['cat']==1][['id','texto','cat']].sample(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "855354f7-71f6-435e-a94f-ce47934a8daf",
   "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</th>\n",
       "      <th>texto</th>\n",
       "      <th>cat</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>924</th>\n",
       "      <td>2022/251608</td>\n",
       "      <td>Balanço Patrimonial</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>878</th>\n",
       "      <td>2022/250981</td>\n",
       "      <td>balanço patrimonial/ orientações envio</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>844</th>\n",
       "      <td>2022/250653</td>\n",
       "      <td>Balanço Patrimonial</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>852</th>\n",
       "      <td>2022/250672</td>\n",
       "      <td>Atendimento por e-mail\\nENC: BB/ GEFOR 34 - Ba...</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>848</th>\n",
       "      <td>2022/250665</td>\n",
       "      <td>Atendimento por e-mail\\nFwd: Fwd: BB/ GEFOR 34...</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>837</th>\n",
       "      <td>2022/250646</td>\n",
       "      <td>Balanço Patrimonial</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>853</th>\n",
       "      <td>2022/250673</td>\n",
       "      <td>Atendimento telefônico realizado em 12.05.2022...</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1081</th>\n",
       "      <td>2022/252970</td>\n",
       "      <td>Balanço Patrimonial - upload da NF - Marcos - ...</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>880</th>\n",
       "      <td>2022/250986</td>\n",
       "      <td>confirmação envio balanço Patrimonial</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>824</th>\n",
       "      <td>2022/250563</td>\n",
       "      <td>Atendimento Telefônico\\nSr. Fabricio - (99) 98...</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               id                                              texto  cat\n",
       "924   2022/251608                                Balanço Patrimonial    2\n",
       "878   2022/250981             balanço patrimonial/ orientações envio    2\n",
       "844   2022/250653                                Balanço Patrimonial    2\n",
       "852   2022/250672  Atendimento por e-mail\\nENC: BB/ GEFOR 34 - Ba...    2\n",
       "848   2022/250665  Atendimento por e-mail\\nFwd: Fwd: BB/ GEFOR 34...    2\n",
       "837   2022/250646                                Balanço Patrimonial    2\n",
       "853   2022/250673  Atendimento telefônico realizado em 12.05.2022...    2\n",
       "1081  2022/252970  Balanço Patrimonial - upload da NF - Marcos - ...    2\n",
       "880   2022/250986              confirmação envio balanço Patrimonial    2\n",
       "824   2022/250563  Atendimento Telefônico\\nSr. Fabricio - (99) 98...    2"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['cat']==2][['id','texto','cat']].sample(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "0735af25-d97f-40c1-ad19-51d123546db0",
   "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</th>\n",
       "      <th>texto</th>\n",
       "      <th>cat</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1336</th>\n",
       "      <td>2022/256068</td>\n",
       "      <td>pagamento NF contrato 201974218057</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1313</th>\n",
       "      <td>2022/255865</td>\n",
       "      <td>emissão e pagamento de NF</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>801</th>\n",
       "      <td>2022/250328</td>\n",
       "      <td>emissão de NF</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778</th>\n",
       "      <td>2022/250053</td>\n",
       "      <td>erro upload NF</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1243</th>\n",
       "      <td>2022/254852</td>\n",
       "      <td>upload de NF</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>526</th>\n",
       "      <td>2022/245728</td>\n",
       "      <td>envio de NF - contrato 201785580039</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1328</th>\n",
       "      <td>2022/255964</td>\n",
       "      <td>Pagamento de NF contrato 202074217676</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>407</th>\n",
       "      <td>2022/243820</td>\n",
       "      <td>envio de nf</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>411</th>\n",
       "      <td>2022/243832</td>\n",
       "      <td>envio de NF/ instabilidade no Portal</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>706</th>\n",
       "      <td>2022/248854</td>\n",
       "      <td>pagamento de NF</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               id                                  texto  cat\n",
       "1336  2022/256068     pagamento NF contrato 201974218057    3\n",
       "1313  2022/255865              emissão e pagamento de NF    3\n",
       "801   2022/250328                          emissão de NF    3\n",
       "778   2022/250053                         erro upload NF    3\n",
       "1243  2022/254852                           upload de NF    3\n",
       "526   2022/245728    envio de NF - contrato 201785580039    3\n",
       "1328  2022/255964  Pagamento de NF contrato 202074217676    3\n",
       "407   2022/243820                            envio de nf    3\n",
       "411   2022/243832   envio de NF/ instabilidade no Portal    3\n",
       "706   2022/248854                        pagamento de NF    3"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['cat']==3][['id','texto','cat']].sample(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "ba0f10c5-39d0-406d-82fe-6413f6f1f6dd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2    1923\n",
       "0     307\n",
       "1      89\n",
       "3      64\n",
       "Name: cat, dtype: int64"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['cat'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "8a78e777-60d6-4dad-9a4c-e821e18fbe99",
   "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.6.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}