from blaze import Data, join, by, transform

db = Data('sqlite:///data/lahman2013.sqlite')
db.Teams

db.Teams[db.Teams.name == 'Chicago White Stockings'][['name', 'yearID', 'park']]

by(db.Teams.name, start_year=db.Teams.yearID.min(), 
                    end_year=db.Teams.yearID.max()).sort('end_year', ascending=False)

from blaze import compute  # compute is internal API, not intended for users

expr = db.Teams[db.Teams.name == 'Chicago White Stockings'][['name', 'yearID', 'park']]
print compute(expr, post_compute=False)

expr = by(db.Teams.name, start_year=db.Teams.yearID.min(), 
                    end_year=db.Teams.yearID.max()).sort('end_year', ascending=False)
print compute(expr, post_compute=False)

db.dshape