def predict_daily_points(database_session, day=None): if day is None: day = date.today() #hitter_regression = HitterRegressionTrainer() hitter_regression = HitterRegressionForestTrainer() hitter_regression.train_network() #pitcher_regression = PitcherRegressionTrainer() pitcher_regression = PitcherRegressionForestTrainer() pitcher_regression.train_network() daily_entries = PregameHitterGameEntry.get_all_daily_entries( database_session, day) for daily_entry in daily_entries: predicted_points = hitter_regression.get_prediction( daily_entry.to_input_vector()) if predicted_points < 0: predicted_points = 0 daily_entry.predicted_draftkings_points = predicted_points database_session.commit() daily_entries = PregamePitcherGameEntry.get_all_daily_entries( database_session, day) for daily_entry in daily_entries: predicted_points = pitcher_regression.get_prediction( daily_entry.to_input_vector()) if predicted_points < 0: predicted_points = 0 daily_entry.predicted_draftkings_points = predicted_points database_session.commit()
def predict_daily_points(database_session, day=None): if day is None: day = date.today() #hitter_regression = HitterRegressionTrainer() hitter_regression = HitterRegressionForestTrainer() hitter_regression.train_network() #pitcher_regression = PitcherRegressionTrainer() pitcher_regression = PitcherRegressionForestTrainer() pitcher_regression.train_network() daily_entries = PregameHitterGameEntry.get_all_daily_entries(database_session, day) for daily_entry in daily_entries: predicted_points = hitter_regression.get_prediction(daily_entry.to_input_vector()) if predicted_points < 0: predicted_points = 0 daily_entry.predicted_draftkings_points = predicted_points database_session.commit() daily_entries = PregamePitcherGameEntry.get_all_daily_entries(database_session, day) for daily_entry in daily_entries: hitter_array = daily_entry.get_opponent_vector(database_session) final_array = np.concatenate([daily_entry.to_input_vector(), hitter_array]) predicted_points = pitcher_regression.get_prediction(final_array) if predicted_points < 0: predicted_points = 0 daily_entry.predicted_draftkings_points = predicted_points database_session.commit()
def update_salaries(database_session, csv_dict=None, game_date=None): if game_date is None: game_date = date.today() if csv_dict is None: csv_dict = Draftkings.get_csv_dict() #Hitters pregame_hitters = PregameHitterGameEntry.get_all_daily_entries( database_session, game_date) for pregame_entry in pregame_hitters: # Lookup the player's name in the database # Lookup the name in the dictionary hitter_entry = database_session.query(HitterEntry).get( pregame_entry.rotowire_id) if hitter_entry is None: print "Player %s not found in the Draftkings CSV file. Deleting entry." % pregame_entry.rotowire_id try: csv_entry = csv_dict[(hitter_entry.first_name + " " + hitter_entry.last_name + hitter_entry.team).lower()] pregame_entry.draftkings_salary = int(csv_entry["Salary"]) positions = csv_entry["Position"].split("/") pregame_entry.primary_position = positions[0] pregame_entry.secondary_position = positions[len(positions) - 1] database_session.commit() except KeyError: print "Player %s not found in the Draftkings CSV file. Deleting entry." % ( hitter_entry.first_name + " " + hitter_entry.last_name) database_session.delete(pregame_entry) database_session.commit() # Pitchers pregame_pitchers = PregamePitcherGameEntry.get_all_daily_entries( database_session, game_date) for pregame_entry in pregame_pitchers: # Lookup the player's name in the database # Lookup the name in the dictionary pitcher_entry = database_session.query(PitcherEntry).get( pregame_entry.rotowire_id) if pitcher_entry is None: print "Player %s not found in the Draftkings CSV file. Deleting entry." % pregame_entry.rotowire_id try: csv_entry = csv_dict[(pitcher_entry.first_name + " " + pitcher_entry.last_name + pitcher_entry.team).lower()] pregame_entry.draftkings_salary = int(csv_entry["Salary"]) database_session.commit() except KeyError: print "Player %s not found in the Draftkings CSV file. Deleting entry." % ( pitcher_entry.first_name + " " + pitcher_entry.last_name) database_session.delete(pregame_entry) database_session.commit()
def update_salaries(database_session, csv_dict=None, game_date=None): if game_date is None: game_date = date.today() if csv_dict is None: csv_dict = Draftkings.get_csv_dict() #Hitters pregame_hitters = PregameHitterGameEntry.get_all_daily_entries(database_session, game_date) for pregame_entry in pregame_hitters: # Lookup the player's name in the database # Lookup the name in the dictionary hitter_entry = database_session.query(HitterEntry).get(pregame_entry.rotowire_id) if hitter_entry is None: print "Player %s not found in the Draftkings CSV file. Deleting entry." % pregame_entry.rotowire_id try: csv_entry = csv_dict[(hitter_entry.first_name + " " + hitter_entry.last_name + hitter_entry.team).lower()] pregame_entry.draftkings_salary = int(csv_entry["Salary"]) positions = csv_entry["Position"].split("/") pregame_entry.primary_position = positions[0] pregame_entry.secondary_position = positions[len(positions) - 1] database_session.commit() except KeyError: print "Player %s not found in the Draftkings CSV file. Deleting entry." % (hitter_entry.first_name + " " + hitter_entry.last_name) database_session.delete(pregame_entry) database_session.commit() # Pitchers pregame_pitchers = PregamePitcherGameEntry.get_all_daily_entries(database_session, game_date) for pregame_entry in pregame_pitchers: # Lookup the player's name in the database # Lookup the name in the dictionary pitcher_entry = database_session.query(PitcherEntry).get(pregame_entry.rotowire_id) if pitcher_entry is None: print "Player %s not found in the Draftkings CSV file. Deleting entry." % pregame_entry.rotowire_id try: csv_entry = csv_dict[(pitcher_entry.first_name + " " + pitcher_entry.last_name + pitcher_entry.team).lower()] pregame_entry.draftkings_salary = int(csv_entry["Salary"]) database_session.commit() except KeyError: print "Player %s not found in the Draftkings CSV file. Deleting entry." % (pitcher_entry.first_name + " " + pitcher_entry.last_name) database_session.delete(pregame_entry) database_session.commit()