Nothing more frustrating in a data science project than a library that doesn’t work in your particular Python version. Sometimes, you just need to install a virtual environment with another Python version. First of all, if you are a venv user, I hate to break it to you. There’s no…
JSON or JavaScript Object Notation is a popular file format for storing semi-structured data. Transforming it to a table is not always easy and sometimes downright ridiculous. However, Pandas offers the possibility via the read_json function. If you are not familiar with the orient argument, you might have a hard…
Brief blog post on a silly Python error. I’m still working on my ML project started hypertuning my sklearn pipeline — manually. To set the parameters of my pipeline in every iteration, I had to use set_params. My estimator is called model_pipeline and I needed to set the parameters via…
Escape ’til infinity — removing or replacing backslashes in a string can be burdensome in any programming language, if you’re not familiar what regex library is below the hood. In this post, we’ll remove a backslash from a string in R. Using gsub, there’s two paradigms to choose from. The…
It’s been a while since I worked on a machine learning project from exploratory phase to model development. I bumped into a real newbie error and decided to write it down for my future self, and for you of course. Here’s the code I wrote and I hoped to get…
Lately, I have been messing around with some machine learning training & monitoring tools. Since Comet.ml has been high on my wish list for a couple of months, it was an obvious choice to give it a spin. I really like Comet.ml so expect more blog posts in the future.…
In this blog post, I elaborate on two specific operations you’ll run into when using dates in BigQuery. Subtracting an interval from a data and calculating the difference between two dates. Subtracting a unit Subtracting a specific amount of days, weeks, months, quarters, or years from a date can be…
The future is server-side. The rise of ad blockers and other privacy extensions hasn’t made product analytics implementation easier. On the other hand, good ol’ Google Analytics has gained quite a lot of competition in recent years from vendors like Heap and Mixpanel. A friend of mine asked my opinion…
Fundamental to data modeling is that you need a fact table or a table with a unique key per row. That is no different in GoodData. In this blog post, I tackle a specific error that you might run into if your dataset doesn’t meet the necessary requirements. When I…
Here’s a blog on GoodData. They have a clever way of prepping and loading data from data warehouses. I was under the impression that reading rights would suffice for GoodData to access my BigQuery datasets, but clearly, that wasn’t the case. In GoodData’s Data Integration Console, I got this big…