%autosave 10

import pandas as pd
import pandasql

# Useful shim, saves typing
pysqldf = lambda q:  pandasql.sqldf(q, globals())

# !!AI maybe use examples from Intro to Data Science course,
# it's identical to this.

# !!AI won't run, just the gist

import pandas.io.sql
import psycopg2

connection = psycopg2.connect()  # !!AI TODO fill in

math_by_date = pandas.io.sql.read_sql("""\
    SELECT ...
    FROM...
    WHERE ...
    AND .
    AND ...
    GROUP BY ...
""", connection)

# More work with pandas.io.sql