Skip to content

Instantly share code, notes, and snippets.

🏠
Working from home

Du Phan fehiepsi

🏠
Working from home
Block or report user

Report or block fehiepsi

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@stefanthoss
stefanthoss / mysql-pandas-import.py
Last active Aug 8, 2019
Import data from a MySQL database table into a Pandas DataFrame using the pymysql package.
View 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()
You can’t perform that action at this time.