Shinyapps.io is a great free resource for hosting your first Shiny app. However, the server space and computing power is quite limited. Upgrading to the cheapest option is $9/month which is more expensive than most web hosting companies. So is there another option to be able to host your Apps without making a dent in …
I am a Data Scientist for the City of Toronto and my objective for this project is to illustrate how citizens can use Open Data to create their own tools and dashboards to understand their locality better. Here is the application I developed. My code can be found on GitHub and if you’re a visual …
How to Create an Interactive WebApp using R Shiny Read More »
I’m the self appointed data steward for the office hockey pool. We award small prizes for the team with the highest points every month. This requires saving the total points and standings by team at the beginning of each month. In years past, that would require me to log in on the first of the …
Using Python to Download Yahoo Fantasy Sports Data into a Spreadsheet Read More »
Someone paid $76,477.50 CAD for a pair of tickets to Game 1 of the NBA Finals in Toronto. The average household income in Toronto is $65,929 CAD.The average ticket price of NBA Finals games in Toronto is $1,933 CAD. With these unbelievable numbers, what’s a fan to do? Do you fork over a month’s worth …
Dynamic Pricing: How MLSE Controlled the Sale of Raptors NBA Finals Tickets Read More »
Shopify is great! It helps you ship your products all across the world for discounted rates. But what happens when someone down the street orders from you? Are they going to pay the extra few bucks to get it shipped? Most e-commerce stores don’t have a physical location so they can’t just come down to …
UPDATE: AS OF SEPTEMBER 2019 FACEBOOK AND INSTAGRAM HAVE CHANGED SOME OF THEIR FEATURES AND THIS GUIDE IS OUTDATED. Feel free to try the steps and see if it’ll work for you, but beyond that I cannot help. Sorry! My wife runs an e-commerce website for artwork. Her main customer base is on social media …
How to Tag Products on Instagram with a Shopify Site in 10 Steps Read More »
The Toronto Municipal Election is scheduled for October 22, 2018. Incumbent mayor John Tory is running for re-election, but there is expected to be a lot of change in terms of those governing the city. Toronto City Council has added the new wards in the downtown core to account for the rising growth in population …
Background The Toronto Real Estate market (and it’s surrounding areas – the GTA) have been red hot coming into 2017. According to the Toronto Real Estate Board (TREB), home prices on average have risen over 65% from 2012 to 2017 (TREB Historic Statistics). I decided to pull the TREB numbers into an excel sheet and see …
I mentioned in a previous post on how to get (nearly) live stock data from Google Finance. However, if you start pulling data from different markets, daily historical rates won’t make sense as different markets are closed on different days. This causes problems when trying to figure out the correlation between stocks. A solution to …
Pulling Stock Data and Creating an Efficient Frontier in Excel Read More »
For this tutorial we will be using Google Sheets. Google Sheets is a great resource for scraping data from the internet and it’s free!