Name: Dota2 Games Results
Creator: Kaggle
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

Dota2 Games Results

Dota 2 is a popular computer game with two teams of 5 players. At the start of the game each player chooses a unique hero with different strengths and weaknesses. The dataset is reasonably sparse as only 10 of 113 possible heroes are chosen in a given game. All games were played in a space of 2 hours on the 13th of August, 2016

The data was collected using: https://gist.github.com/da-steve101/1a7ae319448db431715bd75391a66e1b

Attribute Information

Each row of the dataset is a single game with the following features (in the order in the vector):

Team won the game (1 or -1)
Cluster ID (related to location)
Game mode (eg All Pick)
Game type (eg. Ranked)
- end: Each element is an indicator for a hero. Value of 1 indicates that a player from team '1' played as that hero and '-1' for the other team. Hero can be selected by only one player each game. This means that each row has five '1' and five '-1' values.

The hero to id mapping can be found here: https://github.com/kronusme/dota2-api/blob/master/data/heroes.json

Tables

Dota2test

@kaggle.joebeachcapital_dota2_games_results.dota2test

263.89 KB
10293 rows
117 columns


CREATE TABLE dota2test (
  "n__1" BIGINT,
  "n_223" BIGINT,
  "n_8" BIGINT,
  "n_2" BIGINT,
  "n_0" BIGINT,
  "n__1_1" BIGINT,
  "n_0_1" BIGINT,
  "n_0_2" BIGINT,
  "n_0_3" BIGINT,
  "n_0_4" BIGINT,
  "n_0_5" BIGINT,
  "n_0_6" BIGINT,
  "n_1" BIGINT,
  "n_0_7" BIGINT,
  "n_0_8" BIGINT,
  "n_0_9" BIGINT,
  "n_0_10" BIGINT,
  "n_0_11" BIGINT,
  "n_0_12" BIGINT,
  "n_0_13" BIGINT,
  "n_0_14" BIGINT,
  "n_0_15" BIGINT,
  "n_0_16" BIGINT,
  "n_0_17" BIGINT,
  "n_0_18" BIGINT,
  "n_0_19" BIGINT,
  "n_0_20" BIGINT,
  "n_0_21" BIGINT,
  "n_0_22" BIGINT,
  "n_1_1" BIGINT,
  "n_0_23" BIGINT,
  "n_0_24" BIGINT,
  "n_0_25" BIGINT,
  "n_0_26" BIGINT,
  "n_0_27" BIGINT,
  "n_0_28" BIGINT,
  "n_0_29" BIGINT,
  "n_0_30" BIGINT,
  "n_0_31" BIGINT,
  "n_0_32" BIGINT,
  "n_0_33" BIGINT,
  "n_0_34" BIGINT,
  "n_0_35" BIGINT,
  "n_1_2" BIGINT,
  "n_0_36" BIGINT,
  "n_0_37" BIGINT,
  "n_0_38" BIGINT,
  "n__1_2" BIGINT,
  "n_0_39" BIGINT,
  "n_0_40" BIGINT,
  "n_0_41" BIGINT,
  "n_0_42" BIGINT,
  "n_0_43" BIGINT,
  "n_0_44" BIGINT,
  "n_0_45" BIGINT,
  "n_0_46" BIGINT,
  "n_0_47" BIGINT,
  "n_0_48" BIGINT,
  "n_1_3" BIGINT,
  "n_0_49" BIGINT,
  "n_0_50" BIGINT,
  "n_0_51" BIGINT,
  "n__1_3" BIGINT,
  "n_0_52" BIGINT,
  "n_0_53" BIGINT,
  "n_0_54" BIGINT,
  "n_0_55" BIGINT,
  "n_0_56" BIGINT,
  "n_0_57" BIGINT,
  "n_0_58" BIGINT,
  "n__1_4" BIGINT,
  "n_0_59" BIGINT,
  "n_0_60" BIGINT,
  "n_0_61" BIGINT,
  "n_0_62" BIGINT,
  "n_1_4" BIGINT,
  "n_0_63" BIGINT,
  "n_0_64" BIGINT,
  "n_0_65" BIGINT,
  "n_0_66" BIGINT,
  "n_0_67" BIGINT,
  "n_0_68" BIGINT,
  "n_0_69" BIGINT,
  "n_0_70" BIGINT,
  "n_0_71" BIGINT,
  "n_0_72" BIGINT,
  "n_0_73" BIGINT,
  "n_0_74" BIGINT,
  "n_0_75" BIGINT,
  "n_0_76" BIGINT,
  "n_0_77" BIGINT,
  "n_0_78" BIGINT,
  "n_0_79" BIGINT,
  "n_0_80" BIGINT,
  "n_0_81" BIGINT,
  "n_0_82" BIGINT,
  "n_0_83" BIGINT,
  "n_0_84" BIGINT,
  "n_0_85" BIGINT,
  "n_0_86" BIGINT
);

