Aaron SchlegelContainerizing ETL Data Pipelines with DockerIn this post, we will walk through how to utilize Docker to “containerize” the ETL scripts for getting and transforming the adoptable…Aug 25, 2021Aug 25, 2021
Aaron SchlegelInstall Spark on MacOS and Load Data from AWS S3 with PySparkIn 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, 20211Aug 20, 20211
Aaron SchlegelETL Pipeline for Extracting Animal Welfare Organization Data — Part ThreeIn 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, 20211Aug 10, 20211
Aaron SchlegelBuilding and Managing Data Pipelines with Python, PostgreSQL & Airflow — Part TwoCreating Tables to Store Extracted Data from the Petfinder.com APIAug 6, 2021Aug 6, 2021
Aaron SchlegelBuilding and Managing Data Pipelines with Python, PostgreSQL & Airflow — Part OneInstalling PostgreSQL Locally and Getting Started with AWSAug 3, 20211Aug 3, 20211
Aaron SchlegelQuery JSON Data with PostgreSQLSupport for working with JSON in PostgreSQL has become increasingly powerful since it was first introduced in version 9.2. In PostgreSQL…Jul 30, 2021Jul 30, 2021
Aaron SchlegelAnalyze Petfinder Adoptable Cat and Dog Descriptions with IBM Watson’s Tone Analyzer — Part TwoIn the first part of this series, we extracted adoptable cat and dog information from Petfinder and found the tones used in the…Mar 17, 20201Mar 17, 20201
Aaron SchlegelAnalyze Petfinder Adoptable Pet Descriptions with the IBM Watson Tone Analyzer — Part OneMany animals listed on Petfinder are also given a description by the shelter that provides further details and information on the pet…Mar 1, 2020Mar 1, 2020
Aaron SchlegelAnalyze Seattle’s Pet Licensing Dataset with pandas and seabornThe 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, 20201Feb 29, 20201