Data Engineering

The systematic collection and transformation of data via the creation of tools and pipelines.

Downcast Numerical Data Types with Pandas

Downcast Numerical Data Types with Pandas

Using an Example Where We Downcast Numerical Columns.
From CSVs to Tables: Infer Data Types From Raw Spreadsheets

From CSVs to Tables: Infer Data Types From Raw Spreadsheets

The quest to never explicitly set a table schema ever again.
Psycopg2: PostgreSQL & Python the Old Fashioned Way

Psycopg2: PostgreSQL & Python the Old Fashioned Way

Manage PostgreSQL database interactions in Python with the Psycopg2 library.
Python Database Management with SQLAlchemy

Python Database Management with SQLAlchemy

Connect to any database and execute queries using Python's iconic SQLAlchemy library.
Using Redis to Store Information in Python Applications

Using Redis to Store Information in Python Applications

A temporary data store for everything from session variables to chat queues.
MongoDB Stitch Serverless Functions

MongoDB Stitch Serverless Functions

A crash course in MongoDB Stitch serverless functions: the bread and butter of MongoDB Cloud.
Scraping Data on the Web with BeautifulSoup

Scraping Data on the Web with BeautifulSoup

The honest act of systematically stealing data without permission.
Create a REST API Endpoint Using AWS Lambda

Create a REST API Endpoint Using AWS Lambda

Create an AWS Lambda function to pull records from a database.