Deleting a Row/Column

At times, certain columns may not provide valuable information, making it advantageous to remove them. The pandas library offers the drop() method for this purpose.

index: specifies the row indexes to be deleted (used when axis=0);
columns: identifies the column names to be deleted (used when axis=1);
axis: choose whether to remove labels from the rows (0) or columns (1). The default is 0.

We'll start by examining the DataFrame:


              1234567
            
import pandas as pd 

countries_data = {'country' : ['Thailand', 'Philippines', 'Monaco', 'Malta', 'Sweden', 'Paraguay', 'Latvia'],
          'continent' : [None, None, 'Europe', None, 'Europe', None, 'Europe'],
          'capital':['Bangkok', 'Manila', 'Monaco', 'Valletta', 'Stockholm', 'Asuncion', 'Riga']}
countries = pd.DataFrame(countries_data)
print(countries)

We notice that the 'continent' column contains numerous missing values, making it less informative. Consequently, we'll remove it.


              12345678
            
import pandas

countries_data = {'country' : ['Thailand', 'Philippines', 'Monaco', 'Malta', 'Sweden', 'Paraguay', 'Latvia'],
          'continent' : [None, None, 'Europe', None, 'Europe', None, 'Europe'],
          'capital':['Bangkok', 'Manila', 'Monaco', 'Valletta', 'Stockholm', 'Asuncion', 'Riga']}
countries = pandas.DataFrame(countries_data)
countries = countries.drop(columns = ['continent'],axis=1)
print(countries)

Task

Swipe to show code editor

We have a DataFrame called audi_cars. Your task is to remove the 'capital' column.

Solution

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 1. Chapter 9

Deleting a Row/Column

At times, certain columns may not provide valuable information, making it advantageous to remove them. The pandas library offers the drop() method for this purpose.

index: specifies the row indexes to be deleted (used when axis=0);
columns: identifies the column names to be deleted (used when axis=1);
axis: choose whether to remove labels from the rows (0) or columns (1). The default is 0.

We'll start by examining the DataFrame:


              1234567
            
import pandas as pd 

countries_data = {'country' : ['Thailand', 'Philippines', 'Monaco', 'Malta', 'Sweden', 'Paraguay', 'Latvia'],
          'continent' : [None, None, 'Europe', None, 'Europe', None, 'Europe'],
          'capital':['Bangkok', 'Manila', 'Monaco', 'Valletta', 'Stockholm', 'Asuncion', 'Riga']}
countries = pd.DataFrame(countries_data)
print(countries)

We notice that the 'continent' column contains numerous missing values, making it less informative. Consequently, we'll remove it.


              12345678
            
import pandas

countries_data = {'country' : ['Thailand', 'Philippines', 'Monaco', 'Malta', 'Sweden', 'Paraguay', 'Latvia'],
          'continent' : [None, None, 'Europe', None, 'Europe', None, 'Europe'],
          'capital':['Bangkok', 'Manila', 'Monaco', 'Valletta', 'Stockholm', 'Asuncion', 'Riga']}
countries = pandas.DataFrame(countries_data)
countries = countries.drop(columns = ['continent'],axis=1)
print(countries)

Task

Swipe to show code editor

We have a DataFrame called audi_cars. Your task is to remove the 'capital' column.

Solution

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 1. Chapter 9

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Pandas First Steps

Deleting a Row/Column

Solution

Deleting a Row/Column

Solution