Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Import data from a MySQL database table into a Pandas DataFrame using the pymysql package.
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()
@azizatitallah

This comment has been minimized.

Copy link

commented Feb 27, 2018

I was looking for this, Thanks 🍏

@muthu0101

This comment has been minimized.

Copy link

commented Sep 11, 2018

Thank You

@sourcetop

This comment has been minimized.

Copy link

commented Sep 15, 2018

Great snippet.
Thanks!

@rahman9909

This comment has been minimized.

Copy link

commented Sep 15, 2018

Great, Thanks

@jordaniza

This comment has been minimized.

Copy link

commented Mar 26, 2019

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!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.