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

Dev March Madness

@kaggle.jonathanpilafas_2024_march_madness_statistical_analysis.dev_march_madness

3.33 MB
8314 rows
147 columns
Only the first 100 columns are shown

season Season	short_conference_name Short Conference Name	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	efgpct EFGPct	rankefgpct RankeFGPct	topct TOPct	ranktopct RankTOPct	orpct ORPct	rankorpct RankORPct	ftrate FTRate	rankftrate RankFTRate	offft OffFT	rankoffft RankOffFT	off2ptfg Off2PtFG	rankoff2ptfg RankOff2PtFG	off3ptfg Off3PtFG	rankoff3ptfg RankOff3PtFG	defft DefFT	rankdefft RankDefFT	def2ptfg Def2PtFG	rankdef2ptfg RankDef2PtFG	def3ptfg Def3PtFG	rankdef3ptfg RankDef3PtFG	tempo Tempo	ranktempo RankTempo	adjtempo AdjTempo	rankadjtempo RankAdjTempo	oe OE	rankoe RankOE	adjoe AdjOE	rankadjoe RankAdjOE	de DE	rankde RankDE	adjde AdjDE	rankadjde RankAdjDE	adjem AdjEM	rankadjem RankAdjEM	fg2pct FG2Pct	rankfg2pct RankFG2Pct	fg3pct FG3Pct	rankfg3pct RankFG3Pct	ftpct FTPct	rankftpct RankFTPct	blockpct BlockPct	rankblockpct RankBlockPct	oppfg2pct OppFG2Pct	rankoppfg2pct RankOppFG2Pct	oppfg3pct OppFG3Pct	rankoppfg3pct RankOppFG3Pct	oppftpct OppFTPct	rankoppftpct RankOppFTPct	oppblockpct OppBlockPct	rankoppblockpct RankOppBlockPct	fg3rate FG3Rate	rankfg3rate RankFG3Rate	oppfg3rate OppFG3Rate	rankoppfg3rate RankOppFG3Rate	arate ARate	rankarate RankARate	opparate OppARate	rankopparate RankOppARate	stlrate StlRate	rankstlrate RankStlRate	oppstlrate OppStlRate	rankoppstlrate RankOppStlRate	dfp DFP	nstrate NSTRate	ranknstrate RankNSTRate	oppnstrate OppNSTRate	rankoppnstrate RankOppNSTRate	avgheight AvgHeight	rankavgheight RankAvgHeight	centerheight CenterHeight	rankcenterheight RankCenterHeight	pfheight PFHeight	rankpfheight RankPFHeight	sfheight SFHeight	ranksfheight RankSFHeight	sgheight SGHeight	ranksgheight RankSGHeight	pgheight PGHeight	rankpgheight RankPGHeight	effectiveheight EffectiveHeight	rankeffectiveheight RankEffectiveHeight	experience Experience
2015	SEC	62.4	274	63.8	242	121.3	6	115.5	9	84.4	1	84.7	1	17.7	98	19.6	327	51.5116	75	16.2529	32	39.5012	8	43.8605	31	23.6207	45	55.3793	54	21	326	20.916	161	54.2965	57	24.7875	301	63.7517	242	62.4233	274	115.452	9	121.305	6	84.6617	1	84.3933	1	36.9118	1	51.2117	53	34.8797	145	72.6405	59	18.1633	2	39.1156	2	27.0898	1	66.0209	28	5.9949	3	27.0698	325	30.5293	71	54.9702	136	40.1333	2	0.1008	107	0.0725	12						79.28	1	3	5	3.89	1	2.88	3	3.3	2		183	6.89	1	0.73
2021	WCC	73.8	7	74.3	14	126.4	1	121.9	1	89.9	11	93.4	17	14.4	3	18	299	61.0178117048346	1	16.1279343153221	40	30.0706357214934	102	35.7251908396947	66	17.6228100309172	214	57.6434215046376	26	24.7337684644452	312	15.9192825112108	287	54.8878923766816	45	29.1928251121076	227	74.3411	14	73.7515	7	121.917	1	126.433	1	93.4015	17	89.9493	11	36.4833	1	63.8994668697639	1	36.8098159509202	45	73.0769230769231	97	6.9071373752878	262	46.968534151957	76	32.7300150829563	112	70.2970297029703	143	6.77837014470678	26	33.1806615776081	275	33.7232960325534	67	55.6070435588508	79	45.4764776839566	47	0.106402475742644	57	0.0816869400386442	90		7.95924031145764	33	8.67138286564069	275	78.11	29	0.83	79	0.47	103	0.69	88	1.77	28	2.21	22	0.65	82	1.54
2024	BE	64.6	330	66	305	127.5	1	123	1	91.1	4	96.4	9	18.6	305	17.5	183	56.9074778200253	7	14.4996805716584	36	36.697965571205	12	31.9391634980989	202	17.2604422604423	270	51.4127764127764	153	31.3267813267813	149	20.2681388012618	110	52.0504731861199	124	27.6813880126183	277	66.0359	305	64.6331	330	123.036	1	127.524	1	96.3938	9	91.0982	4	36.4262	1	59.1101694915254	4	35.751840168244	72	74.3386243386243	84	14.1922825376063	13	43.1654676258993	4	31.241655540721	37	72.4964739069111	221	8.33333333333333	102	40.1774397972117	103	32.8797190517998	44	63.5514018691589	5	44.7427293064877	41	0.0931311075881977	172	0.0810164919669687	54		6.39803137496155	46	6.70089676549227	300	78.42	23	2.47	10	0.59	105	0.39	125	1.16	49	1.83	39	1.53	24	2.43106
2025	SEC	68.5	182	68.8	199	130.8	1	128.5	1	94.5	13	95.7	44	16.8	111	18.1	305	59.6026490066225	3	12.9671428355021	2	35.5670103092784	37	28.2119205298013	299	15.1743638077286	325	49.7643732327992	167	35.0612629594722	94	21.2738853503185	71	51.2101910828025	120	27.515923566879	303	68.7635	199	68.4933	182	128.493	1	130.751	1	95.7004	44	94.4856	13	36.2655	1	61.5384615384615	4	38.0368098159509	34	75.5868544600939	72	16.4904862579281	10	42.4947145877378	9	31.5789473684211	109	71.3675213675214	166	4.66200466200466	3	43.1788079470199	87	32.5249643366619	22	59.2783505154639	45	34.7985347985348	2	0.0981624831472589	177	0.0860436580673504	79		4.36277702876706	1	6.66535379394968	300	78.27	40	1.09	67	0.41	122	1.28	35	1.73	16	0.74	121	0.75	80	2.78865
2008	B12	66.8	109	68.5	120	120.9	2	116.6	2	85.7	1	89.5	4					56.5912	5	19.1079	61	37.7628	24	36.3515	178	18.5043	260	56.3758	36	25.1198	259	19.2917	216	46.3333	300	34.375	28	68.4549	120	66.806	109	116.619	2	120.873	2	89.5076	4	85.665	1	35.2083	1	55.3672	6	39.697	14	70.696	117	16.7407	5	41.1852	4	32.8162	55	68.1885	121	6.3402	8	29.2943	287	38.2998	285	61.1014	50	52.7076	108	0.1299	16	0.0914	108						76.99	99	1.56	33	0.88	93	-2.13	330	-0.69	253	-0.27	191	2.44	43	2.09
2019	ACC	59.4	353	60.6	353	123.4	2	116.6	4	89.2	5	91.8	6	21	352	18.8	344	55.1799610894942	19	14.706672830282	12	30.3664921465969	101	29.0856031128405	279	16.3964627855564	293	48.1208548268239	213	35.4826823876197	89	16.3696060037523	298	49.155722326454	194	34.4746716697936	87	60.6202	353	59.4019	353	116.554	4	123.403	2	91.78	6	89.1871	5	34.2156	1	52.5341914722446	75	39.4833948339483	8	74.4147157190636	54	12.9904097646033	28	45.6843940714908	22	28.8915094339623	3	66.6030534351145	19	8.2864038616251	93	39.5428015564202	149	42.5062656641604	299	55.8521560574949	67	43.4330299089727	19	0.0907341510874123	146	0.081273718272611	87	3.82664022505467					77.2	119	1.27	45	1.09	60	1.29	45	0.26	141	-1.99	312	1.18	47	1.6
2002	ACC	74.5	8	76.8	9	121	1	115.7	2	86.8	1	89.7	2					56.2924	2	18.5699	26	34.4605	144	41.014	80	20.0835	207	50.8997	201	29.0167	99	19.3722	231	59.81	3	20.8178	314	76.8235	9	74.4638	8	115.743	2	120.99	1	89.6799	2	86.802	1	34.1881	1	57.4329	2	36.2651	86	68.9845	164	7.2251	215	46.2916	100	30.2703	17	68.8693	152	7.4692	83	37.5736	52	26.1916	14	57.1821	123	49.5516	43	0.1297	26	0.0919	79
2021	B12	67.4	213	69.3	170	125	2	119.1	2	91.1	22	94.5	29	17	140	17.6	231	56.5482502651113	7	16.5283317164313	54	37.2930866601753	5	26.5111346765642	295	14.2340168878166	322	49.6984318455971	210	36.0675512665862	50	18.1771894093686	172	53.5641547861507	76	28.2586558044807	258	69.2981	170	67.4416	213	119.106	2	124.994	2	94.4826	29	91.1275	22	33.867	2	53.184165232358	48	41.2983425414365	1	70.8	186	10.2873030583874	85	48.7488415199259	130	32.8596802841918	118	69.4552529182879	92	10.5851979345955	291	38.3881230116649	159	34.2874543239951	78	55.288985823337	86	51.7580872011252	177	0.127914915022816	6	0.0800067071491023	71		8.52766100152109	75	11.6416945133125	37	76.66	215	0.09	144	-1.21	308	-1.2	307	-0.09	197	1.14	97	-0.56	251	2.01
2018	BE	68.7	150	70	138	127.8	1	122.7	1	94	11	99.3	51	17.9	233	16.6	44	59.5081967213115	1	15.0455126758444	14	29.5698924731183	140	29.4262295081967	287	16.1420733468091	318	43.6615651169506	316	40.1963615362403	15	17.0644816530103	274	53.8653366583541	39	29.0701816886356	262	70.0051	138	68.7242	150	122.728	1	127.756	1	99.3109	51	94.0001	11	33.7563	1	58.9703588143526	3	40.0690846286701	11	77.8551532033426	11	10.49902786779	93	48.9954633830201	140	31.7016317016317	15	74.7269890795632	328	8.19032761310452	94	47.4590163934426	12	35.7351103706789	117	53.6885245901639	137	51.7509727626459	162	0.0916891243069108	125	0.0683243281514818	13	4.04958727136242					77.33	96	-1.05	267	0.19	138	1.34	32	0.66	99	1.51	52	-0.43	228	1.33
2015	B10	58.7	345	59.5	344	129	1	121.1	1	95.2	35	97.5	72	21.8	350	18.3	167	54.7518	16	12.3664	1	32.1309	125	36.1702	193	20.1379	201	50.069	202	29.7931	139	14.3103	349	59.6476	6	26.0421	258	59.4998	344	58.675	345	121.133	1	128.952	1	97.5034	72	95.2324	35	33.7197	2	54.7925	9	36.4557	79	76.3399	12	8.1725	238	44.6589	62	37.5465	308	71.0021	265	6.3396	6	37.3522	89	25.717	6	49.7041	248	39.9554	1	0.0727	325	0.0681	3						79.17	2	2.62	10	2.42	3	3.08	2	1.3	45	3.12	7	5.05	4	2.08


