How to Query Athena using Python
Using AWS Athena? Learn how to use Python to perform queries to get data from Athena.
Evaluating Classification Models Using Accuracy, Precision, Recall, and More
Assessing your classification model's performance is a critical step. This article explores the key classification metrics such as accuracy, precision, recall, f1 score, and specificity.
Getting Started With AWS Athena To Easily Query Data in S3
Explore the capabilities of AWS Athena, a versatile serverless query engine that empowers you to effortlessly query unstructured, semi-structured, and structured data stored in Amazon S3 using SQL.
Using AWS Glue to Convert CSV Files to Parquet
Learn how to harness the power of AWS Glue's fully managed ETL service to effortlessly convert CSV files to Parquet format while performing data transformations.
Creating A Heatmap Chart In Seaborn
Heatmaps are a great way to visualize the frequency or ranges of a multi-dimensional dataset. Learn how to create them in Python using Seaborn.
Creating A Scatterplot Chart In Seaborn
Scatterplots are a great way to visualize relationships between different dimensions. Learn how to create them in Python using Seaborn.
How To Use MySQL’s GROUP_CONCAT To Get Aggregated Lists of Values
One of my favorite MySQL functions that I wished more people knew about is GROUP_CONCAT. This lets you create an aggregated list of values in your queries. Read on to learn how to use it.
Visualizing Connections Using Chord Diagrams in Python
Looking to visualize connections between different categorical values? Learn how to create a chord diagram!
Deploying a Static Site to Digital Ocean’s App Platform
Digital Ocean offers 3 free static sites on their app platform. If you're looking to deploy a static site using their app platform, read this article to learn how.
Creating Your First Chart Using Seaborn
Looking to visualize data in your Pandas dataframe? Seaborn is a great data visualization library. Learn how it works by creating your first chart!
Create a Twitter Bot Using Python and AWS Lambda
In the final article of my AWS Lambda 101 series, I combine all the things we've learned so far into a small, sample project: Creating and deploying a Twitter bot to AWS Lambda.
Passing Credentials to AWS Lambda Using Parameter Store
Need to pass credentials or secrets to your Python Lambda functions?
How To Create an Endpoint for an AWS Lambda Function Using API Gateway
Need to send and retrieve data from your AWS Lambda function via HTTP request? Learn how to create an endpoint that connects to it using AWS API Gateway.
Setting Up a Recurring AWS Lambda Function Using AWS EventBridge
Need to set up an AWS Lambda function on a recurring schedule? Learn how using AWS EventBridge!
How To Create Your First Python AWS Lambda Function
Just getting started with AWS Lambda? Learn how to set up your first Python Lambda function.
How to Insert and Update Data From Databases Using SQL
Need to insert some data into your database or update some existing data? Learn how using SQL!
How To Select Data From Databases Using SQL
Learn how to get data from a database using the SELECT, WHERE, and LIMIT statements.
Learn How Databases and Tables Are Structured
Just getting started with SQL? Let's learn a high-level overview of how databases and tables are structured!
How To Save Data From Help Scout’s API to CSV in Python
Learn how to download your conversations from Help Scout using their API and store them in a CSV file using Python.
Reading From and Writing to CSV Files in Python
Need to work with CSV files in Python? Learn how to open, read, and write to CSV files!
Setting Up Your Python Environment With Venv and requirements.txt
Learn how to use virtual environments and requirements.txt to maintain your projects better.
Using Jinja for HTML Email Templates in Python
Instead of hardcoding your emails within Python, you can move them to HTML templates using Jinja!
Deploying Your Pelican Static Site To Netlify
Ready to deploy your static site built by Pelican? Learn how to deploy to Netlify!
Automatically Run Build Script When Switching Branchs Using Git Hooks
Have build scripts that you have to run every time you switch branches in git? Use git hooks to run them automatically!
Setting Up Pelican Static Site Generator
Interested in setting up a static site using Pelican? Check out how I set up this site!