Re: [Pytables-users] Help on sorting tables

2012-03-22 Thread Francesc Alted
On 3/22/12 1:59 PM, Francesc Alted wrote: On 3/22/12 12:48 PM, sreeaurovindh viswanathan wrote: But.. Can i get sort one column by descending and the other ascending. say if i have two columns and first i would like to sort the one in ascending and then sort the second column based on the search

Re: [Pytables-users] Help on sorting tables

2012-03-22 Thread Francesc Alted
On 3/22/12 12:48 PM, sreeaurovindh viswanathan wrote: > But.. Can i get sort one column by descending and the other ascending. > say > if i have two columns and first i would like to sort the one in > ascending and then sort the second column based on the search from the > first. > > > I mean I i h

Re: [Pytables-users] Help on sorting tables

2012-03-22 Thread sreeaurovindh viswanathan
But.. Can i get sort one column by descending and the other ascending. say if i have two columns and first i would like to sort the one in ascending and then sort the second column based on the search from the first. I mean I i have 1 5 2 6 1 8 2 9 Could i get an output as 1 5 1 8 2 6 2 9 Sor

Re: [Pytables-users] Help on sorting tables

2012-03-22 Thread Ümit Seren
I completely forgot about the CSI index. That's of course much easier than what I suggested ;-) Am 22.03.2012 17:39 schrieb "Francesc Alted" : > On 3/22/12 11:02 AM, sreeaurovindh viswanathan wrote: > > Hi, > > > > If I have three columns in a table and if i wish to sort based on one > > field and

Re: [Pytables-users] Help on sorting tables

2012-03-22 Thread sreeaurovindh viswanathan
Thanks Francesc Alted for your advice. Regards Sree aurovindh V On Thu, Mar 22, 2012 at 10:09 PM, Francesc Alted wrote: > On 3/22/12 11:02 AM, sreeaurovindh viswanathan wrote: >> Hi, >> >> If I have three columns in a table and if i wish to sort based on one >> field and then on the other what w

Re: [Pytables-users] Help on sorting tables

2012-03-22 Thread Francesc Alted
On 3/22/12 11:02 AM, sreeaurovindh viswanathan wrote: > Hi, > > If I have three columns in a table and if i wish to sort based on one > field and then on the other what would be the recommended method.I > would be sorting atleast 75,00,000 records at a time. > > ie I would like to use something equ

Re: [Pytables-users] Help on sorting tables

2012-03-22 Thread Ümit Seren
AFAIK there is no sort functionality built into PyTables. I think there are 4 ways to do it: 1.) load all 7.5 million records and sort it in memory (if it fits into the memory) 2.) implement your own external sorting algorithm (http://en.wikipedia.org/wiki/External_sorting) using pytables iterato