import pymysql
import pandas

conn = pymysql.connect(host='mysql.guaminsects.net',user='readonlyguest',passwd='readonlypassword',db='oryctes')

sql = "SELECT * from matt"
df = pandas.io.sql.read_sql(sql, conn)
df.to_csv('matt-expt.csv')
df.tail()

sql = """
SELECT lure, SUM(maleCRB+femaleCRB) AS trapCatch
FROM  matt
GROUP BY lure
ORDER BY trapCatch DESC;
"""
df = pandas.io.sql.read_sql(sql, conn)
df