How to sum column values for each row in two csv files using bash script?

Question

I have two CSV files and i have the requirement to calculate the sum of the 8th column from File1 and File2 for every row. The two CSV files have exactly 24 rows each and to simplify the things i have extracted the 8th row of each CSV file using:

awk -F, '{ print $8 }' >> FILE1 awk -F, '{ print $8 }' >> FILE2 

Now, i have 2 file data in the following format:

File1

1 2 3 4 

File2

2 3 4 5 

How can i make the calculations in the way that

File1.Col1 + File2.Col1 = File3.Col1 File1.Col2 + File2.Col2 = File3.Col2 File1.Col3 + File2.Col3 = File3.Col3 . . . 

resulting in:

File3

3 5 7 9 

and so on using Bash Shell script because rest of my processing is being done in the same.

Answer 1

paste File1 File2 | awk '{ print $1 + $2; }' > File3

Answer 2

for avoiding an intermediate file, use:

paste <( awk -F, '{ print $8 }' original_file1 ) <( awk -F, '{ print $8 }' original_file2 ) | awk '{print $1+$2}' > file3 

Answer 3

if both field are in 8th column among 24

 paste originalfile1 originalfile2 | awk '{print $8+$32 ; }' > file3 

Answer 4

Using numsum and paste:

paste -d ' ' File[12] | numsum -r > File3 

Or if DataFile1 and DataFile2 are the multi-column files from which File1 and File2 were extracted:

paste -d ' ' <(cut -f 8 DataFile1) <(cut -f 8 DataFile2) | numsum -r > File3