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
It seems that refs were proposed in the past, even with an implementation.
Maybe this could be a starting point:
http://www.mail-archive.com/pytables-users@lists.sourceforge.net/msg01374.html
-á.
On Thu, Mar 15, 2012 at 12:56, Alvaro Tejero Cantero wrote:
> Does PyTables support object regio
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
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
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
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
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
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
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