p6.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import folium  #  map visuals\n",
    "import pandas as pd  #  data manipulation\n",
    "import requests\n",
    "from time import sleep"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "No columns\n"
     ]
    },
    {
     "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>ESTABLISHMENT NAME</th>\n",
       "      <th>ADDRESS</th>\n",
       "      <th>ALDERMANIC DISTRICT</th>\n",
       "      <th>INSPECTION DATE</th>\n",
       "      <th>ESTABLISHMENT GRADE</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NOMIES ON LISBON</td>\n",
       "      <td>7605 W LISBON AV</td>\n",
       "      <td>5.0</td>\n",
       "      <td>12/28/2018</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>TENLEY AUTO CENTER</td>\n",
       "      <td>9208 W CAPITOL DR</td>\n",
       "      <td>5.0</td>\n",
       "      <td>12/28/2018</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>KAM'S THISTLE AND SHAMROCK</td>\n",
       "      <td>3430 N 84TH ST</td>\n",
       "      <td>5.0</td>\n",
       "      <td>12/28/2018</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BC SUPERMARKET</td>\n",
       "      <td>4225 W NORTH AVE</td>\n",
       "      <td>15.0</td>\n",
       "      <td>12/28/2018</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>TUSK</td>\n",
       "      <td>5513 W NORTH AVE</td>\n",
       "      <td>10.0</td>\n",
       "      <td>12/28/2018</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>THE HARP IRISH PUB</td>\n",
       "      <td>113 E JUNEAU AVE</td>\n",
       "      <td>4.0</td>\n",
       "      <td>12/28/2018</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>AMERICAN SERB HALL</td>\n",
       "      <td>5101 W OKLAHOMA AV</td>\n",
       "      <td>11.0</td>\n",
       "      <td>12/28/2018</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>BALL N BISCUIT CATERING</td>\n",
       "      <td>531 E KEEFE AV</td>\n",
       "      <td>6.0</td>\n",
       "      <td>12/27/2018</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>FAMILY DOLLAR #26182</td>\n",
       "      <td>930 N 27TH ST</td>\n",
       "      <td>4.0</td>\n",
       "      <td>12/27/2018</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>DOWNTOWN KITCHEN</td>\n",
       "      <td>777 E WISCONSIN AV</td>\n",
       "      <td>4.0</td>\n",
       "      <td>12/27/2018</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>HISSHO SUSHI</td>\n",
       "      <td>777 W WISCONSIN AV</td>\n",
       "      <td>4.0</td>\n",
       "      <td>12/27/2018</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>TSUNAMI</td>\n",
       "      <td>2222 S 13TH ST</td>\n",
       "      <td>12.0</td>\n",
       "      <td>12/27/2018</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>BIRCH + BUTCHER</td>\n",
       "      <td>459 E PLEASANT ST</td>\n",
       "      <td>3.0</td>\n",
       "      <td>12/26/2018</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>JC KING TORTAS #0803</td>\n",
       "      <td>3128 S 13TH ST</td>\n",
       "      <td>14.0</td>\n",
       "      <td>12/26/2018</td>\n",
       "      <td>MA</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>FREEZ FOOD MART</td>\n",
       "      <td>2526 W HOPKINS ST</td>\n",
       "      <td>6.0</td>\n",
       "      <td>12/26/2018</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>MARATHON MINI MART</td>\n",
       "      <td>4312 W FOND DU LAC AV</td>\n",
       "      <td>7.0</td>\n",
       "      <td>12/26/2018</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>SHIZEN</td>\n",
       "      <td>100 E CAPITOL DR</td>\n",
       "      <td>6.0</td>\n",
       "      <td>12/21/2018</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>BUSINESS OFFICE CAFETERIA</td>\n",
       "      <td>3301 W FOREST HOME AV</td>\n",
       "      <td>8.0</td>\n",
       "      <td>12/21/2018</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>DISTEFANO'S PIZZA PALACE</td>\n",
       "      <td>4630 W FOREST HOME AV</td>\n",
       "      <td>11.0</td>\n",
       "      <td>12/20/2018</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>CHINA HUT</td>\n",
       "      <td>5114 W HOWARD AV</td>\n",
       "      <td>11.0</td>\n",
       "      <td>12/20/2018</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>BRAISE RESTAURANT</td>\n",
       "      <td>1101 S 2ND ST</td>\n",
       "      <td>12.0</td>\n",
       "      <td>12/20/2018</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>LAYTON HEIGHTS PUB &amp; GRILL</td>\n",
       "      <td>4553 S 13TH ST</td>\n",
       "      <td>13.0</td>\n",
       "      <td>12/20/2018</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>PASTELERIA AZTECA</td>\n",
       "      <td>123 W OKLAHOMA AV</td>\n",
       "      <td>14.0</td>\n",
       "      <td>12/20/2018</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>ALEM ETHIOPIAN VILLAGE</td>\n",
       "      <td>307 E WISCONSIN AV</td>\n",
       "      <td>4.0</td>\n",
       "      <td>12/20/2018</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>SHAWARMA HOUSE</td>\n",
       "      <td>2921 N OAKLAND AV</td>\n",
       "      <td>3.0</td>\n",
       "      <td>12/20/2018</td>\n",
       "      <td>B</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>COFFEE SHOP</td>\n",
       "      <td>2323 N LAKE DR</td>\n",
       "      <td>3.0</td>\n",
       "      <td>12/19/2018</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>BLACK SHEEP #3605</td>\n",
       "      <td>216 S 2ND ST</td>\n",
       "      <td>12.0</td>\n",
       "      <td>12/19/2018</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>ARCOIRIS BAKERY</td>\n",
       "      <td>1414 S 6TH ST</td>\n",
       "      <td>12.0</td>\n",
       "      <td>12/19/2018</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>KANPAI 2</td>\n",
       "      <td>2150 N PROSPECT AV</td>\n",
       "      <td>3.0</td>\n",
       "      <td>12/19/2018</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>MEAT ON THE STREET</td>\n",
       "      <td>1125 N 9TH ST</td>\n",
       "      <td>4.0</td>\n",
       "      <td>12/19/2018</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1118</th>\n",
       "      <td>OAK BARREL</td>\n",
       "      <td>1033 N OLD WORLD THIRD ST #100</td>\n",
       "      <td>4.0</td>\n",
       "      <td>01/04/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1119</th>\n",
       "      <td>SCHLITZ PARK CAFE</td>\n",
       "      <td>1555 N RIVERCENTER DR</td>\n",
       "      <td>4.0</td>\n",
       "      <td>01/04/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1120</th>\n",
       "      <td>HILTON MILWAUKEE CITY CENTER-MILLER TIME PUB</td>\n",
       "      <td>509 W WISCONSIN AV</td>\n",
       "      <td>4.0</td>\n",
       "      <td>01/03/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1121</th>\n",
       "      <td>HILTON MILWAUKEE CITY CENTER- CAFE &amp; MILWAUKEE...</td>\n",
       "      <td>509 W WISCONSIN AV</td>\n",
       "      <td>4.0</td>\n",
       "      <td>01/03/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1122</th>\n",
       "      <td>JORDAN STORE</td>\n",
       "      <td>5611 W LISBON AV</td>\n",
       "      <td>10.0</td>\n",
       "      <td>01/03/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1123</th>\n",
       "      <td>HASHAM PETROLEUM LLC</td>\n",
       "      <td>9130 W HAMPTON AV</td>\n",
       "      <td>5.0</td>\n",
       "      <td>01/03/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1124</th>\n",
       "      <td>WINGS CHINESE CARRRYOUT</td>\n",
       "      <td>8408 W LISBON AV</td>\n",
       "      <td>5.0</td>\n",
       "      <td>01/03/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1125</th>\n",
       "      <td>TAVO'S MEXICAN RESTAURANT</td>\n",
       "      <td>5814 W BLUE MOUND RD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/03/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1126</th>\n",
       "      <td>JUST ART'S SALOON</td>\n",
       "      <td>181 S 2ND ST</td>\n",
       "      <td>8.0</td>\n",
       "      <td>01/03/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1127</th>\n",
       "      <td>BACCHUS-A BARTOLOTTA RESTAURANT</td>\n",
       "      <td>925 E WELLS ST</td>\n",
       "      <td>4.0</td>\n",
       "      <td>01/03/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1128</th>\n",
       "      <td>OUTPOST</td>\n",
       "      <td>100 E CAPITOL DR</td>\n",
       "      <td>6.0</td>\n",
       "      <td>01/03/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1129</th>\n",
       "      <td>GENE SUPPER CLUB</td>\n",
       "      <td>4323 N 60TH ST</td>\n",
       "      <td>9.0</td>\n",
       "      <td>01/03/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1130</th>\n",
       "      <td>MCDONALDS</td>\n",
       "      <td>2700 W CAPITOL DR</td>\n",
       "      <td>1.0</td>\n",
       "      <td>01/03/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1131</th>\n",
       "      <td>MAKI YAKI</td>\n",
       "      <td>1616 W WISCONSIN AV</td>\n",
       "      <td>4.0</td>\n",
       "      <td>01/03/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1132</th>\n",
       "      <td>MOREL RESTAURANT</td>\n",
       "      <td>430 S 2ND ST</td>\n",
       "      <td>12.0</td>\n",
       "      <td>01/03/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1133</th>\n",
       "      <td>C. ADAMS BAKERY</td>\n",
       "      <td>400 N WATER ST</td>\n",
       "      <td>4.0</td>\n",
       "      <td>01/03/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1134</th>\n",
       "      <td>BAVETTE</td>\n",
       "      <td>330 E MENOMONEE ST</td>\n",
       "      <td>4.0</td>\n",
       "      <td>01/03/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1135</th>\n",
       "      <td>PIGGLY WIGGLY SUPERMARKET #71</td>\n",
       "      <td>123 W OKLAHOMA AV</td>\n",
       "      <td>14.0</td>\n",
       "      <td>01/03/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1136</th>\n",
       "      <td>CHAR'D</td>\n",
       "      <td>222 E ERIE ST</td>\n",
       "      <td>4.0</td>\n",
       "      <td>01/03/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1137</th>\n",
       "      <td>GLORIOSO'S ITALIAN MARKET</td>\n",
       "      <td>1011 E BRADY ST</td>\n",
       "      <td>3.0</td>\n",
       "      <td>01/03/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1138</th>\n",
       "      <td>2 MESA</td>\n",
       "      <td>4110 W MARTIN DR</td>\n",
       "      <td>10.0</td>\n",
       "      <td>01/03/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1139</th>\n",
       "      <td>BLUE BAT KITCHEN AND TEQUILARIA</td>\n",
       "      <td>249 N WATER ST</td>\n",
       "      <td>4.0</td>\n",
       "      <td>01/03/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1140</th>\n",
       "      <td>HWY 45 MOBIL</td>\n",
       "      <td>5501 N LOVERS LANE RD</td>\n",
       "      <td>5.0</td>\n",
       "      <td>01/03/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1141</th>\n",
       "      <td>HWY 45 HAMPTON BP</td>\n",
       "      <td>11728 W HAMPTON AV</td>\n",
       "      <td>5.0</td>\n",
       "      <td>01/03/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1142</th>\n",
       "      <td>MUNCHIE'S FROZEN CUSTARD</td>\n",
       "      <td>8333 W APPLETON AV</td>\n",
       "      <td>5.0</td>\n",
       "      <td>01/03/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1143</th>\n",
       "      <td>BUFFALO WILD WINGS #407</td>\n",
       "      <td>1123 N WATER ST</td>\n",
       "      <td>4.0</td>\n",
       "      <td>01/03/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1144</th>\n",
       "      <td>ZILLI HOSPITALITY GROUP (MUSEUM CATERING)</td>\n",
       "      <td>800 W WELLS ST</td>\n",
       "      <td>4.0</td>\n",
       "      <td>01/03/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1145</th>\n",
       "      <td>PANDA EXPRESS</td>\n",
       "      <td>275 W WISCONSIN AV</td>\n",
       "      <td>4.0</td>\n",
       "      <td>01/03/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1146</th>\n",
       "      <td>ST. JOSEPH'S EMPLOYEE CAFETERIA</td>\n",
       "      <td>5000 W CHAMBERS ST</td>\n",
       "      <td>7.0</td>\n",
       "      <td>01/02/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1147</th>\n",
       "      <td>NEW CHINA RESTAURANT</td>\n",
       "      <td>6311 W CAPITOL DR</td>\n",
       "      <td>2.0</td>\n",
       "      <td>01/02/2019</td>\n",
       "      <td>A</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1148 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     ESTABLISHMENT NAME  \\\n",
       "0                                      NOMIES ON LISBON   \n",
       "1                                    TENLEY AUTO CENTER   \n",
       "2                            KAM'S THISTLE AND SHAMROCK   \n",
       "3                                        BC SUPERMARKET   \n",
       "4                                                  TUSK   \n",
       "5                                    THE HARP IRISH PUB   \n",
       "6                                    AMERICAN SERB HALL   \n",
       "7                               BALL N BISCUIT CATERING   \n",
       "8                                  FAMILY DOLLAR #26182   \n",
       "9                                      DOWNTOWN KITCHEN   \n",
       "10                                         HISSHO SUSHI   \n",
       "11                                              TSUNAMI   \n",
       "12                                      BIRCH + BUTCHER   \n",
       "13                                 JC KING TORTAS #0803   \n",
       "14                                      FREEZ FOOD MART   \n",
       "15                                   MARATHON MINI MART   \n",
       "16                                               SHIZEN   \n",
       "17                            BUSINESS OFFICE CAFETERIA   \n",
       "18                             DISTEFANO'S PIZZA PALACE   \n",
       "19                                            CHINA HUT   \n",
       "20                                    BRAISE RESTAURANT   \n",
       "21                           LAYTON HEIGHTS PUB & GRILL   \n",
       "22                                    PASTELERIA AZTECA   \n",
       "23                               ALEM ETHIOPIAN VILLAGE   \n",
       "24                                       SHAWARMA HOUSE   \n",
       "25                                          COFFEE SHOP   \n",
       "26                                    BLACK SHEEP #3605   \n",
       "27                                      ARCOIRIS BAKERY   \n",
       "28                                             KANPAI 2   \n",
       "29                                   MEAT ON THE STREET   \n",
       "...                                                 ...   \n",
       "1118                                         OAK BARREL   \n",
       "1119                                  SCHLITZ PARK CAFE   \n",
       "1120       HILTON MILWAUKEE CITY CENTER-MILLER TIME PUB   \n",
       "1121  HILTON MILWAUKEE CITY CENTER- CAFE & MILWAUKEE...   \n",
       "1122                                       JORDAN STORE   \n",
       "1123                               HASHAM PETROLEUM LLC   \n",
       "1124                            WINGS CHINESE CARRRYOUT   \n",
       "1125                          TAVO'S MEXICAN RESTAURANT   \n",
       "1126                                  JUST ART'S SALOON   \n",
       "1127                    BACCHUS-A BARTOLOTTA RESTAURANT   \n",
       "1128                                            OUTPOST   \n",
       "1129                                   GENE SUPPER CLUB   \n",
       "1130                                          MCDONALDS   \n",
       "1131                                          MAKI YAKI   \n",
       "1132                                   MOREL RESTAURANT   \n",
       "1133                                    C. ADAMS BAKERY   \n",
       "1134                                            BAVETTE   \n",
       "1135                      PIGGLY WIGGLY SUPERMARKET #71   \n",
       "1136                                             CHAR'D   \n",
       "1137                          GLORIOSO'S ITALIAN MARKET   \n",
       "1138                                             2 MESA   \n",
       "1139                    BLUE BAT KITCHEN AND TEQUILARIA   \n",
       "1140                                       HWY 45 MOBIL   \n",
       "1141                                  HWY 45 HAMPTON BP   \n",
       "1142                           MUNCHIE'S FROZEN CUSTARD   \n",
       "1143                            BUFFALO WILD WINGS #407   \n",
       "1144          ZILLI HOSPITALITY GROUP (MUSEUM CATERING)   \n",
       "1145                                      PANDA EXPRESS   \n",
       "1146                    ST. JOSEPH'S EMPLOYEE CAFETERIA   \n",
       "1147                               NEW CHINA RESTAURANT   \n",
       "\n",
       "                             ADDRESS  ALDERMANIC DISTRICT INSPECTION DATE  \\\n",
       "0                   7605 W LISBON AV                  5.0      12/28/2018   \n",
       "1                  9208 W CAPITOL DR                  5.0      12/28/2018   \n",
       "2                     3430 N 84TH ST                  5.0      12/28/2018   \n",
       "3                   4225 W NORTH AVE                 15.0      12/28/2018   \n",
       "4                   5513 W NORTH AVE                 10.0      12/28/2018   \n",
       "5                   113 E JUNEAU AVE                  4.0      12/28/2018   \n",
       "6                 5101 W OKLAHOMA AV                 11.0      12/28/2018   \n",
       "7                     531 E KEEFE AV                  6.0      12/27/2018   \n",
       "8                      930 N 27TH ST                  4.0      12/27/2018   \n",
       "9                 777 E WISCONSIN AV                  4.0      12/27/2018   \n",
       "10                777 W WISCONSIN AV                  4.0      12/27/2018   \n",
       "11                    2222 S 13TH ST                 12.0      12/27/2018   \n",
       "12                 459 E PLEASANT ST                  3.0      12/26/2018   \n",
       "13                    3128 S 13TH ST                 14.0      12/26/2018   \n",
       "14                 2526 W HOPKINS ST                  6.0      12/26/2018   \n",
       "15             4312 W FOND DU LAC AV                  7.0      12/26/2018   \n",
       "16                  100 E CAPITOL DR                  6.0      12/21/2018   \n",
       "17             3301 W FOREST HOME AV                  8.0      12/21/2018   \n",
       "18             4630 W FOREST HOME AV                 11.0      12/20/2018   \n",
       "19                  5114 W HOWARD AV                 11.0      12/20/2018   \n",
       "20                     1101 S 2ND ST                 12.0      12/20/2018   \n",
       "21                    4553 S 13TH ST                 13.0      12/20/2018   \n",
       "22                 123 W OKLAHOMA AV                 14.0      12/20/2018   \n",
       "23                307 E WISCONSIN AV                  4.0      12/20/2018   \n",
       "24                 2921 N OAKLAND AV                  3.0      12/20/2018   \n",
       "25                    2323 N LAKE DR                  3.0      12/19/2018   \n",
       "26                      216 S 2ND ST                 12.0      12/19/2018   \n",
       "27                     1414 S 6TH ST                 12.0      12/19/2018   \n",
       "28                2150 N PROSPECT AV                  3.0      12/19/2018   \n",
       "29                     1125 N 9TH ST                  4.0      12/19/2018   \n",
       "...                              ...                  ...             ...   \n",
       "1118  1033 N OLD WORLD THIRD ST #100                  4.0      01/04/2019   \n",
       "1119           1555 N RIVERCENTER DR                  4.0      01/04/2019   \n",
       "1120              509 W WISCONSIN AV                  4.0      01/03/2019   \n",
       "1121              509 W WISCONSIN AV                  4.0      01/03/2019   \n",
       "1122                5611 W LISBON AV                 10.0      01/03/2019   \n",
       "1123               9130 W HAMPTON AV                  5.0      01/03/2019   \n",
       "1124                8408 W LISBON AV                  5.0      01/03/2019   \n",
       "1125            5814 W BLUE MOUND RD                  NaN      01/03/2019   \n",
       "1126                    181 S 2ND ST                  8.0      01/03/2019   \n",
       "1127                  925 E WELLS ST                  4.0      01/03/2019   \n",
       "1128                100 E CAPITOL DR                  6.0      01/03/2019   \n",
       "1129                  4323 N 60TH ST                  9.0      01/03/2019   \n",
       "1130               2700 W CAPITOL DR                  1.0      01/03/2019   \n",
       "1131             1616 W WISCONSIN AV                  4.0      01/03/2019   \n",
       "1132                    430 S 2ND ST                 12.0      01/03/2019   \n",
       "1133                  400 N WATER ST                  4.0      01/03/2019   \n",
       "1134              330 E MENOMONEE ST                  4.0      01/03/2019   \n",
       "1135               123 W OKLAHOMA AV                 14.0      01/03/2019   \n",
       "1136                   222 E ERIE ST                  4.0      01/03/2019   \n",
       "1137                 1011 E BRADY ST                  3.0      01/03/2019   \n",
       "1138                4110 W MARTIN DR                 10.0      01/03/2019   \n",
       "1139                  249 N WATER ST                  4.0      01/03/2019   \n",
       "1140           5501 N LOVERS LANE RD                  5.0      01/03/2019   \n",
       "1141              11728 W HAMPTON AV                  5.0      01/03/2019   \n",
       "1142              8333 W APPLETON AV                  5.0      01/03/2019   \n",
       "1143                 1123 N WATER ST                  4.0      01/03/2019   \n",
       "1144                  800 W WELLS ST                  4.0      01/03/2019   \n",
       "1145              275 W WISCONSIN AV                  4.0      01/03/2019   \n",
       "1146              5000 W CHAMBERS ST                  7.0      01/02/2019   \n",
       "1147               6311 W CAPITOL DR                  2.0      01/02/2019   \n",
       "\n",
       "     ESTABLISHMENT GRADE Latitude Longitude  \n",
       "0                      A                     \n",
       "1                      A                     \n",
       "2                      A                     \n",
       "3                      A                     \n",
       "4                      A                     \n",
       "5                      A                     \n",
       "6                      A                     \n",
       "7                      A                     \n",
       "8                      A                     \n",
       "9                      A                     \n",
       "10                     A                     \n",
       "11                     A                     \n",
       "12                     A                     \n",
       "13                    MA                     \n",
       "14                     A                     \n",
       "15                     A                     \n",
       "16                     A                     \n",
       "17                     A                     \n",
       "18                     A                     \n",
       "19                     A                     \n",
       "20                     A                     \n",
       "21                     A                     \n",
       "22                     A                     \n",
       "23                     A                     \n",
       "24                     B                     \n",
       "25                     A                     \n",
       "26                     A                     \n",
       "27                     A                     \n",
       "28                     A                     \n",
       "29                     A                     \n",
       "...                  ...      ...       ...  \n",
       "1118                   A                     \n",
       "1119                   A                     \n",
       "1120                   A                     \n",
       "1121                   A                     \n",
       "1122                   A                     \n",
       "1123                   A                     \n",
       "1124                   A                     \n",
       "1125                   A                     \n",
       "1126                   A                     \n",
       "1127                   A                     \n",
       "1128                   A                     \n",
       "1129                   A                     \n",
       "1130                   A                     \n",
       "1131                   A                     \n",
       "1132                   A                     \n",
       "1133                   A                     \n",
       "1134                   A                     \n",
       "1135                   A                     \n",
       "1136                   A                     \n",
       "1137                   A                     \n",
       "1138                   A                     \n",
       "1139                   A                     \n",
       "1140                   A                     \n",
       "1141                   A                     \n",
       "1142                   A                     \n",
       "1143                   A                     \n",
       "1144                   A                     \n",
       "1145                   A                     \n",
       "1146                   A                     \n",
       "1147                   A                     \n",
       "\n",
       "[1148 rows x 7 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = pd.read_csv(\"./foodgrading.csv\")\n",
    "if 'Latitude' not in data.columns and 'Longitude' not in data.columns:\n",
    "    data[\"Latitude\"] = \"\"\n",
    "    data[\"Longitude\"] = \"\"\n",
    "    print(\"No columns\")\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Fail\n"
     ]
    }
   ],
   "source": [
    "# geocode addresses for the map\n",
    "latitude = []\n",
    "longitude = []\n",
    "\n",
    "for idx, e in data.iterrows():\n",
    "    try:\n",
    "        if len(str(data.iloc[idx][\"Latitude\"])) > 0:\n",
    "            print(\"Data exists\")\n",
    "            latitude.append(data.iloc[idx][\"Latitude\"])\n",
    "            longitude.append(data.iloc[idx][\"Longitude\"])\n",
    "            continue\n",
    "            \n",
    "        \n",
    "        address = e[\"ADDRESS\"] + \", \" + \"Milwaukee\" \\\n",
    "            + \", \" + \"WI\"\n",
    "        \n",
    "        address = address.replace(\" \", \"+\")\n",
    "        request = \"https://maps.googleapis.com/maps/api/geocode/json?address={}&key=AIzaSyBU828rT3AJLuU4LtZksyB2iWH63oBLCsU\".format(address)\n",
    "        r = requests.get(request)\n",
    "        jsonInfo = r.json()\n",
    "        \n",
    "        locationDict = jsonInfo['results'][0]['geometry']['location']\n",
    "        \n",
    "        latitude.append(locationDict['lat'])\n",
    "        longitude.append(locationDict['lng'] )\n",
    "        \n",
    "              \n",
    "    except:\n",
    "        print(\"Fail\")\n",
    "data[\"Latitude\"] = latitude\n",
    "data[\"Longitude\"] = longitude\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "data.to_csv(\"./cleanedData.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "milwaukee = folium.Map(location=[43.0389, 87.9065],\n",
    "                        zoom_start=11,\n",
    "                        tiles=\"CartoDB dark_matter\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "boroughsShown = {\"A\": 0, \"C\": 0, \"C\": 0, \"T\": 0, \"MA\": 0, \"MB\": 0, \"MC\": 0, \"MT\": 0}\n",
    "\n",
    "boroughsShown[\"A\"] = data.Boro[data.Boro == \"A\"].count()\n",
    "boroughsShown[\"B\"] = data.Boro[data.Boro == \"B\"].count()\n",
    "boroughsShown[\"C\"] = data.Boro[data.Boro == \"C\"].count()\n",
    "boroughsShown[\"T\"] = data.Boro[data.Boro == \"T\"].count()\n",
    "boroughsShown[\"MA\"] = data.Boro[data.Boro == \"MA\"].count()\n",
    "boroughsShown[\"MB\"] = data.Boro[data.Boro == \"MB\"].count()\n",
    "boroughsShown[\"MC\"] = data.Boro[data.Boro == \"MC\"].count()\n",
    "boroughsShown[\"MT\"] = data.Boro[data.Boro == \"MT\"].count()\n",
    "\n",
    "print(\"hello\")\n",
    "for boro, count in boroughsShown.items():\n",
    "    print(\"{} represented by {} restaurants.\".format(boro, count))"
   ]
  },
  {
   "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.7.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}