Context

data mining

Content

the data set contains champion ID and there positions

Inspiration

how to know which champion has won using the data set

Tables

Finalproject Test

@kaggle.pravallika30_kaggel_champs.finalproject_test

2.16 MB
118798 rows
14 columns


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
);

Finalproject Training

@kaggle.pravallika30_kaggel_champs.finalproject_training

9.89 MB
601300 rows
15 columns


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
);