Cricket Players Dataset

90,000 Players, 180+ Features, Endless Possibilities (with Data Cleaning Fun!)

@kaggle.zainhaidar_cricket_players_dataset

Table List

2 tables(26.22 MB)

Cricket Players Cleaned Data

@kaggle.zainhaidar_cricket_players_dataset.cricket_players_cleaned_data

9.02 MB
90308 rows
177 columns
Only the first 100 columns are shown

unnamed_0 Unnamed: 0	id ID	name NAME	country COUNTRY	full_name Full Name	birthdate Birthdate	birthplace Birthplace	died Died	date_of_death Date Of Death	age Age	major_teams Major Teams	batting_style Batting Style	bowling_style Bowling Style	other Other	awards AWARDS	batting_tests_hs BATTING Tests HS	batting_odis_hs BATTING ODIs HS	batting_t20is_hs BATTING T20Is HS	batting_first_class_mat BATTING First-class Mat	batting_first_class_inns BATTING First-class Inns	batting_first_class_no BATTING First-class NO	batting_first_class_runs BATTING First-class Runs	batting_first_class_hs BATTING First-class HS	batting_first_class_ave BATTING First-class Ave	batting_first_class_100 BATTING First-class 100	batting_first_class_50 BATTING First-class 50	batting_first_class_ct BATTING First-class Ct	batting_first_class_st BATTING First-class St	batting_list_a_mat BATTING List A Mat	batting_list_a_inns BATTING List A Inns	batting_list_a_no BATTING List A NO	batting_list_a_runs BATTING List A Runs	batting_list_a_hs BATTING List A HS	batting_list_a_ave BATTING List A Ave	batting_list_a_50 BATTING List A 50	batting_list_a_ct BATTING List A Ct	batting_t20s_hs BATTING T20s HS
	8772	Henry Arkell	England	Henry John Denham Arkell	1898-06-26	Edmonton, Middlesex	Dead	12/03/82	84	Northamptonshire	Right-hand bat	nan	nan	[]	nan	nan	nan	2	2		11	6	5.5									nan				nan
1	532565	Richard Nyren	England	Richard Nyren	1734-04-25	Eartham, Sussex	Dead	1797-04-25	63	Hampshire XI	Left-hand bat	Left-arm bowler (underarm)	nan	[]	nan	nan	nan	49	90	11	1026	97	12.98		2	24						nan				nan
2	16856	Sydney Maartensz	England	Sydney Gratien Adair Maartensz	1882-04-14	Colombo, Ceylon	Dead	10/09/67	85	Hampshire	Right-hand bat	nan	nan	[]	nan	nan	nan	12	17	2	283	60	18.86		1	21	4					nan				nan
3	16715	Brian Lander	England	Brian Richard Lander	09/01/42	Bishop Auckland, Co Durham	Alive	nan	77	['Durham,', 'Minor Counties']	Right-hand bat	Right-arm medium	nan	[]	nan	nan	nan					nan						26	21	3	122	28	6.77		2	nan
4	15989	Derek Kenderdine	England	Derek Charles Kenderdine	1897-10-28	Chislehurst, Kent	Dead	28/08/47	50	Royal Navy	Right-hand bat	Right-arm medium-fast	nan	[]	nan	nan	nan	2	4	1	7	6	2.33			1						nan				nan
5	16166	Rupert Kitzinger	England	Rupert Charles Kitzinger	24/03/79	Chertsey, Surrey	Alive	nan	40	['Dorset,', 'Marylebone Cricket Club']	Right-hand bat	Right-arm medium-fast	Coach, Administrator	[]	nan	nan	nan					nan										nan				nan
6	1151914	Megan Lovick	England	Megan Lovick	17/07/99	nan	Alive	nan	20	Charlbury Women CC	Right-hand bat	Right-arm medium	nan	[]	nan	nan	nan					nan										nan				nan
7	515901	Sophie Luff	England	Sophie Natasha Luff	06/12/93	Taunton, Somerset	Alive	nan	26	['Emeralds,', 'England Academy Women,', 'England Development Squad Women,', 'England Under-19s Women,', 'Somerset Women']	Right-hand bat	Right-arm medium	nan	[]	nan	nan	nan					nan										nan				nan
8	17673	Derek Morgan	England	Derek Clifton Morgan	26/02/29	Muswell Hill, Middlesex	Alive	nan	90	Derbyshire	Right-hand bat	Right-arm fast-medium	nan	[]	nan	nan	nan	556	882	146	18356	147	24.94	9	83	573		27	25	3	360	59*	16.36	1	11	nan
9	1152184	Molly Rossiter	England	Molly Beatrice Rossiter	21/01/03	nan	Alive	nan	16	['Leicestershire Women,', 'Sileby Town Ladies CC']	Right-hand bat	Right-arm medium	nan	[]	nan	nan	nan					nan										nan				nan


