Create_dataframe_with_50_100reviews.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Create Yelp subset with users that wrote 50-100 reviews to reduce dataset size from 3.6B records"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import os\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "filename = 'yelp_review.csv'\n",
    "filepath = os.path.join('..','yelp_dataset',filename)\n",
    "reviews_data_df = pd.read_csv(filepath)\n",
    "filename = 'restaurants.csv'\n",
    "filepath = os.path.join(filename)\n",
    "restaurant_data_df = pd.read_csv(filepath)\n",
    "restaurant_data_df.rename(columns={'stars':'overall_stars'},inplace=True)\n",
    "business_and_review = restaurant_data_df.merge(reviews_data_df,on='business_id')\n",
    "\n",
    "review_df_with_count = business_and_review[\n",
    "    ['name','review_id','user_id','business_id','stars','text','date']\\\n",
    "    ].merge(business_and_review[['user_id','stars']]\\\n",
    "            .rename(columns={'stars':'review_count'})\\\n",
    "            .groupby('user_id')\\\n",
    "            .count(),left_on = 'user_id',right_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "# review_df_with_count[\n",
    "#         (review_df_with_count['review_count']>lower) & \\\n",
    "#         (review_df_with_count['review_count']<=upper)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "rating distribution of reviews from users with 0 to 1 reviews written\n",
      "518291 reviews in subset\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZsAAAEKCAYAAADEovgeAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvNQv5yAAAFDZJREFUeJzt3X+wX3Wd3/HnywArVVjCEikSppfZzdhFx4LeRVpmWn90IMB2w+6KgzNKaulk68AWp3a6cf/B6jrDTqt26SgzWCLBurIMaGFLXMwgrWMXgRuI/FyHOxglm5QEg4g61QHf/eP7yfol3Nx8E/K5h9w8HzPf+Z7v+3zOOe/zR+aVc76fe76pKiRJ6ulVQzcgSVr8DBtJUneGjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTujhi6gVeKE044oaampoZuQ5IOKZs2bXq6qpbta5xh00xNTTEzMzN0G5J0SEnyvUnGeRtNktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktSdTxCQpDFTa28fuoUutlx1waDH98pGktRdt7BJckqSu5I8luSRJFe0+keT/G2Sze11/tg2H0kym+Q7Sc4dq69stdkka8fqpya5J8njSf4iyVGt/ivt82xbP9XrPCVJ+9bzyuZ54MNV9ZvAWcBlSU5r6z5dVae31waAtu5i4I3ASuCzSZYkWQJ8BjgPOA1479h+/rTtawXwDHBpq18KPFNVvwF8uo2TJA2kW9hU1faqur8tPwc8Bpw8zyargBur6mdV9V1gFjizvWar6omq+jlwI7AqSYB3Aje37dcDF47ta31bvhl4VxsvSRrAgnxn025jnQHc00qXJ3kwybokS1vtZODJsc22ttre6r8G/LCqnt+j/qJ9tfXPtvF79rUmyUySmZ07d76sc5Qk7V33sEnyWuAW4ENV9SPgGuDXgdOB7cAndw+dY/M6gPp8+3pxoeraqpquqully/b52z+SpAPUNWySHMkoaL5YVV8GqKqnquqFqvoF8DlGt8lgdGVyytjmy4Ft89SfBo5LcsQe9Rftq63/VWDXwT07SdKkes5GC3Ad8FhVfWqsftLYsN8FHm7LtwEXt5lkpwIrgHuB+4AVbebZUYwmEdxWVQXcBby7bb8auHVsX6vb8ruBr7fxkqQB9PyjzrOB9wMPJdncan/MaDbZ6Yxua20B/gCgqh5JchPwKKOZbJdV1QsASS4H7gCWAOuq6pG2vz8CbkzyJ8ADjMKN9v6FJLOMrmgu7niekqR96BY2VfVN5v7uZMM823wC+MQc9Q1zbVdVT/DL23Dj9f8HXLQ//UqS+vEJApKk7gwbSVJ3ho0kqTvDRpLUnWEjSerOsJEkdWfYSJK6M2wkSd0ZNpKk7gwbSVJ3ho0kqTvDRpLUnWEjSerOsJEkdWfYSJK6M2wkSd0ZNpKk7gwbSVJ3ho0kqTvDRpLUnWEjSerOsJEkdWfYSJK6M2wkSd0ZNpKk7gwbSVJ3ho0kqTvDRpLUnWEjSerOsJEkdWfYSJK66xY2SU5JcleSx5I8kuSKVj8+ycYkj7f3pa2eJFcnmU3yYJK3jO1rdRv/eJLVY/W3JnmobXN1ksx3DEnSMHpe2TwPfLiqfhM4C7gsyWnAWuDOqloB3Nk+A5wHrGivNcA1MAoO4ErgbcCZwJVj4XFNG7t7u5WtvrdjSJIG0C1sqmp7Vd3flp8DHgNOBlYB69uw9cCFbXkVcEONfAs4LslJwLnAxqraVVXPABuBlW3dsVV1d1UVcMMe+5rrGJKkASzIdzZJpoAzgHuAE6tqO4wCCXhdG3Yy8OTYZltbbb761jnqzHMMSdIAuodNktcCtwAfqqofzTd0jlodQH1/eluTZCbJzM6dO/dnU0nSfugaNkmOZBQ0X6yqL7fyU+0WGO19R6tvBU4Z23w5sG0f9eVz1Oc7xotU1bVVNV1V08uWLTuwk5Qk7VPP2WgBrgMeq6pPja26Ddg9o2w1cOtY/ZI2K+0s4Nl2C+wO4JwkS9vEgHOAO9q655Kc1Y51yR77musYkqQBHNFx32cD7wceSrK51f4YuAq4KcmlwPeBi9q6DcD5wCzwU+ADAFW1K8nHgfvauI9V1a62/EHgeuBo4KvtxTzHkCQNoFvYVNU3mft7FYB3zTG+gMv2sq91wLo56jPAm+ao/2CuY0iShuETBCRJ3Rk2kqTuDBtJUneGjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktSdYSNJ6s6wkSR11y1skqxLsiPJw2O1jyb52ySb2+v8sXUfSTKb5DtJzh2rr2y12SRrx+qnJrknyeNJ/iLJUa3+K+3zbFs/1escJUmT6Xllcz2wco76p6vq9PbaAJDkNOBi4I1tm88mWZJkCfAZ4DzgNOC9bSzAn7Z9rQCeAS5t9UuBZ6rqN4BPt3GSpAF1C5uq+gawa8Lhq4Abq+pnVfVdYBY4s71mq+qJqvo5cCOwKkmAdwI3t+3XAxeO7Wt9W74ZeFcbL0kayBDf2Vye5MF2m21pq50MPDk2Zmur7a3+a8APq+r5Peov2ldb/2wbL0kayERhk+TOSWoTuAb4deB0YDvwyd27m2NsHUB9vn29RJI1SWaSzOzcuXO+viVJL8O8YZPk1UmOB05IsjTJ8e01Bbx+fw9WVU9V1QtV9Qvgc4xuk8HoyuSUsaHLgW3z1J8GjktyxB71F+2rrf9V9nI7r6qurarpqppetmzZ/p6OJGlC+7qy+QNgE/AP2/vu162MvrjfL0lOGvv4u8DumWq3ARe3mWSnAiuAe4H7gBVt5tlRjCYR3FZVBdwFvLttv7r1tHtfq9vyu4Gvt/GSpIEcMd/Kqvoz4M+S/GFV/df92XGSLwFvZ3RVtBW4Enh7ktMZ3dbawijMqKpHktwEPAo8D1xWVS+0/VwO3AEsAdZV1SPtEH8E3JjkT4AHgOta/TrgC0lmGV3RXLw/fUuSDr5M+p/+JP8EmGIsoKrqhj5tLbzp6emamZkZug1JA5tae/vQLXSx5aoLuuw3yaaqmt7XuHmvbMZ29gVGX+xvBl5o5QIWTdhIkvqZKGyAaeA0v/uQJB2ISf/O5mHg7/dsRJK0eE16ZXMC8GiSe4Gf7S5W1e906UqStKhMGjYf7dmEJGlxmyhsqup/925EkrR4TTob7Tl++ciXo4AjgZ9U1bG9GpMkLR6TXtkcM/45yYX88lEzkiTN64Ce+lxV/4PRI/4lSdqnSW+j/d7Yx1cx+rsb/+ZGkjSRSWej/Yux5ecZPdds1UHvRpK0KE36nc0HejciSVq8Jv3xtOVJvpJkR5KnktySZHnv5iRJi8OkEwQ+z+h3Yl7P6GeX/7LVJEnap0nDZllVfb6qnm+v6wF/2lKSNJFJw+bpJO9LsqS93gf8oGdjkqTFY9Kw+VfAe4D/C2xn9HPLThqQJE1k0qnPHwdWV9UzAEmOB/4zoxCSJGlek17ZvHl30ABU1S7gjD4tSZIWm0nD5lVJlu7+0K5sJr0qkiQd5iYNjE8Cf53kZkaPqXkP8IluXUmSFpVJnyBwQ5IZRg/fDPB7VfVo184kSYvGxLfCWrgYMJKk/XZAPzEgSdL+MGwkSd0ZNpKk7gwbSVJ3ho0kqTvDRpLUnU8BOAim1t4+dAvdbLnqgqFbkLQIeGUjSerOsJEkddctbJKsS7IjycNjteOTbEzyeHtf2upJcnWS2SQPJnnL2Dar2/jHk6weq781yUNtm6uTZL5jSJKG0/PK5npg5R61tcCdVbUCuLN9BjgPWNFea4Br4O+eLn0l8DbgTODKsfC4po3dvd3KfRxDkjSQbmFTVd8Adu1RXgWsb8vrgQvH6jfUyLeA45KcBJwLbKyqXe33dDYCK9u6Y6vq7qoq4IY99jXXMSRJA1no72xOrKrtAO39da1+MvDk2LitrTZffesc9fmO8RJJ1iSZSTKzc+fOAz4pSdL8XikTBDJHrQ6gvl+q6tqqmq6q6WXLlu3v5pKkCS102DzVboHR3ne0+lbglLFxy4Ft+6gvn6M+3zEkSQNZ6LC5Ddg9o2w1cOtY/ZI2K+0s4Nl2C+wO4JwkS9vEgHOAO9q655Kc1WahXbLHvuY6hiRpIN2eIJDkS8DbgROSbGU0q+wq4KYklwLfBy5qwzcA5wOzwE+BDwBU1a4kHwfua+M+VlW7Jx18kNGMt6OBr7YX8xxDkjSQbmFTVe/dy6p3zTG2gMv2sp91wLo56jPAm+ao/2CuY0iShvNKmSAgSVrEDBtJUneGjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktSdYSNJ6q7bU58lHfqm1t4+dAvdbLnqgqFbOKx4ZSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktSdYSNJ6m6QsEmyJclDSTYnmWm145NsTPJ4e1/a6klydZLZJA8mecvYfla38Y8nWT1Wf2vb/2zbNgt/lpKk3Ya8snlHVZ1eVdPt81rgzqpaAdzZPgOcB6xorzXANTAKJ+BK4G3AmcCVuwOqjVkztt3K/qcjSdqbV9JttFXA+ra8HrhwrH5DjXwLOC7JScC5wMaq2lVVzwAbgZVt3bFVdXdVFXDD2L4kSQMYKmwK+FqSTUnWtNqJVbUdoL2/rtVPBp4c23Zrq81X3zpH/SWSrEkyk2Rm586dL/OUJEl7c8RAxz27qrYleR2wMcnfzDN2ru9b6gDqLy1WXQtcCzA9PT3nGEnSyzfIlU1VbWvvO4CvMPrO5al2C4z2vqMN3wqcMrb5cmDbPurL56hLkgay4GGT5DVJjtm9DJwDPAzcBuyeUbYauLUt3wZc0malnQU8226z3QGck2RpmxhwDnBHW/dckrPaLLRLxvYlSRrAELfRTgS+0mYjHwH8eVX9VZL7gJuSXAp8H7iojd8AnA/MAj8FPgBQVbuSfBy4r437WFXtassfBK4Hjga+2l6SpIEseNhU1RPAP5qj/gPgXXPUC7hsL/taB6yboz4DvOllN6u9mlp7+9AtdLPlqguGbkFadF5JU58lSYuUYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktTdUE99lg45PjVBOnBe2UiSujNsJEndGTaSpO4MG0lSd4aNJKk7w0aS1J1hI0nqzrCRJHVn2EiSujNsJEndGTaSpO4MG0lSd4aNJKk7w0aS1J1hI0nqzrCRJHVn2EiSujNsJEndGTaSpO4MG0lSd4aNJKm7RRs2SVYm+U6S2SRrh+5Hkg5nizJskiwBPgOcB5wGvDfJacN2JUmHr0UZNsCZwGxVPVFVPwduBFYN3JMkHbYWa9icDDw59nlrq0mSBpCqGrqHgy7JRcC5VfWv2+f3A2dW1R/uMW4NsKZ9fAPwnQVt9OA4AXh66CYW0OF2vuA5Hy4O1XP+B1W1bF+DjliITgawFThl7PNyYNueg6rqWuDahWqqhyQzVTU9dB8L5XA7X/CcDxeL/ZwX6220+4AVSU5NchRwMXDbwD1J0mFrUV7ZVNXzSS4H7gCWAOuq6pGB25Kkw9aiDBuAqtoAbBi6jwVwSN8GPACH2/mC53y4WNTnvCgnCEiSXlkW63c2kqRXEMPmEJVkXZIdSR4eupeFkOSUJHcleSzJI0muGLqn3pK8Osm9Sb7dzvk/Dt3TQkmyJMkDSf7n0L0shCRbkjyUZHOSmaH76cHbaIeoJP8U+DFwQ1W9aeh+ektyEnBSVd2f5BhgE3BhVT06cGvdJAnwmqr6cZIjgW8CV1TVtwZurbsk/w6YBo6tqt8eup/ekmwBpqvqUPw7m4l4ZXOIqqpvALuG7mOhVNX2qrq/LT8HPMYifypEjfy4fTyyvRb9/w6TLAcuAP7b0L3o4DFsdMhJMgWcAdwzbCf9tdtJm4EdwMaqWvTnDPwX4D8Avxi6kQVUwNeSbGpPNll0DBsdUpK8FrgF+FBV/Wjofnqrqheq6nRGT8E4M8mivmWa5LeBHVW1aeheFtjZVfUWRk+qv6zdJl9UDBsdMtr3FrcAX6yqLw/dz0Kqqh8C/wtYOXArvZ0N/E77DuNG4J1J/vuwLfVXVdva+w7gK4yeXL+oGDY6JLQvy68DHquqTw3dz0JIsizJcW35aOCfA38zbFd9VdVHqmp5VU0xeszU16vqfQO31VWS17RJLyR5DXAOsOhmmRo2h6gkXwLuBt6QZGuSS4fuqbOzgfcz+p/u5vY6f+imOjsJuCvJg4ye97exqg6LqcCHmROBbyb5NnAvcHtV/dXAPR10Tn2WJHXnlY0kqTvDRpLUnWEjSerOsJEkdWfYSJK6M2ykV5gkH0ry98Y+b9j99zbSocqpz9IA2h+ppqpe8vyvw+EJwDr8eGUjLZAkU+33eD4L3A9cl2Rm/Ldqkvxb4PWM/pjzrlbbkuSEse0/17b5WnuyAEl+K8mDSe5O8p8Ol9850qHDsJEW1hsY/QbRGcCHq2oaeDPwz5K8uaquBrYB76iqd8yx/QrgM1X1RuCHwO+3+ueBf1NV/xh4oftZSPvJsJEW1vfGfvzsPUnuBx4A3gicNsH2362qzW15EzDVvs85pqr+utX//KB2LB0ERwzdgHSY+QlAklOBfw/8VlU9k+R64NUTbP+zseUXgKOBHOwmpYPNKxtpGMcyCp5nk5zI6HdMdnsOOGbSHVXVM8BzSc5qpYsPWpfSQeKVjTSAqvp2kgeAR4AngP8ztvpa4KtJtu/le5u5XAp8LslPGP3uzbMHs1/p5XLqs7QIJHltVf24La8FTqqqKwZuS/o7XtlIi8MFST7C6N/094B/OWw70ot5ZSNJ6s4JApKk7gwbSVJ3ho0kqTvDRpLUnWEjSerOsJEkdff/AcRG6kAlpDf0AAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x107918eb8>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "rating distribution of reviews from users with 1 to 30 reviews written\n",
      "2129629 reviews in subset\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZsAAAEKCAYAAADEovgeAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvNQv5yAAAEn5JREFUeJzt3XHMZXV95/H3R0YEUQRhdHEG+9B1Yjsad7FPkZbETaWBQVyHtNVgqk5dNuw2aHHpph32H7s1JpjdrZUGSUZBwbqlBHWdFhQJ4m6sCjwDKMLUMEGUWagMzoBos7qw3/3j/mb3Ot555oLP7zk+93m/kpvnnO/5nfP73j8mnznnnntuqgpJknp61tANSJJmn2EjSerOsJEkdWfYSJK6M2wkSd0ZNpKk7gwbSVJ3ho0kqTvDRpLU3ZqhG/h5cfzxx9fc3NzQbUjSirJjx45Hq2rtocYZNs3c3BwLCwtDtyFJK0qSb08zzstokqTuDBtJUneGjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTufIKAJI2Z23r90C108cAlZw86v2c2kqTuDBtJUneGjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktRd17BJ8u+S3JPkG0n+KskRSU5KcmuS+5L8dZLD29jntPVdbfvc2HEubvVvJjlzrL6p1XYl2TpWnziHJGkY3cImyTrgD4D5qnolcBhwLvB+4ANVtQHYB5zXdjkP2FdVLwM+0MaRZGPb7xXAJuBDSQ5LchhwGXAWsBF4SxvLInNIkgbQ+zLaGuDIJGuA5wIPA68DrmvbrwLOacub2zpt++lJ0urXVNWPqupbwC7glPbaVVX3V9WPgWuAzW2fg80hSRpAt7Cpqv8J/GfgO4xC5nFgB/BYVT3Zhu0G1rXldcCDbd8n2/jjxusH7HOw+nGLzPETkpyfZCHJwp49e575m5UkLarnZbRjGZ2VnAS8BDiK0SWvA9X+XQ6ybanqP12s2lZV81U1v3bt2klDJElLoOdltN8EvlVVe6rqfwOfAn4dOKZdVgNYDzzUlncDJwK07S8A9o7XD9jnYPVHF5lDkjSAnmHzHeDUJM9tn6OcDtwL3AL8ThuzBfhMW97e1mnbv1BV1erntrvVTgI2ALcBtwMb2p1nhzO6iWB72+dgc0iSBtDzM5tbGX1Ifwdwd5trG/DHwEVJdjH6fOWKtssVwHGtfhGwtR3nHuBaRkH1OeCCqnqqfSbzTuBGYCdwbRvLInNIkgaQ0YmA5ufna2FhYeg2JA1sbuv1Q7fQxQOXnN3luEl2VNX8ocb5BAFJUneGjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrrrGjZJjklyXZK/T7Izya8leWGSm5Lc1/4e28YmyaVJdiX5epJXjx1nSxt/X5ItY/VfSXJ32+fSJGn1iXNIkobR+8zmg8DnquqXgH8G7AS2AjdX1Qbg5rYOcBawob3OBy6HUXAA7wFeA5wCvGcsPC5vY/fvt6nVDzaHJGkA3cImydHAa4ErAKrqx1X1GLAZuKoNuwo4py1vBq6uka8CxyQ5ATgTuKmq9lbVPuAmYFPbdnRVfaWqCrj6gGNNmkOSNICeZza/COwBPprkziQfSXIU8OKqehig/X1RG78OeHBs/92ttlh994Q6i8whSRpAz7BZA7wauLyqTgZ+yOKXszKhVs+gPrUk5ydZSLKwZ8+ep7OrJOlp6Bk2u4HdVXVrW7+OUfh8t10Co/19ZGz8iWP7rwceOkR9/YQ6i8zxE6pqW1XNV9X82rVrn9GblCQdWrewqap/AB5M8vJWOh24F9gO7L+jbAvwmba8HXh7uyvtVODxdgnsRuCMJMe2GwPOAG5s255Icmq7C+3tBxxr0hySpAGs6Xz8dwGfSHI4cD/wDkYBd22S84DvAG9qY28AXg/sAv6xjaWq9iZ5L3B7G/enVbW3Lf8+8DHgSOCz7QVwyUHmkCQNoGvYVNVdwPyETadPGFvABQc5zpXAlRPqC8ArJ9S/N2kOSdIwfIKAJKk7w0aS1J1hI0nqzrCRJHVn2EiSujNsJEndGTaSpO4MG0lSd72fICBpBZvbev3QLXTxwCVnD93CquOZjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUndThU2Sm6epSZI0yaJPEEhyBPBc4PgkxwJpm44GXtK5N0nSjDjU42r+DfBuRsGyg/8fNt8HLuvYlyRphiwaNlX1QeCDSd5VVX+xTD1JkmbMVA/irKq/SPLrwNz4PlV1dae+JEkzZKqwSfJx4J8CdwFPtXIBho0k6ZCm/YmBeWBjVVXPZiRJs2na79l8A/gnPRuRJM2uac9sjgfuTXIb8KP9xap6Y5euJEkzZdqw+ZOeTUiSZtu0d6P9996NSJJm17R3oz3B6O4zgMOBZwM/rKqjezUmSZod057ZPH98Pck5wCldOpIkzZxn9NTnqvpvwOuWuBdJ0oya9jLab42tPovR9278zo0kaSrT3o32L8eWnwQeADYveTeSpJk07Wc27+jdiCRpdk3742nrk3w6ySNJvpvkk0nW925OkjQbpr1B4KPAdka/a7MO+JtWkyTpkKYNm7VV9dGqerK9Pgas7diXJGmGTBs2jyZ5a5LD2uutwPd6NiZJmh3Ths2/At4M/APwMPA7gDcNSJKmMm3YvBfYUlVrq+pFjMLnT6bZsZ0J3Znkb9v6SUluTXJfkr9OcnirP6et72rb58aOcXGrfzPJmWP1Ta22K8nWsfrEOSRJw5g2bF5VVfv2r1TVXuDkKfe9ENg5tv5+4ANVtQHYB5zX6ucB+6rqZcAH2jiSbATOBV4BbAI+tP9yHnAZcBawEXhLG7vYHJKkAUwbNs9Kcuz+lSQvZIrv6LTbo88GPtLWw+gxN9e1IVcB57TlzW2dtv30Nn4zcE1V/aiqvgXsYvRctlOAXVV1f1X9GLgG2HyIOSRJA5j2CQL/BfhykusYPabmzcD7ptjvz4E/AvY/yPM44LGqerKt72Z0KzXt74MAVfVkksfb+HXAV8eOOb7PgwfUX3OIOSRJA5jqzKaqrgZ+G/gusAf4rar6+GL7JHkD8EhV7RgvTzr8IbYtVX1Sj+cnWUiysGfPnklDJElLYNozG6rqXuDep3Hs04A3Jnk9cARwNKMznWOSrGlnHuuBh9r43cCJwO4ka4AXAHvH6vuN7zOp/ugicxz4nrYB2wDm5+d9sKgkdfKMfmJgGlV1cVWtr6o5Rh/wf6Gqfhe4hdGt0wBbgM+05e1tnbb9C1VVrX5uu1vtJGADcBtwO7Ch3Xl2eJtje9vnYHNIkgbQLWwW8cfARUl2Mfp85YpWvwI4rtUvArYCVNU9wLWMzqo+B1xQVU+1s5Z3Ajcyutvt2jZ2sTkkSQOY+jLaz6Kqvgh8sS3fz4Rf+ayq/wW86SD7v48JNyRU1Q3ADRPqE+eQJA1jiDMbSdIqY9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTu1gzdgLRSzG29fugWunngkrOHbkEzzjMbSVJ3ntksAf/HK0mL88xGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpu25hk+TEJLck2ZnkniQXtvoLk9yU5L7299hWT5JLk+xK8vUkrx471pY2/r4kW8bqv5Lk7rbPpUmy2BySpGH0PLN5EvjDqvpl4FTggiQbga3AzVW1Abi5rQOcBWxor/OBy2EUHMB7gNcApwDvGQuPy9vY/fttavWDzSFJGkC3sKmqh6vqjrb8BLATWAdsBq5qw64CzmnLm4Gra+SrwDFJTgDOBG6qqr1VtQ+4CdjUth1dVV+pqgKuPuBYk+aQJA1gWZ6NlmQOOBm4FXhxVT0Mo0BK8qI2bB3w4Nhuu1ttsfruCXUWmePAvs5ndGbES1/60mf47lYnnwcn6enofoNAkucBnwTeXVXfX2zohFo9g/rUqmpbVc1X1fzatWufzq6SpKeha9gkeTajoPlEVX2qlb/bLoHR/j7S6ruBE8d2Xw88dIj6+gn1xeaQJA2g591oAa4AdlbVn41t2g7sv6NsC/CZsfrb211ppwKPt0thNwJnJDm23RhwBnBj2/ZEklPbXG8/4FiT5pAkDaDnZzanAW8D7k5yV6v9B+AS4Nok5wHfAd7Utt0AvB7YBfwj8A6Aqtqb5L3A7W3cn1bV3rb8+8DHgCOBz7YXi8whSRpAt7Cpqi8x+XMVgNMnjC/ggoMc60rgygn1BeCVE+rfmzSHJGkYPkFAktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuZjZskmxK8s0ku5JsHbofSVrNZjJskhwGXAacBWwE3pJk47BdSdLqNZNhA5wC7Kqq+6vqx8A1wOaBe5KkVWtWw2Yd8ODY+u5WkyQNIFU1dA9LLsmbgDOr6l+39bcBp1TVuw4Ydz5wflt9OfDNZW30Z3c88OjQTSwz3/Pq4HteOX6hqtYeatCa5ehkALuBE8fW1wMPHTioqrYB25arqaWWZKGq5ofuYzn5nlcH3/PsmdXLaLcDG5KclORw4Fxg+8A9SdKqNZNnNlX1ZJJ3AjcChwFXVtU9A7clSavWTIYNQFXdANwwdB+drdhLgD8D3/Pq4HueMTN5g4Ak6efLrH5mI0n6OWLYrEBJrkzySJJvDN3LcklyYpJbkuxMck+SC4fuqbckRyS5LcnX2nv+j0P3tBySHJbkziR/O3QvyyXJA0nuTnJXkoWh++nBy2grUJLXAj8Arq6qVw7dz3JIcgJwQlXdkeT5wA7gnKq6d+DWukkS4Kiq+kGSZwNfAi6sqq8O3FpXSS4C5oGjq+oNQ/ezHJI8AMxX1Ur8ns1UPLNZgarqfwB7h+5jOVXVw1V1R1t+AtjJjD8VokZ+0Faf3V4z/b/DJOuBs4GPDN2LlpZhoxUnyRxwMnDrsJ301y4p3QU8AtxUVbP+nv8c+CPg/wzdyDIr4PNJdrQnm8wcw0YrSpLnAZ8E3l1V3x+6n96q6qmq+ueMnoJxSpKZvWya5A3AI1W1Y+heBnBaVb2a0ZPqL2iXymeKYaMVo31u8UngE1X1qaH7WU5V9RjwRWDTwK30dBrwxvb5xTXA65L85bAtLY+qeqj9fQT4NKMn188Uw0YrQvuw/ApgZ1X92dD9LIcka5Mc05aPBH4T+Pthu+qnqi6uqvVVNcfoEVNfqKq3DtxWd0mOaje9kOQo4Axg5u40NWxWoCR/BXwFeHmS3UnOG7qnZXAa8DZG/9u9q71eP3RTnZ0A3JLk64ye93dTVa2a24FXkRcDX0ryNeA24Pqq+tzAPS05b32WJHXnmY0kqTvDRpLUnWEjSerOsJEkdWfYSJK6M2yknzNJ3p3kuWPrN+z/vo20UnnrszSA9iXVVNVPPQNsNTwBWKuPZzbSMkky136P50PAHcAVSRbGf6smyR8AL2H0Zc5bWu2BJMeP7f/hts/n25MFSPKrSb6e5CtJ/tNq+q0jrQyGjbS8Xs7od4hOBv6wquaBVwH/IsmrqupS4CHgN6rqNybsvwG4rKpeATwG/HarfxT4t1X1a8BT3d+F9DQZNtLy+vbYj5+9OckdwJ3AK4CNU+z/raq6qy3vAOba5znPr6ovt/p/XdKOpSWwZugGpFXmhwBJTgL+PfCrVbUvyceAI6bY/0djy08BRwJZ6ialpeaZjTSMoxkFz+NJXszod0z2ewJ4/rQHqqp9wBNJTm2lc5esS2mJeGYjDaCqvpbkTuAe4H7g78Y2bwM+m+Thg3xuM8l5wIeT/JDR7948vpT9Sj8rb32WZkCS51XVD9ryVuCEqrpw4Lak/8czG2k2nJ3kYkb/pr8N/N6w7Ug/yTMbSVJ33iAgSerOsJEkdWfYSJK6M2wkSd0ZNpKk7gwbSVJ3/xf1rVooPg/kAAAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x107a2a550>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "rating distribution of reviews from users with 30 to 50 reviews written\n",
      "274066 reviews in subset\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZUAAAEKCAYAAADaa8itAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvNQv5yAAAEjpJREFUeJzt3X3MXnV9x/H3R5CJKANHdUjJbrY1btW4oR1jI9kyWaCIs8SJwUztHEs3g4p7yFb2D9ucicsenBg06QQE58YM6uykjhHELW4K3AV8KNXQIEoHSl0Lost0Zd/9cf3qLsrd9oL+zn316v1+JVfuc77nd06/5w/y4TynqpAkqYenTLsBSdLhw1CRJHVjqEiSujFUJEndGCqSpG4MFUlSN4aKJKkbQ0WS1I2hIknq5shpN7DYTjjhhJqbm5t2G5I0MzZv3vyNqlo2ydglFypzc3PMz89Puw1JmhlJvjLpWE9/SZK6MVQkSd0YKpKkbgwVSVI3hookqRtDRZLUjaEiSerGUJEkdWOoSJK6WXJP1Et6rLn110+7hcHc+/Zzp93CkuORiiSpG0NFktSNoSJJ6sZQkSR1Y6hIkroxVCRJ3RgqkqRuDBVJUjeGiiSpG0NFktSNoSJJ6sZQkSR1Y6hIkroxVCRJ3RgqkqRu/J6KpCXHb8gMxyMVSVI3hookqRtDRZLUjaEiSerGUJEkdWOoSJK6MVQkSd0YKpKkbgYNlSS/lWRLki8k+bskT0tySpJbktyd5O+THNXGfl+b39aWz41t55JW/1KSs8fqq1ttW5L1Q+6LJOnABguVJCcBbwZWVdULgCOAC4A/Bd5RVSuAXcCFbZULgV1V9aPAO9o4kqxs6z0fWA28O8kRSY4ALgfOAVYCr25jJUlTMvTpryOBo5McCTwdeAB4CXBdW341cF6bXtPmacvPTJJWv7aqvlNVXwa2Aae137aquqeqvgtc28ZKkqZksFCpqv8A/hz4KqMweRjYDDxUVbvbsO3ASW36JOC+tu7uNv4Hxut7rbOvuiRpSoY8/XU8oyOHU4DnAscwOlW1t9qzyj6WPdH6Qr2sSzKfZH7Hjh0Hal2S9CQNefrrF4EvV9WOqvof4MPAzwLHtdNhAMuB+9v0duBkgLb8+4Gd4/W91tlX/XGqakNVraqqVcuWLeuxb5KkBQwZKl8FTk/y9HZt5EzgLuBm4JVtzFrgo216Y5unLf9EVVWrX9DuDjsFWAHcCtwGrGh3kx3F6GL+xgH3R5J0AIN9T6WqbklyHXA7sBu4A9gAXA9cm+RPWu2KtsoVwPuTbGN0hHJB286WJB9kFEi7gYuq6lGAJG8EbmB0Z9mVVbVlqP2RJB3YoB/pqqpLgUv3Kt/D6M6tvcf+N3D+PrbzNuBtC9Q3AZsOvlNJUg8+US9J6sZQkSR1Y6hIkroxVCRJ3RgqkqRuDBVJUjeGiiSpG0NFktSNoSJJ6sZQkSR1Y6hIkroxVCRJ3RgqkqRuDBVJUjeGiiSpG0NFktSNoSJJ6sZQkSR1Y6hIkroxVCRJ3RgqkqRuDBVJUjeGiiSpG0NFktSNoSJJ6sZQkSR1Y6hIkroxVCRJ3RgqkqRuDBVJUjeGiiSpG0NFktSNoSJJ6sZQkSR1Y6hIkroxVCRJ3QwaKkmOS3Jdki8m2ZrkZ5I8K8mNSe5uf49vY5PksiTbknwuyYvGtrO2jb87ydqx+ouTfL6tc1mSDLk/kqT9G/pI5Z3AP1XVjwE/AWwF1gM3VdUK4KY2D3AOsKL91gHvAUjyLOBS4KeB04BL9wRRG7NubL3VA++PJGk/BguVJMcCPwdcAVBV362qh4A1wNVt2NXAeW16DXBNjXwGOC7JicDZwI1VtbOqdgE3AqvbsmOr6tNVVcA1Y9uSJE3BkEcqPwzsAK5KckeS9yY5BnhOVT0A0P4+u40/CbhvbP3trba/+vYF6o+TZF2S+STzO3bsOPg9kyQtaMhQORJ4EfCeqjoV+Db/f6prIQtdD6knUX98sWpDVa2qqlXLli3bf9eSpCdtyFDZDmyvqlva/HWMQubr7dQV7e+DY+NPHlt/OXD/AerLF6hLkqZksFCpqq8B9yV5XiudCdwFbAT23MG1Fvhom94IvK7dBXY68HA7PXYDcFaS49sF+rOAG9qyR5Kc3u76et3YtiRJU3DkwNt/E/CBJEcB9wCvZxRkH0xyIfBV4Pw2dhPwUmAb8F9tLFW1M8lbgdvauD+uqp1t+g3A+4CjgY+3nyRpSgYNlaq6E1i1wKIzFxhbwEX72M6VwJUL1OeBFxxkm5KkTnyiXpLUjaEiSerGUJEkdWOoSJK6MVQkSd0YKpKkbgwVSVI3E4VKkpsmqUmSlrb9PvyY5GnA04ET2itS9rzE8VjguQP3JkmaMQd6ov43gLcwCpDN/H+ofBO4fMC+JEkzaL+hUlXvBN6Z5E1V9a5F6kmSNKMmevdXVb0ryc8Cc+PrVNU1A/UlSZpBE4VKkvcDPwLcCTzayns+4StJEjD5W4pXASvbm4QlSVrQpM+pfAH4wSEbkSTNvkmPVE4A7kpyK/CdPcWqevkgXUmSZtKkofKHQzYhSTo8THr3178M3YgkafZNevfXI4zu9gI4Cngq8O2qOnaoxiRJs2fSI5Vnjs8nOQ84bZCOpCmbW3/9tFsYxL1vP3faLWgJeFJvKa6qfwBe0rkXSdKMm/T01yvGZp/C6LkVn1mRJD3GpHd//dLY9G7gXmBN924kSTNt0msqrx+6EUnS7Jv0I13Lk3wkyYNJvp7kQ0mWD92cJGm2THqh/ipgI6PvqpwE/GOrSZL0PZOGyrKquqqqdrff+4BlA/YlSZpBk4bKN5K8JskR7fca4D+HbEySNHsmDZVfA14FfA14AHgl4MV7SdJjTHpL8VuBtVW1CyDJs4A/ZxQ2kiQBkx+pvHBPoABU1U7g1GFakiTNqklD5SlJjt8z045UJj3KkSQtEZMGw18A/57kOkavZ3kV8LbBupIkzaRJn6i/Jsk8o5dIBnhFVd01aGeSpJkz8SmsFiIGiSRpn57Uq++fiPZcyx1JPtbmT0lyS5K7k/x9kqNa/fva/La2fG5sG5e0+peSnD1WX91q25KsH3pfJEn7N3ioABcDW8fm/xR4R1WtAHYBF7b6hcCuqvpR4B1tHElWAhcAzwdWA+/e8xAmcDlwDrASeHUbK0makkFDpb108lzgvW0+jK7LXNeGXA2c16bXtHna8jPb+DXAtVX1nar6MrCN0VcnTwO2VdU9VfVd4Fp8Hb8kTdXQRyp/Bfwe8L9t/geAh6pqd5vfzugFlbS/9wG05Q+38d+r77XOvuqSpCkZLFSSvAx4sKo2j5cXGFoHWPZE6wv1si7JfJL5HTt27KdrSdLBGPJI5Qzg5UnuZXRq6iWMjlyOS7LnrrPlwP1tejtwMkBb/v3AzvH6Xuvsq/44VbWhqlZV1aply3y5siQNZbBQqapLqmp5Vc0xutD+iar6FeBmRi+kBFgLfLRNb2zztOWfqKpq9Qva3WGnACuAW4HbgBXtbrKj2r+xcaj9kSQd2DRetfL7wLVJ/gS4A7ii1a8A3p9kG6MjlAsAqmpLkg8yekZmN3BRVT0KkOSNwA3AEcCVVbVlUfdEkvQYixIqVfVJ4JNt+h5Gd27tPea/gfP3sf7bWOC1MFW1CdjUsVVJ0kFYjOdUJElLhKEiSerGUJEkdWOoSJK6MVQkSd0YKpKkbgwVSVI3hookqRtDRZLUjaEiSerGUJEkdWOoSJK6MVQkSd0YKpKkbgwVSVI3hookqRtDRZLUjaEiSerGUJEkdWOoSJK6MVQkSd0YKpKkbgwVSVI3hookqZsjp92ADm1z66+fdguDuPft5067Bemw5JGKJKkbQ0WS1I2hIknqxlCRJHVjqEiSujFUJEndGCqSpG4MFUlSN4aKJKkbQ0WS1I2hIknqZrBQSXJykpuTbE2yJcnFrf6sJDcmubv9Pb7Vk+SyJNuSfC7Ji8a2tbaNvzvJ2rH6i5N8vq1zWZIMtT+SpAMb8khlN/A7VfXjwOnARUlWAuuBm6pqBXBTmwc4B1jRfuuA98AohIBLgZ8GTgMu3RNEbcy6sfVWD7g/kqQDGCxUquqBqrq9TT8CbAVOAtYAV7dhVwPntek1wDU18hnguCQnAmcDN1bVzqraBdwIrG7Ljq2qT1dVAdeMbUuSNAWLck0lyRxwKnAL8JyqegBGwQM8uw07CbhvbLXtrba/+vYF6gv9++uSzCeZ37Fjx8HujiRpHwb/nkqSZwAfAt5SVd/cz2WPhRbUk6g/vli1AdgAsGrVqgXHTOJw/bYI+H0RSX0MeqSS5KmMAuUDVfXhVv56O3VF+/tgq28HTh5bfTlw/wHqyxeoS5KmZMi7vwJcAWytqr8cW7QR2HMH11rgo2P117W7wE4HHm6nx24AzkpyfLtAfxZwQ1v2SJLT27/1urFtSZKmYMjTX2cArwU+n+TOVvsD4O3AB5NcCHwVOL8t2wS8FNgG/BfweoCq2pnkrcBtbdwfV9XONv0G4H3A0cDH20+SNCWDhUpVfYqFr3sAnLnA+AIu2se2rgSuXKA+D7zgINqUJHXkE/WSpG4MFUlSN4aKJKkbQ0WS1I2hIknqxlCRJHVjqEiSujFUJEndGCqSpG4MFUlSN4aKJKkbQ0WS1I2hIknqxlCRJHVjqEiSujFUJEndGCqSpG4MFUlSN4aKJKkbQ0WS1I2hIknqxlCRJHVjqEiSujFUJEndGCqSpG4MFUlSN4aKJKkbQ0WS1I2hIknqxlCRJHVjqEiSujFUJEndGCqSpG4MFUlSN4aKJKmbmQ+VJKuTfCnJtiTrp92PJC1lMx0qSY4ALgfOAVYCr06ycrpdSdLSNdOhApwGbKuqe6rqu8C1wJop9yRJS9ash8pJwH1j89tbTZI0BamqaffwpCU5Hzi7qn69zb8WOK2q3rTXuHXAujb7POBLi9rowTsB+Ma0m1hk7vPS4D7Phh+qqmWTDDxy6E4Gth04eWx+OXD/3oOqagOwYbGa6i3JfFWtmnYfi8l9Xhrc58PPrJ/+ug1YkeSUJEcBFwAbp9yTJC1ZM32kUlW7k7wRuAE4AriyqrZMuS1JWrJmOlQAqmoTsGnafQxsZk/dHQT3eWlwnw8zM32hXpJ0aJn1ayqSpEOIoXIIS3JlkgeTfGHavSyWJCcnuTnJ1iRbklw87Z6GluRpSW5N8tm2z3807Z4WQ5IjktyR5GPT7mUxJLk3yeeT3Jlkftr9DMXTX4ewJD8HfAu4pqpeMO1+FkOSE4ETq+r2JM8ENgPnVdVdU25tMEkCHFNV30ryVOBTwMVV9ZkptzaoJL8NrAKOraqXTbufoSW5F1hVVbP2jMoT4pHKIayq/hXYOe0+FlNVPVBVt7fpR4CtHOZvSaiRb7XZp7bfYf1/e0mWA+cC7512L+rLUNEhK8kccCpwy3Q7GV47FXQn8CBwY1Ud7vv8V8DvAf877UYWUQH/nGRze8vHYclQ0SEpyTOADwFvqapvTrufoVXVo1X1k4zeCnFaksP2dGeSlwEPVtXmafeyyM6oqhcxeqv6Re309mHHUNEhp11X+BDwgar68LT7WUxV9RDwSWD1lFsZ0hnAy9s1hmuBlyT5m+m2NLyqur/9fRD4CKO3rB92DBUdUtpF6yuArVX1l9PuZzEkWZbkuDZ9NPCLwBen29VwquqSqlpeVXOMXq30iap6zZTbGlSSY9qNJyQ5BjgLOCzv6jRUDmFJ/g74NPC8JNuTXDjtnhbBGcBrGf3f653t99JpNzWwE4Gbk3yO0fvsbqyqJXGb7RLyHOBTST4L3ApcX1X/NOWeBuEtxZKkbjxSkSR1Y6hIkroxVCRJ3RgqkqRuDBVJUjeGijQlSd6S5Olj85v2PK8izSpvKZYG1B7mTFU97h1XS+WttVpaPFKROksy174H827gduCKJPPj30pJ8mbguYweery51e5NcsLY+n/d1vnn9qQ9SX4qyeeSfDrJny2lb+1oNhgq0jCex+g7OKcCv1NVq4AXAj+f5IVVdRlwP/ALVfULC6y/Ari8qp4PPAT8cqtfBfxmVf0M8OjgeyE9QYaKNIyvjH1k61VJbgfuAJ4PrJxg/S9X1Z1tejMw1663PLOq/r3V/7Zrx1IHR067Aekw9W2AJKcAvwv8VFXtSvI+4GkTrP+dselHgaOB9G5S6s0jFWlYxzIKmIeTPIfRtzT2eAR45qQbqqpdwCNJTm+lC7p1KXXikYo0oKr6bJI7gC3APcC/jS3eAHw8yQP7uK6ykAuBv07ybUbfXXm4Z7/SwfKWYmmGJHnGnu/ZJ1kPnFhVF0+5Lel7PFKRZsu5SS5h9N/uV4BfnW470mN5pCJJ6sYL9ZKkbgwVSVI3hookqRtDRZLUjaEiSerGUJEkdfN/C+Pe+A5SrcIAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x108772160>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "rating distribution of reviews from users with 50 to 100 reviews written\n",
      "323310 reviews in subset\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZsAAAEKCAYAAADEovgeAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvNQv5yAAAFdBJREFUeJzt3X+wX3V95/Hny0QUfyAo0aUJs5ddM85Gxl01RVpnulY6EMQ1TFc6YbaS2uxk66DF3e7U0P2DXZUZnHZLpYvOpCUC1hoZ1CVbYjGDuI6r/LgBRAO63EGUu7AmNhFRR9nQ9/7x/Vz7NdwklySfe8jN8zFz557zPp9zzvv8Aa+c8/3c801VIUlST88ZugFJ0sJn2EiSujNsJEndGTaSpO4MG0lSd4aNJKk7w0aS1J1hI0nqzrCRJHW3eOgGni1OPvnkmpiYGLoNSTqqbN++/ftVteRg4wybZmJigsnJyaHbkKSjSpLvzGWcj9EkSd0ZNpKk7gwbSVJ3ho0kqbtuYZNkU5KdSb4xVvvjJN9Mcl+SzyY5cWzbpUmmknwryTlj9VWtNpVkw1j9tCR3JHkwyaeSHNfqz2vrU237RK9rlCTNTc87m2uBVfvUtgGnV9VrgP8NXAqQZAWwBnh12+cjSRYlWQRcDZwLrAAubGMBPgRcWVXLgT3AulZfB+ypqlcCV7ZxkqQBdQubqvoSsHuf2ueram9bvR1Y1pZXA5ur6mdV9W1gCjij/UxV1UNV9SSwGVidJMCbgRvb/tcB548d67q2fCNwVhsvSRrIkJ/Z/C7wuba8FHhkbNt0q+2v/jLgB2PBNVP/hWO17Y+38ZKkgQwSNkn+E7AX+MRMaZZhdQj1Ax1rtj7WJ5lMMrlr164DNy1JOmTz/gaBJGuBtwJnVdVMCEwDp44NWwY82pZnq38fODHJ4nb3Mj5+5ljTSRYDL2Gfx3kzqmojsBFg5cqVswaSdCyb2HDz0C108/AV5w3dwjFlXu9skqwC3ge8rap+MrZpC7CmzSQ7DVgO3AncBSxvM8+OYzSJYEsLqduAt7f91wI3jR1rbVt+O/CFsVCTJA2g251Nkk8CbwJOTjINXMZo9tnzgG3tM/vbq+r3qmpHkhuA+xk9Xru4qp5qx3k3cAuwCNhUVTvaKd4HbE7yQeAe4JpWvwb4eJIpRnc0a3pdoyRpbrqFTVVdOEv5mllqM+MvBy6fpb4V2DpL/SFGs9X2rf8UuOAZNStJ6so3CEiSujNsJEndGTaSpO4MG0lSd4aNJKk7w0aS1J1hI0nqzrCRJHVn2EiSujNsJEndGTaSpO4MG0lSd4aNJKk7w0aS1J1hI0nqzrCRJHVn2EiSujNsJEndGTaSpO4MG0lSd4aNJKk7w0aS1J1hI0nqzrCRJHVn2EiSujNsJEnddQubJJuS7EzyjbHaS5NsS/Jg+31SqyfJVUmmktyX5HVj+6xt4x9Msnas/vokX2/7XJUkBzqHJGk4Pe9srgVW7VPbANxaVcuBW9s6wLnA8vazHvgojIIDuAx4A3AGcNlYeHy0jZ3Zb9VBziFJGki3sKmqLwG79ymvBq5ry9cB54/Vr6+R24ETk5wCnANsq6rdVbUH2AasattOqKqvVlUB1+9zrNnOIUkayHx/ZvOKqnoMoP1+easvBR4ZGzfdageqT89SP9A5nibJ+iSTSSZ37dp1yBclSTqwZ8sEgcxSq0OoPyNVtbGqVlbVyiVLljzT3SVJczTfYfO99giM9ntnq08Dp46NWwY8epD6slnqBzqHJGkg8x02W4CZGWVrgZvG6he1WWlnAo+3R2C3AGcnOalNDDgbuKVteyLJmW0W2kX7HGu2c0iSBrK414GTfBJ4E3BykmlGs8quAG5Isg74LnBBG74VeAswBfwEeCdAVe1O8gHgrjbu/VU1M+ngXYxmvB0PfK79cIBzSJIG0i1squrC/Ww6a5axBVy8n+NsAjbNUp8ETp+l/neznUOSNJxnywQBSdICZthIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpu25fMSBJR6OJDTcP3UIXD19x3qDn985GktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktSdYSNJ6m6QsEny75PsSPKNJJ9M8vwkpyW5I8mDST6V5Lg29nltfaptnxg7zqWt/q0k54zVV7XaVJIN83+FkqRx8x42SZYCvw+srKrTgUXAGuBDwJVVtRzYA6xru6wD9lTVK4Er2ziSrGj7vRpYBXwkyaIki4CrgXOBFcCFbawkaSBDPUZbDByfZDHwAuAx4M3AjW37dcD5bXl1W6dtPytJWn1zVf2sqr4NTAFntJ+pqnqoqp4ENrexkqSBzHvYVNX/Af4E+C6jkHkc2A78oKr2tmHTwNK2vBR4pO27t41/2Xh9n332V5ckDWSIx2gnMbrTOA34JeCFjB557atmdtnPtmdan62X9Ukmk0zu2rXrYK1Lkg7REI/RfgP4dlXtqqr/B3wG+FXgxPZYDWAZ8GhbngZOBWjbXwLsHq/vs8/+6k9TVRuramVVrVyyZMmRuDZJ0iyGCJvvAmcmeUH77OUs4H7gNuDtbcxa4Ka2vKWt07Z/oaqq1de02WqnAcuBO4G7gOVtdttxjCYRbJmH65Ik7ce8f1NnVd2R5EbgbmAvcA+wEbgZ2Jzkg612TdvlGuDjSaYY3dGsacfZkeQGRkG1F7i4qp4CSPJu4BZGM902VdWO+bo+SdLTDfK10FV1GXDZPuWHGM0k23fsT4EL9nOcy4HLZ6lvBbYefqeSpCPBNwhIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpuzmFTZJb51KTJGk2B/yKgSTPB14AnNy+znnmK5dPYPSVzpIkHdTBvs/m3wHvZRQs2/mHsPkhcHXHviRJC8gBw6aqPgx8OMl7qurP56knSdICM6dv6qyqP0/yq8DE+D5VdX2nviRJC8icwibJx4F/CtwLPNXKBRg2kqSDmlPYACuBFVVVPZuRns0mNtw8dAvdPHzFeUO3oAVurn9n8w3gH/VsRJK0cM31zuZk4P4kdwI/mylW1du6dCVJWlDmGjb/uWcTkqSFba6z0f5n70YkSQvXXGejPcFo9hnAccBzgR9X1Qm9GpMkLRxzvbN58fh6kvOBM7p0JElacA7prc9V9d+BNx/qSZOcmOTGJN9M8kCSX0ny0iTbkjzYfp/UxibJVUmmktyX5HVjx1nbxj+YZO1Y/fVJvt72uSpJZutDkjQ/5voY7TfHVp/D6O9uDudvbj4M/G1VvT3JcYxe9vlHwK1VdUWSDcAG4H3AucDy9vMG4KPAG5K8FLhsrJftSbZU1Z42Zj1wO7AVWAV87jD6lSQdhrnORvtXY8t7gYeB1YdywiQnAL8G/A5AVT0JPJlkNfCmNuw64IuMwmY1cH37g9Lb213RKW3stqra3Y67DViV5IvACVX11Va/Hjgfw0aSBjPXz2zeeQTP+U+AXcDHkvxzRm+TvgR4RVU91s73WJKXt/FLgUfG9p9utQPVp2epS5IGMtcvT1uW5LNJdib5XpJPJ1l2iOdcDLwO+GhVvRb4MaNHZvs9/Sy1OoT60w+crE8ymWRy165dB+5aknTI5jpB4GPAFkbfa7MU+B+tdiimgemquqOt38gofL7XHo/Rfu8cG3/q2P7LgEcPUl82S/1pqmpjVa2sqpVLliw5xMuRJB3MXMNmSVV9rKr2tp9rgUP6v3NV/V/gkSSvaqWzgPsZhdnMjLK1wE1teQtwUZuVdibweHvcdgtwdpKT2sy1s4Fb2rYnkpzZZqFdNHYsSdIA5jpB4PtJfhv4ZFu/EPi7wzjve4BPtJloDwHvZBR8NyRZB3wXuKCN3Qq8BZgCftLGUlW7k3wAuKuNe//MZAHgXcC1wPGMJgY4OUCSBjTXsPld4L8BVzL6/OMrtP/pH4qqupfRlOV9nTXL2AIu3s9xNgGbZqlPAqcfan+SpCNrrmHzAWBt+xsW2t+4/AmjEJIk6YDm+pnNa2aCBkaPsIDX9mlJkrTQzDVsnjPz+hj4+Z3NXO+KJEnHuLkGxn8FvpLkRkaf2fwWcHm3riRJC8pc3yBwfZJJRi/fDPCbVXV/184kSQvGnB+FtXAxYCRJz9ghfcWAJEnPhGEjSerOsJEkdWfYSJK6M2wkSd0ZNpKk7gwbSVJ3ho0kqTvDRpLUnWEjSerOsJEkdWfYSJK6M2wkSd0ZNpKk7gwbSVJ3ho0kqTvDRpLUnWEjSerOsJEkdWfYSJK6GyxskixKck+Sv2nrpyW5I8mDST6V5LhWf15bn2rbJ8aOcWmrfyvJOWP1Va02lWTDfF+bJOkXDXlncwnwwNj6h4Arq2o5sAdY1+rrgD1V9UrgyjaOJCuANcCrgVXAR1qALQKuBs4FVgAXtrGSpIEMEjZJlgHnAX/Z1gO8GbixDbkOOL8tr27rtO1ntfGrgc1V9bOq+jYwBZzRfqaq6qGqehLY3MZKkgYy1J3NnwF/CPx9W38Z8IOq2tvWp4GlbXkp8AhA2/54G//z+j777K/+NEnWJ5lMMrlr167DvSZJ0n7Me9gkeSuws6q2j5dnGVoH2fZM608vVm2sqpVVtXLJkiUH6FqSdDgWD3DONwJvS/IW4PnACYzudE5MsrjdvSwDHm3jp4FTgekki4GXALvH6jPG99lfXZI0gHm/s6mqS6tqWVVNMPqA/wtV9W+A24C3t2FrgZva8pa2Ttv+haqqVl/TZqudBiwH7gTuApa32W3HtXNsmYdLkyTtxxB3NvvzPmBzkg8C9wDXtPo1wMeTTDG6o1kDUFU7ktwA3A/sBS6uqqcAkrwbuAVYBGyqqh3zeiWSpF8waNhU1ReBL7blhxjNJNt3zE+BC/az/+XA5bPUtwJbj2CrkqTD4BsEJEndGTaSpO4MG0lSd4aNJKk7w0aS1J1hI0nqzrCRJHVn2EiSujNsJEndGTaSpO6eTe9G01FkYsPNQ7fQzcNXnDd0C9KC452NJKk7w0aS1J1hI0nqzrCRJHVn2EiSujNsJEndGTaSpO4MG0lSd4aNJKk7w0aS1J1hI0nqzrCRJHVn2EiSujNsJEndzXvYJDk1yW1JHkiyI8klrf7SJNuSPNh+n9TqSXJVkqkk9yV53dix1rbxDyZZO1Z/fZKvt32uSpL5vk5J0j8Y4s5mL/AHVfXPgDOBi5OsADYAt1bVcuDWtg5wLrC8/awHPgqjcAIuA94AnAFcNhNQbcz6sf1WzcN1SZL2Y97Dpqoeq6q72/ITwAPAUmA1cF0bdh1wflteDVxfI7cDJyY5BTgH2FZVu6tqD7ANWNW2nVBVX62qAq4fO5YkaQCDfmaTZAJ4LXAH8IqqegxGgQS8vA1bCjwyttt0qx2oPj1LXZI0kMHCJsmLgE8D762qHx5o6Cy1OoT6bD2sTzKZZHLXrl0Ha1mSdIgGCZskz2UUNJ+oqs+08vfaIzDa752tPg2cOrb7MuDRg9SXzVJ/mqraWFUrq2rlkiVLDu+iJEn7NcRstADXAA9U1Z+ObdoCzMwoWwvcNFa/qM1KOxN4vD1muwU4O8lJbWLA2cAtbdsTSc5s57po7FiSpAEsHuCcbwTeAXw9yb2t9kfAFcANSdYB3wUuaNu2Am8BpoCfAO8EqKrdST4A3NXGvb+qdrfldwHXAscDn2s/kqSBzHvYVNWXmf1zFYCzZhlfwMX7OdYmYNMs9Ung9MNo8xmZ2HDzfJ1q3j18xXlDtyBpAfANApKk7gwbSVJ3ho0kqTvDRpLUnWEjSerOsJEkdWfYSJK6M2wkSd0ZNpKk7gwbSVJ3ho0kqTvDRpLUnWEjSerOsJEkdWfYSJK6M2wkSd0ZNpKk7gwbSVJ3ho0kqTvDRpLUnWEjSerOsJEkdWfYSJK6M2wkSd0ZNpKk7gwbSVJ3CzZskqxK8q0kU0k2DN2PJB3LFmTYJFkEXA2cC6wALkyyYtiuJOnYtSDDBjgDmKqqh6rqSWAzsHrgniTpmLVQw2Yp8MjY+nSrSZIGkKoauocjLskFwDlV9W/b+juAM6rqPfuMWw+sb6uvAr41r40eGScD3x+6iXl0rF0veM3HiqP1mv9xVS052KDF89HJAKaBU8fWlwGP7juoqjYCG+erqR6STFbVyqH7mC/H2vWC13ysWOjXvFAfo90FLE9yWpLjgDXAloF7kqRj1oK8s6mqvUneDdwCLAI2VdWOgduSpGPWggwbgKraCmwduo95cFQ/BjwEx9r1gtd8rFjQ17wgJwhIkp5dFupnNpKkZxHD5iiVZFOSnUm+MXQv8yHJqUluS/JAkh1JLhm6p96SPD/JnUm+1q75vwzd03xJsijJPUn+Zuhe5kOSh5N8Pcm9SSaH7qcHH6MdpZL8GvAj4PqqOn3ofnpLcgpwSlXdneTFwHbg/Kq6f+DWukkS4IVV9aMkzwW+DFxSVbcP3Fp3Sf4DsBI4oareOnQ/vSV5GFhZVUfj39nMiXc2R6mq+hKwe+g+5ktVPVZVd7flJ4AHWOBvhaiRH7XV57afBf+vwyTLgPOAvxy6Fx05ho2OOkkmgNcCdwzbSX/tcdK9wE5gW1Ut+GsG/gz4Q+Dvh25kHhXw+STb25tNFhzDRkeVJC8CPg28t6p+OHQ/vVXVU1X1Lxi9BeOMJAv6kWmStwI7q2r70L3MszdW1esYvan+4vaYfEExbHTUaJ9bfBr4RFV9Zuh+5lNV/QD4IrBq4FZ6eyPwtvYZxmbgzUn+atiW+quqR9vvncBnGb25fkExbHRUaB+WXwM8UFV/OnQ/8yHJkiQntuXjgd8AvjlsV31V1aVVtayqJhi9ZuoLVfXbA7fVVZIXtkkvJHkhcDaw4GaZGjZHqSSfBL4KvCrJdJJ1Q/fU2RuBdzD6l+697ectQzfV2SnAbUnuY/S+v21VdUxMBT7GvAL4cpKvAXcCN1fV3w7c0xHn1GdJUnfe2UiSujNsJEndGTaSpO4MG0lSd4aNJKk7w0Z6lkny3iQvGFvfOvP3NtLRyqnP0gDaH6mmqp72/q9j4Q3AOvZ4ZyPNkyQT7ft4PgLcDVyTZHL8u2qS/D7wS4z+mPO2Vns4yclj+/9F2+fz7c0CJPnlJPcl+WqSPz5WvudIRw/DRppfr2L0HUSvBf6gqlYCrwH+ZZLXVNVVwKPAr1fVr8+y/3Lg6qp6NfAD4F+3+seA36uqXwGe6n4V0jNk2Ejz6ztjX372W0nuBu4BXg2smMP+366qe9vydmCifZ7z4qr6Sqv/9RHtWDoCFg/dgHSM+TFAktOA/wj8clXtSXIt8Pw57P+zseWngOOBHOkmpSPNOxtpGCcwCp7Hk7yC0feYzHgCePFcD1RVe4AnkpzZSmuOWJfSEeKdjTSAqvpaknuAHcBDwP8a27wR+FySx/bzuc1s1gF/keTHjL735vEj2a90uJz6LC0ASV5UVT9qyxuAU6rqkoHbkn7OOxtpYTgvyaWM/pv+DvA7w7Yj/SLvbCRJ3TlBQJLUnWEjSerOsJEkdWfYSJK6M2wkSd0ZNpKk7v4/2NdaqjRCgckAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x108da0128>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "rating distribution of reviews from users with 100 to 1000 reviews written\n",
      "382571 reviews in subset\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZsAAAEKCAYAAADEovgeAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvNQv5yAAAGXxJREFUeJzt3X/QXmV95/H3p0nxV0VQoqUJbmibuouMu+Ij0jrbbaVCENewXelCa8ladrK1aHXbTg3bP+hqnaHtbmlplZ3URIJriSzakqmxaRZpnW75FX7Iz1qeRSpPoSY2gFhXXOh3/7iv6E24kzx5yPUc8+T9mrnnOed7Xeec6zDDfHLOue5zp6qQJKmn7xh6AJKkhc+wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktRdt7BJsiHJjiR37VF/V5LPJ7k7yW+M1S9MMt3aTh+rr2y16SRrx+rHJ7kxyX1JPp7kiFZ/Tlufbu3Le52jJGl20usNAkl+GPgqcEVVndhqPwr8CnBmVT2R5KVVtSPJCcCVwMnA9wD/C/iBtqu/Bt4IzAA3A+dW1T1JrgI+WVWbkvx34HNVdVmSnwNeVVU/m+Qc4N9U1b/b33iPOeaYWr58+UH8LyBJC98tt9zy5apasr9+i3sNoKo+O+Gq4h3AxVX1ROuzo9VXAZta/QtJphkFD8B0Vd0PkGQTsCrJvcAbgJ9sfTYCvwpc1vb1q61+NfB7SVL7SdXly5ezffv2OZypJB2+kvzNbPrN9zObHwD+Zbu99edJXtvqS4EHx/rNtNre6i8BHq2qJ/eoP21frf2x1l+SNJBuVzb7ON7RwCnAa4GrknwvkAl9i8lhWPvoz37anibJGmANwMtf/vJ9DlySNHfzfWUzw+g5S1XVTcA/Ase0+nFj/ZYBD+2j/mXgqCSL96gzvk1rfxGwa9JgqmpdVU1V1dSSJfu95ShJmqP5Dps/YvSshSQ/ABzBKDg2A+e0mWTHAyuAmxhNCFjRZp4dAZwDbG7PX64D3tr2uxq4pi1vbuu09s/s73mNJKmvbrfRklwJ/AhwTJIZ4CJgA7ChTYf+BrC6BcHdbXbZPcCTwAVV9VTbzzuBrcAiYENV3d0O8V5gU5JfA24D1rf6euCjbZLBLkYBJUkaULepz4eaqampcjaaJB2YJLdU1dT++vkGAUlSd4aNJKk7w0aS1N18f89G0iFk+dpPDT2Ebh64+Myhh3BY8cpGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuuoVNkg1JdiS5a0LbLyWpJMe09SS5NMl0kjuSnDTWd3WS+9pn9Vj9NUnubNtcmiSt/uIk21r/bUmO7nWOkqTZ6Xllczmwcs9ikuOANwJfHCufAaxonzXAZa3vi4GLgNcBJwMXjYXHZa3v7u12H2stcG1VrQCubeuSpAF1C5uq+iywa0LTJcAvAzVWWwVcUSM3AEclORY4HdhWVbuq6hFgG7CytR1ZVddXVQFXAGeN7WtjW944VpckDWRen9kkeQvwt1X1uT2algIPjq3PtNq+6jMT6gAvq6qHAdrflx60E5Akzcm8/Sx0kucDvwKcNql5Qq3mUD/QMa1hdCuOl7/85Qe6uSRplubzyub7gOOBzyV5AFgG3JrkuxldmRw31ncZ8NB+6ssm1AG+1G6z0f7u2NuAqmpdVU1V1dSSJUuexalJkvZl3sKmqu6sqpdW1fKqWs4oME6qqr8DNgPntVlppwCPtVtgW4HTkhzdJgacBmxtbY8nOaXNQjsPuKYdajOwe9ba6rG6JGkgPac+XwlcD7wiyUyS8/fRfQtwPzAN/D7wcwBVtQt4P3Bz+7yv1QDeAXy4bfN/gE+3+sXAG5Pcx2jW28UH87wkSQeu2zObqjp3P+3Lx5YLuGAv/TYAGybUtwMnTqj/PXDqAQ5XktSRbxCQJHVn2EiSujNsJEndGTaSpO4MG0lSd4aNJKk7w0aS1J1hI0nqzrCRJHVn2EiSujNsJEndGTaSpO4MG0lSd4aNJKk7w0aS1J1hI0nqzrCRJHVn2EiSuusWNkk2JNmR5K6x2m8m+askdyT5wyRHjbVdmGQ6yeeTnD5WX9lq00nWjtWPT3JjkvuSfDzJEa3+nLY+3dqX9zpHSdLs9LyyuRxYuUdtG3BiVb0K+GvgQoAkJwDnAK9s23woyaIki4APAmcAJwDntr4Avw5cUlUrgEeA81v9fOCRqvp+4JLWT5I0oG5hU1WfBXbtUfvTqnqyrd4ALGvLq4BNVfVEVX0BmAZObp/pqrq/qr4BbAJWJQnwBuDqtv1G4KyxfW1sy1cDp7b+kqSBDPnM5meAT7flpcCDY20zrba3+kuAR8eCa3f9aftq7Y+1/pKkgQwSNkl+BXgS+Nju0oRuNYf6vvY1aRxrkmxPsn3nzp37HrQkac7mPWySrAbeDPxUVe0OgRnguLFuy4CH9lH/MnBUksV71J+2r9b+Iva4nbdbVa2rqqmqmlqyZMmzPTVJ0l7Ma9gkWQm8F3hLVX1trGkzcE6bSXY8sAK4CbgZWNFmnh3BaBLB5hZS1wFvbduvBq4Z29fqtvxW4DNjoSZJGsDi/XeZmyRXAj8CHJNkBriI0eyz5wDb2jP7G6rqZ6vq7iRXAfcwur12QVU91fbzTmArsAjYUFV3t0O8F9iU5NeA24D1rb4e+GiSaUZXNOf0OkdJ0ux0C5uqOndCef2E2u7+HwA+MKG+BdgyoX4/o9lqe9a/Dpx9QIOVJHXlGwQkSd0ZNpKk7gwbSVJ3ho0kqTvDRpLUnWEjSerOsJEkdWfYSJK6M2wkSd0ZNpKk7gwbSVJ3ho0kqTvDRpLUnWEjSerOsJEkdWfYSJK6M2wkSd0ZNpKk7rqFTZINSXYkuWus9uIk25Lc1/4e3epJcmmS6SR3JDlpbJvVrf99SVaP1V+T5M62zaVJsq9jSJKG0/PK5nJg5R61tcC1VbUCuLatA5wBrGifNcBlMAoO4CLgdcDJwEVj4XFZ67t7u5X7OYYkaSDdwqaqPgvs2qO8CtjYljcCZ43Vr6iRG4CjkhwLnA5sq6pdVfUIsA1Y2dqOrKrrq6qAK/bY16RjSJIGMt/PbF5WVQ8DtL8vbfWlwINj/WZabV/1mQn1fR1DkjSQb5cJAplQqznUD+ygyZok25Ns37lz54FuLkmapfkOmy+1W2C0vztafQY4bqzfMuCh/dSXTajv6xjPUFXrqmqqqqaWLFky55OSJO3bfIfNZmD3jLLVwDVj9fParLRTgMfaLbCtwGlJjm4TA04Dtra2x5Oc0mahnbfHviYdQ5I0kMW9dpzkSuBHgGOSzDCaVXYxcFWS84EvAme37luANwHTwNeAtwNU1a4k7wdubv3eV1W7Jx28g9GMt+cBn24f9nEMSdJAuoVNVZ27l6ZTJ/Qt4IK97GcDsGFCfTtw4oT63086hiRpON8uEwQkSQtYtysbaaFZvvZTQw+hmwcuPnPoIWiB88pGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuZhU2Sa6dTU2SpEn2+T2bJM8Fns/olTNH8623LR8JfE/nsUmSFoj9fanzPwLvYRQst/CtsPkK8MGO45IkLSD7DJuq+h3gd5K8q6p+d57GJElaYGb1upqq+t0kPwQsH9+mqq7oNC5J0gIyq7BJ8lHg+4DbgadauQDDRpK0X7N9EecUcEL7KQBJkg7IbL9ncxfw3T0HIklauGZ7ZXMMcE+Sm4Andher6i1dRiVJWlBmGza/2nMQkqSFbVa30arqzyd95nrQJP8pyd1J7kpyZZLnJjk+yY1J7kvy8SRHtL7PaevTrX352H4ubPXPJzl9rL6y1aaTrJ3rOCVJB8dsX1fzeJKvtM/XkzyV5CtzOWCSpcDPA1NVdSKwCDgH+HXgkqpaATwCnN82OR94pKq+H7ik9SPJCW27VwIrgQ8lWZRkEaMvnJ4BnACc2/pKkgYy2+/ZvHB8PclZwMnP8rjPS/L/GL0O52HgDcBPtvaNjG7dXQas4lu38a4Gfi9JWn1TVT0BfCHJ9NiYpqvq/jbWTa3vPc9ivJIOEwv157+H/unvOb31uar+iFE4zGXbvwX+K/BFRiHzGKNX4TxaVU+2bjPA0ra8FHiwbftk6/+S8foe2+yt/gxJ1iTZnmT7zp0753I6kqRZmO2XOn98bPU7GH3vZk7fuWkv9FwFHA88CvxPRre89rR7/9lL297qkwJ04lirah2wDmBqasrvEElSJ7Odjfavx5afBB5gFBhz8WPAF6pqJ0CSTwI/BByVZHG7elkGPNT6zwDHATNJFgMvAnaN1Xcb32ZvdUnSAGb7zObtB/GYXwROSfJ84P8CpwLbgeuAtwKbgNXANa3/5rZ+fWv/TFVVks3AHyT5LUZvpV4B3MToimdFkuOBv2U0iWD3syBJ0gBmOxttWZI/TLIjyZeSfCLJsrkcsKpuZPSg/1bgzjaGdcB7gV9oD/pfAqxvm6wHXtLqvwCsbfu5G7iK0YP/PwEuqKqn2pXRO4GtwL3AVa2vJGkgs72N9hHgD4Cz2/rbWu2NczloVV0EXLRH+X4mzHCrqq+PHXfPtg8AH5hQ3wJsmcvYJEkH32xnoy2pqo9U1ZPtczmwpOO4JEkLyGzD5stJ3rb7S5NJ3gb8fc+BSZIWjtmGzc8APwH8HaPvxrwVOJiTBiRJC9hsn9m8H1hdVY8AJHkxoy9m/kyvgUmSFo7ZXtm8anfQAFTVLuDVfYYkSVpoZhs239G++Q9888pmtldFkqTD3GwD478Bf5nkakavfvkJJkw5liRpktm+QeCKJNsZvXwzwI9XlW9RliTNyqxvhbVwMWAkSQdsTj8xIEnSgTBsJEndGTaSpO4MG0lSd4aNJKk7w0aS1J1hI0nqzrCRJHVn2EiSuhskbJIcleTqJH+V5N4kP5jkxUm2Jbmv/T269U2SS5NMJ7kjyUlj+1nd+t+XZPVY/TVJ7mzbXJokQ5ynJGlkqCub3wH+pKr+KfDPgXuBtcC1VbUCuLatA5wBrGifNcBl8M03T18EvA44Gbho7M3Ul7W+u7dbOQ/nJEnai3kPmyRHAj8MrAeoqm9U1aPAKmBj67YROKstrwKuqJEbgKOSHAucDmyrql3tt3a2AStb25FVdX1VFXDF2L4kSQMY4srme4GdwEeS3Jbkw0leALysqh4GaH9f2vovBR4c236m1fZVn5lQf4Yka5JsT7J9586dz/7MJEkTDRE2i4GTgMuq6tXAP/CtW2aTTHreUnOoP7NYta6qpqpqasmSJfsetSRpzoYImxlgpqpubOtXMwqfL7VbYLS/O8b6Hze2/TLgof3Ul02oS5IGMu9hU1V/BzyY5BWtdCqj38nZDOyeUbYauKYtbwbOa7PSTgEea7fZtgKnJTm6TQw4Ddja2h5PckqbhXbe2L4kSQOY9Y+nHWTvAj6W5AjgfuDtjILvqiTnA18Ezm59twBvAqaBr7W+VNWuJO8Hbm793ldVu9ryO4DLgecBn24fSdJABgmbqrodmJrQdOqEvgVcsJf9bAA2TKhvB058lsOUJB0kvkFAktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktTdYGGTZFGS25L8cVs/PsmNSe5L8vH2k9EkeU5bn27ty8f2cWGrfz7J6WP1la02nWTtfJ+bJOnphryyeTdw79j6rwOXVNUK4BHg/FY/H3ikqr4fuKT1I8kJwDnAK4GVwIdagC0CPgicAZwAnNv6SpIGMkjYJFkGnAl8uK0HeANwdeuyETirLa9q67T2U1v/VcCmqnqiqr4ATAMnt890Vd1fVd8ANrW+kqSBDHVl89vALwP/2NZfAjxaVU+29RlgaVteCjwI0Nofa/2/Wd9jm73VJUkDmfewSfJmYEdV3TJentC19tN2oPVJY1mTZHuS7Tt37tzHqCVJz8YQVzavB96S5AFGt7jewOhK56gki1ufZcBDbXkGOA6gtb8I2DVe32ObvdWfoarWVdVUVU0tWbLk2Z+ZJGmieQ+bqrqwqpZV1XJGD/g/U1U/BVwHvLV1Ww1c05Y3t3Va+2eqqlr9nDZb7XhgBXATcDOwos1uO6IdY/M8nJokaS8W77/LvHkvsCnJrwG3AetbfT3w0STTjK5ozgGoqruTXAXcAzwJXFBVTwEkeSewFVgEbKiqu+f1TCRJTzNo2FTVnwF/1pbvZzSTbM8+XwfO3sv2HwA+MKG+BdhyEIeqPSxf+6mhh9DNAxefOfQQpAXHNwhIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3Rk2kqTuDBtJUneGjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrozbCRJ3c172CQ5Lsl1Se5NcneSd7f6i5NsS3Jf+3t0qyfJpUmmk9yR5KSxfa1u/e9Lsnqs/pokd7ZtLk2S+T5PSdK3DHFl8yTwi1X1z4BTgAuSnACsBa6tqhXAtW0d4AxgRfusAS6DUTgBFwGvA04GLtodUK3PmrHtVs7DeUmS9mLew6aqHq6qW9vy48C9wFJgFbCxddsInNWWVwFX1MgNwFFJjgVOB7ZV1a6qegTYBqxsbUdW1fVVVcAVY/uSJA1g0Gc2SZYDrwZuBF5WVQ/DKJCAl7ZuS4EHxzababV91Wcm1CVJAxksbJJ8F/AJ4D1V9ZV9dZ1QqznUJ41hTZLtSbbv3Llzf0OWJM3RIGGT5DsZBc3HquqTrfyldguM9ndHq88Ax41tvgx4aD/1ZRPqz1BV66pqqqqmlixZ8uxOSpK0V0PMRguwHri3qn5rrGkzsHtG2WrgmrH6eW1W2inAY+0221bgtCRHt4kBpwFbW9vjSU5pxzpvbF+SpAEsHuCYrwd+Grgzye2t9p+Bi4GrkpwPfBE4u7VtAd4ETANfA94OUFW7krwfuLn1e19V7WrL7wAuB54HfLp9JEkDmfewqaq/YPJzFYBTJ/Qv4IK97GsDsGFCfTtw4rMYpiTpIPINApKk7gwbSVJ3QzyzWXCWr/3U0EPo5oGLzxx6CJIWAK9sJEndGTaSpO4MG0lSd4aNJKk7w0aS1J1hI0nqzrCRJHVn2EiSujNsJEndGTaSpO4MG0lSd4aNJKk7w0aS1J1hI0nqzrCRJHW3YMMmycokn08ynWTt0OORpMPZggybJIuADwJnACcA5yY5YdhRSdLha0GGDXAyMF1V91fVN4BNwKqBxyRJh62FGjZLgQfH1mdaTZI0gFTV0GM46JKcDZxeVf+hrf80cHJVvWuPfmuANW31FcDn53WgB8cxwJeHHsQ8OtzOFzznw8Whes7/pKqW7K/T4vkYyQBmgOPG1pcBD+3ZqarWAevma1A9JNleVVNDj2O+HG7nC57z4WKhn/NCvY12M7AiyfFJjgDOATYPPCZJOmwtyCubqnoyyTuBrcAiYENV3T3wsCTpsLUgwwagqrYAW4Yexzw4pG8DzsHhdr7gOR8uFvQ5L8gJApKkby8L9ZmNJOnbiGFziEqyIcmOJHcNPZb5kOS4JNcluTfJ3UnePfSYekvy3CQ3JflcO+f/MvSY5kuSRUluS/LHQ49lPiR5IMmdSW5Psn3o8fTgbbRDVJIfBr4KXFFVJw49nt6SHAscW1W3JnkhcAtwVlXdM/DQukkS4AVV9dUk3wn8BfDuqrph4KF1l+QXgCngyKp689Dj6S3JA8BUVR2K37OZFa9sDlFV9Vlg19DjmC9V9XBV3dqWHwfuZYG/FaJGvtpWv7N9Fvy/DpMsA84EPjz0WHTwGDY65CRZDrwauHHYkfTXbifdDuwAtlXVgj9n4LeBXwb+ceiBzKMC/jTJLe3NJguOYaNDSpLvAj4BvKeqvjL0eHqrqqeq6l8wegvGyUkW9C3TJG8GdlTVLUOPZZ69vqpOYvSm+gvabfIFxbDRIaM9t/gE8LGq+uTQ45lPVfUo8GfAyoGH0tvrgbe0ZxibgDck+R/DDqm/qnqo/d0B/CGjN9cvKIaNDgntYfl64N6q+q2hxzMfkixJclRbfh7wY8BfDTuqvqrqwqpaVlXLGb1m6jNV9baBh9VVkhe0SS8keQFwGrDgZpkaNoeoJFcC1wOvSDKT5Pyhx9TZ64GfZvQv3dvb501DD6qzY4HrktzB6H1/26rqsJgKfJh5GfAXST4H3AR8qqr+ZOAxHXROfZYkdeeVjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrozbKRvM0nek+T5Y+tbdn/fRjpUOfVZGkD7kmqq6hnv/zoc3gCsw49XNtI8SbK8/R7Ph4BbgfVJto//Vk2Snwe+h9GXOa9rtQeSHDO2/e+3bf60vVmAJK9NckeS65P85uHyO0c6dBg20vx6BaPfIHo18ItVNQW8CvhXSV5VVZcCDwE/WlU/OmH7FcAHq+qVwKPAv231jwA/W1U/CDzV/SykA2TYSPPrb8Z+/OwnktwK3Aa8EjhhFtt/oapub8u3AMvb85wXVtVftvofHNQRSwfB4qEHIB1m/gEgyfHALwGvrapHklwOPHcW2z8xtvwU8DwgB3uQ0sHmlY00jCMZBc9jSV7G6HdMdnsceOFsd1RVjwCPJzmllc45aKOUDhKvbKQBVNXnktwG3A3cD/zvseZ1wKeTPLyX5zaTnA/8fpJ/YPS7N48dzPFKz5ZTn6UFIMl3VdVX2/Ja4NiqevfAw5K+ySsbaWE4M8mFjP6f/hvg3w87HOnpvLKRJHXnBAFJUneGjSSpO8NGktSdYSNJ6s6wkSR1Z9hIkrr7/2AM9n3faAr0AAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x108e04da0>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# import matplotlib.pyplot as plt\n",
    "thresholds = [0,1,30,50,100,1000]\n",
    "for n in range(len(thresholds)-1):\n",
    "    upper = thresholds[n+1]\n",
    "    lower = thresholds[n]\n",
    "    print(f'rating distribution of reviews from users with {lower} to {upper} reviews written')\n",
    "#     upper_filter = review_df_with_count['review_count']>lower\n",
    "#     lower_filter = review_df_with_count['review_count']<=upper\n",
    "    reviews = list(review_df_with_count[\n",
    "        (review_df_with_count['review_count']>lower) & \\\n",
    "        (review_df_with_count['review_count']<=upper)]['stars'])\n",
    "    print(f'{len(reviews)} reviews in subset')\n",
    "    plt.hist(reviews,bins=[x+0.5 for x in range(6)],align='mid',width=0.9)\n",
    "    plt.xlabel('rating')\n",
    "    plt.ylabel('count')\n",
    "    plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/Maciel/anaconda/lib/python3.6/site-packages/ipykernel_launcher.py:7: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  import sys\n"
     ]
    }
   ],
   "source": [
    "upper = 100\n",
    "lower = 50\n",
    "reviews_50_100 = review_df_with_count[\n",
    "        (review_df_with_count['review_count']>lower) & \\\n",
    "        (review_df_with_count['review_count']<=upper)]\n",
    "reviews_50_100['word_count'] = reviews_50_100.text.apply(lambda x: len(str(x).split(' ')))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>stars</th>\n",
       "      <th>review_count</th>\n",
       "      <th>word_count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>323310.000000</td>\n",
       "      <td>323310.000000</td>\n",
       "      <td>323310.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>3.712227</td>\n",
       "      <td>71.869240</td>\n",
       "      <td>138.944632</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>1.131043</td>\n",
       "      <td>14.220856</td>\n",
       "      <td>112.224736</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>51.000000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>3.000000</td>\n",
       "      <td>59.000000</td>\n",
       "      <td>61.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>4.000000</td>\n",
       "      <td>70.000000</td>\n",
       "      <td>109.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>5.000000</td>\n",
       "      <td>83.000000</td>\n",
       "      <td>182.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>5.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>1124.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               stars   review_count     word_count\n",
       "count  323310.000000  323310.000000  323310.000000\n",
       "mean        3.712227      71.869240     138.944632\n",
       "std         1.131043      14.220856     112.224736\n",
       "min         1.000000      51.000000       1.000000\n",
       "25%         3.000000      59.000000      61.000000\n",
       "50%         4.000000      70.000000     109.000000\n",
       "75%         5.000000      83.000000     182.000000\n",
       "max         5.000000     100.000000    1124.000000"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "reviews_50_100.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>review_id</th>\n",
       "      <th>user_id</th>\n",
       "      <th>business_id</th>\n",
       "      <th>stars</th>\n",
       "      <th>text</th>\n",
       "      <th>date</th>\n",
       "      <th>review_count</th>\n",
       "      <th>word_count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>\"Brick House Tavern + Tap\"</td>\n",
       "      <td>ZflgoahrEd1_H0tWSATjQw</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>PfOCPjBrlQAnz__NXj9h_w</td>\n",
       "      <td>4</td>\n",
       "      <td>Eating on couches or lounging in comfy recline...</td>\n",
       "      <td>2016-02-27</td>\n",
       "      <td>57</td>\n",
       "      <td>127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224012</th>\n",
       "      <td>\"Whole Foods Market\"</td>\n",
       "      <td>JjJyUhnLtX5aZWVJfSeLKA</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>NFv21m2Czqz2XM5G4kpbKg</td>\n",
       "      <td>3</td>\n",
       "      <td>Convienent easy parking, though I had to avoid...</td>\n",
       "      <td>2016-12-27</td>\n",
       "      <td>57</td>\n",
       "      <td>128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>542595</th>\n",
       "      <td>\"Crave Cantina\"</td>\n",
       "      <td>hQu_gojfKPm8C0yovoszhQ</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>OFaMjL9nLF-A51KHNW8nfg</td>\n",
       "      <td>5</td>\n",
       "      <td>I usually go somewhere local twice before writ...</td>\n",
       "      <td>2017-07-01</td>\n",
       "      <td>57</td>\n",
       "      <td>190</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>550696</th>\n",
       "      <td>\"Newdle Bar\"</td>\n",
       "      <td>0n1w0w1VsRF4eqeqZHnX4g</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>XHK_1UM4CBZQ7RemDFr1mQ</td>\n",
       "      <td>3</td>\n",
       "      <td>Meh...don't come here if you are looking for a...</td>\n",
       "      <td>2016-08-11</td>\n",
       "      <td>57</td>\n",
       "      <td>98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>579958</th>\n",
       "      <td>\"Cornerstone Market &amp; Deli\"</td>\n",
       "      <td>PAldTKppEliQBy3M5vxtlg</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>eZ423jsTh3g9QTt2w-UTyg</td>\n",
       "      <td>5</td>\n",
       "      <td>This place is a gem...I was so glad they reope...</td>\n",
       "      <td>2016-08-17</td>\n",
       "      <td>57</td>\n",
       "      <td>106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>602268</th>\n",
       "      <td>\"Yum Yum Sweet Shop\"</td>\n",
       "      <td>r8ghBuwFFMybBGFcDVv6Ow</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>RaAF9t0_Epbov-1uHfDiXg</td>\n",
       "      <td>4</td>\n",
       "      <td>Step back in time and stay in the present all ...</td>\n",
       "      <td>2016-10-18</td>\n",
       "      <td>57</td>\n",
       "      <td>67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>662398</th>\n",
       "      <td>\"Kintaro Sushi &amp; Hot Pot\"</td>\n",
       "      <td>PTldCrPlj6FbJnekNNQLDQ</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>PJ8VJqsTdJno0beARzaTrQ</td>\n",
       "      <td>4</td>\n",
       "      <td>I have been twice for lunch hotpot and dinner ...</td>\n",
       "      <td>2017-02-21</td>\n",
       "      <td>57</td>\n",
       "      <td>121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>683087</th>\n",
       "      <td>\"PIZZAFIRE\"</td>\n",
       "      <td>I1NMsaLQXLQRFEJwkx2eQA</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>5m_xSthxwPoR-XvJvtTeNQ</td>\n",
       "      <td>5</td>\n",
       "      <td>This restaurant grows their own herbs and lett...</td>\n",
       "      <td>2016-02-24</td>\n",
       "      <td>57</td>\n",
       "      <td>114</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>710074</th>\n",
       "      <td>\"Lemongrass Grill\"</td>\n",
       "      <td>moFCqVwlzeUE4em5P0tynQ</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>06LmLcjFUb6b1HmhNllJZg</td>\n",
       "      <td>5</td>\n",
       "      <td>We will be back here really soon!\\n\\nOur servi...</td>\n",
       "      <td>2016-09-26</td>\n",
       "      <td>57</td>\n",
       "      <td>97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>832747</th>\n",
       "      <td>\"Bowl Of Pho\"</td>\n",
       "      <td>oEa4Csf_LjOQHiwRaYfuqg</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>zzSYBWuv_fXGtSgsO-6_1g</td>\n",
       "      <td>3</td>\n",
       "      <td>Came in due to recommendations and the large a...</td>\n",
       "      <td>2016-12-27</td>\n",
       "      <td>57</td>\n",
       "      <td>92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>964048</th>\n",
       "      <td>\"Outback Steakhouse\"</td>\n",
       "      <td>otCspYf4Vzo97zAuo-c3sg</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>Nz0MchMpTVYmJbijeBSVew</td>\n",
       "      <td>4</td>\n",
       "      <td>Always great, fast, attentive service.  Food i...</td>\n",
       "      <td>2015-06-20</td>\n",
       "      <td>57</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>981670</th>\n",
       "      <td>\"BT Bakery\"</td>\n",
       "      <td>n3DUEVDu2zbm4ewGS_eklg</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>_0XSZZrDCkgsnn_7gs6fEQ</td>\n",
       "      <td>4</td>\n",
       "      <td>We have been here several times and everything...</td>\n",
       "      <td>2017-10-07</td>\n",
       "      <td>57</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>987532</th>\n",
       "      <td>\"Popped\"</td>\n",
       "      <td>fPbWkOn2hhkNu8JvZcuEaA</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>jpBNyJI1eXPsO85gFKYJzA</td>\n",
       "      <td>5</td>\n",
       "      <td>The smell of caramel hits you when you walk in...</td>\n",
       "      <td>2017-09-13</td>\n",
       "      <td>57</td>\n",
       "      <td>105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1000675</th>\n",
       "      <td>\"Toko Japanese Steak House\"</td>\n",
       "      <td>bVpzB-6wfMz_easvZ-B9_A</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>9BQGpsIRhs9cRHuGh9xuJw</td>\n",
       "      <td>3</td>\n",
       "      <td>Preferred lunch vs dinner here...much better v...</td>\n",
       "      <td>2017-03-07</td>\n",
       "      <td>57</td>\n",
       "      <td>152</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1046533</th>\n",
       "      <td>\"Rays Place\"</td>\n",
       "      <td>aT_6C6KU64l87unF7z-j4Q</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>GdZ-Ryn9QzqV4glodYF6Jg</td>\n",
       "      <td>5</td>\n",
       "      <td>Great burgers...handsdown!  As a Kent Alumni--...</td>\n",
       "      <td>2016-01-03</td>\n",
       "      <td>57</td>\n",
       "      <td>67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1171377</th>\n",
       "      <td>\"Luke Wholey's Wild Alaskan Grille\"</td>\n",
       "      <td>3JTTBk-pg3mcWIyjy8UCkg</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>HG3ROmv3FJZTMJPpThSXOw</td>\n",
       "      <td>4</td>\n",
       "      <td>Wish I could give a 3.5. \\n\\nService: We waite...</td>\n",
       "      <td>2016-11-22</td>\n",
       "      <td>57</td>\n",
       "      <td>202</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1258604</th>\n",
       "      <td>\"Panera Bread\"</td>\n",
       "      <td>OiGZiZx2QE7Dgk3qS1stLQ</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>b-88Wiv8vNVrFxWX07KLng</td>\n",
       "      <td>3</td>\n",
       "      <td>What is there to say....its a Panera.  I do no...</td>\n",
       "      <td>2016-01-09</td>\n",
       "      <td>57</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1341340</th>\n",
       "      <td>\"BJ's Restaurant &amp; Brewhouse\"</td>\n",
       "      <td>1dJDr6nyEdyDCjV0d-qeXQ</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>hxedolqDRVlKA_iOoI09Ng</td>\n",
       "      <td>3</td>\n",
       "      <td>The parking here is very odd and scattered. Th...</td>\n",
       "      <td>2016-11-14</td>\n",
       "      <td>57</td>\n",
       "      <td>104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1366367</th>\n",
       "      <td>\"Earth Fare\"</td>\n",
       "      <td>0K57zqClL8x2LWn6-Ip0Yg</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>5rljvpskGd7xPTQC9v2peg</td>\n",
       "      <td>4</td>\n",
       "      <td>Pay attention to the sales and you can get som...</td>\n",
       "      <td>2015-09-11</td>\n",
       "      <td>57</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1380879</th>\n",
       "      <td>\"All City Candy\"</td>\n",
       "      <td>vLAg1X9pdNjF4ZOKfw5N0A</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>MFvUymU0mdNty4kBsUsw0w</td>\n",
       "      <td>5</td>\n",
       "      <td>What a fun store!  Tons of candy..old school a...</td>\n",
       "      <td>2016-10-25</td>\n",
       "      <td>57</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1419847</th>\n",
       "      <td>\"Coquette Patisserie\"</td>\n",
       "      <td>yiWr9pVDGzd_Hebl6ymkYw</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>OkLqpxpbvU2N2-OGDn0yiA</td>\n",
       "      <td>4</td>\n",
       "      <td>I wish I could give different ratings for diff...</td>\n",
       "      <td>2016-04-04</td>\n",
       "      <td>57</td>\n",
       "      <td>105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1520142</th>\n",
       "      <td>\"McDonald's\"</td>\n",
       "      <td>aK5D_tCCL0jjIKvqZzdY9w</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>GDylnjwPm2fcqT8FgG7gJg</td>\n",
       "      <td>5</td>\n",
       "      <td>I feel ridiculous giving a McDonalds a five st...</td>\n",
       "      <td>2017-02-06</td>\n",
       "      <td>57</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1538563</th>\n",
       "      <td>\"Applebee's Neighborhood Grill &amp; Bar\"</td>\n",
       "      <td>HhZ3qbGbnu6oU9ANvUb6vQ</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>B6Zjwindu_x2nB8VBkI1Ig</td>\n",
       "      <td>4</td>\n",
       "      <td>I had started to really stray from Applebees--...</td>\n",
       "      <td>2016-01-03</td>\n",
       "      <td>57</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1569125</th>\n",
       "      <td>\"Honey Hut\"</td>\n",
       "      <td>DvyHsEfhcmCSbL7a5LyQCg</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>8L_YZIrQ1Oa4aPY6lxegSQ</td>\n",
       "      <td>4</td>\n",
       "      <td>What a cute place! Don't let the small size fo...</td>\n",
       "      <td>2016-08-11</td>\n",
       "      <td>57</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1632618</th>\n",
       "      <td>\"Nautica Queen Cruise Ship\"</td>\n",
       "      <td>0ssCEWXSZX5OpaNLO9FpBw</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>dPIQurJHDMt1KDlXolNFhw</td>\n",
       "      <td>4</td>\n",
       "      <td>We went on the Father's Day brunch cruise.  \\n...</td>\n",
       "      <td>2016-06-22</td>\n",
       "      <td>57</td>\n",
       "      <td>139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1715597</th>\n",
       "      <td>\"Aladdin's Eatery\"</td>\n",
       "      <td>vnHlBA8pZ_zRFaXLsYP4Pw</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>hmIcYx04ulrt7FuNcNltsg</td>\n",
       "      <td>5</td>\n",
       "      <td>Very healthy, good wholesome food.  Love the B...</td>\n",
       "      <td>2015-10-01</td>\n",
       "      <td>57</td>\n",
       "      <td>59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1728547</th>\n",
       "      <td>\"La Terraza Bar &amp; Grill\"</td>\n",
       "      <td>Yk_slC3rNhyoTPqCegQgUQ</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>-fn65iT4z-nh1Ybfyajxng</td>\n",
       "      <td>2</td>\n",
       "      <td>This place use to be great but has really slip...</td>\n",
       "      <td>2016-08-22</td>\n",
       "      <td>57</td>\n",
       "      <td>112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1983393</th>\n",
       "      <td>\"Walmart Supercenter\"</td>\n",
       "      <td>m1WPZ9E6SIsIWlVP0A9myw</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>EcMJ-MmvKQ_pf4Is12v8bQ</td>\n",
       "      <td>1</td>\n",
       "      <td>A disorganized disaster!   Out of stock...not ...</td>\n",
       "      <td>2015-12-27</td>\n",
       "      <td>57</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2026083</th>\n",
       "      <td>\"Danny Boys\"</td>\n",
       "      <td>yWMXP9zLeEKAHjaWuL7HCw</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>TEvCRTMnOYwQ9Up9lWXxfA</td>\n",
       "      <td>3</td>\n",
       "      <td>Service was good, however, food times were rea...</td>\n",
       "      <td>2016-10-11</td>\n",
       "      <td>57</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2067592</th>\n",
       "      <td>\"Fresco Mexican Grill &amp; Salsa Bar\"</td>\n",
       "      <td>zeijASfr9VvQ3s7QIpsKTw</td>\n",
       "      <td>KgQnRvsPSrJJTOCp-reYZA</td>\n",
       "      <td>zSQs_cDOOyjnTHREy9yRfQ</td>\n",
       "      <td>5</td>\n",
       "      <td>Great, friendly, fast service.  Reasonable pri...</td>\n",
       "      <td>2015-05-24</td>\n",
       "      <td>57</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2045605</th>\n",
       "      <td>\"Ohjah Japanese Steakhouse Sushi &amp; Hibachi\"</td>\n",
       "      <td>8jqqnSK5ujWtnzbip-NEWw</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>sYfHxCqHpIX2HnDhw0JRAA</td>\n",
       "      <td>5</td>\n",
       "      <td>I'm never disappointed with food here, and as ...</td>\n",
       "      <td>2017-01-06</td>\n",
       "      <td>64</td>\n",
       "      <td>108</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2046628</th>\n",
       "      <td>\"SUSHISAMBA - Las Vegas\"</td>\n",
       "      <td>-YaX8V9TJD1UWER-eaWgrg</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>pH0BLkL4cbxKzu471VZnuA</td>\n",
       "      <td>4</td>\n",
       "      <td>I arrived being pushed in a wheelchair by my f...</td>\n",
       "      <td>2016-03-14</td>\n",
       "      <td>64</td>\n",
       "      <td>401</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2134373</th>\n",
       "      <td>\"Volcano Grille\"</td>\n",
       "      <td>k-lJQI8uuEkZrQ-wfaX0PQ</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>agGJSdMTRrkA6VrYMbC-SQ</td>\n",
       "      <td>5</td>\n",
       "      <td>I've been going to this place since they were ...</td>\n",
       "      <td>2017-04-28</td>\n",
       "      <td>64</td>\n",
       "      <td>141</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2158616</th>\n",
       "      <td>\"Osaka Summerlin\"</td>\n",
       "      <td>VOBdGezFsBkWX5jTRQOXpg</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>czx3G3V_f-4ZDg9YKJ0YQA</td>\n",
       "      <td>4</td>\n",
       "      <td>Groupon strikes again!!!!! This is a lot furth...</td>\n",
       "      <td>2015-12-17</td>\n",
       "      <td>64</td>\n",
       "      <td>246</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2170175</th>\n",
       "      <td>\"Claim Jumper\"</td>\n",
       "      <td>OquPCDxOn-kUY5Bz3y5xBg</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>7xXaO9deBDh_dd0JQjA-Qg</td>\n",
       "      <td>1</td>\n",
       "      <td>Two adults and two kids walk into Claim Jumper...</td>\n",
       "      <td>2015-11-13</td>\n",
       "      <td>64</td>\n",
       "      <td>355</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2227527</th>\n",
       "      <td>\"Topgolf\"</td>\n",
       "      <td>Ki-1GBlzf39B_jw-t57d2g</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>3Jq5LfJ5fmJ5KmuA6VHmzw</td>\n",
       "      <td>4</td>\n",
       "      <td>Now that I've been here a few times... I guess...</td>\n",
       "      <td>2016-11-18</td>\n",
       "      <td>64</td>\n",
       "      <td>189</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2367957</th>\n",
       "      <td>\"Lucille's Smokehouse Bar-B-Que\"</td>\n",
       "      <td>keVaIVN-rpAaUvFsJLOmMw</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>0ldxjei8v4q95fApIei3Lg</td>\n",
       "      <td>4</td>\n",
       "      <td>It's graduation season and we were starving af...</td>\n",
       "      <td>2016-06-18</td>\n",
       "      <td>64</td>\n",
       "      <td>337</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2377392</th>\n",
       "      <td>\"Bachi Burger\"</td>\n",
       "      <td>SM22SkZbzBz_925c-f_ktQ</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>7sPNbCx7vGAaH7SbNPZ6oA</td>\n",
       "      <td>5</td>\n",
       "      <td>Finally made it to Bachi! Surprisingly enough ...</td>\n",
       "      <td>2016-05-23</td>\n",
       "      <td>64</td>\n",
       "      <td>149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2430288</th>\n",
       "      <td>\"Fat Dumpling\"</td>\n",
       "      <td>Wmh3qq_YG-lwT61opVLCyQ</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>6z3cgIE9dJ01wUm43f0yBQ</td>\n",
       "      <td>5</td>\n",
       "      <td>Free delivery to the bar two stores down??? Yo...</td>\n",
       "      <td>2016-04-11</td>\n",
       "      <td>64</td>\n",
       "      <td>93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2446125</th>\n",
       "      <td>\"YuXiang Korean Chinese Cuisine\"</td>\n",
       "      <td>bn_V_rb_0N1rpxcv3Rimyw</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>qIRqFlmvHDRe7kWBAsuVnQ</td>\n",
       "      <td>4</td>\n",
       "      <td>I've ordered Togo before and was amazed enough...</td>\n",
       "      <td>2017-08-18</td>\n",
       "      <td>64</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2459666</th>\n",
       "      <td>\"Bacchanal Buffet\"</td>\n",
       "      <td>yerr-dS7WMHhIrO3p3e7hg</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>RESDUcs7fIiihp38-d6_6g</td>\n",
       "      <td>4</td>\n",
       "      <td>This place is insane!!!! I can't believe I've ...</td>\n",
       "      <td>2017-12-05</td>\n",
       "      <td>64</td>\n",
       "      <td>182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2466562</th>\n",
       "      <td>\"Prime\"</td>\n",
       "      <td>vuCSgh1_MOWViYvMkmu_MQ</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>SZEFE5hL7aN5nM-A44iPwQ</td>\n",
       "      <td>5</td>\n",
       "      <td>Good lord!!! We order sooo much food, we had t...</td>\n",
       "      <td>2016-01-26</td>\n",
       "      <td>64</td>\n",
       "      <td>354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2487992</th>\n",
       "      <td>\"Xo Chinese Food\"</td>\n",
       "      <td>GZwx4jA9gTPVf_BK1i0AHQ</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>fmVKBldrSIgFPKigYcu1Uw</td>\n",
       "      <td>5</td>\n",
       "      <td>I'm always a fan of their lunch special. When ...</td>\n",
       "      <td>2015-10-03</td>\n",
       "      <td>64</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2556174</th>\n",
       "      <td>\"Holsteins Shakes and Buns\"</td>\n",
       "      <td>s7eq9MdInuP9seiPgcScUQ</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>P7pxQFqr7yBKMMI2J51udw</td>\n",
       "      <td>4</td>\n",
       "      <td>When you're starving and want to watch the gam...</td>\n",
       "      <td>2016-05-30</td>\n",
       "      <td>64</td>\n",
       "      <td>213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2587678</th>\n",
       "      <td>\"Archi's Thai Bistro\"</td>\n",
       "      <td>yLy9A685dXwnGHivz5zZnA</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>ixAh9crILnJ9tM8LhWFhkw</td>\n",
       "      <td>5</td>\n",
       "      <td>Never disappointed with Archie's!!!! My favori...</td>\n",
       "      <td>2017-04-28</td>\n",
       "      <td>64</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2684474</th>\n",
       "      <td>\"Siamese Bistro\"</td>\n",
       "      <td>AUUhfibGHVTpdfY0FsLR-A</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>IQnUxhO7oieEP7-5ZVJ4uA</td>\n",
       "      <td>4</td>\n",
       "      <td>This place is under new ownership and a new na...</td>\n",
       "      <td>2016-11-19</td>\n",
       "      <td>64</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2808821</th>\n",
       "      <td>\"Sushi Tower &amp; Steakhouse\"</td>\n",
       "      <td>tbX3CHWW-fpozi1DpZ0MtQ</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>burnDlH36FSphvf4vQf10w</td>\n",
       "      <td>4</td>\n",
       "      <td>This was an impromptu lunch date with dad and ...</td>\n",
       "      <td>2016-05-23</td>\n",
       "      <td>64</td>\n",
       "      <td>113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2934103</th>\n",
       "      <td>\"Le Thai\"</td>\n",
       "      <td>TB5GM2CjLn7ZEdvU_jMvTA</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>-ed0Yc9on37RoIoG2ZgxBA</td>\n",
       "      <td>4</td>\n",
       "      <td>Great food, small space. We came for lunch and...</td>\n",
       "      <td>2016-07-16</td>\n",
       "      <td>64</td>\n",
       "      <td>112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2935441</th>\n",
       "      <td>\"Chronic Tacos\"</td>\n",
       "      <td>AYoY48h6BGV0RQO4mg6F_g</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>ZAqgv1gply0m_4fHAIffWA</td>\n",
       "      <td>3</td>\n",
       "      <td>If you accidentally make it to your movie with...</td>\n",
       "      <td>2016-05-17</td>\n",
       "      <td>64</td>\n",
       "      <td>220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2943731</th>\n",
       "      <td>\"TAO Asian Bistro\"</td>\n",
       "      <td>ubyt887mZWytwmemWoddtg</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>fQt4D34vcJNtEf8Q4zte3w</td>\n",
       "      <td>5</td>\n",
       "      <td>This is my 2nd time at Tao ... And it's better...</td>\n",
       "      <td>2015-09-25</td>\n",
       "      <td>64</td>\n",
       "      <td>131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3122275</th>\n",
       "      <td>\"Pin Kaow Thai\"</td>\n",
       "      <td>rwCjCXiUnntN2JiDZkHSPw</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>pybIuTluqRhH_BQ3CJHlLw</td>\n",
       "      <td>5</td>\n",
       "      <td>Came here for lunch and had the Shrimp Pad Tha...</td>\n",
       "      <td>2015-10-06</td>\n",
       "      <td>64</td>\n",
       "      <td>188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3161830</th>\n",
       "      <td>\"Raku\"</td>\n",
       "      <td>MDXCAq2HczFMEXHdhd13FQ</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>sqRX-XLlhx4rs2c1TpBf8A</td>\n",
       "      <td>3</td>\n",
       "      <td>Came here for a friend big 3-0 birthday dinner...</td>\n",
       "      <td>2017-01-06</td>\n",
       "      <td>64</td>\n",
       "      <td>158</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3264993</th>\n",
       "      <td>\"Herbs &amp; Rye\"</td>\n",
       "      <td>MOi0hrZ_I6rPEVTx0IL7-A</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>SAIrNOB4PtDA4gziNCucwg</td>\n",
       "      <td>5</td>\n",
       "      <td>Great reverse happy hour! An amazing local spo...</td>\n",
       "      <td>2015-12-01</td>\n",
       "      <td>64</td>\n",
       "      <td>189</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3363446</th>\n",
       "      <td>\"Geisha House Steak &amp; Sushi\"</td>\n",
       "      <td>WruZ1FBQmM0xjlorLwYgUQ</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>2pV-BNJvTL3f3EiMZlv6_w</td>\n",
       "      <td>5</td>\n",
       "      <td>Came in for lunch and ordered the 2 special ro...</td>\n",
       "      <td>2015-12-23</td>\n",
       "      <td>64</td>\n",
       "      <td>118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3417179</th>\n",
       "      <td>\"Showboy BakeShop\"</td>\n",
       "      <td>RBZti3lOCWxgTGbysHimnw</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>j32eLTYoQef2ehvUbxS1fg</td>\n",
       "      <td>5</td>\n",
       "      <td>This is the only place I will go to get a cust...</td>\n",
       "      <td>2015-10-16</td>\n",
       "      <td>64</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3429862</th>\n",
       "      <td>\"Ferraro's Italian Restaurant &amp; Wine Bar\"</td>\n",
       "      <td>T2dStTUnJFOQuYhJNvyEWg</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>DESv2ys6SjBKA4SyDtJvxw</td>\n",
       "      <td>5</td>\n",
       "      <td>Didn't even know this place existed, or its la...</td>\n",
       "      <td>2016-07-16</td>\n",
       "      <td>64</td>\n",
       "      <td>179</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3512281</th>\n",
       "      <td>\"Noodles\"</td>\n",
       "      <td>Te76lXMFbdMwdjZ_QUYTDQ</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>CCRgGKhzxSpl38w7yhqKUw</td>\n",
       "      <td>5</td>\n",
       "      <td>I don't how this place has so few stars. Maybe...</td>\n",
       "      <td>2016-06-18</td>\n",
       "      <td>64</td>\n",
       "      <td>122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3524364</th>\n",
       "      <td>\"Sushi House Goyemon\"</td>\n",
       "      <td>Lmu5cgFFAcDFxIA0w8WObA</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>JyxHvtj-syke7m9rbza7mA</td>\n",
       "      <td>5</td>\n",
       "      <td>This place is usually always packed and we luc...</td>\n",
       "      <td>2016-05-26</td>\n",
       "      <td>64</td>\n",
       "      <td>180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3564740</th>\n",
       "      <td>\"Yellowtail\"</td>\n",
       "      <td>cPp2sAxSF-4vfQqex5If5g</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>Dxaz8OxaadecnWol18kAtw</td>\n",
       "      <td>4</td>\n",
       "      <td>I've always loved yellowtail... Just not yello...</td>\n",
       "      <td>2015-12-17</td>\n",
       "      <td>64</td>\n",
       "      <td>256</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3627395</th>\n",
       "      <td>\"Sushi Neko\"</td>\n",
       "      <td>6OBNWpnPR87iBdca4ZtODA</td>\n",
       "      <td>a9UymHuKxZKMnHXOo3nLKA</td>\n",
       "      <td>ghVhlFpNhfBwWDFGSlt2JA</td>\n",
       "      <td>5</td>\n",
       "      <td>This has quickly became a favorite spot for me...</td>\n",
       "      <td>2017-07-26</td>\n",
       "      <td>64</td>\n",
       "      <td>71</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>323310 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                name               review_id  \\\n",
       "23                        \"Brick House Tavern + Tap\"  ZflgoahrEd1_H0tWSATjQw   \n",
       "224012                          \"Whole Foods Market\"  JjJyUhnLtX5aZWVJfSeLKA   \n",
       "542595                               \"Crave Cantina\"  hQu_gojfKPm8C0yovoszhQ   \n",
       "550696                                  \"Newdle Bar\"  0n1w0w1VsRF4eqeqZHnX4g   \n",
       "579958                   \"Cornerstone Market & Deli\"  PAldTKppEliQBy3M5vxtlg   \n",
       "602268                          \"Yum Yum Sweet Shop\"  r8ghBuwFFMybBGFcDVv6Ow   \n",
       "662398                     \"Kintaro Sushi & Hot Pot\"  PTldCrPlj6FbJnekNNQLDQ   \n",
       "683087                                   \"PIZZAFIRE\"  I1NMsaLQXLQRFEJwkx2eQA   \n",
       "710074                            \"Lemongrass Grill\"  moFCqVwlzeUE4em5P0tynQ   \n",
       "832747                                 \"Bowl Of Pho\"  oEa4Csf_LjOQHiwRaYfuqg   \n",
       "964048                          \"Outback Steakhouse\"  otCspYf4Vzo97zAuo-c3sg   \n",
       "981670                                   \"BT Bakery\"  n3DUEVDu2zbm4ewGS_eklg   \n",
       "987532                                      \"Popped\"  fPbWkOn2hhkNu8JvZcuEaA   \n",
       "1000675                  \"Toko Japanese Steak House\"  bVpzB-6wfMz_easvZ-B9_A   \n",
       "1046533                                 \"Rays Place\"  aT_6C6KU64l87unF7z-j4Q   \n",
       "1171377          \"Luke Wholey's Wild Alaskan Grille\"  3JTTBk-pg3mcWIyjy8UCkg   \n",
       "1258604                               \"Panera Bread\"  OiGZiZx2QE7Dgk3qS1stLQ   \n",
       "1341340                \"BJ's Restaurant & Brewhouse\"  1dJDr6nyEdyDCjV0d-qeXQ   \n",
       "1366367                                 \"Earth Fare\"  0K57zqClL8x2LWn6-Ip0Yg   \n",
       "1380879                             \"All City Candy\"  vLAg1X9pdNjF4ZOKfw5N0A   \n",
       "1419847                        \"Coquette Patisserie\"  yiWr9pVDGzd_Hebl6ymkYw   \n",
       "1520142                                 \"McDonald's\"  aK5D_tCCL0jjIKvqZzdY9w   \n",
       "1538563        \"Applebee's Neighborhood Grill & Bar\"  HhZ3qbGbnu6oU9ANvUb6vQ   \n",
       "1569125                                  \"Honey Hut\"  DvyHsEfhcmCSbL7a5LyQCg   \n",
       "1632618                  \"Nautica Queen Cruise Ship\"  0ssCEWXSZX5OpaNLO9FpBw   \n",
       "1715597                           \"Aladdin's Eatery\"  vnHlBA8pZ_zRFaXLsYP4Pw   \n",
       "1728547                     \"La Terraza Bar & Grill\"  Yk_slC3rNhyoTPqCegQgUQ   \n",
       "1983393                        \"Walmart Supercenter\"  m1WPZ9E6SIsIWlVP0A9myw   \n",
       "2026083                                 \"Danny Boys\"  yWMXP9zLeEKAHjaWuL7HCw   \n",
       "2067592           \"Fresco Mexican Grill & Salsa Bar\"  zeijASfr9VvQ3s7QIpsKTw   \n",
       "...                                              ...                     ...   \n",
       "2045605  \"Ohjah Japanese Steakhouse Sushi & Hibachi\"  8jqqnSK5ujWtnzbip-NEWw   \n",
       "2046628                     \"SUSHISAMBA - Las Vegas\"  -YaX8V9TJD1UWER-eaWgrg   \n",
       "2134373                             \"Volcano Grille\"  k-lJQI8uuEkZrQ-wfaX0PQ   \n",
       "2158616                            \"Osaka Summerlin\"  VOBdGezFsBkWX5jTRQOXpg   \n",
       "2170175                               \"Claim Jumper\"  OquPCDxOn-kUY5Bz3y5xBg   \n",
       "2227527                                    \"Topgolf\"  Ki-1GBlzf39B_jw-t57d2g   \n",
       "2367957             \"Lucille's Smokehouse Bar-B-Que\"  keVaIVN-rpAaUvFsJLOmMw   \n",
       "2377392                               \"Bachi Burger\"  SM22SkZbzBz_925c-f_ktQ   \n",
       "2430288                               \"Fat Dumpling\"  Wmh3qq_YG-lwT61opVLCyQ   \n",
       "2446125             \"YuXiang Korean Chinese Cuisine\"  bn_V_rb_0N1rpxcv3Rimyw   \n",
       "2459666                           \"Bacchanal Buffet\"  yerr-dS7WMHhIrO3p3e7hg   \n",
       "2466562                                      \"Prime\"  vuCSgh1_MOWViYvMkmu_MQ   \n",
       "2487992                            \"Xo Chinese Food\"  GZwx4jA9gTPVf_BK1i0AHQ   \n",
       "2556174                  \"Holsteins Shakes and Buns\"  s7eq9MdInuP9seiPgcScUQ   \n",
       "2587678                        \"Archi's Thai Bistro\"  yLy9A685dXwnGHivz5zZnA   \n",
       "2684474                             \"Siamese Bistro\"  AUUhfibGHVTpdfY0FsLR-A   \n",
       "2808821                   \"Sushi Tower & Steakhouse\"  tbX3CHWW-fpozi1DpZ0MtQ   \n",
       "2934103                                    \"Le Thai\"  TB5GM2CjLn7ZEdvU_jMvTA   \n",
       "2935441                              \"Chronic Tacos\"  AYoY48h6BGV0RQO4mg6F_g   \n",
       "2943731                           \"TAO Asian Bistro\"  ubyt887mZWytwmemWoddtg   \n",
       "3122275                              \"Pin Kaow Thai\"  rwCjCXiUnntN2JiDZkHSPw   \n",
       "3161830                                       \"Raku\"  MDXCAq2HczFMEXHdhd13FQ   \n",
       "3264993                                \"Herbs & Rye\"  MOi0hrZ_I6rPEVTx0IL7-A   \n",
       "3363446                 \"Geisha House Steak & Sushi\"  WruZ1FBQmM0xjlorLwYgUQ   \n",
       "3417179                           \"Showboy BakeShop\"  RBZti3lOCWxgTGbysHimnw   \n",
       "3429862    \"Ferraro's Italian Restaurant & Wine Bar\"  T2dStTUnJFOQuYhJNvyEWg   \n",
       "3512281                                    \"Noodles\"  Te76lXMFbdMwdjZ_QUYTDQ   \n",
       "3524364                        \"Sushi House Goyemon\"  Lmu5cgFFAcDFxIA0w8WObA   \n",
       "3564740                                 \"Yellowtail\"  cPp2sAxSF-4vfQqex5If5g   \n",
       "3627395                                 \"Sushi Neko\"  6OBNWpnPR87iBdca4ZtODA   \n",
       "\n",
       "                        user_id             business_id  stars  \\\n",
       "23       KgQnRvsPSrJJTOCp-reYZA  PfOCPjBrlQAnz__NXj9h_w      4   \n",
       "224012   KgQnRvsPSrJJTOCp-reYZA  NFv21m2Czqz2XM5G4kpbKg      3   \n",
       "542595   KgQnRvsPSrJJTOCp-reYZA  OFaMjL9nLF-A51KHNW8nfg      5   \n",
       "550696   KgQnRvsPSrJJTOCp-reYZA  XHK_1UM4CBZQ7RemDFr1mQ      3   \n",
       "579958   KgQnRvsPSrJJTOCp-reYZA  eZ423jsTh3g9QTt2w-UTyg      5   \n",
       "602268   KgQnRvsPSrJJTOCp-reYZA  RaAF9t0_Epbov-1uHfDiXg      4   \n",
       "662398   KgQnRvsPSrJJTOCp-reYZA  PJ8VJqsTdJno0beARzaTrQ      4   \n",
       "683087   KgQnRvsPSrJJTOCp-reYZA  5m_xSthxwPoR-XvJvtTeNQ      5   \n",
       "710074   KgQnRvsPSrJJTOCp-reYZA  06LmLcjFUb6b1HmhNllJZg      5   \n",
       "832747   KgQnRvsPSrJJTOCp-reYZA  zzSYBWuv_fXGtSgsO-6_1g      3   \n",
       "964048   KgQnRvsPSrJJTOCp-reYZA  Nz0MchMpTVYmJbijeBSVew      4   \n",
       "981670   KgQnRvsPSrJJTOCp-reYZA  _0XSZZrDCkgsnn_7gs6fEQ      4   \n",
       "987532   KgQnRvsPSrJJTOCp-reYZA  jpBNyJI1eXPsO85gFKYJzA      5   \n",
       "1000675  KgQnRvsPSrJJTOCp-reYZA  9BQGpsIRhs9cRHuGh9xuJw      3   \n",
       "1046533  KgQnRvsPSrJJTOCp-reYZA  GdZ-Ryn9QzqV4glodYF6Jg      5   \n",
       "1171377  KgQnRvsPSrJJTOCp-reYZA  HG3ROmv3FJZTMJPpThSXOw      4   \n",
       "1258604  KgQnRvsPSrJJTOCp-reYZA  b-88Wiv8vNVrFxWX07KLng      3   \n",
       "1341340  KgQnRvsPSrJJTOCp-reYZA  hxedolqDRVlKA_iOoI09Ng      3   \n",
       "1366367  KgQnRvsPSrJJTOCp-reYZA  5rljvpskGd7xPTQC9v2peg      4   \n",
       "1380879  KgQnRvsPSrJJTOCp-reYZA  MFvUymU0mdNty4kBsUsw0w      5   \n",
       "1419847  KgQnRvsPSrJJTOCp-reYZA  OkLqpxpbvU2N2-OGDn0yiA      4   \n",
       "1520142  KgQnRvsPSrJJTOCp-reYZA  GDylnjwPm2fcqT8FgG7gJg      5   \n",
       "1538563  KgQnRvsPSrJJTOCp-reYZA  B6Zjwindu_x2nB8VBkI1Ig      4   \n",
       "1569125  KgQnRvsPSrJJTOCp-reYZA  8L_YZIrQ1Oa4aPY6lxegSQ      4   \n",
       "1632618  KgQnRvsPSrJJTOCp-reYZA  dPIQurJHDMt1KDlXolNFhw      4   \n",
       "1715597  KgQnRvsPSrJJTOCp-reYZA  hmIcYx04ulrt7FuNcNltsg      5   \n",
       "1728547  KgQnRvsPSrJJTOCp-reYZA  -fn65iT4z-nh1Ybfyajxng      2   \n",
       "1983393  KgQnRvsPSrJJTOCp-reYZA  EcMJ-MmvKQ_pf4Is12v8bQ      1   \n",
       "2026083  KgQnRvsPSrJJTOCp-reYZA  TEvCRTMnOYwQ9Up9lWXxfA      3   \n",
       "2067592  KgQnRvsPSrJJTOCp-reYZA  zSQs_cDOOyjnTHREy9yRfQ      5   \n",
       "...                         ...                     ...    ...   \n",
       "2045605  a9UymHuKxZKMnHXOo3nLKA  sYfHxCqHpIX2HnDhw0JRAA      5   \n",
       "2046628  a9UymHuKxZKMnHXOo3nLKA  pH0BLkL4cbxKzu471VZnuA      4   \n",
       "2134373  a9UymHuKxZKMnHXOo3nLKA  agGJSdMTRrkA6VrYMbC-SQ      5   \n",
       "2158616  a9UymHuKxZKMnHXOo3nLKA  czx3G3V_f-4ZDg9YKJ0YQA      4   \n",
       "2170175  a9UymHuKxZKMnHXOo3nLKA  7xXaO9deBDh_dd0JQjA-Qg      1   \n",
       "2227527  a9UymHuKxZKMnHXOo3nLKA  3Jq5LfJ5fmJ5KmuA6VHmzw      4   \n",
       "2367957  a9UymHuKxZKMnHXOo3nLKA  0ldxjei8v4q95fApIei3Lg      4   \n",
       "2377392  a9UymHuKxZKMnHXOo3nLKA  7sPNbCx7vGAaH7SbNPZ6oA      5   \n",
       "2430288  a9UymHuKxZKMnHXOo3nLKA  6z3cgIE9dJ01wUm43f0yBQ      5   \n",
       "2446125  a9UymHuKxZKMnHXOo3nLKA  qIRqFlmvHDRe7kWBAsuVnQ      4   \n",
       "2459666  a9UymHuKxZKMnHXOo3nLKA  RESDUcs7fIiihp38-d6_6g      4   \n",
       "2466562  a9UymHuKxZKMnHXOo3nLKA  SZEFE5hL7aN5nM-A44iPwQ      5   \n",
       "2487992  a9UymHuKxZKMnHXOo3nLKA  fmVKBldrSIgFPKigYcu1Uw      5   \n",
       "2556174  a9UymHuKxZKMnHXOo3nLKA  P7pxQFqr7yBKMMI2J51udw      4   \n",
       "2587678  a9UymHuKxZKMnHXOo3nLKA  ixAh9crILnJ9tM8LhWFhkw      5   \n",
       "2684474  a9UymHuKxZKMnHXOo3nLKA  IQnUxhO7oieEP7-5ZVJ4uA      4   \n",
       "2808821  a9UymHuKxZKMnHXOo3nLKA  burnDlH36FSphvf4vQf10w      4   \n",
       "2934103  a9UymHuKxZKMnHXOo3nLKA  -ed0Yc9on37RoIoG2ZgxBA      4   \n",
       "2935441  a9UymHuKxZKMnHXOo3nLKA  ZAqgv1gply0m_4fHAIffWA      3   \n",
       "2943731  a9UymHuKxZKMnHXOo3nLKA  fQt4D34vcJNtEf8Q4zte3w      5   \n",
       "3122275  a9UymHuKxZKMnHXOo3nLKA  pybIuTluqRhH_BQ3CJHlLw      5   \n",
       "3161830  a9UymHuKxZKMnHXOo3nLKA  sqRX-XLlhx4rs2c1TpBf8A      3   \n",
       "3264993  a9UymHuKxZKMnHXOo3nLKA  SAIrNOB4PtDA4gziNCucwg      5   \n",
       "3363446  a9UymHuKxZKMnHXOo3nLKA  2pV-BNJvTL3f3EiMZlv6_w      5   \n",
       "3417179  a9UymHuKxZKMnHXOo3nLKA  j32eLTYoQef2ehvUbxS1fg      5   \n",
       "3429862  a9UymHuKxZKMnHXOo3nLKA  DESv2ys6SjBKA4SyDtJvxw      5   \n",
       "3512281  a9UymHuKxZKMnHXOo3nLKA  CCRgGKhzxSpl38w7yhqKUw      5   \n",
       "3524364  a9UymHuKxZKMnHXOo3nLKA  JyxHvtj-syke7m9rbza7mA      5   \n",
       "3564740  a9UymHuKxZKMnHXOo3nLKA  Dxaz8OxaadecnWol18kAtw      4   \n",
       "3627395  a9UymHuKxZKMnHXOo3nLKA  ghVhlFpNhfBwWDFGSlt2JA      5   \n",
       "\n",
       "                                                      text        date  \\\n",
       "23       Eating on couches or lounging in comfy recline...  2016-02-27   \n",
       "224012   Convienent easy parking, though I had to avoid...  2016-12-27   \n",
       "542595   I usually go somewhere local twice before writ...  2017-07-01   \n",
       "550696   Meh...don't come here if you are looking for a...  2016-08-11   \n",
       "579958   This place is a gem...I was so glad they reope...  2016-08-17   \n",
       "602268   Step back in time and stay in the present all ...  2016-10-18   \n",
       "662398   I have been twice for lunch hotpot and dinner ...  2017-02-21   \n",
       "683087   This restaurant grows their own herbs and lett...  2016-02-24   \n",
       "710074   We will be back here really soon!\\n\\nOur servi...  2016-09-26   \n",
       "832747   Came in due to recommendations and the large a...  2016-12-27   \n",
       "964048   Always great, fast, attentive service.  Food i...  2015-06-20   \n",
       "981670   We have been here several times and everything...  2017-10-07   \n",
       "987532   The smell of caramel hits you when you walk in...  2017-09-13   \n",
       "1000675  Preferred lunch vs dinner here...much better v...  2017-03-07   \n",
       "1046533  Great burgers...handsdown!  As a Kent Alumni--...  2016-01-03   \n",
       "1171377  Wish I could give a 3.5. \\n\\nService: We waite...  2016-11-22   \n",
       "1258604  What is there to say....its a Panera.  I do no...  2016-01-09   \n",
       "1341340  The parking here is very odd and scattered. Th...  2016-11-14   \n",
       "1366367  Pay attention to the sales and you can get som...  2015-09-11   \n",
       "1380879  What a fun store!  Tons of candy..old school a...  2016-10-25   \n",
       "1419847  I wish I could give different ratings for diff...  2016-04-04   \n",
       "1520142  I feel ridiculous giving a McDonalds a five st...  2017-02-06   \n",
       "1538563  I had started to really stray from Applebees--...  2016-01-03   \n",
       "1569125  What a cute place! Don't let the small size fo...  2016-08-11   \n",
       "1632618  We went on the Father's Day brunch cruise.  \\n...  2016-06-22   \n",
       "1715597  Very healthy, good wholesome food.  Love the B...  2015-10-01   \n",
       "1728547  This place use to be great but has really slip...  2016-08-22   \n",
       "1983393  A disorganized disaster!   Out of stock...not ...  2015-12-27   \n",
       "2026083  Service was good, however, food times were rea...  2016-10-11   \n",
       "2067592  Great, friendly, fast service.  Reasonable pri...  2015-05-24   \n",
       "...                                                    ...         ...   \n",
       "2045605  I'm never disappointed with food here, and as ...  2017-01-06   \n",
       "2046628  I arrived being pushed in a wheelchair by my f...  2016-03-14   \n",
       "2134373  I've been going to this place since they were ...  2017-04-28   \n",
       "2158616  Groupon strikes again!!!!! This is a lot furth...  2015-12-17   \n",
       "2170175  Two adults and two kids walk into Claim Jumper...  2015-11-13   \n",
       "2227527  Now that I've been here a few times... I guess...  2016-11-18   \n",
       "2367957  It's graduation season and we were starving af...  2016-06-18   \n",
       "2377392  Finally made it to Bachi! Surprisingly enough ...  2016-05-23   \n",
       "2430288  Free delivery to the bar two stores down??? Yo...  2016-04-11   \n",
       "2446125  I've ordered Togo before and was amazed enough...  2017-08-18   \n",
       "2459666  This place is insane!!!! I can't believe I've ...  2017-12-05   \n",
       "2466562  Good lord!!! We order sooo much food, we had t...  2016-01-26   \n",
       "2487992  I'm always a fan of their lunch special. When ...  2015-10-03   \n",
       "2556174  When you're starving and want to watch the gam...  2016-05-30   \n",
       "2587678  Never disappointed with Archie's!!!! My favori...  2017-04-28   \n",
       "2684474  This place is under new ownership and a new na...  2016-11-19   \n",
       "2808821  This was an impromptu lunch date with dad and ...  2016-05-23   \n",
       "2934103  Great food, small space. We came for lunch and...  2016-07-16   \n",
       "2935441  If you accidentally make it to your movie with...  2016-05-17   \n",
       "2943731  This is my 2nd time at Tao ... And it's better...  2015-09-25   \n",
       "3122275  Came here for lunch and had the Shrimp Pad Tha...  2015-10-06   \n",
       "3161830  Came here for a friend big 3-0 birthday dinner...  2017-01-06   \n",
       "3264993  Great reverse happy hour! An amazing local spo...  2015-12-01   \n",
       "3363446  Came in for lunch and ordered the 2 special ro...  2015-12-23   \n",
       "3417179  This is the only place I will go to get a cust...  2015-10-16   \n",
       "3429862  Didn't even know this place existed, or its la...  2016-07-16   \n",
       "3512281  I don't how this place has so few stars. Maybe...  2016-06-18   \n",
       "3524364  This place is usually always packed and we luc...  2016-05-26   \n",
       "3564740  I've always loved yellowtail... Just not yello...  2015-12-17   \n",
       "3627395  This has quickly became a favorite spot for me...  2017-07-26   \n",
       "\n",
       "         review_count  word_count  \n",
       "23                 57         127  \n",
       "224012             57         128  \n",
       "542595             57         190  \n",
       "550696             57          98  \n",
       "579958             57         106  \n",
       "602268             57          67  \n",
       "662398             57         121  \n",
       "683087             57         114  \n",
       "710074             57          97  \n",
       "832747             57          92  \n",
       "964048             57          41  \n",
       "981670             57          48  \n",
       "987532             57         105  \n",
       "1000675            57         152  \n",
       "1046533            57          67  \n",
       "1171377            57         202  \n",
       "1258604            57          80  \n",
       "1341340            57         104  \n",
       "1366367            57          52  \n",
       "1380879            57          44  \n",
       "1419847            57         105  \n",
       "1520142            57          37  \n",
       "1538563            57          53  \n",
       "1569125            57          72  \n",
       "1632618            57         139  \n",
       "1715597            57          59  \n",
       "1728547            57         112  \n",
       "1983393            57          29  \n",
       "2026083            57          83  \n",
       "2067592            57          38  \n",
       "...               ...         ...  \n",
       "2045605            64         108  \n",
       "2046628            64         401  \n",
       "2134373            64         141  \n",
       "2158616            64         246  \n",
       "2170175            64         355  \n",
       "2227527            64         189  \n",
       "2367957            64         337  \n",
       "2377392            64         149  \n",
       "2430288            64          93  \n",
       "2446125            64          56  \n",
       "2459666            64         182  \n",
       "2466562            64         354  \n",
       "2487992            64          29  \n",
       "2556174            64         213  \n",
       "2587678            64          54  \n",
       "2684474            64          32  \n",
       "2808821            64         113  \n",
       "2934103            64         112  \n",
       "2935441            64         220  \n",
       "2943731            64         131  \n",
       "3122275            64         188  \n",
       "3161830            64         158  \n",
       "3264993            64         189  \n",
       "3363446            64         118  \n",
       "3417179            64          80  \n",
       "3429862            64         179  \n",
       "3512281            64         122  \n",
       "3524364            64         180  \n",
       "3564740            64         256  \n",
       "3627395            64          71  \n",
       "\n",
       "[323310 rows x 9 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "reviews_50_100"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "reviews_50_100.to_csv('reviews_users_50-100.csv',index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "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.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}