BC Executive Compensation Tableau Visualization

bc-public-salary-screenshot

The Province of British Columbia publishes public agency executive compensation each year. The data is grouped by: Sector – Employers are categorized in one of six sectors – Colleges, Crown Corporations, Education, Health, Public Service, Universities Employer – Employers belong to one Sector. There are about 190 employers such as BC Assessment Authority, BC Housing Continue Reading →

Twitter Followers and List Membership Tracking

twitter-follower-chart

I was curious to track how my Twitter account’s followers and my account’s list memberships changed over time. The results of my tracking are on this webpage. Twitter Followers – Twitter followers are other Twitter accounts who follow my account. A Twitter Follower may follow my account for a few days and Continue Reading →

Django form geocode submitted address to get lat, lon and postal code

django form

One of my Django applications includes a form where user can enter and submit a property address. The user submitting the form might not know the postal code so I left it optional. However the postal code is a key piece of information for this particular application so I wanted to ensure Continue Reading →

Leaflet.js choropleth map color by count using geoJSON datasource

map1

I have a Django web application that needed an interactive map with shapes corresponding to Canadian postal code FSA areas that were different colors based on how many properties were in each FSA. It ended up looking something like the screenshot below. This exercise turned out to be relatively easy Continue Reading →

Excel Power Query tutorial using Canadian potato production statistics

potatoe

This data comes from Statistics Canada. Statistics Canada download pages often provide the opportunity to modify the data structure and content before it is downloaded. For example clicking on the [Add/Remove data] link provides options select different groupings of data by provinces. I choose to group data by provinces. I Continue Reading →

Canadian TCS FDI Officers Twitter List Member Analysis – Updated

tcs

Blog post updated to add the following: Updated Python “TCS Members Details” code to get additional information from the List members’ profiles. New Python code “TCS Members Tweets” to download all List members’ Tweets. Will provide some more analysis on this new data soon. ————————————————– The Canadian Trade Commissioner Service maintains a Continue Reading →

Use OneDrive API to upload files to Office 365 Sharepoint Site

sharepoint python

I have automated uploading files from my web site host’s server to my Office 365 Sharepoint site using scheduled cron jobs running Python scripts on my web host. The Python scripts use Microsoft’s Azure Active Directory Library (ADAL) to authenticate off Azure Active Directory (Azure AD or ADD), and  OneDrive API and Python Continue Reading →