Unlock the Hidden Power of Your Fitbit Data FitSignals transforms your Fitbit data into comprehensive, interactive visualizations that reveal insights […]
FitSignals – Google Watch Fitbit data and visualization Read More »
A recent Google DeepMind project paper Scaling deep learning for materials discovery described using GNNs trained on a large and
DeepMind Materials new crystal structure data analysis Read More »
TLDR: It is pretty cool that you can directly leverage Deepmind’s cutting edge AI powered AlphaFold and AlphaMissense projects to
DeepMind AlphaMissense matched to 23andMe data Read More »
Voip.ms is a reliable, affordable and customizable VoIP service. Sign-up with my referral code to get $10 discount. Recently I
Voip.ms get call detail records and set call detail record filters using API Read More »
OpenAI ChatGPT 4 Advanced Data Analysis is pretty amazing! I put it to the test on some data I analysed
OpenAI ChatGPT 4 Advanced Data Analysis used to do river water flow analysis Read More »
This post is focuses on a project of the analysis of scaped comments from CBC News website articles. (BTW, there
CBC news article comments analysis and visualization Read More »
The CBC (Canadian Broadcasting Corporation) news website articles often have a comments section. It would be interesting to see the
CBC news comment and replies interaction network visualization Read More »
This post is focuses on a project where I scaped comments from CBC News website articles. (BTW, there are lots
CBC news article comments web scraping Read More »
The Government of Canada is working with Canadian First Nations communities to end long-term drinking water advisories which have been
Canadian Government First Nations long term water advisory data Read More »
This is a list of Canadian COVID-19 related data analysis and visualization that I created during 2020/21 pandemic. Canada COVID-19
COVID-19 Data Analysis and Visualization Summary Read More »
For a 16 month period, from February 2020 to June 2021, TendiesTown.com used the Reddit API in an automated process
TendiesTown.com – WallStreetBets gain and loss analysis Read More »
Sir Patrick Stewart @SirPatStew was doing Shakespeare Sonnet readings from his home during the COVID-19 lockdown and they were really
Sir Patrick Stewart @SirPatStew #ASonnetADay dashboard Read More »
TLDR: I used Amazon Transcribe to transcribe the first presidential debate audio that included timestamps for each word, to create
Amazon AWS Transcribe used to get 2020 presidential debate #1 speaker segments Read More »
TLDR: I extracted text from the WHO’s vaccine candidate PDF file using AWS Textract and made text into a set
This cool periodic chart of the elements shows source / origin of the chemical elements. Source: Wikipedia created by Cmglee
Periodic chart elements by origin from SVG using Python Read More »
Recently needed to get flow and level data for a watercourse hydrological station as well as regional precipitation data for
Retrieve and process Environment Canada hydrometric and climate data using Python Read More »
Plotly.py 4.5, Plotly Express no longer puts the = in trace names, because legends support titles (source). Prior to Plotly.py
Plotly Express Python remove legend title Read More »
During the 2020 COVID-19 pandemic in Canada I wanted to get COVID-19 confirmed cases counts data for the city of
Scraping public health web page using Python, BeautifulSoup4, Requests and Pandas Read More »
During the early days of the 2020 COVID-19 pandemic in Canada, I wanted to get better understanding of the geographical
Choropleth map of Canada COVID-19 cases by health region using Leaflet and D3.js Read More »
GlobalPrePaidCreditCard.com – Prepaid and gift credit card feature comparison for 9 countries. Sort and filter cards by features to find the
Step 1 – Download latest version of Power BI to get new features (version that came out in early August
How to use Python as a datasource for Power BI Read More »
The Province of British Columbia publishes public agency executive compensation each year. The data is grouped by: Sector – Employers
BC Executive Compensation Tableau Visualization Read More »
I have created my own historical reporting of my Twitter account followers and list memberships. I have hosted the reporting
Twitter Followers and List Membership Tracking Read More »
One of my Django applications includes a form where user can enter and submit a property address. The user submitting the form
Django form geocode submitted address to get lat, lon and postal code Read More »
I have a Django web application that needed an interactive map with shapes corresponding to Canadian postal code FSA areas
Leaflet.js choropleth map color by count using geoJSON datasource Read More »
I created a web application that included screenshots of about 190 country’s national statistics agencies website home page. I created the site
Python get image color palette Read More »
Django’s makemigrations and migrate commands are very useful to update existing database tables to reflect model changes. However if you
Django recreate database table Read More »
Blog post updated to add the following: Updated Python “TCS Members Details” code to get additional information from the List
Canadian TCS FDI Officers Twitter list member analysis Read More »
Google’s APIs make getting Adsense (or any other Google service) data easy to download. The code below downloads Adsense data
How to use Google Adsense API to download Adsense data Read More »
I have been using Python 2.7 for most of my Python work but have a few projects where I want
Create Python 3 Virtualenv on machine with Python 2 & 3 installed Read More »
I have automated uploading files from my web site host’s server to my Office 365 Sharepoint site using scheduled cron jobs running
Use OneDrive API to upload files to Office 365 Sharepoint Site Read More »
Microsoft has three file storage options: OneDrive Personal OneDrive Business Sharepoint These have recently been unified into one new OneDrive API https://dev.onedrive.com and oAuth
OneDrive API features Read More »
Happened to see Cuba Gooding Jr’s first tweet about 30 minutes or so after he created it. Update: @cubagoodingjr is no
Tracking Cuba Gooding Jr’s Twitter follower count Read More »
Once upon a time, I needed to find Dell monitor data to analyse. A quick search brought me to their eCommerce
Dell ecommerce web site scraping analysis Read More »
When learning to develop Django and Flask Python applications using virtual environment I did not know that I should activate
Always remember to start Python Virtualenv Read More »
Flask-SQLAlchemy relationship associations are useful to easily retrieve related records from a related Model. In a Python Flask application I
Flask SQLAlchemy relationship associations and backref Read More »
This is a post on how to create custom Google Analytics Profile Segments for the purpose of removing referral spam
Get list of custom segments from Google Analytics API Read More »
BC Hydro made an amazing social media turnaround to communicate with customers in crisis! Go BC Hydro! On August 29,
BC Hydro’s amazing #BCStorm social media turnaround Read More »
Google Analytics data has become incredibly polluted by “spam referrals” which inflate site visits with what are essentially spam advertisements
How to filter referral spam from Google Analytics using API and Python Read More »
The City of Toronto’s open data site includes the results of the city’s regular food and restaurant inspections. This data
Tableau vizualization of Toronto Dine Safe data Read More »
A while back LinkedIn sneakily vacuumed up all of my contacts from my phone via the Android Cardmunch app. Turns
LinkedIn ‘People You May Know’ web scraping and analysis Read More »