Introduction In this tutorial, we want to select specific columns from a Pandas DataFrame. In order to do this, we use square brackets [], the loc() method and the iloc() method of Pandas. Import Libraries First, we import the following python modules: import pandas as pd Create Pandas DataFrame Next, we...
Introduction In this tutorial, we want to rename a Pandas DataFrame column. In order to do this, we use the the rename() method of Pandas. Import Libraries First, we import the following python modules: import pandas as pd Create Pandas DataFrame Next, we create a Pandas DataFrame with some example...
Introduction In this tutorial, we want to create a Pandas DataFrame. In order to do this, we use the DataFrame() class of Pandas in different ways. Import Libraries First, we import the following python modules: import numpy as np import pandas as pd Create DataFrame from Dictionary Now, we create...
Introduction In this tutorial, we want to create a database by using a SQL Statement. In order to do this, we use the CREATE DATABASE Statement. We have already created a server called DLNerdsServer. The database should be called dlnerdsacademy. SQL Statement We navigate to the default database of the...
Introduction In this turorial, you will learn how to create a database with the pgAdmin interface. Create Database We have already created a server called DLNerdsServer. In order to create a database, we right-click on the databases node and select Create>Database. Set properties Now, we can set certain...
Introduction In this tutorial, we want to create a PySpark DataFrame with a specific schema. In order to do this, we use the the createDataFrame() function of PySpark. Import Libraries First, we import the following python modules: from pyspark.sql import SparkSession from pyspark.sql.types import StructType, StructField,...
Introduction In this tutorial, we want to create a PySpark DataFrame. In order to do this, we use the the createDataFrame() function of PySpark. Import Libraries First, we import the following python modules: from pyspark.sql import SparkSession Create SparkSession Before we can work with Pyspark, we need to...
Introduction In this turorial, you will learn how to create a server with the pgAdmin interface. Register Server First, we right-click on the servers node and select Register > Server. General Configuration Next, we enter a name for the server. We choose DLNerdsServer as the name for the server. We...
Introduction In this tutorial, we want to import Data from a Postgres Database into Power BI. This can be easily done in the Power BI Desktop interface. Data Source We have already created a Postgres server called DLNerdsServer and a database called dlnerdsacademy. In this database we have created the...
