Troubleshoot HDFStore exceptions Setting min_itemsize with strings Storing Attributes to a group node In [1]: df = DataFrame(np.random.randn(8,3)) In [2]: store = HDFStore(’test.h5’) In [3]: store append]) Store object in HDFStore HDFStore.append(key, value[, columns]) Append to Table in file. Node must already exist and be Table HDFStore.get(key) Retrieve pandas object stored in file HDFStore pytables.HDFStore.append HDFStore.append(key, value, columns=None, **kwargs) Append to Table in file. Node must already exist and be Table format. Parameters key : object value : {Series, DataFrame, Panel

stored under the root node. In [8]: store.foo.bar.bah AttributeError: 'HDFStore' object has no attribute 'foo' # you can directly access the actual PyTables node but using the root node In [9]: store.root

strings Using ptrepack to create a completely-sorted-index on a store Storing Attributes to a group node In [5]: df = DataFrame(np.random.randn(8,3)) In [6]: store = HDFStore(’test.h5’) In [7]: store append]) Store object in HDFStore HDFStore.append(key, value[, format, ...]) Append to Table in file. Node must already exist and be Table HDFStore.get(key) Retrieve pandas object stored in file HDFStore append(key, value, format=None, append=True, columns=None, dropna=None, **kwargs) Append to Table in file. Node must already exist and be Table format. Parameters key : object value : {Series, DataFrame, Panel

strings Using ptrepack to create a completely-sorted-index on a store Storing Attributes to a group node In [11]: df = DataFrame(np.random.randn(8,3)) In [12]: store = HDFStore(’test.h5’) In [13]: store append]) Store object in HDFStore HDFStore.append(key, value[, format, ...]) Append to Table in file. Node must already exist and be Table HDFStore.get(key) Retrieve pandas object stored in file HDFStore append(key, value, format=None, append=True, columns=None, dropna=None, **kwargs) Append to Table in file. Node must already exist and be Table format. Parameters key : object value : {Series, DataFrame, Panel

strings Using ptrepack to create a completely-sorted-index on a store Storing Attributes to a group node In [159]: df = pd.DataFrame(np.random.randn(8,3)) In [160]: store = pd.HDFStore(’test.h5’) In [161]: append]) Store object in HDFStore HDFStore.append(key, value[, format, ...]) Append to Table in file. Node must already exist and be Table HDFStore.get(key) Retrieve pandas object stored in file HDFStore append(key, value, format=None, append=True, columns=None, dropna=None, **kwargs) Append to Table in file. Node must already exist and be Table format. Parameters key : object value : {Series, DataFrame, Panel

strings Using ptrepack to create a completely-sorted-index on a store Storing Attributes to a group node In [159]: df = pd.DataFrame(np.random.randn(8,3)) In [160]: store = pd.HDFStore(’test.h5’) In [161]: append]) Store object in HDFStore HDFStore.append(key, value[, format, ...]) Append to Table in file. Node must already exist and be Table HDFStore.get(key) Retrieve pandas object stored in file HDFStore append(key, value, format=None, append=True, columns=None, dropna=None, **kwargs) Append to Table in file. Node must already exist and be Table format. Parameters key : object value : {Series, DataFrame, Panel

strings Using ptrepack to create a completely-sorted-index on a store Storing Attributes to a group node In [172]: df = pd.DataFrame(np.random.randn(8,3)) In [173]: store = pd.HDFStore('test.h5') In [174]: stored under the root node. In [8]: store.foo.bar.bah AttributeError: 'HDFStore' object has no attribute 'foo' # you can directly access the actual PyTables node but using the root node In [9]: store.root append(key, value, format=None, append=True, columns=None, dropna=None, **kwargs) Append to Table in file. Node must already exist and be Table format. Parameters key : object value : {Series, DataFrame, Panel

strings Using ptrepack to create a completely-sorted-index on a store Storing Attributes to a group node In [172]: df = pd.DataFrame(np.random.randn(8,3)) In [173]: store = pd.HDFStore('test.h5') In [174]: stored under the root node. In [8]: store.foo.bar.bah AttributeError: 'HDFStore' object has no attribute 'foo' # you can directly access the actual PyTables node but using the root node In [9]: store.root append(key, value, format=None, append=True, columns=None, dropna=None, **kwargs) Append to Table in file. Node must already exist and be Table format. Parameters key : object value : {Series, DataFrame, Panel

strings Using ptrepack to create a completely-sorted-index on a store Storing Attributes to a group node In [173]: df = pd.DataFrame(np.random.randn(8,3)) In [174]: store = pd.HDFStore('test.h5') In [175]: stored under the root node. In [8]: store.foo.bar.bah AttributeError: 'HDFStore' object has no attribute 'foo' # you can directly access the actual PyTables node but using the root node In [9]: store.root append(key, value, format=None, append=True, columns=None, dropna=None, **kwargs) Append to Table in file. Node must already exist and be Table format. Parameters key : object value : {Series, DataFrame, Panel

strings Using ptrepack to create a completely-sorted-index on a store Storing Attributes to a group node In [173]: df = pd.DataFrame(np.random.randn(8,3)) In [174]: store = pd.HDFStore('test.h5') In [175]: stored under the root node. In [8]: store.foo.bar.bah AttributeError: 'HDFStore' object has no attribute 'foo' # you can directly access the actual PyTables node but using the root node In [9]: store.root append(key, value, format=None, append=True, columns=None, dropna=None, **kwargs) Append to Table in file. Node must already exist and be Table format. Parameters key : object value : {Series, DataFrame, Panel