Sum Element of multiple csv files

[Ketan31]

Hello,

I am looking for some suggestions regarding summing the elements of multiple csv files and the the results in a new csv file. Any suggestion will be very helpful to me. 

Please feel free to ask for more details if you need to.

Kind regards,

Ketan Patel

[altenbach]

Well, you would iterate over all files while while keeping the running sum in shift registers, then write the result at the end.

Do you want to sum all elements, all rows, al columns, et.?

Are all files the same size?

so. many. questions.

[Ketan31]

Hello Altenbach,

Yes, i would like to sum all the columns of each file. And yes, they are exactly the same length. They do however have labels for each column (name of the column, for example "Time"). I am not sure if that would create any error. 

Please feel free to ask as many questions you have 🙂

Regards,

Ketan

[altenbach]

well, you just need to deal with the header. No problem. Can you successfully read one file?

[Ketan31]

Yes. The files are being read properly.

[altenbach]

Well, you are really feeding us information with an eye dropper!

It is still not clear at all what you mean by "summing the columns"...

• (A) For each file, sum all elements of each column to form a single row? The output would have one row for each file.
• (B) Just sum all files (In that case, summing rows, summing columns, or summing the entire 2D array, would be the same)!
• something else?

Why can't you give an example?

File 1:

01 02 03

04 05 06

07 08 09

FIle 2:

01 02 03

04 05 06

07 08 09

Output according to one possible interpretation (B)

02 04 06

08 10 12

14 16 18

Is that what you want? Seems trivial to implement!

[Yamaeda]

It sounds like you need 2 Delimited Spreadsheet Files and 1 Add.

[altenbach]

• One "list folder" (using a suitable pattern)
• One FOR loop, autoindexing over the files
• One "build path"
• One file read
• One "add"
• Special handling of first file.
• One shift register to accumulate the sum
• One File write after the loop.
• plus maybe some handing of the headers (they can be left in place for the summing, ignored, and written back at the end). Not shown.