Pandas — Read SQL

Read from SQL

import pandas as pd
import sqlite3

conn = sqlite3.connect('database.db')
df = pd.read_sql('SELECT * FROM users', conn)

Write to SQL

df.to_sql('users', conn, if_exists='replace', index=False)

SQLAlchemy

from sqlalchemy import create_engine

engine = create_engine('postgresql://user:pass@localhost/db')
df = pd.read_sql('SELECT * FROM users', engine)

Query with parameters

query = "SELECT * FROM users WHERE age > ?"
df = pd.read_sql(query, conn, params=[25])

Mini Practice

1. Connect to database
2. Read data
3. Write data
4. Use parameters

Up Next

Continue with Selection - Selecting data.