Hi I have table of values stored in a csv file and the table is organized the following way:
Method1,,Method2, T1,T2,T1,T2 a1,b1,c1,d1 a2,b2,c2,d2 a3,b3,c3,d3 a4,b4,c4,d4
One example of something I have to do with this table is to compute the maximum of each row and then for each column I compute the number of times the column equals the maximum value. I am doing this with excel, but I suspect there would be better tools for this, when the the conditions become complicated. I have no experience with databases.
The question is what is the best tool for this, and given that tool point to some basic tutorials to get me started.