Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

Thanks!

share|improve this question
add comment

2 Answers

If you aren't comfortable with programming languages (like Ruby, Python, PHP, etc.), then Excel is probably your best bet.

If you are having trouble understanding pivot tables, no worries! It's an easy enough process to make step-wise summary tables: e.g. you have your main table of raw information and you have intermediary tables (like row-max-values) and Excel has functions like VLOOKUP that can help you with the rest.

Check out Excel's lookup, vlookup, hlookup and math functions - it probably has all you need.

share|improve this answer
    
I am familiar with python... is there any package to do this kind of thing there or I would have to write on from scratch? –  skeept Feb 29 '12 at 21:32
    
You could use the csv module to read the file in. You can then iterate over the rows, convert to a number format and find the max/count it. Are you proficient enough in Python to write that part yourself? –  Bob Mar 1 '12 at 12:17
    
It wouldn't be very difficult to read the file in and then split the characters by newline and then by comma...then it's just a matter of looping over each of those values to derive your minimums/maximums. –  JakeTheSnake Mar 15 '12 at 0:28
add comment

If you want to do simple things like count, sum, min, max, etc.., you can just dump all of the data into an Excel spreadsheet and use Pivot Tables to create the different looks you need. Pivot tables are all drag & drop and very powerful.

Here are a few good tutorials or just Google "Pivot table tutorials and the version of Excel you have"

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.