CREATE TABLE dev_march_madness (
  "season" BIGINT,
  "short_conference_name" 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,
  "efgpct" DOUBLE,
  "rankefgpct" BIGINT,
  "topct" DOUBLE,
  "ranktopct" BIGINT,
  "orpct" DOUBLE,
  "rankorpct" BIGINT,
  "ftrate" DOUBLE,
  "rankftrate" BIGINT,
  "offft" DOUBLE,
  "rankoffft" BIGINT,
  "off2ptfg" DOUBLE,
  "rankoff2ptfg" BIGINT,
  "off3ptfg" DOUBLE,
  "rankoff3ptfg" BIGINT,
  "defft" DOUBLE,
  "rankdefft" BIGINT,
  "def2ptfg" DOUBLE,
  "rankdef2ptfg" BIGINT,
  "def3ptfg" DOUBLE,
  "rankdef3ptfg" BIGINT,
  "tempo" DOUBLE,
  "ranktempo" BIGINT,
  "adjtempo" DOUBLE,
  "rankadjtempo" BIGINT,
  "oe" DOUBLE,
  "rankoe" BIGINT,
  "adjoe" DOUBLE,
  "rankadjoe" BIGINT,
  "de" DOUBLE,
  "rankde" BIGINT,
  "adjde" DOUBLE,
  "rankadjde" BIGINT,
  "adjem" DOUBLE,
  "rankadjem" BIGINT,
  "fg2pct" DOUBLE,
  "rankfg2pct" BIGINT,
  "fg3pct" DOUBLE,
  "rankfg3pct" BIGINT,
  "ftpct" DOUBLE,
  "rankftpct" BIGINT,
  "blockpct" DOUBLE,
  "rankblockpct" BIGINT,
  "oppfg2pct" DOUBLE,
  "rankoppfg2pct" BIGINT,
  "oppfg3pct" DOUBLE,
  "rankoppfg3pct" BIGINT,
  "oppftpct" DOUBLE,
  "rankoppftpct" BIGINT,
  "oppblockpct" DOUBLE,
  "rankoppblockpct" BIGINT,
  "fg3rate" DOUBLE,
  "rankfg3rate" BIGINT,
  "oppfg3rate" DOUBLE,
  "rankoppfg3rate" BIGINT,
  "arate" DOUBLE,
  "rankarate" BIGINT,
  "opparate" DOUBLE,
  "rankopparate" BIGINT,
  "stlrate" DOUBLE,
  "rankstlrate" BIGINT,
  "oppstlrate" DOUBLE,
  "rankoppstlrate" BIGINT,
  "dfp" DOUBLE,
  "nstrate" DOUBLE,
  "ranknstrate" DOUBLE,
  "oppnstrate" DOUBLE,
  "rankoppnstrate" DOUBLE,
  "avgheight" DOUBLE,
  "rankavgheight" DOUBLE,
  "centerheight" DOUBLE,
  "rankcenterheight" DOUBLE,
  "pfheight" DOUBLE,
  "rankpfheight" DOUBLE,
  "sfheight" DOUBLE,
  "ranksfheight" DOUBLE,
  "sgheight" DOUBLE,
  "ranksgheight" DOUBLE,
  "pgheight" DOUBLE,
  "rankpgheight" DOUBLE,
  "effectiveheight" DOUBLE,
  "rankeffectiveheight" DOUBLE,
  "experience" DOUBLE
);