Level of Difficulty: Beginner – Senior. Say you have a website that you’d like to scrape to find out what information the website represents. Well the good news is that you can, in Python, using a library named TextRazor. TextRazor allows you to scrape categories, entities and topics from the website. To use this library,Continue reading “[Python] Scraping Context (Categories, Topics and Entities) From Websites Using TextRazor and Python”
Category Archives: Python
[Automation] Making a SOAP API Call in Python, Using a Session Key
Level of Difficulty: Beginner – Senior. Let’s say you’re working on a system that needs to query a legacy SOAP API. Although SOAP APIs are becoming more scarce as REST and Open Data APIs are taking the world by storm, the reality is that SOAP APIs still exist and are still used. In most SOAPContinue reading “[Automation] Making a SOAP API Call in Python, Using a Session Key”
[Automation] Retrieving a List of Mail Senders From a Shared Mailbox (Using Outlook and Python)
Level of Difficulty: Beginner – Senior. Have you ever had a use case where you have a shared mailbox setup on your Outlook but you don’t have the credentials to the account behind the mailbox (if one exists)? Well you can get around that by running the Python script detailed in this post. The approachContinue reading “[Automation] Retrieving a List of Mail Senders From a Shared Mailbox (Using Outlook and Python)”
[Automation] Using Google Drive, Google Sheets and Python in Google Colaboratory to Automate Rubric Creation and Synchronisation
Level of Difficulty: Intermediate – Senior. Have you ever run into a situation where you have over 200 students whose work needs to be marked and the admin around it is enough to make anyone go crazy? Well here’s a step towards getting around the labour-intensive admin that goes hand-in-hand with marking student projects, usingContinue reading “[Automation] Using Google Drive, Google Sheets and Python in Google Colaboratory to Automate Rubric Creation and Synchronisation”
[Automation] YouTube Playlist Monitoring Using Python
Level of Difficulty: Beginner – Senior. There are many different workflow and automation suites/platforms available out there (some of which include IFTTT, Power Automate and Tonkean) that allow users to interact with their YouTube connector. Most of these workflows classify the functions within the connectors as either a Trigger or an Action. A trigger wouldContinue reading “[Automation] YouTube Playlist Monitoring Using Python”
[Automation] Monitoring Gmail Inbox Using Python
Level of Difficulty: Beginner – Senior. Many automation solutions make use of the functionality provided by mail services as it serves as an important element that allows for communication between humans and the automation process. There are many benefits provided by using Google Mail (Gmail), one of which is cost – for that reason, thisContinue reading “[Automation] Monitoring Gmail Inbox Using Python”
[Python] Using Python for SQL Schema and Table Validation and Logging Progress to Microsoft Teams
Level of Difficulty: Intermediate to Senior. So you’ve reached created a database, you’ve created schemas and tables. You’ve managed to create an automation Python script that communicates with the database, however, you’ve reached a crossroad where you need to validate your SQL tables. Some of the validation might include ensuring that the tables exist andContinue reading “[Python] Using Python for SQL Schema and Table Validation and Logging Progress to Microsoft Teams”
[Python] Automating ASP.NET Core Web API Creation That Communicates With Your Database in 60 Seconds or Less
Creating an ASP.NET Core Web API That Communicates With Your Database in 60 Seconds or Less
[Python] Auto-Format Code According to PEP 8
Level of Difficulty: Beginner to Senior. So you’ve written a Python Script, Kevin has just told your team that all code needs to be reviewed and part of the team’s Key Performance Indicators (KPIs) will be PEP 8 compliance. Now there’s a slight sense of chaos and stress because “What is PEP 8?! Can oneContinue reading “[Python] Auto-Format Code According to PEP 8”
[Python] Setting up alerts on SQL Server Job Agent failures
Level of Difficulty: Beginner to Intermediate. So you’ve found yourself in a semi-ops situation where you need to do daily checks on SQL Server Agent Jobs because the client, Steve, has concerns that his data is not updating. Now you have to go through the manual process of opening SQL Server Management Studio then loggingContinue reading “[Python] Setting up alerts on SQL Server Job Agent failures”
The JPanda 