Import data from a MySQL database table into a Pandas DataFrame using the pymysql package. · GitHub

Import data from a MySQL database table into a Pandas DataFrame using the pymysql package.

Raw

mysql-pandas-import.py

      
        import pandas as pd
      
        import pymysql
      
        from sqlalchemy import create_engine
      
        engine = create_engine('mysql+pymysql://<user>:<password>@<host>[:<port>]/<dbname>')
      
        df = pd.read_sql_query('SELECT * FROM table', engine)
      
        df.head()

azizatitallah commented Feb 27, 2018

I was looking for this, Thanks 🍏

muthu0101 commented Sep 11, 2018

Thank You

sourcetop commented Sep 15, 2018

Great snippet.
Thanks!

rahman9909 commented Sep 15, 2018

Great, Thanks

jordaniza commented Mar 26, 2019

Had a few difficulties getting this to run - removed the square brackets around [:] did the job, hope that helps anyone struggling.

Really helpful though, thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

You can’t perform that action at this time.