League Of Legends: World Championship 2019

A collection of data from the World Championship 2019

@kaggle.ilyadziamidovich_league_of_legends_world_championship_2019

Table List

3 tables(313.03 KB)

Wc Champions

Wc Matches

Wc Players

Wc Champions

@kaggle.ilyadziamidovich_league_of_legends_world_championship_2019.wc_champions

27.45 KB
98 rows
32 columns

unnamed_0 Unnamed: 0	champion Champion	sum_total Sum Total	win_total Win Total	lose_total Lose Total	winrate_total Winrate Total	sum_blue_side Sum Blue Side	win_blue_side Win Blue Side	lose_blue_side Lose Blue Side	winrate_blue_side Winrate Blue Side	sum_red_side Sum Red Side	win_red_side Win Red Side	lose_red_side Lose Red Side	winrate_red_side Winrate Red Side	matches_less_25_min Matches Less 25 Min	win_lose_less_25_min Win Lose Less 25 Min	winrate_less_25_min Winrate Less 25 Min	matches_25_to_30_min Matches 25 To 30 Min	win_lose_25_to_30_min Win Lose 25 To 30 Min	winrate_25_30_min Winrate 25–30 Min	matches_30_35_min Matches 30–35 Min	win_lose_30_35_min Win Lose 30–35 Min	winrate_30_35_min Winrate 30–35 Min	matches_35_40_min Matches 35–40 Min	win_lose_35_40_min Win Lose 35–40 Min	winrate_35_40_min Winrate 35–40 Min	matches_40_45_min Matches 40–45 Min	win_lose_40_45_min Win Lose 40–45 Min	winrate_40_45_min Winrate 40–45 Min	matches_more_45_min Matches More 45 Min	win_lose_more_45_min Win Lose More 45 Min	winrate_more_45_min Winrate More 45 Min
1	Kai'Sa	71	37	34	52%	30	15	15	50%	41	22	19	54%	7	2-5	29%	21	15-6	71%	26	12-14	46%	11	4-7	36%	5	3-2	60%	1	1-0	100%
2	Lee Sin	58	30	28	52%	21	11	10	52%	37	19	18	51%	4	2-2	50%	15	8-7	53%	20	9-11	45%	10	6-4	60%	8	5-3	63%	1	0-1	0%
3	Xayah	57	35	22	61%	33	21	12	64%	24	14	10	58%	5	3-2	60%	13	9-4	69%	23	16-7	70%	9	3-6	33%	5	2-3	40%	2	2-0	100%
4	Nautilus	52	28	24	54%	27	17	10	63%	25	11	14	44%	4	1-3	25%	11	6-5	55%	19	9-10	47%	11	7-4	64%	5	3-2	60%	2	2-0	100%
5	Gragas	49	32	17	65%	26	16	10	62%	23	16	7	70%	4	2-2	50%	13	7-6	54%	17	10-7	59%	7	6-1	86%	6	6-0	100%	2	1-1	50%
6	Rakan	43	23	20	53%	25	13	12	52%	18	10	8	56%	3	3-0	100%	9	5-4	56%	18	9-9	50%	8	3-5	38%	4	3-1	75%	1	0-1	0%
7	Gangplank	38	21	17	55%	21	11	10	52%	17	10	7	59%	2	0-2	0%	6	5-1	83%	16	8-8	50%	7	3-4	43%	4	3-1	75%	3	2-1	67%
8	Ryze	36	22	14	61%	21	13	8	62%	15	9	6	60%	2	2-0	100%	10	5-5	50%	14	9-5	64%	7	5-2	71%	2	1-1	50%	1	0-1	0%
9	Akali	35	17	18	49%	18	10	8	56%	17	7	10	41%	2	2-0	100%	9	4-5	44%	11	7-4	64%	8	4-4	50%	3	0-3	0%	2	0-2	0%
10	Thresh	35	16	19	46%	18	10	8	56%	17	6	11	35%	1	1-0	100%	10	4-6	40%	14	6-8	43%	4	3-1	75%	5	2-3	40%	1	0-1	0%


CREATE TABLE wc_champions (
  "unnamed_0" BIGINT,
  "champion" VARCHAR,
  "sum_total" BIGINT,
  "win_total" BIGINT,
  "lose_total" BIGINT,
  "winrate_total" VARCHAR,
  "sum_blue_side" BIGINT,
  "win_blue_side" BIGINT,
  "lose_blue_side" BIGINT,
  "winrate_blue_side" VARCHAR,
  "sum_red_side" BIGINT,
  "win_red_side" BIGINT,
  "lose_red_side" BIGINT,
  "winrate_red_side" VARCHAR,
  "matches_less_25_min" BIGINT,
  "win_lose_less_25_min" VARCHAR,
  "winrate_less_25_min" VARCHAR,
  "matches_25_to_30_min" BIGINT,
  "win_lose_25_to_30_min" VARCHAR,
  "winrate_25_30_min" VARCHAR,
  "matches_30_35_min" BIGINT,
  "win_lose_30_35_min" VARCHAR,
  "winrate_30_35_min" VARCHAR,
  "matches_35_40_min" BIGINT,
  "win_lose_35_40_min" VARCHAR,
  "winrate_35_40_min" VARCHAR,
  "matches_40_45_min" BIGINT,
  "win_lose_40_45_min" VARCHAR,
  "winrate_40_45_min" VARCHAR,
  "matches_more_45_min" BIGINT,
  "win_lose_more_45_min" VARCHAR,
  "winrate_more_45_min" VARCHAR
);