```json { "classifications": [ { "column": "web-scraper-order", "role": "identifier", "confidence": 0.95, "reason": "Unique scraper-generated key for each row (29 distinct values for 29 rows)" }, { "column": "web-scraper-start-url", "role": "attribute", "confidence": 0.9, "reason": "Single URL value, descriptive metadata about data source" }, { "column": "f_boxer", "role": "dimension", "confidence": 0.95, "reason": "Low cardinality (2 values), categorical label for first boxer to group/filter by" }, { "column": "s_boxer", "role": "dimension", "confidence": 0.95, "reason": "High cardinality (29 distinct) but categorical opponent names to group/filter by" }, { "column": "f_boxer_result", "role": "dimension", "confidence": 0.95, "reason": "Low cardinality (6 values), categorical fight outcome to group/filter by" }, { "column": "f_boxer_stance", "role": "dimension", "confidence": 0.95, "reason": "Single value 'orthodox', categorical boxing stance to group/filter by" }, { "column": "f_boxer_age", "role": "measure", "confidence": 0.85, "reason": "Numeric age values (28-38) that can be aggregated for average age analysis" }, { "column": "f_boxer_height", "role": "dimension", "confidence": 0.8, "reason": "Low cardinality (4 values), categorical height ranges to group/filter by" }, { "column": "f_boxer_reach", "role": "dimension", "confidence": 0.8, "reason": "Low cardinality (4 values), categorical reach ranges to group/filter by" }, { "column": "f_boxer_won", "role": "measure", "confidence": 0.95, "reason": "Numeric count of wins (0-62) to aggregate for statistics" }, { "column": "f_boxer_lost", "role": "measure", "confidence": 0.95, "reason": "Numeric count of losses (0-5) to aggregate for statistics" }, { "column": "f_boxer_drawn", "role": "measure", "confidence": 0.9, "reason": "Numeric count of draws (all 0) to aggregate for statistics" }, { "column": "f_boxer_KOs", "role": "measure", "confidence": 0.95, "reason": "Numeric count of knockouts (0-52) to aggregate for statistics" }, { "column": "f_boxer_ranking", "role": "measure", "confidence": 0.85, "reason": "Numeric ranking (9-56) that can be aggregated for average ranking analysis" }, { "column": "s_boxer_ranking", "role": "measure", "confidence": 0.85, "reason": "Numeric ranking (11-635) that can be aggregated for average ranking analysis" }, { "column": "s_boxer_age", "role": "measure", "confidence": 0.85, "reason": "Numeric age values (24-43) that can be aggregated for average age analysis" }, { "column": "s_boxer_stance", "role": "dimension", "confidence": 0.95, "reason": "Low cardinality (2 values: orthodox/southpaw), categorical stance to group/filter by" }, { "column": "s_boxer_reach", "role": "attribute", "confidence": 0.75, "reason": "Free-form text with mixed formats (empty strings, imperial/metric), descriptive display field" }, { "column": "s_boxer_height", "role": "attribute", "confidence": 0.75, "reason": "Free-form text with mixed formats (empty strings, imperial/metric), descriptive display field" }, { "column": "s_boxer_won", "role": "measure", "confidence": 0.95, "reason": "Numeric count of wins (2-56) to aggregate for statistics" }, { "column": "s_boxer_lost", "role": "measure", "confidence": 0.95, "reason": "Numeric count of losses (0-25) to aggregate for statistics" }, { "column": "s_boxer_drawn", "role": "measure", "confidence": 0.95, "reason": "Numeric count of draws (0-3) to aggregate for statistics" }, { "column": "s_boxer_KOs", "role": "measure", "confidence": 0.95, "reason": "Numeric count of knockouts (0-42) to aggregate for statistics" }, { "column": "rounds", "role": "attribute", "confidence": 0.9, "reason": "Free-form text with mixed content (names, results, round info), descriptive display field" } ] } ```