Best Bars in New York City
Many people go bars to connect, relax, have fun, and meet people. While others go to put an end to the monotonous life, stay in touch with friends, be seen, be heard, listen to music, watch games, etc. Whatever may be the intention of going, bar provides social lubricant to relax people. My sole intention of this project was to answer my friend’s question “Which is the best bar in New York city?” that I was unable to answer quantitatively when he asked me before his visit here. Prior to this project, I did not have any quantitative information regarding bars other than seeing Yelp or other similar applications for bars. With this project I intend to update my understanding of bars around New York city with my own quantitative measurements .
Questions expected to be answered after this project: Which neighborhood in New York City has the most active night life? Which are the best bars in New York city? Which day of the week is best and worst to go bars? What percentage of bars are wheel chair accessible? What percentage of bars have happy hours, bar TV, own parking, etc.
Methods and tools used: In order to collect data about bars in New York city, I scraped Yelp using Scrapy tool written in Python. All data cleaning, analysis and data visualization were performed in Pandas and NumPy. All my code including data are found in following git hub link https://github.com/basantdhital/MY_pro
Neighborhood with most active Night life: Before diving into the best New York city bars, I wanted to find out the neighborhood with most active night life in New York. For this, I plotted the bar plots of numbers of bars versus neighborhood. From bar plot, the top five neighborhood with most active night life were found to be Mid town West, Mid town East, East Village, Upper East Side, West Village.
Best Bars in New York City: In order to find best bars in New York city, I took account of popularity index defined by the product of the number of reviews and the bar ratings listed in the Yelp website. The best five bars in New York City on the basis of popularity index are shown below. Moreover, best bars were also found to have price range in the less expensive region.
Best and worst night for going bars: The best and worst night of a week to go bars were calculated from the popularity index and the best nights listed on individual bars page. For example, if the bar has listed the best night to be Friday, it was given value 1 for Friday and rest of the days in week were given zero. Then values in particular day of week was multiplied with the popularity index of each bar which was then summed over all the bars. Finally, whichever day of the week has the highest popularity index value was assigned the best night and that with the least value was worst night to go bars. The histogram of various night with popularity index is shown below:
Other useful informations: From the data I collected from the Yelp website, I calculated various percentage of different facilities in bars. In New York city, 30 percent bars are wheel chair accessible. Only 8.15 percent have bar dancing facility and 9.44 percent have their own parking garage. The percentage of bars that provide reservations, happy hours, and with bar TV are 51.23, 53.04, and 53.56, respectively.
Conclusions: I hope with these informations about bars will be helpful to choose your best bars in New York City. From business point of view, this project provides areas to improve such as bar parking, bar dancing, etc. in order to have successful bars in New York City.
Future directions: It would be nice to collect more information about male to female ratio in each bar by scraping the individual reviewers in each bar which I left for future. Male to female ratio might help people to choose right bar to go according to their interest. Finding zones of popular drinking site (may be using heat map) might provide driving industry new area to focus to expand their business in future.