Cleaning_Business_Dataset.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "collapsed_sections": [],
      "authorship_tag": "ABX9TyNOK3YY9f22gdYKrSsllnmc",
      "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/EAName/yelp-reviews/blob/main/Cleaning_Business_Dataset.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 1,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "auky9-DmfF3z",
        "outputId": "b9dcb1d6-b098-49ac-db56-3b1aa9a7aa20"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Mounted at /content/gdrive\n"
          ]
        }
      ],
      "source": [
        "from google.colab import drive\n",
        "drive.mount('/content/gdrive')"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "import json\n",
        "import os\n",
        "\n",
        "import pandas as pd\n",
        "import numpy as np\n",
        "import matplotlib\n",
        "from matplotlib import pyplot as plt\n",
        "import seaborn as sns\n",
        "import statistics\n",
        "import numpy as np\n",
        "\n",
        "%matplotlib inline"
      ],
      "metadata": {
        "id": "LpW_FjImgZT9"
      },
      "execution_count": 2,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# First drop yelp_dataset into your drive (Add shortcut to Drive)\n",
        "business_json_path = '/content/gdrive/MyDrive/yelp_dataset/yelp_academic_dataset_business.json'\n",
        "df_b = pd.read_json(business_json_path, lines=True)"
      ],
      "metadata": {
        "id": "qN1asA02QKGx"
      },
      "execution_count": 3,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "#keep only restaurant category\n",
        "df_b = df_b[df_b['categories'].str.contains(\n",
        "              'restaurant|Restaurant|RESTAURANT',\n",
        "              case=False, na=False)]"
      ],
      "metadata": {
        "id": "tB3qP_u1QZUN"
      },
      "execution_count": 4,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_b.head()"
      ],
      "metadata": {
        "id": "7HqMKHkbQcAN",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 511
        },
        "outputId": "1cfcfc4a-ddfc-41de-abee-c42ad4693254"
      },
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "               business_id                   name              address  \\\n",
              "3   MTSW4McQd7CbVtyjqoe9mw     St Honore Pastries          935 Race St   \n",
              "5   CF33F8-E6oudUQ46HnavjQ         Sonic Drive-In        615 S Main St   \n",
              "8   k0hlBqXX-Bt0vf1op7Jr1w  Tsevi's Pub And Grill    8025 Mackenzie Rd   \n",
              "9   bBDDEgkFA1Otx9Lfe7BZUQ         Sonic Drive-In  2312 Dickerson Pike   \n",
              "11  eEOYSgkmpB90uNA7lDOMRA  Vietnamese Food Truck                        \n",
              "\n",
              "            city state postal_code   latitude  longitude  stars  review_count  \\\n",
              "3   Philadelphia    PA       19107  39.955505 -75.155564    4.0            80   \n",
              "5   Ashland City    TN       37015  36.269593 -87.058943    2.0             6   \n",
              "8         Affton    MO       63123  38.565165 -90.321087    3.0            19   \n",
              "9      Nashville    TN       37207  36.208102 -86.768170    1.5            10   \n",
              "11     Tampa Bay    FL       33602  27.955269 -82.456320    4.0            10   \n",
              "\n",
              "    is_open                                         attributes  \\\n",
              "3         1  {'RestaurantsDelivery': 'False', 'OutdoorSeati...   \n",
              "5         1  {'BusinessParking': 'None', 'BusinessAcceptsCr...   \n",
              "8         0  {'Caters': 'True', 'Alcohol': 'u'full_bar'', '...   \n",
              "9         1  {'RestaurantsAttire': ''casual'', 'Restaurants...   \n",
              "11        1  {'Alcohol': ''none'', 'OutdoorSeating': 'None'...   \n",
              "\n",
              "                                           categories  \\\n",
              "3   Restaurants, Food, Bubble Tea, Coffee & Tea, B...   \n",
              "5   Burgers, Fast Food, Sandwiches, Food, Ice Crea...   \n",
              "8   Pubs, Restaurants, Italian, Bars, American (Tr...   \n",
              "9   Ice Cream & Frozen Yogurt, Fast Food, Burgers,...   \n",
              "11         Vietnamese, Food, Restaurants, Food Trucks   \n",
              "\n",
              "                                                hours  \n",
              "3   {'Monday': '7:0-20:0', 'Tuesday': '7:0-20:0', ...  \n",
              "5   {'Monday': '0:0-0:0', 'Tuesday': '6:0-22:0', '...  \n",
              "8                                                None  \n",
              "9   {'Monday': '0:0-0:0', 'Tuesday': '6:0-21:0', '...  \n",
              "11  {'Monday': '11:0-14:0', 'Tuesday': '11:0-14:0'...  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-1991296c-e754-40d7-bada-efbd9136b873\">\n",
              "    <div 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>business_id</th>\n",
              "      <th>name</th>\n",
              "      <th>address</th>\n",
              "      <th>city</th>\n",
              "      <th>state</th>\n",
              "      <th>postal_code</th>\n",
              "      <th>latitude</th>\n",
              "      <th>longitude</th>\n",
              "      <th>stars</th>\n",
              "      <th>review_count</th>\n",
              "      <th>is_open</th>\n",
              "      <th>attributes</th>\n",
              "      <th>categories</th>\n",
              "      <th>hours</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>MTSW4McQd7CbVtyjqoe9mw</td>\n",
              "      <td>St Honore Pastries</td>\n",
              "      <td>935 Race St</td>\n",
              "      <td>Philadelphia</td>\n",
              "      <td>PA</td>\n",
              "      <td>19107</td>\n",
              "      <td>39.955505</td>\n",
              "      <td>-75.155564</td>\n",
              "      <td>4.0</td>\n",
              "      <td>80</td>\n",
              "      <td>1</td>\n",
              "      <td>{'RestaurantsDelivery': 'False', 'OutdoorSeati...</td>\n",
              "      <td>Restaurants, Food, Bubble Tea, Coffee &amp; Tea, B...</td>\n",
              "      <td>{'Monday': '7:0-20:0', 'Tuesday': '7:0-20:0', ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>CF33F8-E6oudUQ46HnavjQ</td>\n",
              "      <td>Sonic Drive-In</td>\n",
              "      <td>615 S Main St</td>\n",
              "      <td>Ashland City</td>\n",
              "      <td>TN</td>\n",
              "      <td>37015</td>\n",
              "      <td>36.269593</td>\n",
              "      <td>-87.058943</td>\n",
              "      <td>2.0</td>\n",
              "      <td>6</td>\n",
              "      <td>1</td>\n",
              "      <td>{'BusinessParking': 'None', 'BusinessAcceptsCr...</td>\n",
              "      <td>Burgers, Fast Food, Sandwiches, Food, Ice Crea...</td>\n",
              "      <td>{'Monday': '0:0-0:0', 'Tuesday': '6:0-22:0', '...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>k0hlBqXX-Bt0vf1op7Jr1w</td>\n",
              "      <td>Tsevi's Pub And Grill</td>\n",
              "      <td>8025 Mackenzie Rd</td>\n",
              "      <td>Affton</td>\n",
              "      <td>MO</td>\n",
              "      <td>63123</td>\n",
              "      <td>38.565165</td>\n",
              "      <td>-90.321087</td>\n",
              "      <td>3.0</td>\n",
              "      <td>19</td>\n",
              "      <td>0</td>\n",
              "      <td>{'Caters': 'True', 'Alcohol': 'u'full_bar'', '...</td>\n",
              "      <td>Pubs, Restaurants, Italian, Bars, American (Tr...</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>bBDDEgkFA1Otx9Lfe7BZUQ</td>\n",
              "      <td>Sonic Drive-In</td>\n",
              "      <td>2312 Dickerson Pike</td>\n",
              "      <td>Nashville</td>\n",
              "      <td>TN</td>\n",
              "      <td>37207</td>\n",
              "      <td>36.208102</td>\n",
              "      <td>-86.768170</td>\n",
              "      <td>1.5</td>\n",
              "      <td>10</td>\n",
              "      <td>1</td>\n",
              "      <td>{'RestaurantsAttire': ''casual'', 'Restaurants...</td>\n",
              "      <td>Ice Cream &amp; Frozen Yogurt, Fast Food, Burgers,...</td>\n",
              "      <td>{'Monday': '0:0-0:0', 'Tuesday': '6:0-21:0', '...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>eEOYSgkmpB90uNA7lDOMRA</td>\n",
              "      <td>Vietnamese Food Truck</td>\n",
              "      <td></td>\n",
              "      <td>Tampa Bay</td>\n",
              "      <td>FL</td>\n",
              "      <td>33602</td>\n",
              "      <td>27.955269</td>\n",
              "      <td>-82.456320</td>\n",
              "      <td>4.0</td>\n",
              "      <td>10</td>\n",
              "      <td>1</td>\n",
              "      <td>{'Alcohol': ''none'', 'OutdoorSeating': 'None'...</td>\n",
              "      <td>Vietnamese, Food, Restaurants, Food Trucks</td>\n",
              "      <td>{'Monday': '11:0-14:0', 'Tuesday': '11:0-14:0'...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-1991296c-e754-40d7-bada-efbd9136b873')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-1991296c-e754-40d7-bada-efbd9136b873 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-1991296c-e754-40d7-bada-efbd9136b873');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Elaine's DF Clean of Business\n"
      ],
      "metadata": {
        "id": "Tz1bqjBYMpuV"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "Drop Canada and other states"
      ],
      "metadata": {
        "id": "plm0ynljNGFP"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# look at rows with NC, CO, HI, MT, XMS to see if they are mis-labeled or if they should be dropped\n",
        "\n",
        "df_b.loc[df_b['state'].isin([\"NC\", \"CO\", \"HI\", \"MT\", \"XMS\"])]"
      ],
      "metadata": {
        "id": "T3D64c9pMzS-",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 583
        },
        "outputId": "e1ee9eb9-96e2-4614-f92f-2ec13e6ea26e"
      },
      "execution_count": 6,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                  business_id                    name              address  \\\n",
              "9101   em474WuTw7-OkhPfX4EohA                    IHOP  702 Blowing Rock Rd   \n",
              "9126   1H9WYGFJ4AFwXq7WCOOMtg      Two Elk Restaurant     12000 Skyline Dr   \n",
              "12258  bw90rjFL02A_8rVE34m5Lg      Cosmetic Solutions    1010 Lula Lula Dr   \n",
              "48919  gCF0QQWzI9lDouhLfTbYCA       MudMan Food Truck                        \n",
              "98685  IvQs2hhXKZ4NgZhVZ5jjjQ  Pumpernickles Catering   95a Mount Pleasant   \n",
              "\n",
              "            city state postal_code   latitude   longitude  stars  \\\n",
              "9101       Boone    NC       28607  36.378837  -86.463779    2.0   \n",
              "9126        Vail    CO       81657  32.094854 -110.773491    3.5   \n",
              "12258  Lula Lula    HI       90261  38.816486  -90.321750    3.5   \n",
              "48919  Kalispell    MT       59901  27.789678  -82.680746    5.0   \n",
              "98685  Liverpool   XMS      L3 5TB  38.673049  -90.423156    4.0   \n",
              "\n",
              "       review_count  is_open  \\\n",
              "9101             29        0   \n",
              "9126             12        0   \n",
              "12258            17        1   \n",
              "48919             6        0   \n",
              "98685             5        1   \n",
              "\n",
              "                                              attributes  \\\n",
              "9101   {'Alcohol': ''none'', 'RestaurantsTakeOut': 'F...   \n",
              "9126   {'GoodForKids': 'True', 'RestaurantsGoodForGro...   \n",
              "12258  {'BusinessAcceptsCreditCards': 'False', 'Accep...   \n",
              "48919  {'RestaurantsTakeOut': 'True', 'BikeParking': ...   \n",
              "98685  {'RestaurantsPriceRange2': '2', 'BusinessParki...   \n",
              "\n",
              "                                              categories  \\\n",
              "9101   Breakfast & Brunch, Coffee & Tea, Food, Americ...   \n",
              "9126                                Buffets, Restaurants   \n",
              "12258  Cosmetic Surgeons, Pizza, Doctors, Beauty & Sp...   \n",
              "48919  Restaurants, American (Traditional), Food Truc...   \n",
              "98685  Caterers, Breakfast & Brunch, Convenience Stor...   \n",
              "\n",
              "                                                   hours  \n",
              "9101   {'Monday': '0:0-0:0', 'Tuesday': '7:0-15:0', '...  \n",
              "9126                                                None  \n",
              "12258                                               None  \n",
              "48919  {'Tuesday': '17:0-19:30', 'Wednesday': '11:0-1...  \n",
              "98685                                               None  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-403273d0-859d-44e3-8f87-b65fd2c747df\">\n",
              "    <div 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>business_id</th>\n",
              "      <th>name</th>\n",
              "      <th>address</th>\n",
              "      <th>city</th>\n",
              "      <th>state</th>\n",
              "      <th>postal_code</th>\n",
              "      <th>latitude</th>\n",
              "      <th>longitude</th>\n",
              "      <th>stars</th>\n",
              "      <th>review_count</th>\n",
              "      <th>is_open</th>\n",
              "      <th>attributes</th>\n",
              "      <th>categories</th>\n",
              "      <th>hours</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>9101</th>\n",
              "      <td>em474WuTw7-OkhPfX4EohA</td>\n",
              "      <td>IHOP</td>\n",
              "      <td>702 Blowing Rock Rd</td>\n",
              "      <td>Boone</td>\n",
              "      <td>NC</td>\n",
              "      <td>28607</td>\n",
              "      <td>36.378837</td>\n",
              "      <td>-86.463779</td>\n",
              "      <td>2.0</td>\n",
              "      <td>29</td>\n",
              "      <td>0</td>\n",
              "      <td>{'Alcohol': ''none'', 'RestaurantsTakeOut': 'F...</td>\n",
              "      <td>Breakfast &amp; Brunch, Coffee &amp; Tea, Food, Americ...</td>\n",
              "      <td>{'Monday': '0:0-0:0', 'Tuesday': '7:0-15:0', '...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9126</th>\n",
              "      <td>1H9WYGFJ4AFwXq7WCOOMtg</td>\n",
              "      <td>Two Elk Restaurant</td>\n",
              "      <td>12000 Skyline Dr</td>\n",
              "      <td>Vail</td>\n",
              "      <td>CO</td>\n",
              "      <td>81657</td>\n",
              "      <td>32.094854</td>\n",
              "      <td>-110.773491</td>\n",
              "      <td>3.5</td>\n",
              "      <td>12</td>\n",
              "      <td>0</td>\n",
              "      <td>{'GoodForKids': 'True', 'RestaurantsGoodForGro...</td>\n",
              "      <td>Buffets, Restaurants</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12258</th>\n",
              "      <td>bw90rjFL02A_8rVE34m5Lg</td>\n",
              "      <td>Cosmetic Solutions</td>\n",
              "      <td>1010 Lula Lula Dr</td>\n",
              "      <td>Lula Lula</td>\n",
              "      <td>HI</td>\n",
              "      <td>90261</td>\n",
              "      <td>38.816486</td>\n",
              "      <td>-90.321750</td>\n",
              "      <td>3.5</td>\n",
              "      <td>17</td>\n",
              "      <td>1</td>\n",
              "      <td>{'BusinessAcceptsCreditCards': 'False', 'Accep...</td>\n",
              "      <td>Cosmetic Surgeons, Pizza, Doctors, Beauty &amp; Sp...</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48919</th>\n",
              "      <td>gCF0QQWzI9lDouhLfTbYCA</td>\n",
              "      <td>MudMan Food Truck</td>\n",
              "      <td></td>\n",
              "      <td>Kalispell</td>\n",
              "      <td>MT</td>\n",
              "      <td>59901</td>\n",
              "      <td>27.789678</td>\n",
              "      <td>-82.680746</td>\n",
              "      <td>5.0</td>\n",
              "      <td>6</td>\n",
              "      <td>0</td>\n",
              "      <td>{'RestaurantsTakeOut': 'True', 'BikeParking': ...</td>\n",
              "      <td>Restaurants, American (Traditional), Food Truc...</td>\n",
              "      <td>{'Tuesday': '17:0-19:30', 'Wednesday': '11:0-1...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>98685</th>\n",
              "      <td>IvQs2hhXKZ4NgZhVZ5jjjQ</td>\n",
              "      <td>Pumpernickles Catering</td>\n",
              "      <td>95a Mount Pleasant</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>XMS</td>\n",
              "      <td>L3 5TB</td>\n",
              "      <td>38.673049</td>\n",
              "      <td>-90.423156</td>\n",
              "      <td>4.0</td>\n",
              "      <td>5</td>\n",
              "      <td>1</td>\n",
              "      <td>{'RestaurantsPriceRange2': '2', 'BusinessParki...</td>\n",
              "      <td>Caterers, Breakfast &amp; Brunch, Convenience Stor...</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-403273d0-859d-44e3-8f87-b65fd2c747df')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-403273d0-859d-44e3-8f87-b65fd2c747df 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-403273d0-859d-44e3-8f87-b65fd2c747df');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Remove these 5 states since they don't belong to a market "
      ],
      "metadata": {
        "id": "0a_IGbqhM89u"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "#Drop rows for restaurants in outlier states (4 rows) & Canada\n",
        "\n",
        "#dfb_restaurants1.loc[dfb_restaurants1['state'].isin([\"NC\", \"CO\", \"HI\", \"MT\", \"XMS\"])]\n",
        "\n",
        "removestates = [\"NC\", \"CO\", \"HI\", \"MT\", \"XMS\", \"AB\"]\n",
        "\n",
        "df_b = df_b[~ df_b['state'].isin(removestates)]"
      ],
      "metadata": {
        "id": "sTtIVbX-NNl-"
      },
      "execution_count": 7,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_b.shape"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "NiGzgVaslSfI",
        "outputId": "1f393b22-f03c-4e2f-c4e0-2255cd23a22b"
      },
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(49871, 14)"
            ]
          },
          "metadata": {},
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Total restaurants remaining should be 49,871"
      ],
      "metadata": {
        "id": "95abN3cURqSV"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "Normalize cities and states into DMA markets with market column\n",
        "For CA cities, I checked that Reno, NV should only contain NV rows and all CA rows belong to Santa Barbara"
      ],
      "metadata": {
        "id": "lXvCnLN_Nknk"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "#Test that CA zipcodes belonging to Reno DMA are not in the df\n",
        "\n",
        "renoziptest = [\"93512\", \"93517\", \"93529\", \"93541\", \"93546\", \"95646\", \"96009\", \"96056\", \"96068\", \"96107\", \"96109\", \"96113\", \"96114\", \"96117\", \"96119\", \"96120\", \"96121\", \"96123\", \"96127\", \n",
        "               \"96128\", \"96130\", \"96132\", \"96133\", \"96136\", \"96150\", \"96151\", \"96152\", \"96154\", \"96155\", \"96156\", \"96157\", \"96158\"]"
      ],
      "metadata": {
        "id": "e9SnLF7xTvml"
      },
      "execution_count": 9,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "renotestdf = df_b[df_b['postal_code'].isin(renoziptest)]\n",
        "renotestdf.shape"
      ],
      "metadata": {
        "id": "w5oCMq7yT2NF",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "dc8dd710-13d1-40e7-efce-3b95418ed283"
      },
      "execution_count": 10,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(0, 14)"
            ]
          },
          "metadata": {},
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Get list of all states\n",
        "\n",
        "df_b.state.value_counts()"
      ],
      "metadata": {
        "id": "TleRCiFAN4x9",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "749108e0-d966-4630-ee2d-3cfbf7110d99"
      },
      "execution_count": 11,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "PA    12644\n",
              "FL     8732\n",
              "TN     4353\n",
              "MO     4248\n",
              "IN     4150\n",
              "LA     3641\n",
              "NJ     3343\n",
              "AZ     2675\n",
              "NV     1675\n",
              "ID     1304\n",
              "CA     1161\n",
              "IL      983\n",
              "DE      962\n",
              "Name: state, dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#create market dictionary\n",
        "\n",
        "market = {'PA': 'Philadelphia', 'DE': 'Philadelphia', 'NJ': 'Philadelphia', 'FL': 'Tampa', 'IN': 'Indianapolis', 'TN': 'Nashville', 'AZ': 'Tucson', 'LA': 'New Orleans', 'MO': 'St. Louis', 'IL': 'St. Louis',\n",
        "          'NV': 'Reno', 'CA': 'Santa Barbara', 'ID': 'Boise'}"
      ],
      "metadata": {
        "id": "lF2a7BOgNf6-"
      },
      "execution_count": 12,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_b['market']= df_b['state'].map(market)"
      ],
      "metadata": {
        "id": "X7Z0IEFCNsHu"
      },
      "execution_count": 13,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "Look at all the restaurant categories by most frequent"
      ],
      "metadata": {
        "id": "eum-p-SWmY3q"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df_explode = df_b.assign(categories = df_b.categories\n",
        "                         .str.split(', ')).explode('categories')"
      ],
      "metadata": {
        "id": "BFxpFMoFh_A5"
      },
      "execution_count": 14,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "pd.set_option('display.max_rows', None)  # or 1000"
      ],
      "metadata": {
        "id": "p4mRAcWR0RR6"
      },
      "execution_count": 15,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_explode.categories.value_counts().head(200)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "B9DJvzbDiAkS",
        "outputId": "8504ae82-9a32-4c14-9e15-e291bb75c17e"
      },
      "execution_count": 16,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Restaurants                  49853\n",
              "Food                         14818\n",
              "Nightlife                     8355\n",
              "Sandwiches                    8136\n",
              "Bars                          7988\n",
              "American (Traditional)        7943\n",
              "Pizza                         6779\n",
              "Fast Food                     6151\n",
              "Breakfast & Brunch            6023\n",
              "American (New)                5989\n",
              "Burgers                       5392\n",
              "Mexican                       4542\n",
              "Italian                       4395\n",
              "Coffee & Tea                  3839\n",
              "Seafood                       3457\n",
              "Salad                         3000\n",
              "Event Planning & Services     2999\n",
              "Chinese                       2967\n",
              "Chicken Wings                 2880\n",
              "Cafes                         2595\n",
              "Delis                         2344\n",
              "Caterers                      2015\n",
              "Specialty Food                1917\n",
              "Bakeries                      1829\n",
              "Desserts                      1761\n",
              "Sports Bars                   1742\n",
              "Japanese                      1695\n",
              "Barbeque                      1653\n",
              "Sushi Bars                    1647\n",
              "Asian Fusion                  1448\n",
              "Diners                        1445\n",
              "Steakhouses                   1413\n",
              "Cocktail Bars                 1357\n",
              "Pubs                          1300\n",
              "Mediterranean                 1203\n",
              "Beer                          1115\n",
              "Wine & Spirits                1115\n",
              "Vegetarian                    1104\n",
              "Ice Cream & Frozen Yogurt     1049\n",
              "Arts & Entertainment          1046\n",
              "Tacos                         1019\n",
              "Soup                          1016\n",
              "Food Trucks                    988\n",
              "Juice Bars & Smoothies         981\n",
              "Southern                       977\n",
              "Thai                           915\n",
              "Cajun/Creole                   913\n",
              "Tex-Mex                        910\n",
              "Wine Bars                      901\n",
              "Food Delivery Services         830\n",
              "Vegan                          818\n",
              "Grocery                        814\n",
              "Latin American                 794\n",
              "Chicken Shop                   770\n",
              "Venues & Event Spaces          769\n",
              "Hot Dogs                       756\n",
              "Greek                          751\n",
              "Indian                         733\n",
              "Gluten-Free                    717\n",
              "Vietnamese                     711\n",
              "Comfort Food                   702\n",
              "Beer Bar                       628\n",
              "Lounges                        628\n",
              "Cheesesteaks                   613\n",
              "Shopping                       600\n",
              "Bagels                         594\n",
              "Caribbean                      578\n",
              "Buffets                        564\n",
              "Middle Eastern                 542\n",
              "Convenience Stores             532\n",
              "Soul Food                      528\n",
              "Music Venues                   491\n",
              "Gastropubs                     481\n",
              "Ethnic Food                    474\n",
              "French                         471\n",
              "Donuts                         452\n",
              "Korean                         442\n",
              "Local Flavor                   436\n",
              "Tapas/Small Plates             421\n",
              "Food Stands                    416\n",
              "Hotels & Travel                409\n",
              "Breweries                      392\n",
              "Noodles                        354\n",
              "Halal                          332\n",
              "Active Life                    311\n",
              "Wraps                          310\n",
              "Automotive                     286\n",
              "Spanish                        282\n",
              "Cuban                          280\n",
              "Hotels                         277\n",
              "Dive Bars                      274\n",
              "Bubble Tea                     261\n",
              "Gas Stations                   257\n",
              "Street Vendors                 253\n",
              "Meat Shops                     227\n",
              "Seafood Markets                215\n",
              "Pakistani                      211\n",
              "Tapas Bars                     209\n",
              "Irish                          207\n",
              "Ramen                          204\n",
              "Pasta Shops                    187\n",
              "Waffles                        186\n",
              "Poke                           183\n",
              "Fish & Chips                   183\n",
              "Party & Event Planning         181\n",
              "Hawaiian                       181\n",
              "Acai Bowls                     176\n",
              "Karaoke                        171\n",
              "Health Markets                 164\n",
              "Creperies                      158\n",
              "Coffee Roasteries              137\n",
              "Dance Clubs                    131\n",
              "Hookah Bars                    129\n",
              "Food Court                     124\n",
              "Fruits & Veggies               123\n",
              "Dim Sum                        123\n",
              "Modern European                122\n",
              "Farmers Market                 120\n",
              "Irish Pub                      119\n",
              "German                         116\n",
              "Brewpubs                       114\n",
              "Szechuan                       113\n",
              "Arcades                        111\n",
              "New Mexican Cuisine            111\n",
              "Beer Gardens                   109\n",
              "Jazz & Blues                   104\n",
              "African                        104\n",
              "Imported Food                  102\n",
              "Falafel                        101\n",
              "Pretzels                       100\n",
              "Puerto Rican                    99\n",
              "International Grocery           97\n",
              "Flowers & Gifts                 97\n",
              "Cupcakes                        97\n",
              "Tea Rooms                       93\n",
              "Cantonese                       89\n",
              "Gelato                          89\n",
              "Butcher                         86\n",
              "Kebab                           85\n",
              "Golf                            85\n",
              "Filipino                        85\n",
              "Live/Raw Food                   85\n",
              "Beauty & Spas                   83\n",
              "Internet Cafes                  83\n",
              "Cheese Shops                    83\n",
              "Peruvian                        82\n",
              "Wineries                        82\n",
              "Turkish                         78\n",
              "Local Services                  77\n",
              "Pop-Up Restaurants              74\n",
              "Shaved Ice                      73\n",
              "Brazilian                       73\n",
              "Kosher                          72\n",
              "Custom Cakes                    70\n",
              "Health & Medical                69\n",
              "Organic Stores                  69\n",
              "Colombian                       67\n",
              "Pan Asian                       67\n",
              "Home Services                   66\n",
              "British                         66\n",
              "Lebanese                        66\n",
              "Smokehouse                      65\n",
              "Bed & Breakfast                 64\n",
              "Home & Garden                   63\n",
              "Drugstores                      63\n",
              "Pool Halls                      62\n",
              "Taiwanese                       62\n",
              "Hot Pot                         62\n",
              "Fashion                         59\n",
              "Professional Services           58\n",
              "Do-It-Yourself Food             58\n",
              "Salvadoran                      57\n",
              "Ethiopian                       57\n",
              "Shopping Centers                56\n",
              "Empanadas                       56\n",
              "Education                       54\n",
              "Wedding Planning                53\n",
              "Patisserie/Cake Shop            52\n",
              "Florists                        51\n",
              "Casinos                         50\n",
              "Arts & Crafts                   49\n",
              "Whiskey Bars                    49\n",
              "Moroccan                        48\n",
              "Tiki Bars                       48\n",
              "Chocolatiers & Shops            48\n",
              "Bowling                         47\n",
              "Cafeteria                       47\n",
              "Tours                           47\n",
              "Art Galleries                   46\n",
              "Venezuelan                      46\n",
              "Brasseries                      45\n",
              "Personal Chefs                  44\n",
              "Laotian                         44\n",
              "Dominican                       44\n",
              "Gay Bars                        43\n",
              "Russian                         41\n",
              "Candy Stores                    41\n",
              "Afghan                          41\n",
              "Kids Activities                 40\n",
              "Country Clubs                   40\n",
              "Name: categories, dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 16
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Remove rows to narrow \"Restaurant\" Definition to Sit-down restaurants"
      ],
      "metadata": {
        "id": "QHHjuqU4OjHt"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "#Create DF to isolate the rows we want to remove\n",
        "#Please add more as needed\n",
        "\n",
        "df_bfast = df_b[df_b['categories'].str.contains('Fast Food|Bakery|Bakeries|Food Trucks|Street Vendors|Coffee| Coffee & Tea|Caterers|Ice Cream & Frozen Yogurt|Juice Bars & Smoothies|Convenience Stores|Food Stands|Gas Stations|Creperies|Beauty & Spa|International Grocery|Gelato|Butcher|Shaved Ice',\n",
        "                                                                                 case=False, na=False)]\n",
        "df_bfast.shape"
      ],
      "metadata": {
        "id": "YJ32tUweOhdX",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "0263be11-898d-4227-d31c-8407bae2cbb6"
      },
      "execution_count": 17,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(14581, 15)"
            ]
          },
          "metadata": {},
          "execution_count": 17
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df_b = df_b.drop(df_bfast.index)\n",
        "df_b.shape"
      ],
      "metadata": {
        "id": "h4qdjcNEPpNu",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "bf71e60c-ffee-44d8-f2d9-4e032d4d0ed5"
      },
      "execution_count": 18,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(35290, 15)"
            ]
          },
          "metadata": {},
          "execution_count": 18
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Total rows remaining should be 35,290"
      ],
      "metadata": {
        "id": "xboE5G5zRfGv"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "#Check whether top fast food names are still in the df\n",
        "\n",
        "fast_list = [\"McDonald's\", \"Subway\", \"Taco Bell\", \"Burger King\", \"Wendy's\", \"Wawa\",\"Domino's Pizza\", \"Pizza Hut\", \"Papa John's Pizza\", \"Jimmy John's\",\n",
        "             \"KFC\", \"Chick-fil-A\", \"Popeyes Louisiana Kitchen\", \"Chipotle Mexican Grill\", \"Starbucks\", \"Panera Bread\", \"Sonic Drive-In\", \"Arby's\",\n",
        "             \"Panda Express\", \"Waffle House\", \"IHOP\", \"Jack in the Box\", \"Jersey Mike's Subs\" , \"Steak ’n Shake\", \"Five Guys\", \"Dairy Queen\" , \"QDOBA Mexican Eats\", \n",
        "             \"Little Caesars Pizza\", \"Hardee's\", \"Wingstop\", \"Firehouse Subs\", \"Dairy Queen Grill & Chill\", \"Buffalo Wild Wings\", \"Checkers\", \"China Wok\", \n",
        "             \"White Castle\", \"Imo's Pizza\", \"Papa Murphy's\", \"PrimoHoagies\", \"Saladworks\", \"Marco's Pizza\", \"QuikTrip\", \"Philly Pretzel Factory\", \"Boston Market\"\n",
        "              \"Moe's Southwest Grill\", \"Church's Chicken\", \"Culver's\", \"Rally's\", \"Cracker Barrel Old Country Store\", \"Tropical Smoothie Café\", \n",
        "             \"Hungry Howie's Pizza & Subs\", \"McAlister's Deli\", \"Jet's Pizza\", \"Hooters\", \"Little Caesars\", \"St. Louis Bread\", \"Friendly's\", \n",
        "             \"Long John Silver's\", \"Dickey's Barbecue Pit\", \"Zaxby's Chicken Fingers & Buffalo Wings\", \"Captain D's\", \"Chuck E. Cheese\", \"Carl's Jr\",\n",
        "             \"MOD Pizza\", \"Einstein Bros. Bagels\", \"Honey Baked Ham Company\", \"eegee's\", \"Manhattan Bagel\", \"Raising Cane's Chicken Fingers\", \"Noodles & Company\", \n",
        "             \"Smashburger\", \"Penn Station East Coast Subs\", \"Tijuana Flats\",  \"Westshore Pizza\", \"Zoes Kitchen\", \"Port of Subs\", \"Quiznos\", \n",
        "             \"Shake Shack\", \"Fazoli's\"]"
      ],
      "metadata": {
        "id": "aq7ueZhrR7L1"
      },
      "execution_count": 19,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "print(len(df_b[df_b['name'].isin(fast_list)]))"
      ],
      "metadata": {
        "id": "F_3h6AXmSCQt",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "a80ccf5d-0272-4195-ceca-ea4e10016349"
      },
      "execution_count": 20,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "1803\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "There are still 1803 rows with the chains in fast_list, representing 5% of the total businesses. We may need to check if we can delete from Pizza and Sandwich category. The only issue with deleting Pizza is that it may delete \"Italian\" also."
      ],
      "metadata": {
        "id": "YgXgUTkxSIpl"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "Larger Chains that are still kept within the Total restaurants list to provide comparison for sit-down restaurants:\n",
        "\n",
        "\n",
        "\n",
        "*   Applebee's Grill + Bar\n",
        "*   Chili's\n",
        "* Denny's\n",
        "* First Watch\n",
        "* Outback Steakhouse\n",
        "* China King - there is a chain but there are also independents\n",
        "* Olive Garden Italian Restaurant\n",
        "* LongHorn Steakhouse\n",
        "* Red Lobster\n",
        "* Ruby Tuesday\n",
        "* TGI Fridays\n",
        "* Bob Evans\n",
        "* Red Robin Gourmet Burgers and Brews\n",
        "* Beef 'O'Brady's\n",
        "* Texas Roadhouse\n",
        "* Carrabba's Italian Grill\n",
        "* China House\n",
        "* O'Charley's Restaurant & Bar\n",
        "* Bonefish Grill\n",
        "* New China\n",
        "\n",
        "\n",
        "\n",
        "\n",
        "\n"
      ],
      "metadata": {
        "id": "Wjq_Y8r7SWHF"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Rabia's DF Clean of Business"
      ],
      "metadata": {
        "id": "1z1ellONIGvl"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "### One Hot Encode Attributes column"
      ],
      "metadata": {
        "id": "Jmc4jWxv9gvK"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df_b = df_b.join(pd.DataFrame(df_b['attributes'].to_dict()).T)"
      ],
      "metadata": {
        "id": "XV3jBDRtO3NU"
      },
      "execution_count": 21,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "pd.set_option('display.max_columns', None)"
      ],
      "metadata": {
        "id": "cCvE9ZgxClMi"
      },
      "execution_count": 22,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_b.head(10)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "_VejOjCCCmiX",
        "outputId": "c0e358ab-914d-45d4-b13a-d2389c521c06"
      },
      "execution_count": 23,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "               business_id                     name               address  \\\n",
              "8   k0hlBqXX-Bt0vf1op7Jr1w    Tsevi's Pub And Grill     8025 Mackenzie Rd   \n",
              "12  il_Ro8jwPlHresjw9EGmBg                  Denny's          8901 US 31 S   \n",
              "15  MUTTqe8uqyMdBl186RmNeA                 Tuna Bar           205 Race St   \n",
              "19  ROeacJQwBeh05Rqg7F6TCg                      BAP         1224 South St   \n",
              "22  kfNv-JZpuN6TVNSO6hHdkw          Hibachi Express        6625 E 82nd St   \n",
              "23  9OG5YkX1g2GReZM0AskizA  Romano's Macaroni Grill    5505 S Virginia St   \n",
              "24  4iRzR7OaS-QaSXuvYxEGKA                Super Dog  1160 Gallatin Pike S   \n",
              "27  tMkwHmWFUEXrC9ZduonpTg       The Green Pheasant         215 1st Ave S   \n",
              "28  QdN72BWoyFypdGJhhI5r7g                  Bar One          767 S 9th St   \n",
              "29  sqSqqLy0sN8n2IZrAbzidQ           Domino's Pizza     3001 Highway 31 W   \n",
              "\n",
              "            city state postal_code   latitude   longitude  stars  \\\n",
              "8         Affton    MO       63123  38.565165  -90.321087    3.0   \n",
              "12  Indianapolis    IN       46227  39.637133  -86.127217    2.5   \n",
              "15  Philadelphia    PA       19106  39.953949  -75.143226    4.0   \n",
              "19  Philadelphia    PA       19147  39.943223  -75.162568    4.5   \n",
              "22  Indianapolis    IN       46250  39.904320  -86.053080    4.0   \n",
              "23          Reno    NV       89502  39.476117 -119.789339    2.5   \n",
              "24     Nashville    TN       37115  36.248570  -86.719986    4.0   \n",
              "27     Nashville    TN       37201  36.159886  -86.773197    4.0   \n",
              "28  Philadelphia    PA       19147  39.939825  -75.157447    4.0   \n",
              "29   White House    TN       37188  36.464747  -86.659187    3.5   \n",
              "\n",
              "    review_count  is_open                                         attributes  \\\n",
              "8             19        0  {'Caters': 'True', 'Alcohol': 'u'full_bar'', '...   \n",
              "12            28        1  {'RestaurantsReservations': 'False', 'Restaura...   \n",
              "15           245        1  {'RestaurantsReservations': 'True', 'Restauran...   \n",
              "19           205        1  {'NoiseLevel': 'u'quiet'', 'GoodForMeal': '{'d...   \n",
              "22            20        1  {'RestaurantsDelivery': 'True', 'RestaurantsTa...   \n",
              "23           339        1  {'RestaurantsGoodForGroups': 'True', 'Restaura...   \n",
              "24             6        0  {'RestaurantsReservations': 'False', 'Restaura...   \n",
              "27           161        0  {'RestaurantsGoodForGroups': 'True', 'HappyHou...   \n",
              "28            65        0  {'Smoking': 'u'no'', 'NoiseLevel': 'u'average'...   \n",
              "29             8        1                    {'RestaurantsPriceRange2': '1'}   \n",
              "\n",
              "                                           categories  \\\n",
              "8   Pubs, Restaurants, Italian, Bars, American (Tr...   \n",
              "12  American (Traditional), Restaurants, Diners, B...   \n",
              "15                  Sushi Bars, Restaurants, Japanese   \n",
              "19                                Korean, Restaurants   \n",
              "22             Steakhouses, Asian Fusion, Restaurants   \n",
              "23                               Restaurants, Italian   \n",
              "24                              Hot Dogs, Restaurants   \n",
              "27                     Restaurants, Japanese, Seafood   \n",
              "28  Cocktail Bars, Bars, Italian, Nightlife, Resta...   \n",
              "29      Pizza, Chicken Wings, Sandwiches, Restaurants   \n",
              "\n",
              "                                                hours        market Caters  \\\n",
              "8                                                None     St. Louis   True   \n",
              "12  {'Monday': '6:0-22:0', 'Tuesday': '6:0-22:0', ...  Indianapolis    NaN   \n",
              "15  {'Tuesday': '13:30-22:0', 'Wednesday': '13:30-...  Philadelphia    NaN   \n",
              "19  {'Monday': '11:30-20:30', 'Tuesday': '11:30-20...  Philadelphia   True   \n",
              "22  {'Monday': '11:0-21:0', 'Tuesday': '11:0-21:0'...  Indianapolis    NaN   \n",
              "23  {'Monday': '11:0-22:0', 'Tuesday': '11:0-22:0'...          Reno   True   \n",
              "24                                               None     Nashville  False   \n",
              "27  {'Wednesday': '16:0-22:0', 'Thursday': '16:0-2...     Nashville   True   \n",
              "28  {'Monday': '16:0-0:0', 'Tuesday': '16:0-0:0', ...  Philadelphia  False   \n",
              "29  {'Monday': '10:0-0:0', 'Tuesday': '10:0-0:0', ...     Nashville    NaN   \n",
              "\n",
              "             Alcohol RestaurantsAttire RestaurantsDelivery RestaurantsTakeOut  \\\n",
              "8        u'full_bar'         u'casual'               False               True   \n",
              "12            'none'          'casual'                True               True   \n",
              "15        'full_bar'          'casual'                True               True   \n",
              "19           u'none'         u'casual'                None               True   \n",
              "22               NaN               NaN                True               True   \n",
              "23        'full_bar'          'casual'                True               True   \n",
              "24  u'beer_and_wine'         u'casual'               False               True   \n",
              "27       u'full_bar'         u'casual'                None               None   \n",
              "28       u'full_bar'          'casual'                True               True   \n",
              "29               NaN               NaN                 NaN                NaN   \n",
              "\n",
              "    HasTV  NoiseLevel BusinessAcceptsCreditCards OutdoorSeating  \\\n",
              "8    True  u'average'                       True           True   \n",
              "12   True         NaN                       True          False   \n",
              "15  False  u'average'                       True           True   \n",
              "19   True    u'quiet'                       True           None   \n",
              "22    NaN         NaN                        NaN            NaN   \n",
              "23   True  u'average'                       True           True   \n",
              "24   True  u'average'                      False          False   \n",
              "27  False  u'average'                       True          False   \n",
              "28   True  u'average'                       True          False   \n",
              "29    NaN         NaN                        NaN            NaN   \n",
              "\n",
              "                                      BusinessParking  \\\n",
              "8   {'garage': False, 'street': False, 'validated'...   \n",
              "12  {'garage': None, 'street': False, 'validated':...   \n",
              "15  {u'valet': False, u'garage': None, u'street': ...   \n",
              "19  {'garage': False, 'street': True, 'validated':...   \n",
              "22                                                NaN   \n",
              "23  {'garage': False, 'street': False, 'validated'...   \n",
              "24  {'garage': False, 'street': False, 'validated'...   \n",
              "27  {'garage': True, 'street': False, 'validated':...   \n",
              "28  {'garage': None, 'street': True, 'validated': ...   \n",
              "29                                                NaN   \n",
              "\n",
              "                                             Ambience RestaurantsPriceRange2  \\\n",
              "8   {'romantic': False, 'intimate': False, 'touris...                      1   \n",
              "12  {'touristy': None, 'hipster': None, 'romantic'...                      1   \n",
              "15  {'touristy': False, 'hipster': False, 'romanti...                      2   \n",
              "19  {'touristy': False, 'hipster': False, 'romanti...                      1   \n",
              "22                                                NaN                      2   \n",
              "23  {u'divey': False, u'hipster': False, u'casual'...                      2   \n",
              "24  {'romantic': False, 'intimate': False, 'touris...                      1   \n",
              "27  {'touristy': False, 'hipster': False, 'romanti...                    NaN   \n",
              "28  {'touristy': False, 'hipster': True, 'romantic...                      2   \n",
              "29                                                NaN                      1   \n",
              "\n",
              "   GoodForKids     WiFi RestaurantsReservations RestaurantsGoodForGroups  \\\n",
              "8         True  u'free'                   False                     True   \n",
              "12        True    u'no'                   False                     True   \n",
              "15       False   'free'                    True                     True   \n",
              "19        True    u'no'                   False                    False   \n",
              "22         NaN      NaN                     NaN                      NaN   \n",
              "23        True  u'free'                    True                     True   \n",
              "24        True    u'no'                   False                     True   \n",
              "27       False  u'free'                    True                     True   \n",
              "28       False  u'free'                   False                     True   \n",
              "29         NaN      NaN                     NaN                      NaN   \n",
              "\n",
              "   BikeParking                                        GoodForMeal DogsAllowed  \\\n",
              "8          NaN                                                NaN         NaN   \n",
              "12       False  {'dessert': False, 'latenight': False, 'lunch'...         NaN   \n",
              "15         NaN  {'dessert': True, 'latenight': None, 'lunch': ...       False   \n",
              "19        True  {'dessert': False, 'latenight': False, 'lunch'...         NaN   \n",
              "22         NaN                                                NaN         NaN   \n",
              "23        True  {'dessert': None, 'latenight': False, 'lunch':...       False   \n",
              "24         NaN                                                NaN         NaN   \n",
              "27       False  {'dessert': None, 'latenight': None, 'lunch': ...       False   \n",
              "28        True  {'dessert': False, 'latenight': False, 'lunch'...         NaN   \n",
              "29         NaN                                                NaN         NaN   \n",
              "\n",
              "   HappyHour WheelchairAccessible RestaurantsTableService  \\\n",
              "8        NaN                  NaN                     NaN   \n",
              "12       NaN                  NaN                     NaN   \n",
              "15      True                 True                    True   \n",
              "19       NaN                  NaN                    True   \n",
              "22       NaN                  NaN                     NaN   \n",
              "23      True                  NaN                    True   \n",
              "24       NaN                  NaN                     NaN   \n",
              "27      True                 True                    True   \n",
              "28      True                  NaN                    True   \n",
              "29       NaN                  NaN                     NaN   \n",
              "\n",
              "   BusinessAcceptsBitcoin Smoking  \\\n",
              "8                     NaN     NaN   \n",
              "12                    NaN     NaN   \n",
              "15                    NaN     NaN   \n",
              "19                    NaN     NaN   \n",
              "22                    NaN     NaN   \n",
              "23                    NaN     NaN   \n",
              "24                    NaN     NaN   \n",
              "27                  False     NaN   \n",
              "28                    NaN   u'no'   \n",
              "29                    NaN     NaN   \n",
              "\n",
              "                                                Music GoodForDancing  \\\n",
              "8                                                 NaN            NaN   \n",
              "12                                                NaN            NaN   \n",
              "15                                                NaN            NaN   \n",
              "19                                                NaN            NaN   \n",
              "22                                                NaN            NaN   \n",
              "23                                                NaN            NaN   \n",
              "24                                                NaN            NaN   \n",
              "27                                                NaN            NaN   \n",
              "28  {'dj': False, 'background_music': False, 'no_m...          False   \n",
              "29                                                NaN            NaN   \n",
              "\n",
              "   CoatCheck BestNights BYOB ByAppointmentOnly DriveThru Corkage BYOBCorkage  \\\n",
              "8        NaN        NaN  NaN               NaN       NaN     NaN         NaN   \n",
              "12       NaN        NaN  NaN               NaN       NaN     NaN         NaN   \n",
              "15       NaN        NaN  NaN               NaN       NaN     NaN         NaN   \n",
              "19       NaN        NaN  NaN               NaN       NaN     NaN         NaN   \n",
              "22       NaN        NaN  NaN               NaN       NaN     NaN         NaN   \n",
              "23       NaN        NaN  NaN               NaN       NaN     NaN         NaN   \n",
              "24       NaN        NaN  NaN               NaN       NaN     NaN         NaN   \n",
              "27       NaN        NaN  NaN               NaN       NaN     NaN         NaN   \n",
              "28       NaN        NaN  NaN               NaN       NaN     NaN         NaN   \n",
              "29       NaN        NaN  NaN               NaN       NaN     NaN         NaN   \n",
              "\n",
              "   RestaurantsCounterService Open24Hours AgesAllowed AcceptsInsurance  \\\n",
              "8                        NaN         NaN         NaN              NaN   \n",
              "12                       NaN         NaN         NaN              NaN   \n",
              "15                       NaN         NaN         NaN              NaN   \n",
              "19                       NaN         NaN         NaN              NaN   \n",
              "22                       NaN         NaN         NaN              NaN   \n",
              "23                       NaN         NaN         NaN              NaN   \n",
              "24                       NaN         NaN         NaN              NaN   \n",
              "27                       NaN         NaN         NaN              NaN   \n",
              "28                       NaN         NaN         NaN              NaN   \n",
              "29                       NaN         NaN         NaN              NaN   \n",
              "\n",
              "   DietaryRestrictions  \n",
              "8                  NaN  \n",
              "12                 NaN  \n",
              "15                 NaN  \n",
              "19                 NaN  \n",
              "22                 NaN  \n",
              "23                 NaN  \n",
              "24                 NaN  \n",
              "27                 NaN  \n",
              "28                 NaN  \n",
              "29                 NaN  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-d715ccf1-64d6-4a60-a3b3-14dd292aa9a4\">\n",
              "    <div 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>business_id</th>\n",
              "      <th>name</th>\n",
              "      <th>address</th>\n",
              "      <th>city</th>\n",
              "      <th>state</th>\n",
              "      <th>postal_code</th>\n",
              "      <th>latitude</th>\n",
              "      <th>longitude</th>\n",
              "      <th>stars</th>\n",
              "      <th>review_count</th>\n",
              "      <th>is_open</th>\n",
              "      <th>attributes</th>\n",
              "      <th>categories</th>\n",
              "      <th>hours</th>\n",
              "      <th>market</th>\n",
              "      <th>Caters</th>\n",
              "      <th>Alcohol</th>\n",
              "      <th>RestaurantsAttire</th>\n",
              "      <th>RestaurantsDelivery</th>\n",
              "      <th>RestaurantsTakeOut</th>\n",
              "      <th>HasTV</th>\n",
              "      <th>NoiseLevel</th>\n",
              "      <th>BusinessAcceptsCreditCards</th>\n",
              "      <th>OutdoorSeating</th>\n",
              "      <th>BusinessParking</th>\n",
              "      <th>Ambience</th>\n",
              "      <th>RestaurantsPriceRange2</th>\n",
              "      <th>GoodForKids</th>\n",
              "      <th>WiFi</th>\n",
              "      <th>RestaurantsReservations</th>\n",
              "      <th>RestaurantsGoodForGroups</th>\n",
              "      <th>BikeParking</th>\n",
              "      <th>GoodForMeal</th>\n",
              "      <th>DogsAllowed</th>\n",
              "      <th>HappyHour</th>\n",
              "      <th>WheelchairAccessible</th>\n",
              "      <th>RestaurantsTableService</th>\n",
              "      <th>BusinessAcceptsBitcoin</th>\n",
              "      <th>Smoking</th>\n",
              "      <th>Music</th>\n",
              "      <th>GoodForDancing</th>\n",
              "      <th>CoatCheck</th>\n",
              "      <th>BestNights</th>\n",
              "      <th>BYOB</th>\n",
              "      <th>ByAppointmentOnly</th>\n",
              "      <th>DriveThru</th>\n",
              "      <th>Corkage</th>\n",
              "      <th>BYOBCorkage</th>\n",
              "      <th>RestaurantsCounterService</th>\n",
              "      <th>Open24Hours</th>\n",
              "      <th>AgesAllowed</th>\n",
              "      <th>AcceptsInsurance</th>\n",
              "      <th>DietaryRestrictions</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>k0hlBqXX-Bt0vf1op7Jr1w</td>\n",
              "      <td>Tsevi's Pub And Grill</td>\n",
              "      <td>8025 Mackenzie Rd</td>\n",
              "      <td>Affton</td>\n",
              "      <td>MO</td>\n",
              "      <td>63123</td>\n",
              "      <td>38.565165</td>\n",
              "      <td>-90.321087</td>\n",
              "      <td>3.0</td>\n",
              "      <td>19</td>\n",
              "      <td>0</td>\n",
              "      <td>{'Caters': 'True', 'Alcohol': 'u'full_bar'', '...</td>\n",
              "      <td>Pubs, Restaurants, Italian, Bars, American (Tr...</td>\n",
              "      <td>None</td>\n",
              "      <td>St. Louis</td>\n",
              "      <td>True</td>\n",
              "      <td>u'full_bar'</td>\n",
              "      <td>u'casual'</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>u'average'</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>{'garage': False, 'street': False, 'validated'...</td>\n",
              "      <td>{'romantic': False, 'intimate': False, 'touris...</td>\n",
              "      <td>1</td>\n",
              "      <td>True</td>\n",
              "      <td>u'free'</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>il_Ro8jwPlHresjw9EGmBg</td>\n",
              "      <td>Denny's</td>\n",
              "      <td>8901 US 31 S</td>\n",
              "      <td>Indianapolis</td>\n",
              "      <td>IN</td>\n",
              "      <td>46227</td>\n",
              "      <td>39.637133</td>\n",
              "      <td>-86.127217</td>\n",
              "      <td>2.5</td>\n",
              "      <td>28</td>\n",
              "      <td>1</td>\n",
              "      <td>{'RestaurantsReservations': 'False', 'Restaura...</td>\n",
              "      <td>American (Traditional), Restaurants, Diners, B...</td>\n",
              "      <td>{'Monday': '6:0-22:0', 'Tuesday': '6:0-22:0', ...</td>\n",
              "      <td>Indianapolis</td>\n",
              "      <td>NaN</td>\n",
              "      <td>'none'</td>\n",
              "      <td>'casual'</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>{'garage': None, 'street': False, 'validated':...</td>\n",
              "      <td>{'touristy': None, 'hipster': None, 'romantic'...</td>\n",
              "      <td>1</td>\n",
              "      <td>True</td>\n",
              "      <td>u'no'</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>{'dessert': False, 'latenight': False, 'lunch'...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>MUTTqe8uqyMdBl186RmNeA</td>\n",
              "      <td>Tuna Bar</td>\n",
              "      <td>205 Race St</td>\n",
              "      <td>Philadelphia</td>\n",
              "      <td>PA</td>\n",
              "      <td>19106</td>\n",
              "      <td>39.953949</td>\n",
              "      <td>-75.143226</td>\n",
              "      <td>4.0</td>\n",
              "      <td>245</td>\n",
              "      <td>1</td>\n",
              "      <td>{'RestaurantsReservations': 'True', 'Restauran...</td>\n",
              "      <td>Sushi Bars, Restaurants, Japanese</td>\n",
              "      <td>{'Tuesday': '13:30-22:0', 'Wednesday': '13:30-...</td>\n",
              "      <td>Philadelphia</td>\n",
              "      <td>NaN</td>\n",
              "      <td>'full_bar'</td>\n",
              "      <td>'casual'</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>u'average'</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>{u'valet': False, u'garage': None, u'street': ...</td>\n",
              "      <td>{'touristy': False, 'hipster': False, 'romanti...</td>\n",
              "      <td>2</td>\n",
              "      <td>False</td>\n",
              "      <td>'free'</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>{'dessert': True, 'latenight': None, 'lunch': ...</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>ROeacJQwBeh05Rqg7F6TCg</td>\n",
              "      <td>BAP</td>\n",
              "      <td>1224 South St</td>\n",
              "      <td>Philadelphia</td>\n",
              "      <td>PA</td>\n",
              "      <td>19147</td>\n",
              "      <td>39.943223</td>\n",
              "      <td>-75.162568</td>\n",
              "      <td>4.5</td>\n",
              "      <td>205</td>\n",
              "      <td>1</td>\n",
              "      <td>{'NoiseLevel': 'u'quiet'', 'GoodForMeal': '{'d...</td>\n",
              "      <td>Korean, Restaurants</td>\n",
              "      <td>{'Monday': '11:30-20:30', 'Tuesday': '11:30-20...</td>\n",
              "      <td>Philadelphia</td>\n",
              "      <td>True</td>\n",
              "      <td>u'none'</td>\n",
              "      <td>u'casual'</td>\n",
              "      <td>None</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>u'quiet'</td>\n",
              "      <td>True</td>\n",
              "      <td>None</td>\n",
              "      <td>{'garage': False, 'street': True, 'validated':...</td>\n",
              "      <td>{'touristy': False, 'hipster': False, 'romanti...</td>\n",
              "      <td>1</td>\n",
              "      <td>True</td>\n",
              "      <td>u'no'</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>{'dessert': False, 'latenight': False, 'lunch'...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>kfNv-JZpuN6TVNSO6hHdkw</td>\n",
              "      <td>Hibachi Express</td>\n",
              "      <td>6625 E 82nd St</td>\n",
              "      <td>Indianapolis</td>\n",
              "      <td>IN</td>\n",
              "      <td>46250</td>\n",
              "      <td>39.904320</td>\n",
              "      <td>-86.053080</td>\n",
              "      <td>4.0</td>\n",
              "      <td>20</td>\n",
              "      <td>1</td>\n",
              "      <td>{'RestaurantsDelivery': 'True', 'RestaurantsTa...</td>\n",
              "      <td>Steakhouses, Asian Fusion, Restaurants</td>\n",
              "      <td>{'Monday': '11:0-21:0', 'Tuesday': '11:0-21:0'...</td>\n",
              "      <td>Indianapolis</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>9OG5YkX1g2GReZM0AskizA</td>\n",
              "      <td>Romano's Macaroni Grill</td>\n",
              "      <td>5505 S Virginia St</td>\n",
              "      <td>Reno</td>\n",
              "      <td>NV</td>\n",
              "      <td>89502</td>\n",
              "      <td>39.476117</td>\n",
              "      <td>-119.789339</td>\n",
              "      <td>2.5</td>\n",
              "      <td>339</td>\n",
              "      <td>1</td>\n",
              "      <td>{'RestaurantsGoodForGroups': 'True', 'Restaura...</td>\n",
              "      <td>Restaurants, Italian</td>\n",
              "      <td>{'Monday': '11:0-22:0', 'Tuesday': '11:0-22:0'...</td>\n",
              "      <td>Reno</td>\n",
              "      <td>True</td>\n",
              "      <td>'full_bar'</td>\n",
              "      <td>'casual'</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>u'average'</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>{'garage': False, 'street': False, 'validated'...</td>\n",
              "      <td>{u'divey': False, u'hipster': False, u'casual'...</td>\n",
              "      <td>2</td>\n",
              "      <td>True</td>\n",
              "      <td>u'free'</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>{'dessert': None, 'latenight': False, 'lunch':...</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>4iRzR7OaS-QaSXuvYxEGKA</td>\n",
              "      <td>Super Dog</td>\n",
              "      <td>1160 Gallatin Pike S</td>\n",
              "      <td>Nashville</td>\n",
              "      <td>TN</td>\n",
              "      <td>37115</td>\n",
              "      <td>36.248570</td>\n",
              "      <td>-86.719986</td>\n",
              "      <td>4.0</td>\n",
              "      <td>6</td>\n",
              "      <td>0</td>\n",
              "      <td>{'RestaurantsReservations': 'False', 'Restaura...</td>\n",
              "      <td>Hot Dogs, Restaurants</td>\n",
              "      <td>None</td>\n",
              "      <td>Nashville</td>\n",
              "      <td>False</td>\n",
              "      <td>u'beer_and_wine'</td>\n",
              "      <td>u'casual'</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>u'average'</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>{'garage': False, 'street': False, 'validated'...</td>\n",
              "      <td>{'romantic': False, 'intimate': False, 'touris...</td>\n",
              "      <td>1</td>\n",
              "      <td>True</td>\n",
              "      <td>u'no'</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>tMkwHmWFUEXrC9ZduonpTg</td>\n",
              "      <td>The Green Pheasant</td>\n",
              "      <td>215 1st Ave S</td>\n",
              "      <td>Nashville</td>\n",
              "      <td>TN</td>\n",
              "      <td>37201</td>\n",
              "      <td>36.159886</td>\n",
              "      <td>-86.773197</td>\n",
              "      <td>4.0</td>\n",
              "      <td>161</td>\n",
              "      <td>0</td>\n",
              "      <td>{'RestaurantsGoodForGroups': 'True', 'HappyHou...</td>\n",
              "      <td>Restaurants, Japanese, Seafood</td>\n",
              "      <td>{'Wednesday': '16:0-22:0', 'Thursday': '16:0-2...</td>\n",
              "      <td>Nashville</td>\n",
              "      <td>True</td>\n",
              "      <td>u'full_bar'</td>\n",
              "      <td>u'casual'</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>False</td>\n",
              "      <td>u'average'</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>{'garage': True, 'street': False, 'validated':...</td>\n",
              "      <td>{'touristy': False, 'hipster': False, 'romanti...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>False</td>\n",
              "      <td>u'free'</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>{'dessert': None, 'latenight': None, 'lunch': ...</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>QdN72BWoyFypdGJhhI5r7g</td>\n",
              "      <td>Bar One</td>\n",
              "      <td>767 S 9th St</td>\n",
              "      <td>Philadelphia</td>\n",
              "      <td>PA</td>\n",
              "      <td>19147</td>\n",
              "      <td>39.939825</td>\n",
              "      <td>-75.157447</td>\n",
              "      <td>4.0</td>\n",
              "      <td>65</td>\n",
              "      <td>0</td>\n",
              "      <td>{'Smoking': 'u'no'', 'NoiseLevel': 'u'average'...</td>\n",
              "      <td>Cocktail Bars, Bars, Italian, Nightlife, Resta...</td>\n",
              "      <td>{'Monday': '16:0-0:0', 'Tuesday': '16:0-0:0', ...</td>\n",
              "      <td>Philadelphia</td>\n",
              "      <td>False</td>\n",
              "      <td>u'full_bar'</td>\n",
              "      <td>'casual'</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>u'average'</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>{'garage': None, 'street': True, 'validated': ...</td>\n",
              "      <td>{'touristy': False, 'hipster': True, 'romantic...</td>\n",
              "      <td>2</td>\n",
              "      <td>False</td>\n",
              "      <td>u'free'</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>{'dessert': False, 'latenight': False, 'lunch'...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>u'no'</td>\n",
              "      <td>{'dj': False, 'background_music': False, 'no_m...</td>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>sqSqqLy0sN8n2IZrAbzidQ</td>\n",
              "      <td>Domino's Pizza</td>\n",
              "      <td>3001 Highway 31 W</td>\n",
              "      <td>White House</td>\n",
              "      <td>TN</td>\n",
              "      <td>37188</td>\n",
              "      <td>36.464747</td>\n",
              "      <td>-86.659187</td>\n",
              "      <td>3.5</td>\n",
              "      <td>8</td>\n",
              "      <td>1</td>\n",
              "      <td>{'RestaurantsPriceRange2': '1'}</td>\n",
              "      <td>Pizza, Chicken Wings, Sandwiches, Restaurants</td>\n",
              "      <td>{'Monday': '10:0-0:0', 'Tuesday': '10:0-0:0', ...</td>\n",
              "      <td>Nashville</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-d715ccf1-64d6-4a60-a3b3-14dd292aa9a4')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-d715ccf1-64d6-4a60-a3b3-14dd292aa9a4 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-d715ccf1-64d6-4a60-a3b3-14dd292aa9a4');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 23
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Clean the categories"
      ],
      "metadata": {
        "id": "Ex-7W9EYo32H"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df_b.columns"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "U5FK8rqjPDMK",
        "outputId": "64c9320a-b2d1-4863-fccd-9b874e3fb5a7"
      },
      "execution_count": 24,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['business_id', 'name', 'address', 'city', 'state', 'postal_code',\n",
              "       'latitude', 'longitude', 'stars', 'review_count', 'is_open',\n",
              "       'attributes', 'categories', 'hours', 'market', 'Caters', 'Alcohol',\n",
              "       'RestaurantsAttire', 'RestaurantsDelivery', 'RestaurantsTakeOut',\n",
              "       'HasTV', 'NoiseLevel', 'BusinessAcceptsCreditCards', 'OutdoorSeating',\n",
              "       'BusinessParking', 'Ambience', 'RestaurantsPriceRange2', 'GoodForKids',\n",
              "       'WiFi', 'RestaurantsReservations', 'RestaurantsGoodForGroups',\n",
              "       'BikeParking', 'GoodForMeal', 'DogsAllowed', 'HappyHour',\n",
              "       'WheelchairAccessible', 'RestaurantsTableService',\n",
              "       'BusinessAcceptsBitcoin', 'Smoking', 'Music', 'GoodForDancing',\n",
              "       'CoatCheck', 'BestNights', 'BYOB', 'ByAppointmentOnly', 'DriveThru',\n",
              "       'Corkage', 'BYOBCorkage', 'RestaurantsCounterService', 'Open24Hours',\n",
              "       'AgesAllowed', 'AcceptsInsurance', 'DietaryRestrictions'],\n",
              "      dtype='object')"
            ]
          },
          "metadata": {},
          "execution_count": 24
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "all_attributes = ['Caters', 'Alcohol',\n",
        "       'RestaurantsAttire', 'RestaurantsDelivery', 'RestaurantsTakeOut',\n",
        "       'HasTV', 'NoiseLevel', 'BusinessAcceptsCreditCards', 'OutdoorSeating',\n",
        "       'BusinessParking', 'Ambience', 'RestaurantsPriceRange2', 'GoodForKids',\n",
        "       'WiFi', 'RestaurantsReservations', 'RestaurantsGoodForGroups',\n",
        "       'BikeParking', 'GoodForMeal', 'DogsAllowed', 'HappyHour',\n",
        "       'WheelchairAccessible', 'RestaurantsTableService',\n",
        "       'BusinessAcceptsBitcoin', 'Smoking', 'Music', 'GoodForDancing',\n",
        "       'CoatCheck', 'BestNights', 'BYOB', 'ByAppointmentOnly', 'DriveThru',\n",
        "       'Corkage', 'BYOBCorkage', 'RestaurantsCounterService', 'Open24Hours',\n",
        "       'AgesAllowed', 'AcceptsInsurance', 'DietaryRestrictions']"
      ],
      "metadata": {
        "id": "hLxE8FG5oriP"
      },
      "execution_count": 25,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# sub attributes that can be cleaned up later. I could not find a way to hot encode these without getting error messages.\n",
        "# Dietary restrictions has sub-attributes but will be manually cleaned\n",
        "sub_attributes =  ['BusinessParking', 'Ambience', 'GoodForMeal', 'Music', 'BestNights']"
      ],
      "metadata": {
        "id": "NaJM3Ya0pQ-E"
      },
      "execution_count": 26,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "no_sub_attributes = ['Caters', 'Alcohol',\n",
        "       'RestaurantsAttire', 'RestaurantsDelivery', 'RestaurantsTakeOut',\n",
        "       'HasTV', 'NoiseLevel', 'BusinessAcceptsCreditCards', 'OutdoorSeating', \n",
        "       'RestaurantsPriceRange2', 'GoodForKids',\n",
        "       'WiFi', 'RestaurantsReservations', 'RestaurantsGoodForGroups',\n",
        "       'BikeParking', 'DogsAllowed', 'HappyHour',\n",
        "       'WheelchairAccessible', 'RestaurantsTableService',\n",
        "       'BusinessAcceptsBitcoin', 'Smoking', 'GoodForDancing',\n",
        "       'CoatCheck', 'BYOB', 'ByAppointmentOnly', 'DriveThru',\n",
        "       'Corkage', 'BYOBCorkage', 'RestaurantsCounterService', 'Open24Hours',\n",
        "       'AgesAllowed', 'AcceptsInsurance', 'DietaryRestrictions']"
      ],
      "metadata": {
        "id": "wgsZmdNGpNZ8"
      },
      "execution_count": 27,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "for column in no_sub_attributes:\n",
        "  print(column,': ',df_b[column].unique().tolist())"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "ZaMVsCqQs4w_",
        "outputId": "8864b4ef-9bb7-4a9b-aa0e-abe5f3f57269"
      },
      "execution_count": 28,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Caters :  ['True', nan, 'False', None, 'None']\n",
            "Alcohol :  [\"u'full_bar'\", \"'none'\", \"'full_bar'\", \"u'none'\", nan, \"u'beer_and_wine'\", \"'beer_and_wine'\", None, 'None']\n",
            "RestaurantsAttire :  [\"u'casual'\", \"'casual'\", nan, \"u'formal'\", \"'dressy'\", None, \"u'dressy'\", 'None', \"'formal'\"]\n",
            "RestaurantsDelivery :  ['False', 'True', 'None', nan, None]\n",
            "RestaurantsTakeOut :  ['True', 'None', nan, 'False', None]\n",
            "HasTV :  ['True', 'False', nan, None, 'None']\n",
            "NoiseLevel :  [\"u'average'\", nan, \"u'quiet'\", \"'average'\", \"u'loud'\", \"'quiet'\", None, \"'very_loud'\", \"u'very_loud'\", \"'loud'\", 'None']\n",
            "BusinessAcceptsCreditCards :  ['True', nan, 'False', None, 'None']\n",
            "OutdoorSeating :  ['True', 'False', 'None', nan, None]\n",
            "RestaurantsPriceRange2 :  ['1', '2', nan, '3', '4', None, 'None']\n",
            "GoodForKids :  ['True', 'False', nan, None, 'None']\n",
            "WiFi :  [\"u'free'\", \"u'no'\", \"'free'\", nan, \"'no'\", None, \"'paid'\", 'None', \"u'paid'\"]\n",
            "RestaurantsReservations :  ['False', 'True', nan, None, 'None']\n",
            "RestaurantsGoodForGroups :  ['True', 'False', nan, None, 'None']\n",
            "BikeParking :  [nan, 'False', 'True', None, 'None']\n",
            "DogsAllowed :  [nan, 'False', 'True', None, 'None']\n",
            "HappyHour :  [nan, 'True', 'False', None]\n",
            "WheelchairAccessible :  [nan, 'True', 'False', None, 'None']\n",
            "RestaurantsTableService :  [nan, 'True', 'False', None, 'None']\n",
            "BusinessAcceptsBitcoin :  [nan, 'False', None, 'True']\n",
            "Smoking :  [nan, \"u'no'\", \"u'outdoor'\", None, \"u'yes'\", \"'no'\", \"'outdoor'\", 'None']\n",
            "GoodForDancing :  [nan, 'False', 'True', None]\n",
            "CoatCheck :  [nan, 'False', 'True', None, 'None']\n",
            "BYOB :  [nan, 'False', None, 'None', 'True']\n",
            "ByAppointmentOnly :  [nan, 'False', None, 'True']\n",
            "DriveThru :  [nan, 'False', 'True', None, 'None']\n",
            "Corkage :  [nan, 'True', 'False', None, 'None']\n",
            "BYOBCorkage :  [nan, \"'yes_free'\", None, \"'no'\", \"'yes_corkage'\", \"u'yes_free'\", \"u'yes_corkage'\", \"u'no'\", 'None']\n",
            "RestaurantsCounterService :  [nan, None, 'True', 'False']\n",
            "Open24Hours :  [nan, None, 'False', 'True']\n",
            "AgesAllowed :  [nan, None, \"u'allages'\", \"u'21plus'\"]\n",
            "AcceptsInsurance :  [nan, None, 'False', 'True']\n",
            "DietaryRestrictions :  [nan, None, \"{'dairy-free': False, 'gluten-free': False, 'vegan': False, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': True}\", \"{'dairy-free': False, 'gluten-free': True, 'vegan': False, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': False}\", 'None', \"{'dairy-free': False, 'gluten-free': False, 'vegan': True, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': False}\", \"{'dairy-free': False, 'gluten-free': False, 'vegan': True, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': True}\", \"{'dairy-free': True, 'gluten-free': True, 'vegan': True, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': True}\", \"{'dairy-free': False, 'gluten-free': False, 'vegan': True, 'kosher': False, 'halal': True, 'soy-free': False, 'vegetarian': True}\"]\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df_clean = df_b"
      ],
      "metadata": {
        "id": "uMZGJ34l2OHa"
      },
      "execution_count": 29,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Some missing values are represented by different values such as nan, None, 'None'\n",
        "# Combine into one category\n",
        "\n",
        "for column in no_sub_attributes:\n",
        "  df_clean[column] = df_clean[column].replace(['none','None', None],np.NaN)"
      ],
      "metadata": {
        "id": "p1xUtIw80IKR"
      },
      "execution_count": 30,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# manually fix other columns by combining some categories\n",
        "\n",
        "df_clean['Alcohol'] = df_clean['Alcohol'].replace([\"u'full_bar'\", \"'none'\", \"'full_bar'\", \"u'none'\", \"u'beer_and_wine'\", \"'beer_and_wine'\"],\n",
        "                                                  ['full_bar', 'None', 'full_bar', 'None', 'beer_and_wine', 'beer_and_wine'])\n",
        "\n",
        "df_clean['RestaurantsAttire'] = df_clean['RestaurantsAttire'].replace([\"u'casual'\", \"'casual'\", \"u'formal'\", \"'dressy'\", \"u'dressy'\", \"'formal'\"],\n",
        "                                                  ['casual', 'casual', 'formal', 'dressy', 'dressy', 'formal'])\n",
        "\n",
        "df_clean['NoiseLevel'] = df_clean['NoiseLevel'].replace([\"u'average'\", \"u'quiet'\", \"'average'\", \"u'loud'\", \"'quiet'\", \"'very_loud'\", \"u'very_loud'\", \"'loud'\"],\n",
        "                                                  ['average', 'quiet', 'average', 'loud', 'quiet', 'very_loud', 'very_loud', 'loud'])\n",
        "\n",
        "df_clean['WiFi'] = df_clean['WiFi'].replace([\"u'free'\", \"u'no'\", \"'free'\", \"'no'\", \"'paid'\", \"u'paid'\"],\n",
        "                                                  ['free', 'no', 'free', 'no', 'paid', 'paid'])\n",
        "\n",
        "df_clean['Smoking'] = df_clean['Smoking'].replace([\"u'no'\", \"u'outdoor'\", \"u'yes'\", \"'no'\", \"'outdoor'\"],\n",
        "                                                  ['no', 'outdoor', 'yes', 'no', 'outdoor'])\n",
        "\n",
        "df_clean['BYOBCorkage'] = df_clean['BYOBCorkage'].replace([\"'yes_free'\", \"'no'\", \"'yes_corkage'\", \"u'yes_free'\", \"u'yes_corkage'\", \"u'no'\"],\n",
        "                                                  ['yes_free', 'no', 'yes_corkage', 'yes_free', 'yes_corkage', 'no'])\n",
        "\n",
        "df_clean['AgesAllowed'] = df_clean['AgesAllowed'].replace([\"u'allages'\", \"u'21plus'\"],\n",
        "                                                  ['allages', '21plus'])"
      ],
      "metadata": {
        "id": "33C05acD5mnB"
      },
      "execution_count": 31,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "#Manually clean dietary restrictions\n",
        "df_clean['DietaryRestrictions'] = df_clean['DietaryRestrictions'].replace([\"{'dairy-free': False, 'gluten-free': False, 'vegan': False, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': True}\", \"{'dairy-free': False, 'gluten-free': True, 'vegan': False, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': False}\", \"{'dairy-free': False, 'gluten-free': False, 'vegan': True, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': False}\", \"{'dairy-free': False, 'gluten-free': False, 'vegan': True, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': True}\", \"{'dairy-free': True, 'gluten-free': True, 'vegan': True, 'kosher': False, 'halal': False, 'soy-free': False, 'vegetarian': True}\", \"{'dairy-free': False, 'gluten-free': False, 'vegan': True, 'kosher': False, 'halal': True, 'soy-free': False, 'vegetarian': True}\"],\n",
        "                                                  ['vegetarian','gluten_free', 'vegan_vegetarian', 'vegan_vegetarian',\n",
        "                                                   'dairy-free_gluten-free_vegan_vegetarian', 'vegan_vegetarian_halal'])"
      ],
      "metadata": {
        "id": "bBnskeSl-b4h"
      },
      "execution_count": 32,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_clean['DietaryRestrictions'].value_counts()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "lm_gKzE1CBds",
        "outputId": "946e8055-c67d-4d3c-8e0f-11f89ab04e50"
      },
      "execution_count": 33,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "gluten_free                                5\n",
              "vegetarian                                 3\n",
              "vegan_vegetarian                           3\n",
              "dairy-free_gluten-free_vegan_vegetarian    1\n",
              "vegan_vegetarian_halal                     1\n",
              "Name: DietaryRestrictions, dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 33
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Only 13 rows have data for dietary restrictions. Not going to one-hot encode because most are missing"
      ],
      "metadata": {
        "id": "qtw5UtMGCvnH"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Confirm that attribute columns are clean\n",
        "for column in no_sub_attributes:\n",
        "  print(column,': ',df_clean[column].unique().tolist())"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "2AWJZUQU5D-l",
        "outputId": "06d32d96-6607-43d5-fd6b-a3bcec1b4ce3"
      },
      "execution_count": 34,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Caters :  ['True', nan, 'False']\n",
            "Alcohol :  ['full_bar', 'None', nan, 'beer_and_wine']\n",
            "RestaurantsAttire :  ['casual', nan, 'formal', 'dressy']\n",
            "RestaurantsDelivery :  ['False', 'True', nan]\n",
            "RestaurantsTakeOut :  ['True', nan, 'False']\n",
            "HasTV :  ['True', 'False', nan]\n",
            "NoiseLevel :  ['average', nan, 'quiet', 'loud', 'very_loud']\n",
            "BusinessAcceptsCreditCards :  ['True', nan, 'False']\n",
            "OutdoorSeating :  ['True', 'False', nan]\n",
            "RestaurantsPriceRange2 :  ['1', '2', nan, '3', '4']\n",
            "GoodForKids :  ['True', 'False', nan]\n",
            "WiFi :  ['free', 'no', nan, 'paid']\n",
            "RestaurantsReservations :  ['False', 'True', nan]\n",
            "RestaurantsGoodForGroups :  ['True', 'False', nan]\n",
            "BikeParking :  [nan, 'False', 'True']\n",
            "DogsAllowed :  [nan, 'False', 'True']\n",
            "HappyHour :  [nan, 'True', 'False']\n",
            "WheelchairAccessible :  [nan, 'True', 'False']\n",
            "RestaurantsTableService :  [nan, 'True', 'False']\n",
            "BusinessAcceptsBitcoin :  [nan, 'False', 'True']\n",
            "Smoking :  [nan, 'no', 'outdoor', 'yes']\n",
            "GoodForDancing :  [nan, 'False', 'True']\n",
            "CoatCheck :  [nan, 'False', 'True']\n",
            "BYOB :  [nan, 'False', 'True']\n",
            "ByAppointmentOnly :  [nan, 'False', 'True']\n",
            "DriveThru :  [nan, 'False', 'True']\n",
            "Corkage :  [nan, 'True', 'False']\n",
            "BYOBCorkage :  [nan, 'yes_free', 'no', 'yes_corkage']\n",
            "RestaurantsCounterService :  [nan, 'True', 'False']\n",
            "Open24Hours :  [nan, 'False', 'True']\n",
            "AgesAllowed :  [nan, 'allages', '21plus']\n",
            "AcceptsInsurance :  [nan, 'False', 'True']\n",
            "DietaryRestrictions :  [nan, 'vegetarian', 'gluten_free', 'vegan_vegetarian', 'dairy-free_gluten-free_vegan_vegetarian', 'vegan_vegetarian_halal']\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "While most of these new columns are boolean attributes, a number of them are categorical, which need some special handling. We need to encode them so models can use them as features."
      ],
      "metadata": {
        "id": "9wx0XhB6Devt"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# columns with non-boolean categorical values:\n",
        "cols_to_split = ['AgesAllowed', 'Alcohol', 'BYOBCorkage', 'NoiseLevel', 'RestaurantsAttire', 'Smoking', 'WiFi']\n",
        "new_cat = pd.concat([pd.get_dummies(df_clean[col], prefix=col, prefix_sep='_') for col in cols_to_split], axis=1)\n",
        "# keep all columns (not n-1) because 0's for all of them indicates that the data was missing (useful info)\n",
        "df_clean = pd.concat([df_clean, new_cat], axis=1)\n",
        "df_clean.drop(cols_to_split, inplace=True, axis=1)\n",
        "df_clean.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 600
        },
        "id": "66r4W7Qp0dVu",
        "outputId": "7052787e-bd7f-43ab-bc3c-278f35a904cf"
      },
      "execution_count": 35,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "               business_id                   name            address  \\\n",
              "8   k0hlBqXX-Bt0vf1op7Jr1w  Tsevi's Pub And Grill  8025 Mackenzie Rd   \n",
              "12  il_Ro8jwPlHresjw9EGmBg                Denny's       8901 US 31 S   \n",
              "15  MUTTqe8uqyMdBl186RmNeA               Tuna Bar        205 Race St   \n",
              "19  ROeacJQwBeh05Rqg7F6TCg                    BAP      1224 South St   \n",
              "22  kfNv-JZpuN6TVNSO6hHdkw        Hibachi Express     6625 E 82nd St   \n",
              "\n",
              "            city state postal_code   latitude  longitude  stars  review_count  \\\n",
              "8         Affton    MO       63123  38.565165 -90.321087    3.0            19   \n",
              "12  Indianapolis    IN       46227  39.637133 -86.127217    2.5            28   \n",
              "15  Philadelphia    PA       19106  39.953949 -75.143226    4.0           245   \n",
              "19  Philadelphia    PA       19147  39.943223 -75.162568    4.5           205   \n",
              "22  Indianapolis    IN       46250  39.904320 -86.053080    4.0            20   \n",
              "\n",
              "    is_open                                         attributes  \\\n",
              "8         0  {'Caters': 'True', 'Alcohol': 'u'full_bar'', '...   \n",
              "12        1  {'RestaurantsReservations': 'False', 'Restaura...   \n",
              "15        1  {'RestaurantsReservations': 'True', 'Restauran...   \n",
              "19        1  {'NoiseLevel': 'u'quiet'', 'GoodForMeal': '{'d...   \n",
              "22        1  {'RestaurantsDelivery': 'True', 'RestaurantsTa...   \n",
              "\n",
              "                                           categories  \\\n",
              "8   Pubs, Restaurants, Italian, Bars, American (Tr...   \n",
              "12  American (Traditional), Restaurants, Diners, B...   \n",
              "15                  Sushi Bars, Restaurants, Japanese   \n",
              "19                                Korean, Restaurants   \n",
              "22             Steakhouses, Asian Fusion, Restaurants   \n",
              "\n",
              "                                                hours        market Caters  \\\n",
              "8                                                None     St. Louis   True   \n",
              "12  {'Monday': '6:0-22:0', 'Tuesday': '6:0-22:0', ...  Indianapolis    NaN   \n",
              "15  {'Tuesday': '13:30-22:0', 'Wednesday': '13:30-...  Philadelphia    NaN   \n",
              "19  {'Monday': '11:30-20:30', 'Tuesday': '11:30-20...  Philadelphia   True   \n",
              "22  {'Monday': '11:0-21:0', 'Tuesday': '11:0-21:0'...  Indianapolis    NaN   \n",
              "\n",
              "   RestaurantsDelivery RestaurantsTakeOut  HasTV BusinessAcceptsCreditCards  \\\n",
              "8                False               True   True                       True   \n",
              "12                True               True   True                       True   \n",
              "15                True               True  False                       True   \n",
              "19                 NaN               True   True                       True   \n",
              "22                True               True    NaN                        NaN   \n",
              "\n",
              "   OutdoorSeating                                    BusinessParking  \\\n",
              "8            True  {'garage': False, 'street': False, 'validated'...   \n",
              "12          False  {'garage': None, 'street': False, 'validated':...   \n",
              "15           True  {u'valet': False, u'garage': None, u'street': ...   \n",
              "19            NaN  {'garage': False, 'street': True, 'validated':...   \n",
              "22            NaN                                                NaN   \n",
              "\n",
              "                                             Ambience RestaurantsPriceRange2  \\\n",
              "8   {'romantic': False, 'intimate': False, 'touris...                      1   \n",
              "12  {'touristy': None, 'hipster': None, 'romantic'...                      1   \n",
              "15  {'touristy': False, 'hipster': False, 'romanti...                      2   \n",
              "19  {'touristy': False, 'hipster': False, 'romanti...                      1   \n",
              "22                                                NaN                      2   \n",
              "\n",
              "   GoodForKids RestaurantsReservations RestaurantsGoodForGroups BikeParking  \\\n",
              "8         True                   False                     True         NaN   \n",
              "12        True                   False                     True       False   \n",
              "15       False                    True                     True         NaN   \n",
              "19        True                   False                    False        True   \n",
              "22         NaN                     NaN                      NaN         NaN   \n",
              "\n",
              "                                          GoodForMeal DogsAllowed HappyHour  \\\n",
              "8                                                 NaN         NaN       NaN   \n",
              "12  {'dessert': False, 'latenight': False, 'lunch'...         NaN       NaN   \n",
              "15  {'dessert': True, 'latenight': None, 'lunch': ...       False      True   \n",
              "19  {'dessert': False, 'latenight': False, 'lunch'...         NaN       NaN   \n",
              "22                                                NaN         NaN       NaN   \n",
              "\n",
              "   WheelchairAccessible RestaurantsTableService BusinessAcceptsBitcoin Music  \\\n",
              "8                   NaN                     NaN                    NaN   NaN   \n",
              "12                  NaN                     NaN                    NaN   NaN   \n",
              "15                 True                    True                    NaN   NaN   \n",
              "19                  NaN                    True                    NaN   NaN   \n",
              "22                  NaN                     NaN                    NaN   NaN   \n",
              "\n",
              "   GoodForDancing CoatCheck BestNights BYOB ByAppointmentOnly DriveThru  \\\n",
              "8             NaN       NaN        NaN  NaN               NaN       NaN   \n",
              "12            NaN       NaN        NaN  NaN               NaN       NaN   \n",
              "15            NaN       NaN        NaN  NaN               NaN       NaN   \n",
              "19            NaN       NaN        NaN  NaN               NaN       NaN   \n",
              "22            NaN       NaN        NaN  NaN               NaN       NaN   \n",
              "\n",
              "   Corkage RestaurantsCounterService Open24Hours AcceptsInsurance  \\\n",
              "8      NaN                       NaN         NaN              NaN   \n",
              "12     NaN                       NaN         NaN              NaN   \n",
              "15     NaN                       NaN         NaN              NaN   \n",
              "19     NaN                       NaN         NaN              NaN   \n",
              "22     NaN                       NaN         NaN              NaN   \n",
              "\n",
              "   DietaryRestrictions  AgesAllowed_21plus  AgesAllowed_allages  Alcohol_None  \\\n",
              "8                  NaN                   0                    0             0   \n",
              "12                 NaN                   0                    0             1   \n",
              "15                 NaN                   0                    0             0   \n",
              "19                 NaN                   0                    0             1   \n",
              "22                 NaN                   0                    0             0   \n",
              "\n",
              "    Alcohol_beer_and_wine  Alcohol_full_bar  BYOBCorkage_no  \\\n",
              "8                       0                 1               0   \n",
              "12                      0                 0               0   \n",
              "15                      0                 1               0   \n",
              "19                      0                 0               0   \n",
              "22                      0                 0               0   \n",
              "\n",
              "    BYOBCorkage_yes_corkage  BYOBCorkage_yes_free  NoiseLevel_average  \\\n",
              "8                         0                     0                   1   \n",
              "12                        0                     0                   0   \n",
              "15                        0                     0                   1   \n",
              "19                        0                     0                   0   \n",
              "22                        0                     0                   0   \n",
              "\n",
              "    NoiseLevel_loud  NoiseLevel_quiet  NoiseLevel_very_loud  \\\n",
              "8                 0                 0                     0   \n",
              "12                0                 0                     0   \n",
              "15                0                 0                     0   \n",
              "19                0                 1                     0   \n",
              "22                0                 0                     0   \n",
              "\n",
              "    RestaurantsAttire_casual  RestaurantsAttire_dressy  \\\n",
              "8                          1                         0   \n",
              "12                         1                         0   \n",
              "15                         1                         0   \n",
              "19                         1                         0   \n",
              "22                         0                         0   \n",
              "\n",
              "    RestaurantsAttire_formal  Smoking_no  Smoking_outdoor  Smoking_yes  \\\n",
              "8                          0           0                0            0   \n",
              "12                         0           0                0            0   \n",
              "15                         0           0                0            0   \n",
              "19                         0           0                0            0   \n",
              "22                         0           0                0            0   \n",
              "\n",
              "    WiFi_free  WiFi_no  WiFi_paid  \n",
              "8           1        0          0  \n",
              "12          0        1          0  \n",
              "15          1        0          0  \n",
              "19          0        1          0  \n",
              "22          0        0          0  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-afc6bdcb-b3a7-4c47-a1e0-142b5ab022b4\">\n",
              "    <div 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>business_id</th>\n",
              "      <th>name</th>\n",
              "      <th>address</th>\n",
              "      <th>city</th>\n",
              "      <th>state</th>\n",
              "      <th>postal_code</th>\n",
              "      <th>latitude</th>\n",
              "      <th>longitude</th>\n",
              "      <th>stars</th>\n",
              "      <th>review_count</th>\n",
              "      <th>is_open</th>\n",
              "      <th>attributes</th>\n",
              "      <th>categories</th>\n",
              "      <th>hours</th>\n",
              "      <th>market</th>\n",
              "      <th>Caters</th>\n",
              "      <th>RestaurantsDelivery</th>\n",
              "      <th>RestaurantsTakeOut</th>\n",
              "      <th>HasTV</th>\n",
              "      <th>BusinessAcceptsCreditCards</th>\n",
              "      <th>OutdoorSeating</th>\n",
              "      <th>BusinessParking</th>\n",
              "      <th>Ambience</th>\n",
              "      <th>RestaurantsPriceRange2</th>\n",
              "      <th>GoodForKids</th>\n",
              "      <th>RestaurantsReservations</th>\n",
              "      <th>RestaurantsGoodForGroups</th>\n",
              "      <th>BikeParking</th>\n",
              "      <th>GoodForMeal</th>\n",
              "      <th>DogsAllowed</th>\n",
              "      <th>HappyHour</th>\n",
              "      <th>WheelchairAccessible</th>\n",
              "      <th>RestaurantsTableService</th>\n",
              "      <th>BusinessAcceptsBitcoin</th>\n",
              "      <th>Music</th>\n",
              "      <th>GoodForDancing</th>\n",
              "      <th>CoatCheck</th>\n",
              "      <th>BestNights</th>\n",
              "      <th>BYOB</th>\n",
              "      <th>ByAppointmentOnly</th>\n",
              "      <th>DriveThru</th>\n",
              "      <th>Corkage</th>\n",
              "      <th>RestaurantsCounterService</th>\n",
              "      <th>Open24Hours</th>\n",
              "      <th>AcceptsInsurance</th>\n",
              "      <th>DietaryRestrictions</th>\n",
              "      <th>AgesAllowed_21plus</th>\n",
              "      <th>AgesAllowed_allages</th>\n",
              "      <th>Alcohol_None</th>\n",
              "      <th>Alcohol_beer_and_wine</th>\n",
              "      <th>Alcohol_full_bar</th>\n",
              "      <th>BYOBCorkage_no</th>\n",
              "      <th>BYOBCorkage_yes_corkage</th>\n",
              "      <th>BYOBCorkage_yes_free</th>\n",
              "      <th>NoiseLevel_average</th>\n",
              "      <th>NoiseLevel_loud</th>\n",
              "      <th>NoiseLevel_quiet</th>\n",
              "      <th>NoiseLevel_very_loud</th>\n",
              "      <th>RestaurantsAttire_casual</th>\n",
              "      <th>RestaurantsAttire_dressy</th>\n",
              "      <th>RestaurantsAttire_formal</th>\n",
              "      <th>Smoking_no</th>\n",
              "      <th>Smoking_outdoor</th>\n",
              "      <th>Smoking_yes</th>\n",
              "      <th>WiFi_free</th>\n",
              "      <th>WiFi_no</th>\n",
              "      <th>WiFi_paid</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>k0hlBqXX-Bt0vf1op7Jr1w</td>\n",
              "      <td>Tsevi's Pub And Grill</td>\n",
              "      <td>8025 Mackenzie Rd</td>\n",
              "      <td>Affton</td>\n",
              "      <td>MO</td>\n",
              "      <td>63123</td>\n",
              "      <td>38.565165</td>\n",
              "      <td>-90.321087</td>\n",
              "      <td>3.0</td>\n",
              "      <td>19</td>\n",
              "      <td>0</td>\n",
              "      <td>{'Caters': 'True', 'Alcohol': 'u'full_bar'', '...</td>\n",
              "      <td>Pubs, Restaurants, Italian, Bars, American (Tr...</td>\n",
              "      <td>None</td>\n",
              "      <td>St. Louis</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>{'garage': False, 'street': False, 'validated'...</td>\n",
              "      <td>{'romantic': False, 'intimate': False, 'touris...</td>\n",
              "      <td>1</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>il_Ro8jwPlHresjw9EGmBg</td>\n",
              "      <td>Denny's</td>\n",
              "      <td>8901 US 31 S</td>\n",
              "      <td>Indianapolis</td>\n",
              "      <td>IN</td>\n",
              "      <td>46227</td>\n",
              "      <td>39.637133</td>\n",
              "      <td>-86.127217</td>\n",
              "      <td>2.5</td>\n",
              "      <td>28</td>\n",
              "      <td>1</td>\n",
              "      <td>{'RestaurantsReservations': 'False', 'Restaura...</td>\n",
              "      <td>American (Traditional), Restaurants, Diners, B...</td>\n",
              "      <td>{'Monday': '6:0-22:0', 'Tuesday': '6:0-22:0', ...</td>\n",
              "      <td>Indianapolis</td>\n",
              "      <td>NaN</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>{'garage': None, 'street': False, 'validated':...</td>\n",
              "      <td>{'touristy': None, 'hipster': None, 'romantic'...</td>\n",
              "      <td>1</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>{'dessert': False, 'latenight': False, 'lunch'...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>MUTTqe8uqyMdBl186RmNeA</td>\n",
              "      <td>Tuna Bar</td>\n",
              "      <td>205 Race St</td>\n",
              "      <td>Philadelphia</td>\n",
              "      <td>PA</td>\n",
              "      <td>19106</td>\n",
              "      <td>39.953949</td>\n",
              "      <td>-75.143226</td>\n",
              "      <td>4.0</td>\n",
              "      <td>245</td>\n",
              "      <td>1</td>\n",
              "      <td>{'RestaurantsReservations': 'True', 'Restauran...</td>\n",
              "      <td>Sushi Bars, Restaurants, Japanese</td>\n",
              "      <td>{'Tuesday': '13:30-22:0', 'Wednesday': '13:30-...</td>\n",
              "      <td>Philadelphia</td>\n",
              "      <td>NaN</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>{u'valet': False, u'garage': None, u'street': ...</td>\n",
              "      <td>{'touristy': False, 'hipster': False, 'romanti...</td>\n",
              "      <td>2</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>{'dessert': True, 'latenight': None, 'lunch': ...</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>ROeacJQwBeh05Rqg7F6TCg</td>\n",
              "      <td>BAP</td>\n",
              "      <td>1224 South St</td>\n",
              "      <td>Philadelphia</td>\n",
              "      <td>PA</td>\n",
              "      <td>19147</td>\n",
              "      <td>39.943223</td>\n",
              "      <td>-75.162568</td>\n",
              "      <td>4.5</td>\n",
              "      <td>205</td>\n",
              "      <td>1</td>\n",
              "      <td>{'NoiseLevel': 'u'quiet'', 'GoodForMeal': '{'d...</td>\n",
              "      <td>Korean, Restaurants</td>\n",
              "      <td>{'Monday': '11:30-20:30', 'Tuesday': '11:30-20...</td>\n",
              "      <td>Philadelphia</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>{'garage': False, 'street': True, 'validated':...</td>\n",
              "      <td>{'touristy': False, 'hipster': False, 'romanti...</td>\n",
              "      <td>1</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>True</td>\n",
              "      <td>{'dessert': False, 'latenight': False, 'lunch'...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>kfNv-JZpuN6TVNSO6hHdkw</td>\n",
              "      <td>Hibachi Express</td>\n",
              "      <td>6625 E 82nd St</td>\n",
              "      <td>Indianapolis</td>\n",
              "      <td>IN</td>\n",
              "      <td>46250</td>\n",
              "      <td>39.904320</td>\n",
              "      <td>-86.053080</td>\n",
              "      <td>4.0</td>\n",
              "      <td>20</td>\n",
              "      <td>1</td>\n",
              "      <td>{'RestaurantsDelivery': 'True', 'RestaurantsTa...</td>\n",
              "      <td>Steakhouses, Asian Fusion, Restaurants</td>\n",
              "      <td>{'Monday': '11:0-21:0', 'Tuesday': '11:0-21:0'...</td>\n",
              "      <td>Indianapolis</td>\n",
              "      <td>NaN</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-afc6bdcb-b3a7-4c47-a1e0-142b5ab022b4')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-afc6bdcb-b3a7-4c47-a1e0-142b5ab022b4 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-afc6bdcb-b3a7-4c47-a1e0-142b5ab022b4');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 35
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Replace boolean with numeric values\n",
        "df_clean.replace({False: 0, True: 1}, inplace=True)"
      ],
      "metadata": {
        "id": "w5zQz8hoz_Xk"
      },
      "execution_count": 36,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "This is the clean dataset version 1. The missing attribute values have not been replaced but will need to be for future model development. \n",
        "The sub_attributes =  ['BusinessParking', 'Ambience', 'GoodForMeal', 'Music', 'BestNights'] need to one-hot encoded later."
      ],
      "metadata": {
        "id": "5ZW1aVfhGfP9"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df_clean.to_csv('/content/gdrive/MyDrive/yelp_dataset/yelp_business_clean_version1.csv')"
      ],
      "metadata": {
        "id": "qY8xFiltsqbr"
      },
      "execution_count": 37,
      "outputs": []
    }
  ]
}