steam analysis

Steam Game Platform Analysis

Group T

Wu, Qiwen

Wong, Chi Tin

Guo, Ningyan

She, Haoyu

What is steam?

Steam is a digital distribution platform developed by Valve Corporation, which offers digital rights management (DRM), multiplayer gaming, video streaming and social networking services.

dataset from steam API


{
   "578080":{
      "appid":578080,
      "name":"PLAYERUNKNOWN'S BATTLEGROUNDS",
      "developer":"PUBG Corporation",
      "publisher":"PUBG Corporation",
      "score_rank":12,
      "positive":393425,
      "negative":318777,
      "userscore":54,
      "owners":33094342,
      "owners_variance":172959,
      "players_forever":24139352,
      "players_forever_variance":149105,
      "players_2weeks":14648589,
      "players_2weeks_variance":117287,
      "average_forever":13527,
      "average_2weeks":1148,
      "median_forever":8462,
      "median_2weeks":688,
      "price":"2999"
   }
}

Data Preprocess

	
import json
import csv
f = open('rgame.json')
data = json.load(f)
keys = data.keys()
f = open("test.csv", "w")
f1 = csv.writer(f)
f1.writerow(["appid", "name", "developer", "publisher", "score_rank","positive","negative","userscore","owners","owners_variance","players_forever","players_forever_variance","players_2weeks","players_2weeks_variance","average_forever","average_2weeks","median_forever","median_2weeks","price"])

for i in keys:
    f1.writerow([data[tmp]["appid"],
                 data[tmp]["name"],
                 data[tmp]["developer"],
                 data[tmp]["publisher"],
                 data[tmp]["score_rank"],
                 data[tmp]["positive"],
                 data[tmp]["negative"],
                 data[tmp]["userscore"],
                 data[tmp]["owners"],
                 data[tmp]["owners_variance"],
                 data[tmp]["players_forever"],
                 data[tmp]["players_forever_variance"],
                 data[tmp]["players_2weeks"],
                 data[tmp]["players_2weeks_variance"],
                 data[tmp]["average_forever"],
                 data[tmp]["average_2weeks"],
                 data[tmp]["median_forever"],
                 data[tmp]["median_2weeks"],
                 data[tmp]["price"]
                ])
f.close()

Format to Tableau

First,

let's have a basic view of the datasets.

Players last 2 week

Top 3 Games- Player in time sequence

Here comes some questions

Why this increase so rapidly?
How comes it dropped down since January 2018?
Why this game can become the most popular game in Steam, and break Dota2 and CS’s records?