Skip to content

Instantly share code, notes, and snippets.

Working from home

Du Phan fehiepsi

Working from home
View GitHub Profile
stefanthoss /
Last active Apr 20, 2020
Import data from a MySQL database table into a Pandas DataFrame using the pymysql package.
mport 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)
You can’t perform that action at this time.