Skip to content

Instantly share code, notes, and snippets.

@userddssilva

userddssilva/mysql-pandas-import.py

Forked from stefanthoss/mysql-pandas-import.py
Created January 31, 2020 14:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save userddssilva/701620bbd8723e6c36d65546e186167d to your computer and use it in GitHub Desktop.
Save userddssilva/701620bbd8723e6c36d65546e186167d to your computer and use it in GitHub Desktop.
Download ZIP
Import data from a MySQL database table into a Pandas DataFrame using the pymysql package.
Raw
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()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment