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 Test

@kaggle.pravallika30_kaggel_champs.finalproject_test

2.16 MB
118798 rows
14 columns

recordid RecordID	summoner_id Summoner Id	championid ChampionId	match_id Match Id	item2 Item2	item3 Item3	item0 Item0	item1 Item1	item6 Item6	item4 Item4	item5 Item5	teamid TeamId	spell1id Spell1Id	spell2id Spell2Id
	425188	432	174745678	3222	3117	3303	2049	3364	3110		200	4	14
1	20000114	432	1758134998	3800	3083	2049	3069	3340	3047	1033	100	4	14
2	26184782	432	1758135343	2049	3270	3069	2043	3341	3110	1033	100	4	3
3	22203011	432	1758136632	3190	2043	3092	3222	3364	3270	2045	100	3	4
4	23035866	432	1758145442	2049	3096		3190	3341	3117	3114	100	3	4
5	26213160	432	1758170881	3222	3117	3303	2049	3341	2004		100	4	3
6	20337628	432	1758183814	1028	2049	3092	3067	3341	1033	3280	100	14	4
7	20086216	432	1758186647	3143	3270	2049	3190	3341	3098	3110	100	4	3
8	24423408	432	1758189703	3800	3270	2049	3222	3364	3110	3105	100	3	4
9	24270479	432	1758193521	3098	3110	3190	3100	3364	3117	2045	200	4	3


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