League Of Legends Team Compositions Dataset

Team Champion composition (League of Legends)

@kaggle.luisfmcuriel_league_of_legends_team_compositions_dataset

Table List

1 table(870.23 KB)

Lol Matchs

@kaggle.luisfmcuriel_league_of_legends_team_compositions_dataset.lol_matchs

870.23 KB
34678 rows
303 columns
Only the first 100 columns are shown

unnamed_0 Unnamed: 0	aatrox Aatrox	ahri Ahri	akali Akali	alistar Alistar	amumu Amumu	anivia Anivia	annie Annie	aphelios Aphelios	ashe Ashe	aurelion_sol Aurelion Sol	azir Azir	bard Bard	blitzcrank Blitzcrank	brand Brand	braum Braum	caitlyn Caitlyn	camille Camille	cassiopeia Cassiopeia	cho_gath Cho'Gath	corki Corki	darius Darius	diana Diana	dr_mundo Dr. Mundo	draven Draven	ekko Ekko	elise Elise	evelynn Evelynn	ezreal Ezreal	fiddlesticks Fiddlesticks	fiora Fiora	fizz Fizz	galio Galio	gangplank Gangplank	garen Garen	gnar Gnar	gragas Gragas	graves Graves	hecarim Hecarim	heimerdinger Heimerdinger	illaoi Illaoi	irelia Irelia	ivern Ivern	janna Janna	jarvan_iv Jarvan IV	jax Jax	jayce Jayce	jhin Jhin	jinx Jinx	kai_sa Kai'Sa	kalista Kalista	karma Karma	karthus Karthus	kassadin Kassadin	katarina Katarina	kayle Kayle	kayn Kayn	kennen Kennen	kha_zix Kha'Zix	kindred Kindred	kled Kled	kog_maw Kog'Maw	leblanc LeBlanc	lee_sin Lee Sin	leona Leona	lillia Lillia	lissandra Lissandra	lucian Lucian	lulu Lulu	lux Lux	malphite Malphite	malzahar Malzahar	maokai Maokai	master_yi Master Yi	miss_fortune Miss Fortune	mordekaiser Mordekaiser	morgana Morgana	nami Nami	nasus Nasus	nautilus Nautilus	neeko Neeko	nidalee Nidalee	nocturne Nocturne	nunu_willump Nunu & Willump	olaf Olaf	orianna Orianna	ornn Ornn	pantheon Pantheon	poppy Poppy	pyke Pyke	qiyana Qiyana	quinn Quinn	rakan Rakan	rammus Rammus	rek_sai Rek'Sai	renekton Renekton	rengar Rengar	riven Riven	rumble Rumble	ryze Ryze	sejuani Sejuani	senna Senna	sett Sett	shaco Shaco	shen Shen	shyvana Shyvana	singed Singed	sion Sion	sivir Sivir	skarner Skarner	sona Sona	soraka Soraka	swain Swain	sylas Sylas	syndra Syndra	tahm_kench Tahm Kench	taliyah Taliyah	talon Talon	taric Taric	teemo Teemo	thresh Thresh	tristana Tristana	trundle Trundle	tryndamere Tryndamere	twisted_fate Twisted Fate	twitch Twitch	udyr Udyr	urgot Urgot	varus Varus	vayne Vayne	veigar Veigar	vel_koz Vel'Koz	vi Vi	viktor Viktor	vladimir Vladimir	volibear Volibear	warwick Warwick	wukong Wukong	xayah Xayah	xerath Xerath	xin_zhao Xin Zhao	yasuo Yasuo	yone Yone	yorick Yorick	yuumi Yuumi	zac Zac	zed Zed	ziggs Ziggs	zilean Zilean	zoe Zoe	zyra Zyra	aatrox_1 Aatrox.1	ahri_1 Ahri.1	akali_1 Akali.1	alistar_1 Alistar.1	amumu_1 Amumu.1	anivia_1 Anivia.1	annie_1 Annie.1	aphelios_1 Aphelios.1	ashe_1 Ashe.1	aurelion_sol_1 Aurelion Sol.1	azir_1 Azir.1	bard_1 Bard.1	blitzcrank_1 Blitzcrank.1	brand_1 Brand.1	braum_1 Braum.1	caitlyn_1 Caitlyn.1	camille_1 Camille.1	cassiopeia_1 Cassiopeia.1	cho_gath_1 Cho'Gath.1	corki_1 Corki.1	darius_1 Darius.1	diana_1 Diana.1	dr_mundo_1 Dr. Mundo.1	draven_1 Draven.1	ekko_1 Ekko.1	elise_1 Elise.1	evelynn_1 Evelynn.1	ezreal_1 Ezreal.1	fiddlesticks_1 Fiddlesticks.1	fiora_1 Fiora.1	fizz_1 Fizz.1	galio_1 Galio.1	gangplank_1 Gangplank.1	garen_1 Garen.1	gnar_1 Gnar.1	gragas_1 Gragas.1	graves_1 Graves.1	hecarim_1 Hecarim.1	heimerdinger_1 Heimerdinger.1	illaoi_1 Illaoi.1	irelia_1 Irelia.1	ivern_1 Ivern.1	janna_1 Janna.1	jarvan_iv_1 Jarvan IV.1	jax_1 Jax.1	jayce_1 Jayce.1	jhin_1 Jhin.1	jinx_1 Jinx.1	kai_sa_1 Kai'Sa.1	kalista_1 Kalista.1	karma_1 Karma.1	karthus_1 Karthus.1	kassadin_1 Kassadin.1	katarina_1 Katarina.1	kayle_1 Kayle.1	kayn_1 Kayn.1	kennen_1 Kennen.1	kha_zix_1 Kha'Zix.1	kindred_1 Kindred.1	kled_1 Kled.1	kog_maw_1 Kog'Maw.1	leblanc_1 LeBlanc.1	lee_sin_1 Lee Sin.1	leona_1 Leona.1	lillia_1 Lillia.1	lissandra_1 Lissandra.1	lucian_1 Lucian.1	lulu_1 Lulu.1	lux_1 Lux.1	malphite_1 Malphite.1	malzahar_1 Malzahar.1	maokai_1 Maokai.1	master_yi_1 Master Yi.1	miss_fortune_1 Miss Fortune.1	mordekaiser_1 Mordekaiser.1	morgana_1 Morgana.1	nami_1 Nami.1	nasus_1 Nasus.1	nautilus_1 Nautilus.1	neeko_1 Neeko.1	nidalee_1 Nidalee.1	nocturne_1 Nocturne.1	nunu_willump_1 Nunu & Willump.1	olaf_1 Olaf.1	orianna_1 Orianna.1	ornn_1 Ornn.1	pantheon_1 Pantheon.1	poppy_1 Poppy.1	pyke_1 Pyke.1	qiyana_1 Qiyana.1	quinn_1 Quinn.1	rakan_1 Rakan.1	rammus_1 Rammus.1	rek_sai_1 Rek'Sai.1	renekton_1 Renekton.1	rengar_1 Rengar.1	riven_1 Riven.1	rumble_1 Rumble.1	ryze_1 Ryze.1	sejuani_1 Sejuani.1	senna_1 Senna.1	sett_1 Sett.1	shaco_1 Shaco.1	shen_1 Shen.1	shyvana_1 Shyvana.1	singed_1 Singed.1	sion_1 Sion.1	sivir_1 Sivir.1	skarner_1 Skarner.1	sona_1 Sona.1	soraka_1 Soraka.1	swain_1 Swain.1	sylas_1 Sylas.1	syndra_1 Syndra.1	tahm_kench_1 Tahm Kench.1	taliyah_1 Taliyah.1	talon_1 Talon.1	taric_1 Taric.1	teemo_1 Teemo.1	thresh_1 Thresh.1	tristana_1 Tristana.1	trundle_1 Trundle.1	tryndamere_1 Tryndamere.1	twisted_fate_1 Twisted Fate.1	twitch_1 Twitch.1	udyr_1 Udyr.1	urgot_1 Urgot.1	varus_1 Varus.1	vayne_1 Vayne.1	veigar_1 Veigar.1	vel_koz_1 Vel'Koz.1	vi_1 Vi.1	viktor_1 Viktor.1	vladimir_1 Vladimir.1	volibear_1 Volibear.1	warwick_1 Warwick.1	wukong_1 Wukong.1	xayah_1 Xayah.1	xerath_1 Xerath.1	xin_zhao_1 Xin Zhao.1	yasuo_1 Yasuo.1	yone_1 Yone.1	yorick_1 Yorick.1	yuumi_1 Yuumi.1	zac_1 Zac.1	zed_1 Zed.1	ziggs_1 Ziggs.1	zilean_1 Zilean.1	zoe_1 Zoe.1	zyra_1 Zyra.1	team1 Team1	team2 Team2
	1																																															1	1								1
