table scraper

Lake City realtors

#!/usr/bin/env python
from urllib import unquote
import csv
from mechanize import Browser
from BeautifulSoup import BeautifulSoup

mech = Browser()
url = "http://g8rweb.com/scrapers/lakecityagents.html"
page = mech.open(url)
html = page.read()
soup = BeautifulSoup(html)

table = soup.find("table")

myPrettyWriter = csv.writer(open('myfile.csv', 'w'), delimiter="\t")

for row in table.findAll('tr'):
	
	email = row.findAll('td')[0].find('a')
	try:
	    email = row.findAll('td')[0].find('a')
	    email = unquote(email.get('href', None).split(':')[-1]).strip()
	except:
	    continue
	
	fullname = row.findAll('td')[1].find('font').string
	
	myPrettyWriter.writerow([email, fullname])