Boxing

Match History of Recent Top Boxing Competitor

@kaggle.kirilspiridonov_boxing

Table List

10 tables(230.35 KB)

Cleandata V4

@kaggle.kirilspiridonov_boxing.cleandata_v4

23.64 KB
115 rows
26 columns

unnamed_0 Unnamed: 0	x X	f_boxer F Boxer	s_boxer S Boxer	f_boxer_result F Boxer Result	f_boxer_stance F Boxer Stance	f_boxer_age F Boxer Age	f_boxer_height F Boxer Height	f_boxer_reach F Boxer Reach	f_boxer_won F Boxer Won	f_boxer_lost F Boxer Lost	f_boxer_kos F Boxer KOs	f_boxer_ranking F Boxer Ranking	s_boxer_ranking S Boxer Ranking	s_boxer_age S Boxer Age	s_boxer_stance S Boxer Stance	s_boxer_reach S Boxer Reach	s_boxer_height S Boxer Height	s_boxer_won S Boxer Won	s_boxer_lost S Boxer Lost	s_boxer_drawn S Boxer Drawn	s_boxer_kos S Boxer KOs	s_boxer_result S Boxer Result	matchrounds MatchRounds	fightend FightEnd
1	1	Kubrat Pulev	Danny Batchelder	won	orthodox	28	194	202	6		4	2	24	33	orthodox	191	185	25	7	1	12	lost	2	KO/TKO
2	2	Kubrat Pulev	Kevin Johnson	won	orthodox	35	194	202	24	1	13	2	23	37	orthodox	208	191	30	7	1	14	lost	2	UD
3	3	Kubrat Pulev	Tony Thompson	won	orthodox	32	194	202	17		9	2	24	41	southpaw	207	196	38	3		26	lost	2	UD
4	4	Kubrat Pulev	Michael Sprott	won	orthodox	30	194	202	14		6	2	24	36	orthodox	199.414634146341	187	36	17		17	lost	9	RTD
5	5	Kubrat Pulev	Alexander Ustinov	won	orthodox	31	194	202	16		8	2	22	35	orthodox	199.414634146341	202	27			21	lost	1	KO/TKO
6	6	Kubrat Pulev	Gbenga Oluokun	won	orthodox	28	194	202	2		2	2	24	26	orthodox	199.414634146341	185	17	2		10	lost	6	UD
7	7	Kubrat Pulev	George Arias	won	orthodox	34	194	202	20	1	11	2	24	41	orthodox	199.414634146341	181	56	13		42	lost	8	UD
8	8	Kubrat Pulev	Maurice Harris	won	orthodox	34	194	202	21	1	11	2	24	39	orthodox	203	193	26	20	3	11	lost	1	KO/TKO
9	9	Kubrat Pulev	Derric Rossy	won	orthodox	30	194	202	11		5	2	24	30	orthodox	194	191	25	3		14	lost	5	KO/TKO
10	10	Kubrat Pulev	Ivica Perkovic	won	orthodox	32	194	202	19		10	2	24	39	orthodox	193	193	20	23		15	lost	3	RTD


CREATE TABLE cleandata_v4 (
  "unnamed_0" BIGINT,
  "x" BIGINT,
  "f_boxer" VARCHAR,
  "s_boxer" VARCHAR,
  "f_boxer_result" VARCHAR,
  "f_boxer_stance" VARCHAR,
  "f_boxer_age" BIGINT,
  "f_boxer_height" BIGINT,
  "f_boxer_reach" DOUBLE,
  "f_boxer_won" BIGINT,
  "f_boxer_lost" BIGINT,
  "f_boxer_drawn" BIGINT,
  "f_boxer_kos" BIGINT,
  "f_boxer_ranking" BIGINT,
  "s_boxer_ranking" BIGINT,
  "s_boxer_age" BIGINT,
  "s_boxer_stance" VARCHAR,
  "s_boxer_reach" DOUBLE,
  "s_boxer_height" DOUBLE,
  "s_boxer_won" BIGINT,
  "s_boxer_lost" BIGINT,
  "s_boxer_drawn" BIGINT,
  "s_boxer_kos" BIGINT,
  "s_boxer_result" VARCHAR,
  "matchrounds" DOUBLE,
  "fightend" VARCHAR
);