To get started with this repository, follow these steps:

1. Clone the repository:

   git clone https://github.com/arico97/casino.git
   cd RAG_summarizer 

2. Set Up a Virtual Environment (optional but recommended):

   python -m venv venv
   source venv/bin/activate  # On Windows: venv\Scripts\activate

3. Install dependencies:

   pip install -r requirements.txt

To test the prediction model, follow these steps:

1. Edit football_test.py: Open the football_test.py file and edit the teams match to include the Spanish League teams you want to forecast. For example:

   home_team = "Real Madrid"
   away_team = "Barcelona"

2. Set data scrapper: Add the following code on the previous file and personalize your country data.

    from src.scrapper import scrape_data
    db_path = './db/football.db'
    data_folder = './data'
    country = 'Spain'
   
    scrape_data(country, data_folder, db_path)

3. Run the test script: Use the provided .py script to execute the test and see the metrics log. You can choose the option when running the script. For example:

   python football_test.py -o 1

   or

   python football_test.py -o 2

   where -o 1 is test the data with mlflow track and -o 1 with TensorBoard.

4. View the logged metrics: If using MLflow, you can view the logged metrics by running:

   ./mlflow_dashboard.sh

   If using TensorBoard (Tensorflow dashboard), run:

   ./tensorboard.sh

   This will start a local server where you can view the metrics in your web browser.

By following these steps, you can test the prediction model with your specified teams and track the performance metrics.

We welcome contributions from the community! To contribute, follow these steps:

1. Fork the repository on GitHub.
2. Clone your forked repository:

   git clone https://github.com/your-username/your-forked-repo.git

3. Create a new branch for your feature or bugfix:

   git checkout -b feature-or-bugfix-name

4. Make your changes and commit them with a descriptive message:

   git commit -m "Description of your changes"

5. Push your changes to your forked repository:

   git push origin feature-or-bugfix-name

6. Create a pull request on the original repository.

Please ensure your code adheres to the project's coding standards and includes appropriate tests.

This document provides a comprehensive guide to understanding the football data and betting odds included in the dataset. The data is primarily in CSV format and can be used with standard spreadsheet applications.

• Instructions Guide
  • Repository Instructions
  • Test prediction
  • Contributions Guide
  • Overview
  • Sections
  • Football Data Notes
  • Key to Results Data
  • Match Statistics
  • Pre-closing Odds
  • Key to 1X2 Betting Odds Data
  • Key to Total Goals Betting Odds
  • Key to Asian Handicap Betting Odds
  • Closing Odds
  • Acknowledgements

All data is in CSV format, ready for use within standard spreadsheet applications. Some abbreviations may refer to data collected in earlier seasons. For a current list of included bookmakers, visit Football Data.

• Div: League Division
• Date: Match Date (dd/mm/yy)
• Time: Time of match kick off
• HomeTeam: Home Team
• AwayTeam: Away Team
• FTHG and HG: Full Time Home Team Goals
• FTAG and AG: Full Time Away Team Goals
• FTR and Res: Full Time Result (H=Home Win, D=Draw, A=Away Win)
• HTHG: Half Time Home Team Goals
• HTAG: Half Time Away Team Goals
• HTR: Half Time Result (H=Home Win, D=Draw, A=Away Win)

• Attendance: Crowd Attendance
• Referee: Match Referee
• HS: Home Team Shots
• AS: Away Team Shots
• HST: Home Team Shots on Target
• AST: Away Team Shots on Target
• HHW: Home Team Hit Woodwork
• AHW: Away Team Hit Woodwork
• HC: Home Team Corners
• AC: Away Team Corners
• HF: Home Team Fouls Committed
• AF: Away Team Fouls Committed
• HFKC: Home Team Free Kicks Conceded
• AFKC: Away Team Free Kicks Conceded
• HO: Home Team Offsides
• AO: Away Team Offsides
• HY: Home Team Yellow Cards
• AY: Away Team Yellow Cards
• HR: Home Team Red Cards
• AR: Away Team Red Cards
• HBP: Home Team Bookings Points (10 = yellow, 25 = red)
• ABP: Away Team Bookings Points (10 = yellow, 25 = red)

