Pandas 0.23.0 gives ImportError: DLL load failed #21106

manish59 · 2018-05-17T17:45:17Z

Installed pandas not able to import with:

ImportError: DLL load failed: The specified module could not be found.

As far as we know, this happens if you install with pip on Windows 32bit machines (if you have another case, please comment below with specifying your OS, Python version, how you installed pandas, ..).

Workaround for now is to keep your version at pandas 0.22.0. (or to install using conda, or to install VS tools for C++, see #21106 (comment))

We will fix this problem for 0.23.1.

original post:

Code Sample, a copy-pastable example if possible

import pandas
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "C:\Users\lfletcher\AppData\Local\Programs\Python\Python36-32\lib\site-pa
ckages\pandas\__init__.py", line 42, in <module>
    from pandas.core.api import *
  File "C:\Users\lfletcher\AppData\Local\Programs\Python\Python36-32\lib\site-pa
ckages\pandas\core\api.py", line 10, in <module>
    from pandas.core.groupby.groupby import Grouper
  File "C:\Users\lfletcher\AppData\Local\Programs\Python\Python36-32\lib\site-pa
ckages\pandas\core\groupby\__init__.py", line 2, in <module>
    from pandas.core.groupby.groupby import (
  File "C:\Users\lfletcher\AppData\Local\Programs\Python\Python36-32\lib\site-pa
ckages\pandas\core\groupby\groupby.py", line 49, in <module>
    from pandas.core.frame import DataFrame
  File "C:\Users\lfletcher\AppData\Local\Programs\Python\Python36-32\lib\site-pa
ckages\pandas\core\frame.py", line 74, in <module>
    from pandas.core.series import Series
  File "C:\Users\lfletcher\AppData\Local\Programs\Python\Python36-32\lib\site-pa
ckages\pandas\core\series.py", line 3978, in <module>
    Series._add_series_or_dataframe_operations()
  File "C:\Users\lfletcher\AppData\Local\Programs\Python\Python36-32\lib\site-pa
ckages\pandas\core\generic.py", line 8891, in _add_series_or_dataframe_operation
s
    from pandas.core import window as rwindow
  File "C:\Users\lfletcher\AppData\Local\Programs\Python\Python36-32\lib\site-pa
ckages\pandas\core\window.py", line 36, in <module>
    import pandas._libs.window as _window
ImportError: DLL load failed: The specified module could not be found.

The text was updated successfully, but these errors were encountered:

TomAugspurger · 2018-05-17T17:47:45Z

How'd you install pandas?

manish59 · 2018-05-17T17:55:40Z

I used pip install pandas

…

On 5/17/18, Tom Augspurger ***@***.***> wrote: How'd you install pandas? -- You are receiving this because you authored the thread. Reply to this email directly or view it on GitHub: #21106 (comment)

manish59 · 2018-05-17T17:55:57Z

the version is 0.23.0

…

On 5/17/18, Manish ***@***.***> wrote: I used pip install pandas On 5/17/18, Tom Augspurger ***@***.***> wrote: > How'd you install pandas? > > -- > You are receiving this because you authored the thread. > Reply to this email directly or view it on GitHub: > #21106 (comment)

TomAugspurger · 2018-05-17T17:56:28Z

Can you paste the output from your pip install?

manish59 · 2018-05-17T18:49:04Z

when i installed from pip it successfully installed. I didnt see any errors

…

On 5/17/18, Tom Augspurger ***@***.***> wrote: Can you paste the output from your pip install? -- You are receiving this because you authored the thread. Reply to this email directly or view it on GitHub: #21106 (comment)

TomAugspurger · 2018-05-17T18:53:08Z

And what was the output? You can uninstall and reinstall to get the log, if you don't have it anymore.

…

On Thu, May 17, 2018 at 1:49 PM, manish59 ***@***.***> wrote: when i installed from pip it successfully installed. I didnt see any errors On 5/17/18, Tom Augspurger ***@***.***> wrote: > Can you paste the output from your pip install? > > -- > You are receiving this because you authored the thread. > Reply to this email directly or view it on GitHub: > #21106 (comment) — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#21106 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ABQHIhnYGqVV7gVU6UpLsqcbfqlWGofsks5tzcYogaJpZM4UDf0A> .

manish59 · 2018-05-17T18:53:39Z

Collecting pandas Using cached https://files.pythonhosted.org/packages/a2/f1/9c90efc7a128c3336bca8ceb38374c2ba97b90d590e3bb9a2cca1c87fda9/pandas-0.23.0-cp36-cp36m-win32.whl Requirement already satisfied: pytz>=2011k in c:\users\lfletcher\appdata\local\programs\python\python36-32\lib\site-packages (from pandas) Requirement already satisfied: numpy>=1.9.0 in c:\users\lfletcher\appdata\local\programs\python\python36-32\lib\site-packages (from pandas) Requirement already satisfied: python-dateutil>=2.5.0 in c:\users\lfletcher\appdata\local\programs\python\python36-32\lib\site-packages (from pandas) Requirement already satisfied: six>=1.5 in c:\users\lfletcher\appdata\local\programs\python\python36-32\lib\site-packages (from python-dateutil>=2.5.0->pandas) Installing collected packages: pandas Successfully installed pandas-0.23.0

…

On 5/17/18, Manish ***@***.***> wrote: when i installed from pip it successfully installed. I didnt see any errors On 5/17/18, Tom Augspurger ***@***.***> wrote: > Can you paste the output from your pip install? > > -- > You are receiving this because you authored the thread. > Reply to this email directly or view it on GitHub: > #21106 (comment)

chris-b1 · 2018-05-17T19:45:53Z

How did you install python? You seem to be on 32 bit windows which is less tested, but I just tried with a clean conda environment and it worked fine

set CONDA_FORCE_32BIT=1
conda create -n py36_32 python=3.6 numpy -y
activate py36_32
pip install pandas
python -c "import pandas"

TomAugspurger · 2018-05-17T19:47:15Z

You might also provide your versions of Pip, setuptools and NumPy.

…

On Thu, May 17, 2018 at 2:45 PM, chris-b1 ***@***.***> wrote: How did you install python? You seem to be on 32 bit windows which is less tested, but I just tried with a clean conda environment and it worked fine set CONDA_FORCE_32BIT=1 conda create -n py36_32 python=3.6 numpy -y activate py36_32 pip install pandas python -c 'import pandas' — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#21106 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ABQHIkQTekIg93m6JwZMqdUyWqn1qo2Gks5tzdN1gaJpZM4UDf0A> .

mezitax · 2018-05-21T22:57:35Z

I have the same problem

pip 10.0.1
python 3.6
NumPy 1.14.3

chris-b1 · 2018-05-22T01:10:35Z

What platform? How did you install python?

…

On Mon, May 21, 2018, 5:57 PM marcelo ***@***.***> wrote: I have the same problem pip 10.0.1 python 3.6 NumPy 1.14.3 — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#21106 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AB1b_BlekLdJj094H7KnItpXnlKPnqS8ks5t00ZygaJpZM4UDf0A> .

abador · 2018-05-22T14:19:03Z

Installation of pandas 0.22.0 seemed to help some of my students

TomAugspurger · 2018-05-22T14:33:52Z

Yes, this issue is apparently with 0.23 wheels. If people could post their Python (installer, 32 or 64 bit), pip, & NumPy info we may be able to track this down.

…

On Tue, May 22, 2018 at 9:19 AM, Abador ***@***.***> wrote: Install version pandas 0.22.0 it seemed to help some of my students — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#21106 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ABQHIpXhMz71zFW-ajVVTiDs0YU1HK-0ks5t1B5igaJpZM4UDf0A> .

asangansi · 2018-05-23T04:37:42Z

I can confirm this issue is due to 0.23
Uninstall then reinstall 0.22

pip uninstall pandas
pip install pandas==0.22

jorisvandenbossche · 2018-05-23T07:45:55Z

@asangansi can you please give the additional information as mentioned here #21106 (comment). That would be helpful.

abador · 2018-05-23T15:43:15Z

As far as I can tell most of my students have libraries similar to this(copy from pyCharm settings):
et-xmlfile 1.0.1
jdcal 1.4 1.4
numpy 1.14.3 1.14.3
openpyxl 2.5.3 2.5.3
pandas 0.23.0 0.23.0
pip 9.0.1 10.0.1
python-dateutil 2.7.3 2.7.3
pytz 2018.4 2018.4
setuptools 28.8.0 39.2.0
six 1.11.0 1.11.0
xlrd 1.1.0 1.1.0

Python 3.6
Project in PyCharm 2018.1.1

TomAugspurger · 2018-05-23T18:17:42Z

Not a whole lot to go on here, but @cgohlke do you have any guesses?

FWIW, _window.pyx is the first C++ pyx file in

pandas/setup.py

Line 334 in 1abfd1b

_cpp_pyxfiles = ['pandas/_libs/window.pyx',

chris-b1 · 2018-05-23T18:36:05Z

Here's another failed attempt to repro, using a python.org binary.

# download, unzip, cd to root of  https://www.python.org/ftp/python/3.6.2/python-3.6.2-embed-win32.zip
rm python36._pth
curl https://bootstrap.pypa.io/get-pip.py > get-pip.py
python get-pip.py
python -m pip install pandas
python
>>> import pandas
>>>

chris-b1 · 2018-05-23T18:57:42Z

c++ is probably the issue, guessing missing the runtime DLL, though I'm not sure the best fix. From what I recall c++ wasn't particularly necessary for that change so could revert back to c for 0.23.1

Could someone one this issue try install the VS 2015 Redistributable and see if that fixes it for you?
https://www.microsoft.com/en-us/download/details.aspx?id=48145

chris-b1 · 2018-05-23T18:59:08Z

PR was #19549

cgohlke · 2018-05-23T19:01:57Z

The missing DLL is most probably MSVCP140.DLL, the MSVC C++ runtime library.

It is part of the Microsoft Visual C++ Redistributable for Visual Studio 2015/2017.

Some projects, e.g. matplotlib, include this DLL in the binary wheels.

jreback · 2018-05-23T22:23:20Z

we have used c++ for quite some time

jorisvandenbossche · 2018-05-23T22:36:46Z

But we were not using libcpp in cython code before. @jreback might that be a difference with previous c++ code of msgpack?

chris-b1 · 2018-05-24T14:12:26Z

That's right, msgpack only depends on libc, where the window extension is utilizing the c++ std library.

manish59 · 2018-05-24T22:45:19Z

When i degraded my pandas version to 0.22 it was solved

On Thu, May 24, 2018 at 7:13 AM chris-b1 ***@***.***> wrote: That's right, msgpack only depends on libc, where the window extension is utilizing the c++ std library. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#21106 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/APQD9Kz2BtVMjaPrDqN-DUt3NG4OLywDks5t1r_tgaJpZM4UDf0A> .

--

jreback · 2018-05-25T13:05:41Z

@chris-b1 can you see what mpl is doing? maybe need a directive in setup.py? or the wheeel building step

jorisvandenbossche · 2018-05-25T13:06:01Z

@cgohlke is this something you want to do? (including the binaries? similar as matplotlib) (since we are using your wheels to upload to pypi)

sionking · 2018-05-28T05:12:08Z

same here:

Traceback (most recent call last):
  File "C:\Program Files (x86)\Python36-32\lib\site-packages\pandas\__init__.py", line 42, in <module>
    from pandas.core.api import *
  File "C:\Program Files (x86)\Python36-32\lib\site-packages\pandas\core\api.py", line 10, in <module>
    from pandas.core.groupby.groupby import Grouper
  File "C:\Program Files (x86)\Python36-32\lib\site-packages\pandas\core\groupby\__init__.py", line 2, in <module>
    from pandas.core.groupby.groupby import (
  File "C:\Program Files (x86)\Python36-32\lib\site-packages\pandas\core\groupby\groupby.py", line 49, in <module>
    from pandas.core.frame import DataFrame
  File "C:\Program Files (x86)\Python36-32\lib\site-packages\pandas\core\frame.py", line 74, in <module>
    from pandas.core.series import Series
  File "C:\Program Files (x86)\Python36-32\lib\site-packages\pandas\core\series.py", line 3978, in <module>
    Series._add_series_or_dataframe_operations()
  File "C:\Program Files (x86)\Python36-32\lib\site-packages\pandas\core\generic.py", line 8891, in _add_series_or_dataframe_operations
    from pandas.core import window as rwindow
  File "C:\Program Files (x86)\Python36-32\lib\site-packages\pandas\core\window.py", line 36, in <module>
    import pandas._libs.window as _window
ImportError: DLL load failed: The specified module could not be found.
PS C:\Users\xxx\Dropbox\xxx>

version 23 fail.
version 22 works.

manish59 · 2018-05-29T05:08:14Z

When i installed pandas 0.23 version i got same error. But when i installed the version to 0.22 it worked. Just saying try these option it might work

On Sun, May 27, 2018 at 10:12 PM sionking ***@***.***> wrote: same here: Traceback (most recent call last): File "C:\Program Files (x86)\Python36-32\lib\site-packages\pandas\__init__.py", line 42, in <module> from pandas.core.api import * File "C:\Program Files (x86)\Python36-32\lib\site-packages\pandas\core\api.py", line 10, in <module> from pandas.core.groupby.groupby import Grouper File "C:\Program Files (x86)\Python36-32\lib\site-packages\pandas\core\groupby\__init__.py", line 2, in <module> from pandas.core.groupby.groupby import ( File "C:\Program Files (x86)\Python36-32\lib\site-packages\pandas\core\groupby\groupby.py", line 49, in <module> from pandas.core.frame import DataFrame File "C:\Program Files (x86)\Python36-32\lib\site-packages\pandas\core\frame.py", line 74, in <module> from pandas.core.series import Series File "C:\Program Files (x86)\Python36-32\lib\site-packages\pandas\core\series.py", line 3978, in <module> Series._add_series_or_dataframe_operations() File "C:\Program Files (x86)\Python36-32\lib\site-packages\pandas\core\generic.py", line 8891, in _add_series_or_dataframe_operations from pandas.core import window as rwindow File "C:\Program Files (x86)\Python36-32\lib\site-packages\pandas\core\window.py", line 36, in <module> import pandas._libs.window as _window ImportError: DLL load failed: The specified module could not be found. PS C:\Users\xxx\Dropbox\xxx> — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#21106 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/APQD9AUAgiw77S7I9l-PqQ6ZNYcARIR6ks5t24c9gaJpZM4UDf0A> .

--

jorisvandenbossche · 2018-06-04T12:17:17Z

Any updates on this? (somebody who can look at fixing the wheel building?)

Otherwise we can also revert the PR (it was only a performance improvement) for 0.23.1, but keep it in master so have more time to fix the wheel building for 0.24.0.

chris-b1 · 2018-06-04T14:46:54Z

Could someone reporting on this issue (@manish59, @sionking, @asangansi, @abador, @mezitax ) please confirm that installing the redistributable fixes this for 0.23? Every windows machine I have access to already has it installed.

I'll look at what matplotlib does later today.

FalconMadhab · 2018-06-06T09:31:17Z

Yes. By uninstalling 0.23 and reinstalling 0.22 of pandas the problem is resolved. Thanks

hashstat · 2018-06-08T19:44:40Z

I ran into the same issue on my Windows 10 x64 VM with Python 3.6.5 (64-bit). The exception was raised when version 0.23.0 was installed and was resolved when I downgraded to 0.22. It was also resolved by installing the MSVC++ redistributable.

mezitax · 2018-09-25T18:50:56Z

Could someone reporting on this issue (@manish59, @sionking, @asangansi, @abador, @mezitax ) please confirm that installing the redistributable fixes this for 0.23? Every windows machine I have access to already has it installed.

I'll look at what matplotlib does later today.

when uninstalling 0.23 and reinstalling 0.22 the problem was solved, thanks!

deepsach · 2020-06-10T17:12:33Z

I get an error
Attribute error:module'numpy' has no attribute__version__
File:C/python /python36 /lib/ site package /pandas /init
From pandas .compat.numpy import(
File:C/python /python36 /lib/ site package /pandas /compat/numpy/init
Attribute error:module'numpy' has no attribute__version__
Please help me to get rid from this error
I stuck in this error from last 5 days I uninstalled panda numpy again and again but nothing will work

sulaksh451 · 2021-02-16T20:40:12Z

I installed panda,, still facing issue in Intellij, Please help me.

Traceback (most recent call last):
File "C:/Users/SBoddula/IdeaProjects/Automation_IS/src/Morpheus.py", line 1, in
import pandas as pd
File "C:\Users\SBoddula\AppData\Local\Programs\Python\Python37\lib\site-packages\pandas_init_.py", line 185, in
v = get_versions()
File "C:\Users\SBoddula\AppData\Local\Programs\Python\Python37\lib\site-packages\pandas_version.py", line 21, in get_versions
return json.loads(version_json)
AttributeError: module 'json' has no attribute 'loads'

gfyoung added the Build Library building on various platforms label May 21, 2018

jorisvandenbossche added this to the 0.23.1 milestone May 23, 2018

jorisvandenbossche changed the title ~~Installed pandas not able to import it as comes this error~~ Pandas 0.23.0 gives ImportError: DLL load failed May 29, 2018

chris-b1 mentioned this issue Jun 5, 2018

BLD: include dll in package_data on Windows #21321

Merged

4 tasks

jreback closed this as completed in #21321 Jun 8, 2018

Pandas 0.23.0 gives ImportError: DLL load failed #21106

Pandas 0.23.0 gives ImportError: DLL load failed #21106

Comments

manish59 commented May 17, 2018 • edited by jorisvandenbossche Loading

Code Sample, a copy-pastable example if possible

TomAugspurger commented May 17, 2018

manish59 commented May 17, 2018 via email

manish59 commented May 17, 2018 via email

TomAugspurger commented May 17, 2018

manish59 commented May 17, 2018 via email

TomAugspurger commented May 17, 2018 via email

manish59 commented May 17, 2018 via email

chris-b1 commented May 17, 2018 • edited Loading

TomAugspurger commented May 17, 2018 via email

mezitax commented May 21, 2018

chris-b1 commented May 22, 2018 via email

abador commented May 22, 2018 • edited Loading

TomAugspurger commented May 22, 2018 via email

asangansi commented May 23, 2018 • edited Loading

jorisvandenbossche commented May 23, 2018

abador commented May 23, 2018

TomAugspurger commented May 23, 2018

chris-b1 commented May 23, 2018

chris-b1 commented May 23, 2018

chris-b1 commented May 23, 2018

cgohlke commented May 23, 2018

jreback commented May 23, 2018

jorisvandenbossche commented May 23, 2018

chris-b1 commented May 24, 2018

manish59 commented May 24, 2018 via email

jreback commented May 25, 2018

jorisvandenbossche commented May 25, 2018

sionking commented May 28, 2018 • edited Loading

manish59 commented May 29, 2018 via email

jorisvandenbossche commented Jun 4, 2018

chris-b1 commented Jun 4, 2018

FalconMadhab commented Jun 6, 2018

hashstat commented Jun 8, 2018

mezitax commented Sep 25, 2018

deepsach commented Jun 10, 2020

sulaksh451 commented Feb 16, 2021

manish59 commented May 17, 2018 •

edited by jorisvandenbossche

Loading

chris-b1 commented May 17, 2018 •

edited

Loading

abador commented May 22, 2018 •

edited

Loading

asangansi commented May 23, 2018 •

edited

Loading

sionking commented May 28, 2018 •

edited

Loading