I have two Comma-separated values (csv)
files. Each file has 1000 columns and 1000 rows ( i.e. every csv file form a matrix 1000x1000)
The values for every cell in the first csv file represent the mean.
The values for every cell in the second csv file represent the standard deviation.
I want to create new csv file (also 1000x1000). Every cell in this new csv file represent the coefficient of variation (CV) { cv=std/mean}
How can I divide the cells in the second csv file on the cells in the first csv file to get this new csv spreadsheet
For example ( just part of two columns form every csv file to clarify the issue):
First csv:
2 4 . . . .
2 4 . . . .
2 2 . . . .
2 8 . . . .
. . . . . .
. . . . . .
Second csv:
8 2 . . . .
8 4 . . . .
8 2 . . . .
8 2 . . . .
. . . . . .
. . . . . .
New csv:
4 0.5 . . .
4 1 . . . .
4 1 . . . .
4 0.25 . . .
. . . . . .
. . . . . .
PS. I can do it in Matlab. But I want to know how to achieve this under Unix/Linux commands.
octave
an option? – steeldriver Jul 19 '16 at 00:51