Blog

Blog Categories

All Blog Posts AI API Big data Big data jobs Business Intelligence Career in big data data analyst data engineer Data jobs Data science data sience DevOps Google Trends Image recognition Job Market Index Machine Learning Python Qualtrics R Salary Security society Software skills
Improve your Psycopg2 executions for PostgreSQL in Python
01/07/2022
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
Making binary annotations less boring
31/07/2020
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
Using Azure Functions with Python
08/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
Connecting PostgreSQL to your script (Python)
29/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
Data Science Software: We screened 28,000 data job ads. Here is the software you need to know.
04/09/2017
Much has been written on the most popular software and programming languages for Data Science (recall, for instance, the infamous “Python vs R battle”). We approached this question by scraping job ads from Indeed and counting the frequency at which each software is mentioned as a measure of current employer demand. In a recent blog post , we analyzed the Data Science software Swiss employers want job applicants to know (showing that Python...
Read more
Here's the data science software Swiss employers want you to know
22/06/2017
Learning new programming languages is an investment in human capital. Figuring out the return on investment can thus be very informative. There are very specific requirements for each industry and specific job, and finding a generalizable answer to the question proves quite difficult. One approach is to analyze the required software skills in job postings, which reflect current demand and may therefore indicate general return on investment....
Read more
How to measure employer demand of data science software
01/06/2017
One approach to estimate and track employer demand of data science software is to analyze which skills are asked for in job ads. We did this using job ads on Indeed and showed which data science software skills are most in-demand in Switzerland and worldwide .  In this post, we describe the methods these analyses are based on. We worked with R, as it offers convenient packages facilitating the task.    Searching for jobs on Indeed...
Read more