python 2.7 - Pandas HD5-query, where expression fails -


i want query hdf5-file. do

df.to_hdf(pfad,'df', format='table') 

to write dataframe on disc.

to read use

hdf = pandas.hdfstore(pfad) 

i have list contains numpy.datetime64 values called expirations , try read portion of hd5 table dataframe, has values between expirations[1] , expirations[0] in column "expiration". column expiration entries have format timestamp('2002-05-18 00:00:00').

i use following command:

df = hdf.select('df',                 where=['expiration<expiration[1]','expiration>=expirations[0]']) 

however, fails , produces value error:

 valueerror: passed expression: [expiration=expirations[0]]             contains invalid variable reference             of variable refrences must reference             axis (e.g. 'index' or 'columns'), or data_column             defined references are: index,columns 


Comments

Popular posts from this blog

matlab - "Contour not rendered for non-finite ZData" -

delphi - Indy UDP Read Contents of Adata -

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -