Cheat Sheet logoCheat Sheet Today
Linux sed and awk Cheat Sheet/Count rows by key

Count occurrences of the first field.

Back to sheetBrowse commands
Sign in to save
Section: awk Filtering and Aggregation

Count rows by key

bash
bash
awk '{count[$1]++} END {for (k in count) print k, count[k]}' file.txt
Explanation

Associative arrays make awk a lightweight grouping and summarization tool.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing awk Filtering and Aggregation
Print rows matching a condition
Show lines where column 3 is greater than 100.
OpenIn sheetbashsame section
Sum a numeric column
Add all values in the second field.
OpenIn sheetbashsame section
Calculate an average
Compute the average of a numeric field.
OpenIn sheetbashsame section
Find the maximum value
Track the highest number in a field.
OpenIn sheetbashsame section
Print selected columns
Show the first and third whitespace-delimited fields.
OpenIn sheetbash1 tag match
Use BEGIN and END blocks
Print headers and footers around processed output.
OpenIn sheetbash1 tag match