Aaron Schlegel – Medium

Aaron Schlegel

Aaron Schlegel

Containerizing ETL Data Pipelines with Docker

In this post, we will walk through how to utilize Docker to “containerize” the ETL scripts for getting and transforming the adoptable…

Aug 25, 2021

Containerizing ETL Data Pipelines with Docker

Aug 25, 2021

Aaron Schlegel

Install Spark on MacOS and Load Data from AWS S3 with PySpark

In this post, we walk through how to get started with Spark on our local MacOS machine to begin exploring and analyzing data using PySpark…

Aug 20, 2021

Install Spark on MacOS and Load Data from AWS S3 with PySpark

Aug 20, 2021

Aaron Schlegel

ETL Pipeline for Extracting Animal Welfare Organization Data — Part Three

In the previous posts of the series, we installed PostgreSQL on our local machine and got set up with AWS S3 for storing raw results from…

Aug 10, 2021

ETL Pipeline for Extracting Animal Welfare Organization Data — Part Three

Aug 10, 2021

Aaron Schlegel

Building and Managing Data Pipelines with Python, PostgreSQL & Airflow — Part Two

Creating Tables to Store Extracted Data from the Petfinder.com API

Aug 6, 2021

Building and Managing Data Pipelines with Python, PostgreSQL & Airflow — Part Two

Aug 6, 2021

Aaron Schlegel

Building and Managing Data Pipelines with Python, PostgreSQL & Airflow — Part One

Installing PostgreSQL Locally and Getting Started with AWS

Aug 3, 2021

Building and Managing Data Pipelines with Python, PostgreSQL & Airflow — Part One

Aug 3, 2021

Aaron Schlegel

Query JSON Data with PostgreSQL

Support for working with JSON in PostgreSQL has become increasingly powerful since it was first introduced in version 9.2. In PostgreSQL…

Jul 30, 2021

Photo by <a href=”https://unsplash.com/@tofi?utm_source=unsplash&utm_medium=referral&utm_content=creditCopyText">Tobias Fischer</a> on <a href=”https://unsplash.com/s/photos/database?utm_source=unsplash&utm_medium=referral&utm_content=creditCopyText">Unsplash</a>

Jul 30, 2021

Aaron Schlegel

Introduction to JSON and JSON Normalization with PostgreSQL

Jul 27, 2021

Photo by <a href=”https://unsplash.com/@kristinwilson?utm_source=unsplash&utm_medium=referral&utm_content=creditCopyText">Kristin Wilson</a> on <a href=”https://unsplash.com/t/business-work?utm_source=unsplash&utm_medium=referral&utm_content=creditCopyText">Unsplash</a>

Jul 27, 2021

Aaron Schlegel

Analyze Petfinder Adoptable Cat and Dog Descriptions with IBM Watson’s Tone Analyzer — Part Two

In the first part of this series, we extracted adoptable cat and dog information from Petfinder and found the tones used in the…

Mar 17, 2020

Analyze Petfinder Adoptable Cat and Dog Descriptions with IBM Watson’s Tone Analyzer — Part Two

Mar 17, 2020

Aaron Schlegel

Analyze Petfinder Adoptable Pet Descriptions with the IBM Watson Tone Analyzer — Part One

Many animals listed on Petfinder are also given a description by the shelter that provides further details and information on the pet…

Mar 1, 2020

Analyze Petfinder Adoptable Pet Descriptions with the IBM Watson Tone Analyzer — Part One

Mar 1, 2020

Aaron Schlegel

Analyze Seattle’s Pet Licensing Dataset with pandas and seaborn

The city of Seattle makes available its database of pet licenses issued from 2000 to the beginning of 2020 as part of the city’s ongoing…

Feb 29, 2020

Analyze Seattle’s Pet Licensing Dataset with pandas and seaborn

Feb 29, 2020

Aaron Schlegel

Aaron Schlegel

Seeker of knowledge, truth pilgrim, builder of things, science fiction lover, math and stats aficionado, data scientist. https://aaronschlegel.me

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams