Pandas 1.0.3 on Windows 7 64bit throws error "DLL load failed while importing aggregations" on import. Version 1.0.1 works fine.

[mborus]

TLDR; 2 DLLs are missing that were included in 1.0.1

Code Sample, a copy-pastable example if possible

import pandas as pd

Problem description

I'm using Windows 7, German 64bit with a fresh installation of Python 3.8.2 64bit.
I updated pip, created a fresh virtual environment with "py -3 -m venv venv" and activated it.
This installation is in a restricted area with no direct, unfiltered internet access.

I installed Pandas 1.0.3 from a via "python -m pip download pandas" download made on an unrestricted similar Windows7 machine. I moved the download folder behind a firewall and installed Pandas like this: "python -m pip install pandas --no-index --find-links /path/to/downloads":

Pandas installs fine. It crashes on import with the error below (The last sentence says in English: The requested Module was not found)

As recommended by this stack overflow thread (https://stackoverflow.com/questions/60763529/unable-to-import-pandas-pandas-libs-window-aggregations) going back to 1.0.1 fixes the problem. (More below, after the error)

Error:

(venv) C:\my_program>python
Python 3.8.2 (tags/v3.8.2:7b3ab59, Feb 25 2020, 23:03:10) [MSC v.1916 64 bit (AM
D64)] on win32
Type "help", "copyright", "credits" or "license" for more information.

import pandas as pd
Traceback (most recent call last):
File "", line 1, in
File "C:\my_program\venv\lib\site-packages\pandas_init_.py", line 5
5, in
from pandas.core.api import (
File "C:\my_program\venv\lib\site-packages\pandas\core\api.py", line 2
9, in
from pandas.core.groupby import Grouper, NamedAgg
File "C:\my_program\venv\lib\site-packages\pandas\core\groupby_init
_.py", line 1, in
from pandas.core.groupby.generic import DataFrameGroupBy, NamedAgg, SeriesGr
oupBy
File "C:\my_program\venv\lib\site-packages\pandas\core\groupby\generic
.py", line 60, in
from pandas.core.frame import DataFrame
File "C:\my_program\venv\lib\site-packages\pandas\core\frame.py", line
124, in
from pandas.core.series import Series
File "C:\my_program\venv\lib\site-packages\pandas\core\series.py", lin
e 4572, in
Series._add_series_or_dataframe_operations()
File "C:\my_program\venv\lib\site-packages\pandas\core\generic.py", li
ne 10349, in add_series_or_dataframe_operations
from pandas.core.window import EWM, Expanding, Rolling, Window
File "C:\my_program\venv\lib\site-packages\pandas\core\window_init
.py", line 1, in
from pandas.core.window.ewm import EWM # noqa:F401
File "C:\my_program\venv\lib\site-packages\pandas\core\window\ewm.py",
line 5, in
import pandas._libs.window.aggregations as window_aggregations
ImportError: DLL load failed while importing aggregations: Das angegebene Modul
wurde nicht gefunden.

I compared the installation of version 1.0.1 to 1.0.3;

The 1.0.3 installs these files in
"\venv\Lib\site-packages\pandas_libs\window"

    __init__.py
    aggregations.cp38-win_amd64.pyd
    indexers.cp38-win_amd64.pyd

The 1.0.1 version also installs these two DLLs in the same folder.

    concrt140.dll
    msvcp140.dll

When I manually place these DLLs into the above folder of the 1.0.3 version,
the import works without an error.

Expected Output

No error message

Output of pd.show_versions()

Not available, since pd did not import

[TomAugspurger]

This looks to be a duplicate of #32857. I'll copy your comment over there.

[AaryamanCodes]

TLDR; 2 DLLs are missing that were included in 1.0.1

Code Sample, a copy-pastable example if possible

import pandas as pd

Problem description

I'm using Windows 7, German 64bit with a fresh installation of Python 3.8.2 64bit.
I updated pip, created a fresh virtual environment with "py -3 -m venv venv" and activated it.
This installation is in a restricted area with no direct, unfiltered internet access.

I installed Pandas 1.0.3 from a via "python -m pip download pandas" download made on an unrestricted similar Windows7 machine. I moved the download folder behind a firewall and installed Pandas like this: "python -m pip install pandas --no-index --find-links /path/to/downloads":

Pandas installs fine. It crashes on import with the error below (The last sentence says in English: The requested Module was not found)

As recommended by this stack overflow thread (https://stackoverflow.com/questions/60763529/unable-to-import-pandas-pandas-libs-window-aggregations) going back to 1.0.1 fixes the problem. (More below, after the error)

Error:

(venv) C:\my_program>python
Python 3.8.2 (tags/v3.8.2:7b3ab59, Feb 25 2020, 23:03:10) [MSC v.1916 64 bit (AM
D64)] on win32
Type "help", "copyright", "credits" or "license" for more information.

import pandas as pd
Traceback (most recent call last):
File "", line 1, in
File "C:\my_program\venv\lib\site-packages\pandas__init__.py", line 5
5, in
from pandas.core.api import (
File "C:\my_program\venv\lib\site-packages\pandas\core\api.py", line 2
9, in
from pandas.core.groupby import Grouper, NamedAgg
File "C:\my_program\venv\lib\site-packages\pandas\core\groupby__init_
_.py", line 1, in
from pandas.core.groupby.generic import DataFrameGroupBy, NamedAgg, SeriesGr
oupBy
File "C:\my_program\venv\lib\site-packages\pandas\core\groupby\generic
.py", line 60, in
from pandas.core.frame import DataFrame
File "C:\my_program\venv\lib\site-packages\pandas\core\frame.py", line
124, in
from pandas.core.series import Series
File "C:\my_program\venv\lib\site-packages\pandas\core\series.py", lin
e 4572, in
Series.add_series_or_dataframe_operations()
File "C:\my_program\venv\lib\site-packages\pandas\core\generic.py", li
ne 10349, in add_series_or_dataframe_operations
from pandas.core.window import EWM, Expanding, Rolling, Window
File "C:\my_program\venv\lib\site-packages\pandas\core\window__init
.py", line 1, in
from pandas.core.window.ewm import EWM # noqa:F401
File "C:\my_program\venv\lib\site-packages\pandas\core\window\ewm.py",
line 5, in
import pandas._libs.window.aggregations as window_aggregations
ImportError: DLL load failed while importing aggregations: Das angegebene Modul
wurde nicht gefunden.

I compared the installation of version 1.0.1 to 1.0.3;

The 1.0.3 installs these files in
"\venv\Lib\site-packages\pandas_libs\window"

    __init__.py
    aggregations.cp38-win_amd64.pyd
    indexers.cp38-win_amd64.pyd

The 1.0.1 version also installs these two DLLs in the same folder.

    concrt140.dll
    msvcp140.dll

When I manually place these DLLs into the above folder of the 1.0.3 version,
the import works without an error.

Expected Output

No error message

Output of pd.show_versions()

Not available, since pd did not import

Download again using pip and it may work for you or try out Jupyter notebooks, It works there.

[Bellobn666]

thanks man. works like a charm

[AaryamanCodes]

My Pleasure.