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

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 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, ... >     ... > > The data is mu

[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 m