How to solve import error for pandas?

Question

I installed Anaconda with python 2.7.7.
However, whenever I run "import pandas" I get the error:
"ImportError: C extension: y not built. If you want to import pandas from the source directory, you may need to run 'python setup.py build_ext --inplace' to build the C extensions first."
I tried running the suggested command but it stated that

skipping 'pandas\index.c' Cython extension (up-to-date)      
skipping 'pandas\src\period.c' Cython extension (up-to-date) 
skipping 'pandas\algos.c' Cython extension (up-to-date)      
skipping 'pandas\lib.c' Cython extension (up-to-date)        
skipping 'pandas\tslib.c' Cython extension (up-to-date)      
skipping 'pandas\parser.c' Cython extension (up-to-date)     
skipping 'pandas\hashtable.c' Cython extension (up-to-date)  
skipping 'pandas\src\sparse.c' Cython extension (up-to-date) 
skipping 'pandas\src\testing.c' Cython extension (up-to-date)
skipping 'pandas\msgpack.cpp' Cython extension (up-to-date)

Has anyone encountered this before and found a solution?

score 31 · Answer 1 · edited Aug 13 '20 at 08:04

31

I was having the same problem now with Python 3.4.3.

I was using pandas-0.18.0.

Upgrading (using pip) solved the issue for me:

[sudo] pip install --upgrade pandas

The final result of the upgrade:

Successfully installed numpy-1.13.3 pandas-0.21.0 python-dateutil-2.6.1 pytz-2017.3 six-1.11.0

After this, the issue was gone!

edited Aug 13 '20 at 08:04

subtleseeker

4,415
5
29
41

answered Nov 08 '17 at 15:45

João Quintas

761
2
9
18

vicg · Accepted Answer · 2016-10-23T05:00:01.160

13

Pandas has portions of its code written in C to make it run faster. If you tried to install pandas manually you would need to build it. Try reinstalling it with miniconda package manager here: http://conda.pydata.org/miniconda.html

and then you can just do

conda install pandas

There are very simple instructions on how to do it in the link below. Just do ctrl-f miniconda to find the section that talks about it

http://pandas.pydata.org/pandas-docs/dev/install.html

edited Oct 23 '16 at 05:00

answered Jun 10 '15 at 15:49

vicg

1,280
14
32

3

I actually can't use conda because I'm in a business environment that doesn't allow proxies. – Alex F Jun 10 '15 at 16:02
2

The strange thing is that I can run "import pandas" in the python prompt but it causes an error when I try to execute a file with "import pandas" in it. – Alex F Jun 10 '15 at 16:03
You have to build pandas because the c files are uncompiled – vicg Jun 10 '15 at 16:04
2

Okay big update. I realized I can compile files with the "import pandas" in certain directories but not in others...Any ideas why? – Alex F Jun 10 '15 at 16:24
Could you provide the directory structure? – vicg Jun 10 '15 at 17:47
The directory was "C:\DeveloperDesktop\workspaces\default\TestDataSource". However, I tried creating a new project in eclipse and it worked fine. Somehow, the path to the other project became corrupted. – Alex F Jun 10 '15 at 17:57

score 12 · Answer 3 · answered Sep 06 '16 at 07:13

I had the same problem and the issue came from an encoding problem. My os was previously set up in French and everything was fine. But then when I switched to English I had the error above.

You can type

locale

in the terminal to check the local environment variables.

When set up in French, I had this configuration: French config. Then, after I switched to English, I had: English config.

I then added the following lines in the .bash_profile under /Users/myName and everything went back to normal.

export LC_ALL=en_US.UTF-8
export LANG=en_US.UTF-8

score 10 · Answer 4 · answered Dec 13 '17 at 05:09

I was having this problem with python 2.7.13 here is my solution: 1. install Cython with

pip install Cython

2. install g++ and gcc

apt-get install gcc, g++

3. uninstall pandas

pip uninstall pandas

4. reinstall pandas

pip install pandas

then everything will be OK.

score 8 · Answer 5 · edited May 03 '18 at 08:43

8

I was unable to upgrade pandas with regular

pip install --upgrade pandas 

"tensorflow 1.6.0 has requirement numpy>=1.13.3, but you'll have numpy 1.13.1 which is incompatible."

However bumping it with:

pip install --upgrade pandas --force

solved issue completely

edited May 03 '18 at 08:43

Adeel

2,901
7
24
34

answered May 03 '18 at 08:08

Dimitry Boguslavsky

81
1
1

Did this the work for me as well, and I was working on a virtual env. Thanks – eafloresf Mar 30 '21 at 23:51

score 3 · Answer 6 · edited May 23 '19 at 12:42

