Using AWS Athena? Learn how to use Python to perform queries to get data from Athena.
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.
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.
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.
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.
Scatterplots are a great way to visualize relationships between different dimensions. Learn how to create them in Python using Seaborn.
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.
Looking to visualize connections between different categorical values? Learn how to create a chord diagram!
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.
Looking to visualize data in your Pandas dataframe? Seaborn is a great data visualization library. Learn how it works by creating your first chart!
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.
Need to pass credentials or secrets to your Python Lambda functions?
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.
Need to set up an AWS Lambda function on a recurring schedule? Learn how using AWS EventBridge!
Just getting started with AWS Lambda? Learn how to set up your first Python Lambda function.
Need to insert some data into your database or update some existing data? Learn how using SQL!
Learn how to get data from a database using the SELECT, WHERE, and LIMIT statements.
Just getting started with SQL? Let's learn a high-level overview of how databases and tables are structured!
Learn how to download your conversations from Help Scout using their API and store them in a CSV file using Python.
Need to work with CSV files in Python? Learn how to open, read, and write to CSV files!
Learn how to use virtual environments and requirements.txt to maintain your projects better.
Instead of hardcoding your emails within Python, you can move them to HTML templates using Jinja!
Ready to deploy your static site built by Pelican? Learn how to deploy to Netlify!
Have build scripts that you have to run every time you switch branches in git? Use git hooks to run them automatically!
Interested in setting up a static site using Pelican? Check out how I set up this site!