python - uszipcode Windows 命令提示符 : ImportError: DLL load failed: The specified module could not be found

Question

我一直在 anaconda 中使用 uszipcode 模块，没有出现问题，但是当转到 Windows 命令提示符时，我收到 DLL 加载失败的错误。我在 Windows 10 中使用 python3

>>> uszipcode.__version__
'0.2.2'

>>> sys.version
'3.7.1 (default, Dec 10 2018, 22:54:23) [MSC v.1915 64 bit (AMD64)]'

>>> import uszipcode
>>> uszipcode.SearchEngine()
Traceback (most recent call last):
  File "C:\Users\user\Anaconda3\lib\site-packages\sqlalchemy\dialects\sqlite\pysqlite.py", line 334, in dbapi
    from pysqlite2 import dbapi2 as sqlite
ModuleNotFoundError: No module named 'pysqlite2'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "C:\Users\user\Anaconda3\lib\site-packages\uszipcode\search.py", line 82, in __init__
    engine = connect_to_simple_zipcode_db()
  File "C:\Users\user\Anaconda3\lib\site-packages\uszipcode\db.py", line 49, in connect_to_simple_zipcode_db
    return engine_creator.create_sqlite(path=simple_db_file_path.abspath)
  File "C:\Users\user\Anaconda3\lib\site-packages\uszipcode\pkg\sqlalchemy_mate\engine_creator.py", line 51, in create_sqlite
    return create_engine(_create_sqlite(path), **kwargs)
  File "C:\Users\user\Anaconda3\lib\site-packages\sqlalchemy\engine\__init__.py", line 425, in create_engine
    return strategy.create(*args, **kwargs)
  File "C:\Users\user\Anaconda3\lib\site-packages\sqlalchemy\engine\strategies.py", line 81, in create
    dbapi = dialect_cls.dbapi(**dbapi_args)
  File "C:\Users\user\Anaconda3\lib\site-packages\sqlalchemy\dialects\sqlite\pysqlite.py", line 339, in dbapi
    raise e
  File "C:\Users\user\Anaconda3\lib\site-packages\sqlalchemy\dialects\sqlite\pysqlite.py", line 337, in dbapi
    from sqlite3 import dbapi2 as sqlite  # try 2.5+ stdlib name.
  File "C:\Users\user\Anaconda3\lib\sqlite3\__init__.py", line 23, in <module>
    from sqlite3.dbapi2 import *
  File "C:\Users\user\Anaconda3\lib\sqlite3\dbapi2.py", line 27, in <module>
    from _sqlite3 import *
ImportError: DLL load failed: The specified module could not be found.

如有任何帮助，我们将不胜感激。谢谢

Answer 1

我已经用python 3.6创建了环境，问题已经解决。