extracting csv

enrollment.py

from bs4 import BeautifulSoup as bs
from csvkit import CSVKitWriter as ckw

with open('enrollment.html', 'r') as f:
    soup = bs(f.read())
rows = soup.find('table').findAll('tr')
header = [td.text for td in rows[0].findAll('td')]

with open('enrollment.csv', 'w') as f:
    writer = ckw(f)
    writer.writerow(header)
    for row in rows[1:]:
        writer.writerow(cell.text for cell in row.findAll('td'))