Overwatch League Stats Lab
OWL2021 - Map and Player Statistics
@kaggle.sherrytp_overwatch_league_stats_lab
OWL2021 - Map and Player Statistics
@kaggle.sherrytp_overwatch_league_stats_lab
Overwatch is a 6v6 FPS (first-person shooter) team game with great variety between heroes who can be played as. Overwatch League (OWL) is the professional esports league of Overwatch. When watching the OWL matches this year, I noticed the power-rankings and predictive statistics by IBM Watson extremely intriguing, so I determined to introduce the datasets into Kaggle. I, myself, really want to replicate the predictions and rankings, then testing with the stats lab.
The datasets include players, head-to-head match-ups, and maps. The player historical statistics should contain OWL games from 2018 till now. It's centered around each player, and player's picked hero, its team name, performance, match IDs, etc.
Overwatch League Stats Lab has updated and downloadable csv files. And here are some interesting and inspiring questions to look at: https://overwatchleague.com/en-us/news/23303225.
Other than the power rankings and outcome predictions, I plan to look at teamfight stats, first elimination, and first death to compare the team's power.
For Players:
For Heroes:
For Matches:
CREATE TABLE match_map_stats (
"round_start_time" TIMESTAMP,
"round_end_time" TIMESTAMP,
"stage" VARCHAR,
"match_id" BIGINT,
"game_number" BIGINT,
"match_winner" VARCHAR,
"map_winner" VARCHAR,
"map_loser" VARCHAR,
"map_name" VARCHAR,
"map_round" BIGINT,
"winning_team_final_map_score" BIGINT,
"losing_team_final_map_score" BIGINT,
"control_round_name" VARCHAR,
"attacker" VARCHAR,
"defender" VARCHAR,
"team_one_name" VARCHAR,
"team_two_name" VARCHAR,
"attacker_payload_distance" DOUBLE,
"defender_payload_distance" DOUBLE,
"attacker_time_banked" DOUBLE,
"defender_time_banked" DOUBLE,
"attacker_control_perecent" DOUBLE,
"defender_control_perecent" DOUBLE,
"attacker_round_end_score" BIGINT,
"defender_round_end_score" BIGINT
);CREATE TABLE phs_2021_1 (
"start_time" TIMESTAMP,
"esports_match_id" BIGINT,
"tournament_title" VARCHAR,
"map_type" VARCHAR,
"map_name" VARCHAR,
"player_name" VARCHAR,
"team_name" VARCHAR,
"stat_name" VARCHAR,
"hero_name" VARCHAR,
"stat_amount" DOUBLE
);Anyone who has the link will be able to view this.