Guest User

Untitled

a guest
May 22nd, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. 0,2,,,10
  2. 0,2,,,15
  3. 0,1,,,984
  4. 0,2,,,9
  5. 1,14,,,5
  6.  
  7. 2,34
  8. 1,984
  9. 14,5
  10.  
  11. awk -F, '{a[$2]+=$5};END{for(i in a)print i","a[i]}' <file
  12.  
  13. datamash -t ',' -s -g 2 sum 5 <infile
  14.  
  15. 1,984
  16. 14,5
  17. 2,34
  18.  
  19. #!/usr/bin/env perl
  20. use strict;
  21. use warnings;
  22.  
  23. my %things;
  24.  
  25. while (<>) {
  26. my ( undef, $key, @rest ) = split(/,/);
  27. $things{$key} += pop(@rest);
  28. }
  29.  
  30. foreach my $key ( sort { $a <=> $b } keys %things ) {
  31. print "$key = $things{$key}n";
  32. }
Add Comment
Please, Sign In to add comment