Hi. I have a symmetric square matrix (see attached file as sample). I need to convert it to a three column list (I only need either the upper triangular part or the lower triangular part since it is symmetric).
Can anyone give me a perl script that will do it? The actual matrix will be a csv file called similarityM.csv and will only contain the matrix.
With the attached matrix I would want to arrive at something like the following (the '...' mean etc)
allwineclub amazing -0.007007171
allwineclub awesome -0.005773905
amazing awesome 0.019403651
amazing back -0.001234014
awesome back -0.00770258