Recently I decided to start streaming clickstream data (from this blog, indeed) into BigQuery using the insertAll method. It is a relatively cheap solution that requires almost no technical configuration. Until I bumped into an error. Let’s tackle it in this blog post. The error I encountered is: “google.api_core.exceptions.BadRequest: 400…
Pandas can be somewhat puzzling, sometimes. It has a ton load of functionalities, but that can make the syntax and methods obscure. Simply judging from the method name, the ‘join’ and ‘merge’ method could be the same thing. However, they aren’t. Here’s an error that I used to run into…
In this blog post we discover how you can replace empty fields in tables with a zero. As you will see below, this is very straightforward. You can see in this table that some values are empty, that is because there is no corresponding value if that metric for a…
Your first steps in setting up Cloud Build for deploying Google Cloud Functions but running into yet another error? You’re not alone. With this blog post, I hope to put you on your way again. Have you run into the following error? “Permission ‘cloudfunctions.functions.get’ denied on resource […]” Here’s what’s…
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 would like to tackle a recurring phenomenon that I always solved via trial-and-error, depending on the machine I was working on. I think it’s time to get a conclusive answer to the single/double quote problem that occurs with cURL in de Windows Command Prompt. The…
I’ve spent hours trying to find an elegant solution for this problem, and I’m ashamed about how easy it eventually was. I had a column with comma-separated values that I wanted to create features from. Each value should represent one feature. I got started with building loops over the values…
Surprisingly, the Pandas error “columns overlap but no suffix specified”, is one I ran into surprisingly late. Solving it is usually very straightforward. We’ll tackle it in this blog post. First, let’s take a closer look at the error: “ValueError: columns overlap but no suffix specified: Index([<list of columns>], dtype=’object’)”…
I don’t think there is a project I have been wanting to do as long as this one. Although there was a pandemic and accompanying lockdown this year, I still haven’t had the time to tackle this one — became a dad and all. But I had the weekend for…
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…