import pandas as pd
import pymysql

mysql_connection = pymysql.connect(host='localhost',
                    user='root',
                    password='',
                    db='tutorfall2016',
                    charset='utf8',
                    cursorclass=pymysql.cursors.DictCursor)

sql = "SELECT * FROM `sign_ins`"
pd.read_sql(sql, mysql_connection, index_col='id')