Re: [Pytables-users] Help on sorting tables

[sreeaurovindh v. <sre...@gm...>]

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

Sorry to restart the thread.

Thanks
Sree aurovindhV



On Thu, Mar 22, 2012 at 10:09 PM, Francesc Alted <fa...@gm...> 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 would be the recommended method.I
>> would be sorting atleast 75,00,000 records at a time.
>>
>> ie I would like to use something equivalent the following sql query.
>>
>> Select * from sample.table order by query desc,keyword asc.
> Provided that you have created a CSI index on this field, there are a
> couple of ways for doing this:
>
> 1) Table.itersorted(): retrieves the table records in sorted order
>
> 2) Table.readSorted(): retrieves the complete sorted table as a
> monolithic structured array
>
> Both methods follow ascending order by default.  Choose a step=-1 for
> choosing a descending order.
>
> -- Francesc Alted
>
> ------------------------------------------------------------------------------
> This SF email is sponsosred by:
> Try Windows Azure free for 90 days Click Here
> http://p.sf.net/sfu/sfd2d-msazure
> _______________________________________________
> Pytables-users mailing list
> Pyt...@li...
> https://lists.sourceforge.net/lists/listinfo/pytables-users