Open in app

Sign In

Write

Sign In

Alex Galea
Alex Galea

432 Followers

Home

About

Jan 15, 2021

When to Pull the Goalie: Running the Numbers on NHL Goalie Pulls

For 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 their goalie and send out an extra skater in their place. …

Hockey

12 min read

When to Pull the Goalie: Running the Numbers on NHL Goalie Pulls
When to Pull the Goalie: Running the Numbers on NHL Goalie Pulls
Hockey

12 min read


Dec 28, 2020

Pandas Groupby Aggregates with Multiple Columns

Pandas groupby is a powerful function that groups distinct sets within selected columns and aggregates metrics from other columns accordingly. Performing these operations results in a pivot table, something that’s very useful in data analysis. Aggregating Multiple Columns In this article, I share a technique for computing ad-hoc aggregations that can involve multiple…

Programming

3 min read

Pandas Groupby with Multiple Columns
Pandas Groupby with Multiple Columns
Programming

3 min read


Oct 29, 2020

Why I chose Obsidian for my Knowledge Graph

Personal knowledge graphs are rapidly growing in popularity as benefits emerge. There are lots to chose from, but here’s why I love Obsidian. Building my own knowledge graph Roam Research was the first tool like this that I learned about — their revolutionary graph approach to note taking blew my mind a bit. I had…

Productivity

4 min read

Why I chose Obsidian for my Knowledge Graph
Why I chose Obsidian for my Knowledge Graph
Productivity

4 min read


Oct 28, 2020

Data Transfer from AWS Redshift to BigQuery

Databases are like Pokémon. Gotta pass data between em’ all! There are many methods of sending data to and from BigQuery. Some are even documented! In this post I’ll share a simple method that I use to copy tables from Redshift into BigQuery using only SQL and command line tools. Data Synchronization …

Data Engineering

3 min read

Data Transfer from AWS Redshift to BigQuery
Data Transfer from AWS Redshift to BigQuery
Data Engineering

3 min read


Oct 4, 2020

Python’s “try except else finally” explained

In 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 only okay but considered good practice. Real life example: dogs & cats This section is for people who want to learn about the basic try/except control structure…

Python

3 min read

Python’s “try except else finally” explained
Python’s “try except else finally” explained
Python

3 min read


Sep 17, 2020

Airflow Dynamic DAGs — Python Globals

In this post, I introduce the concept of dynamic DAG creation and explain the significance of Python global variables for Airflow. What do I mean by “dynamic DAG”? Dynamic DAG creation is important for scalable data pipeline applications. When confined to the realm of static DAG scripts, we find ourselves duplicating code in order to create pipelines. …

Python

3 min read

Airflow Dynamic DAGs — Python Globals
Airflow Dynamic DAGs — Python Globals
Python

3 min read


Jul 15, 2020

Symlink use cases: Shortcuts, App config files

Shortcuts 🥱 Symbolic links are handy for shortcuts in your file explorer. Maybe you have shortcuts on your desktop to your favorite folders, or maybe you symlink your active projects in your home directory for quick bash access. For example: ln -s /User/alex/Apps/2020/appthing /User/alex/appthing This will create a shortcut to ~/Apps/2020/appthing directly…

Programming

3 min read

Symlink use cases: Shortcuts, App config files
Symlink use cases: Shortcuts, App config files
Programming

3 min read


Jun 30, 2020

New-Window Shortcuts for MacOS Apps

If you’re like me then you try to avoid using the mouse whenever possible. This post will help with that. The Action to Automate My “normal” workflow involves opening new application windows pretty frequently. For example, I might open a new terminal window to start working on a project, or I might open a…

Macos

4 min read

New-Window Shortcuts for MacOS Apps
New-Window Shortcuts for MacOS Apps
Macos

4 min read


Jun 13, 2020

Docker Runtime Arguments

Last night I fell down the rabbit hole of different ways to configure docker apps with runtime arguments. Somehow it ended with me searching for ASCII art of a d20.. I settled on this: If you’re thinking “what does ASCII art of dice have to do with docker?” Nothing really…

Docker

5 min read

Docker Runtime Arguments
Docker Runtime Arguments
Docker

5 min read


Jul 17, 2019

How to Love jsonl — using JSON Lines in your Workflow

Why you should think about using JSON Line format in your data processing workflow. We’ll look at some jsonl examples and discuss how I use it day to day. What is the json line format? It’s a file type specification where each line is a JSON object. Just imagine a bunch of stacked up dictionaries. …

Data

3 min read

How to Love jsonl — using JSON Line Format in your Workflow
How to Love jsonl — using JSON Line Format in your Workflow
Data

3 min read

Alex Galea

Alex Galea

432 Followers

Python Data Engineer, MSc. Physics

Following
  • DailyPriyab

    DailyPriyab

  • Netflix Technology Blog

    Netflix Technology Blog

  • Michael Galarnyk

    Michael Galarnyk

  • Nassim Nicholas Taleb

    Nassim Nicholas Taleb

  • Joaquín Alfaro

    Joaquín Alfaro

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech