display code.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "E_M5F2WKwxsE",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "41085745-096e-4836-b196-eb2de10d8847"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Collecting datatable\n",
            "  Downloading datatable-1.1.0-cp310-cp310-manylinux_2_35_x86_64.whl (82.0 MB)\n",
            "\u001b[2K     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m82.0/82.0 MB\u001b[0m \u001b[31m8.9 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
            "\u001b[?25hInstalling collected packages: datatable\n",
            "Successfully installed datatable-1.1.0\n"
          ]
        }
      ],
      "source": [
        "! pip install datatable\n",
        "# ! pip install flask"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "import pandas as pd\n",
        "import datatable as dt\n",
        "from IPython.display import display\n",
        "# from flask import Flask, render_template\n",
        "\n",
        "from google.colab import drive\n",
        "drive.mount('/content/drive')\n",
        "data_root = '/content/drive/My Drive/Colab Notebooks/chatbot'"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "K6Sy1qjKxH6a",
        "outputId": "6ec878f0-bdec-4b3d-ae27-d73ceeb58b24"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Drive already mounted at /content/drive; to attempt to forcibly remount, call drive.mount(\"/content/drive\", force_remount=True).\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "pd.set_option('display.max_colwidth', None)\n",
        "pd.set_option('display.max_rows', 4)\n",
        "pd.set_option('display.colheader_justify', 'center')\n",
        "\n",
        "my_df = dt.fread(data_root + '/dataframe_final_results.csv')\n",
        "my_df = my_df.to_pandas()\n",
        "\n",
        "# def display_options():\n",
        "\n",
        "#     display = pd.options.display\n",
        "#     display.max_columns = 5\n",
        "#     display.max_rows = 5\n",
        "#     display.max_colwidth = None\n",
        "#     display.width = None\n",
        "#     display.colheader_justify = 'center'\n",
        "#     return None"
      ],
      "metadata": {
        "id": "eGj8f7yX7zyu"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "#define the display function\n",
        "def get_hotels(df):\n",
        "    df = df.rename(columns={'name': 'Hotel_Name'})\n",
        "    print(\"Please tell us the following information:\")\n",
        "    destination = input(\"Which city will you travel to: \").lower()\n",
        "    review_sentiment_input  = input(\"Would you like Positive or Negative Reviews: \").lower()\n",
        "    category = input(\"Are you looking for reviews about certain topic? \\nPlease select from this list {price, service，safety,cleanliness, atmosphere, food, location, room, facility, staff}: \").lower()\n",
        "    category = [category.strip() for category in category.split(',')]\n",
        "    review_sentiment = 1 if review_sentiment_input  == 'positive' else 0\n",
        "\n",
        "    filtered_df = df[(df['city.name'].str.lower() == destination ) &\n",
        "                     (df['category_label'].str.lower().isin(category)) &\n",
        "                     (df['adjust_sentiment'] == review_sentiment)]\n",
        "\n",
        "    grouped_hotel =  filtered_df.groupby(['Hotel_Name'])['review_rating_overall'].mean().reset_index()\n",
        "\n",
        "    print('')\n",
        "    print(f'We have found {len(filtered_df.Hotel_Name.value_counts())} different hotels that meet your expectations.\\n')\n",
        "    print('Please find 3 of them below:')\n",
        "    if review_sentiment == 1:\n",
        "        print(grouped_hotel['Hotel_Name'].tail(3))\n",
        "    else:\n",
        "       print(grouped_hotel['Hotel_Name'].head(3))\n",
        "\n",
        "    print('')\n",
        "    print(f'Please find the Hotels in {destination} and have {review_sentiment_input} reviews about {category}.\\n')\n",
        "\n",
        "\n",
        "    if review_sentiment == 1:\n",
        "        top_hotels = filtered_df.sort_values(by='review_rating_overall', ascending= False)\n",
        "        top_hotels = top_hotels[['Hotel_Name', 'review_comment', 'address','review_rating_overall','category_label']]\n",
        "        display(top_hotels)\n",
        "    elif review_sentiment == 0:\n",
        "        bottom_hotels = filtered_df.sort_values(by='review_rating_overall', ascending= True)\n",
        "        bottom_hotels = bottom_hotels[['Hotel_Name', 'review_comment', 'address','review_rating_overall','category_label']]\n",
        "        display(bottom_hotels)\n",
        "    else:\n",
        "        print(\"Invalid review sentiment input. Please enter 'positive' or 'negative'.\")\n",
        "        return\n"
      ],
      "metadata": {
        "id": "Ei4GbDgCD7n2"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "get_hotels(df = my_df)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 594
        },
        "id": "aJcBI77RHrxh",
        "outputId": "4f35a4d5-73d2-4814-add7-b8320a445e68"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Please tell us the following information:\n",
            "Which city will you travel to: paris\n",
            "Would you like Positive or Negative Reviews: positive\n",
            "Are you looking for reviews about certain topic? \n",
            "Please select from this list {price, service，safety,cleanliness, atmosphere, food, location, room, facility, staff}: cleanliness\n",
            "\n",
            "We have found 2 different hotels that meet your expectations.\n",
            "\n",
            "Please find 3 of them below:\n",
            "0              JO&JOE Paris - Gentilly\n",
            "1    St Christopher's Inn Gare du Nord\n",
            "Name: Hotel_Name, dtype: object\n",
            "\n",
            "Please find the Hotels in paris and have positive reviews about ['cleanliness'].\n",
            "\n"
          ]
        },
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "                 Hotel_Name              \\\n",
              "2736            JO&JOE Paris - Gentilly   \n",
              "459             JO&JOE Paris - Gentilly   \n",
              "3013  St Christopher's Inn Gare du Nord   \n",
              "\n",
              "                                                                                                                                                                                                                                                 review_comment                                                                                                                                                                                                                                              \\\n",
              "2736                                                                                                                                                                                                                 Such a great hostel i had an amazing time, I do not recommend the cabin rooms though absolutely no air flow, the dorms looked like they had a good level of privacy so would stay in a mixed doom next time . Over all a great time in Paris and made wonderful friends at this hostel   \n",
              "459   It was very very clean for a hostel! The bathrooms were very nice and I felt comfortable using them. This was such a great experience for my first time in Paris. If you're travelling solo, you can meet people here who will visit the city with you, and there's nightlife events in the hostel if that's your interest!  Would just say that it can be difficult getting back super super late when subway is closed as it's outside of the main Paris City. Would 100% stay again and recommend!   \n",
              "3013                                                                                                                                                                                                                                                                                                                                                                                               Precious was absolutely amazing - so helpful. I didn’t stay for long but it was a great stay, thank you!   \n",
              "\n",
              "                           address                         \\\n",
              "2736  6 Etage - JO&JOE, 89 Avenue Paul Vaillant Couturier   \n",
              "459   6 Etage - JO&JOE, 89 Avenue Paul Vaillant Couturier   \n",
              "3013                                                        \n",
              "\n",
              "      review_rating_overall category_label  \n",
              "2736           100            cleanliness   \n",
              "459             97            cleanliness   \n",
              "3013            97            cleanliness   "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-a66427dd-efad-4454-bbd6-7c56234c61a4\" 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: center;\">\n",
              "      <th></th>\n",
              "      <th>Hotel_Name</th>\n",
              "      <th>review_comment</th>\n",
              "      <th>address</th>\n",
              "      <th>review_rating_overall</th>\n",
              "      <th>category_label</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2736</th>\n",
              "      <td>JO&amp;JOE Paris - Gentilly</td>\n",
              "      <td>Such a great hostel i had an amazing time, I do not recommend the cabin rooms though absolutely no air flow, the dorms looked like they had a good level of privacy so would stay in a mixed doom next time . Over all a great time in Paris and made wonderful friends at this hostel</td>\n",
              "      <td>6 Etage - JO&amp;JOE, 89 Avenue Paul Vaillant Couturier</td>\n",
              "      <td>100</td>\n",
              "      <td>cleanliness</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>459</th>\n",
              "      <td>JO&amp;JOE Paris - Gentilly</td>\n",
              "      <td>It was very very clean for a hostel! The bathrooms were very nice and I felt comfortable using them. This was such a great experience for my first time in Paris. If you're travelling solo, you can meet people here who will visit the city with you, and there's nightlife events in the hostel if that's your interest!  Would just say that it can be difficult getting back super super late when subway is closed as it's outside of the main Paris City. Would 100% stay again and recommend!</td>\n",
              "      <td>6 Etage - JO&amp;JOE, 89 Avenue Paul Vaillant Couturier</td>\n",
              "      <td>97</td>\n",
              "      <td>cleanliness</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3013</th>\n",
              "      <td>St Christopher's Inn Gare du Nord</td>\n",
              "      <td>Precious was absolutely amazing - so helpful. I didn’t stay for long but it was a great stay, thank you!</td>\n",
              "      <td></td>\n",
              "      <td>97</td>\n",
              "      <td>cleanliness</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-a66427dd-efad-4454-bbd6-7c56234c61a4')\"\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-a66427dd-efad-4454-bbd6-7c56234c61a4 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-a66427dd-efad-4454-bbd6-7c56234c61a4');\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-a224b142-053f-47e4-a29a-9de9bb00cbcd\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-a224b142-053f-47e4-a29a-9de9bb00cbcd')\"\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",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-a224b142-053f-47e4-a29a-9de9bb00cbcd button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "summary": "{\n  \"name\": \"get_hotels(df = my_df)\",\n  \"rows\": 3,\n  \"fields\": [\n    {\n      \"column\": \"Hotel_Name\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 2,\n        \"samples\": [\n          \"St Christopher's Inn Gare du Nord\",\n          \"JO&JOE Paris - Gentilly\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"review_comment\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 3,\n        \"samples\": [\n          \"Such a great hostel i had an amazing time, I do not recommend the cabin rooms though absolutely no air flow, the dorms looked like they had a good level of privacy so would stay in a mixed doom next time . Over all a great time in Paris and made wonderful friends at this hostel\",\n          \"It was very very clean for a hostel! The bathrooms were very nice and I felt comfortable using them. This was such a great experience for my first time in Paris. If you're travelling solo, you can meet people here who will visit the city with you, and there's nightlife events in the hostel if that's your interest!  Would just say that it can be difficult getting back super super late when subway is closed as it's outside of the main Paris City. Would 100% stay again and recommend!\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"address\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 2,\n        \"samples\": [\n          \"\",\n          \"6 Etage - JO&JOE, 89 Avenue Paul Vaillant Couturier\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"review_rating_overall\",\n      \"properties\": {\n        \"dtype\": \"int32\",\n        \"num_unique_values\": 2,\n        \"samples\": [\n          97,\n          100\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"category_label\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"cleanliness\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {}
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#another sample\n",
        "get_hotels(df = my_df)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 808
        },
        "id": "YGIVb8Hbdr1D",
        "outputId": "25a56529-2374-45c2-ac77-a7b73ef83ef3"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Please tell us the following information:\n",
            "Which city will you travel to: paris\n",
            "Would you like Positive or Negative Reviews: positive\n",
            "Are you looking for reviews about certain topic? \n",
            "Please select from this list {price, service，safety,cleanliness, atmosphere, food, location, room, facility, staff}: room, price\n",
            "\n",
            "We have found 6 different hotels that meet your expectations.\n",
            "\n",
            "Please find 3 of them below:\n",
            "3                 St Christopher's Inn Gare du Nord\n",
            "4    The People - Paris Belleville (ex Les Piaules)\n",
            "5                          The People - Paris Bercy\n",
            "Name: Hotel_Name, dtype: object\n",
            "\n",
            "Please find the Hotels in paris and have positive reviews about ['room', 'price'].\n",
            "\n"
          ]
        },
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "                        Hotel_Name                    \\\n",
              "4050  The People - Paris Belleville (ex Les Piaules)   \n",
              "3913                         JO&JOE Paris - Gentilly   \n",
              "...                                              ...   \n",
              "4315                                     MIJE Marais   \n",
              "2505                         JO&JOE Paris - Gentilly   \n",
              "\n",
              "                                                                                                                                                                                                                                                       review_comment                                                                                                                                                                                                                                                    \\\n",
              "4050  This was my second time staying here and have to once again give it a great rating. The location is excellent - near Oberkampf, the St Martin Canal, Parc Belleville AND Parc Butte Chaumont, not to mention TWO major metro stops. The rooftop patio is awesome (the quiet hours are lightly enforced, which is only bad if your room is there). The staff is friendly, the facilities clean and well maintained, and the bar always a fun place to meet people, grab a coffee or even read quietly. Great stay!   \n",
              "3913                                                                                                                                                                                                                                                                                                                  Superior staff who had patience helping me with issues on my phone!!!  Over and beyond helpful!!!!  The location so near to the train was VERY HELPFUL. It was a well thought out place!  Thanks.   \n",
              "...                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 ...   \n",
              "4315                                                                                                              Absolutely loved it here and would recommend it to anyone!! The location is great, the metro is close by and easy to use along with great shops and cafes right around the corner. I felt very lucky with those I shared a room with because there are no luggage lockers but fortunately I felt safe leaving my stuff around them. I know this may not be the case for others, so keep that in mind.   \n",
              "2505                                                                                                                                                                                                                                                                                                                          Nice place, good atmosphere and nice staff. However, Gentilly felt like quite a rough and unsafe area and was quite far from central Paris. Bathrooms felt dirty specifically the shower.   \n",
              "\n",
              "                           address                         \\\n",
              "4050                                                        \n",
              "3913  6 Etage - JO&JOE, 89 Avenue Paul Vaillant Couturier   \n",
              "...                                                   ...   \n",
              "4315                                                        \n",
              "2505  6 Etage - JO&JOE, 89 Avenue Paul Vaillant Couturier   \n",
              "\n",
              "      review_rating_overall category_label  \n",
              "4050           100                room      \n",
              "3913            97                room      \n",
              "...                     ...            ...  \n",
              "4315            83               price      \n",
              "2505            71               price      \n",
              "\n",
              "[14 rows x 5 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-b120c793-595a-414f-86da-4f2d1be05c79\" 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: center;\">\n",
              "      <th></th>\n",
              "      <th>Hotel_Name</th>\n",
              "      <th>review_comment</th>\n",
              "      <th>address</th>\n",
              "      <th>review_rating_overall</th>\n",
              "      <th>category_label</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>4050</th>\n",
              "      <td>The People - Paris Belleville (ex Les Piaules)</td>\n",
              "      <td>This was my second time staying here and have to once again give it a great rating. The location is excellent - near Oberkampf, the St Martin Canal, Parc Belleville AND Parc Butte Chaumont, not to mention TWO major metro stops. The rooftop patio is awesome (the quiet hours are lightly enforced, which is only bad if your room is there). The staff is friendly, the facilities clean and well maintained, and the bar always a fun place to meet people, grab a coffee or even read quietly. Great stay!</td>\n",
              "      <td></td>\n",
              "      <td>100</td>\n",
              "      <td>room</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3913</th>\n",
              "      <td>JO&amp;JOE Paris - Gentilly</td>\n",
              "      <td>Superior staff who had patience helping me with issues on my phone!!!  Over and beyond helpful!!!!  The location so near to the train was VERY HELPFUL. It was a well thought out place!  Thanks.</td>\n",
              "      <td>6 Etage - JO&amp;JOE, 89 Avenue Paul Vaillant Couturier</td>\n",
              "      <td>97</td>\n",
              "      <td>room</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>4315</th>\n",
              "      <td>MIJE Marais</td>\n",
              "      <td>Absolutely loved it here and would recommend it to anyone!! The location is great, the metro is close by and easy to use along with great shops and cafes right around the corner. I felt very lucky with those I shared a room with because there are no luggage lockers but fortunately I felt safe leaving my stuff around them. I know this may not be the case for others, so keep that in mind.</td>\n",
              "      <td></td>\n",
              "      <td>83</td>\n",
              "      <td>price</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2505</th>\n",
              "      <td>JO&amp;JOE Paris - Gentilly</td>\n",
              "      <td>Nice place, good atmosphere and nice staff. However, Gentilly felt like quite a rough and unsafe area and was quite far from central Paris. Bathrooms felt dirty specifically the shower.</td>\n",
              "      <td>6 Etage - JO&amp;JOE, 89 Avenue Paul Vaillant Couturier</td>\n",
              "      <td>71</td>\n",
              "      <td>price</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>14 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-b120c793-595a-414f-86da-4f2d1be05c79')\"\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-b120c793-595a-414f-86da-4f2d1be05c79 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-b120c793-595a-414f-86da-4f2d1be05c79');\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-07b7d4eb-1571-41d7-8d52-e629307bd811\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-07b7d4eb-1571-41d7-8d52-e629307bd811')\"\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",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-07b7d4eb-1571-41d7-8d52-e629307bd811 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "summary": "{\n  \"name\": \"get_hotels(df = my_df)\",\n  \"rows\": 14,\n  \"fields\": [\n    {\n      \"column\": \"Hotel_Name\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 6,\n        \"samples\": [\n          \"The People - Paris Belleville (ex Les Piaules)\",\n          \"JO&JOE Paris - Gentilly\",\n          \"The People - Paris Bercy\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"review_comment\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 14,\n        \"samples\": [\n          \"Nice area to lounge in, the bar is small but still nice, and the terrace on the roof is beautiful. The staff is good. There is only one elevator and it's slow though.\",\n          \"The staff here were really incredibly friendly and tried to create a social environment, making it easy to meet people. I liked the room layout, a good size with privacy curtains and an ensuite shower and toilet room. It was also very clean. It is located in a nice neighbourhood, close to the metro. However, it is far away from popular landmarks and attractions. It felt a little more like a hotel then a hostel, and was on the pricer side, but that seems to be the norm for hostels in Paris.\",\n          \"This was my second time staying here and have to once again give it a great rating. The location is excellent - near Oberkampf, the St Martin Canal, Parc Belleville AND Parc Butte Chaumont, not to mention TWO major metro stops. The rooftop patio is awesome (the quiet hours are lightly enforced, which is only bad if your room is there). The staff is friendly, the facilities clean and well maintained, and the bar always a fun place to meet people, grab a coffee or even read quietly. Great stay!\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"address\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 3,\n        \"samples\": [\n          \"\",\n          \"6 Etage - JO&JOE, 89 Avenue Paul Vaillant Couturier\",\n          \"a, 245 Rue La Fayette\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"review_rating_overall\",\n      \"properties\": {\n        \"dtype\": \"int32\",\n        \"num_unique_values\": 8,\n        \"samples\": [\n          97,\n          86,\n          100\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"category_label\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 2,\n        \"samples\": [\n          \"price\",\n          \"room\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {}
        }
      ]
    }
  ]
}