Blog

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...

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...

Top 6 tips to land your first job in data science

10/07/2020

Because of the rapid development of the field and the promising opportunities in the future, many people are interested in entering the world of data science right now. if you have no experience in the field or you are transitioning from a different background, finding your first job in the field of data science can be a daunting task, especially as competition is increasing. This blog gives you six tips to increase your chances of landing...

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...

9 Tipps zur Verbesserung Ihres Data Science Lebenslaufs

11/04/2020

Der erste Schritt, um eine Stelle als Data Scientist zu bekommen, ist derselbe wie in jedem anderen Beruf: Erstellen Sie einen überzeugenden Lebenslauf! Obwohl es im Bereich der Data Science mehr offene Stellen gibt als je zuvor , ist es wichtig, einen aussagekräftigen und passenden Lebenslauf zu haben, um den gewünschten Job zu bekommen. Dieser Blog gibt Ihnen neun Tipps, um Ihre Chancen zu verbessern, die von Ihnen gewünschte Stelle im...

9 tips to improve your data science resume

11/04/2020

The first step to land a job as a data scientist is the same as in any other profession: create a compelling CV! Although there are more open positions in the field of data science than ever before it is important to have a strong and suitable CV in order to land the job you want. This post gives you nine tips in order to improve your chances to find the data science job you want. 1. Include achievements, not just jobs “I increased...

COVID-19 Dataset Challenge

30/03/2020

Use your extra time at home (and your data skills) for a good cause: Check out the Kaggle COVID-19 Open Research Dataset Challenge. In response to the COVID-19 pandemic, the White House and a coalition of leading research groups have prepared the COVID-19 Open Research Dataset (CORD-19). This dataset is a resource of over 29,000 scholarly articles, including over 13,000 with full text, about COVID-19, SARS-CoV-2, and related...

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...

Nova-DB: Swiss Local Data API

10/10/2019

Accessing datasets in a structured form through an API can often simplify the life of a data analyst - especially if the same data series are used repeatedly. Unfortunately, many public data sources such as the Federal Statistical Office (BFS) do not provide data access through an API ( STAT-TAB makes life a bit easier, but is not fully automated). While opendata.swiss offers a great way to explore available public datasets....

Building a simple sentiment classifier in R using Trump's tweets

12/08/2019

For the past few years, tasks involving text and speech processing have become really hot-trendy. Among the various researches belonging to the fields of Natural Language Processing and Machine Learning, sentiment analysis ranks really high. Sentiment analysis allows identifying and getting subjective information from the source data using data analysis and visualization, ML models for classification, text mining and analysis. This helps to...

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...

Sentiment Analysis of Trump Tweets in Python

09/07/2019

The way other people think about one or another product or service has a big impact on our everyday process of making decisions. Earlier, people relied on the opinion of their friends, relatives, or products and services reposts, but the era of the Internet has made significant changes. Today opinions are collected from different people around the world via reviewing e-commerce sites as well as blogs and social nets. To transform gathered...

Blog Categories