from db import DB

db = DB(filename="./baseball-archive-2012.sqlite", dbtype="sqlite")
db

db.tables.allstarfull

db.tables.allstarfull.head()

db.tables.allstarfull.sample()

db.tables.allstarfull.playerID

db.tables.allstarfull.playerID.head()

db.tables.allstarfull.playerID.unique().count()

db.find_column("*player*")

db.find_column("*ID*")

db.find_column("HR")

db.find_column("HR", "INTEGER")

db.find_column("*", "INTEGER")

db.find_table("*")

db.find_table("*batting*")

db.save_credentials("baseball")

from db import DB

db = DB(profile="baseball", dbtype="sqlite")

db.tables

db.tables.appearances.head()