Frank's Blog

Articles Courses About Contact

November 13, 2023 in Data Engineering

How to Query Athena using Python

Using AWS Athena? Learn how to use Python to perform queries to get data from Athena.

October 30, 2023 in Data Science

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.

October 19, 2023 in Data Engineering

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.

October 11, 2023 in Data Engineering

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.

September 01, 2023 in Data Visualization

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.

January 16, 2023 in Data Visualization

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.

December 26, 2022 in SQL

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.

December 12, 2022 in Data Visualization

Visualizing Connections Using Chord Diagrams in Python

Looking to visualize connections between different categorical values? Learn how to create a chord diagram!

November 28, 2022 in Python

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.

July 05, 2022 in Data Visualization

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!

January 03, 2022 in Python

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.

November 01, 2021 in Python

Passing Credentials to AWS Lambda Using Parameter Store

Need to pass credentials or secrets to your Python Lambda functions?

September 24, 2021 in Python

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.

August 16, 2021 in Python

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!

July 28, 2021 in Python

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.

April 12, 2021 in SQL

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!

March 22, 2021 in SQL

How To Select Data From Databases Using SQL

Learn how to get data from a database using the SELECT, WHERE, and LIMIT statements.

February 01, 2021 in SQL

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!

January 25, 2021 in Data Engineering

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.

January 11, 2021 in 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!

December 14, 2020 in Python

Setting Up Your Python Environment With Venv and requirements.txt

Learn how to use virtual environments and requirements.txt to maintain your projects better.

November 29, 2020 in Python

Using Jinja for HTML Email Templates in Python

Instead of hardcoding your emails within Python, you can move them to HTML templates using Jinja!

October 25, 2020 in Python

Deploying Your Pelican Static Site To Netlify

Ready to deploy your static site built by Pelican? Learn how to deploy to Netlify!

September 18, 2020 in Development Tools

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!

September 01, 2020 in Python

Setting Up Pelican Static Site Generator

Interested in setting up a static site using Pelican? Check out how I set up this site!

© 2023 Frank Corso

GitHub icon Threads icon RSS icon