```json { "classifications": [ { "column": "web-scraper-order", "role": "identifier", "confidence": 0.95, "reason": "Unique scraper-generated ID for each row (68 distinct values for 68 rows)" }, { "column": "web-scraper-start-url", "role": "attribute", "confidence": 0.9, "reason": "Single constant URL value, descriptive metadata not used for grouping" }, { "column": "MatchLink", "role": "attribute", "confidence": 0.85, "reason": "Single constant value 'bout', descriptive label not used for analysis" }, { "column": "MatchLink-href", "role": "identifier", "confidence": 0.95, "reason": "Unique URL identifier for each match (68 distinct values for 68 rows)" }, { "column": "f_boxer", "role": "dimension", "confidence": 0.9, "reason": "First boxer name, low cardinality (5 values), used to group/filter matches" }, { "column": "s_boxer", "role": "dimension", "confidence": 0.9, "reason": "Second boxer name, medium cardinality (61 values), used to group/filter matches" }, { "column": "f_boxer_result", "role": "dimension", "confidence": 0.95, "reason": "Categorical match outcome (6 distinct values), used for grouping and filtering" }, { "column": "f_boxer_stance", "role": "dimension", "confidence": 0.9, "reason": "Categorical stance type (3 values: orthodox/southpaw/height), used for grouping" }, { "column": "f_boxer_age", "role": "measure", "confidence": 0.85, "reason": "Numeric age value (21 distinct values), can be aggregated for average age analysis" }, { "column": "f_boxer_height", "role": "dimension", "confidence": 0.85, "reason": "Height categories (5 distinct values), low cardinality used for grouping" }, { "column": "f_boxer_reach", "role": "dimension", "confidence": 0.85, "reason": "Reach categories (5 distinct values), low cardinality used for grouping" }, { "column": "f_boxer_won", "role": "measure", "confidence": 0.95, "reason": "Numeric count of wins (0-64), aggregated for statistics" }, { "column": "f_boxer_lost", "role": "measure", "confidence": 0.95, "reason": "Numeric count of losses (0-3), aggregated for statistics" }, { "column": "f_boxer_drawn", "role": "measure", "confidence": 0.95, "reason": "Numeric count of draws (0-1), aggregated for statistics" }, { "column": "f_boxer_KOs", "role": "measure", "confidence": 0.95, "reason": "Numeric count of knockouts (0-53), aggregated for statistics" }, { "column": "f_boxer_ranking", "role": "dimension", "confidence": 0.8, "reason": "Ranking points categories (12 distinct values), low cardinality used for grouping" }, { "column": "s_boxer_ranking", "role": "dimension", "confidence": 0.8, "reason": "Ranking points categories (20 distinct values), low cardinality used for grouping" }, { "column": "s_boxer_age", "role": "measure", "confidence": 0.85, "reason": "Numeric age value (20 distinct values), can be aggregated for average age analysis" }, { "column": "s_boxer_stance", "role": "dimension", "confidence": 0.85, "reason": "Stance/height categories (9 distinct values), low cardinality used for grouping" }, { "column": "s_boxer_reach", "role": "dimension", "confidence": 0.85, "reason": "Reach categories (17 distinct values), medium cardinality used for grouping" }, { "column": "s_boxer_height", "role": "dimension", "confidence": 0.85, "reason": "Height categories (24 distinct values), medium cardinality used for grouping" }, { "column": "s_boxer_won", "role": "measure", "confidence": 0.95, "reason": "Numeric count of wins (4-85), aggregated for statistics" }, { "column": "s_boxer_lost", "role": "measure", "confidence": 0.95, "reason": "Numeric count of losses (0-33), aggregated for statistics" }, { "column": "s_boxer_drawn", "role": "measure", "confidence": 0.95, "reason": "Numeric count of draws (0-4), aggregated for statistics" }, { "column": "s_boxer_KOs", "role": "measure", "confidence": 0.95, "reason": "Numeric count of knockouts (1-39), aggregated for statistics" }, { "column": "rounds", "role": "attribute", "confidence": 0.9, "reason": "Free-form text describing match details (31 distinct values), displayed but not aggregated" } ] } ```