Search Results

indeed :)

Which version of awk are you using?

Thanks.

Ok, so I was able to run this last night on a test file:
a,a,1
a,b,0.8
a,c,0.5
b,b,1
b,c,0.2
c,c,1

It returned:
,a,b,c
,0.5
,0.2
c,1

so the first line looks good, meaning 't' is...

Hi Shamrock,

Thanks very much for your help with this. I must be missing something fundamental when running your script. Whether I simplify it and run line by line or by making it an executable...

Greetings, salutations.

I have a 3 column csv file with ~13 million rows and I would like to generate a correlation matrix. Interestingly, you all previously provided a solution to the inverse of...

Thanks very much shamrock. This works well.

---------- Post updated at 01:28 AM ---------- Previous update was at 01:12 AM ----------

Birei - thank you also. Your perl script also works well.

Greetings, Salutations.

I have 3 column csv files with ~25 million rows and considerable redundancy.

Brief description of data: columns 1 and 2 contain variables, column 3 contains their...