Blog

Blog Categories

All Blog Posts AI API Big Data Big data jobs Business Intelligence Career Data Analyst Data Engineer data science DevOps Google Trends Image recognition Job Market Index Machine Learning Python Qualtrics R Salary Security Society Software skills
Making binary annotations less boring
14/08/2021
Introduction For a university project, I’m developing a Music recommendation classifier based on the Spotify API.  The idea is to recommend new music to the user, based on songs he personally likes or dislikes and on the musical components of the song (speed, tonality, instrumentality and many more). The preparation of the dataset usually is the most time-consuming part of any machine learning project. This usually consists of gathering...
Read more
Improve your Psycopg2 executions for PostgreSQL in Python
25/05/2020
I’m sure everybody who worked with Python and a PostgreSQL database is familiar or definitely heard about the psycopg2 library. It is the most popular PostgreSQL database adapter for the Python programming language. In my work, I come in contact with this library every day and execute hundreds of automated statements. As always, I try to improve my code and execution speed, because, in the cloud, time is money. The longer your code runs the...
Read more
Using Azure Functions with Python
10/05/2020
Overview Lately, I worked a lot with the Azure Cloud. Overall I have to say Azure offers a lot but is still not on the same level as its hardest competitors (AWS, Google). One thing that caught my eye is the compatibility of certain programming languages. Azure supports a few different languages (C#, JavaScript, Java, Python, etc.) but the supported features for these languages differ a lot. I think Azure Cloud is really great for...
Read more
Data Science & Analytics Job Market in Switzerland in 2019
26/11/2019
Today, data science specialists are among the most sought-after in the labor market. Being able to find significant insights in a huge amount of information, they help companies and organizations to optimize the structure's work.  The field of data science is rapidly developing and the demand for talent is changing. We use job offerings to analyze the current demand for talent. After performing a  first analysis in 2017 , this article...
Read more
Connecting PostgreSQL to your script (Python)
08/07/2019
Introduction Nowadays PostgreSQL is probably one of the most powerful relational databases among the open-source solutions. Its functional capacities are no worse than Oracle’s and definitely way ahead of the MySQL. So if you are working on apps using Python, someday you will face the need of working with databases. Luckily, Python has quite a wide amount of packages that provide an easy way of connecting and using databases. In this...
Read more
Connect to PostgreSQL with R: A step-by-step example
07/06/2019
Among the variety of open source relational databases, PostgreSQL is probably one of the most popular due to its functional capacities. That is why it is frequently used among all the areas of work where databases are involved. In this article, we will go through connection and usage of PostgreSQL in R. R is an open source language for statistical and graphics data analysis providing scientists, statisticians, and academics powerful tools...
Read more
Data Engineer Salaries in Europe in 2018
12/07/2018
With the rise of the amount of data stored in servers, the demand has also risen for data engineers to help manage the vasts amount of data now available to us. Data Engineers are in high demand, and Google trends have shown that the global volume of the search term “Data Engineer” has tripled since 2014. More and more people are seeking skilled data engineers to help manage the vasts amount of data stored across the globe, and we collected...
Read more