Re: [Numpy-discussion] numpy sum table by category

2010-01-13 Thread Ernest Adrogué
12/01/10 @ 15:33 (-0500), thus spake Marc Schwarzschild: I have a csv file like this: Account, Symbol, Quantity, Price One,SPY,5,119.00 One,SPY,3,120.00 One,SPY,-2,125.00 One,GE,... One,GE,... Two,SPY, ... Three,GE, ... ... The data is much

[Numpy-discussion] numpy sum table by category

2010-01-12 Thread Marc Schwarzschild
I have a csv file like this: Account, Symbol, Quantity, Price One,SPY,5,119.00 One,SPY,3,120.00 One,SPY,-2,125.00 One,GE,... One,GE,... Two,SPY, ... Three,GE, ... ... The data is much larger, could be 10,000 records. I can load it into a numpy array using

Re: [Numpy-discussion] numpy sum table by category

2010-01-12 Thread josef . pktd
On Tue, Jan 12, 2010 at 3:33 PM, Marc Schwarzschild m...@thebrookhavengroup.com wrote: I have a csv file like this:    Account, Symbol, Quantity, Price    One,SPY,5,119.00    One,SPY,3,120.00    One,SPY,-2,125.00    One,GE,...    One,GE,...    Two,SPY, ...    Three,GE, ...     ...