EDA_yelp_business_cleaned_v4.ipynb

{
  "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/EDA_yelp_business_cleaned_v4.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "from google.colab import drive\n",
        "drive.mount('/content/gdrive')\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "p_5-NDa8szfs",
        "outputId": "50dd16c2-8cc6-412e-fc7e-405907e9717d"
      },
      "id": "p_5-NDa8szfs",
      "execution_count": 1,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Drive already mounted at /content/gdrive; to attempt to forcibly remount, call drive.mount(\"/content/gdrive\", force_remount=True).\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "from tqdm import tqdm\n",
        "\n",
        "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": "q5TvsTMRjVrC"
      },
      "id": "q5TvsTMRjVrC",
      "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_business_clean_version1.csv'\n",
        "df_b = pd.read_csv(business_json_path)"
      ],
      "metadata": {
        "id": "PM1mqf4DjVxP",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "e9b81b8b-b9ee-4c85-9baf-646d0577dbf0"
      },
      "id": "PM1mqf4DjVxP",
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "/usr/local/lib/python3.7/dist-packages/IPython/core/interactiveshell.py:3326: DtypeWarning: Columns (43,44,45,46) have mixed types.Specify dtype option on import or set low_memory=False.\n",
            "  exec(code_obj, self.user_global_ns, self.user_ns)\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df_b"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 731
        },
        "id": "J7yLUpiG_HhF",
        "outputId": "6da208c0-a9d1-454b-e694-0bc25f9001f0"
      },
      "id": "J7yLUpiG_HhF",
      "execution_count": 4,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "       Unnamed: 0             business_id                           name  \\\n",
              "0               8  k0hlBqXX-Bt0vf1op7Jr1w          Tsevi's Pub And Grill   \n",
              "1              12  il_Ro8jwPlHresjw9EGmBg                        Denny's   \n",
              "2              15  MUTTqe8uqyMdBl186RmNeA                       Tuna Bar   \n",
              "3              19  ROeacJQwBeh05Rqg7F6TCg                            BAP   \n",
              "4              22  kfNv-JZpuN6TVNSO6hHdkw                Hibachi Express   \n",
              "...           ...                     ...                            ...   \n",
              "35285      150298  gPr1io7ks0Eo3FDsnDTYfg                      Tata Cafe   \n",
              "35286      150306  wVxXRFf10zTTAs11nr4xeA                   PrimoHoagies   \n",
              "35287      150322  2MAQeAqmD8enCT2ZYqUgIQ    The Melting Pot - Nashville   \n",
              "35288      150323  w_4xUt-1AyY2ZwKtnjW0Xg           Bittercreek Alehouse   \n",
              "35289      150336  WnT9NIzQgLlILjPT0kEcsQ  Adelita Taqueria & Restaurant   \n",
              "\n",
              "                    address          city state  postal_code   latitude  \\\n",
              "0         8025 Mackenzie Rd        Affton    MO      63123.0  38.565165   \n",
              "1              8901 US 31 S  Indianapolis    IN      46227.0  39.637133   \n",
              "2               205 Race St  Philadelphia    PA      19106.0  39.953949   \n",
              "3             1224 South St  Philadelphia    PA      19147.0  39.943223   \n",
              "4            6625 E 82nd St  Indianapolis    IN      46250.0  39.904320   \n",
              "...                     ...           ...   ...          ...        ...   \n",
              "35285   7201 Germantown Ave  Philadelphia    PA      19119.0  40.060414   \n",
              "35286        6024 Ridge Ave  Philadelphia    PA      19128.0  40.032483   \n",
              "35287  166 2nd Ave N, Ste A     Nashville    TN      37201.0  36.163875   \n",
              "35288          246 N 8th St         Boise    ID      83702.0  43.616590   \n",
              "35289         1108 S 9th St  Philadelphia    PA      19147.0  39.935982   \n",
              "\n",
              "        longitude  stars  ...  NoiseLevel_very_loud  RestaurantsAttire_casual  \\\n",
              "0      -90.321087    3.0  ...                     0                         1   \n",
              "1      -86.127217    2.5  ...                     0                         1   \n",
              "2      -75.143226    4.0  ...                     0                         1   \n",
              "3      -75.162568    4.5  ...                     0                         1   \n",
              "4      -86.053080    4.0  ...                     0                         0   \n",
              "...           ...    ...  ...                   ...                       ...   \n",
              "35285  -75.191084    4.0  ...                     0                         1   \n",
              "35286  -75.214430    3.0  ...                     0                         1   \n",
              "35287  -86.776311    4.0  ...                     0                         0   \n",
              "35288 -116.202383    4.5  ...                     0                         1   \n",
              "35289  -75.158665    4.5  ...                     0                         1   \n",
              "\n",
              "      RestaurantsAttire_dressy RestaurantsAttire_formal Smoking_no  \\\n",
              "0                            0                        0          0   \n",
              "1                            0                        0          0   \n",
              "2                            0                        0          0   \n",
              "3                            0                        0          0   \n",
              "4                            0                        0          0   \n",
              "...                        ...                      ...        ...   \n",
              "35285                        0                        0          0   \n",
              "35286                        0                        0          0   \n",
              "35287                        1                        0          0   \n",
              "35288                        0                        0          0   \n",
              "35289                        0                        0          0   \n",
              "\n",
              "      Smoking_outdoor Smoking_yes WiFi_free WiFi_no WiFi_paid  \n",
              "0                   0           0         1       0         0  \n",
              "1                   0           0         0       1         0  \n",
              "2                   0           0         1       0         0  \n",
              "3                   0           0         0       1         0  \n",
              "4                   0           0         0       0         0  \n",
              "...               ...         ...       ...     ...       ...  \n",
              "35285               0           0         1       0         0  \n",
              "35286               0           0         0       1         0  \n",
              "35287               0           0         1       0         0  \n",
              "35288               0           0         1       0         0  \n",
              "35289               0           0         1       0         0  \n",
              "\n",
              "[35290 rows x 68 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-71e25949-c544-439d-94c8-576756748d3d\">\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>Unnamed: 0</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>...</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>0</th>\n",
              "      <td>8</td>\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.0</td>\n",
              "      <td>38.565165</td>\n",
              "      <td>-90.321087</td>\n",
              "      <td>3.0</td>\n",
              "      <td>...</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>1</th>\n",
              "      <td>12</td>\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.0</td>\n",
              "      <td>39.637133</td>\n",
              "      <td>-86.127217</td>\n",
              "      <td>2.5</td>\n",
              "      <td>...</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>2</th>\n",
              "      <td>15</td>\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.0</td>\n",
              "      <td>39.953949</td>\n",
              "      <td>-75.143226</td>\n",
              "      <td>4.0</td>\n",
              "      <td>...</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>3</th>\n",
              "      <td>19</td>\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.0</td>\n",
              "      <td>39.943223</td>\n",
              "      <td>-75.162568</td>\n",
              "      <td>4.5</td>\n",
              "      <td>...</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>4</th>\n",
              "      <td>22</td>\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.0</td>\n",
              "      <td>39.904320</td>\n",
              "      <td>-86.053080</td>\n",
              "      <td>4.0</td>\n",
              "      <td>...</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",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35285</th>\n",
              "      <td>150298</td>\n",
              "      <td>gPr1io7ks0Eo3FDsnDTYfg</td>\n",
              "      <td>Tata Cafe</td>\n",
              "      <td>7201 Germantown Ave</td>\n",
              "      <td>Philadelphia</td>\n",
              "      <td>PA</td>\n",
              "      <td>19119.0</td>\n",
              "      <td>40.060414</td>\n",
              "      <td>-75.191084</td>\n",
              "      <td>4.0</td>\n",
              "      <td>...</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>35286</th>\n",
              "      <td>150306</td>\n",
              "      <td>wVxXRFf10zTTAs11nr4xeA</td>\n",
              "      <td>PrimoHoagies</td>\n",
              "      <td>6024 Ridge Ave</td>\n",
              "      <td>Philadelphia</td>\n",
              "      <td>PA</td>\n",
              "      <td>19128.0</td>\n",
              "      <td>40.032483</td>\n",
              "      <td>-75.214430</td>\n",
              "      <td>3.0</td>\n",
              "      <td>...</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>35287</th>\n",
              "      <td>150322</td>\n",
              "      <td>2MAQeAqmD8enCT2ZYqUgIQ</td>\n",
              "      <td>The Melting Pot - Nashville</td>\n",
              "      <td>166 2nd Ave N, Ste A</td>\n",
              "      <td>Nashville</td>\n",
              "      <td>TN</td>\n",
              "      <td>37201.0</td>\n",
              "      <td>36.163875</td>\n",
              "      <td>-86.776311</td>\n",
              "      <td>4.0</td>\n",
              "      <td>...</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>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35288</th>\n",
              "      <td>150323</td>\n",
              "      <td>w_4xUt-1AyY2ZwKtnjW0Xg</td>\n",
              "      <td>Bittercreek Alehouse</td>\n",
              "      <td>246 N 8th St</td>\n",
              "      <td>Boise</td>\n",
              "      <td>ID</td>\n",
              "      <td>83702.0</td>\n",
              "      <td>43.616590</td>\n",
              "      <td>-116.202383</td>\n",
              "      <td>4.5</td>\n",
              "      <td>...</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>35289</th>\n",
              "      <td>150336</td>\n",
              "      <td>WnT9NIzQgLlILjPT0kEcsQ</td>\n",
              "      <td>Adelita Taqueria &amp; Restaurant</td>\n",
              "      <td>1108 S 9th St</td>\n",
              "      <td>Philadelphia</td>\n",
              "      <td>PA</td>\n",
              "      <td>19147.0</td>\n",
              "      <td>39.935982</td>\n",
              "      <td>-75.158665</td>\n",
              "      <td>4.5</td>\n",
              "      <td>...</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",
              "  </tbody>\n",
              "</table>\n",
              "<p>35290 rows × 68 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-71e25949-c544-439d-94c8-576756748d3d')\"\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-71e25949-c544-439d-94c8-576756748d3d 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-71e25949-c544-439d-94c8-576756748d3d');\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": 4
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df_b.info()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "fRwhtSX5_mKx",
        "outputId": "3434dc5a-43f4-40f1-d197-36ab3fbe1bf5"
      },
      "id": "fRwhtSX5_mKx",
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 35290 entries, 0 to 35289\n",
            "Data columns (total 68 columns):\n",
            " #   Column                      Non-Null Count  Dtype  \n",
            "---  ------                      --------------  -----  \n",
            " 0   Unnamed: 0                  35290 non-null  int64  \n",
            " 1   business_id                 35290 non-null  object \n",
            " 2   name                        35290 non-null  object \n",
            " 3   address                     35215 non-null  object \n",
            " 4   city                        35290 non-null  object \n",
            " 5   state                       35290 non-null  object \n",
            " 6   postal_code                 35289 non-null  float64\n",
            " 7   latitude                    35290 non-null  float64\n",
            " 8   longitude                   35290 non-null  float64\n",
            " 9   stars                       35290 non-null  float64\n",
            " 10  review_count                35290 non-null  int64  \n",
            " 11  is_open                     35290 non-null  int64  \n",
            " 12  attributes                  34914 non-null  object \n",
            " 13  categories                  35290 non-null  object \n",
            " 14  hours                       29785 non-null  object \n",
            " 15  market                      35290 non-null  object \n",
            " 16  Caters                      23397 non-null  object \n",
            " 17  RestaurantsDelivery         30318 non-null  object \n",
            " 18  RestaurantsTakeOut          32068 non-null  object \n",
            " 19  HasTV                       29680 non-null  object \n",
            " 20  BusinessAcceptsCreditCards  32136 non-null  object \n",
            " 21  OutdoorSeating              29439 non-null  object \n",
            " 22  BusinessParking             31190 non-null  object \n",
            " 23  Ambience                    29547 non-null  object \n",
            " 24  RestaurantsPriceRange2      30051 non-null  float64\n",
            " 25  GoodForKids                 28780 non-null  object \n",
            " 26  RestaurantsReservations     29965 non-null  object \n",
            " 27  RestaurantsGoodForGroups    29382 non-null  object \n",
            " 28  BikeParking                 23823 non-null  object \n",
            " 29  GoodForMeal                 20284 non-null  object \n",
            " 30  DogsAllowed                 8199 non-null   object \n",
            " 31  HappyHour                   10541 non-null  object \n",
            " 32  WheelchairAccessible        9479 non-null   object \n",
            " 33  RestaurantsTableService     14517 non-null  object \n",
            " 34  BusinessAcceptsBitcoin      4813 non-null   object \n",
            " 35  Music                       5018 non-null   object \n",
            " 36  GoodForDancing              3224 non-null   object \n",
            " 37  CoatCheck                   3717 non-null   object \n",
            " 38  BestNights                  4131 non-null   object \n",
            " 39  BYOB                        3220 non-null   object \n",
            " 40  ByAppointmentOnly           2265 non-null   object \n",
            " 41  DriveThru                   1825 non-null   object \n",
            " 42  Corkage                     2636 non-null   object \n",
            " 43  RestaurantsCounterService   11 non-null     object \n",
            " 44  Open24Hours                 14 non-null     object \n",
            " 45  AcceptsInsurance            4 non-null      object \n",
            " 46  DietaryRestrictions         13 non-null     object \n",
            " 47  AgesAllowed_21plus          35290 non-null  int64  \n",
            " 48  AgesAllowed_allages         35290 non-null  int64  \n",
            " 49  Alcohol_None                35290 non-null  int64  \n",
            " 50  Alcohol_beer_and_wine       35290 non-null  int64  \n",
            " 51  Alcohol_full_bar            35290 non-null  int64  \n",
            " 52  BYOBCorkage_no              35290 non-null  int64  \n",
            " 53  BYOBCorkage_yes_corkage     35290 non-null  int64  \n",
            " 54  BYOBCorkage_yes_free        35290 non-null  int64  \n",
            " 55  NoiseLevel_average          35290 non-null  int64  \n",
            " 56  NoiseLevel_loud             35290 non-null  int64  \n",
            " 57  NoiseLevel_quiet            35290 non-null  int64  \n",
            " 58  NoiseLevel_very_loud        35290 non-null  int64  \n",
            " 59  RestaurantsAttire_casual    35290 non-null  int64  \n",
            " 60  RestaurantsAttire_dressy    35290 non-null  int64  \n",
            " 61  RestaurantsAttire_formal    35290 non-null  int64  \n",
            " 62  Smoking_no                  35290 non-null  int64  \n",
            " 63  Smoking_outdoor             35290 non-null  int64  \n",
            " 64  Smoking_yes                 35290 non-null  int64  \n",
            " 65  WiFi_free                   35290 non-null  int64  \n",
            " 66  WiFi_no                     35290 non-null  int64  \n",
            " 67  WiFi_paid                   35290 non-null  int64  \n",
            "dtypes: float64(5), int64(24), object(39)\n",
            "memory usage: 18.3+ MB\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Have ten features which are across all the restaurants"
      ],
      "metadata": {
        "id": "slu0hSpnAEzu"
      },
      "id": "slu0hSpnAEzu",
      "execution_count": 6,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "#AcceptsInsurance\n",
        "#DietaryRestrictions\n",
        "#ByAppointmentOnly\n",
        "#BusinessAcceptsBitcoin\n",
        "#GoodForMeal\n",
        "#DogsAllowed\n",
        "#RestaurantsTableService\n",
        "#GoodForDancing\n",
        "#CoatCheck\n",
        "#BestNights\n",
        "#DriveThru\n",
        "#Open24Hours\n",
        "#BYOB\n",
        "#Corkage\n",
        "#RestaurantsCounterService\n"
      ],
      "metadata": {
        "id": "4x0eyjvwCaXh"
      },
      "id": "4x0eyjvwCaXh",
      "execution_count": 7,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_columns_deleted = df_b.drop(columns = ['AcceptsInsurance','DietaryRestrictions','ByAppointmentOnly','BusinessAcceptsBitcoin','GoodForMeal','DogsAllowed','RestaurantsTableService','GoodForDancing','CoatCheck','BestNights','DriveThru','Open24Hours','BYOB','Corkage','RestaurantsCounterService'])"
      ],
      "metadata": {
        "id": "ylYbHRw9Eget"
      },
      "id": "ylYbHRw9Eget",
      "execution_count": 8,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_columns_deleted.info()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Ix5_ymwQGn-S",
        "outputId": "45beaad8-a658-4d6a-819c-a59912324e20"
      },
      "id": "Ix5_ymwQGn-S",
      "execution_count": 9,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 35290 entries, 0 to 35289\n",
            "Data columns (total 53 columns):\n",
            " #   Column                      Non-Null Count  Dtype  \n",
            "---  ------                      --------------  -----  \n",
            " 0   Unnamed: 0                  35290 non-null  int64  \n",
            " 1   business_id                 35290 non-null  object \n",
            " 2   name                        35290 non-null  object \n",
            " 3   address                     35215 non-null  object \n",
            " 4   city                        35290 non-null  object \n",
            " 5   state                       35290 non-null  object \n",
            " 6   postal_code                 35289 non-null  float64\n",
            " 7   latitude                    35290 non-null  float64\n",
            " 8   longitude                   35290 non-null  float64\n",
            " 9   stars                       35290 non-null  float64\n",
            " 10  review_count                35290 non-null  int64  \n",
            " 11  is_open                     35290 non-null  int64  \n",
            " 12  attributes                  34914 non-null  object \n",
            " 13  categories                  35290 non-null  object \n",
            " 14  hours                       29785 non-null  object \n",
            " 15  market                      35290 non-null  object \n",
            " 16  Caters                      23397 non-null  object \n",
            " 17  RestaurantsDelivery         30318 non-null  object \n",
            " 18  RestaurantsTakeOut          32068 non-null  object \n",
            " 19  HasTV                       29680 non-null  object \n",
            " 20  BusinessAcceptsCreditCards  32136 non-null  object \n",
            " 21  OutdoorSeating              29439 non-null  object \n",
            " 22  BusinessParking             31190 non-null  object \n",
            " 23  Ambience                    29547 non-null  object \n",
            " 24  RestaurantsPriceRange2      30051 non-null  float64\n",
            " 25  GoodForKids                 28780 non-null  object \n",
            " 26  RestaurantsReservations     29965 non-null  object \n",
            " 27  RestaurantsGoodForGroups    29382 non-null  object \n",
            " 28  BikeParking                 23823 non-null  object \n",
            " 29  HappyHour                   10541 non-null  object \n",
            " 30  WheelchairAccessible        9479 non-null   object \n",
            " 31  Music                       5018 non-null   object \n",
            " 32  AgesAllowed_21plus          35290 non-null  int64  \n",
            " 33  AgesAllowed_allages         35290 non-null  int64  \n",
            " 34  Alcohol_None                35290 non-null  int64  \n",
            " 35  Alcohol_beer_and_wine       35290 non-null  int64  \n",
            " 36  Alcohol_full_bar            35290 non-null  int64  \n",
            " 37  BYOBCorkage_no              35290 non-null  int64  \n",
            " 38  BYOBCorkage_yes_corkage     35290 non-null  int64  \n",
            " 39  BYOBCorkage_yes_free        35290 non-null  int64  \n",
            " 40  NoiseLevel_average          35290 non-null  int64  \n",
            " 41  NoiseLevel_loud             35290 non-null  int64  \n",
            " 42  NoiseLevel_quiet            35290 non-null  int64  \n",
            " 43  NoiseLevel_very_loud        35290 non-null  int64  \n",
            " 44  RestaurantsAttire_casual    35290 non-null  int64  \n",
            " 45  RestaurantsAttire_dressy    35290 non-null  int64  \n",
            " 46  RestaurantsAttire_formal    35290 non-null  int64  \n",
            " 47  Smoking_no                  35290 non-null  int64  \n",
            " 48  Smoking_outdoor             35290 non-null  int64  \n",
            " 49  Smoking_yes                 35290 non-null  int64  \n",
            " 50  WiFi_free                   35290 non-null  int64  \n",
            " 51  WiFi_no                     35290 non-null  int64  \n",
            " 52  WiFi_paid                   35290 non-null  int64  \n",
            "dtypes: float64(5), int64(24), object(24)\n",
            "memory usage: 14.3+ MB\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Two-dimensional count for NaN values in the entire dataframe\n",
        "df_columns_deleted.isnull().sum().sum()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "P0Cyir86HTNJ",
        "outputId": "e0e67fef-9e66-4518-f51e-6b127059ff51"
      },
      "id": "P0Cyir86HTNJ",
      "execution_count": 10,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "165783"
            ]
          },
          "metadata": {},
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#drop rows which contain more than 5 NaN values\n",
        "df_droppedNaN = df_columns_deleted[df_columns_deleted.isnull().sum(axis=1) < 10]\n"
      ],
      "metadata": {
        "id": "Ii2La3kyJa1M"
      },
      "id": "Ii2La3kyJa1M",
      "execution_count": 11,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "perc = 7.0\n",
        "min_count =  int(((100-perc)/100)*df_droppedNaN.shape[0] + 1)\n",
        "mod_df = df_droppedNaN.dropna( axis=1, \n",
        "                thresh=min_count)\n",
        "print(\"Modified Dataframe : \")\n",
        "print(mod_df)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "KeFJCw8q7uwl",
        "outputId": "bed85b45-3012-4dc9-ece3-746cf47ca61e"
      },
      "id": "KeFJCw8q7uwl",
      "execution_count": 12,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Modified Dataframe : \n",
            "       Unnamed: 0             business_id                           name  \\\n",
            "0               8  k0hlBqXX-Bt0vf1op7Jr1w          Tsevi's Pub And Grill   \n",
            "1              12  il_Ro8jwPlHresjw9EGmBg                        Denny's   \n",
            "2              15  MUTTqe8uqyMdBl186RmNeA                       Tuna Bar   \n",
            "3              19  ROeacJQwBeh05Rqg7F6TCg                            BAP   \n",
            "5              23  9OG5YkX1g2GReZM0AskizA        Romano's Macaroni Grill   \n",
            "...           ...                     ...                            ...   \n",
            "35285      150298  gPr1io7ks0Eo3FDsnDTYfg                      Tata Cafe   \n",
            "35286      150306  wVxXRFf10zTTAs11nr4xeA                   PrimoHoagies   \n",
            "35287      150322  2MAQeAqmD8enCT2ZYqUgIQ    The Melting Pot - Nashville   \n",
            "35288      150323  w_4xUt-1AyY2ZwKtnjW0Xg           Bittercreek Alehouse   \n",
            "35289      150336  WnT9NIzQgLlILjPT0kEcsQ  Adelita Taqueria & Restaurant   \n",
            "\n",
            "                    address          city state  postal_code   latitude  \\\n",
            "0         8025 Mackenzie Rd        Affton    MO      63123.0  38.565165   \n",
            "1              8901 US 31 S  Indianapolis    IN      46227.0  39.637133   \n",
            "2               205 Race St  Philadelphia    PA      19106.0  39.953949   \n",
            "3             1224 South St  Philadelphia    PA      19147.0  39.943223   \n",
            "5        5505 S Virginia St          Reno    NV      89502.0  39.476117   \n",
            "...                     ...           ...   ...          ...        ...   \n",
            "35285   7201 Germantown Ave  Philadelphia    PA      19119.0  40.060414   \n",
            "35286        6024 Ridge Ave  Philadelphia    PA      19128.0  40.032483   \n",
            "35287  166 2nd Ave N, Ste A     Nashville    TN      37201.0  36.163875   \n",
            "35288          246 N 8th St         Boise    ID      83702.0  43.616590   \n",
            "35289         1108 S 9th St  Philadelphia    PA      19147.0  39.935982   \n",
            "\n",
            "        longitude  stars  ...  NoiseLevel_very_loud  RestaurantsAttire_casual  \\\n",
            "0      -90.321087    3.0  ...                     0                         1   \n",
            "1      -86.127217    2.5  ...                     0                         1   \n",
            "2      -75.143226    4.0  ...                     0                         1   \n",
            "3      -75.162568    4.5  ...                     0                         1   \n",
            "5     -119.789339    2.5  ...                     0                         1   \n",
            "...           ...    ...  ...                   ...                       ...   \n",
            "35285  -75.191084    4.0  ...                     0                         1   \n",
            "35286  -75.214430    3.0  ...                     0                         1   \n",
            "35287  -86.776311    4.0  ...                     0                         0   \n",
            "35288 -116.202383    4.5  ...                     0                         1   \n",
            "35289  -75.158665    4.5  ...                     0                         1   \n",
            "\n",
            "      RestaurantsAttire_dressy RestaurantsAttire_formal Smoking_no  \\\n",
            "0                            0                        0          0   \n",
            "1                            0                        0          0   \n",
            "2                            0                        0          0   \n",
            "3                            0                        0          0   \n",
            "5                            0                        0          0   \n",
            "...                        ...                      ...        ...   \n",
            "35285                        0                        0          0   \n",
            "35286                        0                        0          0   \n",
            "35287                        1                        0          0   \n",
            "35288                        0                        0          0   \n",
            "35289                        0                        0          0   \n",
            "\n",
            "      Smoking_outdoor Smoking_yes WiFi_free WiFi_no  WiFi_paid  \n",
            "0                   0           0         1       0          0  \n",
            "1                   0           0         0       1          0  \n",
            "2                   0           0         1       0          0  \n",
            "3                   0           0         0       1          0  \n",
            "5                   0           0         1       0          0  \n",
            "...               ...         ...       ...     ...        ...  \n",
            "35285               0           0         1       0          0  \n",
            "35286               0           0         0       1          0  \n",
            "35287               0           0         1       0          0  \n",
            "35288               0           0         1       0          0  \n",
            "35289               0           0         1       0          0  \n",
            "\n",
            "[30930 rows x 42 columns]\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "mod_df.isnull().sum().sum()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "grfydpN4Ja8_",
        "outputId": "afd30d13-6aeb-4fd1-bef4-af189adae641"
      },
      "id": "grfydpN4Ja8_",
      "execution_count": 13,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "8778"
            ]
          },
          "metadata": {},
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "mod_df.fillna(0)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 731
        },
        "id": "vUcm9Af2KpxV",
        "outputId": "85607153-37bc-4000-d399-16ce56efdab3"
      },
      "id": "vUcm9Af2KpxV",
      "execution_count": 14,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "       Unnamed: 0             business_id                           name  \\\n",
              "0               8  k0hlBqXX-Bt0vf1op7Jr1w          Tsevi's Pub And Grill   \n",
              "1              12  il_Ro8jwPlHresjw9EGmBg                        Denny's   \n",
              "2              15  MUTTqe8uqyMdBl186RmNeA                       Tuna Bar   \n",
              "3              19  ROeacJQwBeh05Rqg7F6TCg                            BAP   \n",
              "5              23  9OG5YkX1g2GReZM0AskizA        Romano's Macaroni Grill   \n",
              "...           ...                     ...                            ...   \n",
              "35285      150298  gPr1io7ks0Eo3FDsnDTYfg                      Tata Cafe   \n",
              "35286      150306  wVxXRFf10zTTAs11nr4xeA                   PrimoHoagies   \n",
              "35287      150322  2MAQeAqmD8enCT2ZYqUgIQ    The Melting Pot - Nashville   \n",
              "35288      150323  w_4xUt-1AyY2ZwKtnjW0Xg           Bittercreek Alehouse   \n",
              "35289      150336  WnT9NIzQgLlILjPT0kEcsQ  Adelita Taqueria & Restaurant   \n",
              "\n",
              "                    address          city state  postal_code   latitude  \\\n",
              "0         8025 Mackenzie Rd        Affton    MO      63123.0  38.565165   \n",
              "1              8901 US 31 S  Indianapolis    IN      46227.0  39.637133   \n",
              "2               205 Race St  Philadelphia    PA      19106.0  39.953949   \n",
              "3             1224 South St  Philadelphia    PA      19147.0  39.943223   \n",
              "5        5505 S Virginia St          Reno    NV      89502.0  39.476117   \n",
              "...                     ...           ...   ...          ...        ...   \n",
              "35285   7201 Germantown Ave  Philadelphia    PA      19119.0  40.060414   \n",
              "35286        6024 Ridge Ave  Philadelphia    PA      19128.0  40.032483   \n",
              "35287  166 2nd Ave N, Ste A     Nashville    TN      37201.0  36.163875   \n",
              "35288          246 N 8th St         Boise    ID      83702.0  43.616590   \n",
              "35289         1108 S 9th St  Philadelphia    PA      19147.0  39.935982   \n",
              "\n",
              "        longitude  stars  ...  NoiseLevel_very_loud  RestaurantsAttire_casual  \\\n",
              "0      -90.321087    3.0  ...                     0                         1   \n",
              "1      -86.127217    2.5  ...                     0                         1   \n",
              "2      -75.143226    4.0  ...                     0                         1   \n",
              "3      -75.162568    4.5  ...                     0                         1   \n",
              "5     -119.789339    2.5  ...                     0                         1   \n",
              "...           ...    ...  ...                   ...                       ...   \n",
              "35285  -75.191084    4.0  ...                     0                         1   \n",
              "35286  -75.214430    3.0  ...                     0                         1   \n",
              "35287  -86.776311    4.0  ...                     0                         0   \n",
              "35288 -116.202383    4.5  ...                     0                         1   \n",
              "35289  -75.158665    4.5  ...                     0                         1   \n",
              "\n",
              "      RestaurantsAttire_dressy RestaurantsAttire_formal Smoking_no  \\\n",
              "0                            0                        0          0   \n",
              "1                            0                        0          0   \n",
              "2                            0                        0          0   \n",
              "3                            0                        0          0   \n",
              "5                            0                        0          0   \n",
              "...                        ...                      ...        ...   \n",
              "35285                        0                        0          0   \n",
              "35286                        0                        0          0   \n",
              "35287                        1                        0          0   \n",
              "35288                        0                        0          0   \n",
              "35289                        0                        0          0   \n",
              "\n",
              "      Smoking_outdoor Smoking_yes WiFi_free WiFi_no  WiFi_paid  \n",
              "0                   0           0         1       0          0  \n",
              "1                   0           0         0       1          0  \n",
              "2                   0           0         1       0          0  \n",
              "3                   0           0         0       1          0  \n",
              "5                   0           0         1       0          0  \n",
              "...               ...         ...       ...     ...        ...  \n",
              "35285               0           0         1       0          0  \n",
              "35286               0           0         0       1          0  \n",
              "35287               0           0         1       0          0  \n",
              "35288               0           0         1       0          0  \n",
              "35289               0           0         1       0          0  \n",
              "\n",
              "[30930 rows x 42 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-a60e42a6-cf69-40d7-9f81-0340b289b3a7\">\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>Unnamed: 0</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>...</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>0</th>\n",
              "      <td>8</td>\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.0</td>\n",
              "      <td>38.565165</td>\n",
              "      <td>-90.321087</td>\n",
              "      <td>3.0</td>\n",
              "      <td>...</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>1</th>\n",
              "      <td>12</td>\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.0</td>\n",
              "      <td>39.637133</td>\n",
              "      <td>-86.127217</td>\n",
              "      <td>2.5</td>\n",
              "      <td>...</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>2</th>\n",
              "      <td>15</td>\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.0</td>\n",
              "      <td>39.953949</td>\n",
              "      <td>-75.143226</td>\n",
              "      <td>4.0</td>\n",
              "      <td>...</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>3</th>\n",
              "      <td>19</td>\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.0</td>\n",
              "      <td>39.943223</td>\n",
              "      <td>-75.162568</td>\n",
              "      <td>4.5</td>\n",
              "      <td>...</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>5</th>\n",
              "      <td>23</td>\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.0</td>\n",
              "      <td>39.476117</td>\n",
              "      <td>-119.789339</td>\n",
              "      <td>2.5</td>\n",
              "      <td>...</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>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35285</th>\n",
              "      <td>150298</td>\n",
              "      <td>gPr1io7ks0Eo3FDsnDTYfg</td>\n",
              "      <td>Tata Cafe</td>\n",
              "      <td>7201 Germantown Ave</td>\n",
              "      <td>Philadelphia</td>\n",
              "      <td>PA</td>\n",
              "      <td>19119.0</td>\n",
              "      <td>40.060414</td>\n",
              "      <td>-75.191084</td>\n",
              "      <td>4.0</td>\n",
              "      <td>...</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>35286</th>\n",
              "      <td>150306</td>\n",
              "      <td>wVxXRFf10zTTAs11nr4xeA</td>\n",
              "      <td>PrimoHoagies</td>\n",
              "      <td>6024 Ridge Ave</td>\n",
              "      <td>Philadelphia</td>\n",
              "      <td>PA</td>\n",
              "      <td>19128.0</td>\n",
              "      <td>40.032483</td>\n",
              "      <td>-75.214430</td>\n",
              "      <td>3.0</td>\n",
              "      <td>...</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>35287</th>\n",
              "      <td>150322</td>\n",
              "      <td>2MAQeAqmD8enCT2ZYqUgIQ</td>\n",
              "      <td>The Melting Pot - Nashville</td>\n",
              "      <td>166 2nd Ave N, Ste A</td>\n",
              "      <td>Nashville</td>\n",
              "      <td>TN</td>\n",
              "      <td>37201.0</td>\n",
              "      <td>36.163875</td>\n",
              "      <td>-86.776311</td>\n",
              "      <td>4.0</td>\n",
              "      <td>...</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>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35288</th>\n",
              "      <td>150323</td>\n",
              "      <td>w_4xUt-1AyY2ZwKtnjW0Xg</td>\n",
              "      <td>Bittercreek Alehouse</td>\n",
              "      <td>246 N 8th St</td>\n",
              "      <td>Boise</td>\n",
              "      <td>ID</td>\n",
              "      <td>83702.0</td>\n",
              "      <td>43.616590</td>\n",
              "      <td>-116.202383</td>\n",
              "      <td>4.5</td>\n",
              "      <td>...</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>35289</th>\n",
              "      <td>150336</td>\n",
              "      <td>WnT9NIzQgLlILjPT0kEcsQ</td>\n",
              "      <td>Adelita Taqueria &amp; Restaurant</td>\n",
              "      <td>1108 S 9th St</td>\n",
              "      <td>Philadelphia</td>\n",
              "      <td>PA</td>\n",
              "      <td>19147.0</td>\n",
              "      <td>39.935982</td>\n",
              "      <td>-75.158665</td>\n",
              "      <td>4.5</td>\n",
              "      <td>...</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",
              "  </tbody>\n",
              "</table>\n",
              "<p>30930 rows × 42 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-a60e42a6-cf69-40d7-9f81-0340b289b3a7')\"\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-a60e42a6-cf69-40d7-9f81-0340b289b3a7 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-a60e42a6-cf69-40d7-9f81-0340b289b3a7');\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": 14
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "mod_df.replace({False: 0, True: 1}, inplace=True)\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "hiIuoms0g9iv",
        "outputId": "6cb58ed4-fc67-4594-c5ec-07eb420643fb"
      },
      "id": "hiIuoms0g9iv",
      "execution_count": 15,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "/usr/local/lib/python3.7/dist-packages/pandas/core/frame.py:5244: SettingWithCopyWarning: \n",
            "A value is trying to be set on a copy of a slice from a DataFrame\n",
            "\n",
            "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
            "  method=method,\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "mod_df"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 731
        },
        "id": "rF5vHLYdhPYZ",
        "outputId": "36ae01c6-f293-4349-eedb-44114ed415de"
      },
      "id": "rF5vHLYdhPYZ",
      "execution_count": 16,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "       Unnamed: 0             business_id                           name  \\\n",
              "0               8  k0hlBqXX-Bt0vf1op7Jr1w          Tsevi's Pub And Grill   \n",
              "1              12  il_Ro8jwPlHresjw9EGmBg                        Denny's   \n",
              "2              15  MUTTqe8uqyMdBl186RmNeA                       Tuna Bar   \n",
              "3              19  ROeacJQwBeh05Rqg7F6TCg                            BAP   \n",
              "5              23  9OG5YkX1g2GReZM0AskizA        Romano's Macaroni Grill   \n",
              "...           ...                     ...                            ...   \n",
              "35285      150298  gPr1io7ks0Eo3FDsnDTYfg                      Tata Cafe   \n",
              "35286      150306  wVxXRFf10zTTAs11nr4xeA                   PrimoHoagies   \n",
              "35287      150322  2MAQeAqmD8enCT2ZYqUgIQ    The Melting Pot - Nashville   \n",
              "35288      150323  w_4xUt-1AyY2ZwKtnjW0Xg           Bittercreek Alehouse   \n",
              "35289      150336  WnT9NIzQgLlILjPT0kEcsQ  Adelita Taqueria & Restaurant   \n",
              "\n",
              "                    address          city state  postal_code   latitude  \\\n",
              "0         8025 Mackenzie Rd        Affton    MO      63123.0  38.565165   \n",
              "1              8901 US 31 S  Indianapolis    IN      46227.0  39.637133   \n",
              "2               205 Race St  Philadelphia    PA      19106.0  39.953949   \n",
              "3             1224 South St  Philadelphia    PA      19147.0  39.943223   \n",
              "5        5505 S Virginia St          Reno    NV      89502.0  39.476117   \n",
              "...                     ...           ...   ...          ...        ...   \n",
              "35285   7201 Germantown Ave  Philadelphia    PA      19119.0  40.060414   \n",
              "35286        6024 Ridge Ave  Philadelphia    PA      19128.0  40.032483   \n",
              "35287  166 2nd Ave N, Ste A     Nashville    TN      37201.0  36.163875   \n",
              "35288          246 N 8th St         Boise    ID      83702.0  43.616590   \n",
              "35289         1108 S 9th St  Philadelphia    PA      19147.0  39.935982   \n",
              "\n",
              "        longitude  stars  ...  NoiseLevel_very_loud  RestaurantsAttire_casual  \\\n",
              "0      -90.321087    3.0  ...                     0                         1   \n",
              "1      -86.127217    2.5  ...                     0                         1   \n",
              "2      -75.143226    4.0  ...                     0                         1   \n",
              "3      -75.162568    4.5  ...                     0                         1   \n",
              "5     -119.789339    2.5  ...                     0                         1   \n",
              "...           ...    ...  ...                   ...                       ...   \n",
              "35285  -75.191084    4.0  ...                     0                         1   \n",
              "35286  -75.214430    3.0  ...                     0                         1   \n",
              "35287  -86.776311    4.0  ...                     0                         0   \n",
              "35288 -116.202383    4.5  ...                     0                         1   \n",
              "35289  -75.158665    4.5  ...                     0                         1   \n",
              "\n",
              "      RestaurantsAttire_dressy RestaurantsAttire_formal Smoking_no  \\\n",
              "0                            0                        0          0   \n",
              "1                            0                        0          0   \n",
              "2                            0                        0          0   \n",
              "3                            0                        0          0   \n",
              "5                            0                        0          0   \n",
              "...                        ...                      ...        ...   \n",
              "35285                        0                        0          0   \n",
              "35286                        0                        0          0   \n",
              "35287                        1                        0          0   \n",
              "35288                        0                        0          0   \n",
              "35289                        0                        0          0   \n",
              "\n",
              "       Smoking_outdoor  Smoking_yes  WiFi_free WiFi_no  WiFi_paid  \n",
              "0                    0            0          1       0          0  \n",
              "1                    0            0          0       1          0  \n",
              "2                    0            0          1       0          0  \n",
              "3                    0            0          0       1          0  \n",
              "5                    0            0          1       0          0  \n",
              "...                ...          ...        ...     ...        ...  \n",
              "35285                0            0          1       0          0  \n",
              "35286                0            0          0       1          0  \n",
              "35287                0            0          1       0          0  \n",
              "35288                0            0          1       0          0  \n",
              "35289                0            0          1       0          0  \n",
              "\n",
              "[30930 rows x 42 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-a9df6461-c3fc-4a98-9a3f-e7cc5483066e\">\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>Unnamed: 0</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>...</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>0</th>\n",
              "      <td>8</td>\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.0</td>\n",
              "      <td>38.565165</td>\n",
              "      <td>-90.321087</td>\n",
              "      <td>3.0</td>\n",
              "      <td>...</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>1</th>\n",
              "      <td>12</td>\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.0</td>\n",
              "      <td>39.637133</td>\n",
              "      <td>-86.127217</td>\n",
              "      <td>2.5</td>\n",
              "      <td>...</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>2</th>\n",
              "      <td>15</td>\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.0</td>\n",
              "      <td>39.953949</td>\n",
              "      <td>-75.143226</td>\n",
              "      <td>4.0</td>\n",
              "      <td>...</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>3</th>\n",
              "      <td>19</td>\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.0</td>\n",
              "      <td>39.943223</td>\n",
              "      <td>-75.162568</td>\n",
              "      <td>4.5</td>\n",
              "      <td>...</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>5</th>\n",
              "      <td>23</td>\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.0</td>\n",
              "      <td>39.476117</td>\n",
              "      <td>-119.789339</td>\n",
              "      <td>2.5</td>\n",
              "      <td>...</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>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35285</th>\n",
              "      <td>150298</td>\n",
              "      <td>gPr1io7ks0Eo3FDsnDTYfg</td>\n",
              "      <td>Tata Cafe</td>\n",
              "      <td>7201 Germantown Ave</td>\n",
              "      <td>Philadelphia</td>\n",
              "      <td>PA</td>\n",
              "      <td>19119.0</td>\n",
              "      <td>40.060414</td>\n",
              "      <td>-75.191084</td>\n",
              "      <td>4.0</td>\n",
              "      <td>...</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>35286</th>\n",
              "      <td>150306</td>\n",
              "      <td>wVxXRFf10zTTAs11nr4xeA</td>\n",
              "      <td>PrimoHoagies</td>\n",
              "      <td>6024 Ridge Ave</td>\n",
              "      <td>Philadelphia</td>\n",
              "      <td>PA</td>\n",
              "      <td>19128.0</td>\n",
              "      <td>40.032483</td>\n",
              "      <td>-75.214430</td>\n",
              "      <td>3.0</td>\n",
              "      <td>...</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>35287</th>\n",
              "      <td>150322</td>\n",
              "      <td>2MAQeAqmD8enCT2ZYqUgIQ</td>\n",
              "      <td>The Melting Pot - Nashville</td>\n",
              "      <td>166 2nd Ave N, Ste A</td>\n",
              "      <td>Nashville</td>\n",
              "      <td>TN</td>\n",
              "      <td>37201.0</td>\n",
              "      <td>36.163875</td>\n",
              "      <td>-86.776311</td>\n",
              "      <td>4.0</td>\n",
              "      <td>...</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>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35288</th>\n",
              "      <td>150323</td>\n",
              "      <td>w_4xUt-1AyY2ZwKtnjW0Xg</td>\n",
              "      <td>Bittercreek Alehouse</td>\n",
              "      <td>246 N 8th St</td>\n",
              "      <td>Boise</td>\n",
              "      <td>ID</td>\n",
              "      <td>83702.0</td>\n",
              "      <td>43.616590</td>\n",
              "      <td>-116.202383</td>\n",
              "      <td>4.5</td>\n",
              "      <td>...</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>35289</th>\n",
              "      <td>150336</td>\n",
              "      <td>WnT9NIzQgLlILjPT0kEcsQ</td>\n",
              "      <td>Adelita Taqueria &amp; Restaurant</td>\n",
              "      <td>1108 S 9th St</td>\n",
              "      <td>Philadelphia</td>\n",
              "      <td>PA</td>\n",
              "      <td>19147.0</td>\n",
              "      <td>39.935982</td>\n",
              "      <td>-75.158665</td>\n",
              "      <td>4.5</td>\n",
              "      <td>...</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",
              "  </tbody>\n",
              "</table>\n",
              "<p>30930 rows × 42 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-a9df6461-c3fc-4a98-9a3f-e7cc5483066e')\"\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-a9df6461-c3fc-4a98-9a3f-e7cc5483066e 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-a9df6461-c3fc-4a98-9a3f-e7cc5483066e');\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": 16
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "mod_df.to_csv('/content/gdrive/MyDrive/yelp_dataset/yelp_business_clean_version4.csv')"
      ],
      "metadata": {
        "id": "3Ed_NOUFhfAM"
      },
      "id": "3Ed_NOUFhfAM",
      "execution_count": 17,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "#Regression model\n",
        "#Y = b1x1 + b2x2...+"
      ],
      "metadata": {
        "id": "CAuJqsClJIx1"
      },
      "id": "CAuJqsClJIx1",
      "execution_count": 18,
      "outputs": []
    }
  ],
  "metadata": {
    "kernelspec": {
      "display_name": "Python 3 (ipykernel)",
      "language": "python",
      "name": "python3"
    },
    "language_info": {
      "codemirror_mode": {
        "name": "ipython",
        "version": 3
      },
      "file_extension": ".py",
      "mimetype": "text/x-python",
      "name": "python",
      "nbconvert_exporter": "python",
      "pygments_lexer": "ipython3",
      "version": "3.9.7"
    },
    "colab": {
      "provenance": [],
      "machine_shape": "hm",
      "include_colab_link": true
    },
    "gpuClass": "premium"
  },
  "nbformat": 4,
  "nbformat_minor": 5
}