06-09-2022 09:44 PM
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
06-09-2022 11:47 PM
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.
06-09-2022 11:56 PM
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
06-10-2022 12:23 AM
well, you just need to deal with the header. No problem. Can you successfully read one file?
06-10-2022 01:07 AM
Yes. The files are being read properly.
06-10-2022 09:02 AM
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"...
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!
06-10-2022 09:19 AM
It sounds like you need 2 Delimited Spreadsheet Files and 1 Add.
06-10-2022 09:34 AM - edited 06-10-2022 09:44 AM