← All courses

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.

22 tasks
  1. awk: the second columneasy
  2. awk: count the lineseasy
  3. awk: sum of a columneasy
  4. awk: average of a columnmedium
  5. awk: filter by a condition on a fieldmedium
  6. awk: line with the maximummedium
  7. awk: CSV to TSVmedium
  8. awk: alignment via printfmedium
  9. awk: unique lines, preserving ordermedium
  10. awk: sum by groupmedium
  11. awk: top 3 by frequencymedium
  12. awk: lines between markersmedium
  13. Sum of a Columneasy
  14. Average of a Columneasy
  15. Sum by Groupmedium
  16. Minimum and Maximummedium
  17. How many unique valueseasy
  18. Transpose a tableeasy
  19. Top Products by Units Soldmedium
  20. awk: join two files by keyhard
  21. awk: pivot on a key pairmedium
  22. awk: parsing /etc/passwdmedium