CREATE TABLE cricket_players_cleaned_data (
  "unnamed_0" BIGINT,
  "id" BIGINT,
  "name" VARCHAR,
  "country" VARCHAR,
  "full_name" VARCHAR,
  "birthdate" VARCHAR,
  "birthplace" VARCHAR,
  "died" VARCHAR,
  "date_of_death" VARCHAR,
  "age" DOUBLE,
  "major_teams" VARCHAR,
  "batting_style" VARCHAR,
  "bowling_style" VARCHAR,
  "other" VARCHAR,
  "awards" VARCHAR,
  "batting_tests_mat" DOUBLE,
  "batting_tests_inns" DOUBLE,
  "batting_tests_no" DOUBLE,
  "batting_tests_runs" DOUBLE,
  "batting_tests_hs" VARCHAR,
  "batting_tests_ave" DOUBLE,
  "batting_tests_bf" DOUBLE,
  "batting_tests_sr" DOUBLE,
  "batting_tests_100" DOUBLE,
  "batting_tests_50" DOUBLE,
  "batting_tests_4s" DOUBLE,
  "batting_tests_6s" DOUBLE,
  "batting_tests_ct" DOUBLE,
  "batting_tests_st" DOUBLE,
  "batting_odis_mat" DOUBLE,
  "batting_odis_inns" DOUBLE,
  "batting_odis_no" DOUBLE,
  "batting_odis_runs" DOUBLE,
  "batting_odis_hs" VARCHAR,
  "batting_odis_ave" DOUBLE,
  "batting_odis_bf" DOUBLE,
  "batting_odis_sr" DOUBLE,
  "batting_odis_100" DOUBLE,
  "batting_odis_50" DOUBLE,
  "batting_odis_4s" DOUBLE,
  "batting_odis_6s" DOUBLE,
  "batting_odis_ct" DOUBLE,
  "batting_odis_st" DOUBLE,
  "batting_t20is_mat" DOUBLE,
  "batting_t20is_inns" DOUBLE,
  "batting_t20is_no" DOUBLE,
  "batting_t20is_runs" DOUBLE,
  "batting_t20is_hs" VARCHAR,
  "batting_t20is_ave" DOUBLE,
  "batting_t20is_bf" DOUBLE,
  "batting_t20is_sr" DOUBLE,
  "batting_t20is_100" DOUBLE,
  "batting_t20is_50" DOUBLE,
  "batting_t20is_4s" DOUBLE,
  "batting_t20is_6s" DOUBLE,
  "batting_t20is_ct" DOUBLE,
  "batting_t20is_st" DOUBLE,
  "batting_first_class_mat" DOUBLE,
  "batting_first_class_inns" DOUBLE,
  "batting_first_class_no" DOUBLE,
  "batting_first_class_runs" DOUBLE,
  "batting_first_class_hs" VARCHAR,
  "batting_first_class_ave" DOUBLE,
  "batting_first_class_bf" DOUBLE,
  "batting_first_class_sr" DOUBLE,
  "batting_first_class_100" DOUBLE,
  "batting_first_class_50" DOUBLE,
  "batting_first_class_4s" DOUBLE,
  "batting_first_class_6s" DOUBLE,
  "batting_first_class_ct" DOUBLE,
  "batting_first_class_st" DOUBLE,
  "batting_list_a_mat" DOUBLE,
  "batting_list_a_inns" DOUBLE,
  "batting_list_a_no" DOUBLE,
  "batting_list_a_runs" DOUBLE,
  "batting_list_a_hs" VARCHAR,
  "batting_list_a_ave" DOUBLE,
  "batting_list_a_bf" DOUBLE,
  "batting_list_a_sr" DOUBLE,
  "batting_list_a_100" DOUBLE,
  "batting_list_a_50" DOUBLE,
  "batting_list_a_4s" DOUBLE,
  "batting_list_a_6s" DOUBLE,
  "batting_list_a_ct" DOUBLE,
  "batting_list_a_st" DOUBLE,
  "batting_t20s_mat" DOUBLE,
  "batting_t20s_inns" DOUBLE,
  "batting_t20s_no" DOUBLE,
  "batting_t20s_runs" DOUBLE,
  "batting_t20s_hs" VARCHAR,
  "batting_t20s_ave" DOUBLE,
  "batting_t20s_bf" DOUBLE,
  "batting_t20s_sr" DOUBLE,
  "batting_t20s_100" DOUBLE,
  "batting_t20s_50" DOUBLE,
  "batting_t20s_4s" DOUBLE,
  "batting_t20s_6s" DOUBLE,
  "batting_t20s_ct" DOUBLE,
  "batting_t20s_st" DOUBLE,
  "bowling_tests_mat" DOUBLE
);