March Madness Historical DataSet (2002 To 2025)

March Madness Analytics: Insights and Projections using Historical KenPom Data

@kaggle.jonathanpilafas_2024_march_madness_statistical_analysis

Table List

10 tables(6.99 MB)

Dev March Madness

Int Kenpom Defense

Int Kenpom Efficiency

Int Kenpom Height

Int Kenpom Miscellaneous Team Stats

Int Kenpom Offense

Int Kenpom Point Distribution

Int Kenpom Summary

Ref 2024 Post Season Tournament Teams

Ref Current Ncaam Coaches

Int Kenpom Efficiency

@kaggle.jonathanpilafas_2024_march_madness_statistical_analysis.int_kenpom_efficiency

196.89 KB
9268 rows
19 columns

season Season	team Team	conference Conference	adjusted_temo Adjusted Temo	adjusted_tempo_rank Adjusted Tempo Rank	raw_tempo Raw Tempo	raw_tempo_rank Raw Tempo Rank	adjusted_offensive_efficiency Adjusted Offensive Efficiency	adjusted_offensive_efficiency_rank Adjusted Offensive Efficiency Rank	raw_offensive_efficiency Raw Offensive Efficiency	raw_offensive_efficiency_rank Raw Offensive Efficiency Rank	adjusted_defensive_efficiency Adjusted Defensive Efficiency	adjusted_defensive_efficiency_rank Adjusted Defensive Efficiency Rank	raw_defensive_efficiency Raw Defensive Efficiency	raw_defensive_efficiency_rank Raw Defensive Efficiency Rank	avg_possession_length_offense Avg Possession Length (Offense)	avg_possession_length_offense_rank Avg Possession Length (Offense) Rank	avg_possession_length_defense Avg Possession Length (Defense)	avg_possession_length_defense_rank Avg Possession Length (Defense) Rank
2011	Air Force	MWC	61.1	325	62.7	319	107.2	95	103.1	131	103.8	182	104.3	244	18.8	262	19.3	332
2011	Akron	MAC	65.9	144	66.7	179	103.7	163	102.6	141	99.6	94	97.8	78	17.2	81	18.5	278
2011	Alabama	SEC	63.9	245	65.7	229	104.6	144	101.1	187	90.9	7	90.3	4	18.2	199	18.2	245
2011	Alabama A&M	SWAC	69.7	26	71.2	27	87	339	87.9	335	103.7	179	93.1	15	16.7	53	17	35
2011	Alabama St.	SWAC	63.6	256	66.2	198	92.8	318	92	318	106	235	96.8	54	18.9	275	17.1	44
2011	Albany	AE	59.9	333	61	340	101.7	203	101.2	185	108.6	276	102.8	198	19.3	299	19.8	342
2011	Alcorn St.	SWAC	75.7	1	77.7	1	86.2	342	84.4	343	111.5	317	103.3	209	14.5	2	16.1	2
2011	American	Pat	60.3	331	62.1	328	104.1	156	104.7	96	104.7	205	100.9	154	20.4	334	18.1	220
2011	Appalachian St.	SC	66	134	67.8	121	104.7	143	105	95	109	283	108	309	17.5	113	17.5	91
2011	Arizona	P10	65.3	170	67	169	117.4	12	112.7	14	97.8	67	99.7	114	18.4	231	17.4	88


CREATE TABLE int_kenpom_efficiency (
  "season" BIGINT,
  "team" VARCHAR,
  "conference" VARCHAR,
  "adjusted_temo" DOUBLE,
  "adjusted_tempo_rank" BIGINT,
  "raw_tempo" DOUBLE,
  "raw_tempo_rank" BIGINT,
  "adjusted_offensive_efficiency" DOUBLE,
  "adjusted_offensive_efficiency_rank" BIGINT,
  "raw_offensive_efficiency" DOUBLE,
  "raw_offensive_efficiency_rank" BIGINT,
  "adjusted_defensive_efficiency" DOUBLE,
  "adjusted_defensive_efficiency_rank" BIGINT,
  "raw_defensive_efficiency" DOUBLE,
  "raw_defensive_efficiency_rank" BIGINT,
  "avg_possession_length_offense" DOUBLE,
  "avg_possession_length_offense_rank" DOUBLE,
  "avg_possession_length_defense" DOUBLE,
  "avg_possession_length_defense_rank" DOUBLE
);