Repository navigation
Expand file tree
/
Copy pathindex.html
More file actions
executable file
·244 lines (189 loc) · 13.7 KB
/
Copy pathindex.html
File metadata and controls
executable file
·244 lines (189 loc) · 13.7 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="author" content="Nik Davis">
<meta name="description" content="">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Home | Nik Davis</title>
<link rel="shortcut icon" href="/favicon.ico">
<link rel="alternate" type="application/atom+xml" title="Nik Davis blog atom feed" href="/feeds/all.atom.xml" />
<link rel='stylesheet' href='https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,700'>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
<link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.7.0/css/all.css" integrity="sha384-lZN37f5QGtY3VHgisS14W3ExzMWZxybE1SJSEsQp9S+oqd12jhcu+A56Ebc1zFSJ" crossorigin="anonymous">
<link rel="stylesheet" href="/theme/css/style.css"/>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.0/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"></script>
</head>
<body>
<nav class="navbar navbar-expand-md navbar-dark">
<a class="navbar-brand" href="/" title="Home">Nik Davis</a>
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#collapsibleNavbar">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="collapsibleNavbar">
<ul class="navbar-nav ml-md-auto">
<li class="nav-item">
<a class="nav-link social" href="http://github.com/nik-davis" rel="me" target="_blank"><i class="fab fa-github"></i></a>
</li>
<li class="nav-item">
<a class="nav-link social" href="http://twitter.com/nikdavis0" rel="me" target="_blank"><i class="fab fa-twitter"></i></a>
</li> <li class="nav-item">
<a class="nav-link social" href="https://www.linkedin.com/in/nik-davis" rel="me" target="_blank"><i class="fab fa-linkedin-in"></i></a>
</li>
<li class="nav-item">
<a class="nav-link social" href="https://stackoverflow.com/users/10202890/nik-davis" rel="me" target="_blank"><i class="fab fa-stack-overflow"></i></a>
</li>
<li class="nav-item">
<a class="nav-link" href="/pages/about.html" title="About">About</a>
</li>
<li class="nav-item">
<a class="nav-link" href="/archives.html" title="Archive">Archive</a>
</li>
</ul>
</div>
</nav>
<div id="wrap">
<div class="container index">
<article>
<header>
<h2><a href="https://nik-davis.github.io/posts/2019/steam-data-exploration/">Steam Data Exploration in Python</a></h2>
<time datetime="" title="2019-08-22T00:00:00+01:00" pubdate>Thu 22 August 2019</time>
</header>
<div class="article_content">
<p><a href="http://nik-davis.github.io/tag/steam">In the previous posts in this series</a> we successfully downloaded and cleaned a whole dataset from Steam and Steamspy. Today we're going to be diving into that dataset, getting to grips with it, and trying to get a sense of the gaming industry as a whole. We'll try to focus on questions like 'What makes a game great?' and 'What do the most popular games look like?'. Our answers will relate specifically to the Steam environment, but hopefully we'll be able to uncover some interesting insights that we can relate to the wider video game industry.</p>
<p class="source" style="text-align: center">
<img src="https://nik-davis.github.io/images/steam_game_industry_revenues.jpg">
Global revenues of the video game industry from 1971 to 2018, not adjusted for inflation. Source: <a href=https://en.wikipedia.org/wiki/Video_game_industry#Economics>Wikipedia</a>
</p><p>Comparable in size to the film and music industry in the UK, and generating more than double the revenue of the film industry internationally, the video game industry is huge. Knowing how to navigate this landscape would be invaluable, so let's begin that process. In this post we'll be exploring the data, trying to make sense of it through visualisations in a process commonly referred to as <a href="https://en.wikipedia.org/wiki/Exploratory_data_analysis">Exploratory Data Analysis</a> (EDA).</p>
</div>
<div class="meta">
<div>
<a class="btn btn-purple" href="https://nik-davis.github.io/posts/2019/steam-data-exploration/">Read more</a>
</div>
<div>
<a class="tag" href="https://nik-davis.github.io/tag/steam.html">steam</a>
<a class="tag" href="https://nik-davis.github.io/tag/jupyter.html">jupyter</a>
<a class="tag" href="https://nik-davis.github.io/tag/python.html">python</a>
<a class="tag" href="https://nik-davis.github.io/tag/data.html">data</a>
<a class="tag" href="https://nik-davis.github.io/tag/visualisation.html">visualisation</a>
<a class="tag" href="https://nik-davis.github.io/tag/eda.html">eda</a>
</div>
</div>
</article>
<!-- <div class="separator"></div> -->
<hr>
<article>
<header>
<h2><a href="https://nik-davis.github.io/posts/2019/steamspy-data-cleaning/">SteamSpy Data Cleaning in Python</a></h2>
<time datetime="" title="2019-07-19T00:00:00+01:00" pubdate>Fri 19 July 2019</time>
</header>
<div class="article_content">
<p>Welcome to the final part of the data cleaning process. Once we're finished here we'll be ready to move on to exploring and analysing the data.</p>
<p>As a quick re-cap, so far we have downloaded information on games from the Steam Store via the Steam API and SteamSpy API. We have cleaned and processed the data from the Steam API, and in this section we'll walkthrough cleaning data downloaded from the SteamSpy API. The overall goal of this project is to collect, clean and analyse data from the Steam Store with the idea of advising a fictional game developer or company.</p>
<p>The previous posts went into great depth about the decisions made and methods used. This post will still go over a number of decisions, but will be more in the style of a brief overview than full discussion.</p>
</div>
<div class="meta">
<div>
<a class="btn btn-purple" href="https://nik-davis.github.io/posts/2019/steamspy-data-cleaning/">Read more</a>
</div>
<div>
<a class="tag" href="https://nik-davis.github.io/tag/steam.html">steam</a>
<a class="tag" href="https://nik-davis.github.io/tag/jupyter.html">jupyter</a>
<a class="tag" href="https://nik-davis.github.io/tag/python.html">python</a>
<a class="tag" href="https://nik-davis.github.io/tag/data.html">data</a>
<a class="tag" href="https://nik-davis.github.io/tag/cleaning.html">cleaning</a>
</div>
</div>
</article>
<!-- <div class="separator"></div> -->
<hr>
<article>
<header>
<h2><a href="https://nik-davis.github.io/posts/2019/steam-data-cleaning-optimisation/">Steam Data Cleaning: Code Optimisation in Python</a></h2>
<time datetime="" title="2019-06-12T00:00:00+01:00" pubdate>Wed 12 June 2019</time>
</header>
<div class="article_content">
<p>In my <a href="https://nik-davis.github.io/posts/2019/steam-data-cleaning/">previous post</a>, we took an in-depth look at cleaning data downloaded from the Steam Store. We followed the process from start to finish, omitting just one column, which we will look at today.</p>
<p>The final column to clean, <code>release_date</code>, provides some interesting optimisation and learning challenges. We encountered columns with a similar structure previously, so we can use what we learned there, but now we will also have dates to handle. We're going to approach this problem with the goal of optimisation in mind - we'll start by figuring out how to solve the task, getting to the point of a functional solution, then we'll test parts of the code to see where the major slowdowns are, using this to develop a framework for improving the efficiency of the code. By iteratively testing, rewriting and rerunning sections of code, we can gradually move towards a more efficienct solution.</p>
</div>
<div class="meta">
<div>
<a class="btn btn-purple" href="https://nik-davis.github.io/posts/2019/steam-data-cleaning-optimisation/">Read more</a>
</div>
<div>
<a class="tag" href="https://nik-davis.github.io/tag/steam.html">steam</a>
<a class="tag" href="https://nik-davis.github.io/tag/jupyter.html">jupyter</a>
<a class="tag" href="https://nik-davis.github.io/tag/python.html">python</a>
<a class="tag" href="https://nik-davis.github.io/tag/data.html">data</a>
<a class="tag" href="https://nik-davis.github.io/tag/cleaning.html">cleaning</a>
</div>
</div>
</article>
<!-- <div class="separator"></div> -->
<hr>
<article>
<header>
<h2><a href="https://nik-davis.github.io/posts/2019/steam-data-cleaning/">Steam Data Cleaning in Python</a></h2>
<time datetime="" title="2019-06-11T00:00:00+01:00" pubdate>Tue 11 June 2019</time>
</header>
<div class="article_content">
<p>In the first part of this project, we downloaded and generated data sets from the Steam Store API and SteamSpy API. We now need to take this raw data and prepare it in a process commonly referred to as <a href="https://en.wikipedia.org/wiki/Data_cleansing">data cleaning</a>.</p>
<p>Currently the downloaded data is not in a very useful state. Many of the columns contain lengthy strings or missing values, which hinder analysis and are especially crippling to any machine learning techniques we may wish to implement. Data cleaning involves handling missing values, tidying up values, and ensuring data is neatly and consistently formatted.</p>
</div>
<div class="meta">
<div>
<a class="btn btn-purple" href="https://nik-davis.github.io/posts/2019/steam-data-cleaning/">Read more</a>
</div>
<div>
<a class="tag" href="https://nik-davis.github.io/tag/steam.html">steam</a>
<a class="tag" href="https://nik-davis.github.io/tag/jupyter.html">jupyter</a>
<a class="tag" href="https://nik-davis.github.io/tag/python.html">python</a>
<a class="tag" href="https://nik-davis.github.io/tag/data.html">data</a>
<a class="tag" href="https://nik-davis.github.io/tag/cleaning.html">cleaning</a>
</div>
</div>
</article>
<!-- <div class="separator"></div> -->
<hr>
<article>
<header>
<h2><a href="https://nik-davis.github.io/posts/2019/steam-data-collection/">Gathering Data from the Steam Store API using Python</a></h2>
<time datetime="" title="2019-05-28T00:00:00+01:00" pubdate>Tue 28 May 2019</time>
</header>
<div class="article_content">
<p>The motivation for this project is to download, process and analyse a data set of Steam apps (games) from the Steam store, and gain insights into what makes a game more successful in terms of sales, play-time and ratings. We will imagine that we have been approached by a company hoping to develop and release a new title, using the findings we provide them to inform decisions about how best to manage their budget and hopefully increase the success of their next release.</p>
<p>The first step will be tackling data collection - the actual retrieval of data from Steam's servers and databases. In the future we'll look at cleaning the data, transforming it into a more useful state, then on to data exploration and analysis. Finally we'll summarise our findings in a non-technical report which would be sent to the fictional company in question.</p>
</div>
<div class="meta">
<div>
<a class="btn btn-purple" href="https://nik-davis.github.io/posts/2019/steam-data-collection/">Read more</a>
</div>
<div>
<a class="tag" href="https://nik-davis.github.io/tag/steam.html">steam</a>
<a class="tag" href="https://nik-davis.github.io/tag/jupyter.html">jupyter</a>
<a class="tag" href="https://nik-davis.github.io/tag/python.html">python</a>
<a class="tag" href="https://nik-davis.github.io/tag/data.html">data</a>
</div>
</div>
</article>
<!-- <div class="separator"></div> -->
<hr>
<nav class="pagination">
<ul>
</ul>
</nav>
</div>
</div>
</div>
<!-- <footer>
<p>
© 2012-2017 Nik Davis, license <a href=""> </a>
unless otherwise noted.
Generated by <a href= "http://docs.getpelican.com/">Pelican</a>.
</p>
</footer> -->
</body>
</html>