Create Your Own Positive Expected Value Odds Scraper using Python — Part 12— Adding Opportunities to DB and Posting to discord

Almost there guys!

Code Walkthrough

from fractions import Fraction
from pybettor import convert_odds
from pybettor import implied_prob

players = []
fixture = []
selections = []
marketNames = []
odds = []
averageOdds = []
site = []
for index, row in exampleDF.iterrows():
    team = row['Team']
    playerName = row['Player Name']
    oddsBet365 = row['Over 0.5 SOT Odds Bet365']
    oddsPP = row['Over 0.5 SOT Odds PaddyPower']
    oddsUnibet = row['Over 0.5 SOT Odds Unibet']
    oddsWillHill = row['Over 0.5 SOT Odds WillHill']
    try:
        if(oddsBet365 == "NaN"):
            fraction_numBet365 = "N/A"
        else:
            fraction_numBet365 = Fraction(oddsBet365)
        if(oddsPP == "NaN"):
            fraction_numPP = "N/A"
        else:
            fraction_numPP = Fraction(oddsPP)
        if(oddsUnibet == "NaN"):
            fraction_numUnibet = "N/A"
        else:
            fraction_numUnibet = Fraction(oddsUnibet)
        if(oddsWillHill == "NaN"):
            fraction_numWillHill = "N/A"
        else:
            fraction_numWillHill = Fraction(oddsWillHill)
        if(fraction_numBet365 != "N/A"):
            decimalBet365 = convert_odds(float(fraction_numBet365),"frac","dec")
            decimalBet365 = decimalBet365[0]
        else:
            decimalBet365 = None
        if(fraction_numPP != "N/A"):
            decimalPP =…