My objective for this project was to find how many open resturant applications were approved in NYC. An open resturant applications is applying for permission to seat customers outside due to the COVID-19 pandemic. The question I looked to answer for this project was, did more restaurants receive permission for outdoor dining? I used the pandas librabry to create dataframes and filter the data
Total applications submitted: 13001
Sidewalk Seating Application Results: yes 10963 no 2038
Percentage of sidewalk seating applications approved: 84.32 %
Roadway Seating Application Results: yes 8335 no 4666
Percentage of roadway seating applications approved: 64.11 %
Total applications submitted: 2564
Sidewalk Seating Application Results: yes 2275 no 289
Percentage of sidewalk seating applications approved: 88.73%
Roadway Seating Application Results: yes 1601 no 963
Percentage of roadway seating applications approved: 62.44%
Manhattan:Total applications submitted: 6351
Sidewalk Seating Application Results: yes 5187 no 1164
Percentage of sidewalk seating applications approved: 81.67%
Roadway Seating Application Results: yes 4176 no 2175
Percentage of roadway seating applications approved: 65.75%
Brooklyn:Total applications submitted: 3189
Sidewalk Seating Application Results: yes 2675 no 514
Percentage of sidewalk seating applications approved: 83.88%
Roadway Seating Application Results: yes 2060 no 1129
Percentage of roadway seating applications approved: 64.6%
The Bronx:Total applications submitted: 700
Sidewalk Seating Application Results: yes 648 no 52
Percentage of sidewalk seating applications approved: 92.57%
Roadway Seating Application Results: yes 402 no 298
Percentage of roadway seating applications approved: 57.43%
Staten Island:Total applications submitted: 197
Sidewalk Seating Application Results: yes 178 no 19
Percentage of sidewalk seating applications approved: 90.36%
Roadway Seating Application Results: yes 96 no 101
Percentage of roadway seating applications approved: 48.73%
Queens ranked 3rd on number of applications submitted. Permission for either sidewalk or roadway seating had over a 50% approval rate.
Manhattan had the most applications submitted with 6351! Permission for either sidewalk or roadway seating had over a 50% approval rate. Manhattan had the highest percentage of roadway seating applications approved, with 64.6%
Brooklyn had the second most applications submitted with 3189. Permission for either sidewalk or roadway seating had over a 50% approval rate.
The Bronx had the second least applications submitted with only 700. Permission for either sidewalk or roadway seating had over a 50% approval rate. The Bronx has the highest percentage of sidewalk seating applications approved with 92.57%
Staten Island only had 197 applications filled out, ranking the lowest out of the five boroughs. Over 90% of applications for sidwalk seating were approved, the second highest in NYC! However, only 48.73% of applications for roadway seating were approved. This is the lowest percentage in all of NYC
I first used the pandas library to create a dataframe to hold the data for the open resturant applications. I then used shape with an index of 0 to get all of the rows in the dataset (this would represent how many applications were filled out). I used value_counts to count all values for when there was an approval/denial for sidewalk/roadway seating. I calculated percentages by dividing the number from value_counts by the total applications. I then multiplied that number by 100 and rounded to 2 decimal places to make it easier to read. To get the results for each borough, I created 5 new variables, one for each borough. I then linked the vriable to the original dataframe and used loc to find where all instances of a certain borough appeared. I then repeated the same proccess as I had done for the original dataset.