DataCleaning.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CAMIS</th>\n",
       "      <th>DBA</th>\n",
       "      <th>BORO</th>\n",
       "      <th>BUILDING</th>\n",
       "      <th>STREET</th>\n",
       "      <th>ZIPCODE</th>\n",
       "      <th>PHONE</th>\n",
       "      <th>CUISINE DESCRIPTION</th>\n",
       "      <th>INSPECTION DATE</th>\n",
       "      <th>ACTION</th>\n",
       "      <th>...</th>\n",
       "      <th>RECORD DATE</th>\n",
       "      <th>INSPECTION TYPE</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Community Board</th>\n",
       "      <th>Council District</th>\n",
       "      <th>Census Tract</th>\n",
       "      <th>BIN</th>\n",
       "      <th>BBL</th>\n",
       "      <th>NTA</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>30075445</td>\n",
       "      <td>DOUBLE DRAGON</td>\n",
       "      <td>Bronx</td>\n",
       "      <td>182</td>\n",
       "      <td>EAST  166 STREET</td>\n",
       "      <td>10456.0</td>\n",
       "      <td>7184102838</td>\n",
       "      <td>Chinese</td>\n",
       "      <td>2/24/20</td>\n",
       "      <td>Violations were cited in the following area(s).</td>\n",
       "      <td>...</td>\n",
       "      <td>9/11/21</td>\n",
       "      <td>Cycle Inspection / Re-inspection</td>\n",
       "      <td>40.831591</td>\n",
       "      <td>-73.918842</td>\n",
       "      <td>204.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>18102.0</td>\n",
       "      <td>2002727.0</td>\n",
       "      <td>2.024560e+09</td>\n",
       "      <td>BX14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>30112340</td>\n",
       "      <td>C &amp; J JAMAICAN RESTAURANT AND BAKERY</td>\n",
       "      <td>Queens</td>\n",
       "      <td>24712</td>\n",
       "      <td>S CONDUIT AVE</td>\n",
       "      <td>11422.0</td>\n",
       "      <td>7187122273</td>\n",
       "      <td>Caribbean</td>\n",
       "      <td>1/15/20</td>\n",
       "      <td>Violations were cited in the following area(s).</td>\n",
       "      <td>...</td>\n",
       "      <td>9/11/21</td>\n",
       "      <td>Cycle Inspection / Re-inspection</td>\n",
       "      <td>40.665344</td>\n",
       "      <td>-73.730738</td>\n",
       "      <td>413.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>65600.0</td>\n",
       "      <td>4289451.0</td>\n",
       "      <td>4.136210e+09</td>\n",
       "      <td>QN05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>40356483</td>\n",
       "      <td>KINGSTON BAKE SHOP</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>380</td>\n",
       "      <td>KINGSTON AVENUE</td>\n",
       "      <td>11225.0</td>\n",
       "      <td>7184672047</td>\n",
       "      <td>Jewish/Kosher</td>\n",
       "      <td>8/24/21</td>\n",
       "      <td>Violations were cited in the following area(s).</td>\n",
       "      <td>...</td>\n",
       "      <td>9/11/21</td>\n",
       "      <td>Cycle Inspection / Initial Inspection</td>\n",
       "      <td>40.665687</td>\n",
       "      <td>-73.942554</td>\n",
       "      <td>309.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>33300.0</td>\n",
       "      <td>3034304.0</td>\n",
       "      <td>3.012990e+09</td>\n",
       "      <td>BK63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>40356731</td>\n",
       "      <td>DENNY'S</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>805</td>\n",
       "      <td>PENNSYLVANIA AVENUE</td>\n",
       "      <td>11207.0</td>\n",
       "      <td>7182720301</td>\n",
       "      <td>American</td>\n",
       "      <td>2/4/20</td>\n",
       "      <td>Violations were cited in the following area(s).</td>\n",
       "      <td>...</td>\n",
       "      <td>9/11/21</td>\n",
       "      <td>Cycle Inspection / Initial Inspection</td>\n",
       "      <td>40.657892</td>\n",
       "      <td>-73.890098</td>\n",
       "      <td>305.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>110400.0</td>\n",
       "      <td>3097669.0</td>\n",
       "      <td>3.043470e+09</td>\n",
       "      <td>BK82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>40357217</td>\n",
       "      <td>MBJ - E KIOSK</td>\n",
       "      <td>Queens</td>\n",
       "      <td>3110</td>\n",
       "      <td>THOMSON AVE</td>\n",
       "      <td>11101.0</td>\n",
       "      <td>7184820176</td>\n",
       "      <td>Coffee/Tea</td>\n",
       "      <td>1/9/20</td>\n",
       "      <td>Violations were cited in the following area(s).</td>\n",
       "      <td>...</td>\n",
       "      <td>9/11/21</td>\n",
       "      <td>Pre-permit (Operational) / Initial Inspection</td>\n",
       "      <td>40.744895</td>\n",
       "      <td>-73.935022</td>\n",
       "      <td>402.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>17900.0</td>\n",
       "      <td>4003534.0</td>\n",
       "      <td>4.002780e+09</td>\n",
       "      <td>QN31</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      CAMIS                                   DBA      BORO BUILDING  \\\n",
       "0  30075445                         DOUBLE DRAGON     Bronx      182   \n",
       "1  30112340  C & J JAMAICAN RESTAURANT AND BAKERY    Queens    24712   \n",
       "2  40356483                    KINGSTON BAKE SHOP  Brooklyn      380   \n",
       "3  40356731                               DENNY'S  Brooklyn      805   \n",
       "4  40357217                         MBJ - E KIOSK    Queens     3110   \n",
       "\n",
       "                STREET  ZIPCODE       PHONE CUISINE DESCRIPTION  \\\n",
       "0     EAST  166 STREET  10456.0  7184102838             Chinese   \n",
       "1        S CONDUIT AVE  11422.0  7187122273           Caribbean   \n",
       "2      KINGSTON AVENUE  11225.0  7184672047       Jewish/Kosher   \n",
       "3  PENNSYLVANIA AVENUE  11207.0  7182720301            American   \n",
       "4          THOMSON AVE  11101.0  7184820176          Coffee/Tea   \n",
       "\n",
       "  INSPECTION DATE                                           ACTION  ...  \\\n",
       "0         2/24/20  Violations were cited in the following area(s).  ...   \n",
       "1         1/15/20  Violations were cited in the following area(s).  ...   \n",
       "2         8/24/21  Violations were cited in the following area(s).  ...   \n",
       "3          2/4/20  Violations were cited in the following area(s).  ...   \n",
       "4          1/9/20  Violations were cited in the following area(s).  ...   \n",
       "\n",
       "  RECORD DATE                                INSPECTION TYPE   Latitude  \\\n",
       "0     9/11/21               Cycle Inspection / Re-inspection  40.831591   \n",
       "1     9/11/21               Cycle Inspection / Re-inspection  40.665344   \n",
       "2     9/11/21          Cycle Inspection / Initial Inspection  40.665687   \n",
       "3     9/11/21          Cycle Inspection / Initial Inspection  40.657892   \n",
       "4     9/11/21  Pre-permit (Operational) / Initial Inspection  40.744895   \n",
       "\n",
       "   Longitude Community Board Council District Census Tract        BIN  \\\n",
       "0 -73.918842           204.0             16.0      18102.0  2002727.0   \n",
       "1 -73.730738           413.0             31.0      65600.0  4289451.0   \n",
       "2 -73.942554           309.0             35.0      33300.0  3034304.0   \n",
       "3 -73.890098           305.0             42.0     110400.0  3097669.0   \n",
       "4 -73.935022           402.0             26.0      17900.0  4003534.0   \n",
       "\n",
       "            BBL   NTA  \n",
       "0  2.024560e+09  BX14  \n",
       "1  4.136210e+09  QN05  \n",
       "2  3.012990e+09  BK63  \n",
       "3  3.043470e+09  BK82  \n",
       "4  4.002780e+09  QN31  \n",
       "\n",
       "[5 rows x 26 columns]"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rest_db = pd.read_csv(\"DOHMH_New_York_City_Restaurant_Inspection_Res_Cleaned1.csv\")\n",
    "rest_db.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "12527"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(rest_db)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [],
   "source": [
    "rest_db[\"Duplicate\"] = rest_db.duplicated(keep = 'first')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "False    12527\n",
       "Name: Duplicate, dtype: int64"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rest_db[\"Duplicate\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 12527 entries, 0 to 12526\n",
      "Data columns (total 27 columns):\n",
      " #   Column                 Non-Null Count  Dtype  \n",
      "---  ------                 --------------  -----  \n",
      " 0   CAMIS                  12527 non-null  int64  \n",
      " 1   DBA                    12525 non-null  object \n",
      " 2   BORO                   12527 non-null  object \n",
      " 3   BUILDING               12509 non-null  object \n",
      " 4   STREET                 12527 non-null  object \n",
      " 5   ZIPCODE                12381 non-null  float64\n",
      " 6   PHONE                  12526 non-null  object \n",
      " 7   CUISINE DESCRIPTION    12527 non-null  object \n",
      " 8   INSPECTION DATE        12527 non-null  object \n",
      " 9   ACTION                 12527 non-null  object \n",
      " 10  VIOLATION CODE         12401 non-null  object \n",
      " 11  VIOLATION DESCRIPTION  12440 non-null  object \n",
      " 12  CRITICAL FLAG          12527 non-null  object \n",
      " 13  SCORE                  12097 non-null  float64\n",
      " 14  GRADE                  8144 non-null   object \n",
      " 15  GRADE DATE             7364 non-null   object \n",
      " 16  RECORD DATE            12527 non-null  object \n",
      " 17  INSPECTION TYPE        12527 non-null  object \n",
      " 18  Latitude               12514 non-null  float64\n",
      " 19  Longitude              12514 non-null  float64\n",
      " 20  Community Board        12352 non-null  float64\n",
      " 21  Council District       12352 non-null  float64\n",
      " 22  Census Tract           12352 non-null  float64\n",
      " 23  BIN                    12290 non-null  float64\n",
      " 24  BBL                    12498 non-null  float64\n",
      " 25  NTA                    12352 non-null  object \n",
      " 26  Duplicate              12527 non-null  bool   \n",
      "dtypes: bool(1), float64(9), int64(1), object(16)\n",
      "memory usage: 2.5+ MB\n"
     ]
    }
   ],
   "source": [
    "rest_db.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [],
   "source": [
    "rest_db.drop(['SCORE', 'GRADE','GRADE DATE','RECORD DATE','Community Board','Council District','Census Tract','BIN','BBL','NTA','Duplicate'], axis = 1,inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [],
   "source": [
    "rest_db.rename(columns={'dba': 'restaurant'}, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [],
   "source": [
    "rest_db.to_csv(\"Data/cleaned_db.csv\", index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "new_db = rest_db.dropna()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [],
   "source": [
    "new_db.to_csv(\"Data/cleaned_db2.csv\", index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [],
   "source": [
    "new_db.to_json(\"Data/cleaned_db2.json\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CAMIS</th>\n",
       "      <th>DBA</th>\n",
       "      <th>BORO</th>\n",
       "      <th>BUILDING</th>\n",
       "      <th>STREET</th>\n",
       "      <th>ZIPCODE</th>\n",
       "      <th>PHONE</th>\n",
       "      <th>CUISINE DESCRIPTION</th>\n",
       "      <th>INSPECTION DATE</th>\n",
       "      <th>ACTION</th>\n",
       "      <th>...</th>\n",
       "      <th>RECORD DATE</th>\n",
       "      <th>INSPECTION TYPE</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Community Board</th>\n",
       "      <th>Council District</th>\n",
       "      <th>Census Tract</th>\n",
       "      <th>BIN</th>\n",
       "      <th>BBL</th>\n",
       "      <th>NTA</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>50100495</td>\n",
       "      <td>AUX MERVEILLEUX DE FRED</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>37</td>\n",
       "      <td>8 AVENUE</td>\n",
       "      <td>10014.0</td>\n",
       "      <td>9174751992</td>\n",
       "      <td>Bakery Products/Desserts</td>\n",
       "      <td>2020-02-07</td>\n",
       "      <td>Violations were cited in the following area(s).</td>\n",
       "      <td>...</td>\n",
       "      <td>2021-09-12</td>\n",
       "      <td>Pre-permit (Operational) / Initial Inspection</td>\n",
       "      <td>40.738265</td>\n",
       "      <td>-74.004027</td>\n",
       "      <td>102.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7700.0</td>\n",
       "      <td>1011660.0</td>\n",
       "      <td>1.006260e+09</td>\n",
       "      <td>MN23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>50005479</td>\n",
       "      <td>NEW MING'S KITCHEN</td>\n",
       "      <td>Queens</td>\n",
       "      <td>5615</td>\n",
       "      <td>JUNCTION BLVD</td>\n",
       "      <td>11373.0</td>\n",
       "      <td>7186991625</td>\n",
       "      <td>Chinese</td>\n",
       "      <td>2020-02-10</td>\n",
       "      <td>Violations were cited in the following area(s).</td>\n",
       "      <td>...</td>\n",
       "      <td>2021-09-12</td>\n",
       "      <td>Cycle Inspection / Initial Inspection</td>\n",
       "      <td>40.737097</td>\n",
       "      <td>-73.866017</td>\n",
       "      <td>404.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>44302.0</td>\n",
       "      <td>4047081.0</td>\n",
       "      <td>4.019030e+09</td>\n",
       "      <td>QN25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>50060559</td>\n",
       "      <td>NEW GREAT WALL 1419</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>1419</td>\n",
       "      <td>GRAVESEND NECK ROAD</td>\n",
       "      <td>11229.0</td>\n",
       "      <td>7183765310</td>\n",
       "      <td>Chinese</td>\n",
       "      <td>2020-02-18</td>\n",
       "      <td>Violations were cited in the following area(s).</td>\n",
       "      <td>...</td>\n",
       "      <td>2021-09-12</td>\n",
       "      <td>Cycle Inspection / Re-inspection</td>\n",
       "      <td>40.594708</td>\n",
       "      <td>-73.956308</td>\n",
       "      <td>315.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>58600.0</td>\n",
       "      <td>3200742.0</td>\n",
       "      <td>3.073750e+09</td>\n",
       "      <td>BK17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>50077348</td>\n",
       "      <td>HATFIELDS</td>\n",
       "      <td>Queens</td>\n",
       "      <td>4005</td>\n",
       "      <td>BELL BLVD</td>\n",
       "      <td>11361.0</td>\n",
       "      <td>7182240690</td>\n",
       "      <td>American</td>\n",
       "      <td>2020-01-25</td>\n",
       "      <td>Violations were cited in the following area(s).</td>\n",
       "      <td>...</td>\n",
       "      <td>2021-09-12</td>\n",
       "      <td>Cycle Inspection / Initial Inspection</td>\n",
       "      <td>40.764143</td>\n",
       "      <td>-73.771252</td>\n",
       "      <td>411.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>112300.0</td>\n",
       "      <td>4138270.0</td>\n",
       "      <td>4.062880e+09</td>\n",
       "      <td>QN46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>50015219</td>\n",
       "      <td>MING STAR CHINESE RESTAURANT</td>\n",
       "      <td>Queens</td>\n",
       "      <td>8916</td>\n",
       "      <td>NORTHERN BLVD</td>\n",
       "      <td>11372.0</td>\n",
       "      <td>7184466994</td>\n",
       "      <td>Chinese</td>\n",
       "      <td>2020-02-21</td>\n",
       "      <td>Violations were cited in the following area(s).</td>\n",
       "      <td>...</td>\n",
       "      <td>2021-09-12</td>\n",
       "      <td>Cycle Inspection / Initial Inspection</td>\n",
       "      <td>40.756253</td>\n",
       "      <td>-73.878616</td>\n",
       "      <td>403.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>27700.0</td>\n",
       "      <td>4035408.0</td>\n",
       "      <td>4.014370e+09</td>\n",
       "      <td>QN28</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      CAMIS                           DBA       BORO BUILDING  \\\n",
       "0  50100495       AUX MERVEILLEUX DE FRED  Manhattan       37   \n",
       "1  50005479            NEW MING'S KITCHEN     Queens     5615   \n",
       "2  50060559           NEW GREAT WALL 1419   Brooklyn     1419   \n",
       "3  50077348                     HATFIELDS     Queens     4005   \n",
       "4  50015219  MING STAR CHINESE RESTAURANT     Queens     8916   \n",
       "\n",
       "                STREET  ZIPCODE       PHONE       CUISINE DESCRIPTION  \\\n",
       "0             8 AVENUE  10014.0  9174751992  Bakery Products/Desserts   \n",
       "1        JUNCTION BLVD  11373.0  7186991625                   Chinese   \n",
       "2  GRAVESEND NECK ROAD  11229.0  7183765310                   Chinese   \n",
       "3            BELL BLVD  11361.0  7182240690                  American   \n",
       "4        NORTHERN BLVD  11372.0  7184466994                   Chinese   \n",
       "\n",
       "  INSPECTION DATE                                           ACTION  ...  \\\n",
       "0      2020-02-07  Violations were cited in the following area(s).  ...   \n",
       "1      2020-02-10  Violations were cited in the following area(s).  ...   \n",
       "2      2020-02-18  Violations were cited in the following area(s).  ...   \n",
       "3      2020-01-25  Violations were cited in the following area(s).  ...   \n",
       "4      2020-02-21  Violations were cited in the following area(s).  ...   \n",
       "\n",
       "  RECORD DATE                                INSPECTION TYPE   Latitude  \\\n",
       "0  2021-09-12  Pre-permit (Operational) / Initial Inspection  40.738265   \n",
       "1  2021-09-12          Cycle Inspection / Initial Inspection  40.737097   \n",
       "2  2021-09-12               Cycle Inspection / Re-inspection  40.594708   \n",
       "3  2021-09-12          Cycle Inspection / Initial Inspection  40.764143   \n",
       "4  2021-09-12          Cycle Inspection / Initial Inspection  40.756253   \n",
       "\n",
       "   Longitude Community Board Council District Census Tract        BIN  \\\n",
       "0 -74.004027           102.0              3.0       7700.0  1011660.0   \n",
       "1 -73.866017           404.0             21.0      44302.0  4047081.0   \n",
       "2 -73.956308           315.0             48.0      58600.0  3200742.0   \n",
       "3 -73.771252           411.0             19.0     112300.0  4138270.0   \n",
       "4 -73.878616           403.0             25.0      27700.0  4035408.0   \n",
       "\n",
       "            BBL   NTA  \n",
       "0  1.006260e+09  MN23  \n",
       "1  4.019030e+09  QN25  \n",
       "2  3.073750e+09  BK17  \n",
       "3  4.062880e+09  QN46  \n",
       "4  4.014370e+09  QN28  \n",
       "\n",
       "[5 rows x 26 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rest_df1 = pd.read_excel(\"DOHMH_NYC_Restaurant_Inspection_Aug21.xlsx\")\n",
    "rest_df1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "12090"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(rest_df1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "rest_df1[\"Duplicate\"] = rest_df1.duplicated(keep = 'first')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "False    12090\n",
       "Name: Duplicate, dtype: int64"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rest_df1[\"Duplicate\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 12090 entries, 0 to 12089\n",
      "Data columns (total 27 columns):\n",
      " #   Column                 Non-Null Count  Dtype         \n",
      "---  ------                 --------------  -----         \n",
      " 0   CAMIS                  12090 non-null  int64         \n",
      " 1   DBA                    12088 non-null  object        \n",
      " 2   BORO                   12090 non-null  object        \n",
      " 3   BUILDING               12072 non-null  object        \n",
      " 4   STREET                 12090 non-null  object        \n",
      " 5   ZIPCODE                11950 non-null  float64       \n",
      " 6   PHONE                  12089 non-null  object        \n",
      " 7   CUISINE DESCRIPTION    12090 non-null  object        \n",
      " 8   INSPECTION DATE        12090 non-null  datetime64[ns]\n",
      " 9   ACTION                 12090 non-null  object        \n",
      " 10  VIOLATION CODE         11961 non-null  object        \n",
      " 11  VIOLATION DESCRIPTION  12005 non-null  object        \n",
      " 12  CRITICAL FLAG          12090 non-null  object        \n",
      " 13  SCORE                  11667 non-null  float64       \n",
      " 14  GRADE                  7881 non-null   object        \n",
      " 15  GRADE DATE             7147 non-null   datetime64[ns]\n",
      " 16  RECORD DATE            12090 non-null  datetime64[ns]\n",
      " 17  INSPECTION TYPE        12090 non-null  object        \n",
      " 18  Latitude               12077 non-null  float64       \n",
      " 19  Longitude              12077 non-null  float64       \n",
      " 20  Community Board        11925 non-null  float64       \n",
      " 21  Council District       11925 non-null  float64       \n",
      " 22  Census Tract           11925 non-null  float64       \n",
      " 23  BIN                    11865 non-null  float64       \n",
      " 24  BBL                    12065 non-null  float64       \n",
      " 25  NTA                    11925 non-null  object        \n",
      " 26  Duplicate              12090 non-null  bool          \n",
      "dtypes: bool(1), datetime64[ns](3), float64(9), int64(1), object(13)\n",
      "memory usage: 2.4+ MB\n"
     ]
    }
   ],
   "source": [
    "rest_df1.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "rest_df1.drop(['SCORE', 'GRADE','GRADE DATE','RECORD DATE','Community Board','Council District','Census Tract','BIN','BBL','NTA','Duplicate'], axis = 1,inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 12090 entries, 0 to 12089\n",
      "Data columns (total 16 columns):\n",
      " #   Column                 Non-Null Count  Dtype         \n",
      "---  ------                 --------------  -----         \n",
      " 0   CAMIS                  12090 non-null  int64         \n",
      " 1   DBA                    12088 non-null  object        \n",
      " 2   BORO                   12090 non-null  object        \n",
      " 3   BUILDING               12072 non-null  object        \n",
      " 4   STREET                 12090 non-null  object        \n",
      " 5   ZIPCODE                11950 non-null  float64       \n",
      " 6   PHONE                  12089 non-null  object        \n",
      " 7   CUISINE DESCRIPTION    12090 non-null  object        \n",
      " 8   INSPECTION DATE        12090 non-null  datetime64[ns]\n",
      " 9   ACTION                 12090 non-null  object        \n",
      " 10  VIOLATION CODE         11961 non-null  object        \n",
      " 11  VIOLATION DESCRIPTION  12005 non-null  object        \n",
      " 12  CRITICAL FLAG          12090 non-null  object        \n",
      " 13  INSPECTION TYPE        12090 non-null  object        \n",
      " 14  Latitude               12077 non-null  float64       \n",
      " 15  Longitude              12077 non-null  float64       \n",
      "dtypes: datetime64[ns](1), float64(3), int64(1), object(11)\n",
      "memory usage: 1.5+ MB\n"
     ]
    }
   ],
   "source": [
    "rest_df1.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "rest_df1.rename(columns={'DBA': 'RESTAURANT', 'CUISINE DESCRIPTION':'CUISINE_DESCRIPTION', 'INSPECTION DATE':'INSPECTION_DATE','VIOLATION CODE':'VIOLATION_CODE','VIOLATION DESCRIPTION':'VIOLATION_DESC','CRITICAL FLAG':'CRITICALFLAG','INSPECTION TYPE':'INSPECTIONTYPE'},inplace= True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CAMIS</th>\n",
       "      <th>RESTAURANT</th>\n",
       "      <th>BORO</th>\n",
       "      <th>BUILDING</th>\n",
       "      <th>STREET</th>\n",
       "      <th>ZIPCODE</th>\n",
       "      <th>PHONE</th>\n",
       "      <th>CUISINE_DESCRIPTION</th>\n",
       "      <th>INSPECTION_DATE</th>\n",
       "      <th>ACTION</th>\n",
       "      <th>VIOLATION_CODE</th>\n",
       "      <th>VIOLATION_DESC</th>\n",
       "      <th>CRITICALFLAG</th>\n",
       "      <th>INSPECTIONTYPE</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>50100495</td>\n",
       "      <td>AUX MERVEILLEUX DE FRED</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>37</td>\n",
       "      <td>8 AVENUE</td>\n",
       "      <td>10014.0</td>\n",
       "      <td>9174751992</td>\n",
       "      <td>Bakery Products/Desserts</td>\n",
       "      <td>2020-02-07</td>\n",
       "      <td>Violations were cited in the following area(s).</td>\n",
       "      <td>08A</td>\n",
       "      <td>Facility not vermin proof. Harborage or condit...</td>\n",
       "      <td>Not Critical</td>\n",
       "      <td>Pre-permit (Operational) / Initial Inspection</td>\n",
       "      <td>40.738265</td>\n",
       "      <td>-74.004027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>50005479</td>\n",
       "      <td>NEW MING'S KITCHEN</td>\n",
       "      <td>Queens</td>\n",
       "      <td>5615</td>\n",
       "      <td>JUNCTION BLVD</td>\n",
       "      <td>11373.0</td>\n",
       "      <td>7186991625</td>\n",
       "      <td>Chinese</td>\n",
       "      <td>2020-02-10</td>\n",
       "      <td>Violations were cited in the following area(s).</td>\n",
       "      <td>04L</td>\n",
       "      <td>Evidence of mice or live mice present in facil...</td>\n",
       "      <td>Critical</td>\n",
       "      <td>Cycle Inspection / Initial Inspection</td>\n",
       "      <td>40.737097</td>\n",
       "      <td>-73.866017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>50060559</td>\n",
       "      <td>NEW GREAT WALL 1419</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>1419</td>\n",
       "      <td>GRAVESEND NECK ROAD</td>\n",
       "      <td>11229.0</td>\n",
       "      <td>7183765310</td>\n",
       "      <td>Chinese</td>\n",
       "      <td>2020-02-18</td>\n",
       "      <td>Violations were cited in the following area(s).</td>\n",
       "      <td>06D</td>\n",
       "      <td>Food contact surface not properly washed, rins...</td>\n",
       "      <td>Critical</td>\n",
       "      <td>Cycle Inspection / Re-inspection</td>\n",
       "      <td>40.594708</td>\n",
       "      <td>-73.956308</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>50077348</td>\n",
       "      <td>HATFIELDS</td>\n",
       "      <td>Queens</td>\n",
       "      <td>4005</td>\n",
       "      <td>BELL BLVD</td>\n",
       "      <td>11361.0</td>\n",
       "      <td>7182240690</td>\n",
       "      <td>American</td>\n",
       "      <td>2020-01-25</td>\n",
       "      <td>Violations were cited in the following area(s).</td>\n",
       "      <td>04L</td>\n",
       "      <td>Evidence of mice or live mice present in facil...</td>\n",
       "      <td>Critical</td>\n",
       "      <td>Cycle Inspection / Initial Inspection</td>\n",
       "      <td>40.764143</td>\n",
       "      <td>-73.771252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>50015219</td>\n",
       "      <td>MING STAR CHINESE RESTAURANT</td>\n",
       "      <td>Queens</td>\n",
       "      <td>8916</td>\n",
       "      <td>NORTHERN BLVD</td>\n",
       "      <td>11372.0</td>\n",
       "      <td>7184466994</td>\n",
       "      <td>Chinese</td>\n",
       "      <td>2020-02-21</td>\n",
       "      <td>Violations were cited in the following area(s).</td>\n",
       "      <td>10F</td>\n",
       "      <td>Non-food contact surface improperly constructe...</td>\n",
       "      <td>Not Critical</td>\n",
       "      <td>Cycle Inspection / Initial Inspection</td>\n",
       "      <td>40.756253</td>\n",
       "      <td>-73.878616</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12085</th>\n",
       "      <td>41217162</td>\n",
       "      <td>KINARAS INDIAN FOOD</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>368</td>\n",
       "      <td>MYRTLE AVENUE</td>\n",
       "      <td>11205.0</td>\n",
       "      <td>7182374008</td>\n",
       "      <td>Indian</td>\n",
       "      <td>2021-07-19</td>\n",
       "      <td>Violations were cited in the following area(s).</td>\n",
       "      <td>06E</td>\n",
       "      <td>Sanitized equipment or utensil, including in-u...</td>\n",
       "      <td>Critical</td>\n",
       "      <td>Cycle Inspection / Initial Inspection</td>\n",
       "      <td>40.693182</td>\n",
       "      <td>-73.971487</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12086</th>\n",
       "      <td>41411833</td>\n",
       "      <td>PRET A MANGER</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>2</td>\n",
       "      <td>PARK AVENUE</td>\n",
       "      <td>10016.0</td>\n",
       "      <td>6463601630</td>\n",
       "      <td>Soups/Salads/Sandwiches</td>\n",
       "      <td>2020-02-04</td>\n",
       "      <td>Violations were cited in the following area(s).</td>\n",
       "      <td>10F</td>\n",
       "      <td>Non-food contact surface improperly constructe...</td>\n",
       "      <td>Not Critical</td>\n",
       "      <td>Cycle Inspection / Re-inspection</td>\n",
       "      <td>40.746070</td>\n",
       "      <td>-73.982092</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12087</th>\n",
       "      <td>50095788</td>\n",
       "      <td>SHAXIAN 888</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>6024</td>\n",
       "      <td>7 AVENUE</td>\n",
       "      <td>11220.0</td>\n",
       "      <td>9293970030</td>\n",
       "      <td>Chinese</td>\n",
       "      <td>2020-01-29</td>\n",
       "      <td>Violations were cited in the following area(s).</td>\n",
       "      <td>10F</td>\n",
       "      <td>Non-food contact surface improperly constructe...</td>\n",
       "      <td>Not Critical</td>\n",
       "      <td>Pre-permit (Operational) / Initial Inspection</td>\n",
       "      <td>40.636637</td>\n",
       "      <td>-74.011962</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12088</th>\n",
       "      <td>40369954</td>\n",
       "      <td>VOLARE RESTAURANT</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>147</td>\n",
       "      <td>WEST FOURTH STREET</td>\n",
       "      <td>10012.0</td>\n",
       "      <td>2127772849</td>\n",
       "      <td>Italian</td>\n",
       "      <td>2020-02-04</td>\n",
       "      <td>Violations were cited in the following area(s).</td>\n",
       "      <td>10B</td>\n",
       "      <td>Plumbing not properly installed or maintained;...</td>\n",
       "      <td>Not Critical</td>\n",
       "      <td>Cycle Inspection / Re-inspection</td>\n",
       "      <td>40.731475</td>\n",
       "      <td>-74.000476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12089</th>\n",
       "      <td>50091872</td>\n",
       "      <td>DOMINO'S</td>\n",
       "      <td>Bronx</td>\n",
       "      <td>3869</td>\n",
       "      <td>WHITE PLAINS ROAD</td>\n",
       "      <td>10467.0</td>\n",
       "      <td>7186534618</td>\n",
       "      <td>Pizza</td>\n",
       "      <td>2021-07-21</td>\n",
       "      <td>Violations were cited in the following area(s).</td>\n",
       "      <td>04A</td>\n",
       "      <td>Food Protection Certificate not held by superv...</td>\n",
       "      <td>Critical</td>\n",
       "      <td>Cycle Inspection / Initial Inspection</td>\n",
       "      <td>40.885262</td>\n",
       "      <td>-73.861884</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>12090 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          CAMIS                    RESTAURANT       BORO BUILDING  \\\n",
       "0      50100495       AUX MERVEILLEUX DE FRED  Manhattan       37   \n",
       "1      50005479            NEW MING'S KITCHEN     Queens     5615   \n",
       "2      50060559           NEW GREAT WALL 1419   Brooklyn     1419   \n",
       "3      50077348                     HATFIELDS     Queens     4005   \n",
       "4      50015219  MING STAR CHINESE RESTAURANT     Queens     8916   \n",
       "...         ...                           ...        ...      ...   \n",
       "12085  41217162           KINARAS INDIAN FOOD   Brooklyn      368   \n",
       "12086  41411833                 PRET A MANGER  Manhattan        2   \n",
       "12087  50095788                   SHAXIAN 888   Brooklyn     6024   \n",
       "12088  40369954             VOLARE RESTAURANT  Manhattan      147   \n",
       "12089  50091872                      DOMINO'S      Bronx     3869   \n",
       "\n",
       "                    STREET  ZIPCODE       PHONE       CUISINE_DESCRIPTION  \\\n",
       "0                 8 AVENUE  10014.0  9174751992  Bakery Products/Desserts   \n",
       "1            JUNCTION BLVD  11373.0  7186991625                   Chinese   \n",
       "2      GRAVESEND NECK ROAD  11229.0  7183765310                   Chinese   \n",
       "3                BELL BLVD  11361.0  7182240690                  American   \n",
       "4            NORTHERN BLVD  11372.0  7184466994                   Chinese   \n",
       "...                    ...      ...         ...                       ...   \n",
       "12085        MYRTLE AVENUE  11205.0  7182374008                    Indian   \n",
       "12086          PARK AVENUE  10016.0  6463601630   Soups/Salads/Sandwiches   \n",
       "12087             7 AVENUE  11220.0  9293970030                   Chinese   \n",
       "12088   WEST FOURTH STREET  10012.0  2127772849                   Italian   \n",
       "12089    WHITE PLAINS ROAD  10467.0  7186534618                     Pizza   \n",
       "\n",
       "      INSPECTION_DATE                                           ACTION  \\\n",
       "0          2020-02-07  Violations were cited in the following area(s).   \n",
       "1          2020-02-10  Violations were cited in the following area(s).   \n",
       "2          2020-02-18  Violations were cited in the following area(s).   \n",
       "3          2020-01-25  Violations were cited in the following area(s).   \n",
       "4          2020-02-21  Violations were cited in the following area(s).   \n",
       "...               ...                                              ...   \n",
       "12085      2021-07-19  Violations were cited in the following area(s).   \n",
       "12086      2020-02-04  Violations were cited in the following area(s).   \n",
       "12087      2020-01-29  Violations were cited in the following area(s).   \n",
       "12088      2020-02-04  Violations were cited in the following area(s).   \n",
       "12089      2021-07-21  Violations were cited in the following area(s).   \n",
       "\n",
       "      VIOLATION_CODE                                     VIOLATION_DESC  \\\n",
       "0                08A  Facility not vermin proof. Harborage or condit...   \n",
       "1                04L  Evidence of mice or live mice present in facil...   \n",
       "2                06D  Food contact surface not properly washed, rins...   \n",
       "3                04L  Evidence of mice or live mice present in facil...   \n",
       "4                10F  Non-food contact surface improperly constructe...   \n",
       "...              ...                                                ...   \n",
       "12085            06E  Sanitized equipment or utensil, including in-u...   \n",
       "12086            10F  Non-food contact surface improperly constructe...   \n",
       "12087            10F  Non-food contact surface improperly constructe...   \n",
       "12088            10B  Plumbing not properly installed or maintained;...   \n",
       "12089            04A  Food Protection Certificate not held by superv...   \n",
       "\n",
       "       CRITICALFLAG                                 INSPECTIONTYPE   Latitude  \\\n",
       "0      Not Critical  Pre-permit (Operational) / Initial Inspection  40.738265   \n",
       "1          Critical          Cycle Inspection / Initial Inspection  40.737097   \n",
       "2          Critical               Cycle Inspection / Re-inspection  40.594708   \n",
       "3          Critical          Cycle Inspection / Initial Inspection  40.764143   \n",
       "4      Not Critical          Cycle Inspection / Initial Inspection  40.756253   \n",
       "...             ...                                            ...        ...   \n",
       "12085      Critical          Cycle Inspection / Initial Inspection  40.693182   \n",
       "12086  Not Critical               Cycle Inspection / Re-inspection  40.746070   \n",
       "12087  Not Critical  Pre-permit (Operational) / Initial Inspection  40.636637   \n",
       "12088  Not Critical               Cycle Inspection / Re-inspection  40.731475   \n",
       "12089      Critical          Cycle Inspection / Initial Inspection  40.885262   \n",
       "\n",
       "       Longitude  \n",
       "0     -74.004027  \n",
       "1     -73.866017  \n",
       "2     -73.956308  \n",
       "3     -73.771252  \n",
       "4     -73.878616  \n",
       "...          ...  \n",
       "12085 -73.971487  \n",
       "12086 -73.982092  \n",
       "12087 -74.011962  \n",
       "12088 -74.000476  \n",
       "12089 -73.861884  \n",
       "\n",
       "[12090 rows x 16 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rest_df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['Bakery Products/Desserts' 'Chinese' 'American' 'Other' 'Greek'\n",
      " 'Japanese' 'Sandwiches' 'Pizza' 'Coffee/Tea' 'Vegan' 'Thai' 'Mexican'\n",
      " 'Juice, Smoothies, Fruit Salads' 'Latin American' 'Salads' 'African'\n",
      " 'Korean' 'Italian' 'Indian' 'Irish' 'Mediterranean' 'Caribbean'\n",
      " 'Hamburgers' 'French' 'Tex-Mex' 'Seafood' 'Spanish' 'Chicken'\n",
      " 'Bottled Beverages' 'Donuts' 'Peruvian' 'Southeast Asian'\n",
      " 'Asian/Asian Fusion' 'English' 'Sandwiches/Salads/Mixed Buffet'\n",
      " 'Chinese/Japanese' 'Bagels/Pretzels' 'Jewish/Kosher'\n",
      " 'Soups/Salads/Sandwiches' 'German' 'Middle Eastern' 'Eastern European'\n",
      " 'Russian' 'Hotdogs' 'Barbecue' 'Frozen Desserts' 'Continental'\n",
      " 'Creole/Cajun' 'Turkish' 'Creole' 'Bangladeshi' 'Vegetarian' 'Indonesian'\n",
      " 'Steakhouse' 'Afghan' 'Egyptian' 'Hawaiian' 'Chinese/Cuban' 'Filipino'\n",
      " 'Ethiopian' 'Moroccan' 'New American' 'Southwestern' 'Pakistani'\n",
      " 'Californian' 'Lebanese' 'Portuguese' 'Pancakes/Waffles' 'Australian'\n",
      " 'Scandinavian' 'Soups' 'Polish' 'Soul Food' 'Brazilian' 'Tapas'\n",
      " 'Not Listed/Not Applicable' 'Hotdogs/Pretzels' 'Cajun' 'Iranian'\n",
      " 'Armenian' 'Czech' 'Chilean' 'Basque']\n"
     ]
    }
   ],
   "source": [
    "cuisines = rest_df1['CUISINE_DESCRIPTION'].unique()\n",
    "print (cuisines)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "83"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rest_df1['CUISINE_DESCRIPTION'].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Californian', 'CUISINE_DESCRIPTION'] = 'American'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "82"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rest_df1['CUISINE_DESCRIPTION'].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Hamburgers', 'CUISINE_DESCRIPTION'] = 'American'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Hotdogs/Pretzels', 'CUISINE_DESCRIPTION'] = 'American'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Hotdogs', 'CUISINE_DESCRIPTION'] = 'American'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'New American', 'CUISINE_DESCRIPTION'] = 'American'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Southwestern', 'CUISINE_DESCRIPTION'] = 'American'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Creole', 'CUISINE_DESCRIPTION'] = 'American'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Creole/Cajun', 'CUISINE_DESCRIPTION'] = 'American'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Cajun', 'CUISINE_DESCRIPTION'] = 'American'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Hawaiian', 'CUISINE_DESCRIPTION'] = 'American'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Soul Food', 'CUISINE_DESCRIPTION'] = 'American'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Chinese/Cuban', 'CUISINE_DESCRIPTION'] = 'Chinese'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Chinese/Japanese', 'CUISINE_DESCRIPTION'] = 'Chinese'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Bagels/Pretzels', 'CUISINE_DESCRIPTION'] = 'Bakery'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Bakery Products/Desserts', 'CUISINE_DESCRIPTION'] = 'Bakery'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Donuts', 'CUISINE_DESCRIPTION'] = 'Bakery'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Pancakes/Waffles', 'CUISINE_DESCRIPTION'] = 'Bakery'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Not Listed/Not Applicable', 'CUISINE_DESCRIPTION'] = 'Other'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Vegan', 'CUISINE_DESCRIPTION'] = 'Vegan_Vegetarian'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Vegetarian', 'CUISINE_DESCRIPTION'] = 'Vegan_Vegetarian'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Asian/Asian Fusion', 'CUISINE_DESCRIPTION'] = 'Southeast Asian'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Filipino', 'CUISINE_DESCRIPTION'] = 'Southeast Asian'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Indonesian', 'CUISINE_DESCRIPTION'] = 'Southeast Asian'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Southeast Asian', 'CUISINE_DESCRIPTION'] = 'Southeast Asian'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION']=='Salads','CUISINE_DESCRIPTION']='Soups_Salads_Sandwiches_Beverages'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION']=='Sandwiches','CUISINE_DESCRIPTION']='Soups_Salads_Sandwiches_Beverages'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION']=='Sandwiches/Salads/Mixed Buffet','CUISINE_DESCRIPTION']='Soups_Salads_Sandwiches_Beverages'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION']=='Juice, Smoothies, Fruit Salads','CUISINE_DESCRIPTION']='Soups_Salads_Sandwiches_Beverages'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION']=='Bottled Beverages','CUISINE_DESCRIPTION']='Soups_Salads_Sandwiches_Beverages'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION']=='Soups','CUISINE_DESCRIPTION']='Soups_Salads_Sandwiches_Beverages'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION']=='Soups/Salads/Sandwiches','CUISINE_DESCRIPTION']='Soups_Salads_Sandwiches_Beverages'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Brazilian', 'CUISINE_DESCRIPTION'] = 'Latin American'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Chilean', 'CUISINE_DESCRIPTION'] = 'Latin American'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Peruvian', 'CUISINE_DESCRIPTION'] = 'Latin American'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [],
   "source": [
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Armenian', 'CUISINE_DESCRIPTION'] = 'Middle Eastern'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Iranian', 'CUISINE_DESCRIPTION'] = 'Middle Eastern'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Turkish', 'CUISINE_DESCRIPTION'] = 'Middle Eastern'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Moroccan', 'CUISINE_DESCRIPTION'] = 'Mediterranean'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Lebanese', 'CUISINE_DESCRIPTION'] = 'Mediterranean'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Egyptian', 'CUISINE_DESCRIPTION'] = 'Mediterranean'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Afghan', 'CUISINE_DESCRIPTION'] = 'Indian Subcontinent'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Bangladeshi', 'CUISINE_DESCRIPTION'] = 'Indian Subcontinent'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Indian', 'CUISINE_DESCRIPTION'] = 'Indian Subcontinent'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Pakistani', 'CUISINE_DESCRIPTION'] = 'Indian Subcontinent'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [],
   "source": [
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Ethiopian', 'CUISINE_DESCRIPTION'] = 'African'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [],
   "source": [
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Barbecue', 'CUISINE_DESCRIPTION'] = 'Barbecue & Steakhouse'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Steakhouse', 'CUISINE_DESCRIPTION'] = 'Barbecue & Steakhouse'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [],
   "source": [
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Basque', 'CUISINE_DESCRIPTION'] = 'European'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Continental', 'CUISINE_DESCRIPTION'] = 'European'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Czech', 'CUISINE_DESCRIPTION'] = 'European'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Eastern European', 'CUISINE_DESCRIPTION'] = 'European'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'German', 'CUISINE_DESCRIPTION'] = 'European'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Greek', 'CUISINE_DESCRIPTION'] = 'European'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Polish', 'CUISINE_DESCRIPTION'] = 'European'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Portuguese', 'CUISINE_DESCRIPTION'] = 'European'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Scandinavian', 'CUISINE_DESCRIPTION'] = 'European'\n",
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Russian', 'CUISINE_DESCRIPTION'] = 'European'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [],
   "source": [
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'English', 'CUISINE_DESCRIPTION'] = 'Irish'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [],
   "source": [
    "rest_df1.loc[rest_df1['CUISINE_DESCRIPTION'] == 'Tapas', 'CUISINE_DESCRIPTION'] = 'Spanish'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "31"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rest_df1['CUISINE_DESCRIPTION'].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [],
   "source": [
    "rest_df1.to_csv(\"Data/cleanDb_Aug_31cuisines.csv\", index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [],
   "source": [
    "rest_df1.to_json(\"Data/cleanDb_Aug_31cuisines.json\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [],
   "source": [
    "rest_df1.to_json(\"Data/cleanDb_Aug_31cuisines.json\", orient = 'index')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CAMIS</th>\n",
       "      <th>DBA</th>\n",
       "      <th>BORO</th>\n",
       "      <th>BUILDING</th>\n",
       "      <th>STREET</th>\n",
       "      <th>ZIPCODE</th>\n",
       "      <th>PHONE</th>\n",
       "      <th>CUISINE DESCRIPTION</th>\n",
       "      <th>INSPECTION DATE</th>\n",
       "      <th>ACTION</th>\n",
       "      <th>...</th>\n",
       "      <th>RECORD DATE</th>\n",
       "      <th>INSPECTION TYPE</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Community Board</th>\n",
       "      <th>Council District</th>\n",
       "      <th>Census Tract</th>\n",
       "      <th>BIN</th>\n",
       "      <th>BBL</th>\n",
       "      <th>NTA</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>30075445</td>\n",
       "      <td>AUX MERVEILLEUX DE FRED</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>37</td>\n",
       "      <td>8 AVENUE</td>\n",
       "      <td>10014.0</td>\n",
       "      <td>9174751992</td>\n",
       "      <td>Bakery Products/Desserts</td>\n",
       "      <td>2020-02-07</td>\n",
       "      <td>Violations were cited in the following area(s).</td>\n",
       "      <td>...</td>\n",
       "      <td>2021-09-12</td>\n",
       "      <td>Pre-permit (Operational) / Initial Inspection</td>\n",
       "      <td>40.738265</td>\n",
       "      <td>-74.004027</td>\n",
       "      <td>102.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7700.0</td>\n",
       "      <td>1011660.0</td>\n",
       "      <td>1.006260e+09</td>\n",
       "      <td>MN23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>30112340</td>\n",
       "      <td>NEW MING'S KITCHEN</td>\n",
       "      <td>Queens</td>\n",
       "      <td>5615</td>\n",
       "      <td>JUNCTION BLVD</td>\n",
       "      <td>11373.0</td>\n",
       "      <td>7186991625</td>\n",
       "      <td>Chinese</td>\n",
       "      <td>2020-02-10</td>\n",
       "      <td>Violations were cited in the following area(s).</td>\n",
       "      <td>...</td>\n",
       "      <td>2021-09-12</td>\n",
       "      <td>Cycle Inspection / Initial Inspection</td>\n",
       "      <td>40.737097</td>\n",
       "      <td>-73.866017</td>\n",
       "      <td>404.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>44302.0</td>\n",
       "      <td>4047081.0</td>\n",
       "      <td>4.019030e+09</td>\n",
       "      <td>QN25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>30112340</td>\n",
       "      <td>NEW GREAT WALL 1419</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>1419</td>\n",
       "      <td>GRAVESEND NECK ROAD</td>\n",
       "      <td>11229.0</td>\n",
       "      <td>7183765310</td>\n",
       "      <td>Chinese</td>\n",
       "      <td>2020-02-18</td>\n",
       "      <td>Violations were cited in the following area(s).</td>\n",
       "      <td>...</td>\n",
       "      <td>2021-09-12</td>\n",
       "      <td>Cycle Inspection / Re-inspection</td>\n",
       "      <td>40.594708</td>\n",
       "      <td>-73.956309</td>\n",
       "      <td>315.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>58600.0</td>\n",
       "      <td>3200742.0</td>\n",
       "      <td>3.073750e+09</td>\n",
       "      <td>BK17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>30112340</td>\n",
       "      <td>HATFIELDS</td>\n",
       "      <td>Queens</td>\n",
       "      <td>4005</td>\n",
       "      <td>BELL BLVD</td>\n",
       "      <td>11361.0</td>\n",
       "      <td>7182240690</td>\n",
       "      <td>American</td>\n",
       "      <td>2020-01-25</td>\n",
       "      <td>Violations were cited in the following area(s).</td>\n",
       "      <td>...</td>\n",
       "      <td>2021-09-12</td>\n",
       "      <td>Cycle Inspection / Initial Inspection</td>\n",
       "      <td>40.764143</td>\n",
       "      <td>-73.771252</td>\n",
       "      <td>411.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>112300.0</td>\n",
       "      <td>4138270.0</td>\n",
       "      <td>4.062880e+09</td>\n",
       "      <td>QN46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>30112340</td>\n",
       "      <td>MING STAR CHINESE RESTAURANT</td>\n",
       "      <td>Queens</td>\n",
       "      <td>8916</td>\n",
       "      <td>NORTHERN BLVD</td>\n",
       "      <td>11372.0</td>\n",
       "      <td>7184466994</td>\n",
       "      <td>Chinese</td>\n",
       "      <td>2020-02-21</td>\n",
       "      <td>Violations were cited in the following area(s).</td>\n",
       "      <td>...</td>\n",
       "      <td>2021-09-12</td>\n",
       "      <td>Cycle Inspection / Initial Inspection</td>\n",
       "      <td>40.756253</td>\n",
       "      <td>-73.878616</td>\n",
       "      <td>403.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>27700.0</td>\n",
       "      <td>4035408.0</td>\n",
       "      <td>4.014370e+09</td>\n",
       "      <td>QN28</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      CAMIS                           DBA       BORO BUILDING  \\\n",
       "0  30075445       AUX MERVEILLEUX DE FRED  Manhattan       37   \n",
       "1  30112340            NEW MING'S KITCHEN     Queens     5615   \n",
       "2  30112340           NEW GREAT WALL 1419   Brooklyn     1419   \n",
       "3  30112340                     HATFIELDS     Queens     4005   \n",
       "4  30112340  MING STAR CHINESE RESTAURANT     Queens     8916   \n",
       "\n",
       "                STREET  ZIPCODE       PHONE       CUISINE DESCRIPTION  \\\n",
       "0             8 AVENUE  10014.0  9174751992  Bakery Products/Desserts   \n",
       "1        JUNCTION BLVD  11373.0  7186991625                   Chinese   \n",
       "2  GRAVESEND NECK ROAD  11229.0  7183765310                   Chinese   \n",
       "3            BELL BLVD  11361.0  7182240690                  American   \n",
       "4        NORTHERN BLVD  11372.0  7184466994                   Chinese   \n",
       "\n",
       "  INSPECTION DATE                                           ACTION  ...  \\\n",
       "0      2020-02-07  Violations were cited in the following area(s).  ...   \n",
       "1      2020-02-10  Violations were cited in the following area(s).  ...   \n",
       "2      2020-02-18  Violations were cited in the following area(s).  ...   \n",
       "3      2020-01-25  Violations were cited in the following area(s).  ...   \n",
       "4      2020-02-21  Violations were cited in the following area(s).  ...   \n",
       "\n",
       "  RECORD DATE                                INSPECTION TYPE   Latitude  \\\n",
       "0  2021-09-12  Pre-permit (Operational) / Initial Inspection  40.738265   \n",
       "1  2021-09-12          Cycle Inspection / Initial Inspection  40.737097   \n",
       "2  2021-09-12               Cycle Inspection / Re-inspection  40.594708   \n",
       "3  2021-09-12          Cycle Inspection / Initial Inspection  40.764143   \n",
       "4  2021-09-12          Cycle Inspection / Initial Inspection  40.756253   \n",
       "\n",
       "   Longitude Community Board Council District Census Tract        BIN  \\\n",
       "0 -74.004027           102.0              3.0       7700.0  1011660.0   \n",
       "1 -73.866017           404.0             21.0      44302.0  4047081.0   \n",
       "2 -73.956309           315.0             48.0      58600.0  3200742.0   \n",
       "3 -73.771252           411.0             19.0     112300.0  4138270.0   \n",
       "4 -73.878616           403.0             25.0      27700.0  4035408.0   \n",
       "\n",
       "            BBL   NTA  \n",
       "0  1.006260e+09  MN23  \n",
       "1  4.019030e+09  QN25  \n",
       "2  3.073750e+09  BK17  \n",
       "3  4.062880e+09  QN46  \n",
       "4  4.014370e+09  QN28  \n",
       "\n",
       "[5 rows x 26 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "violationdf = pd.read_excel(\"DOHMH_NYC_Restaurant_Inspection_Results.xlsx\")\n",
    "violationdf.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "43452"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(violationdf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "violationdf.drop(['CAMIS','BUILDING','STREET','ZIPCODE','ACTION','SCORE', 'GRADE','GRADE DATE','RECORD DATE','Community Board','Council District','Census Tract','BIN','BBL','NTA'], axis = 1,inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 43452 entries, 0 to 43451\n",
      "Data columns (total 11 columns):\n",
      " #   Column                 Non-Null Count  Dtype         \n",
      "---  ------                 --------------  -----         \n",
      " 0   DBA                    43447 non-null  object        \n",
      " 1   BORO                   43452 non-null  object        \n",
      " 2   PHONE                  43451 non-null  object        \n",
      " 3   CUISINE DESCRIPTION    43452 non-null  object        \n",
      " 4   INSPECTION DATE        43452 non-null  datetime64[ns]\n",
      " 5   VIOLATION CODE         43115 non-null  object        \n",
      " 6   VIOLATION DESCRIPTION  43302 non-null  object        \n",
      " 7   CRITICAL FLAG          43452 non-null  object        \n",
      " 8   INSPECTION TYPE        43452 non-null  object        \n",
      " 9   Latitude               43419 non-null  float64       \n",
      " 10  Longitude              43419 non-null  float64       \n",
      "dtypes: datetime64[ns](1), float64(2), object(8)\n",
      "memory usage: 3.6+ MB\n"
     ]
    }
   ],
   "source": [
    "violationdf.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 118,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>DBA</th>\n",
       "      <th>BORO</th>\n",
       "      <th>PHONE</th>\n",
       "      <th>CUISINE DESCRIPTION</th>\n",
       "      <th>INSPECTION DATE</th>\n",
       "      <th>VIOLATION CODE</th>\n",
       "      <th>VIOLATION DESCRIPTION</th>\n",
       "      <th>CRITICAL FLAG</th>\n",
       "      <th>INSPECTION TYPE</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AUX MERVEILLEUX DE FRED</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>9174751992</td>\n",
       "      <td>Bakery Products/Desserts</td>\n",
       "      <td>2020-02-07</td>\n",
       "      <td>08A</td>\n",
       "      <td>Facility not vermin proof. Harborage or condit...</td>\n",
       "      <td>Not Critical</td>\n",
       "      <td>Pre-permit (Operational) / Initial Inspection</td>\n",
       "      <td>40.738265</td>\n",
       "      <td>-74.004027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NEW MING'S KITCHEN</td>\n",
       "      <td>Queens</td>\n",
       "      <td>7186991625</td>\n",
       "      <td>Chinese</td>\n",
       "      <td>2020-02-10</td>\n",
       "      <td>04L</td>\n",
       "      <td>Evidence of mice or live mice present in facil...</td>\n",
       "      <td>Critical</td>\n",
       "      <td>Cycle Inspection / Initial Inspection</td>\n",
       "      <td>40.737097</td>\n",
       "      <td>-73.866017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NEW GREAT WALL 1419</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>7183765310</td>\n",
       "      <td>Chinese</td>\n",
       "      <td>2020-02-18</td>\n",
       "      <td>06D</td>\n",
       "      <td>Food contact surface not properly washed, rins...</td>\n",
       "      <td>Critical</td>\n",
       "      <td>Cycle Inspection / Re-inspection</td>\n",
       "      <td>40.594708</td>\n",
       "      <td>-73.956309</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>HATFIELDS</td>\n",
       "      <td>Queens</td>\n",
       "      <td>7182240690</td>\n",
       "      <td>American</td>\n",
       "      <td>2020-01-25</td>\n",
       "      <td>04L</td>\n",
       "      <td>Evidence of mice or live mice present in facil...</td>\n",
       "      <td>Critical</td>\n",
       "      <td>Cycle Inspection / Initial Inspection</td>\n",
       "      <td>40.764143</td>\n",
       "      <td>-73.771252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>MING STAR CHINESE RESTAURANT</td>\n",
       "      <td>Queens</td>\n",
       "      <td>7184466994</td>\n",
       "      <td>Chinese</td>\n",
       "      <td>2020-02-21</td>\n",
       "      <td>10F</td>\n",
       "      <td>Non-food contact surface improperly constructe...</td>\n",
       "      <td>Not Critical</td>\n",
       "      <td>Cycle Inspection / Initial Inspection</td>\n",
       "      <td>40.756253</td>\n",
       "      <td>-73.878616</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43443</th>\n",
       "      <td>CITY SUBS</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>7186361777</td>\n",
       "      <td>Sandwiches</td>\n",
       "      <td>2021-08-30</td>\n",
       "      <td>04L</td>\n",
       "      <td>Evidence of mice or live mice present in facil...</td>\n",
       "      <td>Critical</td>\n",
       "      <td>Cycle Inspection / Initial Inspection</td>\n",
       "      <td>40.680557</td>\n",
       "      <td>-73.977661</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43444</th>\n",
       "      <td>PITA PAN</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>7188323876</td>\n",
       "      <td>Middle Eastern</td>\n",
       "      <td>2020-01-08</td>\n",
       "      <td>06C</td>\n",
       "      <td>Food not protected from potential source of co...</td>\n",
       "      <td>Critical</td>\n",
       "      <td>Cycle Inspection / Re-inspection</td>\n",
       "      <td>40.671963</td>\n",
       "      <td>-73.977336</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43448</th>\n",
       "      <td>LROOM CAFE</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>3473273952</td>\n",
       "      <td>Coffee/Tea</td>\n",
       "      <td>2020-01-14</td>\n",
       "      <td>04N</td>\n",
       "      <td>Filth flies or food/refuse/sewage-associated (...</td>\n",
       "      <td>Critical</td>\n",
       "      <td>Cycle Inspection / Initial Inspection</td>\n",
       "      <td>40.736596</td>\n",
       "      <td>-73.995017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43449</th>\n",
       "      <td>BROOKLYN MOON CAFE</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>7188557149</td>\n",
       "      <td>Caribbean</td>\n",
       "      <td>2020-01-08</td>\n",
       "      <td>04L</td>\n",
       "      <td>Evidence of mice or live mice present in facil...</td>\n",
       "      <td>Critical</td>\n",
       "      <td>Cycle Inspection / Re-inspection</td>\n",
       "      <td>40.686474</td>\n",
       "      <td>-73.974828</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43451</th>\n",
       "      <td>OXOMOCO</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>6466884180</td>\n",
       "      <td>Mexican</td>\n",
       "      <td>2020-02-05</td>\n",
       "      <td>20F</td>\n",
       "      <td>Current letter grade sign not posted.</td>\n",
       "      <td>Not Critical</td>\n",
       "      <td>Administrative Miscellaneous / Initial Inspection</td>\n",
       "      <td>40.730047</td>\n",
       "      <td>-73.955685</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>32718 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                DBA       BORO       PHONE  \\\n",
       "0           AUX MERVEILLEUX DE FRED  Manhattan  9174751992   \n",
       "1                NEW MING'S KITCHEN     Queens  7186991625   \n",
       "2               NEW GREAT WALL 1419   Brooklyn  7183765310   \n",
       "3                         HATFIELDS     Queens  7182240690   \n",
       "4      MING STAR CHINESE RESTAURANT     Queens  7184466994   \n",
       "...                             ...        ...         ...   \n",
       "43443                     CITY SUBS   Brooklyn  7186361777   \n",
       "43444                      PITA PAN   Brooklyn  7188323876   \n",
       "43448                    LROOM CAFE  Manhattan  3473273952   \n",
       "43449            BROOKLYN MOON CAFE   Brooklyn  7188557149   \n",
       "43451                       OXOMOCO   Brooklyn  6466884180   \n",
       "\n",
       "            CUISINE DESCRIPTION INSPECTION DATE VIOLATION CODE  \\\n",
       "0      Bakery Products/Desserts      2020-02-07            08A   \n",
       "1                       Chinese      2020-02-10            04L   \n",
       "2                       Chinese      2020-02-18            06D   \n",
       "3                      American      2020-01-25            04L   \n",
       "4                       Chinese      2020-02-21            10F   \n",
       "...                         ...             ...            ...   \n",
       "43443                Sandwiches      2021-08-30            04L   \n",
       "43444            Middle Eastern      2020-01-08            06C   \n",
       "43448                Coffee/Tea      2020-01-14            04N   \n",
       "43449                 Caribbean      2020-01-08            04L   \n",
       "43451                   Mexican      2020-02-05            20F   \n",
       "\n",
       "                                   VIOLATION DESCRIPTION CRITICAL FLAG  \\\n",
       "0      Facility not vermin proof. Harborage or condit...  Not Critical   \n",
       "1      Evidence of mice or live mice present in facil...      Critical   \n",
       "2      Food contact surface not properly washed, rins...      Critical   \n",
       "3      Evidence of mice or live mice present in facil...      Critical   \n",
       "4      Non-food contact surface improperly constructe...  Not Critical   \n",
       "...                                                  ...           ...   \n",
       "43443  Evidence of mice or live mice present in facil...      Critical   \n",
       "43444  Food not protected from potential source of co...      Critical   \n",
       "43448  Filth flies or food/refuse/sewage-associated (...      Critical   \n",
       "43449  Evidence of mice or live mice present in facil...      Critical   \n",
       "43451              Current letter grade sign not posted.  Not Critical   \n",
       "\n",
       "                                         INSPECTION TYPE   Latitude  Longitude  \n",
       "0          Pre-permit (Operational) / Initial Inspection  40.738265 -74.004027  \n",
       "1                  Cycle Inspection / Initial Inspection  40.737097 -73.866017  \n",
       "2                       Cycle Inspection / Re-inspection  40.594708 -73.956309  \n",
       "3                  Cycle Inspection / Initial Inspection  40.764143 -73.771252  \n",
       "4                  Cycle Inspection / Initial Inspection  40.756253 -73.878616  \n",
       "...                                                  ...        ...        ...  \n",
       "43443              Cycle Inspection / Initial Inspection  40.680557 -73.977661  \n",
       "43444                   Cycle Inspection / Re-inspection  40.671963 -73.977336  \n",
       "43448              Cycle Inspection / Initial Inspection  40.736596 -73.995017  \n",
       "43449                   Cycle Inspection / Re-inspection  40.686474 -73.974828  \n",
       "43451  Administrative Miscellaneous / Initial Inspection  40.730047 -73.955685  \n",
       "\n",
       "[32718 rows x 11 columns]"
      ]
     },
     "execution_count": 118,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "violdf1 = violationdf.groupby('DBA')\n",
    "violdf1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {},
   "outputs": [
    {
     "ename": "AttributeError",
     "evalue": "'DataFrameGroupBy' object has no attribute 'to_csv'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-78-1f7e76cacb39>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mvioldf1\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mto_csv\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m\"Data/Violations.csv\"\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mindex\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;32mFalse\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;32m~/opt/anaconda3/lib/python3.8/site-packages/pandas/core/groupby/groupby.py\u001b[0m in \u001b[0;36m__getattr__\u001b[0;34m(self, attr)\u001b[0m\n\u001b[1;32m    750\u001b[0m             \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mattr\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    751\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 752\u001b[0;31m         raise AttributeError(\n\u001b[0m\u001b[1;32m    753\u001b[0m             \u001b[0;34mf\"'{type(self).__name__}' object has no attribute '{attr}'\"\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    754\u001b[0m         )\n",
      "\u001b[0;31mAttributeError\u001b[0m: 'DataFrameGroupBy' object has no attribute 'to_csv'"
     ]
    }
   ],
   "source": [
    "violdf1.to_csv(\"Data/Violations.csv\", index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "violdf2 = violationdf.sort_values(by = ['DBA'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>DBA</th>\n",
       "      <th>BORO</th>\n",
       "      <th>PHONE</th>\n",
       "      <th>CUISINE DESCRIPTION</th>\n",
       "      <th>INSPECTION DATE</th>\n",
       "      <th>VIOLATION CODE</th>\n",
       "      <th>VIOLATION DESCRIPTION</th>\n",
       "      <th>CRITICAL FLAG</th>\n",
       "      <th>INSPECTION TYPE</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>26307</th>\n",
       "      <td>#1 NATURAL JUICE BAR</td>\n",
       "      <td>Queens</td>\n",
       "      <td>3479565161</td>\n",
       "      <td>Juice, Smoothies, Fruit Salads</td>\n",
       "      <td>2020-02-06</td>\n",
       "      <td>08A</td>\n",
       "      <td>Facility not vermin proof. Harborage or condit...</td>\n",
       "      <td>Not Critical</td>\n",
       "      <td>Cycle Inspection / Re-inspection</td>\n",
       "      <td>40.703054</td>\n",
       "      <td>-73.908096</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16745</th>\n",
       "      <td>#1 NATURAL JUICE BAR</td>\n",
       "      <td>Queens</td>\n",
       "      <td>3479565161</td>\n",
       "      <td>Juice, Smoothies, Fruit Salads</td>\n",
       "      <td>2020-02-06</td>\n",
       "      <td>04N</td>\n",
       "      <td>Filth flies or food/refuse/sewage-associated (...</td>\n",
       "      <td>Critical</td>\n",
       "      <td>Cycle Inspection / Re-inspection</td>\n",
       "      <td>40.703054</td>\n",
       "      <td>-73.908096</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>928</th>\n",
       "      <td>#1 SABOR LATINO RESTAURANT</td>\n",
       "      <td>Bronx</td>\n",
       "      <td>7186532222</td>\n",
       "      <td>Latin American</td>\n",
       "      <td>2020-01-16</td>\n",
       "      <td>10H</td>\n",
       "      <td>Proper sanitization not provided for utensil w...</td>\n",
       "      <td>Not Critical</td>\n",
       "      <td>Cycle Inspection / Re-inspection</td>\n",
       "      <td>40.891176</td>\n",
       "      <td>-73.858591</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42452</th>\n",
       "      <td>#1 SABOR LATINO RESTAURANT</td>\n",
       "      <td>Bronx</td>\n",
       "      <td>7186532222</td>\n",
       "      <td>Latin American</td>\n",
       "      <td>2020-01-16</td>\n",
       "      <td>04N</td>\n",
       "      <td>Filth flies or food/refuse/sewage-associated (...</td>\n",
       "      <td>Critical</td>\n",
       "      <td>Cycle Inspection / Re-inspection</td>\n",
       "      <td>40.891176</td>\n",
       "      <td>-73.858591</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11124</th>\n",
       "      <td>#1 SABOR LATINO RESTAURANT</td>\n",
       "      <td>Bronx</td>\n",
       "      <td>7186532222</td>\n",
       "      <td>Latin American</td>\n",
       "      <td>2020-01-16</td>\n",
       "      <td>08A</td>\n",
       "      <td>Facility not vermin proof. Harborage or condit...</td>\n",
       "      <td>Not Critical</td>\n",
       "      <td>Cycle Inspection / Re-inspection</td>\n",
       "      <td>40.891176</td>\n",
       "      <td>-73.858591</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25740</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>6467246756</td>\n",
       "      <td>Asian/Asian Fusion</td>\n",
       "      <td>2020-03-06</td>\n",
       "      <td>06F</td>\n",
       "      <td>Wiping cloths soiled or not stored in sanitizi...</td>\n",
       "      <td>Critical</td>\n",
       "      <td>Cycle Inspection / Initial Inspection</td>\n",
       "      <td>40.728921</td>\n",
       "      <td>-73.988472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25775</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Queens</td>\n",
       "      <td>6465949646</td>\n",
       "      <td>American</td>\n",
       "      <td>2020-01-22</td>\n",
       "      <td>10F</td>\n",
       "      <td>Non-food contact surface improperly constructe...</td>\n",
       "      <td>Not Critical</td>\n",
       "      <td>Cycle Inspection / Initial Inspection</td>\n",
       "      <td>40.694746</td>\n",
       "      <td>-73.751174</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30488</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>6467246756</td>\n",
       "      <td>Asian/Asian Fusion</td>\n",
       "      <td>2020-03-06</td>\n",
       "      <td>08A</td>\n",
       "      <td>Facility not vermin proof. Harborage or condit...</td>\n",
       "      <td>Not Critical</td>\n",
       "      <td>Cycle Inspection / Initial Inspection</td>\n",
       "      <td>40.728921</td>\n",
       "      <td>-73.988472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31851</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>6467246756</td>\n",
       "      <td>Asian/Asian Fusion</td>\n",
       "      <td>2020-03-06</td>\n",
       "      <td>04L</td>\n",
       "      <td>Evidence of mice or live mice present in facil...</td>\n",
       "      <td>Critical</td>\n",
       "      <td>Cycle Inspection / Initial Inspection</td>\n",
       "      <td>40.728921</td>\n",
       "      <td>-73.988472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40856</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>6467246756</td>\n",
       "      <td>Asian/Asian Fusion</td>\n",
       "      <td>2020-03-06</td>\n",
       "      <td>06D</td>\n",
       "      <td>Food contact surface not properly washed, rins...</td>\n",
       "      <td>Critical</td>\n",
       "      <td>Cycle Inspection / Initial Inspection</td>\n",
       "      <td>40.728921</td>\n",
       "      <td>-73.988472</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>43452 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                              DBA       BORO       PHONE  \\\n",
       "26307        #1 NATURAL JUICE BAR     Queens  3479565161   \n",
       "16745        #1 NATURAL JUICE BAR     Queens  3479565161   \n",
       "928    #1 SABOR LATINO RESTAURANT      Bronx  7186532222   \n",
       "42452  #1 SABOR LATINO RESTAURANT      Bronx  7186532222   \n",
       "11124  #1 SABOR LATINO RESTAURANT      Bronx  7186532222   \n",
       "...                           ...        ...         ...   \n",
       "25740                         NaN  Manhattan  6467246756   \n",
       "25775                         NaN     Queens  6465949646   \n",
       "30488                         NaN  Manhattan  6467246756   \n",
       "31851                         NaN  Manhattan  6467246756   \n",
       "40856                         NaN  Manhattan  6467246756   \n",
       "\n",
       "                  CUISINE DESCRIPTION INSPECTION DATE VIOLATION CODE  \\\n",
       "26307  Juice, Smoothies, Fruit Salads      2020-02-06            08A   \n",
       "16745  Juice, Smoothies, Fruit Salads      2020-02-06            04N   \n",
       "928                    Latin American      2020-01-16            10H   \n",
       "42452                  Latin American      2020-01-16            04N   \n",
       "11124                  Latin American      2020-01-16            08A   \n",
       "...                               ...             ...            ...   \n",
       "25740              Asian/Asian Fusion      2020-03-06            06F   \n",
       "25775                        American      2020-01-22            10F   \n",
       "30488              Asian/Asian Fusion      2020-03-06            08A   \n",
       "31851              Asian/Asian Fusion      2020-03-06            04L   \n",
       "40856              Asian/Asian Fusion      2020-03-06            06D   \n",
       "\n",
       "                                   VIOLATION DESCRIPTION CRITICAL FLAG  \\\n",
       "26307  Facility not vermin proof. Harborage or condit...  Not Critical   \n",
       "16745  Filth flies or food/refuse/sewage-associated (...      Critical   \n",
       "928    Proper sanitization not provided for utensil w...  Not Critical   \n",
       "42452  Filth flies or food/refuse/sewage-associated (...      Critical   \n",
       "11124  Facility not vermin proof. Harborage or condit...  Not Critical   \n",
       "...                                                  ...           ...   \n",
       "25740  Wiping cloths soiled or not stored in sanitizi...      Critical   \n",
       "25775  Non-food contact surface improperly constructe...  Not Critical   \n",
       "30488  Facility not vermin proof. Harborage or condit...  Not Critical   \n",
       "31851  Evidence of mice or live mice present in facil...      Critical   \n",
       "40856  Food contact surface not properly washed, rins...      Critical   \n",
       "\n",
       "                             INSPECTION TYPE   Latitude  Longitude  \n",
       "26307       Cycle Inspection / Re-inspection  40.703054 -73.908096  \n",
       "16745       Cycle Inspection / Re-inspection  40.703054 -73.908096  \n",
       "928         Cycle Inspection / Re-inspection  40.891176 -73.858591  \n",
       "42452       Cycle Inspection / Re-inspection  40.891176 -73.858591  \n",
       "11124       Cycle Inspection / Re-inspection  40.891176 -73.858591  \n",
       "...                                      ...        ...        ...  \n",
       "25740  Cycle Inspection / Initial Inspection  40.728921 -73.988472  \n",
       "25775  Cycle Inspection / Initial Inspection  40.694746 -73.751174  \n",
       "30488  Cycle Inspection / Initial Inspection  40.728921 -73.988472  \n",
       "31851  Cycle Inspection / Initial Inspection  40.728921 -73.988472  \n",
       "40856  Cycle Inspection / Initial Inspection  40.728921 -73.988472  \n",
       "\n",
       "[43452 rows x 11 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "violdf2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 43452 entries, 26307 to 40856\n",
      "Data columns (total 7 columns):\n",
      " #   Column                 Non-Null Count  Dtype         \n",
      "---  ------                 --------------  -----         \n",
      " 0   DBA                    43447 non-null  object        \n",
      " 1   BORO                   43452 non-null  object        \n",
      " 2   INSPECTION DATE        43452 non-null  datetime64[ns]\n",
      " 3   VIOLATION CODE         43115 non-null  object        \n",
      " 4   VIOLATION DESCRIPTION  43302 non-null  object        \n",
      " 5   CRITICAL FLAG          43452 non-null  object        \n",
      " 6   INSPECTION TYPE        43452 non-null  object        \n",
      "dtypes: datetime64[ns](1), object(6)\n",
      "memory usage: 2.7+ MB\n"
     ]
    }
   ],
   "source": [
    "violdf2.drop(['PHONE','CUISINE DESCRIPTION','Latitude','Longitude'], axis = 1,inplace = True)\n",
    "violdf2.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 43452 entries, 26307 to 40856\n",
      "Data columns (total 5 columns):\n",
      " #   Column                 Non-Null Count  Dtype \n",
      "---  ------                 --------------  ----- \n",
      " 0   DBA                    43447 non-null  object\n",
      " 1   BORO                   43452 non-null  object\n",
      " 2   VIOLATION CODE         43115 non-null  object\n",
      " 3   VIOLATION DESCRIPTION  43302 non-null  object\n",
      " 4   CRITICAL FLAG          43452 non-null  object\n",
      "dtypes: object(5)\n",
      "memory usage: 2.0+ MB\n"
     ]
    }
   ],
   "source": [
    "violdf2.drop(['INSPECTION DATE','INSPECTION TYPE'], axis = 1,inplace = True)\n",
    "violdf2.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "violdf2.to_csv('Data/Violations1.csv', index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "metadata": {},
   "outputs": [],
   "source": [
    "violdf2.to_csv('Data/Violations.csv', index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {},
   "outputs": [],
   "source": [
    "violdf2.to_json('Data/violations.json',orient = 'index')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "metadata": {},
   "outputs": [],
   "source": [
    "violdf2.reset_index(drop=True, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "metadata": {},
   "outputs": [],
   "source": [
    "violdf2.to_json('Data/violations.json',orient = 'index')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 43452 entries, 0 to 43451\n",
      "Data columns (total 6 columns):\n",
      " #   Column                 Non-Null Count  Dtype         \n",
      "---  ------                 --------------  -----         \n",
      " 0   DBA                    43447 non-null  object        \n",
      " 1   INSPECTION DATE        43452 non-null  datetime64[ns]\n",
      " 2   VIOLATION CODE         43115 non-null  object        \n",
      " 3   VIOLATION DESCRIPTION  43302 non-null  object        \n",
      " 4   CRITICAL FLAG          43452 non-null  object        \n",
      " 5   INSPECTION TYPE        43452 non-null  object        \n",
      "dtypes: datetime64[ns](1), object(5)\n",
      "memory usage: 2.0+ MB\n"
     ]
    }
   ],
   "source": [
    "violdf2.drop(['BORO','PHONE','CUISINE DESCRIPTION','Latitude','Longitude'], axis = 1,inplace = True)\n",
    "violdf2.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 43452 entries, 0 to 43451\n",
      "Data columns (total 5 columns):\n",
      " #   Column                 Non-Null Count  Dtype \n",
      "---  ------                 --------------  ----- \n",
      " 0   DBA                    43447 non-null  object\n",
      " 1   VIOLATION CODE         43115 non-null  object\n",
      " 2   VIOLATION DESCRIPTION  43302 non-null  object\n",
      " 3   CRITICAL FLAG          43452 non-null  object\n",
      " 4   INSPECTION TYPE        43452 non-null  object\n",
      "dtypes: object(5)\n",
      "memory usage: 1.7+ MB\n"
     ]
    }
   ],
   "source": [
    "violdf2.drop(['INSPECTION DATE'], axis = 1,inplace = True)\n",
    "violdf2.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "metadata": {},
   "outputs": [],
   "source": [
    "violdf2.to_json('Data/violations_5fields.json',orient = 'index')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "metadata": {},
   "outputs": [],
   "source": [
    "violdf2.to_csv('Data/Violations_5fields.csv', index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 43452 entries, 0 to 43451\n",
      "Data columns (total 4 columns):\n",
      " #   Column                 Non-Null Count  Dtype \n",
      "---  ------                 --------------  ----- \n",
      " 0   DBA                    43447 non-null  object\n",
      " 1   VIOLATION CODE         43115 non-null  object\n",
      " 2   VIOLATION DESCRIPTION  43302 non-null  object\n",
      " 3   CRITICAL FLAG          43452 non-null  object\n",
      "dtypes: object(4)\n",
      "memory usage: 1.3+ MB\n"
     ]
    }
   ],
   "source": [
    "violdf2.drop(['INSPECTION TYPE'], axis = 1,inplace = True)\n",
    "violdf2.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "metadata": {},
   "outputs": [],
   "source": [
    "violdf2.rename(columns={'DBA': 'RESTAURANT', 'VIOLATION CODE':'VIOLATION_CODE','VIOLATION DESCRIPTION':'VIOLATION_DESC','CRITICAL FLAG':'CRITICALFLAG'},inplace= True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 43452 entries, 0 to 43451\n",
      "Data columns (total 4 columns):\n",
      " #   Column          Non-Null Count  Dtype \n",
      "---  ------          --------------  ----- \n",
      " 0   RESTAURANT      43447 non-null  object\n",
      " 1   VIOLATION_CODE  43115 non-null  object\n",
      " 2   VIOLATION_DESC  43302 non-null  object\n",
      " 3   CRITICALFLAG    43452 non-null  object\n",
      "dtypes: object(4)\n",
      "memory usage: 1.3+ MB\n"
     ]
    }
   ],
   "source": [
    "violdf2.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "metadata": {},
   "outputs": [],
   "source": [
    "finaldf = violdf2.dropna()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "metadata": {},
   "outputs": [],
   "source": [
    "finaldf.to_csv('Data/Violations_4fields.csv', index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 104,
   "metadata": {},
   "outputs": [],
   "source": [
    "finaldf.to_json('Data/violations_4fields.json',orient = 'index')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Testing sqlalchemy connection"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sqlalchemy.ext.automap import automap_base\n",
    "from sqlalchemy.orm import Session\n",
    "from sqlalchemy import create_engine, func\n",
    "import config"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "metadata": {},
   "outputs": [],
   "source": [
    "database = 'restaurant_db'\n",
    "engine = create_engine(f'postgresql://postgres:{config.password}@localhost:5432/{database}')\n",
    "\n",
    "# reflect an existing database into a new model\n",
    "Base = automap_base()\n",
    "# reflect the tables\n",
    "Base.prepare(engine, reflect=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['restaurants', 'violations']"
      ]
     },
     "execution_count": 114,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Base.classes.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'Restaurant': ('#1 NATURAL JUICE BAR',)},\n",
       " {'Restaurant': ('#1 NATURAL JUICE BAR',)},\n",
       " {'Restaurant': ('#1 SABOR LATINO RESTAURANT',)},\n",
       " {'Restaurant': ('#1 SABOR LATINO RESTAURANT',)},\n",
       " {'Restaurant': ('#1 SABOR LATINO RESTAURANT',)},\n",
       " {'Restaurant': ('$1 PIZZA',)},\n",
       " {'Restaurant': ('$1 PIZZA',)},\n",
       " {'Restaurant': ('$1 PIZZA',)},\n",
       " {'Restaurant': ('$1 PIZZA',)},\n",
       " {'Restaurant': ('& PIZZA',)},\n",
       " {'Restaurant': ('& PIZZA',)},\n",
       " {'Restaurant': ('1 BANANA QUEEN',)},\n",
       " {'Restaurant': ('1 BANANA QUEEN',)},\n",
       " {'Restaurant': ('1 BANANA QUEEN',)},\n",
       " {'Restaurant': ('1 DEGREE UP',)},\n",
       " {'Restaurant': ('1 DEGREE UP',)},\n",
       " {'Restaurant': ('1 DEGREE UP',)},\n",
       " {'Restaurant': ('1 DEGREE UP',)},\n",
       " {'Restaurant': ('1 HOTEL BROOKLYN BRIDGE',)},\n",
       " {'Restaurant': ('1 HOTEL EMPLOYEE DINING KITCHEN #36',)},\n",
       " {'Restaurant': ('1 HOTEL EMPLOYEE DINING KITCHEN #36',)},\n",
       " {'Restaurant': ('1 STOP PATTY SHOP',)},\n",
       " {'Restaurant': ('1 STOP PATTY SHOP',)},\n",
       " {'Restaurant': ('1 STOP PATTY SHOP',)},\n",
       " {'Restaurant': ('1 UNION SUSHI',)},\n",
       " {'Restaurant': ('1 UNION SUSHI',)},\n",
       " {'Restaurant': ('1 UNION SUSHI',)},\n",
       " {'Restaurant': ('1 UNION SUSHI',)},\n",
       " {'Restaurant': ('1 UNION SUSHI',)},\n",
       " {'Restaurant': ('1 UNION SUSHI',)},\n",
       " {'Restaurant': ('1 UNION SUSHI',)},\n",
       " {'Restaurant': ('1 UNION SUSHI',)},\n",
       " {'Restaurant': ('1.5 DAK GALBI',)},\n",
       " {'Restaurant': ('1.5 DAK GALBI',)},\n",
       " {'Restaurant': ('1.5 DAK GALBI',)},\n",
       " {'Restaurant': ('100 FUN',)},\n",
       " {'Restaurant': ('100 FUN',)},\n",
       " {'Restaurant': ('3 BROS 99 CENT PIZZA',)},\n",
       " {'Restaurant': ('100 FUN',)},\n",
       " {'Restaurant': ('101 CAFE',)},\n",
       " {'Restaurant': ('101 CAFE',)},\n",
       " {'Restaurant': ('101 KENNEDY FRIED CHICKEN',)},\n",
       " {'Restaurant': ('101 KENNEDY FRIED CHICKEN',)},\n",
       " {'Restaurant': ('101 KENNEDY FRIED CHICKEN',)},\n",
       " {'Restaurant': ('101 MEAT SHOP',)},\n",
       " {'Restaurant': ('101 MEAT SHOP',)},\n",
       " {'Restaurant': ('101 MEAT SHOP',)},\n",
       " {'Restaurant': ('101 WILSON BAR',)},\n",
       " {'Restaurant': ('101 WILSON BAR',)},\n",
       " {'Restaurant': ('101 WILSON BAR',)},\n",
       " {'Restaurant': ('101 WILSON BAR',)},\n",
       " {'Restaurant': ('101 WILSON BAR',)},\n",
       " {'Restaurant': ('101 WILSON BAR',)},\n",
       " {'Restaurant': ('108 DOUBLE CHINESE RESTAURANT',)},\n",
       " {'Restaurant': ('108 DOUBLE CHINESE RESTAURANT',)},\n",
       " {'Restaurant': ('10TH AVENUE PIZZA & CAFE',)},\n",
       " {'Restaurant': ('10TH AVENUE PIZZA & CAFE',)},\n",
       " {'Restaurant': ('10TH AVENUE PIZZA & CAFE',)},\n",
       " {'Restaurant': ('10TH FLOOR LOUNGE',)},\n",
       " {'Restaurant': ('11 HOWARD KITCHEN',)},\n",
       " {'Restaurant': ('11 HOWARD KITCHEN',)},\n",
       " {'Restaurant': ('11 HOWARD KITCHEN',)},\n",
       " {'Restaurant': ('11 STREET CAFE',)},\n",
       " {'Restaurant': ('11 STREET CAFE',)},\n",
       " {'Restaurant': ('11 STREET CAFE',)},\n",
       " {'Restaurant': ('11 STREET CAFE',)},\n",
       " {'Restaurant': ('11 STREET CAFE',)},\n",
       " {'Restaurant': ('11 STREET CAFE',)},\n",
       " {'Restaurant': ('11 STREET CAFE',)},\n",
       " {'Restaurant': ('11 STREET CAFE',)},\n",
       " {'Restaurant': ('11TH ST BAR',)},\n",
       " {'Restaurant': ('12 CORAZONES RESTAURANT & BAR',)},\n",
       " {'Restaurant': ('12 CORAZONES RESTAURANT & BAR',)},\n",
       " {'Restaurant': ('12 CORAZONES RESTAURANT & BAR',)},\n",
       " {'Restaurant': ('123 NIKKO',)},\n",
       " {'Restaurant': ('123 NIKKO',)},\n",
       " {'Restaurant': ('123 NIKKO',)},\n",
       " {'Restaurant': ('16 HANDLES',)},\n",
       " {'Restaurant': ('51ST BAKERY AND CAFE',)},\n",
       " {'Restaurant': ('123 NIKKO',)},\n",
       " {'Restaurant': ('123 NIKKO',)},\n",
       " {'Restaurant': ('123 NIKKO',)},\n",
       " {'Restaurant': ('123 NIKKO',)},\n",
       " {'Restaurant': ('124 CAFE',)},\n",
       " {'Restaurant': ('124 CAFE',)},\n",
       " {'Restaurant': ('129 GOURMET DELI & GROCERY',)},\n",
       " {'Restaurant': ('129 GOURMET DELI & GROCERY',)},\n",
       " {'Restaurant': ('129 GOURMET DELI & GROCERY',)},\n",
       " {'Restaurant': ('129 GOURMET DELI & GROCERY',)},\n",
       " {'Restaurant': ('129 GOURMET DELI & GROCERY',)},\n",
       " {'Restaurant': ('129 GOURMET DELI & GROCERY',)},\n",
       " {'Restaurant': ('12TH ST. ALE HOUSE',)},\n",
       " {'Restaurant': ('1392 SEAFOOD MUSIC BAR',)},\n",
       " {'Restaurant': ('1392 SEAFOOD MUSIC BAR',)},\n",
       " {'Restaurant': ('1392 SEAFOOD MUSIC BAR',)},\n",
       " {'Restaurant': ('1392 SEAFOOD MUSIC BAR',)},\n",
       " {'Restaurant': ('14 OLD FULTON STREET',)},\n",
       " {'Restaurant': ('14 OLD FULTON STREET',)},\n",
       " {'Restaurant': ('146 NO. 1 YUMMY TACO',)},\n",
       " {'Restaurant': ('15 STORIES',)},\n",
       " {'Restaurant': ('15 STORIES',)},\n",
       " {'Restaurant': ('15 STORIES',)},\n",
       " {'Restaurant': ('16 HANDLES',)},\n",
       " {'Restaurant': ('16 HANDLES',)},\n",
       " {'Restaurant': ('16 HANDLES',)},\n",
       " {'Restaurant': ('16 HANDLES',)},\n",
       " {'Restaurant': ('16 HANDLES',)},\n",
       " {'Restaurant': ('16 HANDLES',)},\n",
       " {'Restaurant': ('16 HANDLES',)},\n",
       " {'Restaurant': ('16 HANDLES',)},\n",
       " {'Restaurant': ('16 HANDLES',)},\n",
       " {'Restaurant': ('16 HANDLES',)},\n",
       " {'Restaurant': ('16 HANDLES',)},\n",
       " {'Restaurant': ('16 HANDLES',)},\n",
       " {'Restaurant': ('16 HANDLES',)},\n",
       " {'Restaurant': ('16 HANDLES',)},\n",
       " {'Restaurant': ('16 HANDLES',)},\n",
       " {'Restaurant': ('16 HANDLES',)},\n",
       " {'Restaurant': ('16 HANDLES',)},\n",
       " {'Restaurant': ('161 HOT POT RICE',)},\n",
       " {'Restaurant': ('161 HOT POT RICE',)},\n",
       " {'Restaurant': ('161 HOT POT RICE',)},\n",
       " {'Restaurant': ('161 HOT POT RICE',)},\n",
       " {'Restaurant': ('161 HOT POT RICE',)},\n",
       " {'Restaurant': ('161 HOT POT RICE',)},\n",
       " {'Restaurant': ('161 LAFAYETTE',)},\n",
       " {'Restaurant': ('161 LAFAYETTE',)},\n",
       " {'Restaurant': ('168 HI TEA',)},\n",
       " {'Restaurant': ('168 HI TEA',)},\n",
       " {'Restaurant': ('168 HI TEA',)},\n",
       " {'Restaurant': ('168 HI TEA',)},\n",
       " {'Restaurant': ('168 HI TEA',)},\n",
       " {'Restaurant': ('168 HI TEA',)},\n",
       " {'Restaurant': ('168 KIM WEI KITCHEN',)},\n",
       " {'Restaurant': ('168 KIM WEI KITCHEN',)},\n",
       " {'Restaurant': ('168 KIM WEI KITCHEN',)},\n",
       " {'Restaurant': ('168 KIM WEI KITCHEN',)},\n",
       " {'Restaurant': ('18 BAKERY',)},\n",
       " {'Restaurant': ('18 BAKERY',)},\n",
       " {'Restaurant': ('18 BAKERY',)},\n",
       " {'Restaurant': ('18 BAKERY',)},\n",
       " {'Restaurant': ('18 HIPOT',)},\n",
       " {'Restaurant': ('18 HIPOT',)},\n",
       " {'Restaurant': ('18 HIPOT',)},\n",
       " {'Restaurant': ('18 HIPOT',)},\n",
       " {'Restaurant': ('18 LOUNGE KTV',)},\n",
       " {'Restaurant': ('18 LOUNGE KTV',)},\n",
       " {'Restaurant': ('18 LOUNGE KTV',)},\n",
       " {'Restaurant': ('18 LOUNGE KTV',)},\n",
       " {'Restaurant': ('18 LOUNGE KTV',)},\n",
       " {'Restaurant': ('18 LOUNGE KTV',)},\n",
       " {'Restaurant': ('18 LOUNGE KTV',)},\n",
       " {'Restaurant': ('18 LOUNGE KTV',)},\n",
       " {'Restaurant': ('18 LOUNGE KTV',)},\n",
       " {'Restaurant': ('18 LOUNGE KTV',)},\n",
       " {'Restaurant': ('18 LOUNGE KTV',)},\n",
       " {'Restaurant': ('18 LOUNGE KTV',)},\n",
       " {'Restaurant': ('18 LOUNGE KTV',)},\n",
       " {'Restaurant': ('18 LOUNGE KTV',)},\n",
       " {'Restaurant': ('18 LOUNGE KTV',)},\n",
       " {'Restaurant': ('18 RESTAURANT',)},\n",
       " {'Restaurant': ('18 RESTAURANT',)},\n",
       " {'Restaurant': ('18 RESTAURANT',)},\n",
       " {'Restaurant': ('1803 NYC',)},\n",
       " {'Restaurant': ('1803 NYC',)},\n",
       " {'Restaurant': ('1803 NYC',)},\n",
       " {'Restaurant': ('1803 NYC',)},\n",
       " {'Restaurant': ('1803 NYC',)},\n",
       " {'Restaurant': ('18TH AVE CAFE G',)},\n",
       " {'Restaurant': ('18TH AVE CAFE G',)},\n",
       " {'Restaurant': ('18TH AVE CAFE G',)},\n",
       " {'Restaurant': ('18TH AVE CAFE G',)},\n",
       " {'Restaurant': ('18TH AVE CAFE G',)},\n",
       " {'Restaurant': ('18TH AVE CAFE G',)},\n",
       " {'Restaurant': ('18TH AVE CAFE G',)},\n",
       " {'Restaurant': ('1982 COFFEE ROASTERS',)},\n",
       " {'Restaurant': ('1982 COFFEE ROASTERS',)},\n",
       " {'Restaurant': ('1982 COFFEE ROASTERS',)},\n",
       " {'Restaurant': ('1982 COFFEE ROASTERS',)},\n",
       " {'Restaurant': ('1982 COFFEE ROASTERS',)},\n",
       " {'Restaurant': ('1982 COFFEE ROASTERS',)},\n",
       " {'Restaurant': ('1982 COFFEE ROASTERS',)},\n",
       " {'Restaurant': ('1982 COFFEE ROASTERS',)},\n",
       " {'Restaurant': ('1ST MAMA RESTAURANT',)},\n",
       " {'Restaurant': ('1ST MAMA RESTAURANT',)},\n",
       " {'Restaurant': ('2 BROS PIZZA',)},\n",
       " {'Restaurant': ('2 BROS PIZZA',)},\n",
       " {'Restaurant': ('2 BROS PIZZA',)},\n",
       " {'Restaurant': ('2 BROS PIZZA',)},\n",
       " {'Restaurant': ('2 BROS PIZZA',)},\n",
       " {'Restaurant': ('2 BROS PIZZA',)},\n",
       " {'Restaurant': ('2 BROS PIZZA',)},\n",
       " {'Restaurant': ('2 BROS PIZZA',)},\n",
       " {'Restaurant': ('2 BROS PIZZA',)},\n",
       " {'Restaurant': ('2 BROS PIZZA',)},\n",
       " {'Restaurant': ('2 BROS PIZZA',)},\n",
       " {'Restaurant': ('2 BROS PIZZA',)},\n",
       " {'Restaurant': ('2 BROS PIZZA',)},\n",
       " {'Restaurant': ('2 BROS PIZZA',)},\n",
       " {'Restaurant': ('2 BROS PIZZA, CORVO COFFEE',)},\n",
       " {'Restaurant': ('2 IN 1 RESTAURANT',)},\n",
       " {'Restaurant': ('2 IN 1 RESTAURANT',)},\n",
       " {'Restaurant': ('2020 SABORES LATINOS REST & BAKERY',)},\n",
       " {'Restaurant': ('2020 SABORES LATINOS REST & BAKERY',)},\n",
       " {'Restaurant': ('2020 SABORES LATINOS REST & BAKERY',)},\n",
       " {'Restaurant': ('2020 SABORES LATINOS REST & BAKERY',)},\n",
       " {'Restaurant': ('2020 SABORES LATINOS REST & BAKERY',)},\n",
       " {'Restaurant': ('2020 SABORES LATINOS REST & BAKERY',)},\n",
       " {'Restaurant': ('2020 SABORES LATINOS REST & BAKERY',)},\n",
       " {'Restaurant': ('2020 SABORES LATINOS REST & BAKERY',)},\n",
       " {'Restaurant': ('21 CLUB',)},\n",
       " {'Restaurant': ('2123 FRESH TORTILLAS',)},\n",
       " {'Restaurant': ('2123 FRESH TORTILLAS',)},\n",
       " {'Restaurant': ('218 RESTAURANT',)},\n",
       " {'Restaurant': ('218 RESTAURANT',)},\n",
       " {'Restaurant': ('218 RESTAURANT',)},\n",
       " {'Restaurant': ('218 RESTAURANT',)},\n",
       " {'Restaurant': ('218 RESTAURANT',)},\n",
       " {'Restaurant': ('218 RESTAURANT',)},\n",
       " {'Restaurant': ('218 RESTAURANT',)},\n",
       " {'Restaurant': ('218 RESTAURANT',)},\n",
       " {'Restaurant': ('218 RESTAURANT',)},\n",
       " {'Restaurant': ('218 RESTAURANT',)},\n",
       " {'Restaurant': ('21ST LIC DELI & GROCERY',)},\n",
       " {'Restaurant': ('21ST LIC DELI & GROCERY',)},\n",
       " {'Restaurant': ('21ST LIC DELI & GROCERY',)},\n",
       " {'Restaurant': ('21ST LIC DELI & GROCERY',)},\n",
       " {'Restaurant': ('21ST LIC DELI & GROCERY',)},\n",
       " {'Restaurant': ('22 THAI CUISINE',)},\n",
       " {'Restaurant': ('22 THAI CUISINE',)},\n",
       " {'Restaurant': ('22 THAI CUISINE',)},\n",
       " {'Restaurant': ('22 THAI CUISINE',)},\n",
       " {'Restaurant': ('22 THAI CUISINE',)},\n",
       " {'Restaurant': ('22 THAI CUISINE',)},\n",
       " {'Restaurant': ('220 CENTRAL PARK SOUTH',)},\n",
       " {'Restaurant': ('2234 GREAT WALL INC',)},\n",
       " {'Restaurant': ('2234 GREAT WALL INC',)},\n",
       " {'Restaurant': ('2234 GREAT WALL INC',)},\n",
       " {'Restaurant': ('2234 GREAT WALL INC',)},\n",
       " {'Restaurant': ('2234 GREAT WALL INC',)},\n",
       " {'Restaurant': ('2234 GREAT WALL INC',)},\n",
       " {'Restaurant': ('2234 GREAT WALL INC',)},\n",
       " {'Restaurant': ('2234 GREAT WALL INC',)},\n",
       " {'Restaurant': ('2234 GREAT WALL INC',)},\n",
       " {'Restaurant': ('234 CHINA CITY',)},\n",
       " {'Restaurant': ('234 CHINA CITY',)},\n",
       " {'Restaurant': ('234 CHINA CITY',)},\n",
       " {'Restaurant': ('241ST CAFE RESTAURANT',)},\n",
       " {'Restaurant': ('241ST CAFE RESTAURANT',)},\n",
       " {'Restaurant': ('241ST CAFE RESTAURANT',)},\n",
       " {'Restaurant': ('25th AVE DELI',)},\n",
       " {'Restaurant': ('25th AVE DELI',)},\n",
       " {'Restaurant': ('25th AVE DELI',)},\n",
       " {'Restaurant': ('25th AVE DELI',)},\n",
       " {'Restaurant': ('25th AVE DELI',)},\n",
       " {'Restaurant': ('27 MORTON',)},\n",
       " {'Restaurant': ('27 MORTON',)},\n",
       " {'Restaurant': ('27 MORTON',)},\n",
       " {'Restaurant': ('27 MORTON',)},\n",
       " {'Restaurant': ('27 MORTON',)},\n",
       " {'Restaurant': ('27 MORTON',)},\n",
       " {'Restaurant': ('27 SPORTS BAR & CAFE',)},\n",
       " {'Restaurant': ('27 SPORTS BAR & CAFE',)},\n",
       " {'Restaurant': ('27 SPORTS BAR & CAFE',)},\n",
       " {'Restaurant': (\"277 PARK AVENUE CAFE'\",)},\n",
       " {'Restaurant': (\"277 PARK AVENUE CAFE'\",)},\n",
       " {'Restaurant': ('290 WILD BAR',)},\n",
       " {'Restaurant': ('2A',)},\n",
       " {'Restaurant': ('2A',)},\n",
       " {'Restaurant': ('2ND AVENUE DELI',)},\n",
       " {'Restaurant': ('2ND AVENUE DELI',)},\n",
       " {'Restaurant': ('3 BROS 99 CENT PIZZA',)},\n",
       " {'Restaurant': ('3 BROS 99 CENT PIZZA',)},\n",
       " {'Restaurant': ('3 BROS 99 CENT PIZZA',)},\n",
       " {'Restaurant': ('3 BROS 99 CENT PIZZA',)},\n",
       " {'Restaurant': ('3 BROS 99 CENTS PIZZA',)},\n",
       " {'Restaurant': ('3 BROS 99 CENTS PIZZA',)},\n",
       " {'Restaurant': ('3 BROS 99 CENTS PIZZA',)},\n",
       " {'Restaurant': ('3 BROS 99 CENTS PIZZA',)},\n",
       " {'Restaurant': ('3 BROS 99 CENTS PIZZA',)},\n",
       " {'Restaurant': ('3 BROS 99 CENTS PIZZA',)},\n",
       " {'Restaurant': ('3 DELI & GRILL',)},\n",
       " {'Restaurant': ('3 DELI & GRILL',)},\n",
       " {'Restaurant': ('3 DELI & GRILL',)},\n",
       " {'Restaurant': ('3 DELI & GRILL',)},\n",
       " {'Restaurant': ('3 GREEKS GRILL',)},\n",
       " {'Restaurant': ('3 GREEKS GRILL',)},\n",
       " {'Restaurant': ('3 GUYS',)},\n",
       " {'Restaurant': ('3 GUYS',)},\n",
       " {'Restaurant': ('3 GUYS SUSHI',)},\n",
       " {'Restaurant': ('3 GUYS SUSHI',)},\n",
       " {'Restaurant': ('3 IN 1 FS&H JAMAICAN RESTAURANT',)},\n",
       " {'Restaurant': ('3 IN 1 FS&H JAMAICAN RESTAURANT',)},\n",
       " {'Restaurant': ('3 IN 1 FS&H JAMAICAN RESTAURANT',)},\n",
       " {'Restaurant': ('3 IN 1 FS&H JAMAICAN RESTAURANT',)},\n",
       " {'Restaurant': (\"3 LUIGI'S PIZZA\",)},\n",
       " {'Restaurant': (\"3 LUIGI'S PIZZA\",)},\n",
       " {'Restaurant': (\"3 LUIGI'S PIZZA\",)},\n",
       " {'Restaurant': (\"3 LUIGI'S PIZZA\",)},\n",
       " {'Restaurant': (\"3 LUIGI'S PIZZA\",)},\n",
       " {'Restaurant': (\"3 LUIGI'S PIZZA\",)},\n",
       " {'Restaurant': (\"3 LUIGI'S PIZZA\",)},\n",
       " {'Restaurant': (\"3 LUIGI'S PIZZA\",)},\n",
       " {'Restaurant': (\"3 LUIGI'S PIZZA\",)},\n",
       " {'Restaurant': (\"3 LUIGI'S PIZZA\",)},\n",
       " {'Restaurant': ('3 TIMES',)},\n",
       " {'Restaurant': ('3 TIMES',)},\n",
       " {'Restaurant': ('3 TIMES',)},\n",
       " {'Restaurant': ('3 TIMES',)},\n",
       " {'Restaurant': ('3 TIMES',)},\n",
       " {'Restaurant': ('3 TIMES',)},\n",
       " {'Restaurant': ('3 TIMES',)},\n",
       " {'Restaurant': ('3 TIMES',)},\n",
       " {'Restaurant': ('3 TIMES',)},\n",
       " {'Restaurant': ('3 TIMES',)},\n",
       " {'Restaurant': ('3 TIMES',)},\n",
       " {'Restaurant': ('3 TIMES',)},\n",
       " {'Restaurant': ('3 TIMES',)},\n",
       " {'Restaurant': ('3 TIMES',)},\n",
       " {'Restaurant': ('3 TIMES',)},\n",
       " {'Restaurant': ('3 TIMES',)},\n",
       " {'Restaurant': ('3 TIMES',)},\n",
       " {'Restaurant': ('3 TIMES',)},\n",
       " {'Restaurant': ('3 TIMES',)},\n",
       " {'Restaurant': ('3 TIMES',)},\n",
       " {'Restaurant': ('3 WAY RESTAURANT',)},\n",
       " {'Restaurant': ('3 WAY RESTAURANT',)},\n",
       " {'Restaurant': ('3 WAY RESTAURANT',)},\n",
       " {'Restaurant': ('3 WAY RESTAURANT',)},\n",
       " {'Restaurant': ('3 WAY RESTAURANT',)},\n",
       " {'Restaurant': ('3 WAY RESTAURANT',)},\n",
       " {'Restaurant': ('302 BAR',)},\n",
       " {'Restaurant': ('303 GOLDEN STAR KITCHEN',)},\n",
       " {'Restaurant': ('303 GOLDEN STAR KITCHEN',)},\n",
       " {'Restaurant': ('303 GOLDEN STAR KITCHEN',)},\n",
       " {'Restaurant': ('303 GOLDEN STAR KITCHEN',)},\n",
       " {'Restaurant': ('32nd Deli',)},\n",
       " {'Restaurant': ('32nd Deli',)},\n",
       " {'Restaurant': ('32nd Deli',)},\n",
       " {'Restaurant': ('32nd Deli',)},\n",
       " {'Restaurant': ('32nd Deli',)},\n",
       " {'Restaurant': ('32nd Deli',)},\n",
       " {'Restaurant': ('32nd Deli',)},\n",
       " {'Restaurant': ('333 LOUNGE',)},\n",
       " {'Restaurant': ('333 LOUNGE',)},\n",
       " {'Restaurant': ('333 LOUNGE',)},\n",
       " {'Restaurant': ('333 LOUNGE',)},\n",
       " {'Restaurant': ('333 LOUNGE',)},\n",
       " {'Restaurant': ('333 LOUNGE',)},\n",
       " {'Restaurant': ('36 CAFE CORP',)},\n",
       " {'Restaurant': ('36 CAFE CORP',)},\n",
       " {'Restaurant': ('36 CAFE CORP',)},\n",
       " {'Restaurant': (\"ABITINO'S PIZZA\",)},\n",
       " {'Restaurant': ('36 CAFE CORP',)},\n",
       " {'Restaurant': ('36 CAFE CORP',)},\n",
       " {'Restaurant': ('369 BBQ',)},\n",
       " {'Restaurant': ('369 BBQ',)},\n",
       " {'Restaurant': ('369 BBQ',)},\n",
       " {'Restaurant': ('369 BBQ',)},\n",
       " {'Restaurant': ('369 BBQ',)},\n",
       " {'Restaurant': ('369 BBQ',)},\n",
       " {'Restaurant': ('375 THRICE COOKED FRIES',)},\n",
       " {'Restaurant': ('39 KINGS',)},\n",
       " {'Restaurant': ('39 KINGS',)},\n",
       " {'Restaurant': ('39 KINGS',)},\n",
       " {'Restaurant': ('39 TACO HOUSE',)},\n",
       " {'Restaurant': ('39 TACO HOUSE',)},\n",
       " {'Restaurant': (\"3D'S DELIGHT BAKERY & RESTAURANT\",)},\n",
       " {'Restaurant': (\"3D'S DELIGHT BAKERY & RESTAURANT\",)},\n",
       " {'Restaurant': (\"3D'S DELIGHT BAKERY & RESTAURANT\",)},\n",
       " {'Restaurant': (\"3D'S DELIGHT BAKERY & RESTAURANT\",)},\n",
       " {'Restaurant': (\"3D'S DELIGHT BAKERY & RESTAURANT\",)},\n",
       " {'Restaurant': (\"3D'S DELIGHT BAKERY & RESTAURANT\",)},\n",
       " {'Restaurant': (\"3D'S LEGACY SALAD & GRILL\",)},\n",
       " {'Restaurant': (\"3D'S LEGACY SALAD & GRILL\",)},\n",
       " {'Restaurant': (\"3D'S LEGACY SALAD & GRILL\",)},\n",
       " {'Restaurant': (\"3D'S LEGACY SALAD & GRILL\",)},\n",
       " {'Restaurant': (\"3D'S LEGACY SALAD & GRILL\",)},\n",
       " {'Restaurant': (\"3D'S LEGACY SALAD & GRILL\",)},\n",
       " {'Restaurant': (\"3D'S LEGACY SALAD & GRILL\",)},\n",
       " {'Restaurant': (\"3D'S LEGACY SALAD & GRILL\",)},\n",
       " {'Restaurant': ('3rd & 7',)},\n",
       " {'Restaurant': ('3rd & 7',)},\n",
       " {'Restaurant': ('40, 40 CLUB',)},\n",
       " {'Restaurant': ('40, 40 CLUB',)},\n",
       " {'Restaurant': ('40, 40 CLUB',)},\n",
       " {'Restaurant': ('42ND STREET PIZZA DINER',)},\n",
       " {'Restaurant': ('42ND STREET PIZZA DINER',)},\n",
       " {'Restaurant': ('456 NEW SHANGHAI RESTAURANT',)},\n",
       " {'Restaurant': ('456 NEW SHANGHAI RESTAURANT',)},\n",
       " {'Restaurant': ('5 STAR VILLAGE CAFE',)},\n",
       " {'Restaurant': ('456 NEW SHANGHAI RESTAURANT',)},\n",
       " {'Restaurant': ('456 NEW SHANGHAI RESTAURANT',)},\n",
       " {'Restaurant': ('4618 BAKERY',)},\n",
       " {'Restaurant': ('4618 BAKERY',)},\n",
       " {'Restaurant': ('4618 BAKERY',)},\n",
       " {'Restaurant': ('4618 BAKERY',)},\n",
       " {'Restaurant': ('4618 BAKERY',)},\n",
       " {'Restaurant': ('48 TREEHOUSE CAFE',)},\n",
       " {'Restaurant': ('48 TREEHOUSE CAFE',)},\n",
       " {'Restaurant': ('4TH FLOOR CAFE',)},\n",
       " {'Restaurant': ('4TH FLOOR CAFE',)},\n",
       " {'Restaurant': ('5 BURRO CAFE',)},\n",
       " {'Restaurant': ('5 ESTRELLA BAKERY',)},\n",
       " {'Restaurant': ('5 ESTRELLA BAKERY',)},\n",
       " {'Restaurant': ('5 ESTRELLA BAKERY',)},\n",
       " {'Restaurant': ('5 ESTRELLA BAKERY',)},\n",
       " {'Restaurant': ('5 ESTRELLA BAKERY',)},\n",
       " {'Restaurant': ('5 ESTRELLA BAKERY',)},\n",
       " {'Restaurant': ('5 ESTRELLA BAKERY',)},\n",
       " {'Restaurant': ('5 NAPKIN BURGER',)},\n",
       " {'Restaurant': ('5 NAPKIN BURGER',)},\n",
       " {'Restaurant': ('5 NAPKIN BURGER',)},\n",
       " {'Restaurant': ('5 NAPKIN BURGER',)},\n",
       " {'Restaurant': ('5 STAR CHEESE STEAK AND PIZZA',)},\n",
       " {'Restaurant': ('5 STAR CHEESE STEAK AND PIZZA',)},\n",
       " {'Restaurant': ('5 STAR CHEESE STEAK AND PIZZA',)},\n",
       " {'Restaurant': ('5 STAR PIZZA',)},\n",
       " {'Restaurant': ('5 STAR PIZZA',)},\n",
       " {'Restaurant': ('5 STAR PIZZA',)},\n",
       " {'Restaurant': ('5 STAR PIZZA',)},\n",
       " {'Restaurant': ('5 STAR PIZZA',)},\n",
       " {'Restaurant': ('5 STAR PIZZA',)},\n",
       " {'Restaurant': ('5 STAR PIZZA',)},\n",
       " {'Restaurant': ('5 STAR PIZZA',)},\n",
       " {'Restaurant': ('5 STAR VILLAGE CAFE',)},\n",
       " {'Restaurant': ('5 STAR VILLAGE CAFE',)},\n",
       " {'Restaurant': ('5 STAR VILLAGE CAFE',)},\n",
       " {'Restaurant': ('51ST BAKERY AND CAFE',)},\n",
       " {'Restaurant': ('51ST BAKERY AND CAFE',)},\n",
       " {'Restaurant': ('51ST BAKERY AND CAFE',)},\n",
       " {'Restaurant': ('51ST BAKERY AND CAFE',)},\n",
       " {'Restaurant': ('51ST BAKERY AND CAFE',)},\n",
       " {'Restaurant': ('52ND SUSHI',)},\n",
       " {'Restaurant': ('52ND SUSHI',)},\n",
       " {'Restaurant': ('52ND SUSHI',)},\n",
       " {'Restaurant': ('53RD STREET FINE DINING',)},\n",
       " {'Restaurant': ('53RD STREET FINE DINING',)},\n",
       " {'Restaurant': ('53RD STREET FINE DINING',)},\n",
       " {'Restaurant': ('54 BELOW',)},\n",
       " {'Restaurant': ('54 BELOW',)},\n",
       " {'Restaurant': ('54 BELOW',)},\n",
       " {'Restaurant': ('54 BELOW',)},\n",
       " {'Restaurant': ('561 DELI AND GROCERY',)},\n",
       " {'Restaurant': ('561 DELI AND GROCERY',)},\n",
       " {'Restaurant': ('561 DELI AND GROCERY',)},\n",
       " {'Restaurant': ('561 DELI AND GROCERY',)},\n",
       " {'Restaurant': ('561 DELI AND GROCERY',)},\n",
       " {'Restaurant': ('561 DELI AND GROCERY',)},\n",
       " {'Restaurant': ('561 DELI AND GROCERY',)},\n",
       " {'Restaurant': ('561 DELI AND GROCERY',)},\n",
       " {'Restaurant': ('561 DELI AND GROCERY',)},\n",
       " {'Restaurant': ('561 DELI AND GROCERY',)},\n",
       " {'Restaurant': ('561 DELI AND GROCERY',)},\n",
       " {'Restaurant': ('561 DELI AND GROCERY',)},\n",
       " {'Restaurant': ('561 DELI AND GROCERY',)},\n",
       " {'Restaurant': ('561 DELI AND GROCERY',)},\n",
       " {'Restaurant': ('561 DELI AND GROCERY',)},\n",
       " {'Restaurant': (\"57'S ALL AMERICAN GRILL\",)},\n",
       " {'Restaurant': (\"57'S ALL AMERICAN GRILL\",)},\n",
       " {'Restaurant': (\"57'S ALL AMERICAN GRILL\",)},\n",
       " {'Restaurant': ('575 PUB ON SECOND',)},\n",
       " {'Restaurant': ('575 PUB ON SECOND',)},\n",
       " {'Restaurant': ('88 WEIJIA',)},\n",
       " {'Restaurant': ('57th BAGELS & MORE',)},\n",
       " {'Restaurant': ('57th BAGELS & MORE',)},\n",
       " {'Restaurant': ('57th BAGELS & MORE',)},\n",
       " {'Restaurant': ('57th BAGELS & MORE',)},\n",
       " {'Restaurant': ('5BAR KARAOKE',)},\n",
       " {'Restaurant': ('5BAR KARAOKE',)},\n",
       " {'Restaurant': ('6321 YUAN BAO',)},\n",
       " {'Restaurant': ('6321 YUAN BAO',)},\n",
       " {'Restaurant': ('6321 YUAN BAO',)},\n",
       " {'Restaurant': ('66S FUSION',)},\n",
       " {'Restaurant': ('66S FUSION',)},\n",
       " {'Restaurant': ('66S FUSION',)},\n",
       " {'Restaurant': ('68 MEI MEI BAKERY',)},\n",
       " {'Restaurant': ('68 MEI MEI BAKERY',)},\n",
       " {'Restaurant': ('68 MEI MEI BAKERY',)},\n",
       " {'Restaurant': ('69 PIZZERIA',)},\n",
       " {'Restaurant': ('69 PIZZERIA',)},\n",
       " {'Restaurant': ('6915 BEST BAKERY',)},\n",
       " {'Restaurant': ('6915 BEST BAKERY',)},\n",
       " {'Restaurant': ('6915 BEST BAKERY',)},\n",
       " {'Restaurant': ('69TH COFFEE SHOP',)},\n",
       " {'Restaurant': ('69TH COFFEE SHOP',)},\n",
       " {'Restaurant': ('69TH COFFEE SHOP',)},\n",
       " {'Restaurant': ('69TH COFFEE SHOP',)},\n",
       " {'Restaurant': ('6B',)},\n",
       " {'Restaurant': ('6B',)},\n",
       " {'Restaurant': ('6th AVE CAFE INC',)},\n",
       " {'Restaurant': ('6th AVE CAFE INC',)},\n",
       " {'Restaurant': ('6th AVE CAFE INC',)},\n",
       " {'Restaurant': ('7 GRAMS CAFFE',)},\n",
       " {'Restaurant': ('7 GRAMS CAFFE',)},\n",
       " {'Restaurant': ('7 GRAMS CAFFE',)},\n",
       " {'Restaurant': ('7 GRAMS CAFFE',)},\n",
       " {'Restaurant': ('7 GRAMS CAFFE',)},\n",
       " {'Restaurant': ('7 GRAMS CAFFE',)},\n",
       " {'Restaurant': ('7 GRAMS CAFFE',)},\n",
       " {'Restaurant': ('7 GRAMS CAFFE',)},\n",
       " {'Restaurant': ('88 CHINESE RESTAURANT',)},\n",
       " {'Restaurant': ('7 GRAMS CAFFE',)},\n",
       " {'Restaurant': ('7 GRAMS CAFFE',)},\n",
       " {'Restaurant': ('77 WEST BISTRO',)},\n",
       " {'Restaurant': ('77 WEST BISTRO',)},\n",
       " {'Restaurant': ('77 WEST BISTRO',)},\n",
       " {'Restaurant': ('77 WEST BISTRO',)},\n",
       " {'Restaurant': ('77 WEST BISTRO',)},\n",
       " {'Restaurant': ('773 LOUNGE',)},\n",
       " {'Restaurant': ('773 LOUNGE',)},\n",
       " {'Restaurant': ('773 LOUNGE',)},\n",
       " {'Restaurant': ('787 COFFEE',)},\n",
       " {'Restaurant': ('787 COFFEE',)},\n",
       " {'Restaurant': ('787 COFFEE',)},\n",
       " {'Restaurant': ('787 COFFEE',)},\n",
       " {'Restaurant': ('787 COFFEE',)},\n",
       " {'Restaurant': ('787 COFFEE',)},\n",
       " {'Restaurant': ('787 COFFEE',)},\n",
       " {'Restaurant': ('787 COFFEE ROASTERS',)},\n",
       " {'Restaurant': ('787 COFFEE ROASTERS',)},\n",
       " {'Restaurant': ('8090 Taiwanese Food #24',)},\n",
       " {'Restaurant': ('8090 Taiwanese Food #24',)},\n",
       " {'Restaurant': ('810 DELI & CAFE',)},\n",
       " {'Restaurant': ('810 DELI & CAFE',)},\n",
       " {'Restaurant': ('810 DELI & CAFE',)},\n",
       " {'Restaurant': ('876 CROWN',)},\n",
       " {'Restaurant': ('876 CROWN',)},\n",
       " {'Restaurant': ('876 CROWN',)},\n",
       " {'Restaurant': ('876 CROWN',)},\n",
       " {'Restaurant': ('88 CAFE',)},\n",
       " {'Restaurant': ('88 CAFE',)},\n",
       " {'Restaurant': ('88 CANTEEN',)},\n",
       " {'Restaurant': ('88 CANTEEN',)},\n",
       " {'Restaurant': ('88 CANTEEN',)},\n",
       " {'Restaurant': ('88 CHINESE RESTAURANT',)},\n",
       " {'Restaurant': ('88 CHINESE RESTAURANT',)},\n",
       " {'Restaurant': ('88 WEIJIA',)},\n",
       " {'Restaurant': (\"ABITINO'S PIZZA\",)},\n",
       " {'Restaurant': ('88 WEIJIA',)},\n",
       " {'Restaurant': ('88 WEIJIA',)},\n",
       " {'Restaurant': ('88 WEIJIA',)},\n",
       " {'Restaurant': ('88 WEIJIA',)},\n",
       " {'Restaurant': ('88 WEIJIA',)},\n",
       " {'Restaurant': ('88 WEIJIA',)},\n",
       " {'Restaurant': ('88 WEIJIA',)},\n",
       " {'Restaurant': ('88 WEIJIA',)},\n",
       " {'Restaurant': ('88 WEIJIA',)},\n",
       " {'Restaurant': ('88 WEIJIA',)},\n",
       " {'Restaurant': ('88 YUMMY IN TUMMY',)},\n",
       " {'Restaurant': ('88 YUMMY IN TUMMY',)},\n",
       " {'Restaurant': ('88 YUMMY IN TUMMY',)},\n",
       " {'Restaurant': ('88 YUMMY IN TUMMY',)},\n",
       " {'Restaurant': ('888 KITCHEN',)},\n",
       " {'Restaurant': ('888 KITCHEN',)},\n",
       " {'Restaurant': ('8SIA',)},\n",
       " {'Restaurant': ('8SIA',)},\n",
       " {'Restaurant': ('8SIA',)},\n",
       " {'Restaurant': ('8TH STREET WINECELLAR',)},\n",
       " {'Restaurant': ('8TH STREET WINECELLAR',)},\n",
       " {'Restaurant': ('8TH STREET WINECELLAR',)},\n",
       " {'Restaurant': ('8TH STREET WINECELLAR',)},\n",
       " {'Restaurant': ('90 DEGREE COFFEE SHOP',)},\n",
       " {'Restaurant': ('90 DEGREE COFFEE SHOP',)},\n",
       " {'Restaurant': ('90 DEGREE COFFEE SHOP',)},\n",
       " {'Restaurant': ('900 DU CHUAN GONG RESTAURANT',)},\n",
       " {'Restaurant': ('900 DU CHUAN GONG RESTAURANT',)},\n",
       " {'Restaurant': ('900 DU CHUAN GONG RESTAURANT',)},\n",
       " {'Restaurant': ('900 DU CHUAN GONG RESTAURANT',)},\n",
       " {'Restaurant': ('900 DU CHUAN GONG RESTAURANT',)},\n",
       " {'Restaurant': ('900 DU CHUAN GONG RESTAURANT',)},\n",
       " {'Restaurant': ('900 DU CHUAN GONG RESTAURANT',)},\n",
       " {'Restaurant': ('900 DU CHUAN GONG RESTAURANT',)},\n",
       " {'Restaurant': ('9020 FOOD',)},\n",
       " {'Restaurant': ('9020 FOOD',)},\n",
       " {'Restaurant': ('9020 FOOD',)},\n",
       " {'Restaurant': ('95 SOUTH',)},\n",
       " {'Restaurant': ('96 FAVOR TASTE RESTAURANT',)},\n",
       " {'Restaurant': ('96 FAVOR TASTE RESTAURANT',)},\n",
       " {'Restaurant': ('96 FAVOR TASTE RESTAURANT',)},\n",
       " {'Restaurant': ('96 FAVOR TASTE RESTAURANT',)},\n",
       " {'Restaurant': ('969 NYC COFFEE',)},\n",
       " {'Restaurant': ('969 NYC COFFEE',)},\n",
       " {'Restaurant': ('969 NYC COFFEE',)},\n",
       " {'Restaurant': ('97 FAVOR TASTE RESTAURANT',)},\n",
       " {'Restaurant': ('97 FAVOR TASTE RESTAURANT',)},\n",
       " {'Restaurant': ('97 FAVOR TASTE RESTAURANT',)},\n",
       " {'Restaurant': ('97 FAVOR TASTE RESTAURANT',)},\n",
       " {'Restaurant': ('98K',)},\n",
       " {'Restaurant': ('98K',)},\n",
       " {'Restaurant': ('98K',)},\n",
       " {'Restaurant': ('98K',)},\n",
       " {'Restaurant': ('98K',)},\n",
       " {'Restaurant': ('98K KENNEDAY HALAL',)},\n",
       " {'Restaurant': ('98K KENNEDAY HALAL',)},\n",
       " {'Restaurant': ('98K KENNEDAY HALAL',)},\n",
       " {'Restaurant': ('98K KENNEDAY HALAL',)},\n",
       " {'Restaurant': ('98K KENNEDAY HALAL',)},\n",
       " {'Restaurant': ('99 CENT EXPRESS PIZZA',)},\n",
       " {'Restaurant': ('99 CENT EXPRESS PIZZA',)},\n",
       " {'Restaurant': ('99 CENT EXPRESS PIZZA',)},\n",
       " {'Restaurant': ('99 CENT FRESH PIZZA',)},\n",
       " {'Restaurant': ('99 CENT FRESH PIZZA',)},\n",
       " {'Restaurant': ('99 CENT FRESH PIZZA',)},\n",
       " {'Restaurant': ('99 CENT PIZZA',)},\n",
       " {'Restaurant': ('99 CENT PIZZA',)},\n",
       " {'Restaurant': ('99 CENT PIZZA',)},\n",
       " {'Restaurant': ('99 CENT PIZZA',)},\n",
       " {'Restaurant': ('99 CENT PIZZA',)},\n",
       " {'Restaurant': ('99 CENT PIZZA',)},\n",
       " {'Restaurant': ('99 CENT PIZZA',)},\n",
       " {'Restaurant': ('99 CENT PIZZA',)},\n",
       " {'Restaurant': ('99 CENT PIZZA',)},\n",
       " {'Restaurant': ('9TH STREET LUNCHEONETTE',)},\n",
       " {'Restaurant': ('99 CENT PIZZA',)},\n",
       " {'Restaurant': ('99 CENT PIZZA',)},\n",
       " {'Restaurant': ('99 CENT PIZZA',)},\n",
       " {'Restaurant': ('99 CENT PIZZA',)},\n",
       " {'Restaurant': ('99 CENT TASTY PIZZA',)},\n",
       " {'Restaurant': ('99 CENT TASTY PIZZA',)},\n",
       " {'Restaurant': ('99 CENT TASTY PIZZA',)},\n",
       " {'Restaurant': ('99 CENTS FRESH & HOT PIZZA',)},\n",
       " {'Restaurant': ('99 CENTS FRESH & HOT PIZZA',)},\n",
       " {'Restaurant': ('99 CENTS FRESH & HOT PIZZA',)},\n",
       " {'Restaurant': ('99 CENTS FRESH & HOT PIZZA',)},\n",
       " {'Restaurant': ('99 CENTS FRESH HOT PIZZA',)},\n",
       " {'Restaurant': ('99 CENTS FRESH HOT PIZZA',)},\n",
       " {'Restaurant': ('99 CENTS FRESH HOT PIZZA',)},\n",
       " {'Restaurant': ('99 CENTS FRESH HOT PIZZA',)},\n",
       " {'Restaurant': ('99 CENTS FRESH HOT PIZZA',)},\n",
       " {'Restaurant': ('99 CENTS FRESH HOT PIZZA',)},\n",
       " {'Restaurant': ('99 CENTS FRESH HOT PIZZA',)},\n",
       " {'Restaurant': ('99 CENTS FRESH HOT PIZZA',)},\n",
       " {'Restaurant': ('99 CENTS FRESH PIZZA',)},\n",
       " {'Restaurant': ('99 CENTS FRESH PIZZA',)},\n",
       " {'Restaurant': ('99 CENTS FRESH PIZZA',)},\n",
       " {'Restaurant': ('99 CENTS HOT PIZZA',)},\n",
       " {'Restaurant': ('99 CENTS HOT PIZZA',)},\n",
       " {'Restaurant': ('99 CENTS HOT PIZZA & HOTDOG',)},\n",
       " {'Restaurant': ('99 CENTS HOT PIZZA & HOTDOG',)},\n",
       " {'Restaurant': ('99 CENTS HOT PIZZA & HOTDOG',)},\n",
       " {'Restaurant': ('99 CENTS HOT PIZZA & HOTDOG',)},\n",
       " {'Restaurant': ('99 CENTS HOT PIZZA & HOTDOG',)},\n",
       " {'Restaurant': ('99 CENTS HOT PIZZA & HOTDOG',)},\n",
       " {'Restaurant': ('99 CENTS HOT PIZZA & HOTDOG',)},\n",
       " {'Restaurant': ('99 CENTS HOT PIZZA & HOTDOG',)},\n",
       " {'Restaurant': ('99 CENTS HOT PIZZA & HOTDOG',)},\n",
       " {'Restaurant': ('99 CENTS HOT PIZZA & HOTDOG',)},\n",
       " {'Restaurant': ('99 CENTS PIZZA & FRIES',)},\n",
       " {'Restaurant': ('99 CENTS PIZZA & FRIES',)},\n",
       " {'Restaurant': ('AFGHAN KEBAB HOUSE',)},\n",
       " {'Restaurant': ('99 CENTS PIZZA & FRIES',)},\n",
       " {'Restaurant': ('99 CENTS PIZZA & FRIES',)},\n",
       " {'Restaurant': ('99 CENTS PIZZA & FRIES',)},\n",
       " {'Restaurant': ('99 CENTS PIZZA & FRIES',)},\n",
       " {'Restaurant': ('99 CENTS TASTY PIZZA PLACE',)},\n",
       " {'Restaurant': ('99 CENTS TASTY PIZZA PLACE',)},\n",
       " {'Restaurant': ('99 CENTS TASTY PIZZA PLACE',)},\n",
       " {'Restaurant': ('99 CENTS TASTY PIZZA PLACE',)},\n",
       " {'Restaurant': ('99 CENTS TASTY PIZZA PLACE',)},\n",
       " {'Restaurant': ('99 CENTS TASTY PIZZA PLACE',)},\n",
       " {'Restaurant': ('99 CENTS TASTY PIZZA PLACE',)},\n",
       " {'Restaurant': ('99 CENTS TASTY PIZZA PLACE',)},\n",
       " {'Restaurant': ('99 CENTS UTICA HOT PIZZA',)},\n",
       " {'Restaurant': ('99 CENTS UTICA HOT PIZZA',)},\n",
       " {'Restaurant': ('99 CENTS UTICA HOT PIZZA',)},\n",
       " {'Restaurant': ('99 CENTS UTICA HOT PIZZA',)},\n",
       " {'Restaurant': ('99 CENTS UTICA HOT PIZZA',)},\n",
       " {'Restaurant': ('99 CENTS UTICA HOT PIZZA',)},\n",
       " {'Restaurant': ('99 CENTS UTICA HOT PIZZA',)},\n",
       " {'Restaurant': ('99 CENTS UTICA HOT PIZZA',)},\n",
       " {'Restaurant': ('99 CENTS UTICA HOT PIZZA',)},\n",
       " {'Restaurant': ('99 CENTS UTICA HOT PIZZA',)},\n",
       " {'Restaurant': ('99 ROGERS',)},\n",
       " {'Restaurant': ('99 ROGERS',)},\n",
       " {'Restaurant': ('99 ROGERS',)},\n",
       " {'Restaurant': ('99¬¢ HOT PIZZA',)},\n",
       " {'Restaurant': ('99¬¢ HOT PIZZA',)},\n",
       " {'Restaurant': ('99¬¢ HOT PIZZA',)},\n",
       " {'Restaurant': ('99¬¢ HOT PIZZA',)},\n",
       " {'Restaurant': ('99¬¢ HOT PIZZA',)},\n",
       " {'Restaurant': ('9ON DOMINICAN KITCHEN',)},\n",
       " {'Restaurant': ('9ON DOMINICAN KITCHEN',)},\n",
       " {'Restaurant': ('9ON DOMINICAN KITCHEN',)},\n",
       " {'Restaurant': ('9TH AVE SALOON',)},\n",
       " {'Restaurant': ('9TH AVE SALOON',)},\n",
       " {'Restaurant': ('9TH STREET LUNCHEONETTE',)},\n",
       " {'Restaurant': ('9TH STREET LUNCHEONETTE',)},\n",
       " {'Restaurant': ('9TH STREET LUNCHEONETTE',)},\n",
       " {'Restaurant': ('9TH STREET LUNCHEONETTE',)},\n",
       " {'Restaurant': ('A & A BAKE AND DOUBLE SHOP',)},\n",
       " {'Restaurant': ('A & A NUTRITION',)},\n",
       " {'Restaurant': ('A & A NUTRITION',)},\n",
       " {'Restaurant': ('A & A NUTRITION',)},\n",
       " {'Restaurant': ('A & A NUTRITION',)},\n",
       " {'Restaurant': ('A & C GUYANA BAKERY & RESTAURANT',)},\n",
       " {'Restaurant': ('A & C GUYANA BAKERY & RESTAURANT',)},\n",
       " {'Restaurant': ('A & C KITCHEN',)},\n",
       " {'Restaurant': ('A & R DELI',)},\n",
       " {'Restaurant': ('A & R DELI',)},\n",
       " {'Restaurant': ('A & R DELI',)},\n",
       " {'Restaurant': ('A & R DELI',)},\n",
       " {'Restaurant': ('A & R DELI',)},\n",
       " {'Restaurant': ('A & S CATERERS',)},\n",
       " {'Restaurant': ('A & S CATERERS',)},\n",
       " {'Restaurant': ('A & S CATERERS',)},\n",
       " {'Restaurant': ('A & S PIZZERIA',)},\n",
       " {'Restaurant': ('A A JING',)},\n",
       " {'Restaurant': ('A A JING',)},\n",
       " {'Restaurant': ('A AND K RESTAURANT',)},\n",
       " {'Restaurant': ('A AND K RESTAURANT',)},\n",
       " {'Restaurant': ('A BAR',)},\n",
       " {'Restaurant': ('A BAR',)},\n",
       " {'Restaurant': ('A LA TURKA',)},\n",
       " {'Restaurant': ('A LA TURKA',)},\n",
       " {'Restaurant': ('A LA TURKA',)},\n",
       " {'Restaurant': ('A LITTLE BIT OF THIS AND A LITTLE BIT OF THAT',)},\n",
       " {'Restaurant': ('A LITTLE BIT OF THIS AND A LITTLE BIT OF THAT',)},\n",
       " {'Restaurant': ('A LITTLE BIT OF THIS AND A LITTLE BIT OF THAT',)},\n",
       " {'Restaurant': ('A LITTLE BIT OF THIS AND A LITTLE BIT OF THAT',)},\n",
       " {'Restaurant': ('A LIVE KITCHEN',)},\n",
       " {'Restaurant': ('A LIVE KITCHEN',)},\n",
       " {'Restaurant': ('A PLUS THAI PLACE',)},\n",
       " {'Restaurant': ('A PLUS THAI PLACE',)},\n",
       " {'Restaurant': ('A PLUS THAI PLACE',)},\n",
       " {'Restaurant': ('A PLUS THAI PLACE',)},\n",
       " {'Restaurant': ('A10TH KITCHEN',)},\n",
       " {'Restaurant': ('BODEGA NEGRA',)},\n",
       " {'Restaurant': ('A SALT & BATTERY',)},\n",
       " {'Restaurant': ('A SLICE OF NEW YORK',)},\n",
       " {'Restaurant': ('A SLICE OF NEW YORK',)},\n",
       " {'Restaurant': ('A SLICE OF NEW YORK',)},\n",
       " {'Restaurant': ('A SLICE OF NEW YORK',)},\n",
       " {'Restaurant': ('A SLICE OF NEW YORK',)},\n",
       " {'Restaurant': ('A SLICE OF NEW YORK',)},\n",
       " {'Restaurant': ('A TASTE OF SHANGHAI RESTAURANT',)},\n",
       " {'Restaurant': ('A&A FOOD MARKET',)},\n",
       " {'Restaurant': ('A&A FOOD MARKET',)},\n",
       " {'Restaurant': ('A-1 PIZZA SHOP',)},\n",
       " {'Restaurant': ('A-1 PIZZA SHOP',)},\n",
       " {'Restaurant': ('A-1 PIZZA SHOP',)},\n",
       " {'Restaurant': ('A-1 PIZZA SHOP',)},\n",
       " {'Restaurant': ('A-1 PIZZA SHOP',)},\n",
       " {'Restaurant': ('A-1 PIZZA SHOP',)},\n",
       " {'Restaurant': ('A-1 PIZZA SHOP',)},\n",
       " {'Restaurant': ('A-1 PIZZA SHOP',)},\n",
       " {'Restaurant': ('A-1 PIZZA SHOP',)},\n",
       " {'Restaurant': ('A-JIAO SICHUAN CHINESE',)},\n",
       " {'Restaurant': ('A-JIAO SICHUAN CHINESE',)},\n",
       " {'Restaurant': ('A. CHURRASQUEIRA RESTAURANT',)},\n",
       " {'Restaurant': ('A. CHURRASQUEIRA RESTAURANT',)},\n",
       " {'Restaurant': ('A. CHURRASQUEIRA RESTAURANT',)},\n",
       " {'Restaurant': ('A.W.O.L. BAR & GRILL',)},\n",
       " {'Restaurant': ('A.W.O.L. BAR & GRILL',)},\n",
       " {'Restaurant': ('A.W.O.L. BAR & GRILL',)},\n",
       " {'Restaurant': ('A.W.O.L. BAR & GRILL',)},\n",
       " {'Restaurant': ('A.W.O.L. BAR & GRILL',)},\n",
       " {'Restaurant': ('A.W.O.L. BAR & GRILL',)},\n",
       " {'Restaurant': ('A.W.O.L. BAR & GRILL',)},\n",
       " {'Restaurant': ('A1 GOURMET DELI & PIZZA',)},\n",
       " {'Restaurant': ('A1 GOURMET DELI & PIZZA',)},\n",
       " {'Restaurant': ('A1 GOURMET DELI & PIZZA',)},\n",
       " {'Restaurant': ('A1 GOURMET DELI & PIZZA',)},\n",
       " {'Restaurant': ('A1 GOURMET DELI & PIZZA',)},\n",
       " {'Restaurant': ('A10TH KITCHEN',)},\n",
       " {'Restaurant': ('A10TH KITCHEN',)},\n",
       " {'Restaurant': ('A10TH KITCHEN',)},\n",
       " {'Restaurant': ('A10TH KITCHEN',)},\n",
       " {'Restaurant': ('A10TH KITCHEN',)},\n",
       " {'Restaurant': ('A10TH KITCHEN',)},\n",
       " {'Restaurant': ('A10TH KITCHEN',)},\n",
       " {'Restaurant': ('A10TH KITCHEN',)},\n",
       " {'Restaurant': ('A10TH KITCHEN',)},\n",
       " {'Restaurant': ('A10TH KITCHEN',)},\n",
       " {'Restaurant': ('A10TH KITCHEN',)},\n",
       " {'Restaurant': ('AAA CARIDAD',)},\n",
       " {'Restaurant': ('AAA CARIDAD',)},\n",
       " {'Restaurant': ('AAA KENNEDY FRIED CHICKEN',)},\n",
       " {'Restaurant': ('AAA KENNEDY FRIED CHICKEN',)},\n",
       " {'Restaurant': ('AANGAN INDIAN RESTAURANT',)},\n",
       " {'Restaurant': ('AANGAN INDIAN RESTAURANT',)},\n",
       " {'Restaurant': ('AANGAN INDIAN RESTAURANT',)},\n",
       " {'Restaurant': ('AANGAN INDIAN RESTAURANT',)},\n",
       " {'Restaurant': ('AANGAN INDIAN RESTAURANT',)},\n",
       " {'Restaurant': ('AANGAN INDIAN RESTAURANT',)},\n",
       " {'Restaurant': ('ABACKY POTLUCK',)},\n",
       " {'Restaurant': ('ABACKY POTLUCK',)},\n",
       " {'Restaurant': ('ABACKY POTLUCK',)},\n",
       " {'Restaurant': ('ABAYA THAI CUISINE',)},\n",
       " {'Restaurant': ('ABAYA THAI CUISINE',)},\n",
       " {'Restaurant': ('ABAYA THAI CUISINE',)},\n",
       " {'Restaurant': ('ABAYA THAI CUISINE',)},\n",
       " {'Restaurant': ('ABAYA THAI CUISINE',)},\n",
       " {'Restaurant': ('ABBEY TAVERN',)},\n",
       " {'Restaurant': ('ABBEY TAVERN',)},\n",
       " {'Restaurant': ('ABBEY TAVERN',)},\n",
       " {'Restaurant': ('ABC BEER CO.',)},\n",
       " {'Restaurant': ('ABC BEER CO.',)},\n",
       " {'Restaurant': ('ABC EATS',)},\n",
       " {'Restaurant': ('ABC EATS',)},\n",
       " {'Restaurant': ('ABC KITCHEN',)},\n",
       " {'Restaurant': ('ABC KITCHEN',)},\n",
       " {'Restaurant': ('ABILENE',)},\n",
       " {'Restaurant': ('ABILENE',)},\n",
       " {'Restaurant': ('ABILENE',)},\n",
       " {'Restaurant': ('ABIR HALAL RESTAURANT INC.',)},\n",
       " {'Restaurant': ('ABIR HALAL RESTAURANT INC.',)},\n",
       " {'Restaurant': (\"ABITINO'S PIZZA\",)},\n",
       " {'Restaurant': (\"ABITINO'S PIZZA\",)},\n",
       " {'Restaurant': (\"ABITINO'S PIZZA\",)},\n",
       " {'Restaurant': (\"ABITINO'S PIZZA\",)},\n",
       " {'Restaurant': (\"ABITINO'S PIZZA\",)},\n",
       " {'Restaurant': (\"ABITINO'S PIZZA\",)},\n",
       " {'Restaurant': (\"ABITINO'S PIZZA\",)},\n",
       " {'Restaurant': (\"ABITINO'S PIZZA\",)},\n",
       " {'Restaurant': (\"ABITINO'S PIZZA\",)},\n",
       " {'Restaurant': (\"ABITINO'S PIZZA\",)},\n",
       " {'Restaurant': (\"ABITINO'S PIZZA\",)},\n",
       " {'Restaurant': ('ABRACO',)},\n",
       " {'Restaurant': ('ABRACO',)},\n",
       " {'Restaurant': ('ABRACO',)},\n",
       " {'Restaurant': ('ABRACO',)},\n",
       " {'Restaurant': ('ABRACO',)},\n",
       " {'Restaurant': ('ABRACO',)},\n",
       " {'Restaurant': ('ABRACO',)},\n",
       " {'Restaurant': ('ABRACO',)},\n",
       " {'Restaurant': ('ABRACO',)},\n",
       " {'Restaurant': ('ABSOLUTE BAGELS',)},\n",
       " {'Restaurant': ('ABSOLUTE BAGELS',)},\n",
       " {'Restaurant': ('ABSOLUTE BAGELS',)},\n",
       " {'Restaurant': ('ABSOLUTE COFFEE',)},\n",
       " {'Restaurant': ('ABSOLUTE COFFEE',)},\n",
       " {'Restaurant': ('ABSOLUTE COFFEE',)},\n",
       " {'Restaurant': ('ABURI SUSHI BAR',)},\n",
       " {'Restaurant': ('ABURI SUSHI BAR',)},\n",
       " {'Restaurant': ('ABYS BAR',)},\n",
       " {'Restaurant': ('ABYS BAR',)},\n",
       " {'Restaurant': ('ABYSSINIA ETHIOPIAN RESTAURANT',)},\n",
       " {'Restaurant': ('ABYSSINIA ETHIOPIAN RESTAURANT',)},\n",
       " {'Restaurant': ('AL HORNO LEAN MEXICAN KITCHEN INC',)},\n",
       " {'Restaurant': ('ABYSSINIA ETHIOPIAN RESTAURANT',)},\n",
       " {'Restaurant': ('ACAPELLA 238 PIZZERIA',)},\n",
       " {'Restaurant': ('ACAPELLA 238 PIZZERIA',)},\n",
       " {'Restaurant': ('ACAPELLA 238 PIZZERIA',)},\n",
       " {'Restaurant': ('ACAPELLA 238 PIZZERIA',)},\n",
       " {'Restaurant': ('ACAPULCO DELI & RESTAURANT',)},\n",
       " {'Restaurant': ('ACAPULCO DELI & RESTAURANT',)},\n",
       " {'Restaurant': ('ACAPULCO DELI & RESTAURANT',)},\n",
       " {'Restaurant': ('ACCRA RESTAURANT',)},\n",
       " {'Restaurant': ('ACCRA RESTAURANT',)},\n",
       " {'Restaurant': ('ACCRA RESTAURANT',)},\n",
       " {'Restaurant': ('ACCRA RESTAURANT',)},\n",
       " {'Restaurant': ('ACCRA RESTAURANT',)},\n",
       " {'Restaurant': ('ACE THAI KITCHEN',)},\n",
       " {'Restaurant': ('ACE THAI KITCHEN',)},\n",
       " {'Restaurant': ('ACE THAI KITCHEN',)},\n",
       " {'Restaurant': ('ACE THAI KITCHEN',)},\n",
       " {'Restaurant': ('ACENTO LATIN KITCHEN & BAR',)},\n",
       " {'Restaurant': ('ACENTO LATIN KITCHEN & BAR',)},\n",
       " {'Restaurant': ('ACENTO LATIN KITCHEN & BAR',)},\n",
       " {'Restaurant': ('ACENTO LATIN KITCHEN & BAR',)},\n",
       " {'Restaurant': ('ACENTO LATIN KITCHEN & BAR',)},\n",
       " {'Restaurant': ('ACENTO LATIN KITCHEN & BAR',)},\n",
       " {'Restaurant': ('ACENTO LATIN KITCHEN & BAR',)},\n",
       " {'Restaurant': (\"ACEY DUCEY'S\",)},\n",
       " {'Restaurant': (\"ACEY DUCEY'S\",)},\n",
       " {'Restaurant': (\"ACEY DUCEY'S\",)},\n",
       " {'Restaurant': (\"ACEY DUCEY'S\",)},\n",
       " {'Restaurant': (\"ACEY DUCEY'S\",)},\n",
       " {'Restaurant': (\"ACEY DUCEY'S\",)},\n",
       " {'Restaurant': (\"ACEY DUCEY'S\",)},\n",
       " {'Restaurant': (\"ACKI'S JUICE BAR\",)},\n",
       " {'Restaurant': (\"ACKI'S JUICE BAR\",)},\n",
       " {'Restaurant': (\"ACKI'S JUICE BAR\",)},\n",
       " {'Restaurant': (\"ACKI'S JUICE BAR\",)},\n",
       " {'Restaurant': (\"ACKI'S JUICE BAR\",)},\n",
       " {'Restaurant': (\"ALBA'S PIZZA\",)},\n",
       " {'Restaurant': (\"ACKI'S JUICE BAR\",)},\n",
       " {'Restaurant': (\"ACKI'S JUICE BAR\",)},\n",
       " {'Restaurant': ('ACOSTA RESTAURANT',)},\n",
       " {'Restaurant': ('ACOSTA RESTAURANT',)},\n",
       " {'Restaurant': ('ACOSTA RESTAURANT',)},\n",
       " {'Restaurant': ('ACOSTA RESTAURANT',)},\n",
       " {'Restaurant': ('ACOSTA RESTAURANT',)},\n",
       " {'Restaurant': ('ACOSTA RESTAURANT',)},\n",
       " {'Restaurant': ('ACQUA SANTA',)},\n",
       " {'Restaurant': ('ACQUA SANTA',)},\n",
       " {'Restaurant': ('ACQUA SANTA',)},\n",
       " {'Restaurant': ('ACQUA SANTA',)},\n",
       " {'Restaurant': ('ACQUA SANTA',)},\n",
       " {'Restaurant': ('ACQUA SANTA',)},\n",
       " {'Restaurant': ('ACQUA SANTA',)},\n",
       " {'Restaurant': ('ACTION BURGER',)},\n",
       " {'Restaurant': ('ACTION BURGER',)},\n",
       " {'Restaurant': ('ACTION BURGER',)},\n",
       " {'Restaurant': ('ACTION BURGER',)},\n",
       " {'Restaurant': ('ACTION BURGER',)},\n",
       " {'Restaurant': ('ACUARIO CAFE',)},\n",
       " {'Restaurant': ('ACUARIO CAFE',)},\n",
       " {'Restaurant': ('ACUARIO CAFE',)},\n",
       " {'Restaurant': ('AD HOC COLLECTIVE',)},\n",
       " {'Restaurant': ('AD HOC COLLECTIVE',)},\n",
       " {'Restaurant': ('ADALYA',)},\n",
       " {'Restaurant': ('ADALYA',)},\n",
       " {'Restaurant': ('ADALYA',)},\n",
       " {'Restaurant': ('ADALYA',)},\n",
       " {'Restaurant': ('ADALYA',)},\n",
       " {'Restaurant': ('ADALYA',)},\n",
       " {'Restaurant': ('ADALYA',)},\n",
       " {'Restaurant': ('ADALYA',)},\n",
       " {'Restaurant': ('ADANA TURKISH GRILL',)},\n",
       " {'Restaurant': ('ADANA TURKISH GRILL',)},\n",
       " {'Restaurant': ('ADANA TURKISH GRILL',)},\n",
       " {'Restaurant': ('ADANA TURKISH GRILL',)},\n",
       " {'Restaurant': ('ADANA TURKISH GRILL',)},\n",
       " {'Restaurant': ('ADAYA AFRICAN AMERICAN RESTAURANT',)},\n",
       " {'Restaurant': ('ADAYA AFRICAN AMERICAN RESTAURANT',)},\n",
       " {'Restaurant': ('ADAYA AFRICAN AMERICAN RESTAURANT',)},\n",
       " {'Restaurant': ('ADAYA AFRICAN AMERICAN RESTAURANT',)},\n",
       " {'Restaurant': (\"ADDEO'S RIVERDALE PIZZERIA\",)},\n",
       " {'Restaurant': (\"ADDEO'S RIVERDALE PIZZERIA\",)},\n",
       " {'Restaurant': ('ADDICCION',)},\n",
       " {'Restaurant': ('ADELITAS',)},\n",
       " {'Restaurant': ('ADELITAS',)},\n",
       " {'Restaurant': ('ADELITAS',)},\n",
       " {'Restaurant': ('ADELITAS',)},\n",
       " {'Restaurant': ('ADELITAS',)},\n",
       " {'Restaurant': ('ADRIA HOTEL',)},\n",
       " {'Restaurant': ('ADRIA HOTEL',)},\n",
       " {'Restaurant': ('ADRIA HOTEL',)},\n",
       " {'Restaurant': ('ADRIA HOTEL',)},\n",
       " {'Restaurant': (\"ADRIENNE'S PIZZA BAR\",)},\n",
       " {'Restaurant': ('ADVENTURE CAFE',)},\n",
       " {'Restaurant': ('ADVENTURE CAFE',)},\n",
       " {'Restaurant': ('ADVENTURES AMUSEMENTS PARK (ice cream, sweets stand)',)},\n",
       " {'Restaurant': ('ADVENTURES AMUSEMENTS PARK (ice cream, sweets stand)',)},\n",
       " {'Restaurant': ('ADVENTURES AMUSEMENTS PARK (ice cream, sweets stand)',)},\n",
       " {'Restaurant': ('ADVENTURES AMUSEMENTS PARK (ice cream, sweets stand)',)},\n",
       " {'Restaurant': ('ADVENTURES AMUSEMENTS PARK (ice cream, sweets stand)',)},\n",
       " {'Restaurant': ('ADYAR ANANDA BHAVAN',)},\n",
       " {'Restaurant': ('ADYAR ANANDA BHAVAN',)},\n",
       " {'Restaurant': ('AEGEA WEST',)},\n",
       " {'Restaurant': ('AEGEA WEST',)},\n",
       " {'Restaurant': (\"AFFY'S PREMIUM GRILL\",)},\n",
       " {'Restaurant': (\"AFFY'S PREMIUM GRILL\",)},\n",
       " {'Restaurant': (\"AFFY'S PREMIUM GRILL\",)},\n",
       " {'Restaurant': ('AFGHAN CHAI KHANA',)},\n",
       " {'Restaurant': ('AFGHAN CHAI KHANA',)},\n",
       " {'Restaurant': ('AFGHAN CHAI KHANA',)},\n",
       " {'Restaurant': ('AFGHAN CHAI KHANA',)},\n",
       " {'Restaurant': ('AFGHAN CHAI KHANA',)},\n",
       " {'Restaurant': ('AFGHAN KEBAB HOUSE',)},\n",
       " {'Restaurant': ('AFRICA KINE',)},\n",
       " {'Restaurant': ('AFRICA KINE',)},\n",
       " {'Restaurant': ('AFRICA KINE',)},\n",
       " {'Restaurant': ('AGAVE',)},\n",
       " {'Restaurant': ('AGAVE',)},\n",
       " {'Restaurant': ('AGAVE',)},\n",
       " {'Restaurant': ('AGAVE',)},\n",
       " {'Restaurant': ('AGAVE',)},\n",
       " {'Restaurant': ('AGAVE',)},\n",
       " {'Restaurant': ('AGAVE',)},\n",
       " {'Restaurant': ('AGAVE',)},\n",
       " {'Restaurant': ('AGAVE',)},\n",
       " {'Restaurant': ('AGAVE',)},\n",
       " {'Restaurant': ('AGAVE',)},\n",
       " {'Restaurant': ('AGAVE',)},\n",
       " {'Restaurant': ('AGAVE',)},\n",
       " {'Restaurant': ('AGAVE DELI GROCERY',)},\n",
       " {'Restaurant': ('AGAVE DELI GROCERY',)},\n",
       " {'Restaurant': ('AGAVI ORGANIC JUICEBAR',)},\n",
       " {'Restaurant': ('AGAVI ORGANIC JUICEBAR',)},\n",
       " {'Restaurant': ('AGAVI ORGANIC JUICEBAR',)},\n",
       " {'Restaurant': ('AGAVI ORGANIC JUICEBAR',)},\n",
       " {'Restaurant': ('AGED',)},\n",
       " {'Restaurant': ('AGED',)},\n",
       " {'Restaurant': ('AGED',)},\n",
       " {'Restaurant': ('AGED',)},\n",
       " {'Restaurant': ('AGERN',)},\n",
       " {'Restaurant': ('AGERN',)},\n",
       " {'Restaurant': ('AGERN',)},\n",
       " {'Restaurant': ('AGERN',)},\n",
       " {'Restaurant': ('AGERN',)},\n",
       " {'Restaurant': ('AGNANTI RESTAURANT',)},\n",
       " {'Restaurant': ('AGORA TAVERNA',)},\n",
       " {'Restaurant': ('AGORA TAVERNA',)},\n",
       " {'Restaurant': ('AGORA TAVERNA',)},\n",
       " {'Restaurant': ('AGORA TAVERNA',)},\n",
       " {'Restaurant': ('AGORA TURKISH RESTAURANT',)},\n",
       " {'Restaurant': ('AGORA TURKISH RESTAURANT',)},\n",
       " {'Restaurant': ('AGORA TURKISH RESTAURANT',)},\n",
       " {'Restaurant': (\"ALBA'S PIZZA\",)},\n",
       " {'Restaurant': ('AGRA GRILL',)},\n",
       " {'Restaurant': ('AGRA GRILL',)},\n",
       " {'Restaurant': ('AGRA HEIGHTS',)},\n",
       " {'Restaurant': ('AGRA HEIGHTS',)},\n",
       " {'Restaurant': ('AGRA HEIGHTS',)},\n",
       " {'Restaurant': ('AGRA HEIGHTS',)},\n",
       " {'Restaurant': ('AGRA HEIGHTS',)},\n",
       " {'Restaurant': ('AGRA TAJ MAHAL',)},\n",
       " ...]"
      ]
     },
     "execution_count": 115,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Violations_info = Base.classes.violations\n",
    "session = Session(engine)\n",
    "violations_data = session.query(Violations_info.restaurant).all()\n",
    "session.close()\n",
    "\n",
    "violation_list = []\n",
    "for rest in violations_data:\n",
    "    violation_dict = {}\n",
    "    violation_dict[\"Restaurant\"] = rest\n",
    "\n",
    "    violation_list.append(violation_dict)\n",
    "violation_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}