Boxing

Match History of Recent Top Boxing Competitor

@kaggle.kirilspiridonov_boxing

Table List

10 tables(230.35 KB)

Cleandata

@kaggle.kirilspiridonov_boxing.cleandata

24.87 KB
127 rows
26 columns

unnamed_0 Unnamed: 0	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	rounds Rounds	s_boxer_result S Boxer Result	matchrounds MatchRounds	fightend FightEnd
1	Kubrat Pulev	Danny Batchelder	won	orthodox	28	194	202	6		4	11		33	orthodox	191	185cm	25	7	1	12	Kubrat Pulev won TKO round 2	lost	2	KO/TKO
2	Kubrat Pulev	Kevin Johnson	won	orthodox	35	194	202	24	1	13	11	97	37	orthodox	208	191cm	30	7	1	14	Kubrat Pulev won UD round 12	lost	2	UD
3	Kubrat Pulev	Tony Thompson	won	orthodox	32	194	202	17		9	11		41	southpaw	207	196cm	38	3		26	Kubrat Pulev won UD round 12	lost	2	UD
4	Kubrat Pulev	Michael Sprott	won	orthodox	30	194	202	14		6	11		36	orthodox		187cm	36	17		17	Kubrat Pulev won RTD round 9	lost	9	RTD
5	Kubrat Pulev	Alexander Ustinov	won	orthodox	31	194	202	16		8	11	83	35	orthodox		202cm	27			21	Kubrat Pulev won KO round 11	lost	1	KO/TKO
6	Kubrat Pulev	Gbenga Oluokun	won	orthodox	28	194	202	2		2	11		26	orthodox		185cm	17	2		10	Kubrat Pulev won UD round 6	lost	6	UD
7	Kubrat Pulev	George Arias	won	orthodox	34	194	202	20	1	11	11		41	orthodox		181cm	56	13		42	Kubrat Pulev won UD round 8	lost	8	UD
8	Kubrat Pulev	Maurice Harris	won	orthodox	34	194	202	21	1	11	11		39	orthodox	203	193cm	26	20	3	11	Kubrat Pulev won KO round 1	lost	1	KO/TKO
9	Kubrat Pulev	Derric Rossy	won	orthodox	30	194	202	11		5	11		30	orthodox	194	191cm	25	3		14	Kubrat Pulev won TKO round 5	lost	5	KO/TKO
10	Kubrat Pulev	Ivica Perkovic	won	orthodox	32	194	202	19		10	11		39	orthodox	193	193cm	20	23		15	Kubrat Pulev won RTD round 3	lost	3	RTD


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