ingest.py

#!/usr/bin/python
from pprint import pprint

query = "insert into observations(beach, month, date, year, observer, effortid, " + \
        "brand, sex, age, behavior, time, photoname, comments) values('%s', '%s', " + \
        "'%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s');"
rawdata = open("UgamakBrands2010.csv").readlines()
for line in [ line.strip().split(",") for line in rawdata[1:] ]:
  print query % tuple(line)

for record in [ line.strip().split(',') for line in open('behavior_rank.csv').readlines()]:
  print "insert into rankings (id, code, rank) values('%s', '%s', '%s');" % tuple(record)