Standard and VADER Sentiment Analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import nltk\n",
    "import pandas as pd\n",
    "from vaderSentiment.vaderSentiment import SentimentIntensityAnalyzer\n",
    "import re\n",
    "import string"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "#load top_10k_mallet.csv with sub topics\n",
    "lda_mallet = pd.read_csv('top_10k_mallet.csv')\n",
    "#load english dataset with around 10k rows\n",
    "top_10k = pd.read_csv('top10k_en.csv')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 118,
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "#Standard Sentiment Analysis\n",
    "\n",
    "#load pos_lexicon and neg_lexicon for standard sentiment analysis\n",
    "pos_lexicon = 'positive-words.txt'\n",
    "neg_lexicon = 'negative-words.txt'\n",
    "\n",
    "#subset the required columns\n",
    "top_10k_standard = top_10k.loc[:, ['name','business_id', 'text']]\n",
    "\n",
    "#split the reviews into texts by space\n",
    "top_10k_standard['text_sep'] = top_10k_standard['text'].map(lambda x:x.split())\n",
    "\n",
    "#create sentiment lexicons\n",
    "def create_dictionary(path):\n",
    " \n",
    "    dictionary = {}\n",
    "    f = open(path, 'r', encoding = \"ISO-8859-1\")\n",
    "    for line in f:\n",
    "        line = line.strip()\n",
    "        dictionary[line] = 1\n",
    "\n",
    "    f.close()\n",
    "    return dictionary\n",
    "    \n",
    "\n",
    "\n",
    "#calculate sentiment score\n",
    "def sentiment_score(dictionary):\n",
    "\n",
    "    score = top_10k_standard['text_sep'].map(lambda row: list(map(lambda x: 1 if x in dictionary else 0, row)))\n",
    "    score_list = []\n",
    "\n",
    "    for row in score:\n",
    "        score_list.append(sum(row))\n",
    "        \n",
    "    score_df = pd.DataFrame(score_list)\n",
    "    return score_df\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#create positive and negative lexicons \n",
    "pos_dict = create_dictionary(pos_lexicon)\n",
    "neg_dict = create_dictionary(neg_lexicon)\n",
    "\n",
    "#calculate sentiment score for each review\n",
    "top_10k_standard['pos_score'] = sentiment_score(pos_dict)\n",
    "top_10k_standard['neg_score'] = sentiment_score(neg_dict)\n",
    "\n",
    "#normalize the score to 0-5\n",
    "top_10k_standard['topic_score'] = top_10k_standard['pos_score'] / (top_10k_standard['pos_score'] + abs(top_10k_standard['neg_score']))*5\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 126,
   "metadata": {
    "scrolled": false
   },
   "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></th>\n",
       "      <th>topic_score</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>name</th>\n",
       "      <th>topic</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"Banh Mi Boys\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>3.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"Basil Thai Kitchen\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>1.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>2.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>2.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>3.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>2.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"Black Hoof\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>3.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>3.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"Bonjour Brioche\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>2.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>3.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>3.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>3.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>3.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"Brassaii\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>3.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>4.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>3.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>3.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"Chino Locos Original\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>3.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>3.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>3.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>3.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"Ciao Wine Bar\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>3.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>3.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">\"Circus Coffee House\"</th>\n",
       "      <th>Food</th>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>1.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"District\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>3.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>3.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>1.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>3.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>2.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">\"Eggspectation Resto-Cafe\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>2.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>3.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">\"Elegance Chinese Cuisine &amp; Banquet\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>2.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>3.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">\"Schwartz's\"</th>\n",
       "      <th>Service</th>\n",
       "      <td>2.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>3.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"Spuntini Restaurant &amp; Bar\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>3.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>2.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>3.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>3.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"Sumo Ramen\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>3.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>2.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>3.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>3.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>2.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"Sun's Kitchen\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>1.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>3.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>3.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>2.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"The Burger's Priest\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>2.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>2.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>3.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"The Sister\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>2.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>4.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>3.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>3.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">\"The Works Gourmet Burger Bistro\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>2.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>3.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>2.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>3.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"Tuck Shop\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>3.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>2.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"Wasabi Japanese Buffet\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>2.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>3.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>2.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>4.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>3.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">\"Wilensky's\"</th>\n",
       "      <th>Food</th>\n",
       "      <td>3.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>2.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>2.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>1.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"WonderPho\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>3.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>3.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>3.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>234 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   topic_score\n",
       "name                                 topic                    \n",
       "\"Banh Mi Boys\"                       Atmosphere            4.0\n",
       "                                     Food                  3.9\n",
       "                                     Price                 3.5\n",
       "                                     Service               3.9\n",
       "                                     Waiting time          3.7\n",
       "\"Basil Thai Kitchen\"                 Atmosphere            1.7\n",
       "                                     Food                  2.5\n",
       "                                     Price                 2.9\n",
       "                                     Service               3.6\n",
       "                                     Waiting time          2.2\n",
       "\"Black Hoof\"                         Atmosphere            3.9\n",
       "                                     Food                  3.9\n",
       "                                     Price                 3.8\n",
       "                                     Service               4.0\n",
       "                                     Waiting time          3.8\n",
       "\"Bonjour Brioche\"                    Atmosphere            2.9\n",
       "                                     Food                  3.5\n",
       "                                     Price                 3.8\n",
       "                                     Service               3.1\n",
       "                                     Waiting time          3.3\n",
       "\"Brassaii\"                           Atmosphere            3.6\n",
       "                                     Food                  4.1\n",
       "                                     Price                 3.1\n",
       "                                     Service               3.8\n",
       "                                     Waiting time          3.9\n",
       "\"Chino Locos Original\"               Atmosphere            3.6\n",
       "                                     Food                  3.6\n",
       "                                     Price                 3.4\n",
       "                                     Service               3.6\n",
       "                                     Waiting time          3.7\n",
       "\"Ciao Wine Bar\"                      Atmosphere            3.0\n",
       "                                     Food                  3.4\n",
       "                                     Price                 4.0\n",
       "                                     Service               3.8\n",
       "                                     Waiting time          3.7\n",
       "\"Circus Coffee House\"                Food                  3.7\n",
       "                                     Service               1.7\n",
       "\"District\"                           Atmosphere            3.4\n",
       "                                     Food                  3.6\n",
       "                                     Price                 1.5\n",
       "                                     Service               3.5\n",
       "                                     Waiting time          2.9\n",
       "\"Eggspectation Resto-Cafe\"           Atmosphere            2.2\n",
       "                                     Food                  3.0\n",
       "                                     Service               0.0\n",
       "                                     Waiting time          3.8\n",
       "\"Elegance Chinese Cuisine & Banquet\" Atmosphere            2.6\n",
       "                                     Food                  3.3\n",
       "                                     Price                 3.7\n",
       "                                     Service               3.7\n",
       "...                                                        ...\n",
       "\"Schwartz's\"                         Service               2.9\n",
       "                                     Waiting time          3.1\n",
       "\"Spuntini Restaurant & Bar\"          Atmosphere            3.6\n",
       "                                     Food                  2.3\n",
       "                                     Price                 1.0\n",
       "                                     Service               3.2\n",
       "                                     Waiting time          3.3\n",
       "\"Sumo Ramen\"                         Atmosphere            3.3\n",
       "                                     Food                  2.3\n",
       "                                     Price                 3.6\n",
       "                                     Service               3.3\n",
       "                                     Waiting time          2.1\n",
       "\"Sun's Kitchen\"                      Atmosphere            1.5\n",
       "                                     Food                  3.2\n",
       "                                     Price                 3.5\n",
       "                                     Service               2.0\n",
       "                                     Waiting time          2.9\n",
       "\"The Burger's Priest\"                Atmosphere            2.9\n",
       "                                     Food                  3.7\n",
       "                                     Price                 3.0\n",
       "                                     Service               2.3\n",
       "                                     Waiting time          3.6\n",
       "\"The Sister\"                         Atmosphere            2.3\n",
       "                                     Food                  4.1\n",
       "                                     Price                 3.8\n",
       "                                     Service               3.2\n",
       "                                     Waiting time          3.9\n",
       "\"The Works Gourmet Burger Bistro\"    Atmosphere            2.2\n",
       "                                     Food                  3.3\n",
       "                                     Service               2.6\n",
       "                                     Waiting time          3.3\n",
       "\"Tuck Shop\"                          Atmosphere            3.6\n",
       "                                     Food                  3.9\n",
       "                                     Price                 2.5\n",
       "                                     Service               2.8\n",
       "                                     Waiting time          3.7\n",
       "\"Wasabi Japanese Buffet\"             Atmosphere            2.9\n",
       "                                     Food                  3.2\n",
       "                                     Price                 2.7\n",
       "                                     Service               4.1\n",
       "                                     Waiting time          3.3\n",
       "\"Wilensky's\"                         Food                  3.8\n",
       "                                     Price                 2.5\n",
       "                                     Service               2.5\n",
       "                                     Waiting time          1.5\n",
       "\"WonderPho\"                          Atmosphere            3.0\n",
       "                                     Food                  3.2\n",
       "                                     Price                 3.7\n",
       "                                     Service               3.6\n",
       "                                     Waiting time          3.5\n",
       "\n",
       "[234 rows x 1 columns]"
      ]
     },
     "execution_count": 126,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def final_score_standard(dataset):\n",
    "\n",
    "    reviews_score = dataset['topic_score']\n",
    "    reviews_score = pd.DataFrame(reviews_score)\n",
    "    \n",
    "    #add new columns to lda_mallet to have individual review score\n",
    "    lda_mallet['topic_score'] = reviews_score\n",
    "    top_10k_score = lda_mallet.loc[:, ['name', 'topic', 'topic_score']]\n",
    "    \n",
    "    #calculate the average ratings for each topic\n",
    "    top_10k_score = round(abs((top_10k_score.groupby(['name',  'topic']).sum() /\n",
    "                    (top_10k_score.groupby(['name', 'topic']).count() + 1))), 1)\n",
    "    \n",
    "    pd.set_option('display.max_rows', 100)\n",
    "    return top_10k_score\n",
    "\n",
    "final_score_standard = final_score_standard(top_10k_standard)\n",
    "final_score_standard\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Vader sentiment analysis\n",
    "def sentiment_analyzer_scores(review, nth):\n",
    "    score_list = []\n",
    "    for i in range(nth):\n",
    "        score = analyzer.polarity_scores(review[i])\n",
    "        for cat, point in score.items():\n",
    "            #only take compound score\n",
    "            if cat == 'compound':\n",
    "                score_list.append(point)\n",
    "    return score_list\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 120,
   "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></th>\n",
       "      <th>topic_score</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>name</th>\n",
       "      <th>topic</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"Banh Mi Boys\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>2.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>3.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>3.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>3.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"Basil Thai Kitchen\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>4.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>4.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>3.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>3.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>4.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"Black Hoof\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>4.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>3.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>3.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>3.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"Bonjour Brioche\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>4.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>3.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>4.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>2.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"Brassaii\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>3.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>4.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>4.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"Chino Locos Original\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>3.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>3.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"Ciao Wine Bar\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>2.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>4.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>3.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>2.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">\"Circus Coffee House\"</th>\n",
       "      <th>Food</th>\n",
       "      <td>3.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>4.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"District\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>3.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>2.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">\"Eggspectation Resto-Cafe\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>4.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">\"Elegance Chinese Cuisine &amp; Banquet\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>2.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">\"Schwartz's\"</th>\n",
       "      <th>Service</th>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>3.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"Spuntini Restaurant &amp; Bar\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>3.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>2.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>3.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>3.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"Sumo Ramen\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>4.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>3.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>2.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"Sun's Kitchen\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>3.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>3.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>3.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>4.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"The Burger's Priest\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>3.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>3.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>4.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>3.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>3.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"The Sister\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>4.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>3.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>2.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>4.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>3.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">\"The Works Gourmet Burger Bistro\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>0.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>3.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>2.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>4.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"Tuck Shop\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>4.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>4.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>3.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>4.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"Wasabi Japanese Buffet\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>3.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>3.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">\"Wilensky's\"</th>\n",
       "      <th>Food</th>\n",
       "      <td>3.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>4.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>2.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>1.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">\"WonderPho\"</th>\n",
       "      <th>Atmosphere</th>\n",
       "      <td>4.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food</th>\n",
       "      <td>2.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Price</th>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service</th>\n",
       "      <td>3.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waiting time</th>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>234 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   topic_score\n",
       "name                                 topic                    \n",
       "\"Banh Mi Boys\"                       Atmosphere            2.7\n",
       "                                     Food                  3.4\n",
       "                                     Price                 3.4\n",
       "                                     Service               3.7\n",
       "                                     Waiting time          3.6\n",
       "\"Basil Thai Kitchen\"                 Atmosphere            4.9\n",
       "                                     Food                  4.8\n",
       "                                     Price                 3.6\n",
       "                                     Service               3.5\n",
       "                                     Waiting time          4.6\n",
       "\"Black Hoof\"                         Atmosphere            4.1\n",
       "                                     Food                  3.8\n",
       "                                     Price                 3.5\n",
       "                                     Service               4.2\n",
       "                                     Waiting time          3.8\n",
       "\"Bonjour Brioche\"                    Atmosphere            4.4\n",
       "                                     Food                  3.1\n",
       "                                     Price                 3.9\n",
       "                                     Service               4.7\n",
       "                                     Waiting time          2.6\n",
       "\"Brassaii\"                           Atmosphere            3.4\n",
       "                                     Food                  3.9\n",
       "                                     Price                 4.1\n",
       "                                     Service               4.1\n",
       "                                     Waiting time          3.9\n",
       "\"Chino Locos Original\"               Atmosphere            4.2\n",
       "                                     Food                  3.3\n",
       "                                     Price                 3.0\n",
       "                                     Service               3.0\n",
       "                                     Waiting time          3.8\n",
       "\"Ciao Wine Bar\"                      Atmosphere            2.7\n",
       "                                     Food                  4.0\n",
       "                                     Price                 4.4\n",
       "                                     Service               3.5\n",
       "                                     Waiting time          2.9\n",
       "\"Circus Coffee House\"                Food                  3.6\n",
       "                                     Service               4.9\n",
       "\"District\"                           Atmosphere            3.9\n",
       "                                     Food                  3.5\n",
       "                                     Price                 2.3\n",
       "                                     Service               3.0\n",
       "                                     Waiting time          3.0\n",
       "\"Eggspectation Resto-Cafe\"           Atmosphere            4.8\n",
       "                                     Food                  2.8\n",
       "                                     Service               0.0\n",
       "                                     Waiting time          3.9\n",
       "\"Elegance Chinese Cuisine & Banquet\" Atmosphere            1.0\n",
       "                                     Food                  3.0\n",
       "                                     Price                 3.0\n",
       "                                     Service               2.6\n",
       "...                                                        ...\n",
       "\"Schwartz's\"                         Service               3.0\n",
       "                                     Waiting time          3.3\n",
       "\"Spuntini Restaurant & Bar\"          Atmosphere            3.4\n",
       "                                     Food                  3.9\n",
       "                                     Price                 2.6\n",
       "                                     Service               3.5\n",
       "                                     Waiting time          3.8\n",
       "\"Sumo Ramen\"                         Atmosphere            4.3\n",
       "                                     Food                  3.7\n",
       "                                     Price                 3.2\n",
       "                                     Service               2.4\n",
       "                                     Waiting time          1.0\n",
       "\"Sun's Kitchen\"                      Atmosphere            5.0\n",
       "                                     Food                  3.3\n",
       "                                     Price                 3.2\n",
       "                                     Service               3.6\n",
       "                                     Waiting time          4.5\n",
       "\"The Burger's Priest\"                Atmosphere            3.6\n",
       "                                     Food                  3.4\n",
       "                                     Price                 4.5\n",
       "                                     Service               3.6\n",
       "                                     Waiting time          3.5\n",
       "\"The Sister\"                         Atmosphere            4.3\n",
       "                                     Food                  3.3\n",
       "                                     Price                 2.7\n",
       "                                     Service               4.7\n",
       "                                     Waiting time          3.3\n",
       "\"The Works Gourmet Burger Bistro\"    Atmosphere            0.7\n",
       "                                     Food                  3.5\n",
       "                                     Service               2.6\n",
       "                                     Waiting time          4.4\n",
       "\"Tuck Shop\"                          Atmosphere            3.9\n",
       "                                     Food                  4.6\n",
       "                                     Price                 4.4\n",
       "                                     Service               3.8\n",
       "                                     Waiting time          4.6\n",
       "\"Wasabi Japanese Buffet\"             Atmosphere            3.1\n",
       "                                     Food                  3.6\n",
       "                                     Price                 4.0\n",
       "                                     Service               3.9\n",
       "                                     Waiting time          3.9\n",
       "\"Wilensky's\"                         Food                  3.5\n",
       "                                     Price                 4.8\n",
       "                                     Service               2.6\n",
       "                                     Waiting time          1.8\n",
       "\"WonderPho\"                          Atmosphere            4.9\n",
       "                                     Food                  2.9\n",
       "                                     Price                 3.7\n",
       "                                     Service               3.2\n",
       "                                     Waiting time          4.0\n",
       "\n",
       "[234 rows x 1 columns]"
      ]
     },
     "execution_count": 120,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_10k = pd.read_csv('top10k_en.csv')\n",
    "\n",
    "def final_score_vader(dataset):\n",
    "    \n",
    "    reviews = dataset['text'] \n",
    "    reviews_score = sentiment_analyzer_scores(reviews, len(reviews))\n",
    "    reviews_score = pd.DataFrame(reviews_score)\n",
    "    lda_mallet['topic_score'] = reviews_score\n",
    "    top_10k_score = lda_mallet.loc[:, ['name', 'topic', 'topic_score']]\n",
    "    \n",
    "    #normalize the score to 0-5\n",
    "    top_10k_score = round(abs((top_10k_score.groupby(['name',  'topic']).sum() /\n",
    "                    top_10k_score.groupby(['name', 'topic']).count()) * 5), 1)\n",
    "    \n",
    "    pd.set_option('display.max_rows', 100)\n",
    "    top_10k_score\n",
    "    return top_10k_score\n",
    "\n",
    "final_score_vader = final_score_vader(top_10k)\n",
    "final_score_vader\n"
   ]
  }
 ],
 "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}