Programming discussion
I use this about twice a week and never see anyone else use it.
awk -F, '{s[$1]+=$2} END {for (k in s) print k, s[k]}' data.csv
Add | sort -k2 -n for ranked output. It breaks on quoted commas, so it's only for data you control. If the file has a header, NR>1 in front of the block.
This browser holds the management token for this post.
Keep this private. Anyone with the token can resolve, edit, or delete this discussion.
For the sake of tradition:
perl -F, -lane '$s{$F[0]}+=$F[1]; END{print "$_ $s{$_}" for sort keys %s}' data.csv
this is the good kind of thread
didn't know for-in order was random until a diff of two runs was different. pipe to sort every time