How can I sum numbers on lines in a file
I have a file which looks like this:
1
3
4
1
4
3
1
2
How can I find the total of this (i.e. 1+3+4+1+4+3+1+2 = 19)?
Solution 1:
bc
with a little help from paste
to get the lines in a single one with +
as the separator:
paste -sd+ file.txt | bc
To use the output of grep
(or any other command) instead a static file, pass the grep
's STDOUT to the STDIN of paste
:
grep .... | paste -sd+ | bc
Example:
% cat file.txt
1
3
4
1
4
3
1
2
% paste -sd+ file.txt | bc
19
% grep . file.txt | paste -sd+ | bc
19
If you must use bash
, then you can use an array to save the file contents and then iterate over the elements or you can read the file line by line and do the sum for each line, the second approach would be more efficient:
$ time { nums=$(<file.txt); for i in ${nums[@]}; do (( sum+=i )); done; echo $sum ;}
19
real 0m0.002s
user 0m0.000s
sys 0m0.000s
$ time { while read i; do (( sum+=i )); done <file.txt; echo $sum ;}
19
real 0m0.000s
user 0m0.000s
sys 0m0.000s
Solution 2:
You could use awk, too. To count the total number of lines in *.txt files that contain the word "hello":
grep -ch 'hello' *.txt | awk '{n += $1}; END{print n}'
To simply sum the numbers in a file:
awk '{n += $1}; END{print n}' file.txt
Solution 3:
Use numsum
from the package num-utils
!
(You may need to sudo apt-get install num-utils
)
The command numsum
does just what you need by default;
$ numsum file.txt
19
Reading the test numbers line by line from stdin
:
$ printf '
1
3
4
1
4
3
1
2' | numsum
19
Or reading from one line:
$ printf '1 3 4 1 4 3 1 2' | numsum -r
19
More utilities
The package contains some other utilities for number processing that deserve to be more well known:
numaverage - find the average of the numbers, or the mode or median
numbound - find minimum of maximum of all lines
numgrep - to find numbers matching ranges or sets
numinterval - roughly like the first derivative
numnormalize - normalize numbers to an interval, like 0-1
numrandom - random numbers from ranges or sets, eg odd.
numrange - similar to seq
numround - round numbers up, down or to nearest
and a more general calculator command numprocess
,
that applies an expression from the command line to numbers on input lines.
Solution 4:
You can use awk
, a native linux application usefull to scanning and processing files with a pattern per line. For your question, this will produce what you want:
awk 'BEGIN { sum=0 } { sum+=$1 } END {print sum }' file.txt
Pipes are also accept:
cat file.txt | awk 'BEGIN { sum=0 } { sum+=$1 } END {print sum }'
Solution 5:
Perl solution:
$ perl -lnae '$c+=$_;END{print $c}' input.txt
19
The above can sum all numbers across multiple files:
$ perl -lnae '$c+=$_;END{print $c}' input.txt input2.txt
34
For multiple files given on command-line where we want to see sum of numbers in individual file we can do this:
$ perl -lnae '$c+=$_;if(eof){printf("%d %s\n",$c,$ARGV);$c=0}' input.txt input2.txt
19 input.txt
15 input2.txt