23_ntb_loading_Json.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "authorship_tag": "ABX9TyOP7RPGxi7MtbuvWq8zhxim",
      "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/luasampaio/data-engineering/blob/main/23_ntb_loading_Json.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# O projeto como um todo seguirá as etapas abaixo.\n",
        "\n",
        " - Coleta de Dados\n",
        " - Análise Exploratória\n",
        " - Tratamento dos Dados"
      ],
      "metadata": {
        "id": "LW1WY5c4KEUP"
      }
    },
    {
      "source": [
        "import pandas as pd\n",
        "\n",
        "# Modify the URL to access the raw JSON data\n",
        "url = 'https://raw.githubusercontent.com/luasampaio/datasets/main/dados_hospedagem.json'\n",
        "\n",
        "df = pd.read_json(url)"
      ],
      "cell_type": "code",
      "metadata": {
        "id": "RG5HjWCJyH9K"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df = pd.json_normalize(df['info_moveis'])\n",
        "df"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 754
        },
        "id": "tH6gI64JyKlr",
        "outputId": "94068108-8c89-4b35-f50f-ec1a9f4f286b"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   avaliacao_geral experiencia_local max_hospedes  \\\n",
              "0             10.0                --            1   \n",
              "1             10.0                --           10   \n",
              "2             10.0                --           11   \n",
              "3             10.0                --           12   \n",
              "4             10.0                --           14   \n",
              "..             ...               ...          ...   \n",
              "65             nan                --            5   \n",
              "66             nan                --            6   \n",
              "67             nan                --            7   \n",
              "68             nan                --            8   \n",
              "69             nan                --            9   \n",
              "\n",
              "                                      descricao_local  \\\n",
              "0   [This clean and comfortable one bedroom sits r...   \n",
              "1   [Welcome to the heart of the 'Ballard Brewery ...   \n",
              "2   [New modern house built in 2013.  Spectacular ...   \n",
              "3   [Our NW style home is 3200+ sq ft with 3 level...   \n",
              "4   [Perfect for groups. 2 bedrooms, full bathroom...   \n",
              "..                                                ...   \n",
              "65  [Our cozy little bungalow is the perfect place...   \n",
              "66  [Bright clean 2 bedroom 1 bath appartment in t...   \n",
              "67  [Beautiful end-unit townhome with lots of dayl...   \n",
              "68  [Heart of Ballard new townhome with 4 BRs + ba...   \n",
              "69  [This business-themed modern home features:  *...   \n",
              "\n",
              "                                 descricao_vizinhanca  \\\n",
              "0   [Lower Queen Anne is near the Seattle Center (...   \n",
              "1   [--, Capital Hill is the heart of Seattle, bor...   \n",
              "2   [Upper Queen Anne is a charming neighborhood f...   \n",
              "3   [The Views from our top floor!  Wallingford ha...   \n",
              "4   [Safeway grocery store within walking distance...   \n",
              "..                                                ...   \n",
              "65  [The Queen Anne neighborhood is one of the mos...   \n",
              "66  [Ballard is the most interesting and ecclectic...   \n",
              "67  [Cherry blossoms (Sakura) in the spring, every...   \n",
              "68  [--, --, The suite is conveniently located off...   \n",
              "69  [Your hosts made Madison Valley their home whe...   \n",
              "\n",
              "                                 quantidade_banheiros  \\\n",
              "0   [1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, ...   \n",
              "1                   [2, 3, 2, 3, 3, 3, 2, 1, 2, 2, 2]   \n",
              "2                                                 [4]   \n",
              "3                            [3, 3, 3, 3, 3, 3, 3, 3]   \n",
              "4                                              [2, 3]   \n",
              "..                                                ...   \n",
              "65  [1, 3, 2, 2, 2, 1, 2, 1, 1, 1, 2, 3, 2, 2, 2, ...   \n",
              "66  [1, 1, 3, 2, 1, 3, 2, 2, 1, 2, 2, 2, 1, 2, 1, ...   \n",
              "67                     [4, 3, 1, 2, 2, 1, 2, 1, 2, 2]   \n",
              "68  [2, 2, 3, 1, 1, 2, 1, 3, 2, 1, 2, 1, 2, 2, 2, ...   \n",
              "69                                             [2, 1]   \n",
              "\n",
              "                                   quantidade_quartos  \\\n",
              "0   [1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, ...   \n",
              "1                   [3, 4, 2, 3, 3, 3, 3, 3, 3, 4, 3]   \n",
              "2                                                 [5]   \n",
              "3                            [6, 6, 5, 5, 5, 5, 4, 4]   \n",
              "4                                              [2, 6]   \n",
              "..                                                ...   \n",
              "65  [2, 2, 2, 3, 2, 2, 2, 2, 2, 2, 2, 3, 2, 2, 2, ...   \n",
              "66  [2, 3, 3, 2, 2, 3, 2, 3, 2, 2, 2, 2, 4, 3, 3, ...   \n",
              "67                     [3, 4, 3, 3, 3, 3, 3, 3, 3, 4]   \n",
              "68  [4, 2, 3, 4, 3, 3, 4, 4, 3, 5, 2, 3, 3, 4, 5, ...   \n",
              "69                                             [3, 4]   \n",
              "\n",
              "                                     quantidade_camas  \\\n",
              "0   [1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, ...   \n",
              "1                   [5, 6, 8, 3, 3, 5, 4, 5, 6, 7, 4]   \n",
              "2                                                 [7]   \n",
              "3                            [6, 6, 7, 8, 7, 7, 6, 6]   \n",
              "4                                              [3, 9]   \n",
              "..                                                ...   \n",
              "65  [3, 2, 2, 3, 3, 2, 3, 2, 2, 3, 3, 3, 2, 3, 2, ...   \n",
              "66  [3, 3, 2, 3, 3, 3, 2, 3, 3, 3, 2, 2, 4, 4, 3, ...   \n",
              "67                     [3, 5, 1, 5, 3, 2, 3, 4, 4, 4]   \n",
              "68  [4, 4, 3, 3, 5, 5, 5, 5, 3, 5, 4, 5, 5, 4, 1, ...   \n",
              "69                                             [6, 6]   \n",
              "\n",
              "                                          modelo_cama  \\\n",
              "0   [Real Bed, Futon, Futon, Pull-out Sofa, Real B...   \n",
              "1   [Real Bed, Real Bed, Real Bed, Real Bed, Real ...   \n",
              "2                                          [Real Bed]   \n",
              "3   [Real Bed, Real Bed, Real Bed, Real Bed, Real ...   \n",
              "4                                [Real Bed, Real Bed]   \n",
              "..                                                ...   \n",
              "65  [Real Bed, Real Bed, Real Bed, Real Bed, Real ...   \n",
              "66  [Real Bed, Real Bed, Real Bed, Real Bed, Real ...   \n",
              "67  [Real Bed, Real Bed, Real Bed, Real Bed, Real ...   \n",
              "68  [Real Bed, Real Bed, Real Bed, Real Bed, Real ...   \n",
              "69                               [Real Bed, Real Bed]   \n",
              "\n",
              "                                          comodidades  \\\n",
              "0   [{Internet,\"Wireless Internet\",Kitchen,\"Free P...   \n",
              "1   [{TV,Internet,\"Wireless Internet\",Kitchen,\"Fre...   \n",
              "2   [{TV,\"Cable TV\",Internet,\"Wireless Internet\",\"...   \n",
              "3   [{Internet,\"Wireless Internet\",Kitchen,\"Free P...   \n",
              "4   [{TV,Internet,\"Wireless Internet\",Kitchen,\"Fre...   \n",
              "..                                                ...   \n",
              "65  [{\"Cable TV\",\"Wireless Internet\",Kitchen,\"Free...   \n",
              "66  [{TV,\"Cable TV\",Internet,\"Wireless Internet\",K...   \n",
              "67  [{TV,\"Cable TV\",Internet,\"Wireless Internet\",\"...   \n",
              "68  [{TV,Internet,\"Wireless Internet\",\"Air Conditi...   \n",
              "69  [{TV,\"Cable TV\",Internet,\"Wireless Internet\",\"...   \n",
              "\n",
              "                                        taxa_deposito  \\\n",
              "0   [$0, $0, $0, $0, $0, $350.00, $350.00, $350.00...   \n",
              "1   [$500.00, $300.00, $0, $300.00, $300.00, $360....   \n",
              "2                                         [$1,000.00]   \n",
              "3   [$500.00, $500.00, $500.00, $500.00, $500.00, ...   \n",
              "4                                [$300.00, $2,000.00]   \n",
              "..                                                ...   \n",
              "65  [$250.00, $200.00, $0, $0, $0, $200.00, $350.0...   \n",
              "66  [$200.00, $200.00, $100.00, $0, $0, $750.00, $...   \n",
              "67  [$750.00, $350.00, $500.00, $500.00, $0, $200....   \n",
              "68  [$500.00, $150.00, $250.00, $800.00, $0, $500....   \n",
              "69                               [$1,000.00, $500.00]   \n",
              "\n",
              "                                         taxa_limpeza  \\\n",
              "0   [$0, $0, $0, $20.00, $15.00, $28.00, $35.00, $...   \n",
              "1   [$125.00, $100.00, $85.00, $110.00, $110.00, $...   \n",
              "2                                           [$300.00]   \n",
              "3   [$225.00, $300.00, $250.00, $250.00, $250.00, ...   \n",
              "4                                   [$40.00, $150.00]   \n",
              "..                                                ...   \n",
              "65  [$35.00, $50.00, $100.00, $100.00, $0, $30.00,...   \n",
              "66  [$0, $0, $100.00, $0, $75.00, $140.00, $112.00...   \n",
              "67  [$300.00, $90.00, $250.00, $100.00, $109.00, $...   \n",
              "68  [$50.00, $85.00, $150.00, $75.00, $100.00, $80...   \n",
              "69                                      [$150.00, $0]   \n",
              "\n",
              "                                                preco  \n",
              "0   [$110.00, $45.00, $55.00, $52.00, $85.00, $50....  \n",
              "1   [$350.00, $300.00, $425.00, $300.00, $285.00, ...  \n",
              "2                                           [$975.00]  \n",
              "3   [$490.00, $550.00, $350.00, $350.00, $350.00, ...  \n",
              "4                                  [$200.00, $545.00]  \n",
              "..                                                ...  \n",
              "65  [$150.00, $200.00, $143.00, $150.00, $350.00, ...  \n",
              "66  [$99.00, $185.00, $250.00, $200.00, $275.00, $...  \n",
              "67  [$218.00, $350.00, $450.00, $149.00, $99.00, $...  \n",
              "68  [$275.00, $199.00, $400.00, $325.00, $300.00, ...  \n",
              "69                                 [$250.00, $350.00]  \n",
              "\n",
              "[70 rows x 13 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-23ce4f25-4fef-4e3b-bbaf-dfbfe8ee0660\" 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>avaliacao_geral</th>\n",
              "      <th>experiencia_local</th>\n",
              "      <th>max_hospedes</th>\n",
              "      <th>descricao_local</th>\n",
              "      <th>descricao_vizinhanca</th>\n",
              "      <th>quantidade_banheiros</th>\n",
              "      <th>quantidade_quartos</th>\n",
              "      <th>quantidade_camas</th>\n",
              "      <th>modelo_cama</th>\n",
              "      <th>comodidades</th>\n",
              "      <th>taxa_deposito</th>\n",
              "      <th>taxa_limpeza</th>\n",
              "      <th>preco</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>10.0</td>\n",
              "      <td>--</td>\n",
              "      <td>1</td>\n",
              "      <td>[This clean and comfortable one bedroom sits r...</td>\n",
              "      <td>[Lower Queen Anne is near the Seattle Center (...</td>\n",
              "      <td>[1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, ...</td>\n",
              "      <td>[1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, ...</td>\n",
              "      <td>[1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, ...</td>\n",
              "      <td>[Real Bed, Futon, Futon, Pull-out Sofa, Real B...</td>\n",
              "      <td>[{Internet,\"Wireless Internet\",Kitchen,\"Free P...</td>\n",
              "      <td>[$0, $0, $0, $0, $0, $350.00, $350.00, $350.00...</td>\n",
              "      <td>[$0, $0, $0, $20.00, $15.00, $28.00, $35.00, $...</td>\n",
              "      <td>[$110.00, $45.00, $55.00, $52.00, $85.00, $50....</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>10.0</td>\n",
              "      <td>--</td>\n",
              "      <td>10</td>\n",
              "      <td>[Welcome to the heart of the 'Ballard Brewery ...</td>\n",
              "      <td>[--, Capital Hill is the heart of Seattle, bor...</td>\n",
              "      <td>[2, 3, 2, 3, 3, 3, 2, 1, 2, 2, 2]</td>\n",
              "      <td>[3, 4, 2, 3, 3, 3, 3, 3, 3, 4, 3]</td>\n",
              "      <td>[5, 6, 8, 3, 3, 5, 4, 5, 6, 7, 4]</td>\n",
              "      <td>[Real Bed, Real Bed, Real Bed, Real Bed, Real ...</td>\n",
              "      <td>[{TV,Internet,\"Wireless Internet\",Kitchen,\"Fre...</td>\n",
              "      <td>[$500.00, $300.00, $0, $300.00, $300.00, $360....</td>\n",
              "      <td>[$125.00, $100.00, $85.00, $110.00, $110.00, $...</td>\n",
              "      <td>[$350.00, $300.00, $425.00, $300.00, $285.00, ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>10.0</td>\n",
              "      <td>--</td>\n",
              "      <td>11</td>\n",
              "      <td>[New modern house built in 2013.  Spectacular ...</td>\n",
              "      <td>[Upper Queen Anne is a charming neighborhood f...</td>\n",
              "      <td>[4]</td>\n",
              "      <td>[5]</td>\n",
              "      <td>[7]</td>\n",
              "      <td>[Real Bed]</td>\n",
              "      <td>[{TV,\"Cable TV\",Internet,\"Wireless Internet\",\"...</td>\n",
              "      <td>[$1,000.00]</td>\n",
              "      <td>[$300.00]</td>\n",
              "      <td>[$975.00]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>10.0</td>\n",
              "      <td>--</td>\n",
              "      <td>12</td>\n",
              "      <td>[Our NW style home is 3200+ sq ft with 3 level...</td>\n",
              "      <td>[The Views from our top floor!  Wallingford ha...</td>\n",
              "      <td>[3, 3, 3, 3, 3, 3, 3, 3]</td>\n",
              "      <td>[6, 6, 5, 5, 5, 5, 4, 4]</td>\n",
              "      <td>[6, 6, 7, 8, 7, 7, 6, 6]</td>\n",
              "      <td>[Real Bed, Real Bed, Real Bed, Real Bed, Real ...</td>\n",
              "      <td>[{Internet,\"Wireless Internet\",Kitchen,\"Free P...</td>\n",
              "      <td>[$500.00, $500.00, $500.00, $500.00, $500.00, ...</td>\n",
              "      <td>[$225.00, $300.00, $250.00, $250.00, $250.00, ...</td>\n",
              "      <td>[$490.00, $550.00, $350.00, $350.00, $350.00, ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>10.0</td>\n",
              "      <td>--</td>\n",
              "      <td>14</td>\n",
              "      <td>[Perfect for groups. 2 bedrooms, full bathroom...</td>\n",
              "      <td>[Safeway grocery store within walking distance...</td>\n",
              "      <td>[2, 3]</td>\n",
              "      <td>[2, 6]</td>\n",
              "      <td>[3, 9]</td>\n",
              "      <td>[Real Bed, Real Bed]</td>\n",
              "      <td>[{TV,Internet,\"Wireless Internet\",Kitchen,\"Fre...</td>\n",
              "      <td>[$300.00, $2,000.00]</td>\n",
              "      <td>[$40.00, $150.00]</td>\n",
              "      <td>[$200.00, $545.00]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>65</th>\n",
              "      <td>nan</td>\n",
              "      <td>--</td>\n",
              "      <td>5</td>\n",
              "      <td>[Our cozy little bungalow is the perfect place...</td>\n",
              "      <td>[The Queen Anne neighborhood is one of the mos...</td>\n",
              "      <td>[1, 3, 2, 2, 2, 1, 2, 1, 1, 1, 2, 3, 2, 2, 2, ...</td>\n",
              "      <td>[2, 2, 2, 3, 2, 2, 2, 2, 2, 2, 2, 3, 2, 2, 2, ...</td>\n",
              "      <td>[3, 2, 2, 3, 3, 2, 3, 2, 2, 3, 3, 3, 2, 3, 2, ...</td>\n",
              "      <td>[Real Bed, Real Bed, Real Bed, Real Bed, Real ...</td>\n",
              "      <td>[{\"Cable TV\",\"Wireless Internet\",Kitchen,\"Free...</td>\n",
              "      <td>[$250.00, $200.00, $0, $0, $0, $200.00, $350.0...</td>\n",
              "      <td>[$35.00, $50.00, $100.00, $100.00, $0, $30.00,...</td>\n",
              "      <td>[$150.00, $200.00, $143.00, $150.00, $350.00, ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>66</th>\n",
              "      <td>nan</td>\n",
              "      <td>--</td>\n",
              "      <td>6</td>\n",
              "      <td>[Bright clean 2 bedroom 1 bath appartment in t...</td>\n",
              "      <td>[Ballard is the most interesting and ecclectic...</td>\n",
              "      <td>[1, 1, 3, 2, 1, 3, 2, 2, 1, 2, 2, 2, 1, 2, 1, ...</td>\n",
              "      <td>[2, 3, 3, 2, 2, 3, 2, 3, 2, 2, 2, 2, 4, 3, 3, ...</td>\n",
              "      <td>[3, 3, 2, 3, 3, 3, 2, 3, 3, 3, 2, 2, 4, 4, 3, ...</td>\n",
              "      <td>[Real Bed, Real Bed, Real Bed, Real Bed, Real ...</td>\n",
              "      <td>[{TV,\"Cable TV\",Internet,\"Wireless Internet\",K...</td>\n",
              "      <td>[$200.00, $200.00, $100.00, $0, $0, $750.00, $...</td>\n",
              "      <td>[$0, $0, $100.00, $0, $75.00, $140.00, $112.00...</td>\n",
              "      <td>[$99.00, $185.00, $250.00, $200.00, $275.00, $...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>67</th>\n",
              "      <td>nan</td>\n",
              "      <td>--</td>\n",
              "      <td>7</td>\n",
              "      <td>[Beautiful end-unit townhome with lots of dayl...</td>\n",
              "      <td>[Cherry blossoms (Sakura) in the spring, every...</td>\n",
              "      <td>[4, 3, 1, 2, 2, 1, 2, 1, 2, 2]</td>\n",
              "      <td>[3, 4, 3, 3, 3, 3, 3, 3, 3, 4]</td>\n",
              "      <td>[3, 5, 1, 5, 3, 2, 3, 4, 4, 4]</td>\n",
              "      <td>[Real Bed, Real Bed, Real Bed, Real Bed, Real ...</td>\n",
              "      <td>[{TV,\"Cable TV\",Internet,\"Wireless Internet\",\"...</td>\n",
              "      <td>[$750.00, $350.00, $500.00, $500.00, $0, $200....</td>\n",
              "      <td>[$300.00, $90.00, $250.00, $100.00, $109.00, $...</td>\n",
              "      <td>[$218.00, $350.00, $450.00, $149.00, $99.00, $...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>68</th>\n",
              "      <td>nan</td>\n",
              "      <td>--</td>\n",
              "      <td>8</td>\n",
              "      <td>[Heart of Ballard new townhome with 4 BRs + ba...</td>\n",
              "      <td>[--, --, The suite is conveniently located off...</td>\n",
              "      <td>[2, 2, 3, 1, 1, 2, 1, 3, 2, 1, 2, 1, 2, 2, 2, ...</td>\n",
              "      <td>[4, 2, 3, 4, 3, 3, 4, 4, 3, 5, 2, 3, 3, 4, 5, ...</td>\n",
              "      <td>[4, 4, 3, 3, 5, 5, 5, 5, 3, 5, 4, 5, 5, 4, 1, ...</td>\n",
              "      <td>[Real Bed, Real Bed, Real Bed, Real Bed, Real ...</td>\n",
              "      <td>[{TV,Internet,\"Wireless Internet\",\"Air Conditi...</td>\n",
              "      <td>[$500.00, $150.00, $250.00, $800.00, $0, $500....</td>\n",
              "      <td>[$50.00, $85.00, $150.00, $75.00, $100.00, $80...</td>\n",
              "      <td>[$275.00, $199.00, $400.00, $325.00, $300.00, ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>69</th>\n",
              "      <td>nan</td>\n",
              "      <td>--</td>\n",
              "      <td>9</td>\n",
              "      <td>[This business-themed modern home features:  *...</td>\n",
              "      <td>[Your hosts made Madison Valley their home whe...</td>\n",
              "      <td>[2, 1]</td>\n",
              "      <td>[3, 4]</td>\n",
              "      <td>[6, 6]</td>\n",
              "      <td>[Real Bed, Real Bed]</td>\n",
              "      <td>[{TV,\"Cable TV\",Internet,\"Wireless Internet\",\"...</td>\n",
              "      <td>[$1,000.00, $500.00]</td>\n",
              "      <td>[$150.00, $0]</td>\n",
              "      <td>[$250.00, $350.00]</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>70 rows × 13 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-23ce4f25-4fef-4e3b-bbaf-dfbfe8ee0660')\"\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-23ce4f25-4fef-4e3b-bbaf-dfbfe8ee0660 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-23ce4f25-4fef-4e3b-bbaf-dfbfe8ee0660');\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-6c8c25cf-9ec4-4626-b28d-aef4b13093f0\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-6c8c25cf-9ec4-4626-b28d-aef4b13093f0')\"\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-6c8c25cf-9ec4-4626-b28d-aef4b13093f0 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "  <div id=\"id_545aa0c8-6058-4554-8b61-52984cb46ae2\">\n",
              "    <style>\n",
              "      .colab-df-generate {\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-generate: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-generate {\n",
              "        background-color: #3B4455;\n",
              "        fill: #D2E3FC;\n",
              "      }\n",
              "\n",
              "      [theme=dark] .colab-df-generate: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",
              "    <button class=\"colab-df-generate\" onclick=\"generateWithVariable('df')\"\n",
              "            title=\"Generate code using this dataframe.\"\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",
              "    <path d=\"M7,19H8.4L18.45,9,17,7.55,7,17.6ZM5,21V16.75L18.45,3.32a2,2,0,0,1,2.83,0l1.4,1.43a1.91,1.91,0,0,1,.58,1.4,1.91,1.91,0,0,1-.58,1.4L9.25,21ZM18.45,9,17,7.55Zm-12,3A5.31,5.31,0,0,0,4.9,8.1,5.31,5.31,0,0,0,1,6.5,5.31,5.31,0,0,0,4.9,4.9,5.31,5.31,0,0,0,6.5,1,5.31,5.31,0,0,0,8.1,4.9,5.31,5.31,0,0,0,12,6.5,5.46,5.46,0,0,0,6.5,12Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "    <script>\n",
              "      (() => {\n",
              "      const buttonEl =\n",
              "        document.querySelector('#id_545aa0c8-6058-4554-8b61-52984cb46ae2 button.colab-df-generate');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      buttonEl.onclick = () => {\n",
              "        google.colab.notebook.generateWithVariable('df');\n",
              "      }\n",
              "      })();\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "df",
              "summary": "{\n  \"name\": \"df\",\n  \"rows\": 70,\n  \"fields\": [\n    {\n      \"column\": \"avaliacao_geral\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 9,\n        \"samples\": [\n          \"9.0\",\n          \"2.0\",\n          \"7.0\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"experiencia_local\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"--\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"max_hospedes\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 15,\n        \"samples\": [\n          \"5\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"descricao_local\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"descricao_vizinhanca\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"quantidade_banheiros\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"quantidade_quartos\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"quantidade_camas\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"modelo_cama\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"comodidades\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"taxa_deposito\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"taxa_limpeza\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"preco\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "colunas = list(df.columns)\n",
        "colunas"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "A_li8wAsyWYa",
        "outputId": "db048d15-3031-4a59-90d4-f83790c4d8dc"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "['avaliacao_geral',\n",
              " 'experiencia_local',\n",
              " 'max_hospedes',\n",
              " 'descricao_local',\n",
              " 'descricao_vizinhanca',\n",
              " 'quantidade_banheiros',\n",
              " 'quantidade_quartos',\n",
              " 'quantidade_camas',\n",
              " 'modelo_cama',\n",
              " 'comodidades',\n",
              " 'taxa_deposito',\n",
              " 'taxa_limpeza',\n",
              " 'preco']"
            ]
          },
          "metadata": {},
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "dados = df.explode(colunas[3:])\n",
        "dados"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "DP-3-MNqyYwf",
        "outputId": "eb9c90a2-0cb2-4985-80fe-5c2232e4b7e0"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   avaliacao_geral experiencia_local max_hospedes  \\\n",
              "0             10.0                --            1   \n",
              "0             10.0                --            1   \n",
              "0             10.0                --            1   \n",
              "0             10.0                --            1   \n",
              "0             10.0                --            1   \n",
              "..             ...               ...          ...   \n",
              "68             nan                --            8   \n",
              "68             nan                --            8   \n",
              "68             nan                --            8   \n",
              "69             nan                --            9   \n",
              "69             nan                --            9   \n",
              "\n",
              "                                      descricao_local  \\\n",
              "0   This clean and comfortable one bedroom sits ri...   \n",
              "0   Our century old Upper Queen Anne house is loca...   \n",
              "0   Cozy room in two-bedroom apartment along the l...   \n",
              "0   Very lovely and cozy room for one. Convenientl...   \n",
              "0   The “Studio at Mibbett Hollow' is in a Beautif...   \n",
              "..                                                ...   \n",
              "68  Beautiful craftsman home in the historic Wedgw...   \n",
              "68  Located in a very easily accessible area of Se...   \n",
              "68  This home is fully furnished and available wee...   \n",
              "69  This business-themed modern home features:  *H...   \n",
              "69  This welcoming home is in the quiet residentia...   \n",
              "\n",
              "                                 descricao_vizinhanca quantidade_banheiros  \\\n",
              "0   Lower Queen Anne is near the Seattle Center (s...                    1   \n",
              "0   Upper Queen Anne is a really pleasant, unique ...                    1   \n",
              "0   The convenience of being in Seattle but on the...                    1   \n",
              "0   Ballard is lovely, vibrant and one of the most...                    1   \n",
              "0                                                  --                    1   \n",
              "..                                                ...                  ...   \n",
              "68                                                 --                    3   \n",
              "68  Quiet, dead end street near I-5. The proximity...                    2   \n",
              "68                                                 --                    1   \n",
              "69  Your hosts made Madison Valley their home when...                    2   \n",
              "69  Despite the quiet, leafy streets of this resid...                    1   \n",
              "\n",
              "   quantidade_quartos quantidade_camas    modelo_cama  \\\n",
              "0                   1                1       Real Bed   \n",
              "0                   1                1          Futon   \n",
              "0                   1                1          Futon   \n",
              "0                   1                1  Pull-out Sofa   \n",
              "0                   1                1       Real Bed   \n",
              "..                ...              ...            ...   \n",
              "68                  4                5       Real Bed   \n",
              "68                  4                4       Real Bed   \n",
              "68                  3                4       Real Bed   \n",
              "69                  3                6       Real Bed   \n",
              "69                  4                6       Real Bed   \n",
              "\n",
              "                                          comodidades taxa_deposito  \\\n",
              "0   {Internet,\"Wireless Internet\",Kitchen,\"Free Pa...            $0   \n",
              "0   {TV,Internet,\"Wireless Internet\",Kitchen,\"Free...            $0   \n",
              "0   {TV,Internet,\"Wireless Internet\",Kitchen,\"Free...            $0   \n",
              "0   {Internet,\"Wireless Internet\",Kitchen,\"Free Pa...            $0   \n",
              "0   {\"Wireless Internet\",Kitchen,\"Free Parking on ...            $0   \n",
              "..                                                ...           ...   \n",
              "68  {TV,\"Cable TV\",Internet,\"Wireless Internet\",\"A...     $1,000.00   \n",
              "68  {TV,\"Cable TV\",Internet,\"Wireless Internet\",Ki...            $0   \n",
              "68  {TV,\"Cable TV\",Internet,\"Wireless Internet\",\"A...            $0   \n",
              "69  {TV,\"Cable TV\",Internet,\"Wireless Internet\",\"A...     $1,000.00   \n",
              "69  {TV,Internet,\"Wireless Internet\",Kitchen,\"Free...       $500.00   \n",
              "\n",
              "   taxa_limpeza    preco  \n",
              "0            $0  $110.00  \n",
              "0            $0   $45.00  \n",
              "0            $0   $55.00  \n",
              "0        $20.00   $52.00  \n",
              "0        $15.00   $85.00  \n",
              "..          ...      ...  \n",
              "68      $178.00  $299.00  \n",
              "68       $99.00  $199.00  \n",
              "68           $0  $400.00  \n",
              "69      $150.00  $250.00  \n",
              "69           $0  $350.00  \n",
              "\n",
              "[3818 rows x 13 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-4d8e2a45-a5f1-46db-b919-ea17e64117ac\" 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>avaliacao_geral</th>\n",
              "      <th>experiencia_local</th>\n",
              "      <th>max_hospedes</th>\n",
              "      <th>descricao_local</th>\n",
              "      <th>descricao_vizinhanca</th>\n",
              "      <th>quantidade_banheiros</th>\n",
              "      <th>quantidade_quartos</th>\n",
              "      <th>quantidade_camas</th>\n",
              "      <th>modelo_cama</th>\n",
              "      <th>comodidades</th>\n",
              "      <th>taxa_deposito</th>\n",
              "      <th>taxa_limpeza</th>\n",
              "      <th>preco</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>10.0</td>\n",
              "      <td>--</td>\n",
              "      <td>1</td>\n",
              "      <td>This clean and comfortable one bedroom sits ri...</td>\n",
              "      <td>Lower Queen Anne is near the Seattle Center (s...</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>Real Bed</td>\n",
              "      <td>{Internet,\"Wireless Internet\",Kitchen,\"Free Pa...</td>\n",
              "      <td>$0</td>\n",
              "      <td>$0</td>\n",
              "      <td>$110.00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>10.0</td>\n",
              "      <td>--</td>\n",
              "      <td>1</td>\n",
              "      <td>Our century old Upper Queen Anne house is loca...</td>\n",
              "      <td>Upper Queen Anne is a really pleasant, unique ...</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>Futon</td>\n",
              "      <td>{TV,Internet,\"Wireless Internet\",Kitchen,\"Free...</td>\n",
              "      <td>$0</td>\n",
              "      <td>$0</td>\n",
              "      <td>$45.00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>10.0</td>\n",
              "      <td>--</td>\n",
              "      <td>1</td>\n",
              "      <td>Cozy room in two-bedroom apartment along the l...</td>\n",
              "      <td>The convenience of being in Seattle but on the...</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>Futon</td>\n",
              "      <td>{TV,Internet,\"Wireless Internet\",Kitchen,\"Free...</td>\n",
              "      <td>$0</td>\n",
              "      <td>$0</td>\n",
              "      <td>$55.00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>10.0</td>\n",
              "      <td>--</td>\n",
              "      <td>1</td>\n",
              "      <td>Very lovely and cozy room for one. Convenientl...</td>\n",
              "      <td>Ballard is lovely, vibrant and one of the most...</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>Pull-out Sofa</td>\n",
              "      <td>{Internet,\"Wireless Internet\",Kitchen,\"Free Pa...</td>\n",
              "      <td>$0</td>\n",
              "      <td>$20.00</td>\n",
              "      <td>$52.00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>10.0</td>\n",
              "      <td>--</td>\n",
              "      <td>1</td>\n",
              "      <td>The “Studio at Mibbett Hollow' is in a Beautif...</td>\n",
              "      <td>--</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>Real Bed</td>\n",
              "      <td>{\"Wireless Internet\",Kitchen,\"Free Parking on ...</td>\n",
              "      <td>$0</td>\n",
              "      <td>$15.00</td>\n",
              "      <td>$85.00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>68</th>\n",
              "      <td>nan</td>\n",
              "      <td>--</td>\n",
              "      <td>8</td>\n",
              "      <td>Beautiful craftsman home in the historic Wedgw...</td>\n",
              "      <td>--</td>\n",
              "      <td>3</td>\n",
              "      <td>4</td>\n",
              "      <td>5</td>\n",
              "      <td>Real Bed</td>\n",
              "      <td>{TV,\"Cable TV\",Internet,\"Wireless Internet\",\"A...</td>\n",
              "      <td>$1,000.00</td>\n",
              "      <td>$178.00</td>\n",
              "      <td>$299.00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>68</th>\n",
              "      <td>nan</td>\n",
              "      <td>--</td>\n",
              "      <td>8</td>\n",
              "      <td>Located in a very easily accessible area of Se...</td>\n",
              "      <td>Quiet, dead end street near I-5. The proximity...</td>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>Real Bed</td>\n",
              "      <td>{TV,\"Cable TV\",Internet,\"Wireless Internet\",Ki...</td>\n",
              "      <td>$0</td>\n",
              "      <td>$99.00</td>\n",
              "      <td>$199.00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>68</th>\n",
              "      <td>nan</td>\n",
              "      <td>--</td>\n",
              "      <td>8</td>\n",
              "      <td>This home is fully furnished and available wee...</td>\n",
              "      <td>--</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>4</td>\n",
              "      <td>Real Bed</td>\n",
              "      <td>{TV,\"Cable TV\",Internet,\"Wireless Internet\",\"A...</td>\n",
              "      <td>$0</td>\n",
              "      <td>$0</td>\n",
              "      <td>$400.00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>69</th>\n",
              "      <td>nan</td>\n",
              "      <td>--</td>\n",
              "      <td>9</td>\n",
              "      <td>This business-themed modern home features:  *H...</td>\n",
              "      <td>Your hosts made Madison Valley their home when...</td>\n",
              "      <td>2</td>\n",
              "      <td>3</td>\n",
              "      <td>6</td>\n",
              "      <td>Real Bed</td>\n",
              "      <td>{TV,\"Cable TV\",Internet,\"Wireless Internet\",\"A...</td>\n",
              "      <td>$1,000.00</td>\n",
              "      <td>$150.00</td>\n",
              "      <td>$250.00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>69</th>\n",
              "      <td>nan</td>\n",
              "      <td>--</td>\n",
              "      <td>9</td>\n",
              "      <td>This welcoming home is in the quiet residentia...</td>\n",
              "      <td>Despite the quiet, leafy streets of this resid...</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>6</td>\n",
              "      <td>Real Bed</td>\n",
              "      <td>{TV,Internet,\"Wireless Internet\",Kitchen,\"Free...</td>\n",
              "      <td>$500.00</td>\n",
              "      <td>$0</td>\n",
              "      <td>$350.00</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>3818 rows × 13 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-4d8e2a45-a5f1-46db-b919-ea17e64117ac')\"\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-4d8e2a45-a5f1-46db-b919-ea17e64117ac 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-4d8e2a45-a5f1-46db-b919-ea17e64117ac');\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-6ccfc1a0-eb72-4109-a0c7-6b20681b2774\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-6ccfc1a0-eb72-4109-a0c7-6b20681b2774')\"\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-6ccfc1a0-eb72-4109-a0c7-6b20681b2774 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "  <div id=\"id_4298a1ae-fb49-47fc-94e4-3c125f703038\">\n",
              "    <style>\n",
              "      .colab-df-generate {\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-generate: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-generate {\n",
              "        background-color: #3B4455;\n",
              "        fill: #D2E3FC;\n",
              "      }\n",
              "\n",
              "      [theme=dark] .colab-df-generate: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",
              "    <button class=\"colab-df-generate\" onclick=\"generateWithVariable('dados')\"\n",
              "            title=\"Generate code using this dataframe.\"\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",
              "    <path d=\"M7,19H8.4L18.45,9,17,7.55,7,17.6ZM5,21V16.75L18.45,3.32a2,2,0,0,1,2.83,0l1.4,1.43a1.91,1.91,0,0,1,.58,1.4,1.91,1.91,0,0,1-.58,1.4L9.25,21ZM18.45,9,17,7.55Zm-12,3A5.31,5.31,0,0,0,4.9,8.1,5.31,5.31,0,0,0,1,6.5,5.31,5.31,0,0,0,4.9,4.9,5.31,5.31,0,0,0,6.5,1,5.31,5.31,0,0,0,8.1,4.9,5.31,5.31,0,0,0,12,6.5,5.46,5.46,0,0,0,6.5,12Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "    <script>\n",
              "      (() => {\n",
              "      const buttonEl =\n",
              "        document.querySelector('#id_4298a1ae-fb49-47fc-94e4-3c125f703038 button.colab-df-generate');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      buttonEl.onclick = () => {\n",
              "        google.colab.notebook.generateWithVariable('dados');\n",
              "      }\n",
              "      })();\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "dados",
              "summary": "{\n  \"name\": \"dados\",\n  \"rows\": 3818,\n  \"fields\": [\n    {\n      \"column\": \"avaliacao_geral\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 9,\n        \"samples\": [\n          \"9.0\",\n          \"2.0\",\n          \"7.0\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"experiencia_local\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"--\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"max_hospedes\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 15,\n        \"samples\": [\n          \"5\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"descricao_local\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 3742,\n        \"samples\": [\n          \"Secure building and studio with privacy, amenities and parking. Clean, bright, comfortable, with wifi, memory foam mattress and pillows. Walking distance to Capitol Hill, Seattle U, International District. Close to downtown, Beacon Hill, bus and trolley lines to/from SeaTac airport, University of WA, and many other prime Seattle areas. Bright, open, comfortable, private and secure. Lovely small kitchen, washer and dryer, dual shower head and beautiful atmosphere. Complimentary ORCA card during your stay for bus lines, trolley, light rail or ferries. This is a brand new studio unit with all amenities inside. Code access for both front door and unit. AirBnB only, unless there is an emergency. Easy access to the city. Comfortable and bright new studio in a clean, quiet, and secure building. \\\"Close to everything.\\\" Public transportation, downtown, International District, Pike place, Capitol Hill, etc. We have three cars available for rent: Mini Cooper- Black $39 day Toyota Yaris Black $30 d\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"descricao_vizinhanca\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 2507,\n        \"samples\": [\n          \"The town home is conveniently located close to all amenities, parks, and midway between downtown and the airport. The neighborhood is easy walking to Trader Joes, plenty of parks. It's a short drive to Alki Beach and Downtown.\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"quantidade_banheiros\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 7,\n        \"samples\": [\n          \"1\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"quantidade_quartos\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 8,\n        \"samples\": [\n          \"3\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"quantidade_camas\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 12,\n        \"samples\": [\n          \"2\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"modelo_cama\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 5,\n        \"samples\": [\n          \"Futon\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"comodidades\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 3284,\n        \"samples\": [\n          \"{\\\"Wireless Internet\\\",Kitchen,\\\"Pets Allowed\\\",Heating,\\\"Family/Kid Friendly\\\",\\\"Smoke Detector\\\",\\\"Carbon Monoxide Detector\\\",\\\"First Aid Kit\\\",\\\"Fire Extinguisher\\\",Essentials,Shampoo}\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"taxa_deposito\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 47,\n        \"samples\": [\n          \"$700.00\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"taxa_limpeza\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 119,\n        \"samples\": [\n          \"$135.00\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"preco\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 273,\n        \"samples\": [\n          \"$59.00\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "dados.reset_index(inplace = True,drop=True)\n",
        "dados.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "id": "-Hf3mXJEyh1W",
        "outputId": "9a455d4d-dfb1-44c1-a1f1-8c3671728ebc"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "  avaliacao_geral experiencia_local max_hospedes  \\\n",
              "0            10.0                --            1   \n",
              "1            10.0                --            1   \n",
              "2            10.0                --            1   \n",
              "3            10.0                --            1   \n",
              "4            10.0                --            1   \n",
              "\n",
              "                                     descricao_local  \\\n",
              "0  This clean and comfortable one bedroom sits ri...   \n",
              "1  Our century old Upper Queen Anne house is loca...   \n",
              "2  Cozy room in two-bedroom apartment along the l...   \n",
              "3  Very lovely and cozy room for one. Convenientl...   \n",
              "4  The “Studio at Mibbett Hollow' is in a Beautif...   \n",
              "\n",
              "                                descricao_vizinhanca quantidade_banheiros  \\\n",
              "0  Lower Queen Anne is near the Seattle Center (s...                    1   \n",
              "1  Upper Queen Anne is a really pleasant, unique ...                    1   \n",
              "2  The convenience of being in Seattle but on the...                    1   \n",
              "3  Ballard is lovely, vibrant and one of the most...                    1   \n",
              "4                                                 --                    1   \n",
              "\n",
              "  quantidade_quartos quantidade_camas    modelo_cama  \\\n",
              "0                  1                1       Real Bed   \n",
              "1                  1                1          Futon   \n",
              "2                  1                1          Futon   \n",
              "3                  1                1  Pull-out Sofa   \n",
              "4                  1                1       Real Bed   \n",
              "\n",
              "                                         comodidades taxa_deposito  \\\n",
              "0  {Internet,\"Wireless Internet\",Kitchen,\"Free Pa...            $0   \n",
              "1  {TV,Internet,\"Wireless Internet\",Kitchen,\"Free...            $0   \n",
              "2  {TV,Internet,\"Wireless Internet\",Kitchen,\"Free...            $0   \n",
              "3  {Internet,\"Wireless Internet\",Kitchen,\"Free Pa...            $0   \n",
              "4  {\"Wireless Internet\",Kitchen,\"Free Parking on ...            $0   \n",
              "\n",
              "  taxa_limpeza    preco  \n",
              "0           $0  $110.00  \n",
              "1           $0   $45.00  \n",
              "2           $0   $55.00  \n",
              "3       $20.00   $52.00  \n",
              "4       $15.00   $85.00  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-abee5ec8-74ae-4c0d-9b40-78603549af3d\" 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>avaliacao_geral</th>\n",
              "      <th>experiencia_local</th>\n",
              "      <th>max_hospedes</th>\n",
              "      <th>descricao_local</th>\n",
              "      <th>descricao_vizinhanca</th>\n",
              "      <th>quantidade_banheiros</th>\n",
              "      <th>quantidade_quartos</th>\n",
              "      <th>quantidade_camas</th>\n",
              "      <th>modelo_cama</th>\n",
              "      <th>comodidades</th>\n",
              "      <th>taxa_deposito</th>\n",
              "      <th>taxa_limpeza</th>\n",
              "      <th>preco</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>10.0</td>\n",
              "      <td>--</td>\n",
              "      <td>1</td>\n",
              "      <td>This clean and comfortable one bedroom sits ri...</td>\n",
              "      <td>Lower Queen Anne is near the Seattle Center (s...</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>Real Bed</td>\n",
              "      <td>{Internet,\"Wireless Internet\",Kitchen,\"Free Pa...</td>\n",
              "      <td>$0</td>\n",
              "      <td>$0</td>\n",
              "      <td>$110.00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>10.0</td>\n",
              "      <td>--</td>\n",
              "      <td>1</td>\n",
              "      <td>Our century old Upper Queen Anne house is loca...</td>\n",
              "      <td>Upper Queen Anne is a really pleasant, unique ...</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>Futon</td>\n",
              "      <td>{TV,Internet,\"Wireless Internet\",Kitchen,\"Free...</td>\n",
              "      <td>$0</td>\n",
              "      <td>$0</td>\n",
              "      <td>$45.00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>10.0</td>\n",
              "      <td>--</td>\n",
              "      <td>1</td>\n",
              "      <td>Cozy room in two-bedroom apartment along the l...</td>\n",
              "      <td>The convenience of being in Seattle but on the...</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>Futon</td>\n",
              "      <td>{TV,Internet,\"Wireless Internet\",Kitchen,\"Free...</td>\n",
              "      <td>$0</td>\n",
              "      <td>$0</td>\n",
              "      <td>$55.00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>10.0</td>\n",
              "      <td>--</td>\n",
              "      <td>1</td>\n",
              "      <td>Very lovely and cozy room for one. Convenientl...</td>\n",
              "      <td>Ballard is lovely, vibrant and one of the most...</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>Pull-out Sofa</td>\n",
              "      <td>{Internet,\"Wireless Internet\",Kitchen,\"Free Pa...</td>\n",
              "      <td>$0</td>\n",
              "      <td>$20.00</td>\n",
              "      <td>$52.00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>10.0</td>\n",
              "      <td>--</td>\n",
              "      <td>1</td>\n",
              "      <td>The “Studio at Mibbett Hollow' is in a Beautif...</td>\n",
              "      <td>--</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>Real Bed</td>\n",
              "      <td>{\"Wireless Internet\",Kitchen,\"Free Parking on ...</td>\n",
              "      <td>$0</td>\n",
              "      <td>$15.00</td>\n",
              "      <td>$85.00</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-abee5ec8-74ae-4c0d-9b40-78603549af3d')\"\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-abee5ec8-74ae-4c0d-9b40-78603549af3d 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-abee5ec8-74ae-4c0d-9b40-78603549af3d');\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-d0f5b5a1-e809-4bcc-b825-46178888c552\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-d0f5b5a1-e809-4bcc-b825-46178888c552')\"\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-d0f5b5a1-e809-4bcc-b825-46178888c552 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",
              "variable_name": "dados",
              "summary": "{\n  \"name\": \"dados\",\n  \"rows\": 3818,\n  \"fields\": [\n    {\n      \"column\": \"avaliacao_geral\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 9,\n        \"samples\": [\n          \"9.0\",\n          \"2.0\",\n          \"7.0\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"experiencia_local\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"--\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"max_hospedes\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 15,\n        \"samples\": [\n          \"5\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"descricao_local\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 3742,\n        \"samples\": [\n          \"Secure building and studio with privacy, amenities and parking. Clean, bright, comfortable, with wifi, memory foam mattress and pillows. Walking distance to Capitol Hill, Seattle U, International District. Close to downtown, Beacon Hill, bus and trolley lines to/from SeaTac airport, University of WA, and many other prime Seattle areas. Bright, open, comfortable, private and secure. Lovely small kitchen, washer and dryer, dual shower head and beautiful atmosphere. Complimentary ORCA card during your stay for bus lines, trolley, light rail or ferries. This is a brand new studio unit with all amenities inside. Code access for both front door and unit. AirBnB only, unless there is an emergency. Easy access to the city. Comfortable and bright new studio in a clean, quiet, and secure building. \\\"Close to everything.\\\" Public transportation, downtown, International District, Pike place, Capitol Hill, etc. We have three cars available for rent: Mini Cooper- Black $39 day Toyota Yaris Black $30 d\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"descricao_vizinhanca\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 2507,\n        \"samples\": [\n          \"The town home is conveniently located close to all amenities, parks, and midway between downtown and the airport. The neighborhood is easy walking to Trader Joes, plenty of parks. It's a short drive to Alki Beach and Downtown.\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"quantidade_banheiros\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 7,\n        \"samples\": [\n          \"1\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"quantidade_quartos\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 8,\n        \"samples\": [\n          \"3\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"quantidade_camas\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 12,\n        \"samples\": [\n          \"2\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"modelo_cama\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 5,\n        \"samples\": [\n          \"Futon\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"comodidades\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 3284,\n        \"samples\": [\n          \"{\\\"Wireless Internet\\\",Kitchen,\\\"Pets Allowed\\\",Heating,\\\"Family/Kid Friendly\\\",\\\"Smoke Detector\\\",\\\"Carbon Monoxide Detector\\\",\\\"First Aid Kit\\\",\\\"Fire Extinguisher\\\",Essentials,Shampoo}\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"taxa_deposito\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 47,\n        \"samples\": [\n          \"$700.00\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"taxa_limpeza\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 119,\n        \"samples\": [\n          \"$135.00\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"preco\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 273,\n        \"samples\": [\n          \"$59.00\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "dados.info()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "NrA1ht1cykP-",
        "outputId": "fca2b64d-1011-4421-c29a-9a2d8044b80e"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 3818 entries, 0 to 3817\n",
            "Data columns (total 13 columns):\n",
            " #   Column                Non-Null Count  Dtype \n",
            "---  ------                --------------  ----- \n",
            " 0   avaliacao_geral       3818 non-null   object\n",
            " 1   experiencia_local     3818 non-null   object\n",
            " 2   max_hospedes          3818 non-null   object\n",
            " 3   descricao_local       3818 non-null   object\n",
            " 4   descricao_vizinhanca  3818 non-null   object\n",
            " 5   quantidade_banheiros  3818 non-null   object\n",
            " 6   quantidade_quartos    3818 non-null   object\n",
            " 7   quantidade_camas      3818 non-null   object\n",
            " 8   modelo_cama           3818 non-null   object\n",
            " 9   comodidades           3818 non-null   object\n",
            " 10  taxa_deposito         3818 non-null   object\n",
            " 11  taxa_limpeza          3818 non-null   object\n",
            " 12  preco                 3818 non-null   object\n",
            "dtypes: object(13)\n",
            "memory usage: 387.9+ KB\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.dtypes"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 492
        },
        "id": "FNWkr9Gbyq1l",
        "outputId": "8317277e-2858-4dd4-ff34-b476828a0837"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "avaliacao_geral         object\n",
              "experiencia_local       object\n",
              "max_hospedes            object\n",
              "descricao_local         object\n",
              "descricao_vizinhanca    object\n",
              "quantidade_banheiros    object\n",
              "quantidade_quartos      object\n",
              "quantidade_camas        object\n",
              "modelo_cama             object\n",
              "comodidades             object\n",
              "taxa_deposito           object\n",
              "taxa_limpeza            object\n",
              "preco                   object\n",
              "dtype: object"
            ],
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>0</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>avaliacao_geral</th>\n",
              "      <td>object</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>experiencia_local</th>\n",
              "      <td>object</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>max_hospedes</th>\n",
              "      <td>object</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>descricao_local</th>\n",
              "      <td>object</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>descricao_vizinhanca</th>\n",
              "      <td>object</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>quantidade_banheiros</th>\n",
              "      <td>object</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>quantidade_quartos</th>\n",
              "      <td>object</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>quantidade_camas</th>\n",
              "      <td>object</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>modelo_cama</th>\n",
              "      <td>object</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>comodidades</th>\n",
              "      <td>object</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>taxa_deposito</th>\n",
              "      <td>object</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>taxa_limpeza</th>\n",
              "      <td>object</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>preco</th>\n",
              "      <td>object</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div><br><label><b>dtype:</b> object</label>"
            ]
          },
          "metadata": {},
          "execution_count": 13
        }
      ]
    }
  ]
}