I thought it would be fun to rank each of Calgary’s quadrants against each other, to see which quadrant parties the most, which is very important to us university students as well. What else do we do when we’re done exams?
Obviously that is a bit difficult to do so I did the next best thing, I took business license data and focused on stores/restaurants with alcohol and cannabis.
I want Calgarians to see the city in a different light, and to see how many locations around the city you can go to get your party started.
Found the data on Open Calgary of Business License Data.
Used packages httr, lubridate, and jsonlite to call from an API within R to get the data.
Filtered for only currently LICENSED businesses. No expired businesses.
After that, I filtered the license types looking only for alcohol and cannabis related licenses using dplyr.
Then finally, I used stringr to search the address column, and then to add a new column called quadrant;
NW, NE, SE, SW
Legend:
Purple – Alcohol sales
Green – Cannabis sales
Initial views show us that Southern Calgary has the most alcohol and cannabis stores. First impression is that they party the most.
I would recommend downloading the PowerBI files from the Dropbox link above. From there you can scroll around Calgary, and check out your favourite spots!
Same findings as before, it looks like the Southern quadrants of Calgary dominate when it comes to partying (business license of Alcohol and Cannabis).
Interesting is how low the NW is to the four other quadrants, wonder if that has to do with Higher Income neighborhoods, or more family-oriented living in the North West.
Null hypothesis: Northern quadrants proportion of stores = city average
Alternative hypothesis: Northern quadrants proportion of stores < city average
For the two Northern locations, I did a less than hypothesis test. This was to test to see if their proportions were statistically less than the city average. Both tests gave us small p-values, allowing us to reject the null hypothesis, and go with the alternative hypothesis that the Northern quadrants do have a smaller proportion than the city average. Or more accurately, there is a lower number of places to purchase alcohol and cannabis in the North compared to the city average
Null hypothesis: Southern quadrants proportion of stores = city average
Alternative hypothesis: Southern quadrants proportion of stores > city average
In the Southern quadrants I went with greater than proportion tests due to what we saw in the visuals. Both the tests reject the null hypothesis, meaning that the Southern quadrants are truly the party areas of Calgary, or more accurately, there is higher number of locations to purchase alcohol and cannabis in the Southern quadrant compared to the city average.
In the end, it appears that the highest density or best place to go to party in Calgary will be the Southwest.
We found this throughout our visualizations and our proportion tests.
Moving forward, I wonder if I should divide the city into more quadrants as shown in the next picture.
I wonder, like I said previously about the NW, if higher income areas or family-oriented neighborhood affects the amount of locations where you can purchase alcohol and cannabis.
In the end, my conclusion seems to lead to more questions!