statsmodels: ImportError: DLL load failed while importing _arpack: The specified procedure could not be found

Question

I got the following error when doing this: from statsmodels.tsa.stattools import adfuller,

I did follow the previous post and uninstall scipy and reinstall scipy by doing pip install -U scipy and it did tell me some error as well, but it did eventually install scipy 1.7.3. Any suggestion? Thanks

---------------------------------------------------------------------------
ImportError                               Traceback (most recent call last)
~\AppData\Local\Temp/ipykernel_20892/21545664.py in <module>
      2 import pandas as pd
      3 import matplotlib.pyplot as plt
----> 4 from statsmodels.tsa.stattools import adfuller
      5 plt.style.use('seaborn')
      6 import warnings

~\miniconda3\lib\site-packages\statsmodels\tsa\stattools.py in <module>
     12 from numpy.linalg import LinAlgError
     13 import pandas as pd
---> 14 from scipy import stats
     15 
     16 from statsmodels.regression.linear_model import OLS, yule_walker

~\miniconda3\lib\site-packages\scipy\stats\__init__.py in <module>
    439 """
    440 
--> 441 from .stats import *
    442 from .distributions import *
    443 from .morestats import *

~\miniconda3\lib\site-packages\scipy\stats\stats.py in <module>
     41 import scipy.special as special
     42 from scipy import linalg
---> 43 from . import distributions
     44 from . import mstats_basic
     45 from ._stats_mstats_common import (_find_repeats, linregress, theilslopes,

~\miniconda3\lib\site-packages\scipy\stats\distributions.py in <module>
      6 #       instead of `git blame -Lxxx,+x`.
      7 #
----> 8 from ._distn_infrastructure import (rv_discrete, rv_continuous, rv_frozen)
      9 
     10 from . import _continuous_distns

~\miniconda3\lib\site-packages\scipy\stats\_distn_infrastructure.py in <module>
     22 # for root finding for continuous distribution ppf, and max likelihood
     23 # estimation
---> 24 from scipy import optimize
     25 
     26 # for functions of continuous distributions (e.g. moments, entropy, cdf)

~\miniconda3\lib\site-packages\scipy\optimize\__init__.py in <module>
    398 """
    399 
--> 400 from .optimize import *
    401 from ._minimize import *
    402 from ._root import *

~\miniconda3\lib\site-packages\scipy\optimize\optimize.py in <module>
     34                          line_search_wolfe2 as line_search,
     35                          LineSearchWarning)
---> 36 from ._numdiff import approx_derivative
     37 from scipy._lib._util import getfullargspec_no_self as _getfullargspec
     38 from scipy._lib._util import MapWrapper

~\miniconda3\lib\site-packages\scipy\optimize\_numdiff.py in <module>
      4 from numpy.linalg import norm
      5 
----> 6 from scipy.sparse.linalg import LinearOperator
      7 from ..sparse import issparse, csc_matrix, csr_matrix, coo_matrix, find
      8 from ._group_columns import group_dense, group_sparse

~\miniconda3\lib\site-packages\scipy\sparse\linalg\__init__.py in <module>
    112 from .dsolve import *
    113 from .interface import *
--> 114 from .eigen import *
    115 from .matfuncs import *
    116 from ._onenormest import *

~\miniconda3\lib\site-packages\scipy\sparse\linalg\eigen\__init__.py in <module>
      7 
      8 """
----> 9 from .arpack import *
     10 from .lobpcg import *
     11 

~\miniconda3\lib\site-packages\scipy\sparse\linalg\eigen\arpack\__init__.py in <module>
     18 
     19 """
---> 20 from .arpack import *

~\miniconda3\lib\site-packages\scipy\sparse\linalg\eigen\arpack\arpack.py in <module>
     40 __all__ = ['eigs', 'eigsh', 'svds', 'ArpackError', 'ArpackNoConvergence']
     41 
---> 42 from . import _arpack
     43 arpack_int = _arpack.timing.nbx.dtype
     44 

ImportError: DLL load failed while importing _arpack: The specified procedure could not be found.

when re-install scipy by doing pip install -U scipy:

    Uninstalling scipy-1.7.1:
      Successfully uninstalled scipy-1.7.1
ERROR: pip's dependency resolver does not currently take into account all the packages that are installed. This behaviour is the source of the following dependency conflicts.
scikit-image 0.18.3 requires matplotlib!=3.0.0,>=2.0.0, which is not installed.
scikit-image 0.18.3 requires networkx>=2.0, which is not installed.
scikit-image 0.18.3 requires pillow!=7.1.0,!=7.1.1,>=4.3.0, which is not installed.
scikit-image 0.18.3 requires PyWavelets>=1.1.1, which is not installed.
greykite 0.2.0 requires matplotlib>=3.4.1, which is not installed.
greykite 0.2.0 requires pmdarima>=1.8.0, which is not installed.
greykite 0.2.0 requires scikit-learn>=0.24.1, which is not installed.
greykite 0.2.0 requires tqdm>=4.52.0, which is not installed.
featuretools 1.1.0 requires psutil>=5.6.6, which is not installed.
featuretools 1.1.0 requires pyyaml>=5.4, which is not installed.
featuretools 1.1.0 requires tqdm>=4.32.0, which is not installed.
fancyimpute 0.6.0 requires keras==2.4.3, which is not installed.
fancyimpute 0.6.0 requires scikit-learn==0.24.2, which is not installed.
alibi-detect 0.7.3 requires matplotlib<4.0.0,>=3.0.0, which is not installed.
alibi-detect 0.7.3 requires Pillow<9.0.0,>=5.4.1, which is not installed.
alibi-detect 0.7.3 requires scikit-learn<1.1.0,>=0.20.2, which is not installed.
alibi-detect 0.7.3 requires tqdm<5.0.0,>=4.28.1, which is not installed.
greykite 0.2.0 requires plotly<4,>=3.10.0, but you have plotly 5.3.1 which is incompatible.
featuretools 1.1.0 requires cloudpickle>=1.5.0, but you have cloudpickle 1.3.0 which is incompatible.
fancyimpute 0.6.0 requires numpy==1.19.5, but you have numpy 1.22.1 which is incompatible.
fancyimpute 0.6.0 requires scipy==1.6.3, but you have scipy 1.7.3 which is incompatible.
fancyimpute 0.6.0 requires tensorflow==2.5, but you have tensorflow 2.4.0 which is incompatible.
Successfully installed scipy-1.7.3