Publications by Econometrics and Free Software
Dealing with heteroskedasticity; regression with robust standard errors using R
First of all, is it heteroskedasticity or heteroscedasticity? According to McCulloch (1985), heteroskedasticity is the proper spelling, because when transliterating Greek words, scientists use the Latin letter k in place of the Greek letter κ (kappa). κ sometimes is transliterated as the Latin letter c, but only when these words entered the Eng...
5619 sym R (12863 sym/21 pcs) 6 img
The year of the GNU+Linux desktop is upon us: using user ratings of Steam Play compatibility to play around with regex and the tidyverse
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 and how more and more games are available on GNU+Linux. I don’t really care about games, I play the occasional one (currently Tangled...
3577 sym R (7919 sym/17 pcs) 2 img
Going from a human readable Excel file to a machine-readable csv with {tidyxl}
I won’t write a very long introduction; we all know that Excel is ubiquitous in business, and that it has a lot of very nice features, especially for business practitioners that do not know any programming. However, when people use Excel for purposes it was not designed for, it can be a hassle. Often, people use Excel as a reporting tool, which...
6087 sym R (3362 sym/10 pcs) 6 img
How Luxembourguish residents spend their time: a small {flexdashboard} demo using the Time use survey data
In a previous blog post I have showed how you could use the {tidyxl} package to go from a human readable Excel Workbook to a tidy data set (or flat file, as they are also called). Some people then contributed their solutions, which is always something I really enjoy when it happens. This way, I also get to learn things! @expersso proposed a solut...
2736 sym R (4460 sym/3 pcs) 2 img
Exporting editable plots from R to Excel: making ggplot2 purrr with officer
I was recently confronted to the following problem: creating hundreds of plots that could still be edited by our client. What this meant was that I needed to export the graphs in Excel or Powerpoint or some other such tool that was familiar to the client, and not export the plots directly to pdf or png as I would normally do. I still wanted to us...
3174 sym R (3029 sym/10 pcs) 6 img
Getting the data from the Luxembourguish elections out of Excel
In this blog post, similar to a previous blog post I am going to show you how we can go from an Excel workbook that contains data to flat file. I will taking advantage of the structure of the tables inside the Excel sheets by writing a function that extracts the tables and then mapping it to each sheet! Last week, October 14th, Luxembourguish nat...
8203 sym R (10026 sym/22 pcs) 6 img
Maps with pie charts on top of each administrative division: an example with Luxembourg’s elections data
Abstract You can find the data used in this blog post here: https://github.com/b-rodrigues/elections_lux This is a follow up to a previous blog post where I extracted data of the 2018 Luxembourguish elections from Excel Workbooks. Now that I have the data, I will create a map of Luxembourg by commune, with pie charts of the results on top of each...
5686 sym R (12639 sym/30 pcs) 24 img
From webscraping data to releasing it as an R package to share with the world: a full tutorial with data from NetHack
If someone told me a decade ago (back before I'd ever heard the term “roguelike”) what I'd be doing today, I would have trouble believing this…Yet here we are. pic.twitter.com/N6Hh6A4tWl— Josh Ge (@GridSageGames) June 21, 2018 Abstract In this post, I am going to show you how you can scrape tables from a website, and then create a packag...
11972 sym R (6862 sym/34 pcs) 18 img
Analyzing NetHack data, part 1: What kills the players
Abstract In this post, I will analyse the data I scraped and put into an R package, which I called {nethack}. NetHack is a roguelike game; for more context, read my previous blog post. You can install the {nethack} package and play around with the data yourself by installing it from github: devtools::install_github("b-rodrigues/nethack") And to ...
7848 sym R (47358 sym/36 pcs) 28 img
Analyzing NetHack data, part 2: What players kill the most
Link to webscraping the data Link to Analysis, part 1 Introduction This is the third blog post that deals with data from the game NetHack, and oh boy, did a lot of things happen since the last blog post! Here’s a short timeline of the events: I scraped data from alt.org/nethack and made a package with the data available on Github (that packag...
9075 sym R (27598 sym/25 pcs) 20 img