Dota2train

@kaggle.joebeachcapital_dota2_games_results.dota2train

1.59 MB
92649 rows
117 columns


CREATE TABLE dota2train (
  "n__1" BIGINT,
  "n_223" BIGINT,
  "n_2" BIGINT,
  "n_2_1" BIGINT,
  "n_0" BIGINT,
  "n_0_1" BIGINT,
  "n_0_2" BIGINT,
  "n_0_3" BIGINT,
  "n_0_4" BIGINT,
  "n_0_5" BIGINT,
  "n_0_6" BIGINT,
  "n_0_7" BIGINT,
  "n_0_8" BIGINT,
  "n_1" BIGINT,
  "n_0_9" BIGINT,
  "n_0_10" BIGINT,
  "n_0_11" BIGINT,
  "n_1_1" BIGINT,
  "n_0_12" BIGINT,
  "n_0_13" BIGINT,
  "n_0_14" BIGINT,
  "n__1_1" BIGINT,
  "n_0_15" BIGINT,
  "n_0_16" BIGINT,
  "n_0_17" BIGINT,
  "n__1_2" BIGINT,
  "n_0_18" BIGINT,
  "n_0_19" BIGINT,
  "n_1_2" BIGINT,
  "n_0_20" BIGINT,
  "n_0_21" BIGINT,
  "n_1_3" BIGINT,
  "n_0_22" BIGINT,
  "n_0_23" BIGINT,
  "n_0_24" BIGINT,
  "n_1_4" BIGINT,
  "n_0_25" BIGINT,
  "n_0_26" BIGINT,
  "n_0_27" BIGINT,
  "n_0_28" BIGINT,
  "n_0_29" BIGINT,
  "n__1_3" BIGINT,
  "n_0_30" BIGINT,
  "n_0_31" BIGINT,
  "n_0_32" BIGINT,
  "n_0_33" BIGINT,
  "n_0_34" BIGINT,
  "n_0_35" BIGINT,
  "n_0_36" BIGINT,
  "n_0_37" BIGINT,
  "n_0_38" BIGINT,
  "n_0_39" BIGINT,
  "n_0_40" BIGINT,
  "n_0_41" BIGINT,
  "n_0_42" BIGINT,
  "n_0_43" BIGINT,
  "n_0_44" BIGINT,
  "n_0_45" BIGINT,
  "n_0_46" BIGINT,
  "n_0_47" BIGINT,
  "n_0_48" BIGINT,
  "n_0_49" BIGINT,
  "n_0_50" BIGINT,
  "n_0_51" BIGINT,
  "n_0_52" BIGINT,
  "n_0_53" BIGINT,
  "n_0_54" BIGINT,
  "n_0_55" BIGINT,
  "n_0_56" BIGINT,
  "n_0_57" BIGINT,
  "n_0_58" BIGINT,
  "n_0_59" BIGINT,
  "n_0_60" BIGINT,
  "n_0_61" BIGINT,
  "n_0_62" BIGINT,
  "n_0_63" BIGINT,
  "n_0_64" BIGINT,
  "n__1_4" BIGINT,
  "n_0_65" BIGINT,
  "n_0_66" BIGINT,
  "n_0_67" BIGINT,
  "n_0_68" BIGINT,
  "n_0_69" BIGINT,
  "n_0_70" BIGINT,
  "n_0_71" BIGINT,
  "n_0_72" BIGINT,
  "n_0_73" BIGINT,
  "n_0_74" BIGINT,
  "n_0_75" BIGINT,
  "n_0_76" BIGINT,
  "n_0_77" BIGINT,
  "n__1_5" BIGINT,
  "n_0_78" BIGINT,
  "n_0_79" BIGINT,
  "n_0_80" BIGINT,
  "n_0_81" BIGINT,
  "n_0_82" BIGINT,
  "n_0_83" BIGINT,
  "n_0_84" BIGINT,
  "n_0_85" BIGINT
);