Recently, New York City (NYC) was ranked as the second best city for "Foodies", people who love food, by Wallethub.com. NYC was ranked this high due to the high density of restaurants, first in restaurants per capita, the high quality of the restaurants, and the diversity of the restaurants. On top of this, NYC was ranked 175 out of 180 by affordability. This would make NYC an attractive spot to open a restaurant. The city is known for having good restaurants and customers are already ready to pay high prices. The only problem is the difficulty in opening a succesful restaurant. Seeing this article, someone in New York hopes to open a restaurant but does not know in which borough to open. Most of all the person aims to avoid potential competition but also hopes to pay a small amount for rent and open in a borough where previous restaurants have been succesful.
This project will use Foursquare location data. This will allow for creating datasets that set apart different locations. The datasets will include proximity to other restauraunts. Restaurants in New York City will be separated by each borough. Additinally, a dataset obtained from the United States Census Burea will be used. The amount of money generated by food services and average amount of rent will be extracted from this dataset. Therefore, the final dataset will contain info on number of restaurants, total money grossed from the food industry, and average rent cost for each borough of New York City.
First, data was obtained from the Foursquare API. Thorugh this method, number of restaurants per borough was obtained. In order to normalize this data, restaurants per capita was calculated. Naturally, boroughs with more people will probably have more restaurants. Calculating the per capita values eliminates this bias. Along with this data, a dataframe was created containing the 'median gross rent' and the total accommodation and food services and sales. Once this dataframe was created a decision needed to be made. Therefore, a decision tree was made using algorithms in the sklearn library. This would help guide a potential person opening a restaurant in New York.
The dataframe used to build the decision tree can be seen below. RPC stands for restaurants per capita. TAF stands for total accomodataions and food services sales. MGR stands for mean gross rent.
final = pd.DataFrame(
[(1000*bronx_num_res/1418207, 1.005, 1.176),
(1000*bro_num_res/2559903, 2.453, 1.374),
(1000*man_num_res/1628706, 20.382, 1.682),
(1000*queens_num_res/2253858, 3.139, 1.520),
(1000*staten_num_res/476143, .472, 1.282),
],
index = ['Bronx', 'Brooklyn', 'Manhattan', 'Queens', 'Staten Island'],
columns = ('RPC (for every thousand people)', 'TAF (per billion)', 'MGR (per thousand)')
)
final
RPC (for every thousand people) | TAF (per billion) | MGR (per thousand) | |
---|---|---|---|
Bronx | 0.129741 | 1.005 | 1.176 |
Brooklyn | 0.135552 | 2.453 | 1.374 |
Manhattan | 0.198317 | 20.382 | 1.682 |
Queens | 0.175255 | 3.139 | 1.520 |
Staten Island | 0.142814 | 0.472 | 1.282 |
The decision tree built can be seen below.
dot_data = StringIO()
filename = "boroughtree.png"
featureNames = final.columns[0:3]
targetNames = final.index.unique().tolist()
out=tree.export_graphviz(boroughTree,feature_names=featureNames, out_file=dot_data, class_names= np.unique(y_trainset), filled=True, special_characters=True,rotate=False)
graph = pydotplus.graph_from_dot_data(dot_data.getvalue())
graph.write_png(filename)
img = mpimg.imread(filename)
plt.figure(figsize=(100, 200))
plt.imshow(img,interpolation='nearest')
<matplotlib.image.AxesImage at 0x7f379743ce48>
The decision tree built shows that a person opening a restaurant should consider the potential money they would make before making other decisions. The decision tree shows that this would eliminate the Bronx because the total grossed from the food and services industry in the bronx is below 1.729 billion. This means people may be less likely to spend money at restaurants in the Bronx. This also eliminates Staten Island, which has a less TAF than the Bronx. This leads to the second decision factor, restaurants per capita (RPC). A person who is looking to open with limited competition should choose somwhere with a lower amount pf restaurants. This separates Brooklyn and Manhattan as shown in the decision tree. Based on this decision tree, a potential restaurant owner should open their restaurant in Brooklyn. Not shown on the decision tree is Queens. While Queens does have a high TAF, its RPC is higher than Brooklyn. Therefore, Brooklyn remains the choice for the Borough in which to open a restaurant.
Based on the analysis done above, Brooklyn would be the optimal borough in New York City in which to open a restaurant. Interestingly the machine learning algorithms chose TAF as the variable as the top indicator. This could be due to its values being naturally higher compared to the other data. In further research better attempts at normalizing data could be done to provide a better decision tree.
Importing necessary libraries for data retrieval and cleaning.
import numpy as np
import pandas as pd
pd.set_option('display.max_columns', None)
pd.set_option('display.max_rows', None)
!conda install -c conda-forge geopy --yes
from geopy.geocoders import Nominatim
import json
import requests
from pandas.io.json import json_normalize
from bs4 import BeautifulSoup
Solving environment: done ## Package Plan ## environment location: /opt/conda/envs/Python36 added / updated specs: - geopy The following packages will be downloaded: package | build ---------------------------|----------------- certifi-2020.6.20 | py36h9f0ad1d_0 151 KB conda-forge python_abi-3.6 | 1_cp36m 4 KB conda-forge geopy-2.0.0 | pyh9f0ad1d_0 63 KB conda-forge geographiclib-1.50 | py_0 34 KB conda-forge openssl-1.1.1g | h516909a_1 2.1 MB conda-forge ca-certificates-2020.6.20 | hecda079_0 145 KB conda-forge ------------------------------------------------------------ Total: 2.5 MB The following NEW packages will be INSTALLED: geographiclib: 1.50-py_0 conda-forge geopy: 2.0.0-pyh9f0ad1d_0 conda-forge python_abi: 3.6-1_cp36m conda-forge The following packages will be UPDATED: certifi: 2020.6.20-py36_0 --> 2020.6.20-py36h9f0ad1d_0 conda-forge openssl: 1.1.1g-h7b6447c_0 --> 1.1.1g-h516909a_1 conda-forge The following packages will be DOWNGRADED: ca-certificates: 2020.6.24-0 --> 2020.6.20-hecda079_0 conda-forge Downloading and Extracting Packages certifi-2020.6.20 | 151 KB | ##################################### | 100% python_abi-3.6 | 4 KB | ##################################### | 100% geopy-2.0.0 | 63 KB | ##################################### | 100% geographiclib-1.50 | 34 KB | ##################################### | 100% openssl-1.1.1g | 2.1 MB | ##################################### | 100% ca-certificates-2020 | 145 KB | ##################################### | 100% Preparing transaction: done Verifying transaction: done Executing transaction: done Solving environment: done ## Package Plan ## environment location: /opt/conda/envs/Python36 added / updated specs: - folium=0.5.0 The following packages will be downloaded: package | build ---------------------------|----------------- branca-0.4.1 | py_0 26 KB conda-forge altair-4.1.0 | py_1 614 KB conda-forge folium-0.5.0 | py_0 45 KB conda-forge vincent-0.4.4 | py_1 28 KB conda-forge ------------------------------------------------------------ Total: 713 KB The following NEW packages will be INSTALLED: altair: 4.1.0-py_1 conda-forge branca: 0.4.1-py_0 conda-forge folium: 0.5.0-py_0 conda-forge vincent: 0.4.4-py_1 conda-forge Downloading and Extracting Packages branca-0.4.1 | 26 KB | ##################################### | 100% altair-4.1.0 | 614 KB | ##################################### | 100% folium-0.5.0 | 45 KB | ##################################### | 100% vincent-0.4.4 | 28 KB | ##################################### | 100% Preparing transaction: done Verifying transaction: done Executing transaction: done
Download data
!wget -q -O 'newyork_data.json' https://cocl.us/new_york_dataset
with open('newyork_data.json') as json_data:
newyork_data = json.load(json_data)
Create dataframe based on the different Boroughs
boroughs_data = newyork_data['features']
column_names = ['Borough', 'Latitude','Longitude']
boroughs = pd.DataFrame(columns=column_names)
for data in boroughs_data:
borough = data['properties']['borough']
coor = data['geometry']['coordinates']
lat = coor[1]
lng = coor[0]
boroughs = boroughs.append({'Borough': borough, 'Latitude': lat, 'Longitude': lng}, ignore_index = True)
Credentials needed to use Foursquare API data.
CLIENT_ID = '****'
CLIENT_SECRET = '*****'
VERSION = '20200818'
address = 'New York City, NY'
geolocator = Nominatim(user_agent = "ny_explorer")
location = geolocator.geocode(address)
latitude = location.latitude
longitude = location.longitude
Create function for finding types of venues from Foursquare API.
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']
Separate the Bronx location data
bronx_data = boroughs[boroughs['Borough'] == 'Bronx'].reset_index(drop = True)
Find all venues in the Bronx
rad = 500
bronx_venues = pd.DataFrame()
for i, row in bronx_data.iterrows():
lat = bronx_data.loc[i, 'Latitude']
lng = bronx_data.loc[i, 'Longitude']
url = 'https://api.foursquare.com/v2/venues/explore?&client_id={}&client_secret={}&v={}&ll={},{}&radius={}'.format(
CLIENT_ID,
CLIENT_SECRET,
VERSION,
lat,
lng,
rad)
url
result = requests.get(url).json()
venues = result['response']['groups'][0]['items']
nearby_venues = json_normalize(venues)
filtered_columns = ['venue.name', 'venue.categories', 'venue.location.lat', 'venue.location.lng']
nearby_venues = nearby_venues.loc[:, filtered_columns]
nearby_venues['venue.categories'] = nearby_venues.apply(get_category_type, axis=1)
nearby_venues.columns = [col.split(".")[-1] for col in nearby_venues.columns]
for k, vals in nearby_venues.iterrows():
venue_row = pd.Series(vals.values)
bronx_venues = bronx_venues.append(venue_row, ignore_index = True)
Filter out all of the venues that aren't restaurants or are fast food restaurants.
bronx_venues.rename(columns = {0: "Name", 1: "Category", 2: "Latitude", 3: "Longitude"}, inplace = True)
bronx_restaurants = bronx_venues[bronx_venues['Category'].str.contains('Restaurant')]
bronx_restaurants = bronx_restaurants[bronx_restaurants['Category'] != 'Fast Food Restaurant']
bronx_restaurants
Name | Category | Latitude | Longitude | |
---|---|---|---|---|
17 | Townhouse Restaurant | Restaurant | 40.876086 | -73.828868 |
25 | Fish & Ting | Caribbean Restaurant | 40.885656 | -73.829197 |
28 | Dyre Fish Market | Seafood Restaurant | 40.889318 | -73.831453 |
30 | Golden Krust Caribbean Restaurant | Caribbean Restaurant | 40.888488 | -73.831083 |
33 | Royal Caribbean Bakery | Caribbean Restaurant | 40.888249 | -73.831661 |
64 | Leche y Miel | Latin American Restaurant | 40.883742 | -73.901857 |
66 | El Malecon | Caribbean Restaurant | 40.879338 | -73.904457 |
72 | El Economico Restaurant | Spanish Restaurant | 40.879330 | -73.904597 |
74 | Estrellita Poblana V | Mexican Restaurant | 40.879687 | -73.906257 |
77 | Picante Picante Mexican Restaurant | Mexican Restaurant | 40.878252 | -73.902936 |
78 | Q'Kachapa | Spanish Restaurant | 40.880006 | -73.904157 |
83 | Chipotle Mexican Grill | Mexican Restaurant | 40.884566 | -73.900474 |
95 | Patrizia's Of Woodlawn | Italian Restaurant | 40.900638 | -73.867724 |
96 | Curry Spot | Indian Restaurant | 40.897625 | -73.867147 |
124 | Queen of Tacos | Mexican Restaurant | 40.880200 | -73.883434 |
126 | V.I.P.'S Cafe | Restaurant | 40.881566 | -73.879299 |
130 | Golden Krust Caribbean Restaurant | Caribbean Restaurant | 40.881672 | -73.878996 |
135 | El Presidente II | Spanish Restaurant | 40.880516 | -73.883233 |
141 | Ming Liang Kitchen | Chinese Restaurant | 40.879876 | -73.876629 |
144 | Pine Deli | American Restaurant | 40.880340 | -73.883142 |
151 | The Dumplin Shop | Caribbean Restaurant | 40.884143 | -73.856449 |
153 | Caridad & Louie | Spanish Restaurant | 40.865843 | -73.837707 |
162 | Moe's Southwest Grill | Mexican Restaurant | 40.866310 | -73.830320 |
175 | Mr. Q's Chinese Restaurant | Chinese Restaurant | 40.855790 | -73.855455 |
176 | Enzo's | Italian Restaurant | 40.854232 | -73.854362 |
181 | Kiraku Hibachi & Sushi | Sushi Restaurant | 40.853356 | -73.853629 |
184 | Pasta Pasta | Italian Restaurant | 40.854788 | -73.854929 |
198 | Artie's Steak and Seafood | Italian Restaurant | 40.849542 | -73.787317 |
200 | Bistro SK | French Restaurant | 40.846387 | -73.786262 |
201 | Black Whale | American Restaurant | 40.846398 | -73.786438 |
202 | Crab Shanty | Seafood Restaurant | 40.848807 | -73.787211 |
204 | Seafood City | Seafood Restaurant | 40.850967 | -73.789778 |
218 | Rays Cafe Resturant | Spanish Restaurant | 40.843999 | -73.785581 |
226 | Jolly Tinker | Italian Restaurant | 40.867451 | -73.883536 |
231 | OK Mr. Pancho | Mexican Restaurant | 40.867343 | -73.883963 |
232 | Las Maravillas De Mexico | Mexican Restaurant | 40.873135 | -73.889019 |
241 | Hung Hing Chinese Restaurant | Chinese Restaurant | 40.871181 | -73.886759 |
242 | Choi Yuan - Chinese Restaurant | Chinese Restaurant | 40.873078 | -73.889086 |
245 | La Rola Resturant | Spanish Restaurant | 40.866037 | -73.886206 |
249 | New Xing Wang Chinese Restaurant | Chinese Restaurant | 40.868875 | -73.889355 |
250 | El Sabor Latino | Mexican Restaurant | 40.872834 | -73.889263 |
253 | Accra Resturant | African Restaurant | 40.853871 | -73.908421 |
261 | Liberato | Latin American Restaurant | 40.853744 | -73.907966 |
273 | NO.1 restaurant | Chinese Restaurant | 40.852104 | -73.909615 |
276 | Yoly Restaurant | Spanish Restaurant | 40.846042 | -73.919716 |
285 | 188 Bakery Cuchifritos | Latin American Restaurant | 40.861602 | -73.898311 |
293 | Kasike Mofongo House | Spanish Restaurant | 40.859929 | -73.893177 |
297 | Panda Express | Chinese Restaurant | 40.863001 | -73.900894 |
304 | Papaye Restaurant | African Restaurant | 40.857407 | -73.899738 |
315 | El Nuevo Bohio | Paella Restaurant | 40.843956 | -73.888025 |
329 | El Valle Restaurant | Restaurant | 40.844964 | -73.889647 |
344 | Food Hai | Chinese Restaurant | 40.840579 | -73.879480 |
354 | Hong Kong | Chinese Restaurant | 40.840809 | -73.873352 |
355 | El Salvadoreño, bar & restaurante | Latin American Restaurant | 40.840689 | -73.872961 |
369 | Happy Garden | Asian Restaurant | 40.836523 | -73.927094 |
377 | wah yong | Chinese Restaurant | 40.838211 | -73.924789 |
378 | Justine Restaurant | Latin American Restaurant | 40.835502 | -73.921439 |
383 | Dong King | Chinese Restaurant | 40.833692 | -73.927466 |
385 | Boca Chica Seafood Restaurant | Seafood Restaurant | 40.835083 | -73.921665 |
386 | La Fuente Restaurant | Spanish Restaurant | 40.833662 | -73.929257 |
388 | El Caldero Restaurant & Sports Bar | Latin American Restaurant | 40.837514 | -73.920771 |
389 | China Wang | Chinese Restaurant | 40.841026 | -73.925262 |
399 | Cinco de Mayo | Mexican Restaurant | 40.822674 | -73.911592 |
420 | Pio Pio | Peruvian Restaurant | 40.806047 | -73.914185 |
434 | Picanteria El Botecito | Spanish Restaurant | 40.803577 | -73.919289 |
436 | Rincon Ecuatoriano | Latin American Restaurant | 40.803759 | -73.911875 |
437 | Carmen And Cindy's | Spanish Restaurant | 40.803215 | -73.912361 |
441 | Pio Pio | Peruvian Restaurant | 40.806047 | -73.914185 |
444 | Carmen And Cindy's | Spanish Restaurant | 40.803215 | -73.912361 |
446 | Walnut Bus Stop | Restaurant | 40.800516 | -73.910598 |
447 | Rincon Ecuatoriano | Latin American Restaurant | 40.803759 | -73.911875 |
454 | El Valle Restaurant | Latin American Restaurant | 40.816113 | -73.896310 |
462 | Randall Restaurant | Spanish Restaurant | 40.812151 | -73.884431 |
465 | City Tamale Inc | Mexican Restaurant | 40.810160 | -73.884653 |
467 | Lobster Place | Seafood Restaurant | 40.811527 | -73.884888 |
485 | Fish N Chips | Seafood Restaurant | 40.822777 | -73.902543 |
490 | Chinese Restaurant | Chinese Restaurant | 40.822529 | -73.896584 |
493 | Crown Fried Chicken | American Restaurant | 40.821294 | -73.897207 |
501 | Golden City Chinese Restaurant | Chinese Restaurant | 40.821435 | -73.866371 |
502 | Kee Hing Restaurant | Chinese Restaurant | 40.822141 | -73.867700 |
510 | Don Leo | Latin American Restaurant | 40.818336 | -73.862740 |
512 | King Dragon Restaurant | Chinese Restaurant | 40.816890 | -73.865470 |
523 | Maravilla's Bar and Grill | South American Restaurant | 40.810872 | -73.855370 |
524 | Muscle Maker Grill | American Restaurant | 40.819391 | -73.817298 |
526 | Green Dragon | Asian Restaurant | 40.818878 | -73.816793 |
528 | Tosca Marquee | Italian Restaurant | 40.819222 | -73.817601 |
532 | Hawaii Chinese Kitchen | Chinese Restaurant | 40.818697 | -73.817371 |
540 | Taqueria Tlaxcali | Mexican Restaurant | 40.836098 | -73.854948 |
543 | Neerob | Asian Restaurant | 40.836111 | -73.854902 |
544 | Ellie's Diner | American Restaurant | 40.837880 | -73.860132 |
547 | Golden Krust Caribbean Restaurant | Caribbean Restaurant | 40.836174 | -73.861013 |
550 | Sabor Latino Seafood Restaurant | Chinese Restaurant | 40.836366 | -73.853034 |
556 | Evo cocktail lounge & restaurant | Restaurant | 40.834377 | -73.853599 |
568 | Applebee's Grill + Bar | American Restaurant | 40.837572 | -73.860832 |
569 | Dynasty Chinese Restaurant | Asian Restaurant | 40.836048 | -73.859978 |
570 | Estrellita Poblana IV | Mexican Restaurant | 40.842072 | -73.844044 |
571 | El Bohio Tropical Restaurant | Latin American Restaurant | 40.840607 | -73.843177 |
582 | Kai Asian Fusion | Asian Restaurant | 40.843591 | -73.845589 |
598 | Caridad Restaurant | Spanish Restaurant | 40.842923 | -73.845052 |
605 | Arth Aljanathain | Middle Eastern Restaurant | 40.847338 | -73.866632 |
620 | Patricia's | Italian Restaurant | 40.849313 | -73.853536 |
626 | La Masa | Arepa Restaurant | 40.848039 | -73.856182 |
643 | Tino's Delicatessen | Italian Restaurant | 40.855882 | -73.887166 |
652 | Arthur Avenue Fiasco | Italian Restaurant | 40.854844 | -73.887908 |
659 | Michaelangelo's Coal Fired Brick Oven Pizza Re... | Italian Restaurant | 40.857412 | -73.886468 |
660 | Calabria Pork Store | Italian Restaurant | 40.854145 | -73.888776 |
662 | Enzo's | Italian Restaurant | 40.854355 | -73.888644 |
664 | Antonio's Trattoria | Italian Restaurant | 40.854083 | -73.886616 |
666 | Emilia's Restaurant | Italian Restaurant | 40.854120 | -73.888910 |
667 | Dominick's Restaurant | Italian Restaurant | 40.854215 | -73.888765 |
670 | Tra Di Noi | Italian Restaurant | 40.855140 | -73.886794 |
675 | Siam Square | Thai Restaurant | 40.878796 | -73.916701 |
687 | Madison's | Italian Restaurant | 40.906483 | -73.903965 |
688 | Carlos & Gabby's - Riverdale | Mexican Restaurant | 40.906566 | -73.904397 |
690 | Tokyo House | Sushi Restaurant | 40.905672 | -73.904309 |
697 | Beccofino | Italian Restaurant | 40.905467 | -73.900423 |
700 | New China | Chinese Restaurant | 40.905181 | -73.901078 |
703 | Golden Phoenix Chinese Restaurant | Chinese Restaurant | 40.905689 | -73.904298 |
712 | Lucca Italian Restaurant | Italian Restaurant | 40.847676 | -73.831834 |
713 | Giovanni's Italian Restaurant | Italian Restaurant | 40.851786 | -73.829786 |
715 | Mexico Magico Restaurant | Mexican Restaurant | 40.846655 | -73.832072 |
716 | Shangri-La | Asian Restaurant | 40.847160 | -73.832642 |
719 | Honey's Thai Pavilion | Thai Restaurant | 40.847845 | -73.831320 |
725 | Villa Barone Ristorante | Italian Restaurant | 40.853225 | -73.827305 |
739 | Cabo | Mexican Restaurant | 40.825960 | -73.821352 |
741 | Legendary Bar and Restaurant | American Restaurant | 40.830862 | -73.826386 |
744 | Taqueria Lupita | Mexican Restaurant | 40.829203 | -73.826892 |
754 | Louis Seafood | Italian Restaurant | 40.830604 | -73.827933 |
755 | Muscle Maker Grill | American Restaurant | 40.819391 | -73.817298 |
759 | Green Dragon | Asian Restaurant | 40.818878 | -73.816793 |
760 | Patricia's of Tremont | Italian Restaurant | 40.823119 | -73.819403 |
764 | Tosca Marquee | Italian Restaurant | 40.819222 | -73.817601 |
766 | Spoto's Italian Restaurant | Italian Restaurant | 40.820399 | -73.817702 |
767 | Rino's Italian Restaurant | Italian Restaurant | 40.821231 | -73.818743 |
772 | IKKO Hibachi Sushi Asian Bistro | Japanese Restaurant | 40.821156 | -73.818528 |
783 | Feroza's Roti Shop | Caribbean Restaurant | 40.871445 | -73.866562 |
785 | Richie Rich | Caribbean Restaurant | 40.871496 | -73.864424 |
787 | Fratelli's | Italian Restaurant | 40.863019 | -73.843607 |
790 | Caridad & Louie | Spanish Restaurant | 40.865843 | -73.837707 |
796 | C&C Coffee Shop & Deli | Spanish Restaurant | 40.862128 | -73.843276 |
799 | Yummy House | Chinese Restaurant | 40.862490 | -73.843079 |
806 | Pelham Bay Diner | American Restaurant | 40.865375 | -73.837246 |
808 | El Gran Valle Restaurant | Spanish Restaurant | 40.833175 | -73.914476 |
809 | Lucky House Chinese Restaurant | Chinese Restaurant | 40.833933 | -73.916674 |
813 | Tiny's Pizza & Pasta | Italian Restaurant | 40.830930 | -73.916626 |
814 | Concourse Jamaican Bakery | Caribbean Restaurant | 40.833523 | -73.914824 |
835 | Brisas Del Caribe Restaurant | Latin American Restaurant | 40.832128 | -73.851270 |
836 | Havana Café | Spanish Restaurant | 40.833195 | -73.851417 |
838 | Jimmy's Grand Cafe | Comfort Food Restaurant | 40.827651 | -73.850271 |
839 | Sabrosura | Latin American Restaurant | 40.831936 | -73.851019 |
843 | Jenny's Roti Shop | Caribbean Restaurant | 40.833876 | -73.851235 |
845 | Marisco Centro Seafood Resaurant | Seafood Restaurant | 40.831440 | -73.850593 |
849 | Melanies Roti Bar And Grill | Indian Restaurant | 40.833293 | -73.851040 |
862 | Golden Krust Caribbean Restaurant | Caribbean Restaurant | 40.831559 | -73.900226 |
869 | Empire King Chinese Food | Chinese Restaurant | 40.832317 | -73.898087 |
873 | Sing Sing Kitchen | Chinese Restaurant | 40.830333 | -73.901401 |
875 | Xing Long Restaurant | Chinese Restaurant | 40.832576 | -73.903958 |
882 | Porto Salvo | Italian Restaurant | 40.823887 | -73.912910 |
884 | Chipotle Mexican Grill | Mexican Restaurant | 40.825890 | -73.919534 |
891 | Hungry Bird | Indian Restaurant | 40.828820 | -73.916828 |
892 | Cinco de Mayo | Mexican Restaurant | 40.822674 | -73.911592 |
909 | Saki Yaki Japan | Japanese Restaurant | 40.825111 | -73.920280 |
914 | Yoly Restaurant | Spanish Restaurant | 40.846042 | -73.919716 |
934 | D Angies Resturant | Latin American Restaurant | 40.843689 | -73.912659 |
945 | El Nuevo Valle | Spanish Restaurant | 40.848664 | -73.911218 |
952 | Happy Land Chinese Restaurant Buffet | Chinese Restaurant | 40.853161 | -73.907532 |
955 | F & J Pine Tavern | Italian Restaurant | 40.848766 | -73.862242 |
957 | El Acatlan | Mexican Restaurant | 40.854260 | -73.866223 |
958 | Peking Kitchen | Chinese Restaurant | 40.854260 | -73.866223 |
961 | Cafe Colonial | Spanish Restaurant | 40.852495 | -73.867654 |
962 | Burektorja Dukagjini | Eastern European Restaurant | 40.854480 | -73.865412 |
963 | Panda restaurant | Chinese Restaurant | 40.854651 | -73.864156 |
982 | Chef King | Chinese Restaurant | 40.865690 | -73.856632 |
990 | Internacional Restaurant & Deli | Spanish Restaurant | 40.862232 | -73.857430 |
994 | New Happy Garden | Chinese Restaurant | 40.861789 | -73.857329 |
996 | La Caridad | Latin American Restaurant | 40.869219 | -73.903219 |
997 | Lucky Star Chinese Restaurant | Chinese Restaurant | 40.869648 | -73.903508 |
999 | Cơm Tấm Ninh Kiều | Vietnamese Restaurant | 40.866956 | -73.897839 |
1002 | Montezuma Mexican Restaurant | Mexican Restaurant | 40.868588 | -73.902104 |
1011 | KBBQ | Korean Restaurant | 40.868843 | -73.901956 |
1013 | Yu Hua Restaurant | Chinese Restaurant | 40.868366 | -73.900742 |
1021 | King's Farm | Restaurant | 40.867558 | -73.898933 |
1024 | New Yung Hong Chinese Restaurant | Chinese Restaurant | 40.873272 | -73.905128 |
1025 | Caridad Spanish Restaurant | Spanish Restaurant | 40.871832 | -73.906700 |
manhattan_data = boroughs[boroughs['Borough'] == 'Manhattan'].reset_index(drop = True)
rad = 500
manhattan_venues = pd.DataFrame()
for i, row in manhattan_data.iterrows():
lat = manhattan_data.loc[i, 'Latitude']
lng = manhattan_data.loc[i, 'Longitude']
url = 'https://api.foursquare.com/v2/venues/explore?&client_id={}&client_secret={}&v={}&ll={},{}&radius={}'.format(
CLIENT_ID,
CLIENT_SECRET,
VERSION,
lat,
lng,
rad)
url
result = requests.get(url).json()
venues = result['response']['groups'][0]['items']
nearby_venues = json_normalize(venues)
filtered_columns = ['venue.name', 'venue.categories', 'venue.location.lat', 'venue.location.lng']
nearby_venues = nearby_venues.loc[:, filtered_columns]
nearby_venues['venue.categories'] = nearby_venues.apply(get_category_type, axis=1)
nearby_venues.columns = [col.split(".")[-1] for col in nearby_venues.columns]
for k, vals in nearby_venues.iterrows():
venue_row = pd.Series(vals.values)
manhattan_venues = manhattan_venues.append(venue_row, ignore_index = True)
manhattan_venues.rename(columns = {0: "Name", 1: "Category", 2: "Latitude", 3: "Longitude"}, inplace = True)
manhattan_restaurants = manhattan_venues[manhattan_venues['Category'].str.contains('Restaurant')]
manhattan_restaurants = manhattan_restaurants[manhattan_restaurants['Category'] != 'Fast Food Restaurant']
manhattan_restaurants
Name | Category | Latitude | Longitude | |
---|---|---|---|---|
13 | Land & Sea Restaurant | Seafood Restaurant | 40.877885 | -73.905873 |
27 | Kiki's | Greek Restaurant | 40.714476 | -73.992036 |
29 | Spicy Village | Chinese Restaurant | 40.717010 | -73.993530 |
32 | Wah Fung Number 1 Fast Food 華豐快餐店 | Chinese Restaurant | 40.717278 | -73.994177 |
34 | Xi'an Famous Foods | Chinese Restaurant | 40.715232 | -73.997263 |
36 | Dimes | American Restaurant | 40.714830 | -73.991719 |
37 | Da Yu Hot Pot 大渝火锅 | Hotpot Restaurant | 40.716735 | -73.995752 |
38 | Forgtmenot | New American Restaurant | 40.714459 | -73.991546 |
43 | Cervo's | Spanish Restaurant | 40.714763 | -73.991455 |
48 | Happy Lamb Hot Pot, Manhattan | Hotpot Restaurant | 40.717639 | -73.995187 |
49 | Ling Kee | Asian Restaurant | 40.714713 | -73.991538 |
55 | The Uptown Garrison | Restaurant | 40.851255 | -73.939473 |
56 | Tampopo Ramen | Ramen Restaurant | 40.850693 | -73.936568 |
58 | Saggio Restaurant | Italian Restaurant | 40.851423 | -73.939761 |
68 | 181 Cabrini | New American Restaurant | 40.851251 | -73.940343 |
74 | The Pandering Pig | American Restaurant | 40.855226 | -73.937793 |
75 | Las Tapas | Tapas Restaurant | 40.855234 | -73.937284 |
79 | La Casa del Mofongo | Caribbean Restaurant | 40.850267 | -73.933145 |
80 | Kismat Indian Restaurant | Indian Restaurant | 40.855222 | -73.936967 |
82 | La Cabana Salvadorena | Latin American Restaurant | 40.854334 | -73.933677 |
83 | Terravita | New American Restaurant | 40.848059 | -73.937645 |
87 | Guadalupe Bar and Grill | Mexican Restaurant | 40.867334 | -73.920863 |
94 | fantastic lounge | Latin American Restaurant | 40.866297 | -73.919626 |
96 | The Tubby Hook | American Restaurant | 40.867816 | -73.920739 |
98 | Inwood Bar and Grill | Restaurant | 40.867044 | -73.922570 |
105 | Genesis Autentica Comida Ecuatoriana | Restaurant | 40.865498 | -73.919842 |
108 | La Reina Del Chicharron | Spanish Restaurant | 40.866357 | -73.925012 |
109 | Pick & Eat | American Restaurant | 40.867614 | -73.921253 |
110 | Made in Mexico | Mexican Restaurant | 40.867275 | -73.917090 |
112 | Guacamole | Mexican Restaurant | 40.869659 | -73.916736 |
117 | Fumo | Italian Restaurant | 40.821412 | -73.950499 |
121 | Oso | Mexican Restaurant | 40.821945 | -73.950038 |
122 | Wat’s On Your Plate | Caribbean Restaurant | 40.825632 | -73.948494 |
125 | Geisha Japanese Cuisine | Japanese Restaurant | 40.824355 | -73.951993 |
128 | Frijolito's | Mexican Restaurant | 40.823413 | -73.952278 |
129 | Trufa | Mediterranean Restaurant | 40.823084 | -73.952952 |
133 | One Stop Patty Shop | Caribbean Restaurant | 40.825014 | -73.947721 |
141 | La Nueva Flor de Broadway | Latin American Restaurant | 40.821896 | -73.953782 |
143 | Chopped Parsley | Sushi Restaurant | 40.825911 | -73.947454 |
144 | Jin Ramen | Ramen Restaurant | 40.815406 | -73.958547 |
147 | Go! Go! Curry! | Japanese Curry Restaurant | 40.815473 | -73.958234 |
153 | Pisticci Ristorante | Italian Restaurant | 40.814015 | -73.960266 |
156 | Chapati House - NYC | Indian Restaurant | 40.814572 | -73.959154 |
158 | El Porton | Mexican Restaurant | 40.814399 | -73.959330 |
160 | El Puerto Seafood and Fish Market | Seafood Restaurant | 40.813861 | -73.956737 |
161 | Bettolona | Italian Restaurant | 40.814084 | -73.959574 |
162 | La Salle Dumpling Room | Dumpling Restaurant | 40.814060 | -73.959701 |
165 | Toast 125 | American Restaurant | 40.814860 | -73.959400 |
166 | Chinelos | Mexican Restaurant | 40.820190 | -73.953769 |
168 | Falafel on Broadway | Falafel Restaurant | 40.814438 | -73.959251 |
169 | Sushi Sushi | Sushi Restaurant | 40.818550 | -73.952731 |
171 | Mofongo del Valle | Spanish Restaurant | 40.820317 | -73.954977 |
172 | Seafood Restaurant | Seafood Restaurant | 40.814053 | -73.956039 |
173 | Harlem's Floridita | Cuban Restaurant | 40.817998 | -73.960982 |
176 | Belle Harlem | American Restaurant | 40.816890 | -73.942680 |
178 | Yatenga | French Restaurant | 40.814306 | -73.944430 |
180 | Abyssinia Restaurant | Ethiopian Restaurant | 40.816308 | -73.946054 |
181 | Ponty Bistro Harlem | African Restaurant | 40.817886 | -73.941522 |
187 | Keur Sokhna | African Restaurant | 40.813556 | -73.945001 |
188 | Renaissance Harlem | French Restaurant | 40.813414 | -73.944984 |
191 | Crispy Bamboo Village | Chinese Restaurant | 40.816278 | -73.946938 |
196 | The Edge Harlem | American Restaurant | 40.819692 | -73.946073 |
198 | 88 Chinese Restaurant | Chinese Restaurant | 40.813187 | -73.941467 |
205 | Alison | New American Restaurant | 40.790971 | -73.947016 |
206 | Cascolate Latin Bistro | Mexican Restaurant | 40.792787 | -73.940830 |
207 | Malii | Thai Restaurant | 40.789525 | -73.943232 |
208 | El Chevere Cuchifritos | Latin American Restaurant | 40.793994 | -73.942971 |
212 | Amor Cubano | Cuban Restaurant | 40.794829 | -73.942536 |
214 | Lupita's Restaurant | Mexican Restaurant | 40.790159 | -73.942930 |
215 | Mountain Bird | French Restaurant | 40.793851 | -73.939942 |
217 | Bangklyn East Harlem | Thai Restaurant | 40.790287 | -73.943054 |
220 | Cafe Ollin | Mexican Restaurant | 40.791066 | -73.939595 |
222 | El Caribeno | Spanish Restaurant | 40.791550 | -73.946723 |
224 | El Aguila | Mexican Restaurant | 40.790464 | -73.947602 |
226 | Lechonera El Barrio | Latin American Restaurant | 40.789868 | -73.946527 |
227 | Brisas Del Mar | Seafood Restaurant | 40.795171 | -73.944249 |
232 | Ranch Market | Restaurant | 40.794385 | -73.949010 |
233 | Absolute Thai Restaurant | Thai Restaurant | 40.789202 | -73.948440 |
235 | Sant Ambroeus | Italian Restaurant | 40.775328 | -73.962819 |
243 | The Mark Restaurant by Jean-Georges | American Restaurant | 40.775219 | -73.963381 |
248 | Café Boulud | French Restaurant | 40.774460 | -73.963893 |
251 | Flex Mussels | Seafood Restaurant | 40.776337 | -73.956430 |
253 | Eli's Table | American Restaurant | 40.775043 | -73.956808 |
254 | Antonucci | Italian Restaurant | 40.775711 | -73.956607 |
257 | Toloache 82 | Mexican Restaurant | 40.776566 | -73.956642 |
260 | Sistina | Italian Restaurant | 40.777597 | -73.961685 |
263 | Sushi Noz | Sushi Restaurant | 40.773786 | -73.958118 |
273 | Peng's Noodle Folk | Asian Restaurant | 40.777258 | -73.949110 |
275 | Nica Trattoria | Italian Restaurant | 40.775688 | -73.950570 |
280 | Poke Restaurant | Sushi Restaurant | 40.776508 | -73.950548 |
282 | Felice 83 | Italian Restaurant | 40.774867 | -73.950868 |
285 | PuTawn Local Thai Kitchen | Thai Restaurant | 40.774599 | -73.951042 |
288 | Pho Shop | Vietnamese Restaurant | 40.778669 | -73.948111 |
293 | Luna Rossa | Italian Restaurant | 40.776544 | -73.950326 |
294 | Mission Ceviche | Restaurant | 40.769218 | -73.957901 |
295 | Up Thai | Thai Restaurant | 40.769898 | -73.957598 |
303 | Bohemian Spirit Restaurant | Czech Restaurant | 40.769114 | -73.956539 |
311 | THEP Thai Restaurant | Thai Restaurant | 40.770743 | -73.957060 |
312 | Afghan Kebab House II | Afghan Restaurant | 40.768021 | -73.959157 |
314 | Kome Waza UES | Japanese Restaurant | 40.765602 | -73.957403 |
315 | Persepolis | Middle Eastern Restaurant | 40.769772 | -73.957616 |
319 | A La Turka | Turkish Restaurant | 40.770128 | -73.957435 |
320 | Shanghai | Chinese Restaurant | 40.768334 | -73.958493 |
324 | NISI | Greek Restaurant | 40.761915 | -73.949966 |
336 | Fuji East | Japanese Restaurant | 40.758966 | -73.952441 |
340 | Bread and Butter Market | Restaurant | 40.763136 | -73.948859 |
346 | Bikur Cholim Room | Kosher Restaurant | 40.764137 | -73.953153 |
354 | Jacob's Pickles | Southern / Soul Food Restaurant | 40.786653 | -73.975622 |
356 | Maison Pickle | American Restaurant | 40.786990 | -73.977787 |
357 | Eléa | Greek Restaurant | 40.787531 | -73.976681 |
358 | Han Dynasty | Chinese Restaurant | 40.787620 | -73.976359 |
359 | Celeste | Italian Restaurant | 40.786689 | -73.975737 |
363 | The Mermaid Inn | Seafood Restaurant | 40.788744 | -73.974243 |
364 | Mokum | Mediterranean Restaurant | 40.785355 | -73.976810 |
365 | Flor de Mayo | Peruvian Restaurant | 40.785966 | -73.976312 |
366 | Pizzeria Sirenetta | Italian Restaurant | 40.788640 | -73.974282 |
370 | Fred's Restaurant | American Restaurant | 40.785658 | -73.976539 |
371 | Peacefood Cafe | Vegetarian / Vegan Restaurant | 40.785166 | -73.977064 |
376 | Jin Ramen | Ramen Restaurant | 40.785261 | -73.976839 |
377 | Alachi Masala | Indian Restaurant | 40.786166 | -73.976414 |
379 | Gazala's | Middle Eastern Restaurant | 40.784575 | -73.977055 |
380 | Land Thai Kitchen | Thai Restaurant | 40.784868 | -73.977122 |
383 | Luke's Lobster | Seafood Restaurant | 40.784147 | -73.977656 |
411 | Rosa Mexicano | Mexican Restaurant | 40.771183 | -73.983325 |
412 | The Smith | American Restaurant | 40.771505 | -73.982292 |
415 | Pio Pio | Peruvian Restaurant | 40.760636 | -73.994714 |
421 | Mémé Mediterranean | Mediterranean Restaurant | 40.760905 | -73.994601 |
436 | Chez Josephine | French Restaurant | 40.758747 | -73.993397 |
450 | Gabriel Kreuther | French Restaurant | 40.754143 | -73.983505 |
451 | Sophie's Cuban Cuisine | Cuban Restaurant | 40.755927 | -73.980598 |
453 | CAVA | Mediterranean Restaurant | 40.754186 | -73.981913 |
459 | Málà Project | Szechuan Restaurant | 40.756850 | -73.980855 |
475 | Kajitsu | Japanese Restaurant | 40.749763 | -73.977688 |
477 | Sons of Thunder | Hawaiian Restaurant | 40.747970 | -73.975751 |
480 | Little Alley | Shanghai Restaurant | 40.747326 | -73.977016 |
481 | Wine:34 | Mediterranean Restaurant | 40.746558 | -73.980060 |
482 | Sarge's Delicatessen & Diner | Jewish Restaurant | 40.747264 | -73.977058 |
483 | Franchia | Vegetarian / Vegan Restaurant | 40.747549 | -73.981124 |
484 | Sushi Ryusei | Sushi Restaurant | 40.748354 | -73.975203 |
495 | Momosan Ramen & Sake | Ramen Restaurant | 40.749953 | -73.977184 |
496 | Rossinis | Italian Restaurant | 40.749056 | -73.979029 |
499 | The Pho 5 | Vietnamese Restaurant | 40.748838 | -73.976211 |
506 | Dil-e Punjab Deli | Indian Restaurant | 40.744845 | -74.002528 |
510 | Blossom Restaurant | Vegetarian / Vegan Restaurant | 40.745394 | -74.002106 |
511 | TAO Downtown | Asian Restaurant | 40.742539 | -74.003812 |
513 | Le Grainne Cafe | French Restaurant | 40.745372 | -74.002337 |
514 | Buddakan | Chinese Restaurant | 40.742120 | -74.004612 |
515 | The Meatball Shop | Italian Restaurant | 40.745988 | -74.001686 |
516 | Mojo Sushi | Sushi Restaurant | 40.744895 | -74.002700 |
520 | Cookshop | American Restaurant | 40.745731 | -74.005596 |
522 | Worthwild | New American Restaurant | 40.744450 | -74.003204 |
527 | Cull & Pistol | Seafood Restaurant | 40.742598 | -74.006078 |
529 | Los Mariscos | Seafood Restaurant | 40.742000 | -74.005890 |
534 | Carbone | Italian Restaurant | 40.727903 | -74.000136 |
537 | DomoDomo | Sushi Restaurant | 40.728007 | -74.001683 |
541 | Raoul's Restaurant | French Restaurant | 40.726224 | -74.002093 |
544 | Miss Lily's & Melvin's Juice Box | Caribbean Restaurant | 40.727916 | -74.001423 |
546 | Coco Pazzo Kitchen & Restaurant | Italian Restaurant | 40.726036 | -74.001507 |
550 | Tomoe Sushi | Sushi Restaurant | 40.727743 | -74.000267 |
553 | Pepe Rosso To Go | Italian Restaurant | 40.727226 | -74.001595 |
555 | Lupa | Italian Restaurant | 40.727577 | -74.000095 |
556 | Song' e Napule Pizzeria | Italian Restaurant | 40.728044 | -74.001814 |
559 | Raku | Udon Restaurant | 40.727404 | -74.002696 |
563 | Blue Ribbon Sushi | Sushi Restaurant | 40.726167 | -74.002607 |
564 | Kura | Japanese Restaurant | 40.726803 | -73.983444 |
566 | Cafe Mogador | Moroccan Restaurant | 40.727277 | -73.984505 |
568 | Smør | Scandinavian Restaurant | 40.729295 | -73.981521 |
570 | Thursday Kitchen | Korean Restaurant | 40.727661 | -73.983761 |
571 | Westville East | American Restaurant | 40.728428 | -73.981894 |
578 | Xe Máy Sandwich Shop | Vietnamese Restaurant | 40.727435 | -73.984835 |
579 | Mokyo | Korean Restaurant | 40.727179 | -73.984056 |
581 | Hanoi House | Vietnamese Restaurant | 40.726905 | -73.983603 |
584 | Raclette | Swiss Restaurant | 40.728836 | -73.980778 |
590 | Miss Lily's 7A | Caribbean Restaurant | 40.726058 | -73.983686 |
596 | Pig and Khao | Filipino Restaurant | 40.719275 | -73.984891 |
598 | Zyara Restaurant & Cafe | Mediterranean Restaurant | 40.719541 | -73.984832 |
599 | Speedy Romeo LES | Italian Restaurant | 40.719455 | -73.984915 |
600 | Kings County Imperial | Chinese Restaurant | 40.717817 | -73.985569 |
601 | Windmill | French Restaurant | 40.719845 | -73.984680 |
602 | Ginger & Lemongrass | Vietnamese Restaurant | 40.719289 | -73.985630 |
611 | Yopparai | Japanese Restaurant | 40.719284 | -73.985663 |
612 | Azasu | Japanese Restaurant | 40.719628 | -73.984803 |
617 | Balvanera | Argentinian Restaurant | 40.720547 | -73.985399 |
619 | Ivan Ramen | Ramen Restaurant | 40.720554 | -73.984429 |
621 | Taco Mix | Mexican Restaurant | 40.717969 | -73.985941 |
622 | Nakamura | Ramen Restaurant | 40.717711 | -73.985170 |
626 | Locanda Verde | Italian Restaurant | 40.719981 | -74.010002 |
633 | Sushi Azabu | Sushi Restaurant | 40.722355 | -74.009750 |
634 | Smith & Mills | American Restaurant | 40.720089 | -74.009876 |
641 | Bubby's | American Restaurant | 40.719932 | -74.008572 |
643 | Yves | New American Restaurant | 40.720202 | -74.010157 |
647 | The Greek | Greek Restaurant | 40.723694 | -74.009598 |
648 | Tamarind TriBeCa | Indian Restaurant | 40.719211 | -74.008727 |
651 | juice press | Vegetarian / Vegan Restaurant | 40.722048 | -74.009743 |
652 | Estancia 460 | Argentinian Restaurant | 40.723761 | -74.009572 |
659 | Despaña | Spanish Restaurant | 40.721144 | -73.997963 |
661 | Yi Ji Shi Mo Noodle Corp | Chinese Restaurant | 40.718254 | -73.995930 |
667 | Thai Diner | Thai Restaurant | 40.720739 | -73.995631 |
677 | Le Coucou | French Restaurant | 40.719114 | -74.000202 |
682 | Gelso & Grand | Italian Restaurant | 40.719580 | -73.997340 |
692 | Le Botaniste | Vegetarian / Vegan Restaurant | 40.720545 | -74.000138 |
701 | Antique Garage | Mediterranean Restaurant | 40.721418 | -74.001343 |
710 | Despaña | Spanish Restaurant | 40.721144 | -73.997963 |
713 | Osteria Morini | Italian Restaurant | 40.721990 | -73.997790 |
714 | L'Artusi | Italian Restaurant | 40.733888 | -74.005114 |
715 | I Sodi | Italian Restaurant | 40.733348 | -74.004947 |
721 | Mémé Mediterranean | Mediterranean Restaurant | 40.736350 | -74.005880 |
726 | RedFarm | Chinese Restaurant | 40.734194 | -74.006268 |
728 | Westville West | American Restaurant | 40.734055 | -74.004279 |
733 | Wallsé | Austrian Restaurant | 40.735495 | -74.008257 |
735 | Fiaschetteria Pistoia | Italian Restaurant | 40.733203 | -74.005426 |
736 | Buvette | French Restaurant | 40.732782 | -74.004275 |
739 | The Little Owl | American Restaurant | 40.732441 | -74.005424 |
740 | Red Paper Clip | New American Restaurant | 40.733105 | -74.005617 |
741 | Via Carota | Italian Restaurant | 40.733052 | -74.003573 |
744 | Saiguette | Vietnamese Restaurant | 40.799209 | -73.962780 |
746 | Osteria 106 | Italian Restaurant | 40.798825 | -73.961793 |
751 | Chipotle Mexican Grill | Mexican Restaurant | 40.794923 | -73.965789 |
754 | Mokja | Korean Restaurant | 40.797707 | -73.967789 |
755 | Makana Hawaiian & Japanese BBQ | Hawaiian Restaurant | 40.800284 | -73.965389 |
757 | Doaba Deli | Indian Restaurant | 40.799513 | -73.962663 |
765 | Thai Market | Thai Restaurant | 40.801270 | -73.965141 |
768 | Awash | Ethiopian Restaurant | 40.800762 | -73.965495 |
772 | Calle Ocho | Latin American Restaurant | 40.800881 | -73.967761 |
773 | Casa Mexicana | Mexican Restaurant | 40.798813 | -73.966877 |
784 | Dos Toros Taqueria | Mexican Restaurant | 40.806545 | -73.965269 |
786 | Dig Inn | American Restaurant | 40.805561 | -73.965348 |
790 | Community Food & Juice | American Restaurant | 40.805823 | -73.965483 |
792 | Shaking Crab | Seafood Restaurant | 40.805145 | -73.966037 |
793 | Symposium | Greek Restaurant | 40.805610 | -73.964242 |
798 | Friedman's | American Restaurant | 40.808332 | -73.959943 |
816 | Taqueria Gramercy | Mexican Restaurant | 40.736218 | -73.985011 |
818 | Mi Noodle Bar | Thai Restaurant | 40.737714 | -73.981393 |
823 | Hane Sushi | Sushi Restaurant | 40.734902 | -73.979847 |
828 | Bluebell Cafe | American Restaurant | 40.738443 | -73.983184 |
829 | Grill 21 | Filipino Restaurant | 40.735743 | -73.979860 |
833 | Simon & The Whale | American Restaurant | 40.739662 | -73.984450 |
847 | Dig Inn | American Restaurant | 40.712062 | -74.015161 |
865 | Manhatta | New American Restaurant | 40.707654 | -74.009138 |
876 | The Capital Grille | American Restaurant | 40.707903 | -74.010086 |
880 | Taim | Falafel Restaurant | 40.707727 | -74.008265 |
881 | Crown Shy | Restaurant | 40.706187 | -74.007490 |
884 | Luke's Lobster | Seafood Restaurant | 40.704488 | -74.010915 |
885 | La Parisienne | French Restaurant | 40.709423 | -74.009992 |
888 | CAVA | Mediterranean Restaurant | 40.705912 | -74.008787 |
905 | Sfoglia | Italian Restaurant | 40.783419 | -73.952768 |
909 | Lex Restaurant | Italian Restaurant | 40.782530 | -73.953700 |
911 | Dig Inn | American Restaurant | 40.780332 | -73.954728 |
914 | Table d'Hote | French Restaurant | 40.784492 | -73.955712 |
916 | Paola's Restaurant | Restaurant | 40.784655 | -73.955869 |
921 | Korali Estiatorio | Mediterranean Restaurant | 40.783298 | -73.950777 |
929 | Le French Diner | French Restaurant | 40.722114 | -73.988130 |
930 | Sweet Chick | Southern / Soul Food Restaurant | 40.721764 | -73.987480 |
934 | Lil' Frankie's | Italian Restaurant | 40.723445 | -73.988328 |
937 | Lucien | French Restaurant | 40.723329 | -73.988071 |
942 | Cafe Himalaya | Himalayan Restaurant | 40.722923 | -73.988293 |
945 | Blue Ribbon Sushi Izakaya | Sushi Restaurant | 40.722063 | -73.988205 |
951 | Uchu | Sushi Restaurant | 40.721722 | -73.990156 |
953 | El Diablito Taqueria | Mexican Restaurant | 40.725229 | -73.989042 |
954 | Atera | Molecular Gastronomy Restaurant | 40.716752 | -74.005712 |
956 | Nish Nūsh | Falafel Restaurant | 40.715537 | -74.007725 |
961 | Racines | French Restaurant | 40.714754 | -74.007581 |
963 | Takahachi | Sushi Restaurant | 40.716526 | -74.008101 |
964 | Sophie's Cuban Cuisine | Cuban Restaurant | 40.714803 | -74.007656 |
973 | The Odeon | French Restaurant | 40.717010 | -74.008042 |
976 | Two Hands Restaurant & Bar | Australian Restaurant | 40.717937 | -74.005695 |
977 | Tiny's and the Bar Upstairs | American Restaurant | 40.716793 | -74.008220 |
982 | Khe-Yo | Asian Restaurant | 40.716753 | -74.008584 |
984 | Jongro BBQ | Korean Restaurant | 40.747574 | -73.987043 |
990 | L'Amico | Italian Restaurant | 40.747096 | -73.989805 |
994 | Samwon Garden BBQ | Korean Restaurant | 40.748010 | -73.987280 |
1001 | Woorijip | Korean Restaurant | 40.747623 | -73.986372 |
1002 | Izakaya MEW | Japanese Restaurant | 40.750145 | -73.986390 |
1005 | Pocha 32 | Korean Restaurant | 40.747635 | -73.986487 |
1009 | BCD Tofu House | Korean Restaurant | 40.747362 | -73.985663 |
1012 | New Wonjo | Korean Restaurant | 40.747800 | -73.986847 |
1019 | Felidia | Italian Restaurant | 40.760267 | -73.965277 |
1022 | Bistro Vendome | French Restaurant | 40.759115 | -73.961698 |
1026 | Neary's | Restaurant | 40.758461 | -73.963400 |
1034 | Luscious Thai | Thai Restaurant | 40.760480 | -73.961627 |
1036 | Anassa Taverna | Mediterranean Restaurant | 40.762099 | -73.965964 |
1040 | Under The Bridge | Greek Restaurant | 40.759577 | -73.961969 |
1041 | Scalinatella | Italian Restaurant | 40.762761 | -73.965566 |
1043 | amata | Italian Restaurant | 40.759236 | -73.967515 |
1045 | KaoruMC | Sushi Restaurant | 40.752109 | -73.969877 |
1050 | Sip Sak | Turkish Restaurant | 40.754517 | -73.968842 |
1058 | Ethos | Greek Restaurant | 40.754526 | -73.966048 |
1059 | Deux Amis | French Restaurant | 40.754648 | -73.966044 |
1061 | The Smith | American Restaurant | 40.755376 | -73.968243 |
1065 | Angeletto | Italian Restaurant | 40.753371 | -73.969718 |
1066 | Crave Fishbar | Seafood Restaurant | 40.755026 | -73.968576 |
1069 | La Pecora Bianca | Italian Restaurant | 40.755116 | -73.968509 |
1073 | Aburiya Kinnosuke | Japanese Restaurant | 40.752550 | -73.972551 |
1078 | Sai Gon Dep | Vietnamese Restaurant | 40.747701 | -73.973788 |
1081 | El Pote | Spanish Restaurant | 40.747618 | -73.973874 |
1085 | Pescatore Seafood | Seafood Restaurant | 40.749559 | -73.970781 |
1088 | Sushi Ryusei | Sushi Restaurant | 40.748354 | -73.975203 |
1089 | Sons of Thunder | Hawaiian Restaurant | 40.747970 | -73.975751 |
1092 | Tempura Matsui | Japanese Restaurant | 40.748461 | -73.974974 |
1093 | Lan Larb Midtown | Thai Restaurant | 40.745334 | -73.975528 |
1095 | El Parador | Mexican Restaurant | 40.744439 | -73.974780 |
1098 | Baby Bo's Cantina | Mexican Restaurant | 40.745048 | -73.975748 |
1099 | EONS Greek Food for Life | Greek Restaurant | 40.745208 | -73.975651 |
1100 | Maison Thai | Thai Restaurant | 40.744969 | -73.975770 |
1103 | Montagu's Gusto | American Restaurant | 40.745558 | -73.975226 |
1127 | HALL | Japanese Restaurant | 40.740260 | -73.992324 |
1129 | Thai Villa | Thai Restaurant | 40.739118 | -73.990579 |
1131 | Sugarfish | Japanese Restaurant | 40.738951 | -73.988955 |
1133 | OOTOYA 大戸屋 (OOTOYA) | Japanese Restaurant | 40.738836 | -73.992777 |
1139 | abcV | Vegetarian / Vegan Restaurant | 40.738182 | -73.989210 |
1140 | Rezdôra | Italian Restaurant | 40.738941 | -73.988862 |
1141 | Mari Vanna | Russian Restaurant | 40.738771 | -73.988683 |
1143 | Gramercy Tavern | American Restaurant | 40.738600 | -73.988320 |
1145 | Nana Thai Street | Thai Restaurant | 40.739568 | -73.988513 |
1147 | ABC Cocina | Mexican Restaurant | 40.738193 | -73.989321 |
1148 | Giorgio's of Gramercy | New American Restaurant | 40.739609 | -73.988762 |
1149 | Dig Inn | American Restaurant | 40.740698 | -73.988315 |
1151 | Boqueria | Tapas Restaurant | 40.740200 | -73.993770 |
1154 | Friedman's | American Restaurant | 40.755271 | -73.998509 |
1162 | Chef's Table At Brooklyn Fare | American Restaurant | 40.756024 | -73.996366 |
1168 | Legacy Records | American Restaurant | 40.757565 | -73.998111 |
1177 | Sergimmo Salumeria | Italian Restaurant | 40.754388 | -73.995642 |
1181 | Farida | Caucasian Restaurant | 40.755722 | -73.994627 |
queens_data = boroughs[boroughs['Borough'] == 'Queens'].reset_index(drop = True)
rad = 500
queens_venues = pd.DataFrame()
for i, row in queens_data.iterrows():
lat = queens_data.loc[i, 'Latitude']
lng = queens_data.loc[i, 'Longitude']
url = 'https://api.foursquare.com/v2/venues/explore?&client_id={}&client_secret={}&v={}&ll={},{}&radius={}'.format(
CLIENT_ID,
CLIENT_SECRET,
VERSION,
lat,
lng,
rad)
url
result = requests.get(url).json()
venues = result['response']['groups'][0]['items']
nearby_venues = json_normalize(venues)
filtered_columns = ['venue.name', 'venue.categories', 'venue.location.lat', 'venue.location.lng']
nearby_venues = nearby_venues.loc[:, filtered_columns]
nearby_venues['venue.categories'] = nearby_venues.apply(get_category_type, axis=1)
nearby_venues.columns = [col.split(".")[-1] for col in nearby_venues.columns]
for k, vals in nearby_venues.iterrows():
venue_row = pd.Series(vals.values)
queens_venues = queens_venues.append(venue_row, ignore_index = True)
queens_venues.rename(columns = {0: "Name", 1: "Category", 2: "Latitude", 3: "Longitude"}, inplace = True)
queens_restaurants = queens_venues[queens_venues['Category'].str.contains('Restaurant')]
queens_restaurants = queens_restaurants[queens_restaurants['Category'] != 'Fast Food Restaurant']
queens_restaurants
Name | Category | Latitude | Longitude | |
---|---|---|---|---|
0 | Favela Grill | Brazilian Restaurant | 40.767348 | -73.917897 |
5 | Off The Hook | Seafood Restaurant | 40.767200 | -73.918104 |
6 | Al-sham Sweets and Pastries | Middle Eastern Restaurant | 40.768077 | -73.911561 |
10 | The Gully | Indian Restaurant | 40.766719 | -73.912410 |
11 | Sabry's | Seafood Restaurant | 40.768446 | -73.911267 |
12 | AbuQir Seafood | Seafood Restaurant | 40.768577 | -73.911169 |
13 | Duzan | Falafel Restaurant | 40.768730 | -73.911013 |
14 | SVL Bar | Greek Restaurant | 40.769816 | -73.918530 |
15 | Zyara Restaurant | Restaurant | 40.766591 | -73.912713 |
17 | El Cafetal | Mexican Restaurant | 40.770153 | -73.918214 |
21 | Seva Indian Cuisine | Indian Restaurant | 40.765521 | -73.919157 |
24 | Ovelia Psistaria Bar | Greek Restaurant | 40.765779 | -73.918890 |
25 | Jujube Tree | Vegetarian / Vegan Restaurant | 40.765309 | -73.918162 |
27 | Viva Viva | Mexican Restaurant | 40.765441 | -73.918768 |
30 | SriPraPhai | Thai Restaurant | 40.746342 | -73.899248 |
33 | Casa Del Chef Bistro | American Restaurant | 40.746174 | -73.899942 |
34 | Izalco | Latin American Restaurant | 40.746060 | -73.899753 |
36 | Thailand's Center Point | Thai Restaurant | 40.746531 | -73.900247 |
41 | Sweet Basil Thai | Thai Restaurant | 40.746484 | -73.903033 |
42 | Tropical Restaurant | Latin American Restaurant | 40.746155 | -73.897281 |
44 | Peking BBQ Chicken | Chinese Restaurant | 40.745488 | -73.906053 |
46 | Matsuri | Japanese Restaurant | 40.745626 | -73.903387 |
47 | Cafe Con Amor | American Restaurant | 40.746039 | -73.899441 |
48 | Woodside Cafe | American Restaurant | 40.744957 | -73.904179 |
50 | House of Inasal | Filipino Restaurant | 40.745986 | -73.898449 |
56 | La Abundancia | Arepa Restaurant | 40.749863 | -73.898791 |
60 | Oceanic Boil | Cajun / Creole Restaurant | 40.749952 | -73.881903 |
62 | Pollos a la Brasa Mario | Latin American Restaurant | 40.749806 | -73.883243 |
63 | El Chivito D' Oro | South American Restaurant | 40.749833 | -73.882376 |
64 | La Nueva Bakery | South American Restaurant | 40.750134 | -73.880227 |
65 | Sompong Thai | Thai Restaurant | 40.749507 | -73.883323 |
66 | La Picada Azuaya | Spanish Restaurant | 40.750140 | -73.881775 |
67 | Las Margaritas | Latin American Restaurant | 40.749886 | -73.882553 |
68 | Urubamba | Peruvian Restaurant | 40.750109 | -73.879710 |
74 | Uncle Peter's | Italian Restaurant | 40.755786 | -73.883810 |
75 | Pio Pio | Peruvian Restaurant | 40.755705 | -73.883145 |
76 | La Pollera Colorada II | Latin American Restaurant | 40.755704 | -73.884871 |
77 | Don Alex Restaurant | Peruvian Restaurant | 40.749882 | -73.882121 |
79 | Tomo Japanese Cuisine | Sushi Restaurant | 40.750169 | -73.880150 |
81 | Black Thai | Thai Restaurant | 40.755465 | -73.885675 |
83 | Mama's Empanadas | Empanada Restaurant | 40.755999 | -73.882393 |
84 | Pio Pio to Go | Peruvian Restaurant | 40.755988 | -73.882747 |
86 | La Cabaña | Argentinian Restaurant | 40.756065 | -73.881306 |
87 | Tacos Mi Mexico Lindo | Mexican Restaurant | 40.747677 | -73.882399 |
89 | Mama's Empanadas | Empanada Restaurant | 40.755880 | -73.882904 |
90 | Eim Khao Mun Kai Elmhurst อิ่ม ข้าวมันไก่เอ็มเ... | Thai Restaurant | 40.743014 | -73.883057 |
91 | Lamoon | Thai Restaurant | 40.742850 | -73.882913 |
92 | La Fusta | Argentinian Restaurant | 40.744701 | -73.884615 |
94 | Taste Good Malaysian Cuisine 好味 | Malay Restaurant | 40.741663 | -73.882177 |
95 | Akino | Sushi Restaurant | 40.741226 | -73.881261 |
96 | Five Loaves and Two Fishes | Chinese Restaurant | 40.741339 | -73.881330 |
97 | JoJu | Vietnamese Restaurant | 40.740689 | -73.879389 |
99 | Dek Sen | Thai Restaurant | 40.741753 | -73.878696 |
100 | Lao Bei Fang | Chinese Restaurant | 40.741078 | -73.879996 |
101 | Paet Rio | Thai Restaurant | 40.743281 | -73.883525 |
102 | Chao Thai ร้านชาวไทย | Thai Restaurant | 40.741416 | -73.880102 |
104 | Sky Cafe | Indonesian Restaurant | 40.741999 | -73.878626 |
105 | Genesis Mexican Authentic Cuisine | Mexican Restaurant | 40.743633 | -73.886846 |
106 | Tacos Mi Mexico Lindo | Mexican Restaurant | 40.747677 | -73.882399 |
107 | Hug Esan NYC | Thai Restaurant | 40.743640 | -73.887392 |
108 | Pho Bac | Vietnamese Restaurant | 40.741283 | -73.881301 |
111 | Pollos a la Brasa Mario | South American Restaurant | 40.747659 | -73.884806 |
112 | La Esquina Del Camaron Mexicano | Mexican Restaurant | 40.747325 | -73.885722 |
113 | La Pequeña Colombia | Colombian Restaurant | 40.747992 | -73.882145 |
115 | Lenny's Clam Bar | Seafood Restaurant | 40.655749 | -73.839004 |
116 | Brothers Ravioli | Italian Restaurant | 40.655282 | -73.838991 |
117 | Prima Pasta & Cafe | Italian Restaurant | 40.654385 | -73.839093 |
121 | Frenasia | Sushi Restaurant | 40.651400 | -73.837462 |
124 | Saffron Tapas Restaurant | Tapas Restaurant | 40.654229 | -73.838977 |
126 | Chipotle Mexican Grill | Mexican Restaurant | 40.657287 | -73.839812 |
127 | Roma View Catering | Italian Restaurant | 40.657220 | -73.839092 |
131 | Hagane | Japanese Restaurant | 40.655786 | -73.839108 |
138 | Empire Buffet | Chinese Restaurant | 40.654483 | -73.838343 |
144 | East Meets West | Chinese Restaurant | 40.654899 | -73.839303 |
146 | Park Side | Italian Restaurant | 40.743670 | -73.855844 |
148 | Empanadas Cafe | Empanada Restaurant | 40.740120 | -73.853310 |
149 | Cienega Las Tlayudas de Oaxaca Mexican Cuisine | Mexican Restaurant | 40.743722 | -73.857661 |
151 | Mi Cocina | Mexican Restaurant | 40.743655 | -73.856106 |
152 | El Palacio De Las Empanadas | South American Restaurant | 40.742674 | -73.854700 |
154 | Don Alex Restaurant | Restaurant | 40.743599 | -73.856304 |
161 | Chuang Chef Chinese Restaurant | Chinese Restaurant | 40.740486 | -73.853294 |
166 | Bangkok Cuisine | Thai Restaurant | 40.721062 | -73.845432 |
167 | Great Wall Chinese Restaurant | Chinese Restaurant | 40.723596 | -73.847968 |
168 | Tu Casa Restaurant | Peruvian Restaurant | 40.724682 | -73.850005 |
175 | MoCA Asian Bistro | Asian Restaurant | 40.720983 | -73.845436 |
190 | Numero 28 | Italian Restaurant | 40.720853 | -73.845614 |
192 | Thai Pot | Thai Restaurant | 40.724720 | -73.850013 |
193 | Tu Casa Restaurant | South American Restaurant | 40.706113 | -73.831586 |
195 | Tikka Indian Grill | Indian Restaurant | 40.705874 | -73.830942 |
202 | The Venue | New American Restaurant | 40.705805 | -73.830967 |
207 | Mehak Mughlai Cuisine | Indian Restaurant | 40.709164 | -73.829509 |
209 | New China Fresh | Chinese Restaurant | 40.705968 | -73.831134 |
210 | Mini-burger | American Restaurant | 40.708837 | -73.830377 |
214 | Paul Michael Brick Oven Cafe | Italian Restaurant | 40.703730 | -73.824960 |
216 | Jade Chinese Restaurant | Chinese Restaurant | 40.708071 | -73.830895 |
221 | Great Taystee Gardens | Chinese Restaurant | 40.709053 | -73.830258 |
225 | Crazy Willy's | Latin American Restaurant | 40.699563 | -73.832275 |
226 | Kaieteur Restaurant | Caribbean Restaurant | 40.699570 | -73.830793 |
231 | Mi Casa Bar & Restaurant | Latin American Restaurant | 40.699401 | -73.832631 |
239 | Girasol Bakery | Spanish Restaurant | 40.699089 | -73.833832 |
241 | Punjabi Kabab House | Indian Restaurant | 40.694523 | -73.828254 |
243 | Debasaki | Korean Restaurant | 40.764852 | -73.831767 |
249 | Happy Lamb Hot Pot, Flushing | Hotpot Restaurant | 40.762083 | -73.828963 |
250 | Spring Shabu Shabu Buffet | Hotpot Restaurant | 40.761083 | -73.829609 |
251 | DunHuang Lanzhou Beef Noodle | Chinese Restaurant | 40.762316 | -73.827633 |
253 | Joe's Shanghai 鹿鸣春 | Dumpling Restaurant | 40.761794 | -73.830341 |
254 | Haidilao Hotpot | Hotpot Restaurant | 40.761195 | -73.827749 |
259 | Shaking Crab | Seafood Restaurant | 40.760839 | -73.832905 |
260 | Dong Yi Feng | Chinese Restaurant | 40.761294 | -73.831998 |
265 | 99 Favor Taste(99號餐廳) | Hotpot Restaurant | 40.761416 | -73.831636 |
268 | Dolar Shop | Hotpot Restaurant | 40.761039 | -73.832690 |
269 | New Mulan Seafood Restaurant | Dim Sum Restaurant | 40.760285 | -73.830250 |
271 | 重庆老灶 (Chong Qing Lao Zao) | Hotpot Restaurant | 40.760649 | -73.833037 |
283 | Waheyo | Mexican Restaurant | 40.749947 | -73.939427 |
286 | Indie | Restaurant | 40.748895 | -73.942162 |
287 | Dumpling D'or | Dumpling Restaurant | 40.750828 | -73.939545 |
298 | Raj's Indian Kitchen | Indian Restaurant | 40.749976 | -73.939261 |
304 | Don Pollo II | Peruvian Restaurant | 40.740049 | -73.923763 |
306 | Fish House | Seafood Restaurant | 40.740322 | -73.923142 |
307 | I Love Paraguay | South American Restaurant | 40.741087 | -73.921490 |
311 | SoleLuna | Italian Restaurant | 40.744096 | -73.924127 |
314 | Tropical Restaurant | Restaurant | 40.737414 | -73.929609 |
316 | La Pollera Colorada | South American Restaurant | 40.740247 | -73.923419 |
321 | La Hoguera Paisa | Latin American Restaurant | 40.743615 | -73.923851 |
326 | Ten Full Chinese | Chinese Restaurant | 40.740006 | -73.925086 |
328 | Harmony Terrace | Romanian Restaurant | 40.740426 | -73.923918 |
341 | Cali Ají Con Sabor | South American Restaurant | 40.762333 | -73.870721 |
352 | Sakura 7 | Sushi Restaurant | 40.724224 | -73.898659 |
355 | Patrizia's of Maspeth | Italian Restaurant | 40.726765 | -73.894270 |
357 | Wakamatsu | Japanese Restaurant | 40.727544 | -73.892359 |
371 | Yeun Wah Takeout | Chinese Restaurant | 40.722240 | -73.892708 |
374 | Taquerias Kermes | Mexican Restaurant | 40.707899 | -73.897762 |
375 | Little Egypt | Egyptian Restaurant | 40.708156 | -73.898048 |
376 | Joe's Restaurant | Italian Restaurant | 40.707452 | -73.903355 |
378 | Energy Fuel | Restaurant | 40.709503 | -73.898813 |
379 | Tendo Sushi | Sushi Restaurant | 40.708226 | -73.897944 |
383 | Coco Lin Vegetarian House | Vegetarian / Vegan Restaurant | 40.709853 | -73.899018 |
384 | Królewskie Jadło | Polish Restaurant | 40.708336 | -73.897926 |
385 | Gottscheer Hall | German Restaurant | 40.706690 | -73.905614 |
387 | Gyro World | Greek Restaurant | 40.707140 | -73.897194 |
392 | Garlic to the Chicken | Korean Restaurant | 40.705042 | -73.902190 |
402 | Bosna Express | Eastern European Restaurant | 40.704718 | -73.902378 |
409 | Avellino Ristorante & Pizzeria | Italian Restaurant | 40.729768 | -73.860451 |
411 | the dinerbar | American Restaurant | 40.729185 | -73.859349 |
412 | Marani | Kosher Restaurant | 40.731295 | -73.859999 |
414 | Chidori Japanese Cuisine | Sushi Restaurant | 40.729838 | -73.860247 |
415 | Bamboo Ya | Japanese Restaurant | 40.729812 | -73.860812 |
421 | Blacksea Fish & Grill | Mediterranean Restaurant | 40.730418 | -73.863424 |
424 | Roast N Co | Restaurant | 40.726658 | -73.853589 |
428 | Grand Sichuan | Chinese Restaurant | 40.727023 | -73.854786 |
430 | Rego Park Sake Sushi | Sushi Restaurant | 40.730438 | -73.863414 |
436 | Tasty & Co | Chinese Restaurant | 40.729334 | -73.862956 |
437 | Tu Arepa Pizza Cafe | Spanish Restaurant | 40.727482 | -73.853028 |
445 | Tropical #1 Restaurant | Latin American Restaurant | 40.692701 | -73.855712 |
450 | New Pops | Restaurant | 40.692488 | -73.858041 |
451 | Thailand Kitchen Corp. | Thai Restaurant | 40.692654 | -73.857987 |
457 | La Gitana Panaderia & Restaurant | Arepa Restaurant | 40.692904 | -73.854248 |
459 | Peking Chinese | Chinese Restaurant | 40.692379 | -73.862030 |
463 | Mia Halal Food | Restaurant | 40.680003 | -73.844438 |
473 | El Viejo Yayo | Latin American Restaurant | 40.684871 | -73.843781 |
480 | Libertad Restaurant | Spanish Restaurant | 40.680786 | -73.842373 |
504 | Mr Dre Kitchen Bar | Latin American Restaurant | 40.784360 | -73.845372 |
507 | Canaan Restaurant | Asian Restaurant | 40.784442 | -73.845817 |
510 | Little Pepper | Chinese Restaurant | 40.782462 | -73.845976 |
515 | Pollos A La Brasa Mr. Mario | Latin American Restaurant | 40.782992 | -73.845941 |
519 | Mangu Grill | Caribbean Restaurant | 40.784095 | -73.845659 |
524 | Lulu Seafood | Seafood Restaurant | 40.781417 | -73.840764 |
526 | La Grille Kitchen & Cafe | Spanish Restaurant | 40.785172 | -73.841450 |
531 | Miso Taco | Mexican Restaurant | 40.785023 | -73.846039 |
539 | Avli Little Greek Tavern | Greek Restaurant | 40.765729 | -73.771972 |
540 | Ayna Agra Indian Restaurant | Indian Restaurant | 40.765478 | -73.771737 |
542 | Taverna Kyclades | Greek Restaurant | 40.764522 | -73.771522 |
549 | Maria's Restaurant | Mediterranean Restaurant | 40.766253 | -73.772253 |
552 | Papazzio Restaurant | Italian Restaurant | 40.764323 | -73.771437 |
553 | Sushi Bell | Sushi Restaurant | 40.767142 | -73.773214 |
554 | You Garden Xiao Long Bao | Shanghai Restaurant | 40.763364 | -73.770664 |
555 | Pho Grand | Vietnamese Restaurant | 40.765448 | -73.772082 |
556 | Sol Bar & Grill | Latin American Restaurant | 40.763932 | -73.770982 |
561 | Krave It | American Restaurant | 40.763830 | -73.771010 |
563 | Uno Pizzeria & Grill | American Restaurant | 40.765087 | -73.771871 |
564 | Sangarita's Tapas Wine | Spanish Restaurant | 40.764155 | -73.771532 |
565 | Bell Garden | Chinese Restaurant | 40.764690 | -73.771240 |
566 | Tanko | Asian Restaurant | 40.766360 | -73.772275 |
567 | Masala Box | Indian Restaurant | 40.762674 | -73.770682 |
568 | Durso's Pasta & Ravioli Company | Italian Restaurant | 40.763338 | -73.793057 |
575 | The Sweet Sap | American Restaurant | 40.757848 | -73.791722 |
581 | Gahwa Sulungtang | Korean Restaurant | 40.757671 | -73.791711 |
583 | Primo Amore | Italian Restaurant | 40.765464 | -73.788901 |
589 | Sushi Takeout Enjoy | Sushi Restaurant | 40.758298 | -73.795392 |
590 | Tei Nei Ya | Japanese Restaurant | 40.769336 | -73.736621 |
591 | Little Dumpling 李小籠 | Chinese Restaurant | 40.770242 | -73.735785 |
592 | Lima 33 Restaurant | Peruvian Restaurant | 40.771539 | -73.734733 |
593 | Greek Islands | Greek Restaurant | 40.771140 | -73.735183 |
594 | Il Bacco | Italian Restaurant | 40.771174 | -73.735006 |
598 | Aunt Bella's | Italian Restaurant | 40.766903 | -73.736485 |
599 | La Baraka Restaurant | French Restaurant | 40.772271 | -73.734267 |
601 | Kebab House | Middle Eastern Restaurant | 40.772149 | -73.734348 |
603 | Sifu Chio - The Noodle Shop | Cantonese Restaurant | 40.769357 | -73.736279 |
607 | LN1380 舍得食府 | Chinese Restaurant | 40.769042 | -73.736964 |
611 | La Grotta di Marcello | Italian Restaurant | 40.771714 | -73.734550 |
615 | Northern Manor 同乐轩 | Chinese Restaurant | 40.769336 | -73.736743 |
618 | Little Saigon Cuisine | Vietnamese Restaurant | 40.770940 | -73.735401 |
623 | Il Sapore Pizza | Italian Restaurant | 40.765934 | -73.744990 |
634 | Best Garden Chinese Restaurant | Chinese Restaurant | 40.765579 | -73.744102 |
636 | Taeneung | Korean Restaurant | 40.767535 | -73.738512 |
639 | Dragon Express Chinese Restaurant | Chinese Restaurant | 40.767756 | -73.748099 |
645 | Santoor Indian Restaurant | Indian Restaurant | 40.745936 | -73.714231 |
653 | Halal Cart on union tpke | Middle Eastern Restaurant | 40.748465 | -73.712666 |
661 | Chicken & Rice | Falafel Restaurant | 40.745745 | -73.714516 |
663 | Fat Ernie's Cheesesteak Co. | American Restaurant | 40.726166 | -73.717401 |
668 | Trattoria Lucia | Italian Restaurant | 40.725976 | -73.718880 |
670 | NY Crab Cake & Company | Seafood Restaurant | 40.724671 | -73.722363 |
673 | Arturo's Ristorante Italiano | Italian Restaurant | 40.724867 | -73.722412 |
677 | King Rice Chinese Restaurant | Chinese Restaurant | 40.726533 | -73.716645 |
687 | Elite Cafe | Sushi Restaurant | 40.725835 | -73.821606 |
688 | Svetsarah | Restaurant | 40.724137 | -73.820293 |
698 | Sushi Metsuyan | Sushi Restaurant | 40.726354 | -73.821936 |
707 | Peking Chinese Restaurant | Vegetarian / Vegan Restaurant | 40.733397 | -73.783293 |
708 | Peking | Chinese Restaurant | 40.733444 | -73.783484 |
715 | New Hong Kong Garden | Chinese Restaurant | 40.737109 | -73.778004 |
723 | Moon Tikka | Indian Restaurant | 40.713202 | -73.807214 |
724 | Misu Sushi | Sushi Restaurant | 40.707920 | -73.815620 |
726 | Don Nico's | Mexican Restaurant | 40.705134 | -73.799258 |
728 | Jamaican Flavors | Caribbean Restaurant | 40.705592 | -73.794951 |
731 | PP Boy Japan Teriyaki & Sushi | Japanese Restaurant | 40.704896 | -73.799031 |
739 | Chipotle Mexican Grill | Mexican Restaurant | 40.703708 | -73.798961 |
744 | Boston Market | American Restaurant | 40.705406 | -73.794668 |
745 | Panda Express | Chinese Restaurant | 40.703704 | -73.798936 |
753 | Applebee's Grill + Bar | American Restaurant | 40.704299 | -73.798058 |
756 | Bi Won Korean Restaurant | Korean Restaurant | 40.747491 | -73.755944 |
759 | Fukuoka Shabu Shabu | Taiwanese Restaurant | 40.748990 | -73.756717 |
761 | Chilsung Garden | Korean Restaurant | 40.749320 | -73.755368 |
762 | Rolly Kimbab | Korean Restaurant | 40.748531 | -73.756335 |
763 | Empire Garden | Chinese Restaurant | 40.748521 | -73.756458 |
765 | Little Dumpling | Chinese Restaurant | 40.749046 | -73.756210 |
768 | River Japanese Cuisine | Sushi Restaurant | 40.748028 | -73.756349 |
774 | Saigon Asian Cuisine | Vietnamese Restaurant | 40.748120 | -73.756345 |
779 | Imperial Wok | Chinese Restaurant | 40.749327 | -73.755178 |
782 | Duck Hyang | Korean Restaurant | 40.749373 | -73.755293 |
797 | Kanto Grill | Filipino Restaurant | 40.717063 | -73.741499 |
801 | Emilio's Mexican Grill | Mexican Restaurant | 40.719885 | -73.732935 |
808 | New Ho Wah | Chinese Restaurant | 40.712344 | -73.764411 |
814 | Cindee's Bakery | Asian Restaurant | 40.712366 | -73.764495 |
815 | The Nourish Spot | Vegetarian / Vegan Restaurant | 40.697966 | -73.792267 |
817 | Anita's Roti Shop | Caribbean Restaurant | 40.699471 | -73.793022 |
824 | The Smokehouse | Caribbean Restaurant | 40.692062 | -73.761234 |
826 | Yardies Jerk | Caribbean Restaurant | 40.694038 | -73.753546 |
827 | jamaican flavors | Caribbean Restaurant | 40.691420 | -73.762452 |
834 | Panda Chinese Restaurant | Chinese Restaurant | 40.693559 | -73.755528 |
835 | Fah Mas | Caribbean Restaurant | 40.695791 | -73.761642 |
839 | Fish & Chips | Seafood Restaurant | 40.691362 | -73.762446 |
848 | Southern Flair Restaurant | Southern / Soul Food Restaurant | 40.673680 | -73.770254 |
851 | Magic Soul Food | Southern / Soul Food Restaurant | 40.672063 | -73.775072 |
852 | New Ming Garden | Chinese Restaurant | 40.672979 | -73.775497 |
870 | Butterflies | Chinese Restaurant | 40.663411 | -73.764449 |
872 | Good Taste Catering | Caribbean Restaurant | 40.692605 | -73.732292 |
875 | Epi Dor Kreyol Restaurant And Bakery | Caribbean Restaurant | 40.693936 | -73.737043 |
876 | Jamaican Flavors | Caribbean Restaurant | 40.693081 | -73.732773 |
878 | Sally's Restaurant | Restaurant | 40.692265 | -73.731812 |
880 | Kitchen King | Restaurant | 40.691898 | -73.730247 |
881 | Little Rabbit | Chinese Restaurant | 40.695073 | -73.739779 |
882 | Pa-Nash Eurosoul | Caribbean Restaurant | 40.660051 | -73.739781 |
888 | Win Chinese Store | Chinese Restaurant | 40.657945 | -73.736228 |
895 | Magic Wok | Chinese Restaurant | 40.606444 | -73.756196 |
899 | Lucky Cornaga | Chinese Restaurant | 40.602612 | -73.749596 |
900 | Golden Krust Caribbean Restaurant | Caribbean Restaurant | 40.604083 | -73.752224 |
912 | Butterflies Chinese Restaurant | Chinese Restaurant | 40.603992 | -73.754936 |
942 | Kumo | Sushi Restaurant | 40.773563 | -73.907109 |
944 | Alba's Pizza & Restaurant | Italian Restaurant | 40.773855 | -73.907548 |
947 | Oishii Sushi | Japanese Restaurant | 40.773779 | -73.907389 |
961 | due ponti ristorante | Italian Restaurant | 40.796289 | -73.806327 |
965 | New Hong Kong | Chinese Restaurant | 40.792408 | -73.806892 |
969 | Emperor House | Chinese Restaurant | 40.793805 | -73.807543 |
974 | Boston Market | American Restaurant | 40.780246 | -73.776820 |
982 | The Health Nuts | Gluten-free Restaurant | 40.778788 | -73.778426 |
993 | Applebee's Grill + Bar | American Restaurant | 40.779199 | -73.776437 |
1008 | New Garden Restaurant | Asian Restaurant | 40.595516 | -73.775436 |
1011 | eliner seafood | Seafood Restaurant | 40.596328 | -73.771077 |
1025 | Thai Kitchen By The Sea | Thai Restaurant | 40.590823 | -73.796706 |
1033 | Batesy's Bbq | Restaurant | 40.590759 | -73.797119 |
1040 | Caracas Arepa Bar (Rockaway Beach Concession) | Arepa Restaurant | 40.580586 | -73.825922 |
1042 | Brisas Del Mar | Spanish Restaurant | 40.584298 | -73.820606 |
1055 | Community House | New American Restaurant | 40.583171 | -73.822110 |
1057 | Uma's | Eastern European Restaurant | 40.582863 | -73.817733 |
1059 | The Summer Shift by The MP Shift | Brazilian Restaurant | 40.585152 | -73.817901 |
1060 | Island Veggie | Vegetarian / Vegan Restaurant | 40.585257 | -73.817947 |
1071 | Hahm Ji Bach - 함지박 | Korean Restaurant | 40.763022 | -73.815042 |
1072 | Mapo BBQ | Korean Restaurant | 40.762309 | -73.814880 |
1074 | Kum Sung Chik Naengmyun | Korean Restaurant | 40.763122 | -73.815091 |
1075 | Northern Sushi | Japanese Restaurant | 40.764717 | -73.811235 |
1076 | Geo Si Gi Restaurant | Korean Restaurant | 40.764865 | -73.811983 |
1078 | SGD Tofu House & BBQ | Korean Restaurant | 40.762125 | -73.815532 |
1079 | Jongro BBQ | Korean Restaurant | 40.764113 | -73.809404 |
1081 | Mad For Chicken | Korean Restaurant | 40.763426 | -73.807724 |
1083 | Han Joo | Korean Restaurant | 40.762274 | -73.814769 |
1084 | Mr. Tofu | Korean Restaurant | 40.764841 | -73.812266 |
1091 | Jeong Yook | Korean Restaurant | 40.764801 | -73.812489 |
1092 | Bonjuk Korean Traditional Porridge Restaurant | Korean Restaurant | 40.764873 | -73.812111 |
1095 | Sodam | Korean Restaurant | 40.763868 | -73.808420 |
1096 | Pizza Maru | Korean Restaurant | 40.763640 | -73.809022 |
1097 | 돌아온 1.5 닭갈비 | Korean Restaurant | 40.763473 | -73.807155 |
1099 | Emone Korean Family Restaurant | Korean Restaurant | 40.763339 | -73.809140 |
1104 | Flavor Of India | Indian Restaurant | 40.737425 | -73.708540 |
1106 | Shahi Darbar | Indian Restaurant | 40.737488 | -73.710022 |
1107 | Honest | Indian Restaurant | 40.737034 | -73.710076 |
1117 | Dhaka Hajir Biryani | Indian Restaurant | 40.720989 | -73.786781 |
1118 | Kung Fu Xiao Long Bao | Dumpling Restaurant | 40.743380 | -73.825741 |
1121 | Main Street Taiwanese Gourmet 北港台菜 | Chinese Restaurant | 40.743538 | -73.825825 |
1122 | Lake Pavilion Restaurant | Chinese Restaurant | 40.742622 | -73.824970 |
1127 | 88 Canteen | Chinese Restaurant | 40.743942 | -73.825862 |
1128 | Asian Gourmet Restaurant | Asian Restaurant | 40.746143 | -73.825935 |
1135 | Cash Villa Shabu Shabu | Asian Restaurant | 40.743420 | -73.825758 |
1143 | Wo Kee Noodle | Dim Sum Restaurant | 40.723045 | -73.799786 |
1161 | Kondo | Japanese Restaurant | 40.762529 | -73.926472 |
1162 | Sami's Kebab House | Afghan Restaurant | 40.758408 | -73.933090 |
1163 | Tamashii Ramen | Ramen Restaurant | 40.762717 | -73.926802 |
1165 | New York Pão de Queijo | Brazilian Restaurant | 40.762601 | -73.925992 |
1167 | Bund On Broadway | Chinese Restaurant | 40.763065 | -73.928221 |
1168 | Aliada Restaurant | Greek Restaurant | 40.762558 | -73.926188 |
1169 | Botte Bar | Italian Restaurant | 40.763265 | -73.928091 |
1172 | Fatima's Halal Kitchen | Chinese Restaurant | 40.763071 | -73.927536 |
1177 | Arepas Grill | Latin American Restaurant | 40.764979 | -73.930430 |
1179 | Abi Sushi | Sushi Restaurant | 40.760320 | -73.926478 |
1181 | Aladdin Sweets and Restaurant | Indian Restaurant | 40.757262 | -73.931159 |
1184 | Kawaii | Japanese Restaurant | 40.666463 | -73.851735 |
1196 | Henrica's Restaurant And Lounge | Caribbean Restaurant | 40.666813 | -73.736520 |
1197 | Golden Krust | Caribbean Restaurant | 40.667382 | -73.737395 |
1201 | G's Restaurant & Bar | Caribbean Restaurant | 40.664833 | -73.736098 |
1214 | Chipotle Mexican Grill | Mexican Restaurant | 40.733244 | -73.863896 |
1226 | Pico Mexican Restaurant | Mexican Restaurant | 40.578352 | -73.849470 |
1231 | Plum Tomatoes | Italian Restaurant | 40.578406 | -73.849340 |
1234 | East Meets West | Chinese Restaurant | 40.578435 | -73.849474 |
1243 | Cuisine By Claudette | French Restaurant | 40.578868 | -73.836868 |
1247 | The Wharf | Seafood Restaurant | 40.582680 | -73.838440 |
1257 | Painico Cafe | Mediterranean Restaurant | 40.580485 | -73.837922 |
1270 | Cara Mia Restaurant | Italian Restaurant | 40.730407 | -73.743181 |
1272 | China King | Chinese Restaurant | 40.728896 | -73.737284 |
1275 | Szechuan Kitchen | Chinese Restaurant | 40.732930 | -73.736662 |
1281 | Silvermoon Diner | Greek Restaurant | 40.730397 | -73.734288 |
1284 | Los Amigos Chimichurry | South American Restaurant | 40.751195 | -73.856925 |
1291 | Los Tres Potrillos | Mexican Restaurant | 40.751719 | -73.855204 |
1292 | King Empanadas | Caribbean Restaurant | 40.752513 | -73.859685 |
1295 | El Fogon Costeno | Latin American Restaurant | 40.757770 | -73.859889 |
1310 | Sushi Time | Sushi Restaurant | 40.718683 | -73.841453 |
1311 | Rove | New American Restaurant | 40.719058 | -73.841879 |
1320 | Happy Fresh Tortilla Grill | Mexican Restaurant | 40.718962 | -73.841342 |
1325 | Pete's Paalace | Polish Restaurant | 40.710514 | -73.842780 |
1327 | Genesis #1 | Caribbean Restaurant | 40.708827 | -73.799318 |
1328 | King Kabab | Halal Restaurant | 40.709936 | -73.795289 |
1329 | Sagar Restaurant | Indian Restaurant | 40.710329 | -73.794123 |
1330 | Annam Brahma | Indian Restaurant | 40.712781 | -73.801283 |
1333 | Sagar Chinese | Chinese Restaurant | 40.711129 | -73.793021 |
1334 | Amina Thai | Thai Restaurant | 40.710897 | -73.792330 |
1340 | Crown Fried Chicken | Southern / Soul Food Restaurant | 40.710992 | -73.791879 |
1343 | shahs halal cart | Halal Restaurant | 40.711057 | -73.792987 |
1346 | Dhanshiri Chinese | Chinese Restaurant | 40.710873 | -73.792076 |
1350 | Tienda Vieja | South American Restaurant | 40.734717 | -73.794717 |
1352 | Bakhter Afghan Halal Kababs | Afghan Restaurant | 40.733205 | -73.794645 |
1369 | Futigi Japanese Cuisine | Japanese Restaurant | 40.733060 | -73.804720 |
1372 | Halal Munchies | Halal Restaurant | 40.732425 | -73.804670 |
1377 | Antonio's Kitchen | Italian Restaurant | 40.768154 | -73.894684 |
1383 | Antonio's Pizzeria and Wine Bar! | Italian Restaurant | 40.768131 | -73.894699 |
1388 | Hibino LIC | Japanese Restaurant | 40.742770 | -73.952127 |
1389 | Casa Enrique | Mexican Restaurant | 40.743374 | -73.954339 |
1390 | Takumen | Japanese Restaurant | 40.742786 | -73.954544 |
1391 | Jackson's Eatery | Bar | American Restaurant | 40.742455 | -73.953153 |
1392 | Tournesol | French Restaurant | 40.742374 | -73.954370 |
1393 | Tuk Tuk | Thai Restaurant | 40.743142 | -73.954021 |
1394 | Manetta's Ristorante | Italian Restaurant | 40.742577 | -73.951940 |
1395 | Jora | Peruvian Restaurant | 40.743674 | -73.951320 |
1399 | Madera Cuban Grill & Steakhouse | Cuban Restaurant | 40.744603 | -73.953439 |
1400 | Bellwether | New American Restaurant | 40.744859 | -73.953364 |
1401 | Blend LIC | Latin American Restaurant | 40.745329 | -73.953305 |
1403 | Bella Via | Italian Restaurant | 40.744219 | -73.953669 |
1405 | Woodbines | American Restaurant | 40.745181 | -73.953337 |
1408 | Cyclo | Vietnamese Restaurant | 40.745563 | -73.953465 |
1410 | Vernon Grille | Greek Restaurant | 40.743489 | -73.953877 |
1413 | Murasaki | Sushi Restaurant | 40.745661 | -73.953240 |
1414 | Dai Hachi | Japanese Restaurant | 40.746355 | -73.953215 |
1416 | Manducatis Rustica | Italian Restaurant | 40.745959 | -73.953021 |
1417 | The Alcove | American Restaurant | 40.745929 | -73.915263 |
1432 | Saffron Garden | Indian Restaurant | 40.746554 | -73.917738 |
1433 | Mangal Kebab | Turkish Restaurant | 40.742782 | -73.918004 |
1435 | Souk El Shater | Middle Eastern Restaurant | 40.743605 | -73.921253 |
1437 | Golden Wok | Chinese Restaurant | 40.745251 | -73.921450 |
1438 | Takesushi | Sushi Restaurant | 40.744091 | -73.922353 |
1439 | TJ Asian Bistro | Sushi Restaurant | 40.746118 | -73.913568 |
1440 | Tito Rad's Grill & Restaurant | Filipino Restaurant | 40.742477 | -73.915584 |
1441 | Sik Gaek | Korean Restaurant | 40.743322 | -73.915336 |
1448 | Tropical Restaurant | Restaurant | 40.737414 | -73.929609 |
1471 | Villa Erasmo | Italian Restaurant | 40.716761 | -73.886221 |
1475 | Toyo | Sushi Restaurant | 40.712611 | -73.878948 |
1476 | Rico's Chicken | South American Restaurant | 40.713009 | -73.877336 |
1483 | Samanta's Restaurant | Spanish Restaurant | 40.713018 | -73.877624 |
1509 | Boulevard Restaurant | Spanish Restaurant | 40.755648 | -73.941834 |
brooklyn_data = boroughs[boroughs['Borough'] == 'Brooklyn'].reset_index(drop = True)
rad = 500
brooklyn_venues = pd.DataFrame()
for i, row in brooklyn_data.iterrows():
lat = brooklyn_data.loc[i, 'Latitude']
lng = brooklyn_data.loc[i, 'Longitude']
url = 'https://api.foursquare.com/v2/venues/explore?&client_id={}&client_secret={}&v={}&ll={},{}&radius={}'.format(
CLIENT_ID,
CLIENT_SECRET,
VERSION,
lat,
lng,
rad)
url
result = requests.get(url).json()
venues = result['response']['groups'][0]['items']
nearby_venues = json_normalize(venues)
filtered_columns = ['venue.name', 'venue.categories', 'venue.location.lat', 'venue.location.lng']
nearby_venues = nearby_venues.loc[:, filtered_columns]
nearby_venues['venue.categories'] = nearby_venues.apply(get_category_type, axis=1)
nearby_venues.columns = [col.split(".")[-1] for col in nearby_venues.columns]
for k, vals in nearby_venues.iterrows():
venue_row = pd.Series(vals.values)
brooklyn_venues = brooklyn_venues.append(venue_row, ignore_index = True)
brooklyn_venues.rename(columns = {0: "Name", 1: "Category", 2: "Latitude", 3: "Longitude"}, inplace = True)
brooklyn_restaurants = brooklyn_venues[brooklyn_venues['Category'].str.contains('Restaurant')]
brooklyn_restaurants = brooklyn_restaurants[brooklyn_restaurants['Category'] != 'Fast Food Restaurant']
brooklyn_restaurants
Name | Category | Latitude | Longitude | |
---|---|---|---|---|
9 | Blue Door Souvlakia | Greek Restaurant | 40.624567 | -74.030311 |
11 | Karam | Middle Eastern Restaurant | 40.622931 | -74.028316 |
17 | Tuscany Grill | Italian Restaurant | 40.622913 | -74.031387 |
18 | Elia Restaurant | Greek Restaurant | 40.623090 | -74.031156 |
19 | Georgian Dream Cafe and Bakery | Caucasian Restaurant | 40.625586 | -74.030196 |
24 | Greenhouse Cafe | American Restaurant | 40.629542 | -74.028514 |
25 | XIN | Chinese Restaurant | 40.625082 | -74.030494 |
26 | Chadwick's Restaurant | American Restaurant | 40.621450 | -74.031964 |
27 | Cebu' Bar & Bistro | New American Restaurant | 40.621812 | -74.031727 |
28 | Zio Toto | Italian Restaurant | 40.624791 | -74.030551 |
30 | Villa Fiorita | Italian Restaurant | 40.611931 | -73.997854 |
32 | il Colosseo | Italian Restaurant | 40.612221 | -73.997436 |
35 | Tenzan | Sushi Restaurant | 40.615265 | -73.994046 |
38 | Hot Spot Nabe | Shabu-Shabu Restaurant | 40.615130 | -73.994582 |
42 | Wasabi | Sushi Restaurant | 40.614718 | -73.994751 |
43 | 18 Hipot | Hotpot Restaurant | 40.609241 | -74.000207 |
50 | Panda Chinese Restaurant | Chinese Restaurant | 40.611388 | -73.990784 |
55 | Home Town Restaurant | Chinese Restaurant | 40.614891 | -73.994881 |
60 | La Isla Cuchifritos | Latin American Restaurant | 40.645245 | -74.010200 |
61 | La Brasa Peruana | Latin American Restaurant | 40.646964 | -74.008443 |
64 | Tacos Matamoros | Mexican Restaurant | 40.647748 | -74.007621 |
74 | Ricos Tacos | Mexican Restaurant | 40.644426 | -74.010705 |
75 | International Restaurant | Latin American Restaurant | 40.648354 | -74.007086 |
77 | Cafe Lore | Italian Restaurant | 40.648474 | -74.010089 |
91 | Oxomoco | Mexican Restaurant | 40.729981 | -73.955460 |
92 | Karczma | Polish Restaurant | 40.730102 | -73.955092 |
93 | Friducha | Mexican Restaurant | 40.731512 | -73.954281 |
96 | Citroën | French Restaurant | 40.731173 | -73.954523 |
98 | Chiko | Szechuan Restaurant | 40.731871 | -73.954369 |
113 | Archestratus Books & Foods | Restaurant | 40.732905 | -73.955365 |
116 | Adelina's | Italian Restaurant | 40.730301 | -73.953352 |
119 | Jungle Cafe | Vegetarian / Vegan Restaurant | 40.730201 | -73.954761 |
121 | Joe's of Avenue U | Italian Restaurant | 40.596971 | -73.973677 |
135 | Bari Pork Store | Italian Restaurant | 40.596167 | -73.978314 |
140 | Choy Le Chinese Restaraunt | Chinese Restaurant | 40.597537 | -73.968531 |
144 | Georgian House in NYC | Restaurant | 40.576636 | -73.967238 |
146 | Beyti Turkish Kebab | Mediterranean Restaurant | 40.577256 | -73.962730 |
150 | Cafe Euroasia | Eastern European Restaurant | 40.577408 | -73.961244 |
151 | Sachiko Sushi | Sushi Restaurant | 40.576380 | -73.965797 |
154 | Cafe At Your Mother-in-Law | Korean Restaurant | 40.577575 | -73.963449 |
157 | Skovorodka | Russian Restaurant | 40.577851 | -73.960968 |
163 | Tatiana Restaurant | Russian Restaurant | 40.575108 | -73.961581 |
164 | Umi Japanese Cuisine | Sushi Restaurant | 40.576609 | -73.966667 |
167 | The National | Restaurant | 40.576992 | -73.964870 |
168 | Tatiana Cafe | Eastern European Restaurant | 40.574914 | -73.962700 |
172 | Opera Cafe Lounge | Turkish Restaurant | 40.583842 | -73.944481 |
174 | Liman Restaurant | Turkish Restaurant | 40.583368 | -73.941053 |
176 | Cats on the Bay | Restaurant | 40.583824 | -73.946849 |
177 | Il Fornetto | Italian Restaurant | 40.583378 | -73.939487 |
178 | Rocca Cafe & Lounge | Turkish Restaurant | 40.583371 | -73.940841 |
183 | Applebee's Grill + Bar | American Restaurant | 40.583888 | -73.943235 |
190 | Passage | Russian Restaurant | 40.583739 | -73.947066 |
209 | Masake | Japanese Restaurant | 40.618227 | -73.957961 |
216 | King Solomon Glatt Kosher | Eastern European Restaurant | 40.613804 | -73.962738 |
218 | El Paso Mexican Grill | Mexican Restaurant | 40.636081 | -73.962079 |
222 | Gyro King | Middle Eastern Restaurant | 40.634575 | -73.962775 |
223 | Double Dragon Chinese Restaurant | Chinese Restaurant | 40.635112 | -73.962907 |
224 | Don Burrito | Mexican Restaurant | 40.635431 | -73.962829 |
225 | Golden Krust Caribbean Bakery and Grill | Caribbean Restaurant | 40.634923 | -73.963013 |
234 | Fisherman's Cove | Caribbean Restaurant | 40.635467 | -73.962869 |
258 | Ess N Bentch | Kosher Restaurant | 40.668639 | -73.942070 |
260 | VIVID Caribbean American Bistro | Caribbean Restaurant | 40.642025 | -73.932636 |
270 | China Express | Chinese Restaurant | 40.641422 | -73.937668 |
274 | To Be Thai | Thai Restaurant | 40.642891 | -73.978334 |
275 | El Mirador | Mexican Restaurant | 40.642318 | -73.981095 |
276 | Sawasde Thai Cooking | Thai Restaurant | 40.645311 | -73.979805 |
278 | Thai Farm Kitchen | Thai Restaurant | 40.644148 | -73.976047 |
287 | Sake Sushi | Japanese Restaurant | 40.644138 | -73.976439 |
298 | Brooklyn Comfort | Restaurant | 40.643591 | -73.977586 |
308 | Krupa Grocery | American Restaurant | 40.659957 | -73.980696 |
310 | East Wind Snack Shop | Chinese Restaurant | 40.660297 | -73.980169 |
312 | Bedawi Cafe | Middle Eastern Restaurant | 40.658588 | -73.982020 |
313 | Sushi Yama | Sushi Restaurant | 40.658542 | -73.982054 |
316 | Giovanni's Brooklyn Eats | Italian Restaurant | 40.660159 | -73.983753 |
321 | Le P'tit Paris Bistro | French Restaurant | 40.658903 | -73.981759 |
333 | The Islands | Caribbean Restaurant | 40.677036 | -73.963563 |
334 | Gen | Sushi Restaurant | 40.677575 | -73.963721 |
341 | Nacho Macho Taco | Mexican Restaurant | 40.676486 | -73.962775 |
347 | Kimchi Grill | Korean Restaurant | 40.675130 | -73.963245 |
348 | Muse | Thai Restaurant | 40.676594 | -73.963503 |
350 | Lowerline | Cajun / Creole Restaurant | 40.674214 | -73.963137 |
351 | Puerto Viejo | Latin American Restaurant | 40.678925 | -73.961960 |
354 | Olmsted | New American Restaurant | 40.677176 | -73.968931 |
359 | Nimbooda | North Indian Restaurant | 40.678277 | -73.963957 |
363 | Tropical Coffee Shop | Spanish Restaurant | 40.665831 | -73.909984 |
366 | Checkers | Restaurant | 40.663111 | -73.909216 |
369 | Wah Yung Chinese Food | Chinese Restaurant | 40.664267 | -73.909533 |
381 | Golden Lotus Chinese Restaurant | Chinese Restaurant | 40.661901 | -73.915296 |
383 | Dotory | Korean Restaurant | 40.707730 | -73.955779 |
392 | Xixa | Latin American Restaurant | 40.710410 | -73.958531 |
393 | Shalom Japan | Japanese Restaurant | 40.709219 | -73.955839 |
394 | Traif | Tapas Restaurant | 40.710557 | -73.958895 |
403 | Dough Vale | Italian Restaurant | 40.709306 | -73.954056 |
406 | Kabob Shack | Middle Eastern Restaurant | 40.710730 | -73.958244 |
407 | To Spiti | Greek Restaurant | 40.711452 | -73.957637 |
413 | Maite | Latin American Restaurant | 40.699091 | -73.926838 |
415 | Taqueria Sofia | Mexican Restaurant | 40.700242 | -73.925575 |
417 | Le Garage | French Restaurant | 40.699312 | -73.926591 |
418 | Millie’s Cuban Cafe | Cuban Restaurant | 40.700370 | -73.925050 |
420 | El Kucho | Mexican Restaurant | 40.700669 | -73.925641 |
424 | Carmenta’s | Italian Restaurant | 40.701320 | -73.926783 |
427 | El Sol de Cholula | Mexican Restaurant | 40.700066 | -73.924548 |
430 | Zatar | Mediterranean Restaurant | 40.698000 | -73.924550 |
433 | Hartbreakers | Vegetarian / Vegan Restaurant | 40.701627 | -73.922853 |
443 | Bar Camillo | Italian Restaurant | 40.686523 | -73.944379 |
448 | Eugene & Co | New American Restaurant | 40.683899 | -73.944023 |
450 | Warude | Japanese Restaurant | 40.684410 | -73.944118 |
476 | Sushi Gallery | Sushi Restaurant | 40.697595 | -73.993236 |
478 | Grand Canyon Restaurant | Mexican Restaurant | 40.694825 | -73.993559 |
480 | Iron Chef House | Japanese Restaurant | 40.697406 | -73.992560 |
482 | Saketumi Asian Bistro | Asian Restaurant | 40.694910 | -73.994578 |
490 | Henry's End | New American Restaurant | 40.698576 | -73.992448 |
494 | Lantern Thai Kitchen | Thai Restaurant | 40.695168 | -73.995621 |
506 | La Vara | Spanish Restaurant | 40.687851 | -73.995582 |
507 | Hibino | Japanese Restaurant | 40.690076 | -73.996497 |
508 | Lillo | Italian Restaurant | 40.690200 | -73.996540 |
510 | Popina | Italian Restaurant | 40.687420 | -74.001432 |
511 | Saint Julivert Fisherie | Seafood Restaurant | 40.687930 | -73.995548 |
514 | Colonie | American Restaurant | 40.690733 | -73.995963 |
524 | Table 87 | Italian Restaurant | 40.691164 | -73.997443 |
525 | Chez Moi | French Restaurant | 40.690654 | -73.995777 |
529 | Yemen Cafe | Middle Eastern Restaurant | 40.690026 | -73.993579 |
530 | PIPS | Restaurant | 40.690732 | -73.995855 |
531 | Fatoosh BBQ & Pizza | Middle Eastern Restaurant | 40.691328 | -73.997739 |
535 | Avlee Greek Kitchen | Greek Restaurant | 40.679975 | -73.994988 |
545 | Fragole | Italian Restaurant | 40.680805 | -73.996890 |
550 | Ugly Baby | Thai Restaurant | 40.678019 | -73.996139 |
553 | Vinny's of Carroll Gardens | Italian Restaurant | 40.681885 | -73.993570 |
554 | The Grocery | American Restaurant | 40.681972 | -73.993778 |
558 | White Maize | Latin American Restaurant | 40.682500 | -73.993313 |
559 | Bar Bête | French Restaurant | 40.682922 | -73.992907 |
560 | Emma’s Torch | Restaurant | 40.679993 | -73.994853 |
561 | Claudine's | Italian Restaurant | 40.681352 | -73.994107 |
565 | Somtum Der | Thai Restaurant | 40.677070 | -74.013306 |
576 | The CopperPot | New American Restaurant | 40.677269 | -74.012580 |
577 | Brooklyn Crab | Seafood Restaurant | 40.675319 | -74.016540 |
585 | Red Hook Lobster Pound | Seafood Restaurant | 40.679752 | -74.010229 |
600 | Buttermilk Channel | American Restaurant | 40.675924 | -73.999070 |
605 | El Mate | Argentinian Restaurant | 40.675016 | -73.999602 |
606 | Frankies 457 Spuntino | Italian Restaurant | 40.677360 | -73.998047 |
607 | Ugly Baby | Thai Restaurant | 40.678019 | -73.996139 |
611 | La Slowteria | Mexican Restaurant | 40.675047 | -73.999404 |
612 | Za-Ya Ramen | Ramen Restaurant | 40.674224 | -73.999877 |
615 | Franks Wine Bar | Italian Restaurant | 40.677181 | -73.998324 |
617 | Kanan's Indian Restaurant | Indian Restaurant | 40.671891 | -73.990940 |
619 | Bar Tano | Italian Restaurant | 40.671363 | -73.991039 |
622 | Evelina Restaurant | Italian Restaurant | 40.689629 | -73.971018 |
623 | Miss Ada | Israeli Restaurant | 40.689560 | -73.972351 |
625 | Olea | Tapas Restaurant | 40.687716 | -73.970594 |
627 | Karasu | Japanese Restaurant | 40.689577 | -73.973290 |
628 | Walter's | New American Restaurant | 40.689630 | -73.973119 |
629 | Colonia Verde | Latin American Restaurant | 40.689693 | -73.970738 |
630 | Imani Caribbean Kitchen & Bar | Caribbean Restaurant | 40.689494 | -73.970959 |
638 | Dino | Italian Restaurant | 40.689535 | -73.970466 |
639 | Habana Outpost | Cuban Restaurant | 40.686364 | -73.974388 |
643 | Cafe Paulette | French Restaurant | 40.689743 | -73.975798 |
647 | LuAnne's Wild Ginger | Vegetarian / Vegan Restaurant | 40.689644 | -73.969824 |
648 | Roman’s | Italian Restaurant | 40.689529 | -73.969518 |
649 | Peaches Hothouse | Southern / Soul Food Restaurant | 40.687016 | -73.975550 |
651 | Endswell | Restaurant | 40.686125 | -73.973798 |
655 | Sushi Katsuei | Japanese Restaurant | 40.670615 | -73.978504 |
675 | Rose Water | American Restaurant | 40.675536 | -73.978240 |
676 | Papi's Grill | Mexican Restaurant | 40.672119 | -73.977249 |
678 | Mr. Falafel | Falafel Restaurant | 40.670262 | -73.978869 |
681 | Chipotle Mexican Grill | Mexican Restaurant | 40.671180 | -73.977713 |
683 | El Gran Mar de Plata | Latin American Restaurant | 40.682170 | -73.877865 |
685 | Barzola | South American Restaurant | 40.681656 | -73.871405 |
695 | Toribio Restaurant | Latin American Restaurant | 40.682142 | -73.878153 |
703 | Sing Yee Kitchen | Chinese Restaurant | 40.684193 | -73.872433 |
705 | Aztec Soul | Mexican Restaurant | 40.681324 | -73.871722 |
711 | LOMA #4 | Spanish Restaurant | 40.666436 | -73.882682 |
712 | New Beginning West Indian And American Cuisine | Caribbean Restaurant | 40.673154 | -73.877641 |
718 | Lechonera Resurant | Latin American Restaurant | 40.666121 | -73.883429 |
723 | Boston Market | American Restaurant | 40.647250 | -73.882550 |
724 | Golden Krust Caribbean Restaurant | Caribbean Restaurant | 40.647003 | -73.883489 |
728 | Chloe's Restaurant and Lounge | Caribbean Restaurant | 40.637569 | -73.897368 |
729 | Double Dragon Chinese Food | Asian Restaurant | 40.633959 | -73.902186 |
731 | Yi Hong | Chinese Restaurant | 40.636047 | -73.899772 |
733 | Lin Wang | Thai Restaurant | 40.637561 | -73.897199 |
734 | Blue Mountain Farm | Caribbean Restaurant | 40.630974 | -73.928093 |
737 | Topaze Restaurant | Caribbean Restaurant | 40.626595 | -73.927438 |
750 | No. 1 Kitchen | Chinese Restaurant | 40.628989 | -73.923789 |
771 | Footprints Cafe | Caribbean Restaurant | 40.575592 | -73.983271 |
777 | Marty’s V Burger | Vegetarian / Vegan Restaurant | 40.574932 | -73.984353 |
783 | Ichi Sushi | Sushi Restaurant | 40.601774 | -73.993869 |
784 | Pino's Ristorante | Italian Restaurant | 40.600955 | -74.000806 |
786 | German Chocolate Cake | German Restaurant | 40.596284 | -73.997543 |
789 | Istanbul Turkish Fast Food & Restaurant | Turkish Restaurant | 40.601771 | -73.993856 |
792 | Lazzat Restaurant | Restaurant | 40.601619 | -74.001519 |
793 | Casa Edesia Pizza and Grill | Italian Restaurant | 40.599751 | -74.002672 |
795 | La granja | Peruvian Restaurant | 40.602023 | -74.003039 |
796 | Charisma Bay | Chinese Restaurant | 40.601963 | -73.994462 |
801 | Choi Fook | Dim Sum Restaurant | 40.603801 | -73.997060 |
802 | Golden Bay Restaurant | Cantonese Restaurant | 40.602534 | -73.995032 |
804 | Happy Seafood Restaurant | Chinese Restaurant | 40.602505 | -73.995053 |
808 | Orchidea | American Restaurant | 40.636390 | -73.993899 |
818 | Spoons | Restaurant | 40.634364 | -73.992624 |
831 | China Glatt | Chinese Restaurant | 40.637381 | -73.989255 |
843 | Jordan's Lobster Dock | Seafood Restaurant | 40.586655 | -73.929179 |
851 | TGI Fridays | Restaurant | 40.586918 | -73.928955 |
861 | new grand wok | Chinese Restaurant | 40.609311 | -73.931668 |
869 | LaRina Pastificio & Vino | Italian Restaurant | 40.693190 | -73.970393 |
872 | Bar Bolinas | Restaurant | 40.693341 | -73.967245 |
876 | Da Ciro Brooklyn | Italian Restaurant | 40.693140 | -73.967176 |
880 | Thaiholic | Thai Restaurant | 40.693233 | -73.971299 |
881 | Damas Falafel House | Falafel Restaurant | 40.693102 | -73.969570 |
882 | Myrtle Thai | Thai Restaurant | 40.693226 | -73.968052 |
883 | Thai 101 | Thai Restaurant | 40.693220 | -73.967527 |
884 | Kum Kau | Chinese Restaurant | 40.693373 | -73.966753 |
887 | Soco | Cajun / Creole Restaurant | 40.693698 | -73.964526 |
888 | GB Crown Tavern | Restaurant | 40.693296 | -73.969301 |
902 | Gold Star Food | American Restaurant | 40.577187 | -74.002121 |
906 | Daigo Hand Roll Bar | Japanese Restaurant | 40.691259 | -73.982603 |
907 | Han Dynasty | Chinese Restaurant | 40.691334 | -73.982456 |
918 | Charm Kao | Thai Restaurant | 40.689212 | -73.986250 |
922 | Xi'an Famous Foods | Chinese Restaurant | 40.692170 | -73.986730 |
930 | Kotti Berliner Döner Kebab | Restaurant | 40.690662 | -73.983533 |
932 | Grand Army | Seafood Restaurant | 40.688329 | -73.986612 |
933 | Rucola | Italian Restaurant | 40.685659 | -73.985769 |
934 | Rice & Miso | Japanese Restaurant | 40.684633 | -73.983768 |
935 | Bedouin Tent | Middle Eastern Restaurant | 40.686936 | -73.984469 |
936 | Taiki | Sushi Restaurant | 40.684500 | -73.983783 |
946 | Masala Grill | Indian Restaurant | 40.685540 | -73.981202 |
958 | Bacchus Bistro & Wine Bar | French Restaurant | 40.686870 | -73.984465 |
959 | Grand Army | Seafood Restaurant | 40.688329 | -73.986612 |
966 | Gandhi Fine Indian Cuisine | Indian Restaurant | 40.655168 | -73.956325 |
968 | Camillo | Italian Restaurant | 40.659626 | -73.950568 |
969 | Mo’s Original | Ramen Restaurant | 40.661301 | -73.953437 |
975 | Silver Rice | Sushi Restaurant | 40.659673 | -73.960368 |
980 | Errol's Caribbean Bakery | Caribbean Restaurant | 40.657160 | -73.960204 |
981 | El Castillo de Jagua | Spanish Restaurant | 40.656685 | -73.960068 |
982 | Edie Jo’s | American Restaurant | 40.657942 | -73.960655 |
989 | Culpepper's | Caribbean Restaurant | 40.660419 | -73.952553 |
991 | Soldiers Jamaican | Caribbean Restaurant | 40.655912 | -73.950138 |
995 | Magic Soul Food | Southern / Soul Food Restaurant | 40.676342 | -73.910610 |
1003 | Good Taste Chinese Restaurant | Chinese Restaurant | 40.679237 | -73.910843 |
1008 | Abuela Antonia | Mexican Restaurant | 40.675330 | -73.913105 |
1022 | El Rey II Restaurant | Latin American Restaurant | 40.678183 | -73.869876 |
1027 | Barzola | South American Restaurant | 40.681656 | -73.871405 |
1031 | El Castillo De Jagua | Cuban Restaurant | 40.677615 | -73.864201 |
1045 | Fulkole Restaurant | Bangladeshi Restaurant | 40.679224 | -73.864764 |
1050 | Yang Kee's Chinese Kitchen | Chinese Restaurant | 40.677631 | -73.864197 |
1068 | Island Express | Caribbean Restaurant | 40.647111 | -73.958108 |
1073 | Golden Krust Caribbean Restaurant | Caribbean Restaurant | 40.648983 | -73.964345 |
1074 | Flatbush Latin Grill | Latin American Restaurant | 40.649627 | -73.961953 |
1075 | Mallenche Mexican Grill | Mexican Restaurant | 40.649048 | -73.964237 |
1077 | Fisherman's Cove | Caribbean Restaurant | 40.650217 | -73.960017 |
1081 | La Cabana Rodriguez | Latin American Restaurant | 40.644880 | -73.958007 |
1082 | Los Tres Chiflados | Mexican Restaurant | 40.645534 | -73.958110 |
1103 | Chipotle Mexican Grill | Mexican Restaurant | 40.626405 | -73.916976 |
1104 | Landi's Pork Store | Italian Restaurant | 40.619633 | -73.917918 |
1107 | Gourmet Grill | American Restaurant | 40.619543 | -73.916111 |
1118 | Sosaku | Japanese Restaurant | 40.619384 | -73.916243 |
1130 | Champs Diner | Vegetarian / Vegan Restaurant | 40.708335 | -73.940816 |
1147 | Win Son | Taiwanese Restaurant | 40.707430 | -73.943359 |
1159 | Tabaré | South American Restaurant | 40.713069 | -73.959031 |
1161 | Birds of a Feather | Chinese Restaurant | 40.714262 | -73.960572 |
1169 | Samurai Mama | Japanese Restaurant | 40.714114 | -73.960196 |
1173 | Caracas Arepa Bar | Arepa Restaurant | 40.713075 | -73.957462 |
1174 | Tacombi | Mexican Restaurant | 40.714992 | -73.959375 |
1180 | Bozu | Sushi Restaurant | 40.712976 | -73.957478 |
1184 | Maison Premiere | Seafood Restaurant | 40.714239 | -73.961512 |
1185 | St. Anselm | American Restaurant | 40.714145 | -73.955984 |
1186 | by CHLOE. | Vegetarian / Vegan Restaurant | 40.715214 | -73.959363 |
1188 | Traif | Tapas Restaurant | 40.710557 | -73.958895 |
1189 | Xixa | Latin American Restaurant | 40.710410 | -73.958531 |
1194 | Bozu | Sushi Restaurant | 40.712976 | -73.957478 |
1198 | Caracas Arepa Bar | Arepa Restaurant | 40.713075 | -73.957462 |
1200 | Tabaré | South American Restaurant | 40.713069 | -73.959031 |
1204 | Desnuda Williamsburg | South American Restaurant | 40.712986 | -73.958958 |
1209 | Cerveceria Havemeyer | Mexican Restaurant | 40.711820 | -73.957396 |
1211 | Walter Sports | American Restaurant | 40.713444 | -73.958582 |
1213 | Noods n’ Chill | Thai Restaurant | 40.711936 | -73.961077 |
1216 | Shalom Japan | Japanese Restaurant | 40.709219 | -73.955839 |
1226 | Pescada | Jewish Restaurant | 40.609418 | -73.968770 |
1230 | Sushi Royale | Sushi Restaurant | 40.609146 | -73.970333 |
1231 | Sushi Moto | Sushi Restaurant | 40.615398 | -73.963646 |
1233 | King Solomon Glatt Kosher | Eastern European Restaurant | 40.613804 | -73.962738 |
1235 | Vinnies Luncheonette | Restaurant | 40.614137 | -73.974000 |
1238 | Campania Coal Fired Pizza | Italian Restaurant | 40.613466 | -74.033237 |
1241 | Shobu Sushi | Sushi Restaurant | 40.615996 | -74.031026 |
1244 | Fushimi | Japanese Restaurant | 40.617270 | -74.031010 |
1250 | Positano | Italian Restaurant | 40.612385 | -74.034059 |
1254 | ha ha chinese | Chinese Restaurant | 40.618022 | -74.030310 |
1262 | Win Hing Chinese Cuisine | Asian Restaurant | 40.613663 | -74.032858 |
1265 | The Common | Restaurant | 40.617844 | -74.033624 |
1266 | Suki Sushi Bay Ridge | Japanese Restaurant | 40.619107 | -74.032848 |
1273 | Cafe Tibet | Tibetan Restaurant | 40.641243 | -73.964064 |
1277 | Island Express | Caribbean Restaurant | 40.647111 | -73.958108 |
1278 | La Cabana Rodriguez | Latin American Restaurant | 40.644880 | -73.958007 |
1282 | Manchego | Tapas Restaurant | 40.641104 | -73.964285 |
1283 | Los Tres Chiflados | Mexican Restaurant | 40.645534 | -73.958110 |
1287 | Cam Tak Express Restaurant | Chinese Restaurant | 40.644370 | -73.957677 |
1289 | Koko Ramen | Ramen Restaurant | 40.641020 | -73.964408 |
1296 | Golden Krust Caribbean Bakery and Grill | Caribbean Restaurant | 40.647065 | -73.958116 |
1317 | Pho-men On Troy | Vietnamese Restaurant | 40.664280 | -73.936996 |
1322 | Fun City | Seafood Restaurant | 40.652464 | -73.924499 |
1326 | C & J Jamaican Restaurant | Caribbean Restaurant | 40.653232 | -73.930493 |
1334 | Linda's Restaurant | Caribbean Restaurant | 40.652162 | -73.926740 |
1341 | Brucee's Patties | Caribbean Restaurant | 40.655302 | -73.916180 |
1345 | Golden Krust Caribbean Restaurant | Caribbean Restaurant | 40.655818 | -73.915774 |
1348 | Silver Krust Restaurant | Caribbean Restaurant | 40.651307 | -73.918014 |
1364 | Lee Chinese Restaraunt | Chinese Restaurant | 40.660728 | -73.884933 |
1368 | Number 1 Chinese Food | Asian Restaurant | 40.659682 | -73.884715 |
1371 | Lechonera Resurant | Latin American Restaurant | 40.666121 | -73.883429 |
1374 | LOMA #4 | Spanish Restaurant | 40.666436 | -73.882682 |
1377 | Double Dragon Chinese Food | Asian Restaurant | 40.633959 | -73.902186 |
1382 | Yoshi | Japanese Restaurant | 40.615668 | -73.918056 |
1386 | Gourmet Grill | American Restaurant | 40.619543 | -73.916111 |
1388 | Landi's Pork Store | Italian Restaurant | 40.619633 | -73.917918 |
1392 | Lima Peruvian Restaurant | Peruvian Restaurant | 40.617069 | -73.909767 |
1394 | Sosaku | Japanese Restaurant | 40.619384 | -73.916243 |
1397 | ChinaTokyo | Chinese Restaurant | 40.619431 | -73.917940 |
1403 | Empire Grill | Middle Eastern Restaurant | 40.613560 | -73.912292 |
1405 | Mr. Kam | Chinese Restaurant | 40.619384 | -73.915760 |
1418 | Luke's Lobster | Seafood Restaurant | 40.703441 | -73.994091 |
1419 | The River Café | American Restaurant | 40.703754 | -73.994834 |
1420 | Gran Eléctrica | Mexican Restaurant | 40.702570 | -73.993096 |
1432 | Cecconi's | Italian Restaurant | 40.703759 | -73.991548 |
1435 | The Osprey | American Restaurant | 40.702360 | -73.995523 |
1439 | Vinegar Hill House | American Restaurant | 40.702686 | -73.981260 |
1451 | Los Papis | Latin American Restaurant | 40.702087 | -73.985044 |
1474 | Hardee | Chinese Restaurant | 40.671893 | -73.930841 |
1476 | Primitos Restaurant | American Restaurant | 40.672226 | -73.930810 |
1482 | China Garden | Chinese Restaurant | 40.674573 | -73.930574 |
1487 | Golden Krust Caribbean Restaurant | Caribbean Restaurant | 40.676571 | -73.900502 |
1498 | Gonzo Fish and Wings | Seafood Restaurant | 40.676313 | -73.900533 |
1510 | Westville DUMBO | American Restaurant | 40.702021 | -73.989596 |
1526 | Cecconi's | Italian Restaurant | 40.703759 | -73.991548 |
1530 | Celestine | Mediterranean Restaurant | 40.704537 | -73.988026 |
1536 | El Mexicano Restaurante & Cafe Inc | Mexican Restaurant | 40.598543 | -73.956353 |
1537 | Stolovaya | Russian Restaurant | 40.598192 | -73.962555 |
1538 | Golden "Z" Restaurant | Chinese Restaurant | 40.598758 | -73.957010 |
1539 | Phở Vietnam | Vietnamese Restaurant | 40.598667 | -73.958486 |
1540 | Wing Hing Seafood Restaurant | Chinese Restaurant | 40.598509 | -73.959570 |
1542 | Fuciaana Asian Food & Crystal Grill | Asian Restaurant | 40.596374 | -73.961098 |
1546 | Three Star Restaurant | American Restaurant | 40.599043 | -73.954987 |
1552 | La Villita Mexican Restaurant | Mexican Restaurant | 40.598712 | -73.958414 |
1558 | Sushi MiKasa | Sushi Restaurant | 40.594120 | -73.958781 |
1567 | Tavares Restaurant | Latin American Restaurant | 40.679397 | -73.885647 |
1576 | Restaurante Maria Internacional | Spanish Restaurant | 40.677613 | -73.891376 |
1577 | Michael's | Italian Restaurant | 40.607520 | -73.943044 |
1585 | Savor Cafe | Restaurant | 40.612250 | -73.944312 |
1587 | Exquisite Delight | Caribbean Restaurant | 40.649091 | -73.949243 |
1590 | Tastee Pattee | Caribbean Restaurant | 40.650850 | -73.947838 |
1594 | Caribbean Vibes | Caribbean Restaurant | 40.651227 | -73.949675 |
1608 | China Kitchen | Chinese Restaurant | 40.650765 | -73.946188 |
staten_data = boroughs[boroughs['Borough'] == 'Staten Island'].reset_index(drop = True)
rad = 500
staten_venues = pd.DataFrame()
for i, row in staten_data.iterrows():
lat = staten_data.loc[i, 'Latitude']
lng = staten_data.loc[i, 'Longitude']
url = 'https://api.foursquare.com/v2/venues/explore?&client_id={}&client_secret={}&v={}&ll={},{}&radius={}'.format(
CLIENT_ID,
CLIENT_SECRET,
VERSION,
lat,
lng,
rad)
url
result = requests.get(url).json()
venues = result['response']['groups'][0]['items']
nearby_venues = json_normalize(venues)
filtered_columns = ['venue.name', 'venue.categories', 'venue.location.lat', 'venue.location.lng']
nearby_venues = nearby_venues.loc[:, filtered_columns]
nearby_venues['venue.categories'] = nearby_venues.apply(get_category_type, axis=1)
nearby_venues.columns = [col.split(".")[-1] for col in nearby_venues.columns]
for k, vals in nearby_venues.iterrows():
venue_row = pd.Series(vals.values)
staten_venues = staten_venues.append(venue_row, ignore_index = True)
--------------------------------------------------------------------------- KeyError Traceback (most recent call last) <ipython-input-31-2a7f43ff1104> in <module> 22 23 filtered_columns = ['venue.name', 'venue.categories', 'venue.location.lat', 'venue.location.lng'] ---> 24 nearby_venues = nearby_venues.loc[:, filtered_columns] 25 26 nearby_venues['venue.categories'] = nearby_venues.apply(get_category_type, axis=1) /opt/conda/envs/Python36/lib/python3.6/site-packages/pandas/core/indexing.py in __getitem__(self, key) 1492 except (KeyError, IndexError, AttributeError): 1493 pass -> 1494 return self._getitem_tuple(key) 1495 else: 1496 # we by definition only have the 0th axis /opt/conda/envs/Python36/lib/python3.6/site-packages/pandas/core/indexing.py in _getitem_tuple(self, tup) 886 continue 887 --> 888 retval = getattr(retval, self.name)._getitem_axis(key, axis=i) 889 890 return retval /opt/conda/envs/Python36/lib/python3.6/site-packages/pandas/core/indexing.py in _getitem_axis(self, key, axis) 1900 raise ValueError('Cannot index with multidimensional key') 1901 -> 1902 return self._getitem_iterable(key, axis=axis) 1903 1904 # nested tuple slicing /opt/conda/envs/Python36/lib/python3.6/site-packages/pandas/core/indexing.py in _getitem_iterable(self, key, axis) 1203 # A collection of keys 1204 keyarr, indexer = self._get_listlike_indexer(key, axis, -> 1205 raise_missing=False) 1206 return self.obj._reindex_with_indexers({axis: [keyarr, indexer]}, 1207 copy=True, allow_dups=True) /opt/conda/envs/Python36/lib/python3.6/site-packages/pandas/core/indexing.py in _get_listlike_indexer(self, key, axis, raise_missing) 1159 self._validate_read_indexer(keyarr, indexer, 1160 o._get_axis_number(axis), -> 1161 raise_missing=raise_missing) 1162 return keyarr, indexer 1163 /opt/conda/envs/Python36/lib/python3.6/site-packages/pandas/core/indexing.py in _validate_read_indexer(self, key, indexer, axis, raise_missing) 1244 raise KeyError( 1245 u"None of [{key}] are in the [{axis}]".format( -> 1246 key=key, axis=self.obj._get_axis_name(axis))) 1247 1248 # We (temporarily) allow for some missing keys with .loc, except in KeyError: "None of [Index(['venue.name', 'venue.categories', 'venue.location.lat',\n 'venue.location.lng'],\n dtype='object')] are in the [columns]"
staten_venues.rename(columns = {0: "Name", 1: "Category", 2: "Latitude", 3: "Longitude"}, inplace = True)
staten_restaurants = staten_venues[staten_venues['Category'].str.contains('Restaurant')]
staten_restaurants = staten_restaurants[staten_restaurants['Category'] != 'Fast Food Restaurant']
staten_restaurants
Name | Category | Latitude | Longitude | |
---|---|---|---|---|
0 | Beso | Tapas Restaurant | 40.643306 | -74.076508 |
7 | Enoteca Maria | Italian Restaurant | 40.641941 | -74.077320 |
9 | Marie's 2 | Italian Restaurant | 40.642176 | -74.076669 |
10 | The Gavel Grill | American Restaurant | 40.642157 | -74.076674 |
26 | Papa's Halal Chicken & Kebab | Falafel Restaurant | 40.643683 | -74.077483 |
43 | Lakruwana | Sri Lankan Restaurant | 40.625654 | -74.075174 |
44 | Bay House Bistro | Asian Restaurant | 40.627827 | -74.076244 |
46 | Campo Bello Restaurante | Spanish Restaurant | 40.624463 | -74.079652 |
48 | El Patron Restaurant & Lounge Inc. | Mexican Restaurant | 40.629154 | -74.076541 |
53 | Vida | Restaurant | 40.628723 | -74.079802 |
67 | Bayou | Cajun / Creole Restaurant | 40.616853 | -74.068161 |
68 | Tony's Brick Oven Pizzeria | Italian Restaurant | 40.615180 | -74.067279 |
71 | Bin 5 | Italian Restaurant | 40.613278 | -74.065459 |
73 | Phil-Am Kusina | Filipino Restaurant | 40.612426 | -74.071455 |
74 | Korzo Klub | Eastern European Restaurant | 40.618819 | -74.069430 |
75 | Maizal | Mexican Restaurant | 40.618335 | -74.069547 |
78 | Convenient Food Mart | Restaurant | 40.612013 | -74.070612 |
87 | Yummy Taco | Mexican Restaurant | 40.616481 | -74.068183 |
91 | Molo | American Restaurant | 40.618391 | -74.069160 |
92 | Mazial | Mexican Restaurant | 40.618556 | -74.069469 |
96 | Panini Grill | Italian Restaurant | 40.630137 | -74.108156 |
100 | Burrito Bar | Mexican Restaurant | 40.630238 | -74.108776 |
109 | Cafe Milano | Italian Restaurant | 40.631014 | -74.102905 |
111 | Nürnberger Bierhaus | German Restaurant | 40.634765 | -74.109549 |
113 | Randall Manor Tavern | American Restaurant | 40.634736 | -74.107501 |
119 | Kyoto Sushi 5 | Japanese Restaurant | 40.630824 | -74.103289 |
145 | Bella Mama Rose Italian Restaurant | Italian Restaurant | 40.631772 | -74.146950 |
148 | bella mama rosa staten island | Italian Restaurant | 40.631750 | -74.147008 |
160 | Tokyo Sushi Japanese | Japanese Restaurant | 40.613121 | -74.120907 |
167 | How Greek Is It 2 | Restaurant | 40.613079 | -74.121753 |
168 | Spice Rack | Indian Restaurant | 40.613330 | -74.123173 |
175 | Holy Schnitzel | Restaurant | 40.589778 | -74.164390 |
179 | QDOBA Mexican Eats | Mexican Restaurant | 40.590926 | -74.164461 |
191 | Peking Taste IV | Chinese Restaurant | 40.590757 | -74.164559 |
192 | Island Kitchen | Chinese Restaurant | 40.590048 | -74.165303 |
194 | El Pollo II Restaurant | Spanish Restaurant | 40.590629 | -74.191982 |
210 | La Strada | Italian Restaurant | 40.573743 | -74.115627 |
213 | Taste Of India II | Indian Restaurant | 40.572127 | -74.112674 |
216 | Brioso | Italian Restaurant | 40.573052 | -74.114789 |
217 | Cantina Mexicana | Mexican Restaurant | 40.573802 | -74.116061 |
219 | Nori | Sushi Restaurant | 40.573737 | -74.117523 |
222 | Little Italy Gourmet | Italian Restaurant | 40.574565 | -74.116150 |
224 | Jade Asian Bistro | Dim Sum Restaurant | 40.571484 | -74.111447 |
227 | Pho Rainbow | Vietnamese Restaurant | 40.573792 | -74.116625 |
228 | Crown Palace | Chinese Restaurant | 40.572840 | -74.114302 |
240 | Arirang Hibachi Steakhouse | Japanese Restaurant | 40.549539 | -74.150123 |
243 | Piccolino's italian Restaurant | Italian Restaurant | 40.551538 | -74.149746 |
249 | Lucky Fortune Chinese Restaurant | Chinese Restaurant | 40.551275 | -74.150083 |
250 | La Candela Espanola | Spanish Restaurant | 40.551469 | -74.149436 |
253 | Benvenuti Pizzeria e Trattoria | Italian Restaurant | 40.551205 | -74.150175 |
258 | Gusto Restaurant | Italian Restaurant | 40.551670 | -74.149811 |
264 | Kiku Sushi | Sushi Restaurant | 40.544350 | -74.165691 |
270 | Giovannis Trattoria | Italian Restaurant | 40.545119 | -74.165951 |
272 | TOMO Japanese Cuisine | Sushi Restaurant | 40.542835 | -74.165578 |
282 | East Sushi | Sushi Restaurant | 40.545171 | -74.161357 |
284 | Aka Sushi | Sushi Restaurant | 40.545318 | -74.160197 |
290 | Tomo | Japanese Restaurant | 40.543011 | -74.165703 |
294 | Il Sogno | Restaurant | 40.541286 | -74.178489 |
295 | Angelos Pizza | American Restaurant | 40.540369 | -74.177033 |
303 | Misaki Sushi | Sushi Restaurant | 40.542515 | -74.207388 |
306 | QDOBA Mexican Eats | Mexican Restaurant | 40.542108 | -74.207452 |
319 | Islander Taste I | Chinese Restaurant | 40.542727 | -74.207586 |
322 | Don Cesar Mexican | Mexican Restaurant | 40.508984 | -74.246680 |
324 | Villaggio | Italian Restaurant | 40.509285 | -74.246597 |
330 | Taqueria El Gallo Azteca | Mexican Restaurant | 40.638402 | -74.078678 |
340 | Golden Krust Caribbean Bakery and Grill | Caribbean Restaurant | 40.637981 | -74.076454 |
346 | M&K Spanish Restaurant | Spanish Restaurant | 40.637543 | -74.076827 |
354 | The Veranda Cafe | American Restaurant | 40.622377 | -74.097934 |
Extracts total number of restaurants form each above dataframe.
bronx_num_res = bronx_restaurants.shape[0]
man_num_res = manhattan_restaurants.shape[0]
queens_num_res = queens_restaurants.shape[0]
bro_num_res = brooklyn_restaurants.shape[0]
staten_num_res = staten_restaurants.shape[0]
per_capita_restaurants = pd.DataFrame (
{
"Bronx RPC": [bronx_num_res/1418207],
"Brooklyn RPC": [bro_num_res/2559903],
"Manhattan RPC": [man_num_res/1628706],
"Queens RPC": [queens_num_res/2253858],
"Staten Island RPC": [staten_num_res/476143],
}
)
per_capita_restaurants
Bronx RPC | Brooklyn RPC | Manhattan RPC | Queens RPC | Staten Island RPC | |
---|---|---|---|---|---|
0 | 0.00013 | 0.000136 | 0.000198 | 0.000175 | 0.000143 |
restaurants per capita, total accomodation and food services (per billion), median gross rent
Import libraries to create a decision tree.
from sklearn.tree import DecisionTreeClassifier
from sklearn.model_selection import train_test_split
Create training and testing datasets.
y = final.index
X = final[['RPC (for every thousand people)', 'TAF (per billion)', 'MGR (per thousand)']].values
X_trainset, X_testset, y_trainset, y_testset = train_test_split(X, y, test_size=0.3, random_state=3)
Create decision tree
boroughTree = DecisionTreeClassifier(criterion="entropy", max_depth = 4)
boroughTree.fit(X_trainset,y_trainset)
DecisionTreeClassifier(class_weight=None, criterion='entropy', max_depth=4, max_features=None, max_leaf_nodes=None, min_impurity_decrease=0.0, min_impurity_split=None, min_samples_leaf=1, min_samples_split=2, min_weight_fraction_leaf=0.0, presort=False, random_state=None, splitter='best')
Import plotting libraries
!conda install -c conda-forge pydotplus -y
!conda install -c conda-forge python-graphviz -y
from sklearn.externals.six import StringIO
import pydotplus
import matplotlib.image as mpimg
from sklearn import tree
%matplotlib inline
import matplotlib.pyplot as plt