Introduction¶
Background
Due of the COVID-19 pandemic, Metro Manila, Philippines has been under quarantine since March 2020. Quarantine restrictions made it difficult for most businesses to operate, but these also greatly increased the demand for delivery services because it is unsafe to go out in public places.
Since large delivery fees are unattractive to most customers, some businesses offer free delivery to certain areas, usually exclusive villages, if they have many customers in that area. These businesses often have a Viber chat group for each village, where residents send their orders.
This delivery model works well for businesses that sell essential, perishable goods such as vegetables and meat because these are items that are bought frequently and by the same customers.
Target Market
This report is targeted towards stakeholders who are interested in starting a perishable goods delivery business that caters to residents in exclusive villages in Metro Manila, Philippines.
Business Problem
If deliveries are done 6 days a week, how could one know which villages to deliver to each day to optimize their logistics, and from which wet market supplier to get the perishable goods from?
Data¶
Data Needed
Based on the definition of the problem, here are the factors that will influence the decision:
- The locations of the exclusive villages in Metro Manila
- The names and ratings of wet markets nearest to each delivery group (since the customers are usually picky with the quality of the goods that they buy)
Data Sources
The following data sources will be used to extract or generate the required information:
- Nominatim API geocoding – for finding the longitude and latitude of each exclusive village in Metro Manila
- Foursquare API – for determining the wet markets around the areas of the exclusive villages and their ratings
- List of exclusive residential areas in Metro Manila from one of the top bread shops in the country that delivers to these villages – for identifying the exclusive villages which the target market will be delivering to
- The residents of the villages listed here are the same ones the target market would want to attract.
- This is public information because this list is available on the bread shop’s online order form.
Methodology¶
Gather data and import libraries needed
One of the top bread shops in the country delivers bread weekly to the most exclusive villages in Metro Manila. The residential areas that they deliver to are included in their online order form, since customers will have to select the village where they live.
I took note of these 45 areas and consolidated each village’s longitude and latitude in a CSV file, which I got from using Nominatim API geocoding. I will import this file later on.
Now I will import the libraries needed.
In [1]:
import requests # library to handle requests
import pandas as pd # library for data analsysis
import numpy as np # library to handle data in a vectorized manner
import json #library to parse JSON files into a Python dictionary or list
import matplotlib.cm as cm # library for plotting points in the map
import matplotlib.colors as colors #library for plotting points in the map
from pandas.io.json import json_normalize # library for tranforming json files into a pandas dataframe library
!python3 -m pip install folium
import folium # library for creating maps
from geopy.geocoders import Nominatim # library for geocoding the longitude and latitude of different areas needed
from sklearn.cluster import KMeans # library for creating a k-means clustering model
print('Libraries imported.')
Requirement already satisfied: folium in /opt/conda/envs/Python-3.7-main/lib/python3.7/site-packages (0.12.1) Requirement already satisfied: jinja2>=2.9 in /opt/conda/envs/Python-3.7-main/lib/python3.7/site-packages (from folium) (2.11.2) Requirement already satisfied: requests in /opt/conda/envs/Python-3.7-main/lib/python3.7/site-packages (from folium) (2.24.0) Requirement already satisfied: branca>=0.3.0 in /opt/conda/envs/Python-3.7-main/lib/python3.7/site-packages (from folium) (0.4.2) Requirement already satisfied: numpy in /opt/conda/envs/Python-3.7-main/lib/python3.7/site-packages (from folium) (1.18.5) Requirement already satisfied: MarkupSafe>=0.23 in /opt/conda/envs/Python-3.7-main/lib/python3.7/site-packages (from jinja2>=2.9->folium) (1.1.1) Requirement already satisfied: urllib3!=1.25.0,!=1.25.1,<1.26,>=1.21.1 in /opt/conda/envs/Python-3.7-main/lib/python3.7/site-packages (from requests->folium) (1.25.9) Requirement already satisfied: chardet<4,>=3.0.2 in /opt/conda/envs/Python-3.7-main/lib/python3.7/site-packages (from requests->folium) (3.0.4) Requirement already satisfied: certifi>=2017.4.17 in /opt/conda/envs/Python-3.7-main/lib/python3.7/site-packages (from requests->folium) (2020.12.5) Requirement already satisfied: idna<3,>=2.5 in /opt/conda/envs/Python-3.7-main/lib/python3.7/site-packages (from requests->folium) (2.9) Libraries imported.
After this, I will input my Foursquare credentials because I will be requesting for data from Foursquare API later on. I will also upload the CSV file of village data into this notebook.
In [2]:
# The code was removed by Watson Studio for sharing.
In [3]:
# The code was removed by Watson Studio for sharing.
Out[3]:
| Village | Latitude | Longitude | |
|---|---|---|---|
| 0 | 53 BENITEZ | 14.614629 | 121.046274 |
| 1 | ACROPOLIS | 14.605744 | 121.077077 |
| 2 | ALEXANDRA | 14.580917 | 121.062601 |
| 3 | APARTMENT RIDGE | 14.556622 | 121.026340 |
| 4 | AYALA ALABANG | 14.405740 | 121.023723 |
Visualize village locations
I want to visualize where the villages are in relation to each other on the map of Metro Manila. To do this, I first have to get the latitude and longitude of Metro Manila and then use the Folium library to generate a map. The villages will be plotted onto the map as blue points.
In [4]:
#get latitude and longitude of Metro Manila
address = 'Metro Manila'
geolocator = Nominatim(user_agent="mm_agent")
location = geolocator.geocode(address)
latitude = location.latitude
longitude = location.longitude
print(latitude, longitude)
14.5736108 121.0329706
In [5]:
# generate map of villages in Metro Manila
village_map = folium.Map(location=[latitude, longitude], zoom_start=13)
# add the villages as blue circle markers
for Latitude, Longitude, label in zip(df_villages.Latitude, df_villages.Longitude, df_villages.Village):
folium.CircleMarker(
[Latitude, Longitude],
radius=5,
color='blue',
popup=label,
fill = True,
fill_color='blue',
fill_opacity=0.6
).add_to(village_map)
# display map
village_map
Out[5]:
Make this Notebook Trusted to load map: File -> Trust Notebook
At first glance, I could see that most villages were located in the center of Metro Manila, while there were a few outliers in the north and south. From here, it looks like there are 4 possible village clusters, but since there are 6 working days a week for delivery, I want to split all these villages into 6 clusters.
K-Means clustering of villages
Because the goods being delivered are perishable and could spoil easily, only residents in villages near each other should be delivered to in one day.
The k-means clustering algorithm is used to group the unlabeled data based on their proximity to each other; in this case, the different villages. After the dataset is divided into 6 groups, a new column will be added to the dataframe for the cluster labels.
In [6]:
#get k-means clusters of Metro Manila exclusive villages
#6 clusters because one cluster for each working day of the week
kclusters = 6
kmeans = KMeans(n_clusters=kclusters, random_state=0).fit(df_villages[["Latitude", "Longitude"]])
kmeans.labels_[0:10]
Out[6]:
array([0, 4, 4, 5, 1, 3, 1, 5, 4, 4], dtype=int32)
In [7]:
#add cluster labels to dataframe
df_villages.insert(0, 'Cluster Labels', kmeans.labels_)
In [8]:
df_villages.head()
Out[8]:
| Cluster Labels | Village | Latitude | Longitude | |
|---|---|---|---|---|
| 0 | 0 | 53 BENITEZ | 14.614629 | 121.046274 |
| 1 | 4 | ACROPOLIS | 14.605744 | 121.077077 |
| 2 | 4 | ALEXANDRA | 14.580917 | 121.062601 |
| 3 | 5 | APARTMENT RIDGE | 14.556622 | 121.026340 |
| 4 | 1 | AYALA ALABANG | 14.405740 | 121.023723 |
To visualize the clusters, a new map will be created where each cluster label will be assigned a specific color and plotted on a map using folium.
In [9]:
#map the clusters
cluster_map = folium.Map(location=[latitude, longitude], zoom_start=12)
# set colors for the clusters
x = np.arange(kclusters)
ys = [i + x + (i*x)**2 for i in range(kclusters)]
colors_array = cm.rainbow(np.linspace(0, 1, len(ys)))
rainbow = [colors.rgb2hex(i) for i in colors_array]
centers = kmeans.cluster_centers_
# put markers
cluster_markers = []
for lat, lon, village, cluster in zip(df_villages['Latitude'], df_villages['Longitude'], df_villages['Village'], df_villages['Cluster Labels']):
label = folium.Popup(str(village) + ' Cluster ' + str(cluster), parse_html=True)
folium.CircleMarker(
[lat, lon],
radius=5,
popup=label,
color=rainbow[cluster-1],
fill=True,
fill_color=rainbow[cluster-1],
fill_opacity=0.7).add_to(cluster_map)
cluster_map
Out[9]:
Make this Notebook Trusted to load map: File -> Trust Notebook
Results and Analysis¶
Now that it was clear which villages would be delivered to on the same day, a specific wet market had to be assigned to each village cluster as to minimize the amount of travel time the goods will have to go through during delivery. It is important that the wet markets chosen are as close as possible to the clusters, especially if there are customers who order seafood or other produce that spoils easily.
Farmers Market in Cubao, Quezon City is one of the more high-end wet markets in Metro Manila where residents of these exclusive villages often get their fresh produce. For this reason, I will not search for wet markets around the areas of Clusters 0 and 4 anymore, since Farmers Market is situated in between these clusters. This will be the wet market supplier for villages in these clusters because 1) it already has a good reputation and 2) "suki" culture in the Philippines means that wet market vendors usually give lower prices to customers who consistently buy from their stalls. Because the target market will be buying goods from the same stalls in Farmers Market for the residents of these two clusters, prices would be minimized as well.
I will only be searching then for the best wet markets to supply villages in Clusters 1, 2, 3, and 5.
Finding wet market supplier candidates for Cluster 1¶
Because Cluster 1 only includes 2 villages (Ayala Alabang and Ayala Southvale), I picked one to use as reference for finding wet markets near Cluster 1, and this will be the first village to be delivered to.
In [10]:
#get latitude and longitude of Ayala Alabang Village
address_1 = 'Ayala Alabang, Metro Manila'
geolocator_1 = Nominatim(user_agent="1_agent")
location_1 = geolocator_1.geocode(address_1)
latitude_1 = location_1.latitude
longitude_1 = location_1.longitude
print(latitude_1, longitude_1)
14.4158464 121.024634
In [11]:
#search wet markets near each selected address
search_query = 'wet market'
radius = 2000
print(search_query)
wet market
In [12]:
#define the url to find wet markets near Cluster 1
url_1 = 'https://api.foursquare.com/v2/venues/search?client_id={}&client_secret={}&ll={},{}&oauth_token={}&v={}&query={}&radius={}&limit={}'.format(CLIENT_ID, CLIENT_SECRET, latitude_1, longitude_1,ACCESS_TOKEN, VERSION, search_query, radius, LIMIT)
url_1
Out[12]:
'https://api.foursquare.com/v2/venues/search?client_id=RSC3G0GMLOJSBAD0PM1CDGKHBJIO441GM32W4RMZ4EG2HXFL&client_secret=QR5FE44FD3AKMH3HRHINEHH4FTOWIPROJB42S02G41NLQE3S&ll=14.4158464,121.024634&oauth_token=AGWAV4YZA0YDWA1CIRQPDLXLXO0XUAC0YRBQ5EVYJTBLHA53&v=20180605&query=wet market&radius=2000&limit=100'
In [13]:
#get the results of wet markets near Cluster 1
results_1 = requests.get(url_1).json()
results_1
Out[13]:
{'meta': {'code': 200, 'requestId': '6021f119a69b7c2919e88b6c'},
'notifications': [{'type': 'notificationTray', 'item': {'unreadCount': 0}}],
'response': {'venues': [{'id': '4d9c0f8381f6f04d521682aa',
'name': 'Alabang Public Market',
'location': {'lat': 14.420129025142451,
'lng': 121.04455969423788,
'labeledLatLngs': [{'label': 'display',
'lat': 14.420129025142451,
'lng': 121.04455969423788}],
'distance': 2200,
'cc': 'PH',
'city': 'Muntinlupa',
'state': 'Rizal',
'country': 'Pilipinas',
'formattedAddress': ['Muntinlupa City', 'Rizal']},
'categories': [{'id': '50be8ee891d4fa8dcc7199a7',
'name': 'Market',
'pluralName': 'Markets',
'shortName': 'Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/market_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '4d4a54e24509721e71252db0',
'name': "Gourdo's World Market",
'location': {'address': 'Alabang Town Center',
'crossStreet': 'Alabang-Zapote Rd',
'lat': 14.42457944485915,
'lng': 121.02897734769452,
'labeledLatLngs': [{'label': 'display',
'lat': 14.42457944485915,
'lng': 121.02897734769452}],
'distance': 1079,
'cc': 'PH',
'city': 'Muntinlupa City',
'country': 'Pilipinas',
'formattedAddress': ['Alabang Town Center (Alabang-Zapote Rd)',
'Muntinlupa City']},
'categories': [{'id': '4bf58dd8d48988d127951735',
'name': 'Arts & Crafts Store',
'pluralName': 'Arts & Crafts Stores',
'shortName': 'Arts & Crafts',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/artstore_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '57f5c417498e2f861592344e',
'name': 'Mongolian Quick-Box / Pho Market',
'location': {'address': 'Ground Floor, Festival Mall, Filinvest Corporate City, Alabang',
'lat': 14.417155,
'lng': 121.039056,
'labeledLatLngs': [{'label': 'display',
'lat': 14.417155,
'lng': 121.039056}],
'distance': 1561,
'postalCode': '1780',
'cc': 'PH',
'neighborhood': 'Alabang',
'city': 'Muntinlupa',
'state': 'Rizal',
'country': 'Pilipinas',
'formattedAddress': ['Ground Floor, Festival Mall, Filinvest Corporate City, Alabang',
'1780 Muntinlupa City',
'Rizal']},
'categories': [{'id': '4eb1d5724b900d56c88a45fe',
'name': 'Mongolian Restaurant',
'pluralName': 'Mongolian Restaurants',
'shortName': 'Mongolian',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/mongolian_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '4b9b4631f964a520b2fd35e3',
'name': 'South Supermarket',
'location': {'address': 'Filinvest Ave., Filinvest Corporate City, Alabang',
'lat': 14.421447473331249,
'lng': 121.03623087255698,
'labeledLatLngs': [{'label': 'display',
'lat': 14.421447473331249,
'lng': 121.03623087255698}],
'distance': 1397,
'postalCode': '1771',
'cc': 'PH',
'city': 'Muntinlupa City',
'country': 'Pilipinas',
'formattedAddress': ['Filinvest Ave., Filinvest Corporate City, Alabang',
'1771 Muntinlupa City']},
'categories': [{'id': '52f2ab2ebcbc57f1066b8b46',
'name': 'Supermarket',
'pluralName': 'Supermarkets',
'shortName': 'Supermarket',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/food_grocery_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '5528d131498e4a1cb5aacaf6',
'name': 'Saturday Market on University Avenue',
'location': {'lat': 14.410440426254628,
'lng': 121.02089702752153,
'labeledLatLngs': [{'label': 'display',
'lat': 14.410440426254628,
'lng': 121.02089702752153}],
'distance': 724,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d143941735',
'name': 'Breakfast Spot',
'pluralName': 'Breakfast Spots',
'shortName': 'Breakfast',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/breakfast_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '4d5efa01b19fa14358f7e0c8',
'name': 'Filinvest Corporate City',
'location': {'lat': 14.417641110862036,
'lng': 121.03920716409016,
'labeledLatLngs': [{'label': 'display',
'lat': 14.417641110862036,
'lng': 121.03920716409016}],
'distance': 1583,
'postalCode': '1781',
'cc': 'PH',
'city': 'Muntinlupa City',
'country': 'Pilipinas',
'formattedAddress': ['1781 Muntinlupa City']},
'categories': [{'id': '4f2a25ac4b909258e854f55f',
'name': 'Neighborhood',
'pluralName': 'Neighborhoods',
'shortName': 'Neighborhood',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/parks_outdoors/neighborhood_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '59d86dca2347246fede29682',
'name': 'Shorts Market',
'location': {'lat': 14.423472,
'lng': 121.029678,
'labeledLatLngs': [{'label': 'display',
'lat': 14.423472,
'lng': 121.029678}],
'distance': 1008,
'postalCode': '1700',
'cc': 'PH',
'city': 'Muntinlupa',
'country': 'Pilipinas',
'formattedAddress': ['1700 Muntinlupa']},
'categories': [{'id': '4bf58dd8d48988d103951735',
'name': 'Clothing Store',
'pluralName': 'Clothing Stores',
'shortName': 'Apparel',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/apparel_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '5df4a01411ae5100084e5c78',
'name': 'Christmas Calle Night Market',
'location': {'address': 'Molito',
'lat': 14.425626,
'lng': 121.026886,
'labeledLatLngs': [{'label': 'display',
'lat': 14.425626,
'lng': 121.026886}],
'distance': 1115,
'cc': 'PH',
'city': 'Muntinlupa',
'country': 'Pilipinas',
'formattedAddress': ['Molito', 'Muntinlupa']},
'categories': [{'id': '53e510b7498ebcb1801b55d4',
'name': 'Night Market',
'pluralName': 'Night Markets',
'shortName': 'Night Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/fleamarket_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '4c04a20173a8c9b6206196e0',
'name': 'Filinvest Marketing Office',
'location': {'lat': 14.414948469421045,
'lng': 121.039045008137,
'labeledLatLngs': [{'label': 'display',
'lat': 14.414948469421045,
'lng': 121.039045008137}],
'distance': 1556,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '5032885091d4c4b30a586d66',
'name': 'Real Estate Office',
'pluralName': 'Real Estate Offices',
'shortName': 'Real Estate',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/realestate_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '4d30e9498ece8cfa6f7dc0a4',
'name': 'Saturday Market',
'location': {'address': 'Alabang Country Club',
'lat': 14.409994617027799,
'lng': 121.01812506757925,
'labeledLatLngs': [{'label': 'display',
'lat': 14.409994617027799,
'lng': 121.01812506757925}],
'distance': 957,
'cc': 'PH',
'city': 'Muntinlupa City',
'country': 'Pilipinas',
'formattedAddress': ['Alabang Country Club', 'Muntinlupa City']},
'categories': [],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '4c385f363849c9288f54bfb1',
'name': "Earle's Delicatessen",
'location': {'address': 'South Supermarket',
'crossStreet': 'Filinvest Ave.',
'lat': 14.421518852445262,
'lng': 121.03627801486566,
'labeledLatLngs': [{'label': 'display',
'lat': 14.421518852445262,
'lng': 121.03627801486566}],
'distance': 1405,
'postalCode': '1771',
'cc': 'PH',
'city': 'Muntinlupa City',
'country': 'Pilipinas',
'formattedAddress': ['South Supermarket (Filinvest Ave.)',
'1771 Muntinlupa City']},
'categories': [{'id': '4bf58dd8d48988d146941735',
'name': 'Deli / Bodega',
'pluralName': 'Delis / Bodegas',
'shortName': 'Deli / Bodega',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/deli_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '4eb1df21490126a570052b42',
'name': 'Intermed Marketing Philippines',
'location': {'lat': 14.426080413266561,
'lng': 121.02458727547716,
'labeledLatLngs': [{'label': 'display',
'lat': 14.426080413266561,
'lng': 121.02458727547716}],
'distance': 1139,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d124941735',
'name': 'Office',
'pluralName': 'Offices',
'shortName': 'Office',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/building/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '4bb1d6daf964a520b7a53ce3',
'name': 'KFC',
'location': {'address': 'Ground Flr, Green Bldg, South Station',
'crossStreet': 'Alabang-Zapote Rd',
'lat': 14.419155100392013,
'lng': 121.04404978936445,
'labeledLatLngs': [{'label': 'display',
'lat': 14.419155100392013,
'lng': 121.04404978936445}],
'distance': 2125,
'cc': 'PH',
'city': 'Muntinlupa',
'state': 'Rizal',
'country': 'Pilipinas',
'formattedAddress': ['Ground Flr, Green Bldg, South Station (Alabang-Zapote Rd)',
'Muntinlupa City',
'Rizal']},
'categories': [{'id': '4bf58dd8d48988d16e941735',
'name': 'Fast Food Restaurant',
'pluralName': 'Fast Food Restaurants',
'shortName': 'Fast Food',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/fastfood_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '500749dce4b0aa85886904c4',
'name': 'TS Cruz Market',
'location': {'lat': 14.426498802066344,
'lng': 121.01540904514835,
'labeledLatLngs': [{'label': 'display',
'lat': 14.426498802066344,
'lng': 121.01540904514835}],
'distance': 1547,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d1fa941735',
'name': 'Farmers Market',
'pluralName': 'Farmers Markets',
'shortName': "Farmer's Market",
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/food_farmersmarket_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '4dca6fcb887769ff3d4de724',
'name': "Gourdo's World Market",
'location': {'address': 'Greenbelt 2',
'lat': 14.427682696601769,
'lng': 121.0212386181831,
'labeledLatLngs': [{'label': 'display',
'lat': 14.427682696601769,
'lng': 121.0212386181831}],
'distance': 1367,
'cc': 'PH',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['Greenbelt 2', 'Makati City', 'Makati City']},
'categories': [],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '50ab2b07e4b068b459279149',
'name': 'HDR Market',
'location': {'lat': 14.413281091617684,
'lng': 121.04096523891052,
'labeledLatLngs': [{'label': 'display',
'lat': 14.413281091617684,
'lng': 121.04096523891052}],
'distance': 1783,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d11d951735',
'name': 'Butcher',
'pluralName': 'Butchers',
'shortName': 'Butcher',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/food_butcher_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '57342e74498e58f5e653ac06',
'name': "festival mall's summer market",
'location': {'lat': 14.416465,
'lng': 121.039943,
'labeledLatLngs': [{'label': 'display',
'lat': 14.416465,
'lng': 121.039943}],
'distance': 1651,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d1f7941735',
'name': 'Flea Market',
'pluralName': 'Flea Markets',
'shortName': 'Flea Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/fleamarket_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '517915c6e4b0e8859321af5c',
'name': 'Moonwalk Market',
'location': {'lat': 14.426528543992971,
'lng': 121.01283856770507,
'labeledLatLngs': [{'label': 'display',
'lat': 14.426528543992971,
'lng': 121.01283856770507}],
'distance': 1741,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '5038d4ebe4b01fa3529f1747',
'name': '7 Eleven, Caltex, Wetparc Condominium',
'location': {'lat': 14.41912,
'lng': 121.0376,
'labeledLatLngs': [{'label': 'display',
'lat': 14.41912,
'lng': 121.0376}],
'distance': 1444,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d1c7941735',
'name': 'Snack Place',
'pluralName': 'Snack Places',
'shortName': 'Snacks',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/snacks_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '4fa47885e4b01208f9fafb9c',
'name': 'Saturday market university ave. Lasalle',
'location': {'lat': 14.40930194642288,
'lng': 121.01775063480123,
'labeledLatLngs': [{'label': 'display',
'lat': 14.40930194642288,
'lng': 121.01775063480123}],
'distance': 1039,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '50be8ee891d4fa8dcc7199a7',
'name': 'Market',
'pluralName': 'Markets',
'shortName': 'Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/market_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '55ecc842498e2b63b57ffdc1',
'name': 'Pilar Village Market',
'location': {'lat': 14.419617652893066,
'lng': 121.00843048095703,
'labeledLatLngs': [{'label': 'display',
'lat': 14.419617652893066,
'lng': 121.00843048095703}],
'distance': 1796,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '50be8ee891d4fa8dcc7199a7',
'name': 'Market',
'pluralName': 'Markets',
'shortName': 'Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/market_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '55f0bf74498edd83076fb4c3',
'name': 'Pilar Village Market',
'location': {'lat': 14.420142029360596,
'lng': 121.00844230860143,
'labeledLatLngs': [{'label': 'display',
'lat': 14.420142029360596,
'lng': 121.00844230860143}],
'distance': 1809,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '50be8ee891d4fa8dcc7199a7',
'name': 'Market',
'pluralName': 'Markets',
'shortName': 'Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/market_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '516478b7e4b00638ee573446',
'name': '711 Market Dr Filinvest Alabang',
'location': {'lat': 14.4131441116333,
'lng': 121.04156494140625,
'labeledLatLngs': [{'label': 'display',
'lat': 14.4131441116333,
'lng': 121.04156494140625}],
'distance': 1850,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4d954b0ea243a5684a65b473',
'name': 'Convenience Store',
'pluralName': 'Convenience Stores',
'shortName': 'Convenience Store',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/conveniencestore_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '5032cf79e4b012c9cf5b18f5',
'name': 'Filinvest Marketing Office, Parking Lot',
'location': {'lat': 14.414868294628228,
'lng': 121.03901119874806,
'labeledLatLngs': [{'label': 'display',
'lat': 14.414868294628228,
'lng': 121.03901119874806}],
'distance': 1553,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4c38df4de52ce0d596b336e1',
'name': 'Parking',
'pluralName': 'Parking',
'shortName': 'Parking',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/building/parking_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '566beac0498e7d638e82b036',
'name': 'MotoMarket',
'location': {'lat': 14.423192423825864,
'lng': 121.0341791525695,
'labeledLatLngs': [{'label': 'display',
'lat': 14.423192423825864,
'lng': 121.0341791525695}],
'distance': 1314,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '5032833091d4c4b30a586d60',
'name': 'Motorcycle Shop',
'pluralName': 'Motorcycle Shops',
'shortName': 'Motorcycle Shop',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/motorcycle_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '4ed46fcf30f803fae72c281c',
'name': 'Almanza Market Dampa',
'location': {'lat': 14.428741882818683,
'lng': 121.01246895207478,
'labeledLatLngs': [{'label': 'display',
'lat': 14.428741882818683,
'lng': 121.01246895207478}],
'distance': 1944,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d1ce941735',
'name': 'Seafood Restaurant',
'pluralName': 'Seafood Restaurants',
'shortName': 'Seafood',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/seafood_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '4f688e16e4b005342b04fc7b',
'name': '7-11 Market Drive',
'location': {'lat': 14.418583852724332,
'lng': 121.04344553652898,
'labeledLatLngs': [{'label': 'display',
'lat': 14.418583852724332,
'lng': 121.04344553652898}],
'distance': 2050,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4d954b0ea243a5684a65b473',
'name': 'Convenience Store',
'pluralName': 'Convenience Stores',
'shortName': 'Convenience Store',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/conveniencestore_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '4b9c7413f964a520d96936e3',
'name': 'Muntinlupa Poblacion Market',
'location': {'address': 'Putatan',
'crossStreet': 'National Road',
'lat': 14.401598151812177,
'lng': 121.03792063024551,
'labeledLatLngs': [{'label': 'display',
'lat': 14.401598151812177,
'lng': 121.03792063024551}],
'distance': 2137,
'postalCode': '1772',
'cc': 'PH',
'city': 'Muntinlupa',
'state': 'Rizal',
'country': 'Pilipinas',
'formattedAddress': ['Putatan (National Road)',
'1772 Muntinlupa City',
'Rizal']},
'categories': [{'id': '4bf58dd8d48988d118951735',
'name': 'Grocery Store',
'pluralName': 'Grocery Stores',
'shortName': 'Grocery Store',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/food_grocery_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '530746b111d2bb1a8b423039',
'name': 'Market Basket',
'location': {'lat': 14.414854,
'lng': 121.03959,
'labeledLatLngs': [{'label': 'display',
'lat': 14.414854,
'lng': 121.03959}],
'distance': 1616,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4eb1bd1c3b7b55596b4a748f',
'name': 'Filipino Restaurant',
'pluralName': 'Filipino Restaurants',
'shortName': 'Filipino',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/filipino_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '5886f37124fd71634798d256',
'name': 'APEX (Admin Project Experts) Marketing Consulting Philippines',
'location': {'address': 'The Commerce Center, E Asia Dr, Alabang',
'lat': 14.4197212,
'lng': 121.0349923,
'labeledLatLngs': [{'label': 'display',
'lat': 14.4197212,
'lng': 121.0349923}],
'distance': 1197,
'postalCode': '1781',
'cc': 'PH',
'city': 'Muntinlupa',
'state': 'Rizal',
'country': 'Pilipinas',
'formattedAddress': ['The Commerce Center, E Asia Dr, Alabang',
'1781 Muntinlupa',
'Rizal']},
'categories': [{'id': '50be8ee891d4fa8dcc7199a7',
'name': 'Market',
'pluralName': 'Markets',
'shortName': 'Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/market_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '5125ab52e4b05c4d0a733521',
'name': 'Filinvest Corporate City Marketing Office',
'location': {'address': 'Corporate Avenue',
'crossStreet': 'Filinvest City, Alabang,',
'lat': 14.411610717944706,
'lng': 121.03439752268035,
'labeledLatLngs': [{'label': 'display',
'lat': 14.411610717944706,
'lng': 121.03439752268035}],
'distance': 1153,
'postalCode': '1781',
'cc': 'PH',
'city': 'Muntinlupa',
'state': 'Rizal',
'country': 'Pilipinas',
'formattedAddress': ['Corporate Avenue (Filinvest City, Alabang,)',
'1781 Muntinlupa City',
'Rizal']},
'categories': [{'id': '4bf58dd8d48988d130941735',
'name': 'Building',
'pluralName': 'Buildings',
'shortName': 'Building',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/building/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '59e5cd79625a6608697d793a',
'name': 'Earthorigins Marketplace + Cafe',
'location': {'address': 'Westgate, Filinvest Corporate Center, Alabang',
'lat': 14.4222975,
'lng': 121.03487,
'labeledLatLngs': [{'label': 'display',
'lat': 14.4222975,
'lng': 121.03487}],
'distance': 1316,
'postalCode': '1781',
'cc': 'PH',
'neighborhood': 'Alabang',
'city': 'Muntinlupa',
'country': 'Pilipinas',
'formattedAddress': ['Westgate, Filinvest Corporate Center, Alabang',
'1781 Muntinlupa']},
'categories': [{'id': '52f2ab2ebcbc57f1066b8b45',
'name': 'Organic Grocery',
'pluralName': 'Organic Groceries',
'shortName': 'Organic Grocery',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/food_grocery_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '53461249498e860024c5ae28',
'name': 'Out Of The Box Marketing',
'location': {'address': 'B29 L22-A Soldiers Hills Village',
'lat': 14.402260578847734,
'lng': 121.03614091873168,
'labeledLatLngs': [{'label': 'display',
'lat': 14.402260578847734,
'lng': 121.03614091873168}],
'distance': 1956,
'postalCode': '1772',
'cc': 'PH',
'city': 'Muntinlupa',
'country': 'Pilipinas',
'formattedAddress': ['B29 L22-A Soldiers Hills Village',
'1772 Muntinlupa']},
'categories': [{'id': '4bf58dd8d48988d128951735',
'name': 'Gift Shop',
'pluralName': 'Gift Shops',
'shortName': 'Gift Shop',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/giftshop_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '5376e71a498e2b3f9db4c8c2',
'name': 'Bio Generra Marketing Inc',
'location': {'lat': 14.415973998727369,
'lng': 121.00680697144352,
'labeledLatLngs': [{'label': 'display',
'lat': 14.415973998727369,
'lng': 121.00680697144352}],
'distance': 1922,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d124941735',
'name': 'Office',
'pluralName': 'Offices',
'shortName': 'Office',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/building/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '55f787f8498ed2a46121bd01',
'name': 'Soldiers Hills Market',
'location': {'lat': 14.401090608803493,
'lng': 121.03532091190645,
'labeledLatLngs': [{'label': 'display',
'lat': 14.401090608803493,
'lng': 121.03532091190645}],
'distance': 2006,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '50be8ee891d4fa8dcc7199a7',
'name': 'Market',
'pluralName': 'Markets',
'shortName': 'Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/market_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False},
{'id': '5332c02f498efb598e0ede01',
'name': 'Market Basket Modern Dampa',
'location': {'address': 'Filinvest, Alabang',
'lat': 14.414870430941388,
'lng': 121.03952509316491,
'labeledLatLngs': [{'label': 'display',
'lat': 14.414870430941388,
'lng': 121.03952509316491}],
'distance': 1609,
'cc': 'PH',
'city': 'Muntinlupa',
'state': 'Rizal',
'country': 'Pilipinas',
'formattedAddress': ['Filinvest, Alabang', 'Muntinlupa', 'Rizal']},
'categories': [{'id': '4bf58dd8d48988d1c4941735',
'name': 'Restaurant',
'pluralName': 'Restaurants',
'shortName': 'Restaurant',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837145',
'hasPerk': False}]}}
In [14]:
# assign relevant part of JSON to venues
venues_1 = results_1['response']['venues']
# tranform venues into a dataframe
df_results_1 = json_normalize(venues_1)
df_results_1
/opt/conda/envs/Python-3.7-main/lib/python3.7/site-packages/ipykernel/__main__.py:5: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead
Out[14]:
| id | name | categories | referralId | hasPerk | location.lat | location.lng | location.labeledLatLngs | location.distance | location.cc | location.city | location.state | location.country | location.formattedAddress | location.address | location.crossStreet | location.postalCode | location.neighborhood | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 4d9c0f8381f6f04d521682aa | Alabang Public Market | [{'id': '50be8ee891d4fa8dcc7199a7', 'name': 'M... | v-1612837145 | False | 14.420129 | 121.044560 | [{'label': 'display', 'lat': 14.42012902514245... | 2200 | PH | Muntinlupa | Rizal | Pilipinas | [Muntinlupa City, Rizal] | NaN | NaN | NaN | NaN |
| 1 | 4d4a54e24509721e71252db0 | Gourdo's World Market | [{'id': '4bf58dd8d48988d127951735', 'name': 'A... | v-1612837145 | False | 14.424579 | 121.028977 | [{'label': 'display', 'lat': 14.42457944485915... | 1079 | PH | Muntinlupa City | NaN | Pilipinas | [Alabang Town Center (Alabang-Zapote Rd), Munt... | Alabang Town Center | Alabang-Zapote Rd | NaN | NaN |
| 2 | 57f5c417498e2f861592344e | Mongolian Quick-Box / Pho Market | [{'id': '4eb1d5724b900d56c88a45fe', 'name': 'M... | v-1612837145 | False | 14.417155 | 121.039056 | [{'label': 'display', 'lat': 14.417155, 'lng':... | 1561 | PH | Muntinlupa | Rizal | Pilipinas | [Ground Floor, Festival Mall, Filinvest Corpor... | Ground Floor, Festival Mall, Filinvest Corpora... | NaN | 1780 | Alabang |
| 3 | 4b9b4631f964a520b2fd35e3 | South Supermarket | [{'id': '52f2ab2ebcbc57f1066b8b46', 'name': 'S... | v-1612837145 | False | 14.421447 | 121.036231 | [{'label': 'display', 'lat': 14.42144747333124... | 1397 | PH | Muntinlupa City | NaN | Pilipinas | [Filinvest Ave., Filinvest Corporate City, Ala... | Filinvest Ave., Filinvest Corporate City, Alabang | NaN | 1771 | NaN |
| 4 | 5528d131498e4a1cb5aacaf6 | Saturday Market on University Avenue | [{'id': '4bf58dd8d48988d143941735', 'name': 'B... | v-1612837145 | False | 14.410440 | 121.020897 | [{'label': 'display', 'lat': 14.41044042625462... | 724 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN |
| 5 | 4d5efa01b19fa14358f7e0c8 | Filinvest Corporate City | [{'id': '4f2a25ac4b909258e854f55f', 'name': 'N... | v-1612837145 | False | 14.417641 | 121.039207 | [{'label': 'display', 'lat': 14.41764111086203... | 1583 | PH | Muntinlupa City | NaN | Pilipinas | [1781 Muntinlupa City] | NaN | NaN | 1781 | NaN |
| 6 | 59d86dca2347246fede29682 | Shorts Market | [{'id': '4bf58dd8d48988d103951735', 'name': 'C... | v-1612837145 | False | 14.423472 | 121.029678 | [{'label': 'display', 'lat': 14.423472, 'lng':... | 1008 | PH | Muntinlupa | NaN | Pilipinas | [1700 Muntinlupa] | NaN | NaN | 1700 | NaN |
| 7 | 5df4a01411ae5100084e5c78 | Christmas Calle Night Market | [{'id': '53e510b7498ebcb1801b55d4', 'name': 'N... | v-1612837145 | False | 14.425626 | 121.026886 | [{'label': 'display', 'lat': 14.425626, 'lng':... | 1115 | PH | Muntinlupa | NaN | Pilipinas | [Molito, Muntinlupa] | Molito | NaN | NaN | NaN |
| 8 | 4c04a20173a8c9b6206196e0 | Filinvest Marketing Office | [{'id': '5032885091d4c4b30a586d66', 'name': 'R... | v-1612837145 | False | 14.414948 | 121.039045 | [{'label': 'display', 'lat': 14.41494846942104... | 1556 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN |
| 9 | 4d30e9498ece8cfa6f7dc0a4 | Saturday Market | [] | v-1612837145 | False | 14.409995 | 121.018125 | [{'label': 'display', 'lat': 14.40999461702779... | 957 | PH | Muntinlupa City | NaN | Pilipinas | [Alabang Country Club, Muntinlupa City] | Alabang Country Club | NaN | NaN | NaN |
| 10 | 4c385f363849c9288f54bfb1 | Earle's Delicatessen | [{'id': '4bf58dd8d48988d146941735', 'name': 'D... | v-1612837145 | False | 14.421519 | 121.036278 | [{'label': 'display', 'lat': 14.42151885244526... | 1405 | PH | Muntinlupa City | NaN | Pilipinas | [South Supermarket (Filinvest Ave.), 1771 Munt... | South Supermarket | Filinvest Ave. | 1771 | NaN |
| 11 | 4eb1df21490126a570052b42 | Intermed Marketing Philippines | [{'id': '4bf58dd8d48988d124941735', 'name': 'O... | v-1612837145 | False | 14.426080 | 121.024587 | [{'label': 'display', 'lat': 14.42608041326656... | 1139 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN |
| 12 | 4bb1d6daf964a520b7a53ce3 | KFC | [{'id': '4bf58dd8d48988d16e941735', 'name': 'F... | v-1612837145 | False | 14.419155 | 121.044050 | [{'label': 'display', 'lat': 14.41915510039201... | 2125 | PH | Muntinlupa | Rizal | Pilipinas | [Ground Flr, Green Bldg, South Station (Alaban... | Ground Flr, Green Bldg, South Station | Alabang-Zapote Rd | NaN | NaN |
| 13 | 500749dce4b0aa85886904c4 | TS Cruz Market | [{'id': '4bf58dd8d48988d1fa941735', 'name': 'F... | v-1612837145 | False | 14.426499 | 121.015409 | [{'label': 'display', 'lat': 14.42649880206634... | 1547 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN |
| 14 | 4dca6fcb887769ff3d4de724 | Gourdo's World Market | [] | v-1612837145 | False | 14.427683 | 121.021239 | [{'label': 'display', 'lat': 14.42768269660176... | 1367 | PH | Makati City | Makati City | Pilipinas | [Greenbelt 2, Makati City, Makati City] | Greenbelt 2 | NaN | NaN | NaN |
| 15 | 50ab2b07e4b068b459279149 | HDR Market | [{'id': '4bf58dd8d48988d11d951735', 'name': 'B... | v-1612837145 | False | 14.413281 | 121.040965 | [{'label': 'display', 'lat': 14.41328109161768... | 1783 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN |
| 16 | 57342e74498e58f5e653ac06 | festival mall's summer market | [{'id': '4bf58dd8d48988d1f7941735', 'name': 'F... | v-1612837145 | False | 14.416465 | 121.039943 | [{'label': 'display', 'lat': 14.416465, 'lng':... | 1651 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN |
| 17 | 517915c6e4b0e8859321af5c | Moonwalk Market | [] | v-1612837145 | False | 14.426529 | 121.012839 | [{'label': 'display', 'lat': 14.42652854399297... | 1741 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN |
| 18 | 5038d4ebe4b01fa3529f1747 | 7 Eleven, Caltex, Wetparc Condominium | [{'id': '4bf58dd8d48988d1c7941735', 'name': 'S... | v-1612837145 | False | 14.419120 | 121.037600 | [{'label': 'display', 'lat': 14.41912, 'lng': ... | 1444 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN |
| 19 | 4fa47885e4b01208f9fafb9c | Saturday market university ave. Lasalle | [{'id': '50be8ee891d4fa8dcc7199a7', 'name': 'M... | v-1612837145 | False | 14.409302 | 121.017751 | [{'label': 'display', 'lat': 14.40930194642288... | 1039 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN |
| 20 | 55ecc842498e2b63b57ffdc1 | Pilar Village Market | [{'id': '50be8ee891d4fa8dcc7199a7', 'name': 'M... | v-1612837145 | False | 14.419618 | 121.008430 | [{'label': 'display', 'lat': 14.41961765289306... | 1796 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN |
| 21 | 55f0bf74498edd83076fb4c3 | Pilar Village Market | [{'id': '50be8ee891d4fa8dcc7199a7', 'name': 'M... | v-1612837145 | False | 14.420142 | 121.008442 | [{'label': 'display', 'lat': 14.42014202936059... | 1809 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN |
| 22 | 516478b7e4b00638ee573446 | 711 Market Dr Filinvest Alabang | [{'id': '4d954b0ea243a5684a65b473', 'name': 'C... | v-1612837145 | False | 14.413144 | 121.041565 | [{'label': 'display', 'lat': 14.4131441116333,... | 1850 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN |
| 23 | 5032cf79e4b012c9cf5b18f5 | Filinvest Marketing Office, Parking Lot | [{'id': '4c38df4de52ce0d596b336e1', 'name': 'P... | v-1612837145 | False | 14.414868 | 121.039011 | [{'label': 'display', 'lat': 14.41486829462822... | 1553 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN |
| 24 | 566beac0498e7d638e82b036 | MotoMarket | [{'id': '5032833091d4c4b30a586d60', 'name': 'M... | v-1612837145 | False | 14.423192 | 121.034179 | [{'label': 'display', 'lat': 14.42319242382586... | 1314 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN |
| 25 | 4ed46fcf30f803fae72c281c | Almanza Market Dampa | [{'id': '4bf58dd8d48988d1ce941735', 'name': 'S... | v-1612837145 | False | 14.428742 | 121.012469 | [{'label': 'display', 'lat': 14.42874188281868... | 1944 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN |
| 26 | 4f688e16e4b005342b04fc7b | 7-11 Market Drive | [{'id': '4d954b0ea243a5684a65b473', 'name': 'C... | v-1612837145 | False | 14.418584 | 121.043446 | [{'label': 'display', 'lat': 14.41858385272433... | 2050 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN |
| 27 | 4b9c7413f964a520d96936e3 | Muntinlupa Poblacion Market | [{'id': '4bf58dd8d48988d118951735', 'name': 'G... | v-1612837145 | False | 14.401598 | 121.037921 | [{'label': 'display', 'lat': 14.40159815181217... | 2137 | PH | Muntinlupa | Rizal | Pilipinas | [Putatan (National Road), 1772 Muntinlupa City... | Putatan | National Road | 1772 | NaN |
| 28 | 530746b111d2bb1a8b423039 | Market Basket | [{'id': '4eb1bd1c3b7b55596b4a748f', 'name': 'F... | v-1612837145 | False | 14.414854 | 121.039590 | [{'label': 'display', 'lat': 14.414854, 'lng':... | 1616 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN |
| 29 | 5886f37124fd71634798d256 | APEX (Admin Project Experts) Marketing Consult... | [{'id': '50be8ee891d4fa8dcc7199a7', 'name': 'M... | v-1612837145 | False | 14.419721 | 121.034992 | [{'label': 'display', 'lat': 14.4197212, 'lng'... | 1197 | PH | Muntinlupa | Rizal | Pilipinas | [The Commerce Center, E Asia Dr, Alabang, 1781... | The Commerce Center, E Asia Dr, Alabang | NaN | 1781 | NaN |
| 30 | 5125ab52e4b05c4d0a733521 | Filinvest Corporate City Marketing Office | [{'id': '4bf58dd8d48988d130941735', 'name': 'B... | v-1612837145 | False | 14.411611 | 121.034398 | [{'label': 'display', 'lat': 14.41161071794470... | 1153 | PH | Muntinlupa | Rizal | Pilipinas | [Corporate Avenue (Filinvest City, Alabang,), ... | Corporate Avenue | Filinvest City, Alabang, | 1781 | NaN |
| 31 | 59e5cd79625a6608697d793a | Earthorigins Marketplace + Cafe | [{'id': '52f2ab2ebcbc57f1066b8b45', 'name': 'O... | v-1612837145 | False | 14.422298 | 121.034870 | [{'label': 'display', 'lat': 14.4222975, 'lng'... | 1316 | PH | Muntinlupa | NaN | Pilipinas | [Westgate, Filinvest Corporate Center, Alabang... | Westgate, Filinvest Corporate Center, Alabang | NaN | 1781 | Alabang |
| 32 | 53461249498e860024c5ae28 | Out Of The Box Marketing | [{'id': '4bf58dd8d48988d128951735', 'name': 'G... | v-1612837145 | False | 14.402261 | 121.036141 | [{'label': 'display', 'lat': 14.40226057884773... | 1956 | PH | Muntinlupa | NaN | Pilipinas | [B29 L22-A Soldiers Hills Village, 1772 Muntin... | B29 L22-A Soldiers Hills Village | NaN | 1772 | NaN |
| 33 | 5376e71a498e2b3f9db4c8c2 | Bio Generra Marketing Inc | [{'id': '4bf58dd8d48988d124941735', 'name': 'O... | v-1612837145 | False | 14.415974 | 121.006807 | [{'label': 'display', 'lat': 14.41597399872736... | 1922 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN |
| 34 | 55f787f8498ed2a46121bd01 | Soldiers Hills Market | [{'id': '50be8ee891d4fa8dcc7199a7', 'name': 'M... | v-1612837145 | False | 14.401091 | 121.035321 | [{'label': 'display', 'lat': 14.40109060880349... | 2006 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN |
| 35 | 5332c02f498efb598e0ede01 | Market Basket Modern Dampa | [{'id': '4bf58dd8d48988d1c4941735', 'name': 'R... | v-1612837145 | False | 14.414870 | 121.039525 | [{'label': 'display', 'lat': 14.41487043094138... | 1609 | PH | Muntinlupa | Rizal | Pilipinas | [Filinvest, Alabang, Muntinlupa, Rizal] | Filinvest, Alabang | NaN | NaN | NaN |
Now that there is a list of wet markets near Cluster 1, the data would have to be cleaned up so it is easier to understand.
In [15]:
# keep only columns that include venue name, and anything that is associated with location
filtered_columns_1 = ['name', 'categories'] + [col for col in df_results_1.columns if col.startswith('location.')] + ['id']
df_markets_1 = df_results_1.loc[:, filtered_columns_1]
# function that extracts the category of the venue
def get_category_type(row):
try:
categories_list = row['categories']
except:
categories_list = row['venue.categories']
if len(categories_list) == 0:
return None
else:
return categories_list[0]['name']
# filter the category for each row
df_markets_1['categories'] = df_markets_1.apply(get_category_type, axis=1)
# clean column names by keeping only last term
df_markets_1.columns = [column.split('.')[-1] for column in df_markets_1.columns]
df_markets_1
Out[15]:
| name | categories | lat | lng | labeledLatLngs | distance | cc | city | state | country | formattedAddress | address | crossStreet | postalCode | neighborhood | id | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Alabang Public Market | Market | 14.420129 | 121.044560 | [{'label': 'display', 'lat': 14.42012902514245... | 2200 | PH | Muntinlupa | Rizal | Pilipinas | [Muntinlupa City, Rizal] | NaN | NaN | NaN | NaN | 4d9c0f8381f6f04d521682aa |
| 1 | Gourdo's World Market | Arts & Crafts Store | 14.424579 | 121.028977 | [{'label': 'display', 'lat': 14.42457944485915... | 1079 | PH | Muntinlupa City | NaN | Pilipinas | [Alabang Town Center (Alabang-Zapote Rd), Munt... | Alabang Town Center | Alabang-Zapote Rd | NaN | NaN | 4d4a54e24509721e71252db0 |
| 2 | Mongolian Quick-Box / Pho Market | Mongolian Restaurant | 14.417155 | 121.039056 | [{'label': 'display', 'lat': 14.417155, 'lng':... | 1561 | PH | Muntinlupa | Rizal | Pilipinas | [Ground Floor, Festival Mall, Filinvest Corpor... | Ground Floor, Festival Mall, Filinvest Corpora... | NaN | 1780 | Alabang | 57f5c417498e2f861592344e |
| 3 | South Supermarket | Supermarket | 14.421447 | 121.036231 | [{'label': 'display', 'lat': 14.42144747333124... | 1397 | PH | Muntinlupa City | NaN | Pilipinas | [Filinvest Ave., Filinvest Corporate City, Ala... | Filinvest Ave., Filinvest Corporate City, Alabang | NaN | 1771 | NaN | 4b9b4631f964a520b2fd35e3 |
| 4 | Saturday Market on University Avenue | Breakfast Spot | 14.410440 | 121.020897 | [{'label': 'display', 'lat': 14.41044042625462... | 724 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN | 5528d131498e4a1cb5aacaf6 |
| 5 | Filinvest Corporate City | Neighborhood | 14.417641 | 121.039207 | [{'label': 'display', 'lat': 14.41764111086203... | 1583 | PH | Muntinlupa City | NaN | Pilipinas | [1781 Muntinlupa City] | NaN | NaN | 1781 | NaN | 4d5efa01b19fa14358f7e0c8 |
| 6 | Shorts Market | Clothing Store | 14.423472 | 121.029678 | [{'label': 'display', 'lat': 14.423472, 'lng':... | 1008 | PH | Muntinlupa | NaN | Pilipinas | [1700 Muntinlupa] | NaN | NaN | 1700 | NaN | 59d86dca2347246fede29682 |
| 7 | Christmas Calle Night Market | Night Market | 14.425626 | 121.026886 | [{'label': 'display', 'lat': 14.425626, 'lng':... | 1115 | PH | Muntinlupa | NaN | Pilipinas | [Molito, Muntinlupa] | Molito | NaN | NaN | NaN | 5df4a01411ae5100084e5c78 |
| 8 | Filinvest Marketing Office | Real Estate Office | 14.414948 | 121.039045 | [{'label': 'display', 'lat': 14.41494846942104... | 1556 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN | 4c04a20173a8c9b6206196e0 |
| 9 | Saturday Market | None | 14.409995 | 121.018125 | [{'label': 'display', 'lat': 14.40999461702779... | 957 | PH | Muntinlupa City | NaN | Pilipinas | [Alabang Country Club, Muntinlupa City] | Alabang Country Club | NaN | NaN | NaN | 4d30e9498ece8cfa6f7dc0a4 |
| 10 | Earle's Delicatessen | Deli / Bodega | 14.421519 | 121.036278 | [{'label': 'display', 'lat': 14.42151885244526... | 1405 | PH | Muntinlupa City | NaN | Pilipinas | [South Supermarket (Filinvest Ave.), 1771 Munt... | South Supermarket | Filinvest Ave. | 1771 | NaN | 4c385f363849c9288f54bfb1 |
| 11 | Intermed Marketing Philippines | Office | 14.426080 | 121.024587 | [{'label': 'display', 'lat': 14.42608041326656... | 1139 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN | 4eb1df21490126a570052b42 |
| 12 | KFC | Fast Food Restaurant | 14.419155 | 121.044050 | [{'label': 'display', 'lat': 14.41915510039201... | 2125 | PH | Muntinlupa | Rizal | Pilipinas | [Ground Flr, Green Bldg, South Station (Alaban... | Ground Flr, Green Bldg, South Station | Alabang-Zapote Rd | NaN | NaN | 4bb1d6daf964a520b7a53ce3 |
| 13 | TS Cruz Market | Farmers Market | 14.426499 | 121.015409 | [{'label': 'display', 'lat': 14.42649880206634... | 1547 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN | 500749dce4b0aa85886904c4 |
| 14 | Gourdo's World Market | None | 14.427683 | 121.021239 | [{'label': 'display', 'lat': 14.42768269660176... | 1367 | PH | Makati City | Makati City | Pilipinas | [Greenbelt 2, Makati City, Makati City] | Greenbelt 2 | NaN | NaN | NaN | 4dca6fcb887769ff3d4de724 |
| 15 | HDR Market | Butcher | 14.413281 | 121.040965 | [{'label': 'display', 'lat': 14.41328109161768... | 1783 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN | 50ab2b07e4b068b459279149 |
| 16 | festival mall's summer market | Flea Market | 14.416465 | 121.039943 | [{'label': 'display', 'lat': 14.416465, 'lng':... | 1651 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN | 57342e74498e58f5e653ac06 |
| 17 | Moonwalk Market | None | 14.426529 | 121.012839 | [{'label': 'display', 'lat': 14.42652854399297... | 1741 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN | 517915c6e4b0e8859321af5c |
| 18 | 7 Eleven, Caltex, Wetparc Condominium | Snack Place | 14.419120 | 121.037600 | [{'label': 'display', 'lat': 14.41912, 'lng': ... | 1444 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN | 5038d4ebe4b01fa3529f1747 |
| 19 | Saturday market university ave. Lasalle | Market | 14.409302 | 121.017751 | [{'label': 'display', 'lat': 14.40930194642288... | 1039 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN | 4fa47885e4b01208f9fafb9c |
| 20 | Pilar Village Market | Market | 14.419618 | 121.008430 | [{'label': 'display', 'lat': 14.41961765289306... | 1796 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN | 55ecc842498e2b63b57ffdc1 |
| 21 | Pilar Village Market | Market | 14.420142 | 121.008442 | [{'label': 'display', 'lat': 14.42014202936059... | 1809 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN | 55f0bf74498edd83076fb4c3 |
| 22 | 711 Market Dr Filinvest Alabang | Convenience Store | 14.413144 | 121.041565 | [{'label': 'display', 'lat': 14.4131441116333,... | 1850 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN | 516478b7e4b00638ee573446 |
| 23 | Filinvest Marketing Office, Parking Lot | Parking | 14.414868 | 121.039011 | [{'label': 'display', 'lat': 14.41486829462822... | 1553 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN | 5032cf79e4b012c9cf5b18f5 |
| 24 | MotoMarket | Motorcycle Shop | 14.423192 | 121.034179 | [{'label': 'display', 'lat': 14.42319242382586... | 1314 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN | 566beac0498e7d638e82b036 |
| 25 | Almanza Market Dampa | Seafood Restaurant | 14.428742 | 121.012469 | [{'label': 'display', 'lat': 14.42874188281868... | 1944 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN | 4ed46fcf30f803fae72c281c |
| 26 | 7-11 Market Drive | Convenience Store | 14.418584 | 121.043446 | [{'label': 'display', 'lat': 14.41858385272433... | 2050 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN | 4f688e16e4b005342b04fc7b |
| 27 | Muntinlupa Poblacion Market | Grocery Store | 14.401598 | 121.037921 | [{'label': 'display', 'lat': 14.40159815181217... | 2137 | PH | Muntinlupa | Rizal | Pilipinas | [Putatan (National Road), 1772 Muntinlupa City... | Putatan | National Road | 1772 | NaN | 4b9c7413f964a520d96936e3 |
| 28 | Market Basket | Filipino Restaurant | 14.414854 | 121.039590 | [{'label': 'display', 'lat': 14.414854, 'lng':... | 1616 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN | 530746b111d2bb1a8b423039 |
| 29 | APEX (Admin Project Experts) Marketing Consult... | Market | 14.419721 | 121.034992 | [{'label': 'display', 'lat': 14.4197212, 'lng'... | 1197 | PH | Muntinlupa | Rizal | Pilipinas | [The Commerce Center, E Asia Dr, Alabang, 1781... | The Commerce Center, E Asia Dr, Alabang | NaN | 1781 | NaN | 5886f37124fd71634798d256 |
| 30 | Filinvest Corporate City Marketing Office | Building | 14.411611 | 121.034398 | [{'label': 'display', 'lat': 14.41161071794470... | 1153 | PH | Muntinlupa | Rizal | Pilipinas | [Corporate Avenue (Filinvest City, Alabang,), ... | Corporate Avenue | Filinvest City, Alabang, | 1781 | NaN | 5125ab52e4b05c4d0a733521 |
| 31 | Earthorigins Marketplace + Cafe | Organic Grocery | 14.422298 | 121.034870 | [{'label': 'display', 'lat': 14.4222975, 'lng'... | 1316 | PH | Muntinlupa | NaN | Pilipinas | [Westgate, Filinvest Corporate Center, Alabang... | Westgate, Filinvest Corporate Center, Alabang | NaN | 1781 | Alabang | 59e5cd79625a6608697d793a |
| 32 | Out Of The Box Marketing | Gift Shop | 14.402261 | 121.036141 | [{'label': 'display', 'lat': 14.40226057884773... | 1956 | PH | Muntinlupa | NaN | Pilipinas | [B29 L22-A Soldiers Hills Village, 1772 Muntin... | B29 L22-A Soldiers Hills Village | NaN | 1772 | NaN | 53461249498e860024c5ae28 |
| 33 | Bio Generra Marketing Inc | Office | 14.415974 | 121.006807 | [{'label': 'display', 'lat': 14.41597399872736... | 1922 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN | 5376e71a498e2b3f9db4c8c2 |
| 34 | Soldiers Hills Market | Market | 14.401091 | 121.035321 | [{'label': 'display', 'lat': 14.40109060880349... | 2006 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | NaN | 55f787f8498ed2a46121bd01 |
| 35 | Market Basket Modern Dampa | Restaurant | 14.414870 | 121.039525 | [{'label': 'display', 'lat': 14.41487043094138... | 1609 | PH | Muntinlupa | Rizal | Pilipinas | [Filinvest, Alabang, Muntinlupa, Rizal] | Filinvest, Alabang | NaN | NaN | NaN | 5332c02f498efb598e0ede01 |
I could see here that not all of the search results are actually wet markets, like "Filinvest Corporate City," which is tagged as a neighborhood. But since most of these are really wet markets anyway, I will visualize these points in the map created and spot which markets are nearest to Ayala Alabang.
In [16]:
# add the wet markets to the map as yellow circle markers
for lat, lng, label in zip(df_markets_1.lat, df_markets_1.lng, df_markets_1.name):
folium.CircleMarker(
[lat, lng],
radius=5,
color='yellow',
popup=label,
fill = True,
fill_color='yellow',
fill_opacity=0.6
).add_to(cluster_map)
# display map
cluster_map
Out[16]:
Make this Notebook Trusted to load map: File -> Trust Notebook
Based on the map, the nearest market to Ayala Alabang would be the Saturday Market on University Ave. which is most likely the same as the points labeled "Saturday Market" and "Saturday Market University Ave. Lasalle." I will check the rating of Saturday Market on University Ave. to see if this market would meet the standards of the potential customers, the exclusive village residents.
In [17]:
#check the rating of Saturday Market on University Ave.
venue_id_SMUA = '4b9c7413f964a520d96936e3' # Saturday Market on University Ave.
url_SMUA = 'https://api.foursquare.com/v2/venues/{}?client_id={}&client_secret={}&oauth_token={}&v={}'.format(venue_id_SMUA, CLIENT_ID, CLIENT_SECRET,ACCESS_TOKEN, VERSION)
result_SMUA = requests.get(url_SMUA).json()
try:
print(result_SMUA['response']['venue']['rating'])
except:
print('This venue has not been rated yet.')
This venue has not been rated yet.
Because this venue has not been rated yet, I tried getting the ratings of the next nearby wet markets. However, all of them have no ratings either so I will try seeing if I can get a photo of the venue and gauge if it looks orderly and has good quality products.
In [18]:
url_SMUA_photo = 'https://api.foursquare.com/v2/photos/{}?client_id={}&client_secret={}&oauth_token={}&v={}'.format(venue_id_SMUA, CLIENT_ID, CLIENT_SECRET,ACCESS_TOKEN, VERSION)
result_SMUA_photo = requests.get(url_SMUA_photo).json()
result_SMUA_photo
Out[18]:
{'meta': {'code': 400,
'errorType': 'param_error',
'errorDetail': 'Must provide a valid photo ID',
'requestId': '6021f11adf2c8a58fb539093'},
'notifications': [{'type': 'notificationTray', 'item': {'unreadCount': 0}}],
'response': {}}
No photo was available also on Foursquare API, so an external image search was done on Google. The photos below showed that the market looked clean and it seemed to cater to the right customers (promotional materials were in English language, the tarpaulin sign was well-designed, and there was an ample amount of walking space). Therefore, I would recommend the target market to get Saturday Market vendors as the suppliers for Cluster 1.
Now, I will repeat the same process for choosing the wet market suppliers for Clusters 2, 3, and 5.
Finding wet market supplier candidates for Cluster 2¶
Because Cluster 2 only includes 3 villages, I picked one that wasn't the middle village to use as reference for finding wet markets near Cluster 2 (Serendra One), and this will be the first village to be delivered to.
In [19]:
#get latitude and longitude of Serendra One
address_2 = 'Serendra One, Metro Manila'
geolocator_2 = Nominatim(user_agent="2_agent")
location_2 = geolocator_2.geocode(address_2)
latitude_2 = location_2.latitude
longitude_2 = location_2.longitude
print(latitude_2, longitude_2)
14.55076185 121.05437323951678
In [20]:
#define the url to find wet markets near Cluster 2
url_2 = 'https://api.foursquare.com/v2/venues/search?client_id={}&client_secret={}&ll={},{}&oauth_token={}&v={}&query={}&radius={}&limit={}'.format(CLIENT_ID, CLIENT_SECRET, latitude_2, longitude_2,ACCESS_TOKEN, VERSION, search_query, radius, LIMIT)
url_2
Out[20]:
'https://api.foursquare.com/v2/venues/search?client_id=RSC3G0GMLOJSBAD0PM1CDGKHBJIO441GM32W4RMZ4EG2HXFL&client_secret=QR5FE44FD3AKMH3HRHINEHH4FTOWIPROJB42S02G41NLQE3S&ll=14.55076185,121.05437323951678&oauth_token=AGWAV4YZA0YDWA1CIRQPDLXLXO0XUAC0YRBQ5EVYJTBLHA53&v=20180605&query=wet market&radius=2000&limit=100'
In [21]:
#get the results of wet markets near Cluster 2
results_2 = requests.get(url_2).json()
results_2
Out[21]:
{'meta': {'code': 200, 'requestId': '6021f11ad7ffe01a4b7fb2f1'},
'notifications': [{'type': 'notificationTray', 'item': {'unreadCount': 0}}],
'response': {'venues': [{'id': '50fd2247e4b0d36cb20cddcd',
'name': 'Guadalupe Wet Market',
'location': {'address': 'Guadalupe',
'lat': 14.562327360326895,
'lng': 121.05019751017659,
'labeledLatLngs': [{'label': 'display',
'lat': 14.562327360326895,
'lng': 121.05019751017659}],
'distance': 1363,
'cc': 'PH',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['Guadalupe', 'Makati', 'Makati City']},
'categories': [{'id': '50be8ee891d4fa8dcc7199a7',
'name': 'Market',
'pluralName': 'Markets',
'shortName': 'Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/market_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4ec850e3f79041351dc96054',
'name': 'Pateros Wet Market',
'location': {'lat': 14.54863779635921,
'lng': 121.0671205691854,
'labeledLatLngs': [{'label': 'display',
'lat': 14.54863779635921,
'lng': 121.0671205691854}],
'distance': 1393,
'cc': 'PH',
'neighborhood': 'Comembo',
'country': 'Pilipinas'},
'categories': [{'id': '50be8ee891d4fa8dcc7199a7',
'name': 'Market',
'pluralName': 'Markets',
'shortName': 'Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/market_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4ff80912e4b036acfb2a5aa6',
'name': 'Wet Market @ 21st Street, West Rembo',
'location': {'address': '(21st) Mabini Street',
'crossStreet': 'West Rembo',
'lat': 14.564738260570083,
'lng': 121.06406418227297,
'labeledLatLngs': [{'label': 'display',
'lat': 14.564738260570083,
'lng': 121.06406418227297}],
'distance': 1873,
'postalCode': '1215',
'cc': 'PH',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['(21st) Mabini Street (West Rembo)',
'1215 Makati City',
'Makati City']},
'categories': [{'id': '4bf58dd8d48988d1f7941735',
'name': 'Flea Market',
'pluralName': 'Flea Markets',
'shortName': 'Flea Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/fleamarket_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4b4ae363f964a520888f26e3',
'name': 'Market! Market!',
'location': {'address': 'McKinley Pkwy',
'crossStreet': 'btwn 26th St & 32nd St',
'lat': 14.549645482533917,
'lng': 121.05589664270772,
'distance': 205,
'postalCode': '1634',
'cc': 'PH',
'city': 'Taguig City',
'country': 'Pilipinas',
'formattedAddress': ['McKinley Pkwy (btwn 26th St & 32nd St)',
'1634 Taguig City']},
'categories': [{'id': '4bf58dd8d48988d1fd941735',
'name': 'Shopping Mall',
'pluralName': 'Shopping Malls',
'shortName': 'Mall',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/mall_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4d4fe11ae027548161f89ab6',
'name': 'Market! Market! Parking',
'location': {'address': 'Market! Market!, McKinley Pwy, Bonifacio Global City',
'crossStreet': '32nd St.',
'lat': 14.550209537233606,
'lng': 121.05713944323499,
'labeledLatLngs': [{'label': 'display',
'lat': 14.550209537233606,
'lng': 121.05713944323499}],
'distance': 304,
'postalCode': '1634',
'cc': 'PH',
'city': 'Taguig City',
'country': 'Pilipinas',
'formattedAddress': ['Market! Market!, McKinley Pwy, Bonifacio Global City (32nd St.)',
'1634 Taguig City']},
'categories': [{'id': '4c38df4de52ce0d596b336e1',
'name': 'Parking',
'pluralName': 'Parking',
'shortName': 'Parking',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/building/parking_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4ef327a09a52fadb3448ee57',
'name': 'Fiesta Market',
'location': {'address': 'Market! Market!',
'lat': 14.548646708158616,
'lng': 121.05550787126899,
'labeledLatLngs': [{'label': 'display',
'lat': 14.548646708158616,
'lng': 121.05550787126899}],
'distance': 265,
'postalCode': '1634',
'cc': 'PH',
'city': 'Taguig',
'state': 'Rizal',
'country': 'Pilipinas',
'formattedAddress': ['Market! Market!', '1634 Taguig', 'Rizal']},
'categories': [{'id': '4bf58dd8d48988d120951735',
'name': 'Food Court',
'pluralName': 'Food Courts',
'shortName': 'Food Court',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/food_foodcourt_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4db88a9c43a1e5b1e2b84857',
'name': 'BGC Bus Stop (Market! Market! Terminal)',
'location': {'address': 'Market! Market! Parking Area',
'crossStreet': 'at 26th St',
'lat': 14.548955517800186,
'lng': 121.0564001529763,
'labeledLatLngs': [{'label': 'display',
'lat': 14.548955517800186,
'lng': 121.0564001529763}],
'distance': 296,
'cc': 'PH',
'neighborhood': 'Fort Bonifacio',
'city': 'Taguig City',
'country': 'Pilipinas',
'formattedAddress': ['Market! Market! Parking Area (at 26th St)',
'Taguig City']},
'categories': [{'id': '4bf58dd8d48988d1fe931735',
'name': 'Bus Station',
'pluralName': 'Bus Stations',
'shortName': 'Bus Station',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/travel/busstation_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4d42870932d5236ab57cb8a5',
'name': 'Market! Market! Activity Center',
'location': {'address': 'G/F Market! Market!, McKinley Pwy, Bonifacio Global City',
'crossStreet': 'btwn 26th & 32nd Sts',
'lat': 14.550386501205601,
'lng': 121.056255204624,
'labeledLatLngs': [{'label': 'display',
'lat': 14.550386501205601,
'lng': 121.056255204624}],
'distance': 207,
'cc': 'PH',
'neighborhood': 'Fort Bonifacio',
'city': 'Taguig',
'state': 'Rizal',
'country': 'Pilipinas',
'formattedAddress': ['G/F Market! Market!, McKinley Pwy, Bonifacio Global City (btwn 26th & 32nd Sts)',
'Taguig City',
'Rizal']},
'categories': [{'id': '4bf58dd8d48988d171941735',
'name': 'Event Space',
'pluralName': 'Event Spaces',
'shortName': 'Event Space',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/building/eventspace_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '5c7216bd840fc2002c16a73d',
'name': 'Market! Market! Farmers Market',
'location': {'address': 'Market! Market!',
'crossStreet': 'McKinley Dr',
'lat': 14.54968,
'lng': 121.05573,
'labeledLatLngs': [{'label': 'display',
'lat': 14.54968,
'lng': 121.05573}],
'distance': 189,
'postalCode': '1200',
'cc': 'PH',
'neighborhood': 'Fort Bonifacio',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['Market! Market! (McKinley Dr)',
'1200 Makati City',
'Makati City']},
'categories': [{'id': '4bf58dd8d48988d1fa941735',
'name': 'Farmers Market',
'pluralName': 'Farmers Markets',
'shortName': "Farmer's Market",
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/food_farmersmarket_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '57fcb246498e23d462ea2368',
'name': 'UV Express Terminal - Market! Market! - Rosario',
'location': {'address': 'Market! Market! Transport Terminal',
'lat': 14.550402,
'lng': 121.05628,
'labeledLatLngs': [{'label': 'display',
'lat': 14.550402,
'lng': 121.05628}],
'distance': 209,
'cc': 'PH',
'neighborhood': 'Fort Bonifacio',
'city': 'Taguig',
'country': 'Pilipinas',
'formattedAddress': ['Market! Market! Transport Terminal', 'Taguig']},
'categories': [{'id': '4bf58dd8d48988d1f6931735',
'name': 'General Travel',
'pluralName': 'General Travel',
'shortName': 'Travel',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/travel/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '54cae5b4498eab65c2b22826',
'name': 'MDC 309 Taguig-Global Market Market McKinley',
'location': {'lat': 14.550892572119084,
'lng': 121.05509609322921,
'labeledLatLngs': [{'label': 'display',
'lat': 14.550892572119084,
'lng': 121.05509609322921}],
'distance': 79,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d10f951735',
'name': 'Pharmacy',
'pluralName': 'Pharmacies',
'shortName': 'Pharmacy',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/pharmacy_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4efe8ad14690f6ece910fd10',
'name': 'Market! Market! Fountain Area',
'location': {'address': 'Market! Market!',
'lat': 14.548976053004028,
'lng': 121.05576208151948,
'labeledLatLngs': [{'label': 'display',
'lat': 14.548976053004028,
'lng': 121.05576208151948}],
'distance': 248,
'cc': 'PH',
'city': 'Taguig',
'state': 'Rizal',
'country': 'Pilipinas',
'formattedAddress': ['Market! Market!', 'Taguig', 'Rizal']},
'categories': [{'id': '56aa371be4b08b9a8d573547',
'name': 'Fountain',
'pluralName': 'Fountains',
'shortName': 'Fountain',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/parks_outdoors/plaza_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4ea5c2857ee5bebc94626256',
'name': 'Market Market Playground',
'location': {'address': 'Mckinley Prkwy',
'lat': 14.55141513716582,
'lng': 121.05428994012158,
'labeledLatLngs': [{'label': 'display',
'lat': 14.55141513716582,
'lng': 121.05428994012158}],
'distance': 73,
'cc': 'PH',
'city': 'Taguig',
'state': 'Rizal',
'country': 'Pilipinas',
'formattedAddress': ['Mckinley Prkwy', 'Taguig', 'Rizal']},
'categories': [{'id': '4bf58dd8d48988d1e7941735',
'name': 'Playground',
'pluralName': 'Playgrounds',
'shortName': 'Playground',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/parks_outdoors/playground_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4c91cdccb641236ac2988479',
'name': 'Fashion Market',
'location': {'address': 'Market! Market!',
'lat': 14.54912326330311,
'lng': 121.05577348159608,
'labeledLatLngs': [{'label': 'display',
'lat': 14.54912326330311,
'lng': 121.05577348159608}],
'distance': 236,
'cc': 'PH',
'city': 'Taguig',
'country': 'Pilipinas',
'formattedAddress': ['Market! Market!', 'Taguig']},
'categories': [{'id': '4bf58dd8d48988d1f7941735',
'name': 'Flea Market',
'pluralName': 'Flea Markets',
'shortName': 'Flea Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/fleamarket_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '5402f47c498ef5279c91fad6',
'name': 'Sodexo Affiliate Store, Celine - Market! Market!',
'location': {'lat': 14.550023,
'lng': 121.054659,
'labeledLatLngs': [{'label': 'display',
'lat': 14.550023,
'lng': 121.054659}],
'distance': 87,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d1f6941735',
'name': 'Department Store',
'pluralName': 'Department Stores',
'shortName': 'Department Store',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/departmentstore_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4d72ede74ab5224bac10c797',
'name': 'South of Market Private Residences',
'location': {'address': '11th Ave cor 25th & 26th Sts, Bonifacio Global City',
'lat': 14.546848572871859,
'lng': 121.05176507843987,
'labeledLatLngs': [{'label': 'display',
'lat': 14.546848572871859,
'lng': 121.05176507843987}],
'distance': 518,
'postalCode': '1634',
'cc': 'PH',
'city': 'Taguig City',
'country': 'Pilipinas',
'formattedAddress': ['11th Ave cor 25th & 26th Sts, Bonifacio Global City',
'1634 Taguig City']},
'categories': [{'id': '4d954b06a243a5684965b473',
'name': 'Residential Building (Apartment / Condo)',
'pluralName': 'Residential Buildings (Apartments / Condos)',
'shortName': 'Residential',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/building/apartment_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '5051b28ae4b04ec1377904aa',
'name': 'Reyes Barbecue Market Market',
'location': {'lat': 14.54993688942407,
'lng': 121.05401562290233,
'labeledLatLngs': [{'label': 'display',
'lat': 14.54993688942407,
'lng': 121.05401562290233}],
'distance': 99,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4eb1bd1c3b7b55596b4a748f',
'name': 'Filipino Restaurant',
'pluralName': 'Filipino Restaurants',
'shortName': 'Filipino',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/filipino_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '52f6104d498ecd9e0a3fb6c8',
'name': 'Guess market market',
'location': {'lat': 14.549899817363686,
'lng': 121.05446348742723,
'labeledLatLngs': [{'label': 'display',
'lat': 14.549899817363686,
'lng': 121.05446348742723}],
'distance': 96,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d103951735',
'name': 'Clothing Store',
'pluralName': 'Clothing Stores',
'shortName': 'Apparel',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/apparel_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '54138d60498e2ddcc2eb78fd',
'name': 'One Serendra - Market Lobby',
'location': {'address': 'One Serendra, Bonifacio Global City',
'lat': 14.549920310820434,
'lng': 121.05499532438606,
'labeledLatLngs': [{'label': 'display',
'lat': 14.549920310820434,
'lng': 121.05499532438606}],
'distance': 115,
'cc': 'PH',
'city': 'Taguig',
'state': 'Rizal',
'country': 'Pilipinas',
'formattedAddress': ['One Serendra, Bonifacio Global City',
'Taguig',
'Rizal']},
'categories': [{'id': '4d954b06a243a5684965b473',
'name': 'Residential Building (Apartment / Condo)',
'pluralName': 'Residential Buildings (Apartments / Condos)',
'shortName': 'Residential',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/building/apartment_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4e1584e0091a21120631050b',
'name': 'Market! Market! Taxi Terminal',
'location': {'address': 'Market! Market!',
'lat': 14.549005917296853,
'lng': 121.05645086615013,
'labeledLatLngs': [{'label': 'display',
'lat': 14.549005917296853,
'lng': 121.05645086615013}],
'distance': 297,
'cc': 'PH',
'city': 'Taguig',
'state': 'Rizal',
'country': 'Pilipinas',
'formattedAddress': ['Market! Market!', 'Taguig City', 'Rizal']},
'categories': [{'id': '53fca564498e1a175f32528b',
'name': 'Taxi Stand',
'pluralName': 'Taxi Stands',
'shortName': 'Taxi Stand',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/travel/taxi_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4f07ac71e4b06fab18a5682e',
'name': 'Market! Market! Terminal',
'location': {'address': '32nd St',
'lat': 14.551267331271063,
'lng': 121.05694937262065,
'labeledLatLngs': [{'label': 'display',
'lat': 14.551267331271063,
'lng': 121.05694937262065}],
'distance': 283,
'cc': 'PH',
'neighborhood': 'Fort Bonifacio',
'country': 'Pilipinas',
'formattedAddress': ['32nd St']},
'categories': [{'id': '4bf58dd8d48988d1f6931735',
'name': 'General Travel',
'pluralName': 'General Travel',
'shortName': 'Travel',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/travel/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4f0ecee5e4b0ac273923d457',
'name': 'The Pearl Market',
'location': {'lat': 14.549914868590564,
'lng': 121.05484976924144,
'labeledLatLngs': [{'label': 'display',
'lat': 14.549914868590564,
'lng': 121.05484976924144}],
'distance': 107,
'cc': 'PH',
'city': 'Taguig City',
'country': 'Pilipinas',
'formattedAddress': ['Taguig City']},
'categories': [{'id': '4bf58dd8d48988d1f6941735',
'name': 'Department Store',
'pluralName': 'Department Stores',
'shortName': 'Department Store',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/departmentstore_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '51616bbde4b05b2faf86f439',
'name': 'South of Market Gym',
'location': {'address': 'South of Market, 26th St, Bonifacio Global City',
'crossStreet': 'at 11th Ave',
'lat': 14.547177470502781,
'lng': 121.05230812411412,
'labeledLatLngs': [{'label': 'display',
'lat': 14.547177470502781,
'lng': 121.05230812411412}],
'distance': 456,
'cc': 'PH',
'city': 'Taguig',
'state': 'Rizal',
'country': 'Pilipinas',
'formattedAddress': ['South of Market, 26th St, Bonifacio Global City (at 11th Ave)',
'Taguig',
'Rizal']},
'categories': [{'id': '4bf58dd8d48988d175941735',
'name': 'Gym / Fitness Center',
'pluralName': 'Gyms or Fitness Centers',
'shortName': 'Gym / Fitness',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/building/gym_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '532c2243498e3df559758eb5',
'name': 'Merrell Market Market',
'location': {'lat': 14.55013998927856,
'lng': 121.05524724633575,
'labeledLatLngs': [{'label': 'display',
'lat': 14.55013998927856,
'lng': 121.05524724633575}],
'distance': 116,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d1f2941735',
'name': 'Sporting Goods Shop',
'pluralName': 'Sporting Goods Shops',
'shortName': 'Sporting Goods',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/sports_outdoors_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4fa8e234e4b06ebe04f98e44',
'name': 'telus market market',
'location': {'address': '4/F Telus Market Market',
'lat': 14.551736880003903,
'lng': 121.05497852957065,
'labeledLatLngs': [{'label': 'display',
'lat': 14.551736880003903,
'lng': 121.05497852957065}],
'distance': 126,
'cc': 'PH',
'city': 'Taguig',
'state': 'Rizal',
'country': 'Pilipinas',
'formattedAddress': ['4/F Telus Market Market', 'Taguig City', 'Rizal']},
'categories': [{'id': '4bf58dd8d48988d130941735',
'name': 'Building',
'pluralName': 'Buildings',
'shortName': 'Building',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/building/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4e33c54862845cff5a42c702',
'name': 'M Lhuillier - Marker!Market!',
'location': {'address': 'Market Market',
'lat': 14.550497259625228,
'lng': 121.05895883526982,
'labeledLatLngs': [{'label': 'display',
'lat': 14.550497259625228,
'lng': 121.05895883526982}],
'distance': 494,
'cc': 'PH',
'city': 'Taguig City',
'country': 'Pilipinas',
'formattedAddress': ['Market Market', 'Taguig City']},
'categories': [{'id': '4bf58dd8d48988d10a951735',
'name': 'Bank',
'pluralName': 'Banks',
'shortName': 'Bank',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/financial_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '52edad5d11d210399d9b44dd',
'name': 'unica hija market market',
'location': {'lat': 14.550304111685653,
'lng': 121.05542639051251,
'labeledLatLngs': [{'label': 'display',
'lat': 14.550304111685653,
'lng': 121.05542639051251}],
'distance': 124,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d103951735',
'name': 'Clothing Store',
'pluralName': 'Clothing Stores',
'shortName': 'Apparel',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/apparel_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '51616c2fe4b08465ec749578',
'name': 'South of Market Poolside',
'location': {'address': 'South of Market, 26th St, Bonifacio Global City',
'crossStreet': 'at 11th Ave',
'lat': 14.546612999150238,
'lng': 121.05202820396936,
'labeledLatLngs': [{'label': 'display',
'lat': 14.546612999150238,
'lng': 121.05202820396936}],
'distance': 526,
'cc': 'PH',
'city': 'Taguig',
'state': 'Rizal',
'country': 'Pilipinas',
'formattedAddress': ['South of Market, 26th St, Bonifacio Global City (at 11th Ave)',
'Taguig',
'Rizal']},
'categories': [{'id': '4bf58dd8d48988d15e941735',
'name': 'Pool',
'pluralName': 'Pools',
'shortName': 'Pool',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/parks_outdoors/pool_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '5395a74c498e3d1061e70c2f',
'name': 'Market! Market! Jeepney Terminal',
'location': {'address': 'Market! Market!',
'lat': 14.551282191103606,
'lng': 121.05017511619641,
'labeledLatLngs': [{'label': 'display',
'lat': 14.551282191103606,
'lng': 121.05017511619641}],
'distance': 456,
'cc': 'PH',
'neighborhood': 'Fort Bonifacio',
'country': 'Pilipinas',
'formattedAddress': ['Market! Market!']},
'categories': [{'id': '4bf58dd8d48988d1f6931735',
'name': 'General Travel',
'pluralName': 'General Travel',
'shortName': 'Travel',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/travel/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '533a3b4a498e8b8847fadd7e',
'name': 'mercury drug market market 2',
'location': {'lat': 14.549681942843979,
'lng': 121.05381968164866,
'labeledLatLngs': [{'label': 'display',
'lat': 14.549681942843979,
'lng': 121.05381968164866}],
'distance': 134,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d10f951735',
'name': 'Pharmacy',
'pluralName': 'Pharmacies',
'shortName': 'Pharmacy',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/pharmacy_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '51fb87e0498e64420476b7ca',
'name': 'me & u gift shop market market',
'location': {'lat': 14.549666,
'lng': 121.054968,
'labeledLatLngs': [{'label': 'display',
'lat': 14.549666,
'lng': 121.054968}],
'distance': 137,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d128951735',
'name': 'Gift Shop',
'pluralName': 'Gift Shops',
'shortName': 'Gift Shop',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/giftshop_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '5c5ce26b8afbe0002db664ba',
'name': 'Sunnies Specs Market Market',
'location': {'address': 'L1 GF Ayala Market Market',
'crossStreet': 'Bonifacio Global City',
'lat': 14.549574,
'lng': 121.055208,
'labeledLatLngs': [{'label': 'display',
'lat': 14.549574,
'lng': 121.055208}],
'distance': 159,
'postalCode': '1200',
'cc': 'PH',
'city': 'Taguig',
'country': 'Pilipinas',
'formattedAddress': ['L1 GF Ayala Market Market (Bonifacio Global City)',
'1200 Taguig']},
'categories': [{'id': '4d954afda243a5684865b473',
'name': 'Optical Shop',
'pluralName': 'Optical Shops',
'shortName': 'Optical',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/building/medical_opticalshop_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4bc598730a30d13aa22e5a9c',
'name': 'Market! Market! Cinemas',
'location': {'address': '5th Flr, Market! Market!',
'crossStreet': 'at McKinley Pkwy & 32nd St.',
'lat': 14.550404640988782,
'lng': 121.05628562673921,
'labeledLatLngs': [{'label': 'display',
'lat': 14.550404640988782,
'lng': 121.05628562673921}],
'distance': 209,
'cc': 'PH',
'city': 'Taguig City',
'country': 'Pilipinas',
'formattedAddress': ['5th Flr, Market! Market! (at McKinley Pkwy & 32nd St.)',
'Taguig City']},
'categories': [{'id': '4bf58dd8d48988d180941735',
'name': 'Multiplex',
'pluralName': 'Multiplexes',
'shortName': 'Cineplex',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/arts_entertainment/movietheater_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '54cb0de7498e0e154a2ceba5',
'name': 'Mint- Market Market',
'location': {'address': 'Market Market',
'lat': 14.551067326510301,
'lng': 121.05565032035845,
'labeledLatLngs': [{'label': 'display',
'lat': 14.551067326510301,
'lng': 121.05565032035845}],
'distance': 141,
'cc': 'PH',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['Market Market', 'Makati', 'Makati City']},
'categories': [{'id': '4bf58dd8d48988d103951735',
'name': 'Clothing Store',
'pluralName': 'Clothing Stores',
'shortName': 'Apparel',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/apparel_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4c4fc8c42a73c9283f7d6ad1',
'name': 'Market on 5th Avenue',
'location': {'address': "St. Luke's Medical Center, 5th Ave",
'lat': 14.555565856208913,
'lng': 121.04836464533484,
'labeledLatLngs': [{'label': 'display',
'lat': 14.555565856208913,
'lng': 121.04836464533484}],
'distance': 839,
'cc': 'PH',
'city': 'Taguig City',
'country': 'Pilipinas',
'formattedAddress': ["St. Luke's Medical Center, 5th Ave",
'Taguig City']},
'categories': [{'id': '4bf58dd8d48988d147941735',
'name': 'Diner',
'pluralName': 'Diners',
'shortName': 'Diner',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/diner_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4d91cf2f80d33704fe47a406',
'name': 'Okonomiyaki Market Market',
'location': {'lat': 14.549566,
'lng': 121.05514,
'labeledLatLngs': [{'label': 'display',
'lat': 14.549566,
'lng': 121.05514}],
'distance': 156,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d1c7941735',
'name': 'Snack Place',
'pluralName': 'Snack Places',
'shortName': 'Snacks',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/snacks_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '50986a53e4b01e2e830a1063',
'name': 'TIP Market Market 5th fl smoking area',
'location': {'lat': 14.550001031785992,
'lng': 121.05556074847006,
'labeledLatLngs': [{'label': 'display',
'lat': 14.550001031785992,
'lng': 121.05556074847006}],
'distance': 153,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d130941735',
'name': 'Building',
'pluralName': 'Buildings',
'shortName': 'Building',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/building/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '5c16d24295d986002cb176cc',
'name': 'Peoples Champorado Fiesta Market',
'location': {'address': 'kiosk 4 fiesta market, market market',
'crossStreet': 'bonifacio global city',
'lat': 14.549198,
'lng': 121.05466,
'labeledLatLngs': [{'label': 'display',
'lat': 14.549198,
'lng': 121.05466}],
'distance': 176,
'cc': 'PH',
'city': 'Taguig',
'country': 'Pilipinas',
'formattedAddress': ['kiosk 4 fiesta market, market market (bonifacio global city)',
'Taguig']},
'categories': [{'id': '56aa371be4b08b9a8d57350b',
'name': 'Food Stand',
'pluralName': 'Food Stands',
'shortName': 'Food Stand',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/travel/movingtarget_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4d91d426cbc1224b0f2821d5',
'name': 'Atm Center Market Market',
'location': {'address': 'Ground Floor',
'lat': 14.549447749999999,
'lng': 121.055025,
'labeledLatLngs': [{'label': 'display',
'lat': 14.549447749999999,
'lng': 121.055025}],
'distance': 162,
'cc': 'PH',
'city': 'Taguig City',
'country': 'Pilipinas',
'formattedAddress': ['Ground Floor', 'Taguig City']},
'categories': [{'id': '4bf58dd8d48988d10a951735',
'name': 'Bank',
'pluralName': 'Banks',
'shortName': 'Bank',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/financial_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4f514831e4b050039c534178',
'name': 'Telus Market! Market! IP Essentials.',
'location': {'lat': 14.54991174831067,
'lng': 121.0556167309081,
'labeledLatLngs': [{'label': 'display',
'lat': 14.54991174831067,
'lng': 121.0556167309081}],
'distance': 164,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d130941735',
'name': 'Building',
'pluralName': 'Buildings',
'shortName': 'Building',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/building/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4e780818d4c0b42f2c3a0a20',
'name': 'Citibank Savings Market Market',
'location': {'lat': 14.55001830765356,
'lng': 121.0556951062776,
'labeledLatLngs': [{'label': 'display',
'lat': 14.55001830765356,
'lng': 121.0556951062776}],
'distance': 164,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d124941735',
'name': 'Office',
'pluralName': 'Offices',
'shortName': 'Office',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/building/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4f38c2cde4b0f4cfdff55d67',
'name': 'Sen-Lek, Market-Market',
'location': {'lat': 14.549621545172009,
'lng': 121.05516327241111,
'labeledLatLngs': [{'label': 'display',
'lat': 14.549621545172009,
'lng': 121.05516327241111}],
'distance': 152,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d149941735',
'name': 'Thai Restaurant',
'pluralName': 'Thai Restaurants',
'shortName': 'Thai',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/thai_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '533fcb62498e0cb3b51f7edb',
'name': 'foodchoices market market',
'location': {'lat': 14.551390095909415,
'lng': 121.0557063027548,
'labeledLatLngs': [{'label': 'display',
'lat': 14.551390095909415,
'lng': 121.0557063027548}],
'distance': 159,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '52e81612bcbc57f1066b7a00',
'name': 'Comfort Food Restaurant',
'pluralName': 'Comfort Food Restaurants',
'shortName': 'Comfort Food',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4d97e1dc97d06ea80ef7270b',
'name': 'Cebuana Lhuillier, Market!Market!',
'location': {'lat': 14.551218118527473,
'lng': 121.05581826746943,
'labeledLatLngs': [{'label': 'display',
'lat': 14.551218118527473,
'lng': 121.05581826746943}],
'distance': 163,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d10a951735',
'name': 'Bank',
'pluralName': 'Banks',
'shortName': 'Bank',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/financial_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4f2132c9e4b09044bd0b2a70',
'name': 'R365P,Inc Market! Market!',
'location': {'lat': 14.55164414475871,
'lng': 121.0559270987342,
'labeledLatLngs': [{'label': 'display',
'lat': 14.55164414475871,
'lng': 121.0559270987342}],
'distance': 194,
'cc': 'PH',
'city': 'Taguig',
'state': 'Rizal',
'country': 'Pilipinas',
'formattedAddress': ['Taguig', 'Rizal']},
'categories': [{'id': '4bf58dd8d48988d124941735',
'name': 'Office',
'pluralName': 'Offices',
'shortName': 'Office',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/building/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4fb6992ee4b02861a88bf7ee',
'name': 'W5 Conference Room, Harte Hanks, Market Market',
'location': {'lat': 14.549644036821336,
'lng': 121.0553200236897,
'labeledLatLngs': [{'label': 'display',
'lat': 14.549644036821336,
'lng': 121.0553200236897}],
'distance': 160,
'cc': 'PH',
'city': 'Taguig',
'country': 'Pilipinas',
'formattedAddress': ['Taguig']},
'categories': [{'id': '4bf58dd8d48988d127941735',
'name': 'Conference Room',
'pluralName': 'Conference Rooms',
'shortName': 'Conference room',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/building/office_conferenceroom_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '50c11536e4b05f48f6ca04ff',
'name': 'Mojo Filter 1 Training Room, TELUS Market! Market!',
'location': {'lat': 14.549449833891586,
'lng': 121.05537040798589,
'labeledLatLngs': [{'label': 'display',
'lat': 14.549449833891586,
'lng': 121.05537040798589}],
'distance': 181,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d127941735',
'name': 'Conference Room',
'pluralName': 'Conference Rooms',
'shortName': 'Conference room',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/building/office_conferenceroom_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4f460abbe4b081614df9e101',
'name': "Elsie's, Market! Market!",
'location': {'lat': 14.549605349036842,
'lng': 121.05504570881818,
'labeledLatLngs': [{'label': 'display',
'lat': 14.549605349036842,
'lng': 121.05504570881818}],
'distance': 147,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d143941735',
'name': 'Breakfast Spot',
'pluralName': 'Breakfast Spots',
'shortName': 'Breakfast',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/breakfast_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4f78362ce4b0b9643b13d8f9',
'name': "Wendy's kiosk Market! Market!",
'location': {'lat': 14.550384342284875,
'lng': 121.05619894672002,
'labeledLatLngs': [{'label': 'display',
'lat': 14.550384342284875,
'lng': 121.05619894672002}],
'distance': 201,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d14e941735',
'name': 'American Restaurant',
'pluralName': 'American Restaurants',
'shortName': 'American',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False},
{'id': '4f6cb4f2e4b032eb625a9e82',
'name': 'Learning And Development Office, Old Flat Top 4, Market Market',
'location': {'lat': 14.550388049568426,
'lng': 121.05590224093707,
'labeledLatLngs': [{'label': 'display',
'lat': 14.550388049568426,
'lng': 121.05590224093707}],
'distance': 169,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d124941735',
'name': 'Office',
'pluralName': 'Offices',
'shortName': 'Office',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/building/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837146',
'hasPerk': False}]}}
In [22]:
# assign relevant part of JSON to venues
venues_2 = results_2['response']['venues']
# tranform venues into a dataframe
df_results_2 = json_normalize(venues_2)
# keep only columns that include venue name, and anything that is associated with location
filtered_columns_2 = ['name', 'categories'] + [col for col in df_results_2.columns if col.startswith('location.')] + ['id']
df_markets_2 = df_results_2.loc[:, filtered_columns_2]
# function that extracts the category of the venue
def get_category_type(row):
try:
categories_list = row['categories']
except:
categories_list = row['venue.categories']
if len(categories_list) == 0:
return None
else:
return categories_list[0]['name']
# filter the category for each row
df_markets_2['categories'] = df_markets_2.apply(get_category_type, axis=1)
# clean column names by keeping only last term
df_markets_2.columns = [column.split('.')[-1] for column in df_markets_2.columns]
df_markets_2
/opt/conda/envs/Python-3.7-main/lib/python3.7/site-packages/ipykernel/__main__.py:5: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead
Out[22]:
| name | categories | address | lat | lng | labeledLatLngs | distance | cc | city | state | country | formattedAddress | neighborhood | crossStreet | postalCode | id | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Guadalupe Wet Market | Market | Guadalupe | 14.562327 | 121.050198 | [{'label': 'display', 'lat': 14.56232736032689... | 1363 | PH | Makati City | Makati City | Pilipinas | [Guadalupe, Makati, Makati City] | NaN | NaN | NaN | 50fd2247e4b0d36cb20cddcd |
| 1 | Pateros Wet Market | Market | NaN | 14.548638 | 121.067121 | [{'label': 'display', 'lat': 14.54863779635921... | 1393 | PH | NaN | NaN | Pilipinas | NaN | Comembo | NaN | NaN | 4ec850e3f79041351dc96054 |
| 2 | Wet Market @ 21st Street, West Rembo | Flea Market | (21st) Mabini Street | 14.564738 | 121.064064 | [{'label': 'display', 'lat': 14.56473826057008... | 1873 | PH | Makati City | Makati City | Pilipinas | [(21st) Mabini Street (West Rembo), 1215 Makat... | NaN | West Rembo | 1215 | 4ff80912e4b036acfb2a5aa6 |
| 3 | Market! Market! | Shopping Mall | McKinley Pkwy | 14.549645 | 121.055897 | NaN | 205 | PH | Taguig City | NaN | Pilipinas | [McKinley Pkwy (btwn 26th St & 32nd St), 1634 ... | NaN | btwn 26th St & 32nd St | 1634 | 4b4ae363f964a520888f26e3 |
| 4 | Market! Market! Parking | Parking | Market! Market!, McKinley Pwy, Bonifacio Globa... | 14.550210 | 121.057139 | [{'label': 'display', 'lat': 14.55020953723360... | 304 | PH | Taguig City | NaN | Pilipinas | [Market! Market!, McKinley Pwy, Bonifacio Glob... | NaN | 32nd St. | 1634 | 4d4fe11ae027548161f89ab6 |
| 5 | Fiesta Market | Food Court | Market! Market! | 14.548647 | 121.055508 | [{'label': 'display', 'lat': 14.54864670815861... | 265 | PH | Taguig | Rizal | Pilipinas | [Market! Market!, 1634 Taguig, Rizal] | NaN | NaN | 1634 | 4ef327a09a52fadb3448ee57 |
| 6 | BGC Bus Stop (Market! Market! Terminal) | Bus Station | Market! Market! Parking Area | 14.548956 | 121.056400 | [{'label': 'display', 'lat': 14.54895551780018... | 296 | PH | Taguig City | NaN | Pilipinas | [Market! Market! Parking Area (at 26th St), Ta... | Fort Bonifacio | at 26th St | NaN | 4db88a9c43a1e5b1e2b84857 |
| 7 | Market! Market! Activity Center | Event Space | G/F Market! Market!, McKinley Pwy, Bonifacio G... | 14.550387 | 121.056255 | [{'label': 'display', 'lat': 14.55038650120560... | 207 | PH | Taguig | Rizal | Pilipinas | [G/F Market! Market!, McKinley Pwy, Bonifacio ... | Fort Bonifacio | btwn 26th & 32nd Sts | NaN | 4d42870932d5236ab57cb8a5 |
| 8 | Market! Market! Farmers Market | Farmers Market | Market! Market! | 14.549680 | 121.055730 | [{'label': 'display', 'lat': 14.54968, 'lng': ... | 189 | PH | Makati City | Makati City | Pilipinas | [Market! Market! (McKinley Dr), 1200 Makati Ci... | Fort Bonifacio | McKinley Dr | 1200 | 5c7216bd840fc2002c16a73d |
| 9 | UV Express Terminal - Market! Market! - Rosario | General Travel | Market! Market! Transport Terminal | 14.550402 | 121.056280 | [{'label': 'display', 'lat': 14.550402, 'lng':... | 209 | PH | Taguig | NaN | Pilipinas | [Market! Market! Transport Terminal, Taguig] | Fort Bonifacio | NaN | NaN | 57fcb246498e23d462ea2368 |
| 10 | MDC 309 Taguig-Global Market Market McKinley | Pharmacy | NaN | 14.550893 | 121.055096 | [{'label': 'display', 'lat': 14.55089257211908... | 79 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | 54cae5b4498eab65c2b22826 |
| 11 | Market! Market! Fountain Area | Fountain | Market! Market! | 14.548976 | 121.055762 | [{'label': 'display', 'lat': 14.54897605300402... | 248 | PH | Taguig | Rizal | Pilipinas | [Market! Market!, Taguig, Rizal] | NaN | NaN | NaN | 4efe8ad14690f6ece910fd10 |
| 12 | Market Market Playground | Playground | Mckinley Prkwy | 14.551415 | 121.054290 | [{'label': 'display', 'lat': 14.55141513716582... | 73 | PH | Taguig | Rizal | Pilipinas | [Mckinley Prkwy, Taguig, Rizal] | NaN | NaN | NaN | 4ea5c2857ee5bebc94626256 |
| 13 | Fashion Market | Flea Market | Market! Market! | 14.549123 | 121.055773 | [{'label': 'display', 'lat': 14.54912326330311... | 236 | PH | Taguig | NaN | Pilipinas | [Market! Market!, Taguig] | NaN | NaN | NaN | 4c91cdccb641236ac2988479 |
| 14 | Sodexo Affiliate Store, Celine - Market! Market! | Department Store | NaN | 14.550023 | 121.054659 | [{'label': 'display', 'lat': 14.550023, 'lng':... | 87 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | 5402f47c498ef5279c91fad6 |
| 15 | South of Market Private Residences | Residential Building (Apartment / Condo) | 11th Ave cor 25th & 26th Sts, Bonifacio Global... | 14.546849 | 121.051765 | [{'label': 'display', 'lat': 14.54684857287185... | 518 | PH | Taguig City | NaN | Pilipinas | [11th Ave cor 25th & 26th Sts, Bonifacio Globa... | NaN | NaN | 1634 | 4d72ede74ab5224bac10c797 |
| 16 | Reyes Barbecue Market Market | Filipino Restaurant | NaN | 14.549937 | 121.054016 | [{'label': 'display', 'lat': 14.54993688942407... | 99 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | 5051b28ae4b04ec1377904aa |
| 17 | Guess market market | Clothing Store | NaN | 14.549900 | 121.054463 | [{'label': 'display', 'lat': 14.54989981736368... | 96 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | 52f6104d498ecd9e0a3fb6c8 |
| 18 | One Serendra - Market Lobby | Residential Building (Apartment / Condo) | One Serendra, Bonifacio Global City | 14.549920 | 121.054995 | [{'label': 'display', 'lat': 14.54992031082043... | 115 | PH | Taguig | Rizal | Pilipinas | [One Serendra, Bonifacio Global City, Taguig, ... | NaN | NaN | NaN | 54138d60498e2ddcc2eb78fd |
| 19 | Market! Market! Taxi Terminal | Taxi Stand | Market! Market! | 14.549006 | 121.056451 | [{'label': 'display', 'lat': 14.54900591729685... | 297 | PH | Taguig | Rizal | Pilipinas | [Market! Market!, Taguig City, Rizal] | NaN | NaN | NaN | 4e1584e0091a21120631050b |
| 20 | Market! Market! Terminal | General Travel | 32nd St | 14.551267 | 121.056949 | [{'label': 'display', 'lat': 14.55126733127106... | 283 | PH | NaN | NaN | Pilipinas | [32nd St] | Fort Bonifacio | NaN | NaN | 4f07ac71e4b06fab18a5682e |
| 21 | The Pearl Market | Department Store | NaN | 14.549915 | 121.054850 | [{'label': 'display', 'lat': 14.54991486859056... | 107 | PH | Taguig City | NaN | Pilipinas | [Taguig City] | NaN | NaN | NaN | 4f0ecee5e4b0ac273923d457 |
| 22 | South of Market Gym | Gym / Fitness Center | South of Market, 26th St, Bonifacio Global City | 14.547177 | 121.052308 | [{'label': 'display', 'lat': 14.54717747050278... | 456 | PH | Taguig | Rizal | Pilipinas | [South of Market, 26th St, Bonifacio Global Ci... | NaN | at 11th Ave | NaN | 51616bbde4b05b2faf86f439 |
| 23 | Merrell Market Market | Sporting Goods Shop | NaN | 14.550140 | 121.055247 | [{'label': 'display', 'lat': 14.55013998927856... | 116 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | 532c2243498e3df559758eb5 |
| 24 | telus market market | Building | 4/F Telus Market Market | 14.551737 | 121.054979 | [{'label': 'display', 'lat': 14.55173688000390... | 126 | PH | Taguig | Rizal | Pilipinas | [4/F Telus Market Market, Taguig City, Rizal] | NaN | NaN | NaN | 4fa8e234e4b06ebe04f98e44 |
| 25 | M Lhuillier - Marker!Market! | Bank | Market Market | 14.550497 | 121.058959 | [{'label': 'display', 'lat': 14.55049725962522... | 494 | PH | Taguig City | NaN | Pilipinas | [Market Market, Taguig City] | NaN | NaN | NaN | 4e33c54862845cff5a42c702 |
| 26 | unica hija market market | Clothing Store | NaN | 14.550304 | 121.055426 | [{'label': 'display', 'lat': 14.55030411168565... | 124 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | 52edad5d11d210399d9b44dd |
| 27 | South of Market Poolside | Pool | South of Market, 26th St, Bonifacio Global City | 14.546613 | 121.052028 | [{'label': 'display', 'lat': 14.54661299915023... | 526 | PH | Taguig | Rizal | Pilipinas | [South of Market, 26th St, Bonifacio Global Ci... | NaN | at 11th Ave | NaN | 51616c2fe4b08465ec749578 |
| 28 | Market! Market! Jeepney Terminal | General Travel | Market! Market! | 14.551282 | 121.050175 | [{'label': 'display', 'lat': 14.55128219110360... | 456 | PH | NaN | NaN | Pilipinas | [Market! Market!] | Fort Bonifacio | NaN | NaN | 5395a74c498e3d1061e70c2f |
| 29 | mercury drug market market 2 | Pharmacy | NaN | 14.549682 | 121.053820 | [{'label': 'display', 'lat': 14.54968194284397... | 134 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | 533a3b4a498e8b8847fadd7e |
| 30 | me & u gift shop market market | Gift Shop | NaN | 14.549666 | 121.054968 | [{'label': 'display', 'lat': 14.549666, 'lng':... | 137 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | 51fb87e0498e64420476b7ca |
| 31 | Sunnies Specs Market Market | Optical Shop | L1 GF Ayala Market Market | 14.549574 | 121.055208 | [{'label': 'display', 'lat': 14.549574, 'lng':... | 159 | PH | Taguig | NaN | Pilipinas | [L1 GF Ayala Market Market (Bonifacio Global C... | NaN | Bonifacio Global City | 1200 | 5c5ce26b8afbe0002db664ba |
| 32 | Market! Market! Cinemas | Multiplex | 5th Flr, Market! Market! | 14.550405 | 121.056286 | [{'label': 'display', 'lat': 14.55040464098878... | 209 | PH | Taguig City | NaN | Pilipinas | [5th Flr, Market! Market! (at McKinley Pkwy & ... | NaN | at McKinley Pkwy & 32nd St. | NaN | 4bc598730a30d13aa22e5a9c |
| 33 | Mint- Market Market | Clothing Store | Market Market | 14.551067 | 121.055650 | [{'label': 'display', 'lat': 14.55106732651030... | 141 | PH | Makati City | Makati City | Pilipinas | [Market Market, Makati, Makati City] | NaN | NaN | NaN | 54cb0de7498e0e154a2ceba5 |
| 34 | Market on 5th Avenue | Diner | St. Luke's Medical Center, 5th Ave | 14.555566 | 121.048365 | [{'label': 'display', 'lat': 14.55556585620891... | 839 | PH | Taguig City | NaN | Pilipinas | [St. Luke's Medical Center, 5th Ave, Taguig City] | NaN | NaN | NaN | 4c4fc8c42a73c9283f7d6ad1 |
| 35 | Okonomiyaki Market Market | Snack Place | NaN | 14.549566 | 121.055140 | [{'label': 'display', 'lat': 14.549566, 'lng':... | 156 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | 4d91cf2f80d33704fe47a406 |
| 36 | TIP Market Market 5th fl smoking area | Building | NaN | 14.550001 | 121.055561 | [{'label': 'display', 'lat': 14.55000103178599... | 153 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | 50986a53e4b01e2e830a1063 |
| 37 | Peoples Champorado Fiesta Market | Food Stand | kiosk 4 fiesta market, market market | 14.549198 | 121.054660 | [{'label': 'display', 'lat': 14.549198, 'lng':... | 176 | PH | Taguig | NaN | Pilipinas | [kiosk 4 fiesta market, market market (bonifac... | NaN | bonifacio global city | NaN | 5c16d24295d986002cb176cc |
| 38 | Atm Center Market Market | Bank | Ground Floor | 14.549448 | 121.055025 | [{'label': 'display', 'lat': 14.54944774999999... | 162 | PH | Taguig City | NaN | Pilipinas | [Ground Floor, Taguig City] | NaN | NaN | NaN | 4d91d426cbc1224b0f2821d5 |
| 39 | Telus Market! Market! IP Essentials. | Building | NaN | 14.549912 | 121.055617 | [{'label': 'display', 'lat': 14.54991174831067... | 164 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | 4f514831e4b050039c534178 |
| 40 | Citibank Savings Market Market | Office | NaN | 14.550018 | 121.055695 | [{'label': 'display', 'lat': 14.55001830765356... | 164 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | 4e780818d4c0b42f2c3a0a20 |
| 41 | Sen-Lek, Market-Market | Thai Restaurant | NaN | 14.549622 | 121.055163 | [{'label': 'display', 'lat': 14.54962154517200... | 152 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | 4f38c2cde4b0f4cfdff55d67 |
| 42 | foodchoices market market | Comfort Food Restaurant | NaN | 14.551390 | 121.055706 | [{'label': 'display', 'lat': 14.55139009590941... | 159 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | 533fcb62498e0cb3b51f7edb |
| 43 | Cebuana Lhuillier, Market!Market! | Bank | NaN | 14.551218 | 121.055818 | [{'label': 'display', 'lat': 14.55121811852747... | 163 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | 4d97e1dc97d06ea80ef7270b |
| 44 | R365P,Inc Market! Market! | Office | NaN | 14.551644 | 121.055927 | [{'label': 'display', 'lat': 14.55164414475871... | 194 | PH | Taguig | Rizal | Pilipinas | [Taguig, Rizal] | NaN | NaN | NaN | 4f2132c9e4b09044bd0b2a70 |
| 45 | W5 Conference Room, Harte Hanks, Market Market | Conference Room | NaN | 14.549644 | 121.055320 | [{'label': 'display', 'lat': 14.54964403682133... | 160 | PH | Taguig | NaN | Pilipinas | [Taguig] | NaN | NaN | NaN | 4fb6992ee4b02861a88bf7ee |
| 46 | Mojo Filter 1 Training Room, TELUS Market! Mar... | Conference Room | NaN | 14.549450 | 121.055370 | [{'label': 'display', 'lat': 14.54944983389158... | 181 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | 50c11536e4b05f48f6ca04ff |
| 47 | Elsie's, Market! Market! | Breakfast Spot | NaN | 14.549605 | 121.055046 | [{'label': 'display', 'lat': 14.54960534903684... | 147 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | 4f460abbe4b081614df9e101 |
| 48 | Wendy's kiosk Market! Market! | American Restaurant | NaN | 14.550384 | 121.056199 | [{'label': 'display', 'lat': 14.55038434228487... | 201 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | 4f78362ce4b0b9643b13d8f9 |
| 49 | Learning And Development Office, Old Flat Top ... | Office | NaN | 14.550388 | 121.055902 | [{'label': 'display', 'lat': 14.55038804956842... | 169 | PH | NaN | NaN | Pilipinas | NaN | NaN | NaN | NaN | 4f6cb4f2e4b032eb625a9e82 |
In [23]:
# add the wet markets as yellow circle markers
for lat, lng, label in zip(df_markets_2.lat, df_markets_2.lng, df_markets_2.name):
folium.CircleMarker(
[lat, lng],
radius=5,
color='yellow',
popup=label,
fill = True,
fill_color='yellow',
fill_opacity=0.6
).add_to(cluster_map)
# display map
cluster_map
Out[23]:
Make this Notebook Trusted to load map: File -> Trust Notebook
As we can see here, there are many markets plotted near Cluster 2 because it is right next to a shopping mall called "Market! Market!" This might be one of the restrictions of using Foursquare API because even the non-food shops in the mall were included in the search results since their names had the word "Market" in them. Upon checking the nearby points though, it could be seen that there is also a Farmers Market within the mall Market! Market!, so this could be the potential supplier for Cluster 2.
Now I will check the rating of the Market! Market! Farmers Market.
In [24]:
#check the rating of Market! Market! Farmers Market
venue_id_MMFM = '5c7216bd840fc2002c16a73d' # Market! Market! Farmers Market
url_MMFM = 'https://api.foursquare.com/v2/venues/{}?client_id={}&client_secret={}&oauth_token={}&v={}'.format(venue_id_MMFM, CLIENT_ID, CLIENT_SECRET,ACCESS_TOKEN, VERSION)
result_MMFM = requests.get(url_MMFM).json()
try:
print(result_MMFM['response']['venue']['rating'])
except:
print('This venue has not been rated yet.')
This venue has not been rated yet.
Again, the venue has not been rated. Let's check if the venue has any tips which might help show feedback on this place.
In [25]:
## MMFM Tips
limit_MMFM = 15 # set limit to be greater than or equal to the total number of tips
tips_MMFM = 'https://api.foursquare.com/v2/venues/{}/tips?client_id={}&client_secret={}&oauth_token={}&v={}&limit={}'.format(venue_id_MMFM, CLIENT_ID, CLIENT_SECRET,ACCESS_TOKEN, VERSION, limit_MMFM)
results_MMFM = requests.get(tips_MMFM).json()
results_MMFM
Out[25]:
{'meta': {'code': 200, 'requestId': '6021f11b0149401628498fca'},
'notifications': [{'type': 'notificationTray', 'item': {'unreadCount': 0}}],
'response': {'tips': {'count': 0, 'items': []}}}
There are also no tips available on Foursquare API. Since this wet market and the next nearest wet markets (which were already a bit far from the cluster) do not have ratings too, I will base my decision to recommend Market! Market! Farmers Market as a supplier for Cluster 2 on photos of it that were found in Google Images.
Based on the photos, this looks like a clean and reputable wet market, especially because it is located in an area of a popular shopping mall. Therefore, I will recommend Market! Market! Farmers Market as a supplier for Cluster 2 residents.
Now, I will look for the best wet market supplier for Cluster 3.
Finding wet market supplier candidates for Cluster 3¶
Because Cluster 3 only includes 3 villages, I picked one that wasn't the middle village to use as reference for finding wet markets near Cluster 3, and this will be the first village to be delivered to. I specifically picked La Vista Village because the other two villages are a bit close to each other and are on one side of a river, so logistically, it's easier to deliver to La Vista first.
In [26]:
#get latitude and longitude of La Vista Village
address_3 = 'La Vista, Metro Manila'
geolocator_3 = Nominatim(user_agent="3_agent")
location_3 = geolocator_3.geocode(address_3)
latitude_3 = location_3.latitude
longitude_3 = location_3.longitude
print(latitude_3, longitude_3)
14.6385719 121.126406
In [27]:
#define the url to find wet markets near Cluster 3
url_3 = 'https://api.foursquare.com/v2/venues/search?client_id={}&client_secret={}&ll={},{}&oauth_token={}&v={}&query={}&radius={}&limit={}'.format(CLIENT_ID, CLIENT_SECRET, latitude_3, longitude_3,ACCESS_TOKEN, VERSION, search_query, radius, LIMIT)
url_3
Out[27]:
'https://api.foursquare.com/v2/venues/search?client_id=RSC3G0GMLOJSBAD0PM1CDGKHBJIO441GM32W4RMZ4EG2HXFL&client_secret=QR5FE44FD3AKMH3HRHINEHH4FTOWIPROJB42S02G41NLQE3S&ll=14.6385719,121.126406&oauth_token=AGWAV4YZA0YDWA1CIRQPDLXLXO0XUAC0YRBQ5EVYJTBLHA53&v=20180605&query=wet market&radius=2000&limit=100'
In [28]:
#get the results of wet markets near Cluster 3
results_3 = requests.get(url_3).json()
results_3
Out[28]:
{'meta': {'code': 200, 'requestId': '6021f11ce4a0d416f03917cc'},
'notifications': [{'type': 'notificationTray', 'item': {'unreadCount': 0}}],
'response': {'venues': [{'id': '4fb83768e4b0ee36afabe199',
'name': 'Masinag Wet Market',
'location': {'lat': 14.62549340975436,
'lng': 121.12346504939873,
'labeledLatLngs': [{'label': 'display',
'lat': 14.62549340975436,
'lng': 121.12346504939873}],
'distance': 1489,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d10e951735',
'name': 'Fish Market',
'pluralName': 'Fish Markets',
'shortName': 'Fish Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/food_fishmarket_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837148',
'hasPerk': False},
{'id': '4f4c2c38e4b0accb031f4e7c',
'name': 'Idol Wet & Dry Market',
'location': {'lat': 14.628670692443848,
'lng': 121.12205505371094,
'labeledLatLngs': [{'label': 'display',
'lat': 14.628670692443848,
'lng': 121.12205505371094}],
'distance': 1197,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d1f7941735',
'name': 'Flea Market',
'pluralName': 'Flea Markets',
'shortName': 'Flea Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/fleamarket_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837148',
'hasPerk': False},
{'id': '50f7c8abe4b059168fe27f13',
'name': 'Molave Wet and Dry Market',
'location': {'address': 'General Ordonez St. Marikina Heights',
'lat': 14.646197412518543,
'lng': 121.11291786613155,
'labeledLatLngs': [{'label': 'display',
'lat': 14.646197412518543,
'lng': 121.11291786613155}],
'distance': 1682,
'cc': 'PH',
'city': 'Marikina City',
'state': 'Marikina',
'country': 'Pilipinas',
'formattedAddress': ['General Ordonez St. Marikina Heights',
'Marikina City',
'Marikina']},
'categories': [{'id': '50be8ee891d4fa8dcc7199a7',
'name': 'Market',
'pluralName': 'Markets',
'shortName': 'Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/market_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837148',
'hasPerk': False},
{'id': '4c6be82e96eaa593366423df',
'name': 'Masinag Market',
'location': {'address': 'Marcos Hwy',
'crossStreet': 'at Sumulong Hwy',
'lat': 14.625439934869634,
'lng': 121.12501742835558,
'labeledLatLngs': [{'label': 'display',
'lat': 14.625439934869634,
'lng': 121.12501742835558}],
'distance': 1469,
'postalCode': '1870',
'cc': 'PH',
'city': 'Antipolo City',
'state': 'Rizal',
'country': 'Pilipinas',
'formattedAddress': ['Marcos Hwy (at Sumulong Hwy)',
'1870 Antipolo City',
'Rizal']},
'categories': [{'id': '50be8ee891d4fa8dcc7199a7',
'name': 'Market',
'pluralName': 'Markets',
'shortName': 'Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/market_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837148',
'hasPerk': False},
{'id': '4df16a6218386ecb4e27b8d6',
'name': 'Viaga Public Market',
'location': {'lat': 14.6407,
'lng': 121.126825,
'labeledLatLngs': [{'label': 'display',
'lat': 14.6407,
'lng': 121.126825}],
'distance': 241,
'cc': 'PH',
'city': 'Antipolo City',
'state': 'Rizal',
'country': 'Pilipinas',
'formattedAddress': ['Antipolo City', 'Rizal']},
'categories': [],
'referralId': 'v-1612837148',
'hasPerk': False},
{'id': '4df16a2822718759f8170e0c',
'name': 'Tumana Public Market',
'location': {'lat': 14.637201,
'lng': 121.120153,
'labeledLatLngs': [{'label': 'display',
'lat': 14.637201,
'lng': 121.120153}],
'distance': 690,
'cc': 'PH',
'city': 'Antipolo City',
'state': 'Rizal',
'country': 'Pilipinas',
'formattedAddress': ['Antipolo City', 'Rizal']},
'categories': [],
'referralId': 'v-1612837148',
'hasPerk': False},
{'id': '565d4586498e1def08eaebb5',
'name': 'Taboan Market',
'location': {'address': 'Cebu',
'lat': 14.631034,
'lng': 121.121824,
'labeledLatLngs': [{'label': 'display',
'lat': 14.631034,
'lng': 121.121824}],
'distance': 973,
'cc': 'PH',
'country': 'Pilipinas',
'formattedAddress': ['Cebu']},
'categories': [{'id': '50be8ee891d4fa8dcc7199a7',
'name': 'Market',
'pluralName': 'Markets',
'shortName': 'Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/market_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837148',
'hasPerk': False},
{'id': '51108ed9e4b00c28af5111c2',
'name': 'Sumulong Market',
'location': {'lat': 14.628974,
'lng': 121.121908,
'labeledLatLngs': [{'label': 'display',
'lat': 14.628974,
'lng': 121.121908}],
'distance': 1173,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '50be8ee891d4fa8dcc7199a7',
'name': 'Market',
'pluralName': 'Markets',
'shortName': 'Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/market_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837148',
'hasPerk': False},
{'id': '50ec29a9e4b0f8936ea8d4bf',
'name': 'Concepcion Square Market',
'location': {'lat': 14.642570107296972,
'lng': 121.1138579181091,
'labeledLatLngs': [{'label': 'display',
'lat': 14.642570107296972,
'lng': 121.1138579181091}],
'distance': 1422,
'cc': 'PH',
'city': 'Marikina City',
'state': 'Marikina',
'country': 'Pilipinas',
'formattedAddress': ['Marikina City', 'Marikina']},
'categories': [{'id': '50be8ee891d4fa8dcc7199a7',
'name': 'Market',
'pluralName': 'Markets',
'shortName': 'Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/market_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837148',
'hasPerk': False},
{'id': '50f792f2e4b0cfe718fb0abf',
'name': 'Goldenbox Marketing Corporation',
'location': {'crossStreet': 'Gen. Ordonez',
'lat': 14.646354065851737,
'lng': 121.11264368291312,
'labeledLatLngs': [{'label': 'display',
'lat': 14.646354065851737,
'lng': 121.11264368291312}],
'distance': 1716,
'cc': 'PH',
'city': 'Marikina City',
'state': 'Marikina',
'country': 'Pilipinas',
'formattedAddress': ['Gen. Ordonez', 'Marikina', 'Marikina']},
'categories': [{'id': '4bf58dd8d48988d124941735',
'name': 'Office',
'pluralName': 'Offices',
'shortName': 'Office',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/building/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837148',
'hasPerk': False},
{'id': '4d1f0f0d90662d430dd0f105',
'name': "McDonald's",
'location': {'address': 'Masinag Market',
'crossStreet': 'at Marcos Hwy & Don Juan Sumulong Ave.',
'lat': 14.625387213732749,
'lng': 121.12467635702546,
'labeledLatLngs': [{'label': 'display',
'lat': 14.625387213732749,
'lng': 121.12467635702546}],
'distance': 1479,
'postalCode': '1870',
'cc': 'PH',
'city': 'Antipolo City',
'state': 'Rizal',
'country': 'Pilipinas',
'formattedAddress': ['Masinag Market (at Marcos Hwy & Don Juan Sumulong Ave.)',
'1870 Antipolo City',
'Rizal']},
'categories': [{'id': '4bf58dd8d48988d16e941735',
'name': 'Fast Food Restaurant',
'pluralName': 'Fast Food Restaurants',
'shortName': 'Fast Food',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/fastfood_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837148',
'hasPerk': False},
{'id': '502490c2e4b00bcf2c3b2ef7',
'name': 'Molave Market',
'location': {'lat': 14.645223365818989,
'lng': 121.11349420839882,
'labeledLatLngs': [{'label': 'display',
'lat': 14.645223365818989,
'lng': 121.11349420839882}],
'distance': 1575,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d1f7941735',
'name': 'Flea Market',
'pluralName': 'Flea Markets',
'shortName': 'Flea Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/fleamarket_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837148',
'hasPerk': False},
{'id': '536e3ec1498efd959a4ebf10',
'name': 'conception market',
'location': {'lat': 14.653008460998535,
'lng': 121.12291717529297,
'labeledLatLngs': [{'label': 'display',
'lat': 14.653008460998535,
'lng': 121.12291717529297}],
'distance': 1650,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d130941735',
'name': 'Building',
'pluralName': 'Buildings',
'shortName': 'Building',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/building/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837148',
'hasPerk': False},
{'id': '5373440611d2c062146431c9',
'name': 'baytree public.market',
'location': {'lat': 14.653008460998535,
'lng': 121.12291717529297,
'labeledLatLngs': [{'label': 'display',
'lat': 14.653008460998535,
'lng': 121.12291717529297}],
'distance': 1650,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '50be8ee891d4fa8dcc7199a7',
'name': 'Market',
'pluralName': 'Markets',
'shortName': 'Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/market_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837148',
'hasPerk': False},
{'id': '4d20aefb2fc48eec208d77a1',
'name': 'Pagrai Public Market',
'location': {'address': 'Pagrai Hills Subdivision',
'crossStreet': 'Marcos Highway Brgy. Mayamot',
'lat': 14.628347589249808,
'lng': 121.14499855422561,
'labeledLatLngs': [{'label': 'display',
'lat': 14.628347589249808,
'lng': 121.14499855422561}],
'distance': 2303,
'postalCode': '1870',
'cc': 'PH',
'city': 'Antipolo City',
'country': 'Pilipinas',
'formattedAddress': ['Pagrai Hills Subdivision (Marcos Highway Brgy. Mayamot)',
'1870 Antipolo City']},
'categories': [{'id': '4bf58dd8d48988d1f7941735',
'name': 'Flea Market',
'pluralName': 'Flea Markets',
'shortName': 'Flea Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/fleamarket_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837148',
'hasPerk': False},
{'id': '50a786fde4b08df1a82104b3',
'name': 'NGI Market',
'location': {'lat': 14.653158788051693,
'lng': 121.1229279209122,
'labeledLatLngs': [{'label': 'display',
'lat': 14.653158788051693,
'lng': 121.1229279209122}],
'distance': 1666,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4f2a25ac4b909258e854f55f',
'name': 'Neighborhood',
'pluralName': 'Neighborhoods',
'shortName': 'Neighborhood',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/parks_outdoors/neighborhood_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837148',
'hasPerk': False},
{'id': '50de9bd2e4b0cf8b35485c1b',
'name': 'Beer Depot Marketing',
'location': {'address': '1 Sevilla St. Virginia Summerville Subd.',
'crossStreet': 'Brgy Mambugan',
'lat': 14.623839038521147,
'lng': 121.13369800471327,
'labeledLatLngs': [{'label': 'display',
'lat': 14.623839038521147,
'lng': 121.13369800471327}],
'distance': 1818,
'cc': 'PH',
'city': 'Antipolo City',
'state': 'Rizal',
'country': 'Pilipinas',
'formattedAddress': ['1 Sevilla St. Virginia Summerville Subd. (Brgy Mambugan)',
'Antipolo City',
'Rizal']},
'categories': [{'id': '4f04b1572fb6e1c99f3db0bf',
'name': 'Storage Facility',
'pluralName': 'Storage Facilities',
'shortName': 'Storage',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/storage_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837148',
'hasPerk': False},
{'id': '502d7a69e4b07d6b33fff9f4',
'name': 'I Fashion Marketing Co.',
'location': {'address': '57 Amang Rodqriguez Ave',
'lat': 14.656314237549617,
'lng': 121.1155197776352,
'labeledLatLngs': [{'label': 'display',
'lat': 14.656314237549617,
'lng': 121.1155197776352}],
'distance': 2296,
'cc': 'PH',
'neighborhood': 'Marikina Heights',
'city': 'Pasig',
'state': 'Pasig',
'country': 'Pilipinas',
'formattedAddress': ['57 Amang Rodqriguez Ave', 'Pasig City', 'Pasig']},
'categories': [{'id': '4bf58dd8d48988d124941735',
'name': 'Office',
'pluralName': 'Offices',
'shortName': 'Office',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/building/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837148',
'hasPerk': False}]}}
In [29]:
# assign relevant part of JSON to venues
venues_3 = results_3['response']['venues']
# tranform venues into a dataframe
df_results_3 = json_normalize(venues_3)
# keep only columns that include venue name, and anything that is associated with location
filtered_columns_3 = ['name', 'categories'] + [col for col in df_results_3.columns if col.startswith('location.')] + ['id']
df_markets_3 = df_results_3.loc[:, filtered_columns_3]
# function that extracts the category of the venue
def get_category_type(row):
try:
categories_list = row['categories']
except:
categories_list = row['venue.categories']
if len(categories_list) == 0:
return None
else:
return categories_list[0]['name']
# filter the category for each row
df_markets_3['categories'] = df_markets_3.apply(get_category_type, axis=1)
# clean column names by keeping only last term
df_markets_3.columns = [column.split('.')[-1] for column in df_markets_3.columns]
df_markets_3
/opt/conda/envs/Python-3.7-main/lib/python3.7/site-packages/ipykernel/__main__.py:5: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead
Out[29]:
| name | categories | lat | lng | labeledLatLngs | distance | cc | country | address | city | state | formattedAddress | crossStreet | postalCode | neighborhood | id | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Masinag Wet Market | Fish Market | 14.625493 | 121.123465 | [{'label': 'display', 'lat': 14.62549340975436... | 1489 | PH | Pilipinas | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 4fb83768e4b0ee36afabe199 |
| 1 | Idol Wet & Dry Market | Flea Market | 14.628671 | 121.122055 | [{'label': 'display', 'lat': 14.62867069244384... | 1197 | PH | Pilipinas | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 4f4c2c38e4b0accb031f4e7c |
| 2 | Molave Wet and Dry Market | Market | 14.646197 | 121.112918 | [{'label': 'display', 'lat': 14.64619741251854... | 1682 | PH | Pilipinas | General Ordonez St. Marikina Heights | Marikina City | Marikina | [General Ordonez St. Marikina Heights, Marikin... | NaN | NaN | NaN | 50f7c8abe4b059168fe27f13 |
| 3 | Masinag Market | Market | 14.625440 | 121.125017 | [{'label': 'display', 'lat': 14.62543993486963... | 1469 | PH | Pilipinas | Marcos Hwy | Antipolo City | Rizal | [Marcos Hwy (at Sumulong Hwy), 1870 Antipolo C... | at Sumulong Hwy | 1870 | NaN | 4c6be82e96eaa593366423df |
| 4 | Viaga Public Market | None | 14.640700 | 121.126825 | [{'label': 'display', 'lat': 14.6407, 'lng': 1... | 241 | PH | Pilipinas | NaN | Antipolo City | Rizal | [Antipolo City, Rizal] | NaN | NaN | NaN | 4df16a6218386ecb4e27b8d6 |
| 5 | Tumana Public Market | None | 14.637201 | 121.120153 | [{'label': 'display', 'lat': 14.637201, 'lng':... | 690 | PH | Pilipinas | NaN | Antipolo City | Rizal | [Antipolo City, Rizal] | NaN | NaN | NaN | 4df16a2822718759f8170e0c |
| 6 | Taboan Market | Market | 14.631034 | 121.121824 | [{'label': 'display', 'lat': 14.631034, 'lng':... | 973 | PH | Pilipinas | Cebu | NaN | NaN | [Cebu] | NaN | NaN | NaN | 565d4586498e1def08eaebb5 |
| 7 | Sumulong Market | Market | 14.628974 | 121.121908 | [{'label': 'display', 'lat': 14.628974, 'lng':... | 1173 | PH | Pilipinas | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 51108ed9e4b00c28af5111c2 |
| 8 | Concepcion Square Market | Market | 14.642570 | 121.113858 | [{'label': 'display', 'lat': 14.64257010729697... | 1422 | PH | Pilipinas | NaN | Marikina City | Marikina | [Marikina City, Marikina] | NaN | NaN | NaN | 50ec29a9e4b0f8936ea8d4bf |
| 9 | Goldenbox Marketing Corporation | Office | 14.646354 | 121.112644 | [{'label': 'display', 'lat': 14.64635406585173... | 1716 | PH | Pilipinas | NaN | Marikina City | Marikina | [Gen. Ordonez, Marikina, Marikina] | Gen. Ordonez | NaN | NaN | 50f792f2e4b0cfe718fb0abf |
| 10 | McDonald's | Fast Food Restaurant | 14.625387 | 121.124676 | [{'label': 'display', 'lat': 14.62538721373274... | 1479 | PH | Pilipinas | Masinag Market | Antipolo City | Rizal | [Masinag Market (at Marcos Hwy & Don Juan Sumu... | at Marcos Hwy & Don Juan Sumulong Ave. | 1870 | NaN | 4d1f0f0d90662d430dd0f105 |
| 11 | Molave Market | Flea Market | 14.645223 | 121.113494 | [{'label': 'display', 'lat': 14.64522336581898... | 1575 | PH | Pilipinas | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 502490c2e4b00bcf2c3b2ef7 |
| 12 | conception market | Building | 14.653008 | 121.122917 | [{'label': 'display', 'lat': 14.65300846099853... | 1650 | PH | Pilipinas | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 536e3ec1498efd959a4ebf10 |
| 13 | baytree public.market | Market | 14.653008 | 121.122917 | [{'label': 'display', 'lat': 14.65300846099853... | 1650 | PH | Pilipinas | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 5373440611d2c062146431c9 |
| 14 | Pagrai Public Market | Flea Market | 14.628348 | 121.144999 | [{'label': 'display', 'lat': 14.62834758924980... | 2303 | PH | Pilipinas | Pagrai Hills Subdivision | Antipolo City | NaN | [Pagrai Hills Subdivision (Marcos Highway Brgy... | Marcos Highway Brgy. Mayamot | 1870 | NaN | 4d20aefb2fc48eec208d77a1 |
| 15 | NGI Market | Neighborhood | 14.653159 | 121.122928 | [{'label': 'display', 'lat': 14.65315878805169... | 1666 | PH | Pilipinas | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 50a786fde4b08df1a82104b3 |
| 16 | Beer Depot Marketing | Storage Facility | 14.623839 | 121.133698 | [{'label': 'display', 'lat': 14.62383903852114... | 1818 | PH | Pilipinas | 1 Sevilla St. Virginia Summerville Subd. | Antipolo City | Rizal | [1 Sevilla St. Virginia Summerville Subd. (Brg... | Brgy Mambugan | NaN | NaN | 50de9bd2e4b0cf8b35485c1b |
| 17 | I Fashion Marketing Co. | Office | 14.656314 | 121.115520 | [{'label': 'display', 'lat': 14.65631423754961... | 2296 | PH | Pilipinas | 57 Amang Rodqriguez Ave | Pasig | Pasig | [57 Amang Rodqriguez Ave, Pasig City, Pasig] | NaN | NaN | Marikina Heights | 502d7a69e4b07d6b33fff9f4 |
In [30]:
# add the wet markets as yellow circle markers
for lat, lng, label in zip(df_markets_3.lat, df_markets_3.lng, df_markets_3.name):
folium.CircleMarker(
[lat, lng],
radius=5,
color='yellow',
popup=label,
fill = True,
fill_color='yellow',
fill_opacity=0.6
).add_to(cluster_map)
# display map
cluster_map
Out[30]:
Make this Notebook Trusted to load map: File -> Trust Notebook
Based on the map, the nearest market to La Vista is the Viaga Public Market. I will check if this has any ratings on Foursquare API.
In [31]:
#check the rating of Viaga Public Market
venue_id_VPM = '4df16a6218386ecb4e27b8d6' # Viaga Public Market
url_VPM = 'https://api.foursquare.com/v2/venues/{}?client_id={}&client_secret={}&oauth_token={}&v={}'.format(venue_id_VPM, CLIENT_ID, CLIENT_SECRET,ACCESS_TOKEN, VERSION)
result_VPM = requests.get(url_VPM).json()
try:
print(result_VPM['response']['venue']['rating'])
except:
print('This venue has not been rated yet.')
This venue has not been rated yet.
Since this venue does not have a rating, I checked the next nearest wet markets to see if they have ratings, tips, or photos. Unfortunately, none of them do. I tried checking Google Images for photos of Viaga Public Market, Tumana Public Market, and Taboan Public Market (the next nearest wet markets to La Vista), but no images of these were available as well.
I suppose that there are not too many venues in Metro Manila (or even in the Philippines) with reviews, tips, and photos on Foursquare API just yet. Either that, or not too many people review and leave tips on wet markets in this area. In this case, I will leave it to the user of this report to explore the suggested wet markets themselves and gauge whether these are suitable for their customers.
Lastly, I will repeat the process for Cluster 5.
Finding wet market supplier candidates for Cluster 5¶
Because Urdaneta Village is generally in the center of Cluster 5, I used it as a reference for searching for the list of wet markets nearest to the cluster.
In [32]:
#get latitude and longitude of Urdaneta Village
address_5 = 'Urdaneta Village, Metro Manila'
geolocator_5 = Nominatim(user_agent="5_agent")
location_5 = geolocator_5.geocode(address_5)
latitude_5 = location_5.latitude
longitude_5 = location_5.longitude
print(latitude_5, longitude_5)
14.5554581 121.03004429349755
In [33]:
#define the url to find wet markets near Cluster 5
url_5 = 'https://api.foursquare.com/v2/venues/search?client_id={}&client_secret={}&ll={},{}&oauth_token={}&v={}&query={}&radius={}&limit={}'.format(CLIENT_ID, CLIENT_SECRET, latitude_5, longitude_5,ACCESS_TOKEN, VERSION, search_query, radius, LIMIT)
url_5
Out[33]:
'https://api.foursquare.com/v2/venues/search?client_id=RSC3G0GMLOJSBAD0PM1CDGKHBJIO441GM32W4RMZ4EG2HXFL&client_secret=QR5FE44FD3AKMH3HRHINEHH4FTOWIPROJB42S02G41NLQE3S&ll=14.5554581,121.03004429349755&oauth_token=AGWAV4YZA0YDWA1CIRQPDLXLXO0XUAC0YRBQ5EVYJTBLHA53&v=20180605&query=wet market&radius=2000&limit=100'
In [34]:
#get the results of wet markets near Cluster 5
results_5 = requests.get(url_5).json()
results_5
Out[34]:
{'meta': {'code': 200, 'requestId': '6021f11dfcab6e35f351c3de'},
'notifications': [{'type': 'notificationTray', 'item': {'unreadCount': 0}}],
'response': {'venues': [{'id': '50cbc254e4b0d0701e405a55',
'name': 'Wet Market sa M. Ocampo St.',
'location': {'lat': 14.554268,
'lng': 121.012069,
'labeledLatLngs': [{'label': 'display',
'lat': 14.554268,
'lng': 121.012069}],
'distance': 1941,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4eb1bd1c3b7b55596b4a748f',
'name': 'Filipino Restaurant',
'pluralName': 'Filipino Restaurants',
'shortName': 'Filipino',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/filipino_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '4f1ccb0ae4b0838233838c13',
'name': 'Wet market',
'location': {'address': 'Pasong tamo',
'lat': 14.5666979,
'lng': 121.0124289,
'labeledLatLngs': [{'label': 'display',
'lat': 14.5666979,
'lng': 121.0124289}],
'distance': 2273,
'cc': 'PH',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['Pasong tamo', 'Makati', 'Makati City']},
'categories': [{'id': '4bf58dd8d48988d1f7941735',
'name': 'Flea Market',
'pluralName': 'Flea Markets',
'shortName': 'Flea Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/fleamarket_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '4d36160ecf67a143aa70af28',
'name': 'Washington Wet Market',
'location': {'address': 'Washington street',
'lat': 14.555784887839843,
'lng': 121.01206027005169,
'labeledLatLngs': [{'label': 'display',
'lat': 14.555784887839843,
'lng': 121.01206027005169}],
'distance': 1938,
'cc': 'PH',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['Washington street', 'Makati', 'Makati City']},
'categories': [{'id': '4bf58dd8d48988d1ff941735',
'name': 'Miscellaneous Shop',
'pluralName': 'Miscellaneous Shops',
'shortName': 'Shop',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '50fd2247e4b0d36cb20cddcd',
'name': 'Guadalupe Wet Market',
'location': {'address': 'Guadalupe',
'lat': 14.562327360326895,
'lng': 121.05019751017659,
'labeledLatLngs': [{'label': 'display',
'lat': 14.562327360326895,
'lng': 121.05019751017659}],
'distance': 2302,
'cc': 'PH',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['Guadalupe', 'Makati', 'Makati City']},
'categories': [{'id': '50be8ee891d4fa8dcc7199a7',
'name': 'Market',
'pluralName': 'Markets',
'shortName': 'Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/market_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '5a8b8832838e59787925d296',
'name': 'Tejeros Wet and Dry Market',
'location': {'address': 'Pasong Tirad St',
'crossStreet': 'Aranda St',
'lat': 14.57139,
'lng': 121.013296,
'labeledLatLngs': [{'label': 'display',
'lat': 14.57139,
'lng': 121.013296}],
'distance': 2530,
'postalCode': '1204',
'cc': 'PH',
'neighborhood': 'Tejeros',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['Pasong Tirad St (Aranda St)',
'1204 Makati City',
'Makati City']},
'categories': [{'id': '50be8ee891d4fa8dcc7199a7',
'name': 'Market',
'pluralName': 'Markets',
'shortName': 'Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/market_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '4f7c32b0e4b0d751c12c0e8a',
'name': 'Olympia Wet and Dry Market',
'location': {'address': 'Sacramento St',
'crossStreet': 'btwn J P Rizal Ave & Calasanz St',
'lat': 14.570688,
'lng': 121.020032,
'labeledLatLngs': [{'label': 'display',
'lat': 14.570688,
'lng': 121.020032}],
'distance': 2009,
'cc': 'PH',
'neighborhood': 'Olympia',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['Sacramento St (btwn J P Rizal Ave & Calasanz St)',
'Makati City',
'Makati City']},
'categories': [{'id': '50be8ee891d4fa8dcc7199a7',
'name': 'Market',
'pluralName': 'Markets',
'shortName': 'Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/market_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '4f0638ad9adf79d8740b4301',
'name': 'Ayala-Washington/Market! Market! Jeepney Terminal',
'location': {'address': 'McKinley Rd',
'crossStreet': 'at Epifanio de los Santos Ave',
'lat': 14.550111421970913,
'lng': 121.03026749400532,
'labeledLatLngs': [{'label': 'display',
'lat': 14.550111421970913,
'lng': 121.03026749400532}],
'distance': 595,
'cc': 'PH',
'neighborhood': 'Forbes Park',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['McKinley Rd (at Epifanio de los Santos Ave)',
'Makati City',
'Makati City']},
'categories': [{'id': '4bf58dd8d48988d1f6931735',
'name': 'General Travel',
'pluralName': 'General Travel',
'shortName': 'Travel',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/travel/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '4ed77521b6346530d05f28a3',
'name': 'The Market',
'location': {'address': 'G/F Tiffany Place, L P Leviste St',
'lat': 14.560122772250736,
'lng': 121.02504256500245,
'labeledLatLngs': [{'label': 'display',
'lat': 14.560122772250736,
'lng': 121.02504256500245}],
'distance': 748,
'postalCode': '1227',
'cc': 'PH',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['G/F Tiffany Place, L P Leviste St',
'1227 Makati City',
'Makati City']},
'categories': [{'id': '4bf58dd8d48988d146941735',
'name': 'Deli / Bodega',
'pluralName': 'Delis / Bodegas',
'shortName': 'Deli / Bodega',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/deli_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '4d9d1d665c33a35d7efffaa0',
'name': 'Market Phils',
'location': {'address': 'Philamlife Tower, 8767 Paseo de Roxas',
'lat': 14.557325,
'lng': 121.021975,
'labeledLatLngs': [{'label': 'display',
'lat': 14.557325,
'lng': 121.021975}],
'distance': 893,
'postalCode': '1209',
'cc': 'PH',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['Philamlife Tower, 8767 Paseo de Roxas',
'1209 Makati City',
'Makati City']},
'categories': [{'id': '4bf58dd8d48988d124941735',
'name': 'Office',
'pluralName': 'Offices',
'shortName': 'Office',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/building/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '4c80dacb47cc224b7752769f',
'name': "Guordo's World Market",
'location': {'address': 'Greenbelt 2',
'lat': 14.552136606540246,
'lng': 121.0209978248664,
'labeledLatLngs': [{'label': 'display',
'lat': 14.552136606540246,
'lng': 121.0209978248664}],
'distance': 1042,
'cc': 'PH',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['Greenbelt 2', 'Makati City', 'Makati City']},
'categories': [{'id': '4bf58dd8d48988d1f5941735',
'name': 'Gourmet Shop',
'pluralName': 'Gourmet Shops',
'shortName': 'Gourmet',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/food_gourmet_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '4e759be9814ddff25ee5cdf4',
'name': 'Poblacion Public Market',
'location': {'address': 'J. D. Villena St.',
'crossStreet': 'Poblacion',
'lat': 14.56518371405648,
'lng': 121.03360891342163,
'labeledLatLngs': [{'label': 'display',
'lat': 14.56518371405648,
'lng': 121.03360891342163}],
'distance': 1148,
'postalCode': '1210',
'cc': 'PH',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['J. D. Villena St. (Poblacion)',
'1210 Makati City',
'Makati City']},
'categories': [{'id': '4bf58dd8d48988d1f7941735',
'name': 'Flea Market',
'pluralName': 'Flea Markets',
'shortName': 'Flea Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/fleamarket_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '4cc7c603ee718cfaa5f1b33d',
'name': 'Savana Market',
'location': {'address': 'Vito Cruz Ext cor Metropolitan Ave',
'lat': 14.566710567280854,
'lng': 121.01347699204122,
'labeledLatLngs': [{'label': 'display',
'lat': 14.566710567280854,
'lng': 121.01347699204122}],
'distance': 2180,
'postalCode': '1200',
'cc': 'PH',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['Vito Cruz Ext cor Metropolitan Ave',
'1200 Makati City',
'Makati City']},
'categories': [{'id': '4bf58dd8d48988d1ff941735',
'name': 'Miscellaneous Shop',
'pluralName': 'Miscellaneous Shops',
'shortName': 'Shop',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '4b7d409ff964a520c7b42fe3',
'name': 'Legazpi Active Park',
'location': {'address': 'Rada St.',
'crossStreet': 'btwn Legazpi St. & Gamboa St.',
'lat': 14.554145209189077,
'lng': 121.01682901382446,
'labeledLatLngs': [{'label': 'display',
'lat': 14.554145209189077,
'lng': 121.01682901382446}],
'distance': 1431,
'postalCode': '1229',
'cc': 'PH',
'neighborhood': 'San Lorenzo',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['Rada St. (btwn Legazpi St. & Gamboa St.)',
'1229 Makati City',
'Makati City']},
'categories': [{'id': '4bf58dd8d48988d163941735',
'name': 'Park',
'pluralName': 'Parks',
'shortName': 'Park',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/parks_outdoors/park_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '4c148d47127f95216ade2425',
'name': 'Bonifacio Global City (BGC)',
'location': {'lat': 14.551145,
'lng': 121.049029,
'labeledLatLngs': [{'label': 'display',
'lat': 14.551145,
'lng': 121.049029}],
'distance': 2101,
'postalCode': '1634',
'cc': 'PH',
'city': 'Taguig City',
'country': 'Pilipinas',
'formattedAddress': ['1634 Taguig City']},
'categories': [{'id': '4f2a25ac4b909258e854f55f',
'name': 'Neighborhood',
'pluralName': 'Neighborhoods',
'shortName': 'Neighborhood',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/parks_outdoors/neighborhood_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '4bdbafdf3904a59391c54b9e',
'name': 'Salcedo Community Market',
'location': {'address': 'Jaime C. Velasquez Park, Tordesillas St, Salcedo Village',
'crossStreet': 'at L.P. Leviste St',
'lat': 14.559990477143446,
'lng': 121.0231404824813,
'labeledLatLngs': [{'label': 'display',
'lat': 14.559990477143446,
'lng': 121.0231404824813}],
'distance': 898,
'postalCode': '1226',
'cc': 'PH',
'neighborhood': 'Bel-Air',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['Jaime C. Velasquez Park, Tordesillas St, Salcedo Village (at L.P. Leviste St)',
'1226 Makati City',
'Makati City']},
'categories': [{'id': '4bf58dd8d48988d1fa941735',
'name': 'Farmers Market',
'pluralName': 'Farmers Markets',
'shortName': "Farmer's Market",
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/food_farmersmarket_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '4c79d538566db60c7d7f460e',
'name': 'Organic Farmers Market',
'location': {'address': 'Legaspi Village',
'lat': 14.555337094136977,
'lng': 121.0162098581076,
'labeledLatLngs': [{'label': 'display',
'lat': 14.555337094136977,
'lng': 121.0162098581076}],
'distance': 1490,
'cc': 'PH',
'neighborhood': 'San Lorenzo',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['Legaspi Village', 'Makati City', 'Makati City']},
'categories': [{'id': '4bf58dd8d48988d1fa941735',
'name': 'Farmers Market',
'pluralName': 'Farmers Markets',
'shortName': "Farmer's Market",
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/food_farmersmarket_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '4c4fc8c42a73c9283f7d6ad1',
'name': 'Market on 5th Avenue',
'location': {'address': "St. Luke's Medical Center, 5th Ave",
'lat': 14.555565856208913,
'lng': 121.04836464533484,
'labeledLatLngs': [{'label': 'display',
'lat': 14.555565856208913,
'lng': 121.04836464533484}],
'distance': 1973,
'cc': 'PH',
'city': 'Taguig City',
'country': 'Pilipinas',
'formattedAddress': ["St. Luke's Medical Center, 5th Ave",
'Taguig City']},
'categories': [{'id': '4bf58dd8d48988d147941735',
'name': 'Diner',
'pluralName': 'Diners',
'shortName': 'Diner',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/diner_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '53743c00498ef88c02346809',
'name': "Mara's Organic Market",
'location': {'address': 'Ground Flr, Gallery Bldg, Amorsolo St',
'lat': 14.554242,
'lng': 121.014956,
'labeledLatLngs': [{'label': 'display',
'lat': 14.554242,
'lng': 121.014956}],
'distance': 1631,
'cc': 'PH',
'neighborhood': 'San Lorenzo',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['Ground Flr, Gallery Bldg, Amorsolo St',
'Makati',
'Makati City']},
'categories': [{'id': '4bf58dd8d48988d1d3941735',
'name': 'Vegetarian / Vegan Restaurant',
'pluralName': 'Vegetarian / Vegan Restaurants',
'shortName': 'Vegetarian / Vegan',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/vegetarian_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '4fc8b93ae4b0adae39be9946',
'name': 'Ayala - Market Market Jeepney Terminal',
'location': {'lat': 14.55068456854846,
'lng': 121.02950929713023,
'labeledLatLngs': [{'label': 'display',
'lat': 14.55068456854846,
'lng': 121.02950929713023}],
'distance': 534,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d1f6931735',
'name': 'General Travel',
'pluralName': 'General Travel',
'shortName': 'Travel',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/travel/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '5517abd0498e91c798991695',
'name': "Cooked Food The Market Fresh Rustan's Makati",
'location': {'lat': 14.552486,
'lng': 121.026441,
'labeledLatLngs': [{'label': 'display',
'lat': 14.552486,
'lng': 121.026441}],
'distance': 510,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d16d941735',
'name': 'Café',
'pluralName': 'Cafés',
'shortName': 'Café',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/cafe_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '4bb075bef964a52084463ce3',
'name': "Max's Restaurant",
'location': {'address': 'Jupiter St., Bel-Air Village',
'lat': 14.561400609239914,
'lng': 121.02949154646247,
'labeledLatLngs': [{'label': 'display',
'lat': 14.561400609239914,
'lng': 121.02949154646247}],
'distance': 664,
'cc': 'PH',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['Jupiter St., Bel-Air Village',
'Makati City',
'Makati City']},
'categories': [{'id': '4d4ae6fc7a7b7dea34424761',
'name': 'Fried Chicken Joint',
'pluralName': 'Fried Chicken Joints',
'shortName': 'Fried Chicken',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/friedchicken_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '5e916915d2839e0007be497a',
'name': 'Polaris Rolling Produce Market',
'location': {'address': 'Polaris St',
'lat': 14.562583,
'lng': 121.030306,
'labeledLatLngs': [{'label': 'display',
'lat': 14.562583,
'lng': 121.030306}],
'distance': 793,
'postalCode': '1210',
'cc': 'PH',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['Polaris St', '1210 Makati City', 'Makati City']},
'categories': [{'id': '4bf58dd8d48988d1fa941735',
'name': 'Farmers Market',
'pluralName': 'Farmers Markets',
'shortName': "Farmer's Market",
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/food_farmersmarket_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '4ddb1a7f45dd588c721a40d0',
'name': 'The Market at L.P Leviste st',
'location': {'lat': 14.559353899721211,
'lng': 121.02569600776346,
'labeledLatLngs': [{'label': 'display',
'lat': 14.559353899721211,
'lng': 121.02569600776346}],
'distance': 638,
'cc': 'PH',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['Makati City', 'Makati City']},
'categories': [],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '4f8fec5ce4b01d8f6da6bce2',
'name': 'Market Market Jeepney Terminal',
'location': {'lat': 14.554971481001536,
'lng': 121.03517581293688,
'labeledLatLngs': [{'label': 'display',
'lat': 14.554971481001536,
'lng': 121.03517581293688}],
'distance': 555,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d1f6931735',
'name': 'General Travel',
'pluralName': 'General Travel',
'shortName': 'Travel',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/travel/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '58fc778d029a555d11deed4e',
'name': 'SHORTS MARKET',
'location': {'address': 'Glorietta',
'lat': 14.551773,
'lng': 121.025185,
'labeledLatLngs': [{'label': 'display',
'lat': 14.551773,
'lng': 121.025185}],
'distance': 665,
'postalCode': '1200',
'cc': 'PH',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['Glorietta', '1200 Makati', 'Makati City']},
'categories': [{'id': '5032781d91d4c4b30a586d5b',
'name': 'Tailor Shop',
'pluralName': 'Tailor Shops',
'shortName': 'Tailor',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/apparel_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '584ab0aafd27167306302816',
'name': 'Gourmand Market',
'location': {'lat': 14.55676,
'lng': 121.02403,
'labeledLatLngs': [{'label': 'display',
'lat': 14.55676,
'lng': 121.02403}],
'distance': 664,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '52e81612bcbc57f1066b79f1',
'name': 'Bistro',
'pluralName': 'Bistros',
'shortName': 'Bistro',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '4cc9117dbcb1b1f7ba1d0d8a',
'name': 'Market Philippines, Inc @philam tower',
'location': {'lat': 14.5579445,
'lng': 121.021609,
'labeledLatLngs': [{'label': 'display',
'lat': 14.5579445,
'lng': 121.021609}],
'distance': 950,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d130941735',
'name': 'Building',
'pluralName': 'Buildings',
'shortName': 'Building',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/building/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '4d8a81da7d4c548106f86a71',
'name': 'Kalayaan Talipapa Market',
'location': {'address': 'Kalayaan Ave, Brgy Pitogo',
'lat': 14.55849696026866,
'lng': 121.04568894400221,
'labeledLatLngs': [{'label': 'display',
'lat': 14.55849696026866,
'lng': 121.04568894400221}],
'distance': 1719,
'postalCode': '1212',
'cc': 'PH',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['Kalayaan Ave, Brgy Pitogo',
'1212 Makati City',
'Makati City']},
'categories': [{'id': '4bf58dd8d48988d1fa941735',
'name': 'Farmers Market',
'pluralName': 'Farmers Markets',
'shortName': "Farmer's Market",
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/food_farmersmarket_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '5fe5f0d3333e68133b1c9d82',
'name': 'Savemore Market A Venue',
'location': {'address': 'G/F A. Venue',
'crossStreet': 'Makati Ave',
'lat': 14.566021,
'lng': 121.029344,
'labeledLatLngs': [{'label': 'display',
'lat': 14.566021,
'lng': 121.029344}],
'distance': 1178,
'postalCode': '1210',
'cc': 'PH',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['G/F A. Venue (Makati Ave)',
'1210 Makati City',
'Makati City']},
'categories': [{'id': '52f2ab2ebcbc57f1066b8b46',
'name': 'Supermarket',
'pluralName': 'Supermarkets',
'shortName': 'Supermarket',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/food_grocery_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '52c168c211d29d0db83aad64',
'name': 'the market place',
'location': {'lat': 14.558335917574018,
'lng': 121.03632924105843,
'labeledLatLngs': [{'label': 'display',
'lat': 14.558335917574018,
'lng': 121.03632924105843}],
'distance': 749,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '50be8ee891d4fa8dcc7199a7',
'name': 'Market',
'pluralName': 'Markets',
'shortName': 'Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/market_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '54b65817498ed34f848586c3',
'name': 'Market Street',
'location': {'address': 'Lower Ground Floor, SM Makati',
'lat': 14.54984800324141,
'lng': 121.02621677244427,
'labeledLatLngs': [{'label': 'display',
'lat': 14.54984800324141,
'lng': 121.02621677244427}],
'distance': 748,
'cc': 'PH',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['Lower Ground Floor, SM Makati',
'Makati City',
'Makati City']},
'categories': [{'id': '4bf58dd8d48988d1c7941735',
'name': 'Snack Place',
'pluralName': 'Snack Places',
'shortName': 'Snacks',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/snacks_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '5067c00be4b0fbec5705888c',
'name': 'Bel-air Flea Market',
'location': {'lat': 14.560886160184737,
'lng': 121.03532139185177,
'labeledLatLngs': [{'label': 'display',
'lat': 14.560886160184737,
'lng': 121.03532139185177}],
'distance': 829,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d1f7941735',
'name': 'Flea Market',
'pluralName': 'Flea Markets',
'shortName': 'Flea Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/fleamarket_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '4f8d487de4b041ba44b68cd3',
'name': 'Toledo Public Market',
'location': {'address': 'Poblacion, Toledo City',
'lat': 14.560160636901855,
'lng': 121.02356719970703,
'labeledLatLngs': [{'label': 'display',
'lat': 14.560160636901855,
'lng': 121.02356719970703}],
'distance': 872,
'cc': 'PH',
'country': 'Pilipinas',
'formattedAddress': ['Poblacion, Toledo City']},
'categories': [{'id': '4bf58dd8d48988d1f7941735',
'name': 'Flea Market',
'pluralName': 'Flea Markets',
'shortName': 'Flea Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/fleamarket_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '51722cfae4b0182f543bc687',
'name': 'Tita Ope, Salcedo Market',
'location': {'lat': 14.56002,
'lng': 121.02361,
'labeledLatLngs': [{'label': 'display',
'lat': 14.56002,
'lng': 121.02361}],
'distance': 859,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d14d941735',
'name': 'Paella Restaurant',
'pluralName': 'Paella Restaurants',
'shortName': 'Paella',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/paella_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '4c10f9ab5a43d13a62d9174b',
'name': 'SM Savers Market (Pasong Tamo-EDSA)',
'location': {'address': 'Pasong Tamo',
'crossStreet': 'at EDSA',
'lat': 14.548573911206974,
'lng': 121.02608798138822,
'labeledLatLngs': [{'label': 'display',
'lat': 14.548573911206974,
'lng': 121.02608798138822}],
'distance': 876,
'postalCode': '1233',
'cc': 'PH',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['Pasong Tamo (at EDSA)',
'1233 Makati City',
'Makati City']},
'categories': [{'id': '4bf58dd8d48988d1ff941735',
'name': 'Miscellaneous Shop',
'pluralName': 'Miscellaneous Shops',
'shortName': 'Shop',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '4ec4c2fb93adf4e73eb4c2dc',
'name': 'Central Square',
'location': {'address': '5th Ave, Bonifacio High Street Central, Bonifacio Global City',
'crossStreet': 'btwn 5th Ave & 7th Ave',
'lat': 14.551876,
'lng': 121.048425,
'labeledLatLngs': [{'label': 'display',
'lat': 14.551876,
'lng': 121.048425}],
'distance': 2020,
'postalCode': '4216',
'cc': 'PH',
'neighborhood': 'Bonifacio Global City',
'city': 'Taguig City',
'country': 'Pilipinas',
'formattedAddress': ['5th Ave, Bonifacio High Street Central, Bonifacio Global City (btwn 5th Ave & 7th Ave)',
'4216 Taguig City']},
'categories': [{'id': '4bf58dd8d48988d1fd941735',
'name': 'Shopping Mall',
'pluralName': 'Shopping Malls',
'shortName': 'Mall',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/mall_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '5082cd0ae4b03db17654f1a9',
'name': 'SHYLIN - Dampa, Seaside Market',
'location': {'address': 'Macapagal Boulevard, Pasay City',
'lat': 14.56220134023684,
'lng': 121.03032121543248,
'labeledLatLngs': [{'label': 'display',
'lat': 14.56220134023684,
'lng': 121.03032121543248}],
'distance': 751,
'cc': 'PH',
'country': 'Pilipinas',
'formattedAddress': ['Macapagal Boulevard, Pasay City']},
'categories': [{'id': '4bf58dd8d48988d1ce941735',
'name': 'Seafood Restaurant',
'pluralName': 'Seafood Restaurants',
'shortName': 'Seafood',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/seafood_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '4dd52a7222716ea3ce6dfcf2',
'name': 'Francis Market',
'location': {'address': 'Gov. Pascual cor M. H del Pilar',
'lat': 14.556066,
'lng': 121.020876,
'labeledLatLngs': [{'label': 'display',
'lat': 14.556066,
'lng': 121.020876}],
'distance': 990,
'cc': 'PH',
'city': 'Malabon City',
'country': 'Pilipinas',
'formattedAddress': ['Gov. Pascual cor M. H del Pilar', 'Malabon City']},
'categories': [{'id': '4bf58dd8d48988d1f7941735',
'name': 'Flea Market',
'pluralName': 'Flea Markets',
'shortName': 'Flea Market',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/fleamarket_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '52f5aaa311d29d7f2a58cde3',
'name': 'Green Palette Salcedo Market',
'location': {'lat': 14.56010913848877,
'lng': 121.0228500366211,
'labeledLatLngs': [{'label': 'display',
'lat': 14.56010913848877,
'lng': 121.0228500366211}],
'distance': 932,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '52e81612bcbc57f1066b79fb',
'name': 'Himalayan Restaurant',
'pluralName': 'Himalayan Restaurants',
'shortName': 'Himalayan',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '536f5370498e2e4d0701cf65',
'name': 'the grey market records',
'location': {'address': 'UG 38 Alfaro Place',
'crossStreet': 'Leviste St',
'lat': 14.559730109701206,
'lng': 121.02384251524536,
'labeledLatLngs': [{'label': 'display',
'lat': 14.559730109701206,
'lng': 121.02384251524536}],
'distance': 820,
'cc': 'PH',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['UG 38 Alfaro Place (Leviste St)',
'Makati',
'Makati City']},
'categories': [{'id': '4bf58dd8d48988d1e7931735',
'name': 'Jazz Club',
'pluralName': 'Jazz Clubs',
'shortName': 'Jazz Club',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/arts_entertainment/musicvenue_jazzclub_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '4e40c706b61cdcbed358a402',
'name': 'The Market',
'location': {'lat': 14.56126653151421,
'lng': 121.024693669421,
'labeledLatLngs': [{'label': 'display',
'lat': 14.56126653151421,
'lng': 121.024693669421}],
'distance': 866,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d146941735',
'name': 'Deli / Bodega',
'pluralName': 'Delis / Bodegas',
'shortName': 'Deli / Bodega',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/deli_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '50010786e4b0382b9f7c34bd',
'name': 'Picole, Salcedo Market',
'location': {'lat': 14.560147664760052,
'lng': 121.02251537472542,
'labeledLatLngs': [{'label': 'display',
'lat': 14.560147664760052,
'lng': 121.02251537472542}],
'distance': 964,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d1c9941735',
'name': 'Ice Cream Shop',
'pluralName': 'Ice Cream Shops',
'shortName': 'Ice Cream',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/icecream_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '4c29d645783d9c74c0948f6b',
'name': 'SM Supermarket',
'location': {'address': 'LG/F SM City Makati',
'lat': 14.549930778420029,
'lng': 121.02667833923196,
'labeledLatLngs': [{'label': 'display',
'lat': 14.549930778420029,
'lng': 121.02667833923196}],
'distance': 714,
'cc': 'PH',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['LG/F SM City Makati',
'Makati City',
'Makati City']},
'categories': [{'id': '52f2ab2ebcbc57f1066b8b46',
'name': 'Supermarket',
'pluralName': 'Supermarkets',
'shortName': 'Supermarket',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/food_grocery_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '4fced87210813a71e876d873',
'name': 'Buma Seafoods Market and Restaurant',
'location': {'address': '1012 Metropolitan Avenue Corner Sacred Heart Street San Antonio Village',
'lat': 14.564747584176805,
'lng': 121.01468324661255,
'labeledLatLngs': [{'label': 'display',
'lat': 14.564747584176805,
'lng': 121.01468324661255}],
'distance': 1951,
'cc': 'PH',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['1012 Metropolitan Avenue Corner Sacred Heart Street San Antonio Village',
'Makati City',
'Makati City']},
'categories': [{'id': '4bf58dd8d48988d1ce941735',
'name': 'Seafood Restaurant',
'pluralName': 'Seafood Restaurants',
'shortName': 'Seafood',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/seafood_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '51b5e296498e1158adcf481c',
'name': 'Guadalupe Night Market',
'location': {'lat': 14.556419332253212,
'lng': 121.039671880628,
'labeledLatLngs': [{'label': 'display',
'lat': 14.556419332253212,
'lng': 121.039671880628}],
'distance': 1042,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d16e941735',
'name': 'Fast Food Restaurant',
'pluralName': 'Fast Food Restaurants',
'shortName': 'Fast Food',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/fastfood_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '550b6b16498ec8c4599f28c6',
'name': 'MDC 348 Cainta Rublou Market Place',
'location': {'lat': 14.55673,
'lng': 121.020277,
'labeledLatLngs': [{'label': 'display',
'lat': 14.55673,
'lng': 121.020277}],
'distance': 1061,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d10f951735',
'name': 'Pharmacy',
'pluralName': 'Pharmacies',
'shortName': 'Pharmacy',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/shops/pharmacy_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '4e0451121f6e97fbec321ad8',
'name': 'The Munchy Market Office',
'location': {'lat': 14.557537,
'lng': 121.019258,
'labeledLatLngs': [{'label': 'display',
'lat': 14.557537,
'lng': 121.019258}],
'distance': 1184,
'cc': 'PH',
'city': 'Makati City',
'state': 'Makati City',
'country': 'Pilipinas',
'formattedAddress': ['Makati City', 'Makati City']},
'categories': [{'id': '4bf58dd8d48988d124941735',
'name': 'Office',
'pluralName': 'Offices',
'shortName': 'Office',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/building/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '512d957ee4b06f13d30c1389',
'name': 'The Market',
'location': {'lat': 14.561346728789122,
'lng': 121.02194979564153,
'labeledLatLngs': [{'label': 'display',
'lat': 14.561346728789122,
'lng': 121.02194979564153}],
'distance': 1091,
'cc': 'PH',
'country': 'Pilipinas'},
'categories': [{'id': '4bf58dd8d48988d146941735',
'name': 'Deli / Bodega',
'pluralName': 'Delis / Bodegas',
'shortName': 'Deli / Bodega',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/deli_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '5395a74c498e3d1061e70c2f',
'name': 'Market! Market! Jeepney Terminal',
'location': {'address': 'Market! Market!',
'lat': 14.551282191103606,
'lng': 121.05017511619641,
'labeledLatLngs': [{'label': 'display',
'lat': 14.551282191103606,
'lng': 121.05017511619641}],
'distance': 2218,
'cc': 'PH',
'neighborhood': 'Fort Bonifacio',
'country': 'Pilipinas',
'formattedAddress': ['Market! Market!']},
'categories': [{'id': '4bf58dd8d48988d1f6931735',
'name': 'General Travel',
'pluralName': 'General Travel',
'shortName': 'Travel',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/travel/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False},
{'id': '50aa0920e4b0495d7fdcf774',
'name': 'The Stock Market',
'location': {'address': 'Bonifacio Global City',
'lat': 14.560656,
'lng': 121.021085,
'labeledLatLngs': [{'label': 'display',
'lat': 14.560656,
'lng': 121.021085}],
'distance': 1125,
'cc': 'PH',
'country': 'Pilipinas',
'formattedAddress': ['Bonifacio Global City']},
'categories': [{'id': '4bf58dd8d48988d14e941735',
'name': 'American Restaurant',
'pluralName': 'American Restaurants',
'shortName': 'American',
'icon': {'prefix': 'https://ss3.4sqi.net/img/categories_v2/food/default_',
'suffix': '.png'},
'primary': True}],
'referralId': 'v-1612837149',
'hasPerk': False}]}}
In [35]:
# assign relevant part of JSON to venues
venues_5 = results_5['response']['venues']
# tranform venues into a dataframe
df_results_5 = json_normalize(venues_5)
# keep only columns that include venue name, and anything that is associated with location
filtered_columns_5 = ['name', 'categories'] + [col for col in df_results_5.columns if col.startswith('location.')] + ['id']
df_markets_5 = df_results_5.loc[:, filtered_columns_5]
# function that extracts the category of the venue
def get_category_type(row):
try:
categories_list = row['categories']
except:
categories_list = row['venue.categories']
if len(categories_list) == 0:
return None
else:
return categories_list[0]['name']
# filter the category for each row
df_markets_5['categories'] = df_markets_5.apply(get_category_type, axis=1)
# clean column names by keeping only last term
df_markets_5.columns = [column.split('.')[-1] for column in df_markets_5.columns]
df_markets_5
/opt/conda/envs/Python-3.7-main/lib/python3.7/site-packages/ipykernel/__main__.py:5: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead
Out[35]:
| name | categories | lat | lng | labeledLatLngs | distance | cc | country | address | city | state | formattedAddress | crossStreet | postalCode | neighborhood | id | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Wet Market sa M. Ocampo St. | Filipino Restaurant | 14.554268 | 121.012069 | [{'label': 'display', 'lat': 14.554268, 'lng':... | 1941 | PH | Pilipinas | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 50cbc254e4b0d0701e405a55 |
| 1 | Wet market | Flea Market | 14.566698 | 121.012429 | [{'label': 'display', 'lat': 14.5666979, 'lng'... | 2273 | PH | Pilipinas | Pasong tamo | Makati City | Makati City | [Pasong tamo, Makati, Makati City] | NaN | NaN | NaN | 4f1ccb0ae4b0838233838c13 |
| 2 | Washington Wet Market | Miscellaneous Shop | 14.555785 | 121.012060 | [{'label': 'display', 'lat': 14.55578488783984... | 1938 | PH | Pilipinas | Washington street | Makati City | Makati City | [Washington street, Makati, Makati City] | NaN | NaN | NaN | 4d36160ecf67a143aa70af28 |
| 3 | Guadalupe Wet Market | Market | 14.562327 | 121.050198 | [{'label': 'display', 'lat': 14.56232736032689... | 2302 | PH | Pilipinas | Guadalupe | Makati City | Makati City | [Guadalupe, Makati, Makati City] | NaN | NaN | NaN | 50fd2247e4b0d36cb20cddcd |
| 4 | Tejeros Wet and Dry Market | Market | 14.571390 | 121.013296 | [{'label': 'display', 'lat': 14.57139, 'lng': ... | 2530 | PH | Pilipinas | Pasong Tirad St | Makati City | Makati City | [Pasong Tirad St (Aranda St), 1204 Makati City... | Aranda St | 1204 | Tejeros | 5a8b8832838e59787925d296 |
| 5 | Olympia Wet and Dry Market | Market | 14.570688 | 121.020032 | [{'label': 'display', 'lat': 14.570688, 'lng':... | 2009 | PH | Pilipinas | Sacramento St | Makati City | Makati City | [Sacramento St (btwn J P Rizal Ave & Calasanz ... | btwn J P Rizal Ave & Calasanz St | NaN | Olympia | 4f7c32b0e4b0d751c12c0e8a |
| 6 | Ayala-Washington/Market! Market! Jeepney Terminal | General Travel | 14.550111 | 121.030267 | [{'label': 'display', 'lat': 14.55011142197091... | 595 | PH | Pilipinas | McKinley Rd | Makati City | Makati City | [McKinley Rd (at Epifanio de los Santos Ave), ... | at Epifanio de los Santos Ave | NaN | Forbes Park | 4f0638ad9adf79d8740b4301 |
| 7 | The Market | Deli / Bodega | 14.560123 | 121.025043 | [{'label': 'display', 'lat': 14.56012277225073... | 748 | PH | Pilipinas | G/F Tiffany Place, L P Leviste St | Makati City | Makati City | [G/F Tiffany Place, L P Leviste St, 1227 Makat... | NaN | 1227 | NaN | 4ed77521b6346530d05f28a3 |
| 8 | Market Phils | Office | 14.557325 | 121.021975 | [{'label': 'display', 'lat': 14.557325, 'lng':... | 893 | PH | Pilipinas | Philamlife Tower, 8767 Paseo de Roxas | Makati City | Makati City | [Philamlife Tower, 8767 Paseo de Roxas, 1209 M... | NaN | 1209 | NaN | 4d9d1d665c33a35d7efffaa0 |
| 9 | Guordo's World Market | Gourmet Shop | 14.552137 | 121.020998 | [{'label': 'display', 'lat': 14.55213660654024... | 1042 | PH | Pilipinas | Greenbelt 2 | Makati City | Makati City | [Greenbelt 2, Makati City, Makati City] | NaN | NaN | NaN | 4c80dacb47cc224b7752769f |
| 10 | Poblacion Public Market | Flea Market | 14.565184 | 121.033609 | [{'label': 'display', 'lat': 14.56518371405648... | 1148 | PH | Pilipinas | J. D. Villena St. | Makati City | Makati City | [J. D. Villena St. (Poblacion), 1210 Makati Ci... | Poblacion | 1210 | NaN | 4e759be9814ddff25ee5cdf4 |
| 11 | Savana Market | Miscellaneous Shop | 14.566711 | 121.013477 | [{'label': 'display', 'lat': 14.56671056728085... | 2180 | PH | Pilipinas | Vito Cruz Ext cor Metropolitan Ave | Makati City | Makati City | [Vito Cruz Ext cor Metropolitan Ave, 1200 Maka... | NaN | 1200 | NaN | 4cc7c603ee718cfaa5f1b33d |
| 12 | Legazpi Active Park | Park | 14.554145 | 121.016829 | [{'label': 'display', 'lat': 14.55414520918907... | 1431 | PH | Pilipinas | Rada St. | Makati City | Makati City | [Rada St. (btwn Legazpi St. & Gamboa St.), 122... | btwn Legazpi St. & Gamboa St. | 1229 | San Lorenzo | 4b7d409ff964a520c7b42fe3 |
| 13 | Bonifacio Global City (BGC) | Neighborhood | 14.551145 | 121.049029 | [{'label': 'display', 'lat': 14.551145, 'lng':... | 2101 | PH | Pilipinas | NaN | Taguig City | NaN | [1634 Taguig City] | NaN | 1634 | NaN | 4c148d47127f95216ade2425 |
| 14 | Salcedo Community Market | Farmers Market | 14.559990 | 121.023140 | [{'label': 'display', 'lat': 14.55999047714344... | 898 | PH | Pilipinas | Jaime C. Velasquez Park, Tordesillas St, Salce... | Makati City | Makati City | [Jaime C. Velasquez Park, Tordesillas St, Salc... | at L.P. Leviste St | 1226 | Bel-Air | 4bdbafdf3904a59391c54b9e |
| 15 | Organic Farmers Market | Farmers Market | 14.555337 | 121.016210 | [{'label': 'display', 'lat': 14.55533709413697... | 1490 | PH | Pilipinas | Legaspi Village | Makati City | Makati City | [Legaspi Village, Makati City, Makati City] | NaN | NaN | San Lorenzo | 4c79d538566db60c7d7f460e |
| 16 | Market on 5th Avenue | Diner | 14.555566 | 121.048365 | [{'label': 'display', 'lat': 14.55556585620891... | 1973 | PH | Pilipinas | St. Luke's Medical Center, 5th Ave | Taguig City | NaN | [St. Luke's Medical Center, 5th Ave, Taguig City] | NaN | NaN | NaN | 4c4fc8c42a73c9283f7d6ad1 |
| 17 | Mara's Organic Market | Vegetarian / Vegan Restaurant | 14.554242 | 121.014956 | [{'label': 'display', 'lat': 14.554242, 'lng':... | 1631 | PH | Pilipinas | Ground Flr, Gallery Bldg, Amorsolo St | Makati City | Makati City | [Ground Flr, Gallery Bldg, Amorsolo St, Makati... | NaN | NaN | San Lorenzo | 53743c00498ef88c02346809 |
| 18 | Ayala - Market Market Jeepney Terminal | General Travel | 14.550685 | 121.029509 | [{'label': 'display', 'lat': 14.55068456854846... | 534 | PH | Pilipinas | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 4fc8b93ae4b0adae39be9946 |
| 19 | Cooked Food The Market Fresh Rustan's Makati | Café | 14.552486 | 121.026441 | [{'label': 'display', 'lat': 14.552486, 'lng':... | 510 | PH | Pilipinas | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 5517abd0498e91c798991695 |
| 20 | Max's Restaurant | Fried Chicken Joint | 14.561401 | 121.029492 | [{'label': 'display', 'lat': 14.56140060923991... | 664 | PH | Pilipinas | Jupiter St., Bel-Air Village | Makati City | Makati City | [Jupiter St., Bel-Air Village, Makati City, Ma... | NaN | NaN | NaN | 4bb075bef964a52084463ce3 |
| 21 | Polaris Rolling Produce Market | Farmers Market | 14.562583 | 121.030306 | [{'label': 'display', 'lat': 14.562583, 'lng':... | 793 | PH | Pilipinas | Polaris St | Makati City | Makati City | [Polaris St, 1210 Makati City, Makati City] | NaN | 1210 | NaN | 5e916915d2839e0007be497a |
| 22 | The Market at L.P Leviste st | None | 14.559354 | 121.025696 | [{'label': 'display', 'lat': 14.55935389972121... | 638 | PH | Pilipinas | NaN | Makati City | Makati City | [Makati City, Makati City] | NaN | NaN | NaN | 4ddb1a7f45dd588c721a40d0 |
| 23 | Market Market Jeepney Terminal | General Travel | 14.554971 | 121.035176 | [{'label': 'display', 'lat': 14.55497148100153... | 555 | PH | Pilipinas | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 4f8fec5ce4b01d8f6da6bce2 |
| 24 | SHORTS MARKET | Tailor Shop | 14.551773 | 121.025185 | [{'label': 'display', 'lat': 14.551773, 'lng':... | 665 | PH | Pilipinas | Glorietta | Makati City | Makati City | [Glorietta, 1200 Makati, Makati City] | NaN | 1200 | NaN | 58fc778d029a555d11deed4e |
| 25 | Gourmand Market | Bistro | 14.556760 | 121.024030 | [{'label': 'display', 'lat': 14.55676, 'lng': ... | 664 | PH | Pilipinas | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 584ab0aafd27167306302816 |
| 26 | Market Philippines, Inc @philam tower | Building | 14.557944 | 121.021609 | [{'label': 'display', 'lat': 14.5579445, 'lng'... | 950 | PH | Pilipinas | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 4cc9117dbcb1b1f7ba1d0d8a |
| 27 | Kalayaan Talipapa Market | Farmers Market | 14.558497 | 121.045689 | [{'label': 'display', 'lat': 14.55849696026866... | 1719 | PH | Pilipinas | Kalayaan Ave, Brgy Pitogo | Makati City | Makati City | [Kalayaan Ave, Brgy Pitogo, 1212 Makati City, ... | NaN | 1212 | NaN | 4d8a81da7d4c548106f86a71 |
| 28 | Savemore Market A Venue | Supermarket | 14.566021 | 121.029344 | [{'label': 'display', 'lat': 14.566021, 'lng':... | 1178 | PH | Pilipinas | G/F A. Venue | Makati City | Makati City | [G/F A. Venue (Makati Ave), 1210 Makati City, ... | Makati Ave | 1210 | NaN | 5fe5f0d3333e68133b1c9d82 |
| 29 | the market place | Market | 14.558336 | 121.036329 | [{'label': 'display', 'lat': 14.55833591757401... | 749 | PH | Pilipinas | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 52c168c211d29d0db83aad64 |
| 30 | Market Street | Snack Place | 14.549848 | 121.026217 | [{'label': 'display', 'lat': 14.54984800324141... | 748 | PH | Pilipinas | Lower Ground Floor, SM Makati | Makati City | Makati City | [Lower Ground Floor, SM Makati, Makati City, M... | NaN | NaN | NaN | 54b65817498ed34f848586c3 |
| 31 | Bel-air Flea Market | Flea Market | 14.560886 | 121.035321 | [{'label': 'display', 'lat': 14.56088616018473... | 829 | PH | Pilipinas | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 5067c00be4b0fbec5705888c |
| 32 | Toledo Public Market | Flea Market | 14.560161 | 121.023567 | [{'label': 'display', 'lat': 14.56016063690185... | 872 | PH | Pilipinas | Poblacion, Toledo City | NaN | NaN | [Poblacion, Toledo City] | NaN | NaN | NaN | 4f8d487de4b041ba44b68cd3 |
| 33 | Tita Ope, Salcedo Market | Paella Restaurant | 14.560020 | 121.023610 | [{'label': 'display', 'lat': 14.56002, 'lng': ... | 859 | PH | Pilipinas | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 51722cfae4b0182f543bc687 |
| 34 | SM Savers Market (Pasong Tamo-EDSA) | Miscellaneous Shop | 14.548574 | 121.026088 | [{'label': 'display', 'lat': 14.54857391120697... | 876 | PH | Pilipinas | Pasong Tamo | Makati City | Makati City | [Pasong Tamo (at EDSA), 1233 Makati City, Maka... | at EDSA | 1233 | NaN | 4c10f9ab5a43d13a62d9174b |
| 35 | Central Square | Shopping Mall | 14.551876 | 121.048425 | [{'label': 'display', 'lat': 14.551876, 'lng':... | 2020 | PH | Pilipinas | 5th Ave, Bonifacio High Street Central, Bonifa... | Taguig City | NaN | [5th Ave, Bonifacio High Street Central, Bonif... | btwn 5th Ave & 7th Ave | 4216 | Bonifacio Global City | 4ec4c2fb93adf4e73eb4c2dc |
| 36 | SHYLIN - Dampa, Seaside Market | Seafood Restaurant | 14.562201 | 121.030321 | [{'label': 'display', 'lat': 14.56220134023684... | 751 | PH | Pilipinas | Macapagal Boulevard, Pasay City | NaN | NaN | [Macapagal Boulevard, Pasay City] | NaN | NaN | NaN | 5082cd0ae4b03db17654f1a9 |
| 37 | Francis Market | Flea Market | 14.556066 | 121.020876 | [{'label': 'display', 'lat': 14.556066, 'lng':... | 990 | PH | Pilipinas | Gov. Pascual cor M. H del Pilar | Malabon City | NaN | [Gov. Pascual cor M. H del Pilar, Malabon City] | NaN | NaN | NaN | 4dd52a7222716ea3ce6dfcf2 |
| 38 | Green Palette Salcedo Market | Himalayan Restaurant | 14.560109 | 121.022850 | [{'label': 'display', 'lat': 14.56010913848877... | 932 | PH | Pilipinas | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 52f5aaa311d29d7f2a58cde3 |
| 39 | the grey market records | Jazz Club | 14.559730 | 121.023843 | [{'label': 'display', 'lat': 14.55973010970120... | 820 | PH | Pilipinas | UG 38 Alfaro Place | Makati City | Makati City | [UG 38 Alfaro Place (Leviste St), Makati, Maka... | Leviste St | NaN | NaN | 536f5370498e2e4d0701cf65 |
| 40 | The Market | Deli / Bodega | 14.561267 | 121.024694 | [{'label': 'display', 'lat': 14.56126653151421... | 866 | PH | Pilipinas | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 4e40c706b61cdcbed358a402 |
| 41 | Picole, Salcedo Market | Ice Cream Shop | 14.560148 | 121.022515 | [{'label': 'display', 'lat': 14.56014766476005... | 964 | PH | Pilipinas | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 50010786e4b0382b9f7c34bd |
| 42 | SM Supermarket | Supermarket | 14.549931 | 121.026678 | [{'label': 'display', 'lat': 14.54993077842002... | 714 | PH | Pilipinas | LG/F SM City Makati | Makati City | Makati City | [LG/F SM City Makati, Makati City, Makati City] | NaN | NaN | NaN | 4c29d645783d9c74c0948f6b |
| 43 | Buma Seafoods Market and Restaurant | Seafood Restaurant | 14.564748 | 121.014683 | [{'label': 'display', 'lat': 14.56474758417680... | 1951 | PH | Pilipinas | 1012 Metropolitan Avenue Corner Sacred Heart S... | Makati City | Makati City | [1012 Metropolitan Avenue Corner Sacred Heart ... | NaN | NaN | NaN | 4fced87210813a71e876d873 |
| 44 | Guadalupe Night Market | Fast Food Restaurant | 14.556419 | 121.039672 | [{'label': 'display', 'lat': 14.55641933225321... | 1042 | PH | Pilipinas | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 51b5e296498e1158adcf481c |
| 45 | MDC 348 Cainta Rublou Market Place | Pharmacy | 14.556730 | 121.020277 | [{'label': 'display', 'lat': 14.55673, 'lng': ... | 1061 | PH | Pilipinas | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 550b6b16498ec8c4599f28c6 |
| 46 | The Munchy Market Office | Office | 14.557537 | 121.019258 | [{'label': 'display', 'lat': 14.557537, 'lng':... | 1184 | PH | Pilipinas | NaN | Makati City | Makati City | [Makati City, Makati City] | NaN | NaN | NaN | 4e0451121f6e97fbec321ad8 |
| 47 | The Market | Deli / Bodega | 14.561347 | 121.021950 | [{'label': 'display', 'lat': 14.56134672878912... | 1091 | PH | Pilipinas | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 512d957ee4b06f13d30c1389 |
| 48 | Market! Market! Jeepney Terminal | General Travel | 14.551282 | 121.050175 | [{'label': 'display', 'lat': 14.55128219110360... | 2218 | PH | Pilipinas | Market! Market! | NaN | NaN | [Market! Market!] | NaN | NaN | Fort Bonifacio | 5395a74c498e3d1061e70c2f |
| 49 | The Stock Market | American Restaurant | 14.560656 | 121.021085 | [{'label': 'display', 'lat': 14.560656, 'lng':... | 1125 | PH | Pilipinas | Bonifacio Global City | NaN | NaN | [Bonifacio Global City] | NaN | NaN | NaN | 50aa0920e4b0495d7fdcf774 |
In [36]:
# add the wet markets as yellow circle markers
for lat, lng, label in zip(df_markets_5.lat, df_markets_5.lng, df_markets_5.name):
folium.CircleMarker(
[lat, lng],
radius=5,
color='yellow',
popup=label,
fill = True,
fill_color='yellow',
fill_opacity=0.6
).add_to(cluster_map)
# display map
cluster_map
Out[36]:
Make this Notebook Trusted to load map: File -> Trust Notebook
Looking at the map of Cluster 5, I noticed that many of the points plotted were not actually wet markets, as some were night markets or supermarkets. It might be best if the wet market supplier is close to at least one of the villages in the border of the cluster, such as Rockwell Makati which is on the top right corner of the cluster. This is so that the wet market supplier could be near an "entry point" of the delivery route for that group. The nearest points near Rockwell Makati are "Marketplace by Rustans," which is a high end supermarket, and "The Grid Food Market," a high-end food court. Since neither are real wet markets for fresh produce, I would recommend Poblacion Public Market as a wet market supplier for this cluster because it is the next nearest point to Rockwell Makati.
Hopefully, this one has a rating available on Foursquare API.
In [37]:
#check the rating of Poblacion Public Market
venue_id_PPM = '4e759be9814ddff25ee5cdf4' # Poblacion Public Market
url_PPM = 'https://api.foursquare.com/v2/venues/{}?client_id={}&client_secret={}&oauth_token={}&v={}'.format(venue_id_PPM, CLIENT_ID, CLIENT_SECRET,ACCESS_TOKEN, VERSION)
result_PPM = requests.get(url_PPM).json()
try:
print(result_PPM['response']['venue']['rating'])
except:
print('This venue has not been rated yet.')
This venue has not been rated yet.
Again, since this venue has no ratings available, I will base the quality of this market on Google Images again. This was the only image of Poblacion Public Market that I was able to find:
Its interior is actually similar to that of Farmers Market Cubao, so I would assume that the produce in this wet market should be of similar quality too. Therefore, I would recommend Poblacion Public Market as the wet market supplier for Cluster 5.
Conclusion¶
The 45 exclusive villages in Metro Manila were clustered into 6 delivery groups (Clusters 0-5) according to their proximity to each other. The groupings could be seen in the table below:
In [38]:
df_villages
Out[38]:
| Cluster Labels | Village | Latitude | Longitude | |
|---|---|---|---|---|
| 0 | 0 | 53 BENITEZ | 14.614629 | 121.046274 |
| 1 | 4 | ACROPOLIS | 14.605744 | 121.077077 |
| 2 | 4 | ALEXANDRA | 14.580917 | 121.062601 |
| 3 | 5 | APARTMENT RIDGE | 14.556622 | 121.026340 |
| 4 | 1 | AYALA ALABANG | 14.405740 | 121.023723 |
| 5 | 3 | AYALA HEIGHTS | 14.662461 | 121.088204 |
| 6 | 1 | AYALA SOUTHVALE | 14.403211 | 121.011704 |
| 7 | 5 | BEL-AIR | 14.562216 | 121.026759 |
| 8 | 4 | CORINTHIAN GARDENS | 14.595673 | 121.063503 |
| 9 | 4 | CORINTHIAN HILLS | 14.596577 | 121.069272 |
| 10 | 5 | DASMARINAS VILLAGE | 14.540761 | 121.026191 |
| 11 | 0 | EAST GREENHILLS | 14.603023 | 121.046444 |
| 12 | 5 | FORBES PARK | 14.547168 | 121.035516 |
| 13 | 4 | GREENMEADOWS | 14.596545 | 121.076000 |
| 14 | 0 | HORSESHOE VILLAGE | 14.611544 | 121.039971 |
| 15 | 0 | JADE GARDEN | 14.606554 | 121.038915 |
| 16 | 3 | LA VISTA | 14.638572 | 121.126406 |
| 17 | 3 | LOYOLA GRAND VILLAS | 14.649698 | 121.087555 |
| 18 | 5 | MAGALLANES | 14.534482 | 121.015670 |
| 19 | 2 | MCKINLEY HILL | 14.533049 | 121.052429 |
| 20 | 0 | NEW MANILA | 14.612781 | 121.028906 |
| 21 | 0 | NORTHEAST GREENHILLS | 14.603023 | 121.046444 |
| 22 | 0 | NORTH GREENHILLS | 14.605751 | 121.045575 |
| 23 | 4 | RENAISSANCE | 14.581505 | 121.064023 |
| 24 | 5 | ROCKWELL MAKATI | 14.563414 | 121.037956 |
| 25 | 0 | ROCKWELL THE GROVE | 14.598197 | 121.036291 |
| 26 | 0 | ROLLING HILLS | 14.621309 | 121.020882 |
| 27 | 5 | SAN LORENZO | 14.546899 | 121.020945 |
| 28 | 5 | SAN MIGUEL VILLAGE | 14.567265 | 121.025519 |
| 29 | 2 | SERENDRA ONE | 14.550762 | 121.054373 |
| 30 | 2 | SERENDRA TWO | 14.546477 | 121.052850 |
| 31 | 4 | SHINE RESIDENCES | 14.582266 | 121.065124 |
| 32 | 5 | URDANETA | 14.555458 | 121.030044 |
| 33 | 0 | VALENCIA | 14.611590 | 121.035794 |
| 34 | 4 | VALLE VERDE 1 | 14.575406 | 121.070287 |
| 35 | 4 | VALLE VERDE 2 | 14.580798 | 121.074096 |
| 36 | 4 | VALLE VERDE 3 | 14.582520 | 121.069121 |
| 37 | 4 | VALLE VERDE 4 | 14.585873 | 121.069272 |
| 38 | 4 | VALLE VERDE 5 | 14.586926 | 121.073930 |
| 39 | 4 | VALLE VERDE 6 | 14.590828 | 121.076098 |
| 40 | 0 | VIRIDIAN | 14.601819 | 121.052299 |
| 41 | 4 | VV HOMES | 14.582494 | 121.075889 |
| 42 | 4 | WACK-WACK ROAD | 14.587722 | 121.052554 |
| 43 | 0 | WACK-WACK VILLAGE | 14.593470 | 121.042559 |
| 44 | 0 | WEST GREENHILLS | 14.603023 | 121.046444 |
| 45 | 4 | WHITE PLAINS | 14.606339 | 121.073432 |
Using Foursquare API and some additional human knowledge (like knowing the reputation of Farmers Market Cubao with the intended customers), I was able to identify some recommended wet markets where the target market could buy supplies which will be sold to the residents of these exclusive villages. These wet markets are:
- Cluster 0 (West Greenhills, Wack Wack Village, etc.) - Farmers Market Cubao
- Cluster 1 (Ayala Alabang, Ayala Southvale) - Saturday Market on University Ave.
- Cluster 2 (Serendra One, Serendra Two, and Mckinley Hill) - Market! Market! Farmers Market
- Cluster 3 (La Vista, Loyola Grand Villas, and Ayala Heights) - Viaga Public Market, Tumana Public Market, or Taboan Public Market
- Cluster 4 (Corinthian Gardens, Valle Verde 1, etc.) - Farmers Market Cubao
- Cluster 5 (Dasmarinas Village, Forbes Park, etc.) - Poblacion Public Market
I have also concluded through this project that although this kind of data and technology are available for aiding in business decisions, a bulk of the analysis still relies on human experience and intuition. For example, data from Foursquare could show us that certain venues tagged as wet markets would be the most practical choice as suppliers based on their proximity to the generated clusters, but this would not account for the savings a businessman could make by choosing the supplier that allows him to haggle for bulk orders.
At the end of the day, technology is a tool to make decision-making easier, but it can only be optimized by integrating it with real-world human knowledge.