from blaze import Data, into, by, join
db = Data('sqlite:///data/lahman2013.sqlite')
joined = join(db.Salaries, db.Teams)
result = by(joined[['name', 'yearID']], avg=joined.salary.mean())
result

type(result)

list(result)

import numpy as np
np.array(result)

into('salaries.csv', result)

!head salaries.csv

# Dump results into a Python set


# Dump results into a Pandas DataFrame


# Dump results into a JSON file, inspect the file to make sure that it came out ok