Kaggel Champs

To find out how is the winner in league of legends

@kaggle.pravallika30_kaggel_champs

Table List

2 tables(12.05 MB)

Finalproject Training

@kaggle.pravallika30_kaggel_champs.finalproject_training

9.89 MB
601300 rows
15 columns

recordid RecordID	winner Winner	championid ChampionId	match_id Match Id	item2 Item2	item3 Item3	item0 Item0	item1 Item1	item6 Item6	spell2id Spell2Id	item4 Item4	item5 Item5	teamid TeamId	spell1id Spell1Id	summoner_id Summoner Id
	False	432	1758132392	3143	3117	3069	3190	3340	3	2049	3025	200	4	21852930
1	False	432	1758132970	2049	3270	3092	3190	3341	3	3024		200	4	40509863
2	False	432	1758142937	3023	3027	2049	3069	3364	4	3117	3067	100	3	23323092
3	False	432	1758144918	2049	3024	3092	1001	3341	3			200	4	23734765
4	False	432	1758145151	3190	2049	3098	3270	3364	3	2043	1052	100	4	19527594
5	False	432	1758145396	2043	2044	3069	2049	3341	4	3117		200	3	23805899
6	True	432	1758145920	2049	3117	3023	3092	3341	3	3027	3057	100	4	22253266
7	False	432	1758145930	3069	2043	2049	2004	3341	4		3117	200	3	37463283
8	False	432	1758146101	2049	3117	3092	3024	3341	14	3082		100	4	26415852
9	False	432	1758146611	2049	3270	3092	3190	3341	3			200	4	23140989


CREATE TABLE finalproject_training (
  "recordid" BIGINT,
  "winner" VARCHAR,
  "championid" BIGINT,
  "match_id" BIGINT,
  "item2" BIGINT,
  "item3" BIGINT,
  "item0" BIGINT,
  "item1" VARCHAR,
  "item6" BIGINT,
  "spell2id" BIGINT,
  "item4" BIGINT,
  "item5" BIGINT,
  "teamid" BIGINT,
  "spell1id" BIGINT,
  "summoner_id" BIGINT
);