Merging a data.table in R is more or less the same as merging a regular data.frame. However, there is one difference. There’s also is a shorthand way to merge two tables that feels more data.table-esque. In this blog post I elaborate on merging tables using R’s data.table library. If you’re…
The title of this blog post says it all: let’s solve a warning. It’s one that occurs when you’re using Pandas’ read_csv. Let’s start by just doing that. Let’s say you run into the following error: Solve DtypeWarning: Columns (X,X) have mixed types. Specify dtype option on import or set…
I was curious how many ways there are to calculate the mode of a 1-D numpy array in Python. Apparently, quite a lot. Although all roads lead to Rome, some will take you there faster. That goes for many things in computer science: also for this seemingly trivial question. Let’s…
As an R-native, switching to Python and Pandas has its little annoyances. In R, when you print a data frame, or its head, you get to see the whole shebang. In Pandas, this is not the case: rows and columns get truncated to keep the output manageable. However, there are…
In my personal quest to compare business intelligence tools, I stumbled upon Infogram. It wasn’t immediately clear to me what I could expect, but after a couple of minutes messing around in the free version, I could come up with enough use cases to write a recommendation in a blog…
I’m a huge fan of Google Cloud Platform because of its intuitive interface and the extremely precise documentation that Google has published regarding its cloud tools. However, there was one error that lost me half an hour of my life when trying to upload a CSV to a PostgreSQL database.…
In my early days as an analyst, adding regression line equations and R² to my plots in Microsoft Excel was a good way to make an impression on the management. Because maths. In R, it is a little harder to achieve. There are two main ways to achieve it: manually,…
In times of covid-19, logarithmic scale is everywhere. A phenomenon such as an epidemic grows exponentially. If we want to visualize an exponentially growing phenomenon, a logarithmic scale is often a good idea. In this blog post I explain how you can do it in cumul.io. To be blunt, there’s…
Being a little bit bored with the default visualization tools in R and Python, I decided to look into the available visualization tools that are out there in the data ecosystem. The Belgian visualization tool cumul.io focusses on integration in platforms, but it also seems like a solid entry-level visualization…
Why do people put data in a list in the first place? Because it can be really darn handy. In this blog post I elaborate on some good use cases for putting data frames in a list. Loading a lot of files In many situations you will be confronted with…