pandas Read MySQL to DataFrame Using sqlalchemy and PyMySQL
Example
from sqlalchemy import create_engine
cnx = create_engine('mysql+pymysql://username:password@server:3306/database').connect()
sql = 'select * from mytable'
df = pd.read_sql(sql, cnx)