1																															1																	1										1
2																																																1	1									1
3																						1																											1																											1						1
4																												1																											1
5																																																1	1
6																																																1
7																												1																				1																										1
8	1																																																																									1
9																																																																																		1


CREATE TABLE lol_matchs (
  "unnamed_0" BIGINT,
  "aatrox" DOUBLE,
  "ahri" DOUBLE,
  "akali" DOUBLE,
  "alistar" DOUBLE,
  "amumu" DOUBLE,
  "anivia" DOUBLE,
  "annie" DOUBLE,
  "aphelios" DOUBLE,
  "ashe" DOUBLE,
  "aurelion_sol" DOUBLE,
  "azir" DOUBLE,
  "bard" DOUBLE,
  "blitzcrank" DOUBLE,
  "brand" DOUBLE,
  "braum" DOUBLE,
  "caitlyn" DOUBLE,
  "camille" DOUBLE,
  "cassiopeia" DOUBLE,
  "cho_gath" DOUBLE,
  "corki" DOUBLE,
  "darius" DOUBLE,
  "diana" DOUBLE,
  "dr_mundo" DOUBLE,
  "draven" DOUBLE,
  "ekko" DOUBLE,
  "elise" DOUBLE,
  "evelynn" DOUBLE,
  "ezreal" DOUBLE,
  "fiddlesticks" DOUBLE,
  "fiora" DOUBLE,
  "fizz" DOUBLE,
  "galio" DOUBLE,
  "gangplank" DOUBLE,
  "garen" DOUBLE,
  "gnar" DOUBLE,
  "gragas" DOUBLE,
  "graves" DOUBLE,
  "hecarim" DOUBLE,
  "heimerdinger" DOUBLE,
  "illaoi" DOUBLE,
  "irelia" DOUBLE,
  "ivern" DOUBLE,
  "janna" DOUBLE,
  "jarvan_iv" DOUBLE,
  "jax" DOUBLE,
  "jayce" DOUBLE,
  "jhin" DOUBLE,
  "jinx" DOUBLE,
  "kai_sa" DOUBLE,
  "kalista" DOUBLE,
  "karma" DOUBLE,
  "karthus" DOUBLE,
  "kassadin" DOUBLE,
  "katarina" DOUBLE,
  "kayle" DOUBLE,
  "kayn" DOUBLE,
  "kennen" DOUBLE,
  "kha_zix" DOUBLE,
  "kindred" DOUBLE,
  "kled" DOUBLE,
  "kog_maw" DOUBLE,
  "leblanc" DOUBLE,
  "lee_sin" DOUBLE,
  "leona" DOUBLE,
  "lillia" DOUBLE,
  "lissandra" DOUBLE,
  "lucian" DOUBLE,
  "lulu" DOUBLE,
  "lux" DOUBLE,
  "malphite" DOUBLE,
  "malzahar" DOUBLE,
  "maokai" DOUBLE,
  "master_yi" DOUBLE,
  "miss_fortune" DOUBLE,
  "mordekaiser" DOUBLE,
  "morgana" DOUBLE,
  "nami" DOUBLE,
  "nasus" DOUBLE,
  "nautilus" DOUBLE,
  "neeko" DOUBLE,
  "nidalee" DOUBLE,
  "nocturne" DOUBLE,
  "nunu_willump" DOUBLE,
  "olaf" DOUBLE,
  "orianna" DOUBLE,
  "ornn" DOUBLE,
  "pantheon" DOUBLE,
  "poppy" DOUBLE,
  "pyke" DOUBLE,
  "qiyana" DOUBLE,
  "quinn" DOUBLE,
  "rakan" DOUBLE,
  "rammus" DOUBLE,
  "rek_sai" DOUBLE,
  "renekton" DOUBLE,
  "rengar" DOUBLE,
  "riven" DOUBLE,
  "rumble" DOUBLE,
  "ryze" DOUBLE
);

Share link

Anyone who has the link will be able to view this.