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 Players

@kaggle.ilyadziamidovich_league_of_legends_world_championship_2019.wc_players

275 KB
1190 rows
91 columns

unnamed_0 Unnamed: 0	date Date	side Side	position Position	player Player	team Team	champion Champion	ban1 Ban1	ban2 Ban2	ban3 Ban3	ban4 Ban4	ban5 Ban5	gamelength Gamelength	result Result	k K	d D	a A	teamkills Teamkills	teamdeaths Teamdeaths	doubles Doubles	fb Fb	fbassist Fbassist	fbvictim Fbvictim	fbtime Fbtime	kpm Kpm	okpm Okpm	ckpm Ckpm	fd Fd	fdtime Fdtime	teamdragkills Teamdragkills	oppdragkills Oppdragkills	elementals Elementals	oppelementals Oppelementals	waterdrakes Waterdrakes	airdrakes Airdrakes	herald Herald	ft Ft	fttime Fttime	firstmidouter Firstmidouter	firsttothreetowers Firsttothreetowers	teamtowerkills Teamtowerkills	opptowerkills Opptowerkills	fbaron Fbaron	fbarontime Fbarontime	teambaronkills Teambaronkills	oppbaronkills Oppbaronkills	dmgtochamps Dmgtochamps	dmgtochampsperminute Dmgtochampsperminute	dmgshare Dmgshare	earnedgoldshare Earnedgoldshare	wards Wards	wpm Wpm	wardshare Wardshare	wardkills Wardkills	wcpm Wcpm	visionwards Visionwards	visionwardbuys Visionwardbuys	totalgold Totalgold	earnedgpm Earnedgpm	goldspent Goldspent	gspd Gspd	minionkills Minionkills	monsterkills Monsterkills	monsterkillsownjungle Monsterkillsownjungle	monsterkillsenemyjungle Monsterkillsenemyjungle	cspm Cspm	goldat10 Goldat10	oppgoldat10 Oppgoldat10	gdat10 Gdat10	goldat15 Goldat15	oppgoldat15 Oppgoldat15	gdat15 Gdat15	xpat10 Xpat10	oppxpat10 Oppxpat10	xpdat10 Xpdat10	csat10 Csat10	oppcsat10 Oppcsat10	csdat10 Csdat10	csat15 Csat15	oppcsat15 Oppcsat15	csdat15 Csdat15
	43740.286145833335	Blue	Top	Evi	DetonatioN FocusMe	Gnar	Qiyana	Gangplank	Akali	Elise	Olaf	26.53333333333333			4	4	7	22					3.8799833333333336		0.0376884422110552	1.092964824120603		9.717566666666666	1	2							13.588566666666669			1	10		23.779816666666665		1	11588	436.7336683417085	0.3120674332803705	0.2068443834548889	11	0.414572864321608	0.1057692307692307	4	0.1507537688442211	4	6	8407	184.05979899497484	8300	-0.1514476614699332	180	8	4	1	7.085427135678391	3078	3440	-362	4670	5468	-798	4530	5051	-521	76	90	-14	116	122	-6
