Author: shafquat

Front Porch The front porch was a complete DIY project. The railings were losing their colour and rusting. The steps had large gaps in them and the cement was chipping. I got some rust-proof black paint for the railings (and recoloured the house number as well). I used mortar mix and outdoor paint for the… Continue reading Home Renovations

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… Continue reading How to Host an R Shiny App on AWS EC2 via Shiny Server and RStudio Server on a Windows Machine

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… Continue reading How to Create an Interactive WebApp using R Shiny

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… Continue reading Using Python to Download Yahoo Fantasy Sports Data into a Spreadsheet

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… Continue reading Free Local Pickup Option with Shopify

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… Continue reading How to Tag Products on Instagram with a Shopify Site in 10 Steps

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… Continue reading Was there a Toronto Real Estate Bubble?

Snapchat Spectacles videos are simply amazing. They’re HD and you can rotate your phone to see more angles of the same video. Furthermore, the fact that they double up as sunglasses, allows you to take a stable video without carefully holding your phone out in front of you. Unfortunately you cannot currently take pictures with… Continue reading How to Import Snapchat Spectacles Videos into Instagram