Last year, I wrote a blog post about bootstrapping (two-sample) the mean in R. Recently, someone contacted me with the question of how to get the corresponding percentile for a specific value of those bootstrapped differences. It’s something you need to answer the question if the difference is statistically significant…
In this blog post, I elaborate on the functionalities of Mode Analytics, a tool that I love because of its flexibility. Mode was founded in 2013 and, this summer, raised 33 million in its Series D. Time to find out what it can do. Many BI platforms have static database…
A classic in B2B marketing: an end-to-end funnel that gives a complete overview of the cost-per-acquisition or even the return-on-investment. Given the fact that Salesforce is one of the most popular CRMs in the world, creating an end-to-end funnel analysis might require you to interact with Salesforce. Let’s do it…
Google Spreadsheets and R: a dynamic duo! An annoying feature in googlesheets4’s read_sheet(), is that within a column, it assigns a type to each cell individually when it is confused. However, this makes perfect sense. Sometimes, a column contains a mix of values that could be integers and values that…
Warning: this blog post touches on a rather technical subject and is not aimed towards beginners. If you ever built a web scraping script, in R, or any other programming languagen, you know how long it can take to scrape a sizeable amount of web pages. The same goes for…
This is something I bumped into early in my pursuit to become a data scientist, during my Coursera course, somewhere in 2017. I don’t know how I fixed it back then, but it is an issue I will always remember because it took my hours to solve it. In this…
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…
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…
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…