SQL – NULL-safe equals operator
<=> is the NULL-safe equals operator SELECT * FROM reports WHERE NOT driver <=> user_id
<=> is the NULL-safe equals operator SELECT * FROM reports WHERE NOT driver <=> user_id
In my article My personal road map for learning data science in 2018 I wrote about how I try to tackle the data science knowledge sphere. Due to the fact that 2018 is slowly coming to an end I think it is time for a little wrap up. What are the things I learned about…
When you are working in an agile team e.g. Scrum you might have heard about the agile manifesto. Formulated in 2001 it influenced a lot of software developers and methodologies like Scrum. The Agile Manifesto consists of 4 values and 12 principles: Values Principles Our highest priority is to satisfy the customer through early and…
Big Data is a buzz word nowadays. But when is data “big data”?
In Regular Expressions Demystified I developed a little python package and distributed it via PyPi. I wanted to publish my second self-written package as well, but coming back after almost a year, some things have changed in the world of PyPi, i.e. the old tutorials aren’t working anymore. So I wrote this article to bring…
Overview matplotlib is the workhorse of data science visualization. The module pyplot gives us MATLAB like plots. You can install it via pip install matplotlib The most basic plot is done with the “plot”-function. It looks like this: import matplotlib.pyplot as plt plt.plot([0, 1, 2, 3], [0, 1, 2, 3]) plt.show() The plot function takes…
When you area already familiar with the basic plot from the introduction to matplotlib here is another type of plot used in data science. A very basic visualization is the scatter plot: import numpy as np import matplotlib.pyplot as plt N = 100 x = np.random.rand(N) y = np.random.rand(N) plt.scatter(x, y) plt.show() Color of the…
What is Feature Scaling? Feature Scaling is an important pre-processing step for some machine learning algorithms. Imagine you have three friends of whom you know the individual weight and height. You would like to deduce Christian’s t-shirt size from David’s and Julia’s by looking at the height and weight. Name Height in m Weight in…
When You are working with different operating systems you encounter different line endings. Editing a file on a Linux system and opening it on a windows machine can give a weird result. Here is a short overview which system uses which command characters: OS Command character Windows CR + LF Linux LF Mac OS <=…
ROC Curve As we already introduced Precision and Recall the ROC curve is another way of looking at the quality of classification algorithms. ROC stands for Receiver Operating Characteristic The ROC curve is created by plotting the true positive rate (TPR) on the y-axis against the false positive rate (FPR) on the x-axis at various…