Short background about me. I am a data scientist by trade and my investment portfolio turned from great (thanks to the 10-year bull market rally) to not-so-great. For the purpose of these blog posts, I am naive and assume that using the tools I use every day in my job…

Short background about me. I am a data scientist by trade and my investment portfolio turned from great (thanks to the 10-year bull market rally) to not-so-great. …

In short, I am a data scientist by trade and my investment portfolio turned from great, thanks to the 10-year bull market rally, to not-so-great. …

Three Bugs and Three Solutions Zipline is an open-source backtesting package for python, used in many quantitative finance and algo trading books over the past few years. It was developed by a crowed-source hedge fund, called Quantopian. The video below is quite dated but still gives a great overview of Zipline’s capabilities and use-cases. …

More or less exactly one year ago, in May 2021, I got together with some data mentors I knew from TechLabs Düsseldorf to found HODS Data Mentoring. The motivation came from our experience at TechLabs’ Digital Shaper Program, where we supported data science students in their projects. We noticed that…

Step-by-step guide with example code to download — Reporting is great. Tools like PowerBI and Tableau make it easy to build interactive reports that can be shared within the organization as self-service data tools. However, the challenge is to get the right data in the right format in an automated way. Big platforms like Amazon and Facebook often…

Modifying and Manipulating Excel Files (Updating a Sales Report) — This tutorial series is for everyone who wants to get started working in python instead of Excel, e.g. for automating tasks or improving speed and scalability. Or for just the curious ones. This blog post series is for you when: you use Excel to combine various sheets or tables (using…

Getting started with dealing with data using pandas — This is part one of a tutorial series for everyone who wants to get started working in python instead of Excel, e.g. for automating tasks or improving speed and scalability. Or for just the curious ones. You’re at the right spot when: you use Excel to combine various sheets or…

The future of work and why we offer free one-to-one mentoring for data students. Dear Reader, if you did not come here directly from our HOSD website or don’t know about us and our mission, I make it short for you: We are a group of Data Professionals that offer…