1	43740.286145833335	Blue	Jungle	Steal	DetonatioN FocusMe	Ekko	Qiyana	Gangplank	Akali	Elise	Olaf	26.53333333333333		1	4	5	7	22					3.8799833333333336	0.0376884422110552	0.2638190954773869	1.092964824120603	1	9.717566666666666	1	2	1	2		1			13.588566666666669			1	10		23.779816666666665		1	7925	298.68090452261305	0.2134220235370156	0.1668623414906863	24	0.9045226130653266	0.2307692307692307	8	0.3015075376884422	11	13	7463	148.48190954773867	7360	-0.2967891235175007	35	96	76		4.9371859296482405	3684	4055	-371	4912	6278	-1366	3679	3928	-249	60	64	-4	88	105	-17
2	43740.286145833335	Blue	Middle	Ceros	DetonatioN FocusMe	Nocturne	Qiyana	Gangplank	Akali	Elise	Olaf	26.53333333333333		1	5	6	7	22					3.8799833333333336	0.0376884422110552	0.1130653266331658	1.092964824120603		9.717566666666666	1	2							13.588566666666669			1	10		23.779816666666665		1	7557	284.8115577889447	0.2035117011822368	0.2101056305218842	13	0.4899497487437185	0.125	1	0.0376884422110552	6	7	8484	186.9618090452261	7700	-0.2817294281729428	186	6	4		7.236180904522612	3926	3569	357	5487	6116	-629	4751	4533	218	88	85	3	131	150	-19
3	43740.286145833335	Blue	ADC	Yutapon	DetonatioN FocusMe	Lucian	Qiyana	Gangplank	Akali	Elise	Olaf	26.53333333333333		3	4	1	7	22	1				3.8799833333333336	0.1130653266331658	0.414572864321608	1.092964824120603		9.717566666666666	1	2							13.588566666666669			1	10		23.779816666666665		1	7369	277.7261306532663	0.1984488191096868	0.3007428866695467	9	0.3391959798994974	0.0865384615384615	7	0.2638190954773869	3	4	10624	267.6150753768844	10150	-0.2153846153846154	219	20	20		9.00753768844221	3579	3969	-390	5313	7142	-1829	3526	3532	-6	87	76	11	119	134	-15
4	43740.286145833335	Blue	Support	Gaeng	DetonatioN FocusMe	Thresh	Qiyana	Gangplank	Akali	Elise	Olaf	26.53333333333333		2	5	2	7	22				1	3.8799833333333336	0.0753768844221105		1.092964824120603		9.717566666666666	1	2							13.588566666666669			1	10		23.779816666666665		1	2694	101.53266331658293	0.0725500228906902	0.1154447578629937	47	1.7713567839195978	0.4519230769230769	8	0.3015075376884422	13	14	6249	102.72814070351755	5450	-0.296875	12	2	2		0.5276381909547738	2088	2394	-306	3163	4319	-1156	2731	2376	355	4	3	1	6	5	1
5	43740.286145833335	Red	Top	Vizicsacsi	Splyce	Kennen	Heimerdinger	Pantheon	Syndra	Cassiopeia	Kai'Sa	26.53333333333333	1	1	1	12	22	7					3.8799833333333336	0.0376884422110552		1.092964824120603		9.717566666666666	2	1					1	1	13.588566666666669	1	1	10	1	1	23.779816666666665	1		14478	545.6532663316583	0.2431479242241032	0.1596708113976688	15	0.5653266331658291	0.1875	8	0.3015075376884422	7	9	9759	235.0145728643216	9660	0.1514476614699332	182				6.85929648241206	3440	3078	362	5468	4670	798	5051	4530	521	90	76	14	122	116	6
6	43740.286145833335	Red	Jungle	Xerxe	Splyce	Hecarim	Heimerdinger	Pantheon	Syndra	Cassiopeia	Kai'Sa	26.53333333333333	1	7	1	6	22	7	1	1			3.8799833333333336	0.2638190954773869	0.0376884422110552	1.092964824120603		9.717566666666666	2	1	2	1	1	1	1	1	13.588566666666669	1	1	10	1	1	23.779816666666665	1		7782	293.2914572864321	0.1306932688432084	0.1998719708298338	9	0.3391959798994974	0.1125	7	0.2638190954773869	8	10	11329	294.1854271356784	9925	0.2967891235175007	18	128	78	12	5.50251256281407	4055	3684	371	6278	4912	1366	3928	3679	249	64	60	4	105	88	17
7	43740.286145833335	Red	Middle	Humanoid	Splyce	Ryze	Heimerdinger	Pantheon	Syndra	Cassiopeia	Kai'Sa	26.53333333333333	1	3	2	10	22	7					3.8799833333333336	0.1130653266331658	0.0376884422110552	1.092964824120603		9.717566666666666	2	1					1	1	13.588566666666669	1	1	10	1	1	23.779816666666665	1		12668	477.4371859296482	0.2127502351202472	0.2157219820964008	15	0.5653266331658291	0.1875	12	0.4522613065326633	6	7	11948	317.5145728643216	10225	0.2817294281729428	222	44	24	11	10.025125628140705	3569	3926	-357	6116	5487	629	4533	4751	-218	85	88	-3	150	131	19
8	43740.286145833335	Red	ADC	Kobbe	Splyce	Xayah	Heimerdinger	Pantheon	Syndra	Cassiopeia	Kai'Sa	26.53333333333333	1	11		5	22	7	3		1		3.8799833333333336	0.414572864321608	0.1130653266331658	1.092964824120603		9.717566666666666	2	1					1	1	13.588566666666669	1	1	10	1	1	23.779816666666665	1		20899	787.6507537688442	0.3509841461776165	0.3009894094270438	11	0.414572864321608	0.1375	11	0.414572864321608	3	4	15278	443.0170854271356	12600	0.2153846153846154	253	16	12		10.138190954773869	3969	3579	390	7142	5313	1829	3532	3526	6	76	87	-11	134	119	15
9	43740.286145833335	Red	Support	Norskeren	Splyce	Rakan	Heimerdinger	Pantheon	Syndra	Cassiopeia	Kai'Sa	26.53333333333333	1		3	18	22	7			1		3.8799833333333336		0.0753768844221105	1.092964824120603		9.717566666666666	2	1					1	1	13.588566666666669	1	1	10	1	1	23.779816666666665	1		3717	140.08793969849245	0.0624244256348246	0.1237458262490525	30	1.1306532663316582	0.375	13	0.4899497487437185	11	11	8356	182.13768844221104	7350	0.296875	13				0.4899497487437185	2394	2088	306	4319	3163	1156	2376	2731	-355	3	4	-1	5	6	-1


