Dota 2 - Pro Players Matches Results 2019 ~ 2021
Analitical Base Table to data scientist's studies.
@kaggle.teocalvo_dota2_pro_players_matches_2019_202106
Analitical Base Table to data scientist's studies.
@kaggle.teocalvo_dota2_pro_players_matches_2019_202106
CREATE TABLE tb_pro_players_matches (
"match_id" BIGINT,
"dt_match" VARCHAR,
"radiant_win" BOOLEAN,
"recencia_r" DOUBLE,
"freq_r" DOUBLE,
"win_pct_r" DOUBLE,
"duration_avg_win_r" DOUBLE,
"duration_avg_lose_r" DOUBLE,
"actions_per_min_avg_r" DOUBLE,
"ancient_kills_avg_r" DOUBLE,
"assists_avg_r" DOUBLE,
"buyback_count_avg_r" DOUBLE,
"courier_kills_avg_r" DOUBLE,
"deaths_avg_r" DOUBLE,
"denies_avg_r" DOUBLE,
"firstblood_claimed_avg_r" DOUBLE,
"gold_avg_r" DOUBLE,
"gold_per_min_avg_r" DOUBLE,
"gold_spent_avg_r" DOUBLE,
"hero_damage_avg_r" DOUBLE,
"hero_healing_avg_r" DOUBLE,
"hero_kills_avg_r" DOUBLE,
"isradiant_avg_r" VARCHAR,
"kda_avg_r" DOUBLE,
"kills_per_min_avg_r" DOUBLE,
"lane_efficiency_avg_r" DOUBLE,
"lane_kills_avg_r" DOUBLE,
"last_hits_avg_r" DOUBLE,
"level_avg_r" DOUBLE,
"necronomicon_kills_avg_r" DOUBLE,
"neutral_kills_avg_r" DOUBLE,
"observer_kills_avg_r" DOUBLE,
"observer_uses_avg_r" DOUBLE,
"purchase_tpscroll_avg_r" DOUBLE,
"roshan_kills_avg_r" DOUBLE,
"sentry_kills_avg_r" DOUBLE,
"sentry_uses_avg_r" DOUBLE,
"total_gold_avg_r" DOUBLE,
"total_xp_avg_r" DOUBLE,
"tower_damage_avg_r" DOUBLE,
"tower_kills_avg_r" DOUBLE,
"xp_per_min_avg_r" DOUBLE,
"hero_1_avg_r" DOUBLE,
"hero_2_avg_r" DOUBLE,
"hero_3_avg_r" DOUBLE,
"hero_4_avg_r" DOUBLE,
"hero_5_avg_r" DOUBLE,
"hero_6_avg_r" DOUBLE,
"hero_7_avg_r" DOUBLE,
"hero_8_avg_r" DOUBLE,
"hero_9_avg_r" DOUBLE,
"hero_10_avg_r" DOUBLE,
"hero_11_avg_r" DOUBLE,
"hero_12_avg_r" DOUBLE,
"hero_13_avg_r" DOUBLE,
"hero_14_avg_r" DOUBLE,
"hero_15_avg_r" DOUBLE,
"hero_16_avg_r" DOUBLE,
"hero_17_avg_r" DOUBLE,
"hero_18_avg_r" DOUBLE,
"hero_19_avg_r" DOUBLE,
"hero_20_avg_r" DOUBLE,
"hero_21_avg_r" DOUBLE,
"hero_22_avg_r" DOUBLE,
"hero_23_avg_r" DOUBLE,
"hero_25_avg_r" DOUBLE,
"hero_26_avg_r" DOUBLE,
"hero_27_avg_r" DOUBLE,
"hero_28_avg_r" DOUBLE,
"hero_29_avg_r" DOUBLE,
"hero_30_avg_r" DOUBLE,
"hero_31_avg_r" DOUBLE,
"hero_32_avg_r" DOUBLE,
"hero_33_avg_r" DOUBLE,
"hero_34_avg_r" DOUBLE,
"hero_35_avg_r" DOUBLE,
"hero_36_avg_r" DOUBLE,
"hero_37_avg_r" DOUBLE,
"hero_38_avg_r" DOUBLE,
"hero_39_avg_r" DOUBLE,
"hero_40_avg_r" DOUBLE,
"hero_41_avg_r" DOUBLE,
"hero_42_avg_r" DOUBLE,
"hero_43_avg_r" DOUBLE,
"hero_44_avg_r" DOUBLE,
"hero_45_avg_r" DOUBLE,
"hero_46_avg_r" DOUBLE,
"hero_47_avg_r" DOUBLE,
"hero_48_avg_r" DOUBLE,
"hero_49_avg_r" DOUBLE,
"hero_50_avg_r" DOUBLE,
"hero_51_avg_r" DOUBLE,
"hero_52_avg_r" DOUBLE,
"hero_53_avg_r" DOUBLE,
"hero_54_avg_r" DOUBLE,
"hero_55_avg_r" DOUBLE,
"hero_56_avg_r" DOUBLE,
"hero_57_avg_r" DOUBLE,
"hero_58_avg_r" DOUBLE,
"hero_59_avg_r" DOUBLE
);
Anyone who has the link will be able to view this.