Learn Deleting a Row/Column | The Very First Steps

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.

drop(index, columns, axis)

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 start coding

You are given a DataFrame named audi_cars.

Remove the 'capital' column and save the resulting DataFrame in the audi_cars variable.

Solution

Everything was clear?

Thanks for your feedback!

Section 1. Chapter 9

single

Ask AI

Ask anything or try one of the suggested questions to begin our chat

Swipe to show menu

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.

drop(index, columns, axis)

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 start coding

You are given a DataFrame named audi_cars.

Remove the 'capital' column and save the resulting DataFrame in the audi_cars variable.

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

single

Deleting a Row/Column

Solution

Awesome!

Deleting a Row/Column

Solution

Awesome!