Data Engineering

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

Working With Google Cloud Functions

Working With Google Cloud Functions

GCP scores a victory by trivializing serverless functions.
Extract Nested Data From Complex JSON

Extract Nested Data From Complex JSON

Never manually walk through complex JSON objects again by using this function.
Reading and Writing to CSVs in Python

Reading and Writing to CSVs in Python

Read and write to CSV files using Python's I/O functions and built-in CSV library
Hacking Your Tableau Linux Server

Hacking Your Tableau Linux Server

Cracking Tableau's master Postgres account.
Using Pandas with AWS Lambda Functions

Using Pandas with AWS Lambda Functions

Use Python's Pandas library in your AWS Lambda functions.
Working with XML tree data in Python

Working with XML tree data in Python

Make use of Python's native XML library to walk through and extract data.
Using PyMySQL: Python's MySQL Library

Using PyMySQL: Python's MySQL Library

The lightweight Python library for interacting with MySQL.
Accessing Self-Hosted MySQL Externally

Accessing Self-Hosted MySQL Externally

Configure a self-installation of MySQL on Ubuntu to allow access from external sources, such as SequelPro or other GUIs.