fairvalue-api / data_schema.md
FairValue
feat: production web app — React/Vite frontend + FastAPI backend with Render/Vercel deployment
b72652e

FairValue Transfer Cap Estimator: Data Schema

This document outlines the CSV structure required for training the XGBoost regression model.

Target Variable

  • Transfer_Fee_2024_GBP: The inflation-adjusted transfer fee in GBP (Target variable to predict).

Master Dataset (train.csv / test.csv)

Column Name Data Type Description
Player_ID Integer Unique identifier for the player.
Name String Player's full name.
Position Categorical Primary position (e.g., CB, CM, CF). Will be One-Hot Encoded.
Age Integer Player's age at the time of the transfer.
Nationality_Tier Integer Grouped tier (Tier 1 = EU5/SA, Tier 2 = Rest of World) influencing commercial value.
Current_League Categorical The league the player is transferring from, mapped to a League Strength Index via UEFA coefficients.
Contract_Years_Left Float Critical risk factor. Years remaining on current contract (1 to 5). Heavily influences the Option Value.
Minutes_2023 Integer Minutes played in the immediate prior season.
Minutes_2022 Integer Minutes played in the season before the immediate prior season.
xG_90_2023 Float Key performance metric. Expected goals per 90 minutes.
xG_90_2022 Float Expected goals per 90 minutes in the previous season.
xA_90_2023 Float Expected assists per 90 minutes.
xA_90_2022 Float Expected assists per 90 minutes in the previous season.
Progressive_Carries_90 Float Progressive carries per 90 minutes, capturing ball-progression skill.
Injury_Days_Total_24m Integer Critical risk factor. Total days injured in the 24 months preceding the transfer. Impacts the "Risk Score" and final Hard Cap.
Transfer_Date Date Date of the transfer, used to determine inflation adjustment multiplier.

Example Row

Player_ID,Name,Position,Age,Nationality_Tier,Current_League,Contract_Years_Left,Minutes_2023,Minutes_2022,xG_90_2023,xG_90_2022,xA_90_2023,xA_90_2022,Progressive_Carries_90,Injury_Days_Total_24m,Transfer_Fee_2024_GBP,Transfer_Date
1001,Jude Bellingham,CM,19,1,La_Liga,4,2500,3000,0.45,0.38,0.22,4.2,5,103000000,2023-06-15
1002,Kai Havertz,CF,24,1,Premier_League,3,2000,2200,0.28,0.25,0.15,3.1,10,65000000,2023-07-01