Introduction In this tutorial, we want to delete all rows from a table by using a SQL Statement. The table itself should remain. In order to do this, we use the TRUNCATE Statement. We have already created the table student with the following data: SQL Statement Now, let's...
Introduction In this tutorial, we want to insert new rows into a table by using a SQL Statement. In order to do this, we use the INSERT Statement. We have already created the table student. As you can see, the table is empty. SQL Statement Now, let's insert...
Introduction In this tutorial, we want to modify an existing table by using a SQL Statement. In order to do this, we use the ALTER TABLE Statement. We have already created a table called student. The table has the following columns: Example 1 - ADD COLUMN We want to add...
Introduction In this tutorial, we want to sort a Pandas DataFrame by specific columns. In order to do this, we use the sort_values() method of Pandas. Import Libraries First, we import the following python modules: import numpy as np import pandas as pd Create Pandas DataFrame Next, we create...
Introduction In this tutorial, we want to create a table by using a SQL Statement. In order to do this, we use the CREATE TABLE Statement. We have already created a server called DLNerdsServer and a database called dlnerdsacademy. Now, we want to create a table called student. SQL Statement...
Introduction In this tutorial, we want to delete an existing database by using a SQL Statement. In order to do this, we use the DROP DATABASE Statement. We have already created a server called DLNerdsServer and a database called dlnerdsacademy. Now, we want to delete the database dlnerdsacademy. SQL Statement...
Introduction In this tutorial, we want to drop columns from a Pandas DataFrame. In order to do this, we use the the drop() 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...
Introduction In this tutorial, we want to add columns to a Pandas DataFrame. In order to do this, we use square brackets [] with the name of the new column. Import Libraries First, we import the following python modules: import numpy as np import pandas as pd Create Pandas DataFrame Next,...
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...
