Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
Import data from a MySQL database table into a Pandas DataFrame using the pymysql package.
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)
Copy link

azizatitallah commented Feb 27, 2018

I was looking for this, Thanks 🍏

Copy link

muthu0101 commented Sep 11, 2018

Thank You

Copy link

sourcetop commented Sep 15, 2018

Great snippet.

Copy link

rahman9909 commented Sep 15, 2018

Great, Thanks

Copy link

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!

Copy link

userddssilva commented Jan 31, 2020

thanks man

Copy link

dariusmortazavi commented Mar 28, 2020

I also removed the square brackets around the port and that worked for me too @jordaniza! Thanks!

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