access_time 2 months ago languageEnglish
more_vert

Create Pandas DataFrame from MySQL

visibility 11 comment 0

Prerequisites

MySQL connector is required which will be used to establish connection to MySQL database. Refer to the following page for more details about installation. 

Python: Load Data from MySQL

Code snippet

The following code snippet connects to a database named test_db in server localhost (runs on port 10101) using user name 'hive' and password 'hive'. 

warning Remember to change the connection details to your own ones.  
import mysql.connector
import pandas as pd 

conn = mysql.connector.connect(user='hive', database='test_db',
                               password='hive',
                               host="localhost",
                               port=10101)
cursor = conn.cursor()

query = "SELECT id, value FROM test_table"

df = pd.read_sql(query, con=conn)
print(df)
conn.close()

copyright This page is subject to Site terms.
Like this article?
Share on

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

Follow Kontext

Get our latest updates on LinkedIn or Twitter.

Want to contribute on Kontext to help others?

Learn more

More from Kontext