ImportError HDFStore requires PyTables No module named tables

Question

import pandas as pd
dfs = pd.HDFStore('xxxxx.h5')

throws this error:

"ImportError: HDFStore requires PyTables, "No module named tables" problem importing"

I tried to install PyTables, which Requires Cython. I have Cython 0.21 installed, but it is throwing an error stating that Cython should be greater than 0.13

Here is the log that I am getting:

".. ERROR:: You need Cython 0.13 or greater to compile PyTables!

----------------------------------------
Cleaning up...
Command python setup.py egg_info failed with error code 1 in /private/tmp/pip_build_root/tables
Storing debug log for failure in /Users/nikhilsahai/Library/Logs/pip.log
Nikhils-MacBook-Pro:~ nikhilsahai$ sudo pip install cython
Requirement already satisfied (use --upgrade to upgrade): cython in /Library/Python/2.7/site-packages/Cython-0.21-py2.7-macosx-10.9-intel.egg
Cleaning up..."

Please guide me how to do solve this issue.

Answer 1

Simply updating pytables with:

pip install --upgrade tables

worked for me.

Answer 2

I also had the same error when using HDFStore. And I tried all the steps specified above and spent many hours to find a solution, but non of them were successful.

Then I downloaded and installed MiniConda. And then I used the below command to install pytables.

conda install -c conda-forge pytables

Please refer the below screenshot.

Answer 3

On Ubuntu, I solved this problem using this command:

sudo apt-get install python3-tables

Note that I am using Python 3

Answer 4

You can use pip on any os :

python -m pip install tables

You can check the official documentation on more ways to install it http://www.pytables.org/usersguide/installation.html