For closing odds, see the section on Closing Odds.

• B365H: Bet365 home win odds
• B365D: Bet365 draw odds
• B365A: Bet365 away win odds
• BFH: Betfair home win odds
• BFD: Betfair draw odds
• BFA: Betfair away win odds
• BSH: Blue Square home win odds
• BSD: Blue Square draw odds
• BSA: Blue Square away win odds
• BWH: Bet&Win home win odds
• BWD: Bet&Win draw odds
• BWA: Bet&Win away win odds
• GBH: Gamebookers home win odds
• GBD: Gamebookers draw odds
• GBA: Gamebookers away win odds
• IWH: Interwetten home win odds
• IWD: Interwetten draw odds
• IWA: Interwetten away win odds
• LBH: Ladbrokes home win odds
• LBD: Ladbrokes draw odds
• LBA: Ladbrokes away win odds
• PSH and PH: Pinnacle home win odds
• PSD and PD: Pinnacle draw odds
• PSA and PA: Pinnacle away win odds
• SOH: Sporting Odds home win odds
• SOD: Sporting Odds draw odds
• SOA: Sporting Odds away win odds
• SBH: Sportingbet home win odds
• SBD: Sportingbet draw odds
• SBA: Sportingbet away win odds
• SJH: Stan James home win odds
• SJD: Stan James draw odds
• SJA: Stan James away win odds
• SYH: Stanleybet home win odds
• SYD: Stanleybet draw odds
• SYA: Stanleybet away win odds
• VCH: VC Bet home win odds
• VCD: VC Bet draw odds
• VCA: VC Bet away win odds
• WHH: William Hill home win odds
• WHD: William Hill draw odds
• WHA: William Hill away win odds

• BbOU: Number of BetBrain bookmakers used to calculate over/under 2.5 goals (total goals) averages and maximums
• BbMx>2.5: Betbrain maximum over 2.5 goals
• BbAv>2.5: Betbrain average over 2.5 goals
• BbMx<2.5: Betbrain maximum under 2.5 goals
• BbAv<2.5: Betbrain average under 2.5 goals
• GB>2.5: Gamebookers over 2.5 goals
• GB<2.5: Gamebookers under 2.5 goals
• B365>2.5: Bet365 over 2.5 goals
• B365<2.5: Bet365 under 2.5 goals
• P>2.5: Pinnacle over 2.5 goals
• P<2.5: Pinnacle under 2.5 goals
• Max>2.5: Market maximum over 2.5 goals
• Max<2.5: Market maximum under 2.5 goals
• Avg>2.5: Market average over 2.5 goals
• Avg<2.5: Market average under 2.5 goals

• BbAH: Number of BetBrain bookmakers used to Asian handicap averages and maximums
• BbAHh: Betbrain size of handicap (home team)
• AHh: Market size of handicap (home team) (since 2019/2020)
• BbMxAHH: Betbrain maximum Asian handicap home team odds
• BbAvAHH: Betbrain average Asian handicap home team odds
• BbMxAHA: Betbrain maximum Asian handicap away team odds
• BbAvAHA: Betbrain average Asian handicap away team odds
• GBAHH: Gamebookers Asian handicap home team odds
• GBAHA: Gamebookers Asian handicap away team odds
• GBAH: Gamebookers size of handicap (home team)
• LBAHH: Ladbrokes Asian handicap home team odds
• LBAHA: Ladbrokes Asian handicap away team odds
• LBAH: Ladbrokes size of handicap (home team)
• B365AHH: Bet365 Asian handicap home team odds
• B365AHA: Bet365 Asian handicap away team odds
• B365AH: Bet365 size of handicap (home team)
• PAHH: Pinnacle Asian handicap home team odds
• PAHA: Pinnacle Asian handicap away team odds
• MaxAHH: Market maximum Asian handicap home team odds
• MaxAHA: Market maximum Asian handicap away team odds
• AvgAHH: Market average Asian handicap home team odds
• AvgAHA: Market average Asian handicap away team odds

