pandas.HDFStore.select#
- HDFStore.select(key, where=None, start=None, stop=None, columns=None, iterator=False, chunksize=None, auto_close=False)[source]#
Retrieve pandas object stored in file, optionally based on where criteria.
Warning
Pandas uses PyTables for reading and writing HDF5 files, which allows serializing object-dtype data with pickle when using the “fixed” format. Loading pickled data received from untrusted sources can be unsafe.
See: https://docs.python.org/3/library/pickle.html for more.
- Parameters
- keystr
Object being retrieved from file.
- wherelist or None
List of Term (or convertible) objects, optional.
- startint or None
Row number to start selection.
- stopint, default None
Row number to stop selection.
- columnslist or None
A list of columns that if not None, will limit the return columns.
- iteratorbool or False
Returns an iterator.
- chunksizeint or None
Number or rows to include in iteration, return an iterator.
- auto_closebool or False
Should automatically close the store when finished.
- Returns
- object
Retrieved object from file.