res_recom.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Yelp Data Challenge - Restaurant Recommender\n",
    "\n",
    "Lei Chen\n",
    "\n",
    "Nov 2018"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "%matplotlib inline\n",
    "plt.style.use(\"ggplot\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_concat = pd.read_csv('../data/df_utility.csv', encoding='ISO-8859-1')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "bus_id = list(set(df_concat.business_id.values))\n",
    "bus_dic = {}\n",
    "i = 0\n",
    "for bus in bus_id:\n",
    "    bus_dic[bus] = i\n",
    "    i += 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_review = pd.read_csv('../data/last_2_years_restaurant_reviews.csv', encoding='ISO-8859-1' )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>business_id</th>\n",
       "      <th>cool</th>\n",
       "      <th>date</th>\n",
       "      <th>funny</th>\n",
       "      <th>review_id</th>\n",
       "      <th>stars</th>\n",
       "      <th>text</th>\n",
       "      <th>useful</th>\n",
       "      <th>user_id</th>\n",
       "      <th>address</th>\n",
       "      <th>...</th>\n",
       "      <th>hours</th>\n",
       "      <th>is_open</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>name</th>\n",
       "      <th>neighborhood</th>\n",
       "      <th>postal_code</th>\n",
       "      <th>review_count</th>\n",
       "      <th>avg_stars</th>\n",
       "      <th>state</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>--9e1ONYQuAa-CB_Rrw7Tw</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-02-14</td>\n",
       "      <td>0</td>\n",
       "      <td>VETXTwMw6qxzOVDlXfe6Tg</td>\n",
       "      <td>5</td>\n",
       "      <td>went for dinner tonight. Amazing my husband ha...</td>\n",
       "      <td>0</td>\n",
       "      <td>ymlnR8UeFvB4FZL56tCZsA</td>\n",
       "      <td>3355 Las Vegas Blvd S</td>\n",
       "      <td>...</td>\n",
       "      <td>{'Monday': '11:30-14:0', 'Tuesday': '11:30-14:...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>36.123183</td>\n",
       "      <td>-115.16919</td>\n",
       "      <td>Delmonico Steakhouse</td>\n",
       "      <td>The Strip</td>\n",
       "      <td>89109.0</td>\n",
       "      <td>1546.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>--9e1ONYQuAa-CB_Rrw7Tw</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-12-04</td>\n",
       "      <td>0</td>\n",
       "      <td>S8-8uZ7fa5YbjnEtaW15ng</td>\n",
       "      <td>5</td>\n",
       "      <td>This was an amazing dinning experience! ORDER ...</td>\n",
       "      <td>0</td>\n",
       "      <td>9pSSL6X6lFpY3FCRLEH3og</td>\n",
       "      <td>3355 Las Vegas Blvd S</td>\n",
       "      <td>...</td>\n",
       "      <td>{'Monday': '11:30-14:0', 'Tuesday': '11:30-14:...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>36.123183</td>\n",
       "      <td>-115.16919</td>\n",
       "      <td>Delmonico Steakhouse</td>\n",
       "      <td>The Strip</td>\n",
       "      <td>89109.0</td>\n",
       "      <td>1546.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>--9e1ONYQuAa-CB_Rrw7Tw</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-08-22</td>\n",
       "      <td>1</td>\n",
       "      <td>1nK5w0VNfDlnR3bOz13dJQ</td>\n",
       "      <td>5</td>\n",
       "      <td>My husband and I went there for lunch on a Sat...</td>\n",
       "      <td>1</td>\n",
       "      <td>gm8nNoA3uB4In5o_Hxpq3g</td>\n",
       "      <td>3355 Las Vegas Blvd S</td>\n",
       "      <td>...</td>\n",
       "      <td>{'Monday': '11:30-14:0', 'Tuesday': '11:30-14:...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>36.123183</td>\n",
       "      <td>-115.16919</td>\n",
       "      <td>Delmonico Steakhouse</td>\n",
       "      <td>The Strip</td>\n",
       "      <td>89109.0</td>\n",
       "      <td>1546.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>--9e1ONYQuAa-CB_Rrw7Tw</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-09-13</td>\n",
       "      <td>0</td>\n",
       "      <td>N1Z93BthdJ7FT2p5S22jIA</td>\n",
       "      <td>3</td>\n",
       "      <td>Went for a nice anniversary dinner. Researched...</td>\n",
       "      <td>0</td>\n",
       "      <td>CEtidlXNyQzgJSdF1ubPFw</td>\n",
       "      <td>3355 Las Vegas Blvd S</td>\n",
       "      <td>...</td>\n",
       "      <td>{'Monday': '11:30-14:0', 'Tuesday': '11:30-14:...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>36.123183</td>\n",
       "      <td>-115.16919</td>\n",
       "      <td>Delmonico Steakhouse</td>\n",
       "      <td>The Strip</td>\n",
       "      <td>89109.0</td>\n",
       "      <td>1546.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>--9e1ONYQuAa-CB_Rrw7Tw</td>\n",
       "      <td>0</td>\n",
       "      <td>2015-02-02</td>\n",
       "      <td>0</td>\n",
       "      <td>_Uwp6FO1X-avE9wqTMC59w</td>\n",
       "      <td>5</td>\n",
       "      <td>This place is first class in every way. Lobste...</td>\n",
       "      <td>0</td>\n",
       "      <td>-Z7Nw2UF7NiBSAzfXNA_XA</td>\n",
       "      <td>3355 Las Vegas Blvd S</td>\n",
       "      <td>...</td>\n",
       "      <td>{'Monday': '11:30-14:0', 'Tuesday': '11:30-14:...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>36.123183</td>\n",
       "      <td>-115.16919</td>\n",
       "      <td>Delmonico Steakhouse</td>\n",
       "      <td>The Strip</td>\n",
       "      <td>89109.0</td>\n",
       "      <td>1546.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NV</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              business_id  cool        date  funny               review_id  \\\n",
       "0  --9e1ONYQuAa-CB_Rrw7Tw     0  2017-02-14      0  VETXTwMw6qxzOVDlXfe6Tg   \n",
       "1  --9e1ONYQuAa-CB_Rrw7Tw     0  2017-12-04      0  S8-8uZ7fa5YbjnEtaW15ng   \n",
       "2  --9e1ONYQuAa-CB_Rrw7Tw     0  2016-08-22      1  1nK5w0VNfDlnR3bOz13dJQ   \n",
       "3  --9e1ONYQuAa-CB_Rrw7Tw     0  2016-09-13      0  N1Z93BthdJ7FT2p5S22jIA   \n",
       "4  --9e1ONYQuAa-CB_Rrw7Tw     0  2015-02-02      0  _Uwp6FO1X-avE9wqTMC59w   \n",
       "\n",
       "   stars                                               text  useful  \\\n",
       "0      5  went for dinner tonight. Amazing my husband ha...       0   \n",
       "1      5  This was an amazing dinning experience! ORDER ...       0   \n",
       "2      5  My husband and I went there for lunch on a Sat...       1   \n",
       "3      3  Went for a nice anniversary dinner. Researched...       0   \n",
       "4      5  This place is first class in every way. Lobste...       0   \n",
       "\n",
       "                  user_id                address  ...  \\\n",
       "0  ymlnR8UeFvB4FZL56tCZsA  3355 Las Vegas Blvd S  ...   \n",
       "1  9pSSL6X6lFpY3FCRLEH3og  3355 Las Vegas Blvd S  ...   \n",
       "2  gm8nNoA3uB4In5o_Hxpq3g  3355 Las Vegas Blvd S  ...   \n",
       "3  CEtidlXNyQzgJSdF1ubPFw  3355 Las Vegas Blvd S  ...   \n",
       "4  -Z7Nw2UF7NiBSAzfXNA_XA  3355 Las Vegas Blvd S  ...   \n",
       "\n",
       "                                               hours is_open   latitude  \\\n",
       "0  {'Monday': '11:30-14:0', 'Tuesday': '11:30-14:...     1.0  36.123183   \n",
       "1  {'Monday': '11:30-14:0', 'Tuesday': '11:30-14:...     1.0  36.123183   \n",
       "2  {'Monday': '11:30-14:0', 'Tuesday': '11:30-14:...     1.0  36.123183   \n",
       "3  {'Monday': '11:30-14:0', 'Tuesday': '11:30-14:...     1.0  36.123183   \n",
       "4  {'Monday': '11:30-14:0', 'Tuesday': '11:30-14:...     1.0  36.123183   \n",
       "\n",
       "   longitude                  name  neighborhood  postal_code review_count  \\\n",
       "0 -115.16919  Delmonico Steakhouse     The Strip      89109.0       1546.0   \n",
       "1 -115.16919  Delmonico Steakhouse     The Strip      89109.0       1546.0   \n",
       "2 -115.16919  Delmonico Steakhouse     The Strip      89109.0       1546.0   \n",
       "3 -115.16919  Delmonico Steakhouse     The Strip      89109.0       1546.0   \n",
       "4 -115.16919  Delmonico Steakhouse     The Strip      89109.0       1546.0   \n",
       "\n",
       "  avg_stars  state  \n",
       "0       4.0     NV  \n",
       "1       4.0     NV  \n",
       "2       4.0     NV  \n",
       "3       4.0     NV  \n",
       "4       4.0     NV  \n",
       "\n",
       "[5 rows x 23 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_review.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Important metrics: df_res"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>address</th>\n",
       "      <th>attributes</th>\n",
       "      <th>business_id</th>\n",
       "      <th>categories</th>\n",
       "      <th>hours</th>\n",
       "      <th>is_open</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>name</th>\n",
       "      <th>neighborhood</th>\n",
       "      <th>postal_code</th>\n",
       "      <th>review_count</th>\n",
       "      <th>stars</th>\n",
       "      <th>cluster</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2255 N Rampart Blvd</td>\n",
       "      <td>{'Alcohol': 'none', 'Ambience': \"{'romantic': ...</td>\n",
       "      <td>kgffcoxT6BQp-gJ-UQ7Czw</td>\n",
       "      <td>Fast Food, Restaurants, Sandwiches</td>\n",
       "      <td>{'Monday': '9:0-21:0', 'Tuesday': '9:0-21:0', ...</td>\n",
       "      <td>1</td>\n",
       "      <td>36.201794</td>\n",
       "      <td>-115.281981</td>\n",
       "      <td>Subway</td>\n",
       "      <td>Summerlin</td>\n",
       "      <td>89128.0</td>\n",
       "      <td>13</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2227 N Rampart Blvd</td>\n",
       "      <td>{'Alcohol': 'beer_and_wine', 'Ambience': \"{'ro...</td>\n",
       "      <td>0jtRI7hVMpQHpUVtUy4ITw</td>\n",
       "      <td>Beer, Wine &amp; Spirits, Italian, Food, American ...</td>\n",
       "      <td>{'Monday': '7:0-14:30', 'Tuesday': '7:0-19:0',...</td>\n",
       "      <td>1</td>\n",
       "      <td>36.201990</td>\n",
       "      <td>-115.283122</td>\n",
       "      <td>Omelet House Summerlin</td>\n",
       "      <td>Summerlin</td>\n",
       "      <td>89128.0</td>\n",
       "      <td>242</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4505 E Bonanza Rd</td>\n",
       "      <td>{'Alcohol': 'none', 'Ambience': \"{'romantic': ...</td>\n",
       "      <td>zhxnD7J5_sCrKSw5cwI9dQ</td>\n",
       "      <td>Chicken Wings, Restaurants, Fast Food</td>\n",
       "      <td>{'Monday': '10:0-23:0', 'Tuesday': '10:0-23:0'...</td>\n",
       "      <td>1</td>\n",
       "      <td>36.173140</td>\n",
       "      <td>-115.077945</td>\n",
       "      <td>Popeyes Louisiana Kitchen</td>\n",
       "      <td>Sunrise</td>\n",
       "      <td>89110.0</td>\n",
       "      <td>16</td>\n",
       "      <td>1.5</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>560 N. Nellis Blvd, Ste E1</td>\n",
       "      <td>{'Alcohol': 'none', 'Ambience': \"{'romantic': ...</td>\n",
       "      <td>2kWrSFkIes_d2BMg4YrRtA</td>\n",
       "      <td>Restaurants, Pizza</td>\n",
       "      <td>{'Monday': '11:0-23:0', 'Tuesday': '11:0-23:0'...</td>\n",
       "      <td>1</td>\n",
       "      <td>36.169353</td>\n",
       "      <td>-115.061694</td>\n",
       "      <td>Pizza Hut</td>\n",
       "      <td>Sunrise</td>\n",
       "      <td>89110.0</td>\n",
       "      <td>19</td>\n",
       "      <td>2.5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3480 S Maryland Pkwy</td>\n",
       "      <td>{'BusinessAcceptsCreditCards': 'True', 'GoodFo...</td>\n",
       "      <td>6llKs7K_tn8ChXcIM-oTvg</td>\n",
       "      <td>Japanese, Restaurants</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>36.125934</td>\n",
       "      <td>-115.135253</td>\n",
       "      <td>Sansei Japan</td>\n",
       "      <td>Eastside</td>\n",
       "      <td>89169.0</td>\n",
       "      <td>3</td>\n",
       "      <td>4.5</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      address  \\\n",
       "0         2255 N Rampart Blvd   \n",
       "1         2227 N Rampart Blvd   \n",
       "2           4505 E Bonanza Rd   \n",
       "3  560 N. Nellis Blvd, Ste E1   \n",
       "4        3480 S Maryland Pkwy   \n",
       "\n",
       "                                          attributes             business_id  \\\n",
       "0  {'Alcohol': 'none', 'Ambience': \"{'romantic': ...  kgffcoxT6BQp-gJ-UQ7Czw   \n",
       "1  {'Alcohol': 'beer_and_wine', 'Ambience': \"{'ro...  0jtRI7hVMpQHpUVtUy4ITw   \n",
       "2  {'Alcohol': 'none', 'Ambience': \"{'romantic': ...  zhxnD7J5_sCrKSw5cwI9dQ   \n",
       "3  {'Alcohol': 'none', 'Ambience': \"{'romantic': ...  2kWrSFkIes_d2BMg4YrRtA   \n",
       "4  {'BusinessAcceptsCreditCards': 'True', 'GoodFo...  6llKs7K_tn8ChXcIM-oTvg   \n",
       "\n",
       "                                          categories  \\\n",
       "0                 Fast Food, Restaurants, Sandwiches   \n",
       "1  Beer, Wine & Spirits, Italian, Food, American ...   \n",
       "2              Chicken Wings, Restaurants, Fast Food   \n",
       "3                                 Restaurants, Pizza   \n",
       "4                              Japanese, Restaurants   \n",
       "\n",
       "                                               hours  is_open   latitude  \\\n",
       "0  {'Monday': '9:0-21:0', 'Tuesday': '9:0-21:0', ...        1  36.201794   \n",
       "1  {'Monday': '7:0-14:30', 'Tuesday': '7:0-19:0',...        1  36.201990   \n",
       "2  {'Monday': '10:0-23:0', 'Tuesday': '10:0-23:0'...        1  36.173140   \n",
       "3  {'Monday': '11:0-23:0', 'Tuesday': '11:0-23:0'...        1  36.169353   \n",
       "4                                                NaN        1  36.125934   \n",
       "\n",
       "    longitude                       name neighborhood  postal_code  \\\n",
       "0 -115.281981                     Subway    Summerlin      89128.0   \n",
       "1 -115.283122     Omelet House Summerlin    Summerlin      89128.0   \n",
       "2 -115.077945  Popeyes Louisiana Kitchen      Sunrise      89110.0   \n",
       "3 -115.061694                  Pizza Hut      Sunrise      89110.0   \n",
       "4 -115.135253               Sansei Japan     Eastside      89169.0   \n",
       "\n",
       "   review_count  stars  cluster  \n",
       "0            13    2.5        0  \n",
       "1           242    4.0        4  \n",
       "2            16    1.5        8  \n",
       "3            19    2.5        5  \n",
       "4             3    4.5        3  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_res = pd.read_csv('../data/df_res.csv')\n",
    "df_res.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_temp = df_res[['business_id', 'cluster']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>business_id</th>\n",
       "      <th>cluster</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>kgffcoxT6BQp-gJ-UQ7Czw</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0jtRI7hVMpQHpUVtUy4ITw</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>zhxnD7J5_sCrKSw5cwI9dQ</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2kWrSFkIes_d2BMg4YrRtA</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>6llKs7K_tn8ChXcIM-oTvg</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              business_id  cluster\n",
       "0  kgffcoxT6BQp-gJ-UQ7Czw        0\n",
       "1  0jtRI7hVMpQHpUVtUy4ITw        4\n",
       "2  zhxnD7J5_sCrKSw5cwI9dQ        8\n",
       "3  2kWrSFkIes_d2BMg4YrRtA        5\n",
       "4  6llKs7K_tn8ChXcIM-oTvg        3"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_temp.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_concat = pd.merge(df_review, df_temp, on='business_id')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>business_id</th>\n",
       "      <th>cool</th>\n",
       "      <th>date</th>\n",
       "      <th>funny</th>\n",
       "      <th>review_id</th>\n",
       "      <th>stars</th>\n",
       "      <th>text</th>\n",
       "      <th>useful</th>\n",
       "      <th>user_id</th>\n",
       "      <th>address</th>\n",
       "      <th>...</th>\n",
       "      <th>is_open</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>name</th>\n",
       "      <th>neighborhood</th>\n",
       "      <th>postal_code</th>\n",
       "      <th>review_count</th>\n",
       "      <th>avg_stars</th>\n",
       "      <th>state</th>\n",
       "      <th>cluster</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>--9e1ONYQuAa-CB_Rrw7Tw</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-02-14</td>\n",
       "      <td>0</td>\n",
       "      <td>VETXTwMw6qxzOVDlXfe6Tg</td>\n",
       "      <td>5</td>\n",
       "      <td>went for dinner tonight. Amazing my husband ha...</td>\n",
       "      <td>0</td>\n",
       "      <td>ymlnR8UeFvB4FZL56tCZsA</td>\n",
       "      <td>3355 Las Vegas Blvd S</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>36.123183</td>\n",
       "      <td>-115.16919</td>\n",
       "      <td>Delmonico Steakhouse</td>\n",
       "      <td>The Strip</td>\n",
       "      <td>89109.0</td>\n",
       "      <td>1546.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NV</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>--9e1ONYQuAa-CB_Rrw7Tw</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-12-04</td>\n",
       "      <td>0</td>\n",
       "      <td>S8-8uZ7fa5YbjnEtaW15ng</td>\n",
       "      <td>5</td>\n",
       "      <td>This was an amazing dinning experience! ORDER ...</td>\n",
       "      <td>0</td>\n",
       "      <td>9pSSL6X6lFpY3FCRLEH3og</td>\n",
       "      <td>3355 Las Vegas Blvd S</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>36.123183</td>\n",
       "      <td>-115.16919</td>\n",
       "      <td>Delmonico Steakhouse</td>\n",
       "      <td>The Strip</td>\n",
       "      <td>89109.0</td>\n",
       "      <td>1546.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NV</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>--9e1ONYQuAa-CB_Rrw7Tw</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-08-22</td>\n",
       "      <td>1</td>\n",
       "      <td>1nK5w0VNfDlnR3bOz13dJQ</td>\n",
       "      <td>5</td>\n",
       "      <td>My husband and I went there for lunch on a Sat...</td>\n",
       "      <td>1</td>\n",
       "      <td>gm8nNoA3uB4In5o_Hxpq3g</td>\n",
       "      <td>3355 Las Vegas Blvd S</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>36.123183</td>\n",
       "      <td>-115.16919</td>\n",
       "      <td>Delmonico Steakhouse</td>\n",
       "      <td>The Strip</td>\n",
       "      <td>89109.0</td>\n",
       "      <td>1546.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NV</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>--9e1ONYQuAa-CB_Rrw7Tw</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-09-13</td>\n",
       "      <td>0</td>\n",
       "      <td>N1Z93BthdJ7FT2p5S22jIA</td>\n",
       "      <td>3</td>\n",
       "      <td>Went for a nice anniversary dinner. Researched...</td>\n",
       "      <td>0</td>\n",
       "      <td>CEtidlXNyQzgJSdF1ubPFw</td>\n",
       "      <td>3355 Las Vegas Blvd S</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>36.123183</td>\n",
       "      <td>-115.16919</td>\n",
       "      <td>Delmonico Steakhouse</td>\n",
       "      <td>The Strip</td>\n",
       "      <td>89109.0</td>\n",
       "      <td>1546.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NV</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>--9e1ONYQuAa-CB_Rrw7Tw</td>\n",
       "      <td>0</td>\n",
       "      <td>2015-02-02</td>\n",
       "      <td>0</td>\n",
       "      <td>_Uwp6FO1X-avE9wqTMC59w</td>\n",
       "      <td>5</td>\n",
       "      <td>This place is first class in every way. Lobste...</td>\n",
       "      <td>0</td>\n",
       "      <td>-Z7Nw2UF7NiBSAzfXNA_XA</td>\n",
       "      <td>3355 Las Vegas Blvd S</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>36.123183</td>\n",
       "      <td>-115.16919</td>\n",
       "      <td>Delmonico Steakhouse</td>\n",
       "      <td>The Strip</td>\n",
       "      <td>89109.0</td>\n",
       "      <td>1546.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NV</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              business_id  cool        date  funny               review_id  \\\n",
       "0  --9e1ONYQuAa-CB_Rrw7Tw     0  2017-02-14      0  VETXTwMw6qxzOVDlXfe6Tg   \n",
       "1  --9e1ONYQuAa-CB_Rrw7Tw     0  2017-12-04      0  S8-8uZ7fa5YbjnEtaW15ng   \n",
       "2  --9e1ONYQuAa-CB_Rrw7Tw     0  2016-08-22      1  1nK5w0VNfDlnR3bOz13dJQ   \n",
       "3  --9e1ONYQuAa-CB_Rrw7Tw     0  2016-09-13      0  N1Z93BthdJ7FT2p5S22jIA   \n",
       "4  --9e1ONYQuAa-CB_Rrw7Tw     0  2015-02-02      0  _Uwp6FO1X-avE9wqTMC59w   \n",
       "\n",
       "   stars                                               text  useful  \\\n",
       "0      5  went for dinner tonight. Amazing my husband ha...       0   \n",
       "1      5  This was an amazing dinning experience! ORDER ...       0   \n",
       "2      5  My husband and I went there for lunch on a Sat...       1   \n",
       "3      3  Went for a nice anniversary dinner. Researched...       0   \n",
       "4      5  This place is first class in every way. Lobste...       0   \n",
       "\n",
       "                  user_id                address  ... is_open   latitude  \\\n",
       "0  ymlnR8UeFvB4FZL56tCZsA  3355 Las Vegas Blvd S  ...     1.0  36.123183   \n",
       "1  9pSSL6X6lFpY3FCRLEH3og  3355 Las Vegas Blvd S  ...     1.0  36.123183   \n",
       "2  gm8nNoA3uB4In5o_Hxpq3g  3355 Las Vegas Blvd S  ...     1.0  36.123183   \n",
       "3  CEtidlXNyQzgJSdF1ubPFw  3355 Las Vegas Blvd S  ...     1.0  36.123183   \n",
       "4  -Z7Nw2UF7NiBSAzfXNA_XA  3355 Las Vegas Blvd S  ...     1.0  36.123183   \n",
       "\n",
       "   longitude                  name  neighborhood  postal_code  review_count  \\\n",
       "0 -115.16919  Delmonico Steakhouse     The Strip      89109.0        1546.0   \n",
       "1 -115.16919  Delmonico Steakhouse     The Strip      89109.0        1546.0   \n",
       "2 -115.16919  Delmonico Steakhouse     The Strip      89109.0        1546.0   \n",
       "3 -115.16919  Delmonico Steakhouse     The Strip      89109.0        1546.0   \n",
       "4 -115.16919  Delmonico Steakhouse     The Strip      89109.0        1546.0   \n",
       "\n",
       "  avg_stars state  cluster  \n",
       "0       4.0    NV        1  \n",
       "1       4.0    NV        1  \n",
       "2       4.0    NV        1  \n",
       "3       4.0    NV        1  \n",
       "4       4.0    NV        1  \n",
       "\n",
       "[5 rows x 24 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_concat.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>business_id</th>\n",
       "      <th>cool</th>\n",
       "      <th>date</th>\n",
       "      <th>funny</th>\n",
       "      <th>review_id</th>\n",
       "      <th>stars</th>\n",
       "      <th>text</th>\n",
       "      <th>useful</th>\n",
       "      <th>address</th>\n",
       "      <th>attributes</th>\n",
       "      <th>...</th>\n",
       "      <th>is_open</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>name</th>\n",
       "      <th>neighborhood</th>\n",
       "      <th>postal_code</th>\n",
       "      <th>review_count</th>\n",
       "      <th>avg_stars</th>\n",
       "      <th>state</th>\n",
       "      <th>cluster</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>user_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>ymlnR8UeFvB4FZL56tCZsA</th>\n",
       "      <td>--9e1ONYQuAa-CB_Rrw7Tw</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-02-14</td>\n",
       "      <td>0</td>\n",
       "      <td>VETXTwMw6qxzOVDlXfe6Tg</td>\n",
       "      <td>5</td>\n",
       "      <td>went for dinner tonight. Amazing my husband ha...</td>\n",
       "      <td>0</td>\n",
       "      <td>3355 Las Vegas Blvd S</td>\n",
       "      <td>{'Alcohol': 'full_bar', 'Ambience': \"{'romanti...</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>36.123183</td>\n",
       "      <td>-115.16919</td>\n",
       "      <td>Delmonico Steakhouse</td>\n",
       "      <td>The Strip</td>\n",
       "      <td>89109.0</td>\n",
       "      <td>1546.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NV</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9pSSL6X6lFpY3FCRLEH3og</th>\n",
       "      <td>--9e1ONYQuAa-CB_Rrw7Tw</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-12-04</td>\n",
       "      <td>0</td>\n",
       "      <td>S8-8uZ7fa5YbjnEtaW15ng</td>\n",
       "      <td>5</td>\n",
       "      <td>This was an amazing dinning experience! ORDER ...</td>\n",
       "      <td>0</td>\n",
       "      <td>3355 Las Vegas Blvd S</td>\n",
       "      <td>{'Alcohol': 'full_bar', 'Ambience': \"{'romanti...</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>36.123183</td>\n",
       "      <td>-115.16919</td>\n",
       "      <td>Delmonico Steakhouse</td>\n",
       "      <td>The Strip</td>\n",
       "      <td>89109.0</td>\n",
       "      <td>1546.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NV</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>gm8nNoA3uB4In5o_Hxpq3g</th>\n",
       "      <td>--9e1ONYQuAa-CB_Rrw7Tw</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-08-22</td>\n",
       "      <td>1</td>\n",
       "      <td>1nK5w0VNfDlnR3bOz13dJQ</td>\n",
       "      <td>5</td>\n",
       "      <td>My husband and I went there for lunch on a Sat...</td>\n",
       "      <td>1</td>\n",
       "      <td>3355 Las Vegas Blvd S</td>\n",
       "      <td>{'Alcohol': 'full_bar', 'Ambience': \"{'romanti...</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>36.123183</td>\n",
       "      <td>-115.16919</td>\n",
       "      <td>Delmonico Steakhouse</td>\n",
       "      <td>The Strip</td>\n",
       "      <td>89109.0</td>\n",
       "      <td>1546.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NV</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CEtidlXNyQzgJSdF1ubPFw</th>\n",
       "      <td>--9e1ONYQuAa-CB_Rrw7Tw</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-09-13</td>\n",
       "      <td>0</td>\n",
       "      <td>N1Z93BthdJ7FT2p5S22jIA</td>\n",
       "      <td>3</td>\n",
       "      <td>Went for a nice anniversary dinner. Researched...</td>\n",
       "      <td>0</td>\n",
       "      <td>3355 Las Vegas Blvd S</td>\n",
       "      <td>{'Alcohol': 'full_bar', 'Ambience': \"{'romanti...</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>36.123183</td>\n",
       "      <td>-115.16919</td>\n",
       "      <td>Delmonico Steakhouse</td>\n",
       "      <td>The Strip</td>\n",
       "      <td>89109.0</td>\n",
       "      <td>1546.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NV</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-Z7Nw2UF7NiBSAzfXNA_XA</th>\n",
       "      <td>--9e1ONYQuAa-CB_Rrw7Tw</td>\n",
       "      <td>0</td>\n",
       "      <td>2015-02-02</td>\n",
       "      <td>0</td>\n",
       "      <td>_Uwp6FO1X-avE9wqTMC59w</td>\n",
       "      <td>5</td>\n",
       "      <td>This place is first class in every way. Lobste...</td>\n",
       "      <td>0</td>\n",
       "      <td>3355 Las Vegas Blvd S</td>\n",
       "      <td>{'Alcohol': 'full_bar', 'Ambience': \"{'romanti...</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>36.123183</td>\n",
       "      <td>-115.16919</td>\n",
       "      <td>Delmonico Steakhouse</td>\n",
       "      <td>The Strip</td>\n",
       "      <td>89109.0</td>\n",
       "      <td>1546.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NV</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   business_id  cool        date  funny  \\\n",
       "user_id                                                                   \n",
       "ymlnR8UeFvB4FZL56tCZsA  --9e1ONYQuAa-CB_Rrw7Tw     0  2017-02-14      0   \n",
       "9pSSL6X6lFpY3FCRLEH3og  --9e1ONYQuAa-CB_Rrw7Tw     0  2017-12-04      0   \n",
       "gm8nNoA3uB4In5o_Hxpq3g  --9e1ONYQuAa-CB_Rrw7Tw     0  2016-08-22      1   \n",
       "CEtidlXNyQzgJSdF1ubPFw  --9e1ONYQuAa-CB_Rrw7Tw     0  2016-09-13      0   \n",
       "-Z7Nw2UF7NiBSAzfXNA_XA  --9e1ONYQuAa-CB_Rrw7Tw     0  2015-02-02      0   \n",
       "\n",
       "                                     review_id  stars  \\\n",
       "user_id                                                 \n",
       "ymlnR8UeFvB4FZL56tCZsA  VETXTwMw6qxzOVDlXfe6Tg      5   \n",
       "9pSSL6X6lFpY3FCRLEH3og  S8-8uZ7fa5YbjnEtaW15ng      5   \n",
       "gm8nNoA3uB4In5o_Hxpq3g  1nK5w0VNfDlnR3bOz13dJQ      5   \n",
       "CEtidlXNyQzgJSdF1ubPFw  N1Z93BthdJ7FT2p5S22jIA      3   \n",
       "-Z7Nw2UF7NiBSAzfXNA_XA  _Uwp6FO1X-avE9wqTMC59w      5   \n",
       "\n",
       "                                                                     text  \\\n",
       "user_id                                                                     \n",
       "ymlnR8UeFvB4FZL56tCZsA  went for dinner tonight. Amazing my husband ha...   \n",
       "9pSSL6X6lFpY3FCRLEH3og  This was an amazing dinning experience! ORDER ...   \n",
       "gm8nNoA3uB4In5o_Hxpq3g  My husband and I went there for lunch on a Sat...   \n",
       "CEtidlXNyQzgJSdF1ubPFw  Went for a nice anniversary dinner. Researched...   \n",
       "-Z7Nw2UF7NiBSAzfXNA_XA  This place is first class in every way. Lobste...   \n",
       "\n",
       "                        useful                address  \\\n",
       "user_id                                                 \n",
       "ymlnR8UeFvB4FZL56tCZsA       0  3355 Las Vegas Blvd S   \n",
       "9pSSL6X6lFpY3FCRLEH3og       0  3355 Las Vegas Blvd S   \n",
       "gm8nNoA3uB4In5o_Hxpq3g       1  3355 Las Vegas Blvd S   \n",
       "CEtidlXNyQzgJSdF1ubPFw       0  3355 Las Vegas Blvd S   \n",
       "-Z7Nw2UF7NiBSAzfXNA_XA       0  3355 Las Vegas Blvd S   \n",
       "\n",
       "                                                               attributes  \\\n",
       "user_id                                                                     \n",
       "ymlnR8UeFvB4FZL56tCZsA  {'Alcohol': 'full_bar', 'Ambience': \"{'romanti...   \n",
       "9pSSL6X6lFpY3FCRLEH3og  {'Alcohol': 'full_bar', 'Ambience': \"{'romanti...   \n",
       "gm8nNoA3uB4In5o_Hxpq3g  {'Alcohol': 'full_bar', 'Ambience': \"{'romanti...   \n",
       "CEtidlXNyQzgJSdF1ubPFw  {'Alcohol': 'full_bar', 'Ambience': \"{'romanti...   \n",
       "-Z7Nw2UF7NiBSAzfXNA_XA  {'Alcohol': 'full_bar', 'Ambience': \"{'romanti...   \n",
       "\n",
       "                        ... is_open   latitude  longitude  \\\n",
       "user_id                 ...                                 \n",
       "ymlnR8UeFvB4FZL56tCZsA  ...     1.0  36.123183 -115.16919   \n",
       "9pSSL6X6lFpY3FCRLEH3og  ...     1.0  36.123183 -115.16919   \n",
       "gm8nNoA3uB4In5o_Hxpq3g  ...     1.0  36.123183 -115.16919   \n",
       "CEtidlXNyQzgJSdF1ubPFw  ...     1.0  36.123183 -115.16919   \n",
       "-Z7Nw2UF7NiBSAzfXNA_XA  ...     1.0  36.123183 -115.16919   \n",
       "\n",
       "                                        name  neighborhood  postal_code  \\\n",
       "user_id                                                                   \n",
       "ymlnR8UeFvB4FZL56tCZsA  Delmonico Steakhouse     The Strip      89109.0   \n",
       "9pSSL6X6lFpY3FCRLEH3og  Delmonico Steakhouse     The Strip      89109.0   \n",
       "gm8nNoA3uB4In5o_Hxpq3g  Delmonico Steakhouse     The Strip      89109.0   \n",
       "CEtidlXNyQzgJSdF1ubPFw  Delmonico Steakhouse     The Strip      89109.0   \n",
       "-Z7Nw2UF7NiBSAzfXNA_XA  Delmonico Steakhouse     The Strip      89109.0   \n",
       "\n",
       "                       review_count avg_stars  state  cluster  \n",
       "user_id                                                        \n",
       "ymlnR8UeFvB4FZL56tCZsA       1546.0       4.0     NV        1  \n",
       "9pSSL6X6lFpY3FCRLEH3og       1546.0       4.0     NV        1  \n",
       "gm8nNoA3uB4In5o_Hxpq3g       1546.0       4.0     NV        1  \n",
       "CEtidlXNyQzgJSdF1ubPFw       1546.0       4.0     NV        1  \n",
       "-Z7Nw2UF7NiBSAzfXNA_XA       1546.0       4.0     NV        1  \n",
       "\n",
       "[5 rows x 23 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_concat.set_index('user_id').head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "user_id\n",
       "ymlnR8UeFvB4FZL56tCZsA    1\n",
       "9pSSL6X6lFpY3FCRLEH3og    1\n",
       "gm8nNoA3uB4In5o_Hxpq3g    1\n",
       "CEtidlXNyQzgJSdF1ubPFw    1\n",
       "-Z7Nw2UF7NiBSAzfXNA_XA    1\n",
       "Name: cluster, dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_user = df_concat.set_index('user_id')['cluster']\n",
    "df_user.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_user = pd.get_dummies(df_user, prefix='cluster_')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>cluster__0</th>\n",
       "      <th>cluster__1</th>\n",
       "      <th>cluster__2</th>\n",
       "      <th>cluster__3</th>\n",
       "      <th>cluster__4</th>\n",
       "      <th>cluster__5</th>\n",
       "      <th>cluster__6</th>\n",
       "      <th>cluster__7</th>\n",
       "      <th>cluster__8</th>\n",
       "      <th>cluster__9</th>\n",
       "      <th>cluster__10</th>\n",
       "      <th>cluster__11</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>user_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>ymlnR8UeFvB4FZL56tCZsA</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9pSSL6X6lFpY3FCRLEH3og</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>gm8nNoA3uB4In5o_Hxpq3g</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CEtidlXNyQzgJSdF1ubPFw</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-Z7Nw2UF7NiBSAzfXNA_XA</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        cluster__0  cluster__1  cluster__2  cluster__3  \\\n",
       "user_id                                                                  \n",
       "ymlnR8UeFvB4FZL56tCZsA           0           1           0           0   \n",
       "9pSSL6X6lFpY3FCRLEH3og           0           1           0           0   \n",
       "gm8nNoA3uB4In5o_Hxpq3g           0           1           0           0   \n",
       "CEtidlXNyQzgJSdF1ubPFw           0           1           0           0   \n",
       "-Z7Nw2UF7NiBSAzfXNA_XA           0           1           0           0   \n",
       "\n",
       "                        cluster__4  cluster__5  cluster__6  cluster__7  \\\n",
       "user_id                                                                  \n",
       "ymlnR8UeFvB4FZL56tCZsA           0           0           0           0   \n",
       "9pSSL6X6lFpY3FCRLEH3og           0           0           0           0   \n",
       "gm8nNoA3uB4In5o_Hxpq3g           0           0           0           0   \n",
       "CEtidlXNyQzgJSdF1ubPFw           0           0           0           0   \n",
       "-Z7Nw2UF7NiBSAzfXNA_XA           0           0           0           0   \n",
       "\n",
       "                        cluster__8  cluster__9  cluster__10  cluster__11  \n",
       "user_id                                                                   \n",
       "ymlnR8UeFvB4FZL56tCZsA           0           0            0            0  \n",
       "9pSSL6X6lFpY3FCRLEH3og           0           0            0            0  \n",
       "gm8nNoA3uB4In5o_Hxpq3g           0           0            0            0  \n",
       "CEtidlXNyQzgJSdF1ubPFw           0           0            0            0  \n",
       "-Z7Nw2UF7NiBSAzfXNA_XA           0           0            0            0  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_user.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_user = df_user.groupby(level=0).sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(260210, 12)"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_user.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "260210"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df_concat['user_id'].unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>cluster__0</th>\n",
       "      <th>cluster__1</th>\n",
       "      <th>cluster__2</th>\n",
       "      <th>cluster__3</th>\n",
       "      <th>cluster__4</th>\n",
       "      <th>cluster__5</th>\n",
       "      <th>cluster__6</th>\n",
       "      <th>cluster__7</th>\n",
       "      <th>cluster__8</th>\n",
       "      <th>cluster__9</th>\n",
       "      <th>cluster__10</th>\n",
       "      <th>cluster__11</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>user_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>---1lKK3aKOuomHnwAkAow</th>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>---udAKDsn0yQXmzbWQNSw</th>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>--0sXNBv6IizZXuV-nl0Aw</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>--2bpE5vyR-2hAP7sZZ4lA</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>--2vR0DIsmQ6WfcSzKWigw</th>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        cluster__0  cluster__1  cluster__2  cluster__3  \\\n",
       "user_id                                                                  \n",
       "---1lKK3aKOuomHnwAkAow         0.0         2.0         0.0         1.0   \n",
       "---udAKDsn0yQXmzbWQNSw         0.0         2.0         0.0         0.0   \n",
       "--0sXNBv6IizZXuV-nl0Aw         0.0         0.0         0.0         0.0   \n",
       "--2bpE5vyR-2hAP7sZZ4lA         0.0         0.0         0.0         0.0   \n",
       "--2vR0DIsmQ6WfcSzKWigw         0.0         2.0         0.0         0.0   \n",
       "\n",
       "                        cluster__4  cluster__5  cluster__6  cluster__7  \\\n",
       "user_id                                                                  \n",
       "---1lKK3aKOuomHnwAkAow         0.0         0.0         0.0         0.0   \n",
       "---udAKDsn0yQXmzbWQNSw         0.0         0.0         0.0         0.0   \n",
       "--0sXNBv6IizZXuV-nl0Aw         0.0         0.0         0.0         0.0   \n",
       "--2bpE5vyR-2hAP7sZZ4lA         0.0         0.0         0.0         0.0   \n",
       "--2vR0DIsmQ6WfcSzKWigw         0.0         0.0         1.0         0.0   \n",
       "\n",
       "                        cluster__8  cluster__9  cluster__10  cluster__11  \n",
       "user_id                                                                   \n",
       "---1lKK3aKOuomHnwAkAow         0.0         0.0          2.0          0.0  \n",
       "---udAKDsn0yQXmzbWQNSw         0.0         0.0          0.0          0.0  \n",
       "--0sXNBv6IizZXuV-nl0Aw         0.0         0.0          0.0          1.0  \n",
       "--2bpE5vyR-2hAP7sZZ4lA         0.0         0.0          1.0          0.0  \n",
       "--2vR0DIsmQ6WfcSzKWigw         0.0         1.0          0.0          0.0  "
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_user.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>cluster__0</th>\n",
       "      <th>cluster__1</th>\n",
       "      <th>cluster__2</th>\n",
       "      <th>cluster__3</th>\n",
       "      <th>cluster__4</th>\n",
       "      <th>cluster__5</th>\n",
       "      <th>cluster__6</th>\n",
       "      <th>cluster__7</th>\n",
       "      <th>cluster__8</th>\n",
       "      <th>cluster__9</th>\n",
       "      <th>cluster__10</th>\n",
       "      <th>cluster__11</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>user_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>---1lKK3aKOuomHnwAkAow</th>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>---udAKDsn0yQXmzbWQNSw</th>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>--0sXNBv6IizZXuV-nl0Aw</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>--2bpE5vyR-2hAP7sZZ4lA</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>--2vR0DIsmQ6WfcSzKWigw</th>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        cluster__0  cluster__1  cluster__2  cluster__3  \\\n",
       "user_id                                                                  \n",
       "---1lKK3aKOuomHnwAkAow           0           2           4           5   \n",
       "---udAKDsn0yQXmzbWQNSw           0           2           3           4   \n",
       "--0sXNBv6IizZXuV-nl0Aw           0           1           2           3   \n",
       "--2bpE5vyR-2hAP7sZZ4lA           0           1           2           3   \n",
       "--2vR0DIsmQ6WfcSzKWigw           0           2           3           4   \n",
       "\n",
       "                        cluster__4  cluster__5  cluster__6  cluster__7  \\\n",
       "user_id                                                                  \n",
       "---1lKK3aKOuomHnwAkAow           6           7           8           9   \n",
       "---udAKDsn0yQXmzbWQNSw           5           6           7           8   \n",
       "--0sXNBv6IizZXuV-nl0Aw           4           5           6           7   \n",
       "--2bpE5vyR-2hAP7sZZ4lA           4           5           6           7   \n",
       "--2vR0DIsmQ6WfcSzKWigw           5           7           8          10   \n",
       "\n",
       "                        cluster__8  cluster__9  cluster__10  cluster__11  \n",
       "user_id                                                                   \n",
       "---1lKK3aKOuomHnwAkAow          11           3            1           10  \n",
       "---udAKDsn0yQXmzbWQNSw           9          10           11            1  \n",
       "--0sXNBv6IizZXuV-nl0Aw           8           9           10           11  \n",
       "--2bpE5vyR-2hAP7sZZ4lA           8           9           11           10  \n",
       "--2vR0DIsmQ6WfcSzKWigw          11           6            9            1  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_user_idx = np.argsort(df_user, axis=1)\n",
    "df_user_idx.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['cluster__0',\n",
       " 'cluster__1',\n",
       " 'cluster__2',\n",
       " 'cluster__3',\n",
       " 'cluster__4',\n",
       " 'cluster__5',\n",
       " 'cluster__6',\n",
       " 'cluster__7',\n",
       " 'cluster__8',\n",
       " 'cluster__9',\n",
       " 'cluster__10',\n",
       " 'cluster__11']"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(df_user_idx)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_user['most_cluster'] = df_user_idx['cluster__11']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>cluster__0</th>\n",
       "      <th>cluster__1</th>\n",
       "      <th>cluster__2</th>\n",
       "      <th>cluster__3</th>\n",
       "      <th>cluster__4</th>\n",
       "      <th>cluster__5</th>\n",
       "      <th>cluster__6</th>\n",
       "      <th>cluster__7</th>\n",
       "      <th>cluster__8</th>\n",
       "      <th>cluster__9</th>\n",
       "      <th>cluster__10</th>\n",
       "      <th>cluster__11</th>\n",
       "      <th>most_cluster</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>user_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>---1lKK3aKOuomHnwAkAow</th>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>---udAKDsn0yQXmzbWQNSw</th>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>--0sXNBv6IizZXuV-nl0Aw</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>--2bpE5vyR-2hAP7sZZ4lA</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>--2vR0DIsmQ6WfcSzKWigw</th>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        cluster__0  cluster__1  cluster__2  cluster__3  \\\n",
       "user_id                                                                  \n",
       "---1lKK3aKOuomHnwAkAow         0.0         2.0         0.0         1.0   \n",
       "---udAKDsn0yQXmzbWQNSw         0.0         2.0         0.0         0.0   \n",
       "--0sXNBv6IizZXuV-nl0Aw         0.0         0.0         0.0         0.0   \n",
       "--2bpE5vyR-2hAP7sZZ4lA         0.0         0.0         0.0         0.0   \n",
       "--2vR0DIsmQ6WfcSzKWigw         0.0         2.0         0.0         0.0   \n",
       "\n",
       "                        cluster__4  cluster__5  cluster__6  cluster__7  \\\n",
       "user_id                                                                  \n",
       "---1lKK3aKOuomHnwAkAow         0.0         0.0         0.0         0.0   \n",
       "---udAKDsn0yQXmzbWQNSw         0.0         0.0         0.0         0.0   \n",
       "--0sXNBv6IizZXuV-nl0Aw         0.0         0.0         0.0         0.0   \n",
       "--2bpE5vyR-2hAP7sZZ4lA         0.0         0.0         0.0         0.0   \n",
       "--2vR0DIsmQ6WfcSzKWigw         0.0         0.0         1.0         0.0   \n",
       "\n",
       "                        cluster__8  cluster__9  cluster__10  cluster__11  \\\n",
       "user_id                                                                    \n",
       "---1lKK3aKOuomHnwAkAow         0.0         0.0          2.0          0.0   \n",
       "---udAKDsn0yQXmzbWQNSw         0.0         0.0          0.0          0.0   \n",
       "--0sXNBv6IizZXuV-nl0Aw         0.0         0.0          0.0          1.0   \n",
       "--2bpE5vyR-2hAP7sZZ4lA         0.0         0.0          1.0          0.0   \n",
       "--2vR0DIsmQ6WfcSzKWigw         0.0         1.0          0.0          0.0   \n",
       "\n",
       "                        most_cluster  \n",
       "user_id                               \n",
       "---1lKK3aKOuomHnwAkAow            10  \n",
       "---udAKDsn0yQXmzbWQNSw             1  \n",
       "--0sXNBv6IizZXuV-nl0Aw            11  \n",
       "--2bpE5vyR-2hAP7sZZ4lA            10  \n",
       "--2vR0DIsmQ6WfcSzKWigw             1  "
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_user.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>most_cluster</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>user_id</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>---1lKK3aKOuomHnwAkAow</th>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>---udAKDsn0yQXmzbWQNSw</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>--0sXNBv6IizZXuV-nl0Aw</th>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>--2bpE5vyR-2hAP7sZZ4lA</th>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>--2vR0DIsmQ6WfcSzKWigw</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        most_cluster\n",
       "user_id                             \n",
       "---1lKK3aKOuomHnwAkAow            10\n",
       "---udAKDsn0yQXmzbWQNSw             1\n",
       "--0sXNBv6IizZXuV-nl0Aw            11\n",
       "--2bpE5vyR-2hAP7sZZ4lA            10\n",
       "--2vR0DIsmQ6WfcSzKWigw             1"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_user_most_cluster = df_user[['most_cluster']]\n",
    "df_user_most_cluster.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_user_most_csv = '../data/df_user_most.csv'\n",
    "df_user_most_cluster.to_csv(df_user_most_csv, index=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Start"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_res_cluster = [df_concat[df_concat['cluster'] == i] for i in range(12)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>business_id</th>\n",
       "      <th>user_id</th>\n",
       "      <th>stars</th>\n",
       "      <th>cluster</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2571</th>\n",
       "      <td>-LMycE26AortJDsbc8oXOg</td>\n",
       "      <td>MrgrBZBe9Fix0oGncpYTAQ</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2572</th>\n",
       "      <td>-LMycE26AortJDsbc8oXOg</td>\n",
       "      <td>LTUFysTYpEX25sCUy-ORtg</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2573</th>\n",
       "      <td>-LMycE26AortJDsbc8oXOg</td>\n",
       "      <td>JaPYkrKv8Z5hkSc237Ss9Q</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2574</th>\n",
       "      <td>-LMycE26AortJDsbc8oXOg</td>\n",
       "      <td>UDKqdVT0FrpL19shSOqgow</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2575</th>\n",
       "      <td>-LMycE26AortJDsbc8oXOg</td>\n",
       "      <td>1_8CkXqRdtR3oMk8JzSStw</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 business_id                 user_id  stars  cluster\n",
       "2571  -LMycE26AortJDsbc8oXOg  MrgrBZBe9Fix0oGncpYTAQ      2        0\n",
       "2572  -LMycE26AortJDsbc8oXOg  LTUFysTYpEX25sCUy-ORtg      1        0\n",
       "2573  -LMycE26AortJDsbc8oXOg  JaPYkrKv8Z5hkSc237Ss9Q      4        0\n",
       "2574  -LMycE26AortJDsbc8oXOg  UDKqdVT0FrpL19shSOqgow      5        0\n",
       "2575  -LMycE26AortJDsbc8oXOg  1_8CkXqRdtR3oMk8JzSStw      1        0"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_res_cluster[0].head(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 1. Clean data and get rating data "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Select relevant columns in the original dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_user_most = pd.read_csv('../data/df_user_most.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "del df_concat"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>business_id</th>\n",
       "      <th>user_id</th>\n",
       "      <th>stars</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2571</th>\n",
       "      <td>-LMycE26AortJDsbc8oXOg</td>\n",
       "      <td>MrgrBZBe9Fix0oGncpYTAQ</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2572</th>\n",
       "      <td>-LMycE26AortJDsbc8oXOg</td>\n",
       "      <td>LTUFysTYpEX25sCUy-ORtg</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2573</th>\n",
       "      <td>-LMycE26AortJDsbc8oXOg</td>\n",
       "      <td>JaPYkrKv8Z5hkSc237Ss9Q</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2574</th>\n",
       "      <td>-LMycE26AortJDsbc8oXOg</td>\n",
       "      <td>UDKqdVT0FrpL19shSOqgow</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2575</th>\n",
       "      <td>-LMycE26AortJDsbc8oXOg</td>\n",
       "      <td>1_8CkXqRdtR3oMk8JzSStw</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 business_id                 user_id  stars\n",
       "2571  -LMycE26AortJDsbc8oXOg  MrgrBZBe9Fix0oGncpYTAQ      2\n",
       "2572  -LMycE26AortJDsbc8oXOg  LTUFysTYpEX25sCUy-ORtg      1\n",
       "2573  -LMycE26AortJDsbc8oXOg  JaPYkrKv8Z5hkSc237Ss9Q      4\n",
       "2574  -LMycE26AortJDsbc8oXOg  UDKqdVT0FrpL19shSOqgow      5\n",
       "2575  -LMycE26AortJDsbc8oXOg  1_8CkXqRdtR3oMk8JzSStw      1"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Get business_id, user_id, stars for recommender\n",
    "df_rec = []\n",
    "for df_tmp in df_res_cluster:\n",
    "    df_rec.append(df_tmp[['business_id', 'user_id', 'stars']])\n",
    "df_rec[0].head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Create utility matrix from records"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Ql_J2DSIE8QYp5rXf3721A'"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bus_id[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bus_dic['Ql_J2DSIE8QYp5rXf3721A']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_utility = []\n",
    "\n",
    "for df_tmp in df_rec:\n",
    "    df_utility.append(pd.pivot_table(data = df_tmp,\n",
    "                                    values='stars',\n",
    "                                    index='user_id',\n",
    "                                    columns='business_id',\n",
    "                                    fill_value=0))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 2. Item-Item similarity recommender"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Calculate item-item similarity matrix"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.metrics.pairwise import cosine_similarity\n",
    "item_sim_mat = []\n",
    "for df_ut in df_utility:\n",
    "    item_sim_mat.append(cosine_similarity(df_ut.T))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(269, 269)"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "item_sim_mat[0].shape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Calculate neighborhood"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(269, 269)"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "least_to_most_sim_indexes = []\n",
    "for item_mat in item_sim_mat:\n",
    "    least_to_most_sim_indexes.append(np.argsort(item_mat, axis=1))\n",
    "least_to_most_sim_indexes[0].shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(269, 10)"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Get neighborhoods\n",
    "neighborhood_size = 10\n",
    "neighborhoods = []\n",
    "for least_index in least_to_most_sim_indexes:\n",
    "    neighborhoods.append(least_index[:, -neighborhood_size:])\n",
    "neighborhoods[0].shape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Make rating prediction on a user"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "user_id = np.random.choice(df_user_most['user_id'], 1)\n",
    "random_user = user_id[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'KokGLhlkzAGdfcTddEN_Sw'"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "random_user"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_user_most = df_user_most.set_index('user_id')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>most_cluster</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>user_id</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>---1lKK3aKOuomHnwAkAow</th>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>---udAKDsn0yQXmzbWQNSw</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>--0sXNBv6IizZXuV-nl0Aw</th>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>--2bpE5vyR-2hAP7sZZ4lA</th>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>--2vR0DIsmQ6WfcSzKWigw</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        most_cluster\n",
       "user_id                             \n",
       "---1lKK3aKOuomHnwAkAow            10\n",
       "---udAKDsn0yQXmzbWQNSw             1\n",
       "--0sXNBv6IizZXuV-nl0Aw            11\n",
       "--2bpE5vyR-2hAP7sZZ4lA            10\n",
       "--2vR0DIsmQ6WfcSzKWigw             1"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_user_most.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "11"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "user_cluster = df_user_most.loc[random_user].values[0]\n",
    "user_cluster"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(146, 146)"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "item_sim_mat[user_cluster].shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>business_id</th>\n",
       "      <th>0-cZ9XfpC3vsLotOJ6Nxfg</th>\n",
       "      <th>0InA3Ffj8MxyQV9hgsyYcQ</th>\n",
       "      <th>0NmTwqYEQiKErDv4a55obg</th>\n",
       "      <th>0mnnlFCploePlnEaddw63g</th>\n",
       "      <th>0qet57CmMA5qUm6gPFUTpg</th>\n",
       "      <th>12P7GjIoq6oj7qCyJ_c0Ag</th>\n",
       "      <th>1WBVqmo7tgF0z0eGf4fPhQ</th>\n",
       "      <th>21sGRVR7HEs_t6PdB9tGMw</th>\n",
       "      <th>2O_b-IAAW7SoPt__RX1Kww</th>\n",
       "      <th>2bK1ng2mnRdtTh_BDNGmIg</th>\n",
       "      <th>...</th>\n",
       "      <th>wPiRP76arN0NB3M1ZXXp7g</th>\n",
       "      <th>x8jNsE4EAYCsecNNlYU02Q</th>\n",
       "      <th>x_onUwRHvlStmDhmLIuPBg</th>\n",
       "      <th>xvfAxe6F0azYjfLSm8ISMA</th>\n",
       "      <th>yniif9v-2PpVIbsotxv6OA</th>\n",
       "      <th>z45xS0Kc6GpiITwrpkRVdQ</th>\n",
       "      <th>zBD6zc8YU-TA0_KJmN1tpA</th>\n",
       "      <th>zQp4fij2fBaZawyO_ymIEg</th>\n",
       "      <th>zY6f_cFY8HTI3hLlJj3SOg</th>\n",
       "      <th>zYDih_sBtW5ujL-zmUjIqA</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>user_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>--0sXNBv6IizZXuV-nl0Aw</th>\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>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>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>--3loIEaXcepp9OKGi_1FQ</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</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>--7oh57FmI8_IHX0Q4n-Wg</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</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>--ZNfWKj1VyVElRx6-g1fg</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</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>--k1k6Iid_sLqUm6_DFoXQ</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 146 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "business_id             0-cZ9XfpC3vsLotOJ6Nxfg  0InA3Ffj8MxyQV9hgsyYcQ  \\\n",
       "user_id                                                                  \n",
       "--0sXNBv6IizZXuV-nl0Aw                       0                       0   \n",
       "--3loIEaXcepp9OKGi_1FQ                       0                       0   \n",
       "--7oh57FmI8_IHX0Q4n-Wg                       0                       0   \n",
       "--ZNfWKj1VyVElRx6-g1fg                       0                       0   \n",
       "--k1k6Iid_sLqUm6_DFoXQ                       0                       0   \n",
       "\n",
       "business_id             0NmTwqYEQiKErDv4a55obg  0mnnlFCploePlnEaddw63g  \\\n",
       "user_id                                                                  \n",
       "--0sXNBv6IizZXuV-nl0Aw                       0                       0   \n",
       "--3loIEaXcepp9OKGi_1FQ                       0                       0   \n",
       "--7oh57FmI8_IHX0Q4n-Wg                       0                       0   \n",
       "--ZNfWKj1VyVElRx6-g1fg                       0                       0   \n",
       "--k1k6Iid_sLqUm6_DFoXQ                       0                       0   \n",
       "\n",
       "business_id             0qet57CmMA5qUm6gPFUTpg  12P7GjIoq6oj7qCyJ_c0Ag  \\\n",
       "user_id                                                                  \n",
       "--0sXNBv6IizZXuV-nl0Aw                       0                       0   \n",
       "--3loIEaXcepp9OKGi_1FQ                       0                       0   \n",
       "--7oh57FmI8_IHX0Q4n-Wg                       0                       0   \n",
       "--ZNfWKj1VyVElRx6-g1fg                       0                       0   \n",
       "--k1k6Iid_sLqUm6_DFoXQ                       0                       0   \n",
       "\n",
       "business_id             1WBVqmo7tgF0z0eGf4fPhQ  21sGRVR7HEs_t6PdB9tGMw  \\\n",
       "user_id                                                                  \n",
       "--0sXNBv6IizZXuV-nl0Aw                       5                       0   \n",
       "--3loIEaXcepp9OKGi_1FQ                       0                       0   \n",
       "--7oh57FmI8_IHX0Q4n-Wg                       0                       0   \n",
       "--ZNfWKj1VyVElRx6-g1fg                       0                       0   \n",
       "--k1k6Iid_sLqUm6_DFoXQ                       0                       0   \n",
       "\n",
       "business_id             2O_b-IAAW7SoPt__RX1Kww  2bK1ng2mnRdtTh_BDNGmIg  ...  \\\n",
       "user_id                                                                 ...   \n",
       "--0sXNBv6IizZXuV-nl0Aw                       0                       0  ...   \n",
       "--3loIEaXcepp9OKGi_1FQ                       0                       0  ...   \n",
       "--7oh57FmI8_IHX0Q4n-Wg                       0                       0  ...   \n",
       "--ZNfWKj1VyVElRx6-g1fg                       0                       0  ...   \n",
       "--k1k6Iid_sLqUm6_DFoXQ                       0                       0  ...   \n",
       "\n",
       "business_id             wPiRP76arN0NB3M1ZXXp7g  x8jNsE4EAYCsecNNlYU02Q  \\\n",
       "user_id                                                                  \n",
       "--0sXNBv6IizZXuV-nl0Aw                       0                       0   \n",
       "--3loIEaXcepp9OKGi_1FQ                       0                       0   \n",
       "--7oh57FmI8_IHX0Q4n-Wg                       0                       0   \n",
       "--ZNfWKj1VyVElRx6-g1fg                       0                       0   \n",
       "--k1k6Iid_sLqUm6_DFoXQ                       0                       0   \n",
       "\n",
       "business_id             x_onUwRHvlStmDhmLIuPBg  xvfAxe6F0azYjfLSm8ISMA  \\\n",
       "user_id                                                                  \n",
       "--0sXNBv6IizZXuV-nl0Aw                       0                       0   \n",
       "--3loIEaXcepp9OKGi_1FQ                       0                       0   \n",
       "--7oh57FmI8_IHX0Q4n-Wg                       0                       0   \n",
       "--ZNfWKj1VyVElRx6-g1fg                       0                       0   \n",
       "--k1k6Iid_sLqUm6_DFoXQ                       0                       0   \n",
       "\n",
       "business_id             yniif9v-2PpVIbsotxv6OA  z45xS0Kc6GpiITwrpkRVdQ  \\\n",
       "user_id                                                                  \n",
       "--0sXNBv6IizZXuV-nl0Aw                       0                       0   \n",
       "--3loIEaXcepp9OKGi_1FQ                       0                       0   \n",
       "--7oh57FmI8_IHX0Q4n-Wg                       0                       0   \n",
       "--ZNfWKj1VyVElRx6-g1fg                       0                       0   \n",
       "--k1k6Iid_sLqUm6_DFoXQ                       0                       0   \n",
       "\n",
       "business_id             zBD6zc8YU-TA0_KJmN1tpA  zQp4fij2fBaZawyO_ymIEg  \\\n",
       "user_id                                                                  \n",
       "--0sXNBv6IizZXuV-nl0Aw                       0                       0   \n",
       "--3loIEaXcepp9OKGi_1FQ                       0                       0   \n",
       "--7oh57FmI8_IHX0Q4n-Wg                       0                       0   \n",
       "--ZNfWKj1VyVElRx6-g1fg                       0                       0   \n",
       "--k1k6Iid_sLqUm6_DFoXQ                       0                       0   \n",
       "\n",
       "business_id             zY6f_cFY8HTI3hLlJj3SOg  zYDih_sBtW5ujL-zmUjIqA  \n",
       "user_id                                                                 \n",
       "--0sXNBv6IizZXuV-nl0Aw                       0                       0  \n",
       "--3loIEaXcepp9OKGi_1FQ                       0                       0  \n",
       "--7oh57FmI8_IHX0Q4n-Wg                       0                       0  \n",
       "--ZNfWKj1VyVElRx6-g1fg                       0                       0  \n",
       "--k1k6Iid_sLqUm6_DFoXQ                       0                       0  \n",
       "\n",
       "[5 rows x 146 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_utility[user_cluster].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['0-cZ9XfpC3vsLotOJ6Nxfg',\n",
       " '0InA3Ffj8MxyQV9hgsyYcQ',\n",
       " '0NmTwqYEQiKErDv4a55obg',\n",
       " '0mnnlFCploePlnEaddw63g',\n",
       " '0qet57CmMA5qUm6gPFUTpg',\n",
       " '12P7GjIoq6oj7qCyJ_c0Ag',\n",
       " '1WBVqmo7tgF0z0eGf4fPhQ',\n",
       " '21sGRVR7HEs_t6PdB9tGMw',\n",
       " '2O_b-IAAW7SoPt__RX1Kww',\n",
       " '2bK1ng2mnRdtTh_BDNGmIg',\n",
       " '36ckWelVitpgX16g7lecqA',\n",
       " '45513UgSlMqWV_yAPVkXrg',\n",
       " '4EfiNcKSsafogIhAjwv0gg',\n",
       " '4KmrrhtfnngTVFa2d5LAjg',\n",
       " '4VkLiFoIEjTTpbCRgxjnCQ',\n",
       " '4yJVSK-Q5UkED6RjORRssA',\n",
       " '5CJOaZc8Muu8WothauxQ4g',\n",
       " '5gv6AqHXfi3gJV4fb432Vw',\n",
       " '5keoVVM81g-nJw0Zdpl1nA',\n",
       " '60uVlCUiLJvq3xNo_3bhQQ',\n",
       " '64o_nYvzIKwHFOSYSEm-qw',\n",
       " '6H8xfhoZ2IGa3eNiY5FqLA',\n",
       " '6TQ0gCdAqaBbuDyCGa0joA',\n",
       " '6jDD-Z8QcsKTdIDWwM8gog',\n",
       " '7NucoWCjPzZyRPjsVR28xQ',\n",
       " '82-wE5pkxyBKhfxyyZap_A',\n",
       " '8dSIAoz_UphMGpZr_uMing',\n",
       " '8olG8J91NG_QU92WHG5QfA',\n",
       " '8yiLVWzJyyTEhYE0fVNvlA',\n",
       " 'AN0bWhisCf6LN9eHZ7DQ3w',\n",
       " 'AZlnpvILz5cEWJifjr2CSQ',\n",
       " 'Ay34xZOFax3X23zaA3nwdg',\n",
       " 'BOQOuwSNhfKx1xvKtONsBg',\n",
       " 'CSaVK9wgqe2_tQuuCDINyQ',\n",
       " 'CvpXZRF-I7wfm19dW1jOXA',\n",
       " 'DGDBFpZk-NIvah4M7MtDDg',\n",
       " 'DLJCwHGtbAV31UQ1lnIjlw',\n",
       " 'DZwXQUa5KGUcJ0y4TO1pFQ',\n",
       " 'EBnR5M6upBcHfMK4063_Sw',\n",
       " 'Ehy00JWQixgoXzisVKhvag',\n",
       " 'EsVVTcYO9DhSK2oxakctjw',\n",
       " 'F7E3qP0oz_SuVGZGL0D8Zw',\n",
       " 'FKnIIONBcfdPSVW-r5_zfw',\n",
       " 'FW_zg6VuyW5v_vM394gWAw',\n",
       " 'FXiPQQGr_2bwlJ4wOrW2eA',\n",
       " 'FqJ1SWEBhgVl66FrcsovOQ',\n",
       " 'FqXwm6UpihHY7Ha-pr4y6Q',\n",
       " 'G-5kEa6E6PD5fkBRuA7k9Q',\n",
       " 'G9h56Qy5DudCqKBmbPWyzQ',\n",
       " 'GTR39A2jwNIS_NV8q2r_JA',\n",
       " 'GXDRFAunLh0aRao6ERnM4A',\n",
       " 'Gen0ei06dGq13OJ8DRXUjg',\n",
       " 'Gyrez6K8f1AyR7dzW9fvAw',\n",
       " 'HUWLnKD5LSZY134amUO2Rg',\n",
       " 'H_FkQxifSo13B2FWjhp36g',\n",
       " 'HaPwC4nxs6RPfe1pAQkQ4A',\n",
       " 'HojKatUfX4UHWaPqtl63NQ',\n",
       " 'I5RoKagQjGYCWgY4_fK_rQ',\n",
       " 'IO3iTBH0rX-G7E7wAreRSQ',\n",
       " 'Ki8seQY5mtXc36xjoMfeDA',\n",
       " 'KkgnBZj3jRVjCY2H49JRaw',\n",
       " 'KkmPDIWzvwbBpyqOHT6pcQ',\n",
       " 'KyzPvdGPb2ubVlXJrS2QPA',\n",
       " 'LFs5jyYdXlzi0SpAYi1eSA',\n",
       " 'LH4U1OJuJVxovAAcx2Oi9Q',\n",
       " 'LN0JGAl8Rr_r_5t_X8Kz6g',\n",
       " 'Lau3N654yNyWdIIybea1uA',\n",
       " 'MNaPOkqm2vKeNG8EqkZWCg',\n",
       " 'MgSd4P3ATkiywbbraFygHg',\n",
       " 'Mh84_j7YmRrAcm0DWV4bUw',\n",
       " 'Nw_-4DFjYK6BDG0CwNwSvQ',\n",
       " 'OMUe6NNOFEe0VdAouIqAuA',\n",
       " 'OUP9dy2eu_-2Mga3DpSFfQ',\n",
       " 'OYaL_-uxBCgrE94uNQ4VCA',\n",
       " 'PSRZaGGxXmOmabL2si8pKw',\n",
       " 'Piw03nxAXZF86UYaVrDn1g',\n",
       " 'Qj1BoynaIVZiKEe8Peq3_g',\n",
       " 'Ql_J2DSIE8QYp5rXf3721A',\n",
       " 'QnfAHUr5-HTiaA5-va3glQ',\n",
       " 'R073RHVTWuUc_JabjD0bsA',\n",
       " 'Sm2k1ijcnK17Ro5paN2_qQ',\n",
       " 'So132GP_uy3XbGs0KNyzyw',\n",
       " 'T9XOUa2dX4conDOqjUtmhA',\n",
       " 'UFn1moo95-PBzi9wWt5FGg',\n",
       " 'VfxlkvZQkLr9tu_w1SU_iw',\n",
       " 'WRbBmXMHmdWOkeGp21OoeA',\n",
       " 'XarMlmD4QuRgGdoYoKRRSQ',\n",
       " 'Xp6ogw-SCNK28s1I0fhUXw',\n",
       " 'Xs5MqC7-g0vc4nmWDtRZoQ',\n",
       " 'Z0o7EnCj3fgzC7E3QRabhQ',\n",
       " 'Z3ZSar8IVAR2qIupqxMynA',\n",
       " 'Zx4iQCmQfAaXvwPc3TlF9Q',\n",
       " 'aKEEQqL1UFMieilnylI1gw',\n",
       " 'aidcfUzZLOjWgwlxfv3UlA',\n",
       " 'anQSLdujUOp0sTCmIBi2Tg',\n",
       " 'aoXb8mDCyb-XbkITiIfYVA',\n",
       " 'bqDFZDfDPdCut0CbybDUrA',\n",
       " 'bvGdqJ-SeGdIHX-HEabwlg',\n",
       " 'cKXMA7AoyvrFKaZzNOp0nA',\n",
       " 'cUpdeZJawIwOl6G21z7CzA',\n",
       " 'cZO6RmJcqRY9jGbYY71z-A',\n",
       " 'cgZOP1ZUBOZmEQMSJ53oiQ',\n",
       " 'czlWRKl1HJwG9p5VZUdIlg',\n",
       " 'd3zW_b-JWlxMneNn7K9xew',\n",
       " 'dPxZI9lrKTl5dvFfnb1_Ig',\n",
       " 'dcFMlXIEun1ax2ebW_Y7-w',\n",
       " 'e0JOkQYz_cnz91k6X55PLw',\n",
       " 'eRjcli4nDHRwhByViUz9Ow',\n",
       " 'esivMfjV4OFS5g8YMuR3UA',\n",
       " 'fpM-O9Ul62xizBq9YNO_tQ',\n",
       " 'h3pMMRwqBjMeMtk0_qQzRQ',\n",
       " 'hdZ_4Vd9opGm5UajNUuhwA',\n",
       " 'hgQOESYp7CF4LnNI90XEiw',\n",
       " 'hrNIDao4XnOhrv7aaFehTg',\n",
       " 'iL2-xJ4-eMsJk88PsbivbQ',\n",
       " 'kafUXRNfQm3e_U14S2WbmA',\n",
       " 'lwxYmWqjmEZ0ukCsXC9Pfg',\n",
       " 'me17NOULVwu40AdKGYHIaQ',\n",
       " 'nI-ZmgPjAtiNTTU-_gnoYQ',\n",
       " 'nS6QENxe6YODNrQ45bpC-A',\n",
       " 'nUpz0YiBsOK7ff9k3vUJ3A',\n",
       " 'oH6QAuoTLFaX97oqqpLTMg',\n",
       " 'oRbrnRAXGQetQDbkDhJp8w',\n",
       " 'oaqbLDW3wNqkynlnp4mvlw',\n",
       " 'ppmYIHMCIL5bocUsJSsDWA',\n",
       " 'q3dJQtwZQrrurNT-1bNKgQ',\n",
       " 'qFAw6wHMMcr4ctF-ZdGhEA',\n",
       " 'r6jbUGiyoN05mZ13apQGgw',\n",
       " 'rS3KdecMS-EF4H3VtmkxBw',\n",
       " 's2X_2ri_9Krm0xuciKCR-Q',\n",
       " 'u0YYkO2CeD3JFCkR1wSMog',\n",
       " 'u73Cv9yp_gTGNhBvECSJGA',\n",
       " 'uIbZjRRqR1OR-t2NBCa1Wg',\n",
       " 'vQWVP7MtpgXFwUMvxCj9Tw',\n",
       " 'vZLAmpN-hTI3GCT9hlHVUA',\n",
       " 'w12x7UBSSRsdbp3ZqguG3Q',\n",
       " 'wPiRP76arN0NB3M1ZXXp7g',\n",
       " 'x8jNsE4EAYCsecNNlYU02Q',\n",
       " 'x_onUwRHvlStmDhmLIuPBg',\n",
       " 'xvfAxe6F0azYjfLSm8ISMA',\n",
       " 'yniif9v-2PpVIbsotxv6OA',\n",
       " 'z45xS0Kc6GpiITwrpkRVdQ',\n",
       " 'zBD6zc8YU-TA0_KJmN1tpA',\n",
       " 'zQp4fij2fBaZawyO_ymIEg',\n",
       " 'zY6f_cFY8HTI3hLlJj3SOg',\n",
       " 'zYDih_sBtW5ujL-zmUjIqA']"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_utl = list(df_utility[user_cluster].columns.values)\n",
    "df_utl"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "def item_list_to_id(item_list):\n",
    "    ans = []\n",
    "    for item in item_list:\n",
    "        ans.append(df_utl[item])\n",
    "    return ans"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[0. 0. 0. 0. 0. 0. 0. 0. 0. 5. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0.\n",
      " 0. 5. 0. 0. 0. 5. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0.\n",
      " 0. 0. 0. 0. 5. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 5. 0. 0. 0. 0.\n",
      " 0. 0. 5. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 5. 0. 0. 0. 0. 5. 0. 0. 0. 5.\n",
      " 0. 5. 0. 0. 5. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0.\n",
      " 0. 0. 0. 0. 0. 5. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 5. 0. 0. 0. 0. 0.\n",
      " 0. 0.]\n",
      "Execution time: 0.276783 seconds\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/opt/anaconda/lib/python3.6/site-packages/ipykernel_launcher.py:6: FutureWarning: Series.nonzero() is deprecated and will be removed in a future version.Use Series.to_numpy().nonzero() instead\n",
      "  \n"
     ]
    }
   ],
   "source": [
    "import time\n",
    "n_users = df_utility[user_cluster].shape[0]\n",
    "n_items = df_utility[user_cluster].shape[1]\n",
    "\n",
    "start_time = time.time()\n",
    "items_rated_by_this_user = df_utility[user_cluster].loc[random_user].nonzero()[0]\n",
    "# Just initializing so we have somewhere to put rating preds\n",
    "out = np.zeros(n_items)\n",
    "for item_to_rate in range(n_items):\n",
    "    relevant_items = np.intersect1d(neighborhoods[user_cluster][item_to_rate],\n",
    "                                    items_rated_by_this_user,\n",
    "                                    assume_unique=True)  # assume_unique speeds up intersection op\n",
    "    out[item_to_rate] = (df_utility[user_cluster].loc[random_user, item_list_to_id(relevant_items)] * \\\n",
    "        item_sim_mat[user_cluster][item_to_rate, relevant_items] / \\\n",
    "        item_sim_mat[user_cluster][item_to_rate, relevant_items]).sum()\n",
    "\n",
    "\n",
    "pred_ratings = np.nan_to_num(out)\n",
    "print(pred_ratings)\n",
    "print(\"Execution time: %f seconds\" % (time.time()-start_time))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(146,)"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pred_ratings.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/opt/anaconda/lib/python3.6/site-packages/ipykernel_launcher.py:8: FutureWarning: Series.nonzero() is deprecated and will be removed in a future version.Use Series.to_numpy().nonzero() instead\n",
      "  \n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "[9, 100, 97, 29, 95, 25, 91, 86, 52, 125]"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Recommend n restaruant\n",
    "n = 10\n",
    "\n",
    "# Get item indexes sorted by predicted rating\n",
    "item_index_sorted_by_pred_rating = list(np.argsort(pred_ratings))[::-1]\n",
    "\n",
    "# Find items that have been rated by user\n",
    "items_rated_by_this_user = df_utility[user_cluster].loc[random_user].nonzero()[0]\n",
    "\n",
    "# We want to exclude the items that have been rated by user\n",
    "unrated_items_by_pred_rating = [item for item in item_index_sorted_by_pred_rating\n",
    "                                if item not in items_rated_by_this_user]\n",
    "\n",
    "unrated_items_by_pred_rating[:n]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'--9e1ONYQuAa-CB_Rrw7Tw': 'Delmonico Steakhouse',\n",
       " '-1m9o3vGRA8IBPNvNqKLmA': \"Bavette's Steakhouse & Bar\",\n",
       " '-1vfRrlnNnNJ5boOVghMPA': 'Red Ginseng Narita Sushi & BBQ',\n",
       " '-3zffZUHoY8bQjGfPSoBKQ': 'Michael Mina',\n",
       " '-8R_-EkGpUhBk55K9Dd4mg': 'Sin City Thai Restaurant',\n",
       " '-9YyInW1wapzdNZrhQJ9dg': 'Fresh Buffet',\n",
       " '-AD5PiuJHgdUcAK-Vxao2A': 'Smashburger',\n",
       " '-ADtl9bLp8wNqYX1k3KuxA': 'Ichi Ramen House',\n",
       " '-AGdGGCeTS-njB_8GkUmjQ': 'Woo Chun Korean BBQ',\n",
       " '-BS4aZAQm9u41YnB9MUASA': 'Argana',\n",
       " '-Bf8BQ3yMk8U2f45r2DRKw': 'In-N-Out Burger',\n",
       " '-BmqghX1sv7sgsxOIS2yAg': 'Merkato Ethiopian Cafe',\n",
       " '-Bv-HHUs8aHzDrdWcZHn8w': 'Smashburger',\n",
       " '-C8sSrFqaCxp51pyo-fQLQ': 'The Rice Shop',\n",
       " '-CQokjildrY7UZezXCdEBw': 'Toddy Shop',\n",
       " '-CbDQXiuKzPQ0_jiUz03aw': 'Taiga Modern Japanese & Thai Restaurant',\n",
       " '-EohS3nXZGl6odE9Lx5BSw': 'Panda Express',\n",
       " '-FNquqGseSCVMWo7KbK-Tg': 'Chipotle Mexican Grill',\n",
       " '-FcZY7a7qgxTUlTvwuyJnQ': '8 Noodle Bar',\n",
       " '-G7MPSNBpxRJmtrJxdwt7A': 'La Costa Del Sol',\n",
       " '-IWsoxH7mLJTTpU5MmWY4w': 'Pho Kinh Do',\n",
       " '-JFVxwdVQfX207554dx1nw': 'Teriyaki Madness',\n",
       " '-JfncbVURtvuzBbof40o1w': 'The Cafe at Monte Carlo',\n",
       " '-Jo0rJr2mZxBVgaJqDs-TQ': 'Chiamaka Food',\n",
       " '-Jx2rd2rH7MlWfb9RMtCFQ': 'Kraken Cafe',\n",
       " '-K82LBrI3H0FVuhTbNDpRA': 'Shoku Ramen',\n",
       " '-LMycE26AortJDsbc8oXOg': 'Jack In the Box',\n",
       " '-Le6cwbZL4tDZwNHwipfKg': 'Marrakech',\n",
       " '-LzUYsR54hd8cCiYXTquRA': 'Medley Buffet',\n",
       " '-MmAW2x9vMGuhVcALU7QRw': \"McDonald's\",\n",
       " '-N_agk8RUHvHk3GVDsyunQ': 'Hitchin Post Saloon & Steakhouse',\n",
       " '-NjZ5HZApXjRJaTVZeSO_w': 'San Salvador Restaurant',\n",
       " '-OEIW0dO96-492qa_luxaw': 'Aces & Ales',\n",
       " '-P8dGzSVhJi-5oZ-8U2y0w': 'Cannery Row Buffet',\n",
       " '-PGsEXB6DFTVKa1eDOlzWA': 'Black Bear Diner',\n",
       " '-Pv-3Moxm6is6COkQIA7Kg': 'Bropards',\n",
       " '-QNQ4R1VgRoL4b6lC8Anrg': 'Mizuya',\n",
       " '-Qkx7W0itbAApcG5lJuMFQ': 'Jaburritos',\n",
       " '-RJ216TTIghZshCkUlD1WQ': 'Sushi Takashi',\n",
       " '-SGZcGqnsp_uRIjKP2RGZg': 'Ranch House Grille',\n",
       " '-SWWUof5TuWDVL5SEAml8Q': 'Wildburger',\n",
       " '-Tv5UZeFHdKz3RM9vOYpaw': \"Milano's Pizzeria\",\n",
       " '-U7tvCtaraTQ9b0zBhpBMA': 'MGM Grand Buffet',\n",
       " '-Uix-n4Jqo4W7ERagC5qAA': 'Wok & Roll \"TAPSILOGAN\"',\n",
       " '-UtYWvCnUppcSaC_u1pTYQ': 'Kopper Keg Restaurant & Lounge',\n",
       " '-WLrZPzjKfrftLWaCi1QZQ': 'Blueberry Hill Family Restaurant',\n",
       " '-WQhVJnBmyapFn0digQJwg': 'FruitLand Las Vegas',\n",
       " '-XKG6GamlSBwy5AcXQGAfA': 'Rickenbackers Cafe',\n",
       " '-YCd2_DdJUeZx3RRcmIZ_g': 'Taco Bell',\n",
       " '-YWr1wm_NaAlgEf9TZzsMQ': 'Jumbo Super Buffet',\n",
       " '-Ylpy3VyRWwubf9dysuwjQ': 'The Cheesecake Factory',\n",
       " '-_TSaVr53qiEGqMkwyEMaQ': 'Parsley Modern Mediterranean',\n",
       " '-_yEVC3_3M6YOsamYfNFEw': \"Jason's Deli\",\n",
       " '-a43zqioXNOjx_QejRS9FA': 'Little Rainbow Caf??',\n",
       " '-a857YYdjzgOdOjFFRsRXQ': 'Beer Park',\n",
       " '-cxD1NimFldATDUsN-oa3A': 'Coasta Cantina',\n",
       " '-dGORHtjPRnQzTZ2-SYa_g': 'Great Wraps',\n",
       " '-ed0Yc9on37RoIoG2ZgxBA': 'Le Thai',\n",
       " '-gXDD2oSHBDA3zgjX6g9pQ': 'The Plate Bar & Grill',\n",
       " '-hzQQ8tbXThpp0k5E_y1Dw': 'Blizz',\n",
       " '-iBk1_3M_efQtY6Bcygp5w': 'Viva Salsa',\n",
       " '-iFvYhgysvjkxckCr42NRw': \"Rani's World Foods\",\n",
       " '-ilCufjKjeswCLyIrCtuqQ': 'Tequila Bar and Grill',\n",
       " '-jEyZSptICvvaNhuur9rUg': 'Barista Bagels',\n",
       " '-kFyzXRzOlyoL4NyzoVkMA': 'Breakfast Buffet at Trump International Tower',\n",
       " '-kbPPBNsIPDfMfgUGO7QhA': 'Kopper Keg South',\n",
       " '-leM8v_oCbtzTthTln-YHg': \"Carl's Jr\",\n",
       " '-mN7z9oY01Mh_-dwTyzpqg': 'Einstein Bros Bagels',\n",
       " '-oUM2uISux96lMGeawHIOA': 'Sugar Factory',\n",
       " '-pG5srxtnRkd1bdIYn78xA': 'Carlitos Cuban Food',\n",
       " '-pGO9M4JLQJHiaCOrqCgbQ': 'Port of Subs',\n",
       " '-pdYzQ_5JAvNcHswys1hEQ': \"Domino's Pizza\",\n",
       " '-qYuPncpK8elgD-6Qx3v7A': 'Flock & Fowl',\n",
       " '-sEbDB_5jI_yIlklu1o1VQ': 'Haifa Restaurant',\n",
       " '-tseCGdDvepLP8IIWtZikQ': 'Polish Deli',\n",
       " '-uRn5Hf1uo4vf3UTtOvIfA': 'Don Tortaco Mexican Grill',\n",
       " '-wCtRhzWJ40Z4F8mmg7kWg': 'Herringbone',\n",
       " '-wDNRL4lm1UgeFLG9KcrjQ': 'Yummy Grill & Sushi',\n",
       " '-wvWO7UlQNK2IprIukH9uQ': 'Jon Smith Subs',\n",
       " '-xX-Vjol_fwWaN2mn1F1wg': 'Voodoo Pizza',\n",
       " '-xbQQR_ydEJGqYzHSF4DnQ': \"Maciano's Pizza & Pastaria\",\n",
       " '-zbJp3NGEhvmNOiFziN8Lg': 'Lopez Restaurant',\n",
       " '-zkn2p1mu9g-kbGNdM1lUA': 'Chinos Locos',\n",
       " '0-cZ9XfpC3vsLotOJ6Nxfg': 'Double Down',\n",
       " '011ayCokCnktQPSx-uL_SA': \"McDonald's\",\n",
       " '01Ov9eDxKRY5k6ImMdiWLQ': 'Hong Kong Garden Seafood & BBQ Cafe',\n",
       " '01SiPgdiOskMC5bUJoyy_g': \"Winchell's Pub & Grill\",\n",
       " '01VPJkcU0m8WzlA7dCEpVQ': 'Tea Space',\n",
       " '02pL_Xj3sTO_lHcWqUcwKA': \"Rollin' Smoke BBQ\",\n",
       " '03Yt7kMeYihN_y6ptiXxyQ': 'Del Taco',\n",
       " '03icrim6SfEQJlejDMbzsA': 'Pho Saigon',\n",
       " '05Solp0aY1YTZqoORMjUTg': 'La Pupusa Loca',\n",
       " '065c76tt1dXBNmoGBymUgQ': \"Cheffini's Hot Dogs\",\n",
       " '06MlxbtB4ZYeg_ri02RIAQ': 'El Pollo Loco',\n",
       " '07AZL5XenCQ_-op_onKLdw': 'BLT Steak',\n",
       " '07jQarxKd_8J_AJHD5YBqQ': 'Muscle Maker Grill - Las Vegas',\n",
       " '096iGHoQ-UImxUExuyqlZA': 'House of Aloha',\n",
       " '0APIz0O0c_XBDXQIWkJimA': \"King Solomon's Table\",\n",
       " '0AQnRQw34IQW9-1gJkYnMA': \"Diablo's Cantina\",\n",
       " '0AZCpDQpbi83NHh9uEpggQ': 'Ihop',\n",
       " '0CB7YB1qRSWLQvMbHw3Fmw': 'Easy Life Boba Tea',\n",
       " '0CwhlQzyXG_7RqEu-2pMSQ': 'Margarita Grille',\n",
       " '0DQ31asd4IeOTI7dkZ3OXQ': 'Sea Harbour Seafood Restaurant',\n",
       " '0EgYXYjt2XJL4hlsKnzrcw': 'PublicUs',\n",
       " '0EpnzIpeFvhISkxMTIv9WA': 'Paradise Place Jamaican Cuisine',\n",
       " '0FHfkDxKSeDuyAEeaY6X-Q': 'Panera Bread',\n",
       " '0G1y7uV7w1D2uziS4Lt_Dw': 'Chapalas Mexican Restaurants',\n",
       " '0G83H_zoum-Q4bWU2olTqQ': 'Bonjour Bakery & Deli',\n",
       " '0HG02r8ri7GEFwuwmdHCyg': 'KFC',\n",
       " '0Hcks5q-DgJbDlmEWolx4A': 'Bonefish Grill',\n",
       " '0IjBFHFm8M-VPyym-Xrkhw': 'Tower Pizzeria',\n",
       " '0InA3Ffj8MxyQV9hgsyYcQ': 'Novecento Pizzeria',\n",
       " '0JBqWzaSuOBHUo56RirJpg': 'Jack in the Box',\n",
       " '0LGnU7V3nepi8NUNzyQOXw': 'Einstein Bros Bagels',\n",
       " '0M7rIhQLKD-j2XSnKgt2ng': 'Sbarro',\n",
       " '0N53m33GANYeHHl-s22d4Q': 'Port of Subs',\n",
       " '0Nb4piKDUVbedlrakwEUuw': 'Del Taco',\n",
       " '0NmTwqYEQiKErDv4a55obg': 'Scarpetta',\n",
       " '0OdZXIKQypu6vplpxFilsA': 'Kneaders Bakery & Cafe',\n",
       " '0QHMAUi6NdOUZ1ckXq0-sA': 'Rainforest Caf??',\n",
       " '0QSnurP5Ibor2zepJmEIlw': 'Tacos La Mexicana',\n",
       " '0S2fiheNzQLDSCs89Kmgnw': 'Bowl of Heaven',\n",
       " '0S4WFZJZhVeM3aAqKjLz1w': 'VooDoo Steakhouse',\n",
       " '0TljdWRIDQzlp4siHQ_BAQ': \"Denny's\",\n",
       " '0Tutx9JhCi_HE6MUnbh5vw': 'Sexy Lexy Kitchen',\n",
       " '0UESjBq6_kPjCs4zPh4oEQ': 'Chicke Now',\n",
       " '0VjHFdczi6Nln_nn8bucJQ': 'Pho Bistro',\n",
       " '0WPXDs4ini3D7jpiy1Daqw': 'The Market',\n",
       " '0WoQQlMXVIDEgI0xNdENKA': 'Feast Buffet',\n",
       " '0XEqyl_lVaJNHRKxNcjJZg': 'Coffee Pub',\n",
       " '0YG_kM5caZhtwd6nbnei6A': 'The Charcoal Room',\n",
       " '0YctfylXsdutJo8qFYnZJA': 'Westcliff Station',\n",
       " '0Yeb_P24sj6MwG2qmuehkA': \"Till's Bar\",\n",
       " '0_VT3sTwi7gorIlU36ASmg': 'LOL Kids Club',\n",
       " '0_aeYE2-VbsZts_UpILgDw': 'Lazy Dog Restaurant & Bar',\n",
       " '0_mJttUgHIzC-NO18gcgBA': 'La Mojarra Loca Grill',\n",
       " '0aDCv4zPhzy7RklHDrnKQg': \"Lucie's Lounge\",\n",
       " '0ahghcpWQVkm4lEFwx-peA': \"Habib's Persian Cuisine\",\n",
       " '0aw3HbxkZ4G7pkPYt10fhA': 'Olive Garden Italian Restaurant',\n",
       " '0bWLkWeIcT-EnrE7SiGEBA': 'Laguna Pool House & Kitchen',\n",
       " '0c6PQILCLwRZ8FIB4AEsGw': 'China One - West Charleston',\n",
       " '0d0i0FaJq1GIeW1rS2D-5w': 'Bruxie',\n",
       " '0dr1FgqQSEMbaTu9SDqiIg': 'China A Go Go',\n",
       " '0eZHVYDyACtVVOIgoBlV3g': 'Da Sheng Chinese Cuisine',\n",
       " '0fdi2Y8RLbnLP9Cvwq7utw': 'Lucky 7s Buffet',\n",
       " '0gTTGuA6uEmMhLhfJi0hqA': \"Sammy's Woodfired Pizza and Grill\",\n",
       " '0gWg-kqRLEQbhui8b_v2Xw': 'Hi Scores - Blue Diamond',\n",
       " '0i9S0BejjRv0ZDwdO9XymA': 'Thai Seafood Ginger',\n",
       " '0ifI4JjTKcgfBSQiAnMmsQ': 'The Mad Greek Cafe',\n",
       " '0jJfQEWEe-6ODl62XSynDw': 'Haggen Food & Pharmacy',\n",
       " '0jtRI7hVMpQHpUVtUy4ITw': 'Omelet House Summerlin',\n",
       " '0keht9nVTliinChbGWWkkg': 'Tapas by Alex Stratta',\n",
       " '0m99JzzybBddbP9mr2y5XA': 'The Chicken Shack',\n",
       " '0mnnlFCploePlnEaddw63g': \"Aurelio's Pizza\",\n",
       " '0n3vcq00Z4ijqwwn-INfkg': \"Can't Dutch This\",\n",
       " '0nlocywsFHQmEt8_xbHNiw': 'Long Jin Chinese Cuisine',\n",
       " '0odAupWjDV8gwhaLqyh1-A': 'Chipotle Mexican Grill',\n",
       " '0p27EjcNwTI7Ey4K_MNPww': 'Fatburger',\n",
       " '0pJiZDiKz1dfx5CIjce5XQ': 'Luis Cocina',\n",
       " '0ps5B5C6oNaRsGyUJzFCuw': 'Subway',\n",
       " '0qPNeqLuKE88rKbIbSZDpg': 'Killer Shrimp',\n",
       " '0q_BHpxbikVtPRRLRu-U0g': 'Picasso',\n",
       " '0qet57CmMA5qUm6gPFUTpg': 'Di Fara Pizza',\n",
       " '0rk2_lmbfpiYXGBFmyxx9Q': 'Centro America Restaurant',\n",
       " '0tnZj3GkhKxPd9hT3HXt5A': 'Huntridge Pharmacy',\n",
       " '0uR48n5SYcLE_DLcjONZPg': \"Jimmy John's\",\n",
       " '0ueq5zB3NqLbh93KYYNIHQ': 'Thai Grill',\n",
       " '0uzQymPVW2l24rpjX9KIBA': 'KFC',\n",
       " '0v55V13hPb3sSF03widnKg': 'Subway',\n",
       " '0w3BdEOxvwKTpypwbN5kiQ': 'Tofu Hut',\n",
       " '0wW9PasC8pw8SY7rlY3ZKw': 'Fish King Grill',\n",
       " '0xNSLnqLT5miZO9RqSvbhw': 'Heavenly Jars',\n",
       " '0xtBEP5zCu1153SoqqemLw': 'Tacos Y Tortas El Panzon',\n",
       " '0xvdC8F0HmFpAFkJk6nXLg': 'Yoji?? Japanese Fondue',\n",
       " '0ydy2fdDg6kpGy1dbnHYsQ': 'Tequila Restaurante',\n",
       " '0yjLZZx708uJbierAonqQg': \"Church's Chicken\",\n",
       " '0zAJMAk4TbSm9XNQr9ks0A': 'Subway',\n",
       " '0zGeYN8ReYwVj27U7EHOJA': 'American Cafe',\n",
       " '0zoXYHq82haayMaV952jEQ': 'Greens and Proteins',\n",
       " '1-Jdq5Up9SgKoqptGvkXHA': 'MVR Auto Services',\n",
       " '11y02mqvQyJf0R8LImw3xA': 'Tacos El Guero Nayarit',\n",
       " '12P7GjIoq6oj7qCyJ_c0Ag': 'Little Caesars Pizza',\n",
       " '16Fplxu-OwVmTEFxQAUP4g': 'TENDER Steakhouse',\n",
       " '16NS8EICI94IGdn-S0yxkw': \"McDonald's\",\n",
       " '16tWXenJ1wTqugXJU7yiZg': '808 Sushi',\n",
       " '19S0gFtg5GTX6CkiApJiAQ': 'Frijoles & Frescas Grilled Tacos',\n",
       " '19lr9xcN3Ud0w0UX7bl6Qw': 'Subway',\n",
       " '19umlhmVB9O3njIBfRAe8g': 'Fiesta Rancho',\n",
       " '19wIOjBlI_2EKGM8E4O6Mg': 'Quiznos',\n",
       " '1BtNZszIr8LvtPOhN0X4Mw': 'Gold Mine Bar & Grill',\n",
       " '1CP8aJa8ILlfM5deroar0Q': 'Wingstop',\n",
       " '1CR2ddUcjYYwRd5JLtiRrw': 'Hard Rock Cafe',\n",
       " '1CTapYK3FHvpiJaQhOaaIw': 'L & L Hawaiian Barbecue',\n",
       " '1CWMNSTRMejdSyXBG2chNg': 'Fireside Restaurant & Tavern',\n",
       " '1CaM8eIvl41l4f3V-V-cAw': 'Smooth Eats',\n",
       " '1DHPkjDwHBguDZo_HR_ymw': 'Chengdu Laozao Hotpot',\n",
       " '1DP5vHxJzCDbgawv0WC3yA': 'Rose. Rabbit. Lie.',\n",
       " '1Df5WnLX3DqN6ymlhqznaQ': \"Roy's Restaurant\",\n",
       " '1FAvxOUOGGyZoYNlAXACag': 'Dal Toro Ristorante',\n",
       " '1KhBzrqmU164bss64jR5uA': \"Rick's Rollin Smoke BBQ & Tavern\",\n",
       " '1M1A-s6BbnzK3eURw01rZQ': 'Rincon Catracho',\n",
       " '1ME-zOtZ9HApzJUOpR0-vQ': 'El Herradero Mexican Restaurant',\n",
       " '1MrSwj8i2VEBHdp3IsWCpQ': 'El Fish Taco',\n",
       " '1NZNZHnGE4-FLZmU6xp3oQ': 'Kung Pao Wok',\n",
       " '1SCETxRnwaYo2aBC3fi4SA': 'PDQ - Las Vegas: Sahara',\n",
       " '1SE9f6TEV5XhnTuuK01xwA': 'Wingstop',\n",
       " '1SqLPgnZEVeVYDM-AuoFhg': \"Pop's Philly Steaks\",\n",
       " '1Tak6Q-IlkDrdmLwrEZeSg': 'Off the Strip Just Real Food',\n",
       " '1UvrUFk3BXAmueL1KQaKPQ': 'Fiesta Filipina Cuisine',\n",
       " '1V-mRUpVnIRq6GYymT_uyw': \"Braddah's Island Style\",\n",
       " '1VQmZoUwNbNik7EQs_EHeQ': 'Greek Delights',\n",
       " '1Vvxx-9AoINg8TJXOZgEHg': 'YOLOS',\n",
       " '1WBVqmo7tgF0z0eGf4fPhQ': 'Pastaidea',\n",
       " '1WsXLCPRP2EZ9KoBRTkSbw': \"Pt's Gold\",\n",
       " '1XeI5PX5RxvFlaAHBKRUYA': 'Bowl of Heaven',\n",
       " '1Z5S_Lkcl6vA3ZvrAG91TA': 'Sofrito Rico Authentic Puerto Rican Cuisine',\n",
       " '1ZHBhMwi9rdXJ92QPHrWLw': 'Dragon Buffet',\n",
       " '1ZJz840L496LAmQdeDv0WA': 'Pinches Tacos',\n",
       " '1ZhZUzFbbt1gGXDEW3JaBw': \"Griff's\",\n",
       " '1ZnVfS-qP19upP_fwOhZsA': 'Big Wong Restaurant',\n",
       " '1_eNhr53_bTPy11vvVL4Hw': 'El Tinajon Cuban Food',\n",
       " '1aB0kMQNVRhhUXtb7C4Njg': 'Pollos El Dorado',\n",
       " '1aGNx-7cTXIeBCMVM8X0TQ': 'Pizza Hut',\n",
       " '1aMxCG33wAoxjWoeRsl4BA': 'Brioche by Guy Savoy',\n",
       " '1aYKH2ea5_dg0bLznqnvQA': 'LV Taco Catering',\n",
       " '1aj4TG0eFq6NaPBKk6bK7Q': 'Jacques Cafe',\n",
       " '1bALsE6aZE23mGV2WPxN_g': \"Capriotti's Sandwich Shop\",\n",
       " '1diuAK7FMn93WxlK-ndJhA': 'Bowlology',\n",
       " '1fG7Xg4dLzcKIApzJiXtXw': 'Tae Heung Gak',\n",
       " '1g29d62cEojB-7mX7p8AzQ': 'Kanji Steak and Sushi',\n",
       " '1g47zyA_utx8mpgmtLc6tg': 'Teriyaki Madness',\n",
       " '1gU1ZNbcvk0puuUQjbl23w': 'Sushi Factory',\n",
       " '1gjhtfYxlN-0xjS9Xdh66g': 'Jack-In-the-Box #7239',\n",
       " '1h3ysSuSazvXc1aeLiiOew': 'Subway',\n",
       " '1i4iRBkkNU_o_S2pY7W7kQ': 'Panda Express',\n",
       " '1jpYP-JNOEYCMIzP4OlGuQ': \"Braddah's Island Style\",\n",
       " '1kHr1RTkm_J-dfrq-HPBug': 'Viva El Taco',\n",
       " '1mSAHgRm_sbDslTgeId2Mg': 'Taqueria El Buen Pastor',\n",
       " '1nM-ES-xVqL0yQGTCwtd-Q': 'Thai Taste',\n",
       " '1qTx9z8RMz7RIYKAfnpZ0A': \"Lillie's Asian Cuisine\",\n",
       " '1tNVPumjvFErYjvSXbOQ6Q': \"Wendy's\",\n",
       " '1tV2_4oHJTUB9ZFJfOgowA': 'Original Chicken Tender',\n",
       " '1u7fJVL82JEznv76noobVQ': \"McDonald's\",\n",
       " '1uDUisf3ro5V3vC60cxfFw': 'Mr. Cooker',\n",
       " '1vRSIAJ5rlnSabNLMiOXeA': \"Carl's Jr.\",\n",
       " '1ziIZL9P77FrsXS4_NMiDQ': 'Roman McCarthy Meats',\n",
       " '20P1JukOLfR023mnrDeXlw': \"Carl's Jr\",\n",
       " '217u7Wad7y90x4el26-TIw': \"Capriotti's Sandwich Shop\",\n",
       " '21sGRVR7HEs_t6PdB9tGMw': \"Angelina's Pizzeria\",\n",
       " '24wnyPyir6-Bmv6zq7OXHg': 'Viva El Salvador Restaurant & Pupuseria',\n",
       " '25PEf9-e8_7phdV7JjOHhA': 'Baja Fresh Mexican Grill',\n",
       " '25uxgxlqp7sW5F15wguyIA': 'Jack In the Box',\n",
       " '25wTaO0_Rk-GLb4k2uMs0Q': 'AquaKnox',\n",
       " '296PZdxSrtH08EUwCsOKMw': \"Michael's Gourmet Room\",\n",
       " '2B46bRpDh49eDyjXGhL_ZQ': 'La Maison de Maggie',\n",
       " '2B4bC4w4PDC8Pj53SfTG2g': 'Taste - Homestyle Indian Kitchen',\n",
       " '2BHReLgbinzeO7rYuxWZ8Q': \"Dude Where's my Hotdog\",\n",
       " '2DydwQRkIutHarWT_o1L0Q': 'Don Chuy Mexican Grill',\n",
       " '2GzQ1Cc7eDWhKrqNAR1kAA': 'Chipotle Mexican Grill',\n",
       " '2HxaDXZmAOH6LiuzGgNdPA': 'Farmer Boys',\n",
       " '2I_qSTehoUFsDNjaqCVxlA': 'Cafe Moda',\n",
       " '2IvrdAb6zdxr3ZqplqJHbg': 'Jose Cuervo Tequileria',\n",
       " '2K64ON5ifF5fUsfef6egSw': 'El Pollo Mobile',\n",
       " '2LNnIARy-lGmrlEMZSxZ1w': 'Great Buns Bakery',\n",
       " '2LZGeJy8qByYKB71ML-jcw': \"Rock & Rita's\",\n",
       " '2Mp53KxlGeZJkodTuqpVow': 'Project Pie - MGM',\n",
       " '2O1GOiDhvXywzysqAJHkdA': 'Budweiser Brewhouse',\n",
       " '2O_b-IAAW7SoPt__RX1Kww': 'Buca di Beppo',\n",
       " '2PS9kBbuJcmBhcNp-D62uA': \"Mom's Teriyaki\",\n",
       " '2Q9Mgkc7iFHuKoD_z7kJkQ': 'Lokuras',\n",
       " '2QznyHGF0PuiYkrl5RU66A': 'Playa Papagayos',\n",
       " '2RFe9vDTzyBkF4mvsFDDow': \"Dickey's Barbecue Pit\",\n",
       " '2SfSzEd3B7WimeZac23zhg': 'Leon?? Caf??',\n",
       " '2WiMyg8-DoXQ8_R5qFc2iQ': 'Poke Addiction',\n",
       " '2Wl4o7l54I-EtxtaDpOTzA': 'Pub 365',\n",
       " '2Xc6cpbFM6bqKkgz6bV9kQ': 'Rock n Roll Sushi',\n",
       " '2XkVexeY_8zyc9nriSElQg': 'Tacos Tijuana',\n",
       " '2Y0-nrSZNsLRStyupZgM7g': 'Courtyard Cafe',\n",
       " '2Y7voMZLcJ4YYC8_UjEuPg': 'KFC',\n",
       " '2YBO1LEKIgyle0uX50u15Q': 'Noodle Exchange',\n",
       " '2aPbaa0FFbN9AdPtxHqbVg': 'Tables Board Game Spot',\n",
       " '2bK1ng2mnRdtTh_BDNGmIg': 'North End Pizza',\n",
       " '2bSyNMam79SlwiHwQD6RGg': 'Subway',\n",
       " '2dCnTMv3Hh-fM8bOjYS4Xw': 'Nevada Chicken Cafe',\n",
       " '2dUXkonsAdoXKAalTnmlig': 'Dimas Tacos',\n",
       " '2gZDJ-ek2Urm-vA_xBRfkg': 'Walters Louisiana Cajun Barbeque',\n",
       " '2g_auUWw7c3c2CUTgVqI8Q': 'Pho 88',\n",
       " '2hSIeCX2cV-chFcBBXrZZA': 'Pressed For Juice',\n",
       " '2hrj6ISpLJmvRen3AZkBWw': 'Subway',\n",
       " '2hyciWHsqnbqdEkUvO3KuQ': 'Little Crown & Anchor Pub',\n",
       " '2iTsRqUsPGRH1li1WVRvKQ': 'Carson Kitchen',\n",
       " '2iWpS2xe9rBaFAv1CJuz3g': 'Memphis BBQ Cleaning Service',\n",
       " '2ivGlp_mVzwFaPjatAERXg': 'Tacos Mexico',\n",
       " '2k01kgbLdNV9b19GrOqdNA': 'Italian Oasis Pizzeria',\n",
       " '2kWrSFkIes_d2BMg4YrRtA': 'Pizza Hut',\n",
       " '2koVk44qPX7mV8irHO_e3A': 'Filipino Fast Food & Asian Market',\n",
       " '2lPLbTenaBH3SGHgpwM54A': 'Pho Lan',\n",
       " '2lUp2T09MltaVT5awHRElA': 'I. C. China Bistro',\n",
       " '2m4092MsMzEHkuxodaj6-g': 'Ondori Asian Kitchen',\n",
       " '2nEhcvxBZk2W4x_fi0cYxw': \"Roberto's Taco Shop\",\n",
       " '2nraROl3d0-Wr9EPGkW-1A': 'Subway',\n",
       " '2oCM63whZH_IW6kzxciysg': 'Taqueria El Pastorcito 2',\n",
       " '2oSmaFSi0GSDPTOHOKeQHQ': \"P-Dub's BBQ\",\n",
       " '2pTq2dbPsSQwQJWUH5tE-w': 'Taco Bell',\n",
       " '2pcrNqDnsFd6UCelOriVlw': 'Taco Bell',\n",
       " '2reHgsuAWofHfocfJ4Xs5w': \"Song's Family\",\n",
       " '2rvBPUBtQU0WfcOAHLQWRQ': 'Crunch Donut Factory',\n",
       " '2s1JuKtL1jPzM9Tmg13CLA': 'Senor Blues',\n",
       " '2sdU3Fq3Wv2XQycJoJQArg': 'Salo-Salo Grill',\n",
       " '2sjfncn3GNHpKZDAcsm1Uw': 'Mariscos El Tapatio',\n",
       " '2smgOPhpYbDT7G5tbVRdiQ': 'Burger King',\n",
       " '2sx52lDoiEtef7xgPCaoBw': 'VegeNation',\n",
       " '2vr2yGIzSehe_ITFamNpyw': 'Fun Tacos',\n",
       " '2weQS-RnoOBhb1KsHKyoSQ': 'The Buffet',\n",
       " '2wv9ocE3VS2MbBRany2Zyw': 'El Pollo Mobile',\n",
       " '2xCswTbQwG6CVka0U3XayQ': 'Pho Kitchen',\n",
       " '2xbxXWeu3tpZEJdGTTGbLg': 'Fortune Chinese Restaurant',\n",
       " '2zSr7jNNWpA-IfD74wOlTA': \"Pt's Gold\",\n",
       " '2zufEbSI_D8t3WPCgShw-w': 'The Marketplace',\n",
       " '3-dR6RJvTHdkZEHMmB8OeQ': \"Nathan's Famous\",\n",
       " '30TxDt2V8G7FWXsKaEKA9A': \"Marco's Pizza\",\n",
       " '31cOttU_tML5b6eLLXZfsQ': 'Go!ku',\n",
       " '31mm5EtlmT4557BTYAFOrA': 'China Gourmet',\n",
       " '3281FKql3HVOzSVxymjJRg': 'Frijoles & Frescas',\n",
       " '32FTAxYkehRO2lozvGszkQ': 'Subway',\n",
       " '32JWhoH-Kiu1wRFTvHvW9Q': 'Pie Me Over',\n",
       " '32u4chtkG4fIa52396iOhw': \"Papa John's Pizza\",\n",
       " '33Tr0eRki1Yamzleu4GMdw': 'Rosallie',\n",
       " '34PMhyoSQHVd4Lr7slzUcA': \"Ori'Zaba's Scratch Mexican Grill\",\n",
       " '35fWtS1LZkaZ-ooKupJ1XA': 'Buffalo Wild Wings',\n",
       " '364hhL5st0LV16UcBHRJ3A': 'Yonaka Modern Japanese',\n",
       " '36ckWelVitpgX16g7lecqA': 'Canaletto Ristorante Veneto',\n",
       " '38YPE4KCvgChy9y6FcksEQ': 'Pizza Hut',\n",
       " '39BNnMLzx0UUwkWKxGeQKA': 'La Cosina Mexican Restaurant',\n",
       " '39rjgt5MpEACNzyFnUmyaQ': 'Bella Panini',\n",
       " '3A_NZZNHG5dxeZmO-ije2Q': 'Taco Bell',\n",
       " '3BAcvsVdl3-rKk8pzw7ZKw': 'Fish In the Spotlight',\n",
       " '3BCsAgo_1i4xMuTyLKMLRQ': 'SkinnyFATS',\n",
       " '3CxiP8n7DAL-YOOTCW2wNw': 'Jack in the Box',\n",
       " '3F7fYgrubSCzAQrpBRKMgQ': 'Marcos Pizza',\n",
       " '3FlWR_osNPb8dcqLgHebHw': \"Mimi's Cafe\",\n",
       " '3GEEy7RP6e4bT4LAiWFMFQ': 'Pizza Rock',\n",
       " '3GFwQiMc4UB5rMSi4HPy-A': 'Kunchorn Thai Restaurant',\n",
       " '3GfdCuI0YCc5U3rLLLPHUw': 'Izakaya Cocokala',\n",
       " '3Gt3xskppi9jZuTrwrhLNg': 'Stack Restaurant & Bar',\n",
       " '3Gw8YcAjo3AcMbtbX1TGSA': 'Jack In the Box',\n",
       " '3I4I9C5VN3NIkU1K0Mc01w': 'Taqueria El Buen Pastor',\n",
       " '3IwCop28R1_L5jMv6AkL8Q': 'Jalisco Cantina',\n",
       " '3Jq5LfJ5fmJ5KmuA6VHmzw': 'Topgolf',\n",
       " '3L4VPQXH3ni8IsuJLnd74g': \"Marco's Pizza\",\n",
       " '3LQhD2j97GuVIDAciQzX2Q': 'Firehouse Subs',\n",
       " '3LWsVfsSmb_Nzbi2YQ-NIA': 'Delhi Indian Cuisine',\n",
       " '3Nx9NCzMTXC6jFgdk2mDGg': \"Charlie's Market Buffet\",\n",
       " '3PshdJtSwd_poaPL7fIOHg': 'Counter Cuisine',\n",
       " '3QQdF1RT43sVq2YxeE_iHw': 'My Pie Pizza',\n",
       " '3QcTqsdxQBlSndBdMJBRhQ': 'Freedom Beat',\n",
       " '3Qe4M3JNs7yIRXP13g-NYA': 'No Regrets Bar',\n",
       " '3QzPhQ3ltbon0-1gC7Q18Q': 'Beer Garden',\n",
       " '3TRgD3KLVis61eGvMZrykA': 'SK Seafood Restaurant ???¨¨',\n",
       " '3WRvQJS9GIBubGxbHMzX2g': 'Chipotle Mexican Grill',\n",
       " '3X-SMnyYq77IYEnyCp-TtQ': 'Tropical Breeze Cafe',\n",
       " '3X_u-2o1c-8ERcp7TIE3Cw': 'Villa Italian Kitchen',\n",
       " '3YV-GLtQLI3sbZDZ-0NN4Q': \"Capriotti's Sandwich Shop\",\n",
       " '3ZHyw0d8mk0HOEP7v4fW1A': 'Krung Thai Restaurant',\n",
       " '3ajqOW9A7VhResA08I7RTg': 'Hash House A Go Go',\n",
       " '3c6U5CdxsN_6Gpc6dqTylg': 'Chicken Connection',\n",
       " '3cHL1r5w2oLYH-veijtweA': 'Public House',\n",
       " '3cg4pKBL8DTFXCtZ5y9V4g': 'Johnny Smalls',\n",
       " '3dC3opMY67zrquz_yYc-tw': \"Pepe's Tacos\",\n",
       " '3fPIRTnBhd81MixgS9YoMQ': 'California Pizza Kitchen',\n",
       " '3fT1kcQ-MVEImGHa3hll5w': 'Earl of Sandwich',\n",
       " '3h5jLa-kbHg0cL7v9En0Lg': 'Firelight Buffet',\n",
       " '3j_mvJHnT7nJd7su_7zazw': 'Ginseng 3',\n",
       " '3kdSl5mo9dWC4clrQjEDGg': 'Egg & I',\n",
       " '3lRFcrfR3IrSAQJtrnn80A': 'El Salvador 503',\n",
       " '3mpBYH3k_lfzycajGtkggQ': 'Sandwich Carvery 108',\n",
       " '3nWXxSCR6q7SVxHvsUUeWg': 'Flavor Bomb LV',\n",
       " '3nf-a84p8LC41_WAIvJPjg': \"Grimaldi's Pizzeria\",\n",
       " '3p0SYIaMbJ8j-yeK_do5Qg': 'Longhorn Hotel & Casino',\n",
       " '3p7mUvZtYocYf8gYEENGxw': \"Simon & Joe's Eatery\",\n",
       " '3pGA9YGsDLRQ7HJLw5cwcQ': 'Yunnan Tasty Garden',\n",
       " '3pSUr_cdrphurO6m1HMP9A': 'J Karaoke Bar',\n",
       " '3qIFv-MbDoj-gDigpo_FgA': \"John Mull's Meats & Road Kill Grill II\",\n",
       " '3rj1qpgFvkRWtAka17mhEQ': \"Mimi's Cafe\",\n",
       " '3sPSc8NBvrkXi7scpRYDLg': 'Hello Tokyo',\n",
       " '3sXlZWM9B72_r-dYBIgmyg': \"McDonald's\",\n",
       " '3uC7Lbc3RgUDTWQlBu4PqQ': 'Bouchon Bakery at the Venetian Theater',\n",
       " '3vxIqhm2jCVjkUWtmDvTsw': \"Raising Cane's\",\n",
       " '3weo8OctYcKoS_AV9OrOgw': 'Juice NV',\n",
       " '3yJD0xcRuhZA8Bl1liUr_A': 'The Flying Pig',\n",
       " '3yhdmUXeZS5j9xZRcuIv0g': \"Papa John's Pizza\",\n",
       " '409qhf4RF0rlxcuaM576Qg': 'El Pollo Loco',\n",
       " '41Kbugm-qmIQTt7unkALYQ': \"Top of Binion's Steakhouse\",\n",
       " '41WfL6MGTAXYgRQfNT3dyA': 'El Pollo Loco',\n",
       " '41b2SLmjLcxTGLVRxASiDA': 'Country Club',\n",
       " '42yLya7lhe7TQGz3KEdKAw': '#1 Hawaiian Barbecue',\n",
       " '44kd3YdkhXj5XiSPs5XNjQ': 'FireRock Steakhouse',\n",
       " '44xBONbuMSghULXXEnl-Lw': 'L & L Hawaiian BBQ',\n",
       " '45513UgSlMqWV_yAPVkXrg': 'Verona Pizza',\n",
       " '45Rl4Lmi1ijnxag0Ua0-Mw': 'Great Steak',\n",
       " '46UHF46E1z-W2dOmhv-Fng': \"Pt's Pub\",\n",
       " '46ud6EO8tIlgnLnhLN2Tvg': 'Southern Style Eatery',\n",
       " '499ugPqwBhr-EQYnCuFC0A': 'Thai Noodles Cafe',\n",
       " '4Azs1HUqi0Nk6s6xB_9jsQ': 'Shizen Japanese Restaurant',\n",
       " '4Bw9XffSa0AMy2SrNCS2KA': 'Sababa Mediterranean Grill',\n",
       " '4E309lwPu65lXyaeuLRETQ': \"Boomer's Bar\",\n",
       " '4EfiNcKSsafogIhAjwv0gg': 'Rustica Pizzeria',\n",
       " '4FC_tTgynakPLLngLkvRSw': 'Johnny Rockets',\n",
       " '4FaRTjXXFdfs1Nn29V9kAg': 'KoKoRo Ramen',\n",
       " '4GXII-GU7S0ZyU6ElkhscQ': 'Hooters Casino Hotel Las Vegas',\n",
       " '4Hx-brYb86k4C1VSKPvj7g': 'Crazy Pita Rotisserie & Grill',\n",
       " '4I4OoW0tbaoG4I4D2spF3w': 'Del Taco',\n",
       " '4JNXUYY8wbaaDmk3BPzlWw': 'Mon Ami Gabi',\n",
       " '4JkGjRRc3XucG9U8XwthGg': 'China Gourmet',\n",
       " '4KmrrhtfnngTVFa2d5LAjg': 'Allegro',\n",
       " '4L3VJwVqUareUUIGPE2zcw': 'Shalimar Restaurant',\n",
       " '4LhURdgGRofYSR_1LBTXvQ': \"Amber's Smoked Vegan\",\n",
       " '4Nj2ktP2NjCbv2aKeH3ZBg': 'Vesta Coffee Roasters',\n",
       " '4NxIM5xpIEem1IkEkz2I7Q': 'La Cabana',\n",
       " '4Odbtgh9g8XUKorRg7MTHg': 'Italian American Club Restaurant',\n",
       " '4OeBE57Hs4WMLOTtT32d1Q': \"Bubba D's BBQ\",\n",
       " '4Pb7SlTK89uSdqOwMNM35A': 'Tequila Taqueria',\n",
       " '4Pl-ziYL2oerGyIPlwVdmA': 'Chuchote Thai Bistro & Desserts',\n",
       " '4QmwJBk9VPKyO2DfUeIVWg': \"Tommy Rocker's Mojave Beach Bar & Grill\",\n",
       " '4UmjnX46qbhV6-D5W89IOQ': 'Taco Bell',\n",
       " '4UvQ0BUbqlNPJbAggsi0eA': 'Delightful Chefs',\n",
       " '4VXIS8vpNzEysXZVN5xGDA': 'Las Americas',\n",
       " '4V_EncSagOpI_0IuS7vURw': \"Long John Silver's\",\n",
       " '4VjrVv-PBuG-al5JnUUIGg': 'Tacoman Catering',\n",
       " '4VkLiFoIEjTTpbCRgxjnCQ': 'Spaghetty Western',\n",
       " '4Wou6LarHqefHP21qRu0Ag': 'Tropical Smoothie',\n",
       " '4X0KWUPcD2EkHN83aa4cXg': 'Blondies Sports Bar & Grill',\n",
       " '4ZB0RpAhXl9zhjKYRxpJgw': 'Alternative Junkie',\n",
       " '4ZbRwCB9oGibxK21MUZKHA': \"Smith's\",\n",
       " '4aAf2nAr86lcDHzqWSaYuQ': \"Alexander's Pizza\",\n",
       " '4bqbAhYZQeokD3zqN77XLA': 'Nestle Toll House Cafe by Chip',\n",
       " '4cDWyZa6EqsY4XSWwLY7RA': 'Go Raw Cafe',\n",
       " '4d9BIUYJwAsMfMrH_0vdDQ': 'TGI Fridays',\n",
       " '4eiQMRAP1eDWNK1QMpzT5w': 'Chickpeas Mediterranean Caf??',\n",
       " '4fGGeKlUY3SwqLW4SH_QnQ': 'Cafe Lola',\n",
       " '4hG2j_ibsNblDgqei05U_g': 'Social House',\n",
       " '4iLbq_AUiWtsSKHFpG5cbQ': 'Food Factory',\n",
       " '4k3RlMAMd46DZ_JyZU0lMg': 'Ramen Sora',\n",
       " '4khsN1eXcWR0YYmROlLEzw': 'SkyJump Las Vegas',\n",
       " '4klmo_xFoMHjPR-HgdFDgQ': 'Sushi Avenue & Steak House',\n",
       " '4l1cmNrXBOLVUJR29MDp3A': 'Subway',\n",
       " '4lAwPgy1m9Rd0oBpi4Hr2w': \"McDonald's\",\n",
       " '4lKF-M_3OLsk1usLPDJEFA': 'Einstein Bros Bagels',\n",
       " '4mYPOzBokDgz307TW2EIKw': 'Crafted Buffet',\n",
       " '4mb32UmQULqg7IMck28vog': 'Pinches Tacos',\n",
       " '4oC1z2SDrpraoZzRIQ-WsA': \"McDonald's\",\n",
       " '4oJeSkScjPxuDC_LeK3KiQ': \"Hennessey's Las Vegas\",\n",
       " '4oeqftAA2w9rcffOFaxFLA': 'El Rey De La Pi?¡ÀAta',\n",
       " '4pxK5njPxYHFp7IMEch1Bw': \"Wendy's\",\n",
       " '4qG3Gh8QyugC1XvoTlmgcQ': 'Egg Works',\n",
       " '4qTeGqt6YpufGxZXJ_FldQ': 'LavAzza',\n",
       " '4s_kb5VXnx96fEJLZ_AkIQ': \"McDonald's\",\n",
       " '4srfPk1s8nlm1YusyDUbjg': 'Subway',\n",
       " '4tWF2w6jP2LNK2xTVNEMFw': \"Garduno's of Mexico\",\n",
       " '4tiFtmGNFcvKRSPXPVT8Hw': 'Mercadito',\n",
       " '4uISbaUPJLVECBHIi3tpxA': 'Wazuzu',\n",
       " '4uMs5UbtIAaHhuKQlQhXEQ': 'Chicken Now',\n",
       " '4ugJ4F8jDJ9-2dEiZ47wLg': 'Hachi',\n",
       " '4uiijOUDzc-DeIb2XcKW_A': 'Khotan',\n",
       " '4v5ZLpmNn13Mze1w_XfWHw': 'Harley-Davidson Las Vegas Cafe',\n",
       " '4v9nhZ5h-KScIsG7uXjfzg': \"McDonald's\",\n",
       " '4vm2W7J_ztH0vcX4bKfuXw': 'Sin Fronteras Tacos',\n",
       " '4w3Niht34LptK7pyp94myQ': 'Firehouse Subs',\n",
       " '4xioa5IWUTYEepxCiqRMtw': \"McDonald's\",\n",
       " '4yAvytbVKHqSYAo3mkI9OA': 'Pro Kabob Persian Restaurant',\n",
       " '4yJVSK-Q5UkED6RjORRssA': 'El Congo Restaurant',\n",
       " '522GgMvOvzaKCEX6BfAtvg': 'La Reyna Mexican Restaurant & Mariscos',\n",
       " '52p6b51oPNIwWBXuvIao1A': 'Dem Noles Bois',\n",
       " '54LYVM1gCGQ2UVFK9QhgTw': 'The Flame Broiler',\n",
       " '54WM5coZonA0izd2y04p_A': \"Famous Dave's Barbeque\",\n",
       " '55FnSahXfQoiueQjrKC86w': 'Bellagio Patisserie',\n",
       " '56Ll9rqG2WxXj4X2pmlkHQ': 'Sweet Tomatoes',\n",
       " '56Yb9IgEREFeaSjJ5Y3RVg': \"Huffman's Homemade Chicken\",\n",
       " '59YbAeuiz0isJtRNKATTKw': 'Bacon Bar',\n",
       " '5A9XLq-oNiua4fVrsRCaXg': 'Panda Express',\n",
       " '5CJL_2-XwCGBmOav4mFdYg': 'Krung Siam Thai',\n",
       " '5CJOaZc8Muu8WothauxQ4g': 'Pizza Forte',\n",
       " '5D3cAYturwbEqnj52b1Tmw': \"PT's\",\n",
       " '5DH-yIBIvlpQopUk7HcTcg': 'Panera Bread',\n",
       " '5Dccw539NNtnyCgTu5ed5A': 'Thai House',\n",
       " '5EgDTPJNZsmbMG52ixnMXA': 'Samdae Korean BBQ',\n",
       " '5EicViODfX1qNOIhdb4OzA': 'Umezono Sushi and Japanese Grill',\n",
       " '5FiuxRWs-indyk2Y9imkSg': 'Chopstix',\n",
       " '5G4Tg_hBfUGilQWj2lj8IA': 'Port of Subs',\n",
       " '5JNvfPfd6mcpwNoekzqBow': 'H2O Sushi & Izakaya',\n",
       " '5JjGTaZkHbbjBrzBODcsAQ': 'Daisho Sushi',\n",
       " '5K5Fppbmvsw9znotxVOXng': 'Taco Bell',\n",
       " '5Lcit9Zt6TF9bmKoFMhF0g': 'Noodle Pot',\n",
       " '5MlgZwfmaegOL7_FJ3b7lA': \"Papa Murphy's\",\n",
       " '5MnLa1nE606cvNGlSFt01Q': \"Ben's BBQ & Smokehouse\",\n",
       " '5Mp-PD_CUaPoJr6CP-WBdA': \"Rubio's\",\n",
       " '5MzGPxcrSPoWQc_bRmOXoQ': 'Kopper Keg Lounge',\n",
       " '5O7qB4gNmr3NgdYAuYbP4Q': 'Indian Curry House',\n",
       " '5OLtY1-xR6LjeH3kJGJ5UA': 'Scentz N Sudz',\n",
       " '5OqrwhtZ3mcmUSwLINZTWQ': 'Blossom',\n",
       " '5PP6BwtNYlPARHApB9lzcQ': 'Blue Ox Tavern',\n",
       " '5QNXZcclknB2PkfeN7FJWQ': 'The Hush Puppy',\n",
       " '5QsW4RdCrDhVuDHnlgnCuA': 'Carefree Catering',\n",
       " '5RQ6ENVWSmgmzFxmUGWQ9Q': '21 Restaurant & Lounge',\n",
       " '5RTL-ZQ8LS6gN3TLpJmDkg': 'Nayar Sonora Taqueria Mexican Food',\n",
       " '5SZe-u0hyquuipQL5lbg_g': 'Yatai Japanese Grill & Pub',\n",
       " '5T0h9YCsXiDZyBsVIN9gcg': 'Viet Bistro',\n",
       " '5TY-YMiAXgBjmP_y4AiXhg': \"Capriotti's Sandwich Shop\",\n",
       " '5TY6bUT3bbl9aHItiIXXqw': \"Big Al's Oyster Bar\",\n",
       " '5TeA1dyLR7MIor-DfIrYog': 'Cherry Berries',\n",
       " '5UvAxXy6BBgyuxv0B3ztjA': '888 Noodle Bar',\n",
       " '5VXlHFrYZZzj7zfZEsz5nQ': 'Dragon Noodle Co.',\n",
       " '5VeKrLlQdJjMmKGwBBvMmw': \"Yanni's Gyros\",\n",
       " '5WKtODFwnoKA_y9H-HubFg': 'Tropical Smoothie Cafe',\n",
       " '5WOE18ldtQ1U0MK5fN2HGQ': \"Rubio's Coastal Grill\",\n",
       " '5WjFHat0vyx0OYtGbTpyag': 'Pacific Island Taste',\n",
       " '5XORYO9raiXVZSGGPvjSmA': 'Kopper Keg North',\n",
       " '5XqlvHsByE4GFgTZtZDXgQ': 'Indian Bowl Cuisine',\n",
       " '5Zc41a446gV3K_o7CDs69Q': 'Riviera Hotel & Casino',\n",
       " '5ZyF-uAb4RVN05THprS3IQ': 'Tropical Smoothie Cafe',\n",
       " '5_MrPFw9E0cMJ1Q0DJFZOQ': 'Tilted Kilt Pub & Eatery',\n",
       " '5aeR9KcboZmhDZlFscnYRA': 'Fresh Mama',\n",
       " '5eDg_Y2N6aU_k7tIxoFXTg': 'Armaan Taste of India',\n",
       " '5exz18duMXvg91ZPdNX3eA': 'Blue Ribbon Fried Chicken - Grand Bazaar',\n",
       " '5fSz08wFcBhCeCXh7sxG5A': 'Runway Cafe',\n",
       " '5fWcM1vRg4v8HI85Vmy8OA': \"Jimmy John's\",\n",
       " '5fpXjlC71y_mKORnPdX5zA': \"Roberto's Taco Shop\",\n",
       " '5gZ4k_mdDOcEmCG4wHVH-g': 'Rhodes Ranch Club House Restaurant',\n",
       " '5gv6AqHXfi3gJV4fb432Vw': 'Little Italy Pizza',\n",
       " '5i5sLQPOkBAE5CoimgiK1g': 'Painted Desert Golf Club',\n",
       " '5iAFiMPfitcYDMeII5_dnQ': \"Auntie Anne's\",\n",
       " '5iHctUjkQTGwEvOaBkwMRQ': 'Espression Cafe',\n",
       " '5iSlHNIy3RLbCP5AayB31g': 'Ruby Tuesday',\n",
       " '5ic8m9PNixMA__h0G4WH5w': 'Southern Hills Cafe',\n",
       " '5id6Wu6n07N2lIklMAorEw': 'McDonalds',\n",
       " '5j7BnXXvlS69uLVHrY9Upw': 'El Pollo Loco',\n",
       " '5jTmjxb1X34EfcY1gos4tw': 'Fatburger',\n",
       " '5k8kyvvReTf1RMq4jpayQg': 'Cafe Luhena',\n",
       " '5keoVVM81g-nJw0Zdpl1nA': 'Evel Pie',\n",
       " '5l-yKN13VwfPwuSiBIqdJQ': 'Farmer Boys',\n",
       " '5ma1OUQWy_Ds80xUiP7JPQ': 'Fuku Burger Chinatown',\n",
       " '5mair616AhJMpRjbd5z94g': 'Subway',\n",
       " '5n2dA_QqO4c_7pSK0Of6AQ': 'Fatburger',\n",
       " '5o7Fx7Iot-gLKVNegLLw-w': 'El Santaneco',\n",
       " '5pxRAyPz1PrW2amW7yYaxA': 'Chronic Tacos',\n",
       " '5qG4UHurI1yEozwn25WAFw': 'BLACKOUT Dining in the Dark',\n",
       " '5qK5rJxwo0cjP3vTf3lkSA': 'Little Caesars Pizza',\n",
       " '5rPcuMOjSbKPuYzVLsstQQ': \"Papa John's Pizza\",\n",
       " '5shgJB7a-2_gdnzc0gsOtg': 'Firefly',\n",
       " '5t9kTG9DakuamJgY65HA7w': 'La Casona Bar & Grill',\n",
       " '5tTKSogU3fWO7TlnYrffbA': 'Wienerschnitzel',\n",
       " '5tl4tyaJEzGeAdbi_L7PzQ': 'El Pollo Mobile',\n",
       " '5tzNOeow197qn-a0tUJdVA': 'Curbside Cafe',\n",
       " '5uk8eUTiRS_Y5p_EjnrfkQ': \"Bonanno's New York Pizzeria\",\n",
       " '5uvX6yqie9DpHR7UAiQZtw': \"McDonald's\",\n",
       " '5xX1Eb4fBoUr53OJkgRHRQ': \"Sofia's Pizza\",\n",
       " '5xYk23lz0ktdMvzHtohymQ': 'Village Pub & Poker',\n",
       " '5xdKUuu4DbJ71KGbwRXfFg': 'Ramen KoBo',\n",
       " '5yZ1XmDcOEsElDeb9PlPDQ': 'Yagyu Ramen',\n",
       " '5z1WIr7E9P2CSzyN5seeSA': 'Sterling Brunch',\n",
       " '6-gRHn1n11ATqWBrFTLnNA': 'Great American  Pub',\n",
       " '6-lmL3sC-axuh8y1SPSiqg': \"Roberto's Taco Shop\",\n",
       " '60YMDriyoqeimFOjHXCUoQ': 'Loose Caboose Flamingo',\n",
       " '60uVlCUiLJvq3xNo_3bhQQ': \"Carmine's Pizza Kitchen\",\n",
       " '61pecmfztHO2SLs-WRkwVg': 'Pho Hung Restaurant',\n",
       " '61qDFkNrHKzyA9n3dlgcEw': 'The Carmel Room',\n",
       " '63Qj5E-GzHJ6vhjhGR4XDw': 'Ringer Wings, Pizza & Sliders',\n",
       " '64o_nYvzIKwHFOSYSEm-qw': \"Joe's New York Pizza\",\n",
       " '65eDIQ8bpMJFtgdyX7ulVA': 'Yassou Greek Grill Cafe',\n",
       " '66jwLkSd6M0cZulZrA3zcw': \"Applebee's Grill + Bar\",\n",
       " '679eSYC15Sc17TN9Djj8sg': 'I Love Burgers',\n",
       " '68jn0s0snbO5dhasLaVvDw': 'Flock & Fowl',\n",
       " '698nukvxe7mq2Fra5vDikQ': 'Rise & Shine a Steak & Egg Place',\n",
       " '69SHzcXpZCuLwCG1X4l4_Q': 'Fountains Brunch',\n",
       " '6ANVuBMmpkXpFd5Hzkn4_Q': 'Red 8',\n",
       " '6Ege_N9uJ-rtKIs1TNA8aQ': 'Jack in the Box',\n",
       " '6GlGdRX8JaG9alaqZAOaTQ': \"Arby's\",\n",
       " '6H8xfhoZ2IGa3eNiY5FqLA': 'Trattoria Nakamura-Ya',\n",
       " '6HdzmAatFoB8UDep4n9QIw': 'IHOP',\n",
       " '6JVaLv8KvOgK24RB7pxUiw': 'Sunset Grill',\n",
       " '6LkNSA3b3dufG5_dKfEQdQ': 'Southern Kitchen',\n",
       " '6MpOzb5ImLdDXHsn4HwI-Q': 'Embers',\n",
       " '6Na0jTJjX5GQY_ZJ53G02A': 'Verrazano Pizza',\n",
       " '6OftN85zwsd_PRxSYhgQCQ': 'Burger King',\n",
       " '6OjAOpupZOllj6mzLomVuQ': 'Panda Express',\n",
       " '6Or07nY9iiSSJf-Kaf0GMw': \"Adi's Active Nutrition\",\n",
       " '6PqYwabO2g1r2ZB7eImOiw': 'Olive Garden Italian Restaurant',\n",
       " '6QUuDlLjNDQWFCbJ9--jsQ': 'F?? Asian Kitchen',\n",
       " '6TQ0gCdAqaBbuDyCGa0joA': 'Masso Osteria',\n",
       " '6TSpAuUdmo2UEn9emgd8xg': 'Simply Pure by Chef Stacey Dougan',\n",
       " '6Tq13q3Ib17gSgP0zki3EA': 'Las Gorditas',\n",
       " '6TvB1PZCY1Ap2S-yNJPs4w': 'Hooters',\n",
       " '6UI3dCIY6eM1eBOsnEVBuw': 'The Perq',\n",
       " '6UqOXFic_vu2JLGuu8YD6A': 'Cheers Bar & Grill',\n",
       " '6V_7ldr9tjmet0BdAnC34A': 'Tournament of Kings',\n",
       " '6Ve_2kEz18dvhp4q3M5I2Q': 'El Pollo Mobile',\n",
       " '6Vyp-9i1jzwK_bvisuPJpQ': 'Lobster ME',\n",
       " '6W3hdaCjx_n1kADEuORduA': 'Bonnie Springs Restaurant',\n",
       " '6WE1SLCq_gUzJGQpglYM9A': 'Pizza Hut',\n",
       " '6WRVv6S1IWR0nt4Lr2w7Og': 'China A Gogo',\n",
       " '6WWXpMwIB7gTc4yZrkM-fQ': 'Hot Dog On A Stick',\n",
       " '6Z6IyosSMciZtwk8hRLRag': 'China Mama Restaurant',\n",
       " '6_KCUxu2kOgP-pRnSNXG8Q': 'Food Express',\n",
       " '6a3n4Hd0niHndoPywSkb7Q': 'Red Ribbon Bakeshop',\n",
       " '6bU4NFkXbdbvnQBDa9-nfQ': 'Fiesta Filipina Cuisine',\n",
       " '6bVEM9jD-mpU4WNXcJ9tHA': 'New York Pizza Ribs & Wings',\n",
       " '6bYgKI5JaQmS2xDoofS6cQ': 'USS Fish N Chips',\n",
       " '6beJGNWviNq_VbODEULexA': 'Cafe325',\n",
       " '6bgjcFOy4WHMyw62_1V9Pw': 'Panera Bread',\n",
       " '6cYgq6_kSOa2SgXrjyaLZg': 'Popeyes Louisiana Kitchen',\n",
       " '6e0Abng1LRexKI4LRJTX_A': 'Algobertos',\n",
       " '6fKmO2gzGQhzM791H6b4mQ': \"Domino's Pizza\",\n",
       " '6fPQJq4f_yiq1NHn0fd11Q': 'La Creperie',\n",
       " '6fz0hnNIVpLF5v2NqJfA9w': 'Babystacks Cafe',\n",
       " '6gxlDhmZ80bhflm2A-U0KQ': 'Burger King',\n",
       " '6hsXF2bRmrstSmwuHwI-kw': 'Siam Garden',\n",
       " '6jDD-Z8QcsKTdIDWwM8gog': \"Anna Marie's Italian Cuisine\",\n",
       " '6l4yIOi0foUw81OacrAZMQ': 'Port of Subs',\n",
       " '6llKs7K_tn8ChXcIM-oTvg': 'Sansei Japan',\n",
       " '6nPyQJp7xmc1cvYaolwn8Q': 'Subway',\n",
       " '6nbPXEjmBnDtsgM_YNwGjw': 'Island Flavor',\n",
       " '6oLnLmdo9FhuAeR-vLQ4tg': 'Xtreme Sushi',\n",
       " '6qKjl6xJQzLb9ka-QbTudA': 'Las Cazuelas',\n",
       " '6qP6R78nlAGSahx78DayHQ': 'Taco Bell',\n",
       " '6r8YOdxoNYfkEfqxl-nO1A': 'Subway',\n",
       " '6s7uduX1Q1KSjOKvwxYkRA': 'Koji Sushi Bar and China Bistro',\n",
       " '6tCMxC7Etf--WYEd-EiprA': 'Tostadas & Tacos',\n",
       " '6tSvz_21BMo3a4GaItwa0g': 'Jjanga Japanese Restaurant',\n",
       " '6uV3KMOo8YQofuNUs4D9pA': \"Heidi's Brooklyn Deli\",\n",
       " '6u_6RV0qDaTQyYqZTzl3XA': 'Wingstop',\n",
       " '6xL0DuOl6PkkzyaJTCPtAw': \"Steak 'n Shake\",\n",
       " '6xgcHeLad-VaoTIQewK84A': 'N9NE Steakhouse',\n",
       " '6z3cgIE9dJ01wUm43f0yBQ': 'Fat Dumpling',\n",
       " '6z4fp-8YDR1Zh5Y0Ubni8g': 'Pinoy Market',\n",
       " '7-Ba9uSmYYpXgnQRoIPxMQ': 'Havana Grill',\n",
       " '71bwX-tbmq4su8H7Q9oLOQ': \"Pt's Gold\",\n",
       " '73oP6zoYZKNlO8642EMD_Q': 'Chip Off The Block Deli',\n",
       " '73wAdIyaeTh6DuZCe-CpSg': 'Kabob Kitchen',\n",
       " '742D-FQL6glg1ek71G4R2w': 'Philadelphia Steak & Hoagie',\n",
       " '74C1z6cqEdvJVgETTcEodw': 'Portofino by Chef Michael LaPlaca',\n",
       " '74pWjFssgqyhaVg-YCUo3A': 'The Cracked Egg',\n",
       " '750iLCqKvDnIWzRSRSUlrg': \"Bob's East Side Deli\",\n",
       " '77AfVfvvjfQXslusY8QElg': 'La Jolla',\n",
       " '77KuSFMOXqRGqcV9NJjzDA': 'Dirty South',\n",
       " '77h11eWv6HKJAgojLx8G4w': 'Eggslut',\n",
       " '78TC3sZSYBzBsSJ0z5pyhw': 'Le Provencal',\n",
       " '78XbdLi5e42XDxgnxuYacg': 'Ohjah Japanese Steakhouse Sushi & Hibachi Flamingo',\n",
       " '78hGCrQ6wLA2yh8zMywnmw': \"Wahoo's Fish Tacos\",\n",
       " '7BK6vckOh2Ywq8ryy8P7Ow': 'Rumbi Island Grill',\n",
       " '7BZ2NdkysVLgWScSEvhILQ': 'chow.',\n",
       " '7EZ4Eu7YJ1ltRCC5jXFJrQ': 'The Buffet At TI',\n",
       " '7FLHJMOYszFPCqK3tg5umA': 'Sakun Thai',\n",
       " '7GGJlp1aWfcXGQz6q7SkXQ': 'The Rockhouse',\n",
       " '7GfA5WMSRd-JCaPxnwgIQw': 'Panda Express',\n",
       " '7IkSGKKiWhfkXQBCT8EOgA': 'Brentwood Cafe & Tavern',\n",
       " '7KkgMcbVaetryW1wwpzvvA': 'Cafe Rio',\n",
       " '7NucoWCjPzZyRPjsVR28xQ': \"Bonanno's New York Pizzeria\",\n",
       " '7NvIgf7XW55OKa5ZU7gw8Q': 'Arandas Taqueria',\n",
       " '7P3Z4HTUM8M8Y9Yw3cc7Pg': 'Tipsy Coffee House',\n",
       " '7PTQ-a8Fu4kxXccFvWWT-Q': \"Papa John's Pizza\",\n",
       " '7Ppgpgva-HP3o3h-xp2sWw': \"McDonald's\",\n",
       " '7PtKr_0IX3bLbTbIT6_HrA': 'LMJ Cafe',\n",
       " '7RidnmyYyH0cfcX2x7buag': 'Siena Bistro',\n",
       " '7SLZwNRhc2bpUXQXLypTTg': 'Burger King',\n",
       " '7T7IaK6WGQccQS0UjJmmmQ': \"Big Ern's BBQ\",\n",
       " '7UFDAX4wLi6ux5otguYldA': 'Andiron Steak & Sea',\n",
       " '7UtqNjjd9D6oU7UcT2nxig': \"Capriotti's Sandwich Shop\",\n",
       " '7VWtmHsd4HSNDkF5f5xnng': 'Burger King',\n",
       " '7WHAdFHiHLmNJN72M_AKYQ': 'Dumpling And Noodle House',\n",
       " '7Wr0piSMGiq5qy5opiLNrA': 'Cabana Grill',\n",
       " '7Xw_vv-ekUL2sTqipnKT0g': 'Buffalo Wild Wings',\n",
       " '7_F6dA9xh2lydTtr1LCtIQ': 'Jack In the Box',\n",
       " '7dHYudt6OOIjiaxkSvv3lQ': 'In-N-Out Burger',\n",
       " '7fxebHYUwIF6CakxSr70iQ': 'Carnevino',\n",
       " '7gdpCYPKkQqfiWDoTQnHgQ': 'Sakura Japanese Cuisine',\n",
       " '7gjYJ6leqm2IMJXNpKvIlw': \"Capriotti's Sandwich Shop\",\n",
       " '7hXWFtmoJHz63SD8k56a_Q': \"Putter's Bar & Grill\",\n",
       " '7ibuDLfx8gEhESAufYIySw': 'Sushi Mon',\n",
       " '7iuruLs-q-_RW06IbsBxZw': 'Arirang Korean BBQ',\n",
       " '7kXrUSjG67NitjRfRFn9cw': \"McDonald's\",\n",
       " '7nOip4YnRTvW8tgiJRQ7Eg': 'Habanero Grill',\n",
       " '7nPrP_cikNWYz297F4EYRw': 'Big Horn Cafe',\n",
       " '7nRlDLrob6oK5zmGo4Vpbg': 'Blueberry Hill Family Restaurant ',\n",
       " '7njZaRjDXi8anBaGlGQu4g': 'The Lodge Cactus',\n",
       " '7phGRr7Z36IrET7zDKD3Pg': \"Tony's Mexican Food\",\n",
       " '7qFtiPg0gdbk911_mj6LoA': 'The Broiler',\n",
       " '7re6iyJY2v4Zb3x3hJnkaA': 'Cadillac To Go',\n",
       " '7sGcBZwkD4yFLiBLS1WKgA': 'Presto Cafe',\n",
       " '7sPNbCx7vGAaH7SbNPZ6oA': 'Bachi Burger',\n",
       " '7sb2FYLS2sejZKxRYF9mtg': 'Sakana',\n",
       " '7tqDSf2wJ1BrLDSfhhJitA': 'Islandtucky Fried Chicken',\n",
       " '7usumJrTK_qs2GbSd8zIvg': 'Wake Up Coffee Cafe',\n",
       " '7vHvQCjPq5pWj7Rio1A--w': 'Blue Fin Sushi & Roll',\n",
       " '7vWb1Afpm2arr8NCaE_EyQ': 'Ogden Mart',\n",
       " '7vXmhdqO6aAoZGEVyusk0w': 'Taco Rico Los 3 Gallos',\n",
       " '7w9GpK5BJZY94sbfK__oDw': \"Mo's Pizzeria\",\n",
       " '7w9UhH7Hz14N736FAe5_Fg': \"Long John Silver's\",\n",
       " '7wHLFohwCw8l6WS-feLjeg': 'Other Mama',\n",
       " '7wMCJ9NqL9eBEX4WdJWuIA': 'Outback Steakhouse',\n",
       " '7xEgy2btCKLdTe1vD14ABw': 'Johnny Rockets',\n",
       " '7xXaO9deBDh_dd0JQjA-Qg': 'Claim Jumper',\n",
       " '7yYexN1Q5ShE_z1MH2TDTw': \"Sammy's LA Pastrami & Burgers\",\n",
       " '7yntwIUh2ZEkWGe9Zth7tw': 'Port of Subs',\n",
       " '7zMwR4FkvTbSGY0vRT5Ljg': 'Angry Blasian',\n",
       " '8-8btzuYZCqEVOPwk0YYfA': 'Gen Korean BBQ House',\n",
       " '80Lkm305ZOkQdMEIvOy_lw': 'TAP Sports Bar',\n",
       " '816UOVoEQM6yLiWBD7PDNQ': 'El Canelo Restaurant',\n",
       " '81WMGpA8CVYlPhuhZatkXw': 'Aria Patisserie',\n",
       " '82-wE5pkxyBKhfxyyZap_A': 'Cafe Modena',\n",
       " '82AEJCAi_-mzOcJmy_XTew': 'Cafe Verdi Henderson',\n",
       " '82YGtjc5KKikNiqBZ33qzw': 'Kyara Japanese Tapas',\n",
       " '82g1PwX5FvclqqdjJHcVNA': 'Bomb Tacos',\n",
       " '82kehL5xSvGbLYTmF_f2Vg': \"Crepes N' Tacos Mexican Grill\",\n",
       " '83C5ysOCnmNGB_fDsVdr9Q': 'Brothers Italian Bistro',\n",
       " '84DjKzaR26vphu9fNI9nKg': 'Sierra Gold',\n",
       " '85gYSNxRpFIbQ3JVcudsVw': 'Pizza Hut',\n",
       " '86stmK3Vm2f5W6PdyvuLrQ': \"Applebee's Neighborhood Grill & Bar\",\n",
       " '86wtLylJ9fbVuXRy5WU3Zw': 'Vegan Bites',\n",
       " '86xm0Q8iX5ZjODWMkvwnxA': 'Popeyes Louisiana Kitchen',\n",
       " '88vF_9_X9dJwZ7w-hwtMow': 'Lucky Streak at LAS',\n",
       " '893VryJbZcCm5V9xon_aLA': 'Those Guys Pies',\n",
       " '89N08SxuIHyD3A1iuU5i3Q': 'Sin City Soul Deli Caribbean BBQ',\n",
       " '8EU78DspV7ORFRXr9BPxuA': 'Chicago Cravings',\n",
       " '8F-UdXe_YylX3k0L1SEiRg': 'Pho Little Saigon',\n",
       " '8FUzCm4Q13MJMX7N6ftmQw': 'China Hot Wok',\n",
       " '8GOle3PqqZnni4U-vXBKQA': 'Good Pie',\n",
       " '8I2Xb-mksGen0ra2CnUJpw': \"Love's Travel Stop\",\n",
       " '8IEay5jgk3FOTur5tUvsaQ': 'eatwell',\n",
       " '8J4oT58-Nc-q1bpF9CRTpw': \"Applebee's Grill + Bar\",\n",
       " '8JxhnIJyOOR4qpqhRr0eiw': \"Carl's Jr\",\n",
       " '8K3CRM4COa0SSBEvli0fJQ': 'Paymons Mediterranean Cafe & Hookah Lounge',\n",
       " '8KEB1lcjKlIVSd6uA8JB9w': 'Cafe Rio',\n",
       " '8KEtBCNHvjx3-S5CP7W2Aw': 'Nagano Sushi & Grill',\n",
       " '8KsMtzkmKgNsiVWyeeYQYw': 'Las Vegas Chinatown Plaza',\n",
       " '8L_eeOwZryvlUEO42Zq8nQ': 'L & L Hawaiian Barbecue',\n",
       " '8OaXvfag7E7oznV4rVb7vg': 'Rivas Mexican Grill',\n",
       " '8PxPmL6FI9CgazDqNzw5CQ': 'Canelo Restaurant Y Mariscos',\n",
       " '8Q6jl7OW8DZzwANggDspcw': 'Sugar Factory American Brasserie',\n",
       " '8Qs6f026h6sU6MAzL7JJjg': 'Viet Bistro',\n",
       " '8REOSFVMO-E1VrmLvY49Tg': 'Home-Made Ice Cream',\n",
       " '8RFT1woy0WnTp62ndVJgow': 'The Blue Skillet',\n",
       " '8RGoNUEC4QGbpF4af7CDdQ': \"Little Caesar's\",\n",
       " '8SWZLawwzqwzbXpGQS7gBw': \"Della's Kitchen\",\n",
       " '8StUtYZ3yTCDxMS9439GMQ': 'Mi Lindo Nayarit Seafood',\n",
       " '8SwMaPL6AJIs1ZPSZ3NJ4w': 'Forte European Tapas Bar and Bistro',\n",
       " '8USUyIeN39rurnqCn5cA0w': 'Los Lupes Mexican Restaurant',\n",
       " '8Uq4KDu10q1NAjA86v5Oeg': 'Subway',\n",
       " '8VCyDz3DHrlo5TFt8T1x6Q': \"Lady D's Pizzeria\",\n",
       " '8YJOMfdnk42v3PvpkDxJGg': 'Maribel Mexican Food & More',\n",
       " '8YjfILsV0xu84t0aTiceig': \"Papa Murphy's\",\n",
       " '8Yz1eFsaUy-ny3B6YZDOrg': 'Outback Steakhouse',\n",
       " '8_hy-FrbC9zcakjKH_yaXA': 'Bomb Tacos',\n",
       " '8aRk2nVmVvhfNFW9TcsUfA': 'Cafe Siena',\n",
       " '8b5ll2kjXfjgFIqWsjkr8Q': 'Seabreeze Cafe',\n",
       " '8bYXg27QEoAx7us15eIL5g': \"Applebee's Grill + Bar\",\n",
       " '8bZ49zy4KlFVu5teFETYhQ': 'Go Wild Sushi & Grill',\n",
       " '8bqhrcvbLe-Hz1jcI0yx3Q': 'Si Jang',\n",
       " '8chcaZIRlP4p5anpzUB3FQ': 'Dirty Fork',\n",
       " '8cn8zqkyz-UpGKXcKeIRYA': \"Wasabi Jane's Venetiaen\",\n",
       " '8dSIAoz_UphMGpZr_uMing': \"Rosati's\",\n",
       " '8f5JVaK2mZCu9lct23dhtQ': \"Chuck E. Cheese's\",\n",
       " '8fFTJBh0RB2EKG53ibiBKw': \"Zenaida's Cafe\",\n",
       " '8fiZjbPMgg4qDSLIdZsWZg': 'Sunshine Cafe',\n",
       " '8fjF2NIPSM0Ar1hed2tdog': \"Gilligan's HideAway\",\n",
       " '8hAGLM_ZQa4CFhzvVcLczQ': \"Salt 'N Pepper Southern Comfort Bar and Grill\",\n",
       " '8hDKFHyRrILlXp5DfTlSGw': 'Steak & Spud Factory',\n",
       " '8hZjiPzJIojA1k7_W4hELA': 'Taco San Francisco',\n",
       " '8itGZAOBMiTbHKOwLuh4_Q': 'Buffet Asia On Nellis',\n",
       " '8jj6dYkZtxTCsq_Y-C_DtQ': 'iCheese Pizza & Sub',\n",
       " '8lZtLSeJVg28Gb75iklmmQ': 'East Side Pizza',\n",
       " '8menaxER6kxM_Lyi5tBmSA': 'Subway',\n",
       " '8nDEOGVVvReXFJ2zjPh4Pw': \"Denny's\",\n",
       " '8olG8J91NG_QU92WHG5QfA': 'Amore Taste of Chicago',\n",
       " '8ovqtunN8zGdCbYi-MCTAQ': \"Pt's Gold\",\n",
       " '8pmGz3Lg4f_r7HdDZPa4dQ': 'Payless Pizza',\n",
       " '8qAtou9A4ksXGkjyLibWDg': 'D. Vino',\n",
       " '8sFRqawo8bDDWiaC9wkA5g': 'Las Micheladas Bar and Grill',\n",
       " '8t4RND0dQhO0MBvyuMVkKA': 'Engine 1 Pizza',\n",
       " '8tMy7yEeNVYylVVFRlPmdQ': 'Boteco',\n",
       " '8tSoBxQ8KzMWvCw7a8KBCg': 'Philippine Gardens Karaoke Restaurant and Lounge',\n",
       " '8vkFJ_kA8XxDyjHfmsdEOg': 'Five Guys',\n",
       " '8w2Mzdz-JKy3qOpndK1Wqw': 'Subway',\n",
       " '8wFiWvlfOVt1zvAvsoLw2g': 'La Bonita Taco Shop',\n",
       " '8wt-saX_qXaqVCXQHc5qXw': 'Sporting Life Bar',\n",
       " '8yiLVWzJyyTEhYE0fVNvlA': 'Il Mulino New York',\n",
       " '8zh9Uts1H32Cqfbar44TLw': 'El Birotazo',\n",
       " '9-cVW8wSRoE6Nmnc7v0uUA': 'Pantry - 24 Hour Kitchen',\n",
       " '909BaH47M7FfjbFniClm6Q': 'Little Caesars Pizza',\n",
       " '91JwvxaCYhLWnAOWp_AmeQ': 'Popeyes Lousiana Kitchen',\n",
       " '92lt0pzWl8RRZiPCikDUpA': 'Don Tortaco',\n",
       " '939j88ceB05Te3D7kQPwSA': 'VooDoo Rooftop Nightclub & Lounge',\n",
       " '94BEy7wGKmrOC7sjSHMisw': 'Charlies  Lakeside Restaurant & Lounge',\n",
       " '94EjzQ9cp7iVctFNe0SSsw': 'Wings Restaurant',\n",
       " '94GL9JkTuhSqSZ94RS5Dkw': \"Russell's Restaurant\",\n",
       " '94GNGMxmruuqRLRhLqllWw': \"Wendy's\",\n",
       " '94mQ3aJ2xjP6W-CV1j8cXg': 'Port of Subs',\n",
       " '95ASq_FH5hLT1bA3fdISqw': 'Burger King',\n",
       " '95CCHowiE0W_ovv5-9lQAQ': 'Fat Boy',\n",
       " '95TwO5NbFeH7Kz7_OYr1Ig': 'Triple Play American Grill',\n",
       " '966W5oXOBW0ZWhNYy0yjcA': \"Wendy's Noodle Cafe\",\n",
       " '97TVQZZo_2nMDTeWvqfXXg': 'Ciao Ciao Cafe & Bar',\n",
       " '98hNRWW4AC5IzEg4BP3f5Q': 'Sushi Bar Sage',\n",
       " '99kGGQoig4YaRi-52VtqMA': 'Tropical Smoothie Cafe',\n",
       " '9A-SbsQJ9efK57oW3GsAlQ': 'Jack in the Box',\n",
       " '9AnvV8V-UvA_rFhMCr_Dlw': 'Mint Indian Bistro',\n",
       " '9Aq0MmPAYcz-Xm2vbUq98A': \"Carl's Jr.\",\n",
       " '9B9rmmyvI7uWx9C_BFU59A': 'Smokeit BBQ & Catering',\n",
       " '9Bu4mbMrtSq6lrAtSjJq2w': 'Bullets and Burgers',\n",
       " '9CNObWIk7w8poCo5IAtgmw': \"Raising Cane's\",\n",
       " '9Fn0aU6gg6oGi9HsE5tlbw': \"Corcoran's Irish Pub\",\n",
       " '9GPTELAPPpT5vUxad9AoCw': 'Red Ribbon Bakeshop',\n",
       " '9GRbDT8WCtfImKHMn823-A': 'Z Chicken',\n",
       " '9IpKGHaPy3hhXo9g5Bt7lg': 'Metro Pizza',\n",
       " '9J-Vg2-uqjreSRtITaDlMg': 'Odyssey Pizza',\n",
       " '9Jc3W0aR9Xf2gcHI0rEXsw': 'The Garden Grill',\n",
       " '9MK66QkfnTp6BxZudH9wxg': \"Capriotti's Sandwich Shop\",\n",
       " '9NwXHbKyJOhX9nxjRi0AcQ': \"Auntie Anne's\",\n",
       " '9P23-V64kYz3trn9ecaJJA': 'Kame Omakase',\n",
       " '9PIC380tmNYpIC3z5cvcNA': 'Is Sweet',\n",
       " '9QtHDX71JnaQbmzWWVbi-A': \"Quark's Bar & Restaurant\",\n",
       " '9R2UXiCt1DgV8Yhm3WX2KA': \"McDonald's\",\n",
       " '9RQznFcE6Mhslaw0WlJ3jA': 'Paiz Latin & Vegan Food',\n",
       " '9Rs7n2LbINBN8kLbScjhmA': 'The Cr??pe',\n",
       " '9SHoWGXsGOCa5hOjBOzPtg': \"China Joe's\",\n",
       " '9U4Tqt5SkZKQ6eeH6IPSxQ': 'Ohjah Japanese Steakhouse',\n",
       " '9UVkAmyodpaSBm49DBKFNw': 'Sweet Pok??',\n",
       " '9UZbY3FxhpNZ8sVWcYON6A': 'Cicis',\n",
       " '9V9RlgqqnPFQJfF_e9Lnmw': 'Baidu China Bistro',\n",
       " '9WVNvQ1UhzXVMihF2Rhuiw': 'Rigos Taco',\n",
       " '9WeJvvyT-j3btKwvTXyzjw': \"Dotty's #7\",\n",
       " '9XelmxS5q9tv7uClvjGqMg': 'Seafood City Supermarket',\n",
       " '9YB4qqmyglww3bbW7i0kOA': 'Ramen Kobo+Sake',\n",
       " '9YiQ3o0EGmtojzjXdEfgeQ': 'The Green Regime',\n",
       " '9ZDfXwG2dPN6lbKpWkAnsA': 'GFY Burgers and Fries',\n",
       " '9_OPjioLbD9Q_zAeHfv6kw': 'The Red Pot',\n",
       " '9_P2oM43QIRze2VJpw_dHw': 'A La Mode',\n",
       " '9a9xBjlW2RxKxD9RMgmcuQ': \"McDonald's\",\n",
       " '9ae7asMUB-Fty3tw6m18qQ': 'Pho Da Nang Vietnamese Kitchen',\n",
       " '9apCvu75wELDFia_usTjlg': 'Oyster Bar',\n",
       " '9avLLw9uke50m8qO9doyMQ': \"King's Sausage\",\n",
       " '9c3LlXubVkbMwIrS8dIp0Q': 'Ribs & Burgers',\n",
       " '9cw870n3gsGikVoOT5YOYg': 'Pier 215',\n",
       " '9d36_PI9Fh7kZ-Pybr2QiA': 'The Olive Mediterranean Grill',\n",
       " '9dz6ZYUDCqtD67LSPTLApQ': \"McDonald's\",\n",
       " '9eUBRR7WWOqXErZ7omYLNA': 'Sandbar',\n",
       " '9edPSkfXKsJmkZYIaOmA7Q': 'Las Vegas South Premium Outlets',\n",
       " '9ehTNgvu0vZgHjWkQqF6KQ': 'Macayo Vegas',\n",
       " '9evRrJHVWghiv16EOUg6zA': 'Mountain View Bistro',\n",
       " '9f68hfHK6gNyHWmt9guiJw': 'Mariscos Vallarta',\n",
       " '9gXhs9peDtrjWGdUlytYog': 'Quickee Burgers',\n",
       " '9hEPwq1GmU1dp3ZyBB9ASQ': \"Pt's Gold\",\n",
       " '9hNuOUywLPHdSbAXtQ9DhQ': 'Slices Pizzeria',\n",
       " '9iCgfQ7ffWtroHbde7q-pQ': 'IHOP',\n",
       " '9iNZ2o5jt-zpdMoAOgd7_g': 'China Kitchen',\n",
       " '9jPb9kD6UBk4aVEgaizaoQ': 'Cafe Cortez',\n",
       " '9kPbAt95kECBGGi_e5yV0Q': 'Modern Proteins',\n",
       " '9km51KaQujxsSgdaG9gYSw': 'Paina Cafe',\n",
       " '9li2xKBUybR_7JGiCwo6Gg': 'Pizza N Pizza',\n",
       " '9lqPRnnxUA47dacFK9lhtQ': 'Va Bene Caff?¡§',\n",
       " '9pAjLSoHs95m5D3nP3nY5Q': 'Subway',\n",
       " '9pTewioF128zRmHKAYGYDQ': \"Papa John's Pizza\",\n",
       " '9qAGif3XfRlJ83GJBbDNOQ': 'Viet Kitchen',\n",
       " '9qcTpWYxrZrN13p1zAP6dA': 'Ping Pong Thai Restaurant',\n",
       " '9r6ijZgxDLJFysxIohtTcQ': 'Northern China Restaurant',\n",
       " '9sbXPpRC_wDhCsp7qG2PDw': 'HK Seafood Garden',\n",
       " '9tLCuUmw3Tlco-tKPGkIWQ': 'Teriyaki Madness',\n",
       " '9tjX_OuFofQxLTh9pky8KQ': 'Pinoy Resto Buffet',\n",
       " '9uRrzqQaq9XwW9lLj7oBxw': 'IHOP',\n",
       " '9virZ-ORrLHsv0p8EORxeg': 'Dairy Queen',\n",
       " '9wNrqTeoEepFSbFu4QLuUQ': \"Rosati's Pizza\",\n",
       " '9wUIxdYz-CCpGRLu9BxJdg': 'South Philly Steak & Fries',\n",
       " '9wxxjUKdaiWeK0fGxSYhzQ': 'Raffles Cafe',\n",
       " '9xAQPtjOf92wLjMHPWYEpA': 'Cili',\n",
       " '9zvglUorc3YOpN3SyJQKZw': 'Tropical Smoothie',\n",
       " 'A-uZAD4zP3rRxb44WUGV5w': 'Soho Japanese Restaurant',\n",
       " 'A0X1baHPgw9IiBRivu0G9g': 'Patisserie Manon',\n",
       " 'A1ZRCrjOMOwQGj2hCYWDEQ': 'KFC',\n",
       " 'A2pZTpFXWC38z506XIhnBQ': 'Wingstop',\n",
       " 'A4yJu-Nq1n6nuLP6QKZkrw': 'El Pollo Loco',\n",
       " 'A4zLP5AyKEEHQr_dWEZKig': 'Cleo',\n",
       " 'A5Rkh7UymKm0_Rxm9K2PJw': 'Yard House',\n",
       " 'A6kXV4LPZsPjqWyGU-h_zw': 'KFC',\n",
       " 'A6lKCuTrDSJ_eFKyumZCJQ': 'WuHu Noodle',\n",
       " 'A6rPIkIzxIeriuI4FFwxnw': \"Joey's Pizza\",\n",
       " 'A7jbtXYFAZhErOW7xIQinA': \"Mother's Korean Grill\",\n",
       " 'A81a8oV8DAxnGLY2_r8dUQ': 'Tapioca Express',\n",
       " 'A8IouaHOlMHoVIRuAKbKzA': 'Wine Cellar & Tasting Room',\n",
       " 'A9B6jSj2FvIsK5gpDBXbCw': 'Jake & Eli',\n",
       " 'A9IUE1W6TfVXfSC6LkrWCw': 'White Rabbit Cafe 2',\n",
       " 'A9cpN5TtYvJcB25pjLxkpQ': 'Subway',\n",
       " 'ABJjxuO6oh5D9R48-eAUdQ': 'The Buffet at Luxor',\n",
       " 'ABtCLFoIEH26T2Ij-FQjag': \"Roly's Bakery\",\n",
       " 'AES2bv2pf2jIL5c2qVQ33w': \"Papa John's Pizza\",\n",
       " 'AHnvBkGTNlpAVTmg-k0Bsg': 'Subway',\n",
       " 'AI7zxDNVgO3pDyAP_rcA7A': 'Chipotle Mexican Grill',\n",
       " 'AKBSPjk_H_w8RCqCE_vUuA': 'Paradise Cafe',\n",
       " 'AKHdt0hRzX1sYZwmGzwG_A': 'Fuel Caf??',\n",
       " 'AL5YzikrmxwcBzBNLGO7Jw': 'Fuddruckers',\n",
       " 'ALaBtHzn3ekGDJQoCoQgOg': 'Onion Steak Sub',\n",
       " 'ALp--wAIVL4qQfCANn3ffw': 'Hunt & Gather Cafe',\n",
       " 'AMTNJbYbu0OMMAkx4meQxw': 'Circo',\n",
       " 'AN0bWhisCf6LN9eHZ7DQ3w': 'Los Olivos Ristorante',\n",
       " 'AN6HjBZeEcLgekQawgmS3w': 'Jack in the Box',\n",
       " 'ANSdwcG2_tH5iHdOpokVpQ': 'El Taquito Restaurant',\n",
       " 'ANfmkeFbBgNRc4AN1bpFaw': 'Design & Dine',\n",
       " 'AOEHe6uKrnC_Aje3kT8-7w': \"Angelo's Pizza  Kitchen\",\n",
       " 'AOzTlFAnIvuv2Hj_gnepsw': 'Popeyes Louisiana Kitchen',\n",
       " 'APAsM2DPl9FH0sC6jFEaXQ': 'Snacks',\n",
       " 'APIbThZ8PYfWsdK4Z0D5Rg': 'Subway',\n",
       " 'ARGQeEn17fhIdfij07FwNw': 'Viva El Taco Express',\n",
       " 'ARohEoxqg8TzA5gQfdGAZw': 'Benihana',\n",
       " 'ASxoWbHKUWBZLh2rWysLcw': 'Fortune Seafood Restaurant',\n",
       " 'AT1bODcrWTKTRNZKRxO-cA': 'Streetcar Po-boys',\n",
       " 'ATGZLAWudXt5hQXQ1AVGDQ': 'SG Bar',\n",
       " 'AT_xDv2Lm5K7VtER1fp-SA': 'Strip House Steak House',\n",
       " 'AUOlDSQ8R2wIkN4lQ4kVDg': 'Lima Limon',\n",
       " 'AUZQbqGldMpNURXCh-UuUQ': 'Snacks',\n",
       " 'AUl6myFhTAbEqt0GMdKHiw': 'Chipotle Mexican Grill',\n",
       " 'AVA3AwMEHfLY9anV3WgDXA': 'El Pollo Loco',\n",
       " 'AVXw5x9Sg-jD5EVcvpxrQA': 'Burger King',\n",
       " 'AVtNuwwdgWWm2CZqRe5pKQ': 'San Gennaro Burger',\n",
       " 'AYe8rS3qBPuLHSwNOZSbcA': 'Sushi Loca',\n",
       " 'AZlnpvILz5cEWJifjr2CSQ': 'Roma Deli II and Wine Shop',\n",
       " 'A_CXVdyJCE6nyxwbd6fNwg': 'Libertine Social',\n",
       " 'AaLvYFsLuyO1uGk0QLxN5A': 'Dirt Dog - Las Vegas Strip',\n",
       " 'AbadN65irz8uSL8z6fkoBg': 'BBQ King',\n",
       " 'AcF2XeufMmKG_-y-Bu-_1A': 'Wienerschnitzel',\n",
       " 'AdNbLQQWgR28-GWU0G-qJw': \"Denny's\",\n",
       " 'Ad_-9GuDFTEjAsSQ3PXLOw': 'Subway',\n",
       " 'Adfso3cOhkAfv8YXC__aqg': 'Madison Avenue Bar & Grille',\n",
       " 'Ae91-YlrGnHKq7KXD1WDxw': 'ABX American Burger Works',\n",
       " 'AedKwfr0VdNj7Xmx70GW6g': 'Old School Brewing Company',\n",
       " 'AfL8Ds7ex73tfVbq3EFWKg': 'Baja Fresh',\n",
       " 'AgMBY5tKMaFnFA2S6Vf22A': \"Capriotti's Sandwich Shop\",\n",
       " 'AhAuNIkWtht0Fq4gEJzodA': 'Wienerschnitzel',\n",
       " 'AhkHsa9xM7-Fxz9sxKra2Q': 'Pink Box',\n",
       " 'AiXzyI2Xehh-1yvbB-WcYw': 'Panda Express',\n",
       " 'AjWFFZN8KwyqJzzi0DyEsw': 'Burger Brasserie',\n",
       " 'AkG4ozbKUgjDk8-Mmywsxw': 'Timbers - Lake Mead',\n",
       " 'AkdyGTQX8gO3J24nPlww_w': 'The Steakhouse at Treasures',\n",
       " 'Akl6WDSUwYQ3zanxczLNSg': 'Rice & Company',\n",
       " 'AmIJMMd9OeT_mUj9DAn2ow': 'papa johns',\n",
       " 'AmJ0GFlYCAap-vGYxv-OJQ': \"Rocky's Bar and Grill\",\n",
       " 'AnXovUgUHJap3QaDRnjL1w': 'Blueberry Hill Family Restaurant',\n",
       " 'Ang2kQwTBd9S4LrhAS2pCA': 'Mala Restaurant',\n",
       " 'AoGCnRtwifZ2gTGHtg8KTw': 'Tokyo Sushi House',\n",
       " 'Apkr-qykgpUI5ltIw7B-7Q': 'Stake Out Bar & Grill',\n",
       " 'AqfEIxefqdArIWf9YUVAtQ': 'Omelet House',\n",
       " 'Arx42aGpdfI6XRH9lnKdaQ': 'GlutenZero Bakery',\n",
       " 'Asy49gKgikq_NkYsC_7c0Q': \"Capriotti's Sandwich Shop\",\n",
       " 'AtD6B83S4Mbmq0t7iDnUVA': 'Veggie House',\n",
       " 'AuYHfT9Y0QEeu0hrZic0xg': 'Worlds Best Corndogs',\n",
       " 'AurgTYGyCItvvgFp9NQBag': 'Subway',\n",
       " 'AwBCgvegeFogpb3lpmpCuw': \"Joey's Pizza\",\n",
       " 'Ay34xZOFax3X23zaA3nwdg': 'Roma Deli 1 & Restaurant',\n",
       " 'AyEtowSGi9vx0-xFfrgjWw': 'Payard P??tisserie & Bistro',\n",
       " 'AyKOSCyaPb7x8a9gqZ0z2A': 'Subway',\n",
       " 'AztVIokc5VtP4m8r6kSnWw': 'Subway',\n",
       " 'B0Vm2tge4I2JJlZhD4sl0Q': '35 Steaks + Martinis',\n",
       " 'B19KKE75ZxqoR3EDuvA1qw': 'China Star',\n",
       " 'B1X-D4mRW3VjNUUolPDItA': 'Mr Beijing',\n",
       " 'B3omTXI--0eiBC7nCv_WXg': 'Farm Basket',\n",
       " 'B4zX3o9Qehq-cibq05FTcA': \"Auntie Anne's\",\n",
       " 'B7XwqO9Lbzq-VtOiRobfCg': 'LBS Burger',\n",
       " 'B7qQmqD9H2UoOpShmHTfZw': 'Soulfish Poke',\n",
       " 'B7wVtgjOxkFNOoD6S11Urw': 'Flowing Tide Pub 6',\n",
       " 'B8Wqz8w7kKvMjZIbr2yUZg': 'The Spot to Eat',\n",
       " 'B9hP01A7AT4tQXv_nRozQw': 'Sammy Pho Vietnamese Cuisine',\n",
       " 'BB-Ab0rwYk6aclOn9SMVmg': 'Blue Dogs Pub',\n",
       " 'BBJ6Y9Kb2-luoBFBfc8o9w': 'California Noodle House',\n",
       " 'BCAw9a_kyx2RddRH9tMmKQ': \"Mr. Lucky's 24-7\",\n",
       " 'BEplfZTUzYwApjMUaOA12w': 'Canonita',\n",
       " 'BEtgRzNeXGAf0uQ-HuSyfA': 'Ohjah Noodle House',\n",
       " 'BFZ4mqQ3hRKxzbdOU2Nrqw': 'Togoshi Ramen',\n",
       " 'BHIIG8miKQo3s7bodp2ICA': 'Checkers',\n",
       " 'BIbjBxoiJLS8CnNsSP64TQ': '360 Gourmet Burrito',\n",
       " 'BIuXMWuQIlC1ZlC3lTzy-w': 'Konbea Belt Sushi',\n",
       " 'BIwjYT9nqbkF7kbzne-tmQ': 'Wolfgang Puck Express',\n",
       " 'BKg8YIGX_5YyUczmBAyyCQ': 'China Passion',\n",
       " 'BM7Q7WHJWqNfyEzq0k4mdw': 'Subway',\n",
       " 'BMAflH82OUIMl2mHtP0MNQ': \"Bonanno's New York Pizzeria\",\n",
       " 'BOMgSyi4-TYAnjVn3m0z3A': '24 Seven Cafe',\n",
       " 'BOQOuwSNhfKx1xvKtONsBg': 'Settebello Pizzeria Napoletana',\n",
       " 'BORPULADzZV6_LJZzcsywQ': 'PBR Rock Bar & Grill',\n",
       " 'BQJokxJ4y4s57i7Mn65pvA': 'Hecho en Vegas',\n",
       " 'BQKPbuILIAG53XtIZ51s5Q': \"Original Tommy's Hamburgers\",\n",
       " 'BS2Y5IZiCOHBebHMEU2dEQ': 'Claim Jumper',\n",
       " 'BSDKbSLFO3CP-uhfcuUCkA': \"Dave & Buster's\",\n",
       " 'BSGy3c4voXZ5ntOi2fJwjg': 'Panini Cafe',\n",
       " 'BUoV8s0j22KD_PzLm8BlkA': 'Salcianu Bistro',\n",
       " 'BXkk_gg5y4ltheHqKCWMdg': 'Virgin V Cheese',\n",
       " 'BYp4NUxpwXCsTAoEmksLxA': 'Cornerstone',\n",
       " 'BZSzoBFhkXBUQTx4Cgl5Aw': \"Coco's Bakery Restaurant\",\n",
       " 'B_WggEKFq-ZFNui8CHPYvA': 'Soho Sushi Burrito',\n",
       " 'Bb75P8jpxGGtFUzKbA7XFg': \"Pop N' Sons\",\n",
       " 'BbOx9i_kDJBnE9K2hyqBTg': 'Kahuku Poke and Hawaiian Barbecue',\n",
       " 'BcW7Z9lPmOB_8eS2lEuOqQ': 'Musashi Japanese Steakhouse',\n",
       " 'BdzJQypceJ5Bam2P7egoiw': 'Mr Pok?? Bowls & Rolls',\n",
       " 'BeAr85oCQpeaWFJjLhRPWg': 'Wienerschnitzel',\n",
       " 'BfBl4TKaTrfrZY-yGSB1jQ': 'Johnny Rockets',\n",
       " ...}"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pickle\n",
    "\n",
    "with open('../data/business.pkl', 'rb') as f:\n",
    "    bus_name = pickle.load(f)\n",
    "\n",
    "bus_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "North End Pizza\n",
      "My Mother's House Italian Restaurant\n",
      "North Beach Italian Bistro\n",
      "Los Olivos Ristorante\n",
      "Sbarro\n",
      "Cafe Modena\n",
      "The Tap House\n",
      "Joe Philly's Pizza\n",
      "Casanova\n",
      "Capo's Italian Cuisine\n"
     ]
    }
   ],
   "source": [
    "for num in unrated_items_by_pred_rating[:n]:\n",
    "    print(bus_name[df_utl[num]])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python 3",
   "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.6.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}