Skip to content

Instantly share code, notes, and snippets.

@thepycoach
Created February 6, 2021 17:51
Show Gist options
  • Select an option

  • Save thepycoach/c682c9cc74ab61c14e9c4f5e0fee78c9 to your computer and use it in GitHub Desktop.

Select an option

Save thepycoach/c682c9cc74ab61c14e9c4f5e0fee78c9 to your computer and use it in GitHub Desktop.
def calculate_real_odds(home_team, away_team, df_past_years, market):
df_past_years = df_past_years.assign(total_goals=df_past_years['home_goals'] + df_past_years['away_goals'])
df_past_years['Over/Under'] = np.where(df_past_years['total_goals']>2, 'Over 2.5', 'Under 2.5')
dict_markets = {'Over/Under':['Over 2.5', 'Under 2.5']}
df_real_odds = df_past_years[(df_past_years['home_team']==home_team)|(df_past_years['away_team']==away_team)].groupby(market).count()[['total_goals']]
option1 = df_real_odds.loc[dict_markets[market][0], 'total_goals']
option2 = df_real_odds.loc[dict_markets[market][1], 'total_goals']
percentage_odds_over = option1 / (option1 + option2)
real_odds = round(1/percentage_odds_over, 2)
return real_odds
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment