Visit The New, Modern Unix Linux Community


Sum Numbers from different files


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Sum Numbers from different files
# 1  
Sum Numbers from different files

Hi All,

I need to print the sum of numbers from different files.

Input files:

Code:
file1.out
10
20
30

file2.out
10
20
30

i want the sum of the numbers from each row from each file.
in this example, i desire to get

Code:
10+10
20+20
30+30

Any help with awk. Thanks a lot.
# 2  
Code:
awk 'NR==FNR{a[NR]=$1; next}{print a[FNR]+$1}' file1.out file2.out

This User Gave Thanks to mirni For This Post:
# 3  
Code:
paste -d + file1.out file2.out|bc

This User Gave Thanks to vgersh99 For This Post:
# 4  
Quote:
Originally Posted by mirni
Code:
awk 'NR==FNR{a[NR]=$1; next}{print a[FNR]+$1}' file1.out file2.out

Thanks Mirni, how i can do the same for 1000s of files.

---------- Post updated at 03:43 PM ---------- Previous update was at 03:39 PM ----------

Quote:
Originally Posted by vgersh99
Code:
paste -d + file1.out file2.out|bc

Thanks vgersh99. the simple code works. but i have too many files that paste doesn't work.
# 5  
Quote:
Originally Posted by saint2006
Thanks Mirni, how i can do the same for 1000s of files.

---------- Post updated at 03:43 PM ---------- Previous update was at 03:39 PM ----------



Thanks vgersh99. the simple code works. but i have too many files that paste doesn't work.
then follow mirni's suggestion with the wild-carded file names:
Code:
awk '{print a[FNR]+=$1}END{for(i=1;i in a;i++) print a[i]}' myFiles*

This User Gave Thanks to vgersh99 For This Post:
# 6  
Quote:
Originally Posted by vgersh99
then follow mirni's suggestion with the wild-carded file names:
Code:
awk '{print a[FNR]+=$1}END{for(i=1;i in a;i++) print a[i]}' myFiles*

vgersh99's has bug, here is the update:

Code:
awk '{a[FNR]+=$1}END{for(i=1;i in a;i++) print a[i]}' myFiles*

This User Gave Thanks to rdcwayx For This Post:

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #610
Difficulty: Medium
Compared to Python, Perl has a relatively small Comprehensive Perl Archive Network (CPAN) library.
True or False?

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Sum even numbers from 1 to 100

I need help with this assignment. I'm very new to using UNIX/LINUX, and my only previous experience with programing anything is using python. We are writing scripts using vim, and this one I'm stumped on. "Write a shell script that finds and display the sum of even positive integers from 0 to... (5 Replies)
Discussion started by: Nastybutler
5 Replies

2. Shell Programming and Scripting

Shell script count lines and sum numbers from multiple files

I want to count the number of lines, I need this result be a number, and sum the last numeric column, I had done to make this one at time, but I need to make this for a crontab, so, it has to be an script, here is my lines: It counts the number of lines: egrep -i String file_name_201611* |... (5 Replies)
Discussion started by: Elly
5 Replies

3. Shell Programming and Scripting

Sum up numbers in a for loop

Hi i have to calculate some numbers, column by column. Herfore i used a for-loop.. for i in {4..26};do awk -F"," '{x'$i'+=$'$i'}END{print '$i'"\t" x'$i'}' file.tmp;done ----- printout ----- 4 660905240 5 71205272 6 8.26169e+07 7 8.85961e+07 8 8.60936e+07 9 7.42238e+07 10 5.6051e+07... (7 Replies)
Discussion started by: IMPe
7 Replies

4. Shell Programming and Scripting

Sum of numbers in three or more files

I have files : cat file1 15 88 44 667 33 4cat file2 445 66 77 3 56 (12 Replies)
Discussion started by: Natalie
12 Replies

5. Shell Programming and Scripting

sum numbers of multiple files

Hi, I want to count the number of occurrences of numbers from a file of 6,000,000 lines. Because its too large, I decided to split the counts up in multiple files. So I have files of the counts of 5,000 lines. Now I want to add up the counts of all those files. The "counts file" looks like... (9 Replies)
Discussion started by: linseyr
9 Replies

6. Shell Programming and Scripting

getting the sum of numbers

I basically have a file where I had to do a bunch of greps to get a list of numbers example: a file called numbers.txt 10000 10000 superman 10000 batman 10000 10000 grep '100' * | 10000 10000 10000 10000 10000 (2 Replies)
Discussion started by: zerofire123
2 Replies

7. Shell Programming and Scripting

Finding the sum of two numbers

cat *.out |grep "<some text>" | awk '{print $6}' For ex,This will reutrn me 11111 22222 is it possible to add these two numbers in the above given command itself?I can write this to a file and find the sum. But I prefer to this calculation in the above given line itself. Any... (3 Replies)
Discussion started by: prasperl
3 Replies

8. Shell Programming and Scripting

sum numbers in multiple files

I have 11 directories with around 200 files in each. In each directory the files are labeled out.0 through out.201 . Each file has around 118 numbers in a single column. I need to sum the files in each directory so each directory will have a resultant vector that is 118 numbers long. I then... (5 Replies)
Discussion started by: pattywac
5 Replies

9. Shell Programming and Scripting

sum numbers from stdout

hello im looking for short way to sum numbers from stdout the way i found to do it is to long for me i wander if there is shorter way to do it ok it 2 stage action this will make the list of number in to file sum.txt grep -c include *.c | awk '{l=split($0,a,":");print a;}' > sum.txt this... (1 Reply)
Discussion started by: umen
1 Replies

10. Shell Programming and Scripting

how to sum numbers in column

Hi, i want to sum all nubers in one column. Example: 12.23 11 23.01 3544.01 I'm trying to do this in awk, but it doesn't work properly. Seems like awk is summing only integers, for example: 12 11 23 3544 It cuts off numbers after dot. I used this command: akw /text/ file.txt |nawk... (1 Reply)
Discussion started by: iahveh
1 Replies

Featured Tech Videos