PsyCare.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "toc_visible": true,
      "authorship_tag": "ABX9TyPzXQ2ClZQq7+6SKmryWxOW",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/augusto1jr/PsyCare-Backend/blob/main/PsyCare.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# **Imports**"
      ],
      "metadata": {
        "id": "me8gJ91Tb5rf"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "!pip install scikit-surprise &> /dev/null"
      ],
      "metadata": {
        "id": "pV5W0KR-gM4V"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "9DkJqbThv8IB"
      },
      "outputs": [],
      "source": [
        "import pandas as pd\n",
        "import numpy as np\n",
        "import random"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Recomendação Baseada em Conteúdo\n",
        "from sklearn.feature_extraction.text import TfidfVectorizer\n",
        "from sklearn.feature_extraction.text import CountVectorizer\n",
        "from sklearn.metrics.pairwise import linear_kernel"
      ],
      "metadata": {
        "id": "AkZbOi5E2kYw"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Recomendação Baseada em Filtro Colaborativo\n",
        "from surprise import Reader, Dataset, SVD\n",
        "from surprise.accuracy import rmse, mae\n",
        "from surprise.model_selection import cross_validate\n",
        "from collections import defaultdict"
      ],
      "metadata": {
        "id": "XnVr6UL_f4lf"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "**Os dados a seguir foram obtidos por meio de um scraper [Acesso disponível em: <https://github.com/augusto1jr/PsyCare-Scraping>] que extraiu os dados da plataforma Psicologia Viva [Acesso disponível em: <https://www.psicologiaviva.com.br/>].**"
      ],
      "metadata": {
        "id": "7vz2XLpITj-0"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Criando o dataframe que vai armazenar os dados dos psicólogos\n",
        "psychologists = pd.read_csv('https://raw.githubusercontent.com/augusto1jr/PsyCare-Backend/main/psychologists.csv', low_memory=False)"
      ],
      "metadata": {
        "id": "JLdfKnKR1FxV"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "Preenche com 'None' os dados não essenciais para os fins do projeto."
      ],
      "metadata": {
        "id": "UkVP2e_ZoIxi"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "psychologists = psychologists.fillna('None')"
      ],
      "metadata": {
        "id": "i-3jl-uoLjL_"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "As informações estão divididas em: **name** (nome do psicólogo), **bio** (biografia escrita pelo psicólogo), **expertises** (transtornos e\n",
        "temáticas que o psicólogo possui expertise para oferecer tratamento), **total_ratings** (número total de avaliações recebidas pelo psicólogo), **average_rating** (nota média do psicólogo na plataforma)."
      ],
      "metadata": {
        "id": "gZ0wjmhHV1TA"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "psychologists"
      ],
      "metadata": {
        "id": "bdf1d5h32w-h",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "outputId": "83dd29d4-1850-4f71-b09c-434915dd28c6"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                          name  \\\n",
              "0     Eliane Aguiar Monteiro Marques Cerchiari   \n",
              "1                     Rafael Cristiano Batista   \n",
              "2         Jhennifer Campos Lubanco de Barcelos   \n",
              "3                         Gustavo Simões Ramos   \n",
              "4                               Fernanda Dudek   \n",
              "...                                        ...   \n",
              "1024     Mariana Lima Cavalcante Gaia do Couto   \n",
              "1025                   Francielly Ap Inocencio   \n",
              "1026             Thais De Vincenzo Schultheisz   \n",
              "1027                 Lucas Ranyere Alves Costa   \n",
              "1028                             Monielle Lima   \n",
              "\n",
              "                                                    bio  \\\n",
              "0     Olá! Como vc está?, Meu nome é Eliane e sou ps...   \n",
              "1     Olá, Como você está?, , Primeiramente, quero d...   \n",
              "2     Olá, bem vindo(a) ao meu perfil aqui na Psicol...   \n",
              "3     Oi, me chamo Gustavo! Estou disponível para at...   \n",
              "4     Você que chegou até meu perfil, seja muito bem...   \n",
              "...                                                 ...   \n",
              "1024  Me chamo Mariana e sou Psicóloga pela PUC-Rio....   \n",
              "1025  Meu nome é Francielly Inocencio, tenho 33 anos...   \n",
              "1026  Sou Dra. em Psicologia da Saúde. Atuo há mais ...   \n",
              "1027  Viver não é fácil, eu sei e você também sabe, ...   \n",
              "1028  \"Olá! Sou Monielle Lima, psicóloga apaixonada ...   \n",
              "\n",
              "                                             expertises  total_ratings  \\\n",
              "0     Acompanhamento pessoal, Ansiedade, Conflitos A...            269   \n",
              "1     Ansiedade, Casal, Casamento, Compulsões, Confl...            111   \n",
              "2     Acompanhamento psicológico de Gravidez, Ansied...             94   \n",
              "3     Ansiedade, Casamento, Conflitos Amorosos, Conf...            174   \n",
              "4     Acompanhamento psicológico de Gravidez, Acompa...             55   \n",
              "...                                                 ...            ...   \n",
              "1024  Ansiedade, Compulsões, Conflitos Amorosos, Con...              2   \n",
              "1025  Ansiedade, Casal, Conflitos Amorosos, Conflito...              4   \n",
              "1026  Ansiedade, Depressão, Dor, Estresse, Família, ...            332   \n",
              "1027  Ansiedade, Conflitos Amorosos, Conflitos Famil...            120   \n",
              "1028  Acompanhamento psicológico de idosos, Ansiedad...             50   \n",
              "\n",
              "      avarage_rating  \n",
              "0           5.000000  \n",
              "1           4.783784  \n",
              "2           4.968085  \n",
              "3           4.988506  \n",
              "4           5.000000  \n",
              "...              ...  \n",
              "1024        5.000000  \n",
              "1025        5.000000  \n",
              "1026        4.716867  \n",
              "1027        4.975000  \n",
              "1028        4.920000  \n",
              "\n",
              "[1029 rows x 5 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-b5c03e7f-1770-48c1-9ea6-2839ef7c6491\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>name</th>\n",
              "      <th>bio</th>\n",
              "      <th>expertises</th>\n",
              "      <th>total_ratings</th>\n",
              "      <th>avarage_rating</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Eliane Aguiar Monteiro Marques Cerchiari</td>\n",
              "      <td>Olá! Como vc está?, Meu nome é Eliane e sou ps...</td>\n",
              "      <td>Acompanhamento pessoal, Ansiedade, Conflitos A...</td>\n",
              "      <td>269</td>\n",
              "      <td>5.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Rafael Cristiano Batista</td>\n",
              "      <td>Olá, Como você está?, , Primeiramente, quero d...</td>\n",
              "      <td>Ansiedade, Casal, Casamento, Compulsões, Confl...</td>\n",
              "      <td>111</td>\n",
              "      <td>4.783784</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Jhennifer Campos Lubanco de Barcelos</td>\n",
              "      <td>Olá, bem vindo(a) ao meu perfil aqui na Psicol...</td>\n",
              "      <td>Acompanhamento psicológico de Gravidez, Ansied...</td>\n",
              "      <td>94</td>\n",
              "      <td>4.968085</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Gustavo Simões Ramos</td>\n",
              "      <td>Oi, me chamo Gustavo! Estou disponível para at...</td>\n",
              "      <td>Ansiedade, Casamento, Conflitos Amorosos, Conf...</td>\n",
              "      <td>174</td>\n",
              "      <td>4.988506</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Fernanda Dudek</td>\n",
              "      <td>Você que chegou até meu perfil, seja muito bem...</td>\n",
              "      <td>Acompanhamento psicológico de Gravidez, Acompa...</td>\n",
              "      <td>55</td>\n",
              "      <td>5.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1024</th>\n",
              "      <td>Mariana Lima Cavalcante Gaia do Couto</td>\n",
              "      <td>Me chamo Mariana e sou Psicóloga pela PUC-Rio....</td>\n",
              "      <td>Ansiedade, Compulsões, Conflitos Amorosos, Con...</td>\n",
              "      <td>2</td>\n",
              "      <td>5.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1025</th>\n",
              "      <td>Francielly Ap Inocencio</td>\n",
              "      <td>Meu nome é Francielly Inocencio, tenho 33 anos...</td>\n",
              "      <td>Ansiedade, Casal, Conflitos Amorosos, Conflito...</td>\n",
              "      <td>4</td>\n",
              "      <td>5.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1026</th>\n",
              "      <td>Thais De Vincenzo Schultheisz</td>\n",
              "      <td>Sou Dra. em Psicologia da Saúde. Atuo há mais ...</td>\n",
              "      <td>Ansiedade, Depressão, Dor, Estresse, Família, ...</td>\n",
              "      <td>332</td>\n",
              "      <td>4.716867</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1027</th>\n",
              "      <td>Lucas Ranyere Alves Costa</td>\n",
              "      <td>Viver não é fácil, eu sei e você também sabe, ...</td>\n",
              "      <td>Ansiedade, Conflitos Amorosos, Conflitos Famil...</td>\n",
              "      <td>120</td>\n",
              "      <td>4.975000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1028</th>\n",
              "      <td>Monielle Lima</td>\n",
              "      <td>\"Olá! Sou Monielle Lima, psicóloga apaixonada ...</td>\n",
              "      <td>Acompanhamento psicológico de idosos, Ansiedad...</td>\n",
              "      <td>50</td>\n",
              "      <td>4.920000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1029 rows × 5 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-b5c03e7f-1770-48c1-9ea6-2839ef7c6491')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-b5c03e7f-1770-48c1-9ea6-2839ef7c6491 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-b5c03e7f-1770-48c1-9ea6-2839ef7c6491');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-1bae56ea-31f4-4bf5-97de-b82f00216fe2\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-1bae56ea-31f4-4bf5-97de-b82f00216fe2')\"\n",
              "            title=\"Suggest charts.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "    background-color: #E8F0FE;\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: #1967D2;\n",
              "    height: 32px;\n",
              "    padding: 0 0 0 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart:hover {\n",
              "    background-color: #434B5C;\n",
              "    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "    fill: #FFFFFF;\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const charts = await google.colab.kernel.invokeFunction(\n",
              "          'suggestCharts', [key], {});\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-1bae56ea-31f4-4bf5-97de-b82f00216fe2 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# **Recomendação Baseada em Conteúdo**"
      ],
      "metadata": {
        "id": "VKqnRyhQzthp"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "Nesse cenário o algoritmo TF-IDF foi aplicado no campo *expertises* (especialidades de tratamento do psicólogo), criando uma matriz de similaridade que permite identificar o grau de similaridade entre os psicólogos da base de dados."
      ],
      "metadata": {
        "id": "7uwuJDKu4TsM"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "A partir disso é possível localizar um psicólogo na matriz de similaridade, e então ordenar os psicólogos com maior grau de similaridade para com o psicólogo em questão e exibir a recomendação gerada.\n"
      ],
      "metadata": {
        "id": "2dmr0aCD4Ufn"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "def Recomendacao_Baseada_Conteudo_Nome(name):\n",
        "  # Calcula a matriz de similaridades entre os psicólogos\n",
        "  vectorizer = TfidfVectorizer()\n",
        "  similarities_matrix = vectorizer.fit_transform(psychologists['expertises'])\n",
        "  similarity = linear_kernel(similarities_matrix, similarities_matrix)\n",
        "\n",
        "  # Encontra o Psicólogo pelo nome\n",
        "  psychologist = psychologists.loc[psychologists['name']==name]\n",
        "\n",
        "  # Determina a similaridade relativa ao psicólogo em questão\n",
        "  psy_similarity = list(enumerate(similarity[psychologist.index[0]]))\n",
        "\n",
        "  # Recria a base de dados com o campo de similaridade anterior\n",
        "  similar_psychologists = psychologists.copy()\n",
        "  similar_psychologists['similarity'] = pd.Series(psy_similarity).apply(lambda x: x[1])\n",
        "\n",
        "  # Ordena os psicólogos com maior similaridade em relação ao psicólogo em questão\n",
        "  recommendations = sorted(psy_similarity, key=lambda x: x[1], reverse=True)\n",
        "\n",
        "  # Seleciona os 10 psicólogos mais semelhantes\n",
        "  '''O psicólogo de índice 0 é \"pulado\" pois sempre será o psicólogo em questão\n",
        "  cujo se deseja estabelecer a similaridade aos outros (haverá 100% de similaridade com ele)'''\n",
        "  recommendations = recommendations[1:11]\n",
        "\n",
        "  # Seleciona os índices dos 10 psicólogos mais semelhantes\n",
        "  recommendations_indexes = [i[0] for i in recommendations]\n",
        "\n",
        "  # Retorna os 10 psicólogos mais semelhantes\n",
        "  return similar_psychologists.iloc[recommendations_indexes]"
      ],
      "metadata": {
        "id": "coZjVp7azzh2"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "Recomendacao_Baseada_Conteudo_Nome('Rafael Cristiano Batista')"
      ],
      "metadata": {
        "id": "63giEA4S2M4p",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 363
        },
        "outputId": "0c167043-4f2e-40ae-99a3-895020733537"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                              name  \\\n",
              "764   Amanda Caldas Cunha Cordeiro   \n",
              "168            Karine Vieira Matos   \n",
              "564                    Karen Gomes   \n",
              "447               Monique Carvalho   \n",
              "324                 Tatiane Macedo   \n",
              "59         Lainá Ferreira de Souza   \n",
              "21     VITOR JUNIOR DA SILVA PINTO   \n",
              "669  Márcia Maria Tavares de Souza   \n",
              "702                   Ester Salema   \n",
              "254                 Isabela Mendes   \n",
              "\n",
              "                                                   bio  \\\n",
              "764  Olá, seja bem-vindo(a) ao meu perfil! Meu nome...   \n",
              "168  Olá,, Meu nome é Karine, conhecida como Ká! So...   \n",
              "564  Como psicóloga clínica, minha busca esta na re...   \n",
              "447  Olá, como você está?, , Se você chegou até aqu...   \n",
              "324  Você sente que trabalha muito e não consegue o...   \n",
              "59   Olá, seja bem vindo (a) ao meu perfil! Estou a...   \n",
              "21   Olá, seja bem-vindo(a)! Se você chegou até o m...   \n",
              "669  Atendimento Clínico Autoconhecimento-o ser int...   \n",
              "702  Olá, tudo bem? Seja bem vindo (a) ao meu consu...   \n",
              "254  Olá! Seja bem vinda (o), auxilio pessoas a lid...   \n",
              "\n",
              "                                            expertises  total_ratings  \\\n",
              "764  Acompanhamento pessoal, Ansiedade, Conflitos A...             46   \n",
              "168  Ansiedade, Conflitos Amorosos, Depressão, Dese...              1   \n",
              "564  Acompanhamento pessoal, Ansiedade, Compulsões,...             26   \n",
              "447  Ansiedade, Casal, Casamento, Conflitos Amoroso...             91   \n",
              "324  Acompanhamento pessoal, Ansiedade, Casal, Conf...             45   \n",
              "59   Acompanhamento psicológico de idosos, Ansiedad...            498   \n",
              "21   Ansiedade, Conflitos Amorosos, Conflitos Famil...              0   \n",
              "669  Conflitos Familiares, Desenvolvimento Pessoal,...             28   \n",
              "702  Acompanhamento pessoal, Ansiedade, Casamento, ...             79   \n",
              "254  Ansiedade, Casal, Conflitos Amorosos, Conflito...             80   \n",
              "\n",
              "     avarage_rating  similarity  \n",
              "764        5.000000    0.666882  \n",
              "168        5.000000    0.641843  \n",
              "564        5.000000    0.631617  \n",
              "447        4.978022    0.606228  \n",
              "324        5.000000    0.598624  \n",
              "59         5.000000    0.598369  \n",
              "21         0.000000    0.593656  \n",
              "669        5.000000    0.593461  \n",
              "702        5.000000    0.584010  \n",
              "254        4.937500    0.581982  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-aaf9ea14-d4d7-4054-a502-35048cfb4e63\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>name</th>\n",
              "      <th>bio</th>\n",
              "      <th>expertises</th>\n",
              "      <th>total_ratings</th>\n",
              "      <th>avarage_rating</th>\n",
              "      <th>similarity</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>764</th>\n",
              "      <td>Amanda Caldas Cunha Cordeiro</td>\n",
              "      <td>Olá, seja bem-vindo(a) ao meu perfil! Meu nome...</td>\n",
              "      <td>Acompanhamento pessoal, Ansiedade, Conflitos A...</td>\n",
              "      <td>46</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>0.666882</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>168</th>\n",
              "      <td>Karine Vieira Matos</td>\n",
              "      <td>Olá,, Meu nome é Karine, conhecida como Ká! So...</td>\n",
              "      <td>Ansiedade, Conflitos Amorosos, Depressão, Dese...</td>\n",
              "      <td>1</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>0.641843</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>564</th>\n",
              "      <td>Karen Gomes</td>\n",
              "      <td>Como psicóloga clínica, minha busca esta na re...</td>\n",
              "      <td>Acompanhamento pessoal, Ansiedade, Compulsões,...</td>\n",
              "      <td>26</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>0.631617</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>447</th>\n",
              "      <td>Monique Carvalho</td>\n",
              "      <td>Olá, como você está?, , Se você chegou até aqu...</td>\n",
              "      <td>Ansiedade, Casal, Casamento, Conflitos Amoroso...</td>\n",
              "      <td>91</td>\n",
              "      <td>4.978022</td>\n",
              "      <td>0.606228</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>324</th>\n",
              "      <td>Tatiane Macedo</td>\n",
              "      <td>Você sente que trabalha muito e não consegue o...</td>\n",
              "      <td>Acompanhamento pessoal, Ansiedade, Casal, Conf...</td>\n",
              "      <td>45</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>0.598624</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>59</th>\n",
              "      <td>Lainá Ferreira de Souza</td>\n",
              "      <td>Olá, seja bem vindo (a) ao meu perfil! Estou a...</td>\n",
              "      <td>Acompanhamento psicológico de idosos, Ansiedad...</td>\n",
              "      <td>498</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>0.598369</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>VITOR JUNIOR DA SILVA PINTO</td>\n",
              "      <td>Olá, seja bem-vindo(a)! Se você chegou até o m...</td>\n",
              "      <td>Ansiedade, Conflitos Amorosos, Conflitos Famil...</td>\n",
              "      <td>0</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.593656</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>669</th>\n",
              "      <td>Márcia Maria Tavares de Souza</td>\n",
              "      <td>Atendimento Clínico Autoconhecimento-o ser int...</td>\n",
              "      <td>Conflitos Familiares, Desenvolvimento Pessoal,...</td>\n",
              "      <td>28</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>0.593461</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>702</th>\n",
              "      <td>Ester Salema</td>\n",
              "      <td>Olá, tudo bem? Seja bem vindo (a) ao meu consu...</td>\n",
              "      <td>Acompanhamento pessoal, Ansiedade, Casamento, ...</td>\n",
              "      <td>79</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>0.584010</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>254</th>\n",
              "      <td>Isabela Mendes</td>\n",
              "      <td>Olá! Seja bem vinda (o), auxilio pessoas a lid...</td>\n",
              "      <td>Ansiedade, Casal, Conflitos Amorosos, Conflito...</td>\n",
              "      <td>80</td>\n",
              "      <td>4.937500</td>\n",
              "      <td>0.581982</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-aaf9ea14-d4d7-4054-a502-35048cfb4e63')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-aaf9ea14-d4d7-4054-a502-35048cfb4e63 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-aaf9ea14-d4d7-4054-a502-35048cfb4e63');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-16169012-9ba0-49c6-8c16-195ffd71f841\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-16169012-9ba0-49c6-8c16-195ffd71f841')\"\n",
              "            title=\"Suggest charts.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "    background-color: #E8F0FE;\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: #1967D2;\n",
              "    height: 32px;\n",
              "    padding: 0 0 0 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart:hover {\n",
              "    background-color: #434B5C;\n",
              "    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "    fill: #FFFFFF;\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const charts = await google.colab.kernel.invokeFunction(\n",
              "          'suggestCharts', [key], {});\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-16169012-9ba0-49c6-8c16-195ffd71f841 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "No exemplo acima a recomendação foi gerada ao estabelecer a similaridade entre um psicólogo em questão com relação à outros."
      ],
      "metadata": {
        "id": "StdjI6Xf4gfp"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "Além disso, também foi implementada uma outra forma de recomendação baseada em conteúdo que não necessita do parâmetro de um psicólogo. Nesse cenário, o usuário deve inserir alguns problemas que tem interesse em receber tratamento."
      ],
      "metadata": {
        "id": "_C3l3H3b4kkc"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "def Recomendacao_Baseada_Conteudo_Problemas(problems):\n",
        "  # Cria um Psicólogo temporário\n",
        "  '''Esse psicólogo possui como especialidades os problemas que o usuário\n",
        "  inseriu. Ele vai funcionar como um \"psicólogo ideal\" e servir como base\n",
        "  para encontrar o psicólogo mais semelhante com o que o usuário procura.'''\n",
        "  psychologists.loc[len(psychologists)] = ['temporary psychologist', None, problems, None, None]\n",
        "  temp_psychologist = psychologists.loc[psychologists['name']=='temporary psychologist']\n",
        "\n",
        "  # Calcula a matriz de similaridades entre os psicólogos\n",
        "  vectorizer = TfidfVectorizer()\n",
        "  similarities_matrix = vectorizer.fit_transform(psychologists['expertises'])\n",
        "  similarity = linear_kernel(similarities_matrix, similarities_matrix)\n",
        "\n",
        "  # Determina a similaridade relativa ao psicólogo em questão\n",
        "  psy_similarity = list(enumerate(similarity[temp_psychologist.index[0]]))\n",
        "\n",
        "  # Recria a base de dados com o campo de similaridade anterior\n",
        "  similar_psychologists = psychologists.copy()\n",
        "  similar_psychologists['similarity'] = pd.Series(psy_similarity).apply(lambda x: x[1])\n",
        "\n",
        "  # Ordena os psicólogos com maior similaridade em relação ao psicólogo em questão\n",
        "  recommendations = sorted(psy_similarity, key=lambda x: x[1], reverse=True)\n",
        "\n",
        "  # Seleciona os 10 psicólogos mais semelhantes\n",
        "  '''Nesse caso são incluídos 11 psicólogos pois o\n",
        "  psicólogo temporário será excluído posteriormente'''\n",
        "  recommendations = recommendations[0:11]\n",
        "\n",
        "  # Seleciona os índices dps 10 psicólogos mais semelhantes\n",
        "  recommendations_indexes = [i[0] for i in recommendations]\n",
        "\n",
        "  # Remove o psicólogo temporário\n",
        "  psychologists.drop(temp_psychologist.index, inplace=True)\n",
        "  recommendations_indexes.remove(temp_psychologist.index)\n",
        "\n",
        "  # Retorna os 10 psicólogos mais semelhantes\n",
        "  return similar_psychologists.iloc[recommendations_indexes]"
      ],
      "metadata": {
        "id": "LwiS-SzO2Ffe"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Nesse caso foram usados as especialidades (campo expertises) do psicólogo Rafael Cristiano Batista\n",
        "# com o objetivo de avaliar a precisão do algoritmo, que corretamente apresentou 1.0 (100%) de similaridade com o mesmo\n",
        "\n",
        "Recomendacao_Baseada_Conteudo_Problemas('Ansiedade, Casal, Casamento, Compulsões, Conflitos Amorosos, Conflitos Familiares, Dependência Química, Depressão, Desenvolvimento Pessoal, Estresse, Família, Orientação de pais, Orientação Profissional, Psicologia Clínica, Psicologia Organizacional, Saúde Mental, Violência Sexual, Sexualidade e identidade de gênero, Seleção de pessoal por competências, Sexualidade e Identidade de gênero, Maternidade, Paternidade')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 363
        },
        "id": "X5I0y3CK9ntT",
        "outputId": "dab44d76-8411-4f82-fe77-8420a0c62c87"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                              name  \\\n",
              "1         Rafael Cristiano Batista   \n",
              "764   Amanda Caldas Cunha Cordeiro   \n",
              "168            Karine Vieira Matos   \n",
              "564                    Karen Gomes   \n",
              "447               Monique Carvalho   \n",
              "59         Lainá Ferreira de Souza   \n",
              "324                 Tatiane Macedo   \n",
              "21     VITOR JUNIOR DA SILVA PINTO   \n",
              "669  Márcia Maria Tavares de Souza   \n",
              "702                   Ester Salema   \n",
              "\n",
              "                                                   bio  \\\n",
              "1    Olá, Como você está?, , Primeiramente, quero d...   \n",
              "764  Olá, seja bem-vindo(a) ao meu perfil! Meu nome...   \n",
              "168  Olá,, Meu nome é Karine, conhecida como Ká! So...   \n",
              "564  Como psicóloga clínica, minha busca esta na re...   \n",
              "447  Olá, como você está?, , Se você chegou até aqu...   \n",
              "59   Olá, seja bem vindo (a) ao meu perfil! Estou a...   \n",
              "324  Você sente que trabalha muito e não consegue o...   \n",
              "21   Olá, seja bem-vindo(a)! Se você chegou até o m...   \n",
              "669  Atendimento Clínico Autoconhecimento-o ser int...   \n",
              "702  Olá, tudo bem? Seja bem vindo (a) ao meu consu...   \n",
              "\n",
              "                                            expertises total_ratings  \\\n",
              "1    Ansiedade, Casal, Casamento, Compulsões, Confl...           111   \n",
              "764  Acompanhamento pessoal, Ansiedade, Conflitos A...            46   \n",
              "168  Ansiedade, Conflitos Amorosos, Depressão, Dese...             1   \n",
              "564  Acompanhamento pessoal, Ansiedade, Compulsões,...            26   \n",
              "447  Ansiedade, Casal, Casamento, Conflitos Amoroso...            91   \n",
              "59   Acompanhamento psicológico de idosos, Ansiedad...           498   \n",
              "324  Acompanhamento pessoal, Ansiedade, Casal, Conf...            45   \n",
              "21   Ansiedade, Conflitos Amorosos, Conflitos Famil...             0   \n",
              "669  Conflitos Familiares, Desenvolvimento Pessoal,...            28   \n",
              "702  Acompanhamento pessoal, Ansiedade, Casamento, ...            79   \n",
              "\n",
              "     avarage_rating  similarity  \n",
              "1          4.783784    1.000000  \n",
              "764        5.000000    0.666302  \n",
              "168        5.000000    0.641211  \n",
              "564        5.000000    0.630732  \n",
              "447        4.978022    0.606194  \n",
              "59         5.000000    0.599007  \n",
              "324        5.000000    0.597837  \n",
              "21         0.000000    0.594441  \n",
              "669        5.000000    0.592697  \n",
              "702        5.000000    0.583241  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-a20c481c-e269-4a4e-bc8a-cb1210d0f51a\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>name</th>\n",
              "      <th>bio</th>\n",
              "      <th>expertises</th>\n",
              "      <th>total_ratings</th>\n",
              "      <th>avarage_rating</th>\n",
              "      <th>similarity</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Rafael Cristiano Batista</td>\n",
              "      <td>Olá, Como você está?, , Primeiramente, quero d...</td>\n",
              "      <td>Ansiedade, Casal, Casamento, Compulsões, Confl...</td>\n",
              "      <td>111</td>\n",
              "      <td>4.783784</td>\n",
              "      <td>1.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>764</th>\n",
              "      <td>Amanda Caldas Cunha Cordeiro</td>\n",
              "      <td>Olá, seja bem-vindo(a) ao meu perfil! Meu nome...</td>\n",
              "      <td>Acompanhamento pessoal, Ansiedade, Conflitos A...</td>\n",
              "      <td>46</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>0.666302</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>168</th>\n",
              "      <td>Karine Vieira Matos</td>\n",
              "      <td>Olá,, Meu nome é Karine, conhecida como Ká! So...</td>\n",
              "      <td>Ansiedade, Conflitos Amorosos, Depressão, Dese...</td>\n",
              "      <td>1</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>0.641211</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>564</th>\n",
              "      <td>Karen Gomes</td>\n",
              "      <td>Como psicóloga clínica, minha busca esta na re...</td>\n",
              "      <td>Acompanhamento pessoal, Ansiedade, Compulsões,...</td>\n",
              "      <td>26</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>0.630732</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>447</th>\n",
              "      <td>Monique Carvalho</td>\n",
              "      <td>Olá, como você está?, , Se você chegou até aqu...</td>\n",
              "      <td>Ansiedade, Casal, Casamento, Conflitos Amoroso...</td>\n",
              "      <td>91</td>\n",
              "      <td>4.978022</td>\n",
              "      <td>0.606194</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>59</th>\n",
              "      <td>Lainá Ferreira de Souza</td>\n",
              "      <td>Olá, seja bem vindo (a) ao meu perfil! Estou a...</td>\n",
              "      <td>Acompanhamento psicológico de idosos, Ansiedad...</td>\n",
              "      <td>498</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>0.599007</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>324</th>\n",
              "      <td>Tatiane Macedo</td>\n",
              "      <td>Você sente que trabalha muito e não consegue o...</td>\n",
              "      <td>Acompanhamento pessoal, Ansiedade, Casal, Conf...</td>\n",
              "      <td>45</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>0.597837</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>VITOR JUNIOR DA SILVA PINTO</td>\n",
              "      <td>Olá, seja bem-vindo(a)! Se você chegou até o m...</td>\n",
              "      <td>Ansiedade, Conflitos Amorosos, Conflitos Famil...</td>\n",
              "      <td>0</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.594441</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>669</th>\n",
              "      <td>Márcia Maria Tavares de Souza</td>\n",
              "      <td>Atendimento Clínico Autoconhecimento-o ser int...</td>\n",
              "      <td>Conflitos Familiares, Desenvolvimento Pessoal,...</td>\n",
              "      <td>28</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>0.592697</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>702</th>\n",
              "      <td>Ester Salema</td>\n",
              "      <td>Olá, tudo bem? Seja bem vindo (a) ao meu consu...</td>\n",
              "      <td>Acompanhamento pessoal, Ansiedade, Casamento, ...</td>\n",
              "      <td>79</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>0.583241</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-a20c481c-e269-4a4e-bc8a-cb1210d0f51a')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-a20c481c-e269-4a4e-bc8a-cb1210d0f51a button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-a20c481c-e269-4a4e-bc8a-cb1210d0f51a');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-65b5ebcd-a6ba-4d76-b24b-99a9656225ab\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-65b5ebcd-a6ba-4d76-b24b-99a9656225ab')\"\n",
              "            title=\"Suggest charts.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "    background-color: #E8F0FE;\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: #1967D2;\n",
              "    height: 32px;\n",
              "    padding: 0 0 0 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart:hover {\n",
              "    background-color: #434B5C;\n",
              "    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "    fill: #FFFFFF;\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const charts = await google.colab.kernel.invokeFunction(\n",
              "          'suggestCharts', [key], {});\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-65b5ebcd-a6ba-4d76-b24b-99a9656225ab button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# **Recomendação Baseada em Filtragem Colaborativa**"
      ],
      "metadata": {
        "id": "atBYDZj0lpwy"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "**Os dados a seguir também foram obtidos por meio do mesmo scraper [Acesso disponível em: <https://github.com/augusto1jr/PsyCare-Scraping>] que extraiu os dados da plataforma Psicologia Viva [Acesso disponível em: <https://www.psicologiaviva.com.br/>].**"
      ],
      "metadata": {
        "id": "SOJICUy1JvJm"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "As informações estão divididas em: **patient** (paciente que realizou a avaliação), **psychologist** (psicólogo que recebeu a avaliação), **rating** (nota dada pelo paciente ao psicólogo)."
      ],
      "metadata": {
        "id": "iOD95Pjb4173"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Criando o dataframe que vai armazenar os dados de avaliações\n",
        "ratings = pd.read_csv('https://raw.githubusercontent.com/augusto1jr/PsyCare-Backend/main/ratings.csv', low_memory=False)"
      ],
      "metadata": {
        "id": "tpcx9TBIZ2Fd"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# O sistema de avaliações funciona com base em consultas\n",
        "# Dessa forma, um paciente pode avaliar diversas vezes o mesmo psicólogo\n",
        "# Portanto, é necessário remover as linhas que representam avaliações repetidas\n",
        "ratings = ratings.drop_duplicates()"
      ],
      "metadata": {
        "id": "URaGA1sk8yjR"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "ratings"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "KhDxrCrx_MZ4",
        "outputId": "832a237d-3c8e-4746-eea8-8fe8c17c464a"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "      patient                              psychologist  rating\n",
              "0           O  Eliane Aguiar Monteiro Marques Cerchiari       5\n",
              "1         GBS  Eliane Aguiar Monteiro Marques Cerchiari       5\n",
              "2       KRGDF  Eliane Aguiar Monteiro Marques Cerchiari       5\n",
              "3       SBSDF  Eliane Aguiar Monteiro Marques Cerchiari       5\n",
              "5        SPGB  Eliane Aguiar Monteiro Marques Cerchiari       5\n",
              "...       ...                                       ...     ...\n",
              "93017   FCDMS           Matheus Rodrigues do Nascimento       5\n",
              "93024     KKC           Matheus Rodrigues do Nascimento       5\n",
              "93027    RDOV           Matheus Rodrigues do Nascimento       5\n",
              "93031   FFRDM           Matheus Rodrigues do Nascimento       5\n",
              "93043     WCC           Matheus Rodrigues do Nascimento       5\n",
              "\n",
              "[22245 rows x 3 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-cd78af04-ad73-4718-b57d-4d68f7664885\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>patient</th>\n",
              "      <th>psychologist</th>\n",
              "      <th>rating</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>O</td>\n",
              "      <td>Eliane Aguiar Monteiro Marques Cerchiari</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>GBS</td>\n",
              "      <td>Eliane Aguiar Monteiro Marques Cerchiari</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>KRGDF</td>\n",
              "      <td>Eliane Aguiar Monteiro Marques Cerchiari</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>SBSDF</td>\n",
              "      <td>Eliane Aguiar Monteiro Marques Cerchiari</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>SPGB</td>\n",
              "      <td>Eliane Aguiar Monteiro Marques Cerchiari</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>93017</th>\n",
              "      <td>FCDMS</td>\n",
              "      <td>Matheus Rodrigues do Nascimento</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>93024</th>\n",
              "      <td>KKC</td>\n",
              "      <td>Matheus Rodrigues do Nascimento</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>93027</th>\n",
              "      <td>RDOV</td>\n",
              "      <td>Matheus Rodrigues do Nascimento</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>93031</th>\n",
              "      <td>FFRDM</td>\n",
              "      <td>Matheus Rodrigues do Nascimento</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>93043</th>\n",
              "      <td>WCC</td>\n",
              "      <td>Matheus Rodrigues do Nascimento</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>22245 rows × 3 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-cd78af04-ad73-4718-b57d-4d68f7664885')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-cd78af04-ad73-4718-b57d-4d68f7664885 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-cd78af04-ad73-4718-b57d-4d68f7664885');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-d1202627-f674-470d-a328-3a53f1933c4c\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-d1202627-f674-470d-a328-3a53f1933c4c')\"\n",
              "            title=\"Suggest charts.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "    background-color: #E8F0FE;\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: #1967D2;\n",
              "    height: 32px;\n",
              "    padding: 0 0 0 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart:hover {\n",
              "    background-color: #434B5C;\n",
              "    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "    fill: #FFFFFF;\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const charts = await google.colab.kernel.invokeFunction(\n",
              "          'suggestCharts', [key], {});\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-d1202627-f674-470d-a328-3a53f1933c4c button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 17
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Inserindo manualmente um usuário com suas avaliações no dataframe\n",
        "# Nesse cenário o paciente avaliou bem um grupo de psicólogos semelhantes entre si\n",
        "# E avaliou mal os psicólogos mais diferentes com relação ao grupo\n",
        "\n",
        "# O paciente possui intencionalmente poucas avaliações\n",
        "# O objetivo é testar possíveis problemas de cold start posteriormente\n",
        "ratings = pd.concat([ratings, pd.DataFrame.from_records([{'patient': 'AAAAA', 'psychologist': 'Isabela Rodrigues Leal', 'rating': 5}])], ignore_index=True)\n",
        "ratings = pd.concat([ratings, pd.DataFrame.from_records([{'patient': 'AAAAA', 'psychologist': 'Herika Blumer de Vita Bezerra da Silva', 'rating': 5}])], ignore_index=True)\n",
        "ratings = pd.concat([ratings, pd.DataFrame.from_records([{'patient': 'AAAAA', 'psychologist': 'Rafael Franco', 'rating': 5}])], ignore_index=True)\n",
        "ratings = pd.concat([ratings, pd.DataFrame.from_records([{'patient': 'AAAAA', 'psychologist': 'Glauco Luiz Targino', 'rating': 5}])], ignore_index=True)\n",
        "ratings = pd.concat([ratings, pd.DataFrame.from_records([{'patient': 'AAAAA', 'psychologist': 'Jairla Santana dos Santos', 'rating': 5}])], ignore_index=True)\n",
        "ratings = pd.concat([ratings, pd.DataFrame.from_records([{'patient': 'AAAAA', 'psychologist': 'Jamile Bangemann', 'rating': 5}])], ignore_index=True)\n",
        "ratings = pd.concat([ratings, pd.DataFrame.from_records([{'patient': 'AAAAA', 'psychologist': 'Amanda Manis Casarini', 'rating': 4}])], ignore_index=True)\n",
        "ratings = pd.concat([ratings, pd.DataFrame.from_records([{'patient': 'AAAAA', 'psychologist': \"Fernanda D'Avila Rodrigues\", 'rating': 3}])], ignore_index=True)\n",
        "ratings = pd.concat([ratings, pd.DataFrame.from_records([{'patient': 'AAAAA', 'psychologist': 'Ana Cristina Wagner', 'rating': 2}])], ignore_index=True)\n",
        "ratings = pd.concat([ratings, pd.DataFrame.from_records([{'patient': 'AAAAA', 'psychologist': 'Caroline Santos de Almeida Martins', 'rating': 1}])], ignore_index=True)\n"
      ],
      "metadata": {
        "id": "3ReiJl-fmzUy"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "## **Treinando o modelo**"
      ],
      "metadata": {
        "id": "4M8WAHu8mO9L"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "Para a recomendação colaborativa o objetivo foi utilizar os dados de avaliações descritos acima para prever as notas que o paciente daria para os psicólogos, isso foi feito utilizando o SVD (Singular Value Decomposition) em conjunto com o Cross-Validation, servindo como forma de treinamento e avaliação do modelo."
      ],
      "metadata": {
        "id": "7AocY_C55xMb"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Informa o range das notas, nesse sistema ele vai de 1 até 5\n",
        "reader = Reader(rating_scale = (1, 5))\n",
        "\n",
        "# Cria um dataset com Reader\n",
        "data = Dataset.load_from_df(ratings[['patient', 'psychologist', 'rating']], reader)"
      ],
      "metadata": {
        "id": "5w49duznpfap"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Criando instancia do SVD\n",
        "np.random.seed(5)\n",
        "svd = SVD()\n",
        "\n",
        "# Treinando os dados\n",
        "cross_validate(svd, data, measures = ['MAE', 'RMSE'], cv=5, verbose = True)\n",
        "print('>> Traning Done')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "OcFPuSBZoS-3",
        "outputId": "c5dfa8b6-1f96-493f-afb1-357911b721b4"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Evaluating MAE, RMSE of algorithm SVD on 5 split(s).\n",
            "\n",
            "                  Fold 1  Fold 2  Fold 3  Fold 4  Fold 5  Mean    Std     \n",
            "MAE (testset)     0.1233  0.1288  0.1251  0.1240  0.1171  0.1237  0.0038  \n",
            "RMSE (testset)    0.3741  0.4030  0.3904  0.3689  0.3322  0.3737  0.0240  \n",
            "Fit time          0.38    0.34    0.37    0.34    0.38    0.36    0.02    \n",
            "Test time         0.03    0.03    0.03    0.03    0.02    0.03    0.00    \n",
            ">> Traning Done\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Cria a base de testes\n",
        "trainset = data.build_full_trainset()\n",
        "\n",
        "# Pega as notas que não estão no teste e preenche com a média\n",
        "antiset = trainset.build_anti_testset()"
      ],
      "metadata": {
        "id": "l0q35Fn-oiOx"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Gera todas as previsões\n",
        "predictions = svd.test(antiset)"
      ],
      "metadata": {
        "id": "3EnYkQfPomzD"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Prevê a nota que um usuário aleatório daria para um psicólogo específico\n",
        "svd.predict('GBS', 'Rafael Cristiano Batista')"
      ],
      "metadata": {
        "id": "hQRvE4sll02R",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "794501d4-dab4-4196-d664-a0ce26907c65"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Prediction(uid='GBS', iid='Rafael Cristiano Batista', r_ui=None, est=4.916057619194589, details={'was_impossible': False})"
            ]
          },
          "metadata": {},
          "execution_count": 23
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Prevê a nota que o usuário inserido manualmente daria para um psicólogo específico\n",
        "svd.predict('AAAAA', 'Rafael Cristiano Batista')"
      ],
      "metadata": {
        "id": "Joe_-eapqZwq",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "91830c41-c998-4276-dd85-730def9b377a"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Prediction(uid='AAAAA', iid='Rafael Cristiano Batista', r_ui=None, est=4.348226193885154, details={'was_impossible': False})"
            ]
          },
          "metadata": {},
          "execution_count": 24
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## **Algoritmo de Filtragem Colaborativa**"
      ],
      "metadata": {
        "id": "lClOxkDrmidW"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "A partir do treinamento realizado pelo Cross-Validation e do cálculo previsões pelo SVD, é possível gerar uma lista de recomendações com base nos psicólogos que receberam as maiores notas previstas."
      ],
      "metadata": {
        "id": "cuewEzAH6UeO"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Para cada usuário, seleciona o top 10 psicólogos com a melhor nota prevista\n",
        "top_predictions = defaultdict(list)\n",
        "for u_id, p_id, _, est, _ in predictions:\n",
        "    top_predictions[u_id].append((p_id,est))\n",
        "for u_id, user_ratings in top_predictions.items():\n",
        "    user_ratings.sort(key = lambda x: x[1], reverse = True)\n",
        "    top_predictions[u_id] = user_ratings[:10]"
      ],
      "metadata": {
        "id": "d-GN4uudtB6V"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "def Recomendacao_Colaborativa(user):\n",
        "  # Transforma o dicionário em um dataframe\n",
        "  top_predictions_df = pd.DataFrame(top_predictions[user])\n",
        "  top_predictions_df.columns = ['psychologist', 'predicted_rating']\n",
        "\n",
        "  # Busca os psicólogos do top10 na base de dados\n",
        "  recommendations = pd.DataFrame()\n",
        "  for i in range(len(top_predictions_df)):\n",
        "    prediction = top_predictions_df.loc[top_predictions_df.index == i].psychologist.item()\n",
        "    psychologist = psychologists.loc[psychologists.name == prediction]\n",
        "    recommendations = pd.concat([recommendations, psychologist[['name', 'bio', 'expertises', 'total_ratings', 'avarage_rating']]], ignore_index=True)\n",
        "\n",
        "  recommendations['predicted_rating'] = top_predictions_df['predicted_rating']\n",
        "\n",
        "  return recommendations"
      ],
      "metadata": {
        "id": "6IzgZienwzug"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Resultado da recomendação colaborativa com um usuário aleatório\n",
        "Recomendacao_Colaborativa('GBS')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 363
        },
        "id": "vAH1GeFPPCkF",
        "outputId": "ad6da10d-b8d0-4533-f0f0-077a4bc7cf5f"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                 name  \\\n",
              "0                      Fernanda Dudek   \n",
              "1               Andressa Severo Pinto   \n",
              "2           Hellen Rose Correa Santos   \n",
              "3                      Simony Almeida   \n",
              "4                ADRIANA REGINA JULIO   \n",
              "5  Jessica Lais Soares Nunes da Silva   \n",
              "6       Luciane Pereira Maia Silveira   \n",
              "7               Hugo Luiz Araújo José   \n",
              "8               Lylian Santos e Silva   \n",
              "9      Carina Cruz de Santana Almeida   \n",
              "\n",
              "                                                 bio  \\\n",
              "0  Você que chegou até meu perfil, seja muito bem...   \n",
              "1  Olá, seja bem-vindo ao meu perfil. Meu nome é ...   \n",
              "2                                               None   \n",
              "3  Avaliação, Diagnóstico e Tratamento em TDAH | ...   \n",
              "4  Olá, primeiramente parabéns pela iniciativa de...   \n",
              "5  Atuo a quatro anos no atendimento clínico psic...   \n",
              "6  Meu nome é Luciane mas também conhecida como L...   \n",
              "7  Olá, seja bem-vindo(a)!, , Meu nome é Hugo Ara...   \n",
              "8  *** ENTRE EM CONTATO PARA VERIFICAR POSSIBILID...   \n",
              "9  Trabalho em conjunto com os princípios psicana...   \n",
              "\n",
              "                                          expertises total_ratings  \\\n",
              "0  Acompanhamento psicológico de Gravidez, Acompa...            55   \n",
              "1  Ansiedade, Compulsões, Conflitos Amorosos, Dep...             4   \n",
              "2  Ansiedade, Casal, Casamento, Conflitos Amoroso...             9   \n",
              "3  Ansiedade, Aprendizagem, Compulsões, Conflitos...            63   \n",
              "4  Ansiedade, Cirurgia Bariátrica, Compulsões, Co...           124   \n",
              "5  Acompanhamento psicológico de Gravidez, Acompa...             9   \n",
              "6  Acompanhamento pessoal, Ansiedade, Aprendizage...            20   \n",
              "7  Ansiedade, Conflitos Familiares, Depressão, De...             3   \n",
              "8  Ansiedade, Conflitos Familiares, Consultoria E...           317   \n",
              "9  Acompanhamento pessoal, Ansiedade, Casal, Casa...            24   \n",
              "\n",
              "   avarage_rating  predicted_rating  \n",
              "0        5.000000                 5  \n",
              "1        5.000000                 5  \n",
              "2        4.888889                 5  \n",
              "3        5.000000                 5  \n",
              "4        4.983871                 5  \n",
              "5        5.000000                 5  \n",
              "6        4.950000                 5  \n",
              "7        5.000000                 5  \n",
              "8        4.996845                 5  \n",
              "9        5.000000                 5  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-167bc098-410d-44fd-936c-6bbeae7f8b81\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>name</th>\n",
              "      <th>bio</th>\n",
              "      <th>expertises</th>\n",
              "      <th>total_ratings</th>\n",
              "      <th>avarage_rating</th>\n",
              "      <th>predicted_rating</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Fernanda Dudek</td>\n",
              "      <td>Você que chegou até meu perfil, seja muito bem...</td>\n",
              "      <td>Acompanhamento psicológico de Gravidez, Acompa...</td>\n",
              "      <td>55</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Andressa Severo Pinto</td>\n",
              "      <td>Olá, seja bem-vindo ao meu perfil. Meu nome é ...</td>\n",
              "      <td>Ansiedade, Compulsões, Conflitos Amorosos, Dep...</td>\n",
              "      <td>4</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Hellen Rose Correa Santos</td>\n",
              "      <td>None</td>\n",
              "      <td>Ansiedade, Casal, Casamento, Conflitos Amoroso...</td>\n",
              "      <td>9</td>\n",
              "      <td>4.888889</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Simony Almeida</td>\n",
              "      <td>Avaliação, Diagnóstico e Tratamento em TDAH | ...</td>\n",
              "      <td>Ansiedade, Aprendizagem, Compulsões, Conflitos...</td>\n",
              "      <td>63</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>ADRIANA REGINA JULIO</td>\n",
              "      <td>Olá, primeiramente parabéns pela iniciativa de...</td>\n",
              "      <td>Ansiedade, Cirurgia Bariátrica, Compulsões, Co...</td>\n",
              "      <td>124</td>\n",
              "      <td>4.983871</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Jessica Lais Soares Nunes da Silva</td>\n",
              "      <td>Atuo a quatro anos no atendimento clínico psic...</td>\n",
              "      <td>Acompanhamento psicológico de Gravidez, Acompa...</td>\n",
              "      <td>9</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Luciane Pereira Maia Silveira</td>\n",
              "      <td>Meu nome é Luciane mas também conhecida como L...</td>\n",
              "      <td>Acompanhamento pessoal, Ansiedade, Aprendizage...</td>\n",
              "      <td>20</td>\n",
              "      <td>4.950000</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Hugo Luiz Araújo José</td>\n",
              "      <td>Olá, seja bem-vindo(a)!, , Meu nome é Hugo Ara...</td>\n",
              "      <td>Ansiedade, Conflitos Familiares, Depressão, De...</td>\n",
              "      <td>3</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Lylian Santos e Silva</td>\n",
              "      <td>*** ENTRE EM CONTATO PARA VERIFICAR POSSIBILID...</td>\n",
              "      <td>Ansiedade, Conflitos Familiares, Consultoria E...</td>\n",
              "      <td>317</td>\n",
              "      <td>4.996845</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Carina Cruz de Santana Almeida</td>\n",
              "      <td>Trabalho em conjunto com os princípios psicana...</td>\n",
              "      <td>Acompanhamento pessoal, Ansiedade, Casal, Casa...</td>\n",
              "      <td>24</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-167bc098-410d-44fd-936c-6bbeae7f8b81')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-167bc098-410d-44fd-936c-6bbeae7f8b81 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-167bc098-410d-44fd-936c-6bbeae7f8b81');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-7d40e189-8c4b-4f61-8eab-f7033518f544\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-7d40e189-8c4b-4f61-8eab-f7033518f544')\"\n",
              "            title=\"Suggest charts.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "    background-color: #E8F0FE;\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: #1967D2;\n",
              "    height: 32px;\n",
              "    padding: 0 0 0 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart:hover {\n",
              "    background-color: #434B5C;\n",
              "    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "    fill: #FFFFFF;\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const charts = await google.colab.kernel.invokeFunction(\n",
              "          'suggestCharts', [key], {});\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-7d40e189-8c4b-4f61-8eab-f7033518f544 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 30
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Resultado da recomendação colaborativa com o usuário inserido manualmente\n",
        "Recomendacao_Colaborativa('AAAAA')"
      ],
      "metadata": {
        "id": "aFDHqySypD7a",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 363
        },
        "outputId": "9c0d0674-38ea-43b2-994f-2ea908f1ca60"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                             name  \\\n",
              "0            Maysa Valbom Ladeira   \n",
              "1      Bruna Ribeiro Lima Barbosa   \n",
              "2  Monica Freitas Pessanha Vieira   \n",
              "3                 Gustavo Brehmer   \n",
              "4                 Henrique Paixão   \n",
              "5          Monice Kattar Giovanni   \n",
              "6                     TAINÁ KURTZ   \n",
              "7         Walace Gonçalves Veloso   \n",
              "8           Andressa Mara Marques   \n",
              "9          TAIRINI EVLIN CARVALHO   \n",
              "\n",
              "                                                 bio  \\\n",
              "0  Oiii! Muito prazer!, Me chamo Maysa, sou psico...   \n",
              "1  Olá, seja bem-vindo(a). , Que bom te ver por a...   \n",
              "2  Olá fica tranquilo, Psicoterapia é pra todos!!...   \n",
              "3  - Atendo a partir de 18 anos., A vida se apres...   \n",
              "4  Oi, eu sou o Henrique! Sou formado em Psicolog...   \n",
              "5  Sou psicóloga há 16 anos, professora universit...   \n",
              "6  Olá! Eu sou psicóloga e especializanda em Tera...   \n",
              "7  Olá, me chamo Walace Veloso, seja bem-vindo! E...   \n",
              "8  Olá! Se você busca autoconhecimento; melhorar ...   \n",
              "9  Escutar, compreender seus sentimentos, angústi...   \n",
              "\n",
              "                                          expertises total_ratings  \\\n",
              "0  Acompanhamento psicológico de idosos, Ansiedad...             3   \n",
              "1  Acompanhamento pessoal, Ansiedade, Depressão, ...             9   \n",
              "2  Ansiedade, Conflitos Familiares, Depressão, De...            96   \n",
              "3  Acompanhamento pessoal, Ansiedade, Casamento, ...           384   \n",
              "4  Ansiedade, Casal, Compulsões, Dependência Quím...            15   \n",
              "5  Ansiedade, Conflitos Amorosos, Conflitos Famil...            25   \n",
              "6  Acompanhamento psicológico de Gravidez, Acompa...           251   \n",
              "7  Ansiedade, Casamento, Conflitos Amorosos, Conf...            15   \n",
              "8  Ansiedade, Conflitos Amorosos, Conflitos Famil...            79   \n",
              "9  Ansiedade, Compulsões, Conflitos Amorosos, Con...           198   \n",
              "\n",
              "   avarage_rating  predicted_rating  \n",
              "0        5.000000          4.829982  \n",
              "1        5.000000          4.819084  \n",
              "2        5.000000          4.798524  \n",
              "3        5.000000          4.777459  \n",
              "4        5.000000          4.762813  \n",
              "5        5.000000          4.749837  \n",
              "6        5.000000          4.742987  \n",
              "7        5.000000          4.740020  \n",
              "8        5.000000          4.724120  \n",
              "9        4.989899          4.720764  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-55473672-f0cd-4128-a995-8045415bf611\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>name</th>\n",
              "      <th>bio</th>\n",
              "      <th>expertises</th>\n",
              "      <th>total_ratings</th>\n",
              "      <th>avarage_rating</th>\n",
              "      <th>predicted_rating</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Maysa Valbom Ladeira</td>\n",
              "      <td>Oiii! Muito prazer!, Me chamo Maysa, sou psico...</td>\n",
              "      <td>Acompanhamento psicológico de idosos, Ansiedad...</td>\n",
              "      <td>3</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>4.829982</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Bruna Ribeiro Lima Barbosa</td>\n",
              "      <td>Olá, seja bem-vindo(a). , Que bom te ver por a...</td>\n",
              "      <td>Acompanhamento pessoal, Ansiedade, Depressão, ...</td>\n",
              "      <td>9</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>4.819084</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Monica Freitas Pessanha Vieira</td>\n",
              "      <td>Olá fica tranquilo, Psicoterapia é pra todos!!...</td>\n",
              "      <td>Ansiedade, Conflitos Familiares, Depressão, De...</td>\n",
              "      <td>96</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>4.798524</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Gustavo Brehmer</td>\n",
              "      <td>- Atendo a partir de 18 anos., A vida se apres...</td>\n",
              "      <td>Acompanhamento pessoal, Ansiedade, Casamento, ...</td>\n",
              "      <td>384</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>4.777459</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Henrique Paixão</td>\n",
              "      <td>Oi, eu sou o Henrique! Sou formado em Psicolog...</td>\n",
              "      <td>Ansiedade, Casal, Compulsões, Dependência Quím...</td>\n",
              "      <td>15</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>4.762813</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Monice Kattar Giovanni</td>\n",
              "      <td>Sou psicóloga há 16 anos, professora universit...</td>\n",
              "      <td>Ansiedade, Conflitos Amorosos, Conflitos Famil...</td>\n",
              "      <td>25</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>4.749837</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>TAINÁ KURTZ</td>\n",
              "      <td>Olá! Eu sou psicóloga e especializanda em Tera...</td>\n",
              "      <td>Acompanhamento psicológico de Gravidez, Acompa...</td>\n",
              "      <td>251</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>4.742987</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Walace Gonçalves Veloso</td>\n",
              "      <td>Olá, me chamo Walace Veloso, seja bem-vindo! E...</td>\n",
              "      <td>Ansiedade, Casamento, Conflitos Amorosos, Conf...</td>\n",
              "      <td>15</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>4.740020</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Andressa Mara Marques</td>\n",
              "      <td>Olá! Se você busca autoconhecimento; melhorar ...</td>\n",
              "      <td>Ansiedade, Conflitos Amorosos, Conflitos Famil...</td>\n",
              "      <td>79</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>4.724120</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>TAIRINI EVLIN CARVALHO</td>\n",
              "      <td>Escutar, compreender seus sentimentos, angústi...</td>\n",
              "      <td>Ansiedade, Compulsões, Conflitos Amorosos, Con...</td>\n",
              "      <td>198</td>\n",
              "      <td>4.989899</td>\n",
              "      <td>4.720764</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-55473672-f0cd-4128-a995-8045415bf611')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-55473672-f0cd-4128-a995-8045415bf611 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-55473672-f0cd-4128-a995-8045415bf611');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-242b88ec-07c0-456a-9ac7-4ea10b52267f\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-242b88ec-07c0-456a-9ac7-4ea10b52267f')\"\n",
              "            title=\"Suggest charts.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "    background-color: #E8F0FE;\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: #1967D2;\n",
              "    height: 32px;\n",
              "    padding: 0 0 0 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart:hover {\n",
              "    background-color: #434B5C;\n",
              "    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "    fill: #FFFFFF;\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const charts = await google.colab.kernel.invokeFunction(\n",
              "          'suggestCharts', [key], {});\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-242b88ec-07c0-456a-9ac7-4ea10b52267f button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 31
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "É possível observar que o usuário inserido manualmente possui uma recomendação razoavelmente pior, levando em consideração as notas dos psicólogos incluídos na recomendação. Esse é um problema de coldstart que ocorre devido ao menor número de dados de avaliações sobre esse usuário no sistema."
      ],
      "metadata": {
        "id": "SQrbe7VmWPuH"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "# **Recomendação Baseada em Filtragem Híbrida**"
      ],
      "metadata": {
        "id": "RFGMCDelxKuz"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "Por fim, o algoritmo de recomendação baseado em filtragem híbrida faz uma mescla entre os dois algoritmos citados anteriormente (TF-IDF e SVD) buscando gerar uma recomendação que balanceie os pontos fracos de ambos."
      ],
      "metadata": {
        "id": "jkIXKy5F6cwG"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "## **Modelo 1 (TFIDF-SVD)**"
      ],
      "metadata": {
        "id": "8rcJ0EizwiP8"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "O primeiro modelo híbrido funciona inicialmente calculando a similaridade por TF-IDF, e posteriormente ordenando esse resultado com base na nota prevista pelo SVD."
      ],
      "metadata": {
        "id": "l46-abH-aDg2"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Recomendação Híbrida Ordenada por Nota Prevista\n",
        "\n",
        "def Recomendacao_Hibrida_TFIDF_SVD(user, psy_name):\n",
        "  # Calcula a matriz de similaridades entre os psicólogos\n",
        "  vectorizer = TfidfVectorizer()\n",
        "  similarities_matrix = vectorizer.fit_transform(psychologists['expertises'])\n",
        "  similarity = linear_kernel(similarities_matrix, similarities_matrix)\n",
        "\n",
        "  # Encontra o Psicólogo pelo nome\n",
        "  psychologist = psychologists.loc[psychologists['name']==psy_name]\n",
        "  psy_id = int(psychologist.index[0])\n",
        "\n",
        "  # Determina a similaridade relativa ao psicólogo em questão\n",
        "  psy_similarity = list(enumerate(similarity[psy_id]))\n",
        "\n",
        "  # Recria a base de dados com o campo de similaridade anterior\n",
        "  similar_psychologists = psychologists.copy()\n",
        "  similar_psychologists['similarity_level'] = pd.Series(psy_similarity).apply(lambda x: x[1])\n",
        "\n",
        "  # Ordena os psicólogos com maior similaridade em relação ao psicólogo em questão\n",
        "  recommendations = sorted(psy_similarity, key=lambda x: x[1], reverse=True)\n",
        "\n",
        "  # Seleciona os 100 psicólogos mais semelhantes\n",
        "  '''O psicólogo de índice 0 é \"pulado\" pois sempre será o psicólogo em questão\n",
        "  cujo se deseja estabelecer a similaridade aos outros (haverá 100% de similaridade com ele)'''\n",
        "  recommendations = recommendations[1:101]\n",
        "\n",
        "  # Seleciona os índices dos 100 psicólogos mais semelhantes\n",
        "  recommendations_indexes = [i[0] for i in recommendations]\n",
        "\n",
        "  # Busca os 100 psicólogos na base de dados\n",
        "  similar_psychologists = similar_psychologists.iloc[recommendations_indexes]\n",
        "\n",
        "  # Preve a nota do usuario para os 100 psicólogos mais semelhantes\n",
        "  similar_psychologists['predicted_rating'] = similar_psychologists.name.apply(lambda x: svd.predict(user, x).est)\n",
        "\n",
        "  # Ordena a recomendação com base na nota prevista\n",
        "  similar_psychologists = similar_psychologists.sort_values('predicted_rating', ascending=False)\n",
        "\n",
        "  return similar_psychologists[0:10]"
      ],
      "metadata": {
        "id": "8Mna4dwXXRMg"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Resultado do primeiro modelo de recomendação híbrida com um usuário aleatório\n",
        "Recomendacao_Hibrida_TFIDF_SVD('GBS', 'Rafael Cristiano Batista')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 450
        },
        "id": "IrGtMjFDqO0i",
        "outputId": "c7b06559-dcdd-49e5-9557-3d734b4621b3"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                name  \\\n",
              "764     Amanda Caldas Cunha Cordeiro   \n",
              "852                  Jurece Curupaná   \n",
              "132                  Lorrayne Ismael   \n",
              "387  Eloize Marianny Bonfim da Silva   \n",
              "325                  Camilla Schultz   \n",
              "141         Andreza da silva andrade   \n",
              "744         Caroline Orlande Gabriel   \n",
              "248      Fernanda Gomes de Melo Lima   \n",
              "533                 João Luiz Corrêa   \n",
              "623         Elisangela Lima de Paula   \n",
              "\n",
              "                                                   bio  \\\n",
              "764  Olá, seja bem-vindo(a) ao meu perfil! Meu nome...   \n",
              "852  Meu nome é Jurecê de Oliveira Curupaná, sou Ps...   \n",
              "132  Olá, me chamo Lorrayne, sou psicóloga, pós gra...   \n",
              "387                                               None   \n",
              "325  Olá, meu nome é Camilla e sou psicóloga clínic...   \n",
              "141  Olá! me chamo Andreza, tenho 26 anos. Me forme...   \n",
              "744  Sou graduada em Psicologia pela Universidade F...   \n",
              "248  Uma professora ao longo da minha formação um d...   \n",
              "533  Olá! Como está se sentindo? , , Meu nome é Joã...   \n",
              "623  Olá eu nome é Elisângela, me graduei no ano de...   \n",
              "\n",
              "                                            expertises total_ratings  \\\n",
              "764  Acompanhamento pessoal, Ansiedade, Conflitos A...            46   \n",
              "852  Ansiedade, Casal, Casamento, Cirurgia Bariátri...           166   \n",
              "132  Acompanhamento psicológico de Gravidez, Acompa...            73   \n",
              "387  Ansiedade, Casal, Conflitos Amorosos, Conflito...            14   \n",
              "325  Ansiedade, Casamento, Conflitos Amorosos, Conf...           121   \n",
              "141  Ansiedade, Casal, Casamento, Conflitos Amoroso...            67   \n",
              "744  Acompanhamento pessoal, Ansiedade, Casamento, ...            19   \n",
              "248  Ansiedade, Compulsões, Conflitos Amorosos, Con...            50   \n",
              "533  Acompanhamento pessoal, Ansiedade, Casamento, ...            88   \n",
              "623  Acompanhamento pessoal, Acompanhamento psicoló...          1316   \n",
              "\n",
              "     avarage_rating  similarity_level  predicted_rating  \n",
              "764        5.000000          0.666882               5.0  \n",
              "852        5.000000          0.468418               5.0  \n",
              "132        5.000000          0.537944               5.0  \n",
              "387        5.000000          0.471770               5.0  \n",
              "325        4.991736          0.528079               5.0  \n",
              "141        4.955224          0.525794               5.0  \n",
              "744        5.000000          0.521512               5.0  \n",
              "248        5.000000          0.519243               5.0  \n",
              "533        5.000000          0.512659               5.0  \n",
              "623        0.436930          0.512489               5.0  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-2a94631d-3160-4977-829b-d54b0fd7921e\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>name</th>\n",
              "      <th>bio</th>\n",
              "      <th>expertises</th>\n",
              "      <th>total_ratings</th>\n",
              "      <th>avarage_rating</th>\n",
              "      <th>similarity_level</th>\n",
              "      <th>predicted_rating</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>764</th>\n",
              "      <td>Amanda Caldas Cunha Cordeiro</td>\n",
              "      <td>Olá, seja bem-vindo(a) ao meu perfil! Meu nome...</td>\n",
              "      <td>Acompanhamento pessoal, Ansiedade, Conflitos A...</td>\n",
              "      <td>46</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>0.666882</td>\n",
              "      <td>5.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>852</th>\n",
              "      <td>Jurece Curupaná</td>\n",
              "      <td>Meu nome é Jurecê de Oliveira Curupaná, sou Ps...</td>\n",
              "      <td>Ansiedade, Casal, Casamento, Cirurgia Bariátri...</td>\n",
              "      <td>166</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>0.468418</td>\n",
              "      <td>5.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>132</th>\n",
              "      <td>Lorrayne Ismael</td>\n",
              "      <td>Olá, me chamo Lorrayne, sou psicóloga, pós gra...</td>\n",
              "      <td>Acompanhamento psicológico de Gravidez, Acompa...</td>\n",
              "      <td>73</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>0.537944</td>\n",
              "      <td>5.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>387</th>\n",
              "      <td>Eloize Marianny Bonfim da Silva</td>\n",
              "      <td>None</td>\n",
              "      <td>Ansiedade, Casal, Conflitos Amorosos, Conflito...</td>\n",
              "      <td>14</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>0.471770</td>\n",
              "      <td>5.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>325</th>\n",
              "      <td>Camilla Schultz</td>\n",
              "      <td>Olá, meu nome é Camilla e sou psicóloga clínic...</td>\n",
              "      <td>Ansiedade, Casamento, Conflitos Amorosos, Conf...</td>\n",
              "      <td>121</td>\n",
              "      <td>4.991736</td>\n",
              "      <td>0.528079</td>\n",
              "      <td>5.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>141</th>\n",
              "      <td>Andreza da silva andrade</td>\n",
              "      <td>Olá! me chamo Andreza, tenho 26 anos. Me forme...</td>\n",
              "      <td>Ansiedade, Casal, Casamento, Conflitos Amoroso...</td>\n",
              "      <td>67</td>\n",
              "      <td>4.955224</td>\n",
              "      <td>0.525794</td>\n",
              "      <td>5.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>744</th>\n",
              "      <td>Caroline Orlande Gabriel</td>\n",
              "      <td>Sou graduada em Psicologia pela Universidade F...</td>\n",
              "      <td>Acompanhamento pessoal, Ansiedade, Casamento, ...</td>\n",
              "      <td>19</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>0.521512</td>\n",
              "      <td>5.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>248</th>\n",
              "      <td>Fernanda Gomes de Melo Lima</td>\n",
              "      <td>Uma professora ao longo da minha formação um d...</td>\n",
              "      <td>Ansiedade, Compulsões, Conflitos Amorosos, Con...</td>\n",
              "      <td>50</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>0.519243</td>\n",
              "      <td>5.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>533</th>\n",
              "      <td>João Luiz Corrêa</td>\n",
              "      <td>Olá! Como está se sentindo? , , Meu nome é Joã...</td>\n",
              "      <td>Acompanhamento pessoal, Ansiedade, Casamento, ...</td>\n",
              "      <td>88</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>0.512659</td>\n",
              "      <td>5.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>623</th>\n",
              "      <td>Elisangela Lima de Paula</td>\n",
              "      <td>Olá eu nome é Elisângela, me graduei no ano de...</td>\n",
              "      <td>Acompanhamento pessoal, Acompanhamento psicoló...</td>\n",
              "      <td>1316</td>\n",
              "      <td>0.436930</td>\n",
              "      <td>0.512489</td>\n",
              "      <td>5.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-2a94631d-3160-4977-829b-d54b0fd7921e')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-2a94631d-3160-4977-829b-d54b0fd7921e button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-2a94631d-3160-4977-829b-d54b0fd7921e');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-c4394621-0926-4e3c-9865-53d04a4a7ce9\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-c4394621-0926-4e3c-9865-53d04a4a7ce9')\"\n",
              "            title=\"Suggest charts.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "    background-color: #E8F0FE;\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: #1967D2;\n",
              "    height: 32px;\n",
              "    padding: 0 0 0 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart:hover {\n",
              "    background-color: #434B5C;\n",
              "    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "    fill: #FFFFFF;\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const charts = await google.colab.kernel.invokeFunction(\n",
              "          'suggestCharts', [key], {});\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-c4394621-0926-4e3c-9865-53d04a4a7ce9 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 33
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Resultado do primeiro modelo de recomendação híbrida com o usuário inserido manualmente\n",
        "Recomendacao_Hibrida_TFIDF_SVD('AAAAA', 'Rafael Cristiano Batista')"
      ],
      "metadata": {
        "id": "M68CkcyTq16h",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 484
        },
        "outputId": "c0a2bf4d-19d5-439b-b7e9-9c8bc1f69904"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                      name  \\\n",
              "58                         Sandra Pinheiro   \n",
              "701              Beatriz De Oliveira Toral   \n",
              "324                         Tatiane Macedo   \n",
              "248            Fernanda Gomes de Melo Lima   \n",
              "983            Fernanda Cristina Grilletti   \n",
              "94               Natalia Iara Alves Isepon   \n",
              "160                            Caio Rangel   \n",
              "814  Renata Sousa Lima Ribeiro de Oliveira   \n",
              "744               Caroline Orlande Gabriel   \n",
              "627        Fabiana Galla Soares dos Santos   \n",
              "\n",
              "                                                   bio  \\\n",
              "58   “Olá, sou psicóloga há seis anos . Tenho exper...   \n",
              "701  Olá, seja bem-vindo(a)! Sou Beatriz, psicóloga...   \n",
              "324  Você sente que trabalha muito e não consegue o...   \n",
              "248  Uma professora ao longo da minha formação um d...   \n",
              "983  Meu nome é Fernanda Cristina Grilletti, CRP 06...   \n",
              "94   Olá, sou psicóloga clínica e trabalho pautada ...   \n",
              "160  Enquanto houver vida dentro de você, existirá ...   \n",
              "814  Psicóloga Clínica., Psicoterapeuta  de Adolesc...   \n",
              "744  Sou graduada em Psicologia pela Universidade F...   \n",
              "627  Olá, se você está aqui, possivelmente surgiu u...   \n",
              "\n",
              "                                            expertises total_ratings  \\\n",
              "58   Acompanhamento pessoal, Ansiedade, Conflitos A...             4   \n",
              "701  Ansiedade, Conflitos Amorosos, Conflitos Famil...            38   \n",
              "324  Acompanhamento pessoal, Ansiedade, Casal, Conf...            45   \n",
              "248  Ansiedade, Compulsões, Conflitos Amorosos, Con...            50   \n",
              "983  Ansiedade, Aprendizagem, Conflitos Amorosos, C...             4   \n",
              "94   Acompanhamento psicológico de idosos, Ansiedad...            41   \n",
              "160  Ansiedade, Casal, Casamento, Conflitos Familia...            96   \n",
              "814  Acompanhamento pessoal, Ansiedade, Compulsões,...           104   \n",
              "744  Acompanhamento pessoal, Ansiedade, Casamento, ...            19   \n",
              "627  Acompanhamento pessoal, Ansiedade, Casamento, ...            41   \n",
              "\n",
              "     avarage_rating  similarity_level  predicted_rating  \n",
              "58              5.0          0.509941          4.673082  \n",
              "701             5.0          0.497528          4.667403  \n",
              "324             5.0          0.598624          4.646881  \n",
              "248             5.0          0.519243          4.629283  \n",
              "983             5.0          0.499235          4.628978  \n",
              "94              5.0          0.476238          4.627176  \n",
              "160             5.0          0.467188          4.627133  \n",
              "814             5.0          0.498591          4.625746  \n",
              "744             5.0          0.521512          4.611128  \n",
              "627             5.0          0.544767          4.610946  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-34b955e8-559f-4d65-8516-c641e020efee\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>name</th>\n",
              "      <th>bio</th>\n",
              "      <th>expertises</th>\n",
              "      <th>total_ratings</th>\n",
              "      <th>avarage_rating</th>\n",
              "      <th>similarity_level</th>\n",
              "      <th>predicted_rating</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>58</th>\n",
              "      <td>Sandra Pinheiro</td>\n",
              "      <td>“Olá, sou psicóloga há seis anos . Tenho exper...</td>\n",
              "      <td>Acompanhamento pessoal, Ansiedade, Conflitos A...</td>\n",
              "      <td>4</td>\n",
              "      <td>5.0</td>\n",
              "      <td>0.509941</td>\n",
              "      <td>4.673082</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>701</th>\n",
              "      <td>Beatriz De Oliveira Toral</td>\n",
              "      <td>Olá, seja bem-vindo(a)! Sou Beatriz, psicóloga...</td>\n",
              "      <td>Ansiedade, Conflitos Amorosos, Conflitos Famil...</td>\n",
              "      <td>38</td>\n",
              "      <td>5.0</td>\n",
              "      <td>0.497528</td>\n",
              "      <td>4.667403</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>324</th>\n",
              "      <td>Tatiane Macedo</td>\n",
              "      <td>Você sente que trabalha muito e não consegue o...</td>\n",
              "      <td>Acompanhamento pessoal, Ansiedade, Casal, Conf...</td>\n",
              "      <td>45</td>\n",
              "      <td>5.0</td>\n",
              "      <td>0.598624</td>\n",
              "      <td>4.646881</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>248</th>\n",
              "      <td>Fernanda Gomes de Melo Lima</td>\n",
              "      <td>Uma professora ao longo da minha formação um d...</td>\n",
              "      <td>Ansiedade, Compulsões, Conflitos Amorosos, Con...</td>\n",
              "      <td>50</td>\n",
              "      <td>5.0</td>\n",
              "      <td>0.519243</td>\n",
              "      <td>4.629283</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>983</th>\n",
              "      <td>Fernanda Cristina Grilletti</td>\n",
              "      <td>Meu nome é Fernanda Cristina Grilletti, CRP 06...</td>\n",
              "      <td>Ansiedade, Aprendizagem, Conflitos Amorosos, C...</td>\n",
              "      <td>4</td>\n",
              "      <td>5.0</td>\n",
              "      <td>0.499235</td>\n",
              "      <td>4.628978</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>94</th>\n",
              "      <td>Natalia Iara Alves Isepon</td>\n",
              "      <td>Olá, sou psicóloga clínica e trabalho pautada ...</td>\n",
              "      <td>Acompanhamento psicológico de idosos, Ansiedad...</td>\n",
              "      <td>41</td>\n",
              "      <td>5.0</td>\n",
              "      <td>0.476238</td>\n",
              "      <td>4.627176</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>160</th>\n",
              "      <td>Caio Rangel</td>\n",
              "      <td>Enquanto houver vida dentro de você, existirá ...</td>\n",
              "      <td>Ansiedade, Casal, Casamento, Conflitos Familia...</td>\n",
              "      <td>96</td>\n",
              "      <td>5.0</td>\n",
              "      <td>0.467188</td>\n",
              "      <td>4.627133</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>814</th>\n",
              "      <td>Renata Sousa Lima Ribeiro de Oliveira</td>\n",
              "      <td>Psicóloga Clínica., Psicoterapeuta  de Adolesc...</td>\n",
              "      <td>Acompanhamento pessoal, Ansiedade, Compulsões,...</td>\n",
              "      <td>104</td>\n",
              "      <td>5.0</td>\n",
              "      <td>0.498591</td>\n",
              "      <td>4.625746</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>744</th>\n",
              "      <td>Caroline Orlande Gabriel</td>\n",
              "      <td>Sou graduada em Psicologia pela Universidade F...</td>\n",
              "      <td>Acompanhamento pessoal, Ansiedade, Casamento, ...</td>\n",
              "      <td>19</td>\n",
              "      <td>5.0</td>\n",
              "      <td>0.521512</td>\n",
              "      <td>4.611128</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>627</th>\n",
              "      <td>Fabiana Galla Soares dos Santos</td>\n",
              "      <td>Olá, se você está aqui, possivelmente surgiu u...</td>\n",
              "      <td>Acompanhamento pessoal, Ansiedade, Casamento, ...</td>\n",
              "      <td>41</td>\n",
              "      <td>5.0</td>\n",
              "      <td>0.544767</td>\n",
              "      <td>4.610946</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-34b955e8-559f-4d65-8516-c641e020efee')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-34b955e8-559f-4d65-8516-c641e020efee button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-34b955e8-559f-4d65-8516-c641e020efee');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-a89518bc-575d-4858-bee2-eeb7f108412c\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-a89518bc-575d-4858-bee2-eeb7f108412c')\"\n",
              "            title=\"Suggest charts.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "    background-color: #E8F0FE;\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: #1967D2;\n",
              "    height: 32px;\n",
              "    padding: 0 0 0 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart:hover {\n",
              "    background-color: #434B5C;\n",
              "    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "    fill: #FFFFFF;\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const charts = await google.colab.kernel.invokeFunction(\n",
              "          'suggestCharts', [key], {});\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-a89518bc-575d-4858-bee2-eeb7f108412c button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 34
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## **Modelo 2 (SVD-TFIDF)**"
      ],
      "metadata": {
        "id": "WO5dfepEwn_7"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "Já o segundo modelo híbrido funciona de maneira inversa, inicialmente calculando as notas previstas pelo SVD, e posteriormente ordenando esse resultado com base na similaridade por TF-IDF."
      ],
      "metadata": {
        "id": "dUdJy4Wzl_s7"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Para cada usuário, seleciona o top 100 psicólogos com a melhor nota prevista\n",
        "top_predictions = defaultdict(list)\n",
        "for u_id, p_id, _, est, _ in predictions:\n",
        "    top_predictions[u_id].append((p_id,est))\n",
        "for u_id, user_ratings in top_predictions.items():\n",
        "    user_ratings.sort(key = lambda x: x[1], reverse = True)\n",
        "    top_predictions[u_id] = user_ratings[:100]"
      ],
      "metadata": {
        "id": "JNvtzmDHwuUo"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "def Recomendacao_Hibrida_SVD_TFIDF(user, psy_name):\n",
        "  # Transforma o dicionário em um dataframe\n",
        "  top_predictions_df = pd.DataFrame(top_predictions[user])\n",
        "  top_predictions_df.columns = ['psychologist', 'predicted_rating']\n",
        "\n",
        "  # Busca os psicólogos do top10 na base de dados\n",
        "  recommendations = pd.DataFrame()\n",
        "  for i in range(len(top_predictions_df)):\n",
        "    prediction = top_predictions_df.loc[top_predictions_df.index == i].psychologist.item()\n",
        "    psychologist = psychologists.loc[psychologists.name == prediction]\n",
        "    recommendations = pd.concat([recommendations, psychologist[['name', 'bio', 'expertises', 'total_ratings', 'avarage_rating']]], ignore_index=True)\n",
        "\n",
        "  # Adiciona a coluna de notas previstas\n",
        "  recommendations['predicted_rating'] = top_predictions_df['predicted_rating']\n",
        "\n",
        "  # Calcula a matriz de similaridades entre os psicólogos\n",
        "  vectorizer = TfidfVectorizer()\n",
        "  similarities_matrix = vectorizer.fit_transform(recommendations['expertises'])\n",
        "  similarity = linear_kernel(similarities_matrix, similarities_matrix)\n",
        "\n",
        "  # Encontra o Psicólogo pelo nome\n",
        "  psychologist = psychologists.loc[psychologists['name']==psy_name]\n",
        "\n",
        "  # Determina a similaridade relativa ao psicólogo em questão\n",
        "  psy_similarity = list(enumerate(similarity[psychologist.index[0]]))\n",
        "\n",
        "  # Recria a base de dados com o campo de similaridade anterior\n",
        "  similar_psychologists = recommendations.copy()\n",
        "  similar_psychologists['similarity'] = pd.Series(psy_similarity).apply(lambda x: x[1])\n",
        "  similar_psychologists = similar_psychologists.sort_values('similarity', ascending=False)\n",
        "\n",
        "  return similar_psychologists[1:11]"
      ],
      "metadata": {
        "id": "4jeEgwBkajH-"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Resultado do primeiro modelo de recomendação híbrida com um usuário aleatório\n",
        "Recomendacao_Hibrida_SVD_TFIDF('GBS', 'Rafael Cristiano Batista')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 363
        },
        "outputId": "e8c2caa7-4346-4fd5-d4de-902336586ac9",
        "id": "Kq0G8RwuXHXe"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                name  \\\n",
              "65    Isabelle telyne Contel Anzulim   \n",
              "48               Geiziane Silva Mota   \n",
              "76          Katiussia Viana da Silva   \n",
              "97        Henrique Lovato Corte Real   \n",
              "19                   Henrique Paixão   \n",
              "64         Larissa Favarão Bianchesi   \n",
              "61       Franciele Miloch dos Santos   \n",
              "98                   Luciene Martins   \n",
              "96  Kareen Cristina Centurion Jordão   \n",
              "66              Caroline Rosa Aquino   \n",
              "\n",
              "                                                  bio  \\\n",
              "65  Olá, voce se sente ansioso?  sem vontade de fa...   \n",
              "48  Olá! Sou Geiziane Silva Mota, Psicóloga Clínic...   \n",
              "76  Olá, me chamo Katiussia, e sou Psicóloga Clíni...   \n",
              "97  Olá, seja bem-vindo(a)! , Sou psicólogo, ativo...   \n",
              "19  Oi, eu sou o Henrique! Sou formado em Psicolog...   \n",
              "64                                               None   \n",
              "61  Olá! Prazer, meu nome é Franciele e meu princi...   \n",
              "98  Olá, Seja muito  bem vindo (a)!  Aqui, você va...   \n",
              "96  Como você vem se sentindo? Desanimado, ansioso...   \n",
              "66  Atuo como Psicóloga Clínica, auxiliando jovens...   \n",
              "\n",
              "                                           expertises total_ratings  \\\n",
              "65  Ansiedade, Compulsões, Conflitos Amorosos, Dep...            51   \n",
              "48  Ansiedade, Conflitos Amorosos, Conflitos Famil...            21   \n",
              "76  Ansiedade, Conflitos Amorosos, Depressão, Dese...            39   \n",
              "97  Ansiedade, Aprendizagem, Compulsões, Conflitos...           628   \n",
              "19  Ansiedade, Casal, Compulsões, Dependência Quím...            15   \n",
              "64  Acompanhamento pessoal, Ansiedade, Casamento, ...           114   \n",
              "61  Ansiedade, Compulsões, Conflitos Familiares, D...            88   \n",
              "98  Ansiedade, Compulsões, Conflitos Amorosos, Con...             5   \n",
              "96  Acompanhamento pessoal, Acompanhamento psicoló...            28   \n",
              "66  Ansiedade, Compulsões, Conflitos Amorosos, Con...            10   \n",
              "\n",
              "    avarage_rating  predicted_rating  similarity  \n",
              "65        4.980392                 5    0.776750  \n",
              "48        4.857143                 5    0.700091  \n",
              "76        5.000000                 5    0.648997  \n",
              "97        2.939490                 5    0.597224  \n",
              "19        5.000000                 5    0.571970  \n",
              "64        5.000000                 5    0.548429  \n",
              "61        5.000000                 5    0.547517  \n",
              "98        5.000000                 5    0.544796  \n",
              "96        5.000000                 5    0.528556  \n",
              "66        5.000000                 5    0.515125  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-1680ce5b-a96a-491e-9964-d23db17f823a\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>name</th>\n",
              "      <th>bio</th>\n",
              "      <th>expertises</th>\n",
              "      <th>total_ratings</th>\n",
              "      <th>avarage_rating</th>\n",
              "      <th>predicted_rating</th>\n",
              "      <th>similarity</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>65</th>\n",
              "      <td>Isabelle telyne Contel Anzulim</td>\n",
              "      <td>Olá, voce se sente ansioso?  sem vontade de fa...</td>\n",
              "      <td>Ansiedade, Compulsões, Conflitos Amorosos, Dep...</td>\n",
              "      <td>51</td>\n",
              "      <td>4.980392</td>\n",
              "      <td>5</td>\n",
              "      <td>0.776750</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>Geiziane Silva Mota</td>\n",
              "      <td>Olá! Sou Geiziane Silva Mota, Psicóloga Clínic...</td>\n",
              "      <td>Ansiedade, Conflitos Amorosos, Conflitos Famil...</td>\n",
              "      <td>21</td>\n",
              "      <td>4.857143</td>\n",
              "      <td>5</td>\n",
              "      <td>0.700091</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>76</th>\n",
              "      <td>Katiussia Viana da Silva</td>\n",
              "      <td>Olá, me chamo Katiussia, e sou Psicóloga Clíni...</td>\n",
              "      <td>Ansiedade, Conflitos Amorosos, Depressão, Dese...</td>\n",
              "      <td>39</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>5</td>\n",
              "      <td>0.648997</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>97</th>\n",
              "      <td>Henrique Lovato Corte Real</td>\n",
              "      <td>Olá, seja bem-vindo(a)! , Sou psicólogo, ativo...</td>\n",
              "      <td>Ansiedade, Aprendizagem, Compulsões, Conflitos...</td>\n",
              "      <td>628</td>\n",
              "      <td>2.939490</td>\n",
              "      <td>5</td>\n",
              "      <td>0.597224</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>Henrique Paixão</td>\n",
              "      <td>Oi, eu sou o Henrique! Sou formado em Psicolog...</td>\n",
              "      <td>Ansiedade, Casal, Compulsões, Dependência Quím...</td>\n",
              "      <td>15</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>5</td>\n",
              "      <td>0.571970</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>64</th>\n",
              "      <td>Larissa Favarão Bianchesi</td>\n",
              "      <td>None</td>\n",
              "      <td>Acompanhamento pessoal, Ansiedade, Casamento, ...</td>\n",
              "      <td>114</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>5</td>\n",
              "      <td>0.548429</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>61</th>\n",
              "      <td>Franciele Miloch dos Santos</td>\n",
              "      <td>Olá! Prazer, meu nome é Franciele e meu princi...</td>\n",
              "      <td>Ansiedade, Compulsões, Conflitos Familiares, D...</td>\n",
              "      <td>88</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>5</td>\n",
              "      <td>0.547517</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>98</th>\n",
              "      <td>Luciene Martins</td>\n",
              "      <td>Olá, Seja muito  bem vindo (a)!  Aqui, você va...</td>\n",
              "      <td>Ansiedade, Compulsões, Conflitos Amorosos, Con...</td>\n",
              "      <td>5</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>5</td>\n",
              "      <td>0.544796</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>96</th>\n",
              "      <td>Kareen Cristina Centurion Jordão</td>\n",
              "      <td>Como você vem se sentindo? Desanimado, ansioso...</td>\n",
              "      <td>Acompanhamento pessoal, Acompanhamento psicoló...</td>\n",
              "      <td>28</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>5</td>\n",
              "      <td>0.528556</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>66</th>\n",
              "      <td>Caroline Rosa Aquino</td>\n",
              "      <td>Atuo como Psicóloga Clínica, auxiliando jovens...</td>\n",
              "      <td>Ansiedade, Compulsões, Conflitos Amorosos, Con...</td>\n",
              "      <td>10</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>5</td>\n",
              "      <td>0.515125</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-1680ce5b-a96a-491e-9964-d23db17f823a')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-1680ce5b-a96a-491e-9964-d23db17f823a button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-1680ce5b-a96a-491e-9964-d23db17f823a');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-79293582-e6fc-41be-a582-7e12f63198f4\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-79293582-e6fc-41be-a582-7e12f63198f4')\"\n",
              "            title=\"Suggest charts.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "    background-color: #E8F0FE;\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: #1967D2;\n",
              "    height: 32px;\n",
              "    padding: 0 0 0 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart:hover {\n",
              "    background-color: #434B5C;\n",
              "    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "    fill: #FFFFFF;\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const charts = await google.colab.kernel.invokeFunction(\n",
              "          'suggestCharts', [key], {});\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-79293582-e6fc-41be-a582-7e12f63198f4 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 38
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Resultado do segundo modelo de recomendação híbrida com um usuário aleatório\n",
        "Recomendacao_Hibrida_SVD_TFIDF('AAAAA', 'Rafael Cristiano Batista')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 363
        },
        "outputId": "eb31b93b-3e2a-4302-eb9d-0d4a127eea3c",
        "id": "yhHQdmCAW51z"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                             name  \\\n",
              "48  Cintia Regina Oliveira Macedo   \n",
              "49                  Aline Machado   \n",
              "35    Ana Carolina Mendes Caixeta   \n",
              "38         Giovana Lourenço Crudi   \n",
              "63      Eliene Aparecida do Carmo   \n",
              "4                 Henrique Paixão   \n",
              "19      Larissa Favarão Bianchesi   \n",
              "32                 Fernanda Dudek   \n",
              "28       Ana Luiza Pereira Amaral   \n",
              "10   Delcia Gomes da Silva soares   \n",
              "\n",
              "                                                  bio  \\\n",
              "48  Seja bem vindo!, Sou psicóloga e psicanalista....   \n",
              "49  Atuo como psicóloga utilizando a abordagem psi...   \n",
              "35  Você tem se sentido mais ansioso e acredita qu...   \n",
              "38  Você quer melhorar sua qualidade de vida e de ...   \n",
              "63  . Graduação em Psicologia, pela Estácio de Sá....   \n",
              "4   Oi, eu sou o Henrique! Sou formado em Psicolog...   \n",
              "19                                               None   \n",
              "32  Você que chegou até meu perfil, seja muito bem...   \n",
              "28  Olá, que bom te ter aqui! Buscar ajuda não cos...   \n",
              "10  Olá: bem vindo-a,  ao nosso espaço psicológico...   \n",
              "\n",
              "                                           expertises total_ratings  \\\n",
              "48  Ansiedade, Casal, Compulsões, Conflitos Famili...            84   \n",
              "49  Acompanhamento psicológico de idosos, Ansiedad...           225   \n",
              "35  Ansiedade, Compulsões, Conflitos Amorosos, Con...           223   \n",
              "38  Ansiedade, Casamento, Conflitos Amorosos, Conf...            10   \n",
              "63  Ansiedade, Conflitos Familiares, Estresse Pós ...            65   \n",
              "4   Ansiedade, Casal, Compulsões, Dependência Quím...            15   \n",
              "19  Acompanhamento pessoal, Ansiedade, Casamento, ...           114   \n",
              "32  Acompanhamento psicológico de Gravidez, Acompa...            55   \n",
              "28  Ansiedade, Conflitos Amorosos, Depressão, Dese...           111   \n",
              "10  Acompanhamento psicológico de idosos, Ansiedad...           167   \n",
              "\n",
              "    avarage_rating  predicted_rating  similarity  \n",
              "48        4.988095          4.645162    0.696008  \n",
              "49        5.000000          4.643292    0.659237  \n",
              "35        4.995516          4.659556    0.601992  \n",
              "38        5.000000          4.654621    0.585399  \n",
              "63        4.984615          4.630526    0.576172  \n",
              "4         5.000000          4.762813    0.575421  \n",
              "19        5.000000          4.684741    0.567318  \n",
              "32        5.000000          4.663319    0.546246  \n",
              "28        5.000000          4.668393    0.533298  \n",
              "10        4.191617          4.718030    0.505049  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-254a6bd2-a64b-4d6c-bcd6-5f38376e3516\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>name</th>\n",
              "      <th>bio</th>\n",
              "      <th>expertises</th>\n",
              "      <th>total_ratings</th>\n",
              "      <th>avarage_rating</th>\n",
              "      <th>predicted_rating</th>\n",
              "      <th>similarity</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>Cintia Regina Oliveira Macedo</td>\n",
              "      <td>Seja bem vindo!, Sou psicóloga e psicanalista....</td>\n",
              "      <td>Ansiedade, Casal, Compulsões, Conflitos Famili...</td>\n",
              "      <td>84</td>\n",
              "      <td>4.988095</td>\n",
              "      <td>4.645162</td>\n",
              "      <td>0.696008</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>Aline Machado</td>\n",
              "      <td>Atuo como psicóloga utilizando a abordagem psi...</td>\n",
              "      <td>Acompanhamento psicológico de idosos, Ansiedad...</td>\n",
              "      <td>225</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>4.643292</td>\n",
              "      <td>0.659237</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>Ana Carolina Mendes Caixeta</td>\n",
              "      <td>Você tem se sentido mais ansioso e acredita qu...</td>\n",
              "      <td>Ansiedade, Compulsões, Conflitos Amorosos, Con...</td>\n",
              "      <td>223</td>\n",
              "      <td>4.995516</td>\n",
              "      <td>4.659556</td>\n",
              "      <td>0.601992</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>Giovana Lourenço Crudi</td>\n",
              "      <td>Você quer melhorar sua qualidade de vida e de ...</td>\n",
              "      <td>Ansiedade, Casamento, Conflitos Amorosos, Conf...</td>\n",
              "      <td>10</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>4.654621</td>\n",
              "      <td>0.585399</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>63</th>\n",
              "      <td>Eliene Aparecida do Carmo</td>\n",
              "      <td>. Graduação em Psicologia, pela Estácio de Sá....</td>\n",
              "      <td>Ansiedade, Conflitos Familiares, Estresse Pós ...</td>\n",
              "      <td>65</td>\n",
              "      <td>4.984615</td>\n",
              "      <td>4.630526</td>\n",
              "      <td>0.576172</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Henrique Paixão</td>\n",
              "      <td>Oi, eu sou o Henrique! Sou formado em Psicolog...</td>\n",
              "      <td>Ansiedade, Casal, Compulsões, Dependência Quím...</td>\n",
              "      <td>15</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>4.762813</td>\n",
              "      <td>0.575421</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>Larissa Favarão Bianchesi</td>\n",
              "      <td>None</td>\n",
              "      <td>Acompanhamento pessoal, Ansiedade, Casamento, ...</td>\n",
              "      <td>114</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>4.684741</td>\n",
              "      <td>0.567318</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>Fernanda Dudek</td>\n",
              "      <td>Você que chegou até meu perfil, seja muito bem...</td>\n",
              "      <td>Acompanhamento psicológico de Gravidez, Acompa...</td>\n",
              "      <td>55</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>4.663319</td>\n",
              "      <td>0.546246</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>Ana Luiza Pereira Amaral</td>\n",
              "      <td>Olá, que bom te ter aqui! Buscar ajuda não cos...</td>\n",
              "      <td>Ansiedade, Conflitos Amorosos, Depressão, Dese...</td>\n",
              "      <td>111</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>4.668393</td>\n",
              "      <td>0.533298</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Delcia Gomes da Silva soares</td>\n",
              "      <td>Olá: bem vindo-a,  ao nosso espaço psicológico...</td>\n",
              "      <td>Acompanhamento psicológico de idosos, Ansiedad...</td>\n",
              "      <td>167</td>\n",
              "      <td>4.191617</td>\n",
              "      <td>4.718030</td>\n",
              "      <td>0.505049</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-254a6bd2-a64b-4d6c-bcd6-5f38376e3516')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-254a6bd2-a64b-4d6c-bcd6-5f38376e3516 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-254a6bd2-a64b-4d6c-bcd6-5f38376e3516');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-f1c9e271-9df3-4ad3-b3ee-3bac139834f2\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-f1c9e271-9df3-4ad3-b3ee-3bac139834f2')\"\n",
              "            title=\"Suggest charts.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "    background-color: #E8F0FE;\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: #1967D2;\n",
              "    height: 32px;\n",
              "    padding: 0 0 0 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart:hover {\n",
              "    background-color: #434B5C;\n",
              "    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "    fill: #FFFFFF;\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const charts = await google.colab.kernel.invokeFunction(\n",
              "          'suggestCharts', [key], {});\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-f1c9e271-9df3-4ad3-b3ee-3bac139834f2 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 39
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "No cenário de ambos os modelos híbridos é possível observar uma maior variedade entre os psicólogos recomendados quando comparados com a recomendação por conteúdo, mostrando a capacidade de mitigar o problema de falta de variedade desse tipo de recomendação.\n",
        "\n",
        "Além disso, ambos os modelos também apresentaram uma melhora nos resultados do usuário inserido manualmente, mostrando a capacidade do modelo híbrido de mitigar o problema de cold start, que pode ter sido o motivo das notas mais baixas na recomendação colaborativa."
      ],
      "metadata": {
        "id": "lkwZNpAenf_7"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "Ao comparar os dois modelos entre si, é possível observar que ambos apresentam resultados positivos em termos de notas previstas, apesar do modelo SVD-TFIDF apresentar resultados melhores nos níveis de similaridade."
      ],
      "metadata": {
        "id": "2qTbwxNiu_iU"
      }
    }
  ]
}