Water Watch Scraper

from mechanize import Browser
import csv
import re

sitenumber = []

with open('data.csv', 'rb') as csvfile:
  test = csv.reader(csvfile)
  for row in test:
		sitenumber.append(row[0])

for index, x in enumerate(sitenumber):
	br = Browser()
	br.set_handle_robots(False)
	br.open("http://waterwatch.usgs.gov/index.php?id=wwchart_sitedur")
	br.select_form(name="frmXBuilder")
	br.form.set_all_readonly(False)
	br['sno'] = str(x)
	br['ofmt'] = ['stat_csv']
	
	response = br.submit()
	content = response.read()
	text_file = open(str(x) + '.csv', 'w')
	text_file.write(content)
	text_file.close()