biz_data_explore.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import json\n",
    "import pandas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "bizdata='data/yelp_academic_dataset_business.json'\n",
    "reviews='data/yelp_academic_dataset_review.json'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "def read_data(datafilename):\n",
    "    data_file = open(datafilename,'r')\n",
    "    data = []\n",
    "    for line in data_file:\n",
    "        data.append(json.loads(line))\n",
    "    data_file.close()\n",
    "    return data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(192609, 60)\n",
      "Index(['business_id', 'name', 'address', 'city', 'state', 'postal_code',\n",
      "       'latitude', 'longitude', 'stars', 'review_count', 'is_open',\n",
      "       'categories', 'hours', 'attributes.GoodForKids',\n",
      "       'attributes.RestaurantsReservations', 'attributes.GoodForMeal',\n",
      "       'attributes.BusinessParking', 'attributes.Caters',\n",
      "       'attributes.NoiseLevel', 'attributes.RestaurantsTableService',\n",
      "       'attributes.RestaurantsTakeOut', 'attributes.RestaurantsPriceRange2',\n",
      "       'attributes.OutdoorSeating', 'attributes.BikeParking',\n",
      "       'attributes.Ambience', 'attributes.HasTV', 'attributes.WiFi',\n",
      "       'attributes.Alcohol', 'attributes.RestaurantsAttire',\n",
      "       'attributes.RestaurantsGoodForGroups', 'attributes.RestaurantsDelivery',\n",
      "       'hours.Monday', 'hours.Tuesday', 'hours.Wednesday', 'hours.Thursday',\n",
      "       'hours.Friday', 'hours.Saturday', 'hours.Sunday',\n",
      "       'attributes.BusinessAcceptsCreditCards', 'attributes',\n",
      "       'attributes.BusinessAcceptsBitcoin', 'attributes.ByAppointmentOnly',\n",
      "       'attributes.AcceptsInsurance', 'attributes.Music',\n",
      "       'attributes.GoodForDancing', 'attributes.CoatCheck',\n",
      "       'attributes.HappyHour', 'attributes.BestNights',\n",
      "       'attributes.WheelchairAccessible', 'attributes.DogsAllowed',\n",
      "       'attributes.BYOBCorkage', 'attributes.DriveThru', 'attributes.Smoking',\n",
      "       'attributes.AgesAllowed', 'attributes.HairSpecializesIn',\n",
      "       'attributes.Corkage', 'attributes.BYOB',\n",
      "       'attributes.DietaryRestrictions', 'attributes.Open24Hours',\n",
      "       'attributes.RestaurantsCounterService'],\n",
      "      dtype='object')\n"
     ]
    }
   ],
   "source": [
    "#load\n",
    "bizraw=read_data(bizdata)\n",
    "bizdf_ = pandas.json_normalize(bizraw,max_level=1)\n",
    "print(bizdf_.shape)\n",
    "print(bizdf_.columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(192609, 58)\n",
      "(108179, 58)\n",
      "(108082, 58)\n",
      "Index(['business_id', 'name', 'address', 'city', 'state', 'postal_code',\n",
      "       'latitude', 'longitude', 'stars', 'review_count', 'is_open',\n",
      "       'categories', 'attributes.GoodForKids',\n",
      "       'attributes.RestaurantsReservations', 'attributes.GoodForMeal',\n",
      "       'attributes.BusinessParking', 'attributes.Caters',\n",
      "       'attributes.NoiseLevel', 'attributes.RestaurantsTableService',\n",
      "       'attributes.RestaurantsTakeOut', 'attributes.RestaurantsPriceRange2',\n",
      "       'attributes.OutdoorSeating', 'attributes.BikeParking',\n",
      "       'attributes.Ambience', 'attributes.HasTV', 'attributes.WiFi',\n",
      "       'attributes.Alcohol', 'attributes.RestaurantsAttire',\n",
      "       'attributes.RestaurantsGoodForGroups', 'attributes.RestaurantsDelivery',\n",
      "       'hours.Monday', 'hours.Tuesday', 'hours.Wednesday', 'hours.Thursday',\n",
      "       'hours.Friday', 'hours.Saturday', 'hours.Sunday',\n",
      "       'attributes.BusinessAcceptsCreditCards',\n",
      "       'attributes.BusinessAcceptsBitcoin', 'attributes.ByAppointmentOnly',\n",
      "       'attributes.AcceptsInsurance', 'attributes.Music',\n",
      "       'attributes.GoodForDancing', 'attributes.CoatCheck',\n",
      "       'attributes.HappyHour', 'attributes.BestNights',\n",
      "       'attributes.WheelchairAccessible', 'attributes.DogsAllowed',\n",
      "       'attributes.BYOBCorkage', 'attributes.DriveThru', 'attributes.Smoking',\n",
      "       'attributes.AgesAllowed', 'attributes.HairSpecializesIn',\n",
      "       'attributes.Corkage', 'attributes.BYOB',\n",
      "       'attributes.DietaryRestrictions', 'attributes.Open24Hours',\n",
      "       'attributes.RestaurantsCounterService'],\n",
      "      dtype='object')\n"
     ]
    }
   ],
   "source": [
    "#clean\n",
    "print(bizdf_.shape)\n",
    "# bizdf_=bizdf_.drop(['hours','attributes'],axis=1)\n",
    "# print(bizdf_.shape)\n",
    "bizdf=bizdf_.dropna(subset=['attributes.RestaurantsPriceRange2'])\n",
    "print(bizdf.shape)\n",
    "bizdf=bizdf[bizdf['attributes.RestaurantsPriceRange2']!='None']\n",
    "print(bizdf.shape)\n",
    "print(bizdf.columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2    61506\n",
      "1    33859\n",
      "3    10462\n",
      "4     2255\n",
      "Name: attributes.RestaurantsPriceRange2, dtype: int64\n"
     ]
    }
   ],
   "source": [
    "priceranges=bizdf['attributes.RestaurantsPriceRange2'].value_counts()\n",
    "print(priceranges)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "business_id                                                         QXAEGFB4oINsVuTFxEYKFQ\n",
      "name                                                            Emerald Chinese Restaurant\n",
      "address                                                               30 Eglinton Avenue W\n",
      "city                                                                           Mississauga\n",
      "state                                                                                   ON\n",
      "postal_code                                                                        L5R 3E7\n",
      "latitude                                                                           43.6055\n",
      "longitude                                                                         -79.6523\n",
      "stars                                                                                  2.5\n",
      "review_count                                                                           128\n",
      "is_open                                                                                  1\n",
      "categories                               Specialty Food, Restaurants, Dim Sum, Imported...\n",
      "attributes.GoodForKids                                                                True\n",
      "attributes.RestaurantsReservations                                                    True\n",
      "attributes.GoodForMeal                   {'dessert': False, 'latenight': False, 'lunch'...\n",
      "attributes.BusinessParking               {'garage': False, 'street': False, 'validated'...\n",
      "attributes.Caters                                                                     True\n",
      "attributes.NoiseLevel                                                              u'loud'\n",
      "attributes.RestaurantsTableService                                                    True\n",
      "attributes.RestaurantsTakeOut                                                         True\n",
      "attributes.RestaurantsPriceRange2                                                        2\n",
      "attributes.OutdoorSeating                                                            False\n",
      "attributes.BikeParking                                                               False\n",
      "attributes.Ambience                      {'romantic': False, 'intimate': False, 'classy...\n",
      "attributes.HasTV                                                                     False\n",
      "attributes.WiFi                                                                      u'no'\n",
      "attributes.Alcohol                                                             u'full_bar'\n",
      "attributes.RestaurantsAttire                                                     u'casual'\n",
      "attributes.RestaurantsGoodForGroups                                                   True\n",
      "attributes.RestaurantsDelivery                                                       False\n",
      "hours.Monday                                                                       9:0-0:0\n",
      "hours.Tuesday                                                                      9:0-0:0\n",
      "hours.Wednesday                                                                    9:0-0:0\n",
      "hours.Thursday                                                                     9:0-0:0\n",
      "hours.Friday                                                                       9:0-1:0\n",
      "hours.Saturday                                                                     9:0-1:0\n",
      "hours.Sunday                                                                       9:0-0:0\n",
      "attributes.BusinessAcceptsCreditCards                                                  NaN\n",
      "attributes.BusinessAcceptsBitcoin                                                      NaN\n",
      "attributes.ByAppointmentOnly                                                           NaN\n",
      "attributes.AcceptsInsurance                                                            NaN\n",
      "attributes.Music                                                                       NaN\n",
      "attributes.GoodForDancing                                                              NaN\n",
      "attributes.CoatCheck                                                                   NaN\n",
      "attributes.HappyHour                                                                   NaN\n",
      "attributes.BestNights                                                                  NaN\n",
      "attributes.WheelchairAccessible                                                        NaN\n",
      "attributes.DogsAllowed                                                                 NaN\n",
      "attributes.BYOBCorkage                                                                 NaN\n",
      "attributes.DriveThru                                                                   NaN\n",
      "attributes.Smoking                                                                     NaN\n",
      "attributes.AgesAllowed                                                                 NaN\n",
      "attributes.HairSpecializesIn                                                           NaN\n",
      "attributes.Corkage                                                                     NaN\n",
      "attributes.BYOB                                                                        NaN\n",
      "attributes.DietaryRestrictions                                                         NaN\n",
      "attributes.Open24Hours                                                                 NaN\n",
      "attributes.RestaurantsCounterService                                                   NaN\n",
      "Name: 1, dtype: object\n"
     ]
    }
   ],
   "source": [
    "print(bizdf.iloc[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(108082, 4)\n"
     ]
    }
   ],
   "source": [
    "bizdfsmall=bizdf[['business_id', 'name','attributes.RestaurantsPriceRange2','review_count']]\n",
    "print(bizdfsmall.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "              business_id                         name  \\\n",
      "1  QXAEGFB4oINsVuTFxEYKFQ   Emerald Chinese Restaurant   \n",
      "2  gnKjwL_1w79qoiV3IC_xQQ  Musashi Japanese Restaurant   \n",
      "5  68dUKd8_8liJ7in4aWOSEA                The UPS Store   \n",
      "6  5JucpCfHZltJh5r1JabjDg             Edgeworxx Studio   \n",
      "7  gbQN7vr_caG_A1ugSmGhWg                    Supercuts   \n",
      "\n",
      "  attributes.RestaurantsPriceRange2  review_count  \n",
      "1                                 2           128  \n",
      "2                                 2           170  \n",
      "5                                 2             3  \n",
      "6                                 2             7  \n",
      "7                                 3             3  \n"
     ]
    }
   ],
   "source": [
    "print(bizdfsmall.iloc[:5])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYoAAAD4CAYAAADy46FuAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAAATkklEQVR4nO3df6zd9X3f8edrdkMcUgg/xhWz0UyE1Y0f6hIsSpqpupqr4iZVzR8guSLDnTxZQqxLO6TKrH9E22QJplJa2ECyQoqhLOC50WylYg0yvZomgalJsjngMNzCwMGFMAjF0SCYvffH+dzk+Ob6c/E55t5r+/mQjs73vL/fz/d8zlsXXnx/nEOqCkmSjuXvLPQEJEmLm0EhSeoyKCRJXQaFJKnLoJAkdS1d6AmcaOeff36tXLly5PE//OEPOfPMM0/chE5B9qjP/szNHs1tvnv09NNPv15Vf3e2dadcUKxcuZK9e/eOPH5qaorJyckTN6FTkD3qsz9zs0dzm+8eJfnfx1rnqSdJUpdBIUnqMigkSV0GhSSpy6CQJHUZFJKkLoNCktRlUEiSugwKSVLXKffN7HHt+95b/ObmP5v3933xts/P+3tK0gfhEYUkqcugkCR1GRSSpC6DQpLUZVBIkroMCklSl0EhSeoyKCRJXQaFJKnLoJAkdc0ZFEm+kuS1JN8Zqp2b5LEkz7fnc4bW3ZrkQJLnklwzVL8yyb627q4kafUzkjzS6nuSrBwas6G9x/NJNpywTy1J+sA+yBHF/cDaGbXNwO6qWgXsbq9JcimwHrisjbknyZI25l5gE7CqPab3uRF4s6ouAe4Ebm/7Ohf4EvALwFXAl4YDSZI0P+YMiqr6b8AbM8rrgG1teRtw7VD94ap6t6peAA4AVyW5EDirqp6oqgIemDFmel87gDXtaOMa4LGqeqOq3gQe46cDS5L0IRv112MnquoQQFUdSnJBqy8Hnhza7mCrvdeWZ9anx7zc9nUkyVvAecP1WcYcJckmBkcrTExMMDU1NeLHgollcMsVR0YeP6px5jzfDh8+fFLNd77Zn7nZo7ktph6d6J8Zzyy16tRHHXN0sWorsBVg9erVNTk5OedEj+Xuh3Zyx775//X1F2+YnPf3HNXU1BTj9PhUZ3/mZo/mtph6NOpdT6+200m059da/SBw0dB2K4BXWn3FLPWjxiRZCpzN4FTXsfYlSZpHowbFLmD6LqQNwM6h+vp2J9PFDC5aP9VOU72d5Op2/eHGGWOm93Ud8Hi7jvHnwK8kOaddxP6VVpMkzaM5z7Ek+SowCZyf5CCDO5FuA7Yn2Qi8BFwPUFXPJNkOPAscAW6uqvfbrm5icAfVMuDR9gC4D3gwyQEGRxLr277eSPLvgL9s2/3bqpp5UV2S9CGbMyiq6jeOsWrNMbbfAmyZpb4XuHyW+ju0oJll3VeAr8w1R0nSh8dvZkuSugwKSVKXQSFJ6jIoJEldBoUkqcugkCR1GRSSpC6DQpLUZVBIkroMCklSl0EhSeoyKCRJXQaFJKnLoJAkdRkUkqQug0KS1GVQSJK6DApJUpdBIUnqMigkSV0GhSSpy6CQJHUZFJKkLoNCktRlUEiSugwKSVKXQSFJ6jIoJEldBoUkqcugkCR1jRUUSX4nyTNJvpPkq0k+muTcJI8leb49nzO0/a1JDiR5Lsk1Q/Urk+xr6+5KklY/I8kjrb4nycpx5itJOn4jB0WS5cC/BFZX1eXAEmA9sBnYXVWrgN3tNUkubesvA9YC9yRZ0nZ3L7AJWNUea1t9I/BmVV0C3AncPup8JUmjGffU01JgWZKlwMeAV4B1wLa2fhtwbVteBzxcVe9W1QvAAeCqJBcCZ1XVE1VVwAMzxkzvawewZvpoQ5I0P5aOOrCqvpfk94GXgP8LfKOqvpFkoqoOtW0OJbmgDVkOPDm0i4Ot9l5bnlmfHvNy29eRJG8B5wGvD88lySYGRyRMTEwwNTU16sdiYhnccsWRkcePapw5z7fDhw+fVPOdb/ZnbvZoboupRyMHRbv2sA64GPgB8J+TfKE3ZJZadeq9MUcXqrYCWwFWr15dk5OTnWn03f3QTu7YN3JbRvbiDZPz/p6jmpqaYpwen+rsz9zs0dwWU4/GOfX0y8ALVfX9qnoP+Brwi8Cr7XQS7fm1tv1B4KKh8SsYnKo62JZn1o8a005vnQ28McacJUnHaZygeAm4OsnH2nWDNcB+YBewoW2zAdjZlncB69udTBczuGj9VDtN9XaSq9t+bpwxZnpf1wGPt+sYkqR5Ms41ij1JdgDfBI4A32Jw+ufjwPYkGxmEyfVt+2eSbAeebdvfXFXvt93dBNwPLAMebQ+A+4AHkxxgcCSxftT5SpJGM9bJ+Kr6EvClGeV3GRxdzLb9FmDLLPW9wOWz1N+hBY0kaWH4zWxJUpdBIUnqMigkSV0GhSSpy6CQJHUZFJKkLoNCktRlUEiSugwKSVKXQSFJ6jIoJEldBoUkqcugkCR1GRSSpC6DQpLUZVBIkroMCklSl0EhSeoyKCRJXQaFJKnLoJAkdRkUkqQug0KS1GVQSJK6DApJUpdBIUnqMigkSV0GhSSpy6CQJHWNFRRJPpFkR5LvJtmf5DNJzk3yWJLn2/M5Q9vfmuRAkueSXDNUvzLJvrburiRp9TOSPNLqe5KsHGe+kqTjN+4RxR8B/7Wq/gHw88B+YDOwu6pWAbvba5JcCqwHLgPWAvckWdL2cy+wCVjVHmtbfSPwZlVdAtwJ3D7mfCVJx2nkoEhyFvBLwH0AVfWjqvoBsA7Y1jbbBlzbltcBD1fVu1X1AnAAuCrJhcBZVfVEVRXwwIwx0/vaAayZPtqQJM2PpWOM/STwfeCPk/w88DTwRWCiqg4BVNWhJBe07ZcDTw6NP9hq77XlmfXpMS+3fR1J8hZwHvD68ESSbGJwRMLExARTU1Mjf6iJZXDLFUdGHj+qceY83w4fPnxSzXe+2Z+52aO5LaYejRMUS4FPA79VVXuS/BHtNNMxzHYkUJ16b8zRhaqtwFaA1atX1+TkZGcafXc/tJM79o3TltG8eMPkvL/nqKamphinx6c6+zM3ezS3xdSjca5RHAQOVtWe9noHg+B4tZ1Ooj2/NrT9RUPjVwCvtPqKWepHjUmyFDgbeGOMOUuSjtPIQVFVfwO8nOTnWmkN8CywC9jQahuAnW15F7C+3cl0MYOL1k+101RvJ7m6XX+4ccaY6X1dBzzermNIkubJuOdYfgt4KMlHgL8G/hmD8NmeZCPwEnA9QFU9k2Q7gzA5AtxcVe+3/dwE3A8sAx5tDxhcKH8wyQEGRxLrx5yvJOk4jRUUVfVtYPUsq9YcY/stwJZZ6nuBy2epv0MLGknSwvCb2ZKkLoNCktRlUEiSugwKSVKXQSFJ6jIoJEldBoUkqcugkCR1GRSSpC6DQpLUZVBIkroMCklSl0EhSeoyKCRJXQaFJKnLoJAkdRkUkqQug0KS1GVQSJK6DApJUpdBIUnqMigkSV0GhSSpy6CQJHUZFJKkLoNCktRlUEiSugwKSVKXQSFJ6jIoJEldYwdFkiVJvpXk6+31uUkeS/J8ez5naNtbkxxI8lySa4bqVybZ19bdlSStfkaSR1p9T5KV485XknR8TsQRxReB/UOvNwO7q2oVsLu9JsmlwHrgMmAtcE+SJW3MvcAmYFV7rG31jcCbVXUJcCdw+wmYryTpOIwVFElWAJ8HvjxUXgdsa8vbgGuH6g9X1btV9QJwALgqyYXAWVX1RFUV8MCMMdP72gGsmT7akCTNj6Vjjv9D4HeBnx2qTVTVIYCqOpTkglZfDjw5tN3BVnuvLc+sT495ue3rSJK3gPOA14cnkWQTgyMSJiYmmJqaGvkDTSyDW644MvL4UY0z5/l2+PDhk2q+883+zM0ezW0x9WjkoEjya8BrVfV0kskPMmSWWnXqvTFHF6q2AlsBVq9eXZOTH2Q6s7v7oZ3csW/c/Dx+L94wOe/vOaqpqSnG6fGpzv7MzR7NbTH1aJx/I34W+PUknwM+CpyV5E+AV5Nc2I4mLgRea9sfBC4aGr8CeKXVV8xSHx5zMMlS4GzgjTHmLEk6TiNfo6iqW6tqRVWtZHCR+vGq+gKwC9jQNtsA7GzLu4D17U6mixlctH6qnaZ6O8nV7frDjTPGTO/ruvYeP3VEIUn68HwY51huA7Yn2Qi8BFwPUFXPJNkOPAscAW6uqvfbmJuA+4FlwKPtAXAf8GCSAwyOJNZ/CPOVJHWckKCoqilgqi3/H2DNMbbbAmyZpb4XuHyW+ju0oJEkLQy/mS1J6jIoJEldBoUkqcugkCR1GRSSpC6DQpLUZVBIkroMCklSl0EhSeoyKCRJXQaFJKnLoJAkdRkUkqQug0KS1GVQSJK6DApJUpdBIUnqMigkSV0GhSSpy6CQJHUZFJKkLoNCktRlUEiSugwKSVKXQSFJ6jIoJEldBoUkqcugkCR1GRSSpK6RgyLJRUn+Isn+JM8k+WKrn5vksSTPt+dzhsbcmuRAkueSXDNUvzLJvrburiRp9TOSPNLqe5KsHOOzSpJGMM4RxRHglqr6h8DVwM1JLgU2A7urahWwu72mrVsPXAasBe5JsqTt615gE7CqPda2+kbgzaq6BLgTuH2M+UqSRjByUFTVoar6Zlt+G9gPLAfWAdvaZtuAa9vyOuDhqnq3ql4ADgBXJbkQOKuqnqiqAh6YMWZ6XzuANdNHG5Kk+bH0ROyknRL6FLAHmKiqQzAIkyQXtM2WA08ODTvYau+15Zn16TEvt30dSfIWcB7w+oz338TgiISJiQmmpqZG/iwTy+CWK46MPH5U48x5vh0+fPikmu98sz9zs0dzW0w9Gjsoknwc+FPgt6vqbzv/wT/biurUe2OOLlRtBbYCrF69uiYnJ+eY9bHd/dBO7th3QvLzuLx4w+S8v+eopqamGKfHpzr7Mzd7NLfF1KOx7npK8jMMQuKhqvpaK7/aTifRnl9r9YPARUPDVwCvtPqKWepHjUmyFDgbeGOcOUuSjs84dz0FuA/YX1V/MLRqF7ChLW8Adg7V17c7mS5mcNH6qXaa6u0kV7d93jhjzPS+rgMeb9cxJEnzZJxzLJ8F/imwL8m3W+1fA7cB25NsBF4CrgeoqmeSbAeeZXDH1M1V9X4bdxNwP7AMeLQ9YBBEDyY5wOBIYv0Y85UkjWDkoKiq/87s1xAA1hxjzBZgyyz1vcDls9TfoQWNJGlh+M1sSVKXQSFJ6jIoJEldBoUkqcugkCR1GRSSpC6DQpLUZVBIkroMCklSl0EhSeoyKCRJXQaFJKnLoJAkdRkUkqQug0KS1GVQSJK6DApJUpdBIUnqMigkSV0GhSSpy6CQJHUZFJKkLoNCktRlUEiSugwKSVKXQSFJ6jIoJEldBoUkqcugkCR1GRSSpK6TIiiSrE3yXJIDSTYv9Hwk6XSy6IMiyRLgPwK/ClwK/EaSSxd2VpJ0+li60BP4AK4CDlTVXwMkeRhYBzy7oLM6wVZu/rMFe+8Xb/v8gr23pMXvZAiK5cDLQ68PAr8wvEGSTcCm9vJwkufGeL/zgdfHGH/Sye3HPeS069Fxsj9zs0dzm+8e/f1jrTgZgiKz1OqoF1Vbga0n5M2SvVW1+kTs61Rlj/rsz9zs0dwWU48W/TUKBkcQFw29XgG8skBzkaTTzskQFH8JrEpycZKPAOuBXQs8J0k6bSz6U09VdSTJvwD+HFgCfKWqnvkQ3/KEnMI6xdmjPvszN3s0t0XTo1TV3FtJkk5bJ8OpJ0nSAjIoJEldBkVzOv9MSJKLkvxFkv1JnknyxVY/N8ljSZ5vz+cMjbm19eq5JNcM1a9Msq+tuyvJbLc3n5SSLEnyrSRfb6/tz5Akn0iyI8l329/SZ+zR0ZL8Tvtn7DtJvprkoydFj6rqtH8wuEj+V8AngY8A/wO4dKHnNY+f/0Lg0235Z4H/xeDnUv49sLnVNwO3t+VLW4/OAC5uvVvS1j0FfIbB918eBX51oT/fCezTvwL+E/D19tr+HN2fbcA/b8sfAT5hj47qz3LgBWBZe70d+M2ToUceUQz8+GdCqupHwPTPhJwWqupQVX2zLb8N7GfwR72OwT/8tOdr2/I64OGqereqXgAOAFcluRA4q6qeqMFf8wNDY05qSVYAnwe+PFS2P02Ss4BfAu4DqKofVdUPsEczLQWWJVkKfIzBd8IWfY8MioHZfiZk+QLNZUElWQl8CtgDTFTVIRiECXBB2+xY/VrelmfWTwV/CPwu8P+GavbnJz4JfB/443Z67stJzsQe/VhVfQ/4feAl4BDwVlV9g5OgRwbFwJw/E3I6SPJx4E+B366qv+1tOkutOvWTWpJfA16rqqc/6JBZaqdsf5qlwKeBe6vqU8APGZxGOZbTrkft2sM6BqeR/h5wZpIv9IbMUluQHhkUA6f9z4Qk+RkGIfFQVX2tlV9th7m059da/Vj9OtiWZ9ZPdp8Ffj3JiwxOS/6TJH+C/Rl2EDhYVXva6x0MgsMe/cQvAy9U1fer6j3ga8AvchL0yKAYOK1/JqTdMXEfsL+q/mBo1S5gQ1veAOwcqq9PckaSi4FVwFPtsPntJFe3fd44NOakVVW3VtWKqlrJ4G/j8ar6Avbnx6rqb4CXk/xcK61h8L8CsEc/8RJwdZKPtc+2hsH1wMXfo4W+E2CxPIDPMbjb56+A31vo+czzZ//HDA5d/yfw7fb4HHAesBt4vj2fOzTm91qvnmPojgtgNfCdtu4/0L79f6o8gEl+cteT/Tm6N/8I2Nv+jv4LcI49+qke/Rvgu+3zPcjgjqZF3yN/wkOS1OWpJ0lSl0EhSeoyKCRJXQaFJKnLoJAkdRkUkqQug0KS1PX/ARPm4DkCQUtFAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "rchist=bizdfsmall['review_count'].hist(bins=10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYQAAAD4CAYAAADsKpHdAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAAAYvElEQVR4nO3df2xV95nn8fenkG09dEjzo7liMVpYBc2WHyrZWCy7Wa28pVo8yWigUiK5SgtVWbmKiDZdIY1g5o9pVSEl0lBmEw1ItGQhDFOCaLugtJmdiPSqqkRgSCdTBwgb78AGBzZMGkpxpDAxffaP87h7cS729b22L/b9vKSre+5zzvee8xjjj8+P66OIwMzM7GPN3gAzM7s1OBDMzAxwIJiZWXIgmJkZ4EAwM7M0s9kbUK+777475s+fX9fY999/n1mzZo3vBt3i3HNrcM+toZGeX3311Xcj4tPV5k3ZQJg/fz4nTpyoa2y5XKazs3N8N+gW555bg3tuDY30LOn/3GyeDxmZmRngQDAzs+RAMDMzwIFgZmbJgWBmZoADwczMkgPBzMwAB4KZmSUHgpmZAVP4k8qN6H37Cl/Z9KOmrPvckw81Zb1mZqPxHoKZmQFjCARJMyT9naQX8vWdkl6S9GY+31Gx7GZJfZLOSFpVUb9fUm/Oe1qSsv5xSc9n/Zik+ePYo5mZ1WAsewhPAKcrXm8CjkTEQuBIvkbSIqAbWAx0AdslzcgxO4AeYGE+urK+HrgcEfcC24Cn6urGzMzqVlMgSGoHHgK+W1FeDezJ6T3Amor6/oi4FhFngT5guaQ5wOyIOBoRATw3bMzQex0EVg7tPZiZ2eSo9aTynwN/BPxuRa0UERcBIuKipHuyPhd4pWK5/qx9mNPD60Njzud7DUq6AtwFvFu5EZJ6KPYwKJVKlMvlGjf/RqU22Lh0sK6xjap3mxs1MDDQtHU3i3tuDe55/IwaCJL+ALgUEa9K6qzhPav9Zh8j1Ecac2MhYiewE6CjoyPq/Xvgz+w7xNbe5lxgde7Rzqas138zvjW459YwUT3X8lPxAeAPJT0IfAKYLekvgXckzcm9gznApVy+H5hXMb4duJD19ir1yjH9kmYCtwPv1dmTmZnVYdRzCBGxOSLaI2I+xcnilyPiS8BhYF0utg44lNOHge68cmgBxcnj43l46aqkFXl+YO2wMUPv9XCu4yN7CGZmNnEaOW7yJHBA0nrgLeARgIg4KekAcAoYBDZExPUc8xiwG2gDXswHwC5gr6Q+ij2D7ga2y8zM6jCmQIiIMlDO6V8CK2+y3BZgS5X6CWBJlfoHZKCYmVlz+JPKZmYGOBDMzCw5EMzMDHAgmJlZciCYmRngQDAzs+RAMDMzwIFgZmbJgWBmZoADwczMkgPBzMwAB4KZmSUHgpmZAQ4EMzNLDgQzMwMcCGZmlkYNBEmfkHRc0t9LOinpm1n/hqS3Jb2WjwcrxmyW1CfpjKRVFfX7JfXmvKfzVprk7Tafz/oxSfMnoFczMxtBLXsI14DPRcRngWVAl6QVOW9bRCzLx48BJC2iuAXmYqAL2C5pRi6/A+ihuM/ywpwPsB64HBH3AtuApxruzMzMxmTUQIjCQL68LR8xwpDVwP6IuBYRZ4E+YLmkOcDsiDgaEQE8B6ypGLMnpw8CK4f2HszMbHLUdA5B0gxJrwGXgJci4ljOelzSLyQ9K+mOrM0FzlcM78/a3JweXr9hTEQMAleAu8bejpmZ1WtmLQtFxHVgmaRPAT+UtITi8M+3KPYWvgVsBb4KVPvNPkaoM8q835LUQ3HIiVKpRLlcrmXzP6LUBhuXDtY1tlH1bnOjBgYGmrbuZnHPrcE9j5+aAmFIRPxKUhnoiog/G6pL+g7wQr7sB+ZVDGsHLmS9vUq9cky/pJnA7cB7Vda/E9gJ0NHREZ2dnWPZ/N96Zt8htvaOqfVxc+7Rzqast1wuU+/Xa6pyz63BPY+fWq4y+nTuGSCpDfg88EaeExjyBeD1nD4MdOeVQwsoTh4fj4iLwFVJK/L8wFrgUMWYdTn9MPBynmcwM7NJUsuvyXOAPXml0MeAAxHxgqS9kpZRHNo5B3wNICJOSjoAnAIGgQ15yAngMWA30Aa8mA+AXcBeSX0UewbdjbdmZmZjMWogRMQvgPuq1L88wpgtwJYq9RPAkir1D4BHRtsWMzObOP6kspmZAQ4EMzNLDgQzMwMcCGZmlhwIZmYGOBDMzCw5EMzMDHAgmJlZciCYmRngQDAzs+RAMDMzwIFgZmbJgWBmZoADwczMkgPBzMwAB4KZmSUHgpmZAbXdU/kTko5L+ntJJyV9M+t3SnpJ0pv5fEfFmM2S+iSdkbSqon6/pN6c93TeW5m8//LzWT8maf4E9GpmZiOoZQ/hGvC5iPgssAzokrQC2AQciYiFwJF8jaRFFPdEXgx0AdvzfswAO4AeYGE+urK+HrgcEfcC24CnGm/NzMzGYtRAiMJAvrwtHwGsBvZkfQ+wJqdXA/sj4lpEnAX6gOWS5gCzI+JoRATw3LAxQ+91EFg5tPdgZmaTY2YtC+Vv+K8C9wJ/ERHHJJUi4iJARFyUdE8uPhd4pWJ4f9Y+zOnh9aEx5/O9BiVdAe4C3h22HT0UexiUSiXK5XKNbd6o1AYblw7WNbZR9W5zowYGBpq27mZxz63BPY+fmgIhIq4DyyR9CvihpCUjLF7tN/sYoT7SmOHbsRPYCdDR0RGdnZ0jbMbNPbPvEFt7a2p93J17tLMp6y2Xy9T79Zqq3HNrcM/jZ0xXGUXEr4AyxbH/d/IwEPl8KRfrB+ZVDGsHLmS9vUr9hjGSZgK3A++NZdvMzKwxtVxl9OncM0BSG/B54A3gMLAuF1sHHMrpw0B3Xjm0gOLk8fE8vHRV0oo8P7B22Jih93oYeDnPM5iZ2SSp5bjJHGBPnkf4GHAgIl6QdBQ4IGk98BbwCEBEnJR0ADgFDAIb8pATwGPAbqANeDEfALuAvZL6KPYMusejOTMzq92ogRARvwDuq1L/JbDyJmO2AFuq1E8AHzn/EBEfkIFiZmbN4U8qm5kZ4EAwM7PkQDAzM8CBYGZmyYFgZmaAA8HMzJIDwczMAAeCmZklB4KZmQEOBDMzSw4EMzMDHAhmZpYcCGZmBjgQzMwsORDMzAxwIJiZWarlFprzJP1E0mlJJyU9kfVvSHpb0mv5eLBizGZJfZLOSFpVUb9fUm/OezpvpUnebvP5rB+TNH8CejUzsxHUsocwCGyMiM8AK4ANkhblvG0RsSwfPwbIed3AYqAL2J633wTYAfRQ3Gd5Yc4HWA9cjoh7gW3AU423ZmZmYzFqIETExYj4eU5fBU4Dc0cYshrYHxHXIuIs0AcslzQHmB0RRyMigOeANRVj9uT0QWDl0N6DmZlNjlHvqVwpD+XcBxwDHgAel7QWOEGxF3GZIixeqRjWn7UPc3p4nXw+DxARg5KuAHcB7w5bfw/FHgalUolyuTyWzf+tUhtsXDpY19hG1bvNjRoYGGjaupvFPbcG9zx+ag4ESZ8Evg98PSJ+LWkH8C0g8nkr8FWg2m/2MUKdUeb9/0LETmAnQEdHR3R2dta6+Td4Zt8htvaOKQvHzblHO5uy3nK5TL1fr6nKPbcG9zx+arrKSNJtFGGwLyJ+ABAR70TE9Yj4DfAdYHku3g/MqxjeDlzIenuV+g1jJM0Ebgfeq6chMzOrTy1XGQnYBZyOiG9X1OdULPYF4PWcPgx055VDCyhOHh+PiIvAVUkr8j3XAocqxqzL6YeBl/M8g5mZTZJajps8AHwZ6JX0Wtb+GPiipGUUh3bOAV8DiIiTkg4ApyiuUNoQEddz3GPAbqANeDEfUATOXkl9FHsG3Y00ZWZmYzdqIETEz6h+jP/HI4zZAmypUj8BLKlS/wB4ZLRtMTOzieNPKpuZGeBAMDOz5EAwMzPAgWBmZsmBYGZmgAPBzMySA8HMzAAHgpmZJQeCmZkBDgQzM0sOBDMzAxwIZmaWmnOXmBY2f9OPmrLe3V2zmrJeM5s6vIdgZmaAA8HMzJIDwczMgNpuoTlP0k8knZZ0UtITWb9T0kuS3sznOyrGbJbUJ+mMpFUV9fsl9ea8p/NWmuTtNp/P+jFJ8yegVzMzG0EtewiDwMaI+AywAtggaRGwCTgSEQuBI/manNcNLAa6gO2SZuR77QB6KO6zvDDnA6wHLkfEvcA24Klx6M3MzMZg1ECIiIsR8fOcvgqcBuYCq4E9udgeYE1Orwb2R8S1iDgL9AHLJc0BZkfE0YgI4LlhY4be6yCwcmjvwczMJseYLjvNQzn3AceAUkRchCI0JN2Ti80FXqkY1p+1D3N6eH1ozPl8r0FJV4C7gHeHrb+HYg+DUqlEuVwey+b/VqkNNi4drGvsVDUwMFD312uqcs+twT2Pn5oDQdInge8DX4+IX4/wC3y1GTFCfaQxNxYidgI7ATo6OqKzs3OUra7umX2H2NrbWh/B2N01i3q/XlNVuVx2zy3APY+fmq4yknQbRRjsi4gfZPmdPAxEPl/Kej8wr2J4O3Ah6+1V6jeMkTQTuB14b6zNmJlZ/Wq5ykjALuB0RHy7YtZhYF1OrwMOVdS788qhBRQnj4/n4aWrklbke64dNmbovR4GXs7zDGZmNklqOW7yAPBloFfSa1n7Y+BJ4ICk9cBbwCMAEXFS0gHgFMUVShsi4nqOewzYDbQBL+YDisDZK6mPYs+gu7G2zMxsrEYNhIj4GdWP8QOsvMmYLcCWKvUTwJIq9Q/IQDEzs+bwJ5XNzAxwIJiZWXIgmJkZ4EAwM7PkQDAzM8CBYGZmyYFgZmaAA8HMzJIDwczMAAeCmZklB4KZmQEOBDMzSw4EMzMDHAhmZpYcCGZmBjgQzMws1XILzWclXZL0ekXtG5LelvRaPh6smLdZUp+kM5JWVdTvl9Sb857O22iSt9p8PuvHJM0f5x7NzKwGtewh7Aa6qtS3RcSyfPwYQNIiittfLs4x2yXNyOV3AD0U91heWPGe64HLEXEvsA14qs5ezMysAaMGQkT8lOI+x7VYDeyPiGsRcRboA5ZLmgPMjoijERHAc8CaijF7cvogsHJo78HMzCbPqPdUHsHjktYCJ4CNEXEZmAu8UrFMf9Y+zOnhdfL5PEBEDEq6AtwFvDt8hZJ6KPYyKJVKlMvluja81AYblw7WNXaqGhgYqPvrNVW559bgnsdPvYGwA/gWEPm8FfgqUO03+xihzijzbixG7AR2AnR0dERnZ+eYNnrIM/sOsbW3kSycenZ3zaLer9dUVS6X3XMLcM/jp66rjCLinYi4HhG/Ab4DLM9Z/cC8ikXbgQtZb69Sv2GMpJnA7dR+iMrMzMZJXYGQ5wSGfAEYugLpMNCdVw4toDh5fDwiLgJXJa3I8wNrgUMVY9bl9MPAy3mewczMJtGox00kfQ/oBO6W1A/8KdApaRnFoZ1zwNcAIuKkpAPAKWAQ2BAR1/OtHqO4YqkNeDEfALuAvZL6KPYMusehLzMzG6NRAyEivlilvGuE5bcAW6rUTwBLqtQ/AB4ZbTvMzGxi+ZPKZmYGOBDMzCw5EMzMDHAgmJlZciCYmRngQDAzs+RAMDMzwIFgZmbJgWBmZoADwczMkgPBzMwAB4KZmSUHgpmZAQ4EMzNLDgQzMwPqv6eyTTG9b1/hK5t+1JR1n3vyoaas18zGZtQ9BEnPSrok6fWK2p2SXpL0Zj7fUTFvs6Q+SWckraqo3y+pN+c9nbfSJG+3+XzWj0maP849mplZDWo5ZLQb6BpW2wQciYiFwJF8jaRFFLfAXJxjtkuakWN2AD0U91leWPGe64HLEXEvsA14qt5mzMysfqMGQkT8lOJex5VWA3tyeg+wpqK+PyKuRcRZoA9YLmkOMDsijkZEAM8NGzP0XgeBlUN7D2ZmNnnqPYdQioiLABFxUdI9WZ8LvFKxXH/WPszp4fWhMefzvQYlXQHuAt4dvlJJPRR7GZRKJcrlcn0b3wYblw7WNXaqambP9f47NWpgYKBp624W99waJqrn8T6pXO03+xihPtKYjxYjdgI7ATo6OqKzs7OOTYRn9h1ia29rnU/fuHSwaT2fe7SzKestl8vU+z0yVbnn1jBRPdd72ek7eRiIfL6U9X5gXsVy7cCFrLdXqd8wRtJM4HY+eojKzMwmWL2BcBhYl9PrgEMV9e68cmgBxcnj43l46aqkFXl+YO2wMUPv9TDwcp5nMDOzSTTqMQRJ3wM6gbsl9QN/CjwJHJC0HngLeAQgIk5KOgCcAgaBDRFxPd/qMYorltqAF/MBsAvYK6mPYs+ge1w6MzOzMRk1ECLiizeZtfImy28BtlSpnwCWVKl/QAaKmZk1j/90hZmZAQ4EMzNLDgQzMwMcCGZmlhwIZmYGOBDMzCw5EMzMDHAgmJlZciCYmRngQDAzs+RAMDMzYPzvh2D2EfM3/agp693dNasp6zWbqryHYGZmgAPBzMySA8HMzAAHgpmZpYYCQdI5Sb2SXpN0Imt3SnpJ0pv5fEfF8psl9Uk6I2lVRf3+fJ8+SU/nbTbNzGwSjccewn+MiGUR0ZGvNwFHImIhcCRfI2kRxe0xFwNdwHZJM3LMDqCH4h7MC3O+mZlNook4ZLQa2JPTe4A1FfX9EXEtIs4CfcBySXOA2RFxNCICeK5ijJmZTZJGAyGAv5H0qqSerJUi4iJAPt+T9bnA+Yqx/Vmbm9PD62ZmNoka/WDaAxFxQdI9wEuS3hhh2WrnBWKE+kffoAidHoBSqUS5XB7j5hZKbbBx6WBdY6eqVux5YGCg7u+Rqco9t4aJ6rmhQIiIC/l8SdIPgeXAO5LmRMTFPBx0KRfvB+ZVDG8HLmS9vUq92vp2AjsBOjo6orOzs67tfmbfIbb2ttaHtDcuHWzNnn/2/qSv99yTD036OoeUy2Xq/X8xVbnn8VP3ISNJsyT97tA08J+A14HDwLpcbB1wKKcPA92SPi5pAcXJ4+N5WOmqpBV5ddHaijFmZjZJGvmVsQT8MK8QnQn8VUT8taS/BQ5IWg+8BTwCEBEnJR0ATgGDwIaIuJ7v9RiwG2gDXsyHmZlNoroDISL+AfhslfovgZU3GbMF2FKlfgJYUu+2mJlZ4/xJZTMzAxwIZmaWWuuyE7NJ0Kz7P4DvAWGN8R6CmZkBDgQzM0sOBDMzA3wOwWxa6X37Cl9pwjmMZn4628aP9xDMzAxwIJiZWfIhIzNrmC+1nR68h2BmZoD3EMxsivOJ9PHjQDAzq8N0PEzmQ0ZmZgY4EMzMLDkQzMwMcCCYmVm6ZQJBUpekM5L6JG1q9vaYmbWaWyIQJM0A/gL4fWAR8EVJi5q7VWZmreWWCARgOdAXEf8QEf8E7AdWN3mbzMxaiiKi2duApIeBroj4z/n6y8C/iYjHhy3XA/Tky98DztS5yruBd+scO1W559bgnltDIz3/i4j4dLUZt8oH01Sl9pGkioidwM6GVyadiIiORt9nKnHPrcE9t4aJ6vlWOWTUD8yreN0OXGjStpiZtaRbJRD+FlgoaYGkfwZ0A4ebvE1mZi3lljhkFBGDkh4H/icwA3g2Ik5O4CobPuw0Bbnn1uCeW8OE9HxLnFQ2M7Pmu1UOGZmZWZM5EMzMDGjBQGiFP5EhaZ6kn0g6LemkpCeyfqeklyS9mc93NHtbx5OkGZL+TtIL+Xq69/spSQclvZH/1v+2BXr+r/k9/bqk70n6xHTrWdKzki5Jer2idtMeJW3On2dnJK1qZN0tFQgt9CcyBoGNEfEZYAWwIfvcBByJiIXAkXw9nTwBnK54Pd37/W/AX0fEvwI+S9H7tO1Z0lzgvwAdEbGE4gKUbqZfz7uBrmG1qj3m/+tuYHGO2Z4/5+rSUoFAi/yJjIi4GBE/z+mrFD8o5lL0uicX2wOsacoGTgBJ7cBDwHcrytO539nAfwB2AUTEP0XEr5jGPaeZQJukmcDvUHxeaVr1HBE/Bd4bVr5Zj6uB/RFxLSLOAn0UP+fq0mqBMBc4X/G6P2vTlqT5wH3AMaAUERehCA3gniZu2nj7c+CPgN9U1KZzv/8S+Efgv+dhsu9KmsU07jki3gb+DHgLuAhciYi/YRr3XOFmPY7rz7RWC4Sa/kTGdCHpk8D3ga9HxK+bvT0TRdIfAJci4tVmb8skmgn8a2BHRNwHvM/UP1QyojxuvhpYAPxzYJakLzV3q5puXH+mtVogtMyfyJB0G0UY7IuIH2T5HUlzcv4c4FKztm+cPQD8oaRzFIcBPyfpL5m+/ULxvdwfEcfy9UGKgJjOPX8eOBsR/xgRHwI/AP4d07vnITfrcVx/prVaILTEn8iQJIpjy6cj4tsVsw4D63J6HXBosrdtIkTE5ohoj4j5FP+mL0fEl5im/QJExP8Fzkv6vSytBE4xjXumOFS0QtLv5Pf4SorzY9O55yE36/Ew0C3p45IWAAuB43WvJSJa6gE8CPwv4H8Df9Ls7ZmgHv89xW7jL4DX8vEgcBfFFQpv5vOdzd7WCei9E3ghp6d1v8Ay4ET+O/8P4I4W6PmbwBvA68Be4OPTrWfgexTnSD6k2ANYP1KPwJ/kz7MzwO83sm7/6QozMwNa75CRmZndhAPBzMwAB4KZmSUHgpmZAQ4EMzNLDgQzMwMcCGZmlv4fL8G11qOHhK8AAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "rchist=bizdfsmall['review_count'].hist(bins=10,range=(0,100))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX0AAAD4CAYAAAAAczaOAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAAATxklEQVR4nO3dbYxc53ne8f8V0pYZxYSlylqwpFAqKOFGEuEXLVS6LoJtFFRMFIT6UAEM5IgqFBAQlMBpCQRU+6HIBwJq0QSx0EgAYTuiGscC4dgRYUFpBCaLIIBeQiVOKOqlYixWZsWIjgM3oj/Ionr3wzwuZ1dL7uzbrLTP/wcM5px7zjNzzk3y2rPPnBmmqpAk9eFHVnsHJEnjY+hLUkcMfUnqiKEvSR0x9CWpI+tXewfmc9VVV9XWrVtXezeW5Pvf/z6XX375au/Ge4K9mMl+zGQ/LlhqL5577rm/q6qPzq6/50N/69atHDt2bLV3Y0mmp6eZmppa7d14T7AXM9mPmezHBUvtRZL/NVfd6R1J6oihL0kdMfQlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSRwx9SerIe/4TuUuxdf/jq/K6p+6/dVVeV5Lm45m+JHXE0Jekjhj6ktQRQ1+SOmLoS1JHDH1J6oihL0kdGSn0k3wkyVeTvJTkxSSfTnJlkieTvNLurxja/r4kJ5O8nOSWofqNSY63xx5IkpU4KEnS3EY90/888IdV9c+AjwMvAvuBo1W1DTja1klyHbAbuB7YCTyYZF17noeAvcC2dtu5TMchSRrBvKGfZCPwk8AXAarqB1X1PWAXcKhtdgi4rS3vAh6tqreq6lXgJHBTkk3Axqp6qqoKeGRojCRpDEb5GoYfB74D/E6SjwPPAZ8DJqrqDEBVnUlyddt+M/D00PjTrfZ2W55df5ckexn8RsDExATT09OjHs8M+7afX9S4pZq9v+fOnVv0Maw19mIm+zGT/bhgpXoxSuivBz4F/EpVPZPk87SpnIuYa56+LlF/d7HqIHAQYHJyshb7P8LftVrfvXPH1Iz1pf6v9muJvZjJfsxkPy5YqV6MMqd/GjhdVc+09a8y+CHwRpuyod2fHdr+mqHxW4DXW33LHHVJ0pjMG/pV9bfAt5N8rJVuBl4AjgB7Wm0P8FhbPgLsTnJZkmsZvGH7bJsKejPJjnbVzp1DYyRJYzDqVyv/CvDlJB8EvgX8WwY/MA4nuRt4DbgdoKpOJDnM4AfDeeDeqnqnPc89wMPABuCJdpMkjclIoV9V3wQm53jo5otsfwA4MEf9GHDDAvZPkrSM/ESuJHXE0Jekjhj6ktQRQ1+SOmLoS1JHDH1J6oihL0kdMfQlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOGPqS1BFDX5I6YuhLUkcMfUnqiKEvSR0ZKfSTnEpyPMk3kxxrtSuTPJnklXZ/xdD29yU5meTlJLcM1W9sz3MyyQNJsvyHJEm6mIWc6f+rqvpEVU229f3A0araBhxt6yS5DtgNXA/sBB5Msq6NeQjYC2xrt51LPwRJ0qiWMr2zCzjUlg8Btw3VH62qt6rqVeAkcFOSTcDGqnqqqgp4ZGiMJGkMRg39Av4oyXNJ9rbaRFWdAWj3V7f6ZuDbQ2NPt9rmtjy7Lkkak/UjbveZqno9ydXAk0leusS2c83T1yXq736CwQ+WvQATExNMT0+PuJsz7dt+flHjlmr2/p47d27Rx7DW2IuZ7MdM9uOClerFSKFfVa+3+7NJvg7cBLyRZFNVnWlTN2fb5qeBa4aGbwFeb/Utc9Tner2DwEGAycnJmpqaGvmAht21//FFjVuqU3dMzVifnp5mscew1tiLmezHTPbjgpXqxbzTO0kuT/LhHy4D/xp4HjgC7Gmb7QEea8tHgN1JLktyLYM3bJ9tU0BvJtnRrtq5c2iMJGkMRjnTnwC+3q6uXA/8XlX9YZI/Bw4nuRt4DbgdoKpOJDkMvACcB+6tqnfac90DPAxsAJ5oN0nSmMwb+lX1LeDjc9S/C9x8kTEHgANz1I8BNyx8NyVJy8FP5EpSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOGPqS1BFDX5I6YuhLUkcMfUnqiKEvSR0x9CWpI4a+JHXE0Jekjhj6ktQRQ1+SOmLoS1JHDH1J6oihL0kdMfQlqSOGviR1xNCXpI4Y+pLUEUNfkjoycugnWZfkL5N8o61fmeTJJK+0+yuGtr0vyckkLye5Zah+Y5Lj7bEHkmR5D0eSdCkLOdP/HPDi0Pp+4GhVbQOOtnWSXAfsBq4HdgIPJlnXxjwE7AW2tdvOJe29JGlBRgr9JFuAW4EvDJV3AYfa8iHgtqH6o1X1VlW9CpwEbkqyCdhYVU9VVQGPDI2RJI3B+hG3+y3g14APD9UmquoMQFWdSXJ1q28Gnh7a7nSrvd2WZ9ffJcleBr8RMDExwfT09Ii7OdO+7ecXNW6pZu/vuXPnFn0Ma429mMl+zGQ/LlipXswb+kl+DjhbVc8lmRrhOeeap69L1N9drDoIHASYnJysqalRXvbd7tr/+KLGLdWpO6ZmrE9PT7PYY1hr7MVM9mMm+3HBSvVilDP9zwA/n+RngQ8BG5P8LvBGkk3tLH8TcLZtfxq4Zmj8FuD1Vt8yR12SNCbzzulX1X1VtaWqtjJ4g/aPq+qzwBFgT9tsD/BYWz4C7E5yWZJrGbxh+2ybCnozyY521c6dQ2MkSWMw6pz+XO4HDie5G3gNuB2gqk4kOQy8AJwH7q2qd9qYe4CHgQ3AE+0mSRqTBYV+VU0D0235u8DNF9nuAHBgjvox4IaF7qQkaXn4iVxJ6oihL0kdMfQlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOGPqS1BFDX5I6YuhLUkcMfUnqiKEvSR0x9CWpI4a+JHXE0Jekjhj6ktQRQ1+SOmLoS1JH5g39JB9K8mySv0pyIsmvt/qVSZ5M8kq7v2JozH1JTiZ5OcktQ/Ubkxxvjz2QJCtzWJKkuYxypv8W8FNV9XHgE8DOJDuA/cDRqtoGHG3rJLkO2A1cD+wEHkyyrj3XQ8BeYFu77Vy+Q5EkzWfe0K+Bc231A+1WwC7gUKsfAm5ry7uAR6vqrap6FTgJ3JRkE7Cxqp6qqgIeGRojSRqD9aNs1M7UnwP+KfDbVfVMkomqOgNQVWeSXN023ww8PTT8dKu93ZZn1+d6vb0MfiNgYmKC6enpkQ9o2L7t5xc1bqlm7++5c+cWfQxrjb2YyX7MZD8uWKlejBT6VfUO8IkkHwG+nuSGS2w+1zx9XaI+1+sdBA4CTE5O1tTU1Ci7+S537X98UeOW6tQdUzPWp6enWewxrDX2Yib7MZP9uGClerGgq3eq6nvANIO5+DfalA3t/mzb7DRwzdCwLcDrrb5ljrokaUxGuXrno+0MnyQbgJ8GXgKOAHvaZnuAx9ryEWB3ksuSXMvgDdtn21TQm0l2tKt27hwaI0kag1GmdzYBh9q8/o8Ah6vqG0meAg4nuRt4DbgdoKpOJDkMvACcB+5t00MA9wAPAxuAJ9pNkjQm84Z+Vf018Mk56t8Fbr7ImAPAgTnqx4BLvR8gSVpBfiJXkjpi6EtSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOGPqS1BFDX5I6YuhLUkcMfUnqiKEvSR0x9CWpI4a+JHXE0Jekjhj6ktQRQ1+SOmLoS1JHDH1J6sgo/zG6Fmjr/sdnrO/bfp67ZtVWyqn7bx3L60h6f/JMX5I6YuhLUkcMfUnqyLyhn+SaJH+S5MUkJ5J8rtWvTPJkklfa/RVDY+5LcjLJy0luGarfmOR4e+yBJFmZw5IkzWWUM/3zwL6q+glgB3BvkuuA/cDRqtoGHG3rtMd2A9cDO4EHk6xrz/UQsBfY1m47l/FYJEnzmDf0q+pMVf1FW34TeBHYDOwCDrXNDgG3teVdwKNV9VZVvQqcBG5KsgnYWFVPVVUBjwyNkSSNwYIu2UyyFfgk8AwwUVVnYPCDIcnVbbPNwNNDw0632ttteXZ9rtfZy+A3AiYmJpienl7Ibv5/+7afX9S45TaxYXz7sthejcu5c+fe8/s4TvZjJvtxwUr1YuTQT/JjwO8Dv1pV/3CJ6fi5HqhL1N9drDoIHASYnJysqampUXdzhnFdGz+ffdvP8xvHx/ORiFN3TI3ldRZrenqaxf55rkX2Yyb7ccFK9WKkq3eSfIBB4H+5qr7Wym+0KRva/dlWPw1cMzR8C/B6q2+Zoy5JGpNRrt4J8EXgxar6zaGHjgB72vIe4LGh+u4klyW5lsEbts+2qaA3k+xoz3nn0BhJ0hiMMufwGeAXgeNJvtlq/wG4Hzic5G7gNeB2gKo6keQw8AKDK3/urap32rh7gIeBDcAT7SZJGpN5Q7+q/oy55+MBbr7ImAPAgTnqx4AbFrKDkqTl4ydyJakjhr4kdcTQl6SOGPqS1BFDX5I6YuhLUkcMfUnqiKEvSR0x9CWpI4a+JHXE0Jekjhj6ktQRQ1+SOmLoS1JHDH1J6oihL0kdMfQlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSR9av9g5oeW3d//iqvO6p+29dldeVtDCe6UtSR+YN/SRfSnI2yfNDtSuTPJnklXZ/xdBj9yU5meTlJLcM1W9Mcrw99kCSLP/hSJIuZZQz/YeBnbNq+4GjVbUNONrWSXIdsBu4vo15MMm6NuYhYC+wrd1mP6ckaYXNG/pV9afA388q7wIOteVDwG1D9Uer6q2qehU4CdyUZBOwsaqeqqoCHhkaI0kak8W+kTtRVWcAqupMkqtbfTPw9NB2p1vt7bY8uz6nJHsZ/FbAxMQE09PTi9rJfdvPL2rccpvY8N7Zl5Uy6p/RuXPnFv3nuRbZj5nsxwUr1Yvlvnpnrnn6ukR9TlV1EDgIMDk5WVNTU4vambtW6UqW2fZtP89vHF/bF0qdumNqpO2mp6dZ7J/nWmQ/ZrIfF6xULxZ79c4bbcqGdn+21U8D1wxttwV4vdW3zFGXJI3RYkP/CLCnLe8BHhuq705yWZJrGbxh+2ybCnozyY521c6dQ2MkSWMy75xDkq8AU8BVSU4D/wm4Hzic5G7gNeB2gKo6keQw8AJwHri3qt5pT3UPgyuBNgBPtJskaYzmDf2q+oWLPHTzRbY/AByYo34MuGFBeydJWlZ+IleSOmLoS1JHDH1J6oihL0kdMfQlqSNr+2OiGptRv8d/3/bzy/5Jab/LXxqdZ/qS1BFDX5I6YuhLUkcMfUnqiKEvSR0x9CWpI4a+JHXE6/T1vjfqZwSWm58P0PuRZ/qS1BFDX5I6YuhLUkcMfUnqiKEvSR3x6h1pkZbjqqHFfuuoVw5psTzTl6SOeKYvvQ/52QQtlmf6ktQRQ1+SOjL26Z0kO4HPA+uAL1TV/ePeB0mLs9LTSivx32m+Xz288/IVed6xnuknWQf8NvAzwHXALyS5bpz7IEk9G/f0zk3Ayar6VlX9AHgU2DXmfZCkbqWqxvdiyb8BdlbVL7X1XwT+eVX98qzt9gJ72+rHgJfHtpMr4yrg71Z7J94j7MVM9mMm+3HBUnvxT6rqo7OL457Tzxy1d/3UqaqDwMGV353xSHKsqiZXez/eC+zFTPZjJvtxwUr1YtzTO6eBa4bWtwCvj3kfJKlb4w79Pwe2Jbk2yQeB3cCRMe+DJHVrrNM7VXU+yS8D/4PBJZtfqqoT49yHVbJmpqqWgb2YyX7MZD8uWJFejPWNXEnS6vITuZLUEUNfkjpi6C9RkmuS/EmSF5OcSPK5Vr8yyZNJXmn3VwyNuS/JySQvJ7ll9fZ+ZSRZl+Qvk3yjrffci48k+WqSl9rfkU933o9/1/6dPJ/kK0k+1FM/knwpydkkzw/VFnz8SW5Mcrw99kCSuS6Hn1tVeVvCDdgEfKotfxj4nwy+YuK/APtbfT/wn9vydcBfAZcB1wJ/A6xb7eNY5p78e+D3gG+09Z57cQj4pbb8QeAjvfYD2Ay8Cmxo64eBu3rqB/CTwKeA54dqCz5+4Fng0ww++/QE8DOj7oNn+ktUVWeq6i/a8pvAiwz+cu9i8A+edn9bW94FPFpVb1XVq8BJBl9PsSYk2QLcCnxhqNxrLzYy+Ef+RYCq+kFVfY9O+9GsBzYkWQ/8KIPP6XTTj6r6U+DvZ5UXdPxJNgEbq+qpGvwEeGRozLwM/WWUZCvwSeAZYKKqzsDgBwNwddtsM/DtoWGnW22t+C3g14D/O1TrtRc/DnwH+J023fWFJJfTaT+q6n8D/xV4DTgD/J+q+iM67ceQhR7/5rY8uz4SQ3+ZJPkx4PeBX62qf7jUpnPU1sR1s0l+DjhbVc+NOmSO2proRbOewa/yD1XVJ4HvM/j1/WLWdD/aXPUuBlMV/xi4PMlnLzVkjtqa6ccILnb8S+qLob8MknyAQeB/uaq+1spvtF/DaPdnW30tfxXFZ4CfT3KKwTeo/lSS36XPXsDg+E5X1TNt/asMfgj02o+fBl6tqu9U1dvA14B/Qb/9+KGFHv/ptjy7PhJDf4nau+ZfBF6sqt8ceugIsKct7wEeG6rvTnJZkmuBbQzelHnfq6r7qmpLVW1l8BUbf1xVn6XDXgBU1d8C307ysVa6GXiBTvvBYFpnR5Ifbf9ubmbwHliv/fihBR1/mwJ6M8mO1sc7h8bMb7XfzX6/34B/yeBXq78GvtluPwv8I+Ao8Eq7v3JozH9k8E78yyzgXff30w2Y4sLVO932AvgEcKz9/fgD4IrO+/HrwEvA88B/Z3BlSjf9AL7C4P2Mtxmcsd+9mOMHJlsP/wb4b7RvVxjl5tcwSFJHnN6RpI4Y+pLUEUNfkjpi6EtSRwx9SeqIoS9JHTH0Jakj/w83TMYHEcMNPAAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "rchist=bizdfsmall['review_count'].hist(bins=10,range=(100,1000))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Empty DataFrame\n",
      "Columns: [business_id, name, attributes.RestaurantsPriceRange2, review_count]\n",
      "Index: []\n"
     ]
    }
   ],
   "source": [
    "count0=bizdfsmall[bizdfsmall['review_count']==0]\n",
    "print(count0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "bizdfsmall.to_csv('bizdfsmall.csv',index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}