def main(season_id):
conn = establish_db_connection('sqlalchemy').connect()
prev_seasons = [
str(int(season_id)),
str(int(season_id) - 1),
str(int(season_id) - 2)
]
historic_data = get_prev_player_data(conn, prev_seasons)
## get list of active players for the selected season
active_players = (historic_data['217'])['Player_id'].tolist()
season_projections = build_simple_season_projections(
active_players, historic_data)
print "uploading player projections..."
re_conn = establish_db_connection('sqlalchemy').connect()
season_projections.to_sql('218_fantasy_projections',
con=re_conn,
if_exists='replace',
index=False)
return None
def upload_player_stats(season_id):
_season_data = pd.read_csv(
"%s/projects/NBA_Jam/Data/%s_season_player_stats.csv" %
(home_dir, season_id),
sep=",")
_season_data[['Player_name',
'Player_id']] = _season_data['Player'].str.split('\\',
expand=True)
_season_data = _season_data.drop(columns=['Player', 'Rk'])
clean_cols = []
old_cols = list(_season_data)
for n, c in enumerate(old_cols):
#print old_cols[n]
if "%" in c:
c = c.replace("%", "per")
elif c == "PS/G":
c = "PTS"
pass
clean_cols.append(c)
_season_data.columns = clean_cols
## upload to db
conn = establish_db_connection('sqlalchemy').connect()
table_name = "player_season_stats_%s" % season_id
print "uploading stats to %s..." % table_name
_season_data.to_sql(table_name, con=conn, index=False, if_exists='replace')
return None
def upload_data_to_db(data, table):
conn = db_connection_manager.establish_db_connection(
'sqlalchemy').connect()
data.to_sql(table, con=conn, if_exists='replace')
return None
def __init__(self):
# self.creds = email_config._get_email_creds()
self.conn = establish_db_connection('sqlalchemy').connect()
self.today = datetime.now().date().strftime("%m/%d/%Y")
self.subject = "NBA Rundown for %s"%self.today
self.degenerates = list(email_config.degenerates.values())
self._fetch_picks()
def __init__(self, game_id=None, game_date=None, daily_slate=None):
self.conn = db_connection_manager.establish_db_connection(
'sqlalchemy').connect()
self.game_id = game_id
self.game_date = game_date
self.daily_slate = daily_slate
self.main()
def main():
conn = establish_db_connection('sqlalchemy').connect()
raw_preds = pd.read_sql("SELECT * FROM 218_fantasy_projections", con=conn)
stats_list = ['FGper', 'FTper', '3P', 'PTS', 'TRB', 'AST', 'STL', 'BLK']
top_10_each_cat = get_top_10_by_stat(raw_preds, stats_list)
master_rankings = get_master_rankings(raw_preds, stats_list, conn)
return None
from config import teams, seasons, season_sql
import datetime
import numpy as np
from assets import list_games, range_all_dates
#from argparse import ArgumentParser
from os.path import expanduser
import sys
import result_calculator
home_dir = expanduser("~")
syspath = '%s/projects/NBA_Jam/' % home_dir
sys.path.insert(0, syspath)
from pulls import spreads_scraper
from utilities import db_connection_manager
### USE THIS TO SCRAPE SPREADS AND UPLOAD TO DB, AD HOC ###
engine = db_connection_manager.establish_db_connection('sqlalchemy')
conn = engine.connect()
for d in range_all_dates("2019-01-25", "2019-01-25"):
df = spreads_scraper.main(d)
df.drop(['time'], axis=1, inplace=True)
df['date'] = df['date'].str[0:4] + "-" + df['date'].str[4:6] + "-" + df[
'date'].str[6:8]
df.to_sql('spreads', con=conn, if_exists='append', index=False)
# conn = db_connection_manager.establish_db_connection('sqlalchemy').connect()
# agg_stats = pd.read_sql("SELECT * FROM four_factors_thru", con = conn)
#
# print agg_stats['as_of'].max()
def __init__(self):
self.conn = db_connection_manager.establish_db_connection(
'sqlalchemy').connect()
self.main()
def __init__(self):
self.conn = establish_db_connection('sqlalchemy').connect()
def __init__(self):
self.conn = db_connection_manager.establish_db_connection(
'sqlalchemy').connect()
self.headers = config.request_header
self.fetch_and_store_lineups()
