{ "cells": [ { "cell_type": "markdown", "id": "champion-multimedia", "metadata": {}, "source": [ "# Obsessed with Boba? Analyzing Bubble Tea Shops in NYC Using the Yelp Fusion API\n", "Exploratory Data Analysis" ] }, { "cell_type": "code", "execution_count": 1, "id": "6fd94ed8", "metadata": {}, "outputs": [], "source": [ "# # 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 \n", "\n", "import pandas as pd\n", "import numpy as np\n", "import geopandas as gpd\n", "import matplotlib.pyplot as plt\n", "import seaborn as sns\n", "\n", "%matplotlib inline\n", "sns.set(color_codes=True)" ] }, { "cell_type": "code", "execution_count": 2, "id": "00399d87", "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", " | 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", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
409 | \n", "QBebLBqhiuDlWasPgp6s4Q | \n", "tbaar-flushing-5 | \n", "TBaar | \n", "https://s3-media1.fl.yelpcdn.com/bphoto/bgao-b... | \n", "False | \n", "https://www.yelp.com/biz/tbaar-flushing-5?adju... | \n", "2 | \n", "[{'alias': 'bubbletea', 'title': 'Bubble Tea'}] | \n", "3.5 | \n", "{'latitude': 40.759357, 'longitude': -73.830396} | \n", "['pickup', 'delivery'] | \n", "NaN | \n", "{'address1': '135-52 Roosevelt Ave', 'address2... | \n", "NaN | \n", "NaN | \n", "15054.917573 | \n", "40.759357 | \n", "-73.830396 | \n", "POINT (-73.83039599999999 40.759357) | \n", "
410 | \n", "7apqk24GsFC9dptoD5dDZg | \n", "uncleman-cafe-new-york | \n", "Uncleman Cafe | \n", "NaN | \n", "False | \n", "https://www.yelp.com/biz/uncleman-cafe-new-yor... | \n", "1 | \n", "[{'alias': 'desserts', 'title': 'Desserts'}, {... | \n", "1.0 | \n", "{'latitude': 40.71781, 'longitude': -73.99795} | \n", "[] | \n", "NaN | \n", "{'address1': '122 Mulberry St', 'address2': No... | \n", "1.212967e+10 | \n", "(212) 966-6206 | \n", "1414.238245 | \n", "40.717810 | \n", "-73.997950 | \n", "POINT (-73.99795 40.71781) | \n", "
411 | \n", "Vz6hbICqQfyMWq9wzAKakw | \n", "tbaar-flushing-4 | \n", "TBaar | \n", "https://s3-media1.fl.yelpcdn.com/bphoto/phUYWa... | \n", "False | \n", "https://www.yelp.com/biz/tbaar-flushing-4?adju... | \n", "6 | \n", "[{'alias': 'bubbletea', 'title': 'Bubble Tea'}... | \n", "4.0 | \n", "{'latitude': 40.7613116, 'longitude': -73.8308... | \n", "[] | \n", "NaN | \n", "{'address1': '37-11 Main St', 'address2': '', ... | \n", "NaN | \n", "NaN | \n", "15147.410738 | \n", "40.761312 | \n", "-73.830812 | \n", "POINT (-73.8308122 40.7613116) | \n", "
412 | \n", "YBgAPbviWYtVP2gAUhc7_A | \n", "t-baar-flushing | \n", "TBaar | \n", "https://s3-media4.fl.yelpcdn.com/bphoto/8pk-_Q... | \n", "False | \n", "https://www.yelp.com/biz/t-baar-flushing?adjus... | \n", "8 | \n", "[{'alias': 'bubbletea', 'title': 'Bubble Tea'}] | \n", "3.5 | \n", "{'latitude': 40.7587509, 'longitude': -73.830162} | \n", "[] | \n", "$ | \n", "{'address1': '135-36 40th Rd', 'address2': '',... | \n", "NaN | \n", "NaN | \n", "15045.970192 | \n", "40.758751 | \n", "-73.830162 | \n", "POINT (-73.830162 40.7587509) | \n", "
413 | \n", "f5UVQXvDpOrrIZdCjsw47w | \n", "maxins-cafe-flushing | \n", "Maxin's Cafe | \n", "https://s3-media1.fl.yelpcdn.com/bphoto/S3vWvD... | \n", "False | \n", "https://www.yelp.com/biz/maxins-cafe-flushing?... | \n", "15 | \n", "[{'alias': 'bakeries', 'title': 'Bakeries'}, {... | \n", "3.5 | \n", "{'latitude': 40.7585, 'longitude': -73.83064} | \n", "[] | \n", "$ | \n", "{'address1': '135-24 40th Rd', 'address2': '',... | \n", "1.718887e+10 | \n", "(718) 886-9200 | \n", "14997.842205 | \n", "40.758500 | \n", "-73.830640 | \n", "POINT (-73.83064 40.7585) | \n", "
\n", " | null_count | \n", "null_perc | \n", "
---|---|---|
price | \n", "156 | \n", "37.68 | \n", "
display_phone | \n", "52 | \n", "12.56 | \n", "
phone | \n", "52 | \n", "12.56 | \n", "
image_url | \n", "5 | \n", "1.21 | \n", "
id | \n", "0 | \n", "0.00 | \n", "
transactions | \n", "0 | \n", "0.00 | \n", "
longitude | \n", "0 | \n", "0.00 | \n", "
latitude | \n", "0 | \n", "0.00 | \n", "
distance | \n", "0 | \n", "0.00 | \n", "
location | \n", "0 | \n", "0.00 | \n", "
coordinates | \n", "0 | \n", "0.00 | \n", "
alias | \n", "0 | \n", "0.00 | \n", "
rating | \n", "0 | \n", "0.00 | \n", "
categories | \n", "0 | \n", "0.00 | \n", "
review_count | \n", "0 | \n", "0.00 | \n", "
url | \n", "0 | \n", "0.00 | \n", "
is_closed | \n", "0 | \n", "0.00 | \n", "
name | \n", "0 | \n", "0.00 | \n", "
geometry | \n", "0 | \n", "0.00 | \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", " | 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", " | name | \n", "counts | \n", "
---|---|---|
0 | \n", "Kung Fu Tea | \n", "26 | \n", "
1 | \n", "Vivi Bubble Tea | \n", "25 | \n", "
2 | \n", "Gong Cha | \n", "24 | \n", "
3 | \n", "CoCo Fresh Tea & Juice | \n", "10 | \n", "
4 | \n", "Möge Tee | \n", "9 | \n", "
... | \n", "... | \n", "... | \n", "
254 | \n", "Chokolat Patisserie & Culture Tea Bar | \n", "1 | \n", "
255 | \n", "Siips Bubble | \n", "1 | \n", "
256 | \n", "Yummy Boba Desserts | \n", "1 | \n", "
257 | \n", "Bread & Joe | \n", "1 | \n", "
258 | \n", "Maxin's Cafe | \n", "1 | \n", "
259 rows × 2 columns
\n", "\n", " | index | \n", "name | \n", "
---|---|---|
0 | \n", "Kung Fu Tea | \n", "26 | \n", "
1 | \n", "Vivi Bubble Tea | \n", "25 | \n", "
2 | \n", "Gong Cha | \n", "24 | \n", "
3 | \n", "CoCo Fresh Tea & Juice | \n", "10 | \n", "
4 | \n", "Möge Tee | \n", "9 | \n", "
... | \n", "... | \n", "... | \n", "
254 | \n", "Chokolat Patisserie & Culture Tea Bar | \n", "1 | \n", "
255 | \n", "Siips Bubble | \n", "1 | \n", "
256 | \n", "Yummy Boba Desserts | \n", "1 | \n", "
257 | \n", "Bread & Joe | \n", "1 | \n", "
258 | \n", "Maxin's Cafe | \n", "1 | \n", "
259 rows × 2 columns
\n", "\n", " | name | \n", "review_count | \n", "
---|---|---|
0 | \n", "Ten Ren's Tea Time | \n", "656.0 | \n", "
1 | \n", "Hanco's | \n", "519.0 | \n", "
2 | \n", "Ajisen Ramen | \n", "438.0 | \n", "
3 | \n", "Teado Tea Shop | \n", "428.0 | \n", "
4 | \n", "520 Dessert | \n", "358.0 | \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", "transactions | \n", "price | \n", "location | \n", "phone | \n", "display_phone | \n", "distance | \n", "latitude | \n", "longitude | \n", "geometry | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
170 | \n", "bn0zZ9nT_j1INOwfpxWmEw | \n", "tiger-sugar-flushing | \n", "tigersugar | \n", "https://s3-media2.fl.yelpcdn.com/bphoto/hai87B... | \n", "False | \n", "https://www.yelp.com/biz/tiger-sugar-flushing?... | \n", "740 | \n", "[{'alias': 'bubbletea', 'title': 'Bubble Tea'}... | \n", "4.0 | \n", "{'latitude': 40.75922023369396, 'longitude': -... | \n", "['pickup', 'delivery'] | \n", "$$ | \n", "{'address1': '40-10 Main St', 'address2': 'Ste... | \n", "1.347732e+10 | \n", "(347) 732-4001 | \n", "15055.920826 | \n", "40.759220 | \n", "-73.830305 | \n", "POINT (-73.83030496537685 40.75922023369396) | \n", "
90 | \n", "NqnYnZtajJ4Y-Lmxa26VdA | \n", "hancos-brooklyn | \n", "Hanco's | \n", "https://s3-media3.fl.yelpcdn.com/bphoto/_vQWWX... | \n", "False | \n", "https://www.yelp.com/biz/hancos-brooklyn?adjus... | \n", "704 | \n", "[{'alias': 'vietnamese', 'title': 'Vietnamese'... | \n", "4.0 | \n", "{'latitude': 40.6870318621828, 'longitude': -7... | \n", "['pickup', 'delivery'] | \n", "$ | \n", "{'address1': '134 Smith St', 'address2': '', '... | \n", "1.718859e+10 | \n", "(718) 858-6818 | \n", "2073.182530 | \n", "40.687032 | \n", "-73.990429 | \n", "POINT (-73.9904292380982 40.6870318621828) | \n", "
51 | \n", "WxNlqGSsj_2TCodkx9Sa4A | \n", "vivi-bubble-tea-new-york-6 | \n", "Vivi Bubble Tea | \n", "https://s3-media2.fl.yelpcdn.com/bphoto/Fw3SYB... | \n", "False | \n", "https://www.yelp.com/biz/vivi-bubble-tea-new-y... | \n", "658 | \n", "[{'alias': 'bubbletea', 'title': 'Bubble Tea'}] | \n", "4.0 | \n", "{'latitude': 40.715099, 'longitude': -73.997535} | \n", "['pickup', 'delivery'] | \n", "$ | \n", "{'address1': '49 Bayard St', 'address2': '', '... | \n", "1.212567e+10 | \n", "(212) 566-6833 | \n", "1114.073275 | \n", "40.715099 | \n", "-73.997535 | \n", "POINT (-73.997535 40.715099) | \n", "
45 | \n", "SqVHETmH6bf3rPKmdftvvw | \n", "ten-rens-tea-time-new-york-2 | \n", "Ten Ren's Tea Time | \n", "https://s3-media1.fl.yelpcdn.com/bphoto/UChdn5... | \n", "False | \n", "https://www.yelp.com/biz/ten-rens-tea-time-new... | \n", "656 | \n", "[{'alias': 'bubbletea', 'title': 'Bubble Tea'}] | \n", "4.0 | \n", "{'latitude': 40.7163819, 'longitude': -73.9982... | \n", "['delivery'] | \n", "$$ | \n", "{'address1': '73 Mott St', 'address2': '', 'ad... | \n", "1.212733e+10 | \n", "(212) 732-7178 | \n", "1261.450313 | \n", "40.716382 | \n", "-73.998268 | \n", "POINT (-73.99826830000001 40.7163819) | \n", "
266 | \n", "ZLo3HRSSvN--Mw4eCBLxCg | \n", "mango-mango-dessert-flushing-3 | \n", "Mango Mango Dessert | \n", "https://s3-media3.fl.yelpcdn.com/bphoto/X7bnQ9... | \n", "False | \n", "https://www.yelp.com/biz/mango-mango-dessert-f... | \n", "622 | \n", "[{'alias': 'desserts', 'title': 'Desserts'}, {... | \n", "4.0 | \n", "{'latitude': 40.7603809317017, 'longitude': -7... | \n", "['pickup', 'delivery'] | \n", "$ | \n", "{'address1': '136-28 39th Ave', 'address2': ''... | \n", "1.917563e+10 | \n", "(917) 563-1847 | \n", "15199.500511 | \n", "40.760381 | \n", "-73.829452 | \n", "POINT (-73.8294516357502 40.7603809317017) | \n", "
\n", " | price | \n", "counts | \n", "
---|---|---|
0 | \n", "$ | \n", "166 | \n", "
1 | \n", "$$ | \n", "91 | \n", "
2 | \n", "$$$$ | \n", "1 | \n", "
\n", " | price | \n", "counts | \n", "
---|---|---|
0 | \n", "1 | \n", "166 | \n", "
1 | \n", "2 | \n", "91 | \n", "
2 | \n", "4 | \n", "1 | \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", "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", " | 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.99622 40.71917) | \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.99710 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.98454 40.72060) | \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.98775 40.72880) | \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.98919 40.73552) | \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", "
16 | \n", "DbhBca8LzskjS0B-L4QfZg | \n", "tiger-sugar-new-york | \n", "tigersugar | \n", "https://s3-media3.fl.yelpcdn.com/bphoto/5wNVyj... | \n", "False | \n", "https://www.yelp.com/biz/tiger-sugar-new-york?... | \n", "515 | \n", "[{'alias': 'bubbletea', 'title': 'Bubble Tea'}] | \n", "4.0 | \n", "{'latitude': 40.717891007822274, 'longitude': ... | \n", "... | \n", "-73.999780 | \n", "POINT (-73.99978 40.71789) | \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", "
29 | \n", "bxCjNLVDQggNTbpviV0RMw | \n", "lazy-sundaes-new-york-4 | \n", "Lazy Sundaes | \n", "https://s3-media3.fl.yelpcdn.com/bphoto/iDul5E... | \n", "False | \n", "https://www.yelp.com/biz/lazy-sundaes-new-york... | \n", "65 | \n", "[{'alias': 'bubbletea', 'title': 'Bubble Tea'}... | \n", "4.0 | \n", "{'latitude': 40.7189689, 'longitude': -74.0006... | \n", "... | \n", "-74.000677 | \n", "POINT (-74.00068 40.71897) | \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", "
60 | \n", "jsJdz6pvyYZjtut9vkUwBw | \n", "yaya-tea-grand-new-york-2 | \n", "Yaya Tea Grand | \n", "https://s3-media2.fl.yelpcdn.com/bphoto/iutBCc... | \n", "False | \n", "https://www.yelp.com/biz/yaya-tea-grand-new-yo... | \n", "295 | \n", "[{'alias': 'bubbletea', 'title': 'Bubble Tea'}... | \n", "4.0 | \n", "{'latitude': 40.7192268371582, 'longitude': -7... | \n", "... | \n", "-73.996277 | \n", "POINT (-73.99628 40.71923) | \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", "
72 | \n", "uge-Lp_kY1J6Z4CzzceULw | \n", "honestea-new-york | \n", "Honestea | \n", "https://s3-media1.fl.yelpcdn.com/bphoto/77X7Xd... | \n", "False | \n", "https://www.yelp.com/biz/honestea-new-york?adj... | \n", "104 | \n", "[{'alias': 'bubbletea', 'title': 'Bubble Tea'}... | \n", "3.5 | \n", "{'latitude': 40.71789, 'longitude': -73.99692} | \n", "... | \n", "-73.996920 | \n", "POINT (-73.99692 40.71789) | \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", "
5 rows × 27 columns
\n", "\n", " | ntaname | \n", "shape_area | \n", "counts | \n", "counts_squaremile | \n", "
---|---|---|---|---|
0 | \n", "Flushing | \n", "3.786424e+07 | \n", "40 | \n", "29.450898 | \n", "
1 | \n", "Chinatown | \n", "1.450188e+07 | \n", "28 | \n", "53.827184 | \n", "
2 | \n", "Sunset Park East | \n", "2.711007e+07 | \n", "23 | \n", "23.651849 | \n", "
3 | \n", "Hunters Point-Sunnyside-West Maspeth | \n", "1.024191e+08 | \n", "19 | \n", "5.171787 | \n", "
4 | \n", "Elmhurst | \n", "3.267480e+07 | \n", "17 | \n", "14.504535 | \n", "