RTCW stats analysis for years 2020 and 2021 in NA

Load stats from public repository

cache files locally as they will never change again

Inspect the dataset

What data looks like

More meaningful column selection

Clean the dataset

Some cleaning steps I have discovered mostly after the fact

Analysis

Set the stage - who are the players and what are the maps?

Player win percentages

Here we probably need to state that the games are handpicked/adjusted for fairness and those with higher percentages are probably performing better than expected, people down the middle are just right, and the bottom is not shown.

Player wins by map

Least favorite maps per player

Most effective maps per player

Heatmap graph

People we haven't seen in a while

Shortest rounds ever played

Shortest rounds per map and Average map durations

Best individual performance in any match

Blank class is either engineer or (most likely) a medic

Best individual performance in a 6v6

Biggest match ever

Maps with their fullhold percentages

Damage throughput and KDR per player over time

This is an attempt to see improvement in players over time

Most improved players by KDR

Most improved players by Damage Given per Minute

Various metrics averages

KDR distribution

Damange per Kill

Damage taken per death

Ratio of suicides to deaths

Gameplay score = score - kills, TKs, suicides.