As a Data Analyst, I analyze and visualize data in order to answer business questions and to enable data-driven decision making.
Introduction In this tutorial, we want to create a Heatmap. In order to do this, we use the heatmap() function of Seaborn. Import Libraries First, we import the following python modules: import matplotlib.pyplot as plt import seaborn as sns import numpy as np Define Data Let's define...
Introduction In this tutorial, we want to calculcate the sum of values of a specific column. In order to do this, we use the SUM function. We have already created the table student with the following data: Example 1 We want to calculcate the sum of credit points of all...
Introduction In this tutorial, we want to count the number of unique values of a specific column. In order to do this, we use the COUNT function with the DISTINCT keyword. We have already created the table student with the following data: Example 1 We want to count the number...
Introduction In this tutorial, we want to count the number of values of a specific column. In order to do this, we use the COUNT function. We have already created the table student with the following data: Example 1 We want to count the total number of students. In order...
Introduction In this tutorial, we want to select data from a table that satisfy a certain condition. In order to do this, we use the SELECT Statement with the WHERE Clause. We have already created the table student with the following data: Example 1 We want to select all columns...
Introduction In this tutorial, we want to select data from a table and sort the result set. In order to do this, we use the SELECT Statement with the ORDER BY Clause. We have already created the table student with the following data: Example 1 - Sort rows in ascending...
Introduction In this tutorial, we want to select a specific number of rows from a table by using a SQL Statement. In order to do this, we use the SELECT Statement with the LIMIT Clause. We have already created the table student with the following data: SQL Statement We want...
Introduction In this tutorial, we want to select data from a table by using a SQL Statement. The result should not contain duplicate rows. In order to do this, we use the SELECT Statement with the DISTINCT Clause. We have already created the table student with the following data: Example...
Introduction In this tutorial, we want to select data from a table by using a SQL Statement. In order to do this, we use the SELECT Statement. We have already created the table student with the following data: Example 1 - SELECT specific columns We want to select the columns...