How to Conditionally Sum and Group Data with awk
One line. No spreadsheet, no database, no extra dependencies.
Save pandas and NumPy for when you actually need a DataFrame. For this? awk just showed up and did the job.
BlogEtcetera
Thoughts on this, that and the rest
BlogEtcetera
Thoughts on this, that and the rest
programming
Reclaim Your Terminal: How Lazygit Supercharges Your Git Workflow
Finding the right tools for your development workflow is a constant struggle, and Git tooling is no exception. Despite the plethora of Git clients available, none of them ever felt quite right. For a while, I settled on GitFiend. It…
AWK CSV Column Sum: Quick Command Line Tutorial
Imagine you have a file with multiple columns and you need to quickly get the total of a column in command line in UNIX. The easiest way is to use AWK in the command line. Let’s take the following file:…
The Split() Trap: Why Perl Was Eating My Empty Fields
I was working on a data-matching project. One organisation sending data to match against another. Standard stuff: plain text, fields separated by a delimiter (tab, in this case). I reached for Perl’s split function to break each line into an…
