<p><div><div><div><div data-show-faces="false" data-height="21" data-width="100" data-layout="button_count" data-send="true" data-href="https://www.r-bloggers.com/the-year-of-the-gnulinux-desktop-is-upon-us-using-user-ratings-of-steam-play-compatibility-to-play-around-with-regex-and-the-tidyverse/"></div></div><div></div></div><div></div></div>
<div>
(This article was first published on <strong><a href="http://www.brodrigues.co/blog/2018-09-08-steam_linux/"> Econometrics and Free Software</a></strong>, and kindly contributed to <a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers)</a> </div>
<div>
<p><a rel="nofollow" href="https://www.youtube.com/watch?v=4QokOwvPxrE" target="_blank"><br>
<img src="https://i0.wp.com/www.brodrigues.co/blog/2018-09-08-steam_linux/img/want_to_believe.jpg?w=456" data-recalc-dims="1"></a></p>
</div>
<p>I’ve been using GNU+Linux distros for about 10 years now, and have settled for openSUSE as my main operating system around 3 years ago, perhaps even more. If you’re a gamer, you might have heard about SteamOS<br>
and how more and more games are available on GNU+Linux. I don’t really care about<br>
games, I play the occasional one (currently <a rel="nofollow" href="http://www.tangledeep.com/" target="_blank">Tangledeep</a>) when I find<br>
the time, but still follow the news about gaming on GNU+Linux. Last week,<br>
Valve announced something quite big; it is now possible to run Windows games on GNU+Linux directly<br>
from Steam, using a modified version of <a rel="nofollow" href="https://en.wikipedia.org/wiki/Wine_(software)" target="_blank">Wine</a><br>
they call Proton. The feature is still in Beta, and Valve announced that they guarantee around<br>
30 games to work already flawlessly. Of course, people have tried running a lot of other games, and,<br>
as was to be expected from Free Software and Open Source fans, GNU+Linux gamers created a Google Sheet<br>
that lists which games were tried and how they run. You can take a look at the sheet <a rel="nofollow" href="https://docs.google.com/spreadsheets/d/1DcZZQ4HL_Ol969UbXJmFG8TzOHNnHoj8Q1f8DIFe8-8/htmlview?sle=true&pru=AAABZbqTTkc*IvT11ShwA2kjoe_4lPefiQ#gid=1003113831" target="_blank">here</a>.</p>
<p>In this blog post, I will play around with this sheet. This blog post lists some <code>{tidyverse}</code> tricks<br>
I find useful and use often. Perhaps these tricks will be useful to you too! Let’s start by loading<br>
the needed packages:</p>
<pre><code>library(tidyverse)
library(magrittr)
library(readxl)</code></pre>
<p>Since I’m lazy and don’t want to type the whole name of the file I’ll be using some little regex:</p>
<pre><code>steam &lt;- read_excel(Sys.glob(&quot;Steam*&quot;), sheet = &quot;Main&quot;, skip = 2)

glimpse(steam)</code></pre>
<pre><code>## Observations: 8,570
## Variables: 9
## $ SteamDB   </code></pre>