(no subject)

[chess]

There really should be a program for what I want to do:
Assign a list of numbers (positive and negative) I have in a CSV file to catagories (named with arbitary strings) whilst looking at a description of them also held in the CSV file
Easily generate a pie chart showing the total number in each catagory.

Currently I am doing it with a spreadsheet, which works but is kind of tedious as it doesn't have an 'okay, give me a total of everything in column Y where column X has the value Foo' function.

Comments

[hatter.livejournal.com]

It's called a 'database'. In addition to the python/pychart, suggestion, there's also the perl way, with DBD::CSV to talk sql at it like any other db. Or a few lines of bash, a dose of sort/split/uniq, and back to excel with the trivially graphable results.


the hatter