2 NYC Yelp API.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "2921ddaa",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Standard Imports\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "\n",
    "# Additional Imports\n",
    "import os, json, math, time\n",
    "from yelpapi import YelpAPI\n",
    "from tqdm.notebook import tqdm_notebook"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "c83bbbac",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Load API Credentials\n",
    "with open('/Users/davyd/.secret/yelp_api.json','r') as f:\n",
    "    login = json.load(f)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "41d31fd3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict_keys(['client-id', 'api-key'])"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "dict_keys(['client-id', 'api-key'])"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Login Key\n",
    "login.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "bc2fc4f3",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Instantiate YelpAPI Variable\n",
    "yelp = YelpAPI(login['api-key'],timeout_s=5.0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "e9f638de",
   "metadata": {},
   "outputs": [],
   "source": [
    "# set our API call parameters and filename before the first call\n",
    "location = 'Manhattan'\n",
    "term = 'Pizza'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "f1e0903c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Manhattan'"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "'Manhattan'"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "location.split(',')[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "87673087",
   "metadata": {},
   "outputs": [],
   "source": [
    "## Specify fodler for saving data\n",
    "\n",
    "\n",
    "FOLDER ='Data/'\n",
    "\n",
    "os.makedirs(FOLDER,exist_ok=True)\n",
    "\n",
    "# Specifying JSON_FILE filename (can include a folder)\n",
    "JSON_FILE = FOLDER+f\"{location.split(',')[0]}-{term}.json\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "012d2c60",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[i] Data/Manhattan-Pizza.json already exists.\n",
      "[i] Data/Manhattan-Pizza.json already exists.\n"
     ]
    }
   ],
   "source": [
    "## Check if JSON_FILE exists\n",
    "file_exists = os.path.isfile(JSON_FILE)\n",
    "\n",
    "## If it does not exist: \n",
    "if file_exists ==False:\n",
    "    ## CREATE ANY NEEDED FOLDERS\n",
    "    # Get the Folder Name only\n",
    "    folder = os.path.dirname(JSON_FILE)\n",
    "    \n",
    "    ## If JSON_FILE included a folder:\n",
    "    if len(folder)>0:\n",
    "        # create the folder\n",
    "        os.makedirs(folder,exist_ok=True)\n",
    "        \n",
    "    ## INFORM USER AND SAVE EMPTY LIST\n",
    "    print(f\"[i] {JSON_FILE} not found. Saving empty list to file.\")\n",
    "    \n",
    "    \n",
    "    ## save the first page of results\n",
    "    with open(JSON_FILE,'w')as f:\n",
    "        json.dump([],f)\n",
    "        \n",
    "## If it exists, inform user\n",
    "else:\n",
    "       print(f\"[i] {JSON_FILE} already exists.\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "74506d00",
   "metadata": {},
   "outputs": [],
   "source": [
    "results = yelp.search_query(term=term,location = location)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "1e95b2e8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "dict"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(results)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "646a2323",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "3"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(results)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "32447993",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict_keys(['businesses', 'total', 'region'])"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "dict_keys(['businesses', 'total', 'region'])"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "results.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "1fc54f96",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "10100"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "10100"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "results['total']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "4885f0c6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'center': {'longitude': -73.96957397460938, 'latitude': 40.75917470627005}}"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "{'center': {'longitude': -73.96957397460938, 'latitude': 40.75917470627005}}"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "results['region']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "6dbecd00",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'id': 'KEEXuHCYhsQJ-zpJhu98bA',\n",
       "  'alias': 'joes-pizza-new-york-148',\n",
       "  'name': \"Joe's Pizza\",\n",
       "  'image_url': 'https://s3-media4.fl.yelpcdn.com/bphoto/FluVgKezP5ifs7greHV8Qg/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/joes-pizza-new-york-148?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 2307,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'}],\n",
       "  'rating': 4.2,\n",
       "  'coordinates': {'latitude': 40.7547, 'longitude': -73.98696},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'price': '$',\n",
       "  'location': {'address1': '1435 Broadway',\n",
       "   'address2': '',\n",
       "   'address3': None,\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10018',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['1435 Broadway', 'New York, NY 10018']},\n",
       "  'phone': '+16465594878',\n",
       "  'display_phone': '(646) 559-4878',\n",
       "  'distance': 1552.86453787486},\n",
       " {'id': 'oRdM7n-AfBPBGAlH4Q0Sag',\n",
       "  'alias': 'my-pie-pizzeria-romana-new-york-2',\n",
       "  'name': 'My Pie Pizzeria Romana',\n",
       "  'image_url': 'https://s3-media1.fl.yelpcdn.com/bphoto/b3BIzM5lgmuF-W7owEx5xQ/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/my-pie-pizzeria-romana-new-york-2?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 937,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'}],\n",
       "  'rating': 4.4,\n",
       "  'coordinates': {'latitude': 40.7608512, 'longitude': -73.9694809},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'price': '$$',\n",
       "  'location': {'address1': '690 Lexington Ave',\n",
       "   'address2': '',\n",
       "   'address3': '',\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10022',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['690 Lexington Ave', 'New York, NY 10022']},\n",
       "  'phone': '+12123171850',\n",
       "  'display_phone': '(212) 317-1850',\n",
       "  'distance': 186.58214310058082},\n",
       " {'id': 'G9hV4H2iGpWD8RoUpjtokg',\n",
       "  'alias': 'l-industrie-pizzeria-new-york',\n",
       "  'name': 'L’industrie Pizzeria',\n",
       "  'image_url': 'https://s3-media4.fl.yelpcdn.com/bphoto/Hzdlv1PI6ZM60HzVwxUc8A/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/l-industrie-pizzeria-new-york?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 322,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'}],\n",
       "  'rating': 4.6,\n",
       "  'coordinates': {'latitude': 40.73323443774397, 'longitude': -74.0049081},\n",
       "  'transactions': [],\n",
       "  'location': {'address1': '104 Christopher St',\n",
       "   'address2': '',\n",
       "   'address3': None,\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10014',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['104 Christopher St', 'New York, NY 10014']},\n",
       "  'phone': '+12122560648',\n",
       "  'display_phone': '(212) 256-0648',\n",
       "  'distance': 4144.896541579684},\n",
       " {'id': 'zj8Lq1T8KIC5zwFief15jg',\n",
       "  'alias': 'prince-street-pizza-new-york-2',\n",
       "  'name': 'Prince Street Pizza',\n",
       "  'image_url': 'https://s3-media1.fl.yelpcdn.com/bphoto/Jo9jBP5y6G_bG_g3H31fiw/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/prince-street-pizza-new-york-2?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 5346,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'},\n",
       "   {'alias': 'italian', 'title': 'Italian'}],\n",
       "  'rating': 4.3,\n",
       "  'coordinates': {'latitude': 40.72308755605564,\n",
       "   'longitude': -73.99453001177575},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'price': '$',\n",
       "  'location': {'address1': '27 Prince St',\n",
       "   'address2': None,\n",
       "   'address3': '',\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10012',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['27 Prince St', 'New York, NY 10012']},\n",
       "  'phone': '+12129664100',\n",
       "  'display_phone': '(212) 966-4100',\n",
       "  'distance': 4530.158358332591},\n",
       " {'id': 'EXQ0x2W9RTydIlHAU9MU1A',\n",
       "  'alias': 'mimis-pizza-east-86th-new-york-2',\n",
       "  'name': \"Mimi's Pizza - East 86th\",\n",
       "  'image_url': 'https://s3-media3.fl.yelpcdn.com/bphoto/btcWJW_uNq7JEwk2wFMtiQ/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/mimis-pizza-east-86th-new-york-2?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 211,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'}],\n",
       "  'rating': 4.5,\n",
       "  'coordinates': {'latitude': 40.778638, 'longitude': -73.952895},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'location': {'address1': '217 E 86th St',\n",
       "   'address2': None,\n",
       "   'address3': '',\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10028',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['217 E 86th St', 'New York, NY 10028']},\n",
       "  'phone': '+16468612518',\n",
       "  'display_phone': '(646) 861-2518',\n",
       "  'distance': 2577.9373154983723},\n",
       " {'id': 'GgdR6L49eKH5drPaOYOOPQ',\n",
       "  'alias': 'pops-pizzas-new-york',\n",
       "  'name': \"Pop's Pizzas\",\n",
       "  'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/K51H3tN_XFj8LCYv5raNWQ/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/pops-pizzas-new-york?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 231,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'}],\n",
       "  'rating': 4.6,\n",
       "  'coordinates': {'latitude': 40.767085, 'longitude': -73.983103},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'price': '$',\n",
       "  'location': {'address1': '301 West 57th St',\n",
       "   'address2': 'Ground Fl',\n",
       "   'address3': '',\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10019',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['301 West 57th St', 'Ground Fl', 'New York, NY 10019']},\n",
       "  'phone': '+12127848863',\n",
       "  'display_phone': '(212) 784-8863',\n",
       "  'distance': 1440.0598002104812},\n",
       " {'id': '-9NO2IDCJMyNGZMAQ1-VQw',\n",
       "  'alias': 'ny-pizza-suprema-new-york',\n",
       "  'name': 'NY Pizza Suprema',\n",
       "  'image_url': 'https://s3-media4.fl.yelpcdn.com/bphoto/EqbDXneMuQP6pw6GemVdQA/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/ny-pizza-suprema-new-york?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 2682,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'}],\n",
       "  'rating': 4.3,\n",
       "  'coordinates': {'latitude': 40.7502059936523,\n",
       "   'longitude': -73.9953231811523},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'price': '$$',\n",
       "  'location': {'address1': '413 8th Ave',\n",
       "   'address2': '',\n",
       "   'address3': '',\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10001',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['413 8th Ave', 'New York, NY 10001']},\n",
       "  'phone': '+12125948939',\n",
       "  'display_phone': '(212) 594-8939',\n",
       "  'distance': 2387.061954989499},\n",
       " {'id': 'v1DHGRNCH9247WLYoaoA9A',\n",
       "  'alias': 'l-industrie-pizzeria-brooklyn',\n",
       "  'name': \"L'industrie Pizzeria\",\n",
       "  'image_url': 'https://s3-media1.fl.yelpcdn.com/bphoto/1-VBwAOj0g9YKYey3V-Z6Q/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/l-industrie-pizzeria-brooklyn?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 1368,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'}],\n",
       "  'rating': 4.7,\n",
       "  'coordinates': {'latitude': 40.71162, 'longitude': -73.95783},\n",
       "  'transactions': ['delivery'],\n",
       "  'price': '$$',\n",
       "  'location': {'address1': '254 S 2nd St',\n",
       "   'address2': '',\n",
       "   'address3': '',\n",
       "   'city': 'Brooklyn',\n",
       "   'zip_code': '11211',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['254 S 2nd St', 'Brooklyn, NY 11211']},\n",
       "  'phone': '+17185990002',\n",
       "  'display_phone': '(718) 599-0002',\n",
       "  'distance': 5382.969880738413},\n",
       " {'id': 'ypJRRRKZtaNad--1EbRBTg',\n",
       "  'alias': 'roma-pizza-and-restaurant-new-york',\n",
       "  'name': 'Roma Pizza & Restaurant',\n",
       "  'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/LA5DKU89rzsD41Hta-ECpg/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/roma-pizza-and-restaurant-new-york?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 52,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'},\n",
       "   {'alias': 'seafood', 'title': 'Seafood'},\n",
       "   {'alias': 'catering', 'title': 'Caterers'}],\n",
       "  'rating': 4.7,\n",
       "  'coordinates': {'latitude': 40.751211, 'longitude': -73.986364},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'location': {'address1': '980 6th Ave',\n",
       "   'address2': None,\n",
       "   'address3': '',\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10018',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['980 6th Ave', 'New York, NY 10018']},\n",
       "  'phone': '+12124578555',\n",
       "  'display_phone': '(212) 457-8555',\n",
       "  'distance': 1669.7516613878195},\n",
       " {'id': 'YchMTqpM6xksrpqXR0YUrQ',\n",
       "  'alias': 'xeno-s-pizza-new-york',\n",
       "  'name': 'Xeno’s Pizza',\n",
       "  'image_url': 'https://s3-media1.fl.yelpcdn.com/bphoto/dVkXWNvDYPgZ7OesI246Kw/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/xeno-s-pizza-new-york?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 39,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'}],\n",
       "  'rating': 4.2,\n",
       "  'coordinates': {'latitude': 40.75728, 'longitude': -73.97008},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'location': {'address1': '163 E 52nd St',\n",
       "   'address2': '',\n",
       "   'address3': None,\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10022',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['163 E 52nd St', 'New York, NY 10022']},\n",
       "  'phone': '+16469520030',\n",
       "  'display_phone': '(646) 952-0030',\n",
       "  'distance': 210.61563672529866},\n",
       " {'id': 'AOZlppihRNG8Y2N4Jid30A',\n",
       "  'alias': 'brooklyn-pizza-masters-new-york',\n",
       "  'name': 'Brooklyn Pizza Masters',\n",
       "  'image_url': 'https://s3-media1.fl.yelpcdn.com/bphoto/Dko2ofSegIWoF3n57Y5ISQ/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/brooklyn-pizza-masters-new-york?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 258,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'},\n",
       "   {'alias': 'salad', 'title': 'Salad'}],\n",
       "  'rating': 4.3,\n",
       "  'coordinates': {'latitude': 40.75869828079016,\n",
       "   'longitude': -73.962919097227},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'location': {'address1': '1055 1st Ave',\n",
       "   'address2': '',\n",
       "   'address3': None,\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10022',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['1055 1st Ave', 'New York, NY 10022']},\n",
       "  'phone': '+16466697757',\n",
       "  'display_phone': '(646) 669-7757',\n",
       "  'distance': 563.0113927421821},\n",
       " {'id': 'tRIHhPKryUZ56SfIz6mLiA',\n",
       "  'alias': 'angelos-coal-oven-pizzeria-new-york',\n",
       "  'name': \"Angelo's Coal Oven Pizzeria\",\n",
       "  'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/0XEf78-yZ-plQXosA3oFlw/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/angelos-coal-oven-pizzeria-new-york?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 1329,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'},\n",
       "   {'alias': 'italian', 'title': 'Italian'}],\n",
       "  'rating': 4.0,\n",
       "  'coordinates': {'latitude': 40.76492, 'longitude': -73.97794},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'price': '$$',\n",
       "  'location': {'address1': '117 W 57th St',\n",
       "   'address2': '',\n",
       "   'address3': '',\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10019',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['117 W 57th St', 'New York, NY 10019']},\n",
       "  'phone': '+12123334333',\n",
       "  'display_phone': '(212) 333-4333',\n",
       "  'distance': 951.371290575802},\n",
       " {'id': 'KEgdfVEVVgJFnGFiLNPDzQ',\n",
       "  'alias': 'sofia-pizza-shoppe-new-york',\n",
       "  'name': 'Sofia Pizza Shoppe',\n",
       "  'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/XTOP8koYT-ccWAPx2cUIKg/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/sofia-pizza-shoppe-new-york?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 262,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'}],\n",
       "  'rating': 4.4,\n",
       "  'coordinates': {'latitude': 40.75674, 'longitude': -73.96431},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'price': '$',\n",
       "  'location': {'address1': '989 1st Ave',\n",
       "   'address2': '',\n",
       "   'address3': None,\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10022',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['989 1st Ave', 'New York, NY 10022']},\n",
       "  'phone': '+12128888816',\n",
       "  'display_phone': '(212) 888-8816',\n",
       "  'distance': 520.3312331060953},\n",
       " {'id': 'iUnELVbiyEszV8DiVB3CTA',\n",
       "  'alias': 'see-no-evil-pizza-new-york',\n",
       "  'name': 'See No Evil Pizza',\n",
       "  'image_url': 'https://s3-media3.fl.yelpcdn.com/bphoto/XOTyidNS18dtgwDU41iSQw/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/see-no-evil-pizza-new-york?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 17,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'}],\n",
       "  'rating': 4.8,\n",
       "  'coordinates': {'latitude': 40.761482, 'longitude': -73.984508},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'location': {'address1': '210 W 50th St',\n",
       "   'address2': 'Conourse  1',\n",
       "   'address3': None,\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10019',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['210 W 50th St', 'Conourse  1', 'New York, NY 10019']},\n",
       "  'phone': '',\n",
       "  'display_phone': '',\n",
       "  'distance': 1284.2877252969977},\n",
       " {'id': 'XujJhk-uQQezYgxyx-YN5Q',\n",
       "  'alias': 'parla-new-york',\n",
       "  'name': 'Parla',\n",
       "  'image_url': 'https://s3-media3.fl.yelpcdn.com/bphoto/65VnWTH-CoFLfWoFK__qjg/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/parla-new-york?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 91,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'},\n",
       "   {'alias': 'pastashops', 'title': 'Pasta Shops'},\n",
       "   {'alias': 'cocktailbars', 'title': 'Cocktail Bars'}],\n",
       "  'rating': 4.3,\n",
       "  'coordinates': {'latitude': 40.779604142118245,\n",
       "   'longitude': -73.9775782278624},\n",
       "  'transactions': [],\n",
       "  'price': '$$',\n",
       "  'location': {'address1': '320 Columbus Ave',\n",
       "   'address2': '',\n",
       "   'address3': None,\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10023',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['320 Columbus Ave', 'New York, NY 10023']},\n",
       "  'phone': '+12127029006',\n",
       "  'display_phone': '(212) 702-9006',\n",
       "  'distance': 2369.5437016537244},\n",
       " {'id': 'V4-ds3mhlB7uLLY9qfZTJQ',\n",
       "  'alias': 'abitinos-pizzeria-new-york-17',\n",
       "  'name': \"Abitino's Pizzeria\",\n",
       "  'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/7RzwMz38XT1vtEza41hN5A/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/abitinos-pizzeria-new-york-17?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 69,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'}],\n",
       "  'rating': 4.3,\n",
       "  'coordinates': {'latitude': 40.75958, 'longitude': -73.97747},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'location': {'address1': '5 West 51 St',\n",
       "   'address2': None,\n",
       "   'address3': '',\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10020',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['5 West 51 St', 'New York, NY 10020']},\n",
       "  'phone': '+12123566181',\n",
       "  'display_phone': '(212) 356-6181',\n",
       "  'distance': 667.90284054447},\n",
       " {'id': '2MuvmwOuwvGOWkBimhniLA',\n",
       "  'alias': 'la-bellezza-new-york',\n",
       "  'name': 'La Bellezza',\n",
       "  'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/75SVEMwv8WbLIB4eYzPdLA/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/la-bellezza-new-york?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 309,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'}],\n",
       "  'rating': 4.1,\n",
       "  'coordinates': {'latitude': 40.7557792663574,\n",
       "   'longitude': -73.9720153808594},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'price': '$',\n",
       "  'location': {'address1': '145 E 49th St',\n",
       "   'address2': '',\n",
       "   'address3': '',\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10017',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['145 E 49th St', 'New York, NY 10017']},\n",
       "  'phone': '+12128713223',\n",
       "  'display_phone': '(212) 871-3223',\n",
       "  'distance': 426.901060768092},\n",
       " {'id': '2-GsvFaQpVpbaIdwb9lSeQ',\n",
       "  'alias': 'andiamo-pizza-new-york-2',\n",
       "  'name': 'Andiamo Pizza',\n",
       "  'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/1p0cE3ZKgflstS6s__3fuQ/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/andiamo-pizza-new-york-2?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 212,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'},\n",
       "   {'alias': 'italian', 'title': 'Italian'},\n",
       "   {'alias': 'catering', 'title': 'Caterers'}],\n",
       "  'rating': 4.5,\n",
       "  'coordinates': {'latitude': 40.746144, 'longitude': -73.990189},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'location': {'address1': '818 6th Ave',\n",
       "   'address2': None,\n",
       "   'address3': '',\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10001',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['818 6th Ave', 'New York, NY 10001']},\n",
       "  'phone': '+12122542860',\n",
       "  'display_phone': '(212) 254-2860',\n",
       "  'distance': 2263.1122742182406},\n",
       " {'id': 'vVVmHacu2YAxKfpIjhfd1g',\n",
       "  'alias': 'norma-new-york-5',\n",
       "  'name': 'Norma',\n",
       "  'image_url': 'https://s3-media3.fl.yelpcdn.com/bphoto/qJKt5l2xSBUKOFRA6UOqVg/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/norma-new-york-5?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 670,\n",
       "  'categories': [{'alias': 'italian', 'title': 'Italian'},\n",
       "   {'alias': 'pizza', 'title': 'Pizza'}],\n",
       "  'rating': 4.4,\n",
       "  'coordinates': {'latitude': 40.743553, 'longitude': -73.980026},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'price': '$$',\n",
       "  'location': {'address1': '438 3rd Ave',\n",
       "   'address2': None,\n",
       "   'address3': '',\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10016',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['438 3rd Ave', 'New York, NY 10016']},\n",
       "  'phone': '+12128890600',\n",
       "  'display_phone': '(212) 889-0600',\n",
       "  'distance': 1942.2913842319626},\n",
       " {'id': 'WG639VkTjmK5dzydd1BBJA',\n",
       "  'alias': 'rubirosa-new-york-2',\n",
       "  'name': 'Rubirosa',\n",
       "  'image_url': 'https://s3-media3.fl.yelpcdn.com/bphoto/l0Phrnhhj78RFiDhLIOUyQ/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/rubirosa-new-york-2?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 3400,\n",
       "  'categories': [{'alias': 'italian', 'title': 'Italian'},\n",
       "   {'alias': 'pizza', 'title': 'Pizza'}],\n",
       "  'rating': 4.3,\n",
       "  'coordinates': {'latitude': 40.722766, 'longitude': -73.996233},\n",
       "  'transactions': ['pickup'],\n",
       "  'price': '$$',\n",
       "  'location': {'address1': '235 Mulberry St',\n",
       "   'address2': '',\n",
       "   'address3': '',\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10012',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['235 Mulberry St', 'New York, NY 10012']},\n",
       "  'phone': '+12129650500',\n",
       "  'display_phone': '(212) 965-0500',\n",
       "  'distance': 4629.739253785127}]"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/plain": [
       "[{'id': 'KEEXuHCYhsQJ-zpJhu98bA',\n",
       "  'alias': 'joes-pizza-new-york-148',\n",
       "  'name': \"Joe's Pizza\",\n",
       "  'image_url': 'https://s3-media4.fl.yelpcdn.com/bphoto/FluVgKezP5ifs7greHV8Qg/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/joes-pizza-new-york-148?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 2307,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'}],\n",
       "  'rating': 4.2,\n",
       "  'coordinates': {'latitude': 40.7547, 'longitude': -73.98696},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'price': '$',\n",
       "  'location': {'address1': '1435 Broadway',\n",
       "   'address2': '',\n",
       "   'address3': None,\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10018',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['1435 Broadway', 'New York, NY 10018']},\n",
       "  'phone': '+16465594878',\n",
       "  'display_phone': '(646) 559-4878',\n",
       "  'distance': 1552.86453787486},\n",
       " {'id': 'oRdM7n-AfBPBGAlH4Q0Sag',\n",
       "  'alias': 'my-pie-pizzeria-romana-new-york-2',\n",
       "  'name': 'My Pie Pizzeria Romana',\n",
       "  'image_url': 'https://s3-media1.fl.yelpcdn.com/bphoto/b3BIzM5lgmuF-W7owEx5xQ/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/my-pie-pizzeria-romana-new-york-2?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 937,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'}],\n",
       "  'rating': 4.4,\n",
       "  'coordinates': {'latitude': 40.7608512, 'longitude': -73.9694809},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'price': '$$',\n",
       "  'location': {'address1': '690 Lexington Ave',\n",
       "   'address2': '',\n",
       "   'address3': '',\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10022',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['690 Lexington Ave', 'New York, NY 10022']},\n",
       "  'phone': '+12123171850',\n",
       "  'display_phone': '(212) 317-1850',\n",
       "  'distance': 186.58214310058082},\n",
       " {'id': 'G9hV4H2iGpWD8RoUpjtokg',\n",
       "  'alias': 'l-industrie-pizzeria-new-york',\n",
       "  'name': 'L’industrie Pizzeria',\n",
       "  'image_url': 'https://s3-media4.fl.yelpcdn.com/bphoto/Hzdlv1PI6ZM60HzVwxUc8A/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/l-industrie-pizzeria-new-york?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 322,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'}],\n",
       "  'rating': 4.6,\n",
       "  'coordinates': {'latitude': 40.73323443774397, 'longitude': -74.0049081},\n",
       "  'transactions': [],\n",
       "  'location': {'address1': '104 Christopher St',\n",
       "   'address2': '',\n",
       "   'address3': None,\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10014',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['104 Christopher St', 'New York, NY 10014']},\n",
       "  'phone': '+12122560648',\n",
       "  'display_phone': '(212) 256-0648',\n",
       "  'distance': 4144.896541579684},\n",
       " {'id': 'zj8Lq1T8KIC5zwFief15jg',\n",
       "  'alias': 'prince-street-pizza-new-york-2',\n",
       "  'name': 'Prince Street Pizza',\n",
       "  'image_url': 'https://s3-media1.fl.yelpcdn.com/bphoto/Jo9jBP5y6G_bG_g3H31fiw/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/prince-street-pizza-new-york-2?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 5346,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'},\n",
       "   {'alias': 'italian', 'title': 'Italian'}],\n",
       "  'rating': 4.3,\n",
       "  'coordinates': {'latitude': 40.72308755605564,\n",
       "   'longitude': -73.99453001177575},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'price': '$',\n",
       "  'location': {'address1': '27 Prince St',\n",
       "   'address2': None,\n",
       "   'address3': '',\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10012',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['27 Prince St', 'New York, NY 10012']},\n",
       "  'phone': '+12129664100',\n",
       "  'display_phone': '(212) 966-4100',\n",
       "  'distance': 4530.158358332591},\n",
       " {'id': 'EXQ0x2W9RTydIlHAU9MU1A',\n",
       "  'alias': 'mimis-pizza-east-86th-new-york-2',\n",
       "  'name': \"Mimi's Pizza - East 86th\",\n",
       "  'image_url': 'https://s3-media3.fl.yelpcdn.com/bphoto/btcWJW_uNq7JEwk2wFMtiQ/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/mimis-pizza-east-86th-new-york-2?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 211,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'}],\n",
       "  'rating': 4.5,\n",
       "  'coordinates': {'latitude': 40.778638, 'longitude': -73.952895},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'location': {'address1': '217 E 86th St',\n",
       "   'address2': None,\n",
       "   'address3': '',\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10028',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['217 E 86th St', 'New York, NY 10028']},\n",
       "  'phone': '+16468612518',\n",
       "  'display_phone': '(646) 861-2518',\n",
       "  'distance': 2577.9373154983723},\n",
       " {'id': 'GgdR6L49eKH5drPaOYOOPQ',\n",
       "  'alias': 'pops-pizzas-new-york',\n",
       "  'name': \"Pop's Pizzas\",\n",
       "  'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/K51H3tN_XFj8LCYv5raNWQ/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/pops-pizzas-new-york?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 231,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'}],\n",
       "  'rating': 4.6,\n",
       "  'coordinates': {'latitude': 40.767085, 'longitude': -73.983103},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'price': '$',\n",
       "  'location': {'address1': '301 West 57th St',\n",
       "   'address2': 'Ground Fl',\n",
       "   'address3': '',\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10019',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['301 West 57th St', 'Ground Fl', 'New York, NY 10019']},\n",
       "  'phone': '+12127848863',\n",
       "  'display_phone': '(212) 784-8863',\n",
       "  'distance': 1440.0598002104812},\n",
       " {'id': '-9NO2IDCJMyNGZMAQ1-VQw',\n",
       "  'alias': 'ny-pizza-suprema-new-york',\n",
       "  'name': 'NY Pizza Suprema',\n",
       "  'image_url': 'https://s3-media4.fl.yelpcdn.com/bphoto/EqbDXneMuQP6pw6GemVdQA/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/ny-pizza-suprema-new-york?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 2682,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'}],\n",
       "  'rating': 4.3,\n",
       "  'coordinates': {'latitude': 40.7502059936523,\n",
       "   'longitude': -73.9953231811523},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'price': '$$',\n",
       "  'location': {'address1': '413 8th Ave',\n",
       "   'address2': '',\n",
       "   'address3': '',\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10001',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['413 8th Ave', 'New York, NY 10001']},\n",
       "  'phone': '+12125948939',\n",
       "  'display_phone': '(212) 594-8939',\n",
       "  'distance': 2387.061954989499},\n",
       " {'id': 'v1DHGRNCH9247WLYoaoA9A',\n",
       "  'alias': 'l-industrie-pizzeria-brooklyn',\n",
       "  'name': \"L'industrie Pizzeria\",\n",
       "  'image_url': 'https://s3-media1.fl.yelpcdn.com/bphoto/1-VBwAOj0g9YKYey3V-Z6Q/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/l-industrie-pizzeria-brooklyn?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 1368,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'}],\n",
       "  'rating': 4.7,\n",
       "  'coordinates': {'latitude': 40.71162, 'longitude': -73.95783},\n",
       "  'transactions': ['delivery'],\n",
       "  'price': '$$',\n",
       "  'location': {'address1': '254 S 2nd St',\n",
       "   'address2': '',\n",
       "   'address3': '',\n",
       "   'city': 'Brooklyn',\n",
       "   'zip_code': '11211',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['254 S 2nd St', 'Brooklyn, NY 11211']},\n",
       "  'phone': '+17185990002',\n",
       "  'display_phone': '(718) 599-0002',\n",
       "  'distance': 5382.969880738413},\n",
       " {'id': 'ypJRRRKZtaNad--1EbRBTg',\n",
       "  'alias': 'roma-pizza-and-restaurant-new-york',\n",
       "  'name': 'Roma Pizza & Restaurant',\n",
       "  'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/LA5DKU89rzsD41Hta-ECpg/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/roma-pizza-and-restaurant-new-york?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 52,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'},\n",
       "   {'alias': 'seafood', 'title': 'Seafood'},\n",
       "   {'alias': 'catering', 'title': 'Caterers'}],\n",
       "  'rating': 4.7,\n",
       "  'coordinates': {'latitude': 40.751211, 'longitude': -73.986364},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'location': {'address1': '980 6th Ave',\n",
       "   'address2': None,\n",
       "   'address3': '',\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10018',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['980 6th Ave', 'New York, NY 10018']},\n",
       "  'phone': '+12124578555',\n",
       "  'display_phone': '(212) 457-8555',\n",
       "  'distance': 1669.7516613878195},\n",
       " {'id': 'YchMTqpM6xksrpqXR0YUrQ',\n",
       "  'alias': 'xeno-s-pizza-new-york',\n",
       "  'name': 'Xeno’s Pizza',\n",
       "  'image_url': 'https://s3-media1.fl.yelpcdn.com/bphoto/dVkXWNvDYPgZ7OesI246Kw/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/xeno-s-pizza-new-york?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 39,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'}],\n",
       "  'rating': 4.2,\n",
       "  'coordinates': {'latitude': 40.75728, 'longitude': -73.97008},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'location': {'address1': '163 E 52nd St',\n",
       "   'address2': '',\n",
       "   'address3': None,\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10022',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['163 E 52nd St', 'New York, NY 10022']},\n",
       "  'phone': '+16469520030',\n",
       "  'display_phone': '(646) 952-0030',\n",
       "  'distance': 210.61563672529866},\n",
       " {'id': 'AOZlppihRNG8Y2N4Jid30A',\n",
       "  'alias': 'brooklyn-pizza-masters-new-york',\n",
       "  'name': 'Brooklyn Pizza Masters',\n",
       "  'image_url': 'https://s3-media1.fl.yelpcdn.com/bphoto/Dko2ofSegIWoF3n57Y5ISQ/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/brooklyn-pizza-masters-new-york?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 258,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'},\n",
       "   {'alias': 'salad', 'title': 'Salad'}],\n",
       "  'rating': 4.3,\n",
       "  'coordinates': {'latitude': 40.75869828079016,\n",
       "   'longitude': -73.962919097227},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'location': {'address1': '1055 1st Ave',\n",
       "   'address2': '',\n",
       "   'address3': None,\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10022',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['1055 1st Ave', 'New York, NY 10022']},\n",
       "  'phone': '+16466697757',\n",
       "  'display_phone': '(646) 669-7757',\n",
       "  'distance': 563.0113927421821},\n",
       " {'id': 'tRIHhPKryUZ56SfIz6mLiA',\n",
       "  'alias': 'angelos-coal-oven-pizzeria-new-york',\n",
       "  'name': \"Angelo's Coal Oven Pizzeria\",\n",
       "  'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/0XEf78-yZ-plQXosA3oFlw/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/angelos-coal-oven-pizzeria-new-york?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 1329,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'},\n",
       "   {'alias': 'italian', 'title': 'Italian'}],\n",
       "  'rating': 4.0,\n",
       "  'coordinates': {'latitude': 40.76492, 'longitude': -73.97794},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'price': '$$',\n",
       "  'location': {'address1': '117 W 57th St',\n",
       "   'address2': '',\n",
       "   'address3': '',\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10019',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['117 W 57th St', 'New York, NY 10019']},\n",
       "  'phone': '+12123334333',\n",
       "  'display_phone': '(212) 333-4333',\n",
       "  'distance': 951.371290575802},\n",
       " {'id': 'KEgdfVEVVgJFnGFiLNPDzQ',\n",
       "  'alias': 'sofia-pizza-shoppe-new-york',\n",
       "  'name': 'Sofia Pizza Shoppe',\n",
       "  'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/XTOP8koYT-ccWAPx2cUIKg/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/sofia-pizza-shoppe-new-york?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 262,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'}],\n",
       "  'rating': 4.4,\n",
       "  'coordinates': {'latitude': 40.75674, 'longitude': -73.96431},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'price': '$',\n",
       "  'location': {'address1': '989 1st Ave',\n",
       "   'address2': '',\n",
       "   'address3': None,\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10022',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['989 1st Ave', 'New York, NY 10022']},\n",
       "  'phone': '+12128888816',\n",
       "  'display_phone': '(212) 888-8816',\n",
       "  'distance': 520.3312331060953},\n",
       " {'id': 'iUnELVbiyEszV8DiVB3CTA',\n",
       "  'alias': 'see-no-evil-pizza-new-york',\n",
       "  'name': 'See No Evil Pizza',\n",
       "  'image_url': 'https://s3-media3.fl.yelpcdn.com/bphoto/XOTyidNS18dtgwDU41iSQw/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/see-no-evil-pizza-new-york?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 17,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'}],\n",
       "  'rating': 4.8,\n",
       "  'coordinates': {'latitude': 40.761482, 'longitude': -73.984508},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'location': {'address1': '210 W 50th St',\n",
       "   'address2': 'Conourse  1',\n",
       "   'address3': None,\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10019',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['210 W 50th St', 'Conourse  1', 'New York, NY 10019']},\n",
       "  'phone': '',\n",
       "  'display_phone': '',\n",
       "  'distance': 1284.2877252969977},\n",
       " {'id': 'XujJhk-uQQezYgxyx-YN5Q',\n",
       "  'alias': 'parla-new-york',\n",
       "  'name': 'Parla',\n",
       "  'image_url': 'https://s3-media3.fl.yelpcdn.com/bphoto/65VnWTH-CoFLfWoFK__qjg/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/parla-new-york?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 91,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'},\n",
       "   {'alias': 'pastashops', 'title': 'Pasta Shops'},\n",
       "   {'alias': 'cocktailbars', 'title': 'Cocktail Bars'}],\n",
       "  'rating': 4.3,\n",
       "  'coordinates': {'latitude': 40.779604142118245,\n",
       "   'longitude': -73.9775782278624},\n",
       "  'transactions': [],\n",
       "  'price': '$$',\n",
       "  'location': {'address1': '320 Columbus Ave',\n",
       "   'address2': '',\n",
       "   'address3': None,\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10023',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['320 Columbus Ave', 'New York, NY 10023']},\n",
       "  'phone': '+12127029006',\n",
       "  'display_phone': '(212) 702-9006',\n",
       "  'distance': 2369.5437016537244},\n",
       " {'id': 'V4-ds3mhlB7uLLY9qfZTJQ',\n",
       "  'alias': 'abitinos-pizzeria-new-york-17',\n",
       "  'name': \"Abitino's Pizzeria\",\n",
       "  'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/7RzwMz38XT1vtEza41hN5A/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/abitinos-pizzeria-new-york-17?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 69,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'}],\n",
       "  'rating': 4.3,\n",
       "  'coordinates': {'latitude': 40.75958, 'longitude': -73.97747},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'location': {'address1': '5 West 51 St',\n",
       "   'address2': None,\n",
       "   'address3': '',\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10020',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['5 West 51 St', 'New York, NY 10020']},\n",
       "  'phone': '+12123566181',\n",
       "  'display_phone': '(212) 356-6181',\n",
       "  'distance': 667.90284054447},\n",
       " {'id': '2MuvmwOuwvGOWkBimhniLA',\n",
       "  'alias': 'la-bellezza-new-york',\n",
       "  'name': 'La Bellezza',\n",
       "  'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/75SVEMwv8WbLIB4eYzPdLA/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/la-bellezza-new-york?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 309,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'}],\n",
       "  'rating': 4.1,\n",
       "  'coordinates': {'latitude': 40.7557792663574,\n",
       "   'longitude': -73.9720153808594},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'price': '$',\n",
       "  'location': {'address1': '145 E 49th St',\n",
       "   'address2': '',\n",
       "   'address3': '',\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10017',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['145 E 49th St', 'New York, NY 10017']},\n",
       "  'phone': '+12128713223',\n",
       "  'display_phone': '(212) 871-3223',\n",
       "  'distance': 426.901060768092},\n",
       " {'id': '2-GsvFaQpVpbaIdwb9lSeQ',\n",
       "  'alias': 'andiamo-pizza-new-york-2',\n",
       "  'name': 'Andiamo Pizza',\n",
       "  'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/1p0cE3ZKgflstS6s__3fuQ/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/andiamo-pizza-new-york-2?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 212,\n",
       "  'categories': [{'alias': 'pizza', 'title': 'Pizza'},\n",
       "   {'alias': 'italian', 'title': 'Italian'},\n",
       "   {'alias': 'catering', 'title': 'Caterers'}],\n",
       "  'rating': 4.5,\n",
       "  'coordinates': {'latitude': 40.746144, 'longitude': -73.990189},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'location': {'address1': '818 6th Ave',\n",
       "   'address2': None,\n",
       "   'address3': '',\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10001',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['818 6th Ave', 'New York, NY 10001']},\n",
       "  'phone': '+12122542860',\n",
       "  'display_phone': '(212) 254-2860',\n",
       "  'distance': 2263.1122742182406},\n",
       " {'id': 'vVVmHacu2YAxKfpIjhfd1g',\n",
       "  'alias': 'norma-new-york-5',\n",
       "  'name': 'Norma',\n",
       "  'image_url': 'https://s3-media3.fl.yelpcdn.com/bphoto/qJKt5l2xSBUKOFRA6UOqVg/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/norma-new-york-5?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 670,\n",
       "  'categories': [{'alias': 'italian', 'title': 'Italian'},\n",
       "   {'alias': 'pizza', 'title': 'Pizza'}],\n",
       "  'rating': 4.4,\n",
       "  'coordinates': {'latitude': 40.743553, 'longitude': -73.980026},\n",
       "  'transactions': ['delivery', 'pickup'],\n",
       "  'price': '$$',\n",
       "  'location': {'address1': '438 3rd Ave',\n",
       "   'address2': None,\n",
       "   'address3': '',\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10016',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['438 3rd Ave', 'New York, NY 10016']},\n",
       "  'phone': '+12128890600',\n",
       "  'display_phone': '(212) 889-0600',\n",
       "  'distance': 1942.2913842319626},\n",
       " {'id': 'WG639VkTjmK5dzydd1BBJA',\n",
       "  'alias': 'rubirosa-new-york-2',\n",
       "  'name': 'Rubirosa',\n",
       "  'image_url': 'https://s3-media3.fl.yelpcdn.com/bphoto/l0Phrnhhj78RFiDhLIOUyQ/o.jpg',\n",
       "  'is_closed': False,\n",
       "  'url': 'https://www.yelp.com/biz/rubirosa-new-york-2?adjust_creative=TqzhtA42spPSKOmzDuw9JA&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=TqzhtA42spPSKOmzDuw9JA',\n",
       "  'review_count': 3400,\n",
       "  'categories': [{'alias': 'italian', 'title': 'Italian'},\n",
       "   {'alias': 'pizza', 'title': 'Pizza'}],\n",
       "  'rating': 4.3,\n",
       "  'coordinates': {'latitude': 40.722766, 'longitude': -73.996233},\n",
       "  'transactions': ['pickup'],\n",
       "  'price': '$$',\n",
       "  'location': {'address1': '235 Mulberry St',\n",
       "   'address2': '',\n",
       "   'address3': '',\n",
       "   'city': 'New York',\n",
       "   'zip_code': '10012',\n",
       "   'country': 'US',\n",
       "   'state': 'NY',\n",
       "   'display_address': ['235 Mulberry St', 'New York, NY 10012']},\n",
       "  'phone': '+12129650500',\n",
       "  'display_phone': '(212) 965-0500',\n",
       "  'distance': 4629.739253785127}]"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "results['businesses']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "dea88b45",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>alias</th>\n",
       "      <th>name</th>\n",
       "      <th>image_url</th>\n",
       "      <th>is_closed</th>\n",
       "      <th>url</th>\n",
       "      <th>review_count</th>\n",
       "      <th>categories</th>\n",
       "      <th>rating</th>\n",
       "      <th>coordinates</th>\n",
       "      <th>transactions</th>\n",
       "      <th>price</th>\n",
       "      <th>location</th>\n",
       "      <th>phone</th>\n",
       "      <th>display_phone</th>\n",
       "      <th>distance</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>KEEXuHCYhsQJ-zpJhu98bA</td>\n",
       "      <td>joes-pizza-new-york-148</td>\n",
       "      <td>Joe's Pizza</td>\n",
       "      <td>https://s3-media4.fl.yelpcdn.com/bphoto/FluVgK...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/joes-pizza-new-york-1...</td>\n",
       "      <td>2307</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}]</td>\n",
       "      <td>4.2</td>\n",
       "      <td>{'latitude': 40.7547, 'longitude': -73.98696}</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>$</td>\n",
       "      <td>{'address1': '1435 Broadway', 'address2': '', ...</td>\n",
       "      <td>+16465594878</td>\n",
       "      <td>(646) 559-4878</td>\n",
       "      <td>1552.864538</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>oRdM7n-AfBPBGAlH4Q0Sag</td>\n",
       "      <td>my-pie-pizzeria-romana-new-york-2</td>\n",
       "      <td>My Pie Pizzeria Romana</td>\n",
       "      <td>https://s3-media1.fl.yelpcdn.com/bphoto/b3BIzM...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/my-pie-pizzeria-roman...</td>\n",
       "      <td>937</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}]</td>\n",
       "      <td>4.4</td>\n",
       "      <td>{'latitude': 40.7608512, 'longitude': -73.9694...</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>$$</td>\n",
       "      <td>{'address1': '690 Lexington Ave', 'address2': ...</td>\n",
       "      <td>+12123171850</td>\n",
       "      <td>(212) 317-1850</td>\n",
       "      <td>186.582143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>G9hV4H2iGpWD8RoUpjtokg</td>\n",
       "      <td>l-industrie-pizzeria-new-york</td>\n",
       "      <td>L’industrie Pizzeria</td>\n",
       "      <td>https://s3-media4.fl.yelpcdn.com/bphoto/Hzdlv1...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/l-industrie-pizzeria-...</td>\n",
       "      <td>322</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}]</td>\n",
       "      <td>4.6</td>\n",
       "      <td>{'latitude': 40.73323443774397, 'longitude': -...</td>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{'address1': '104 Christopher St', 'address2':...</td>\n",
       "      <td>+12122560648</td>\n",
       "      <td>(212) 256-0648</td>\n",
       "      <td>4144.896542</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>zj8Lq1T8KIC5zwFief15jg</td>\n",
       "      <td>prince-street-pizza-new-york-2</td>\n",
       "      <td>Prince Street Pizza</td>\n",
       "      <td>https://s3-media1.fl.yelpcdn.com/bphoto/Jo9jBP...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/prince-street-pizza-n...</td>\n",
       "      <td>5346</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}, {'alias...</td>\n",
       "      <td>4.3</td>\n",
       "      <td>{'latitude': 40.72308755605564, 'longitude': -...</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>$</td>\n",
       "      <td>{'address1': '27 Prince St', 'address2': None,...</td>\n",
       "      <td>+12129664100</td>\n",
       "      <td>(212) 966-4100</td>\n",
       "      <td>4530.158358</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>EXQ0x2W9RTydIlHAU9MU1A</td>\n",
       "      <td>mimis-pizza-east-86th-new-york-2</td>\n",
       "      <td>Mimi's Pizza - East 86th</td>\n",
       "      <td>https://s3-media3.fl.yelpcdn.com/bphoto/btcWJW...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/mimis-pizza-east-86th...</td>\n",
       "      <td>211</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}]</td>\n",
       "      <td>4.5</td>\n",
       "      <td>{'latitude': 40.778638, 'longitude': -73.952895}</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{'address1': '217 E 86th St', 'address2': None...</td>\n",
       "      <td>+16468612518</td>\n",
       "      <td>(646) 861-2518</td>\n",
       "      <td>2577.937315</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>GgdR6L49eKH5drPaOYOOPQ</td>\n",
       "      <td>pops-pizzas-new-york</td>\n",
       "      <td>Pop's Pizzas</td>\n",
       "      <td>https://s3-media2.fl.yelpcdn.com/bphoto/K51H3t...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/pops-pizzas-new-york?...</td>\n",
       "      <td>231</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}]</td>\n",
       "      <td>4.6</td>\n",
       "      <td>{'latitude': 40.767085, 'longitude': -73.983103}</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>$</td>\n",
       "      <td>{'address1': '301 West 57th St', 'address2': '...</td>\n",
       "      <td>+12127848863</td>\n",
       "      <td>(212) 784-8863</td>\n",
       "      <td>1440.059800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>-9NO2IDCJMyNGZMAQ1-VQw</td>\n",
       "      <td>ny-pizza-suprema-new-york</td>\n",
       "      <td>NY Pizza Suprema</td>\n",
       "      <td>https://s3-media4.fl.yelpcdn.com/bphoto/EqbDXn...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/ny-pizza-suprema-new-...</td>\n",
       "      <td>2682</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}]</td>\n",
       "      <td>4.3</td>\n",
       "      <td>{'latitude': 40.7502059936523, 'longitude': -7...</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>$$</td>\n",
       "      <td>{'address1': '413 8th Ave', 'address2': '', 'a...</td>\n",
       "      <td>+12125948939</td>\n",
       "      <td>(212) 594-8939</td>\n",
       "      <td>2387.061955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>v1DHGRNCH9247WLYoaoA9A</td>\n",
       "      <td>l-industrie-pizzeria-brooklyn</td>\n",
       "      <td>L'industrie Pizzeria</td>\n",
       "      <td>https://s3-media1.fl.yelpcdn.com/bphoto/1-VBwA...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/l-industrie-pizzeria-...</td>\n",
       "      <td>1368</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}]</td>\n",
       "      <td>4.7</td>\n",
       "      <td>{'latitude': 40.71162, 'longitude': -73.95783}</td>\n",
       "      <td>[delivery]</td>\n",
       "      <td>$$</td>\n",
       "      <td>{'address1': '254 S 2nd St', 'address2': '', '...</td>\n",
       "      <td>+17185990002</td>\n",
       "      <td>(718) 599-0002</td>\n",
       "      <td>5382.969881</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>ypJRRRKZtaNad--1EbRBTg</td>\n",
       "      <td>roma-pizza-and-restaurant-new-york</td>\n",
       "      <td>Roma Pizza &amp; Restaurant</td>\n",
       "      <td>https://s3-media2.fl.yelpcdn.com/bphoto/LA5DKU...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/roma-pizza-and-restau...</td>\n",
       "      <td>52</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}, {'alias...</td>\n",
       "      <td>4.7</td>\n",
       "      <td>{'latitude': 40.751211, 'longitude': -73.986364}</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{'address1': '980 6th Ave', 'address2': None, ...</td>\n",
       "      <td>+12124578555</td>\n",
       "      <td>(212) 457-8555</td>\n",
       "      <td>1669.751661</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>YchMTqpM6xksrpqXR0YUrQ</td>\n",
       "      <td>xeno-s-pizza-new-york</td>\n",
       "      <td>Xeno’s Pizza</td>\n",
       "      <td>https://s3-media1.fl.yelpcdn.com/bphoto/dVkXWN...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/xeno-s-pizza-new-york...</td>\n",
       "      <td>39</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}]</td>\n",
       "      <td>4.2</td>\n",
       "      <td>{'latitude': 40.75728, 'longitude': -73.97008}</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{'address1': '163 E 52nd St', 'address2': '', ...</td>\n",
       "      <td>+16469520030</td>\n",
       "      <td>(646) 952-0030</td>\n",
       "      <td>210.615637</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>AOZlppihRNG8Y2N4Jid30A</td>\n",
       "      <td>brooklyn-pizza-masters-new-york</td>\n",
       "      <td>Brooklyn Pizza Masters</td>\n",
       "      <td>https://s3-media1.fl.yelpcdn.com/bphoto/Dko2of...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/brooklyn-pizza-master...</td>\n",
       "      <td>258</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}, {'alias...</td>\n",
       "      <td>4.3</td>\n",
       "      <td>{'latitude': 40.75869828079016, 'longitude': -...</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{'address1': '1055 1st Ave', 'address2': '', '...</td>\n",
       "      <td>+16466697757</td>\n",
       "      <td>(646) 669-7757</td>\n",
       "      <td>563.011393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>tRIHhPKryUZ56SfIz6mLiA</td>\n",
       "      <td>angelos-coal-oven-pizzeria-new-york</td>\n",
       "      <td>Angelo's Coal Oven Pizzeria</td>\n",
       "      <td>https://s3-media2.fl.yelpcdn.com/bphoto/0XEf78...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/angelos-coal-oven-piz...</td>\n",
       "      <td>1329</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}, {'alias...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>{'latitude': 40.76492, 'longitude': -73.97794}</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>$$</td>\n",
       "      <td>{'address1': '117 W 57th St', 'address2': '', ...</td>\n",
       "      <td>+12123334333</td>\n",
       "      <td>(212) 333-4333</td>\n",
       "      <td>951.371291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>KEgdfVEVVgJFnGFiLNPDzQ</td>\n",
       "      <td>sofia-pizza-shoppe-new-york</td>\n",
       "      <td>Sofia Pizza Shoppe</td>\n",
       "      <td>https://s3-media2.fl.yelpcdn.com/bphoto/XTOP8k...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/sofia-pizza-shoppe-ne...</td>\n",
       "      <td>262</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}]</td>\n",
       "      <td>4.4</td>\n",
       "      <td>{'latitude': 40.75674, 'longitude': -73.96431}</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>$</td>\n",
       "      <td>{'address1': '989 1st Ave', 'address2': '', 'a...</td>\n",
       "      <td>+12128888816</td>\n",
       "      <td>(212) 888-8816</td>\n",
       "      <td>520.331233</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>iUnELVbiyEszV8DiVB3CTA</td>\n",
       "      <td>see-no-evil-pizza-new-york</td>\n",
       "      <td>See No Evil Pizza</td>\n",
       "      <td>https://s3-media3.fl.yelpcdn.com/bphoto/XOTyid...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/see-no-evil-pizza-new...</td>\n",
       "      <td>17</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}]</td>\n",
       "      <td>4.8</td>\n",
       "      <td>{'latitude': 40.761482, 'longitude': -73.984508}</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{'address1': '210 W 50th St', 'address2': 'Con...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>1284.287725</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>XujJhk-uQQezYgxyx-YN5Q</td>\n",
       "      <td>parla-new-york</td>\n",
       "      <td>Parla</td>\n",
       "      <td>https://s3-media3.fl.yelpcdn.com/bphoto/65VnWT...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/parla-new-york?adjust...</td>\n",
       "      <td>91</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}, {'alias...</td>\n",
       "      <td>4.3</td>\n",
       "      <td>{'latitude': 40.779604142118245, 'longitude': ...</td>\n",
       "      <td>[]</td>\n",
       "      <td>$$</td>\n",
       "      <td>{'address1': '320 Columbus Ave', 'address2': '...</td>\n",
       "      <td>+12127029006</td>\n",
       "      <td>(212) 702-9006</td>\n",
       "      <td>2369.543702</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>V4-ds3mhlB7uLLY9qfZTJQ</td>\n",
       "      <td>abitinos-pizzeria-new-york-17</td>\n",
       "      <td>Abitino's Pizzeria</td>\n",
       "      <td>https://s3-media2.fl.yelpcdn.com/bphoto/7RzwMz...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/abitinos-pizzeria-new...</td>\n",
       "      <td>69</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}]</td>\n",
       "      <td>4.3</td>\n",
       "      <td>{'latitude': 40.75958, 'longitude': -73.97747}</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{'address1': '5 West 51 St', 'address2': None,...</td>\n",
       "      <td>+12123566181</td>\n",
       "      <td>(212) 356-6181</td>\n",
       "      <td>667.902841</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2MuvmwOuwvGOWkBimhniLA</td>\n",
       "      <td>la-bellezza-new-york</td>\n",
       "      <td>La Bellezza</td>\n",
       "      <td>https://s3-media2.fl.yelpcdn.com/bphoto/75SVEM...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/la-bellezza-new-york?...</td>\n",
       "      <td>309</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}]</td>\n",
       "      <td>4.1</td>\n",
       "      <td>{'latitude': 40.7557792663574, 'longitude': -7...</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>$</td>\n",
       "      <td>{'address1': '145 E 49th St', 'address2': '', ...</td>\n",
       "      <td>+12128713223</td>\n",
       "      <td>(212) 871-3223</td>\n",
       "      <td>426.901061</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2-GsvFaQpVpbaIdwb9lSeQ</td>\n",
       "      <td>andiamo-pizza-new-york-2</td>\n",
       "      <td>Andiamo Pizza</td>\n",
       "      <td>https://s3-media2.fl.yelpcdn.com/bphoto/1p0cE3...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/andiamo-pizza-new-yor...</td>\n",
       "      <td>212</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}, {'alias...</td>\n",
       "      <td>4.5</td>\n",
       "      <td>{'latitude': 40.746144, 'longitude': -73.990189}</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{'address1': '818 6th Ave', 'address2': None, ...</td>\n",
       "      <td>+12122542860</td>\n",
       "      <td>(212) 254-2860</td>\n",
       "      <td>2263.112274</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>vVVmHacu2YAxKfpIjhfd1g</td>\n",
       "      <td>norma-new-york-5</td>\n",
       "      <td>Norma</td>\n",
       "      <td>https://s3-media3.fl.yelpcdn.com/bphoto/qJKt5l...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/norma-new-york-5?adju...</td>\n",
       "      <td>670</td>\n",
       "      <td>[{'alias': 'italian', 'title': 'Italian'}, {'a...</td>\n",
       "      <td>4.4</td>\n",
       "      <td>{'latitude': 40.743553, 'longitude': -73.980026}</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>$$</td>\n",
       "      <td>{'address1': '438 3rd Ave', 'address2': None, ...</td>\n",
       "      <td>+12128890600</td>\n",
       "      <td>(212) 889-0600</td>\n",
       "      <td>1942.291384</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>WG639VkTjmK5dzydd1BBJA</td>\n",
       "      <td>rubirosa-new-york-2</td>\n",
       "      <td>Rubirosa</td>\n",
       "      <td>https://s3-media3.fl.yelpcdn.com/bphoto/l0Phrn...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/rubirosa-new-york-2?a...</td>\n",
       "      <td>3400</td>\n",
       "      <td>[{'alias': 'italian', 'title': 'Italian'}, {'a...</td>\n",
       "      <td>4.3</td>\n",
       "      <td>{'latitude': 40.722766, 'longitude': -73.996233}</td>\n",
       "      <td>[pickup]</td>\n",
       "      <td>$$</td>\n",
       "      <td>{'address1': '235 Mulberry St', 'address2': ''...</td>\n",
       "      <td>+12129650500</td>\n",
       "      <td>(212) 965-0500</td>\n",
       "      <td>4629.739254</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        id                                alias  \\\n",
       "0   KEEXuHCYhsQJ-zpJhu98bA              joes-pizza-new-york-148   \n",
       "1   oRdM7n-AfBPBGAlH4Q0Sag    my-pie-pizzeria-romana-new-york-2   \n",
       "2   G9hV4H2iGpWD8RoUpjtokg        l-industrie-pizzeria-new-york   \n",
       "3   zj8Lq1T8KIC5zwFief15jg       prince-street-pizza-new-york-2   \n",
       "4   EXQ0x2W9RTydIlHAU9MU1A     mimis-pizza-east-86th-new-york-2   \n",
       "5   GgdR6L49eKH5drPaOYOOPQ                 pops-pizzas-new-york   \n",
       "6   -9NO2IDCJMyNGZMAQ1-VQw            ny-pizza-suprema-new-york   \n",
       "7   v1DHGRNCH9247WLYoaoA9A        l-industrie-pizzeria-brooklyn   \n",
       "8   ypJRRRKZtaNad--1EbRBTg   roma-pizza-and-restaurant-new-york   \n",
       "9   YchMTqpM6xksrpqXR0YUrQ                xeno-s-pizza-new-york   \n",
       "10  AOZlppihRNG8Y2N4Jid30A      brooklyn-pizza-masters-new-york   \n",
       "11  tRIHhPKryUZ56SfIz6mLiA  angelos-coal-oven-pizzeria-new-york   \n",
       "12  KEgdfVEVVgJFnGFiLNPDzQ          sofia-pizza-shoppe-new-york   \n",
       "13  iUnELVbiyEszV8DiVB3CTA           see-no-evil-pizza-new-york   \n",
       "14  XujJhk-uQQezYgxyx-YN5Q                       parla-new-york   \n",
       "15  V4-ds3mhlB7uLLY9qfZTJQ        abitinos-pizzeria-new-york-17   \n",
       "16  2MuvmwOuwvGOWkBimhniLA                 la-bellezza-new-york   \n",
       "17  2-GsvFaQpVpbaIdwb9lSeQ             andiamo-pizza-new-york-2   \n",
       "18  vVVmHacu2YAxKfpIjhfd1g                     norma-new-york-5   \n",
       "19  WG639VkTjmK5dzydd1BBJA                  rubirosa-new-york-2   \n",
       "\n",
       "                           name  \\\n",
       "0                   Joe's Pizza   \n",
       "1        My Pie Pizzeria Romana   \n",
       "2          L’industrie Pizzeria   \n",
       "3           Prince Street Pizza   \n",
       "4      Mimi's Pizza - East 86th   \n",
       "5                  Pop's Pizzas   \n",
       "6              NY Pizza Suprema   \n",
       "7          L'industrie Pizzeria   \n",
       "8       Roma Pizza & Restaurant   \n",
       "9                  Xeno’s Pizza   \n",
       "10       Brooklyn Pizza Masters   \n",
       "11  Angelo's Coal Oven Pizzeria   \n",
       "12           Sofia Pizza Shoppe   \n",
       "13            See No Evil Pizza   \n",
       "14                        Parla   \n",
       "15           Abitino's Pizzeria   \n",
       "16                  La Bellezza   \n",
       "17                Andiamo Pizza   \n",
       "18                        Norma   \n",
       "19                     Rubirosa   \n",
       "\n",
       "                                            image_url  is_closed  \\\n",
       "0   https://s3-media4.fl.yelpcdn.com/bphoto/FluVgK...      False   \n",
       "1   https://s3-media1.fl.yelpcdn.com/bphoto/b3BIzM...      False   \n",
       "2   https://s3-media4.fl.yelpcdn.com/bphoto/Hzdlv1...      False   \n",
       "3   https://s3-media1.fl.yelpcdn.com/bphoto/Jo9jBP...      False   \n",
       "4   https://s3-media3.fl.yelpcdn.com/bphoto/btcWJW...      False   \n",
       "5   https://s3-media2.fl.yelpcdn.com/bphoto/K51H3t...      False   \n",
       "6   https://s3-media4.fl.yelpcdn.com/bphoto/EqbDXn...      False   \n",
       "7   https://s3-media1.fl.yelpcdn.com/bphoto/1-VBwA...      False   \n",
       "8   https://s3-media2.fl.yelpcdn.com/bphoto/LA5DKU...      False   \n",
       "9   https://s3-media1.fl.yelpcdn.com/bphoto/dVkXWN...      False   \n",
       "10  https://s3-media1.fl.yelpcdn.com/bphoto/Dko2of...      False   \n",
       "11  https://s3-media2.fl.yelpcdn.com/bphoto/0XEf78...      False   \n",
       "12  https://s3-media2.fl.yelpcdn.com/bphoto/XTOP8k...      False   \n",
       "13  https://s3-media3.fl.yelpcdn.com/bphoto/XOTyid...      False   \n",
       "14  https://s3-media3.fl.yelpcdn.com/bphoto/65VnWT...      False   \n",
       "15  https://s3-media2.fl.yelpcdn.com/bphoto/7RzwMz...      False   \n",
       "16  https://s3-media2.fl.yelpcdn.com/bphoto/75SVEM...      False   \n",
       "17  https://s3-media2.fl.yelpcdn.com/bphoto/1p0cE3...      False   \n",
       "18  https://s3-media3.fl.yelpcdn.com/bphoto/qJKt5l...      False   \n",
       "19  https://s3-media3.fl.yelpcdn.com/bphoto/l0Phrn...      False   \n",
       "\n",
       "                                                  url  review_count  \\\n",
       "0   https://www.yelp.com/biz/joes-pizza-new-york-1...          2307   \n",
       "1   https://www.yelp.com/biz/my-pie-pizzeria-roman...           937   \n",
       "2   https://www.yelp.com/biz/l-industrie-pizzeria-...           322   \n",
       "3   https://www.yelp.com/biz/prince-street-pizza-n...          5346   \n",
       "4   https://www.yelp.com/biz/mimis-pizza-east-86th...           211   \n",
       "5   https://www.yelp.com/biz/pops-pizzas-new-york?...           231   \n",
       "6   https://www.yelp.com/biz/ny-pizza-suprema-new-...          2682   \n",
       "7   https://www.yelp.com/biz/l-industrie-pizzeria-...          1368   \n",
       "8   https://www.yelp.com/biz/roma-pizza-and-restau...            52   \n",
       "9   https://www.yelp.com/biz/xeno-s-pizza-new-york...            39   \n",
       "10  https://www.yelp.com/biz/brooklyn-pizza-master...           258   \n",
       "11  https://www.yelp.com/biz/angelos-coal-oven-piz...          1329   \n",
       "12  https://www.yelp.com/biz/sofia-pizza-shoppe-ne...           262   \n",
       "13  https://www.yelp.com/biz/see-no-evil-pizza-new...            17   \n",
       "14  https://www.yelp.com/biz/parla-new-york?adjust...            91   \n",
       "15  https://www.yelp.com/biz/abitinos-pizzeria-new...            69   \n",
       "16  https://www.yelp.com/biz/la-bellezza-new-york?...           309   \n",
       "17  https://www.yelp.com/biz/andiamo-pizza-new-yor...           212   \n",
       "18  https://www.yelp.com/biz/norma-new-york-5?adju...           670   \n",
       "19  https://www.yelp.com/biz/rubirosa-new-york-2?a...          3400   \n",
       "\n",
       "                                           categories  rating  \\\n",
       "0              [{'alias': 'pizza', 'title': 'Pizza'}]     4.2   \n",
       "1              [{'alias': 'pizza', 'title': 'Pizza'}]     4.4   \n",
       "2              [{'alias': 'pizza', 'title': 'Pizza'}]     4.6   \n",
       "3   [{'alias': 'pizza', 'title': 'Pizza'}, {'alias...     4.3   \n",
       "4              [{'alias': 'pizza', 'title': 'Pizza'}]     4.5   \n",
       "5              [{'alias': 'pizza', 'title': 'Pizza'}]     4.6   \n",
       "6              [{'alias': 'pizza', 'title': 'Pizza'}]     4.3   \n",
       "7              [{'alias': 'pizza', 'title': 'Pizza'}]     4.7   \n",
       "8   [{'alias': 'pizza', 'title': 'Pizza'}, {'alias...     4.7   \n",
       "9              [{'alias': 'pizza', 'title': 'Pizza'}]     4.2   \n",
       "10  [{'alias': 'pizza', 'title': 'Pizza'}, {'alias...     4.3   \n",
       "11  [{'alias': 'pizza', 'title': 'Pizza'}, {'alias...     4.0   \n",
       "12             [{'alias': 'pizza', 'title': 'Pizza'}]     4.4   \n",
       "13             [{'alias': 'pizza', 'title': 'Pizza'}]     4.8   \n",
       "14  [{'alias': 'pizza', 'title': 'Pizza'}, {'alias...     4.3   \n",
       "15             [{'alias': 'pizza', 'title': 'Pizza'}]     4.3   \n",
       "16             [{'alias': 'pizza', 'title': 'Pizza'}]     4.1   \n",
       "17  [{'alias': 'pizza', 'title': 'Pizza'}, {'alias...     4.5   \n",
       "18  [{'alias': 'italian', 'title': 'Italian'}, {'a...     4.4   \n",
       "19  [{'alias': 'italian', 'title': 'Italian'}, {'a...     4.3   \n",
       "\n",
       "                                          coordinates        transactions  \\\n",
       "0       {'latitude': 40.7547, 'longitude': -73.98696}  [delivery, pickup]   \n",
       "1   {'latitude': 40.7608512, 'longitude': -73.9694...  [delivery, pickup]   \n",
       "2   {'latitude': 40.73323443774397, 'longitude': -...                  []   \n",
       "3   {'latitude': 40.72308755605564, 'longitude': -...  [delivery, pickup]   \n",
       "4    {'latitude': 40.778638, 'longitude': -73.952895}  [delivery, pickup]   \n",
       "5    {'latitude': 40.767085, 'longitude': -73.983103}  [delivery, pickup]   \n",
       "6   {'latitude': 40.7502059936523, 'longitude': -7...  [delivery, pickup]   \n",
       "7      {'latitude': 40.71162, 'longitude': -73.95783}          [delivery]   \n",
       "8    {'latitude': 40.751211, 'longitude': -73.986364}  [delivery, pickup]   \n",
       "9      {'latitude': 40.75728, 'longitude': -73.97008}  [delivery, pickup]   \n",
       "10  {'latitude': 40.75869828079016, 'longitude': -...  [delivery, pickup]   \n",
       "11     {'latitude': 40.76492, 'longitude': -73.97794}  [delivery, pickup]   \n",
       "12     {'latitude': 40.75674, 'longitude': -73.96431}  [delivery, pickup]   \n",
       "13   {'latitude': 40.761482, 'longitude': -73.984508}  [delivery, pickup]   \n",
       "14  {'latitude': 40.779604142118245, 'longitude': ...                  []   \n",
       "15     {'latitude': 40.75958, 'longitude': -73.97747}  [delivery, pickup]   \n",
       "16  {'latitude': 40.7557792663574, 'longitude': -7...  [delivery, pickup]   \n",
       "17   {'latitude': 40.746144, 'longitude': -73.990189}  [delivery, pickup]   \n",
       "18   {'latitude': 40.743553, 'longitude': -73.980026}  [delivery, pickup]   \n",
       "19   {'latitude': 40.722766, 'longitude': -73.996233}            [pickup]   \n",
       "\n",
       "   price                                           location         phone  \\\n",
       "0      $  {'address1': '1435 Broadway', 'address2': '', ...  +16465594878   \n",
       "1     $$  {'address1': '690 Lexington Ave', 'address2': ...  +12123171850   \n",
       "2    NaN  {'address1': '104 Christopher St', 'address2':...  +12122560648   \n",
       "3      $  {'address1': '27 Prince St', 'address2': None,...  +12129664100   \n",
       "4    NaN  {'address1': '217 E 86th St', 'address2': None...  +16468612518   \n",
       "5      $  {'address1': '301 West 57th St', 'address2': '...  +12127848863   \n",
       "6     $$  {'address1': '413 8th Ave', 'address2': '', 'a...  +12125948939   \n",
       "7     $$  {'address1': '254 S 2nd St', 'address2': '', '...  +17185990002   \n",
       "8    NaN  {'address1': '980 6th Ave', 'address2': None, ...  +12124578555   \n",
       "9    NaN  {'address1': '163 E 52nd St', 'address2': '', ...  +16469520030   \n",
       "10   NaN  {'address1': '1055 1st Ave', 'address2': '', '...  +16466697757   \n",
       "11    $$  {'address1': '117 W 57th St', 'address2': '', ...  +12123334333   \n",
       "12     $  {'address1': '989 1st Ave', 'address2': '', 'a...  +12128888816   \n",
       "13   NaN  {'address1': '210 W 50th St', 'address2': 'Con...                 \n",
       "14    $$  {'address1': '320 Columbus Ave', 'address2': '...  +12127029006   \n",
       "15   NaN  {'address1': '5 West 51 St', 'address2': None,...  +12123566181   \n",
       "16     $  {'address1': '145 E 49th St', 'address2': '', ...  +12128713223   \n",
       "17   NaN  {'address1': '818 6th Ave', 'address2': None, ...  +12122542860   \n",
       "18    $$  {'address1': '438 3rd Ave', 'address2': None, ...  +12128890600   \n",
       "19    $$  {'address1': '235 Mulberry St', 'address2': ''...  +12129650500   \n",
       "\n",
       "     display_phone     distance  \n",
       "0   (646) 559-4878  1552.864538  \n",
       "1   (212) 317-1850   186.582143  \n",
       "2   (212) 256-0648  4144.896542  \n",
       "3   (212) 966-4100  4530.158358  \n",
       "4   (646) 861-2518  2577.937315  \n",
       "5   (212) 784-8863  1440.059800  \n",
       "6   (212) 594-8939  2387.061955  \n",
       "7   (718) 599-0002  5382.969881  \n",
       "8   (212) 457-8555  1669.751661  \n",
       "9   (646) 952-0030   210.615637  \n",
       "10  (646) 669-7757   563.011393  \n",
       "11  (212) 333-4333   951.371291  \n",
       "12  (212) 888-8816   520.331233  \n",
       "13                  1284.287725  \n",
       "14  (212) 702-9006  2369.543702  \n",
       "15  (212) 356-6181   667.902841  \n",
       "16  (212) 871-3223   426.901061  \n",
       "17  (212) 254-2860  2263.112274  \n",
       "18  (212) 889-0600  1942.291384  \n",
       "19  (212) 965-0500  4629.739254  "
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>alias</th>\n",
       "      <th>name</th>\n",
       "      <th>image_url</th>\n",
       "      <th>is_closed</th>\n",
       "      <th>url</th>\n",
       "      <th>review_count</th>\n",
       "      <th>categories</th>\n",
       "      <th>rating</th>\n",
       "      <th>coordinates</th>\n",
       "      <th>transactions</th>\n",
       "      <th>price</th>\n",
       "      <th>location</th>\n",
       "      <th>phone</th>\n",
       "      <th>display_phone</th>\n",
       "      <th>distance</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>KEEXuHCYhsQJ-zpJhu98bA</td>\n",
       "      <td>joes-pizza-new-york-148</td>\n",
       "      <td>Joe's Pizza</td>\n",
       "      <td>https://s3-media4.fl.yelpcdn.com/bphoto/FluVgK...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/joes-pizza-new-york-1...</td>\n",
       "      <td>2307</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}]</td>\n",
       "      <td>4.2</td>\n",
       "      <td>{'latitude': 40.7547, 'longitude': -73.98696}</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>$</td>\n",
       "      <td>{'address1': '1435 Broadway', 'address2': '', ...</td>\n",
       "      <td>+16465594878</td>\n",
       "      <td>(646) 559-4878</td>\n",
       "      <td>1552.864538</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>oRdM7n-AfBPBGAlH4Q0Sag</td>\n",
       "      <td>my-pie-pizzeria-romana-new-york-2</td>\n",
       "      <td>My Pie Pizzeria Romana</td>\n",
       "      <td>https://s3-media1.fl.yelpcdn.com/bphoto/b3BIzM...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/my-pie-pizzeria-roman...</td>\n",
       "      <td>937</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}]</td>\n",
       "      <td>4.4</td>\n",
       "      <td>{'latitude': 40.7608512, 'longitude': -73.9694...</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>$$</td>\n",
       "      <td>{'address1': '690 Lexington Ave', 'address2': ...</td>\n",
       "      <td>+12123171850</td>\n",
       "      <td>(212) 317-1850</td>\n",
       "      <td>186.582143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>G9hV4H2iGpWD8RoUpjtokg</td>\n",
       "      <td>l-industrie-pizzeria-new-york</td>\n",
       "      <td>L’industrie Pizzeria</td>\n",
       "      <td>https://s3-media4.fl.yelpcdn.com/bphoto/Hzdlv1...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/l-industrie-pizzeria-...</td>\n",
       "      <td>322</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}]</td>\n",
       "      <td>4.6</td>\n",
       "      <td>{'latitude': 40.73323443774397, 'longitude': -...</td>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{'address1': '104 Christopher St', 'address2':...</td>\n",
       "      <td>+12122560648</td>\n",
       "      <td>(212) 256-0648</td>\n",
       "      <td>4144.896542</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>zj8Lq1T8KIC5zwFief15jg</td>\n",
       "      <td>prince-street-pizza-new-york-2</td>\n",
       "      <td>Prince Street Pizza</td>\n",
       "      <td>https://s3-media1.fl.yelpcdn.com/bphoto/Jo9jBP...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/prince-street-pizza-n...</td>\n",
       "      <td>5346</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}, {'alias...</td>\n",
       "      <td>4.3</td>\n",
       "      <td>{'latitude': 40.72308755605564, 'longitude': -...</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>$</td>\n",
       "      <td>{'address1': '27 Prince St', 'address2': None,...</td>\n",
       "      <td>+12129664100</td>\n",
       "      <td>(212) 966-4100</td>\n",
       "      <td>4530.158358</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>EXQ0x2W9RTydIlHAU9MU1A</td>\n",
       "      <td>mimis-pizza-east-86th-new-york-2</td>\n",
       "      <td>Mimi's Pizza - East 86th</td>\n",
       "      <td>https://s3-media3.fl.yelpcdn.com/bphoto/btcWJW...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/mimis-pizza-east-86th...</td>\n",
       "      <td>211</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}]</td>\n",
       "      <td>4.5</td>\n",
       "      <td>{'latitude': 40.778638, 'longitude': -73.952895}</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{'address1': '217 E 86th St', 'address2': None...</td>\n",
       "      <td>+16468612518</td>\n",
       "      <td>(646) 861-2518</td>\n",
       "      <td>2577.937315</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>GgdR6L49eKH5drPaOYOOPQ</td>\n",
       "      <td>pops-pizzas-new-york</td>\n",
       "      <td>Pop's Pizzas</td>\n",
       "      <td>https://s3-media2.fl.yelpcdn.com/bphoto/K51H3t...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/pops-pizzas-new-york?...</td>\n",
       "      <td>231</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}]</td>\n",
       "      <td>4.6</td>\n",
       "      <td>{'latitude': 40.767085, 'longitude': -73.983103}</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>$</td>\n",
       "      <td>{'address1': '301 West 57th St', 'address2': '...</td>\n",
       "      <td>+12127848863</td>\n",
       "      <td>(212) 784-8863</td>\n",
       "      <td>1440.059800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>-9NO2IDCJMyNGZMAQ1-VQw</td>\n",
       "      <td>ny-pizza-suprema-new-york</td>\n",
       "      <td>NY Pizza Suprema</td>\n",
       "      <td>https://s3-media4.fl.yelpcdn.com/bphoto/EqbDXn...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/ny-pizza-suprema-new-...</td>\n",
       "      <td>2682</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}]</td>\n",
       "      <td>4.3</td>\n",
       "      <td>{'latitude': 40.7502059936523, 'longitude': -7...</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>$$</td>\n",
       "      <td>{'address1': '413 8th Ave', 'address2': '', 'a...</td>\n",
       "      <td>+12125948939</td>\n",
       "      <td>(212) 594-8939</td>\n",
       "      <td>2387.061955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>v1DHGRNCH9247WLYoaoA9A</td>\n",
       "      <td>l-industrie-pizzeria-brooklyn</td>\n",
       "      <td>L'industrie Pizzeria</td>\n",
       "      <td>https://s3-media1.fl.yelpcdn.com/bphoto/1-VBwA...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/l-industrie-pizzeria-...</td>\n",
       "      <td>1368</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}]</td>\n",
       "      <td>4.7</td>\n",
       "      <td>{'latitude': 40.71162, 'longitude': -73.95783}</td>\n",
       "      <td>[delivery]</td>\n",
       "      <td>$$</td>\n",
       "      <td>{'address1': '254 S 2nd St', 'address2': '', '...</td>\n",
       "      <td>+17185990002</td>\n",
       "      <td>(718) 599-0002</td>\n",
       "      <td>5382.969881</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>ypJRRRKZtaNad--1EbRBTg</td>\n",
       "      <td>roma-pizza-and-restaurant-new-york</td>\n",
       "      <td>Roma Pizza &amp; Restaurant</td>\n",
       "      <td>https://s3-media2.fl.yelpcdn.com/bphoto/LA5DKU...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/roma-pizza-and-restau...</td>\n",
       "      <td>52</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}, {'alias...</td>\n",
       "      <td>4.7</td>\n",
       "      <td>{'latitude': 40.751211, 'longitude': -73.986364}</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{'address1': '980 6th Ave', 'address2': None, ...</td>\n",
       "      <td>+12124578555</td>\n",
       "      <td>(212) 457-8555</td>\n",
       "      <td>1669.751661</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>YchMTqpM6xksrpqXR0YUrQ</td>\n",
       "      <td>xeno-s-pizza-new-york</td>\n",
       "      <td>Xeno’s Pizza</td>\n",
       "      <td>https://s3-media1.fl.yelpcdn.com/bphoto/dVkXWN...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/xeno-s-pizza-new-york...</td>\n",
       "      <td>39</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}]</td>\n",
       "      <td>4.2</td>\n",
       "      <td>{'latitude': 40.75728, 'longitude': -73.97008}</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{'address1': '163 E 52nd St', 'address2': '', ...</td>\n",
       "      <td>+16469520030</td>\n",
       "      <td>(646) 952-0030</td>\n",
       "      <td>210.615637</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>AOZlppihRNG8Y2N4Jid30A</td>\n",
       "      <td>brooklyn-pizza-masters-new-york</td>\n",
       "      <td>Brooklyn Pizza Masters</td>\n",
       "      <td>https://s3-media1.fl.yelpcdn.com/bphoto/Dko2of...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/brooklyn-pizza-master...</td>\n",
       "      <td>258</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}, {'alias...</td>\n",
       "      <td>4.3</td>\n",
       "      <td>{'latitude': 40.75869828079016, 'longitude': -...</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{'address1': '1055 1st Ave', 'address2': '', '...</td>\n",
       "      <td>+16466697757</td>\n",
       "      <td>(646) 669-7757</td>\n",
       "      <td>563.011393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>tRIHhPKryUZ56SfIz6mLiA</td>\n",
       "      <td>angelos-coal-oven-pizzeria-new-york</td>\n",
       "      <td>Angelo's Coal Oven Pizzeria</td>\n",
       "      <td>https://s3-media2.fl.yelpcdn.com/bphoto/0XEf78...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/angelos-coal-oven-piz...</td>\n",
       "      <td>1329</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}, {'alias...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>{'latitude': 40.76492, 'longitude': -73.97794}</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>$$</td>\n",
       "      <td>{'address1': '117 W 57th St', 'address2': '', ...</td>\n",
       "      <td>+12123334333</td>\n",
       "      <td>(212) 333-4333</td>\n",
       "      <td>951.371291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>KEgdfVEVVgJFnGFiLNPDzQ</td>\n",
       "      <td>sofia-pizza-shoppe-new-york</td>\n",
       "      <td>Sofia Pizza Shoppe</td>\n",
       "      <td>https://s3-media2.fl.yelpcdn.com/bphoto/XTOP8k...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/sofia-pizza-shoppe-ne...</td>\n",
       "      <td>262</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}]</td>\n",
       "      <td>4.4</td>\n",
       "      <td>{'latitude': 40.75674, 'longitude': -73.96431}</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>$</td>\n",
       "      <td>{'address1': '989 1st Ave', 'address2': '', 'a...</td>\n",
       "      <td>+12128888816</td>\n",
       "      <td>(212) 888-8816</td>\n",
       "      <td>520.331233</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>iUnELVbiyEszV8DiVB3CTA</td>\n",
       "      <td>see-no-evil-pizza-new-york</td>\n",
       "      <td>See No Evil Pizza</td>\n",
       "      <td>https://s3-media3.fl.yelpcdn.com/bphoto/XOTyid...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/see-no-evil-pizza-new...</td>\n",
       "      <td>17</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}]</td>\n",
       "      <td>4.8</td>\n",
       "      <td>{'latitude': 40.761482, 'longitude': -73.984508}</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{'address1': '210 W 50th St', 'address2': 'Con...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>1284.287725</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>XujJhk-uQQezYgxyx-YN5Q</td>\n",
       "      <td>parla-new-york</td>\n",
       "      <td>Parla</td>\n",
       "      <td>https://s3-media3.fl.yelpcdn.com/bphoto/65VnWT...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/parla-new-york?adjust...</td>\n",
       "      <td>91</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}, {'alias...</td>\n",
       "      <td>4.3</td>\n",
       "      <td>{'latitude': 40.779604142118245, 'longitude': ...</td>\n",
       "      <td>[]</td>\n",
       "      <td>$$</td>\n",
       "      <td>{'address1': '320 Columbus Ave', 'address2': '...</td>\n",
       "      <td>+12127029006</td>\n",
       "      <td>(212) 702-9006</td>\n",
       "      <td>2369.543702</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>V4-ds3mhlB7uLLY9qfZTJQ</td>\n",
       "      <td>abitinos-pizzeria-new-york-17</td>\n",
       "      <td>Abitino's Pizzeria</td>\n",
       "      <td>https://s3-media2.fl.yelpcdn.com/bphoto/7RzwMz...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/abitinos-pizzeria-new...</td>\n",
       "      <td>69</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}]</td>\n",
       "      <td>4.3</td>\n",
       "      <td>{'latitude': 40.75958, 'longitude': -73.97747}</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{'address1': '5 West 51 St', 'address2': None,...</td>\n",
       "      <td>+12123566181</td>\n",
       "      <td>(212) 356-6181</td>\n",
       "      <td>667.902841</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2MuvmwOuwvGOWkBimhniLA</td>\n",
       "      <td>la-bellezza-new-york</td>\n",
       "      <td>La Bellezza</td>\n",
       "      <td>https://s3-media2.fl.yelpcdn.com/bphoto/75SVEM...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/la-bellezza-new-york?...</td>\n",
       "      <td>309</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}]</td>\n",
       "      <td>4.1</td>\n",
       "      <td>{'latitude': 40.7557792663574, 'longitude': -7...</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>$</td>\n",
       "      <td>{'address1': '145 E 49th St', 'address2': '', ...</td>\n",
       "      <td>+12128713223</td>\n",
       "      <td>(212) 871-3223</td>\n",
       "      <td>426.901061</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2-GsvFaQpVpbaIdwb9lSeQ</td>\n",
       "      <td>andiamo-pizza-new-york-2</td>\n",
       "      <td>Andiamo Pizza</td>\n",
       "      <td>https://s3-media2.fl.yelpcdn.com/bphoto/1p0cE3...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/andiamo-pizza-new-yor...</td>\n",
       "      <td>212</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}, {'alias...</td>\n",
       "      <td>4.5</td>\n",
       "      <td>{'latitude': 40.746144, 'longitude': -73.990189}</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{'address1': '818 6th Ave', 'address2': None, ...</td>\n",
       "      <td>+12122542860</td>\n",
       "      <td>(212) 254-2860</td>\n",
       "      <td>2263.112274</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>vVVmHacu2YAxKfpIjhfd1g</td>\n",
       "      <td>norma-new-york-5</td>\n",
       "      <td>Norma</td>\n",
       "      <td>https://s3-media3.fl.yelpcdn.com/bphoto/qJKt5l...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/norma-new-york-5?adju...</td>\n",
       "      <td>670</td>\n",
       "      <td>[{'alias': 'italian', 'title': 'Italian'}, {'a...</td>\n",
       "      <td>4.4</td>\n",
       "      <td>{'latitude': 40.743553, 'longitude': -73.980026}</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>$$</td>\n",
       "      <td>{'address1': '438 3rd Ave', 'address2': None, ...</td>\n",
       "      <td>+12128890600</td>\n",
       "      <td>(212) 889-0600</td>\n",
       "      <td>1942.291384</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>WG639VkTjmK5dzydd1BBJA</td>\n",
       "      <td>rubirosa-new-york-2</td>\n",
       "      <td>Rubirosa</td>\n",
       "      <td>https://s3-media3.fl.yelpcdn.com/bphoto/l0Phrn...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/rubirosa-new-york-2?a...</td>\n",
       "      <td>3400</td>\n",
       "      <td>[{'alias': 'italian', 'title': 'Italian'}, {'a...</td>\n",
       "      <td>4.3</td>\n",
       "      <td>{'latitude': 40.722766, 'longitude': -73.996233}</td>\n",
       "      <td>[pickup]</td>\n",
       "      <td>$$</td>\n",
       "      <td>{'address1': '235 Mulberry St', 'address2': ''...</td>\n",
       "      <td>+12129650500</td>\n",
       "      <td>(212) 965-0500</td>\n",
       "      <td>4629.739254</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        id                                alias  \\\n",
       "0   KEEXuHCYhsQJ-zpJhu98bA              joes-pizza-new-york-148   \n",
       "1   oRdM7n-AfBPBGAlH4Q0Sag    my-pie-pizzeria-romana-new-york-2   \n",
       "2   G9hV4H2iGpWD8RoUpjtokg        l-industrie-pizzeria-new-york   \n",
       "3   zj8Lq1T8KIC5zwFief15jg       prince-street-pizza-new-york-2   \n",
       "4   EXQ0x2W9RTydIlHAU9MU1A     mimis-pizza-east-86th-new-york-2   \n",
       "5   GgdR6L49eKH5drPaOYOOPQ                 pops-pizzas-new-york   \n",
       "6   -9NO2IDCJMyNGZMAQ1-VQw            ny-pizza-suprema-new-york   \n",
       "7   v1DHGRNCH9247WLYoaoA9A        l-industrie-pizzeria-brooklyn   \n",
       "8   ypJRRRKZtaNad--1EbRBTg   roma-pizza-and-restaurant-new-york   \n",
       "9   YchMTqpM6xksrpqXR0YUrQ                xeno-s-pizza-new-york   \n",
       "10  AOZlppihRNG8Y2N4Jid30A      brooklyn-pizza-masters-new-york   \n",
       "11  tRIHhPKryUZ56SfIz6mLiA  angelos-coal-oven-pizzeria-new-york   \n",
       "12  KEgdfVEVVgJFnGFiLNPDzQ          sofia-pizza-shoppe-new-york   \n",
       "13  iUnELVbiyEszV8DiVB3CTA           see-no-evil-pizza-new-york   \n",
       "14  XujJhk-uQQezYgxyx-YN5Q                       parla-new-york   \n",
       "15  V4-ds3mhlB7uLLY9qfZTJQ        abitinos-pizzeria-new-york-17   \n",
       "16  2MuvmwOuwvGOWkBimhniLA                 la-bellezza-new-york   \n",
       "17  2-GsvFaQpVpbaIdwb9lSeQ             andiamo-pizza-new-york-2   \n",
       "18  vVVmHacu2YAxKfpIjhfd1g                     norma-new-york-5   \n",
       "19  WG639VkTjmK5dzydd1BBJA                  rubirosa-new-york-2   \n",
       "\n",
       "                           name  \\\n",
       "0                   Joe's Pizza   \n",
       "1        My Pie Pizzeria Romana   \n",
       "2          L’industrie Pizzeria   \n",
       "3           Prince Street Pizza   \n",
       "4      Mimi's Pizza - East 86th   \n",
       "5                  Pop's Pizzas   \n",
       "6              NY Pizza Suprema   \n",
       "7          L'industrie Pizzeria   \n",
       "8       Roma Pizza & Restaurant   \n",
       "9                  Xeno’s Pizza   \n",
       "10       Brooklyn Pizza Masters   \n",
       "11  Angelo's Coal Oven Pizzeria   \n",
       "12           Sofia Pizza Shoppe   \n",
       "13            See No Evil Pizza   \n",
       "14                        Parla   \n",
       "15           Abitino's Pizzeria   \n",
       "16                  La Bellezza   \n",
       "17                Andiamo Pizza   \n",
       "18                        Norma   \n",
       "19                     Rubirosa   \n",
       "\n",
       "                                            image_url  is_closed  \\\n",
       "0   https://s3-media4.fl.yelpcdn.com/bphoto/FluVgK...      False   \n",
       "1   https://s3-media1.fl.yelpcdn.com/bphoto/b3BIzM...      False   \n",
       "2   https://s3-media4.fl.yelpcdn.com/bphoto/Hzdlv1...      False   \n",
       "3   https://s3-media1.fl.yelpcdn.com/bphoto/Jo9jBP...      False   \n",
       "4   https://s3-media3.fl.yelpcdn.com/bphoto/btcWJW...      False   \n",
       "5   https://s3-media2.fl.yelpcdn.com/bphoto/K51H3t...      False   \n",
       "6   https://s3-media4.fl.yelpcdn.com/bphoto/EqbDXn...      False   \n",
       "7   https://s3-media1.fl.yelpcdn.com/bphoto/1-VBwA...      False   \n",
       "8   https://s3-media2.fl.yelpcdn.com/bphoto/LA5DKU...      False   \n",
       "9   https://s3-media1.fl.yelpcdn.com/bphoto/dVkXWN...      False   \n",
       "10  https://s3-media1.fl.yelpcdn.com/bphoto/Dko2of...      False   \n",
       "11  https://s3-media2.fl.yelpcdn.com/bphoto/0XEf78...      False   \n",
       "12  https://s3-media2.fl.yelpcdn.com/bphoto/XTOP8k...      False   \n",
       "13  https://s3-media3.fl.yelpcdn.com/bphoto/XOTyid...      False   \n",
       "14  https://s3-media3.fl.yelpcdn.com/bphoto/65VnWT...      False   \n",
       "15  https://s3-media2.fl.yelpcdn.com/bphoto/7RzwMz...      False   \n",
       "16  https://s3-media2.fl.yelpcdn.com/bphoto/75SVEM...      False   \n",
       "17  https://s3-media2.fl.yelpcdn.com/bphoto/1p0cE3...      False   \n",
       "18  https://s3-media3.fl.yelpcdn.com/bphoto/qJKt5l...      False   \n",
       "19  https://s3-media3.fl.yelpcdn.com/bphoto/l0Phrn...      False   \n",
       "\n",
       "                                                  url  review_count  \\\n",
       "0   https://www.yelp.com/biz/joes-pizza-new-york-1...          2307   \n",
       "1   https://www.yelp.com/biz/my-pie-pizzeria-roman...           937   \n",
       "2   https://www.yelp.com/biz/l-industrie-pizzeria-...           322   \n",
       "3   https://www.yelp.com/biz/prince-street-pizza-n...          5346   \n",
       "4   https://www.yelp.com/biz/mimis-pizza-east-86th...           211   \n",
       "5   https://www.yelp.com/biz/pops-pizzas-new-york?...           231   \n",
       "6   https://www.yelp.com/biz/ny-pizza-suprema-new-...          2682   \n",
       "7   https://www.yelp.com/biz/l-industrie-pizzeria-...          1368   \n",
       "8   https://www.yelp.com/biz/roma-pizza-and-restau...            52   \n",
       "9   https://www.yelp.com/biz/xeno-s-pizza-new-york...            39   \n",
       "10  https://www.yelp.com/biz/brooklyn-pizza-master...           258   \n",
       "11  https://www.yelp.com/biz/angelos-coal-oven-piz...          1329   \n",
       "12  https://www.yelp.com/biz/sofia-pizza-shoppe-ne...           262   \n",
       "13  https://www.yelp.com/biz/see-no-evil-pizza-new...            17   \n",
       "14  https://www.yelp.com/biz/parla-new-york?adjust...            91   \n",
       "15  https://www.yelp.com/biz/abitinos-pizzeria-new...            69   \n",
       "16  https://www.yelp.com/biz/la-bellezza-new-york?...           309   \n",
       "17  https://www.yelp.com/biz/andiamo-pizza-new-yor...           212   \n",
       "18  https://www.yelp.com/biz/norma-new-york-5?adju...           670   \n",
       "19  https://www.yelp.com/biz/rubirosa-new-york-2?a...          3400   \n",
       "\n",
       "                                           categories  rating  \\\n",
       "0              [{'alias': 'pizza', 'title': 'Pizza'}]     4.2   \n",
       "1              [{'alias': 'pizza', 'title': 'Pizza'}]     4.4   \n",
       "2              [{'alias': 'pizza', 'title': 'Pizza'}]     4.6   \n",
       "3   [{'alias': 'pizza', 'title': 'Pizza'}, {'alias...     4.3   \n",
       "4              [{'alias': 'pizza', 'title': 'Pizza'}]     4.5   \n",
       "5              [{'alias': 'pizza', 'title': 'Pizza'}]     4.6   \n",
       "6              [{'alias': 'pizza', 'title': 'Pizza'}]     4.3   \n",
       "7              [{'alias': 'pizza', 'title': 'Pizza'}]     4.7   \n",
       "8   [{'alias': 'pizza', 'title': 'Pizza'}, {'alias...     4.7   \n",
       "9              [{'alias': 'pizza', 'title': 'Pizza'}]     4.2   \n",
       "10  [{'alias': 'pizza', 'title': 'Pizza'}, {'alias...     4.3   \n",
       "11  [{'alias': 'pizza', 'title': 'Pizza'}, {'alias...     4.0   \n",
       "12             [{'alias': 'pizza', 'title': 'Pizza'}]     4.4   \n",
       "13             [{'alias': 'pizza', 'title': 'Pizza'}]     4.8   \n",
       "14  [{'alias': 'pizza', 'title': 'Pizza'}, {'alias...     4.3   \n",
       "15             [{'alias': 'pizza', 'title': 'Pizza'}]     4.3   \n",
       "16             [{'alias': 'pizza', 'title': 'Pizza'}]     4.1   \n",
       "17  [{'alias': 'pizza', 'title': 'Pizza'}, {'alias...     4.5   \n",
       "18  [{'alias': 'italian', 'title': 'Italian'}, {'a...     4.4   \n",
       "19  [{'alias': 'italian', 'title': 'Italian'}, {'a...     4.3   \n",
       "\n",
       "                                          coordinates        transactions  \\\n",
       "0       {'latitude': 40.7547, 'longitude': -73.98696}  [delivery, pickup]   \n",
       "1   {'latitude': 40.7608512, 'longitude': -73.9694...  [delivery, pickup]   \n",
       "2   {'latitude': 40.73323443774397, 'longitude': -...                  []   \n",
       "3   {'latitude': 40.72308755605564, 'longitude': -...  [delivery, pickup]   \n",
       "4    {'latitude': 40.778638, 'longitude': -73.952895}  [delivery, pickup]   \n",
       "5    {'latitude': 40.767085, 'longitude': -73.983103}  [delivery, pickup]   \n",
       "6   {'latitude': 40.7502059936523, 'longitude': -7...  [delivery, pickup]   \n",
       "7      {'latitude': 40.71162, 'longitude': -73.95783}          [delivery]   \n",
       "8    {'latitude': 40.751211, 'longitude': -73.986364}  [delivery, pickup]   \n",
       "9      {'latitude': 40.75728, 'longitude': -73.97008}  [delivery, pickup]   \n",
       "10  {'latitude': 40.75869828079016, 'longitude': -...  [delivery, pickup]   \n",
       "11     {'latitude': 40.76492, 'longitude': -73.97794}  [delivery, pickup]   \n",
       "12     {'latitude': 40.75674, 'longitude': -73.96431}  [delivery, pickup]   \n",
       "13   {'latitude': 40.761482, 'longitude': -73.984508}  [delivery, pickup]   \n",
       "14  {'latitude': 40.779604142118245, 'longitude': ...                  []   \n",
       "15     {'latitude': 40.75958, 'longitude': -73.97747}  [delivery, pickup]   \n",
       "16  {'latitude': 40.7557792663574, 'longitude': -7...  [delivery, pickup]   \n",
       "17   {'latitude': 40.746144, 'longitude': -73.990189}  [delivery, pickup]   \n",
       "18   {'latitude': 40.743553, 'longitude': -73.980026}  [delivery, pickup]   \n",
       "19   {'latitude': 40.722766, 'longitude': -73.996233}            [pickup]   \n",
       "\n",
       "   price                                           location         phone  \\\n",
       "0      $  {'address1': '1435 Broadway', 'address2': '', ...  +16465594878   \n",
       "1     $$  {'address1': '690 Lexington Ave', 'address2': ...  +12123171850   \n",
       "2    NaN  {'address1': '104 Christopher St', 'address2':...  +12122560648   \n",
       "3      $  {'address1': '27 Prince St', 'address2': None,...  +12129664100   \n",
       "4    NaN  {'address1': '217 E 86th St', 'address2': None...  +16468612518   \n",
       "5      $  {'address1': '301 West 57th St', 'address2': '...  +12127848863   \n",
       "6     $$  {'address1': '413 8th Ave', 'address2': '', 'a...  +12125948939   \n",
       "7     $$  {'address1': '254 S 2nd St', 'address2': '', '...  +17185990002   \n",
       "8    NaN  {'address1': '980 6th Ave', 'address2': None, ...  +12124578555   \n",
       "9    NaN  {'address1': '163 E 52nd St', 'address2': '', ...  +16469520030   \n",
       "10   NaN  {'address1': '1055 1st Ave', 'address2': '', '...  +16466697757   \n",
       "11    $$  {'address1': '117 W 57th St', 'address2': '', ...  +12123334333   \n",
       "12     $  {'address1': '989 1st Ave', 'address2': '', 'a...  +12128888816   \n",
       "13   NaN  {'address1': '210 W 50th St', 'address2': 'Con...                 \n",
       "14    $$  {'address1': '320 Columbus Ave', 'address2': '...  +12127029006   \n",
       "15   NaN  {'address1': '5 West 51 St', 'address2': None,...  +12123566181   \n",
       "16     $  {'address1': '145 E 49th St', 'address2': '', ...  +12128713223   \n",
       "17   NaN  {'address1': '818 6th Ave', 'address2': None, ...  +12122542860   \n",
       "18    $$  {'address1': '438 3rd Ave', 'address2': None, ...  +12128890600   \n",
       "19    $$  {'address1': '235 Mulberry St', 'address2': ''...  +12129650500   \n",
       "\n",
       "     display_phone     distance  \n",
       "0   (646) 559-4878  1552.864538  \n",
       "1   (212) 317-1850   186.582143  \n",
       "2   (212) 256-0648  4144.896542  \n",
       "3   (212) 966-4100  4530.158358  \n",
       "4   (646) 861-2518  2577.937315  \n",
       "5   (212) 784-8863  1440.059800  \n",
       "6   (212) 594-8939  2387.061955  \n",
       "7   (718) 599-0002  5382.969881  \n",
       "8   (212) 457-8555  1669.751661  \n",
       "9   (646) 952-0030   210.615637  \n",
       "10  (646) 669-7757   563.011393  \n",
       "11  (212) 333-4333   951.371291  \n",
       "12  (212) 888-8816   520.331233  \n",
       "13                  1284.287725  \n",
       "14  (212) 702-9006  2369.543702  \n",
       "15  (212) 356-6181   667.902841  \n",
       "16  (212) 871-3223   426.901061  \n",
       "17  (212) 254-2860  2263.112274  \n",
       "18  (212) 889-0600  1942.291384  \n",
       "19  (212) 965-0500  4629.739254  "
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(results['businesses'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "c95f32aa",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Save the API response as a JSON file\n",
    "with open(JSON_FILE, 'w') as f:\n",
    "    json.dump(results['businesses'], f)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "e641864b",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Read the JSON file into a DataFrame\n",
    "df = pd.read_json(JSON_FILE)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "2867019d",
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 20 entries, 0 to 19\n",
      "Data columns (total 16 columns):\n",
      " #   Column         Non-Null Count  Dtype  \n",
      "---  ------         --------------  -----  \n",
      " 0   id             20 non-null     object \n",
      " 1   alias          20 non-null     object \n",
      " 2   name           20 non-null     object \n",
      " 3   image_url      20 non-null     object \n",
      " 4   is_closed      20 non-null     bool   \n",
      " 5   url            20 non-null     object \n",
      " 6   review_count   20 non-null     int64  \n",
      " 7   categories     20 non-null     object \n",
      " 8   rating         20 non-null     float64\n",
      " 9   coordinates    20 non-null     object \n",
      " 10  transactions   20 non-null     object \n",
      " 11  price          12 non-null     object \n",
      " 12  location       20 non-null     object \n",
      " 13  phone          20 non-null     object \n",
      " 14  display_phone  20 non-null     object \n",
      " 15  distance       20 non-null     float64\n",
      "dtypes: bool(1), float64(2), int64(1), object(12)\n",
      "memory usage: 2.5+ KB\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 20 entries, 0 to 19\n",
      "Data columns (total 16 columns):\n",
      " #   Column         Non-Null Count  Dtype  \n",
      "---  ------         --------------  -----  \n",
      " 0   id             20 non-null     object \n",
      " 1   alias          20 non-null     object \n",
      " 2   name           20 non-null     object \n",
      " 3   image_url      20 non-null     object \n",
      " 4   is_closed      20 non-null     bool   \n",
      " 5   url            20 non-null     object \n",
      " 6   review_count   20 non-null     int64  \n",
      " 7   categories     20 non-null     object \n",
      " 8   rating         20 non-null     float64\n",
      " 9   coordinates    20 non-null     object \n",
      " 10  transactions   20 non-null     object \n",
      " 11  price          12 non-null     object \n",
      " 12  location       20 non-null     object \n",
      " 13  phone          20 non-null     object \n",
      " 14  display_phone  20 non-null     object \n",
      " 15  distance       20 non-null     float64\n",
      "dtypes: bool(1), float64(2), int64(1), object(12)\n",
      "memory usage: 2.5+ KB\n"
     ]
    }
   ],
   "source": [
    "# Looking at the data\n",
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "2a1bf1a9",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "5e2d6e45",
   "metadata": {},
   "outputs": [],
   "source": [
    "limit = 50"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "ac63f555",
   "metadata": {},
   "outputs": [],
   "source": [
    "results = yelp.search_query(term=term, location='Queens', limit=1)\n",
    "total_results = results['total']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "3ef112de",
   "metadata": {},
   "outputs": [],
   "source": [
    "limit = min(total_results, limit)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "c5a42e70",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "num_batches = (total_results // limit) + 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "280c3ee4",
   "metadata": {},
   "outputs": [],
   "source": [
    "max_results = 1000"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "793ac9d8",
   "metadata": {},
   "outputs": [],
   "source": [
    "all_results = []"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "76433213",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "An error occurred: VALIDATION_ERROR: Too many results requested, limit+offset must be <= 240.\n",
      "Total results fetched: 200\n",
      "An error occurred: VALIDATION_ERROR: Too many results requested, limit+offset must be <= 240.\n",
      "Total results fetched: 200\n"
     ]
    }
   ],
   "source": [
    "# Calculate number of batches needed\n",
    "num_batches = max_results // limit\n",
    "\n",
    "for batch in range(num_batches):\n",
    "    offset = batch * limit\n",
    "    try:\n",
    "        results = yelp.search_query(term=term, location=location, limit=limit, offset=offset, categories='pizza')\n",
    "        all_results.extend(results['businesses'])\n",
    "    except YelpAPI.YelpAPIError as e:\n",
    "        print(f\"An error occurred: {e}\")\n",
    "        break\n",
    "\n",
    "# If there are any remaining results to fetch within the limit of 1000\n",
    "remaining_results = max_results % limit\n",
    "if remaining_results > 0:\n",
    "    offset = num_batches * limit\n",
    "    try:\n",
    "        results = yelp.search_query(term=term, location=location, limit=remaining_results, offset=offset, categories='pizza')\n",
    "        all_results.extend(results['businesses'])\n",
    "    except YelpAPI.YelpAPIError as e:\n",
    "        print(f\"An error occurred: {e}\")\n",
    "\n",
    "print(f\"Total results fetched: {len(all_results)}\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "f94ab16c",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Save all results to the JSON file\n",
    "with open(JSON_FILE, 'w') as f:\n",
    "    json.dump(all_results, f)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "4e0771b6",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Read the JSON file into a DataFrame\n",
    "df = pd.read_json(JSON_FILE)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python (dojo-env)",
   "language": "python",
   "name": "dojo-env"
  },
  "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.9.15"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}