Apparently, this is something that many (even experienced) data scientists still google. Sometimes you’re dealing with a comma-separated value file that has no header. In this blog post I explain how to deal with this when you’re loading these files with pandas in Python. The read_csv function in pandas is…
It’s an operation I use quite a lot, but I never took the time to find out which solution is fastest. That’s why I decided to dedicate this blog post on how to concatenate columns in pandas (Python) and their execution speed. I’ve been working with the “donors” dataset from…
In this blog post, I tackle a question that you recurringly see on a lot of boards. We are going to calculate the cumulative sum, but within a group that the rows belong to. Thanks to vegetableagony for pointing out that, depending on the size of the dataset, other conclusions…
For a personal project, to check how many pictures we took of our cats over the past seven years, I wanted to read EXIF data from my photos. In this blog post I explain how to do it. As you might have guessed, this is not a functionality that’s built…
On my list of things that frustrate me when using notebooks is the fact that you do not see the output of every expression of a cell by default. For example, during an exploratory analysis phase, I want to see the result of two pandas operations or function within the…
When I first started using notebooks, one of the letdowns was that I wasn’t able to navigate upwards out of the installation folder. I save all my projects on an extra internal hard disk drive, both for safety and portability. It’s also never a bad idea to have an additional…
Plotting bars in ggplot2 is easy. Yet, in many cases, you want to order these bars according to their frequency (count) or according to any other numeric value. In this blog post, I show you three ways to achieve this. First, let’s load the libraries and create the titanic data…
Django has become my favorite web development framework. It’s Python-based and in a couple of minutes you can deploy your first app. A problem I ran into when building my first apps was that I seemingly had to create a subfolder to start a new project. To create a new…
Zoho Analytics is created by Indian-based Zoho, which generated some estimated 500 million in revenue in 2019. Using Zoho Analytics provides the largest synergies when your company uses other products from the Zoho product suite (such as Zoho CRM or SalesIQ). However, Zoho Analytics’ target audience clearly goes beyond its…
You might have noticed that the startup speed of RStudio varies. But how can you fix RStudio when its loading time is really, really long? In this blog post I elaborate on the problem and how you can solve it. Everytime you close RStudio while working on your projects, RStudio…