Description
Get this error on this code block. Any suggestions?
with pd.HDFStore(DATA_STORE) as store: prices = (store['quandl/wiki/prices'] .loc[idx[str(START):str(END), :], 'adj_close'] .unstack('ticker')) stocks = store['us_equities/stocks'].loc[:, ['marketcap', 'ipoyear', 'sector']]
`---------------------------------------------------------------------------
ValueError Traceback (most recent call last)
in
3 .loc[idx[str(START):str(END), :], 'adj_close']
4 .unstack('ticker'))
----> 5 stocks = store['us_equities/stocks'].loc[:, ['marketcap', 'ipoyear', 'sector']]
/opt/conda/envs/ml4t-dl/lib/python3.7/site-packages/pandas/io/pytables.py in getitem(self, key)
551
552 def getitem(self, key: str):
--> 553 return self.get(key)
554
555 def setitem(self, key: str, value):
/opt/conda/envs/ml4t-dl/lib/python3.7/site-packages/pandas/io/pytables.py in get(self, key)
745 if group is None:
746 raise KeyError(f"No object named {key} in the file")
--> 747 return self._read_group(group)
748
749 def select(
/opt/conda/envs/ml4t-dl/lib/python3.7/site-packages/pandas/io/pytables.py in _read_group(self, group)
1716 s = self._create_storer(group)
1717 s.infer_axes()
-> 1718 return s.read()
1719
1720
/opt/conda/envs/ml4t-dl/lib/python3.7/site-packages/pandas/io/pytables.py in read(self, where, columns, start, stop)
3068
3069 blk_items = self.read_index(f"block{i}_items")
-> 3070 values = self.read_array(f"block{i}_values", start=_start, stop=_stop)
3071
3072 columns = items[items.get_indexer(blk_items)]
/opt/conda/envs/ml4t-dl/lib/python3.7/site-packages/pandas/io/pytables.py in read_array(self, key, start, stop)
2723
2724 if isinstance(node, tables.VLArray):
-> 2725 ret = node[0][start:stop]
2726 else:
2727 dtype = getattr(attrs, "value_type", None)
/opt/conda/envs/ml4t-dl/lib/python3.7/site-packages/tables/vlarray.py in getitem(self, key)
679 key += self.nrows
680 (start, stop, step) = self._process_range(key, key + 1, 1)
--> 681 return self.read(start, stop, step)[0]
682 elif isinstance(key, slice):
683 start, stop, step = self._process_range(
/opt/conda/envs/ml4t-dl/lib/pyt
5524
hon3.7/site-packages/tables/vlarray.py in read(self, start, stop, step)
819 listarr = []
820 else:
--> 821 listarr = self._read_array(start, stop, step)
822
823 atom = self.atom
tables/hdf5extension.pyx in tables.hdf5extension.VLArray._read_array()
ValueError: cannot set WRITEABLE flag to True of this array`