CREATE TABLE wc_players (
  "unnamed_0" BIGINT,
  "date" DOUBLE,
  "side" VARCHAR,
  "position" VARCHAR,
  "player" VARCHAR,
  "team" VARCHAR,
  "champion" VARCHAR,
  "ban1" VARCHAR,
  "ban2" VARCHAR,
  "ban3" VARCHAR,
  "ban4" VARCHAR,
  "ban5" VARCHAR,
  "gamelength" DOUBLE,
  "result" BIGINT,
  "k" BIGINT,
  "d" BIGINT,
  "a" BIGINT,
  "teamkills" BIGINT,
  "teamdeaths" BIGINT,
  "doubles" BIGINT,
  "triples" BIGINT,
  "quadras" BIGINT,
  "pentas" BIGINT,
  "fb" BIGINT,
  "fbassist" BIGINT,
  "fbvictim" BIGINT,
  "fbtime" DOUBLE,
  "kpm" DOUBLE,
  "okpm" DOUBLE,
  "ckpm" DOUBLE,
  "fd" BIGINT,
  "fdtime" DOUBLE,
  "teamdragkills" BIGINT,
  "oppdragkills" BIGINT,
  "elementals" BIGINT,
  "oppelementals" BIGINT,
  "firedrakes" BIGINT,
  "waterdrakes" BIGINT,
  "earthdrakes" BIGINT,
  "airdrakes" BIGINT,
  "elders" BIGINT,
  "oppelders" BIGINT,
  "herald" BIGINT,
  "heraldtime" VARCHAR,
  "ft" BIGINT,
  "fttime" DOUBLE,
  "firstmidouter" BIGINT,
  "firsttothreetowers" BIGINT,
  "teamtowerkills" BIGINT,
  "opptowerkills" BIGINT,
  "fbaron" DOUBLE,
  "fbarontime" DOUBLE,
  "teambaronkills" BIGINT,
  "oppbaronkills" BIGINT,
  "dmgtochamps" BIGINT,
  "dmgtochampsperminute" DOUBLE,
  "dmgshare" DOUBLE,
  "earnedgoldshare" DOUBLE,
  "wards" BIGINT,
  "wpm" DOUBLE,
  "wardshare" DOUBLE,
  "wardkills" BIGINT,
  "wcpm" DOUBLE,
  "visionwards" BIGINT,
  "visionwardbuys" BIGINT,
  "visiblewardclearrate" VARCHAR,
  "invisiblewardclearrate" VARCHAR,
  "totalgold" BIGINT,
  "earnedgpm" DOUBLE,
  "goldspent" BIGINT,
  "gspd" DOUBLE,
  "minionkills" BIGINT,
  "monsterkills" BIGINT,
  "monsterkillsownjungle" BIGINT,
  "monsterkillsenemyjungle" BIGINT,
  "cspm" DOUBLE,
  "goldat10" BIGINT,
  "oppgoldat10" BIGINT,
  "gdat10" BIGINT,
  "goldat15" BIGINT,
  "oppgoldat15" BIGINT,
  "gdat15" BIGINT,
  "xpat10" BIGINT,
  "oppxpat10" BIGINT,
  "xpdat10" BIGINT,
  "csat10" BIGINT,
  "oppcsat10" BIGINT,
  "csdat10" BIGINT,
  "csat15" BIGINT,
  "oppcsat15" BIGINT,
  "csdat15" BIGINT
);