Created
December 6, 2017 22:28
-
-
Save onelittlenightmusic/3eef03aba89d4dd62839c52ba8bfcecc to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "cells": [ | |
| { | |
| "cell_type": "code", | |
| "execution_count": 1, | |
| "metadata": { | |
| "collapsed": true | |
| }, | |
| "outputs": [], | |
| "source": [ | |
| "import findspark\n", | |
| "findspark.init()\n", | |
| "import pyspark\n", | |
| "from pyspark.sql import SQLContext\n", | |
| "sc = pyspark.SparkContext(appName=\"jdbcquery\")\n", | |
| "spark = SQLContext(sc)" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 2, | |
| "metadata": { | |
| "collapsed": true | |
| }, | |
| "outputs": [], | |
| "source": [ | |
| "def show_query_response(query):\n", | |
| " url = \"jdbc:postgresql://localhost:5432/postgres\"\n", | |
| " properties = {\"user\": \"postgres\",\"password\": \"postgres\",\"driver\": \"org.postgresql.Driver\"}\n", | |
| " read_test_with_query2 = spark.read.jdbc(table=\"(%s) as t\"%query, properties=properties, url=url)\n", | |
| " return read_test_with_query2.toPandas()" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 3, | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "data": { | |
| "text/html": [ | |
| "<div>\n", | |
| "<style>\n", | |
| " .dataframe thead tr:only-child th {\n", | |
| " text-align: right;\n", | |
| " }\n", | |
| "\n", | |
| " .dataframe thead th {\n", | |
| " text-align: left;\n", | |
| " }\n", | |
| "\n", | |
| " .dataframe tbody tr th {\n", | |
| " vertical-align: top;\n", | |
| " }\n", | |
| "</style>\n", | |
| "<table border=\"1\" class=\"dataframe\">\n", | |
| " <thead>\n", | |
| " <tr style=\"text-align: right;\">\n", | |
| " <th></th>\n", | |
| " <th>borough</th>\n", | |
| " <th>cuisine</th>\n", | |
| " <th>name</th>\n", | |
| " <th>restaurant_id</th>\n", | |
| " <th>address_json</th>\n", | |
| " <th>grades_json</th>\n", | |
| " </tr>\n", | |
| " </thead>\n", | |
| " <tbody>\n", | |
| " <tr>\n", | |
| " <th>0</th>\n", | |
| " <td>Bronx</td>\n", | |
| " <td>Bakery</td>\n", | |
| " <td>Morris Park Bake Shop</td>\n", | |
| " <td>30075445</td>\n", | |
| " <td>{\"building\":\"1007\",\"coord\":[-73.856077,40.8484...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1393804800000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Hamburgers</td>\n", | |
| " <td>Wendy'S</td>\n", | |
| " <td>30112340</td>\n", | |
| " <td>{\"building\":\"469\",\"coord\":[-73.961704,40.66294...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1419897600000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Irish</td>\n", | |
| " <td>Dj Reynolds Pub And Restaurant</td>\n", | |
| " <td>30191841</td>\n", | |
| " <td>{\"building\":\"351\",\"coord\":[-73.98513559999999,...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1409961600000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>3</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Riviera Caterer</td>\n", | |
| " <td>40356018</td>\n", | |
| " <td>{\"building\":\"2780\",\"coord\":[-73.98241999999999...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1402358400000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>4</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Jewish/Kosher</td>\n", | |
| " <td>Tov Kosher Kitchen</td>\n", | |
| " <td>40356068</td>\n", | |
| " <td>{\"building\":\"97-22\",\"coord\":[-73.8601152,40.73...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1416787200000},\"grade\":\"Z\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>5</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Brunos On The Boulevard</td>\n", | |
| " <td>40356151</td>\n", | |
| " <td>{\"building\":\"8825\",\"coord\":[-73.8803827,40.764...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1416009600000},\"grade\":\"Z\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>6</th>\n", | |
| " <td>Staten Island</td>\n", | |
| " <td>Jewish/Kosher</td>\n", | |
| " <td>Kosher Island</td>\n", | |
| " <td>40356442</td>\n", | |
| " <td>{\"building\":\"2206\",\"coord\":[-74.1377286,40.611...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1412553600000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>7</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Delicatessen</td>\n", | |
| " <td>Wilken'S Fine Food</td>\n", | |
| " <td>40356483</td>\n", | |
| " <td>{\"building\":\"7114\",\"coord\":[-73.9068506,40.619...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1401321600000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>8</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Regina Caterers</td>\n", | |
| " <td>40356649</td>\n", | |
| " <td>{\"building\":\"6409\",\"coord\":[-74.00528899999999...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1405641600000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>9</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Ice Cream, Gelato, Yogurt, Ices</td>\n", | |
| " <td>Taste The Tropics Ice Cream</td>\n", | |
| " <td>40356731</td>\n", | |
| " <td>{\"building\":\"1839\",\"coord\":[-73.9482609,40.640...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1405296000000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>10</th>\n", | |
| " <td>Bronx</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Wild Asia</td>\n", | |
| " <td>40357217</td>\n", | |
| " <td>{\"building\":\"2300\",\"coord\":[-73.8786113,40.850...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1401235200000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>11</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>American</td>\n", | |
| " <td>C & C Catering Service</td>\n", | |
| " <td>40357437</td>\n", | |
| " <td>{\"building\":\"7715\",\"coord\":[-73.9973325,40.611...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1397606400000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>12</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Chinese</td>\n", | |
| " <td>May May Kitchen</td>\n", | |
| " <td>40358429</td>\n", | |
| " <td>{\"building\":\"1269\",\"coord\":[-73.871194,40.6730...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1410825600000},\"grade\":\"B\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>13</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>American</td>\n", | |
| " <td>1 East 66Th Street Kitchen</td>\n", | |
| " <td>40359480</td>\n", | |
| " <td>{\"building\":\"1\",\"coord\":[-73.96926909999999,40...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1399420800000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>14</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Jewish/Kosher</td>\n", | |
| " <td>Seuda Foods</td>\n", | |
| " <td>40360045</td>\n", | |
| " <td>{\"building\":\"705\",\"coord\":[-73.9653967,40.6064...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1415577600000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>15</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Ice Cream, Gelato, Yogurt, Ices</td>\n", | |
| " <td>Carvel Ice Cream</td>\n", | |
| " <td>40360076</td>\n", | |
| " <td>{\"building\":\"203\",\"coord\":[-73.97822040000001,...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1391990400000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>16</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Ice Cream, Gelato, Yogurt, Ices</td>\n", | |
| " <td>Carvel Ice Cream</td>\n", | |
| " <td>40361322</td>\n", | |
| " <td>{\"building\":\"265-15\",\"coord\":[-73.7032601,40.7...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1414454400000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>17</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Delicatessen</td>\n", | |
| " <td>Nordic Delicacies</td>\n", | |
| " <td>40361390</td>\n", | |
| " <td>{\"building\":\"6909\",\"coord\":[-74.0259567,40.635...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1408579200000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>18</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Glorious Food</td>\n", | |
| " <td>40361521</td>\n", | |
| " <td>{\"building\":\"522\",\"coord\":[-73.95171,40.767461...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1409616000000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>19</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>American</td>\n", | |
| " <td>The Movable Feast</td>\n", | |
| " <td>40361606</td>\n", | |
| " <td>{\"building\":\"284\",\"coord\":[-73.9829239,40.6580...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1416355200000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>20</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Delicatessen</td>\n", | |
| " <td>Sal'S Deli</td>\n", | |
| " <td>40361618</td>\n", | |
| " <td>{\"building\":\"129-08\",\"coord\":[-73.839297,40.78...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1408147200000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>21</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Delicatessen</td>\n", | |
| " <td>Bully'S Deli</td>\n", | |
| " <td>40361708</td>\n", | |
| " <td>{\"building\":\"759\",\"coord\":[-73.9925306,40.7309...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1390262400000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>22</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Delicatessen</td>\n", | |
| " <td>Steve Chu'S Deli & Grocery</td>\n", | |
| " <td>40361998</td>\n", | |
| " <td>{\"building\":\"3406\",\"coord\":[-73.94024739999999...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1395187200000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>23</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Chicken</td>\n", | |
| " <td>Harriet'S Kitchen</td>\n", | |
| " <td>40362098</td>\n", | |
| " <td>{\"building\":\"502\",\"coord\":[-73.976112,40.78671...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1410739200000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>24</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>American</td>\n", | |
| " <td>P & S Deli Grocery</td>\n", | |
| " <td>40362264</td>\n", | |
| " <td>{\"building\":\"730\",\"coord\":[-73.96805719999999,...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1410480000000},\"grade\":\"B\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Angelika Film Center</td>\n", | |
| " <td>40362274</td>\n", | |
| " <td>{\"building\":\"18\",\"coord\":[-73.996984,40.72589]...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1396483200000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>26</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Hamburgers</td>\n", | |
| " <td>White Castle</td>\n", | |
| " <td>40362344</td>\n", | |
| " <td>{\"building\":\"531\",\"coord\":[-73.9634876,40.6940...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1395100800000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>27</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Chinese</td>\n", | |
| " <td>Ho Mei Restaurant</td>\n", | |
| " <td>40362432</td>\n", | |
| " <td>{\"building\":\"103-05\",\"coord\":[-73.8642349,40.7...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1398038400000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>28</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Turkish</td>\n", | |
| " <td>The Country Cafe</td>\n", | |
| " <td>40362715</td>\n", | |
| " <td>{\"building\":\"60\",\"coord\":[-74.0085357,40.70620...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1411689600000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>29</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Caribbean</td>\n", | |
| " <td>Shashemene Int'L Restaura</td>\n", | |
| " <td>40362869</td>\n", | |
| " <td>{\"building\":\"195\",\"coord\":[-73.9246028,40.6522...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1399939200000},\"grade\":\"A\",\"...</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", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25329</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Mexican</td>\n", | |
| " <td>Bella'S Place</td>\n", | |
| " <td>41646934</td>\n", | |
| " <td>{\"building\":\"87-77\",\"coord\":[-73.8093635,40.70...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1413417600000},\"grade\":\"Z\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25330</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Caribbean</td>\n", | |
| " <td>Perfect Touch Cuisine Ii</td>\n", | |
| " <td>41646958</td>\n", | |
| " <td>{\"building\":\"1148\",\"coord\":[-73.9508029,40.659...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1409270400000},\"grade\":\"B\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25331</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Del Rio Diner</td>\n", | |
| " <td>41646963</td>\n", | |
| " <td>{\"building\":\"166\",\"coord\":[-73.98527659999999,...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1397001600000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25332</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Chinese</td>\n", | |
| " <td>Fay Da Bakery</td>\n", | |
| " <td>41646967</td>\n", | |
| " <td>{\"building\":\"321\",\"coord\":[-74.0062401,40.7397...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1399852800000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25333</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Caribbean</td>\n", | |
| " <td>Jahlookova</td>\n", | |
| " <td>41646976</td>\n", | |
| " <td>{\"building\":\"1962\",\"coord\":[-73.9405519,40.806...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1416960000000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25334</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Delicatessen</td>\n", | |
| " <td>Merci Market</td>\n", | |
| " <td>41646979</td>\n", | |
| " <td>{\"building\":\"350\",\"coord\":[-73.9922178,40.7579...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1420588800000},\"grade\":\"Z\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25335</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Caribbean</td>\n", | |
| " <td>Meat Veggies & Pasta Restaurant</td>\n", | |
| " <td>41647006</td>\n", | |
| " <td>{\"building\":\"118-16\",\"coord\":[-73.819531,40.67...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1415577600000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25336</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Toshi'S Living Room</td>\n", | |
| " <td>41647012</td>\n", | |
| " <td>{\"building\":\"9\",\"coord\":[-73.98931019999999,40...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1415750400000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25337</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Five Lamps Tavern</td>\n", | |
| " <td>41647017</td>\n", | |
| " <td>{\"building\":\"2756\",\"coord\":[-73.9675441,40.800...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1407283200000},\"grade\":\"C\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25338</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>German</td>\n", | |
| " <td>Max</td>\n", | |
| " <td>41647039</td>\n", | |
| " <td>{\"building\":\"47-02\",\"coord\":[-73.918047,40.765...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1416355200000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25339</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Chinese</td>\n", | |
| " <td>Liang'S Kitchen Flushing Restaurant</td>\n", | |
| " <td>41647062</td>\n", | |
| " <td>{\"building\":\"13351\",\"coord\":[-73.832828,40.759...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1403308800000},\"grade\":\"B\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25340</th>\n", | |
| " <td>Bronx</td>\n", | |
| " <td>Bangladeshi</td>\n", | |
| " <td>Mehman Sweets Restaurant</td>\n", | |
| " <td>41647098</td>\n", | |
| " <td>{\"building\":\"1445\",\"coord\":[-73.8549994,40.835...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1406592000000},\"grade\":\"Z\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25341</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Mexican</td>\n", | |
| " <td>Stephanie'S Mexican Bakery</td>\n", | |
| " <td>41647129</td>\n", | |
| " <td>{\"building\":\"37-56\",\"coord\":[-73.860018,40.752...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1408406400000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25342</th>\n", | |
| " <td>Bronx</td>\n", | |
| " <td>Bakery</td>\n", | |
| " <td>Bibbies Bakery</td>\n", | |
| " <td>41647169</td>\n", | |
| " <td>{\"building\":\"262\",\"coord\":[-73.9111954,40.8615...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1399507200000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25343</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Thai</td>\n", | |
| " <td>Jaiya Thai & Oriental Restaurant</td>\n", | |
| " <td>41647176</td>\n", | |
| " <td>{\"building\":\"1553\",\"coord\":[-73.954548,40.7745...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1414540800000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25344</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Chinese</td>\n", | |
| " <td>China Wok</td>\n", | |
| " <td>41647181</td>\n", | |
| " <td>{\"building\":\"199\",\"coord\":[-73.9831015,40.7228...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1408060800000},\"grade\":\"B\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25345</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Chinese</td>\n", | |
| " <td>Xing Xing Chinese Restaurant</td>\n", | |
| " <td>41647183</td>\n", | |
| " <td>{\"building\":\"9712\",\"coord\":[-73.8194803,40.584...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1398729600000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25346</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Packard Cafe</td>\n", | |
| " <td>41647192</td>\n", | |
| " <td>{\"building\":\"4134\",\"coord\":[-73.9400398,40.751...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1421193600000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25347</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Pizza</td>\n", | |
| " <td>Springfield & La Bari Pizzeria</td>\n", | |
| " <td>41647210</td>\n", | |
| " <td>{\"building\":\"136-13\",\"coord\":[-73.763352,40.67...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1419984000000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25348</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Caribbean</td>\n", | |
| " <td>Dee'S Catering Services</td>\n", | |
| " <td>41647221</td>\n", | |
| " <td>{\"building\":\"217-15\",\"coord\":[-73.737423999999...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1401840000000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25349</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Asian</td>\n", | |
| " <td>Jack'S Sliders And Sushi</td>\n", | |
| " <td>41647241</td>\n", | |
| " <td>{\"building\":\"171\",\"coord\":[-73.98581899999999,...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1417564800000},\"grade\":\"B\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25350</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Chinese</td>\n", | |
| " <td>New Ming Fat Chinese Restaurant</td>\n", | |
| " <td>41647292</td>\n", | |
| " <td>{\"building\":\"1155\",\"coord\":[-73.8753401,40.672...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1394496000000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25351</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Chinese</td>\n", | |
| " <td>Noodle House</td>\n", | |
| " <td>41647360</td>\n", | |
| " <td>{\"building\":\"56-09\",\"coord\":[-73.7315557,40.76...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1404259200000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25352</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Middle Eastern</td>\n", | |
| " <td>Bahary Fish Market</td>\n", | |
| " <td>41647370</td>\n", | |
| " <td>{\"building\":\"484\",\"coord\":[-74.0212854,40.6334...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1401840000000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25353</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>American</td>\n", | |
| " <td>The Tin House Tavern</td>\n", | |
| " <td>41647380</td>\n", | |
| " <td>{\"building\":\"195-02\",\"coord\":[-73.785758,40.75...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1410134400000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25354</th>\n", | |
| " <td>Staten Island</td>\n", | |
| " <td>Pizza</td>\n", | |
| " <td>Ambrosino'S Ii</td>\n", | |
| " <td>41647384</td>\n", | |
| " <td>{\"building\":\"6410\",\"coord\":[-74.2150624,40.521...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1409616000000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25355</th>\n", | |
| " <td>Bronx</td>\n", | |
| " <td>Soul Food</td>\n", | |
| " <td>Bruce'S Fish And Chips</td>\n", | |
| " <td>41647392</td>\n", | |
| " <td>{\"building\":\"500\",\"coord\":[-73.890768,40.85709...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1403568000000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25356</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Café/Coffee/Tea</td>\n", | |
| " <td>Coffee Bean Tea & Leaf</td>\n", | |
| " <td>41647399</td>\n", | |
| " <td>{\"building\":\"2169\",\"coord\":[-73.981231,40.7822...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1406592000000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25357</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Ice Cream, Gelato, Yogurt, Ices</td>\n", | |
| " <td>Gelato Ti Amo</td>\n", | |
| " <td>41647482</td>\n", | |
| " <td>{\"building\":\"68\",\"coord\":[-73.9892179,40.72594...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1403913600000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25358</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Caribbean</td>\n", | |
| " <td>Rockaway Roti Shop</td>\n", | |
| " <td>41647521</td>\n", | |
| " <td>{\"building\":\"12221\",\"coord\":[-73.8032425999999...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1418428800000},\"grade\":\"A\",\"...</td>\n", | |
| " </tr>\n", | |
| " </tbody>\n", | |
| "</table>\n", | |
| "<p>25359 rows × 6 columns</p>\n", | |
| "</div>" | |
| ], | |
| "text/plain": [ | |
| " borough cuisine \\\n", | |
| "0 Bronx Bakery \n", | |
| "1 Brooklyn Hamburgers \n", | |
| "2 Manhattan Irish \n", | |
| "3 Brooklyn American \n", | |
| "4 Queens Jewish/Kosher \n", | |
| "5 Queens American \n", | |
| "6 Staten Island Jewish/Kosher \n", | |
| "7 Brooklyn Delicatessen \n", | |
| "8 Brooklyn American \n", | |
| "9 Brooklyn Ice Cream, Gelato, Yogurt, Ices \n", | |
| "10 Bronx American \n", | |
| "11 Brooklyn American \n", | |
| "12 Brooklyn Chinese \n", | |
| "13 Manhattan American \n", | |
| "14 Brooklyn Jewish/Kosher \n", | |
| "15 Brooklyn Ice Cream, Gelato, Yogurt, Ices \n", | |
| "16 Queens Ice Cream, Gelato, Yogurt, Ices \n", | |
| "17 Brooklyn Delicatessen \n", | |
| "18 Manhattan American \n", | |
| "19 Brooklyn American \n", | |
| "20 Queens Delicatessen \n", | |
| "21 Manhattan Delicatessen \n", | |
| "22 Queens Delicatessen \n", | |
| "23 Manhattan Chicken \n", | |
| "24 Manhattan American \n", | |
| "25 Manhattan American \n", | |
| "26 Brooklyn Hamburgers \n", | |
| "27 Queens Chinese \n", | |
| "28 Manhattan Turkish \n", | |
| "29 Brooklyn Caribbean \n", | |
| "... ... ... \n", | |
| "25329 Queens Mexican \n", | |
| "25330 Brooklyn Caribbean \n", | |
| "25331 Brooklyn American \n", | |
| "25332 Manhattan Chinese \n", | |
| "25333 Manhattan Caribbean \n", | |
| "25334 Manhattan Delicatessen \n", | |
| "25335 Queens Caribbean \n", | |
| "25336 Manhattan American \n", | |
| "25337 Manhattan American \n", | |
| "25338 Queens German \n", | |
| "25339 Queens Chinese \n", | |
| "25340 Bronx Bangladeshi \n", | |
| "25341 Queens Mexican \n", | |
| "25342 Bronx Bakery \n", | |
| "25343 Manhattan Thai \n", | |
| "25344 Manhattan Chinese \n", | |
| "25345 Queens Chinese \n", | |
| "25346 Queens American \n", | |
| "25347 Queens Pizza \n", | |
| "25348 Queens Caribbean \n", | |
| "25349 Manhattan Asian \n", | |
| "25350 Brooklyn Chinese \n", | |
| "25351 Queens Chinese \n", | |
| "25352 Brooklyn Middle Eastern \n", | |
| "25353 Queens American \n", | |
| "25354 Staten Island Pizza \n", | |
| "25355 Bronx Soul Food \n", | |
| "25356 Manhattan Café/Coffee/Tea \n", | |
| "25357 Manhattan Ice Cream, Gelato, Yogurt, Ices \n", | |
| "25358 Queens Caribbean \n", | |
| "\n", | |
| " name restaurant_id \\\n", | |
| "0 Morris Park Bake Shop 30075445 \n", | |
| "1 Wendy'S 30112340 \n", | |
| "2 Dj Reynolds Pub And Restaurant 30191841 \n", | |
| "3 Riviera Caterer 40356018 \n", | |
| "4 Tov Kosher Kitchen 40356068 \n", | |
| "5 Brunos On The Boulevard 40356151 \n", | |
| "6 Kosher Island 40356442 \n", | |
| "7 Wilken'S Fine Food 40356483 \n", | |
| "8 Regina Caterers 40356649 \n", | |
| "9 Taste The Tropics Ice Cream 40356731 \n", | |
| "10 Wild Asia 40357217 \n", | |
| "11 C & C Catering Service 40357437 \n", | |
| "12 May May Kitchen 40358429 \n", | |
| "13 1 East 66Th Street Kitchen 40359480 \n", | |
| "14 Seuda Foods 40360045 \n", | |
| "15 Carvel Ice Cream 40360076 \n", | |
| "16 Carvel Ice Cream 40361322 \n", | |
| "17 Nordic Delicacies 40361390 \n", | |
| "18 Glorious Food 40361521 \n", | |
| "19 The Movable Feast 40361606 \n", | |
| "20 Sal'S Deli 40361618 \n", | |
| "21 Bully'S Deli 40361708 \n", | |
| "22 Steve Chu'S Deli & Grocery 40361998 \n", | |
| "23 Harriet'S Kitchen 40362098 \n", | |
| "24 P & S Deli Grocery 40362264 \n", | |
| "25 Angelika Film Center 40362274 \n", | |
| "26 White Castle 40362344 \n", | |
| "27 Ho Mei Restaurant 40362432 \n", | |
| "28 The Country Cafe 40362715 \n", | |
| "29 Shashemene Int'L Restaura 40362869 \n", | |
| "... ... ... \n", | |
| "25329 Bella'S Place 41646934 \n", | |
| "25330 Perfect Touch Cuisine Ii 41646958 \n", | |
| "25331 Del Rio Diner 41646963 \n", | |
| "25332 Fay Da Bakery 41646967 \n", | |
| "25333 Jahlookova 41646976 \n", | |
| "25334 Merci Market 41646979 \n", | |
| "25335 Meat Veggies & Pasta Restaurant 41647006 \n", | |
| "25336 Toshi'S Living Room 41647012 \n", | |
| "25337 Five Lamps Tavern 41647017 \n", | |
| "25338 Max 41647039 \n", | |
| "25339 Liang'S Kitchen Flushing Restaurant 41647062 \n", | |
| "25340 Mehman Sweets Restaurant 41647098 \n", | |
| "25341 Stephanie'S Mexican Bakery 41647129 \n", | |
| "25342 Bibbies Bakery 41647169 \n", | |
| "25343 Jaiya Thai & Oriental Restaurant 41647176 \n", | |
| "25344 China Wok 41647181 \n", | |
| "25345 Xing Xing Chinese Restaurant 41647183 \n", | |
| "25346 Packard Cafe 41647192 \n", | |
| "25347 Springfield & La Bari Pizzeria 41647210 \n", | |
| "25348 Dee'S Catering Services 41647221 \n", | |
| "25349 Jack'S Sliders And Sushi 41647241 \n", | |
| "25350 New Ming Fat Chinese Restaurant 41647292 \n", | |
| "25351 Noodle House 41647360 \n", | |
| "25352 Bahary Fish Market 41647370 \n", | |
| "25353 The Tin House Tavern 41647380 \n", | |
| "25354 Ambrosino'S Ii 41647384 \n", | |
| "25355 Bruce'S Fish And Chips 41647392 \n", | |
| "25356 Coffee Bean Tea & Leaf 41647399 \n", | |
| "25357 Gelato Ti Amo 41647482 \n", | |
| "25358 Rockaway Roti Shop 41647521 \n", | |
| "\n", | |
| " address_json \\\n", | |
| "0 {\"building\":\"1007\",\"coord\":[-73.856077,40.8484... \n", | |
| "1 {\"building\":\"469\",\"coord\":[-73.961704,40.66294... \n", | |
| "2 {\"building\":\"351\",\"coord\":[-73.98513559999999,... \n", | |
| "3 {\"building\":\"2780\",\"coord\":[-73.98241999999999... \n", | |
| "4 {\"building\":\"97-22\",\"coord\":[-73.8601152,40.73... \n", | |
| "5 {\"building\":\"8825\",\"coord\":[-73.8803827,40.764... \n", | |
| "6 {\"building\":\"2206\",\"coord\":[-74.1377286,40.611... \n", | |
| "7 {\"building\":\"7114\",\"coord\":[-73.9068506,40.619... \n", | |
| "8 {\"building\":\"6409\",\"coord\":[-74.00528899999999... \n", | |
| "9 {\"building\":\"1839\",\"coord\":[-73.9482609,40.640... \n", | |
| "10 {\"building\":\"2300\",\"coord\":[-73.8786113,40.850... \n", | |
| "11 {\"building\":\"7715\",\"coord\":[-73.9973325,40.611... \n", | |
| "12 {\"building\":\"1269\",\"coord\":[-73.871194,40.6730... \n", | |
| "13 {\"building\":\"1\",\"coord\":[-73.96926909999999,40... \n", | |
| "14 {\"building\":\"705\",\"coord\":[-73.9653967,40.6064... \n", | |
| "15 {\"building\":\"203\",\"coord\":[-73.97822040000001,... \n", | |
| "16 {\"building\":\"265-15\",\"coord\":[-73.7032601,40.7... \n", | |
| "17 {\"building\":\"6909\",\"coord\":[-74.0259567,40.635... \n", | |
| "18 {\"building\":\"522\",\"coord\":[-73.95171,40.767461... \n", | |
| "19 {\"building\":\"284\",\"coord\":[-73.9829239,40.6580... \n", | |
| "20 {\"building\":\"129-08\",\"coord\":[-73.839297,40.78... \n", | |
| "21 {\"building\":\"759\",\"coord\":[-73.9925306,40.7309... \n", | |
| "22 {\"building\":\"3406\",\"coord\":[-73.94024739999999... \n", | |
| "23 {\"building\":\"502\",\"coord\":[-73.976112,40.78671... \n", | |
| "24 {\"building\":\"730\",\"coord\":[-73.96805719999999,... \n", | |
| "25 {\"building\":\"18\",\"coord\":[-73.996984,40.72589]... \n", | |
| "26 {\"building\":\"531\",\"coord\":[-73.9634876,40.6940... \n", | |
| "27 {\"building\":\"103-05\",\"coord\":[-73.8642349,40.7... \n", | |
| "28 {\"building\":\"60\",\"coord\":[-74.0085357,40.70620... \n", | |
| "29 {\"building\":\"195\",\"coord\":[-73.9246028,40.6522... \n", | |
| "... ... \n", | |
| "25329 {\"building\":\"87-77\",\"coord\":[-73.8093635,40.70... \n", | |
| "25330 {\"building\":\"1148\",\"coord\":[-73.9508029,40.659... \n", | |
| "25331 {\"building\":\"166\",\"coord\":[-73.98527659999999,... \n", | |
| "25332 {\"building\":\"321\",\"coord\":[-74.0062401,40.7397... \n", | |
| "25333 {\"building\":\"1962\",\"coord\":[-73.9405519,40.806... \n", | |
| "25334 {\"building\":\"350\",\"coord\":[-73.9922178,40.7579... \n", | |
| "25335 {\"building\":\"118-16\",\"coord\":[-73.819531,40.67... \n", | |
| "25336 {\"building\":\"9\",\"coord\":[-73.98931019999999,40... \n", | |
| "25337 {\"building\":\"2756\",\"coord\":[-73.9675441,40.800... \n", | |
| "25338 {\"building\":\"47-02\",\"coord\":[-73.918047,40.765... \n", | |
| "25339 {\"building\":\"13351\",\"coord\":[-73.832828,40.759... \n", | |
| "25340 {\"building\":\"1445\",\"coord\":[-73.8549994,40.835... \n", | |
| "25341 {\"building\":\"37-56\",\"coord\":[-73.860018,40.752... \n", | |
| "25342 {\"building\":\"262\",\"coord\":[-73.9111954,40.8615... \n", | |
| "25343 {\"building\":\"1553\",\"coord\":[-73.954548,40.7745... \n", | |
| "25344 {\"building\":\"199\",\"coord\":[-73.9831015,40.7228... \n", | |
| "25345 {\"building\":\"9712\",\"coord\":[-73.8194803,40.584... \n", | |
| "25346 {\"building\":\"4134\",\"coord\":[-73.9400398,40.751... \n", | |
| "25347 {\"building\":\"136-13\",\"coord\":[-73.763352,40.67... \n", | |
| "25348 {\"building\":\"217-15\",\"coord\":[-73.737423999999... \n", | |
| "25349 {\"building\":\"171\",\"coord\":[-73.98581899999999,... \n", | |
| "25350 {\"building\":\"1155\",\"coord\":[-73.8753401,40.672... \n", | |
| "25351 {\"building\":\"56-09\",\"coord\":[-73.7315557,40.76... \n", | |
| "25352 {\"building\":\"484\",\"coord\":[-74.0212854,40.6334... \n", | |
| "25353 {\"building\":\"195-02\",\"coord\":[-73.785758,40.75... \n", | |
| "25354 {\"building\":\"6410\",\"coord\":[-74.2150624,40.521... \n", | |
| "25355 {\"building\":\"500\",\"coord\":[-73.890768,40.85709... \n", | |
| "25356 {\"building\":\"2169\",\"coord\":[-73.981231,40.7822... \n", | |
| "25357 {\"building\":\"68\",\"coord\":[-73.9892179,40.72594... \n", | |
| "25358 {\"building\":\"12221\",\"coord\":[-73.8032425999999... \n", | |
| "\n", | |
| " grades_json \n", | |
| "0 [{\"date\":{\"$date\":1393804800000},\"grade\":\"A\",\"... \n", | |
| "1 [{\"date\":{\"$date\":1419897600000},\"grade\":\"A\",\"... \n", | |
| "2 [{\"date\":{\"$date\":1409961600000},\"grade\":\"A\",\"... \n", | |
| "3 [{\"date\":{\"$date\":1402358400000},\"grade\":\"A\",\"... \n", | |
| "4 [{\"date\":{\"$date\":1416787200000},\"grade\":\"Z\",\"... \n", | |
| "5 [{\"date\":{\"$date\":1416009600000},\"grade\":\"Z\",\"... \n", | |
| "6 [{\"date\":{\"$date\":1412553600000},\"grade\":\"A\",\"... \n", | |
| "7 [{\"date\":{\"$date\":1401321600000},\"grade\":\"A\",\"... \n", | |
| "8 [{\"date\":{\"$date\":1405641600000},\"grade\":\"A\",\"... \n", | |
| "9 [{\"date\":{\"$date\":1405296000000},\"grade\":\"A\",\"... \n", | |
| "10 [{\"date\":{\"$date\":1401235200000},\"grade\":\"A\",\"... \n", | |
| "11 [{\"date\":{\"$date\":1397606400000},\"grade\":\"A\",\"... \n", | |
| "12 [{\"date\":{\"$date\":1410825600000},\"grade\":\"B\",\"... \n", | |
| "13 [{\"date\":{\"$date\":1399420800000},\"grade\":\"A\",\"... \n", | |
| "14 [{\"date\":{\"$date\":1415577600000},\"grade\":\"A\",\"... \n", | |
| "15 [{\"date\":{\"$date\":1391990400000},\"grade\":\"A\",\"... \n", | |
| "16 [{\"date\":{\"$date\":1414454400000},\"grade\":\"A\",\"... \n", | |
| "17 [{\"date\":{\"$date\":1408579200000},\"grade\":\"A\",\"... \n", | |
| "18 [{\"date\":{\"$date\":1409616000000},\"grade\":\"A\",\"... \n", | |
| "19 [{\"date\":{\"$date\":1416355200000},\"grade\":\"A\",\"... \n", | |
| "20 [{\"date\":{\"$date\":1408147200000},\"grade\":\"A\",\"... \n", | |
| "21 [{\"date\":{\"$date\":1390262400000},\"grade\":\"A\",\"... \n", | |
| "22 [{\"date\":{\"$date\":1395187200000},\"grade\":\"A\",\"... \n", | |
| "23 [{\"date\":{\"$date\":1410739200000},\"grade\":\"A\",\"... \n", | |
| "24 [{\"date\":{\"$date\":1410480000000},\"grade\":\"B\",\"... \n", | |
| "25 [{\"date\":{\"$date\":1396483200000},\"grade\":\"A\",\"... \n", | |
| "26 [{\"date\":{\"$date\":1395100800000},\"grade\":\"A\",\"... \n", | |
| "27 [{\"date\":{\"$date\":1398038400000},\"grade\":\"A\",\"... \n", | |
| "28 [{\"date\":{\"$date\":1411689600000},\"grade\":\"A\",\"... \n", | |
| "29 [{\"date\":{\"$date\":1399939200000},\"grade\":\"A\",\"... \n", | |
| "... ... \n", | |
| "25329 [{\"date\":{\"$date\":1413417600000},\"grade\":\"Z\",\"... \n", | |
| "25330 [{\"date\":{\"$date\":1409270400000},\"grade\":\"B\",\"... \n", | |
| "25331 [{\"date\":{\"$date\":1397001600000},\"grade\":\"A\",\"... \n", | |
| "25332 [{\"date\":{\"$date\":1399852800000},\"grade\":\"A\",\"... \n", | |
| "25333 [{\"date\":{\"$date\":1416960000000},\"grade\":\"A\",\"... \n", | |
| "25334 [{\"date\":{\"$date\":1420588800000},\"grade\":\"Z\",\"... \n", | |
| "25335 [{\"date\":{\"$date\":1415577600000},\"grade\":\"A\",\"... \n", | |
| "25336 [{\"date\":{\"$date\":1415750400000},\"grade\":\"A\",\"... \n", | |
| "25337 [{\"date\":{\"$date\":1407283200000},\"grade\":\"C\",\"... \n", | |
| "25338 [{\"date\":{\"$date\":1416355200000},\"grade\":\"A\",\"... \n", | |
| "25339 [{\"date\":{\"$date\":1403308800000},\"grade\":\"B\",\"... \n", | |
| "25340 [{\"date\":{\"$date\":1406592000000},\"grade\":\"Z\",\"... \n", | |
| "25341 [{\"date\":{\"$date\":1408406400000},\"grade\":\"A\",\"... \n", | |
| "25342 [{\"date\":{\"$date\":1399507200000},\"grade\":\"A\",\"... \n", | |
| "25343 [{\"date\":{\"$date\":1414540800000},\"grade\":\"A\",\"... \n", | |
| "25344 [{\"date\":{\"$date\":1408060800000},\"grade\":\"B\",\"... \n", | |
| "25345 [{\"date\":{\"$date\":1398729600000},\"grade\":\"A\",\"... \n", | |
| "25346 [{\"date\":{\"$date\":1421193600000},\"grade\":\"A\",\"... \n", | |
| "25347 [{\"date\":{\"$date\":1419984000000},\"grade\":\"A\",\"... \n", | |
| "25348 [{\"date\":{\"$date\":1401840000000},\"grade\":\"A\",\"... \n", | |
| "25349 [{\"date\":{\"$date\":1417564800000},\"grade\":\"B\",\"... \n", | |
| "25350 [{\"date\":{\"$date\":1394496000000},\"grade\":\"A\",\"... \n", | |
| "25351 [{\"date\":{\"$date\":1404259200000},\"grade\":\"A\",\"... \n", | |
| "25352 [{\"date\":{\"$date\":1401840000000},\"grade\":\"A\",\"... \n", | |
| "25353 [{\"date\":{\"$date\":1410134400000},\"grade\":\"A\",\"... \n", | |
| "25354 [{\"date\":{\"$date\":1409616000000},\"grade\":\"A\",\"... \n", | |
| "25355 [{\"date\":{\"$date\":1403568000000},\"grade\":\"A\",\"... \n", | |
| "25356 [{\"date\":{\"$date\":1406592000000},\"grade\":\"A\",\"... \n", | |
| "25357 [{\"date\":{\"$date\":1403913600000},\"grade\":\"A\",\"... \n", | |
| "25358 [{\"date\":{\"$date\":1418428800000},\"grade\":\"A\",\"... \n", | |
| "\n", | |
| "[25359 rows x 6 columns]" | |
| ] | |
| }, | |
| "execution_count": 3, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "url = \"jdbc:postgresql://localhost:5432/postgres\"\n", | |
| "properties = {\"user\": \"postgres\",\"password\": \"postgres\",\"driver\": \"org.postgresql.Driver\"}\n", | |
| "read_test = spark.read.jdbc(table=\"restaurant_from_df\", properties=properties, url=\"jdbc:postgresql://localhost:5432/postgres\")\n", | |
| "read_test.toPandas()" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 4, | |
| "metadata": { | |
| "collapsed": true | |
| }, | |
| "outputs": [], | |
| "source": [ | |
| "url = \"jdbc:postgresql://localhost:5432/postgres\"\n", | |
| "properties = {\"user\": \"postgres\",\"password\": \"postgres\",\"driver\": \"org.postgresql.Driver\"}\n", | |
| "read_test_with_query = spark.read.jdbc(table=\"(select *, address_json::json->'building' as building from restaurant_from_df) as t\", properties=properties, url=url)" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 5, | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "data": { | |
| "text/html": [ | |
| "<div>\n", | |
| "<style>\n", | |
| " .dataframe thead tr:only-child th {\n", | |
| " text-align: right;\n", | |
| " }\n", | |
| "\n", | |
| " .dataframe thead th {\n", | |
| " text-align: left;\n", | |
| " }\n", | |
| "\n", | |
| " .dataframe tbody tr th {\n", | |
| " vertical-align: top;\n", | |
| " }\n", | |
| "</style>\n", | |
| "<table border=\"1\" class=\"dataframe\">\n", | |
| " <thead>\n", | |
| " <tr style=\"text-align: right;\">\n", | |
| " <th></th>\n", | |
| " <th>borough</th>\n", | |
| " <th>cuisine</th>\n", | |
| " <th>name</th>\n", | |
| " <th>restaurant_id</th>\n", | |
| " <th>address_json</th>\n", | |
| " <th>grades_json</th>\n", | |
| " <th>building</th>\n", | |
| " </tr>\n", | |
| " </thead>\n", | |
| " <tbody>\n", | |
| " <tr>\n", | |
| " <th>0</th>\n", | |
| " <td>Bronx</td>\n", | |
| " <td>Bakery</td>\n", | |
| " <td>Morris Park Bake Shop</td>\n", | |
| " <td>30075445</td>\n", | |
| " <td>{\"building\":\"1007\",\"coord\":[-73.856077,40.8484...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1393804800000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"1007\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Hamburgers</td>\n", | |
| " <td>Wendy'S</td>\n", | |
| " <td>30112340</td>\n", | |
| " <td>{\"building\":\"469\",\"coord\":[-73.961704,40.66294...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1419897600000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"469\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Irish</td>\n", | |
| " <td>Dj Reynolds Pub And Restaurant</td>\n", | |
| " <td>30191841</td>\n", | |
| " <td>{\"building\":\"351\",\"coord\":[-73.98513559999999,...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1409961600000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"351\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>3</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Riviera Caterer</td>\n", | |
| " <td>40356018</td>\n", | |
| " <td>{\"building\":\"2780\",\"coord\":[-73.98241999999999...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1402358400000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"2780\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>4</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Jewish/Kosher</td>\n", | |
| " <td>Tov Kosher Kitchen</td>\n", | |
| " <td>40356068</td>\n", | |
| " <td>{\"building\":\"97-22\",\"coord\":[-73.8601152,40.73...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1416787200000},\"grade\":\"Z\",\"...</td>\n", | |
| " <td>\"97-22\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>5</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Brunos On The Boulevard</td>\n", | |
| " <td>40356151</td>\n", | |
| " <td>{\"building\":\"8825\",\"coord\":[-73.8803827,40.764...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1416009600000},\"grade\":\"Z\",\"...</td>\n", | |
| " <td>\"8825\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>6</th>\n", | |
| " <td>Staten Island</td>\n", | |
| " <td>Jewish/Kosher</td>\n", | |
| " <td>Kosher Island</td>\n", | |
| " <td>40356442</td>\n", | |
| " <td>{\"building\":\"2206\",\"coord\":[-74.1377286,40.611...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1412553600000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"2206\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>7</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Delicatessen</td>\n", | |
| " <td>Wilken'S Fine Food</td>\n", | |
| " <td>40356483</td>\n", | |
| " <td>{\"building\":\"7114\",\"coord\":[-73.9068506,40.619...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1401321600000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"7114\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>8</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Regina Caterers</td>\n", | |
| " <td>40356649</td>\n", | |
| " <td>{\"building\":\"6409\",\"coord\":[-74.00528899999999...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1405641600000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"6409\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>9</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Ice Cream, Gelato, Yogurt, Ices</td>\n", | |
| " <td>Taste The Tropics Ice Cream</td>\n", | |
| " <td>40356731</td>\n", | |
| " <td>{\"building\":\"1839\",\"coord\":[-73.9482609,40.640...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1405296000000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"1839\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>10</th>\n", | |
| " <td>Bronx</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Wild Asia</td>\n", | |
| " <td>40357217</td>\n", | |
| " <td>{\"building\":\"2300\",\"coord\":[-73.8786113,40.850...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1401235200000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"2300\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>11</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>American</td>\n", | |
| " <td>C & C Catering Service</td>\n", | |
| " <td>40357437</td>\n", | |
| " <td>{\"building\":\"7715\",\"coord\":[-73.9973325,40.611...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1397606400000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"7715\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>12</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Chinese</td>\n", | |
| " <td>May May Kitchen</td>\n", | |
| " <td>40358429</td>\n", | |
| " <td>{\"building\":\"1269\",\"coord\":[-73.871194,40.6730...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1410825600000},\"grade\":\"B\",\"...</td>\n", | |
| " <td>\"1269\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>13</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>American</td>\n", | |
| " <td>1 East 66Th Street Kitchen</td>\n", | |
| " <td>40359480</td>\n", | |
| " <td>{\"building\":\"1\",\"coord\":[-73.96926909999999,40...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1399420800000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"1\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>14</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Jewish/Kosher</td>\n", | |
| " <td>Seuda Foods</td>\n", | |
| " <td>40360045</td>\n", | |
| " <td>{\"building\":\"705\",\"coord\":[-73.9653967,40.6064...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1415577600000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"705\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>15</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Ice Cream, Gelato, Yogurt, Ices</td>\n", | |
| " <td>Carvel Ice Cream</td>\n", | |
| " <td>40360076</td>\n", | |
| " <td>{\"building\":\"203\",\"coord\":[-73.97822040000001,...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1391990400000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"203\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>16</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Ice Cream, Gelato, Yogurt, Ices</td>\n", | |
| " <td>Carvel Ice Cream</td>\n", | |
| " <td>40361322</td>\n", | |
| " <td>{\"building\":\"265-15\",\"coord\":[-73.7032601,40.7...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1414454400000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"265-15\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>17</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Delicatessen</td>\n", | |
| " <td>Nordic Delicacies</td>\n", | |
| " <td>40361390</td>\n", | |
| " <td>{\"building\":\"6909\",\"coord\":[-74.0259567,40.635...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1408579200000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"6909\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>18</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Glorious Food</td>\n", | |
| " <td>40361521</td>\n", | |
| " <td>{\"building\":\"522\",\"coord\":[-73.95171,40.767461...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1409616000000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"522\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>19</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>American</td>\n", | |
| " <td>The Movable Feast</td>\n", | |
| " <td>40361606</td>\n", | |
| " <td>{\"building\":\"284\",\"coord\":[-73.9829239,40.6580...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1416355200000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"284\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>20</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Delicatessen</td>\n", | |
| " <td>Sal'S Deli</td>\n", | |
| " <td>40361618</td>\n", | |
| " <td>{\"building\":\"129-08\",\"coord\":[-73.839297,40.78...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1408147200000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"129-08\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>21</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Delicatessen</td>\n", | |
| " <td>Bully'S Deli</td>\n", | |
| " <td>40361708</td>\n", | |
| " <td>{\"building\":\"759\",\"coord\":[-73.9925306,40.7309...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1390262400000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"759\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>22</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Delicatessen</td>\n", | |
| " <td>Steve Chu'S Deli & Grocery</td>\n", | |
| " <td>40361998</td>\n", | |
| " <td>{\"building\":\"3406\",\"coord\":[-73.94024739999999...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1395187200000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"3406\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>23</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Chicken</td>\n", | |
| " <td>Harriet'S Kitchen</td>\n", | |
| " <td>40362098</td>\n", | |
| " <td>{\"building\":\"502\",\"coord\":[-73.976112,40.78671...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1410739200000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"502\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>24</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>American</td>\n", | |
| " <td>P & S Deli Grocery</td>\n", | |
| " <td>40362264</td>\n", | |
| " <td>{\"building\":\"730\",\"coord\":[-73.96805719999999,...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1410480000000},\"grade\":\"B\",\"...</td>\n", | |
| " <td>\"730\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Angelika Film Center</td>\n", | |
| " <td>40362274</td>\n", | |
| " <td>{\"building\":\"18\",\"coord\":[-73.996984,40.72589]...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1396483200000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"18\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>26</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Hamburgers</td>\n", | |
| " <td>White Castle</td>\n", | |
| " <td>40362344</td>\n", | |
| " <td>{\"building\":\"531\",\"coord\":[-73.9634876,40.6940...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1395100800000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"531\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>27</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Chinese</td>\n", | |
| " <td>Ho Mei Restaurant</td>\n", | |
| " <td>40362432</td>\n", | |
| " <td>{\"building\":\"103-05\",\"coord\":[-73.8642349,40.7...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1398038400000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"103-05\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>28</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Turkish</td>\n", | |
| " <td>The Country Cafe</td>\n", | |
| " <td>40362715</td>\n", | |
| " <td>{\"building\":\"60\",\"coord\":[-74.0085357,40.70620...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1411689600000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"60\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>29</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Caribbean</td>\n", | |
| " <td>Shashemene Int'L Restaura</td>\n", | |
| " <td>40362869</td>\n", | |
| " <td>{\"building\":\"195\",\"coord\":[-73.9246028,40.6522...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1399939200000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"195\"</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>25329</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Mexican</td>\n", | |
| " <td>Bella'S Place</td>\n", | |
| " <td>41646934</td>\n", | |
| " <td>{\"building\":\"87-77\",\"coord\":[-73.8093635,40.70...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1413417600000},\"grade\":\"Z\",\"...</td>\n", | |
| " <td>\"87-77\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25330</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Caribbean</td>\n", | |
| " <td>Perfect Touch Cuisine Ii</td>\n", | |
| " <td>41646958</td>\n", | |
| " <td>{\"building\":\"1148\",\"coord\":[-73.9508029,40.659...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1409270400000},\"grade\":\"B\",\"...</td>\n", | |
| " <td>\"1148\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25331</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Del Rio Diner</td>\n", | |
| " <td>41646963</td>\n", | |
| " <td>{\"building\":\"166\",\"coord\":[-73.98527659999999,...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1397001600000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"166\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25332</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Chinese</td>\n", | |
| " <td>Fay Da Bakery</td>\n", | |
| " <td>41646967</td>\n", | |
| " <td>{\"building\":\"321\",\"coord\":[-74.0062401,40.7397...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1399852800000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"321\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25333</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Caribbean</td>\n", | |
| " <td>Jahlookova</td>\n", | |
| " <td>41646976</td>\n", | |
| " <td>{\"building\":\"1962\",\"coord\":[-73.9405519,40.806...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1416960000000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"1962\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25334</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Delicatessen</td>\n", | |
| " <td>Merci Market</td>\n", | |
| " <td>41646979</td>\n", | |
| " <td>{\"building\":\"350\",\"coord\":[-73.9922178,40.7579...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1420588800000},\"grade\":\"Z\",\"...</td>\n", | |
| " <td>\"350\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25335</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Caribbean</td>\n", | |
| " <td>Meat Veggies & Pasta Restaurant</td>\n", | |
| " <td>41647006</td>\n", | |
| " <td>{\"building\":\"118-16\",\"coord\":[-73.819531,40.67...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1415577600000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"118-16\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25336</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Toshi'S Living Room</td>\n", | |
| " <td>41647012</td>\n", | |
| " <td>{\"building\":\"9\",\"coord\":[-73.98931019999999,40...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1415750400000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"9\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25337</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Five Lamps Tavern</td>\n", | |
| " <td>41647017</td>\n", | |
| " <td>{\"building\":\"2756\",\"coord\":[-73.9675441,40.800...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1407283200000},\"grade\":\"C\",\"...</td>\n", | |
| " <td>\"2756\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25338</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>German</td>\n", | |
| " <td>Max</td>\n", | |
| " <td>41647039</td>\n", | |
| " <td>{\"building\":\"47-02\",\"coord\":[-73.918047,40.765...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1416355200000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"47-02\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25339</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Chinese</td>\n", | |
| " <td>Liang'S Kitchen Flushing Restaurant</td>\n", | |
| " <td>41647062</td>\n", | |
| " <td>{\"building\":\"13351\",\"coord\":[-73.832828,40.759...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1403308800000},\"grade\":\"B\",\"...</td>\n", | |
| " <td>\"13351\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25340</th>\n", | |
| " <td>Bronx</td>\n", | |
| " <td>Bangladeshi</td>\n", | |
| " <td>Mehman Sweets Restaurant</td>\n", | |
| " <td>41647098</td>\n", | |
| " <td>{\"building\":\"1445\",\"coord\":[-73.8549994,40.835...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1406592000000},\"grade\":\"Z\",\"...</td>\n", | |
| " <td>\"1445\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25341</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Mexican</td>\n", | |
| " <td>Stephanie'S Mexican Bakery</td>\n", | |
| " <td>41647129</td>\n", | |
| " <td>{\"building\":\"37-56\",\"coord\":[-73.860018,40.752...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1408406400000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"37-56\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25342</th>\n", | |
| " <td>Bronx</td>\n", | |
| " <td>Bakery</td>\n", | |
| " <td>Bibbies Bakery</td>\n", | |
| " <td>41647169</td>\n", | |
| " <td>{\"building\":\"262\",\"coord\":[-73.9111954,40.8615...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1399507200000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"262\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25343</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Thai</td>\n", | |
| " <td>Jaiya Thai & Oriental Restaurant</td>\n", | |
| " <td>41647176</td>\n", | |
| " <td>{\"building\":\"1553\",\"coord\":[-73.954548,40.7745...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1414540800000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"1553\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25344</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Chinese</td>\n", | |
| " <td>China Wok</td>\n", | |
| " <td>41647181</td>\n", | |
| " <td>{\"building\":\"199\",\"coord\":[-73.9831015,40.7228...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1408060800000},\"grade\":\"B\",\"...</td>\n", | |
| " <td>\"199\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25345</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Chinese</td>\n", | |
| " <td>Xing Xing Chinese Restaurant</td>\n", | |
| " <td>41647183</td>\n", | |
| " <td>{\"building\":\"9712\",\"coord\":[-73.8194803,40.584...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1398729600000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"9712\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25346</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Packard Cafe</td>\n", | |
| " <td>41647192</td>\n", | |
| " <td>{\"building\":\"4134\",\"coord\":[-73.9400398,40.751...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1421193600000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"4134\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25347</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Pizza</td>\n", | |
| " <td>Springfield & La Bari Pizzeria</td>\n", | |
| " <td>41647210</td>\n", | |
| " <td>{\"building\":\"136-13\",\"coord\":[-73.763352,40.67...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1419984000000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"136-13\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25348</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Caribbean</td>\n", | |
| " <td>Dee'S Catering Services</td>\n", | |
| " <td>41647221</td>\n", | |
| " <td>{\"building\":\"217-15\",\"coord\":[-73.737423999999...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1401840000000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"217-15\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25349</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Asian</td>\n", | |
| " <td>Jack'S Sliders And Sushi</td>\n", | |
| " <td>41647241</td>\n", | |
| " <td>{\"building\":\"171\",\"coord\":[-73.98581899999999,...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1417564800000},\"grade\":\"B\",\"...</td>\n", | |
| " <td>\"171\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25350</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Chinese</td>\n", | |
| " <td>New Ming Fat Chinese Restaurant</td>\n", | |
| " <td>41647292</td>\n", | |
| " <td>{\"building\":\"1155\",\"coord\":[-73.8753401,40.672...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1394496000000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"1155\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25351</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Chinese</td>\n", | |
| " <td>Noodle House</td>\n", | |
| " <td>41647360</td>\n", | |
| " <td>{\"building\":\"56-09\",\"coord\":[-73.7315557,40.76...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1404259200000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"56-09\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25352</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Middle Eastern</td>\n", | |
| " <td>Bahary Fish Market</td>\n", | |
| " <td>41647370</td>\n", | |
| " <td>{\"building\":\"484\",\"coord\":[-74.0212854,40.6334...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1401840000000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"484\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25353</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>American</td>\n", | |
| " <td>The Tin House Tavern</td>\n", | |
| " <td>41647380</td>\n", | |
| " <td>{\"building\":\"195-02\",\"coord\":[-73.785758,40.75...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1410134400000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"195-02\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25354</th>\n", | |
| " <td>Staten Island</td>\n", | |
| " <td>Pizza</td>\n", | |
| " <td>Ambrosino'S Ii</td>\n", | |
| " <td>41647384</td>\n", | |
| " <td>{\"building\":\"6410\",\"coord\":[-74.2150624,40.521...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1409616000000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"6410\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25355</th>\n", | |
| " <td>Bronx</td>\n", | |
| " <td>Soul Food</td>\n", | |
| " <td>Bruce'S Fish And Chips</td>\n", | |
| " <td>41647392</td>\n", | |
| " <td>{\"building\":\"500\",\"coord\":[-73.890768,40.85709...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1403568000000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"500\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25356</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Café/Coffee/Tea</td>\n", | |
| " <td>Coffee Bean Tea & Leaf</td>\n", | |
| " <td>41647399</td>\n", | |
| " <td>{\"building\":\"2169\",\"coord\":[-73.981231,40.7822...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1406592000000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"2169\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25357</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Ice Cream, Gelato, Yogurt, Ices</td>\n", | |
| " <td>Gelato Ti Amo</td>\n", | |
| " <td>41647482</td>\n", | |
| " <td>{\"building\":\"68\",\"coord\":[-73.9892179,40.72594...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1403913600000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"68\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25358</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Caribbean</td>\n", | |
| " <td>Rockaway Roti Shop</td>\n", | |
| " <td>41647521</td>\n", | |
| " <td>{\"building\":\"12221\",\"coord\":[-73.8032425999999...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1418428800000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"12221\"</td>\n", | |
| " </tr>\n", | |
| " </tbody>\n", | |
| "</table>\n", | |
| "<p>25359 rows × 7 columns</p>\n", | |
| "</div>" | |
| ], | |
| "text/plain": [ | |
| " borough cuisine \\\n", | |
| "0 Bronx Bakery \n", | |
| "1 Brooklyn Hamburgers \n", | |
| "2 Manhattan Irish \n", | |
| "3 Brooklyn American \n", | |
| "4 Queens Jewish/Kosher \n", | |
| "5 Queens American \n", | |
| "6 Staten Island Jewish/Kosher \n", | |
| "7 Brooklyn Delicatessen \n", | |
| "8 Brooklyn American \n", | |
| "9 Brooklyn Ice Cream, Gelato, Yogurt, Ices \n", | |
| "10 Bronx American \n", | |
| "11 Brooklyn American \n", | |
| "12 Brooklyn Chinese \n", | |
| "13 Manhattan American \n", | |
| "14 Brooklyn Jewish/Kosher \n", | |
| "15 Brooklyn Ice Cream, Gelato, Yogurt, Ices \n", | |
| "16 Queens Ice Cream, Gelato, Yogurt, Ices \n", | |
| "17 Brooklyn Delicatessen \n", | |
| "18 Manhattan American \n", | |
| "19 Brooklyn American \n", | |
| "20 Queens Delicatessen \n", | |
| "21 Manhattan Delicatessen \n", | |
| "22 Queens Delicatessen \n", | |
| "23 Manhattan Chicken \n", | |
| "24 Manhattan American \n", | |
| "25 Manhattan American \n", | |
| "26 Brooklyn Hamburgers \n", | |
| "27 Queens Chinese \n", | |
| "28 Manhattan Turkish \n", | |
| "29 Brooklyn Caribbean \n", | |
| "... ... ... \n", | |
| "25329 Queens Mexican \n", | |
| "25330 Brooklyn Caribbean \n", | |
| "25331 Brooklyn American \n", | |
| "25332 Manhattan Chinese \n", | |
| "25333 Manhattan Caribbean \n", | |
| "25334 Manhattan Delicatessen \n", | |
| "25335 Queens Caribbean \n", | |
| "25336 Manhattan American \n", | |
| "25337 Manhattan American \n", | |
| "25338 Queens German \n", | |
| "25339 Queens Chinese \n", | |
| "25340 Bronx Bangladeshi \n", | |
| "25341 Queens Mexican \n", | |
| "25342 Bronx Bakery \n", | |
| "25343 Manhattan Thai \n", | |
| "25344 Manhattan Chinese \n", | |
| "25345 Queens Chinese \n", | |
| "25346 Queens American \n", | |
| "25347 Queens Pizza \n", | |
| "25348 Queens Caribbean \n", | |
| "25349 Manhattan Asian \n", | |
| "25350 Brooklyn Chinese \n", | |
| "25351 Queens Chinese \n", | |
| "25352 Brooklyn Middle Eastern \n", | |
| "25353 Queens American \n", | |
| "25354 Staten Island Pizza \n", | |
| "25355 Bronx Soul Food \n", | |
| "25356 Manhattan Café/Coffee/Tea \n", | |
| "25357 Manhattan Ice Cream, Gelato, Yogurt, Ices \n", | |
| "25358 Queens Caribbean \n", | |
| "\n", | |
| " name restaurant_id \\\n", | |
| "0 Morris Park Bake Shop 30075445 \n", | |
| "1 Wendy'S 30112340 \n", | |
| "2 Dj Reynolds Pub And Restaurant 30191841 \n", | |
| "3 Riviera Caterer 40356018 \n", | |
| "4 Tov Kosher Kitchen 40356068 \n", | |
| "5 Brunos On The Boulevard 40356151 \n", | |
| "6 Kosher Island 40356442 \n", | |
| "7 Wilken'S Fine Food 40356483 \n", | |
| "8 Regina Caterers 40356649 \n", | |
| "9 Taste The Tropics Ice Cream 40356731 \n", | |
| "10 Wild Asia 40357217 \n", | |
| "11 C & C Catering Service 40357437 \n", | |
| "12 May May Kitchen 40358429 \n", | |
| "13 1 East 66Th Street Kitchen 40359480 \n", | |
| "14 Seuda Foods 40360045 \n", | |
| "15 Carvel Ice Cream 40360076 \n", | |
| "16 Carvel Ice Cream 40361322 \n", | |
| "17 Nordic Delicacies 40361390 \n", | |
| "18 Glorious Food 40361521 \n", | |
| "19 The Movable Feast 40361606 \n", | |
| "20 Sal'S Deli 40361618 \n", | |
| "21 Bully'S Deli 40361708 \n", | |
| "22 Steve Chu'S Deli & Grocery 40361998 \n", | |
| "23 Harriet'S Kitchen 40362098 \n", | |
| "24 P & S Deli Grocery 40362264 \n", | |
| "25 Angelika Film Center 40362274 \n", | |
| "26 White Castle 40362344 \n", | |
| "27 Ho Mei Restaurant 40362432 \n", | |
| "28 The Country Cafe 40362715 \n", | |
| "29 Shashemene Int'L Restaura 40362869 \n", | |
| "... ... ... \n", | |
| "25329 Bella'S Place 41646934 \n", | |
| "25330 Perfect Touch Cuisine Ii 41646958 \n", | |
| "25331 Del Rio Diner 41646963 \n", | |
| "25332 Fay Da Bakery 41646967 \n", | |
| "25333 Jahlookova 41646976 \n", | |
| "25334 Merci Market 41646979 \n", | |
| "25335 Meat Veggies & Pasta Restaurant 41647006 \n", | |
| "25336 Toshi'S Living Room 41647012 \n", | |
| "25337 Five Lamps Tavern 41647017 \n", | |
| "25338 Max 41647039 \n", | |
| "25339 Liang'S Kitchen Flushing Restaurant 41647062 \n", | |
| "25340 Mehman Sweets Restaurant 41647098 \n", | |
| "25341 Stephanie'S Mexican Bakery 41647129 \n", | |
| "25342 Bibbies Bakery 41647169 \n", | |
| "25343 Jaiya Thai & Oriental Restaurant 41647176 \n", | |
| "25344 China Wok 41647181 \n", | |
| "25345 Xing Xing Chinese Restaurant 41647183 \n", | |
| "25346 Packard Cafe 41647192 \n", | |
| "25347 Springfield & La Bari Pizzeria 41647210 \n", | |
| "25348 Dee'S Catering Services 41647221 \n", | |
| "25349 Jack'S Sliders And Sushi 41647241 \n", | |
| "25350 New Ming Fat Chinese Restaurant 41647292 \n", | |
| "25351 Noodle House 41647360 \n", | |
| "25352 Bahary Fish Market 41647370 \n", | |
| "25353 The Tin House Tavern 41647380 \n", | |
| "25354 Ambrosino'S Ii 41647384 \n", | |
| "25355 Bruce'S Fish And Chips 41647392 \n", | |
| "25356 Coffee Bean Tea & Leaf 41647399 \n", | |
| "25357 Gelato Ti Amo 41647482 \n", | |
| "25358 Rockaway Roti Shop 41647521 \n", | |
| "\n", | |
| " address_json \\\n", | |
| "0 {\"building\":\"1007\",\"coord\":[-73.856077,40.8484... \n", | |
| "1 {\"building\":\"469\",\"coord\":[-73.961704,40.66294... \n", | |
| "2 {\"building\":\"351\",\"coord\":[-73.98513559999999,... \n", | |
| "3 {\"building\":\"2780\",\"coord\":[-73.98241999999999... \n", | |
| "4 {\"building\":\"97-22\",\"coord\":[-73.8601152,40.73... \n", | |
| "5 {\"building\":\"8825\",\"coord\":[-73.8803827,40.764... \n", | |
| "6 {\"building\":\"2206\",\"coord\":[-74.1377286,40.611... \n", | |
| "7 {\"building\":\"7114\",\"coord\":[-73.9068506,40.619... \n", | |
| "8 {\"building\":\"6409\",\"coord\":[-74.00528899999999... \n", | |
| "9 {\"building\":\"1839\",\"coord\":[-73.9482609,40.640... \n", | |
| "10 {\"building\":\"2300\",\"coord\":[-73.8786113,40.850... \n", | |
| "11 {\"building\":\"7715\",\"coord\":[-73.9973325,40.611... \n", | |
| "12 {\"building\":\"1269\",\"coord\":[-73.871194,40.6730... \n", | |
| "13 {\"building\":\"1\",\"coord\":[-73.96926909999999,40... \n", | |
| "14 {\"building\":\"705\",\"coord\":[-73.9653967,40.6064... \n", | |
| "15 {\"building\":\"203\",\"coord\":[-73.97822040000001,... \n", | |
| "16 {\"building\":\"265-15\",\"coord\":[-73.7032601,40.7... \n", | |
| "17 {\"building\":\"6909\",\"coord\":[-74.0259567,40.635... \n", | |
| "18 {\"building\":\"522\",\"coord\":[-73.95171,40.767461... \n", | |
| "19 {\"building\":\"284\",\"coord\":[-73.9829239,40.6580... \n", | |
| "20 {\"building\":\"129-08\",\"coord\":[-73.839297,40.78... \n", | |
| "21 {\"building\":\"759\",\"coord\":[-73.9925306,40.7309... \n", | |
| "22 {\"building\":\"3406\",\"coord\":[-73.94024739999999... \n", | |
| "23 {\"building\":\"502\",\"coord\":[-73.976112,40.78671... \n", | |
| "24 {\"building\":\"730\",\"coord\":[-73.96805719999999,... \n", | |
| "25 {\"building\":\"18\",\"coord\":[-73.996984,40.72589]... \n", | |
| "26 {\"building\":\"531\",\"coord\":[-73.9634876,40.6940... \n", | |
| "27 {\"building\":\"103-05\",\"coord\":[-73.8642349,40.7... \n", | |
| "28 {\"building\":\"60\",\"coord\":[-74.0085357,40.70620... \n", | |
| "29 {\"building\":\"195\",\"coord\":[-73.9246028,40.6522... \n", | |
| "... ... \n", | |
| "25329 {\"building\":\"87-77\",\"coord\":[-73.8093635,40.70... \n", | |
| "25330 {\"building\":\"1148\",\"coord\":[-73.9508029,40.659... \n", | |
| "25331 {\"building\":\"166\",\"coord\":[-73.98527659999999,... \n", | |
| "25332 {\"building\":\"321\",\"coord\":[-74.0062401,40.7397... \n", | |
| "25333 {\"building\":\"1962\",\"coord\":[-73.9405519,40.806... \n", | |
| "25334 {\"building\":\"350\",\"coord\":[-73.9922178,40.7579... \n", | |
| "25335 {\"building\":\"118-16\",\"coord\":[-73.819531,40.67... \n", | |
| "25336 {\"building\":\"9\",\"coord\":[-73.98931019999999,40... \n", | |
| "25337 {\"building\":\"2756\",\"coord\":[-73.9675441,40.800... \n", | |
| "25338 {\"building\":\"47-02\",\"coord\":[-73.918047,40.765... \n", | |
| "25339 {\"building\":\"13351\",\"coord\":[-73.832828,40.759... \n", | |
| "25340 {\"building\":\"1445\",\"coord\":[-73.8549994,40.835... \n", | |
| "25341 {\"building\":\"37-56\",\"coord\":[-73.860018,40.752... \n", | |
| "25342 {\"building\":\"262\",\"coord\":[-73.9111954,40.8615... \n", | |
| "25343 {\"building\":\"1553\",\"coord\":[-73.954548,40.7745... \n", | |
| "25344 {\"building\":\"199\",\"coord\":[-73.9831015,40.7228... \n", | |
| "25345 {\"building\":\"9712\",\"coord\":[-73.8194803,40.584... \n", | |
| "25346 {\"building\":\"4134\",\"coord\":[-73.9400398,40.751... \n", | |
| "25347 {\"building\":\"136-13\",\"coord\":[-73.763352,40.67... \n", | |
| "25348 {\"building\":\"217-15\",\"coord\":[-73.737423999999... \n", | |
| "25349 {\"building\":\"171\",\"coord\":[-73.98581899999999,... \n", | |
| "25350 {\"building\":\"1155\",\"coord\":[-73.8753401,40.672... \n", | |
| "25351 {\"building\":\"56-09\",\"coord\":[-73.7315557,40.76... \n", | |
| "25352 {\"building\":\"484\",\"coord\":[-74.0212854,40.6334... \n", | |
| "25353 {\"building\":\"195-02\",\"coord\":[-73.785758,40.75... \n", | |
| "25354 {\"building\":\"6410\",\"coord\":[-74.2150624,40.521... \n", | |
| "25355 {\"building\":\"500\",\"coord\":[-73.890768,40.85709... \n", | |
| "25356 {\"building\":\"2169\",\"coord\":[-73.981231,40.7822... \n", | |
| "25357 {\"building\":\"68\",\"coord\":[-73.9892179,40.72594... \n", | |
| "25358 {\"building\":\"12221\",\"coord\":[-73.8032425999999... \n", | |
| "\n", | |
| " grades_json building \n", | |
| "0 [{\"date\":{\"$date\":1393804800000},\"grade\":\"A\",\"... \"1007\" \n", | |
| "1 [{\"date\":{\"$date\":1419897600000},\"grade\":\"A\",\"... \"469\" \n", | |
| "2 [{\"date\":{\"$date\":1409961600000},\"grade\":\"A\",\"... \"351\" \n", | |
| "3 [{\"date\":{\"$date\":1402358400000},\"grade\":\"A\",\"... \"2780\" \n", | |
| "4 [{\"date\":{\"$date\":1416787200000},\"grade\":\"Z\",\"... \"97-22\" \n", | |
| "5 [{\"date\":{\"$date\":1416009600000},\"grade\":\"Z\",\"... \"8825\" \n", | |
| "6 [{\"date\":{\"$date\":1412553600000},\"grade\":\"A\",\"... \"2206\" \n", | |
| "7 [{\"date\":{\"$date\":1401321600000},\"grade\":\"A\",\"... \"7114\" \n", | |
| "8 [{\"date\":{\"$date\":1405641600000},\"grade\":\"A\",\"... \"6409\" \n", | |
| "9 [{\"date\":{\"$date\":1405296000000},\"grade\":\"A\",\"... \"1839\" \n", | |
| "10 [{\"date\":{\"$date\":1401235200000},\"grade\":\"A\",\"... \"2300\" \n", | |
| "11 [{\"date\":{\"$date\":1397606400000},\"grade\":\"A\",\"... \"7715\" \n", | |
| "12 [{\"date\":{\"$date\":1410825600000},\"grade\":\"B\",\"... \"1269\" \n", | |
| "13 [{\"date\":{\"$date\":1399420800000},\"grade\":\"A\",\"... \"1\" \n", | |
| "14 [{\"date\":{\"$date\":1415577600000},\"grade\":\"A\",\"... \"705\" \n", | |
| "15 [{\"date\":{\"$date\":1391990400000},\"grade\":\"A\",\"... \"203\" \n", | |
| "16 [{\"date\":{\"$date\":1414454400000},\"grade\":\"A\",\"... \"265-15\" \n", | |
| "17 [{\"date\":{\"$date\":1408579200000},\"grade\":\"A\",\"... \"6909\" \n", | |
| "18 [{\"date\":{\"$date\":1409616000000},\"grade\":\"A\",\"... \"522\" \n", | |
| "19 [{\"date\":{\"$date\":1416355200000},\"grade\":\"A\",\"... \"284\" \n", | |
| "20 [{\"date\":{\"$date\":1408147200000},\"grade\":\"A\",\"... \"129-08\" \n", | |
| "21 [{\"date\":{\"$date\":1390262400000},\"grade\":\"A\",\"... \"759\" \n", | |
| "22 [{\"date\":{\"$date\":1395187200000},\"grade\":\"A\",\"... \"3406\" \n", | |
| "23 [{\"date\":{\"$date\":1410739200000},\"grade\":\"A\",\"... \"502\" \n", | |
| "24 [{\"date\":{\"$date\":1410480000000},\"grade\":\"B\",\"... \"730\" \n", | |
| "25 [{\"date\":{\"$date\":1396483200000},\"grade\":\"A\",\"... \"18\" \n", | |
| "26 [{\"date\":{\"$date\":1395100800000},\"grade\":\"A\",\"... \"531\" \n", | |
| "27 [{\"date\":{\"$date\":1398038400000},\"grade\":\"A\",\"... \"103-05\" \n", | |
| "28 [{\"date\":{\"$date\":1411689600000},\"grade\":\"A\",\"... \"60\" \n", | |
| "29 [{\"date\":{\"$date\":1399939200000},\"grade\":\"A\",\"... \"195\" \n", | |
| "... ... ... \n", | |
| "25329 [{\"date\":{\"$date\":1413417600000},\"grade\":\"Z\",\"... \"87-77\" \n", | |
| "25330 [{\"date\":{\"$date\":1409270400000},\"grade\":\"B\",\"... \"1148\" \n", | |
| "25331 [{\"date\":{\"$date\":1397001600000},\"grade\":\"A\",\"... \"166\" \n", | |
| "25332 [{\"date\":{\"$date\":1399852800000},\"grade\":\"A\",\"... \"321\" \n", | |
| "25333 [{\"date\":{\"$date\":1416960000000},\"grade\":\"A\",\"... \"1962\" \n", | |
| "25334 [{\"date\":{\"$date\":1420588800000},\"grade\":\"Z\",\"... \"350\" \n", | |
| "25335 [{\"date\":{\"$date\":1415577600000},\"grade\":\"A\",\"... \"118-16\" \n", | |
| "25336 [{\"date\":{\"$date\":1415750400000},\"grade\":\"A\",\"... \"9\" \n", | |
| "25337 [{\"date\":{\"$date\":1407283200000},\"grade\":\"C\",\"... \"2756\" \n", | |
| "25338 [{\"date\":{\"$date\":1416355200000},\"grade\":\"A\",\"... \"47-02\" \n", | |
| "25339 [{\"date\":{\"$date\":1403308800000},\"grade\":\"B\",\"... \"13351\" \n", | |
| "25340 [{\"date\":{\"$date\":1406592000000},\"grade\":\"Z\",\"... \"1445\" \n", | |
| "25341 [{\"date\":{\"$date\":1408406400000},\"grade\":\"A\",\"... \"37-56\" \n", | |
| "25342 [{\"date\":{\"$date\":1399507200000},\"grade\":\"A\",\"... \"262\" \n", | |
| "25343 [{\"date\":{\"$date\":1414540800000},\"grade\":\"A\",\"... \"1553\" \n", | |
| "25344 [{\"date\":{\"$date\":1408060800000},\"grade\":\"B\",\"... \"199\" \n", | |
| "25345 [{\"date\":{\"$date\":1398729600000},\"grade\":\"A\",\"... \"9712\" \n", | |
| "25346 [{\"date\":{\"$date\":1421193600000},\"grade\":\"A\",\"... \"4134\" \n", | |
| "25347 [{\"date\":{\"$date\":1419984000000},\"grade\":\"A\",\"... \"136-13\" \n", | |
| "25348 [{\"date\":{\"$date\":1401840000000},\"grade\":\"A\",\"... \"217-15\" \n", | |
| "25349 [{\"date\":{\"$date\":1417564800000},\"grade\":\"B\",\"... \"171\" \n", | |
| "25350 [{\"date\":{\"$date\":1394496000000},\"grade\":\"A\",\"... \"1155\" \n", | |
| "25351 [{\"date\":{\"$date\":1404259200000},\"grade\":\"A\",\"... \"56-09\" \n", | |
| "25352 [{\"date\":{\"$date\":1401840000000},\"grade\":\"A\",\"... \"484\" \n", | |
| "25353 [{\"date\":{\"$date\":1410134400000},\"grade\":\"A\",\"... \"195-02\" \n", | |
| "25354 [{\"date\":{\"$date\":1409616000000},\"grade\":\"A\",\"... \"6410\" \n", | |
| "25355 [{\"date\":{\"$date\":1403568000000},\"grade\":\"A\",\"... \"500\" \n", | |
| "25356 [{\"date\":{\"$date\":1406592000000},\"grade\":\"A\",\"... \"2169\" \n", | |
| "25357 [{\"date\":{\"$date\":1403913600000},\"grade\":\"A\",\"... \"68\" \n", | |
| "25358 [{\"date\":{\"$date\":1418428800000},\"grade\":\"A\",\"... \"12221\" \n", | |
| "\n", | |
| "[25359 rows x 7 columns]" | |
| ] | |
| }, | |
| "execution_count": 5, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "read_test_with_query.toPandas()" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 21, | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "data": { | |
| "text/html": [ | |
| "<div>\n", | |
| "<style>\n", | |
| " .dataframe thead tr:only-child th {\n", | |
| " text-align: right;\n", | |
| " }\n", | |
| "\n", | |
| " .dataframe thead th {\n", | |
| " text-align: left;\n", | |
| " }\n", | |
| "\n", | |
| " .dataframe tbody tr th {\n", | |
| " vertical-align: top;\n", | |
| " }\n", | |
| "</style>\n", | |
| "<table border=\"1\" class=\"dataframe\">\n", | |
| " <thead>\n", | |
| " <tr style=\"text-align: right;\">\n", | |
| " <th></th>\n", | |
| " <th>borough</th>\n", | |
| " <th>cuisine</th>\n", | |
| " <th>name</th>\n", | |
| " <th>restaurant_id</th>\n", | |
| " <th>address_json</th>\n", | |
| " <th>grades_json</th>\n", | |
| " <th>building</th>\n", | |
| " </tr>\n", | |
| " </thead>\n", | |
| " <tbody>\n", | |
| " <tr>\n", | |
| " <th>0</th>\n", | |
| " <td>Bronx</td>\n", | |
| " <td>Bakery</td>\n", | |
| " <td>Morris Park Bake Shop</td>\n", | |
| " <td>30075445</td>\n", | |
| " <td>{\"building\":\"1007\",\"coord\":[-73.856077,40.8484...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1393804800000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"1007\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Hamburgers</td>\n", | |
| " <td>Wendy'S</td>\n", | |
| " <td>30112340</td>\n", | |
| " <td>{\"building\":\"469\",\"coord\":[-73.961704,40.66294...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1419897600000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"469\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Irish</td>\n", | |
| " <td>Dj Reynolds Pub And Restaurant</td>\n", | |
| " <td>30191841</td>\n", | |
| " <td>{\"building\":\"351\",\"coord\":[-73.98513559999999,...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1409961600000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"351\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>3</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Riviera Caterer</td>\n", | |
| " <td>40356018</td>\n", | |
| " <td>{\"building\":\"2780\",\"coord\":[-73.98241999999999...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1402358400000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"2780\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>4</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Jewish/Kosher</td>\n", | |
| " <td>Tov Kosher Kitchen</td>\n", | |
| " <td>40356068</td>\n", | |
| " <td>{\"building\":\"97-22\",\"coord\":[-73.8601152,40.73...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1416787200000},\"grade\":\"Z\",\"...</td>\n", | |
| " <td>\"97-22\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>5</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Brunos On The Boulevard</td>\n", | |
| " <td>40356151</td>\n", | |
| " <td>{\"building\":\"8825\",\"coord\":[-73.8803827,40.764...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1416009600000},\"grade\":\"Z\",\"...</td>\n", | |
| " <td>\"8825\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>6</th>\n", | |
| " <td>Staten Island</td>\n", | |
| " <td>Jewish/Kosher</td>\n", | |
| " <td>Kosher Island</td>\n", | |
| " <td>40356442</td>\n", | |
| " <td>{\"building\":\"2206\",\"coord\":[-74.1377286,40.611...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1412553600000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"2206\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>7</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Delicatessen</td>\n", | |
| " <td>Wilken'S Fine Food</td>\n", | |
| " <td>40356483</td>\n", | |
| " <td>{\"building\":\"7114\",\"coord\":[-73.9068506,40.619...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1401321600000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"7114\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>8</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Regina Caterers</td>\n", | |
| " <td>40356649</td>\n", | |
| " <td>{\"building\":\"6409\",\"coord\":[-74.00528899999999...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1405641600000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"6409\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>9</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Ice Cream, Gelato, Yogurt, Ices</td>\n", | |
| " <td>Taste The Tropics Ice Cream</td>\n", | |
| " <td>40356731</td>\n", | |
| " <td>{\"building\":\"1839\",\"coord\":[-73.9482609,40.640...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1405296000000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"1839\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>10</th>\n", | |
| " <td>Bronx</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Wild Asia</td>\n", | |
| " <td>40357217</td>\n", | |
| " <td>{\"building\":\"2300\",\"coord\":[-73.8786113,40.850...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1401235200000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"2300\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>11</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>American</td>\n", | |
| " <td>C & C Catering Service</td>\n", | |
| " <td>40357437</td>\n", | |
| " <td>{\"building\":\"7715\",\"coord\":[-73.9973325,40.611...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1397606400000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"7715\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>12</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Chinese</td>\n", | |
| " <td>May May Kitchen</td>\n", | |
| " <td>40358429</td>\n", | |
| " <td>{\"building\":\"1269\",\"coord\":[-73.871194,40.6730...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1410825600000},\"grade\":\"B\",\"...</td>\n", | |
| " <td>\"1269\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>13</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>American</td>\n", | |
| " <td>1 East 66Th Street Kitchen</td>\n", | |
| " <td>40359480</td>\n", | |
| " <td>{\"building\":\"1\",\"coord\":[-73.96926909999999,40...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1399420800000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"1\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>14</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Jewish/Kosher</td>\n", | |
| " <td>Seuda Foods</td>\n", | |
| " <td>40360045</td>\n", | |
| " <td>{\"building\":\"705\",\"coord\":[-73.9653967,40.6064...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1415577600000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"705\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>15</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Ice Cream, Gelato, Yogurt, Ices</td>\n", | |
| " <td>Carvel Ice Cream</td>\n", | |
| " <td>40360076</td>\n", | |
| " <td>{\"building\":\"203\",\"coord\":[-73.97822040000001,...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1391990400000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"203\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>16</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Ice Cream, Gelato, Yogurt, Ices</td>\n", | |
| " <td>Carvel Ice Cream</td>\n", | |
| " <td>40361322</td>\n", | |
| " <td>{\"building\":\"265-15\",\"coord\":[-73.7032601,40.7...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1414454400000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"265-15\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>17</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Delicatessen</td>\n", | |
| " <td>Nordic Delicacies</td>\n", | |
| " <td>40361390</td>\n", | |
| " <td>{\"building\":\"6909\",\"coord\":[-74.0259567,40.635...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1408579200000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"6909\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>18</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Glorious Food</td>\n", | |
| " <td>40361521</td>\n", | |
| " <td>{\"building\":\"522\",\"coord\":[-73.95171,40.767461...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1409616000000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"522\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>19</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>American</td>\n", | |
| " <td>The Movable Feast</td>\n", | |
| " <td>40361606</td>\n", | |
| " <td>{\"building\":\"284\",\"coord\":[-73.9829239,40.6580...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1416355200000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"284\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>20</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Delicatessen</td>\n", | |
| " <td>Sal'S Deli</td>\n", | |
| " <td>40361618</td>\n", | |
| " <td>{\"building\":\"129-08\",\"coord\":[-73.839297,40.78...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1408147200000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"129-08\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>21</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Delicatessen</td>\n", | |
| " <td>Bully'S Deli</td>\n", | |
| " <td>40361708</td>\n", | |
| " <td>{\"building\":\"759\",\"coord\":[-73.9925306,40.7309...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1390262400000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"759\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>22</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Delicatessen</td>\n", | |
| " <td>Steve Chu'S Deli & Grocery</td>\n", | |
| " <td>40361998</td>\n", | |
| " <td>{\"building\":\"3406\",\"coord\":[-73.94024739999999...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1395187200000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"3406\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>23</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Chicken</td>\n", | |
| " <td>Harriet'S Kitchen</td>\n", | |
| " <td>40362098</td>\n", | |
| " <td>{\"building\":\"502\",\"coord\":[-73.976112,40.78671...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1410739200000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"502\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>24</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>American</td>\n", | |
| " <td>P & S Deli Grocery</td>\n", | |
| " <td>40362264</td>\n", | |
| " <td>{\"building\":\"730\",\"coord\":[-73.96805719999999,...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1410480000000},\"grade\":\"B\",\"...</td>\n", | |
| " <td>\"730\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Angelika Film Center</td>\n", | |
| " <td>40362274</td>\n", | |
| " <td>{\"building\":\"18\",\"coord\":[-73.996984,40.72589]...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1396483200000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"18\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>26</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Hamburgers</td>\n", | |
| " <td>White Castle</td>\n", | |
| " <td>40362344</td>\n", | |
| " <td>{\"building\":\"531\",\"coord\":[-73.9634876,40.6940...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1395100800000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"531\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>27</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Chinese</td>\n", | |
| " <td>Ho Mei Restaurant</td>\n", | |
| " <td>40362432</td>\n", | |
| " <td>{\"building\":\"103-05\",\"coord\":[-73.8642349,40.7...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1398038400000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"103-05\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>28</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Turkish</td>\n", | |
| " <td>The Country Cafe</td>\n", | |
| " <td>40362715</td>\n", | |
| " <td>{\"building\":\"60\",\"coord\":[-74.0085357,40.70620...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1411689600000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"60\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>29</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Caribbean</td>\n", | |
| " <td>Shashemene Int'L Restaura</td>\n", | |
| " <td>40362869</td>\n", | |
| " <td>{\"building\":\"195\",\"coord\":[-73.9246028,40.6522...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1399939200000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"195\"</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>25329</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Mexican</td>\n", | |
| " <td>Bella'S Place</td>\n", | |
| " <td>41646934</td>\n", | |
| " <td>{\"building\":\"87-77\",\"coord\":[-73.8093635,40.70...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1413417600000},\"grade\":\"Z\",\"...</td>\n", | |
| " <td>\"87-77\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25330</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Caribbean</td>\n", | |
| " <td>Perfect Touch Cuisine Ii</td>\n", | |
| " <td>41646958</td>\n", | |
| " <td>{\"building\":\"1148\",\"coord\":[-73.9508029,40.659...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1409270400000},\"grade\":\"B\",\"...</td>\n", | |
| " <td>\"1148\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25331</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Del Rio Diner</td>\n", | |
| " <td>41646963</td>\n", | |
| " <td>{\"building\":\"166\",\"coord\":[-73.98527659999999,...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1397001600000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"166\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25332</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Chinese</td>\n", | |
| " <td>Fay Da Bakery</td>\n", | |
| " <td>41646967</td>\n", | |
| " <td>{\"building\":\"321\",\"coord\":[-74.0062401,40.7397...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1399852800000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"321\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25333</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Caribbean</td>\n", | |
| " <td>Jahlookova</td>\n", | |
| " <td>41646976</td>\n", | |
| " <td>{\"building\":\"1962\",\"coord\":[-73.9405519,40.806...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1416960000000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"1962\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25334</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Delicatessen</td>\n", | |
| " <td>Merci Market</td>\n", | |
| " <td>41646979</td>\n", | |
| " <td>{\"building\":\"350\",\"coord\":[-73.9922178,40.7579...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1420588800000},\"grade\":\"Z\",\"...</td>\n", | |
| " <td>\"350\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25335</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Caribbean</td>\n", | |
| " <td>Meat Veggies & Pasta Restaurant</td>\n", | |
| " <td>41647006</td>\n", | |
| " <td>{\"building\":\"118-16\",\"coord\":[-73.819531,40.67...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1415577600000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"118-16\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25336</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Toshi'S Living Room</td>\n", | |
| " <td>41647012</td>\n", | |
| " <td>{\"building\":\"9\",\"coord\":[-73.98931019999999,40...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1415750400000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"9\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25337</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Five Lamps Tavern</td>\n", | |
| " <td>41647017</td>\n", | |
| " <td>{\"building\":\"2756\",\"coord\":[-73.9675441,40.800...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1407283200000},\"grade\":\"C\",\"...</td>\n", | |
| " <td>\"2756\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25338</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>German</td>\n", | |
| " <td>Max</td>\n", | |
| " <td>41647039</td>\n", | |
| " <td>{\"building\":\"47-02\",\"coord\":[-73.918047,40.765...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1416355200000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"47-02\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25339</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Chinese</td>\n", | |
| " <td>Liang'S Kitchen Flushing Restaurant</td>\n", | |
| " <td>41647062</td>\n", | |
| " <td>{\"building\":\"13351\",\"coord\":[-73.832828,40.759...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1403308800000},\"grade\":\"B\",\"...</td>\n", | |
| " <td>\"13351\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25340</th>\n", | |
| " <td>Bronx</td>\n", | |
| " <td>Bangladeshi</td>\n", | |
| " <td>Mehman Sweets Restaurant</td>\n", | |
| " <td>41647098</td>\n", | |
| " <td>{\"building\":\"1445\",\"coord\":[-73.8549994,40.835...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1406592000000},\"grade\":\"Z\",\"...</td>\n", | |
| " <td>\"1445\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25341</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Mexican</td>\n", | |
| " <td>Stephanie'S Mexican Bakery</td>\n", | |
| " <td>41647129</td>\n", | |
| " <td>{\"building\":\"37-56\",\"coord\":[-73.860018,40.752...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1408406400000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"37-56\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25342</th>\n", | |
| " <td>Bronx</td>\n", | |
| " <td>Bakery</td>\n", | |
| " <td>Bibbies Bakery</td>\n", | |
| " <td>41647169</td>\n", | |
| " <td>{\"building\":\"262\",\"coord\":[-73.9111954,40.8615...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1399507200000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"262\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25343</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Thai</td>\n", | |
| " <td>Jaiya Thai & Oriental Restaurant</td>\n", | |
| " <td>41647176</td>\n", | |
| " <td>{\"building\":\"1553\",\"coord\":[-73.954548,40.7745...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1414540800000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"1553\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25344</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Chinese</td>\n", | |
| " <td>China Wok</td>\n", | |
| " <td>41647181</td>\n", | |
| " <td>{\"building\":\"199\",\"coord\":[-73.9831015,40.7228...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1408060800000},\"grade\":\"B\",\"...</td>\n", | |
| " <td>\"199\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25345</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Chinese</td>\n", | |
| " <td>Xing Xing Chinese Restaurant</td>\n", | |
| " <td>41647183</td>\n", | |
| " <td>{\"building\":\"9712\",\"coord\":[-73.8194803,40.584...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1398729600000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"9712\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25346</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>American</td>\n", | |
| " <td>Packard Cafe</td>\n", | |
| " <td>41647192</td>\n", | |
| " <td>{\"building\":\"4134\",\"coord\":[-73.9400398,40.751...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1421193600000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"4134\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25347</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Pizza</td>\n", | |
| " <td>Springfield & La Bari Pizzeria</td>\n", | |
| " <td>41647210</td>\n", | |
| " <td>{\"building\":\"136-13\",\"coord\":[-73.763352,40.67...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1419984000000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"136-13\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25348</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Caribbean</td>\n", | |
| " <td>Dee'S Catering Services</td>\n", | |
| " <td>41647221</td>\n", | |
| " <td>{\"building\":\"217-15\",\"coord\":[-73.737423999999...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1401840000000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"217-15\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25349</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Asian</td>\n", | |
| " <td>Jack'S Sliders And Sushi</td>\n", | |
| " <td>41647241</td>\n", | |
| " <td>{\"building\":\"171\",\"coord\":[-73.98581899999999,...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1417564800000},\"grade\":\"B\",\"...</td>\n", | |
| " <td>\"171\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25350</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Chinese</td>\n", | |
| " <td>New Ming Fat Chinese Restaurant</td>\n", | |
| " <td>41647292</td>\n", | |
| " <td>{\"building\":\"1155\",\"coord\":[-73.8753401,40.672...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1394496000000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"1155\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25351</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Chinese</td>\n", | |
| " <td>Noodle House</td>\n", | |
| " <td>41647360</td>\n", | |
| " <td>{\"building\":\"56-09\",\"coord\":[-73.7315557,40.76...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1404259200000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"56-09\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25352</th>\n", | |
| " <td>Brooklyn</td>\n", | |
| " <td>Middle Eastern</td>\n", | |
| " <td>Bahary Fish Market</td>\n", | |
| " <td>41647370</td>\n", | |
| " <td>{\"building\":\"484\",\"coord\":[-74.0212854,40.6334...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1401840000000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"484\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25353</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>American</td>\n", | |
| " <td>The Tin House Tavern</td>\n", | |
| " <td>41647380</td>\n", | |
| " <td>{\"building\":\"195-02\",\"coord\":[-73.785758,40.75...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1410134400000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"195-02\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25354</th>\n", | |
| " <td>Staten Island</td>\n", | |
| " <td>Pizza</td>\n", | |
| " <td>Ambrosino'S Ii</td>\n", | |
| " <td>41647384</td>\n", | |
| " <td>{\"building\":\"6410\",\"coord\":[-74.2150624,40.521...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1409616000000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"6410\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25355</th>\n", | |
| " <td>Bronx</td>\n", | |
| " <td>Soul Food</td>\n", | |
| " <td>Bruce'S Fish And Chips</td>\n", | |
| " <td>41647392</td>\n", | |
| " <td>{\"building\":\"500\",\"coord\":[-73.890768,40.85709...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1403568000000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"500\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25356</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Café/Coffee/Tea</td>\n", | |
| " <td>Coffee Bean Tea & Leaf</td>\n", | |
| " <td>41647399</td>\n", | |
| " <td>{\"building\":\"2169\",\"coord\":[-73.981231,40.7822...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1406592000000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"2169\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25357</th>\n", | |
| " <td>Manhattan</td>\n", | |
| " <td>Ice Cream, Gelato, Yogurt, Ices</td>\n", | |
| " <td>Gelato Ti Amo</td>\n", | |
| " <td>41647482</td>\n", | |
| " <td>{\"building\":\"68\",\"coord\":[-73.9892179,40.72594...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1403913600000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"68\"</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25358</th>\n", | |
| " <td>Queens</td>\n", | |
| " <td>Caribbean</td>\n", | |
| " <td>Rockaway Roti Shop</td>\n", | |
| " <td>41647521</td>\n", | |
| " <td>{\"building\":\"12221\",\"coord\":[-73.8032425999999...</td>\n", | |
| " <td>[{\"date\":{\"$date\":1418428800000},\"grade\":\"A\",\"...</td>\n", | |
| " <td>\"12221\"</td>\n", | |
| " </tr>\n", | |
| " </tbody>\n", | |
| "</table>\n", | |
| "<p>25359 rows × 7 columns</p>\n", | |
| "</div>" | |
| ], | |
| "text/plain": [ | |
| " borough cuisine \\\n", | |
| "0 Bronx Bakery \n", | |
| "1 Brooklyn Hamburgers \n", | |
| "2 Manhattan Irish \n", | |
| "3 Brooklyn American \n", | |
| "4 Queens Jewish/Kosher \n", | |
| "5 Queens American \n", | |
| "6 Staten Island Jewish/Kosher \n", | |
| "7 Brooklyn Delicatessen \n", | |
| "8 Brooklyn American \n", | |
| "9 Brooklyn Ice Cream, Gelato, Yogurt, Ices \n", | |
| "10 Bronx American \n", | |
| "11 Brooklyn American \n", | |
| "12 Brooklyn Chinese \n", | |
| "13 Manhattan American \n", | |
| "14 Brooklyn Jewish/Kosher \n", | |
| "15 Brooklyn Ice Cream, Gelato, Yogurt, Ices \n", | |
| "16 Queens Ice Cream, Gelato, Yogurt, Ices \n", | |
| "17 Brooklyn Delicatessen \n", | |
| "18 Manhattan American \n", | |
| "19 Brooklyn American \n", | |
| "20 Queens Delicatessen \n", | |
| "21 Manhattan Delicatessen \n", | |
| "22 Queens Delicatessen \n", | |
| "23 Manhattan Chicken \n", | |
| "24 Manhattan American \n", | |
| "25 Manhattan American \n", | |
| "26 Brooklyn Hamburgers \n", | |
| "27 Queens Chinese \n", | |
| "28 Manhattan Turkish \n", | |
| "29 Brooklyn Caribbean \n", | |
| "... ... ... \n", | |
| "25329 Queens Mexican \n", | |
| "25330 Brooklyn Caribbean \n", | |
| "25331 Brooklyn American \n", | |
| "25332 Manhattan Chinese \n", | |
| "25333 Manhattan Caribbean \n", | |
| "25334 Manhattan Delicatessen \n", | |
| "25335 Queens Caribbean \n", | |
| "25336 Manhattan American \n", | |
| "25337 Manhattan American \n", | |
| "25338 Queens German \n", | |
| "25339 Queens Chinese \n", | |
| "25340 Bronx Bangladeshi \n", | |
| "25341 Queens Mexican \n", | |
| "25342 Bronx Bakery \n", | |
| "25343 Manhattan Thai \n", | |
| "25344 Manhattan Chinese \n", | |
| "25345 Queens Chinese \n", | |
| "25346 Queens American \n", | |
| "25347 Queens Pizza \n", | |
| "25348 Queens Caribbean \n", | |
| "25349 Manhattan Asian \n", | |
| "25350 Brooklyn Chinese \n", | |
| "25351 Queens Chinese \n", | |
| "25352 Brooklyn Middle Eastern \n", | |
| "25353 Queens American \n", | |
| "25354 Staten Island Pizza \n", | |
| "25355 Bronx Soul Food \n", | |
| "25356 Manhattan Café/Coffee/Tea \n", | |
| "25357 Manhattan Ice Cream, Gelato, Yogurt, Ices \n", | |
| "25358 Queens Caribbean \n", | |
| "\n", | |
| " name restaurant_id \\\n", | |
| "0 Morris Park Bake Shop 30075445 \n", | |
| "1 Wendy'S 30112340 \n", | |
| "2 Dj Reynolds Pub And Restaurant 30191841 \n", | |
| "3 Riviera Caterer 40356018 \n", | |
| "4 Tov Kosher Kitchen 40356068 \n", | |
| "5 Brunos On The Boulevard 40356151 \n", | |
| "6 Kosher Island 40356442 \n", | |
| "7 Wilken'S Fine Food 40356483 \n", | |
| "8 Regina Caterers 40356649 \n", | |
| "9 Taste The Tropics Ice Cream 40356731 \n", | |
| "10 Wild Asia 40357217 \n", | |
| "11 C & C Catering Service 40357437 \n", | |
| "12 May May Kitchen 40358429 \n", | |
| "13 1 East 66Th Street Kitchen 40359480 \n", | |
| "14 Seuda Foods 40360045 \n", | |
| "15 Carvel Ice Cream 40360076 \n", | |
| "16 Carvel Ice Cream 40361322 \n", | |
| "17 Nordic Delicacies 40361390 \n", | |
| "18 Glorious Food 40361521 \n", | |
| "19 The Movable Feast 40361606 \n", | |
| "20 Sal'S Deli 40361618 \n", | |
| "21 Bully'S Deli 40361708 \n", | |
| "22 Steve Chu'S Deli & Grocery 40361998 \n", | |
| "23 Harriet'S Kitchen 40362098 \n", | |
| "24 P & S Deli Grocery 40362264 \n", | |
| "25 Angelika Film Center 40362274 \n", | |
| "26 White Castle 40362344 \n", | |
| "27 Ho Mei Restaurant 40362432 \n", | |
| "28 The Country Cafe 40362715 \n", | |
| "29 Shashemene Int'L Restaura 40362869 \n", | |
| "... ... ... \n", | |
| "25329 Bella'S Place 41646934 \n", | |
| "25330 Perfect Touch Cuisine Ii 41646958 \n", | |
| "25331 Del Rio Diner 41646963 \n", | |
| "25332 Fay Da Bakery 41646967 \n", | |
| "25333 Jahlookova 41646976 \n", | |
| "25334 Merci Market 41646979 \n", | |
| "25335 Meat Veggies & Pasta Restaurant 41647006 \n", | |
| "25336 Toshi'S Living Room 41647012 \n", | |
| "25337 Five Lamps Tavern 41647017 \n", | |
| "25338 Max 41647039 \n", | |
| "25339 Liang'S Kitchen Flushing Restaurant 41647062 \n", | |
| "25340 Mehman Sweets Restaurant 41647098 \n", | |
| "25341 Stephanie'S Mexican Bakery 41647129 \n", | |
| "25342 Bibbies Bakery 41647169 \n", | |
| "25343 Jaiya Thai & Oriental Restaurant 41647176 \n", | |
| "25344 China Wok 41647181 \n", | |
| "25345 Xing Xing Chinese Restaurant 41647183 \n", | |
| "25346 Packard Cafe 41647192 \n", | |
| "25347 Springfield & La Bari Pizzeria 41647210 \n", | |
| "25348 Dee'S Catering Services 41647221 \n", | |
| "25349 Jack'S Sliders And Sushi 41647241 \n", | |
| "25350 New Ming Fat Chinese Restaurant 41647292 \n", | |
| "25351 Noodle House 41647360 \n", | |
| "25352 Bahary Fish Market 41647370 \n", | |
| "25353 The Tin House Tavern 41647380 \n", | |
| "25354 Ambrosino'S Ii 41647384 \n", | |
| "25355 Bruce'S Fish And Chips 41647392 \n", | |
| "25356 Coffee Bean Tea & Leaf 41647399 \n", | |
| "25357 Gelato Ti Amo 41647482 \n", | |
| "25358 Rockaway Roti Shop 41647521 \n", | |
| "\n", | |
| " address_json \\\n", | |
| "0 {\"building\":\"1007\",\"coord\":[-73.856077,40.8484... \n", | |
| "1 {\"building\":\"469\",\"coord\":[-73.961704,40.66294... \n", | |
| "2 {\"building\":\"351\",\"coord\":[-73.98513559999999,... \n", | |
| "3 {\"building\":\"2780\",\"coord\":[-73.98241999999999... \n", | |
| "4 {\"building\":\"97-22\",\"coord\":[-73.8601152,40.73... \n", | |
| "5 {\"building\":\"8825\",\"coord\":[-73.8803827,40.764... \n", | |
| "6 {\"building\":\"2206\",\"coord\":[-74.1377286,40.611... \n", | |
| "7 {\"building\":\"7114\",\"coord\":[-73.9068506,40.619... \n", | |
| "8 {\"building\":\"6409\",\"coord\":[-74.00528899999999... \n", | |
| "9 {\"building\":\"1839\",\"coord\":[-73.9482609,40.640... \n", | |
| "10 {\"building\":\"2300\",\"coord\":[-73.8786113,40.850... \n", | |
| "11 {\"building\":\"7715\",\"coord\":[-73.9973325,40.611... \n", | |
| "12 {\"building\":\"1269\",\"coord\":[-73.871194,40.6730... \n", | |
| "13 {\"building\":\"1\",\"coord\":[-73.96926909999999,40... \n", | |
| "14 {\"building\":\"705\",\"coord\":[-73.9653967,40.6064... \n", | |
| "15 {\"building\":\"203\",\"coord\":[-73.97822040000001,... \n", | |
| "16 {\"building\":\"265-15\",\"coord\":[-73.7032601,40.7... \n", | |
| "17 {\"building\":\"6909\",\"coord\":[-74.0259567,40.635... \n", | |
| "18 {\"building\":\"522\",\"coord\":[-73.95171,40.767461... \n", | |
| "19 {\"building\":\"284\",\"coord\":[-73.9829239,40.6580... \n", | |
| "20 {\"building\":\"129-08\",\"coord\":[-73.839297,40.78... \n", | |
| "21 {\"building\":\"759\",\"coord\":[-73.9925306,40.7309... \n", | |
| "22 {\"building\":\"3406\",\"coord\":[-73.94024739999999... \n", | |
| "23 {\"building\":\"502\",\"coord\":[-73.976112,40.78671... \n", | |
| "24 {\"building\":\"730\",\"coord\":[-73.96805719999999,... \n", | |
| "25 {\"building\":\"18\",\"coord\":[-73.996984,40.72589]... \n", | |
| "26 {\"building\":\"531\",\"coord\":[-73.9634876,40.6940... \n", | |
| "27 {\"building\":\"103-05\",\"coord\":[-73.8642349,40.7... \n", | |
| "28 {\"building\":\"60\",\"coord\":[-74.0085357,40.70620... \n", | |
| "29 {\"building\":\"195\",\"coord\":[-73.9246028,40.6522... \n", | |
| "... ... \n", | |
| "25329 {\"building\":\"87-77\",\"coord\":[-73.8093635,40.70... \n", | |
| "25330 {\"building\":\"1148\",\"coord\":[-73.9508029,40.659... \n", | |
| "25331 {\"building\":\"166\",\"coord\":[-73.98527659999999,... \n", | |
| "25332 {\"building\":\"321\",\"coord\":[-74.0062401,40.7397... \n", | |
| "25333 {\"building\":\"1962\",\"coord\":[-73.9405519,40.806... \n", | |
| "25334 {\"building\":\"350\",\"coord\":[-73.9922178,40.7579... \n", | |
| "25335 {\"building\":\"118-16\",\"coord\":[-73.819531,40.67... \n", | |
| "25336 {\"building\":\"9\",\"coord\":[-73.98931019999999,40... \n", | |
| "25337 {\"building\":\"2756\",\"coord\":[-73.9675441,40.800... \n", | |
| "25338 {\"building\":\"47-02\",\"coord\":[-73.918047,40.765... \n", | |
| "25339 {\"building\":\"13351\",\"coord\":[-73.832828,40.759... \n", | |
| "25340 {\"building\":\"1445\",\"coord\":[-73.8549994,40.835... \n", | |
| "25341 {\"building\":\"37-56\",\"coord\":[-73.860018,40.752... \n", | |
| "25342 {\"building\":\"262\",\"coord\":[-73.9111954,40.8615... \n", | |
| "25343 {\"building\":\"1553\",\"coord\":[-73.954548,40.7745... \n", | |
| "25344 {\"building\":\"199\",\"coord\":[-73.9831015,40.7228... \n", | |
| "25345 {\"building\":\"9712\",\"coord\":[-73.8194803,40.584... \n", | |
| "25346 {\"building\":\"4134\",\"coord\":[-73.9400398,40.751... \n", | |
| "25347 {\"building\":\"136-13\",\"coord\":[-73.763352,40.67... \n", | |
| "25348 {\"building\":\"217-15\",\"coord\":[-73.737423999999... \n", | |
| "25349 {\"building\":\"171\",\"coord\":[-73.98581899999999,... \n", | |
| "25350 {\"building\":\"1155\",\"coord\":[-73.8753401,40.672... \n", | |
| "25351 {\"building\":\"56-09\",\"coord\":[-73.7315557,40.76... \n", | |
| "25352 {\"building\":\"484\",\"coord\":[-74.0212854,40.6334... \n", | |
| "25353 {\"building\":\"195-02\",\"coord\":[-73.785758,40.75... \n", | |
| "25354 {\"building\":\"6410\",\"coord\":[-74.2150624,40.521... \n", | |
| "25355 {\"building\":\"500\",\"coord\":[-73.890768,40.85709... \n", | |
| "25356 {\"building\":\"2169\",\"coord\":[-73.981231,40.7822... \n", | |
| "25357 {\"building\":\"68\",\"coord\":[-73.9892179,40.72594... \n", | |
| "25358 {\"building\":\"12221\",\"coord\":[-73.8032425999999... \n", | |
| "\n", | |
| " grades_json building \n", | |
| "0 [{\"date\":{\"$date\":1393804800000},\"grade\":\"A\",\"... \"1007\" \n", | |
| "1 [{\"date\":{\"$date\":1419897600000},\"grade\":\"A\",\"... \"469\" \n", | |
| "2 [{\"date\":{\"$date\":1409961600000},\"grade\":\"A\",\"... \"351\" \n", | |
| "3 [{\"date\":{\"$date\":1402358400000},\"grade\":\"A\",\"... \"2780\" \n", | |
| "4 [{\"date\":{\"$date\":1416787200000},\"grade\":\"Z\",\"... \"97-22\" \n", | |
| "5 [{\"date\":{\"$date\":1416009600000},\"grade\":\"Z\",\"... \"8825\" \n", | |
| "6 [{\"date\":{\"$date\":1412553600000},\"grade\":\"A\",\"... \"2206\" \n", | |
| "7 [{\"date\":{\"$date\":1401321600000},\"grade\":\"A\",\"... \"7114\" \n", | |
| "8 [{\"date\":{\"$date\":1405641600000},\"grade\":\"A\",\"... \"6409\" \n", | |
| "9 [{\"date\":{\"$date\":1405296000000},\"grade\":\"A\",\"... \"1839\" \n", | |
| "10 [{\"date\":{\"$date\":1401235200000},\"grade\":\"A\",\"... \"2300\" \n", | |
| "11 [{\"date\":{\"$date\":1397606400000},\"grade\":\"A\",\"... \"7715\" \n", | |
| "12 [{\"date\":{\"$date\":1410825600000},\"grade\":\"B\",\"... \"1269\" \n", | |
| "13 [{\"date\":{\"$date\":1399420800000},\"grade\":\"A\",\"... \"1\" \n", | |
| "14 [{\"date\":{\"$date\":1415577600000},\"grade\":\"A\",\"... \"705\" \n", | |
| "15 [{\"date\":{\"$date\":1391990400000},\"grade\":\"A\",\"... \"203\" \n", | |
| "16 [{\"date\":{\"$date\":1414454400000},\"grade\":\"A\",\"... \"265-15\" \n", | |
| "17 [{\"date\":{\"$date\":1408579200000},\"grade\":\"A\",\"... \"6909\" \n", | |
| "18 [{\"date\":{\"$date\":1409616000000},\"grade\":\"A\",\"... \"522\" \n", | |
| "19 [{\"date\":{\"$date\":1416355200000},\"grade\":\"A\",\"... \"284\" \n", | |
| "20 [{\"date\":{\"$date\":1408147200000},\"grade\":\"A\",\"... \"129-08\" \n", | |
| "21 [{\"date\":{\"$date\":1390262400000},\"grade\":\"A\",\"... \"759\" \n", | |
| "22 [{\"date\":{\"$date\":1395187200000},\"grade\":\"A\",\"... \"3406\" \n", | |
| "23 [{\"date\":{\"$date\":1410739200000},\"grade\":\"A\",\"... \"502\" \n", | |
| "24 [{\"date\":{\"$date\":1410480000000},\"grade\":\"B\",\"... \"730\" \n", | |
| "25 [{\"date\":{\"$date\":1396483200000},\"grade\":\"A\",\"... \"18\" \n", | |
| "26 [{\"date\":{\"$date\":1395100800000},\"grade\":\"A\",\"... \"531\" \n", | |
| "27 [{\"date\":{\"$date\":1398038400000},\"grade\":\"A\",\"... \"103-05\" \n", | |
| "28 [{\"date\":{\"$date\":1411689600000},\"grade\":\"A\",\"... \"60\" \n", | |
| "29 [{\"date\":{\"$date\":1399939200000},\"grade\":\"A\",\"... \"195\" \n", | |
| "... ... ... \n", | |
| "25329 [{\"date\":{\"$date\":1413417600000},\"grade\":\"Z\",\"... \"87-77\" \n", | |
| "25330 [{\"date\":{\"$date\":1409270400000},\"grade\":\"B\",\"... \"1148\" \n", | |
| "25331 [{\"date\":{\"$date\":1397001600000},\"grade\":\"A\",\"... \"166\" \n", | |
| "25332 [{\"date\":{\"$date\":1399852800000},\"grade\":\"A\",\"... \"321\" \n", | |
| "25333 [{\"date\":{\"$date\":1416960000000},\"grade\":\"A\",\"... \"1962\" \n", | |
| "25334 [{\"date\":{\"$date\":1420588800000},\"grade\":\"Z\",\"... \"350\" \n", | |
| "25335 [{\"date\":{\"$date\":1415577600000},\"grade\":\"A\",\"... \"118-16\" \n", | |
| "25336 [{\"date\":{\"$date\":1415750400000},\"grade\":\"A\",\"... \"9\" \n", | |
| "25337 [{\"date\":{\"$date\":1407283200000},\"grade\":\"C\",\"... \"2756\" \n", | |
| "25338 [{\"date\":{\"$date\":1416355200000},\"grade\":\"A\",\"... \"47-02\" \n", | |
| "25339 [{\"date\":{\"$date\":1403308800000},\"grade\":\"B\",\"... \"13351\" \n", | |
| "25340 [{\"date\":{\"$date\":1406592000000},\"grade\":\"Z\",\"... \"1445\" \n", | |
| "25341 [{\"date\":{\"$date\":1408406400000},\"grade\":\"A\",\"... \"37-56\" \n", | |
| "25342 [{\"date\":{\"$date\":1399507200000},\"grade\":\"A\",\"... \"262\" \n", | |
| "25343 [{\"date\":{\"$date\":1414540800000},\"grade\":\"A\",\"... \"1553\" \n", | |
| "25344 [{\"date\":{\"$date\":1408060800000},\"grade\":\"B\",\"... \"199\" \n", | |
| "25345 [{\"date\":{\"$date\":1398729600000},\"grade\":\"A\",\"... \"9712\" \n", | |
| "25346 [{\"date\":{\"$date\":1421193600000},\"grade\":\"A\",\"... \"4134\" \n", | |
| "25347 [{\"date\":{\"$date\":1419984000000},\"grade\":\"A\",\"... \"136-13\" \n", | |
| "25348 [{\"date\":{\"$date\":1401840000000},\"grade\":\"A\",\"... \"217-15\" \n", | |
| "25349 [{\"date\":{\"$date\":1417564800000},\"grade\":\"B\",\"... \"171\" \n", | |
| "25350 [{\"date\":{\"$date\":1394496000000},\"grade\":\"A\",\"... \"1155\" \n", | |
| "25351 [{\"date\":{\"$date\":1404259200000},\"grade\":\"A\",\"... \"56-09\" \n", | |
| "25352 [{\"date\":{\"$date\":1401840000000},\"grade\":\"A\",\"... \"484\" \n", | |
| "25353 [{\"date\":{\"$date\":1410134400000},\"grade\":\"A\",\"... \"195-02\" \n", | |
| "25354 [{\"date\":{\"$date\":1409616000000},\"grade\":\"A\",\"... \"6410\" \n", | |
| "25355 [{\"date\":{\"$date\":1403568000000},\"grade\":\"A\",\"... \"500\" \n", | |
| "25356 [{\"date\":{\"$date\":1406592000000},\"grade\":\"A\",\"... \"2169\" \n", | |
| "25357 [{\"date\":{\"$date\":1403913600000},\"grade\":\"A\",\"... \"68\" \n", | |
| "25358 [{\"date\":{\"$date\":1418428800000},\"grade\":\"A\",\"... \"12221\" \n", | |
| "\n", | |
| "[25359 rows x 7 columns]" | |
| ] | |
| }, | |
| "execution_count": 21, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "query = \"select *, address_json::json->'building' as building from restaurant_from_df\"\n", | |
| "show_query_response(query)" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 36, | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "data": { | |
| "text/html": [ | |
| "<div>\n", | |
| "<style>\n", | |
| " .dataframe thead tr:only-child th {\n", | |
| " text-align: right;\n", | |
| " }\n", | |
| "\n", | |
| " .dataframe thead th {\n", | |
| " text-align: left;\n", | |
| " }\n", | |
| "\n", | |
| " .dataframe tbody tr th {\n", | |
| " vertical-align: top;\n", | |
| " }\n", | |
| "</style>\n", | |
| "<table border=\"1\" class=\"dataframe\">\n", | |
| " <thead>\n", | |
| " <tr style=\"text-align: right;\">\n", | |
| " <th></th>\n", | |
| " <th>building</th>\n", | |
| " </tr>\n", | |
| " </thead>\n", | |
| " <tbody>\n", | |
| " <tr>\n", | |
| " <th>0</th>\n", | |
| " <td>-73.856077</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1</th>\n", | |
| " <td>-73.961704</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2</th>\n", | |
| " <td>-73.98513559999999</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>3</th>\n", | |
| " <td>-73.98241999999999</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>4</th>\n", | |
| " <td>-73.8601152</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>5</th>\n", | |
| " <td>-73.8803827</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>6</th>\n", | |
| " <td>-74.1377286</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>7</th>\n", | |
| " <td>-73.9068506</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>8</th>\n", | |
| " <td>-74.00528899999999</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>9</th>\n", | |
| " <td>-73.9482609</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>10</th>\n", | |
| " <td>-73.8786113</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>11</th>\n", | |
| " <td>-73.9973325</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>12</th>\n", | |
| " <td>-73.871194</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>13</th>\n", | |
| " <td>-73.96926909999999</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>14</th>\n", | |
| " <td>-73.9653967</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>15</th>\n", | |
| " <td>-73.97822040000001</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>16</th>\n", | |
| " <td>-73.7032601</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>17</th>\n", | |
| " <td>-74.0259567</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>18</th>\n", | |
| " <td>-73.95171</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>19</th>\n", | |
| " <td>-73.9829239</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>20</th>\n", | |
| " <td>-73.839297</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>21</th>\n", | |
| " <td>-73.9925306</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>22</th>\n", | |
| " <td>-73.94024739999999</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>23</th>\n", | |
| " <td>-73.976112</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>24</th>\n", | |
| " <td>-73.96805719999999</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25</th>\n", | |
| " <td>-73.996984</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>26</th>\n", | |
| " <td>-73.9634876</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>27</th>\n", | |
| " <td>-73.8642349</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>28</th>\n", | |
| " <td>-74.0085357</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>29</th>\n", | |
| " <td>-73.9246028</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>...</th>\n", | |
| " <td>...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25329</th>\n", | |
| " <td>-73.8093635</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25330</th>\n", | |
| " <td>-73.9508029</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25331</th>\n", | |
| " <td>-73.98527659999999</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25332</th>\n", | |
| " <td>-74.0062401</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25333</th>\n", | |
| " <td>-73.9405519</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25334</th>\n", | |
| " <td>-73.9922178</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25335</th>\n", | |
| " <td>-73.819531</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25336</th>\n", | |
| " <td>-73.98931019999999</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25337</th>\n", | |
| " <td>-73.9675441</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25338</th>\n", | |
| " <td>-73.918047</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25339</th>\n", | |
| " <td>-73.832828</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25340</th>\n", | |
| " <td>-73.8549994</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25341</th>\n", | |
| " <td>-73.860018</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25342</th>\n", | |
| " <td>-73.9111954</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25343</th>\n", | |
| " <td>-73.954548</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25344</th>\n", | |
| " <td>-73.9831015</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25345</th>\n", | |
| " <td>-73.8194803</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25346</th>\n", | |
| " <td>-73.9400398</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25347</th>\n", | |
| " <td>-73.763352</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25348</th>\n", | |
| " <td>-73.73742399999999</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25349</th>\n", | |
| " <td>-73.98581899999999</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25350</th>\n", | |
| " <td>-73.8753401</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25351</th>\n", | |
| " <td>-73.7315557</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25352</th>\n", | |
| " <td>-74.0212854</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25353</th>\n", | |
| " <td>-73.785758</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25354</th>\n", | |
| " <td>-74.2150624</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25355</th>\n", | |
| " <td>-73.890768</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25356</th>\n", | |
| " <td>-73.981231</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25357</th>\n", | |
| " <td>-73.9892179</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25358</th>\n", | |
| " <td>-73.80324259999999</td>\n", | |
| " </tr>\n", | |
| " </tbody>\n", | |
| "</table>\n", | |
| "<p>25359 rows × 1 columns</p>\n", | |
| "</div>" | |
| ], | |
| "text/plain": [ | |
| " building\n", | |
| "0 -73.856077\n", | |
| "1 -73.961704\n", | |
| "2 -73.98513559999999\n", | |
| "3 -73.98241999999999\n", | |
| "4 -73.8601152\n", | |
| "5 -73.8803827\n", | |
| "6 -74.1377286\n", | |
| "7 -73.9068506\n", | |
| "8 -74.00528899999999\n", | |
| "9 -73.9482609\n", | |
| "10 -73.8786113\n", | |
| "11 -73.9973325\n", | |
| "12 -73.871194\n", | |
| "13 -73.96926909999999\n", | |
| "14 -73.9653967\n", | |
| "15 -73.97822040000001\n", | |
| "16 -73.7032601\n", | |
| "17 -74.0259567\n", | |
| "18 -73.95171\n", | |
| "19 -73.9829239\n", | |
| "20 -73.839297\n", | |
| "21 -73.9925306\n", | |
| "22 -73.94024739999999\n", | |
| "23 -73.976112\n", | |
| "24 -73.96805719999999\n", | |
| "25 -73.996984\n", | |
| "26 -73.9634876\n", | |
| "27 -73.8642349\n", | |
| "28 -74.0085357\n", | |
| "29 -73.9246028\n", | |
| "... ...\n", | |
| "25329 -73.8093635\n", | |
| "25330 -73.9508029\n", | |
| "25331 -73.98527659999999\n", | |
| "25332 -74.0062401\n", | |
| "25333 -73.9405519\n", | |
| "25334 -73.9922178\n", | |
| "25335 -73.819531\n", | |
| "25336 -73.98931019999999\n", | |
| "25337 -73.9675441\n", | |
| "25338 -73.918047\n", | |
| "25339 -73.832828\n", | |
| "25340 -73.8549994\n", | |
| "25341 -73.860018\n", | |
| "25342 -73.9111954\n", | |
| "25343 -73.954548\n", | |
| "25344 -73.9831015\n", | |
| "25345 -73.8194803\n", | |
| "25346 -73.9400398\n", | |
| "25347 -73.763352\n", | |
| "25348 -73.73742399999999\n", | |
| "25349 -73.98581899999999\n", | |
| "25350 -73.8753401\n", | |
| "25351 -73.7315557\n", | |
| "25352 -74.0212854\n", | |
| "25353 -73.785758\n", | |
| "25354 -74.2150624\n", | |
| "25355 -73.890768\n", | |
| "25356 -73.981231\n", | |
| "25357 -73.9892179\n", | |
| "25358 -73.80324259999999\n", | |
| "\n", | |
| "[25359 rows x 1 columns]" | |
| ] | |
| }, | |
| "execution_count": 36, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "query = \"select (address_json::json->'coord'->0) as building from restaurant_from_df\"\n", | |
| "show_query_response(query)" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 41, | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "data": { | |
| "text/html": [ | |
| "<div>\n", | |
| "<style>\n", | |
| " .dataframe thead tr:only-child th {\n", | |
| " text-align: right;\n", | |
| " }\n", | |
| "\n", | |
| " .dataframe thead th {\n", | |
| " text-align: left;\n", | |
| " }\n", | |
| "\n", | |
| " .dataframe tbody tr th {\n", | |
| " vertical-align: top;\n", | |
| " }\n", | |
| "</style>\n", | |
| "<table border=\"1\" class=\"dataframe\">\n", | |
| " <thead>\n", | |
| " <tr style=\"text-align: right;\">\n", | |
| " <th></th>\n", | |
| " <th>restaurant_id</th>\n", | |
| " <th>x</th>\n", | |
| " </tr>\n", | |
| " </thead>\n", | |
| " <tbody>\n", | |
| " <tr>\n", | |
| " <th>0</th>\n", | |
| " <td>30075445</td>\n", | |
| " <td>-73.856077000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1</th>\n", | |
| " <td>30112340</td>\n", | |
| " <td>-73.961704000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2</th>\n", | |
| " <td>30191841</td>\n", | |
| " <td>-73.985135599999990000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>3</th>\n", | |
| " <td>40356018</td>\n", | |
| " <td>-73.982419999999990000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>4</th>\n", | |
| " <td>40356068</td>\n", | |
| " <td>-73.860115200000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>5</th>\n", | |
| " <td>40356151</td>\n", | |
| " <td>-73.880382700000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>6</th>\n", | |
| " <td>40356442</td>\n", | |
| " <td>-74.137728600000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>7</th>\n", | |
| " <td>40356483</td>\n", | |
| " <td>-73.906850600000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>8</th>\n", | |
| " <td>40356649</td>\n", | |
| " <td>-74.005288999999990000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>9</th>\n", | |
| " <td>40356731</td>\n", | |
| " <td>-73.948260900000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>10</th>\n", | |
| " <td>40357217</td>\n", | |
| " <td>-73.878611300000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>11</th>\n", | |
| " <td>40357437</td>\n", | |
| " <td>-73.997332500000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>12</th>\n", | |
| " <td>40358429</td>\n", | |
| " <td>-73.871194000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>13</th>\n", | |
| " <td>40359480</td>\n", | |
| " <td>-73.969269099999990000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>14</th>\n", | |
| " <td>40360045</td>\n", | |
| " <td>-73.965396700000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>15</th>\n", | |
| " <td>40360076</td>\n", | |
| " <td>-73.978220400000010000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>16</th>\n", | |
| " <td>40361322</td>\n", | |
| " <td>-73.703260100000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>17</th>\n", | |
| " <td>40361390</td>\n", | |
| " <td>-74.025956700000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>18</th>\n", | |
| " <td>40361521</td>\n", | |
| " <td>-73.951710000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>19</th>\n", | |
| " <td>40361606</td>\n", | |
| " <td>-73.982923900000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>20</th>\n", | |
| " <td>40361618</td>\n", | |
| " <td>-73.839297000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>21</th>\n", | |
| " <td>40361708</td>\n", | |
| " <td>-73.992530600000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>22</th>\n", | |
| " <td>40361998</td>\n", | |
| " <td>-73.940247399999990000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>23</th>\n", | |
| " <td>40362098</td>\n", | |
| " <td>-73.976112000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>24</th>\n", | |
| " <td>40362264</td>\n", | |
| " <td>-73.968057199999990000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25</th>\n", | |
| " <td>40362274</td>\n", | |
| " <td>-73.996984000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>26</th>\n", | |
| " <td>40362344</td>\n", | |
| " <td>-73.963487600000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>27</th>\n", | |
| " <td>40362432</td>\n", | |
| " <td>-73.864234900000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>28</th>\n", | |
| " <td>40362715</td>\n", | |
| " <td>-74.008535700000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>29</th>\n", | |
| " <td>40362869</td>\n", | |
| " <td>-73.924602800000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>...</th>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25329</th>\n", | |
| " <td>41646934</td>\n", | |
| " <td>-73.809363500000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25330</th>\n", | |
| " <td>41646958</td>\n", | |
| " <td>-73.950802900000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25331</th>\n", | |
| " <td>41646963</td>\n", | |
| " <td>-73.985276599999990000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25332</th>\n", | |
| " <td>41646967</td>\n", | |
| " <td>-74.006240100000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25333</th>\n", | |
| " <td>41646976</td>\n", | |
| " <td>-73.940551900000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25334</th>\n", | |
| " <td>41646979</td>\n", | |
| " <td>-73.992217800000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25335</th>\n", | |
| " <td>41647006</td>\n", | |
| " <td>-73.819531000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25336</th>\n", | |
| " <td>41647012</td>\n", | |
| " <td>-73.989310199999990000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25337</th>\n", | |
| " <td>41647017</td>\n", | |
| " <td>-73.967544100000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25338</th>\n", | |
| " <td>41647039</td>\n", | |
| " <td>-73.918047000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25339</th>\n", | |
| " <td>41647062</td>\n", | |
| " <td>-73.832828000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25340</th>\n", | |
| " <td>41647098</td>\n", | |
| " <td>-73.854999400000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25341</th>\n", | |
| " <td>41647129</td>\n", | |
| " <td>-73.860018000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25342</th>\n", | |
| " <td>41647169</td>\n", | |
| " <td>-73.911195400000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25343</th>\n", | |
| " <td>41647176</td>\n", | |
| " <td>-73.954548000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25344</th>\n", | |
| " <td>41647181</td>\n", | |
| " <td>-73.983101500000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25345</th>\n", | |
| " <td>41647183</td>\n", | |
| " <td>-73.819480300000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25346</th>\n", | |
| " <td>41647192</td>\n", | |
| " <td>-73.940039800000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25347</th>\n", | |
| " <td>41647210</td>\n", | |
| " <td>-73.763352000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25348</th>\n", | |
| " <td>41647221</td>\n", | |
| " <td>-73.737423999999990000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25349</th>\n", | |
| " <td>41647241</td>\n", | |
| " <td>-73.985818999999990000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25350</th>\n", | |
| " <td>41647292</td>\n", | |
| " <td>-73.875340100000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25351</th>\n", | |
| " <td>41647360</td>\n", | |
| " <td>-73.731555700000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25352</th>\n", | |
| " <td>41647370</td>\n", | |
| " <td>-74.021285400000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25353</th>\n", | |
| " <td>41647380</td>\n", | |
| " <td>-73.785758000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25354</th>\n", | |
| " <td>41647384</td>\n", | |
| " <td>-74.215062400000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25355</th>\n", | |
| " <td>41647392</td>\n", | |
| " <td>-73.890768000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25356</th>\n", | |
| " <td>41647399</td>\n", | |
| " <td>-73.981231000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25357</th>\n", | |
| " <td>41647482</td>\n", | |
| " <td>-73.989217900000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25358</th>\n", | |
| " <td>41647521</td>\n", | |
| " <td>-73.803242599999990000</td>\n", | |
| " </tr>\n", | |
| " </tbody>\n", | |
| "</table>\n", | |
| "<p>25359 rows × 2 columns</p>\n", | |
| "</div>" | |
| ], | |
| "text/plain": [ | |
| " restaurant_id x\n", | |
| "0 30075445 -73.856077000000000000\n", | |
| "1 30112340 -73.961704000000000000\n", | |
| "2 30191841 -73.985135599999990000\n", | |
| "3 40356018 -73.982419999999990000\n", | |
| "4 40356068 -73.860115200000000000\n", | |
| "5 40356151 -73.880382700000000000\n", | |
| "6 40356442 -74.137728600000000000\n", | |
| "7 40356483 -73.906850600000000000\n", | |
| "8 40356649 -74.005288999999990000\n", | |
| "9 40356731 -73.948260900000000000\n", | |
| "10 40357217 -73.878611300000000000\n", | |
| "11 40357437 -73.997332500000000000\n", | |
| "12 40358429 -73.871194000000000000\n", | |
| "13 40359480 -73.969269099999990000\n", | |
| "14 40360045 -73.965396700000000000\n", | |
| "15 40360076 -73.978220400000010000\n", | |
| "16 40361322 -73.703260100000000000\n", | |
| "17 40361390 -74.025956700000000000\n", | |
| "18 40361521 -73.951710000000000000\n", | |
| "19 40361606 -73.982923900000000000\n", | |
| "20 40361618 -73.839297000000000000\n", | |
| "21 40361708 -73.992530600000000000\n", | |
| "22 40361998 -73.940247399999990000\n", | |
| "23 40362098 -73.976112000000000000\n", | |
| "24 40362264 -73.968057199999990000\n", | |
| "25 40362274 -73.996984000000000000\n", | |
| "26 40362344 -73.963487600000000000\n", | |
| "27 40362432 -73.864234900000000000\n", | |
| "28 40362715 -74.008535700000000000\n", | |
| "29 40362869 -73.924602800000000000\n", | |
| "... ... ...\n", | |
| "25329 41646934 -73.809363500000000000\n", | |
| "25330 41646958 -73.950802900000000000\n", | |
| "25331 41646963 -73.985276599999990000\n", | |
| "25332 41646967 -74.006240100000000000\n", | |
| "25333 41646976 -73.940551900000000000\n", | |
| "25334 41646979 -73.992217800000000000\n", | |
| "25335 41647006 -73.819531000000000000\n", | |
| "25336 41647012 -73.989310199999990000\n", | |
| "25337 41647017 -73.967544100000000000\n", | |
| "25338 41647039 -73.918047000000000000\n", | |
| "25339 41647062 -73.832828000000000000\n", | |
| "25340 41647098 -73.854999400000000000\n", | |
| "25341 41647129 -73.860018000000000000\n", | |
| "25342 41647169 -73.911195400000000000\n", | |
| "25343 41647176 -73.954548000000000000\n", | |
| "25344 41647181 -73.983101500000000000\n", | |
| "25345 41647183 -73.819480300000000000\n", | |
| "25346 41647192 -73.940039800000000000\n", | |
| "25347 41647210 -73.763352000000000000\n", | |
| "25348 41647221 -73.737423999999990000\n", | |
| "25349 41647241 -73.985818999999990000\n", | |
| "25350 41647292 -73.875340100000000000\n", | |
| "25351 41647360 -73.731555700000000000\n", | |
| "25352 41647370 -74.021285400000000000\n", | |
| "25353 41647380 -73.785758000000000000\n", | |
| "25354 41647384 -74.215062400000000000\n", | |
| "25355 41647392 -73.890768000000000000\n", | |
| "25356 41647399 -73.981231000000000000\n", | |
| "25357 41647482 -73.989217900000000000\n", | |
| "25358 41647521 -73.803242599999990000\n", | |
| "\n", | |
| "[25359 rows x 2 columns]" | |
| ] | |
| }, | |
| "execution_count": 41, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "query = \"select restaurant_id, (address_json::json->'coord'->0)::TEXT::NUMERIC as x from restaurant_from_df\"\n", | |
| "show_query_response(query)" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 48, | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "data": { | |
| "text/html": [ | |
| "<div>\n", | |
| "<style>\n", | |
| " .dataframe thead tr:only-child th {\n", | |
| " text-align: right;\n", | |
| " }\n", | |
| "\n", | |
| " .dataframe thead th {\n", | |
| " text-align: left;\n", | |
| " }\n", | |
| "\n", | |
| " .dataframe tbody tr th {\n", | |
| " vertical-align: top;\n", | |
| " }\n", | |
| "</style>\n", | |
| "<table border=\"1\" class=\"dataframe\">\n", | |
| " <thead>\n", | |
| " <tr style=\"text-align: right;\">\n", | |
| " <th></th>\n", | |
| " <th>restaurant_id</th>\n", | |
| " <th>x</th>\n", | |
| " <th>y</th>\n", | |
| " </tr>\n", | |
| " </thead>\n", | |
| " <tbody>\n", | |
| " <tr>\n", | |
| " <th>0</th>\n", | |
| " <td>30075445</td>\n", | |
| " <td>-73.856077000000000000</td>\n", | |
| " <td>40.848447000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1</th>\n", | |
| " <td>30112340</td>\n", | |
| " <td>-73.961704000000000000</td>\n", | |
| " <td>40.662942000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2</th>\n", | |
| " <td>30191841</td>\n", | |
| " <td>-73.985135599999990000</td>\n", | |
| " <td>40.767691900000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>3</th>\n", | |
| " <td>40356018</td>\n", | |
| " <td>-73.982419999999990000</td>\n", | |
| " <td>40.579505000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>4</th>\n", | |
| " <td>40356068</td>\n", | |
| " <td>-73.860115200000000000</td>\n", | |
| " <td>40.731173900000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>5</th>\n", | |
| " <td>40356151</td>\n", | |
| " <td>-73.880382700000000000</td>\n", | |
| " <td>40.764312400000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>6</th>\n", | |
| " <td>40356442</td>\n", | |
| " <td>-74.137728600000000000</td>\n", | |
| " <td>40.611957200000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>7</th>\n", | |
| " <td>40356483</td>\n", | |
| " <td>-73.906850600000000000</td>\n", | |
| " <td>40.619903400000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>8</th>\n", | |
| " <td>40356649</td>\n", | |
| " <td>-74.005288999999990000</td>\n", | |
| " <td>40.628886000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>9</th>\n", | |
| " <td>40356731</td>\n", | |
| " <td>-73.948260900000000000</td>\n", | |
| " <td>40.640827100000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>10</th>\n", | |
| " <td>40357217</td>\n", | |
| " <td>-73.878611300000000000</td>\n", | |
| " <td>40.850288300000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>11</th>\n", | |
| " <td>40357437</td>\n", | |
| " <td>-73.997332500000000000</td>\n", | |
| " <td>40.611748899999990000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>12</th>\n", | |
| " <td>40358429</td>\n", | |
| " <td>-73.871194000000000000</td>\n", | |
| " <td>40.673097500000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>13</th>\n", | |
| " <td>40359480</td>\n", | |
| " <td>-73.969269099999990000</td>\n", | |
| " <td>40.768523500000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>14</th>\n", | |
| " <td>40360045</td>\n", | |
| " <td>-73.965396700000000000</td>\n", | |
| " <td>40.606433900000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>15</th>\n", | |
| " <td>40360076</td>\n", | |
| " <td>-73.978220400000010000</td>\n", | |
| " <td>40.643525400000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>16</th>\n", | |
| " <td>40361322</td>\n", | |
| " <td>-73.703260100000000000</td>\n", | |
| " <td>40.738641700000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>17</th>\n", | |
| " <td>40361390</td>\n", | |
| " <td>-74.025956700000000000</td>\n", | |
| " <td>40.635367400000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>18</th>\n", | |
| " <td>40361521</td>\n", | |
| " <td>-73.951710000000000000</td>\n", | |
| " <td>40.767461000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>19</th>\n", | |
| " <td>40361606</td>\n", | |
| " <td>-73.982923900000000000</td>\n", | |
| " <td>40.658075300000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>20</th>\n", | |
| " <td>40361618</td>\n", | |
| " <td>-73.839297000000000000</td>\n", | |
| " <td>40.781470000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>21</th>\n", | |
| " <td>40361708</td>\n", | |
| " <td>-73.992530600000000000</td>\n", | |
| " <td>40.730934600000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>22</th>\n", | |
| " <td>40361998</td>\n", | |
| " <td>-73.940247399999990000</td>\n", | |
| " <td>40.762328800000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>23</th>\n", | |
| " <td>40362098</td>\n", | |
| " <td>-73.976112000000000000</td>\n", | |
| " <td>40.786714000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>24</th>\n", | |
| " <td>40362264</td>\n", | |
| " <td>-73.968057199999990000</td>\n", | |
| " <td>40.792558700000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25</th>\n", | |
| " <td>40362274</td>\n", | |
| " <td>-73.996984000000000000</td>\n", | |
| " <td>40.725890000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>26</th>\n", | |
| " <td>40362344</td>\n", | |
| " <td>-73.963487600000000000</td>\n", | |
| " <td>40.694000100000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>27</th>\n", | |
| " <td>40362432</td>\n", | |
| " <td>-73.864234900000000000</td>\n", | |
| " <td>40.753560000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>28</th>\n", | |
| " <td>40362715</td>\n", | |
| " <td>-74.008535700000000000</td>\n", | |
| " <td>40.706205399999990000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>29</th>\n", | |
| " <td>40362869</td>\n", | |
| " <td>-73.924602800000000000</td>\n", | |
| " <td>40.652239600000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>...</th>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25329</th>\n", | |
| " <td>41646934</td>\n", | |
| " <td>-73.809363500000000000</td>\n", | |
| " <td>40.705091200000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25330</th>\n", | |
| " <td>41646958</td>\n", | |
| " <td>-73.950802900000000000</td>\n", | |
| " <td>40.659537000000010000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25331</th>\n", | |
| " <td>41646963</td>\n", | |
| " <td>-73.985276599999990000</td>\n", | |
| " <td>40.605480500000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25332</th>\n", | |
| " <td>41646967</td>\n", | |
| " <td>-74.006240100000000000</td>\n", | |
| " <td>40.739754600000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25333</th>\n", | |
| " <td>41646976</td>\n", | |
| " <td>-73.940551900000000000</td>\n", | |
| " <td>40.806262900000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25334</th>\n", | |
| " <td>41646979</td>\n", | |
| " <td>-73.992217800000000000</td>\n", | |
| " <td>40.757992200000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25335</th>\n", | |
| " <td>41647006</td>\n", | |
| " <td>-73.819531000000000000</td>\n", | |
| " <td>40.675913000000010000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25336</th>\n", | |
| " <td>41647012</td>\n", | |
| " <td>-73.989310199999990000</td>\n", | |
| " <td>40.744059200000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25337</th>\n", | |
| " <td>41647017</td>\n", | |
| " <td>-73.967544100000000000</td>\n", | |
| " <td>40.800936900000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25338</th>\n", | |
| " <td>41647039</td>\n", | |
| " <td>-73.918047000000000000</td>\n", | |
| " <td>40.765320800000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25339</th>\n", | |
| " <td>41647062</td>\n", | |
| " <td>-73.832828000000000000</td>\n", | |
| " <td>40.759771000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25340</th>\n", | |
| " <td>41647098</td>\n", | |
| " <td>-73.854999400000000000</td>\n", | |
| " <td>40.835251600000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25341</th>\n", | |
| " <td>41647129</td>\n", | |
| " <td>-73.860018000000000000</td>\n", | |
| " <td>40.752453000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25342</th>\n", | |
| " <td>41647169</td>\n", | |
| " <td>-73.911195400000000000</td>\n", | |
| " <td>40.861512400000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25343</th>\n", | |
| " <td>41647176</td>\n", | |
| " <td>-73.954548000000000000</td>\n", | |
| " <td>40.774537900000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25344</th>\n", | |
| " <td>41647181</td>\n", | |
| " <td>-73.983101500000000000</td>\n", | |
| " <td>40.722830500000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25345</th>\n", | |
| " <td>41647183</td>\n", | |
| " <td>-73.819480300000000000</td>\n", | |
| " <td>40.584887500000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25346</th>\n", | |
| " <td>41647192</td>\n", | |
| " <td>-73.940039800000000000</td>\n", | |
| " <td>40.751488500000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25347</th>\n", | |
| " <td>41647210</td>\n", | |
| " <td>-73.763352000000000000</td>\n", | |
| " <td>40.674456000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25348</th>\n", | |
| " <td>41647221</td>\n", | |
| " <td>-73.737423999999990000</td>\n", | |
| " <td>40.718094000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25349</th>\n", | |
| " <td>41647241</td>\n", | |
| " <td>-73.985818999999990000</td>\n", | |
| " <td>40.734705000000010000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25350</th>\n", | |
| " <td>41647292</td>\n", | |
| " <td>-73.875340100000000000</td>\n", | |
| " <td>40.672474200000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25351</th>\n", | |
| " <td>41647360</td>\n", | |
| " <td>-73.731555700000000000</td>\n", | |
| " <td>40.760093900000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25352</th>\n", | |
| " <td>41647370</td>\n", | |
| " <td>-74.021285400000000000</td>\n", | |
| " <td>40.633488700000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25353</th>\n", | |
| " <td>41647380</td>\n", | |
| " <td>-73.785758000000000000</td>\n", | |
| " <td>40.752324000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25354</th>\n", | |
| " <td>41647384</td>\n", | |
| " <td>-74.215062400000000000</td>\n", | |
| " <td>40.521769900000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25355</th>\n", | |
| " <td>41647392</td>\n", | |
| " <td>-73.890768000000000000</td>\n", | |
| " <td>40.857094400000010000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25356</th>\n", | |
| " <td>41647399</td>\n", | |
| " <td>-73.981231000000000000</td>\n", | |
| " <td>40.782200600000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25357</th>\n", | |
| " <td>41647482</td>\n", | |
| " <td>-73.989217900000000000</td>\n", | |
| " <td>40.725940000000000000</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25358</th>\n", | |
| " <td>41647521</td>\n", | |
| " <td>-73.803242599999990000</td>\n", | |
| " <td>40.674534900000000000</td>\n", | |
| " </tr>\n", | |
| " </tbody>\n", | |
| "</table>\n", | |
| "<p>25359 rows × 3 columns</p>\n", | |
| "</div>" | |
| ], | |
| "text/plain": [ | |
| " restaurant_id x y\n", | |
| "0 30075445 -73.856077000000000000 40.848447000000000000\n", | |
| "1 30112340 -73.961704000000000000 40.662942000000000000\n", | |
| "2 30191841 -73.985135599999990000 40.767691900000000000\n", | |
| "3 40356018 -73.982419999999990000 40.579505000000000000\n", | |
| "4 40356068 -73.860115200000000000 40.731173900000000000\n", | |
| "5 40356151 -73.880382700000000000 40.764312400000000000\n", | |
| "6 40356442 -74.137728600000000000 40.611957200000000000\n", | |
| "7 40356483 -73.906850600000000000 40.619903400000000000\n", | |
| "8 40356649 -74.005288999999990000 40.628886000000000000\n", | |
| "9 40356731 -73.948260900000000000 40.640827100000000000\n", | |
| "10 40357217 -73.878611300000000000 40.850288300000000000\n", | |
| "11 40357437 -73.997332500000000000 40.611748899999990000\n", | |
| "12 40358429 -73.871194000000000000 40.673097500000000000\n", | |
| "13 40359480 -73.969269099999990000 40.768523500000000000\n", | |
| "14 40360045 -73.965396700000000000 40.606433900000000000\n", | |
| "15 40360076 -73.978220400000010000 40.643525400000000000\n", | |
| "16 40361322 -73.703260100000000000 40.738641700000000000\n", | |
| "17 40361390 -74.025956700000000000 40.635367400000000000\n", | |
| "18 40361521 -73.951710000000000000 40.767461000000000000\n", | |
| "19 40361606 -73.982923900000000000 40.658075300000000000\n", | |
| "20 40361618 -73.839297000000000000 40.781470000000000000\n", | |
| "21 40361708 -73.992530600000000000 40.730934600000000000\n", | |
| "22 40361998 -73.940247399999990000 40.762328800000000000\n", | |
| "23 40362098 -73.976112000000000000 40.786714000000000000\n", | |
| "24 40362264 -73.968057199999990000 40.792558700000000000\n", | |
| "25 40362274 -73.996984000000000000 40.725890000000000000\n", | |
| "26 40362344 -73.963487600000000000 40.694000100000000000\n", | |
| "27 40362432 -73.864234900000000000 40.753560000000000000\n", | |
| "28 40362715 -74.008535700000000000 40.706205399999990000\n", | |
| "29 40362869 -73.924602800000000000 40.652239600000000000\n", | |
| "... ... ... ...\n", | |
| "25329 41646934 -73.809363500000000000 40.705091200000000000\n", | |
| "25330 41646958 -73.950802900000000000 40.659537000000010000\n", | |
| "25331 41646963 -73.985276599999990000 40.605480500000000000\n", | |
| "25332 41646967 -74.006240100000000000 40.739754600000000000\n", | |
| "25333 41646976 -73.940551900000000000 40.806262900000000000\n", | |
| "25334 41646979 -73.992217800000000000 40.757992200000000000\n", | |
| "25335 41647006 -73.819531000000000000 40.675913000000010000\n", | |
| "25336 41647012 -73.989310199999990000 40.744059200000000000\n", | |
| "25337 41647017 -73.967544100000000000 40.800936900000000000\n", | |
| "25338 41647039 -73.918047000000000000 40.765320800000000000\n", | |
| "25339 41647062 -73.832828000000000000 40.759771000000000000\n", | |
| "25340 41647098 -73.854999400000000000 40.835251600000000000\n", | |
| "25341 41647129 -73.860018000000000000 40.752453000000000000\n", | |
| "25342 41647169 -73.911195400000000000 40.861512400000000000\n", | |
| "25343 41647176 -73.954548000000000000 40.774537900000000000\n", | |
| "25344 41647181 -73.983101500000000000 40.722830500000000000\n", | |
| "25345 41647183 -73.819480300000000000 40.584887500000000000\n", | |
| "25346 41647192 -73.940039800000000000 40.751488500000000000\n", | |
| "25347 41647210 -73.763352000000000000 40.674456000000000000\n", | |
| "25348 41647221 -73.737423999999990000 40.718094000000000000\n", | |
| "25349 41647241 -73.985818999999990000 40.734705000000010000\n", | |
| "25350 41647292 -73.875340100000000000 40.672474200000000000\n", | |
| "25351 41647360 -73.731555700000000000 40.760093900000000000\n", | |
| "25352 41647370 -74.021285400000000000 40.633488700000000000\n", | |
| "25353 41647380 -73.785758000000000000 40.752324000000000000\n", | |
| "25354 41647384 -74.215062400000000000 40.521769900000000000\n", | |
| "25355 41647392 -73.890768000000000000 40.857094400000010000\n", | |
| "25356 41647399 -73.981231000000000000 40.782200600000000000\n", | |
| "25357 41647482 -73.989217900000000000 40.725940000000000000\n", | |
| "25358 41647521 -73.803242599999990000 40.674534900000000000\n", | |
| "\n", | |
| "[25359 rows x 3 columns]" | |
| ] | |
| }, | |
| "execution_count": 48, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "query = '''\n", | |
| "select restaurant_id, (coord->0)::TEXT::NUMERIC as x, (coord->1)::TEXT::NUMERIC as y \n", | |
| "from (\n", | |
| " select *, address_json::json->'coord' as coord\n", | |
| " from restaurant_from_df\n", | |
| ") as t\n", | |
| "'''\n", | |
| "show_query_response(query)" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": null, | |
| "metadata": { | |
| "collapsed": true | |
| }, | |
| "outputs": [], | |
| "source": [] | |
| } | |
| ], | |
| "metadata": { | |
| "anaconda-cloud": {}, | |
| "kernelspec": { | |
| "display_name": "Python [Root]", | |
| "language": "python", | |
| "name": "Python [Root]" | |
| }, | |
| "language_info": { | |
| "codemirror_mode": { | |
| "name": "ipython", | |
| "version": 3 | |
| }, | |
| "file_extension": ".py", | |
| "mimetype": "text/x-python", | |
| "name": "python", | |
| "nbconvert_exporter": "python", | |
| "pygments_lexer": "ipython3", | |
| "version": "3.5.4" | |
| } | |
| }, | |
| "nbformat": 4, | |
| "nbformat_minor": 1 | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment