Automating workflows with Python and PostgreSQL: A Step-by-Step Guide with Example CodeIn this article, we’ll explore how to connect Python to a PostgreSQL database using the psycopg2 library. We'll also walk through the…Dec 28, 2024Dec 28, 2024
“Mastering SQL: Pivoting and Unpivoting Technique(s)”A pivot table is an effective technique for calculating, compiling, and analyzing data. It is designed to simplify the search for patterns…Sep 3, 20233Sep 3, 20233
Extracting and Displaying Football Scores and Standings from Sky News: A Code Implementation GuideThis blog post focuses on creating a code implementation to extract football scores and standings from Sky News. It aims to address the…Aug 27, 2023621Aug 27, 2023621
Secret Santa App using Microsoft PowerAppsHere is a step by step method on how the app was createdNov 29, 20224Nov 29, 20224
Monkey Pox VizA guide on how the Viz was made. Click here to interact with vizJun 9, 2022181Jun 9, 2022181
Web-scraping using spotify’s APIA guide to the spotify’s API and data analysisMay 16, 202213May 16, 202213
Web-scraping using spotify’s APIA guide to the spotify’s API and data analysisMay 16, 20221May 16, 20221