Read from SQL databases - Python Pandas Module

Read from SQL databases - Python Pandas Module. The following code shows how to read data from SQL database for working with the Python Pandas module.

In [1]:

import pandas as pd
import mysql.connector

Here we use the sqlalchemy library to grab data from a sql database

In [2]:

conn = mysql.connector.connect(user='root', password='root', database='pandas')
cursor = conn.cursor()
cursor.execute("SELECT * FROM test")
data = cursor.fetchall()

In [3]:

my_data_frame = pd.DataFrame(data=list(data))
my_data_frame

Out[3]: