opentable (1).ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Scraping OpenTable"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "# import libraries\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import os\n",
    "from bs4 import BeautifulSoup\n",
    "import requests\n",
    "from datetime import datetime\n",
    "from datetime import timedelta "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "200\n"
     ]
    }
   ],
   "source": [
    "# accessing the website and pulling data\n",
    "url = 'https://www.opentable.com/r/american-son-washington'\n",
    "response = requests.get(url)\n",
    "print(response.status_code)\n",
    "page_tree = BeautifulSoup(response.content, 'html.parser')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<p class=\"_3fd7bece\"><span>Top Tags</span>: </p>"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "page_tree.main.div.p"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "divs = page_tree.main.div.find_all('div')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1098"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(divs)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "40\n"
     ]
    }
   ],
   "source": [
    "# getting all reviews\n",
    "all_reviews = []\n",
    "for review in page_tree.select('p[id*=\"review-body-\"]'):\n",
    "    all_reviews.append(review.get_text())\n",
    "    #print(review.get_text())\n",
    "    #print()\n",
    "print(len(all_reviews))\n",
    "#all_reviews"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[datetime.date(2021, 3, 10),\n",
       " datetime.date(2021, 2, 27),\n",
       " datetime.date(2021, 2, 22),\n",
       " datetime.date(2021, 2, 21),\n",
       " datetime.date(2021, 2, 20),\n",
       " datetime.date(2021, 2, 7),\n",
       " datetime.date(2021, 1, 30),\n",
       " datetime.date(2021, 1, 29),\n",
       " datetime.date(2020, 11, 26),\n",
       " datetime.date(2020, 11, 26),\n",
       " datetime.date(2020, 11, 16),\n",
       " datetime.date(2020, 10, 23),\n",
       " datetime.date(2020, 10, 11),\n",
       " datetime.date(2020, 10, 3),\n",
       " datetime.date(2020, 9, 26),\n",
       " datetime.date(2020, 9, 5),\n",
       " datetime.date(2020, 9, 5),\n",
       " datetime.date(2020, 8, 29),\n",
       " datetime.date(2020, 8, 29),\n",
       " datetime.date(2020, 8, 23),\n",
       " datetime.date(2020, 8, 23),\n",
       " datetime.date(2020, 8, 23),\n",
       " datetime.date(2020, 8, 22),\n",
       " datetime.date(2020, 3, 4),\n",
       " datetime.date(2020, 3, 3),\n",
       " datetime.date(2020, 2, 29),\n",
       " datetime.date(2020, 2, 28),\n",
       " datetime.date(2020, 2, 27),\n",
       " datetime.date(2020, 2, 25),\n",
       " datetime.date(2020, 2, 25),\n",
       " datetime.date(2020, 2, 22),\n",
       " datetime.date(2020, 2, 21),\n",
       " datetime.date(2020, 2, 17),\n",
       " datetime.date(2020, 2, 16),\n",
       " datetime.date(2020, 2, 16),\n",
       " datetime.date(2020, 2, 15),\n",
       " datetime.date(2020, 2, 15),\n",
       " datetime.date(2020, 2, 14),\n",
       " datetime.date(2020, 2, 14),\n",
       " datetime.date(2020, 2, 14)]"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# getting dates\n",
    "# referenced this site: https://www.dataquest.io/blog/python-datetime-tutorial/https://www.dataquest.io/blog/python-datetime-tutorial/\n",
    "all_dates_span = page_tree.find_all(\"span\", {\"class\": \"oc-reviews-47b8de40\"})\n",
    "all_dates = []\n",
    "for date in all_dates_span:\n",
    "    curr = date.get_text()\n",
    "    if 'on' in curr:\n",
    "        curr = curr[9:]\n",
    "        curr = datetime.strptime(curr, \"%B %d, %Y\")\n",
    "        # all_dates.append('' + str(curr.year) + '-' + str(curr.month) + '-' + str(curr.day))\n",
    "        #print(my_date.year)\n",
    "    else:\n",
    "        curr = curr[6:8]\n",
    "        curr = int(curr.strip())\n",
    "        now = datetime.now()\n",
    "        # curr_str = '' + str(curr) + str(now.month) + str(now.year) + ''\n",
    "        # curr_date = datetime.strptime(curr_str, \"%d%m%Y\")\n",
    "        curr = now - timedelta(days=curr+1)\n",
    "    all_dates.append(curr.date())\n",
    "all_dates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "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>review</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>The calamari dish was Luke warm despite the co...</td>\n",
       "      <td>2021-03-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Great staff, very accommodating. At one point ...</td>\n",
       "      <td>2021-02-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ambiance was great, trendy yet retro. Cute spo...</td>\n",
       "      <td>2021-02-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Food was average. The menu read a lot more \"in...</td>\n",
       "      <td>2021-02-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Food was not good. Not much options to pick from</td>\n",
       "      <td>2021-02-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Blah is the best word to describe the brunch d...</td>\n",
       "      <td>2021-02-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>The service was overall disappointing. Our ser...</td>\n",
       "      <td>2021-01-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>We waited 55 minutes for the first course to c...</td>\n",
       "      <td>2021-01-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>I would definitely come back again!!! Ms. Tiff...</td>\n",
       "      <td>2020-11-26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Such great service &amp; good covid precautions.</td>\n",
       "      <td>2020-11-26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Food was really salty, had to return it.</td>\n",
       "      <td>2020-11-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>A fine hotel restaurant with an interesting me...</td>\n",
       "      <td>2020-10-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Great little indoor/outdoor open dining for br...</td>\n",
       "      <td>2020-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Delicious brunch and great service! Ate outsid...</td>\n",
       "      <td>2020-10-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Extremely limited menu, food was tasty and coo...</td>\n",
       "      <td>2020-09-26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>The vibe was perfect and the staff was super n...</td>\n",
       "      <td>2020-09-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Good service, Good food, Despite bugs bite whe...</td>\n",
       "      <td>2020-09-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>My group &amp; I dined at American Son 3 times dur...</td>\n",
       "      <td>2020-08-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>The biggest issue here was that there is absol...</td>\n",
       "      <td>2020-08-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>The restaurant week brunch wasn’t really worth...</td>\n",
       "      <td>2020-08-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>American Son is definitely on my revisit list....</td>\n",
       "      <td>2020-08-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Love the place it was beautiful. The food wasn...</td>\n",
       "      <td>2020-08-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Great Restaurant Week Brunch menu.  Lots of ch...</td>\n",
       "      <td>2020-08-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Very hard to find, there is very little signag...</td>\n",
       "      <td>2020-03-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Slow service. Uninterested server. Food ok.</td>\n",
       "      <td>2020-03-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>On the day we went, they were booked for a pri...</td>\n",
       "      <td>2020-02-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>The food was overpriced for the quality and qu...</td>\n",
       "      <td>2020-02-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Very slow service.</td>\n",
       "      <td>2020-02-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>The Snapper was very good, as was the scallops...</td>\n",
       "      <td>2020-02-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Great place for a lunch.  Nice location, servi...</td>\n",
       "      <td>2020-02-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>I have been here 3 times and the service is co...</td>\n",
       "      <td>2020-02-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>My friend and I both thought our meals (scallo...</td>\n",
       "      <td>2020-02-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Went for dinner. Food was fine. Prices are high.</td>\n",
       "      <td>2020-02-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>The tables were too small to hold all of our f...</td>\n",
       "      <td>2020-02-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Hostess was friendly and welcoming. The manage...</td>\n",
       "      <td>2020-02-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>In town for the weekend</td>\n",
       "      <td>2020-02-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>The food was awesome. Very inventive cuisine.</td>\n",
       "      <td>2020-02-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Great Valentines Dinner!</td>\n",
       "      <td>2020-02-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Valentine’s Day meal with my significant other...</td>\n",
       "      <td>2020-02-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Food was cold, atmosphere cold, this is a hote...</td>\n",
       "      <td>2020-02-14</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               review        date\n",
       "0   The calamari dish was Luke warm despite the co...  2021-03-10\n",
       "1   Great staff, very accommodating. At one point ...  2021-02-27\n",
       "2   Ambiance was great, trendy yet retro. Cute spo...  2021-02-22\n",
       "3   Food was average. The menu read a lot more \"in...  2021-02-21\n",
       "4    Food was not good. Not much options to pick from  2021-02-20\n",
       "5   Blah is the best word to describe the brunch d...  2021-02-07\n",
       "6   The service was overall disappointing. Our ser...  2021-01-30\n",
       "7   We waited 55 minutes for the first course to c...  2021-01-29\n",
       "8   I would definitely come back again!!! Ms. Tiff...  2020-11-26\n",
       "9        Such great service & good covid precautions.  2020-11-26\n",
       "10           Food was really salty, had to return it.  2020-11-16\n",
       "11  A fine hotel restaurant with an interesting me...  2020-10-23\n",
       "12  Great little indoor/outdoor open dining for br...  2020-10-11\n",
       "13  Delicious brunch and great service! Ate outsid...  2020-10-03\n",
       "14  Extremely limited menu, food was tasty and coo...  2020-09-26\n",
       "15  The vibe was perfect and the staff was super n...  2020-09-05\n",
       "16  Good service, Good food, Despite bugs bite whe...  2020-09-05\n",
       "17  My group & I dined at American Son 3 times dur...  2020-08-29\n",
       "18  The biggest issue here was that there is absol...  2020-08-29\n",
       "19  The restaurant week brunch wasn’t really worth...  2020-08-23\n",
       "20  American Son is definitely on my revisit list....  2020-08-23\n",
       "21  Love the place it was beautiful. The food wasn...  2020-08-23\n",
       "22  Great Restaurant Week Brunch menu.  Lots of ch...  2020-08-22\n",
       "23  Very hard to find, there is very little signag...  2020-03-04\n",
       "24        Slow service. Uninterested server. Food ok.  2020-03-03\n",
       "25  On the day we went, they were booked for a pri...  2020-02-29\n",
       "26  The food was overpriced for the quality and qu...  2020-02-28\n",
       "27                                 Very slow service.  2020-02-27\n",
       "28  The Snapper was very good, as was the scallops...  2020-02-25\n",
       "29  Great place for a lunch.  Nice location, servi...  2020-02-25\n",
       "30  I have been here 3 times and the service is co...  2020-02-22\n",
       "31  My friend and I both thought our meals (scallo...  2020-02-21\n",
       "32   Went for dinner. Food was fine. Prices are high.  2020-02-17\n",
       "33  The tables were too small to hold all of our f...  2020-02-16\n",
       "34  Hostess was friendly and welcoming. The manage...  2020-02-16\n",
       "35                            In town for the weekend  2020-02-15\n",
       "36      The food was awesome. Very inventive cuisine.  2020-02-15\n",
       "37                           Great Valentines Dinner!  2020-02-14\n",
       "38  Valentine’s Day meal with my significant other...  2020-02-14\n",
       "39  Food was cold, atmosphere cold, this is a hote...  2020-02-14"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "review_df = pd.DataFrame(all_reviews, columns = ['review']) \n",
    "review_df['date'] = all_dates\n",
    "review_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [],
   "source": [
    "# getting the all the ratings seperatly\n",
    "all_r = page_tree.find_all(\"div\", {\"class\": \"oc-reviews-0d90fee7\"})\n",
    "overall = []\n",
    "food = []\n",
    "service = []\n",
    "ambiance = []\n",
    "for r in all_r:\n",
    "    all_span_r = r.find_all('span', {'class': 'oc-reviews-e3e61235'})\n",
    "    total = 0\n",
    "    i = 0\n",
    "    for sr in all_span_r:\n",
    "        num = int(sr.get_text())\n",
    "        if i == 0:\n",
    "            overall.append(num)\n",
    "        elif i == 1:\n",
    "            food.append(num)\n",
    "        elif i == 2:\n",
    "            service.append(num)\n",
    "        else:\n",
    "            ambiance.append(num)\n",
    "        i += 1\n",
    "        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "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>review</th>\n",
       "      <th>date</th>\n",
       "      <th>overall_rating</th>\n",
       "      <th>food_rating</th>\n",
       "      <th>service_rating</th>\n",
       "      <th>ambiance_rating</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>The calamari dish was Luke warm despite the co...</td>\n",
       "      <td>2021-03-10</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Great staff, very accommodating. At one point ...</td>\n",
       "      <td>2021-02-27</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ambiance was great, trendy yet retro. Cute spo...</td>\n",
       "      <td>2021-02-22</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Food was average. The menu read a lot more \"in...</td>\n",
       "      <td>2021-02-21</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Food was not good. Not much options to pick from</td>\n",
       "      <td>2021-02-20</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Blah is the best word to describe the brunch d...</td>\n",
       "      <td>2021-02-07</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>The service was overall disappointing. Our ser...</td>\n",
       "      <td>2021-01-30</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>We waited 55 minutes for the first course to c...</td>\n",
       "      <td>2021-01-29</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>I would definitely come back again!!! Ms. Tiff...</td>\n",
       "      <td>2020-11-26</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Such great service &amp; good covid precautions.</td>\n",
       "      <td>2020-11-26</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Food was really salty, had to return it.</td>\n",
       "      <td>2020-11-16</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>A fine hotel restaurant with an interesting me...</td>\n",
       "      <td>2020-10-23</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Great little indoor/outdoor open dining for br...</td>\n",
       "      <td>2020-10-11</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Delicious brunch and great service! Ate outsid...</td>\n",
       "      <td>2020-10-03</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Extremely limited menu, food was tasty and coo...</td>\n",
       "      <td>2020-09-26</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>The vibe was perfect and the staff was super n...</td>\n",
       "      <td>2020-09-05</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Good service, Good food, Despite bugs bite whe...</td>\n",
       "      <td>2020-09-05</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>My group &amp; I dined at American Son 3 times dur...</td>\n",
       "      <td>2020-08-29</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>The biggest issue here was that there is absol...</td>\n",
       "      <td>2020-08-29</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>The restaurant week brunch wasn’t really worth...</td>\n",
       "      <td>2020-08-23</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>American Son is definitely on my revisit list....</td>\n",
       "      <td>2020-08-23</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Love the place it was beautiful. The food wasn...</td>\n",
       "      <td>2020-08-23</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Great Restaurant Week Brunch menu.  Lots of ch...</td>\n",
       "      <td>2020-08-22</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Very hard to find, there is very little signag...</td>\n",
       "      <td>2020-03-04</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Slow service. Uninterested server. Food ok.</td>\n",
       "      <td>2020-03-03</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>On the day we went, they were booked for a pri...</td>\n",
       "      <td>2020-02-29</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>The food was overpriced for the quality and qu...</td>\n",
       "      <td>2020-02-28</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Very slow service.</td>\n",
       "      <td>2020-02-27</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>The Snapper was very good, as was the scallops...</td>\n",
       "      <td>2020-02-25</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Great place for a lunch.  Nice location, servi...</td>\n",
       "      <td>2020-02-25</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>I have been here 3 times and the service is co...</td>\n",
       "      <td>2020-02-22</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>My friend and I both thought our meals (scallo...</td>\n",
       "      <td>2020-02-21</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Went for dinner. Food was fine. Prices are high.</td>\n",
       "      <td>2020-02-17</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>The tables were too small to hold all of our f...</td>\n",
       "      <td>2020-02-16</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Hostess was friendly and welcoming. The manage...</td>\n",
       "      <td>2020-02-16</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>In town for the weekend</td>\n",
       "      <td>2020-02-15</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>The food was awesome. Very inventive cuisine.</td>\n",
       "      <td>2020-02-15</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Great Valentines Dinner!</td>\n",
       "      <td>2020-02-14</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Valentine’s Day meal with my significant other...</td>\n",
       "      <td>2020-02-14</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Food was cold, atmosphere cold, this is a hote...</td>\n",
       "      <td>2020-02-14</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               review        date  \\\n",
       "0   The calamari dish was Luke warm despite the co...  2021-03-10   \n",
       "1   Great staff, very accommodating. At one point ...  2021-02-27   \n",
       "2   Ambiance was great, trendy yet retro. Cute spo...  2021-02-22   \n",
       "3   Food was average. The menu read a lot more \"in...  2021-02-21   \n",
       "4    Food was not good. Not much options to pick from  2021-02-20   \n",
       "5   Blah is the best word to describe the brunch d...  2021-02-07   \n",
       "6   The service was overall disappointing. Our ser...  2021-01-30   \n",
       "7   We waited 55 minutes for the first course to c...  2021-01-29   \n",
       "8   I would definitely come back again!!! Ms. Tiff...  2020-11-26   \n",
       "9        Such great service & good covid precautions.  2020-11-26   \n",
       "10           Food was really salty, had to return it.  2020-11-16   \n",
       "11  A fine hotel restaurant with an interesting me...  2020-10-23   \n",
       "12  Great little indoor/outdoor open dining for br...  2020-10-11   \n",
       "13  Delicious brunch and great service! Ate outsid...  2020-10-03   \n",
       "14  Extremely limited menu, food was tasty and coo...  2020-09-26   \n",
       "15  The vibe was perfect and the staff was super n...  2020-09-05   \n",
       "16  Good service, Good food, Despite bugs bite whe...  2020-09-05   \n",
       "17  My group & I dined at American Son 3 times dur...  2020-08-29   \n",
       "18  The biggest issue here was that there is absol...  2020-08-29   \n",
       "19  The restaurant week brunch wasn’t really worth...  2020-08-23   \n",
       "20  American Son is definitely on my revisit list....  2020-08-23   \n",
       "21  Love the place it was beautiful. The food wasn...  2020-08-23   \n",
       "22  Great Restaurant Week Brunch menu.  Lots of ch...  2020-08-22   \n",
       "23  Very hard to find, there is very little signag...  2020-03-04   \n",
       "24        Slow service. Uninterested server. Food ok.  2020-03-03   \n",
       "25  On the day we went, they were booked for a pri...  2020-02-29   \n",
       "26  The food was overpriced for the quality and qu...  2020-02-28   \n",
       "27                                 Very slow service.  2020-02-27   \n",
       "28  The Snapper was very good, as was the scallops...  2020-02-25   \n",
       "29  Great place for a lunch.  Nice location, servi...  2020-02-25   \n",
       "30  I have been here 3 times and the service is co...  2020-02-22   \n",
       "31  My friend and I both thought our meals (scallo...  2020-02-21   \n",
       "32   Went for dinner. Food was fine. Prices are high.  2020-02-17   \n",
       "33  The tables were too small to hold all of our f...  2020-02-16   \n",
       "34  Hostess was friendly and welcoming. The manage...  2020-02-16   \n",
       "35                            In town for the weekend  2020-02-15   \n",
       "36      The food was awesome. Very inventive cuisine.  2020-02-15   \n",
       "37                           Great Valentines Dinner!  2020-02-14   \n",
       "38  Valentine’s Day meal with my significant other...  2020-02-14   \n",
       "39  Food was cold, atmosphere cold, this is a hote...  2020-02-14   \n",
       "\n",
       "    overall_rating  food_rating  service_rating  ambiance_rating  \n",
       "0                3            3               3                5  \n",
       "1                5            5               5                5  \n",
       "2                5            5               5                5  \n",
       "3                3            3               3                4  \n",
       "4                1            1               4                3  \n",
       "5                3            2               3                5  \n",
       "6                1            1               1                4  \n",
       "7                1            3               1                1  \n",
       "8                5            5               5                5  \n",
       "9                5            5               5                5  \n",
       "10               2            1               4                3  \n",
       "11               4            4               4                4  \n",
       "12               5            5               4                5  \n",
       "13               5            5               5                5  \n",
       "14               3            3               3                3  \n",
       "15               5            5               5                5  \n",
       "16               5            5               5                5  \n",
       "17               5            4               5                5  \n",
       "18               3            4               4                2  \n",
       "19               3            2               4                4  \n",
       "20               4            4               5                4  \n",
       "21               4            3               5                5  \n",
       "22               5            5               5                5  \n",
       "23               3            4               4                3  \n",
       "24               3            3               2                3  \n",
       "25               4            5               3                5  \n",
       "26               3            2               4                4  \n",
       "27               4            4               3                2  \n",
       "28               5            5               5                5  \n",
       "29               5            5               4                4  \n",
       "30               2            4               1                4  \n",
       "31               2            1               3                2  \n",
       "32               3            3               3                3  \n",
       "33               3            5               2                3  \n",
       "34               5            5               5                5  \n",
       "35               5            5               5                5  \n",
       "36               5            5               5                5  \n",
       "37               5            5               5                5  \n",
       "38               4            3               5                5  \n",
       "39               1            1               2                1  "
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# adding all review columns to the dataset\n",
    "review_df['overall_rating'] = overall\n",
    "review_df['food_rating'] = food\n",
    "review_df['service_rating'] = service\n",
    "review_df['ambiance_rating'] = ambiance\n",
    "review_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [],
   "source": [
    "opentable_reviewss = review_df.to_csv('opentable_reviews.csv')"
   ]
  },
  {
   "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.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}