Mem_new_stuff.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "from IPython.core.interactiveshell import InteractiveShell\n",
    "InteractiveShell.ast_node_interactivity = \"all\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "range(stop) -> range object\n",
      "range(start, stop[, step]) -> range object\n",
      "\n",
      "Return an object that produces a sequence of integers from start (inclusive)\n",
      "to stop (exclusive) by step.  range(i, j) produces i, i+1, i+2, ..., j-1.\n",
      "start defaults to 0, and stop is omitted!  range(4) produces 0, 1, 2, 3.\n",
      "These are exactly the valid indices for a list of 4 elements.\n",
      "When step is given, it specifies the increment (or decrement).\n"
     ]
    }
   ],
   "source": [
    "print(range.__doc__)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "range?"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "You can find out what variables are declared in the local or global namespace, by using the dictionaries locals() and globals()."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "12"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x = 12\n",
    "locals()['x']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "del x"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'not here'"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "locals().get('x','not here')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[25, 22.5, 19.8, 20.5]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "heights = [21.6, 22.5, 19.8, 20.5]\n",
    "heights [0] = 25\n",
    "h = heights\n",
    "h"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "99"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "4573819016"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "4573819016"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "b = h\n",
    "b[2] = 99\n",
    "h[2]\n",
    "id(b)\n",
    "id(h)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[25, 22.5, 99, 20.5]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "b = h[:]\n",
    "b"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[25, 22.5, 99, 20.5]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "b[1] = 99\n",
    "h"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "False"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "b = list(h) #alterantive creates a copy\n",
    "c = h.copy()\n",
    "c is h"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "range(1996, 2013)"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "years = range(1996, 2013)\n",
    "years"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "ename": "TypeError",
     "evalue": "'range' object is not callable",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------\u001b[0m",
      "\u001b[0;31mTypeError\u001b[0mTraceback (most recent call last)",
      "\u001b[0;32m<ipython-input-25-4549a8722c1f>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0myears\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m  \u001b[0;31m#shift tab tab\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;31mTypeError\u001b[0m: 'range' object is not callable"
     ]
    }
   ],
   "source": [
    "years()  #shift tab tab"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Method to read a file"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "# open using a context manager --closes file automatically; csv_file is the file handle\n",
    "with open(\"data/health_inspection_chi_sample.csv\") as csv_file:\n",
    "    for line in csv_file:\n",
    "        pass"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "' | 41. PREMISES MAINTAINED FREE OF LITTER, UNNECESSARY ARTICLES, CLEANING  EQUIPMENT PROPERLY STORED - Comments: CORRECTED. | 41. PREMISES MAINTAINED FREE OF LITTER, UNNECESSARY ARTICLES, CLEANING  EQUIPMENT PROPERLY STORED - Comments: OBSERVED STANDING WASTE WATER INSIDE OF THE MOP BUCKET IN THE REAR PREP AREA AND A WET MOP ON THE FLOOR; INSTRUCTED TO DISPOSE OF STANDING WASTE WATER WHEN DONE USING AND TO HANG WET MOPS UPWARD TO DRY.\",60651.0\\n'"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "line #prints the last line"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1775568\n"
     ]
    }
   ],
   "source": [
    "json_file = open('data/health_inspection_chi_sample.json')\n",
    "\n",
    "for line in json_file:\n",
    "    pass\n",
    "print(json_file.tell())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "json_file.seek(0) #seek means go back to the beginning of the iterable\n",
    "for line in json_file:\n",
    "    pass"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### another method to read a file"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "import csv\n",
    "from pprint import pprint\n",
    "csv_file = open(\"data/health_inspection_chi_sample.csv\")\n",
    "reader = csv.reader(csv_file)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['address',\n",
      " 'aka_name',\n",
      " 'city',\n",
      " 'dba_name',\n",
      " 'facility_type',\n",
      " 'inspection_date',\n",
      " 'inspection_id',\n",
      " 'inspection_type',\n",
      " 'latitude',\n",
      " 'license_',\n",
      " 'location',\n",
      " 'longitude',\n",
      " 'results',\n",
      " 'risk',\n",
      " 'state',\n",
      " 'violations',\n",
      " 'zip']\n"
     ]
    }
   ],
   "source": [
    "headers = next(reader)\n",
    "pprint(headers)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['5255 W MADISON ST ',\n",
      " 'RED SNAPPER FISH CHICKEN & PIZZA',\n",
      " 'CHICAGO',\n",
      " 'RED SNAPPER FISH CHICKEN & PIZZA',\n",
      " 'Restaurant',\n",
      " '2016-09-26T00:00:00.000',\n",
      " '1965287',\n",
      " 'Canvass',\n",
      " '41.880236543865834',\n",
      " '1991820.0',\n",
      " \"{'type': 'Point', 'coordinates': [-87.757220392117, 41.880236543866]}\",\n",
      " '-87.7572203921175',\n",
      " 'Pass w/ Conditions',\n",
      " 'Risk 1 (High)',\n",
      " 'IL',\n",
      " '35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTRUCTED PER CODE: GOOD REPAIR, '\n",
      " 'SURFACES CLEAN AND DUST-LESS CLEANING METHODS - Comments: MUST CLEAN THE '\n",
      " 'WALLS AT WALL BASE NEAR THE MIXER IN REAR OF PREMISES AND THE PREP AREA OF '\n",
      " 'FOOD SPILLS AND CLEAN THE WALL VENT IN PREP AREA ,INSTRUCTED TO CLEAN AND '\n",
      " 'MAINTAIN AREA | 33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSILS CLEAN, FREE '\n",
      " 'OF ABRASIVE DETERGENTS - Comments: MUST CLEAN THE INTERIOR PANEL OF THE ICE '\n",
      " 'MACHINE IN REAR OF PREMISES | 34. FLOORS: CONSTRUCTED PER CODE, CLEANED, '\n",
      " 'GOOD REPAIR, COVING INSTALLED, DUST-LESS CLEANING METHODS USED - Comments: '\n",
      " 'MUST CLEAN FLOORS THROUGHOUT PREMISES,ALONG WALL BASE AND CORNERS OF GREASE '\n",
      " 'AND DIRT BUILD-UP,INSTRUCTED TO CLEAN AND MAINTAIN AREA | 36. LIGHTING: '\n",
      " 'REQUIRED MINIMUM FOOT-CANDLES OF LIGHT PROVIDED, FIXTURES SHIELDED - '\n",
      " 'Comments: MUST PROVIDE A LIGHT SHIELD COVER FOR THE WALK-IN FREEZER IN REAR '\n",
      " 'OF PREMISES | 22. DISH MACHINES: PROVIDED WITH ACCURATE THERMOMETERS, '\n",
      " 'CHEMICAL TEST KITS AND SUITABLE GAUGE COCK - Comments: OBSERVED NO CHEMICAL '\n",
      " 'TEST STRIPS TO TEST THE SANITIZER AT 3 COMPARTMENT SINK,WHEN SINK IS SET UP '\n",
      " 'FOR WASH,RINSE AND SANITIZE,INSTRUCTED TO PROVIDE SERIOUS VIOLATION 7-38-030 '\n",
      " '| 40. REFRIGERATION AND METAL STEM THERMOMETERS PROVIDED AND CONSPICUOUS - '\n",
      " 'Comments: MUST PROVIDE A THERMOMETER INSIDE THE PREP COOLER IN PREP AREA',\n",
      " '60644.0']\n"
     ]
    }
   ],
   "source": [
    "line = next(reader)\n",
    "pprint(line)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### List Comprehensions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[1, 2, 3, 4, 5]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list1 = [i for i in range(1, 6)]\n",
    "list1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['a', 'b', 'c', 'd']"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x = ['a', 'b', 'c', 'd', '_e', '_f']\n",
    "[i for i in x if not i.startswith('_')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['a', 'b', 'c', 'd', 'skipped', 'skipped']"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "[i if not i.startswith('_') else 'skipped' for i in x]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "matrix = [\n",
    "    [1, 2, 3, 4],\n",
    "    [5, 6, 7, 8],\n",
    "    [9, 10, 11, 12],\n",
    "]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12]"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "[element for row in matrix for element in row]  #getting too complex"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'first_initial': 'J', 'last_name': 'Doe', 'address': '1234 Main Street'}"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#dictionary comprehension\n",
    "pairs = [\n",
    "    (\"first_initial\", \"J\"), \n",
    "    (\"last_name\", \"Doe\"), \n",
    "    (\"address\", \"1234 Main Street\")\n",
    "]\n",
    "{key: value for key, value in pairs}"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Reading Data: web data\n",
    "Of course, pandas can also load data directly from a URL, but I encourage you to reach for requests as often as you need it."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "#note the addition of parens to split the url into two lines\n",
    "response = requests.get(\n",
    "    \"https://data.cityofchicago.org/\"\n",
    "    \"resource/cwig-ma7x.json\", \n",
    "    params=\"$limit=10\"\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Response [200]>"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "response\n",
    "response.ok"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "- libraries like Beautiful Soup, lxml, and mechanize can be helpful.\n",
    "- There's also a read_html function in pandas that will quickly scrape HTML tables for you and put them into a DataFrame."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "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>:@computed_region_43wa_7qmu</th>\n",
       "      <th>:@computed_region_6mkv_f3dw</th>\n",
       "      <th>:@computed_region_awaf_s7ux</th>\n",
       "      <th>:@computed_region_bdys_3d7i</th>\n",
       "      <th>:@computed_region_vrxf_vc4k</th>\n",
       "      <th>address</th>\n",
       "      <th>aka_name</th>\n",
       "      <th>city</th>\n",
       "      <th>dba_name</th>\n",
       "      <th>facility_type</th>\n",
       "      <th>...</th>\n",
       "      <th>inspection_type</th>\n",
       "      <th>latitude</th>\n",
       "      <th>license_</th>\n",
       "      <th>location</th>\n",
       "      <th>longitude</th>\n",
       "      <th>results</th>\n",
       "      <th>risk</th>\n",
       "      <th>state</th>\n",
       "      <th>violations</th>\n",
       "      <th>zip</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>42</td>\n",
       "      <td>4447</td>\n",
       "      <td>33</td>\n",
       "      <td>264</td>\n",
       "      <td>73</td>\n",
       "      <td>3323 W 111TH ST</td>\n",
       "      <td>WONDERBURGER</td>\n",
       "      <td>CHICAGO</td>\n",
       "      <td>WONDERBURGER</td>\n",
       "      <td>Restaurant</td>\n",
       "      <td>...</td>\n",
       "      <td>License</td>\n",
       "      <td>41.691404</td>\n",
       "      <td>2626727</td>\n",
       "      <td>{'type': 'Point', 'coordinates': [-87.70428241...</td>\n",
       "      <td>-87.704282</td>\n",
       "      <td>Fail</td>\n",
       "      <td>Risk 3 (Low)</td>\n",
       "      <td>IL</td>\n",
       "      <td>10. ADEQUATE HANDWASHING SINKS PROPERLY SUPPLI...</td>\n",
       "      <td>60655.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   :@computed_region_43wa_7qmu  :@computed_region_6mkv_f3dw  \\\n",
       "0                           42                         4447   \n",
       "\n",
       "   :@computed_region_awaf_s7ux  :@computed_region_bdys_3d7i  \\\n",
       "0                           33                          264   \n",
       "\n",
       "   :@computed_region_vrxf_vc4k           address      aka_name     city  \\\n",
       "0                           73  3323 W 111TH ST   WONDERBURGER  CHICAGO   \n",
       "\n",
       "       dba_name facility_type   ...    inspection_type   latitude license_  \\\n",
       "0  WONDERBURGER    Restaurant   ...            License  41.691404  2626727   \n",
       "\n",
       "                                            location  longitude results  \\\n",
       "0  {'type': 'Point', 'coordinates': [-87.70428241... -87.704282    Fail   \n",
       "\n",
       "           risk state                                         violations  \\\n",
       "0  Risk 3 (Low)    IL  10. ADEQUATE HANDWASHING SINKS PROPERLY SUPPLI...   \n",
       "\n",
       "       zip  \n",
       "0  60655.0  \n",
       "\n",
       "[1 rows x 22 columns]"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "dta = pd.read_json(response.content, orient='records')\n",
    "dta.head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 146,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(25000, 16)"
      ]
     },
     "execution_count": 146,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "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>latitude</th>\n",
       "      <th>license_</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>24865.000000</td>\n",
       "      <td>2.499600e+04</td>\n",
       "      <td>24865.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>41.879734</td>\n",
       "      <td>1.475028e+06</td>\n",
       "      <td>-87.675890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>0.081968</td>\n",
       "      <td>8.912679e+05</td>\n",
       "      <td>0.058372</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>41.644670</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>-87.914428</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>41.828059</td>\n",
       "      <td>1.000632e+06</td>\n",
       "      <td>-87.707209</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>41.891528</td>\n",
       "      <td>1.884173e+06</td>\n",
       "      <td>-87.666377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>41.939792</td>\n",
       "      <td>2.134724e+06</td>\n",
       "      <td>-87.634533</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>42.021064</td>\n",
       "      <td>8.700606e+06</td>\n",
       "      <td>-87.525125</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           latitude      license_     longitude\n",
       "count  24865.000000  2.499600e+04  24865.000000\n",
       "mean      41.879734  1.475028e+06    -87.675890\n",
       "std        0.081968  8.912679e+05      0.058372\n",
       "min       41.644670  0.000000e+00    -87.914428\n",
       "25%       41.828059  1.000632e+06    -87.707209\n",
       "50%       41.891528  1.884173e+06    -87.666377\n",
       "75%       41.939792  2.134724e+06    -87.634533\n",
       "max       42.021064  8.700606e+06    -87.525125"
      ]
     },
     "execution_count": 146,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 25000 entries, 1965287 to 413268\n",
      "Data columns (total 16 columns):\n",
      "address            25000 non-null object\n",
      "aka_name           24709 non-null object\n",
      "city               24981 non-null object\n",
      "dba_name           25000 non-null object\n",
      "facility_type      24787 non-null category\n",
      "inspection_date    25000 non-null datetime64[ns]\n",
      "inspection_type    25000 non-null category\n",
      "latitude           24865 non-null float64\n",
      "license_           24996 non-null float64\n",
      "location           24865 non-null object\n",
      "longitude          24865 non-null float64\n",
      "results            25000 non-null category\n",
      "risk               24995 non-null category\n",
      "state              24994 non-null object\n",
      "violations         23908 non-null object\n",
      "zip                24990 non-null object\n",
      "dtypes: category(4), datetime64[ns](1), float64(3), object(8)\n",
      "memory usage: 3.2+ MB\n"
     ]
    }
   ],
   "source": [
    "dta.shape\n",
    "dta.describe()\n",
    "dta.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 147,
   "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>facility_type</th>\n",
       "      <th>inspection_type</th>\n",
       "      <th>results</th>\n",
       "      <th>risk</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>24787</td>\n",
       "      <td>25000</td>\n",
       "      <td>25000</td>\n",
       "      <td>24995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unique</th>\n",
       "      <td>226</td>\n",
       "      <td>40</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>top</th>\n",
       "      <td>Restaurant</td>\n",
       "      <td>Canvass</td>\n",
       "      <td>Pass</td>\n",
       "      <td>Risk 1 (High)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>freq</th>\n",
       "      <td>16954</td>\n",
       "      <td>12487</td>\n",
       "      <td>15915</td>\n",
       "      <td>18249</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       facility_type inspection_type results           risk\n",
       "count          24787           25000   25000          24995\n",
       "unique           226              40       7              4\n",
       "top       Restaurant         Canvass    Pass  Risk 1 (High)\n",
       "freq           16954           12487   15915          18249"
      ]
     },
     "execution_count": 147,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dta.select_dtypes(['category']).describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "dta = dta.set_index('inspection_id')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "inspection_id\n",
       "2279757           3323 W 111TH ST \n",
       "2279808          1515 W DEVON AVE \n",
       "2279779    811 W FULTON MARKET ST \n",
       "2279758        1610 W CHICAGO AVE \n",
       "2279754        4521 N SHERIDAN RD \n",
       "Name: address, dtype: object"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dta['address'].head() #w/o loc we get a column"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "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>address</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>inspection_id</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2279757</th>\n",
       "      <td>3323 W 111TH ST</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2279808</th>\n",
       "      <td>1515 W DEVON AVE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2279779</th>\n",
       "      <td>811 W FULTON MARKET ST</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               address\n",
       "inspection_id                         \n",
       "2279757               3323 W 111TH ST \n",
       "2279808              1515 W DEVON AVE \n",
       "2279779        811 W FULTON MARKET ST "
      ]
     },
     "execution_count": 79,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# or pass it a list to preserve the df\n",
    "dta[['address']].head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "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>:@computed_region_43wa_7qmu</th>\n",
       "      <th>:@computed_region_6mkv_f3dw</th>\n",
       "      <th>:@computed_region_awaf_s7ux</th>\n",
       "      <th>:@computed_region_bdys_3d7i</th>\n",
       "      <th>:@computed_region_vrxf_vc4k</th>\n",
       "      <th>address</th>\n",
       "      <th>aka_name</th>\n",
       "      <th>city</th>\n",
       "      <th>dba_name</th>\n",
       "      <th>facility_type</th>\n",
       "      <th>...</th>\n",
       "      <th>inspection_type</th>\n",
       "      <th>latitude</th>\n",
       "      <th>license_</th>\n",
       "      <th>location</th>\n",
       "      <th>longitude</th>\n",
       "      <th>results</th>\n",
       "      <th>risk</th>\n",
       "      <th>state</th>\n",
       "      <th>violations</th>\n",
       "      <th>zip</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>inspection_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2279808</th>\n",
       "      <td>16</td>\n",
       "      <td>4451</td>\n",
       "      <td>46</td>\n",
       "      <td>536</td>\n",
       "      <td>76</td>\n",
       "      <td>1515 W DEVON AVE</td>\n",
       "      <td>LA UNICA FOOD MART</td>\n",
       "      <td>CHICAGO</td>\n",
       "      <td>LA UNICA FOOD MART, INC.</td>\n",
       "      <td>RESTAURANT/GROCERY STORE</td>\n",
       "      <td>...</td>\n",
       "      <td>Complaint</td>\n",
       "      <td>41.997993</td>\n",
       "      <td>491</td>\n",
       "      <td>{'type': 'Point', 'coordinates': [-87.66842788...</td>\n",
       "      <td>-87.668428</td>\n",
       "      <td>Fail</td>\n",
       "      <td>Risk 1 (High)</td>\n",
       "      <td>IL</td>\n",
       "      <td>2. CITY OF CHICAGO FOOD SERVICE SANITATION CER...</td>\n",
       "      <td>60660.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2279779</th>\n",
       "      <td>46</td>\n",
       "      <td>14917</td>\n",
       "      <td>41</td>\n",
       "      <td>63</td>\n",
       "      <td>29</td>\n",
       "      <td>811 W FULTON MARKET ST</td>\n",
       "      <td>THE WING FULTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>THE WING FULTON</td>\n",
       "      <td>Restaurant</td>\n",
       "      <td>...</td>\n",
       "      <td>License</td>\n",
       "      <td>41.886684</td>\n",
       "      <td>2642303</td>\n",
       "      <td>{'type': 'Point', 'coordinates': [-87.64800067...</td>\n",
       "      <td>-87.648001</td>\n",
       "      <td>Fail</td>\n",
       "      <td>Risk 2 (Medium)</td>\n",
       "      <td>IL</td>\n",
       "      <td>3. MANAGEMENT, FOOD EMPLOYEE AND CONDITIONAL E...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               :@computed_region_43wa_7qmu  :@computed_region_6mkv_f3dw  \\\n",
       "inspection_id                                                             \n",
       "2279808                                 16                         4451   \n",
       "2279779                                 46                        14917   \n",
       "\n",
       "               :@computed_region_awaf_s7ux  :@computed_region_bdys_3d7i  \\\n",
       "inspection_id                                                             \n",
       "2279808                                 46                          536   \n",
       "2279779                                 41                           63   \n",
       "\n",
       "               :@computed_region_vrxf_vc4k                  address  \\\n",
       "inspection_id                                                         \n",
       "2279808                                 76        1515 W DEVON AVE    \n",
       "2279779                                 29  811 W FULTON MARKET ST    \n",
       "\n",
       "                         aka_name     city                  dba_name  \\\n",
       "inspection_id                                                          \n",
       "2279808        LA UNICA FOOD MART  CHICAGO  LA UNICA FOOD MART, INC.   \n",
       "2279779           THE WING FULTON      NaN           THE WING FULTON   \n",
       "\n",
       "                          facility_type   ...    inspection_type   latitude  \\\n",
       "inspection_id                             ...                                 \n",
       "2279808        RESTAURANT/GROCERY STORE   ...          Complaint  41.997993   \n",
       "2279779                      Restaurant   ...            License  41.886684   \n",
       "\n",
       "               license_                                           location  \\\n",
       "inspection_id                                                                \n",
       "2279808             491  {'type': 'Point', 'coordinates': [-87.66842788...   \n",
       "2279779         2642303  {'type': 'Point', 'coordinates': [-87.64800067...   \n",
       "\n",
       "               longitude  results             risk state  \\\n",
       "inspection_id                                              \n",
       "2279808       -87.668428     Fail    Risk 1 (High)    IL   \n",
       "2279779       -87.648001     Fail  Risk 2 (Medium)    IL   \n",
       "\n",
       "                                                      violations      zip  \n",
       "inspection_id                                                              \n",
       "2279808        2. CITY OF CHICAGO FOOD SERVICE SANITATION CER...  60660.0  \n",
       "2279779        3. MANAGEMENT, FOOD EMPLOYEE AND CONDITIONAL E...      NaN  \n",
       "\n",
       "[2 rows x 21 columns]"
      ]
     },
     "execution_count": 80,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dta.loc[[2279808, 2279779]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "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>address</th>\n",
       "      <th>aka_name</th>\n",
       "      <th>city</th>\n",
       "      <th>dba_name</th>\n",
       "      <th>facility_type</th>\n",
       "      <th>inspection_date</th>\n",
       "      <th>inspection_type</th>\n",
       "      <th>latitude</th>\n",
       "      <th>license_</th>\n",
       "      <th>location</th>\n",
       "      <th>longitude</th>\n",
       "      <th>results</th>\n",
       "      <th>risk</th>\n",
       "      <th>state</th>\n",
       "      <th>violations</th>\n",
       "      <th>zip</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>inspection_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2279808</th>\n",
       "      <td>1515 W DEVON AVE</td>\n",
       "      <td>LA UNICA FOOD MART</td>\n",
       "      <td>CHICAGO</td>\n",
       "      <td>LA UNICA FOOD MART, INC.</td>\n",
       "      <td>RESTAURANT/GROCERY STORE</td>\n",
       "      <td>2019-03-21T00:00:00.000</td>\n",
       "      <td>Complaint</td>\n",
       "      <td>41.997993</td>\n",
       "      <td>491</td>\n",
       "      <td>{'type': 'Point', 'coordinates': [-87.66842788...</td>\n",
       "      <td>-87.668428</td>\n",
       "      <td>Fail</td>\n",
       "      <td>Risk 1 (High)</td>\n",
       "      <td>IL</td>\n",
       "      <td>2. CITY OF CHICAGO FOOD SERVICE SANITATION CER...</td>\n",
       "      <td>60660.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2279779</th>\n",
       "      <td>811 W FULTON MARKET ST</td>\n",
       "      <td>THE WING FULTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>THE WING FULTON</td>\n",
       "      <td>Restaurant</td>\n",
       "      <td>2019-03-21T00:00:00.000</td>\n",
       "      <td>License</td>\n",
       "      <td>41.886684</td>\n",
       "      <td>2642303</td>\n",
       "      <td>{'type': 'Point', 'coordinates': [-87.64800067...</td>\n",
       "      <td>-87.648001</td>\n",
       "      <td>Fail</td>\n",
       "      <td>Risk 2 (Medium)</td>\n",
       "      <td>IL</td>\n",
       "      <td>3. MANAGEMENT, FOOD EMPLOYEE AND CONDITIONAL E...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               address            aka_name     city  \\\n",
       "inspection_id                                                         \n",
       "2279808              1515 W DEVON AVE   LA UNICA FOOD MART  CHICAGO   \n",
       "2279779        811 W FULTON MARKET ST      THE WING FULTON      NaN   \n",
       "\n",
       "                               dba_name             facility_type  \\\n",
       "inspection_id                                                       \n",
       "2279808        LA UNICA FOOD MART, INC.  RESTAURANT/GROCERY STORE   \n",
       "2279779                 THE WING FULTON                Restaurant   \n",
       "\n",
       "                       inspection_date inspection_type   latitude  license_  \\\n",
       "inspection_id                                                                 \n",
       "2279808        2019-03-21T00:00:00.000       Complaint  41.997993       491   \n",
       "2279779        2019-03-21T00:00:00.000         License  41.886684   2642303   \n",
       "\n",
       "                                                        location  longitude  \\\n",
       "inspection_id                                                                 \n",
       "2279808        {'type': 'Point', 'coordinates': [-87.66842788... -87.668428   \n",
       "2279779        {'type': 'Point', 'coordinates': [-87.64800067... -87.648001   \n",
       "\n",
       "              results             risk state  \\\n",
       "inspection_id                                  \n",
       "2279808          Fail    Risk 1 (High)    IL   \n",
       "2279779          Fail  Risk 2 (Medium)    IL   \n",
       "\n",
       "                                                      violations      zip  \n",
       "inspection_id                                                              \n",
       "2279808        2. CITY OF CHICAGO FOOD SERVICE SANITATION CER...  60660.0  \n",
       "2279779        3. MANAGEMENT, FOOD EMPLOYEE AND CONDITIONAL E...      NaN  "
      ]
     },
     "execution_count": 81,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dta.iloc[1:3,5:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "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>address</th>\n",
       "      <th>inspection_date</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>inspection_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2279757</th>\n",
       "      <td>3323 W 111TH ST</td>\n",
       "      <td>2019-03-21T00:00:00.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2279808</th>\n",
       "      <td>1515 W DEVON AVE</td>\n",
       "      <td>2019-03-21T00:00:00.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2279779</th>\n",
       "      <td>811 W FULTON MARKET ST</td>\n",
       "      <td>2019-03-21T00:00:00.000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               address          inspection_date\n",
       "inspection_id                                                  \n",
       "2279757               3323 W 111TH ST   2019-03-21T00:00:00.000\n",
       "2279808              1515 W DEVON AVE   2019-03-21T00:00:00.000\n",
       "2279779        811 W FULTON MARKET ST   2019-03-21T00:00:00.000"
      ]
     },
     "execution_count": 82,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dta.loc[:2279779, [\"address\", \"inspection_date\"]].head(4)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "dta.inspection_date = dta.inspection_date.apply(pd.to_datetime)  # probably easiest way to convert to datetime\n",
    "# using apply to a series to convert it ..."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "inspection_id\n",
       "2279757   2019-03-21\n",
       "2279808   2019-03-21\n",
       "2279779   2019-03-21\n",
       "Name: inspection_date, dtype: datetime64[ns]"
      ]
     },
     "execution_count": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dta.inspection_date.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "metadata": {},
   "outputs": [],
   "source": [
    "# SEE BELOW on use of dtype = 'str', so that we don't need this\n",
    "\n",
    "import numpy as np\n",
    "def float_to_zip(zip_code):\n",
    "    if np.isnan(zip_code):\n",
    "        return np.nan\n",
    "    \n",
    "    # 0 makes sure to left-pad with zero\n",
    "    # zip codes have 5 digits\n",
    "    # .0 means, we don't want anything after the decimal\n",
    "    # f is for float\n",
    "    zip_code = \"{:05.0f}\".format(zip_code)\n",
    "    # {:  0: 0 pad if there are 5 digits; nothing after '.' is accepted}\n",
    "    return zip_code"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "metadata": {},
   "outputs": [],
   "source": [
    "dta.zip = dta.zip.apply(float_to_zip)  # note use of apply again"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "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>zip</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>inspection_id</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2279757</th>\n",
       "      <td>60655</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2279808</th>\n",
       "      <td>60660</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2279779</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2279758</th>\n",
       "      <td>60622</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2279754</th>\n",
       "      <td>60640</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 zip\n",
       "inspection_id       \n",
       "2279757        60655\n",
       "2279808        60660\n",
       "2279779          NaN\n",
       "2279758        60622\n",
       "2279754        60640"
      ]
     },
     "execution_count": 90,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dta[['zip']].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "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>:@computed_region_43wa_7qmu</th>\n",
       "      <th>:@computed_region_6mkv_f3dw</th>\n",
       "      <th>:@computed_region_awaf_s7ux</th>\n",
       "      <th>:@computed_region_bdys_3d7i</th>\n",
       "      <th>:@computed_region_vrxf_vc4k</th>\n",
       "      <th>address</th>\n",
       "      <th>aka_name</th>\n",
       "      <th>city</th>\n",
       "      <th>dba_name</th>\n",
       "      <th>facility_type</th>\n",
       "      <th>inspection_date</th>\n",
       "      <th>inspection_type</th>\n",
       "      <th>latitude</th>\n",
       "      <th>license_</th>\n",
       "      <th>longitude</th>\n",
       "      <th>results</th>\n",
       "      <th>risk</th>\n",
       "      <th>state</th>\n",
       "      <th>violations</th>\n",
       "      <th>zip</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>inspection_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2279757</th>\n",
       "      <td>42</td>\n",
       "      <td>4447</td>\n",
       "      <td>33</td>\n",
       "      <td>264</td>\n",
       "      <td>73</td>\n",
       "      <td>3323 W 111TH ST</td>\n",
       "      <td>WONDERBURGER</td>\n",
       "      <td>CHICAGO</td>\n",
       "      <td>WONDERBURGER</td>\n",
       "      <td>Restaurant</td>\n",
       "      <td>2019-03-21</td>\n",
       "      <td>License</td>\n",
       "      <td>41.691404</td>\n",
       "      <td>2626727</td>\n",
       "      <td>-87.704282</td>\n",
       "      <td>Fail</td>\n",
       "      <td>Risk 3 (Low)</td>\n",
       "      <td>IL</td>\n",
       "      <td>10. ADEQUATE HANDWASHING SINKS PROPERLY SUPPLI...</td>\n",
       "      <td>60655</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2279808</th>\n",
       "      <td>16</td>\n",
       "      <td>4451</td>\n",
       "      <td>46</td>\n",
       "      <td>536</td>\n",
       "      <td>76</td>\n",
       "      <td>1515 W DEVON AVE</td>\n",
       "      <td>LA UNICA FOOD MART</td>\n",
       "      <td>CHICAGO</td>\n",
       "      <td>LA UNICA FOOD MART, INC.</td>\n",
       "      <td>RESTAURANT/GROCERY STORE</td>\n",
       "      <td>2019-03-21</td>\n",
       "      <td>Complaint</td>\n",
       "      <td>41.997993</td>\n",
       "      <td>491</td>\n",
       "      <td>-87.668428</td>\n",
       "      <td>Fail</td>\n",
       "      <td>Risk 1 (High)</td>\n",
       "      <td>IL</td>\n",
       "      <td>2. CITY OF CHICAGO FOOD SERVICE SANITATION CER...</td>\n",
       "      <td>60660</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2279779</th>\n",
       "      <td>46</td>\n",
       "      <td>14917</td>\n",
       "      <td>41</td>\n",
       "      <td>63</td>\n",
       "      <td>29</td>\n",
       "      <td>811 W FULTON MARKET ST</td>\n",
       "      <td>THE WING FULTON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>THE WING FULTON</td>\n",
       "      <td>Restaurant</td>\n",
       "      <td>2019-03-21</td>\n",
       "      <td>License</td>\n",
       "      <td>41.886684</td>\n",
       "      <td>2642303</td>\n",
       "      <td>-87.648001</td>\n",
       "      <td>Fail</td>\n",
       "      <td>Risk 2 (Medium)</td>\n",
       "      <td>IL</td>\n",
       "      <td>3. MANAGEMENT, FOOD EMPLOYEE AND CONDITIONAL E...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               :@computed_region_43wa_7qmu  :@computed_region_6mkv_f3dw  \\\n",
       "inspection_id                                                             \n",
       "2279757                                 42                         4447   \n",
       "2279808                                 16                         4451   \n",
       "2279779                                 46                        14917   \n",
       "\n",
       "               :@computed_region_awaf_s7ux  :@computed_region_bdys_3d7i  \\\n",
       "inspection_id                                                             \n",
       "2279757                                 33                          264   \n",
       "2279808                                 46                          536   \n",
       "2279779                                 41                           63   \n",
       "\n",
       "               :@computed_region_vrxf_vc4k                  address  \\\n",
       "inspection_id                                                         \n",
       "2279757                                 73         3323 W 111TH ST    \n",
       "2279808                                 76        1515 W DEVON AVE    \n",
       "2279779                                 29  811 W FULTON MARKET ST    \n",
       "\n",
       "                         aka_name     city                  dba_name  \\\n",
       "inspection_id                                                          \n",
       "2279757              WONDERBURGER  CHICAGO              WONDERBURGER   \n",
       "2279808        LA UNICA FOOD MART  CHICAGO  LA UNICA FOOD MART, INC.   \n",
       "2279779           THE WING FULTON      NaN           THE WING FULTON   \n",
       "\n",
       "                          facility_type inspection_date inspection_type  \\\n",
       "inspection_id                                                             \n",
       "2279757                      Restaurant      2019-03-21         License   \n",
       "2279808        RESTAURANT/GROCERY STORE      2019-03-21       Complaint   \n",
       "2279779                      Restaurant      2019-03-21         License   \n",
       "\n",
       "                latitude  license_  longitude results             risk state  \\\n",
       "inspection_id                                                                  \n",
       "2279757        41.691404   2626727 -87.704282    Fail     Risk 3 (Low)    IL   \n",
       "2279808        41.997993       491 -87.668428    Fail    Risk 1 (High)    IL   \n",
       "2279779        41.886684   2642303 -87.648001    Fail  Risk 2 (Medium)    IL   \n",
       "\n",
       "                                                      violations    zip  \n",
       "inspection_id                                                            \n",
       "2279757        10. ADEQUATE HANDWASHING SINKS PROPERLY SUPPLI...  60655  \n",
       "2279808        2. CITY OF CHICAGO FOOD SERVICE SANITATION CER...  60660  \n",
       "2279779        3. MANAGEMENT, FOOD EMPLOYEE AND CONDITIONAL E...    NaN  "
      ]
     },
     "execution_count": 91,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "del dta['location']\n",
    "dta.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Using pandas to read csv directly \n",
    "\n",
    "dta = pd.read_csv(\n",
    "    \"data/health_inspection_chi.csv\", \n",
    "    index_col=\"inspection_id\",\n",
    "    parse_dates=[\"inspection_date\"]\n",
    ")\n",
    "# makes inspection_date a datetime object\n",
    "# sets up index to be more useful"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# use of converters during the read....\n",
    "# apply the function float_to_zip as we read it in\n",
    "dta = pd.read_csv(\n",
    "    \"data/health_inspection_chi.csv\",\n",
    "    converters={\n",
    "        'zip': float_to_zip\n",
    "    },\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# use of usecols\n",
    "dta = pd.read_csv(\n",
    "    \"data/health_inspection_chi.csv\",\n",
    "    usecols=lambda col: col != 'location'\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 254,
   "metadata": {},
   "outputs": [],
   "source": [
    "dta = pd.read_csv(\n",
    "    \"data/health_inspection_chi.csv\",\n",
    "    index_col=\"inspection_id\",\n",
    "    parse_dates=[\"inspection_date\"],\n",
    "    dtype={\n",
    "        'results': 'category',\n",
    "        'risk': 'category',\n",
    "        'inspection_type': 'category',\n",
    "        'facility_type': 'category',\n",
    "        'zip': 'str' #zipcodes can start with a 0 so cast as a string\n",
    "    }\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 255,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 25000 entries, 1965287 to 413268\n",
      "Data columns (total 16 columns):\n",
      "address            25000 non-null object\n",
      "aka_name           24709 non-null object\n",
      "city               24981 non-null object\n",
      "dba_name           25000 non-null object\n",
      "facility_type      24787 non-null category\n",
      "inspection_date    25000 non-null datetime64[ns]\n",
      "inspection_type    25000 non-null category\n",
      "latitude           24865 non-null float64\n",
      "license_           24996 non-null float64\n",
      "location           24865 non-null object\n",
      "longitude          24865 non-null float64\n",
      "results            25000 non-null category\n",
      "risk               24995 non-null category\n",
      "state              24994 non-null object\n",
      "violations         23908 non-null object\n",
      "zip                24990 non-null object\n",
      "dtypes: category(4), datetime64[ns](1), float64(3), object(8)\n",
      "memory usage: 2.6+ MB\n"
     ]
    }
   ],
   "source": [
    "dta.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 256,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "inspection_id\n",
       "1965287      Risk 1 (High)\n",
       "1329698      Risk 1 (High)\n",
       "470787       Risk 1 (High)\n",
       "68091      Risk 2 (Medium)\n",
       "1335320       Risk 3 (Low)\n",
       "Name: risk, dtype: category\n",
       "Categories (4, object): [All, Risk 1 (High), Risk 2 (Medium), Risk 3 (Low)]"
      ]
     },
     "execution_count": 256,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "inspection_id\n",
       "1965287               Restaurant\n",
       "1329698               Restaurant\n",
       "470787                Restaurant\n",
       "68091                 Restaurant\n",
       "1335320    Mobile Food Dispenser\n",
       "Name: facility_type, dtype: category\n",
       "Categories (226, object): [1023 CHILDERN'S SERVICES FACILITY, 1023 CHILDREN'S SERVICES FACILITY, 1023-CHILDREN'S SERVICES FACILITY, A-Not-For-Profit Chef Training Program, ..., tavern/restaurant, theater, warehouse, weight loss program]"
      ]
     },
     "execution_count": 256,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dta.risk.head()\n",
    "dta.facility_type.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 181,
   "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>address</th>\n",
       "      <th>aka_name</th>\n",
       "      <th>city</th>\n",
       "      <th>dba_name</th>\n",
       "      <th>facility_type</th>\n",
       "      <th>inspection_date</th>\n",
       "      <th>inspection_type</th>\n",
       "      <th>latitude</th>\n",
       "      <th>license_</th>\n",
       "      <th>location</th>\n",
       "      <th>longitude</th>\n",
       "      <th>results</th>\n",
       "      <th>risk</th>\n",
       "      <th>state</th>\n",
       "      <th>violations</th>\n",
       "      <th>zip</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>inspection_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>68091</th>\n",
       "      <td>2804 N CLARK ST</td>\n",
       "      <td>Wells Street Popcorn</td>\n",
       "      <td>CHICAGO</td>\n",
       "      <td>Wells Street Popcorn</td>\n",
       "      <td>Restaurant</td>\n",
       "      <td>2010-02-01</td>\n",
       "      <td>Canvass</td>\n",
       "      <td>41.932921</td>\n",
       "      <td>1954774.0</td>\n",
       "      <td>{'type': 'Point', 'coordinates': [-87.64515454...</td>\n",
       "      <td>-87.645155</td>\n",
       "      <td>Pass</td>\n",
       "      <td>Risk 2 (Medium)</td>\n",
       "      <td>IL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60657.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233722</th>\n",
       "      <td>3121 W CERMAK RD</td>\n",
       "      <td>TAQUERIA EL PALMAR</td>\n",
       "      <td>CHICAGO</td>\n",
       "      <td>TAQUERIA EL PALMAR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010-05-11</td>\n",
       "      <td>Canvass</td>\n",
       "      <td>41.851674</td>\n",
       "      <td>1243326.0</td>\n",
       "      <td>{'type': 'Point', 'coordinates': [-87.70378752...</td>\n",
       "      <td>-87.703788</td>\n",
       "      <td>Fail</td>\n",
       "      <td>Risk 1 (High)</td>\n",
       "      <td>IL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60623.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284278</th>\n",
       "      <td>3813-3815 W CHICAGO AVE</td>\n",
       "      <td>SUGA RAY'S SPORTS GRILL</td>\n",
       "      <td>CHICAGO</td>\n",
       "      <td>SUGA RAY'S SPORTS GRILL</td>\n",
       "      <td>Restaurant</td>\n",
       "      <td>2010-08-12</td>\n",
       "      <td>Canvass</td>\n",
       "      <td>41.895297</td>\n",
       "      <td>1922230.0</td>\n",
       "      <td>{'type': 'Point', 'coordinates': [-87.72179977...</td>\n",
       "      <td>-87.721800</td>\n",
       "      <td>Out of Business</td>\n",
       "      <td>Risk 2 (Medium)</td>\n",
       "      <td>IL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60651.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231272</th>\n",
       "      <td>1204 W 36TH PL</td>\n",
       "      <td>MOBILE TRUCK #13</td>\n",
       "      <td>CHICAGO</td>\n",
       "      <td>THUNDERBIRD CATERING</td>\n",
       "      <td>Mobile Food Dispenser</td>\n",
       "      <td>2010-03-22</td>\n",
       "      <td>License</td>\n",
       "      <td>41.828094</td>\n",
       "      <td>1476473.0</td>\n",
       "      <td>{'type': 'Point', 'coordinates': [-87.65585369...</td>\n",
       "      <td>-87.655854</td>\n",
       "      <td>Pass</td>\n",
       "      <td>Risk 3 (Low)</td>\n",
       "      <td>IL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60609.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>277874</th>\n",
       "      <td>2826 N LINCOLN AVE</td>\n",
       "      <td>MGM Catering</td>\n",
       "      <td>CHICAGO</td>\n",
       "      <td>MGM Catering</td>\n",
       "      <td>Catering</td>\n",
       "      <td>2010-08-02</td>\n",
       "      <td>License</td>\n",
       "      <td>41.933101</td>\n",
       "      <td>2037141.0</td>\n",
       "      <td>{'type': 'Point', 'coordinates': [-87.65968295...</td>\n",
       "      <td>-87.659683</td>\n",
       "      <td>Pass</td>\n",
       "      <td>Risk 1 (High)</td>\n",
       "      <td>IL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60657.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                address                 aka_name     city  \\\n",
       "inspection_id                                                               \n",
       "68091                  2804 N CLARK ST      Wells Street Popcorn  CHICAGO   \n",
       "233722                3121 W CERMAK RD        TAQUERIA EL PALMAR  CHICAGO   \n",
       "284278         3813-3815 W CHICAGO AVE   SUGA RAY'S SPORTS GRILL  CHICAGO   \n",
       "231272                  1204 W 36TH PL          MOBILE TRUCK #13  CHICAGO   \n",
       "277874              2826 N LINCOLN AVE              MGM Catering  CHICAGO   \n",
       "\n",
       "                              dba_name          facility_type inspection_date  \\\n",
       "inspection_id                                                                   \n",
       "68091             Wells Street Popcorn             Restaurant      2010-02-01   \n",
       "233722              TAQUERIA EL PALMAR                    NaN      2010-05-11   \n",
       "284278         SUGA RAY'S SPORTS GRILL             Restaurant      2010-08-12   \n",
       "231272            THUNDERBIRD CATERING  Mobile Food Dispenser      2010-03-22   \n",
       "277874                    MGM Catering               Catering      2010-08-02   \n",
       "\n",
       "              inspection_type   latitude   license_  \\\n",
       "inspection_id                                         \n",
       "68091                 Canvass  41.932921  1954774.0   \n",
       "233722                Canvass  41.851674  1243326.0   \n",
       "284278                Canvass  41.895297  1922230.0   \n",
       "231272                License  41.828094  1476473.0   \n",
       "277874                License  41.933101  2037141.0   \n",
       "\n",
       "                                                        location  longitude  \\\n",
       "inspection_id                                                                 \n",
       "68091          {'type': 'Point', 'coordinates': [-87.64515454... -87.645155   \n",
       "233722         {'type': 'Point', 'coordinates': [-87.70378752... -87.703788   \n",
       "284278         {'type': 'Point', 'coordinates': [-87.72179977... -87.721800   \n",
       "231272         {'type': 'Point', 'coordinates': [-87.65585369... -87.655854   \n",
       "277874         {'type': 'Point', 'coordinates': [-87.65968295... -87.659683   \n",
       "\n",
       "                       results             risk state violations      zip  \n",
       "inspection_id                                                              \n",
       "68091                     Pass  Risk 2 (Medium)    IL        NaN  60657.0  \n",
       "233722                    Fail    Risk 1 (High)    IL        NaN  60623.0  \n",
       "284278         Out of Business  Risk 2 (Medium)    IL        NaN  60651.0  \n",
       "231272                    Pass     Risk 3 (Low)    IL        NaN  60609.0  \n",
       "277874                    Pass    Risk 1 (High)    IL        NaN  60657.0  "
      ]
     },
     "execution_count": 181,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dta.loc[dta.violations.isnull()].head() #does not seem to be a pattern"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 305,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "inspection_id\n",
      "1965287    35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTRUCTED PER CODE: GOOD REPAIR, SURFACES CLEAN AND DUST-LESS CLEANING METHODS - Comments: MUST CLEAN THE WALLS AT WALL BASE NEAR THE MIXER IN REAR OF PREMISES AND THE PREP AREA OF FOOD SPILLS AND CLEAN THE WALL VENT IN PREP AREA ,INSTRUCTED TO CLEAN AND MAINTAIN AREA | 33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSILS CLEAN, FREE OF ABRASIVE DETERGENTS - Comments: MUST CLEAN THE INTERIOR PANEL OF THE ICE MACHINE IN REAR OF PREMISES | 34. FLOORS: CONS...\n",
      "1329698    33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSILS CLEAN, FREE OF ABRASIVE DETERGENTS - Comments: Non food contact surfaces of ice machine not clean, needs cleaning. \\nNon food contact surfaces of cooler shelving/racks not clean, need cleaning. \\nPrep table lower shelving not clean, need detailed cleaning(crevices). | 34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GOOD REPAIR, COVING INSTALLED, DUST-LESS CLEANING METHODS USED - Comments: Floors under heavy equipment, cooking equipment not clean, n...\n",
      "Name: violations, dtype: object\n"
     ]
    }
   ],
   "source": [
    "with pd.option_context(\"display.max_colwidth\", 500):\n",
    "    print(dta.violations.head(2))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 306,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>10</th>\n",
       "      <th>11</th>\n",
       "      <th>12</th>\n",
       "      <th>13</th>\n",
       "      <th>14</th>\n",
       "      <th>15</th>\n",
       "      <th>16</th>\n",
       "      <th>17</th>\n",
       "      <th>18</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>inspection_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1965287</th>\n",
       "      <td>35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTR...</td>\n",
       "      <td>33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...</td>\n",
       "      <td>34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...</td>\n",
       "      <td>36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...</td>\n",
       "      <td>22. DISH MACHINES: PROVIDED WITH ACCURATE THE...</td>\n",
       "      <td>40. REFRIGERATION AND METAL STEM THERMOMETERS...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1329698</th>\n",
       "      <td>33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSI...</td>\n",
       "      <td>34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...</td>\n",
       "      <td>36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...</td>\n",
       "      <td>38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>470787</th>\n",
       "      <td>6. HANDS WASHED AND CLEANED, GOOD HYGIENIC PRA...</td>\n",
       "      <td>11. ADEQUATE NUMBER, CONVENIENT, ACCESSIBLE, ...</td>\n",
       "      <td>19. OUTSIDE GARBAGE WASTE GREASE AND STORAGE ...</td>\n",
       "      <td>36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...</td>\n",
       "      <td>3. POTENTIALLY HAZARDOUS FOOD MEETS TEMPERATU...</td>\n",
       "      <td>33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...</td>\n",
       "      <td>32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...</td>\n",
       "      <td>35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...</td>\n",
       "      <td>40. REFRIGERATION AND METAL STEM THERMOMETERS...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68091</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1335320</th>\n",
       "      <td>32. FOOD AND NON-FOOD CONTACT SURFACES PROPERL...</td>\n",
       "      <td>38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...</td>\n",
       "      <td>9. WATER SOURCE: SAFE, HOT &amp; COLD UNDER CITY ...</td>\n",
       "      <td>12. HAND WASHING FACILITIES: WITH SOAP AND SA...</td>\n",
       "      <td>18. NO EVIDENCE OF RODENT OR INSECT OUTER OPE...</td>\n",
       "      <td>30. FOOD IN ORIGINAL CONTAINER, PROPERLY LABE...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                              0   \\\n",
       "inspection_id                                                      \n",
       "1965287        35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTR...   \n",
       "1329698        33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSI...   \n",
       "470787         6. HANDS WASHED AND CLEANED, GOOD HYGIENIC PRA...   \n",
       "68091                                                        NaN   \n",
       "1335320        32. FOOD AND NON-FOOD CONTACT SURFACES PROPERL...   \n",
       "\n",
       "                                                              1   \\\n",
       "inspection_id                                                      \n",
       "1965287         33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...   \n",
       "1329698         34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...   \n",
       "470787          11. ADEQUATE NUMBER, CONVENIENT, ACCESSIBLE, ...   \n",
       "68091                                                        NaN   \n",
       "1335320         38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...   \n",
       "\n",
       "                                                              2   \\\n",
       "inspection_id                                                      \n",
       "1965287         34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...   \n",
       "1329698         36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...   \n",
       "470787          19. OUTSIDE GARBAGE WASTE GREASE AND STORAGE ...   \n",
       "68091                                                        NaN   \n",
       "1335320         9. WATER SOURCE: SAFE, HOT & COLD UNDER CITY ...   \n",
       "\n",
       "                                                              3   \\\n",
       "inspection_id                                                      \n",
       "1965287         36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...   \n",
       "1329698         38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...   \n",
       "470787          36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...   \n",
       "68091                                                        NaN   \n",
       "1335320         12. HAND WASHING FACILITIES: WITH SOAP AND SA...   \n",
       "\n",
       "                                                              4   \\\n",
       "inspection_id                                                      \n",
       "1965287         22. DISH MACHINES: PROVIDED WITH ACCURATE THE...   \n",
       "1329698                                                     None   \n",
       "470787          3. POTENTIALLY HAZARDOUS FOOD MEETS TEMPERATU...   \n",
       "68091                                                        NaN   \n",
       "1335320         18. NO EVIDENCE OF RODENT OR INSECT OUTER OPE...   \n",
       "\n",
       "                                                              5   \\\n",
       "inspection_id                                                      \n",
       "1965287         40. REFRIGERATION AND METAL STEM THERMOMETERS...   \n",
       "1329698                                                     None   \n",
       "470787          33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...   \n",
       "68091                                                        NaN   \n",
       "1335320         30. FOOD IN ORIGINAL CONTAINER, PROPERLY LABE...   \n",
       "\n",
       "                                                              6   \\\n",
       "inspection_id                                                      \n",
       "1965287                                                     None   \n",
       "1329698                                                     None   \n",
       "470787          32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...   \n",
       "68091                                                        NaN   \n",
       "1335320                                                     None   \n",
       "\n",
       "                                                              7   \\\n",
       "inspection_id                                                      \n",
       "1965287                                                     None   \n",
       "1329698                                                     None   \n",
       "470787          35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...   \n",
       "68091                                                        NaN   \n",
       "1335320                                                     None   \n",
       "\n",
       "                                                              8     9     10  \\\n",
       "inspection_id                                                                  \n",
       "1965287                                                     None  None  None   \n",
       "1329698                                                     None  None  None   \n",
       "470787          40. REFRIGERATION AND METAL STEM THERMOMETERS...  None  None   \n",
       "68091                                                        NaN   NaN   NaN   \n",
       "1335320                                                     None  None  None   \n",
       "\n",
       "                 11    12    13    14    15    16    17    18  \n",
       "inspection_id                                                  \n",
       "1965287        None  None  None  None  None  None  None  None  \n",
       "1329698        None  None  None  None  None  None  None  None  \n",
       "470787         None  None  None  None  None  None  None  None  \n",
       "68091           NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "1335320        None  None  None  None  None  None  None  None  "
      ]
     },
     "execution_count": 306,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "violations = dta.violations.str.split(\"\\|\", expand=True)\n",
    "violations.head()\n",
    "#19 columns because that was the maximum violations at one site"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 307,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "19.0"
      ]
     },
     "execution_count": 307,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "4.924000334616028"
      ]
     },
     "execution_count": 307,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "4.0"
      ]
     },
     "execution_count": 307,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(dta.violations.str.count(\"\\|\") + 1).max()\n",
    "(dta.violations.str.count(\"\\|\") + 1).mean()\n",
    "(dta.violations.str.count(\"\\|\") + 1).median()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 308,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "inspection_id   \n",
       "1965287        0    35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTR...\n",
       "               1     33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...\n",
       "               2     34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...\n",
       "               3     36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...\n",
       "               4     22. DISH MACHINES: PROVIDED WITH ACCURATE THE...\n",
       "               5     40. REFRIGERATION AND METAL STEM THERMOMETERS...\n",
       "1329698        0    33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSI...\n",
       "               1     34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...\n",
       "               2     36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...\n",
       "               3     38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...\n",
       "470787         0    6. HANDS WASHED AND CLEANED, GOOD HYGIENIC PRA...\n",
       "               1     11. ADEQUATE NUMBER, CONVENIENT, ACCESSIBLE, ...\n",
       "               2     19. OUTSIDE GARBAGE WASTE GREASE AND STORAGE ...\n",
       "               3     36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...\n",
       "               4     3. POTENTIALLY HAZARDOUS FOOD MEETS TEMPERATU...\n",
       "dtype: object"
      ]
     },
     "execution_count": 308,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "violations.stack().head(15)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 309,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>10</th>\n",
       "      <th>11</th>\n",
       "      <th>12</th>\n",
       "      <th>13</th>\n",
       "      <th>14</th>\n",
       "      <th>15</th>\n",
       "      <th>16</th>\n",
       "      <th>17</th>\n",
       "      <th>18</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>inspection_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>44249</th>\n",
       "      <td>41. PREMISES MAINTAINED FREE OF LITTER, UNNECE...</td>\n",
       "      <td>18. NO EVIDENCE OF RODENT OR INSECT OUTER OPE...</td>\n",
       "      <td>35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...</td>\n",
       "      <td>33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...</td>\n",
       "      <td>34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44259</th>\n",
       "      <td>32. FOOD AND NON-FOOD CONTACT SURFACES PROPERL...</td>\n",
       "      <td>33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44262</th>\n",
       "      <td>33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSI...</td>\n",
       "      <td>34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...</td>\n",
       "      <td>35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48225</th>\n",
       "      <td>32. FOOD AND NON-FOOD CONTACT SURFACES PROPERL...</td>\n",
       "      <td>38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...</td>\n",
       "      <td>34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52237</th>\n",
       "      <td>16. FOOD PROTECTED DURING STORAGE, PREPARATION...</td>\n",
       "      <td>26. ADEQUATE NUMBER, CONVENIENT, ACCESSIBLE, ...</td>\n",
       "      <td>32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...</td>\n",
       "      <td>35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...</td>\n",
       "      <td>38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52241</th>\n",
       "      <td>19. OUTSIDE GARBAGE WASTE GREASE AND STORAGE A...</td>\n",
       "      <td>24. DISH WASHING FACILITIES: PROPERLY DESIGNE...</td>\n",
       "      <td>36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52245</th>\n",
       "      <td>3. POTENTIALLY HAZARDOUS FOOD MEETS TEMPERATUR...</td>\n",
       "      <td>17. POTENTIALLY HAZARDOUS FOOD PROPERLY THAWE...</td>\n",
       "      <td>29. PREVIOUS MINOR VIOLATION(S) CORRECTED 7-4...</td>\n",
       "      <td>32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...</td>\n",
       "      <td>38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52246</th>\n",
       "      <td>32. FOOD AND NON-FOOD CONTACT SURFACES PROPERL...</td>\n",
       "      <td>34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...</td>\n",
       "      <td>36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52247</th>\n",
       "      <td>12. HAND WASHING FACILITIES: WITH SOAP AND SAN...</td>\n",
       "      <td>18. NO EVIDENCE OF RODENT OR INSECT OUTER OPE...</td>\n",
       "      <td>32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...</td>\n",
       "      <td>33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...</td>\n",
       "      <td>34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...</td>\n",
       "      <td>38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52250</th>\n",
       "      <td>35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTR...</td>\n",
       "      <td>34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...</td>\n",
       "      <td>32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...</td>\n",
       "      <td>19. OUTSIDE GARBAGE WASTE GREASE AND STORAGE ...</td>\n",
       "      <td>18. NO EVIDENCE OF RODENT OR INSECT OUTER OPE...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52262</th>\n",
       "      <td>2. FACILITIES TO MAINTAIN PROPER TEMPERATURE -...</td>\n",
       "      <td>3. POTENTIALLY HAZARDOUS FOOD MEETS TEMPERATU...</td>\n",
       "      <td>18. NO EVIDENCE OF RODENT OR INSECT OUTER OPE...</td>\n",
       "      <td>33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...</td>\n",
       "      <td>36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52267</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52270</th>\n",
       "      <td>32. FOOD AND NON-FOOD CONTACT SURFACES PROPERL...</td>\n",
       "      <td>30. FOOD IN ORIGINAL CONTAINER, PROPERLY LABE...</td>\n",
       "      <td>33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...</td>\n",
       "      <td>34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...</td>\n",
       "      <td>35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...</td>\n",
       "      <td>36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52272</th>\n",
       "      <td>16. FOOD PROTECTED DURING STORAGE, PREPARATION...</td>\n",
       "      <td>29. PREVIOUS MINOR VIOLATION(S) CORRECTED 7-4...</td>\n",
       "      <td>35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...</td>\n",
       "      <td>36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54214</th>\n",
       "      <td>41. PREMISES MAINTAINED FREE OF LITTER, UNNECE...</td>\n",
       "      <td>38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...</td>\n",
       "      <td>12. HAND WASHING FACILITIES: WITH SOAP AND SA...</td>\n",
       "      <td>20. INSIDE CONTAINERS OR RECEPTACLES: ADEQUAT...</td>\n",
       "      <td>33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...</td>\n",
       "      <td>34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...</td>\n",
       "      <td>35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...</td>\n",
       "      <td>36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...</td>\n",
       "      <td>40. REFRIGERATION AND METAL STEM THERMOMETERS...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54217</th>\n",
       "      <td>21. * CERTIFIED FOOD MANAGER ON SITE WHEN POTE...</td>\n",
       "      <td>34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...</td>\n",
       "      <td>33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...</td>\n",
       "      <td>18. NO EVIDENCE OF RODENT OR INSECT OUTER OPE...</td>\n",
       "      <td>41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54222</th>\n",
       "      <td>18. NO EVIDENCE OF RODENT OR INSECT OUTER OPEN...</td>\n",
       "      <td>21. * CERTIFIED FOOD MANAGER ON SITE WHEN POT...</td>\n",
       "      <td>29. PREVIOUS MINOR VIOLATION(S) CORRECTED 7-4...</td>\n",
       "      <td>32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...</td>\n",
       "      <td>38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54228</th>\n",
       "      <td>21. * CERTIFIED FOOD MANAGER ON SITE WHEN POTE...</td>\n",
       "      <td>26. ADEQUATE NUMBER, CONVENIENT, ACCESSIBLE, ...</td>\n",
       "      <td>34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...</td>\n",
       "      <td>37. TOILET ROOM DOORS SELF CLOSING: DRESSING ...</td>\n",
       "      <td>38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54232</th>\n",
       "      <td>38. VENTILATION: ROOMS AND EQUIPMENT VENTED AS...</td>\n",
       "      <td>34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...</td>\n",
       "      <td>41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54239</th>\n",
       "      <td>29. PREVIOUS MINOR VIOLATION(S) CORRECTED 7-42...</td>\n",
       "      <td>33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...</td>\n",
       "      <td>37. TOILET ROOM DOORS SELF CLOSING: DRESSING ...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54242</th>\n",
       "      <td>34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GOO...</td>\n",
       "      <td>38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...</td>\n",
       "      <td>41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54248</th>\n",
       "      <td>33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSI...</td>\n",
       "      <td>32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...</td>\n",
       "      <td>36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...</td>\n",
       "      <td>38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...</td>\n",
       "      <td>19. OUTSIDE GARBAGE WASTE GREASE AND STORAGE ...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54251</th>\n",
       "      <td>38. VENTILATION: ROOMS AND EQUIPMENT VENTED AS...</td>\n",
       "      <td>41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54256</th>\n",
       "      <td>33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSI...</td>\n",
       "      <td>34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...</td>\n",
       "      <td>35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...</td>\n",
       "      <td>36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...</td>\n",
       "      <td>37. TOILET ROOM DOORS SELF CLOSING: DRESSING ...</td>\n",
       "      <td>38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58227</th>\n",
       "      <td>18. NO EVIDENCE OF RODENT OR INSECT OUTER OPEN...</td>\n",
       "      <td>34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...</td>\n",
       "      <td>36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...</td>\n",
       "      <td>41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58239</th>\n",
       "      <td>38. VENTILATION: ROOMS AND EQUIPMENT VENTED AS...</td>\n",
       "      <td>41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58243</th>\n",
       "      <td>35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTR...</td>\n",
       "      <td>38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58251</th>\n",
       "      <td>38. VENTILATION: ROOMS AND EQUIPMENT VENTED AS...</td>\n",
       "      <td>41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...</td>\n",
       "      <td>29. PREVIOUS MINOR VIOLATION(S) CORRECTED 7-4...</td>\n",
       "      <td>34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...</td>\n",
       "      <td>37. TOILET ROOM DOORS SELF CLOSING: DRESSING ...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58254</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58267</th>\n",
       "      <td>18. NO EVIDENCE OF RODENT OR INSECT OUTER OPEN...</td>\n",
       "      <td>32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...</td>\n",
       "      <td>33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...</td>\n",
       "      <td>34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...</td>\n",
       "      <td>35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...</td>\n",
       "      <td>36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...</td>\n",
       "      <td>38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...</td>\n",
       "      <td>40. REFRIGERATION AND METAL STEM THERMOMETERS...</td>\n",
       "      <td>41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2098955</th>\n",
       "      <td>14. PREVIOUS SERIOUS VIOLATION CORRECTED, 7-42...</td>\n",
       "      <td>32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...</td>\n",
       "      <td>33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...</td>\n",
       "      <td>36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...</td>\n",
       "      <td>38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...</td>\n",
       "      <td>41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2098962</th>\n",
       "      <td>40. REFRIGERATION AND METAL STEM THERMOMETERS ...</td>\n",
       "      <td>33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...</td>\n",
       "      <td>16. FOOD PROTECTED DURING STORAGE, PREPARATIO...</td>\n",
       "      <td>18. NO EVIDENCE OF RODENT OR INSECT OUTER OPE...</td>\n",
       "      <td>34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...</td>\n",
       "      <td>36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...</td>\n",
       "      <td>38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2098965</th>\n",
       "      <td>33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSI...</td>\n",
       "      <td>32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...</td>\n",
       "      <td>34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...</td>\n",
       "      <td>41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...</td>\n",
       "      <td>30. FOOD IN ORIGINAL CONTAINER, PROPERLY LABE...</td>\n",
       "      <td>35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...</td>\n",
       "      <td>3. POTENTIALLY HAZARDOUS FOOD MEETS TEMPERATU...</td>\n",
       "      <td>11. ADEQUATE NUMBER, CONVENIENT, ACCESSIBLE, ...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2098971</th>\n",
       "      <td>29. PREVIOUS MINOR VIOLATION(S) CORRECTED 7-42...</td>\n",
       "      <td>22. DISH MACHINES: PROVIDED WITH ACCURATE THE...</td>\n",
       "      <td>32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...</td>\n",
       "      <td>33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...</td>\n",
       "      <td>35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...</td>\n",
       "      <td>41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2098993</th>\n",
       "      <td>3. POTENTIALLY HAZARDOUS FOOD MEETS TEMPERATUR...</td>\n",
       "      <td>21. * CERTIFIED FOOD MANAGER ON SITE WHEN POT...</td>\n",
       "      <td>33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...</td>\n",
       "      <td>34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...</td>\n",
       "      <td>38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2099002</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2099019</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2099030</th>\n",
       "      <td>43. FOOD (ICE) DISPENSING UTENSILS, WASH CLOTH...</td>\n",
       "      <td>32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...</td>\n",
       "      <td>35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2099031</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2099046</th>\n",
       "      <td>36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES OF...</td>\n",
       "      <td>32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...</td>\n",
       "      <td>41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...</td>\n",
       "      <td>40. REFRIGERATION AND METAL STEM THERMOMETERS...</td>\n",
       "      <td>35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...</td>\n",
       "      <td>1. SOURCE SOUND CONDITION, NO SPOILAGE, FOODS...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2099053</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2099055</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2099058</th>\n",
       "      <td>32. FOOD AND NON-FOOD CONTACT SURFACES PROPERL...</td>\n",
       "      <td>34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2099083</th>\n",
       "      <td>38. VENTILATION: ROOMS AND EQUIPMENT VENTED AS...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2099093</th>\n",
       "      <td>11. ADEQUATE NUMBER, CONVENIENT, ACCESSIBLE, D...</td>\n",
       "      <td>12. HAND WASHING FACILITIES: WITH SOAP AND SA...</td>\n",
       "      <td>18. NO EVIDENCE OF RODENT OR INSECT OUTER OPE...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2099097</th>\n",
       "      <td>34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GOO...</td>\n",
       "      <td>33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2099102</th>\n",
       "      <td>30. FOOD IN ORIGINAL CONTAINER, PROPERLY LABEL...</td>\n",
       "      <td>32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...</td>\n",
       "      <td>34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2099104</th>\n",
       "      <td>32. FOOD AND NON-FOOD CONTACT SURFACES PROPERL...</td>\n",
       "      <td>35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...</td>\n",
       "      <td>41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...</td>\n",
       "      <td>43. FOOD (ICE) DISPENSING UTENSILS, WASH CLOT...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2099153</th>\n",
       "      <td>27. TOILET ROOMS ENCLOSED CLEAN, PROVIDED WITH...</td>\n",
       "      <td>32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2099175</th>\n",
       "      <td>32. FOOD AND NON-FOOD CONTACT SURFACES PROPERL...</td>\n",
       "      <td>37. TOILET ROOM DOORS SELF CLOSING: DRESSING ...</td>\n",
       "      <td>35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...</td>\n",
       "      <td>40. REFRIGERATION AND METAL STEM THERMOMETERS...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2099186</th>\n",
       "      <td>12. HAND WASHING FACILITIES: WITH SOAP AND SAN...</td>\n",
       "      <td>16. FOOD PROTECTED DURING STORAGE, PREPARATIO...</td>\n",
       "      <td>33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...</td>\n",
       "      <td>35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2102218</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2102224</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2102229</th>\n",
       "      <td>16. FOOD PROTECTED DURING STORAGE, PREPARATION...</td>\n",
       "      <td>35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...</td>\n",
       "      <td>45. FOOD HANDLER REQUIREMENTS MET - Comments:...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2102234</th>\n",
       "      <td>18. NO EVIDENCE OF RODENT OR INSECT OUTER OPEN...</td>\n",
       "      <td>34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...</td>\n",
       "      <td>24. DISH WASHING FACILITIES: PROPERLY DESIGNE...</td>\n",
       "      <td>24. DISH WASHING FACILITIES: PROPERLY DESIGNE...</td>\n",
       "      <td>32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2102251</th>\n",
       "      <td>2. FACILITIES TO MAINTAIN PROPER TEMPERATURE -...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2102254</th>\n",
       "      <td>3. POTENTIALLY HAZARDOUS FOOD MEETS TEMPERATUR...</td>\n",
       "      <td>33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...</td>\n",
       "      <td>34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...</td>\n",
       "      <td>38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...</td>\n",
       "      <td>35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...</td>\n",
       "      <td>30. FOOD IN ORIGINAL CONTAINER, PROPERLY LABE...</td>\n",
       "      <td>41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2102269</th>\n",
       "      <td>32. FOOD AND NON-FOOD CONTACT SURFACES PROPERL...</td>\n",
       "      <td>35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2102275</th>\n",
       "      <td>14. PREVIOUS SERIOUS VIOLATION CORRECTED, 7-42...</td>\n",
       "      <td>33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...</td>\n",
       "      <td>34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...</td>\n",
       "      <td>35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...</td>\n",
       "      <td>40. REFRIGERATION AND METAL STEM THERMOMETERS...</td>\n",
       "      <td>41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2102294</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>25000 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                              0   \\\n",
       "inspection_id                                                      \n",
       "44249          41. PREMISES MAINTAINED FREE OF LITTER, UNNECE...   \n",
       "44259          32. FOOD AND NON-FOOD CONTACT SURFACES PROPERL...   \n",
       "44262          33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSI...   \n",
       "48225          32. FOOD AND NON-FOOD CONTACT SURFACES PROPERL...   \n",
       "52237          16. FOOD PROTECTED DURING STORAGE, PREPARATION...   \n",
       "52241          19. OUTSIDE GARBAGE WASTE GREASE AND STORAGE A...   \n",
       "52245          3. POTENTIALLY HAZARDOUS FOOD MEETS TEMPERATUR...   \n",
       "52246          32. FOOD AND NON-FOOD CONTACT SURFACES PROPERL...   \n",
       "52247          12. HAND WASHING FACILITIES: WITH SOAP AND SAN...   \n",
       "52250          35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTR...   \n",
       "52262          2. FACILITIES TO MAINTAIN PROPER TEMPERATURE -...   \n",
       "52267                                                        NaN   \n",
       "52270          32. FOOD AND NON-FOOD CONTACT SURFACES PROPERL...   \n",
       "52272          16. FOOD PROTECTED DURING STORAGE, PREPARATION...   \n",
       "54214          41. PREMISES MAINTAINED FREE OF LITTER, UNNECE...   \n",
       "54217          21. * CERTIFIED FOOD MANAGER ON SITE WHEN POTE...   \n",
       "54222          18. NO EVIDENCE OF RODENT OR INSECT OUTER OPEN...   \n",
       "54228          21. * CERTIFIED FOOD MANAGER ON SITE WHEN POTE...   \n",
       "54232          38. VENTILATION: ROOMS AND EQUIPMENT VENTED AS...   \n",
       "54239          29. PREVIOUS MINOR VIOLATION(S) CORRECTED 7-42...   \n",
       "54242          34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GOO...   \n",
       "54248          33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSI...   \n",
       "54251          38. VENTILATION: ROOMS AND EQUIPMENT VENTED AS...   \n",
       "54256          33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSI...   \n",
       "58227          18. NO EVIDENCE OF RODENT OR INSECT OUTER OPEN...   \n",
       "58239          38. VENTILATION: ROOMS AND EQUIPMENT VENTED AS...   \n",
       "58243          35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTR...   \n",
       "58251          38. VENTILATION: ROOMS AND EQUIPMENT VENTED AS...   \n",
       "58254                                                        NaN   \n",
       "58267          18. NO EVIDENCE OF RODENT OR INSECT OUTER OPEN...   \n",
       "...                                                          ...   \n",
       "2098955        14. PREVIOUS SERIOUS VIOLATION CORRECTED, 7-42...   \n",
       "2098962        40. REFRIGERATION AND METAL STEM THERMOMETERS ...   \n",
       "2098965        33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSI...   \n",
       "2098971        29. PREVIOUS MINOR VIOLATION(S) CORRECTED 7-42...   \n",
       "2098993        3. POTENTIALLY HAZARDOUS FOOD MEETS TEMPERATUR...   \n",
       "2099002                                                      NaN   \n",
       "2099019                                                      NaN   \n",
       "2099030        43. FOOD (ICE) DISPENSING UTENSILS, WASH CLOTH...   \n",
       "2099031                                                      NaN   \n",
       "2099046        36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES OF...   \n",
       "2099053                                                      NaN   \n",
       "2099055                                                      NaN   \n",
       "2099058        32. FOOD AND NON-FOOD CONTACT SURFACES PROPERL...   \n",
       "2099083        38. VENTILATION: ROOMS AND EQUIPMENT VENTED AS...   \n",
       "2099093        11. ADEQUATE NUMBER, CONVENIENT, ACCESSIBLE, D...   \n",
       "2099097        34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GOO...   \n",
       "2099102        30. FOOD IN ORIGINAL CONTAINER, PROPERLY LABEL...   \n",
       "2099104        32. FOOD AND NON-FOOD CONTACT SURFACES PROPERL...   \n",
       "2099153        27. TOILET ROOMS ENCLOSED CLEAN, PROVIDED WITH...   \n",
       "2099175        32. FOOD AND NON-FOOD CONTACT SURFACES PROPERL...   \n",
       "2099186        12. HAND WASHING FACILITIES: WITH SOAP AND SAN...   \n",
       "2102218                                                      NaN   \n",
       "2102224                                                      NaN   \n",
       "2102229        16. FOOD PROTECTED DURING STORAGE, PREPARATION...   \n",
       "2102234        18. NO EVIDENCE OF RODENT OR INSECT OUTER OPEN...   \n",
       "2102251        2. FACILITIES TO MAINTAIN PROPER TEMPERATURE -...   \n",
       "2102254        3. POTENTIALLY HAZARDOUS FOOD MEETS TEMPERATUR...   \n",
       "2102269        32. FOOD AND NON-FOOD CONTACT SURFACES PROPERL...   \n",
       "2102275        14. PREVIOUS SERIOUS VIOLATION CORRECTED, 7-42...   \n",
       "2102294                                                      NaN   \n",
       "\n",
       "                                                              1   \\\n",
       "inspection_id                                                      \n",
       "44249           18. NO EVIDENCE OF RODENT OR INSECT OUTER OPE...   \n",
       "44259           33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...   \n",
       "44262           34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...   \n",
       "48225           38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...   \n",
       "52237           26. ADEQUATE NUMBER, CONVENIENT, ACCESSIBLE, ...   \n",
       "52241           24. DISH WASHING FACILITIES: PROPERLY DESIGNE...   \n",
       "52245           17. POTENTIALLY HAZARDOUS FOOD PROPERLY THAWE...   \n",
       "52246           34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...   \n",
       "52247           18. NO EVIDENCE OF RODENT OR INSECT OUTER OPE...   \n",
       "52250           34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...   \n",
       "52262           3. POTENTIALLY HAZARDOUS FOOD MEETS TEMPERATU...   \n",
       "52267                                                        NaN   \n",
       "52270           30. FOOD IN ORIGINAL CONTAINER, PROPERLY LABE...   \n",
       "52272           29. PREVIOUS MINOR VIOLATION(S) CORRECTED 7-4...   \n",
       "54214           38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...   \n",
       "54217           34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...   \n",
       "54222           21. * CERTIFIED FOOD MANAGER ON SITE WHEN POT...   \n",
       "54228           26. ADEQUATE NUMBER, CONVENIENT, ACCESSIBLE, ...   \n",
       "54232           34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...   \n",
       "54239           33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...   \n",
       "54242           38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...   \n",
       "54248           32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...   \n",
       "54251           41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...   \n",
       "54256           34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...   \n",
       "58227           34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...   \n",
       "58239           41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...   \n",
       "58243           38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...   \n",
       "58251           41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...   \n",
       "58254                                                        NaN   \n",
       "58267           32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...   \n",
       "...                                                          ...   \n",
       "2098955         32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...   \n",
       "2098962         33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...   \n",
       "2098965         32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...   \n",
       "2098971         22. DISH MACHINES: PROVIDED WITH ACCURATE THE...   \n",
       "2098993         21. * CERTIFIED FOOD MANAGER ON SITE WHEN POT...   \n",
       "2099002                                                      NaN   \n",
       "2099019                                                      NaN   \n",
       "2099030         32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...   \n",
       "2099031                                                      NaN   \n",
       "2099046         32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...   \n",
       "2099053                                                      NaN   \n",
       "2099055                                                      NaN   \n",
       "2099058         34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...   \n",
       "2099083                                                     None   \n",
       "2099093         12. HAND WASHING FACILITIES: WITH SOAP AND SA...   \n",
       "2099097         33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...   \n",
       "2099102         32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...   \n",
       "2099104         35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...   \n",
       "2099153         32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...   \n",
       "2099175         37. TOILET ROOM DOORS SELF CLOSING: DRESSING ...   \n",
       "2099186         16. FOOD PROTECTED DURING STORAGE, PREPARATIO...   \n",
       "2102218                                                      NaN   \n",
       "2102224                                                      NaN   \n",
       "2102229         35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...   \n",
       "2102234         34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...   \n",
       "2102251                                                     None   \n",
       "2102254         33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...   \n",
       "2102269         35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...   \n",
       "2102275         33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...   \n",
       "2102294                                                      NaN   \n",
       "\n",
       "                                                              2   \\\n",
       "inspection_id                                                      \n",
       "44249           35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...   \n",
       "44259                                                       None   \n",
       "44262           35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...   \n",
       "48225           34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...   \n",
       "52237           32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...   \n",
       "52241           36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...   \n",
       "52245           29. PREVIOUS MINOR VIOLATION(S) CORRECTED 7-4...   \n",
       "52246           36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...   \n",
       "52247           32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...   \n",
       "52250           32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...   \n",
       "52262           18. NO EVIDENCE OF RODENT OR INSECT OUTER OPE...   \n",
       "52267                                                        NaN   \n",
       "52270           33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...   \n",
       "52272           35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...   \n",
       "54214           12. HAND WASHING FACILITIES: WITH SOAP AND SA...   \n",
       "54217           33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...   \n",
       "54222           29. PREVIOUS MINOR VIOLATION(S) CORRECTED 7-4...   \n",
       "54228           34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...   \n",
       "54232           41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...   \n",
       "54239           37. TOILET ROOM DOORS SELF CLOSING: DRESSING ...   \n",
       "54242           41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...   \n",
       "54248           36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...   \n",
       "54251                                                       None   \n",
       "54256           35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...   \n",
       "58227           36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...   \n",
       "58239                                                       None   \n",
       "58243                                                       None   \n",
       "58251           29. PREVIOUS MINOR VIOLATION(S) CORRECTED 7-4...   \n",
       "58254                                                        NaN   \n",
       "58267           33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...   \n",
       "...                                                          ...   \n",
       "2098955         33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...   \n",
       "2098962         16. FOOD PROTECTED DURING STORAGE, PREPARATIO...   \n",
       "2098965         34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...   \n",
       "2098971         32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...   \n",
       "2098993         33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...   \n",
       "2099002                                                      NaN   \n",
       "2099019                                                      NaN   \n",
       "2099030         35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...   \n",
       "2099031                                                      NaN   \n",
       "2099046         41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...   \n",
       "2099053                                                      NaN   \n",
       "2099055                                                      NaN   \n",
       "2099058                                                     None   \n",
       "2099083                                                     None   \n",
       "2099093         18. NO EVIDENCE OF RODENT OR INSECT OUTER OPE...   \n",
       "2099097                                                     None   \n",
       "2099102         34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...   \n",
       "2099104         41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...   \n",
       "2099153                                                     None   \n",
       "2099175         35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...   \n",
       "2099186         33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...   \n",
       "2102218                                                      NaN   \n",
       "2102224                                                      NaN   \n",
       "2102229         45. FOOD HANDLER REQUIREMENTS MET - Comments:...   \n",
       "2102234         24. DISH WASHING FACILITIES: PROPERLY DESIGNE...   \n",
       "2102251                                                     None   \n",
       "2102254         34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...   \n",
       "2102269                                                     None   \n",
       "2102275         34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...   \n",
       "2102294                                                      NaN   \n",
       "\n",
       "                                                              3   \\\n",
       "inspection_id                                                      \n",
       "44249           33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...   \n",
       "44259                                                       None   \n",
       "44262                                                       None   \n",
       "48225                                                       None   \n",
       "52237           35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...   \n",
       "52241                                                       None   \n",
       "52245           32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...   \n",
       "52246                                                       None   \n",
       "52247           33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...   \n",
       "52250           19. OUTSIDE GARBAGE WASTE GREASE AND STORAGE ...   \n",
       "52262           33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...   \n",
       "52267                                                        NaN   \n",
       "52270           34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...   \n",
       "52272           36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...   \n",
       "54214           20. INSIDE CONTAINERS OR RECEPTACLES: ADEQUAT...   \n",
       "54217           18. NO EVIDENCE OF RODENT OR INSECT OUTER OPE...   \n",
       "54222           32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...   \n",
       "54228           37. TOILET ROOM DOORS SELF CLOSING: DRESSING ...   \n",
       "54232                                                       None   \n",
       "54239                                                       None   \n",
       "54242                                                       None   \n",
       "54248           38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...   \n",
       "54251                                                       None   \n",
       "54256           36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...   \n",
       "58227           41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...   \n",
       "58239                                                       None   \n",
       "58243                                                       None   \n",
       "58251           34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...   \n",
       "58254                                                        NaN   \n",
       "58267           34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...   \n",
       "...                                                          ...   \n",
       "2098955         36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...   \n",
       "2098962         18. NO EVIDENCE OF RODENT OR INSECT OUTER OPE...   \n",
       "2098965         41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...   \n",
       "2098971         33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...   \n",
       "2098993         34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...   \n",
       "2099002                                                      NaN   \n",
       "2099019                                                      NaN   \n",
       "2099030                                                     None   \n",
       "2099031                                                      NaN   \n",
       "2099046         40. REFRIGERATION AND METAL STEM THERMOMETERS...   \n",
       "2099053                                                      NaN   \n",
       "2099055                                                      NaN   \n",
       "2099058                                                     None   \n",
       "2099083                                                     None   \n",
       "2099093                                                     None   \n",
       "2099097                                                     None   \n",
       "2099102                                                     None   \n",
       "2099104         43. FOOD (ICE) DISPENSING UTENSILS, WASH CLOT...   \n",
       "2099153                                                     None   \n",
       "2099175         40. REFRIGERATION AND METAL STEM THERMOMETERS...   \n",
       "2099186         35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...   \n",
       "2102218                                                      NaN   \n",
       "2102224                                                      NaN   \n",
       "2102229                                                     None   \n",
       "2102234         24. DISH WASHING FACILITIES: PROPERLY DESIGNE...   \n",
       "2102251                                                     None   \n",
       "2102254         38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...   \n",
       "2102269                                                     None   \n",
       "2102275         35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...   \n",
       "2102294                                                      NaN   \n",
       "\n",
       "                                                              4   \\\n",
       "inspection_id                                                      \n",
       "44249           34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...   \n",
       "44259                                                       None   \n",
       "44262                                                       None   \n",
       "48225                                                       None   \n",
       "52237           38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...   \n",
       "52241                                                       None   \n",
       "52245           38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...   \n",
       "52246                                                       None   \n",
       "52247           34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...   \n",
       "52250           18. NO EVIDENCE OF RODENT OR INSECT OUTER OPE...   \n",
       "52262           36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...   \n",
       "52267                                                        NaN   \n",
       "52270           35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...   \n",
       "52272                                                       None   \n",
       "54214           33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...   \n",
       "54217           41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...   \n",
       "54222           38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...   \n",
       "54228           38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...   \n",
       "54232                                                       None   \n",
       "54239                                                       None   \n",
       "54242                                                       None   \n",
       "54248           19. OUTSIDE GARBAGE WASTE GREASE AND STORAGE ...   \n",
       "54251                                                       None   \n",
       "54256           37. TOILET ROOM DOORS SELF CLOSING: DRESSING ...   \n",
       "58227                                                       None   \n",
       "58239                                                       None   \n",
       "58243                                                       None   \n",
       "58251           37. TOILET ROOM DOORS SELF CLOSING: DRESSING ...   \n",
       "58254                                                        NaN   \n",
       "58267           35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...   \n",
       "...                                                          ...   \n",
       "2098955         38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...   \n",
       "2098962         34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...   \n",
       "2098965         30. FOOD IN ORIGINAL CONTAINER, PROPERLY LABE...   \n",
       "2098971         35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...   \n",
       "2098993         38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...   \n",
       "2099002                                                      NaN   \n",
       "2099019                                                      NaN   \n",
       "2099030                                                     None   \n",
       "2099031                                                      NaN   \n",
       "2099046         35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...   \n",
       "2099053                                                      NaN   \n",
       "2099055                                                      NaN   \n",
       "2099058                                                     None   \n",
       "2099083                                                     None   \n",
       "2099093                                                     None   \n",
       "2099097                                                     None   \n",
       "2099102                                                     None   \n",
       "2099104                                                     None   \n",
       "2099153                                                     None   \n",
       "2099175                                                     None   \n",
       "2099186                                                     None   \n",
       "2102218                                                      NaN   \n",
       "2102224                                                      NaN   \n",
       "2102229                                                     None   \n",
       "2102234         32. FOOD AND NON-FOOD CONTACT SURFACES PROPER...   \n",
       "2102251                                                     None   \n",
       "2102254         35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...   \n",
       "2102269                                                     None   \n",
       "2102275         40. REFRIGERATION AND METAL STEM THERMOMETERS...   \n",
       "2102294                                                      NaN   \n",
       "\n",
       "                                                              5   \\\n",
       "inspection_id                                                      \n",
       "44249                                                       None   \n",
       "44259                                                       None   \n",
       "44262                                                       None   \n",
       "48225                                                       None   \n",
       "52237                                                       None   \n",
       "52241                                                       None   \n",
       "52245                                                       None   \n",
       "52246                                                       None   \n",
       "52247           38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...   \n",
       "52250                                                       None   \n",
       "52262                                                       None   \n",
       "52267                                                        NaN   \n",
       "52270           36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...   \n",
       "52272                                                       None   \n",
       "54214           34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...   \n",
       "54217                                                       None   \n",
       "54222                                                       None   \n",
       "54228                                                       None   \n",
       "54232                                                       None   \n",
       "54239                                                       None   \n",
       "54242                                                       None   \n",
       "54248                                                       None   \n",
       "54251                                                       None   \n",
       "54256           38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...   \n",
       "58227                                                       None   \n",
       "58239                                                       None   \n",
       "58243                                                       None   \n",
       "58251                                                       None   \n",
       "58254                                                        NaN   \n",
       "58267           36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...   \n",
       "...                                                          ...   \n",
       "2098955         41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...   \n",
       "2098962         36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...   \n",
       "2098965         35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...   \n",
       "2098971         41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...   \n",
       "2098993                                                     None   \n",
       "2099002                                                      NaN   \n",
       "2099019                                                      NaN   \n",
       "2099030                                                     None   \n",
       "2099031                                                      NaN   \n",
       "2099046         1. SOURCE SOUND CONDITION, NO SPOILAGE, FOODS...   \n",
       "2099053                                                      NaN   \n",
       "2099055                                                      NaN   \n",
       "2099058                                                     None   \n",
       "2099083                                                     None   \n",
       "2099093                                                     None   \n",
       "2099097                                                     None   \n",
       "2099102                                                     None   \n",
       "2099104                                                     None   \n",
       "2099153                                                     None   \n",
       "2099175                                                     None   \n",
       "2099186                                                     None   \n",
       "2102218                                                      NaN   \n",
       "2102224                                                      NaN   \n",
       "2102229                                                     None   \n",
       "2102234                                                     None   \n",
       "2102251                                                     None   \n",
       "2102254         30. FOOD IN ORIGINAL CONTAINER, PROPERLY LABE...   \n",
       "2102269                                                     None   \n",
       "2102275         41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...   \n",
       "2102294                                                      NaN   \n",
       "\n",
       "                                                              6   \\\n",
       "inspection_id                                                      \n",
       "44249                                                       None   \n",
       "44259                                                       None   \n",
       "44262                                                       None   \n",
       "48225                                                       None   \n",
       "52237                                                       None   \n",
       "52241                                                       None   \n",
       "52245                                                       None   \n",
       "52246                                                       None   \n",
       "52247                                                       None   \n",
       "52250                                                       None   \n",
       "52262                                                       None   \n",
       "52267                                                        NaN   \n",
       "52270                                                       None   \n",
       "52272                                                       None   \n",
       "54214           35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONST...   \n",
       "54217                                                       None   \n",
       "54222                                                       None   \n",
       "54228                                                       None   \n",
       "54232                                                       None   \n",
       "54239                                                       None   \n",
       "54242                                                       None   \n",
       "54248                                                       None   \n",
       "54251                                                       None   \n",
       "54256                                                       None   \n",
       "58227                                                       None   \n",
       "58239                                                       None   \n",
       "58243                                                       None   \n",
       "58251                                                       None   \n",
       "58254                                                        NaN   \n",
       "58267           38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...   \n",
       "...                                                          ...   \n",
       "2098955                                                     None   \n",
       "2098962         38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...   \n",
       "2098965         3. POTENTIALLY HAZARDOUS FOOD MEETS TEMPERATU...   \n",
       "2098971                                                     None   \n",
       "2098993                                                     None   \n",
       "2099002                                                      NaN   \n",
       "2099019                                                      NaN   \n",
       "2099030                                                     None   \n",
       "2099031                                                      NaN   \n",
       "2099046                                                     None   \n",
       "2099053                                                      NaN   \n",
       "2099055                                                      NaN   \n",
       "2099058                                                     None   \n",
       "2099083                                                     None   \n",
       "2099093                                                     None   \n",
       "2099097                                                     None   \n",
       "2099102                                                     None   \n",
       "2099104                                                     None   \n",
       "2099153                                                     None   \n",
       "2099175                                                     None   \n",
       "2099186                                                     None   \n",
       "2102218                                                      NaN   \n",
       "2102224                                                      NaN   \n",
       "2102229                                                     None   \n",
       "2102234                                                     None   \n",
       "2102251                                                     None   \n",
       "2102254         41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...   \n",
       "2102269                                                     None   \n",
       "2102275                                                     None   \n",
       "2102294                                                      NaN   \n",
       "\n",
       "                                                              7   \\\n",
       "inspection_id                                                      \n",
       "44249                                                       None   \n",
       "44259                                                       None   \n",
       "44262                                                       None   \n",
       "48225                                                       None   \n",
       "52237                                                       None   \n",
       "52241                                                       None   \n",
       "52245                                                       None   \n",
       "52246                                                       None   \n",
       "52247                                                       None   \n",
       "52250                                                       None   \n",
       "52262                                                       None   \n",
       "52267                                                        NaN   \n",
       "52270                                                       None   \n",
       "52272                                                       None   \n",
       "54214           36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...   \n",
       "54217                                                       None   \n",
       "54222                                                       None   \n",
       "54228                                                       None   \n",
       "54232                                                       None   \n",
       "54239                                                       None   \n",
       "54242                                                       None   \n",
       "54248                                                       None   \n",
       "54251                                                       None   \n",
       "54256                                                       None   \n",
       "58227                                                       None   \n",
       "58239                                                       None   \n",
       "58243                                                       None   \n",
       "58251                                                       None   \n",
       "58254                                                        NaN   \n",
       "58267           40. REFRIGERATION AND METAL STEM THERMOMETERS...   \n",
       "...                                                          ...   \n",
       "2098955                                                     None   \n",
       "2098962                                                     None   \n",
       "2098965         11. ADEQUATE NUMBER, CONVENIENT, ACCESSIBLE, ...   \n",
       "2098971                                                     None   \n",
       "2098993                                                     None   \n",
       "2099002                                                      NaN   \n",
       "2099019                                                      NaN   \n",
       "2099030                                                     None   \n",
       "2099031                                                      NaN   \n",
       "2099046                                                     None   \n",
       "2099053                                                      NaN   \n",
       "2099055                                                      NaN   \n",
       "2099058                                                     None   \n",
       "2099083                                                     None   \n",
       "2099093                                                     None   \n",
       "2099097                                                     None   \n",
       "2099102                                                     None   \n",
       "2099104                                                     None   \n",
       "2099153                                                     None   \n",
       "2099175                                                     None   \n",
       "2099186                                                     None   \n",
       "2102218                                                      NaN   \n",
       "2102224                                                      NaN   \n",
       "2102229                                                     None   \n",
       "2102234                                                     None   \n",
       "2102251                                                     None   \n",
       "2102254                                                     None   \n",
       "2102269                                                     None   \n",
       "2102275                                                     None   \n",
       "2102294                                                      NaN   \n",
       "\n",
       "                                                              8     9     10  \\\n",
       "inspection_id                                                                  \n",
       "44249                                                       None  None  None   \n",
       "44259                                                       None  None  None   \n",
       "44262                                                       None  None  None   \n",
       "48225                                                       None  None  None   \n",
       "52237                                                       None  None  None   \n",
       "52241                                                       None  None  None   \n",
       "52245                                                       None  None  None   \n",
       "52246                                                       None  None  None   \n",
       "52247                                                       None  None  None   \n",
       "52250                                                       None  None  None   \n",
       "52262                                                       None  None  None   \n",
       "52267                                                        NaN   NaN   NaN   \n",
       "52270                                                       None  None  None   \n",
       "52272                                                       None  None  None   \n",
       "54214           40. REFRIGERATION AND METAL STEM THERMOMETERS...  None  None   \n",
       "54217                                                       None  None  None   \n",
       "54222                                                       None  None  None   \n",
       "54228                                                       None  None  None   \n",
       "54232                                                       None  None  None   \n",
       "54239                                                       None  None  None   \n",
       "54242                                                       None  None  None   \n",
       "54248                                                       None  None  None   \n",
       "54251                                                       None  None  None   \n",
       "54256                                                       None  None  None   \n",
       "58227                                                       None  None  None   \n",
       "58239                                                       None  None  None   \n",
       "58243                                                       None  None  None   \n",
       "58251                                                       None  None  None   \n",
       "58254                                                        NaN   NaN   NaN   \n",
       "58267           41. PREMISES MAINTAINED FREE OF LITTER, UNNEC...  None  None   \n",
       "...                                                          ...   ...   ...   \n",
       "2098955                                                     None  None  None   \n",
       "2098962                                                     None  None  None   \n",
       "2098965                                                     None  None  None   \n",
       "2098971                                                     None  None  None   \n",
       "2098993                                                     None  None  None   \n",
       "2099002                                                      NaN   NaN   NaN   \n",
       "2099019                                                      NaN   NaN   NaN   \n",
       "2099030                                                     None  None  None   \n",
       "2099031                                                      NaN   NaN   NaN   \n",
       "2099046                                                     None  None  None   \n",
       "2099053                                                      NaN   NaN   NaN   \n",
       "2099055                                                      NaN   NaN   NaN   \n",
       "2099058                                                     None  None  None   \n",
       "2099083                                                     None  None  None   \n",
       "2099093                                                     None  None  None   \n",
       "2099097                                                     None  None  None   \n",
       "2099102                                                     None  None  None   \n",
       "2099104                                                     None  None  None   \n",
       "2099153                                                     None  None  None   \n",
       "2099175                                                     None  None  None   \n",
       "2099186                                                     None  None  None   \n",
       "2102218                                                      NaN   NaN   NaN   \n",
       "2102224                                                      NaN   NaN   NaN   \n",
       "2102229                                                     None  None  None   \n",
       "2102234                                                     None  None  None   \n",
       "2102251                                                     None  None  None   \n",
       "2102254                                                     None  None  None   \n",
       "2102269                                                     None  None  None   \n",
       "2102275                                                     None  None  None   \n",
       "2102294                                                      NaN   NaN   NaN   \n",
       "\n",
       "                 11    12    13    14    15    16    17    18  \n",
       "inspection_id                                                  \n",
       "44249          None  None  None  None  None  None  None  None  \n",
       "44259          None  None  None  None  None  None  None  None  \n",
       "44262          None  None  None  None  None  None  None  None  \n",
       "48225          None  None  None  None  None  None  None  None  \n",
       "52237          None  None  None  None  None  None  None  None  \n",
       "52241          None  None  None  None  None  None  None  None  \n",
       "52245          None  None  None  None  None  None  None  None  \n",
       "52246          None  None  None  None  None  None  None  None  \n",
       "52247          None  None  None  None  None  None  None  None  \n",
       "52250          None  None  None  None  None  None  None  None  \n",
       "52262          None  None  None  None  None  None  None  None  \n",
       "52267           NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "52270          None  None  None  None  None  None  None  None  \n",
       "52272          None  None  None  None  None  None  None  None  \n",
       "54214          None  None  None  None  None  None  None  None  \n",
       "54217          None  None  None  None  None  None  None  None  \n",
       "54222          None  None  None  None  None  None  None  None  \n",
       "54228          None  None  None  None  None  None  None  None  \n",
       "54232          None  None  None  None  None  None  None  None  \n",
       "54239          None  None  None  None  None  None  None  None  \n",
       "54242          None  None  None  None  None  None  None  None  \n",
       "54248          None  None  None  None  None  None  None  None  \n",
       "54251          None  None  None  None  None  None  None  None  \n",
       "54256          None  None  None  None  None  None  None  None  \n",
       "58227          None  None  None  None  None  None  None  None  \n",
       "58239          None  None  None  None  None  None  None  None  \n",
       "58243          None  None  None  None  None  None  None  None  \n",
       "58251          None  None  None  None  None  None  None  None  \n",
       "58254           NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "58267          None  None  None  None  None  None  None  None  \n",
       "...             ...   ...   ...   ...   ...   ...   ...   ...  \n",
       "2098955        None  None  None  None  None  None  None  None  \n",
       "2098962        None  None  None  None  None  None  None  None  \n",
       "2098965        None  None  None  None  None  None  None  None  \n",
       "2098971        None  None  None  None  None  None  None  None  \n",
       "2098993        None  None  None  None  None  None  None  None  \n",
       "2099002         NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "2099019         NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "2099030        None  None  None  None  None  None  None  None  \n",
       "2099031         NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "2099046        None  None  None  None  None  None  None  None  \n",
       "2099053         NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "2099055         NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "2099058        None  None  None  None  None  None  None  None  \n",
       "2099083        None  None  None  None  None  None  None  None  \n",
       "2099093        None  None  None  None  None  None  None  None  \n",
       "2099097        None  None  None  None  None  None  None  None  \n",
       "2099102        None  None  None  None  None  None  None  None  \n",
       "2099104        None  None  None  None  None  None  None  None  \n",
       "2099153        None  None  None  None  None  None  None  None  \n",
       "2099175        None  None  None  None  None  None  None  None  \n",
       "2099186        None  None  None  None  None  None  None  None  \n",
       "2102218         NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "2102224         NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "2102229        None  None  None  None  None  None  None  None  \n",
       "2102234        None  None  None  None  None  None  None  None  \n",
       "2102251        None  None  None  None  None  None  None  None  \n",
       "2102254        None  None  None  None  None  None  None  None  \n",
       "2102269        None  None  None  None  None  None  None  None  \n",
       "2102275        None  None  None  None  None  None  None  None  \n",
       "2102294         NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN  \n",
       "\n",
       "[25000 rows x 19 columns]"
      ]
     },
     "execution_count": 309,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "violations.sort_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 310,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "inspection_id   \n",
       "1965287        0    35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTR...\n",
       "               1     33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...\n",
       "               2     34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...\n",
       "               3     36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...\n",
       "               4     22. DISH MACHINES: PROVIDED WITH ACCURATE THE...\n",
       "               5     40. REFRIGERATION AND METAL STEM THERMOMETERS...\n",
       "1329698        0    33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSI...\n",
       "               1     34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...\n",
       "               2     36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...\n",
       "               3     38. VENTILATION: ROOMS AND EQUIPMENT VENTED A...\n",
       "470787         0    6. HANDS WASHED AND CLEANED, GOOD HYGIENIC PRA...\n",
       "               1     11. ADEQUATE NUMBER, CONVENIENT, ACCESSIBLE, ...\n",
       "               2     19. OUTSIDE GARBAGE WASTE GREASE AND STORAGE ...\n",
       "               3     36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...\n",
       "               4     3. POTENTIALLY HAZARDOUS FOOD MEETS TEMPERATU...\n",
       "dtype: object"
      ]
     },
     "execution_count": 310,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "violations = violations.stack().dropna()\n",
    "violations.head(15)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 311,
   "metadata": {},
   "outputs": [],
   "source": [
    "violations.reset_index(level=1, drop=True, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 312,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "inspection_id\n",
       "1965287    35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTR...\n",
       "1965287     33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENS...\n",
       "1965287     34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GO...\n",
       "1965287     36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES O...\n",
       "1965287     22. DISH MACHINES: PROVIDED WITH ACCURATE THE...\n",
       "dtype: object"
      ]
     },
     "execution_count": 312,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "violations.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 313,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "inspection_id\n",
       "1965287    35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTR...\n",
       "1965287    33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSI...\n",
       "1965287    34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GOO...\n",
       "1965287    36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES OF...\n",
       "1965287    22. DISH MACHINES: PROVIDED WITH ACCURATE THER...\n",
       "dtype: object"
      ]
     },
     "execution_count": 313,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "violations = violations.str.strip().head()\n",
    "violations.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 341,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Pass                    198\n",
       "Fail                     61\n",
       "Pass w/ Conditions       33\n",
       "Out of Business           0\n",
       "Not Ready                 0\n",
       "No Entry                  0\n",
       "Business Not Located      0\n",
       "Name: results, dtype: int64"
      ]
     },
     "execution_count": 341,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dta[dta.dba_name.str.contains('MCD')].results.value_counts() #note all McDonalds grouped under MCD"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 314,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Pass                    15915\n",
       "Fail                     5760\n",
       "Pass w/ Conditions       2931\n",
       "Out of Business           246\n",
       "No Entry                  107\n",
       "Not Ready                  40\n",
       "Business Not Located        1\n",
       "Name: results, dtype: int64"
      ]
     },
     "execution_count": 314,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dta.results.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 315,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pandas.core.groupby.groupby.DataFrameGroupBy object at 0x1284cc160>"
      ]
     },
     "execution_count": 315,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "g = dta.groupby(dta.results)\n",
    "g"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<font color=\"blue\">**You can access the variables on this object, the same as a DataFrame, and any code called will execute within the groups.**</font> "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 316,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "results\n",
       "Business Not Located        1\n",
       "Fail                     5760\n",
       "No Entry                  107\n",
       "Not Ready                  40\n",
       "Out of Business           246\n",
       "Pass                    15915\n",
       "Pass w/ Conditions       2931\n",
       "dtype: int64"
      ]
     },
     "execution_count": 316,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "g.size()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 317,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "results               dba_name                              \n",
       "Business Not Located  CITGO SUPER WASH & GAS                     1\n",
       "Fail                  SUBWAY                                    42\n",
       "                      DUNKIN DONUTS                             33\n",
       "                      MCDONALD'S                                22\n",
       "                      HAROLD'S CHICKEN SHACK                    14\n",
       "                      CHIPOTLE MEXICAN GRILL                    11\n",
       "                      DUNKIN DONUTS / BASKIN ROBBINS            10\n",
       "                      MCDONALDS                                 10\n",
       "                      7-ELEVEN                                   9\n",
       "                      POTBELLY SANDWICH WORKS                    9\n",
       "                      POTBELLY SANDWICH WORKS LLC                9\n",
       "                      JIMMY JOHNS                                8\n",
       "                      LAS ISLAS MARIAS                           8\n",
       "                      KFC                                        7\n",
       "                      PIZZA HUT                                  7\n",
       "                      BAR LOUIE                                  6\n",
       "                      CORNER BAKERY CAFE                         6\n",
       "                      DUNKIN DONUTS/BASKIN ROBBINS               6\n",
       "                      EL TACONAZO RESTAURANT                     6\n",
       "                      FRESHII                                    6\n",
       "                      HALSTED STREET DELI                        6\n",
       "                      OLD COUNTRY BUFFET                         6\n",
       "                      SHARKS FISH & CHICKEN                      6\n",
       "                      AMAZING GRACE DAYCARE CENTER               5\n",
       "                      ANTON DVORAK ELEMENTARY                    5\n",
       "                      CHURCH'S CHICKEN # 992                     5\n",
       "                      CITGO                                      5\n",
       "                      Congress Pizza                             5\n",
       "                      DOMINO'S PIZZA                             5\n",
       "                      EL CHILE RESTAURANT & PANCAKE HOUSE        5\n",
       "                                                                ..\n",
       "Pass w/ Conditions    WOW BAO                                    1\n",
       "                      WRIGLEVILLE DBA DUNKIN DONUTS              1\n",
       "                      WRIGLEY ROOFTOPS III                       1\n",
       "                      Walgreens # 05192                          1\n",
       "                      Walmart Neighborhood Market #5646          1\n",
       "                      WingStop                                   1\n",
       "                      XANDO COFFEE & BAR / COSI SANDWICH BAR     1\n",
       "                      XOCO                                       1\n",
       "                      XSPORT FITNESS                             1\n",
       "                      YARD HOUSE                                 1\n",
       "                      YOGURTLAND                                 1\n",
       "                      YOLANDA'S RESTAURANT INC                   1\n",
       "                      YOLK CAFE                                  1\n",
       "                      YON'S DELI                                 1\n",
       "                      YOSHI'S CAFE                               1\n",
       "                      YOUNG'S RESTAURANT                         1\n",
       "                      YOUTH CONNECTION                           1\n",
       "                      YUCA  CAFE                                 1\n",
       "                      Yuki Hana                                  1\n",
       "                      Z-A PIZZA                                  1\n",
       "                      ZACATACOS                                  1\n",
       "                      ZACATACOS, II. INC                         1\n",
       "                      ZAKI CHICAGO STYLE GRILLE                  1\n",
       "                      ZALESKI & HORVATH MARKETCAFE               1\n",
       "                      ZEENAT  BANQUETS  INC                      1\n",
       "                      ZELLA                                      1\n",
       "                      ZOOM PIZZA FACTORY, INC.                   1\n",
       "                      ZUZU WRAPS INC                             1\n",
       "                      Zaytune Mediterranean Grill                1\n",
       "                      subway restaurant 1                        1\n",
       "Name: dba_name, Length: 16451, dtype: int64"
      ]
     },
     "execution_count": 317,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result = g.dba_name.value_counts()\n",
    "result\n",
    "#series with a multi-index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 318,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pandas.core.series.Series"
      ]
     },
     "execution_count": 318,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "FrozenList(['results', 'dba_name'])"
      ]
     },
     "execution_count": 318,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(result)\n",
    "result.index.names #what are the index names..."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 319,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "dba_name\n",
      "SUBWAY                            42\n",
      "DUNKIN DONUTS                     33\n",
      "MCDONALD'S                        22\n",
      "HAROLD'S CHICKEN SHACK            14\n",
      "CHIPOTLE MEXICAN GRILL            11\n",
      "DUNKIN DONUTS / BASKIN ROBBINS    10\n",
      "MCDONALDS                         10\n",
      "                                  ..\n",
      "MERCY'S TOBACCO                    1\n",
      "MERCY HOME FOR BOYS AND GIRLS      1\n",
      "MERCER 113                         1\n",
      "MELLOS PEANUT COMPANY              1\n",
      "MEHRAB SUPER MARKET                1\n",
      "MEERATH KABAB                      1\n",
      "HALSTED FOOD                       1\n",
      "Name: dba_name, Length: 4422, dtype: int64\n"
     ]
    }
   ],
   "source": [
    "with pd.option_context('max.rows', 15):\n",
    "    print(result[\"Fail\"].sort_values(ascending=False))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 320,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "dba_name\n",
      "SUBWAY                                     219\n",
      "DUNKIN DONUTS                              118\n",
      "MCDONALD'S                                  61\n",
      "7-ELEVEN                                    38\n",
      "MCDONALDS                                   35\n",
      "AU BON PAIN                                 29\n",
      "POTBELLY SANDWICH WORKS LLC                 29\n",
      "                                          ... \n",
      "KATAKANA & FIESTA & KOKO GRILL               1\n",
      "KASEY'S TAVERN                               1\n",
      "KARYN'S ON GREEN                             1\n",
      "KARLA'S KITCHEN INC.                         1\n",
      "KARLA'S KITCHEN                              1\n",
      "KARE INC                                     1\n",
      "CITY GARDEN EARLY CHILDHOOD CENTER,INC.      1\n",
      "Name: dba_name, Length: 9325, dtype: int64\n"
     ]
    }
   ],
   "source": [
    "with pd.option_context('max.rows', 15):\n",
    "    print(result[\"Pass\"].sort_values(ascending=False))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 266,
   "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>address</th>\n",
       "      <th>aka_name</th>\n",
       "      <th>city</th>\n",
       "      <th>dba_name</th>\n",
       "      <th>facility_type</th>\n",
       "      <th>inspection_date</th>\n",
       "      <th>inspection_type</th>\n",
       "      <th>latitude</th>\n",
       "      <th>license_</th>\n",
       "      <th>location</th>\n",
       "      <th>longitude</th>\n",
       "      <th>results</th>\n",
       "      <th>risk</th>\n",
       "      <th>state</th>\n",
       "      <th>violations</th>\n",
       "      <th>zip</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>inspection_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1965287</th>\n",
       "      <td>5255 W MADISON ST</td>\n",
       "      <td>RED SNAPPER FISH CHICKEN &amp; PIZZA</td>\n",
       "      <td>CHICAGO</td>\n",
       "      <td>RED SNAPPER FISH CHICKEN &amp; PIZZA</td>\n",
       "      <td>Restaurant</td>\n",
       "      <td>2016-09-26</td>\n",
       "      <td>Canvass</td>\n",
       "      <td>41.880237</td>\n",
       "      <td>1991820.0</td>\n",
       "      <td>{'type': 'Point', 'coordinates': [-87.75722039...</td>\n",
       "      <td>-87.757220</td>\n",
       "      <td>Pass w/ Conditions</td>\n",
       "      <td>Risk 1 (High)</td>\n",
       "      <td>IL</td>\n",
       "      <td>35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTR...</td>\n",
       "      <td>60644.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1329698</th>\n",
       "      <td>5958 W DIVERSEY AVE</td>\n",
       "      <td>TAQUERIA MORELOS</td>\n",
       "      <td>CHICAGO</td>\n",
       "      <td>TAQUERIA MORELOS</td>\n",
       "      <td>Restaurant</td>\n",
       "      <td>2014-02-06</td>\n",
       "      <td>Canvass</td>\n",
       "      <td>41.931250</td>\n",
       "      <td>2099479.0</td>\n",
       "      <td>{'type': 'Point', 'coordinates': [-87.77590699...</td>\n",
       "      <td>-87.775907</td>\n",
       "      <td>Pass</td>\n",
       "      <td>Risk 1 (High)</td>\n",
       "      <td>IL</td>\n",
       "      <td>33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSI...</td>\n",
       "      <td>60639.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>470787</th>\n",
       "      <td>5400-5402 N CLARK ST</td>\n",
       "      <td>HAMBURGER MARY'S/MARY'S REC ROOM</td>\n",
       "      <td>CHICAGO</td>\n",
       "      <td>HAMBURGER MARY'S CHICAGO/MARY'S REC ROOM</td>\n",
       "      <td>Restaurant</td>\n",
       "      <td>2010-12-03</td>\n",
       "      <td>SFP</td>\n",
       "      <td>41.979884</td>\n",
       "      <td>1933748.0</td>\n",
       "      <td>{'type': 'Point', 'coordinates': [-87.66842948...</td>\n",
       "      <td>-87.668429</td>\n",
       "      <td>Fail</td>\n",
       "      <td>Risk 1 (High)</td>\n",
       "      <td>IL</td>\n",
       "      <td>6. HANDS WASHED AND CLEANED, GOOD HYGIENIC PRA...</td>\n",
       "      <td>60640.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                             address                          aka_name  \\\n",
       "inspection_id                                                            \n",
       "1965287           5255 W MADISON ST   RED SNAPPER FISH CHICKEN & PIZZA   \n",
       "1329698         5958 W DIVERSEY AVE                   TAQUERIA MORELOS   \n",
       "470787         5400-5402 N CLARK ST   HAMBURGER MARY'S/MARY'S REC ROOM   \n",
       "\n",
       "                  city                                  dba_name  \\\n",
       "inspection_id                                                      \n",
       "1965287        CHICAGO          RED SNAPPER FISH CHICKEN & PIZZA   \n",
       "1329698        CHICAGO                          TAQUERIA MORELOS   \n",
       "470787         CHICAGO  HAMBURGER MARY'S CHICAGO/MARY'S REC ROOM   \n",
       "\n",
       "              facility_type inspection_date inspection_type   latitude  \\\n",
       "inspection_id                                                            \n",
       "1965287          Restaurant      2016-09-26         Canvass  41.880237   \n",
       "1329698          Restaurant      2014-02-06         Canvass  41.931250   \n",
       "470787           Restaurant      2010-12-03             SFP  41.979884   \n",
       "\n",
       "                license_                                           location  \\\n",
       "inspection_id                                                                 \n",
       "1965287        1991820.0  {'type': 'Point', 'coordinates': [-87.75722039...   \n",
       "1329698        2099479.0  {'type': 'Point', 'coordinates': [-87.77590699...   \n",
       "470787         1933748.0  {'type': 'Point', 'coordinates': [-87.66842948...   \n",
       "\n",
       "               longitude             results           risk state  \\\n",
       "inspection_id                                                       \n",
       "1965287       -87.757220  Pass w/ Conditions  Risk 1 (High)    IL   \n",
       "1329698       -87.775907                Pass  Risk 1 (High)    IL   \n",
       "470787        -87.668429                Fail  Risk 1 (High)    IL   \n",
       "\n",
       "                                                      violations      zip  \n",
       "inspection_id                                                              \n",
       "1965287        35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTR...  60644.0  \n",
       "1329698        33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSI...  60639.0  \n",
       "470787         6. HANDS WASHED AND CLEANED, GOOD HYGIENIC PRA...  60640.0  "
      ]
     },
     "execution_count": 266,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dta.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 286,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "inspection_id\n",
       "176504    MCDonalds\n",
       "Name: dba_name, dtype: object"
      ]
     },
     "execution_count": 286,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(dta[dta.dba_name.str.startswith('mcd')]).dba_name.str.replace('mcd','MCD')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 339,
   "metadata": {},
   "outputs": [],
   "source": [
    "dta.dba_name = dta.dba_name.str.replace('Mc D','MCD') #STEP 2 replace problem names with proper name \"MCD\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 330,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "address            0\n",
       "aka_name           0\n",
       "city               0\n",
       "dba_name           0\n",
       "facility_type      0\n",
       "inspection_date    0\n",
       "inspection_type    0\n",
       "latitude           0\n",
       "license_           0\n",
       "location           0\n",
       "longitude          0\n",
       "results            0\n",
       "risk               0\n",
       "state              0\n",
       "violations         0\n",
       "zip                0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 330,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dta[dta.dba_name.str.startswith('McD')].count()      #STEP 1 Find the problem childern (.contains is better)  \n",
    "                                                     #STEP 3 recheck \n",
    "    #mcd, McD, MC D"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 328,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "address            287\n",
       "aka_name           286\n",
       "city               287\n",
       "dba_name           287\n",
       "facility_type      284\n",
       "inspection_date    287\n",
       "inspection_type    287\n",
       "latitude           287\n",
       "license_           287\n",
       "location           287\n",
       "longitude          287\n",
       "results            287\n",
       "risk               287\n",
       "state              287\n",
       "violations         267\n",
       "zip                287\n",
       "dtype: int64"
      ]
     },
     "execution_count": 328,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dta[dta.dba_name.str.startswith('MCD')].count() #NOTE the difference between startswith and contains"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 340,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "address            292\n",
       "aka_name           291\n",
       "city               292\n",
       "dba_name           292\n",
       "facility_type      289\n",
       "inspection_date    292\n",
       "inspection_type    292\n",
       "latitude           292\n",
       "license_           292\n",
       "location           292\n",
       "longitude          292\n",
       "results            292\n",
       "risk               292\n",
       "state              292\n",
       "violations         272\n",
       "zip                292\n",
       "dtype: int64"
      ]
     },
     "execution_count": 340,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dta[dta.dba_name.str.contains('MCD')].count()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### This is the end of this section - new topic below"
   ]
  },
  {
   "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>field_A</th>\n",
       "      <th>field_B</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>54</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>65</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>98</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>55</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>93</td>\n",
       "      <td>59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>72</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>72</td>\n",
       "      <td>92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>3</td>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>84</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   field_A  field_B\n",
       "0       54       47\n",
       "1       65        0\n",
       "2       98       15\n",
       "3        3       23\n",
       "4       55       21\n",
       "5       93       59\n",
       "6       72       42\n",
       "7       72       92\n",
       "8        3       79\n",
       "9       84       78"
      ]
     },
     "execution_count": 118,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# ASIDE on Quantiles\n",
    "import pandas as pd\n",
    "import random\n",
    "\n",
    "A = [ random.randint(0,100) for i in range(10) ]\n",
    "B = [ random.randint(0,100) for i in range(10) ]\n",
    "\n",
    "df = pd.DataFrame({ 'field_A': A, 'field_B': B })\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 120,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "field_A    59.9\n",
       "field_B    45.6\n",
       "dtype: float64"
      ]
     },
     "execution_count": 120,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "field_A    68.5\n",
       "field_B    44.5\n",
       "dtype: float64"
      ]
     },
     "execution_count": 120,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.mean()\n",
    "df.median()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 121,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3.0"
      ]
     },
     "execution_count": 121,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "68.5"
      ]
     },
     "execution_count": 121,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "93.5"
      ]
     },
     "execution_count": 121,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.field_A.quantile(0.1)\n",
    "df.field_A.quantile(0.5) # this is the same as median\n",
    "df.field_A.quantile(0.9)  # 90% of the numbers are below this value"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "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.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}