Main.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "DEFINES_ONLY = True"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# -*- coding: utf-8 -*-\n",
    "\"\"\"\n",
    "Created on Wed Nov  1 15:00:40 2017\n",
    "\n",
    "@author: He Song\n",
    "\"\"\"\n",
    "\n",
    "from bs4 import BeautifulSoup\n",
    "import time\n",
    "import requests\n",
    "\n",
    "def reviews(url,type,name):\n",
    "    count=0;\n",
    "    restname=[]\n",
    "    fw=open(name,'w') # output file\n",
    "    for p in range(1,80):\n",
    "        pageLink=url+'/search?find_loc=Los+Angeles,+CA&start='+str(p*10)+'&cflt=' +type# make the page url\n",
    "        for i in range(5): # try 5 times\n",
    "                    try:\n",
    "                        #use the browser to access the url\n",
    "                        response=requests.get(pageLink,headers = { 'User-Agent': 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2228.0 Safari/537.36', })\n",
    "                        html=response.content # get the html\n",
    "                        break # we got the file, break the loops\n",
    "                    except Exception as e:# browser.open() threw an exception, the attempt to get the response failed\n",
    "                        print ('failed attempt',i)\n",
    "                        time.sleep(2) # wait 2 secs\n",
    "        \t\t\t\t\n",
    "        \t\t\n",
    "        if not html:continue # couldnt get the page, ignore\n",
    "                \n",
    "        soup = BeautifulSoup(html.decode('ascii', 'ignore'),'lxml') # parse the html \n",
    "        divget=soup.findAll('div',{'class':'media-story'})\n",
    "        \n",
    "        for div in divget:\n",
    "            #print(review)\n",
    "            #print(div)\n",
    "            try:\n",
    "                restaurant=div.find('a', {'class':'biz-name js-analytics-click'}) # get all the review divs\n",
    "                kind=div.find('span',{'class':'category-str-list'})\n",
    "                #print(restaurant)\n",
    "               \n",
    "                if restaurant:\n",
    "                    if 'ad_business_id' not in restaurant['href']:\n",
    "                        kind_s=kind.findAll('a')\n",
    "                        if len(kind_s)==1:\n",
    "                            \n",
    "                            reviewnum=div.find('span',{'class':'review-count rating-qualifier'})\n",
    "                            \n",
    "                            reviewnum=reviewnum.text.replace('reviews','')\n",
    "                            reviewnum=reviewnum.replace(' ','')\n",
    "                           \n",
    "                            if float(reviewnum)>200 and count<=50:\n",
    "                                #print(kind)\n",
    "                                print(reviewnum)\n",
    "                                nextse=restaurant['href']\n",
    "                                print(nextse)\n",
    "                                sp=restaurant.find('span')\n",
    "                                print(sp.text)\n",
    "                                if sp.text not in restname:\n",
    "                                    fw.write(str(count)+'\\t'+reviewnum+'\\t'+nextse+'\\t'+sp.text+'\\n')\n",
    "                                    restname.append(sp.text)\n",
    "                                    count+=1\n",
    "                                print('\\n')\n",
    "                                    \n",
    "                            elif count>50 :\n",
    "                                fw.close()\n",
    "                                return\n",
    "            except Exception as e:\n",
    "                continue\n",
    "\n",
    "if DEFINES_ONLY == False:\n",
    "    reviews('https://www.yelp.com', 'chinese', 'chinese.txt')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# -*- coding: utf-8 -*-\n",
    "\"\"\"\n",
    "Created on Wed Nov  1 15:00:40 2017\n",
    "\n",
    "@author: Y. Zhao\n",
    "\"\"\"\n",
    "\n",
    "import time\n",
    "import requests\n",
    "import os, shutil\n",
    "\n",
    "def getReviews(urlBase, url, filepath, maxReviews = 300):\n",
    "    for p in range(0, int(maxReviews / 20)):\n",
    "        pageLink=urlBase + url + '?start=' + str(p * 20) + '&sort_by=date_desc'# make the page url\n",
    "        for i in range(5): # try 5 times\n",
    "            try:\n",
    "                #use the browser to access the url\n",
    "                response=requests.get(pageLink,headers = { 'User-Agent': 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2228.0 Safari/537.36', })\n",
    "                html=response.content # get the html\n",
    "                break # we got the file, break the loops\n",
    "            except Exception as e:# browser.open() threw an exception, the attempt to get the response failed\n",
    "                print ('failed attempt',i)\n",
    "                time.sleep(2) # wait 2 secs\n",
    "\n",
    "\n",
    "        if not html:\n",
    "            raise Exception()\n",
    "            continue # couldnt get the page, ignore\n",
    "        else:\n",
    "            with open(filepath + '/' + str(p) + '.html', 'w') as f:\n",
    "                f.write(html.decode('ascii', 'ignore'))\n",
    "\n",
    "\n",
    "#reviews('https://www.yelp.com', '/biz/lao-sze-chuan-glendale-5')\n",
    "\n",
    "def getGene(name, maxReviews = 300):\n",
    "    with open(name + '.txt', 'r') as f:\n",
    "        ls = f.readlines()\n",
    "        print(int(len(ls) / 3))\n",
    "        for i in range(0, len(ls), 3):\n",
    "            id = ls[i].strip()\n",
    "            path = ls[i + 2].strip().split('\\t')[0]\n",
    "            print(id + \" \" + ls[i + 2].strip().split('\\t')[1])\n",
    "            if os.path.exists(os.path.join(os.getcwd(), name + \"_\" + id)) == False:\n",
    "                try:\n",
    "                    os.mkdir(os.path.join(os.getcwd(), 'temp'))\n",
    "                except FileExistsError as e:\n",
    "                    shutil.rmtree(os.path.join(os.getcwd(), 'temp/'))\n",
    "                    os.mkdir(os.path.join(os.getcwd(), 'temp'))\n",
    "                try:\n",
    "                    getReviews('https://www.yelp.com', path, os.path.join(os.getcwd(), 'temp'), maxReviews = 300)\n",
    "                    with open(os.path.join(os.getcwd(), 'temp') + '/metadata', 'w') as f:\n",
    "                        f.write(ls[i] + ls[i + 1] + ls[i + 2] + str(int(maxReviews / 20)) + '\\n')\n",
    "                    os.rename(os.path.join(os.getcwd(), 'temp'), os.path.join(os.getcwd(), name + \"_\" + id))\n",
    "                except Exception as e:\n",
    "                    print ('failed attempt', name + \"_\" + id)\n",
    "                    continue\n",
    "            \n",
    "if DEFINES_ONLY == False:\n",
    "    getGene('chinese')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# -*- coding: utf-8 -*-\n",
    "\"\"\"\n",
    "Created on Wed Nov  1 15:00:40 2017\n",
    "\n",
    "@author: Yi Zhao\n",
    "\"\"\"\n",
    "\n",
    "from bs4 import BeautifulSoup\n",
    "import re\n",
    "import time\n",
    "import requests\n",
    "import pandas as pd\n",
    "import os\n",
    "\n",
    "def get1(div_review, classdesc):\n",
    "    try:\n",
    "        li_friends = div_review.findAll('li', {'class': classdesc})\n",
    "        li_friends_b = li_friends[0].findAll('b')\n",
    "        friends = li_friends_b[0].contents[0]\n",
    "        return friends\n",
    "    except:\n",
    "        return 0\n",
    "\n",
    "\n",
    "def analyseHtml(html, rId):\n",
    "    results = []\n",
    "    print(rId)\n",
    "\n",
    "    soup = BeautifulSoup(html,'lxml') # parse the html \n",
    "    reviews=soup.findAll('div',{'class':'review review--with-sidebar'})\n",
    "    \n",
    "    for div_review in reviews:\n",
    "        result = {'restaurantId': rId}\n",
    "        \n",
    "        review_id = div_review['data-review-id']\n",
    "        result['review_id'] = review_id\n",
    "\n",
    "        try:\n",
    "            a_username = div_review.findAll('a', {'class': 'user-display-name js-analytics-click'})\n",
    "            username = a_username[0].contents[0]\n",
    "            result['username'] = username\n",
    "        except IndexError:\n",
    "            result['username'] = ''\n",
    "        \n",
    "        num_friends = get1(div_review, 'friend-count responsive-small-display-inline-block')\n",
    "        result['num_friends'] = num_friends\n",
    "        num_reviews = get1(div_review, 'review-count responsive-small-display-inline-block')\n",
    "        result['num_reviews'] = num_reviews\n",
    "        num_photos = get1(div_review, 'photo-count responsive-small-display-inline-block')\n",
    "        result['num_photos'] = num_photos\n",
    "        \n",
    "        try:\n",
    "            review_text = div_review.findAll('p', {'lang': 'en'})[0].contents[0]\n",
    "            result['review_text'] = review_text\n",
    "        except IndexError:\n",
    "            result['review_text'] = ''\n",
    "        \n",
    "        rating_qualifier = div_review.findAll('span', {'class': 'rating-qualifier'})[0].contents[0]\n",
    "        result['date'] = rating_qualifier.strip()\n",
    "        \n",
    "        elite = len(div_review.findAll('a', {'href': '/elite'}))\n",
    "        result['elite'] = elite\n",
    "        \n",
    "        try:\n",
    "            a_useful = div_review.findAll('class', {'ybtn ybtn--small useful js-analytics-click'})[0]\n",
    "            span_useful = a_useful.findAll('span', {'class': 'count'})[0]\n",
    "            useful = span_useful.contents[0]\n",
    "            result['useful'] = useful\n",
    "        except IndexError:\n",
    "            result['useful'] = 0\n",
    "        \n",
    "        rating = div_review.findAll('div', {'class': 'rating-large'})[0]['title']\n",
    "        result['rating'] = rating.split()[0]\n",
    "    \n",
    "        results.append(result)\n",
    "        \n",
    "    return results\n",
    "\n",
    "def analyseDir(path, rId):\n",
    "    csvfilepath = os.path.join(path, 'data.csv')\n",
    "    if os.path.isfile(csvfilepath) == True:\n",
    "        return pd.read_csv(csvfilepath)\n",
    "    else:\n",
    "        res = []\n",
    "        tempfilepath = 'temp.csv'\n",
    "        f = open(os.path.join(path, 'metadata'))\n",
    "        pages = int(f.readlines()[3])\n",
    "        for page in range(pages):\n",
    "            res += analyseHtml(open(os.path.join(path, str(page) + '.html')).read(), rId)\n",
    "        df2 = pd.DataFrame(res)\n",
    "        df2.to_csv(tempfilepath)\n",
    "        os.rename(tempfilepath, csvfilepath)\n",
    "        return df2\n",
    "\n",
    "def analyseGene(name, max_id, path='/Users/enyaning/Desktop/BIA660/BIA660_TEAM_2/'):\n",
    "    dfs = []\n",
    "    for id in range(max_id + 1):\n",
    "        df = analyseDir(path + name + '_' + str(id), name + '_' + str(id))\n",
    "        dfs.append(df)\n",
    "    return pd.concat(dfs)\n",
    "\n",
    "def main(name, max_id, path):\n",
    "    df2 = analyseGene(name, max_id, path=path)\n",
    "    df2.to_csv(name + '.csv')\n",
    "    return df2\n",
    "\n",
    "if DEFINES_ONLY == False:\n",
    "    main('chinese', 50, '/Users/enyaning/Desktop/BIA660/BIA660_TEAM_2/')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#!/usr/bin/env python3\n",
    "# -*- coding: utf-8 -*-\n",
    "\"\"\"\n",
    "Created on Wed Nov  8 14:39:07 2017\n",
    "\n",
    "@author: enyaning\n",
    "\"\"\"\n",
    "\n",
    "\n",
    "import pandas as pd\n",
    "import re\n",
    "import operator\n",
    "from nltk.corpus import stopwords\n",
    "\n",
    "import nltk\n",
    "from nltk.util import ngrams\n",
    "from nltk.tokenize import sent_tokenize\n",
    "from nltk import load\n",
    "\n",
    "from textblob import TextBlob\n",
    "\n",
    "def getFreq(inputcsv, outputcsv):\n",
    "    csv_path = inputcsv\n",
    "    data = pd.read_csv(csv_path)\n",
    "\n",
    "    wordcount = {}\n",
    "    stop_words =  set(stopwords.words('english'))\n",
    "    costumer_stop_words = ['chinese', 'italian', 'mexican', 'good', 'great', 'food', 'place', 'los', 'angeles', 'hoboken']\n",
    "    for word in costumer_stop_words: stop_words.add(word)\n",
    "    costumer_not_stop_words = []\n",
    "    for word in costumer_not_stop_words: stop_words.discard(word)\n",
    "    file_stop_words = [word.strip().lower() for word in open('stopwords.txt').readlines()]\n",
    "\n",
    "    #make a new tagger\n",
    "    _POS_TAGGER = 'taggers/maxent_treebank_pos_tagger/english.pickle'\n",
    "    tagger = load(_POS_TAGGER)\n",
    "\n",
    "\n",
    "    jsons = []\n",
    "\n",
    "    review_number = 0\n",
    "    for index, row in data.iterrows():\n",
    "        try:\n",
    "            review = row['review_text']\n",
    "            restaurantId = row['restaurantId']\n",
    "\n",
    "            blob = TextBlob(review)\n",
    "            blob.noun_phrases\n",
    "\n",
    "            for i in range(len(blob.sentences)):\n",
    "                sentence = blob.sentences[i]\n",
    "\n",
    "                terms = nltk.word_tokenize(sentence.raw.lower())\n",
    "                tagged_terms=tagger.tag(terms)\n",
    "\n",
    "                for tg in ngrams(tagged_terms,2):\n",
    "                    if tg[0][1].startswith('NN') and tg[1][1].startswith('NN') and tg[0][0] not in stop_words and tg[1][0] not in stop_words:\n",
    "                        key = tg[0][0] + \" \" + tg[1][0]\n",
    "                        json = {\n",
    "                            \"restaurantId\": restaurantId,\n",
    "                            \"review_id\": index,\n",
    "                            \"sentence_id\": i,\n",
    "                            \"sentence\": sentence.raw,\n",
    "                            \"phrase\": key\n",
    "                        }\n",
    "                        jsons.append(json)\n",
    "\n",
    "        except TypeError:\n",
    "            print(\"TypeError\");\n",
    "        finally:\n",
    "            if review_number%20 == 0:\n",
    "                print(review_number)\n",
    "            review_number += 1\n",
    "\n",
    "    df = pd.DataFrame(jsons)\n",
    "    df.to_csv('test.csv')\n",
    "    print(df)\n",
    "    \n",
    "if DEFINES_ONLY == False:\n",
    "    getFreq('chinese.csv', 'test.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#!/usr/bin/env python3\n",
    "# -*- coding: utf-8 -*-\n",
    "\"\"\"\n",
    "Created on Wed Nov  8 14:39:07 2017\n",
    "\n",
    "@author: enyaning\n",
    "\"\"\"\n",
    "\n",
    "\n",
    "import pandas as pd\n",
    "import json\n",
    "\n",
    "def toJson(inputcsv, outputjson, restaurantDictName):\n",
    "    csv_path = inputcsv\n",
    "    data = pd.read_csv(csv_path)\n",
    "\n",
    "    reduce1 = {}\n",
    "    print('reducing 1')\n",
    "\n",
    "    for index, row in data.iterrows():\n",
    "        key = str(row['restaurantId']) + \"|\" + row['phrase'] + \"|\" + str(row['review_id']) \n",
    "        if key not in reduce1:\n",
    "            reduce1[key] = []\n",
    "        reduce1[key].append(row['sentence'])\n",
    "\n",
    "    reduce2 = {}\n",
    "    print('reducing 2')\n",
    "\n",
    "    for k, v in reduce1.items():\n",
    "        parts = k.split(\"|\")\n",
    "        key = parts[0] + \"|\" + parts[1] # restaurantId | phrase\n",
    "        if key not in reduce2:\n",
    "            reduce2[key] = []\n",
    "        reduce2[key].append({'review_id': parts[2], 'sentences': v})\n",
    "\n",
    "    reduce3 = {}\n",
    "    print('reducing 3')\n",
    "\n",
    "    for k, v in reduce2.items():\n",
    "        parts = k.split(\"|\")\n",
    "        key = parts[0] # restaurantId\n",
    "        if key not in reduce3:\n",
    "            reduce3[key] = []\n",
    "        reduce3[key].append({'phrase': parts[1], 'reviews': v})\n",
    "\n",
    "    def sort_top_100(arr):\n",
    "        return sorted(arr, key = lambda k: len(k['reviews']), reverse=True)[:100]\n",
    "\n",
    "    print('finally')\n",
    "\n",
    "    dictIdName = {}\n",
    "    i = 0\n",
    "    for l in open(restaurantDictName + '.txt').readlines():\n",
    "        parts = l.split('\\t')\n",
    "        print(l, parts)\n",
    "        if(len(parts) == 3):\n",
    "            dictIdName[restaurantDictName + '_' + str(i)] = parts[2]\n",
    "            i += 1\n",
    "    \n",
    "    res = []\n",
    "    for k, v in reduce3.items():\n",
    "        res.append({'restaurantId': k, 'restaurantName': dictIdName[k], 'top-none-phrases': sort_top_100(v)})\n",
    "\n",
    "    with open(outputjson, 'w') as f:\n",
    "        json.dump(res, f, indent=4, sort_keys=True)\n",
    "\n",
    "    return res\n",
    "\n",
    "# DEFINES_ONLY = False\n",
    "DEFINES_ONLY = True\n",
    "if DEFINES_ONLY == False:\n",
    "    toJson('test.csv', 'json.json', 'customer')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# -*- coding: utf-8 -*-\n",
    "\"\"\"\n",
    "Created on Sat Dec  2 14:32:59 2017\n",
    "\n",
    "@author: hasee\n",
    "\"\"\"\n",
    "from textblob import TextBlob\n",
    "import json\n",
    "\n",
    "def getresult(inputjson, outputfile):\n",
    "    d = {}\n",
    "    with open(inputjson) as json_data:\n",
    "        d=json.load(json_data)\n",
    "\n",
    "    dictIdName = {}\n",
    "    i = 0\n",
    "    for l in open('chinese' + '.txt').readlines():\n",
    "        parts = l.split('\\t')\n",
    "        print(l, parts)\n",
    "        if(len(parts) == 3):\n",
    "            dictIdName['chinese' + '_' + str(i)] = parts[2]\n",
    "            i += 1\n",
    "\n",
    "    for restaurant in d: #[0:5]:\n",
    "        outputfile.write('\\n')\n",
    "        outputfile.write(dictIdName[restaurant['restaurantId']])\n",
    "#         outputfile.write(restaurant['restaurantName'] + '\\n')\n",
    "        likes=[]\n",
    "        dislikes=[]\n",
    "        for topword in restaurant['top-none-phrases'][0:10]:\n",
    "\n",
    "            scoreword=0\n",
    "    #        print(topword['phrase'])\n",
    "            for reviews in topword['reviews']:\n",
    "                countse=0\n",
    "                scorese=0;\n",
    "                for sentence in reviews['sentences']:\n",
    "                    sentence=sentence.replace('chicken','beef')\n",
    "                    blob = TextBlob(sentence)\n",
    "                    blob.tags\n",
    "                    blob.noun_phrases\n",
    "                    ns=blob.sentences[0].sentiment.polarity\n",
    "                    scorese+=ns\n",
    "    #                print(sentence)\n",
    "    #                print(ns)\n",
    "                    countse+=1;\n",
    "                scoreword+=scorese/countse\n",
    "            result_word_score_avg=scoreword/len(topword['reviews'])\n",
    "            if result_word_score_avg>0:\n",
    "                likes.append(topword['phrase'])\n",
    "            else:\n",
    "                dislikes.append(topword['phrase'])\n",
    "    #        print(result_word_score_avg)\n",
    "        outputfile.write('What the Guests loved Most: ' + '\\n')\n",
    "        for like in likes:\n",
    "            outputfile.write(like + '\\n')\n",
    "        outputfile.write('\\n')\n",
    "        outputfile.write('What nedd to be improved: ' + '\\n')\n",
    "        for dislike in dislikes:\n",
    "            outputfile.write(dislike + '\\n')\n",
    "        outputfile.write('\\n')\n",
    "        outputfile.write('\\n')\n",
    "    \n",
    "if DEFINES_ONLY == False:\n",
    "    getresult('json.json', sys.stdout)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import sys\n",
    "\n",
    "def customerRestaurant(url, name):\n",
    "    open('customer.txt', 'w').write('0\\n300\\n\\t' + url + '\\t' + name + '\\n')\n",
    "    getGene('customer')\n",
    "    main('customer', 0, '/Users/tylio/660/BIA660_TEAM_2/')\n",
    "    getFreq('customer.csv', 'test.csv')\n",
    "    toJson('test.csv', 'json.json', 'customer')\n",
    "    getresult('json.json', sys.stdout)\n",
    "\n",
    "def runGene(geneName):\n",
    "    reviews('https://www.yelp.com', geneName, geneName + '.txt')\n",
    "    getGene(geneName)\n",
    "    main(geneName, 50, '/Users/tylio/660/BIA660_TEAM_2/')\n",
    "    getFreq(geneName + '.csv', 'test.csv')\n",
    "    toJson('test.csv', 'json.json', geneName)\n",
    "    getresult('json.json', sys.stdout)\n",
    "    \n",
    "if DEFINES_ONLY == False:\n",
    "    runGene('chinese')\n",
    "    customerRestaurant('/biz/king-szechuan-palace-jersey-city', 'King Szechuan Palace')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "814\n",
      "\n",
      "/biz/il-capriccio-on-vermont-los-angeles\n",
      "Il Capriccio on Vermont\n",
      "\n",
      "\n",
      "\n",
      "714\n",
      "\n",
      "/biz/pomodoro-trattoria-los-angeles-2\n",
      "Pomodoro Trattoria\n",
      "\n",
      "\n",
      "\n",
      "488\n",
      "\n",
      "/biz/speranza-los-angeles\n",
      "Speranza\n",
      "\n",
      "\n",
      "\n",
      "298\n",
      "\n",
      "/biz/frankies-los-angeles-2\n",
      "Frankies\n",
      "\n",
      "\n",
      "\n",
      "1001\n",
      "\n",
      "/biz/the-factory-kitchen-los-angeles\n",
      "The Factory Kitchen\n",
      "\n",
      "\n",
      "\n",
      "1382\n",
      "\n",
      "/biz/drago-centro-los-angeles\n",
      "DRAGO Centro\n",
      "\n",
      "\n",
      "\n",
      "455\n",
      "\n",
      "/biz/pizzicotto-los-angeles\n",
      "Pizzicotto\n",
      "\n",
      "\n",
      "\n",
      "562\n",
      "\n",
      "/biz/spumoni-restaurant-sherman-oaks\n",
      "Spumoni Restaurant\n",
      "\n",
      "\n",
      "\n",
      "1382\n",
      "\n",
      "/biz/drago-centro-los-angeles\n",
      "DRAGO Centro\n",
      "\n",
      "\n",
      "\n",
      "726\n",
      "\n",
      "/biz/fabiolus-cucina-hollywood\n",
      "Fabiolus Cucina\n",
      "\n",
      "\n",
      "\n",
      "879\n",
      "\n",
      "/biz/gales-pasadena\n",
      "Gales\n",
      "\n",
      "\n",
      "\n",
      "637\n",
      "\n",
      "/biz/madeo-restaurant-los-angeles-3\n",
      "Madeo Restaurant\n",
      "\n",
      "\n",
      "\n",
      "391\n",
      "\n",
      "/biz/gusto-los-angeles\n",
      "Gusto\n",
      "\n",
      "\n",
      "\n",
      "259\n",
      "\n",
      "/biz/centanni-trattoria-burbank\n",
      "Centanni Trattoria\n",
      "\n",
      "\n",
      "\n",
      "249\n",
      "\n",
      "/biz/cafe-angelino-los-angeles\n",
      "Cafe Angelino\n",
      "\n",
      "\n",
      "\n",
      "677\n",
      "\n",
      "/biz/la-tavolata-artesia\n",
      "La Tavolata\n",
      "\n",
      "\n",
      "\n",
      "775\n",
      "\n",
      "/biz/raffaello-ristorante-san-pedro\n",
      "Raffaello Ristorante\n",
      "\n",
      "\n",
      "\n",
      "877\n",
      "\n",
      "/biz/jon-and-vinnys-los-angeles\n",
      "Jon & Vinnys\n",
      "\n",
      "\n",
      "\n",
      "641\n",
      "\n",
      "/biz/ca-del-sole-toluca-lake-2\n",
      "Ca Del Sole\n",
      "\n",
      "\n",
      "\n",
      "423\n",
      "\n",
      "/biz/locanda-veneta-los-angeles\n",
      "Locanda Veneta\n",
      "\n",
      "\n",
      "\n",
      "423\n",
      "\n",
      "/biz/locanda-veneta-los-angeles\n",
      "Locanda Veneta\n",
      "\n",
      "\n",
      "\n",
      "260\n",
      "\n",
      "/biz/enzo-and-angela-los-angeles-2\n",
      "Enzo & Angela\n",
      "\n",
      "\n",
      "\n",
      "344\n",
      "\n",
      "/biz/italys-little-kitchen-los-angeles\n",
      "Italys Little Kitchen\n",
      "\n",
      "\n",
      "\n",
      "677\n",
      "\n",
      "/biz/la-tavolata-artesia\n",
      "La Tavolata\n",
      "\n",
      "\n",
      "\n",
      "1344\n",
      "\n",
      "/biz/c-and-o-cucina-marina-del-rey\n",
      "C & O Cucina\n",
      "\n",
      "\n",
      "\n",
      "434\n",
      "\n",
      "/biz/chi-spacca-los-angeles\n",
      "Chi Spacca\n",
      "\n",
      "\n",
      "\n",
      "214\n",
      "\n",
      "/biz/spartina-los-angeles\n",
      "Spartina\n",
      "\n",
      "\n",
      "\n",
      "247\n",
      "\n",
      "/biz/ancora-cucina-italiana-tarzana\n",
      "Ancora Cucina Italiana\n",
      "\n",
      "\n",
      "\n",
      "275\n",
      "\n",
      "/biz/north-italia-santa-monica-3\n",
      "North Italia\n",
      "\n",
      "\n",
      "\n",
      "495\n",
      "\n",
      "/biz/romano-cucina-sunset-beach-2\n",
      "Romano Cucina\n",
      "\n",
      "\n",
      "\n",
      "207\n",
      "\n",
      "/biz/palmeri-ristorante-los-angeles\n",
      "Palmeri Ristorante\n",
      "\n",
      "\n",
      "\n",
      "333\n",
      "\n",
      "/biz/brunos-santa-monica\n",
      "Brunos\n",
      "\n",
      "\n",
      "\n",
      "950\n",
      "\n",
      "/biz/trattoria-amici-glendale-2\n",
      "Trattoria Amici\n",
      "\n",
      "\n",
      "\n",
      "259\n",
      "\n",
      "/biz/centanni-trattoria-burbank\n",
      "Centanni Trattoria\n",
      "\n",
      "\n",
      "\n",
      "641\n",
      "\n",
      "/biz/ca-del-sole-toluca-lake-2\n",
      "Ca Del Sole\n",
      "\n",
      "\n",
      "\n",
      "372\n",
      "\n",
      "/biz/via-veneto-santa-monica\n",
      "Via Veneto\n",
      "\n",
      "\n",
      "\n",
      "726\n",
      "\n",
      "/biz/fabiolus-cucina-hollywood\n",
      "Fabiolus Cucina\n",
      "\n",
      "\n",
      "\n",
      "276\n",
      "\n",
      "/biz/novecento-pasta-and-grill-culver-city\n",
      "Novecento Pasta & Grill\n",
      "\n",
      "\n",
      "\n",
      "265\n",
      "\n",
      "/biz/adagio-ristorante-woodland-hills\n",
      "Adagio Ristorante\n",
      "\n",
      "\n",
      "\n",
      "238\n",
      "\n",
      "/biz/buon-gusto-ristorante-mission-hills\n",
      "Buon Gusto Ristorante\n",
      "\n",
      "\n",
      "\n",
      "303\n",
      "\n",
      "/biz/divina-cucina-montrose\n",
      "Divina Cucina\n",
      "\n",
      "\n",
      "\n",
      "464\n",
      "\n",
      "/biz/il-tramezzino-beverly-hills-beverly-hills\n",
      "Il Tramezzino - Beverly Hills\n",
      "\n",
      "\n",
      "\n",
      "394\n",
      "\n",
      "/biz/via-alloro-beverly-hills-2\n",
      "Via Alloro\n",
      "\n",
      "\n",
      "\n",
      "271\n",
      "\n",
      "/biz/la-cava-san-fernando-valley\n",
      "La Cava\n",
      "\n",
      "\n",
      "\n",
      "237\n",
      "\n",
      "/biz/betos-simi-valley\n",
      "Betos\n",
      "\n",
      "\n",
      "\n",
      "247\n",
      "\n",
      "/biz/ancora-cucina-italiana-tarzana\n",
      "Ancora Cucina Italiana\n",
      "\n",
      "\n",
      "\n",
      "529\n",
      "\n",
      "/biz/ago-restaurant-west-hollywood\n",
      "AGO Restaurant\n",
      "\n",
      "\n",
      "\n",
      "434\n",
      "\n",
      "/biz/vino-and-cucina-long-beach\n",
      "Vino & Cucina\n",
      "\n",
      "\n",
      "\n",
      "254\n",
      "\n",
      "/biz/trastevere-hollywood-2\n",
      "Trastevere\n",
      "\n",
      "\n",
      "\n",
      "394\n",
      "\n",
      "/biz/via-alloro-beverly-hills-2\n",
      "Via Alloro\n",
      "\n",
      "\n",
      "\n",
      "279\n",
      "\n",
      "/biz/picarellis-cucina-italiana-long-beach-3\n",
      "Picarellis Cucina Italiana\n",
      "\n",
      "\n",
      "\n",
      "254\n",
      "\n",
      "/biz/trastevere-hollywood-2\n",
      "Trastevere\n",
      "\n",
      "\n",
      "\n",
      "422\n",
      "\n",
      "/biz/la-scala-beverly-hills-2\n",
      "La Scala\n",
      "\n",
      "\n",
      "\n",
      "361\n",
      "\n",
      "/biz/il-ristorante-di-giorgio-baldi-santa-monica\n",
      "Il Ristorante di Giorgio Baldi\n",
      "\n",
      "\n",
      "\n",
      "245\n",
      "\n",
      "/biz/mangiamo-ristorante-and-bar-manhattan-beach\n",
      "Mangiamo Ristorante & Bar\n",
      "\n",
      "\n",
      "\n",
      "351\n",
      "\n",
      "/biz/capo-santa-monica\n",
      "Capo\n",
      "\n",
      "\n",
      "\n",
      "412\n",
      "\n",
      "/biz/valentino-santa-monica\n",
      "Valentino\n",
      "\n",
      "\n",
      "\n",
      "677\n",
      "\n",
      "/biz/la-tavolata-artesia\n",
      "La Tavolata\n",
      "\n",
      "\n",
      "\n",
      "222\n",
      "\n",
      "/biz/locanda-portofino-santa-monica-2\n",
      "Locanda Portofino\n",
      "\n",
      "\n",
      "\n",
      "555\n",
      "\n",
      "/biz/trastevere-santa-monica\n",
      "Trastevere\n",
      "\n",
      "\n",
      "\n",
      "222\n",
      "\n",
      "/biz/locanda-portofino-santa-monica-2\n",
      "Locanda Portofino\n",
      "\n",
      "\n",
      "\n",
      "213\n",
      "\n",
      "/biz/the-bottle-inn-hermosa-hermosa-beach\n",
      "The Bottle Inn Hermosa\n",
      "\n",
      "\n",
      "\n",
      "325\n",
      "\n",
      "/biz/francos-italian-restaurant-cypress\n",
      "Francos Italian Restaurant\n",
      "\n",
      "\n",
      "51\n",
      "0 Il Capriccio on Vermont\n",
      "1 Pomodoro Trattoria\n",
      "2 Speranza\n",
      "3 Frankies\n",
      "4 The Factory Kitchen\n",
      "5 DRAGO Centro\n",
      "6 Pizzicotto\n",
      "7 Spumoni Restaurant\n",
      "8 Fabiolus Cucina\n",
      "9 Gales\n",
      "10 Madeo Restaurant\n",
      "11 Gusto\n",
      "12 Centanni Trattoria\n",
      "13 Cafe Angelino\n",
      "14 La Tavolata\n",
      "15 Raffaello Ristorante\n",
      "16 Jon & Vinnys\n",
      "17 Ca Del Sole\n",
      "18 Locanda Veneta\n",
      "19 Enzo & Angela\n",
      "20 Italys Little Kitchen\n",
      "21 C & O Cucina\n",
      "22 Chi Spacca\n",
      "23 Spartina\n",
      "24 Ancora Cucina Italiana\n",
      "25 North Italia\n",
      "26 Romano Cucina\n",
      "27 Palmeri Ristorante\n",
      "28 Brunos\n",
      "29 Trattoria Amici\n",
      "30 Via Veneto\n",
      "31 Novecento Pasta & Grill\n",
      "32 Adagio Ristorante\n",
      "33 Buon Gusto Ristorante\n",
      "34 Divina Cucina\n",
      "35 Il Tramezzino - Beverly Hills\n",
      "36 Via Alloro\n",
      "37 La Cava\n",
      "38 Betos\n",
      "39 AGO Restaurant\n",
      "40 Vino & Cucina\n",
      "41 Trastevere\n",
      "42 Picarellis Cucina Italiana\n",
      "43 La Scala\n",
      "44 Il Ristorante di Giorgio Baldi\n",
      "45 Mangiamo Ristorante & Bar\n",
      "46 Capo\n",
      "47 Valentino\n",
      "48 Locanda Portofino\n",
      "49 The Bottle Inn Hermosa\n",
      "50 Francos Italian Restaurant\n",
      "italian_0\n",
      "italian_0\n",
      "italian_0\n",
      "italian_0\n",
      "italian_0\n",
      "italian_0\n",
      "italian_0\n",
      "italian_0\n",
      "italian_0\n",
      "italian_0\n",
      "italian_0\n",
      "italian_0\n",
      "italian_0\n",
      "italian_0\n",
      "italian_0\n",
      "italian_1\n",
      "italian_1\n",
      "italian_1\n",
      "italian_1\n",
      "italian_1\n",
      "italian_1\n",
      "italian_1\n",
      "italian_1\n",
      "italian_1\n",
      "italian_1\n",
      "italian_1\n",
      "italian_1\n",
      "italian_1\n",
      "italian_1\n",
      "italian_1\n",
      "italian_2\n",
      "italian_2\n",
      "italian_2\n",
      "italian_2\n",
      "italian_2\n",
      "italian_2\n",
      "italian_2\n",
      "italian_2\n",
      "italian_2\n",
      "italian_2\n",
      "italian_2\n",
      "italian_2\n",
      "italian_2\n",
      "italian_2\n",
      "italian_2\n",
      "italian_3\n",
      "italian_3\n",
      "italian_3\n",
      "italian_3\n",
      "italian_3\n",
      "italian_3\n",
      "italian_3\n",
      "italian_3\n",
      "italian_3\n",
      "italian_3\n",
      "italian_3\n",
      "italian_3\n",
      "italian_3\n",
      "italian_3\n",
      "italian_3\n",
      "italian_4\n",
      "italian_4\n",
      "italian_4\n",
      "italian_4\n",
      "italian_4\n",
      "italian_4\n",
      "italian_4\n",
      "italian_4\n",
      "italian_4\n",
      "italian_4\n",
      "italian_4\n",
      "italian_4\n",
      "italian_4\n",
      "italian_4\n",
      "italian_4\n",
      "italian_5\n",
      "italian_5\n",
      "italian_5\n",
      "italian_5\n",
      "italian_5\n",
      "italian_5\n",
      "italian_5\n",
      "italian_5\n",
      "italian_5\n",
      "italian_5\n",
      "italian_5\n",
      "italian_5\n",
      "italian_5\n",
      "italian_5\n",
      "italian_5\n",
      "italian_6\n",
      "italian_6\n",
      "italian_6\n",
      "italian_6\n",
      "italian_6\n",
      "italian_6\n",
      "italian_6\n",
      "italian_6\n",
      "italian_6\n",
      "italian_6\n",
      "italian_6\n",
      "italian_6\n",
      "italian_6\n",
      "italian_6\n",
      "italian_6\n",
      "italian_7\n",
      "italian_7\n",
      "italian_7\n",
      "italian_7\n",
      "italian_7\n",
      "italian_7\n",
      "italian_7\n",
      "italian_7\n",
      "italian_7\n",
      "italian_7\n",
      "italian_7\n",
      "italian_7\n",
      "italian_7\n",
      "italian_7\n",
      "italian_7\n",
      "italian_8\n",
      "italian_8\n",
      "italian_8\n",
      "italian_8\n",
      "italian_8\n",
      "italian_8\n",
      "italian_8\n",
      "italian_8\n",
      "italian_8\n",
      "italian_8\n",
      "italian_8\n",
      "italian_8\n",
      "italian_8\n",
      "italian_8\n",
      "italian_8\n",
      "italian_9\n",
      "italian_9\n",
      "italian_9\n",
      "italian_9\n",
      "italian_9\n",
      "italian_9\n",
      "italian_9\n",
      "italian_9\n",
      "italian_9\n",
      "italian_9\n",
      "italian_9\n",
      "italian_9\n",
      "italian_9\n",
      "italian_9\n",
      "italian_9\n",
      "italian_10\n",
      "italian_10\n",
      "italian_10\n",
      "italian_10\n",
      "italian_10\n",
      "italian_10\n",
      "italian_10\n",
      "italian_10\n",
      "italian_10\n",
      "italian_10\n",
      "italian_10\n",
      "italian_10\n",
      "italian_10\n",
      "italian_10\n",
      "italian_10\n",
      "italian_11\n",
      "italian_11\n",
      "italian_11\n",
      "italian_11\n",
      "italian_11\n",
      "italian_11\n",
      "italian_11\n",
      "italian_11\n",
      "italian_11\n",
      "italian_11\n",
      "italian_11\n",
      "italian_11\n",
      "italian_11\n",
      "italian_11\n",
      "italian_11\n",
      "italian_12\n",
      "italian_12\n",
      "italian_12\n",
      "italian_12\n",
      "italian_12\n",
      "italian_12\n",
      "italian_12\n",
      "italian_12\n",
      "italian_12\n",
      "italian_12\n",
      "italian_12\n",
      "italian_12\n",
      "italian_12\n",
      "italian_12\n",
      "italian_12\n",
      "italian_13\n",
      "italian_13\n",
      "italian_13\n",
      "italian_13\n",
      "italian_13\n",
      "italian_13\n",
      "italian_13\n",
      "italian_13\n",
      "italian_13\n",
      "italian_13\n",
      "italian_13\n",
      "italian_13\n",
      "italian_13\n",
      "italian_13\n",
      "italian_13\n",
      "italian_14\n",
      "italian_14\n",
      "italian_14\n",
      "italian_14\n",
      "italian_14\n",
      "italian_14\n",
      "italian_14\n",
      "italian_14\n",
      "italian_14\n",
      "italian_14\n",
      "italian_14\n",
      "italian_14\n",
      "italian_14\n",
      "italian_14\n",
      "italian_14\n",
      "italian_15\n",
      "italian_15\n",
      "italian_15\n",
      "italian_15\n",
      "italian_15\n",
      "italian_15\n",
      "italian_15\n",
      "italian_15\n",
      "italian_15\n",
      "italian_15\n",
      "italian_15\n",
      "italian_15\n",
      "italian_15\n",
      "italian_15\n",
      "italian_15\n",
      "italian_16\n",
      "italian_16\n",
      "italian_16\n",
      "italian_16\n",
      "italian_16\n",
      "italian_16\n",
      "italian_16\n",
      "italian_16\n",
      "italian_16\n",
      "italian_16\n",
      "italian_16\n",
      "italian_16\n",
      "italian_16\n",
      "italian_16\n",
      "italian_16\n",
      "italian_17\n",
      "italian_17\n",
      "italian_17\n",
      "italian_17\n",
      "italian_17\n",
      "italian_17\n",
      "italian_17\n",
      "italian_17\n",
      "italian_17\n",
      "italian_17\n",
      "italian_17\n",
      "italian_17\n",
      "italian_17\n",
      "italian_17\n",
      "italian_17\n",
      "italian_18\n",
      "italian_18\n",
      "italian_18\n",
      "italian_18\n",
      "italian_18\n",
      "italian_18\n",
      "italian_18\n",
      "italian_18\n",
      "italian_18\n",
      "italian_18\n",
      "italian_18\n",
      "italian_18\n",
      "italian_18\n",
      "italian_18\n",
      "italian_18\n",
      "italian_19\n",
      "italian_19\n",
      "italian_19\n",
      "italian_19\n",
      "italian_19\n",
      "italian_19\n",
      "italian_19\n",
      "italian_19\n",
      "italian_19\n",
      "italian_19\n",
      "italian_19\n",
      "italian_19\n",
      "italian_19\n",
      "italian_19\n",
      "italian_19\n",
      "italian_20\n",
      "italian_20\n",
      "italian_20\n",
      "italian_20\n",
      "italian_20\n",
      "italian_20\n",
      "italian_20\n",
      "italian_20\n",
      "italian_20\n",
      "italian_20\n",
      "italian_20\n",
      "italian_20\n",
      "italian_20\n",
      "italian_20\n",
      "italian_20\n",
      "italian_21\n",
      "italian_21\n",
      "italian_21\n",
      "italian_21\n",
      "italian_21\n",
      "italian_21\n",
      "italian_21\n",
      "italian_21\n",
      "italian_21\n",
      "italian_21\n",
      "italian_21\n",
      "italian_21\n",
      "italian_21\n",
      "italian_21\n",
      "italian_21\n",
      "italian_22\n",
      "italian_22\n",
      "italian_22\n",
      "italian_22\n",
      "italian_22\n",
      "italian_22\n",
      "italian_22\n",
      "italian_22\n",
      "italian_22\n",
      "italian_22\n",
      "italian_22\n",
      "italian_22\n",
      "italian_22\n",
      "italian_22\n",
      "italian_22\n",
      "italian_23\n",
      "italian_23\n",
      "italian_23\n",
      "italian_23\n",
      "italian_23\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "italian_23\n",
      "italian_23\n",
      "italian_23\n",
      "italian_23\n",
      "italian_23\n",
      "italian_23\n",
      "italian_23\n",
      "italian_23\n",
      "italian_23\n",
      "italian_23\n",
      "italian_24\n",
      "italian_24\n",
      "italian_24\n",
      "italian_24\n",
      "italian_24\n",
      "italian_24\n",
      "italian_24\n",
      "italian_24\n",
      "italian_24\n",
      "italian_24\n",
      "italian_24\n",
      "italian_24\n",
      "italian_24\n",
      "italian_24\n",
      "italian_24\n",
      "italian_25\n",
      "italian_25\n",
      "italian_25\n",
      "italian_25\n",
      "italian_25\n",
      "italian_25\n",
      "italian_25\n",
      "italian_25\n",
      "italian_25\n",
      "italian_25\n",
      "italian_25\n",
      "italian_25\n",
      "italian_25\n",
      "italian_25\n",
      "italian_25\n",
      "italian_26\n",
      "italian_26\n",
      "italian_26\n",
      "italian_26\n",
      "italian_26\n",
      "italian_26\n",
      "italian_26\n",
      "italian_26\n",
      "italian_26\n",
      "italian_26\n",
      "italian_26\n",
      "italian_26\n",
      "italian_26\n",
      "italian_26\n",
      "italian_26\n",
      "italian_27\n",
      "italian_27\n",
      "italian_27\n",
      "italian_27\n",
      "italian_27\n",
      "italian_27\n",
      "italian_27\n",
      "italian_27\n",
      "italian_27\n",
      "italian_27\n",
      "italian_27\n",
      "italian_27\n",
      "italian_27\n",
      "italian_27\n",
      "italian_27\n",
      "italian_28\n",
      "italian_28\n",
      "italian_28\n",
      "italian_28\n",
      "italian_28\n",
      "italian_28\n",
      "italian_28\n",
      "italian_28\n",
      "italian_28\n",
      "italian_28\n",
      "italian_28\n",
      "italian_28\n",
      "italian_28\n",
      "italian_28\n",
      "italian_28\n",
      "italian_29\n",
      "italian_29\n",
      "italian_29\n",
      "italian_29\n",
      "italian_29\n",
      "italian_29\n",
      "italian_29\n",
      "italian_29\n",
      "italian_29\n",
      "italian_29\n",
      "italian_29\n",
      "italian_29\n",
      "italian_29\n",
      "italian_29\n",
      "italian_29\n",
      "italian_30\n",
      "italian_30\n",
      "italian_30\n",
      "italian_30\n",
      "italian_30\n",
      "italian_30\n",
      "italian_30\n",
      "italian_30\n",
      "italian_30\n",
      "italian_30\n",
      "italian_30\n",
      "italian_30\n",
      "italian_30\n",
      "italian_30\n",
      "italian_30\n",
      "italian_31\n",
      "italian_31\n",
      "italian_31\n",
      "italian_31\n",
      "italian_31\n",
      "italian_31\n",
      "italian_31\n",
      "italian_31\n",
      "italian_31\n",
      "italian_31\n",
      "italian_31\n",
      "italian_31\n",
      "italian_31\n",
      "italian_31\n",
      "italian_31\n",
      "italian_32\n",
      "italian_32\n",
      "italian_32\n",
      "italian_32\n",
      "italian_32\n",
      "italian_32\n",
      "italian_32\n",
      "italian_32\n",
      "italian_32\n",
      "italian_32\n",
      "italian_32\n",
      "italian_32\n",
      "italian_32\n",
      "italian_32\n",
      "italian_32\n",
      "italian_33\n",
      "italian_33\n",
      "italian_33\n",
      "italian_33\n",
      "italian_33\n",
      "italian_33\n",
      "italian_33\n",
      "italian_33\n",
      "italian_33\n",
      "italian_33\n",
      "italian_33\n",
      "italian_33\n",
      "italian_33\n",
      "italian_33\n",
      "italian_33\n",
      "italian_34\n",
      "italian_34\n",
      "italian_34\n",
      "italian_34\n",
      "italian_34\n",
      "italian_34\n",
      "italian_34\n",
      "italian_34\n",
      "italian_34\n",
      "italian_34\n",
      "italian_34\n",
      "italian_34\n",
      "italian_34\n",
      "italian_34\n",
      "italian_34\n",
      "italian_35\n",
      "italian_35\n",
      "italian_35\n",
      "italian_35\n",
      "italian_35\n",
      "italian_35\n",
      "italian_35\n",
      "italian_35\n",
      "italian_35\n",
      "italian_35\n",
      "italian_35\n",
      "italian_35\n",
      "italian_35\n",
      "italian_35\n",
      "italian_35\n",
      "italian_36\n",
      "italian_36\n",
      "italian_36\n",
      "italian_36\n",
      "italian_36\n",
      "italian_36\n",
      "italian_36\n",
      "italian_36\n",
      "italian_36\n",
      "italian_36\n",
      "italian_36\n",
      "italian_36\n",
      "italian_36\n",
      "italian_36\n",
      "italian_36\n",
      "italian_37\n",
      "italian_37\n",
      "italian_37\n",
      "italian_37\n",
      "italian_37\n",
      "italian_37\n",
      "italian_37\n",
      "italian_37\n",
      "italian_37\n",
      "italian_37\n",
      "italian_37\n",
      "italian_37\n",
      "italian_37\n",
      "italian_37\n",
      "italian_37\n",
      "italian_38\n",
      "italian_38\n",
      "italian_38\n",
      "italian_38\n",
      "italian_38\n",
      "italian_38\n",
      "italian_38\n",
      "italian_38\n",
      "italian_38\n",
      "italian_38\n",
      "italian_38\n",
      "italian_38\n",
      "italian_38\n",
      "italian_38\n",
      "italian_38\n",
      "italian_39\n",
      "italian_39\n",
      "italian_39\n",
      "italian_39\n",
      "italian_39\n",
      "italian_39\n",
      "italian_39\n",
      "italian_39\n",
      "italian_39\n",
      "italian_39\n",
      "italian_39\n",
      "italian_39\n",
      "italian_39\n",
      "italian_39\n",
      "italian_39\n",
      "italian_40\n",
      "italian_40\n",
      "italian_40\n",
      "italian_40\n",
      "italian_40\n",
      "italian_40\n",
      "italian_40\n",
      "italian_40\n",
      "italian_40\n",
      "italian_40\n",
      "italian_40\n",
      "italian_40\n",
      "italian_40\n",
      "italian_40\n",
      "italian_40\n",
      "italian_41\n",
      "italian_41\n",
      "italian_41\n",
      "italian_41\n",
      "italian_41\n",
      "italian_41\n",
      "italian_41\n",
      "italian_41\n",
      "italian_41\n",
      "italian_41\n",
      "italian_41\n",
      "italian_41\n",
      "italian_41\n",
      "italian_41\n",
      "italian_41\n",
      "italian_42\n",
      "italian_42\n",
      "italian_42\n",
      "italian_42\n",
      "italian_42\n",
      "italian_42\n",
      "italian_42\n",
      "italian_42\n",
      "italian_42\n",
      "italian_42\n",
      "italian_42\n",
      "italian_42\n",
      "italian_42\n",
      "italian_42\n",
      "italian_42\n",
      "italian_43\n",
      "italian_43\n",
      "italian_43\n",
      "italian_43\n",
      "italian_43\n",
      "italian_43\n",
      "italian_43\n",
      "italian_43\n",
      "italian_43\n",
      "italian_43\n",
      "italian_43\n",
      "italian_43\n",
      "italian_43\n",
      "italian_43\n",
      "italian_43\n",
      "italian_44\n",
      "italian_44\n",
      "italian_44\n",
      "italian_44\n",
      "italian_44\n",
      "italian_44\n",
      "italian_44\n",
      "italian_44\n",
      "italian_44\n",
      "italian_44\n",
      "italian_44\n",
      "italian_44\n",
      "italian_44\n",
      "italian_44\n",
      "italian_44\n",
      "italian_45\n",
      "italian_45\n",
      "italian_45\n",
      "italian_45\n",
      "italian_45\n",
      "italian_45\n",
      "italian_45\n",
      "italian_45\n",
      "italian_45\n",
      "italian_45\n",
      "italian_45\n",
      "italian_45\n",
      "italian_45\n",
      "italian_45\n",
      "italian_45\n",
      "italian_46\n",
      "italian_46\n",
      "italian_46\n",
      "italian_46\n",
      "italian_46\n",
      "italian_46\n",
      "italian_46\n",
      "italian_46\n",
      "italian_46\n",
      "italian_46\n",
      "italian_46\n",
      "italian_46\n",
      "italian_46\n",
      "italian_46\n",
      "italian_46\n",
      "italian_47\n",
      "italian_47\n",
      "italian_47\n",
      "italian_47\n",
      "italian_47\n",
      "italian_47\n",
      "italian_47\n",
      "italian_47\n",
      "italian_47\n",
      "italian_47\n",
      "italian_47\n",
      "italian_47\n",
      "italian_47\n",
      "italian_47\n",
      "italian_47\n",
      "italian_48\n",
      "italian_48\n",
      "italian_48\n",
      "italian_48\n",
      "italian_48\n",
      "italian_48\n",
      "italian_48\n",
      "italian_48\n",
      "italian_48\n",
      "italian_48\n",
      "italian_48\n",
      "italian_48\n",
      "italian_48\n",
      "italian_48\n",
      "italian_48\n",
      "italian_49\n",
      "italian_49\n",
      "italian_49\n",
      "italian_49\n",
      "italian_49\n",
      "italian_49\n",
      "italian_49\n",
      "italian_49\n",
      "italian_49\n",
      "italian_49\n",
      "italian_49\n",
      "italian_49\n",
      "italian_49\n",
      "italian_49\n",
      "italian_49\n",
      "italian_50\n",
      "italian_50\n",
      "italian_50\n",
      "italian_50\n",
      "italian_50\n",
      "italian_50\n",
      "italian_50\n",
      "italian_50\n",
      "italian_50\n",
      "italian_50\n",
      "italian_50\n",
      "italian_50\n",
      "italian_50\n",
      "italian_50\n",
      "italian_50\n",
      "0\n",
      "20\n",
      "40\n",
      "60\n",
      "80\n",
      "100\n",
      "120\n",
      "140\n",
      "160\n",
      "180\n",
      "200\n",
      "220\n",
      "240\n",
      "260\n",
      "280\n",
      "300\n",
      "320\n",
      "340\n",
      "360\n",
      "380\n",
      "400\n",
      "420\n",
      "440\n",
      "460\n",
      "480\n",
      "500\n",
      "520\n",
      "540\n",
      "560\n",
      "580\n",
      "600\n",
      "620\n",
      "640\n",
      "660\n",
      "680\n",
      "700\n",
      "720\n",
      "740\n",
      "760\n",
      "780\n",
      "800\n",
      "820\n",
      "840\n",
      "860\n",
      "880\n",
      "900\n",
      "920\n",
      "940\n",
      "960\n",
      "980\n",
      "1000\n",
      "1020\n",
      "1040\n",
      "1060\n",
      "1080\n",
      "1100\n",
      "1120\n",
      "1140\n",
      "1160\n",
      "1180\n",
      "1200\n",
      "1220\n",
      "1240\n",
      "1260\n",
      "1280\n",
      "1300\n",
      "1320\n",
      "1340\n",
      "1360\n",
      "1380\n",
      "1400\n",
      "1420\n",
      "1440\n",
      "1460\n",
      "1480\n",
      "1500\n",
      "1520\n",
      "1540\n",
      "1560\n",
      "1580\n",
      "1600\n",
      "1620\n",
      "1640\n",
      "1660\n",
      "1680\n",
      "1700\n",
      "1720\n",
      "1740\n",
      "1760\n",
      "1780\n",
      "1800\n",
      "1820\n",
      "1840\n",
      "1860\n",
      "1880\n",
      "1900\n",
      "1920\n",
      "1940\n",
      "1960\n",
      "1980\n",
      "2000\n",
      "2020\n",
      "2040\n",
      "2060\n",
      "2080\n",
      "2100\n",
      "2120\n",
      "2140\n",
      "2160\n",
      "2180\n",
      "2200\n",
      "2220\n",
      "2240\n",
      "2260\n",
      "2280\n",
      "2300\n",
      "2320\n",
      "2340\n",
      "2360\n",
      "2380\n",
      "2400\n",
      "2420\n",
      "2440\n",
      "2460\n",
      "2480\n",
      "2500\n",
      "2520\n",
      "2540\n",
      "2560\n",
      "2580\n",
      "2600\n",
      "2620\n",
      "2640\n",
      "2660\n",
      "2680\n",
      "2700\n",
      "2720\n",
      "2740\n",
      "2760\n",
      "2780\n",
      "2800\n",
      "2820\n",
      "2840\n",
      "2860\n",
      "2880\n",
      "2900\n",
      "2920\n",
      "2940\n",
      "2960\n",
      "2980\n",
      "3000\n",
      "3020\n",
      "3040\n",
      "3060\n",
      "3080\n",
      "3100\n",
      "3120\n",
      "3140\n",
      "3160\n",
      "3180\n",
      "3200\n",
      "3220\n",
      "3240\n",
      "3260\n",
      "3280\n",
      "3300\n",
      "3320\n",
      "3340\n",
      "3360\n",
      "3380\n",
      "3400\n",
      "3420\n",
      "3440\n",
      "3460\n",
      "3480\n",
      "3500\n",
      "3520\n",
      "3540\n",
      "3560\n",
      "3580\n",
      "3600\n",
      "3620\n",
      "3640\n",
      "3660\n",
      "3680\n",
      "3700\n",
      "3720\n",
      "3740\n",
      "3760\n",
      "3780\n",
      "3800\n",
      "3820\n",
      "3840\n",
      "3860\n",
      "3880\n",
      "3900\n",
      "3920\n",
      "3940\n",
      "3960\n",
      "3980\n",
      "4000\n",
      "4020\n",
      "4040\n",
      "4060\n",
      "4080\n",
      "4100\n",
      "4120\n",
      "4140\n",
      "4160\n",
      "4180\n",
      "4200\n",
      "4220\n",
      "4240\n",
      "4260\n",
      "4280\n",
      "4300\n",
      "4320\n",
      "4340\n",
      "4360\n",
      "4380\n",
      "4400\n",
      "4420\n",
      "4440\n",
      "4460\n",
      "4480\n",
      "4500\n",
      "4520\n",
      "4540\n",
      "4560\n",
      "4580\n",
      "4600\n",
      "4620\n",
      "4640\n",
      "4660\n",
      "4680\n",
      "4700\n",
      "4720\n",
      "4740\n",
      "4760\n",
      "4780\n",
      "4800\n",
      "4820\n",
      "4840\n",
      "4860\n",
      "4880\n",
      "4900\n",
      "4920\n",
      "4940\n",
      "4960\n",
      "4980\n",
      "5000\n",
      "5020\n",
      "5040\n",
      "5060\n",
      "5080\n",
      "5100\n",
      "5120\n",
      "5140\n",
      "5160\n",
      "5180\n",
      "5200\n",
      "5220\n",
      "5240\n",
      "5260\n",
      "5280\n",
      "5300\n",
      "5320\n",
      "5340\n",
      "5360\n",
      "5380\n",
      "5400\n",
      "5420\n",
      "5440\n",
      "5460\n",
      "5480\n",
      "5500\n",
      "5520\n",
      "5540\n",
      "5560\n",
      "5580\n",
      "5600\n",
      "5620\n",
      "5640\n",
      "5660\n",
      "5680\n",
      "5700\n",
      "5720\n",
      "5740\n",
      "5760\n",
      "5780\n",
      "5800\n",
      "5820\n",
      "5840\n",
      "5860\n",
      "5880\n",
      "5900\n",
      "5920\n",
      "5940\n",
      "5960\n",
      "5980\n",
      "6000\n",
      "6020\n",
      "6040\n",
      "6060\n",
      "6080\n",
      "6100\n",
      "6120\n",
      "6140\n",
      "6160\n",
      "6180\n",
      "6200\n",
      "6220\n",
      "6240\n",
      "6260\n",
      "6280\n",
      "6300\n",
      "6320\n",
      "6340\n",
      "6360\n",
      "6380\n",
      "6400\n",
      "6420\n",
      "6440\n",
      "6460\n",
      "6480\n",
      "6500\n",
      "6520\n",
      "6540\n",
      "6560\n",
      "6580\n",
      "6600\n",
      "6620\n",
      "6640\n",
      "6660\n",
      "6680\n",
      "6700\n",
      "6720\n",
      "6740\n",
      "6760\n",
      "6780\n",
      "6800\n",
      "6820\n",
      "6840\n",
      "6860\n",
      "6880\n",
      "6900\n",
      "6920\n",
      "6940\n",
      "6960\n",
      "6980\n",
      "7000\n",
      "7020\n",
      "7040\n",
      "7060\n",
      "7080\n",
      "7100\n",
      "7120\n",
      "7140\n",
      "7160\n",
      "7180\n",
      "7200\n",
      "7220\n",
      "7240\n",
      "7260\n",
      "7280\n",
      "7300\n",
      "7320\n",
      "7340\n",
      "7360\n",
      "7380\n",
      "7400\n",
      "7420\n",
      "7440\n",
      "7460\n",
      "7480\n",
      "7500\n",
      "7520\n",
      "7540\n",
      "7560\n",
      "7580\n",
      "7600\n",
      "7620\n",
      "7640\n",
      "7660\n",
      "7680\n",
      "7700\n",
      "7720\n",
      "7740\n",
      "7760\n",
      "7780\n",
      "7800\n",
      "7820\n",
      "7840\n",
      "7860\n",
      "7880\n",
      "7900\n",
      "7920\n",
      "7940\n",
      "7960\n",
      "7980\n",
      "8000\n",
      "8020\n",
      "8040\n",
      "8060\n",
      "8080\n",
      "8100\n",
      "8120\n",
      "8140\n",
      "8160\n",
      "8180\n",
      "8200\n",
      "8220\n",
      "8240\n",
      "8260\n",
      "8280\n",
      "8300\n",
      "8320\n",
      "8340\n",
      "8360\n",
      "8380\n",
      "8400\n",
      "8420\n",
      "8440\n",
      "8460\n",
      "8480\n",
      "8500\n",
      "8520\n",
      "8540\n",
      "8560\n",
      "8580\n",
      "8600\n",
      "8620\n",
      "8640\n",
      "8660\n",
      "8680\n",
      "8700\n",
      "8720\n",
      "8740\n",
      "8760\n",
      "8780\n",
      "8800\n",
      "8820\n",
      "8840\n",
      "8860\n",
      "8880\n",
      "8900\n",
      "8920\n",
      "8940\n",
      "8960\n",
      "8980\n",
      "9000\n",
      "9020\n",
      "9040\n",
      "9060\n",
      "9080\n",
      "9100\n",
      "9120\n",
      "9140\n",
      "9160\n",
      "9180\n",
      "9200\n",
      "9220\n",
      "9240\n",
      "9260\n",
      "9280\n",
      "9300\n",
      "9320\n",
      "9340\n",
      "9360\n",
      "9380\n",
      "9400\n",
      "9420\n",
      "9440\n",
      "9460\n",
      "9480\n",
      "9500\n",
      "9520\n",
      "9540\n",
      "9560\n",
      "9580\n",
      "9600\n",
      "9620\n",
      "9640\n",
      "9660\n",
      "9680\n",
      "9700\n",
      "9720\n",
      "9740\n",
      "9760\n",
      "9780\n",
      "9800\n",
      "9820\n",
      "9840\n",
      "9860\n",
      "9880\n",
      "9900\n",
      "9920\n",
      "9940\n",
      "9960\n",
      "9980\n",
      "10000\n",
      "10020\n",
      "10040\n",
      "10060\n",
      "10080\n",
      "10100\n",
      "10120\n",
      "10140\n",
      "10160\n",
      "10180\n",
      "10200\n",
      "10220\n",
      "10240\n",
      "10260\n",
      "10280\n",
      "10300\n",
      "10320\n",
      "10340\n",
      "10360\n",
      "10380\n",
      "10400\n",
      "10420\n",
      "10440\n",
      "10460\n",
      "10480\n",
      "10500\n",
      "10520\n",
      "10540\n",
      "10560\n",
      "10580\n",
      "10600\n",
      "10620\n",
      "10640\n",
      "10660\n",
      "10680\n",
      "10700\n",
      "10720\n",
      "10740\n",
      "10760\n",
      "10780\n",
      "10800\n",
      "10820\n",
      "10840\n",
      "10860\n",
      "10880\n",
      "10900\n",
      "10920\n",
      "10940\n",
      "10960\n",
      "10980\n",
      "11000\n",
      "11020\n",
      "11040\n",
      "11060\n",
      "11080\n",
      "11100\n",
      "11120\n",
      "11140\n",
      "11160\n",
      "11180\n",
      "11200\n",
      "11220\n",
      "11240\n",
      "11260\n",
      "11280\n",
      "11300\n",
      "11320\n",
      "11340\n",
      "11360\n",
      "11380\n",
      "11400\n",
      "11420\n",
      "11440\n",
      "11460\n",
      "11480\n",
      "11500\n",
      "11520\n",
      "11540\n",
      "11560\n",
      "11580\n",
      "11600\n",
      "11620\n",
      "11640\n",
      "11660\n",
      "11680\n",
      "11700\n",
      "11720\n",
      "11740\n",
      "11760\n",
      "11780\n",
      "11800\n",
      "11820\n",
      "11840\n",
      "11860\n",
      "11880\n",
      "11900\n",
      "11920\n",
      "11940\n",
      "11960\n",
      "11980\n",
      "12000\n",
      "12020\n",
      "12040\n",
      "12060\n",
      "12080\n",
      "12100\n",
      "12120\n",
      "12140\n",
      "12160\n",
      "12180\n",
      "12200\n",
      "12220\n",
      "12240\n",
      "12260\n",
      "12280\n",
      "12300\n",
      "12320\n",
      "12340\n",
      "12360\n",
      "12380\n",
      "12400\n",
      "12420\n",
      "12440\n",
      "12460\n",
      "12480\n",
      "12500\n",
      "12520\n",
      "12540\n",
      "12560\n",
      "12580\n",
      "12600\n",
      "12620\n",
      "12640\n",
      "12660\n",
      "12680\n",
      "12700\n",
      "12720\n",
      "12740\n",
      "12760\n",
      "12780\n",
      "12800\n",
      "12820\n",
      "12840\n",
      "12860\n",
      "12880\n",
      "12900\n",
      "12920\n",
      "12940\n",
      "12960\n",
      "12980\n",
      "13000\n",
      "13020\n",
      "13040\n",
      "13060\n",
      "13080\n",
      "13100\n",
      "13120\n",
      "13140\n",
      "13160\n",
      "13180\n",
      "13200\n",
      "13220\n",
      "13240\n",
      "13260\n",
      "13280\n",
      "13300\n",
      "13320\n",
      "13340\n",
      "13360\n",
      "13380\n",
      "13400\n",
      "13420\n",
      "13440\n",
      "13460\n",
      "13480\n",
      "13500\n",
      "13520\n",
      "13540\n",
      "13560\n",
      "13580\n",
      "13600\n",
      "13620\n",
      "13640\n",
      "13660\n",
      "13680\n",
      "13700\n",
      "13720\n",
      "13740\n",
      "13760\n",
      "13780\n",
      "13800\n",
      "13820\n",
      "13840\n",
      "13860\n",
      "13880\n",
      "13900\n",
      "13920\n",
      "13940\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "13960\n",
      "13980\n",
      "14000\n",
      "14020\n",
      "14040\n",
      "14060\n",
      "14080\n",
      "14100\n",
      "14120\n",
      "14140\n",
      "14160\n",
      "14180\n",
      "14200\n",
      "14220\n",
      "14240\n",
      "14260\n",
      "14280\n",
      "14300\n",
      "14320\n",
      "14340\n",
      "14360\n",
      "14380\n",
      "14400\n",
      "14420\n",
      "14440\n",
      "14460\n",
      "14480\n",
      "                        phrase restaurantId  review_id  \\\n",
      "0                  goat cheese    italian_0          0   \n",
      "1            excellent service    italian_0          1   \n",
      "2                     el dente    italian_0          2   \n",
      "3                 crappy owner    italian_0          3   \n",
      "4              wednesday night    italian_0          4   \n",
      "5             ravioli aragosta    italian_0          4   \n",
      "6                     yr mouth    italian_0          4   \n",
      "7                tuesday night    italian_0          5   \n",
      "8                greek theater    italian_0          5   \n",
      "9              theater concert    italian_0          5   \n",
      "10              homemade bread    italian_0          6   \n",
      "11            rigatoni antonio    italian_0          6   \n",
      "12          gorgonzola chicken    italian_0          8   \n",
      "13                  pasta alla    italian_0         11   \n",
      "14                alla norcina    italian_0         11   \n",
      "15                   zuppa del    italian_0         11   \n",
      "16                  del giorno    italian_0         11   \n",
      "17               mushroom soup    italian_0         11   \n",
      "18                  pasta alla    italian_0         11   \n",
      "19                alla norcina    italian_0         11   \n",
      "20                tomato sauce    italian_0         11   \n",
      "21               sauce thicker    italian_0         11   \n",
      "22               pasta fagioli    italian_0         16   \n",
      "23                 lame excuse    italian_0         18   \n",
      "24                cheese salad    italian_0         18   \n",
      "25          gorgonzola gnocchi    italian_0         18   \n",
      "26                 squid pasta    italian_0         18   \n",
      "27              gnocchi better    italian_0         18   \n",
      "28                time regular    italian_0         18   \n",
      "29           regular champagne    italian_0         18   \n",
      "...                        ...          ...        ...   \n",
      "30279                bev hills   italian_50      14481   \n",
      "30280  entertainment assistant   italian_50      14481   \n",
      "30281             coopers pale   italian_50      14481   \n",
      "30282                 pale ale   italian_50      14481   \n",
      "30283           tomato potatoe   italian_50      14484   \n",
      "30284             potatoe soup   italian_50      14484   \n",
      "30285              glass wines   italian_50      14484   \n",
      "30286                 il formo   italian_50      14485   \n",
      "30287              formo caldo   italian_50      14485   \n",
      "30288                 mi piace   italian_50      14485   \n",
      "30289          town pasadena..   italian_50      14485   \n",
      "30290          chicken alfredo   italian_50      14485   \n",
      "30291            chicken penne   italian_50      14485   \n",
      "30292               pink sauce   italian_50      14485   \n",
      "30293                  oil dip   italian_50      14485   \n",
      "30294       saturday afternoon   italian_50      14485   \n",
      "30295               okay staff   italian_50      14485   \n",
      "30296              food.. hehe   italian_50      14485   \n",
      "30297           hills location   italian_50      14486   \n",
      "30298             dinning area   italian_50      14486   \n",
      "30299        reason whatsoever   italian_50      14486   \n",
      "30300                 il forno   italian_50      14486   \n",
      "30301              forno caldo   italian_50      14486   \n",
      "30302               warm bread   italian_50      14488   \n",
      "30303              veg options   italian_50      14488   \n",
      "30304         coworkers inform   italian_50      14488   \n",
      "30305             cognac sauce   italian_50      14488   \n",
      "30306       chicken parmagiana   italian_50      14489   \n",
      "30307             oven chicken   italian_50      14489   \n",
      "30308           homemade bread   italian_50      14489   \n",
      "\n",
      "                                                sentence  sentence_id  \n",
      "0      I recommend the fried goat cheese for an appet...            3  \n",
      "1                                     Excellent service.            0  \n",
      "2                    The pasta was el dente and perfect.            3  \n",
      "3                                          CRAPPY owner!            1  \n",
      "4      Love this place ... we chose to dine here on a...            0  \n",
      "5      Love this place ... we chose to dine here on a...            0  \n",
      "6      Love this place ... we chose to dine here on a...            0  \n",
      "7      Not crowded at all on a Tuesday night before a...            2  \n",
      "8      Not crowded at all on a Tuesday night before a...            2  \n",
      "9      Not crowded at all on a Tuesday night before a...            2  \n",
      "10     The homemade bread is terrific along with the ...            0  \n",
      "11     The homemade bread is terrific along with the ...            0  \n",
      "12     I had the Gorgonzola chicken & my BF had the l...            1  \n",
      "13     I had the Pasta alla norcina and the Zuppa del...            0  \n",
      "14     I had the Pasta alla norcina and the Zuppa del...            0  \n",
      "15     I had the Pasta alla norcina and the Zuppa del...            0  \n",
      "16     I had the Pasta alla norcina and the Zuppa del...            0  \n",
      "17     I had the Pasta alla norcina and the Zuppa del...            0  \n",
      "18     The pasta alla norcina was made with tomato sa...            4  \n",
      "19     The pasta alla norcina was made with tomato sa...            4  \n",
      "20     The pasta alla norcina was made with tomato sa...            4  \n",
      "21     The pasta alla norcina was made with tomato sa...            4  \n",
      "22     The pasta fagioli was thick and comforting and...            2  \n",
      "23     There was then some lame excuse about how they...            2  \n",
      "24     We ordered a goat cheese salad that was highly...            6  \n",
      "25     We ordered a goat cheese salad that was highly...            6  \n",
      "26     We ordered a goat cheese salad that was highly...            6  \n",
      "27     Both pastas were great- I liked the gnocchi be...            8  \n",
      "28                  This time regular champagne arrived.           10  \n",
      "29                  This time regular champagne arrived.           10  \n",
      "...                                                  ...          ...  \n",
      "30279  It's a good Italian meal for the price, especi...            2  \n",
      "30280  It's a good Italian meal for the price, especi...            2  \n",
      "30281  One interesting thing i'd like to point out is...            3  \n",
      "30282  One interesting thing i'd like to point out is...            3  \n",
      "30283    Awesome steak sandwich and tomato potatoe soup.            1  \n",
      "30284    Awesome steak sandwich and tomato potatoe soup.            1  \n",
      "30285        Nice by the glass wines as well as bottles.            3  \n",
      "30286  I like my il formo caldo italian restaurant in...            0  \n",
      "30287  I like my il formo caldo italian restaurant in...            0  \n",
      "30288  I like my il formo caldo italian restaurant in...            0  \n",
      "30289  I like my il formo caldo italian restaurant in...            0  \n",
      "30290  I like my il formo caldo italian restaurant in...            0  \n",
      "30291  I like my il formo caldo italian restaurant in...            0  \n",
      "30292  I like my il formo caldo italian restaurant in...            0  \n",
      "30293  I like my il formo caldo italian restaurant in...            0  \n",
      "30294  there is usually not a wait there at all durin...            1  \n",
      "30295  they also have an okay staff for service..but ...            2  \n",
      "30296  they also have an okay staff for service..but ...            2  \n",
      "30297  The prices are very reasonable, especially for...            2  \n",
      "30298  The dinning area is quaint, but if there are m...            3  \n",
      "30299  There is no reason whatsoever to drive far to ...            5  \n",
      "30300  There is no reason whatsoever to drive far to ...            5  \n",
      "30301  There is no reason whatsoever to drive far to ...            5  \n",
      "30302             Yummy warm bread, the best bruschetta.            0  \n",
      "30303  As a vegetarian, their veg options were pretty...            1  \n",
      "30304  My coworkers inform me the chicken in cognac s...            2  \n",
      "30305  My coworkers inform me the chicken in cognac s...            2  \n",
      "30306  I was a little concerned when the menu didn't ...            2  \n",
      "30307  I was a little concerned when the menu didn't ...            2  \n",
      "30308  I especially have to suggest the homemade brea...            3  \n",
      "\n",
      "[30309 rows x 5 columns]\n",
      "reducing 1\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "reducing 2\n",
      "reducing 3\n",
      "finally\n",
      "0\t\n",
      " ['0', '\\n']\n",
      "814\n",
      " ['814\\n']\n",
      "\t/biz/il-capriccio-on-vermont-los-angeles\tIl Capriccio on Vermont\n",
      " ['', '/biz/il-capriccio-on-vermont-los-angeles', 'Il Capriccio on Vermont\\n']\n",
      "1\t\n",
      " ['1', '\\n']\n",
      "714\n",
      " ['714\\n']\n",
      "\t/biz/pomodoro-trattoria-los-angeles-2\tPomodoro Trattoria\n",
      " ['', '/biz/pomodoro-trattoria-los-angeles-2', 'Pomodoro Trattoria\\n']\n",
      "2\t\n",
      " ['2', '\\n']\n",
      "488\n",
      " ['488\\n']\n",
      "\t/biz/speranza-los-angeles\tSperanza\n",
      " ['', '/biz/speranza-los-angeles', 'Speranza\\n']\n",
      "3\t\n",
      " ['3', '\\n']\n",
      "298\n",
      " ['298\\n']\n",
      "\t/biz/frankies-los-angeles-2\tFrankies\n",
      " ['', '/biz/frankies-los-angeles-2', 'Frankies\\n']\n",
      "4\t\n",
      " ['4', '\\n']\n",
      "1001\n",
      " ['1001\\n']\n",
      "\t/biz/the-factory-kitchen-los-angeles\tThe Factory Kitchen\n",
      " ['', '/biz/the-factory-kitchen-los-angeles', 'The Factory Kitchen\\n']\n",
      "5\t\n",
      " ['5', '\\n']\n",
      "1382\n",
      " ['1382\\n']\n",
      "\t/biz/drago-centro-los-angeles\tDRAGO Centro\n",
      " ['', '/biz/drago-centro-los-angeles', 'DRAGO Centro\\n']\n",
      "6\t\n",
      " ['6', '\\n']\n",
      "455\n",
      " ['455\\n']\n",
      "\t/biz/pizzicotto-los-angeles\tPizzicotto\n",
      " ['', '/biz/pizzicotto-los-angeles', 'Pizzicotto\\n']\n",
      "7\t\n",
      " ['7', '\\n']\n",
      "562\n",
      " ['562\\n']\n",
      "\t/biz/spumoni-restaurant-sherman-oaks\tSpumoni Restaurant\n",
      " ['', '/biz/spumoni-restaurant-sherman-oaks', 'Spumoni Restaurant\\n']\n",
      "8\t\n",
      " ['8', '\\n']\n",
      "726\n",
      " ['726\\n']\n",
      "\t/biz/fabiolus-cucina-hollywood\tFabiolus Cucina\n",
      " ['', '/biz/fabiolus-cucina-hollywood', 'Fabiolus Cucina\\n']\n",
      "9\t\n",
      " ['9', '\\n']\n",
      "879\n",
      " ['879\\n']\n",
      "\t/biz/gales-pasadena\tGales\n",
      " ['', '/biz/gales-pasadena', 'Gales\\n']\n",
      "10\t\n",
      " ['10', '\\n']\n",
      "637\n",
      " ['637\\n']\n",
      "\t/biz/madeo-restaurant-los-angeles-3\tMadeo Restaurant\n",
      " ['', '/biz/madeo-restaurant-los-angeles-3', 'Madeo Restaurant\\n']\n",
      "11\t\n",
      " ['11', '\\n']\n",
      "391\n",
      " ['391\\n']\n",
      "\t/biz/gusto-los-angeles\tGusto\n",
      " ['', '/biz/gusto-los-angeles', 'Gusto\\n']\n",
      "12\t\n",
      " ['12', '\\n']\n",
      "259\n",
      " ['259\\n']\n",
      "\t/biz/centanni-trattoria-burbank\tCentanni Trattoria\n",
      " ['', '/biz/centanni-trattoria-burbank', 'Centanni Trattoria\\n']\n",
      "13\t\n",
      " ['13', '\\n']\n",
      "249\n",
      " ['249\\n']\n",
      "\t/biz/cafe-angelino-los-angeles\tCafe Angelino\n",
      " ['', '/biz/cafe-angelino-los-angeles', 'Cafe Angelino\\n']\n",
      "14\t\n",
      " ['14', '\\n']\n",
      "677\n",
      " ['677\\n']\n",
      "\t/biz/la-tavolata-artesia\tLa Tavolata\n",
      " ['', '/biz/la-tavolata-artesia', 'La Tavolata\\n']\n",
      "15\t\n",
      " ['15', '\\n']\n",
      "775\n",
      " ['775\\n']\n",
      "\t/biz/raffaello-ristorante-san-pedro\tRaffaello Ristorante\n",
      " ['', '/biz/raffaello-ristorante-san-pedro', 'Raffaello Ristorante\\n']\n",
      "16\t\n",
      " ['16', '\\n']\n",
      "877\n",
      " ['877\\n']\n",
      "\t/biz/jon-and-vinnys-los-angeles\tJon & Vinnys\n",
      " ['', '/biz/jon-and-vinnys-los-angeles', 'Jon & Vinnys\\n']\n",
      "17\t\n",
      " ['17', '\\n']\n",
      "641\n",
      " ['641\\n']\n",
      "\t/biz/ca-del-sole-toluca-lake-2\tCa Del Sole\n",
      " ['', '/biz/ca-del-sole-toluca-lake-2', 'Ca Del Sole\\n']\n",
      "18\t\n",
      " ['18', '\\n']\n",
      "423\n",
      " ['423\\n']\n",
      "\t/biz/locanda-veneta-los-angeles\tLocanda Veneta\n",
      " ['', '/biz/locanda-veneta-los-angeles', 'Locanda Veneta\\n']\n",
      "19\t\n",
      " ['19', '\\n']\n",
      "260\n",
      " ['260\\n']\n",
      "\t/biz/enzo-and-angela-los-angeles-2\tEnzo & Angela\n",
      " ['', '/biz/enzo-and-angela-los-angeles-2', 'Enzo & Angela\\n']\n",
      "20\t\n",
      " ['20', '\\n']\n",
      "344\n",
      " ['344\\n']\n",
      "\t/biz/italys-little-kitchen-los-angeles\tItalys Little Kitchen\n",
      " ['', '/biz/italys-little-kitchen-los-angeles', 'Italys Little Kitchen\\n']\n",
      "21\t\n",
      " ['21', '\\n']\n",
      "1344\n",
      " ['1344\\n']\n",
      "\t/biz/c-and-o-cucina-marina-del-rey\tC & O Cucina\n",
      " ['', '/biz/c-and-o-cucina-marina-del-rey', 'C & O Cucina\\n']\n",
      "22\t\n",
      " ['22', '\\n']\n",
      "434\n",
      " ['434\\n']\n",
      "\t/biz/chi-spacca-los-angeles\tChi Spacca\n",
      " ['', '/biz/chi-spacca-los-angeles', 'Chi Spacca\\n']\n",
      "23\t\n",
      " ['23', '\\n']\n",
      "214\n",
      " ['214\\n']\n",
      "\t/biz/spartina-los-angeles\tSpartina\n",
      " ['', '/biz/spartina-los-angeles', 'Spartina\\n']\n",
      "24\t\n",
      " ['24', '\\n']\n",
      "247\n",
      " ['247\\n']\n",
      "\t/biz/ancora-cucina-italiana-tarzana\tAncora Cucina Italiana\n",
      " ['', '/biz/ancora-cucina-italiana-tarzana', 'Ancora Cucina Italiana\\n']\n",
      "25\t\n",
      " ['25', '\\n']\n",
      "275\n",
      " ['275\\n']\n",
      "\t/biz/north-italia-santa-monica-3\tNorth Italia\n",
      " ['', '/biz/north-italia-santa-monica-3', 'North Italia\\n']\n",
      "26\t\n",
      " ['26', '\\n']\n",
      "495\n",
      " ['495\\n']\n",
      "\t/biz/romano-cucina-sunset-beach-2\tRomano Cucina\n",
      " ['', '/biz/romano-cucina-sunset-beach-2', 'Romano Cucina\\n']\n",
      "27\t\n",
      " ['27', '\\n']\n",
      "207\n",
      " ['207\\n']\n",
      "\t/biz/palmeri-ristorante-los-angeles\tPalmeri Ristorante\n",
      " ['', '/biz/palmeri-ristorante-los-angeles', 'Palmeri Ristorante\\n']\n",
      "28\t\n",
      " ['28', '\\n']\n",
      "333\n",
      " ['333\\n']\n",
      "\t/biz/brunos-santa-monica\tBrunos\n",
      " ['', '/biz/brunos-santa-monica', 'Brunos\\n']\n",
      "29\t\n",
      " ['29', '\\n']\n",
      "950\n",
      " ['950\\n']\n",
      "\t/biz/trattoria-amici-glendale-2\tTrattoria Amici\n",
      " ['', '/biz/trattoria-amici-glendale-2', 'Trattoria Amici\\n']\n",
      "30\t\n",
      " ['30', '\\n']\n",
      "372\n",
      " ['372\\n']\n",
      "\t/biz/via-veneto-santa-monica\tVia Veneto\n",
      " ['', '/biz/via-veneto-santa-monica', 'Via Veneto\\n']\n",
      "31\t\n",
      " ['31', '\\n']\n",
      "276\n",
      " ['276\\n']\n",
      "\t/biz/novecento-pasta-and-grill-culver-city\tNovecento Pasta & Grill\n",
      " ['', '/biz/novecento-pasta-and-grill-culver-city', 'Novecento Pasta & Grill\\n']\n",
      "32\t\n",
      " ['32', '\\n']\n",
      "265\n",
      " ['265\\n']\n",
      "\t/biz/adagio-ristorante-woodland-hills\tAdagio Ristorante\n",
      " ['', '/biz/adagio-ristorante-woodland-hills', 'Adagio Ristorante\\n']\n",
      "33\t\n",
      " ['33', '\\n']\n",
      "238\n",
      " ['238\\n']\n",
      "\t/biz/buon-gusto-ristorante-mission-hills\tBuon Gusto Ristorante\n",
      " ['', '/biz/buon-gusto-ristorante-mission-hills', 'Buon Gusto Ristorante\\n']\n",
      "34\t\n",
      " ['34', '\\n']\n",
      "303\n",
      " ['303\\n']\n",
      "\t/biz/divina-cucina-montrose\tDivina Cucina\n",
      " ['', '/biz/divina-cucina-montrose', 'Divina Cucina\\n']\n",
      "35\t\n",
      " ['35', '\\n']\n",
      "464\n",
      " ['464\\n']\n",
      "\t/biz/il-tramezzino-beverly-hills-beverly-hills\tIl Tramezzino - Beverly Hills\n",
      " ['', '/biz/il-tramezzino-beverly-hills-beverly-hills', 'Il Tramezzino - Beverly Hills\\n']\n",
      "36\t\n",
      " ['36', '\\n']\n",
      "394\n",
      " ['394\\n']\n",
      "\t/biz/via-alloro-beverly-hills-2\tVia Alloro\n",
      " ['', '/biz/via-alloro-beverly-hills-2', 'Via Alloro\\n']\n",
      "37\t\n",
      " ['37', '\\n']\n",
      "271\n",
      " ['271\\n']\n",
      "\t/biz/la-cava-san-fernando-valley\tLa Cava\n",
      " ['', '/biz/la-cava-san-fernando-valley', 'La Cava\\n']\n",
      "38\t\n",
      " ['38', '\\n']\n",
      "237\n",
      " ['237\\n']\n",
      "\t/biz/betos-simi-valley\tBetos\n",
      " ['', '/biz/betos-simi-valley', 'Betos\\n']\n",
      "39\t\n",
      " ['39', '\\n']\n",
      "529\n",
      " ['529\\n']\n",
      "\t/biz/ago-restaurant-west-hollywood\tAGO Restaurant\n",
      " ['', '/biz/ago-restaurant-west-hollywood', 'AGO Restaurant\\n']\n",
      "40\t\n",
      " ['40', '\\n']\n",
      "434\n",
      " ['434\\n']\n",
      "\t/biz/vino-and-cucina-long-beach\tVino & Cucina\n",
      " ['', '/biz/vino-and-cucina-long-beach', 'Vino & Cucina\\n']\n",
      "41\t\n",
      " ['41', '\\n']\n",
      "254\n",
      " ['254\\n']\n",
      "\t/biz/trastevere-hollywood-2\tTrastevere\n",
      " ['', '/biz/trastevere-hollywood-2', 'Trastevere\\n']\n",
      "42\t\n",
      " ['42', '\\n']\n",
      "279\n",
      " ['279\\n']\n",
      "\t/biz/picarellis-cucina-italiana-long-beach-3\tPicarellis Cucina Italiana\n",
      " ['', '/biz/picarellis-cucina-italiana-long-beach-3', 'Picarellis Cucina Italiana\\n']\n",
      "43\t\n",
      " ['43', '\\n']\n",
      "422\n",
      " ['422\\n']\n",
      "\t/biz/la-scala-beverly-hills-2\tLa Scala\n",
      " ['', '/biz/la-scala-beverly-hills-2', 'La Scala\\n']\n",
      "44\t\n",
      " ['44', '\\n']\n",
      "361\n",
      " ['361\\n']\n",
      "\t/biz/il-ristorante-di-giorgio-baldi-santa-monica\tIl Ristorante di Giorgio Baldi\n",
      " ['', '/biz/il-ristorante-di-giorgio-baldi-santa-monica', 'Il Ristorante di Giorgio Baldi\\n']\n",
      "45\t\n",
      " ['45', '\\n']\n",
      "245\n",
      " ['245\\n']\n",
      "\t/biz/mangiamo-ristorante-and-bar-manhattan-beach\tMangiamo Ristorante & Bar\n",
      " ['', '/biz/mangiamo-ristorante-and-bar-manhattan-beach', 'Mangiamo Ristorante & Bar\\n']\n",
      "46\t\n",
      " ['46', '\\n']\n",
      "351\n",
      " ['351\\n']\n",
      "\t/biz/capo-santa-monica\tCapo\n",
      " ['', '/biz/capo-santa-monica', 'Capo\\n']\n",
      "47\t\n",
      " ['47', '\\n']\n",
      "412\n",
      " ['412\\n']\n",
      "\t/biz/valentino-santa-monica\tValentino\n",
      " ['', '/biz/valentino-santa-monica', 'Valentino\\n']\n",
      "48\t\n",
      " ['48', '\\n']\n",
      "222\n",
      " ['222\\n']\n",
      "\t/biz/locanda-portofino-santa-monica-2\tLocanda Portofino\n",
      " ['', '/biz/locanda-portofino-santa-monica-2', 'Locanda Portofino\\n']\n",
      "49\t\n",
      " ['49', '\\n']\n",
      "213\n",
      " ['213\\n']\n",
      "\t/biz/the-bottle-inn-hermosa-hermosa-beach\tThe Bottle Inn Hermosa\n",
      " ['', '/biz/the-bottle-inn-hermosa-hermosa-beach', 'The Bottle Inn Hermosa\\n']\n",
      "50\t\n",
      " ['50', '\\n']\n",
      "325\n",
      " ['325\\n']\n",
      "\t/biz/francos-italian-restaurant-cypress\tFrancos Italian Restaurant\n",
      " ['', '/biz/francos-italian-restaurant-cypress', 'Francos Italian Restaurant\\n']\n",
      "\n"
     ]
    },
    {
     "ename": "KeyError",
     "evalue": "'italian_18'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-18-b760678b2746>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mrunGene\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'italian'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;32m<ipython-input-17-47e46f7edaf6>\u001b[0m in \u001b[0;36mrunGene\u001b[0;34m(geneName)\u001b[0m\n\u001b[1;32m     15\u001b[0m     \u001b[0mgetFreq\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mgeneName\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0;34m'.csv'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m'test.csv'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     16\u001b[0m     \u001b[0mtoJson\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'test.csv'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m'json.json'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mgeneName\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 17\u001b[0;31m     \u001b[0mgetresult\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'json.json'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0msys\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mstdout\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     18\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     19\u001b[0m \u001b[0;32mif\u001b[0m \u001b[0mDEFINES_ONLY\u001b[0m \u001b[0;34m==\u001b[0m \u001b[0;32mFalse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m<ipython-input-14-518d4a77b264>\u001b[0m in \u001b[0;36mgetresult\u001b[0;34m(inputjson, outputfile)\u001b[0m\n\u001b[1;32m     24\u001b[0m     \u001b[0;32mfor\u001b[0m \u001b[0mrestaurant\u001b[0m \u001b[0;32min\u001b[0m \u001b[0md\u001b[0m\u001b[0;34m:\u001b[0m \u001b[0;31m#[0:5]:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     25\u001b[0m         \u001b[0moutputfile\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mwrite\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'\\n'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 26\u001b[0;31m         \u001b[0moutputfile\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mwrite\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdictIdName\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mrestaurant\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'restaurantId'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     27\u001b[0m \u001b[0;31m#         outputfile.write(restaurant['restaurantName'] + '\\n')\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     28\u001b[0m         \u001b[0mlikes\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mKeyError\u001b[0m: 'italian_18'"
     ]
    }
   ],
   "source": [
    "runGene('italian')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0\t\n",
      " ['0', '\\n']\n",
      "221\n",
      " ['221\\n']\n",
      "\t/biz/the-new-moon-los-angeles\tThe New Moon\n",
      " ['', '/biz/the-new-moon-los-angeles', 'The New Moon\\n']\n",
      "1\t\n",
      " ['1', '\\n']\n",
      "242\n",
      " ['242\\n']\n",
      "\t/biz/northern-cafe-los-angeles\tNorthern Cafe\n",
      " ['', '/biz/northern-cafe-los-angeles', 'Northern Cafe\\n']\n",
      "2\t\n",
      " ['2', '\\n']\n",
      "251\n",
      " ['251\\n']\n",
      "\t/biz/pauls-kitchen-los-angeles\tPauls Kitchen\n",
      " ['', '/biz/pauls-kitchen-los-angeles', 'Pauls Kitchen\\n']\n",
      "3\t\n",
      " ['3', '\\n']\n",
      "201\n",
      " ['201\\n']\n",
      "\t/biz/shin-beijing-los-angeles\tShin Beijing\n",
      " ['', '/biz/shin-beijing-los-angeles', 'Shin Beijing\\n']\n",
      "4\t\n",
      " ['4', '\\n']\n",
      "396\n",
      " ['396\\n']\n",
      "\t/biz/house-of-joy-chinese-restaurant-glendale\tHouse of Joy Chinese Restaurant\n",
      " ['', '/biz/house-of-joy-chinese-restaurant-glendale', 'House of Joy Chinese Restaurant\\n']\n",
      "5\t\n",
      " ['5', '\\n']\n",
      "316\n",
      " ['316\\n']\n",
      "\t/biz/jin-jiang-restaurant-los-angeles\tJin Jiang Restaurant\n",
      " ['', '/biz/jin-jiang-restaurant-los-angeles', 'Jin Jiang Restaurant\\n']\n",
      "6\t\n",
      " ['6', '\\n']\n",
      "239\n",
      " ['239\\n']\n",
      "\t/biz/chyn-king-los-angeles\tChyn King\n",
      " ['', '/biz/chyn-king-los-angeles', 'Chyn King\\n']\n",
      "7\t\n",
      " ['7', '\\n']\n",
      "317\n",
      " ['317\\n']\n",
      "\t/biz/phoenix-inn-chinese-cuisine-los-angeles\tPhoenix Inn Chinese Cuisine\n",
      " ['', '/biz/phoenix-inn-chinese-cuisine-los-angeles', 'Phoenix Inn Chinese Cuisine\\n']\n",
      "8\t\n",
      " ['8', '\\n']\n",
      "337\n",
      " ['337\\n']\n",
      "\t/biz/ixlb-dimsum-eats-los-angeles-2\tixlb DimSum Eats\n",
      " ['', '/biz/ixlb-dimsum-eats-los-angeles-2', 'ixlb DimSum Eats\\n']\n",
      "9\t\n",
      " ['9', '\\n']\n",
      "255\n",
      " ['255\\n']\n",
      "\t/biz/cheng-du-restaurant-los-angeles\tCheng Du Restaurant\n",
      " ['', '/biz/cheng-du-restaurant-los-angeles', 'Cheng Du Restaurant\\n']\n",
      "10\t\n",
      " ['10', '\\n']\n",
      "898\n",
      " ['898\\n']\n",
      "\t/biz/won-kok-restaurant-los-angeles\tWon Kok Restaurant\n",
      " ['', '/biz/won-kok-restaurant-los-angeles', 'Won Kok Restaurant\\n']\n",
      "11\t\n",
      " ['11', '\\n']\n",
      "308\n",
      " ['308\\n']\n",
      "\t/biz/rice-wok-studio-city\tRice Wok\n",
      " ['', '/biz/rice-wok-studio-city', 'Rice Wok\\n']\n",
      "12\t\n",
      " ['12', '\\n']\n",
      "202\n",
      " ['202\\n']\n",
      "\t/biz/hot-wok-north-hollywood\tHot Wok\n",
      " ['', '/biz/hot-wok-north-hollywood', 'Hot Wok\\n']\n",
      "13\t\n",
      " ['13', '\\n']\n",
      "248\n",
      " ['248\\n']\n",
      "\t/biz/little-palace-glendale\tLittle Palace\n",
      " ['', '/biz/little-palace-glendale', 'Little Palace\\n']\n",
      "14\t\n",
      " ['14', '\\n']\n",
      "273\n",
      " ['273\\n']\n",
      "\t/biz/wok-on-the-wild-side-inglewood\tWok On The Wild Side\n",
      " ['', '/biz/wok-on-the-wild-side-inglewood', 'Wok On The Wild Side\\n']\n",
      "15\t\n",
      " ['15', '\\n']\n",
      "291\n",
      " ['291\\n']\n",
      "\t/biz/hop-li-seafood-restaurant-los-angeles\tHop Li Seafood Restaurant\n",
      " ['', '/biz/hop-li-seafood-restaurant-los-angeles', 'Hop Li Seafood Restaurant\\n']\n",
      "16\t\n",
      " ['16', '\\n']\n",
      "1677\n",
      " ['1677\\n']\n",
      "\t/biz/mamas-lu-dumpling-house-monterey-park-4\tMamas Lu Dumpling House\n",
      " ['', '/biz/mamas-lu-dumpling-house-monterey-park-4', 'Mamas Lu Dumpling House\\n']\n",
      "17\t\n",
      " ['17', '\\n']\n",
      "301\n",
      " ['301\\n']\n",
      "\t/biz/mandarin-kitchen-los-angeles\tMandarin Kitchen\n",
      " ['', '/biz/mandarin-kitchen-los-angeles', 'Mandarin Kitchen\\n']\n",
      "18\t\n",
      " ['18', '\\n']\n",
      "343\n",
      " ['343\\n']\n",
      "\t/biz/chinese-deli-t-and-d-north-hollywood-2\tChinese Deli T & D\n",
      " ['', '/biz/chinese-deli-t-and-d-north-hollywood-2', 'Chinese Deli T & D\\n']\n",
      "19\t\n",
      " ['19', '\\n']\n",
      "302\n",
      " ['302\\n']\n",
      "\t/biz/lao-sze-chuan-glendale-5\tLao Sze Chuan\n",
      " ['', '/biz/lao-sze-chuan-glendale-5', 'Lao Sze Chuan\\n']\n",
      "20\t\n",
      " ['20', '\\n']\n",
      "402\n",
      " ['402\\n']\n",
      "\t/biz/twin-dragon-chinese-restaurant-los-angeles\tTwin Dragon Chinese Restaurant\n",
      " ['', '/biz/twin-dragon-chinese-restaurant-los-angeles', 'Twin Dragon Chinese Restaurant\\n']\n",
      "21\t\n",
      " ['21', '\\n']\n",
      "225\n",
      " ['225\\n']\n",
      "\t/biz/green-tea-house-los-angeles\tGreen Tea House\n",
      " ['', '/biz/green-tea-house-los-angeles', 'Green Tea House\\n']\n",
      "22\t\n",
      " ['22', '\\n']\n",
      "228\n",
      " ['228\\n']\n",
      "\t/biz/ping-pong-chinese-cuisine-encino-3\tPing Pong Chinese Cuisine\n",
      " ['', '/biz/ping-pong-chinese-cuisine-encino-3', 'Ping Pong Chinese Cuisine\\n']\n",
      "23\t\n",
      " ['23', '\\n']\n",
      "403\n",
      " ['403\\n']\n",
      "\t/biz/hop-woo-bbq-and-seafood-restaurant-la-los-angeles\tHop Woo BBQ & Seafood Restaurant - LA\n",
      " ['', '/biz/hop-woo-bbq-and-seafood-restaurant-la-los-angeles', 'Hop Woo BBQ & Seafood Restaurant - LA\\n']\n",
      "24\t\n",
      " ['24', '\\n']\n",
      "808\n",
      " ['808\\n']\n",
      "\t/biz/maos-kitchen-venice\tMaos Kitchen\n",
      " ['', '/biz/maos-kitchen-venice', 'Maos Kitchen\\n']\n",
      "25\t\n",
      " ['25', '\\n']\n",
      "256\n",
      " ['256\\n']\n",
      "\t/biz/regent-china-inn-los-angeles\tRegent China Inn\n",
      " ['', '/biz/regent-china-inn-los-angeles', 'Regent China Inn\\n']\n",
      "26\t\n",
      " ['26', '\\n']\n",
      "329\n",
      " ['329\\n']\n",
      "\t/biz/grandview-palace-pasadena\tGrandview Palace\n",
      " ['', '/biz/grandview-palace-pasadena', 'Grandview Palace\\n']\n",
      "27\t\n",
      " ['27', '\\n']\n",
      "533\n",
      " ['533\\n']\n",
      "\t/biz/new-moon-montrose\tNew Moon\n",
      " ['', '/biz/new-moon-montrose', 'New Moon\\n']\n",
      "28\t\n",
      " ['28', '\\n']\n",
      "286\n",
      " ['286\\n']\n",
      "\t/biz/dragon-street-chinese-north-hollywood-2\tDragon Street Chinese\n",
      " ['', '/biz/dragon-street-chinese-north-hollywood-2', 'Dragon Street Chinese\\n']\n",
      "29\t\n",
      " ['29', '\\n']\n",
      "292\n",
      " ['292\\n']\n",
      "\t/biz/silver-palace-chinese-restaurant-whittier-3\tSilver Palace Chinese Restaurant\n",
      " ['', '/biz/silver-palace-chinese-restaurant-whittier-3', 'Silver Palace Chinese Restaurant\\n']\n",
      "30\t\n",
      " ['30', '\\n']\n",
      "201\n",
      " ['201\\n']\n",
      "\t/biz/healthy-wok-sherman-oaks\tHealthy Wok\n",
      " ['', '/biz/healthy-wok-sherman-oaks', 'Healthy Wok\\n']\n",
      "31\t\n",
      " ['31', '\\n']\n",
      "466\n",
      " ['466\\n']\n",
      "\t/biz/szechuan-impression-alhambra-3\tSzechuan Impression\n",
      " ['', '/biz/szechuan-impression-alhambra-3', 'Szechuan Impression\\n']\n",
      "32\t\n",
      " ['32', '\\n']\n",
      "302\n",
      " ['302\\n']\n",
      "\t/biz/chinese-delight-north-hollywood\tChinese Delight\n",
      " ['', '/biz/chinese-delight-north-hollywood', 'Chinese Delight\\n']\n",
      "33\t\n",
      " ['33', '\\n']\n",
      "333\n",
      " ['333\\n']\n",
      "\t/biz/golden-phoenix-lakewood\tGolden Phoenix\n",
      " ['', '/biz/golden-phoenix-lakewood', 'Golden Phoenix\\n']\n",
      "34\t\n",
      " ['34', '\\n']\n",
      "339\n",
      " ['339\\n']\n",
      "\t/biz/chin-chin-beverly-hills\tChin Chin\n",
      " ['', '/biz/chin-chin-beverly-hills', 'Chin Chin\\n']\n",
      "35\t\n",
      " ['35', '\\n']\n",
      "415\n",
      " ['415\\n']\n",
      "\t/biz/ws-china-bistro-redondo-beach\tWs China Bistro\n",
      " ['', '/biz/ws-china-bistro-redondo-beach', 'Ws China Bistro\\n']\n",
      "36\t\n",
      " ['36', '\\n']\n",
      "235\n",
      " ['235\\n']\n",
      "\t/biz/golden-hunan-chinese-restaurant-northridge\tGolden Hunan Chinese Restaurant\n",
      " ['', '/biz/golden-hunan-chinese-restaurant-northridge', 'Golden Hunan Chinese Restaurant\\n']\n",
      "37\t\n",
      " ['37', '\\n']\n",
      "367\n",
      " ['367\\n']\n",
      "\t/biz/hui-tou-xiang-san-gabriel\tHui Tou Xiang\n",
      " ['', '/biz/hui-tou-xiang-san-gabriel', 'Hui Tou Xiang\\n']\n",
      "38\t\n",
      " ['38', '\\n']\n",
      "282\n",
      " ['282\\n']\n",
      "\t/biz/jj-chinese-express-long-beach\tJJ Chinese Express\n",
      " ['', '/biz/jj-chinese-express-long-beach', 'JJ Chinese Express\\n']\n",
      "39\t\n",
      " ['39', '\\n']\n",
      "220\n",
      " ['220\\n']\n",
      "\t/biz/wacky-wok-venice\tWacky Wok\n",
      " ['', '/biz/wacky-wok-venice', 'Wacky Wok\\n']\n",
      "40\t\n",
      " ['40', '\\n']\n",
      "267\n",
      " ['267\\n']\n",
      "\t/biz/hong-kong-express-westminster-3\tHong Kong Express\n",
      " ['', '/biz/hong-kong-express-westminster-3', 'Hong Kong Express\\n']\n",
      "41\t\n",
      " ['41', '\\n']\n",
      "659\n",
      " ['659\\n']\n",
      "\t/biz/chengdu-taste-alhambra\tChengdu Taste\n",
      " ['', '/biz/chengdu-taste-alhambra', 'Chengdu Taste\\n']\n",
      "42\t\n",
      " ['42', '\\n']\n",
      "371\n",
      " ['371\\n']\n",
      "\t/biz/golden-wall-la-mirada\tGolden Wall\n",
      " ['', '/biz/golden-wall-la-mirada', 'Golden Wall\\n']\n",
      "43\t\n",
      " ['43', '\\n']\n",
      "301\n",
      " ['301\\n']\n",
      "\t/biz/yang-chow-pasadena\tYang Chow\n",
      " ['', '/biz/yang-chow-pasadena', 'Yang Chow\\n']\n",
      "44\t\n",
      " ['44', '\\n']\n",
      "234\n",
      " ['234\\n']\n",
      "\t/biz/tasty-kitchen-gardena\tTasty Kitchen\n",
      " ['', '/biz/tasty-kitchen-gardena', 'Tasty Kitchen\\n']\n",
      "45\t\n",
      " ['45', '\\n']\n",
      "492\n",
      " ['492\\n']\n",
      "\t/biz/seafood-port-chinese-restaurant-torrance\tSeafood Port Chinese Restaurant\n",
      " ['', '/biz/seafood-port-chinese-restaurant-torrance', 'Seafood Port Chinese Restaurant\\n']\n",
      "46\t\n",
      " ['46', '\\n']\n",
      "232\n",
      " ['232\\n']\n",
      "\t/biz/harlams-kitchen-rosemead-2\tHarlams Kitchen\n",
      " ['', '/biz/harlams-kitchen-rosemead-2', 'Harlams Kitchen\\n']\n",
      "47\t\n",
      " ['47', '\\n']\n",
      "373\n",
      " ['373\\n']\n",
      "\t/biz/seafood-town-chinese-restaurant-torrance\tSeafood Town Chinese Restaurant\n",
      " ['', '/biz/seafood-town-chinese-restaurant-torrance', 'Seafood Town Chinese Restaurant\\n']\n",
      "48\t\n",
      " ['48', '\\n']\n",
      "599\n",
      " ['599\\n']\n",
      "\t/biz/fortune-cookies-restaurant-los-alamitos\tFortune Cookies Restaurant\n",
      " ['', '/biz/fortune-cookies-restaurant-los-alamitos', 'Fortune Cookies Restaurant\\n']\n",
      "49\t\n",
      " ['49', '\\n']\n",
      "262\n",
      " ['262\\n']\n",
      "\t/biz/the-great-wall-chinese-restaurant-reseda\tThe Great Wall Chinese Restaurant\n",
      " ['', '/biz/the-great-wall-chinese-restaurant-reseda', 'The Great Wall Chinese Restaurant\\n']\n",
      "50\t\n",
      " ['50', '\\n']\n",
      "211\n",
      " ['211\\n']\n",
      "\t/biz/phoenix-food-boutique-south-pasadena\tPhoenix Food Boutique\n",
      " ['', '/biz/phoenix-food-boutique-south-pasadena', 'Phoenix Food Boutique\\n']\n"
     ]
    }
   ],
   "source": [
    "getresult('groupby_resuaurant_phrase2Grams_review.json', open('chinese_result.txt', 'w'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1\n",
      "0 King Szechuan Palace\n",
      "0\n",
      "20\n",
      "40\n",
      "60\n",
      "80\n",
      "                   phrase restaurantId  review_id  \\\n",
      "0          pork intestine   customer_0          0   \n",
      "1            intestine w.   customer_0          0   \n",
      "2            chili pepper   customer_0          0   \n",
      "3          pork intestine   customer_0          0   \n",
      "4            intestine w.   customer_0          0   \n",
      "5            chili pepper   customer_0          0   \n",
      "6            chinese food   customer_0          1   \n",
      "7               mapo tofu   customer_0          1   \n",
      "8            chinese food   customer_0          2   \n",
      "9           szechuan food   customer_0          2   \n",
      "10             food items   customer_0          2   \n",
      "11            pot recipes   customer_0          3   \n",
      "12         soup dumplings   customer_0          3   \n",
      "13                sub par   customer_0          4   \n",
      "14          par dumplings   customer_0          4   \n",
      "15              min drive   customer_0          4   \n",
      "16         soup dumplings   customer_0          5   \n",
      "17       delivery chinese   customer_0          6   \n",
      "18           chinese food   customer_0          6   \n",
      "19            jersey city   customer_0          6   \n",
      "20           pepper steak   customer_0          6   \n",
      "21              shrimp lo   customer_0          6   \n",
      "22                lo mein   customer_0          6   \n",
      "23           krab rangoon   customer_0          6   \n",
      "24              shrimp lo   customer_0          6   \n",
      "25                lo mein   customer_0          6   \n",
      "26         price.the krab   customer_0          6   \n",
      "27           krab rangoon   customer_0          6   \n",
      "28           cream cheese   customer_0          6   \n",
      "29         please forgive   customer_0          7   \n",
      "..                    ...          ...        ...   \n",
      "211           tender beef   customer_0         83   \n",
      "212               mau pau   customer_0         83   \n",
      "213              pau tofu   customer_0         83   \n",
      "214         spicy wontons   customer_0         83   \n",
      "215              pay cash   customer_0         84   \n",
      "216          chinese food   customer_0         85   \n",
      "217         king szechuan   customer_0         85   \n",
      "218       chinese around-   customer_0         86   \n",
      "219            tests- egg   customer_0         86   \n",
      "220             egg rolls   customer_0         86   \n",
      "221             mill take   customer_0         87   \n",
      "222         delivery time   customer_0         88   \n",
      "223          delivery etc   customer_0         88   \n",
      "224       delivery driver   customer_0         88   \n",
      "225         food delivery   customer_0         88   \n",
      "226        chinese option   customer_0         89   \n",
      "227           jersey city   customer_0         89   \n",
      "228         legit attempt   customer_0         89   \n",
      "229         szechuan food   customer_0         89   \n",
      "230               dan dan   customer_0         89   \n",
      "231           dan noodles   customer_0         89   \n",
      "232         spicy noodles   customer_0         89   \n",
      "233        spicy cucumber   customer_0         89   \n",
      "234             time yelp   customer_0         90   \n",
      "235           yelp reader   customer_0         90   \n",
      "236      chinese delivery   customer_0         90   \n",
      "237        delivery place   customer_0         90   \n",
      "238  szechuan peppercorns   customer_0         90   \n",
      "239       szechuan spices   customer_0         91   \n",
      "240           tongue numb   customer_0         91   \n",
      "\n",
      "                                              sentence  sentence_id  \n",
      "0    Dry Sauteed Pork Intestine w. Dried Red Chili ...            1  \n",
      "1    Dry Sauteed Pork Intestine w. Dried Red Chili ...            1  \n",
      "2    Dry Sauteed Pork Intestine w. Dried Red Chili ...            1  \n",
      "3    Dry Sauteed Pork Intestine w. Dried Red Chili ...            3  \n",
      "4    Dry Sauteed Pork Intestine w. Dried Red Chili ...            3  \n",
      "5    Dry Sauteed Pork Intestine w. Dried Red Chili ...            3  \n",
      "6                It's actually authentic Chinese food.            1  \n",
      "7          I ordered the mapo tofu and it was so good!            2  \n",
      "8    Recently moved nearby and this is the first an...            0  \n",
      "9    There is a wide variety of both Americanized a...            2  \n",
      "10   There is a wide variety of both Americanized a...            2  \n",
      "11     Great dry pot recipes, wontons, soup dumplings.            2  \n",
      "12     Great dry pot recipes, wontons, soup dumplings.            2  \n",
      "13   waited an hour and a half for sub par dumpling...            0  \n",
      "14   waited an hour and a half for sub par dumpling...            0  \n",
      "15   Positive they forgot about it because it was d...            2  \n",
      "16                    The best soup dumplings in town.            0  \n",
      "17   This will be our go-to for delivery Chinese fo...            0  \n",
      "18   This will be our go-to for delivery Chinese fo...            0  \n",
      "19   This will be our go-to for delivery Chinese fo...            0  \n",
      "20   Husband had the pepper steak and an order of v...            3  \n",
      "21          I had the shrimp lo mein and krab Rangoon.            5  \n",
      "22          I had the shrimp lo mein and krab Rangoon.            5  \n",
      "23          I had the shrimp lo mein and krab Rangoon.            5  \n",
      "24   The shrimp lo mein was very good, lots of shri...            6  \n",
      "25   The shrimp lo mein was very good, lots of shri...            6  \n",
      "26   The portions were also good for the price.The ...            7  \n",
      "27   The portions were also good for the price.The ...            7  \n",
      "28   The portions were also good for the price.The ...            7  \n",
      "29   I'm not going to go off on them angrily, thoug...            0  \n",
      "..                                                 ...          ...  \n",
      "211  So far I have had 4 different types of \"Double...            5  \n",
      "212  The vegetarian Mau Pau Tofu is soft, silky, an...            7  \n",
      "213  The vegetarian Mau Pau Tofu is soft, silky, an...            7  \n",
      "214  The spicy wontons are a little doughy, but sti...            8  \n",
      "215           DO NOT ORDER ONLINE AND PAY CASH!!!!!!!!            3  \n",
      "216  I've got some pretty terrible Chinese food aro...            1  \n",
      "217  I've got some pretty terrible Chinese food aro...            1  \n",
      "218  Easily the best Chinese around- we've tried th...            0  \n",
      "219  Passed the simplest of tests- egg rolls and th...            2  \n",
      "220  Passed the simplest of tests- egg rolls and th...            2  \n",
      "221  The reviews made me think I might have found a...            0  \n",
      "222  After ordering online I called to check delive...            0  \n",
      "223  I had to call back 4 more times checking on st...            2  \n",
      "224  The delivery driver never showed up, meaning t...            5  \n",
      "225  The delivery driver never showed up, meaning t...            5  \n",
      "226  Finally, we have real Szechuan and a great Chi...            0  \n",
      "227  Finally, we have real Szechuan and a great Chi...            0  \n",
      "228  I haven't been there but I've had them through...            1  \n",
      "229  I haven't been there but I've had them through...            1  \n",
      "230  So far I've had successful versions of double ...            2  \n",
      "231  So far I've had successful versions of double ...            2  \n",
      "232  So far I've had successful versions of double ...            2  \n",
      "233  So far I've had successful versions of double ...            2  \n",
      "234               Long time yelp reader, first review.            0  \n",
      "235               Long time yelp reader, first review.            0  \n",
      "236  We live in Hoboken and have been looking for a...            1  \n",
      "237  We live in Hoboken and have been looking for a...            1  \n",
      "238  First of all I love Szechuan food...specifical...            3  \n",
      "239       This place uses traditional Szechuan spices.            2  \n",
      "240  That's right, you know that spice which makes ...            3  \n",
      "\n",
      "[241 rows x 5 columns]\n",
      "reducing 1\n",
      "reducing 2\n",
      "reducing 3\n",
      "finally\n",
      "0\n",
      " ['0\\n']\n",
      "300\n",
      " ['300\\n']\n",
      "\t/biz/king-szechuan-palace-jersey-city\tKing Szechuan Palace\n",
      " ['', '/biz/king-szechuan-palace-jersey-city', 'King Szechuan Palace\\n']\n",
      "\n",
      "King Szechuan Palace\n",
      "\n",
      "What the Guests loved Most: \n",
      "chinese food\n",
      "mapo tofu\n",
      "jersey city\n",
      "soup dumplings\n",
      "food delivery\n",
      "friday night\n",
      "delivery person\n",
      "seamless reviews\n",
      "delivery man\n",
      "\n",
      "What nedd to be improved: \n",
      "customer service\n",
      "\n",
      "\n",
      "__main__\n"
     ]
    }
   ],
   "source": [
    "customerRestaurant('/biz/king-szechuan-palace-jersey-city', 'King Szechuan Palace')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python [default]",
   "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.5.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}