无法在Jupyter Notebook中使用Pyodbc模块 [英] Unable to use pyodbc module in Jupyter notebook

问题描述

在Jupyter中，我尝试使用pyodbc通过obdc连接提取sql数据.我收到以下错误.我可以使用python 2在spyder中使用pyodbc.我尝试从命令行重新加载pyodbc模块，但未成功.有什么想法吗?

In Jupyter, I am trying to pull sql data through a obdc connection,using pyodbc. I get the below error. I am able to use pyodbc in spyder using python 2. I have tried re-loading pyodbc module from the command line without success. Any ideas?

import pandas as pd
import pyodbc

---------------------------------------------------------------------------
ModuleNotFoundError                       Traceback (most recent call last)
<ipython-input-15-b8f1855c5265> in <module>()
      1 import pandas as pd
----> 2 import pyodbc

ModuleNotFoundError: No module named 'pyodbc'

推荐答案

从本质上讲，您的计算机具有两个版本的Python安装.因此，模块pyodbc仅对应于一个版本2，而不对应于另一个版本3.您可以执行以下任一操作:

Essentially, your machine has two version installations of Python. Hence, the module pyodbc corresponds to only one version, 2, and not the other, 3. You can do one of the following:

1. 将两个Python 2内核都添加到当前的Jupyter安装中.然后，在Python 2下运行所需的笔记本以访问其所有模块，例如pyodbc和spyder.请参见此处:

python2 -m pip install ipykernel

python2 -m ipykernel install --user

为Python 3安装pyodbc，例如以下命令行:

Install pyodbc for Python 3 such as below command line:

python3 -m pip install pyodbc

这篇关于无法在Jupyter Notebook中使用Pyodbc模块的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！