{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Boba Maps of NYC\n", "### Best NYC Neighborhoods for Boba Lovers?" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "### Imports for Google Colab Session\n", "\n", "# # imports for Google Colab Sessions\n", "# !apt install gdal-bin python-gdal python3-gdal \n", "# # Install rtree - Geopandas requirment\n", "# !apt install python3-rtree \n", "# # Install Geopandas\n", "# !pip install git+git://github.com/geopandas/geopandas.git\n", "# # Install descartes - Geopandas requirment\n", "# !pip install descartes " ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [], "source": [ "import os\n", "import numpy as np\n", "import pandas as pd\n", "import geopandas as gpd\n", "import matplotlib.pyplot as plt" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | id | \n", "alias | \n", "name | \n", "image_url | \n", "is_closed | \n", "url | \n", "review_count | \n", "categories | \n", "rating | \n", "coordinates | \n", "transactions | \n", "price | \n", "location | \n", "phone | \n", "display_phone | \n", "distance | \n", "latitude | \n", "longitude | \n", "geometry | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "Q3fmTHT7zilDWtfzLK9lMA | \n", "truedan-new-york-3 | \n", "Truedan | \n", "https://s3-media2.fl.yelpcdn.com/bphoto/BmUZXO... | \n", "False | \n", "https://www.yelp.com/biz/truedan-new-york-3?ad... | \n", "99 | \n", "[{'alias': 'bubbletea', 'title': 'Bubble Tea'}] | \n", "4.5 | \n", "{'latitude': 40.7191742, 'longitude': -73.9962... | \n", "['pickup', 'delivery'] | \n", "$$ | \n", "{'address1': '208 Grand St', 'address2': None,... | \n", "1.646559e+10 | \n", "(646) 559-2886 | \n", "1535.241614 | \n", "40.719174 | \n", "-73.996220 | \n", "POINT (-73.9962197 40.7191742) | \n", "
1 | \n", "7-bx74TooPuZKZDNW4WFcQ | \n", "chun-yang-tea-new-york | \n", "Chun Yang Tea | \n", "https://s3-media1.fl.yelpcdn.com/bphoto/JrGwrZ... | \n", "False | \n", "https://www.yelp.com/biz/chun-yang-tea-new-yor... | \n", "91 | \n", "[{'alias': 'bubbletea', 'title': 'Bubble Tea'}] | \n", "4.5 | \n", "{'latitude': 40.71617, 'longitude': -73.9971} | \n", "['pickup', 'delivery'] | \n", "$$ | \n", "{'address1': '26B Elizabeth St', 'address2': '... | \n", "1.212420e+10 | \n", "(212) 420-0123 | \n", "1212.877370 | \n", "40.716170 | \n", "-73.997100 | \n", "POINT (-73.9971 40.71617) | \n", "
2 | \n", "3aypSFXLfkAL4dhHVFobKg | \n", "lazy-sundaes-new-york-6 | \n", "Lazy Sundaes | \n", "https://s3-media3.fl.yelpcdn.com/bphoto/kEfCYC... | \n", "False | \n", "https://www.yelp.com/biz/lazy-sundaes-new-york... | \n", "32 | \n", "[{'alias': 'bubbletea', 'title': 'Bubble Tea'}... | \n", "4.5 | \n", "{'latitude': 40.720597, 'longitude': -73.984539} | \n", "['pickup', 'delivery'] | \n", "$$ | \n", "{'address1': '23 Clinton St', 'address2': None... | \n", "NaN | \n", "NaN | \n", "1877.016204 | \n", "40.720597 | \n", "-73.984539 | \n", "POINT (-73.984539 40.720597) | \n", "
3 | \n", "bVJQEeRNi34-3XN_F1AZEg | \n", "xing-fu-tang-new-york | \n", "Xing Fu Tang | \n", "https://s3-media2.fl.yelpcdn.com/bphoto/cyFHFE... | \n", "False | \n", "https://www.yelp.com/biz/xing-fu-tang-new-york... | \n", "91 | \n", "[{'alias': 'bubbletea', 'title': 'Bubble Tea'}] | \n", "4.5 | \n", "{'latitude': 40.7288, 'longitude': -73.98775} | \n", "['pickup', 'delivery'] | \n", "NaN | \n", "{'address1': '133 2nd Ave', 'address2': '', 'a... | \n", "NaN | \n", "NaN | \n", "2656.450427 | \n", "40.728800 | \n", "-73.987750 | \n", "POINT (-73.98775000000001 40.7288) | \n", "
4 | \n", "zupVwJAFYkHDwrsQd2ktXA | \n", "fiftylan-union-square-new-york-3 | \n", "FIFTYLAN Union Square | \n", "https://s3-media3.fl.yelpcdn.com/bphoto/UIwR20... | \n", "False | \n", "https://www.yelp.com/biz/fiftylan-union-square... | \n", "60 | \n", "[{'alias': 'bubbletea', 'title': 'Bubble Tea'}] | \n", "4.0 | \n", "{'latitude': 40.735516, 'longitude': -73.989191} | \n", "['pickup', 'delivery'] | \n", "NaN | \n", "{'address1': '32 Union Square E', 'address2': ... | \n", "1.646767e+10 | \n", "(646) 767-0085 | \n", "3367.900728 | \n", "40.735516 | \n", "-73.989191 | \n", "POINT (-73.98919100000001 40.735516) | \n", "
\n", " | review_count | \n", "rating | \n", "phone | \n", "distance | \n", "latitude | \n", "longitude | \n", "
---|---|---|---|---|---|---|
count | \n", "414.000000 | \n", "414.000000 | \n", "3.620000e+02 | \n", "414.000000 | \n", "414.000000 | \n", "414.000000 | \n", "
mean | \n", "89.722222 | \n", "3.985507 | \n", "1.613962e+10 | \n", "8980.359386 | \n", "40.716170 | \n", "-73.941997 | \n", "
std | \n", "116.765312 | \n", "0.608481 | \n", "2.375761e+09 | \n", "5684.076763 | \n", "0.058255 | \n", "0.084129 | \n", "
min | \n", "1.000000 | \n", "1.000000 | \n", "1.201432e+10 | \n", "953.875131 | \n", "40.537609 | \n", "-74.166080 | \n", "
25% | \n", "16.250000 | \n", "3.500000 | \n", "1.347732e+10 | \n", "3954.891025 | \n", "40.689505 | \n", "-73.994920 | \n", "
50% | \n", "49.000000 | \n", "4.000000 | \n", "1.718286e+10 | \n", "8254.243639 | \n", "40.731610 | \n", "-73.975096 | \n", "
75% | \n", "109.000000 | \n", "4.500000 | \n", "1.718886e+10 | \n", "13019.588280 | \n", "40.757300 | \n", "-73.880179 | \n", "
max | \n", "740.000000 | \n", "5.000000 | \n", "1.934235e+10 | \n", "25132.157979 | \n", "40.886959 | \n", "-73.702410 | \n", "
\n", " | count | \n", "unique | \n", "top | \n", "freq | \n", "
---|---|---|---|---|
id | \n", "414 | \n", "414 | \n", "Q3fmTHT7zilDWtfzLK9lMA | \n", "1 | \n", "
alias | \n", "414 | \n", "414 | \n", "truedan-new-york-3 | \n", "1 | \n", "
name | \n", "414 | \n", "259 | \n", "Kung Fu Tea | \n", "26 | \n", "
image_url | \n", "409 | \n", "409 | \n", "https://s3-media2.fl.yelpcdn.com/bphoto/BmUZXO... | \n", "1 | \n", "
url | \n", "414 | \n", "414 | \n", "https://www.yelp.com/biz/truedan-new-york-3?ad... | \n", "1 | \n", "
categories | \n", "414 | \n", "177 | \n", "[{'alias': 'bubbletea', 'title': 'Bubble Tea'}] | \n", "115 | \n", "
coordinates | \n", "414 | \n", "409 | \n", "{'latitude': 40.71697, 'longitude': -73.99471} | \n", "2 | \n", "
transactions | \n", "414 | \n", "5 | \n", "['pickup', 'delivery'] | \n", "229 | \n", "
price | \n", "258 | \n", "3 | \n", "$ | \n", "166 | \n", "
location | \n", "414 | \n", "411 | \n", "{'address1': '90-15 Queens Blvd', 'address2': ... | \n", "2 | \n", "
display_phone | \n", "362 | \n", "357 | \n", "(718) 395-8297 | \n", "2 | \n", "
geometry | \n", "414 | \n", "409 | \n", "POINT (-73.99471 40.71697) | \n", "2 | \n", "
\n", " | boro_code | \n", "boro_name | \n", "county_fip | \n", "ntacode | \n", "ntaname | \n", "shape_area | \n", "shape_leng | \n", "geometry | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "4.0 | \n", "Queens | \n", "081 | \n", "QN51 | \n", "Murray Hill | \n", "5.248828e+07 | \n", "33266.904856 | \n", "POLYGON ((-73.80379 40.77561, -73.80099 40.775... | \n", "
1 | \n", "4.0 | \n", "Queens | \n", "081 | \n", "QN27 | \n", "East Elmhurst | \n", "1.972685e+07 | \n", "19816.711894 | \n", "POLYGON ((-73.86110 40.76366, -73.85993 40.762... | \n", "
2 | \n", "4.0 | \n", "Queens | \n", "081 | \n", "QN41 | \n", "Fresh Meadows-Utopia | \n", "2.777485e+07 | \n", "22106.431272 | \n", "POLYGON ((-73.77758 40.73019, -73.77849 40.729... | \n", "
3 | \n", "1.0 | \n", "Manhattan | \n", "061 | \n", "MN17 | \n", "Midtown-Midtown South | \n", "3.019153e+07 | \n", "27032.700375 | \n", "POLYGON ((-73.97301 40.76428, -73.97141 40.763... | \n", "
4 | \n", "2.0 | \n", "Bronx | \n", "005 | \n", "BX09 | \n", "Soundview-Castle Hill-Clason Point-Harding Park | \n", "5.198380e+07 | \n", "67340.977626 | \n", "MULTIPOLYGON (((-73.88064 40.81852, -73.88098 ... | \n", "
\n", " | id | \n", "alias | \n", "name | \n", "image_url | \n", "is_closed | \n", "url | \n", "review_count | \n", "categories | \n", "rating | \n", "coordinates | \n", "... | \n", "longitude | \n", "geometry | \n", "index_right | \n", "boro_code | \n", "boro_name | \n", "county_fip | \n", "ntacode | \n", "ntaname | \n", "shape_area | \n", "shape_leng | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "Q3fmTHT7zilDWtfzLK9lMA | \n", "truedan-new-york-3 | \n", "Truedan | \n", "https://s3-media2.fl.yelpcdn.com/bphoto/BmUZXO... | \n", "False | \n", "https://www.yelp.com/biz/truedan-new-york-3?ad... | \n", "99 | \n", "[{'alias': 'bubbletea', 'title': 'Bubble Tea'}] | \n", "4.5 | \n", "{'latitude': 40.7191742, 'longitude': -73.9962... | \n", "... | \n", "-73.996220 | \n", "POINT (-73.99622 40.71917) | \n", "94 | \n", "1.0 | \n", "Manhattan | \n", "061 | \n", "MN24 | \n", "SoHo-TriBeCa-Civic Center-Little Italy | \n", "2.503268e+07 | \n", "26855.031527 | \n", "
1 | \n", "7-bx74TooPuZKZDNW4WFcQ | \n", "chun-yang-tea-new-york | \n", "Chun Yang Tea | \n", "https://s3-media1.fl.yelpcdn.com/bphoto/JrGwrZ... | \n", "False | \n", "https://www.yelp.com/biz/chun-yang-tea-new-yor... | \n", "91 | \n", "[{'alias': 'bubbletea', 'title': 'Bubble Tea'}] | \n", "4.5 | \n", "{'latitude': 40.71617, 'longitude': -73.9971} | \n", "... | \n", "-73.997100 | \n", "POINT (-73.99710 40.71617) | \n", "88 | \n", "1.0 | \n", "Manhattan | \n", "061 | \n", "MN27 | \n", "Chinatown | \n", "1.450188e+07 | \n", "20786.254332 | \n", "
2 | \n", "3aypSFXLfkAL4dhHVFobKg | \n", "lazy-sundaes-new-york-6 | \n", "Lazy Sundaes | \n", "https://s3-media3.fl.yelpcdn.com/bphoto/kEfCYC... | \n", "False | \n", "https://www.yelp.com/biz/lazy-sundaes-new-york... | \n", "32 | \n", "[{'alias': 'bubbletea', 'title': 'Bubble Tea'}... | \n", "4.5 | \n", "{'latitude': 40.720597, 'longitude': -73.984539} | \n", "... | \n", "-73.984539 | \n", "POINT (-73.98454 40.72060) | \n", "88 | \n", "1.0 | \n", "Manhattan | \n", "061 | \n", "MN27 | \n", "Chinatown | \n", "1.450188e+07 | \n", "20786.254332 | \n", "
3 | \n", "bVJQEeRNi34-3XN_F1AZEg | \n", "xing-fu-tang-new-york | \n", "Xing Fu Tang | \n", "https://s3-media2.fl.yelpcdn.com/bphoto/cyFHFE... | \n", "False | \n", "https://www.yelp.com/biz/xing-fu-tang-new-york... | \n", "91 | \n", "[{'alias': 'bubbletea', 'title': 'Bubble Tea'}] | \n", "4.5 | \n", "{'latitude': 40.7288, 'longitude': -73.98775} | \n", "... | \n", "-73.987750 | \n", "POINT (-73.98775 40.72880) | \n", "139 | \n", "1.0 | \n", "Manhattan | \n", "061 | \n", "MN22 | \n", "East Village | \n", "1.089424e+07 | \n", "13555.232094 | \n", "
4 | \n", "zupVwJAFYkHDwrsQd2ktXA | \n", "fiftylan-union-square-new-york-3 | \n", "FIFTYLAN Union Square | \n", "https://s3-media3.fl.yelpcdn.com/bphoto/UIwR20... | \n", "False | \n", "https://www.yelp.com/biz/fiftylan-union-square... | \n", "60 | \n", "[{'alias': 'bubbletea', 'title': 'Bubble Tea'}] | \n", "4.0 | \n", "{'latitude': 40.735516, 'longitude': -73.989191} | \n", "... | \n", "-73.989191 | \n", "POINT (-73.98919 40.73552) | \n", "32 | \n", "1.0 | \n", "Manhattan | \n", "061 | \n", "MN21 | \n", "Gramercy | \n", "7.526916e+06 | \n", "12096.891148 | \n", "
5 rows × 27 columns
\n", "\n", " | counts | \n", "
---|---|
count | \n", "93.000000 | \n", "
mean | \n", "4.451613 | \n", "
std | \n", "6.289253 | \n", "
min | \n", "1.000000 | \n", "
25% | \n", "1.000000 | \n", "
50% | \n", "2.000000 | \n", "
75% | \n", "5.000000 | \n", "
max | \n", "40.000000 | \n", "
\n", " | rating | \n", "
---|---|
count | \n", "93.000000 | \n", "
mean | \n", "4.018089 | \n", "
std | \n", "0.472595 | \n", "
min | \n", "2.000000 | \n", "
25% | \n", "3.833333 | \n", "
50% | \n", "4.000000 | \n", "
75% | \n", "4.333333 | \n", "
max | \n", "5.000000 | \n", "
\n", " | review_count | \n", "
---|---|
count | \n", "93.000000 | \n", "
mean | \n", "399.408602 | \n", "
std | \n", "812.981820 | \n", "
min | \n", "1.000000 | \n", "
25% | \n", "32.000000 | \n", "
50% | \n", "114.000000 | \n", "
75% | \n", "384.000000 | \n", "
max | \n", "5093.000000 | \n", "
\n", " | boro_code | \n", "boro_name | \n", "county_fip | \n", "ntacode | \n", "ntaname | \n", "shape_area | \n", "shape_leng | \n", "geometry | \n", "counts | \n", "rating | \n", "review_count | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "4.0 | \n", "Queens | \n", "081 | \n", "QN51 | \n", "Murray Hill | \n", "5.248828e+07 | \n", "33266.904856 | \n", "POLYGON ((-73.80379 40.77561, -73.80099 40.775... | \n", "4.0 | \n", "4.250000 | \n", "56.0 | \n", "
1 | \n", "4.0 | \n", "Queens | \n", "081 | \n", "QN27 | \n", "East Elmhurst | \n", "1.972685e+07 | \n", "19816.711894 | \n", "POLYGON ((-73.86110 40.76366, -73.85993 40.762... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2 | \n", "4.0 | \n", "Queens | \n", "081 | \n", "QN41 | \n", "Fresh Meadows-Utopia | \n", "2.777485e+07 | \n", "22106.431272 | \n", "POLYGON ((-73.77758 40.73019, -73.77849 40.729... | \n", "5.0 | \n", "4.000000 | \n", "338.0 | \n", "
3 | \n", "1.0 | \n", "Manhattan | \n", "061 | \n", "MN17 | \n", "Midtown-Midtown South | \n", "3.019153e+07 | \n", "27032.700375 | \n", "POLYGON ((-73.97301 40.76428, -73.97141 40.763... | \n", "15.0 | \n", "3.833333 | \n", "2564.0 | \n", "
4 | \n", "2.0 | \n", "Bronx | \n", "005 | \n", "BX09 | \n", "Soundview-Castle Hill-Clason Point-Harding Park | \n", "5.198380e+07 | \n", "67340.977626 | \n", "MULTIPOLYGON (((-73.88064 40.81852, -73.88098 ... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
\n", " | boro_code | \n", "boro_name | \n", "county_fip | \n", "ntacode | \n", "ntaname | \n", "shape_area | \n", "shape_leng | \n", "geometry | \n", "counts | \n", "rating | \n", "review_count | \n", "label_geometry | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "4.0 | \n", "Queens | \n", "081 | \n", "QN51 | \n", "Murray Hill | \n", "5.248828e+07 | \n", "33266.904856 | \n", "POLYGON ((-73.80379 40.77561, -73.80099 40.775... | \n", "4.0 | \n", "4.250000 | \n", "56.0 | \n", "POINT (-73.80955 40.76835) | \n", "
1 | \n", "4.0 | \n", "Queens | \n", "081 | \n", "QN27 | \n", "East Elmhurst | \n", "1.972685e+07 | \n", "19816.711894 | \n", "POLYGON ((-73.86110 40.76366, -73.85993 40.762... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "POINT (-73.86840 40.76335) | \n", "
2 | \n", "4.0 | \n", "Queens | \n", "081 | \n", "QN41 | \n", "Fresh Meadows-Utopia | \n", "2.777485e+07 | \n", "22106.431272 | \n", "POLYGON ((-73.77758 40.73019, -73.77849 40.729... | \n", "5.0 | \n", "4.000000 | \n", "338.0 | \n", "POINT (-73.78372 40.73489) | \n", "
3 | \n", "1.0 | \n", "Manhattan | \n", "061 | \n", "MN17 | \n", "Midtown-Midtown South | \n", "3.019153e+07 | \n", "27032.700375 | \n", "POLYGON ((-73.97301 40.76428, -73.97141 40.763... | \n", "15.0 | \n", "3.833333 | \n", "2564.0 | \n", "POINT (-73.98350 40.75573) | \n", "
4 | \n", "2.0 | \n", "Bronx | \n", "005 | \n", "BX09 | \n", "Soundview-Castle Hill-Clason Point-Harding Park | \n", "5.198380e+07 | \n", "67340.977626 | \n", "MULTIPOLYGON (((-73.88064 40.81852, -73.88098 ... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "POINT (-73.85619 40.81805) | \n", "
\n", " | rating | \n", "counts | \n", "review_count | \n", "
---|---|---|---|
count | \n", "93.000000 | \n", "93.000000 | \n", "93.000000 | \n", "
mean | \n", "4.018089 | \n", "4.451613 | \n", "399.408602 | \n", "
std | \n", "0.472595 | \n", "6.289253 | \n", "812.981820 | \n", "
min | \n", "2.000000 | \n", "1.000000 | \n", "1.000000 | \n", "
25% | \n", "3.833333 | \n", "1.000000 | \n", "32.000000 | \n", "
50% | \n", "4.000000 | \n", "2.000000 | \n", "114.000000 | \n", "
75% | \n", "4.333333 | \n", "5.000000 | \n", "384.000000 | \n", "
max | \n", "5.000000 | \n", "40.000000 | \n", "5093.000000 | \n", "
\n", " | boro_code | \n", "boro_name | \n", "county_fip | \n", "ntacode | \n", "ntaname | \n", "shape_area | \n", "shape_leng | \n", "geometry | \n", "counts | \n", "rating | \n", "review_count | \n", "label_geometry | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|
64 | \n", "2.0 | \n", "Bronx | \n", "005 | \n", "BX06 | \n", "Belmont | \n", "1.355635e+07 | \n", "17104.422131 | \n", "POLYGON ((-73.88309 40.86660, -73.88298 40.866... | \n", "1.0 | \n", "5.0 | \n", "5.0 | \n", "POINT (-73.88587 40.85778) | \n", "
103 | \n", "4.0 | \n", "Queens | \n", "081 | \n", "QN23 | \n", "College Point | \n", "5.055398e+07 | \n", "59454.750110 | \n", "MULTIPOLYGON (((-73.86788 40.78736, -73.86803 ... | \n", "1.0 | \n", "5.0 | \n", "2.0 | \n", "POINT (-73.84281 40.78092) | \n", "
145 | \n", "3.0 | \n", "Brooklyn | \n", "047 | \n", "BK73 | \n", "North Side-South Side | \n", "2.886227e+07 | \n", "28155.614043 | \n", "POLYGON ((-73.95814 40.72440, -73.95772 40.724... | \n", "5.0 | \n", "4.6 | \n", "434.0 | \n", "POINT (-73.95862 40.71492) | \n", "
122 | \n", "5.0 | \n", "Staten Island | \n", "085 | \n", "SI07 | \n", "Westerleigh | \n", "6.325658e+07 | \n", "41655.704816 | \n", "POLYGON ((-74.13047 40.63089, -74.13014 40.629... | \n", "3.0 | \n", "4.5 | \n", "68.0 | \n", "POINT (-74.12535 40.61688) | \n", "
81 | \n", "4.0 | \n", "Queens | \n", "081 | \n", "QN71 | \n", "Old Astoria | \n", "1.562046e+07 | \n", "19367.656081 | \n", "POLYGON ((-73.92828 40.77690, -73.92785 40.776... | \n", "1.0 | \n", "4.5 | \n", "124.0 | \n", "POINT (-73.92833 40.77157) | \n", "
63 | \n", "3.0 | \n", "Brooklyn | \n", "047 | \n", "BK35 | \n", "Stuyvesant Heights | \n", "3.140694e+07 | \n", "28239.081099 | \n", "POLYGON ((-73.91805 40.68721, -73.91800 40.686... | \n", "1.0 | \n", "4.5 | \n", "49.0 | \n", "POINT (-73.93189 40.68817) | \n", "
97 | \n", "1.0 | \n", "Manhattan | \n", "061 | \n", "MN28 | \n", "Lower East Side | \n", "2.329937e+07 | \n", "26518.511656 | \n", "MULTIPOLYGON (((-73.98237 40.70554, -73.98246 ... | \n", "1.0 | \n", "4.5 | \n", "8.0 | \n", "POINT (-73.98091 40.71784) | \n", "
100 | \n", "4.0 | \n", "Queens | \n", "081 | \n", "QN68 | \n", "Queensbridge-Ravenswood-Long Island City | \n", "2.331294e+07 | \n", "27228.382705 | \n", "POLYGON ((-73.93453 40.77118, -73.93425 40.771... | \n", "1.0 | \n", "4.5 | \n", "27.0 | \n", "POINT (-73.93875 40.75756) | \n", "
109 | \n", "1.0 | \n", "Manhattan | \n", "061 | \n", "MN06 | \n", "Manhattanville | \n", "1.073480e+07 | \n", "17357.246731 | \n", "POLYGON ((-73.94608 40.82126, -73.94640 40.820... | \n", "1.0 | \n", "4.5 | \n", "90.0 | \n", "POINT (-73.95382 40.81802) | \n", "
52 | \n", "2.0 | \n", "Bronx | \n", "005 | \n", "BX29 | \n", "Spuyten Duyvil-Kingsbridge | \n", "2.321411e+07 | \n", "27990.757219 | \n", "POLYGON ((-73.89788 40.89028, -73.89827 40.889... | \n", "1.0 | \n", "4.5 | \n", "19.0 | \n", "POINT (-73.91067 40.88241) | \n", "
\n", " | boro_name | \n", "ntaname | \n", "geometry | \n", "label_geometry | \n", "
---|---|---|---|---|
0 | \n", "Queens | \n", "Murray Hill | \n", "POLYGON ((-73.80379 40.77561, -73.80099 40.775... | \n", "POINT (-73.80955 40.76835) | \n", "
1 | \n", "Queens | \n", "East Elmhurst | \n", "POLYGON ((-73.86110 40.76366, -73.85993 40.762... | \n", "POINT (-73.86840 40.76335) | \n", "
2 | \n", "Queens | \n", "Fresh Meadows-Utopia | \n", "POLYGON ((-73.77758 40.73019, -73.77849 40.729... | \n", "POINT (-73.78372 40.73489) | \n", "
3 | \n", "Manhattan | \n", "Midtown-Midtown South | \n", "POLYGON ((-73.97301 40.76428, -73.97141 40.763... | \n", "POINT (-73.98350 40.75573) | \n", "
4 | \n", "Bronx | \n", "Soundview-Castle Hill-Clason Point-Harding Park | \n", "MULTIPOLYGON (((-73.88064 40.81852, -73.88098 ... | \n", "POINT (-73.85619 40.81805) | \n", "
\n", " | id | \n", "alias | \n", "name | \n", "image_url | \n", "is_closed | \n", "url | \n", "review_count | \n", "categories | \n", "rating | \n", "coordinates | \n", "... | \n", "geometry | \n", "index_right | \n", "boro_code | \n", "boro_name | \n", "county_fip | \n", "ntacode | \n", "ntaname | \n", "shape_area | \n", "shape_leng | \n", "rate_rev | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "Q3fmTHT7zilDWtfzLK9lMA | \n", "truedan-new-york-3 | \n", "Truedan | \n", "https://s3-media2.fl.yelpcdn.com/bphoto/BmUZXO... | \n", "False | \n", "https://www.yelp.com/biz/truedan-new-york-3?ad... | \n", "99 | \n", "[{'alias': 'bubbletea', 'title': 'Bubble Tea'}] | \n", "4.5 | \n", "{'latitude': 40.7191742, 'longitude': -73.9962... | \n", "... | \n", "POINT (-73.99622 40.71917) | \n", "94 | \n", "1.0 | \n", "Manhattan | \n", "061 | \n", "MN24 | \n", "SoHo-TriBeCa-Civic Center-Little Italy | \n", "2.503268e+07 | \n", "26855.031527 | \n", "445.5 | \n", "
1 | \n", "7-bx74TooPuZKZDNW4WFcQ | \n", "chun-yang-tea-new-york | \n", "Chun Yang Tea | \n", "https://s3-media1.fl.yelpcdn.com/bphoto/JrGwrZ... | \n", "False | \n", "https://www.yelp.com/biz/chun-yang-tea-new-yor... | \n", "91 | \n", "[{'alias': 'bubbletea', 'title': 'Bubble Tea'}] | \n", "4.5 | \n", "{'latitude': 40.71617, 'longitude': -73.9971} | \n", "... | \n", "POINT (-73.99710 40.71617) | \n", "88 | \n", "1.0 | \n", "Manhattan | \n", "061 | \n", "MN27 | \n", "Chinatown | \n", "1.450188e+07 | \n", "20786.254332 | \n", "409.5 | \n", "
2 | \n", "3aypSFXLfkAL4dhHVFobKg | \n", "lazy-sundaes-new-york-6 | \n", "Lazy Sundaes | \n", "https://s3-media3.fl.yelpcdn.com/bphoto/kEfCYC... | \n", "False | \n", "https://www.yelp.com/biz/lazy-sundaes-new-york... | \n", "32 | \n", "[{'alias': 'bubbletea', 'title': 'Bubble Tea'}... | \n", "4.5 | \n", "{'latitude': 40.720597, 'longitude': -73.984539} | \n", "... | \n", "POINT (-73.98454 40.72060) | \n", "88 | \n", "1.0 | \n", "Manhattan | \n", "061 | \n", "MN27 | \n", "Chinatown | \n", "1.450188e+07 | \n", "20786.254332 | \n", "144.0 | \n", "
3 | \n", "bVJQEeRNi34-3XN_F1AZEg | \n", "xing-fu-tang-new-york | \n", "Xing Fu Tang | \n", "https://s3-media2.fl.yelpcdn.com/bphoto/cyFHFE... | \n", "False | \n", "https://www.yelp.com/biz/xing-fu-tang-new-york... | \n", "91 | \n", "[{'alias': 'bubbletea', 'title': 'Bubble Tea'}] | \n", "4.5 | \n", "{'latitude': 40.7288, 'longitude': -73.98775} | \n", "... | \n", "POINT (-73.98775 40.72880) | \n", "139 | \n", "1.0 | \n", "Manhattan | \n", "061 | \n", "MN22 | \n", "East Village | \n", "1.089424e+07 | \n", "13555.232094 | \n", "409.5 | \n", "
4 | \n", "zupVwJAFYkHDwrsQd2ktXA | \n", "fiftylan-union-square-new-york-3 | \n", "FIFTYLAN Union Square | \n", "https://s3-media3.fl.yelpcdn.com/bphoto/UIwR20... | \n", "False | \n", "https://www.yelp.com/biz/fiftylan-union-square... | \n", "60 | \n", "[{'alias': 'bubbletea', 'title': 'Bubble Tea'}] | \n", "4.0 | \n", "{'latitude': 40.735516, 'longitude': -73.989191} | \n", "... | \n", "POINT (-73.98919 40.73552) | \n", "32 | \n", "1.0 | \n", "Manhattan | \n", "061 | \n", "MN21 | \n", "Gramercy | \n", "7.526916e+06 | \n", "12096.891148 | \n", "240.0 | \n", "
5 rows × 28 columns
\n", "\n", " | ntaname | \n", "rate_rev | \n", "
---|---|---|
0 | \n", "park-cemetery-etc-Queens | \n", "2.0 | \n", "
1 | \n", "College Point | \n", "10.0 | \n", "
2 | \n", "Fort Greene | \n", "10.5 | \n", "
3 | \n", "Belmont | \n", "25.0 | \n", "
4 | \n", "Georgetown-Marine Park-Bergen Beach-Mill Basin | \n", "28.0 | \n", "
\n", " | boro_name | \n", "ntaname | \n", "geometry | \n", "label_geometry | \n", "counts | \n", "rating | \n", "review_count | \n", "rate_rev | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "Queens | \n", "Murray Hill | \n", "POLYGON ((-73.80379 40.77561, -73.80099 40.775... | \n", "POINT (-73.80955 40.76835) | \n", "4.0 | \n", "4.250000 | \n", "56.0 | \n", "245.0 | \n", "
1 | \n", "Queens | \n", "East Elmhurst | \n", "POLYGON ((-73.86110 40.76366, -73.85993 40.762... | \n", "POINT (-73.86840 40.76335) | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2 | \n", "Queens | \n", "Fresh Meadows-Utopia | \n", "POLYGON ((-73.77758 40.73019, -73.77849 40.729... | \n", "POINT (-73.78372 40.73489) | \n", "5.0 | \n", "4.000000 | \n", "338.0 | \n", "1230.5 | \n", "
3 | \n", "Manhattan | \n", "Midtown-Midtown South | \n", "POLYGON ((-73.97301 40.76428, -73.97141 40.763... | \n", "POINT (-73.98350 40.75573) | \n", "15.0 | \n", "3.833333 | \n", "2564.0 | \n", "9598.5 | \n", "
4 | \n", "Bronx | \n", "Soundview-Castle Hill-Clason Point-Harding Park | \n", "MULTIPOLYGON (((-73.88064 40.81852, -73.88098 ... | \n", "POINT (-73.85619 40.81805) | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
\n", " | boro_name | \n", "ntaname | \n", "geometry | \n", "label_geometry | \n", "counts | \n", "rating | \n", "review_count | \n", "rate_rev | \n", "boba_index | \n", "
---|---|---|---|---|---|---|---|---|---|
0 | \n", "Queens | \n", "Murray Hill | \n", "POLYGON ((-73.80379 40.77561, -73.80099 40.775... | \n", "POINT (-73.80955 40.76835) | \n", "4.0 | \n", "4.250000 | \n", "56.0 | \n", "245.0 | \n", "4.826066 | \n", "
1 | \n", "Queens | \n", "East Elmhurst | \n", "POLYGON ((-73.86110 40.76366, -73.85993 40.762... | \n", "POINT (-73.86840 40.76335) | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2 | \n", "Queens | \n", "Fresh Meadows-Utopia | \n", "POLYGON ((-73.77758 40.73019, -73.77849 40.729... | \n", "POINT (-73.78372 40.73489) | \n", "5.0 | \n", "4.000000 | \n", "338.0 | \n", "1230.5 | \n", "4.489884 | \n", "
3 | \n", "Manhattan | \n", "Midtown-Midtown South | \n", "POLYGON ((-73.97301 40.76428, -73.97141 40.763... | \n", "POINT (-73.98350 40.75573) | \n", "15.0 | \n", "3.833333 | \n", "2564.0 | \n", "9598.5 | \n", "7.996799 | \n", "
4 | \n", "Bronx | \n", "Soundview-Castle Hill-Clason Point-Harding Park | \n", "MULTIPOLYGON (((-73.88064 40.81852, -73.88098 ... | \n", "POINT (-73.85619 40.81805) | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
\n", " | boro_name | \n", "ntaname | \n", "geometry | \n", "label_geometry | \n", "counts | \n", "rating | \n", "review_count | \n", "rate_rev | \n", "boba_index | \n", "
---|---|---|---|---|---|---|---|---|---|
155 | \n", "Queens | \n", "Flushing | \n", "POLYGON ((-73.82331 40.77958, -73.82355 40.779... | \n", "POINT (-73.82887 40.76109) | \n", "40.0 | \n", "3.687500 | \n", "5093.0 | \n", "19257.0 | \n", "13.189555 | \n", "
88 | \n", "Manhattan | \n", "Chinatown | \n", "POLYGON ((-73.98382 40.72147, -73.98386 40.721... | \n", "POINT (-73.99463 40.71561) | \n", "28.0 | \n", "4.000000 | \n", "4803.0 | \n", "19208.0 | \n", "11.671691 | \n", "
166 | \n", "Queens | \n", "Hunters Point-Sunnyside-West Maspeth | \n", "POLYGON ((-73.92563 40.75214, -73.92442 40.752... | \n", "POINT (-73.93121 40.73977) | \n", "19.0 | \n", "4.289474 | \n", "970.0 | \n", "4076.0 | \n", "10.102397 | \n", "
150 | \n", "Brooklyn | \n", "Sunset Park East | \n", "POLYGON ((-73.98906 40.64412, -73.98978 40.643... | \n", "POINT (-74.00465 40.64189) | \n", "23.0 | \n", "3.434783 | \n", "1183.0 | \n", "4148.5 | \n", "9.275888 | \n", "
144 | \n", "Queens | \n", "Elmhurst | \n", "POLYGON ((-73.86791 40.74493, -73.86788 40.744... | \n", "POINT (-73.87712 40.73949) | \n", "17.0 | \n", "4.088235 | \n", "1048.0 | \n", "4059.5 | \n", "8.808885 | \n", "
140 | \n", "Manhattan | \n", "West Village | \n", "POLYGON ((-73.98990 40.73443, -73.98987 40.733... | \n", "POINT (-74.00155 40.73305) | \n", "13.0 | \n", "4.269231 | \n", "1232.0 | \n", "5169.0 | \n", "8.343585 | \n", "
118 | \n", "Brooklyn | \n", "Park Slope-Gowanus | \n", "POLYGON ((-73.97376 40.68305, -73.97375 40.682... | \n", "POINT (-73.98390 40.67123) | \n", "13.0 | \n", "4.269231 | \n", "1764.0 | \n", "7257.0 | \n", "8.181170 | \n", "
3 | \n", "Manhattan | \n", "Midtown-Midtown South | \n", "POLYGON ((-73.97301 40.76428, -73.97141 40.763... | \n", "POINT (-73.98350 40.75573) | \n", "15.0 | \n", "3.833333 | \n", "2564.0 | \n", "9598.5 | \n", "7.996799 | \n", "
106 | \n", "Brooklyn | \n", "Bensonhurst West | \n", "POLYGON ((-73.97964 40.61556, -73.98022 40.615... | \n", "POINT (-73.99526 40.61222) | \n", "15.0 | \n", "3.833333 | \n", "845.0 | \n", "3097.5 | \n", "7.830427 | \n", "
139 | \n", "Manhattan | \n", "East Village | \n", "POLYGON ((-73.98378 40.72154, -73.98382 40.721... | \n", "POINT (-73.98593 40.72762) | \n", "12.0 | \n", "4.041667 | \n", "1652.0 | \n", "6668.5 | \n", "7.712478 | \n", "
\n", " | counts | \n", "rating | \n", "review_count | \n", "rate_rev | \n", "boba_index | \n", "
---|---|---|---|---|---|
count | \n", "93.000000 | \n", "93.000000 | \n", "93.000000 | \n", "93.000000 | \n", "93.000000 | \n", "
mean | \n", "4.451613 | \n", "4.018089 | \n", "399.408602 | \n", "1576.779570 | \n", "3.959228 | \n", "
std | \n", "6.289253 | \n", "0.472595 | \n", "812.981820 | \n", "3165.047052 | \n", "2.340969 | \n", "
min | \n", "1.000000 | \n", "2.000000 | \n", "1.000000 | \n", "2.000000 | \n", "1.103101 | \n", "
25% | \n", "1.000000 | \n", "3.833333 | \n", "32.000000 | \n", "124.000000 | \n", "2.481977 | \n", "
50% | \n", "2.000000 | \n", "4.000000 | \n", "114.000000 | \n", "477.500000 | \n", "3.150041 | \n", "
75% | \n", "5.000000 | \n", "4.333333 | \n", "384.000000 | \n", "1470.500000 | \n", "4.826066 | \n", "
max | \n", "40.000000 | \n", "5.000000 | \n", "5093.000000 | \n", "19257.000000 | \n", "13.189555 | \n", "