Opening a Caribbean Restaurant in New York
Introduction & Business Problem
The City of New York is the most famous and vibrant city in the United States. It is seen as a melting pot of cultures which means that is it likely to also be a melting pot for food. With this popularity, it provides an enabling environment for businesses of various types. New York City was home to nearly 8.5 million people in 2018, accounting for over 40% of the population of New York State and a slightly lower percentage of the New York metropolitan area, home to approximately 23.6 million. Over the last decade, the city has been growing faster than the region. The New York region continues to be by far the leading metropolitan gateway for legal immigrants admitted into the United States, which is why the focus of this project will be on Caribbean immigrants who want to open a restaurant. This final project explores the best locations for Caribbean restaurants throughout the city of New York.
· What is/are the best location(s) for Caribbean cuisine in New York City?
· In what Neighborhood and/or borough should the investor open a Caribbean restaurant to have the best chance of being successful?
· Where would I go to New York City to have the best Caribbean food?
· Data on New York City neighborhoods, boroughs, and their respective latitudes & longitudes, as well as the restaurant ratings and tips, are required.
· New York City location data containing the neighborhoods and boroughs, latitudes, and longitudes will be obtained from the data source: https://cocl.us/new_york_dataset
· All data related to locations and quality of Caribbean restaurants will be obtained via the FourSquare API utilized via the Request library in Python
• Data will be collected from https://cocl.us/new_york_dataset and cleaned and processed into a dataframe.
• FourSquare be used to locate all venues and then filtered by Caribbean restaurants. Ratings, tips, and likes by users will be counted and added to the dataframe.
• Data will be sorted based on rankings.
• Finally, the data will be visually assessed using graphing from Python libraries.
The results of my analysis can be seen below:
1) From the Data we can see that Queens has the highest number of Neighborhoods per Borough while Manhattan has the lowest.
2) From the Data we can see that Brooklyn has the highest numbers of Caribbean Restaurants per Borough while Staten Island has the lowest.
3) From the Data we can see that Prospect Park South of the Bronx has the highest number of Caribbean Restaurants among neighborhoods while Hamilton Heights Manhattan has the lowest.
4) Manhattan has the highest average rating for Caribbean Restaurants second to the Bronx, with Staten Island and Queens are at the low ratings of 6.0
5) Below is a visualization of the Average Scores of neighborhoods in NYC, we can see that Staten Island is more distributed than other clusters with ratings above 6.0.
Manhattan and Bronx have the best rated Caribbean restaurants on average. Staten Island and Manhattan have the least number of Caribbean Restaurants per borough while Brooklyn and Queens have the most. Prospect Park South in Brooklyn has the highest number of Caribbean Restaurants in all of NY. Brooklyn and Queens have the highest number of neighborhoods in NYC. Staten Island despite having average ratings, it has a high number of neighborhoods and the lowest number of Caribbean Restaurants which means that competition isn’t fierce and business can be distributed have the best shot of success, I would open a Caribbean restaurant in Staten Island. As a final note, all the above analyses is depended on the accuracy of Four-Square data. A more comprehensive analysis and future work would need to incorporate data from other external databases.