/Horse-Racing-Classification-Project

Primary LanguageJupyter Notebook

Horse-Racing-Classification-Project

Explanation of the Columns of Data

  • 'Date': Date of the race
  • 'City': City of the race
  • 'Race_n_time': Time and number of the race on the given date
  • 'ID': ID
  • 'Racer': Racer of current race
  • 'Racer_1': Racer of ID latest race
  • 'LAST_RACER_SAME_AS_CURRENT_RACER': TRUE IF RACER OF THE LAST RACE WAS SAME AS CURRENT RACE FOR THE GIVEN ID, False if not
  • 'LAST_ RACER SAME_AS_CURRENT RACER _BINARY': 1 if above column was TRUE, False if not
  • 'Yas': Age of the given ID
  • 'Speed_in_Secs': Speed of the ID in the given race converted in m/s
  • 'GANYAN_TRANS': Odds of the ID for the given race
  • 'GANYAN_TRANS_int': Odds in the above column converted
  • 'RANK': Rank of the ID in the given race
  • 'AG_Percentage': Percentage (Only available for specific races)
  • 'AG_RANK_AMONG_GROUP': Rank of the percentage number of AG for the given race
  • 'AG_RANKING_Score_Normalized': Min-max normalized score of AG calculated from the rank of the AG
  • 'Ranking_Score_Normalized': Min-max normalized score from the rank of the ID for the given race
  • 'First_Position_Percentage':==1A=Percentage of the 1st Position of the Racer of the ID for current race
  • 'Second_Position_Percentage':==1B=Percentage of the 2nd Position of the Racer of the ID for current race
  • 'Third_Position_Percentage':==1C=Percentage of the 3rd Position of the Racer of the ID for current race *'Forth_Position_Percentage': Percentage of the 4th Position of the Racer of the ID for current race
  • 'TOP_THREE_RACER_PERCENTAGE': 1A+1B+1C *'RANK_LATEST_1ST': RANK OF THE ID IN THE LATEST RACE
  • 'RANK_LATEST_2ND': RANK OF THE ID IN THE 2ND LAST RACE
  • 'RANK_LATEST_3RD': RANK OF THE ID IN THE 3RD LAST RACE
  • 'RANK_LATEST_4TH': RANK OF THE ID IN THE 4TH LAST RACE
  • 'RANK_LATEST_5TH': RANK OF THE ID IN THE 5TH LAST RACE
  • 'TOPLAM_RACES': Total Races played by the ID in whole lifetime
  • 'TOPLAM_1ST': Number of races in which ID got 1st position
  • 'TOPLAM_2ND': Number of races in which ID got 2nd position
  • 'TOPLAM_3RD': Number of races in which ID got 3rd position *'TOPLAM_4TH': Number of races in which ID got 4th position
  • 'BIRINCILIK_PERCENTAGE': Percentage of 1st Positions
  • 'IKINCILIK_PERCENTAGE': Percentage of 2nd Positions
  • 'UCUNCULUK_PERCENTAGE': Percentage of 3rd Positions
  • 'DORDUNCULUK_PERCENTAGE': Percentage of 4th Positions
  • 'SPEED_LATEST_1ST': Speed of the last race of the given ID calculated from the time and distance for that specific race
  • 'SPEED_LATEST_2nd': Speed of the 2nd last race of the given ID calculated from the time and distance for that specific race
  • 'SPEED_LATEST_3rd': Speed of the 3rd last race of the given ID calculated from the time and distance for that specific race
  • 'SPEED_LATEST_4th':Speed of the 4th last race of the given ID calculated from the time and distance for that specific race
  • 'SPEED_LATEST_5th': Speed of the 5th last race of the given ID calculated from the time and distance for that specific race
  • 'RANK': Rank of the ID in the given race, WILL BE OUR LEARNING CRITERIA
  • 'Ranking_Score_Normalized': Min-max normalized score from the rank of the ID for the given race, WILL BE OUR PREDICTION CRITERIA OR SCORE