Yelp Data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "data = pd.read_csv('https://raw.githubusercontent.com/vc1492a/Yelp-Challenge-Dataset/master/Prepped%20Data/output.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>business_id</th>\n",
       "      <th>city</th>\n",
       "      <th>full_address</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>name</th>\n",
       "      <th>review_count</th>\n",
       "      <th>stars</th>\n",
       "      <th>state</th>\n",
       "      <th>type</th>\n",
       "      <th>...</th>\n",
       "      <th>Pakistani</th>\n",
       "      <th>Barbeque</th>\n",
       "      <th>Vietnamese</th>\n",
       "      <th>Asian Fusion</th>\n",
       "      <th>Diners</th>\n",
       "      <th>Greek</th>\n",
       "      <th>Vegetarian</th>\n",
       "      <th>Number_of_Checkins</th>\n",
       "      <th>Number_of_Tips</th>\n",
       "      <th>Number_of_Tip_Likes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5UmKMjUEUNdYWqANhGckJw</td>\n",
       "      <td>Dravosburg</td>\n",
       "      <td>4734 Lebanon Church Rd Dravosburg, PA 15034</td>\n",
       "      <td>40.354327</td>\n",
       "      <td>-79.900706</td>\n",
       "      <td>Mr Hoagie</td>\n",
       "      <td>4</td>\n",
       "      <td>4.5</td>\n",
       "      <td>PA</td>\n",
       "      <td>business</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>1</th>\n",
       "      <td>UsFtqoBl7naz8AVUBZMjQQ</td>\n",
       "      <td>Dravosburg</td>\n",
       "      <td>202 McClure St Dravosburg, PA 15034</td>\n",
       "      <td>40.350553</td>\n",
       "      <td>-79.886814</td>\n",
       "      <td>Clancy's Pub</td>\n",
       "      <td>4</td>\n",
       "      <td>3.5</td>\n",
       "      <td>PA</td>\n",
       "      <td>business</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>2</th>\n",
       "      <td>3eu6MEFlq2Dg7bQh8QbdOg</td>\n",
       "      <td>Dravosburg</td>\n",
       "      <td>1 Ravine St Dravosburg, PA 15034</td>\n",
       "      <td>40.350956</td>\n",
       "      <td>-79.889059</td>\n",
       "      <td>Joe Cislo's Auto</td>\n",
       "      <td>3</td>\n",
       "      <td>5.0</td>\n",
       "      <td>PA</td>\n",
       "      <td>business</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>3</th>\n",
       "      <td>cE27W9VPgO88Qxe4ol6y_g</td>\n",
       "      <td>Bethel Park</td>\n",
       "      <td>1530 Hamilton Rd Bethel Park, PA 15234</td>\n",
       "      <td>40.354116</td>\n",
       "      <td>-80.014660</td>\n",
       "      <td>Cool Springs Golf Center</td>\n",
       "      <td>5</td>\n",
       "      <td>2.5</td>\n",
       "      <td>PA</td>\n",
       "      <td>business</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>9</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>HZdLhv6COCleJMo7nPl-RA</td>\n",
       "      <td>Pittsburgh</td>\n",
       "      <td>301 South Hills Village Pittsburgh, PA 15241</td>\n",
       "      <td>40.357620</td>\n",
       "      <td>-80.059980</td>\n",
       "      <td>Verizon</td>\n",
       "      <td>5</td>\n",
       "      <td>2.5</td>\n",
       "      <td>PA</td>\n",
       "      <td>business</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 × 89 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              business_id         city  \\\n",
       "0  5UmKMjUEUNdYWqANhGckJw   Dravosburg   \n",
       "1  UsFtqoBl7naz8AVUBZMjQQ   Dravosburg   \n",
       "2  3eu6MEFlq2Dg7bQh8QbdOg   Dravosburg   \n",
       "3  cE27W9VPgO88Qxe4ol6y_g  Bethel Park   \n",
       "4  HZdLhv6COCleJMo7nPl-RA   Pittsburgh   \n",
       "\n",
       "                                   full_address   latitude  longitude  \\\n",
       "0   4734 Lebanon Church Rd Dravosburg, PA 15034  40.354327 -79.900706   \n",
       "1           202 McClure St Dravosburg, PA 15034  40.350553 -79.886814   \n",
       "2              1 Ravine St Dravosburg, PA 15034  40.350956 -79.889059   \n",
       "3        1530 Hamilton Rd Bethel Park, PA 15234  40.354116 -80.014660   \n",
       "4  301 South Hills Village Pittsburgh, PA 15241  40.357620 -80.059980   \n",
       "\n",
       "                       name  review_count  stars state      type  \\\n",
       "0                 Mr Hoagie             4    4.5    PA  business   \n",
       "1              Clancy's Pub             4    3.5    PA  business   \n",
       "2          Joe Cislo's Auto             3    5.0    PA  business   \n",
       "3  Cool Springs Golf Center             5    2.5    PA  business   \n",
       "4                   Verizon             5    2.5    PA  business   \n",
       "\n",
       "          ...         Pakistani Barbeque Vietnamese Asian Fusion Diners Greek  \\\n",
       "0         ...                 0        0          0            0      0     0   \n",
       "1         ...                 0        0          0            0      0     0   \n",
       "2         ...                 0        0          0            0      0     0   \n",
       "3         ...                 0        0          0            0      0     0   \n",
       "4         ...                 0        0          0            0      0     0   \n",
       "\n",
       "  Vegetarian Number_of_Checkins Number_of_Tips Number_of_Tip_Likes  \n",
       "0          0                  0              0                   0  \n",
       "1          0                  0              0                   0  \n",
       "2          0                  0              0                   0  \n",
       "3          0                  9              1                   0  \n",
       "4          0                  0              0                   0  \n",
       "\n",
       "[5 rows x 89 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['business_id', 'city', 'full_address', 'latitude', 'longitude', 'name',\n",
       "       'review_count', 'stars', 'state', 'type', 'Sunday_Open', 'Sunday_Close',\n",
       "       'Monday_Open', 'Monday_Close', 'Tuesday_Open', 'Tuesday_Close',\n",
       "       'Wednesday_Open', 'Wednesday_Close', 'Thursday_Open', 'Thursday_Close',\n",
       "       'Friday_Open', 'Friday_Close', 'Saturday_Open', 'Saturday_Close',\n",
       "       'Noise Level', 'Attire', 'Alcohol', 'Price_Range', 'Delivery',\n",
       "       'Outdoor_Seating', 'Drive-Thru', 'Good_for_Groups', 'Has_TV', 'Caters',\n",
       "       'Waiter_Service', 'Good_for_Kids', 'Accepts_Credit_Cards',\n",
       "       'Takes_Reservations', 'Wi_Fi', 'Happy_Hour', 'Good_for_Dancing',\n",
       "       'Smoking', 'BYOB', 'Corkage', 'Take_Out', 'Coat_Check',\n",
       "       'Parking_Street', 'Parking_Valet', 'Parking_Lot', 'Parking_Garage',\n",
       "       'Parking_Validated', 'Music_DJ', 'Music_Karaoke', 'Music_Video',\n",
       "       'Music_Live', 'Music_Jukebox', 'Music_Background_Music',\n",
       "       'Is_Restaurants', 'Sandwiches', 'Fast Food', 'Nightlife', 'Pizza',\n",
       "       'Bars', 'Mexican', 'Food', 'American (Traditional)', 'Burgers',\n",
       "       'Chinese', 'Italian', 'American (New)', 'Breakfast & Brunch', 'Thai',\n",
       "       'Indian', 'Sushi Bars', 'Korean', 'Mediterranean', 'Japanese',\n",
       "       'Seafood', 'Middle Eastern', 'Pakistani', 'Barbeque', 'Vietnamese',\n",
       "       'Asian Fusion', 'Diners', 'Greek', 'Vegetarian', 'Number_of_Checkins',\n",
       "       'Number_of_Tips', 'Number_of_Tip_Likes'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 72742 entries, 0 to 72741\n",
      "Data columns (total 89 columns):\n",
      "business_id               72742 non-null object\n",
      "city                      72740 non-null object\n",
      "full_address              72742 non-null object\n",
      "latitude                  72742 non-null float64\n",
      "longitude                 72742 non-null float64\n",
      "name                      72742 non-null object\n",
      "review_count              72742 non-null int64\n",
      "stars                     72742 non-null float64\n",
      "state                     72741 non-null object\n",
      "type                      72742 non-null object\n",
      "Sunday_Open               30137 non-null object\n",
      "Sunday_Close              30137 non-null object\n",
      "Monday_Open               43407 non-null object\n",
      "Monday_Close              43407 non-null object\n",
      "Tuesday_Open              45917 non-null object\n",
      "Tuesday_Close             45917 non-null object\n",
      "Wednesday_Open            46367 non-null object\n",
      "Wednesday_Close           46367 non-null object\n",
      "Thursday_Open             46539 non-null object\n",
      "Thursday_Close            46539 non-null object\n",
      "Friday_Open               46332 non-null object\n",
      "Friday_Close              46332 non-null object\n",
      "Saturday_Open             41198 non-null object\n",
      "Saturday_Close            41198 non-null object\n",
      "Noise Level               19127 non-null object\n",
      "Attire                    21084 non-null object\n",
      "Alcohol                   21083 non-null object\n",
      "Price_Range               46132 non-null float64\n",
      "Delivery                  21245 non-null float64\n",
      "Outdoor_Seating           23896 non-null float64\n",
      "Drive-Thru                3201 non-null float64\n",
      "Good_for_Groups           23296 non-null float64\n",
      "Has_TV                    20368 non-null float64\n",
      "Caters                    14608 non-null float64\n",
      "Waiter_Service            19287 non-null float64\n",
      "Good_for_Kids             27665 non-null float64\n",
      "Accepts_Credit_Cards      52650 non-null float64\n",
      "Takes_Reservations        20743 non-null float64\n",
      "Wi_Fi                     19645 non-null object\n",
      "Happy_Hour                4203 non-null float64\n",
      "Good_for_Dancing          4055 non-null float64\n",
      "Smoking                   4300 non-null object\n",
      "BYOB                      836 non-null float64\n",
      "Corkage                   623 non-null float64\n",
      "Take_Out                  21203 non-null float64\n",
      "Coat_Check                4044 non-null float64\n",
      "Parking_Street            41377 non-null float64\n",
      "Parking_Valet             41379 non-null float64\n",
      "Parking_Lot               41377 non-null float64\n",
      "Parking_Garage            41391 non-null float64\n",
      "Parking_Validated         40989 non-null float64\n",
      "Music_DJ                  3404 non-null float64\n",
      "Music_Karaoke             1522 non-null float64\n",
      "Music_Video               2372 non-null float64\n",
      "Music_Live                2558 non-null float64\n",
      "Music_Jukebox             2566 non-null float64\n",
      "Music_Background_Music    1501 non-null float64\n",
      "Is_Restaurants            72742 non-null int64\n",
      "Sandwiches                72742 non-null int64\n",
      "Fast Food                 72742 non-null int64\n",
      "Nightlife                 72742 non-null int64\n",
      "Pizza                     72742 non-null int64\n",
      "Bars                      72742 non-null int64\n",
      "Mexican                   72742 non-null int64\n",
      "Food                      72742 non-null int64\n",
      "American (Traditional)    72742 non-null int64\n",
      "Burgers                   72742 non-null int64\n",
      "Chinese                   72742 non-null int64\n",
      "Italian                   72742 non-null int64\n",
      "American (New)            72742 non-null int64\n",
      "Breakfast & Brunch        72742 non-null int64\n",
      "Thai                      72742 non-null int64\n",
      "Indian                    72742 non-null int64\n",
      "Sushi Bars                72742 non-null int64\n",
      "Korean                    72742 non-null int64\n",
      "Mediterranean             72742 non-null int64\n",
      "Japanese                  72742 non-null int64\n",
      "Seafood                   72742 non-null int64\n",
      "Middle Eastern            72742 non-null int64\n",
      "Pakistani                 72742 non-null int64\n",
      "Barbeque                  72742 non-null int64\n",
      "Vietnamese                72742 non-null int64\n",
      "Asian Fusion              72742 non-null int64\n",
      "Diners                    72742 non-null int64\n",
      "Greek                     72742 non-null int64\n",
      "Vegetarian                72742 non-null int64\n",
      "Number_of_Checkins        72742 non-null int64\n",
      "Number_of_Tips            72742 non-null int64\n",
      "Number_of_Tip_Likes       72742 non-null int64\n",
      "dtypes: float64(31), int64(33), object(25)\n",
      "memory usage: 49.4+ MB\n"
     ]
    }
   ],
   "source": [
    "data.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "user_data = pd.read_json(r'C:\\Users\\ZekeLabs\\Downloads\\yelp_training_set\\yelp_training_set\\yelp_training_set_user.json',lines=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>average_stars</th>\n",
       "      <th>name</th>\n",
       "      <th>review_count</th>\n",
       "      <th>type</th>\n",
       "      <th>user_id</th>\n",
       "      <th>votes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Jim</td>\n",
       "      <td>6</td>\n",
       "      <td>user</td>\n",
       "      <td>CR2y7yEm4X035ZMzrTtN9Q</td>\n",
       "      <td>{'funny': 0, 'useful': 7, 'cool': 0}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Kelle</td>\n",
       "      <td>2</td>\n",
       "      <td>user</td>\n",
       "      <td>_9GXoHhdxc30ujPaQwh6Ew</td>\n",
       "      <td>{'funny': 0, 'useful': 1, 'cool': 0}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Stephanie</td>\n",
       "      <td>2</td>\n",
       "      <td>user</td>\n",
       "      <td>8mM-nqxjg6pT04kwcjMbsw</td>\n",
       "      <td>{'funny': 0, 'useful': 1, 'cool': 0}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5.0</td>\n",
       "      <td>T</td>\n",
       "      <td>2</td>\n",
       "      <td>user</td>\n",
       "      <td>Ch6CdTR2IVaVANr-RglMOg</td>\n",
       "      <td>{'funny': 0, 'useful': 2, 'cool': 0}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Beth</td>\n",
       "      <td>1</td>\n",
       "      <td>user</td>\n",
       "      <td>NZrLmHRyiHmyT1JrfzkCOA</td>\n",
       "      <td>{'funny': 0, 'useful': 0, 'cool': 0}</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   average_stars       name  review_count  type                 user_id  \\\n",
       "0            5.0        Jim             6  user  CR2y7yEm4X035ZMzrTtN9Q   \n",
       "1            1.0      Kelle             2  user  _9GXoHhdxc30ujPaQwh6Ew   \n",
       "2            5.0  Stephanie             2  user  8mM-nqxjg6pT04kwcjMbsw   \n",
       "3            5.0          T             2  user  Ch6CdTR2IVaVANr-RglMOg   \n",
       "4            1.0       Beth             1  user  NZrLmHRyiHmyT1JrfzkCOA   \n",
       "\n",
       "                                  votes  \n",
       "0  {'funny': 0, 'useful': 7, 'cool': 0}  \n",
       "1  {'funny': 0, 'useful': 1, 'cool': 0}  \n",
       "2  {'funny': 0, 'useful': 1, 'cool': 0}  \n",
       "3  {'funny': 0, 'useful': 2, 'cool': 0}  \n",
       "4  {'funny': 0, 'useful': 0, 'cool': 0}  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "user_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "review_data = pd.read_json(r'C:\\Users\\ZekeLabs\\Downloads\\yelp_training_set\\yelp_training_set\\yelp_training_set_review.json',lines=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>business_id</th>\n",
       "      <th>date</th>\n",
       "      <th>review_id</th>\n",
       "      <th>stars</th>\n",
       "      <th>text</th>\n",
       "      <th>type</th>\n",
       "      <th>user_id</th>\n",
       "      <th>votes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>9yKzy9PApeiPPOUJEtnvkg</td>\n",
       "      <td>2011-01-26</td>\n",
       "      <td>fWKvX83p0-ka4JS3dc6E5A</td>\n",
       "      <td>5</td>\n",
       "      <td>My wife took me here on my birthday for breakf...</td>\n",
       "      <td>review</td>\n",
       "      <td>rLtl8ZkDX5vH5nAx9C3q5Q</td>\n",
       "      <td>{'funny': 0, 'useful': 5, 'cool': 2}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ZRJwVLyzEJq1VAihDhYiow</td>\n",
       "      <td>2011-07-27</td>\n",
       "      <td>IjZ33sJrzXqU-0X6U8NwyA</td>\n",
       "      <td>5</td>\n",
       "      <td>I have no idea why some people give bad review...</td>\n",
       "      <td>review</td>\n",
       "      <td>0a2KyEL0d3Yb1V6aivbIuQ</td>\n",
       "      <td>{'funny': 0, 'useful': 0, 'cool': 0}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>6oRAC4uyJCsJl1X0WZpVSA</td>\n",
       "      <td>2012-06-14</td>\n",
       "      <td>IESLBzqUCLdSzSqm0eCSxQ</td>\n",
       "      <td>4</td>\n",
       "      <td>love the gyro plate. Rice is so good and I als...</td>\n",
       "      <td>review</td>\n",
       "      <td>0hT2KtfLiobPvh6cDC8JQg</td>\n",
       "      <td>{'funny': 0, 'useful': 1, 'cool': 0}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>_1QQZuf4zZOyFCvXc0o6Vg</td>\n",
       "      <td>2010-05-27</td>\n",
       "      <td>G-WvGaISbqqaMHlNnByodA</td>\n",
       "      <td>5</td>\n",
       "      <td>Rosie, Dakota, and I LOVE Chaparral Dog Park!!...</td>\n",
       "      <td>review</td>\n",
       "      <td>uZetl9T0NcROGOyFfughhg</td>\n",
       "      <td>{'funny': 0, 'useful': 2, 'cool': 1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>6ozycU1RpktNG2-1BroVtw</td>\n",
       "      <td>2012-01-05</td>\n",
       "      <td>1uJFq2r5QfJG_6ExMRCaGw</td>\n",
       "      <td>5</td>\n",
       "      <td>General Manager Scott Petello is a good egg!!!...</td>\n",
       "      <td>review</td>\n",
       "      <td>vYmM4KTsC8ZfQBg-j5MWkw</td>\n",
       "      <td>{'funny': 0, 'useful': 0, 'cool': 0}</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              business_id       date               review_id  stars  \\\n",
       "0  9yKzy9PApeiPPOUJEtnvkg 2011-01-26  fWKvX83p0-ka4JS3dc6E5A      5   \n",
       "1  ZRJwVLyzEJq1VAihDhYiow 2011-07-27  IjZ33sJrzXqU-0X6U8NwyA      5   \n",
       "2  6oRAC4uyJCsJl1X0WZpVSA 2012-06-14  IESLBzqUCLdSzSqm0eCSxQ      4   \n",
       "3  _1QQZuf4zZOyFCvXc0o6Vg 2010-05-27  G-WvGaISbqqaMHlNnByodA      5   \n",
       "4  6ozycU1RpktNG2-1BroVtw 2012-01-05  1uJFq2r5QfJG_6ExMRCaGw      5   \n",
       "\n",
       "                                                text    type  \\\n",
       "0  My wife took me here on my birthday for breakf...  review   \n",
       "1  I have no idea why some people give bad review...  review   \n",
       "2  love the gyro plate. Rice is so good and I als...  review   \n",
       "3  Rosie, Dakota, and I LOVE Chaparral Dog Park!!...  review   \n",
       "4  General Manager Scott Petello is a good egg!!!...  review   \n",
       "\n",
       "                  user_id                                 votes  \n",
       "0  rLtl8ZkDX5vH5nAx9C3q5Q  {'funny': 0, 'useful': 5, 'cool': 2}  \n",
       "1  0a2KyEL0d3Yb1V6aivbIuQ  {'funny': 0, 'useful': 0, 'cool': 0}  \n",
       "2  0hT2KtfLiobPvh6cDC8JQg  {'funny': 0, 'useful': 1, 'cool': 0}  \n",
       "3  uZetl9T0NcROGOyFfughhg  {'funny': 0, 'useful': 2, 'cool': 1}  \n",
       "4  vYmM4KTsC8ZfQBg-j5MWkw  {'funny': 0, 'useful': 0, 'cool': 0}  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "review_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "business_data = pd.read_json(r'C:\\Users\\ZekeLabs\\Downloads\\yelp_training_set\\yelp_training_set\\yelp_training_set_business.json',lines=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>business_id</th>\n",
       "      <th>categories</th>\n",
       "      <th>city</th>\n",
       "      <th>full_address</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>name</th>\n",
       "      <th>neighborhoods</th>\n",
       "      <th>open</th>\n",
       "      <th>review_count</th>\n",
       "      <th>stars</th>\n",
       "      <th>state</th>\n",
       "      <th>type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>rncjoVoEFUJGCUoC1JgnUA</td>\n",
       "      <td>[Accountants, Professional Services, Tax Servi...</td>\n",
       "      <td>Peoria</td>\n",
       "      <td>8466 W Peoria Ave\\nSte 6\\nPeoria, AZ 85345</td>\n",
       "      <td>33.581867</td>\n",
       "      <td>-112.241596</td>\n",
       "      <td>Peoria Income Tax Service</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>3</td>\n",
       "      <td>5.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0FNFSzCFP_rGUoJx8W7tJg</td>\n",
       "      <td>[Sporting Goods, Bikes, Shopping]</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>2149 W Wood Dr\\nPhoenix, AZ 85029</td>\n",
       "      <td>33.604054</td>\n",
       "      <td>-112.105933</td>\n",
       "      <td>Bike Doctor</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>5</td>\n",
       "      <td>5.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3f_lyB6vFK48ukH6ScvLHg</td>\n",
       "      <td>[]</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>1134 N Central Ave\\nPhoenix, AZ 85004</td>\n",
       "      <td>33.460526</td>\n",
       "      <td>-112.073933</td>\n",
       "      <td>Valley Permaculture Alliance</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>4</td>\n",
       "      <td>5.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>usAsSV36QmUej8--yvN-dg</td>\n",
       "      <td>[Food, Grocery]</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>845 W Southern Ave\\nPhoenix, AZ 85041</td>\n",
       "      <td>33.392210</td>\n",
       "      <td>-112.085377</td>\n",
       "      <td>Food City</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>5</td>\n",
       "      <td>3.5</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>PzOqRohWw7F7YEPBz6AubA</td>\n",
       "      <td>[Food, Bagels, Delis, Restaurants]</td>\n",
       "      <td>Glendale Az</td>\n",
       "      <td>6520 W Happy Valley Rd\\nSte 101\\nGlendale Az, ...</td>\n",
       "      <td>33.712797</td>\n",
       "      <td>-112.200264</td>\n",
       "      <td>Hot Bagels &amp; Deli</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>14</td>\n",
       "      <td>3.5</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              business_id                                         categories  \\\n",
       "0  rncjoVoEFUJGCUoC1JgnUA  [Accountants, Professional Services, Tax Servi...   \n",
       "1  0FNFSzCFP_rGUoJx8W7tJg                  [Sporting Goods, Bikes, Shopping]   \n",
       "2  3f_lyB6vFK48ukH6ScvLHg                                                 []   \n",
       "3  usAsSV36QmUej8--yvN-dg                                    [Food, Grocery]   \n",
       "4  PzOqRohWw7F7YEPBz6AubA                 [Food, Bagels, Delis, Restaurants]   \n",
       "\n",
       "          city                                       full_address   latitude  \\\n",
       "0       Peoria         8466 W Peoria Ave\\nSte 6\\nPeoria, AZ 85345  33.581867   \n",
       "1      Phoenix                  2149 W Wood Dr\\nPhoenix, AZ 85029  33.604054   \n",
       "2      Phoenix              1134 N Central Ave\\nPhoenix, AZ 85004  33.460526   \n",
       "3      Phoenix              845 W Southern Ave\\nPhoenix, AZ 85041  33.392210   \n",
       "4  Glendale Az  6520 W Happy Valley Rd\\nSte 101\\nGlendale Az, ...  33.712797   \n",
       "\n",
       "    longitude                          name neighborhoods  open  review_count  \\\n",
       "0 -112.241596     Peoria Income Tax Service            []  True             3   \n",
       "1 -112.105933                   Bike Doctor            []  True             5   \n",
       "2 -112.073933  Valley Permaculture Alliance            []  True             4   \n",
       "3 -112.085377                     Food City            []  True             5   \n",
       "4 -112.200264             Hot Bagels & Deli            []  True            14   \n",
       "\n",
       "   stars state      type  \n",
       "0    5.0    AZ  business  \n",
       "1    5.0    AZ  business  \n",
       "2    5.0    AZ  business  \n",
       "3    3.5    AZ  business  \n",
       "4    3.5    AZ  business  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "business_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "checkin_data = pd.read_json(r'C:\\Users\\ZekeLabs\\Downloads\\yelp_training_set\\yelp_training_set\\yelp_training_set_checkin.json',lines=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>business_id</th>\n",
       "      <th>checkin_info</th>\n",
       "      <th>type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>KO9CpaSPOoqm0iCWm5scmg</td>\n",
       "      <td>{'0-5': 1, '13-3': 1, '14-3': 2, '14-1': 2, '1...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>oRqBAYtcBYZHXA7G8FlPaA</td>\n",
       "      <td>{'20-3': 1, '0-5': 1, '10-6': 1, '0-0': 3, '1-...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>6cy2C9aBXUwkrh4bY1DApw</td>\n",
       "      <td>{'8-2': 1, '13-4': 1, '6-4': 1, '19-0': 1, '6-...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>D0IB17N66FiyYDCzTlAI4A</td>\n",
       "      <td>{'13-4': 2, '10-1': 1, '12-5': 1, '10-5': 2, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>HLQGo3EaYVvAv22bONGkIw</td>\n",
       "      <td>{'13-4': 1, '16-2': 1, '14-5': 1, '12-5': 2, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              business_id                                       checkin_info  \\\n",
       "0  KO9CpaSPOoqm0iCWm5scmg  {'0-5': 1, '13-3': 1, '14-3': 2, '14-1': 2, '1...   \n",
       "1  oRqBAYtcBYZHXA7G8FlPaA  {'20-3': 1, '0-5': 1, '10-6': 1, '0-0': 3, '1-...   \n",
       "2  6cy2C9aBXUwkrh4bY1DApw  {'8-2': 1, '13-4': 1, '6-4': 1, '19-0': 1, '6-...   \n",
       "3  D0IB17N66FiyYDCzTlAI4A  {'13-4': 2, '10-1': 1, '12-5': 1, '10-5': 2, '...   \n",
       "4  HLQGo3EaYVvAv22bONGkIw  {'13-4': 1, '16-2': 1, '14-5': 1, '12-5': 2, '...   \n",
       "\n",
       "      type  \n",
       "0  checkin  \n",
       "1  checkin  \n",
       "2  checkin  \n",
       "3  checkin  \n",
       "4  checkin  "
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "checkin_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>business_id</th>\n",
       "      <th>checkin_info</th>\n",
       "      <th>type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>KO9CpaSPOoqm0iCWm5scmg</td>\n",
       "      <td>{'0-5': 1, '13-3': 1, '14-3': 2, '14-1': 2, '1...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>oRqBAYtcBYZHXA7G8FlPaA</td>\n",
       "      <td>{'20-3': 1, '0-5': 1, '10-6': 1, '0-0': 3, '1-...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>6cy2C9aBXUwkrh4bY1DApw</td>\n",
       "      <td>{'8-2': 1, '13-4': 1, '6-4': 1, '19-0': 1, '6-...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>D0IB17N66FiyYDCzTlAI4A</td>\n",
       "      <td>{'13-4': 2, '10-1': 1, '12-5': 1, '10-5': 2, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>HLQGo3EaYVvAv22bONGkIw</td>\n",
       "      <td>{'13-4': 1, '16-2': 1, '14-5': 1, '12-5': 2, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>J6OojF0R_1OuwNlrZI-ynQ</td>\n",
       "      <td>{'18-4': 1, '19-3': 1, '15-5': 1, '18-5': 1}</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>qgNlUte2tSI7OufuuvR8DA</td>\n",
       "      <td>{'10-6': 2, '13-6': 2, '18-1': 3, '12-5': 1, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>RUZvUPOn90ScX60eETwcCw</td>\n",
       "      <td>{'13-4': 4, '15-2': 5, '13-3': 3, '21-1': 1, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>I0UXl0AwcpSZCd4_3YCccA</td>\n",
       "      <td>{'17-3': 1, '10-6': 1, '16-5': 1, '18-6': 1, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>ypDZCOYcy4hPkLwFtiNp5g</td>\n",
       "      <td>{'8-2': 1, '22-6': 1, '12-5': 1, '17-2': 1, '1...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>qNqvJIH4_KENAajUfRZKoA</td>\n",
       "      <td>{'13-4': 3, '0-0': 1, '13-3': 1, '20-0': 5, '1...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>7n3_Dg8SCgoPjKYjcp62QQ</td>\n",
       "      <td>{'12-3': 1, '16-4': 2, '10-4': 2, '16-5': 1, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>aTUHVjsSH7YLV_wD3i4Lsw</td>\n",
       "      <td>{'12-5': 3, '11-3': 2, '21-1': 1, '20-4': 1, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>lEGq4UveDPxikXcpwjtFow</td>\n",
       "      <td>{'19-0': 1, '18-1': 4, '12-5': 4, '20-5': 3, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>IK8ID-Dq7LZsPppx4sKLhg</td>\n",
       "      <td>{'4-2': 1, '6-4': 3, '6-3': 2, '3-4': 1, '13-3...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>d-YNxMKL6ZhkiRhfUPxKHg</td>\n",
       "      <td>{'13-4': 1, '20-2': 1, '19-5': 1, '12-0': 2, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>QVDzhx0E3d-J7Lh9FuQtTQ</td>\n",
       "      <td>{'15-2': 3, '10-3': 3, '12-0': 1, '12-2': 3, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>UACSWwOwCFg58ycvb32-RQ</td>\n",
       "      <td>{'10-0': 1, '20-4': 1, '20-2': 1, '16-3': 1, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>U5-VseaV5NWnuh5AW4acJg</td>\n",
       "      <td>{'14-1': 1, '11-2': 1, '11-4': 2}</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>9cmq0_NV08ejfNsSgr2c-Q</td>\n",
       "      <td>{'10-6': 1, '12-5': 1, '10-5': 1, '15-0': 1, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>l4ymgiD1WnsSrwxWWk7a3Q</td>\n",
       "      <td>{'6-4': 4, '7-2': 1, '12-5': 1, '10-5': 1, '12...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>AYPTLvxlCw2euajnglksTA</td>\n",
       "      <td>{'8-2': 1, '19-2': 1, '7-1': 1, '21-2': 1, '10...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>YEOnspVAXguZEJp0iKLq8w</td>\n",
       "      <td>{'22-6': 1, '18-1': 1, '12-5': 1, '22-5': 1, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>LDJhwZN14AZOJyHjg2lkRw</td>\n",
       "      <td>{'13-4': 1, '7-6': 1, '22-6': 1, '17-1': 3, '1...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>9uMnQTDD0hi_ivp_te6s4A</td>\n",
       "      <td>{'13-4': 1, '18-2': 1, '12-5': 2, '3-4': 2, '1...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>pskMAsS5zxuwQUF--tWIUQ</td>\n",
       "      <td>{'13-4': 1, '16-3': 2, '20-3': 1, '12-0': 1, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>WTf7fOvesYyhMVGfk3C-pw</td>\n",
       "      <td>{'17-3': 1, '18-4': 1, '18-0': 1, '18-6': 1}</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>iqVDfE7XknJ6kDIoepT_xQ</td>\n",
       "      <td>{'10-6': 5, '20-0': 1, '11-2': 1, '8-3': 1, '1...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>nXKwzVKJCtIGd4HxXgjdnQ</td>\n",
       "      <td>{'0-5': 1, '15-2': 1, '22-6': 1, '0-1': 1, '22...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>AE7TfOrefJCI_qTvUoAezA</td>\n",
       "      <td>{'17-4': 1, '11-4': 1, '13-4': 1, '12-4': 1, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8252</th>\n",
       "      <td>Lo0dRIDKXc5mlE-coVZrtQ</td>\n",
       "      <td>{'8-3': 1, '13-4': 6, '6-4': 1, '13-3': 4, '16...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8253</th>\n",
       "      <td>s1c4bXeV08ml2_iH4XLzhw</td>\n",
       "      <td>{'12-3': 1, '9-5': 1, '11-4': 1, '13-5': 1, '1...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8254</th>\n",
       "      <td>HRjDpeJOL02ZqwrYgtHV_A</td>\n",
       "      <td>{'16-6': 1, '21-0': 1, '11-0': 1, '12-5': 1, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8255</th>\n",
       "      <td>KetHG4JpYO6a3mlYNCONRg</td>\n",
       "      <td>{'16-2': 1, '9-1': 1, '15-4': 1}</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8256</th>\n",
       "      <td>9jBTMRNxvYyyHAlCGVO91Q</td>\n",
       "      <td>{'22-5': 1, '16-4': 1, '13-3': 1, '9-3': 1, '2...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8257</th>\n",
       "      <td>YzHtlphJ-5LDtJdNzKs7Fg</td>\n",
       "      <td>{'15-6': 3, '18-2': 2, '22-5': 2, '17-4': 1, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8258</th>\n",
       "      <td>1g1rzWxU-2PQqI0-9ajFsA</td>\n",
       "      <td>{'16-4': 1, '16-6': 1, '14-0': 1, '11-2': 1, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8259</th>\n",
       "      <td>wEh9tQZxl5H1ke9MgSOW9g</td>\n",
       "      <td>{'10-5': 1, '16-5': 1, '17-4': 1, '10-4': 1, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8260</th>\n",
       "      <td>fVjeOZPjMmxyxtJuD31UOQ</td>\n",
       "      <td>{'14-5': 3, '7-1': 1, '19-0': 1, '19-2': 1, '2...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8261</th>\n",
       "      <td>4SbNOPZZ2PG-c74gH1Tx9g</td>\n",
       "      <td>{'17-4': 1, '12-1': 1, '15-2': 1, '8-5': 1, '1...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8262</th>\n",
       "      <td>_pw-OnDpCe9XM0rDVvTUMg</td>\n",
       "      <td>{'4-2': 3, '1-6': 3, '18-1': 1, '6-3': 1, '8-4...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8263</th>\n",
       "      <td>OsBdaxPwMOeeH-8uGpJDZA</td>\n",
       "      <td>{'10-3': 1, '13-3': 1, '17-0': 1}</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8264</th>\n",
       "      <td>Xq1_YvXpmg7edv2SzZuoIA</td>\n",
       "      <td>{'13-4': 2, '13-3': 1, '20-0': 1, '14-3': 1, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8265</th>\n",
       "      <td>jn3OgTqiQIFymRA9U0PTfQ</td>\n",
       "      <td>{'17-5': 3, '15-5': 2, '19-5': 2, '21-2': 1, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8266</th>\n",
       "      <td>z0dWiC4uFQTr9GBuVmui1g</td>\n",
       "      <td>{'10-5': 1, '16-5': 1, '5-0': 1}</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8267</th>\n",
       "      <td>nKrK1aK2uWtL57Q3ShH6Hg</td>\n",
       "      <td>{'13-4': 1, '13-6': 3, '20-6': 1, '14-3': 4, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8268</th>\n",
       "      <td>LY5TW3Pvlfpprl3kpRE5_w</td>\n",
       "      <td>{'17-4': 1, '20-2': 1, '13-2': 1, '16-2': 1, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8269</th>\n",
       "      <td>Our6bzte5W1wlIeOu9luug</td>\n",
       "      <td>{'13-4': 2, '15-2': 2, '22-5': 3, '13-3': 1, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8270</th>\n",
       "      <td>g_QakYd7wB6DVqyv48nWcg</td>\n",
       "      <td>{'0-2': 1, '22-4': 1, '10-6': 1, '0-6': 1, '15...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8271</th>\n",
       "      <td>DjJFnY7_Um0XhfazxlPO1Q</td>\n",
       "      <td>{'16-2': 1, '12-1': 1, '14-5': 1, '20-5': 1, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8272</th>\n",
       "      <td>s5roBvbA79SQaO4FHkJgGw</td>\n",
       "      <td>{'19-0': 3, '21-2': 1, '17-1': 2, '16-0': 1, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8273</th>\n",
       "      <td>T8xI1f3_yHzhrquCZh07Wg</td>\n",
       "      <td>{'8-0': 1, '7-0': 1, '11-0': 2, '7-3': 1, '7-2...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8274</th>\n",
       "      <td>XK5FFbrKWMjRqc6ZbSTknw</td>\n",
       "      <td>{'19-0': 1, '18-1': 1, '12-5': 1, '20-6': 2, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8275</th>\n",
       "      <td>lfysf-HycrQ7Z02HuPqgKg</td>\n",
       "      <td>{'14-5': 1, '13-5': 1, '11-5': 1, '15-4': 1}</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8276</th>\n",
       "      <td>rlG9WPf3h5MfNwHhpNsWjQ</td>\n",
       "      <td>{'8-2': 1, '13-4': 1, '22-0': 1, '15-5': 1, '1...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8277</th>\n",
       "      <td>ptU2Fh1WmnaMBOjBxJZRwA</td>\n",
       "      <td>{'13-4': 1, '14-5': 1, '16-5': 1, '19-4': 1, '...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8278</th>\n",
       "      <td>C40IsC_MxEfX3-fOBNe7WA</td>\n",
       "      <td>{'7-0': 3, '10-6': 1, '7-1': 1, '5-0': 1, '7-3...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8279</th>\n",
       "      <td>UxxPsF0oxTOideIpuppK8A</td>\n",
       "      <td>{'13-4': 1, '6-4': 1, '15-2': 1, '19-5': 1, '2...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8280</th>\n",
       "      <td>cqIHyZ3Q0D4vBi-vb4mi-g</td>\n",
       "      <td>{'0-5': 11, '22-6': 4, '0-1': 6, '18-5': 4, '1...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8281</th>\n",
       "      <td>1Nge1ObX93-y1AoXONt34A</td>\n",
       "      <td>{'8-2': 2, '18-1': 1, '12-5': 1, '17-1': 3, '1...</td>\n",
       "      <td>checkin</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8282 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 business_id  \\\n",
       "0     KO9CpaSPOoqm0iCWm5scmg   \n",
       "1     oRqBAYtcBYZHXA7G8FlPaA   \n",
       "2     6cy2C9aBXUwkrh4bY1DApw   \n",
       "3     D0IB17N66FiyYDCzTlAI4A   \n",
       "4     HLQGo3EaYVvAv22bONGkIw   \n",
       "5     J6OojF0R_1OuwNlrZI-ynQ   \n",
       "6     qgNlUte2tSI7OufuuvR8DA   \n",
       "7     RUZvUPOn90ScX60eETwcCw   \n",
       "8     I0UXl0AwcpSZCd4_3YCccA   \n",
       "9     ypDZCOYcy4hPkLwFtiNp5g   \n",
       "10    qNqvJIH4_KENAajUfRZKoA   \n",
       "11    7n3_Dg8SCgoPjKYjcp62QQ   \n",
       "12    aTUHVjsSH7YLV_wD3i4Lsw   \n",
       "13    lEGq4UveDPxikXcpwjtFow   \n",
       "14    IK8ID-Dq7LZsPppx4sKLhg   \n",
       "15    d-YNxMKL6ZhkiRhfUPxKHg   \n",
       "16    QVDzhx0E3d-J7Lh9FuQtTQ   \n",
       "17    UACSWwOwCFg58ycvb32-RQ   \n",
       "18    U5-VseaV5NWnuh5AW4acJg   \n",
       "19    9cmq0_NV08ejfNsSgr2c-Q   \n",
       "20    l4ymgiD1WnsSrwxWWk7a3Q   \n",
       "21    AYPTLvxlCw2euajnglksTA   \n",
       "22    YEOnspVAXguZEJp0iKLq8w   \n",
       "23    LDJhwZN14AZOJyHjg2lkRw   \n",
       "24    9uMnQTDD0hi_ivp_te6s4A   \n",
       "25    pskMAsS5zxuwQUF--tWIUQ   \n",
       "26    WTf7fOvesYyhMVGfk3C-pw   \n",
       "27    iqVDfE7XknJ6kDIoepT_xQ   \n",
       "28    nXKwzVKJCtIGd4HxXgjdnQ   \n",
       "29    AE7TfOrefJCI_qTvUoAezA   \n",
       "...                      ...   \n",
       "8252  Lo0dRIDKXc5mlE-coVZrtQ   \n",
       "8253  s1c4bXeV08ml2_iH4XLzhw   \n",
       "8254  HRjDpeJOL02ZqwrYgtHV_A   \n",
       "8255  KetHG4JpYO6a3mlYNCONRg   \n",
       "8256  9jBTMRNxvYyyHAlCGVO91Q   \n",
       "8257  YzHtlphJ-5LDtJdNzKs7Fg   \n",
       "8258  1g1rzWxU-2PQqI0-9ajFsA   \n",
       "8259  wEh9tQZxl5H1ke9MgSOW9g   \n",
       "8260  fVjeOZPjMmxyxtJuD31UOQ   \n",
       "8261  4SbNOPZZ2PG-c74gH1Tx9g   \n",
       "8262  _pw-OnDpCe9XM0rDVvTUMg   \n",
       "8263  OsBdaxPwMOeeH-8uGpJDZA   \n",
       "8264  Xq1_YvXpmg7edv2SzZuoIA   \n",
       "8265  jn3OgTqiQIFymRA9U0PTfQ   \n",
       "8266  z0dWiC4uFQTr9GBuVmui1g   \n",
       "8267  nKrK1aK2uWtL57Q3ShH6Hg   \n",
       "8268  LY5TW3Pvlfpprl3kpRE5_w   \n",
       "8269  Our6bzte5W1wlIeOu9luug   \n",
       "8270  g_QakYd7wB6DVqyv48nWcg   \n",
       "8271  DjJFnY7_Um0XhfazxlPO1Q   \n",
       "8272  s5roBvbA79SQaO4FHkJgGw   \n",
       "8273  T8xI1f3_yHzhrquCZh07Wg   \n",
       "8274  XK5FFbrKWMjRqc6ZbSTknw   \n",
       "8275  lfysf-HycrQ7Z02HuPqgKg   \n",
       "8276  rlG9WPf3h5MfNwHhpNsWjQ   \n",
       "8277  ptU2Fh1WmnaMBOjBxJZRwA   \n",
       "8278  C40IsC_MxEfX3-fOBNe7WA   \n",
       "8279  UxxPsF0oxTOideIpuppK8A   \n",
       "8280  cqIHyZ3Q0D4vBi-vb4mi-g   \n",
       "8281  1Nge1ObX93-y1AoXONt34A   \n",
       "\n",
       "                                           checkin_info     type  \n",
       "0     {'0-5': 1, '13-3': 1, '14-3': 2, '14-1': 2, '1...  checkin  \n",
       "1     {'20-3': 1, '0-5': 1, '10-6': 1, '0-0': 3, '1-...  checkin  \n",
       "2     {'8-2': 1, '13-4': 1, '6-4': 1, '19-0': 1, '6-...  checkin  \n",
       "3     {'13-4': 2, '10-1': 1, '12-5': 1, '10-5': 2, '...  checkin  \n",
       "4     {'13-4': 1, '16-2': 1, '14-5': 1, '12-5': 2, '...  checkin  \n",
       "5          {'18-4': 1, '19-3': 1, '15-5': 1, '18-5': 1}  checkin  \n",
       "6     {'10-6': 2, '13-6': 2, '18-1': 3, '12-5': 1, '...  checkin  \n",
       "7     {'13-4': 4, '15-2': 5, '13-3': 3, '21-1': 1, '...  checkin  \n",
       "8     {'17-3': 1, '10-6': 1, '16-5': 1, '18-6': 1, '...  checkin  \n",
       "9     {'8-2': 1, '22-6': 1, '12-5': 1, '17-2': 1, '1...  checkin  \n",
       "10    {'13-4': 3, '0-0': 1, '13-3': 1, '20-0': 5, '1...  checkin  \n",
       "11    {'12-3': 1, '16-4': 2, '10-4': 2, '16-5': 1, '...  checkin  \n",
       "12    {'12-5': 3, '11-3': 2, '21-1': 1, '20-4': 1, '...  checkin  \n",
       "13    {'19-0': 1, '18-1': 4, '12-5': 4, '20-5': 3, '...  checkin  \n",
       "14    {'4-2': 1, '6-4': 3, '6-3': 2, '3-4': 1, '13-3...  checkin  \n",
       "15    {'13-4': 1, '20-2': 1, '19-5': 1, '12-0': 2, '...  checkin  \n",
       "16    {'15-2': 3, '10-3': 3, '12-0': 1, '12-2': 3, '...  checkin  \n",
       "17    {'10-0': 1, '20-4': 1, '20-2': 1, '16-3': 1, '...  checkin  \n",
       "18                    {'14-1': 1, '11-2': 1, '11-4': 2}  checkin  \n",
       "19    {'10-6': 1, '12-5': 1, '10-5': 1, '15-0': 1, '...  checkin  \n",
       "20    {'6-4': 4, '7-2': 1, '12-5': 1, '10-5': 1, '12...  checkin  \n",
       "21    {'8-2': 1, '19-2': 1, '7-1': 1, '21-2': 1, '10...  checkin  \n",
       "22    {'22-6': 1, '18-1': 1, '12-5': 1, '22-5': 1, '...  checkin  \n",
       "23    {'13-4': 1, '7-6': 1, '22-6': 1, '17-1': 3, '1...  checkin  \n",
       "24    {'13-4': 1, '18-2': 1, '12-5': 2, '3-4': 2, '1...  checkin  \n",
       "25    {'13-4': 1, '16-3': 2, '20-3': 1, '12-0': 1, '...  checkin  \n",
       "26         {'17-3': 1, '18-4': 1, '18-0': 1, '18-6': 1}  checkin  \n",
       "27    {'10-6': 5, '20-0': 1, '11-2': 1, '8-3': 1, '1...  checkin  \n",
       "28    {'0-5': 1, '15-2': 1, '22-6': 1, '0-1': 1, '22...  checkin  \n",
       "29    {'17-4': 1, '11-4': 1, '13-4': 1, '12-4': 1, '...  checkin  \n",
       "...                                                 ...      ...  \n",
       "8252  {'8-3': 1, '13-4': 6, '6-4': 1, '13-3': 4, '16...  checkin  \n",
       "8253  {'12-3': 1, '9-5': 1, '11-4': 1, '13-5': 1, '1...  checkin  \n",
       "8254  {'16-6': 1, '21-0': 1, '11-0': 1, '12-5': 1, '...  checkin  \n",
       "8255                   {'16-2': 1, '9-1': 1, '15-4': 1}  checkin  \n",
       "8256  {'22-5': 1, '16-4': 1, '13-3': 1, '9-3': 1, '2...  checkin  \n",
       "8257  {'15-6': 3, '18-2': 2, '22-5': 2, '17-4': 1, '...  checkin  \n",
       "8258  {'16-4': 1, '16-6': 1, '14-0': 1, '11-2': 1, '...  checkin  \n",
       "8259  {'10-5': 1, '16-5': 1, '17-4': 1, '10-4': 1, '...  checkin  \n",
       "8260  {'14-5': 3, '7-1': 1, '19-0': 1, '19-2': 1, '2...  checkin  \n",
       "8261  {'17-4': 1, '12-1': 1, '15-2': 1, '8-5': 1, '1...  checkin  \n",
       "8262  {'4-2': 3, '1-6': 3, '18-1': 1, '6-3': 1, '8-4...  checkin  \n",
       "8263                  {'10-3': 1, '13-3': 1, '17-0': 1}  checkin  \n",
       "8264  {'13-4': 2, '13-3': 1, '20-0': 1, '14-3': 1, '...  checkin  \n",
       "8265  {'17-5': 3, '15-5': 2, '19-5': 2, '21-2': 1, '...  checkin  \n",
       "8266                   {'10-5': 1, '16-5': 1, '5-0': 1}  checkin  \n",
       "8267  {'13-4': 1, '13-6': 3, '20-6': 1, '14-3': 4, '...  checkin  \n",
       "8268  {'17-4': 1, '20-2': 1, '13-2': 1, '16-2': 1, '...  checkin  \n",
       "8269  {'13-4': 2, '15-2': 2, '22-5': 3, '13-3': 1, '...  checkin  \n",
       "8270  {'0-2': 1, '22-4': 1, '10-6': 1, '0-6': 1, '15...  checkin  \n",
       "8271  {'16-2': 1, '12-1': 1, '14-5': 1, '20-5': 1, '...  checkin  \n",
       "8272  {'19-0': 3, '21-2': 1, '17-1': 2, '16-0': 1, '...  checkin  \n",
       "8273  {'8-0': 1, '7-0': 1, '11-0': 2, '7-3': 1, '7-2...  checkin  \n",
       "8274  {'19-0': 1, '18-1': 1, '12-5': 1, '20-6': 2, '...  checkin  \n",
       "8275       {'14-5': 1, '13-5': 1, '11-5': 1, '15-4': 1}  checkin  \n",
       "8276  {'8-2': 1, '13-4': 1, '22-0': 1, '15-5': 1, '1...  checkin  \n",
       "8277  {'13-4': 1, '14-5': 1, '16-5': 1, '19-4': 1, '...  checkin  \n",
       "8278  {'7-0': 3, '10-6': 1, '7-1': 1, '5-0': 1, '7-3...  checkin  \n",
       "8279  {'13-4': 1, '6-4': 1, '15-2': 1, '19-5': 1, '2...  checkin  \n",
       "8280  {'0-5': 11, '22-6': 4, '0-1': 6, '18-5': 4, '1...  checkin  \n",
       "8281  {'8-2': 2, '18-1': 1, '12-5': 1, '17-1': 3, '1...  checkin  \n",
       "\n",
       "[8282 rows x 3 columns]"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "checkin_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>business_id</th>\n",
       "      <th>date</th>\n",
       "      <th>review_id</th>\n",
       "      <th>stars</th>\n",
       "      <th>text</th>\n",
       "      <th>type</th>\n",
       "      <th>user_id</th>\n",
       "      <th>votes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>9yKzy9PApeiPPOUJEtnvkg</td>\n",
       "      <td>2011-01-26</td>\n",
       "      <td>fWKvX83p0-ka4JS3dc6E5A</td>\n",
       "      <td>5</td>\n",
       "      <td>My wife took me here on my birthday for breakf...</td>\n",
       "      <td>review</td>\n",
       "      <td>rLtl8ZkDX5vH5nAx9C3q5Q</td>\n",
       "      <td>{'funny': 0, 'cool': 2, 'useful': 5}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ZRJwVLyzEJq1VAihDhYiow</td>\n",
       "      <td>2011-07-27</td>\n",
       "      <td>IjZ33sJrzXqU-0X6U8NwyA</td>\n",
       "      <td>5</td>\n",
       "      <td>I have no idea why some people give bad review...</td>\n",
       "      <td>review</td>\n",
       "      <td>0a2KyEL0d3Yb1V6aivbIuQ</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 0}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>6oRAC4uyJCsJl1X0WZpVSA</td>\n",
       "      <td>2012-06-14</td>\n",
       "      <td>IESLBzqUCLdSzSqm0eCSxQ</td>\n",
       "      <td>4</td>\n",
       "      <td>love the gyro plate. Rice is so good and I als...</td>\n",
       "      <td>review</td>\n",
       "      <td>0hT2KtfLiobPvh6cDC8JQg</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>_1QQZuf4zZOyFCvXc0o6Vg</td>\n",
       "      <td>2010-05-27</td>\n",
       "      <td>G-WvGaISbqqaMHlNnByodA</td>\n",
       "      <td>5</td>\n",
       "      <td>Rosie, Dakota, and I LOVE Chaparral Dog Park!!...</td>\n",
       "      <td>review</td>\n",
       "      <td>uZetl9T0NcROGOyFfughhg</td>\n",
       "      <td>{'funny': 0, 'cool': 1, 'useful': 2}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>6ozycU1RpktNG2-1BroVtw</td>\n",
       "      <td>2012-01-05</td>\n",
       "      <td>1uJFq2r5QfJG_6ExMRCaGw</td>\n",
       "      <td>5</td>\n",
       "      <td>General Manager Scott Petello is a good egg!!!...</td>\n",
       "      <td>review</td>\n",
       "      <td>vYmM4KTsC8ZfQBg-j5MWkw</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 0}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>-yxfBYGB6SEqszmxJxd97A</td>\n",
       "      <td>2007-12-13</td>\n",
       "      <td>m2CKSsepBCoRYWxiRUsxAg</td>\n",
       "      <td>4</td>\n",
       "      <td>Quiessence is, simply put, beautiful.  Full wi...</td>\n",
       "      <td>review</td>\n",
       "      <td>sqYN3lNgvPbPCTRsMFu27g</td>\n",
       "      <td>{'funny': 1, 'cool': 4, 'useful': 3}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>zp713qNhx8d9KCJJnrw1xA</td>\n",
       "      <td>2010-02-12</td>\n",
       "      <td>riFQ3vxNpP4rWLk_CSri2A</td>\n",
       "      <td>5</td>\n",
       "      <td>Drop what you're doing and drive here. After I...</td>\n",
       "      <td>review</td>\n",
       "      <td>wFweIWhv2fREZV_dYkz_1g</td>\n",
       "      <td>{'funny': 4, 'cool': 7, 'useful': 7}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>hW0Ne_HTHEAgGF1rAdmR-g</td>\n",
       "      <td>2012-07-12</td>\n",
       "      <td>JL7GXJ9u4YMx7Rzs05NfiQ</td>\n",
       "      <td>4</td>\n",
       "      <td>Luckily, I didn't have to travel far to make m...</td>\n",
       "      <td>review</td>\n",
       "      <td>1ieuYcKS7zeAv_U15AB13A</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>wNUea3IXZWD63bbOQaOH-g</td>\n",
       "      <td>2012-08-17</td>\n",
       "      <td>XtnfnYmnJYi71yIuGsXIUA</td>\n",
       "      <td>4</td>\n",
       "      <td>Definitely come for Happy hour! Prices are ama...</td>\n",
       "      <td>review</td>\n",
       "      <td>Vh_DlizgGhSqQh4qfZ2h6A</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 0}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>nMHhuYan8e3cONo3PornJA</td>\n",
       "      <td>2010-08-11</td>\n",
       "      <td>jJAIXA46pU1swYyRCdfXtQ</td>\n",
       "      <td>5</td>\n",
       "      <td>Nobuo shows his unique talents with everything...</td>\n",
       "      <td>review</td>\n",
       "      <td>sUNkXg8-KFtCMQDV6zRzQg</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>AsSCv0q_BWqIe3mX2JqsOQ</td>\n",
       "      <td>2010-06-16</td>\n",
       "      <td>E11jzpKz9Kw5K7fuARWfRw</td>\n",
       "      <td>5</td>\n",
       "      <td>The oldish man who owns the store is as sweet ...</td>\n",
       "      <td>review</td>\n",
       "      <td>-OMlS6yWkYjVldNhC31wYg</td>\n",
       "      <td>{'funny': 1, 'cool': 1, 'useful': 3}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>e9nN4XxjdHj4qtKCOPq_vg</td>\n",
       "      <td>2011-10-21</td>\n",
       "      <td>3rPt0LxF7rgmEUrznoH22w</td>\n",
       "      <td>5</td>\n",
       "      <td>Wonderful Vietnamese sandwich shoppe. Their ba...</td>\n",
       "      <td>review</td>\n",
       "      <td>C1rHp3dmepNea7XiouwB6Q</td>\n",
       "      <td>{'funny': 0, 'cool': 1, 'useful': 1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>h53YuCiIDfEFSJCQpk8v1g</td>\n",
       "      <td>2010-01-11</td>\n",
       "      <td>cGnKNX3I9rthE0-TH24-qA</td>\n",
       "      <td>5</td>\n",
       "      <td>They have a limited time thing going on right ...</td>\n",
       "      <td>review</td>\n",
       "      <td>UPtysDF6cUDUxq2KY-6Dcg</td>\n",
       "      <td>{'funny': 0, 'cool': 1, 'useful': 2}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>WGNIYMeXPyoWav1APUq7jA</td>\n",
       "      <td>2011-12-23</td>\n",
       "      <td>FvEEw1_OsrYdvwLV5Hrliw</td>\n",
       "      <td>4</td>\n",
       "      <td>Good tattoo shop. Clean space, multiple artist...</td>\n",
       "      <td>review</td>\n",
       "      <td>Xm8HXE1JHqscXe5BKf0GFQ</td>\n",
       "      <td>{'funny': 0, 'cool': 1, 'useful': 2}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>yc5AH9H71xJidA_J2mChLA</td>\n",
       "      <td>2010-05-20</td>\n",
       "      <td>pfUwBKYYmUXeiwrhDluQcw</td>\n",
       "      <td>4</td>\n",
       "      <td>I'm 2 weeks new to Phoenix. I looked up Irish ...</td>\n",
       "      <td>review</td>\n",
       "      <td>JOG-4G4e8ae3lx_szHtR8g</td>\n",
       "      <td>{'funny': 0, 'cool': 1, 'useful': 1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Vb9FPCEL6Ly24PNxLBaAFw</td>\n",
       "      <td>2011-03-20</td>\n",
       "      <td>HvqmdqWcerVWO3Gs6zbrOw</td>\n",
       "      <td>2</td>\n",
       "      <td>Was it worth the 21$ for a salad and small piz...</td>\n",
       "      <td>review</td>\n",
       "      <td>ylWOj2y7TV2e3yYeWhu2QA</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 2}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>supigcPNO9IKo6olaTNV-g</td>\n",
       "      <td>2008-10-12</td>\n",
       "      <td>HXP_0Ul-FCmA4f-k9CqvaQ</td>\n",
       "      <td>3</td>\n",
       "      <td>We went here on a Saturday afternoon and this ...</td>\n",
       "      <td>review</td>\n",
       "      <td>SBbftLzfYYKItOMFwOTIJg</td>\n",
       "      <td>{'funny': 2, 'cool': 3, 'useful': 4}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>O510Re68mOy9dU490JTKCg</td>\n",
       "      <td>2010-05-03</td>\n",
       "      <td>j4SIzrIy0WrmW4yr4--Khg</td>\n",
       "      <td>5</td>\n",
       "      <td>okay this is the best place EVER! i grew up sh...</td>\n",
       "      <td>review</td>\n",
       "      <td>u1KWcbPMvXFEEYkZZ0Yktg</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 0}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>b5cEoKR8iQliq-yT2_O0LQ</td>\n",
       "      <td>2009-03-06</td>\n",
       "      <td>v0cTd3PNpYCkTyGKSpOfGA</td>\n",
       "      <td>3</td>\n",
       "      <td>I met a friend for lunch yesterday. \\n\\nLoved ...</td>\n",
       "      <td>review</td>\n",
       "      <td>UsULgP4bKA8RMzs8dQzcsA</td>\n",
       "      <td>{'funny': 4, 'cool': 5, 'useful': 6}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>4JzzbSbK9wmlOBJZWYfuCg</td>\n",
       "      <td>2011-11-17</td>\n",
       "      <td>a0lCu-j2Sk_kHQsZi_eNgw</td>\n",
       "      <td>4</td>\n",
       "      <td>They've gotten better and better for me in the...</td>\n",
       "      <td>review</td>\n",
       "      <td>nDBly08j5URmrHQ2JCbyiw</td>\n",
       "      <td>{'funny': 1, 'cool': 1, 'useful': 1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>8FNO4D3eozpIjj0k3q5Zbg</td>\n",
       "      <td>2008-10-08</td>\n",
       "      <td>MuqugTuR5DdIPcZ2IVP3aQ</td>\n",
       "      <td>3</td>\n",
       "      <td>DVAP....\\n\\nYou have to go at least once in yo...</td>\n",
       "      <td>review</td>\n",
       "      <td>C6IOtaaYdLIT5fWd7ZYIuA</td>\n",
       "      <td>{'funny': 1, 'cool': 2, 'useful': 4}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>tdcjXyFLMKAsvRhURNOkCg</td>\n",
       "      <td>2011-06-28</td>\n",
       "      <td>LmuKVFh03Uz318VKnUWrxA</td>\n",
       "      <td>5</td>\n",
       "      <td>This place shouldn't even be reviewed - becaus...</td>\n",
       "      <td>review</td>\n",
       "      <td>YN3ZLOdg8kpnfbVcIhuEZA</td>\n",
       "      <td>{'funny': 2, 'cool': 1, 'useful': 1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>eFA9dqXT5EA_TrMgbo03QQ</td>\n",
       "      <td>2011-07-13</td>\n",
       "      <td>CQYc8hgKxV4enApDkx0IhA</td>\n",
       "      <td>5</td>\n",
       "      <td>first time my friend and I went there... it wa...</td>\n",
       "      <td>review</td>\n",
       "      <td>6lg55RIP23VhjYEBXJ8Njw</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 0}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>IJ0o6b8bJFAbG6MjGfBebQ</td>\n",
       "      <td>2010-09-05</td>\n",
       "      <td>Dx9sfFU6Zn0GYOckijom-g</td>\n",
       "      <td>1</td>\n",
       "      <td>U can go there n check the car out. If u wanna...</td>\n",
       "      <td>review</td>\n",
       "      <td>zRlQEDYd_HKp0VS3hnAffA</td>\n",
       "      <td>{'funny': 1, 'cool': 0, 'useful': 1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>JhupPnWfNlMJivnWB5druA</td>\n",
       "      <td>2011-05-22</td>\n",
       "      <td>cFtQnKzn2VDpBedy_TxlvA</td>\n",
       "      <td>5</td>\n",
       "      <td>I love this place! I have been coming here for...</td>\n",
       "      <td>review</td>\n",
       "      <td>13xj6FSvYO0rZVRv5XZp4w</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>wzP2yNpV5p04nh0injjymA</td>\n",
       "      <td>2010-05-26</td>\n",
       "      <td>ChBeixVZerfFkeO0McdlbA</td>\n",
       "      <td>4</td>\n",
       "      <td>This place is great.  A nice little ole' fashi...</td>\n",
       "      <td>review</td>\n",
       "      <td>rLtl8ZkDX5vH5nAx9C3q5Q</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 0}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>qjmCVYkwP-HDa35jwYucbQ</td>\n",
       "      <td>2013-01-03</td>\n",
       "      <td>kZ4TzrVX6qeF0OvrVTGVEw</td>\n",
       "      <td>5</td>\n",
       "      <td>I love love LOVE this place. My boss (who is i...</td>\n",
       "      <td>review</td>\n",
       "      <td>fpItLlgimq0nRltWOkuJJw</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 0}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>wct7rZKyZqZftzmAU-vhWQ</td>\n",
       "      <td>2008-03-21</td>\n",
       "      <td>B5h25WK28rJjx4KHm4gr7g</td>\n",
       "      <td>4</td>\n",
       "      <td>Not that my review will mean much given the mo...</td>\n",
       "      <td>review</td>\n",
       "      <td>RRTraCQw77EU4yZh0BBTag</td>\n",
       "      <td>{'funny': 1, 'cool': 2, 'useful': 4}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>vz2zQQSjy-NnnKLZzjjoxA</td>\n",
       "      <td>2011-03-30</td>\n",
       "      <td>Y_ERKao0J5WsRiCtlKSNSA</td>\n",
       "      <td>4</td>\n",
       "      <td>Came here for breakfast yesterday, it had been...</td>\n",
       "      <td>review</td>\n",
       "      <td>EP3cGJvYiuOwumerwADplg</td>\n",
       "      <td>{'funny': 1, 'cool': 1, 'useful': 1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>i213sY5rhkfCO8cD-FPr1A</td>\n",
       "      <td>2012-07-12</td>\n",
       "      <td>hre97jjSwon4bn1muHKOJg</td>\n",
       "      <td>4</td>\n",
       "      <td>Always reliably good.  Great beer selection as...</td>\n",
       "      <td>review</td>\n",
       "      <td>kpbhy1zPewGDmdNfNqQp-g</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229877</th>\n",
       "      <td>cVejKU_SrdbvzIbQ4oPV0A</td>\n",
       "      <td>2011-01-24</td>\n",
       "      <td>JZ2fbTjFq2IBNv1YW-cK-Q</td>\n",
       "      <td>3</td>\n",
       "      <td>I should start by saying that \"American Mexica...</td>\n",
       "      <td>review</td>\n",
       "      <td>e9d9EQqOd2-NlX8WFx0aEg</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229878</th>\n",
       "      <td>lktu5JPDlQUG-7cV7gOzDQ</td>\n",
       "      <td>2011-08-12</td>\n",
       "      <td>1WZL0SrFfcniJk32dFVAEQ</td>\n",
       "      <td>5</td>\n",
       "      <td>Always amazing</td>\n",
       "      <td>review</td>\n",
       "      <td>ayKW9eWwGFcrtJaHcwZUCw</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 0}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229879</th>\n",
       "      <td>N_6bV3c3JagKW7sD3X9ldA</td>\n",
       "      <td>2009-06-02</td>\n",
       "      <td>C1a9VtS3PrJ7m3Ef7xTvyQ</td>\n",
       "      <td>5</td>\n",
       "      <td>By far the best burger I have had in Phoenix.\\...</td>\n",
       "      <td>review</td>\n",
       "      <td>2FiNCj5rM3nF0qgaWf86Gg</td>\n",
       "      <td>{'funny': 1, 'cool': 1, 'useful': 1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229880</th>\n",
       "      <td>wN_wAXWg8W94v04eqijy6g</td>\n",
       "      <td>2012-04-10</td>\n",
       "      <td>gjASLbnYV1K6HxRfIb7luA</td>\n",
       "      <td>4</td>\n",
       "      <td>Good tacos, good service and kid friendly. We'...</td>\n",
       "      <td>review</td>\n",
       "      <td>NfyrHToGY6aJu22U9oS8Xg</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229881</th>\n",
       "      <td>rwQIBAM_kHtVl1Ks8Flexw</td>\n",
       "      <td>2010-08-28</td>\n",
       "      <td>payXdGJQO9rJlsJRrMwRDA</td>\n",
       "      <td>1</td>\n",
       "      <td>We used the Restaurant.com $25 off of $35 or m...</td>\n",
       "      <td>review</td>\n",
       "      <td>KucBnMrhalzxnD9AWrxwYQ</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 0}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229882</th>\n",
       "      <td>FUI-hWH_bpis7AKZTWenUQ</td>\n",
       "      <td>2011-01-03</td>\n",
       "      <td>bYNRa1NfCruNo0nL84PzIg</td>\n",
       "      <td>5</td>\n",
       "      <td>Ticoz is a new find for us. I've been wanting ...</td>\n",
       "      <td>review</td>\n",
       "      <td>Sa64rQmghfE9i17_dRIDyw</td>\n",
       "      <td>{'funny': 0, 'cool': 2, 'useful': 3}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229883</th>\n",
       "      <td>z7W0sUbrVi2k6R2BR5jtzw</td>\n",
       "      <td>2011-04-24</td>\n",
       "      <td>Amjc54cchXqHO8I_h-e0Fw</td>\n",
       "      <td>4</td>\n",
       "      <td>Every now and then a movie comes along and cha...</td>\n",
       "      <td>review</td>\n",
       "      <td>8JC-Yb3UDUv2FUl5ym1nVg</td>\n",
       "      <td>{'funny': 3, 'cool': 2, 'useful': 3}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229884</th>\n",
       "      <td>sbnCG3-CouwIu0jsApfCsQ</td>\n",
       "      <td>2010-02-26</td>\n",
       "      <td>1QaTK1mNeHEUFQ8BLwmwBg</td>\n",
       "      <td>1</td>\n",
       "      <td>We ate at the Arrowhead Mall Johnny Rockets to...</td>\n",
       "      <td>review</td>\n",
       "      <td>mlY2rj2PBhK6-nlWjDMQIg</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 0}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229885</th>\n",
       "      <td>WQc22qucCCtOytbx5CHqbw</td>\n",
       "      <td>2011-02-26</td>\n",
       "      <td>TzRaZKK9jWLOJ34RUkwS2Q</td>\n",
       "      <td>3</td>\n",
       "      <td>We stayed at the Westin during our stay in Sco...</td>\n",
       "      <td>review</td>\n",
       "      <td>9yX1qVa2PJtd-yx9M5xuFg</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229886</th>\n",
       "      <td>tI600wWPFDc4bxEvrbBpRQ</td>\n",
       "      <td>2010-01-30</td>\n",
       "      <td>4YXC7JT2vfRRJLGTGWq20Q</td>\n",
       "      <td>1</td>\n",
       "      <td>Every time I've been here, there is a problem....</td>\n",
       "      <td>review</td>\n",
       "      <td>IC1rNlFJSzEJK8AFfDlfcg</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229887</th>\n",
       "      <td>Ez2MFsVT5lJZ05yvK_0AXQ</td>\n",
       "      <td>2010-06-23</td>\n",
       "      <td>NUmpXW7xOyq8Pfhrut2W-w</td>\n",
       "      <td>5</td>\n",
       "      <td>Although this joint is by far one of the best ...</td>\n",
       "      <td>review</td>\n",
       "      <td>SC_bFYaDgDub7tDjKCvV_g</td>\n",
       "      <td>{'funny': 2, 'cool': 2, 'useful': 3}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229888</th>\n",
       "      <td>hWhVP-28LYP3llaMlAJ_JA</td>\n",
       "      <td>2011-01-28</td>\n",
       "      <td>0YP-uHK74b7WsCFtNXfGsg</td>\n",
       "      <td>5</td>\n",
       "      <td>This is the real-deal Mexican food in Arizona....</td>\n",
       "      <td>review</td>\n",
       "      <td>6TnX7mzI-jfgK6teWqIS9Q</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 0}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229889</th>\n",
       "      <td>cE99Cjrj2YXSGs4MECb86w</td>\n",
       "      <td>2007-10-19</td>\n",
       "      <td>ywQkCyv3j6vX3_tno94elg</td>\n",
       "      <td>3</td>\n",
       "      <td>You want a monster sandwich that will challeng...</td>\n",
       "      <td>review</td>\n",
       "      <td>tlSSQwfHYJany7wPoTH46A</td>\n",
       "      <td>{'funny': 7, 'cool': 2, 'useful': 6}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229890</th>\n",
       "      <td>pS19vd7pkIsd4nXT-hUUNQ</td>\n",
       "      <td>2011-06-03</td>\n",
       "      <td>B9O7fq9_Iy-iPohqrTAeFQ</td>\n",
       "      <td>5</td>\n",
       "      <td>One of my favorite luxuries ~ although it's ac...</td>\n",
       "      <td>review</td>\n",
       "      <td>1X5BItB--PO2zn69nyfvLw</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 0}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229891</th>\n",
       "      <td>fPExBO1aXA5c4uwlHFyx2Q</td>\n",
       "      <td>2012-04-06</td>\n",
       "      <td>uxfey6plUULyFQvsEQQ3SA</td>\n",
       "      <td>5</td>\n",
       "      <td>First time tonight,  went on reccommendation o...</td>\n",
       "      <td>review</td>\n",
       "      <td>zgOeUiJnNMLOocpYN4m2VQ</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229892</th>\n",
       "      <td>ybXlbfOjrKDdz5NoC-G9Gw</td>\n",
       "      <td>2012-07-15</td>\n",
       "      <td>0Ben4vrARnRyQX2s1XGqyw</td>\n",
       "      <td>4</td>\n",
       "      <td>Great music and fun atmosphere! \\n\\nParking is...</td>\n",
       "      <td>review</td>\n",
       "      <td>hs8t_DMnNNpf_wXtFE2xpw</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229893</th>\n",
       "      <td>c8XlQvVNwKhH9BOHEObtNQ</td>\n",
       "      <td>2011-12-16</td>\n",
       "      <td>ENmRNlah1ex6xh6iCz13Ng</td>\n",
       "      <td>4</td>\n",
       "      <td>Went for lunch at Claim Jumper, let me tell yo...</td>\n",
       "      <td>review</td>\n",
       "      <td>8dbRf1UsWp2ktXHZ6Zv06w</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 0}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229894</th>\n",
       "      <td>Tt6DYs0TyERWHWW5xiRL_A</td>\n",
       "      <td>2009-07-20</td>\n",
       "      <td>TpZdxtW9C4vUCONsRcWXNQ</td>\n",
       "      <td>5</td>\n",
       "      <td>I have passed by Yen Sushi &amp; Sake Bar several ...</td>\n",
       "      <td>review</td>\n",
       "      <td>t7FjQwcAY2wYJMgmfVrvKQ</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229895</th>\n",
       "      <td>6imLt53br7SJ3av07jjH7w</td>\n",
       "      <td>2010-06-10</td>\n",
       "      <td>JIfpkIHovOr7wO4c5chemQ</td>\n",
       "      <td>4</td>\n",
       "      <td>After reading Yelp reviews, I was looking forw...</td>\n",
       "      <td>review</td>\n",
       "      <td>Lk9_kIKXGxnfcfQ6coI9ig</td>\n",
       "      <td>{'funny': 1, 'cool': 1, 'useful': 0}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229896</th>\n",
       "      <td>uEJQSIjWui-TDWXaGlcqyQ</td>\n",
       "      <td>2011-11-25</td>\n",
       "      <td>6Ea1Utcv3u_mON7LgNBLOg</td>\n",
       "      <td>2</td>\n",
       "      <td>Pros:\\n-Great tasting kool-aid, but then again...</td>\n",
       "      <td>review</td>\n",
       "      <td>oJTwHtNlipl1iqaFV7HHZA</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229897</th>\n",
       "      <td>j5HLcBru7FEirYJPbKFVWA</td>\n",
       "      <td>2009-10-07</td>\n",
       "      <td>PzVTbuN_MP_wx9MwQnIZDA</td>\n",
       "      <td>2</td>\n",
       "      <td>No, we just stopped serving breakfast.\\nThe on...</td>\n",
       "      <td>review</td>\n",
       "      <td>UoBfwbXaixelZBghbJ2cSg</td>\n",
       "      <td>{'funny': 2, 'cool': 3, 'useful': 4}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229898</th>\n",
       "      <td>FV0BkoGOd3Yu_eJnXY15ZA</td>\n",
       "      <td>2010-06-02</td>\n",
       "      <td>AoAQ9sqH9AandCGPNJ3mGw</td>\n",
       "      <td>2</td>\n",
       "      <td>I have been wanting to try Cowboy Ciao for a w...</td>\n",
       "      <td>review</td>\n",
       "      <td>tTO6rv0Z9aNNYmmZU_BR4g</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 0}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229899</th>\n",
       "      <td>Li5LOL873Ep8HoPRML18sw</td>\n",
       "      <td>2008-12-05</td>\n",
       "      <td>Cmkb7SDJWYtWZXgAfOwJkQ</td>\n",
       "      <td>5</td>\n",
       "      <td>Los Olivos is great!  I am a huge fan of any c...</td>\n",
       "      <td>review</td>\n",
       "      <td>Ak2jlINPRk9dWWazWUW2hA</td>\n",
       "      <td>{'funny': 0, 'cool': 1, 'useful': 1}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229900</th>\n",
       "      <td>Y-9dJvw-J2d9QKfuL7mKgA</td>\n",
       "      <td>2008-02-03</td>\n",
       "      <td>A1Y7yT_kgj391Xa1jcKzmw</td>\n",
       "      <td>1</td>\n",
       "      <td>The coffee was good.\\nI had the two egg breakf...</td>\n",
       "      <td>review</td>\n",
       "      <td>CAlxnkAuqNetlUmWtCQ_eQ</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 2}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229901</th>\n",
       "      <td>C1tH3sEQra33EOTk56Eu1Q</td>\n",
       "      <td>2008-09-11</td>\n",
       "      <td>ZQI8AUx7H_g0UJxX604brQ</td>\n",
       "      <td>3</td>\n",
       "      <td>I'm sorry to this but I must admit I was prett...</td>\n",
       "      <td>review</td>\n",
       "      <td>q9XgOylNsSbqZqF_SO3-OQ</td>\n",
       "      <td>{'funny': 1, 'cool': 4, 'useful': 2}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229902</th>\n",
       "      <td>vnffHkFJbmd-J3OaBbK2Eg</td>\n",
       "      <td>2011-04-14</td>\n",
       "      <td>f9JaiNg_FMoPNWxt7MlbZQ</td>\n",
       "      <td>2</td>\n",
       "      <td>I really wanted to like this place because it'...</td>\n",
       "      <td>review</td>\n",
       "      <td>6e7pZofhDuIlD_rX2oYirQ</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 0}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229903</th>\n",
       "      <td>l5oUrgQ190l8CcN8uzd_pA</td>\n",
       "      <td>2011-01-23</td>\n",
       "      <td>QDWRP1pW5r0huIBAoGmFyg</td>\n",
       "      <td>1</td>\n",
       "      <td>My husband I stayed here for two nights.  Of c...</td>\n",
       "      <td>review</td>\n",
       "      <td>dDNfSFT0VApxPmURclX6_g</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 2}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229904</th>\n",
       "      <td>-EctXOb3B7T177jGYUhjVA</td>\n",
       "      <td>2010-10-11</td>\n",
       "      <td>JmR3yk7JlS1LVVxtIc3xBQ</td>\n",
       "      <td>4</td>\n",
       "      <td>Cool atmosphere. A lot of beers on tap and goo...</td>\n",
       "      <td>review</td>\n",
       "      <td>M5wHt6Odh1k5v0tIjqd8DQ</td>\n",
       "      <td>{'funny': 0, 'cool': 0, 'useful': 0}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229905</th>\n",
       "      <td>YQvg0JCGRFUkb6reMMf3Iw</td>\n",
       "      <td>2011-01-18</td>\n",
       "      <td>z5b2p5TbCg0uaIiIe8n62w</td>\n",
       "      <td>3</td>\n",
       "      <td>I have to take a star off for the spotty servi...</td>\n",
       "      <td>review</td>\n",
       "      <td>jopndPrv-H5KW2CfScnw9A</td>\n",
       "      <td>{'funny': 1, 'cool': 0, 'useful': 2}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229906</th>\n",
       "      <td>gKxOZvQTTd5hpFa3r5igGQ</td>\n",
       "      <td>2010-08-14</td>\n",
       "      <td>QM1rFJsW-ZJoCHbgsysKaw</td>\n",
       "      <td>5</td>\n",
       "      <td>So cool, yo.</td>\n",
       "      <td>review</td>\n",
       "      <td>mbRUG6h0Mgb2XIJvscIoMg</td>\n",
       "      <td>{'funny': 1, 'cool': 1, 'useful': 0}</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>229907 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   business_id       date               review_id  stars  \\\n",
       "0       9yKzy9PApeiPPOUJEtnvkg 2011-01-26  fWKvX83p0-ka4JS3dc6E5A      5   \n",
       "1       ZRJwVLyzEJq1VAihDhYiow 2011-07-27  IjZ33sJrzXqU-0X6U8NwyA      5   \n",
       "2       6oRAC4uyJCsJl1X0WZpVSA 2012-06-14  IESLBzqUCLdSzSqm0eCSxQ      4   \n",
       "3       _1QQZuf4zZOyFCvXc0o6Vg 2010-05-27  G-WvGaISbqqaMHlNnByodA      5   \n",
       "4       6ozycU1RpktNG2-1BroVtw 2012-01-05  1uJFq2r5QfJG_6ExMRCaGw      5   \n",
       "5       -yxfBYGB6SEqszmxJxd97A 2007-12-13  m2CKSsepBCoRYWxiRUsxAg      4   \n",
       "6       zp713qNhx8d9KCJJnrw1xA 2010-02-12  riFQ3vxNpP4rWLk_CSri2A      5   \n",
       "7       hW0Ne_HTHEAgGF1rAdmR-g 2012-07-12  JL7GXJ9u4YMx7Rzs05NfiQ      4   \n",
       "8       wNUea3IXZWD63bbOQaOH-g 2012-08-17  XtnfnYmnJYi71yIuGsXIUA      4   \n",
       "9       nMHhuYan8e3cONo3PornJA 2010-08-11  jJAIXA46pU1swYyRCdfXtQ      5   \n",
       "10      AsSCv0q_BWqIe3mX2JqsOQ 2010-06-16  E11jzpKz9Kw5K7fuARWfRw      5   \n",
       "11      e9nN4XxjdHj4qtKCOPq_vg 2011-10-21  3rPt0LxF7rgmEUrznoH22w      5   \n",
       "12      h53YuCiIDfEFSJCQpk8v1g 2010-01-11  cGnKNX3I9rthE0-TH24-qA      5   \n",
       "13      WGNIYMeXPyoWav1APUq7jA 2011-12-23  FvEEw1_OsrYdvwLV5Hrliw      4   \n",
       "14      yc5AH9H71xJidA_J2mChLA 2010-05-20  pfUwBKYYmUXeiwrhDluQcw      4   \n",
       "15      Vb9FPCEL6Ly24PNxLBaAFw 2011-03-20  HvqmdqWcerVWO3Gs6zbrOw      2   \n",
       "16      supigcPNO9IKo6olaTNV-g 2008-10-12  HXP_0Ul-FCmA4f-k9CqvaQ      3   \n",
       "17      O510Re68mOy9dU490JTKCg 2010-05-03  j4SIzrIy0WrmW4yr4--Khg      5   \n",
       "18      b5cEoKR8iQliq-yT2_O0LQ 2009-03-06  v0cTd3PNpYCkTyGKSpOfGA      3   \n",
       "19      4JzzbSbK9wmlOBJZWYfuCg 2011-11-17  a0lCu-j2Sk_kHQsZi_eNgw      4   \n",
       "20      8FNO4D3eozpIjj0k3q5Zbg 2008-10-08  MuqugTuR5DdIPcZ2IVP3aQ      3   \n",
       "21      tdcjXyFLMKAsvRhURNOkCg 2011-06-28  LmuKVFh03Uz318VKnUWrxA      5   \n",
       "22      eFA9dqXT5EA_TrMgbo03QQ 2011-07-13  CQYc8hgKxV4enApDkx0IhA      5   \n",
       "23      IJ0o6b8bJFAbG6MjGfBebQ 2010-09-05  Dx9sfFU6Zn0GYOckijom-g      1   \n",
       "24      JhupPnWfNlMJivnWB5druA 2011-05-22  cFtQnKzn2VDpBedy_TxlvA      5   \n",
       "25      wzP2yNpV5p04nh0injjymA 2010-05-26  ChBeixVZerfFkeO0McdlbA      4   \n",
       "26      qjmCVYkwP-HDa35jwYucbQ 2013-01-03  kZ4TzrVX6qeF0OvrVTGVEw      5   \n",
       "27      wct7rZKyZqZftzmAU-vhWQ 2008-03-21  B5h25WK28rJjx4KHm4gr7g      4   \n",
       "28      vz2zQQSjy-NnnKLZzjjoxA 2011-03-30  Y_ERKao0J5WsRiCtlKSNSA      4   \n",
       "29      i213sY5rhkfCO8cD-FPr1A 2012-07-12  hre97jjSwon4bn1muHKOJg      4   \n",
       "...                        ...        ...                     ...    ...   \n",
       "229877  cVejKU_SrdbvzIbQ4oPV0A 2011-01-24  JZ2fbTjFq2IBNv1YW-cK-Q      3   \n",
       "229878  lktu5JPDlQUG-7cV7gOzDQ 2011-08-12  1WZL0SrFfcniJk32dFVAEQ      5   \n",
       "229879  N_6bV3c3JagKW7sD3X9ldA 2009-06-02  C1a9VtS3PrJ7m3Ef7xTvyQ      5   \n",
       "229880  wN_wAXWg8W94v04eqijy6g 2012-04-10  gjASLbnYV1K6HxRfIb7luA      4   \n",
       "229881  rwQIBAM_kHtVl1Ks8Flexw 2010-08-28  payXdGJQO9rJlsJRrMwRDA      1   \n",
       "229882  FUI-hWH_bpis7AKZTWenUQ 2011-01-03  bYNRa1NfCruNo0nL84PzIg      5   \n",
       "229883  z7W0sUbrVi2k6R2BR5jtzw 2011-04-24  Amjc54cchXqHO8I_h-e0Fw      4   \n",
       "229884  sbnCG3-CouwIu0jsApfCsQ 2010-02-26  1QaTK1mNeHEUFQ8BLwmwBg      1   \n",
       "229885  WQc22qucCCtOytbx5CHqbw 2011-02-26  TzRaZKK9jWLOJ34RUkwS2Q      3   \n",
       "229886  tI600wWPFDc4bxEvrbBpRQ 2010-01-30  4YXC7JT2vfRRJLGTGWq20Q      1   \n",
       "229887  Ez2MFsVT5lJZ05yvK_0AXQ 2010-06-23  NUmpXW7xOyq8Pfhrut2W-w      5   \n",
       "229888  hWhVP-28LYP3llaMlAJ_JA 2011-01-28  0YP-uHK74b7WsCFtNXfGsg      5   \n",
       "229889  cE99Cjrj2YXSGs4MECb86w 2007-10-19  ywQkCyv3j6vX3_tno94elg      3   \n",
       "229890  pS19vd7pkIsd4nXT-hUUNQ 2011-06-03  B9O7fq9_Iy-iPohqrTAeFQ      5   \n",
       "229891  fPExBO1aXA5c4uwlHFyx2Q 2012-04-06  uxfey6plUULyFQvsEQQ3SA      5   \n",
       "229892  ybXlbfOjrKDdz5NoC-G9Gw 2012-07-15  0Ben4vrARnRyQX2s1XGqyw      4   \n",
       "229893  c8XlQvVNwKhH9BOHEObtNQ 2011-12-16  ENmRNlah1ex6xh6iCz13Ng      4   \n",
       "229894  Tt6DYs0TyERWHWW5xiRL_A 2009-07-20  TpZdxtW9C4vUCONsRcWXNQ      5   \n",
       "229895  6imLt53br7SJ3av07jjH7w 2010-06-10  JIfpkIHovOr7wO4c5chemQ      4   \n",
       "229896  uEJQSIjWui-TDWXaGlcqyQ 2011-11-25  6Ea1Utcv3u_mON7LgNBLOg      2   \n",
       "229897  j5HLcBru7FEirYJPbKFVWA 2009-10-07  PzVTbuN_MP_wx9MwQnIZDA      2   \n",
       "229898  FV0BkoGOd3Yu_eJnXY15ZA 2010-06-02  AoAQ9sqH9AandCGPNJ3mGw      2   \n",
       "229899  Li5LOL873Ep8HoPRML18sw 2008-12-05  Cmkb7SDJWYtWZXgAfOwJkQ      5   \n",
       "229900  Y-9dJvw-J2d9QKfuL7mKgA 2008-02-03  A1Y7yT_kgj391Xa1jcKzmw      1   \n",
       "229901  C1tH3sEQra33EOTk56Eu1Q 2008-09-11  ZQI8AUx7H_g0UJxX604brQ      3   \n",
       "229902  vnffHkFJbmd-J3OaBbK2Eg 2011-04-14  f9JaiNg_FMoPNWxt7MlbZQ      2   \n",
       "229903  l5oUrgQ190l8CcN8uzd_pA 2011-01-23  QDWRP1pW5r0huIBAoGmFyg      1   \n",
       "229904  -EctXOb3B7T177jGYUhjVA 2010-10-11  JmR3yk7JlS1LVVxtIc3xBQ      4   \n",
       "229905  YQvg0JCGRFUkb6reMMf3Iw 2011-01-18  z5b2p5TbCg0uaIiIe8n62w      3   \n",
       "229906  gKxOZvQTTd5hpFa3r5igGQ 2010-08-14  QM1rFJsW-ZJoCHbgsysKaw      5   \n",
       "\n",
       "                                                     text    type  \\\n",
       "0       My wife took me here on my birthday for breakf...  review   \n",
       "1       I have no idea why some people give bad review...  review   \n",
       "2       love the gyro plate. Rice is so good and I als...  review   \n",
       "3       Rosie, Dakota, and I LOVE Chaparral Dog Park!!...  review   \n",
       "4       General Manager Scott Petello is a good egg!!!...  review   \n",
       "5       Quiessence is, simply put, beautiful.  Full wi...  review   \n",
       "6       Drop what you're doing and drive here. After I...  review   \n",
       "7       Luckily, I didn't have to travel far to make m...  review   \n",
       "8       Definitely come for Happy hour! Prices are ama...  review   \n",
       "9       Nobuo shows his unique talents with everything...  review   \n",
       "10      The oldish man who owns the store is as sweet ...  review   \n",
       "11      Wonderful Vietnamese sandwich shoppe. Their ba...  review   \n",
       "12      They have a limited time thing going on right ...  review   \n",
       "13      Good tattoo shop. Clean space, multiple artist...  review   \n",
       "14      I'm 2 weeks new to Phoenix. I looked up Irish ...  review   \n",
       "15      Was it worth the 21$ for a salad and small piz...  review   \n",
       "16      We went here on a Saturday afternoon and this ...  review   \n",
       "17      okay this is the best place EVER! i grew up sh...  review   \n",
       "18      I met a friend for lunch yesterday. \\n\\nLoved ...  review   \n",
       "19      They've gotten better and better for me in the...  review   \n",
       "20      DVAP....\\n\\nYou have to go at least once in yo...  review   \n",
       "21      This place shouldn't even be reviewed - becaus...  review   \n",
       "22      first time my friend and I went there... it wa...  review   \n",
       "23      U can go there n check the car out. If u wanna...  review   \n",
       "24      I love this place! I have been coming here for...  review   \n",
       "25      This place is great.  A nice little ole' fashi...  review   \n",
       "26      I love love LOVE this place. My boss (who is i...  review   \n",
       "27      Not that my review will mean much given the mo...  review   \n",
       "28      Came here for breakfast yesterday, it had been...  review   \n",
       "29      Always reliably good.  Great beer selection as...  review   \n",
       "...                                                   ...     ...   \n",
       "229877  I should start by saying that \"American Mexica...  review   \n",
       "229878                                     Always amazing  review   \n",
       "229879  By far the best burger I have had in Phoenix.\\...  review   \n",
       "229880  Good tacos, good service and kid friendly. We'...  review   \n",
       "229881  We used the Restaurant.com $25 off of $35 or m...  review   \n",
       "229882  Ticoz is a new find for us. I've been wanting ...  review   \n",
       "229883  Every now and then a movie comes along and cha...  review   \n",
       "229884  We ate at the Arrowhead Mall Johnny Rockets to...  review   \n",
       "229885  We stayed at the Westin during our stay in Sco...  review   \n",
       "229886  Every time I've been here, there is a problem....  review   \n",
       "229887  Although this joint is by far one of the best ...  review   \n",
       "229888  This is the real-deal Mexican food in Arizona....  review   \n",
       "229889  You want a monster sandwich that will challeng...  review   \n",
       "229890  One of my favorite luxuries ~ although it's ac...  review   \n",
       "229891  First time tonight,  went on reccommendation o...  review   \n",
       "229892  Great music and fun atmosphere! \\n\\nParking is...  review   \n",
       "229893  Went for lunch at Claim Jumper, let me tell yo...  review   \n",
       "229894  I have passed by Yen Sushi & Sake Bar several ...  review   \n",
       "229895  After reading Yelp reviews, I was looking forw...  review   \n",
       "229896  Pros:\\n-Great tasting kool-aid, but then again...  review   \n",
       "229897  No, we just stopped serving breakfast.\\nThe on...  review   \n",
       "229898  I have been wanting to try Cowboy Ciao for a w...  review   \n",
       "229899  Los Olivos is great!  I am a huge fan of any c...  review   \n",
       "229900  The coffee was good.\\nI had the two egg breakf...  review   \n",
       "229901  I'm sorry to this but I must admit I was prett...  review   \n",
       "229902  I really wanted to like this place because it'...  review   \n",
       "229903  My husband I stayed here for two nights.  Of c...  review   \n",
       "229904  Cool atmosphere. A lot of beers on tap and goo...  review   \n",
       "229905  I have to take a star off for the spotty servi...  review   \n",
       "229906                                       So cool, yo.  review   \n",
       "\n",
       "                       user_id                                 votes  \n",
       "0       rLtl8ZkDX5vH5nAx9C3q5Q  {'funny': 0, 'cool': 2, 'useful': 5}  \n",
       "1       0a2KyEL0d3Yb1V6aivbIuQ  {'funny': 0, 'cool': 0, 'useful': 0}  \n",
       "2       0hT2KtfLiobPvh6cDC8JQg  {'funny': 0, 'cool': 0, 'useful': 1}  \n",
       "3       uZetl9T0NcROGOyFfughhg  {'funny': 0, 'cool': 1, 'useful': 2}  \n",
       "4       vYmM4KTsC8ZfQBg-j5MWkw  {'funny': 0, 'cool': 0, 'useful': 0}  \n",
       "5       sqYN3lNgvPbPCTRsMFu27g  {'funny': 1, 'cool': 4, 'useful': 3}  \n",
       "6       wFweIWhv2fREZV_dYkz_1g  {'funny': 4, 'cool': 7, 'useful': 7}  \n",
       "7       1ieuYcKS7zeAv_U15AB13A  {'funny': 0, 'cool': 0, 'useful': 1}  \n",
       "8       Vh_DlizgGhSqQh4qfZ2h6A  {'funny': 0, 'cool': 0, 'useful': 0}  \n",
       "9       sUNkXg8-KFtCMQDV6zRzQg  {'funny': 0, 'cool': 0, 'useful': 1}  \n",
       "10      -OMlS6yWkYjVldNhC31wYg  {'funny': 1, 'cool': 1, 'useful': 3}  \n",
       "11      C1rHp3dmepNea7XiouwB6Q  {'funny': 0, 'cool': 1, 'useful': 1}  \n",
       "12      UPtysDF6cUDUxq2KY-6Dcg  {'funny': 0, 'cool': 1, 'useful': 2}  \n",
       "13      Xm8HXE1JHqscXe5BKf0GFQ  {'funny': 0, 'cool': 1, 'useful': 2}  \n",
       "14      JOG-4G4e8ae3lx_szHtR8g  {'funny': 0, 'cool': 1, 'useful': 1}  \n",
       "15      ylWOj2y7TV2e3yYeWhu2QA  {'funny': 0, 'cool': 0, 'useful': 2}  \n",
       "16      SBbftLzfYYKItOMFwOTIJg  {'funny': 2, 'cool': 3, 'useful': 4}  \n",
       "17      u1KWcbPMvXFEEYkZZ0Yktg  {'funny': 0, 'cool': 0, 'useful': 0}  \n",
       "18      UsULgP4bKA8RMzs8dQzcsA  {'funny': 4, 'cool': 5, 'useful': 6}  \n",
       "19      nDBly08j5URmrHQ2JCbyiw  {'funny': 1, 'cool': 1, 'useful': 1}  \n",
       "20      C6IOtaaYdLIT5fWd7ZYIuA  {'funny': 1, 'cool': 2, 'useful': 4}  \n",
       "21      YN3ZLOdg8kpnfbVcIhuEZA  {'funny': 2, 'cool': 1, 'useful': 1}  \n",
       "22      6lg55RIP23VhjYEBXJ8Njw  {'funny': 0, 'cool': 0, 'useful': 0}  \n",
       "23      zRlQEDYd_HKp0VS3hnAffA  {'funny': 1, 'cool': 0, 'useful': 1}  \n",
       "24      13xj6FSvYO0rZVRv5XZp4w  {'funny': 0, 'cool': 0, 'useful': 1}  \n",
       "25      rLtl8ZkDX5vH5nAx9C3q5Q  {'funny': 0, 'cool': 0, 'useful': 0}  \n",
       "26      fpItLlgimq0nRltWOkuJJw  {'funny': 0, 'cool': 0, 'useful': 0}  \n",
       "27      RRTraCQw77EU4yZh0BBTag  {'funny': 1, 'cool': 2, 'useful': 4}  \n",
       "28      EP3cGJvYiuOwumerwADplg  {'funny': 1, 'cool': 1, 'useful': 1}  \n",
       "29      kpbhy1zPewGDmdNfNqQp-g  {'funny': 0, 'cool': 0, 'useful': 1}  \n",
       "...                        ...                                   ...  \n",
       "229877  e9d9EQqOd2-NlX8WFx0aEg  {'funny': 0, 'cool': 0, 'useful': 1}  \n",
       "229878  ayKW9eWwGFcrtJaHcwZUCw  {'funny': 0, 'cool': 0, 'useful': 0}  \n",
       "229879  2FiNCj5rM3nF0qgaWf86Gg  {'funny': 1, 'cool': 1, 'useful': 1}  \n",
       "229880  NfyrHToGY6aJu22U9oS8Xg  {'funny': 0, 'cool': 0, 'useful': 1}  \n",
       "229881  KucBnMrhalzxnD9AWrxwYQ  {'funny': 0, 'cool': 0, 'useful': 0}  \n",
       "229882  Sa64rQmghfE9i17_dRIDyw  {'funny': 0, 'cool': 2, 'useful': 3}  \n",
       "229883  8JC-Yb3UDUv2FUl5ym1nVg  {'funny': 3, 'cool': 2, 'useful': 3}  \n",
       "229884  mlY2rj2PBhK6-nlWjDMQIg  {'funny': 0, 'cool': 0, 'useful': 0}  \n",
       "229885  9yX1qVa2PJtd-yx9M5xuFg  {'funny': 0, 'cool': 0, 'useful': 1}  \n",
       "229886  IC1rNlFJSzEJK8AFfDlfcg  {'funny': 0, 'cool': 0, 'useful': 1}  \n",
       "229887  SC_bFYaDgDub7tDjKCvV_g  {'funny': 2, 'cool': 2, 'useful': 3}  \n",
       "229888  6TnX7mzI-jfgK6teWqIS9Q  {'funny': 0, 'cool': 0, 'useful': 0}  \n",
       "229889  tlSSQwfHYJany7wPoTH46A  {'funny': 7, 'cool': 2, 'useful': 6}  \n",
       "229890  1X5BItB--PO2zn69nyfvLw  {'funny': 0, 'cool': 0, 'useful': 0}  \n",
       "229891  zgOeUiJnNMLOocpYN4m2VQ  {'funny': 0, 'cool': 0, 'useful': 1}  \n",
       "229892  hs8t_DMnNNpf_wXtFE2xpw  {'funny': 0, 'cool': 0, 'useful': 1}  \n",
       "229893  8dbRf1UsWp2ktXHZ6Zv06w  {'funny': 0, 'cool': 0, 'useful': 0}  \n",
       "229894  t7FjQwcAY2wYJMgmfVrvKQ  {'funny': 0, 'cool': 0, 'useful': 1}  \n",
       "229895  Lk9_kIKXGxnfcfQ6coI9ig  {'funny': 1, 'cool': 1, 'useful': 0}  \n",
       "229896  oJTwHtNlipl1iqaFV7HHZA  {'funny': 0, 'cool': 0, 'useful': 1}  \n",
       "229897  UoBfwbXaixelZBghbJ2cSg  {'funny': 2, 'cool': 3, 'useful': 4}  \n",
       "229898  tTO6rv0Z9aNNYmmZU_BR4g  {'funny': 0, 'cool': 0, 'useful': 0}  \n",
       "229899  Ak2jlINPRk9dWWazWUW2hA  {'funny': 0, 'cool': 1, 'useful': 1}  \n",
       "229900  CAlxnkAuqNetlUmWtCQ_eQ  {'funny': 0, 'cool': 0, 'useful': 2}  \n",
       "229901  q9XgOylNsSbqZqF_SO3-OQ  {'funny': 1, 'cool': 4, 'useful': 2}  \n",
       "229902  6e7pZofhDuIlD_rX2oYirQ  {'funny': 0, 'cool': 0, 'useful': 0}  \n",
       "229903  dDNfSFT0VApxPmURclX6_g  {'funny': 0, 'cool': 0, 'useful': 2}  \n",
       "229904  M5wHt6Odh1k5v0tIjqd8DQ  {'funny': 0, 'cool': 0, 'useful': 0}  \n",
       "229905  jopndPrv-H5KW2CfScnw9A  {'funny': 1, 'cool': 0, 'useful': 2}  \n",
       "229906  mbRUG6h0Mgb2XIJvscIoMg  {'funny': 1, 'cool': 1, 'useful': 0}  \n",
       "\n",
       "[229907 rows x 8 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "review_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "business_review = business_data.merge(review_data,on='business_id')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(229907, 20)"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "business_review.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "gb_business_review = business_review.groupby('business_id')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "interesting_restro = gb_business_review[['text']].count().sort_values('text',ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "top_restro = interesting_restro[interesting_restro['text'] > 300]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(48, 1)"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_restro.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>text</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>business_id</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>hW0Ne_HTHEAgGF1rAdmR-g</th>\n",
       "      <td>844</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VVeogjZya58oiTxK7qUjAQ</th>\n",
       "      <td>794</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JokKtdXU7zXHcr20Lrk29A</th>\n",
       "      <td>731</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ntN85eu27C04nwyPa8IHtw</th>\n",
       "      <td>679</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EWMwV5V9BxNs_U6nNVMeqw</th>\n",
       "      <td>645</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>V1nEpIRmEa1768oj_tuxeQ</th>\n",
       "      <td>588</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WNy1uzcmm_UHmTyR--o5IA</th>\n",
       "      <td>575</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SDwYQ6eSu1htn8vHWv128g</th>\n",
       "      <td>568</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-sC66z4SO3tR7nFCjfQwuQ</th>\n",
       "      <td>540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>QnAzW6KMSciUcuJ20oI3Bw</th>\n",
       "      <td>519</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OFBJtqWGSx6n6CchtVmoRw</th>\n",
       "      <td>501</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>pwpl-rxwNRQdgqFz_-qMPg</th>\n",
       "      <td>484</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>c1yGkETheht_1vjda7G5sA</th>\n",
       "      <td>472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>aRkYtXfmEKYG-eTDf_qUsw</th>\n",
       "      <td>456</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>uKSX1n1RoAzGq4bV8GPHVg</th>\n",
       "      <td>451</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3oZcTGb_oDHGwZFiP-7kxQ</th>\n",
       "      <td>449</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>K8pM6qQdYu5h6buRE1-_sw</th>\n",
       "      <td>447</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>_FXql6eVhbM923RdCi94SA</th>\n",
       "      <td>437</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>YKOvlBNkF4KpUP9q7x862w</th>\n",
       "      <td>436</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zx8_4zKdDBSO3qGrkukBIA</th>\n",
       "      <td>426</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qjmCVYkwP-HDa35jwYucbQ</th>\n",
       "      <td>426</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>R8VwdLyvsp9iybNqRvm94g</th>\n",
       "      <td>418</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>xY1sPHTA2RGVFlh5tZhs9g</th>\n",
       "      <td>408</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3n9mSKySEv3G03YjcU-YOQ</th>\n",
       "      <td>394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1NZLxU5WvB5roPFzneAlLw</th>\n",
       "      <td>392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>L9UYbtAUOcfTgZFimehlXw</th>\n",
       "      <td>387</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AqbgC7Gul5Es1rRzGNLDFA</th>\n",
       "      <td>361</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>rZbHg4ACfN3iShdsT47WKQ</th>\n",
       "      <td>359</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5VMajxduxfLPSyQkVFKESg</th>\n",
       "      <td>352</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53YGfwmbW73JhFiemNeyzQ</th>\n",
       "      <td>351</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>uEJQSIjWui-TDWXaGlcqyQ</th>\n",
       "      <td>347</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FV0BkoGOd3Yu_eJnXY15ZA</th>\n",
       "      <td>344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IVc23uY-36WUNYoIbz42Fg</th>\n",
       "      <td>341</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MuIXnv7Oq7X3-4aEsp9dDA</th>\n",
       "      <td>338</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bc4DoKgrKCtCuN-0O5He3A</th>\n",
       "      <td>333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>vARjqeIkSNsazHltujiq4Q</th>\n",
       "      <td>332</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>I4bSn5gXsHuSPu7L-d_8nQ</th>\n",
       "      <td>321</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FURgKkRFtMK5yKbjYZVVwA</th>\n",
       "      <td>321</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6imLt53br7SJ3av07jjH7w</th>\n",
       "      <td>316</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2ceeU8e3nZjaPfGmLwh4kg</th>\n",
       "      <td>314</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FqzgT9Y-Yu7jiWdHnGW-kQ</th>\n",
       "      <td>313</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>bgTB6MgdVQssXhkNJ7qIfw</th>\n",
       "      <td>313</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Y-9dJvw-J2d9QKfuL7mKgA</th>\n",
       "      <td>309</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Xq9tkiHhyN_aBFswFeGLvA</th>\n",
       "      <td>307</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AkOruz5CrCxUmXe1p_WoRg</th>\n",
       "      <td>306</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zp713qNhx8d9KCJJnrw1xA</th>\n",
       "      <td>303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cp39VURFby4A6u9m2It8jg</th>\n",
       "      <td>302</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>V6BYjHM9SnXscfkln3hCdA</th>\n",
       "      <td>301</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        text\n",
       "business_id                 \n",
       "hW0Ne_HTHEAgGF1rAdmR-g   844\n",
       "VVeogjZya58oiTxK7qUjAQ   794\n",
       "JokKtdXU7zXHcr20Lrk29A   731\n",
       "ntN85eu27C04nwyPa8IHtw   679\n",
       "EWMwV5V9BxNs_U6nNVMeqw   645\n",
       "V1nEpIRmEa1768oj_tuxeQ   588\n",
       "WNy1uzcmm_UHmTyR--o5IA   575\n",
       "SDwYQ6eSu1htn8vHWv128g   568\n",
       "-sC66z4SO3tR7nFCjfQwuQ   540\n",
       "QnAzW6KMSciUcuJ20oI3Bw   519\n",
       "OFBJtqWGSx6n6CchtVmoRw   501\n",
       "pwpl-rxwNRQdgqFz_-qMPg   484\n",
       "c1yGkETheht_1vjda7G5sA   472\n",
       "aRkYtXfmEKYG-eTDf_qUsw   456\n",
       "uKSX1n1RoAzGq4bV8GPHVg   451\n",
       "3oZcTGb_oDHGwZFiP-7kxQ   449\n",
       "K8pM6qQdYu5h6buRE1-_sw   447\n",
       "_FXql6eVhbM923RdCi94SA   437\n",
       "YKOvlBNkF4KpUP9q7x862w   436\n",
       "Zx8_4zKdDBSO3qGrkukBIA   426\n",
       "qjmCVYkwP-HDa35jwYucbQ   426\n",
       "R8VwdLyvsp9iybNqRvm94g   418\n",
       "xY1sPHTA2RGVFlh5tZhs9g   408\n",
       "3n9mSKySEv3G03YjcU-YOQ   394\n",
       "1NZLxU5WvB5roPFzneAlLw   392\n",
       "L9UYbtAUOcfTgZFimehlXw   387\n",
       "AqbgC7Gul5Es1rRzGNLDFA   361\n",
       "rZbHg4ACfN3iShdsT47WKQ   359\n",
       "5VMajxduxfLPSyQkVFKESg   352\n",
       "53YGfwmbW73JhFiemNeyzQ   351\n",
       "uEJQSIjWui-TDWXaGlcqyQ   347\n",
       "FV0BkoGOd3Yu_eJnXY15ZA   344\n",
       "IVc23uY-36WUNYoIbz42Fg   341\n",
       "MuIXnv7Oq7X3-4aEsp9dDA   338\n",
       "Bc4DoKgrKCtCuN-0O5He3A   333\n",
       "vARjqeIkSNsazHltujiq4Q   332\n",
       "I4bSn5gXsHuSPu7L-d_8nQ   321\n",
       "FURgKkRFtMK5yKbjYZVVwA   321\n",
       "6imLt53br7SJ3av07jjH7w   316\n",
       "2ceeU8e3nZjaPfGmLwh4kg   314\n",
       "FqzgT9Y-Yu7jiWdHnGW-kQ   313\n",
       "bgTB6MgdVQssXhkNJ7qIfw   313\n",
       "Y-9dJvw-J2d9QKfuL7mKgA   309\n",
       "Xq9tkiHhyN_aBFswFeGLvA   307\n",
       "AkOruz5CrCxUmXe1p_WoRg   306\n",
       "zp713qNhx8d9KCJJnrw1xA   303\n",
       "cp39VURFby4A6u9m2It8jg   302\n",
       "V6BYjHM9SnXscfkln3hCdA   301"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_restro"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "pd.concat()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Help on method reindex in module pandas.core.frame:\n",
      "\n",
      "reindex(index=None, columns=None, **kwargs) method of pandas.core.frame.DataFrame instance\n",
      "    Conform DataFrame to new index with optional filling logic, placing\n",
      "    NA/NaN in locations having no value in the previous index. A new object\n",
      "    is produced unless the new index is equivalent to the current one and\n",
      "    copy=False\n",
      "    \n",
      "    Parameters\n",
      "    ----------\n",
      "    index, columns : array-like, optional (can be specified in order, or as\n",
      "        keywords)\n",
      "        New labels / index to conform to. Preferably an Index object to\n",
      "        avoid duplicating data\n",
      "    method : {None, 'backfill'/'bfill', 'pad'/'ffill', 'nearest'}, optional\n",
      "        method to use for filling holes in reindexed DataFrame.\n",
      "        Please note: this is only  applicable to DataFrames/Series with a\n",
      "        monotonically increasing/decreasing index.\n",
      "    \n",
      "        * default: don't fill gaps\n",
      "        * pad / ffill: propagate last valid observation forward to next\n",
      "          valid\n",
      "        * backfill / bfill: use next valid observation to fill gap\n",
      "        * nearest: use nearest valid observations to fill gap\n",
      "    \n",
      "    copy : boolean, default True\n",
      "        Return a new object, even if the passed indexes are the same\n",
      "    level : int or name\n",
      "        Broadcast across a level, matching Index values on the\n",
      "        passed MultiIndex level\n",
      "    fill_value : scalar, default np.NaN\n",
      "        Value to use for missing values. Defaults to NaN, but can be any\n",
      "        \"compatible\" value\n",
      "    limit : int, default None\n",
      "        Maximum number of consecutive elements to forward or backward fill\n",
      "    tolerance : optional\n",
      "        Maximum distance between original and new labels for inexact\n",
      "        matches. The values of the index at the matching locations most\n",
      "        satisfy the equation ``abs(index[indexer] - target) <= tolerance``.\n",
      "    \n",
      "        .. versionadded:: 0.17.0\n",
      "    \n",
      "    Examples\n",
      "    --------\n",
      "    \n",
      "    Create a dataframe with some fictional data.\n",
      "    \n",
      "    >>> index = ['Firefox', 'Chrome', 'Safari', 'IE10', 'Konqueror']\n",
      "    >>> df = pd.DataFrame({\n",
      "    ...      'http_status': [200,200,404,404,301],\n",
      "    ...      'response_time': [0.04, 0.02, 0.07, 0.08, 1.0]},\n",
      "    ...       index=index)\n",
      "    >>> df\n",
      "                http_status  response_time\n",
      "    Firefox            200           0.04\n",
      "    Chrome             200           0.02\n",
      "    Safari             404           0.07\n",
      "    IE10               404           0.08\n",
      "    Konqueror          301           1.00\n",
      "    \n",
      "    Create a new index and reindex the dataframe. By default\n",
      "    values in the new index that do not have corresponding\n",
      "    records in the dataframe are assigned ``NaN``.\n",
      "    \n",
      "    >>> new_index= ['Safari', 'Iceweasel', 'Comodo Dragon', 'IE10',\n",
      "    ...             'Chrome']\n",
      "    >>> df.reindex(new_index)\n",
      "                   http_status  response_time\n",
      "    Safari                 404           0.07\n",
      "    Iceweasel              NaN            NaN\n",
      "    Comodo Dragon          NaN            NaN\n",
      "    IE10                   404           0.08\n",
      "    Chrome                 200           0.02\n",
      "    \n",
      "    We can fill in the missing values by passing a value to\n",
      "    the keyword ``fill_value``. Because the index is not monotonically\n",
      "    increasing or decreasing, we cannot use arguments to the keyword\n",
      "    ``method`` to fill the ``NaN`` values.\n",
      "    \n",
      "    >>> df.reindex(new_index, fill_value=0)\n",
      "                   http_status  response_time\n",
      "    Safari                 404           0.07\n",
      "    Iceweasel                0           0.00\n",
      "    Comodo Dragon            0           0.00\n",
      "    IE10                   404           0.08\n",
      "    Chrome                 200           0.02\n",
      "    \n",
      "    >>> df.reindex(new_index, fill_value='missing')\n",
      "                  http_status response_time\n",
      "    Safari                404          0.07\n",
      "    Iceweasel         missing       missing\n",
      "    Comodo Dragon     missing       missing\n",
      "    IE10                  404          0.08\n",
      "    Chrome                200          0.02\n",
      "    \n",
      "    To further illustrate the filling functionality in\n",
      "    ``reindex``, we will create a dataframe with a\n",
      "    monotonically increasing index (for example, a sequence\n",
      "    of dates).\n",
      "    \n",
      "    >>> date_index = pd.date_range('1/1/2010', periods=6, freq='D')\n",
      "    >>> df2 = pd.DataFrame({\"prices\": [100, 101, np.nan, 100, 89, 88]},\n",
      "    ...                    index=date_index)\n",
      "    >>> df2\n",
      "                prices\n",
      "    2010-01-01     100\n",
      "    2010-01-02     101\n",
      "    2010-01-03     NaN\n",
      "    2010-01-04     100\n",
      "    2010-01-05      89\n",
      "    2010-01-06      88\n",
      "    \n",
      "    Suppose we decide to expand the dataframe to cover a wider\n",
      "    date range.\n",
      "    \n",
      "    >>> date_index2 = pd.date_range('12/29/2009', periods=10, freq='D')\n",
      "    >>> df2.reindex(date_index2)\n",
      "                prices\n",
      "    2009-12-29     NaN\n",
      "    2009-12-30     NaN\n",
      "    2009-12-31     NaN\n",
      "    2010-01-01     100\n",
      "    2010-01-02     101\n",
      "    2010-01-03     NaN\n",
      "    2010-01-04     100\n",
      "    2010-01-05      89\n",
      "    2010-01-06      88\n",
      "    2010-01-07     NaN\n",
      "    \n",
      "    The index entries that did not have a value in the original data frame\n",
      "    (for example, '2009-12-29') are by default filled with ``NaN``.\n",
      "    If desired, we can fill in the missing values using one of several\n",
      "    options.\n",
      "    \n",
      "    For example, to backpropagate the last valid value to fill the ``NaN``\n",
      "    values, pass ``bfill`` as an argument to the ``method`` keyword.\n",
      "    \n",
      "    >>> df2.reindex(date_index2, method='bfill')\n",
      "                prices\n",
      "    2009-12-29     100\n",
      "    2009-12-30     100\n",
      "    2009-12-31     100\n",
      "    2010-01-01     100\n",
      "    2010-01-02     101\n",
      "    2010-01-03     NaN\n",
      "    2010-01-04     100\n",
      "    2010-01-05      89\n",
      "    2010-01-06      88\n",
      "    2010-01-07     NaN\n",
      "    \n",
      "    Please note that the ``NaN`` value present in the original dataframe\n",
      "    (at index value 2010-01-03) will not be filled by any of the\n",
      "    value propagation schemes. This is because filling while reindexing\n",
      "    does not look at dataframe values, but only compares the original and\n",
      "    desired indexes. If you do want to fill in the ``NaN`` values present\n",
      "    in the original dataframe, use the ``fillna()`` method.\n",
      "    \n",
      "    Returns\n",
      "    -------\n",
      "    reindexed : DataFrame\n",
      "\n"
     ]
    }
   ],
   "source": [
    "help(business_data.reindex)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "bd = business_data.reindex(columns=['business_id'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "ename": "TypeError",
     "evalue": "first argument must be an iterable of pandas objects, you passed an object of type \"DataFrame\"",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m-----------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mTypeError\u001b[0m                             Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-44-fd48b8b549f1>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m()\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mpd\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mconcat\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mbusiness_data\u001b[0m\u001b[1;33m,\u001b[0m\u001b[0mbd\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;32mC:\\Users\\ZekeLabs\\Anaconda3\\lib\\site-packages\\pandas\\tools\\merge.py\u001b[0m in \u001b[0;36mconcat\u001b[1;34m(objs, axis, join, join_axes, ignore_index, keys, levels, names, verify_integrity, copy)\u001b[0m\n\u001b[0;32m   1449\u001b[0m                        \u001b[0mkeys\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mkeys\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mlevels\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mlevels\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mnames\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mnames\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   1450\u001b[0m                        \u001b[0mverify_integrity\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mverify_integrity\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 1451\u001b[1;33m                        copy=copy)\n\u001b[0m\u001b[0;32m   1452\u001b[0m     \u001b[1;32mreturn\u001b[0m \u001b[0mop\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mget_result\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   1453\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mC:\\Users\\ZekeLabs\\Anaconda3\\lib\\site-packages\\pandas\\tools\\merge.py\u001b[0m in \u001b[0;36m__init__\u001b[1;34m(self, objs, axis, join, join_axes, keys, levels, names, ignore_index, verify_integrity, copy)\u001b[0m\n\u001b[0;32m   1464\u001b[0m             raise TypeError('first argument must be an iterable of pandas '\n\u001b[0;32m   1465\u001b[0m                             \u001b[1;34m'objects, you passed an object of type '\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 1466\u001b[1;33m                             '\"{0}\"'.format(type(objs).__name__))\n\u001b[0m\u001b[0;32m   1467\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   1468\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0mjoin\u001b[0m \u001b[1;33m==\u001b[0m \u001b[1;34m'outer'\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mTypeError\u001b[0m: first argument must be an iterable of pandas objects, you passed an object of type \"DataFrame\""
     ]
    }
   ],
   "source": [
    "pd.concat(business_data,bd)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [],
   "source": [
    "bd2 = business_data.set_index('business_id')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "      business_id           \n",
       "text  hW0Ne_HTHEAgGF1rAdmR-g    844\n",
       "      VVeogjZya58oiTxK7qUjAQ    794\n",
       "      JokKtdXU7zXHcr20Lrk29A    731\n",
       "      ntN85eu27C04nwyPa8IHtw    679\n",
       "      EWMwV5V9BxNs_U6nNVMeqw    645\n",
       "      V1nEpIRmEa1768oj_tuxeQ    588\n",
       "      WNy1uzcmm_UHmTyR--o5IA    575\n",
       "      SDwYQ6eSu1htn8vHWv128g    568\n",
       "      -sC66z4SO3tR7nFCjfQwuQ    540\n",
       "      QnAzW6KMSciUcuJ20oI3Bw    519\n",
       "      OFBJtqWGSx6n6CchtVmoRw    501\n",
       "      pwpl-rxwNRQdgqFz_-qMPg    484\n",
       "      c1yGkETheht_1vjda7G5sA    472\n",
       "      aRkYtXfmEKYG-eTDf_qUsw    456\n",
       "      uKSX1n1RoAzGq4bV8GPHVg    451\n",
       "      3oZcTGb_oDHGwZFiP-7kxQ    449\n",
       "      K8pM6qQdYu5h6buRE1-_sw    447\n",
       "      _FXql6eVhbM923RdCi94SA    437\n",
       "      YKOvlBNkF4KpUP9q7x862w    436\n",
       "      Zx8_4zKdDBSO3qGrkukBIA    426\n",
       "      qjmCVYkwP-HDa35jwYucbQ    426\n",
       "      R8VwdLyvsp9iybNqRvm94g    418\n",
       "      xY1sPHTA2RGVFlh5tZhs9g    408\n",
       "      3n9mSKySEv3G03YjcU-YOQ    394\n",
       "      1NZLxU5WvB5roPFzneAlLw    392\n",
       "      L9UYbtAUOcfTgZFimehlXw    387\n",
       "      AqbgC7Gul5Es1rRzGNLDFA    361\n",
       "      rZbHg4ACfN3iShdsT47WKQ    359\n",
       "      5VMajxduxfLPSyQkVFKESg    352\n",
       "      53YGfwmbW73JhFiemNeyzQ    351\n",
       "      uEJQSIjWui-TDWXaGlcqyQ    347\n",
       "      FV0BkoGOd3Yu_eJnXY15ZA    344\n",
       "      IVc23uY-36WUNYoIbz42Fg    341\n",
       "      MuIXnv7Oq7X3-4aEsp9dDA    338\n",
       "      Bc4DoKgrKCtCuN-0O5He3A    333\n",
       "      vARjqeIkSNsazHltujiq4Q    332\n",
       "      I4bSn5gXsHuSPu7L-d_8nQ    321\n",
       "      FURgKkRFtMK5yKbjYZVVwA    321\n",
       "      6imLt53br7SJ3av07jjH7w    316\n",
       "      2ceeU8e3nZjaPfGmLwh4kg    314\n",
       "      FqzgT9Y-Yu7jiWdHnGW-kQ    313\n",
       "      bgTB6MgdVQssXhkNJ7qIfw    313\n",
       "      Y-9dJvw-J2d9QKfuL7mKgA    309\n",
       "      Xq9tkiHhyN_aBFswFeGLvA    307\n",
       "      AkOruz5CrCxUmXe1p_WoRg    306\n",
       "      zp713qNhx8d9KCJJnrw1xA    303\n",
       "      cp39VURFby4A6u9m2It8jg    302\n",
       "      V6BYjHM9SnXscfkln3hCdA    301\n",
       "dtype: int64"
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>text</th>\n",
       "      <th>categories</th>\n",
       "      <th>city</th>\n",
       "      <th>full_address</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>name</th>\n",
       "      <th>neighborhoods</th>\n",
       "      <th>open</th>\n",
       "      <th>review_count</th>\n",
       "      <th>stars</th>\n",
       "      <th>state</th>\n",
       "      <th>type</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>business_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>hW0Ne_HTHEAgGF1rAdmR-g</th>\n",
       "      <td>844</td>\n",
       "      <td>[Hotels &amp; Travel, Airports]</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>3400 E Sky Harbor Blvd\\nPhoenix, AZ 85034</td>\n",
       "      <td>33.434750</td>\n",
       "      <td>-112.006440</td>\n",
       "      <td>Phoenix Sky Harbor International Airport</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>862</td>\n",
       "      <td>3.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VVeogjZya58oiTxK7qUjAQ</th>\n",
       "      <td>794</td>\n",
       "      <td>[Pizza, Restaurants]</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>623 E Adams St\\nPhoenix, AZ 85004</td>\n",
       "      <td>33.449233</td>\n",
       "      <td>-112.065458</td>\n",
       "      <td>Pizzeria Bianco</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>803</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JokKtdXU7zXHcr20Lrk29A</th>\n",
       "      <td>731</td>\n",
       "      <td>[Bars, Food, Breweries, Pubs, Nightlife, Ameri...</td>\n",
       "      <td>Tempe</td>\n",
       "      <td>1340 E 8th St\\nSte 104\\nTempe, AZ 85281</td>\n",
       "      <td>33.419451</td>\n",
       "      <td>-111.915926</td>\n",
       "      <td>Four Peaks Brewing Co</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>735</td>\n",
       "      <td>4.5</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ntN85eu27C04nwyPa8IHtw</th>\n",
       "      <td>679</td>\n",
       "      <td>[Breakfast &amp; Brunch, Restaurants]</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>801 N 1st St\\nPhoenix, AZ 85004</td>\n",
       "      <td>33.456696</td>\n",
       "      <td>-112.072327</td>\n",
       "      <td>Matt's Big Breakfast</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>689</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EWMwV5V9BxNs_U6nNVMeqw</th>\n",
       "      <td>645</td>\n",
       "      <td>[Bars, Mediterranean, Nightlife, Lounges, Amer...</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>3815 N Central Ave\\nPhoenix, AZ 85012</td>\n",
       "      <td>33.491645</td>\n",
       "      <td>-112.073196</td>\n",
       "      <td>FEZ</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>652</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>V1nEpIRmEa1768oj_tuxeQ</th>\n",
       "      <td>588</td>\n",
       "      <td>[Italian, Pizza, Sandwiches, Restaurants]</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>603 N 5th Ave\\nPhoenix, AZ 85003</td>\n",
       "      <td>33.454848</td>\n",
       "      <td>-112.080071</td>\n",
       "      <td>Cibo</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>594</td>\n",
       "      <td>4.5</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WNy1uzcmm_UHmTyR--o5IA</th>\n",
       "      <td>575</td>\n",
       "      <td>[Pubs, Bars, Nightlife, British, Restaurants]</td>\n",
       "      <td>Tempe</td>\n",
       "      <td>960 W University Dr\\nTempe, AZ 85281</td>\n",
       "      <td>33.422728</td>\n",
       "      <td>-111.951494</td>\n",
       "      <td>Cornish Pasty Company</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>580</td>\n",
       "      <td>4.5</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SDwYQ6eSu1htn8vHWv128g</th>\n",
       "      <td>568</td>\n",
       "      <td>[Wine Bars, Bars, Restaurants, Nightlife, Ital...</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>3939 E Campbell Ave\\nPhoenix, AZ 85018</td>\n",
       "      <td>33.502191</td>\n",
       "      <td>-111.996292</td>\n",
       "      <td>Postino Arcadia</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>575</td>\n",
       "      <td>4.5</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-sC66z4SO3tR7nFCjfQwuQ</th>\n",
       "      <td>540</td>\n",
       "      <td>[Mexican, Restaurants]</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>401 W Clarendon Ave\\nPhoenix, AZ 85013</td>\n",
       "      <td>33.491120</td>\n",
       "      <td>-112.079081</td>\n",
       "      <td>Gallo Blanco Cafe</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>549</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>QnAzW6KMSciUcuJ20oI3Bw</th>\n",
       "      <td>519</td>\n",
       "      <td>[American (Traditional), Restaurants]</td>\n",
       "      <td>Gilbert</td>\n",
       "      <td>3000 E Ray Rd\\nBldg 1\\nGilbert, AZ 85296</td>\n",
       "      <td>33.321062</td>\n",
       "      <td>-111.723919</td>\n",
       "      <td>Joe's Farm Grill</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>525</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OFBJtqWGSx6n6CchtVmoRw</th>\n",
       "      <td>501</td>\n",
       "      <td>[Burgers, Bars, Nightlife, Restaurants]</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>3146 E Camelback Rd\\nPhoenix, AZ 85016</td>\n",
       "      <td>33.510040</td>\n",
       "      <td>-112.014641</td>\n",
       "      <td>Delux</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>502</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>pwpl-rxwNRQdgqFz_-qMPg</th>\n",
       "      <td>484</td>\n",
       "      <td>[Italian, Pizza, Restaurants]</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>1916 E Camelback Rd\\nPhoenix, AZ 85016</td>\n",
       "      <td>33.509446</td>\n",
       "      <td>-112.040395</td>\n",
       "      <td>The Parlor</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>489</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>c1yGkETheht_1vjda7G5sA</th>\n",
       "      <td>472</td>\n",
       "      <td>[Vegetarian, Vegan, Restaurants]</td>\n",
       "      <td>Tempe</td>\n",
       "      <td>2240 N Scottsdale Rd\\nTempe, AZ 85281</td>\n",
       "      <td>33.453787</td>\n",
       "      <td>-111.927166</td>\n",
       "      <td>Green</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>477</td>\n",
       "      <td>4.5</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>aRkYtXfmEKYG-eTDf_qUsw</th>\n",
       "      <td>456</td>\n",
       "      <td>[Food, Coffee &amp; Tea]</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>4402 N Central Ave\\nPhoenix, AZ 85012</td>\n",
       "      <td>33.500572</td>\n",
       "      <td>-112.074114</td>\n",
       "      <td>Lux</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>461</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>uKSX1n1RoAzGq4bV8GPHVg</th>\n",
       "      <td>451</td>\n",
       "      <td>[American (New), Restaurants]</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>111 E Camelback Rd\\nPhoenix, AZ 85012</td>\n",
       "      <td>33.509276</td>\n",
       "      <td>-112.071818</td>\n",
       "      <td>St Francis Restaurant</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>461</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3oZcTGb_oDHGwZFiP-7kxQ</th>\n",
       "      <td>449</td>\n",
       "      <td>[Breakfast &amp; Brunch, American (Traditional), R...</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>5040 N 40th St\\nPhoenix, AZ 85018</td>\n",
       "      <td>33.512319</td>\n",
       "      <td>-111.995355</td>\n",
       "      <td>Chelsea's Kitchen</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>453</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>K8pM6qQdYu5h6buRE1-_sw</th>\n",
       "      <td>447</td>\n",
       "      <td>[Soul Food, Southern, Restaurants]</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>1220 S Central Ave\\nPhoenix, AZ 85003</td>\n",
       "      <td>33.435455</td>\n",
       "      <td>-112.073914</td>\n",
       "      <td>Lo-Lo's Chicken &amp; Waffles</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>450</td>\n",
       "      <td>4.5</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>_FXql6eVhbM923RdCi94SA</th>\n",
       "      <td>437</td>\n",
       "      <td>[Seafood, Caribbean, Hawaiian, Restaurants]</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>4700 N Central Ave\\nPhoenix, AZ 85012</td>\n",
       "      <td>33.506208</td>\n",
       "      <td>-112.073914</td>\n",
       "      <td>Hula's Modern Tiki</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>444</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>YKOvlBNkF4KpUP9q7x862w</th>\n",
       "      <td>436</td>\n",
       "      <td>[Latin American, Restaurants]</td>\n",
       "      <td>Scottsdale</td>\n",
       "      <td>3815 N Brown Ave\\nScottsdale, AZ 85251</td>\n",
       "      <td>33.492298</td>\n",
       "      <td>-111.924552</td>\n",
       "      <td>The Mission</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>441</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zx8_4zKdDBSO3qGrkukBIA</th>\n",
       "      <td>426</td>\n",
       "      <td>[Asian Fusion, Mexican, Restaurants]</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>15414 N 19th Ave\\nSte K\\nPhoenix, AZ 85023</td>\n",
       "      <td>33.626933</td>\n",
       "      <td>-112.100731</td>\n",
       "      <td>Chino Bandido</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>431</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>qjmCVYkwP-HDa35jwYucbQ</th>\n",
       "      <td>426</td>\n",
       "      <td>[American (New), Restaurants]</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>2502 E Camelback Rd\\nPhoenix, AZ 85016</td>\n",
       "      <td>33.510207</td>\n",
       "      <td>-112.027204</td>\n",
       "      <td>True Food Kitchen</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>434</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>R8VwdLyvsp9iybNqRvm94g</th>\n",
       "      <td>418</td>\n",
       "      <td>[Food, Grocery, Breakfast &amp; Brunch, Restaurants]</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>4410 N 40th St\\nPhoenix, AZ 85018</td>\n",
       "      <td>33.502409</td>\n",
       "      <td>-111.995501</td>\n",
       "      <td>La Grande Orange Grocery</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>421</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>xY1sPHTA2RGVFlh5tZhs9g</th>\n",
       "      <td>408</td>\n",
       "      <td>[Bars, American (New), Nightlife, Restaurants]</td>\n",
       "      <td>Scottsdale</td>\n",
       "      <td>7135 E Camelback Rd\\nSte 125\\nScottsdale, AZ 8...</td>\n",
       "      <td>33.501982</td>\n",
       "      <td>-111.927618</td>\n",
       "      <td>Culinary Dropout</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>412</td>\n",
       "      <td>3.5</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3n9mSKySEv3G03YjcU-YOQ</th>\n",
       "      <td>394</td>\n",
       "      <td>[Wine Bars, Bars, Restaurants, Nightlife, Ital...</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>5144 N Central Ave\\nPhoenix, AZ 85012</td>\n",
       "      <td>33.512770</td>\n",
       "      <td>-112.074012</td>\n",
       "      <td>Postino Central</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>402</td>\n",
       "      <td>4.5</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1NZLxU5WvB5roPFzneAlLw</th>\n",
       "      <td>392</td>\n",
       "      <td>[Mexican, Restaurants]</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>2814 N 16th St\\nPhoenix, AZ 85006</td>\n",
       "      <td>33.478794</td>\n",
       "      <td>-112.047809</td>\n",
       "      <td>Barrio Café</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>398</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>L9UYbtAUOcfTgZFimehlXw</th>\n",
       "      <td>387</td>\n",
       "      <td>[Food, Coffee &amp; Tea, American (New), Restaurants]</td>\n",
       "      <td>Gilbert</td>\n",
       "      <td>230 N Gilbert Rd\\nGilbert, AZ 85234</td>\n",
       "      <td>33.354701</td>\n",
       "      <td>-111.789790</td>\n",
       "      <td>Liberty Market</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>390</td>\n",
       "      <td>4.5</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AqbgC7Gul5Es1rRzGNLDFA</th>\n",
       "      <td>361</td>\n",
       "      <td>[Food, Desserts]</td>\n",
       "      <td>Scottsdale</td>\n",
       "      <td>4501 N Scottsdale Rd\\nScottsdale, AZ 85251</td>\n",
       "      <td>33.502499</td>\n",
       "      <td>-111.925895</td>\n",
       "      <td>Sprinkles Cupcakes</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>362</td>\n",
       "      <td>3.5</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>rZbHg4ACfN3iShdsT47WKQ</th>\n",
       "      <td>359</td>\n",
       "      <td>[American (New), Barbeque, Restaurants]</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>8501 N 27th Ave\\nPhoenix, AZ 85051</td>\n",
       "      <td>33.561259</td>\n",
       "      <td>-112.115624</td>\n",
       "      <td>Bobby Q</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>363</td>\n",
       "      <td>4.5</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5VMajxduxfLPSyQkVFKESg</th>\n",
       "      <td>352</td>\n",
       "      <td>[Barbeque, Restaurants]</td>\n",
       "      <td>Gilbert</td>\n",
       "      <td>301 N Gilbert Rd\\nGilbert, AZ 85234</td>\n",
       "      <td>33.355044</td>\n",
       "      <td>-111.789531</td>\n",
       "      <td>Joe's Real BBQ</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>353</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53YGfwmbW73JhFiemNeyzQ</th>\n",
       "      <td>351</td>\n",
       "      <td>[American (Traditional), American (New), Resta...</td>\n",
       "      <td>Scottsdale</td>\n",
       "      <td>7135 E Camelback Rd\\nSte 195\\nScottsdale, AZ 8...</td>\n",
       "      <td>33.501982</td>\n",
       "      <td>-111.927618</td>\n",
       "      <td>Olive &amp; Ivy</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>358</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>uEJQSIjWui-TDWXaGlcqyQ</th>\n",
       "      <td>347</td>\n",
       "      <td>[Soul Food, Breakfast &amp; Brunch, Southern, Rest...</td>\n",
       "      <td>Scottsdale</td>\n",
       "      <td>2765 N Scottsdale Rd\\nScottsdale, AZ 85257</td>\n",
       "      <td>33.478794</td>\n",
       "      <td>-111.925909</td>\n",
       "      <td>Lo-Lo's Chicken &amp; Waffles</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>357</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FV0BkoGOd3Yu_eJnXY15ZA</th>\n",
       "      <td>344</td>\n",
       "      <td>[American (New), Restaurants]</td>\n",
       "      <td>Scottsdale</td>\n",
       "      <td>7133 E Stetson Dr\\nSte 1\\nScottsdale, AZ 85251</td>\n",
       "      <td>33.499499</td>\n",
       "      <td>-111.927402</td>\n",
       "      <td>Cowboy Ciao</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>349</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IVc23uY-36WUNYoIbz42Fg</th>\n",
       "      <td>341</td>\n",
       "      <td>[Wine Bars, Bars, American (New), Nightlife, R...</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>2603 N Central Ave\\nPhoenix, AZ 85004</td>\n",
       "      <td>33.477024</td>\n",
       "      <td>-112.073629</td>\n",
       "      <td>Switch Restaurant &amp; Wine Bar</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>343</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MuIXnv7Oq7X3-4aEsp9dDA</th>\n",
       "      <td>338</td>\n",
       "      <td>[Gastropubs, American (New), Restaurants]</td>\n",
       "      <td>Scottsdale</td>\n",
       "      <td>7111 E 5th Ave\\nSte E\\nScottsdale, AZ 85251</td>\n",
       "      <td>33.498028</td>\n",
       "      <td>-111.927951</td>\n",
       "      <td>Citizen Public House</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>347</td>\n",
       "      <td>4.5</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bc4DoKgrKCtCuN-0O5He3A</th>\n",
       "      <td>333</td>\n",
       "      <td>[Food, Ice Cream &amp; Frozen Yogurt]</td>\n",
       "      <td>Scottsdale</td>\n",
       "      <td>9160 E Shea Blvd\\nScottsdale, AZ 85260</td>\n",
       "      <td>33.583480</td>\n",
       "      <td>-111.883526</td>\n",
       "      <td>Sweet Republic</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>335</td>\n",
       "      <td>4.5</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>vARjqeIkSNsazHltujiq4Q</th>\n",
       "      <td>332</td>\n",
       "      <td>[British, Restaurants]</td>\n",
       "      <td>Mesa</td>\n",
       "      <td>1941 W Guadalupe Rd\\nSte 101\\nMesa, AZ 85202</td>\n",
       "      <td>33.362719</td>\n",
       "      <td>-111.876139</td>\n",
       "      <td>Cornish Pasty Company</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>333</td>\n",
       "      <td>4.5</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FURgKkRFtMK5yKbjYZVVwA</th>\n",
       "      <td>321</td>\n",
       "      <td>[American (New), Restaurants]</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>5223 N Central Ave\\nPhoenix, AZ 85012</td>\n",
       "      <td>33.513697</td>\n",
       "      <td>-112.073412</td>\n",
       "      <td>Windsor</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>326</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>I4bSn5gXsHuSPu7L-d_8nQ</th>\n",
       "      <td>321</td>\n",
       "      <td>[American (New), Restaurants]</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>3717 E Indian School Rd\\nPhoenix, AZ 85018</td>\n",
       "      <td>33.495137</td>\n",
       "      <td>-112.001232</td>\n",
       "      <td>Beckett's Table</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>323</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6imLt53br7SJ3av07jjH7w</th>\n",
       "      <td>316</td>\n",
       "      <td>[Bars, Nightlife, Lounges]</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>40 N 1st St\\nPhoenix, AZ 85004</td>\n",
       "      <td>33.449241</td>\n",
       "      <td>-112.072854</td>\n",
       "      <td>Hanny's</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>318</td>\n",
       "      <td>3.5</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2ceeU8e3nZjaPfGmLwh4kg</th>\n",
       "      <td>314</td>\n",
       "      <td>[Bars, Seafood, Irish, Pubs, Nightlife, Restau...</td>\n",
       "      <td>Tempe</td>\n",
       "      <td>850 S Ash Ave\\nTempe, AZ 85281</td>\n",
       "      <td>33.420571</td>\n",
       "      <td>-111.942444</td>\n",
       "      <td>Casey Moore's Oyster House</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>317</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>bgTB6MgdVQssXhkNJ7qIfw</th>\n",
       "      <td>313</td>\n",
       "      <td>[Steakhouses, Sushi Bars, Japanese, Restaurants]</td>\n",
       "      <td>Scottsdale</td>\n",
       "      <td>7299 N Scottsdale Rd\\nScottsdale, AZ 85253</td>\n",
       "      <td>33.542193</td>\n",
       "      <td>-111.925634</td>\n",
       "      <td>Roka Akor</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>315</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FqzgT9Y-Yu7jiWdHnGW-kQ</th>\n",
       "      <td>313</td>\n",
       "      <td>[Bars, American (Traditional), Pubs, Nightlife...</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>4041 N 40th St\\nPhoenix, AZ 85018</td>\n",
       "      <td>33.494459</td>\n",
       "      <td>-111.995329</td>\n",
       "      <td>The Vig</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>316</td>\n",
       "      <td>3.5</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Y-9dJvw-J2d9QKfuL7mKgA</th>\n",
       "      <td>309</td>\n",
       "      <td>[Breakfast &amp; Brunch, Restaurants]</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>4730 E Indian School Rd\\nSte 123\\nPhoenix, AZ ...</td>\n",
       "      <td>33.494820</td>\n",
       "      <td>-111.979821</td>\n",
       "      <td>Over Easy</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>310</td>\n",
       "      <td>3.5</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Xq9tkiHhyN_aBFswFeGLvA</th>\n",
       "      <td>307</td>\n",
       "      <td>[American (New), Restaurants]</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>2 E Jefferson St\\nSte 150\\nPhoenix, AZ 85004</td>\n",
       "      <td>33.447173</td>\n",
       "      <td>-112.073781</td>\n",
       "      <td>The Arrogant Butcher</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>321</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AkOruz5CrCxUmXe1p_WoRg</th>\n",
       "      <td>306</td>\n",
       "      <td>[Asian Fusion, Italian, Japanese, Restaurants]</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>914 E Camelback Rd\\nPhoenix, AZ 85014</td>\n",
       "      <td>33.509337</td>\n",
       "      <td>-112.060818</td>\n",
       "      <td>CherryBlossom Noodle Cafe</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>309</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zp713qNhx8d9KCJJnrw1xA</th>\n",
       "      <td>303</td>\n",
       "      <td>[Mexican, Restaurants]</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>1919 N 16th St\\nPhoenix, AZ 85006</td>\n",
       "      <td>33.469132</td>\n",
       "      <td>-112.047512</td>\n",
       "      <td>La Condesa Gourmet Taco Shop</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>307</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cp39VURFby4A6u9m2It8jg</th>\n",
       "      <td>302</td>\n",
       "      <td>[Burgers, Restaurants]</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>2502 E Camelback Rd\\nSte 127\\nPhoenix, AZ 85016</td>\n",
       "      <td>33.509535</td>\n",
       "      <td>-112.027592</td>\n",
       "      <td>Zinburger</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>305</td>\n",
       "      <td>3.5</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>V6BYjHM9SnXscfkln3hCdA</th>\n",
       "      <td>301</td>\n",
       "      <td>[Breakfast &amp; Brunch, American (Traditional), R...</td>\n",
       "      <td>Scottsdale</td>\n",
       "      <td>7373 E Scottsdale Mall\\nSte 6\\nScottsdale, AZ ...</td>\n",
       "      <td>33.492502</td>\n",
       "      <td>-111.924119</td>\n",
       "      <td>Orange Table</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>304</td>\n",
       "      <td>4.0</td>\n",
       "      <td>AZ</td>\n",
       "      <td>business</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        text  \\\n",
       "business_id                    \n",
       "hW0Ne_HTHEAgGF1rAdmR-g   844   \n",
       "VVeogjZya58oiTxK7qUjAQ   794   \n",
       "JokKtdXU7zXHcr20Lrk29A   731   \n",
       "ntN85eu27C04nwyPa8IHtw   679   \n",
       "EWMwV5V9BxNs_U6nNVMeqw   645   \n",
       "V1nEpIRmEa1768oj_tuxeQ   588   \n",
       "WNy1uzcmm_UHmTyR--o5IA   575   \n",
       "SDwYQ6eSu1htn8vHWv128g   568   \n",
       "-sC66z4SO3tR7nFCjfQwuQ   540   \n",
       "QnAzW6KMSciUcuJ20oI3Bw   519   \n",
       "OFBJtqWGSx6n6CchtVmoRw   501   \n",
       "pwpl-rxwNRQdgqFz_-qMPg   484   \n",
       "c1yGkETheht_1vjda7G5sA   472   \n",
       "aRkYtXfmEKYG-eTDf_qUsw   456   \n",
       "uKSX1n1RoAzGq4bV8GPHVg   451   \n",
       "3oZcTGb_oDHGwZFiP-7kxQ   449   \n",
       "K8pM6qQdYu5h6buRE1-_sw   447   \n",
       "_FXql6eVhbM923RdCi94SA   437   \n",
       "YKOvlBNkF4KpUP9q7x862w   436   \n",
       "Zx8_4zKdDBSO3qGrkukBIA   426   \n",
       "qjmCVYkwP-HDa35jwYucbQ   426   \n",
       "R8VwdLyvsp9iybNqRvm94g   418   \n",
       "xY1sPHTA2RGVFlh5tZhs9g   408   \n",
       "3n9mSKySEv3G03YjcU-YOQ   394   \n",
       "1NZLxU5WvB5roPFzneAlLw   392   \n",
       "L9UYbtAUOcfTgZFimehlXw   387   \n",
       "AqbgC7Gul5Es1rRzGNLDFA   361   \n",
       "rZbHg4ACfN3iShdsT47WKQ   359   \n",
       "5VMajxduxfLPSyQkVFKESg   352   \n",
       "53YGfwmbW73JhFiemNeyzQ   351   \n",
       "uEJQSIjWui-TDWXaGlcqyQ   347   \n",
       "FV0BkoGOd3Yu_eJnXY15ZA   344   \n",
       "IVc23uY-36WUNYoIbz42Fg   341   \n",
       "MuIXnv7Oq7X3-4aEsp9dDA   338   \n",
       "Bc4DoKgrKCtCuN-0O5He3A   333   \n",
       "vARjqeIkSNsazHltujiq4Q   332   \n",
       "FURgKkRFtMK5yKbjYZVVwA   321   \n",
       "I4bSn5gXsHuSPu7L-d_8nQ   321   \n",
       "6imLt53br7SJ3av07jjH7w   316   \n",
       "2ceeU8e3nZjaPfGmLwh4kg   314   \n",
       "bgTB6MgdVQssXhkNJ7qIfw   313   \n",
       "FqzgT9Y-Yu7jiWdHnGW-kQ   313   \n",
       "Y-9dJvw-J2d9QKfuL7mKgA   309   \n",
       "Xq9tkiHhyN_aBFswFeGLvA   307   \n",
       "AkOruz5CrCxUmXe1p_WoRg   306   \n",
       "zp713qNhx8d9KCJJnrw1xA   303   \n",
       "cp39VURFby4A6u9m2It8jg   302   \n",
       "V6BYjHM9SnXscfkln3hCdA   301   \n",
       "\n",
       "                                                               categories  \\\n",
       "business_id                                                                 \n",
       "hW0Ne_HTHEAgGF1rAdmR-g                        [Hotels & Travel, Airports]   \n",
       "VVeogjZya58oiTxK7qUjAQ                               [Pizza, Restaurants]   \n",
       "JokKtdXU7zXHcr20Lrk29A  [Bars, Food, Breweries, Pubs, Nightlife, Ameri...   \n",
       "ntN85eu27C04nwyPa8IHtw                  [Breakfast & Brunch, Restaurants]   \n",
       "EWMwV5V9BxNs_U6nNVMeqw  [Bars, Mediterranean, Nightlife, Lounges, Amer...   \n",
       "V1nEpIRmEa1768oj_tuxeQ          [Italian, Pizza, Sandwiches, Restaurants]   \n",
       "WNy1uzcmm_UHmTyR--o5IA      [Pubs, Bars, Nightlife, British, Restaurants]   \n",
       "SDwYQ6eSu1htn8vHWv128g  [Wine Bars, Bars, Restaurants, Nightlife, Ital...   \n",
       "-sC66z4SO3tR7nFCjfQwuQ                             [Mexican, Restaurants]   \n",
       "QnAzW6KMSciUcuJ20oI3Bw              [American (Traditional), Restaurants]   \n",
       "OFBJtqWGSx6n6CchtVmoRw            [Burgers, Bars, Nightlife, Restaurants]   \n",
       "pwpl-rxwNRQdgqFz_-qMPg                      [Italian, Pizza, Restaurants]   \n",
       "c1yGkETheht_1vjda7G5sA                   [Vegetarian, Vegan, Restaurants]   \n",
       "aRkYtXfmEKYG-eTDf_qUsw                               [Food, Coffee & Tea]   \n",
       "uKSX1n1RoAzGq4bV8GPHVg                      [American (New), Restaurants]   \n",
       "3oZcTGb_oDHGwZFiP-7kxQ  [Breakfast & Brunch, American (Traditional), R...   \n",
       "K8pM6qQdYu5h6buRE1-_sw                 [Soul Food, Southern, Restaurants]   \n",
       "_FXql6eVhbM923RdCi94SA        [Seafood, Caribbean, Hawaiian, Restaurants]   \n",
       "YKOvlBNkF4KpUP9q7x862w                      [Latin American, Restaurants]   \n",
       "Zx8_4zKdDBSO3qGrkukBIA               [Asian Fusion, Mexican, Restaurants]   \n",
       "qjmCVYkwP-HDa35jwYucbQ                      [American (New), Restaurants]   \n",
       "R8VwdLyvsp9iybNqRvm94g   [Food, Grocery, Breakfast & Brunch, Restaurants]   \n",
       "xY1sPHTA2RGVFlh5tZhs9g     [Bars, American (New), Nightlife, Restaurants]   \n",
       "3n9mSKySEv3G03YjcU-YOQ  [Wine Bars, Bars, Restaurants, Nightlife, Ital...   \n",
       "1NZLxU5WvB5roPFzneAlLw                             [Mexican, Restaurants]   \n",
       "L9UYbtAUOcfTgZFimehlXw  [Food, Coffee & Tea, American (New), Restaurants]   \n",
       "AqbgC7Gul5Es1rRzGNLDFA                                   [Food, Desserts]   \n",
       "rZbHg4ACfN3iShdsT47WKQ            [American (New), Barbeque, Restaurants]   \n",
       "5VMajxduxfLPSyQkVFKESg                            [Barbeque, Restaurants]   \n",
       "53YGfwmbW73JhFiemNeyzQ  [American (Traditional), American (New), Resta...   \n",
       "uEJQSIjWui-TDWXaGlcqyQ  [Soul Food, Breakfast & Brunch, Southern, Rest...   \n",
       "FV0BkoGOd3Yu_eJnXY15ZA                      [American (New), Restaurants]   \n",
       "IVc23uY-36WUNYoIbz42Fg  [Wine Bars, Bars, American (New), Nightlife, R...   \n",
       "MuIXnv7Oq7X3-4aEsp9dDA          [Gastropubs, American (New), Restaurants]   \n",
       "Bc4DoKgrKCtCuN-0O5He3A                  [Food, Ice Cream & Frozen Yogurt]   \n",
       "vARjqeIkSNsazHltujiq4Q                             [British, Restaurants]   \n",
       "FURgKkRFtMK5yKbjYZVVwA                      [American (New), Restaurants]   \n",
       "I4bSn5gXsHuSPu7L-d_8nQ                      [American (New), Restaurants]   \n",
       "6imLt53br7SJ3av07jjH7w                         [Bars, Nightlife, Lounges]   \n",
       "2ceeU8e3nZjaPfGmLwh4kg  [Bars, Seafood, Irish, Pubs, Nightlife, Restau...   \n",
       "bgTB6MgdVQssXhkNJ7qIfw   [Steakhouses, Sushi Bars, Japanese, Restaurants]   \n",
       "FqzgT9Y-Yu7jiWdHnGW-kQ  [Bars, American (Traditional), Pubs, Nightlife...   \n",
       "Y-9dJvw-J2d9QKfuL7mKgA                  [Breakfast & Brunch, Restaurants]   \n",
       "Xq9tkiHhyN_aBFswFeGLvA                      [American (New), Restaurants]   \n",
       "AkOruz5CrCxUmXe1p_WoRg     [Asian Fusion, Italian, Japanese, Restaurants]   \n",
       "zp713qNhx8d9KCJJnrw1xA                             [Mexican, Restaurants]   \n",
       "cp39VURFby4A6u9m2It8jg                             [Burgers, Restaurants]   \n",
       "V6BYjHM9SnXscfkln3hCdA  [Breakfast & Brunch, American (Traditional), R...   \n",
       "\n",
       "                              city  \\\n",
       "business_id                          \n",
       "hW0Ne_HTHEAgGF1rAdmR-g     Phoenix   \n",
       "VVeogjZya58oiTxK7qUjAQ     Phoenix   \n",
       "JokKtdXU7zXHcr20Lrk29A       Tempe   \n",
       "ntN85eu27C04nwyPa8IHtw     Phoenix   \n",
       "EWMwV5V9BxNs_U6nNVMeqw     Phoenix   \n",
       "V1nEpIRmEa1768oj_tuxeQ     Phoenix   \n",
       "WNy1uzcmm_UHmTyR--o5IA       Tempe   \n",
       "SDwYQ6eSu1htn8vHWv128g     Phoenix   \n",
       "-sC66z4SO3tR7nFCjfQwuQ     Phoenix   \n",
       "QnAzW6KMSciUcuJ20oI3Bw     Gilbert   \n",
       "OFBJtqWGSx6n6CchtVmoRw     Phoenix   \n",
       "pwpl-rxwNRQdgqFz_-qMPg     Phoenix   \n",
       "c1yGkETheht_1vjda7G5sA       Tempe   \n",
       "aRkYtXfmEKYG-eTDf_qUsw     Phoenix   \n",
       "uKSX1n1RoAzGq4bV8GPHVg     Phoenix   \n",
       "3oZcTGb_oDHGwZFiP-7kxQ     Phoenix   \n",
       "K8pM6qQdYu5h6buRE1-_sw     Phoenix   \n",
       "_FXql6eVhbM923RdCi94SA     Phoenix   \n",
       "YKOvlBNkF4KpUP9q7x862w  Scottsdale   \n",
       "Zx8_4zKdDBSO3qGrkukBIA     Phoenix   \n",
       "qjmCVYkwP-HDa35jwYucbQ     Phoenix   \n",
       "R8VwdLyvsp9iybNqRvm94g     Phoenix   \n",
       "xY1sPHTA2RGVFlh5tZhs9g  Scottsdale   \n",
       "3n9mSKySEv3G03YjcU-YOQ     Phoenix   \n",
       "1NZLxU5WvB5roPFzneAlLw     Phoenix   \n",
       "L9UYbtAUOcfTgZFimehlXw     Gilbert   \n",
       "AqbgC7Gul5Es1rRzGNLDFA  Scottsdale   \n",
       "rZbHg4ACfN3iShdsT47WKQ     Phoenix   \n",
       "5VMajxduxfLPSyQkVFKESg     Gilbert   \n",
       "53YGfwmbW73JhFiemNeyzQ  Scottsdale   \n",
       "uEJQSIjWui-TDWXaGlcqyQ  Scottsdale   \n",
       "FV0BkoGOd3Yu_eJnXY15ZA  Scottsdale   \n",
       "IVc23uY-36WUNYoIbz42Fg     Phoenix   \n",
       "MuIXnv7Oq7X3-4aEsp9dDA  Scottsdale   \n",
       "Bc4DoKgrKCtCuN-0O5He3A  Scottsdale   \n",
       "vARjqeIkSNsazHltujiq4Q        Mesa   \n",
       "FURgKkRFtMK5yKbjYZVVwA     Phoenix   \n",
       "I4bSn5gXsHuSPu7L-d_8nQ     Phoenix   \n",
       "6imLt53br7SJ3av07jjH7w     Phoenix   \n",
       "2ceeU8e3nZjaPfGmLwh4kg       Tempe   \n",
       "bgTB6MgdVQssXhkNJ7qIfw  Scottsdale   \n",
       "FqzgT9Y-Yu7jiWdHnGW-kQ     Phoenix   \n",
       "Y-9dJvw-J2d9QKfuL7mKgA     Phoenix   \n",
       "Xq9tkiHhyN_aBFswFeGLvA     Phoenix   \n",
       "AkOruz5CrCxUmXe1p_WoRg     Phoenix   \n",
       "zp713qNhx8d9KCJJnrw1xA     Phoenix   \n",
       "cp39VURFby4A6u9m2It8jg     Phoenix   \n",
       "V6BYjHM9SnXscfkln3hCdA  Scottsdale   \n",
       "\n",
       "                                                             full_address  \\\n",
       "business_id                                                                 \n",
       "hW0Ne_HTHEAgGF1rAdmR-g          3400 E Sky Harbor Blvd\\nPhoenix, AZ 85034   \n",
       "VVeogjZya58oiTxK7qUjAQ                  623 E Adams St\\nPhoenix, AZ 85004   \n",
       "JokKtdXU7zXHcr20Lrk29A            1340 E 8th St\\nSte 104\\nTempe, AZ 85281   \n",
       "ntN85eu27C04nwyPa8IHtw                    801 N 1st St\\nPhoenix, AZ 85004   \n",
       "EWMwV5V9BxNs_U6nNVMeqw              3815 N Central Ave\\nPhoenix, AZ 85012   \n",
       "V1nEpIRmEa1768oj_tuxeQ                   603 N 5th Ave\\nPhoenix, AZ 85003   \n",
       "WNy1uzcmm_UHmTyR--o5IA               960 W University Dr\\nTempe, AZ 85281   \n",
       "SDwYQ6eSu1htn8vHWv128g             3939 E Campbell Ave\\nPhoenix, AZ 85018   \n",
       "-sC66z4SO3tR7nFCjfQwuQ             401 W Clarendon Ave\\nPhoenix, AZ 85013   \n",
       "QnAzW6KMSciUcuJ20oI3Bw           3000 E Ray Rd\\nBldg 1\\nGilbert, AZ 85296   \n",
       "OFBJtqWGSx6n6CchtVmoRw             3146 E Camelback Rd\\nPhoenix, AZ 85016   \n",
       "pwpl-rxwNRQdgqFz_-qMPg             1916 E Camelback Rd\\nPhoenix, AZ 85016   \n",
       "c1yGkETheht_1vjda7G5sA              2240 N Scottsdale Rd\\nTempe, AZ 85281   \n",
       "aRkYtXfmEKYG-eTDf_qUsw              4402 N Central Ave\\nPhoenix, AZ 85012   \n",
       "uKSX1n1RoAzGq4bV8GPHVg              111 E Camelback Rd\\nPhoenix, AZ 85012   \n",
       "3oZcTGb_oDHGwZFiP-7kxQ                  5040 N 40th St\\nPhoenix, AZ 85018   \n",
       "K8pM6qQdYu5h6buRE1-_sw              1220 S Central Ave\\nPhoenix, AZ 85003   \n",
       "_FXql6eVhbM923RdCi94SA              4700 N Central Ave\\nPhoenix, AZ 85012   \n",
       "YKOvlBNkF4KpUP9q7x862w             3815 N Brown Ave\\nScottsdale, AZ 85251   \n",
       "Zx8_4zKdDBSO3qGrkukBIA         15414 N 19th Ave\\nSte K\\nPhoenix, AZ 85023   \n",
       "qjmCVYkwP-HDa35jwYucbQ             2502 E Camelback Rd\\nPhoenix, AZ 85016   \n",
       "R8VwdLyvsp9iybNqRvm94g                  4410 N 40th St\\nPhoenix, AZ 85018   \n",
       "xY1sPHTA2RGVFlh5tZhs9g  7135 E Camelback Rd\\nSte 125\\nScottsdale, AZ 8...   \n",
       "3n9mSKySEv3G03YjcU-YOQ              5144 N Central Ave\\nPhoenix, AZ 85012   \n",
       "1NZLxU5WvB5roPFzneAlLw                  2814 N 16th St\\nPhoenix, AZ 85006   \n",
       "L9UYbtAUOcfTgZFimehlXw                230 N Gilbert Rd\\nGilbert, AZ 85234   \n",
       "AqbgC7Gul5Es1rRzGNLDFA         4501 N Scottsdale Rd\\nScottsdale, AZ 85251   \n",
       "rZbHg4ACfN3iShdsT47WKQ                 8501 N 27th Ave\\nPhoenix, AZ 85051   \n",
       "5VMajxduxfLPSyQkVFKESg                301 N Gilbert Rd\\nGilbert, AZ 85234   \n",
       "53YGfwmbW73JhFiemNeyzQ  7135 E Camelback Rd\\nSte 195\\nScottsdale, AZ 8...   \n",
       "uEJQSIjWui-TDWXaGlcqyQ         2765 N Scottsdale Rd\\nScottsdale, AZ 85257   \n",
       "FV0BkoGOd3Yu_eJnXY15ZA     7133 E Stetson Dr\\nSte 1\\nScottsdale, AZ 85251   \n",
       "IVc23uY-36WUNYoIbz42Fg              2603 N Central Ave\\nPhoenix, AZ 85004   \n",
       "MuIXnv7Oq7X3-4aEsp9dDA        7111 E 5th Ave\\nSte E\\nScottsdale, AZ 85251   \n",
       "Bc4DoKgrKCtCuN-0O5He3A             9160 E Shea Blvd\\nScottsdale, AZ 85260   \n",
       "vARjqeIkSNsazHltujiq4Q       1941 W Guadalupe Rd\\nSte 101\\nMesa, AZ 85202   \n",
       "FURgKkRFtMK5yKbjYZVVwA              5223 N Central Ave\\nPhoenix, AZ 85012   \n",
       "I4bSn5gXsHuSPu7L-d_8nQ         3717 E Indian School Rd\\nPhoenix, AZ 85018   \n",
       "6imLt53br7SJ3av07jjH7w                     40 N 1st St\\nPhoenix, AZ 85004   \n",
       "2ceeU8e3nZjaPfGmLwh4kg                     850 S Ash Ave\\nTempe, AZ 85281   \n",
       "bgTB6MgdVQssXhkNJ7qIfw         7299 N Scottsdale Rd\\nScottsdale, AZ 85253   \n",
       "FqzgT9Y-Yu7jiWdHnGW-kQ                  4041 N 40th St\\nPhoenix, AZ 85018   \n",
       "Y-9dJvw-J2d9QKfuL7mKgA  4730 E Indian School Rd\\nSte 123\\nPhoenix, AZ ...   \n",
       "Xq9tkiHhyN_aBFswFeGLvA       2 E Jefferson St\\nSte 150\\nPhoenix, AZ 85004   \n",
       "AkOruz5CrCxUmXe1p_WoRg              914 E Camelback Rd\\nPhoenix, AZ 85014   \n",
       "zp713qNhx8d9KCJJnrw1xA                  1919 N 16th St\\nPhoenix, AZ 85006   \n",
       "cp39VURFby4A6u9m2It8jg    2502 E Camelback Rd\\nSte 127\\nPhoenix, AZ 85016   \n",
       "V6BYjHM9SnXscfkln3hCdA  7373 E Scottsdale Mall\\nSte 6\\nScottsdale, AZ ...   \n",
       "\n",
       "                         latitude   longitude  \\\n",
       "business_id                                     \n",
       "hW0Ne_HTHEAgGF1rAdmR-g  33.434750 -112.006440   \n",
       "VVeogjZya58oiTxK7qUjAQ  33.449233 -112.065458   \n",
       "JokKtdXU7zXHcr20Lrk29A  33.419451 -111.915926   \n",
       "ntN85eu27C04nwyPa8IHtw  33.456696 -112.072327   \n",
       "EWMwV5V9BxNs_U6nNVMeqw  33.491645 -112.073196   \n",
       "V1nEpIRmEa1768oj_tuxeQ  33.454848 -112.080071   \n",
       "WNy1uzcmm_UHmTyR--o5IA  33.422728 -111.951494   \n",
       "SDwYQ6eSu1htn8vHWv128g  33.502191 -111.996292   \n",
       "-sC66z4SO3tR7nFCjfQwuQ  33.491120 -112.079081   \n",
       "QnAzW6KMSciUcuJ20oI3Bw  33.321062 -111.723919   \n",
       "OFBJtqWGSx6n6CchtVmoRw  33.510040 -112.014641   \n",
       "pwpl-rxwNRQdgqFz_-qMPg  33.509446 -112.040395   \n",
       "c1yGkETheht_1vjda7G5sA  33.453787 -111.927166   \n",
       "aRkYtXfmEKYG-eTDf_qUsw  33.500572 -112.074114   \n",
       "uKSX1n1RoAzGq4bV8GPHVg  33.509276 -112.071818   \n",
       "3oZcTGb_oDHGwZFiP-7kxQ  33.512319 -111.995355   \n",
       "K8pM6qQdYu5h6buRE1-_sw  33.435455 -112.073914   \n",
       "_FXql6eVhbM923RdCi94SA  33.506208 -112.073914   \n",
       "YKOvlBNkF4KpUP9q7x862w  33.492298 -111.924552   \n",
       "Zx8_4zKdDBSO3qGrkukBIA  33.626933 -112.100731   \n",
       "qjmCVYkwP-HDa35jwYucbQ  33.510207 -112.027204   \n",
       "R8VwdLyvsp9iybNqRvm94g  33.502409 -111.995501   \n",
       "xY1sPHTA2RGVFlh5tZhs9g  33.501982 -111.927618   \n",
       "3n9mSKySEv3G03YjcU-YOQ  33.512770 -112.074012   \n",
       "1NZLxU5WvB5roPFzneAlLw  33.478794 -112.047809   \n",
       "L9UYbtAUOcfTgZFimehlXw  33.354701 -111.789790   \n",
       "AqbgC7Gul5Es1rRzGNLDFA  33.502499 -111.925895   \n",
       "rZbHg4ACfN3iShdsT47WKQ  33.561259 -112.115624   \n",
       "5VMajxduxfLPSyQkVFKESg  33.355044 -111.789531   \n",
       "53YGfwmbW73JhFiemNeyzQ  33.501982 -111.927618   \n",
       "uEJQSIjWui-TDWXaGlcqyQ  33.478794 -111.925909   \n",
       "FV0BkoGOd3Yu_eJnXY15ZA  33.499499 -111.927402   \n",
       "IVc23uY-36WUNYoIbz42Fg  33.477024 -112.073629   \n",
       "MuIXnv7Oq7X3-4aEsp9dDA  33.498028 -111.927951   \n",
       "Bc4DoKgrKCtCuN-0O5He3A  33.583480 -111.883526   \n",
       "vARjqeIkSNsazHltujiq4Q  33.362719 -111.876139   \n",
       "FURgKkRFtMK5yKbjYZVVwA  33.513697 -112.073412   \n",
       "I4bSn5gXsHuSPu7L-d_8nQ  33.495137 -112.001232   \n",
       "6imLt53br7SJ3av07jjH7w  33.449241 -112.072854   \n",
       "2ceeU8e3nZjaPfGmLwh4kg  33.420571 -111.942444   \n",
       "bgTB6MgdVQssXhkNJ7qIfw  33.542193 -111.925634   \n",
       "FqzgT9Y-Yu7jiWdHnGW-kQ  33.494459 -111.995329   \n",
       "Y-9dJvw-J2d9QKfuL7mKgA  33.494820 -111.979821   \n",
       "Xq9tkiHhyN_aBFswFeGLvA  33.447173 -112.073781   \n",
       "AkOruz5CrCxUmXe1p_WoRg  33.509337 -112.060818   \n",
       "zp713qNhx8d9KCJJnrw1xA  33.469132 -112.047512   \n",
       "cp39VURFby4A6u9m2It8jg  33.509535 -112.027592   \n",
       "V6BYjHM9SnXscfkln3hCdA  33.492502 -111.924119   \n",
       "\n",
       "                                                            name  \\\n",
       "business_id                                                        \n",
       "hW0Ne_HTHEAgGF1rAdmR-g  Phoenix Sky Harbor International Airport   \n",
       "VVeogjZya58oiTxK7qUjAQ                           Pizzeria Bianco   \n",
       "JokKtdXU7zXHcr20Lrk29A                     Four Peaks Brewing Co   \n",
       "ntN85eu27C04nwyPa8IHtw                      Matt's Big Breakfast   \n",
       "EWMwV5V9BxNs_U6nNVMeqw                                       FEZ   \n",
       "V1nEpIRmEa1768oj_tuxeQ                                      Cibo   \n",
       "WNy1uzcmm_UHmTyR--o5IA                     Cornish Pasty Company   \n",
       "SDwYQ6eSu1htn8vHWv128g                           Postino Arcadia   \n",
       "-sC66z4SO3tR7nFCjfQwuQ                         Gallo Blanco Cafe   \n",
       "QnAzW6KMSciUcuJ20oI3Bw                          Joe's Farm Grill   \n",
       "OFBJtqWGSx6n6CchtVmoRw                                     Delux   \n",
       "pwpl-rxwNRQdgqFz_-qMPg                                The Parlor   \n",
       "c1yGkETheht_1vjda7G5sA                                     Green   \n",
       "aRkYtXfmEKYG-eTDf_qUsw                                       Lux   \n",
       "uKSX1n1RoAzGq4bV8GPHVg                     St Francis Restaurant   \n",
       "3oZcTGb_oDHGwZFiP-7kxQ                         Chelsea's Kitchen   \n",
       "K8pM6qQdYu5h6buRE1-_sw                 Lo-Lo's Chicken & Waffles   \n",
       "_FXql6eVhbM923RdCi94SA                        Hula's Modern Tiki   \n",
       "YKOvlBNkF4KpUP9q7x862w                               The Mission   \n",
       "Zx8_4zKdDBSO3qGrkukBIA                             Chino Bandido   \n",
       "qjmCVYkwP-HDa35jwYucbQ                         True Food Kitchen   \n",
       "R8VwdLyvsp9iybNqRvm94g                  La Grande Orange Grocery   \n",
       "xY1sPHTA2RGVFlh5tZhs9g                          Culinary Dropout   \n",
       "3n9mSKySEv3G03YjcU-YOQ                           Postino Central   \n",
       "1NZLxU5WvB5roPFzneAlLw                               Barrio Café   \n",
       "L9UYbtAUOcfTgZFimehlXw                            Liberty Market   \n",
       "AqbgC7Gul5Es1rRzGNLDFA                        Sprinkles Cupcakes   \n",
       "rZbHg4ACfN3iShdsT47WKQ                                   Bobby Q   \n",
       "5VMajxduxfLPSyQkVFKESg                            Joe's Real BBQ   \n",
       "53YGfwmbW73JhFiemNeyzQ                               Olive & Ivy   \n",
       "uEJQSIjWui-TDWXaGlcqyQ                 Lo-Lo's Chicken & Waffles   \n",
       "FV0BkoGOd3Yu_eJnXY15ZA                               Cowboy Ciao   \n",
       "IVc23uY-36WUNYoIbz42Fg              Switch Restaurant & Wine Bar   \n",
       "MuIXnv7Oq7X3-4aEsp9dDA                      Citizen Public House   \n",
       "Bc4DoKgrKCtCuN-0O5He3A                            Sweet Republic   \n",
       "vARjqeIkSNsazHltujiq4Q                     Cornish Pasty Company   \n",
       "FURgKkRFtMK5yKbjYZVVwA                                   Windsor   \n",
       "I4bSn5gXsHuSPu7L-d_8nQ                           Beckett's Table   \n",
       "6imLt53br7SJ3av07jjH7w                                   Hanny's   \n",
       "2ceeU8e3nZjaPfGmLwh4kg                Casey Moore's Oyster House   \n",
       "bgTB6MgdVQssXhkNJ7qIfw                                 Roka Akor   \n",
       "FqzgT9Y-Yu7jiWdHnGW-kQ                                   The Vig   \n",
       "Y-9dJvw-J2d9QKfuL7mKgA                                 Over Easy   \n",
       "Xq9tkiHhyN_aBFswFeGLvA                      The Arrogant Butcher   \n",
       "AkOruz5CrCxUmXe1p_WoRg                 CherryBlossom Noodle Cafe   \n",
       "zp713qNhx8d9KCJJnrw1xA              La Condesa Gourmet Taco Shop   \n",
       "cp39VURFby4A6u9m2It8jg                                 Zinburger   \n",
       "V6BYjHM9SnXscfkln3hCdA                              Orange Table   \n",
       "\n",
       "                       neighborhoods  open  review_count  stars state  \\\n",
       "business_id                                                             \n",
       "hW0Ne_HTHEAgGF1rAdmR-g            []  True           862    3.0    AZ   \n",
       "VVeogjZya58oiTxK7qUjAQ            []  True           803    4.0    AZ   \n",
       "JokKtdXU7zXHcr20Lrk29A            []  True           735    4.5    AZ   \n",
       "ntN85eu27C04nwyPa8IHtw            []  True           689    4.0    AZ   \n",
       "EWMwV5V9BxNs_U6nNVMeqw            []  True           652    4.0    AZ   \n",
       "V1nEpIRmEa1768oj_tuxeQ            []  True           594    4.5    AZ   \n",
       "WNy1uzcmm_UHmTyR--o5IA            []  True           580    4.5    AZ   \n",
       "SDwYQ6eSu1htn8vHWv128g            []  True           575    4.5    AZ   \n",
       "-sC66z4SO3tR7nFCjfQwuQ            []  True           549    4.0    AZ   \n",
       "QnAzW6KMSciUcuJ20oI3Bw            []  True           525    4.0    AZ   \n",
       "OFBJtqWGSx6n6CchtVmoRw            []  True           502    4.0    AZ   \n",
       "pwpl-rxwNRQdgqFz_-qMPg            []  True           489    4.0    AZ   \n",
       "c1yGkETheht_1vjda7G5sA            []  True           477    4.5    AZ   \n",
       "aRkYtXfmEKYG-eTDf_qUsw            []  True           461    4.0    AZ   \n",
       "uKSX1n1RoAzGq4bV8GPHVg            []  True           461    4.0    AZ   \n",
       "3oZcTGb_oDHGwZFiP-7kxQ            []  True           453    4.0    AZ   \n",
       "K8pM6qQdYu5h6buRE1-_sw            []  True           450    4.5    AZ   \n",
       "_FXql6eVhbM923RdCi94SA            []  True           444    4.0    AZ   \n",
       "YKOvlBNkF4KpUP9q7x862w            []  True           441    4.0    AZ   \n",
       "Zx8_4zKdDBSO3qGrkukBIA            []  True           431    4.0    AZ   \n",
       "qjmCVYkwP-HDa35jwYucbQ            []  True           434    4.0    AZ   \n",
       "R8VwdLyvsp9iybNqRvm94g            []  True           421    4.0    AZ   \n",
       "xY1sPHTA2RGVFlh5tZhs9g            []  True           412    3.5    AZ   \n",
       "3n9mSKySEv3G03YjcU-YOQ            []  True           402    4.5    AZ   \n",
       "1NZLxU5WvB5roPFzneAlLw            []  True           398    4.0    AZ   \n",
       "L9UYbtAUOcfTgZFimehlXw            []  True           390    4.5    AZ   \n",
       "AqbgC7Gul5Es1rRzGNLDFA            []  True           362    3.5    AZ   \n",
       "rZbHg4ACfN3iShdsT47WKQ            []  True           363    4.5    AZ   \n",
       "5VMajxduxfLPSyQkVFKESg            []  True           353    4.0    AZ   \n",
       "53YGfwmbW73JhFiemNeyzQ            []  True           358    4.0    AZ   \n",
       "uEJQSIjWui-TDWXaGlcqyQ            []  True           357    4.0    AZ   \n",
       "FV0BkoGOd3Yu_eJnXY15ZA            []  True           349    4.0    AZ   \n",
       "IVc23uY-36WUNYoIbz42Fg            []  True           343    4.0    AZ   \n",
       "MuIXnv7Oq7X3-4aEsp9dDA            []  True           347    4.5    AZ   \n",
       "Bc4DoKgrKCtCuN-0O5He3A            []  True           335    4.5    AZ   \n",
       "vARjqeIkSNsazHltujiq4Q            []  True           333    4.5    AZ   \n",
       "FURgKkRFtMK5yKbjYZVVwA            []  True           326    4.0    AZ   \n",
       "I4bSn5gXsHuSPu7L-d_8nQ            []  True           323    4.0    AZ   \n",
       "6imLt53br7SJ3av07jjH7w            []  True           318    3.5    AZ   \n",
       "2ceeU8e3nZjaPfGmLwh4kg            []  True           317    4.0    AZ   \n",
       "bgTB6MgdVQssXhkNJ7qIfw            []  True           315    4.0    AZ   \n",
       "FqzgT9Y-Yu7jiWdHnGW-kQ            []  True           316    3.5    AZ   \n",
       "Y-9dJvw-J2d9QKfuL7mKgA            []  True           310    3.5    AZ   \n",
       "Xq9tkiHhyN_aBFswFeGLvA            []  True           321    4.0    AZ   \n",
       "AkOruz5CrCxUmXe1p_WoRg            []  True           309    4.0    AZ   \n",
       "zp713qNhx8d9KCJJnrw1xA            []  True           307    4.0    AZ   \n",
       "cp39VURFby4A6u9m2It8jg            []  True           305    3.5    AZ   \n",
       "V6BYjHM9SnXscfkln3hCdA            []  True           304    4.0    AZ   \n",
       "\n",
       "                            type  \n",
       "business_id                       \n",
       "hW0Ne_HTHEAgGF1rAdmR-g  business  \n",
       "VVeogjZya58oiTxK7qUjAQ  business  \n",
       "JokKtdXU7zXHcr20Lrk29A  business  \n",
       "ntN85eu27C04nwyPa8IHtw  business  \n",
       "EWMwV5V9BxNs_U6nNVMeqw  business  \n",
       "V1nEpIRmEa1768oj_tuxeQ  business  \n",
       "WNy1uzcmm_UHmTyR--o5IA  business  \n",
       "SDwYQ6eSu1htn8vHWv128g  business  \n",
       "-sC66z4SO3tR7nFCjfQwuQ  business  \n",
       "QnAzW6KMSciUcuJ20oI3Bw  business  \n",
       "OFBJtqWGSx6n6CchtVmoRw  business  \n",
       "pwpl-rxwNRQdgqFz_-qMPg  business  \n",
       "c1yGkETheht_1vjda7G5sA  business  \n",
       "aRkYtXfmEKYG-eTDf_qUsw  business  \n",
       "uKSX1n1RoAzGq4bV8GPHVg  business  \n",
       "3oZcTGb_oDHGwZFiP-7kxQ  business  \n",
       "K8pM6qQdYu5h6buRE1-_sw  business  \n",
       "_FXql6eVhbM923RdCi94SA  business  \n",
       "YKOvlBNkF4KpUP9q7x862w  business  \n",
       "Zx8_4zKdDBSO3qGrkukBIA  business  \n",
       "qjmCVYkwP-HDa35jwYucbQ  business  \n",
       "R8VwdLyvsp9iybNqRvm94g  business  \n",
       "xY1sPHTA2RGVFlh5tZhs9g  business  \n",
       "3n9mSKySEv3G03YjcU-YOQ  business  \n",
       "1NZLxU5WvB5roPFzneAlLw  business  \n",
       "L9UYbtAUOcfTgZFimehlXw  business  \n",
       "AqbgC7Gul5Es1rRzGNLDFA  business  \n",
       "rZbHg4ACfN3iShdsT47WKQ  business  \n",
       "5VMajxduxfLPSyQkVFKESg  business  \n",
       "53YGfwmbW73JhFiemNeyzQ  business  \n",
       "uEJQSIjWui-TDWXaGlcqyQ  business  \n",
       "FV0BkoGOd3Yu_eJnXY15ZA  business  \n",
       "IVc23uY-36WUNYoIbz42Fg  business  \n",
       "MuIXnv7Oq7X3-4aEsp9dDA  business  \n",
       "Bc4DoKgrKCtCuN-0O5He3A  business  \n",
       "vARjqeIkSNsazHltujiq4Q  business  \n",
       "FURgKkRFtMK5yKbjYZVVwA  business  \n",
       "I4bSn5gXsHuSPu7L-d_8nQ  business  \n",
       "6imLt53br7SJ3av07jjH7w  business  \n",
       "2ceeU8e3nZjaPfGmLwh4kg  business  \n",
       "bgTB6MgdVQssXhkNJ7qIfw  business  \n",
       "FqzgT9Y-Yu7jiWdHnGW-kQ  business  \n",
       "Y-9dJvw-J2d9QKfuL7mKgA  business  \n",
       "Xq9tkiHhyN_aBFswFeGLvA  business  \n",
       "AkOruz5CrCxUmXe1p_WoRg  business  \n",
       "zp713qNhx8d9KCJJnrw1xA  business  \n",
       "cp39VURFby4A6u9m2It8jg  business  \n",
       "V6BYjHM9SnXscfkln3hCdA  business  "
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.merge(top_restro,bd2,left_index=True, right_index=True).sort_values('text',ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "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.5.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}