awk and datamash: reports from tables
Compute sums, averages and top lists over any table right in the terminal — awk for the tricky cases, datamash for the routine ones.
- awk: the second columneasy
- awk: count the lineseasy
- awk: sum of a columneasy
- awk: average of a columnmedium
- awk: filter by a condition on a fieldmedium
- awk: line with the maximummedium
- awk: CSV to TSVmedium
- awk: alignment via printfmedium
- awk: unique lines, preserving ordermedium
- awk: sum by groupmedium
- awk: top 3 by frequencymedium
- awk: lines between markersmedium
- Sum of a Columneasy
- Average of a Columneasy
- Sum by Groupmedium
- Minimum and Maximummedium
- How many unique valueseasy
- Transpose a tableeasy
- Top Products by Units Soldmedium
- awk: join two files by keyhard
- awk: pivot on a key pairmedium
- awk: parsing /etc/passwdmedium