Boxing
Match History of Recent Top Boxing Competitor
@kaggle.kirilspiridonov_boxing
Match History of Recent Top Boxing Competitor
@kaggle.kirilspiridonov_boxing
I have always watching boxing and wanted to predict the winner. Now I have extracted some data and hope you can also benefit from it as I haven't found a similar dataset online.
boxing_****.csv
is the raw data from the scraper.
cleandata_**.csv
is the data that I have transformed and every version is a step.
I have been transforming the data for a particular task, so I decided to upload all data that I have been through.
Many thanks to BoxRec. The data is scraped from their website.
I am wondering. Is this sufficient to predict the match outcome or match rounds?
CREATE TABLE boxing_aj (
"web_scraper_order" VARCHAR,
"web_scraper_start_url" VARCHAR,
"matchlink" VARCHAR,
"matchlink_href" VARCHAR,
"f_boxer" VARCHAR,
"s_boxer" VARCHAR,
"f_boxer_result" VARCHAR,
"f_boxer_stance" VARCHAR,
"f_boxer_age" BIGINT,
"f_boxer_height" VARCHAR,
"f_boxer_reach" VARCHAR,
"f_boxer_won" BIGINT,
"f_boxer_lost" BIGINT,
"f_boxer_drawn" BIGINT,
"f_boxer_kos" BIGINT,
"f_boxer_ranking" BIGINT,
"s_boxer_ranking" DOUBLE,
"s_boxer_age" BIGINT,
"s_boxer_stance" VARCHAR,
"s_boxer_reach" VARCHAR,
"s_boxer_height" VARCHAR,
"s_boxer_won" BIGINT,
"s_boxer_lost" BIGINT,
"s_boxer_drawn" BIGINT,
"s_boxer_kos" BIGINT,
"rounds" VARCHAR
);
CREATE TABLE boxing_klitschko (
"web_scraper_order" VARCHAR,
"web_scraper_start_url" VARCHAR,
"matchlink" VARCHAR,
"matchlink_href" VARCHAR,
"f_boxer" VARCHAR,
"s_boxer" VARCHAR,
"f_boxer_result" VARCHAR,
"f_boxer_stance" VARCHAR,
"f_boxer_age" VARCHAR,
"f_boxer_height" VARCHAR,
"f_boxer_reach" VARCHAR,
"f_boxer_won" BIGINT,
"f_boxer_lost" BIGINT,
"f_boxer_drawn" BIGINT,
"f_boxer_kos" DOUBLE,
"f_boxer_ranking" VARCHAR,
"s_boxer_ranking" VARCHAR,
"s_boxer_age" VARCHAR,
"s_boxer_stance" VARCHAR,
"s_boxer_reach" VARCHAR,
"s_boxer_height" VARCHAR,
"s_boxer_won" BIGINT,
"s_boxer_lost" BIGINT,
"s_boxer_drawn" BIGINT,
"s_boxer_kos" DOUBLE,
"rounds" VARCHAR
);
CREATE TABLE boxing_pulev (
"web_scraper_order" VARCHAR,
"web_scraper_start_url" VARCHAR,
"matchlink" VARCHAR,
"matchlink_href" VARCHAR,
"f_boxer" VARCHAR,
"s_boxer" VARCHAR,
"f_boxer_result" VARCHAR,
"f_boxer_stance" VARCHAR,
"f_boxer_age" BIGINT,
"f_boxer_height" VARCHAR,
"f_boxer_reach" VARCHAR,
"f_boxer_won" BIGINT,
"f_boxer_lost" BIGINT,
"f_boxer_drawn" BIGINT,
"f_boxer_kos" BIGINT,
"f_boxer_ranking" DOUBLE,
"s_boxer_ranking" DOUBLE,
"s_boxer_age" BIGINT,
"s_boxer_stance" VARCHAR,
"s_boxer_reach" VARCHAR,
"s_boxer_height" VARCHAR,
"s_boxer_won" BIGINT,
"s_boxer_lost" BIGINT,
"s_boxer_drawn" BIGINT,
"s_boxer_kos" BIGINT,
"rounds" VARCHAR
);
CREATE TABLE boxing_pulev_clean (
"web_scraper_order" VARCHAR,
"web_scraper_start_url" VARCHAR,
"f_boxer" VARCHAR,
"s_boxer" VARCHAR,
"f_boxer_result" VARCHAR,
"f_boxer_stance" VARCHAR,
"f_boxer_age" BIGINT,
"f_boxer_height" VARCHAR,
"f_boxer_reach" VARCHAR,
"f_boxer_won" BIGINT,
"f_boxer_lost" BIGINT,
"f_boxer_drawn" BIGINT,
"f_boxer_kos" BIGINT,
"f_boxer_ranking" DOUBLE,
"s_boxer_ranking" DOUBLE,
"s_boxer_age" BIGINT,
"s_boxer_stance" VARCHAR,
"s_boxer_reach" VARCHAR,
"s_boxer_height" VARCHAR,
"s_boxer_won" BIGINT,
"s_boxer_lost" BIGINT,
"s_boxer_drawn" BIGINT,
"s_boxer_kos" BIGINT,
"rounds" VARCHAR
);
CREATE TABLE boxing_tysonfury (
"web_scraper_order" VARCHAR,
"web_scraper_start_url" VARCHAR,
"matchlink" VARCHAR,
"matchlink_href" VARCHAR,
"f_boxer" VARCHAR,
"s_boxer" VARCHAR,
"f_boxer_result" VARCHAR,
"f_boxer_stance" VARCHAR,
"f_boxer_age" BIGINT,
"f_boxer_height" VARCHAR,
"f_boxer_reach" VARCHAR,
"f_boxer_won" BIGINT,
"f_boxer_lost" BIGINT,
"f_boxer_drawn" BIGINT,
"f_boxer_kos" BIGINT,
"f_boxer_ranking" DOUBLE,
"s_boxer_ranking" DOUBLE,
"s_boxer_age" BIGINT,
"s_boxer_stance" VARCHAR,
"s_boxer_reach" VARCHAR,
"s_boxer_height" VARCHAR,
"s_boxer_won" BIGINT,
"s_boxer_lost" BIGINT,
"s_boxer_drawn" BIGINT,
"s_boxer_kos" BIGINT,
"rounds" VARCHAR
);
CREATE TABLE cleandata (
"unnamed_0" BIGINT -- Unnamed: 0,
"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
);
CREATE TABLE cleandata_v2 (
"unnamed_0" BIGINT -- Unnamed: 0,
"x" 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" BIGINT,
"s_boxer_ranking" BIGINT,
"s_boxer_age" DOUBLE,
"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" DOUBLE,
"rounds" VARCHAR,
"s_boxer_result" VARCHAR,
"matchrounds" DOUBLE,
"fightend" VARCHAR
);
CREATE TABLE cleandata_v3 (
"unnamed_0" BIGINT -- Unnamed: 0,
"x" 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" BIGINT,
"s_boxer_ranking" BIGINT,
"s_boxer_age" DOUBLE,
"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" DOUBLE,
"s_boxer_result" VARCHAR,
"matchrounds" DOUBLE,
"fightend" VARCHAR
);
CREATE TABLE cleandata_v4 (
"unnamed_0" BIGINT -- Unnamed: 0,
"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
);
CREATE TABLE cleandata_v5 (
"unnamed_0" BIGINT -- Unnamed: 0,
"x" DOUBLE,
"f_boxer" VARCHAR,
"s_boxer" VARCHAR,
"f_boxer_result" VARCHAR,
"f_boxer_stance" VARCHAR,
"f_boxer_age" DOUBLE,
"f_boxer_height" DOUBLE,
"f_boxer_reach" DOUBLE,
"f_boxer_won" DOUBLE,
"f_boxer_lost" DOUBLE,
"f_boxer_drawn" DOUBLE,
"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" DOUBLE,
"s_boxer_won" DOUBLE,
"s_boxer_lost" DOUBLE,
"s_boxer_drawn" DOUBLE,
"s_boxer_kos" DOUBLE,
"s_boxer_result" VARCHAR,
"matchrounds" DOUBLE,
"fightend" VARCHAR
);
Anyone who has the link will be able to view this.