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…
LEFT() and RIGHT() are probably the most used string functions within Microsoft Excel (or other spreadsheet software). Many people who make the transition to R wonder where to find these functions. Short story: they’re not available out-of-the-box. However, why not create them yourself or find a library that suits your…
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…
In this blog post, I elaborate on running an R kernel within a Google Colab notebook and I demonstrate a range of basic functionalities. In the FAQ of Google Colab, you can read that, for now, Google does not support kernels other than Python 3. Although they would like to,…
