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, 2023Sep 3, 2023
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, 20231Aug 27, 20231
Secret Santa App using Microsoft PowerAppsHere is a step by step method on how the app was createdNov 29, 2022Nov 29, 2022
Monkey Pox VizA guide on how the Viz was made. Click here to interact with vizJun 9, 20221Jun 9, 20221
Web-scraping using spotify’s APIA guide to the spotify’s API and data analysisMay 16, 2022May 16, 2022
Web-scraping using spotify’s APIA guide to the spotify’s API and data analysisMay 16, 2022May 16, 2022