Q.Write the steps required to read data from a MySQL database to a DataFrame.

Steps to Read Data from a MySQL Database into a DataFrame

The process uses the pandas library along with a database connector (mysql-connector-python or pymysql). Here are the complete steps:

Step 1: Install required libraries (if not already installed)

pip install pandas mysql-connector-python

Step 2: Import the libraries

import pandas as pd
import mysql.connector

Step 3: Establish a connection to the MySQL database

conn = mysql.connector.connect(
    host="localhost",
    user="your_username",
    password="your_password",
    database="your_database_name"
)

Step 4: Write the SQL query

query = "SELECT * FROM your_table_name"

Step 5: Use pd.read_sql() to execute the query and load data into a DataFrame

df = pd.read_sql(query, conn)

Step 6: Close the database connection

conn.close()

Step 7: Verify the DataFrame

print(df.head())   # Display first 5 rows
print(df.info())   # Check data types and non-null counts

This is a plain theory question — it asks for the steps, not code output. The core idea is that pandas provides a direct bridge between SQL result sets and DataFrames, eliminating the need to manually iterate through rows.

Why pd.read_sql() is the right tool

When you execute a SQL query in Python, the database driver returns a cursor object containing rows. Manually converting these rows into a DataFrame would require:

• Fetching all rows with cursor.fetchall()
• Extracting column names from cursor.description
• Building a list of dictionaries or tuples
• Passing them to pd.DataFrame()

pd.read_sql() does all of this in one call. It accepts either a connection object (not a cursor) or a SQLAlchemy engine, executes the query, and returns a DataFrame with proper column names and data types.

Step-by-step process

Step 1: Install and import the required library

You need a MySQL connector. The two most common are mysql-connector-python (official Oracle) and pymysql. Import pandas and the connector:

import pandas as pd
import mysql.connector  # or import pymysql

Step 2: Establish a connection to the MySQL database

Create a connection object by providing host, user, password, and database name:

conn = mysql.connector.connect(
    host="localhost",
    user="root",
    password="your_password",
    database="school_db"
)

Step 3: Write the SQL query

Define the SELECT statement that fetches the data you need:

query = "SELECT * FROM students WHERE grade = 'A'"

Step 4: Use pd.read_sql() to read into a DataFrame

Pass the query and the connection object. The function executes the query and returns a DataFrame:

df = pd.read_sql(query, conn)

Step 5: Close the connection

Always close the connection when done:

conn.close()

Alternative: Using SQLAlchemy engine

For more complex applications, use SQLAlchemy's create_engine():

from sqlalchemy import create_engine

engine = create_engine("mysql+mysqlconnector://root:password@localhost/school_db")
df = pd.read_sql("SELECT * FROM students", engine)

Complete working example