As above but with an additional "C" character following the bookmaker abbreviation/Max/Avg.

Football-Data would like to acknowledge the following sources which have been utilised in the compilation of Football-Data's results and odds files:

• Current results (full time, half time): XScores
• Match statistics: BBC, ESPN Soccer, Bundesliga.de, Gazzetta.it, and Football.fr
• Bookmakers betting odds: Betbrain.com, Oddsportal.com, Individual bookmakers

Betting odds for weekend games are collected Friday afternoons, and on Tuesday afternoons for midweek games.

Additional match statistics (corners, shots, bookings, referee, etc.) for the 2000/01 and 2001/02 seasons for the English, Scottish, and German leagues were provided by Sports.com (now under new ownership and no longer available).

Notes for Football Data

All data is in csv format, ready for use within standard spreadsheet applications. Please note that some abbreviations are no longer in use (in particular odds from specific bookmakers no longer used) and refer to data collected in earlier seasons. For a current list of what bookmakers are included in the dataset please visit http://www.football-data.co.uk/matches.php

Key to results data:

Div = League Division Date = Match Date (dd/mm/yy) Time = Time of match kick off HomeTeam = Home Team AwayTeam = Away Team FTHG and HG = Full Time Home Team Goals FTAG and AG = Full Time Away Team Goals FTR and Res = Full Time Result (H=Home Win, D=Draw, A=Away Win) HTHG = Half Time Home Team Goals HTAG = Half Time Away Team Goals HTR = Half Time Result (H=Home Win, D=Draw, A=Away Win)

Match Statistics (where available) Attendance = Crowd Attendance Referee = Match Referee HS = Home Team Shots AS = Away Team Shots HST = Home Team Shots on Target AST = Away Team Shots on Target HHW = Home Team Hit Woodwork AHW = Away Team Hit Woodwork HC = Home Team Corners AC = Away Team Corners HF = Home Team Fouls Committed AF = Away Team Fouls Committed HFKC = Home Team Free Kicks Conceded AFKC = Away Team Free Kicks Conceded HO = Home Team Offsides AO = Away Team Offsides HY = Home Team Yellow Cards AY = Away Team Yellow Cards HR = Home Team Red Cards AR = Away Team Red Cards HBP = Home Team Bookings Points (10 = yellow, 25 = red) ABP = Away Team Bookings Points (10 = yellow, 25 = red)

Note that Free Kicks Conceeded includes fouls, offsides and any other offense commmitted and will always be equal to or higher than the number of fouls. Fouls make up the vast majority of Free Kicks Conceded. Free Kicks Conceded are shown when specific data on Fouls are not available (France 2nd, Belgium 1st and Greece 1st divisions).

Note also that English and Scottish yellow cards do not include the initial yellow card when a second is shown to a player converting it into a red, but this is included as a yellow (plus red) for European games.

[Pre-closing odds. For closing odds, see further below.]

Key to 1X2 (match) betting odds data:

B365H = Bet365 home win odds B365D = Bet365 draw odds B365A = Bet365 away win odds BFH = Betfair home win odds BFD = Betfair draw odds BFA = Betfair away win odds BSH = Blue Square home win odds BSD = Blue Square draw odds BSA = Blue Square away win odds BWH = Bet&Win home win odds BWD = Bet&Win draw odds BWA = Bet&Win away win odds GBH = Gamebookers home win odds GBD = Gamebookers draw odds GBA = Gamebookers away win odds IWH = Interwetten home win odds IWD = Interwetten draw odds IWA = Interwetten away win odds LBH = Ladbrokes home win odds LBD = Ladbrokes draw odds LBA = Ladbrokes away win odds PSH and PH = Pinnacle home win odds PSD and PD = Pinnacle draw odds PSA and PA = Pinnacle away win odds SOH = Sporting Odds home win odds SOD = Sporting Odds draw odds SOA = Sporting Odds away win odds SBH = Sportingbet home win odds SBD = Sportingbet draw odds SBA = Sportingbet away win odds SJH = Stan James home win odds SJD = Stan James draw odds SJA = Stan James away win odds SYH = Stanleybet home win odds SYD = Stanleybet draw odds SYA = Stanleybet away win odds VCH = VC Bet home win odds VCD = VC Bet draw odds VCA = VC Bet away win odds WHH = William Hill home win odds WHD = William Hill draw odds WHA = William Hill away win odds

