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

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()

Great, Thanks

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!

thanks man

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