League Of Legends: World Championship 2022
A collection of data from the World Championship 2022
@kaggle.ilyadziamidovich_league_of_legends_world_championship_2022
Table List
- 5 tables(115.89 KB)
Wc Champions
@kaggle.ilyadziamidovich_league_of_legends_world_championship_2022.wc_champions
- 18.38 KB
- 108 rows
- 19 columns
unnamed_0Unnamed: 0 | championChampion | sum_totalSum Total | win_totalWin Total | lose_totalLose Total | winrate_totalWinrate Total | pick_ratePick Rate | sum_blue_sideSum Blue Side | win_blue_sideWin Blue Side | lose_blue_sideLose Blue Side | winrate_blue_sideWinrate Blue Side | sum_red_sideSum Red Side | win_red_sideWin Red Side | lose_red_sideLose Red Side | winrate_red_sideWinrate Red Side | sum_bansSum Bans | ban_rateBan Rate | sum_pick_banSum Pick Ban | pick_ban_ratePick Ban Rate |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Sylas | 50 | 33 | 17 | 66.00% | 39.37% | 28 | 21 | 7 | 75.00% | 22 | 12 | 10 | 54.55% | 49 | 38.58% | 99 | 77.95% | |
| 1 | Sejuani | 49 | 24 | 25 | 48.98% | 38.58% | 23 | 12 | 11 | 52.17% | 26 | 12 | 14 | 46.15% | 57 | 44.88% | 106 | 83.46% |
| 2 | Azir | 48 | 24 | 24 | 50.00% | 37.80% | 27 | 14 | 13 | 51.85% | 21 | 10 | 11 | 47.62% | 43 | 33.86% | 91 | 71.65% |
| 3 | Aatrox | 46 | 29 | 17 | 63.04% | 36.22% | 35 | 24 | 11 | 68.57% | 11 | 5 | 6 | 45.45% | 79 | 62.20% | 125 | 98.43% |
| 4 | Aphelios | 43 | 23 | 20 | 53.49% | 33.86% | 20 | 10 | 10 | 50.00% | 23 | 13 | 10 | 56.52% | 20 | 15.75% | 63 | 49.61% |
| 5 | Maokai | 43 | 22 | 21 | 51.16% | 33.86% | 27 | 13 | 14 | 48.15% | 16 | 9 | 7 | 56.25% | 48 | 37.80% | 91 | 71.65% |
| 6 | Viego | 38 | 24 | 14 | 63.16% | 29.92% | 20 | 13 | 7 | 65.00% | 18 | 11 | 7 | 61.11% | 18 | 14.17% | 56 | 44.09% |
| 7 | Akali | 33 | 18 | 15 | 54.55% | 25.98% | 13 | 8 | 5 | 61.54% | 20 | 10 | 10 | 50.00% | 34 | 26.77% | 67 | 52.76% |
| 8 | Graves | 33 | 16 | 17 | 48.48% | 25.98% | 14 | 7 | 7 | 50.00% | 19 | 9 | 10 | 47.37% | 50 | 39.37% | 83 | 65.35% |
| 9 | Lucian | 30 | 19 | 11 | 63.33% | 23.62% | 15 | 10 | 5 | 66.67% | 15 | 9 | 6 | 60.00% | 29 | 22.83% | 59 | 46.46% |
CREATE TABLE wc_champions (
"unnamed_0" BIGINT,
"champion" VARCHAR,
"sum_total" BIGINT,
"win_total" BIGINT,
"lose_total" BIGINT,
"winrate_total" VARCHAR,
"pick_rate" 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,
"sum_bans" BIGINT,
"ban_rate" VARCHAR,
"sum_pick_ban" BIGINT,
"pick_ban_rate" VARCHAR
);