I have a group of output csv files from replicates of a simulation. Each file line in the file follow the same format: generation, number, value1, value2, .... valueX. (the file also include a header, same order.
I would like to calculate the mean and stdev between each cell of each file, and to output another csv file, where the mean would be in the same cell/position of the original files. The stdev can be in either another file in the same cell/position, or after all cells:
generation, number_mean, value1_mean, value2_mean,..., valueX_mean, value1_stdev, value2_stdev,...,valueX_stdev
What would be a good way to do this?
It is important that the output csv file follow the same format as the input files.
Thank you very much.