Sum duplicate row values with awk

by

Use an Awk as below,

awk '{ seen[$1] += $2 } END { for (i in seen) print i, seen[i] }' file1
1486113768 9936
1486113769 6160736
1486113770 5122176
1486113772 4096832
1486113773 9229920
1486113774 8568888

{seen[$1]+=$2} creates a hash-map with the $1 being treated as the index value and the sum is incremented only for those unique items from $1 in the file.

More Related Contents:

  1. Some troubles with using sed and awk [closed]
  2. How can I manipulate text in bash? [closed]
  3. How do I use shell variables in an awk script?
  4. How can I do a recursive find/replace of a string with awk or sed?
  5. How to merge every two lines into one from the command line?
  6. bash: shortest way to get n-th column of output
  7. awk in bash with ls and variable
  8. Remove first N lines of a file in place in unix command line
  9. How to add to the end of lines containing a pattern with sed or awk?
  10. Parsing variables from config file in Bash
  11. Parse out key=value pairs into variables
  12. Specify other flags in awk script header
  13. Use awk to find average of a column [duplicate]
  14. Parsing a CSV file using gawk
  15. Split CSV files into smaller files but keeping the headers?
  16. Bash: Parse CSV with quotes, commas and newlines
  17. How to remove double-quotes in jq output for parsing json files in bash?
  18. How to find/replace and increment a matched number with sed/awk?
  19. find difference between two text files with one item per line [duplicate]
  20. Grep output with multiple Colors?
  21. Using grep to search for hex strings in a file
  22. How to append a string at end of a specific line in a file in bash [duplicate]
  23. How to strip out all of the links of an HTML file in Bash or grep or batch and store them in a text file
  24. Parse HTML using shell
  25. How to get the PID of a process in a pipeline
  26. using bash (sed/awk) to extract rows AND columns in CSV files?
  27. How to delete rows from a csv file based on a list values from another file?
  28. What is the shortest way to get n-th column of an output?
  29. How to grep for case insensitive string in a file?
  30. How can I format the output of a bash command in neat columns

Leave a Comment