How can I sum values in column based on the value in another column?

by 
$ awk '{a[$1]+=$2}END{for(i in a) print i,a[i]}' file
ABC 80
XYZ 20
MNP 60
DEF 170

More Related Contents:

  1. In Powershell, what’s the best way to join two tables into one?
  2. How to delete items from a dictionary while iterating over it?
  3. Escaping Double Quotes in Batch Script
  4. Add a prefix string to beginning of each line
  5. Scripting Language vs Programming Language [closed]
  6. Using sed, Insert a line above or below the pattern? [duplicate]
  7. Running a CMD or BAT in silent mode
  8. Stopping scripters from slamming your website
  9. What are the best ways to automate a GDB debugging session?
  10. Determine if current PowerShell Process is 32-bit or 64-bit?
  11. How do you execute an arbitrary native command from a string?
  12. VBScript getting results from Shell
  13. How to compile a linux shell script to be a standalone executable *binary* (i.e. not just e.g. chmod 755)?
  14. Creating a script for a Telnet session?
  15. gdb scripting: execute commands at selected breakpoint
  16. Visual Basic scripting dynamic array
  17. Best tool(s) for decompiling Lua bytecode? [closed]
  18. Move folder from one directory to another in batch script
  19. How can I remove the first line of a text file using bash/sed script?
  20. What is the best scripting language to embed in a C# desktop application? [closed]
  21. Date command does not follow Linux specifications (Mac OS X Lion)
  22. Shell/Bash shortcut for bulk renaming of files in a folder
  23. How to get started with PowerShell? [closed]
  24. How to I launch a ruby script from the command line by just its name?
  25. Date arithmetic in cmd scripting
  26. Best way to simulate “group by” from bash?
  27. Determine if a function exists in bash
  28. Remove part of path on Unix
  29. Giving the script tag an ID
  30. Can PHP asynchronously use sockets?

Leave a Comment