Bb1X2 = Number of BetBrain bookmakers used to calculate match odds averages and maximums BbMxH = Betbrain maximum home win odds BbAvH = Betbrain average home win odds BbMxD = Betbrain maximum draw odds BbAvD = Betbrain average draw win odds BbMxA = Betbrain maximum away win odds BbAvA = Betbrain average away win odds

MaxH = Market maximum home win odds MaxD = Market maximum draw win odds MaxA = Market maximum away win odds AvgH = Market average home win odds AvgD = Market average draw win odds AvgA = Market average away win odds

BFEH = Betfair Exchange home win odds BFED = Betfair Exchange draw odds BFEA = Betfair Exchange away win odds

Key to total goals betting odds:

BbOU = Number of BetBrain bookmakers used to calculate over/under 2.5 goals (total goals) averages and maximums BbMx>2.5 = Betbrain maximum over 2.5 goals BbAv>2.5 = Betbrain average over 2.5 goals BbMx<2.5 = Betbrain maximum under 2.5 goals BbAv<2.5 = Betbrain average under 2.5 goals

GB>2.5 = Gamebookers over 2.5 goals GB<2.5 = Gamebookers under 2.5 goals B365>2.5 = Bet365 over 2.5 goals B365<2.5 = Bet365 under 2.5 goals P>2.5 = Pinnacle over 2.5 goals P<2.5 = Pinnacle under 2.5 goals Max>2.5 = Market maximum over 2.5 goals Max<2.5 = Market maximum under 2.5 goals Avg>2.5 = Market average over 2.5 goals Avg<2.5 = Market average under 2.5 goals

Key to Asian handicap betting odds:

BbAH = Number of BetBrain bookmakers used to Asian handicap averages and maximums BbAHh = Betbrain size of handicap (home team) AHh = Market size of handicap (home team) (since 2019/2020) BbMxAHH = Betbrain maximum Asian handicap home team odds BbAvAHH = Betbrain average Asian handicap home team odds BbMxAHA = Betbrain maximum Asian handicap away team odds BbAvAHA = Betbrain average Asian handicap away team odds

GBAHH = Gamebookers Asian handicap home team odds GBAHA = Gamebookers Asian handicap away team odds GBAH = Gamebookers size of handicap (home team) LBAHH = Ladbrokes Asian handicap home team odds LBAHA = Ladbrokes Asian handicap away team odds LBAH = Ladbrokes size of handicap (home team) B365AHH = Bet365 Asian handicap home team odds B365AHA = Bet365 Asian handicap away team odds B365AH = Bet365 size of handicap (home team) PAHH = Pinnacle Asian handicap home team odds PAHA = Pinnacle Asian handicap away team odds MaxAHH = Market maximum Asian handicap home team odds MaxAHA = Market maximum Asian handicap away team odds AvgAHH = Market average Asian handicap home team odds AvgAHA = Market average Asian handicap away team odds

Closing odds (last odds before match starts)

As above but with an additional "C" character following the bookmaker abbreviation/Max/Avg

Football-Data would like to acknowledge the following sources which have been utilised in the compilation of Football-Data's results and odds files.

Current results (full time, half time) XScores - http://www.xscores .com

Match statistics BBC, ESPN Soccer, Bundesliga.de, Gazzetta.it and Football.fr

Bookmakers betting odds Betbrain.com Oddsportal.com Individual bookmakers

Betting odds for weekend games are collected Friday afternoons, and on Tuesday afternoons for midweek games.

Additional match statistics (corners, shots, bookings, referee etc.) for the 2000/01 and 2001/02 seasons for the English, Scottish and German leagues were provided by Sports.com (now under new ownership and no longer available).