Alex GaleaWhen to Pull the Goalie: Running the Numbers on NHL Goalie PullsFor hockey fans, it’s a familiar story. As the clock runs down in the final (3rd) period, teams losing by a goal or two will look to pull…12 min read·Jan 15, 2021----
Alex GaleaPandas Groupby with Multiple ColumnsPandas groupby is a powerful function that groups distinct sets within selected columns and aggregates metrics from other columns…3 min read·Dec 28, 2020--1--1
Alex GaleaWhy I chose Obsidian for my Knowledge GraphPersonal knowledge graphs are rapidly growing in popularity as benefits emerge. There are lots to chose from, but here’s why I love…4 min read·Oct 29, 2020----
Alex GaleaData Transfer from AWS Redshift to BigQueryDatabases are like Pokémon. Gotta pass data between em’ all!3 min read·Oct 28, 2020--1--1
Alex GaleaPython’s “try except else finally” explainedIn Python it’s okay to make assumptions, as long as you’re able to clean up the mess if they turn out to be wrong. In fact, this is not…3 min read·Oct 4, 2020----
Alex GaleaAirflow Dynamic DAGs — Python GlobalsDynamic DAG creation is important for scalable data pipeline applications.3 min read·Sep 17, 2020----
Alex GaleaSymlink use cases: Shortcuts, App config filesExamples of when to use absolute and relative paths for symlinks3 min read·Jul 15, 2020----
Alex GaleaNew-Window Shortcuts for MacOS AppsIf you’re like me then you try to avoid using the mouse whenever possible. This post will help with that.4 min read·Jun 30, 2020----
Alex GaleaDocker Runtime ArgumentsLast night I fell down the rabbit hole of different ways to configure docker apps with runtime arguments.5 min read·Jun 13, 2020----
Alex GaleaHow to Love jsonl — using JSON Line Format in your WorkflowWhy you should think about using JSON Line format in your data processing workflow. We’ll look at some jsonl examples and discuss how I…3 min read·Jul 17, 2019--2--2