title: ModuleNotFoundError: No module named 'pymysql' using Jupyter / Panda
body: <p>Need a Help from somebody out there! </p>
  
  <blockquote>
    <p>The errors mentioned below occurs in jupyter when executing</p>
  </blockquote>
  
  <pre><code>Import pymysql
  </code></pre>
  
  <p>ModuleNotFoundError                       Traceback (most recent call
  last)  in 
  ----> 1 import pymysql</p>
  
  <p>ModuleNotFoundError: No module named 'pymysql'</p>
  
  <blockquote>
    <p>and when Executing</p>
  </blockquote>
  
  <pre><code>create_engine('mysql+pymysql://root:root@localhost:3306/pandas_tutorial')
  
  ModuleNotFoundError Traceback (most recent call last) 
  &lt;ipython-input-2-751a940a98c4&gt; in &lt;module&gt; ----&gt; 1 engine = 
   sqlalchemy.create_engine('mysql+pymysql://root:root@localhost:3306/pandas_tutorial')
  
  ~\Anaconda3\lib\site-packages\sqlalchemy\engine\__init__.py in create_engine(*args, **kwargs) 
  477 strategy = kwargs.pop("strategy", default_strategy) 
  478 strategy = strategies.strategies[strategy] 
  --&gt; 479 return strategy.create(*args, **kwargs) 
  480 
  481 
  ~\Anaconda3\lib\site-packages\sqlalchemy\engine\strategies.py in create(self, name_or_url, **kwargs) 
  85 if k in kwargs: 
  86 dbapi_args[k] = pop_kwarg(k) 
  ---&gt;    87 dbapi = dialect_cls.dbapi(**dbapi_args) 
  88 
  89 dialect_args["dbapi"] = dbapi 
  ~\Anaconda3\lib\site-packages\sqlalchemy\dialects\mysql\pymysql.py in dbapi(cls) 
  60 @classmethod 
  61 def dbapi(cls): ---&gt; 
  62 return __import__("pymysql") 
  63 
  64 def is_disconnect(self, e, connection, cursor): 
  ModuleNotFoundError: No module named 'pymysql'
  </code></pre>
  
  <p>OS &amp; Tools:</p>
  
  <pre><code>Windows 10
  Jupyter 6.0.1
  Python 3.7.4
  Pandas 3
  </code></pre>
  
  <p>list of Packages installed:</p>
  
  <pre><code>mysql       0.0.2
  mysqlclient 1.4.6    
  pip         20.0.2   
  PyMySQL     0.9.3  using "pip install pymysql"   
  setuptools  41.2.0
  SQLAlchemy  1.3.13 using "pip install sqlalchemy"
  </code></pre>