I tried all the solutions above, but nothing works out...

Error Message

I got an error message with ipython

ImportError: C extension: iNaT not built. If you want to import pandas 
from the source directory, 
you may need to run 'python setup.py build_ext --inplace --force' 
to build the C extensions first.

and it suggests

$ python setup.py build_ext --inplace --force

Solution

My suggestion: Be careful about the version issue!

I clone pandas from the official github repo, then build it myself and install by pip

Following is the command I typed in terminal

$ cd pandas

$ python setup.py build_ext --inplace --force

$ sudo pip install .  # don't forget the dot

or, if you want to install in your personal Linux account instead of under the system (due to multiple users issue)

you can add --user flag

$ pip --user install . # don't forget the dot, too

Now, everything works fine on my laptop

My configuration

Ubuntu 16.04
Python 2.7
Numpy 1.13.1

Good luck!

score 1 · Answer 7 · answered Jun 06 '17 at 01:02

1

Instead of installing it with conda or pip, try to install it with your package manager:

sudo apt-get install python3-pandas

answered Jun 06 '17 at 01:02

colo

152
4

score 1 · Answer 8 · answered Nov 09 '18 at 14:57

Actually, none of these answers worked for me in the following environment:

docker-compose # multiple containers, the managing one based on debian
Python 2.7
Django 1.8.19
numpy==1.11.3 # pinned to version, because of https://github.com/rbgirshick/py-faster-rcnn/issues/481

... more requirements

The following solution worked, after reading

https://github.com/pandas-dev/pandas/issues/18281

and

https://github.com/pandas-dev/pandas/issues/16715

which both addressed interim solutions and later recommended upgrading,

so I integrated into the Dockerfile

pip install -r requirements.txt \
&& pip install \
pandas==0.21.0 \
--force-reinstall \
--upgrade \
--no-deps \
--no-cache \
--find-links https://3f23b170c54c2533c070-1c8a9b3114517dc5fe17b7c3f8c63a43.ssl.cf2.rackcdn.com/ \
--no-index

which is mentioned in https://github.com/pandas-dev/pandas/issues/16715#issuecomment-310063504

I tried all solutions mentioned here, except the accepted answer, also because a) I don't want anaconda in a web production environment and b) it's not a good answer to foster frameworks or cli-solutions for architectures, where a package is not used standalone...

Furthermore, I dislike @colo's answer being downvoted, because it actually is a feasible solution in a certain environment.

For anyone finding this thread with similar requirements and expectations like me, I hope to have saved some minutes.

score 0 · Answer 9 · answered May 24 '17 at 19:57

0

try

/miniconda3/bin/conda install python

python: 3.6.0-0 --> 3.6.1-2

and

/miniconda3/bin/conda install pandas

Try the same with your Anaconda version.

answered May 24 '17 at 19:57

Kaushik Velusamy

111
1
9

score 0 · Answer 10 · answered Jan 22 '18 at 16:49

0

I had this issue when I needed up upgrade from Python 32 bit to 64 bit to use tensorflow.

Running this command uninstalled pandas 0.21 and reinstalled 0.22 :

pip install --upgrade pandas

Sorted.

answered Jan 22 '18 at 16:49

John McCurdy

41
3

score 0 · Answer 11 · answered May 29 '18 at 06:37

0

I just had exactly the same issue when running tox.

Steps to solve:

Update setup.py to contain pandas==0.23.0 (instead of 0.21.0).
Remove .tox directory
Run tox again.

answered May 29 '18 at 06:37

Martin Thoma

124,992
159
614
958

score 0 · Answer 12 · answered Dec 05 '20 at 21:12

0

upgrading pip solved the issue for me:

pip install --upgrade pip

answered Dec 05 '20 at 21:12

Khalil Meg

731
10
14

score 0 · Answer 13 · answered Feb 12 '21 at 18:41

0

Ok, I tried more than 20 differents way of install/uninstall, it was still not working. (conda and pip, --force --upgrade, ==THEGOODVERSION, etc...).

At the end I found that I had the wrong PATH...

answered Feb 12 '21 at 18:41

score 0 · Answer 14 · answered Oct 14 '21 at 16:25

So another problem that you may have and this was the case for me: You may have multiple versions of Python on your system in different locations So even though you have pip installed everything up to date, it may be trying to interpret a version that hasn't had that pip update applied.

So within your IDE say Visual Studio Code, check to be sure you are using the correct Python interpreter.

In VS Code you can find this by clicking on Python in the Left side of the bottom blue bar. If multiple interpreters show up, you may need to use those paths and uninstall all the others to eliminate the confusion.

How to solve import error for pandas?

14 Answers14

Error Message

Solution

My configuration

Linked