Yelp.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "thirty-rebound",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "import requests\n",
    "import pandas as pd\n",
    "import geopandas as gpd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "heard-indication",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'businesses': [{'id': 'eab04KSBbf30FqB4cH8erQ',\n",
       "   'alias': 'umami-ramen-and-dumpling-bar-madison',\n",
       "   'name': 'Umami Ramen & Dumpling Bar',\n",
       "   'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/jK8LI9SUO0rgO_Ydqqoh7w/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/umami-ramen-and-dumpling-bar-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 387,\n",
       "   'categories': [{'alias': 'japanese', 'title': 'Japanese'},\n",
       "    {'alias': 'chinese', 'title': 'Chinese'},\n",
       "    {'alias': 'taiwanese', 'title': 'Taiwanese'}],\n",
       "   'rating': 3.5,\n",
       "   'coordinates': {'latitude': 43.0798377, 'longitude': -89.3687295},\n",
       "   'transactions': ['delivery', 'pickup'],\n",
       "   'price': '$$',\n",
       "   'location': {'address1': '923 Williamson St',\n",
       "    'address2': '',\n",
       "    'address3': '',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53703',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['923 Williamson St', 'Madison, WI 53703']},\n",
       "   'phone': '+16088196319',\n",
       "   'display_phone': '(608) 819-6319',\n",
       "   'distance': 2745.489121830829},\n",
       "  {'id': 'soIfkcfwujR-Na1lprr-XA',\n",
       "   'alias': 'breakwater-monona',\n",
       "   'name': 'Breakwater',\n",
       "   'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/LMJKUNEAmgoyyI2WahWFDA/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/breakwater-monona?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 77,\n",
       "   'categories': [{'alias': 'newamerican', 'title': 'American (New)'},\n",
       "    {'alias': 'cocktailbars', 'title': 'Cocktail Bars'},\n",
       "    {'alias': 'burgers', 'title': 'Burgers'}],\n",
       "   'rating': 3.5,\n",
       "   'coordinates': {'latitude': 43.0488089, 'longitude': -89.3371995},\n",
       "   'transactions': ['delivery'],\n",
       "   'price': '$$',\n",
       "   'location': {'address1': '6308 Metropolitan Ln',\n",
       "    'address2': '',\n",
       "    'address3': None,\n",
       "    'city': 'Monona',\n",
       "    'zip_code': '53713',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['6308 Metropolitan Ln', 'Monona, WI 53713']},\n",
       "   'phone': '+16084165388',\n",
       "   'display_phone': '(608) 416-5388',\n",
       "   'distance': 5865.567302056555},\n",
       "  {'id': 'X0siHN0KchBjGKn9QsEAFg',\n",
       "   'alias': 'vintage-spirits-and-grill-madison',\n",
       "   'name': 'Vintage Spirits & Grill',\n",
       "   'image_url': 'https://s3-media3.fl.yelpcdn.com/bphoto/viJpWL7qVnF6e3Y8mig4RA/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/vintage-spirits-and-grill-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 66,\n",
       "   'categories': [{'alias': 'breakfast_brunch', 'title': 'Breakfast & Brunch'},\n",
       "    {'alias': 'newamerican', 'title': 'American (New)'},\n",
       "    {'alias': 'beerbar', 'title': 'Beer Bar'}],\n",
       "   'rating': 4.0,\n",
       "   'coordinates': {'latitude': 43.07299, 'longitude': -89.3955},\n",
       "   'transactions': ['delivery', 'pickup'],\n",
       "   'price': '$',\n",
       "   'location': {'address1': '529 University Ave',\n",
       "    'address2': '',\n",
       "    'address3': '',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53703',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['529 University Ave', 'Madison, WI 53703']},\n",
       "   'phone': '+16082500700',\n",
       "   'display_phone': '(608) 250-0700',\n",
       "   'distance': 470.0176610289135},\n",
       "  {'id': 'i60v66vwf1A13YqcIqGD_A',\n",
       "   'alias': 'montys-blue-plate-diner-madison',\n",
       "   'name': \"Monty's Blue Plate Diner\",\n",
       "   'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/DW9UO4ovc8GJAITUcmc7Ew/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/montys-blue-plate-diner-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 580,\n",
       "   'categories': [{'alias': 'diners', 'title': 'Diners'},\n",
       "    {'alias': 'tradamerican', 'title': 'American (Traditional)'},\n",
       "    {'alias': 'vegetarian', 'title': 'Vegetarian'}],\n",
       "   'rating': 4.0,\n",
       "   'coordinates': {'latitude': 43.09242, 'longitude': -89.3518969},\n",
       "   'transactions': ['delivery'],\n",
       "   'price': '$$',\n",
       "   'location': {'address1': '2089 Atwood Ave',\n",
       "    'address2': '',\n",
       "    'address3': '',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53704',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['2089 Atwood Ave', 'Madison, WI 53704']},\n",
       "   'phone': '+16082448505',\n",
       "   'display_phone': '(608) 244-8505',\n",
       "   'distance': 4548.688951382061},\n",
       "  {'id': '3Z4pcWY2xnyZumGmsoXIVA',\n",
       "   'alias': 'porter-madison-3',\n",
       "   'name': 'Porter',\n",
       "   'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/Yz2KA771hme1nh63cEY5Ew/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/porter-madison-3?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 70,\n",
       "   'categories': [{'alias': 'coffee', 'title': 'Coffee & Tea'},\n",
       "    {'alias': 'breakfast_brunch', 'title': 'Breakfast & Brunch'},\n",
       "    {'alias': 'tacos', 'title': 'Tacos'}],\n",
       "   'rating': 4.0,\n",
       "   'coordinates': {'latitude': 43.06829, 'longitude': -89.3948},\n",
       "   'transactions': ['delivery'],\n",
       "   'price': '$',\n",
       "   'location': {'address1': '640 W Washington Ave',\n",
       "    'address2': 'Ste 101',\n",
       "    'address3': None,\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53703',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['640 W Washington Ave',\n",
       "     'Ste 101',\n",
       "     'Madison, WI 53703']},\n",
       "   'phone': '+16087201110',\n",
       "   'display_phone': '(608) 720-1110',\n",
       "   'distance': 777.7196537745776},\n",
       "  {'id': 'F9ghY9oiVXWw9J0jU1E1lA',\n",
       "   'alias': 'heritage-bbq-and-to-go-fitchburg',\n",
       "   'name': 'Heritage BBQ & To-Go',\n",
       "   'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/29mt_fDHkUv5aERVm2_VQA/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/heritage-bbq-and-to-go-fitchburg?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 9,\n",
       "   'categories': [{'alias': 'bbq', 'title': 'Barbeque'},\n",
       "    {'alias': 'beerbar', 'title': 'Beer Bar'}],\n",
       "   'rating': 4.5,\n",
       "   'coordinates': {'latitude': 43.014806, 'longitude': -89.458028},\n",
       "   'transactions': [],\n",
       "   'location': {'address1': '5957 McKee Rd',\n",
       "    'address2': '',\n",
       "    'address3': None,\n",
       "    'city': 'Fitchburg',\n",
       "    'zip_code': '53719',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['5957 McKee Rd', 'Fitchburg, WI 53719']},\n",
       "   'phone': '+16082839500',\n",
       "   'display_phone': '(608) 283-9500',\n",
       "   'distance': 7952.9831611432455},\n",
       "  {'id': 'OnKyFU0FsiPVd8Jwl6st6g',\n",
       "   'alias': 'fromagination-madison',\n",
       "   'name': 'Fromagination',\n",
       "   'image_url': 'https://s3-media3.fl.yelpcdn.com/bphoto/_mYOzfOyUREDJPk7fxEIPA/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/fromagination-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 226,\n",
       "   'categories': [{'alias': 'cheese', 'title': 'Cheese Shops'},\n",
       "    {'alias': 'sandwiches', 'title': 'Sandwiches'},\n",
       "    {'alias': 'cheesetastingclasses', 'title': 'Cheese Tasting Classes'}],\n",
       "   'rating': 4.5,\n",
       "   'coordinates': {'latitude': 43.0734313842218,\n",
       "    'longitude': -89.384942302724},\n",
       "   'transactions': ['delivery'],\n",
       "   'price': '$$',\n",
       "   'location': {'address1': '12 S Carroll St',\n",
       "    'address2': '',\n",
       "    'address3': '',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53703',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['12 S Carroll St', 'Madison, WI 53703']},\n",
       "   'phone': '+16082552430',\n",
       "   'display_phone': '(608) 255-2430',\n",
       "   'distance': 1323.6559779524987},\n",
       "  {'id': 'zEGAtxktaC-r5IvvZVgjoA',\n",
       "   'alias': 'the-bar-madison',\n",
       "   'name': 'The Bar',\n",
       "   'image_url': 'https://s3-media4.fl.yelpcdn.com/bphoto/cW6Io2zxWZVt_DDYVxTlnw/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/the-bar-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 13,\n",
       "   'categories': [{'alias': 'bars', 'title': 'Bars'},\n",
       "    {'alias': 'sandwiches', 'title': 'Sandwiches'}],\n",
       "   'rating': 4.5,\n",
       "   'coordinates': {'latitude': 43.075625, 'longitude': -89.386593},\n",
       "   'transactions': [],\n",
       "   'price': '$$',\n",
       "   'location': {'address1': '1 W Dayton St',\n",
       "    'address2': '',\n",
       "    'address3': '',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53703',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['1 W Dayton St', 'Madison, WI 53703']},\n",
       "   'phone': '+18003568293',\n",
       "   'display_phone': '(800) 356-8293',\n",
       "   'distance': 1222.8467248842142},\n",
       "  {'id': 'Wh9uMJIuTxAtPHK6MJUt-Q',\n",
       "   'alias': 'mi-madison',\n",
       "   'name': 'Mi',\n",
       "   'image_url': 'https://s3-media3.fl.yelpcdn.com/bphoto/g9X82fQcFOL1-EQIiAyauQ/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/mi-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 1,\n",
       "   'categories': [{'alias': 'sandwiches', 'title': 'Sandwiches'}],\n",
       "   'rating': 4.0,\n",
       "   'coordinates': {'latitude': 43.0732519179583,\n",
       "    'longitude': -89.4017346203327},\n",
       "   'transactions': [],\n",
       "   'location': {'address1': '950 University Ave',\n",
       "    'address2': '',\n",
       "    'address3': None,\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53706',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['950 University Ave', 'Madison, WI 53706']},\n",
       "   'phone': '+16087744549',\n",
       "   'display_phone': '(608) 774-4549',\n",
       "   'distance': 89.67542315260609},\n",
       "  {'id': 'Wf7AV7JbR52qABil0bU8NA',\n",
       "   'alias': 'the-boathouse-madison',\n",
       "   'name': 'The Boathouse',\n",
       "   'image_url': 'https://s3-media3.fl.yelpcdn.com/bphoto/Z0jh1ZssR-Q2K_llRQABsQ/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/the-boathouse-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 90,\n",
       "   'categories': [{'alias': 'tradamerican', 'title': 'American (Traditional)'},\n",
       "    {'alias': 'sandwiches', 'title': 'Sandwiches'}],\n",
       "   'rating': 2.5,\n",
       "   'coordinates': {'latitude': 43.079302, 'longitude': -89.3906446299791},\n",
       "   'transactions': [],\n",
       "   'price': '$$',\n",
       "   'location': {'address1': '1001 Wisconsin Pl',\n",
       "    'address2': '',\n",
       "    'address3': '',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53703',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['1001 Wisconsin Pl', 'Madison, WI 53703']},\n",
       "   'phone': '+16085358232',\n",
       "   'display_phone': '(608) 535-8232',\n",
       "   'distance': 1105.5890427435847},\n",
       "  {'id': 'iFWL9vaoRVQ172gzohhugQ',\n",
       "   'alias': 'jardin-at-robinia-courtyard-madison-2',\n",
       "   'name': 'Jardin at Robinia Courtyard',\n",
       "   'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/pphD-quIMIh1z4pBxGlFJg/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/jardin-at-robinia-courtyard-madison-2?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 38,\n",
       "   'categories': [{'alias': 'bars', 'title': 'Bars'},\n",
       "    {'alias': 'tapasmallplates', 'title': 'Tapas/Small Plates'},\n",
       "    {'alias': 'newamerican', 'title': 'American (New)'}],\n",
       "   'rating': 4.0,\n",
       "   'coordinates': {'latitude': 43.0815042588812,\n",
       "    'longitude': -89.3736290336059},\n",
       "   'transactions': ['delivery'],\n",
       "   'price': '$$',\n",
       "   'location': {'address1': '829 E Washington Ave',\n",
       "    'address2': '',\n",
       "    'address3': None,\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53703',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['829 E Washington Ave', 'Madison, WI 53703']},\n",
       "   'phone': '+16084780110',\n",
       "   'display_phone': '(608) 478-0110',\n",
       "   'distance': 2430.8462536611905},\n",
       "  {'id': 'Q_fvIdn5mGAyyJKniY1F7Q',\n",
       "   'alias': 'ramen-station-madison',\n",
       "   'name': 'Ramen Station',\n",
       "   'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/0I2JUiBMUL6SvA85fT_ebQ/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/ramen-station-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 103,\n",
       "   'categories': [{'alias': 'ramen', 'title': 'Ramen'}],\n",
       "   'rating': 3.5,\n",
       "   'coordinates': {'latitude': 43.054238, 'longitude': -89.396799},\n",
       "   'transactions': ['delivery', 'pickup'],\n",
       "   'price': '$$',\n",
       "   'location': {'address1': '1124 S Park St',\n",
       "    'address2': '',\n",
       "    'address3': '',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53715',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['1124 S Park St', 'Madison, WI 53715']},\n",
       "   'phone': '+16088198918',\n",
       "   'display_phone': '(608) 819-8918',\n",
       "   'distance': 2122.6528252272333},\n",
       "  {'id': 'NiBzh0kHusvH5rdnpm7yVw',\n",
       "   'alias': 'bandung-indonesian-restaurant-madison',\n",
       "   'name': 'Bandung Indonesian Restaurant',\n",
       "   'image_url': 'https://s3-media4.fl.yelpcdn.com/bphoto/dvd8QvZWGjFa6BvpzOXXHw/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/bandung-indonesian-restaurant-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 246,\n",
       "   'categories': [{'alias': 'indonesian', 'title': 'Indonesian'}],\n",
       "   'rating': 4.0,\n",
       "   'coordinates': {'latitude': 43.076604, 'longitude': -89.3745656},\n",
       "   'transactions': ['delivery', 'pickup'],\n",
       "   'price': '$$',\n",
       "   'location': {'address1': '600 Williamson St',\n",
       "    'address2': 'Ste M',\n",
       "    'address3': '',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53703',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['600 Williamson St', 'Ste M', 'Madison, WI 53703']},\n",
       "   'phone': '+16082556910',\n",
       "   'display_phone': '(608) 255-6910',\n",
       "   'distance': 2201.5184995398754},\n",
       "  {'id': 'VRTrhsYKSJo1kGX5RqBlFA',\n",
       "   'alias': 'belair-cantina-madison-2',\n",
       "   'name': 'Belair Cantina',\n",
       "   'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/mx4A8_jxoiTxOL4g23XaVQ/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/belair-cantina-madison-2?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 184,\n",
       "   'categories': [{'alias': 'mexican', 'title': 'Mexican'},\n",
       "    {'alias': 'bars', 'title': 'Bars'},\n",
       "    {'alias': 'gluten_free', 'title': 'Gluten-Free'}],\n",
       "   'rating': 3.5,\n",
       "   'coordinates': {'latitude': 43.0738, 'longitude': -89.3824},\n",
       "   'transactions': ['delivery', 'pickup'],\n",
       "   'price': '$$',\n",
       "   'location': {'address1': '111 Martin Luther King Jr Blvd',\n",
       "    'address2': '',\n",
       "    'address3': None,\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53703',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['111 Martin Luther King Jr Blvd',\n",
       "     'Madison, WI 53703']},\n",
       "   'phone': '+16086206040',\n",
       "   'display_phone': '(608) 620-6040',\n",
       "   'distance': 1510.7655792110334},\n",
       "  {'id': 'Xl6I0-JmFE_6w28bku2idQ',\n",
       "   'alias': 'himal-chuli-madison',\n",
       "   'name': 'Himal Chuli',\n",
       "   'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/5E7tsyTyo2vWD227-tpqrA/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/himal-chuli-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 252,\n",
       "   'categories': [{'alias': 'himalayan', 'title': 'Himalayan/Nepalese'}],\n",
       "   'rating': 4.0,\n",
       "   'coordinates': {'latitude': 43.07495, 'longitude': -89.39077},\n",
       "   'transactions': ['delivery', 'pickup'],\n",
       "   'price': '$$',\n",
       "   'location': {'address1': '318 State St',\n",
       "    'address2': '',\n",
       "    'address3': '',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53703',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['318 State St', 'Madison, WI 53703']},\n",
       "   'phone': '+16082519225',\n",
       "   'display_phone': '(608) 251-9225',\n",
       "   'distance': 873.7888824363857},\n",
       "  {'id': 'scM6rLQqoz5dEIgwz_JFsg',\n",
       "   'alias': 'haveli-restaurant-fitchburg',\n",
       "   'name': 'Haveli Restaurant',\n",
       "   'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/yWZ4j5gIaUsvTZAN14_DaQ/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/haveli-restaurant-fitchburg?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 142,\n",
       "   'categories': [{'alias': 'indpak', 'title': 'Indian'}],\n",
       "   'rating': 4.5,\n",
       "   'coordinates': {'latitude': 43.0149577177488,\n",
       "    'longitude': -89.4582483970144},\n",
       "   'transactions': ['delivery'],\n",
       "   'price': '$$',\n",
       "   'location': {'address1': '5957 McKee Rd',\n",
       "    'address2': '',\n",
       "    'address3': '',\n",
       "    'city': 'Fitchburg',\n",
       "    'zip_code': '53719',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['5957 McKee Rd', 'Fitchburg, WI 53719']},\n",
       "   'phone': '+16082743333',\n",
       "   'display_phone': '(608) 274-3333',\n",
       "   'distance': 7949.673542337535},\n",
       "  {'id': 'e-r7PKs_7OzLaqGVXJX2vg',\n",
       "   'alias': 'hibachi-hut-madison',\n",
       "   'name': 'Hibachi Hut',\n",
       "   'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/ST_Rp5rkH1T4ghfOHOzrVA/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/hibachi-hut-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 2,\n",
       "   'categories': [{'alias': 'chinese', 'title': 'Chinese'},\n",
       "    {'alias': 'japanese', 'title': 'Japanese'}],\n",
       "   'rating': 3.5,\n",
       "   'coordinates': {'latitude': 43.0748936616907,\n",
       "    'longitude': -89.3982946872711},\n",
       "   'transactions': [],\n",
       "   'location': {'address1': '716-798 State St',\n",
       "    'address2': '',\n",
       "    'address3': 'University of Wisconsin-Madison',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53706',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['716-798 State St',\n",
       "     'University of Wisconsin-Madison',\n",
       "     'Madison, WI 53706']},\n",
       "   'phone': '',\n",
       "   'display_phone': '',\n",
       "   'distance': 314.36577757067244},\n",
       "  {'id': 'jE5lfHPvsuNCJijXWaPqTw',\n",
       "   'alias': 'madison-club-madison',\n",
       "   'name': 'Madison Club',\n",
       "   'image_url': 'https://s3-media4.fl.yelpcdn.com/bphoto/ra3eL-PNQgPLEqcGrcBJ3w/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/madison-club-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 22,\n",
       "   'categories': [{'alias': 'newamerican', 'title': 'American (New)'},\n",
       "    {'alias': 'bars', 'title': 'Bars'},\n",
       "    {'alias': 'venues', 'title': 'Venues & Event Spaces'}],\n",
       "   'rating': 4.0,\n",
       "   'coordinates': {'latitude': 43.0724754333496,\n",
       "    'longitude': -89.380729675293},\n",
       "   'transactions': ['delivery'],\n",
       "   'price': '$$$$',\n",
       "   'location': {'address1': '5 E Wilson St',\n",
       "    'address2': '',\n",
       "    'address3': '',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53703',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['5 E Wilson St', 'Madison, WI 53703']},\n",
       "   'phone': '+16082554861',\n",
       "   'display_phone': '(608) 255-4861',\n",
       "   'distance': 1666.2948032005074},\n",
       "  {'id': 'HO2knNxcc_8lFtgGxN8q2A',\n",
       "   'alias': 'nitty-gritty-madison-madison',\n",
       "   'name': 'Nitty Gritty - Madison',\n",
       "   'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/jk_rGh-RuckbPfdRoMilrQ/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/nitty-gritty-madison-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 189,\n",
       "   'categories': [{'alias': 'bars', 'title': 'Bars'},\n",
       "    {'alias': 'tradamerican', 'title': 'American (Traditional)'}],\n",
       "   'rating': 3.5,\n",
       "   'coordinates': {'latitude': 43.0718116760254,\n",
       "    'longitude': -89.3956146240234},\n",
       "   'transactions': ['delivery', 'pickup'],\n",
       "   'price': '$$',\n",
       "   'location': {'address1': '223 N Frances St',\n",
       "    'address2': '',\n",
       "    'address3': '',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53703',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['223 N Frances St', 'Madison, WI 53703']},\n",
       "   'phone': '+16082512521',\n",
       "   'display_phone': '(608) 251-2521',\n",
       "   'distance': 477.266825570338},\n",
       "  {'id': 'h8k9AFDqj7fJGjRUZkJkYw',\n",
       "   'alias': 'fit-2-eat-madison',\n",
       "   'name': 'Fit 2 Eat',\n",
       "   'image_url': 'https://s3-media3.fl.yelpcdn.com/bphoto/ywLNaoNGy2ksSIAozrPbQg/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/fit-2-eat-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 10,\n",
       "   'categories': [{'alias': 'newamerican', 'title': 'American (New)'},\n",
       "    {'alias': 'sandwiches', 'title': 'Sandwiches'}],\n",
       "   'rating': 4.0,\n",
       "   'coordinates': {'latitude': 43.0610873, 'longitude': -89.4384874},\n",
       "   'transactions': [],\n",
       "   'price': '$',\n",
       "   'location': {'address1': '3742 Speedway Rd',\n",
       "    'address2': '',\n",
       "    'address3': '',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53705',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['3742 Speedway Rd', 'Madison, WI 53705']},\n",
       "   'phone': '+16082337192',\n",
       "   'display_phone': '(608) 233-7192',\n",
       "   'distance': 3306.023500570463},\n",
       "  {'id': 'TQSgOs4gahJ9g8Y_-whMsQ',\n",
       "   'alias': 'ogdens-north-street-diner-madison',\n",
       "   'name': \"Ogden's North Street Diner\",\n",
       "   'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/IbZWdWoV5xODzHHIstEjcQ/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/ogdens-north-street-diner-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 115,\n",
       "   'categories': [{'alias': 'diners', 'title': 'Diners'},\n",
       "    {'alias': 'breakfast_brunch', 'title': 'Breakfast & Brunch'}],\n",
       "   'rating': 4.5,\n",
       "   'coordinates': {'latitude': 43.1066979, 'longitude': -89.3514027},\n",
       "   'transactions': ['delivery'],\n",
       "   'price': '$',\n",
       "   'location': {'address1': '560 North St',\n",
       "    'address2': '',\n",
       "    'address3': None,\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53704',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['560 North St', 'Madison, WI 53704']},\n",
       "   'phone': '+16084673930',\n",
       "   'display_phone': '(608) 467-3930',\n",
       "   'distance': 5510.824434371463},\n",
       "  {'id': 'wQAAWFymmeojcGscan1GwA',\n",
       "   'alias': 'mr-seafood-madison',\n",
       "   'name': 'Mr. Seafood',\n",
       "   'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/yhV2jto6TTCRGCwzpGb3QA/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/mr-seafood-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 7,\n",
       "   'categories': [{'alias': 'seafood', 'title': 'Seafood'},\n",
       "    {'alias': 'chinese', 'title': 'Chinese'}],\n",
       "   'rating': 4.0,\n",
       "   'coordinates': {'latitude': 43.07682, 'longitude': -89.37459},\n",
       "   'transactions': ['delivery', 'pickup'],\n",
       "   'location': {'address1': '600 Williamson St',\n",
       "    'address2': None,\n",
       "    'address3': None,\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53703',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['600 Williamson St', 'Madison, WI 53703']},\n",
       "   'phone': '+16086309882',\n",
       "   'display_phone': '(608) 630-9882',\n",
       "   'distance': 2172.199442562806},\n",
       "  {'id': 'aVBFKYoF0AHuusNssaQpJA',\n",
       "   'alias': 'ians-pizza-on-state-madison-3',\n",
       "   'name': \"Ian's Pizza on State\",\n",
       "   'image_url': 'https://s3-media4.fl.yelpcdn.com/bphoto/5n5CQMoK5eCkVx6Dssxu5A/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/ians-pizza-on-state-madison-3?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 495,\n",
       "   'categories': [{'alias': 'pizza', 'title': 'Pizza'}],\n",
       "   'rating': 4.0,\n",
       "   'coordinates': {'latitude': 43.07494, 'longitude': -89.38702},\n",
       "   'transactions': ['delivery', 'pickup'],\n",
       "   'price': '$',\n",
       "   'location': {'address1': '100 State St',\n",
       "    'address2': None,\n",
       "    'address3': '',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53703',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['100 State St', 'Madison, WI 53703']},\n",
       "   'phone': '+16082579248',\n",
       "   'display_phone': '(608) 257-9248',\n",
       "   'distance': 1174.3056985469784},\n",
       "  {'id': 'KYxQB66vtwUg7NhAhhW_HQ',\n",
       "   'alias': 'el-coqui-madison',\n",
       "   'name': 'El Coqui',\n",
       "   'image_url': 'https://s3-media1.fl.yelpcdn.com/bphoto/2_pZesvR_hDv5xyFgkCSDw/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/el-coqui-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 2,\n",
       "   'categories': [{'alias': 'puertorican', 'title': 'Puerto Rican'},\n",
       "    {'alias': 'desserts', 'title': 'Desserts'}],\n",
       "   'rating': 5.0,\n",
       "   'coordinates': {'latitude': 43.0747371, 'longitude': -89.38647},\n",
       "   'transactions': [],\n",
       "   'location': {'address1': '',\n",
       "    'address2': '',\n",
       "    'address3': None,\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53703',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['Madison, WI 53703']},\n",
       "   'phone': '+16086950380',\n",
       "   'display_phone': '(608) 695-0380',\n",
       "   'distance': 1213.4502553491745},\n",
       "  {'id': 'wQgY7CdljLdCJm6XIk1HuA',\n",
       "   'alias': 'cheba-hut-toasted-subs-madison-3',\n",
       "   'name': 'Cheba Hut Toasted Subs',\n",
       "   'image_url': 'https://s3-media4.fl.yelpcdn.com/bphoto/O4p5lF8lqcn32FX0XJbLQQ/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/cheba-hut-toasted-subs-madison-3?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 78,\n",
       "   'categories': [{'alias': 'sandwiches', 'title': 'Sandwiches'},\n",
       "    {'alias': 'beer_and_wine', 'title': 'Beer, Wine & Spirits'},\n",
       "    {'alias': 'catering', 'title': 'Caterers'}],\n",
       "   'rating': 4.5,\n",
       "   'coordinates': {'latitude': 43.073425, 'longitude': -89.394789},\n",
       "   'transactions': ['delivery', 'pickup'],\n",
       "   'price': '$',\n",
       "   'location': {'address1': '453 W Gilman St',\n",
       "    'address2': '',\n",
       "    'address3': '',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53703',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['453 W Gilman St', 'Madison, WI 53703']},\n",
       "   'phone': '+16088198485',\n",
       "   'display_phone': '(608) 819-8485',\n",
       "   'distance': 524.8251769524201},\n",
       "  {'id': 'hzgWqrkH-_mD_gZ-LBnhUw',\n",
       "   'alias': 'forage-kitchen-monona',\n",
       "   'name': 'Forage Kitchen',\n",
       "   'image_url': 'https://s3-media1.fl.yelpcdn.com/bphoto/MkFCKcQ6rRm1FAzNA6Hu3g/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/forage-kitchen-monona?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 11,\n",
       "   'categories': [{'alias': 'salad', 'title': 'Salad'},\n",
       "    {'alias': 'juicebars', 'title': 'Juice Bars & Smoothies'}],\n",
       "   'rating': 4.0,\n",
       "   'coordinates': {'latitude': 43.047755, 'longitude': -89.337122},\n",
       "   'transactions': ['delivery'],\n",
       "   'location': {'address1': '800 W Broadway',\n",
       "    'address2': 'Unit 700',\n",
       "    'address3': '',\n",
       "    'city': 'Monona',\n",
       "    'zip_code': '53713',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['800 W Broadway', 'Unit 700', 'Monona, WI 53713']},\n",
       "   'phone': '+16082306782',\n",
       "   'display_phone': '(608) 230-6782',\n",
       "   'distance': 5919.310530026525},\n",
       "  {'id': 'RcclDgLFBc_KzeZL03XcYw',\n",
       "   'alias': 'crave-coffee-madison',\n",
       "   'name': 'Crave Coffee',\n",
       "   'image_url': 'https://s3-media3.fl.yelpcdn.com/bphoto/KteDDnYZRByj6JmmGWpnkw/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/crave-coffee-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 11,\n",
       "   'categories': [{'alias': 'donuts', 'title': 'Donuts'},\n",
       "    {'alias': 'coffee', 'title': 'Coffee & Tea'},\n",
       "    {'alias': 'breakfast_brunch', 'title': 'Breakfast & Brunch'}],\n",
       "   'rating': 3.0,\n",
       "   'coordinates': {'latitude': 43.0733745331002,\n",
       "    'longitude': -89.3962322364211},\n",
       "   'transactions': ['delivery'],\n",
       "   'location': {'address1': '604 University Ave',\n",
       "    'address2': '',\n",
       "    'address3': None,\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53715',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['604 University Ave', 'Madison, WI 53715']},\n",
       "   'phone': '',\n",
       "   'display_phone': '',\n",
       "   'distance': 407.5381096824269},\n",
       "  {'id': 'ssQRpUNhldhNNnRpl4M3xQ',\n",
       "   'alias': 'forage-kitchen-madison-3',\n",
       "   'name': 'Forage Kitchen',\n",
       "   'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/uWsVG0ogaCd1rTdarHQ_6w/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/forage-kitchen-madison-3?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 27,\n",
       "   'categories': [{'alias': 'salad', 'title': 'Salad'},\n",
       "    {'alias': 'juicebars', 'title': 'Juice Bars & Smoothies'}],\n",
       "   'rating': 4.0,\n",
       "   'coordinates': {'latitude': 43.0732605114288,\n",
       "    'longitude': -89.4537905018133},\n",
       "   'transactions': ['delivery'],\n",
       "   'location': {'address1': '715 Hilldale Way',\n",
       "    'address2': '',\n",
       "    'address3': None,\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53705',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['715 Hilldale Way', 'Madison, WI 53705']},\n",
       "   'phone': '+16088196223',\n",
       "   'display_phone': '(608) 819-6223',\n",
       "   'distance': 4236.3902830801635},\n",
       "  {'id': 'V80NaT5ZnfuA31yW3Y5Pdg',\n",
       "   'alias': 'el-grito-taqueria-madison',\n",
       "   'name': 'El Grito Taqueria',\n",
       "   'image_url': 'https://s3-media3.fl.yelpcdn.com/bphoto/tfWyUbZe9NK3NRYnUDeFwA/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/el-grito-taqueria-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 30,\n",
       "   'categories': [{'alias': 'foodtrucks', 'title': 'Food Trucks'},\n",
       "    {'alias': 'mexican', 'title': 'Mexican'}],\n",
       "   'rating': 5.0,\n",
       "   'coordinates': {'latitude': 43.0747316, 'longitude': -89.3862126},\n",
       "   'transactions': [],\n",
       "   'price': '$',\n",
       "   'location': {'address1': '50 State St',\n",
       "    'address2': None,\n",
       "    'address3': '',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53703',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['50 State St', 'Madison, WI 53703']},\n",
       "   'phone': '',\n",
       "   'display_phone': '',\n",
       "   'distance': 1234.0179960609667},\n",
       "  {'id': '11VaL6Wydw031ro4EeVyAw',\n",
       "   'alias': 'red-lion-singapore-grill-and-japanese-cuisine-madison',\n",
       "   'name': 'Red Lion Singapore Grill and Japanese Cuisine',\n",
       "   'image_url': 'https://s3-media4.fl.yelpcdn.com/bphoto/5JUP-3SWXo3CzjuRwSsEdA/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/red-lion-singapore-grill-and-japanese-cuisine-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 46,\n",
       "   'categories': [{'alias': 'singaporean', 'title': 'Singaporean'},\n",
       "    {'alias': 'japanese', 'title': 'Japanese'}],\n",
       "   'rating': 4.5,\n",
       "   'coordinates': {'latitude': 43.08356, 'longitude': -89.31766},\n",
       "   'transactions': ['delivery', 'pickup'],\n",
       "   'price': '$$',\n",
       "   'location': {'address1': '515 Cottage Grove Rd',\n",
       "    'address2': '',\n",
       "    'address3': None,\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53716',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['515 Cottage Grove Rd', 'Madison, WI 53716']},\n",
       "   'phone': '+16084673018',\n",
       "   'display_phone': '(608) 467-3018',\n",
       "   'distance': 6883.072997973655},\n",
       "  {'id': 'TdBC5PlJleNyfABjsPt00w',\n",
       "   'alias': 'common-pasta-madison',\n",
       "   'name': 'Common Pasta',\n",
       "   'image_url': 'https://s3-media3.fl.yelpcdn.com/bphoto/d3z8Gl_xZclcF3Pu9zCS5g/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/common-pasta-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 17,\n",
       "   'categories': [{'alias': 'italian', 'title': 'Italian'},\n",
       "    {'alias': 'foodtrucks', 'title': 'Food Trucks'}],\n",
       "   'rating': 5.0,\n",
       "   'coordinates': {'latitude': 43.0738, 'longitude': -89.3824},\n",
       "   'transactions': [],\n",
       "   'price': '$',\n",
       "   'location': {'address1': '1 E Main St',\n",
       "    'address2': '',\n",
       "    'address3': None,\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53703',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['1 E Main St', 'Madison, WI 53703']},\n",
       "   'phone': '',\n",
       "   'display_phone': '',\n",
       "   'distance': 1534.6868241705542},\n",
       "  {'id': 'DUUY9UpEbA69xhketnsdLw',\n",
       "   'alias': 'macha-tea-company-madison-2',\n",
       "   'name': 'Macha Tea Company',\n",
       "   'image_url': 'https://s3-media1.fl.yelpcdn.com/bphoto/FYEPDn2Zpp4RcEcpfWR1lg/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/macha-tea-company-madison-2?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 45,\n",
       "   'categories': [{'alias': 'tea', 'title': 'Tea Rooms'},\n",
       "    {'alias': 'bakeries', 'title': 'Bakeries'},\n",
       "    {'alias': 'breakfast_brunch', 'title': 'Breakfast & Brunch'}],\n",
       "   'rating': 5.0,\n",
       "   'coordinates': {'latitude': 43.083748100416,\n",
       "    'longitude': -89.3771679326892},\n",
       "   'transactions': ['delivery'],\n",
       "   'price': '$',\n",
       "   'location': {'address1': '823 E Johnson St',\n",
       "    'address2': 'Ste 5',\n",
       "    'address3': '',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53703',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['823 E Johnson St', 'Ste 5', 'Madison, WI 53703']},\n",
       "   'phone': '+16082839286',\n",
       "   'display_phone': '(608) 283-9286',\n",
       "   'distance': 2287.81252223906},\n",
       "  {'id': 'M-caugKzJ9qLOmCBfD9Nyg',\n",
       "   'alias': 'la-brioche-true-food-madison',\n",
       "   'name': 'La Brioche True Food',\n",
       "   'image_url': 'https://s3-media3.fl.yelpcdn.com/bphoto/rAsTbSW0dH5U-Q_xpJS1jA/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/la-brioche-true-food-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 209,\n",
       "   'categories': [{'alias': 'breakfast_brunch', 'title': 'Breakfast & Brunch'},\n",
       "    {'alias': 'newamerican', 'title': 'American (New)'},\n",
       "    {'alias': 'pizza', 'title': 'Pizza'}],\n",
       "   'rating': 3.5,\n",
       "   'coordinates': {'latitude': 43.075353530641, 'longitude': -89.438346052091},\n",
       "   'transactions': ['delivery', 'pickup'],\n",
       "   'price': '$$',\n",
       "   'location': {'address1': '2862 University Ave',\n",
       "    'address2': '',\n",
       "    'address3': '',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53705',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['2862 University Ave', 'Madison, WI 53705']},\n",
       "   'phone': '+16082333388',\n",
       "   'display_phone': '(608) 233-3388',\n",
       "   'distance': 3025.5832040572586},\n",
       "  {'id': 'AIEyiX9-yfXQgvLOtBgFgA',\n",
       "   'alias': 'pacos-tacos-madison',\n",
       "   'name': \"Paco's Tacos\",\n",
       "   'image_url': 'https://s3-media4.fl.yelpcdn.com/bphoto/mM6Y10imVlc-uBoJ38jRBw/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/pacos-tacos-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 38,\n",
       "   'categories': [{'alias': 'mexican', 'title': 'Mexican'}],\n",
       "   'rating': 4.5,\n",
       "   'coordinates': {'latitude': 43.030984, 'longitude': -89.4055451},\n",
       "   'transactions': ['pickup', 'delivery'],\n",
       "   'price': '$$',\n",
       "   'location': {'address1': '1331 Greenway Cross',\n",
       "    'address2': '',\n",
       "    'address3': '',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53713',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['1331 Greenway Cross', 'Madison, WI 53713']},\n",
       "   'phone': '+16084928552',\n",
       "   'display_phone': '(608) 492-8552',\n",
       "   'distance': 4690.753934607845},\n",
       "  {'id': 'iyFZ9sfWWeMDNhtmdl9MvQ',\n",
       "   'alias': 'el-wiscorican-madison',\n",
       "   'name': 'El Wiscorican',\n",
       "   'image_url': 'https://s3-media1.fl.yelpcdn.com/bphoto/GIX2UbDpOuh3s6cAt1tLGA/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/el-wiscorican-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 11,\n",
       "   'categories': [{'alias': 'foodtrucks', 'title': 'Food Trucks'},\n",
       "    {'alias': 'puertorican', 'title': 'Puerto Rican'}],\n",
       "   'rating': 5.0,\n",
       "   'coordinates': {'latitude': 43.0824892059271,\n",
       "    'longitude': -89.370613284409},\n",
       "   'transactions': [],\n",
       "   'location': {'address1': '999 E Main St',\n",
       "    'address2': '',\n",
       "    'address3': None,\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53703',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['999 E Main St', 'Madison, WI 53703']},\n",
       "   'phone': '',\n",
       "   'display_phone': '',\n",
       "   'distance': 2699.0720797396702},\n",
       "  {'id': 'QvpH6e7_1Tdlflk_yOj4NQ',\n",
       "   'alias': 'adamah-neighborhood-table-madison',\n",
       "   'name': 'Adamah Neighborhood Table',\n",
       "   'image_url': 'https://s3-media1.fl.yelpcdn.com/bphoto/JFh_j09vFAbNPAYVRMn7vA/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/adamah-neighborhood-table-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 15,\n",
       "   'categories': [{'alias': 'newamerican', 'title': 'American (New)'},\n",
       "    {'alias': 'kosher', 'title': 'Kosher'},\n",
       "    {'alias': 'mediterranean', 'title': 'Mediterranean'}],\n",
       "   'rating': 3.5,\n",
       "   'coordinates': {'latitude': 43.07552, 'longitude': -89.39603},\n",
       "   'transactions': ['delivery', 'pickup'],\n",
       "   'price': '$',\n",
       "   'location': {'address1': '611 Langdon St',\n",
       "    'address2': '',\n",
       "    'address3': '',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53703',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['611 Langdon St', 'Madison, WI 53703']},\n",
       "   'phone': '+16084411574',\n",
       "   'display_phone': '(608) 441-1574',\n",
       "   'distance': 507.6117293110188},\n",
       "  {'id': 'y6R_bSCYiotoUjvygVcFaQ',\n",
       "   'alias': 'sugar-river-pizza-verona',\n",
       "   'name': 'Sugar River Pizza',\n",
       "   'image_url': 'https://s3-media3.fl.yelpcdn.com/bphoto/bm2gRSsvWUlvIVEfH4AItw/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/sugar-river-pizza-verona?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 189,\n",
       "   'categories': [{'alias': 'pizza', 'title': 'Pizza'},\n",
       "    {'alias': 'sandwiches', 'title': 'Sandwiches'}],\n",
       "   'rating': 4.5,\n",
       "   'coordinates': {'latitude': 42.9726372451541,\n",
       "    'longitude': -89.5066787302494},\n",
       "   'transactions': ['delivery'],\n",
       "   'price': '$$',\n",
       "   'location': {'address1': '957 Liberty Dr',\n",
       "    'address2': '',\n",
       "    'address3': '',\n",
       "    'city': 'Verona',\n",
       "    'zip_code': '53593',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['957 Liberty Dr', 'Verona, WI 53593']},\n",
       "   'phone': '+16084971800',\n",
       "   'display_phone': '(608) 497-1800',\n",
       "   'distance': 14076.59316733302},\n",
       "  {'id': 'Iq1P8S3--gqd50xoQJxpqA',\n",
       "   'alias': 'blended-madison-2',\n",
       "   'name': 'Blended',\n",
       "   'image_url': 'https://s3-media3.fl.yelpcdn.com/bphoto/uSICvhKrWaZtwVBYv0Sj5A/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/blended-madison-2?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 80,\n",
       "   'categories': [{'alias': 'juicebars', 'title': 'Juice Bars & Smoothies'},\n",
       "    {'alias': 'vegan', 'title': 'Vegan'},\n",
       "    {'alias': 'gluten_free', 'title': 'Gluten-Free'}],\n",
       "   'rating': 4.5,\n",
       "   'coordinates': {'latitude': 43.0729301199309,\n",
       "    'longitude': -89.4532138686669},\n",
       "   'transactions': ['pickup', 'delivery'],\n",
       "   'price': '$$',\n",
       "   'location': {'address1': '717 Hilldale Way',\n",
       "    'address2': '',\n",
       "    'address3': '',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53705',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['717 Hilldale Way', 'Madison, WI 53705']},\n",
       "   'phone': '+16082322233',\n",
       "   'display_phone': '(608) 232-2233',\n",
       "   'distance': 4222.466021735487},\n",
       "  {'id': 'x0LohgBoD53hIa3BMM00PQ',\n",
       "   'alias': 'the-free-house-pub-middleton',\n",
       "   'name': 'The Free House Pub',\n",
       "   'image_url': 'https://s3-media3.fl.yelpcdn.com/bphoto/PTmb_uE-uFlcp-kgjEitYw/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/the-free-house-pub-middleton?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 205,\n",
       "   'categories': [{'alias': 'pubs', 'title': 'Pubs'},\n",
       "    {'alias': 'tradamerican', 'title': 'American (Traditional)'}],\n",
       "   'rating': 4.0,\n",
       "   'coordinates': {'latitude': 43.096159, 'longitude': -89.511939},\n",
       "   'transactions': ['delivery', 'pickup'],\n",
       "   'price': '$$',\n",
       "   'location': {'address1': '1902 Parmenter St',\n",
       "    'address2': '',\n",
       "    'address3': '',\n",
       "    'city': 'Middleton',\n",
       "    'zip_code': '53562',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['1902 Parmenter St', 'Middleton, WI 53562']},\n",
       "   'phone': '+16088315000',\n",
       "   'display_phone': '(608) 831-5000',\n",
       "   'distance': 9350.714829157034},\n",
       "  {'id': 'HHCn1akqIpl_BhdcJoYPbw',\n",
       "   'alias': 'saigon-noodles-madison',\n",
       "   'name': 'Saigon Noodles',\n",
       "   'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/f6wA9zLbsJ5lCsSZcVHe3A/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/saigon-noodles-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 385,\n",
       "   'categories': [{'alias': 'vietnamese', 'title': 'Vietnamese'},\n",
       "    {'alias': 'noodles', 'title': 'Noodles'}],\n",
       "   'rating': 4.0,\n",
       "   'coordinates': {'latitude': 43.0571, 'longitude': -89.49924},\n",
       "   'transactions': ['delivery', 'pickup'],\n",
       "   'price': '$',\n",
       "   'location': {'address1': '6754 Odana Rd',\n",
       "    'address2': '',\n",
       "    'address3': '',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53719',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['6754 Odana Rd', 'Madison, WI 53719']},\n",
       "   'phone': '+16088279120',\n",
       "   'display_phone': '(608) 827-9120',\n",
       "   'distance': 8180.035943746956},\n",
       "  {'id': 'Lrn9Yk5dmLrYJMVvQT_CHw',\n",
       "   'alias': 'strada-madison',\n",
       "   'name': 'Strada',\n",
       "   'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/_ewRuVrYPhGvM24vwDsDvw/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/strada-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 16,\n",
       "   'categories': [{'alias': 'pizza', 'title': 'Pizza'},\n",
       "    {'alias': 'sandwiches', 'title': 'Sandwiches'}],\n",
       "   'rating': 3.5,\n",
       "   'coordinates': {'latitude': 43.07645, 'longitude': -89.399024},\n",
       "   'transactions': [],\n",
       "   'price': '$',\n",
       "   'location': {'address1': '800 Langdon St',\n",
       "    'address2': None,\n",
       "    'address3': '',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53703',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['800 Langdon St', 'Madison, WI 53703']},\n",
       "   'phone': '',\n",
       "   'display_phone': '',\n",
       "   'distance': 370.4417428822068},\n",
       "  {'id': '-y8Nz-elBXkUYoIoc9AADg',\n",
       "   'alias': 'naf-naf-grill-madison',\n",
       "   'name': 'Naf Naf Grill',\n",
       "   'image_url': 'https://s3-media1.fl.yelpcdn.com/bphoto/TNqIDHqzonZ6D9-UVZh8Jw/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/naf-naf-grill-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 79,\n",
       "   'categories': [{'alias': 'mideastern', 'title': 'Middle Eastern'},\n",
       "    {'alias': 'salad', 'title': 'Salad'},\n",
       "    {'alias': 'falafel', 'title': 'Falafel'}],\n",
       "   'rating': 4.0,\n",
       "   'coordinates': {'latitude': 43.0748219157851,\n",
       "    'longitude': -89.3949237666777},\n",
       "   'transactions': ['delivery', 'pickup'],\n",
       "   'price': '$',\n",
       "   'location': {'address1': '555 State St',\n",
       "    'address2': '',\n",
       "    'address3': '',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53703',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['555 State St', 'Madison, WI 53703']},\n",
       "   'phone': '+16082861242',\n",
       "   'display_phone': '(608) 286-1242',\n",
       "   'distance': 548.7696367899014},\n",
       "  {'id': 'S8jQztEAObUAbW6aeRFqjQ',\n",
       "   'alias': 'beef-butter-bbq-madison-2',\n",
       "   'name': 'Beef Butter BBQ',\n",
       "   'image_url': 'https://s3-media3.fl.yelpcdn.com/bphoto/wjCQzB__Sw0mIJVG8JRbCg/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/beef-butter-bbq-madison-2?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 136,\n",
       "   'categories': [{'alias': 'bbq', 'title': 'Barbeque'},\n",
       "    {'alias': 'catering', 'title': 'Caterers'}],\n",
       "   'rating': 4.0,\n",
       "   'coordinates': {'latitude': 43.129696, 'longitude': -89.362733},\n",
       "   'transactions': ['delivery', 'pickup'],\n",
       "   'price': '$$',\n",
       "   'location': {'address1': '3001 N Sherman Ave',\n",
       "    'address2': None,\n",
       "    'address3': None,\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53704',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['3001 N Sherman Ave', 'Madison, WI 53704']},\n",
       "   'phone': '+16086405000',\n",
       "   'display_phone': '(608) 640-5000',\n",
       "   'distance': 7031.468624010446},\n",
       "  {'id': 'UDyScSvpzBEgOGs6HAXcRg',\n",
       "   'alias': 'davids-jamaican-cuisine-monona',\n",
       "   'name': \"David's Jamaican Cuisine\",\n",
       "   'image_url': 'https://s3-media4.fl.yelpcdn.com/bphoto/qrwVZ0GPYL9CWAfSSFnmkA/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/davids-jamaican-cuisine-monona?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 90,\n",
       "   'categories': [{'alias': 'caribbean', 'title': 'Caribbean'}],\n",
       "   'rating': 4.0,\n",
       "   'coordinates': {'latitude': 43.05859, 'longitude': -89.32527},\n",
       "   'transactions': ['delivery'],\n",
       "   'price': '$',\n",
       "   'location': {'address1': '5696 Monona Dr',\n",
       "    'address2': '',\n",
       "    'address3': '',\n",
       "    'city': 'Monona',\n",
       "    'zip_code': '53716',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['5696 Monona Dr', 'Monona, WI 53716']},\n",
       "   'phone': '+16082228109',\n",
       "   'display_phone': '(608) 222-8109',\n",
       "   'distance': 6377.041403391948},\n",
       "  {'id': 'COnqdubhr87gCDJjPGwT6A',\n",
       "   'alias': 'freska-mediterranean-grill-middleton',\n",
       "   'name': 'Freska Mediterranean Grill',\n",
       "   'image_url': 'https://s3-media3.fl.yelpcdn.com/bphoto/ynAn_B9pMOc5kdfapXtn3A/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/freska-mediterranean-grill-middleton?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 116,\n",
       "   'categories': [{'alias': 'mediterranean', 'title': 'Mediterranean'}],\n",
       "   'rating': 4.0,\n",
       "   'coordinates': {'latitude': 43.090502687125,\n",
       "    'longitude': -89.5256438110285},\n",
       "   'transactions': ['delivery', 'pickup'],\n",
       "   'price': '$',\n",
       "   'location': {'address1': '8310 Greenway Blvd',\n",
       "    'address2': 'Ste 104',\n",
       "    'address3': '',\n",
       "    'city': 'Middleton',\n",
       "    'zip_code': '53562',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['8310 Greenway Blvd',\n",
       "     'Ste 104',\n",
       "     'Middleton, WI 53562']},\n",
       "   'phone': '+16082035034',\n",
       "   'display_phone': '(608) 203-5034',\n",
       "   'distance': 10288.848660007556},\n",
       "  {'id': 'uNpqQEz9tE5TertGlQCBsA',\n",
       "   'alias': 'cafe-costa-rica-madison-4',\n",
       "   'name': 'Cafe Costa Rica',\n",
       "   'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/fnZv1xt7z7aIhphS5InoFg/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/cafe-costa-rica-madison-4?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 4,\n",
       "   'categories': [{'alias': 'foodtrucks', 'title': 'Food Trucks'},\n",
       "    {'alias': 'latin', 'title': 'Latin American'},\n",
       "    {'alias': 'caribbean', 'title': 'Caribbean'}],\n",
       "   'rating': 5.0,\n",
       "   'coordinates': {'latitude': 43.0748397822723,\n",
       "    'longitude': -89.3976026773453},\n",
       "   'transactions': [],\n",
       "   'price': '$',\n",
       "   'location': {'address1': '731 State St',\n",
       "    'address2': '',\n",
       "    'address3': '',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53703',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['731 State St', 'Madison, WI 53703']},\n",
       "   'phone': '+16083528466',\n",
       "   'display_phone': '(608) 352-8466',\n",
       "   'distance': 355.4834582176618},\n",
       "  {'id': 'aUrOyWFKxKeVXiFzwbTXSA',\n",
       "   'alias': 'the-green-owl-cafe-madison-2',\n",
       "   'name': 'The Green Owl Cafe',\n",
       "   'image_url': 'https://s3-media3.fl.yelpcdn.com/bphoto/NZy8-PgJIBp43qGhZKVq_A/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/the-green-owl-cafe-madison-2?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 328,\n",
       "   'categories': [{'alias': 'vegetarian', 'title': 'Vegetarian'},\n",
       "    {'alias': 'vegan', 'title': 'Vegan'},\n",
       "    {'alias': 'cafes', 'title': 'Cafes'}],\n",
       "   'rating': 4.0,\n",
       "   'coordinates': {'latitude': 43.09231, 'longitude': -89.35556},\n",
       "   'transactions': ['delivery'],\n",
       "   'price': '$$',\n",
       "   'location': {'address1': '1970 Atwood Ave',\n",
       "    'address2': '',\n",
       "    'address3': '',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53704',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['1970 Atwood Ave', 'Madison, WI 53704']},\n",
       "   'phone': '+16082855290',\n",
       "   'display_phone': '(608) 285-5290',\n",
       "   'distance': 4279.3225988342965},\n",
       "  {'id': 'kq5eyQIzH4S36TqA2eKiWA',\n",
       "   'alias': 'bierock-madison',\n",
       "   'name': 'Bierock',\n",
       "   'image_url': 'https://s3-media4.fl.yelpcdn.com/bphoto/Zv7sosUylKM1RgRKUkefFQ/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/bierock-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 34,\n",
       "   'categories': [{'alias': 'tradamerican', 'title': 'American (Traditional)'},\n",
       "    {'alias': 'beerbar', 'title': 'Beer Bar'},\n",
       "    {'alias': 'comfortfood', 'title': 'Comfort Food'}],\n",
       "   'rating': 4.5,\n",
       "   'coordinates': {'latitude': 43.128579, 'longitude': -89.36098},\n",
       "   'transactions': ['delivery'],\n",
       "   'location': {'address1': '2911 N Sherman Ave',\n",
       "    'address2': None,\n",
       "    'address3': '',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53704',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['2911 N Sherman Ave', 'Madison, WI 53704']},\n",
       "   'phone': '+16085158087',\n",
       "   'display_phone': '(608) 515-8087',\n",
       "   'distance': 6985.8755392865},\n",
       "  {'id': 'XFuNeVTGWZ-UOYO58NNmKg',\n",
       "   'alias': 'the-statehouse-madison-2',\n",
       "   'name': 'The Statehouse',\n",
       "   'image_url': 'https://s3-media2.fl.yelpcdn.com/bphoto/OofpnvblfPgGjEIX4mG7IA/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/the-statehouse-madison-2?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 121,\n",
       "   'categories': [{'alias': 'newamerican', 'title': 'American (New)'},\n",
       "    {'alias': 'breakfast_brunch', 'title': 'Breakfast & Brunch'}],\n",
       "   'rating': 3.0,\n",
       "   'coordinates': {'latitude': 43.079215, 'longitude': -89.389695},\n",
       "   'transactions': ['delivery'],\n",
       "   'price': '$$$',\n",
       "   'location': {'address1': '1001 Wisconsin Pl',\n",
       "    'address2': '',\n",
       "    'address3': '',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53703',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['1001 Wisconsin Pl', 'Madison, WI 53703']},\n",
       "   'phone': '+16085358230',\n",
       "   'display_phone': '(608) 535-8230',\n",
       "   'distance': 1157.8826604045425},\n",
       "  {'id': '91Y6ASRhkDz3mJG9ezGNiQ',\n",
       "   'alias': 'babcock-hall-dairy-store-madison',\n",
       "   'name': 'Babcock Hall Dairy Store',\n",
       "   'image_url': 'https://s3-media3.fl.yelpcdn.com/bphoto/K66JihetTUeveuVXMkzT7A/o.jpg',\n",
       "   'is_closed': False,\n",
       "   'url': 'https://www.yelp.com/biz/babcock-hall-dairy-store-madison?adjust_creative=0-n8vj8zh5AmPa9bs91oww&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_search&utm_source=0-n8vj8zh5AmPa9bs91oww',\n",
       "   'review_count': 84,\n",
       "   'categories': [{'alias': 'icecream', 'title': 'Ice Cream & Frozen Yogurt'},\n",
       "    {'alias': 'cheese', 'title': 'Cheese Shops'},\n",
       "    {'alias': 'sandwiches', 'title': 'Sandwiches'}],\n",
       "   'rating': 4.5,\n",
       "   'coordinates': {'latitude': 43.0749778, 'longitude': -89.4137655},\n",
       "   'transactions': ['delivery', 'pickup'],\n",
       "   'price': '$',\n",
       "   'location': {'address1': '1605 Linden Dr',\n",
       "    'address2': '',\n",
       "    'address3': '',\n",
       "    'city': 'Madison',\n",
       "    'zip_code': '53706',\n",
       "    'country': 'US',\n",
       "    'state': 'WI',\n",
       "    'display_address': ['1605 Linden Dr', 'Madison, WI 53706']},\n",
       "   'phone': '+16082623045',\n",
       "   'display_phone': '(608) 262-3045',\n",
       "   'distance': 1040.4895686682185}],\n",
       " 'total': 937,\n",
       " 'region': {'center': {'longitude': -89.40123, 'latitude': 43.073051}}}"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# define the endpoint\n",
    "endpoint = 'https://api.yelp.com/v3/businesses/search'\n",
    "api_key = 'ZsHZFGtKEZeOOXhTne98eErmfd6BfNTm9GqO2S6inSnWzDwtgC2sEauXcB-8zUna_lXZEal4jsW_St6O0OQOcuNvifrr6uqNYmjFXW-FyVKvaMyczbihWELI80tjYHYx' # as a str \n",
    "headers = {'Authorization': 'bearer %s' % api_key}\n",
    "parameters = {\n",
    "    'term':\"restaurants\",\n",
    "    'limit':50,\n",
    "    'radius':40000,\n",
    "    'offset':150,\n",
    "    'latitude':43.073051,\n",
    "    'longitude': -89.401230\n",
    "}\n",
    "\n",
    "response = requests.get(url=endpoint, params=parameters, headers=headers)\n",
    "result = response.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "casual-accommodation",
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_results(keyword, lat=None, lon=None, location=None, radius=40000):\n",
    "    assert lat != None and lon != None or location != None\n",
    "    if location != None:\n",
    "        parameters = {\n",
    "        'term': keyword,\n",
    "        'limit':50,\n",
    "        'radius':radius,\n",
    "        'location':'Madison, Wisconsin'}\n",
    "    else:\n",
    "        parameters = {\n",
    "        'term': keyword,\n",
    "        'limit':50,\n",
    "        'radius':radius,\n",
    "        'latitude':lat,\n",
    "        'longitude':lon}\n",
    "    all_results = []\n",
    "    response = requests.get(url=endpoint, params=parameters, headers=headers)\n",
    "    result = response.json()\n",
    "    all_results += result['businesses']\n",
    "    \n",
    "    found = result['total']\n",
    "    searches = found // 50 \n",
    "    \n",
    "    if searches != 0:\n",
    "        for i in range(searches):\n",
    "            offset = (i+1) * 50\n",
    "            parameters['offset'] = offset\n",
    "            response = requests.get(url=endpoint, params=parameters, headers=headers)\n",
    "            result = response.json()\n",
    "            all_results += result['businesses']\n",
    "    return all_results\n",
    "\n",
    "\n",
    "def get_info(data, key='name'):\n",
    "    final = []\n",
    "    for item in data:\n",
    "        obj = item[key]\n",
    "        final.append(obj)\n",
    "    return final\n",
    "\n",
    "\n",
    "def get_dataframe(data):\n",
    "    df = pd.DataFrame()\n",
    "    for col in keys:\n",
    "        df[col] = get_info(data, key=col)\n",
    "    return df\n",
    "    \n",
    "\n",
    "keys = ['id', 'alias', 'name', 'image_url', 'is_closed', \n",
    "        'url', 'review_count', 'categories', 'rating', 'coordinates', \n",
    "        'transactions', 'location', 'phone', 'display_phone', 'distance']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "opened-journal",
   "metadata": {},
   "outputs": [],
   "source": [
    "restaurants = get_results('restaurants', lat=43.073051, lon=-89.401230)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "ordered-superior",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Graze',\n",
       " 'Pig in a Fur Coat',\n",
       " 'Heritage Tavern',\n",
       " 'Everyday Kitchen - Madison',\n",
       " 'The Old Fashioned',\n",
       " 'Settle Down Tavern',\n",
       " \"Dotty Dumpling's Dowry\",\n",
       " 'Sweet Home Wisconsin',\n",
       " 'Merchant',\n",
       " 'Mediterranean Cafe',\n",
       " 'Nook',\n",
       " 'The Weary Traveler Freehouse',\n",
       " \"Paul's Pel'meni\",\n",
       " 'Mr.Kimchi Modern Korean',\n",
       " 'La Kitchenette']"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# can input id, alias, coordinates, location (address basically), review count etc\n",
    "get_info(restaurants, 'name')[:15]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "posted-serum",
   "metadata": {},
   "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>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>XmsBtCykUtObXg4Q1mYpvg</td>\n",
       "      <td>graze-madison</td>\n",
       "      <td>Graze</td>\n",
       "      <td>https://s3-media3.fl.yelpcdn.com/bphoto/2zSpLS...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/graze-madison?adjust_...</td>\n",
       "      <td>1174</td>\n",
       "      <td>[{'alias': 'newamerican', 'title': 'American (...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>{'latitude': 43.0750940450292, 'longitude': -8...</td>\n",
       "      <td>[delivery]</td>\n",
       "      <td>{'address1': '1 S Pinckney St', 'address2': ''...</td>\n",
       "      <td>+16082512700</td>\n",
       "      <td>(608) 251-2700</td>\n",
       "      <td>1571.032819</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>OoI3WUe4Xl86d53avy3oVA</td>\n",
       "      <td>pig-in-a-fur-coat-madison</td>\n",
       "      <td>Pig in a Fur Coat</td>\n",
       "      <td>https://s3-media1.fl.yelpcdn.com/bphoto/3-xM2o...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/pig-in-a-fur-coat-mad...</td>\n",
       "      <td>441</td>\n",
       "      <td>[{'alias': 'newamerican', 'title': 'American (...</td>\n",
       "      <td>4.5</td>\n",
       "      <td>{'latitude': 43.08056, 'longitude': -89.36869}</td>\n",
       "      <td>[delivery]</td>\n",
       "      <td>{'address1': '940 Williamson St', 'address2': ...</td>\n",
       "      <td>+16083163300</td>\n",
       "      <td>(608) 316-3300</td>\n",
       "      <td>2778.536281</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>sXYkjcuGhtaYP8yeQPaHgA</td>\n",
       "      <td>heritage-tavern-madison</td>\n",
       "      <td>Heritage Tavern</td>\n",
       "      <td>https://s3-media2.fl.yelpcdn.com/bphoto/Rn3rWz...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/heritage-tavern-madis...</td>\n",
       "      <td>505</td>\n",
       "      <td>[{'alias': 'newamerican', 'title': 'American (...</td>\n",
       "      <td>4.5</td>\n",
       "      <td>{'latitude': 43.076779, 'longitude': -89.383321}</td>\n",
       "      <td>[restaurant_reservation, delivery, pickup]</td>\n",
       "      <td>{'address1': '131 E Mifflin St', 'address2': '...</td>\n",
       "      <td>+16082839500</td>\n",
       "      <td>(608) 283-9500</td>\n",
       "      <td>1520.081956</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>gXSmo3owUfQXIFduFy7kBQ</td>\n",
       "      <td>everyday-kitchen-madison-madison</td>\n",
       "      <td>Everyday Kitchen - Madison</td>\n",
       "      <td>https://s3-media2.fl.yelpcdn.com/bphoto/U7VjHC...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/everyday-kitchen-madi...</td>\n",
       "      <td>49</td>\n",
       "      <td>[{'alias': 'cocktailbars', 'title': 'Cocktail ...</td>\n",
       "      <td>4.5</td>\n",
       "      <td>{'latitude': 43.07502, 'longitude': -89.43708}</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>{'address1': '2801 Marshall Ct', 'address2': N...</td>\n",
       "      <td>+16084705500</td>\n",
       "      <td>(608) 470-5500</td>\n",
       "      <td>2914.811812</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>RJNAeNA-209sctUO0dmwuA</td>\n",
       "      <td>the-old-fashioned-madison</td>\n",
       "      <td>The Old Fashioned</td>\n",
       "      <td>https://s3-media2.fl.yelpcdn.com/bphoto/welglu...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/the-old-fashioned-mad...</td>\n",
       "      <td>1916</td>\n",
       "      <td>[{'alias': 'tradamerican', 'title': 'American ...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>{'latitude': 43.0761862475496, 'longitude': -8...</td>\n",
       "      <td>[delivery, pickup]</td>\n",
       "      <td>{'address1': '23 N Pinckney St', 'address2': '...</td>\n",
       "      <td>+16083104545</td>\n",
       "      <td>(608) 310-4545</td>\n",
       "      <td>1461.399409</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>932</th>\n",
       "      <td>MwsLN3Lo2SEbldy0HvBYEw</td>\n",
       "      <td>subway-madison-97</td>\n",
       "      <td>Subway</td>\n",
       "      <td>https://s3-media2.fl.yelpcdn.com/bphoto/e4lXe9...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/subway-madison-97?adj...</td>\n",
       "      <td>3</td>\n",
       "      <td>[{'alias': 'sandwiches', 'title': 'Sandwiches'}]</td>\n",
       "      <td>2.5</td>\n",
       "      <td>{'latitude': 43.1476537619461, 'longitude': -8...</td>\n",
       "      <td>[]</td>\n",
       "      <td>{'address1': '5551 E Park Blvd', 'address2': N...</td>\n",
       "      <td>+16084420113</td>\n",
       "      <td>(608) 442-0113</td>\n",
       "      <td>12362.120519</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>933</th>\n",
       "      <td>khHxKm1_x6syS5W2LTX0lw</td>\n",
       "      <td>quiznos-madison-12</td>\n",
       "      <td>Quiznos</td>\n",
       "      <td></td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/quiznos-madison-12?ad...</td>\n",
       "      <td>3</td>\n",
       "      <td>[{'alias': 'sandwiches', 'title': 'Sandwiches'...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>{'latitude': 43.0697212730165, 'longitude': -8...</td>\n",
       "      <td>[delivery]</td>\n",
       "      <td>{'address1': '116 Gammon Rd', 'address2': '', ...</td>\n",
       "      <td>+16088333434</td>\n",
       "      <td>(608) 833-3434</td>\n",
       "      <td>8233.300716</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>934</th>\n",
       "      <td>k7vX7EO6a88gMxTAz5tiCw</td>\n",
       "      <td>mcdonalds-mcfarland</td>\n",
       "      <td>McDonald's</td>\n",
       "      <td>https://s3-media2.fl.yelpcdn.com/bphoto/d0i4Pu...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/mcdonalds-mcfarland?a...</td>\n",
       "      <td>12</td>\n",
       "      <td>[{'alias': 'hotdogs', 'title': 'Fast Food'}, {...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>{'latitude': 43.017724, 'longitude': -89.299713}</td>\n",
       "      <td>[delivery]</td>\n",
       "      <td>{'address1': '4800 Larson Beach Rd', 'address2...</td>\n",
       "      <td>+16088380139</td>\n",
       "      <td>(608) 838-0139</td>\n",
       "      <td>10290.912769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>935</th>\n",
       "      <td>hc81y_5FQjTiZcgqnY8vfQ</td>\n",
       "      <td>pizza-hut-madison-8</td>\n",
       "      <td>Pizza Hut</td>\n",
       "      <td>https://s3-media2.fl.yelpcdn.com/bphoto/EqIpdg...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/pizza-hut-madison-8?a...</td>\n",
       "      <td>16</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}, {'alias...</td>\n",
       "      <td>1.5</td>\n",
       "      <td>{'latitude': 43.0846214, 'longitude': -89.2997...</td>\n",
       "      <td>[delivery]</td>\n",
       "      <td>{'address1': '4762 Cottage Grove Rd', 'address...</td>\n",
       "      <td>+16082210666</td>\n",
       "      <td>(608) 221-0666</td>\n",
       "      <td>8354.865379</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>936</th>\n",
       "      <td>cxrmfEWXlkgjB7zocBNkqA</td>\n",
       "      <td>pizza-hut-middleton-5</td>\n",
       "      <td>Pizza Hut</td>\n",
       "      <td>https://s3-media4.fl.yelpcdn.com/bphoto/hzBrt6...</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.yelp.com/biz/pizza-hut-middleton-5...</td>\n",
       "      <td>7</td>\n",
       "      <td>[{'alias': 'pizza', 'title': 'Pizza'}, {'alias...</td>\n",
       "      <td>2.5</td>\n",
       "      <td>{'latitude': 43.0967016282602, 'longitude': -8...</td>\n",
       "      <td>[delivery]</td>\n",
       "      <td>{'address1': '6771 University Ave', 'address2'...</td>\n",
       "      <td>+16088363888</td>\n",
       "      <td>(608) 836-3888</td>\n",
       "      <td>8333.828098</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>937 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                         id                             alias  \\\n",
       "0    XmsBtCykUtObXg4Q1mYpvg                     graze-madison   \n",
       "1    OoI3WUe4Xl86d53avy3oVA         pig-in-a-fur-coat-madison   \n",
       "2    sXYkjcuGhtaYP8yeQPaHgA           heritage-tavern-madison   \n",
       "3    gXSmo3owUfQXIFduFy7kBQ  everyday-kitchen-madison-madison   \n",
       "4    RJNAeNA-209sctUO0dmwuA         the-old-fashioned-madison   \n",
       "..                      ...                               ...   \n",
       "932  MwsLN3Lo2SEbldy0HvBYEw                 subway-madison-97   \n",
       "933  khHxKm1_x6syS5W2LTX0lw                quiznos-madison-12   \n",
       "934  k7vX7EO6a88gMxTAz5tiCw               mcdonalds-mcfarland   \n",
       "935  hc81y_5FQjTiZcgqnY8vfQ               pizza-hut-madison-8   \n",
       "936  cxrmfEWXlkgjB7zocBNkqA             pizza-hut-middleton-5   \n",
       "\n",
       "                           name  \\\n",
       "0                         Graze   \n",
       "1             Pig in a Fur Coat   \n",
       "2               Heritage Tavern   \n",
       "3    Everyday Kitchen - Madison   \n",
       "4             The Old Fashioned   \n",
       "..                          ...   \n",
       "932                      Subway   \n",
       "933                     Quiznos   \n",
       "934                  McDonald's   \n",
       "935                   Pizza Hut   \n",
       "936                   Pizza Hut   \n",
       "\n",
       "                                             image_url  is_closed  \\\n",
       "0    https://s3-media3.fl.yelpcdn.com/bphoto/2zSpLS...      False   \n",
       "1    https://s3-media1.fl.yelpcdn.com/bphoto/3-xM2o...      False   \n",
       "2    https://s3-media2.fl.yelpcdn.com/bphoto/Rn3rWz...      False   \n",
       "3    https://s3-media2.fl.yelpcdn.com/bphoto/U7VjHC...      False   \n",
       "4    https://s3-media2.fl.yelpcdn.com/bphoto/welglu...      False   \n",
       "..                                                 ...        ...   \n",
       "932  https://s3-media2.fl.yelpcdn.com/bphoto/e4lXe9...      False   \n",
       "933                                                         False   \n",
       "934  https://s3-media2.fl.yelpcdn.com/bphoto/d0i4Pu...      False   \n",
       "935  https://s3-media2.fl.yelpcdn.com/bphoto/EqIpdg...      False   \n",
       "936  https://s3-media4.fl.yelpcdn.com/bphoto/hzBrt6...      False   \n",
       "\n",
       "                                                   url  review_count  \\\n",
       "0    https://www.yelp.com/biz/graze-madison?adjust_...          1174   \n",
       "1    https://www.yelp.com/biz/pig-in-a-fur-coat-mad...           441   \n",
       "2    https://www.yelp.com/biz/heritage-tavern-madis...           505   \n",
       "3    https://www.yelp.com/biz/everyday-kitchen-madi...            49   \n",
       "4    https://www.yelp.com/biz/the-old-fashioned-mad...          1916   \n",
       "..                                                 ...           ...   \n",
       "932  https://www.yelp.com/biz/subway-madison-97?adj...             3   \n",
       "933  https://www.yelp.com/biz/quiznos-madison-12?ad...             3   \n",
       "934  https://www.yelp.com/biz/mcdonalds-mcfarland?a...            12   \n",
       "935  https://www.yelp.com/biz/pizza-hut-madison-8?a...            16   \n",
       "936  https://www.yelp.com/biz/pizza-hut-middleton-5...             7   \n",
       "\n",
       "                                            categories  rating  \\\n",
       "0    [{'alias': 'newamerican', 'title': 'American (...     4.0   \n",
       "1    [{'alias': 'newamerican', 'title': 'American (...     4.5   \n",
       "2    [{'alias': 'newamerican', 'title': 'American (...     4.5   \n",
       "3    [{'alias': 'cocktailbars', 'title': 'Cocktail ...     4.5   \n",
       "4    [{'alias': 'tradamerican', 'title': 'American ...     4.0   \n",
       "..                                                 ...     ...   \n",
       "932   [{'alias': 'sandwiches', 'title': 'Sandwiches'}]     2.5   \n",
       "933  [{'alias': 'sandwiches', 'title': 'Sandwiches'...     3.0   \n",
       "934  [{'alias': 'hotdogs', 'title': 'Fast Food'}, {...     2.0   \n",
       "935  [{'alias': 'pizza', 'title': 'Pizza'}, {'alias...     1.5   \n",
       "936  [{'alias': 'pizza', 'title': 'Pizza'}, {'alias...     2.5   \n",
       "\n",
       "                                           coordinates  \\\n",
       "0    {'latitude': 43.0750940450292, 'longitude': -8...   \n",
       "1       {'latitude': 43.08056, 'longitude': -89.36869}   \n",
       "2     {'latitude': 43.076779, 'longitude': -89.383321}   \n",
       "3       {'latitude': 43.07502, 'longitude': -89.43708}   \n",
       "4    {'latitude': 43.0761862475496, 'longitude': -8...   \n",
       "..                                                 ...   \n",
       "932  {'latitude': 43.1476537619461, 'longitude': -8...   \n",
       "933  {'latitude': 43.0697212730165, 'longitude': -8...   \n",
       "934   {'latitude': 43.017724, 'longitude': -89.299713}   \n",
       "935  {'latitude': 43.0846214, 'longitude': -89.2997...   \n",
       "936  {'latitude': 43.0967016282602, 'longitude': -8...   \n",
       "\n",
       "                                   transactions  \\\n",
       "0                                    [delivery]   \n",
       "1                                    [delivery]   \n",
       "2    [restaurant_reservation, delivery, pickup]   \n",
       "3                            [delivery, pickup]   \n",
       "4                            [delivery, pickup]   \n",
       "..                                          ...   \n",
       "932                                          []   \n",
       "933                                  [delivery]   \n",
       "934                                  [delivery]   \n",
       "935                                  [delivery]   \n",
       "936                                  [delivery]   \n",
       "\n",
       "                                              location         phone  \\\n",
       "0    {'address1': '1 S Pinckney St', 'address2': ''...  +16082512700   \n",
       "1    {'address1': '940 Williamson St', 'address2': ...  +16083163300   \n",
       "2    {'address1': '131 E Mifflin St', 'address2': '...  +16082839500   \n",
       "3    {'address1': '2801 Marshall Ct', 'address2': N...  +16084705500   \n",
       "4    {'address1': '23 N Pinckney St', 'address2': '...  +16083104545   \n",
       "..                                                 ...           ...   \n",
       "932  {'address1': '5551 E Park Blvd', 'address2': N...  +16084420113   \n",
       "933  {'address1': '116 Gammon Rd', 'address2': '', ...  +16088333434   \n",
       "934  {'address1': '4800 Larson Beach Rd', 'address2...  +16088380139   \n",
       "935  {'address1': '4762 Cottage Grove Rd', 'address...  +16082210666   \n",
       "936  {'address1': '6771 University Ave', 'address2'...  +16088363888   \n",
       "\n",
       "      display_phone      distance  \n",
       "0    (608) 251-2700   1571.032819  \n",
       "1    (608) 316-3300   2778.536281  \n",
       "2    (608) 283-9500   1520.081956  \n",
       "3    (608) 470-5500   2914.811812  \n",
       "4    (608) 310-4545   1461.399409  \n",
       "..              ...           ...  \n",
       "932  (608) 442-0113  12362.120519  \n",
       "933  (608) 833-3434   8233.300716  \n",
       "934  (608) 838-0139  10290.912769  \n",
       "935  (608) 221-0666   8354.865379  \n",
       "936  (608) 836-3888   8333.828098  \n",
       "\n",
       "[937 rows x 15 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = get_dataframe(restaurants)\n",
    "df"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}