web_scraping_ratings.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "from bs4 import BeautifulSoup\n",
    "import pandas as pd\n",
    "import re\n",
    "pd.set_option('display.max_rows', None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "url = 'https://www.diffordsguide.com/cocktails/search?style=14&sort=rating&limit=80&offset=0'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "b'<!DOCTYPE html>\\n<html lang=\"en\">\\n<head>\\n\\t<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">\\n\\t<meta name=\"viewport\" content=\"width=device-width\">\\n\\t<title>Search cocktails and cocktail Recipes with </title>\\n\\t<meta name=\"description\" content=\"From Dry Martini (5:1 ratio) Dickens Preferred to French 76, there\\'s all sorts of \\'Top 100 Best Known Cocktails\\' style drinks you can whip up on Difford\\'s Guide\">\\n\\t<meta name=\"keywords\" content=\"Cocktails with - A searchable library of over 3,000 easy to follow recipes, including the Mojito, Margarita, Old Fashioned and Daiquiri, and thousan'"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "html = requests.get(url).content\n",
    "html[0:600]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "soup = BeautifulSoup(html, \"lxml\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Dry Martini (5:1 ratio) Dickens Preferred',\n",
       " 'Negroni Cocktail',\n",
       " 'Penicillin cocktail',\n",
       " 'The Last Word cocktail',\n",
       " \"Benton's Old Fashioned\",\n",
       " \"Blood and Sand (Difford's recipe)\",\n",
       " 'Bradford Martini',\n",
       " 'Breakfast Martini',\n",
       " 'Caipirinha',\n",
       " 'Espresso Martini']"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cdict = {'class':'box__title'}\n",
    "table = soup.find_all('h3', cdict)\n",
    "rating_list = [table[i].contents[0] for i in range(len(table))]\n",
    "rating_list[:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Dry Martini (5:1 Ratio) Dickens Preferred',\n",
       " 'Negroni Cocktail',\n",
       " 'Penicillin Cocktail',\n",
       " 'The Last Word Cocktail',\n",
       " \"Benton'S Old Fashioned\",\n",
       " \"Blood And Sand (Difford'S Recipe)\",\n",
       " 'Bradford Martini',\n",
       " 'Breakfast Martini',\n",
       " 'Caipirinha',\n",
       " 'Espresso Martini']"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Capitalize each word to align spelling accross the dataset.\n",
    "\n",
    "rating_list = [rating_list[i].title() for i in range(len(rating_list))]\n",
    "rating_list[:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Dry Martini',\n",
       " 'Negroni',\n",
       " 'Penicillin',\n",
       " 'The Last Word',\n",
       " \"Benton'S Old Fashioned\",\n",
       " 'Blood And Sand',\n",
       " 'Bradford Martini',\n",
       " 'Breakfast Martini',\n",
       " 'Caipirinha',\n",
       " 'Espresso Martini']"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Remove word 'Cocktail' from the name.\n",
    "\n",
    "rating_list_clean = [re.sub(r'\\ *Cocktail', '', i) for i in rating_list]\n",
    "rating_list_clean = [re.sub(r'\\ *\\([^)]*\\)\\ *', '', i) for i in rating_list_clean]\n",
    "rating_list_clean[0] = 'Dry Martini'\n",
    "rating_list_clean[:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>0</th>\n",
       "      <th>1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Dry Martini (5:1 Ratio) Dickens Preferred</td>\n",
       "      <td>Dry Martini</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Negroni Cocktail</td>\n",
       "      <td>Negroni</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Penicillin Cocktail</td>\n",
       "      <td>Penicillin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>The Last Word Cocktail</td>\n",
       "      <td>The Last Word</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Benton'S Old Fashioned</td>\n",
       "      <td>Benton'S Old Fashioned</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Blood And Sand (Difford'S Recipe)</td>\n",
       "      <td>Blood And Sand</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Bradford Martini</td>\n",
       "      <td>Bradford Martini</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Breakfast Martini</td>\n",
       "      <td>Breakfast Martini</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Caipirinha</td>\n",
       "      <td>Caipirinha</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Espresso Martini</td>\n",
       "      <td>Espresso Martini</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>French 75 Cocktail</td>\n",
       "      <td>French 75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Garibaldi</td>\n",
       "      <td>Garibaldi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Honeysuckle Daiquiri</td>\n",
       "      <td>Honeysuckle Daiquiri</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Manhattan (Sweet)</td>\n",
       "      <td>Manhattan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Mint Julep Cocktail</td>\n",
       "      <td>Mint Julep</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Mojito Cocktail</td>\n",
       "      <td>Mojito</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Naked &amp; Famous</td>\n",
       "      <td>Naked &amp; Famous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Paper Plane</td>\n",
       "      <td>Paper Plane</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Ramos Gin Fizz</td>\n",
       "      <td>Ramos Gin Fizz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Sazerac Cocktail (Difford'S Recipe)</td>\n",
       "      <td>Sazerac</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Tommy'S Margarita</td>\n",
       "      <td>Tommy'S Margarita</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Vieux Carré Cocktail</td>\n",
       "      <td>Vieux Carré</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Whiskey Sour (Difford'S Recipe)</td>\n",
       "      <td>Whiskey Sour</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Zombie</td>\n",
       "      <td>Zombie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Amaretto Sour (By Jeffrey Morgenthaler)</td>\n",
       "      <td>Amaretto Sour</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Americano</td>\n",
       "      <td>Americano</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Aperol Spritz</td>\n",
       "      <td>Aperol Spritz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Army &amp; Navy</td>\n",
       "      <td>Army &amp; Navy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Aviation Cocktail (Difford'S Recipe)</td>\n",
       "      <td>Aviation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Bernice</td>\n",
       "      <td>Bernice</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Between The Sheets</td>\n",
       "      <td>Between The Sheets</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Bloody Mary (Modern Recipe)</td>\n",
       "      <td>Bloody Mary</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Blue Blazer</td>\n",
       "      <td>Blue Blazer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Bobby Burns Cocktail (Craddock'S Recipe)</td>\n",
       "      <td>Bobby Burns</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Boulevardier Cocktail</td>\n",
       "      <td>Boulevardier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Bramble</td>\n",
       "      <td>Bramble</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Brandy Alexander</td>\n",
       "      <td>Brandy Alexander</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Brandy Crusta</td>\n",
       "      <td>Brandy Crusta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Bronx</td>\n",
       "      <td>Bronx</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Brooklyn Cocktail</td>\n",
       "      <td>Brooklyn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Casino (The Savoy)</td>\n",
       "      <td>Casino</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Corpse Reviver No.2 (Savoy Recipe)</td>\n",
       "      <td>Corpse Reviver No.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Cosmopolitan Cocktail (Dale Degroff'S Recipe)</td>\n",
       "      <td>Cosmopolitan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Dirty Banana</td>\n",
       "      <td>Dirty Banana</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Fat Tire</td>\n",
       "      <td>Fat Tire</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Fish House Punch</td>\n",
       "      <td>Fish House Punch</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Fitzgerald</td>\n",
       "      <td>Fitzgerald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Fog Cutter</td>\n",
       "      <td>Fog Cutter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>French Martini</td>\n",
       "      <td>French Martini</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Gin &amp; It</td>\n",
       "      <td>Gin &amp; It</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Gin Basil Smash</td>\n",
       "      <td>Gin Basil Smash</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>Gin Sour</td>\n",
       "      <td>Gin Sour</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>Hanky Panky Cocktail</td>\n",
       "      <td>Hanky Panky</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Hemingway Special Daiquiri (Papa Doble)</td>\n",
       "      <td>Hemingway Special Daiquiri</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>Jack Rose Cocktail</td>\n",
       "      <td>Jack Rose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Mai Tai (Trader Vic'S) Cocktail</td>\n",
       "      <td>Mai Tai</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Mary Pickford Cocktail</td>\n",
       "      <td>Mary Pickford</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Mexican Mule</td>\n",
       "      <td>Mexican Mule</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Milano Torino (Mi-To) Cocktail</td>\n",
       "      <td>Milano Torino</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>Missionary'S Downfall</td>\n",
       "      <td>Missionary'S Downfall</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>New York Sour Cocktail</td>\n",
       "      <td>New York Sour</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>Nuclear Daiquiri</td>\n",
       "      <td>Nuclear Daiquiri</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>Old Cuban</td>\n",
       "      <td>Old Cuban</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>Paloma</td>\n",
       "      <td>Paloma</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>Pina Colada Cocktail (Puerto Rican Style)</td>\n",
       "      <td>Pina Colada</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Pink Tsipouro Fizz</td>\n",
       "      <td>Pink Tsipouro Fizz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>Porn Star Martini</td>\n",
       "      <td>Porn Star Martini</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>Russian Spring Punch</td>\n",
       "      <td>Russian Spring Punch</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>Sidecar Cocktail (Difford'S Spec.)</td>\n",
       "      <td>Sidecar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>Slow Comfortable Screw Against The Wall</td>\n",
       "      <td>Slow Comfortable Screw Against The Wall</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>Tequila Sour</td>\n",
       "      <td>Tequila Sour</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Whisky Mac</td>\n",
       "      <td>Whisky Mac</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>White Lady Cocktail</td>\n",
       "      <td>White Lady</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>White Negroni</td>\n",
       "      <td>White Negroni</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Alexander</td>\n",
       "      <td>Alexander</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Cantaritos</td>\n",
       "      <td>Cantaritos</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Charlie Chaplin Cocktail</td>\n",
       "      <td>Charlie Chaplin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>Elderflower Collins</td>\n",
       "      <td>Elderflower Collins</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Final Ward</td>\n",
       "      <td>Final Ward</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>French 76</td>\n",
       "      <td>French 76</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                0  \\\n",
       "0       Dry Martini (5:1 Ratio) Dickens Preferred   \n",
       "1                                Negroni Cocktail   \n",
       "2                             Penicillin Cocktail   \n",
       "3                          The Last Word Cocktail   \n",
       "4                          Benton'S Old Fashioned   \n",
       "5               Blood And Sand (Difford'S Recipe)   \n",
       "6                                Bradford Martini   \n",
       "7                               Breakfast Martini   \n",
       "8                                      Caipirinha   \n",
       "9                                Espresso Martini   \n",
       "10                             French 75 Cocktail   \n",
       "11                                      Garibaldi   \n",
       "12                           Honeysuckle Daiquiri   \n",
       "13                              Manhattan (Sweet)   \n",
       "14                            Mint Julep Cocktail   \n",
       "15                                Mojito Cocktail   \n",
       "16                                 Naked & Famous   \n",
       "17                                    Paper Plane   \n",
       "18                                 Ramos Gin Fizz   \n",
       "19            Sazerac Cocktail (Difford'S Recipe)   \n",
       "20                              Tommy'S Margarita   \n",
       "21                           Vieux Carré Cocktail   \n",
       "22                Whiskey Sour (Difford'S Recipe)   \n",
       "23                                         Zombie   \n",
       "24        Amaretto Sour (By Jeffrey Morgenthaler)   \n",
       "25                                      Americano   \n",
       "26                                  Aperol Spritz   \n",
       "27                                    Army & Navy   \n",
       "28           Aviation Cocktail (Difford'S Recipe)   \n",
       "29                                        Bernice   \n",
       "30                             Between The Sheets   \n",
       "31                    Bloody Mary (Modern Recipe)   \n",
       "32                                    Blue Blazer   \n",
       "33       Bobby Burns Cocktail (Craddock'S Recipe)   \n",
       "34                          Boulevardier Cocktail   \n",
       "35                                        Bramble   \n",
       "36                               Brandy Alexander   \n",
       "37                                  Brandy Crusta   \n",
       "38                                          Bronx   \n",
       "39                              Brooklyn Cocktail   \n",
       "40                             Casino (The Savoy)   \n",
       "41             Corpse Reviver No.2 (Savoy Recipe)   \n",
       "42  Cosmopolitan Cocktail (Dale Degroff'S Recipe)   \n",
       "43                                   Dirty Banana   \n",
       "44                                       Fat Tire   \n",
       "45                               Fish House Punch   \n",
       "46                                     Fitzgerald   \n",
       "47                                     Fog Cutter   \n",
       "48                                 French Martini   \n",
       "49                                       Gin & It   \n",
       "50                                Gin Basil Smash   \n",
       "51                                       Gin Sour   \n",
       "52                           Hanky Panky Cocktail   \n",
       "53        Hemingway Special Daiquiri (Papa Doble)   \n",
       "54                             Jack Rose Cocktail   \n",
       "55                Mai Tai (Trader Vic'S) Cocktail   \n",
       "56                         Mary Pickford Cocktail   \n",
       "57                                   Mexican Mule   \n",
       "58                 Milano Torino (Mi-To) Cocktail   \n",
       "59                          Missionary'S Downfall   \n",
       "60                         New York Sour Cocktail   \n",
       "61                               Nuclear Daiquiri   \n",
       "62                                      Old Cuban   \n",
       "63                                         Paloma   \n",
       "64      Pina Colada Cocktail (Puerto Rican Style)   \n",
       "65                             Pink Tsipouro Fizz   \n",
       "66                              Porn Star Martini   \n",
       "67                           Russian Spring Punch   \n",
       "68             Sidecar Cocktail (Difford'S Spec.)   \n",
       "69        Slow Comfortable Screw Against The Wall   \n",
       "70                                   Tequila Sour   \n",
       "71                                     Whisky Mac   \n",
       "72                            White Lady Cocktail   \n",
       "73                                  White Negroni   \n",
       "74                                      Alexander   \n",
       "75                                     Cantaritos   \n",
       "76                       Charlie Chaplin Cocktail   \n",
       "77                            Elderflower Collins   \n",
       "78                                     Final Ward   \n",
       "79                                      French 76   \n",
       "\n",
       "                                          1  \n",
       "0                               Dry Martini  \n",
       "1                                   Negroni  \n",
       "2                                Penicillin  \n",
       "3                             The Last Word  \n",
       "4                    Benton'S Old Fashioned  \n",
       "5                            Blood And Sand  \n",
       "6                          Bradford Martini  \n",
       "7                         Breakfast Martini  \n",
       "8                                Caipirinha  \n",
       "9                          Espresso Martini  \n",
       "10                                French 75  \n",
       "11                                Garibaldi  \n",
       "12                     Honeysuckle Daiquiri  \n",
       "13                                Manhattan  \n",
       "14                               Mint Julep  \n",
       "15                                   Mojito  \n",
       "16                           Naked & Famous  \n",
       "17                              Paper Plane  \n",
       "18                           Ramos Gin Fizz  \n",
       "19                                  Sazerac  \n",
       "20                        Tommy'S Margarita  \n",
       "21                              Vieux Carré  \n",
       "22                             Whiskey Sour  \n",
       "23                                   Zombie  \n",
       "24                            Amaretto Sour  \n",
       "25                                Americano  \n",
       "26                            Aperol Spritz  \n",
       "27                              Army & Navy  \n",
       "28                                 Aviation  \n",
       "29                                  Bernice  \n",
       "30                       Between The Sheets  \n",
       "31                              Bloody Mary  \n",
       "32                              Blue Blazer  \n",
       "33                              Bobby Burns  \n",
       "34                             Boulevardier  \n",
       "35                                  Bramble  \n",
       "36                         Brandy Alexander  \n",
       "37                            Brandy Crusta  \n",
       "38                                    Bronx  \n",
       "39                                 Brooklyn  \n",
       "40                                   Casino  \n",
       "41                      Corpse Reviver No.2  \n",
       "42                             Cosmopolitan  \n",
       "43                             Dirty Banana  \n",
       "44                                 Fat Tire  \n",
       "45                         Fish House Punch  \n",
       "46                               Fitzgerald  \n",
       "47                               Fog Cutter  \n",
       "48                           French Martini  \n",
       "49                                 Gin & It  \n",
       "50                          Gin Basil Smash  \n",
       "51                                 Gin Sour  \n",
       "52                              Hanky Panky  \n",
       "53               Hemingway Special Daiquiri  \n",
       "54                                Jack Rose  \n",
       "55                                  Mai Tai  \n",
       "56                            Mary Pickford  \n",
       "57                             Mexican Mule  \n",
       "58                            Milano Torino  \n",
       "59                    Missionary'S Downfall  \n",
       "60                            New York Sour  \n",
       "61                         Nuclear Daiquiri  \n",
       "62                                Old Cuban  \n",
       "63                                   Paloma  \n",
       "64                              Pina Colada  \n",
       "65                       Pink Tsipouro Fizz  \n",
       "66                        Porn Star Martini  \n",
       "67                     Russian Spring Punch  \n",
       "68                                  Sidecar  \n",
       "69  Slow Comfortable Screw Against The Wall  \n",
       "70                             Tequila Sour  \n",
       "71                               Whisky Mac  \n",
       "72                               White Lady  \n",
       "73                            White Negroni  \n",
       "74                                Alexander  \n",
       "75                               Cantaritos  \n",
       "76                          Charlie Chaplin  \n",
       "77                      Elderflower Collins  \n",
       "78                               Final Ward  \n",
       "79                                French 76  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Review of result. As 100 lines is not so many it worths to be reviewed manually.\n",
    "\n",
    "pd.DataFrame(zip(rating_list, rating_list_clean))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Rating</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Dry Martini</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Negroni</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Penicillin</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>The Last Word</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Benton'S Old Fashioned</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Name  Rating\n",
       "0             Dry Martini       0\n",
       "1                 Negroni       1\n",
       "2              Penicillin       2\n",
       "3           The Last Word       3\n",
       "4  Benton'S Old Fashioned       4"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame(rating_list_clean, columns=['Name'])\n",
    "df['Rating'] = df.index\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('.\\\\clean_data\\\\rating.csv')"
   ]
  }
 ],
 "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.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}