Skip to content

Instantly share code, notes, and snippets.

@stefanthoss

stefanthoss/mysql-pandas-import.py

Last active December 26, 2023 19:48
Show Gist options
  • Save stefanthoss/364b2a99521d5bb76d51 to your computer and use it in GitHub Desktop.
Save stefanthoss/364b2a99521d5bb76d51 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()
@muthu0101
Copy link

Thank You

@sourcetop
Copy link

Great snippet.
Thanks!

@rahman9909
Copy link

Great, Thanks

@jordaniza
Copy link

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!

@userddssilva
Copy link

thanks man

@dariusmortazavi
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment