Tips to identify unreferenced values across your tables with Python — If you have worked with relational databases, you must know SQL joins — they have many use cases, but in this post, I am going to focus on data cleaning. When performing left, right, or full outer joins, you create tables where either all records are present or just records…

Mice, and pests, in general, are indeed a big problem in some cities around the world. If you live in your own property, you have the power to act, while you rent, things can get a bit more complicated. …

Some notes from Mass-paranoia (2018) by Peter Kreko — Originally I wrote this post in 2018… Kreko’s recent and timely book is all about conspiracy theories and fake news, exploring how they work, why people believe in them, and how to overcome them. It is indeed a topical issue as…

My general experience with programming is that you learn new skills and techniques on the job, which can be often painful as one can easily spend hours figuring out stuff or browsing tutorials… For an application that I am developing, I wanted a simple, pure CSS toggle switch with the…

If you manage any social media channels, especially if it’s not your personal but your employer’s official account, sometimes, you might struggle to come up with new content. That’s totally normal, it can be really demanding to publish engaging stuff on a daily basis. Towards the end of the year…

As a digital communication professional, data science is not new to me, but I have never systematically learned it, just picked up the necessary skills on the job. So one of my COVID-19 lockdown commitments was to look into data science and machine learning in a bit more structured way…