from sqlalchemy import create_engine, Table, MetaData
from sqlalchemy.orm import sessionmaker
import pandas as pd
credentials = dict(username = "username",
password = "password",
host = "localhost",
database = "database")
engine = create_engine('mysql://{username}:{password}@l{host}/{database}?charset=utf8'.format(**credentials))
Session = sessionmaker(engine)
meta = MetaData()
abc = Table("abc", meta, autoload_with = engine)
session = Session()
query = (session.query(abc))
df = pd.read_sql(query.statement, query.session.bind)