[Pytables-users] subsetting rows from a table referencing more than one condition and column

[Gyan S. <gya...@ya...>]

Hello all:

The following snippet doesn't work as I think it
should and I'd like to understand why.

from tables import *

f = openFile('abs.h5')
abs = f.root.performance

boams = [ x for x in abs if abs.cols.shelf == ' BOAMS'
and abs.cols.sar > 0]

f.close

I think this should give me all rows in the abs table
where the shelf is 'BOAMS' and where the sar value is
greater than zero. However, an inspection of the shelf
values in boams reveals that the result set does not
filter out values that are not ' BOAMS'.

Any clarifications would be appreciated.

Thx in advance.


Gyan P. Sinha21 Cambridge PlaceEnglewood Cliffs,NJ 07632H: (201) 569-3231O: (212) 272-9858

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com