(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

[theinquisitor.livejournal.com]

Create foo.pl as below:

#! /usr/bin/perl
while(<>=~/^(.*?),(.*)\n$/){$v{$1}+=$2;}
print $v;

Then

cat bah | ./foo.pl | [Command-line pi chart generator of choice]

Obviously, you may need to adapt the regexp slightly.