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
code-snippet
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 Discarding 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…
