Skip to content

009co Consulting

Business Intelligence | Analytics | Digital Solutions

  • Welcome to 009co Consulting
  • Blog Posts
  • COVID-19 Data Analysis and Visualization
  • Environmental Science Projects

Category: Python

July 9, 2023: OpenAI Code Interpreter river flow analysis

December 8, 2021: CBC news article comments analysis

November 3, 2021: CBC news article comments web scraping

September 16, 2021: Canadian Government First Nations long term water advisory data

July 14, 2021: COVID-19 Data Analysis and Visualization Summary

July 8, 2021: TendiesTown.com – WallStreetBets gain and loss analysis

January 1, 2021: @SirPatStew #ASonnetADay dashboard

October 5, 2020: Amazon AWS Transcribe to get 2020 presidential debate #1 speaker segments

August 27, 2020: Amazon AWS Textract – WHO “Draft landscape of COVID-19 candidate vaccines” – convert PDF to csv

August 10, 2020: Periodic chart elements by origin from SVG using Python

July 15, 2020: Retrieve and process Environment Canada hydrometric and climate data using Python

July 12, 2020: Plotly Express Python remove legend title

May 9, 2020: Scraping public health web page using Python, BeautifulSoup4, Requests and Pandas

April 19, 2020: Choropleth map of Canada COVID-19 cases by health region using Leaflet and D3.js

January 1, 2020: Prepaid and gift credit card feature comparison for multiple countries

August 9, 2018: How to use Python as a datasource for Power BI

October 22, 2016: BC Executive Compensation Tableau Visualization

October 16, 2016: Twitter Followers and List Membership Tracking

August 6, 2016: Django form geocode submitted address to get lat, lon and postal code

August 6, 2016: Leaflet.js choropleth map color by count using geoJSON datasource

July 21, 2016: Python get image color palette

July 16, 2016: Django recreate database table

July 9, 2016: Canadian TCS FDI Officers Twitter list member analysis

June 8, 2016: How to use Google Adsense API to download Adsense data

June 1, 2016: Create Python 3 Virtualenv on machine with Python 2 & 3 installed

May 26, 2016: Use OneDrive API to upload files to Office 365 Sharepoint Site

May 18, 2016: OneDrive API features

February 12, 2016: Tracking Cuba Gooding Jr’s Twitter follower count

January 29, 2016: Dell ecommerce web site scraping analysis

January 29, 2016: Always remember to start Python Virtualenv

January 29, 2016: Flask SQLAlchemy relationship associations and backref

January 29, 2016: Get list of custom segments from Google Analytics API

January 29, 2016: BC Hydro’s amazing #BCStorm social media turnaround

January 23, 2016: How to filter referral spam from Google Analytics using API and Python

January 22, 2016: Tableau vizualization of Toronto Dine Safe data

January 19, 2016: LinkedIn ‘People You May Know’ web scraping and analysis

Recent Blog Posts

  • Microsoft Windows Copilot General Availability September 26, 2023
  • Voip.ms getCDR API – get all call detail records
  • OpenAI Code Interpreter river flow analysis
  • Fabric Dataflow Gen2 Web API connection with dynamic current date parameter
  • CBC news article comments analysis
  • Canada cell tower distribution
  • CBC news article comments web scraping
  • Xero.com data and reporting
  • Canadian Government First Nations long term water advisory data
  • COVID-19 Data Analysis and Visualization Summary

Blog Categories

  • Amazon Web Services (AWS) (7)
  • API (10)
  • Azure (4)
  • BeautifulSoup (5)
  • Business Intelligence (3)
  • CakePHP (3)
  • Chart.js (2)
  • ChatGPT (1)
  • D3.js (6)
  • Django (7)
  • Environmental science (3)
  • ERP (1)
  • Excel Pivot Chart (4)
  • Excel Pivot Table (4)
  • Fabric (1)
  • Flask (1)
  • Geocoding (6)
  • Google Adsense (1)
  • Google Analytics (3)
  • Google Calendar (1)
  • Google Charts (2)
  • Google Maps API (2)
  • Google Script (1)
  • Hadoop (2)
  • Javascript (14)
  • Microsoft Copilot (1)
  • MS Access (1)
  • MySQL (2)
  • NetworkX (1)
  • NLTK (2)
  • Office 365 (8)
  • OneDrive (4)
  • Open Data (1)
  • Palm Pilot (1)
  • PHP (4)
  • Plotly (7)
  • Postgres (2)
  • Power BI (12)
  • Power Query (11)
  • Python (36)
  • QGIS (1)
  • Qlikview (1)
  • SaaS (1)
  • Science (1)
  • Sharepoint (6)
  • SQLAlchemy (1)
  • Tableau (6)
  • Twitter API (6)
  • VBA (1)
  • Web Development (14)
  • Xero (1)

Recent Comments

  1. Curtis on Django form geocode submitted address to get lat, lon and postal codeMay 30, 2021

    Django forms have some complexity when first encountered. Recommend following any basic Django forms tutorial, and applying to your specific…

  2. NS on Django form geocode submitted address to get lat, lon and postal codeMay 30, 2021

    Ah yes that does help to clear it up. However, I’m facing an issue now that whenever my form is…

  3. Curtis on Django form geocode submitted address to get lat, lon and postal codeMay 25, 2021

    Hey NS, The data is saved to database by the form post action eg starting with: if request.method == 'POST':.…

  4. NS on Django form geocode submitted address to get lat, lon and postal codeMay 25, 2021

    Hi Curtis, I’m relatively new to django and I’m trying to create a Django application where i can get a…

  5. Curtis on Legend and polygon colors for Leaflet choropleth using Chroma.jsMay 5, 2021

    Looks like it is working fine but my code was missing a line break at the end of if then…

Login - Copyright 2021 009co

Proudly powered by WordPress